FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
31 rows where Foreign_Principal = "Embassy of the State of Qatar" sorted by rowid
This data as json, CSV (advanced)
Registrant_Name 12
- Ballard Partners 1
- California Strategies, LLC 1
- Collier Shannon Scott, PLLC 1
- Information Management Services, Inc. 1
- Integrated Strategy Group LLC 1
- Lexington Avenue Consulting 1
- Mercury Public Affairs, LLC 1
- PAVEA, LLC 1
- Portland PR Inc. 1
- Proof Strategies Inc. 1
- Silversmith Law Offices PLLC 1
- Stonington Strategies, LLC 1
Foreign_Principal 1
- Embassy of the State of Qatar · 12 ✖
Country/Location_Represented 1
- QATAR 12
City 1
- Washington 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7276 | 7276 | 2018-05-31 | Embassy of the State of Qatar | 2017-06-29 | QATAR | Information Management Services, Inc. 6442 | 2017-06-29 | Information Management Services, Inc. | 2555 M Street, NW | Washington | DC | 20037 | |
8743 | 8743 | 2017-06-30 | Embassy of the State of Qatar | 2015-01-15 | QATAR | Portland PR Inc. 6064 | 2011-09-19 | Portland PR Inc. | 2555 M Street, NW | Washington | DC | 20037 | |
8777 | 8777 | 2021-06-30 | Embassy of the State of Qatar | 2021-03-05 | QATAR | Integrated Strategy Group LLC 6933 | 2021-03-05 | Integrated Strategy Group LLC | 2555 M Street, NW | Washington | DC | 20037 | |
10328 | 10328 | 2022-08-13 | Embassy of the State of Qatar | 2021-12-18 | QATAR | California Strategies, LLC 7061 | 2021-12-18 | California Strategies, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
10653 | 10653 | 2018-08-21 | Embassy of the State of Qatar | 2017-09-03 | QATAR | Stonington Strategies, LLC 6458 | 2017-09-03 | Stonington Strategies, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
11174 | 11174 | 2019-08-31 | Embassy of the State of Qatar | 2019-01-09 | QATAR | PAVEA, LLC 6627 | 2019-01-09 | PAVEA, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
12742 | 12742 | 2019-10-15 | Embassy of the State of Qatar | 2015-01-02 | QATAR | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
13421 | 13421 | 2005-10-31 | Embassy of the State of Qatar | 2005-10-31 | QATAR | Collier Shannon Scott, PLLC 5718 | 2005-10-31 | Collier Shannon Scott, PLLC | 2555 M Street, NW | Washington | DC | 20037 | |
14777 | 14777 | 2020-12-03 | Embassy of the State of Qatar | 2018-04-02 | QATAR | Ballard Partners 6415 | 2017-04-05 | Ballard Partners | 601 Thirteenth Street NW | Suit 450 | Washington | DC | 20005 |
16824 | 16824 | 2018-12-31 | Embassy of the State of Qatar | 2018-10-03 | QATAR | Silversmith Law Offices PLLC 6597 | 2018-10-03 | Silversmith Law Offices PLLC | 255 M Street NW | Washington | |||
16873 | 16873 | 2020-12-31 | Embassy of the State of Qatar | 2019-12-30 | QATAR | Lexington Avenue Consulting 6777 | 2019-12-30 | Lexington Avenue Consulting | 2555 M Street, NW | Washington | DC | 20037 | |
16898 | 16898 | 2021-12-31 | Embassy of the State of Qatar | 2020-05-08 | QATAR | Proof Strategies Inc. 6822 | 2020-05-08 | Proof Strategies Inc. | 2555 M Street, NW | Washington | DC | 20037 |
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]) );