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

16 rows where City = "Sunnyvale"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Last_Name, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date)

Registration_Number 6

  • San Francisco Off. of Korea Institute of Machinery & Metals 4
  • Fukuoka Center for Overseas Commerce in America 4
  • Welsh Development International 3
  • Mathews & Clark Communications, Inc. 2
  • Mathews & Clark Communications 2
  • Enterprise Estonia in San Jose 1

Registrant_Name 6

  • Fukuoka Center for Overseas Commerce in America 4
  • San Francisco Off. of Korea Institute of Machinery & Metals 4
  • Welsh Development International 3
  • Mathews & Clark Communications 2
  • Mathews & Clark Communications, Inc. 2
  • Enterprise Estonia in San Jose 1

State 1

  • CA 16

City 1

  • Sunnyvale · 16 ✖
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
4773 4773 2016-01-29 2006-08-15 Musteric Marc J. Fukuoka Center for Overseas Commerce in America 5591 2003-12-02 Fukuoka Center for Overseas Commerce in America 440 N. Wolfe Rd.   Sunnyvale CA 94085
10632 10632 2006-03-23 2003-12-02 Sata Masahiko Fukuoka Center for Overseas Commerce in America 5591 2003-12-02 Fukuoka Center for Overseas Commerce in America 440 N. Wolfe Rd.   Sunnyvale CA 94085
12068 12068 2010-03-31 2006-04-12 Takenami Kenjiro Fukuoka Center for Overseas Commerce in America 5591 2003-12-02 Fukuoka Center for Overseas Commerce in America 440 N. Wolfe Rd.   Sunnyvale CA 94085
12138 12138 2013-03-31 2011-07-28 Nakaya Ryuzo Fukuoka Center for Overseas Commerce in America 5591 2003-12-02 Fukuoka Center for Overseas Commerce in America 440 N. Wolfe Rd.   Sunnyvale CA 94085
15209 15209 2020-04-30 2007-10-26 Viirg Andrus Enterprise Estonia in San Jose 5833 2007-10-26 Enterprise Estonia in San Jose 440 North Wolfe Road   Sunnyvale CA 94085
15388 15388 1988-05-01 1986-02-27 Sutcliffe Charles H. Welsh Development International 3671 1985-04-15 Welsh Development International 710 Lakeway Suite 170 Sunnyvale CA 94086-4013
15823 15823 1996-05-06 1992-05-01 Deutsch Ronald I. Mathews & Clark Communications 4659 1992-05-01 Mathews & Clark Communications 710 Lakeway Drive Suite 170 Sunnyvale CA 94086-4013
17438 17438 1985-05-30 1976-04-22 O'Neill Robert S. San Francisco Off. of Korea Institute of Machinery & Metals 2685 1976-04-22 San Francisco Off. of Korea Institute of Machinery & Metals 355 West Olive Avenue Suite 215 Sunnyvale CA 94086
17439 17439 1985-05-30 1984-05-30 Lee Jong Buhm San Francisco Off. of Korea Institute of Machinery & Metals 2685 1976-04-22 San Francisco Off. of Korea Institute of Machinery & Metals 355 West Olive Avenue Suite 215 Sunnyvale CA 94086
17441 17441 1985-05-30 1980-11-25 Lee Eun Kwi San Francisco Off. of Korea Institute of Machinery & Metals 2685 1976-04-22 San Francisco Off. of Korea Institute of Machinery & Metals 355 West Olive Avenue Suite 215 Sunnyvale CA 94086
28013 28013 1980-08-31 1976-04-22 Kim Ki Yong San Francisco Off. of Korea Institute of Machinery & Metals 2685 1976-04-22 San Francisco Off. of Korea Institute of Machinery & Metals 355 West Olive Avenue Suite 215 Sunnyvale CA 94086
35712 35712 1990-11-13 1984-01-23 Clark Joseph W. Mathews & Clark Communications, Inc. 3554 1984-01-23 Mathews & Clark Communications, Inc. 710 Lakeway Suite 170 Sunnyvale CA 94086-4013
35713 35713 1990-11-13 1984-01-23 Mathews Walter H. Mathews & Clark Communications, Inc. 3554 1984-01-23 Mathews & Clark Communications, Inc. 710 Lakeway Suite 170 Sunnyvale CA 94086-4013
38511 38511 1994-12-16 1992-05-01 Rigoli Thomas P. Mathews & Clark Communications 4659 1992-05-01 Mathews & Clark Communications 710 Lakeway Drive Suite 170 Sunnyvale CA 94086-4013
38741 38741 1989-12-19 1988-05-12 Lewis Paul L. Welsh Development International 3671 1985-04-15 Welsh Development International 710 Lakeway Suite 170 Sunnyvale CA 94086-4013
38743 38743 1989-12-19 1985-12-30 Francis Colin E. Welsh Development International 3671 1985-04-15 Welsh Development International 710 Lakeway Suite 170 Sunnyvale CA 94086-4013

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