Self Hauler Registrants

Companies listed as of the most recent export date have been issued Class 1 self-hauler registrations by the Business Integrity Commission. They are authorized to remove, collect or dispose of trade waste that is generated in the course of operation of such person's business. (Companies removing, collecting or disposing of construction and demolition debris must apply for Exemption from Licensing Requirements, otherwise known as Class 2 Construction and Demolition Registration).

This data is collected on the entities that apply with the commission to operate as class 1 self hauler registrants.

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 'CL1' noting the type of applicant which is Class 1 Self Hauler Registration

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/self-hauler-registrants-a8wp-rerh\".\"self_hauler_registrants\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.