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,165 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 >30

  • JETRO, Los Angeles 180
  • JETRO, San Francisco 122
  • 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
  • Pillsbury Winthrop Shaw Pittman, LLP 44
  • Japan National Tourism Organization, Los Angeles 42
  • Korea National Tourism Organization, Los Angeles 42
  • Fontayne Group, Inc. 37
  • Far East Trade Services, Inc. 36
  • Japan National Tourist Organization, San Francisco 32
  • China Books & Periodicals, Inc. 30
  • New Zealand Central Reservations Office 29
  • New South Wales Government Office 29
  • Tourism Authority of Thailand, Los Angeles 28
  • Kuomintang of China 27
  • Aviso, Inc. 27
  • Comite Regional Sinarquista en Los Angeles 25
  • Malaysia Tourism Promotion Board 23
  • Charles von Loewenfeldt, Inc. 21
  • Camstoll Group, LLC 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
  • Mexican Tourism Board 13
  • …

Registrant_Name >30

  • JETRO, Los Angeles 180
  • JETRO, San Francisco 122
  • 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
  • Pillsbury Winthrop Shaw Pittman, LLP 44
  • Japan National Tourism Organization, Los Angeles 42
  • Korea National Tourism Organization, Los Angeles 42
  • Fontayne Group, Inc. 37
  • Far East Trade Services, Inc. 36
  • Japan National Tourist Organization, San Francisco 32
  • China Books & Periodicals, Inc. 30
  • New South Wales Government Office 29
  • New Zealand Central Reservations Office 29
  • Tourism Authority of Thailand, Los Angeles 28
  • Aviso, Inc. 27
  • Kuomintang of China 27
  • Braun & Company 26
  • Comite Regional Sinarquista en Los Angeles 25
  • Malaysia Tourism Promotion Board 23
  • Rogers & Cowan, Inc. 22
  • Camstoll Group, LLC 21
  • Charles von Loewenfeldt, Inc. 21
  • Dailey & Associates 19
  • Kearns International 19
  • PTI USA, LLC 19
  • California Strategies, LLC 16
  • Austrian Trade Commission, Los Angeles 15
  • …

City >30

  • Los Angeles 1,113
  • San Francisco 512
  • Petaluma 67
  • Santa Monica 62
  • 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
  • Burbank 9
  • Montebello 9
  • Northridge 9
  • San Jose 9
  • Anaheim 8
  • Universal City 8
  • Encino 7
  • Oakland 6
  • South San Francisco 6
  • Alhambra 5
  • Dana Point 5
  • Fresno 5
  • Woodland Hills 5
  • Hollywood 4
  • La Palma 4
  • …

