State Government Expenditure
Data as of 2022Annual data on state government expenditure across various categories, including development expenditure (DE) and operating expenditure (OE).
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 expenditure 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 expenditure data (rather than budgeted expenditure) 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 expenditure 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 expenditure across various categories, including development expenditure (DE) and operating expenditure (OE).
Variable definitions
- Date
- State
- Expenditure Category
- Acutal Expenditure
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) | Expenditure Category | The category of expenditure; either development expenditure (DE), operating expenditure (OE), or a more detailed OE breakdown covering Emoluments (oe_10000), Services and Supplies (oe_20000), Assets (oe_30000), Fixed Payments (oe_40000), and Other Expenditures (oe_50000). |
expenditure (Float, RM mil) | Acutal Expenditure | Actual expenditure for the given category; note that this may be different from the originally budgeted amount |
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_expenditure.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_expenditure&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data