FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
224 rows where "Date_Stamped" is on date 1990-10-01
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name >30
- - 186
- "State Don Cossacks Song and Dance Ensemble" 1
- ASSOCIATION FRANCOIS-XAVIER BAGNOUD 1
- BRITISH AIRWAYS, PLC 1
- CITY OF KAISERSLAUTERN, FRG 1
- COMMISSION OF THE EUROPEAN COMMUNITIES 1
- COMMITTEE FOR DEMOCRACY IN EL SALVADOR, THROUGH O'CONNOR & H 1
- COMPANHIA DE NAVEGACAO MARITIMA NETUMAR 1
- DEUTSCHE BUNDESPOST TELEKOM 1
- EMBASSY OF GOVERNMENT OF CANADA 1
- EMBASSY OF JAPAN 1
- EMBASSY OF PAPUA NEW GUINEA 1
- EMBASSY OF THE REPUBLIC OF TURKEY 1
- EUROPEAN LARGEST TEXTILE & APPAREL COMPANIES 1
- FASTENERS INSTITUTE OF JAPAN 1
- GL HOLDINGS CORPORATION 1
- GOVERNMENT OF ISRAEL - MINISTRY OF JUSTICE 1
- GOVERNMENT OF NICARAGUA 1
- INTERNATIONAL BUSINESS COMMUNICATIONS, INC. 1
- KHMER PEOPLE'S NATIONAL LIBERATION FRONT 1
- LUSO-AMERICAN DEVELOPMENT FOUNDATION 1
- MARTELL 1
- MASA YARDS, INC. 1
- MATSUSHITA ELECTRIC INDUSTRIAL COMPANY, LTD. 1
- MITSUBISHI ELECTRONICS AMERICA, INC. 1
- OROMO LIBERATION FRONT 1
- PORTUGUESE NATIONAL TOURIST OFFICE 1
- PROGRESSIVE ALLIANCE 1
- PUERTO VALLARTA TOURISM TRUST 1
- REPUBLIC OF ESTONIA 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]) );