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()

Number of TNB Customers by Sector

URL: https://archive.data.gov.my/data/dataset/31c7a88c-f95a-48c5-a282-00d65d5d41b7/resource/138057ac-18f1-4b4a-ad96-3f00ee118597/download/number-of-tnb-customers-by-sector.xlsx

Total number of customers in Peninsular Malaysia registered under TNB for electricity supply and they are categorised by sector.

Fullscreen Embed

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

Download resource

Data Dictionary

Column	Type	Label	Description
Year	numeric
Domestic	numeric
Commercial	numeric
Industry	numeric
Public Lighting	numeric
Mining	numeric
Others (Including Agriculture)	numeric
Free Units	numeric
TOTAL	numeric

Additional Information

Field	Value
Data last updated	October 8, 2018
Metadata last updated	October 8, 2018
Created	October 8, 2018
File Format	XLSX
License	Creative Commons Attribution

Openness:
Reason: Content of file appeared to be format "XLS" which receives openness score: 2.
Checked: August 22, 2020

CKAN Data API

Number of TNB Customers by Sector

Embed resource view

Data Dictionary

Additional Information