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)

United Kingdom

In the table showing rates and numbers of murders per country the sum of the numbers of homicides for the component parts of the UK (Northern Ireland - 21, Scotland - 58 and England & Wales 696) is 775 but the total for the UK is showing as 673 and so the rate per 100,000 for the UK is 1.0 while the component parts all have higher rates - 1.2 for England & Wales and 1.1 for Northern Ireland and also Scotland. 82.34.151.31 (talk) 23:55, 27 November 2023 (UTC)

The years are different. Vgbyp (talk) 08:18, 28 November 2023 (UTC)

Taiwan

Shouldn't there be an entry for Taiwan ? 184.171.141.56 (talk) 01:58, 3 December 2023 (UTC)

Vgbyp. I don't see Taiwan or mainland China here:

https://dataunodc.un.org/dp-intentional-homicide-victims

Where did you get the China numbers? --Timeshifter (talk) 06:49, 3 December 2023 (UTC)

There is data for China in the downloadable Dataset. I don't know why they don't include it into the web form. There is no mention of Taiwan in the Dataset though. Vgbyp (talk) 10:20, 3 December 2023 (UTC)

Column order and small screens

On my little phone, I can see 5 out of 7 columns of the table without scrolling to the left, which sadly shoves off the main topic of the article (homicide rate). And even on a large screen, a skinny table is easier to read than a fat table. The most important columns in the table are the Country and the Rate. It may be worth considering how the columns could be re-arranged in order to get the Country and Rate closer together. Certainly, the Year column could be moved all the way over to the right.

I would also suggest that the Region and Subregion columns are the least important, and maybe one or both of them are unnecessary.

Consider a rather different table to the current one:

Location	Rate	Count	Year
Afghanistan *	4.0	1,613	2021
Albania *	2.3	66	2021
Algeria	1.6	695	2021
American Samoa	0	0	2019
Andorra	2.6	2	2020
Angola	4.1	1,196	2016

Perhaps this is too much of a change for some, but please consider each of the suggestions separately. Wizmut (talk) 23:51, 6 December 2023 (UTC)

Some good ideas. I put columns of most importance to the left.

From above the table: "When the regions or subregions are sorted the countries are also alphabetically sorted within those regions or subregions. Then shift-click rates or counts to secondarily sort countries by rates or counts within the regions or subregions previously sorted."

So it is good to keep those columns. --Timeshifter (talk) 00:02, 7 December 2023 (UTC)

Good point, was not aware of that function.

And thank you for the quick change! Wizmut (talk) 00:03, 7 December 2023 (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)