home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ForeignPrincipals

Table actions
  • GraphQL API for 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

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

Registrant_Name 30

  • 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
  • Empire Consulting Group, Inc. 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
  • Neale Creek, 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
  • Silversmith Law Offices PLLC 1
  • Stonington Strategies, LLC 1
  • ThirdCircle, Inc. 1
  • Tigercomm, LLC 1
  • Venable, LLP 1
  • Waltham PLLC 1

State 3

  • DC 28
  • - 2
  • MD 1

City 3

  • Washington 28
  • - 2
  • Chevy Chase 1

Foreign_Principal 1

  • Embassy of the State of Qatar · 31 ✖

Country/Location_Represented 1

  • QATAR 31
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
212 212   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
213 213   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
214 214   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
215 215   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
216 216   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
217 217   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
218 218   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
219 219   Embassy of the State of Qatar 2019-09-06 QATAR Neale Creek, LLC 6723 2019-09-06 Neale Creek, LLC 11 E. Lenox Street   Chevy Chase MD 20815
220 220   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
221 221   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
222 222   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
1145 1145 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  
2060 2060 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
3759 3759 2022-03-15 Embassy of the State of Qatar 2021-03-22 QATAR Empire Consulting Group, Inc. 6919 2021-01-26 Empire Consulting Group, Inc.          
4055 4055 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
4750 4750 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
4926 4926 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
4927 4927 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
5366 5366 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
7221 7221 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
8680 8680 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
8714 8714 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
10260 10260 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
10585 10585 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
11104 11104 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
12666 12666 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
13345 13345 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
14697 14697 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
16743 16743 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    
16792 16792 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
16818 16818 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

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 · Queries took 109.99ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history