search

owid / etl

A compute graph for loading and transforming OWID's data
https://docs.owid.io/projects/etl
MIT License
86 stars 23 forks source link

📊 energy: Update IRENA Renewable Power Generation Costs data #3470

Closed pabloarosado closed 3 weeks ago

pabloarosado commented 3 weeks ago

@paarriagadap please use this link to review the code. there's no need for a thorough review, it's mostly an adaptation of already existing steps.

owidbot commented 3 weeks ago
Quick links (staging server): Site Admin Wizard

Login: ssh owid@staging-site-update-irena-costs

chart-diff: ✅
  • 3/3 reviewed charts
    • Modified: 3/3
    • New: 0/0
    • Rejected: 0
data-diff: ❌ Found differences ```diff + Dataset garden/energy/2024-10-30/photovoltaic_cost_and_capacity + + Table photovoltaic_cost_and_capacity + + Column cost + + Column cost_source + + Column cumulative_capacity + + Column cumulative_capacity_source = Dataset garden/health/latest/global_health_mpox = Table global_health_mpox ~ Dim country + + New values: 2 / 89 (2.25%) date country 2024-10-20 Kenya 2024-10-13 Nigeria - - Removed values: 6 / 89 (6.74%) date country 2024-07-19 Burundi 2024-10-27 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria ~ Dim date + + New values: 2 / 89 (2.25%) country date Kenya 2024-10-20 Nigeria 2024-10-13 - - Removed values: 6 / 89 (6.74%) country date Burundi 2024-07-19 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria 2024-10-27 ~ Column reported_cases (new data, changed data) + + New values: 2 / 89 (2.25%) country date reported_cases Kenya 2024-10-20 230.0 Nigeria 2024-10-13 42.0 - - Removed values: 6 / 89 (6.74%) country date reported_cases Burundi 2024-07-19 5.0 Burundi 2024-10-27 113.0 Central African Republic 2024-10-27 5.0 Cote d'Ivoire 2024-10-27 42.0 Nigeria 2024-10-27 50.0 ~ Changed values: 10 / 89 (11.24%) country date reported_cases - reported_cases + Liberia 2024-10-20 23.0 192.0 Nigeria 2024-08-25 65.0 66.0 Nigeria 2024-09-08 72.0 96.0 Nigeria 2024-10-06 56.0 60.0 Rwanda 2024-10-13 298.0 303.0 ~ Column suspected_cases_cumulative (new data, changed data) + + New values: 2 / 89 (2.25%) country date suspected_cases_cumulative Kenya 2024-10-20 230.0 Nigeria 2024-10-13 1339.0 - - Removed values: 6 / 89 (6.74%) country date suspected_cases_cumulative Burundi 2024-07-19 5.0 Burundi 2024-10-27 1852.0 Central African Republic 2024-10-27 5.0 Cote d'Ivoire 2024-10-27 293.0 Nigeria 2024-10-27 1287.0 ~ Changed values: 20 / 89 (22.47%) country date suspected_cases_cumulative - suspected_cases_cumulative + Burundi 2024-08-09 114.0 109.0 Burundi 2024-10-12 1526.0 1521.0 Liberia 2024-10-20 23.0 192.0 Nigeria 2024-10-06 1237.0 1297.0 Rwanda 2024-10-13 2037.0 2042.0 + Dataset garden/irena/2024-10-29/renewable_power_generation_costs + + Table renewable_power_generation_costs + + Column bioenergy + + Column concentrated_solar_power + + Column geothermal + + Column hydropower + + Column offshore_wind + + Column onshore_wind + + Column solar_photovoltaic + + Table solar_photovoltaic_module_prices + + Column cost = Dataset garden/who/2024-09-09/flu_test = Table flu_test ~ Dim country - - Removed values: 16 / 71888 (0.02%) date country 2024-10-21 Brunei 2024-10-21 India 2024-10-21 Iraq 2024-10-14 Japan 2024-10-14 Saudi Arabia ~ Dim date - - Removed values: 16 / 71888 (0.02%) country date Brunei 2024-10-21 India 2024-10-21 Iraq 2024-10-21 Japan 2024-10-14 Saudi Arabia 2024-10-14 ~ Column denomcombined (changed data) - - Removed values: 16 / 71888 (0.02%) country date denomcombined Brunei 2024-10-21 28 India 2024-10-21 162 Iraq 2024-10-21 34 Japan 2024-10-14 3 Saudi Arabia 2024-10-14 216 ~ Changed values: 39 / 71888 (0.05%) country date denomcombined - denomcombined + Japan 2024-05-20 29 25 Nepal 2024-10-14 144 102 New Caledonia 2024-10-14 50 39 Somalia 2024-08-12 24 7 Somalia 2024-08-19 17 6 ~ Column pcnt_poscombined (changed data) - - Removed values: 16 / 71888 (0.02%) country date pcnt_poscombined Brunei 2024-10-21 7.142857 India 2024-10-21 6.172840 Iraq 2024-10-21 2.941176 Japan 2024-10-14 100.000000 Saudi Arabia 2024-10-14 26.851852 ~ Changed values: 40 / 71888 (0.06%) country date pcnt_poscombined - pcnt_poscombined + Japan 2024-05-20 24.137932 28.000000 Japan 2024-07-01 40.000000 44.444443 Japan 2024-09-23 52.631580 38.461540 Japan 2024-10-07 77.777779 75.000000 Nepal 2024-09-23 18.243244 17.241379 = Dataset garden/who/latest/monkeypox = Table monkeypox ~ Dim country + + New values: 1 / 94253 (0.00%) date country 2024-10-20 Kenya - - Removed values: 6 / 94253 (0.01%) date country 2024-07-19 Burundi 2024-10-27 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria ~ Dim date + + New values: 1 / 94253 (0.00%) country date Kenya 2024-10-20 - - Removed values: 6 / 94253 (0.01%) country date Burundi 2024-07-19 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria 2024-10-27 ~ Column annotation (new data, changed data) + + New values: 1 / 94253 (0.00%) country date annotation Kenya 2024-10-20 - - Removed values: 6 / 94253 (0.01%) country date annotation Burundi 2024-07-19 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria 2024-10-27 ~ Column iso_code (new data) + + New values: 1 / 94253 (0.00%) country date iso_code Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date iso_code Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column new_cases (new data) + + New values: 1 / 94253 (0.00%) country date new_cases Kenya 2024-10-20 - - Removed values: 6 / 94253 (0.01%) country date new_cases Burundi 2024-07-19 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria 2024-10-27 ~ Column new_cases_per_million (new data) + + New values: 1 / 94253 (0.00%) country date new_cases_per_million Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date new_cases_per_million Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column new_cases_smoothed (new data) + + New values: 1 / 94253 (0.00%) country date new_cases_smoothed Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date new_cases_smoothed Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column new_cases_smoothed_per_million (new data) + + New values: 1 / 94253 (0.00%) country date new_cases_smoothed_per_million Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date new_cases_smoothed_per_million Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column new_deaths (new data) + + New values: 1 / 94253 (0.00%) country date new_deaths Kenya 2024-10-20 - - Removed values: 6 / 94253 (0.01%) country date new_deaths Burundi 2024-07-19 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria 2024-10-27 ~ Column new_deaths_per_million (new data) + + New values: 1 / 94253 (0.00%) country date new_deaths_per_million Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date new_deaths_per_million Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column new_deaths_smoothed (new data) + + New values: 1 / 94253 (0.00%) country date new_deaths_smoothed Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date new_deaths_smoothed Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column new_deaths_smoothed_per_million (new data) + + New values: 1 / 94253 (0.00%) country date new_deaths_smoothed_per_million Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date new_deaths_smoothed_per_million Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column suspected_cases_cumulative (new data, changed data) + + New values: 1 / 94253 (0.00%) country date suspected_cases_cumulative Kenya 2024-10-20 230 - - Removed values: 6 / 94253 (0.01%) country date suspected_cases_cumulative Burundi 2024-07-19 5 Burundi 2024-10-27 1852 Central African Republic 2024-10-27 5 Cote d'Ivoire 2024-10-27 293 Nigeria 2024-10-27 1287 ~ Changed values: 21 / 94253 (0.02%) country date suspected_cases_cumulative - suspected_cases_cumulative + Burundi 2024-08-09 114 109 Burundi 2024-10-12 1526 1521 Liberia 2024-10-21 56 225 Nigeria 2024-09-01 920 935 Rwanda 2024-10-13 2037 2042 ~ Column total_cases (new data) + + New values: 1 / 94253 (0.00%) country date total_cases Kenya 2024-10-20 - - Removed values: 6 / 94253 (0.01%) country date total_cases Burundi 2024-07-19 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria 2024-10-27 ~ Column total_cases_per_million (new data) + + New values: 1 / 94253 (0.00%) country date total_cases_per_million Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date total_cases_per_million Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN ~ Column total_deaths (new data) + + New values: 1 / 94253 (0.00%) country date total_deaths Kenya 2024-10-20 - - Removed values: 6 / 94253 (0.01%) country date total_deaths Burundi 2024-07-19 Burundi 2024-10-27 Central African Republic 2024-10-27 Cote d'Ivoire 2024-10-27 Nigeria 2024-10-27 ~ Column total_deaths_per_million (new data) + + New values: 1 / 94253 (0.00%) country date total_deaths_per_million Kenya 2024-10-20 NaN - - Removed values: 6 / 94253 (0.01%) country date total_deaths_per_million Burundi 2024-07-19 NaN Burundi 2024-10-27 NaN Central African Republic 2024-10-27 NaN Cote d'Ivoire 2024-10-27 NaN Nigeria 2024-10-27 NaN = Dataset garden/wpf/2024-10-03/famines_by_factor ~ Table famines_by_factor (changed metadata) - - title: The WPF Famine Dataset - - description: |- - - 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). ~ Dim year - - Removed values: 114 / 172 (66.28%) country year World 1885 World 1888 World 1902 World 1912 World 1997 ~ Dim country - - Removed values: 114 / 172 (66.28%) year country 1885 World 1888 World 1902 World 1912 World 1997 World ~ Column sum_conflict_mortality (changed metadata, changed data) - - {} + + title: Deaths from famines where conflict was not a factor + + description_short: Famines that are estimated to have killed 100,000 people or more. + + origins: + + - producer: World Peace Foundation + + title: The WPF Famine Dataset + + description: |- + + 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). + + citation_full: Historic Famines dataset. World Peace Foundation (2024). + + url_main: https://worldpeacefoundation.org/ + + date_accessed: '2024-10-03' + + date_published: '2024' + + license: + + name: permission obtained from the authors + + unit: deaths + + display: + + numDecimalPlaces: 0 + + presentation: + + topic_tags: + + - Famines - - Removed values: 114 / 172 (66.28%) year country sum_conflict_mortality 1885 World NaN 1888 World NaN 1902 World NaN 1912 World NaN 1997 World NaN ~ Changed values: 172 / 172 (100.00%) year country sum_conflict_mortality - sum_conflict_mortality + 1910 Africa NaN 0.0 1911 Africa NaN 0.0 1915 Africa NaN 0.0 1981 Africa NaN 0.0 2006 Africa NaN 0.0 ~ Column sum_conflict_mortality_factor (changed metadata, changed data) + + {} - - title: Deaths from famines where conflict was a factor - - description_short: |- - - Famines estimated to have caused over 100,000 deaths, where factors like "war," "blockade," "counterinsurgency," "occupation," "siege," "forced starvation," and "genocide" contributed to disrupting food supply and access. - - origins: - - - producer: World Peace Foundation - - title: The WPF Famine Dataset - - description: |- - - 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). - - citation_full: Historic Famines dataset. World Peace Foundation (2024). - - url_main: https://worldpeacefoundation.org/ - - date_accessed: '2024-10-03' - - date_published: '2024' - - license: - - name: permission obtained from the authors - - unit: deaths - - display: - - numDecimalPlaces: 0 - - presentation: - - topic_tags: - - - Famines - - description_processing: The deaths were assumed to have been distributed evenly over the duration of the famine. - - Removed values: 114 / 172 (66.28%) year country sum_conflict_mortality_factor 1885 World 0.0 1888 World 600000.0 1902 World 193750.0 1912 World 25000.0 1997 World 0.0 ~ Changed values: 172 / 172 (100.00%) year country sum_conflict_mortality_factor - sum_conflict_mortality_factor + 1910 Africa 8333.333008 NaN 1911 Africa 8333.333008 NaN 1915 Africa 108333.335938 NaN 1981 Africa 60000.000000 NaN 2006 Africa 54000.000000 NaN ~ Column sum_conflict_mortality_not_a_factor (changed metadata, changed data) + + {} - - title: Deaths from famines where conflict was not a factor - - description_short: |- - - Famines estimated to have caused over 100,000 deaths, where factors like "war," "blockade," "counterinsurgency," "occupation," "siege," "forced starvation," and "genocide" did not contribute to disrupting food supply and access. - - origins: - - - producer: World Peace Foundation - - title: The WPF Famine Dataset - - description: |- - - 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). - - citation_full: Historic Famines dataset. World Peace Foundation (2024). - - url_main: https://worldpeacefoundation.org/ - - date_accessed: '2024-10-03' - - date_published: '2024' - - license: - - name: permission obtained from the authors - - unit: deaths - - display: - - numDecimalPlaces: 0 - - presentation: - - topic_tags: - - - Famines - - description_processing: The deaths were assumed to have been distributed evenly over the duration of the famine. - - Removed values: 114 / 172 (66.28%) year country sum_conflict_mortality_not_a_factor 1885 World 195833.328125 1888 World 270833.343750 1902 World 195833.328125 1912 World 0.000000 1997 World 110000.000000 ~ Changed values: 172 / 172 (100.00%) year country sum_conflict_mortality_not_a_factor - sum_conflict_mortality_not_a_factor + 1910 Africa 0.0 NaN 1911 Africa 0.0 NaN 1915 Africa 0.0 NaN 1981 Africa 0.0 NaN 2006 Africa 0.0 NaN ~ Column sum_external_factors_mortality (changed metadata, changed data) - - {} + + title: Deaths from famines where external factors was not a factor + + description_short: Famines that are estimated to have killed 100,000 people or more. + + origins: + + - producer: World Peace Foundation + + title: The WPF Famine Dataset + + description: |- + + 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). + + citation_full: Historic Famines dataset. World Peace Foundation (2024). + + url_main: https://worldpeacefoundation.org/ + + date_accessed: '2024-10-03' + + date_published: '2024' + + license: + + name: permission obtained from the authors + + unit: deaths + + display: + + numDecimalPlaces: 0 + + presentation: + + topic_tags: + + - Famines - - Removed values: 114 / 172 (66.28%) year country sum_external_factors_mortality 1885 World NaN 1888 World NaN 1902 World NaN 1912 World NaN 1997 World NaN ~ Changed values: 172 / 172 (100.00%) year country sum_external_factors_mortality - sum_external_factors_mortality + 1910 Africa NaN 0.0 1911 Africa NaN 0.0 1915 Africa NaN 0.0 1981 Africa NaN 0.0 2006 Africa NaN 0.0 ~ Column sum_external_factors_mortality_factor (changed metadata, changed data) + + {} - - title: Deaths from famines where external factors was a factor - - description_short: |- - - Famines estimated to have killed 100,000 or more, where factors like "climate," "environment," and "disease" contributed to reduced food production and access. - - origins: - - - producer: World Peace Foundation - - title: The WPF Famine Dataset - - description: |- - - 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). - - citation_full: Historic Famines dataset. World Peace Foundation (2024). - - url_main: https://worldpeacefoundation.org/ - - date_accessed: '2024-10-03' - - date_published: '2024' - - license: - - name: permission obtained from the authors - - unit: deaths - - display: - - numDecimalPlaces: 0 - - presentation: - - topic_tags: - - - Famines - - description_processing: The deaths were assumed to have been distributed evenly over the duration of the famine. - - Removed values: 114 / 172 (66.28%) year country sum_external_factors_mortality_factor 1885 World 195833.328125 1888 World 870833.312500 1902 World 389583.343750 1912 World 25000.000000 1997 World 110000.000000 ~ Changed values: 172 / 172 (100.00%) year country sum_external_factors_mortality_factor - sum_external_factors_mortality_factor + 1910 Africa 8333.333008 NaN 1911 Africa 8333.333008 NaN 1915 Africa 108333.335938 NaN 1981 Africa 60000.000000 NaN 2006 Africa 54000.000000 NaN ~ Column sum_external_factors_mortality_not_a_factor (changed metadata, changed data) + + {} - - title: Deaths from famines where external factors was not a factor - - description_short: |- - - Famines estimated to have killed 100,000 or more, where factors like "climate," "environment," and "disease" did not contribute to reduced food production and access. - - origins: - - - producer: World Peace Foundation - - title: The WPF Famine Dataset - - description: |- - - 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). - - citation_full: Historic Famines dataset. World Peace Foundation (2024). - - url_main: https://worldpeacefoundation.org/ - - date_accessed: '2024-10-03' - - date_published: '2024' - - license: - - name: permission obtained from the authors - - unit: deaths - - display: - - numDecimalPlaces: 0 - - presentation: - - topic_tags: - - - Famines - - description_processing: The deaths were assumed to have been distributed evenly over the duration of the famine. - - Removed values: 114 / 172 (66.28%) year country sum_external_factors_mortality_not_a_factor 1885 World 0.0 1888 World 0.0 1902 World 0.0 1912 World 0.0 1997 World 0.0 ~ Changed values: 172 / 172 (100.00%) year country sum_external_factors_mortality_not_a_factor - sum_external_factors_mortality_not_a_factor + 1910 Africa 0.0 NaN 1911 Africa 0.0 NaN 1915 Africa 0.0 NaN 1981 Africa 0.0 NaN 2006 Africa 0.0 NaN ~ Column sum_government_policy_overall_mortality (changed metadata, changed data) - - {} + + title: Deaths from famines where government policy was not a factor + + description_short: Famines that are estimated to have killed 100,000 people or more. + + origins: + + - producer: World Peace Foundation + + title: The WPF Famine Dataset + + description: |- + + 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). + + citation_full: Historic Famines dataset. World Peace Foundation (2024). + + url_main: https://worldpeacefoundation.org/ + + date_accessed: '2024-10-03' + + date_published: '2024' + + license: + + name: permission obtained from the authors + + unit: deaths + + display: + + numDecimalPlaces: 0 + + presentation: + + topic_tags: + + - Famines - - Removed values: 114 / 172 (66.28%) year country sum_government_policy_overall_mortality 1885 World NaN 1888 World NaN 1902 World NaN 1912 World NaN 1997 World NaN ~ Changed values: 172 / 172 (100.00%) year country sum_government_policy_overall_mortality - sum_government_policy_overall_mortality + 1910 Africa NaN 8333.333008 1911 Africa NaN 8333.333008 1915 Africa NaN 108333.335938 1981 Africa NaN 60000.000000 2006 Africa NaN 54000.000000 ~ Column sum_government_policy_overall_mortality_factor (changed metadata, changed data) + + {} - - title: Deaths from famines where government policy was a factor - - description_short: |- - - Famines estimated to have killed 100,000 or more, where government actions like "economic policy," "colonial policy," "taxation," "state capacity," and "forced labor" contributed to limiting food availability and access. - - origins: - - - producer: World Peace Foundation - - title: The WPF Famine Dataset - - description: |- - - 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). - - citation_full: Historic Famines dataset. World Peace Foundation (2024). - - url_main: https://worldpeacefoundation.org/ - - date_accessed: '2024-10-03' - - date_published: '2024' - - license: - - name: permission obtained from the authors - - unit: deaths - - display: - - numDecimalPlaces: 0 - - presentation: - - topic_tags: - - - Famines - - description_processing: The deaths were assumed to have been distributed evenly over the duration of the famine. - - Removed values: 114 / 172 (66.28%) year country sum_government_policy_overall_mortality_factor 1885 World 195833.328125 1888 World 795833.312500 1902 World 389583.343750 1912 World 0.000000 1997 World 110000.000000 ~ Changed values: 172 / 172 (100.00%) year country sum_government_policy_overall_mortality_factor - sum_government_policy_overall_mortality_factor + 1910 Africa 0.0 NaN 1911 Africa 0.0 NaN 1915 Africa 0.0 NaN 1981 Africa 0.0 NaN 2006 Africa 0.0 NaN ~ Column sum_government_policy_overall_mortality_not_a_factor (changed metadata, changed data) + + {} - - title: Deaths from famines where government policy was not a factor - - description_short: |- - - Famines estimated to have killed 100,000 or more, where government actions like "economic policy," "colonial policy," "taxation," "state capacity," and "forced labor" did not contribute to limiting food availability and access. - - origins: - - - producer: World Peace Foundation - - title: The WPF Famine Dataset - - description: |- - - 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). - - citation_full: Historic Famines dataset. World Peace Foundation (2024). - - url_main: https://worldpeacefoundation.org/ - - date_accessed: '2024-10-03' - - date_published: '2024' - - license: - - name: permission obtained from the authors - - unit: deaths - - display: - - numDecimalPlaces: 0 - - presentation: - - topic_tags: - - - Famines - - description_processing: The deaths were assumed to have been distributed evenly over the duration of the famine. - - Removed values: 114 / 172 (66.28%) year country sum_government_policy_overall_mortality_not_a_factor 1885 World 0.0 1888 World 75000.0 1902 World 0.0 1912 World 25000.0 1997 World 0.0 ~ Changed values: 172 / 172 (100.00%) year country sum_government_policy_overall_mortality_not_a_factor - sum_government_policy_overall_mortality_not_a_factor + 1910 Africa 8333.333008 NaN 1911 Africa 8333.333008 NaN 1915 Africa 108333.335938 NaN 1981 Africa 60000.000000 NaN 2006 Africa 54000.000000 NaN = Dataset garden/wpf/2024-10-03/total_famines_by_year_decade = Table total_famines_by_year_decade ~ Column decadal_famine_count (changed metadata) - - unit: famines + + unit: '' + + short_unit: '' ~ Column decadal_famine_deaths (changed metadata) - - description_short: Deaths in famines that are estimated to have killed 100,000 people or more. ? ^^^^^^^^^^^ + + description_short: Famines that are estimated to have killed 100,000 people or more. ? ^ + + short_unit: '' ~ Column decadal_famine_deaths_rate (changed metadata) - - description_short: Deaths in famines that are estimated to have killed 100,000 people or more, per 100,000 people. ? ^^^^^^^^^^^ -------------------- + + description_short: Famines that are estimated to have killed 100,000 people or more. ? ^ ~ Column famine_count (changed metadata) - - unit: famines + + unit: '' + + short_unit: '' ~ Column famine_deaths (changed metadata) - - description_short: Deaths in famines that are estimated to have killed 100,000 people or more. ? ^^^^^^^^^^^ + + description_short: Famines that are estimated to have killed 100,000 people or more. ? ^ + + short_unit: '' ~ Column famine_deaths_per_rate (changed metadata) - - description_short: Deaths in famines that are estimated to have killed 100,000 people or more, per 100,000 people. ? ^^^^^^^^^^^ -------------------- + + description_short: Famines that are estimated to have killed 100,000 people or more. ? ^ Legend: +New ~Modified -Removed =Identical Details Hint: Run this locally with etl diff REMOTE data/ --include yourdataset --verbose --snippet ``` Automatically updated datasets matching _weekly_wildfires|excess_mortality|covid|fluid|flunet|country_profile|garden/ihme_gbd/2019/gbd_risk_ are not included

Edited: 2024-10-31 08:21:22 UTC Execution time: 19.95 seconds