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 Short_Form_Termination_Date
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number >30
- 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
- …
Registrant_Name >30
- 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
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
58 | 58 | 2020-01-03 | Rabinowitz | Matthew R. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
363 | 363 | 2002-02-13 | Becker | Stephan E. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
438 | 438 | 2012-02-23 | Sprague | Esther M. | Sprague, Esther Marie 6091 | 2012-02-23 | Sprague, Esther Marie | 123 Hanover Street | San Francisco | CA | 94112 | ||
439 | 439 | 2019-02-23 | Kaplan | Aryeh L. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
863 | 863 | 2015-04-24 | Moeller | Elizabeth V. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
899 | 899 | 2021-04-28 | La | Kellie | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
900 | 900 | 2021-04-28 | Nakanishi | Tomoaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
994 | 994 | 2023-05-09 | Hayashi | Yotetsu | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1334 | 1334 | 2021-06-30 | Finch | Brian | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
1869 | 1869 | 2020-09-29 | Fast | Andrew | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1871 | 1871 | 2020-09-29 | Shiozaki | Misako | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
1873 | 1873 | 2020-09-29 | Yamashita | Takanari | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2022 | 2022 | 2018-10-23 | Ferguson | William | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2023 | 2023 | 2018-10-23 | Ishibashi | Yuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2057 | 2057 | 2020-10-29 | Ramsey | Edward | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2066 | 2066 | 2015-10-30 | Hunter | Naoco | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2067 | 2067 | 2015-10-30 | Tanaka | Mihoko | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2068 | 2068 | 2017-10-30 | Tomita | Hiroshi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2169 | 2169 | 2022-11-14 | Ishiguro | Seiya | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 | |
2202 | 2202 | 2021-11-19 | Tsai | David J. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2203 | 2203 | 2012-11-20 | Laughlin | Gregory H. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2345 | 2345 | 2019-12-03 | Fischer | Nancy A. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2360 | 2360 | 2012-12-07 | Saperstein | Craig J. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
2370 | 2370 | 2019-12-09 | Wall | Christopher W. | Pillsbury Winthrop Shaw Pittman, LLP 5198 | 1997-07-31 | Pillsbury Winthrop Shaw Pittman, LLP | Four Embarcadero Center | 22nd Floor | San Francisco | CA | 94111-2228 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
39512 | 39512 | 1950-12-31 | 1947-04-25 | Grob | Werner | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
4508 | 4508 | 1953-01-26 | 1953-01-26 | Feingold | Jeremiah | Russky Kustar 754 | 1953-01-26 | Russky Kustar | 1200 Divisadero 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
20719 | 20719 | 1961-06-30 | 1954-08-18 | Lam | Tit Hong | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
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 | ||
24630 | 24630 | 1963-07-31 | 1959-01-29 | Trinidad | Carmencita | Philippine Tourist & Travel Association 1195 | 1959-01-29 | Philippine Tourist & Travel Association | 212 Stockton Street | San Francisco | CA | 94108 | |
39783 | 39783 | 1964-12-31 | 1963-11-22 | Koss | Harry | China Books & Periodicals, Inc. 1350 | 1960-04-06 | China Books & Periodicals, Inc. | 2929 - 24th Street | San Francisco | CA | 94110 | |
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 | |
32490 | 32490 | 1965-10-09 | 1964-11-05 | Moriyama | Shingo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
4196 | 4196 | 1966-01-21 | 1964-11-05 | Nakano | Hideo | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10276 | 10276 | 1966-03-19 | 1964-11-05 | Takeda | Ippei | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
16178 | 16178 | 1966-05-13 | 1964-11-13 | Kawasaki | Sumio | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
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 | |
24652 | 24652 | 1966-07-31 | 1964-05-08 | Libunao | Josph A. | Philippine Tourist & Travel Association 1195 | 1959-01-29 | Philippine Tourist & Travel Association | 212 Stockton Street | San Francisco | CA | 94108 | |
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 | |
35086 | 35086 | 1966-11-02 | 1964-12-03 | Calhoun | Alexander Dewey , Jr. | Graham, James & Rolph 1825 | 1964-12-03 | Graham, James & Rolph | 310 Sansome Street | San Francisco | CA | 94104 | |
35087 | 35087 | 1966-11-02 | 1964-12-03 | Fleischmann | Roger J. | Graham, James & Rolph 1825 | 1964-12-03 | Graham, James & Rolph | 310 Sansome Street | San Francisco | CA | 94104 | |
4919 | 4919 | 1967-01-31 | 1967-05-02 | Nakamura | Kohji | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
10927 | 10927 | 1967-03-28 | 1964-11-05 | Tanabe | Ryuichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
27865 | 27865 | 1967-08-31 | 1962-04-23 | Soot | Hong Gee | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
27867 | 27867 | 1967-08-31 | 1954-06-11 | Yaw | King (aka: Hong Pao) Chang | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
39861 | 39861 | 1967-12-31 | 1947-10-07 | Egli | Gody | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
8659 | 8659 | 1968-03-01 | 1964-11-05 | Tashiro | Nobuyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
22939 | 22939 | 1968-07-11 | 1967-05-02 | Nagaoka | Sadao | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
34019 | 34019 | 1968-10-30 | 1965-03-18 | R. | Horacio Macalpin | Mexican Government Tourism Office, San Francisco 1872 | 1965-03-18 | Mexican Government Tourism Office, San Francisco | 50 California Street | Suite 2465 | San Francisco | CA | 94111 |
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 | |
17604 | 17604 | 1969-05-31 | 1966-04-28 | Miyata | Kyoshiro | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
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 |
30293 | 30293 | 1969-09-23 | 1966-02-07 | Amador | Napoleon | Alianza Patriotica Nicaraguense 1955 | 1966-02-07 | Alianza Patriotica Nicaraguense | 61 Fair Avenue | San Francisco | CA | 94110 | |
31807 | 31807 | 1969-10-01 | 1966-04-28 | Eguchi | Hiromichi | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
4800 | 4800 | 1970-01-30 | 1969-01-09 | Ito | Hidemaro | Braden Toureast, Inc. 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
4801 | 4801 | 1970-01-30 | 1968-05-09 | Braden | Edwin E. | Braden Toureast, Inc. 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
4802 | 4802 | 1970-01-30 | 1968-06-19 | Manalac | Gabriel V. , Jr. | Braden Toureast, Inc. 2091 | 1968-05-09 | Braden Toureast, Inc. | 210 Post Street | San Francisco | CA | 94108 | |
17608 | 17608 | 1970-05-31 | 1966-04-28 | Kuraishi | Fumiaki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
14479 | 14479 | 1971-04-30 | 1971-02-14 | Mapa | Victorino P. | Philippine Tourist & Travel Association 1195 | 1959-01-29 | Philippine Tourist & Travel Association | 212 Stockton Street | San Francisco | CA | 94108 | |
22675 | 22675 | 1971-07-07 | 1968-05-06 | Tsubaki | Hiroyuki | JETRO, San Francisco 1813 | 1964-11-05 | JETRO, San Francisco | 575 Market Street | Suite 2400 | San Francisco | CA | 94105 |
27460 | 27460 | 1971-08-26 | 1971-04-19 | Broek | H.F. Den | Netherlands Information Service 2048 | 1966-12-31 | Netherlands Information Service | 601 California Street | San Francisco | CA | 94108 |
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]) );