lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "e5c79ddc-43fe-49c8-b3cf-e538abdc188e" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2769955 | PET INDUSTRY JOINT ADVISORY COUNCIL e5c79ddc-43fe-49c8-b3cf-e538abdc188e | Q1 | PET INDUSTRY JOINT ADVISORY COUNCIL | 400311455 | PET INDUSTRY JOINT ADVISORY COUNCIL | 2022 | first_quarter | ANI | H.R. 48 - American Sovereignty and Species Protection Act H.R. 151/S. 37 - Preventing Future Pandemics Act of 2021 H.R. 160/S. 46 - Restoring Resilient Reefs Act of 2021 H.R. 763 - Child and Animal Abuse Detection and Report Act H.R. 930 - Saving Americas Vulnerable Endangered Species Act H.R. 1016 - Animal Cruelty Enforcement Act of 2021 H.R. 1022 - Puppies Assisting Wounded Servicemembers Act of 2021 H.R. 1442 - Providing Responsible Emergency Plans for Animals at Risk of Emerging Disasters Act H.R. 1448/S. 613 - Puppies Assisting Wounded Servicemembers Act of 2021 H.R. 1569 - "Critically Endangered Animals Conservation Act of 2021" H.R. 1739 - "Support Our Military Working Dogs Act" H.R. 2061/ S. 861 - "Advancing Emergency Preparedness Through One Health Act of 2021" H.R. 2085 - "HEART Act of 2021" H.R. 2486/S. 792 - "Haulers of Agriculture and Livestock Safety Act of 2021" H.R. 2840/S. 1385 - "Puppy Protection Act of 2021" H.R. 3277 - "Animal Welfare Enforcement Improvement Act" H.R. 3424/S. 1737 - "Global Pandemic Prevention and Biosecurity Act" H.R. 3973 - "Less Imprecision in Species Treatment Act of 2021" H.R. 4182 - "Extinction Crisis Emergency Act of 2021" H.R. 4239/S. 2597 - "Healthy Dog Importation Act" H.R. 4350 - "National Defense Authorization Act for Fiscal Year 2022" H.R. 4502 - "Departments of Labor, Health & Human Services, Education & Related Agencies Appropriations Act of 2022" H.R. 4521/S. 1260 - "America COMPETES Act" H.R. 4996 - "Ocean Shipping Reform Act of 2021" H.R. 5550/S. 668 - "Endangered Species Management Self-Determination Act" H.R. 5996/S. 3211 - "Eliminate, Neutralize, and Disrupt Wildlife Trafficking Reauthorization and Improvements Act of 2021" H.R. 6100 - "Goldie's Act" S. 276 - Saving Americas Vulnerable Endangered Species Act S. 626 - Lacey Act Amendments of 2021 S. 951 - Puppies Assisting Wounded Servicemembers Act of 2021 S. 2070 - "Intrastate/Interstate Commerce in Endangered Species" S. 2297 - "Interational Pandemic Preparedness and COVID-19 Response Act of 2021" S. 307… | Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,U.S. Fish & Wildlife Service (USFWS),U.S. Trade Representative (USTR) | 0 | 0 | 2022-04-05T12:41:42-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);