[CTPP] ACS table numbering and ACS tables to be deleted in 2006 processing

Dear everyone: I thought I would share some materials from Kin Koerber from the Census Bureau, and Phil Salopek (recently retired from the Census Bureau). ACS TABLE NAMING AND NUMBERING The first character in the table is a key to the type of the table. Subject S Several tables compiled together addressing a specific subject. Limited to areas with 1+ million population. Base or Detailed B These tables are used to create the Subject tables, but can be used independently. Collapsed C These tables are a smaller version of the Base tables with a reduced number of categories to reduce suppression. However, some tables may still be suppressed if the coefficient of variation among the cells is too high. Ranking R These tables sort the results based on individual values, for example, average travel time, or percent using transit as means of transportation to work. For 2005, these are given for State totals. Data Profiles --- There are 4 profile sheets: demographics, social, economic, housing, and 1 narrative document. The economic profile includes workers and commuting. Selected Population Profiles --- These are tables by race, ethnicity and ancestry. All the JTW and Place of Work tables begin with "08". As for the detailed (base) tables, there is somewhat of a pattern. Those beginning with B080 or C080 support the Subject Table S0801. Also included in that set are the Place of Work by metro/micro/non-metro or -micro tables (B08016-B08018/C08016-C08018). The latter are included with the others since S0801 uses the other Place of Work tables. However, S0801 does use some JTW tables. The workplace-based tables that parallel those detailed tables start with B084 or C084. The last two digits are the same for corresponding residence-based and workplace-based tables. The detailed tables that are used for the Means of Transportation Subject Table (S0802), are numbered starting with either B081 or C081. The workplace-based tables that parallel those detailed tables start with B085 or C085. The last two digits are the same for corresponding residence-based and workplace-based tables. The household data detailed tables that were requested by DOT and not used in any other products are numbered starting with either B082 or C082. These are: B08201: Household Size by Vehicles Available B08202: Household Size by Number of Workers B08203: Number of Workers by Vehicles Available The new one-dimensional JTW detailed tables will be numbered starting with either B083 or C083. The workplace-based tables that parallel those detailed tables will start with B086 or C086. The last two digits will be the same for corresponding residence-based and workplace-based tables. There will be holes in the numbering where tables are removed. 2005 ACS TABLES REMOVED FROM 2006 ACS TABULATION PLANS The CB's Journey to Work and Migration branch was asked to reduce the number of ACS standard tables for 2006 and beyond. http://www.census.gov/acs/www/acs-php/experienced_users_guide.php?acs_t opic=Journey+to+Work These are the "place of work" tables: http://www.census.gov/acs/www/acs-php/experienced_users_guide.php?acs_t opic=Place+of+Work There are the "vehicles available" tables: http://www.census.gov/acs/www/acs-php/experienced_users_guide.php?acs_t opic=Vehicles+Available' A univariate table of means of transportation to work (18 categories) has been added (see above). Here's the list of what was submitted for deletion. 1) Subject Table S0803. Retain subject tables S0801 (commuting characteristics by sex), S0802 (Means of Transportation (short list) by various characteristics such as age, race, sex, occupation and industry) but delete S0803 (worker characteristics crossed by sex). These subject tables are only produced for areas with 1 million+ population. 2) Mean travel time in S0802. Delete the mean travel time to work column from subject table S0802. To calculate the mean travel time, these "aggregate travel times" are needed, so by eliminating mean travel time from the subject table, 21 base tables/collapsed tables: B08102, B08106A through I (race/Hispanic repeats), B08112, B08114/C08114, B08120, B08123, B08125, B08127, B08129, B08138, B08142/C08142 can be eliminated. Some tables with travel time distributions remain e.g. B08012, B08134. 3) Means of Transportation by Marital Status : Delete the base tables, collapsed tables, and aggregate travel time table of Means of Transportation by Marital Status. These are tables B08115/C08115, B08515/C08515, and B08116/C08116. Also delete Marital Status from subject tables S0802 and S0804. This change deletes all the marital status by means of transportation data. 4) Means of Transportation by Educational Attainment Delete the base tables, collapsed tables, and aggregate travel time table of Means of Transportation by Educational Attainment. This is tables B08117/C08117, B08517/C08517, and B08118. Also delete Educational Attainment from subject tables S0802 and S0804. This removes all the educational attainment by means of transportation data. 5) Means of Transportation by Household Type There are only two categories of household type used in these tables: 1) Married couple family households and 2) Other households. Delete the base tables, collapsed tables, and aggregate travel time table of Means of Transportation by Household Type. These are tables B08139/C08139, B08539/C08539, and B08140. Also delete Household Type from subject tables S0802 and S0804. This removes all the household type by means of transportation data. Don't forget that we created our own profiles using the 2005 ACS results. These are available at: http://ctpp.transportation.org/home/default.htm and include some data from 1990 and 2000. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle)