lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
96,889 rows where filing_period = "first_quarter" and filing_year = 2025 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3327403 | OSCAR POLICY GROUP, LLC f7ef56a4-cefe-4cdd-9d5c-67305c9efd8f | 1TY | OSCAR POLICY GROUP, LLC | 401106013 | THE SUPPORT SIGHT FOUNDATION | 2025 | first_quarter | 0 | 1 | 2025-01-02T18:54:42-05:00 | |||||
| 3327404 | MILLER & WENHOLD CAPITOL STRATEGIES cc128dd9-15c6-4580-bfa8-bce585d9b255 | 1TY | MILLER & WENHOLD CAPITOL STRATEGIES | 307034 | DOUGLAS COUNTY | 2025 | first_quarter | 0 | 1 | 2025-01-03T10:55:15-05:00 | |||||
| 3327405 | MR. PHILIP KLEIN eb73d308-d208-4270-b263-93de9669fbae | 1TY | MR. PHILIP KLEIN | 401104494 | RB | 2025 | first_quarter | 0 | 1 | 2025-01-08T07:43:39-05:00 | |||||
| 3327406 | INTEGER, LLC 9117a03c-b9cb-40e1-a48b-43bdd5c96cd1 | 1T | INTEGER, LLC | 401106683 | PHILANTHROPY ROUNDTABLE | 2025 | first_quarter | TAX | Tax proposals impacting foundations and donors, including the charitable deduction. | HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 0 | 1 | 2025-01-08T11:20:41-05:00 | ||
| 3327407 | LEGO SYSTEMS, INC. 1b1e0584-7e23-4f4d-a41d-141aa86190b8 | Q1 | LEGO SYSTEMS, INC. | 401107919 | LEGO SYSTEMS, INC. | 2025 | first_quarter | ENV | Monitor issues related to sustainability and climate change. | HOUSE OF REPRESENTATIVES,SENATE | 100000 | 0 | 0 | 2025-01-14T14:52:17-05:00 | |
| 3327408 | LEGO SYSTEMS, INC. 1b1e0584-7e23-4f4d-a41d-141aa86190b8 | Q1 | LEGO SYSTEMS, INC. | 401107919 | LEGO SYSTEMS, INC. | 2025 | first_quarter | CSP | Monitor issues related to safety and compliance | HOUSE OF REPRESENTATIVES,SENATE | 100000 | 0 | 0 | 2025-01-14T14:52:17-05:00 | |
| 3327409 | LEGO SYSTEMS, INC. 1b1e0584-7e23-4f4d-a41d-141aa86190b8 | Q1 | LEGO SYSTEMS, INC. | 401107919 | LEGO SYSTEMS, INC. | 2025 | first_quarter | EDU | Monitor issues related to education and STEM | HOUSE OF REPRESENTATIVES,SENATE | 100000 | 0 | 0 | 2025-01-14T14:52:17-05:00 | |
| 3327410 | LEGO SYSTEMS, INC. 1b1e0584-7e23-4f4d-a41d-141aa86190b8 | Q1 | LEGO SYSTEMS, INC. | 401107919 | LEGO SYSTEMS, INC. | 2025 | first_quarter | SCI | Monitor issues related to children's online safety and privacy | HOUSE OF REPRESENTATIVES,SENATE | 100000 | 0 | 0 | 2025-01-14T14:52:17-05:00 | |
| 3327411 | LEGO SYSTEMS, INC. 1b1e0584-7e23-4f4d-a41d-141aa86190b8 | Q1 | LEGO SYSTEMS, INC. | 401107919 | LEGO SYSTEMS, INC. | 2025 | first_quarter | TRD | Monitor issues related to trade | HOUSE OF REPRESENTATIVES,SENATE | 100000 | 0 | 0 | 2025-01-14T14:52:17-05:00 | |
| 3327412 | SENSE INCORPORATED 2ef78e5d-3617-4242-ad2c-0ddf7d5fb88d | 1TY | SENSE INCORPORATED | 34843 | NORTHWEST INDIAN FISHERIES COMMISSION | 2025 | first_quarter | 0 | 1 | 2025-01-22T11:20:01-05:00 | |||||
| 3327413 | SENSE INCORPORATED 3592f66f-db4a-4430-8cd0-31fe8b568c96 | 1TY | SENSE INCORPORATED | 34843 | JAMESTOWN S'KLALLAM TRIBE | 2025 | first_quarter | 0 | 1 | 2025-01-22T12:06:31-05:00 | |||||
| 3327414 | SENSE INCORPORATED de0a943b-3e59-466c-8e09-f7178720cbaf | 1TY | SENSE INCORPORATED | 34843 | SQUAXIN ISLAND TRIBE | 2025 | first_quarter | 0 | 1 | 2025-01-22T12:14:18-05:00 | |||||
| 3327415 | SENSE INCORPORATED 35af6561-99a9-417f-b531-37236748c4de | 1TY | SENSE INCORPORATED | 34843 | CHOCTAW NATION OF OKLAHOMA | 2025 | first_quarter | 0 | 1 | 2025-01-22T12:29:17-05:00 | |||||
| 3327416 | FRANZ CONSULTING, LLC 87fdf7a9-b031-4f40-9a0d-cc99ba3a7765 | 1TY | FRANZ CONSULTING, LLC | 401103148 | NATIONAL ASSOCIATION OF WHEAT GROWERS | 2025 | first_quarter | 0 | 1 | 2025-01-23T11:53:12-05:00 | |||||
| 3327417 | CORNERSTONE GOVERNMENT AFFAIRS, INC. ed3ac44d-01f0-47cc-9259-955cc323e30e | 1T | CORNERSTONE GOVERNMENT AFFAIRS, INC. | 75557 | MR. JAY ALIX | 2025 | first_quarter | GOV | Promoting transparency in government by addressing conflicts of interest. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2025-01-23T14:14:45-05:00 | |
| 3327418 | CORNERSTONE GOVERNMENT AFFAIRS, INC. ed3ac44d-01f0-47cc-9259-955cc323e30e | 1T | CORNERSTONE GOVERNMENT AFFAIRS, INC. | 75557 | MR. JAY ALIX | 2025 | first_quarter | BNK | Protecting the integrity of the bankruptcy system and promoting transparency in government. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2025-01-23T14:14:45-05:00 | |
| 3327419 | LOBBYIT.COM a1bc87ea-137e-48ad-b857-c829be774e39 | 1T | LOBBYIT.COM | 400487397 | JONATHAN RODRIGUEZ CEFALU | 2025 | first_quarter | CPI | N/A | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2025-01-27T22:47:32-05:00 | |
| 3327420 | LOBBYIT.COM b36c49c2-84d1-4a8a-8b38-31d2e3cbff1d | 1T | LOBBYIT.COM | 400487397 | ADVOCATES FOR WILD EQUINES | 2025 | first_quarter | ANI | Animal and majority Horse well fair | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-01-27T22:50:36-05:00 | ||
| 3327421 | LOBBYIT.COM 637fabba-ecab-40af-886a-5bb0d67857d7 | 1T | LOBBYIT.COM | 400487397 | AMERICAN BOARD OF OPTICIANRY AND NATIONAL CONTACT LENS EXAMINERS | 2025 | first_quarter | HCR | Focuses on expanding access to vision care and ensuring that adequately trained professionals serve individuals. | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2025-01-27T22:52:11-05:00 | |
| 3327422 | CORNERSTONE GOVERNMENT AFFAIRS, INC. 91ba1bea-ceeb-4eeb-9bb5-d5ff2feab6f8 | 1T | CORNERSTONE GOVERNMENT AFFAIRS, INC. | 75557 | SIERRA SPACE CORPORATION | 2025 | first_quarter | AER | FY 25 NASA Appropriations bill; FY 25 NASA Authorization legislation; FY 25 Defense Appropriations bill; FY 25 Defense Authorization bill; Issues involving space and launch policies at FAA and Commerce; S. 447 Orbits Act; FAA Reauthorization | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-01-28T12:02:44-05:00 | ||
| 3327423 | CORNERSTONE GOVERNMENT AFFAIRS, INC. 91ba1bea-ceeb-4eeb-9bb5-d5ff2feab6f8 | 1T | CORNERSTONE GOVERNMENT AFFAIRS, INC. | 75557 | SIERRA SPACE CORPORATION | 2025 | first_quarter | DEF | FY 25 NASA Appropriations bill; FY 25 NASA Authorization legislation; FY 25 Defense Appropriations bill; FY 25 Defense Authorization bill; Issues involving space and launch policies at FAA and Commerce; S. 447 Orbits Act | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-01-28T12:02:44-05:00 | ||
| 3327424 | JGB & ASSOCIATES, LLC 00bc8b6f-c9f7-4879-8ab0-a462075b8567 | 1T | JGB & ASSOCIATES, LLC | 401017872 | CORNERSTONE GOVERNMENT AFFAIRS OBO SIERRA SPACE CORPORATION | 2025 | first_quarter | AER | FY 25 NASA Appropriations bill; FY 25 NASA Authorization legislation; FY 25 Defense Appropriations bill; FY 25 Defense Authorization bill; Issues involving space and launch policies at FAA and Commerce; S. 447 Orbits Act; FAA Reauthorization | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-01-28T12:42:19-05:00 | ||
| 3327425 | JGB & ASSOCIATES, LLC 00bc8b6f-c9f7-4879-8ab0-a462075b8567 | 1T | JGB & ASSOCIATES, LLC | 401017872 | CORNERSTONE GOVERNMENT AFFAIRS OBO SIERRA SPACE CORPORATION | 2025 | first_quarter | DEF | FY 25 NASA Appropriations bill; FY 25 NASA Authorization legislation; FY 25 Defense Appropriations bill; FY 25 Defense Authorization bill; Issues involving space and launch policies at FAA and Commerce; S. 447 Orbits Act; FAA Reauthorization | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-01-28T12:42:19-05:00 | ||
| 3327426 | CARPENTER STRATEGIC CONSULTING LLC 1c73aba3-c007-43c3-83d7-357a85d33e62 | 1TY | CARPENTER STRATEGIC CONSULTING LLC | 401104143 | LYNK GLOBAL INC (FKA UBIQUITILINK) | 2025 | first_quarter | 0 | 1 | 2025-01-30T11:04:39-05:00 | |||||
| 3327427 | FORBES-TATE 1a784ae5-4110-4110-a5cf-2ab8b91405b7 | 1TY | FORBES-TATE | 400976792 | OUTDOOR INDUSTRY ASSOCIATION | 2025 | first_quarter | 0 | 1 | 2025-01-30T16:35:57-05:00 | |||||
| 3327428 | FORBES-TATE 08baeda1-47cd-4d4b-a82b-95199c53253d | 1T | FORBES-TATE | 400976792 | SIGNIFIER MEDICAL TECHNOLOGIES LIMITED | 2025 | first_quarter | HCR | Issues related to medical device coverage and reimbursement. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-01-30T16:40:51-05:00 | ||
| 3327429 | BRICK STREET STRATEGY 69e94304-8c16-4a8e-9a1f-d5c75bb43400 | 1T | BRICK STREET STRATEGY | 401106351 | SIEMENS MEDICAL SOLUTIONS USA, INC. | 2025 | first_quarter | VET | Medical technology and clinical staffing | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-01-31T09:50:06-05:00 | ||
| 3327430 | AUBURN HEALTH STRATEGIES, LLC 3455119d-8391-40ec-a8ed-b8e8222e2c29 | 1TY | AUBURN HEALTH STRATEGIES, LLC | 292697 | AOAC INTERNATIONAL | 2025 | first_quarter | 0 | 1 | 2025-01-31T13:00:15-05:00 | |||||
| 3327431 | THEGROUP DC, LLC 3d5fb409-af9a-47a4-a853-2dbe10f16620 | 1TY | THEGROUP DC, LLC | 401103834 | ASSOCIATION OF AMERICAN PUBLISHERS | 2025 | first_quarter | 0 | 1 | 2025-01-31T16:11:52-05:00 | |||||
| 3327432 | GEPHARDT GROUP GOVERNMENT AFFAIRS fc91207f-43a2-41e9-8dc1-24a65fad9d88 | 1TY | GEPHARDT GROUP GOVERNMENT AFFAIRS | 315717 | ANCORA ADVISORS, LLC | 2025 | first_quarter | 0 | 1 | 2025-01-31T16:33:52-05:00 | |||||
| 3327433 | LIEBMAN & ASSOCIATES, INC. b1272f0c-2e57-4959-bbb0-9d1681729b52 | 1TY | LIEBMAN & ASSOCIATES, INC. | 46585 | NEXTERA ENERGY, INC. | 2025 | first_quarter | 0 | 1 | 2025-02-02T10:29:22-05:00 | |||||
| 3327434 | BGR GOVERNMENT AFFAIRS 31dd6dea-0272-4db0-a4cd-98389ac3d214 | Q1 | BGR GOVERNMENT AFFAIRS | 5357 | A PLACE FOR MOM, INC. | 2025 | first_quarter | GOV | Provide strategic guidance and advocacy regarding Congressional oversight of the Senior Living Referral sector. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 0 | 2025-02-03T15:23:02-05:00 | |
| 3327435 | BGR GOVERNMENT AFFAIRS f34db9a9-9358-485f-86c5-2f1604de39c3 | Q1 | BGR GOVERNMENT AFFAIRS | 5357 | ACADEMY OF NUTRITION AND DIETETICS | 2025 | first_quarter | HCR | Provide strategic counsel and advocate on issues related to health care coverage for Medical Nutritional Therapy and Intensive behavior health and other priorities for the Academy of Nutrition and Dietetics | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE | 90000 | 0 | 0 | 2025-02-03T15:26:28-05:00 | |
| 3327436 | BGR GOVERNMENT AFFAIRS f317069d-dafa-45f1-9347-7ae9e4143062 | Q1 | BGR GOVERNMENT AFFAIRS | 5357 | ADVANCED MEDICAL TECHNOLOGY ASSOCIATION | 2025 | first_quarter | HCR | Provide guidance and strategic advice regarding regulation and coverage of medical devices, including diagnostic tests | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 0 | 2025-02-03T15:28:36-05:00 | |
| 3327437 | BGR GOVERNMENT AFFAIRS 6b0b71e2-6cc0-4cfe-9bf8-949d94b186c2 | Q1 | BGR GOVERNMENT AFFAIRS | 5357 | ALKERMES, INC. | 2025 | first_quarter | HCR | Provide strategic counsel and advocate on issues related to the biopharmaceutical industry generally, and Alkermes, Inc. specifically | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 0 | 2025-02-03T15:33:51-05:00 | |
| 3327438 | BGR GOVERNMENT AFFAIRS baf26d85-4e0c-4d18-b827-a38414c5be91 | Q1 | BGR GOVERNMENT AFFAIRS | 5357 | AMERICAN HEALTH CARE ASSOCIATION | 2025 | first_quarter | MMM | Long-term care reform; Medicare and Medicaid payment policy; Medicare Advantage policy; arbitration issues; implementation of health care reform; bad debt relief; SGR replacement; NOTICE Act; Nurse staffing shortage; appropriations | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 150000 | 0 | 0 | 2025-02-03T15:35:35-05:00 | |
| 3327439 | BGR GOVERNMENT AFFAIRS 6301b8f9-4819-4999-85cd-3d8a52c5e2b2 | Q1 | BGR GOVERNMENT AFFAIRS | 5357 | APPLIED BIOLOGICS | 2025 | first_quarter | HCR | Advocate on issues related to Medicare coverage | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2025-02-03T15:37:15-05:00 | |
| 3327440 | BGR GOVERNMENT AFFAIRS 7f193f04-6675-4c52-abd0-ac1da141ceda | Q1 | BGR GOVERNMENT AFFAIRS | 5357 | BIOMERIEUX, INC. | 2025 | first_quarter | HCR | Provide strategic counsel and advocate on issues related to diagnostic testing issues generally and bioMerieux specifically. | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 0 | 2025-02-03T15:39:02-05:00 | |
| 3327441 | HEALTH TRANSFORMATION ALLIANCE 009c26be-6677-45e0-8fa5-04b8865b9147 | Q1Y | HEALTH TRANSFORMATION ALLIANCE | 401104265 | HEALTH TRANSFORMATION ALLIANCE | 2025 | first_quarter | 0 | 0 | 2025-02-04T10:45:55-05:00 | |||||
| 3327442 | LURKINS CONSULTING, LLC 337e3763-a44b-463b-a005-105e75630877 | 1T | LURKINS CONSULTING, LLC | 401107754 | COVERCRESS, INC. | 2025 | first_quarter | AGR | general awareness of company and efforts | HOUSE OF REPRESENTATIVES,SENATE | 6000 | 0 | 1 | 2025-02-04T12:57:17-05:00 | |
| 3327443 | THOMPSON CONSULTING GROUP e58236a6-5149-4cb1-aec5-805456cdb9e4 | 1TY | THOMPSON CONSULTING GROUP | 73670 | INFOBLOX (FORMERLY KNOWN AS IID) | 2025 | first_quarter | 10000 | 0 | 1 | 2025-02-04T13:37:43-05:00 | ||||
| 3327444 | FORBES-TATE 540f289e-1023-4025-8f19-138aedc80e60 | 1TY | FORBES-TATE | 400976792 | NEW VENTURE FUND | 2025 | first_quarter | 0 | 1 | 2025-02-05T19:24:10-05:00 | |||||
| 3327445 | FORBES-TATE 514a745a-cb57-4883-92ff-522200f094b5 | 1TY | FORBES-TATE | 400976792 | NCCS | 2025 | first_quarter | 0 | 1 | 2025-02-06T09:14:26-05:00 | |||||
| 3327446 | CSS PARTNERS, LLC ad44d909-0a78-46a8-8270-25c8d49815b1 | 1T | CSS PARTNERS, LLC | 401104724 | CAMBRIDGE MOBILE TELEMATICS | 2025 | first_quarter | TRA | Issues related to mobile telematics and highway safety. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-02-09T11:11:37-05:00 | ||
| 3327447 | BECKER & POLIAKOFF, P.A. 43b830ea-2c5b-4c1c-b0ca-e3b03844e6a2 | 1T | BECKER & POLIAKOFF, P.A. | 283696 | AMERICAN HEALTHY ALTERNATIVES ASSOCIATION, INC. | 2025 | first_quarter | AGR | FY25 Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act | HOUSE OF REPRESENTATIVES | 0 | 1 | 2025-02-10T09:27:42-05:00 | ||
| 3327448 | MR. AMIR GOULART SCHARIF 1f84966b-ab82-4482-889d-2fd3df462224 | Q1 | MR. AMIR GOULART SCHARIF | 401105292 | FUEL ETHANOL DISRUPTIVE BIOTECHNOLOGY RESEARCH CENTER INCORPATED | 2025 | first_quarter | CPT | Engaged in research and development activities in The United States' energy independence strategy | 0 | 0 | 2025-02-10T12:32:49-05:00 | |||
| 3327449 | MR. AMIR GOULART SCHARIF 1f84966b-ab82-4482-889d-2fd3df462224 | Q1 | MR. AMIR GOULART SCHARIF | 401105292 | FUEL ETHANOL DISRUPTIVE BIOTECHNOLOGY RESEARCH CENTER INCORPATED | 2025 | first_quarter | ENG | Engaged in research and development activities in The United States' energy independence strategy | 0 | 0 | 2025-02-10T12:32:49-05:00 | |||
| 3327450 | MR. AMIR GOULART SCHARIF 1f84966b-ab82-4482-889d-2fd3df462224 | Q1 | MR. AMIR GOULART SCHARIF | 401105292 | FUEL ETHANOL DISRUPTIVE BIOTECHNOLOGY RESEARCH CENTER INCORPATED | 2025 | first_quarter | SCI | Engaged in research and development activities in The United States' energy independence strategy | 0 | 0 | 2025-02-10T12:32:49-05:00 | |||
| 3327451 | MEHLMAN CONSULTING, INC. d327119d-2fc5-4674-9950-f024177bb847 | 1T | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2025 | first_quarter | TRD | U.S. trade policy; U.S. trade negotiations | 20000 | 0 | 1 | 2025-02-10T16:15:24-05:00 | ||
| 3327452 | MEHLMAN CONSULTING, INC. d327119d-2fc5-4674-9950-f024177bb847 | 1T | MEHLMAN CONSULTING, INC. | 284950 | SAP AMERICA, INC. | 2025 | first_quarter | CPI | Issues related to data protection, privacy, artificial intelligence. | 20000 | 0 | 1 | 2025-02-10T16:15:24-05:00 | ||
| 3327453 | WHITMER & WORRALL, LLC 3b9f1403-f775-476f-a246-3b0f2dffa363 | 1T | WHITMER & WORRALL, LLC | 292892 | UNIVERSITY OF NORTH FLORIDA | 2025 | first_quarter | EDU | Issues related to higher education, research and grant opportunities, workforce development, and establishing relationships in the federal government marketplace. Issues related to H.R. 496, the Promoting Employment and Lifelong Learning (PELL) Act. Issues related to H.R. 1311, the College Cost Transparency and Student Protection Act. Issues related to H.R. 793 / S. 161, the Jumpstart Our Businesses by Supporting Students (JOBS) Act of 2023. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2025-02-10T17:38:47-05:00 | |
| 3327454 | WHITMER & WORRALL, LLC 3b9f1403-f775-476f-a246-3b0f2dffa363 | 1T | WHITMER & WORRALL, LLC | 292892 | UNIVERSITY OF NORTH FLORIDA | 2025 | first_quarter | HCR | Issues related to higher education, research and grant opportunities, workforce development, and establishing relationships in the federal government marketplace as it relates to health care initiatives. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2025-02-10T17:38:47-05:00 | |
| 3327455 | WHITMER & WORRALL, LLC 3b9f1403-f775-476f-a246-3b0f2dffa363 | 1T | WHITMER & WORRALL, LLC | 292892 | UNIVERSITY OF NORTH FLORIDA | 2025 | first_quarter | TRA | Issues related to higher education, research and grant opportunities, workforce development, and establishing relationships in the federal government marketplace. Issues related to the implementation of H.R. 3684, the Infrastructure Investment and Jobs Act (IIJA). Issues related to a Center for Maritime Innovation. | HOUSE OF REPRESENTATIVES,Maritime Administration (MARAD),SENATE | 10000 | 0 | 1 | 2025-02-10T17:38:47-05:00 | |
| 3327456 | WHITMER & WORRALL, LLC 3b9f1403-f775-476f-a246-3b0f2dffa363 | 1T | WHITMER & WORRALL, LLC | 292892 | UNIVERSITY OF NORTH FLORIDA | 2025 | first_quarter | BUD | Issues related to H.R. 9026, the Commerce, Justice, Science, and Related Agencies Appropriations Act, 2025. Issues related to S. 4795, the Commerce, Justice, Science, and Related Agencies Appropriations Act, 2025. Issues related to H.R. 9029, the Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2025. Issues related to S. 4942, the Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2025. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2025-02-10T17:38:47-05:00 | |
| 3327457 | TCH GROUP, LLC 88416449-e68d-4592-be78-8fafdbf9a10a | 1TY | TCH GROUP, LLC | 51478 | CORMAC GROUP ON BEHALF OF BELL LEGAL GROUP | 2025 | first_quarter | 0 | 1 | 2025-02-11T16:12:47-05:00 | |||||
| 3327458 | BRIMLEY GROUP INC. a40c730e-d52f-446e-84d6-a655df386be7 | 1T | BRIMLEY GROUP INC. | 401103384 | JUST DETENTION INTERNATIONAL | 2025 | first_quarter | LAW | Funding for Prison Rape Elimination Act (PREA) within the FY2024 Commerce-Justice-Science Appropriations bill and Dept. of Homeland Security bill (both House and Senate); legislative proposal to provide emotional support services to incarcerated survivors of sexual abuse (H.R. 9835/S. 1422). | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2025-02-12T15:22:03-05:00 | |
| 3327459 | BRIMLEY GROUP INC. a40c730e-d52f-446e-84d6-a655df386be7 | 1T | BRIMLEY GROUP INC. | 401103384 | JUST DETENTION INTERNATIONAL | 2025 | first_quarter | BUD | Funding for Prison Rape Elimination Act (PREA) within the FY2024 Commerce-Justice-Science Appropriations bill and Dept. of Homeland Security bill (both House and Senate); legislative proposal to provide emotional support services to incarcerated survivors of sexual abuse (H.R. 9835/S. 1422). | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2025-02-12T15:22:03-05:00 | |
| 3327460 | BRIMLEY GROUP INC. 9433e18b-0084-41af-857b-733b6ecf15d7 | 1T | BRIMLEY GROUP INC. | 401103384 | CORRECTIONAL LEADERS ASSOC. (F.K.A. ASSOC. OF STATE CORRECTIONAL ADMINISTRATORS) | 2025 | first_quarter | LAW | Policy related to corrections, including the Cellphone Jamming Reform Act of 2023 (S. 1047) and the Second Chance Reauthorization Act of 2024 (H.R. 8028/S. 4477). | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2025-02-12T15:23:12-05:00 | |
| 3327461 | BRIMLEY GROUP INC. 542b4443-09a8-447c-b397-22376b67cdc3 | 1T | BRIMLEY GROUP INC. | 401103384 | AMERICAN CIVIL LIBERTIES UNION | 2025 | first_quarter | LAW | Support on federal sentencing reform and other federal criminal justice priorities, including pardons, clemency, and commutations and federal prison oversight. | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 1 | 2025-02-12T15:24:12-05:00 | |
| 3327462 | MORGAN CASNER ASSOCIATES 00cb97ce-0434-477d-a92f-c99e068eb7da | 1TY | MORGAN CASNER ASSOCIATES | 295270 | AFFILIATED SANTE GROUP | 2025 | first_quarter | 0 | 1 | 2025-02-12T17:15:42-05:00 | |||||
| 3327463 | SPIRIT AEROSYSTEMS, INC. eea328cd-9f07-4915-9d2f-ff91c1d2cc24 | 1TY | SPIRIT AEROSYSTEMS, INC. | 401108602 | SPIRIT AEROSYSTEMS, INC. | 2025 | first_quarter | 0 | 1 | 2025-02-13T13:53:45-05:00 | |||||
| 3327464 | TIBER CREEK GROUP af5a124f-863a-433f-9d5f-d7ccbb17df67 | 1TY | TIBER CREEK GROUP | 20744 | MMM HEALTHCARE | 2025 | first_quarter | 0 | 1 | 2025-02-13T14:39:02-05:00 | |||||
| 3327465 | IEX GROUP 3836db65-22b9-42d8-ac23-beaec6295e34 | 1T | IEX GROUP | 401106910 | IEX GROUP | 2025 | first_quarter | FIN | Equity market structure issues. | HOUSE OF REPRESENTATIVES,SENATE | 45000 | 0 | 1 | 2025-02-13T17:37:41-05:00 | |
| 3327466 | THE PETRIZZO GROUP, INC. acac5f38-83d5-4e06-8b7a-7f7ba3a843b3 | 1T | THE PETRIZZO GROUP, INC. | 305932 | DYSAUTONOMIA INTERNATIONAL | 2025 | first_quarter | BUD | Advocating for funding for (1) a public awareness and provider education program at the CDC on POTS and similar forms of dysautonomia, (2) an infection associated chronic conditions office at the NIH to coordinate research, and (3) funding for research to examine the correlation between POTS and Long COVID. | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 15000 | 0 | 1 | 2025-02-14T00:23:48-05:00 | |
| 3327467 | THE PETRIZZO GROUP, INC. acac5f38-83d5-4e06-8b7a-7f7ba3a843b3 | 1T | THE PETRIZZO GROUP, INC. | 305932 | DYSAUTONOMIA INTERNATIONAL | 2025 | first_quarter | HCR | Advocating for policies to address access to patient care, including maintaining and increasing autonomic fellowships. | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 15000 | 0 | 1 | 2025-02-14T00:23:48-05:00 | |
| 3327468 | THE PETRIZZO GROUP, INC. acac5f38-83d5-4e06-8b7a-7f7ba3a843b3 | 1T | THE PETRIZZO GROUP, INC. | 305932 | DYSAUTONOMIA INTERNATIONAL | 2025 | first_quarter | MED | Advocate for NIH research funding for dysautonomia disorders, specifically Postural Orthostatic Tachycardia Syndrome (POTS) and funding to examine the correlation between POTS and Long COVID. Supporting establishment of an infection associated chronic conditions office at the NIH to coordinate research. Asking for continued support for the Autonomic Medicine Section at the NIH. | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),SENATE | 15000 | 0 | 1 | 2025-02-14T00:23:48-05:00 | |
| 3327469 | CARD & ASSOCIATES, LLC 447bf4cd-5a8c-4102-a65c-3a775c11ed44 | 1T | CARD & ASSOCIATES, LLC | 84217 | GREATER NEW YORK HOSPITAL ASSOCIATION | 2025 | first_quarter | HCR | Support the Resident Physician Shortage Reduction Act -- H.R. 2389 Oppose changes to site neutral provider reimbursement policies Monitor and support healthcare extenders Support FY 2025 FEMA Funding Monitor H.R. 10545 | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2025-02-14T08:21:04-05:00 | |
| 3327470 | CARD & ASSOCIATES, LLC 61760c0d-5de8-43b5-bc49-a7feb75b0349 | 1T | CARD & ASSOCIATES, LLC | 84217 | AMAZON.COM (FRA PILLPACK AN AMAZON COMPANY) | 2025 | first_quarter | PHA | Monitor legislation on drug price transparency and market access issues including legislative proposals related to drug pricing Monitor FY 2025 Appropriations Support access to telehealth Monitor and engage on EU & Canadian digital regulatory policies Monitor international trade issues | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2025-02-14T08:25:55-05:00 | |
| 3327471 | CARD & ASSOCIATES, LLC 9289288d-57ea-4cb1-b2ec-4d34936c2726 | 1T | CARD & ASSOCIATES, LLC | 84217 | COALITION FOR STUDENT OPPORTUNITY AND SUCCESS | 2025 | first_quarter | EDU | Institutional Accreditation Transfer of credit issues Higher Education Reauthorization Monitor FY 2025 Labor/HHS Appropriations 90/10 Rule Implementation of the Isakson-Roe Veterans Healthcare and Benefits Improvement Act Support S. 141 Monitor legislation to reauthorize the Workforce Innovation and Opportunity Act | HOUSE OF REPRESENTATIVES,SENATE | 40000 | 0 | 1 | 2025-02-14T08:29:24-05:00 | |
| 3327472 | CARD & ASSOCIATES, LLC e67c5497-6313-4cd9-a0ff-f636741e53fc | 1T | CARD & ASSOCIATES, LLC | 84217 | CORN REFINERS ASSOCIATION | 2025 | first_quarter | AGR | Monitor and advocate for trade issues Monitor bioeconomy issues Monitor dietary guidelines and policies and front of package labeling Monitor and advocate FY 2025 Appropriations for USDA, EPA Monitor rail/transportation issues FSGG Appropriations (NAICS Codes) | HOUSE OF REPRESENTATIVES,SENATE | 60000 | 0 | 1 | 2025-02-14T08:32:58-05:00 | |
| 3327473 | CARD & ASSOCIATES, LLC aa31389d-75d2-49c7-9476-59c8957c90e2 | 1T | CARD & ASSOCIATES, LLC | 84217 | HILL EAST GROUP ON BEHALF OF AIRPORTS COUNCIL INTERNATIONAL - NORTH AMERICA | 2025 | first_quarter | AVI | Monitor FY 2025 THUD Appropriations Monitor FY 2025 NDAA Appropriations Monitor implementation of FAA Reauthorization (airport funding, issues affecting airport management and operations, and security issues) Support AIP Funding and Implementation Issues PFAS Remediation Issues | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2025-02-14T08:35:08-05:00 | |
| 3327474 | CARD & ASSOCIATES, LLC c3ea8bc0-1ac4-40f1-8c12-707f4f336e26 | 1T | CARD & ASSOCIATES, LLC | 84217 | BLUESTAR STRATEGIES IN SUPPORT OF SCHOLARLY PUBLISHING & ACADEMIC RESOURCES COAL | 2025 | first_quarter | EDU | Advocate for open access of federally funded research Oppose defunding efforts regarding the implementation of Administration Memorandum "Ensuring Free, Immediate and Equitable Access to Federally Funded Research" FY 2025 Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2025-02-14T08:38:00-05:00 | |
| 3327475 | FIDELIS GOVERNMENT RELATIONS 84f01717-ffe1-494c-9ec8-94fbee360912 | 1TY | FIDELIS GOVERNMENT RELATIONS | 306011 | HARRIS LAW FIRM OBO ROBBINS SALOMON & PATT OBO COALITION OF GM CRASH VICTIMS | 2025 | first_quarter | 0 | 1 | 2025-02-14T10:18:19-05:00 | |||||
| 3327476 | FIDELIS GOVERNMENT RELATIONS fa238179-38d4-4f33-bc02-b15faa482f99 | 1TY | FIDELIS GOVERNMENT RELATIONS | 306011 | ROCHE SURETY, INC. | 2025 | first_quarter | 0 | 1 | 2025-02-14T10:19:42-05:00 | |||||
| 3327477 | FOLEY HOAG LLP 218f4d5f-fbd1-4a69-9f34-4c51150199df | 1T | FOLEY HOAG LLP | 79610 | JEWISH FEDERATIONS OF NORTH AMERICA | 2025 | first_quarter | HCR | Legislative priorities for strengthening access to health care | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-02-14T14:49:51-05:00 | ||
| 3327478 | FOLEY HOAG LLP 2f241699-06ab-41f6-a3d6-08767dc68919 | 1T | FOLEY HOAG LLP | 79610 | T2 BIOSYSTEMS | 2025 | first_quarter | HCR | Issues related to access for rapid diagnostics. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-02-14T14:51:24-05:00 | ||
| 3327479 | SANBORN ANALYTICS INC d5778bf1-1621-479d-b4b6-cbe6b1bbef46 | Q1 | SANBORN ANALYTICS INC | 401109257 | SANBORN ANALYTICS INC | 2025 | first_quarter | MAR | Maritime Security | SENATE | 0 | 0 | 2025-02-14T16:40:31-05:00 | ||
| 3327480 | SANBORN ANALYTICS INC d5778bf1-1621-479d-b4b6-cbe6b1bbef46 | Q1 | SANBORN ANALYTICS INC | 401109257 | SANBORN ANALYTICS INC | 2025 | first_quarter | DEF | David Eastmond representing Sanborn Analytics lobbied for funds to support maritime security and the building of a Maritime Information Center. | SENATE | 0 | 0 | 2025-02-14T16:40:31-05:00 | ||
| 3327481 | SANBORN ANALYTICS INC d5778bf1-1621-479d-b4b6-cbe6b1bbef46 | Q1 | SANBORN ANALYTICS INC | 401109257 | SANBORN ANALYTICS INC | 2025 | first_quarter | INT | David Eastmond representing Sanborn Analytics lobbied for funds to support maritime security and the building of a Maritime Information Center. | SENATE | 0 | 0 | 2025-02-14T16:40:31-05:00 | ||
| 3327482 | SANBORN ANALYTICS INC d5778bf1-1621-479d-b4b6-cbe6b1bbef46 | Q1 | SANBORN ANALYTICS INC | 401109257 | SANBORN ANALYTICS INC | 2025 | first_quarter | HOM | David Eastmond representing Sanborn Analytics lobbied for funds to support maritime security and the building of a Maritime Information Center. | SENATE | 0 | 0 | 2025-02-14T16:40:31-05:00 | ||
| 3327483 | ASSOCIATION OF THE UNITED STATES NAVY 4131dd2e-3c2b-467d-835e-a539ecf20006 | Q1Y | ASSOCIATION OF THE UNITED STATES NAVY | 400894615 | ASSOCIATION OF THE UNITED STATES NAVY | 2025 | first_quarter | 0 | 0 | 2025-02-14T17:29:34-05:00 | |||||
| 3327484 | CROSSROADS STRATEGIES, LLC c5e120cc-0b1e-4ec5-bddb-10bb6ffd60b5 | 1TY | CROSSROADS STRATEGIES, LLC | 400531586 | AMERICAN CHEMISTRY COUNCIL, INC. ON BEHALF OF ITS SPRAY FOAM COALITION | 2025 | first_quarter | 0 | 1 | 2025-02-14T18:09:39-05:00 | |||||
| 3327485 | JCWS,LLC f43441b6-8d93-449c-9807-076f8614962e | Q1Y | JCWS,LLC | 401105836 | JCWS,LLC | 2025 | first_quarter | 0 | 0 | 2025-02-16T16:10:37-05:00 | |||||
| 3327486 | THORN RUN PARTNERS 0768d62e-bbd7-402a-9418-4e89f1edacdb | 1T | THORN RUN PARTNERS | 400534596 | NORTH TEXAS COMMISSION | 2025 | first_quarter | ECN | Federal legislative and regulatory issues affecting the North Texas regions economy. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-02-18T11:18:06-05:00 | ||
| 3327487 | THORN RUN PARTNERS fa889e1e-3991-42b9-81d6-dc86cd2ddef0 | 1T | THORN RUN PARTNERS | 400534596 | OBSIDIAN RENEWABLES, LLC | 2025 | first_quarter | ENG | Issues related to Hydrogen. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-02-18T13:07:33-05:00 | ||
| 3327488 | K&L GATES, LLP effa5433-81fe-4a31-9431-2d432098bfed | 1TY | K&L GATES, LLP | 32098 | NEW YORK EMBROIDERY STUDIO, INC. | 2025 | first_quarter | 0 | 1 | 2025-02-18T13:43:54-05:00 | |||||
| 3327489 | BGR GOVERNMENT AFFAIRS d8f8cb9f-4207-4559-8cf9-925c27fa5150 | 1TY | BGR GOVERNMENT AFFAIRS | 5357 | COLONY BRANDS, INC. | 2025 | first_quarter | 0 | 1 | 2025-02-18T15:52:50-05:00 | |||||
| 3327490 | BGR GOVERNMENT AFFAIRS 53cdd54c-e8a5-493d-a3b2-820361d5b149 | 1TY | BGR GOVERNMENT AFFAIRS | 5357 | EMOVIS TECHNOLOGIES US, INC. | 2025 | first_quarter | 0 | 1 | 2025-02-18T15:56:02-05:00 | |||||
| 3327491 | BGR GOVERNMENT AFFAIRS c16e984f-035b-496c-aad7-bc07ca28f59f | 1TY | BGR GOVERNMENT AFFAIRS | 5357 | MIND SPRINGS HEALTH | 2025 | first_quarter | 0 | 1 | 2025-02-18T15:57:24-05:00 | |||||
| 3327492 | BGR GOVERNMENT AFFAIRS d686c718-57ff-42a3-9afe-554a3316e654 | 1TY | BGR GOVERNMENT AFFAIRS | 5357 | CREDIT SUISSE SECURITIES (USA) LLC | 2025 | first_quarter | 0 | 1 | 2025-02-18T15:59:07-05:00 | |||||
| 3327493 | BGR GOVERNMENT AFFAIRS 4ffeca1c-3135-4ef1-975d-ee8984e80ce1 | 1T | BGR GOVERNMENT AFFAIRS | 5357 | 7 ELEVEN, INC. | 2025 | first_quarter | ECN | Provide strategic counsel and advocacy for issues related to swipe fees and other matters affecting 7 Eleven, Inc. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2025-02-18T16:01:45-05:00 | |
| 3327494 | ARK STRATEGY 7e544008-f981-43b3-ac53-182c8407cc89 | 1TY | ARK STRATEGY | 401108659 | EVOLUTION SPACE, INC. | 2025 | first_quarter | 10000 | 0 | 1 | 2025-02-20T08:00:00-05:00 | ||||
| 3327495 | AKIN GUMP STRAUSS HAUER & FELD d08e2285-7308-4318-84e4-223a53f7e69f | 1TY | AKIN GUMP STRAUSS HAUER & FELD | 682 | PORT OF CORPUS CHRISTI AUTHORITY | 2025 | first_quarter | 0 | 1 | 2025-02-20T17:21:14-05:00 | |||||
| 3327496 | SQUIRE PATTON BOGGS 98e9f788-0e7b-4a2a-ae78-e519d0296e12 | 1TY | SQUIRE PATTON BOGGS | 30906 | NATIONAL CANNABIS ROUNDTABLE | 2025 | first_quarter | 0 | 1 | 2025-02-21T13:22:52-05:00 | |||||
| 3327497 | NELSON MULLINS RILEY & SCARBOROUGH ed9e0f93-7e8e-4e5d-958c-066d69382fb2 | 1T | NELSON MULLINS RILEY & SCARBOROUGH | 285871 | GENESIS HEALTHCARE, INC. | 2025 | first_quarter | HCR | 340B Drug Pricing Program | 10000 | 0 | 1 | 2025-02-21T15:20:22-05:00 | ||
| 3327498 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) 2921c515-cdb0-4f44-b92e-1a672fa990b5 | Q1 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) | 401108257 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA RCI FOR CAREGIVING) | 2025 | first_quarter | BUD | FY25 Appropriations - family caregivers | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2025-02-21T15:44:44-05:00 | |
| 3327499 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) 2921c515-cdb0-4f44-b92e-1a672fa990b5 | Q1 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) | 401108257 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA RCI FOR CAREGIVING) | 2025 | first_quarter | HCR | Family Caregiver issues (Office of Caregiver Health, Alleviating Barriers for Caregivers (ABC) Act, Lifespan Respite Reauthorization Act, Physician Fee Schedule paid caregiver training in Medicare implementation, Older Americans Act Reauthorization, caregiver mental health) | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2025-02-21T15:44:44-05:00 | |
| 3327500 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) 2921c515-cdb0-4f44-b92e-1a672fa990b5 | Q1 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) | 401108257 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA RCI FOR CAREGIVING) | 2025 | first_quarter | MMM | Family Caregiver issues (Physician Fee Schedule paid caregiver training in Medicare implementation, Older Americans Act Reauthorization) | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2025-02-21T15:44:44-05:00 | |
| 3327501 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) 2921c515-cdb0-4f44-b92e-1a672fa990b5 | Q1 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) | 401108257 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA RCI FOR CAREGIVING) | 2025 | first_quarter | TAX | Family Caregivers (Credit for Caring Act - family caregiver tax credit) | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 0 | 2025-02-21T15:44:44-05:00 | |
| 3327502 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) 08f9f1e5-dc52-405c-9c95-9b74d9a7c858 | 1T | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA ROSALYNN CARTER INSTITUTE FOR CAREGIVING) | 401108257 | ROSALYNN CARTER INSTITUTE FOR CAREGIVERS (FKA RCI FOR CAREGIVING) | 2025 | first_quarter | BUD | FY25 Appropriations - family caregivers | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2025-02-21T15:56:46-05: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);