DataBrighten

    Intentional homicides (per 100,000 people)

    4,065 × 6rows × columns: 196 countries, 1990 to 2023

    Real data: World Bank, World Development Indicators, indicator VC.IHR.PSRC.P5, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows4,065country-year values
    Countries196with at least one value
    Years1990 – 202334 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    An intentional homicide is defined as an unlawful death inflicted upon a person with the intent to cause death or serious injury.

    Limits and exceptions (World Bank note)

    Statistics reported to the United Nations in the context of its various surveys on crime levels and criminal justice trends are incidents of victimization that have been reported to the authorities in any given country. That means that this data is subject to the problems of accuracy of all official crime data. The survey results provide an overview of trends and interrelationships between various parts of the criminal justice system to promote informed decision-making in administration, nationally and internationally. The degree to which different societies apportion the level of culpability to acts resulting in death is also subject to variation. Consequently, the comparison between countries and regions of "intentional homicide", or unlawful death purposefully inflicted on a person by another person, is also a comparison of the extent to which different countries deem that a killing be classified as such, as well as the capacity of their legal systems to record it. Caution should therefore be applied when evaluating and comparing homicide data.

    The numbers in 2022

    In 2022, 105 countries have a value. The highest is Turks and Caicos Islands (76.34); the lowest is Qatar (0.0691). The median country value is 2.27. The World Bank's World aggregate for 2023 is 5.2.

    Top 10 countries, 2022

    per 100,000 people

    Source: World Bank, VC.IHR.PSRC.P5, retrieved 19 November 2026. Computed from intentional-homicides-per-100-000-people.csv.

    Highest, 2022

    #CountryValue
    1Turks and Caicos Islands76.34
    2Jamaica53.11
    3South Africa43.72
    4St. Vincent and the Grenadines41.16
    5Trinidad and Tobago40.44
    6St. Lucia36.92
    7Honduras34.97
    8Bahamas, The32.2
    9Dominica28.43
    10Belize28.06

    Lowest, 2022

    #CountryValue
    1Qatar0.0691
    2Singapore0.124
    3Bahrain0.196
    4Japan0.231
    5Oman0.254
    6Macao SAR, China0.284
    7Indonesia0.304
    8Hong Kong SAR, China0.402
    9Switzerland0.478
    10Korea, Rep.0.496
    How many countries report, by decade
    DecadeMost countries in one year
    1990s105
    2000s152
    2010s157
    2020s129

    World aggregate by year

    As published by the World Bank (in the regions file, not the country file).

    YearWorld
    20235.2
    20225.3
    20215.5
    20205.3
    20195.4
    20185.7
    20175.9
    20166
    20155.9
    20146.1
    20136.1
    20126.2

    By region, 2022

    World Bank regionValue
    Latin America & Caribbean 20
    Sub-Saharan Africa 12.6
    North America6.1
    Middle East, North Africa, Afghanistan & Pakistan3.8
    South Asia2.7
    Europe & Central Asia2.2
    East Asia & Pacific0.8

    First rows

    intentional-homicides-per-100-000-people.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20094.05954969836362
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20103.47545228477135
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20114.19453539608613
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20126.37433845786952
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20159.95218590955213
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20166.6799974594108
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20176.79202120758186
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20186.73324816708819

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy, World Bank name
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearnumberCalendar year of the value
    valuenumberIntentional homicides (per 100,000 people), exactly as the World Bank API returns it (not rounded)

    Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.

    Practice questions

    answers computed from the file

    Which country has the highest value in 2022?

    Turks and Caicos Islands, with 76.34.

    Excel (on the long CSV: E = year, F = value)

    =FILTER(A2:A100000,(E2:E100000=2022)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2022)))

    SQL (table wb = the CSV)

    SELECT country, value FROM wb WHERE year = 2022
      AND value = (SELECT MAX(value) FROM wb WHERE year = 2022);

    pandas (df = pd.read_csv("intentional-homicides-per-100-000-people.csv"))

    y = df[df.year == 2022]
    y[y.value == y.value.max()][["country", "value"]]

    File: intentional-homicides-per-100-000-people.csv

    How many countries report a value for 2022?

    105 of the 217 economies in the file's country list.

    Excel (on the long CSV: E = year, F = value)

    =COUNTIF(E2:E100000,2022)

    SQL (table wb = the CSV)

    SELECT COUNT(*) FROM wb WHERE year = 2022;

    pandas (df = pd.read_csv("intentional-homicides-per-100-000-people.csv"))

    (df.year == 2022).sum()

    File: intentional-homicides-per-100-000-people.csv

    What is the median across countries in 2022?

    2.27 (median of the 105 country values; not a World Bank aggregate).

    Excel (on the long CSV: E = year, F = value)

    =MEDIAN(FILTER(F2:F100000,E2:E100000=2022))

    SQL (table wb = the CSV)

    -- SQLite has no MEDIAN(); this picks the middle value(s)
    SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2022 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2022) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2022));

    pandas (df = pd.read_csv("intentional-homicides-per-100-000-people.csv"))

    df[df.year == 2022]["value"].median()

    File: intentional-homicides-per-100-000-people.csv

    Which country rose the most between 2012 and 2022?

    Ecuador: from 12.34 to 27.41, a rise of 15.07 (out of 98 countries with both years).

    Excel (on the long CSV: E = year, F = value)

    Use the wide file (intentional-homicides-per-100-000-people-wide.csv): add a column = [2022] - [2012], then sort it largest to smallest.

    SQL (table wb = the CSV)

    SELECT a.country, b.value - a.value AS rise FROM wb a JOIN wb b ON a.iso3 = b.iso3
    WHERE a.year = 2012 AND b.year = 2022 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("intentional-homicides-per-100-000-people.csv"))

    w = df.pivot(index="country", columns="year", values="value")
    (w[2022] - w[2012]).dropna().nlargest(1)

    File: intentional-homicides-per-100-000-people.csv

    Which year has the most countries reporting?

    2010, with 157 countries. (Later years are still filling in as countries report.)

    Excel (on the long CSV: E = year, F = value)

    Make a pivot table: year in Rows, Count of value in Values, then sort by the count.

    SQL (table wb = the CSV)

    SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;

    pandas (df = pd.read_csv("intentional-homicides-per-100-000-people.csv"))

    df.groupby("year").size().sort_values(ascending=False).head(1)

    File: intentional-homicides-per-100-000-people.csv