FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
14 rows where Registrant_Name = "Movimiento 26 de Julio (26th of July Movement)", "Short_Form_Termination_Date" is on date 1961-07-18 and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Short_Form_First_Name, Registration_Date (date)
State 1
- NY · 14 ✖
Registration_Number 1
Registrant_Name 1
- Movimiento 26 de Julio (26th of July Movement) · 14 ✖
City 1
- Manhattan 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23472 | 23472 | 1961-07-18 | 1961-03-07 | Parrado | Aurelio Bernardino Sanchez | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23473 | 23473 | 1961-07-18 | 1962-03-07 | Lopez | Bienvenido Efrain | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23474 | 23474 | 1961-07-18 | 1960-07-18 | Medina | Julio P. | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23475 | 23475 | 1961-07-18 | 1960-07-18 | Sanchez | Jose Manuel | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23476 | 23476 | 1961-07-18 | 1960-07-20 | Fernandez | Efrain Trujillo | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23477 | 23477 | 1961-07-18 | 1961-08-21 | Santana | Erasmo Moises Manganelle | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23478 | 23478 | 1961-07-18 | 1961-08-21 | Valdes | Carlos Carbonelll | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23479 | 23479 | 1961-07-18 | 1961-08-23 | Medina | Julio P. | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23480 | 23480 | 1961-07-18 | 1961-08-23 | Rodriguez | Angel Rafael Lopez | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23481 | 23481 | 1961-07-18 | 1961-08-23 | Tapanes | Pedro Ricardo Serefin | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23482 | 23482 | 1961-07-18 | 1961-09-05 | Rojas | Miguel S. Morera | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23483 | 23483 | 1961-07-18 | 1960-11-25 | Alonso | Kenneth | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23484 | 23484 | 1961-07-18 | 1960-11-25 | Aynat | Salvador Rafael | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY | ||
23485 | 23485 | 1961-07-18 | 1960-12-28 | Rojas | Filiberto | Movimiento 26 de Julio (26th of July Movement) 1379 | 1960-07-18 | Movimiento 26 de Julio (26th of July Movement) | 610 West 143rd Street | Manhattan | NY |
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]) );