FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

23 rows where Foreign_Principal = "Embassy of the State of Qatar"

View and edit SQL

Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State

City

Foreign_Principal

  • Embassy of the State of Qatar · 23

Country/Location_Represented

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
196   Embassy of the State of Qatar 2019-01-22 QATAR 6540 6540 2018-04-13 ThirdCircle, Inc. 2555 M Street, NW   Washington DC 20037
197   Embassy of the State of Qatar 2018-02-05 QATAR 5931 5931 2009-04-17 Venable, LLP 2555 M Street, NW   Washington DC 20037
198   Embassy of the State of Qatar 2020-03-20 QATAR 6804 6804 2020-03-20 Bridge Builder Communications 2555 M St NW   Washington DC 20037
199   Embassy of the State of Qatar 2020-03-26 QATAR 6415 6415 2017-04-05 Ballard Partners 601 Thirteenth Street NW Suit 450 Washington DC 20005
200   Embassy of the State of Qatar 2018-03-29 QATAR 6537 6537 2018-03-29 Lumen8 Advisors, LLC 2555 M Street, NW   Washington DC 20037
201   Embassy of the State of Qatar 2020-04-07 QATAR 4990 4990 1995-02-06 JWI, LLC 2555 M St., NW   Washington DC 20037
202   Embassy of the State of Qatar 2020-05-08 QATAR 6822 6822 2020-05-08 Proof Strategies Inc. 2555 M Street, NW   Washington DC 20037
203   Embassy of the State of Qatar 2018-06-22 QATAR 5044 5044 1995-09-13 Reed, T. Dean 2555 M Street, NW   Washington DC 20037
204   Embassy of the State of Qatar 2019-09-06 QATAR 6723 6723 2019-09-06 Neale Creek, LLC 2555 M Street, NW   Washington DC 20037
205   Embassy of the State of Qatar 2019-12-10 QATAR 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2555 M Street NW   Washington DC 20037
206   Embassy of the State of Qatar 2019-12-17 QATAR 6771 6771 2019-12-17 Waltham PLLC 2555 M Street, NW   Washington DC 20037
207   Embassy of the State of Qatar 2019-12-30 QATAR 6777 6777 2019-12-30 Lexington Avenue Consulting 2555 M Street, NW   Washington DC 20037
1082 2006-01-09 Embassy of the State of Qatar 2002-11-19 QATAR 5531 5531 2002-11-19 Rahall Consulting Group 4200 Wisconsin Avenue, N.W. Suite 200 20016     DC  
3883 2020-03-27 Embassy of the State of Qatar 2016-07-27 QATAR 6277 6277 2015-02-12 Gallagher Group, LLC 2555 M Street, NW   Washington DC 20037
4727 2020-04-01 Embassy of the State of Qatar 2017-07-24 QATAR 6446 6446 2017-07-24 Avenue Strategies Global, LLC 2555 M Street, NW   Washington DC 20037-1305
5150 2018-04-19 Embassy of the State of Qatar 2018-01-23 QATAR 6511 6511 2018-01-23 Tigercomm, LLC 2555 M Street, NW   Washington DC 20037
6948 2018-05-31 Embassy of the State of Qatar 2017-06-29 QATAR 6442 6442 2017-06-29 Information Management Services, Inc. 2555 M Street, NW   Washington DC 20037
8369 2017-06-30 Embassy of the State of Qatar 2015-01-15 QATAR 6064 6064 2011-09-19 Portland PR Inc. 2555 M Street, NW   Washington DC 20037
10210 2018-08-21 Embassy of the State of Qatar 2017-09-03 QATAR 6458 6458 2017-09-03 Stonington Strategies, LLC 2555 M Street, NW   Washington DC 20037
10719 2019-08-31 Embassy of the State of Qatar 2019-01-09 QATAR 6627 6627 2019-01-09 PAVEA, LLC 2555 M Street, NW   Washington DC 20037
12191 2019-10-15 Embassy of the State of Qatar 2015-01-02 QATAR 6170 6170 2013-05-14 Mercury Public Affairs, LLC 2555 M Street, NW   Washington DC 20037
12855 2005-10-31 Embassy of the State of Qatar 2005-10-31 QATAR 5718 5718 2005-10-31 Collier Shannon Scott, PLLC 2555 M Street, NW   Washington DC 20037
16177 2018-12-31 Embassy of the State of Qatar 2018-10-03 QATAR 6597 6597 2018-10-03 Silversmith Law Offices PLLC 255 M Street NW   Washington    

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);
Powered by Datasette · Query took 144.252ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history