Current Data Sets for Go Code Colorado

Over 200 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. The descriptions on this page showcase these ~200 datasets and maps.

The Go Code Colorado data team publishes public data sets that are relevant to the Go Code Colorado challenge statement. As each dataset is released this page will feature a fly-over perspective about how the data can help teams turn public data into useful business insights and tools. Competitors have the benefit of newly published data, in addition to all of the data that has been published by the Go Code data team in the past. Stay tuned to this page for updates, new data can be added up until Challenge Weekend begins.

For more details on how to compete, visit the Compete and Rules sections to learn more about the competition.


public Data sets Published 2018

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.

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).

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 LOCAL AFFAIRS DEMOGRAPHY DIVISION: CENSUS CONGRESSIONAL DISTRICTS

In addition to the 5 geography types of Census updated this year, the DOLA Demography Office has made available Congressional Districts. The congressional districts are redrawn every ten years with the decennial census. The demographic profile contained within those geographies, however, changes year over year. The fields selected for these datasets match the fields selected for all other published Census geographies and years. Additional resources available GitHub>kbase>Census.

OFFICE OF ECONOMIC DEVELOPMENT AND INTERNATIONAL TRADE: EVENTS

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 documented by the Go Code data team on the GitHub-kbase-public-2018 repo.

COLORADO DEPARTMENT OF LOCAL AFFAIRS DEMOGRAPHY DIVISION: CENSUS

This year the DOLA Census division has published 5 geospatial data sets for 2012-2016. For those who have tried and struggled working with the Census directly know why it is so valuable that Go Code Colorado and the Demography Division work together to make census data updates easily available and consistent each year. This allows comparing previous years and see not only Colorado’s current demographic makeup at different geographic regions, but also to see the changes that have taken place.  Additional resources available GitHub>kbase>Census.

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 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.

boulder COLORADO: Septic Systems in Boulder County Colorado

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.


public Data sets Published 2017

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 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 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 December 2015. 

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. For more information about GitHub, see the Resources page in the Compete section of this 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 transportation: traffic counts and highway quality

There is updated information for data sets that are gathered annually. First, Highway Traffic Counts for 2015, is a geospatial data set that has information on vehicle traffic numbers along certain stretches of highway. There is also a 2014 version, published previously. Second, Highway Quality for 2016, is a tabular data set that has information on quality of sections of Colorado highways. There are two previous versions of this dataset: 2014 and 2015.

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 LOCAL AFFAIRS DEMOGRAPHY DIVISION: CENSUS

This year the DOLA Census division has published 10 geospatial data sets, five for 2009-2013 and five for 2011-2015. For those who have tried and struggled, you know why it is so valuable that Go Code Colorado and the Demography Division work together to make census data updates easily available each year. Quite simply, it can be very difficult to get data from the American Community Service website that is specific to the region you are looking for and the fields you want. Additional resources available GitHub>kbase>Census.

 

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 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.


public Data sets Published 2014-2016

COLORADO SECRETARY OF STATE: BUSINESS ENTITIES

This refers to 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 data sets related to Charities and three related to Uniform Commercial Code Filings.

COLORADO DEParTment OF LOCAL AFFAIRS: CENSUS

The census is made available by the Federal government, but the advantage of using the data sets 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), and a nation-wide census API for all ACS data sets and the 1980-2010 census. Download data by geographic area (this download set is for Census 2010): State, County, Zip Code, Tract, Block Group, Block. Census data contains more than just population, age, race and gender. Additional resources available GitHub>kbase>Census

There are approximately 150 fields in the ACS data set. Here are some selected topics:

  • Median Household Income, Median Family Income, Per Capita Income, Persons by Poverty Status in Previous Year.
  • Total Households, Total Families, Households by Household Type by Household Size, Persons in Group Quarters by Detailed Group Quarters Type, 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.

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. 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.

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, in addition to proposed construction plans for state roads projected out four years:  Milepoints, GPS Mileposts, Noxious Weeds, HighwaysLocal Roads, Major Roads and Routes. NEW in 2016 Highway Traffic Counts in Colorado and Road Traffic Counts in Colorado.  Each row in these tables represents a stretch of highway or road with traffic counts for a specific time frame. Data have been collected at a variety of locations dating back to 1999 and are factored in to produce the annual average.

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 DistrictsCemetery 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, Market Area, Age of Building and Size of Building; vacancy rates by Type of Apartment, Market Area, 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 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.

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. These data sets are generated from self-reported retail sales tax information obtained from the Colorado Retail Sales Tax Return (Form DR 0100). 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). Three similar data sets extracted from Form DR1002 are  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. Form DR 1002 lists Colorado Sales/Use Tax rates throughout the state. 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

Locations of schools, libraries, medical and healthcare providers, public safety entities, community colleges and other institutions of higher education, and other community support organizations and entities. These locations 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. Accessing community anchor institutions may involve the use of the external tools provided in this README_ArcGIS-Tips file. Also in this suite are the detailed Infrastructure Planimetric Datasets for 1300 square miles of the Denver urbanized metro area from DRCOG. This highly valuable data includes Building Roofprints, 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. In addition to trails, check out the Regional Bicycle Facility Inventory and historical crash data from 2004-2012. Wait there’s more! 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 – its real!

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 Potential for Colorado, 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.