Current Data Sets for Go Code Colorado

Over 250 of the datasets and maps available on the Colorado Information Marketplace have been curated and are maintained by the Go Code Colorado data team in collaboration with the agency providing the data. Use keyword “gocodecolorado” to search for type = dataset -or- type = map. Or from reading the related dataset descriptions on this page.

The Go Code Colorado data team publishes public data sets that are relevant to the Go Code Colorado challenge statement. Stay tuned to this page for updates, new data is being added all the time.


COLORADO SECRETARY OF STATE: BUSINESS ENTITIES

The Colorado Secretary of State Business and Licensing Division maintains multiple datasets in what is referred to as a suite of data sets. The primary data set is entitled Business Entities and is a roster of all businesses registered with the State of Colorado since 1864. It includes the entity formation date and the current status, however, it does not clarify if the address listed is a physical retail space or a mailing address. Also included in this suite are a rosters of Corporate Transactions, Trademarks and Tradenames – all dating back to the 1800s. Additionally there are eight datasets related to Charities and three related to Uniform Commercial Code Filings. For more info check out GitHub Resource.

COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT: INCOME, INDUSTRY, EMPLOYMENT STATS

Created by local surveys, this data is aggregated by the Federal government and then anonymized by the state and housed in the Labor and Market Information database. This is a suite of six data sets that include SIC and NAICS industry codes (876 unique occupation types for all Colorado Counties), personal income by county, occupational statistics, employment and unemployment statistics and the Consumer Price Index, which reports prices paid by urban consumers for a representative basket of goods and services and can be used to observe changes in prices.

COLORADO DEPARTMENT OF LOCAL AFFAIRS: CENSUS

The census is made available by the Federal government, but the advantage of using the datasets prepared by the Demography Office in the Department of Local Affairs and published to CIM is that they have been cleaned and joined with their geometric boundaries and clipped to Colorado to maximize user friendliness. The Demography Office also publishes a Population Projections data set (1990-2040). Additional resources available GitHub>kbase>Census.

There are approximately 150 fields from ACS available in this cleaned format for Colorado, represented thematically by these selected groups: (1)Median Household Income, Median Family Income, Per Capita Income, Persons by Poverty Status in Previous Year, Total Households; (2) Total Families, Households by Household Type by Household Size, Persons in Group Quarters by Detailed Group Quarters Type; (3) Travel Time to Work, Mode of Travel, Total Housing Units, Housing Units by Occupancy Status, Vacant Housing Units by Vacancy Status, Occupied Housing Units by Tenure, Median Housing Value, Median Contract Rent.

City and County of Denver Datasets on CIM

The City and County of Denver public data portal has over 200 datasets, and 10 have been published to CIM to improve discoverability and provide API access. The datasets selected as a pilot for 2019, like most data for Go Code Colorado, was selected based on likelihood of application to solving business problems. Active Business Licenses Denver has geocode limitations just like the State’s business entity roster, but datasets like Food Stores in Denver, Body Art Licenses Denver and Points of Interest in Denver all provide a view into the actual physical location of businesses by industry type. Also relevant are the ever-growing General Improvement Districts Denver, Neighborhood Business Revitalization Corridors Denver and Business Improvement Districts Denver. Other datasets can provide indicators of things that impact quality of life such that their uses are varied and the possibilities are endless, like Tree Inventory Denver and Tree Canopy Assessment 2013 Denver. Finally, Denver Parcels is updated daily, but if you’re looking to compare parcels across jurisdictions consider using the Statewide Aggregate Parcels, and find documentation on why the fields are different in the two datasets in the GitHub>Kbase>CO-GIS/OIT doc.

Marijuana Data

