FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Address_1 = "Washington" and Country/Location_Represented = "LATVIA" sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 11
- 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
- Government of Latvia, Ministry of Foreign Affairs, Embassy 1
- Latvian Legation 1
- Legation of Latvia 1
Registrant_Name 8
State 1
- DC 12
Country/Location_Represented 1
- LATVIA · 12 ✖
City 1
- - 12
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 | |||
5594 | 5594 | 1951-04-26 | Anatol Dinbergs | 1949-02-15 | LATVIA | Shillers, Rudolf 284 | 1944-12-06 | Shillers, Rudolf | Washington | DC | |||
5595 | 5595 | 1951-04-26 | Dr. Alfred Bilmanis | 1944-12-06 | 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 | |||
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 | |||
2193 | 2193 | 1993-02-04 | Legation of Latvia | 1990-12-31 | LATVIA | Kalnins, Ojars Erik 4457 | 1990-12-31 | Kalnins, Ojars Erik | 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 |
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]) );