FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
75 rows where City = "Dallas"
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 18
- Korea Trade Center, Dallas 19
- JETRO, Dallas (Japan External Trade Organization) 10
- Japan National Tourist Organization, Dallas 6
- Allyn & Company 5
- Grant Advertising, Inc. 4
- Sanders & Associates Advertising & Public Relations 4
- Far East Trade Service, Inc., Dallas Branch Office 4
- Mexican Government Tourism Office, Dallas 3
- Santa Fe (U.S. Holdings) Inc. 3
- E. Bruce Harrison Company/Southwest, Inc. 3
- Insignias Global, LLC 3
- Spanish National Tourist Office, Dallas 2
- Unicorp International, Inc. 2
- Kilgore & Kilgore, Inc. 2
- Levenson, Levenson & Hill, Inc. 2
- Cathey, Hutton & Associates, Inc. 1
- DeBello, Yirgu Megerssa 1
- Winstead Sechrest & Minick P.C. 1
Registrant_Name 18
- Korea Trade Center, Dallas 19
- JETRO, Dallas (Japan External Trade Organization) 10
- Japan National Tourist Organization, Dallas 6
- Allyn & Company 5
- Far East Trade Service, Inc., Dallas Branch Office 4
- Grant Advertising, Inc. 4
- Sanders & Associates Advertising & Public Relations 4
- E. Bruce Harrison Company/Southwest, Inc. 3
- Insignias Global, LLC 3
- Mexican Government Tourism Office, Dallas 3
- Santa Fe (U.S. Holdings) Inc. 3
- Kilgore & Kilgore, Inc. 2
- Levenson, Levenson & Hill, Inc. 2
- Spanish National Tourist Office, Dallas 2
- Unicorp International, Inc. 2
- Cathey, Hutton & Associates, Inc. 1
- DeBello, Yirgu Megerssa 1
- Winstead Sechrest & Minick P.C. 1
State 1
- TX 75
City 1
- Dallas · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3098 | 3098 | 2001-01-05 | 2000-04-19 | Kodama | Masaaki | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
4717 | 4717 | 1965-01-31 | 1964-12-17 | Cuevas | Enrique Valles las | Spanish National Tourist Office, Dallas 1836 | 1964-12-17 | Spanish National Tourist Office, Dallas | 1418 Commerce Street | Dallas | TX | 75201 | |
6426 | 6426 | 1987-02-12 | 1985-01-31 | Choi | Kyu Jae | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
7393 | 7393 | 1997-02-25 | 1993-02-16 | Park | Poong | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
7642 | 7642 | 1979-02-28 | 1977-12-02 | Minato | Yunosuke | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
8510 | 8510 | 1988-03-01 | 1987-02-03 | Nakagami | Masaru | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
8699 | 8699 | 1979-03-02 | 1977-08-08 | Yoshihashi | Toshio | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
8707 | 8707 | 1994-03-02 | 1986-08-19 | Shannon | Edfred L. , Jr. | Santa Fe (U.S. Holdings) Inc. 3841 | 1986-06-06 | Santa Fe (U.S. Holdings) Inc. | Two Lincoln Centre | 5420 LBJ Freeway, Suite 1100 | Dallas | TX | 75240-2648 |
8849 | 8849 | 1982-03-04 | 1979-10-01 | Yoshida | Toshi | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
9223 | 9223 | 1979-03-09 | 1977-08-03 | Inoue | Hiro | Unicorp International, Inc. 2818 | 1977-08-03 | Unicorp International, Inc. | 4835 LBJ Freeway | Suite 630 | Dallas | TX | 75234 |
9224 | 9224 | 1979-03-09 | 1977-11-29 | Shaw | John F. | Unicorp International, Inc. 2818 | 1977-08-03 | Unicorp International, Inc. | 4835 LBJ Freeway | Suite 630 | Dallas | TX | 75234 |
9416 | 9416 | 1985-03-12 | 1981-05-28 | Kitade | Akira | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
9867 | 9867 | 2000-03-17 | 1997-04-15 | Hanji | Tadaaki | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
9955 | 9955 | 1994-03-18 | 1991-04-03 | Kondo | Takanori | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
9961 | 9961 | 1997-03-18 | 1994-04-05 | Sugiura | Katsunori | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
10150 | 10150 | 1989-03-21 | 1987-12-22 | Artkop | Gregory Stephan | E. Bruce Harrison Company/Southwest, Inc. 4078 | 1987-12-22 | E. Bruce Harrison Company/Southwest, Inc. | 7920 Beltline Road | Suite 340 | Dallas | TX | 75240 |
10151 | 10151 | 1989-03-21 | 1987-12-22 | McKhann | Emily Priest | E. Bruce Harrison Company/Southwest, Inc. 4078 | 1987-12-22 | E. Bruce Harrison Company/Southwest, Inc. | 7920 Beltline Road | Suite 340 | Dallas | TX | 75240 |
10152 | 10152 | 1989-03-21 | 1987-12-22 | Petruzzello | Michael James | E. Bruce Harrison Company/Southwest, Inc. 4078 | 1987-12-22 | E. Bruce Harrison Company/Southwest, Inc. | 7920 Beltline Road | Suite 340 | Dallas | TX | 75240 |
10155 | 10155 | 1991-03-21 | 1988-12-05 | Asada | Takao | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
10354 | 10354 | 1966-03-24 | 1965-07-20 | Diaz | Enrique Suarez | Spanish National Tourist Office, Dallas 1836 | 1964-12-17 | Spanish National Tourist Office, Dallas | 1418 Commerce Street | Dallas | TX | 75201 | |
10407 | 10407 | 2003-03-24 | 2001-09-06 | Madokoro | Yoichiro | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
11207 | 11207 | 1982-03-31 | 1979-09-25 | Kim | Young Chul | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
11312 | 11312 | 1990-03-31 | 1987-02-17 | Chung | Gil Won | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
11350 | 11350 | 1992-03-31 | 1989-01-19 | Park | Chang Do | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
11402 | 11402 | 1995-03-31 | 1990-02-02 | Suzuki | Seiichi | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
12070 | 12070 | 1976-04-01 | 1976-01-16 | Chun | Hai Chang | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
14174 | 14174 | 1985-04-30 | 1982-09-13 | Lee | Chang Nyul | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
16252 | 16252 | 1993-05-19 | 1989-08-15 | Lee | Joon Hee | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
16298 | 16298 | 1976-05-20 | 1972-07-03 | Kimura | Yoshio | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
17904 | 17904 | 1970-06-01 | 1965-02-16 | Garza | Samuel C. Leon | Mexican Government Tourism Office, Dallas 1857 | 1965-02-16 | Mexican Government Tourism Office, Dallas | 2 Turtle Creek Village | Suite 1416 | Dallas | TX | 75219 |
18481 | 18481 | 1991-06-06 | 1986-06-06 | Bramlett | Arnold W. | Santa Fe (U.S. Holdings) Inc. 3841 | 1986-06-06 | Santa Fe (U.S. Holdings) Inc. | Two Lincoln Centre | 5420 LBJ Freeway, Suite 1100 | Dallas | TX | 75240-2648 |
20498 | 20498 | 1984-06-30 | 1978-10-19 | Hang | Gregory S. L. | Far East Trade Service, Inc., Dallas Branch Office 2971 | 1978-10-19 | Far East Trade Service, Inc., Dallas Branch Office | 2050 Stemmons Freeway | W.T.C. 110, P.O. Box 58007 | Dallas | TX | 75258 |
20710 | 20710 | 1996-06-30 | 1996-05-28 | Levenson | Stan | Levenson, Levenson & Hill, Inc. 5109 | 1996-05-28 | Levenson, Levenson & Hill, Inc. | 600 North Pearl Street | Suite 910 | Dallas | TX | 75201 |
20711 | 20711 | 1996-06-30 | 1996-05-28 | Ronaldi | Lynn | Levenson, Levenson & Hill, Inc. 5109 | 1996-05-28 | Levenson, Levenson & Hill, Inc. | 600 North Pearl Street | Suite 910 | Dallas | TX | 75201 |
21429 | 21429 | 2020-06-30 | 2019-12-31 | Brewster | James | Insignias Global, LLC 6778 | 2019-12-31 | Insignias Global, LLC | 3522 Prescott Avenue | Dallas | TX | 75219 | |
21430 | 21430 | 2020-06-30 | 2019-12-31 | Fox | Kristen | Insignias Global, LLC 6778 | 2019-12-31 | Insignias Global, LLC | 3522 Prescott Avenue | Dallas | TX | 75219 | |
21431 | 21431 | 2020-06-30 | 2019-12-31 | Satawake | Bob Joe | Insignias Global, LLC 6778 | 2019-12-31 | Insignias Global, LLC | 3522 Prescott Avenue | Dallas | TX | 75219 | |
22793 | 22793 | 1996-07-16 | 1997-02-25 | Choi | Kwang-Soo | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
22794 | 22794 | 1996-07-16 | 1997-02-25 | Gahng | Young J. | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
22795 | 22795 | 1996-07-16 | 1997-02-25 | Park | Sung | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
22796 | 22796 | 1996-07-16 | 1990-08-21 | Oh | Jae Ho | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
23022 | 23022 | 1985-07-19 | 1982-05-13 | Brudno | Walter W. | Kilgore & Kilgore, Inc. 3369 | 1982-05-13 | Kilgore & Kilgore, Inc. | 1800 InterFirst One | Dallas | TX | 75202 | |
23023 | 23023 | 1985-07-19 | 1982-05-13 | Laity | Eric T. | Kilgore & Kilgore, Inc. 3369 | 1982-05-13 | Kilgore & Kilgore, Inc. | 1800 InterFirst One | Dallas | TX | 75202 | |
23673 | 23673 | 1977-07-28 | 1977-07-28 | Burnside | Janet R. | Sanders & Associates Advertising & Public Relations 2816 | 1977-07-28 | Sanders & Associates Advertising & Public Relations | 5025 North Central Expressway | Suite 2030 | Dallas | TX | 75205 |
23674 | 23674 | 1977-07-28 | 1977-07-28 | Leatherwood | Karen C. | Sanders & Associates Advertising & Public Relations 2816 | 1977-07-28 | Sanders & Associates Advertising & Public Relations | 5025 North Central Expressway | Suite 2030 | Dallas | TX | 75205 |
23675 | 23675 | 1977-07-28 | 1977-07-28 | Sanders | George T. | Sanders & Associates Advertising & Public Relations 2816 | 1977-07-28 | Sanders & Associates Advertising & Public Relations | 5025 North Central Expressway | Suite 2030 | Dallas | TX | 75205 |
23676 | 23676 | 1977-07-28 | 1977-07-28 | Squires | James | Sanders & Associates Advertising & Public Relations 2816 | 1977-07-28 | Sanders & Associates Advertising & Public Relations | 5025 North Central Expressway | Suite 2030 | Dallas | TX | 75205 |
24026 | 24026 | 1965-07-31 | 1965-02-16 | Villarreal | Raul Flores | Mexican Government Tourism Office, Dallas 1857 | 1965-02-16 | Mexican Government Tourism Office, Dallas | 2 Turtle Creek Village | Suite 1416 | Dallas | TX | 75219 |
25599 | 25599 | 1980-08-08 | 1976-11-15 | Takenoshita | Hisayoshi | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
26833 | 26833 | 2003-08-27 | 2003-08-05 | Flukinger | Scott | Winstead Sechrest & Minick P.C. 5571 | 2003-08-05 | Winstead Sechrest & Minick P.C. | 5400 Renaissance Tower | 1201 Elm Street | Dallas | TX | 75270 |
27053 | 27053 | 1979-08-30 | 1978-10-19 | Chen | Eugene I. J. | Far East Trade Service, Inc., Dallas Branch Office 2971 | 1978-10-19 | Far East Trade Service, Inc., Dallas Branch Office | 2050 Stemmons Freeway | W.T.C. 110, P.O. Box 58007 | Dallas | TX | 75258 |
28927 | 28927 | 2002-09-12 | 1993-11-12 | Kiuchi | Shinkichi | JETRO, Dallas (Japan External Trade Organization) 2820 | 1977-08-08 | JETRO, Dallas (Japan External Trade Organization) | 2050 Stemmons Freeway #152-1 | P.O. Box 420370 | Dallas | TX | 75342-0370 |
30386 | 30386 | 1995-09-30 | 1993-02-16 | Kim | Hyung-Wonk | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
30395 | 30395 | 1995-09-30 | 1993-05-19 | Song | Dong-Kyu | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
31081 | 31081 | 1976-10-01 | 1976-01-16 | Um | Chang Sub | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
32576 | 32576 | 1985-10-22 | 1965-08-31 | Flores | Hector Escamilla | Mexican Government Tourism Office, Dallas 1857 | 1965-02-16 | Mexican Government Tourism Office, Dallas | 2 Turtle Creek Village | Suite 1416 | Dallas | TX | 75219 |
34934 | 34934 | 1984-11-14 | 1984-07-20 | Wang | Gary | Far East Trade Service, Inc., Dallas Branch Office 2971 | 1978-10-19 | Far East Trade Service, Inc., Dallas Branch Office | 2050 Stemmons Freeway | W.T.C. 110, P.O. Box 58007 | Dallas | TX | 75258 |
34995 | 34995 | 1976-11-15 | 1976-01-16 | Kim | Joo Sung | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
35247 | 35247 | 1993-11-19 | 1992-11-06 | Keller | Lawrence P. | Cathey, Hutton & Associates, Inc. 4732 | 1992-11-06 | Cathey, Hutton & Associates, Inc. | 2711 LBJ Freeway | Suite 560 | Dallas | TX | 75234 |
35890 | 35890 | 1988-11-30 | 1985-09-16 | Suh | Jung-Rak | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
35953 | 35953 | 1993-11-30 | 1993-11-10 | Debello | Yirgu Megerssa | DeBello, Yirgu Megerssa 4868 | 1993-11-10 | DeBello, Yirgu Megerssa | 7100 San Mateo Blvd. | Apt. 212 | Dallas | TX | 75223-1083 |
36778 | 36778 | 1986-12-02 | 1986-12-02 | Okada | Toyokazu | Japan National Tourist Organization, Dallas 2348 | 1972-07-03 | Japan National Tourist Organization, Dallas | 2121 San Jacinto Street | Suite 980 - LB-53 | Dallas | TX | 75201 |
37183 | 37183 | 1982-12-10 | 1980-02-26 | Kang | Seok Kap | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
37421 | 37421 | 1956-12-14 | 1955-06-14 | Carpenter | Paul Althouse | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
37422 | 37422 | 1956-12-14 | 1955-06-14 | Marvin | Robert Carl | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
37423 | 37423 | 1956-12-14 | 1955-06-14 | Weinsoff | Portia | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
37424 | 37424 | 1956-12-14 | 1955-08-03 | Reede | William | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
37693 | 37693 | 1986-12-17 | 1985-04-11 | Han | Young Woo | Korea Trade Center, Dallas 2652 | 1976-01-16 | Korea Trade Center, Dallas | 12720 Hillcrest Road | Suite 390 | Dallas | TX | 75230-2040 |
39379 | 39379 | 1982-12-31 | 1980-08-19 | Yu | Charles T. C. | Far East Trade Service, Inc., Dallas Branch Office 2971 | 1978-10-19 | Far East Trade Service, Inc., Dallas Branch Office | 2050 Stemmons Freeway | W.T.C. 110, P.O. Box 58007 | Dallas | TX | 75258 |
39511 | 39511 | 1986-12-31 | 1986-06-06 | Walton | James K. | Santa Fe (U.S. Holdings) Inc. 3841 | 1986-06-06 | Santa Fe (U.S. Holdings) Inc. | Two Lincoln Centre | 5420 LBJ Freeway, Suite 1100 | Dallas | TX | 75240-2648 |
40663 | 40663 | 2006-12-31 | 2005-12-27 | Allyn | Rob | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
40664 | 40664 | 2006-12-31 | 2005-12-27 | Griesenbeck | Kelly | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
40665 | 40665 | 2006-12-31 | 2005-12-27 | Reyes | Claire | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
40666 | 40666 | 2006-12-31 | 2005-12-27 | Ring | Jennifer | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
40667 | 40667 | 2006-12-31 | 2005-12-27 | Stewart | Jeremy | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );