About this Dataset

Trade Waste Broker Registrants

Companies listed as of the most recent export date have been issued trade waste broker's registrations by the Business Integrity Commission. They are authorized to broker agreements between business customers and trade waste removal
companies and/or to conduct evaluations of the customers' waste stream in order to recommend cost efficient means of waste disposal or other changes.

This data is collected on the entities that apply with the commission to operate as Class 2 Brokers

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 'CL2-Broker' noting the type of applicant which is a Broker Registrant They are authorized to broker agreements between business customers and trade waste removal companies throughout the city.

The BIC Number field is unique to every company that applies to the Commission.
Organization: City of New York
Last updated: 2020-11-10T17:03:59.509053
Tags: bic, brokers, cl2-broker, nycbic, registrant, trade-waste, trade-waste-broker

Tables

Table 1

@usgov.city_of_new_york_trade_waste_broker_registrants.table_1

1.28 MB
191,069 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
);