# Metlink bus performance measure CSV documentation

This file is documentation for the daily and weekly bus performance measure
CSV files published by Metlink, available from the
[Metlink website](https://www.metlink.org.nz/about-us/performance-of-our-network).

These CSV files are intended for use by people with data science or programming
experience, and contain the same data in the pivoted and formatted Excel files,
but structured as machine readable long form / "tidy" files.

In the column definitions below, "peak times" is defined as between 6:30–9:00am
and 3:00–6:00pm on non-public holiday weekdays.

## Columns

### day
*Date*
YYYY-MM-DD formatted date. Present only in daily file.

### week
*Date*
YYYY-MM-DD formatted date. Present only in weekly file.

### route
*String*
Route number. Note that while most routes are numeric, some have letter
suffixes (e.g. 12e, 32x) or are only letters (e.g. AX, HX), therefore this
column should be parsed as a string.

### scheduled_trips
*Integer*
Number of scheduled trips.

### reliability_numerator
*Integer*
Number of scheduled trips that were sighted as being run by any of the
Snapper ticketing system, the Real Time Information system, or the On Bus
Announcement system.

### reliability_denominator
*Integer*
Number of scheduled trips.

### reliability
*Float*
reliability_numerator divided by reliability_denominator.

### punctuality_numerator
*Integer*
Number of scheduled trips which were sighted by the Real Time
Information system departing the first stop less than 1m 15s early or 5m 15s
late.

### punctuality_denominator
*Integer*
Number of scheduled trips which were sighted by the Real Time
Information at the first stop.

### punctuality
*Float*
punctuality_numerator divided by puncutality_denominator.

### punctuality_contributing_percent
*Float*
punctuality_denominator divided by scheduled_trips, i.e. the percentage
of scheduled trips which were sighted at first stop and therefore contribute to
the punctuality measure.

### mean_departure_time_variance
*Float*
The mean of the difference in seconds between the scheduled departure
time from first stop and the sighted time from the Real Time Information system,
for trips that were sighted by RTI at first stop.

### cancellations
*Integer*
Number of scheduled trips which the operator has cancelled and did not
run. An operator may cancel only part of a trip, which are included here as a
cancellation, or cancel and then reinstate a trip, which are not included.

### cancellations_rate
*Float*
cancellations divided by scheduled_trips.

### seated_capacity
*Integer*
The sum of the number of seats onboard vehicles operating scheduled
trips, where the vehicle is known.

### license_capacity
*Integer*
The sum of the total number of passengers a vehicle is licensed to
carry (i.e. seating + standing) for vehicles operating scheduled trips, where
the vehicle is known.

### trips_with_some_standing
*Integer*
The number of trips where at any point during the trip, the number of
people onboard as reported by the Snapper ticketing system was greater than the
seated_capacity of the vehicle operating the trip.

### trips_with_some_standing_rate
*Float*
trips_with_some_standing divided by scheduled_trips

### peak_scheduled_trips
*Integer*
Same as scheduled_trips but for trips which scheduled start time is at
peak times.

### peak_reliability_numerator
*Integer*
Same as reliability_numerator but for trips which scheduled start time
is at peak times.

### peak_reliability_denominator
*Integer*
Same as reliability_denominator but for trips which scheduled start
time is at peak times.

### peak_reliability
*Float*
Same as reliability but for trips which scheduled start time is at peak
times.

### peak_punctuality_numerator
*Integer*
Same as punctuality_numerator but for trips which scheduled start time
is at peak times.

### peak_punctuality_denominator
*Integer*
Same as punctuality_denominator but for trips which scheduled start
time is at peak times.

### peak_punctuality
*Float*
Same as punctuality but for trips which scheduled start time is at peak
times.

### peak_punctuality_contributing_percent
*Float*
Same as punctuality_contributing_percent but for trips which scheduled
start time is at peak times.

### peak_mean_departure_time_variance
*Float*
Same as mean_departure_time_variance but for trips which scheduled start
time is at peak times.

### peak_cancellations
*Integer*
Same as cancellations but for trips which scheduled start time is at
peak times.

### peak_cancellations_rate
*Float*
Same as cancellations_rate but for trips which scheduled start time is
at peak times.

### peak_seated_capacity
*Integer*
Same as seated_capacity but for trips which scheduled start time is at
peak times.

### peak_license_capacity
*Integer*
Same as license_capacity but for trips which scheduled start time is
at peak times.

### peak_trips_with_some_standing
*Integer*
Same as trips_with_some_standing but for trips which scheduled start
time is at peak times.

### peak_trips_with_some_standing_rate
*Float*
Same as trips_with_some_standing_rate but for trips which scheduled
start time is at peak times.

### patronage
*Integer*
Number of boardings recorded through the Snapper ticketing system.

### peak_patronage
*Integer*
Number of boardings recorded through the Snapper ticketing system
where the boarding occurred at peak times. Note this is slightly different to
the other peak measures, where each trip is defined as peak or not based on its
scheduled start time.

### offpeak_patronage
*Integer*
Number of boardings recorded through the Snapper ticketing system
where the boarding occurred not at peak times.

### offpeak_patronage_percent
*Float*
off_peak_patronage divided by patronage.