cityofchicago/micromarket-recovery-program-violations-and-ujwc-724r
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Micro-Market Recovery Program - Violations and Inspections

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 Violations and Inspections dataset contains Department of Buildings (DOB) Violations and associated Inspections that have occured at properties falling within an 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 and link to Permits APKEY_PERMIT and Cases APKEY_CASE. *Note: Inspections are included only when at least one violation was written. Inspections without violations are not included in this dataset.

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-violations-and-ujwc-724r\".\"micromarket_recovery_program_violations_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • micromarket_recovery_program_violations_and
     
     
     
     
     
Upstream Metadata