FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

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

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 · 24 ✖

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
191 191   Embassy of the State of Qatar 2019-01-22 QATAR 6540 6540 2018-04-13 ThirdCircle, Inc. 2555 M Street, NW   Washington DC 20037
192 192   Embassy of the State of Qatar 2018-02-05 QATAR 5931 5931 2009-04-17 Venable, LLP 2555 M Street, NW   Washington DC 20037
193 193   Embassy of the State of Qatar 2021-02-09 QATAR 6924 6924 2021-02-09 Ogilvy Government Relations 2555 M Street, NW   Washington DC 20037
194 194   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
195 195   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
196 196   Embassy of the State of Qatar 2018-04-02 QATAR 6415 6415 2017-04-05 Ballard Partners 601 Thirteenth Street NW Suit 450 Washington DC 20005
197 197   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
198 198   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
199 199   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
200 200   Embassy of the State of Qatar 2019-12-17 QATAR 6771 6771 2019-12-17 Waltham PLLC 2555 M Street, NW   Washington DC 20037
1064 1064 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  
3887 3887 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
4579 4579 2020-03-31 Embassy of the State of Qatar 2020-04-07 QATAR 4990 4990 1995-02-06 JWI, LLC 2555 M St., NW   Washington DC 20037
4733 4733 2020-04-01 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
4734 4734 2020-04-01 Embassy of the State of Qatar 2017-07-24 QATAR 6446 6446 2017-07-24 Avenue Strategies, LLC 2555 M Street, NW   Washington DC 20037-1305
5162 5162 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
6968 6968 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
8395 8395 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
10248 10248 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
10758 10758 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
12255 12255 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
12924 12924 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
16264 16264 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    
16308 16308 2020-12-31 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

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)
);