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)
Registration_Number 11
- Korea Trade Center, Dallas 7
- Allyn & Company 5
- Grant Advertising, Inc. 4
- Far East Trade Service, Inc., Dallas Branch Office 2
- Mexican Government Tourism Office, Dallas 1
- Japan National Tourist Organization, Dallas 1
- JETRO, Dallas (Japan External Trade Organization) 1
- Santa Fe (U.S. Holdings) Inc. 1
- Cathey, Hutton & Associates, Inc. 1
- DeBello, Yirgu Megerssa 1
- Bailey Strategic Advisors, LLC 1
Registrant_Name 11
- Korea Trade Center, Dallas 7
- Allyn & Company 5
- Grant Advertising, Inc. 4
- Far East Trade Service, Inc., Dallas Branch Office 2
- Bailey Strategic Advisors, LLC 1
- Cathey, Hutton & Associates, Inc. 1
- DeBello, Yirgu Megerssa 1
- JETRO, Dallas (Japan External Trade Organization) 1
- Japan National Tourist Organization, Dallas 1
- Mexican Government Tourism Office, Dallas 1
- Santa Fe (U.S. Holdings) Inc. 1
State 1
- TX 25
City 1
- Dallas · 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]) );