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 = "1986-06-30"
This data as json, CSV (advanced)
Suggested facets: Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 13
- Anderson, Hibey & Blair 1
- Black, Kelly, Scruggs & Healey 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Daniel J. Edelman, Inc. 1
- Development Counsellors International, Ltd. 1
- GFE, Ltd. 1
- Hill and Knowlton Strategies, LLC 1
- Korea Trade Center, Atlanta 1
- Manafort Jr., Paul J. 1
- Michael K. Deaver & Associates 1
- Modern Education Services, Inc. 1
- Mudge, Rose, Guthrie, Alexander & Ferdon 1
- Tromson Monroe Advertising, Inc. 1
Foreign_Principal 13
- Canadian Asbestos Information Center 1
- DESC Comercio Exterior, S.A. de C.V. 1
- Electronic Industries Association of Japan (EIAJ) 1
- Embassy of the Government of Canada 1
- Glenrothes Development Corporation 1
- Government of Peru 1
- Government of Saudi Arabia 1
- Instituto Brasileiro de Siderurgia 1
- Korea Trade Promotion Corporation - Government of the Republic of Korea 1
- Peugeot, S.A. 1
- Republic of Panama 1
- Royal Air Maroc 1
- Tourist Authority of Thailand 1
Country/Location_Represented 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8401 | 8401 | 1986-06-30 | Canadian Asbestos Information Center | 1983-11-08 | CANADA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Montreal, Quebec | ||||
8402 | 8402 | 1986-06-30 | DESC Comercio Exterior, S.A. de C.V. | 1985-10-03 | MEXICO | GFE, Ltd. 3705 | 1985-07-18 | GFE, Ltd. | |||||
8403 | 8403 | 1986-06-30 | Electronic Industries Association of Japan (EIAJ) | 1985-12-27 | JAPAN | Mudge, Rose, Guthrie, Alexander & Ferdon 3200 | 1981-02-18 | Mudge, Rose, Guthrie, Alexander & Ferdon | Tokyo | ||||
8404 | 8404 | 1986-06-30 | Embassy of the Government of Canada | 1985-09-15 | CANADA | Michael K. Deaver & Associates 3734 | 1985-09-18 | Michael K. Deaver & Associates | Washington | DC | |||
8405 | 8405 | 1986-06-30 | Glenrothes Development Corporation | 1980-06-11 | SCOTLAND | Development Counsellors International, Ltd. 1421 | 1961-01-30 | Development Counsellors International, Ltd. | |||||
8406 | 8406 | 1986-06-30 | Government of Peru | 1985-09-16 | PERU | Black, Kelly, Scruggs & Healey 3600 | 1984-06-14 | Black, Kelly, Scruggs & Healey | Lima | ||||
8407 | 8407 | 1986-06-30 | Government of Saudi Arabia | 1984-06-04 | SAUDI ARABIA | Manafort Jr., Paul J. 3594 | 1984-06-04 | Manafort Jr., Paul J. | Washington | DC | |||
8408 | 8408 | 1986-06-30 | Instituto Brasileiro de Siderurgia | 1984-10-19 | BRAZIL | Anderson, Hibey & Blair 3208 | 1981-03-09 | Anderson, Hibey & Blair | Rio de Janeiro | ||||
8409 | 8409 | 1986-06-30 | Korea Trade Promotion Corporation - Government of the Republic of Korea | 1977-03-14 | KOREA, SOUTH | Korea Trade Center, Atlanta 2760 | 1977-03-14 | Korea Trade Center, Atlanta | Seoul | ||||
8410 | 8410 | 1986-06-30 | Peugeot, S.A. | 1985-11-01 | FRANCE | Cleary, Gottlieb, Steen & Hamilton, LLP 508 | 1948-01-19 | Cleary, Gottlieb, Steen & Hamilton, LLP | Paris | ||||
8411 | 8411 | 1986-06-30 | Republic of Panama | 1988-03-22 | PANAMA | Daniel J. Edelman, Inc. 3657 | 1985-03-12 | Daniel J. Edelman, Inc. | |||||
8412 | 8412 | 1986-06-30 | Royal Air Maroc | 1986-05-21 | MOROCCO | Tromson Monroe Advertising, Inc. 2403 | 1973-01-09 | Tromson Monroe Advertising, Inc. | |||||
8413 | 8413 | 1986-06-30 | Tourist Authority of Thailand | 1984-01-11 | THAILAND | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, 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]) );