FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where "Foreign_Principal_Registration_Date" is on date 1942-07-09 sorted by Registrant_Date
This data as json, CSV (advanced)
Foreign_Principal 10
- Department of Fomento, Republic of the U.S. of Venezuela 1
- Dr. Syngman Rhee 1
- Erez Israel (Palestine) Foundation Fund Keren Hayesod, Ltd. 1
- Finnish-American Trading Corporation 1
- Jewish Agency for Palestine 1
- Korean National Front Federation 1
- Sino-Korean People's League 1
- Spanish Embassy 1
- Spanish Library of Information 1
- Vicesecretaria de Educacion Popular 1
Registrant_Name 9
City 1
- - 10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
770 | 770 | 1944-01-01 | Jewish Agency for Palestine | 1942-07-09 | PALESTINE | Rosenbluth, Martin (Michael) 31 | 1942-07-09 | Rosenbluth, Martin (Michael) | 77 Great Russell, London | ||||
1164 | 1164 | 1945-01-09 | Erez Israel (Palestine) Foundation Fund Keren Hayesod, Ltd. | 1942-07-09 | ISRAEL | Blumenfeld, Kurt 30 | 1942-07-09 | Blumenfeld, Kurt | Behavia, Jerusalem | ||||
2234 | 2234 | 1948-02-06 | Spanish Embassy | 1942-07-09 | SPAIN | LeRoy & Denslow 27 | 1942-07-09 | LeRoy & Denslow | Washington | DC | |||
4146 | 4146 | 1943-03-30 | Department of Fomento, Republic of the U.S. of Venezuela | 1942-07-09 | VENEZUELA | Arroyo, Julian Avelino 25 | 1942-07-09 | Arroyo, Julian Avelino | Caracas | ||||
9112 | 9112 | 1942-07-09 | Dr. Syngman Rhee | 1942-07-09 | KOREA, SOUTH | Chang, Kee Young 26 | 1942-07-09 | Chang, Kee Young | Washington | DC | |||
9113 | 9113 | 1942-07-09 | Vicesecretaria de Educacion Popular | 1942-07-09 | SPAIN | Spanish Library of Information 28 | 1942-07-09 | Spanish Library of Information | Madrid | ||||
9114 | 9114 | 1943-07-09 | Finnish-American Trading Corporation | 1942-07-09 | FINLAND | Jarvinen, Vilho Olavi 24 | 1942-07-09 | Jarvinen, Vilho Olavi | New York | NY | |||
9116 | 9116 | 1946-07-09 | Sino-Korean People's League | 1942-07-09 | KOREA, SOUTH | Haan, Kilsoo Kenneth 23 | 1942-07-09 | Haan, Kilsoo Kenneth | Honolulu | HI | |||
9117 | 9117 | 1946-07-09 | Korean National Front Federation | 1942-07-09 | KOREA, SOUTH | Haan, Kilsoo Kenneth 23 | 1942-07-09 | Haan, Kilsoo Kenneth | Chungking | ||||
9473 | 9473 | 1943-07-26 | Spanish Library of Information | 1942-07-09 | SPAIN | Carpenter, Charles M. 29 | 1942-07-09 | Carpenter, Charles M. | New York | NY |
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]) );