County/Metro Indicator - Health Professional Shortage Areas

Numerator: U.S. Department of Health and Human Services. Health Resources and Services Administration (HRSA). Area Health Resources File (AHRF), 2017-2018 Release. https://datawarehouse.hrsa.gov/data/datadownload.aspx

Denominator: U.S. Census Bureau, American Community Survey 1-Year Summary Estimates (2007-2017), Table B01003. https://factfinder.census.gov/bkmk/table/1.0/en/ACS/17_1YR/B01003/0100000US|0400000US06|0500000US06071

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"healthstat-dph-sbcounty-gov/countymetro-indicator-health-professional-shortage-8qj6-q9nf\".\"countymetro_indicator_health_professional_shortage\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.