From a 500-row sample across 3 columns.
route_numberschool_year| school_year | route_number | opt_code |
|---|---|---|
| 2015-2016 | J698 | 75004 |
| 2015-2016 | J699 | 75580 |
| 2015-2016 | J700 | 75003 |
| 2015-2016 | J700 | 75140 |
| 2015-2016 | J701 | 75003 |
| 2015-2016 | J701 | 75140 |
| 2015-2016 | J702 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
school_year | categorical | Indicates the school year the record refers to. The DOE school year starts in September every year. | 0% | 2018-20192017-20182016-2017of 7 |
route_number | text | Either four (1 alpha + 3 numeric) or five (1 alpha + 4 numeric) character unique route ID that represent a contracted service with a school bus or ambulance vendor. In this table, Route Number is not unique if the route serves more than one school. | 0% | Q9000Q8000M9000 |
opt_code | text | The unique ID for a location receiving any transportation service from OPT. Transportation service may include busing, ambulance or MetroCard shipments for distribution amongst eligible recipients. An OPT Code represents an organization in a specific location; it is possible to have more than one OPT Code associated with the same location, but there are no instances of a single OPT Code being in multiple locations. In this table, OPT Code is not unique if the transportation site is served by mo | 0% |
GET /api/datasets/fgqh-vfzz GET /api/datasets/fgqh-vfzz/quality GET /api/datasets/fgqh-vfzz/related GET /api/columns?dataset=fgqh-vfzz
| 75003 |
| 2015-2016 | J702 | 75140 |
| 2015-2016 | J703 | 75003 |
| 2015-2016 | J703 | 75140 |
302273100712084