FARA_All_Registrants

List of all registrant data (active and terminated)

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

9 rows where State = "HI"

View and edit SQL

Suggested facets: Address_2, Zip, Registration_Date (date), Termination_Date (date)

State

Registration_Number Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
109 1942-08-28 1945-03-25 De Bisschop, Eric   158 Dowsett Avenue   Honolulu HI  
254 1944-05-23 1947-05-23 Korean National Revolutionary Party, Hawaii   1269 South Beretania Street   Honolulu HI  
814 1954-02-10 1971-06-21 Phillips, Wendell   2222 Kalakaua Avenue Suite 1409 Honolulu HI 96815
1579 1962-11-06 1964-05-06 Friends of Cuba In Exile   Post Office Box 6   Paia, Maui HI  
1581 1962-11-14 1969-06-24 Dawson, Donald Roy   Post Office Box 2092   Honolulu HI 96805
2151 1969-07-11 1969-07-30 Curtis, Claude H.   Post Office Box 1029   Wahiawa HI  
2351 1972-07-03 1985-08-31 Japan National Tourist Organization, Hawaii   2270 Kalakaua Avenue Suite 1703 Honolulu HI 96815
2671 1976-03-23 1977-09-23 Leffingwell Associates, Inc.   Post Office Box 4034   Honolulu HI  
4056 1987-11-12 1990-05-15 Van Dyke, Jon M.   2515 Dole Street   Honolulu HI 96822

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_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 · Query took 35.585ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history