User:Timeshifter/Sandbox248
List of countries by firearm-related death rate
- https://dataunodc.un.org/dp-intentional-homicide-victims - see UNODC dataset link.
Use LibreOffice Calc to filter for:
- "Firearms or explosives - firearms" in UNODC dataset. Then filter for:
- "Rate per 100,000 population".
Filter the above via LibreOffice Calc method described here:
Then delete all columns other than country, year, and value. Copy and paste to new Calc file to get accurate row numbering, and small file size.
Table. Data processed by Our World in Data[edit]
OWID uses same UNODC data. But doesn't go back past 2005. Or beyond 2021.
Table below is from this method:
- https://ask.libreoffice.org/t/csv-file-only-keep-last-entry-for-each-country/105990
- https://ask.libreoffice.org/t/csv-file-only-keep-last-entry-for-each-country/105990/2
- Note: Only data vetted by Our World in Data is used in the table.
- Asterisk (*) in Location column indicates a Crime in LOCATION article.
| Location | Year | Rate |
|---|---|---|
 Albania *
|
2021 | 1.75 |
 Algeria
|
2021 | 0.14 |
 Andorra
|
2015 | 0 |
 Antigua and Barbuda
|
2021 | 4.29 |
 Argentina *
|
2021 | 2.42 |
 Armenia *
|
2019 | 0.67 |
 Australia *
|
2021 | 0.10 |
 Austria *
|
2021 | 0.18 |
 Azerbaijan *
|
2021 | 0.16 |
 Bahamas
|
2021 | 25.50 |
 Barbados
|
2021 | 6.05 |
 Belarus
|
2014 | 0.21 |
 Belize *
|
2021 | 22.75 |
 Bermuda
|
2021 | 4.67 |
 Bhutan *
|
2020 | 0 |
 Bolivia *
|
2021 | 0.31 |
 Bosnia and Herzegovina
|
2021 | 0.43 |
 Brazil *
|
2020 | 15.94 |
 Bulgaria *
|
2017 | 0.24 |
 Canada *
|
2021 | 0.78 |
 Cape Verde *
|
2018 | 1.93 |
 Chile *
|
2021 | 1.86 |
 Colombia *
|
2021 | 20.81 |
 Costa Rica *
|
2021 | 8.30 |
 Croatia
|
2021 | 0.17 |
 Cyprus
|
2021 | 0.40 |
 Czech Republic *
|
2021 | 0.08 |
 Denmark *
|
2018 | 0.05 |
 Dominica
|
2021 | 1.38 |
 Dominican Republic *
|
2021 | 6.12 |
 Ecuador *
|
2021 | 10.25 |
 Egypt *
|
2011 | 2.06 |
 El Salvador *
|
2021 | 12.15 |
 Eswatini
|
2021 | 1.43 |
 Finland *
|
2019 | 0.09 |
 France *
|
2017 | 0.10 |
 Georgia
|
2018 | 0.85 |
 Germany *
|
2020 | 0.06 |
 Greece *
|
2021 | 0.27 |
 Grenada
|
2021 | 0 |
 Guatemala *
|
2021 | 3.44 |
 Guyana *
|
2021 | 2.98 |
 Honduras *
|
2021 | 28.72 |
 Hong Kong *
|
2021 | 0 |
 Hungary *
|
2021 | 0.02 |
 Iceland
|
2021 | 0.27 |
 India *
|
2012 | 0.30 |
 Iran *
|
2015 | 0.37 |
 Italy *
|
2021 | 0.15 |
 Jamaica *
|
2021 | 44.21 |
 Japan *
|
2019 | 0.00 |
 Jordan *
|
2021 | 0.24 |
 Kazakhstan *
|
2020 | 0.11 |
 Liechtenstein
|
2016 | 0 |
 Lithuania
|
2020 | 0.11 |
 Luxembourg
|
2014 | 0.18 |
 Macau *
|
2015 | 0 |
 Malta
|
2021 | 0 |
 Mauritius *
|
2021 | 0.15 |
 Mexico *
|
2021 | 19.33 |
 Moldova *
|
2020 | 0.23 |
 Monaco
|
2015 | 0 |
 Mongolia
|
2021 | 0.09 |
 Montenegro *
|
2021 | 1.11 |
 Morocco
|
2021 | 0.01 |
 Netherlands
|
2021 | 0.15 |
 New Zealand *
|
2019 | 1.23 |
 Nicaragua
|
2021 | 2.00 |
 North Macedonia
|
2017 | 0.76 |
 Oman *
|
2019 | 0.07 |
 Palestine *
|
2021 | 0.37 |
 Panama *
|
2021 | 10.23 |
 Paraguay *
|
2021 | 4.80 |
 Peru *
|
2020 | 2.94 |
 Philippines *
|
2019 | 1.10 |
 Puerto Rico *
|
2016 | 18.38 |
 Saint Kitts and Nevis *
|
2021 | 25.21 |
 Saint Lucia *
|
2021 | 26.16 |
 Saint Vincent and the Grenadines
|
2021 | 20.13 |
 Serbia *
|
2021 | 0.12 |
 Slovakia *
|
2021 | 0.06 |
 Slovenia *
|
2021 | 0 |
 South Korea *
|
2021 | 0 |
 Spain *
|
2021 | 0.08 |
 Sri Lanka *
|
2019 | 0.07 |
 Suriname *
|
2021 | 2.61 |
 Sweden *
|
2021 | 0.43 |
 Switzerland *
|
2021 | 0.09 |
 Tajikistan
|
2020 | 0.06 |
 Tanzania
|
2015 | 0.10 |
 Thailand *
|
2016 | 1.46 |
 Trinidad and Tobago *
|
2020 | 20.55 |
 Uganda
|
2021 | 0.66 |
 United Arab Emirates *
|
2021 | 0.04 |
 United States *
|
2020 | 4.05 |
 Uruguay
|
2021 | 5.34 |
 Uzbekistan
|
2019 | 0.01 |
 Vatican City *
|
2015 | 0 |