FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
9 rows where City = "New York" and Short_Form_First_Name = "Manuel"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5081 | 5081 | 1991-01-31 | 1988-08-09 | Guillen | Manuel | Mexican Tourism Board 1754 | 1964-06-09 | Mexican Tourism Board | 400 Madison Avenue | Suite 11C | New York | NY | 10017 |
25430 | 25430 | 1946-08-01 | 1945-08-01 | Zavala | Manuel | MacVane, John 3121 | 1980-07-03 | MacVane, John | United Nations | Room 368 | New York | NY | 10017 |
26350 | 26350 | 1968-08-10 | 1967-12-12 | Tuma | Manuel | Partido Quisqueyano Democrata 2066 | 1967-12-12 | Partido Quisqueyano Democrata | 56 Fort Washington Avenue | Apartment 65 | New York | NY | 10032 |
32429 | 32429 | 1946-10-08 | 1942-07-08 | Diaz | Manuel | Garcia & Diaz 16 | 1942-07-08 | Garcia & Diaz | 17 Battery Place | New York | NY | ||
33075 | 33075 | 2000-10-17 | 1974-08-01 | Manana | Manuel | Partido de la Liberacion Dominicana, New York 2509 | 1974-04-17 | Partido de la Liberacion Dominicana, New York | P.O. Box 433, Audubon Station | New York | NY | 10032 | |
33076 | 33076 | 2000-10-17 | 1974-08-01 | Vargas | Manuel | Partido de la Liberacion Dominicana, New York 2509 | 1974-04-17 | Partido de la Liberacion Dominicana, New York | P.O. Box 433, Audubon Station | New York | NY | 10032 | |
35945 | 35945 | 1988-11-16 | 1983-04-11 | Lopez | Manuel | Federal Reformist Party 3465 | 1983-04-11 | Federal Reformist Party | 3750 Broadway | Apartment 6 | New York | NY | 10032 |
37705 | 37705 | 2013-12-03 | 2006-07-06 | Gonzalez | Manuel | Cayman Islands Department of Tourism 2500 | 1974-03-04 | Cayman Islands Department of Tourism | 350 5th Avenue | Suite 4620 | New York | NY | 10118-1801 |
39997 | 39997 | 1976-12-31 | 1973-01-24 | Aguilar | Manuel | Mexican Government Ministry of Tourism, New York 1879 | 1965-04-12 | Mexican Government Ministry of Tourism, New York | 630 Fifth Avenue | Suite 351 | New York | NY | 10020 |
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]) );