FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Foreign_Principal_Registration_Date = "2010-08-03"
This data as json, CSV (advanced)
Suggested facets: Registration_Number, Registrant_Date, Address_2, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 10
- Centrica LNG Company Limited 1
- China-United States Exchange Foundation 1
- Doha Bank 1
- Government of El Salvador 1
- Loomba Foundation 1
- Qatar 2022 Bid Committee 1
- Qatar Chamber of Commerce 1
- Qatar Diar Real Estate Investment Company 1
- Qatar Tourism Authority 1
- Shafallah Center for Children with Special Needs 1
Country/Location_Represented 4
- QATAR 6
- UNITED KINGDOM 2
- CHINA 1
- EL SALVADOR 1
City 3
- Doha 5
- - 4
- San Salvador 1
Registrant_Name 2
State 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1016 | 1016 | 2012-01-01 | Qatar 2022 Bid Committee | 2010-08-03 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | P.O. Box 62022 | 26th Floor, QOC Building | Doha | ||
2202 | 2202 | 2010-02-04 | Qatar Diar Real Estate Investment Company | 2010-08-03 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | Qatari Diar Visitors Center | Lusail District P.O. Box 23175 Doha | |||
3341 | 3341 | 2010-03-01 | Centrica LNG Company Limited | 2010-08-03 | UNITED KINGDOM | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | Millstream Maidenhead Road | Windsor Berkshire | |||
7900 | 7900 | 2010-06-17 | Qatar Chamber of Commerce | 2010-08-03 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | P.O. Box No. 402 | Doha | |||
8690 | 8690 | 2010-06-30 | Doha Bank | 2010-08-03 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | Attention: Sh. Fahad Bin Mohammad Bin Jabor Al Thani | Chairman of the Board of Directors PO Box 3818 | Doha | ||
8717 | 8717 | 2013-06-30 | Shafallah Center for Children with Special Needs | 2010-08-03 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | P.O. Box 4251 | Doha | |||
10047 | 10047 | 2011-08-01 | Government of El Salvador | 2010-08-03 | EL SALVADOR | Gephardt Group Government Affairs, LLC 5874 | 2008-07-21 | Gephardt Group Government Affairs, LLC | Casa Presidencial No. 5500 Manuel Enrique Araujo Highway | Colonia San Benito | San Salvador | ||
10859 | 10859 | 2011-08-30 | Loomba Foundation | 2010-08-03 | UNITED KINGDOM | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | |||||
13635 | 13635 | 2009-11-01 | Qatar Tourism Authority | 2010-08-03 | QATAR | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | P.O. Box 24624 | Doha | |||
16674 | 16674 | 2010-12-31 | China-United States Exchange Foundation | 2010-08-03 | CHINA | BLJ Worldwide LTD 5875 | 2008-06-17 | BLJ Worldwide LTD | 15/F shun Ho Tower | 24-30 Ice House Street, Central |
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]) );