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

13 rows where Country/Location_Represented = "JAPAN" and State = "IL"

✎ View and edit SQL

This data as json, CSV (advanced)

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

City 2

State 1

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

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