This tutorial consists of a collection of video modules that provide the basic information needed to make use of the Missouri Census Data Center's acsmcdcprofiles_extract web application. We have an overview module where we explain the basic concepts of the application with some clues as to who would use it and why. The remaining modules are video demonstrations of the application being used to perform common types of data extractions.
The video modules are mp4 files, so you will need to have software (such as Windows MediaPlayer) that can handle such a file. The examples are being created in May of 2013, using vintage 2011 ACS data. If you are accessing the tutorial in 2014 or later some of the examples may not work exactly the same. But the basic concepts should remain the same.
- Overview (short ppt presentation)
- Example 1: Simple extract of 3 tables for all counties in a single state (Missouri) (9:30)
- Example 1a: Use Dexter capabilities to create a custom report in HTML format featuring just a few variables related to poverty. (7:15)
- Example 2: Selected Tables for all the ZIP Codes in California (8:30 )
In this module we demonstrate accessing data at the ZCTA (ZIP Census Tabulation Area) level for the state of California. We demonstrate the ease of creating multiple output csv files and converting those to Excel spreadsheets.
- Example 3: Hispanic population by Census Tract for state of Missouri (4:50 )
Includes a brief discussion of how output files are saved and can be readily shared with colleagues or clients who may be the ones who need to process the data.
- Example 4: Income and Poverty data for all places in a 5-state Area (4:15 )
- Example 5: Poverty Ratios for block groups in Adams County, Ill. (4:09 )
- Example 6a: All tables for all counties in a state using Dexter transpose feature. (7:47)
This example using the Dexter Advanced Options section and features the Transpose capabilities. Output has the profile variables as the rows of the report/csv file and the counties of a selected state (CT) as the columns. We save the resulting dexter query as a Queries module that you can access via Uexplore. Select the acs_extract6a.html file to have the completed dexter query form loaded into your browser. You can then run the query as-is by just using one of the Extract Data buttons. Or, you could first modify the state code ("Value" column) used to filter in Section II get data for your state rather than Connecticut. E.g. change the 09 to 06 and you would get data for California.
This file last modified Tuesday May 28, 2013, 08:48:52