Sarawak Data

Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2019 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/786
Description	Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2019
Format	XLSX
File Size	10 KB
Downloads	110
Package ID	e517eb76-7521-4164-98a0-1546195e1cbf
Resource ID	4b739300-3551-4960-9725-49f0eb8b7a2b
Revision ID	ae441cd5-f752-4450-a413-60d98273a9c9
Published Date	21/05/2019 02:54 AM
Last Modified	20/01/2021 07:12 AM
MD5 Checksum	f4137128323afcda444ff4f384ff1d48

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=4b739300-3551-4960-9725-49f0eb8b7a2b&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=4b739300-3551-4960-9725-49f0eb8b7a2b&q=jones

Example: Javascript »

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

var data = {
    resource_id: '4b739300-3551-4960-9725-49f0eb8b7a2b', // 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=4b739300-3551-4960-9725-49f0eb8b7a2b&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()