FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
76 rows where City = "Dallas"
This data as json, CSV (advanced)
Suggested facets: Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
Registration_Number 19
- 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
- Bailey Strategic Advisors, LLC 1
Registrant_Name 19
- 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
- Bailey Strategic Advisors, LLC 1
- Cathey, Hutton & Associates, Inc. 1
- DeBello, Yirgu Megerssa 1
- Winstead Sechrest & Minick P.C. 1
State 1
- TX 76
City 1
- Dallas · 76 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3242 | 3242 | 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 |
4915 | 4915 | 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 | |
6648 | 6648 | 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 |
7640 | 7640 | 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 |
7887 | 7887 | 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 |
8765 | 8765 | 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 |
8965 | 8965 | 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 |
8973 | 8973 | 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 |
9116 | 9116 | 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 |
9507 | 9507 | 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 |
9508 | 9508 | 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 |
9709 | 9709 | 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 |
10165 | 10165 | 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 |
10254 | 10254 | 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 |
10260 | 10260 | 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 |
10449 | 10449 | 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 |
10450 | 10450 | 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 |
10451 | 10451 | 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 |
10454 | 10454 | 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 |
10655 | 10655 | 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 | |
10708 | 10708 | 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 |
11514 | 11514 | 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 |
11619 | 11619 | 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 |
11657 | 11657 | 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 |
11709 | 11709 | 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 |
12417 | 12417 | 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 |
14559 | 14559 | 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 |
16697 | 16697 | 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 |
16745 | 16745 | 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 |
18398 | 18398 | 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 |
18984 | 18984 | 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 |
21031 | 21031 | 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 |
21243 | 21243 | 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 |
21244 | 21244 | 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 |
21964 | 21964 | 2020-06-30 | 2019-12-31 | Brewster | James | Insignias Global, LLC 6778 | 2019-12-31 | Insignias Global, LLC | 3522 Prescott Avenue | Dallas | TX | 75219 | |
21965 | 21965 | 2020-06-30 | 2019-12-31 | Fox | Kristen | Insignias Global, LLC 6778 | 2019-12-31 | Insignias Global, LLC | 3522 Prescott Avenue | Dallas | TX | 75219 | |
21966 | 21966 | 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 | |
23379 | 23379 | 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 |
23380 | 23380 | 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 |
23381 | 23381 | 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 |
23382 | 23382 | 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 |
23608 | 23608 | 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 | |
23609 | 23609 | 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 | |
24293 | 24293 | 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 |
24294 | 24294 | 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 |
24295 | 24295 | 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 |
24296 | 24296 | 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 |
24648 | 24648 | 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 |
26258 | 26258 | 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 |
27527 | 27527 | 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 |
27748 | 27748 | 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 |
29644 | 29644 | 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 |
30637 | 30637 | 2022-09-27 | 2022-09-21 | Bailey | Roy W. | Bailey Strategic Advisors, LLC 7171 | 2022-09-21 | Bailey Strategic Advisors, LLC | 3953 Maple Avenue | Dallas | TX | 75219 | |
31116 | 31116 | 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 |
31125 | 31125 | 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 |
31833 | 31833 | 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 |
33358 | 33358 | 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 |
35747 | 35747 | 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 |
35808 | 35808 | 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 |
36060 | 36060 | 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 |
36709 | 36709 | 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 |
36772 | 36772 | 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 |
37611 | 37611 | 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 |
38020 | 38020 | 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 |
38261 | 38261 | 1956-12-14 | 1955-06-14 | Carpenter | Paul Althouse | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
38262 | 38262 | 1956-12-14 | 1955-06-14 | Marvin | Robert Carl | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
38263 | 38263 | 1956-12-14 | 1955-06-14 | Weinsoff | Portia | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
38264 | 38264 | 1956-12-14 | 1955-08-03 | Reede | William | Grant Advertising, Inc. 895 | 1955-06-14 | Grant Advertising, Inc. | 2003 Davis Building | Dallas | TX | ||
38541 | 38541 | 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 |
40236 | 40236 | 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 |
40368 | 40368 | 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 |
41520 | 41520 | 2006-12-31 | 2005-12-27 | Allyn | Rob | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
41521 | 41521 | 2006-12-31 | 2005-12-27 | Griesenbeck | Kelly | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
41522 | 41522 | 2006-12-31 | 2005-12-27 | Reyes | Claire | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
41523 | 41523 | 2006-12-31 | 2005-12-27 | Ring | Jennifer | Allyn & Company 5725 | 2005-12-27 | Allyn & Company | 3232 McKinney Avenue | Suite 660 | Dallas | TX | 75204 |
41524 | 41524 | 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]) );