The Colorado Department of Revenue has published data on revenue from marijuana sales as well as tax revenues from marijuana sales, dating back to 2014 (when cannabis was legalized in Colorado). Two datasets are focused on the the special tax on marijuana (city and county). Another two datasets are on the revenues from Marijuana sales: sales revenue totals and the standard 2.9% sales tax revenues. Most recently published is the Licensed Marijuana Businesses in Colorado dataset, listing all currently licenses Marijuana businesses including retailers, transporters, cultivators, and more.

BOULDER COUNTY: RESTAURANT INSPECTIONS AND SEPTIC SYSTEMS

Restaurant Inspections are updated daily to the dataset Restaurant Inspections in Boulder County Colorado. This dataset includes the facility name and site address. Septic system data including type, status and location for dwellings within Boulder County, Colorado provided by Boulder County can be found in the Septic Systems in Boulder County Colorado dataset. Additionally, there is information on the duration of permitting process, the engineer and installer,  the lot size and number of bedrooms (for residential sites), and also the depth to bedrock and site soil type. Septic systems are the second most frequently cited source of groundwater contamination in the US. Unapproved, aging, and failing septic systems have a large impact on the quality and safety of the water supply.

ADAMS, ARAPAHOE, DOUGLAS COUNTIES VIA TRI-COUNTY HEALTH: RESTAURANT INSPECTIONS

The Tri-County Health Department provides public health services to Adams, Arapahoe, and Douglas counties, including public inspections of restaurants, grocery stores, and wholesalers. Restaurant Inspections in Tri-County Colorado is updated daily, and provides information like building capacity, business name, type, and location. Additionally, there are over 65 fields detailing whether the location is in compliance with health standards related to facilities (refrigeration, plumbing etc).

NOTE: Restaurant Inspections currently being logged off-system while the agencies transition to the new 2019 Colorado Standard. Data updates will resume following this scheduled maintenance.

COLORADO DEPARTMENT OF REGULATORY AFFAIRS: PROFESSIONAL AND OCCUPATIONAL LICENSES

The data provided by the Colorado Department of Regulatory Agencies, Division of Professions and Occupations, contains information on the professional license holders in the State of Colorado. Professional and Occupational Licenses for Colorado include technical occupations such as Accountancy, Architecture and Electricians, and extends to a wide variety of healthcare professions. See Professional and Occupational License Types for Colorado for a more complete list and an important disclaimer about the frequency of data updates in the Long Description metadata category of the license roster.

DEPARTMENT OF REVENUE LIQUOR LICENSING DIVISION: LIQUOR LICENSES

Colorado liquor licenses are registered with the Department of Revenue Liquor License Division on a daily basis, and are updated to CIM monthly to the Liquor Licenses in Colorado dataset. As newly registered licenses are issued, their record is included in this roster and also in the Recently Approved Liquor Licenses in Colorado as this is a frequently requested subset. When licenses expire, their record is transferred to the Recently Surrendered or Expired Liquor Licenses in Colorado dataset where they are listed for two months before being dropped from all public active liquor license lists. Other datasets associated with this dataset are Sales Rooms in Colorado, which is all permanent fixtures (ie tasting room) where beer, wine, or spirits are sold. Two datasets provide information on events in Colorado Liquor Permits for Special Events in Colorado and Manufacturer Sales Room Permits in Colorado. One dataset is available for finding information on compliance: Liquor Compliance Checks in Colorado. It is important to note that the listed address is not always guaranteed to be the physical location of the business’ main operation for the liquor license, but event locations are expected to be the actual locations of the events.

OFFICE OF ECONOMIC DEVELOPMENT AND INTERNATIONAL TRADE: EVENTS IN COLORADO

Events data all across the state is being made available via an API. Every day new events are being reported to the tourism office in the Office of Economic Development and International Trade by event coordinators throughout the state. Find resources on how to best utilize this data in the GitHub>Kbase>EventsAPI doc.

COLORADO DEPARTMENT OF TRANSPORTATION: TRAFFIC COUNTS AND HIGHWAY QUALITY MULTI-YEAR DATA

