Medicare and Medicaid Healthcare Facilities

This is the "Provider of Service" extract from the Quality Improvement Evaluation System (QIES) database maintained by the Centers for Medicare & Medicaid Services (CMS). These data include provider number, name, and address and characterize the participating institutional provider (including hospitals, skilled nursing facilities, home health agencies, and other types of facilities). The data are collected through the CMS Regional Offices. The file contains an individual record for each Medicare-approved provider and is updated quarterly.

http://datawarehouse.hrsa.gov/tools/dataportal.aspx

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 \"celebratingcities-data-socrata/medicare-and-medicaid-healthcare-facilities-vpts-5agk\".\"medicare_and_medicaid_healthcare_facilities\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.