FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
65 rows where State = "CA" and Zip = 94111
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Short_Form_Termination_Date (date), Short_Form_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
7264 | 7264 | 2020-02-19 | 2019-09-24 | Coleman | Daveon | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
8818 | 8818 | 1999-03-01 | 1998-07-12 | Blomquist | Eric | PBN Company 5264 | 1998-07-12 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
8819 | 8819 | 1999-03-01 | 1998-07-12 | Nathanson | Paul | PBN Company 5264 | 1998-07-12 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
9669 | 9669 | 2020-03-11 | 2019-09-20 | Tauber | Jill | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
9700 | 9700 | 1980-03-12 | 1977-08-11 | Kong | Yap Fung | Malaysian Trade Commission 2507 | 1974-03-25 | Malaysian Trade Commission | TransAmerica Pyramid Building | 600 Montgomery Street, 36th Fl | 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 |
11793 | 11793 | 1998-03-31 | 1997-09-04 | Blomquist | Eric | PBN Company 5206 | 1997-09-04 | PBN Company | 3 Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
11794 | 11794 | 1998-03-31 | 1997-09-04 | Nathanson | Paul | PBN Company 5206 | 1997-09-04 | PBN Company | 3 Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
11795 | 11795 | 1998-03-31 | 1997-09-09 | Dillard | John R. | PBN Company 5206 | 1997-09-04 | PBN Company | 3 Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
11796 | 11796 | 1998-03-31 | 1997-10-16 | Necarsulmer | Peter B. | PBN Company 5206 | 1997-09-04 | PBN Company | 3 Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
13278 | 13278 | 1980-04-13 | 1979-01-16 | Khen | Teng Peng | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
14118 | 14118 | 2022-04-25 | 2019-09-24 | Wagner | Martin | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
14119 | 14119 | 2022-04-25 | 2021-09-24 | Manupipatpong | Methawee | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | 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 |
14569 | 14569 | 1986-04-30 | 1984-08-27 | Keling | Aminudin Bin | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | 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 |
16856 | 16856 | 2021-05-21 | 2019-09-24 | Dillen | Abigail | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
17008 | 17008 | 1983-05-24 | 1980-03-15 | Shafie | Abdul Mutalib bin | Malaysian Trade Commission 2507 | 1974-03-25 | Malaysian Trade Commission | TransAmerica Pyramid Building | 600 Montgomery Street, 36th Fl | San Francisco | CA | 94111 |
17009 | 17009 | 1983-05-24 | 1980-05-15 | Saleh | Ismail bin | Malaysian Trade Commission 2507 | 1974-03-25 | Malaysian Trade Commission | TransAmerica Pyramid Building | 600 Montgomery Street, 36th Fl | San Francisco | CA | 94111 |
17011 | 17011 | 1983-05-24 | 1977-11-15 | Mamat | Raja Ibrahim bin Raja | Malaysian Trade Commission 2507 | 1974-03-25 | Malaysian Trade Commission | TransAmerica Pyramid Building | 600 Montgomery Street, 36th Fl | San Francisco | CA | 94111 |
17205 | 17205 | 2020-05-26 | 2019-09-20 | Arnoldy | Ben | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
20977 | 20977 | 1981-06-30 | 1980-12-18 | Tan | Cheam Siew | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
23352 | 23352 | 1976-07-16 | 1974-03-25 | Ho | Tom Shing Chong | Malaysian Trade Commission 2507 | 1974-03-25 | Malaysian Trade Commission | TransAmerica Pyramid Building | 600 Montgomery Street, 36th Fl | San Francisco | CA | 94111 |
23509 | 23509 | 1986-07-18 | 1981-06-24 | Ford | John J. , III | Ford & Vlahos 3252 | 1981-06-24 | Ford & Vlahos | Alcoa Building | 1 Maritime Plaza, Suite 1313 | San Francisco | CA | 94111 |
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 |
24466 | 24466 | 1973-07-30 | 1972-08-31 | Paredes | Fernando Anzures | 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 |
24689 | 24689 | 1977-07-31 | 1977-06-21 | Austin | Alan K. | McKee, William D. 2794 | 1977-06-21 | McKee, William D. | 600 Montgomery Street | 12th Floor | 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 |
28919 | 28919 | 1998-09-01 | 1998-07-12 | Dillard | John R. | PBN Company 5264 | 1998-07-12 | PBN Company | Three Embarcadero Center | Suite 2210 | San Francisco | CA | 94111 |
29819 | 29819 | 1981-09-15 | 1979-11-30 | Salleh | Mohd Thabit Bin Mohd | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
30947 | 30947 | 1981-09-30 | 1974-08-06 | Ochoa | Sergio Guerrero | 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 |
31680 | 31680 | 2019-09-30 | 2019-09-24 | Fitzgerald | Erin | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
31681 | 31681 | 2019-09-30 | 2019-09-24 | Trotter | Elizabeth | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
32645 | 32645 | 2021-10-11 | 2019-09-20 | Pejan | Ramin | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33222 | 33222 | 2020-10-19 | 2019-09-20 | Patriana | Zarah | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33223 | 33223 | 2020-10-19 | 2019-09-20 | Sivaraman | Bala | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33224 | 33224 | 2020-10-19 | 2019-09-20 | Zniber | Siham | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33225 | 33225 | 2020-10-19 | 2019-09-24 | Brenner | Sarah | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
33226 | 33226 | 2020-10-19 | 2019-09-25 | Fitzsimmons | Jill | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
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 |
35673 | 35673 | 2020-11-12 | 2019-09-20 | Brauer | Gabe | Earthjustice 6725 | 2019-09-20 | Earthjustice | 50 California Street | Suite 500 | San Francisco | CA | 94111 |
35754 | 35754 | 1989-11-14 | 1986-09-21 | Aziz | Zubir B. Hj. Abd. | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | 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 |
37601 | 37601 | 1977-12-02 | 1975-11-11 | Daud | Mohamad Bin | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | San Francisco | CA | 94111 |
38372 | 38372 | 1978-12-15 | 1978-07-06 | Majed | Mohamed Bin Abd | Felda Marketing Corporation 2628 | 1975-11-11 | Felda Marketing Corporation | C/O Graham & James | 1 Maritime Plaza, 3rd Floor | 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 |
40571 | 40571 | 1989-12-31 | 1982-06-08 | Beaver | Janet Arneson | Russom & Leeper 3377 | 1982-06-08 | Russom & Leeper | 350 Pacific Avenue | San Francisco | CA | 94111 |
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]) );