DOI: 10.7910/dvn/alw9sj
title: Health Professional Shortage Areas (HPSA)

description: &lt;h3 class="post-title entry-title" itemprop="name"&gt; analyze health professional shortage areas (hpsa) with r &lt;/h3&gt; a health professional shortage area (hpsa) is a geographic area, population group, or health care facility that has been designated by the united states government as having an insufficient supply of medical providers, based on certain provider-to-population ratios. primary care physician shortage areas are usually defined as any geography with fewer than one general practitioner
for every 3,500 residents. dental and mental health shortage areas have fewer than one dentist or mental health professional per 5,000 and 30,000 residents, respectively. states and locales have some financial incentives to receive this designation:
&lt;a href="http://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/HPSAPSAPhysicianBonuses/index.html?redirect=/HPSAPSAPhysicianBonuses/"&gt;medicare bonuses&lt;/a&gt;, &lt;a href="http://nhsc.hrsa.gov/"&gt;loan repayment&lt;/a&gt;, etc. the united states &lt;a href="http://www.hrsa.gov/"&gt;health resources and services administration (hrsa)&lt;/a&gt; holds the key to this data castle.&lt;br /&gt; &lt;br /&gt; to quickly understand exactly what's possible with this microdata, look at &lt;a href="http://ersrs.hrsa.gov/ReportServer/Pages/
ReportViewer.aspx?/HGDW_Reports/BCD_HPSA/BCD_HPSA_SCR50_Smry&amp;rs:Format=HTML4.0"&gt;hrsa's nationwide statistics table&lt;/a&gt;. alright, you got me, this isn't a complex sample survey. but hey, merge it onto other survey data sets. what's that? other data sets don't have &lt;a href="http://www.census.gov/geo/www/cen_tract.html"&gt;census tract&lt;/a&gt;- or &lt;a href="http://en.wikipedia.org/wiki/Minor_civil_division"&gt;minor civil division&lt;/a&gt;-level identifiers? perhaps not in their public use files, but
&lt;a href="http://www.census.gov/sdc/"&gt;visit&lt;/a&gt; &lt;a href="http://www.cdc.gov/rdc/"&gt;the&lt;/a&gt; &lt;a href="http://www.bls.gov/bls/blsresda.htm"&gt;data&lt;/a&gt; &lt;a href="http://meps.ahrq.gov/data_stats/onsite_datacenter.jsp"&gt;centers&lt;/a&gt; and you might find the geocodes you seek. this new github repository contains three scripts:&lt;br /&gt; &lt;br /&gt; &lt;b&gt;download current hpsa table.R&lt;/b&gt;&lt;br /&gt; &lt;ul&gt; &lt;li&gt;download &lt;a href="http://datawarehouse.hrsa.gov/HPSADownload.aspx"&gt;the zipped health professional shortage areas file&lt;/
a&gt; directly onto your computer&lt;/li&gt; &lt;li&gt;load the &lt;a href="http://bhpr.hrsa.gov/shortage/hpsas/designationcriteria/primarycarehpsaoverview.html"&gt;primary care physician&lt;/a&gt;, &lt;a href="http://bhpr.hrsa.gov/shortage/hpsas/designationcriteria/dentalhpsaoverview.html"&gt;dental&lt;/a&gt;, and &lt;a href="http://bhpr.hrsa.gov/shortage/hpsas/designationcriteria/mentalhealthhpsaoverview.html"&gt;mental health&lt;/a&gt; shortage area &lt;a href="http://stat.ethz.ch/R-manual/R-devel/library/utils/html/read.table.html"&gt;tables into
r&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="http://stat.ethz.ch/R-manual/R-patched/library/base/html/save.html"&gt;save&lt;/a&gt; each file as an r data file (.rda) for fast loading later&lt;/li&gt; &lt;/ul&gt; &lt;b&gt; &lt;/b&gt;&lt;br /&gt; &lt;b&gt;identify point-in-time geographic hpsas.R&lt;/b&gt;&lt;br /&gt; &lt;ul&gt; &lt;li&gt;limit the primary care physician hpsa data to only records &lt;a href="http://bhpr.hrsa.gov/shortage/hpsas/designationcriteria/designationcriteria.html"&gt;actively designated&lt;/a&gt; on the date specified&lt;/li&gt; &lt;li&gt;further limit the data to only geographic a
reas (and possibly certain population groups)&lt;/li&gt; &lt;li&gt;if included: create flags for each of the major population groups&lt;/li&gt; &lt;li&gt;extract and save county-, minor civil division-, and census tract-level records from this original file &lt;/li&gt; &lt;/ul&gt; &lt;br /&gt; &lt;b&gt;replicate hrsa nationwide statistics.R&lt;/b&gt;&lt;br /&gt; &lt;ul&gt; &lt;li&gt;&lt;a href="https://stat.ethz.ch/pipermail/r-help/2009-March/190119.html"&gt;excel_round&lt;/a&gt;, &lt;a href="http://stat.ethz.ch/R-manual/R-devel/library/base/html/Round.html"&gt;floor&lt;/a&gt;, and &lt;a href
="http://www.ats.ucla.edu/stat/r/faq/subset_R.htm"&gt;subset&lt;/a&gt; as specified during conversations with &lt;a href="http://www.hrsa.gov/about/contact/"&gt;the friendly folks at hrsa&lt;/a&gt;&lt;/li&gt; &lt;li&gt;precisely match all five numbers in the top row of &lt;a href="http://ersrs.hrsa.gov/ReportServer/Pages/ReportViewer.aspx?/HGDW_Reports/BCD_HPSA/BCD_HPSA_SCR50_Smry&amp;rs:Format=HTML4.0"&gt;hrsa's current designation statistics table&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt; &lt;br /&gt; &lt;br /&gt; &lt;a href="https://github.com/ajdamico/usgsd/tree/master/H
ealth%20Professional%20Shortage%20Areas"&gt;click here to view these three scripts
&lt;/a&gt;&lt;br /&gt; &lt;br /&gt; &lt;br /&gt; &lt;br /&gt; for more detail about health professional shortage areas, visit:&lt;br /&gt; &lt;ul&gt; &lt;li&gt;&lt;a href="http://bhpr.hrsa.gov/shortage/hpsas/index.html"&gt;the shortage area homepage&lt;/a&gt;&lt;/li&gt; &lt;li&gt;&lt;a href="http://datawarehouse.hrsa.gov/hpsadetail.aspx"&gt;the hrsa data warehouse&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt; &lt;br /&gt; notes:&lt;br /&gt; &lt;br /&gt; depending on your goals and motivations, the cartography tools at &lt;a href="http://www.hrsa.gov/data-statistics/"&gt;hrsa's data n statistics pages&lt;/a&gt; might have all you re
ally want. loading the microdata into r is for the tinkerers among us.
&lt;br /&gt; &lt;br /&gt; for a mapping between minor civil divisions and other geographies, check out &lt;a href="http://mcdc.missouri.edu/websas/geocorr12.html"&gt;the missouri census data center's geocorr12&lt;/a&gt;. depending on what geographies you have available in the data set you're merging hpsa data to, you'll have to make some decisions about what to do when one minor civil division overlaps two or more, say, &lt;a href="https://www.google.com/search?q=zip+code+tabulation+area"&gt;zip code tabulation areas&lt;/a&gt;.
geocorr12 provides an `afact` column, which is just the percent of the population of the geography you're mapping
&lt;i&gt;from&lt;/i&gt; that lives in the geography you're mapping &lt;i&gt;to&lt;/i&gt;. woo hoo.&lt;br /&gt; &lt;br /&gt; &lt;br /&gt; confidential to sas, spss, stata, and sudaan users: why run a three-legged race when you can sprint like an olympian? time to transition to r. :D