From a 500-row sample across 10 columns.
statussample_timesample_date+4statussample_timesample_site+5statusanalytefinal_result+2sample_site| sample_id | sample_site | sample_date | sample_time | analyte | status | final_result | units | aqueduct_group |
|---|---|---|---|---|---|---|---|---|
| K-2405103-02 | EARCM | 2024-12-31T00:00:00.000 | 12:00:00 | Turbidity | Done | 2.1 | NTU | Catskill Aqueduct |
| G-2405096-04 | RDRRCM | 2024-12-31T00:00:00.000 | 10:03:00 | Coliform, Total | Done | E200 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sample_id | text | Laboratory sample identifier | 0% | E-1904586-01E-1904571-03K-2203937-01 |
sample_site | text | Name of sampling site | 0% | CATALUMDEL17DEL18 |
sample_date | datetime | Date of sample creation | 0% | 2017-10-30T00:00:00.0002015-11-30T00:00:00.0002018-10-01T00:00:00.000 |
sample_time | text | Time of sample creation | 19% | 9:009:159:10 |
GET /api/datasets/wcg2-rbkn GET /api/datasets/wcg2-rbkn/quality GET /api/datasets/wcg2-rbkn/related GET /api/columns?dataset=wcg2-rbkn
sample_timesample_sitesample_date| TC/100mL |
| Delaware Aqueduct |
| G-2405096-01 | NRR2CM | 2024-12-31T00:00:00.000 | — | Coliform, Total | Cancel | Cancel | TC/100mL | Neversink Aqueduct |
| G-2405096-02 | PRR2CM | 2024-12-31T00:00:00.000 | 09:30:00 | Coliform, Total | Done | E48 | TC/100mL | Pepacton Aqueduct |
| G-2405096-03 | WDTOCM | 2024-12-31T00:00:00.000 | 09:11:00 | Coliform, Total | Done | E350 | TC/100mL | Cannonsville Aqueduct |
| G-2405096-01 | NRR2CM | 2024-12-31T00:00:00.000 | — | Total Plankton | Cancel | Cancel | ASU/mL | Neversink Aqueduct |
| E-2405052-03 | DEL19LAB | 2024-12-31T00:00:00.000 | 08:44:00 | Fluoride Residual | Done | 0.7 | mg/L | Cat\Del |
| K-2405103-01 | SRR2CM | 2024-12-31T00:00:00.000 | 11:09:00 | Turbidity | Done | 21 | NTU | Shandaken Tunnel |
| G-2405096-01 | NRR2CM | 2024-12-31T00:00:00.000 | — | Coliform, Fecal | Cancel | Cancel | FC/100mL | Neversink Aqueduct |
| K-2405103-03 | SRR1CM | 2024-12-31T00:00:00.000 | 09:58:00 | Turbidity | Done | 21 | NTU | Shandaken Tunnel |
analyte |
| text |
| Component or chemical substance tested for |
| 0% |
TurbidityTemperaturepH |
status | categorical | Indicates result status including Done (no issues), Warning (results are reportable, but may indicate a sampling or analytical issue), Cancel (not analyzed), and Failure (data not reportable). | 66% | DoneCancelWarningof 5 |
final_result | text | Final result produced from testing | 1% | <1Cancel0 |
units | text | Units of final result produced from the test collected | 21% | mg/LNTUC |
aqueduct_group | text | Groups a set of sampling sites together by reservoir or by stream. | 4% | Delaware AqueductCatskill AqueductDelaware Taps |
elevation_ft | float | — | 94% | 0.03.0513.0 |