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

1 row where datasetId = 426 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
548 Our World In Data based on NOAA, Lopez Holle and population data 
{
    "link": null,
    "retrievedDate": "2017-April-22",
    "additionalInfo": "Data on the annual fatalities (since 1940) to various weather events in the US is from the National Oceanic and Atmospheric Administration (NOAA) National Weather Service. This dataset is online here: http://www.lightningsafety.noaa.gov/victims.shtml\nData on lightning from lightning earlier than 1991 is not from this dataset from NOAA, but from the Lopez and Holle paper cited below. \n\nI have calculated the fatality rate based on the NOAA fatality counts and estimates of the US population. These estimates are based on US census data for the period before 1960 and on World Bank data for the period since then.\n\nThe US census data is online here: https://www2.census.gov/programs-surveys/popest/tables/1900-1980/national/totals/popclockest.txt\nThe World Bank estimates are online here: http://data.worldbank.org/indicator/SP.POP.TOTL\n\n\nData on the lightning fatality rate until 1990 is from Ra\u00fal E. Lopez and Ronald L. Holle (1997) \u2013 Changes in the Number of Lightning Deaths in the United States during the Twentieth Century. Journal of Climate; Volume 11.\nThis fatality rate is not calculated for the entire US since in earlier periods not all US states reported the number of annual fatalities. (In the calculation of the fatality rate Lopez and Holle have taken only the population of the reporting states into account so that the population in the numerator and the denominator refer to the same group of people.)",
    "dataPublishedBy": "Our World In Data based on NOAA, Lopez Holle (1997) and population data from the US census and the World Bank",
    "dataPublisherSource": null
}
 2017-04-22 16:42:12 2017-11-02 13:04:39 Weather fatality rates in the US – OWID based on NOAA and Lopez Holle and population data 426 Data on the annual fatalities (since 1940) to various weather events in the US is from the National Oceanic and Atmospheric Administration (NOAA) National Weather Service. This dataset is online here: http://www.lightningsafety.noaa.gov/victims.shtml Data on lightning from lightning earlier than 1991 is not from this dataset from NOAA, but from the Lopez and Holle paper cited below. I have calculated the fatality rate based on the NOAA fatality counts and estimates of the US population. These estimates are based on US census data for the period before 1960 and on World Bank data for the period since then. The US census data is online here: https://www2.census.gov/programs-surveys/popest/tables/1900-1980/national/totals/popclockest.txt The World Bank estimates are online here: http://data.worldbank.org/indicator/SP.POP.TOTL Data on the lightning fatality rate until 1990 is from Raúl E. Lopez and Ronald L. Holle (1997) – Changes in the Number of Lightning Deaths in the United States during the Twentieth Century. Journal of Climate; Volume 11. This fatality rate is not calculated for the entire US since in earlier periods not all US states reported the number of annual fatalities. (In the calculation of the fatality rate Lopez and Holle have taken only the population of the reporting states into account so that the population in the numerator and the denominator refer to the same group of people.)   Our World In Data based on NOAA, Lopez Holle (1997) and population data from the US census and the World Bank

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");