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 = "de4e2db9-9cc9-4b73-b09f-5faa795a23fe" and issue_code = "BAN" 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
194874 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES de4e2db9-9cc9-4b73-b09f-5faa795a23fe YY CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 7725 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 2002 year_end BAN Regulatory Issues National Credit Union Administration Foreign Branching for Credit Unions Retirement Benefits for FCU Employees 2003-2008 NCUA Strategic Plan Prompt Corrective Action Advertising Requirements 2003 NCUA Budget Securities and Exchange Commission Sweep Account Authority for Credit Unions Federal Legislation HR 7 -- Community Solutions Act of 2001 HR 237 -- Consumer Internet Privacy Enhancement Act HR 333 -- Bankruptcy Abuse Prevention and Consumer Protection Act of 2001 HR 760 -- Faith Based Lending Protection Act HR 974 -- Small Business Interest Checking Act of 2001 HR 1055 -- Federal Payday Loan Consumer Protection Amendments of 2001 HR 1061 -- Consumer Banking Services Costs Assessment Act of 2001 HR 1408 -- Financial Services Antifraud Network Act of 2001 HR 2160 -- To provide for the establishment of individual development accounts H.R. 2576 -- The Subchapter S Modernization Act H.R. 2720 -- Markey-Barton Consumers’ Right to Financial Privacy Act HR 2796 -- FHLB Act Amendments HR 3162 -- USA Patriot Act HR 3717, Federal Deposit Insurance Reform Act of 2002 HR 3763, Corporate and Auditing Accountability, Responsibility and Transparency Act of 2002 HR 3911, Telemarketing Relief Act of 2002 HR 3951, Financial Services Regulatory Relief Act of 2002 HR. 4073, Amendments to Microenterprise for Self Reliance Act of 2000 HR 4612, Expanded Access To Financial Services Act of 2002 H.R. 5414 -- The Check Clearing for the 21st Century Act, S 30 -- Financial Information Privacy Protection Act of 2001 S 229 -- Interest on Business Checking Act of 2001 S 324 -- Social Security Number Privacy Act of 2001 S 420 -- Bankruptcy Reform Act of 2001 S 592 -- The Savings Opportunity and Charitable Giving Act of 2001 S 1025 -- A bill to provide for savings for working families S 1055 -- Privacy Act of 2001 S. 1201 – The Subchapter S Modernization Act S 1371 -- Money Laundering Safeguards S. 1924 -- Compassion, Aid, Recovery and Empowerment (CARE) Act S 1945,… Federal Deposit Insurance Corporation (FDIC),Federal Housing Finance Agency (FHFA),Federal Reserve System,HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Natl Credit Union Administration (NCUA),Office of the Comptroller of the Currency (OCC),Office of Thrift Supervision (OTS),SENATE,Treasury, Dept of,White House Office   200000 0 0 2003-01-28T00:00:00-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);