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

21 rows where City = "San Diego"

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Date, Short_Form_First_Name, Address_1, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

City 1

  • San Diego · 21 ✖
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
2776 2776 1998-01-01 1997-01-24 Clemens Roni Hicks Roni Hicks & Associates, Inc. 5154 1997-01-24 Roni Hicks & Associates, Inc. 1875 Third Avenue   San Diego CA 92101
2777 2777 1998-01-01 1997-01-24 Devries Henry Roni Hicks & Associates, Inc. 5154 1997-01-24 Roni Hicks & Associates, Inc. 1875 Third Avenue   San Diego CA 92101
2778 2778 1998-01-01 1997-01-24 Lentin Jennifer Roni Hicks & Associates, Inc. 5154 1997-01-24 Roni Hicks & Associates, Inc. 1875 Third Avenue   San Diego CA 92101
2779 2779 1998-01-01 1997-01-24 Sullivan Adina Roni Hicks & Associates, Inc. 5154 1997-01-24 Roni Hicks & Associates, Inc. 1875 Third Avenue   San Diego CA 92101
7044 7044 1961-02-16 1960-05-05 Haughton Troy Harold Nationalistic Revolutionary Movement for Liberation, D. Rep. 1330 1960-02-16 Nationalistic Revolutionary Movement for Liberation, D. Rep. 6523 Celia Vista Drive   San Diego CA  
16483 16483 2016-05-15 2016-03-21 Johnson Ashley Southwest Strategies, LLC 6343 2016-03-21 Southwest Strategies, LLC 401 B Street Suite 150 San Diego CA 92101
16484 16484 2016-05-15 2016-03-21 Jones Brandon Southwest Strategies, LLC 6343 2016-03-21 Southwest Strategies, LLC 401 B Street Suite 150 San Diego CA 92101
16485 16485 2016-05-15 2016-03-21 Ziegaus Alan Southwest Strategies, LLC 6343 2016-03-21 Southwest Strategies, LLC 401 B Street Suite 150 San Diego CA 92101
21029 21029 1984-06-30 1965-10-13 Sales Jose Rodrigo Alfaro Mexican Government Tourism Office, San Diego 1866 1965-03-10 Mexican Government Tourism Office, San Diego 600 B Street Suite 1212 San Diego CA 92101
21034 21034 1984-06-30 1972-11-30 Moreno Ramon Jesus Roa Mexican Government Tourism Office, San Diego 1866 1965-03-10 Mexican Government Tourism Office, San Diego 600 B Street Suite 1212 San Diego CA 92101
23318 23318 2017-07-15 2017-05-12 Rodgers James M. Global Strategies Council, Inc. 6410 2017-03-17 Global Strategies Council, Inc. P.O. Box 675805 Rancho Santa Fe San Diego CA 92067
28604 28604 2015-08-31 2015-06-19 Johnson Ashley Southwest Strategies, LLC 6302 2015-06-19 Southwest Strategies, LLC 401 B Street, Suite 150   San Diego CA 92101
28605 28605 2015-08-31 2015-06-19 Jones Brandon Southwest Strategies, LLC 6302 2015-06-19 Southwest Strategies, LLC 401 B Street, Suite 150   San Diego CA 92101
28606 28606 2015-08-31 2015-06-19 Ziegaus Alan Southwest Strategies, LLC 6302 2015-06-19 Southwest Strategies, LLC 401 B Street, Suite 150   San Diego CA 92101
30854 30854 1965-09-30 1965-03-10 Vega Evangelina Chapula Mexican Government Tourism Office, San Diego 1866 1965-03-10 Mexican Government Tourism Office, San Diego 600 B Street Suite 1212 San Diego CA 92101
30904 30904 1972-09-30 1965-03-10 Astudillo Rogelio Gudino Mexican Government Tourism Office, San Diego 1866 1965-03-10 Mexican Government Tourism Office, San Diego 600 B Street Suite 1212 San Diego CA 92101
34112 34112 2017-10-30 2017-03-17 Goudamanis Miltiades Global Strategies Council, Inc. 6410 2017-03-17 Global Strategies Council, Inc. P.O. Box 675805 Rancho Santa Fe San Diego CA 92067
34113 34113 2017-10-30 2017-05-12 Walls Jr. Robert J. Global Strategies Council, Inc. 6410 2017-03-17 Global Strategies Council, Inc. P.O. Box 675805 Rancho Santa Fe San Diego CA 92067
34342 34342 1993-10-31 1993-10-04 Hilliard Carl B. , Jr. Via/Net Companies 4856 1993-10-04 Via/Net Companies 836 East Washington Street   San Diego CA 92103
35469 35469 1973-11-09 1972-11-30 Zarur Esperanza Mexican Government Tourism Office, San Diego 1866 1965-03-10 Mexican Government Tourism Office, San Diego 600 B Street Suite 1212 San Diego CA 92101
40642 40642 1990-12-31 1988-08-25 Holsather Timothy Edgar California Group/Translingua 4172 1988-08-25 California Group/Translingua 2907 Shelter Island Drive Suite 105-275 San Diego CA 92106

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