lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
46,396 rows where filing_period = "fourth_quarter" and filing_year = 2023 sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: filing_type, is_termination, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3045093 | ALCALDE & FAY e1fa6e64-3e24-4671-a615-6112629a09c9 | 4T | ALCALDE & FAY | 818 | APPLIED RESEARCH ASSOCIATES, INC. | 2023 | fourth_quarter | BUD | Advocated for funding within the Fiscal Year 2024 Defense Appropriations bill. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-10-05T11:34:39-04:00 | |
| 3045737 | CONGRESSIONAL STRATEGIES LLC cdc1df5e-28f6-4cca-9be2-e4ad1c4af258 | Q4 | CONGRESSIONAL STRATEGIES LLC | 58636 | ENERSYS ADVANCE SYSTEMS INC | 2023 | fourth_quarter | DEF | THERMAL BATTERIES | HOUSE OF REPRESENTATIVES | 7500 | 0 | 0 | 2023-10-06T16:09:33-04:00 | |
| 3056355 | KIANA MOORE 7cf21280-a0f1-426e-8086-2fa261397cae | Q4 | KIANA MOORE | 401107387 | AMERICAN STATISTICAL ASSOCIATION | 2023 | fourth_quarter | SCI | H.R.1050 - Data Science and Literacy Act of 2023 | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2023-10-18T13:00:34-04:00 | |
| 3056356 | KIANA MOORE 7cf21280-a0f1-426e-8086-2fa261397cae | Q4 | KIANA MOORE | 401107387 | AMERICAN STATISTICAL ASSOCIATION | 2023 | fourth_quarter | EDU | H.R.1050 - Data Science and Literacy Act of 2023 | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2023-10-18T13:00:34-04:00 | |
| 3063952 | WIDERCHANGE LLC 0cd1c025-e989-4552-bb5b-b96b35282722 | 4TY | WIDERCHANGE LLC | 401107228 | PHOENIX ZONES INITIATIVE | 2023 | fourth_quarter | 0 | 1 | 2023-10-19T15:45:50-04:00 | |||||
| 3064148 | WIDERCHANGE LLC 16697c5a-a62d-4fc8-82a0-05c72483f6fe | 4@Y | WIDERCHANGE LLC | 401107228 | PHOENIX ZONES INITIATIVE | 2023 | fourth_quarter | 0 | 1 | 2023-10-19T15:56:23-04:00 | |||||
| 3068747 | HEALTHCARE LEGAL RESOURCES NETWORK, LLC 92a0d897-9e66-4474-99f6-77fe8fbb9955 | 4T | HEALTHCARE LEGAL RESOURCES NETWORK, LLC | 401107302 | HEALTHCARE LEGAL RESOURCES NETWORK, LLC | 2023 | fourth_quarter | SCI | Vaccines | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2023-10-20T09:29:17-04:00 | ||
| 3068748 | HEALTHCARE LEGAL RESOURCES NETWORK, LLC 92a0d897-9e66-4474-99f6-77fe8fbb9955 | 4T | HEALTHCARE LEGAL RESOURCES NETWORK, LLC | 401107302 | HEALTHCARE LEGAL RESOURCES NETWORK, LLC | 2023 | fourth_quarter | MED | Pharmaceutical | Federal Aviation Administration (FAA),Homeland Security, Dept of (DHS),SENATE | 0 | 1 | 2023-10-20T09:29:17-04:00 | ||
| 3076416 | KYLE HOUSE GROUP e33bcef6-e303-49d9-a44f-430429a4a47f | 4TY | KYLE HOUSE GROUP | 400713140 | WILLIAM CARTER COMPANY, INC. | 2023 | fourth_quarter | 0 | 1 | 2023-10-20T14:19:47-04:00 | |||||
| 3079946 | FIFESTRATEGIES, LLC b629e0c1-ea6d-43b2-bb2b-16830e2ca692 | 4T | FIFESTRATEGIES, LLC | 400586788 | AEROJET ROCKETDYNE, AN L3HARRIS TECHNOLOGIES CO (FKA AEROJET ROCKETDYNE INC.) | 2023 | fourth_quarter | BUD | House (HR 4365) and Senate (S 2587) Fiscal Year 2024 Department of Defense Appropriations Bill -- issues and funding related to propulsion systems for tactical missiles, strategic systems, hypersonics, Missile Defense Agency programs, space launch and satellites. House (HR 5893) and Senate (S 2321) Fiscal Year 2024 Commerce, Justice, Science Appropriations Bill -- issues and funding related to propulsion systems, NASA space launch and satellite propulsion programs. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-10-20T16:22:06-04:00 | |
| 3079947 | FIFESTRATEGIES, LLC b629e0c1-ea6d-43b2-bb2b-16830e2ca692 | 4T | FIFESTRATEGIES, LLC | 400586788 | AEROJET ROCKETDYNE, AN L3HARRIS TECHNOLOGIES CO (FKA AEROJET ROCKETDYNE INC.) | 2023 | fourth_quarter | DEF | House (HR 2670) and Senate (S 2226) Fiscal Year 2024 National Defense Authorization Act -- issues and funding related to propulsion systems for tactical missiles, strategic systems, hypersonics, Missile Defense Agency programs, space launch and satellites; and defense industrial base and mergers and acquisition policy matters. | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-10-20T16:22:06-04:00 | |
| 3079948 | FIFESTRATEGIES, LLC b629e0c1-ea6d-43b2-bb2b-16830e2ca692 | 4T | FIFESTRATEGIES, LLC | 400586788 | AEROJET ROCKETDYNE, AN L3HARRIS TECHNOLOGIES CO (FKA AEROJET ROCKETDYNE INC.) | 2023 | fourth_quarter | AER | Monitored space launch and propulsion issues related to NASA, commercial launches and the US military. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-10-20T16:22:06-04:00 | |
| 3085196 | FAMILY POLICY ALLIANCE 290fac30-b6fe-4dcf-997b-bb3b6f25b8fd | Q4 | FAMILY POLICY ALLIANCE | 401107290 | FAMILY POLICY ALLIANCE | 2023 | fourth_quarter | HCR | S.635/H.R.1276-Protecting Minors from Medical Malpractice Act of 2023 H.R.3329/S. 1595 - End Taxpayer Funding of Gender Experimentation Act of 2023 EEOC rule: RIN number 3046-AB30 | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-10-27T00:43:04-04:00 | ||
| 3085232 | VENABLE LLP fec0bcbf-bf79-4b13-bc45-e6157dc1a377 | 4TY | VENABLE LLP | 39941 | MUSCOGEE (CREEK) NATION | 2023 | fourth_quarter | 0 | 1 | 2023-10-27T12:36:47-04:00 | |||||
| 3085270 | MERIDIAN GOVERNMENT RELATIONS 774c8644-1151-4259-a4fb-8c8b2fcc2ead | 4T | MERIDIAN GOVERNMENT RELATIONS | 401106713 | NORTH DAKOTA HOSPITAL ASSOCIATION | 2023 | fourth_quarter | MMM | Congressional monitoring, new Congress and the forthcoming policy items from a new Majority. Informing Members of Congress about issues impacting hospitals. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2023-10-27T15:33:47-04:00 | ||
| 3085271 | MERIDIAN GOVERNMENT RELATIONS 774c8644-1151-4259-a4fb-8c8b2fcc2ead | 4T | MERIDIAN GOVERNMENT RELATIONS | 401106713 | NORTH DAKOTA HOSPITAL ASSOCIATION | 2023 | fourth_quarter | HCR | Congressional monitoring, new Congress and the forthcoming policy items from a new Majority. Informing Members of Congress about issues impacting hospitals. | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2023-10-27T15:33:47-04:00 | ||
| 3085285 | 38 NORTH SOLUTIONS, LLC a0d27ef6-f76d-48e9-a93e-4197369e4076 | 4TY | 38 NORTH SOLUTIONS, LLC | 400944730 | ADVANCED ENERGY MANAGEMENT ALLIANCE | 2023 | fourth_quarter | 20000 | 0 | 1 | 2023-10-27T16:10:22-04:00 | ||||
| 3085314 | FAMILY POLICY ALLIANCE 983f5393-da16-4d22-be70-af2e21fda56c | 4T | FAMILY POLICY ALLIANCE | 401107290 | FAMILY POLICY ALLIANCE | 2023 | fourth_quarter | HCR | S.635/H.R.1276-Protecting Minors from Medical Malpractice Act of 2023 H.R.3329/S. 1595 - End Taxpayer Funding of Gender Experimentation Act of 2023 EEOC rule: RIN number 3046-AB30 | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2023-10-27T22:09:06-04:00 | ||
| 3085481 | DENBURY INC. 1c65d4ce-680e-46f4-990b-f4b22a73ec98 | 4T | DENBURY INC. | 400469321 | DENBURY INC | 2023 | fourth_quarter | ENG | S.542; H.R. 1262; H.R. 2670; S. 2226; H.R. 4365 | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2023-10-31T11:42:48-04:00 | ||
| 3085685 | KEY BRIDGE ADVISORS f30dba2f-1327-4370-824e-e7933b691fce | 4TY | KEY BRIDGE ADVISORS | 401105296 | FLEXA INC. | 2023 | fourth_quarter | 0 | 1 | 2023-11-01T12:07:52-04:00 | |||||
| 3085795 | CYRRUS ANALYTICS LLC 1ca2224a-ee13-4cfb-a1b1-cbc231da4f89 | 4TY | CYRRUS ANALYTICS LLC | 401103558 | ALLIANCE FOR DIGITAL INNOVATION | 2023 | fourth_quarter | 30000 | 0 | 1 | 2023-11-02T11:21:54-04:00 | ||||
| 3085885 | KILEY & ASSOCIATES 49239a08-a00c-4ba0-9d0b-7e27bb8fdc6a | 4T | KILEY & ASSOCIATES | 401106268 | CITY OF BAKERSFIELD | 2023 | fourth_quarter | BUD | FY 2024 Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 0 | 1 | 2023-11-03T09:31:19-04:00 | ||
| 3085937 | VIR BIOTECHNOLOGY, INC. 38839f74-d8c8-477c-91be-44d0b2d08442 | 4T | VIR BIOTECHNOLOGY, INC. | 401106205 | VIR BIOTECHNOLOGY, INC. | 2023 | fourth_quarter | HCR | Pandemic Preparedness Funding, Influenza Preparedness; COVID-19 Response and Therapeutics Procurement and Distribution; FY 2024 Labor-HHS Appropriations; Pandemic and All-Hazards Preparedness Act Reauthorization | Centers For Disease Control & Prevention (CDC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Science & Technology Policy (OSTP),SENATE | 70000 | 0 | 1 | 2023-11-03T15:19:02-04:00 | |
| 3085938 | VIR BIOTECHNOLOGY, INC. 38839f74-d8c8-477c-91be-44d0b2d08442 | 4T | VIR BIOTECHNOLOGY, INC. | 401106205 | VIR BIOTECHNOLOGY, INC. | 2023 | fourth_quarter | SCI | Pandemic Preparedness; Biomanufacturing | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Natl Institutes of Health (NIH),Office of Science & Technology Policy (OSTP),SENATE | 70000 | 0 | 1 | 2023-11-03T15:19:02-04:00 | |
| 3085939 | VIR BIOTECHNOLOGY, INC. 38839f74-d8c8-477c-91be-44d0b2d08442 | 4T | VIR BIOTECHNOLOGY, INC. | 401106205 | VIR BIOTECHNOLOGY, INC. | 2023 | fourth_quarter | MMM | Inflation Reduction Act Rx Provisions Implementation; S. 476, Maintaining Investments in New Innovation Act | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE | 70000 | 0 | 1 | 2023-11-03T15:19:02-04:00 | |
| 3085940 | VIR BIOTECHNOLOGY, INC. 38839f74-d8c8-477c-91be-44d0b2d08442 | 4T | VIR BIOTECHNOLOGY, INC. | 401106205 | VIR BIOTECHNOLOGY, INC. | 2023 | fourth_quarter | TAX | S. 866, American Innovation and Jobs Act; H.R. 2673, American Innovation and R&D Competitiveness Act; H.R. 3938, Build It In America Act | HOUSE OF REPRESENTATIVES,SENATE | 70000 | 0 | 1 | 2023-11-03T15:19:02-04:00 | |
| 3085941 | VIR BIOTECHNOLOGY, INC. 38839f74-d8c8-477c-91be-44d0b2d08442 | 4T | VIR BIOTECHNOLOGY, INC. | 401106205 | VIR BIOTECHNOLOGY, INC. | 2023 | fourth_quarter | TRD | COVID-19 Trade Related Aspects of Intellectual Property Rights Waiver | HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),SENATE,U.S. International Trade Commission (ITC),White House Office | 70000 | 0 | 1 | 2023-11-03T15:19:02-04:00 | |
| 3085999 | FRONTLINE PUBLIC STRATEGIES, INC. 831077b5-fc2a-438c-9fec-79c5215bbe65 | 4A | FRONTLINE PUBLIC STRATEGIES, INC. | 291093 | ILLINOIS HOMECARE & HOSPICE COUNCIL | 2023 | fourth_quarter | HCR | issues related to home health care | Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2023-11-06T11:59:27-05:00 | ||
| 3086074 | CLASSIFIED POLITICAL CONSULTANTS LLC. afc4cbf2-34b5-4a61-9c78-68e53b5f8e98 | Q4Y | CLASSIFIED POLITICAL CONSULTANTS LLC. | 401107353 | CLASSIFIED POLITICAL CONSULTANTS LLC. | 2023 | fourth_quarter | 0 | 0 | 2023-11-06T20:21:35-05:00 | |||||
| 3086100 | THE PRENDA GROUP LLC 15d4e8ac-13df-4644-a969-4b2458e9057d | 4TY | THE PRENDA GROUP LLC | 401104543 | INDRA SISTEMAS | 2023 | fourth_quarter | 0 | 1 | 2023-11-07T15:37:46-05:00 | |||||
| 3086104 | THE PRENDA GROUP LLC 2bef5cea-2188-461f-9873-4f44d601d4c1 | 4TY | THE PRENDA GROUP LLC | 401104543 | OTOTRONIX LLC | 2023 | fourth_quarter | 0 | 1 | 2023-11-07T15:42:35-05:00 | |||||
| 3086253 | CALGON CARBON CORPORATION a1b45872-d8cc-4d64-bbfd-a762a726ba9e | 4TY | CALGON CARBON CORPORATION | 400589799 | CALGON CARBON CORPORATION | 2023 | fourth_quarter | 0 | 1 | 2023-11-10T15:37:57-05:00 | |||||
| 3086278 | BECKER & POLIAKOFF, P.A. 378cc6d3-b225-4072-be3e-b5d2861bfa2a | 4T | BECKER & POLIAKOFF, P.A. | 283696 | OZINGA READY MADE CONCRETE, INC. | 2023 | fourth_quarter | TRA | Port Infrastructure Development Program | HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 10000 | 0 | 1 | 2023-11-13T11:19:34-05:00 | |
| 3086318 | NVG, LLC 3af18f69-99f9-42f4-9448-0dd3ae1b4445 | 4T | NVG, LLC | 76833 | COMMUNITY JUSTICE ACTION FUND | 2023 | fourth_quarter | LAW | Issues related to implementation of the Bipartisan Safer Communities Act, gun safety and community violence intervention programs. Issues related to gun violence. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-11-13T14:40:22-05:00 | |
| 3086319 | COVINGTON & BURLING LLP 9142beb0-34d0-49d9-872c-7f21ae93a3e0 | 4TY | COVINGTON & BURLING LLP | 11195 | NEW VENTURE FUND | 2023 | fourth_quarter | 0 | 1 | 2023-11-13T15:10:07-05:00 | |||||
| 3086737 | THE NICKLES GROUP, LLC 5723ed79-c833-466f-9db7-b0ea11112a6c | 4TY | THE NICKLES GROUP, LLC | 293335 | CONNECTED DMV | 2023 | fourth_quarter | 0 | 1 | 2023-11-14T18:29:10-05:00 | |||||
| 3086790 | FAEGRE DRINKER BIDDLE & REATH LLP 1f7b4255-2118-4bca-96ba-88ff7b6e88da | 4T | FAEGRE DRINKER BIDDLE & REATH LLP | 12631 | STEP ONE FOODS | 2023 | fourth_quarter | HCR | Issues around food as medicine interventions in the Medicare program. | 0 | 1 | 2023-11-15T10:39:27-05:00 | |||
| 3086862 | K&L GATES, LLP ec9ea9eb-b740-44ee-9ebf-e2052e8304fb | 4TY | K&L GATES, LLP | 32098 | ABPRO CORPORATION | 2023 | fourth_quarter | 0 | 1 | 2023-11-15T15:32:41-05:00 | |||||
| 3087004 | EJK, LLC 7f625f60-21fd-4585-b20c-cc545344ed68 | 4TY | EJK, LLC | 401105478 | AMERICANS FOR TRANSPARENCY AND ACCOUNTABILITY | 2023 | fourth_quarter | 0 | 1 | 2023-11-17T11:39:57-05:00 | |||||
| 3087041 | ALSTON & BIRD LLP 9112684c-41fe-41c1-bc7f-68b6d2e4e657 | 4T | ALSTON & BIRD LLP | 1182 | PREMIER, INC. | 2023 | fourth_quarter | MMM | Issues regarding group purchasing organizations, drug pricing, drug shortages and health care delivery reform. | Centers For Medicare and Medicaid Services (CMS),Executive Office of the President (EOP),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office | 30000 | 0 | 1 | 2023-11-17T15:53:03-05:00 | |
| 3087222 | NICHERAPPORT LLC 961ca5f2-6590-4498-a7a7-74c76438b2f4 | Q4 | NICHERAPPORT LLC | 401106059 | NUCLEAR INNOVATION ALLIANCE | 2023 | fourth_quarter | ENG | Nuclear Regulatory Commission reform Energy and Water Appropriations | 15000 | 0 | 0 | 2023-11-20T11:12:08-05:00 | ||
| 3087510 | BC CONSULTING, LLC 42369203-e13e-4220-aaa5-dde3f034d933 | 4T | BC CONSULTING, LLC | 401104213 | ROAD SAFE AMERICA | 2023 | fourth_quarter | TRA | Transportation issues | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-11-20T13:30:18-05:00 | |
| 3087953 | OIL COMPANIES INTERNATIONAL MARINE FORUM 40b47d74-4aa1-4f5a-8745-ae146efb642d | Q4Y | OIL COMPANIES INTERNATIONAL MARINE FORUM | 299274 | OIL COMPANIES INTERNATIONAL MARINE FORUM | 2023 | fourth_quarter | 0 | 0 | 2023-11-22T10:17:42-05:00 | |||||
| 3087958 | FORBES-TATE e8c4ca4b-5ab7-4409-8782-9c75c1693dcc | 4T | FORBES-TATE | 400976792 | AMERICAN HOTEL & LODGING ASSOCIATION | 2023 | fourth_quarter | TAX | Issues related to hotel and lodging industry; Issues related to online booking scams; Issues related to 1099 forms. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2023-11-22T11:40:43-05:00 | |
| 3087959 | FORBES-TATE e8c4ca4b-5ab7-4409-8782-9c75c1693dcc | 4T | FORBES-TATE | 400976792 | AMERICAN HOTEL & LODGING ASSOCIATION | 2023 | fourth_quarter | LBR | Issues related to hotel and lodging industry. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2023-11-22T11:40:43-05:00 | |
| 3087960 | FORBES-TATE e8c4ca4b-5ab7-4409-8782-9c75c1693dcc | 4T | FORBES-TATE | 400976792 | AMERICAN HOTEL & LODGING ASSOCIATION | 2023 | fourth_quarter | CSP | Issues related to hotel and lodging industry; Issues related to hotel resort fees. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2023-11-22T11:40:43-05:00 | |
| 3087961 | FORBES-TATE 05bf99d5-97b9-4769-a165-c6b1f782767b | 4TY | FORBES-TATE | 400976792 | HD NURSING | 2023 | fourth_quarter | 0 | 1 | 2023-11-22T11:44:38-05:00 | |||||
| 3088188 | BCE CORPORATION PMC c2fe1286-57df-4915-853d-bee8a23d0b61 | 4AY | BCE CORPORATION PMC | 401108033 | BCE CORPORATION PMC | 2023 | fourth_quarter | 0 | 0 | 2023-11-28T10:49:40-05:00 | |||||
| 3088202 | COVINGTON & BURLING LLP c30fec6d-af0b-4d13-98dd-657dc56ba955 | 4TY | COVINGTON & BURLING LLP | 11195 | SNOW JOE LLC | 2023 | fourth_quarter | 0 | 1 | 2023-11-28T11:28:03-05:00 | |||||
| 3088301 | WEXFORD STRATEGIES 05d8b2d1-b7a0-4ea7-ac52-dc779da01c23 | Q4 | WEXFORD STRATEGIES | 400798394 | CONSUMER ENERGY ALLIANCE | 2023 | fourth_quarter | ENG | Energy | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 0 | 2023-11-29T09:08:02-05:00 | |
| 3088421 | BGR GOVERNMENT AFFAIRS ddaf4031-a5da-4dfc-8416-566e6cb99471 | 4TY | BGR GOVERNMENT AFFAIRS | 5357 | WORLD DOG ALLIANCE (HONG KONG) LIMITED | 2023 | fourth_quarter | 0 | 1 | 2023-11-29T17:51:50-05:00 | |||||
| 3088430 | AKIN GUMP STRAUSS HAUER & FELD 76436734-7c49-47a4-8bb9-f8329bdeea2b | 4TY | AKIN GUMP STRAUSS HAUER & FELD | 682 | ALLEGIANT TRAVEL COMPANY | 2023 | fourth_quarter | 30000 | 0 | 1 | 2023-11-30T11:09:18-05:00 | ||||
| 3088431 | THE MCKEON GROUP, INC. 22d1120b-2c04-4e1d-b315-444340b51dd4 | Q4 | THE MCKEON GROUP, INC. | 401103598 | BOSSIER PARISH POLICE JURY | 2023 | fourth_quarter | DEF | CYBERSECURITY AND CYBER-RELATED POLICY ISSUES RELATED TO WORKFORCE DEVELOPMENT; NUCLEAR ENTERPRISE MODERNIZATION; INNOVATION AND TECHNOLOGY TRANSFER POLICY ISSUES; DEFENSE APPROPRIATIONS AND AUTHORIZATION ISSUES RELATED TO CYBERSECURITY, NUCLEAR ENTERPRISE MODERNIZATION, INNOVATION, AND TECHNOLOGY TRANSFER | Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE | 75000 | 0 | 0 | 2023-11-30T11:18:11-05:00 | |
| 3088432 | THE MCKEON GROUP, INC. 22d1120b-2c04-4e1d-b315-444340b51dd4 | Q4 | THE MCKEON GROUP, INC. | 401103598 | BOSSIER PARISH POLICE JURY | 2023 | fourth_quarter | HOM | CYBERSECURITY AND CYBER RELATED WORKFORCE AND OTHER POLICY ISSUES. HOMELAND SECURITY APPROPRIATIONS AND AUTHORIZATION ISSUES RELATED TO CYBERSECURITY CYBER RELATED WORKFORCE AND OTHER POLICY ISSUES. | Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE | 75000 | 0 | 0 | 2023-11-30T11:18:11-05:00 | |
| 3088463 | UNITY SOFTWARE, INC. b7739219-bbc8-448a-8671-666e65d4fdde | 4T | UNITY SOFTWARE, INC. | 401106592 | UNITY SOFTWARE, INC. | 2023 | fourth_quarter | SCI | Issues related to technology; immersive technologies, including artificial intelligence, virtual reality, and digital twins; childrens online safety; privacy and data protection. | HOUSE OF REPRESENTATIVES,SENATE | 50000 | 0 | 1 | 2023-12-01T00:48:58-05:00 | |
| 3088464 | CSS PARTNERS, LLC eadd3d4c-4381-4db8-b6f0-204e46257bd7 | 4T | CSS PARTNERS, LLC | 401104724 | HILLIARY COMMUNICATIONS LLC | 2023 | fourth_quarter | TEC | Issues related to broadband funding. | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2023-12-01T10:30:51-05:00 | |
| 3088465 | RANDSTAD NORTH AMERICA 12973024-4be0-4f66-8cd0-9ea71d733bc8 | Q4 | RANDSTAD NORTH AMERICA | 401106140 | RANDSTAD NORTH AMERICA | 2023 | fourth_quarter | LBR | labor and workforce, job training, short term pell, worker shortage | HOUSE OF REPRESENTATIVES,SENATE | 38000 | 0 | 0 | 2023-12-01T10:37:53-05:00 | |
| 3088466 | RANDSTAD NORTH AMERICA 12973024-4be0-4f66-8cd0-9ea71d733bc8 | Q4 | RANDSTAD NORTH AMERICA | 401106140 | RANDSTAD NORTH AMERICA | 2023 | fourth_quarter | TAX | EITC, Worker Opportunity Tax Credit | HOUSE OF REPRESENTATIVES,SENATE | 38000 | 0 | 0 | 2023-12-01T10:37:53-05:00 | |
| 3088467 | RANDSTAD NORTH AMERICA 12973024-4be0-4f66-8cd0-9ea71d733bc8 | Q4 | RANDSTAD NORTH AMERICA | 401106140 | RANDSTAD NORTH AMERICA | 2023 | fourth_quarter | EDU | Job retraining, pell grants | HOUSE OF REPRESENTATIVES,SENATE | 38000 | 0 | 0 | 2023-12-01T10:37:53-05:00 | |
| 3088473 | JEAN MARIE CONSULTING, LLC a5f33a20-40f4-4d92-a817-af0b8587b7ad | 4T | JEAN MARIE CONSULTING, LLC | 401105465 | FREEDOM FOUNDATION | 2023 | fourth_quarter | EDU | union reform | HOUSE OF REPRESENTATIVES,SENATE | 20000 | 0 | 1 | 2023-12-01T11:19:59-05:00 | |
| 3088546 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC c94ce76a-baf5-4798-99fe-273ca169f904 | Q4 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC | 401103935 | TAIYO NIPPON SANSO CORP. | 2023 | fourth_quarter | AUT | GaN power transistors for electric vehicle batteries | Energy, Dept of | 20000 | 0 | 0 | 2023-12-04T15:08:28-05:00 | |
| 3088547 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC c94ce76a-baf5-4798-99fe-273ca169f904 | Q4 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC | 401103935 | TAIYO NIPPON SANSO CORP. | 2023 | fourth_quarter | SCI | GaN power transistors for electric vehicle batteries | Energy, Dept of | 20000 | 0 | 0 | 2023-12-04T15:08:28-05:00 | |
| 3088548 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC c94ce76a-baf5-4798-99fe-273ca169f904 | Q4 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC | 401103935 | TAIYO NIPPON SANSO CORP. | 2023 | fourth_quarter | ENG | supporting the development of multijunction III-V solar cells | Energy, Dept of | 20000 | 0 | 0 | 2023-12-04T15:08:28-05:00 | |
| 3088549 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC 93412c5b-5ef3-4d6e-98eb-e9572d1c98af | Q4 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC | 401103935 | ASSOCIATION OF FLIGHT ATTENDANTS-CWA | 2023 | fourth_quarter | AVI | Improving cabin air quality, providing pump guidance for crewmembers, reducing air turbulence, improving crew member self-defense training courses, deterring disruptive passengers, establishing cabin air temperature standards, and protecting aviation jobs in H.R. 3935, The Securing Growth and Robust Leadership in American Aviation Act and S.1939, the FAA Reauthorization Act of 2023. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2023-12-04T15:09:52-05:00 | |
| 3088550 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC 93412c5b-5ef3-4d6e-98eb-e9572d1c98af | Q4 | SARAH BLACKWOOD GOVERNMENT RELATIONS, LLC | 401103935 | ASSOCIATION OF FLIGHT ATTENDANTS-CWA | 2023 | fourth_quarter | LBR | Improving cabin air quality, providing pump guidance for crewmembers, reducing air turbulence, improving crew member self-defense training courses, deterring disruptive passengers, establishing cabin air temperature standards, and protecting aviation jobs in H.R. 3935, The Securing Growth and Robust Leadership in American Aviation Act and S.1939, the FAA Reauthorization Act of 2023. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2023-12-04T15:09:52-05:00 | |
| 3088665 | THE FERGUSON GROUP 5a593ec6-c361-46e6-9c9d-4066766dd6b2 | 4T | THE FERGUSON GROUP | 14451 | SOMACH SIMMONS & DUNN ON BEHALF OF STATE OF TEXAS | 2023 | fourth_quarter | NAT | Endangered Species Act (ESA) consultation with federal and local agencies regarding ESA, and H.R. 4891/S. 2718/H.R. 2 - New Mexico provisions of the Western Water Security Act. Legislation pertaining to the Rio Grande Compact of 1936. US Supreme Court - Texas vs New Mexico | Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Council on Environmental Quality (CEQ),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Justice, Dept of (DOJ),Office of Management & Budget (OMB),SENATE | 0 | 1 | 2023-12-05T22:36:43-05:00 | ||
| 3088708 | EMERGENCY DEPARTMENT PRACTICE MANAGEMENT ASSOCIATION 84ae0045-7318-4f66-aa9f-2ed6246b28a9 | Q4 | EMERGENCY DEPARTMENT PRACTICE MANAGEMENT ASSOCIATION | 400316484 | EMERGENCY DEPARTMENT PRACTICE MANAGEMENT ASSOCIATION | 2023 | fourth_quarter | HCR | HR 2474 - Strengthening Medicare For Patients and Providers to reform the Medicare Physician Fee Schedule by (1) fully offsetting the 3.4% reduction planned for 2024, (2) providing an annual inflationary update, and (3) modernizing the budget neutrality requirement. HR 2584 / S 2768 - Safety From Violence for Healthcare Employees (SAVE) Act to advance bipartisan support of the Safety from Violence for Healthcare Employees (SAVE) Act Enforce implementation of the No Surprises Act to provide continued and impacting oversight of HHS, to improve enforcement mechanisms that protect patients and ensure smooth implementation including: Create penalties for payers who fail to meet the statutory payment deadline of 30 days following a determination made by the independent dispute resolution (IDR) entity. Create penalties for statutory violations of patient protections by payers that mirror the penalties for similar violations by providers. Provide additional transparency requirements. To permanently halt the implementation of the G2211 add-on code that will cut Medicare payments to emergency physicians and other medical practices. Rural Health - Improving Access to Health Care in Rural and Underserved Areas To reauthorize the Pandemic and All-Hazards Preparedness Act (PAHPA) to better position our country to prevent, prepare for and respond to national health security threats. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,Treasury, Dept of | 7500 | 0 | 0 | 2023-12-06T13:46:57-05:00 | |
| 3088709 | EMERGENCY DEPARTMENT PRACTICE MANAGEMENT ASSOCIATION 84ae0045-7318-4f66-aa9f-2ed6246b28a9 | Q4 | EMERGENCY DEPARTMENT PRACTICE MANAGEMENT ASSOCIATION | 400316484 | EMERGENCY DEPARTMENT PRACTICE MANAGEMENT ASSOCIATION | 2023 | fourth_quarter | MMM | Comment letters submitted to CMS on the Physician Fee Schedule Proposed Rule and the 2024 Hospital Outpatient Prospective Payment System (OPPS) proposed rules. Fixing the implementation of the No Surprises Act | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Justice, Dept of (DOJ),Labor, Dept of (DOL),SENATE,Treasury, Dept of | 7500 | 0 | 0 | 2023-12-06T13:46:57-05:00 | |
| 3088710 | NATIONAL INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION 344715d9-2495-4b96-91fd-2afef68b4cb3 | Q4Y | NATIONAL INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION | 401105858 | NATIONAL INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION | 2023 | fourth_quarter | 0 | 0 | 2023-12-06T13:47:04-05:00 | |||||
| 3088719 | T A BUSINESS DEVELOPMENT, LLC 331c4e20-5a18-421c-97fe-07fdc958f0a1 | 4TY | T A BUSINESS DEVELOPMENT, LLC | 401106391 | PCS WIRELESS, LLC | 2023 | fourth_quarter | 0 | 1 | 2023-12-06T16:22:50-05:00 | |||||
| 3088720 | SPLYSS LLC 3a238548-ae42-4210-af4b-746cabab73ea | Q4 | SPLYSS LLC | 401105022 | DAHLBERG STRATEGIC ON BEHALF OF HUNTINGTON INGALLS | 2023 | fourth_quarter | DEF | Aircraft Carriers and Appropriations | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 0 | 2023-12-06T17:03:04-05:00 | |
| 3088721 | SPLYSS LLC 3a238548-ae42-4210-af4b-746cabab73ea | Q4 | SPLYSS LLC | 401105022 | DAHLBERG STRATEGIC ON BEHALF OF HUNTINGTON INGALLS | 2023 | fourth_quarter | BUD | Aircraft Carriers | HOUSE OF REPRESENTATIVES,SENATE | 5000 | 0 | 0 | 2023-12-06T17:03:04-05:00 | |
| 3088722 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | CIV | In favor of statutory protections for the privacy of people in the United States and against government acquisition of Fourth Amendment-protected information, including in support of the Fourth Amendment Is Not For Sale Act (H.R. 4639) and against reauthorization of Section 702 of FISA. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088723 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | CON | In favor of statutory protections for the privacy of people in the United States and against government acquisition of Fourth Amendment-protected information, including in support of the Fourth Amendment Is Not For Sale Act (H.R. 4639) and against reauthorization of Section 702 of FISA. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088724 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | FOR | In support of reducing militarism and strengthening diplomatic resolution to conflicts. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088725 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | DEF | In support of reducing militarism and strengthening diplomatic resolution to conflicts. In favor of the Davidson-Jacobs amendment to the NDAA for 2024 prohibiting Dept. of Defense from purchasing Fourth Amendment-protected information without a warrant. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088726 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | GOV | In support of government accountability and transparency, including in support of the SUNLIGHT Act. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088727 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | INT | In favor of statutory protections for the privacy of people in the United States and against government acquisition of Fourth Amendment-protected information, including in support of the Fourth Amendment Is Not For Sale Act (H.R. 4639) and against reauthorization of Section 702 of FISA. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088728 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | LAW | In favor of statutory protections for the privacy of people in the United States and against government acquisition of Fourth Amendment-protected information, including in support of the Fourth Amendment Is Not For Sale Act (H.R. 4639) and against reauthorization of Section 702 of FISA. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088729 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | LBR | In support of strengthening antitrust laws. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088730 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | BUD | In support of appropriations requirements to strengthen transparency within DOJ's Office of Legal Counsel and around intelligence surveillance, and in support of United States support for the Open Technology Fund. | HOUSE OF REPRESENTATIVES,SENATE | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088731 | PALE BLUE, LLC c6da4241-d0d4-427a-9fb9-55784554e2ac | 4T | PALE BLUE, LLC | 401103835 | DEMAND PROGRESS ACTION, INC. | 2023 | fourth_quarter | CSP | In favor of enforcing and updating privacy protections for consumers whose information is sold commercially, for instance by data brokers, and then purchased without court orders by government entities. | Consumer Financial Protection Bureau (CFPB) | 10000 | 0 | 1 | 2023-12-07T13:21:29-05:00 | |
| 3088825 | THE PETERSON GROUP INC cf7c4ee0-5fb6-4297-9cb6-0b2bcf2b0f01 | 4TY | THE PETERSON GROUP INC | 401106416 | CATTLEMEN'S HERITAGE BEEF COMPANY | 2023 | fourth_quarter | 10000 | 0 | 1 | 2023-12-11T13:13:38-05:00 | ||||
| 3088848 | MEHLMAN CONSULTING, INC. 35adc4ce-681c-4be5-9dc9-0f38b1c727b0 | 4T | MEHLMAN CONSULTING, INC. | 284950 | SCRIBEAMERICA | 2023 | fourth_quarter | CSP | Monitoring Healthcare AI legislation. | 20000 | 0 | 1 | 2023-12-12T12:48:48-05:00 | ||
| 3088849 | MEHLMAN CONSULTING, INC. 35adc4ce-681c-4be5-9dc9-0f38b1c727b0 | 4T | MEHLMAN CONSULTING, INC. | 284950 | SCRIBEAMERICA | 2023 | fourth_quarter | HCR | Monitoring healthcare workforce issues and healthcare AI legislation. | 20000 | 0 | 1 | 2023-12-12T12:48:48-05:00 | ||
| 3088850 | MEHLMAN CONSULTING, INC. 35adc4ce-681c-4be5-9dc9-0f38b1c727b0 | 4T | MEHLMAN CONSULTING, INC. | 284950 | SCRIBEAMERICA | 2023 | fourth_quarter | SCI | Monitoring healthcare workforce issues and healthcare AI legislation. | 20000 | 0 | 1 | 2023-12-12T12:48:48-05:00 | ||
| 3088855 | IQOM STRATEGIC ADVISORS, LLC 9384fe53-fc0a-42dd-a4f2-6b4c22ca3b86 | Q4 | IQOM STRATEGIC ADVISORS, LLC | 401105233 | CONSEJO COORDINADOR EMPRESARIAL | 2023 | fourth_quarter | TRD | Promotion of US Mexico trade relationship | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,State, Dept of (DOS),U.S. Trade Representative (USTR) | 70000 | 0 | 0 | 2023-12-12T17:35:26-05:00 | |
| 3088865 | LIEBMAN & ASSOCIATES, INC. 11874576-868d-4d6e-ba60-07ed69b77c39 | 4TY | LIEBMAN & ASSOCIATES, INC. | 46585 | RENEWCO2, INC. | 2023 | fourth_quarter | 0 | 1 | 2023-12-13T12:30:23-05:00 | |||||
| 3088866 | LIEBMAN & ASSOCIATES, INC. 16167bd6-61ce-4109-9a8d-5761de673ad1 | 4TY | LIEBMAN & ASSOCIATES, INC. | 46585 | ECHOGEN POWER SYSTEMS, LLC | 2023 | fourth_quarter | 0 | 1 | 2023-12-13T12:33:15-05:00 | |||||
| 3088867 | LIEBMAN & ASSOCIATES, INC. aaab691c-62bc-4d8f-b40f-3ec8cb759ed1 | 4TY | LIEBMAN & ASSOCIATES, INC. | 46585 | WEC ENERGY GROUP INC. | 2023 | fourth_quarter | 0 | 1 | 2023-12-13T12:34:44-05:00 | |||||
| 3088868 | LIEBMAN & ASSOCIATES, INC. fb4a24e3-41dc-4d20-b26b-b5187814e447 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | TCCI MANUFACTURING | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:39:24-05:00 | |||||
| 3088869 | LIEBMAN & ASSOCIATES, INC. f6872f04-4ffc-4eb9-9ad5-2bc892530e17 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | KIEPE ELECTRIC LLC | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:41:37-05:00 | |||||
| 3088870 | LIEBMAN & ASSOCIATES, INC. 9e1f1220-ed08-43b9-970d-e67a8c263992 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | CENTRIO ENERGY | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:45:40-05:00 | |||||
| 3088871 | LIEBMAN & ASSOCIATES, INC. 841a4c52-d9c2-4c0c-af1c-babdd2536ab0 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | LYONDELLBASELL | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:47:43-05:00 | |||||
| 3088872 | LIEBMAN & ASSOCIATES, INC. 947ac2c2-baa5-4087-abee-bd1c8fc34149 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | IRIDIA, INC. | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:52:34-05:00 | |||||
| 3088873 | LIEBMAN & ASSOCIATES, INC. b8da437e-8d00-471d-8c3d-e3a9e770cb58 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | XCEL ENERGY | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:53:46-05:00 | |||||
| 3088874 | LIEBMAN & ASSOCIATES, INC. 18b423ce-90fe-4a08-ad80-42b5f676412a | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | UNILEVER UNITED STATES | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:54:50-05:00 | |||||
| 3088875 | LIEBMAN & ASSOCIATES, INC. 6f0f210d-a040-428f-a9a3-074c4c75e3dd | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | NEXTERA ENERGY, INC. | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:57:03-05:00 | |||||
| 3088876 | LIEBMAN & ASSOCIATES, INC. 31807149-3f00-47e0-99c0-e3febeeed9e2 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | JACOBS ENGINEERING | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:58:21-05:00 | |||||
| 3088877 | LIEBMAN & ASSOCIATES, INC. d78bca65-9fe1-46a8-a6d5-31502c746812 | Q4Y | LIEBMAN & ASSOCIATES, INC. | 46585 | G14 TECHNOLOGIES, INC. | 2023 | fourth_quarter | 0 | 0 | 2023-12-13T12:59:27-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);