FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
169 rows where "Date_Stamped" is on date 1988-03-01
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name, Foreign_Principal_Country
Foreign_Principal_Name 26
- - 144
- ACE FROSTY SHIPPING COMPANY, LTD. - C/O CLIFFORD CHANCE 1
- AVIANCA, INC. 1
- BANK OF MONTREAL, PUBLIC AFFAIRS OFFICE 1
- BECKETT PACKAGING, LTD. 1
- BERETTA, U.S.A. CORPORATION 1
- BERLIN ECONOMIC DEVELOPMENT CORPORATION 1
- BRITISH GOVERNMENT CONSULATE 1
- COMMITTEE ON U.S. BUSINESS, CANADA HEALTH & LIFE INSURANCE 1
- DORNIER MEDICAL SYSTEMS, INC. 1
- ECO CORPORATION 1
- ELMONT, A.G. 1
- FLAT GLASS ASSOCIATION OF JAPAN 1
- FOREIGN INVESTMENT INSTITUTE OF PORTUGAL 1
- GOVERNMENT OF THE FEDERATED STATES OF MICRONESIA 1
- GOVERNMENT OF THE REPUBLIC OF CHINA 1
- GOVERNMENT OF THE REPUBLIC OF PANAMA (IN EXILE), 1
- INTERNATIONAL ASSOCIATION OF INDEPENDENT TANKER OWNERS 1
- JETRO, LOS ANGELES (JAPAN EXTERNAL TRADE ORGANIZATION) 1
- LEHNDORFF & BABSON REAL ESTATE COUNSEL 1
- MITSUBISHI TRUST & BANKING CORPORATION 1
- NICARAGUAN RESISTANCE 1
- REPUBLIC OF PANAMA 1
- SANWA BANK, LTD. 1
- SUZUKI OF AMERICA AUTOMOTIVE CORPORATION 1
- UNIVERSAL FRUTRADING CO-OPERATIVE, LTD. 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]) );