FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
59 rows where State = "IL"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date)
Registrant_Name >30
- Association Films, Inc. 2
- Drost, John A. 2
- Hill and Knowlton Strategies, LLC 2
- Luehne Jr., John H. 2
- Mayer & O'Brien, Inc. 2
- Mayer, Brown & Platt 2
- Public Service Audience Planners 2
- Austrian National Tourist Office, Midwest Office 1
- Austrian Trade Commissioner in the U.S., Chicago 1
- Bentley, Barnes & Lynn, Inc. 1
- Berkanovic, Edward T. 1
- Bharat Barai 1
- Bloemer, Dr. Klaus 1
- Brown, David Todd 1
- Centron Corporation, Inc. 1
- Cleary, Gottlieb, Steen & Hamilton, LLP 1
- Collier Shannon Scott, PLLC 1
- Cosmo Public Relations 1
- Daloisio Global LLC 1
- DeCamp Legal Services, P.C. 1
- Deborah Gordon Public Relations 1
- Dellow, Reginald L. 1
- Derus Media Service, Inc. 1
- Edelman International Corporation 1
- Film Comm, Inc. 1
- Fleishman-Hillard, Inc. 1
- G.S. Schwartz & Company, Inc. 1
- GCI Group, Inc. 1
- Hopkins & Sutter 1
- IPG DXTRA, Inc 1
- …
Foreign_Principal >30
- Italian Trade Commission 3
- British Consulate General 2
- Agie U.S.A., Ltd. 1
- Alhaji Muhammadu Dikko Yusufu (through Capital Missions Company) 1
- Austrian Consulate General of Chicago 1
- Austrian Federal Chamber of Commerce 1
- Austrian National Tourist Office 1
- Austrian Trade Delegate in the U.S. 1
- Brambles U.S.A., Inc. 1
- British Government 1
- British Government Consulate 1
- Business Location Germany 1
- Consul General of India 1
- Consul General of Iran 1
- Consul General of Japan 1
- Consulate (Central Region) of the State of Israel 1
- Consulate General of Israel, Midwest State of Israel 1
- Consulate General of Japan, Chicago 1
- Consulate General of Yugoslavia 1
- Consulate-General of Japan in Chicago 1
- Council of Hellenes Abroad 1
- Daniel S. Smith, Consul General, South Africa Consulate 1
- Deutschlandsender 1
- Fujisawa Pharmaceutical Company 1
- German National Tourist Office-Chicago 1
- German Tourist Office 1
- Guillermo Mejia Velez 1
- Harris Trust Savings Bank 1
- Her Majesty's Government (Through the British Consulate General) 1
- Inward, Ltd. 1
- …
Country/Location_Represented 24
- JAPAN 13
- GERMANY, FEDERAL REPUBLIC OF 6
- GREAT BRITAIN 6
- ITALY 5
- AUSTRIA 4
- ISRAEL 4
- KOREA, SOUTH 2
- NICARAGUA 2
- SWITZERLAND 2
- AUSTRALIA 1
- BULGARIA 1
- CANADA 1
- DENMARK 1
- GERMANY 1
- GREECE 1
- INDIA 1
- INTERNATIONAL 1
- IRAN 1
- LITHUANIA 1
- NIGERIA 1
- SOUTH AFRICA 1
- VENEZUELA 1
- YUGOSLAVIA 1
- ZIMBABWE 1
City 3
- - 53
- Chicago 5
- Park Ridge 1
State 1
- IL · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1116 | 1116 | 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 | |
1176 | 1176 | 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 | |||
1177 | 1177 | 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 | |||
1885 | 1885 | 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 | |||
1982 | 1982 | 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 | |||
2978 | 2978 | 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 | |||
3322 | 3322 | 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 | |||
3832 | 3832 | 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 | |||
4328 | 4328 | 1969-03-31 | Consul General of Japan | 1967-09-06 | JAPAN | Johnson, Robert Bruce 2046 | 1967-09-06 | Johnson, Robert Bruce | Chicago | IL | |||
4808 | 4808 | 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 | |
5278 | 5278 | 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 | |||
5582 | 5582 | 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 | |||
5861 | 5861 | 1991-04-30 | British Government Consulate | 1990-04-18 | GREAT BRITAIN | Sagamore-Bainbridge 4368 | 1990-04-18 | Sagamore-Bainbridge | Chicago | IL | |||
6319 | 6319 | 1983-05-04 | Korea National Tourism Corporation | 1981-10-06 | KOREA, SOUTH | Centron Corporation, Inc. 3284 | 1981-10-06 | Centron Corporation, Inc. | Chicago | IL | |||
6325 | 6325 | 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 | |||
6356 | 6356 | 1965-05-06 | Consulate General of Yugoslavia | 1964-10-29 | YUGOSLAVIA | Berkanovic, Edward T. 1809 | 1964-10-29 | Berkanovic, Edward T. | Chicago | IL | |||
6833 | 6833 | 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 | |||
7103 | 7103 | 1991-05-31 | Fujisawa Pharmaceutical Company | 1990-12-07 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | Deerfield | IL | |||
7712 | 7712 | 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 | |
7768 | 7768 | 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 | |||
7894 | 7894 | 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 | |||
8532 | 8532 | 1995-06-30 | Brambles U.S.A., Inc. | 1989-09-08 | AUSTRALIA | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Chicago | IL | |||
8870 | 8870 | 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 | |||
9757 | 9757 | 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 | |||
9777 | 9777 | 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 | |||
10038 | 10038 | 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 | |||
10304 | 10304 | 1988-08-12 | British Consulate General | 1988-05-12 | GREAT BRITAIN | O'Connor & Hannan 4142 | 1988-05-12 | O'Connor & Hannan | Chicago | IL | |||
10611 | 10611 | 1964-08-19 | Deutschlandsender | 1964-08-19 | GERMANY, FEDERAL REPUBLIC OF | Bloemer, Dr. Klaus 1780 | 1964-08-19 | Bloemer, Dr. Klaus | Chicago | IL | |||
10627 | 10627 | 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 | |||
10685 | 10685 | 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 | |||
10687 | 10687 | 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 | |||
10776 | 10776 | 1981-08-27 | Italian Trade Commission | 1980-07-25 | ITALY | Bentley, Barnes & Lynn, Inc. 3127 | 1980-07-25 | Bentley, Barnes & Lynn, Inc. | Chicago | IL | |||
10922 | 10922 | 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 | |||
10926 | 10926 | 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 | |||
11089 | 11089 | 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 | |||
11191 | 11191 | 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 |
11192 | 11192 | 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 | |
11723 | 11723 | 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 | |||
11805 | 11805 | 1993-09-24 | Japan External Trade Organization | 1992-07-20 | JAPAN | Ornberg & Associates 4691 | 1992-07-20 | Ornberg & Associates | Chicago | IL | |||
12245 | 12245 | 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 | |
12878 | 12878 | 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 | |||
13375 | 13375 | 1998-10-31 | Business Location Germany | 1997-05-05 | GERMANY | Fleishman-Hillard, Inc. 3774 | 1986-02-05 | Fleishman-Hillard, Inc. | Chicago | IL | |||
13546 | 13546 | 1979-11-01 | Mitsubishi Bank, Ltd. | 1979-11-21 | JAPAN | Edelman International Corporation 2548 | 1974-11-29 | Edelman International Corporation | Chicago | IL | |||
14194 | 14194 | 1992-11-23 | JETRO, Chicago | 1976-06-15 | JAPAN | International Marketing Center, Ltd. 2698 | 1976-06-15 | International Marketing Center, Ltd. | Chicago | IL | |||
14319 | 14319 | 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 | |||
14502 | 14502 | 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 | |||
14876 | 14876 | 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 | |||
14989 | 14989 | 1993-12-10 | Scandinavian Airlines Systems, Inc. | 1978-12-12 | INTERNATIONAL | Film Comm, Inc. 2638 | 1975-12-10 | Film Comm, Inc. | Chicago | IL | |||
15087 | 15087 | 1964-12-14 | Japan Trade Center | 1964-12-14 | JAPAN | Mayer & O'Brien, Inc. 1831 | 1964-12-14 | Mayer & O'Brien, Inc. | Chicago | IL | |||
15363 | 15363 | 1964-12-24 | Austrian Consulate General of Chicago | 1964-10-05 | AUSTRIA | Drost, John A. 1798 | 1964-10-05 | Drost, John A. | Chicago | IL | |||
15364 | 15364 | 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 | |||
15482 | 15482 | 1983-12-30 | Consulate General of Japan, Chicago | 1979-02-15 | JAPAN | Dellow, Reginald L. 2999 | 1979-02-15 | Dellow, Reginald L. | Chicago | IL | |||
16145 | 16145 | 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 | |||
16146 | 16146 | 1990-12-31 | British Government | 1990-01-03 | GREAT BRITAIN | Murphy & Desmond, S.C. 4327 | 1990-01-03 | Murphy & Desmond, S.C. | Chicago | IL | |||
16179 | 16179 | 1990-12-31 | Sodick, Inc. | 1990-04-09 | JAPAN | Williams & Jensen, P.C. 3112 | 1980-06-13 | Williams & Jensen, P.C. | Rolling Meadows | IL | |||
16225 | 16225 | 1991-12-31 | Zurich Insurance Company | 1990-03-20 | SWITZERLAND | Collier Shannon Scott, PLLC 3694 | 1985-06-24 | Collier Shannon Scott, PLLC | Schaumburg | IL | |||
16234 | 16234 | 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 | |||
16333 | 16333 | 1995-12-31 | Harris Trust Savings Bank | 1995-11-22 | CANADA | Mayer, Brown & Platt 3076 | 1979-12-13 | Mayer, Brown & Platt | Chicago | IL | |||
16514 | 16514 | 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
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]) );