Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Office of Planning, Environment, & Realty (HEP)
Planning · Environment · Real Estate

HEP Events Guidance Publications Glossary Awards Contacts

CTPP using ACS 2006-2010 (5-YEAR Summary)

Notes on the Data Output Layout

This information was superseded in May 2013.

6/11/2010

Beyond 20/20 would prefer to have a single file for each table. Each file will include all geographies for that table, in order of summary level, component, and GEOID. The files will be .CSV format. File name will be Txxxxxx.csv (where the x's are the AASHTO Table number).

Beyond 20/20 does not need the variable header, title line, or universe line, or total number of cells incorporated into the output. However, per FHWA and AASHTO, they would slightly prefer to keep the title, universe, and total number of cells incorporated in the output, for advanced users who will not use the software. (2/23/10)

The total number of data lines in the table will be placed in the Universe line under the 5th column (column E), the estimate column.

The Margin of Error (MOE) will be just the value. It will NOT have the "+/- " that is added to the standard tables.

The VARIABLE (Column) HEADER for all files is in the following order: GEOID, TableID, Order, Title, Estimate, STDERR, MOE.

GEOID - The ID code of the geography, concatenated if it is a flow geography. See the GEO- ids tab.

TableID - The AASHTO table number. (Will not start with a T or end in x.)

Order - Data line number of the table

Title - The name of the category(ies) represented in the data line.

Estimate - The estimate.

StdErr - The standard error of the estimate.

MOE - The 90% margin of error of the estimate. This is just the MOE without the "+/- " added to standard tables.

Example of a table data file:

GEOIDTableIDOrderTitleEstimateStdErrMOE
   Urban/Rural residence (3)   
   Universe: Total Population3  
C0100US 111031 Total999999999* * * * * * * * * *
C0100US 111032 Living in urban area99999999999999999999
C0100US 111033Living in rural area   
C0101US 111031 Total   
C0101US 111032 Living in urban area   
C0101US 111033Living in rural area   
C0143US 111031 Total   
C0143US 111032 Living in urban area   
C0143US 111033Living in rural area   
C01A0US 111031 Total   
C01A0US 111032 Living in urban area   
C01A0US 111033Living in rural area   
C01C0US 111031 Total   
C01C0US 111032 Living in urban area   
C01C0US 111033Living in rural area   
C01C1US 111031 Total   
C01C1US 111032 Living in urban area   
C01C1US 111033Living in rural area   
C01C2US 111031 Total   
C01C2US 111032 Living in urban area   
C01C2US 111033Living in rural area   
C01E0US 111031 Total   
C01E0US 111032 Living in urban area   
C01E0US 111033Living in rural area   
C01E1US 111031 Total   
C01E1US 111032 Living in urban area   
C01E1US 111033Living in rural area   
C01E2US 111031 Total   
C01E2US 111032 Living in urban area   
C01E2US 111033Living in rural area   
C01G0US 111031 Total   
C01G0US 111032 Living in urban area   
C01G0US 111033Living in rural area   
C01H0US 111031 Total   
C01H0US 111032 Living in urban area   
C01H0US 111033Living in rural area   
C0200US01 111031 Total   
C0200US01 111032 Living in urban area   
C0200US01 111033Living in rural area   
C0200US02 111031 Total   
C0200US02 111032 Living in urban area   
C0200US02 111033Living in rural area   
C0200US04 111031 Total   
C0200US04 111032 Living in urban area   
C0200US04 111033Living in rural area   
C0200US05 111031 Total   
C0200US05 111032 Living in urban area   
C0200US05 111033Living in rural area   
C0200US06 111031 Total   
C0200US06 111032 Living in urban area   
C0200US06 111033Living in rural area   
C0200US08111031 Total   
C0200US08 111032 Living in urban area   
C0200US08 111033Living in rural area   
C0200US09 111031 Total   
C0200US09 111032 Living in urban area   
C0200US09 111033Living in rural area   
C0200US10 111031 Total   
C0200US10 111032 Living in urban area   
C0200US10 111033Living in rural area   
C0200US11 111031 Total   
C0200US11 111032 Living in urban area   
C0200US11 111033Living in rural area   
C0200US12 111031 Total   
C0200US12 111032 Living in urban area   
C0200US12 111033Living in rural area   
C0200US13 111031 Total   
C0200US13 111032 Living in urban area   
C0200US13 111033Living in rural area   
C0200US15 111031 Total   
C0200US15 111032 Living in urban area   
C0200US15 111033Living in rural area   
C0200US16 111031 Total   
C0200US16 111032 Living in urban area   
C0200US16 111033Living in rural area   
C0200US17 111031 Total   
C0200US17 111032 Living in urban area   
C0200US17 111033Living in rural area   
C0200US18 111031 Total   
C0200US18 111032 Living in urban area    
C0200US18 111033Living in rural area    
C0200US19 111031 Total   
C0200US19 111032 Living in urban area   
C0200US19 111033Living in rural area   
C0200US20 111031 Total   
C0200US20 111032 Living in urban area   
C0200US20 111033Living in rural area   
C0200US21 111031 Total   
C0200US21 111032 Living in urban area   
C0200US21 111033Living in rural area   
C0200US22 111031 Total   
C0200US22 111032 Living in urban area   
C0200US22 111033Living in rural area   
C0200US23 111031 Total   
C0200US23 111032 Living in urban area   
C0200US23 111033Living in rural area   
C0200US24 111031 Total   
C0200US24 111032 Living in urban area   
C0200US24 111033Living in rural area   
C0200US25 111031 Total   
C0200US25 111032 Living in urban area   
C0200US25 111033Living in rural area   
C0200US26 111031 Total   
C0200US26 111032 Living in urban area   
C0200US26 111033Living in rural area   
C0200US27 111031 Total   
C0200US27 111032 Living in urban area   
C0200US27 111033Living in rural area   
C0200US28 111031 Total   
C0200US28 111032 Living in urban area   
C0200US28 111033Living in rural area   
C0200US29 111031 Total   
C0200US29 111032 Living in urban area   
C0200US29 111033Living in rural area   
C0200US30 111031 Total   
C0200US30 111032 Living in urban area   
C0200US30 111033Living in rural area   
C0200US31 111031 Total   
C0200US31 111032 Living in urban area   
C0200US31 111033Living in rural area   
C0200US32 111031 Total   
C0200US32 111032 Living in urban area   
C0200US32 111033Living in rural area   
C0200US33 111031 Total   
C0200US33 111032 Living in urban area   
C0200US33 111033Living in rural area   
C0200US34 111031 Total   
C0200US34 111032 Living in urban area   
C0200US34 111033Living in rural area   
C0200US35 111031 Total   
C0200US35 111032 Living in urban area   
C0200US35 111033Living in rural area   
C0200US36 111031 Total   
C0200US36 111032 Living in urban area   
C0200US36 111033Living in rural area   
C0200US37 111031 Total   
C0200US37 111032 Living in urban area   
C0200US37 111033Living in rural area   
C0200US38 111031 Total   
C0200US38 111032 Living in urban area   
C0200US38 111033Living in rural area   
C0200US39 111031 Total   
C0200US39 111032 Living in urban area   
C0200US39 111033Living in rural area   
C0200US40 111031 Total   
C0200US40 111032 Living in urban area   
C0200US40 111033Living in rural area   
C0200US41 111031 Total   
C0200US41 111032 Living in urban area   
C0200US41 111033Living in rural area   
C0200US42 111031 Total   
C0200US42 111032 Living in urban area   
C0200US42 111033Living in rural area   
C0200US44 111031 Total   
C0200US44 111032 Living in urban area   
C0200US44 111033Living in rural area   
C0200US45 111031 Total   
C0200US45 111032 Living in urban area   
C0200US45 111033Living in rural area   
C0200US46 111031 Total   
C0200US46 111032 Living in urban area   
C0200US46 111033Living in rural area   
C0200US47 111031 Total   
C0200US47 111032 Living in urban area   
C0200US47 111033Living in rural area   
C0200US48 111031 Total   
C0200US48 111032 Living in urban area   
C0200US48 111033Living in rural area   
C0200US49 111031 Total   
C0200US49 111032 Living in urban area   
C0200US49 111033Living in rural area   
C0200US50 111031 Total   
C0200US50 111032 Living in urban area   
C0200US50 111033Living in rural area   
C0200US51 111031 Total   
C0200US51 111032 Living in urban area   
C0200US51 111033Living in rural area   
C0200US53 111031 Total   
C0200US53 111032 Living in urban area   
C0200US53 111033Living in rural area   
C0200US54 111031 Total   
C0200US54 111032 Living in urban area   
C0200US54 111033Living in rural area   
C0200US55 111031 Total   
C0200US55 111032 Living in urban area   
C0200US55 111033Living in rural area   
C0200US56 111031 Total   
C0200US56 111032 Living in urban area   
C0200US56 111033Living in rural area   
C0200US72 111031 Total   
C0200US72 111032 Living in urban area   
C0200US72 111033Living in rural area   
C0201US01 111031 Total   
C0201US01 111032 Living in urban area   
C0201US01 111033Living in rural area   
C0201US02 111031 Total   
C0201US02 111032 Living in urban area   
C0201US02 111033Living in rural area   
C0201US04 111031 Total   
C0201US04 111032 Living in urban area   
C0201US04 111033Living in rural area   
C0201US05 111031 Total   
C0201US05 111032 Living in urban area   
C0201US05 111033Living in rural area   
C0201US06 111031 Total   
C0201US06 111032 Living in urban area   
C0201US06 111033Living in rural area   
C0201US08 111031 Total   
C0201US08 111032 Living in urban area   
C0201US08 111033Living in rural area   
C0201US09 111031 Total   
C0201US09 111032 Living in urban area   
C0201US09 111033Living in rural area   
C0201US10 111031 Total   
C0201US10 111032 Living in urban area   
C0201US10 111033Living in rural area   
C0201US11 111031 Total   
C0201US11 111032 Living in urban area   
C0201US11 111033Living in rural area   
C0201US12 111031 Total   
C0201US12 111032 Living in urban area   
C0201US12 111033Living in rural area   
C0201US13 111031 Total   
C0201US13 111032 Living in urban area   
C0201US13 111033Living in rural area   
C0201US15 111031 Total   
C0201US15 111032 Living in urban area   
C0201US15 111033Living in rural area   
C0201US16 111031 Total   
C0201US16 111032 Living in urban area   
C0201US16 111033Living in rural area   
C0201US17 111031 Total   
C0201US17 111032 Living in urban area   
C0201US17 111033Living in rural area   
C0201US18 111031 Total   
C0201US18 111032 Living in urban area   
C0201US18 111033Living in rural area   
C0201US19 111031 Total   
C0201US19 111032 Living in urban area   
C0201US19 111033Living in rural area   
C0201US20 111031 Total   
C0201US20 111032 Living in urban area   
C0201US20 111033Living in rural area   
C0201US21 111031 Total   
C0201US21 111032 Living in urban area   
C0201US21 111033Living in rural area   
C0201US22 111031 Total   
C0201US22 111032 Living in urban area   
C0201US22 111033Living in rural area   
C0201US23 111031 Total   
C0201US23 111032 Living in urban area   
C0201US23 111033Living in rural area   
C0201US24 111031 Total   
C0201US24 111032 Living in urban area   
C0201US24 111033Living in rural area   
C0201US25 111031 Total   
C0201US25 111032 Living in urban area   
C0201US25 111033Living in rural area   
C0201US26 111031 Total   
C0201US26 111032 Living in urban area   
C0201US26 111033Living in rural area   
C0201US27 111031 Total   
C0201US27 111032 Living in urban area   
C0201US27 111033Living in rural area   
C0201US28 111031 Total   
C0201US28 111032 Living in urban area   
C0201US28 111033Living in rural area   
C0201US29 111031 Total   
C0201US29 111032 Living in urban area   
C0201US29 111033Living in rural area   
C0201US30 111031 Total   
C0201US30 111032 Living in urban area   
C0201US30 111033Living in rural area   
C0201US31 111031 Total   
C0201US31 111032 Living in urban area   
C0201US31 111033Living in rural area   
C0201US32 111031 Total   
C0201US32 111032 Living in urban area   
C0201US32 111033Living in rural area   
C0201US33 111031 Total   
C0201US33 111032 Living in urban area   
C0201US33 111033Living in rural area   
C0201US34 111031 Total   
C0201US34 111032 Living in urban area   
C0201US34 111033Living in rural area   
C0201US35 111031 Total   
C0201US35 111032 Living in urban area   
C0201US35 111033Living in rural area   
C0201US36 111031 Total   
C0201US36 111032 Living in urban area   
C0201US36 111033Living in rural area   
C0201US37 111031 Total   
C0201US37 111032 Living in urban area   
C0201US37 111033Living in rural area   
C0201US38 111031 Total   
C0201US38 111032 Living in urban area   
C0201US38 111033Living in rural area   
C0201US39 111031 Total   
C0201US39 111032 Living in urban area   
C0201US39 111033Living in rural area   
C0201US40 111031 Total   
C0201US40 111032 Living in urban area   
C0201US40 111033Living in rural area   
C0201US41 111031 Total   
C0201US41 111032 Living in urban area   
C0201US41 111033Living in rural area   
C0201US42 111031 Total   
C0201US42 111032 Living in urban area   
C0201US42 111033Living in rural area   
C0201US44 111031 Total   
C0201US44 111032 Living in urban area   
C0201US44 111033Living in rural area   
C0201US45 111031 Total   
C0201US45 111032 Living in urban area   
C0201US45 111033Living in rural area   
C0201US46 111031 Total   
C0201US46 111032 Living in urban area   
C0201US46 111033Living in rural area   
C0201US47 111031 Total   
C0201US47 111032 Living in urban area   
C0201US47 111033Living in rural area   
C0201US48 111031 Total   
C0201US48 111032 Living in urban area   
C0201US48 111033Living in rural area   
C0201US49 111031 Total   
C0201US49 111032 Living in urban area   
C0201US49 111033Living in rural area   
C0201US50 111031 Total   
C0201US50 111032 Living in urban area   
C0201US50 111033Living in rural area   
C0201US51 111031 Total   
C0201US51 111032 Living in urban area   
C0201US51 111033Living in rural area   
C0201US53 111031 Total   
C0201US53 111032 Living in urban area   
C0201US53 111033Living in rural area   
C0201US54 111031 Total   
C0201US54 111032 Living in urban area   
C0201US54 111033Living in rural area   
C0201US55 111031 Total   
C0201US55 111032 Living in urban area   
C0201US55 111033Living in rural area   
C0201US56 111031 Total   
C0201US56 111032 Living in urban area   
C0201US56 111033Living in rural area   
C0201US72 111031 Total   
C0201US72 111032 Living in urban area   
C0201US72 111033Living in rural area   
C0243US01 111031 Total   
C0243US01 111032 Living in urban area   
C0243US01 111033Living in rural area   
C0243US02 111031 Total   
C0243US02 111032 Living in urban area   
C0243US02 111033Living in rural area   
C0243US04 111031 Total   
C0243US04 111032 Living in urban area   
C0243US04 111033Living in rural area   
C0243US05 111031 Total   
C0243US05 111032 Living in urban area   
C0243US05 111033Living in rural area   
C0243US06 111031 Total   
C0243US06 111032 Living in urban area   
C0243US06 111033Living in rural area   
C0243US08 111031 Total   
C0243US08 111032 Living in urban area   
C0243US08 111033Living in rural area   
C0243US09 111031 Total   
C0243US09 111032 Living in urban area   
C0243US09 111033Living in rural area   
C0243US10 111031 Total   
C0243US10 111032 Living in urban area   
C0243US10 111033Living in rural area   
C0243US12 111031 Total   
C0243US12 111032 Living in urban area   
C0243US12 111033Living in rural area   
C0243US13 111031 Total   
C0243US13 111032 Living in urban area   
C0243US13 111033Living in rural area   
C0243US15 111031 Total   
C0243US15 111032 Living in urban area   
C0243US15 111033Living in rural area   
C0243US16 111031 Total   
C0243US16 111032 Living in urban area   
C0243US16 111033Living in rural area   
C0243US17 111031 Total   
C0243US17 111032 Living in urban area   
C0243US17 111033Living in rural area   
C0243US18 111031 Total   
C0243US18 111032 Living in urban area   
C0243US18 111033Living in rural area   
C0243US19 111031 Total   
C0243US19 111032 Living in urban area   
C0243US19 111033Living in rural area   
C0243US20 111031 Total   
C0243US20 111032 Living in urban area   
C0243US20 111033Living in rural area   
C0243US21 111031 Total   
C0243US21 111032 Living in urban area   
C0243US21 111033Living in rural area   
C0243US22 111031 Total   
C0243US22 111032 Living in urban area   
C0243US22 111033Living in rural area   
C0243US23 111031 Total   
C0243US23 111032 Living in urban area   
C0243US23 111033Living in rural area   
C0243US24 111031 Total   
C0243US24 111032 Living in urban area   
C0243US24 111033Living in rural area   
C0243US25 111031 Total   
C0243US25 111032 Living in urban area   
C0243US25 111033Living in rural area   
C0243US26 111031 Total   
C0243US26 111032 Living in urban area   
C0243US26 111033Living in rural area   
C0243US27 111031 Total   
C0243US27 111032 Living in urban area   
C0243US27 111033Living in rural area   
C0243US28 111031 Total   
C0243US28 111032 Living in urban area   
C0243US28 111033Living in rural area   
C0243US29 111031 Total   
C0243US29 111032 Living in urban area   
C0243US29 111033Living in rural area   
C0243US30 111031 Total   
C0243US30 111032 Living in urban area   
C0243US30 111033Living in rural area   
C0243US31 111031 Total   
C0243US31 111032 Living in urban area   
C0243US31 111033Living in rural area   
C0243US32 111031 Total   
C0243US32 111032 Living in urban area   
C0243US32 111033Living in rural area   
C0243US33 111031 Total   
C0243US33 111032 Living in urban area   
C0243US33 111033Living in rural area   
C0243US34 111031 Total   
C0243US34 111032 Living in urban area   
C0243US34 111033Living in rural area   
C0243US35 111031 Total   
C0243US35 111032 Living in urban area   
C0243US35 111033Living in rural area   
C0243US36 111031 Total   
C0243US36 111032 Living in urban area   
C0243US36 111033Living in rural area   
C0243US37 111031 Total   
C0243US37 111032 Living in urban area   
C0243US37 111033Living in rural area   
C0243US38 111031 Total   
C0243US38 111032 Living in urban area   
C0243US38 111033Living in rural area   
C0243US39 111031 Total   
C0243US39 111032 Living in urban area   
C0243US39 111033Living in rural area   
C0243US40 111031 Total   
C0243US40 111032 Living in urban area   
C0243US40 111033Living in rural area   
C0243US41 111031 Total   
C0243US41 111032 Living in urban area   
C0243US41 111033Living in rural area   
C0243US42 111031 Total   
C0243US42 111032 Living in urban area   
C0243US42 111033Living in rural area   
C0243US44 111031 Total   
C0243US44 111032 Living in urban area   
C0243US44 111033Living in rural area   
C0243US45 111031 Total   
C0243US45 111032 Living in urban area   
C0243US45 111033Living in rural area   
C0243US46 111031 Total   
C0243US46 111032 Living in urban area   
C0243US46 111033Living in rural area   
C0243US47 111031 Total   
C0243US47 111032 Living in urban area   
C0243US47 111033Living in rural area   
C0243US48 111031 Total   
C0243US48 111032 Living in urban area   
C0243US48 111033Living in rural area   
C0243US49 111031 Total   
C0243US49 111032 Living in urban area   
C0243US49 111033Living in rural area   
C0243US50 111031 Total   
C0243US50 111032 Living in urban area   
C0243US50 111033Living in rural area   
C0243US51 111031 Total   
C0243US51 111032 Living in urban area   
C0243US51 111033Living in rural area   
C0243US53 111031 Total   
C0243US53 111032 Living in urban area   
C0243US53 111033Living in rural area   
C0243US54 111031 Total   
C0243US54 111032 Living in urban area   
C0243US54 111033Living in rural area   
C0243US55 111031 Total   
C0243US55 111032 Living in urban area   
C0243US55 111033Living in rural area   
C0243US56 111031 Total   
C0243US56 111032 Living in urban area   
C0243US56 111033Living in rural area   
C0243US72 111031 Total   
C0243US72 111032 Living in urban area   
C0243US72 111033Living in rural area   
C02A0US01 111031 Total   
C02A0US01 111032 Living in urban area   
C02A0US01 111033Living in rural area   
C02A0US02 111031 Total   
C02A0US02 111032 Living in urban area   
C02A0US02 111033Living in rural area   
C02A0US04 111031 Total   
C02A0US04 111032 Living in urban area   
C02A0US04 111033Living in rural area   
C02A0US05 111031 Total   
C02A0US05 111032 Living in urban area   
C02A0US05 111033Living in rural area   
C02A0US06 111031 Total   
C02A0US06 111032 Living in urban area   
C02A0US06 111033Living in rural area   
C02A0US08 111031 Total   
C02A0US08 111032 Living in urban area   
C02A0US08 111033Living in rural area   
C02A0US09 111031 Total   
C02A0US09 111032 Living in urban area   
C02A0US09 111033Living in rural area   
C02A0US10 111031 Total   
C02A0US10 111032 Living in urban area   
C02A0US10 111033Living in rural area   
C02A0US11 111031 Total   
C02A0US11 111032 Living in urban area   
C02A0US11 111033Living in rural area   
C02A0US12 111031 Total   
C02A0US12 111032 Living in urban area   
C02A0US12 111033Living in rural area   
C02A0US13 111031 Total   
C02A0US13 111032 Living in urban area   
C02A0US13 111033Living in rural area   
. . .       
then C02G0 and rest of geocomponents            
then C03, then C04, etc. through C09            
Updated: 05/14/2013
HEP Home Planning Environment Real Estate
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000