FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
519 rows where "Date_Stamped" is on date 1993-05-01
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country, Date_Stamped
Foreign_Principal_Name >30
- - 489
- AEC FOREST PRODUCTS 1
- ARTE Y CIA 1
- CONSULATE GENERAL OF SWITZERLAND 1
- COUNTRY OF ZAIRE - AMBASSADOR MOKOLO W'A MPOMBO 1
- DEMOCRACY & DIGNITY FOUNDATION 1
- ELBIT, LTD. 1
- GENEVA DEPARTEMENT DE L:ECONOMIE PUBLIQUE 1
- GOVERNMENT OF HONG KONG 1
- GOVERNMENT OF ITALY, SENATOR GIULIO ANDREOTTI 1
- GOVERNMENT OF MEXICO, SECRETARIA DE COMERCIO Y FOMENTO 1
- GOVERNMENT OF NORWAY 1
- GOVERNMENT OF UKRAINE 1
- GRAND METROPOLITAN, INC. 1
- INDUSTRIAL BANK OF JAPAN, LTD. 1
- JETRO, HOUSTON 1
- MAGAL SECURITY SYSTEMS, LTD. 1
- METHANEX, INC. 1
- NATIONAL PETROLEUM COMPANY, "SUDAN", LTD. 1
- OFFICE OF THE PRESIDENT OF UKRAINE 1
- PENAJANS/DMB & B TICARET, A.S. 1
- RAFAEL U.S.A., INC. 1
- REPUBLIC OF AZERBAIJAN 1
- REPUBLIC OF CROATIA 1
- REPUBLIC OF THE PHILIPPINES, PRESIDENTIAL COMMITTEE IN THE 1
- RIVIERE AGRO - ALIMENTAIRE, S.A. 1
- STATE OF ISRAEL 1
- SYNTEX CORPORATION 1
- UNITED DEMOCRATIC FRONT 1
- USINE A. MANTEQUE DE PORT-AU-PRINCE 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]) );