FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
15 rows where Country/Location_Represented = "LATVIA" and State = "DC" sorted by Foreign_Principal_Registration_Date
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 14
- Republic of Latvia 2
- Anatol Dinbergs 1
- Dr. Alfred Bilmanis 1
- Dr. Alfred Bilmanis, Latvian Minister & Consul General of Latvia in the U.S. & the Latvian Legation 1
- Dr. Anatol Dinbergs 1
- Dr. Anatol Dinbergs, Counselor, Latvian Legation 1
- Dr. Arnolds Spekke 1
- Dr. Arnolds Spekke, Charge d'Affaires of Lativa to the U.S. 1
- Embassy of Latvia 1
- Government of Latvia, Ministry of Foreign Affairs, Embassy 1
- Latvian Legation 1
- Legation of Latvia 1
- Ministry of Foreign Affairs of the Republic of Latvia, Embassy 1
- Republic of Latvia, Embassy 1
Registrant_Name 11
City 2
- - 14
- Washington 1
State 1
- DC · 15 ✖
Country/Location_Represented 1
- LATVIA · 15 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11693 | 11693 | 1963-09-18 | Dr. Arnolds Spekke, Charge d'Affaires of Lativa to the U.S. | 1942-07-15 | LATVIA | Law Jr., Robert H. 46 | 1942-07-15 | Law Jr., Robert H. | Washington | DC | |||
11694 | 11694 | 1963-09-18 | Dr. Alfred Bilmanis, Latvian Minister & Consul General of Latvia in the U.S. & the Latvian Legation | 1942-07-15 | LATVIA | Law Jr., Robert H. 46 | 1942-07-15 | Law Jr., Robert H. | Washington | DC | |||
11695 | 11695 | 1963-09-18 | Dr. Anatol Dinbergs, Counselor, Latvian Legation | 1942-07-15 | LATVIA | Law Jr., Robert H. 46 | 1942-07-15 | Law Jr., Robert H. | Washington | DC | |||
4072 | 4072 | 1944-03-27 | Latvian Legation | 1942-07-17 | LATVIA | Lielnors, Harry W. 53 | 1942-07-17 | Lielnors, Harry W. | Washington | DC | |||
3856 | 3856 | 1943-03-18 | Republic of Latvia | 1942-09-18 | LATVIA | Ekis, Ludvigs 125 | 1942-09-18 | Ekis, Ludvigs | Washington | DC | |||
5595 | 5595 | 1951-04-26 | Dr. Alfred Bilmanis | 1944-12-06 | LATVIA | Shillers, Rudolf 284 | 1944-12-06 | Shillers, Rudolf | Washington | DC | |||
5594 | 5594 | 1951-04-26 | Anatol Dinbergs | 1949-02-15 | LATVIA | Shillers, Rudolf 284 | 1944-12-06 | Shillers, Rudolf | Washington | DC | |||
8126 | 8126 | 1973-06-27 | Dr. Anatol Dinbergs | 1963-12-16 | LATVIA | Law III, Robert H. 1672 | 1963-12-16 | Law III, Robert H. | Washington | DC | |||
8127 | 8127 | 1973-06-27 | Dr. Arnolds Spekke | 1963-12-16 | LATVIA | Law III, Robert H. 1672 | 1963-12-16 | Law III, Robert H. | Washington | DC | |||
2193 | 2193 | 1993-02-04 | Legation of Latvia | 1990-12-31 | LATVIA | Kalnins, Ojars Erik 4457 | 1990-12-31 | Kalnins, Ojars Erik | Washington | DC | |||
8041 | 8041 | 1994-06-23 | Republic of Latvia | 1993-03-22 | LATVIA | Shaw, Pittman, Potts & Trowbridge 2580 | 1975-02-21 | Shaw, Pittman, Potts & Trowbridge | Washington | DC | |||
9272 | 9272 | 1997-07-15 | Government of Latvia, Ministry of Foreign Affairs, Embassy | 1997-04-25 | LATVIA | Smith, Anne Victoria 5177 | 1997-04-25 | Smith, Anne Victoria | Washington | DC | |||
6578 | 6578 | 2003-05-15 | Ministry of Foreign Affairs of the Republic of Latvia, Embassy | 2001-05-30 | LATVIA | Orion Strategies LLC 5437 | 2001-05-30 | Orion Strategies LLC | Embassy of the Republic of Latvia 4325 17th Street, N.W. 20011 | DC | |||
9851 | 9851 | 2004-07-31 | Embassy of Latvia | 2004-05-26 | LATVIA | Dutko Group Companies 5625 | 2004-05-26 | Dutko Group Companies | Embassy of Lativa 4325 17th Street, N.W. 20011 | DC | |||
12474 | 12474 | 2007-10-04 | Republic of Latvia, Embassy | 2007-05-01 | LATVIA | Dutko Worldwide, LLC 5804 | 2007-05-01 | Dutko Worldwide, LLC | 2306 Massachusetts Avenue, NW | Washington | DC | 20008 |
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]) );