home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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,224 rows where State = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Registration_Number >30

  • JETRO, Los Angeles 184
  • JETRO, San Francisco 124
  • Netherlands Chamber of Commerce in the U.S. 87
  • New Zealand Milk Products, Inc. 67
  • Tourism Australia 64
  • Korea Trade Center, Los Angeles 59
  • Hong Kong Tourism Board 58
  • Japan National Tourism Organization, Los Angeles 45
  • Pillsbury Winthrop Shaw Pittman, LLP 44
  • Korea National Tourism Organization, Los Angeles 42
  • Fontayne Group, Inc. 37
  • Far East Trade Services, Inc. 36
  • Japan National Tourist Organization, San Francisco 32
  • Wagstaff Worldwide Public Relations, Inc. 32
  • China Books & Periodicals, Inc. 30
  • New Zealand Central Reservations Office 29
  • New South Wales Government Office 29
  • Tourism Authority of Thailand, Los Angeles 29
  • Kuomintang of China 27
  • Aviso, Inc. 27
  • Comite Regional Sinarquista en Los Angeles 25
  • Malaysia Tourism Promotion Board 23
  • Camstoll Group, LLC 22
  • Charles von Loewenfeldt, Inc. 21
  • Dailey & Associates 19
  • PTI USA, LLC 19
  • Kearns International 16
  • Austrian Trade Commission, Los Angeles 15
  • Earthjustice 15
  • Italian Government Tourist Board (ENIT), Los Angeles 13
  • …

Registrant_Name >30

  • JETRO, Los Angeles 184
  • JETRO, San Francisco 124
  • Netherlands Chamber of Commerce in the U.S. 87
  • New Zealand Milk Products, Inc. 67
  • Tourism Australia 64
  • Korea Trade Center, Los Angeles 59
  • Hong Kong Tourism Board 58
  • Japan National Tourism Organization, Los Angeles 45
  • Pillsbury Winthrop Shaw Pittman, LLP 44
  • Korea National Tourism Organization, Los Angeles 42
  • Fontayne Group, Inc. 37
  • Far East Trade Services, Inc. 36
  • Japan National Tourist Organization, San Francisco 32
  • Wagstaff Worldwide Public Relations, Inc. 32
  • China Books & Periodicals, Inc. 30
  • New South Wales Government Office 29
  • New Zealand Central Reservations Office 29
  • Tourism Authority of Thailand, Los Angeles 29
  • Aviso, Inc. 27
  • Kuomintang of China 27
  • Braun & Company 26
  • Comite Regional Sinarquista en Los Angeles 25
  • Malaysia Tourism Promotion Board 23
  • Camstoll Group, LLC 22
  • Rogers & Cowan, Inc. 22
  • Charles von Loewenfeldt, Inc. 21
  • Dailey & Associates 19
  • Kearns International 19
  • PTI USA, LLC 19
  • California Strategies, LLC 16
  • …

City >30

  • Los Angeles 1,153
  • San Francisco 514
  • Petaluma 67
  • Santa Monica 63
  • Sacramento 49
  • Santa Clara 36
  • Beverly Hills 34
  • Alameda 27
  • Mill Valley 21
  • San Diego 21
  • Chino Hills 19
  • Torrance 17
  • Sunnyvale 16
  • Pasadena 15
  • Palo Alto 10
  • San Jose 10
  • Burbank 9
  • Montebello 9
  • Northridge 9
  • Anaheim 8
  • Universal City 8
  • Encino 7
  • West Hollywood 7
  • Oakland 6
  • South San Francisco 6
  • Alhambra 5
  • Dana Point 5
  • Fresno 5
  • Temple City 5
  • Woodland Hills 5
  • …

