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

13 rows where Foreign_Principal_Country = "JAPAN" and Registrant_Name = "Hogan & Hartson, L.L.P."

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 2

Registrant_Name 1

  • Hogan & Hartson, L.L.P. · 13 ✖

Foreign_Principal_Country 1

  • JAPAN · 13 ✖

Document_Type 1

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
7928 7928 2006-01-27 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20060127-8.pdf
32138 32138 2006-03-30 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20060330-10.pdf
32155 32155 2007-03-30 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20070330-14.pdf
33145 33145 2003-03-31 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20030331-HCTP9803.pdf
33196 33196 2004-03-31 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20040331-HVRKJ903.pdf
33239 33239 2005-03-31 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20050331-IEJ6U804.pdf
41345 41345 2001-04-19 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan, Embassy JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20010419-GLZ99201.pdf
53417 53417 2005-05-20 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20050520-1.pdf
101106 101106 2007-09-28 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20070928-17.pdf
101387 101387 2006-09-29 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20060929-13.pdf
102208 102208 2003-09-30 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20030930-HP8GEO03.pdf
102254 102254 2004-09-30 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20040930-I5JGE205.pdf
102283 102283 2005-09-30 Hogan & Hartson, L.L.P. Hogan Lovells US LLP 2244 Exhibit AB   Government of Japan JAPAN https://efile.fara.gov/docs/2244-Exhibit-AB-20050930-6.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])
);