sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

2 rows where datasetId = 6651 sorted by id descending

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
22685
 22685
 30959
 OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024)
 {"link": null, "retrievedDate": null, "additionalInfo": "\nThe homicide rate data shown here is taken from Table 4 on pages 80-81 in Eisner (2015). In the table homicide rate estimates are given for a range of years, we present data for the mid-point year here. For example, if data is given for 1200-1299 we show this as 1250.\n\nDataset notes:\n\n* For 1775 and 1862 the data for Switzerland are for the canton of Zurich only.\n* From 1825 onwards the estimates for Corsica and Sardinia are for Sardinia only.", "dataPublishedBy": "OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024)"}
 2024-07-31 12:15:49
 2024-09-30 17:58:07
 6651
 The homicide rate data shown here is taken from Table 4 on pages 80-81 in Eisner (2015). In the table homicide rate estimates are given for a range of years, we present data for the mid-point year here. For example, if data is given for 1200-1299 we show this as 1250. Dataset notes: * For 1775 and 1862 the data for Switzerland are for the canton of Zurich only. * From 1825 onwards the estimates for Corsica and Sardinia are for Sardinia only.
   OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024)
22684
 22684
 30958
 OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024)
 {"link": null, "retrievedDate": null, "additionalInfo": "The homicide rate data shown here is taken from Table 4 on pages 80-81 in Eisner (2015). In the table homicide rate estimates are given for a range of years, we present data for the mid-point year here. For example, if data is given for 1200-1299 we show this as 1250.\n\nDataset notes:\n\n* For 1775 and 1862 the data for Switzerland are for the canton of Zurich only.\n* From 1825 onwards the estimates for Corsica and Sardinia are for Sardinia only.", "dataPublishedBy": "OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024)"}
 2024-07-31 12:15:49
 2025-02-12 10:59:27
 6651
 The homicide rate data shown here is taken from Table 4 on pages 80-81 in Eisner (2015). In the table homicide rate estimates are given for a range of years, we present data for the mid-point year here. For example, if data is given for 1200-1299 we show this as 1250. Dataset notes: * For 1775 and 1862 the data for Switzerland are for the canton of Zurich only. * From 1825 onwards the estimates for Corsica and Sardinia are for Sardinia only.
   OWID based on Eisner (2014); United Nations Office of Drugs and Crime (2022); WHO Mortality Database (2024)

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE sources(id INTEGER, "name" VARCHAR, description VARCHAR, createdAt TIMESTAMP, updatedAt TIMESTAMP, datasetId INTEGER, additionalInfo VARCHAR, link VARCHAR, dataPublishedBy VARCHAR);;