FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Registration_Number = 1643 and State = "" sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Foreign_Principal_Termination_Date (date), Registrant_Date (date)
Foreign_Principal 7
Foreign_Principal_Registration_Date (date) 6 ✖
- 1987-12-24 2
- 1963-06-25 1
- 1974-05-26 1
- 1989-05-09 1
- 2004-08-25 1
- 2006-02-01 1
State 1
- - · 7 ✖
Registrant_Name 1
Country/Location_Represented 1
- JAPAN 7
City 1
- - 7
Link | rowid | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date ▼ | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
373 | 373 | Japan External Trade Organization | 1963-06-25 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | Tokyo | |||||
3020 | 3020 | 1997-02-28 | Osaka Prefectural Government | 1974-05-26 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | Osaka | ||||
4487 | 4487 | 1990-03-31 | Hyogo Prefectural Government | 1987-12-24 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | Kobe City | ||||
4631 | 4631 | 2004-03-31 | Fukui Prefectural Government | 1987-12-24 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | Fukui City | ||||
4620 | 4620 | 2003-03-31 | KYOTO Prefectural Government | 1989-05-09 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | Kyoto City | ||||
3918 | 3918 | 2015-03-20 | Ishikawa Prefectural Government | 2004-08-25 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 1-1 Kuratsuki, Kanazawa-City Ishikawa-Pref. 920-8580 | ||||
389 | 389 | Kanagawa Prefectural Government | 2006-02-01 | JAPAN | JETRO, New York 1643 | 1963-06-25 | JETRO, New York | 1 Nihon Odori Naka-ku Yokohama-city, Kanagawa-Pref. 231-8588 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );