FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where "Foreign_Principal_Termination_Date" is on date 1986-04-12
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Registrant_Date (date)
Foreign_Principal 13
- Amsterdam Stock Exchange 1
- Austrian Press & Information Service 1
- Borman Williams for Dusseldorf Trade Fair Company 1
- Embassy of Japan 1
- Embassy of South Africa 1
- Embassy of the Union of Soviet Socialist Republics 1
- Foods & Wines from France 1
- Government of Haiti 1
- Haiti National Offices of Tourism 1
- Mexican General of Communication 1
- Nation Newspaper 1
- Norseland Foods, Inc. 1
- Royal Embassy of Saudi Arabia 1
Country/Location_Represented 12
- HAITI 2
- AUSTRIA 1
- FRANCE 1
- GERMANY, FEDERAL REPUBLIC OF 1
- JAPAN 1
- KENYA 1
- MEXICO 1
- NETHERLANDS 1
- NORWAY 1
- SAUDI ARABIA 1
- SOUTH AFRICA 1
- USSR 1
Registrant_Name 2
City 1
- - 13
Link | rowid ▼ | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5203 | 5203 | 1986-04-12 | Amsterdam Stock Exchange | 1985-09-04 | NETHERLANDS | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5204 | 5204 | 1986-04-12 | Austrian Press & Information Service | 1985-03-18 | AUSTRIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5205 | 5205 | 1986-04-12 | Borman Williams for Dusseldorf Trade Fair Company | 1985-06-14 | GERMANY, FEDERAL REPUBLIC OF | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5206 | 5206 | 1986-04-12 | Embassy of Japan | 1986-02-04 | JAPAN | Colby, Baily & Associates 3663 | 1985-03-22 | Colby, Baily & Associates | Washington | DC | |||
5207 | 5207 | 1986-04-12 | Embassy of South Africa | 1984-11-13 | SOUTH AFRICA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5208 | 5208 | 1986-04-12 | Embassy of the Union of Soviet Socialist Republics | 1985-04-25 | USSR | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | DC | ||||
5209 | 5209 | 1986-04-12 | Foods & Wines from France | 1979-06-27 | FRANCE | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | New York | NY | |||
5210 | 5210 | 1986-04-12 | Government of Haiti | 1985-06-04 | HAITI | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | DC | ||||
5211 | 5211 | 1986-04-12 | Haiti National Offices of Tourism | 1985-11-05 | HAITI | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NJ | ||||
5212 | 5212 | 1986-04-12 | Mexican General of Communication | 1983-05-04 | MEXICO | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5213 | 5213 | 1986-04-12 | Nation Newspaper | 1985-05-24 | KENYA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5214 | 5214 | 1986-04-12 | Norseland Foods, Inc. | 1985-06-05 | NORWAY | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | NY | ||||
5215 | 5215 | 1986-04-12 | Royal Embassy of Saudi Arabia | 1985-04-25 | SAUDI ARABIA | North American Precis Syndicate 2836 | 1977-10-12 | North American Precis Syndicate | DC |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );