Sarawak Data

Sarawak Export by Commodity Sections_December 2020 Sarawak Export By Commodity Sections_December 2020

Source	Sarawak Export By Commodity Sections_December 2020
URL	https://data.sarawak.gov.my/home/data/resource_download/1069
Description	Sarawak Export By Commodity Sections from January 2017 until December 2020
Format	XLSX
File Size	13 KB
Downloads	85
Package ID	665631a5-3ebc-41ac-905e-4c06631c39c2
Resource ID	61d5a522-7327-47cf-b25a-e1ad61b9800b
Revision ID	410d7b80-7154-42c9-8862-15945a236d43
Published Date	26/02/2021 02:26 AM
Last Modified	26/02/2021 02:26 AM
MD5 Checksum	1c776ecbc9b37cf3ce659ef18fa4307d

Data Explorer

Download

Columns

No	Field	Type
1	_id	Integer
2	Commodity Sections	Text
3	Unit Value	Text
4	2017-01-01 00:00:00	Numeric
5	2017-02-01 00:00:00	Numeric
6	2017-03-01 00:00:00	Numeric
7	2017-04-01 00:00:00	Numeric
8	2017-05-01 00:00:00	Numeric
9	2017-06-01 00:00:00	Numeric
10	2017-07-01 00:00:00	Numeric
11	2017-08-01 00:00:00	Numeric
12	2017-09-01 00:00:00	Numeric
13	2017-10-01 00:00:00	Numeric
14	2017-11-01 00:00:00	Numeric
15	2017-12-01 00:00:00	Numeric
16	2018-01-01 00:00:00	Numeric
17	2018-02-01 00:00:00	Numeric
18	2018-03-01 00:00:00	Numeric
19	2018-04-01 00:00:00	Numeric
20	2018-05-01 00:00:00	Numeric
21	2018-06-01 00:00:00	Numeric
22	2018-07-01 00:00:00	Numeric
23	2018-08-01 00:00:00	Numeric
24	2018-09-01 00:00:00	Numeric
25	2018-10-01 00:00:00	Numeric
26	2018-11-01 00:00:00	Numeric
27	2018-12-01 00:00:00	Numeric
28	2019-01-01 00:00:00	Numeric
29	2019-02-01 00:00:00	Numeric
30	2019-03-01 00:00:00	Numeric
31	2019-04-01 00:00:00	Numeric
32	2019-05-01 00:00:00	Numeric
33	2019-06-01 00:00:00	Numeric
34	2019-07-01 00:00:00	Numeric
35	2019-08-01 00:00:00	Numeric
36	2019-09-01 00:00:00	Numeric
37	2019-10-01 00:00:00	Numeric
38	2019-11-01 00:00:00	Numeric
39	2019-12-01 00:00:00	Numeric
40	2020-01-01 00:00:00	Numeric
41	2020-02-01 00:00:00	Numeric
42	2020-03-01 00:00:00	Numeric
43	2020-04-01 00:00:00	Numeric
44	2020-05-01 00:00:00	Numeric
45	2020-06-01 00:00:00	Numeric
46	2020-07-01 00:00:00	Numeric
47	2020-08-01 00:00:00	Numeric
48	2020-09-01 00:00:00	Numeric
49	2020-10-01 00:00:00	Numeric
50	2020-11-01 00:00:00	Numeric
51	2020-12-01 00:00:00	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=61d5a522-7327-47cf-b25a-e1ad61b9800b&limit=5

Query example (results containing 'jones')

https://catalog.sarawak.gov.my/api/3/action/datastore_search?resource_id=61d5a522-7327-47cf-b25a-e1ad61b9800b&q=jones

Example: Javascript »

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

var data = {
    resource_id: '61d5a522-7327-47cf-b25a-e1ad61b9800b', // 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=61d5a522-7327-47cf-b25a-e1ad61b9800b&limit=5&q=title:jones'
fileobj = urllib.urlopen(url)
print fileobj.read()