FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
7 rows where Short_Form_Last_Name = "Contreras"
This data as json, CSV (advanced)
Suggested facets: Address_1, Zip, Short_Form_Date (date)
Registration_Number 7
Registrant_Name 7
City 6
- Overland Park 2
- Chicago 1
- Miami 1
- New York 1
- Phoenix 1
- Universal City 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2424 | 2424 | 2018-12-18 | Contreras | Susana Iakovliev | Myriad International Marketing, LLC 6549 | 2018-04-30 | Myriad International Marketing, LLC | 7309 W. 80th Street | Suite 400 | Overland Park | KS | 66204 | |
33706 | 33706 | 1994-10-27 | 1992-03-03 | Contreras | Nancy | Moya, Villanueva & Associates 4629 | 1992-03-03 | Moya, Villanueva & Associates | 10 Universal City Plaza | Suite 2600 | Universal City | CA | 91608-1084 |
35930 | 35930 | 2019-11-15 | 2018-06-29 | Contreras | Susana lakovliev | MMGY Global, LLC 6492 | 2017-11-27 | MMGY Global, LLC | 7309 W. 80th Street | #400 | Overland Park | KS | 66204 |
36024 | 36024 | 1988-11-18 | 1987-11-30 | Contreras | Martha | Friends of Democracy, Inc. 4065 | 1987-11-30 | Friends of Democracy, Inc. | 10380 Southwest 140th Street | Miami | FL | 33176 | |
37291 | 37291 | 1971-12-01 | 1967-12-12 | Contreras | Jose Luciano | Partido Quisqueyano Democrata 2066 | 1967-12-12 | Partido Quisqueyano Democrata | 56 Fort Washington Avenue | Apartment 65 | New York | NY | 10032 |
40001 | 40001 | 1976-12-31 | 1965-02-04 | Contreras | Norman Roy Williams | Mexican Ministry of Tourism, Chicago 1852 | 1965-02-04 | Mexican Ministry of Tourism, Chicago | 210 North Michigan Avenue | Chicago | IL | 60601 | |
40102 | 40102 | 1979-12-31 | 1970-08-07 | Contreras | Norman Williams | Mexican Government Tourism Office, Phoenix 2201 | 1970-07-10 | Mexican Government Tourism Office, Phoenix | 3443 North Central Avenue | Suite 101 | Phoenix | AZ | 85012 |
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]) );