Performance Metrics - Business Affairs & Consumer Protection - Retail Food Licenses

All restaurants and food stores selling perishable items are required to apply for a Retail Food License (RFL). This metric tracks the average number of days the Department of Business Affairs and Consumer Protection (BACP) takes to issue RFLs. The target response time for processing is within 15 days.

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/performance-metrics-business-affairs-consumer-uxj2-up34\".\"performance_metrics_business_affairs_consumer\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.