Icon for Socrata external plugin
Open repository in Console
Updated 5 years ago
Indexed 7 days ago

County/Metro Indicator - Access to Health Professionals

Numerator: Medical Board of California, Annual Reports (2007-2008, 2008-2009, 2009-2010, 2010-2011, 2011-2012, 2012-2013, 2013-2014, 2014-2015, 2015-2016,2016-2017).

Denominator: U.S. Census Bureau, American Community Survey 1-Year Summary Estimates (2007-2017), Table B01001.|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-access-to-health-9ear-7rwn\".\"countymetro_indicator_access_to_health\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • countymetro_indicator_access_to_health