Text Alternative for Data Files Instructional Video

Video Actions Audio Transcription
The AGID home page. The cursor moves over the Data Files link in the middle of the home page. The following tutorial will take an in-depth look at the Data Files section of AGID.
The Download Data Files and Documentation landing page. These files are provided to assist with more detailed analysis and can be downloaded in several different formats.
The Download Data Files and Documentation landing page. The links in the middle are highlighted to show the different data files. Currently, data files are available for AoA Special Tabulations, the National Survey of OAA Participants, and the National Survey of Area Agencies on Aging. Additional data files will be added as they become available.
The Download Data Files and Documentation landing page. The "AoA Special Tabulations" link is chosen. Below it is expanded to show the different tabulations and a description of each. We will first look at the AoA Special Tabulations. The Special Tabulations are based on the Census Bureau's American Community Survey data and are made up of sets of tables for a variety of topic areas with different geographic levels of aggregation.

The design of the special tabulations took into consideration the data needs of state and area agencies and others involved in programs and services for aging and priority populations.

In addition, the data contain estimates at the PSA, county, Census Tract, and other geographic levels, when feasible. Users can access tables with the ACS 5-year estimates and disability tables with the ACS 3-year estimates.
The Download Data Files and Documentation landing page. The "2005 - 2009 ACS Special Tabulation" link is chosen from the list. In this tutorial, we will look at the AoA Special Tabulation for 2005 to 2009.
The Quick Tips on the 2005-2009 ACS Special Tabulation on Aging page. The cursor moves to expand and hide the "Technical Documentation" tab information. At the top of the page, there are links to the technical documentation. The rest of the page shows groups of data tables by topic area.
The Quick Tips on the 2005-2009 ACS Special Tabulation on Aging page. The cursor selects "Alabama" from the "Select a state" drop down. Use the Select a State drop-down list to choose a state.
The Quick Tips on the 2005-2009 ACS Special Tabulation on Aging page. The cursor selects the "Age and Population" link which expands a section below it containing links to different tables. The cursor selects the "S21001 - Total Population" link. Expand a table group to select an individual table.
The Alabama 2005-2009 Total Population data page. Once you click on a table, you will be taken to a preview page.
The Alabama 2005-2009 Total Population data page showing the "Save" link in the top. The "Save" link expands to show "Excel", "Excel 2003", and "XML" options. Here you can view the data in a table or use the Save menu to download the entire table. The files can be downloaded in Excel or XML format.
The Alabama 2005-2009 Total Population data page. At the top of the page there are breadcrumbs which are highlighted. The breadcrumbs at the top of the page are a useful way to navigate back to previous pages.
The Alabama 2005-2009 Total Population data page. At the top of the page in the breadcrumb, the cursor selects the "2005 - 2009 Special Tabulation" link. We can use this link to go back to the main page for the 2005 to 2009 Special Tabulation to change the state and select another table.
The Quick Tips on the 2005-2009 ACS Special Tabulation on Aging page. The cursor selects "California" as the state and chooses "Household Type and Martial Status" from the list. The section expands to show a list of links. The cursor chooses the first link which is "S21010A - Age by Sex by Household Type (Including Living Alone) by Relationship of the Population 60 Years and Over". Here we see a table of Household Type and Marital Status for California. Note that due to browser limitations, only a partial view of the data for the larger tables can be seen on the screen. Use the Save menu to download and see the entire data table.
The Quick Tips on the 2005-2009 ACS Special Tabulation on Aging page. The "Data Files" link from the breadcrumb above is selected and the "Download Data Files and Documentation" page is displayed. Next we'll navigate back to the main page for Data Files and examine a survey database.
The Download Data Files and Documentation landing page. The "National Survey of OAA Participants" link is clicked and a link with its description is displayed below it. The "National Survey of OAA Participants" link is selected. We will look at the National Survey of Older Americans Act Participants. Multiple years of data are available for this survey.
The National Survey of OAA Participants page. There is a table with years and different links for data. The "Information and Assistance" link under "Access Services" for 2003 is selected. The data and documentation are organized by year and by service. We'll select Information and Assistance for 2003.
The 2003 Information and Assistance page. Users can download data in different formats. The files are zipped to reduce their size for faster downloading. Files in zipped format must be uncompressed using a zip utility in order to use their contents. Supporting documentation such as the survey instrument, codebooks with frequencies of the data elements, and programming statements are available for each data file.

This concludes the Data Files tutorial.