home / openregs

lobbying_lobbyists

Individual lobbyists listed on LDA filings. 3.5M+ records with covered positions (former government roles).

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

3,464,421 rows sorted by lobbyist_name

✎ View and edit SQL

This data as json, CSV (advanced)

id filing_uuid lobbyist_name ▼ covered_position is_new
1180882 d49424ba-d691-4d9a-ac04-60aa034e64a4 " Staff Director, Senate Commitee on Veterans Affairs; 1993-99 1
1180988 76f01588-cb25-4d78-b340-d78c96f854f2 " Staff Director; Senate Vet Affairs Comm 1
1183785 ffb7390b-c467-434c-825f-c6341abe8479 " Deputy Asst Sec for Legis Affairs, U.S. Dept of Defense 1
1054618 f19424c7-35ac-484d-b657-7c98ae9beb65 " " ( '87-'91)   0
1084960 15d86fa6-dba5-4a58-9b26-7aa4aa01a7d4 " " ( '87-'91)   0
1907005 36b99d8d-81be-46ae-9a6c-1f6cf3b2e78f ' (OCIA)(1995). 1
1289274 a428402a-f3d8-4b7d-a2c1-ce2026034d00 (CONTINUED)   1
1323162 9cdec44c-9f60-46a7-82c8-679e373bc27a (CONTINUED)   1
1341000 789afd68-1707-4b2d-935c-33ca11c22362 (CONTINUED)   1
1341563 7ff86093-38db-4cd4-9bb6-2d9d2105937f (CONTINUED)   1
1341711 f2a96d9e-4318-4d82-9009-9b9af4418ab2 (CONTINUED)   1
1344096 e9f3544d-cf71-4b65-8a7e-8be77e8e136a (CONTINUED)   1
1399482 55472f86-8aa1-400a-9a93-cd880ad85053 (CONTINUED)   1
1401152 17544550-abe8-4a52-bb7a-5975d7f0d00c (CONTINUED)   1
1451392 c3e5b4bb-6b1a-4a9d-bec4-99dca5597cc6 (CONTINUED) Coun. to House Govt. Reform Comm. 1
1451485 b950f842-958d-4a3b-8020-98897cea60b0 (CONTINUED) Coun. to House Govt. Reform Comm. 1
1455613 44c7a4bc-f2b3-4207-9772-fef081f7b92d (CONTINUED)   1
1501323 b03b2ead-96a7-44ee-ace0-c5cbe637848d (CONTINUED)   1
1501327 4e8c40e7-3a5d-4b02-b43f-0bb68a8315c9 (CONTINUED) Dep. Chief of Staff, Sen. Arlen Specter 1
1549216 d167dfb2-b857-4a7d-9d58-0fee7abf3897 (CONTINUED)   1
1549393 e14902c8-73a5-4ec0-91be-08510c1a7c59 (CONTINUED) Coun. to House Govt. Reform Comm. 1
1550059 29375975-23fa-4310-8567-718de26ea8ca (CONTINUED)   1
1550688 0770201f-5c18-4fd2-8fe1-450bc4e40c95 (CONTINUED)   1
1602572 8278a690-0ad3-4eb4-8b83-cd2ac035ac2e (CONTINUED)   1
1603549 21bc0afa-db45-40d8-b1c8-d4b2aa0d5671 (CONTINUED)   1
1614078 b86f1405-dabb-4384-b509-52e12f7e2e15 (CONTINUED)   1
1645227 136d7fda-0f1b-4521-8e4a-d5027a9196fc (CONTINUED)   1
1646520 1efc1c20-626f-4777-91f0-ddf8f092b218 (CONTINUED)   1
1646898 e8b15efa-3db3-4571-a6a0-2d4054af6376 (CONTINUED)   1
1647312 66ef8acb-9290-4239-8b33-f09222d5b3be (CONTINUED)   1
1647662 132ce769-7196-444e-afb6-954c7d86905c (CONTINUED)   1
1647721 a8e47b7c-da45-4cbe-bc35-6efcf223bf8b (CONTINUED)   1
1647840 98b58051-195f-4ace-942d-455c9dda8837 (CONTINUED)   1
1649053 7123c2ce-47f7-42ae-b956-a63f9908954f (CONTINUED)   1
1689838 c8448cf9-8157-41a8-beeb-aa00d6b7aebc (CONTINUED)   1
1691656 a0946be8-f5df-4e63-a036-c90c64b5f5fc (CONTINUED) Coun. to House Govt. Reform Comm. 1
1731043 6a1dcc4c-312a-482e-b72d-e7981d6f4ee4 (CONTINUED)   1
1731409 c4f1a69d-2353-4070-ad01-6312dd1d9637 (CONTINUED)   1
1733721 f9df3f60-1de7-4ebd-86f7-3d693de95467 (CONTINUED)   1
1733903 60a4be7f-ac9a-429f-ac26-56547c1f3ad2 (CONTINUED)   1
1733905 fcc36d33-a222-428a-95bc-563c250c8e3f (CONTINUED)   1
1734411 6216ef4a-7dd8-4ebd-840e-2b1d3c35e708 (CONTINUED)   1
1734520 99d74cb1-b8d4-4aa9-8920-909c87b089f9 (CONTINUED)   1
1750405 71d5f039-f681-48ea-89e7-1d2e073ea8ee (CONTINUED) Coun. to House Govt. Reform Comm. 1
1782159 cd93dab1-212d-47a8-b15d-f0535ddd5a0f (CONTINUED)   1
1782286 528dfdbf-1696-4bbc-8174-c8d0f2e46e00 (CONTINUED) Coun. to House Govt. Reform Comm. 1
1782511 1f202cfb-334e-46de-bd56-a24668e74518 (CONTINUED)   1
1782513 4e89f3ec-edca-4759-a033-6094956e0611 (CONTINUED)   1
1782868 24b507b8-9373-4836-83ae-606b11c6d967 (CONTINUED)   1
1822427 c7c2de5a-1b3a-413c-b2bd-35d7f7d32529 (CONTINUED)   1
1864366 d82d8b45-4370-4930-bb69-b57ca8a86468 (CONTINUED)   1
1864666 1d5ed561-0a00-4989-9189-2c6b9023ada8 (CONTINUED)   1
1864669 87c1fd41-c91f-42d9-b07a-9df1dc5a9614 (CONTINUED)   1
1903377 018d818d-73eb-4db7-9c7d-990001d39ad6 (CONTINUED)   1
1903394 51bafd62-6bb2-4fae-9f9d-a7ee468dd06e (CONTINUED) Comm.; Energy and Minerals Coun., House Resources Comm. 1
1903706 d5f83d80-a42d-4e07-b1db-71782fb55eb1 (CONTINUED) Comm.; Energy and Minerals Coun., House Resources Comm. 1
1908057 34e2804e-7a3e-45e1-827c-bd65acb8f0a7 (CONTINUED)   1
1945211 6b4b95d4-3968-42ce-96a6-b6229014c82d (CONTINUED)   1
1945748 ec313e82-ba9d-48a2-955e-515176040dea (CONTINUED)   1
1946393 078347b4-0c34-4eb2-b33f-348180962495 (CONTINUED) Comm.; Energy and Minerals Coun., House Resources Comm. 1
1958277 674adabb-ce5d-4d83-8301-9c24d205c7b5 (CONTINUED)   1
1990845 163c9a99-f949-4284-9748-89e67cbe244c (CONTINUED)   1
2023266 8bd9c3ef-9413-48ca-94fa-52f857b41d61 (CONTINUED)   1
2034387 b8952631-58f3-4594-9765-8ffb9af2c25f (CONTINUED)   1
2061895 14fbbdf4-2151-4087-a7d1-0cf6583c1644 (CONTINUED)   1
2063562 139ab7ca-8ddf-4c2e-a33f-0e673e8da2e4 (CONTINUED)   1
2102529 bb1735db-224d-46fd-8b5b-5c35b329d4a4 (CONTINUED)   1
2106554 4a24d4d9-9e80-4852-bbd1-345619e3e5ca (CONTINUED)   1
2107067 b072c1a7-1f8a-430e-be20-c6f92e5bbc6b (CONTINUED)   1
2143373 caf97143-cca7-44c4-925e-2ec675d376d9 (CONTINUED)   1
2144802 b408e4d3-c8fb-42f4-873d-0d0f75383c63 (CONTINUED)   1
2157955 08a5cf70-b7fd-4a41-b858-402e5cb7c837 (CONTINUED)   1
2182581 4f72beda-dbaa-44e8-827d-19d0d790c5fc (CONTINUED)   1
2189210 bda57cdd-4398-4c6b-9ee9-27d4e2b72bf0 (CONTINUED)   1
2189219 bb077816-3b30-4fe9-809d-b9550adb299a (CONTINUED)   1
2221750 7c8f6256-d88d-4d83-8e51-c1ec3ed0eeba (CONTINUED) Comm.; Energy and Minerals Coun., House Resources Comm. 1
1341713 f2a96d9e-4318-4d82-9009-9b9af4418ab2 (NO BEFORE JAN 11 2010)   1
1351304 99140568-f339-406f-86be-3986ceb186ca (NO BEFORE JAN 11 2010)   0
1414196 3ca43296-4f22-4cd1-88ad-068b56cdad1f (NO BEFORE JAN 11 2010)   0
1414227 0683b5cb-6f4f-4015-9813-95280113deac (NO BEFORE JAN 11 2010)   0
1594864 2a158eff-daa1-4e70-bed7-73acc2f47452 (NONE)   0
1549427 fcee6cd5-e2b1-4e5d-8c13-f7668eae89c1 (SEE ABOVE)   1
1392335 664661b4-3b84-4988-b38e-aac41e2733e4 *** *** previous report listed name in error 0
1067159 82e9d333-c017-440d-90c6-54a1e6ce27d8 ***CONTINUED*** ***CONTINUED*** Research Analyst, US Department of Justice 1
1523180 4f3968c5-727f-4b68-8a84-3edd0547648c **NOTE** **CHANGES** **SEE LOBBYIST CHANGES * PAGE 1 AND 3 1
1622037 c97a8190-3b32-4197-9a25-9336b7b40c15 **NOTE** **CHANGES** ** LOBBYIST CHANGE* * AS OF 3/31/2011 1
1626017 913c1181-31ef-4f98-ad64-84cc5f74a6f7 **NOTE** **CHANGES** ** LOBBYIST CHANGE* * AS OF 3/31/2011 1
1925571 6ce46834-7c7a-468b-b459-ca8eca152cdf *VOLUNTARILY MEMBERS OF   0
1925574 b535301b-5fbb-478e-a548-6f1fc4a7860a *VOLUNTARILY MEMBERS OF   0
1925576 24514e07-6a74-42ba-85fb-8506a82f6152 *VOLUNTARILY MEMBERS OF   0
1925583 9c35e787-2205-452c-9bb8-e3d332b41435 *VOLUNTARILY MEMBERS OF   0
1444031 b68fff9a-fc3d-4451-bc14-aef48f8e6682 - Waxman counsel; Senator Pryor Staff 1
1445545 cf4b3a8c-aa16-44a7-9deb-6dfa2f5c5867 - Federal Health Care Policy Specialist, President Bush 1
1491199 76bc1378-95f6-403f-aff1-06a022245005 - Waxman counsel; Senator Pryor Staff 1
1529150 89d4a886-8f3e-4123-8457-1b8a73a7fd5f - Waxman counsel; Senator Pryor Staff 1
1535411 3fcac031-fa01-4916-a07d-460df10c1f37 - Human Resource Committee 1
1536407 9cf9c6b6-8bfb-46bf-bc42-689ed9512e53 - Human Resource Committee 1
1583662 b4c2f2ec-f8db-4973-af1f-4dae5b16ea45 - Human Resource Committee 1
1603087 ea9aa3d4-f20f-4583-9fe7-4109d995d55a - Waxman counsel; Senator Pryor Staff 1
1606196 0389df6a-771a-42d1-9fe3-aa30e130b0c6 - Waxman counsel; Senator Pryor staff 1

Next page

Advanced export

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

CSV options:

CREATE TABLE lobbying_lobbyists (
    id INTEGER PRIMARY KEY,
    filing_uuid TEXT NOT NULL,
    lobbyist_name TEXT NOT NULL,
    covered_position TEXT,
    is_new INTEGER DEFAULT 0
);
CREATE INDEX idx_lobby_lob_uuid ON lobbying_lobbyists(filing_uuid);
CREATE INDEX idx_lobby_lob_name ON lobbying_lobbyists(lobbyist_name);
CREATE INDEX idx_lobby_lob_covered ON lobbying_lobbyists(covered_position) WHERE covered_position IS NOT NULL AND covered_position != '';
Powered by Datasette · Queries took 975.453ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API