About this Dataset

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.
Organization: City of New York
Last updated: 2020-11-10T17:01:46.030534
Tags: bic, cl1, class-1, landscaper, nycbic, registrant, self-hauler, waste

Tables

Table 1

@usgov.city_of_new_york_self_hauler_registrants.table_1

9.49 MB
1,112,017 rows
25 columns

CREATE TABLE table_1 (
  "created" TIMESTAMP,
  "bic_number" VARCHAR,
  "account_name" VARCHAR,
  "trade_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "application_type" VARCHAR,
  "disposition_date" TIMESTAMP,
  "effective_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "renewal" VARCHAR,
  "export_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "boro" VARCHAR
);