FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Date_Stamped" is on date 1983-05-01, Document_Type = "Exhibit AB" and Registrant_Name = "NORTH AMERICAN PRECIS SYNDICATE"
This data as json, CSV (advanced)
These facets timed out: Document_Type, Registrant_Name
Foreign_Principal_Name 12
- FINNAIR 1
- GERMAN NATIONAL TOURIST OFFICE 1
- HALLAND-AMERICAN CRUISES 1
- ISRAEL MINISTRY OF TOURISM 1
- JAPANESE INFORMATION CENTER 1
- KOREA NATIONAL TOURISM CORPORATION 1
- LUFTHANSA AIRLINES 1
- MEXICAN GENERAL OF COMMUNICATION 1
- PUBLIC RELATIONS BRANCH REVENUE CANADA C&E 1
- SWEDISH TOURIST BOARD 1
- TURKISH TOURISM & INFORMATION OFFICE 1
- YUGOSLAV NATIONAL TOURIST OFFICE 1
Foreign_Principal_Country 11
- GERMANY FEDERAL REPUBLIC OF 2
- CANADA 1
- FINLAND 1
- ISRAEL 1
- JAPAN 1
- KOREA SOUTH 1
- MEXICO 1
- NETHERLANDS 1
- SWEDEN 1
- TURKEY 1
- YUGOSLAVIA 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]) );