Data Table Schemas ¶

Data table schemas are specified in JSON and are compatible with the frictionless data table schema standards.

Event Tables ¶

Fare Transactions ¶

fare_transactions.schema.json

Timestamped fare transaction, associated with devices.

Primary key: {transaction_id}

Passenger Events ¶

passenger_events.schema.json

Timestamped passenger-related events, including boardings and alightings.

Primary key: {passenger_event_id}

Vehicle Locations ¶

vehicle_locations.schema.json

Timestamped vehicle locations and speeds.

Primary key: {location_ping_id}

Summary Tables ¶

Station Activities ¶

station_activities.schema.json

Summarized transactions, entries, and exits by stop or station and time period for each service date (for events not associated with a trip).

Primary key: {stop_id, time_period_end, time_period_start, service_date}

Stop Visits ¶

stop_visits.schema.json

Summarized boarding, alighting, arrival, departure, and other events (kneel engaged, ramp deployed, etc.) by trip and stop for each service date.

Primary key: {trip_stop_sequence, trip_id_performed, service_date}

Trips Performed ¶

trips_performed.schema.json

Trips performed for each service date.

Primary key: {trip_id_performed, service_date}

Supporting Tables ¶

Devices ¶

devices.schema.json

Measurement devices, such as AVL, APC, and AFC devices, associated with vehicles or stops or stations.

Primary key: {device_id}

Operators ¶

operators.schema.json

Personnel who operate vehicles.

Primary key: {operator_id}

Train Cars ¶

train_cars.schema.json

Assets that comprise vehicles, such as train cars, with descriptive information.

Primary key: {train_car_id}

Vehicle Train Cars ¶

vehicle_train_cars.schema.json

Relationships between assets and vehicles.

Primary key: {train_car_id, vehicle_id}

Vehicles ¶

vehicles.schema.json

Vehicles, including buses and train consists, with descriptive information.

Primary key: {vehicle_id}