lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where filing_uuid = "e2b9d45e-053c-44df-9d7d-e0a20f7989b7" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2164661 | HUMANE WORLD ACTION FUND AND AFFILIATES (FORMERLY KNOWN AS HUMANE SOCIETY LEGISLATIVE FUND) e2b9d45e-053c-44df-9d7d-e0a20f7989b7 | Q2 | HUMANE WORLD ACTION FUND AND AFFILIATES (FORMERLY KNOWN AS HUMANE SOCIETY LEGISLATIVE FUND) | 400873559 | HUMANE WORLD ACTION FUND | 2018 | second_quarter | ANI | Legislation oH.R. 1818/S. 2990 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/S. 2957 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 oH.R. 2 Agriculture and Nutrition Act of 2018 oH.R. 4691 Welfare of Our Friends Act of 2017 oH.R. 4693 Puppy Protection Act of 2017 oPuppy Mill bill by Rep. Costello (not yet introduced) oAnimal Welfare in Agricultural Research Endeavors Act (not yet introduced) oH.R. 424/S. 164 Gray Wolf State Management 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. 2083/S. 1702 Endangered Salmon and Fisheries Predation Prevention Act oH.R. 1759 Traveling Exotic Animal and Public Safety Protection Act oH.R. 3197 Preventing Unkind and Painful Procedures and Experiments on Respected Species (PUPPERS) Act oH.R. 2887 No Regulation Without Representation Act of 2017 oH.R. 4879 Protect Interstate Commerce Act oH.R. 3668 Sportsmens Heritage And Recreational Enhancement Act oH.R. 2327/S. 1014 Puppies Assisting Wounded Service members oH.R. 3133 Streamlining Environmental Approvals Act oH Res. 401 Urging China, South Korea, Vietnam, Thailand, the Philippines, Indonesia, Cambodia, Laos, India, and all nations to outlaw the dog and cat meat trade and to enforce existing laws against the trade oH.R. 3792 Animal Emergency Planning Act of 2017 oH.R. 717 ESA Listing Reform Act oH.R. 4202/S. 2971 Parity in Animal Cruelty Enforcement Act oH.R… | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,Veterans Affairs, Dept of (VA) | 260000 | 0 | 0 | 2018-07-20T12:17:04.657000-04:00 | |
| 2164662 | HUMANE WORLD ACTION FUND AND AFFILIATES (FORMERLY KNOWN AS HUMANE SOCIETY LEGISLATIVE FUND) e2b9d45e-053c-44df-9d7d-e0a20f7989b7 | Q2 | HUMANE WORLD ACTION FUND AND AFFILIATES (FORMERLY KNOWN AS HUMANE SOCIETY LEGISLATIVE FUND) | 400873559 | HUMANE WORLD ACTION FUND | 2018 | second_quarter | BUD | oFY19 Appropriations  Agriculture Animal and Plant Health Inspection Service Animal Welfare Act enforcement funding Animal and Plant Health Inspection Service Horse Protection Act enforcement funding and rulemaking Animal and Plant Health Inspection Service Animal Welfare Act and Horse Protection Act online records Agricultural Research Service Animal Welfare Coverage Animal and Plant Health Inspection Service Investigative and Enforcement Services funding Food Safety and Inspection Service Humane Methods of Slaughter Enforcement funding Agriculture Office of Inspector General Animal Fighting Enforcement Funding National Institute of Food and Agriculture Veterinary Medical Services Act Funding Animal and Plant Health Inspection Service Emergency Management Systems funding Class B random source dealers block licensing Horse slaughter defund amendment Predators control methods in Wildlife Services  Labor HHS Computational toxicology funding 21stcentury science Chimpanzee retirement Nonanimal alternatives  Interior Bureau of Land Management proposal to allow the slaughter of wild horses Preserving the Endangered Species Act (ESA) National Park Service rule on trapping and hunting in Alaska National Wildlife Refuge land and on National Park Service land Bureau of Land Management program of nonlethal fertility control for wild horses and burros, opposition to slaughter or euthanasia of wild horses National Center for Computational Toxicology program funding Preserving protections for Gray Wolves in the Great Lakes region and Wyoming Increasing funding for wildlife trafficking and ESA listings  Defense Military trauma training  Commerce, Justice, Science Preserving the MMPA Marine Mammal Commission funding | Agriculture, Dept of (USDA),Commerce, Dept of (DOC),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,Veterans Affairs, Dept of (VA) | 260000 | 0 | 0 | 2018-07-20T12:17:04.657000-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);