Documentation: ACS 2008 (3-Year Estimates)
you are here: choose a survey survey document chapter
Publisher: U.S. Census Bureau
Document: ACS 2008-3yr Summary File: Technical Documentation
citation:
Social Explorer; U.S. Census Bureau; American Community Survey 2006-2008 Summary File: Technical Documentation.
ACS 2008-3yr Summary File: Technical Documentation
Appendix J: User Notes
1) Jam Values

Some data values represent unique situations where either: a) the information to be conveyed is an explanation for the absence of data, represented by a symbol in the data display, such as "(X)", or b) the information to be conveyed is an open-ended distribution, such as 115 or greater, represented by 115+.

Following are the special data values (and their meaning) for case (b), which can appear in any 2008 ACS Detailed Tables containing an open-ended distribution:

Table IDLow ValueJam Value DefinitionHigh ValueJam Value Definition
B0100201-116115+
B01002A01-116115+
B01002B01-116115+
B01002C01-116115+
B01002D01-116115+
B01002E01-116115+
B01002F01-116115+
B01002G01-116115+
B01002H01-116115+
B01002I01-116115+
B0500401-116115+
B0600201-116115+
B06002PR01-116115+
B0601124992,500-100001100,000+
B06011PR24992,500-100001100,000+
B0700201-116115+
B07002PR01-116115+
B0701124992,500-100001100,000+
B07011PR24992,500-100001100,000+
B0740201-116115+
B07402PR01-116115+
B0741124992,500-100001100,000+
B07411PR24992,500-100001100,000+
B0810301-116115+
B0812124992,500-100001100,000+
B0850301-116115+
B0852124992,500-100001100,000+
B1001024992,500-200001200,000+
B1901324992,500-200001200,000+
B19013A24992,500-200001200,000+
B19013B24992,500-200001200,000+
B19013C24992,500-200001200,000+
B19013D24992,500-200001200,000+
B19013E24992,500-200001200,000+
B19013F24992,500-200001200,000+
B19013G24992,500-200001200,000+
B19013H24992,500-200001200,000+
B19013I24992,500-200001200,000+
B1901924992,500-200001200,000+
B1904924992,500-200001200,000+
B1908024992,500-200000200,000+
B1911324992,500-200001200,000+
B19113A24992,500-200001200,000+
B19113B24992,500-200001200,000+
B19113C24992,500-200001200,000+
B19113D24992,500-200001200,000+
B19113E24992,500-200001200,000+
B19113F24992,500-200001200,000+
B19113G24992,500-200001200,000+
B19113H24992,500-200001200,000+
B19113I24992,500-200001200,000+
B1911924992,500-200001200,000+
B1912124992,500-200001200,000+
B1912524992,500-200001200,000+
B1912624992,500-200001200,000+
B1920224992,500-200001200,000+
B19202A24992,500-200001200,000+
B19202B24992,500-200001200,000+
B19202C24992,500-200001200,000+
B19202D24992,500-200001200,000+
B19202E24992,500-200001200,000+
B19202F24992,500-200001200,000+
B19202G24992,500-200001200,000+
B19202H24992,500-200001200,000+
B19202I24992,500-200001200,000+
B1921524992,500-200001200,000+
B1932624992,500-100001100,000+
B2000224992,500-100001100,000+
B2000424992,500-100001100,000+
B2001724992,500-100001100,000+
B20017A24992,500-100001100,000+
B20017B24992,500-100001100,000+
B20017C24992,500-100001100,000+
B20017D24992,500-100001100,000+
B20017E24992,500-100001100,000+
B20017F24992,500-100001100,000+
B20017G24992,500-100001100,000+
B20017H24992,500-100001100,000+
B20017I24992,500-100001100,000+
B2100424992,500-100001100,000+
B2200824992,500-200001200,000+
B2301301-116115+
B2401124992,500-100001100,000+
B2401224992,500-100001100,000+
B2402124992,500-100001100,000+
B2402224992,500-100001100,000+
B2403124992,500-100001100,000+
B2403224992,500-100001100,000+
B2404124992,500-100001100,000+
B2404224992,500-100001100,000+
B2408124992,500-100001100,000+
B2408224992,500-100001100,000+
B2409124992,500-100001100,000+
B2409224992,500-100001100,000+
B2412124992,500-100001100,000+
B2412224992,500-100001100,000+
B2412324992,500-100001100,000+
B2501814.114.0+  
B2502114.114.0+  
B2503519391939-20052005
B2503719391939-20052005
B2503919691969-20052005
B2505799100-30013,000+
B2505899100-30013,000+
B2505999100-30013,000+
B2506499100-30013,000+
B250719.910.0-90.190.0+
B2507699910,000-10000011,000,000+
B2507799910,000-10000011,000,000+
B2507899910,000-10000011,000,000+
B2508399910,000-10000011,000,000+
B2508899100-60016,000+
B2508820012,000+  
B250929.910.0-50.150.0+
B2509799910,000-10000011,000,000+
B2509924992,500-200001200,000+
B25103199200-1000110,000+
B2510599100-60016,000+
B2510799910,000-10000011,000,000+
B2510999910,000-10000011,000,000+
B2511199100-30013,000+
B2511399100-30013,000+
B2511924992,500-200001200,000+


