About this Dataset

ITS4US HIRTA Health Connector Performance Evaluation Dataset

The attached file has trip level information for Health Connector rides taken from October 1, 2024 to January 31, 2025. Any information that could identify the rider has been stripped. Each row corresponds to one ride request.
Organization: Department of Transportation
Last updated: 2025-03-24T19:57:27.989442
Tags: intelligent-transportation-systems-its, its-joint-program-office-jpo, moe, ridership, transit, transport-to-medical-appointments, underserved-transportation

Tables

Table 1

@usgov.dot_gov_its4us_hirta_health_connector_performance_evaluation.table_1

30.47 kB
111 rows
32 columns

CREATE TABLE table_1 (
  "requestid" BIGINT,
  "status" VARCHAR,
  "driverid" DOUBLE,
  "vehicleid" DOUBLE,
  "wheelchairs" BIGINT,
  "rideshared" VARCHAR,
  "sharedduration" DOUBLE,
  "passengers" BIGINT,
  "booking" VARCHAR,
  "preference" VARCHAR,
  "month" VARCHAR,
  "requestedpickup" VARCHAR,
  "requesteddropoff" VARCHAR,
  "originalpickup" VARCHAR,
  "cancellationahead" VARCHAR,
  "cancellationsource" VARCHAR,
  "noshow" VARCHAR,
  "arrivaltime" VARCHAR,
  "pickuptime" VARCHAR,
  "dropofftime" VARCHAR,
  "ridedist" DOUBLE,
  "rideduration" DOUBLE,
  "directduration" DOUBLE,
  "lastpickup" VARCHAR,
  "lastdropoff" VARCHAR,
  "lastduration" DOUBLE,
  "rating" VARCHAR,
  "pickupstart" VARCHAR,
  "pickupend" VARCHAR,
  "vehiclepickup" VARCHAR,
  "vehicledropoff" VARCHAR,
  "pickupstatus" VARCHAR
);