SDG 16-1-1: Victims of Intentional Homicide
Data as of 2022Number of victims of intentional homicide per 100,000 population by sex, as per the specifications of SDG Indicator 16-1-1.
0 views·0 downloads
How is this data produced?
This dataset is produced based on the individual-level administrative records collected by the Royal Malaysia Police (PDRM), which is the single source of truth for data on crimes in Malaysia. Besides for operational purposes, this data is reported as part of Malaysia's monitoring of the Sustainable Development Goals (SDGs), in line with the most recent SDG Global Indicator Framework.
What caveats I should bear in mind when using this data?
The data is subject to revision in future updates.
Publication(s) using this data
—
Metadata
Dataset description
Number of victims of intentional homicide per 100,000 population by sex, as per the specifications of SDG Indicator 16-1-1.
Variable definitions
- State
- Date
- Sex
- Victims per 100,000 Population
Name in Dataset | Variable | Definition |
|---|---|---|
state (Categorical) | State | One of 16 states, or Malaysia |
date (Date) | Date | The date in YYYY-MM-DD format, with MM-DD set to 01-01 as the data is at annual frequency. |
sex (Categorical) | Sex | Either both sexes ('both'), male ('male') or female ('female') |
value (Float) | Victims per 100,000 Population | The number of victims of intentional homicide per 100,000 population |
Last updated:
01 Sept 2024, 12:00
Next update:
N/A
Data source(s)
- Royal Malaysia Police
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.dosm.gov.my/sdg/sdg_16-1-1.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=sdg_16-1-1&limit=3"
response_json = requests.get(url=url).json()
pprint.pprint(response_json)
© 2024 Public Sector Open Data