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

23 rows where City = "Austin" and Registration_Number = 5689

✖
✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Last_Name, Short_Form_First_Name, Short_Form_Date (date)

State 1

Registration_Number 1

  • Public Strategies, Inc. · 23 ✖

Registrant_Name 1

City 1

  • Austin · 23 ✖
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
20464 20464 2005-06-28 2005-06-22 Zhong Qingchuan Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25649 25649 2006-08-01 2006-05-17 Martin Jack L. Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25800 25800 2005-08-02 2005-06-22 Eller Jeff Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25801 25801 2005-08-02 2005-06-22 Fues Lisa Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25802 25802 2005-08-02 2005-06-22 Ludke Jr. Robert L. Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25803 25803 2005-08-02 2005-06-22 Palmer Mark Anderson Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25804 25804 2005-08-02 2005-06-22 Propper Steven Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25805 25805 2005-08-02 2005-06-24 Angelo Cliff N. Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25806 25806 2005-08-02 2005-06-24 Bethel Danner Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25807 25807 2005-08-02 2005-06-24 Emery Joe Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25808 25808 2005-08-02 2005-06-24 Goldman Adam Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25809 25809 2005-08-02 2005-06-24 Ianelli David Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25810 25810 2005-08-02 2005-06-24 Johnson Michael Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25811 25811 2005-08-02 2005-06-24 Kelley Rusty Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25812 25812 2005-08-02 2005-06-24 Schaaf Jeanne Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
25813 25813 2005-08-02 2005-06-24 Thomas Travis Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
28945 28945 2006-09-01 2006-05-17 Propper Steven Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
32933 32933 2005-10-15 2005-06-24 Macdonald Catherine Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
41499 41499 2006-12-31 2006-05-17 Eller Jeff Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
41500 41500 2006-12-31 2006-05-17 Hickman Erin Marie Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
41501 41501 2006-12-31 2006-05-17 Levine Adam Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
41502 41502 2006-12-31 2006-05-17 Ludke Robert L. Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701
41503 41503 2006-12-31 2006-05-17 Williams Scott Andrew Public Strategies, Inc. 5689 2005-06-22 Public Strategies, Inc. 98 Jacinto Boulevard Suite 1200 Austin TX 78701

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