Documentation: ACS 2007 (3-Year Estimates)
you are here: choose a survey survey document chapter
Publisher: U.S. Census Bureau
Document: ACS 2007-3yr Summary File: Technical Documentation
citation:
Social Explorer; U.S. Census Bureau; 2005-2007 American Community Survey 3-Year Summary File: Technical Documentation.
ACS 2007-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 2007 Summary File contains 14 digits, because since SAS was used to generate the 2007 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)144 (PR)
2 (US)145 (PR)
23 (US)146 (PR)
24 (US)147 (PR)
28 (US)148 (PR)
29 (US)149 (PR)
30 (US)150 (PR)
31 (US)151 (PR)
32 (US)152 (PR)
142 (US)153 (PR


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 2007 base tables that were subject to geographic restrictions are located on:

http://www.census.gov/acs/www/Products/users_guide/ACS2007_Data_Product_Geographic_Restriction.xls


©2024 Social Explorer. All rights reserved.