FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
25 rows where "Registrant_Date" is on date 1983-06-23
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Address_1, Foreign_Principal_Registration_Date (date)
Foreign_Principal 24
- Lake Ontario Cement, Ltd. 2
- Agora Centro de Estudios Internacionales (ACEI) 1
- Agro-Quimicas de Guatemala, S.A. 1
- All Nippon Airways Company, Ltd. 1
- Asbestos Institute 1
- Asia Satellite Telecommunications, Hong Kong, Ltd. 1
- Asocolflores 1
- Association for the Advancement of Human Rights in Japan 1
- C.B.I. Sugar Group (Through Michael K. Deaver & Associates) 1
- C.B.I. Sugar Group, Inc. 1
- Canada Cement Lafarge, Ltd. 1
- Consulate of Columbia 1
- Daiwa Securities Company, Ltd. 1
- Inland Cement, Ltd. (Genstar Cement, Ltd.) 1
- International Maritime Satellite Organization 1
- Japan Tobacco, Inc. 1
- Mitsubishi Electric Corporation 1
- Mitsubishi Electronics, America, Inc. 1
- Novatel Communications, Ltd. 1
- RSV Mining Equipment, B.V. 1
- St. Lawrence Cement, Inc. 1
- St. Marys Cement, Ltd. 1
- Thai Steel Pipe Association 1
- Yamaichi Securities Company, Ltd. 1
Country/Location_Represented 10
- CANADA 8
- JAPAN 7
- COLOMBIA 2
- GUATEMALA 2
- ARGENTINA 1
- GREAT BRITAIN 1
- HONG KONG 1
- NETHERLANDS 1
- PANAMA 1
- THAILAND 1
State 1
- - 25
Registrant_Name 1
City 1
- - 25
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 870 | 870 | 1985-01-01 | Consulate of Columbia | 1984-01-25 | COLOMBIA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | |||||
| 916 | 916 | 1989-01-01 | Asocolflores | 1983-06-23 | COLOMBIA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Bogota | ||||
| 920 | 920 | 1989-01-01 | International Maritime Satellite Organization | 1987-06-01 | GREAT BRITAIN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | |||||
| 1730 | 1730 | 1988-01-31 | Lake Ontario Cement, Ltd. | 1987-08-04 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | |||||
| 2593 | 2593 | 1990-02-16 | Agro-Quimicas de Guatemala, S.A. | 1986-04-14 | GUATEMALA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | |||||
| 2594 | 2594 | 1990-02-16 | C.B.I. Sugar Group, Inc. | 1986-08-13 | GUATEMALA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | |||||
| 2595 | 2595 | 1990-02-16 | St. Lawrence Cement, Inc. | 1983-06-23 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Quebec | ||||
| 2596 | 2596 | 1990-02-16 | St. Marys Cement, Ltd. | 1985-11-21 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Toronto, Ontario | ||||
| 2597 | 2597 | 1990-02-16 | Thai Steel Pipe Association | 1987-10-16 | THAILAND | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Samutprakarn | ||||
| 4425 | 4425 | 1986-03-31 | All Nippon Airways Company, Ltd. | 1986-03-17 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Tokyo | ||||
| 4916 | 4916 | 1989-04-01 | Canada Cement Lafarge, Ltd. | 1985-11-21 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Montreal, Quebec | ||||
| 7401 | 7401 | 1988-06-01 | RSV Mining Equipment, B.V. | 1983-06-23 | NETHERLANDS | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Rotterdam | ||||
| 7571 | 7571 | 1986-06-04 | Lake Ontario Cement, Ltd. | 1985-11-21 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Toronto, Ontario | ||||
| 7833 | 7833 | 1989-06-15 | Agora Centro de Estudios Internacionales (ACEI) | 1988-10-13 | ARGENTINA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Buenos Aires | ||||
| 7835 | 7835 | 1989-06-15 | Daiwa Securities Company, Ltd. | 1987-08-04 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | |||||
| 7836 | 7836 | 1989-06-15 | Yamaichi Securities Company, Ltd. | 1988-03-07 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Tokyo | ||||
| 8416 | 8416 | 1987-06-30 | Inland Cement, Ltd. (Genstar Cement, Ltd.) | 1985-11-21 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Edmonton, Alberta | ||||
| 10322 | 10322 | 1986-08-13 | C.B.I. Sugar Group (Through Michael K. Deaver & Associates) | 1985-10-22 | PANAMA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Panama City | ||||
| 10842 | 10842 | 1986-08-30 | Asbestos Institute | 1986-05-01 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Montreal, Quebec | ||||
| 13158 | 13158 | 1986-10-30 | Japan Tobacco, Inc. | 1985-12-23 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Tokyo | ||||
| 13159 | 13159 | 1986-10-30 | Mitsubishi Electric Corporation | 1985-11-21 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Tokyo | ||||
| 13160 | 13160 | 1986-10-30 | Mitsubishi Electronics, America, Inc. | 1985-10-11 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | |||||
| 14383 | 14383 | 1989-11-30 | Asia Satellite Telecommunications, Hong Kong, Ltd. | 1988-07-27 | HONG KONG | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Wanchai | ||||
| 15995 | 15995 | 1987-12-31 | Association for the Advancement of Human Rights in Japan | 1986-01-27 | JAPAN | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell | Tokyo | ||||
| 16072 | 16072 | 1988-12-31 | Novatel Communications, Ltd. | 1987-08-12 | CANADA | Heron, Burchette, Ruckert & Rothwell 3488 | 1983-06-23 | Heron, Burchette, Ruckert & Rothwell |
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]) );