colorado-gov/census-zip-codes-in-colorado-2020-ucnv-vw74
Icon for Socrata external plugin
  •  
    Overview
  •  
    Tables
  •  
    REST API
  •  
    SQL Query
Open repository in Console
 
Readme
Updated 13 hours ago
‧
Indexed 7 minutes ago

Census Zip Codes in Colorado 2020

American Community Survey Census data includes demographics, education level, commute information, and more subset to Colorado by the Department of Local Affairs (DOLA).

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/census-zip-codes-in-colorado-2020-ucnv-vw74\".\"census_zip_codes_in_colorado_2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • census_zip_codes_in_colorado_2020
     
    Left sidebar is currently unimplemented
     
     
     
     
    Right sidebar is currently unimplemented
Upstream Metadata
GeospatialCollection MethodNot specifiedHorizontal AccuracyCensus data is reliable as within the constraints of funding, staffing and legislation. Sampling and Non-sampling errors include, but are not limited to, missing survey responses, under and over counts, inverviewer error.Coordinate System DisclaimerNOTE: To maintain source projection, select “Export Original” from export menu. To display on the web, export using any other option.Horizontal Coordinate SystemNAD83/GCS_North_American_1983Web Display Coordinate SystemWGS84
Data QualityExpected Update FrequencyStatic
Data UpdatesUpdate TypeStaticUpdate MethodNoneUpdate ScheduleNoneSource Update ScheduleNot specifiedTotal Records At Initial Publish526
Data DescriptionSingle RowCensus zip codes demographicsCollection ModeTIGER line filesLong DescriptionCensus Data is collected every 10 years by mail surveys to every household with primary data collection fields of population, gender, race and number of occupants. Overcounts are known to exist in student and dual-residence populations, while undercounts are a given for homeless and illegal immigrants. Errors arise from both sampling and non-sampling methods. Sampling errors are misrepresentations of a larger population based on the selection of the representative sample. Accuracy of the estimates depend in part on how typical the people within the sampled housing units are to others within their area. The Census estimates sampling error based on the population and its extent of variability. The long-form of the Census is distributed to a subset of households, and includes additional data related to households, economy, employment, occupation, as well as occupancy and building structure data. Household fields include: Total Households, Total Families, Households by Household Type by Household Size, Persons in Group Quarters by Detailed Group Quarters Type, Persons 25 Years and Over by Educational Attainment, Persons 16 Years and Over by Labor Force and Employment Status, Median Household Income, Median Family Income, Per Capita Income, Persons by Poverty Status in Previous Year. Occupancy fields include: 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. Field Descriptions at: https://data.colorado.gov/Demographics/Census-Field-Descriptions/qten-sdpnCollection MethodThe 2000 census marked the last year that the long form was distributed to 1 in 6 households (a 17% sample), and in 2010 the actual sample size for the long form was 2.5% per year (totaling 12.5% over a 5 year cycle). In 2000, one household answered the long form questions on behalf of 5 other households, and in 2010 a single household provides data for between seven other households (5 year averages) and 39 other households (1 year averages for larger places).Newest Record in DatasetNot specifiedOldest Record in DatasetNot specifiedData Collection InstrumentSurveysField Names, comma delimitedhttps://data.colorado.gov/Demographics/Census-Field-Descriptions/qten-sdpn/dataDate of Initial Dataset Creation2020
Dataset CoverageGranularityNot specifiedUnit of AnalysisVector polygonGeographic CoverageState
Contributing Agency InformationCitationDOLA - Department of Local AffairsData SourceNot specifiedAgency Program Pagehttps://www.colorado.gov/dolaAgency Data Series Pagehttps://www.census.gov/data.html
Additional Dataset DocumentationData DictionaryNot specifiedAdditional MetadataNot specifiedTechnical DocumentationNot specified

About

Census Zip Codes in Colorado 2020
13 hours ago (updated)
7 minutes ago (indexed)
Loading...

Topics

  • american community survey
  • bic
  • census
  • colorado
  • geospatial
  • + 4

Sources

  • Colorado Information Marketplace - Census Zip Codes in Colorado 2020
  • DOLA (creator)

License

Public Domain