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

38 rows where Registration_Number = 5174

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Name

Foreign_Principal_Country 2

Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
41713 41713 1997-04-21 OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE Osaka Prefectural Government, California Office 5174 Exhibit AB   INTERNATIONAL BUSINESS ORGANIZATION OF OSAKA JAPAN https://efile.fara.gov/docs/5174-Exhibit-AB-19970421-EC8UBI06.pdf
41714 41714 1997-04-21 OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE Osaka Prefectural Government, California Office 5174 Exhibit AB   OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE JAPAN https://efile.fara.gov/docs/5174-Exhibit-AB-19970421-EC8UJP06.pdf
41715 41715 1997-04-21 OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE Osaka Prefectural Government, California Office 5174 Registration Statement       Available-FARA-Public-Office
41716 41716 1997-04-21 OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE Osaka Prefectural Government, California Office 5174 Short-Form NARUMI FUJIMURA     Available-FARA-Public-Office
44501 44501 1998-04-30 OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-19980430-EUT7VA04.pdf
44556 44556 1999-04-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-19990430-FGXHQI01.pdf
44610 44610 2000-04-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20000430-GCZFNE02.pdf
44659 44659 2001-04-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20010430-GOJT4K01.pdf
44706 44706 2002-04-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20020430-H9QM2U01.pdf
44754 44754 2003-04-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20030430-HFYLDE04.pdf
44795 44795 2004-04-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20040430-HYFRE501.pdf
52917 52917 2000-05-18 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Hara,Shigeo     Available-FARA-Public-Office
55180 55180 2008-05-27 Osaka Prefectural Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20080527-7.pdf
55758 55758 2003-05-29 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Eino,Masao     Available-FARA-Public-Office
56090 56090 2006-05-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Ninomiya, Yoshinori     Available-FARA-Public-Office
56091 56091 2006-05-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20060530-3.pdf
56771 56771 2002-05-31 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Shigetome,Masayo     Available-FARA-Public-Office
66259 66259 2007-06-20 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20070620-5.pdf
79152 79152 2005-07-27 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20050727-1.pdf
84480 84480 2003-08-01 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Chao,Sidney C.     Available-FARA-Public-Office
84481 84481 2003-08-01 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Kaneshima,Hideto     Available-FARA-Public-Office
98166 98166 2003-09-16 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Mitani,Hideki     Available-FARA-Public-Office
113138 113138 1997-10-31 OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-19971031-EMW6OC03.pdf
113183 113183 1998-10-31 OSAKA PREFECTUAL GOVERNMENT, CALIFORNIA OFFICE Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-19981031-F3NTE301.pdf
113225 113225 1999-10-31 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-19991031-G2XXE901.pdf
113273 113273 2000-10-31 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20001031-GU03D401.pdf
113320 113320 2001-10-31 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20011031-GSO7DR03.pdf
113359 113359 2002-10-31 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20021031-H6K77O02.pdf
113403 113403 2003-10-31 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20031031-HQV9EB03.pdf
113466 113466 2004-10-31 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20041031-I809CK04.pdf
119875 119875 2005-11-16 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20051116-2.pdf
123146 123146 2006-11-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Amendment       https://efile.fara.gov/docs/5174-Amendment-20061130-1.pdf
123147 123147 2006-11-30 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20061130-4.pdf
129936 129936 2004-12-09 Osaka Prefectual Government, California Office Osaka Prefectural Government, California Office 5174 Short-Form Ujiie, Yutaka     Available-FARA-Public-Office
131337 131337 2008-12-16 Osaka Prefectural Government, California Office Osaka Prefectural Government, California Office 5174 Amendment       https://efile.fara.gov/docs/5174-Amendment-20081216-2.pdf
131338 131338 2008-12-16 Osaka Prefectural Government, California Office Osaka Prefectural Government, California Office 5174 Amendment       https://efile.fara.gov/docs/5174-Amendment-20081216-3.pdf
131339 131339 2008-12-16 Osaka Prefectural Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20081216-8.pdf
133550 133550 2007-12-26 Osaka Prefectural Government, California Office Osaka Prefectural Government, California Office 5174 Supplemental Statement       https://efile.fara.gov/docs/5174-Supplemental-Statement-20071226-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])
);