FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
27 rows where Registration_Number = 4220
This data as json, CSV (advanced)
State 1
- CA 12
Registration_Number 1
- Aviso, Inc. · 12 ✖
Registrant_Name 1
- Aviso, Inc. 12
City 1
- Alameda 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]) );