FARA_All_ForeignPrincipals
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
62 rows where Address_1 = "San Francisco" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Registrant_Date, Foreign_Principal_Termination_Date (date), Foreign_Principal_Registration_Date (date), Registrant_Date (date)
Registration_Number 30 ✖
- Association Films, Inc. 18
- Charles von Loewenfeldt, Inc. 12
- Steele, Donald Dickinson 2
- Hannaford Company, Inc. 2
- Orrick, Herrington & Sutcliffe 2
- Keene & Associates 2
- Comite France Amerique 1
- Danielson, Walter G. 1
- L'Echo de l'Quest, Inc. 1
- Latta & Company 1
- Danielson, George E. 1
- Public Relations Counselors, Inc. 1
- Graham, James & Rolph 1
- International Council of Cruise Lines 1
- Curtis, Claude H. 1
- Gleason Associates, Inc. 1
- Carl Byoir, Arnold, Palmer & Noble 1
- Keating Group, Inc. 1
- McKee, William D. 1
- Cotton, Seligman & Ray 1
- Ernest Beyl Public Relations, Inc. 1
- Potash & Company 1
- Greve, Clifford, Diepenbrock & Paras 1
- Bond Donatelli, Inc. 1
- Sher & Blackwell 1
- Paul Purdom & Company, Inc. 1
- Gottshall, Ronald Burton 1
- Schrier, Elliot 1
- Eisbrenner Public Relations, Inc. 1
- Levenson, Levenson & Hill, Inc. 1
Registrant_Name 30
- Association Films, Inc. 18
- Charles von Loewenfeldt, Inc. 12
- Hannaford Company, Inc. 2
- Keene & Associates 2
- Orrick, Herrington & Sutcliffe 2
- Steele, Donald Dickinson 2
- Bond Donatelli, Inc. 1
- Carl Byoir, Arnold, Palmer & Noble 1
- Comite France Amerique 1
- Cotton, Seligman & Ray 1
- Curtis, Claude H. 1
- Danielson, George E. 1
- Danielson, Walter G. 1
- Eisbrenner Public Relations, Inc. 1
- Ernest Beyl Public Relations, Inc. 1
- Gleason Associates, Inc. 1
- Gottshall, Ronald Burton 1
- Graham, James & Rolph 1
- Greve, Clifford, Diepenbrock & Paras 1
- International Council of Cruise Lines 1
- Keating Group, Inc. 1
- L'Echo de l'Quest, Inc. 1
- Latta & Company 1
- Levenson, Levenson & Hill, Inc. 1
- McKee, William D. 1
- Paul Purdom & Company, Inc. 1
- Potash & Company 1
- Public Relations Counselors, Inc. 1
- Schrier, Elliot 1
- Sher & Blackwell 1
Foreign_Principal >30
- Consulate General of Japan, San Francisco 4
- Government of India Tourist Office 2
- Government of Japan 2
- Hong Kong Tourist Association 2
- Swiss National Tourist Office 2
- Transpacific Westbound Rate Agreement (TWRA) 2
- Australian Trade Commission (Austrade) 1
- Barclays Bank of California 1
- Branko Karadzole, Consul General, Federal People's Republic of Yugoslavia 1
- British Consulate General, San Francisco (Hong Kong Economic & Trade Office) 1
- CIDEM (Center for Information & Business Development, Autonomous Region of Catalonia, Spain) 1
- Canadian Consulate General 1
- Chinese Information Service 1
- Commercial Counselor of Spain 1
- Commercial Office of the Government of Spain 1
- Committee of Foreign Banks in Support of U.S.-U.K. Income Tax Treaty 1
- Consul General of Belgium (Francis G. Lockem) 1
- Consul General of Sweden 1
- Consul General of Sweden, Per Anger 1
- Consul Gereral of Ireland 1
- Ente Nazionale Italiano Per Il Turismo (ENIT) 1
- French Consulate in San Francisco (Provisional Government of France) 1
- German National Tourist Office-San Francisco 1
- Government of Japan, Consulate 1
- Hong Kong Economic & Trade Office 1
- Industrial Bank of Japan, Ltd. San Francisco Agency 1
- Irish Tourist Board 1
- Italian Government, Office of the Commercial Attache 1
- Italian State Tourist Office 1
- JETRO, San Francisco 1
- …
Country/Location_Represented 23
- JAPAN 18
- HONG KONG 5
- INTERNATIONAL 4
- SPAIN 4
- CHINA 3
- FRANCE 3
- AUSTRALIA 2
- INDIA 2
- IRELAND 2
- ITALY 2
- PHILIPPINES 2
- SWEDEN 2
- SWITZERLAND 2
- UNITED KINGDOM 2
- BELGIUM 1
- CANADA 1
- DENMARK 1
- GERMANY, FEDERAL REPUBLIC OF 1
- KOREA, SOUTH 1
- MEXICO 1
- NETHERLANDS 1
- UNITED ARAB EMIRATES 1
- YUGOSLAVIA 1
City 1
- - 62
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1188 | 1188 | 1982-01-10 | Commercial Office of the Government of Spain | 1981-03-03 | SPAIN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
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 | |||
1699 | 1699 | 1975-01-31 | Government of India Tourist Office | 1973-04-17 | INDIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
1988 | 1988 | 1978-02-01 | Commercial Counselor of Spain | 1977-06-06 | SPAIN | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | 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 | |||
2313 | 2313 | 1967-02-09 | Italian Government, Office of the Commercial Attache | 1962-09-07 | ITALY | 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 | |||
3464 | 3464 | 1943-03-06 | Consul General of Sweden | 1943-03-06 | SWEDEN | Danielson, Walter G. 180 | 1943-03-06 | Danielson, Walter G. | San Francisco | CA | |||
3631 | 3631 | 1993-03-11 | UTA French Airlines | 1989-12-28 | FRANCE | Keating Group, Inc. 2478 | 1973-11-23 | Keating Group, Inc. | San Francisco | CA | |||
3703 | 3703 | 1947-03-14 | San Francisco Comite France Amerique | 1942-09-14 | FRANCE | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | 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 | |||
4144 | 4144 | 1993-03-29 | British Consulate General, San Francisco (Hong Kong Economic & Trade Office) | 1991-07-15 | HONG KONG | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | 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 | |||
5014 | 5014 | 1963-04-04 | United Arab Republic State Tourist Administration | 1961-02-03 | UNITED ARAB EMIRATES | Charles von Loewenfeldt, Inc. 810 | 1954-01-05 | Charles von Loewenfeldt, Inc. | San Francisco | CA | |||
6704 | 6704 | 1959-05-22 | Branko Karadzole, Consul General, Federal People's Republic of Yugoslavia | 1958-01-01 | YUGOSLAVIA | Danielson, George E. 1154 | 1958-07-01 | Danielson, George E. | San Francisco | CA | |||
7044 | 7044 | 1975-05-31 | Government of India Tourist Office | 1965-06-29 | INDIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, 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 | |||
7420 | 7420 | 1994-06-01 | Australian Trade Commission (Austrade) | 1993-10-19 | AUSTRALIA | Eisbrenner Public Relations, Inc. 4862 | 1993-10-19 | Eisbrenner Public Relations, Inc. | 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 | |||
7700 | 7700 | 1993-06-09 | Canadian Consulate General | 1992-12-21 | CANADA | Paul Purdom & Company, Inc. 4740 | 1992-12-21 | Paul Purdom & Company, Inc. | 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 | |||
8545 | 8545 | 1996-06-30 | Hong Kong Economic & Trade Office | 1996-05-28 | HONG KONG | Levenson, Levenson & Hill, Inc. 5109 | 1996-05-28 | Levenson, Levenson & Hill, Inc. | San Francisco | CA | |||
9313 | 9313 | 1947-07-17 | French Consulate in San Francisco (Provisional Government of France) | 1945-07-17 | FRANCE | L'Echo de l'Quest, Inc. 309 | 1945-07-17 | L'Echo de l'Quest, Inc. | San Francisco | ||||
9424 | 9424 | 1978-07-22 | Barclays Bank of California | 1977-07-22 | UNITED KINGDOM | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | San Francisco | CA | |||
9607 | 9607 | 1969-07-30 | Chinese Information Service | 1969-07-11 | CHINA | Curtis, Claude H. 2151 | 1969-07-11 | Curtis, Claude H. | San Francisco | CA | |||
9714 | 9714 | 1977-07-31 | Committee of Foreign Banks in Support of U.S.-U.K. Income Tax Treaty | 1977-06-21 | UNITED KINGDOM | McKee, William D. 2794 | 1977-06-21 | McKee, William D. | 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 | |||
10532 | 10532 | 1994-08-15 | Transpacific Westbound Rate Agreement (TWRA) | 1993-09-30 | INTERNATIONAL | Schrier, Elliot 4854 | 1993-09-30 | Schrier, Elliot | San Francisco | CA | |||
10913 | 10913 | 1981-08-31 | Consul Gereral of Ireland | 1977-06-26 | IRELAND | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10915 | 10915 | 1981-08-31 | Ente Nazionale Italiano Per Il Turismo (ENIT) | 1965-06-29 | ITALY | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10924 | 10924 | 1981-08-31 | German National Tourist Office-San Francisco | 1973-04-17 | GERMANY, FEDERAL REPUBLIC OF | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10929 | 10929 | 1981-08-31 | Hong Kong Tourist Association | 1975-07-17 | HONG KONG | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10931 | 10931 | 1981-08-31 | Irish Tourist Board | 1970-04-24 | IRELAND | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | 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 | |||
10942 | 10942 | 1981-08-31 | Mexican National Tourist Council | 1977-06-26 | MEXICO | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10950 | 10950 | 1981-08-31 | Qantas Airways, Ltd. | 1975-01-14 | AUSTRALIA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10954 | 10954 | 1981-08-31 | Republic of China Tourism Bureau | 1980-04-30 | CHINA | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | ||||
10958 | 10958 | 1981-08-31 | Spanish National Tourist Office | 1967-10-03 | SPAIN | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10959 | 10959 | 1981-08-31 | Swiss National Tourist Office | 1973-04-17 | SWITZERLAND | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10960 | 10960 | 1981-08-31 | Swiss National Tourist Office | 1967-10-03 | SWITZERLAND | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
10963 | 10963 | 1981-08-31 | Tourism Council of the Republic of China | 1971-02-14 | CHINA | 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 | |||
11650 | 11650 | 1994-09-15 | Transpacific Westbound Rate Agreement (TWRA) | 1993-09-30 | INTERNATIONAL | Gottshall, Ronald Burton 4853 | 1993-09-30 | Gottshall, Ronald Burton | 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 | |||
12676 | 12676 | 1993-10-14 | CIDEM (Center for Information & Business Development, Autonomous Region of Catalonia, Spain) | 1991-07-15 | SPAIN | Hannaford Company, Inc. 2850 | 1977-11-29 | Hannaford Company, Inc. | San Francisco | CA | |||
13222 | 13222 | 1979-10-31 | Hong Kong Tourist Association | 1974-10-16 | HONG KONG | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | San Francisco | CA | |||
13269 | 13269 | 1989-10-31 | Yin Choy Oen | 1989-02-14 | HONG KONG | Bond Donatelli, Inc. 4215 | 1989-02-14 | Bond Donatelli, Inc. | San Francisco | CA | |||
13752 | 13752 | 1978-11-06 | Korean Consulate | 1975-12-09 | KOREA, SOUTH | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
14121 | 14121 | 1990-11-21 | P&O Lines, Inc. | 1967-07-25 | INTERNATIONAL | International Council of Cruise Lines 2036 | 1967-07-25 | International Council of Cruise Lines | San Francisco | CA | |||
14348 | 14348 | 1976-11-30 | Netherlands Information Service | 1968-02-14 | NETHERLANDS | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
14793 | 14793 | 1982-12-04 | Republic of the Philippines, Consulate, San Francisco | 1981-07-02 | PHILIPPINES | Ernest Beyl Public Relations, Inc. 3254 | 1981-07-02 | Ernest Beyl Public Relations, Inc. | San Francisco | CA | |||
15118 | 15118 | 1950-12-15 | Consul General of Belgium (Francis G. Lockem) | 1950-11-01 | BELGIUM | Latta & Company 647 | 1950-11-01 | Latta & Company | San Francisco | CA | |||
15414 | 15414 | 1994-12-27 | Transpacific Westbound Rate Agreement | 1993-09-30 | INTERNATIONAL | Sher & Blackwell 4576 | 1991-08-01 | Sher & Blackwell | San Francisco | CA | |||
15639 | 15639 | 1965-12-31 | Consul General of Sweden, Per Anger | 1963-05-24 | SWEDEN | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | San Francisco | CA | |||
15715 | 15715 | 1973-12-31 | Royal Danish Consulate General | 1967-10-03 | DENMARK | Association Films, Inc. 1814 | 1964-11-06 | Association Films, Inc. | San Francisco | CA | |||
16174 | 16174 | 1990-12-31 | Republic of the Philippines | 1990-02-09 | PHILIPPINES | Orrick, Herrington & Sutcliffe 4266 | 1989-06-12 | Orrick, Herrington & Sutcliffe | 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]) );