From a 500-row sample across 31 columns.
_11_00_12_00pm_5_00_6_00am_6_00_7_00am+27directiondate| segmentid | roadway_name | from | to | direction | date | veh_class_type | _8_00_9_00pm | _9_00_10_00pm | _10_00_11_00pm | _11_00_12_00am | _12_00_1_00_am |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-29T00:00:00.000 | Auto | 58 | 61 | 42 | 17 | — |
| 152031 | 34 Avenue |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
segmentid | integer | LION Segment ID. Called "GIS ID" in the 2011-12 dataset, "Segment ID" in the 2012-13 dataset. | 0% | 507052113919874 |
roadway_name | text | Street name | 0% | BroadwayKings HwyJerome Ave |
from | text | Intersecting street name at one end of street | 0% | BroadwayGrand Concourse11th Ave |
to | text | Intersecting street name at other end of street | 0% | Park AveBroadwayGrand Concourse |
GET /api/datasets/96ay-ea4r GET /api/datasets/96ay-ea4r/quality GET /api/datasets/96ay-ea4r/related GET /api/columns?dataset=96ay-ea4r
| 113 Street |
| 114 Street |
| WB |
| 2014-10-29T00:00:00.000 |
| Taxis |
| 3 |
| 4 |
| 1 |
| 4 |
| — |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-29T00:00:00.000 | Commercial | 0 | 1 | 1 | 2 | — |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-29T00:00:00.000 | Medium Truck | 0 | 0 | 0 | 2 | — |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-29T00:00:00.000 | Heavy Truck | 0 | 0 | 0 | 0 | — |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-29T00:00:00.000 | School Bus | 0 | 0 | 0 | 0 | — |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-29T00:00:00.000 | Other Bus | 0 | 0 | 0 | 0 | — |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-30T00:00:00.000 | Auto | — | — | — | — | 19 |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-30T00:00:00.000 | Taxis | — | — | — | — | 2 |
| 152031 | 34 Avenue | 113 Street | 114 Street | WB | 2014-10-30T00:00:00.000 | Commercial | — | — | — | — | 0 |
Showing 12 of 31 columns. All of them are listed below.
direction |
| categorical |
| Compass direction |
| 0% |
NBSBEBof 5 |
date | datetime | Date of the traffic count | 0% | 2025-11-12T00:00:00.0002025-11-13T00:00:00.0002025-11-19T00:00:00.000 |
veh_class_type | categorical | Type of vehicle being counted | 0% | School BusHeavy TruckOther Busof 12 |
_12_00_1_00_am | integer | Count for the clock hour | 19% | 012 |
_1_00_2_00am | integer | — | 22% | 012 |
_2_00_3_00am | integer | — | 22% | 012 |
_3_00_4_00am | integer | — | 22% | 012 |
_4_00_5_00am | integer | — | 22% | 012 |
_5_00_6_00am | integer | — | 22% | 012 |
_6_00_7_00am | integer | — | 22% | 012 |
_7_00_8_00am | integer | — | 22% | 012 |
_8_00_9_00am | integer | — | 22% | 012 |
_9_00_10_00am | integer | — | 22% | 012 |
_10_00_11_00am | integer | — | 22% | 012 |
_11_00_12_00pm | integer | — | 22% | 012 |
_12_00_1_00pm | integer | — | 22% | 012 |
_1_00_2_00pm | integer | — | 22% | 012 |
_2_00_3_00pm | integer | — | 22% | 012 |
_3_00_4_00pm | integer | — | 22% | 012 |
_4_00_5_00pm | integer | — | 22% | 012 |
_5_00_6_00pm | integer | — | 22% | 012 |
_6_00_7_00pm | integer | — | 22% | 012 |
_7_00_8_00pm | integer | — | 22% | 012 |
_8_00_9_00pm | integer | — | 22% | 012 |
_9_00_10_00pm | integer | — | 22% | 012 |
_10_00_11_00pm | integer | — | 22% | 012 |
_11_00_12_00am | integer | — | 22% | 012 |