Open data
Our test results are published as open data so anyone — swimmers, clubs, researchers, journalists — can use them. Results appear once a sample is complete. Each value shows a qualifier: '=' for an exact count, '<' when below the lab's detection limit, '>' when above its counting limit. Status (pass, warn, fail) uses the thresholds on the Explain readings page. Please credit 'The River Thames Water Quality Testing Group' when you use the data. Results are a guide only — see the disclaimer.
Using the data
Published results are available from this public web address:
https://msqjdbthrkuogclaamjn.supabase.co/rest/v1/public_resultsEvery request needs our public key sent as the apikey header:
sb_publishable_GUZ6HgW1Wz8BPYXkNKPTZQ_cppKUPl5Example: the 10 most recent results at Boulters Lock.
curl "https://msqjdbthrkuogclaamjn.supabase.co/rest/v1/public_results?location_slug=eq.boulters-lock&order=sampled_at.desc&limit=10" \ -H "apikey: sb_publishable_GUZ6HgW1Wz8BPYXkNKPTZQ_cppKUPl5"
Fields returned
| Field | Description |
|---|---|
| location_name | Name of the testing location. |
| location_slug | Short identifier for the location, used in filters and links. |
| sampled_at | When the sample was taken (ISO 8601, UTC). |
| parameter_name | What was measured, e.g. E. coli. |
| parameter_unit | Unit of the value, e.g. CFU/100ml. |
| value | The measured count, or the detection bound for < and > results. |
| qualifier | eq (exact), lt (below detection limit) or gt (above counting limit). |
| status | pass, warn or fail against the thresholds on the Explain readings page. |
| method_title | Testing method used, e.g. Laboratory. |
| public_note | Optional public note about the sample. |