home / openregs

lobbying_filings

Senate Lobbying Disclosure Act filings (1999–2026). LD-1 registrations and LD-2 quarterly activity reports. 1.5M+ filings.

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

93,470 rows where filing_year = 2022 sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

filing_year 1

  • 2022 · 93,470 ✖
filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year ▲ filing_period received_date amount_reported is_amendment is_no_activity is_termination
a71de50d-ce0b-4056-b699-05368ec543ba RR 401103986 MR. BRIAN DEARING 213170 CREATIVE TENT INTERNATIONAL 2022 first_quarter 2022-01-01T14:12:24-05:00   0 0 0
00ec8a9e-35d6-4bcf-a43a-da032d3723bc RA 2822 AMERICAN MALTING BARLEY ASSOCIATION, INC. 103601 AMERICAN MALTING BARLEY ASSOCIATION, INC. 2022 first_quarter 2022-01-03T11:28:38-05:00   1 0 0
606530b1-f1a6-4c86-891c-1b19c413a103 RR 401106349 STRATHMORE HEALTH STRATEGY 213177 GISKIT PHARMA 2022 first_quarter 2022-01-03T15:28:25-05:00   0 0 0
da28266e-90ad-46b5-aa54-bcf6fdfb5c36 RR 401104738 PETER DAMON GROUP LLC 213179 STATE FEDERAL STRATEGIES ON BEHALF OF HEAT AND FROST INSULATORS (LMCT) 2022 first_quarter 2022-01-03T18:50:59-05:00   0 0 0
1cb6546a-74e5-489a-aa65-ffd600472919 RR 401104213 BC CONSULTING, LLC 213178 NATIONAL MOTOR FREIGHT TRAFFIC ASSOCIATION 2022 first_quarter 2022-01-03T19:19:48-05:00   0 0 0
8e8fdd52-6697-4bff-b691-68316342e1d3 RR 400400892 ATS COMMUNICATIONS, INC. (DBA SILBEY STRATEGIES) 213184 REGENT CRAFT, INC. 2022 first_quarter 2022-01-04T06:55:43-05:00   0 0 0
b500f55d-10df-4da8-9797-f3a03caabc5f RA 12835 DUQUESNE LIGHT HOLDINGS, INC. (FKA DUQUESNE LIGHT COMPANY) 117814 DUQUESNE LIGHT HOLDINGS, INC. (FKA DUQUESNE LIGHT COMPANY) 2022 first_quarter 2022-01-04T11:01:52-05:00   1 0 0
38b2c1c5-25f0-4314-bd58-72729b3bd2dc RR 401106344 DAPPER LABS, INC. 213183 DAPPER LABS, INC. 2022 first_quarter 2022-01-04T11:19:32-05:00   0 0 0
21fcca3f-ca4a-4472-b83f-52f318fd6f2a RR 401104385 WASHINGTON ADVOCACY GROUP 213186 BLACKSTONE CONSTRUCTION LLC 2022 first_quarter 2022-01-04T11:44:20-05:00   0 0 0
767e1b68-4b55-4169-b051-0c67d0afb829 RR 401105820 DIROMA ECK & CO. LLP 213187 MARATHON DIGITAL HOLDINGS, INC. 2022 first_quarter 2022-01-04T12:32:25-05:00   0 0 0
33b1d4d9-3976-4e95-9fcc-472d58df96a7 RR 401104374 LINCOLN PARK GROUP L.L.C. 213185 K&L GATES LLP ON BEHALF OF CYANCO INTERNATIONAL 2022 first_quarter 2022-01-04T13:27:44-05:00   0 0 0
810bdd94-7227-4d8c-a12c-9f6dcc5664ad RR 818 ALCALDE & FAY 213188 APPLIED RESEARCH ASSOCIATES, INC. 2022 first_quarter 2022-01-04T15:04:58-05:00   0 0 0
63e5442a-1d98-42d4-8083-cc8615b287ca RR 401104071 NEW CENTURY GOVERNMENT AFFAIRS (F/K/A TERRENCE C. WOLFE) 213189 M&S MEDIA, INC. 2022 first_quarter 2022-01-04T15:13:36-05:00   0 0 0
675a3d4d-5920-46ea-a0b1-8458b2b0811f RR 401104304 MR. LANDON FULMER 213192 MEDICAL DEVELOPMENT MANAGEMENT 2022 first_quarter 2022-01-05T10:21:04-05:00   0 0 0
b42bc13a-f6d3-4547-8e20-ae8f718eff05 RR 401103443 ANN WARNER LLC 213193 NATIONAL INDUSTRIAL TRANSPORTATION LEAGUE 2022 first_quarter 2022-01-05T11:54:23-05:00   0 0 0
6e5e60ef-8677-4046-8676-a530553827ef RR 293233 MR. MARK KOPEC 213195 HUDSON SUSTAINABLE GROUP, LLC 2022 first_quarter 2022-01-05T14:24:00-05:00   0 0 0
6a2b8300-47f6-4a38-91ca-f434cfa2aa6c RR 294212 G S PROCTOR AND ASSOCIATES, INC 213207 MELWOOD HORTICULTURAL TRAINING CENTER 2022 first_quarter 2022-01-05T14:50:14-05:00   0 0 0
9e7d8786-df58-4e51-b4a1-61541d765e58 RA 401104825 ILLUMINA, INC. 202795 ILLUMINA, INC. 2022 first_quarter 2022-01-05T14:53:09-05:00   1 0 0
8bf04d7d-8650-4610-87d1-87de0a7baca0 RR 401105566 CONSILIUM CONSULTING 213212 COMCAST CORPORATION 2022 first_quarter 2022-01-06T10:22:32-05:00   0 0 0
48766dcc-9e0c-436b-9405-40071da90c1b RR 24486 MCGUIREWOODS CONSULTING (A SUBSIDIARY OF MCGUIREWOODS LLP) 213205 GALESBURG COTTAGE HOSPITAL 2022 first_quarter 2022-01-06T10:45:31-05:00   0 0 0
e8ce68f7-6808-4337-941a-e29a61a57ca1 RR 401106343 DAIMLER TRUCK NORTH AMERICA LLC 213211 DAIMLER TRUCK NORTH AMERICA LLC 2022 first_quarter 2022-01-06T14:59:30-05:00   0 0 0
e94b126b-0447-401c-90f0-653adc914457 RR 401106318 MERCARI, INC. 213218 MERCARI, INC. 2022 first_quarter 2022-01-06T19:58:38-05:00   0 0 0
3643cb50-872d-48f2-b3b9-3943763c6c45 RA 401105566 CONSILIUM CONSULTING 213212 COMCAST CORPORATION 2022 first_quarter 2022-01-06T21:20:41-05:00   1 0 0
3be53ab0-e154-4244-8ff1-c6c59c145b98 RR 401104718 HB STRATEGIES 213221 A3 GLOBAL, INC. 2022 first_quarter 2022-01-07T10:37:02-05:00   0 0 0
c1b9c624-51bb-47ea-9034-09fb75454579 1TY 46585 LIEBMAN & ASSOCIATES, INC. 212864 ENERGETICO, INC. 2022 first_quarter 2022-01-07T11:25:47.837000-05:00   0 0 1
e2c934d1-a956-47cd-b00f-bbb5a0fb181a RR 40044351 GRASSROOTS POLITICAL CONSULTING LLC 213224 AVICENA SYSTEMS LTD. 2022 first_quarter 2022-01-07T12:43:23-05:00   0 0 0
b047b74b-4404-46a2-b865-3537c034acf1 RR 401103348 MCCAULLEY&COMPANY 213223 NAMI OHIO 2022 first_quarter 2022-01-07T14:31:12-05:00   0 0 0
3d309189-7ca1-4c0e-b6ef-e193c4f54d36 RR 401103348 MCCAULLEY&COMPANY 213230 EAST LIVERPOOL COMMUNITY PARTNERSHIP FOR REVITALIZATION 2022 first_quarter 2022-01-07T14:44:29-05:00   0 0 0
39adb162-0f0b-4b66-b049-e15ef0d04e3c RR 401105536 TRAVAGLINI SCORZONI KILEY LLC 213234 OCS-A 0522, LLC 2022 first_quarter 2022-01-07T17:44:34-05:00   0 0 0
d07abd13-ded8-4c0f-a633-30ce67c48fab RR 401103955 DOWNS GOVERNMENT AFFAIRS 213232 KERN COMMUNITY COLLEGE DISTRICT 2022 first_quarter 2022-01-08T10:20:20-05:00   0 0 0
00376ba9-0e87-4172-a3cc-113de5d231b5 RR 401103955 DOWNS GOVERNMENT AFFAIRS 213228 SAN DIEGO COMMUNITY COLLEGE DISTRICT 2022 first_quarter 2022-01-08T10:24:17-05:00   0 0 0
356360ef-bda7-454d-8f22-9527bacda274 RR 7268 BROYDRICK & ASSOCIATES 213227 KENOSHA COUNTY 2022 first_quarter 2022-01-08T12:17:33-05:00   0 0 0
ebeafdf6-584a-4fa9-a34e-9113919bba67 RA 283696 BECKER & POLIAKOFF, P.A. 212433 CONVERGED SERVICES, INC. 2022 first_quarter 2022-01-08T14:30:09-05:00   1 0 0
c3383848-ed4e-42bf-b433-b85ca833ee4c RR 283696 BECKER & POLIAKOFF, P.A. 213231 HISPANIC NATIONAL BAR ASSOCIATION 2022 first_quarter 2022-01-08T14:40:43-05:00   0 0 0
1db02097-77d5-449a-980c-4682ee35e3bc RR 283696 BECKER & POLIAKOFF, P.A. 213233 RAILSPIRE LLC 2022 first_quarter 2022-01-08T14:47:39-05:00   0 0 0
51995ec8-6245-4719-b9e6-383452d3cfe5 RR 35640 CARPI & CLAY, INC 213241 MONTEREY ONE WATER 2022 first_quarter 2022-01-10T11:29:51-05:00   0 0 0
4fe1a52e-6567-492c-af0f-f349ba29110f RR 283878 VERITAS ADVISORS, LLP 213242 CLEARWATER PAPER 2022 first_quarter 2022-01-10T13:53:00-05:00   0 0 0
2c0e428b-1011-445c-b9eb-550bee6256c7 RR 84775 RICH FEUER ANDERSON 213250 ANT GROUP CO., LTD. 2022 first_quarter 2022-01-10T15:10:12-05:00   0 0 0
c036e689-492e-4177-aa09-7217d0f58a6b RR 2194 AMERICAN DEFENSE INTERNATIONAL, INC. 213249 VARDA SPACE INDUSTRIES, INC. 2022 first_quarter 2022-01-10T15:26:44-05:00   0 0 0
7737fff6-8382-4343-ab85-b88a1975f050 RR 2194 AMERICAN DEFENSE INTERNATIONAL, INC. 213254 STRATOLAUNCH, LLC 2022 first_quarter 2022-01-10T15:32:20-05:00   0 0 0
7157a336-bb27-4c2c-9904-f21c80d2f1be RR 401104408 KELLER PARTNERS & COMPANY 213256 COMMUNITY MEMORIAL HOSPITAL 2022 first_quarter 2022-01-10T16:04:05-05:00   0 0 0
721f8f55-c8d1-4914-982e-26622aa08023 RR 401104408 KELLER PARTNERS & COMPANY 213252 NEW DESTINY TREATMENT CENTER 2022 first_quarter 2022-01-10T16:09:52-05:00   0 0 0
f7116dcd-e6f3-4504-9871-c23097c16526 RR 401105959 DISTRICT CATALYST 213257 METRO AVIATION 2022 first_quarter 2022-01-11T10:39:26-05:00   0 0 0
689b114e-ad8b-4bc1-be6a-076aa8f278a1 RA 39542 UNIVERSITY OF VIRGINIA 147165 UNIVERSITY OF VIRGINIA 2022 first_quarter 2022-01-11T15:46:20-05:00   1 0 0
3f382d50-3796-484d-9dcf-834c56b1592d RR 400487397 LOBBYIT.COM 213263 TO SOIL LESS, LLC 2022 first_quarter 2022-01-11T16:23:35-05:00   0 0 0
abfaf1fb-4b01-4ca2-b288-e11ba4a0a363 RR 7268 BROYDRICK & ASSOCIATES 213273 FIT FOODZ, INC. 2022 first_quarter 2022-01-12T07:57:19-05:00   0 0 0
70f1559f-882f-4f23-834a-dda74607b65b RR 401105848 EDGE CREEK PARTNERS 213268 ALUMINUM EXTRUDERS COUNCIL 2022 first_quarter 2022-01-12T10:12:23-05:00   0 0 0
d4986f3b-7bd6-4923-919c-27d39252ef67 RR 7257 BROWNSTEIN HYATT FARBER SCHRECK, LLP 213275 DTEK INTERNATIONAL LIMITED 2022 first_quarter 2022-01-12T12:21:58-05:00   0 0 0
50f36bdb-6f2b-4eee-9cb9-5bf74f1458ca RR 401105918 BROWN & WEINRAUB ADVISORS, LLC 213269 NEW YORK CREDIT UNION ASSOCIATION, INC. 2022 first_quarter 2022-01-12T12:22:42-05:00   0 0 0
398a2eee-832a-4416-b6dc-eab20ce44f82 RR 297294 BOSE PUBLIC AFFAIRS GROUP 213270 AMERICAN POLITICAL SCIENCE ASSOCIATION 2022 first_quarter 2022-01-12T13:58:48-05:00   0 0 0
a44cb171-b0d8-481b-9626-41d3a1638908 RR 400886595 THE ROOSEVELT GROUP 213274 GUAM REGIONAL MEDICAL CITY 2022 first_quarter 2022-01-12T14:14:03-05:00   0 0 0
f1a591c6-242a-4dea-9458-e0dc01476aa9 RR 401104281 A1.9 STRATEGIES LLC 213287 O'BRIEN, GENTRY, AND SCOTT OBO SATELLES, INC. 2022 first_quarter 2022-01-12T17:38:12-05:00   0 0 0
91468850-59f9-403f-807d-8b57039a9558 RR 292538 BARKER LEAVITT, PLLC (SKA MR. JAMES C. BARKER) 213277 COVINGTON WATER DISTRICT 2022 first_quarter 2022-01-13T11:30:11-05:00   0 0 0
78237662-e7db-482c-9f66-54589855bded RR 401106174 OLD NORTH STRATEGIES, LLC 213288 EXELA PHARMA SCIENCES, LLC 2022 first_quarter 2022-01-13T11:54:02-05:00   0 0 0
8d696e9f-6669-43cd-9cd1-35b3ea7dd74a RR 401106174 OLD NORTH STRATEGIES, LLC 213294 NORTH CAROLINA FRATERNAL ORDER OF POLICE 2022 first_quarter 2022-01-13T12:03:55-05:00   0 0 0
de504b7c-68c1-47aa-af93-9b93ac93676c RR 5357 BGR GOVERNMENT AFFAIRS 213295 ARMIS 2022 first_quarter 2022-01-13T12:20:28-05:00   0 0 0
cf784e14-db00-4455-948e-ae3c7abe827b RR 10478 CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK) 213310 DISCOVERY CLEAN WATER ALLIANCE 2022 first_quarter 2022-01-13T18:09:40-05:00   0 0 0
ee81f31c-290d-4638-8eeb-ca32f10fec48 RR 401106373 WHEAT SHROYER GOVERNMENT RELATIONS LLC 213333 AMERICAN SOCIETY OF HAND THERAPISTS 2022 first_quarter 2022-01-14T09:26:39-05:00   0 0 0
f6c47876-86a0-413e-928c-abfe3647b4bd RR 401106373 WHEAT SHROYER GOVERNMENT RELATIONS LLC 213332 WALLACE ENVIRONMENTAL CONSULTING, INC. 2022 first_quarter 2022-01-14T11:14:45-05:00   0 0 0
b59b9a0c-6bd4-4caf-9eda-5b5d3115cdf4 RR 401106373 WHEAT SHROYER GOVERNMENT RELATIONS LLC 213427 THE CONAFAY GROUP ON BEHALF OF ANTIMICROBIALS WORKING GROUP 2022 first_quarter 2022-01-14T11:18:46-05:00   0 0 0
5a7a66da-44a1-459f-b8db-2e69292f6bdb RR 401106372 ACCENTCARE, INC. 213304 ACCENTCARE, INC. 2022 first_quarter 2022-01-14T11:25:01-05:00   0 0 0
ac9a2c50-08aa-4e64-bd03-38f4003b9203 RR 401103562 9B GROUP, INC. 213301 LAND O'LAKES 2022 first_quarter 2022-01-14T11:29:10-05:00   0 0 0
2f70cf62-7ef1-4408-bcf9-69226d0e6029 RR 65191 VENN STRATEGIES 213326 FASTCAP SYSTEMS CORPORATION DBA NANORAMIC LABORATORIES 2022 first_quarter 2022-01-14T12:56:30-05:00   0 0 0
069daaa3-ddc7-45de-bc33-1e9893138114 RR 297294 BOSE PUBLIC AFFAIRS GROUP 213322 RIVER HERITAGE CONSERVANCY 2022 first_quarter 2022-01-14T14:01:50-05:00   0 0 0
fa10cd69-ea12-40b7-b47d-fc65d2b4895a RR 313511 J.A. GREEN AND COMPANY (FORMERLY LLC) 213324 CHARTER COMMUNICATIONS INC. 2022 first_quarter 2022-01-14T14:12:42-05:00   0 0 0
4002fbb4-3f7f-4211-8706-a62ce26591b4 RR 313511 J.A. GREEN AND COMPANY (FORMERLY LLC) 213315 MODERN TECHNOLOGY SOLUTIONS, INC. 2022 first_quarter 2022-01-14T14:21:55-05:00   0 0 0
9eca7835-ff9d-4f51-92b5-e215b5b88899 RR 401103562 9B GROUP, INC. 213351 THEODORE ROOSEVELT CONSERVATION PARTNERSHIP 2022 first_quarter 2022-01-14T15:33:35-05:00   0 0 0
ad82b1fc-b05a-4ae7-a4f1-77f8515427c9 RA 19935 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 126454 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2022 first_quarter 2022-01-14T16:11:36-05:00   1 0 0
31d90e13-e579-44a1-8691-7be756454165 RR 400882581 ACTIVE POLICY SOLUTIONS, LLC 213343 AMERICAN COLLEGE HEALTH ASSOCIATION 2022 first_quarter 2022-01-14T16:19:58-05:00   0 0 0
b2c70a2b-4bde-4dce-8881-93e7016964ed RR 401105021 VECTIS DC 213339 CITY OF MONTEBELLO, CALIFORNIA 2022 first_quarter 2022-01-15T10:49:43-05:00   0 0 0
b9dd53ba-fb55-4bbf-a395-72e2629c1ae4 RR 288613 THE JOSEPH GROUP, LLC 213347 YELP 2022 first_quarter 2022-01-15T19:56:57-05:00   0 0 0
0603b691-2abd-4c53-8aec-3a07f63a21d8 RR 285255 STRATEGIC HEALTH CARE 213345 HILLS AND DALES GENERAL HOSPITAL 2022 first_quarter 2022-01-17T14:45:57-05:00   0 0 0
25470941-2516-42ff-9a09-dcec1f6290da RR 285255 STRATEGIC HEALTH CARE 213359 GRAND RIVER HOSPITAL DISTRICT 2022 first_quarter 2022-01-17T14:48:29-05:00   0 0 0
36bcfc9c-dd6f-4311-84eb-6dde0628e12f RR 285255 STRATEGIC HEALTH CARE 213357 COVINGTON COUNTY HOSPITAL 2022 first_quarter 2022-01-17T14:50:52-05:00   0 0 0
7af1df05-aaa0-4ab9-be09-9acfb9666919 RR 285255 STRATEGIC HEALTH CARE 213361 WEST FELICIANA HOSPITAL 2022 first_quarter 2022-01-17T14:52:48-05:00   0 0 0
17f953fd-4c89-4ee1-87d4-e48e39cbdcc6 RR 60550 STRATEGIC MARKETING INNOVATIONS 213360 BKI ENGINEERING SERVICES BEHALF INLAND POWER & LIGHT COMPANY 2022 first_quarter 2022-01-17T17:40:49-05:00   0 0 0
ef5e08a1-e3b6-4cc3-a339-cf318294881a RR 60550 STRATEGIC MARKETING INNOVATIONS 213362 BKI ENGINEERING SERVICES BEHALF MISSOULA ELECTRIC COOPERATIVE 2022 first_quarter 2022-01-17T17:49:11-05:00   0 0 0
ae081bd7-34e6-4b9c-b573-e6aa72e91d93 RR 60550 STRATEGIC MARKETING INNOVATIONS 213364 FINCANTIERI MARINE GROUP LLC 2022 first_quarter 2022-01-17T18:44:24-05:00   0 0 0
e94006c4-e12a-479c-bdaa-c72a7f2e84e3 RR 400761275 REPUBLIC CONSULTANTS, LLC 213376 KNDS - KMW + NEXTER DEFENSE SYSTEMS 2022 first_quarter 2022-01-18T11:10:02-05:00   0 0 0
c0e82f04-5b25-4c40-b970-80a3bdc67aa9 RR 401106368 GUSTO 213372 GUSTO 2022 first_quarter 2022-01-18T12:10:54-05:00   0 0 0
21c65e2c-ab86-4975-bbb7-bc6725862af3 RR 401104543 THE PRENDA GROUP LLC 213373 PUGET SOUND AGGREGATES, LLC 2022 first_quarter 2022-01-18T12:24:04-05:00   0 0 0
d69de1ef-02a5-4a25-bd97-f10bb5d12eef RR 401104430 EFB ADVOCACY, LLC 213378 HOLT INTERNATIONAL 2022 first_quarter 2022-01-18T13:05:31-05:00   0 0 0
7a2f2333-b844-4802-987c-931003dbb038 RR 401106360 AMERICAN FIREARMS ASSOCIATION 213379 AMERICAN FIREARMS ASSOCIATION 2022 first_quarter 2022-01-18T13:21:44-05:00   0 0 0
12958919-ff96-486e-b1d5-d3e92e0d1df0 RR 400400892 ATS COMMUNICATIONS, INC. (DBA SILBEY STRATEGIES) 213380 KARMAN-SD (FKA SYSTIMA TECHNOLOGIES, INC.) 2022 first_quarter 2022-01-18T13:27:31-05:00   0 0 0
1227f396-5dea-4067-afd1-ea054e4a0d82 RR 297294 BOSE PUBLIC AFFAIRS GROUP 213381 INVEST IN EDUCATION COALITION 2022 first_quarter 2022-01-18T13:43:04-05:00   0 0 0
6959f59e-4b0a-48cd-be7c-94f744668455 RA 297294 BOSE PUBLIC AFFAIRS GROUP 213381 INVEST IN EDUCATION COALITION 2022 first_quarter 2022-01-18T16:16:21-05:00   1 0 0
172d9ccb-3145-476d-91cc-ae8172d3a8cf 1TY 292573 MCALLISTER & QUINN, LLC 212410 BROADCOM CORPORATION 2022 first_quarter 2022-01-19T09:06:46.183000-05:00 10000.0 0 0 1
f8a46b71-2580-4706-8ad7-3b9038cf0682 RR 12868 DUTKO WORLDWIDE, LLC 213404 FARMINGTON, UTAH 2022 first_quarter 2022-01-19T09:27:15-05:00   0 0 0
9d011878-5e9d-483f-b30d-a39680415431 RR 20744 TIBER CREEK GROUP 213411 QUIDNET ENERGY, INC. 2022 first_quarter 2022-01-19T09:33:42-05:00   0 0 0
627f436e-15b9-408a-8dc3-21d0eaf614d7 RR 401106369 CAROL G HOLLADAY & ASSOCIATES 213407 SAVANNAH AIRPORT COMMISSION 2022 first_quarter 2022-01-19T09:43:37-05:00   0 0 0
b76a1657-9ddd-40bd-99fd-937fd128fb57 RR 401105996 MG HOUSING STRATEGIES LLC 213413 LINCOLN AVENUE CAPITAL 2022 first_quarter 2022-01-19T10:04:09-05:00   0 0 0
7fa13aa5-5db3-4185-a518-3c1ef4cf1eba 1T 10478 CFM STRATEGIC COMMUNICATIONS (CONKLING FISKUM & MCCORMICK) 209736 CITY OF INDEPENDENCE 2022 first_quarter 2022-01-19T10:19:08.580000-05:00 20000.0 0 0 1
20e63802-0326-4955-a982-196a21b5c19b RR 287771 CLARK HILL, PLC 213412 THE SHYFT GROUP 2022 first_quarter 2022-01-19T10:49:54-05:00   0 0 0
5a3d25e5-6ab6-4b85-9c5a-ca4936882ddd RA 401105157 ENVIVA INC. (FKA ENVIVA HOLDINGS LP) 203312 ENVIVA INC. (FKA ENVIVA HOLDINGS LP) 2022 first_quarter 2022-01-19T11:00:08-05:00   1 0 0
4db7cbf6-95da-4d55-800d-d2391498e693 1TY 292573 MCALLISTER & QUINN, LLC 178276 NATIONAL CENTER FOR MANUFACTURING SCIENCES 2022 first_quarter 2022-01-19T11:11:53.703000-05:00   0 0 1
e2afa3e0-5c24-43dc-aff6-7ca87335b62c RR 401105780 ASCENDANT STRATEGIC PARTNERS 213401 MOLECULAR TESTING LABS 2022 first_quarter 2022-01-19T11:12:59-05:00   0 0 0
74ae9e67-5669-4e71-8165-2281db6fa4a4 RR 32008 POWERS PYLES SUTTER & VERVILLE, P.C. 213402 ACCESS READY STRATEGIC SOCIAL PURPOSE CORPORATION 2022 first_quarter 2022-01-19T11:17:48-05:00   0 0 0
8a4cd2dc-413b-4b4e-821f-4c17b74d0427 1TY 292573 MCALLISTER & QUINN, LLC 178282 CONNECTICUT CENTER FOR ADVANCED TECHNOLOGY (CCAT) 2022 first_quarter 2022-01-19T11:23:31.483000-05:00 10000.0 0 0 1
a3a1555a-8dba-4830-86f2-39132b40e5b0 RR 306636 THE NORMANDY GROUP, LLC 213432 TAYLOR ENGLISH DUMA LLP 2022 first_quarter 2022-01-19T12:43:07-05:00   0 0 0
37828766-3f01-4fc8-8ef8-e67a10ad35f1 RR 306636 THE NORMANDY GROUP, LLC 213439 FUTURE PLANS 2022 first_quarter 2022-01-19T12:57:55-05:00   0 0 0

Next page

Advanced export

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

CSV options:

CREATE TABLE lobbying_filings (
    filing_uuid TEXT PRIMARY KEY,
    filing_type TEXT NOT NULL,
    registrant_id INTEGER,
    registrant_name TEXT,
    client_id INTEGER,
    client_name TEXT,
    filing_year INTEGER,
    filing_period TEXT,
    received_date TEXT,
    amount_reported REAL,
    is_amendment INTEGER DEFAULT 0,
    is_no_activity INTEGER DEFAULT 0,
    is_termination INTEGER DEFAULT 0
);
CREATE INDEX idx_lobby_filing_type ON lobbying_filings(filing_type);
CREATE INDEX idx_lobby_client ON lobbying_filings(client_name);
CREATE INDEX idx_lobby_year ON lobbying_filings(filing_year);
Powered by Datasette · Queries took 2725.063ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API