From a 500-row sample across 11 columns.
boroughzipcodedate_collectedboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| kit_id | borough | zipcode | date_collected | date_received | lead_first_draw_mg_l | lead_1_2_minute_flush_mg_l | copper_first_draw_mg_l | copper_1_2_minute_flush_mg_l |
|---|---|---|---|---|---|---|---|---|
| 21284513 | Staten Island | 10304 | 2022-01-01T07:00:00.000 | 2022-01-10T14:48:20.000 | 0.000 | 0.000 | 0.238 | 0.182 |
| 21285085 | Brooklyn | 11237 | 2022-01-01T07:57:00.000 | 2022-01-06T11:28:09.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
kit_id | integer | Identification number assigned to kit | 0% | 14222352141008610206723 |
borough | text | Borough where sample was collected | 0% | BrooklynQueensManhattan |
zipcode | text | Zipcode of location where sample was collected | 0% | 112151123810025 |
date_collected | datetime | date sample was collected | 0% | 2016-03-18T00:00:00.0002025-01-06T00:00:00.0002025-01-07T00:00:00.000 |
GET /api/datasets/k5us-nav4 GET /api/datasets/k5us-nav4/quality GET /api/datasets/k5us-nav4/related GET /api/columns?dataset=k5us-nav4
| 0.002 |
| 0.000 |
| 0.127 |
| 0.047 |
| 21285469 | Manhattan | 10029 | 2022-01-01T09:08:00.000 | 2022-01-05T14:25:52.000 | 0.000 | 0.000 | 0.240 | 0.169 |
| 21285416 | Brooklyn | 11215 | 2022-01-01T11:43:00.000 | 2022-01-05T14:25:00.000 | 0.000 | 0.000 | 0.293 | 0.079 |
| 21281178 | Manhattan | 10003 | 2022-01-01T17:06:00.000 | 2022-01-05T14:56:44.000 | 0.002 | 0.000 | 0.256 | 0.026 |
| 21285630 | Queens | 11372 | 2022-01-01T20:30:00.000 | 2022-01-10T14:45:56.000 | 0.004 | 0.000 | 0.093 | 0.034 |
| 21285127 | Brooklyn | 11214 | 2022-01-01T21:35:00.000 | 2022-01-07T12:09:01.000 | 0.000 | 0.000 | 0.247 | 0.016 |
| 21285292 | Manhattan | 10024 | 2022-01-02T07:00:00.000 | 2022-01-06T11:33:14.000 | 0.000 | 0.000 | 0.161 | 0.149 |
| 21285691 | Queens | 11385 | 2022-01-02T07:57:00.000 | 2022-01-10T14:42:58.000 | 0.002 | 0.000 | 0.155 | 0.046 |
| 21285526 | Brooklyn | 11216 | 2022-01-02T08:13:00.000 | 2022-01-06T11:28:51.000 | 0.000 | 0.000 | 0.483 | 0.102 |
date_received | datetime | date sample was received by DEP | 0% | 2025-01-13T00:00:00.0002016-03-19T00:00:00.0002016-03-28T00:00:00.000 |
lead_first_draw_mg_l | float | Concentration of lead in the first draw sample | 0% | 0.0000.0010.002 |
lead_1_2_minute_flush_mg_l | float | Concentration of lead in the 1-2 minute flush sample | 0% | 0.0000.0020.001 |
lead_5_minute_flush_mg_l | float | Concentration of lead in the 5 minute flush sample | 97% | 0.0000.0020.001 |
copper_first_draw_mg_l | float | Concentration of copper in the first draw sample | 0% | 0.1580.1170.132 |
copper_1_2_minute_flush_mg_l | float | Concentration of copper in the 1-2 minute flush sample | 0% | 0.0180.0170.019 |
copper_5_minute_flush_mg_l | float | Concentration of copper in the 5 minute flush sample | 97% | 0.010.0140.02 |