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

27 rows where Registration_Number = 4220 and State = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

Registration_Number 1

  • Aviso, Inc. · 27 ✖

Registrant_Name 1

City 1

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
5115 5115 1992-01-31 1991-10-09 Youngberg Jon Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
8013 8013 1995-02-28 1989-02-22 Bendel Margaret Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
8014 8014 1995-02-28 1989-02-22 Hamilton Irvin C. , Jr. Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
8015 8015 1995-02-28 1989-02-22 Perkins Barbara Pacini Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
8041 8041 1995-02-28 1992-10-13 Gardiner Lyn Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
8042 8042 1995-02-28 1990-10-15 Lee Patricia Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
9973 9973 1994-03-15 1993-10-01 III Kenneth High Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
11621 11621 1990-03-31 1989-02-22 Walker Patricia Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
14279 14279 1995-04-28 1990-10-15 Repose Michelle Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
19974 19974 1991-06-21 1989-02-22 Gribble Tamese Gaye Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
21133 21133 1990-06-30 1989-02-22 Hazard Dana S. Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
22848 22848 1993-07-09 1989-02-22 Ruppel George Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
22850 22850 1993-07-09 1992-10-13 Collins Steve Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
23276 23276 1994-07-15 1990-10-15 Black Ann Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
24377 24377 1994-07-29 1993-07-09 Martinez Carol Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
29023 29023 1988-09-02 1989-02-22 Whitfield Linda Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
31929 31929 1993-10-01 1991-03-28 McGuire Janet Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
31935 31935 1993-10-01 1992-10-13 Moyer Louise Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
32734 32734 1992-10-13 1992-04-08 Basinet Barbara Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
32735 32735 1992-10-13 1992-04-08 Epnett Laura K. Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
32736 32736 1992-10-13 1992-04-08 Patino Raul , Jr. Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
32739 32739 1992-10-13 1991-10-09 Parten Jill Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
32740 32740 1992-10-13 1990-10-15 Litchfield Mary Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
34343 34343 1994-10-31 1989-02-22 Jordan Chermerdene Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
38870 38870 1990-12-21 1990-10-15 Schiffer Ginger Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
40460 40460 1988-12-31 1989-02-22 Spear Robin Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501
40771 40771 1994-12-31 1989-02-22 Lowery Joan Aviso, Inc. 4220 1989-02-22 Aviso, Inc. 1150 Marina Village Parkway Suite 104 Alameda CA 94501

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