Sarawak Data

Water Consumption Analysis in Sarawak 2017-2018

Water Consumption Analysis in Sarawak

Source	Water Consumption Analysis in Sarawak
URL	https://data.sarawak.gov.my/home/data/resource_download/757
Description	Water Consumption Analysis in Sarawak 2017 - Sep 2018
Format	XLSX
File Size	18 KB
Downloads	57
Package ID	08269c9e-21f9-46d8-979d-54db919fd74c
Resource ID	f060375b-6ddf-4799-ae2b-0526a1f97ea6
Revision ID	978d26f4-23d7-4190-ad6c-7e68d73436e0
Published Date	19/11/2018 04:26 AM
Last Modified	19/11/2018 04:26 AM
MD5 Checksum	db4fedd73fb77ea50156121451916d34

Data Explorer

Columns

No	Field	Type
1	_id	Integer
2	Year	Numeric
3	Month	Text
4	Division	Text
5	Domestic Consumption	Numeric
6	Domestic / Commercial Consumption	Numeric
7	Commercial Consumption	Numeric
8	Industrial Consumption	Numeric
9	Processed Consumption	Numeric
10	Special Commercial Consumption	Numeric
11	Standpipes Consumption	Numeric
12	Others Consumption	Numeric
13	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=f060375b-6ddf-4799-ae2b-0526a1f97ea6&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=f060375b-6ddf-4799-ae2b-0526a1f97ea6&q=jones

Example: Javascript »

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

var data = {
    resource_id: 'f060375b-6ddf-4799-ae2b-0526a1f97ea6', // 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=f060375b-6ddf-4799-ae2b-0526a1f97ea6&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()