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 = "cb3f27bc-e924-4e07-80bd-dfe3e9e0f1eb" and issue_code = "ANI" 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
2050034 HUMANE WORLD ACTION FUND AND AFFILIATES (FORMERLY KNOWN AS HUMANE SOCIETY LEGISLATIVE FUND) cb3f27bc-e924-4e07-80bd-dfe3e9e0f1eb Q3 HUMANE WORLD ACTION FUND AND AFFILIATES (FORMERLY KNOWN AS HUMANE SOCIETY LEGISLATIVE FUND) 400873559 HUMANE WORLD ACTION FUND 2017 third_quarter ANI Legislation oH.R. 1818 Big Cat Public Safety Act oH.R. 2790 Humane Cosmetics Act oH.R. 1753/S. 741 Opportunities for Fairness in Farming Act oH.R. 1752/S. 740 Voluntary Checkoff Program Participation Act oH.R. 2651 Horseracing Integrity Act oH.R. 1494/S. 654 Preventing Animal Cruelty and Torture Act oH.R. 1847 Prevent All Soring Tactics Act oH.R. 1338 Horse Protection Amendments Act oH.R. 909/S. 322 Pet and Women Safety Act oH.R. 113/S. 1706 Safeguarding American Food Exports Act oH.R. 1456/S. 793 Shark Fin Trade Elimination Act oH.R. 1406 Dog and Cat Meat Trade Prohibition Act of 2017 oH.R. 1368/S. 503 Animal Welfare Accountability and Transparency Act oFarm Bill (not yet introduced) oPuppy Mill Bills (not yet introduced) oH.R. 2887 No Regulation without Representation Act of 2017 oAnimal Welfare in Agricultural Research Endeavors Act (not yet introduced) oH.R. 424/S. 164 Gray Wolf State Management Act oS. 733 Sportsmens Act oS. 1514 Hunting Heritage and Environmental Legacy Preservation (HELP) for Wildlife Act oH.R. 226 African Elephant Conservation and Legal Ivory Possession Act oH.R. 1243 Battlefield Excellence through Superior Training Practices Act oH.R. 2810 and S. 1519 National Defense Authorization Act for Fiscal Year 2018 oH.R. 1438 Refuge from Cruel Trapping Act oH. Res. 244 Expressing support for Japan to end its whaling in all forms and to strengthen measures to conserve whale populations oH.R. 1817 Chemical Poisons Reduction Act oH.R. 2542Federal Bird-Safe Buildings Act of 2017 oH.R. 2083/S. 1702 Endangered Salmon and Fisheries Predation Prevention Act oH.R. 1759 Traveling Exotic Animal and Public Safety Protection Act oH.R. 816 FACT Act oH.R. 3197 Preventing Unkind and Painful Procedures and Experiments on Respected Species (PUPPERS) Act oH.R. 3354 Department of the Interior, Environment, and Related Agencies Appropriations Act, 2018 oH.R. 2887 No Regulation Without Representation Act of 2017 oH.R. 3599 Protect Interstate Commerce Act oH.R. 3668 Sportsmens Heritage And Recreational Enhancement Ac… Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Natl Oceanic & Atmospheric Administration (NOAA),SENATE,Veterans Affairs, Dept of (VA)   270000 0 0 2017-10-20T17:08:57.003000-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,
            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);