FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Short_Form_Last_Name = "Ramirez"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date)
Registration_Number 11
- Union Nacional Sinarquista 2
- Comite Regional Sinarquista en Los Angeles 1
- Club Patriotico 26 de Julio de Miami 1
- Arnold & Porter Kaye Scholer LLP 1
- Partido Revolucionario Dominicano, New York 1
- Dominican Republic Government Tourist Office 1
- Korea Trade Center, Los Angeles 1
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- IPG DXTRA, Inc 1
- QORVIS LLC 1
- Podesta Group, Inc. 1
Registrant_Name 11
- Union Nacional Sinarquista 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Arnold & Porter Kaye Scholer LLP 1
- Club Patriotico 26 de Julio de Miami 1
- Comite Regional Sinarquista en Los Angeles 1
- Dominican Republic Government Tourist Office 1
- IPG DXTRA, Inc 1
- Korea Trade Center, Los Angeles 1
- Partido Revolucionario Dominicano, New York 1
- Podesta Group, Inc. 1
- QORVIS LLC 1
City 5
- Washington 4
- New York 3
- El Paso 2
- Los Angeles 2
- Miami 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829 | 829 | 2023-04-18 | Ramirez | Mario Luis | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | 2001 K Street, NW | Washington | DC | 20006 | ||
2521 | 2521 | 1959-01-01 | 1958-10-24 | Ramirez | Oscar Diego Ruben | Club Patriotico 26 de Julio de Miami 998 | 1957-02-06 | Club Patriotico 26 de Julio de Miami | 3527 Northwest 2nd Street | Miami | FL | ||
7308 | 7308 | 2015-02-20 | 2015-01-30 | Ramirez | Kelly | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | 909 Third Ave. | New York | NY | 10022 | |
9090 | 9090 | 1968-03-04 | 1955-03-21 | Ramirez | Jose Alvarez | Comite Regional Sinarquista en Los Angeles 139 | 1942-10-08 | Comite Regional Sinarquista en Los Angeles | 727 Camulos Street | Los Angeles | CA | ||
12467 | 12467 | 1987-04-01 | 1985-04-10 | Ramirez | M. Pia | Korea Trade Center, Los Angeles 2646 | 1975-12-19 | Korea Trade Center, Los Angeles | 4801 Wilshire Boulevard | Suite 104 | Los Angeles | CA | 90010-3813 |
15273 | 15273 | 1945-05-01 | 1942-09-14 | Ramirez | Ramon Luis | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | 7245 -1/2 Dale Road #15 | El Paso | |||
18849 | 18849 | 1999-06-04 | 1990-01-16 | Ramirez | Profirio F. , Jr. | Arnold & Porter Kaye Scholer LLP 1750 | 1964-06-04 | Arnold & Porter Kaye Scholer LLP | 601 Massachusetts Avenue, NW | Washington | DC | 20001-3743 | |
26490 | 26490 | 1980-08-12 | 1974-07-03 | Ramirez | Hector | Dominican Republic Government Tourist Office 2524 | 1974-07-03 | Dominican Republic Government Tourist Office | 64 West 50th Street | New York | NY | 10020 | |
29072 | 29072 | 1948-09-03 | 1942-09-14 | Ramirez | Marcelino | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | 7245 -1/2 Dale Road #15 | El Paso | |||
30902 | 30902 | 1971-09-30 | 1971-07-12 | Ramirez | Miguelina | Partido Revolucionario Dominicano, New York 1923 | 1965-09-01 | Partido Revolucionario Dominicano, New York | 216 West 103rd Street | New York | NY | 10025 | |
32064 | 32064 | 2013-10-01 | 2011-07-29 | Ramirez | Catherine Cecilia Castro | QORVIS LLC 5483 | 2002-03-06 | QORVIS LLC | 1201 Connecticut Avenue, NW | Suite 1000 | Washington | DC | 20036 |
35928 | 35928 | 2017-11-15 | 2010-11-05 | Ramirez | Oscar | Podesta Group, Inc. 5926 | 2009-04-01 | Podesta Group, Inc. | 1001 G Street, NW | Suite 1000 West | Washington | DC | 20001 |
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]) );