OD0030 Physician, Hospital And Nursing Home Statistics from 2009

An analysis of physician, hospital, and nursing home statistics for Prince Edward Island, from 2009.

The number of practicing physicians is the number of full-time equivalent positions filled by physicians as of December of each year. It does not include locum or out-of-province visiting physicians.The number of funded beds in licensed private nursing homes is as of December of each year.

Prince Edward Home beds – note that from 2009 to 2013, the numbers include convalescent/restorative beds, as well as beds for under 60 year old residents. In 2014 a new Prince Edward Home was constructed.

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 \"princeedwardisland-ca/od0030-physician-hospital-and-nursing-home-76n9-ph3c\".\"od0030_physician_hospital_and_nursing_home\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.