Bronx2000ICD9CensusTracts
Since the source for the ICD9 data has not yet been updated to reflect the changes in the 2010 Census Tracts, I used 2000 Census Tracts with 2010 ICD9 data. This decreased the number of errors and tracts lacking data by 25%. This data is updated
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 \"bronx-lehman-cuny-edu/bronx2000icd9censustracts-e8wp-sccx\".\"bronx2000icd9censustracts\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.