The WPF Famine Dataset
@owid.total_famines_by_year_decade
@owid.total_famines_by_year_decade
The dataset is a catalogue of famines and instances of mass starvation around the world since 1870 that are estimated to have killed 100,000 people or more. The dataset includes date, location, estimate for excess deaths, and causes (proximate, underlying, and contributory, along with a classification of the role of political intent).
CREATE TABLE owid_total_famines_by_year_decade_1 (
"year" INTEGER,
"country" VARCHAR,
"famine_count" INTEGER,
"famine_deaths" FLOAT,
"decadal_famine_count" INTEGER,
"decadal_famine_deaths" UINTEGER,
"famine_deaths_per_rate" FLOAT,
"decadal_famine_deaths_rate" FLOAT
);CREATE TABLE owid_total_famines_by_year_decade_2 (
"year" INTEGER,
"country" VARCHAR,
"famine_deaths" FLOAT,
"decadal_famine_deaths" UINTEGER,
"famine_deaths_per_rate" FLOAT,
"decadal_famine_deaths_rate" FLOAT
);Anyone who has the link will be able to view this.