FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
154 rows where "Date_Stamped" is on date 1986-10-01
This data as json, CSV (advanced)
These facets timed out: Document_Type, Foreign_Principal_Name
Registrant_Name >30
- HILL & KNOWLTON, INC. 23
- SHEA & GARDNER 12
- WHITEHOUSE ASSOCIATES, INC. 5
- O'CONNOR & HANNAN, LLP 4
- ARNOLD & PORTER 3
- BURSON-MARSTELLER 3
- DOW, LOHNES & ALBERTSON, LLP 3
- FIERCE, DONALD L. 3
- RUDER & FINN, INC. 3
- (UNITA) NATIONAL UNION FOR TOTAL INDEP ANGOLA 2
- AARON D. CUSHMAN & ASSOCIATES, INC. 2
- FONTAYNE GROUP, INC. 2
- INTERNATIONAL MARKETING CENTER, LTD. 2
- JONES, DAY, REAVIS & POGUE 2
- KRENTZ, HUGH A. 2
- LAW OFFICES OF JOHN P. SEARS 2
- MUDGE, ROSE, GUTHRIE, ALEXANDER & FERDON 2
- SAATCHI & SAATCHI NORTH AMERICA, INC. 2
- SAWYER MILLER GROUP 2
- YORKSHIRE & HUMBERSIDE DEVELOPMENT ASSOCIATION, CALIFORNIA 2
- ABRAMSONEHRLICHMANES, INC. 1
- AKIN, GUMP, STRAUSS, HAUER & FELD, L.L.P. 1
- ARIANESPACE, INC. 1
- ARUBA TOURISM AUTHORITY 1
- AUSTRIAN BUSINESS AGENCY 1
- AUSTRIAN TRADE COMMISSION, LOS ANGELES 1
- BERLINER, CORCORAN & ROWE 1
- BERRY, MAX N. 1
- BRITISH TOURIST AUTHORITY 1
- BRITISH VIRGIN ISLANDS TOURIST BOARD 1
- …
Foreign_Principal_Country 19
- - 123
- SWITZERLAND 4
- CANADA 3
- GREAT BRITAIN 3
- JAPAN 3
- BOLIVIA 2
- CYPRUS 2
- ICELAND 2
- KOREA SOUTH 2
- CAYMAN ISLANDS 1
- COLOMBIA 1
- ECUADOR 1
- FRANCE 1
- GUATEMALA 1
- ITALY 1
- KOREA REPUBLIC OF 1
- MEXICO 1
- PARAGUAY 1
- VENEZUELA 1
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]) );