From a 500-row sample across 7 columns.
final_resultsample_idanalyte+2sample_datefinal_resultsample_id+5sample_datefinal_resultsample_id+4sample_datesample_idanalyte+1| sample_id | sample_site | sample_date | analyte | final_result | units | stream_group |
|---|---|---|---|---|---|---|
| E-94988 | DIVERTR | 1987-01-05T00:00:00.000 | Alkalinity | 61.3 | mg/L | East Branch |
| C-199439 | E13I | 1987-01-05T00:00:00.000 | Iron, Total | 0.06 | mg/L | Esopus |
| C-195825 | BK | 1987-01-05T00:00:00.000 |
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% | E-1901638-03E-1901638-07E-1901638-04 |
sample_site | text | Name of sampling site | 0% | CBSE16IMB-1 |
sample_date | datetime | Date of sample collection | 0% | 2001-04-02T00:00:00.0002001-07-02T00:00:00.0001999-07-12T00:00:00.000 |
sample_time | text | Time sample was collected | 24% | 10:0010:5010:40 |
GET /api/datasets/e3xf-jwmj GET /api/datasets/e3xf-jwmj/quality GET /api/datasets/e3xf-jwmj/related GET /api/columns?dataset=e3xf-jwmj
sample_datesample_idanalyte+1sample_sitesample_datesample_idanalyte+1| Iron, Total |
| 0.01 |
| mg/L |
| Esopus |
| C-182099 | LBK | 1987-01-05T00:00:00.000 | Iron, Total | 0.07 | mg/L | Esopus |
| E-96871 | MIDDLEBRR | 1987-01-05T00:00:00.000 | Alkalinity | 48.7 | mg/L | EOH Hydrology |
| E-97121 | MUSCOOTR | 1987-01-05T00:00:00.000 | Alkalinity | 49.4 | mg/L | EOH Hydrology |
| C-198134 | E10I | 1987-01-05T00:00:00.000 | Iron, Total | <0.01 | mg/L | Esopus |
| C-189020 | SCL | 1987-01-05T00:00:00.000 | Iron, Total | <0.01 | mg/L | Esopus |
| E-94988 | DIVERTR | 1987-01-05T00:00:00.000 | Apparent Color | 35 | CU | East Branch |
| C-199439 | E13I | 1987-01-05T00:00:00.000 | Apparent Color | 11 | CU | Esopus |
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). | 80% | DoneWarningCancelof 5 |
final_result | text | Final result produced from testing | 0% | Error0<1 |
units | text | Units of final result produced from the test collected | 8% | mg/Lµg/LNTU |
stream_group | categorical | Stream or river network used for grouping sampling sites | 0% | CannonsvilleEsopusPepactonof 16 |