FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where State = "MI"
This data as json, 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 9
Registrant_Name 8
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
899 | 899 | 1988-01-01 | Budd Company | 1982-08-09 | GERMANY, FEDERAL REPUBLIC OF | Taussig-Tomb & Associates 2217 | 1970-11-05 | Taussig-Tomb & Associates | Troy | MI | |||
2081 | 2081 | 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 | |
2331 | 2331 | 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 | |||
6664 | 6664 | 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 | |||
8136 | 8136 | 1993-06-28 | Holnam, Inc. | 1992-12-22 | SWITZERLAND | Crowell & Moring 3987 | 1987-05-29 | Crowell & Moring | Dundee | MI | |||
11153 | 11153 | 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 | |
11158 | 11158 | 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 | |
12001 | 12001 | 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 | |||
13775 | 13775 | 1972-11-07 | Republic of Bolivia | 1972-02-15 | BOLIVIA | Rollinson, Long & Stein 2315 | 1972-02-15 | Rollinson, Long & Stein | MI |
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]) );