ridership.csv

This file associates students defined in students.csv to the stops defined in stops.csv, and to the routes defined in routes.csv.

Fields

Student id as per students.csv.

Stop id as per stops.csv.

Route id as per routes.csv.

"yes" if the student will be dropped off at this stop. “no” or left blank if the student will be picked up at this stop.

student_id,stop_id,route_id,is_dropoff

309123,S1,B1,no

309124,S1,B2,no

309125,S2,B2,no

309123,S3,B3,yes

309124,S3,B3,yes

309125,S3,B3,yes

Related Articles
students.csv
This file contains student demographic data, such as name, address, and phone number. Bus pass (RFID tag, fob, etc.) numbers will also be contained in this file. Fields id Unique ID for the student. Used to provide associated events (e.g. ridership ...
fobs.csv
This file associates each student defined in students.csv with the number of his or her fob or other bus pass. Fields student_id student id as per students.csv. fob_number The number associated with the fob or other bus pass. Example CSV ...
tags.csv
This file associates tags to students, guardians, routes, stops, buses, or schools. Tags can be any sequence of characters, including emojis. Fields category The name of the category this tag will apply to. Has to be one of student, guardian, route, ...
stops.csv
This file contains all stops for all routes in the system. Each row is a stop. Stops can be used on multiple routes, so each stop should only have one row in this file. If no latitude or longitude are provided, the system will attempt to resolve the ...
guardians.csv
This file contains guardians for the students. Each row is a guardian. Required fields are id, name, and at least one form of contact information. "Children" is not a required field -- this is to accommodate special situations -- but normally each ...