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

75 rows where City = "Dallas"

✎ View and edit SQL

This data as json, atom, 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

State

City

  • 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
2366 2366   2019-12-31 Brewster James 6778 6778 2019-12-31 Insignias Global, LLC 3522 Prescott Avenue   Dallas TX 75219
2367 2367   2019-12-31 Fox Kristen 6778 6778 2019-12-31 Insignias Global, LLC 3522 Prescott Avenue   Dallas TX 75219
2368 2368   2019-12-31 Satawake Bob Joe 6778 6778 2019-12-31 Insignias Global, LLC 3522 Prescott Avenue   Dallas TX 75219
3089 3089 2001-01-05 2000-04-19 Kodama Masaaki 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
4625 4625 1965-01-31 1964-12-17 Cuevas Enrique Valles las 1836 1836 1964-12-17 Spanish National Tourist Office, Dallas 1418 Commerce Street   Dallas TX 75201
6244 6244 1987-02-12 1985-01-31 Choi Kyu Jae 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
7149 7149 1997-02-25 1993-02-16 Park Poong 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
7383 7383 1979-02-28 1977-12-02 Minato Yunosuke 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
8161 8161 1988-03-01 1987-02-03 Nakagami Masaru 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
8333 8333 1979-03-02 1977-08-08 Yoshihashi Toshio 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
8341 8341 1994-03-02 1986-08-19 Shannon Edfred L. , Jr. 3841 3841 1986-06-06 Santa Fe (U.S. Holdings) Inc. Two Lincoln Centre 5420 LBJ Freeway, Suite 1100 Dallas TX 75240-2648
8478 8478 1982-03-04 1979-10-01 Yoshida Toshi 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
8848 8848 1979-03-09 1977-08-03 Inoue Hiro 2818 2818 1977-08-03 Unicorp International, Inc. 4835 LBJ Freeway Suite 630 Dallas TX 75234
8849 8849 1979-03-09 1977-11-29 Shaw John F. 2818 2818 1977-08-03 Unicorp International, Inc. 4835 LBJ Freeway Suite 630 Dallas TX 75234
9032 9032 1985-03-12 1981-05-28 Kitade Akira 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
9475 9475 2000-03-17 1997-04-15 Hanji Tadaaki 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
9563 9563 1994-03-18 1991-04-03 Kondo Takanori 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
9569 9569 1997-03-18 1994-04-05 Sugiura Katsunori 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
9756 9756 1989-03-21 1987-12-22 Artkop Gregory Stephan 4078 4078 1987-12-22 E. Bruce Harrison Company/Southwest, Inc. 7920 Beltline Road Suite 340 Dallas TX 75240
9757 9757 1989-03-21 1987-12-22 McKhann Emily Priest 4078 4078 1987-12-22 E. Bruce Harrison Company/Southwest, Inc. 7920 Beltline Road Suite 340 Dallas TX 75240
9758 9758 1989-03-21 1987-12-22 Petruzzello Michael James 4078 4078 1987-12-22 E. Bruce Harrison Company/Southwest, Inc. 7920 Beltline Road Suite 340 Dallas TX 75240
9761 9761 1991-03-21 1988-12-05 Asada Takao 2820 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 1966-03-24 1965-07-20 Diaz Enrique Suarez 1836 1836 1964-12-17 Spanish National Tourist Office, Dallas 1418 Commerce Street   Dallas TX 75201
10008 10008 2003-03-24 2001-09-06 Madokoro Yoichiro 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
10793 10793 1982-03-31 1979-09-25 Kim Young Chul 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
10898 10898 1990-03-31 1987-02-17 Chung Gil Won 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
10936 10936 1992-03-31 1989-01-19 Park Chang Do 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
10988 10988 1995-03-31 1990-02-02 Suzuki Seiichi 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
11590 11590 1976-04-01 1976-01-16 Chun Hai Chang 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
13600 13600 1985-04-30 1982-09-13 Lee Chang Nyul 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
15512 15512 1993-05-19 1989-08-15 Lee Joon Hee 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
15554 15554 1976-05-20 1972-07-03 Kimura Yoshio 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
17091 17091 1970-06-01 1965-02-16 Garza Samuel C. Leon 1857 1857 1965-02-16 Mexican Government Tourism Office, Dallas 2 Turtle Creek Village Suite 1416 Dallas TX 75219
17636 17636 1991-06-06 1986-06-06 Bramlett Arnold W. 3841 3841 1986-06-06 Santa Fe (U.S. Holdings) Inc. Two Lincoln Centre 5420 LBJ Freeway, Suite 1100 Dallas TX 75240-2648
19613 19613 1984-06-30 1978-10-19 Hang Gregory S. L. 2971 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
19825 19825 1996-06-30 1996-05-28 Levenson Stan 5109 5109 1996-05-28 Levenson, Levenson & Hill, Inc. 600 North Pearl Street Suite 910 Dallas TX 75201
19826 19826 1996-06-30 1996-05-28 Ronaldi Lynn 5109 5109 1996-05-28 Levenson, Levenson & Hill, Inc. 600 North Pearl Street Suite 910 Dallas TX 75201
21775 21775 1996-07-16 1997-02-25 Choi Kwang-Soo 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
21776 21776 1996-07-16 1997-02-25 Gahng Young J. 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
21777 21777 1996-07-16 1997-02-25 Park Sung 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
21778 21778 1996-07-16 1990-08-21 Oh Jae Ho 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
21988 21988 1985-07-19 1982-05-13 Brudno Walter W. 3369 3369 1982-05-13 Kilgore & Kilgore, Inc. 1800 InterFirst One   Dallas TX 75202
21989 21989 1985-07-19 1982-05-13 Laity Eric T. 3369 3369 1982-05-13 Kilgore & Kilgore, Inc. 1800 InterFirst One   Dallas TX 75202
22628 22628 1977-07-28 1977-07-28 Burnside Janet R. 2816 2816 1977-07-28 Sanders & Associates Advertising & Public Relations 5025 North Central Expressway Suite 2030 Dallas TX 75205
22629 22629 1977-07-28 1977-07-28 Leatherwood Karen C. 2816 2816 1977-07-28 Sanders & Associates Advertising & Public Relations 5025 North Central Expressway Suite 2030 Dallas TX 75205
22630 22630 1977-07-28 1977-07-28 Sanders George T. 2816 2816 1977-07-28 Sanders & Associates Advertising & Public Relations 5025 North Central Expressway Suite 2030 Dallas TX 75205
22631 22631 1977-07-28 1977-07-28 Squires James 2816 2816 1977-07-28 Sanders & Associates Advertising & Public Relations 5025 North Central Expressway Suite 2030 Dallas TX 75205
22974 22974 1965-07-31 1965-02-16 Villarreal Raul Flores 1857 1857 1965-02-16 Mexican Government Tourism Office, Dallas 2 Turtle Creek Village Suite 1416 Dallas TX 75219
24477 24477 1980-08-08 1976-11-15 Takenoshita Hisayoshi 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
25656 25656 2003-08-27 2003-08-05 Flukinger Scott 5571 5571 2003-08-05 Winstead Sechrest & Minick P.C. 5400 Renaissance Tower 1201 Elm Street Dallas TX 75270
25869 25869 1979-08-30 1978-10-19 Chen Eugene I. J. 2971 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
27690 27690 2002-09-12 1993-11-12 Kiuchi Shinkichi 2820 2820 1977-08-08 JETRO, Dallas (Japan External Trade Organization) 2050 Stemmons Freeway #152-1 P.O. Box 420370 Dallas TX 75342-0370
29119 29119 1995-09-30 1993-02-16 Kim Hyung-Wonk 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
29128 29128 1995-09-30 1993-05-19 Song Dong-Kyu 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
29769 29769 1976-10-01 1976-01-16 Um Chang Sub 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
31200 31200 1985-10-22 1965-08-31 Flores Hector Escamilla 1857 1857 1965-02-16 Mexican Government Tourism Office, Dallas 2 Turtle Creek Village Suite 1416 Dallas TX 75219
33445 33445 1984-11-14 1984-07-20 Wang Gary 2971 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
33506 33506 1976-11-15 1976-01-16 Kim Joo Sung 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
33752 33752 1993-11-19 1992-11-06 Keller Lawrence P. 4732 4732 1992-11-06 Cathey, Hutton & Associates, Inc. 2711 LBJ Freeway Suite 560 Dallas TX 75234
34357 34357 1988-11-30 1985-09-16 Suh Jung-Rak 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
34420 34420 1993-11-30 1993-11-10 Debello Yirgu Megerssa 4868 4868 1993-11-10 DeBello, Yirgu Megerssa 7100 San Mateo Blvd. Apt. 212 Dallas TX 75223-1083
35150 35150 1986-12-02 1986-12-02 Okada Toyokazu 2348 2348 1972-07-03 Japan National Tourist Organization, Dallas 2121 San Jacinto Street Suite 980 - LB-53 Dallas TX 75201
35538 35538 1982-12-10 1980-02-26 Kang Seok Kap 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
35774 35774 1956-12-14 1955-06-14 Carpenter Paul Althouse 895 895 1955-06-14 Grant Advertising, Inc. 2003 Davis Building   Dallas TX  
35775 35775 1956-12-14 1955-06-14 Marvin Robert Carl 895 895 1955-06-14 Grant Advertising, Inc. 2003 Davis Building   Dallas TX  
35776 35776 1956-12-14 1955-06-14 Weinsoff Portia 895 895 1955-06-14 Grant Advertising, Inc. 2003 Davis Building   Dallas TX  
35777 35777 1956-12-14 1955-08-03 Reede William 895 895 1955-06-14 Grant Advertising, Inc. 2003 Davis Building   Dallas TX  
36030 36030 1986-12-17 1985-04-11 Han Young Woo 2652 2652 1976-01-16 Korea Trade Center, Dallas 12720 Hillcrest Road Suite 390 Dallas TX 75230-2040
37703 37703 1982-12-31 1980-08-19 Yu Charles T. C. 2971 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
37835 37835 1986-12-31 1986-06-06 Walton James K. 3841 3841 1986-06-06 Santa Fe (U.S. Holdings) Inc. Two Lincoln Centre 5420 LBJ Freeway, Suite 1100 Dallas TX 75240-2648
38986 38986 2006-12-31 2005-12-27 Allyn Rob 5725 5725 2005-12-27 Allyn & Company 3232 McKinney Avenue Suite 660 Dallas TX 75204
38987 38987 2006-12-31 2005-12-27 Griesenbeck Kelly 5725 5725 2005-12-27 Allyn & Company 3232 McKinney Avenue Suite 660 Dallas TX 75204
38988 38988 2006-12-31 2005-12-27 Reyes Claire 5725 5725 2005-12-27 Allyn & Company 3232 McKinney Avenue Suite 660 Dallas TX 75204
38989 38989 2006-12-31 2005-12-27 Ring Jennifer 5725 5725 2005-12-27 Allyn & Company 3232 McKinney Avenue Suite 660 Dallas TX 75204
38990 38990 2006-12-31 2005-12-27 Stewart Jeremy 5725 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 · Query took 321.243ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history