There are several road and traffic focused datasets on CIM. The main suites of data are road traffic, highway traffic, and highway quality. There are datasets focused on local road traffic in Colorado, including Road Traffic Counts in Colorado 2015, 2016, and 2017. There are also datasets for highway traffic in Colorado for 2015, 2016, and 2017. And last but not least is the data on highway quality in Colorado for 2014, 2015, 2016, and 2017. Published as snapshots in time, these datasets are intended for ease of use in temporal analyses. The process is simple for creating a shapefile with all roads combined – just follow the tutorial in the GitHub>Kbase>CO-GIS/OIT doc.

COLORADO DEPARTMENT OF TRANSPORTATION: HIGHWAY SIGN POSTS

Sign data sets are created by combining data from the five Department of Transportation regions to create three data sets: Sign Locations, Sign Panels and Sign Posts. These contain information for signs and their representation. They are linked through the sign locations SignLocationGUId column. The Panel data set contains very interesting information, including the color columns, which can be used to determine the Type of Sign (e.g., informational, traffic sign, warning sign). There is a code with a corresponding name. There are also two descriptive columns that have parks/tourism value: signsPanelLegend and signsPanelSpecLegend. They contain text about the area of the sign and the legend of the sign. For example, there are some entries for kayak signs, implying that there is a spot for kayaks to put in at this area/exit. Whereas the information is not standardized or perfect, it is a useful indicator for the data consumer who is up to the challenge.

COLORADO DEPARTMENT OF PUBLIC SAFETY: CRIME STATISTICS BY POLICE DISTRICT

Crime data is collected by local Police Districts (sheriff, police and state agencies) and then reported up to the State Department of Criminal Justice to provide these aggregate statistics for the state. Arrests are incidents in which an individual was actually booked and charged. The annual report represents data on crimes (offenses and arrests) reported by law enforcement agencies through the Colorado Uniform Crime Reporting Program (UCR) and are stored in the Colorado Crime Information Center (CCIC) computer located at the Colorado Bureau of Investigation. During 2015, 245 law enforcement agencies were responsible for reporting crimes and arrests to the Colorado Bureau of Investigation (CBI). This data is now available dating back to 2001.

COLORADO DEPARTMENT OF PUBLIC HEALTH AND ENVIRONMENT: HEALTHCARE FACILITIES

There are five themed data sets pertaining to the location and function of healthcare facilities for the State of Colorado. The primary data set, Health Facilities, includes known regulated health facilities in Colorado, and is developed directly from address information obtained directly from the Health Facilities and Emergency Medical Services Division of CDPHE. Also in this suite are Community Behavioral Health Centers, Drug Treatment Programs and Resources and a wide variety of other socio-demographic data sets relevant to healthcare. For more on Behavioral Statistics and Emergency Management related data, such as Durable Medical Equipment, see the Health and Environment Available Dataset Summary for Go Code Colorado on GitHub.

COLORADO DEPARTMENT OF HUMAN SERVICES: LICENSED CHILD CARE FACILITIES

The Colorado Department of Human Services (CDHS) updates the Licensed Child Care Facilities data set monthly with any changes or additions to non-24 hour licensed child care facilities in the State of Colorado. Fields include CDHS-issued child care license numbers and legal business names of the child care facility programs as they appear in the licensing application as well as the physical location addresses (including coordinates). For each location, the total licensed capacity and the types of services and programs are provided. Also included in this data set is the Colorado Shines quality rating level (if applicable), and whether the location utilizes the Colorado Child Care Assistance Program (CCCAP).

COLORADO DEPARTMENT OF STATE: DURABLE MEDICAL EQUIPMENT SUPPLIERS IN COLORADO

Durable medical equipment (DME) and disposable medical supplies are medically necessary, in general, means that the DME/supply has a medical purpose that is appropriate for the intended use, it is the most cost effective item available, and it provides for a safe environment. Some examples of equipment that are considered DME include: oxygen, wheelchairs, walkers and bathroom/bedroom safety equipment. This dataset Durable Medical Equipment Suppliers in Colorado provides the location of DME suppliers.

