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

1,087 rows where City = "Los Angeles"

View and edit SQL

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

Registration_Number

State

  • CA 1,087

City

  • Los Angeles · 1,087
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
119   1996-01-18 Morgan Irene 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
162   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
163   2018-01-25 Kuriyama Ai 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
164   2018-01-25 Murata Soma 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
165   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
166   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
167   2018-01-25 Yoneyama Lena 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
194   2019-01-29 Aisen Mayuka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
285   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
291   2017-02-10 Hojo Takashi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
292   2017-02-10 Nishimoto Keiichi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
501   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
600   2019-04-09 Vandeventer Paul 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
1211   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
1229   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
1240   2018-07-27 Yamaguchi Makoto 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1243   2016-07-28 Kanazashi Hisashi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1244   2017-07-28 Asai Yasutaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1276   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
1298   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
1300   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
1301   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
1304   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
1305   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
1364   2006-08-17 Gomm Anne Fabry 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1365   2006-08-17 Lavalle James 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1384   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
1516   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
1520   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
1779   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
1783   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
1784   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
1903   2019-10-30 Hancock Alfaro Ange Marie 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
1904   2019-10-30 Levey Andrew 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
1979   1994-11-14 Monfrini Robert W. 1032 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2046   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
2047   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
2057   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
2075   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
2123   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
2246   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
2247   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
2248   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
2251   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
2321   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
2322   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
2323   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
2330   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
2394 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
2395 1964-01-01 1963-03-26 Guiglia Maria Corella 1612 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2396 1964-01-01 1963-03-26 Virchis Roman Joseph 1612 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2397 1964-01-01 1963-03-26 Zeman Leland Ellis 1612 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2420 1970-01-01 1966-09-07 Vejarano Carlos 639 639 1950-08-22 Netherlands Chamber of Commerce in the U.S. 350 South Figueroa Street Suite 901 Los Angeles CA 90017
2493 1985-01-01 1983-01-28 Nardone Silverio 1884 1884 1965-04-19 Italian Government Tourist Board (ENIT), Los Angeles 10850 Wilshire Boulevard Suite 575 Los Angeles CA 90024
2549 1989-01-01 1989-08-16 Hamid Noor Ahmad 2510 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
2677 2002-01-01 1988-07-26 Gray Lyndel 1032 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2726 2007-01-01 2006-12-08 Milmoe Peter 5777 5777 2006-11-20 Sitrick and Company, Inc. 1840 Century Park East Suite 800 Los Angeles CA 90067-2109
2942 1992-01-02 1984-03-12 Renner Herwig 793 793 1953-10-21 Austrian Trade Commission, Los Angeles 11601 Wilshire Boulevard Suite 2420 Los Angeles CA 90025
3026 1995-01-04 1990-11-15 Cook Fred 4437 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3027 1995-01-04 1990-11-15 Yamamoto Deanne 4437 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3028 1995-01-04 1993-12-30 Crow Maureen B. 4437 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3029 1995-01-04 1993-12-30 Kintisch Jean 4437 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3030 1995-01-04 1993-12-30 Walters Bonnie 4437 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3033 2000-01-04 1992-02-10 Leong Charles 2744 2744 1977-01-04 ASEAN Promotional Chapter for Tourism - North America c/o Tourism Authority of Thailand 611 North Larchmont Blvd., 1st Floor Los Angeles CA 90004
3034 2000-01-04 1999-07-27 Arisman Chilman 2744 2744 1977-01-04 ASEAN Promotional Chapter for Tourism - North America c/o Tourism Authority of Thailand 611 North Larchmont Blvd., 1st Floor Los Angeles CA 90004
3035 2000-01-04 1999-07-27 Boncan-Francisco Regina 2744 2744 1977-01-04 ASEAN Promotional Chapter for Tourism - North America c/o Tourism Authority of Thailand 611 North Larchmont Blvd., 1st Floor Los Angeles CA 90004
3036 2000-01-04 1999-07-27 Danial Sharifah L. 2744 2744 1977-01-04 ASEAN Promotional Chapter for Tourism - North America c/o Tourism Authority of Thailand 611 North Larchmont Blvd., 1st Floor Los Angeles CA 90004
3037 2000-01-04 1999-07-27 Kongrut Niti 2744 2744 1977-01-04 ASEAN Promotional Chapter for Tourism - North America c/o Tourism Authority of Thailand 611 North Larchmont Blvd., 1st Floor Los Angeles CA 90004
3038 2000-01-04 1995-09-19 Chindanon Sethapon 2744 2744 1977-01-04 ASEAN Promotional Chapter for Tourism - North America c/o Tourism Authority of Thailand 611 North Larchmont Blvd., 1st Floor Los Angeles CA 90004
3041 2007-01-04 2006-08-17 Willus Amy 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
3176 2000-01-07 1995-03-31 Endara Soudad M. 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
3180 2005-01-07 2000-05-19 Musa Normasila 2510 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
3192 1973-01-08 1958-02-04 Flynn Patricia Mary 1032 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
3194 1974-01-08 1972-05-30 Richter, Jr., Ralph L. 2343 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3195 1974-01-08 1972-07-11 O'Guin Kathleen 2343 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3196 1974-01-08 1972-07-11 Bennett Lita 2343 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3197 1974-01-08 1972-07-11 Bennett Sue 2343 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3198 1974-01-08 1972-07-11 Carr Brent 2343 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3199 1974-01-08 1972-07-11 Urist Harry M. 2343 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3322 1985-01-10 1980-03-11 Shurtleff Robert Bruce 1276 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
3408 1983-01-12 1979-03-05 Hunt Leonard Godfrey 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3450 1992-01-13 1990-07-17 Vitalis Esther 2199 2199 1970-06-09 Greek National Tourist Organization, Los Angeles 611 West Sixth Street Suite 2198 Los Angeles CA 90017
3473 1945-01-14 1944-06-20 Kim Sung K. 266 266 1944-06-20 Korean Independence 955 West Jefferson Boulevard   Los Angeles CA  
3492 1983-01-14 1979-03-05 Simpson Roger 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3591 1999-01-15 1988-09-20 Bakht Mary 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
3592 1999-01-15 1988-09-20 Testa Mary 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
3602 2005-01-15 2001-09-18 Takashi Muneo 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3620 1973-01-16 1952-10-07 Oppenhagen Caroline Helene Marianne 639 639 1950-08-22 Netherlands Chamber of Commerce in the U.S. 350 South Figueroa Street Suite 901 Los Angeles CA 90017
3650 1986-01-16 1985-09-16 Horan Michael James 3266 3266 1981-08-06 Victorian Government Business Office, Los Angeles 611 North Larchmont Boulevard Second Floor Los Angeles CA 90004
3687 1960-01-17 1951-04-23 Firth Roberts Mathew 672 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3718 1995-01-17 1991-01-17 Suzuki Masahiro 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3724 1995-01-17 1991-12-23 Inagaki Akihisa 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3725 1995-01-17 1991-12-23 Obata Tomoyasu 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3796 1994-01-18 1991-01-17 Iwaki Shigenori 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3891 1974-01-20 1971-01-31 Ueda Kooichi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3908 1997-01-20 1994-12-29 Kim Yong-Il 2544 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
3909 1999-01-20 1997-07-17 Na Sang Hoon 2544 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
3937 1980-01-21 1977-07-28 Clewis John 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
3974 1964-01-22 1961-09-27 Alioto Samuel Francis 639 639 1950-08-22 Netherlands Chamber of Commerce in the U.S. 350 South Figueroa Street Suite 901 Los Angeles CA 90017
3975 1964-01-22 1962-09-28 Kammeijer Christiaan 639 639 1950-08-22 Netherlands Chamber of Commerce in the U.S. 350 South Figueroa Street Suite 901 Los Angeles CA 90017

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