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

This data as json, CSV (advanced)

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 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 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 71   2020-01-09 Renezeder Fiona 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
104 104   2014-01-17 Grothaus Nicholas 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
110 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 320   2012-02-23 Sprague Esther M. 6091 6091 2012-02-23 Sprague, Esther Marie 123 Hanover Street   San Francisco CA 94112
323 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 330   2020-02-24 Chao Kevin 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
381 381   2020-03-03 Biggs Allison 6777 6777 2019-12-30 Lexington Avenue Consulting 4046 Collis Avenue   Los Angeles CA 90032
464 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 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 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 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 647   2019-04-09 Vandeventer Paul 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
704 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 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 731   2019-04-25 Braver Adam 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
756 756   2018-04-27 Hirokazu Shimoda 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
823 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 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 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 1280   2019-07-09 Schwartz Jason 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1286 1286   2009-07-10 Ficker Jared 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1287 1287   2009-07-10 Kinney Jason 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1288 1288   2009-07-10 White Robert 5697 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1289 1289   2015-07-10 Elam David Richard 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1349 1349   2013-07-22 Nakhla Mark 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1360 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1753   2019-09-20 Brauer Gabe 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1754 1754   2019-09-20 Patriana Zarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1755 1755   2019-09-20 Pejan Ramin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1756 1756   2019-09-20 Sivaraman Bala 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1757 1757   2019-09-20 Zniber Siham 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1775 1775   2019-09-24 Brenner Sarah 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1776 1776   2019-09-24 Dillen Abigail 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1777 1777   2019-09-24 Wagner Martin 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1784 1784   2019-09-25 Fitzsimmons Jill 6725 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1963 1963   2018-10-23 Ferguson William 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1964 1964   2018-10-23 Ishibashi Yuki 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1975 1975   2007-10-26 Viirg Andrus 5833 5833 2007-10-26 Enterprise Estonia in San Jose 440 North Wolfe Road   Sunnyvale CA 94085
2005 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 2012   2015-10-30 Hunter Naoco 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2013 2013   2015-10-30 Tanaka Mihoko 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2016 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   2017-10-30 Tarutani Noriya 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2018 2018   2017-10-30 Tomita Hiroshi 1813 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2022 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 2023   2019-10-30 Levey Andrew 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
2062 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 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 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 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 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 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 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 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 2241   2014-12-02 Barresi Joseph Francis 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2242 2242   2014-12-02 Wiese Landry 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2269 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 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 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 2300   2012-12-10 Epstein Matthew 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2301 2301   2012-12-10 Schmidt Benjamin 6144 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2315 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 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 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 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 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 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 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 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 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