FARA_All_ForeignPrincipals

Table actions
List of all foreign principals (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

11 rows where Country/Location_Represented = "INDONESIA" and State = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)

State 1

Country/Location_Represented 1

  • INDONESIA · 11 ✖

City 1

  • - 11
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
1993 1993 1979-02-01 P.N. Pertamina 1973-04-18 INDONESIA Ansberry, Louise S. 2297 1971-12-15 Ansberry, Louise S. New York     NY  
3492 3492 1958-03-07 Indonesian Delegation to the United Nations 1955-12-23 INDONESIA Frontaura, Pablo 926 1955-12-23 Frontaura, Pablo New York     NY  
3885 3885 1957-03-19 Indonesia 1957-03-19 INDONESIA Danforth Investigation Bureau 1012 1957-03-19 Danforth Investigation Bureau New York     NY  
5239 5239 1948-04-13 Republic of Indonesia Information Office 1948-04-13 INDONESIA Executive Research, Inc., California 522 1948-04-13 Executive Research, Inc., California New York     NY  
6732 6732 1953-05-23 Republic of Indonesia 1949-05-23 INDONESIA Demby, Emanuel Harry 572 1949-05-23 Demby, Emanuel Harry New York     NY  
6733 6733 1953-05-23 Republic of the United States of Indonesia (Information Office) 1950-07-13 INDONESIA Demby, Emanuel Harry 572 1949-05-23 Demby, Emanuel Harry New York     NY  
12694 12694 1951-10-15 Indonesian Mission to the United Nations, Office of the Permanent Observer to the United Nations 1950-08-03 INDONESIA Mintz, Jeanne S. 636 1950-08-03 Mintz, Jeanne S. New York     NY  
12759 12759 1958-10-16 Indonesian Permanent Mission to the United Nations 1958-04-16 INDONESIA Eggleston, Arthur 1131 1958-04-16 Eggleston, Arthur New York     NY  
13200 13200 1954-10-31 Information Office of the Republic of Indonesia 1953-12-28 INDONESIA Drysdale Roche Gibson Associates, Inc. 772 1953-06-11 Drysdale Roche Gibson Associates, Inc. New York     NY  
15198 15198 1967-12-18 Central Indonesian Trading Company, Inc. 1964-12-10 INDONESIA Aranow, Brodsky, Bohlinger, Einhorn & Dann 1731 1964-05-13 Aranow, Brodsky, Bohlinger, Einhorn & Dann New York     NY  
15398 15398 1949-12-27 Matthew Fox 1949-01-17 INDONESIA Feltus, Randolph 381 1946-10-16 Feltus, Randolph New York     NY  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);