The Go Code Colorado data team publishes public data sets that are relevant to the current year’s Go Code Colorado challenge statement as well as great data sets they find along way. When the Go Code Colorado 2018 Challenge Statement is released, we will offer a fly-over perspective about how the data we’ve published 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.
The datasets featured on this page are a resource for competing teams, but don’t allow what’s here to limit your creativity. And, be sure to stay tuned to this page for updates.
If you’re new to the Go Code Competition, be sure to visit the Compete and Rules sections of our website to learn more about the competition. To learn about current Go Code Colorado data sets, please keep on reading.
government 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.
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).
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.
government 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. 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, Highways, Local 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 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, 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.