COLORADO DEPARTMENT OF TRANSPORTATION: CONSTRUCTION PROJECTS

Colorado Department of Transportation Projects Systems data set is created by combining a tabular export from the project management database and joining it to the related road segments in the Highway and Local Roads shapefiles. The geography represents a subset of Highway Mileposts as beginning and ending points of road segments in Construction Project Endpoints for Funded Roads in Colorado. These road segments in Construction Project Line Segments for Funded Roads in Colorado correspond to line segments extracted and joined for data completeness. There are multiple date fields in this data set because of the process of obtaining funding and funding construction projects through multiple phases and QA checkpoints to completion.

COLORADO DEPARTMENT OF LOCAL AFFAIRS: RACE ESTIMATES

As a new addition to the Population Projections in Colorado dataset suite, Race Estimates in Colorado and Race Forecasts in Colorado also provide year by year information about past estimates and projected forecasts of age and race by county for the state. Race Forecasts also includes data by gender along with forecasts through 2050.

COLORADO DEPARTMENT OF STATE: NOTARIES IN COLORADO

Current Notaries in Colorado operate across the State of Colorado and are commissioned on a 4-year schedule, and serve the public as impartial witnesses in performing official fraud-deterrent acts related to the signing of important documents. Every day new notaries are added and non-renewing notaries removed, and the data is updated to the Colorado Information Marketplace weekly. This dataset contains information on current notaries registered with the Colorado Department of State and can be aggregated by Zip Code for geospatial analysis.

COLORADO DEPARTMENT OF REVENUE:  RESTAURANT, BUILDING MATERIALS AND MOTOR VEHICLE SALES

The Department of Revenue publishes sales reports by quarter and county for each of three categories. Self-reported retail sales tax information is submitted via the Colorado Retail Sales Tax Return (Form DR 0100). The published reports are derived from returns that reflect taxes for sales made during a filing period (month, quarter or annual). Taxes for the filing period are collected the month following the close of the reporting period. For example, taxes incurred in January are collected in February. County level reports are available in aggregate at the monthly level and city level reports are available quarterly. Restaurant Sales in Colorado has monthly data for 11 counties and a “Rest of State” field. Building Material Sales in Colorado has monthly data for 14 counties. Motor Vehicle  Sales in Colorado has monthly data for 14 counties. All three government data sets have data back through 2008 and are current up to 2016.

NOTE: This data has not been published due to a technical issue since 2016, you can see more information on the Department of Revenue website.

COLORADO SECRETARY OF STATE: LOBBYISTS

The lobbyist database maintained by the Colorado Secretary of State has produced six data sets with information about lobbyists in Colorado. Four data sets provide directory information: Directory of Lobbyists in Colorado, Subcontractors for Lobbyists in Colorado, Directory of Lobbyist Clients in Colorado, Characterization of Lobbyist Clients in Colorado. Information is also available about Expenses for Lobbyists in Colorado, and the primary data set Bill Information and Position with Income of Lobbyist in Colorado has information for each lobbyist and their associated client with the reported bills and positions associated with the client and the total gross income the client paid to the lobbyist for the report month for the State of Colorado. It is important to note that the key field is annualLobbyistRegistrationId, showing the lobbyist is registered for a given year, and is repeated as many times as there are unique clients to that lobbyist. Frequently, multiple bills are associated with a single monetary transaction for a given month from a client to a lobbyist, and they are listed in the billInformationAndPosition field along with the position of the client. Occasionally multiple months of activity will be reported together in a single month.

COLORADO DEPARTMENT OF LOCAL AFFAIRS HOUSING DIVISION: FORECLOSURES

