FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
34 rows where Address_1 = "Jakarta" sorted by Foreign_Principal_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Date (date) 28 ✖
- 1976-12-17 4
- 1965-02-10 2
- 1986-12-01 2
- 1992-07-31 2
- 1946-02-25 1
- 1951-01-12 1
- 1964-10-19 1
- 1973-10-23 1
- 1975-08-04 1
- 1977-02-15 1
- 1977-03-09 1
- 1979-02-08 1
- 1980-12-24 1
- 1981-11-10 1
- 1983-05-24 1
- 1983-06-24 1
- 1986-01-03 1
- 1987-05-28 1
- 1989-11-22 1
- 1991-04-01 1
- 1991-08-19 1
- 1992-06-26 1
- 1993-08-04 1
- 1994-09-26 1
- 1997-04-11 1
- 1999-10-15 1
- 2000-04-12 1
- 2000-04-27 1
Registrant_Name 27
- Hill & Knowlton, Inc. 4
- IPG DXTRA, Inc 2
- KCM International, Inc. 2
- Sandler & Travis Trade Advisory Services, Inc. 2
- Tea Council of the U.S.A., Inc. 2
- Akin, Gump, Strauss, Hauer & Feld, LLP 1
- Boasberg Valentine-Radford, Inc. 1
- Bogle & Gates 1
- Burson-Marsteller 1
- Clark, Clifford M. 1
- Crowell & Moring International, LLC 1
- Ein Communications 1
- Gass, Oscar 1
- George C. Benson, Ltd. 1
- Hill and Knowlton Strategies, LLC 1
- Indonesia Tourist Promotion Office for North America 1
- International Business Communications 1
- Lipstein, Jaffe & Lawson, L.L.P. 1
- Mackey, Thomas S. 1
- Modern Education Services, Inc. 1
- Quiko, Eduard 1
- Rogers & Wells 1
- Smith McCabe, Ltd. 1
- White & Case, LLP 1
- White, John C. 1
- William H. Douglass & Associates 1
- World Trade Link 1
Foreign_Principal 26
- Republic of Indonesia 5
- Government of Indonesia 2
- Government of the Republic of Indonesia 2
- National Development Information Office of the Republic of Indonesia 2
- P.T. Texmaco Jaya 2
- APKINDO (Asosiasi Panel Kayu Indonesia) 1
- Asosiasi Panel Kayu Indonesia (APKINDO")" 1
- Batam Industrial Development Authority 1
- Batam Island Development Authority 1
- Directorate General of Tourism Indonesia 1
- General Wiranto 1
- Government of Indonesia through Mercurindo 1
- Government of the Republic of Indonesia, Minister of Finance 1
- Indonesian National Oil & Gas Mining Enterprise (Pertamina) 1
- Indonesian Tourist Promotion Board 1
- Indonesian World Trade Centre 1
- Karwell Group 1
- Lembaga Bantuan Pemasaran & Management 1
- Lembaga Bantuan Perasaran & Managemen 1
- Matari, Inc. 1
- Minister Alwi Shihab 1
- Ministry of Trade, Government of Indonesia 1
- P.T. Teknojasa Sapta Utama 1
- P.T. Teknojasa Sapta Utama (TSU) 1
- PERTAMINA 1
- PT Timah 1
State 1
- - 34
Country/Location_Represented 1
- INDONESIA 34
City 1
- - 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11909 | 11909 | 1952-09-30 | Republic of Indonesia | 1951-01-12 | INDONESIA | Clark, Clifford M. 655 | 1951-01-12 | Clark, Clifford M. | Jakarta | ||||
2768 | 2768 | 1960-02-25 | Government of the Republic of Indonesia | 1957-02-06 | INDONESIA | Gass, Oscar 345 | 1946-02-25 | Gass, Oscar | Jakarta | ||||
15641 | 15641 | 1965-12-31 | Government of Indonesia | 1965-02-10 | INDONESIA | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | Jakarta | ||||
11942 | 11942 | 1977-09-30 | Republic of Indonesia | 1976-12-17 | INDONESIA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Jakarta | ||||
2782 | 2782 | 1979-02-25 | Republic of Indonesia | 1977-07-13 | INDONESIA | Rogers & Wells 2598 | 1975-08-04 | Rogers & Wells | Jakarta | ||||
4999 | 4999 | 1979-04-03 | PT Timah | 1979-02-08 | INDONESIA | Mackey, Thomas S. 2995 | 1979-02-08 | Mackey, Thomas S. | Jakarta | ||||
9991 | 9991 | 1984-08-01 | Batam Island Development Authority | 1984-05-02 | INDONESIA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Jakarta | ||||
12924 | 12924 | 1986-10-22 | Batam Industrial Development Authority | 1986-09-19 | INDONESIA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Jakarta | ||||
12933 | 12933 | 1986-10-22 | National Development Information Office of the Republic of Indonesia | 1977-07-08 | INDONESIA | Hill & Knowlton, Inc. 2740 | 1976-12-17 | Hill & Knowlton, Inc. | Jakarta | ||||
2381 | 2381 | 1987-02-11 | Indonesian World Trade Centre | 1986-01-03 | INDONESIA | International Business Communications 3767 | 1986-01-03 | International Business Communications | Jakarta | ||||
3296 | 3296 | 1990-03-01 | Indonesian National Oil & Gas Mining Enterprise (Pertamina) | 1980-12-24 | INDONESIA | George C. Benson, Ltd. 3183 | 1980-12-24 | George C. Benson, Ltd. | Jakarta | ||||
14422 | 14422 | 1990-11-30 | Lembaga Bantuan Pemasaran & Management | 1989-11-22 | INDONESIA | World Trade Link 4317 | 1989-11-22 | World Trade Link | Jakarta | ||||
2972 | 2972 | 1991-02-28 | Matari, Inc. | 1991-04-01 | INDONESIA | Boasberg Valentine-Radford, Inc. 4492 | 1991-04-01 | Boasberg Valentine-Radford, Inc. | Jakarta | ||||
6439 | 6439 | 1992-05-10 | PERTAMINA | 1991-08-19 | INDONESIA | William H. Douglass & Associates 4555 | 1991-08-19 | William H. Douglass & Associates | Jakarta | ||||
9546 | 9546 | 1993-07-27 | Republic of Indonesia | 1977-01-21 | INDONESIA | Tea Council of the U.S.A., Inc. 1853 | 1965-02-10 | Tea Council of the U.S.A., Inc. | Jakarta | ||||
14225 | 14225 | 1993-11-24 | Lembaga Bantuan Perasaran & Managemen | 1989-09-14 | INDONESIA | Bogle & Gates 3474 | 1983-05-24 | Bogle & Gates | Jakarta | ||||
3714 | 3714 | 1994-03-14 | Directorate General of Tourism Indonesia | 1991-09-09 | INDONESIA | Modern Education Services, Inc. 1803 | 1964-10-19 | Modern Education Services, Inc. | Jakarta | ||||
7736 | 7736 | 1994-06-10 | National Development Information Office of the Republic of Indonesia | 1987-07-13 | INDONESIA | Hill and Knowlton Strategies, LLC 3301 | 1981-11-10 | Hill and Knowlton Strategies, LLC | Jakarta | ||||
8521 | 8521 | 1994-06-30 | Government of the Republic of Indonesia | 1992-06-26 | INDONESIA | Smith McCabe, Ltd. 4687 | 1992-06-26 | Smith McCabe, Ltd. | Jakarta | ||||
13611 | 13611 | 1994-11-01 | P.T. Texmaco Jaya | 1993-08-04 | INDONESIA | White, John C. 4839 | 1993-08-04 | White, John C. | Jakarta | ||||
15260 | 15260 | 1994-12-20 | APKINDO (Asosiasi Panel Kayu Indonesia) | 1994-10-06 | INDONESIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Jakarta | ||||
12068 | 12068 | 1995-09-30 | Karwell Group | 1992-07-31 | INDONESIA | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | Jakarta | ||||
2504 | 2504 | 1996-02-14 | Asosiasi Panel Kayu Indonesia (APKINDO")" | 1995-07-17 | INDONESIA | Akin, Gump, Strauss, Hauer & Feld, LLP 3492 | 1983-06-24 | Akin, Gump, Strauss, Hauer & Feld, LLP | Jakarta | ||||
8550 | 8550 | 1996-06-30 | P.T. Texmaco Jaya | 1992-07-31 | INDONESIA | Sandler & Travis Trade Advisory Services, Inc. 4699 | 1992-07-31 | Sandler & Travis Trade Advisory Services, Inc. | Jakarta | ||||
11595 | 11595 | 1996-09-14 | P.T. Teknojasa Sapta Utama | 1994-09-26 | INDONESIA | KCM International, Inc. 4951 | 1994-09-26 | KCM International, Inc. | Jakarta | ||||
2559 | 2559 | 1998-02-15 | Indonesian Tourist Promotion Board | 1977-02-15 | INDONESIA | Indonesia Tourist Promotion Office for North America 2757 | 1977-02-15 | Indonesia Tourist Promotion Office for North America | Jakarta | ||||
4563 | 4563 | 1998-03-31 | Government of Indonesia | 1992-04-17 | INDONESIA | Burson-Marsteller 2469 | 1973-10-23 | Burson-Marsteller | Jakarta | ||||
4567 | 4567 | 1998-03-31 | P.T. Teknojasa Sapta Utama (TSU) | 1997-04-11 | INDONESIA | KCM International, Inc. 5170 | 1997-04-11 | KCM International, Inc. | Jakarta | ||||
8567 | 8567 | 1998-06-30 | Government of Indonesia through Mercurindo | 1995-08-08 | INDONESIA | IPG DXTRA, Inc 3911 | 1986-12-01 | IPG DXTRA, Inc | Jakarta | ||||
13616 | 13616 | 1998-11-01 | Ministry of Trade, Government of Indonesia | 1994-01-13 | INDONESIA | Crowell & Moring International, LLC 3988 | 1987-05-28 | Crowell & Moring International, LLC | Jakarta | ||||
3162 | 3162 | 2000-02-29 | Government of the Republic of Indonesia, Minister of Finance | 1999-10-29 | INDONESIA | Lipstein, Jaffe & Lawson, L.L.P. 5337 | 1999-10-15 | Lipstein, Jaffe & Lawson, L.L.P. | Jakarta | ||||
7177 | 7177 | 2000-05-31 | General Wiranto | 2000-04-27 | INDONESIA | Ein Communications 5369 | 2000-04-27 | Ein Communications | Jakarta | ||||
9163 | 9163 | 2000-07-10 | Minister Alwi Shihab | 2000-04-12 | INDONESIA | Quiko, Eduard 5366 | 2000-04-12 | Quiko, Eduard | Jakarta | ||||
4952 | 4952 | 2007-04-01 | Republic of Indonesia | 1977-03-09 | INDONESIA | White & Case, LLP 2759 | 1977-03-09 | White & Case, LLP | Jakarta |
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]) );