FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where City = "New York" and Short_Form_First_Name = "Victor"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 12
- Garcia & Diaz 1
- American Section of the Jewish Agency for Israel 1
- Israel Government Tourist Office 1
- Selvage & Lee, Inc. 1
- Druzhinin, Alexander Nikolaevich 1
- Partido Reformista Social Cristiano 1
- Rabinowitz & Boudin 1
- Doremus & Company 1
- Dominican Tourist Information Center, Inc. 1
- Marston Webb & Associates 1
- Department of Culture Tourism - Abu Dhabi (New York Branch) 1
- Media Planning International Corporation 1
Registrant_Name 12
- American Section of the Jewish Agency for Israel 1
- Department of Culture Tourism - Abu Dhabi (New York Branch) 1
- Dominican Tourist Information Center, Inc. 1
- Doremus & Company 1
- Druzhinin, Alexander Nikolaevich 1
- Garcia & Diaz 1
- Israel Government Tourist Office 1
- Marston Webb & Associates 1
- Media Planning International Corporation 1
- Partido Reformista Social Cristiano 1
- Rabinowitz & Boudin 1
- Selvage & Lee, Inc. 1
State 1
- NY 12
City 1
- New York · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6193 | 6193 | 2002-02-05 | 1973-11-20 | Marte | Victor | Partido Reformista Social Cristiano 1687 | 1964-02-05 | Partido Reformista Social Cristiano | 3736 10th Avenue | Suite 9A | New York | NY | 10034 |
11017 | 11017 | 1966-03-29 | 1964-09-24 | Perlo | Victor | Druzhinin, Alexander Nikolaevich 1613 | 1963-04-02 | Druzhinin, Alexander Nikolaevich | 11 Riverside Drive | New York | NY | ||
12137 | 12137 | 2013-03-31 | 2009-07-08 | Webb | Victor | Marston Webb & Associates 5929 | 2009-04-15 | Marston Webb & Associates | 270 Madison Avenue | Suite 1203 | New York | NY | 10010 |
13572 | 13572 | 1992-04-16 | 1980-07-14 | Cabral | Victor | Dominican Tourist Information Center, Inc. 3114 | 1980-06-24 | Dominican Tourist Information Center, Inc. | 485 Madison Avenue | New York | NY | 10022 | |
20765 | 20765 | 1965-06-30 | 1961-05-22 | Bennahum | Victor | Israel Government Tourist Office 620 | 1950-03-27 | Israel Government Tourist Office | 350 Fifth Avenue | New York | NY | 10118 | |
22007 | 22007 | 2022-06-30 | 2021-07-09 | Lopez | Victor | Media Planning International Corporation 6621 | 2018-12-21 | Media Planning International Corporation | c/o Havas Creative Group | 200 Hudson Street | New York | NY | 10013 |
29511 | 29511 | 1968-09-10 | 1964-05-04 | Rabinowitz | Victor | Rabinowitz & Boudin 1734 | 1964-05-04 | Rabinowitz & Boudin | 30 East 42nd Street | New York | NY | 10017 | |
30419 | 30419 | 1964-09-25 | 1961-12-29 | Gold | Victor | Selvage & Lee, Inc. 1454 | 1961-05-29 | Selvage & Lee, Inc. | 500 Fifth Avenue | New York | NY | ||
30507 | 30507 | 1985-09-26 | 1977-03-24 | Gialleonardo | Victor | Doremus & Company 2319 | 1972-02-18 | Doremus & Company | 120 Broadway | New York | NY | 10271 | |
32428 | 32428 | 1946-10-08 | 1942-07-08 | Alvarez | Victor | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | 17 Battery Place | New York | NY | ||
33883 | 33883 | 1971-10-29 | 1948-05-19 | Avrunin | Victor | American Section of the Jewish Agency for Israel 208 | 1943-09-14 | American Section of the Jewish Agency for Israel | 515 Park Avenue | New York | NY | 10022 | |
34117 | 34117 | 2019-10-30 | 2015-10-02 | Rios | Victor | Department of Culture Tourism - Abu Dhabi (New York Branch) 6134 | 2012-09-14 | Department of Culture Tourism - Abu Dhabi (New York Branch) | 40 Exchange Place, Suite 701 | New York | NY | 10005 |
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]) );