About this Dataset

Vision Zero Base Report

The Vision Zero Base Reports are collections of facts and statistics about individual TLC-regulated for-hire vehicle (FHV) businesses produced to help passengers identify businesses with the best safety records and support the for-hire industry’s efforts to achieve the highest levels of safety and service. Find definitions for the metrics used and more information on the reports here - http://www.nyc.gov/html/tlc/html/industry/vision_zero_base_reports.shtml
Organization: City of New York
Last updated: 2020-11-10T17:04:34.726394

Tables

Table 1

@usgov.city_of_new_york_vision_zero_base_report.table_1

154.75 kB
771 rows
50 columns

CREATE TABLE table_1 (
  "download_pdf_report" VARCHAR,
  "license_number" VARCHAR,
  "industry_sector" VARCHAR,
  "base_does_business_as" VARCHAR,
  "base_name" VARCHAR,
  "serving_areas" VARCHAR,
  "year_base_opened" DOUBLE,
  "green_taxi_service" VARCHAR,
  "on_demand_service" VARCHAR,
  "book_ahead_service" VARCHAR,
  "phone" VARCHAR,
  "website" VARCHAR,
  "email" VARCHAR,
  "booking_app" VARCHAR,
  "n_24_hours" VARCHAR  -- 24 HOURS,
  "n_2015_honor_roll_drivers" DOUBLE  -- 2015 HONOR ROLL DRIVERS,
  "n_2015_honor_roll_base" VARCHAR  -- 2015 HONOR ROLL BASE,
  "hosted_vision_zero_training" VARCHAR,
  "vehicle_safety_technology_used" VARCHAR,
  "base_provides_safety_training" VARCHAR,
  "fatal_crashes" DOUBLE,
  "fatal_crash_details" VARCHAR,
  "injury_crashes_per_vehicle" DOUBLE,
  "sector_average_injury_crashes_per_vehicle" DOUBLE  -- SECTOR AVERAGE - INJURY CRASHES PER VEHICLE,
  "vehicle_safety_violations_per_vehicle" DOUBLE,
  "sector_average_vehicle_safety_violations_per_vehicle" DOUBLE  -- SECTOR AVERAGE - VEHICLE SAFETY VIOLATIONS PER VEHICLE,
  "base_safety_violations_per_vehicle" DOUBLE,
  "sector_average_base_safety_violations_per_vehicle" DOUBLE  -- SECTOR AVERAGE -BASE SAFETY VIOLATIONS PER VEHICLE,
  "affiliated_vehicles" DOUBLE,
  "average_vehicle_age" DOUBLE,
  "sector_average_average_vehicle_age" DOUBLE  -- SECTOR AVERAGE - AVERAGE VEHICLE AGE,
  "percent_hybrid_alt_fuel_vehicles" DOUBLE  -- PERCENT HYBRID & ALT-FUEL VEHICLES,
  "percent_wheelchair_accessible_vehicles" DOUBLE,
  "top_vehicle_models_1" VARCHAR  -- TOP VEHICLE MODELS - 1,
  "top_vehicle_models_2" VARCHAR  -- TOP VEHICLE MODELS - 2,
  "top_vehicle_models_3" VARCHAR  -- TOP VEHICLE MODELS - 3,
  "top_vehicle_models_4" VARCHAR  -- TOP VEHICLE MODELS - 4,
  "top_vehicle_models_5" VARCHAR  -- TOP VEHICLE MODELS - 5,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "postcode" DOUBLE,
  "borough" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);