FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where "Foreign_Principal_Termination_Date" is on date 1991-03-31
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Address_1, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 15
- Australian Wheat Board 1
- Denis Sassou-Nguesso, President of The Republic of the Congo 1
- Dofasco, Inc. 1
- Electronic Industries Association of Japan 1
- Embassy of South Africa 1
- Fujitsu Microelectronics 1
- Global News Service 1
- Government of Japan 1
- Government of Kenya 1
- Japan External Trade Organization 1
- Japan Foundation 1
- Polish People's Republic State Administration for Tourism 1
- Republic of Romania 1
- Republic of the Congo President Denis Sassou-Nguesso 1
- Stelco, Inc. 1
Registrant_Name 13
- Modern Education Services, Inc. 2
- Pack, Allen Scott 2
- Ball, Janik & Novack 1
- Belin, Harris, Helmick, Lamson, McCormick, P.C. 1
- Black, Kelly, Scruggs & Healey 1
- Daniel J. Edelman, Inc. 1
- Garrett & Company 1
- I.S.I. Enterprises, Inc. 1
- JETRO, Puerto Rico 1
- Pearson & Pipkin, Inc. 1
- Polish National Tourist Office, Chicago 1
- Tanaka, Michele N. 1
- Vickers, Eugene B. 1
Country/Location_Represented 8
- JAPAN 5
- CANADA 2
- CONGO, DEMOCRATIC REPUBLIC OF THE 2
- SOUTH AFRICA 2
- AUSTRALIA 1
- KENYA 1
- POLAND 1
- ROMANIA 1
City 1
- - 15
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4496 | 4496 | 1991-03-31 | Polish People's Republic State Administration for Tourism | 1982-04-21 | POLAND | Polish National Tourist Office, Chicago 3360 | 1982-04-21 | Polish National Tourist Office, Chicago | Warsaw | ||||
4497 | 4497 | 1991-03-31 | Australian Wheat Board | 1987-10-14 | AUSTRALIA | Vickers, Eugene B. 4050 | 1987-10-14 | Vickers, Eugene B. | Melbourne, Victoria | ||||
4498 | 4498 | 1991-03-31 | Denis Sassou-Nguesso, President of The Republic of the Congo | 1990-07-25 | CONGO, DEMOCRATIC REPUBLIC OF THE | Garrett & Company 4398 | 1990-07-12 | Garrett & Company | Brazzaville | ||||
4499 | 4499 | 1991-03-31 | Dofasco, Inc. | 1985-09-27 | CANADA | Pack, Allen Scott 3741 | 1985-09-27 | Pack, Allen Scott | Ontario | ||||
4500 | 4500 | 1991-03-31 | Electronic Industries Association of Japan | 1977-12-09 | JAPAN | Tanaka, Michele N. 948 | 1956-04-24 | Tanaka, Michele N. | |||||
4501 | 4501 | 1991-03-31 | Embassy of South Africa | 1985-08-29 | SOUTH AFRICA | Pearson & Pipkin, Inc. 3727 | 1985-08-29 | Pearson & Pipkin, Inc. | |||||
4502 | 4502 | 1991-03-31 | Fujitsu Microelectronics | 1989-03-28 | JAPAN | Ball, Janik & Novack 4230 | 1989-03-28 | Ball, Janik & Novack | San Jose | CA | |||
4503 | 4503 | 1991-03-31 | Global News Service | 1987-07-13 | SOUTH AFRICA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | |||||
4504 | 4504 | 1991-03-31 | Government of Japan | 1991-04-18 | JAPAN | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | New York | NY | |||
4505 | 4505 | 1991-03-31 | Government of Kenya | 1989-05-18 | KENYA | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Nairobi | ||||
4506 | 4506 | 1991-03-31 | Japan External Trade Organization | 1973-10-23 | JAPAN | JETRO, Puerto Rico 2468 | 1973-10-23 | JETRO, Puerto Rico | |||||
4507 | 4507 | 1991-03-31 | Japan Foundation | 1981-07-30 | JAPAN | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | NY | ||||
4508 | 4508 | 1991-03-31 | Republic of Romania | 1991-02-28 | ROMANIA | Belin, Harris, Helmick, Lamson, McCormick, P.C. 4478 | 1991-02-28 | Belin, Harris, Helmick, Lamson, McCormick, P.C. | Bucharest | ||||
4509 | 4509 | 1991-03-31 | Republic of the Congo President Denis Sassou-Nguesso | 1990-07-16 | CONGO, DEMOCRATIC REPUBLIC OF THE | I.S.I. Enterprises, Inc. 4399 | 1990-07-16 | I.S.I. Enterprises, Inc. | |||||
4510 | 4510 | 1991-03-31 | Stelco, Inc. | 1985-09-27 | CANADA | Pack, Allen Scott 3741 | 1985-09-27 | Pack, Allen Scott | Ontario |
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]) );