Sarawak Data

Water Consumption Analysis in Sarawak By Division and Type of Usage for Year 2017

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/672
Description	Water Consumption Analysis in Sarawak By Division and Type of Usage by Month for Year 2017
Format	XLSX
File Size	11 KB
Downloads	0
Package ID	e517eb76-7521-4164-98a0-1546195e1cbf
Resource ID	8d005ba1-b2e0-498e-85df-32af03726157
Revision ID	ae441cd5-f752-4450-a413-60d98273a9c9
Published Date	26/10/2018 01:43 AM
Last Modified	20/01/2021 07:12 AM
MD5 Checksum	4c83d9a778eece63ff095d6cbc20d4c6

Data Explorer

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=8d005ba1-b2e0-498e-85df-32af03726157&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=8d005ba1-b2e0-498e-85df-32af03726157&q=jones

Example: Javascript »

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

var data = {
    resource_id: '8d005ba1-b2e0-498e-85df-32af03726157', // 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=8d005ba1-b2e0-498e-85df-32af03726157&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()