Water Consumption by State and Sector
Data as of 31 Dec 2022, 23:59Annual water consumption by state, broken down into domestic and non-domestic sectors.
0 views·0 downloads
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. Classification into domestic and non-domestic sectors is based on the purpose of water usage registered with the operator for each user account. 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).
- 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?
Data for the most recent year is provisional and may be revised in future updates.
Publication(s) using this data
—
Metadata
Dataset description
Annual water consumption by state, broken down into domestic and non-domestic sectors.
Variable definitions
- Date
- State
- Sector
- Water Consumption
Name in Dataset | Variable | Definition |
|---|---|---|
date (Date) | Date | The date in YYYY-MM-DD format, with DD set to 01 as the data is at monthly frequency |
state (Categorical) | State | One of 16 states, or Malaysia, which has been included for ease of analysis |
sector (Categorical) | Sector | Either the domestic ('domestic') or non-domestic ('nondomestic') sector |
value (Float) | Water Consumption | Amount of water consumed in millions of litres per day (MLD) |
Last updated:
01 Sept 2024, 12:00
Next update:
N/A
Data source(s)
- The National Water Services Commission
- Ministry of Natural Resources & Environmental Sustainability
- Department of Statistics Malaysia
URLs to dataset
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)
Recommended for individuals seeking an Excel-friendly format.
0
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_consumption.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_consumption&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data