From a 500-row sample across 5 columns.
date| site1 | date | giardia | cryptosporidium | qualifiers |
|---|---|---|---|---|
| 1CR21 | 2015-04-20T00:00:00.000 | Cancel | Cancel | — |
| 1CR21 | 2015-04-27T00:00:00.000 | Cancel | Cancel | — |
| 1CR21 | 2015-05-04T00:00:00.000 | 0 | 0 | — |
| 1CR21 | 2015-05-11T00:00:00.000 | 0 | 0 | — |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
site1 | categorical | Sample Site | 0% | DEL18DTCATLEFFDEL18of 7 |
date | datetime | Sample Collection Date | 0% | 2011-08-29T00:00:00.0002012-03-19T00:00:00.0002016-02-16T00:00:00.000 |
giardia | categorical | Number of Giardia cysts observed in a 50 liter sample | 0% | 012of 19 |
cryptosporidium | categorical | Number of Cryptosporidium oocysts observed in a 50 liter sample | 0% | 01 |
GET /api/datasets/x2s6-6d2j GET /api/datasets/x2s6-6d2j/quality GET /api/datasets/x2s6-6d2j/related GET /api/columns?dataset=x2s6-6d2j
| 1CR21 | 2015-05-18T00:00:00.000 | 0 | 0 | — |
| 1CR21 | 2015-05-26T00:00:00.000 | 0 | 0 | — |
| 1CR21 | 2015-06-01T00:00:00.000 | 0 | 0 | — |
| 1CR21 | 2015-06-08T00:00:00.000 | 0 | 0 | — |
| 1CR21 | 2015-06-15T00:00:00.000 | 0 | 0 | The duplicate analysis was not within the control limits. |
| 1CR21 | 2015-06-22T00:00:00.000 | 0 | 0 | — |
Cancelqualifiers | text | Notes relating to the analytical process or results | 94% | The spike analysis was n…Heat DissociationThe IR gun was out of ca… |