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,114 rows where State = "CA"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

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

Registration_Number

State

  • CA · 2,114 ✖
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
36 36   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
67 67   2020-01-09 Renezeder Fiona 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
112 112   2014-01-17 Grothaus Nicholas 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
117 117   1996-01-18 Morgan Irene 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
121 121   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
122 122   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
125 125   2018-01-19 Loh Choon Hong 5350 5350 1999-12-10 Malaysian Investment Development Authority 226 Airport Parkway Suite 480 San Jose CA 95110
126 126   2016-01-20 Larson Stephen 6337 6337 2016-01-20 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
127 127   2016-01-20 McEfee Camden S. 6337 6337 2016-01-20 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
145 145   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
158 158   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
160 160   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
161 161   2018-01-25 Kuriyama Ai 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
162 162   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
163 163   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
196 196   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
237 237   2020-01-31 Saeki Norihiko 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
295 295   2013-02-08 Wannalert Kulpramote 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
301 301   2017-02-10 Hojo Takashi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
322 322   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
353 353   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
361 361   2012-02-23 Sprague Esther M. 6091 6091 2012-02-23 Sprague, Esther Marie 123 Hanover Street   San Francisco CA 94112
364 364   2019-02-23 Jean Joseph D. 5198 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
365 365   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
517 517   2014-03-26 Sitthichai Suriya 2178 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
616 616   2019-04-09 Vandeventer Paul 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
661 661   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
677 677   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
693 693   2019-04-25 Braver Adam 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
723 723   2018-04-27 Hirokazu Shimoda 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
777 777   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
1002 1002   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
1170 1170   2019-07-09 Schwartz Jason 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1171 1171   2009-07-10 Ficker Jared 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1172 1172   2009-07-10 Kinney Jason 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1173 1173   2009-07-10 White Robert 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1174 1174   2015-07-10 Elam David Richard 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1220 1220   2013-07-22 Nakhla Mark 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1224 1224   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
1242 1242   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
1253 1253   2018-07-27 Yamaguchi Makoto 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1256 1256   2017-07-28 Asai Yasutaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1288 1288   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
1310 1310   2019-08-02 Burck William 6705 6705 2019-08-02 Quinn Emanuel Urquhart & Sullivan, LLP 865 South Figueroa Street 10th Floor Los Angeles CA 90017
1312 1312   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
1313 1313   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
1316 1316   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
1317 1317   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
1363 1363   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
1376 1376   2006-08-17 Gomm Anne Fabry 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1377 1377   2006-08-17 Lavalle James 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1396 1396   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
1481 1481   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
1528 1528   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
1532 1532   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
1584 1584   2019-09-20 Arnoldy Ben 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1585 1585   2019-09-20 Brauer Gabe 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1586 1586   2019-09-20 Patriana Zarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1587 1587   2019-09-20 Pejan Ramin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1588 1588   2019-09-20 Sivaraman Bala 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1589 1589   2019-09-20 Tauber Jill 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1590 1590   2019-09-20 Zniber Siham 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1613 1613   2019-09-24 Brenner Sarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1614 1614   2019-09-24 Coleman Daveon 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1615 1615   2019-09-24 Dillen Abigail 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1616 1616   2019-09-24 Wagner Martin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1623 1623   2019-09-25 Fitzsimmons Jill 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1791 1791   2017-10-17 Boni Emanuela 1884 1884 1965-04-19 Italian Government Tourist Board (ENIT), Los Angeles 10850 Wilshire Boulevard Suite 575 Los Angeles CA 90024
1795 1795   2017-10-17 Lanzafame Fabrizio 1884 1884 1965-04-19 Italian Government Tourist Board (ENIT), Los Angeles 10850 Wilshire Boulevard Suite 575 Los Angeles CA 90024
1796 1796   2017-10-17 Moschini Cinzia 1884 1884 1965-04-19 Italian Government Tourist Board (ENIT), Los Angeles 10850 Wilshire Boulevard Suite 575 Los Angeles CA 90024
1847 1847   2018-10-23 Ferguson William 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1848 1848   2018-10-23 Ishibashi Yuki 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1864 1864   2007-10-26 Viirg Andrus 5833 5833 2007-10-26 Enterprise Estonia in San Jose 440 North Wolfe Road   Sunnyvale CA 94085
1897 1897   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
1904 1904   2015-10-30 Hunter Naoco 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1905 1905   2015-10-30 Tanaka Mihoko 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1908 1908   2017-10-30 Nakazawa Norio 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1909 1909   2017-10-30 Tarutani Noriya 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1910 1910   2017-10-30 Tomita Hiroshi 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1915 1915   2019-10-30 Hancock Alfaro Ange Marie 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
1916 1916   2019-10-30 Levey Andrew 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
1961 1961   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
1991 1991   1994-11-14 Monfrini Robert W. 1032 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2039 2039   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
2057 2057   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
2058 2058   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
2068 2068   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
2086 2086   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
2133 2133   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
2170 2170   2014-12-02 Barresi Joseph Francis 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2171 2171   2014-12-02 Wiese Landry 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2203 2203   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
2217 2217   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
2231 2231   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
2234 2234   2012-12-10 Epstein Matthew 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2235 2235   2012-12-10 Schmidt Benjamin 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2253 2253   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
2254 2254   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
2255 2255   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
2258 2258   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

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 312.325ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history