A Singapore Government Agency Website

How to identify

Official website links end with .gov.sg

Government agencies communicate via .gov.sg websites (e.g. go.gov.sg/open). Trusted websites

Secure websites use HTTPS

Look for a lock () or https:// as an added precaution. Share sensitive information only on official, secure websites.

Real-time APIs will be unavailable from September 19th, 2024, 06:00 pm to September 19th, 2024, 10:00 pm due to upstream service's system maintenance. We apologise for the inconvenience caused.

Drinking water quality datasets

Data from Jan 2019 to Dec 2022Updated 4 months ago

PUB (PUB, Singapore's national water agency)

Data explorer

Drinkingwaterqualitydatasets.csv (252 rows, 8.3 KB)

Year Datetime (Year) "YYYY"	Water quality parameter Text (General)	Average value Text (General)	Unit Text (General)
(Null)0.0%	(Null)0.0%	(Null)0.0%	(Null)0.0%
2019	Escherichia coli (E. coli)	<1	cfu/100ml
2019	Colour	<5	Hazen
2019	Conductivity	200	uS/cm
2019	Odour	Unobjectionable	TON
2019	pH Value	8.1	Units
2019	Total Dissolved Solid	131	mg/L
2019	Turbidity	0.13	NTU
2019	Gross Alpha	0.043	Bq/L
2019	Gross Beta	0.1426	Bq/L
2019	Radon 222	<0.6	Bq/L

Column legend

Title	Column name	Data type	Unit of measure	Description
Year	year	Datetime (Year) "YYYY"	-	-
Water quality parameter	water_quality_parameter	Text (General)	-	-
Average value	average_value	Text (General)	-	-
Unit	unit	Text (General)	-	-

Sample OpenAPI query

This code can be used to test a sample API query. It retrieves the data catalogue of this dataset. For a complete guide on query parameters and syntax, please refer to the API documentation. Try it out on your browser to see the response schema.

import requests
          
datasetId = "d_f397c39929978d3047e0e32430c6763b"
url = "https://data.gov.sg/api/action/datastore_search?resource_id="  + datasetId 
        
response = requests.get(url)
print(response.json())

About this dataset

Contact

feedback@data.gov.sg

Created on

25 May 2017

Licence

Free forever for personal or commercial use, under the Open Data Licence.

Agency

PUB (PUB, Singapore's national water agency)

Dataset usage

470
Views

74
Downloads

28
API calls