User:Timeshifter/Sandbox44


 * Note: Please do not edit this page. Create sandboxes on your own user subpages. This is from "Global Study on Homicide 2013", the full PDF report. It is linked from the United Nations Office on Drugs and Crime site: Global Study on Homicide. It has been converted to a large wikitext table below. It is created from the xlsx spreadsheet.

For more recent UNODC data see: User:Timeshifter/Sandbox62.


 * See: List of countries by intentional homicide rate. The table below has source data for the main table in that article.


 * Global Study on Homicide (home page). United Nations Office on Drugs and Crime (UNODC). See the PDF of the full report titled "Global Study on Homicide 2013". See the statistical annex at the end of it. For the current report it starts on page 121. The statistical annex has detailed charts for homicide counts and rates by country with data from 2000–2012. Use the "rotate view" command in your PDF reader. Map 7.2 on page 112 is a world map showing the latest year available for homicide count for each country or territory.


 * Data. Global Study on Homicide. UNODC. See "Homicide counts and rates, time series...". The xlsx files can be converted to other formats at zamzar.com. Upload the file, or paste in the URL of the file at zamzar.com/url, and the converted file will be emailed to you. It arrives fast since the conversion is quick for small files such as the main file:
 * https://www.unodc.org/documents/gsh/data/GSH2013_Homicide_count_and_rate.xlsx

That file was converted to CSV at zamzar.com, and then to wikitext here:
 * CSV Converter (csv2wp) - converts many types of spreadsheet tables, comma-separated values (CSV), tab-separated values, etc. to wiki code or HTML. You can use this to convert tables from Excel and more.
 * More info in English: de:Benutzer:Duesentrieb/csv2wp_(en)


 * See: Commons:Convert tables and charts to wiki code or image files.

Notes were pulled out of the table, and moved to the top in order to make the table more compact and understandable. Blank lines at the top and bottom were removed. Formatting came only from class="wikitable sortable". See Help:Sorting. To enable that I used exclamation points (!) in the wikitext for the headers.

Table

 * Note: The initial order of the countries is alphabetical within subregion. Reload the page to get the initial sort order. Use your browser's find command to find the rate and count for a particular country. See page 121 of the full report for the data source abbreviations.

Intentional homicide count and rate per 100,000 population, by country/territory (2000-2012). Intentional homicide is defined as unlawful death purposefully inflicted on a person by another person.

In 2009, the Philippine National Police (PNP) has implemented a new crime reporting system wherein crime data for 2009 was set as the baseline for future research, study and comparison. Thus, crime statistics in 2009 cannot be compared with those data obtained in the previous years (2008 and earlier) since the parameters were no longer the same.


 * x - due to small population size the estimated count is less than 2.
 * * - CTS Victims data are continued using UNECE trend data.