FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
8 rows where Country/Location_Represented = "IRAN" and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 7
Foreign_Principal 7
- Mission of the Islamic Republic of Iran to the UN 2
- Government of Iran, Permanent Mission of the Republic of Iran to the U.N. 1
- Government of Iran, United Nations Mission 1
- Iranian Information Service of the Government of Iran (Iranian Information Center) 1
- Khaibar Khan 1
- Logistics Support Center Imperial Iranian Air Force 1
- Mission of Islamic Republic of Iran to the United Nations 1
State 1
- NY · 8 ✖
Country/Location_Represented 1
- IRAN · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2386 | 2386 | 2013-02-11 | Mission of the Islamic Republic of Iran to the UN | 2006-06-22 | IRAN | Clark, Mark Edmond 5755 | 2006-06-22 | Clark, Mark Edmond | 622 Third Avenue | 34th Floor | New York | NY | 10017 |
2536 | 2536 | 1960-02-15 | Iranian Information Service of the Government of Iran (Iranian Information Center) | 1959-10-15 | IRAN | Rasponi Associates, Inc. 1287 | 1959-10-15 | Rasponi Associates, Inc. | New York | NY | |||
2989 | 2989 | 1993-02-28 | Government of Iran, Permanent Mission of the Republic of Iran to the U.N. | 1992-08-12 | IRAN | Sepasy, Bijan Adam 4703 | 1992-08-12 | Sepasy, Bijan Adam | New York | NY | |||
3077 | 3077 | 2006-02-28 | Mission of the Islamic Republic of Iran to the UN | 2005-08-01 | IRAN | Clark, Mark Edmond 5701 | 2005-08-01 | Clark, Mark Edmond | 622 Third Avenue | 34th Floor | New York | NY | 10016 |
7755 | 7755 | 1964-06-12 | Khaibar Khan | 1963-06-12 | IRAN | Chandor, E. Haring 1638 | 1963-06-12 | Chandor, E. Haring | New York | NY | |||
10022 | 10022 | 1992-08-01 | Government of Iran, United Nations Mission | 1992-07-30 | IRAN | Forum on American-Iranian Relations Foundation 4702 | 1992-07-30 | Forum on American-Iranian Relations Foundation | New York | NY | |||
10306 | 10306 | 1992-08-12 | Mission of Islamic Republic of Iran to the United Nations | 1991-09-03 | IRAN | Bijan Adam Sepasy - Access U.S.A., Inc. 4560 | 1991-09-03 | Bijan Adam Sepasy - Access U.S.A., Inc. | New York | NY | |||
11380 | 11380 | 1980-09-05 | Logistics Support Center Imperial Iranian Air Force | 1979-08-22 | IRAN | Berkowitz, Boyar & Higgins 2948 | 1979-08-22 | Berkowitz, Boyar & Higgins | 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]) );