Data Dictionary

Kolumna Typ Label Opis
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.

Dodatkowe informacje

Pole Wartość
Data last updated 5 listopada 2024
Metadata last updated 5 listopada 2024
Created 30 października 2019
Format CSV
Licencja 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