The following are the special data values (and their meaning), which can appear in the 2008 ACS Summary File table as an explanation for the absence of data:

Missing Value = ".": A dot ".", indicates that the estimate is unavailable. All ACS tables contain these values when estimates are missing due to certain special conditions.

Filtered Value or Geographic Restriction =" ": A blank indicates that a value is filtered or is not shown due to a geographic restriction.

Margin of Error (MOE) or Standard Error (SE) = 0: Estimate is controlled, which indicates the estimates are controlled and a statistical test is not appropriate.

2) Rounding Rules, Margin of Errors (MOE), and Standard Errors (SE)

A. B00001, B00002, B98001, and B98002 are sample counts, not estimates, and do not have MOEs and SEs associated with them. Tables in series B99* imputation tables and B98* quality measure tables (except B98001 and B98002) do not have MOEs calculated for them. The MOE and SE are set to -1 for these tables.

B. There are a few special rules on how certain margin of error and standard error are determined for ACS estimates. The accuracy of the estimate (decimal place) in the base tables to determine how many digits the standard error should be rounded. The only exceptions to these rules are tables

B19082: SHARES OF AGGREGATE HOUSEHOLD INCOME BY QUINTILE and B19083: GINI INDEX OF INCOME INEQUALITY. On American FactFinder (AFF), the estimates display to 2 decimal places and the MOE to 3.

3) Display of Estimates
Display of whole numbers in the summary files: The estimates in the summary files are stored using standard notation instead of in scientific notation. The largest estimate in the 2008 Summary File contains 14 digits, because since SAS was used to generate the 2008 Summary File, SAS automatically stores and displays values with more than 12 digits using scientific notation, but these values were stored in the summary files as whole numbers.

Display of decimal values in the summary files: The following median and ratio tables are displayed as decimals. The following list shows these tables, their table types, and accuracy.

Table IDTable TitleTable TypeAccuracy
B01002MEDIAN AGE BY SEXMEDIANTenths
B01002AMEDIAN AGE BY SEX (WHITE ALONE)MEDIANTenths
B01002BMEDIAN AGE BY SEX (BLACK OR AFRICAN AMERICAN ALONE)MEDIANTenths
B01002CMEDIAN AGE BY SEX (AMERICAN INDIAN AND ALASKA NATIVE)MEDIANTenths
B01002DMEDIAN AGE BY SEX (ASIAN ALONE)MEDIANTenths
B01002EMEDIAN AGE BY SEX (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE)MEDIANTenths
B01002FMEDIAN AGE BY SEX (SOME OTHER RACE ALONE)MEDIANTenths
B01002GMEDIAN AGE BY SEX (TWO OR MORE RACES)MEDIANTenths
B01002HMEDIAN AGE BY SEX (WHITE ALONE, NOT HISPANIC OR LATINO)MEDIANTenths
B01002IMEDIAN AGE BY SEX (HISPANIC OR LATINO)MEDIANTenths
B05004MEDIAN AGE BY CITIZENSHIP STATUS BY SEXMEDIANTenths
B06002MEDIAN AGE BY PLACE OF BIRTH IN THE UNITED STATESMEDIANTenths
B06002PRMEDIAN AGE BY PLACE OF BIRTH IN PUERTO RICOMEDIANTenths
B07002MEDIAN AGE BY RESIDENCE 1 YEAR AGO IN THE UNITED STATESMEDIANTenths
B07002PRMEDIAN AGE BY RESIDENCE 1 YEAR AGO IN PUERTO RICOMEDIANTenths
B08103MEDIAN AGE BY MEANS OF TRANSPORTATION TO WORKMEDIANTenths
B08503MEDIAN AGE BY MEANS OF TRANSPORTATION TO WORK FOR WORKPLACE GEOGRAPHYMEDIANTenths
B12008MEDIAN AGE AT FIRST MARRIAGEMEDIANTenths
B12008AMEDIAN AGE AT FIRST MARRIAGE (WHITE ALONE)MEDIANTenths
B12008BMEDIAN AGE AT FIRST MARRIAGE (BLACK OR AFRICAN AMERICAN ALONE)MEDIANTenths
B12008CMEDIAN AGE AT FIRST MARRIAGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE)MEDIANTenths
B12008DMEDIAN AGE AT FIRST MARRIAGE (ASIAN ALONE)MEDIANTenths
B12008EMEDIAN AGE AT FIRST MARRIAGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE)MEDIANTenths
B12008FMEDIAN AGE AT FIRST MARRIAGE (SOME OTHER RACE ALONE)MEDIANTenths
B12008GMEDIAN AGE AT FIRST MARRIAGE (TWO OR MORE RACES)MEDIANTenths
B12008HMEDIAN AGE AT FIRST MARRIAGE (WHITE ALONE, NOT HISPANIC OR LATINO)MEDIANTenths
B12008IMEDIAN AGE AT FIRST MARRIAGE (HISPANIC OR LATINO)MEDIANTenths
B19082SHARES OF AGGREGATE HOUSEHOLD INCOME BY QUINTILEGINITenths
B19083GINI INDEX OF INCOME INEQUALITY GINIThousandths
B23013MEDIAN AGE BY SEX FOR WORKERS 16 TO 64 YEARSMEDIANTenths
B23020MEAN USUAL HOURS WORKED IN THE PAST 12 MONTHS FOR WORKERS 16 TO 64 YEARSRATIOTenths
B23021MEAN WEEKS WORKED IN THE PAST 12 MONTHS FOR WORKERS 16 TO 64 YEARSRATIOTenths
B25010 AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURERATIOHundredths
B25018MEDIAN NUMBER OF ROOMSMEDIANTenths
B25021MEDIAN NUMBER OF ROOMS BY TENUREMEDIANTenths
B25071MEDIAN GROSS RENT AS A PERCENTAGE OF HOUSEHOLD INCOME IN THE PAST 12 MONTHS (DOLLARS)MEDIANTenths
B25092MEDIAN SELECTED MONTHLY OWNER COSTS AS A PERCENTAGE OF HOUSEHOLD INCOME IN THE PAST 12 MONTHSMEDIANTenths


