FARA_All_ShortForms

Table actions
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,113 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)

State 1

  • CA 1,113

City 1

  • Los Angeles · 1,113 ✖
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
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
156 156   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
157 157   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
158 158   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
183 183   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
185 185   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
187 187   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
248 248   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
425 425   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
468 468   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
488 488   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
649 649   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
692 692   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
944 944   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
989 989   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
1409 1409   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
1420 1420   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
1513 1513   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
1515 1515   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
1602 1602   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
1603 1603   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
1635 1635   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
1709 1709   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
1712 1712   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
1735 1735   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
2098 2098   1994-11-14 Monfrini Robert W. Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2148 2148   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
2383 2383   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
2384 2384   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
2385 2385   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
2386 2386   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
2399 2399   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
2444 2444 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
2445 2445 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  
2446 2446 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  
2447 2447 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  
2470 2470 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
2543 2543 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
2599 2599 1989-01-01 1989-08-16 Hamid Noor Ahmad Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
2727 2727 2002-01-01 1988-07-26 Gray Lyndel Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
2776 2776 2007-01-01 2006-12-08 Milmoe Peter Sitrick and Company, Inc. 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 Austrian Trade Commission, Los Angeles 793 1953-10-21 Austrian Trade Commission, Los Angeles 11601 Wilshire Boulevard Suite 2420 Los Angeles CA 90025
3092 3092 1995-01-04 1990-11-15 Cook Fred Golin/Harris 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3093 3093 1995-01-04 1990-11-15 Yamamoto Deanne Golin/Harris 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3094 3094 1995-01-04 1993-12-30 Crow Maureen B. Golin/Harris 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3095 3095 1995-01-04 1993-12-30 Kintisch Jean Golin/Harris 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3096 3096 1995-01-04 1993-12-30 Walters Bonnie Golin/Harris 4437 1990-11-15 Golin/Harris 601 West Fifth Street 4th Floor Los Angeles CA 90071
3099 3099 2000-01-04 1992-02-10 Leong Charles ASEAN Promotional Chapter for Tourism - North America 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 1999-07-27 Arisman Chilman ASEAN Promotional Chapter for Tourism - North America 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
3101 3101 2000-01-04 1999-07-27 Boncan-Francisco Regina ASEAN Promotional Chapter for Tourism - North America 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
3102 3102 2000-01-04 1999-07-27 Danial Sharifah L. ASEAN Promotional Chapter for Tourism - North America 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 2000-01-04 1999-07-27 Kongrut Niti ASEAN Promotional Chapter for Tourism - North America 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
3104 3104 2000-01-04 1995-09-19 Chindanon Sethapon ASEAN Promotional Chapter for Tourism - North America 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
3107 3107 2007-01-04 2006-08-17 Willus Amy Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
3246 3246 2000-01-07 1995-03-31 Endara Soudad M. Destination New South Wales 4450 1990-12-18 Destination New South Wales 2029 Century Park East Suite 3150 Los Angeles CA 90067
3250 3250 2005-01-07 2000-05-19 Musa Normasila Malaysia Tourism Promotion Board 2510 1974-04-17 Malaysia Tourism Promotion Board 818 West Seventh Street Suite 970 Los Angeles CA 90017-3432
3265 3265 1973-01-08 1958-02-04 Flynn Patricia Mary Tourism Australia 1032 1957-06-03 Tourism Australia 2029 Century Park East Suite 3150 Los Angeles CA 90067
3267 3267 1974-01-08 1972-05-30 Richter, Jr., Ralph L. Richter & Mracky-Bates, Inc. 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3268 3268 1974-01-08 1972-07-11 O'Guin Kathleen Richter & Mracky-Bates, Inc. 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3269 3269 1974-01-08 1972-07-11 Bennett Lita Richter & Mracky-Bates, Inc. 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3270 3270 1974-01-08 1972-07-11 Bennett Sue Richter & Mracky-Bates, Inc. 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3271 3271 1974-01-08 1972-07-11 Carr Brent Richter & Mracky-Bates, Inc. 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3272 3272 1974-01-08 1972-07-11 Urist Harry M. Richter & Mracky-Bates, Inc. 2343 1972-05-30 Richter & Mracky-Bates, Inc. 9255 Sunset Boulevard Suite 116   Los Angeles CA 90069
3398 3398 1985-01-10 1980-03-11 Shurtleff Robert Bruce New South Wales Government Office 1276 1959-09-25 New South Wales Government Office 2049 Century Park, East Suite 2250 Los Angeles CA 90067
3492 3492 1983-01-12 1979-03-05 Hunt Leonard Godfrey New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3537 3537 1992-01-13 1990-07-17 Vitalis Esther Greek National Tourist Organization, Los Angeles 2199 1970-06-09 Greek National Tourist Organization, Los Angeles 611 West Sixth Street Suite 2198 Los Angeles CA 90017
3560 3560 1945-01-14 1944-06-20 Kim Sung K. Korean Independence 266 1944-06-20 Korean Independence 955 West Jefferson Boulevard   Los Angeles CA  
3579 3579 1983-01-14 1979-03-05 Simpson Roger New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3598 3598 2022-01-14 2019-11-29 Jeong Byeongok 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
3685 3685 1999-01-15 1988-09-20 Bakht Mary Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
3686 3686 1999-01-15 1988-09-20 Testa Mary Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
3696 3696 2005-01-15 2001-09-18 Takashi Muneo JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3739 3739 1973-01-16 1952-10-07 Oppenhagen Caroline Helene Marianne 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
3769 3769 1986-01-16 1985-09-16 Horan Michael James Victorian Government Business Office, Los Angeles 3266 1981-08-06 Victorian Government Business Office, Los Angeles 611 North Larchmont Boulevard Second Floor Los Angeles CA 90004
3813 3813 1960-01-17 1951-04-23 Firth Roberts Mathew New Zealand Central Reservations Office 672 1951-04-23 New Zealand Central Reservations Office 6033 West Century Boulevard Suite 1270 Los Angeles CA 90045
3844 3844 1995-01-17 1991-01-17 Suzuki Masahiro JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3850 3850 1995-01-17 1991-12-23 Inagaki Akihisa JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3851 3851 1995-01-17 1991-12-23 Obata Tomoyasu JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
3925 3925 1994-01-18 1991-01-17 Iwaki Shigenori JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4027 4027 1974-01-20 1971-01-31 Ueda Kooichi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4044 4044 1997-01-20 1994-12-29 Kim Yong-Il 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
4045 4045 1999-01-20 1997-07-17 Na Sang Hoon 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
4073 4073 1980-01-21 1977-07-28 Clewis John Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
4111 4111 1964-01-22 1961-09-27 Alioto Samuel Francis 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
4112 4112 1964-01-22 1962-09-28 Kammeijer Christiaan 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
4113 4113 1964-01-22 1962-09-28 Roselaar Louis A. 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
4203 4203 1974-01-24 1969-01-21 Whitehouse Jack P. JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4205 4205 1979-01-24 1979-01-24 Kasagi Shunsuke JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513
4246 4246 1984-01-25 1981-01-27 Chambers Mary Lynn Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4247 4247 1984-01-25 1981-01-27 Masters Tom Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4249 4249 1984-01-25 1964-07-10 Lewis Bud Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4250 4250 1984-01-25 1978-07-17 Scholnick Joseph B. Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4251 4251 1984-01-25 1964-07-30 DeMos John A. Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4252 4252 1984-01-25 1980-10-10 Zaiser Carol Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4253 4253 1984-01-25 1965-10-11 Chanaud Raymond Jean Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4254 4254 1984-01-25 1966-10-20 Ferris Robert Neal Lewis Company, Ltd. 1763 1964-06-19 Lewis Company, Ltd. 650 North Bronson Avenue   Los Angeles CA 90004
4259 4259 1988-01-25 1981-12-02 Sather Richard W. Hong Kong Tourism Board 2110 1968-10-29 Hong Kong Tourism Board 5901 W CENTURY BLVD. SUITE 650 Los Angeles CA 90045
4454 4454 2007-01-26 2006-11-20 Saylor Mark Sitrick and Company, Inc. 5777 2006-11-20 Sitrick and Company, Inc. 1840 Century Park East Suite 800 Los Angeles CA 90067-2109
4488 4488 1985-01-27 1982-08-04 Ishida Takashi JETRO, Los Angeles 1833 1964-12-14 JETRO, Los Angeles 777 South Figueroa Street Suite 3750 Los Angeles CA 90017-2513

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])
);