Difference between revisions of "List of census templates"
From SmartWiki
(updating categories) |
|||
| (7 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
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: | 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: | ||
| − | :<font size="3"> | + | :<font size="3">http://www2.census.gov/acs2012_3yr/summaryfile/ACS2012_3-Year_TableShells.xls</font> |
| − | A csv-formatted version is also downloadable from SmartSimple here: | + | |
| + | <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 | ||
| + | To return a margin of error for the dataset, replace the "E" at the end of the template with an "M"</pre> | ||
| + | |||
| + | A csv-formatted version is also downloadable from SmartSimple here, that contains the correctly-formatted variable in the left-most column: | ||
:<font size="3">[https://smart.smartsimple.com/files/113/f140356/censusvar.csv Download here (7 MB file)]</font> | :<font size="3">[https://smart.smartsimple.com/files/113/f140356/censusvar.csv Download here (7 MB file)]</font> | ||
| − | + | ==Troubleshooting== | |
| − | + | Please note that the data profiles may return the following in place of data: | |
| − | ** | + | * An '**' entry in the margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate. |
| − | * | + | * An '-' entry in the estimate column indicates that either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution. |
| − | * | + | * An '-' following a median estimate means the median falls in the lowest interval of an open-ended distribution. |
| − | *''' | + | * An '+' following a median estimate means the median falls in the upper interval of an open-ended distribution. |
| − | ** | + | * An '***' entry in the margin of error column indicates that the median falls in the lowest interval or upper interval of an open-ended distribution. A statistical test is not appropriate. |
| − | ** | + | * An '*****' entry in the margin of error column indicates that the estimate is controlled. A statistical test for sampling variability is not appropriate. |
| − | ** | + | * An 'N' entry in the estimate and margin of error columns indicates that data for this geographic area cannot be displayed because the number of sample cases is too small. |
| − | ** | + | * An '(X)' means that the estimate is not applicable or not available. |
| − | ** | + | ''(from http://www.census.gov/developers/data/?eml=gd&utm_medium=email&utm_source=govdelivery)'' |
| − | * | + | |
| − | + | ||
| − | + | See [[Census Integration]] for details on configuration. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | *''' | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
[[Category:Integration]] | [[Category:Integration]] | ||
| + | [[Category:External Data Source]] | ||
Latest revision as of 13:39, 20 July 2017
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 To return a margin of error for the dataset, replace the "E" at the end of the template with an "M"
A csv-formatted version is also downloadable from SmartSimple here, that contains the correctly-formatted variable in the left-most column:
Troubleshooting
Please note that the data profiles may return the following in place of data:
- An '**' entry in the margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate.
- An '-' entry in the estimate column indicates that either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution.
- An '-' following a median estimate means the median falls in the lowest interval of an open-ended distribution.
- An '+' following a median estimate means the median falls in the upper interval of an open-ended distribution.
- An '***' entry in the margin of error column indicates that the median falls in the lowest interval or upper interval of an open-ended distribution. A statistical test is not appropriate.
- An '*****' entry in the margin of error column indicates that the estimate is controlled. A statistical test for sampling variability is not appropriate.
- An 'N' entry in the estimate and margin of error columns indicates that data for this geographic area cannot be displayed because the number of sample cases is too small.
- An '(X)' means that the estimate is not applicable or not available.
(from http://www.census.gov/developers/data/?eml=gd&utm_medium=email&utm_source=govdelivery)
See Census Integration for details on configuration.
