About this Dataset

BIC Complaints Inquiries

BIC Complaints Inquiries dataset contains information on all waste hauling complaints/inquiries BIC received. Each row of data contains information about a complaint or inquiry, including source of complaint/inquiry, nature of complaint/inquiry, company name, geographic location, total response time, and complaint/inquiry disposition.

Business Integrity Commission maintains this dataset (Trade Waste Enforcement Unit), updating it quarterly.
Organization: City of New York
Last updated: 2020-11-10T17:04:29.644452

Tables

Table 1

@usgov.city_of_new_york_bic_complaints_inquiries.table_1

753.47 KB
18531 rows
42 columns


CREATE TABLE table_1 (
  "complaint_inquiry_number" VARCHAR,
  "license_type" VARCHAR,
  "account_name" VARCHAR,
  "bic_number" VARCHAR,
  "date_complaint_inquiry_reported_on" TIMESTAMP,
  "industry_type" VARCHAR,
  "account_status" VARCHAR,
  "source_of_complaint_inquiry" VARCHAR,
  "complaint_inquiry_disposition" VARCHAR,
  "complaint_inquiry_status" VARCHAR,
  "total_response_time" DOUBLE,
  "complaint_or_inquiry" VARCHAR,
  "nature_of_complaint_inquiry" VARCHAR,
  "complaint_inquiry_street_address" VARCHAR,
  "complaint_inquiry_city" VARCHAR,
  "complaint_inquiry_state" VARCHAR,
  "complaint_inquiry_zip" VARCHAR,
  "complaint_inquiry_borough" VARCHAR,
  "account_focus_of_complaint_inquiry" VARCHAR,
  "account_address" VARCHAR,
  "account_city" VARCHAR,
  "account_state" VARCHAR,
  "account_zip" VARCHAR,
  "account_phone" VARCHAR,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "vehicle_type" VARCHAR,
  "vehicle_year" VARCHAR,
  "vehicle_color" VARCHAR,
  "contacted_complainant" BOOLEAN,
  "unable_to_contact_complainant" BOOLEAN,
  "method_used_to_contact_complainant" VARCHAR,
  "export_date" TIMESTAMP,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitide" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);