From a 500-row sample across 10 columns.
statusanalytesample_time+4statusanalytesample_time+4statusanalyteunits+3analytesample_datesample_id| sample_id | site | sample_date | sample_time | depth_m | analyte | status | final_result | units | reservoir |
|---|---|---|---|---|---|---|---|---|---|
| E-2405095-02 | 1UEC | 2024-12-30T00:00:00.000 | 11:15:00.000 | 3 | Turbidity | Done | 0.89 | NTU | Kensico |
| G-2404824-03 | 1RR | 2024-12-19T00:00:00.000 | 11:13:00.000 | 18 | Dissolved Oxygen |
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% | G00003897001C-37650C-37667 |
site | text | Name of sampling site | 0% | 1EAW1RR4EAE |
sample_date | datetime | Date of sample creation | 0% | 1999-07-12T00:00:00.0002000-04-17T00:00:00.0001995-07-10T00:00:00.000 |
sample_time | text | Time of sample creation | 16% | 11:0010:3010:00 |
GET /api/datasets/3y4p-uusw GET /api/datasets/3y4p-uusw/quality GET /api/datasets/3y4p-uusw/related GET /api/columns?dataset=3y4p-uusw
analytesample_datesample_idanalytesample_datesample_idsample_timesample_date| Done |
| 10.6 |
| mg/L |
| Rondout |
| G-2404824-02 | 1RR | 2024-12-19T00:00:00.000 | 11:02:00.000 | 3 | Specific Conductance | Done | 58 | umhos/cm | Rondout |
| G-2404824-02 | 1RR | 2024-12-19T00:00:00.000 | 11:02:00.000 | 3 | Coliform, Total | Done | E28 | TC/100mL | Rondout |
| G-2404824-03 | 1RR | 2024-12-19T00:00:00.000 | 11:13:00.000 | 18 | Specific Conductance | Done | 58 | umhos/cm | Rondout |
| G-2404824-02 | 1RR | 2024-12-19T00:00:00.000 | 11:02:00.000 | 3 | Dissolved Oxygen | Done | 10.6 | mg/L | Rondout |
| G-2404824-02 | 1RR | 2024-12-19T00:00:00.000 | 11:02:00.000 | 3 | Turbidity | Done | 1.1 | NTU | Rondout |
| G-2404824-02 | 1RR | 2024-12-19T00:00:00.000 | 11:02:00.000 | 3 | Coliform, Fecal | Done | E5 | FC/100mL | Rondout |
| E-2404860-02 | 1UEC | 2024-12-19T00:00:00.000 | 09:04:00.000 | 3 | Turbidity | Done | 1.1 | NTU | Kensico |
| G-2404824-03 | 1RR | 2024-12-19T00:00:00.000 | 11:13:00.000 | 18 | Coliform, Fecal | Done | E2 | FC/100mL | Rondout |
depth_m| integer |
| The depth (in meters) where the sample was collected |
| 2% |
037 |
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). | 75% | DoneCancelWarningof 6 |
final_result | text | Final result produced from testing | 0% | <1CancelError |
units | text | Units of final result produced from the test collected | 9% | mg/Lµg/Lm |
reservoir | text | The reservoir from which the data came. | 0% | KensicoNew CrotonAshokan West Basin |