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