FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
30 rows where City = "New York", Registration_Number = 401 and State = "NY" sorted by Registration_Number
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Short_Form_Date (date)
Short_Form_Termination_Date (date) 27 ✖
- 1965-06-30 2
- 1973-11-07 2
- 1976-10-29 2
- 1947-04-29 1
- 1953-04-14 1
- 1954-10-01 1
- 1956-11-01 1
- 1957-04-30 1
- 1960-03-31 1
- 1960-11-01 1
- 1965-06-15 1
- 1968-03-15 1
- 1968-07-06 1
- 1968-09-27 1
- 1969-07-31 1
- 1971-03-15 1
- 1971-05-06 1
- 1974-04-07 1
- 1978-04-30 1
- 1979-01-01 1
- 1979-02-01 1
- 1981-10-28 1
- 1982-06-29 1
- 1983-01-01 1
- 1987-03-17 1
- 1988-05-31 1
- 1990-02-28 1
State 1
- NY · 30 ✖
Registration_Number 1
- Corporacion de Fomento de la Produccion · 30 ✖
Registrant_Name 1
City 1
- New York · 30 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2586 | 2586 | 1979-01-01 | 1974-10-18 | Corssen | Ricardo | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
2616 | 2616 | 1983-01-01 | 1980-10-15 | Egana | Gerardo | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
5716 | 5716 | 1979-02-01 | 1977-05-02 | Palma | Isidoro Luis A. | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
7954 | 7954 | 1990-02-28 | 1987-03-17 | Canessa | Julio | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
9903 | 9903 | 1968-03-15 | 1965-12-06 | Vial | Enrique | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
9909 | 9909 | 1971-03-15 | 1971-02-17 | Donoso | Jaime | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
10128 | 10128 | 1987-03-17 | 1982-05-07 | Palacios | Javier | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
11357 | 11357 | 1960-03-31 | 1954-06-03 | Figueroa | Joaquin | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
12868 | 12868 | 1974-04-07 | 1971-05-11 | Vergara | Mario | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
13301 | 13301 | 1953-04-14 | 1946-11-25 | Oliver | Robert | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
14325 | 14325 | 1947-04-29 | 1946-11-25 | Mariani | Charles X. | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
14419 | 14419 | 1957-04-30 | 1951-12-06 | Senger | Aloysius J. | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
14513 | 14513 | 1978-04-30 | 1977-06-21 | Claro | Jorge Fernando | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
15788 | 15788 | 1971-05-06 | 1971-02-17 | Velasco | Luis | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
17710 | 17710 | 1988-05-31 | 1983-05-05 | Borquez | Carlos | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
19494 | 19494 | 1965-06-15 | 1960-04-28 | Zabala | Jose | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
20514 | 20514 | 1982-06-29 | 1979-12-19 | Prieto | Joaquin | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
20760 | 20760 | 1965-06-30 | 1961-04-20 | Sepulveda | Marcelo | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
20769 | 20769 | 1965-06-30 | 1946-11-25 | Siemon | William J. | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
22622 | 22622 | 1968-07-06 | 1965-12-06 | Alonzo | Carlos | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
24657 | 24657 | 1969-07-31 | 1963-01-08 | Roe | Marjorie | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
30585 | 30585 | 1968-09-27 | 1965-12-06 | Meschi | Angel | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
31765 | 31765 | 1954-10-01 | 1952-11-10 | Araneda | Bernardo Pizarro | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
33744 | 33744 | 1981-10-28 | 1979-12-19 | Laborde | Martin | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
33953 | 33953 | 1976-10-29 | 1971-02-17 | Mahn | Edgar | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
33954 | 33954 | 1976-10-29 | 1974-02-19 | Pastor | Mariano A. | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
34797 | 34797 | 1956-11-01 | 1955-12-12 | Schneider | Jorge | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
34810 | 34810 | 1960-11-01 | 1957-05-27 | Fajardo | Sergio | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
35358 | 35358 | 1973-11-07 | 1973-06-12 | Urrutia | Javier | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
35363 | 35363 | 1973-11-07 | 1965-12-06 | Barraza | Enrique | Corporacion de Fomento de la Produccion 401 | 1946-12-23 | Corporacion de Fomento de la Produccion | One World Trade Center | Suite 5151 | New York | NY | 10048-0497 |
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]) );