Dataset: New York City Bus Breakdown And Delays

About this Dataset

New York City Bus Breakdown And Delays

The Bus Breakdown and Delay system collects information from school bus vendors operating out in the field in real time. Bus staff that encounter delays during the route are instructed to radio the dispatcher at the bus vendor’s central office. The bus vendor staff are then instructed to log into the Bus Breakdown and Delay system to record the event and notify OPT. OPT customer service agents use this system to inform parents who call with questions regarding bus service. The Bus Breakdown and Delay system is publicly accessible and contains real time updates. All information in the system is entered by school bus vendor staff.

Tables

Bus Breakdowns Delays

@kaggle.mattop_new_york_city_bus_breakdown_and_delays.bus_breakdowns_delays

19.42 MB
545691 rows
21 columns


CREATE TABLE bus_breakdowns_delays (
  "school_year" VARCHAR,
  "busbreakdown_id" BIGINT,
  "run_type" VARCHAR,
  "bus_no" VARCHAR,
  "route_number" VARCHAR,
  "reason" VARCHAR,
  "schools_serviced" VARCHAR,
  "occurred_on" VARCHAR,
  "created_on" VARCHAR,
  "boro" VARCHAR,
  "bus_company_name" VARCHAR,
  "how_long_delayed" VARCHAR,
  "number_of_students_on_the_bus" BIGINT,
  "has_contractor_notified_schools" VARCHAR,
  "has_contractor_notified_parents" VARCHAR,
  "have_you_alerted_opt" VARCHAR,
  "informed_on" VARCHAR,
  "incident_number" VARCHAR,
  "last_updated_on" VARCHAR,
  "breakdown_or_running_late" VARCHAR,
  "school_age_or_prek" VARCHAR
);