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

19 rows where Country/Location_Represented = "INDONESIA" and State = "DC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Foreign_Principal_Termination_Date, Registrant_Date, Address_1, Zip, Foreign_Principal_Termination_Date (date), Registrant_Date (date)

City 2

State 1

Country/Location_Represented 1

  • INDONESIA · 19 ✖
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
1105 1105 1995-01-06 Embassy of the Republic of Indonesia 1992-07-29 INDONESIA International Trade & Development Agency, Inc. 3690 1985-06-13 International Trade & Development Agency, Inc. Washington     DC  
3222 3222 1968-03-01 Embassy of Indonesia 1967-09-29 INDONESIA Schweitzer, N. Tina 2053 1967-09-29 Schweitzer, N. Tina Washington     DC  
3728 3728 2012-03-14 Embassy of the Republic of lndonesia 2012-02-28 INDONESIA Quinn Gillespie & Associates, LLC 5753 2006-06-01 Quinn Gillespie & Associates, LLC 2020 Massachusetts Avenue, NW   Washington DC 20036
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  
6672 6672 1993-05-20 Embassy of the Republic of Indonesia 1992-04-27 INDONESIA Pintak Communications International, Ltd. 4673 1992-04-27 Pintak Communications International, Ltd. Washington     DC  
7011 7011 1957-05-31 Embassy of Indonesia 1954-11-30 INDONESIA Spencer, William Byron 857 1954-11-30 Spencer, William Byron Washington     DC  
7713 7713 1956-06-10 Embassy of Indonesia 1956-05-09 INDONESIA Felt, Truman T. 951 1956-05-09 Felt, Truman T. Washington     DC  
7867 7867 1955-06-16 Republic of Indonesia 1955-04-14 INDONESIA Schaler, Butler & Associates 718 1952-02-26 Schaler, Butler & Associates Washington     DC  
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  
8135 8135 1963-06-28 Republic of Indonesia 1961-12-29 INDONESIA Milks, Martha Ann 1505 1961-12-29 Milks, Martha Ann Washington     DC  
8160 8160 1984-06-29 Kedutaan Besar Indonesia - Embassy of Indonesia 1968-08-22 INDONESIA Sakai, Ruby C. 2101 1968-08-22 Sakai, Ruby C. Washington     DC  
8800 8800 1951-07-01 Government of Indonesia 1949-07-15 INDONESIA McInerny, Timothy A. 584 1949-07-15 McInerny, Timothy A. Washington     DC  
9292 9292 1952-07-16 Embassy of the Republic of Indonesia 1952-01-16 INDONESIA Jerome Jacobson Associates 708 1952-01-16 Jerome Jacobson Associates Washington     DC  
12412 12412 2011-10-01 Embassy of the Republic of Indonesia 2011-06-23 INDONESIA Quinn Gillespie & Associates, LLC 5753 2006-06-01 Quinn Gillespie & Associates, LLC 2020 Massachusetts Avenue, NW   Washington DC 20036
12574 12574 1950-10-10 Government of the Republic of the United States of Indonesia 1950-07-20 INDONESIA Onishi, Charles Y. 632 1950-07-20 Onishi, Charles Y. Washington     DC  
13309 13309 1991-10-31 Ministry of Forestry of Indonesia, represented by the Embassy of Indonesia 1991-09-11 INDONESIA Cassidy & Associates, Inc. 4259 1989-05-25 Cassidy & Associates, Inc. Washington     DC  
14110 14110 1976-11-21 Embassy in the U.S. & Mission to the United Nations of the Republic of the United States of Indonesia 1950-02-20 INDONESIA Delson & Gordon 502 1947-11-21 Delson & Gordon Washington     DC  
14112 14112 1976-11-21 Embassy of the Republic of Indonesia 1971-05-20 INDONESIA Delson & Gordon 502 1947-11-21 Delson & Gordon Washington     DC  
15181 15181 1954-12-17 Embassy of Indonesia 1954-10-13 INDONESIA Smith, Edwin S. 723 1952-05-05 Smith, Edwin S. Washington     DC  

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