State 1

  • CA · 2,165 ✖
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
5 5     Guy Sr. Frederick R. Ho, Jason 7109 2022-04-18 Ho, Jason 4664 Hill Top View Lane   San Jose CA 95138
24 24   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
58 58   2020-01-09 Renezeder Fiona Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
83 83   2022-01-12 Clay Lacy Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
114 114   2014-01-17 Grothaus Nicholas Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
120 120   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
147 147   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
156 156   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
157 157   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
158 158   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
159 159   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
184 184   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
186 186   2022-01-28 Mochizuki Jasmine JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
188 188   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
193 193   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
232 232   2020-01-31 Saeki Norihiko JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
255 255   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
326 326   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
365 365   2018-02-20 Merrifield Jeffrey S. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
377 377   2012-02-23 Sprague Esther M. Sprague, Esther Marie 6091 2012-02-23 Sprague, Esther Marie 123 Hanover Street   San Francisco CA 94112
379 379   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
436 436   2020-03-02 Yamagishi Yu 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
482 482   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
503 503   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
516 516   2021-03-11 Armanous Rana Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
541 541   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
542 542   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
672 672   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
719 719   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
831 831   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
860 860   2021-04-28 La Kellie JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
861 861   2021-04-28 Nakanishi Tomoaki JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
960 960   2021-05-08 Lamp Sarah Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
981 981   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
1028 1028   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
1165 1165   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
1229 1229   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
1273 1273   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
1314 1314   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
1315 1315   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
1316 1316   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
1317 1317   2015-07-10 Elam David Richard Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1327 1327   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
1355 1355   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
1359 1359   2013-07-22 Nakhla Mark Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
1365 1365   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
1367 1367   2021-07-23 Oresman Matthew S. Pillsbury Winthrop Shaw Pittman, LLP 5198 1997-07-31 Pillsbury Winthrop Shaw Pittman, LLP Four Embarcadero Center 22nd Floor San Francisco CA 94111-2228
1371 1371   2013-07-26 Sukthavorn Proud 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
1386 1386   2017-07-28 Asai Yasutaka JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1420 1420   2021-07-30 Maurata Keiko JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
1422 1422   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
1491 1491   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
1492 1492   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
1524 1524   2019-08-22 Kishinaka Ayami 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
1611 1611   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
1614 1614   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
1637 1637   2018-09-13 ASO Ryoji 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
1669 1669   2019-09-20 Pejan Ramin Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
1713 1713   2020-09-29 Fast Andrew JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1715 1715   2020-09-29 Shiozaki Misako JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1717 1717   2020-09-29 Yamashita Takanari JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1862 1862   2018-10-23 Ferguson William JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1863 1863   2018-10-23 Ishibashi Yuki JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1874 1874   2007-10-26 Viirg Andrus Enterprise Estonia in San Jose 5833 2007-10-26 Enterprise Estonia in San Jose 440 North Wolfe Road   Sunnyvale CA 94085
1879 1879   2021-10-26 Nazary Ali International Representation of the National Resistance Front of Afghanistan 7030 2021-10-26 International Representation of the National Resistance Front of Afghanistan 4216 Pacific Coast Highway P.O. Box 10301 Torrance CA 90505
1886 1886   2020-10-27 Kamaras Jacob Stellar Jay Communications 6789 2020-01-31 Stellar Jay Communications 8453 Cliffridge Avenue   La Jolla CA 92037
1902 1902   2020-10-29 Ramsey Edward JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1916 1916   2015-10-30 Hunter Naoco JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1917 1917   2015-10-30 Tanaka Mihoko JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1918 1918   2017-10-30 Tarutani Noriya JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1919 1919   2017-10-30 Tomita Hiroshi JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
1963 1963   2021-11-02 Maehiro Yuki JETRO, San Francisco 1813 1964-11-05 JETRO, San Francisco 575 Market Street Suite 2400 San Francisco CA 94105
2033 2033   1994-11-14 Monfrini Robert W. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2068 2068   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
2069 2069   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
2084 2084   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
2192 2192   2020-12-01 Su Ting Xin Min International, Inc. 6897 2020-12-01 Xin Min International, Inc. 5250 Sereno Drive   Temple City CA 91780
2193 2193   2020-12-01 Yang Jing Xin Min International, Inc. 6897 2020-12-01 Xin Min International, Inc. 5250 Sereno Drive   Temple City CA 91780
2194 2194   2020-12-01 Zhu Guoshun Xin Min International, Inc. 6897 2020-12-01 Xin Min International, Inc. 5250 Sereno Drive   Temple City CA 91780
2196 2196   2014-12-02 Barresi Joseph Francis Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2215 2215   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
2233 2233   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
2247 2247   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
2255 2255   2012-12-10 Epstein Matthew Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2256 2256   2012-12-10 Schmidt Benjamin Camstoll Group, LLC 6144 2012-12-10 Camstoll Group, LLC 1112 Montana Avenue #904 Santa Monica CA 90403
2306 2306   2021-12-18 Bustamante Michael California Strategies, LLC 7061 2021-12-18 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
2307 2307   2021-12-18 Klink Matthew California Strategies, LLC 7061 2021-12-18 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
2308 2308   2021-12-18 Kozberg Joanne California Strategies, LLC 7061 2021-12-18 California Strategies, LLC 980 9th Street Suite 2000 Sacramento CA 95814
2315 2315   2021-12-20 Naouai Anissa Maffick LLC 7063 2021-12-20 Maffick LLC 2917 W. Temple Street Suite 102 Los Angeles CA 90026
2333 2333   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
2334 2334   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
2335 2335   2006-12-27 Tuvanuti Yurawat 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
2336 2336   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
2350 2350   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
2396 2396 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
2397 2397 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  
2398 2398 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  
2399 2399 1964-01-01 1963-03-26 Zeman Leland Ellis Frente Civico Mexicano de Afirmacion Revolucionaria 1612 1963-03-26 Frente Civico Mexicano de Afirmacion Revolucionaria 4620 Beverly Boulevard   Los Angeles CA  
2422 2422 1970-01-01 1966-09-07 Vejarano Carlos Netherlands Chamber of Commerce in the U.S. 639 1950-08-22 Netherlands Chamber of Commerce in the U.S. 350 South Figueroa Street Suite 901 Los Angeles CA 90017
2495 2495 1985-01-01 1983-01-28 Nardone Silverio Italian Government Tourist Board (ENIT), Los Angeles 1884 1965-04-19 Italian Government Tourist Board (ENIT), Los Angeles 10850 Wilshire Boulevard Suite 575 Los Angeles CA 90024

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