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

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

View and edit SQL

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

State

City

Foreign_Principal

  • Embassy of the State of Qatar · 19

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
197   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
198   Embassy of the State of Qatar 2019-01-09 QATAR 6627 6627 2019-01-09 PAVEA, LLC 2555 M Street, NW   Washington DC 20037
199   Embassy of the State of Qatar 2019-01-22 QATAR 6540 6540 2018-04-13 ThirdCircle, Inc. 2555 M Street, NW   Washington DC 20037
200   Embassy of the State of Qatar 2018-02-05 QATAR 5931 5931 2009-04-17 Venable, LLP 2555 M Street, NW   Washington DC 20037
201   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
202   Embassy of the State of Qatar 2018-04-02 QATAR 6415 6415 2017-04-05 Ballard Partners 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 2017-07-24 QATAR 6446 6446 2017-07-24 Avenue Strategies Global, LLC 2555 M Street, NW   Washington DC 20037-1305
205   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
206   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
207   Embassy of the State of Qatar 2019-12-17 QATAR 6771 6771 2019-12-17 Waltham PLLC 2555 M Street, NW   Washington DC 20037
208   Embassy of the State of Qatar 2019-12-30 QATAR 6777 6777 2019-12-30 Biggs, Allison 2555 M Street, NW   Washington DC 20037
1095 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  
5121 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
6907 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
8320 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
10139 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
12769 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
16068 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 140.286ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history