FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
16 rows where Registrant_Date = "1955-04-18"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Termination_Date (date)
Foreign_Principal 15
- Indonesian National Army of the Republic of Indonesia 2
- B. Datuk Bagindo 1
- Bedek Aircraft, Ltd. 1
- Dr. Francois Duvalier (President de la Republique D'Haiti) 1
- Ecuadorian Sugar Producers 1
- Government of Ecuador 1
- Israel Aircraft Industries (Formerly: Bedek Aircraft, Ltd.) 1
- Israeli Military Industries 1
- Novedades 1
- Plywood de Nicaragua, S.A. 1
- President Jean-Claude Duvalier 1
- President Joaquin Balaguer 1
- President Luis Somoza 1
- Republic of Nicaragua (General A. Somoza) 1
- Republique of Haiti 1
Country/Location_Represented 6
Registrant_Name 1
City 1
- - 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4849 | 4849 | 1970-04-01 | Indonesian National Army of the Republic of Indonesia | 1962-01-09 | INDONESIA | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Washington | DC | |||
7908 | 7908 | 1973-06-18 | Dr. Francois Duvalier (President de la Republique D'Haiti) | 1970-06-30 | HAITI | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Port-au-Prince | ||||
7909 | 7909 | 1973-06-18 | Bedek Aircraft, Ltd. | 1960-05-19 | ISRAEL | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Tel-Aviv | ||||
7910 | 7910 | 1973-06-18 | Ecuadorian Sugar Producers | 1962-07-05 | ECUADOR | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Guayaquil | ||||
7911 | 7911 | 1973-06-18 | Government of Ecuador | 1960-11-18 | ECUADOR | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Quito | ||||
7912 | 7912 | 1973-06-18 | Indonesian National Army of the Republic of Indonesia | 1970-06-30 | INDONESIA | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Washington | DC | |||
7913 | 7913 | 1973-06-18 | Israel Aircraft Industries (Formerly: Bedek Aircraft, Ltd.) | 1960-11-18 | ISRAEL | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Tel-Aviv | ||||
7914 | 7914 | 1973-06-18 | Israeli Military Industries | 1958-07-22 | ISRAEL | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Tel-Aviv | ||||
7915 | 7915 | 1973-06-18 | Novedades | 1960-05-19 | NICARAGUA | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Managua | ||||
7916 | 7916 | 1973-06-18 | Plywood de Nicaragua, S.A. | 1960-05-19 | NICARAGUA | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Managua | ||||
7917 | 7917 | 1973-06-18 | President Jean-Claude Duvalier | 1971-06-15 | HAITI | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Port-au-Prince | ||||
7918 | 7918 | 1973-06-18 | President Joaquin Balaguer | 1968-03-05 | DOMINICAN REPUBLIC | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Santo Domingo | ||||
7919 | 7919 | 1973-06-18 | President Luis Somoza | 1957-06-04 | NICARAGUA | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Managua | ||||
7920 | 7920 | 1973-06-18 | Republic of Nicaragua (General A. Somoza) | 1955-04-18 | NICARAGUA | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | |||||
7921 | 7921 | 1973-06-18 | Republique of Haiti | 1964-01-03 | HAITI | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Port-au-Haiti | ||||
11344 | 11344 | 1962-09-03 | B. Datuk Bagindo | 1962-08-24 | INDONESIA | Davidson, I. Irving 886 | 1955-04-18 | Davidson, I. Irving | Kota |
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]) );