Icon for Socrata external plugin
Open repository in Console
Updated 5 years ago
Indexed 2 hours ago

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.

Denominator: U.S. Census Bureau, American Community Survey 1-Year Summary Estimates (2007-2017), Table B01003.|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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"healthstat-dph-sbcounty-gov/countymetro-indicator-health-professional-shortage-8qj6-q9nf\".\"countymetro_indicator_health_professional_shortage\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • countymetro_indicator_health_professional_shortage