From a 500-row sample across 51 columns.
boroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| id | referencenumber | studyunit | externalreferencenumber | daterequested | statusdescription | studystatus | statusdate | borough | mainstreet | midblock | removal |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 18331 | CQ06-0393A | SE | CEQRNO.05-DCP-080Q | 2006-03-08T00:00:00.000 | Engineering Study Completed (Signals Engineering) | CLOSED | 2006-03-21T00:00:00.000 | Queens | SILVERCUP WEST | No | No |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
id | integer | — | 0% | 142135146337142591 |
referencenumber | text | — | 0% | CK16-1814CK18-3232CQ20-0012 |
studyunit | categorical | — | 0% | ICUSEof 2 |
datecreated | datetime | — | 51% | 2015-05-16T00:00:00.0002015-04-11T00:00:00.0002015-06-16T00:00:00.000 |
oldreferencenumber |
GET /api/datasets/w76s-c5u4 GET /api/datasets/w76s-c5u4/quality GET /api/datasets/w76s-c5u4/related GET /api/columns?dataset=w76s-c5u4
borough| 228428 |
| CQ25-2721B |
| SE |
| DOT-706108-J0S3 |
| 2025-07-28T00:00:00.000 |
| Engineering Study Completed (Signals Engineering) |
| CLOSED |
| 2025-12-04T00:00:00.000 |
| Queens |
| GUY R BREWER BOULEVARD |
| No |
| No |
| 219220 | CX25-1457 | ICU | — | 2025-04-29T00:00:00.000 | Study Request Denial | CLOSED | 2025-12-16T00:00:00.000 | Bronx | WEST 250 STREET | No | No |
| 133369 | CQ16-1447B | SE | — | 2016-08-03T00:00:00.000 | Engineering Study Completed (Signals Engineering) | CLOSED | 2018-08-22T00:00:00.000 | Queens | 36 AVENUE | No | No |
| 117386 | SM98-0340B | SE | 14679 | 1998-04-09T00:00:00.000 | Engineering Study Completed (Signals Engineering) | CLOSED | 1998-07-02T00:00:00.000 | Manhattan | BROADWAY | No | No |
| 230070 | CK25-3366B | SE | DOT-719150-V1S2 | 2025-10-16T00:00:00.000 | Engineering Study Completed (Signals Engineering) | CLOSED | 2025-12-30T00:00:00.000 | Brooklyn | COURT STREET | No | No |
| 228624 | CM25-2917B | SE | DOT-709716-B1H4 | 2025-08-29T00:00:00.000 | Engineering Study Completed (Signals Engineering) | CLOSED | 2025-12-22T00:00:00.000 | Manhattan | SEAMAN AVENUE | No | No |
| 228526 | CK25-2819B | SE | DOT-706784-P1Y3 | 2025-08-08T00:00:00.000 | Engineering Study Completed (Signals Engineering) | CLOSED | 2025-12-09T00:00:00.000 | Brooklyn | AVENUE T | No | No |
| 183575 | CS22-2812 | ICU | DOT-565975-C0X6; DOT-603619-W8F9; DOT-679741-B0Y3; DOT-728617-V3T7 | 2022-09-23T00:00:00.000 | Signal Approval | CLOSED | 2025-06-17T00:00:00.000 | Staten Island | CASTLETON AVENUE | No | No |
| 124677 | CQ03-1064A | SE | QBC03-1293 | 2003-07-15T00:00:00.000 | VOID--Signals Engineering Studies (ICU) | CLOSED | 2003-09-26T00:00:00.000 | Queens | UNION TURNPIKE | No | No |
Showing 12 of 39 columns. All of them are listed below.
| text |
| — |
| 72% |
N/ACK03-1573CQ06-0932 |
externalreferencenumber | text | — | 18% | INTERNAL REQUESTN/ACCU-13-2722, BBC-13-285 |
daterequested | datetime | — | 0% | 1996-06-28T00:00:00.0001996-04-11T00:00:00.0001996-07-23T00:00:00.000 |
statusdescription | text | — | 0% | Study Request DenialEngineering Study Comple…Signal Approval |
studystatus | text | — | 0% | CLOSEDof 1 |
statusdate | datetime | — | 0% | 2017-04-04T00:00:00.0002017-04-05T00:00:00.0002017-11-27T00:00:00.000 |
requesttype | categorical | — | 15% | Traffic SignalAll-Way StopLeft Turn Arrow/Signalof 14 |
dateassigned | datetime | — | 53% | 2017-01-26T00:00:00.0002013-03-04T00:00:00.0002016-10-17T00:00:00.000 |
borough | text | — | 0% | QueensBrooklynStaten Island |
locationtype | categorical | — | 10% | IntersectionStretchCitywideof 4 |
mainstreet | text | — | 1% | BROADWAYATLANTIC AVENUEQUEENS BOULEVARD |
crossstreet1 | text | — | 5% | UNION TURNPIKEFLATBUSH AVENUEBROADWAY |
crossstreet2 | text | — | 89% | NYCTA SUBWAYBROADWAYGOWANUS EXPRESSWAY |
compassdirectionone | categorical | — | 96% | NESof 5 |
compassdirectiontwo | categorical | — | 100% | NESof 4 |
locationnotes | text | — | 99% | VARIOUSMANHATTAN VARIOUSBROOKLYN VARIOUS |
midblock | categorical | — | 0% | NoYesof 2 |
removal | categorical | — | 0% | NoYesof 2 |
visionzero | categorical | — | 0% | NoYesof 2 |
seasonal | categorical | — | 0% | NoYesof 2 |
hurricanesandy | categorical | — | 0% | NoYesof 2 |
schoolhold | categorical | — | 0% | NoYesof 2 |
consultant | categorical | — | 0% | NoYesof 2 |
schoolcrossing | categorical | — | 0% | NoYesof 2 |
schoolnumber | text | — | 90% | P.S. 32P.S. 199P.S. 45 |
schoolname | text | — | 91% | SACRED HEARTVISITATION ACADEMYGOOD SHEPHERD |
targetdate | datetime | — | 24% | 1996-09-26T00:00:00.0002014-12-31T00:00:00.0002016-01-31T00:00:00.000 |
reevaluationdate | datetime | — | 98% | 2019-06-29T00:00:00.0002020-02-17T00:00:00.0002019-09-28T00:00:00.000 |
am_count | datetime | — | 73% | 2018-05-16T00:00:00.0002016-06-08T00:00:00.0002018-05-09T00:00:00.000 |
am_count2 | datetime | — | 99% | 2015-07-22T00:00:00.0002021-07-14T00:00:00.0002019-07-10T00:00:00.000 |
pm_count | datetime | — | 73% | 2018-05-22T00:00:00.0002015-10-14T00:00:00.0002018-05-16T00:00:00.000 |
pm_count2 | datetime | — | 99% | 2015-07-22T00:00:00.0002025-07-22T00:00:00.0002025-07-07T00:00:00.000 |
midday_count | datetime | — | 80% | 2018-05-16T00:00:00.0002018-05-30T00:00:00.0002018-05-22T00:00:00.000 |
midday_count2 | coordinate | — | 100% | 20240406000000.00000000020230527000000.00000000020250716000000.000000000 |
schooldismissal | datetime | — | 78% | 2018-05-16T00:00:00.0002018-05-22T00:00:00.0002018-01-24T00:00:00.000 |
schooldismissal2 | datetime | — | 100% | 2019-01-30T00:00:00.0002025-07-14T00:00:00.0002025-07-22T00:00:00.000 |
pedestriancount | datetime | — | 78% | 2018-05-16T00:00:00.0002018-05-22T00:00:00.0002018-06-27T00:00:00.000 |
pedestriancount2 | datetime | — | 98% | 2019-07-30T00:00:00.0002019-07-10T00:00:00.0002026-07-15T00:00:00.000 |
gap | datetime | — | 77% | 2018-05-16T00:00:00.0002018-05-09T00:00:00.0002018-06-27T00:00:00.000 |
gap2 | datetime | — | 98% | 2019-07-30T00:00:00.0002025-07-08T00:00:00.0002025-07-22T00:00:00.000 |
speed | datetime | — | 76% | 2018-01-24T00:00:00.0002018-05-16T00:00:00.0002017-05-09T00:00:00.000 |
speed2 | datetime | — | 99% | 2025-07-22T00:00:00.0002025-07-08T00:00:00.0002021-07-14T00:00:00.000 |
otherstudies | datetime | — | 100% | 2015-11-18T00:00:00.0002015-04-14T00:00:00.0002024-04-06T00:00:00.000 |
otherstudies2 | coordinate | — | 100% | 20140412000000.00000000020140712000000.00000000020141014000000.000000000of 14 |
atr_receivedate | datetime | — | 99% | 2018-01-22T00:00:00.0002017-09-11T00:00:00.0002018-06-18T00:00:00.000 |
atr_requestdate | datetime | — | 98% | 1996-09-13T00:00:00.0002021-10-13T00:00:00.0002021-06-03T00:00:00.000 |
warrantdescription | text | — | 94% | XYZWarrant 7 - Crash Experi…Warrant 5 - Engineering … |
warrantsstudytype | categorical | — | 95% | Traffic SignalAll-Wayof 2 |
warrantssatisfieddate | datetime | — | 97% | 1997-10-09T00:00:00.0002001-03-13T00:00:00.0002018-10-01T00:00:00.000 |
signalinstalldate | datetime | — | 96% | 2020-10-06T00:00:00.0002020-02-27T00:00:00.0002020-04-02T00:00:00.000 |
aw_installdate | datetime | — | 98% | 2019-12-03T00:00:00.0002023-10-25T00:00:00.0002024-01-29T00:00:00.000 |
findings | text | — | 62% | A/W DENIEDT/S DENIEDT/S APPROVAL |
tentativesignalinstalldate | datetime | — | 98% | 2006-07-06T00:00:00.0002008-05-08T00:00:00.0002005-04-01T00:00:00.000 |