FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
164 rows where Foreign_Principal_Country = "JAPAN" and Foreign_Principal_Name = "Embassy of Japan"
This data as json, CSV (advanced)
These facets timed out: Foreign_Principal_Name
Registrant_Name >30
- Parvin, C. Landon 22
- Akin, Gump, Strauss, Hauer & Feld, LLP 12
- Alignment Government Strategies 10
- Greenfield Law, LLC 10
- Podesta Group, Inc. 9
- Beacon Policy Advisors LLC 7
- Hogan Lovells US LLP 7
- Rasky Baerlein Strategic Communications, Inc. 7
- Daschle Group, LLC 6
- Forbes Tate Partners LLC 6
- Holland & Knight 6
- RSC Services International LLC 5
- Saunders & Company 5
- Sorini, Samet & Associates, LLC 4
- Mercury Public Affairs, LLC/dba Mercury/Clark & Weinstock 3
- Peck Madigan Jones, Inc. 3
- Ballard Partners 2
- Bob, Daniel 2
- Butterfield Carter and Associates 2
- CGCN Group 2
- Cogent Strategies LLC 2
- Comeau & Company LLC 2
- Greenfield & Kress, P.A. 2
- KP Public Affairs, LLC 2
- King & Spalding, LLP 2
- McGuireWoods Consulting, LLC 2
- Patrick,Griffin 2
- Reed, T. Dean 2
- Robert R. Nathan Associates, Inc. 2
- S-3 Group 2
- …
Date_Stamped (date) >30 ✖
- 2020-04-10 3
- 2022-05-05 3
- 2003-09-10 2
- 2005-11-14 2
- 2006-05-30 2
- 2006-11-15 2
- 2008-11-17 2
- 2014-06-26 2
- 2016-08-25 2
- 2018-04-17 2
- 2019-05-01 2
- 2020-04-09 2
- 2021-04-15 2
- 2021-04-30 2
- 2021-05-03 2
- 2021-05-10 2
- 2022-05-10 2
- 2023-04-11 2
- 2023-06-29 2
- 1963-07-31 1
- 1963-12-10 1
- 2001-05-08 1
- 2001-09-06 1
- 2002-02-13 1
- 2002-02-19 1
- 2002-09-04 1
- 2003-04-08 1
- 2003-11-12 1
- 2004-05-01 1
- 2004-09-10 1
- …
Document_Type 2
Foreign_Principal_Country 1
- JAPAN · 164 ✖
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );