FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
6 rows where "Foreign_Principal_Registration_Date" is on date 2019-08-23 sorted by Registrant_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_2, Zip
Foreign_Principal 6
- Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) 1
- Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) 1
- European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) 1
- Kanbawza Bank Limited (aka KBZ Bank) 1
- Lambert Mende Omalanga Minister of Communications and Media 1
- National Wildlife Federation (under grant from the Norwegian Agency for Development Cooperation) 1
Registrant_Name 3
Country/Location_Represented 3
City 3
- - 4
- Reston 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1927 | 1927 | 2020-01-31 | Lambert Mende Omalanga Minister of Communications and Media | 2019-08-23 | CONGO, REPUBLIC OF THE | Scribe Strategies & Advisors, Inc. 6305 | 2015-07-20 | Scribe Strategies & Advisors, Inc. | Ministry of Communications and Media | 83 avenue Tombalbaye Kinshasa Gombe | |||
1929 | 1929 | 2021-01-31 | Kanbawza Bank Limited (aka KBZ Bank) | 2019-08-23 | MYANMAR (BURMA) | Williams & Connolly LLP 6711 | 2019-08-23 | Williams & Connolly LLP | No. (615/1), Pyay Road, | Kamayut Township, Yangon | |||
4799 | 4799 | 2021-03-31 | Aidenvironment (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | Barentszplein 7 1013 NJ Amsterdam Netherlands | ||||
16871 | 16871 | 2020-12-31 | Center for International Policy (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 2000 M Street, NW | Suite 720 | Washington | DC | 20036 |
16875 | 16875 | 2020-12-31 | European Federation for Transport and Environment (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 18 Square De Meeus, 2nd Floor, Brussels, Belgium 1050 | ||||
16881 | 16881 | 2020-12-31 | National Wildlife Federation (under grant from the Norwegian Agency for Development Cooperation) | 2019-08-23 | NORWAY | Waxman Consulting, Inc. DBA Waxman Strategies 6710 | 2019-08-23 | Waxman Consulting, Inc. DBA Waxman Strategies | 11100 Wildlife Center Drive | Reston | VA | 20190 |
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]) );