FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where Country/Location_Represented = "JAPAN" and State = "IL"
This data as json, CSV (advanced)
Suggested facets: Zip, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registrant_Name 13
- Cosmo Public Relations 1
- Dellow, Reginald L. 1
- Derus Media Service, Inc. 1
- Edelman International Corporation 1
- International Marketing Center, Ltd. 1
- Johnson, Robert Bruce 1
- Marks, Murase & White 1
- Mayer & O'Brien, Inc. 1
- Mayeroff, Jerry M. 1
- Ornberg & Associates 1
- Public Relations Board, Inc. 1
- Reputation Partners, LLC 1
- Williams & Jensen, P.C. 1
Foreign_Principal 13
- Consul General of Japan 1
- Consulate General of Japan, Chicago 1
- Consulate-General of Japan in Chicago 1
- Fujisawa Pharmaceutical Company 1
- JETRO, Chicago 1
- Japan External Trade Organization 1
- Japan External Trade Organization (JETRO, Chicago) 1
- Japan Trade Center 1
- Japan Trade Center (JETRO) 1
- Japanese Information Service of the Japanese Consulate 1
- Mitsubishi Bank, Ltd. 1
- Sodick, Inc. 1
- Sodick, Inc. (See: Sodick Company, Ltd.) 1
Address_1 4 ✖
State 1
- IL · 13 ✖
Country/Location_Represented 1
- JAPAN · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
7103 | 7103 | 1991-05-31 | Fujisawa Pharmaceutical Company | 1990-12-07 | JAPAN | Cosmo Public Relations 4434 | 1990-11-13 | Cosmo Public Relations | Deerfield | IL | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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]) );