FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

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

14 rows where Foreign_Principal_Country = "JAPAN", Foreign_Principal_Name = "Government of Japan" and Registrant_Name = "Hogan Lovells US LLP"

✎ View and edit SQL

This data as json, CSV (advanced)

Registrant_Name 1

  • Hogan Lovells US LLP · 14 ✖

Foreign_Principal_Name 1

  • Government of Japan · 14 ✖

Foreign_Principal_Country 1

  • JAPAN · 14 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
15680 15680 2011-02-11 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20110211-29.pdf
32200 32200 2009-03-30 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20090330-23.pdf
38236 38236 2017-04-06 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20170406-76.pdf
42025 42025 2011-04-22 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20110422-32.pdf
49281 49281 2010-05-04 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20100504-28.pdf
50087 50087 2012-05-07 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20120507-39.pdf
51942 51942 2015-05-14 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20150514-59.pdf
53434 53434 2013-05-20 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20130520-48.pdf
53459 53459 2016-05-20 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20160520-74.pdf
64393 64393 2018-06-11 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20180611-81.pdf
67666 67666 2014-06-26 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20140626-56.pdf
77697 77697 2009-07-21 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20090721-25.pdf
102346 102346 2008-09-30 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20080930-21.pdf
102396 102396 2009-09-30 Hogan Lovells US LLP Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20090930-27.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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