From a 500-row sample across 13 columns.
statusfinal_resultanalyte+2statusfinal_resultanalyte+3statusfinal_resultanalyte+2| sample_id | site | sample_start_date | date | start_time | time | analyte | status | final_result | units | water_treatment_plant | wtp_group |
|---|---|---|---|---|---|---|---|---|---|---|---|
| G-2404941-02 | PJ9 | 2024-12-25T00:00:00.000 | 2024-12-26T00:00:00.000 | 06:30:00.000 | 06:30:00.000 | BOD | Done | 9.1 | mg/L | Port Jervis | City Owned - Effluent |
| G-2404941-01 |
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% | B-1403034-06B-1500538-05D-100092 |
site | text | Name of sampling site | 0% | PJ9MSCRGC |
sample_start_date | datetime | Date that sample collection started | 97% | 2013-05-14T00:00:00.0002014-05-13T00:00:00.0002013-10-22T00:00:00.000 |
date | datetime | Date of sample creation | 0% | 1995-07-05T00:00:00.0001996-11-06T00:00:00.000 |
GET /api/datasets/icbf-663g GET /api/datasets/icbf-663g/quality GET /api/datasets/icbf-663g/related GET /api/columns?dataset=icbf-663g
analytesample_idanalytesample_idanalytesample_id| PJ1 |
| 2024-12-25T00:00:00.000 |
| 2024-12-26T00:00:00.000 |
| 06:30:00.000 |
| 06:30:00.000 |
| Solids, Total Suspended |
| Done |
| 186 |
| mg/L |
| Port Jervis |
| City Owned - Influent |
| G-2404941-01 | PJ1 | 2024-12-25T00:00:00.000 | 2024-12-26T00:00:00.000 | 06:30:00.000 | 06:30:00.000 | BOD | Done | 260 | mg/L | Port Jervis | City Owned - Influent |
| G-2404941-02 | PJ9 | 2024-12-25T00:00:00.000 | 2024-12-26T00:00:00.000 | 06:30:00.000 | 06:30:00.000 | Solids, Total Suspended | Done | 5 | mg/L | Port Jervis | City Owned - Effluent |
| G-2404941-03 | PJ9 | — | 2024-12-26T00:00:00.000 | — | 06:35:00.000 | Coliform, Fecal | Done | E4 | FC/100mL | Port Jervis | City Owned - Effluent |
| G-2404820-03 | PJ9 | — | 2024-12-18T00:00:00.000 | — | 07:30:00.000 | Coliform, Fecal | Done | E4 | FC/100mL | Port Jervis | City Owned - Effluent |
| G-2404820-01 | PJ1 | 2024-12-17T00:00:00.000 | 2024-12-18T00:00:00.000 | 07:30:00.000 | 07:30:00.000 | BOD | Done | 251 | mg/L | Port Jervis | City Owned - Influent |
| G-2404820-01 | PJ1 | 2024-12-17T00:00:00.000 | 2024-12-18T00:00:00.000 | 07:30:00.000 | 07:30:00.000 | Solids, Total Suspended | Done | 129 | mg/L | Port Jervis | City Owned - Influent |
| K-2404704-03 | STE | — | 2024-12-18T00:00:00.000 | — | 09:00:00.000 | Coliform, Fecal | Done | <1 | FC/100mL | Tannersville | City Owned - Effluent |
| K-2404704-06 | SGE | — | 2024-12-18T00:00:00.000 | — | 09:00:00.000 | Coliform, Fecal | Done | <1 | FC/100mL | Grand Gorge | City Owned - Effluent |
Showing 12 of 13 columns. All of them are listed below.
2014-05-14T00:00:00.000start_time | text | Time that sample collection started | 85% | 8:009:0009:00:00.000 |
time | text | Time of sample creation | 5% | 13:0015:008:00 |
analyte | text | Component or chemical substance tested for | 0% | Solids, Total SuspendedTemperaturepH |
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). | 82% | DoneCancelWarningof 5 |
final_result | text | Final result produced from testing | 0% | <0.1Cancel<1 |
units | categorical | Units of final result produced from the test collected | 9% | mg/LCµg/Lof 19 |
water_treatment_plant | text | The wastewater facility that the data came from | 1% | MuscootSchoharieCannonsville |
wtp_group | categorical | Groups a set of sampling sites together by reservoir or by stream. | 0% | Non-City OwnedCity Owned - EffluentCity Owned - Influentof 4 |
spdes_number | text | Unique ID for individual wastewater treatment plants permitted through the NY Statewide Pollutant Discharge Elimination System (SPDES) generated by the NYS DEC | 8% | NY0026522NY0026531NY0026549 |