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 University, San Francisco Office"
This data as json, CSV (advanced)
Registrant_Name 1
- Osaka University, San Francisco 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 |
---|---|---|---|---|---|---|---|---|---|
48765 | 48765 | 2007-05-02 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Tanimoto, Chikaosa | Available-FARA-Public-Office | ||
78391 | 78391 | 2014-07-24 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Kabasawa, Satoshi | https://efile.fara.gov/docs/5631-Short-Form-20140724-12.pdf | ||
87939 | 87939 | 2004-08-16 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Mukai,Hiroshi | Available-FARA-Public-Office | ||
87940 | 87940 | 2004-08-16 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Murooka,Yoshikatsu | Available-FARA-Public-Office | ||
89613 | 89613 | 2006-08-25 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Tsuji, Toshihiko | Available-FARA-Public-Office | ||
110048 | 110048 | 2010-10-20 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Kuboi, Ryoichi | https://efile.fara.gov/docs/5631-Short-Form-20101020-10.pdf | ||
118218 | 118218 | 2007-11-08 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Tanaka, Chie | Available-FARA-Public-Office | ||
122039 | 122039 | 2006-11-27 | Osaka University, San Francisco Office | Osaka University, San Francisco Office 5631 | Short-Form | Ichiki, Tomoko | 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]) );