FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where Foreign_Principal_Termination_Date = "2019-07-31" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 9
- Embassy of the Bolivarian Republic of Venezuela 1
- Government of Canada, Embassy 1
- Government of Scotland in North America 1
- Innovative Technology & Business Consulting LLC 1
- Lord Gregory Barker of Battle 1
- Province of Ontario, Canada 1
- Sokolov, Michael 1
- Taipei Economic and Cultural Representative Office in the U.S. 1
- White House Writers Group on behalf of the Consulate of Poland 1
Registrant_Name 8
City 5
- - 3
- Washington 3
- New York 1
- Pikesville 1
- Toronto 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9928 | 9928 | 2019-07-31 | Government of Canada, Embassy | 1989-03-09 | CANADA | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | Washington | DC | |||
9932 | 9932 | 2019-07-31 | Province of Ontario, Canada | 2006-05-17 | CANADA | Foster Garvey PC 3047 | 1979-08-09 | Foster Garvey PC | Ministry of the Attorney General | Legal Services Branch, Environment and Energy 10th Floor, 135 St. Clair Ave | Toronto | ||
9935 | 9935 | 2019-07-31 | White House Writers Group on behalf of the Consulate of Poland | 2018-06-21 | POLAND | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 233 Madison Avenue | New York | NY | 10016 | |
9930 | 9930 | 2019-07-31 | Innovative Technology & Business Consulting LLC | 2018-07-06 | UKRAINE | Livingston Group, LLC 6344 | 2016-03-25 | Livingston Group, LLC | 1829 Reisterstown Road, Suite 350 | Pikesville | MD | 21208 | |
9927 | 9927 | 2019-07-31 | Embassy of the Bolivarian Republic of Venezuela | 2018-12-15 | VENEZUELA | Flores, Leonardo 6613 | 2018-12-15 | Flores, Leonardo | 1099 30th Street, NW | Washington | DC | 20007 | |
9931 | 9931 | 2019-07-31 | Lord Gregory Barker of Battle | 2019-01-23 | RUSSIA | Latham & Watkins LLP 6628 | 2019-01-23 | Latham & Watkins LLP | The Old Rectory, Warbleton, Heathfield, East Sussex, TN21 9PT | UK | |||
9929 | 9929 | 2019-07-31 | Government of Scotland in North America | 2019-01-28 | SCOTLAND | Clyde Group, LLC 6631 | 2019-01-28 | Clyde Group, LLC | 3100 Massachusetts Avenue, NW | Washington | DC | 20008 | |
9934 | 9934 | 2019-07-31 | Taipei Economic and Cultural Representative Office in the U.S. | 2019-03-11 | TAIWAN | Castillo, Edward O. 6643 | 2019-03-11 | Castillo, Edward O. | 4201 WIsconsin Avenue, NW | Washington | DC | 20016 | |
9933 | 9933 | 2019-07-31 | Sokolov, Michael | 2019-12-03 | UKRAINE | ITBC LLC 6762 | 2019-12-03 | ITBC LLC |
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]) );