State 1

  • CA · 2,224 ✖
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
58 58   2020-01-03 Rabinowitz Matthew R. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
86 86   2020-01-09 Renezeder Fiona Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
136 136   2014-01-17 Grothaus Nicholas Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
146 146   1996-01-18 Morgan Irene Destination New South Wales 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
177 177   2003-01-24 Kor Sabrina (Ya-Rei) Far East Trade Services, Inc. 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
187 187   2006-01-25 Tsai Chia-Hsuan Far East Trade Services, Inc. 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
188 188   2018-01-25 Baker Christopher JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
189 189   2018-01-25 Torres Kumiko Tanaka JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
190 190   2018-01-25 Vermeiren Sachie JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
216 216   2022-01-28 John Maai JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
217 217   2022-01-28 Shibahara Tomonori JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
222 222   2021-01-29 Nakano Chiaki JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
294 294   2022-02-02 Wongseree Marisa Tourism Authority of Thailand, Los Angeles 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
325 325   2023-02-06 Hirano Junko JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
326 326   2023-02-06 Kimura Kota JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
327 327   2023-02-06 Olivieri Elena Actum UK Opco, LLC 7176 2022-10-05 Actum UK Opco, LLC 9000 Sunset Blvd, Floor 3 West Hollywood CA 90069
328 328   2023-02-06 Tsuwaki Yoshiko JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
329 329   2023-02-06 Wanami Takuro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
339 339   2023-02-08 Dodt Kimberly Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
363 363   2002-02-13 Becker Stephan E. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
438 438   2012-02-23 Sprague Esther M. Sprague, Esther Marie 6091 2012-02-23 Sprague, Esther Marie 123 Hanover Street   San Francisco CA 94112
439 439   2019-02-23 Kaplan Aryeh L. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
505 505   2023-03-04 Bass Jonathan Stephen Merchant House Films, LLC 7234 2023-03-04 Merchant House Films, LLC P.O. Box 15084   Beverly Hills CA 90209-1084
531 531   2021-03-08 Shoji Kaoru Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
547 547   2021-03-10 Shahangian Bahman Brian Iranian Resurgent Party I.R.P. 6934 2021-03-10 Iranian Resurgent Party I.R.P. 6603 Independence Avenue   Los Angeles CA 91303
561 561   2021-03-11 Armanous Rana Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
579 579   2020-03-16 Her David K. Hmong Kingdom ChaoFa State - US Representatives 6800 2020-03-16 Hmong Kingdom ChaoFa State - US Representatives P.O. Box 6209   Fresno CA 93703
580 580   2020-03-16 Tubtsimnuj Fang Robert Hmong Kingdom ChaoFa State - US Representatives 6800 2020-03-16 Hmong Kingdom ChaoFa State - US Representatives P.O. Box 6209   Fresno CA 93703
696 696   2021-03-30 Seeharach Siriwan Tourism Authority of Thailand, Los Angeles 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
736 736   2022-04-06 Kitazawa Izumi Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
825 825   2022-04-18 Guy Sr. Frederick R. Ho, Jason 7109 2022-04-18 Ho, Jason 4664 Hill Top View Lane   San Jose CA 95138
863 863   2015-04-24 Moeller Elizabeth V. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
899 899   2021-04-28 La Kellie JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
900 900   2021-04-28 Nakanishi Tomoaki JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
983 983   2021-05-08 Lamp Sarah Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
994 994   2023-05-09 Hayashi Yotetsu JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1007 1007   2022-05-12 Jang You Hyun Korea National Tourism Organization, Los Angeles 2544 1974-10-25 Korea National Tourism Organization, Los Angeles 5509 Wilshire Boulevard Suite 201 Los Angeles CA 90036
1053 1053   2023-05-18 Zherka Ilir Civica LLC 7275 2023-05-18 Civica LLC 18 Eagle Hill Terrace   Redwood City CA 94062
1057 1057   2020-05-19 Setia Mohd Akbal Bin Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
1195 1195   2012-06-06 Syu Shu Jywan Far East Trade Services, Inc. 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
1261 1261   2023-06-20 Johnson Jeffrey Actum UK Opco, LLC 7176 2022-10-05 Actum UK Opco, LLC 9000 Sunset Blvd, Floor 3 West Hollywood CA 90069
1276 1276   2020-06-22 Wu Yi-Rou Far East Trade Services, Inc. 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
1334 1334   2021-06-30 Finch Brian Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
1377 1377   2022-07-08 Chung Billy WCETV 7135 2022-07-08 WCETV 17755 Rowland Street   City of Industry CA 91748
1378 1378   2022-07-08 Chung Grace WCETV 7135 2022-07-08 WCETV 17755 Rowland Street   City of Industry CA 91748
1382 1382   2009-07-10 Ficker Jared California Strategies & Advocacy, LLC 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1383 1383   2009-07-10 Kinney Jason California Strategies & Advocacy, LLC 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1384 1384   2009-07-10 White Robert California Strategies & Advocacy, LLC 5697 2005-07-20 California Strategies & Advocacy, LLC 980 Ninth Street Suite 2000 Sacramento CA 95814
1394 1394   2021-07-12 Ahmad Jaafar Ahmad Nur Fayyadh Malaysian Investment Development Authority 5350 1999-12-10 Malaysian Investment Development Authority 226 Airport Parkway Suite 480 San Jose CA 95110
1402 1402   2023-07-13 Bader Jeffrey A. Jeffrey Bader LLC 7295 2023-07-13 Jeffrey Bader LLC 928 Superba Avenue   Venice CA 90291
1421 1421   2023-07-18 Tapanya Suphasuta Tourism Authority of Thailand, Los Angeles 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
1444 1444   2021-07-20 Tsou ChangChing Far East Trade Services, Inc. 2985 1978-12-06 Far East Trade Services, Inc. 5201 Great America Parkway Suite 306 Santa Clara CA 95054-1122
1458 1458   2013-07-22 Nakhla Mark Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1469 1469   2015-07-23 Krajangsri Candy Tourism Authority of Thailand, Los Angeles 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
1496 1496   2022-07-27 Hamdan Mustafa Mohd Hamim Malaysian Investment Development Authority 5350 1999-12-10 Malaysian Investment Development Authority 226 Airport Parkway Suite 480 San Jose CA 95110
1546 1546   2021-07-30 Nagata Hikara JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1559 1559   2022-08-02 Ma Xiaohung Xin Min International, Inc. 6897 2020-12-01 Xin Min International, Inc. 5250 Sereno Drive   Temple City CA 91780
1560 1560   2023-08-02 Tahler Kristin Quinn Emanuel Urquhart & Sullivan, LLP 7303 2023-08-02 Quinn Emanuel Urquhart & Sullivan, LLP 865 South Figueroa Street, 10th Floor   Los Angeles CA 90017
1621 1621   2006-08-17 Gomm Anne Fabry Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
1622 1622   2006-08-17 Lavalle James Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
1731 1731   2019-09-06 Bress Richard P. Latham & Watkins LLP 6628 2019-01-23 Latham & Watkins LLP 355 South Grand Avenue Suite 100 Los Angeles CA 90071
1733 1733   2019-09-06 Schindler David J. Latham & Watkins LLP 6628 2019-01-23 Latham & Watkins LLP 355 South Grand Avenue Suite 100 Los Angeles CA 90071
1826 1826   2022-09-22 Ando Katsuhiro Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1827 1827   2022-09-22 Furihata Moe Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1831 1831   2022-09-22 Watanabe Kodai Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
1869 1869   2020-09-29 Fast Andrew JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1871 1871   2020-09-29 Shiozaki Misako JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1873 1873   2020-09-29 Yamashita Takanari JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1897 1897   2022-10-05 Hassan Miran Actum UK Opco, LLC 7176 2022-10-05 Actum UK Opco, LLC 9000 Sunset Blvd, Floor 3 West Hollywood CA 90069
1898 1898   2022-10-05 Inanc Tolga Actum UK Opco, LLC 7176 2022-10-05 Actum UK Opco, LLC 9000 Sunset Blvd, Floor 3 West Hollywood CA 90069
1900 1900   2022-10-05 Reid Morris Actum UK Opco, LLC 7176 2022-10-05 Actum UK Opco, LLC 9000 Sunset Blvd, Floor 3 West Hollywood CA 90069
1901 1901   2022-10-05 Toomey Molly Actum UK Opco, LLC 7176 2022-10-05 Actum UK Opco, LLC 9000 Sunset Blvd, Floor 3 West Hollywood CA 90069
2022 2022   2018-10-23 Ferguson William JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2023 2023   2018-10-23 Ishibashi Yuki JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2035 2035   2021-10-26 Nazary Ali International Office of the National Resistance Front of AFGH Inc. 7030 2021-10-26 International Office of the National Resistance Front of AFGH Inc. 4216 Pacific Coast Highway P.O. Box 10301 Torrance CA 90505
2041 2041   2020-10-27 Kamaras Jacob Stellar Jay Communications 6789 2020-01-31 Stellar Jay Communications 8453 Cliffridge Avenue   La Jolla CA 92037
2057 2057   2020-10-29 Ramsey Edward JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2066 2066   2015-10-30 Hunter Naoco JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2067 2067   2015-10-30 Tanaka Mihoko JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2068 2068   2017-10-30 Tomita Hiroshi JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2166 2166   1994-11-14 Monfrini Robert W. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2169 2169   2022-11-14 Ishiguro Seiya JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2202 2202   2021-11-19 Tsai David J. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2203 2203   2012-11-20 Laughlin Gregory H. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2224 2224   2009-11-24 Flora William B. Jr. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
2323 2323   2020-12-01 Su Ting Xin Min International, Inc. 6897 2020-12-01 Xin Min International, Inc. 5250 Sereno Drive   Temple City CA 91780
2324 2324   2020-12-01 Yang Jing Xin Min International, Inc. 6897 2020-12-01 Xin Min International, Inc. 5250 Sereno Drive   Temple City CA 91780
2328 2328   2014-12-02 Barresi Joseph Francis Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2345 2345   2019-12-03 Fischer Nancy A. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2360 2360   2012-12-07 Saperstein Craig J. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2370 2370   2019-12-09 Wall Christopher W. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
2380 2380   2012-12-10 Epstein Matthew Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2381 2381   2012-12-10 Schmidt Benjamin Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2461 2461   2006-12-27 Chomsin Tassanee Tourism Authority of Thailand, Los Angeles 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
2462 2462   2006-12-27 Narongchaisakun Lert Tourism Authority of Thailand, Los Angeles 2178 1969-12-19 Tourism Authority of Thailand, Los Angeles 611 North Larchmont Boulevard 1st Floor Los Angeles CA 90004
2463 2463   2021-12-27 Kwak Wooshin KBS America, Inc. 5684 2005-05-17 KBS America, Inc. 625 South Kingsley Drive 4th Floor Los Angeles CA 90005
2481 2481   2014-12-30 Scott Yohko Japan National Tourism Organization, Los Angeles  2350 1972-07-03 Japan National Tourism Organization, Los Angeles 707 Wilshire Blvd. Suite 4325 Los Angeles CA 90017
2526 2526 1964-01-01 1961-03-02 Scott Wilson New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
2527 2527 1964-01-01 1963-03-26 Guiglia Maria Corella Frente Civico Mexicano de Afirmacion Revolucionaria 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2528 2528 1964-01-01 1963-03-26 Virchis Roman Joseph Frente Civico Mexicano de Afirmacion Revolucionaria 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  

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