Trade Waste Hauler Licensees

Companies listed as of the most recent export date have been issued trade waste removal licenses by the Business Integrity Commission and, therefore, are authorized to collect and remove all types of trade waste covered by Local Law 42 of 1996.

This data is collected on the entities that apply with the commission to operate as Licensees.

Each record represents an entity that is approved to operate in the City of New York by the Commission.

The Application Type field denotes the class of application 'License' noting the type of applicant which is a Licensee. They are able to pickup all trade waste from various businesses throughout the city.

The BIC Number field is unique to every company that applies to the Commission.

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/trade-waste-hauler-licensees-867j-5pgi\".\"trade_waste_hauler_licensees\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.