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

3 rows where filing_uuid = "5dfc19a9-4fb4-4f91-b97c-55607aaf2f9d" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 3

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
2347199 ANIMAL WELLNESS ACTION 5dfc19a9-4fb4-4f91-b97c-55607aaf2f9d Q3 ANIMAL WELLNESS ACTION 401104987 ANIMAL WELLNESS ACTION 2019 third_quarter BUD Discussions of FY 2020 Appropriations Bills that include Interior Appropriations (DOI), Agriculture Appropriations (USDA), and Criminal Justice Appropriations (DOJ)- HR 3055. S.2522 - Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, 2020 S.2580 - Department of the Interior, Environment, and Related Agencies Appropriations Act, 2020 S.2584 - Commerce and Justice, Science, and Related Agencies Appropriations Act, 2020 Agriculture, Dept of (USDA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2019-10-17T14:30:46.840000-04:00
2347200 ANIMAL WELLNESS ACTION 5dfc19a9-4fb4-4f91-b97c-55607aaf2f9d Q3 ANIMAL WELLNESS ACTION 401104987 ANIMAL WELLNESS ACTION 2019 third_quarter ANI Enforcement of the Horse Protection Act of 1970 Preventing Animal Cruelty and Torture (PACT) Act - H.R. 724 / S. 479 U.S. Senator Joseph D. Tydings Memorial Prevent All Soring Tactics (PAST) Act of 2019 - H.R. 693 Prevent All Soring Tactics (PAST) Act (S. 1007) Safeguard American Food Exports Act (SAFE) of 2019 - H.R. 961 (not yet introduced in Senate) Shark Fin Sales Elimination Act of 2019 - H.R. 737 / S. 877 Horseracing Integrity Act - H.R. 1754; S. 1820 Welfare of Our Friends (WOOF) Act of 2019 - H.R. 1002 Opportunities for Fairness in Farming (OFF) Act - S. 935 (not yet introduced in House) Providing Responsible Emergency Plans for Animals at Risk of Emerging Disasters (PREPARED) Act - H.R. 1042 Big Cat Public Safety Act - H.R. 1380 Wildlife Conservation and Anti-Trafficking Act of 2019 - H.R. 864 Bird Safe Buildings Act - H.R. 919 Bear Protection Act - H.R. 2264 (not yet introduced in Senate) Albatross and Petrel Conservation Act - H.R. 1305 Rescuing Animals with Rewards (RAWR) Act - H.R. 97; S. 1590 Puppy Protection Act (H.R. 2422) FY20 Appropriations Bills, including Interior Appropriations (DOI), Agriculture Appropriations (USDA), and Criminal Justice Appropriations (DOJ) - HR 3055 S.2522 - Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act, 2020 S.2580 - Department of the Interior, Environment, and Related Agencies Appropriations Act, 2020 S.2584 - Commerce and Justice, Science, and Related Agencies Appropriations Act, 2020 Wolf Delisting Regulation Docket No. FWS-HQ-ES-2018-0097 Discussions of the following bills not yet introduced by the House or Senate: Greyhound Racing Elimination Act LEAD Act PIGS (Gestation Crate Ban) Act Organic Standards Legislation TEASPA Best Practices Act Captive Primate Safety Act Agriculture, Dept of (USDA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2019-10-17T14:30:46.840000-04:00
2347201 ANIMAL WELLNESS ACTION 5dfc19a9-4fb4-4f91-b97c-55607aaf2f9d Q3 ANIMAL WELLNESS ACTION 401104987 ANIMAL WELLNESS ACTION 2019 third_quarter AGR U.S. Senator Joseph D. Tydings Memorial Prevent All Soring Tactics (PAST) Act of 2019 - H.R. 693 Prevent All Soring Tactics (PAST) Act (S. 1007) Safeguard American Food Exports Act (SAFE) of 2019 - H.R. 961 Opportunities for Fairness in Farming (OFF) Act - S. 935, not yet introduced in the House Agriculture, Dept of (USDA),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2019-10-17T14:30:46.840000-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);