The Department of Local Affairs Housing Division tracks both the number of home Foreclosure Filings in Colorado and Foreclosure Sales in Colorado by county for each quarter. As a complement to the existing Rents and Vacancies data, the Housing Division has released Foreclosures in Colorado, a new data set this year with 2015-2016 data. Foreclosure filings provide a good guide to foreclosure activity in a given county, and whereas a property may be withdrawn from the foreclosure process after a filing is made, the filings statistics nevertheless indicate where borrowers are delinquent and in default.

COLORADO DEPARTMENT OF LABOR AND EMPLOYMENT:  OPEN/CLOSED PETROLEUM RELEASE EVENTS IN COLORADO

All the Open Petroleum Release Events that are currently active petroleum releases from regulated storage tank systems are reported to the State of Colorado’s Division of Oil & Public Safety. These petroleum releases (or “events”) are currently being investigated, assessed or remediated, or are obtaining closure. For active and closed events, navigate to the Active and Closed Petroleum Release Events in Colorado data set. The Petroleum Program within the division is responsible for protecting human health and the environment from petroleum releases caused by regulated storage tank systems. This includes oversight of assessment and cleanup of regulated substances from both underground storage tank (UST) and above ground storage tank (AST) systems. This data set is updated monthly from the Colorado Storage Tank Information System (COSTIS) Database, and the locations are generated from point address based geocoding.

COLORADO DEPARTMENT OF TRANSPORTATION: ROADS, ROAD ATTRIBUTES

This is a suite of five data sets that give characterization to the statewide road and highway data sets. This includes surface finishes, curves/grades, speed limits and lane directions, HOV lanes, ADA curb ramps, and a variety of other characteristics. Also included are a variety of geospatial information about roads:  Milepoints, GPS Mileposts, Noxious Weeds, Highways, Local Roads, Major Roads and Routes.

COLORADO DEPARTMENT OF TRANSPORTATION: MULTI-MODAL

Transit data sets include Airports, Railroads, Streams and Lakes, Also included is the Bicycle and Pedestrian Count data set with data for 16 counties in Colorado: Adams, Arapahoe, Boulder, Denver, Douglas, Eagle, El Paso, Garfield, Jefferson, La Plata, Larimer, Mesa, Pueblo, Routt, Summit and Weld.

COLORADO DEPARTMENT OF HIGHER EDUCATION: DEGREES AWARDED

Demographics for all certificate, degree, or formal award approved by CDHE for students since 2001. Demographics include data on age, ethnicity, program name and residency. Also accompanying this data set are the Enrollment and Financial Aid data sets, which both contain gender and ethnicity information, and neither include program name.

COLORADO DEPARTMENT OF LOCAL AFFAIRS: SPECIAL DISTRICTS AND MUNICIPAL BOUNDARIES

A geographic representation of the state’s Municipalities and Annexations, School Districts, Hospital Districts, Fire Districts, Metro Districts, Parks and Recreation Districts, Library Districts, Cemetery Districts, Soil Districts and Water/Sanitation Districts.

COLORADO DEPARTMENT OF LOCAL AFFAIRS: HOUSING RENTS AND VACANCIES

The Colorado Multi-Family Vacancy and Rental Survey shows rent levels by Type of Apartment,  Age of Building and Size of Building; vacancy rates by Type of Apartment, Age of Building, and Size of Building. The survey includes only multi-family rentals, two units and more. The survey reports averages, so there may be significant differences in vacancy and rental rates by market area, size and location of multi-family buildings.

COLORADO DEPARTMENT OF REVENUE: RETAIL SALES AND TAXES

Aggregate numbers for Colorado Retail Sales and Sales Tax Summaries from local municipalities and jurisdictions can be found in Taxes by County and Industry and  Retail Sales by County and Industry. They are summarized at the monthly level and published annually. The monthly data can be added together to produce quarterly and annual summaries for calendar year and fiscal year. The Department of Revenue categorizes businesses using the North American Industry Classification System (NAICS).

