FARA_All_Registrants
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "Denver"
This data as json, CSV (advanced)
Address_1 10
Termination_Date (date) 8 ✖
- 1975-06-02 1
- 1981-02-10 1
- 1984-02-08 1
- 1985-10-22 1
- 1994-05-26 1
- 2004-10-28 1
- 2007-10-17 1
- 2021-09-29 1
State 1
- CO 10
City 1
- Denver · 10 ✖
Registration_Number ▼ | Registration_Date | Termination_Date | Name | Business_Name | Address_1 | Address_2 | City | State | Zip |
---|---|---|---|---|---|---|---|---|---|
2455 | 1973-08-24 | 1985-10-22 | Mexican Government Tourism Office, Denver | Consejo Nacional de Turismo | 425 South Cherry Street | Suite 640 | Denver | CO | 80222 |
2499 | 1974-02-28 | 1975-06-02 | Korea Trade Promotion Office, Denver | 718 - 17th Street | Denver | CO | 80202 | ||
3074 | 1979-12-11 | 1981-02-10 | Noranda Exploration, Inc. | 12640 West Cedar Drive | Post Office Box 15638 | Denver | CO | 80214 | |
3511 | 1983-08-16 | 1984-02-08 | William Kostka & Associates, Inc. | 1407 Larimer Square | Denver | CO | 80202 | ||
4017 | 1987-07-28 | 2004-10-28 | JETRO, Denver | 1200 - 17th Street | Suite 1110 | Denver | CO | 80202 | |
4730 | 1992-11-03 | 1994-05-26 | DGL International Publishing, Ltd., Liability Company | C/O Denver Centerpoint | 3900 East Mexico Avenue #330 | Denver | CO | 80210 | |
5818 | 2007-07-02 | 2007-10-17 | Brownstein Hyatt Farber Schreck, P.C. | 410 Seventeenth Street | Suite 2200 | Denver | CO | 80802-4437 | |
5870 | 2008-06-16 | Brownstein Hyatt Farber Schreck, LLP | 675 15th Street | Suite 2900 | Denver | CO | 80202-4432 | ||
6963 | 2021-05-19 | 2021-09-29 | Miklosi, Joe | 2205 South Holly Street | Unit 8 | Denver | CO | 80222 | |
6965 | 2021-05-26 | Novitas Communication Inc. | 1732 Wazee Street | Suite 201 | Denver | CO | 80202 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [FARA_All_Registrants] ( [Registration_Number] INTEGER PRIMARY KEY, [Registration_Date] TEXT, [Termination_Date] TEXT, [Name] TEXT, [Business_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );