From a 500-row sample across 10 columns.
| id | vendorname | route | runtype | type | reason | delay | schools | school_reported | dateoccured |
|---|---|---|---|---|---|---|---|---|---|
| 322425 | PRIDE TRANSPORTATION (SCH AGE) | k206 | PM Run | Running Late | Other | 61-90 Min | 21735 | false | 2021-01-06 |
| 322429 | LORINDA ENTERPRISES, LTD. | l693 | AM Run | Breakdown | Won`t Start |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
id | integer | — | 0% | 327114340709327553 |
vendorname | text | — | 0% | LEESEL TRANSPORTATION CO…RELIANT TRANSPORTATION, …HOYT TRANSPORTATION CORP… |
route | text | — | 0% | n362l638n154 |
runtype | categorical | — | 2% | AM RunPM RunField Tripof 3 |
type |
GET /api/datasets/c6ph-pcpz GET /api/datasets/c6ph-pcpz/quality GET /api/datasets/c6ph-pcpz/related GET /api/columns?dataset=c6ph-pcpz
| — |
| 19020 |
| false |
| 2021-01-06 |
| 322429 | LORINDA ENTERPRISES, LTD. | l693 | AM Run | Breakdown | Won`t Start | — | 19279 | false | 2021-01-06 |
| 322429 | LORINDA ENTERPRISES, LTD. | l693 | AM Run | Breakdown | Won`t Start | — | 19551 | false | 2021-01-06 |
| 322433 | LITTLE RICHIE BUS SERVICE | q600 | PM Run | Breakdown | Won`t Start | — | 24007 | false | 2021-01-06 |
| 322433 | LITTLE RICHIE BUS SERVICE | q600 | PM Run | Breakdown | Won`t Start | — | 24409 | false | 2021-01-06 |
| 322449 | LEESEL TRANSPORTATION CORP (B2192) | n119 | AM Run | Running Late | Heavy Traffic | 46-60 Min | 05079 | false | 2021-01-06 |
| 322449 | LEESEL TRANSPORTATION CORP (B2192) | n119 | AM Run | Running Late | Heavy Traffic | 46-60 Min | 05133 | false | 2021-01-06 |
| 322449 | LEESEL TRANSPORTATION CORP (B2192) | n119 | AM Run | Running Late | Heavy Traffic | 46-60 Min | 05440 | false | 2021-01-06 |
| 322451 | LITTLE RICHIE BUS SERVICE | q601 | AM Run | Running Late | Heavy Traffic | 31-45 Min | 24409 | false | 2021-01-06 |
| categorical |
| — |
| 0% |
Running LateBreakdownof 2 |
reason | categorical | — | 0% | Heavy TrafficOtherMechanical Problemof 10 |
delay | categorical | — | 9% | 31-45 Min46-60 Min16-30 Minof 5 |
schools | text | — | 0% | 029090483901616 |
school_reported | boolean | — | 0% | FalseTrueof 2 |
dateoccured | date | — | 0% | 2021-06-102021-04-272021-04-12 |