FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
11 rows where "Short_Form_Date" is on date 1959-09-04
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Short_Form_Date (date)
Registration_Number 4
Registrant_Name 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9082 | 9082 | 1960-03-04 | 1959-09-04 | Adams | Andrew D. | Brennan, Earl 1265 | 1959-09-04 | Brennan, Earl | Brock Electric Company | 648 Kenmore Boulevard | Akron | OH | |
22572 | 22572 | 1961-07-05 | 1959-09-04 | Espinal | Miguel | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
22573 | 22573 | 1961-07-05 | 1959-09-04 | Gonzalez | Matos U. | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
22574 | 22574 | 1961-07-05 | 1959-09-04 | Hernandez | Jose A. | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
22575 | 22575 | 1961-07-05 | 1959-09-04 | Lambloglia | Juana Yolanda | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
22576 | 22576 | 1961-07-05 | 1959-09-04 | Maceo | Gaston Espinal | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
22577 | 22577 | 1961-07-05 | 1959-09-04 | Simo | Hilda | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
22578 | 22578 | 1961-07-05 | 1959-09-04 | Trujillo | Carmen | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
37263 | 37263 | 1964-12-01 | 1959-09-04 | Dalal | Vasantkumar Dwarkadas | Government of India Trade Centre, New York 923 | 1955-12-01 | Government of India Trade Centre, New York | 19 East 49th Street | New York | NY | ||
37264 | 37264 | 1964-12-01 | 1959-09-04 | Shah | Rasiklal Ujamshi | Government of India Trade Centre, New York 923 | 1955-12-01 | Government of India Trade Centre, New York | 19 East 49th Street | New York | NY | ||
39950 | 39950 | 1973-12-31 | 1959-09-04 | Hall | Ronald John | British Information Services 481 | 1947-07-25 | British Information Services | 845 Third Avenue | New York | NY | 10022 |
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]) );