FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where Short_Form_First_Name = "Nicolas"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 10
- Agence France-Presse (France-Presse News Agency) 1
- NTS-Alliance of Russian Solidarists 1
- Partido Revolucionario Dominicano, New York 1
- Partido Revolucionario Dominicano, Puerto Rico 1
- Burson-Marsteller 1
- Sidley Austin LLP 1
- Medley Global Advisors 1
- Quinn Gillespie & Associates, LLC 1
- Cleary Gottlieb Steen & Hamilton LLP 1
- Cleary Gottlieb Steen & Hamilton LLP 1
Registrant_Name 9
- Cleary Gottlieb Steen & Hamilton LLP 2
- Agence France-Presse (France-Presse News Agency) 1
- Burson-Marsteller 1
- Medley Global Advisors 1
- NTS-Alliance of Russian Solidarists 1
- Partido Revolucionario Dominicano, New York 1
- Partido Revolucionario Dominicano, Puerto Rico 1
- Quinn Gillespie & Associates, LLC 1
- Sidley Austin LLP 1
City 4
- New York 5
- Washington 3
- Hartford 1
- Rio Diedras 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5948 | 5948 | 1968-02-02 | 1964-08-11 | Garrido | Nicolas | Partido Revolucionario Dominicano, Puerto Rico 1777 | 1964-08-11 | Partido Revolucionario Dominicano, Puerto Rico | 967 Alameda St. Villa Granada | Rio Diedras | |||
9293 | 9293 | 1956-03-07 | 1954-07-07 | Myschencoff | Nicolas | NTS-Alliance of Russian Solidarists 565 | 1949-03-07 | NTS-Alliance of Russian Solidarists | C/O Igor Vechesloff | 51 Lorraine Street | Hartford | CT | 06105 |
11902 | 11902 | 2003-03-31 | 2002-03-11 | Checa | Nicolas | Medley Global Advisors 5484 | 2002-03-11 | Medley Global Advisors | 451 Greenwich Street | 6th Floor | New York | NY | 10013 |
20199 | 20199 | 2021-06-24 | 2021-05-25 | Grabar | Nicolas | Cleary Gottlieb Steen & Hamilton LLP 6964 | 2021-05-25 | Cleary Gottlieb Steen & Hamilton LLP | One Liberty Plaza | New York | NY | 10006 | |
21558 | 21558 | 2005-06-30 | 2004-12-22 | Maduros | Nicolas | Quinn Gillespie & Associates, LLC 5662 | 2004-12-22 | Quinn Gillespie & Associates, LLC | 1133 Connecticut Avenue, N.W. | 5th Floor | Washington | DC | 20036 |
22571 | 22571 | 1961-07-05 | 1951-05-29 | Silfa | Nicolas | Partido Revolucionario Dominicano, New York 674 | 1951-05-29 | Partido Revolucionario Dominicano, New York | 229 West 97th Street | Apartment 3C | New York | NY | |
32065 | 32065 | 2013-10-01 | 2002-10-15 | Lloreda | Nicolas | Sidley Austin LLP 3731 | 1985-09-13 | Sidley Austin LLP | 1501 K Street, N.W. | 8th Floor | Washington | DC | 20005 |
37138 | 37138 | 2019-11-30 | 2018-11-06 | Grabar | Nicolas | Cleary Gottlieb Steen & Hamilton LLP 6607 | 2018-11-06 | Cleary Gottlieb Steen & Hamilton LLP | One Liberty Plaza | New York | NY | 10006 | |
38960 | 38960 | 2010-12-22 | 2010-12-22 | Bianchi | Nicolas | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | 1110 Vermont Avenue, NW, 12th Floor | Washington | DC | 20005-3544 | |
39641 | 39641 | 1957-12-31 | 1952-11-21 | Steinheil | Nicolas | Agence France-Presse (France-Presse News Agency) 223 | 1943-12-02 | Agence France-Presse (France-Presse News Agency) | 50 Rockefeller Plaza | 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]) );