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

59 rows where State = "IL"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 3

State 1

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
1090 1090 2023-01-06 Consul General of India 2023-01-06 INDIA Bharat Barai 7214 2023-01-06 Bharat Barai 455 N. Cityfront Plaza Dr., Suite 850   Chicago IL 60611
1150 1150 1945-01-10 Johann Luehne, Sr. 1942-07-10 GERMANY, FEDERAL REPUBLIC OF Luehne Jr., John H. 33 1942-07-10 Luehne Jr., John H. Chicago     IL  
1151 1151 1945-01-10 Modene Louis Rachin 1942-07-10 GERMANY, FEDERAL REPUBLIC OF Luehne Jr., John H. 33 1942-07-10 Luehne Jr., John H. Chicago     IL  
1858 1858 2011-01-31 Korean National Tourism Organization 1979-11-23 KOREA, SOUTH Korea National Tourism Organization, Chicago 3069 1979-11-23 Korea National Tourism Organization, Chicago Chicago     IL  
1955 1955 1974-02-01 Consul General of Iran 1973-09-12 IRAN Mayer & O'Brien, Inc. 2461 1973-09-12 Mayer & O'Brien, Inc. Chicago     IL  
2950 2950 1992-02-28 Agie U.S.A., Ltd. 1990-04-27 SWITZERLAND G.S. Schwartz & Company, Inc. 4370 1990-04-27 G.S. Schwartz & Company, Inc. Addison     IL  
3290 3290 1999-03-01 Alhaji Muhammadu Dikko Yusufu (through Capital Missions Company) 1998-11-12 NIGERIA Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC St. Charles     IL  
3794 3794 1960-03-17 Guillermo Mejia Velez 1960-03-17 NICARAGUA Nicaraguan Liberation Movement of July 23rd 1341 1960-03-17 Nicaraguan Liberation Movement of July 23rd Evanston     IL  
4288 4288 1969-03-31 Consul General of Japan 1967-09-06 JAPAN Johnson, Robert Bruce 2046 1967-09-06 Johnson, Robert Bruce Chicago     IL  
4768 4768 2021-03-31 Nicaraguans for Security & Prosperity 2019-10-17 NICARAGUA Sanitas International, Inc. 6530 2018-03-07 Sanitas International, Inc. 500 N. Michigan Ave. STE 600   Chicago IL 60611
5227 5227 1976-04-15 Japan Trade Center (JETRO) 1967-11-24 JAPAN Public Relations Board, Inc. 2065 1967-11-24 Public Relations Board, Inc. Chicago     IL  
5530 5530 1991-04-25 Italian Institute for Foreign Trade - Rome, Italy 1983-10-25 ITALY Piero Ottinetti Design 3532 1983-10-25 Piero Ottinetti Design Chicago     IL  
5808 5808 1991-04-30 British Government Consulate 1990-04-18 GREAT BRITAIN Sagamore-Bainbridge 4368 1990-04-18 Sagamore-Bainbridge Chicago     IL  
6265 6265 1983-05-04 Korea National Tourism Corporation 1981-10-06 KOREA, SOUTH Centron Corporation, Inc. 3284 1981-10-06 Centron Corporation, Inc. Chicago     IL  
6271 6271 1993-05-04 Consulate (Central Region) of the State of Israel 1989-09-12 ISRAEL Jasculca/Terman & Associates, Inc. 4289 1989-09-12 Jasculca/Terman & Associates, Inc. Chicago     IL  
6302 6302 1965-05-06 Consulate General of Yugoslavia 1964-10-29 YUGOSLAVIA Berkanovic, Edward T. 1809 1964-10-29 Berkanovic, Edward T. Chicago     IL  
6779 6779 1997-05-25 Lithuanian-American Council, Inc. 1999-01-22 LITHUANIA Washington World Group, Ltd. 5016 1995-04-20 Washington World Group, Ltd. Chicago     IL  
7048 7048 1991-05-31 Fujisawa Pharmaceutical Company 1990-12-07 JAPAN Cosmo Public Relations 4434 1990-11-13 Cosmo Public Relations Deerfield     IL  
7652 7652 2021-06-09 Pavel Valnev 2020-12-19 BULGARIA Yorktown Solutions, LLC 6491 2017-11-19 Yorktown Solutions, LLC 1492 Tyrell Avenue   Park Ridge IL 60068
7708 7708 1990-06-12 Sodick, Inc. (See: Sodick Company, Ltd.) 1990-04-06 JAPAN Marks, Murase & White 4141 1988-05-12 Marks, Murase & White Rolling Meadows     IL  
7831 7831 1992-06-17 Austrian Federal Chamber of Commerce 1955-02-21 AUSTRIA Austrian Trade Commissioner in the U.S., Chicago 874 1955-02-21 Austrian Trade Commissioner in the U.S., Chicago Chicago     IL  
8469 8469 1995-06-30 Brambles U.S.A., Inc. 1989-09-08 AUSTRALIA Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt Chicago     IL  
8804 8804 1988-07-01 Her Majesty's Government (Through the British Consulate General) 1988-03-17 GREAT BRITAIN Hopkins & Sutter 4101 1988-03-17 Hopkins & Sutter Chicago     IL  
9689 9689 1989-07-31 Daniel S. Smith, Consul General, South Africa Consulate 1988-03-25 SOUTH AFRICA Rothschild, Mary Kathleen 4108 1988-03-25 Rothschild, Mary Kathleen Chicago     IL  
9709 9709 1990-07-31 Italian Trade Commission 1985-04-08 ITALY Miluski, Krystine R.L. 3668 1985-04-08 Miluski, Krystine R.L. West Dundee     IL  
9970 9970 2001-08-01 Movement for Democratic Change 2001-06-22 ZIMBABWE IPG DXTRA, Inc 3911 1986-12-01 IPG DXTRA, Inc 1900 South Clark Street Chicago 60616     IL  
10236 10236 1988-08-12 British Consulate General 1988-05-12 GREAT BRITAIN O'Connor & Hannan 4142 1988-05-12 O'Connor & Hannan Chicago     IL  
10543 10543 1964-08-19 Deutschlandsender 1964-08-19 GERMANY, FEDERAL REPUBLIC OF Bloemer, Dr. Klaus 1780 1964-08-19 Bloemer, Dr. Klaus Chicago     IL  
10559 10559 1950-08-20 Venezuelan Trade Mission to the First U.S. International Fair 1950-12-26 VENEZUELA Cleary, Gottlieb, Steen & Hamilton, LLP 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP Chicago     IL  
10615 10615 1992-08-23 Israel Government Tourist Office 1978-06-01 ISRAEL Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Chicago     IL  
10617 10617 1992-08-23 Royal Danish Consulate General, Chicago 1977-11-08 DENMARK Public Service Audience Planners 2452 1979-08-23 Public Service Audience Planners Chicago     IL  
10706 10706 1981-08-27 Italian Trade Commission 1980-07-25 ITALY Bentley, Barnes & Lynn, Inc. 3127 1980-07-25 Bentley, Barnes & Lynn, Inc. Chicago     IL  
10852 10852 1981-08-31 German National Tourist Office-Chicago 1973-04-17 GERMANY, FEDERAL REPUBLIC OF Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Chicago     IL  
10856 10856 1981-08-31 German Tourist Office 1970-06-17 GERMANY, FEDERAL REPUBLIC OF Association Films, Inc. 1814 1964-11-06 Association Films, Inc. Chicago     IL  
11019 11019 2004-08-31 Italian Trade Commission 2004-01-13 ITALY GCI Group, Inc. 3856 1986-07-11 GCI Group, Inc. 401 N. Michigan Avenue, Suite 3030 Chicago 60611     IL  
11121 11121 2021-08-31 Italian Trade Agency Chicago Office, Italian Trade Commission 2021-08-04 ITALY Daloisio Global LLC 6986 2021-08-04 Daloisio Global LLC 401 North Michigan Avenue Suite 1720 Chicago IL 60611
11122 11122 2021-08-31 State of Israel 2021-08-18 ISRAEL Brown, David Todd 6994 2021-08-18 Brown, David Todd 500 W Madison, St 3100   Chicago IL 60661
11651 11651 1995-09-19 Inward, Ltd. 1988-04-21 GREAT BRITAIN Spring O'Brien & Company, Inc. 3661 1985-03-19 Spring O'Brien & Company, Inc. Evanston     IL  
11735 11735 1993-09-24 Japan External Trade Organization 1992-07-20 JAPAN Ornberg & Associates 4691 1992-07-20 Ornberg & Associates Chicago     IL  
12175 12175 2018-09-30 Consulate-General of Japan in Chicago 2018-05-14 JAPAN Reputation Partners, LLC 6556 2018-05-14 Reputation Partners, LLC 737 N Michigan Avenue #1100   Chicago IL 60611
12802 12802 1993-10-20 Austrian National Tourist Office 1973-09-04 AUSTRIA Austrian National Tourist Office, Midwest Office 2457 1973-09-04 Austrian National Tourist Office, Midwest Office Chicago     IL  
13299 13299 1998-10-31 Business Location Germany 1997-05-05 GERMANY Fleishman-Hillard, Inc. 3774 1986-02-05 Fleishman-Hillard, Inc. Chicago     IL  
13470 13470 1979-11-01 Mitsubishi Bank, Ltd. 1979-11-21 JAPAN Edelman International Corporation 2548 1974-11-29 Edelman International Corporation Chicago     IL  
14117 14117 1992-11-23 JETRO, Chicago 1976-06-15 JAPAN International Marketing Center, Ltd. 2698 1976-06-15 International Marketing Center, Ltd. Chicago     IL  
14242 14242 1951-11-30 K. Heinrich Knappstein 1951-02-21 GERMANY, FEDERAL REPUBLIC OF Simon, Hugo Ferdinand 661 1951-02-21 Simon, Hugo Ferdinand Chicago     IL  
14425 14425 2002-11-30 Japan External Trade Organization (JETRO, Chicago) 1995-11-07 JAPAN Mayeroff, Jerry M. 5067 1995-11-07 Mayeroff, Jerry M. Chicago     IL  
14796 14796 1992-12-07 Japanese Information Service of the Japanese Consulate 1987-07-14 JAPAN Derus Media Service, Inc. 3799 1986-03-19 Derus Media Service, Inc. Chicago     IL  
14909 14909 1993-12-10 Scandinavian Airlines Systems, Inc. 1978-12-12 INTERNATIONAL Film Comm, Inc. 2638 1975-12-10 Film Comm, Inc. Chicago     IL  
15007 15007 1964-12-14 Japan Trade Center 1964-12-14 JAPAN Mayer & O'Brien, Inc. 1831 1964-12-14 Mayer & O'Brien, Inc. Chicago     IL  
15282 15282 1964-12-24 Austrian Consulate General of Chicago 1964-10-05 AUSTRIA Drost, John A. 1798 1964-10-05 Drost, John A. Chicago     IL  
15283 15283 1964-12-24 Austrian Trade Delegate in the U.S. 1964-12-30 AUSTRIA Drost, John A. 1798 1964-10-05 Drost, John A. Chicago     IL  
15401 15401 1983-12-30 Consulate General of Japan, Chicago 1979-02-15 JAPAN Dellow, Reginald L. 2999 1979-02-15 Dellow, Reginald L. Chicago     IL  
16064 16064 1990-12-31 British Consulate General 1989-05-24 GREAT BRITAIN DeCamp Legal Services, P.C. 4258 1989-05-24 DeCamp Legal Services, P.C. Chicago     IL  
16065 16065 1990-12-31 British Government 1990-01-03 GREAT BRITAIN Murphy & Desmond, S.C. 4327 1990-01-03 Murphy & Desmond, S.C. Chicago     IL  
16098 16098 1990-12-31 Sodick, Inc. 1990-04-09 JAPAN Williams & Jensen, P.C. 3112 1980-06-13 Williams & Jensen, P.C. Rolling Meadows     IL  
16144 16144 1991-12-31 Zurich Insurance Company 1990-03-20 SWITZERLAND Collier Shannon Scott, PLLC 3694 1985-06-24 Collier Shannon Scott, PLLC Schaumburg     IL  
16153 16153 1992-12-31 Consulate General of Israel, Midwest State of Israel 1998-02-12 ISRAEL Deborah Gordon Public Relations 5229 1992-05-22 Deborah Gordon Public Relations Chicago     IL  
16252 16252 1995-12-31 Harris Trust Savings Bank 1995-11-22 CANADA Mayer, Brown & Platt 3076 1979-12-13 Mayer, Brown & Platt Chicago     IL  
16433 16433 2002-12-31 Council of Hellenes Abroad 2003-07-09 GREECE Hill and Knowlton Strategies, LLC 3301 1981-11-10 Hill and Knowlton Strategies, LLC North & South America region - 360 N. Michigan Avenue, Suite 1109 Chicago 60601 (headquarters in T     IL  

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