lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
12 rows where filing_uuid = "8af4f607-e9cb-4304-8cd2-cddbd96a2a91" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2478124 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | SMB | H.R. 7010 Paycheck Protection Program Flexibility Act of 2020 H.R. 748 Coronavirus Aid, Relief, and Economic Security Act or the CARES Act and implementation related to small business loans, tax provision and student load debt (P.L. 116-136) H.R. 6201 Families First Coronavirus Response Act related to paid time off and family leave and tax credits for small businesses (P.L. 166-127) H.R.1651 RE-VAC Act H.R. 1994 SECURE Act S. 1428 Retirement Parity for Student Loans Act H.R. 2513 Corporate Transparency Act of 2019 S. 2563 ILLICIT CASH Act Paycheck Protection Program implementation and improvements H.R. 6821/S. 3612 Small Business Expense Protection Act S. 4117 Paycheck Protection Program Small Business Forgiveness Act | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478125 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | BUD | FY 2021 Agriculture, Rural Development, Food and Drug Administration, and related Agencies Appropriations Act, (NAHLN, VMLRP, VSGP, FARAD); FY 2021 Department of the Interior, Environment, and Related Agencies Appropriations Act (Wild Horse and Burros; National Wildlife Health Center) P.L. 116-6, FY 2019 appropriations P.L. 116-94 FY 2020 appropriations | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478126 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | EDU | Higher Education Act reauthorization; H.R. 4647 College Affordability Act S. 1163/H.R. 2746 Veterinary Medicine Loan Repayment Program Enhancement Act Public Service Loan Forgiveness Program implementation S. 609 Protecting JOBs Act H.R. 2099 Wildlife Veterinarians Employment and Training Act H.R. 3102 Helping Individuals Get a Higher Education while Reducing Education Debt (HIGHER ED) Act H.R. 3418 Protecting Our Students by Terminating Graduate Rates that Add to Debt Act (POST Grad Act) H.R. 2065/S. 1002 Affordable Loans for Any Student Act H.R. 2728/S. 1489 Joint Consolidation Loan Separation Act H.R. 2129/S. 1496 Empowering Students Though Enhanced Financial Counseling Act H.R. 3674 Eliminating the Hidden Student Loan Tax Act; S. 1696, Student Loan Tax Elimination Act of 2019 H.R. 2186 Student Loan Refinancing Act H.R. 3098 Student Loan Interest Deduction Act S. 379 To amend the Internal Revenue Code of 1986 to permit amounts paid for programs to obtain a recognized postsecondary credential or a license to be treated as qualified higher education expenses for purposes of a 529 account S. 1175 PSLF Technical Corrections Act S. 3760 Strengthening Loan Forgiveness for Public Servants During the COVID-19 Crisis Act | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478127 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | ANI | H.R. 2651/S. 1820 Horse Racing Integrity Act of 2017; H.R. 6921 Healthy Dog Importation Act H.R. 919 Bird Safe Buildings Act of 2019 | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478128 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | PHA | H.R. 1607/S.1290 Fairness to Pet Owners Act GFI 256 FDA Compounding Guidance | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478129 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | HOM | H.R. 1589 CBRN Intelligence and Information Sharing Act, all provisions H.R. 4482/S.2107 Protecting American's Food and Agriculture Act of 2019, all provisions | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478130 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | DEF | 2021 National Defense Authorization Act, provision Army Corp Trauma/Emergency Training/Military Working Dog support; Breed policy on military bases | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478131 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | AGR | S.4156 A bill to require the Secretary of Agriculture to provide relief from hardship due to the COVID-19 pandemic to agriculture producers, and for other purposes. H.R. 2859/S.1620 Processing Revival and Intrastate Meat Exemption (PRIME) Act S. 2695 National Bio and Agro-Defense Facility Act of 2019 H.R. 6800 HEROES Act Animal health and disease management provisions S.4156 Respond to Epidemic Losses and Investing in the Economic Future (RELIEF) for Procedures Act of 2020 | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478132 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | TRA | H.R.2 - INVEST in America Act related to horse transportation H.R. 487/S.1255 Transporting Livestock Across American Safely Act H.R. 2460/S. 600 Modernizing Transportation Act | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478133 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | TAX | H.R. 2746/S. 1163 Veterinary Medicine Loan Repayment Program Enhancement Act; H.R. 1043/S. 460 Employer Participation in Repayment Act P.L. 115-97 Tax Cuts and Jobs Act 2017-2019 tax extenders UBIT repeal: H.R. 513 Nonprofits Support Act S. 632 Lift for Charities Act | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478134 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | HCR | H.R. 3771/S.1903 Advancing Emergency Preparedness Through One Health Act; H.R. 3771/S.1903 Advancing Emergency Preparedness Through Once Health Act Coronavirus Disease Outbreak S.3759 - Global Wildlife Health and Pandemic Prevention Act S. 1170/H.R. 2294 Association Health Plans Act of 2019 Department of Labor NPRM/Final Rule, Definition of Employer Under Section 3(5) of ERISA-Association Health Plans | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-04:00 | |
| 2478135 | AMERICAN VETERINARY MEDICAL ASSOCIATION 8af4f607-e9cb-4304-8cd2-cddbd96a2a91 | Q2 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 3630 | AMERICAN VETERINARY MEDICAL ASSOCIATION | 2020 | second_quarter | VET | H.R. 3103/S. 2949 Puppies Assisting Wounded Service members Act of 2019 | Education, Dept of,Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Small Business Administration (SBA) | 220000 | 0 | 0 | 2020-07-19T19:35:03.817000-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);