4) Special Table ID Sequence Rules
The data from the American Community Survey contains 75 detailed tables that have different table layouts for the Puerto Rico than their United States counterparts. The United States version of the tables are limited to geographic areas in the US (50 states plus the District of Columbia) while the Puerto Rico versions are limited to areas in Puerto Rico. In the summary file the Puerto Rico version of the tables are in sequence file 149 through 158. Therefore, for all geographic areas within the US sequence files 149 through 158 will be blank. In addition, sequence files 1,2,23,24, 28-32, and 147 will be blank for Puerto Rico as they contain the US version of the tables. The decision to separate the files was made because the comparable tables between the US and Puerto Rico may have a different number of cells (such as C06001 with 45 cells and C06001PR with 37 cells) which would significantly alter the metadata between the US and Puerto Rico. To identify what tables are available for Puerto Rico only look for the "PR" suffix in the table id (e.g. C06001PR).

For more information on PR only sequences that are counterparts to states-only sequences, please reference the following table.

US/State-only SequencesPR Only Sequences
1 (US)149 (PR)
2 (US)150 (PR)
23 (US)151 (PR)
24 (US)152 (PR)
28 (US)153 (PR)
29 (US)154 (PR)
30 (US)155 (PR)
31 (US)156 (PR)
32 (US)157 (PR)
147 (US)158 (PR


Sequences 51 and 146 contain many geo-restricted tables. Sequences 125-133 contain 3 large median tables with 499 cells. Due to the size restriction on the sequences (no more than 245 cells), each of the tables had to be broken into 3 sequences. So for example, sequence 125 contains B24121 cells 1-167, sequence 126 contains B24121 cells 168-333; sequence 127 contains B24121 cells 334-499, etc.

5) ACS User Notes
ACS User Notes are available on:
http://www.census.gov/acs/www/UseData/usernotes.html

6) Detailed Table Geographic Restrictions
ACS 2008 base tables that were subject to geographic restrictions are located on:
http://www.census.gov/acs/www/Products/users_guide/ACS2008_Data_Product_Geographic_Restriction.xls

7) Data Release Filtering Rules
Data release filtering rules. Filtering rules, based on the statistical reliability of the survey estimates, are used because certain geographic areas contain very detailed tables might include estimates whose reliability is unacceptable. The main data release rule for the ACS tables works as follows. Every base table consists of a series of estimates. If more than half the estimates are not statistically different from 0 (at a 90 percent confidence level), then the table fails. Each estimate is subject to sampling variability that can be summarized by its standard error. Dividing the standard error by the estimate yields the coefficient of variation (CV) for each of the estimates. (If the estimate is 0, a CV of 100 percent is assigned.) To implement this requirement for each table at a given geographic area, CVs are calculated for each of the table's estimates, and the median CV value is determined. If the median CV value for the table is less than or equal to 61 percent, the table passes for that geographic area; if it is greater than 61 percent, the table fails. Tables that are too sparse will fail this test. In that case, the table will not be published for that geographic area. Whenever a table fails, a simpler table that collapses some of the detailed lines together can be substituted for the original, more detailed table. The rules are then applied to the simpler table. If it passes, the simpler table is released. If it fails, none of the estimates for that particular table is released for this geographic area. These rules are applied to single-year period estimates and multi-year period estimates based on three years of sample data.

For a complete list of filtered detailed tables, please reference the filter_helper_file.txt located on http://www2.census.gov/acs2008_3yr/summaryfile/

8) 2008 1-Year Detailed Tables that are not available for the 2008 3-Year data release
Selected detailed tables that were published for the 2008 1-Year data release are not available for the 2008 3-Year data release. For a complete list of these tables, please reference the following file:
http://www2.census.gov/acs2008_3yr/summaryfile/
Tables_in_1Year_NOT_in_3year.xls. For more information on changes to the detailed tables please reference the 2008 Data Product Changes page on the ACS Website on:
http://www.census.gov/acs/www/Products/2008/new_notable_dp_changes.html





©2024 Social Explorer. All rights reserved.