From a 500-row sample across 10 columns.
sample_sitesample_date| sample_site | sample_date | ph_unit | alkalinity_mg_l_caco3 | calcium_mg_l | specific_conductance_s_cm | temperature_f | ortho_phosphate_mg_l | lead_g_l | copper_mg_l |
|---|---|---|---|---|---|---|---|---|---|
| 11750 | 2026-06-02T00:00:00.000 | 7.52 | 17.10 | 6.35 | 102 | 61 | 2.18 | 0 | 0.003 |
| 16150 | 2026-06-02T00:00:00.000 | 7.31 | 15.60 | 5.98 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
sample_site | integer | — | 0% | 117503825076150 |
sample_date | datetime | — | 0% | 2025-11-05T00:00:00.0002023-02-07T00:00:00.0002023-11-08T00:00:00.000 |
ph_unit | float | — | 0% | 7.377.347.32 |
alkalinity_mg_l_caco3 | float | — | 1% | 16.415.615.5 |
calcium_mg_l | float |
GET /api/datasets/g63j-swsd GET /api/datasets/g63j-swsd/quality GET /api/datasets/g63j-swsd/related GET /api/columns?dataset=g63j-swsd
| 100 |
| 61 |
| 2.32 |
| 0 |
| 0.003 |
| 20150 | 2026-06-02T00:00:00.000 | 7.43 | 16.50 | 5.97 | 100 | 61 | 2.20 | 0 | 0.004 |
| 20650 | 2026-06-02T00:00:00.000 | 7.38 | 16.40 | 6.02 | 101 | 61 | 2.26 | 0 | 0.004 |
| 27350 | 2026-06-02T00:00:00.000 | 7.38 | 16.40 | 6.03 | 101 | 59 | 2.17 | 0 | 0.005 |
| 30550 | 2026-06-02T00:00:00.000 | 7.53 | 17.90 | 6.22 | 105 | 66 | 2.24 | 0 | 0.004 |
| 31450 | 2026-06-02T00:00:00.000 | 7.63 | 17.40 | 6.04 | 102 | 59 | 2.25 | 0 | 0.003 |
| 31550 | 2026-06-02T00:00:00.000 | 7.55 | 17.70 | 6.41 | 105 | 61 | 2.20 | 0 | 0.003 |
| 33050 | 2026-06-02T00:00:00.000 | 7.54 | 17.40 | 5.87 | 103 | 59 | 2.27 | 0 | 0.005 |
| 33850 | 2026-06-02T00:00:00.000 | 7.54 | 17.50 | 6.06 | 105 | 61 | 2.26 | 0 | 0.004 |
| — |
| 1% |
5.835.776.18 |
specific_conductance_s_cm | integer | — | 0% | 929391 |
temperature_f | integer | — | 0% | 666843 |
ortho_phosphate_mg_l | float | — | 0% | 2.072.092.13 |
lead_g_l | categorical | — | 0% | 021of 7 |
copper_mg_l | float | — | 0% | 0.0050.0040.006 |