FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
514 rows where City = "San Francisco" sorted by Zip
This data as json, CSV (advanced)
Suggested facets: Short_Form_Last_Name, Short_Form_First_Name, Registration_Date, Address_1, Zip, Short_Form_Date (date), Registration_Date (date)
Short_Form_Termination_Date (date) 354 ✖
- 1979-11-05 12
- 1949-12-19 11
- 1978-07-22 10
- 2018-05-07 8
- 1984-09-05 7
- 1959-03-21 6
- 1973-12-31 5
- 1984-09-20 5
- 1985-01-07 5
- 2020-10-19 5
- 1977-08-31 4
- 1980-01-08 4
- 1981-09-24 4
- 1998-03-31 4
- 1947-03-14 3
- 1949-06-03 3
- 1953-12-16 3
- 1965-01-30 3
- 1970-01-30 3
- 1972-09-14 3
- 1974-10-17 3
- 1981-08-31 3
- 1983-05-24 3
- 1990-01-31 3
- 1994-11-18 3
- 1996-04-05 3
- 1997-05-18 3
- 2005-12-31 3
- 2008-03-31 3
- 2011-10-31 3
- 2012-12-31 3
- 2018-03-15 3
- 1955-02-11 2
- 1956-08-02 2
- 1958-07-02 2
- 1962-11-09 2
- 1966-10-05 2
- 1966-11-02 2
- 1967-08-31 2
- 1972-12-31 2
- 1973-08-08 2
- 1974-11-05 2
- 1978-07-31 2
- 1978-08-31 2
- 1981-06-20 2
- 1981-08-01 2
- 1985-08-31 2
- 1988-03-31 2
- 1990-09-27 2
- 1992-03-19 2
- 1998-05-31 2
- 1999-03-01 2
- 2017-03-31 2
- 2019-09-30 2
- 2022-04-25 2
- 2022-10-10 2
- 1946-12-01 1
- 1947-05-06 1
- 1947-06-03 1
- 1947-09-08 1
- 1950-12-31 1
- 1953-01-26 1
- 1961-06-30 1
- 1963-07-31 1
- 1964-12-31 1
- 1965-10-09 1
- 1966-01-21 1
- 1966-03-19 1
- 1966-05-13 1
- 1966-06-21 1
- 1966-07-31 1
- 1967-01-31 1
- 1967-03-28 1
- 1967-12-31 1
- 1968-03-01 1
- 1968-07-11 1
- 1968-10-30 1
- 1969-04-11 1
- 1969-05-31 1
- 1969-07-07 1
- 1969-09-23 1
- 1969-10-01 1
- 1970-05-31 1
- 1971-04-30 1
- 1971-07-07 1
- 1971-08-26 1
- 1971-12-31 1
- 1972-05-15 1
- 1972-07-01 1
- 1972-08-31 1
- 1972-09-15 1
- 1972-11-15 1
- 1972-12-18 1
- 1973-01-09 1
- 1973-04-10 1
- 1973-05-22 1
- 1973-06-01 1
- 1973-06-15 1
- 1973-06-24 1
- 1973-07-30 1
- 1973-08-31 1
- 1973-09-04 1
- 1973-12-06 1
- 1974-06-08 1
- 1974-07-22 1
- 1974-08-01 1
- 1975-02-01 1
- 1975-03-31 1
- 1975-05-27 1
- 1975-12-31 1
- 1976-02-29 1
- 1976-05-21 1
- 1976-06-03 1
- 1976-06-26 1
- 1976-07-16 1
- 1976-08-06 1
- 1976-10-11 1
- 1976-10-22 1
- 1976-11-04 1
- 1977-03-28 1
- 1977-04-30 1
- 1977-07-31 1
- 1977-08-01 1
- 1977-09-01 1
- 1977-12-02 1
- 1978-06-22 1
- 1978-07-03 1
- 1978-07-20 1
- 1978-09-13 1
- 1978-09-30 1
- 1978-11-24 1
- 1978-12-15 1
- 1979-01-15 1
- 1979-03-18 1
- 1979-06-01 1
- 1979-06-02 1
- 1979-09-30 1
- 1979-11-01 1
- 1979-11-25 1
- 1980-03-12 1
- 1980-03-31 1
- 1980-04-13 1
- 1980-05-30 1
- 1980-07-29 1
- 1980-08-23 1
- 1980-09-30 1
- 1980-12-30 1
- 1981-03-01 1
- 1981-06-30 1
- 1981-09-15 1
- 1981-09-30 1
- 1981-12-31 1
- 1982-03-31 1
- 1982-05-01 1
- 1982-06-09 1
- 1982-06-22 1
- 1982-12-31 1
- 1983-03-11 1
- 1983-04-25 1
- 1983-05-15 1
- 1983-08-01 1
- 1983-10-31 1
- 1983-11-02 1
- 1983-11-30 1
- 1984-02-14 1
- 1984-04-01 1
- 1984-05-31 1
- 1984-08-28 1
- 1984-10-16 1
- 1985-01-01 1
- 1985-04-17 1
- 1985-08-01 1
- 1985-10-09 1
- 1985-12-01 1
- 1986-04-30 1
- 1986-06-30 1
- 1986-07-18 1
- 1987-03-11 1
- 1987-06-01 1
- 1987-06-06 1
- 1987-06-14 1
- 1987-06-26 1
- 1988-03-18 1
- 1988-06-19 1
- 1988-08-23 1
- 1988-08-27 1
- 1988-08-28 1
- 1988-11-30 1
- 1988-12-30 1
- 1989-02-24 1
- 1989-05-18 1
- 1989-06-15 1
- 1989-06-23 1
- 1989-11-14 1
- 1989-12-31 1
- 1990-01-05 1
- 1990-03-02 1
- 1990-03-31 1
- 1990-06-17 1
- 1991-03-21 1
- 1991-04-24 1
- 1991-04-28 1
- 1991-06-05 1
- 1991-07-04 1
- 1991-07-08 1
- 1991-12-31 1
- 1992-01-01 1
- 1992-03-23 1
- 1992-06-09 1
- 1992-11-12 1
- 1992-11-17 1
- 1993-06-15 1
- 1993-07-21 1
- 1994-07-14 1
- 1994-08-16 1
- 1994-12-24 1
- 1995-06-02 1
- 1995-07-07 1
- 1995-08-21 1
- 1995-12-31 1
- 1996-03-06 1
- 1996-06-05 1
- 1997-07-06 1
- 1998-01-31 1
- 1998-06-03 1
- 1998-06-22 1
- 1998-08-07 1
- 1998-09-01 1
- 1998-10-16 1
- 1999-01-31 1
- 1999-03-30 1
- 1999-05-07 1
- 1999-06-27 1
- 1999-06-28 1
- 1999-10-12 1
- 2000-03-01 1
- 2000-03-31 1
- 2000-05-15 1
- 2000-06-30 1
- 2000-07-25 1
- 2001-03-28 1
- 2001-06-30 1
- 2001-07-08 1
- 2001-07-20 1
- 2001-10-15 1
- 2001-11-08 1
- 2002-02-07 1
- 2002-03-11 1
- 2002-08-01 1
- 2002-08-30 1
- 2003-02-27 1
- 2003-03-01 1
- 2003-03-23 1
- 2003-06-27 1
- 2003-06-30 1
- 2003-07-06 1
- 2004-03-01 1
- 2004-05-31 1
- 2004-06-19 1
- 2004-09-30 1
- 2004-10-12 1
- 2004-12-26 1
- 2005-02-02 1
- 2005-02-25 1
- 2005-04-01 1
- 2005-04-21 1
- 2005-04-27 1
- 2005-05-01 1
- 2005-05-02 1
- 2005-06-12 1
- 2005-10-12 1
- 2006-01-12 1
- 2006-03-31 1
- 2006-06-17 1
- 2006-07-06 1
- 2006-08-16 1
- 2006-08-28 1
- 2006-09-30 1
- 2007-01-02 1
- 2007-03-31 1
- 2007-07-31 1
- 2008-03-13 1
- 2008-03-27 1
- 2008-05-09 1
- 2008-09-12 1
- 2008-10-31 1
- 2008-11-13 1
- 2008-11-14 1
- 2009-07-02 1
- 2009-07-31 1
- 2009-09-25 1
- 2009-10-09 1
- 2010-03-31 1
- 2010-04-14 1
- 2010-07-09 1
- 2010-08-31 1
- 2011-02-01 1
- 2011-03-16 1
- 2011-04-28 1
- 2011-04-30 1
- 2011-06-17 1
- 2012-04-27 1
- 2012-06-01 1
- 2012-07-31 1
- 2012-12-07 1
- 2013-01-31 1
- 2013-06-25 1
- 2013-11-24 1
- 2013-12-31 1
- 2014-02-27 1
- 2014-03-31 1
- 2014-07-31 1
- 2014-08-01 1
- 2014-11-01 1
- 2014-11-27 1
- 2014-12-22 1
- 2015-01-23 1
- 2015-06-30 1
- 2015-07-31 1
- 2016-01-09 1
- 2016-01-31 1
- 2016-03-20 1
- 2016-03-31 1
- 2016-06-17 1
- 2016-06-27 1
- 2016-07-31 1
- 2017-01-31 1
- 2017-07-24 1
- 2017-08-15 1
- 2017-09-06 1
- 2017-12-15 1
- 2018-06-30 1
- 2018-11-09 1
- 2019-03-22 1
- 2019-03-28 1
- 2019-05-31 1
- 2019-07-31 1
- 2019-08-26 1
- 2019-09-20 1
- 2019-11-17 1
- 2020-02-19 1
- 2020-03-11 1
- 2020-05-12 1
- 2020-05-26 1
- 2020-07-31 1
- 2020-10-23 1
- 2020-11-12 1
- 2021-02-11 1
- 2021-05-21 1
- 2021-06-11 1
- 2021-10-11 1
- 2021-11-11 1
- 2022-05-13 1
- 2022-08-26 1
Registration_Number 69
- JETRO, San Francisco 124
- Pillsbury Winthrop Shaw Pittman, LLP 44
- Japan National Tourist Organization, San Francisco 32
- China Books & Periodicals, Inc. 30
- Kuomintang of China 27
- Kearns International 16
- Earthjustice 15
- Korea Trade Center, San Francisco 13
- Chinese Nationalist Daily 11
- Cotton, Seligman & Ray 11
- Brunswick Group, LLC 11
- Osaka Prefectural Government, California Office 9
- Swiss National Tourist Office, San Francisco 8
- Carl Byoir, Arnold, Palmer & Noble 8
- Osaka University, San Francisco Office 8
- British Columbia House 7
- Felda Marketing Corporation 7
- Daniel J. Edelman, Inc. - San Francisco 7
- Conlon Associates, Ltd. 6
- Scottish Development Agency 6
- Hong Kong Government (Industry Department) 6
- Public Relations Counselors, Inc. 5
- Neeson Company 5
- Malaysian Trade Commission 5
- Polish Chamber of Foreign Trade 5
- L'Echo de l'Quest, Inc. 4
- Philippine Tourist & Travel Association 4
- Spanish National Tourist Office, San Francisco 4
- Gleason Associates, Inc. 4
- PBN Company 4
- Comite France Amerique 3
- Central News Agency of China, San Francisco Bureau 3
- Lykke-Wilkin & Associates 3
- Mexican Government Tourism Office, San Francisco 3
- Braden Toureast, Inc. 3
- Kearns International 3
- Hi-Tech Public Relations, Inc. 3
- PBN Company 3
- Grayling Connecting Point, LLC 3
- Marias, Joseph Francis 2
- Padilla, Jose G. 2
- Free China Political Organizations 2
- Democratic & Socialist Party of China 2
- Graham, James & Rolph 2
- Steele, Donald Dickinson 2
- Netherlands Information Service 2
- Freeman, Teilmann & Associates Public Relations 2
- Neptune Orient Lines, Ltd. 2
- Nossaman, Guthner, Knox & Elliott 2
- McCutchen, Doyle, Brown & Enersen, L.L.P. 2
- Russky Kustar 1
- Central News Agency of China, San Francisco Bureau 1
- James, Leonard Gage 1
- Alianza Patriotica Nicaraguense 1
- B.M. Lawrence & Company 1
- Jamaica Tourist Board, San Francisco 1
- Korea Tourist Service 1
- German-American Chamber of Commerce of Pacific Coast, Inc. 1
- McKee, William D. 1
- Ford & Vlahos 1
- Ernest Beyl Public Relations, Inc. 1
- Russom & Leeper 1
- Ernest Beyl Public Relations, Inc. 1
- J.R. Bechtle & Company 1
- TransPacific Communications & Research Company 1
- Lillick & Charles 1
- Farella, Braun & Martel 1
- Sierra Club Legal Defense Fund, Inc. 1
- Sprague, Esther Marie 1
Registrant_Name 65
- JETRO, San Francisco 124
- Pillsbury Winthrop Shaw Pittman, LLP 44
- Japan National Tourist Organization, San Francisco 32
- China Books & Periodicals, Inc. 30
- Kuomintang of China 27
- Kearns International 19
- Earthjustice 15
- Korea Trade Center, San Francisco 13
- Brunswick Group, LLC 11
- Chinese Nationalist Daily 11
- Cotton, Seligman & Ray 11
- Osaka Prefectural Government, California Office 9
- Carl Byoir, Arnold, Palmer & Noble 8
- Osaka University, San Francisco Office 8
- Swiss National Tourist Office, San Francisco 8
- British Columbia House 7
- Daniel J. Edelman, Inc. - San Francisco 7
- Felda Marketing Corporation 7
- PBN Company 7
- Conlon Associates, Ltd. 6
- Hong Kong Government (Industry Department) 6
- Scottish Development Agency 6
- Malaysian Trade Commission 5
- Neeson Company 5
- Polish Chamber of Foreign Trade 5
- Public Relations Counselors, Inc. 5
- Central News Agency of China, San Francisco Bureau 4
- Gleason Associates, Inc. 4
- L'Echo de l'Quest, Inc. 4
- Philippine Tourist & Travel Association 4
- Spanish National Tourist Office, San Francisco 4
- Braden Toureast, Inc. 3
- Comite France Amerique 3
- Grayling Connecting Point, LLC 3
- Hi-Tech Public Relations, Inc. 3
- Lykke-Wilkin & Associates 3
- Mexican Government Tourism Office, San Francisco 3
- Democratic & Socialist Party of China 2
- Ernest Beyl Public Relations, Inc. 2
- Free China Political Organizations 2
- Freeman, Teilmann & Associates Public Relations 2
- Graham, James & Rolph 2
- Marias, Joseph Francis 2
- McCutchen, Doyle, Brown & Enersen, L.L.P. 2
- Neptune Orient Lines, Ltd. 2
- Netherlands Information Service 2
- Nossaman, Guthner, Knox & Elliott 2
- Padilla, Jose G. 2
- Steele, Donald Dickinson 2
- Alianza Patriotica Nicaraguense 1
- B.M. Lawrence & Company 1
- Farella, Braun & Martel 1
- Ford & Vlahos 1
- German-American Chamber of Commerce of Pacific Coast, Inc. 1
- J.R. Bechtle & Company 1
- Jamaica Tourist Board, San Francisco 1
- James, Leonard Gage 1
- Korea Tourist Service 1
- Lillick & Charles 1
- McKee, William D. 1
- Russky Kustar 1
- Russom & Leeper 1
- Sierra Club Legal Defense Fund, Inc. 1
- Sprague, Esther Marie 1
- TransPacific Communications & Research Company 1
State 1
- CA 514
City 1
- San Francisco · 514 ✖
Link | rowid | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4508 | 4508 | 1953-01-26 | 1953-01-26 | Feingold | Jeremiah | Russky Kustar 754 | 1953-01-26 | Russky Kustar | 1200 Divisadero Street | San Francisco | CA | ||
4787 | 4787 | 1965-01-30 | 1963-09-03 | Crawford | James Whitson | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4788 | 4788 | 1965-01-30 | 1963-09-03 | Hoffman | Robert P. | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
4789 | 4789 | 1965-01-30 | 1963-09-03 | Hoffman | Virginia | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
6600 | 6600 | 1955-02-11 | 1955-02-11 | Li | Tsung-Jen | Free China Political Organizations 871 | 1955-02-11 | Free China Political Organizations | 736 Grant Avenue | San Francisco | CA | ||
6601 | 6601 | 1955-02-11 | 1955-02-11 | Wu | Shang-Ying | Free China Political Organizations 871 | 1955-02-11 | Free China Political Organizations | 736 Grant Avenue | San Francisco | CA | ||
9799 | 9799 | 1947-03-14 | 1943-03-16 | Tobin | Richard M. | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
9800 | 9800 | 1947-03-14 | 1946-04-16 | Raoul-Duval | Richard | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
9801 | 9801 | 1947-03-14 | 1946-04-18 | Harrison | Maurice E. | Comite France Amerique 131 | 1942-09-14 | Comite France Amerique | Jones & McAllister Streets | San Francisco | CA | ||
10413 | 10413 | 1959-03-21 | 1959-03-11 | Gold | David Bernard | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10414 | 10414 | 1959-03-21 | 1959-03-11 | Mattson | Marie Joanne | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10415 | 10415 | 1959-03-21 | 1958-06-09 | Conlon | Richard Paul | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10416 | 10416 | 1959-03-21 | 1958-06-09 | Gerson | Richard I. | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10417 | 10417 | 1959-03-21 | 1958-06-09 | Harris | John Robert | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
10418 | 10418 | 1959-03-21 | 1958-06-09 | Sloss | Leon | Conlon Associates, Ltd. 1146 | 1958-06-09 | Conlon Associates, Ltd. | 130 Bush Street | San Francisco | CA | ||
15774 | 15774 | 1947-05-06 | 1945-07-17 | Rey | Leon M. | L'Echo de l'Quest, Inc. 309 | 1945-07-17 | L'Echo de l'Quest, Inc. | 2448 Clay Street | San Francisco | CA | ||
18704 | 18704 | 1947-06-03 | 1945-07-17 | Lusinchi | Augustin | L'Echo de l'Quest, Inc. 309 | 1945-07-17 | L'Echo de l'Quest, Inc. | 2448 Clay Street | San Francisco | CA | ||
18705 | 18705 | 1949-06-03 | 1949-03-28 | Chinn | Thomas Wayne | Central News Agency of China, San Francisco Bureau 546 | 1948-12-02 | Central News Agency of China, San Francisco Bureau | Cornell Hotel | 715 Bush Street, Room 103 | San Francisco | CA | |
18706 | 18706 | 1949-06-03 | 1948-12-02 | Jen | Richard Linghsun | Central News Agency of China, San Francisco Bureau 546 | 1948-12-02 | Central News Agency of China, San Francisco Bureau | Cornell Hotel | 715 Bush Street, Room 103 | San Francisco | CA | |
18707 | 18707 | 1949-06-03 | 1948-12-02 | Lee | Chien-san | Central News Agency of China, San Francisco Bureau 546 | 1948-12-02 | Central News Agency of China, San Francisco Bureau | Cornell Hotel | 715 Bush Street, Room 103 | San Francisco | CA | |
22419 | 22419 | 1958-07-02 | 1952-01-02 | Orozco | Jose | Padilla, Jose G. 702 | 1952-01-02 | Padilla, Jose G. | 2953 - 22nd Street | San Francisco | CA | ||
22420 | 22420 | 1958-07-02 | 1957-03-13 | Perez | Leandro | Padilla, Jose G. 702 | 1952-01-02 | Padilla, Jose G. | 2953 - 22nd Street | San Francisco | CA | ||
25771 | 25771 | 1956-08-02 | 1951-04-19 | Troxell | Edward Pryor | Marias, Joseph Francis 671 | 1951-04-18 | Marias, Joseph Francis | 461 Market Street | San Francisco | CA | ||
25772 | 25772 | 1956-08-02 | 1952-06-19 | O'Donnell | John A. | Marias, Joseph Francis 671 | 1951-04-18 | Marias, Joseph Francis | 461 Market Street | San Francisco | CA | ||
29372 | 29372 | 1947-09-08 | 1945-07-17 | Sallaberry | Jean | L'Echo de l'Quest, Inc. 309 | 1945-07-17 | L'Echo de l'Quest, Inc. | 2448 Clay Street | San Francisco | CA | ||
32313 | 32313 | 1966-10-05 | 1963-09-03 | Redwine | Frances C. | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
32314 | 32314 | 1966-10-05 | 1963-09-03 | Seoane | Frank | Public Relations Counselors, Inc. 1632 | 1963-05-24 | Public Relations Counselors, Inc. | 68 Post Street | Room 503 | San Francisco | CA | |
35465 | 35465 | 1962-11-09 | 1962-05-09 | Liang | Chao Wei | Democratic & Socialist Party of China 1543 | 1962-05-09 | Democratic & Socialist Party of China | 777 Sacramento Street | San Francisco | CA | ||
35466 | 35466 | 1962-11-09 | 1962-05-09 | Tsang | Hu Chor | Democratic & Socialist Party of China 1543 | 1962-05-09 | Democratic & Socialist Party of China | 777 Sacramento Street | San Francisco | CA | ||
37206 | 37206 | 1946-12-01 | 1945-07-17 | Poggi | Francois J. | L'Echo de l'Quest, Inc. 309 | 1945-07-17 | L'Echo de l'Quest, Inc. | 2448 Clay Street | San Francisco | CA | ||
38476 | 38476 | 1953-12-16 | 1953-01-19 | Lykke | Fawn S. | Lykke-Wilkin & Associates 750 | 1952-12-16 | Lykke-Wilkin & Associates | 681 Market Street | San Francisco | CA | ||
38477 | 38477 | 1953-12-16 | 1953-01-19 | McFerrin | Naomi H. | Lykke-Wilkin & Associates 750 | 1952-12-16 | Lykke-Wilkin & Associates | 681 Market Street | San Francisco | CA | ||
38478 | 38478 | 1953-12-16 | 1953-01-19 | Wilkin | William J. | Lykke-Wilkin & Associates 750 | 1952-12-16 | Lykke-Wilkin & Associates | 681 Market Street | San Francisco | CA | ||
38707 | 38707 | 1949-12-19 | 1946-10-01 | Chan | Pay King | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38708 | 38708 | 1949-12-19 | 1946-10-01 | Chuen | Lim Heong | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38709 | 38709 | 1949-12-19 | 1946-10-01 | Gee | Chu Suey | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38710 | 38710 | 1949-12-19 | 1946-10-01 | Joe | Phillip | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38711 | 38711 | 1949-12-19 | 1946-10-01 | Lew | Wong | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38712 | 38712 | 1949-12-19 | 1946-10-01 | Liu | Pei Chi | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38713 | 38713 | 1949-12-19 | 1946-10-01 | Quong | Dear Bing | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38714 | 38714 | 1949-12-19 | 1946-10-01 | Tong | Woo Yick | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38715 | 38715 | 1949-12-19 | 1946-10-01 | Yee | Buck | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38716 | 38716 | 1949-12-19 | 1946-10-01 | Yet | Gee Kwan | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
38717 | 38717 | 1949-12-19 | 1946-10-01 | Yow | Mock Bing | Chinese Nationalist Daily 373 | 1946-10-01 | Chinese Nationalist Daily | 809 Sacramento Street | San Francisco | CA | ||
11451 | 11451 | 1975-03-31 | 1966-08-31 | Diaz | Enrique Suarez | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | 1 Hallidie Plaza | San Francisco | CA | 94102 | |
19951 | 19951 | 1966-06-21 | 1965-08-11 | Pachon | Carlos Sanchez | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | 1 Hallidie Plaza | San Francisco | CA | 94102 | |
30932 | 30932 | 1979-09-30 | 1975-09-15 | Cuevas | Jose Antonio Nunex Las | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | 1 Hallidie Plaza | San Francisco | CA | 94102 | |
39325 | 39325 | 1980-12-30 | 1980-03-17 | De Arcenegui | Joaquin | Spanish National Tourist Office, San Francisco 1914 | 1965-08-11 | Spanish National Tourist Office, San Francisco | 1 Hallidie Plaza | San Francisco | CA | 94102 | |
19917 | 19917 | 1981-06-20 | 1967-07-18 | Steele | Donald D. | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | 703 Market Street | Suite 1305 | San Francisco | CA | 94103 |
19918 | 19918 | 1981-06-20 | 1967-07-18 | Steele | Evelyn Jane | Steele, Donald Dickinson 2030 | 1967-06-20 | Steele, Donald Dickinson | 703 Market Street | Suite 1305 | San Francisco | CA | 94103 |
2627 | 2627 | 1985-01-01 | 1979-06-01 | Green | Marjorie | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
3479 | 3479 | 1973-01-09 | 1964-09-01 | MacKay | Frederick Cameron | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
3630 | 3630 | 2006-01-12 | 2003-05-29 | Eino | Masao | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
6806 | 6806 | 1984-02-14 | 1982-03-12 | Tiong | Koh Poh | Neptune Orient Lines, Ltd. 3345 | 1982-03-12 | Neptune Orient Lines, Ltd. | 300 Montgomery Street | Suite 540 | San Francisco | CA | 94104 |
7800 | 7800 | 2003-02-27 | 2002-05-31 | Shigetome | Masayo | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
8450 | 8450 | 1976-02-29 | 1975-01-31 | Carlson | Jack Jay | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
8821 | 8821 | 2000-03-01 | 1997-04-21 | Fujimura | Narumi | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
8832 | 8832 | 2003-03-01 | 2000-05-18 | Hara | Shigeo | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
8967 | 8967 | 1990-03-02 | 1988-12-22 | Conley | Lyle Hayden | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
9628 | 9628 | 1987-03-11 | 1982-11-18 | Ashworth | Robert A. | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
10224 | 10224 | 1988-03-18 | 1937-01-01 | Dawson | John H. | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
11181 | 11181 | 1999-03-30 | 1988-10-13 | Hamilton | Robert K. | TransPacific Communications & Research Company 4173 | 1988-08-26 | TransPacific Communications & Research Company | 582 Market Street | Suite 602 | San Francisco | CA | 94104 |
12022 | 12022 | 2007-03-31 | 2004-08-16 | Murooka | Yoshikatsu | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
12030 | 12030 | 2008-03-31 | 2003-08-01 | Kaneshima | Hideto | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
12031 | 12031 | 2008-03-31 | 2003-09-16 | Mitani | Hideki | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
12032 | 12032 | 2008-03-31 | 2004-12-09 | Ujiie | Yutaka | Osaka Prefectural Government, California Office 5174 | 1997-04-21 | Osaka Prefectural Government, California Office | 332 Pine Street | Suite 610 | San Francisco | CA | 94104 |
12070 | 12070 | 2010-03-31 | 2007-05-02 | Tanimoto | Chikaosa | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
12161 | 12161 | 2014-03-31 | 2010-10-20 | Kuboi | Ryoichi | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
12447 | 12447 | 1984-04-01 | 1981-06-18 | Yates | Geoffrey Galloway | Scottish Development Agency 3249 | 1981-06-18 | Scottish Development Agency | 465 California Street | Suite 1220 | San Francisco | CA | 94104 |
13144 | 13144 | 1969-04-11 | 1962-07-03 | Sebald | William Joseph | James, Leonard Gage 1554 | 1962-07-03 | James, Leonard Gage | 310 Sansome Street | San Francisco | CA | 94104 | |
13623 | 13623 | 1985-04-17 | 1984-04-13 | Tay | William | Neptune Orient Lines, Ltd. 3345 | 1982-03-12 | Neptune Orient Lines, Ltd. | 300 Montgomery Street | Suite 540 | San Francisco | CA | 94104 |
14256 | 14256 | 1991-04-28 | 1988-11-18 | Fletcher | Donald M. | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
16366 | 16366 | 1972-05-15 | 1972-04-25 | Terra | Frank Stanley | Neeson Company 2015 | 1967-03-14 | Neeson Company | 704 Russ Building | San Francisco | CA | 94104 | |
16667 | 16667 | 1997-05-18 | 1990-05-18 | Won | Robin N. | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
16668 | 16668 | 1997-05-18 | 1992-09-16 | Chung | Patrick | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
16669 | 16669 | 1997-05-18 | 1988-12-15 | Minney | Yuemei | Hong Kong Government (Industry Department) 3421 | 1982-11-18 | Hong Kong Government (Industry Department) | 130 Montgomery Street | San Francisco | CA | 94104 | |
18412 | 18412 | 1973-06-01 | 1969-07-29 | Fraser | Roderick John | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
18437 | 18437 | 1979-06-01 | 1964-09-01 | Harrod | Harry | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
19311 | 19311 | 2005-06-12 | 2004-08-16 | Mukai | Hiroshi | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
22098 | 22098 | 1972-07-01 | 1970-10-06 | Lawrence | B.M. | B.M. Lawrence & Company 2211 | 1970-10-06 | B.M. Lawrence & Company | 351 California Street | San Francisco | CA | 94104 | |
22518 | 22518 | 1978-07-03 | 1977-01-21 | Cooper | Walter F. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
22673 | 22673 | 1969-07-07 | 1964-09-01 | Steacy | Newton Phillips | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
24356 | 24356 | 1980-07-29 | 1979-10-23 | Ostafin | Leszek | Polish Chamber of Foreign Trade 2550 | 1974-12-06 | Polish Chamber of Foreign Trade | 44 Montgomery Street | Suite 626 | San Francisco | CA | 94104 |
24692 | 24692 | 1978-07-31 | 1976-02-27 | Young | Earl B. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
24697 | 24697 | 1978-07-31 | 1975-10-30 | Oakes | Eugene E. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
25119 | 25119 | 2007-07-31 | 2006-11-27 | Ichiki | Tomoko | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
25287 | 25287 | 2016-07-31 | 2014-07-24 | Kabasawa | Satoshi | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
29703 | 29703 | 1972-09-14 | 1967-03-14 | Diespecker | Richard A. | Neeson Company 2015 | 1967-03-14 | Neeson Company | 704 Russ Building | San Francisco | CA | 94104 | |
29704 | 29704 | 1972-09-14 | 1967-03-14 | Neeson | John V. | Neeson Company 2015 | 1967-03-14 | Neeson Company | 704 Russ Building | San Francisco | CA | 94104 | |
29707 | 29707 | 1972-09-14 | 1967-12-12 | Zimmerman | Gabriel A. | Neeson Company 2015 | 1967-03-14 | Neeson Company | 704 Russ Building | San Francisco | CA | 94104 | |
30117 | 30117 | 1984-09-20 | 1984-05-30 | Burns | R. | Scottish Development Agency 3249 | 1981-06-18 | Scottish Development Agency | 465 California Street | Suite 1220 | San Francisco | CA | 94104 |
30118 | 30118 | 1984-09-20 | 1984-05-30 | Harrison | Donald | Scottish Development Agency 3249 | 1981-06-18 | Scottish Development Agency | 465 California Street | Suite 1220 | San Francisco | CA | 94104 |
30119 | 30119 | 1984-09-20 | 1981-06-18 | Reid | James | Scottish Development Agency 3249 | 1981-06-18 | Scottish Development Agency | 465 California Street | Suite 1220 | San Francisco | CA | 94104 |
30120 | 30120 | 1984-09-20 | 1984-07-19 | Gow | Frank | Scottish Development Agency 3249 | 1981-06-18 | Scottish Development Agency | 465 California Street | Suite 1220 | San Francisco | CA | 94104 |
30121 | 30121 | 1984-09-20 | 1984-07-19 | McPhail | Cameron Ian | Scottish Development Agency 3249 | 1981-06-18 | Scottish Development Agency | 465 California Street | Suite 1220 | San Francisco | CA | 94104 |
30364 | 30364 | 1981-09-24 | 1980-08-26 | Tekielski | Maciej | Polish Chamber of Foreign Trade 2550 | 1974-12-06 | Polish Chamber of Foreign Trade | 44 Montgomery Street | Suite 626 | San Francisco | CA | 94104 |
30365 | 30365 | 1981-09-24 | 1981-08-27 | Krzemirski | Andrzej | Polish Chamber of Foreign Trade 2550 | 1974-12-06 | Polish Chamber of Foreign Trade | 44 Montgomery Street | Suite 626 | San Francisco | CA | 94104 |
30367 | 30367 | 1981-09-24 | 1974-12-06 | Hys | Janusz | Polish Chamber of Foreign Trade 2550 | 1974-12-06 | Polish Chamber of Foreign Trade | 44 Montgomery Street | Suite 626 | San Francisco | CA | 94104 |
30368 | 30368 | 1981-09-24 | 1974-12-06 | Parlewicz | Bohdan | Polish Chamber of Foreign Trade 2550 | 1974-12-06 | Polish Chamber of Foreign Trade | 44 Montgomery Street | Suite 626 | San Francisco | CA | 94104 |
30455 | 30455 | 2009-09-25 | 2007-11-08 | Tanaka | Chie | Osaka University, San Francisco Office 5631 | 2004-07-12 | Osaka University, San Francisco Office | 44 Montgomery Street | Suite 3580 | San Francisco | CA | 94104 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_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]) );