Extraction of Minerals by State and Commodity
Data as of 2021Annual extraction of mineral commodities by state from 2016 to 2021.
0 views·0 downloads
How is this data produced?
Data on mineral extraction in Malaysia is produced by the Mineral Intelligence Unit based on data collected via establishment-level surveys and censuses conducted by the Department of Mineral and Geoscience (JMG), in collaboration with the Department of Statistics Malaysia (DOSM). Accordingly, this data reflects the extractive activities of establishments registered with the DMG only. The data shown here is also used for the production of Malaysia's official GDP statistics.
From a definitional perspective, it should be noted that:
- The production of non-metallic aggregates in Sabah and Sarawak includes gravel.
- Silica production includes silica sand, as well as sand as a by-product of tin mining and crushed quartz rock.
What caveats I should bear in mind when using this data?
National totals may be slightly different to the sum of state values due to rounding.
Publication(s) using this data
—
Metadata
Dataset description
Annual extraction of mineral commodities by state from 2016 to 2021.
Variable definitions
- State
- Date
- Commodity Type
- Commodity
- Extraction
Name in Dataset | Variable | Definition |
|---|---|---|
state (Categorical) | State | One of 16 states, or Malaysia; note that W.P. Labuan is not present in the dataset due to an absence of mineral extraction activitiy in the state. |
date (Date) | Date | The date in YYYY-MM-DD format, with MM-DD set to 01-01 since the data is at annual frequency |
type (Categorical) | Commodity Type | The type of commodity in snake case; either energy ('energy'), metallic ('metallic') or non-metallic ('non_metallic'). |
commodity (Categorical) | Commodity | The mineral commodity extracted in snake case, such as coal, bauxite, gold, feldspare, limestone, etc. |
production (Float) | Extraction | The quantity of the commodity extracted; all values are in metric tonnes except for gold and silver, which are denominated in grammes |
Last updated:
01 Sept 2024, 12:00
Next update:
N/A
Data source(s)
- JMG
- DOSM
URLs to dataset
License
This data is made open under the Creative Commons Attribution 4.0 International License (CC BY 4.0). A copy of the license is available Here.
Download
Data
Full Dataset (CSV)
Recommended for individuals seeking an Excel-friendly format.
0
Full Dataset (Parquet)
Recommended for data scientists seeking to work with data via code.
0
Code
Connect directly to the data with Python.
# If not already installed, do: pip install pandas fastparquet
import pandas as pd
URL_DATA = 'https://storage.data.gov.my/mining/mineral_extraction.parquet'
df = pd.read_parquet(URL_DATA)
if 'date' in df.columns: df['date'] = pd.to_datetime(df['date'])
print(df)Sample OpenAPI query
The following code is an example of how to make an API query to retrieve the data catalogue mentioned above. You can use different programming languages by switching the code accordingly. For a complete guide on possible query parameters and syntax, please refer to the official Open API Documentation.
import requests
import pprint
url = "https://api.data.gov.my/data-catalogue?id=mineral_extraction&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data