Talk:List of countries by intentional homicide rate

Note: See table updating info: /LibreOffice Calc instructions and /Excel instructions.

map no longer correlates with data in the table

— Preceding unsigned comment added by 2603:8001:a702:13a8:351a:90bc:15e4:a903 (talk • contribs) 29 May 2022 (UTC)

2022 numbers are available. Need full table update

Vgbyp and others. I don't know if I have the energy, health, and time to do this. See the help subpages linked from the top of this talk page.

See the first reference link. From that page there is a dataset link to download all the data.

See the visual editor section of Help:Creating tables#Tables and visual editor for how-to info on creating a wiki table from a spreadsheet. --Timeshifter (talk) 17:25, 7 December 2023 (UTC)

Just so others know, Vgbyp has updated the numbers to the latest available year. --Timeshifter (talk) 19:59, 28 December 2023 (UTC)

I updated the link (above) for help. Here is the current link:

Help:Creating tables#Tables and visual editor. --Timeshifter (talk) 12:50, 2 April 2024 (UTC)

Several countries missing

Data for several countries is missing from both (the current version of) this table and from the UNODC source. This data was previously available in the article's table, but was removed on 2021-11-02. Old tables with the now-missing data can be viewed here. Missing countries include Chad, Comoros, both Republics of the Congo, Côte d'Ivoire, Equatorial Guinea, Gabon, Gambia, Guinea, North Korea, Laos, Libya, Madagascar, Mali, Mauritania, F.S.Micronesia, Nauru, Somalia, Togo, Vanuatu, and Zimbabwe. Does anyone know why this data is missing from UNODC? Should we use the pre-2021-11-02 data anyway? Lebonk (talk) 05:56, 1 April 2024 (UTC)

You added Djibouti to the article. I noticed that Djibouti is missing from the main UNODC source page with the tables and menus. But it is found in the UNODC downloadable dataset.

Creating a table with the latest available year from a dataset is not easy. See the talk subpages with instructions. They are linked at the top of the subpages. They need to be updated. I have not had the time, health, or energy to figure it out very far. Feel free to do so. If you do, please overwrite the instructions, or start another instruction subpage. It would help with many list articles. To be useful it has to be detailed without skipping any steps.

Feel free to add countries if you can find the data in one of the UNODC sources. Please mention in your edit summary which UNODC source: Tables or dataset. --Timeshifter (talk) 15:44, 1 April 2024 (UTC)

Denmark vs Denmark

As a Dane I have to admit I find it a bit misleading that the number of homicides in the row labeled "Denmark" is taken from UNODC, as it only provides the number of homicides in the *kingdom* of Denmark; not the *country* of Denmark.

Just as an example (and to maybe put things in perspective): in 2022 there were 58 homicides in the *kingdom* of Denmark [1], as correctly noted in the table. However, "only" 39 of them were actually committed in the *country* of Denmark [2], which means that *19* (*32.76%*) of them were committed outside the country.

Is this fair? Are homicides committed in Puerto Rico, for example, also included in the row labled "United States"? 194.62.169.4 (talk) 17:09, 9 April 2024 (UTC)

I don't read Danish. So I couldn't figure out the Danish source. The UNODC source you linked to just says "Denmark". So I am assuming that you are getting your numbers from the Danish source as concerns the kingdom of Denmark.

Greenland is in the table here, and only had 3 homicides for the latest year (2016) that UNODC has.

Faroe Islands is not listed separately at that UNODC link, or in the table here.

Maybe you can dig around the UNODC site to find out if they specifically say whether their numbers cover all of the kingdom or just metropolitan Denmark. Then we can link to that UNODC page, and add a note below the table. With a link from within the table.

I don't have the time. So you or someone else will have to at least do the research. --Timeshifter (talk) 22:24, 9 April 2024 (UTC)

2023 data from UNODC has been added to the table

See diff.

Vgbyp. Thanks! Did you use Excel again? If so can you update and clarify the instructions at Talk:List of countries by intentional homicide rate/Excel instructions.

It would be nice to know how to do it simply in LibreOffice Calc too. See:

• Talk:List of countries by intentional homicide rate/LibreOffice Calc instructions

It is currently way too complex. So complex I can't figure it out from the old forum thread. If I could find a simpler way with LibreOffice I could use it on many state and country tables.

I am understanding more and more of what you wrote in the Excel instructions. And I think I can apply them to Calc. I will need to experiment further.

In your Excel instructions you said you manually compared the results to the article table: "It is then trivial to compare the existing Wikipedia table to the UNODC table. It cannot automatically generate the entire table, but when there are just a few changes to the data, it is a simple and rather fast approach."

One thing I have figured out is this:

• Help:Tables and locations#Separate counts and rates to 2 columns.

Does this help you? --Timeshifter (talk) 00:01, 1 June 2024 (UTC)

Djibouti has no data on UNODC site

Its most recent data that I can find is 6.8/100,000 in 2015: https://www.ceicdata.com/en/djibouti/health-statistics/dj-intentional-homicides-per-100000-people

Countries with no data in ODC should be marked as such, not listed as 'zero'. — Preceding unsigned comment added by Copperknickers (talk • contribs) June 5, 2024 (UTC)

Copperknickers. Djibouti is missing from the main UNODC source page with the tables and menus. But it is found in the UNODC downloadable dataset according to a previous talk section. I don't know the year or rate. Please look it up in the dataset. LibreOffice Calc is free software for spreadsheets. --Timeshifter (talk) 05:00, 7 June 2024 (UTC)

Table fully updated from dataset retrieved June 24, 2024

Table has been fully updated. Including some country name clarifications, and some manual alphabetizing. See the last sections of the instructions:

• Talk:List of countries by intentional homicide rate/LibreOffice Calc instructions

Instructions are much simpler now. --Timeshifter (talk) 11:00, 2 July 2024 (UTC)

United Kingdom Inconsistency

The UNOCD lists the UK as: United Kingdom (England and Wales) United Kingdom (Northern Ireland) United Kingdom (Scotland)

Surely this article should follow that same template, however right now they are listed as: United Kingdom (England and Wales) Northern Ireland Scotland

Either all the nations should be listed with "United Kingdom" before them, or none of them should. Having 1/3 start with "United Kingdom" is confusing, incorrect, and causes the alphabetical order sorting to be inconsistent too.

ElleBlair (talk) 16:51, 1 November 2024 (UTC)

Agreed. I'd argue for changing them to the following:

• England and Wales (United Kingdom)
• Northern Ireland (United Kingdom)
• Scotland (United Kingdom)

This would make finding the right country easier, yet it will mention that all are parts of the UK. Vgbyp (talk) 12:06, 2 November 2024 (UTC)