FARA_All_ForeignPrincipals

List of all foreign principals (active and terminated)

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

54 rows where State = "IL"

View and edit SQL

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

City

State

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
1086 1945-01-10 Johann Luehne, Sr. 1942-07-10 GERMANY, FEDERAL REPUBLIC OF 33 33 1942-07-10 Luehne Jr., John H. Chicago     IL  
1087 1945-01-10 Modene Louis Rachin 1942-07-10 GERMANY, FEDERAL REPUBLIC OF 33 33 1942-07-10 Luehne Jr., John H. Chicago     IL  
1774 2011-01-31 Korean National Tourism Organization 1979-11-23 KOREA, SOUTH 3069 3069 1979-11-23 Korea National Tourism Organization, Chicago Chicago     IL  
1858 1974-02-01 Consul General of Iran 1973-09-12 IRAN 2461 2461 1973-09-12 Mayer & O'Brien, Inc. Chicago     IL  
2818 1992-02-28 Agie U.S.A., Ltd. 1990-04-27 SWITZERLAND 4370 4370 1990-04-27 G.S. Schwartz & Company, Inc. Addison     IL  
3143 1999-03-01 Alhaji Muhammadu Dikko Yusufu (through Capital Missions Company) 1998-11-12 NIGERIA 3301 3301 1981-11-10 Hill and Knowlton Strategies, LLC St. Charles     IL  
3626 1960-03-17 Guillermo Mejia Velez 1960-03-17 NICARAGUA 1341 1341 1960-03-17 Nicaraguan Liberation Movement of July 23rd Evanston     IL  
4113 1969-03-31 Consul General of Japan 1967-09-06 JAPAN 2046 2046 1967-09-06 Johnson, Robert Bruce Chicago     IL  
5011 1976-04-15 Japan Trade Center (JETRO) 1967-11-24 JAPAN 2065 2065 1967-11-24 Public Relations Board, Inc. Chicago     IL  
5306 1991-04-25 Italian Institute for Foreign Trade - Rome, Italy 1983-10-25 ITALY 3532 3532 1983-10-25 Piero Ottinetti Design Chicago     IL  
5579 1991-04-30 British Government Consulate 1990-04-18 GREAT BRITAIN 4368 4368 1990-04-18 Sagamore-Bainbridge Chicago     IL  
6013 1983-05-04 Korea National Tourism Corporation 1981-10-06 KOREA, SOUTH 3284 3284 1981-10-06 Centron Corporation, Inc. Chicago     IL  
6019 1993-05-04 Consulate (Central Region) of the State of Israel 1989-09-12 ISRAEL 4289 4289 1989-09-12 Jasculca/Terman & Associates, Inc. Chicago     IL  
6050 1965-05-06 Consulate General of Yugoslavia 1964-10-29 YUGOSLAVIA 1809 1809 1964-10-29 Berkanovic, Edward T. Chicago     IL  
6512 1997-05-25 Lithuanian-American Council, Inc. 1999-01-22 LITHUANIA 5016 5016 1995-04-20 Washington World Group, Ltd. Chicago     IL  
6775 1991-05-31 Fujisawa Pharmaceutical Company 1990-12-07 JAPAN 4434 4434 1990-11-13 Cosmo Public Relations Deerfield     IL  
7408 1990-06-12 Sodick, Inc. (See: Sodick Company, Ltd.) 1990-04-06 JAPAN 4141 4141 1988-05-12 Marks, Murase & White Rolling Meadows     IL  
7528 1992-06-17 Austrian Federal Chamber of Commerce 1955-02-21 AUSTRIA 874 874 1955-02-21 Austrian Trade Commissioner in the U.S., Chicago Chicago     IL  
8158 1995-06-30 Brambles U.S.A., Inc. 1989-09-08 AUSTRALIA 3076 3076 1979-12-13 Mayer, Brown & Platt Chicago     IL  
8476 1988-07-01 Her Majesty's Government (Through the British Consulate General) 1988-03-17 GREAT BRITAIN 4101 4101 1988-03-17 Hopkins & Sutter Chicago     IL  
9341 1989-07-31 Daniel S. Smith, Consul General, South Africa Consulate 1988-03-25 SOUTH AFRICA 4108 4108 1988-03-25 Rothschild, Mary Kathleen Chicago     IL  
9361 1990-07-31 Italian Trade Commission 1985-04-08 ITALY 3668 3668 1985-04-08 Miluski, Krystine R.L. West Dundee     IL  
9610 2001-08-01 Movement for Democratic Change 2001-06-22 ZIMBABWE 3911 3911 1986-12-01 CMGRP, Inc. 1900 South Clark Street Chicago 60616     IL  
9869 1988-08-12 British Consulate General 1988-05-12 GREAT BRITAIN 4142 4142 1988-05-12 O'Connor & Hannan Chicago     IL  
10170 1964-08-19 Deutschlandsender 1964-08-19 GERMANY, FEDERAL REPUBLIC OF 1780 1780 1964-08-19 Bloemer, Dr. Klaus Chicago     IL  
10184 1950-08-20 Venezuelan Trade Mission to the First U.S. International Fair 1950-12-26 VENEZUELA 508 508 1948-01-19 Cleary, Gottlieb, Steen & Hamilton, LLP Chicago     IL  
10237 1992-08-23 Israel Government Tourist Office 1978-06-01 ISRAEL 2452 2452 1979-08-23 Public Service Audience Planners Chicago     IL  
10239 1992-08-23 Royal Danish Consulate General, Chicago 1977-11-08 DENMARK 2452 2452 1979-08-23 Public Service Audience Planners Chicago     IL  
10325 1981-08-27 Italian Trade Commission 1980-07-25 ITALY 3127 3127 1980-07-25 Bentley, Barnes & Lynn, Inc. Chicago     IL  
10469 1981-08-31 German National Tourist Office-Chicago 1973-04-17 GERMANY, FEDERAL REPUBLIC OF 1814 1814 1964-11-06 Association Films, Inc. Chicago     IL  
10473 1981-08-31 German Tourist Office 1970-06-17 GERMANY, FEDERAL REPUBLIC OF 1814 1814 1964-11-06 Association Films, Inc. Chicago     IL  
10636 2004-08-31 Italian Trade Commission 2004-01-13 ITALY 3856 3856 1986-07-11 GCI Group, Inc. 401 N. Michigan Avenue, Suite 3030 Chicago 60611     IL  
11243 1995-09-19 Inward, Ltd. 1988-04-21 GREAT BRITAIN 3661 3661 1985-03-19 Spring O'Brien & Company, Inc. Evanston     IL  
11323 1993-09-24 Japan External Trade Organization 1992-07-20 JAPAN 4691 4691 1992-07-20 Ornberg & Associates Chicago     IL  
11749 2018-09-30 Consulate-General of Japan in Chicago 2018-05-14 JAPAN 6556 6556 2018-05-14 Reputation Partners, LLC 737 N Michigan Avenue #1100   Chicago IL 60611
12321 1993-10-20 Austrian National Tourist Office 1973-09-04 AUSTRIA 2457 2457 1973-09-04 Austrian National Tourist Office, Midwest Office Chicago     IL  
12809 1998-10-31 Business Location Germany 1997-05-05 GERMANY 3774 3774 1986-02-05 Fleishman-Hillard, Inc. Chicago     IL  
12970 1979-11-01 Mitsubishi Bank, Ltd. 1979-11-21 JAPAN 2548 2548 1974-11-29 Edelman International Corporation Chicago     IL  
13596 1992-11-23 JETRO, Chicago 1976-06-15 JAPAN 2698 2698 1976-06-15 International Marketing Center, Ltd. Chicago     IL  
13720 1951-11-30 K. Heinrich Knappstein 1951-02-21 GERMANY, FEDERAL REPUBLIC OF 661 661 1951-02-21 Simon, Hugo Ferdinand Chicago     IL  
13903 2002-11-30 Japan External Trade Organization (JETRO, Chicago) 1995-11-07 JAPAN 5067 5067 1995-11-07 Mayeroff, Jerry M. Chicago     IL  
14250 1992-12-07 Japanese Information Service of the Japanese Consulate 1987-07-14 JAPAN 3799 3799 1986-03-19 Derus Media Service, Inc. Chicago     IL  
14363 1993-12-10 Scandinavian Airlines Systems, Inc. 1978-12-12 INTERNATIONAL 2638 2638 1975-12-10 Film Comm, Inc. Chicago     IL  
14460 1964-12-14 Japan Trade Center 1964-12-14 JAPAN 1831 1831 1964-12-14 Mayer & O'Brien, Inc. Chicago     IL  
14724 1964-12-24 Austrian Consulate General of Chicago 1964-10-05 AUSTRIA 1798 1798 1964-10-05 Drost, John A. Chicago     IL  
14725 1964-12-24 Austrian Trade Delegate in the U.S. 1964-12-30 AUSTRIA 1798 1798 1964-10-05 Drost, John A. Chicago     IL  
14837 1983-12-30 Consulate General of Japan, Chicago 1979-02-15 JAPAN 2999 2999 1979-02-15 Dellow, Reginald L. Chicago     IL  
15500 1990-12-31 British Consulate General 1989-05-24 GREAT BRITAIN 4258 4258 1989-05-24 DeCamp Legal Services, P.C. Chicago     IL  
15501 1990-12-31 British Government 1990-01-03 GREAT BRITAIN 4327 4327 1990-01-03 Murphy & Desmond, S.C. Chicago     IL  
15534 1990-12-31 Sodick, Inc. 1990-04-09 JAPAN 3112 3112 1980-06-13 Williams & Jensen, P.C. Rolling Meadows     IL  
15580 1991-12-31 Zurich Insurance Company 1990-03-20 SWITZERLAND 3694 3694 1985-06-24 Collier Shannon Scott, PLLC Schaumburg     IL  
15589 1992-12-31 Consulate General of Israel, Midwest State of Israel 1998-02-12 ISRAEL 5229 5229 1992-05-22 Deborah Gordon Public Relations Chicago     IL  
15688 1995-12-31 Harris Trust Savings Bank 1995-11-22 CANADA 3076 3076 1979-12-13 Mayer, Brown & Platt Chicago     IL  
15869 2002-12-31 Council of Hellenes Abroad 2003-07-09 GREECE 3301 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)
);
Powered by Datasette · Query took 196.449ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history