FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
28 rows where Foreign_Principal = "Embassy of the State of Qatar" and State = "DC" sorted by City
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Address_1, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 27
- Mercury Public Affairs, LLC 2
- Avenue Strategies, LLC 1
- BGR Government Affairs, LLC 1
- Ballard Partners 1
- Bridge Builder Communications LLC 1
- California Strategies, LLC 1
- Collier Shannon Scott, PLLC 1
- Ferox Strategies LLC 1
- Gallagher Group, LLC 1
- Information Management Services, Inc. 1
- Integrated Strategy Group LLC 1
- JWI, LLC 1
- Lexington Avenue Consulting 1
- Lumen8 Advisors, LLC 1
- Ogilvy Government Relations 1
- PAVEA, LLC 1
- Portland PR Inc. 1
- Praia Consultants LLC 1
- Proof Strategies Inc. 1
- Rahall Consulting Group 1
- Reed, T. Dean 1
- Rubin Turnbull & Associates, Inc. 1
- Stonington Strategies, LLC 1
- ThirdCircle, Inc. 1
- Tigercomm, LLC 1
- Venable, LLP 1
- Waltham PLLC 1
Registrant_Date 27 ✖
- 2013-05-14 2
- 1995-02-06 1
- 1995-09-13 1
- 2001-05-10 1
- 2002-11-19 1
- 2005-10-31 1
- 2009-04-17 1
- 2011-09-19 1
- 2015-02-12 1
- 2017-04-05 1
- 2017-06-29 1
- 2017-07-24 1
- 2017-09-03 1
- 2018-01-23 1
- 2018-03-29 1
- 2018-04-13 1
- 2019-01-09 1
- 2019-12-17 1
- 2019-12-30 1
- 2020-03-20 1
- 2020-05-08 1
- 2020-08-18 1
- 2021-02-03 1
- 2021-02-09 1
- 2021-03-05 1
- 2021-04-01 1
- 2021-12-18 1
Zip 4 ✖
- 20037 25
- - 1
- 20005 1
- 20037-1305 1
City 2
- Washington 27
- - 1
State 1
- DC · 28 ✖
Foreign_Principal 1
- Embassy of the State of Qatar · 28 ✖
Country/Location_Represented 1
- QATAR 28
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1171 | 1171 | 2006-01-09 | Embassy of the State of Qatar | 2002-11-19 | QATAR | Rahall Consulting Group 5531 | 2002-11-19 | Rahall Consulting Group | 4200 Wisconsin Avenue, N.W. Suite 200 20016 | DC | |||
218 | 218 | Embassy of the State of Qatar | 2019-01-22 | QATAR | ThirdCircle, Inc. 6540 | 2018-04-13 | ThirdCircle, Inc. | 2555 M Street, NW | Washington | DC | 20037 | ||
219 | 219 | Embassy of the State of Qatar | 2018-02-05 | QATAR | Venable, LLP 5931 | 2009-04-17 | Venable, LLP | 2555 M Street, NW | Washington | DC | 20037 | ||
220 | 220 | Embassy of the State of Qatar | 2020-03-20 | QATAR | Bridge Builder Communications LLC 6804 | 2020-03-20 | Bridge Builder Communications LLC | 2555 M St NW | Washington | DC | 20037 | ||
221 | 221 | Embassy of the State of Qatar | 2018-03-29 | QATAR | Lumen8 Advisors, LLC 6537 | 2018-03-29 | Lumen8 Advisors, LLC | 2555 M Street, NW | Washington | DC | 20037 | ||
222 | 222 | Embassy of the State of Qatar | 2021-04-01 | QATAR | Rubin Turnbull & Associates, Inc. 6944 | 2021-04-01 | Rubin Turnbull & Associates, Inc. | 2555 M Street, NW | Washington | DC | 20037 | ||
223 | 223 | Embassy of the State of Qatar | 2022-05-09 | QATAR | Ferox Strategies LLC 6922 | 2021-02-03 | Ferox Strategies LLC | 2555 M Street, NW | Washington | DC | 20037 | ||
224 | 224 | Embassy of the State of Qatar | 2020-08-18 | QATAR | Praia Consultants LLC 6857 | 2020-08-18 | Praia Consultants LLC | 2555 M St. NW | Washington | DC | 20037 | ||
226 | 226 | Embassy of the State of Qatar | 2021-12-08 | QATAR | BGR Government Affairs, LLC 5430 | 2001-05-10 | BGR Government Affairs, LLC | 2555 M Street, NW | Washington | DC | 20037 | ||
227 | 227 | Embassy of the State of Qatar | 2019-12-10 | QATAR | Mercury Public Affairs, LLC 6170 | 2013-05-14 | Mercury Public Affairs, LLC | 2555 M Street NW | Washington | DC | 20037 | ||
228 | 228 | Embassy of the State of Qatar | 2019-12-17 | QATAR | Waltham PLLC 6771 | 2019-12-17 | Waltham PLLC | 2555 M Street, NW | Washington | DC | 20037 | ||
2087 | 2087 | 2022-02-01 | Embassy of the State of Qatar | 2021-02-09 | QATAR | Ogilvy Government Relations 6924 | 2021-02-09 | Ogilvy Government Relations | 2555 M Street, NW | Washington | DC | 20037 | |
4095 | 4095 | 2020-03-27 | Embassy of the State of Qatar | 2016-07-27 | QATAR | Gallagher Group, LLC 6277 | 2015-02-12 | Gallagher Group, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
4790 | 4790 | 2020-03-31 | Embassy of the State of Qatar | 2020-04-07 | QATAR | JWI, LLC 4990 | 1995-02-06 | JWI, LLC | 2555 M St., NW | Washington | DC | 20037 | |
4973 | 4973 | 2020-04-01 | Embassy of the State of Qatar | 2018-06-22 | QATAR | Reed, T. Dean 5044 | 1995-09-13 | Reed, T. Dean | 2555 M Street, NW | Washington | DC | 20037 | |
4974 | 4974 | 2020-04-01 | Embassy of the State of Qatar | 2017-07-24 | QATAR | Avenue Strategies, LLC 6446 | 2017-07-24 | Avenue Strategies, LLC | 2555 M Street, NW | Washington | DC | 20037-1305 | |
5418 | 5418 | 2018-04-19 | Embassy of the State of Qatar | 2018-01-23 | QATAR | Tigercomm, LLC 6511 | 2018-01-23 | Tigercomm, LLC | 2555 M Street, NW | Washington | DC | 20037 | |
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 |
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]) );