Sarawak Data

Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2018 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/703
Description	Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2018 (January - December)
Format	XLSX
File Size	11 KB
Downloads	92
Package ID	e517eb76-7521-4164-98a0-1546195e1cbf
Resource ID	9fb6d987-d41c-4e01-b3c4-aee9aa162d14
Revision ID	ae441cd5-f752-4450-a413-60d98273a9c9
Published Date	31/10/2018 05:14 AM
Last Modified	20/01/2021 07:13 AM
MD5 Checksum	bb96a8aea542a1999500e91f50d59d62

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	Others 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=9fb6d987-d41c-4e01-b3c4-aee9aa162d14&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=9fb6d987-d41c-4e01-b3c4-aee9aa162d14&q=jones

Example: Javascript »

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

var data = {
    resource_id: '9fb6d987-d41c-4e01-b3c4-aee9aa162d14', // 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=9fb6d987-d41c-4e01-b3c4-aee9aa162d14&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()