FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
1 row where 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 City
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]) );