Legally Operating Businesses

<b>NOTE:</b> This dataset reflects data as of 7/21/2023. The Department of Consumer and Worker Protection (DCWP) is working on an updated version of this dataset.

This dataset features licenses issued by DCWP to businesses and individuals so that they may legally operate in New York City. Note: Temporary street fair vendor permits 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 \"cityofnewyork-us/legally-operating-businesses-w7w3-xahh\".\"legally_operating_businesses\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.