FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where Country/Location_Represented = "DOMINICA" and Foreign_Principal = "Scott Caruthers, Ambassador at Large, Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine from the Commonwealth of Dominica" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
State 1
- MD 1
Registrant_Name 1
Foreign_Principal 1
- Scott Caruthers, Ambassador at Large, Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine from the Commonwealth of Dominica · 1 ✖
Country/Location_Represented 1
- DOMINICA · 1 ✖
City 1
- - 1
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13771 | 13771 | 2000-11-06 | Scott Caruthers, Ambassador at Large, Honorary Consul Designate to Washington, D.C. and Ambassador Designate to the Ukraine from the Commonwealth of Dominica | 2000-05-18 | DOMINICA | Gershberg & Associates, LLC 5370 | 2000-05-18 | Gershberg & Associates, LLC | 597 Scott Drive Westminster | MD |
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]) );