Difference between revisions of "List of census templates"
From SmartWiki
| Line 2: | Line 2: | ||
:<font size="3">http://www2.census.gov/acs2012_3yr/summaryfile/ACS2012_3-Year_TableShells.xls</font> | :<font size="3">http://www2.census.gov/acs2012_3yr/summaryfile/ACS2012_3-Year_TableShells.xls</font> | ||
| − | In order to use the variables from the Excel file above, take the "Unique ID" from column C, add an underscore as the 7th character, and add "E" at the end, so that | + | <pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">In order to use the variables from the Excel file above, take the "Unique ID" from column C, add an underscore as the 7th character, and add "E" at the end, so that |
| − | + | B01001004 (Sex by Age - 5 to 9 years) becomes B01001_004E</pre> | |
| − | |||
A csv-formatted version is also downloadable from SmartSimple here, that contains the correctly-formatted variable in the left-most column: | A csv-formatted version is also downloadable from SmartSimple here, that contains the correctly-formatted variable in the left-most column: | ||
Revision as of 15:54, 11 July 2014
A list of all templates usable with SmartSimple's Census Integration variables is available for download from the U.S. Census Bureau's website here:
In order to use the variables from the Excel file above, take the "Unique ID" from column C, add an underscore as the 7th character, and add "E" at the end, so that B01001004 (Sex by Age - 5 to 9 years) becomes B01001_004E
A csv-formatted version is also downloadable from SmartSimple here, that contains the correctly-formatted variable in the left-most column:
A variety of datasets are available from the Census Bureau's templates. Using the templates, you can return census data broken out by the following categories:
- Demographic Characteristics
- Sex
- Age
- Race
- Hispanic Origin
- Social Characteristics
- Education
- Marital Status
- Fertility
- Grandparent Caregivers
- Veterans
- Disability Status
- Health Insurance
- Place of Birth
- Citizenship
- Year of Entry
- Language Spoken at Home
- Ancestry / Tribal Affiliation
- Economic Characteristics
- Income
- Benefits
- Employment Status
- Occupation
- Industry
- Commuting to Work
- Place of Work
- Housing Characteristics
- Housing Tenure
- Occupancy & Structure
- Housing Value
- Taxes & Insurance
- Utilities
- Mortgage/Monthly Rent
See Census Integration for details on configuration.
