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 Address_1
This data as json, CSV (advanced)
Short_Form_Termination_Date (date) >30 ✖
- 1979-11-05 12
- 1949-12-19 11
- 1978-07-22 10
- 2018-05-07 8
- 1984-09-05 7
- 1959-03-21 6
- 1984-09-20 5
- 1985-01-07 5
- 2020-10-19 5
- 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
- 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
- …
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
- 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
- …
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
- 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
- …
State 1
- CA 487
City 1
- San Francisco · 487 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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 |
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 |
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 |
39910 | 39910 | 1972-12-31 | 1971-01-31 | Turbis | Steve C. | British Columbia House 1782 | 1964-09-01 | British Columbia House | 100 Bush Street | Suite 400 | San Francisco | CA | 94104 |
11589 | 11589 | 1988-03-31 | 1987-09-29 | Bagley | William T. | Nossaman, Guthner, Knox & Elliott 4046 | 1987-09-29 | Nossaman, Guthner, Knox & Elliott | 100 The Embarcadero | 3rd Floor | San Francisco | CA | 94105 |
11590 | 11590 | 1988-03-31 | 1987-09-29 | Zweben | Murray | Nossaman, Guthner, Knox & Elliott 4046 | 1987-09-29 | Nossaman, Guthner, Knox & Elliott | 100 The Embarcadero | 3rd Floor | San Francisco | CA | 94105 |
4508 | 4508 | 1953-01-26 | 1953-01-26 | Feingold | Jeremiah | Russky Kustar 754 | 1953-01-26 | Russky Kustar | 1200 Divisadero Street | San Francisco | CA | ||
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 | ||
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 | ||
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 | |
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 | |
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 | |
23772 | 23772 | 1978-07-22 | 1977-07-22 | Breece | Conrad D. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23773 | 23773 | 1978-07-22 | 1977-07-22 | Cox | Allen H. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23774 | 23774 | 1978-07-22 | 1977-07-22 | Friedman | Ronald B. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23775 | 23775 | 1978-07-22 | 1977-07-22 | Garvey | Joanne M. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23776 | 23776 | 1978-07-22 | 1977-07-22 | Keeler | George C. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23777 | 23777 | 1978-07-22 | 1977-07-22 | Koning | Kirk E. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23778 | 23778 | 1978-07-22 | 1977-07-22 | Olive | Jack H. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23779 | 23779 | 1978-07-22 | 1977-07-22 | Seligman | Joseph L. , Jr. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23780 | 23780 | 1978-07-22 | 1977-07-22 | Tomberling | George E. , Jr. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
23781 | 23781 | 1978-07-22 | 1977-07-22 | Wright | William M. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
28799 | 28799 | 1977-09-01 | 1977-07-22 | Barusch | Lawrence R. | Cotton, Seligman & Ray 2813 | 1977-07-22 | Cotton, Seligman & Ray | 1400 Alcoa Building | 1 Maritime Plaza | San Francisco | CA | 94111 |
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 | |
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 | |
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 | |
33052 | 33052 | 1974-10-17 | 1974-08-27 | Kearns | Henry | Kearns International 2531 | 1974-08-27 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
33053 | 33053 | 1974-10-17 | 1974-08-27 | Ladd | Robert D. | Kearns International 2531 | 1974-08-27 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
33054 | 33054 | 1974-10-17 | 1974-08-27 | Malick | Dell M. | Kearns International 2531 | 1974-08-27 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35272 | 35272 | 1979-11-05 | 1976-04-18 | Searby | Daniel M. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35273 | 35273 | 1979-11-05 | 1976-04-30 | Carlson | Jack Jay | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35274 | 35274 | 1979-11-05 | 1975-05-14 | Emerson | Claudius Lee | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35275 | 35275 | 1979-11-05 | 1978-09-12 | Murphy | Betty S. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35276 | 35276 | 1979-11-05 | 1974-10-24 | Kearns | Henry | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35277 | 35277 | 1979-11-05 | 1974-10-24 | Ladd | Robert D. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35278 | 35278 | 1979-11-05 | 1974-10-24 | Malick | Dell M. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35279 | 35279 | 1979-11-05 | 1974-10-24 | Southard | Frank A. , Jr. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35280 | 35280 | 1979-11-05 | 1975-10-30 | Drewes | Fred J. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35281 | 35281 | 1979-11-05 | 1975-10-30 | Goldhar | Laura K. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35282 | 35282 | 1979-11-05 | 1975-10-30 | Gomory | Paul Louis , Jr. | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
35283 | 35283 | 1979-11-05 | 1975-11-03 | Rand | Joseph | Kearns International 2542 | 1974-10-24 | Kearns International | 155 Sansome Street | San Francisco | CA | 94104 | |
40869 | 40869 | 1995-12-31 | 1995-06-20 | Goldman | Patti A. | Sierra Club Legal Defense Fund, Inc. 5026 | 1995-06-20 | Sierra Club Legal Defense Fund, Inc. | 180 Montgomery Street | Suite 1400 | San Francisco | CA | 94104-4209 |
29138 | 29138 | 1973-09-04 | 1972-08-10 | Diespecker | Richard a. | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
29211 | 29211 | 1984-09-05 | 1973-02-08 | Motroni | John L. | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
29212 | 29212 | 1984-09-05 | 1976-05-12 | Katz | Daniel H. | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
29213 | 29213 | 1984-09-05 | 1972-08-10 | Arnold | Richard K. | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
29214 | 29214 | 1984-09-05 | 1972-08-10 | Jacob | William | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
29215 | 29215 | 1984-09-05 | 1972-08-10 | Meblin | Sam | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
29216 | 29216 | 1984-09-05 | 1972-08-10 | Noble | Gerald S. | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
29217 | 29217 | 1984-09-05 | 1973-09-04 | Wills | James C. | Carl Byoir, Arnold, Palmer & Noble 2367 | 1972-08-10 | Carl Byoir, Arnold, Palmer & Noble | 181 Fremont Street | Mezzanine Suite | San Francisco | CA | 94105 |
3353 | 3353 | 1985-01-07 | 1985-01-07 | Kim | Sei Rok | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3354 | 3354 | 1985-01-07 | 1981-01-27 | Chong | Hui Sop | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3358 | 3358 | 1985-01-07 | 1978-04-11 | Lee | Soon Heung | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3359 | 3359 | 1985-01-07 | 1978-04-11 | Papesh | Michael H. | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
3360 | 3360 | 1985-01-07 | 1981-10-27 | Baird | Philip | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
10200 | 10200 | 1979-03-18 | 1976-12-09 | Choi | Yoon Hong | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
10941 | 10941 | 1977-03-28 | 1976-02-13 | Sull | Wonchull | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
11495 | 11495 | 1980-03-31 | 1977-11-29 | Cha | Shi Wha | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
11515 | 11515 | 1982-03-31 | 1979-09-28 | Lee | Tae Huan | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
11618 | 11618 | 1990-03-31 | 1990-02-01 | Mesirow | Harold E. | Lillick & Charles 4338 | 1990-02-01 | Lillick & Charles | 2 Embarcadero Center | 26th Floor | San Francisco | CA | 94111 |
14511 | 14511 | 1977-04-30 | 1976-02-13 | Flynn | James David | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
16814 | 16814 | 1976-05-21 | 1976-02-13 | Kim | Doo Hwan | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
36652 | 36652 | 1983-11-30 | 1981-01-27 | Kim | Yong Hun | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
40205 | 40205 | 1981-12-31 | 1981-10-27 | Cheong | Lynn Jeong | Korea Trade Center, San Francisco 2660 | 1976-02-13 | Korea Trade Center, San Francisco | 2 Embarcadero Center | Suite 660 | San Francisco | CA | 94111 |
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 | |
27900 | 27900 | 1972-08-31 | 1972-04-25 | Kim | Yeon Shil | Korea Tourist Service 2335 | 1972-04-25 | Korea Tourist Service | 210 Post Street | Suite 1017 | San Francisco | CA | 94108 |
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 | |
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 | |
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 | |
39930 | 39930 | 1972-12-31 | 1962-12-14 | Clark | Nelly Burgos | Philippine Tourist & Travel Association 1195 | 1959-01-29 | Philippine Tourist & Travel Association | 212 Stockton Street | San Francisco | CA | 94108 | |
5986 | 5986 | 2005-02-02 | 2004-12-28 | Truong | Autumn Tru | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
7649 | 7649 | 2005-02-25 | 2004-12-28 | Lande | Rachel | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
12523 | 12523 | 2005-04-01 | 2005-03-15 | Chung | Lucy Kyung Eun | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
32709 | 32709 | 2005-10-12 | 2004-12-28 | Vermazen | Kathleen A. | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
41460 | 41460 | 2005-12-31 | 2005-10-19 | Finn | Andrea W. | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
41461 | 41461 | 2005-12-31 | 2005-10-19 | Glass | Eric Mathew | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
41472 | 41472 | 2005-12-31 | 2004-12-28 | Kawashima | Caroline M. | Daniel J. Edelman, Inc. - San Francisco 5664 | 2004-12-28 | Daniel J. Edelman, Inc. - San Francisco | 221 Main Street | Suite 1300 | San Francisco | CA | 94105 |
40728 | 40728 | 1991-12-31 | 1990-12-03 | Farella | Frank E. | Farella, Braun & Martel 4443 | 1990-12-03 | Farella, Braun & Martel | 235 Montgomery Street | Suite 3000 | San Francisco | CA | 94104 |
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 | ||
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 |
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]) );