FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where City = "Washington" and Registrant_Name = "Okinawa Prefecture DC Office, Inc."
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Date (date)
State 1
- DC 8
Registration_Number 1
Registrant_Name 1
- Okinawa Prefecture DC Office, Inc. · 8 ✖
City 1
- Washington · 8 ✖
Link | rowid ▼ | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
195 | 195 | 2022-01-25 | Tamaki | Katsuya | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 | |
1497 | 1497 | 2022-07-27 | Nakazato | Kazuyuki | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 | |
12259 | 12259 | 2020-03-31 | 2017-05-09 | Unten | Osamu | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 |
12285 | 12285 | 2021-03-31 | 2019-07-07 | Yamashiro | Kenichiro | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 |
12331 | 12331 | 2022-03-31 | 2020-12-28 | Uechi | Satoshi | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 |
16003 | 16003 | 2017-05-09 | 2015-12-23 | Henzan | Hideo | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 |
21891 | 21891 | 2017-06-30 | 2015-12-23 | Yamazato | Eigo | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 |
22738 | 22738 | 2019-07-07 | 2017-05-09 | Aharen | Takao | Okinawa Prefecture DC Office, Inc. 6332 | 2015-12-23 | Okinawa Prefecture DC Office, Inc. | 1101 Connecticut Avenue, NW | Suite 450 | Washington | DC | 20036 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_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]) );