Current Data Sets

Go Code Colorado recognizes that the government collects mountains of data in the course of regular operations. That data has tremendous potential beyond that primary purpose, and the private sector is much better positioned to define that value and use the data accordingly. The Go Code Colorado competition is a way to ask developers, data experts, and tech entrepreneurs the value you see in the data we collect and to do something awesome with it. We are intentional about publishing government data sets that are relevant to the current year’s Challenge Statement, but we are also continuing to publish great data sets that we find along the journey to increasing our familiarity with the data that is published.

When the 2018 Challenge Statement is released, we will then take the first step, offering a fly-over perspective about how the data we’ve published might be relevant to finding solutions to this year’s Challenge Statement.

But it will be you, through this competition, that will tell us what we have and the value in it. This is meant to be a resource to you, do not allow it to limit your creativity. Stay tuned to this page for updates!


New government Data sets Published 2017

 

COLORADO DEPARTMENT OF TRANSPORTATION: CONSTRUCTION PROJECTS

Colorado Department of Transportation Projects Systems data set is created from 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 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 from 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 (i.e., informational, traffic sign, warning sign, etc). There is a code with a corresponding name. Second, there are 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. While the information is not standardized and is not 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 the 3 categories. Self-reported retail sales tax information are submitted via the Colorado Retail Sales Tax Return (Form DR 0100).  The published reports are derived from returns which 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 while 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, and Motor Vehicle  Sales in Colorado has monthly data for 14 counties. All three government data sets have data back to 2008, and are current up to Dec 2015. The data goes back through 2008.

COLORADO DEPT 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 known regulated health facilities in Colorado, 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, like Durable Medical Equipment, see the Health and Environment Available Dataset Summary for Go Code Colorado on GitHub.

COLORADO SECRETARY OF STATE: lobbyists

The Lobbyist database at the secretary of state has produced six data sets with information about Lobbyists in Colorado. Three data sets that provide directory information are 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.  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 lobbyist for the report month for the State of Colorado. 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 is Highway Traffic Counts for 2015, a geospatial data set that has information on vehicle traffic numbers along certain stretches of the highway. There is also a 2014 version, published previously. Second is Highway Quality for 2016, a tabular data set that has information on quality of sections of Colorado highways. There are 2 previous versions of this dataset, 2014 and 2015.

COLORADO DEPT OF LOCAL AFFAIRS HOUSING DIVISION: FORECLOSURES

The Department of Local Affairs Housing Division tracks both the number of home foreclosure Foreclosure Filings in Colorado and Foreclosure Sales in Colorado by county for each quarter. As a compliment 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 while 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 DEPT OF LOCAL AFFAIRS DEMOGRAPHY DIVISION: CENSUS

This year the DOLA Census division has published 10 geospatial data sets, 5 for 2009-2013 and 5 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 ACS/Census 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 the local Police Districts (sheriffs, 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 where 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 the 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 capacities and the types of service the programs are provided. Also included in this data set is the Colorado Shines quality rating levels (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

 

Data in combination is one of the easiest ways to create new value from publicly available government data sets.

This year’s competitors will have the benefit of newly published data, in addition to all of  the data that has been published by the Go Code team in the past three years.

COLORADO SECRETARY OF STATE: BUSINESS ENTITIES

This refers to a suite of data sets, of which the primary data sets is titled Business Entities and is the 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 roster of Corporate Transactions, Trademarks and Tradenames – all dating back to the 1800s. Additionally there are 8 data sets related to Charities, and three related to Uniform Commercial Code Filings.

COLORADO DEPT OF LOCAL AFFAIRS: CENSUS

The Census is made available by the Federal Govt, 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 group also publishes their 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 of fields in the American Community Survey 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 DEPT 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 6 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 DEPT 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 a proposed construction plans for state roads projected out 4 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 has been collected at a variety of locations dating back to 1999 and are factored in to produce the annual average.

COLORADO DEPT OF TRANSPORTATION: MULTI-MODAL

Transit data sets include Airports, Railroads, Streams, 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, Weld.

COLORADO DEPT 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 DEPT 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 Rec Districts, Library DistrictsCemetery Districts, Soil Districts and Water/Sanitation Districts.

COLORADO DEPT 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 up. The survey reports averages so there may be significant differences in vacancy and rental rates by market area, size of multi-family buildings, and location of multi-family buildings.

COLORADO DEPT 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 includes technical occupations like 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 DEPT 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 and 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.

US ENERGY INFORMATION ADMINISTRATION: GAS & ELECTRICITY IN COLORADO

This suite contains two filtered 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 US Electricity Revenue and US 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, midgrade 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 is the detailed Infrastructure Planimetric Datasets for 1300 sqmi 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, 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 LAB: ENERGY RESOURCES DATA

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 in addition to Electric Truck Stations. There is also data on the existing potential for various alternative energy sources like Wind Potential for Colorado as well as 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, Finally the two policy related datasets are the Colorado Energy Profile and the Colorado Alternative Energy Laws and Incentives.