From a 500-row sample across 6 columns.
sample_date| sample_id | sample_date | beach_name | sample_location | enterococci_results | units_or_notes |
|---|---|---|---|---|---|
| JB2609291005-1.2 | 2026-09-29T00:00:00.000 | SEA GATE BEACH CLUB | Center | 31 | MPN/100 ml |
| JB2609291005-1.3 | 2026-09-29T00:00:00.000 | SEA GATE BEACH CLUB | Right | 31 | MPN/100 ml |
| JB2609291005-1.1 | 2026-09-29T00:00:00.000 | SEA GATE BEACH CLUB | Left |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sample_id | text | Unique identifier consisting of text, date, time, sample subunit number and sample location number | 0% | 070709GR16AC2509150955-1.1JB2505271220-1.2 |
sample_date | datetime | Date of sampling | 0% | 2011-08-30T00:00:00.0002012-07-02T00:00:00.0002007-07-02T00:00:00.000 |
beach_name | text | Simply present name of beach | 0% | SOUTH BEACHDOUGLASTON HOMEOWNERS AS…ORCHARD BEACH |
sample_location | categorical | Location on the beach where sample was taken | 0% |
GET /api/datasets/2xir-kwzz GET /api/datasets/2xir-kwzz/quality GET /api/datasets/2xir-kwzz/related GET /api/columns?dataset=2xir-kwzz
| — |
| MPN/100 ml |
| JB2609210945-1.3 | 2026-09-21T00:00:00.000 | SCHUYLER HILL CIVIC ASSOCIATION | Right | 9.9 | MPN/100 ml |
| KB2609210925-1.3 | 2026-09-21T00:00:00.000 | SEA GATE BEACH CLUB | Right | 30 | MPN/100 ml |
| JB2609210945-1.1 | 2026-09-21T00:00:00.000 | SCHUYLER HILL CIVIC ASSOCIATION | Left | 30 | MPN/100 ml |
| JB2609210945-1.2 | 2026-09-21T00:00:00.000 | SCHUYLER HILL CIVIC ASSOCIATION | Center | 9.9 | MPN/100 ml |
| KB2609210925-1.2 | 2026-09-21T00:00:00.000 | SEA GATE BEACH CLUB | Center | 20 | MPN/100 ml |
| KB2609210925-1.1 | 2026-09-21T00:00:00.000 | SEA GATE BEACH CLUB | Left | 10 | MPN/100 ml |
| JB2609141040-1.1 | 2026-09-14T00:00:00.000 | SCHUYLER HILL CIVIC ASSOCIATION | Left | 10 | MPN/100 ml |
CenterLeftRightof 5enterococci_results | float | Measurement of bacteria present | 24% | 4.009.908.00 |
units_or_notes | categorical | Unit of measurement | 0% | MPN/100 mlResult below detection l…of 2 |