FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
48 rows where "Registrant_Date" is on date 1942-09-14 sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Registration_Date, Registration_Number, Address_1
Foreign_Principal >30
- Agence Teleradio 1
- Amparo Martinez 1
- Antonio Calderon Talavera 1
- Antonio Madrigal 1
- Antonio Martinez Aguayo 1
- Antonio Urvizu 1
- Antonio Zermeno 1
- Bibiano Segura Leon 1
- Chizu T. Buma & Yukio Buma 1
- Consuelo Sanchez Gonzalez 1
- David Lomeli Contreras 1
- Davis Orosco Romo 1
- Eiji Koike 1
- France-Amerique 1
- Francisco Raul Calderon 1
- Gildardo Gonsalez Sanchez 1
- Gustavo Arizmendi 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
- Jose Valadez Navarro 1
- Josefina Escobedo 1
- Juan Ignacio Padilla 1
- Kohji Katoh 1
- Leon Aguilar 1
- Leopoldo Martinez 1
- …
Foreign_Principal_Registration_Date (date) 14 ✖
- 1942-09-14 11
- 1949-05-02 8
- 1955-05-01 7
- 1946-09-17 6
- 1955-11-01 5
- 1960-05-31 3
- 1943-04-05 1
- 1946-10-02 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 4
City 1
- - 48
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2822 | 2822 | 1964-02-26 | Amparo Martinez | 1950-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 | |||||
2826 | 2826 | 1964-02-26 | Consuelo Sanchez Gonzalez | 1955-05-01 | 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 | |||||
2828 | 2828 | 1964-02-26 | Davis Orosco Romo | 1955-11-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 | |||||
2831 | 2831 | 1964-02-26 | Ignacio Gonzalez Gollaz | 1949-05-02 | 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 | |||||
2834 | 2834 | 1964-02-26 | Jose Davalos | 1958-11-30 | 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 | |||||
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 | |||||
2840 | 2840 | 1964-02-26 | Juan Ignacio Padilla | 1949-05-02 | 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 | |||||
2843 | 2843 | 1964-02-26 | Leovardo Senteno | 1953-05-01 | 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 | |||||
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 | |||||
2846 | 2846 | 1964-02-26 | Ofelia Ramirez | 1961-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 | |||||
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 | |||||
2850 | 2850 | 1964-02-26 | Saturnina Zuniga | 1962-05-01 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
2851 | 2851 | 1964-02-26 | Union Nacional Sinarquista | 1942-09-14 | 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 | |||||
3694 | 3694 | 1943-03-14 | Chizu T. Buma & Yukio Buma | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3695 | 3695 | 1943-03-14 | Eiji Koike | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3696 | 3696 | 1943-03-14 | Kohji Katoh | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3697 | 3697 | 1943-03-14 | Mareo Wooyeno | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3698 | 3698 | 1943-03-14 | Morimura Brothers, Inc. (Morimura Kumi) | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3699 | 3699 | 1943-03-14 | Sukisaburo Nagai | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3700 | 3700 | 1943-03-14 | Yonosuke Maenami | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3701 | 3701 | 1943-03-14 | Yukio Buma | 1942-09-14 | JAPAN | Furudera, Robert H. 122 | 1942-09-14 | Furudera, Robert H. | Tokyo | ||||
3702 | 3702 | 1947-03-14 | France-Amerique | 1946-10-02 | FRANCE | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | Paris | ||||
3703 | 3703 | 1947-03-14 | San Francisco Comite France Amerique | 1942-09-14 | FRANCE | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | San Francisco | CA | |||
6125 | 6125 | 1948-05-01 | Antonio Madrigal | 1946-09-17 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
6126 | 6126 | 1948-05-01 | Antonio Martinez Aguayo | 1946-09-17 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
6127 | 6127 | 1948-05-01 | Antonio Urvizu | 1946-09-17 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
6128 | 6128 | 1948-05-01 | Gildardo Gonsalez Sanchez | 1946-09-17 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
6129 | 6129 | 1948-05-01 | Gustavo Arizmendi | 1946-09-17 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
6130 | 6130 | 1948-05-01 | Manuel Torres Bueno | 1943-04-05 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
13519 | 13519 | 1951-11-01 | Jose Valadez Navarro | 1946-09-17 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
13520 | 13520 | 1951-11-01 | Luis Martinez Narezo | 1949-05-02 | MEXICO | Union Nacional Sinarquista 123 | 1942-09-14 | Union Nacional Sinarquista | |||||
13838 | 13838 | 1942-11-09 | Agence Teleradio | 1942-09-14 | FRANCE | Estrangin, Gustave Fritsch 1 | 1942-09-14 | Estrangin, Gustave Fritsch | Vichy |
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]) );