2010 US Census Data Sources
These data sources contain a subset of 2010 US Census data sourced from the US Census Bureau. The United States collects census data once every ten years. The last US Census was in 2010 and the next one is scheduled for 2020. These data sources provide Census data based on 4 types of geographical boundaries; states, counties, ZTCA5 (Zip Code Tabulation Area), and the 111th Congressional Districts.
Query URLs
The following are the Query URL’s that can be used to access the US Census data separated by each of the 4 types of geographical boundary types.
State Census Data Query URL
https://spatial.virtualearth.net/REST/v1/data/755aa60032b24cb1bfb54e8a6d59c229/USCensus2010\_States/States
County Census Data Query URL
https://spatial.virtualearth.net/REST/v1/data/6c39d83e5812459f914832970618048e/USCensus2010\_Counties/Counties
111th Congressional District Query URL
https://spatial.virtualearth.net/REST/v1/data/04566e63b0d74e45aa5fa19a2f8bb8bc/USCensus2010\_CD/CongressionalDistrict111th
ZCTA5 Census Data Query URL
https://spatial.virtualearth.net/REST/v1/data/f42cab32d0ee41738d90856badd638d3/USCensus2010\_ZCTA5/ZCTA5
Entity Properties
The following table describes the properties that are available in the 4 different US Census geographical boundary data sources.
| Property | Data type | State | County | 111th Congressional District | ZTCA5 | Description |
|---|---|---|---|---|---|---|
| Area_Land | Edm.Int64 | x | x | x | Area of land within this area | |
| Area_Water | Edm.Int64 | x | x | x | Area of water in this area | |
| Boundary | Edm.Geography | x | x | x | x | The polygon boundary of this area |
| cdsessn | Edm.String | x | Congressional District Session | |||
| countyns | Edm.String | x | County National Standard Code | |||
| EntityID | Edm.String | x | x | x | A unique idenifier for the boundary | |
| GeoID | Edm.String | x | Geographic Identifier | |||
| HousingUnits | Edm.Int64 | x | Number of housing units within this boundary | |||
| Latitude | Edm.Double | x | x | x | x | Latitude coordinate for the center of the boundary |
| Longitude | Edm.Double | x | x | x | x | Longitude coordinate for the center of the boundary |
| Name | Edm.String | x | x | x | x | The name of the boundary |
| Pop_10_to_14_years | Edm.Int64 | x | x | x | x | Population between 10 and 14 years of age |
| Pop_15_to_19_years | Edm.Int64 | x | x | x | x | Population between 15 and 19 years of age |
| Pop_20_to_24_years | Edm.Int64 | x | x | x | x | Population between 20 and 24 years of age |
| Pop_25_to_29_years | Edm.Int64 | x | x | x | x | Population between 25 and 29 years of age |
| Pop_30_to_34_years | Edm.Int64 | x | x | x | x | Population between 30 and 34 years of age |
| Pop_35_to_39_years | Edm.Int64 | x | x | x | x | Population between 35 and 39 years of age |
| Pop_40_to_44_years | Edm.Int64 | x | x | x | x | Population between 40 and 44 years of age |
| Pop_45_to_49_years | Edm.Int64 | x | x | x | x | Population between 45 and 49 years of age |
| Pop_5_to_9_years | Edm.Int64 | x | x | x | x | Population between 5 and 9 years of age |
| Pop_50_to_54_years | Edm.Int64 | x | x | x | x | Population between 50 and 54 years of age |
| Pop_55_to_59_years | Edm.Int64 | x | x | x | x | Population between 55 and 59 years of age |
| Pop_60_to_64_years | Edm.Int64 | x | x | x | x | Population between 60 and 64 years of age |
| Pop_65_to_69_years | Edm.Int64 | x | x | x | x | Population between 65 and 69 years of age |
| Pop_70_to_74_years | Edm.Int64 | x | x | x | x | Population between 70 and 74 years of age |
| Pop_75_to_79_years | Edm.Int64 | x | x | x | x | Population between 75 and 79 years of age |
| Pop_80_to_84_years | Edm.Int64 | x | x | x | x | Population between 80 and 84 years of age |
| Pop_85_years_and_over | Edm.Int64 | x | x | x | x | Population 85 years of age and over |
| Pop_Female_Over16 | Edm.Int64 | x | x | x | x | Population of females over the age of 16 |
| Pop_Female_Over21 | Edm.Int64 | x | x | x | x | Population of females over the age of 21 |
| Pop_Female_Over65 | Edm.Int64 | x | x | x | x | Population of females over the age of 65 |
| Pop_Male_Over16 | Edm.Int64 | x | x | x | x | Population of males over the age of 16 |
| Pop_Male_Over21 | Edm.Int64 | x | x | x | x | Population of males over the age of 21 |
| Pop_Male_Over65 | Edm.Int64 | x | x | x | x | Population of males over the age of 65 |
| Pop_Over16 | Edm.Int64 | x | x | x | x | Population over the age of 16 |
| Pop_Over21 | Edm.Int64 | x | x | x | x | Population over the age of 21 |
| Pop_Over65 | Edm.Int64 | x | x | x | x | Population over the age of 65 |
| Pop_Under_5_years | Edm.Int64 | x | x | x | x | Population below the age of 5 years old |
| Population | Edm.Int64 | x | x | x | x | Total population |
| StateCode | Edm.String | x | x | x | 2 letter state code | |
| statefp | Edm.String | x | 2-character state FIPS code | |||
| StateName | Edm.String | x | x | The name of the US state in which this boundary resides |