Download

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Endpoints »

The Data API can be accessed via the following actions of the CKAN action API.

Create	`https://www.data.gov.my/data/api/3/action/datastore_create`
Update / Insert	`https://www.data.gov.my/data/api/3/action/datastore_upsert`
Query	`https://www.data.gov.my/data/api/3/action/datastore_search`
Query (via SQL)	`https://www.data.gov.my/data/api/3/action/datastore_search_sql`

Querying »

Query example (first 5 results)

https://www.data.gov.my/data/api/3/action/datastore_search?limit=5&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7

Query example (results containing 'jones')

https://www.data.gov.my/data/api/3/action/datastore_search?q=jones&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7

Query example (via SQL statement)

https://www.data.gov.my/data/api/3/action/datastore_search_sql?sql=SELECT * from "2903e39a-dde6-4053-818e-ebdb8066d8b7" WHERE title LIKE 'jones'

Example: Javascript »

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

        var data = {
          resource_id: '2903e39a-dde6-4053-818e-ebdb8066d8b7', // the resource id
          limit: 5, // get 5 results
          q: 'jones' // query for 'jones'
        };
        $.ajax({
          url: 'https://www.data.gov.my/data/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://www.data.gov.my/data/api/3/action/datastore_search?limit=5&resource_id=2903e39a-dde6-4053-818e-ebdb8066d8b7&q=title:jones'
      fileobj = urllib.urlopen(url)
      print fileobj.read()

Population with treated piped water by state...

URL: https://archive.data.gov.my/data/dataset/ac21d674-e58a-4aa1-a29f-5f347c8e6abd/resource/7b032cda-0156-47f2-ac55-2ada96334042/download/m-20210316115854_202103161158540_population-with-treated-piped-water-by-state-and-strata-malaysi.csv

This dataset shows the Population with treated piped water by state and strata, Malaysia, 2000-2019.Footnote Kelantan’s percentage of population served refers to percentage of population with connected water supply. The percentage of premises with connected services is low although there is accessibility; many households still using alternative sources i.e. ground water. For other states, population served based on percentage of population that have access to the public water supply system.Sarawak includes Northern Sarawak Water Board (LAKU), Sibu Water Board, Kuching Water Board and Sarawak Rural Water Supply Department. Figures for the rural areas of Sarawak exclude partly treated portable water supplied by the other agencies such as Ministry of Rural and Regional Development, Ministry of Health and private water supply.Selangor includes W.P. Kuala Lumpur and W.P. Putrajaya. Sources : Department of Statistics Malaysia

Fullscreen Embed

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

Column	Type	Label	Description

Additional Information

Field	Value
Data last updated	March 17, 2021
Metadata last updated	June 6, 2021
Created	March 17, 2021
File Format	CSV
License	Creative Commons Attribution

CKAN Data API

Population with treated piped water by state...

Embed resource view

Data Dictionary

Additional Information