About this Dataset

BIC Issued Violations

BIC issued violations dataset includes violations issued by Business Integrity Commission for companies operating in the trade waste industry.

Business Integrity Commission maintains this dataset, updating it quarterly. Each row of data contains information about a violation issued by BIC to an approved or unlicensed company in the trade waste industry. These violations are adjudicated within the Office of Administrative Trials and Hearings (OATH).
Organization: City of New York
Last updated: 2020-11-10T17:05:38.625364

Tables

Table 1

@usgov.city_of_new_york_bic_issued_violations.table_1

876.67 KB
15449 rows
31 columns


CREATE TABLE table_1 (
  "violation_number" VARCHAR,
  "bic_number" DOUBLE,
  "account_name" VARCHAR,
  "type_of_violation" VARCHAR,
  "violation_phase" VARCHAR,
  "violation_disposition" VARCHAR,
  "account_type" VARCHAR,
  "violation_account_address" VARCHAR,
  "violation_account_city" VARCHAR,
  "violation_account_state" VARCHAR,
  "violation_account_postcode" VARCHAR,
  "borough_of_violation" VARCHAR,
  "date_of_violation" TIMESTAMP,
  "date_violation_issued" TIMESTAMP,
  "maximum_fine" DOUBLE,
  "fine_amount" DOUBLE,
  "date_fine_paid" TIMESTAMP,
  "early_settlement_violation" BOOLEAN,
  "settlement_date" TIMESTAMP,
  "rule_code" VARCHAR,
  "number_of_counts" BIGINT,
  "description_of_rule" VARCHAR,
  "export_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);