FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
18 rows where Address_1 = "San Francisco", Country/Location_Represented = "JAPAN" and State = "CA"
This data as json, CSV (advanced)
Suggested facets: Foreign_Principal_Termination_Date, Foreign_Principal_Registration_Date, Registration_Number, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Foreign_Principal 14
- Consulate General of Japan, San Francisco 4
- Government of Japan 2
- Government of Japan, Consulate 1
- Industrial Bank of Japan, Ltd. San Francisco Agency 1
- Italian State Tourist Office 1
- JETRO, San Francisco 1
- Japan Airlines Company, Ltd. 1
- Japan External Trade Organization 1
- Japan National Tourist Organization 1
- Japan Trade Center (JETRO) 1
- Japan Trade Center (Japan External Trade Organization) San Francisco 1
- Japan Trade Center, San Francisco 1
- Japanese Consulate General at San Francisco (Consul General of Japan) 1
- Toshiba International Corporation 1
Registrant_Name 9
State 1
- CA · 18 ✖
Country/Location_Represented 1
- JAPAN · 18 ✖
City 1
- - 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1688 | 1688 | 1969-01-31 | Japan Trade Center (JETRO) | 1968-01-06 | JAPAN | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | San Francisco | CA | |||
2192 | 2192 | 1993-02-04 | Japan Airlines Company, Ltd. | 1954-01-05 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
2314 | 2314 | 1967-02-09 | Japan National Tourist Organization | 1966-10-21 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
3971 | 3971 | 1991-03-22 | Government of Japan | 1989-06-15 | JAPAN | Orrick, Herrington & Sutcliffe 4266 | 1989-06-12 | Orrick, Herrington & Sutcliffe | San Francisco | CA | |||
4419 | 4419 | 1985-03-31 | Consulate General of Japan, San Francisco | 1972-03-07 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
4420 | 4420 | 1985-03-31 | Consulate General of Japan, San Francisco | 1965-04-09 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
4444 | 4444 | 1988-03-31 | Consulate General of Japan, San Francisco | 1986-12-15 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
7403 | 7403 | 1989-06-01 | Government of Japan | 1988-07-29 | JAPAN | Greve, Clifford, Diepenbrock & Paras 4163 | 1988-07-29 | Greve, Clifford, Diepenbrock & Paras | San Francisco | CA | |||
7528 | 7528 | 1966-06-03 | Japanese Consulate General at San Francisco (Consul General of Japan) | 1964-12-03 | JAPAN | Graham, James & Rolph 1825 | 1964-12-03 | Graham, James & Rolph | San Francisco | CA | |||
7958 | 7958 | 1981-06-20 | Toshiba International Corporation | 1968-01-06 | JAPAN | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | San Francisco | CA | |||
8031 | 8031 | 1988-06-23 | JETRO, San Francisco | 1986-07-18 | JAPAN | Potash & Company 3859 | 1986-07-18 | Potash & Company | San Francisco | CA | |||
9729 | 9729 | 1982-07-31 | Japan External Trade Organization | 1981-08-13 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
10086 | 10086 | 1956-08-03 | Consulate General of Japan, San Francisco | 1954-01-05 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
10215 | 10215 | 1994-08-08 | Industrial Bank of Japan, Ltd. San Francisco Agency | 1993-05-19 | JAPAN | Keene & Associates 4511 | 1991-05-14 | Keene & Associates | San Francisco | CA | |||
10933 | 10933 | 1981-08-31 | Italian State Tourist Office | 1973-04-17 | JAPAN | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
11381 | 11381 | 1984-09-05 | Japan Trade Center (Japan External Trade Organization) San Francisco | 1972-08-10 | JAPAN | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | San Francisco | CA | |||
11951 | 11951 | 1980-09-30 | Japan Trade Center, San Francisco | 1955-01-26 | JAPAN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
12192 | 12192 | 2009-09-30 | Government of Japan, Consulate | 1991-05-14 | JAPAN | Keene & Associates 4511 | 1991-05-14 | Keene & Associates | San Francisco | CA |
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]) );