FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

17 rows where "Short_Form_Date" is on date 1990-09-11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_2

State 2

City 2

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
7983 7983 1991-02-28 1990-09-11 Clemente Charles C. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
8115 8115 2000-02-28 1990-09-11 Chang Lily Chun-Yen China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation 1500 Broadway Suite 2800 New York NY 10036
8823 8823 2001-03-01 1990-09-11 Tse Karen C. China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation 1500 Broadway Suite 2800 New York NY 10036
9979 9979 1998-03-15 1990-09-11 Strout Andrea Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
10238 10238 1991-03-18 1990-09-11 Martinson Verla Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
13330 13330 1995-04-14 1990-09-11 Willett Deborah L. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
14813 14813 1999-04-30 1990-09-11 Wiley Roy Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
19159 19159 1990-06-10 1990-09-11 Sparks John K. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
21341 21341 1999-06-30 1990-09-11 Hui Chen China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation 1500 Broadway Suite 2800 New York NY 10036
21342 21342 1999-06-30 1990-09-11 Xiaobei Zhang China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation 1500 Broadway Suite 2800 New York NY 10036
26386 26386 1992-08-10 1990-09-11 O'Rourke Mary Ann Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
30160 30160 2006-09-20 1990-09-11 Hom Jin-Get China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation 1500 Broadway Suite 2800 New York NY 10036
33217 33217 2011-10-19 1990-09-11 Yinghuang Zhu China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation 1500 Broadway Suite 2800 New York NY 10036
35596 35596 2003-11-10 1990-09-11 Austin Marcia S. Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
37428 37428 1991-12-01 1990-09-11 Levi Wendy Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
37429 37429 1991-12-01 1990-09-11 Welch Louie Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC 1111 19th Street NW 3rd Floor Washington DC 20036
41513 41513 2006-12-31 1990-09-11 Wong Lap-Jong China Daily Distribution Corporation 3457 1983-04-19 China Daily Distribution Corporation 1500 Broadway Suite 2800 New York NY 10036

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])
);