lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts. Sortable columns (indexed): client_name, issue_code, filing_year, filing_uuid. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

5 rows where filing_uuid = "d2841ccf-52f7-4326-9eca-82383d58c59d" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

issue_code 5

filing_year 1

filing_period 1

id filing_uuid filing_type registrant_name registrant_id client_name filing_year ▲ filing_period issue_code specific_issues government_entities is_no_activity is_termination received_date
1301483 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS d2841ccf-52f7-4326-9eca-82383d58c59d Q3 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 400531588 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 2012 third_quarter BAN H.R. 1697 (and S. 1600) - Communities First Act (Community bank regulatory and tax relief) (all sections) (House and Senate) H.R. 1418 (and S. 509 renumbered in the Senate to S. 2231) - Small Business Lending Enhancement Act of 2011 (Expansion of credit unions member business lending powers) (all sections) (House and Senate) H.R. 3993 Capital Access for Small Business and Jobs Act (Credit union access to outside capital) (all sections) (House and Senate) H.R. 3461 (and S. 2160) Financial Institutions Examination Fairness Act (To improve the examination of depository institutions) (all sections) (House and Senate) H.R. 4367 (and S. 3204) ATM fee disclosure legislation to eliminate the duplicative disclosure notices on the exterior of ATM machines (House and Senate) Five-year extension of the Transaction Account Guarantee (TAG) program (House and Senate) Interest penalties for violations of reporting requirements regarding the Small Business Lending Fund (SBLF) (House and Senate and Treasury/SBLF) Comment Letter regarding Basel III - Proposed Rulemaking on Minimum Regulatory Capital and the Standardized Approach for Risk-weighted Assets extension of comment period. Federal Reserve Docket No. R-1430; RIN No. 7100-AD87 and Docket No. R-1442; RIN No. 7100-AD87 FDIC RIN 3064-AD95, RIN 3064-AD96 OCC Docket ID OCC-2012-0008 and Docket ID OCC-2012-0009 (Federal Reserve, FDIC, and Treasury/OCC) Comment Letter regarding Basel III - Proposed Rulemaking on Minimum Regulatory Capital and the Standardized Approach for Risk-weighted Assets community bank exemption. Federal Reserve Docket No. R-1430; RIN No. 7100-AD87 and Docket No. R-1442; RIN No. 7100-AD87 FDIC RIN 3… Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 0 0 2012-10-16T17:52:28.073000-04:00
1301484 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS d2841ccf-52f7-4326-9eca-82383d58c59d Q3 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 400531588 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 2012 third_quarter FIN H.R. 1697 (and S. 1600) - Communities First Act (Community bank regulatory and tax relief) (all sections) (House and Senate) H.R. 1418 (and S. 509 renumbered in the Senate to S. 2231) - Small Business Lending Enhancement Act of 2011 (Expansion of credit unions member business lending powers) (all sections) (House and Senate) H.R. 3993 Capital Access for Small Business and Jobs Act (Credit union access to outside capital) (all sections) (House and Senate) H.R. 3461 (and S. 2160) Financial Institutions Examination Fairness Act (To improve the examination of depository institutions) (all sections) (House and Senate) H.R. 4367 (and S. 3204) ATM fee disclosure legislation to eliminate the duplicative disclosure notices on the exterior of ATM machines (House and Senate) Five-year extension of the Transaction Account Guarantee (TAG) program (House and Senate) Interest penalties for violations of reporting requirements regarding the Small Business Lending Fund (SBLF) (House and Senate and Treasury/SBLF) Comment Letter regarding Basel III - Proposed Rulemaking on Minimum Regulatory Capital and the Standardized Approach for Risk-weighted Assets extension of comment period. Federal Reserve Docket No. R-1430; RIN No. 7100-AD87 and Docket No. R-1442; RIN No. 7100-AD87 FDIC RIN 3064-AD95, RIN 3064-AD96 OCC Docket ID OCC-2012-0008 and Docket ID OCC-2012-0009 (Federal Reserve, FDIC, and Treasury/OCC) Comment Letter regarding Basel III - Proposed Rulemaking on Minimum Regulatory Capital and the Standardized Approach for Risk-weighted Assets community bank exemption. Federal Reserve Docket No. R-1430; RIN No. 7100-AD87 and Docket No. R-1442; RIN No. 7100-AD87 FDIC RIN 3… Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 0 0 2012-10-16T17:52:28.073000-04:00
1301485 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS d2841ccf-52f7-4326-9eca-82383d58c59d Q3 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 400531588 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 2012 third_quarter TAX H.R. 1418 (and S. 509 - renumbered in the Senate to S. 2231) - Small Business Lending Enhancement Act of 2011 (Expansion of credit unions' member business lending powers) (all sections) (House and Senate) H.R. 3993 - Capital Access for Small Business and Jobs Act (Credit union access to outside capital) (all sections) (House and Senate) Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 0 0 2012-10-16T17:52:28.073000-04:00
1301486 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS d2841ccf-52f7-4326-9eca-82383d58c59d Q3 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 400531588 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 2012 third_quarter SMB Interest penalties for violations of reporting requirements regarding the Small Business Lending Fund (SBLF) (House and Senate and Treasury/SBLF) H.R. 1418 (and S. 509 renumbered in the Senate to S. 2231) - Small Business Lending Enhancement Act of 2011 (Expansion of credit unions member business lending powers) (all sections) (House and Senate) H.R. 3993 Capital Access for Small Business and Jobs Act (Credit union access to outside capital) (all sections) (House and Senate) Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 0 0 2012-10-16T17:52:28.073000-04:00
1301487 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS d2841ccf-52f7-4326-9eca-82383d58c59d Q3 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 400531588 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 2012 third_quarter CSP Informed House regarding the Consumer Financial Protection Bureau regarding regulatory burden, supervision of non-bank financial service providers, challenges in obtaining credit, tiered regulation, and Small Business Review Panels (House) Informed the Consumer Financial Protection Bureau regarding applicability of rules, positive feedback, consumer responsibility, focus on the largest financial institutions and the shadow financial industry, five year extension of the TAG program, and a Basel III exemption for community banks. (Treasury/CFPB) Informed Consumer Financial Protection Bureau regarding compliance systems and resources available to community banks and the costs community banks incur to become compliant with various regulations. (Treasury/CFPB) Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 0 0 2012-10-16T17:52:28.073000-04:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);