FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Foreign_Principal_Termination_Date" is on date 1984-03-01 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- Allmanna Svenska Elektriska Aktiebdayet (ASEA) 1
- City of Frankfurt 1
- Government of Mexico Tourism Office 1
- Industrias Quimicas y Tartaricas 1
- Japan Airlines 1
- Japan Automobile Manufacturers' Associations, Inc. 1
- Reassemblement Pour la Republique 1
- Republic of Guinea 1
- Republic of South Africa 1
- Tourism Canada 1
- Trinidad & Tobago 1
Country/Location_Represented 10
- JAPAN 2
- CANADA 1
- FRANCE 1
- GERMANY, FEDERAL REPUBLIC OF 1
- GUINEA 1
- MEXICO 1
- SOUTH AFRICA 1
- SPAIN 1
- SWEDEN 1
- TRINIDAD AND TOBAGO 1
Registrant_Name 8
City 1
- - 11
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3262 | 3262 | 1984-03-01 | Japan Automobile Manufacturers' Associations, Inc. | 1981-04-10 | JAPAN | Baskin & Sears, P.C. 3184 | 1981-01-06 | Baskin & Sears, P.C. | Tokyo | ||||
3263 | 3263 | 1984-03-01 | Allmanna Svenska Elektriska Aktiebdayet (ASEA) | 1973-10-23 | SWEDEN | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Vasteras | ||||
3264 | 3264 | 1984-03-01 | City of Frankfurt | 1982-07-14 | GERMANY, FEDERAL REPUBLIC OF | Baskin & Sears, P.C. 3184 | 1981-01-06 | Baskin & Sears, P.C. | Frankfurt | ||||
3265 | 3265 | 1984-03-01 | Government of Mexico Tourism Office | 1980-03-19 | MEXICO | Jones, B. Calvin 3150 | 1980-09-19 | Jones, B. Calvin | |||||
3266 | 3266 | 1984-03-01 | Industrias Quimicas y Tartaricas | 1983-01-28 | SPAIN | Barnes, Richardson & Colburn 2751 | 1977-02-10 | Barnes, Richardson & Colburn | Gerona | ||||
3267 | 3267 | 1984-03-01 | Japan Airlines | 1981-11-13 | JAPAN | Baskin & Sears, P.C. 3184 | 1981-01-06 | Baskin & Sears, P.C. | Tokyo | ||||
3268 | 3268 | 1984-03-01 | Reassemblement Pour la Republique | 1983-02-18 | FRANCE | Rassemblement Pour la Republique U.S.A., Inc. 3447 | 1983-02-18 | Rassemblement Pour la Republique U.S.A., Inc. | |||||
3269 | 3269 | 1984-03-01 | Republic of Guinea | 1983-08-26 | GUINEA | Cadwalader, Wickersham & Taft 3516 | 1983-08-25 | Cadwalader, Wickersham & Taft | DC | ||||
3270 | 3270 | 1984-03-01 | Republic of South Africa | 1981-01-06 | SOUTH AFRICA | Baskin & Sears, P.C. 3184 | 1981-01-06 | Baskin & Sears, P.C. | Washington | DC | |||
3271 | 3271 | 1984-03-01 | Tourism Canada | 1984-10-05 | CANADA | Dailey & Associates 2299 | 1971-12-27 | Dailey & Associates | Ottawa | ||||
3272 | 3272 | 1984-03-01 | Trinidad & Tobago | 1980-04-10 | TRINIDAD AND TOBAGO | Carpenters & Associates 3100 | 1980-04-10 | Carpenters & Associates |
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]) );