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

22 rows where Registration_Number = 2347

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

  • IL 22

Registration_Number 1

  • Japan National Tourist Organization, Chicago · 22 ✖

Registrant_Name 1

  • Japan National Tourist Organization, Chicago 22

City 1

  • Chicago 22
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
7699 7699 1985-02-26 1982-11-15 Ebisawa Yo Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
8742 8742 1982-03-01 1979-09-24 Abe Tsunehiko Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
16123 16123 1989-05-12 1985-08-26 Yamaguchi Mitsuo Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
16191 16191 1976-05-13 1975-09-24 Ajiro Norimasa Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
16593 16593 1985-05-17 1981-05-15 Sato Hiroyasu Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
16694 16694 1992-05-19 1989-07-25 Miyazaki Yoshihiro Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
16868 16868 1973-05-22 1972-07-03 Takata Shinya Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
17194 17194 1995-05-26 1992-08-14 Morimoto Masayuki Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
17240 17240 1998-05-27 1995-07-27 Tanimoto Atsunori Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
19551 19551 1988-06-15 1985-08-26 Yamanouchi Tamotsu Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
20460 20460 2003-06-28 2002-02-05 Fujiwara Iichiro Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
24091 24091 1993-07-26 1988-08-05 Sato Tetsuya Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
24092 24092 1993-07-26 1992-08-14 Oyama Naoyuki Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
24220 24220 2001-07-27 1999-02-04 Iwatsuki Masahiro Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
25015 25015 2003-07-31 2001-02-02 Tsukamoto Yasutake Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
25605 25605 1994-08-01 1993-05-19 Ruzbasan Debra Ann Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
25607 25607 1994-08-01 1993-07-26 Nakazono Masato Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
31816 31816 1972-10-01 1972-07-03 Sakurada Kaoru Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
33026 33026 2000-10-16 1997-04-01 Nagaoka Takashi Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
34182 34182 1976-10-31 1973-02-08 Sato Tetsuya Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
37800 37800 1996-12-05 1993-07-26 Sawada Toshihiko Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611
37867 37867 1980-12-07 1977-07-13 Okada Toyokazu Japan National Tourist Organization, Chicago 2347 1972-07-03 Japan National Tourist Organization, Chicago 401 North Michigan Avenue Suite 770 Chicago IL 60611

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 293.773ms · 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