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 = "ae1ce8b2-e32f-41df-8652-be7f4fe01c02" 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
3245071 ANIMAL WELFARE INSTITUTE FKA SOCIETY FOR ANIMAL PROTECTIVE LEGISLATION ae1ce8b2-e32f-41df-8652-be7f4fe01c02 Q3 ANIMAL WELFARE INSTITUTE FKA SOCIETY FOR ANIMAL PROTECTIVE LEGISLATION 35935 ANIMAL WELFARE INSTITUTE FKA SOCIETY FOR ANIMAL PROTECTIVE LEGISLATION 2024 third_quarter ANI HR 3090/S 4004PAST Act - To expand horse soring regulations HR 3475/S 2037SAFE Act - To amend the Agriculture Improvement Act of 2018 to prohibit the slaughter of equines for human consumption. HR 3656Wild Horse and Burro Protection Act - To prohibit certain uses of aircraft with respect to the management of wild free-roaming horses and burros HR 3783Mink VIRUS Act - To protect public health and human safety by prohibiting the farming of mink for their fur, to compensate farmers as they transition out of the industry, and for other purposes. HR 3859Animal Welfare Enforcement Improvement Act -- To amend the Animal Welfare Act to increase protections for animals, and for other purposes. HR 4068/S 1940Canyon's Law - To prohibit the use of M-44 devices, commonly known as "cyanide bombs", on public land, and for other purposes. HR 4241Horse Transportation Safety Act- To amend the Horse Protection Act, to prohibit the transportation of horses in interstate transportation in a motor vehicle containing 2 or more levels stacked on top of one another, and for other purposes. HR 4417/S 2020Ending Agricultural Trade Suppression Act (EATS Act) -- To prevent States and local jurisdictions from interfering with the production and distribution of agricultural products in interstate commerce, and for other purposes. HR 6021Ejiao Act of 2023 -- To prohibit the transportation, sale, and purchase of donkeys or donkey hides for the purpose of producing ejiao, to prohibit the transportation, sale, and purchase of products containing ejiao, and for other purposes. HR 8164/S 4206Captive Primate Safety Act -- To amend the Lacey Act Amendments of 1981 to prohibit certain activities involving prohibited primate species HR 8467Farm Bill HR 8492Prohibit Wildlife Killing Contests Act -- To prohibit wildlife killing contests on public lands HR 9571 Cold-Blooded Animal Research and Exhibition Act -- To amend the Animal Welfare Act to include cold-blooded species as animals S 4753Energy Permitting Reform Act -- To reform leasing, permitting, and… Agriculture, Dept of (USDA),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,U.S. Fish & Wildlife Service (USFWS)   70000 0 0 2024-10-17T15:58:42-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);