FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
51 rows where City = "San Francisco" and Zip = 94108
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Registration_Date, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3400 | 3400 | 1980-01-08 | 1972-01-14 | Fanning | Branwell D. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3401 | 3401 | 1980-01-08 | 1972-01-14 | Gleason | William E. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3402 | 3402 | 1980-01-08 | 1972-01-14 | McKean | Suzanne L. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
3403 | 3403 | 1980-01-08 | 1972-01-14 | Winslow | David C. | Gleason Associates, Inc. 2305 | 1972-01-14 | Gleason Associates, Inc. | 251 Kearny Street | San Francisco | CA | 94108 | |
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 | |
13066 | 13066 | 1973-04-10 | 1972-04-27 | Simonsz | W.H. | Netherlands Information Service 2048 | 1966-12-31 | Netherlands Information Service | 601 California Street | 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 | |
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 |
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 | |
25495 | 25495 | 1974-08-01 | 1966-04-12 | Lew | Mon Ben | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
25502 | 25502 | 1977-08-01 | 1975-08-21 | Gong | Shu Chung | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
25514 | 25514 | 1981-08-01 | 1966-02-01 | Chew | Jong-Yen | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
25518 | 25518 | 1981-08-01 | 1975-08-21 | Lee | Wallace | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
25530 | 25530 | 1983-08-01 | 1975-08-21 | Wong | Kai Foon | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
25535 | 25535 | 1985-08-01 | 1972-04-13 | Wong | Thomas | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
26246 | 26246 | 1973-08-08 | 1973-08-08 | Freeman | Howard Burton | Freeman, Teilmann & Associates Public Relations 2450 | 1973-08-09 | Freeman, Teilmann & Associates Public Relations | 26 O'Farrell Street | Suite 903 | San Francisco | CA | 94108 |
26247 | 26247 | 1973-08-08 | 1973-08-08 | Teilmann | Michael R. | Freeman, Teilmann & Associates Public Relations 2450 | 1973-08-09 | Freeman, Teilmann & Associates Public Relations | 26 O'Farrell Street | Suite 903 | San Francisco | CA | 94108 |
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 | |
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 |
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 |
27907 | 27907 | 1973-08-31 | 1966-02-18 | Wong | Sen Chong | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
27948 | 27948 | 1977-08-31 | 1972-04-13 | Ng | Tong | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
27949 | 27949 | 1977-08-31 | 1972-04-13 | Wong | Wah Poy | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
27950 | 27950 | 1977-08-31 | 1972-04-13 | Wu | She Kwan | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
27986 | 27986 | 1977-08-31 | 1975-08-21 | Wong | Kay | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
28000 | 28000 | 1978-08-31 | 1969-01-14 | Juon | Hans | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
28002 | 28002 | 1978-08-31 | 1971-03-29 | Juon | Hans | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
28039 | 28039 | 1981-08-31 | 1975-08-21 | Chu | Leonard C. | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
28040 | 28040 | 1981-08-31 | 1975-08-21 | Fong | Jimmy H. | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
28041 | 28041 | 1981-08-31 | 1975-08-21 | Lee | Chan Min | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
28090 | 28090 | 1985-08-31 | 1975-08-21 | Suen | Donald | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
28093 | 28093 | 1985-08-31 | 1949-09-19 | Liu | Pei Chi | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
29805 | 29805 | 1972-09-15 | 1969-05-05 | Adank | Matthias | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
30600 | 30600 | 1990-09-27 | 1973-01-09 | Isler | Willy (William) | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
30601 | 30601 | 1990-09-27 | 1984-08-22 | Waser | Robert | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
34227 | 34227 | 1983-10-31 | 1981-02-13 | Urs | Werner Iberhard | Swiss National Tourist Office, San Francisco 458 | 1947-04-25 | Swiss National Tourist Office, San Francisco | 260 Stockton Street | San Francisco | CA | 94108 | |
35268 | 35268 | 1974-11-05 | 1972-04-13 | Liu | Pei Chi | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
35269 | 35269 | 1974-11-05 | 1973-07-02 | Sum | Jang Young | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
37382 | 37382 | 1985-12-01 | 1975-08-21 | Mock | Cheong Hing | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
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 | |
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 | |
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 | |
39939 | 39939 | 1973-12-31 | 1972-04-13 | Toy | Don | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
39940 | 39940 | 1973-12-31 | 1962-04-23 | Kwan | Peter Tzu Shu | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
39941 | 39941 | 1973-12-31 | 1962-04-23 | Lee | Jack Jong | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
39944 | 39944 | 1973-12-31 | 1954-06-11 | Lew | Goot Chee | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton Street | San Francisco | CA | 94108 |
39945 | 39945 | 1973-12-31 | 1954-06-11 | Li | Tak (aka D. Foon) | Kuomintang of China 282 | 1945-01-01 | Kuomintang of China | (Headquarters in America) | 844 Stockton 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]) );