Micro-Market Recovery Program - Cases

The City of Chicago launched the Micro-Market Recovery Program (MMRP), a coordinated effort among the City, not-for-profit intermediaries, and non-profit and for-profit capital sources to improve conditions, strengthen property values, and create environments supportive of private investment in targeted markets throughout the city. The goal of MMRP is to improve conditions, strengthen property values, and create environments supportive of private investment in targeted areas by strategically deploying public and private capital and other tools and resources in well-defined micro-markets. This MMRP Case dataset contains all Department of Buildings (DOB) Cases that have occured at properties falling within any MMRP Zone. Permits, Cases and Violations can be linked to the MMRP Geographies dataset using ADDRKEY or ADDRGRPKEY. To link Violations and Inspections to their Permits and Cases use Violation PERMITORCASEKEY to link to Permits APKEY_PERMIT and Cases APKEY_CASE. For more information on the MMRP program, please see http://www.regionalhopi.org/content/city-chicago-micro-market-recovery-program-overview.

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 \"cityofchicago/micromarket-recovery-program-cases-gm9b-bwv5\".\"micromarket_recovery_program_cases\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.