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.
From the ACS
website: these are the “journey to work” tables: http://www.census.gov/acs/www/acs-php/experienced_users_guide.php?acs_topic=Journey+to+Work
These are the
“place of work” tables:
http://www.census.gov/acs/www/acs-php/experienced_users_guide.php?acs_topic=Place+of+Work
There are the
“vehicles available” tables:
http://www.census.gov/acs/www/acs-php/experienced_users_guide.php?acs_topic=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)