From a 500-row sample across 11 columns.
sample_datesite| site | location | sample_date | analysis_date_tthm_g_l_a | result_tthm_g_l_a | lraa_tthm_g_l_a | oel_tthm_g_l_a | analysis_date_haa5_g_l_b | result_haa5_g_l_b | lraa_haa5_g_l_b | oel_haa5_g_l_b |
|---|---|---|---|---|---|---|---|---|---|---|
| 15150 | SS - E/S Grand Concourse, 1st SS S/O E 171st St, IFO 1420 Grand Concourse, 12" | 2026-08-04T00:00:00.000 | 2026-08-04T00:00:00.000 | 34 | 31 | 32 | 2026-08-07T00:00:00.000 | 26 | 35 | 32 |
| 18650 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
site | integer | — | 0% | 508507765033450 |
location | text | — | 0% | SS - E/S Woodhull Ave, 1…SS - IFO 116 E/S Ave C, …SS - IFO 218 W/S Nichola… |
sample_date | datetime | — | 0% | 2015-05-05T00:00:00.0002017-11-08T00:00:00.0002021-08-03T00:00:00.000 |
analysis_date_tthm_g_l_a | datetime | — | 0% | 2015-05-05T00:00:00.000 |
GET /api/datasets/33c5-b922 GET /api/datasets/33c5-b922/quality GET /api/datasets/33c5-b922/related GET /api/columns?dataset=33c5-b922
| SS - N/S Dewey Ave, BTW Quincy & Swinton Aves, 12" |
| 2026-08-04T00:00:00.000 |
| 2026-08-05T00:00:00.000 |
| 43 |
| 33 |
| 35 |
| 2026-08-07T00:00:00.000 |
| 29 |
| 34 |
| 33 |
| 23450 | SS - N/S Jefferson Ave, 2nd SS W/O Lewis Ave, OPP 518 Jefferson Ave, 20" | 2026-08-04T00:00:00.000 | 2026-08-05T00:00:00.000 | 47 | 36 | 39 | 2026-08-05T00:00:00.000 | 28 | 37 | 35 |
| 24350 | SS - W/S Brighton 11th St, 2nd SS S/O Cass Pl, IFO 82 Brighton 11th St, 12" | 2026-08-04T00:00:00.000 | 2026-08-04T00:00:00.000 | 50 | 38 | 41 | 2026-08-10T00:00:00.000 | 32 | 38 | 37 |
| 31750 | SS - N/S W 26th St, 2nd SS W/O 9th Ave, IFO 427 W. 26th St, 12" | 2026-08-04T00:00:00.000 | 2026-08-05T00:00:00.000 | 60 | 43 | 48 | 2026-08-06T00:00:00.000 | 27 | 39 | 37 |
| 31850 | SS - S/S Warren St, 2nd SS E/O Greenwich St, IFO 82 Warren St, 12" | 2026-08-04T00:00:00.000 | 2026-08-05T00:00:00.000 | 56 | 40 | 43 | 2026-08-06T00:00:00.000 | 35 | 40 | 39 |
| 32350 | SS - E/S Ave C, 2nd SS N/O E 7th St, IFO 116 Ave C, 12" | 2026-08-04T00:00:00.000 | 2026-08-04T00:00:00.000 | 61 | 42 | 48 | 2026-08-06T00:00:00.000 | 30 | 37 | 39 |
| 33450 | SS - N/S W 112th St, 2nd SS W/O St Nicholas Ave, - IFO 135 W. 112th St, 12" | 2026-08-04T00:00:00.000 | 2026-08-04T00:00:00.000 | 67 | 37 | 47 | 2026-08-06T00:00:00.000 | 31 | 28 | 31 |
| 33950 | SS - N/S E 104th St, 2nd SS E/O 3rd Ave, 12" | 2026-08-04T00:00:00.000 | 2026-08-05T00:00:00.000 | 59 | 34 | 42 | 2026-08-06T00:00:00.000 | 32 | 29 | 33 |
| 37950 | SS - N/S E 12th St, 2nd SS E/O 2nd Ave, IFO 325 E. 12th St, 12" | 2026-08-04T00:00:00.000 | 2026-08-04T00:00:00.000 | 60 | 42 | 47 | 2026-08-10T00:00:00.000 | 23 | 36 | 33 |
2015-02-05T00:00:00.0002016-02-03T00:00:00.000result_tthm_g_l_a | integer | — | 0% | 424441 |
lraa_tthm_g_l_a | integer | — | 0% | 383941 |
oel_tthm_g_l_a | integer | — | 0% | 383741 |
analysis_date_haa5_g_l_b | datetime | — | 0% | 2015-05-09T00:00:00.0002025-05-08T00:00:00.0002015-05-08T00:00:00.000 |
result_haa5_g_l_b | integer | — | 0% | 353836 |
lraa_haa5_g_l_b | integer | — | 0% | 394038 |
oel_haa5_g_l_b | integer | — | 0% | 403936 |