From a 500-row sample across 20 columns.
Has borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| school_year | busbreakdown_id | run_type | bus_no | route_number | reason | schools_serviced | occurred_on | created_on | boro | bus_company_name | number_of_students_on_the_bus |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015-2016 | 1272996 | Special Ed AM Run | 2256 | K355 | Won`t Start | 15879 | 2016-06-03T06:03:00.000 | 2016-06-03T06:05:00.000 | Brooklyn | RELIANT TRANS, INC. (B232 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
school_year | text | Indicates the school year the record refers to. The DOE school year starts in September every year. | 0% | 2018-20192022-20232025-2026 |
busbreakdown_id | integer | Unique ID of each record. | 0% | 780852780853780854 |
run_type | categorical | Designates whether a breakdown or delay occurred on a specific category of busing service. The categories are: • General Ed AM Run - stop-to-school service in the morning with pick-ups at bus stops and drops-offs at school(s). • General Ed PM Run - stop-to-school service in the afternoon with pick-ups at school(s) and drop-offs at bus stops. • General Ed Field Trip - refers to any mid-day bus trip that does not involve at least one student with an IEP for busing. For OPT, the term "field trip" | 0% | Special Ed AM RunSpecial Ed PM RunGeneral Ed AM Runof 10 |
GET /api/datasets/ez4e-fazm GET /api/datasets/ez4e-fazm/quality GET /api/datasets/ez4e-fazm/related GET /api/columns?dataset=ez4e-fazm
| 2016-2017 |
| 1313907 |
| Special Ed AM Run |
| 4481 |
| K002 |
| Won`t Start |
| 22001 |
| 2017-01-10T05:55:00.000 |
| 2017-01-10T05:57:00.000 |
| Brooklyn |
| NEW DAWN TRANSIT, LLC (B2 |
| 0 |
| 2015-2016 | 1267391 | Special Ed AM Run | GT2114 | Y925 | Won`t Start | 11012 | 2016-05-11T05:50:00.000 | 2016-05-11T05:59:00.000 | Bronx | DON THOMAS BUSES, INC. (B | 0 |
| 2016-2017 | 1312240 | General Ed AM Run | 2436 | K1546 | Other | 15032 | 2017-01-05T06:00:00.000 | 2017-01-05T06:05:00.000 | Brooklyn | ALL AMERICAN SCHOOL BUS C | 0 |
| 2016-2017 | 1312351 | Special Ed AM Run | 5814D | X441 | Mechanical Problem | 11002 | 2017-01-05T06:45:00.000 | 2017-01-05T06:54:00.000 | Bronx | LITTLE LISA BUS CO. INC. | 0 |
| 2016-2017 | 1320379 | Special Ed PM Run | 8802D | X565 | Flat Tire | 11458 | 2017-02-01T14:17:00.000 | 2017-02-01T14:24:00.000 | Bronx | LITTLE RICHIE BUS SERVICE | 0 |
| 2016-2017 | 1329633 | General Ed AM Run | 2320 | X2355 | Mechanical Problem | 11006 | 2017-03-15T05:54:00.000 | 2017-03-15T05:59:00.000 | Bronx | GRANDPA`S BUS CO., INC. | 0 |
| 2016-2017 | 1339561 | Pre-K/EI | AA1 | AA2 | Flat Tire | S223 | 2017-04-12T14:00:00.000 | 2017-04-12T14:14:00.000 | Queens | PENNY TRANSPORTATION | 4 |
| 2016-2017 | 1321074 | Special Ed AM Run | GT 1479 | Y749 | Mechanical Problem | 11688 | 2017-02-06T06:01:00.000 | 2017-02-06T06:02:00.000 | — | DON THOMAS BUSES, INC. (B | 0 |
| 2016-2017 | 1344219 | General Ed AM Run | 8008 | K8423 | Accident | 19108 | 2017-05-02T06:04:00.000 | 2017-05-02T06:04:00.000 | Brooklyn | QUALITY TRANSPORTATION CO | 0 |
Showing 12 of 20 columns. All of them are listed below.
bus_no |
| text |
| The bus number is assigned by the bus vendor. The numbers are not unique identifiers and may be repeated across vendors. For example, many bus vendors may have a Bus #1. Each bus vendor may have their own numbering convention. |
| 0% |
0000/1801 |
route_number | text | This refers to the unique identifier four (1 alpha + 3 numeric) character route numbers indicate curb-to-curb service while five (1 alpha + 4 numeric) indicates stop-to-school service. Pre-K/EI routes may have any value in the Route Number field; bus vendors are not required to follow any naming convention for those routes. | 0% | 123 |
reason | categorical | Reason for delay as entered by staff employed by reporting bus vendor. User chooses from the following categories: • Accident - to be selected if any accident that delays the bus is recorded. The bus can be delayed by an accident that the bus itself is not actually involved in. • Delayed by School - to be selected by reporting bus vendors when schools have delays ushering students to or from the bus. • Flat Tire - to be selected by reporting bus vendors for any flat tire that requires the bus t | 11% | Heavy TrafficOtherMechanical Problemof 10 |
schools_serviced | text | OPT Codes of all transportation sites on the route. If there is more than one site, each site code will be separated by a comma. If the incident occurred on a bus used for Pre-K/EI service, the code will have one alpha, three numeric and sometimes one additional alpha character. If the incident occurred on a bus used for school-aged service, the code will have five text formatted numerals and may include a leading zero. | 0% | 120840293075907 |
occurred_on | datetime | Time/date the incident occurred, as entered by the staff employed by the reporting bus vendor | 0% | 2010-05-03T07:30:00.0002010-09-13T06:00:00.0002010-09-08T06:00:00.000 |
created_on | datetime | Time/date the record was created in the OPT Breakdown and Delay system. | 0% | 2010-09-15T06:00:00.0002010-05-03T09:12:00.0002017-10-31T06:48:00.000 |
boro | categorical | Borough, county or state in which the delay occurred, as entered by the staff employed by the reporting bus vendor. | 2% | BrooklynBronxManhattanof 12 |
bus_company_name | text | Bus vendor name of the reporting bus vendor. | 0% | AMBOY BUS COMPANY, INCLEESEL TRANSPORTATION CO…PRIDE TRANSPORTATION (SC… |
how_long_delayed | text | Length of delay as estimated by the staff employed by the reporting bus vendor. OPT does not systematically monitor the contents of this field in real time. | 14% | 16-30 Min31-45 Min46-60 Min |
number_of_students_on_the_bus | integer | Number of students on the bus at the time of the incident as estimated by the staff employed by the reporting bus vendor. OPT does not systematically monitor the contents of this field in real time. | 0% | 021 |
has_contractor_notified_schools | categorical | Indicator status as reported by the staff employed by the reporting bus vendor. OPT does not systematically monitor the contents of this field in real time. | 0% | YesNoof 2 |
has_contractor_notified_parents | categorical | Indicator status as reported by the staff employed by the reporting bus vendor. OPT does not systematically monitor the contents of this field in real time. | 0% | YesNoof 2 |
have_you_alerted_opt | categorical | Indicator status as reported by the staff employed by the reporting bus vendor. OPT does not systematically monitor the contents of this field in real time. | 0% | NoYesof 2 |
informed_on | datetime | Date on which the school, parents or OPT was notified, as reported by the bus vendor. | 0% | 2010-09-15T06:00:00.0002010-05-03T09:12:00.0002017-10-31T06:48:00.000 |
incident_number | text | Some reports of bus breakdowns or delays originate from calls to the OPT Customer Service line who records incidents. When this happens, the record will have the Incident reference number. | 99% | NAXx |
last_updated_on | datetime | Time/date the record was last edited in the OPT Breakdown and Delay system. | 0% | 1900-01-01T00:00:00.0002019-04-26T11:49:12.0002019-04-26T11:49:11.000 |
breakdown_or_running_late | categorical | Indicator status as reported by the staff employed by the reporting bus vendor. OPT does not edit this field. Designates whether a bus has broken down (and requires another vehicle to be dispatched to finish the route) or is delayed (and may not require another vehicle). | 0% | Running LateBreakdownof 2 |
school_age_or_prek | categorical | Indicator of whether the route serves the school-age or Pre-K/EI population. These two busing types have very different contract terms. OPT does not perform route planning for Pre-K service and doesn't assign route numbers. | 0% | School-AgePre-Kof 2 |