Sarawak Data

Monthly Water Consumption Analysis by Charge Codes For 2018

Monthly Water Consumption Analysis by Charge Codes

Source	Monthly Water Consumption Analysis by Charge Codes
URL	https://data.sarawak.gov.my/home/data/resource_download/698
Description	Monthly Water Consumption Analysis by Charge Codes For 2018 (volume in M3)
Format	XLSX
File Size	13 KB
Downloads	0
Package ID	ca87e543-6f19-46ef-8deb-3693ed9b2dd7
Resource ID	6ad44b86-9ca5-4e9f-872d-21b89eb6a20e
Revision ID	18ffba10-d147-4fe5-96f3-c416bd7b8eff
Published Date	30/10/2018 04:12 AM
Last Modified	21/05/2019 02:53 AM
MD5 Checksum	1d977e2392a961d2d771eb8a6aef331d

Data Explorer

Columns

No	Field	Type
1	_id	Integer
2	Charge Code	Text
3	Charge Code Description	Text
4	January	Text
5	February	Text
6	March	Numeric
7	April	Numeric
8	May	Numeric
9	June	Numeric
10	July	Text
11	August	Numeric
12	September	Numeric
13	October	Numeric
14	November	Numeric
15	December	Numeric
16	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=6ad44b86-9ca5-4e9f-872d-21b89eb6a20e&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=6ad44b86-9ca5-4e9f-872d-21b89eb6a20e&q=jones

Example: Javascript »

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

var data = {
    resource_id: '6ad44b86-9ca5-4e9f-872d-21b89eb6a20e', // 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=6ad44b86-9ca5-4e9f-872d-21b89eb6a20e&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()