Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
This data as json, atom, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal
Registrant_Name
Country/Location_Represented
City
State
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 844 | 844 | 1988-01-01 | Budd Company | 1982-08-09 | GERMANY, FEDERAL REPUBLIC OF | 2217 2217 | 1970-11-05 | Taussig-Tomb & Associates | Troy | MI | |||
| 1965 | 1965 | 2019-02-01 | Tri-Star International Trading, Co. | 2018-07-06 | LIBYA | 6236 6236 | 2014-07-30 | Mayer Brown, LLP | 9602 Greenfield Road | Detroit | MI | 48227 | |
| 2202 | 2202 | 1994-02-09 | NSK Corporation | 1992-06-09 | JAPAN | 4681 4681 | 1992-06-09 | Donohue & Donohue, Attorneys at Law | Ann Arbor | MI | |||
| 6311 | 6311 | 1986-05-20 | Urdan Industries U.S.A., Ltd. | 1986-03-20 | ISRAEL | 3473 3473 | 1983-05-20 | Fried, Frank, Harris, Shriver & Jacobson | Southfield | MI | |||
| 7715 | 7715 | 1993-06-28 | Holnam, Inc. | 1992-12-22 | SWITZERLAND | 3987 3987 | 1987-05-29 | Crowell & Moring | Dundee | MI | |||
| 10628 | 10628 | 2017-08-31 | Bozel North America, LLC | 2017-02-16 | CAYMAN ISLANDS | 6180 6180 | 2013-08-12 | Sandler Trade, LLC | 7177 Crabb Road | Temperance | MI | 48182 | |
| 10633 | 10633 | 2017-08-31 | Polymet Alloys Inc. | 2017-02-16 | CAYMAN ISLANDS | 6180 6180 | 2013-08-12 | Sandler Trade, LLC | 7177 Crabb Road | Temperance | MI | 48182 | |
| 11431 | 11431 | 1989-09-30 | Consul General, Federal Republic of Germany | 1987-10-15 | GERMANY, FEDERAL REPUBLIC OF | 4051 4051 | 1987-10-15 | Durocher & Company, Inc. | Detroit | MI | |||
| 13095 | 13095 | 1972-11-07 | Republic of Bolivia | 1972-02-15 | BOLIVIA | 2315 2315 | 1972-02-15 | Rollinson, Long & Stein | MI |
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) );