FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Foreign_Principal_Termination_Date" is on date 2019-01-31 sorted by City
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_2, Zip, Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- Abdul Sattar 1
- Democratic Republic of Congo through Mer Security and Communications, Ltd. 1
- Embassy of Australia 1
- Embassy of Qatar (through Pillsbury Winthrop Shaw Pittman LLP) 1
- Embassy of the Republic of Suriname 1
- Government Technology Agency of Singapore 1
- Government Technology Agency of Singapore (via BCW Asia Pacific) 1
- Irina Vyshinsky 1
- Luxembourg Trade and Investment Office 1
- Members of the National Diet of Japan 1
Registrant_Name 9
Country/Location_Represented 9
- SINGAPORE 2
- AUSTRALIA 1
- BANGLADESH 1
- CONGO, REPUBLIC OF THE 1
- JAPAN 1
- LUXEMBOURG 1
- QATAR 1
- SURINAME 1
- UKRAINE 1
City 3
- - 6
- Washington 3
- Tokyo 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1915 | 1915 | 2019-01-31 | Abdul Sattar | 2018-09-06 | BANGLADESH | Rasky Partners 6586 | 2018-09-06 | Rasky Partners | 83 Wise Road | London E15 2TG | |||
1916 | 1916 | 2019-01-31 | Democratic Republic of Congo through Mer Security and Communications, Ltd. | 2018-02-14 | CONGO, REPUBLIC OF THE | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy 6399 | 2016-12-11 | Sonoran Policy Group, LLC D/B/A Stryk Global Diplomacy | 5 Hatzoref Street | Holon, Israel | |||
1920 | 1920 | 2019-01-31 | Government Technology Agency of Singapore (via BCW Asia Pacific) | 2020-05-13 | SINGAPORE | BCW LLC 6227 | 2014-06-18 | BCW LLC | |||||
1921 | 1921 | 2019-01-31 | Government Technology Agency of Singapore | 2018-12-03 | SINGAPORE | BCW LLC 6227 | 2014-06-18 | BCW LLC | 10 Pasir Panjang Road #10-01 Mapletree Business City | Singapore 117438 | |||
1922 | 1922 | 2019-01-31 | Irina Vyshinsky | 2018-12-11 | UKRAINE | Friedlander Group 6097 | 2012-04-25 | Friedlander Group | 117593 Russia, Moscow, Litovsky Boulevard | 3, build. 2, flat 380 | |||
1923 | 1923 | 2019-01-31 | Luxembourg Trade and Investment Office | 1994-03-10 | LUXEMBOURG | Luxcore, Ltd. 4901 | 1994-03-10 | Luxcore, Ltd. | New York | NY | |||
1924 | 1924 | 2019-01-31 | Members of the National Diet of Japan | 2018-07-20 | JAPAN | Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) 6574 | 2018-07-20 | Ippan Shadan Hojin Nippon Keizai Dantai Rengokai (KEIDANREN) | Nagatacho | Chiyoda-Ku | Tokyo | ||
1917 | 1917 | 2019-01-31 | Embassy of Australia | 2018-02-15 | AUSTRALIA | Hamilton Place Strategies, LLC 6526 | 2018-02-15 | Hamilton Place Strategies, LLC | 1601 Massachusetts Avenue, NW | Washington | DC | 20036 | |
1918 | 1918 | 2019-01-31 | Embassy of Qatar (through Pillsbury Winthrop Shaw Pittman LLP) | 2018-07-13 | QATAR | Sitrick Group, LLC 6572 | 2018-07-13 | Sitrick Group, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
1919 | 1919 | 2019-01-31 | Embassy of the Republic of Suriname | 2018-01-24 | SURINAME | Albertine Enterprises, Inc. 6512 | 2018-01-24 | Albertine Enterprises, Inc. | 4201 Connecticut Avenue, NW #400 | 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]) );