FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Address_2 = "" and City = "Dallas"
This data as json, CSV (advanced)
Suggested facets: Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]) );