CASSI At UNC Charlotte Usage by US Government | Demographics and Population Studies

About this Dataset

CASSI At UNC Charlotte Usage

Beep, Inc. provided weekly data reports to the University of North Carolina at Charlotte (UNC Charlotte) and the North Carolina Department of Transportation (NCDOT) that included ridership and operations data.

This dataset is compiled from Beep, Inc.’s reports for the 23-week pilot period and includes ridership as number of passengers, number of trips, ramp deployments and wheelchair securements, scheduled hours and hours operated, uptime percentage, battery percentage, service suspensions, vehicle speed, and time in autonomous mode.

NCDOT partnered with UNC Charlotte to bring the Connected Autonomous Shuttle Supporting Innovation (CASSI) program to the campus. Please see NCDOT's CASSI webpage for additional information about the program.

Please look to the CASSI_NCDOT_UNC_Charlotte_Open_Data_Portal_Documentation_20240712.pdf file in the Attachments section below for a record of all data cleaning and quality control practices conducted and to the Dataset Schema section for descriptions of the columns present.
Organization: Town of Cary, North Carolina
Last updated: 2024-07-20T20:33:24.396998
Tags: beep, cassi

Tables

Table 1

@usgov.town_of_cary_north_carolina_cassi_at_unc_charlotte_usage.table_1

26.48 KB
117 rows
24 columns


CREATE TABLE table_1 (
  "entry_order" BIGINT,
  "date" TIMESTAMP,
  "day_of_week" VARCHAR,
  "day_of_week_as_number" BIGINT,
  "week_of_year" BIGINT,
  "number_of_weeks_into_pilot" BIGINT,
  "number_of_round_trips_completed" BIGINT,
  "number_of_passengers" BIGINT,
  "number_of_ramp_deployments" BIGINT,
  "number_of_wheelchair_securements" BIGINT,
  "number_of_scheduled_hours" DOUBLE,
  "number_of_hours_operated" DOUBLE,
  "uptime_percentage" DOUBLE,
  "shuttle_id" VARCHAR,
  "starting_battery_percentage" DOUBLE,
  "ending_battery_percentage" DOUBLE,
  "battery_percentage_used" DOUBLE,
  "suspension_of_service_details" VARCHAR,
  "average_vehicle_speed" DOUBLE,
  "maximum_vehicle_speed" DOUBLE,
  "autonomous_mode_percentage" DOUBLE,
  "number_of_passengers_per_hour_operated" DOUBLE,
  "number_of_passengers_per_round_trip" DOUBLE,
  "number_of_round_trips_per_hour_operated" DOUBLE
);