FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Document_Type = "Short-Form" and Registrant_Name = "Osaka Prefectual Government, California Office"
This data as json, CSV (advanced)
Registrant_Name 1
- Osaka Prefectual Government, California Office · 8 ✖
Foreign_Principal_Name 1
- - 8
Foreign_Principal_Country 1
- - 8
Document_Type 1
- Short-Form · 8 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
52917 | 52917 | 2000-05-18 | Osaka Prefectual Government, California Office | Osaka Prefectural Government, California Office 5174 | Short-Form | Hara,Shigeo | Available-FARA-Public-Office | ||
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 | ||
56771 | 56771 | 2002-05-31 | Osaka Prefectual Government, California Office | Osaka Prefectural Government, California Office 5174 | Short-Form | Shigetome,Masayo | Available-FARA-Public-Office | ||
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 | ||
129936 | 129936 | 2004-12-09 | Osaka Prefectual Government, California Office | Osaka Prefectural Government, California Office 5174 | Short-Form | Ujiie, Yutaka | Available-FARA-Public-Office |
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]) );