Performance Metrics - Business Affairs & Consumer Protection - Limited Business Licenses

Limited Business Licenses (LBLs) are required for all Chicago businesses not specifically exempt from licensing requirements. This includes all business that provide services, or engage in office operations or general sales. Currently the performance target for processing Limited Business Licenses is 3 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-7483-qiqw\".\"performance_metrics_business_affairs_consumer\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.