Sarawak Data

Active consumers by charge codes for 2019

Active consumers by charge codes

Source	Active consumers by charge codes
URL	https://data.sarawak.gov.my/home/data/resource_download/886
Description	Number of active consumers by charge codes for 2019 where: W1 - Domestic W2 - Domestic/Commercial W3 - Commercial W4 - Industrial W5 - Special Commercial W6 - Schools W7 - Standpipes W8 - Ships
Format	XLSX
File Size	12 KB
Downloads	5
Package ID	7c930592-e8d2-4f2d-866a-697ffa6a3613
Resource ID	8de975e8-1442-483b-8bc8-96055497ffda
Revision ID	2f7472af-9e44-4066-a1da-48b0eb6dc5e3
Published Date	27/10/2020 03:02 AM
Last Modified	27/10/2020 03:02 AM
MD5 Checksum	f4769ceaa46937109625460680e46460

Data Explorer

Columns

No	Field	Type
1	_id	Integer
2	Charge Code Description	Text
3	2019-01-01 00:00:00	Text
4	2019-02-01 00:00:00	Text
5	2019-03-01 00:00:00	Text
6	2019-04-01 00:00:00	Text
7	2019-05-01 00:00:00	Text
8	2019-06-01 00:00:00	Text
9	2019-07-01 00:00:00	Text
10	2019-08-01 00:00:00	Text
11	2019-09-01 00:00:00	Text
12	2019-10-01 00:00:00	Text
13	2019-11-01 00:00:00	Text
14	2019-12-01 00:00:00	Text

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=8de975e8-1442-483b-8bc8-96055497ffda&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=8de975e8-1442-483b-8bc8-96055497ffda&q=jones

Example: Javascript »

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

var data = {
    resource_id: '8de975e8-1442-483b-8bc8-96055497ffda', // 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=8de975e8-1442-483b-8bc8-96055497ffda&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()