home / lobbying

lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

10,120 rows where filing_period = "second_quarter" and issue_code = "SCI" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

filing_year 18

  • 2025 1,347
  • 2024 868
  • 2023 810
  • 2022 788
  • 2021 661
  • 2020 527
  • 2019 494
  • 2009 473
  • 2010 462
  • 2008 436
  • 2015 418
  • 2014 413
  • 2013 411
  • 2016 409
  • 2018 409
  • 2012 407
  • 2011 397
  • 2017 390

issue_code 1

  • SCI · 10,120 ✖

filing_period 1

  • second_quarter · 10,120 ✖
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
3371994 GRANITE CAPITOL CONSULTING LLC c0876b52-84e1-42f3-868f-811ee9c9c187 Q2 GRANITE CAPITOL CONSULTING LLC 401108946 QURALIS 2025 second_quarter SCI FDA Related issues HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2025-05-05T15:56:17-04:00
3374708 WILLIAM A. COHAN, P.C. f171526c-1f0c-4c04-9808-af6e1ce941e5 2T WILLIAM A. COHAN, P.C. 401108280 TEKLIUM, INC. 2025 second_quarter SCI Communications regarding client's legal rights Justice, Dept of (DOJ)     0 1 2025-06-02T14:11:14-04:00
3375364 LEGO SYSTEMS, INC. a8050929-0ea5-4fac-b809-519d61dfd98f Q2 LEGO SYSTEMS, INC. 401107919 LEGO SYSTEMS, INC. 2025 second_quarter SCI Monitor issues related to children's online safety and privacy HOUSE OF REPRESENTATIVES,SENATE   100000 0 0 2025-06-27T10:25:10-04:00
3375387 NORTH SHORE CONSULTANTS 0c1f3c0c-48e1-44ff-8a46-b9603a14138d Q2 NORTH SHORE CONSULTANTS 29516 OCEAN EXPLORATION TRUST 2025 second_quarter SCI FY 2026 CJS Appropriations Bill HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-06-27T14:21:32-04:00
3375429 NOONE ASSOCIATES, LLC 3656009a-76a1-4ebf-88bf-bbf2e6948e3f Q2 NOONE ASSOCIATES, LLC 401104768 VAN BUSKIRK AND ASSOCIATES 2025 second_quarter SCI Space suits HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-06-30T11:03:41-04:00
3375558 ATOLLETC LLC ca3a163e-870b-4bf9-ba80-71aadfd3b36f Q2 ATOLLETC LLC 401105527 ATOLLETC LLC 2025 second_quarter SCI Education on the importance of digital identity systems and its positive impact for all people throughout the world. Recognition of the first blockchain based country and also opening discussions on the regulatory platform for the metaverse. HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-01T09:56:18-04:00
3375828 STUDENTS FOR SENSIBLE DRUG POLICY 181a7cb4-04bb-4c60-bc18-86c9c5df6c6a Q2 STUDENTS FOR SENSIBLE DRUG POLICY 401105102 STUDENTS FOR SENSIBLE DRUG POLICY 2025 second_quarter SCI Opposition to S. 331 HALT Fentanyl Act Support for psychedelic research and therapy HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-01T14:51:58-04:00
3375914 STRATEGIC PRINCIPLES LLC 36c74818-bd0a-471f-98a7-7e93d6cf352d Q2 STRATEGIC PRINCIPLES LLC 401106789 EVANGELICAL ENVIRONMENTAL NETWORK 2025 second_quarter SCI new technologies for infrastructure strengthening and battery storage capacity for energy. HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2025-07-01T18:47:51-04:00
3375990 MARSHALL BRACHMAN c10bead3-fae5-4d3b-b0af-5a5ee6a6bf9a Q2 MARSHALL BRACHMAN 6848 EDMUND OPTICS INC 2025 second_quarter SCI support STEM funding HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2025-07-01T22:17:40-04:00
3376070 ZERO ONE STRATEGIES f3a3fb64-b579-4ae2-93a1-4480a6f702ce Q2 ZERO ONE STRATEGIES 401108857 BLOCK INC. 2025 second_quarter SCI Issues related to artificial intelligence and digital assets, including bitcoin. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-02T11:18:21-04:00
3376095 KEYSIGHT TECHNOLOGIES, INC b8ffc307-4d1e-4cef-a8f6-9cb372a6679c Q2 KEYSIGHT TECHNOLOGIES, INC 401103416 KEYSIGHT TECHNOLOGIES, INC 2025 second_quarter SCI FY2026 House and Senate Appropriations and Authorization Bills around Acquisition Reform, Semiconductor Fabrication Facilities, CHIPS Act, and STEM. Commerce, Dept of (DOC),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Natl Science Foundation (NSF),Natl Telecommunications & Information Administration (NTIA),SENATE   14220 0 0 2025-07-02T12:14:00-04:00
3376306 JAMES JOCHUM f32dee68-30f7-456c-a733-04343bbc242e Q2 JAMES JOCHUM 401109102 GOOGLE CLIENT SERVICES LLC 2025 second_quarter SCI online privacy, safety issues SENATE 50000   0 0 2025-07-03T10:21:23-04:00
3376455 TIGER HILL PARTNERS LLC 6a17ec9d-0836-4479-824f-6c917020405b Q2 TIGER HILL PARTNERS LLC 401105491 DYNAMOFL, INC. 2025 second_quarter SCI Issues related to artificial intelligence. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-03T15:03:08-04:00
3376463 TIGER HILL PARTNERS LLC 80ff2835-71ad-4d99-ac04-1804d57c69f9 Q2 TIGER HILL PARTNERS LLC 401105491 GRASS OPCO LTD. 2025 second_quarter SCI Issues related to ethical proxy networks HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-03T15:06:37-04:00
3376517 HOLLAND & KNIGHT LLP 46f35f3c-f0ab-43a2-b61f-b5b48908feba Q2 HOLLAND & KNIGHT LLP 18466 SILA NANOTECHNOLOGIES INC. 2025 second_quarter SCI Battery supply chain.   60000   0 0 2025-07-03T15:53:10-04:00
3376578 POLICY DEVELOPMENT GROUP 8870cd5c-61eb-44bb-a4a7-ba22b6a3c391 Q2 POLICY DEVELOPMENT GROUP 31736 LED ENTERPRISE LLC 2025 second_quarter SCI IT HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-03T17:15:42-04:00
3376591 STUART CHEMTOB, ESQ d57cc06a-b29a-4dd5-bc57-41e81cff7281 Q2 STUART CHEMTOB, ESQ 401108262 INTERDIGITAL COMMUNICATIONS 2025 second_quarter SCI Standards Policy Natl Institute of Standards & Technology (NIST) 15000   0 0 2025-07-03T18:50:59-04:00
3376797 NATIONAL GROUP, LLP 2479d9e0-78cc-40fd-a0fd-5bf26c4366ee Q2 NATIONAL GROUP, LLP 66090 THE CITY UNIVERSITY OF NEW YORK 2025 second_quarter SCI S&T Research Funding HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),Natl Science Foundation (NSF),SENATE 50000   0 0 2025-07-06T09:47:08-04:00
3376804 NATIONAL GROUP, LLP 93cf5278-12ee-48bc-9eb2-660d593eb386 Q2 NATIONAL GROUP, LLP 66090 MUSEUM OF SCIENCE AND INDUSTRY 2025 second_quarter SCI S&T Funding HOUSE OF REPRESENTATIVES,Institute of Museum and Library Services (IMLS),Natl Science Foundation (NSF),SENATE 30000   0 0 2025-07-06T09:51:59-04:00
3376828 RED MAPLE CONSULTING, LLC 039caef5-d4f7-44ab-b7d4-98ceaddee453 Q2 RED MAPLE CONSULTING, LLC 400382761 BIOMASS ENERGY SYSTEMS, INC (BESI) 2025 second_quarter SCI methane emissions capture and conversion project proposal HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-06T11:00:35-04:00
3376836 RED MAPLE CONSULTING, LLC eb5a907e-e394-4c70-8854-984ba9419574 Q2 RED MAPLE CONSULTING, LLC 400382761 STRATEGIES 360 (ON BEHALF OF UNIVERSITY CORPORATION FOR ATMOSPHERIC RESEARCH) 2025 second_quarter SCI Federal funding for earth systems science HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-06T11:13:56-04:00
3376870 RED MAPLE CONSULTING, LLC e810fc3a-55ba-49d7-8b5d-3f4f867a614d 2A RED MAPLE CONSULTING, LLC 400382761 BIOMASS ENERGY SYSTEMS, INC (BESI) 2025 second_quarter SCI methane emissions capture and conversion project proposal HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-06T12:51:25-04:00
3376876 RED MAPLE CONSULTING, LLC 2c7d63a2-1768-4bd2-b51e-e95fbfa4993f 2A RED MAPLE CONSULTING, LLC 400382761 STRATEGIES 360 (ON BEHALF OF UNIVERSITY CORPORATION FOR ATMOSPHERIC RESEARCH) 2025 second_quarter SCI Federal funding for earth systems science HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-06T13:00:21-04:00
3376895 HOLLAND & KNIGHT LLP c6633de6-f94a-4fab-b59e-9b9e6d797b47 Q2 HOLLAND & KNIGHT LLP 18466 DUPONT DE NEMOURS, INC. 2025 second_quarter SCI Implementation of the CHIPS and Science Act. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2025-07-06T15:50:03-04:00
3376913 HOLLAND & KNIGHT LLP e557fae9-9276-47c6-adec-d1ce35236521 Q2 HOLLAND & KNIGHT LLP 18466 VERISIGN, INC. 2025 second_quarter SCI Issues related to internet governance policy; issues related to online privacy. HOUSE OF REPRESENTATIVES,SENATE 90000   0 0 2025-07-06T16:14:02-04:00
3376915 HOLLAND & KNIGHT LLP 2dd80aa6-6068-4d9e-96d2-e82f49f91786 Q2 HOLLAND & KNIGHT LLP 18466 VIASAT, INC. 2025 second_quarter SCI Issues related to commercial space legislation and orbital debris management; NASA Transition Authorization Act of 2025. HOUSE OF REPRESENTATIVES,SENATE 70000   0 0 2025-07-06T16:17:36-04:00
3376961 CAPITOL ASSET STRATEGIES 55a9a60e-90c5-4ad9-a89b-2f4d7c4ddcf2 Q2 CAPITOL ASSET STRATEGIES 401109062 AVA LABS, INC. 2025 second_quarter SCI Issues related to digital assets. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Small Business Administration (SBA),Veterans Affairs, Dept of (VA) 32000   0 0 2025-07-07T09:40:24-04:00
3376968 CAPITOL ASSET STRATEGIES 491bb83c-e218-44f1-9004-d84e16e05ce4 2A CAPITOL ASSET STRATEGIES 401109062 AVA LABS, INC. 2025 second_quarter SCI Issues related to digital assets. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Small Business Administration (SBA),Veterans Affairs, Dept of (VA) 16000   0 0 2025-07-07T09:43:51-04:00
3377039 HACKENSACK MERIDIAN HEALTH 2248dc5e-01d5-42e0-8f22-bf42a68e28a5 Q2 HACKENSACK MERIDIAN HEALTH 401104109 HACKENSACK MERIDIAN HEALTH 2025 second_quarter SCI AI Centers For Medicare and Medicaid Services (CMS)   180000 0 0 2025-07-07T10:56:27-04:00
3377306 IBEX2 SOLUTIONS, LLC a161dfc8-4955-4af9-b586-9c38e7374c69 Q2 IBEX2 SOLUTIONS, LLC 401106918 OBRIEN, GENTRY AND SCOTT OBO MOTIV SPACE SYSTEMS 2025 second_quarter SCI Budget, FY2026 commerce, justice, Science appropriations; 2025 NASA Authorization; defense authorization. Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),SENATE 10000   0 0 2025-07-07T18:07:21-04:00
3377314 IBEX2 SOLUTIONS, LLC f7e6c5cc-341d-4dc1-8f81-28b8facca6fe Q2 IBEX2 SOLUTIONS, LLC 401106918 UNITED LAUNCH ALLIANCE, LLC 2025 second_quarter SCI launch to support space science HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),SENATE 30000   0 0 2025-07-07T18:15:46-04:00
3377320 IBEX2 SOLUTIONS, LLC 04797499-0ae3-4763-b3ea-a388ef56ce9a Q2 IBEX2 SOLUTIONS, LLC 401106918 OCEANEERING INTERNATIONAL, INC. 2025 second_quarter SCI NASA Authorization, FY2025 funding, FY2026 funding Natl Aeronautics & Space Administration (NASA) 20000   0 0 2025-07-07T18:23:24-04:00
3377390 TAFT STETTINIUS & HOLLISTER LLP DBA TAFT ADVISORS LLC FKA (TAFT, STETTINIUS & HO 845ad8a1-382f-41a6-90cc-00714f33a3c1 Q2 TAFT STETTINIUS & HOLLISTER LLP DBA TAFT ADVISORS LLC FKA (TAFT, STETTINIUS & HO 400348604 TOMORROW.IO 2025 second_quarter SCI Issues related to Tomorrow Companies, DOD and NASA issues Defense, Dept of (DOD)     0 0 2025-07-08T08:50:23-04:00
3377499 MCDERMOTT WILL & SCHULTE LLP 80a3ff87-d1c9-4ee0-b90c-6aa6768bae5d Q2 MCDERMOTT WILL & SCHULTE LLP 24338 SURESCRIPTS 2025 second_quarter SCI Efforts to advance interoperability and to ensure that technological advances in the pharmacy services sector, including in electronic prescribing and electronic prior authorization, benefit patients, prescribers, and others in a timely way. Centers For Medicare and Medicaid Services (CMS),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-08T10:46:07-04:00
3377504 ADVANCED POLICY CONSULTING, LLC d496e52e-5e0f-4f0f-b1fb-033660451db9 Q2 ADVANCED POLICY CONSULTING, LLC 401103524 WIZ, INC. 2025 second_quarter SCI Education about available solutions for cloud and AI cybersecurity. Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-07-08T10:58:46-04:00
3377539 COORSTEK, INC. 9f235ce5-5e4a-40db-96fb-61b349d324f1 Q2 COORSTEK, INC. 40008062 COORSTEK INC 2025 second_quarter SCI Semiconductor Supply Chain, Export Controls Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE   25000 0 0 2025-07-08T11:23:04-04:00
3377592 GOODLATTE GROUP, LLC F.K.A. ROBERT GOODLATTE b1803fcf-d686-40c6-8edb-d84160001ba1 Q2 GOODLATTE GROUP, LLC F.K.A. ROBERT GOODLATTE 401105539 ASSOCIATION OF AMERICAN PUBLISHERS 2025 second_quarter SCI Issues related to government regulation of peer reviewed journal articles Artificial intelligence issues HOUSE OF REPRESENTATIVES,Office of Science & Technology Policy (OSTP),SENATE 50000   0 0 2025-07-08T12:11:13-04:00
3377921 COLDQUANTA DBA INFLEQTION (FKA COLDQUANTA) 5fc3f289-bdcc-4337-862e-497ff3d103d8 Q2 COLDQUANTA DBA INFLEQTION (FKA COLDQUANTA) 401106474 COLDQUANTA DBA INFLEQTION (FKA COLDQUANTA) 2025 second_quarter SCI ColdQuanta dba Infleqtion is a quantum technology company and a manufacturer of quantum components. Our lobbying activities focused on programmatic budget requests for quantum technology projects and support for quantum-related legislation including the NQIRA. We also performed general education for staff on the topics of quantum technology and the quantum ecosystem. HOUSE OF REPRESENTATIVES,SENATE   17000 0 0 2025-07-08T18:46:10-04:00
3377968 CORNERSTONE GOVERNMENT AFFAIRS, INC. 1c4ebdd7-52fa-4fe1-ab45-c01191eccbf6 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 ANALOG DEVICES, INC. 2025 second_quarter SCI General representation on technology policy, including on issues impacting the semiconductor industry. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2025-07-09T07:37:25-04:00
3377969 CORNERSTONE GOVERNMENT AFFAIRS, INC. 123ff1df-cb02-4672-bb02-0efb7099db86 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 ARLO TECHNOLOGIES, INC. 2025 second_quarter SCI Engage Congress on the ROUTERS Act and related bills. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-09T07:38:49-04:00
3378000 HOLLAND & KNIGHT LLP 61258272-2284-4991-a0fe-388af3ccb976 Q2 HOLLAND & KNIGHT LLP 18466 BLUE ORIGIN LLC 2025 second_quarter SCI Unnumbered FY 2026 Commerce, Justice, Science, and Related Agencies Appropriations bill - issues related to space; S. 933, NASA Transition Authorization Act of 2025, issues related to Artemis program and commercial space; H.R. 1, One Big Beautiful Bill Act - issues related to space. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-09T09:15:03-04:00
3378064 HOLLAND & KNIGHT LLP e41981f0-0c27-4adb-9ccd-dc84c0b95877 Q2 HOLLAND & KNIGHT LLP 18466 INTERLUNE CORPORATION 2025 second_quarter SCI S. 933, NASA Transition Authorization Act of 2025 - issues related to space resources. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-09T10:09:37-04:00
3378066 HOLLAND & KNIGHT LLP 69769909-890d-40b8-8a4b-0bc896c3fbf9 Q2 HOLLAND & KNIGHT LLP 18466 QUANTUM INDUSTRY COALITION 2025 second_quarter SCI Unnumbered National Quantum Initiative reauthorization bill - all provisions; unnumbered FY 2026 Commerce, Justice, Science, and Related Agencies Appropriations bill - issues related to quantum technology; S. 1746, Quantum LEAP Act of 2025 - all provisions; H.R. 3220/S. 1334, Quantum Sandbox for Near-Term Applications Act of 2025 - all provisions; H.R. 3259, Post Quantum Cybersecurity Standards Act - all provisions; S. 579, Department of Energy Quantum Leadership Act - all provisions; S. 1343, Advancing Quantum Manufacturing Act of 2025 - all provisions. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-09T10:15:40-04:00
3378115 AMERICAN POLITICAL SCIENCE ASSOCIATION 7e6fdda3-3ba3-43ef-b0f0-4aefc142740d Q2 AMERICAN POLITICAL SCIENCE ASSOCIATION 401105414 AMERICAN POLITICAL SCIENCE ASSOCIATION 2025 second_quarter SCI HR 1968 Full-Year Continuing Appropriations and Extensions Act In support of funding increase for the National Science Foundation HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-09T11:03:17-04:00
3378248 CHW ADVISORS 1818de79-e9f1-4757-a5b5-37e50e99b301 Q2 CHW ADVISORS 401105960 MOMENTIVE PERFORMANCE MATERIALS QUARTZ, INC. 2025 second_quarter SCI CHIPS Act HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-09T12:22:41-04:00
3378289 CORNERSTONE GOVERNMENT AFFAIRS, INC. ff113037-57f6-44bf-8b89-0fcdd8b6e4d6 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 NEW MEXICO STATE UNIVERSITY 2025 second_quarter SCI Advocated for Programmatic and congressionally directed funding to enhance NMSUs role as a Land-grant University, and enhance NMSUs position as a resource and subject matter asset for the New Mexico Congressional Delegation and specific Federal agencies. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-09T13:04:45-04:00
3378317 CORNERSTONE GOVERNMENT AFFAIRS, INC. 7089842b-870f-4dd3-86bc-32480be6e466 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 UNITED LAUNCH ALLIANCE 2025 second_quarter SCI Issues related to the National Defense Authorization Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-09T13:14:57-04:00
3378330 CORNERSTONE GOVERNMENT AFFAIRS, INC. 7ee6a6b0-0149-49ba-be90-34f1a326312d Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 NATIONAL SORGHUM PRODUCERS 2025 second_quarter SCI Issues related agricultural appropriations, research, crop protection, biotechnology, climate-Smart practices Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-09T13:21:18-04:00
3378345 CORNERSTONE GOVERNMENT AFFAIRS, INC. 14945807-6040-4a18-ba58-278943053268 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 VALENT U.S.A. LLC 2025 second_quarter SCI Federal Insecticide, Fungicide, and Rodenticide Act and Food Quality Protection Act; Endangered Species Act. Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-09T13:28:34-04:00
3378402 GRANT CONSULTING GROUP 12209d23-8114-4f51-bdb0-0006a51e0615 Q2 GRANT CONSULTING GROUP 89155 BMC 2025 second_quarter SCI IT, IT modernization General Services Administration (GSA),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-07-09T14:27:23-04:00
3378420 HOLLAND & KNIGHT LLP f6815d0c-a443-41f2-89f9-afa9a7d6873a Q2 HOLLAND & KNIGHT LLP 18466 AETHERFLUX, INC. 2025 second_quarter SCI Issues related to space-based solar power. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-09T14:34:22-04:00
3378466 FEDERAL SOLUTIONS, LLC 648bab8b-8c41-4287-914a-4ecbc5392fc9 Q2 FEDERAL SOLUTIONS, LLC 311371 MISSISSIPPI STATE UNIVERSITY 2025 second_quarter SCI Commerce/Justice/Science Appropriations: Provisions relating to research and development in NOAA HOUSE OF REPRESENTATIVES,Natl Oceanic & Atmospheric Administration (NOAA),SENATE 50000   0 0 2025-07-09T15:06:08-04:00
3378498 CORNERSTONE GOVERNMENT AFFAIRS, INC. a2d42be1-b9d1-4573-868e-ea08e77be28f Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 KELLOGG BROWN & ROOT LLC 2025 second_quarter SCI Funding and policy issues pertaining to the U.S. Antarctica Program. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-09T15:19:51-04:00
3378552 CORNERSTONE GOVERNMENT AFFAIRS, INC. 6948d62a-f998-428d-be06-8b640e8a13ad Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 VANTAGE DATA CENTERS MANAGEMENT COMPANY, LLC 2025 second_quarter SCI Energy and technology policy related to data center operations and development. HOUSE OF REPRESENTATIVES,Office of Science & Technology Policy (OSTP),SENATE 50000   0 0 2025-07-09T15:53:04-04:00
3378570 HOLLAND & KNIGHT LLP d3795ae5-68c5-4bb4-9974-8175ba92a9ad Q2 HOLLAND & KNIGHT LLP 18466 CLARK STREET ASSOCIATES ON BEHALF OF LATTICE SEMICONDUCTOR 2025 second_quarter SCI Federal funding for on-shore semiconductor manufacturing; H.R.4016 - Department of Defense Appropriations Act, 2026. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-09T15:58:56-04:00
3378582 CORNERSTONE GOVERNMENT AFFAIRS, INC. 7651bcb8-ae2d-4006-b424-d36abc7203ca Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 AMPERE COMPUTING LLC 2025 second_quarter SCI Issue related to the implementation of Chips and Science Act, general representation on technology and R&D policy. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-09T16:03:58-04:00
3378889 CORNERSTONE GOVERNMENT AFFAIRS, INC. c12501b2-2427-461f-9ad9-5a3b0c59808a Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 THE UNIVERSITY OF TEXAS SYSTEM 2025 second_quarter SCI Assessing the Systems R&D funding opportunities, designing strategies to pursue funding, and securing funding for research priorities. HOUSE OF REPRESENTATIVES,SENATE 90000   0 0 2025-07-10T11:09:24-04:00
3379042 HERMEUS CORP. 834d68ea-b510-47f9-8068-98836bc250e5 Q2 HERMEUS CORP. 401107286 HERMEUS CORP. 2025 second_quarter SCI H.R. 1: One Big Beautiful Bill Act. Discussed having funding inserted into the bill for reuseable hypersonic technology. H.R. 477: MACH Act. Lobbied in support of the Act. H.R. 3410: SAM Act. Lobbied in support of this Act. H.R. 4107: Golden Dome Act: Lobbied to get high-Mach and hypersonic aircraft into the Act. Lobbied for funding in FY26 defense appropriations bill Lobbied for language favorable to hypersonics in National Defense Authorization Act FY26 Lobbied FAA for a waiver using section 927 from the FAA Reauthorization Act of 2024 HOUSE OF REPRESENTATIVES,SENATE   108000 0 0 2025-07-10T12:55:52-04:00
3379086 TSG ADVOCATES DC, LLC bdd0a303-9a53-46e9-b39f-94edddd43018 Q2 TSG ADVOCATES DC, LLC 401109292 PROTECTING AMERICAN INNOVATIONS, INC. 2025 second_quarter SCI Patent protection for small businesses and independent innovators, the regulatory power of the US Patent and Trademark Office, and offshoring of communications technology. HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),SENATE 30000   0 0 2025-07-10T13:39:30-04:00
3379142 CORNERSTONE GOVERNMENT AFFAIRS, INC. ba5b986c-538c-48bf-a19b-be720b3e7c43 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 ADOBE INC. 2025 second_quarter SCI Educate the Administration on technology solutions Commerce, Dept of (DOC),Executive Office of the President (EOP) 50000   0 0 2025-07-10T14:09:53-04:00
3379204 CORNERSTONE GOVERNMENT AFFAIRS, INC. 903cc0e2-78cf-43a1-b5d8-6e8c0439ef33 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 LYTEN, INC. 2025 second_quarter SCI Inform and educate officials on the development and production of domestic graphene and its battery composite and sensor applications across the federal government policy and funding issues; advocate for policy incentives for graphene production capacity in US. Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Security Council (NSC),SENATE,State, Dept of (DOS) 50000   0 0 2025-07-10T14:39:10-04:00
3379327 KELLOGG, BROWN AND ROOT (KBR) b7dae04d-2d39-4989-98e4-c918b6a4da86 Q2 KELLOGG, BROWN AND ROOT (KBR) 401108293 KELLOGG, BROWN AND ROOT (KBR) 2025 second_quarter SCI HR-1 (OBBBA); CJS FY26 Appropriations (no bill number available for both Senate and House); HR-1968 FY25 Continuing Resolution - Specifically: NASA/NOAA - NASA Goddard, OSAM, LANDSAT, and Science budgets National Science Foundation - U.S. Antarctica Program HOUSE OF REPRESENTATIVES,SENATE   300000 0 0 2025-07-10T15:16:10-04:00
3379331 NOKIA OF AMERICA CORPORATION 1ee4dc11-f886-4446-8567-5d9c8ee4ea38 Q2 NOKIA OF AMERICA CORPORATION 29380 NOKIA OF AMERICA CORPORATION 2025 second_quarter SCI Funding for 5G and beyond; funding for research and development activities. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE   160000 0 0 2025-07-10T15:16:47-04:00
3379378 SQUIRE PATTON BOGGS 4335cdf3-4869-4075-8717-cb5c9c2be37e Q2 SQUIRE PATTON BOGGS 30906 TATA CONSULTANCY SERVICES 2025 second_quarter SCI Artificial Intelligence (AI) HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2025-07-10T15:31:33-04:00
3379521 STEVE PETERSEN & ASSOCIATES 805edbe7-7b0b-4f51-9335-973e64f7e6e4 Q2 STEVE PETERSEN & ASSOCIATES 401106734 VERDEGO AERO 2025 second_quarter SCI Research and Development Funding, Hybrid Engine Development, FY2025 Defense Appropriations. Air Force, Dept of,Army, Dept of (Other),HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-10T16:25:10-04:00
3379552 HOLLAND & KNIGHT LLP df47bea9-c319-46b4-9d7f-10fe5a03844e Q2 HOLLAND & KNIGHT LLP 18466 HMS ASSOCIATES (ON BEHALF OF THE EXPLORATORIUM) 2025 second_quarter SCI Scientific exhibits.   30000   0 0 2025-07-10T16:44:36-04:00
3379599 LIVE OAK STRATEGIES 61e0e1c0-947f-4c70-88d3-4d368b29ad43 Q2 LIVE OAK STRATEGIES 401105683 CART.COM 2025 second_quarter SCI Issues related to e-commerce services, software, regular logistics, warehousing, and related government contracting. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-10T21:18:22-04:00
3379722 INDIANA CHAMBER OF COMMERCE, INC. bc397806-62e2-4cac-9d36-d499674d9155 Q2 INDIANA CHAMBER OF COMMERCE, INC. 19263 INDIANA CHAMBER OF COMMERCE INC 2025 second_quarter SCI Issues related to artificial intelligence regulation in H.R. 1 The One Big Beautiful Bill SENATE   40000 0 0 2025-07-11T10:05:25-04:00
3379729 HOLLAND & KNIGHT LLP dcd9938b-a30b-41d6-bee8-7599536d3d2d Q2 HOLLAND & KNIGHT LLP 18466 CLARK STREET ASSOCIATES ON BEHALF OF IONQ, INC. 2025 second_quarter SCI Unnumbered National Quantum Initiative reauthorization bill - all provisions; S. 579, Department of Energy Quantum Leadership Act - all provisions; unnumbered FY 2026 Commerce, Justice, Science, and Related Agencies Appropriations bill - issues related to quantum technology. HOUSE OF REPRESENTATIVES,SENATE 70000   0 0 2025-07-11T10:08:06-04:00
3379771 THE PRENDA GROUP LLC 9f0e9d69-c557-4ae3-898b-61f04c2fb787 Q2 THE PRENDA GROUP LLC 401104543 TACTILE ENGINEERING INC. 2025 second_quarter SCI Monitoring issues concerning Inclusion workforce training for the blind and visually impaired through technology. Monitoring funding related to blind and visually impaired research and development. Handheld devices for the Blind and visually impaired. HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-11T10:31:33-04:00
3379856 LEWIS-BURKE ASSOCIATES, LLC ae71cbaa-6fc3-4edc-966c-6e4abbae044a Q2 LEWIS-BURKE ASSOCIATES, LLC 22781 ACTIVATE GLOBAL, INC. 2025 second_quarter SCI Issues pertaining to entrepreneurship programming in biotech and other emerging sectors. Issues pertaining to a DOE Entrepreneurship Program. Issues pertaining to entrepreneurship to advance grid security. Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-11T11:12:42-04:00
3380025 STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY 45166b03-d801-4b82-b083-9190628577a9 Q2 STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY 36537 STATE FARM MUTUAL AUTOMOBILE INSURANCE COMPANY 2025 second_quarter SCI Issues related to the insurance industry's use of weather data provided by the National Oceanic and Atmospheric Administration (NOAA). HOUSE OF REPRESENTATIVES,SENATE   320000 0 0 2025-07-11T13:17:58-04:00
3380143 UNIVERSITY OF MARYLAND, BALTIMORE (UMB) 26b00985-c12c-4878-b586-2483d9a40208 Q2 UNIVERSITY OF MARYLAND, BALTIMORE (UMB) 401103161 UNIVERSITY OF MARYLAND, BALTIMORE (UMB) 2025 second_quarter SCI F&A rate for scientific research HOUSE OF REPRESENTATIVES,SENATE   10000 0 0 2025-07-11T15:27:35-04:00
3380369 SKYLINE CAPITOL LLC e7bccb5f-78e6-47d7-be6a-765fc03994af Q2 SKYLINE CAPITOL LLC 401108050 SEEK LABS, INC. 2025 second_quarter SCI Issues regarding healthcare solutions that bridge gaps between patients, providers and treatments. Increasing access to diagnostic and pharmaceutical solutions and tools. HOUSE OF REPRESENTATIVES,SENATE,White House Office 45000   0 0 2025-07-12T10:40:11-04:00
3380426 CHAMBER HILL STRATEGIES 1a5bf5e3-7b4c-4daf-8b7c-b408e21c0097 Q2 CHAMBER HILL STRATEGIES 400645947 LET LAHAINA REBUILD COALITION 2025 second_quarter SCI coastal flooding forecasting and the Coastal Zone Management Program Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE 40000   0 0 2025-07-12T15:39:07-04:00
3380684 G2G CONSULTING 0999515e-8d73-4228-9ef1-2945bef8d397 Q2 G2G CONSULTING 323136 AMERICAVIEW 2025 second_quarter SCI Advocate for Earth observation education HOUSE OF REPRESENTATIVES,SENATE,White House Office     0 0 2025-07-13T18:44:33-04:00
3380734 CORNERSTONE GOVERNMENT AFFAIRS, INC. 7f049e61-4a78-455b-a312-55edcb54446f Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 WORKDAY, INC. 2025 second_quarter SCI Supporting appropriations related to software as a service. SENATE 50000   0 0 2025-07-13T23:00:45-04:00
3380951 THE BURNHAM GROUP LLC d56c947c-c114-4ebe-b6fb-59005ea95b5c Q2 THE BURNHAM GROUP LLC 401105302 OAKLAND UNIVERSITY 2025 second_quarter SCI Basic research at NSF, NIST, DOD, DOE, NIH NOAA HR 1 One Big Beautiful Bill HR 4016 Defense Appropriations Bill CJS Appropriations Bill HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-07-14T10:30:23-04:00
3381007 CORNERSTONE GOVERNMENT AFFAIRS, INC. d880701d-c408-4d8c-9c00-6d35a8ca99bf Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 PSIQUANTUM 2025 second_quarter SCI Issues related to Quantum computing policy and funding within Fiscal Year 2026 Defense Appropriations Act and National Defense Authorization Act. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-14T10:54:53-04:00
3381035 CORNERSTONE GOVERNMENT AFFAIRS, INC. 2a70e49f-4d6b-4dbf-9446-4f129a452f9f Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 SCALE AI, INC. 2025 second_quarter SCI Advocating for Artificial Intelligence related provisions in legislation. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-14T11:04:27-04:00
3381078 CLEMSON UNIVERSITY d132b045-dcd3-4e8e-b5d1-51a98932caa6 Q2 CLEMSON UNIVERSITY 400389804 CLEMSON UNIVERSITY 2025 second_quarter SCI Discussed NSF related university research proposals with staff from the S.C. Congressional delegation. HOUSE OF REPRESENTATIVES,SENATE   110000 0 0 2025-07-14T11:19:54-04:00
3381210 STRATEGIC MARKETING INNOVATIONS 044e685b-53bd-42e8-a71a-08b4e21bb3d9 Q2 STRATEGIC MARKETING INNOVATIONS 60550 AM BATTERIES 2025 second_quarter SCI Product R&D and manufacturing scale-up Defense, Dept of (DOD),Energy, Dept of,SENATE 20000   0 0 2025-07-14T12:24:29-04:00
3381227 MERCURY PUBLIC AFFAIRS, LLC 73ca6d65-9369-4130-8faf-bffe5bc84d05 Q2 MERCURY PUBLIC AFFAIRS, LLC 70175 CONSUMER TECHNOLOGY ASSOCIATION 2025 second_quarter SCI issues related to consumer technology HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-14T12:29:40-04:00
3381283 STRATEGIC MARKETING INNOVATIONS b3f418f4-6278-4dff-bd26-816fc064e0e7 Q2 STRATEGIC MARKETING INNOVATIONS 60550 SYENSQO FINANCE (AMERICA), LLC (FKA SYENSQO) 2025 second_quarter SCI Infrastructure funding, FY23 appropriations for DOD and DOE R&D for advanced materials Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-14T12:59:37-04:00
3381414 CORNERSTONE GOVERNMENT AFFAIRS, INC. 80fc9a83-d005-422e-a5ce-9bd09b780ad5 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 AMERICAN CRITICAL MINERALS ASSOCIATION 2025 second_quarter SCI Education and advocacy focused on advancing domestic capabilities and incentives for the permitting, production, processing, refining and recycling of critical minerals to strengthen national supply chains and promote sustainability Defense, Dept of (DOD),Energy, Dept of,Executive Office of the President (EOP),Export-Import Bank of the United States (EXIM Bank),HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),SENATE,State, Dept of (DOS) 40000   0 0 2025-07-14T13:42:24-04:00
3381449 STRATEGIC MARKETING INNOVATIONS faa1e927-52bf-4d94-8c2d-ccd6518a35fb Q2 STRATEGIC MARKETING INNOVATIONS 60550 MONTANA STATE UNIVERSITY 2025 second_quarter SCI Regional tech hubs HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-14T13:51:56-04:00
3381473 STRATEGIC MARKETING INNOVATIONS 97542e4f-7f38-4219-b4e5-6f01388f3b0c Q2 STRATEGIC MARKETING INNOVATIONS 60550 UNIVERSITY OF MONTANA 2025 second_quarter SCI Regional technology hubs HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-14T13:57:27-04:00
3381514 TWILIO INC. 328da995-6cbb-47ad-94b5-790d3e5c5a89 Q2 TWILIO INC. 401105202 TWILIO INC. 2025 second_quarter SCI Issues related to AI policy. HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),Office of Science & Technology Policy (OSTP),SENATE   230000 0 0 2025-07-14T14:11:06-04:00
3381542 CORNERSTONE GOVERNMENT AFFAIRS, INC. d40450ad-6d2f-48ad-acd9-d4942a7f6afe Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 XLIGHT INC. 2025 second_quarter SCI Inform and educate officials on the development and production of EUV lithography for advanced CHIPS manufacturing as well as the need for appropriations and federal funding support for advanced semiconductor technologies. Commerce, Dept of (DOC),Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Natl Institute of Standards & Technology (NIST),SENATE,White House Office 50000   0 0 2025-07-14T14:17:08-04:00
3381570 MERCURY PUBLIC AFFAIRS, LLC 8f56fd85-27e2-4f33-a42d-d7b9ae7e8f0f Q2 MERCURY PUBLIC AFFAIRS, LLC 70175 SENTINELONE INC. 2025 second_quarter SCI Issues related to cybersecurity Technology White House Office 40000   0 0 2025-07-14T14:21:44-04:00
3381609 CORNERSTONE GOVERNMENT AFFAIRS, INC. ea84cafd-e5f1-4561-a411-b1856017e3d6 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 SEMICONDUCTOR INDUSTRY ASSOCIATION 2025 second_quarter SCI Issues related to implementation of the CHIPS and Science Act. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,White House Office 50000   0 0 2025-07-14T14:30:41-04:00
3381657 MERCURY PUBLIC AFFAIRS, LLC ee2b9386-0545-4d2c-92f0-a1542ff1122c Q2 MERCURY PUBLIC AFFAIRS, LLC 70175 OPEN AI 2025 second_quarter SCI Issues related to artificial intelligence policy HOUSE OF REPRESENTATIVES,Office of Administration,SENATE 20000   0 0 2025-07-14T14:39:23-04:00
3381759 CASSIDY & ASSOCIATES, INC. 59d3cfe2-73ce-4a68-8df1-b9e788122ac3 Q2 CASSIDY & ASSOCIATES, INC. 8453 UNIVERSITY OF NEBRASKA 2025 second_quarter SCI University Research and Development Funding Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 70000   0 0 2025-07-14T15:10:32-04:00
3381779 UNIVERSITY OF MARYLAND 4df23645-4335-4a1e-ad33-db098b649c93 Q2 UNIVERSITY OF MARYLAND 79676 UNIVERSITY OF MARYLAND 2025 second_quarter SCI National Quantum Initiative Act -entire bill General protection of negotiated Facilities and Administrative (F&A) rates on federal grants and contracts HOUSE OF REPRESENTATIVES,SENATE   35000 0 0 2025-07-14T15:16:43-04:00
3381783 I STREET ADVOCATES d824db00-1814-4464-9d97-9ea11bfa46cb Q2 I STREET ADVOCATES 51753 WEATHER GROUP TELEVISION, LLC D/B/A THE WEATHER CHANNEL 2025 second_quarter SCI Weather Research and Forecasting Legislation; public safety issues related to weather information accessibility HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-14T15:17:26-04:00
3381824 VIVID STRATEGIES LLC b4e1bc66-3604-4a67-8e7a-3f143e2611bf Q2 VIVID STRATEGIES LLC 401109416 DIGITALEUROPE 2025 second_quarter SCI H.R. 2471 - Cyber Incident Reporting for Critical Infrastructure Act (CIRCIA) of 2022 U.S. Artificial Intelligence Action Plan Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of Science & Technology Policy (OSTP),SENATE 30000   0 0 2025-07-14T15:29:23-04:00
3381901 MERCURY PUBLIC AFFAIRS, LLC 833675de-0c34-4f6c-a996-774f2e5c6f25 Q2 MERCURY PUBLIC AFFAIRS, LLC 70175 GOTION, INC. 2025 second_quarter SCI Issues related to clean energy technology, U.S. domestic manufacturing and foreign direct investment, trade and economic development. Energy, Dept of,State, Dept of (DOS),Transportation, Dept of (DOT),White House Office 255000   0 0 2025-07-14T15:54:18-04:00
3381936 ARIZONA STATE UNIVERSITY 35bda5d1-7442-43aa-acec-edd5f7891361 Q2 ARIZONA STATE UNIVERSITY 75397 ARIZONA STATE UNIVERSITY 2025 second_quarter SCI ASU has interest in increased investment in advancing materials research through the use of artificial intelligence (AI). ASU has interest in maintaining the NSF Engine program and its funding. HOUSE OF REPRESENTATIVES,SENATE   210000 0 0 2025-07-14T16:04:11-04:00
3382042 GREATER CLEVELAND PARTNERSHIP 9a2baefd-9d15-4e33-81bc-02cae3d39170 Q2 GREATER CLEVELAND PARTNERSHIP 82330 GREATER CLEVELAND PARTNERSHIP 2025 second_quarter SCI NASA HOUSE OF REPRESENTATIVES,Natl Aeronautics & Space Administration (NASA),SENATE   90000 0 0 2025-07-14T16:46:25-04:00
3382060 INTERNATIONAL SOCIETY FOR STEM CELL RESEARCH 4c8f6fed-470e-4ca1-9ce2-b51b9f35efef Q2 INTERNATIONAL SOCIETY FOR STEM CELL RESEARCH 401104821 INTERNATIONAL SOCIETY FOR STEM CELL RESEARCH 2025 second_quarter SCI HR 1082, Shandra Eisenga Human Cell and Tissue Product Safety Act HOUSE OF REPRESENTATIVES   30000 0 0 2025-07-14T16:49:22-04:00

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 2171.572ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API