Sarawak Data

Estimated Water Supply Coverage for Sarawak Data on Water Supply

Source	Data on Water Supply
URL	https://data.sarawak.gov.my/home/data/resource_download/478
Description	Estimated Water Supply Coverage for Sarawak
Format	XLSX
File Size	10 KB
Downloads	163
Package ID	b75789ae-5b53-4ea5-956e-6493d8a90faf
Resource ID	a7aa6c48-05d1-41ed-838a-10cfe1785d6a
Revision ID	9d9c84d9-7e2f-4b40-be48-a526a35ec6ab
Published Date	11/05/2018 03:27 PM
Last Modified	11/05/2018 07:14 PM
MD5 Checksum	2bacae6e52e13b23fd66f7cc2c41c1f6

Data Explorer

Download

Columns

No	Field	Type
1	_id	Integer
2	Year	Text
3	Overall No. of Household	Numeric
4	Percentage	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=a7aa6c48-05d1-41ed-838a-10cfe1785d6a&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=a7aa6c48-05d1-41ed-838a-10cfe1785d6a&q=jones

Example: Javascript »

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

var data = {
    resource_id: 'a7aa6c48-05d1-41ed-838a-10cfe1785d6a', // 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=a7aa6c48-05d1-41ed-838a-10cfe1785d6a&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()