From a 500-row sample across 10 columns.
sample_datesample_time| sample_number | sample_date | sample_time | sample_site | sample_class | residual_free_chlorine_mg_l | turbidity_ntu | coliform_quanti_tray_mpn_100ml | e_coli_quanti_tray_mpn_100ml | fluoride_mg_l |
|---|---|---|---|---|---|---|---|---|---|
| 202436678 | 2024-12-31T00:00:00.000 | 09:47:00.000 | 51050 | Compliance | 0.50 | 0.69 | <1 | <1 | — |
| 202436679 | 2024-12-31T00:00:00.000 | 10:28:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sample_number | integer | — | 0% | 202123323201723990201529216 |
sample_date | datetime | — | 0% | 2021-06-02T00:00:00.0002015-08-05T00:00:00.0002023-08-14T00:00:00.000 |
sample_time | text | — | 0% | 9:309:119:46 |
sample_site | text | — | 0% | 1S03A2090040200 |
sample_class |
GET /api/datasets/bkwf-xfky GET /api/datasets/bkwf-xfky/quality GET /api/datasets/bkwf-xfky/related GET /api/columns?dataset=bkwf-xfky
| 58350 |
| Compliance |
| 0.46 |
| 0.82 |
| <1 |
| <1 |
| — |
| 202436680 | 2024-12-31T00:00:00.000 | 09:08:00.000 | 59350 | Compliance | 0.39 | 0.75 | <1 | <1 | — |
| 202436675 | 2024-12-31T00:00:00.000 | 08:45:00.000 | 78450 | Compliance | 0.32 | 0.70 | <1 | <1 | — |
| 202426025 | 2024-10-01T00:00:00.000 | 08:36:00.000 | 10750 | Compliance | 0.84 | 0.47 | <1 | <1 | 0.71 |
| 202426062 | 2024-10-01T00:00:00.000 | 09:22:00.000 | 11250 | Compliance | 0.95 | 0.58 | <1 | <1 | — |
| 202426026 | 2024-10-01T00:00:00.000 | 11:21:00.000 | 17350 | Compliance | 0.58 | 0.42 | <1 | <1 | — |
| 202426063 | 2024-10-01T00:00:00.000 | 08:46:00.000 | 17650 | Compliance | 0.65 | 0.26 | <1 | <1 | — |
| 202426027 | 2024-10-01T00:00:00.000 | 09:57:00.000 | 1S02B | Operational | 0.62 | 0.83 | <1 | <1 | 0.74 |
| 202426095 | 2024-10-01T00:00:00.000 | 09:20:00.000 | 1S03 | Operational | 0.86 | 0.55 | <1 | <1 | 0.74 |
| categorical |
| — |
| 0% |
ComplianceOperationalResample_Complianceof 5 |
residual_free_chlorine_mg_l | coordinate | — | 0% | 0.620.580.55 |
turbidity_ntu | coordinate | — | 0% | 0.70.720.68 |
fluoride_mg_l | coordinate | — | 87% | 0.710.70.72 |
coliform_quanti_tray_mpn_100ml | text | — | 0% | <112 |
e_coli_quanti_tray_mpn_100ml | categorical | — | 0% | <112of 4 |