This file includes census tract to census tract flows from the new CTPP 2006-2010, using the American Community Survey. The Microsoft Access file has a total of 4,156,426 records. Download the database file. (151 MB; requires Microsoft Access.)
The file includes all tract pairs which present flows from the CTPP 2006-2010 including Puerto Rico. This file only include one measure: total worker counts and its associated margins of error. FIPS codes are also provided for residence and workplace State, County and Census Tract.
This tutorial provides a guide on how to query the database.
Example: I want to get flows from all the tracts in Broward County, Florida (County FIPS =11, State FIPS = 12) to all tracts in Florida.
Please note: if you are looking for a Census Tract ID, for example Census Tract ID = 0201.00, you will have to provide number "20100" in the query as all Census Tract IDs are converted to numbers.
Step (3). Close the "Show Table" window. In the Field row, click on drop down arrow in each cell to add variables . You must add ALL variables from the tract-flows database as only selected variables will be included in the queried database. In the Criteria Row, enter the corresponding FIPS codes to filtrate the desired records. In our example, criteria include:
Step (4). The output can be saved by right clicking on the table tab "Query1", and then you will be asked to type the table name. Type "Broward County FL". A table index is automatically created On the left panel.
Step (5). You can export Access file into Excel by right clicking on table name on the left panel. However, users must be aware that the maximum records of 2010 Excel is 1,048,576. If your queried database is bigger than 1,048,576 records, a statistical software (SAS,SPSS and Access) is recommended to manipulate the data.