Sarawak Data

PRODUCTION VS CONSUMPTION FOR YEAR 2017 PRODUCTION VS CONSUMPTION - RURAL WATER SUPPLY DEPARTMENT

Source	PRODUCTION VS CONSUMPTION - RURAL WATER SUPPLY DEPARTMENT
URL	https://data.sarawak.gov.my/home/data/resource_download/770
Description	PRODUCTION VS CONSUMPTION FOR YEAR 2017
Format	XLSX
File Size	14 KB
Downloads	49
Package ID	db0eb060-00cc-4ab0-aa4a-25123a1c8d2b
Resource ID	737808b4-2db9-4722-8a54-6692b3a680e3
Revision ID	ffd6dcb1-6ec8-4cc6-b41d-d4d7792ab4b7
Published Date	04/12/2018 03:06 AM
Last Modified	04/12/2018 03:10 AM
MD5 Checksum	9c3cb0e8faf6a4f898c848bba0268221

Data Explorer

Download

Columns

No	Field	Type
1	_id	Integer
2	Month	Text
3	Production of Water ('000 meter padu/'000 cu. metres)	Numeric
4	Domestic	Numeric
5	Industry & Commercial	Numeric
6	Government	Numeric
7	Others	Numeric
8	Total Consumption of Water ('000 meter padu/cu.metres)	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=737808b4-2db9-4722-8a54-6692b3a680e3&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=737808b4-2db9-4722-8a54-6692b3a680e3&q=jones

Example: Javascript »

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

var data = {
    resource_id: '737808b4-2db9-4722-8a54-6692b3a680e3', // 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=737808b4-2db9-4722-8a54-6692b3a680e3&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()