About this Dataset

Pittsburgh Regional Transit Scheduled Trip Counts

This dataset lists Pittsburgh Regional Transit scheduled bus and rail trip counts and distances since November 2016.

For convenience, this data is published in several formats:

Daily Scheduled Trips: Aggregated total trip count and trip distances for each route per day.
Monthly Scheduled Trips: Aggregated total trip count and trip distances for each route per month and day type (weekday, Saturday, and Sunday). This can be joined with the Monthly Ridership dataset on DateKey, Route, and DayType to normalize the average riders per trip.
Detailed Daily Scheduled Trips: This dataset lists the detailed daily schedule for each route, including the start and end times for each trip. This can be used to see the earliest and latest runs and study peak- and off-peak trip frequencies.

Port Authority makes quarterly schedule adjustments that include adding and removing trips on certain routes to better serve riders. These schedule adjustments are called "picks" and correspond to the year and month of the schedule change, e.g. the November 2016 pick is known as 1611.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2020-11-30T02:50:16.166978
Tags: bus, picks, public-transit, rail, schedules, timetable, transit, transportation, trip-count, trip-distance, trips

Tables

Detailed Daily Scheduled Trips

@usgov.allegheny_county_city_of_pitts_port_authority_schedule_35a3937a.detailed_daily_scheduled_trips

3 MB
286,887 rows
24 columns

CREATE TABLE detailed_daily_scheduled_trips (
  "service_context" VARCHAR,
  "schedule_type" VARCHAR,
  "booking" BIGINT,
  "number_of_insrv_trip_s" BIGINT  -- Number.of.InSrv.Trip.s.,
  "garage" BIGINT,
  "route" VARCHAR,
  "trip_start" VARCHAR,
  "trip_end" VARCHAR,
  "trip_block" VARCHAR,
  "trp_off_serv_duration" DOUBLE,
  "trp_in_serv_duration" DOUBLE,
  "trp_layover_duration" DOUBLE,
  "trp_total_duration" DOUBLE,
  "trp_in_serv_dist" DOUBLE  -- Trp.In.Serv.Dist.,
  "trp_off_serv_dist" DOUBLE  -- Trp.Off.Serv.Dist.,
  "trp_dist" DOUBLE  -- Trp.Dist.,
  "speed_inbound" VARCHAR,
  "speed_outbound" VARCHAR,
  "trip_variant" VARCHAR,
  "trip_is_pull_out" VARCHAR,
  "trip_is_pull_in" VARCHAR,
  "trip" BIGINT  -- Trip..,
  "internal_trip" BIGINT  -- Internal.Trip..,
  "day_type" VARCHAR
);

Monthly Scheduled Trips

@usgov.allegheny_county_city_of_pitts_port_authority_schedule_35a3937a.monthly_scheduled_trips

42.56 kB
16,342 rows
10 columns

CREATE TABLE monthly_scheduled_trips (
  "pickid" VARCHAR,
  "datekey" BIGINT,
  "route" VARCHAR,
  "routecode" VARCHAR,
  "daily_trip_dist" DOUBLE,
  "daily_trip_count" BIGINT,
  "day_type_join" VARCHAR,
  "route_full_name" VARCHAR,
  "current_garage" VARCHAR,
  "mode" VARCHAR
);