Sarawak Data

Water Consumption Analysis Year 2017 Water Consumption Analysis Year 2017

Source	Water Consumption Analysis Year 2017
URL	https://data.sarawak.gov.my/home/data/resource_download/134
Description	-
Format	XLSX
File Size	18 KB
Downloads	176
Package ID	4605a093-10fe-49a8-a62d-a3d0fca197a0
Resource ID	07bc2688-e0a8-40c0-90e6-b3d2a82e8ad2
Revision ID	49dfd500-0455-4b05-8493-7e9db0db3cb5
Published Date	04/05/2018 03:13 AM
Last Modified	04/05/2018 03:13 AM
MD5 Checksum	c16e26d9a2aa259465eebb21e3c56b9e

Data Explorer

Download

Columns

No	Field	Type
1	_id	Integer
2	Month	Text
3	Domestic	Numeric
4	Domestic / Commercial	Numeric
5	Commercial	Numeric
6	Standpipes	Numeric
7	Processed	Numeric
8	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=07bc2688-e0a8-40c0-90e6-b3d2a82e8ad2&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=07bc2688-e0a8-40c0-90e6-b3d2a82e8ad2&q=jones

Example: Javascript »

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

var data = {
    resource_id: '07bc2688-e0a8-40c0-90e6-b3d2a82e8ad2', // 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=07bc2688-e0a8-40c0-90e6-b3d2a82e8ad2&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()