DOR also publishes data related to taxes:  County Areas Collecting State Sales Tax in Colorado, which includes sales tax, use tax by county, etc.,  City Tax Rates Without State Collected Tax in Colorado and City Areas Collecting State Sales Tax in Colorado, which include city name, county, city sales tax, etc., and Use Tax Rates for Districts in Colorado, which lists municipalities that have different tax rates including a list by area. All state collected city/county sales taxes or rate changes may become effective only on January 1 or July 1.

U.S. ENERGY INFORMATION ADMINISTRATION: GAS & ELECTRICITY IN COLORADO

This suite contains two filtered and related data sets related to Electricity Revenue including, revenue and pricing for electricity consumption by month in Colorado since 1990 and the revenue and counts broken down by utility company and by sector, since 1999 (annual updates). Full un-filtered data for U.S. Electricity Revenue and U.S. Electricity Revenue Data by Utility is also available for comparison of Colorado to national numbers. The Natural Gas prices for Colorado table includes price date by month broken down by price type (citygate, residential, commercial, industrial and electric power) in dollars per thousand cubic feet. Monthly data currently ranges from 1989 to 2015 with annual updates. The Gasoline prices in Colorado table includes average gas prices for every week since 2000 broken down by grade (all grades, regular, mid-grade and premium) in dollars per gallon including taxes. This data is updated weekly.

COLORADO STATE GIS OFFICE: COMMUNITY ANCHOR INSTITUTIONS AND INFRASTRUCTURE

Schools, libraries, medical and healthcare providers, public safety entities, community colleges, other institutions of higher education, and other community support organizations and entities can be considered community anchor institutions. The locations of such institutions are gathered in the National Telecommunications Information Administration (NTIA) State Broadband Data Development Program (SBDD) in an effort to identify existing and potential broadband availability to the public.  Community anchor institutions can be found on CIM. Find more details in the GitHub>Kbase>CO-GIS/OIT doc.

Also hosted by the Colorado Goernor’s Office for OIT GIS Department is the high-resolution aerial imagery (DRAPP) flown by DRCOG. These photos are used to generate the detailed vector Infrastructure Planimetric Datasets for 1300 square miles of the Denver urbanized metro area from DRCOG. This vector data includes Building Roof Prints, Trails, Parking, Water Bodies, River Polygons, River Lines, Sidewalk Ramps,  Polygon Sidewalks, Centerline Sidewalks, Edge of Pavement Polygons, Edge of Pavement Lines and Driveways, and presents an ideal standard for urban data collection that should be employed across municipalities state-wide. DRCOG has also recently released the very first normalized Regional Zoning Dataset for the Denver Metro region containing 17 categories based on FAR (floor area ratio)… go ahead, pinch yourself – it’s real! Be sure to also check out the Regional Bicycle Facility Inventory and historical crash data (DRCOG update coming soon) from 2004-2015.

NATIONAL RENEWABLE ENERGY LABORATORY: ENERGY RESOURCES DATA

The National Renewable Energy Laboratory (NREL) is the only federal laboratory dedicated to the research, development, commercialization and deployment of renewable energy and energy efficiency technologies. They publish a wide variety of data for the nation, and some of the more valuable data has been custom subset to Colorado for ease of use, including Locations of Alternative Fuels Stations and the associated types of fuels available, and Electric Truck Stations. There is also data on the existing potential for various alternative energy sources, such as Wind Potential for Colorado and Wind Turbine Locations, Solar Data, Biomass Potential for Colorado, and Biomethane Potential for Colorado. NREL also produces data for oil and natural gas, including Crude Oil Pipelines, Crude Oil Rail Terminals and Natural Gas Underground Storage for 2014. NREL also has two policy-related datasets: Colorado Energy Profile and Colorado Alternative Energy Laws and Incentives.  Find resources for these two suites of data by navigating to the GitHub>Kbase>Solar resources and GitHub>Kbase>buildings and Infrastructure.