FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
31 rows where "Foreign_Principal_Termination_Date" is on date 1964-02-26 sorted by Foreign_Principal_Registration_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registrant_Date, Address_1
Foreign_Principal >30
- Amparo Martinez 1
- Antonio Calderon Talavera 1
- Antonio Zermeno 1
- Bibiano Segura Leon 1
- Consuelo Sanchez Gonzalez 1
- David Lomeli Contreras 1
- Davis Orosco Romo 1
- Diego Bordas - Assistant to Juan Bosch, While President Elect" & President of the Dominican Republic" 1
- Francisco Raul Calderon 1
- Ignacio Gonzalez Gollaz 1
- Jaime Delgado Herrera 1
- Jesus Montenegro Aboytes 1
- Jose Davalos 1
- Jose Manuel Figueroa 1
- Jose Resendiz Castaneda 1
- Jose Sanchez Gonzalez 1
- Josefina Escobedo 1
- Juan Bosch, President Elect, President of Dominican Republic 1
- Juan Ignacio Padilla 1
- Leon Aguilar 1
- Leopoldo Martinez 1
- Leovardo Senteno 1
- Manuel Galindo Fuentes 1
- Maria De Jesus Castro De Lomeli 1
- Ofelia Ramirez 1
- Oscar Memdez Napoles 1
- Rafael Bernal 1
- Salvador Zermeno Marques 1
- Saturnina Zuniga 1
- Union Nacional Sinarquista 1
- …
Foreign_Principal_Registration_Date (date) 12 ✖
- 1949-05-02 7
- 1955-05-01 7
- 1955-11-01 5
- 1960-05-31 3
- 1964-02-26 2
- 1942-09-14 1
- 1950-05-01 1
- 1953-05-01 1
- 1958-11-30 1
- 1959-05-31 1
- 1961-05-01 1
- 1962-05-01 1
Registrant_Name 2
Registrant_Date (date) 2 ✖
- 1942-09-14 29
- 1964-02-26 2
Country/Location_Represented 2
- MEXICO 29
- DOMINICAN REPUBLIC 2
State 1
- - 31
City 1
- - 31
Link | rowid | Foreign_Principal_Termination_Date | Foreign_Principal | Foreign_Principal_Registration_Date ▼ | Country/Location_Represented | Registration_Number | Registrant_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2851 | 2851 | 1964-02-26 | Union Nacional Sinarquista | 1942-09-14 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2827 | 2827 | 1964-02-26 | David Lomeli Contreras | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2831 | 2831 | 1964-02-26 | Ignacio Gonzalez Gollaz | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2840 | 2840 | 1964-02-26 | Juan Ignacio Padilla | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2844 | 2844 | 1964-02-26 | Manuel Galindo Fuentes | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2848 | 2848 | 1964-02-26 | Rafael Bernal | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2849 | 2849 | 1964-02-26 | Salvador Zermeno Marques | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2852 | 2852 | 1964-02-26 | Zefrerino Sanchez Hidalgo | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2822 | 2822 | 1964-02-26 | Amparo Martinez | 1950-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2843 | 2843 | 1964-02-26 | Leovardo Senteno | 1953-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2826 | 2826 | 1964-02-26 | Consuelo Sanchez Gonzalez | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2830 | 2830 | 1964-02-26 | Francisco Raul Calderon | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2832 | 2832 | 1964-02-26 | Jaime Delgado Herrera | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2833 | 2833 | 1964-02-26 | Jesus Montenegro Aboytes | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2835 | 2835 | 1964-02-26 | Jose Manuel Figueroa | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2836 | 2836 | 1964-02-26 | Jose Resendiz Castaneda | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2847 | 2847 | 1964-02-26 | Oscar Memdez Napoles | 1955-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2823 | 2823 | 1964-02-26 | Antonio Calderon Talavera | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2824 | 2824 | 1964-02-26 | Antonio Zermeno | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2825 | 2825 | 1964-02-26 | Bibiano Segura Leon | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2828 | 2828 | 1964-02-26 | Davis Orosco Romo | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2845 | 2845 | 1964-02-26 | Maria De Jesus Castro De Lomeli | 1955-11-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2834 | 2834 | 1964-02-26 | Jose Davalos | 1958-11-30 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2837 | 2837 | 1964-02-26 | Jose Sanchez Gonzalez | 1959-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2838 | 2838 | 1964-02-26 | Josefina Escobedo | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2841 | 2841 | 1964-02-26 | Leon Aguilar | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2842 | 2842 | 1964-02-26 | Leopoldo Martinez | 1960-05-31 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2846 | 2846 | 1964-02-26 | Ofelia Ramirez | 1961-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2850 | 2850 | 1964-02-26 | Saturnina Zuniga | 1962-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2829 | 2829 | 1964-02-26 | Diego Bordas - Assistant to Juan Bosch, While President Elect" & President of the Dominican Republic" | 1964-02-26 | DOMINICAN REPUBLIC | Cichanowicz & Callan 1694 | 1964-02-26 | Cichanowicz & Callan | Santo Domingo | ||||
2839 | 2839 | 1964-02-26 | Juan Bosch, President Elect, President of Dominican Republic | 1964-02-26 | DOMINICAN REPUBLIC | Cichanowicz & Callan 1694 | 1964-02-26 | Cichanowicz & Callan | Santo Domingo |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ForeignPrincipals] ( [Foreign_Principal_Termination_Date] TEXT, [Foreign_Principal] TEXT, [Foreign_Principal_Registration_Date] TEXT, [Country/Location_Represented] TEXT, [Registration_Number] INTEGER, [Registrant_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]) );