Legally Operating Businesses

This data set features businesses/individuals holding a DCA license so that they may legally operate in New York City. Note: Sightseeing guides and temporary street fair vendors are not included in this data set.</br>

<b>*Due to COVID-19 pandemic, DCA extended certain license expiration dates and renewal application deadlines which are not reflected in this data set. For more information, visit <a href="https://www1.nyc.gov/site/dca/businesses/licenses.page">nyc.gov/BusinessToolbox</a>.</b>

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.