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

43,522 rows where filing_period = "second_quarter" and filing_year = 2020 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code >30

  • BUD 4,186
  • HCR 3,480
  • TAX 2,782
  • DEF 1,869
  • TRA 1,813
  • TRD 1,649
  • MMM 1,587
  • ENG 1,271
  • ENV 1,058
  • EDU 1,045
  • FIN 974
  • AGR 916
  • LBR 857
  • TEC 844
  • GOV 825
  • NAT 813
  • HOM 752
  • IMM 677
  • BAN 675
  • SMB 622
  • DIS 597
  • SCI 527
  • ECN 512
  • LAW 497
  • AVI 477
  • CSP 472
  • CPT 434
  • CAW 414
  • HOU 412
  • FOR 406
  • …

filing_year 1

  • 2020 · 43,522 ✖

filing_period 1

  • second_quarter · 43,522 ✖
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
2420754 BRAMER GROUP LLC e5bd8e9a-97b1-4e7f-9b78-208523a76208 Q2 BRAMER GROUP LLC 401103355 MSI-DEFENSE SYSTEMS US, INC 2020 second_quarter DEF Defense Requirements and Appropriations for Naval Systems National Defense Authorization Act for Fiscal Year 2021 FFG(X) Capabilities LAW Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE 24000   0 0 2020-04-02T14:02:12.410000-04:00
2423073 ZELL & COX LAW, P.C. 549eb7dc-29d7-469e-95ab-b2ce5aa734dd 2T ZELL & COX LAW, P.C. 298216 LYTTON BAND OF POMO INDIANS 2020 second_quarter IND H.R. 1388, the Lytton Rancheria Homelands Act of 2019 SENATE 10000   0 1 2020-04-10T15:38:45.617000-04:00
2429057 CHRISTIE 55 SOLUTIONS LLC 0f614517-c2f1-43dc-ac9b-b99440a8e681 2@Y CHRISTIE 55 SOLUTIONS LLC 401105567 DONJON-SMIT LLC, AN OPA-90 ALLIANCE 2020 second_quarter           0 1 2020-04-16T15:10:42.820000-04:00
2432284 BLOOM STRATEGIC COUNSEL f391eb0c-5493-4be5-8bd3-597132f23e41 2T BLOOM STRATEGIC COUNSEL 401036920 MASIMO 2020 second_quarter LBR Competition in the medical device marketplace Federal Trade Commission (FTC),SENATE 10000   0 1 2020-04-17T14:18:18.430000-04:00
2434275 JEFFREY J. KIMBELL & ASSOCIATES, INC. 1a2e9c73-0abd-4657-b5ea-c59ff08d281e 2T JEFFREY J. KIMBELL & ASSOCIATES, INC. 46038 NEVRO CORPORATION 2020 second_quarter MMM Federal policy issues related to non-opioid pain therapies. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2020-04-17T18:26:55.320000-04:00
2445667 THE PICARD GROUP, LLC 11e99390-2ba2-4563-9d15-a69ff8b87ad7 2TY THE PICARD GROUP, LLC 400711132 KENNEDY RICE MILL LLC 2020 second_quarter           0 1 2020-04-20T14:15:59.447000-04:00
2447660 THORN RUN PARTNERS 9307f9b5-74be-4548-b3fa-4f034c822420 2T THORN RUN PARTNERS 400534596 INDEPENDENT RESTAURANT COALITION 2020 second_quarter SMB Paycheck Protection Program issues included in the CARES Act. S. 3548 and H.R. 748, Coronavirus Aid, Relief, and Economic Security Act. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2020-04-20T15:41:14.630000-04:00
2449227 JEFFERSON BUSINESS CONSULTING, LLC 33de15f0-cb5b-4079-821f-610264fc329c 2TY JEFFERSON BUSINESS CONSULTING, LLC 48782 GETWELLNETWORK 2020 second_quarter           0 1 2020-04-20T16:36:31.117000-04:00
2455846 MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) ccf0ac9d-1bce-4c1f-977f-d3fb5a45b37d 2TY MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) 24486 BANK OF AMERICA, N.A. 2020 second_quarter           0 1 2020-04-22T10:01:08.443000-04:00
2456361 MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) 0eed16bf-d271-4c41-af0d-e1c317a71006 2@Y MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) 24486 BANK OF AMERICA, N.A. 2020 second_quarter           0 1 2020-04-24T10:59:55.560000-04:00
2457212 FWH AND ASSOCIATES LLC 85019e02-43e1-43c7-82b1-c710db86e88e 2TY FWH AND ASSOCIATES LLC 401103515 NOBLE ENERGY 2020 second_quarter           0 1 2020-05-01T11:33:58.540000-04:00
2457338 MILLER & WENHOLD CAPITOL STRATEGIES 64c8b342-21bb-4284-9d98-eba24a280eb9 2T MILLER & WENHOLD CAPITOL STRATEGIES 307034 BEVILACQUE GROUP 2020 second_quarter GOV PPE per COVID-19 Federal Emergency Management Agency (FEMA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,White House Office 5000   0 1 2020-05-04T10:37:05.940000-04:00
2457402 WHITMER & WORRALL, LLC f02f1de9-a28e-49b6-b0a2-f0283e33b5d7 2TY WHITMER & WORRALL, LLC 292892 RAVN ALASKA 2020 second_quarter           0 1 2020-05-04T17:35:35.820000-04:00
2457433 TIBER HUDSON LLC 868d9000-216b-41ea-9ba1-077b2a6b00a7 Q2 TIBER HUDSON LLC 401103612 COMMITTEE ON HEALTHCARE FINANCING 2020 second_quarter HOU National Housing Act Section 232 and 242 loan programs Housing & Urban Development, Dept of (HUD)     0 0 2020-05-05T09:36:58.730000-04:00
2457434 LAW OFFICES OF FREDERICK H. GRAEFE, PLLC c6825c4f-591f-41c9-ba54-39f499caf424 2T LAW OFFICES OF FREDERICK H. GRAEFE, PLLC 291914 ARMED FORCES HEALTHCARE FOUNDATION 2020 second_quarter DEF advice and counsel concerning DOD Military Health Agency Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2020-05-05T09:37:59.233000-04:00
2457435 LAW OFFICES OF FREDERICK H. GRAEFE, PLLC c6825c4f-591f-41c9-ba54-39f499caf424 2T LAW OFFICES OF FREDERICK H. GRAEFE, PLLC 291914 ARMED FORCES HEALTHCARE FOUNDATION 2020 second_quarter HCR Advice and counsel concerning DOD Military Health Agency Defense, Dept of (DOD),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2020-05-05T09:37:59.233000-04:00
2457436 LAW OFFICES OF FREDERICK H. GRAEFE, PLLC a3dd2515-66a7-4335-a924-4001621bfe63 2T LAW OFFICES OF FREDERICK H. GRAEFE, PLLC 291914 AMERISOURCEBERGEN CORPORATION 2020 second_quarter MMM medicare and medicaid legislative advice Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 15000   0 1 2020-05-05T09:40:59.847000-04:00
2457437 BRODY GROUP L.L.C. PUBLIC AFFAIRS 2ddae1ca-3393-423d-b5e4-851383268b87 2T BRODY GROUP L.L.C. PUBLIC AFFAIRS 323318 PARKER AEROSPACE 2020 second_quarter BUD Fiscal Year 20 and 21 Defense Authorization and Appropriations. Additive Manufacturing HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-05-05T10:03:00.507000-04:00
2457439 THE MIZEUR GROUP, LLC e4ba7ec5-c288-4026-b670-305ced9148c0 2TY THE MIZEUR GROUP, LLC 400296396 INTERSYSTEMS, INC. 2020 second_quarter           0 1 2020-05-05T10:42:02.163000-04:00
2457455 THE SMITH-FREE GROUP, LLC 70f92a96-1ddb-46e9-8999-568b7fdddc1b 2T THE SMITH-FREE GROUP, LLC 35800 INGRAM INDUSTRIES INC. 2020 second_quarter EDU Monitored potential changes in COPPA and FERPA standards Monitored HR 3900 - To amend the Children's Online Privacy Protection Act of 1998 to strengthen protections relating to the online collection, use, and disclosure of personal information of children and minors, and for other purposes Monitored S 748 - To amend the Children's Online Privacy Protection Act of 1998 to strengthen protections relating to the online collection, use, and disclosure of personal information of children and minors, and for other purposes.   10000   0 1 2020-05-05T14:35:13.787000-04:00
2457456 THE SMITH-FREE GROUP, LLC 70f92a96-1ddb-46e9-8999-568b7fdddc1b 2T THE SMITH-FREE GROUP, LLC 35800 INGRAM INDUSTRIES INC. 2020 second_quarter CSP Monitored federal data privacy legislation   10000   0 1 2020-05-05T14:35:13.787000-04:00
2457640 NORTH STAR LIBERTY GROUP cdd9ceac-353e-4c97-a1d8-ddfe7f5036c9 2TY NORTH STAR LIBERTY GROUP 401105563 MINORITIES FOR MEDICAL MARIJUANA 2020 second_quarter           0 1 2020-05-05T17:02:14.303000-04:00
2457805 PETRA STRATEGIES LLC 377d903f-edd6-432a-9e0c-91f3e3b48f98 2T PETRA STRATEGIES LLC 401099066 LIFTABLE MEDIA, INC 2020 second_quarter MIA Digital media censorship HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-05-06T08:57:23.473000-04:00
2457806 PETRA STRATEGIES LLC 377d903f-edd6-432a-9e0c-91f3e3b48f98 2T PETRA STRATEGIES LLC 401099066 LIFTABLE MEDIA, INC 2020 second_quarter ADV Digital media censorship. HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-05-06T08:57:23.473000-04:00
2457844 THE NICKLES GROUP, LLC 856202ad-ea42-4991-ae59-0d36df45b650 2T THE NICKLES GROUP, LLC 293335 EDITAS MEDICINE 2020 second_quarter MMM Issues related to reimbursement of novel therapies; monitored issue related to drug pricing; S. 2543, Prescription Drug Pricing Reduction Act of 2019. Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2020-05-06T10:49:37.840000-04:00
2457845 THE NICKLES GROUP, LLC 856202ad-ea42-4991-ae59-0d36df45b650 2T THE NICKLES GROUP, LLC 293335 EDITAS MEDICINE 2020 second_quarter HCR Issues related to the science of gene editing; issues related to the Agriculture Appropriations legislation. Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2020-05-06T10:49:37.840000-04:00
2457949 MILLER & WENHOLD CAPITOL STRATEGIES 5bebecad-5451-4464-9e52-a1fc926b3431 2T MILLER & WENHOLD CAPITOL STRATEGIES 307034 SPAULDING MEDICAL 2020 second_quarter GOV Helping support getting Spaulding Medical registered to sell their medical devices to the federal government. Army, Dept of (Corps of Engineers),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 5000   0 1 2020-05-06T15:19:22.973000-04:00
2457958 LOBO STRATEGIES 08b862b3-3469-4b38-80db-afc5ceeb427a Q2 LOBO STRATEGIES 401105642 ROCK-IT CARGO USA LLC 2020 second_quarter TRA Assisting federal COVID-19 response efforts including logistical support for repatriation of Americans abroad and transport of PPE Army, Dept of (Corps of Engineers),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) 20000   0 0 2020-05-06T15:36:28.603000-04:00
2458078 LOBO STRATEGIES 78f8cc98-e499-4a9b-a526-53f68127fb7a 2A LOBO STRATEGIES 401105642 ROCK-IT CARGO USA LLC 2020 second_quarter TRA Assisting federal COVID-19 response efforts including logistical support for repatriation of Americans abroad and transport of PPE Army, Dept of (Corps of Engineers),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)     0 0 2020-05-07T10:26:20.363000-04:00
2458286 MARKS & SOKOLOV, LLC 697218d7-3118-4b7a-b98d-6052b4faa337 2TY MARKS & SOKOLOV, LLC 401104341 IGOR KOLOMOISKY 2020 second_quarter           0 1 2020-05-08T12:15:45.987000-04:00
2458333 BALLARD PARTNERS e9cad661-bfc5-42b7-89d9-8b2aecf1c86a 2T BALLARD PARTNERS 401104288 ALLIANCE RESOURCE PARTNERS, L.P. 2020 second_quarter ENG Monitor congressional and administrative actions related to energy and coal policy. White House Office 30000   0 1 2020-05-08T15:27:04.903000-04:00
2458471 CIVITAS PUBLIC AFFAIRS GROUP, LLC 234c884b-4fbd-44f3-819c-f02b682f19a7 2T CIVITAS PUBLIC AFFAIRS GROUP, LLC 401060990 YEAR UP 2020 second_quarter EDU General workforce development issues HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-05-11T16:21:11.980000-04:00
2458472 CIVITAS PUBLIC AFFAIRS GROUP, LLC 234c884b-4fbd-44f3-819c-f02b682f19a7 2T CIVITAS PUBLIC AFFAIRS GROUP, LLC 401060990 YEAR UP 2020 second_quarter IMM Advocating on issues related to the DACA fix HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-05-11T16:21:11.980000-04:00
2458503 JUSTICE FOR JAKE ed578083-4d45-4230-94d5-17f5f4f666fe 2TY JUSTICE FOR JAKE 401104713 JUSTICE FOR JAKE 2020 second_quarter           0 1 2020-05-12T02:31:25.507000-04:00
2458558 THE CORMAC GROUP, LLC bfcf7fe7-2c28-4c2f-a368-89deedffadff 2T THE CORMAC GROUP, LLC 66773 MAGIC LEAP, 2020 second_quarter TAX CARES Act HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2020-05-12T16:18:53.107000-04:00
2458559 THE CORMAC GROUP, LLC bfcf7fe7-2c28-4c2f-a368-89deedffadff 2T THE CORMAC GROUP, LLC 66773 MAGIC LEAP, 2020 second_quarter BUD Appropriations, funding HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2020-05-12T16:18:53.107000-04:00
2458619 ALLERGAN USA, INC. 6d50b898-5265-4457-9302-c6012138cdb8 2T ALLERGAN USA, INC. 63837 ALLERGAN USA, INC. 2020 second_quarter TRD Advocacy of Allergan's Social Contract with Patients to encourage greater access to innovative medicines; support for strategic, market-based international trade policies to improve patient access and intellectual property protections of life-saving therapies. Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office   230000 0 1 2020-05-13T14:51:32.380000-04:00
2458620 ALLERGAN USA, INC. 6d50b898-5265-4457-9302-c6012138cdb8 2T ALLERGAN USA, INC. 63837 ALLERGAN USA, INC. 2020 second_quarter TAX Issues relating to tax moratoriums for medical devices. Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office   230000 0 1 2020-05-13T14:51:32.380000-04:00
2458621 ALLERGAN USA, INC. 6d50b898-5265-4457-9302-c6012138cdb8 2T ALLERGAN USA, INC. 63837 ALLERGAN USA, INC. 2020 second_quarter MMM Proposals to maintain and strengthen patient access to needed prescription medicine and medical devices under the Medicare and Medicaid programs; advocacy for access to personalized treatment options for low income populations; supporting regulations to empower health care decisions between health care providers and patients; issues related to Administration actions which would allow patients to save out-of-pocket expenses on their prescription drugs. Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office   230000 0 1 2020-05-13T14:51:32.380000-04:00
2458622 ALLERGAN USA, INC. 6d50b898-5265-4457-9302-c6012138cdb8 2T ALLERGAN USA, INC. 63837 ALLERGAN USA, INC. 2020 second_quarter PHA Supporting proposals to strengthen cGMP; encouraging full implementation and enforcement of the Drug Quality and Safety Act. Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office   230000 0 1 2020-05-13T14:51:32.380000-04:00
2458623 ALLERGAN USA, INC. 6d50b898-5265-4457-9302-c6012138cdb8 2T ALLERGAN USA, INC. 63837 ALLERGAN USA, INC. 2020 second_quarter CPT Proposals to enhance intellectual property protections to meet unmet medical needs, notably research and development of life-saving therapies; proposals to modify the Food Drug and Cosmetic Act which simplify pathways to approve patent claims. Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office   230000 0 1 2020-05-13T14:51:32.380000-04:00
2458624 ALLERGAN USA, INC. 6d50b898-5265-4457-9302-c6012138cdb8 2T ALLERGAN USA, INC. 63837 ALLERGAN USA, INC. 2020 second_quarter DIS Support for proposals to provide economic relief to small businesses and income security for affected populations in light of the coronavirus pandemic. Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office   230000 0 1 2020-05-13T14:51:32.380000-04:00
2458625 ALLERGAN USA, INC. 6d50b898-5265-4457-9302-c6012138cdb8 2T ALLERGAN USA, INC. 63837 ALLERGAN USA, INC. 2020 second_quarter HCR Proposals encouraging research and development and manufacturing of potentially life-saving treatments and ensuring patient access to improve quality of life; supporting protections for patients from illegal and inappropriate exposure to counterfeit and diverted medicines; promoting new therapeutic approaches to gene therapy and tissue replacement toward unmet medical needs; education regarding emerging health care concerns surrounding rare and undiagnosed diseases; support for providing incentives to encourage development of novel anti-infective treatments to counter microbial resistant diseases; support for protecting research and development for novel diagnostics, treatments and vaccines. Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,White House Office   230000 0 1 2020-05-13T14:51:32.380000-04:00
2458683 BECKER & POLIAKOFF, P.A. cc49b505-8343-4c0a-9dcd-80e3d439cc62 2TY BECKER & POLIAKOFF, P.A. 283696 ENTERPRISE FLORIDA, INC. 2020 second_quarter           0 1 2020-05-15T09:08:07.070000-04:00
2458684 MILLENNIAL GR & PUBLIC AFFAIRS PARTNERS 37a4c290-24db-49bf-bd91-6661bfe78f28 2TY MILLENNIAL GR & PUBLIC AFFAIRS PARTNERS 401105271 INTELLECTUAL VENTURES MANAGEMENT 2020 second_quarter       50000   0 1 2020-05-15T11:42:09.910000-04:00
2458799 HOLLRAH LLC abab1d7b-4fe0-4594-bfa0-5b7dc77e02ae 2T HOLLRAH LLC 70437 MYSTERY SHOPPING PROVIDERS ASSOCIATION, INC. 2020 second_quarter TAX Defending independent-contractor status and Section 530 of the Revenue Act of 1978, opposing tax withholding on payments to independent contractors. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE     0 1 2020-05-18T08:29:17.200000-04:00
2458800 HOLLRAH LLC abab1d7b-4fe0-4594-bfa0-5b7dc77e02ae 2T HOLLRAH LLC 70437 MYSTERY SHOPPING PROVIDERS ASSOCIATION, INC. 2020 second_quarter LBR Defending independent-contractor status; urging harmonized definition of "employee" for purposes of federal statutes; supporting the Modern Worker Empowerment Act, H.R. 4069 and S. 2973. HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),SENATE     0 1 2020-05-18T08:29:17.200000-04:00
2458823 WHITMER & WORRALL, LLC b6b92465-3f4d-4fed-b44e-41c2ba538d90 2T WHITMER & WORRALL, LLC 292892 YOUSCRIPT 2020 second_quarter HCR Issues related to medication management software and pharmacogenetic testing. HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2020-05-18T16:10:33.800000-04:00
2458824 WHITMER & WORRALL, LLC b6b92465-3f4d-4fed-b44e-41c2ba538d90 2T WHITMER & WORRALL, LLC 292892 YOUSCRIPT 2020 second_quarter VET Issues related to medication management software and pharmacogenetic testing. HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2020-05-18T16:10:33.800000-04:00
2458825 WHITMER & WORRALL, LLC b6b92465-3f4d-4fed-b44e-41c2ba538d90 2T WHITMER & WORRALL, LLC 292892 YOUSCRIPT 2020 second_quarter BUD issues related to the Fiscal Year 2021 Military Construction, Veterans Affairs, and Related Agencies Appropriations Bill. HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2020-05-18T16:10:33.800000-04:00
2458826 WHITMER & WORRALL, LLC c9c04aeb-a914-4422-a831-4e5ae4c7ba16 2T WHITMER & WORRALL, LLC 292892 DOCUSIGN 2020 second_quarter SCI Issues related to the implementation of H.R. 5759, the 21st Century Integrated Digital Experience (IDEA) Act. Issues related to assisting federal government agencies with prioritizing and delivering the digitization of government services and forms. Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Consumer Financial Protection Bureau (CFPB),General Services Administration (GSA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Natl Transportation Safety Board (NTSB),Office of Personnel Management (OPM),Overseas Private Investment Corp (OPIC),Pension Benefit Guaranty Corporation (PBGC),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Postal Service (USPS),Veterans Affairs, Dept of (VA),White House Office 10000   0 1 2020-05-18T16:24:34.737000-04:00
2458827 WHITMER & WORRALL, LLC c9c04aeb-a914-4422-a831-4e5ae4c7ba16 2T WHITMER & WORRALL, LLC 292892 DOCUSIGN 2020 second_quarter GOV Issues related to the implementation of H.R. 5759, the 21st Century Integrated Digital Experience (IDEA) Act. Issues related to assisting federal government agencies with prioritizing and delivering the digitization of government services and forms. Issues related to the implementation of H.R. 748, the Coronavirus Aid, Relief, and Economic Security (CARES) Act and federal agency continuity of operations. Agriculture, Dept of (USDA),AMTRAK - Natl Railroad Passenger Corporation,Army, Dept of (Corps of Engineers),Commerce, Dept of (DOC),Consumer Financial Protection Bureau (CFPB),General Services Administration (GSA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Housing & Urban Development, Dept of (HUD),Interior, Dept of (DOI),Natl Transportation Safety Board (NTSB),Office of Personnel Management (OPM),Overseas Private Investment Corp (OPIC),Pension Benefit Guaranty Corporation (PBGC),SENATE,Small Business Administration (SBA),State, Dept of (DOS),Transportation, Dept of (DOT),U.S. Postal Service (USPS),Veterans Affairs, Dept of (VA),White House Office 10000   0 1 2020-05-18T16:24:34.737000-04:00
2458853 FIRST SOLAR, INC. 25564e14-9eeb-4646-a15b-b408f8f301f9 2TY FIRST SOLAR, INC. 400569712 FIRST SOLAR INC 2020 second_quarter         100000 0 1 2020-05-19T12:02:54.037000-04:00
2458862 HUSCH BLACKWELL, LLP c67bc085-e7cc-4704-abe7-b9c4a9f839f1 2TY HUSCH BLACKWELL, LLP 6303 FORT BEND COUNTY LEVEE IMPROVEMENT DISTRICT #2 2020 second_quarter           0 1 2020-05-19T16:37:05.240000-04:00
2458865 HUSCH BLACKWELL, LLP baf9353e-835e-4111-900a-cd3903ea7929 2TY HUSCH BLACKWELL, LLP 6303 JTPI, LLC 2020 second_quarter           0 1 2020-05-19T16:38:06.990000-04:00
2458866 HUSCH BLACKWELL, LLP 1530c76b-2529-41a4-be47-270dd61c2aa4 2TY HUSCH BLACKWELL, LLP 6303 SPECIAL HEALTH RESOURCES FOR TEXAS, INC. 2020 second_quarter           0 1 2020-05-19T16:39:07.820000-04:00
2458867 HUSCH BLACKWELL, LLP 8533a1f0-cbdc-46dc-944e-7fdc829ff1c8 2TY HUSCH BLACKWELL, LLP 6303 WILLIAM JEWELL COLLEGE 2020 second_quarter           0 1 2020-05-19T16:40:08.567000-04:00
2458890 BGR GOVERNMENT AFFAIRS 6363eba0-8942-4b18-9411-133c2022715c 2TY BGR GOVERNMENT AFFAIRS 5357 EBURY STREET CAPITAL, LLC 2020 second_quarter           0 1 2020-05-20T16:47:40.417000-04:00
2458899 PILLSBURY WINTHROP SHAW PITTMAN LLP e3733b52-4548-4f9e-bb6f-544de2523e2a 2TY PILLSBURY WINTHROP SHAW PITTMAN LLP 35002 CITY OF BURLINGTON, NORTH CAROLINA 2020 second_quarter           0 1 2020-05-21T14:20:52.130000-04:00
2458904 BGR GOVERNMENT AFFAIRS e7fcc2c8-ac55-4933-b0d2-8a88712cecb2 2TY BGR GOVERNMENT AFFAIRS 5357 LEGISLATIVE LEADERSHIP INSTITUTE 2020 second_quarter           0 1 2020-05-21T16:26:59.080000-04:00
2458905 BGR GOVERNMENT AFFAIRS 83744e4c-a07c-4198-9b44-3be98f1419c0 2TY BGR GOVERNMENT AFFAIRS 5357 SHIJI GROUP 2020 second_quarter           0 1 2020-05-21T16:56:59.647000-04:00
2458906 BGR GOVERNMENT AFFAIRS 7363b3e7-1e03-47f9-804a-3a30691d1e1d 2@ BGR GOVERNMENT AFFAIRS 5357 SHIJI GROUP 2020 second_quarter GOV Provide strategic guidance and counsel on a USG issue impacting the Company. Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 80000   0 1 2020-05-21T17:55:00.513000-04:00
2458998 THE PETRIZZO GROUP, INC. a1b43f7d-8c93-4f18-a2a1-bd27a37d5673 2TY THE PETRIZZO GROUP, INC. 305932 ALLENA PHARMACEUTICALS 2020 second_quarter           0 1 2020-05-22T16:16:45.590000-04:00
2459208 RPN ADVOCACY, LLC 86974a27-86fe-4464-ab4a-81246c558be5 Q2 RPN ADVOCACY, LLC 401105542 TACITUS, LLC 2020 second_quarter ENV NEPA related permitting Bureau of Land Management (BLM),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2020-05-26T15:16:22.993000-04:00
2459209 RPN ADVOCACY, LLC 86974a27-86fe-4464-ab4a-81246c558be5 Q2 RPN ADVOCACY, LLC 401105542 TACITUS, LLC 2020 second_quarter ENG Helium related energy development and extraction policy Bureau of Land Management (BLM),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2020-05-26T15:16:22.993000-04:00
2459289 BGR GOVERNMENT AFFAIRS 87818959-3389-4bca-b9dc-24ce5fe36276 2TY BGR GOVERNMENT AFFAIRS 5357 ALKERMES, INC. 2020 second_quarter           0 1 2020-05-27T16:59:10.030000-04:00
2459290 FORBES-TATE 24f3102a-7dc9-4ba1-9c46-9c7b9c305acd 2T FORBES-TATE 400976792 COMCAST CORPORATION 2020 second_quarter TAX Issues related to the implementation of corporate tax reform. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2020-05-27T17:00:10.703000-04:00
2459291 FORBES-TATE 24f3102a-7dc9-4ba1-9c46-9c7b9c305acd 2T FORBES-TATE 400976792 COMCAST CORPORATION 2020 second_quarter TEC Issues related to net neutrality, rural broadband, privacy, infrastructure deployment, and broadband mapping. HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2020-05-27T17:00:10.703000-04:00
2459347 FLORIDA BANKERS ASSOCIATION cabd65e9-31e5-4c8e-b3b2-a2e9f2891e0c Q2 FLORIDA BANKERS ASSOCIATION 305511 FLORIDA BANKERS ASSOCIATION 2020 second_quarter BAN BSA/AML Regulatory Relief Credit Unions HOUSE OF REPRESENTATIVES,SENATE     0 0 2020-05-28T15:57:35.253000-04:00
2459349 THE POLICY GROUP, INC. 3d680201-7139-4182-983e-0f126de6b838 2TY THE POLICY GROUP, INC. 401103518 NATIONAL PORK PRODUCERS COUNCIL 2020 second_quarter           0 1 2020-05-29T09:21:43.647000-04:00
2459350 THE POLICY GROUP, INC. 965fbdcd-64de-463d-af6e-171d4b8de685 2TY THE POLICY GROUP, INC. 401103518 RAI SERVICES COMPANY 2020 second_quarter           0 1 2020-05-29T09:35:44.480000-04:00
2459377 WARWICK GROUP CONSULTANTS, LLC b3e832e5-9021-43b1-8e9c-85a0a97ca37a 2T WARWICK GROUP CONSULTANTS, LLC 401103619 CITY OF SAN CLEMENTE 2020 second_quarter BUD Construction funds for shore protection Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2020-05-29T11:46:54.453000-04:00
2459394 MILLER & CHEVALIER CHARTERED d10adb1e-0ebc-486d-ac9c-6da10f4a4e79 2T MILLER & CHEVALIER CHARTERED 25306 PRITIKIN ICR LLC 2020 second_quarter HCR Monitor legislation related to Medicare coverage for chronic cardiac patients. HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-06-01T09:51:17.513000-04:00
2459395 MILLER & CHEVALIER CHARTERED d10adb1e-0ebc-486d-ac9c-6da10f4a4e79 2T MILLER & CHEVALIER CHARTERED 25306 PRITIKIN ICR LLC 2020 second_quarter MMM Monitoring legislation related to Medicare coverage for chronic cardiac patients. HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-06-01T09:51:17.513000-04:00
2459396 CASSIDY & ASSOCIATES, INC. a0a50fa3-ac1b-48b6-8742-919a55457e4d 2T CASSIDY & ASSOCIATES, INC. 8453 CKP INSURANCE 2020 second_quarter AGR Apiculture; Pasture, Rangeland & Forage Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-06-01T09:54:18.457000-04:00
2459397 MILLER & CHEVALIER CHARTERED 33feef08-96a4-4611-8081-12e7e3e5737f 2T MILLER & CHEVALIER CHARTERED 25306 TRINET GROUP, INC. 2020 second_quarter SMB Paycheck Protection Program HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),SENATE,Small Business Administration (SBA),Treasury, Dept of 30000   0 1 2020-06-01T09:58:19.060000-04:00
2459399 LOBO STRATEGIES 6e5817c5-b47a-4304-a854-19657ecabc34 2T LOBO STRATEGIES 401105642 ROCK-IT CARGO USA LLC 2020 second_quarter TRA Assisting federal COVID-19 response efforts including logistical support for repatriation of Americans abroad and transport of PPE Army, Dept of (Corps of Engineers),Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)     0 1 2020-06-01T10:05:20.587000-04:00
2459439 PALE BLUE, LLC e4935eb7-2b0c-4b94-af84-dc1f372361c3 Q2 PALE BLUE, LLC 401103835 DEMAND PROGRESS, PROJECT OF SIXTEEN THIRTY FUND 2020 second_quarter GOV On improving Congressional and public transparency around Office of Legal Counsel opinions from the Department of Justice, in support of HR4556, the OLC SUNLIGHT Act of 2019. HOUSE OF REPRESENTATIVES,SENATE     0 0 2020-06-01T19:10:37.607000-04:00
2459440 PALE BLUE, LLC e4935eb7-2b0c-4b94-af84-dc1f372361c3 Q2 PALE BLUE, LLC 401103835 DEMAND PROGRESS, PROJECT OF SIXTEEN THIRTY FUND 2020 second_quarter INT Curtailing surveillance under the USA PATRIOT Act/USA FREEDOM Act. HOUSE OF REPRESENTATIVES,SENATE     0 0 2020-06-01T19:10:37.607000-04:00
2459441 PALE BLUE, LLC e4935eb7-2b0c-4b94-af84-dc1f372361c3 Q2 PALE BLUE, LLC 401103835 DEMAND PROGRESS, PROJECT OF SIXTEEN THIRTY FUND 2020 second_quarter DEF On restoring Congress's War Powers authority pursuant to the Constitution and the War Powers Resolution. HOUSE OF REPRESENTATIVES,SENATE     0 0 2020-06-01T19:10:37.607000-04:00
2459442 PALE BLUE, LLC e4935eb7-2b0c-4b94-af84-dc1f372361c3 Q2 PALE BLUE, LLC 401103835 DEMAND PROGRESS, PROJECT OF SIXTEEN THIRTY FUND 2020 second_quarter CIV Curtailing surveillance under the USA PATRIOT Act/USA FREEDOM Act, opposing the House-passed version of HR6172, the USA FREEDOM Reauthorization Act. HOUSE OF REPRESENTATIVES,SENATE     0 0 2020-06-01T19:10:37.607000-04:00
2459443 PALE BLUE, LLC e4935eb7-2b0c-4b94-af84-dc1f372361c3 Q2 PALE BLUE, LLC 401103835 DEMAND PROGRESS, PROJECT OF SIXTEEN THIRTY FUND 2020 second_quarter FOR In support of removing United States Armed Forces from hostilities in the Republic of Yemen that have not been authorized by Congress, as well as in support of SJRes 68, which requires the President to seek congressional authorization before engaging in further military action against Iran. HOUSE OF REPRESENTATIVES,SENATE     0 0 2020-06-01T19:10:37.607000-04:00
2459451 RED+BLUE STRATEGIES 65c936e5-2dd1-4cd4-b2a3-9050305dfbd2 2T RED+BLUE STRATEGIES 400693064 AMERICAN SOCIETY FROM RADIATION ONCOLOGY (ASTRO) 2020 second_quarter HCR H.R. 6800 - The Heroes Act - Inclusion of policies that support Medicare and Medicaid coverage of people with cancer and treating physicians. H.R. 6074 - The Coronavirus Preparedness and Response Supplemental Appropriations Act of 2020 - Issues related to the implementation of policies supporting physicians treating patients and their challenges during the COVID-19 pandemic. H.R. 6201 - THe Families First Coronavirus Response Act - Issues related to the implementation of policies ensuring that physicians have the tools and resources they need to care for and protect their patients during the COVID-19 pandemic. H.R. 748 - The CARES Act - Issues related to ensuring that physician practices have the resources need to care for their patients throughout the COVID-19 pandemic. H.R. 6074 - The Coronavirus Preparedness and Response Supplemental Appropriations Act of 2020 - Issues related to supporting physicians treating patients and their challenges during the COVID-19 pandemic. H.R. 6201 - The Families First Coronavirus Response Act - Issues related to ensuring that physicians have the tools and resources they need to care for and protect their patients during the COVID-19 pandemic. H.R. 748 - The CARES Act - Issues related to the implementation of policies ensuring that physician practices have the resources need to care for their patients throughout the COVID-19 pandemic. H.R. 3107 - Issues related to practices regarding prior authorization for certain cancer treatments. Issues related to CMMI's treatment of proposals for the Radiation Oncology Advance Payment Model (ROAPM) Issues related to ensuring that cancer patients in rural and underserved communities have access to radiation oncology services if it is part of their treatment plans. HOUSE OF REPRESENTATIVES,SENATE 40000   0 1 2020-06-02T09:50:46.240000-04:00
2459452 RED+BLUE STRATEGIES 65c936e5-2dd1-4cd4-b2a3-9050305dfbd2 2T RED+BLUE STRATEGIES 400693064 AMERICAN SOCIETY FROM RADIATION ONCOLOGY (ASTRO) 2020 second_quarter MMM H.R. 6800 - The Heroes Act - Inclusion of policies that support Medicare and Medicaid coverage of people with cancer and treating physicians. H.R. 6074 - The Coronavirus Preparedness and Response Supplemental Appropriations Act of 2020 - Implementation of policies related to supporting physicians treating patients and their challenges during the COVID-19 pandemic. H.R. 6201 - THe Families First Coronavirus Response Act - Issues related the implementation of policies ensuring that physicians have the tools and resources they need to care for and protect their patients during the COVID-19 pandemic. H.R. 748 - The CARES Act - Issues related the implementation of policies that ensure that physician practices have the resources need to care for their patients throughout the COVID-19 pandemic. H.R. 3107 - Issues related to practices regarding prior authorization for certain cancer treatments. Issues related to CMMI's treatment of proposals for the Radiation Oncology Advance Payment Model (ROAPM) Issues related to ensuring that cancer patients in rural and underserved communities have access to radiation oncology services if it is part of their treatment plans. HOUSE OF REPRESENTATIVES,SENATE 40000   0 1 2020-06-02T09:50:46.240000-04:00
2459576 CLARK HILL, PLC f37be3e1-36d9-4f6e-b5b4-3046160b76ee 2TY CLARK HILL, PLC 287771 FEDERAL HOME LOAN BANK OF SAN FRANCISCO 2020 second_quarter           0 1 2020-06-02T11:11:29.277000-04:00
2459708 MAPETSI POLICY GROUP cd537f47-abe2-4837-96de-15e2fed484c9 2T MAPETSI POLICY GROUP 400598824 LAGUNA DEVELOPMENT CORPORATION 2020 second_quarter IND economic development Interior, Dept of (DOI),Natl Indian Gaming Commission     0 1 2020-06-02T14:16:09.977000-04:00
2459797 VENG GROUP 73c9a9c8-7361-4c8e-a1ea-d505af558b23 Q2 VENG GROUP 400881577 NATIONAL ASIAN PACIFIC AMERICAN BAR ASSOCIATION 2020 second_quarter CIV judicial nominations SENATE 7500   0 0 2020-06-02T23:29:56.433000-04:00
2459798 VENG GROUP 4e814f7a-aed4-448a-a2db-466952170c5f Q2Y VENG GROUP 400881577 MNET MEDIA 2020 second_quarter           0 0 2020-06-02T23:30:56.917000-04:00
2459799 VENG GROUP e8b92aac-9ae8-4464-8623-61de125596c9 Q2Y VENG GROUP 400881577 CHINESE AMERICAN CITIZENS ALLIANCE - NATIONAL LODGE 2020 second_quarter           0 0 2020-06-02T23:31:57.360000-04:00
2459819 LEBLANC GOVERNMENT RELATIONS, LLC a68f2658-896e-49e3-817b-5d9f8a42f1e0 2T LEBLANC GOVERNMENT RELATIONS, LLC 400670003 CROSSROADS STRATEGIES ON BEHALF OF ALITHEON, INC. 2020 second_quarter DEF In support of the adoption of Alitheon technology in defense-wide supply chains Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID)     0 1 2020-06-03T09:45:04.357000-04:00
2459820 LEBLANC GOVERNMENT RELATIONS, LLC a68f2658-896e-49e3-817b-5d9f8a42f1e0 2T LEBLANC GOVERNMENT RELATIONS, LLC 400670003 CROSSROADS STRATEGIES ON BEHALF OF ALITHEON, INC. 2020 second_quarter PHA In support of Alitheon technology for pharmaceutical verification in difficult locations. Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID)     0 1 2020-06-03T09:45:04.357000-04:00
2459821 LEBLANC GOVERNMENT RELATIONS, LLC a68f2658-896e-49e3-817b-5d9f8a42f1e0 2T LEBLANC GOVERNMENT RELATIONS, LLC 400670003 CROSSROADS STRATEGIES ON BEHALF OF ALITHEON, INC. 2020 second_quarter TRA In support of the adoption of Alitheon technology by the TSA Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID)     0 1 2020-06-03T09:45:04.357000-04:00
2459822 LEBLANC GOVERNMENT RELATIONS, LLC a68f2658-896e-49e3-817b-5d9f8a42f1e0 2T LEBLANC GOVERNMENT RELATIONS, LLC 400670003 CROSSROADS STRATEGIES ON BEHALF OF ALITHEON, INC. 2020 second_quarter HOM In support of the adoption of Alitheon technology by TSA and CBP Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Agency for International Development (USAID)     0 1 2020-06-03T09:45:04.357000-04:00
2459844 ACT FOR AMERICA 71d75987-c9ae-47d0-a53f-55380b2ea76b Q2Y ACT FOR AMERICA 400434104 ACT FOR AMERICA 2020 second_quarter           0 0 2020-06-03T13:43:15.397000-04:00
2459854 THE PICARD GROUP, LLC fcb77b33-8cb2-43cd-8d38-1f0cea14b35a 2T THE PICARD GROUP, LLC 400711132 ACADIAN COMPANIES 2020 second_quarter VET Payment re-imbursement issues. HOUSE OF REPRESENTATIVES,SENATE 10000   0 1 2020-06-03T15:26:22.077000-04:00
2459885 A1.9 STRATEGIES LLC 66c57a4c-60e4-46f9-a987-6acfda2bb7a8 2T A1.9 STRATEGIES LLC 401104281 VIKEN DETECTION 2020 second_quarter HOM DHS CBP Adoption of millimeter wave handheld and undercarriage detection devices; acceleration of Non-intrusive inspection, primary POV testing and deployment of systems. HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-06-04T09:18:36.483000-04:00
2459889 A1.9 STRATEGIES LLC 9f95f7cd-4505-4f95-a77f-e1bb05d80708 Q2 A1.9 STRATEGIES LLC 401104281 VIKEN DETECTION 2020 second_quarter HOM DHS CBP Adoption of millimeter wave handheld and undercarriage detection devices; acceleration of Non-intrusive inspection, primary POV testing and deployment of systems. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2020-06-04T12:23:43.927000-04:00
2459890 A1.9 STRATEGIES LLC 6f13666c-5aa8-46a4-adea-ef6a39535934 2T A1.9 STRATEGIES LLC 401104281 CROWDVISION 2020 second_quarter HOM TSA Modernization Act - Section 1922 Real Time, Wait Time Reporting HOUSE OF REPRESENTATIVES,SENATE     0 1 2020-06-04T12:25:44.407000-04:00
2459891 NORTH SHORE CONSULTANTS 802d96c7-a9f3-4929-b93c-cde480cdffad Q2 NORTH SHORE CONSULTANTS 29516 OCEAN EXPLORATION TRUST 2020 second_quarter EDU FY 2021 CJS Appropriations Bill HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2020-06-04T13:22:45.337000-04:00
2459892 NORTH SHORE CONSULTANTS 802d96c7-a9f3-4929-b93c-cde480cdffad Q2 NORTH SHORE CONSULTANTS 29516 OCEAN EXPLORATION TRUST 2020 second_quarter SCI FY 2021 CJS Appropriations Bill HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2020-06-04T13:22:45.337000-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 1997.324ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API