From a 500-row sample across 6 columns.
| comp_date | location | type_name | comments | req | ref |
|---|---|---|---|---|---|
| 2002-09-16T00:00:00.000 | PARSONS BLVD @ 17 RD | KWICK CURB | SERVICE KWICK CURB | — | — |
| 2001-01-01T00:00:00.000 | TILLARY ST W/B BETWEEN GOLD & NAVY ST | — | (1) SI-743K | H99-09-157 | MD-186 |
| 2002-12-13T00:00:00.000 | BQE E/B @ SANDS ST | SPECIAL | REM (1) SR-1559 | — | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
req | datetime | If signs were manufactured for a specific entry a requisition form is written for said signs | 92% | 2025-06-30T00:00:00.0002025-07-08T00:00:00.0002025-06-23T00:00:00.000 |
comp_date | datetime | Date work was completed | 0% | 2005-12-23T00:00:00.0002009-08-14T00:00:00.0002010-03-16T00:00:00.000 |
location | text | Exact location of the job | 0% | G C P E/B @ FRANCIS LEWI…J R P E/B @ MYRTLE AVE E…B R P N/B @ MOSHOLU PKWY… |
type_name | text | The kind of work performed | 0% |
GET /api/datasets/jkdk-6p97 GET /api/datasets/jkdk-6p97/quality GET /api/datasets/jkdk-6p97/related GET /api/columns?dataset=jkdk-6p97
| 2001-01-01T00:00:00.000 | LIE W/B @ EXIT TO VAN DAM ST | NEW WORK | (1) SR-R5-1 (2) SR-607 (1) R1-1A | H99-08-146 | H-2090 |
| 2002-12-13T00:00:00.000 | BQE W/B @ FLUSHING AV | SPECIAL | REM (1) SR-1559 | — | — |
| 2002-12-13T00:00:00.000 | BQE W/B @ MARCY AV | SPECIAL | REM (1) SR-1559 | — | — |
| 2002-12-13T00:00:00.000 | BQE E/B @ McGUINESS ST ENT | SPECIAL | REM (1) SR-1559 | — | — |
| 2001-04-10T00:00:00.000 | 58 ST @ QBB UPPER RDWY ENT RAMP | KWICK CURB | 4 FLAT WHITE BOLLARDS MISSING | — | — |
| 2001-04-10T00:00:00.000 | 5 AV @ BROADWAY | KWICK CURB | 40 BOLLARDS DEFACED W/STICKERS | — | — |
| 2001-04-10T00:00:00.000 | BROADWAY, 34 ST - 35 ST | KWICK CURB | 6 BOLLARDS MISSING | — | — |
R.O.NEW WORKOTHER |
comments | text | Brief description of work performed | 0% | SERVICE KWICK CURBEXIT SIGN DOWNREM 5 BORO BIKE TOUR ADV… |
ref | text | Order Number | 66% | BENCHESBIKE RACKSCORRALS |