From a 500-row sample across 5 columns.
sample_idanalytesample_site+2sample_idanalytesample_site+2sample_idanalytesample_site+2sample_idanalytesample_site+1| sample_site | sample_id | analyte | sample_date | qualifier |
|---|---|---|---|---|
| Kent Manor Sewer Corporation | K-2404696-06 | Dissolved Oxygen | 2024-12-04T00:00:00.000 | Site access issue |
| MICHELLE ESTATES | K-2404696-04 | Ammonia (as NH3) | 2024-12-04T00:00:00.000 | Site access issue |
| PJ9 | G-2404563-02 | Nitrate/Nitrite (as N) | 2024-12-04T00:00:00.000 | Analysis omitted deliberately. Wrong folder type was prelogged. |
| PJ9 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sample_site | text | Sample Site | 0% | PJ9RGCMSC |
sample_id | text | Sample Id | 0% | D-90528D-90980K-1401409-02 |
analyte | text | Analyte | 0% | pHCBODBOD |
sample_date | datetime | Sample Date | 0% | 2012-06-27T00:00:00.0002008-02-05T00:00:00.0002010-12-01T00:00:00.000 |
qualifier | text |
GET /api/datasets/rmsj-k8gu GET /api/datasets/rmsj-k8gu/quality GET /api/datasets/rmsj-k8gu/related GET /api/columns?dataset=rmsj-k8gu
sample_idanalytesample_site+1sample_idanalytesample_datesample_idanalytesample_site| G-2404698-02 |
| Ammonia (as NH3) |
| 2024-12-04T00:00:00.000 |
| Data reanalyzed due to result above calibration range. |
| PJ9 | G-2404698-02 | Zinc, Total | 2024-12-04T00:00:00.000 | QC failed |
| PJ9 | G-2404563-02 | Phosphorus, Total (as P) | 2024-12-04T00:00:00.000 | Analysis omitted deliberately. Wrong folder type was prelogged. |
| PJ1 | G-2404698-01 | Ammonia (as NH3) | 2024-12-04T00:00:00.000 | Data reanalyzed due to result above calibration range. |
| THE FAIRWAYS (HILL&DALE) | K-2404696-05 | Ammonia (as NH3) | 2024-12-04T00:00:00.000 | Site access issue |
| MICHELLE ESTATES | K-2404696-04 | Phosphorus, Total (as P) | 2024-12-04T00:00:00.000 | Site access issue |
| PJ1 | G-2404563-01 | BOD | 2024-12-04T00:00:00.000 | Analysis omitted deliberately. Wrong folder type was prelogged. |
| Qualifier |
| 0% |
NYS ELAP requires analys…All CBOD5 samples were a…Site insufficient flow o… |