What Is AGID?
The AGing Integrated Database (AGID) system is an on-line query system that provides dynamic access to AoA-related program performance results, surveys and other data files. The purpose of the system is to allow users to produce customized tables in a step-by-step process and output the results in print or spreadsheet form. Whereas much of the information in AGID can be gathered from other sources, AGID users have the ability to select only those data elements applicable to their needs, and to further refine their results based on geographic locations (such as individual states or AoA regions) or demographic stratifiers that are meaningful to their application. In addition, the results from user queries can be downloaded in spreadsheet form and, in turn, post-processed for graphical displays or more in-depth analyses.
The system is based on aggregate statistics reports to speed up data access and protect individual records. Since there are many thousands of data elements available in the original databases, only the analytically relevant variables were carried over to AGID. If there is a query you would like to see that AGID does not support, please submit a request using the “Submit Feedback” link on the AGID home page and you will receive a prompt response. Although there are constructed variables and some restructuring of the database files, most of the data elements appearing in the system are in the form as reported by the states or survey participants.
The databases that are currently available in the system are listed below. Additional data sources are being considered for inclusion in the system, and all current files are updated on a periodic basis as new data become available. The “What’s New?” text on the AGID home page will provide users with information about updates to the system when they occur. Note that many of these are supplemented by survey instruments, reporting requirements documents, and codebooks that contain frequency counts and percentages of all individual data elements.
State Program Reports (SPR), 2000-2008
National Ombudsman Reporting System (NORS), 2000-2008
National Survey of Older Americans Act (OAA) Participants, 2003-2005, 2008
National Survey of Area Agencies on Aging (AAA), 2005/2006
Title VI Services by Tribal Organization 2002-2008
American Community Survey (ACS) Demographic Data, 2004-2008
State-Level Population Estimates Data, 2000-2008
County-Level Population Estimates Data, 2000-2008
PSA-Level Population Estimates Data, 2000-2008
A unique feature of the AGID system is the ability to build your own customized database. The user has the option of selecting a single database in generating database-specific tables or combining data elements from multiple databases to build a customized table. All of the state-level databases appearing in AGID – SPR, NORS, ACS and Population Data – are available for multi-database processing. Since state estimates are not available, the National AAA and OAA Programs survey data are excluded from this feature.
What You Can Do With AGID-Generated Data
AGID was designed to be a simple and easy-to-use system for accessing AoA-related related data and population characteristics from the Census Bureau. The intention was to allow users the ability to construct and print customized tables or, if desired, download the table output in spreadsheet form for post-processing. The ability to export the data to an Excel spreadsheet provides the user with the flexibility to create a whole range of graphs, charts or print quality reports using any number of tools, programming languages or graphical display software. Although there are unlimited uses, this section provides a few examples of charts generated from AGID data.
A simple table is generated in AGID using the 2005 National Survey of OAA Participants data. A single data element, overall rating for home delivered meals, was selected in the table construction process and stratified by number of ADLs: