FARA_All_ShortForms

List of all short form registrants (active and terminated)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

2,122 rows where State = "CA"

View and edit SQL

Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

  • CA · 2,122
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
25     Wu Yi-Rou 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
45   2020-01-03 Rabinowitz Matthew R. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
71   2020-01-09 Renezeder Fiona 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
104   2014-01-17 Grothaus Nicholas 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
110   1996-01-18 Morgan Irene 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
113   2015-01-19 Vang Tou-Fu 6130 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 232738   Sacramento CA 95823
114   2015-01-19 Vang Victor 6130 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 232738   Sacramento CA 95823
117   2018-01-19 Loh Choon Hong 5350 5350 1999-12-10 Malaysian Investment Development Authority 226 Airport Parkway Suite 480 San Jose CA 95110
132   2003-01-24 Kor Sabrina (Ya-Rei) 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
145   2006-01-25 Tsai Chia-Hsuan 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
147   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
148   2018-01-25 Kuriyama Ai 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
149   2018-01-25 Torres Kumiko Tanaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
150   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
178   2019-01-30 Fork William E. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
215   2020-01-31 Saeki Norihiko 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
263   2017-02-10 Hojo Takashi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
284   2002-02-13 Becker Stephan E. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
311   2018-02-20 Merrifield Jeffrey S. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
320   2012-02-23 Sprague Esther M. 6091 6091 2012-02-23 Sprague, Esther Marie 123 Hanover Street   San Francisco CA 94112
323   2019-02-23 Kaplan Aryeh L. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
330   2020-02-24 Chao Kevin 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
381   2020-03-03 Biggs Allison 6777 6777 2019-12-30 Lexington Avenue Consulting 4046 Collis Avenue   Los Angeles CA 90032
464   2020-03-16 Her David K. 6800 6800 2020-03-16 Hmong Kingdom ChaoFa State - US Representatives P.O. Box 6209   Fresno CA 93703
465   2020-03-16 Tubtsimnuj Fang Robert 6800 6800 2020-03-16 Hmong Kingdom ChaoFa State - US Representatives P.O. Box 6209   Fresno CA 93703
534   2020-03-26 Phichitkawin Theeraphong 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
535   2020-03-26 Prapattong Kittipong 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
647   2019-04-09 Vandeventer Paul 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
704   2018-04-19 Oresman Matthew S. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
720   2015-04-24 Moeller Elizabeth V. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
731   2019-04-25 Braver Adam 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
756   2018-04-27 Hirokazu Shimoda 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
823   2017-05-01 Laih Wern-Yih 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
926   2020-05-19 Setia Mohd Akbal Bin 2510 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
1075   2012-06-06 Syu Shu Jywan 2985 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
1280   2019-07-09 Schwartz Jason 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1286   2009-07-10 Ficker Jared 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1287   2009-07-10 Kinney Jason 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1288   2009-07-10 White Robert 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1289   2015-07-10 Elam David Richard 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1349   2013-07-22 Nakhla Mark 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1360   2015-07-23 Krajangsri Candy 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
1371   2013-07-26 Sukthavorn Proud 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
1386   2017-07-28 Asai Yasutaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1419   2019-07-30 Pike Chika Yamaga 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1454   2019-08-02 Hauss Stephen 6705 6705 2019-08-02 Quinn Emanuel Urquhart & Sullivan, LLP 865 South Figueroa Street 10th Floor Los Angeles CA 90017
1455   2019-08-02 Hedrich Marc 6705 6705 2019-08-02 Quinn Emanuel Urquhart & Sullivan, LLP 865 South Figueroa Street 10th Floor Los Angeles CA 90017
1457   2019-08-02 Shaffer Derek 6705 6705 2019-08-02 Quinn Emanuel Urquhart & Sullivan, LLP 865 South Figueroa Street 10th Floor Los Angeles CA 90017
1458   2019-08-02 Tahler Kristin 6705 6705 2019-08-02 Quinn Emanuel Urquhart & Sullivan, LLP 865 South Figueroa Street 10th Floor Los Angeles CA 90017
1506   2006-08-15 Musteric Marc J. 5591 5591 2003-12-02 Fukuoka Center for Overseas Commerce in America 440 N. Wolfe Rd.   Sunnyvale CA 94085
1514   2006-08-17 Gomm Anne Fabry 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1515   2006-08-17 Lavalle James 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1547   2019-08-22 Kishinaka Ayami 2350 2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1650   2012-09-05 Vang Chong 6130 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 232738   Sacramento CA 95823
1693   2018-09-13 ASO Ryoji 2350 2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1696   2018-09-13 Kadowaki Keita 2350 2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1753   2019-09-20 Brauer Gabe 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1754   2019-09-20 Patriana Zarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1755   2019-09-20 Pejan Ramin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1756   2019-09-20 Sivaraman Bala 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1757   2019-09-20 Zniber Siham 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1775   2019-09-24 Brenner Sarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1776   2019-09-24 Dillen Abigail 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1777   2019-09-24 Wagner Martin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1784   2019-09-25 Fitzsimmons Jill 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1963   2018-10-23 Ferguson William 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1964   2018-10-23 Ishibashi Yuki 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1975   2007-10-26 Viirg Andrus 5833 5833 2007-10-26 Enterprise Estonia in San Jose 440 North Wolfe Road   Sunnyvale CA 94085
2005   2014-10-29 Nokham Chao Khamlouang 6130 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 232738   Sacramento CA 95823
2012   2015-10-30 Hunter Naoco 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2013   2015-10-30 Tanaka Mihoko 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2016   2017-10-30 Nakazawa Norio 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2017   2017-10-30 Tarutani Noriya 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2018   2017-10-30 Tomita Hiroshi 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2022   2019-10-30 Hancock Alfaro Ange Marie 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
2023   2019-10-30 Levey Andrew 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
2062   2012-11-07 Oun Lo-Cam 6130 6130 2012-09-05 United Lao Council for Peace, Freedom and Reconstruction (ULCPFR) P.O. Box 232738   Sacramento CA 95823
2088   1994-11-14 Monfrini Robert W. 1032 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2131   2012-11-20 Laughlin Gregory H. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2147   2017-11-22 Myung Sewon 2544 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
2148   2017-11-22 Suk Lee Dong 2544 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
2157   2009-11-24 Flora William B. Jr. 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
2173   2017-11-27 Ab Rahim Ednie Rahma 2510 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
2215   2019-11-29 Jeong Byeongok 2544 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
2241   2014-12-02 Barresi Joseph Francis 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2242   2014-12-02 Wiese Landry 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2269   2019-12-03 Fischer Nancy A. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2283   2012-12-07 Saperstein Craig J. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2297   2019-12-09 Wall Christopher W. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2300   2012-12-10 Epstein Matthew 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2301   2012-12-10 Schmidt Benjamin 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2315   2019-12-13 Dembia Dennis 6769 6769 2019-12-13 CMGRP, Inc., d/b/a Rogers & Cowan 1840 Century Park East 18th Floor Los Angeles CA 90067
2316   2019-12-13 Dizon Sidney Angela 6769 6769 2019-12-13 CMGRP, Inc., d/b/a Rogers & Cowan 1840 Century Park East 18th Floor Los Angeles CA 90067
2317   2019-12-13 Magner Jason 6769 6769 2019-12-13 CMGRP, Inc., d/b/a Rogers & Cowan 1840 Century Park East 18th Floor Los Angeles CA 90067
2320   2019-12-13 Smith Ryan 6769 6769 2019-12-13 CMGRP, Inc., d/b/a Rogers & Cowan 1840 Century Park East 18th Floor Los Angeles CA 90067
2384   2006-12-27 Chomsin Tassanee 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
2385   2006-12-27 Narongchaisakun Lert 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
2386   2006-12-27 Tuvanuti Yurawat 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
2392   2014-12-30 Scott Yohko 2350 2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
2448 1964-01-01 1961-03-02 Scott Wilson 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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)
);
Powered by Datasette · Query took 340.133ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history