Please note that ACS 1-Year Data may return the following in place of data:
ACS 1-Year Data contain variables ending in E, EA, M, MA, PE, PM and SS. See the table below for each variable type and its meaning:
Variable Type | Title | Related Products | Meaning |
---|---|---|---|
E | Estimate | Summary Files, Subject Tables, Data Profiles, Comparison Profiles | A numeric representation of the estimate. |
EA | Estimate Annotation | Subject Tables, Comparison Profiles | A character representation of the estimate. If an Estimate Annotation exists, use this value in place of the Estimate. (See Example #1 below) |
M | Margin of Error | Summary Files, Subject Tables, Data Profiles | A numeric representation of the margin of error. |
MA | Margin of Error Annotation | Subject Tables Only | A character representation of the margin of error. If a Margin of Error Annotation exists, use this value in place of the Margin of Error. |
PE | Percent Estimate | Data Profiles Only | An estimate representing a percent of the total. |
PM | Percent Margin of Error | Data Profiles Only | The Margin of Error for the corresponding Percent Estimate (PE) variable |
SS | Statistical Significance | Comparison Profiles Only | Returns ‘*’ or ‘c’ representing the Statistical Significance for the corresponding estimate (E) variable. (See Example #2 below) An * indicates that the estimate is significantly different (at a 90% confidence level) than the estimate from the most current year. A "c" indicates the estimates for that year and the current year are both controlled; a statistical test is not appropriate. |
Figure 1: Visual Representation of S0101_C02_031E/A from American Factfinder
In the following example, the variable S0101_C02_031EA returns “(X)”. Using the notes above, this indicates that the estimate is not applicable or not available. Since S0101_C02_031E represents the Sex Ratio (males per 100 females) and the column is for Males only this estimate is not applicable. S0101_C02_031E returns -888888888 as a caution not to use this estimate in reporting or further calculations. See Figure 1 above for a visual context for this estimate.
Returns:
[["NAME","S0101_C02_031E","S0101_C02_031EA","S0101_C02_031M","S0101_C02_031MA","us"],
["United States","-888888888","(X)","-888888888","(X)","1"]]
Figure 2: Visual Representation of CP02_2015to2014_001SS from American Factfinder
In the following example, the variable CP02_2015to2014_001SS returns “*”. Using the notes above, this indicates that the 2015 estimate for Total households is significantly different when compared to the 2014 estimate.
Returns:
[["NAME","CP02_2015_001E","CP02_2014_001E","CP02_2015to2014_001SS","us"],
["United States","118208250","117259427","*","1"]]
See the table below for a list of common Estimate/Margin of Error (E/M) values and their corresponding Annotation (EA/MA) values. See section above titled “Notes on ACS 1 Year Data” for Annotation Values and its meanings.
Estimate Value | Annotation Value |
---|---|
-999999999 | N |
-888888888 | (X) |
-777777777 | (Z) |
-666666666 | - |
-555555555 | ***** |
-333333333 | *** |
-222222222 | ** |