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,092 rows where City = "Los Angeles"

✎ 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 1,092

City

  • Los Angeles · 1,092 ✖
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
121 121   1996-01-18 Morgan Irene 4450 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
158 158   2018-01-25 Baker Christopher 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
159 159   2018-01-25 Kuriyama Ai 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
160 160   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
161 161   2018-01-25 Vermeiren Sachie 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
226 226   2020-01-31 Saeki Norihiko 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
274 274   2017-02-10 Hojo Takashi 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
392 392   2020-03-03 Biggs Allison 6777 6777 2019-12-30 Lexington Avenue Consulting 4046 Collis Avenue   Los Angeles CA 90032
545 545   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
546 546   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
658 658   2019-04-09 Vandeventer Paul 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
937 937   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
1374 1374   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
1385 1385   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
1400 1400   2017-07-28 Asai Yasutaka 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1433 1433   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
1468 1468   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
1469 1469   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
1471 1471   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
1472 1472   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
1528 1528   2006-08-17 Gomm Anne Fabry 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1529 1529   2006-08-17 Lavalle James 2110 2110 1968-10-29 Hong Kong Tourism Board 5670 Wilshire Boulevard Suite 1230 Los Angeles CA 90036
1561 1561   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
1705 1705   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
1708 1708   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
2028 2028   2019-10-30 Hancock Alfaro Ange Marie 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
2029 2029   2019-10-30 Levey Andrew 6659 6659 2019-04-09 Community Partners 1000 N. Alameda Street Suite 240 Los Angeles CA 90012
2094 2094   1994-11-14 Monfrini Robert W. 1032 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2153 2153   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
2154 2154   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
2163 2163   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
2179 2179   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
2221 2221   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
2321 2321   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
2322 2322   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
2323 2323   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
2326 2326   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
2390 2390   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
2391 2391   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
2392 2392   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
2398 2398   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
2454 2454 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
2455 2455 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  
2456 2456 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  
2457 2457 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  
2480 2480 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
2553 2553 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
2609 2609 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
2737 2737 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
2786 2786 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
3004 3004 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
3088 3088 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
3089 3089 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
3090 3090 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
3091 3091 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
3092 3092 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
3095 3095 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
3096 3096 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
3097 3097 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
3098 3098 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
3099 3099 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
3100 3100 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
3103 3103 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
3239 3239 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
3243 3243 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
3255 3255 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
3257 3257 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
3258 3258 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
3259 3259 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
3260 3260 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
3261 3261 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
3262 3262 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
3385 3385 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
3474 3474 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
3516 3516 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
3539 3539 1945-01-14 1944-06-20 Kim Sung K. 266 266 1944-06-20 Korean Independence 955 West Jefferson Boulevard   Los Angeles CA  
3558 3558 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
3659 3659 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
3660 3660 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
3670 3670 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
3688 3688 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
3718 3718 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
3755 3755 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
3786 3786 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
3792 3792 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
3793 3793 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
3865 3865 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
3960 3960 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
3977 3977 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
3978 3978 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
4006 4006 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
4044 4044 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
4045 4045 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
4046 4046 1964-01-22 1962-09-28 Roselaar Louis A. 639 639 1950-08-22 Netherlands Chamber of Commerce in the U.S. 350 South Figueroa Street Suite 901 Los Angeles CA 90017
4134 4134 1974-01-24 1969-01-21 Whitehouse Jack P. 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4136 4136 1979-01-24 1979-01-24 Kasagi Shunsuke 1833 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4177 4177 1984-01-25 1981-01-27 Chambers Mary Lynn 1763 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4178 4178 1984-01-25 1981-01-27 Masters Tom 1763 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4180 4180 1984-01-25 1964-07-10 Lewis Bud 1763 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4181 4181 1984-01-25 1978-07-17 Scholnick Joseph B. 1763 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004

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