Data Dictionary

Column Type Label Description
route text

"Friendly" route code that joins with PAAC geospatial data.

ridership_route_code text

Route code for joining with ridership data.

route_full_name text

Full route name as it would appear on the headsign of the bus/light rail vehicle.

current_garage text

The garage that the bus route operates out of. Route 64 alternates between East Liberty and West Mifflin garage; its total ridership is averaged in this dataset.

mode text

Transit mode: bus, light rail (the T), or incline.

month_start date

The first day of the month in YYYY-MM-DD format.

year_month text

The year-month key in YYYYMM format.

day_type text

Weekday, Saturday, or Sunday/Holiday service. PAAC routes and schedules vary based on the service day. PAAC provides Sunday service on the following holidays: New Years Day, Memorial Day, Fourth of July, Labor Day, Thanksgiving, and Christmas.

avg_riders float8

The average daily riders for that month, day type, and route.

day_count int4

The number of days for each day_type in the month. Certain holidays are considered Sundays. Riders can be multiplied by day_count to estimate the monthly total riders.

Additional Information

Field Value
Data last updated November 5, 2024
Metadata last updated November 5, 2024
Created October 30, 2019
Format CSV
License Creative Commons Attribution
Datastore activeTrue
Has viewsTrue
Id12bb84ed-397e-435c-8d1b-8ce543108698
Mimetypetext/csv
Package ide6c089da-43d1-439b-92fc-e500d6fb5e73
Position0
Revision id79ff7849-19ff-4705-ad0a-a6481d99f8d2
Size636.4 KiB
Stateactive
Url typedatapusher