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.

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

1 row where filing_uuid = "2ba7f870-a924-48cd-a45e-e069823a4e82" and issue_code = "SMB" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

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 income_amount expense_amount is_no_activity is_termination received_date
1771022 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 2ba7f870-a924-48cd-a45e-e069823a4e82 Q4 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 400531588 COMMUNITY BANKERS ASSOCIATION OF ILLINOIS 2015 fourth_quarter SMB Community Bankers Association of Illinois (CBAI) 2015 Federal Policy Priorities (House and Senate, FDIC, OCC) Tiered Regulation and Supervision for Community Banks - The Independent Community Bankers of Americas Plan for Prosperity- Outsized risks taken by Wall Street mega banks during the financial crisis. The different/modest risks posed by community banks. Regulations not reflecting those differences. Regulatory burden on community banks by a one-size-fits-all approach. Disproportionate burden of banking laws and regulations on community banks. Credit unions, Farm Credit System lenders and other non-bank financial service providers not subject to the same laws and regulations as community banks. Unlevel playing field and a significant competitive disadvantage for community banks. Independent Community Bankers of Americas (ICBA) Plan for Prosperity - a regulatory platform - community banks able to thrive and contribute to local economies. Excessive, redundant and costly regulations. Regulatory accountability. Community banks dedicating resources to promoting economic growth. Steady increase in regulations over many decades. Regulatory threats to community banks and their communities. The Plan for Prosperity regarding: Basel III original intent. additional capital for small holding companies - modernize the Federal Reserves Policy Statement. Securities and Exchange Commission rules. reforming mortgage lending. accountability in bank exams by providing an appeals process. bank oversight and examinations - targeting risks. annual requirement for redundant privacy notices. consumer regulation - inclusive and accountable CFPB governance. arbitrary disparate impact fair lending causes of action. viability of mutual banks with new charter options. cost-benefit analysis to justify new rules. red tape in small business lending - burdensome data collection. community bank mortgage servicing. Treasury Assistant Secretary for Community Banks. subchapter S constraints. five-year loss carryback - support for… Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),SENATE   50000 0 0 2016-01-18T12:59:15.390000-05: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,
            income_amount INTEGER,
            expense_amount INTEGER,
            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);