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

58 rows where Registration_Number = 2110

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Registrant_Name

State 1

  • CA 58

Registration_Number 1

  • Hong Kong Tourism Board · 58 ✖

City 1

  • Los Angeles 58
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
1621 1621   2006-08-17 Gomm Anne Fabry Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
1622 1622   2006-08-17 Lavalle James Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
2224 2224   2009-11-24 Flora William B. Jr. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
3198 3198 2007-01-04 2006-08-17 Willus Amy Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
3809 3809 1999-01-15 1988-09-20 Bakht Mary Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
3810 3810 1999-01-15 1988-09-20 Testa Mary Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
4203 4203 1980-01-21 1977-07-28 Clewis John Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
4391 4391 1988-01-25 1981-12-02 Sather Richard W. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
4805 4805 1973-01-30 1970-06-23 Trump Charles Michael John Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
5002 5002 1985-01-31 1974-08-04 O'Donnell John Gerard Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
6425 6425 2008-02-08 2007-06-29 Okada Yuko Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
7479 7479 1996-02-23 1989-07-07 Nakasone Stephanie Carol Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
8092 8092 1998-02-28 1996-08-05 Lambert Kenneth Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
8181 8181 2005-02-28 1990-05-30 Chang Michael G. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
10475 10475 2004-03-21 1998-06-09 Chan Aliana M. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
11491 11491 1979-03-31 1978-12-04 Keeping Michael J. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
11558 11558 1987-03-31 1986-02-20 Tiedemann Edwin W. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
11738 11738 1996-03-31 1979-03-29 Ossmo Torre O. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
11853 11853 2001-03-31 1988-01-11 Bryant Barbara J. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
13645 13645 1996-04-17 1995-09-13 Tsai Francis F. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
14329 14329 1973-04-29 1971-07-07 Tann Richard Arnold Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
14332 14332 1982-04-29 1980-01-21 Tiedemann Edwin W. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
14502 14502 1975-04-30 1969-03-06 Connelly Terrence M. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
14824 14824 2000-04-30 1997-05-15 Kurko Crystal J. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
17014 17014 1989-05-24 1981-01-27 Tavares Carolyn E. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
17348 17348 1991-05-29 1987-06-03 West Thomas A. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
17349 17349 1991-05-29 1982-06-28 Dalton Jeanne Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
17352 17352 1991-05-29 1975-12-08 Leonard James Richard Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
17649 17649 1978-05-31 1969-07-01 Sullivan John Edward Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
17848 17848 1995-05-31 1973-09-04 Remedios Catherine Leonora d'Almada Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
17981 17981 2005-05-31 1999-03-08 Shum Lily Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
18626 18626 1971-06-02 1968-10-29 Lo Lorenzo Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
18672 18672 2000-06-02 1988-04-27 Macaluso Louis D. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
19448 19448 1999-06-14 1986-06-03 Barrett Mark E. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
23138 23138 2010-07-14 1999-03-22 Bishop Lillibeth Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
23402 23402 1971-07-17 1969-05-19 Haley Joseph W. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
24699 24699 1978-07-31 1975-12-08 Mason Robert F. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
24759 24759 1987-07-31 1976-12-09 Hollands Frederick William Clements Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
24886 24886 1997-07-31 1986-01-17 Haymaker Richard Allen Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
25977 25977 1985-08-05 1984-11-26 Hays David William Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
26820 26820 1975-08-16 1971-09-08 Reynolds Robert Frances Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
27361 27361 2007-08-24 2006-08-17 Cooper Chip Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
28347 28347 1999-08-31 1971-07-07 McGee Michael Curtis Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
29523 29523 1985-09-10 1977-12-05 Fung Henry C. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
29952 29952 1990-09-16 1989-07-03 Garza M. Theresa Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
30941 30941 1981-09-30 1979-01-04 Di Marco Vince Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
31061 31061 1990-09-30 1988-09-08 Lester Mary Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
31172 31172 1997-09-30 1982-09-13 Russell James F. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
31298 31298 2002-09-30 1996-05-31 Smits Kathryn Nedelman Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
31913 31913 1990-10-01 1988-04-27 Lester Mary A. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
34079 34079 1996-10-30 1990-05-30 Hewett Susan Lynn Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
34417 34417 1998-10-31 1997-09-30 Deegan Tim Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
37282 37282 1970-12-01 1969-05-19 Dougherty Joseph A. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
38380 38380 1981-12-15 1973-02-15 Kertz Robert A. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
39097 39097 2007-12-24 2007-12-28 Silvermintz William Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
39891 39891 1970-12-31 1970-12-09 Eagle Sandra A. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
40521 40521 1988-12-31 1988-09-08 Foley Margaret Ann Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
41068 41068 1998-12-31 1970-01-06 Fu Terence J. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045

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