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

29 rows where City = "Washington", Foreign_Principal = "Embassy of Japan" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Foreign_Principal 1

  • Embassy of Japan · 29 ✖

Country/Location_Represented 1

City 1

  • Washington · 29 ✖
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
160 160   Embassy of Japan 2018-02-10 JAPAN Forbes Tate Partners LLC 6522 2018-02-10 Forbes Tate Partners LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
161 161   Embassy of Japan 2011-03-02 JAPAN Akin, Gump, Strauss, Hauer & Feld, LLP 3492 1983-06-24 Akin, Gump, Strauss, Hauer & Feld, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
162 162   Embassy of Japan 2019-04-09 JAPAN Beacon Policy Advisors LLC 6658 2019-04-09 Beacon Policy Advisors LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
163 163   Embassy of Japan 2020-04-10 JAPAN Patrick,Griffin 6815 2020-04-10 Patrick,Griffin 2520 Massachusetts Avenue, NW   Washington DC 20008
164 164   Embassy of Japan 2020-04-10 JAPAN Tiber Creek Group, Inc. 6816 2020-04-10 Tiber Creek Group, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
165 165   Embassy of Japan 2023-04-14 JAPAN Ballard Partners 7070 2022-01-13 Ballard Partners 2520 Massachusetts Ave, NW   Washington DC 20008
166 166   Embassy of Japan 2015-04-16 JAPAN Daschle Group, LLC 6280 2015-03-16 Daschle Group, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
168 168   Embassy of Japan 2023-04-21 JAPAN theGroup DC, LLC 6388 2016-10-28 theGroup DC, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
170 170   Embassy of Japan 2017-04-26 JAPAN S-3 Group 6422 2017-04-26 S-3 Group 2520 Massachusetts Avenue, NW   Washington DC 20008
171 171   Embassy of Japan 2015-05-08 JAPAN Holland & Knight 3718 1985-08-07 Holland & Knight 2520 Massachusetts Avenue, NW   Washington DC 20008
172 172   Embassy of Japan 2015-05-16 JAPAN Greenfield Law, LLC 6294 2015-05-16 Greenfield Law, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
173 173   Embassy of Japan 2018-05-18 JAPAN RSC Services International LLC 6554 2018-05-18 RSC Services International LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
174 174   Embassy of Japan 2015-09-18 JAPAN Alignment Government Strategies 6317 2015-09-18 Alignment Government Strategies 2520 Massachusetts Avenue, NW   Washington DC 20008
175 175   Embassy of Japan 2013-11-08 JAPAN Parvin, C. Landon 6194 2013-11-08 Parvin, C. Landon 2520 Massachusetts Avenue, NW   Washington DC  
3141 3141 2021-02-28 Embassy of Japan 2020-08-04 JAPAN Seven Letter 6847 2020-08-04 Seven Letter 2520 Massachusetts Avenue, NW   Washington DC 20008
4683 4683 2008-03-31 Embassy of Japan 2007-02-23 JAPAN Bob, Daniel 5794 2007-02-23 Bob, Daniel 2520 Massachusetts Avenue, NW   Washington DC 20008
4755 4755 2016-03-31 Embassy of Japan 2015-09-25 JAPAN King & Spalding, LLP 6307 2015-07-24 King & Spalding, LLP 2520 Massachusetts Avenue, NW   Washington DC 20008
4771 4771 2018-03-31 Embassy of Japan 2016-07-22 JAPAN Mercury Public Affairs, LLC 6170 2013-05-14 Mercury Public Affairs, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
4772 4772 2018-03-31 Embassy of Japan 2017-12-21 JAPAN Cogent Strategies LLC 6502 2017-12-21 Cogent Strategies LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
4778 4778 2019-03-31 Embassy of Japan 2012-04-25 JAPAN Friedlander Group 6097 2012-04-25 Friedlander Group 2520 Massachusetts Avenue, NW   Washington DC 20008
4803 4803 2021-03-31 Embassy of Japan 2015-05-19 JAPAN McGuireWoods Consulting, LLC 6295 2015-05-19 McGuireWoods Consulting, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
5316 5316 2016-04-15 Embassy of Japan 2013-05-05 JAPAN Reed, T. Dean 5044 1995-09-13 Reed, T. Dean 2520 Massachusetts Avenue, NW   Washington DC 20008
11152 11152 2015-08-31 Embassy of Japan 2015-06-19 JAPAN Southwest Strategies, LLC 6302 2015-06-19 Southwest Strategies, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
11445 11445 2017-09-08 Embassy of Japan 2014-06-26 JAPAN Rasky Baerlein Strategic Communications, Inc. 6222 2014-05-16 Rasky Baerlein Strategic Communications, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
12280 12280 2022-09-30 Embassy of Japan 2017-04-12 JAPAN CGCN Group 6396 2016-11-30 CGCN Group 2520 Massachusetts Avenue, NW   Washington DC 20008
12403 12403 2007-10-01 Embassy of Japan 2007-08-31 JAPAN Advocacy Group 5826 2007-08-31 Advocacy Group 2520 Massachusetts Avenue, NW   Washington DC 20008
14565 14565 2017-11-30 Embassy of Japan 2009-09-16 JAPAN Podesta Group, Inc. 5926 2009-04-01 Podesta Group, Inc. 2520 Massachusetts Avenue, NW   Washington DC 20008
14587 14587 2020-11-30 Embassy of Japan 2014-05-21 JAPAN Sorini, Samet & Associates, LLC 5839 2007-11-12 Sorini, Samet & Associates, LLC 2520 Massachusetts Avenue, NW   Washington DC 20008
16617 16617 2007-12-31 Embassy of Japan 2007-12-18 JAPAN Goldman, Betsy M. 5857 2007-12-18 Goldman, Betsy M. 2520 Massachusetts Avenue, NW   Washington DC 20008

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