About this Dataset

Licensees And Registrants Fleet Information

Licensees and Registrants Fleet Information dataset contains information about active vehicles of approved BIC licensees and registrants. This data is partially collected from the application submitted to the commission by licensees and registrants. The majority of data points are collected from licensees and registrants via the Vehicle Management Portal. Business Integrity Commission maintains this dataset, updating it quarterly. Each row of data contains information about an active vehicle registered at BIC, including BIC plate number, vehicle year, vehicle model, vehicle make, engine year and so on.
Organization: City of New York
Last updated: 2020-11-10T17:04:21.474207

Tables

Table 1

@usgov.city_of_new_york_licensees_and_registrants_fleet_information.table_1

179.24 kB
7,072 rows
18 columns

CREATE TABLE table_1 (
  "account_name" VARCHAR,
  "active" BOOLEAN,
  "vehicle_information_complete" BOOLEAN,
  "bic_number" VARCHAR,
  "bic_plate_number" VARCHAR,
  "vehicle_body_type" VARCHAR,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "vehicle_year" DOUBLE,
  "vehicle_engine_make" VARCHAR,
  "vehicle_engine_horsepower" DOUBLE,
  "vehicle_fuel_type" VARCHAR,
  "vehicle_gross_vehicle_weight" VARCHAR,
  "vehicle_gross_vehicle_weight_rating_gvwr" VARCHAR  -- VEHICLE GROSS VEHICLE WEIGHT RATING (GVWR),
  "vehicle_has_side_guard" VARCHAR,
  "vehicle_ownership_type" VARCHAR,
  "vehicle_annual_miles_traveled_in_last_year" DOUBLE,
  "export_date" TIMESTAMP
);