Data Warehouse Help and Frequently Asked Questions (FAQs)
|
HRSA’s Data Warehouse (HDW) serves as the official repository for current HRSA data and the point of access for reporting on HRSA Activities.
- For a printable document summarizing the Data Warehouse, see our Information Sheet
 (36 KB)
|
| What data sets are available in the Data Warehouse? |
A detailed listing is available which also shows the Data Refresh Dates. Data in the HDW consists of the following:
- Active Grants. The term "active grant" refers to a grant whose project period end date occurs after the date of a given report or map. A grant can be "active" whether or not it has received an award in the current fiscal year.
- Awarded Grants. Fiscal Year 1999 through the current date. Updated daily from the Electronic Handbooks (EHB).
- Area Health Education Centers. AHEC centers provide community-based education in primary care, public health and the needs of underserved populations.
- Area Resource File. A collection of data from over 50 sources, to be used by health care planners, policy makers and researchers interested in the US health care delivery system.
- Births and Infant Deaths.
- U.S. Census. Health-related data from the U.S. Census Bureau.
- Congressional Districts. Geographic data based on congressional districts.
- Health Care Service Delivery Sites. Data relating to HRSA-supported health centers which provide care for anyone, including those who lack health insurance.
- Health Professional Shortage Areas. Health Professional Shortage Areas (HPSAs) are designated by HRSA as having shortages of primary medical care, dental or mental health providers and may be geographic (a county or service area), demographic (low income population) or institutional (comprehensive health center, federally qualified health center or other public facility).
- Medically Underserved Areas / Populations. Medically Underserved Areas/Populations are areas or populations designated by HRSA as having: too few primary care providers, high infant mortality, high poverty and/or high elderly population.
- National Health Service Corps Awards, Providers and Sites. NHSC primary health care clinics and facilities are improving care to their communities by recruiting and retaining NHSC providers.
- CMS – Providers of Services. Information from the Centers for Medicare and Medicaid Services.
- National Sample Survey of Registered Nurses. Used to sample and estimate the characteristics of registered nurses in the workforce.
- Organ Procurement Organizations and Organ Transplantation Centers. OPOs are non-profit organizations responsible for recovering organ and tissues for transplantation and promoting donor registration. OTCs are hospital units that provide an array of services related to the transplantation of organs.
- Primary Care Service Areas (2006). Nationwide data on primary health care resources, populations and utilization.
- Ryan White Providers of Ambulatory and Medical Care. The Ryan White HIV/AIDS Program can help people living with HIV/AIDS access the medical care they need.
- Uniform Data System (UDS) Performance Data. For reviewing the operation and performance of health centers.
|
| Where can I see a summary of HRSA's Activities Data? |
|
| My organization's contact information is incorrect. How can this be fixed? |
|
| When searching for Health Professional Shortage Areas (HPSAs) using the City and State selection tool, why do I get fewer results than when I use the two-letter state abbreviation? |
- Using the HPSA search tool to search by City and State will return only "Point" type (i.e. facility) HPSAs because this type of HPSA contains city and state information. Using the state abbreviation will return all HPSAs, a much larger group, but which have no city identifier included.
|
| How are clinicians and grantee counts calculated? |
- Clinicians and grantees may serve or operate in multiple locations with funds from a single grant or award. These locations may be in different HRSA regions, states, counties, or Congressional Districts. Because of this, the counts of clinicians and grantees may not “roll up” across all geographic reporting areas.
|
| How are shortage area counts calculated? |
- The geographic boundaries of shortage areas, including HPSAs, MUAs, and MUPs, may cross the geographic boundaries of a HRSA region, state, county, or Congressional District. As a result, a shortage area may be counted in more than one geographic area. Alternately, some shortage areas cannot be geocoded to an exact location, only to the state or territory in which they are located.
|
| Why do quotation marks appear around the data when I download data in Excel? |
- By default, Microsoft Excel removes leading zeros when data is imported into an Excel file. For example, without adding the quotation marks in the Excel files when the automatic import, the zip code 02108 would appear as 2108, which is not a valid zip code format. To preserve the integrity of the data, the Data Warehouse team has added quotation marks to the data in automatic Excel download files. To remove the quotation marks, please use the find and replace function in Excel to find quotation marks (") and replace them with no value.
- CSV files do not provide the option to preserve the leading zeros in this way, so please be aware that when accessing data via CSV file, leading zeros will be dropped.
|
|
I'm having trouble with the HRSA Data Warehouse (HDW) site. How can I get help?
For documentation and help with our Report Tool, please see Interactive Report Tool Help or Printer-friendly Report Tool Help (PDF, approx. 400 KB)
For documentation and help with our Mapping Tool, please see Interactive Map Tool Help or Printer-friendly Map Tool Help (PDF, approx. 1.2 MB)
If these documents do not answer your question, contact the HRSA Call Center at
CallCenter@hrsa.gov
or 1-877-464-4772, weekdays from 9 am to 5:30 pm ET (except Federal holidays).
The HRSA Data Warehouse consists of the data sets listed above and tools to access them. If you did not find what you were looking for, please visit www.hrsa.gov. Some pages you might find useful include:
|
|
About Congressional District Boundaries:
On January 3, 2013, the 113th Congress began its session. The Census Bureau released the geographies for the new districts on January 7, 2013. The HDW is updating its reference data with the new geographies. In the interim, HDW will use the 112th Congressional District boundaries, which may affect geoprocessing assignments. Read more >>
Daily updates of the HPSA data will resume on March 29, 2013. If you have any questions, please contact CAPT Phil Budashewitz, Director, Division of Policy and Shortage Designation, Bureau of Clinician Recruitment and Service at pbudashewitz@hrsa.gov.
|
Rate this Page