State Government Revenue
Data as of 2022Annual data on state government revenue by source, covering tax, non-tax, and non-revenue receipts.
0 views·0 downloads
How is this data produced?
This dataset is produced from the financial statements of state governments in Malaysia, as published by the National Audit Department in the Auditor General's Report. Categorisation of revenue is based on the Classification Codes for Revenue and Expenditure published by the Federal Treasury.
What caveats I should bear in mind when using this data?
The latest actual revenue data (rather than projected revenue) is as of 2022, except for Sarawak which is as of 2020. Values for Sarawak will be updated to 2022 when available. Furthermore, it should be noted that because this dataset shows the revenue of state governments, it does not include the Federal Territories of Kuala Lumpur, Labuan, and Putrajaya, which do not have their own State Legislative Assemblies.
Publication(s) using this data
—
Metadata
Dataset description
Annual data on state government revenue by source, covering tax, non-tax, and non-revenue receipts.
Variable definitions
- Date
- State
- Revenue Category
- Acutal Revenue
Name in Dataset | Variable | Definition |
|---|---|---|
date (Date) | Date | The date in YYYY-MM-DD format, with MM-DD set to 01-01 since the data is at annual frequency |
state (Categorical) | State | One of 13 states with their own State Legislative Assembly (does not include Federal Territories) |
category (Categorical) | Revenue Category | Either total revenue ('total') or the category of revenue comprising tax revenue ('revenue_60000'), non-tax revenue ('revenue_70000'), and non-revenue receipts ('revenue_80000') |
expenditure (Float, RM mil) | Acutal Revenue | Actual revenue for the given category; note that this may be different from the original projection presented in the state budget |
Last updated:
01 Sept 2024, 12:00
Next update:
N/A
Data source(s)
- National Audit Department
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/publicadmin/state_finance_revenue.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=state_finance_revenue&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data