Sarawak Data

Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2020 WATER CONSUMPTION ANALYSIS IN SARAWAK BY DIVISION AND TYPE OF USAGE

Source	WATER CONSUMPTION ANALYSIS IN SARAWAK BY DIVISION AND TYPE OF USAGE
URL	https://data.sarawak.gov.my/home/data/resource_download/880
Description	Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2020
Format	XLSX
File Size	11 KB
Downloads	103
Package ID	e517eb76-7521-4164-98a0-1546195e1cbf
Resource ID	a604d4e4-a7b4-467b-8cf9-1bb42683340d
Revision ID	66404549-4df8-4846-aacc-bf1a4591dc69
Published Date	27/10/2020 04:33 AM
Last Modified	18/11/2022 05:07 AM
MD5 Checksum	dc0548f2f860f8df4272d288ed39576f

Data Explorer

Download

Columns

No	Field	Type
1	_id	Integer
2	Month	Date and Time
3	Division	Text
4	Domestic Consumption	Numeric
5	Domestic / Commercial Consumption	Numeric
6	Commercial Consumption	Numeric
7	Special Commercial Consumption	Numeric
8	Standpipes Consumption	Numeric
9	Other Consumption	Numeric
10	Total	Numeric

Endpoint »

The Data API can be accessed via the following actions of the CKAN action API.

Query	`https://catalog.sarawak.gov.my/api/3/action/datastore_search`

Querying »

Query example (first 5 results)

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=a604d4e4-a7b4-467b-8cf9-1bb42683340d&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=a604d4e4-a7b4-467b-8cf9-1bb42683340d&q=jones

Example: Javascript »

A simple ajax (JSONP) request to the data API using jQuery.

var data = {
    resource_id: 'a604d4e4-a7b4-467b-8cf9-1bb42683340d', // the resource id
    limit: 5, // get 5 results
    q: 'jones' // query for 'jones'
};
$.ajax({
    url: 'https://catalog.sarawak.gov.my/api/3/action/datastore_search',
    data: data,
    dataType: 'jsonp',
    success: function(data) {
        alert('Total results found: ' + data.result.total)
    }
});

Example: Python »

import urllib
url = 'https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=a604d4e4-a7b4-467b-8cf9-1bb42683340d&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()