FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where "Foreign_Principal_Termination_Date" is on date 1992-03-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Address_1, Registrant_Date (date)
Registrant_Name 11
- Riley & Fox, Inc. 2
- Bayh, Connaughton, Fensterheim & Malone, P.C. 1
- Charles von Loewenfeldt, Inc. 1
- Garrett & Company 1
- I.S.I. Enterprises, Inc. 1
- Jones Day 1
- Manchester Trade, Inc. 1
- Miller, Canfield, Paddock & Stone, P.L.C. 1
- Paul, Weiss, Rifkind, Wharton & Garrison 1
- Productions by Hirahara 1
- Wilmer, Cutler & Pickering 1
Foreign_Principal 11
- Eurafrica Communications, Inc. 2
- Chamber of Mines of South Africa 1
- Electronic Industries Association of Korea 1
- European Communities 1
- Federation of Bankers' Association of Japan 1
- Government of the Republic of Belarus 1
- JETRO, Los Angeles (Japan External Trade Organization) 1
- Japan Foundation 1
- Jugopetrol 1
- Newsprint Section of the Canadian Pulp & Paper Association 1
- Republic of South Africa 1
Country/Location_Represented 8
City 1
- - 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4511 | 4511 | 1992-03-31 | Federation of Bankers' Association of Japan | 1991-05-15 | JAPAN | Jones Day 3427 | 1982-12-10 | Jones Day | Tokyo | ||||
4512 | 4512 | 1992-03-31 | Chamber of Mines of South Africa | 1989-06-12 | SOUTH AFRICA | Riley & Fox, Inc. 3813 | 1986-04-11 | Riley & Fox, Inc. | Johannesburg | ||||
4513 | 4513 | 1992-03-31 | Electronic Industries Association of Korea | 1990-05-11 | KOREA, SOUTH | Manchester Trade, Inc. 4149 | 1988-06-22 | Manchester Trade, Inc. | Seoul | ||||
4514 | 4514 | 1992-03-31 | Eurafrica Communications, Inc. | 1991-05-03 | CONGO, DEMOCRATIC REPUBLIC OF THE | I.S.I. Enterprises, Inc. 4399 | 1990-07-16 | I.S.I. Enterprises, Inc. | Washington | DC | |||
4515 | 4515 | 1992-03-31 | Eurafrica Communications, Inc. | 1991-05-07 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Washington | DC | |||
4516 | 4516 | 1992-03-31 | European Communities | 1987-11-23 | GREAT BRITAIN | Wilmer, Cutler & Pickering 3355 | 1982-04-08 | Wilmer, Cutler & Pickering | Washington | DC | |||
4517 | 4517 | 1992-03-31 | Government of the Republic of Belarus | 1992-03-25 | BELARUS | Miller, Canfield, Paddock & Stone, P.L.C. 4524 | 1991-05-23 | Miller, Canfield, Paddock & Stone, P.L.C. | Minsk | ||||
4518 | 4518 | 1992-03-31 | JETRO, Los Angeles (Japan External Trade Organization) | 1988-03-08 | JAPAN | Productions by Hirahara 4099 | 1988-03-08 | Productions by Hirahara | Los Angeles | CA | |||
4519 | 4519 | 1992-03-31 | Japan Foundation | 1987-02-10 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | Tokyo | ||||
4520 | 4520 | 1992-03-31 | Jugopetrol | 1992-01-13 | YUGOSLAVIA | Bayh, Connaughton, Fensterheim & Malone, P.C. 4606 | 1992-01-13 | Bayh, Connaughton, Fensterheim & Malone, P.C. | Belgrade | ||||
4521 | 4521 | 1992-03-31 | Newsprint Section of the Canadian Pulp & Paper Association | 1991-10-17 | CANADA | Paul, Weiss, Rifkind, Wharton & Garrison 4539 | 1991-07-09 | Paul, Weiss, Rifkind, Wharton & Garrison | Quebec | ||||
4522 | 4522 | 1992-03-31 | Republic of South Africa | 1986-04-11 | SOUTH AFRICA | Riley & Fox, Inc. 3813 | 1986-04-11 | Riley & Fox, Inc. |
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]) );