Sarawak Data

Production of Water for 2018 Monthly Production of Water

Source	Monthly Production of Water
URL	https://data.sarawak.gov.my/home/data/resource_download/693
Description	Production of Water for 2018
Format	XLSX
File Size	9 KB
Downloads	51
Package ID	2af14ad5-d8c0-478b-84f3-f3a83da61ff8
Resource ID	c4d32da6-0a88-4b0f-83ee-b3d1a5e00acb
Revision ID	f9f3831c-aa24-4de1-b465-5e782711faec
Published Date	30/10/2018 01:30 AM
Last Modified	21/05/2019 02:50 AM
MD5 Checksum	b87335aac231564f5f66f3febd9305e0

Data Explorer

Download

Columns

No	Field	Type
1	_id	Integer
2	Description	Text
3	January	Numeric
4	February	Numeric
5	March	Numeric
6	April	Numeric
7	May	Numeric
8	June	Numeric
9	July	Numeric
10	August	Numeric
11	September	Numeric
12	October	Numeric
13	November	Numeric
14	December	Numeric
15	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=c4d32da6-0a88-4b0f-83ee-b3d1a5e00acb&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=c4d32da6-0a88-4b0f-83ee-b3d1a5e00acb&q=jones

Example: Javascript »

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

var data = {
    resource_id: 'c4d32da6-0a88-4b0f-83ee-b3d1a5e00acb', // 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=c4d32da6-0a88-4b0f-83ee-b3d1a5e00acb&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()