home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

11 rows where State = "HI"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Address_1, Address_2, Short_Form_Date (date), Registration_Date (date)

Registration_Number 5

  • Korean National Revolutionary Party, Hawaii 4
  • Japan National Tourist Organization, Hawaii 3
  • Leffingwell Associates, Inc. 2
  • Friends of Cuba In Exile 1
  • McClellan Group 1

Registrant_Name 5

  • Korean National Revolutionary Party, Hawaii 4
  • Japan National Tourist Organization, Hawaii 3
  • Leffingwell Associates, Inc. 2
  • Friends of Cuba In Exile 1
  • McClellan Group 1

City 3

  • Honolulu 9
  • Paia, Maui 1
  • Pearl City 1

State 1

  • HI · 11 ✖
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
10431 10431 1983-03-21 1978-11-01 Ohkata Toru Japan National Tourist Organization, Hawaii 2351 1972-07-03 Japan National Tourist Organization, Hawaii 2270 Kalakaua Avenue Suite 1703 Honolulu HI 96815
15785 15785 1964-05-06 1962-11-06 Tavares William Durney Friends of Cuba In Exile 1579 1962-11-06 Friends of Cuba In Exile Post Office Box 6   Paia, Maui HI  
16920 16920 1947-05-23 1944-05-23 Hyun Soon (Tehe Shiang Song) Korean National Revolutionary Party, Hawaii 254 1944-05-23 Korean National Revolutionary Party, Hawaii 1269 South Beretania Street   Honolulu HI  
16921 16921 1947-05-23 1944-05-23 Min Chan Ho Korean National Revolutionary Party, Hawaii 254 1944-05-23 Korean National Revolutionary Party, Hawaii 1269 South Beretania Street   Honolulu HI  
16922 16922 1947-05-23 1944-05-23 Shin Sarah Korean National Revolutionary Party, Hawaii 254 1944-05-23 Korean National Revolutionary Party, Hawaii 1269 South Beretania Street   Honolulu HI  
16923 16923 1947-05-23 1946-08-23 Chun Hyung Koon Korean National Revolutionary Party, Hawaii 254 1944-05-23 Korean National Revolutionary Party, Hawaii 1269 South Beretania Street   Honolulu HI  
25396 25396 2020-07-31 2020-12-16 McClellan William Henry K. McClellan Group 6900 2020-12-16 McClellan Group 2319 Ahamoa Street   Pearl City HI 96782
28088 28088 1985-08-31 1972-07-03 Ikeda Atsushi Japan National Tourist Organization, Hawaii 2351 1972-07-03 Japan National Tourist Organization, Hawaii 2270 Kalakaua Avenue Suite 1703 Honolulu HI 96815
28089 28089 1985-08-31 1983-08-17 Tanaka Isokazu Japan National Tourist Organization, Hawaii 2351 1972-07-03 Japan National Tourist Organization, Hawaii 2270 Kalakaua Avenue Suite 1703 Honolulu HI 96815
30303 30303 1977-09-23 1976-03-23 Leffingwell Roy J. Leffingwell Associates, Inc. 2671 1976-03-23 Leffingwell Associates, Inc. Post Office Box 4034   Honolulu HI  
30304 30304 1977-09-23 1976-03-23 Madden Richard F. Leffingwell Associates, Inc. 2671 1976-03-23 Leffingwell Associates, Inc. Post Office Box 4034   Honolulu HI  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 533.5ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows