FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13,366 rows where Document_Type = "Amendment" sorted by rowid descending
This data as json, CSV (advanced)
Registrant_Name >30
- ARNOLD & PORTER 224
- Daniel J. Edelman, Inc. 136
- RUDER & FINN, INC. 127
- HILL & KNOWLTON, INC. 123
- Mercury Public Affairs, LLC 115
- APCO Worldwide, Inc. 104
- Squire Patton Boggs, LLP 93
- SHAW, PITTMAN, POTTS & TROWBRIDGE 83
- CIVIC SERVICE, INC. 80
- Podesta Group, Inc. 80
- Glover Park Group, LLC 75
- BGR Government Affairs, LLC 71
- Pillsbury Winthrop Shaw Pittman, LLP 67
- L.A. MOTLEY & COMPANY 65
- APCO Worldwide LLC 64
- Arnold & Porter Kaye Scholer, LLP 60
- Hogan Lovells US LLP 60
- HOGAN & HARTSON, L.L.P. 57
- APCO ASSOCIATES, INC. 56
- ARENT FOX KINTNER PLOTKIN & KAHN, PLLC 56
- Akin, Gump, Strauss, Hauer & Feld, LLP 56
- Nelson Mullins Riley & Scarborough, LLP 54
- Holland & Knight 53
- Livingston Group, LLC 52
- PATTON BOGGS, L.L.P. 52
- Sonoran Policy Group, LLC 52
- Patton Boggs, LLP 51
- JONES, DAY, REAVIS & POGUE 48
- Brownstein Hyatt Farber Schreck, LLP 45
- GARVEY, SCHUBERT & BARER 45
- …
Foreign_Principal_Name 1
- - 12,292
Foreign_Principal_Country 1
- - 12,292
Document_Type 1
- Amendment · 12,292 ✖
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );