From a 500-row sample across 5 columns.
qualifiersample_idsample_date+2qualifiersample_idsample_date+2qualifiersample_idsample_date+2sample_idsample_dateanalyte+1| sample_site | sample_id | analyte | sample_date | qualifier |
|---|---|---|---|---|
| CROFALLSVC | E-2405058-02 | Organic Carbon, Dissolved | 2024-12-30T00:00:00.000 | This sample was not preserved within 15 minutes of sample collection. acid (prep ID:173-24) added in lab |
| ASP M-1 Conf | K-2405093-05 | Temperature | 2024-12-30T00:00:00.000 | Site insufficient flow or elevation |
| ASP M-1 Conf | K-2405093-05 | Solids, Total Suspended | 2024-12-30T00:00:00.000 | Site insufficient flow or elevation |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sample_site | text | Name of sampling site | 0% | MIDBR3MUSCOOT10CBS |
sample_id | text | Laboratory sample identifier | 0% | E-114917E-105400E-111927 |
analyte | text | Component or chemical substance tested for | 0% | Phosphorus, Total (as P)Nitrate/Nitrite (as N)pH |
sample_date | datetime | Date of sample creation | 0% | 1997-10-06T00:00:00.0001999-10-04T00:00:00.0001996-07-01T00:00:00.000 |
GET /api/datasets/shus-qn78 GET /api/datasets/shus-qn78/quality GET /api/datasets/shus-qn78/related GET /api/columns?dataset=shus-qn78
sample_idsample_dateanalyte+1sample_idsample_dateanalytesample_sitesample_idanalyte| ASP M-1 Conf | K-2405093-05 | Turbidity | 2024-12-30T00:00:00.000 | Site insufficient flow or elevation |
| ASP | K-2405093-04 | Turbidity | 2024-12-30T00:00:00.000 | Site insufficient flow or elevation |
| CBS | G-2405069-08 | Ammonia (as N) | 2024-12-30T00:00:00.000 | Sample result had a negative peak; suspect preserved sample was over acidified |
| NCG | G-2405030-01 | Organic Carbon, Total | 2024-12-30T00:00:00.000 | This sample is associated with a spiked sample result that was above the high calibrant. The spike recovery was calculated using an extrapolated value. |
| NCG | G-2405030-01 | Ammonia (as N) | 2024-12-30T00:00:00.000 | Sample result had a negative peak; suspect preserved sample was over acidified |
| CROSSRVVC | E-2405058-03 | Organic Carbon, Dissolved | 2024-12-30T00:00:00.000 | This sample was not preserved within 15 minutes of sample collection. acid (prep ID:173-24) added in lab |
| ASP | K-2405093-04 | Coliform, Fecal | 2024-12-30T00:00:00.000 | Site insufficient flow or elevation |
qualifier | text | Provides any further detail that should accompany an analytical result. | 0% | Metal samples are acidif…Samples with pH beyond m…NYS ELAP requires analys… |