Access to Treated Water by State & Strata

Data as of 2022

Annual access of households to treated piped water by state and strata.

0 views·0 downloads

Table

Access to Treated Water

How is this data produced?

In Malaysia, all public and private operators of water provision services must be licensed by the National Water Services Commission (SPAN), and must report key performance indicators as specified in the terms of the license issued by SPAN. This dataset represents part of that reporting, and is compiled from the transactional operational records of water supply companies across Malaysia. Official data on the number of households from the Department of Statistics (DOSM) is used as the target population, or the denominator for calculating percentage coverage.

It should be noted that:

  • Data for Sarawak includes LAKU Management Sdn. Bhd. (Bintulu, Miri & Limbang, Sibu Water Board, Kuching Water Board and Sarawak Rural Water Supply Department (JBALB). Figures for the rural areas of Sarawak exclude partly treated portable water supplied by the other agencies such as Ministry of Rural and Regional Development, Ministry of Health and private water supply.
  • Data for W.P. Kuala Lumpur and W.P. Putrajaya are subsumed under Selangor.

What caveats I should bear in mind when using this data?

This data shows the proportion of households with connected water supply. This is different from access to the public water supply system, as households may choose not to have a connected water supply, and instead use alternative sources such as ground water. This phenomenon is especially prevalent in Kelantan.

Publication(s) using this data

Metadata

Dataset description

Annual access of households to treated piped water by state and strata.

Variable definitions
  • Date
  • State
  • Strata
  • Access (%)
Last updated:

01 Sept 2024, 12:00

Next update:

N/A

Data source(s)
  • SPAN
  • NRES
License

This data is made open under the Creative Commons Attribution 4.0 International License (CC BY 4.0). A copy of the license is available Here.

Download

Data
Full Dataset (CSV)

Full Dataset (CSV)

Recommended for individuals seeking an Excel-friendly format.

0

Full Dataset (Parquet)

Full Dataset (Parquet)

Recommended for data scientists seeking to work with data via code.

0

Code

Connect directly to the data with Python.

# If not already installed, do: pip install pandas fastparquet import pandas as pd URL_DATA = 'https://storage.data.gov.my/water/water_access.parquet' df = pd.read_parquet(URL_DATA) if 'date' in df.columns: df['date'] = pd.to_datetime(df['date']) print(df)

Sample OpenAPI query

The following code is an example of how to make an API query to retrieve the data catalogue mentioned above. You can use different programming languages by switching the code accordingly. For a complete guide on possible query parameters and syntax, please refer to the official Open API Documentation.

import requests import pprint url = "https://api.data.gov.my/data-catalogue?id=water_access&limit=3" response_json = requests.get(url=url).json() pprint.pprint(response_json)
jata negara

Department of Statistics Malaysia

© 2024 Public Sector Open Data