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

76 rows where City = "Dallas"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_1, Address_2, Short_Form_Termination_Date (date), Short_Form_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

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