search

owid / etl

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

📊 child mortality: adding regional values for count variables in UN IGME #3492

Closed spoonerf closed 3 weeks ago

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

Login: ssh owid@staging-site-igme-eu

chart-diff: ✅ No charts for review.
data-diff: ❌ Found differences ```diff = Dataset garden/gapminder/2023-09-22/total_fertility_rate = Table fertility_rate ~ Dim country + + New values: 246 / 16127 (1.53%) year country 2003 Africa 2006 Africa 2021 Africa 1959 Asia 1960 Asia ~ Dim year + + New values: 246 / 16127 (1.53%) country year Africa 2003 Africa 2006 Africa 2021 Asia 1959 Asia 1960 ~ Column children_dying_before_five_per_woman (changed metadata, new data) + + description: Population by country and year. + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + processing_level: major + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 246 / 16127 (1.53%) country year children_dying_before_five_per_woman Africa 2003 0.592730 Africa 2006 0.514560 Africa 2021 0.266742 Asia 1959 1.077650 Asia 1960 1.033913 ~ Column children_surviving_past_five_per_woman (changed metadata, new data) + + description: Population by country and year. + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + processing_level: major + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 246 / 16127 (1.53%) country year children_surviving_past_five_per_woman Africa 2003 4.587270 Africa 2006 4.545440 Africa 2021 4.013258 Asia 1959 4.032350 Asia 1960 3.976087 ~ Column fertility_rate (new data) + + New values: 246 / 16127 (1.53%) country year fertility_rate Africa 2003 5.18 Africa 2006 5.06 Africa 2021 4.28 Asia 1959 5.11 Asia 1960 5.01 = Dataset garden/un/2024-09-11/igme = Table igme ~ Dim country + + New values: 25775 / 734844 (3.51%) year indicator sex wealth_quintile unit_of_measure country 1955 Infant deaths Male Total Number of deaths Europe 1958 Under-five mortality rate Total Total Deaths per 100 live births Europe 1998 Deaths age 5 to 14 Total Total Number of deaths North America 2007 Deaths age 5 to 14 Total Total Number of deaths North America 1993 Deaths age 10 to 14 Female Total Number of deaths Oceania (SDG) ~ Dim year + + New values: 25775 / 734844 (3.51%) country indicator sex wealth_quintile unit_of_measure year Europe Infant deaths Male Total Number of deaths 1955 Europe Under-five mortality rate Total Total Deaths per 100 live births 1958 North America Deaths age 5 to 14 Total Total Number of deaths 1998 North America Deaths age 5 to 14 Total Total Number of deaths 2007 Oceania (SDG) Deaths age 10 to 14 Female Total Number of deaths 1993 ~ Dim indicator + + New values: 25775 / 734844 (3.51%) country year sex wealth_quintile unit_of_measure indicator Europe 1955 Male Total Number of deaths Infant deaths Europe 1958 Total Total Deaths per 100 live births Under-five mortality rate North America 1998 Total Total Number of deaths Deaths age 5 to 14 North America 2007 Total Total Number of deaths Deaths age 5 to 14 Oceania (SDG) 1993 Female Total Number of deaths Deaths age 10 to 14 ~ Dim sex + + New values: 25775 / 734844 (3.51%) country year indicator wealth_quintile unit_of_measure sex Europe 1955 Infant deaths Total Number of deaths Male Europe 1958 Under-five mortality rate Total Deaths per 100 live births Total North America 1998 Deaths age 5 to 14 Total Number of deaths Total North America 2007 Deaths age 5 to 14 Total Number of deaths Total Oceania (SDG) 1993 Deaths age 10 to 14 Total Number of deaths Female ~ Dim wealth_quintile + + New values: 25775 / 734844 (3.51%) country year indicator sex unit_of_measure wealth_quintile Europe 1955 Infant deaths Male Number of deaths Total Europe 1958 Under-five mortality rate Total Deaths per 100 live births Total North America 1998 Deaths age 5 to 14 Total Number of deaths Total North America 2007 Deaths age 5 to 14 Total Number of deaths Total Oceania (SDG) 1993 Deaths age 10 to 14 Female Number of deaths Total ~ Dim unit_of_measure + + New values: 25775 / 734844 (3.51%) country year indicator sex wealth_quintile unit_of_measure Europe 1955 Infant deaths Male Total Number of deaths Europe 1958 Under-five mortality rate Total Total Deaths per 100 live births North America 1998 Deaths age 5 to 14 Total Total Number of deaths North America 2007 Deaths age 5 to 14 Total Total Number of deaths Oceania (SDG) 1993 Deaths age 10 to 14 Female Total Number of deaths ~ Column lower_bound (changed metadata, new data, changed data) + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 25775 / 734844 (3.51%) country year indicator sex wealth_quintile unit_of_measure lower_bound Europe 1955 Infant deaths Male Total Number of deaths 150046.0 Europe 1958 Under-five mortality rate Total Total Deaths per 100 live births NaN North America 1998 Deaths age 5 to 14 Total Total Number of deaths 31190.0 North America 2007 Deaths age 5 to 14 Total Total Number of deaths 21299.0 Oceania (SDG) 1993 Deaths age 10 to 14 Female Total Number of deaths 379.0 ~ Changed values: 2453 / 734844 (0.33%) country year indicator sex wealth_quintile unit_of_measure lower_bound - lower_bound + Oceania 1994 Deaths age 5 to 24 Total Total Number of deaths 6535.000000 6268.0 Oceania 2001 Under-five mortality rate Male Total Deaths per 100 live births 3.014682 NaN Oceania 2006 Deaths age 5 to 14 Female Total Number of deaths 943.000000 915.0 Oceania 2006 Deaths age 5 to 9 Total Total Number of deaths 1260.000000 1223.0 Oceania 2019 Mortality rate age 5-24 Total Total Deaths per 100 children aged 5 0.995459 NaN ~ Column obs_value (changed metadata, new data, changed data) + + description: Population by country and year. + + description_short: Population by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + licenses: + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + processing_level: major + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 25775 / 734844 (3.51%) country year indicator sex wealth_quintile unit_of_measure obs_value Europe 1955 Infant deaths Male Total Number of deaths 155521.000000 Europe 1958 Under-five mortality rate Total Total Deaths per 100 live births 5.010353 North America 1998 Deaths age 5 to 14 Total Total Number of deaths 33633.000000 North America 2007 Deaths age 5 to 14 Total Total Number of deaths 22792.000000 Oceania (SDG) 1993 Deaths age 10 to 14 Female Total Number of deaths 444.000000 ~ Changed values: 1388 / 734844 (0.19%) country year indicator sex wealth_quintile unit_of_measure obs_value - obs_value + Oceania 1993 Mortality rate age 15-24 Total Total Deaths per 100 children aged 15 1.041067 0.981407 Oceania 1997 Mortality rate age 5-9 Female Total Deaths per 100 children aged 5 0.273696 0.201935 Oceania 2006 Infant mortality rate Total Total Deaths per 100 live births 2.233300 1.480553 Oceania 2009 Mortality rate age 20-24 Male Total Deaths per 100 children aged 20 0.589873 0.546597 Oceania 2014 Mortality rate age 5-14 Total Total Deaths per 100 children aged 5 0.424635 0.311116 ~ Column upper_bound (changed metadata, new data, changed data) + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 25775 / 734844 (3.51%) country year indicator sex wealth_quintile unit_of_measure upper_bound Europe 1955 Infant deaths Male Total Number of deaths 161381.0 Europe 1958 Under-five mortality rate Total Total Deaths per 100 live births NaN North America 1998 Deaths age 5 to 14 Total Total Number of deaths 36405.0 North America 2007 Deaths age 5 to 14 Total Total Number of deaths 24565.0 Oceania (SDG) 1993 Deaths age 10 to 14 Female Total Number of deaths 520.0 ~ Changed values: 2453 / 734844 (0.33%) country year indicator sex wealth_quintile unit_of_measure upper_bound - upper_bound + Oceania 1994 Deaths age 5 to 24 Total Total Number of deaths 8278.000000 8593.0 Oceania 2001 Under-five mortality rate Male Total Deaths per 100 live births 3.622649 NaN Oceania 2006 Deaths age 5 to 14 Female Total Number of deaths 1373.000000 1409.0 Oceania 2006 Deaths age 5 to 9 Total Total Number of deaths 1841.000000 1882.0 Oceania 2019 Mortality rate age 5-24 Total Total Deaths per 100 children aged 5 1.352805 NaN = Table igme_under_fifteen_mortality ~ Dim country + + New values: 462 / 18171 (2.54%) year indicator sex wealth_quintile unit_of_measure country 2000 Under-fifteen mortality rate Total Total Deaths per 100 live births Africa 1996 Under-fifteen deaths Total Total Number of deaths Asia 2013 Under-fifteen mortality rate Total Total Deaths per 100 live births Asia 2016 Under-fifteen deaths Total Total Number of deaths Asia 2003 Under-fifteen mortality rate Total Total Deaths per 100 live births European Union (27) ~ Dim year + + New values: 462 / 18171 (2.54%) country indicator sex wealth_quintile unit_of_measure year Africa Under-fifteen mortality rate Total Total Deaths per 100 live births 2000 Asia Under-fifteen deaths Total Total Number of deaths 1996 Asia Under-fifteen mortality rate Total Total Deaths per 100 live births 2013 Asia Under-fifteen deaths Total Total Number of deaths 2016 European Union (27) Under-fifteen mortality rate Total Total Deaths per 100 live births 2003 ~ Dim indicator + + New values: 462 / 18171 (2.54%) country year sex wealth_quintile unit_of_measure indicator Africa 2000 Total Total Deaths per 100 live births Under-fifteen mortality rate Asia 1996 Total Total Number of deaths Under-fifteen deaths Asia 2013 Total Total Deaths per 100 live births Under-fifteen mortality rate Asia 2016 Total Total Number of deaths Under-fifteen deaths European Union (27) 2003 Total Total Deaths per 100 live births Under-fifteen mortality rate ~ Dim sex + + New values: 462 / 18171 (2.54%) country year indicator wealth_quintile unit_of_measure sex Africa 2000 Under-fifteen mortality rate Total Deaths per 100 live births Total Asia 1996 Under-fifteen deaths Total Number of deaths Total Asia 2013 Under-fifteen mortality rate Total Deaths per 100 live births Total Asia 2016 Under-fifteen deaths Total Number of deaths Total European Union (27) 2003 Under-fifteen mortality rate Total Deaths per 100 live births Total ~ Dim wealth_quintile + + New values: 462 / 18171 (2.54%) country year indicator sex unit_of_measure wealth_quintile Africa 2000 Under-fifteen mortality rate Total Deaths per 100 live births Total Asia 1996 Under-fifteen deaths Total Number of deaths Total Asia 2013 Under-fifteen mortality rate Total Deaths per 100 live births Total Asia 2016 Under-fifteen deaths Total Number of deaths Total European Union (27) 2003 Under-fifteen mortality rate Total Deaths per 100 live births Total ~ Dim unit_of_measure + + New values: 462 / 18171 (2.54%) country year indicator sex wealth_quintile unit_of_measure Africa 2000 Under-fifteen mortality rate Total Total Deaths per 100 live births Asia 1996 Under-fifteen deaths Total Total Number of deaths Asia 2013 Under-fifteen mortality rate Total Total Deaths per 100 live births Asia 2016 Under-fifteen deaths Total Total Number of deaths European Union (27) 2003 Under-fifteen mortality rate Total Total Deaths per 100 live births ~ Column obs_value (changed metadata, new data, changed data) + + description: Population by country and year. + + description_short: |- + + <% if 'rate' in indicator %>Estimated share of children that die before reaching the age of fifteen.<% else %>Estiamted number of children that die before reaching the age of fifteen.<%- endif -%> + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + licenses: + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing - - short_unit: '%' + + short_unit: <% if 'rate' in indicator %>%<% else %><%- endif -%> - - numDecimalPlaces: <% if 'rate' in indicator %>1<% else %>0<%- endif -%> ? ^ + + numDecimalPlaces: <% if 'rate' in indicator %>2<% else %>0<%- endif -%> ? ^ + + processing_level: major + + New values: 462 / 18171 (2.54%) country year indicator sex wealth_quintile unit_of_measure obs_value Africa 2000 Under-fifteen mortality rate Total Total Deaths per 100 live births 1.490399e+01 Asia 1996 Under-fifteen deaths Total Total Number of deaths 6.997608e+06 Asia 2013 Under-fifteen mortality rate Total Total Deaths per 100 live births 3.602422e+00 Asia 2016 Under-fifteen deaths Total Total Number of deaths 2.750758e+06 European Union (27) 2003 Under-fifteen mortality rate Total Total Deaths per 100 live births 7.913421e-01 ~ Changed values: 33 / 18171 (0.18%) country year indicator sex wealth_quintile unit_of_measure obs_value - obs_value + Oceania 1992 Under-fifteen mortality rate Total Total Deaths per 100 live births 3.723691 2.557714 Oceania 2001 Under-fifteen mortality rate Total Total Deaths per 100 live births 3.568771 2.322238 Oceania 2007 Under-fifteen mortality rate Total Total Deaths per 100 live births 3.217870 2.194746 Oceania 2010 Under-fifteen mortality rate Total Total Deaths per 100 live births 3.013194 2.073086 Oceania 2014 Under-fifteen mortality rate Total Total Deaths per 100 live births 2.801991 1.913453 ~ Dataset garden/un/2024-09-16/long_run_child_mortality + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing = Table long_run_child_mortality_selected ~ Dim country + + New values: 566 / 17183 (3.29%) year country 1954 Asia 1959 Asia 1985 Asia 1988 Europe 2021 Oceania (SDG) ~ Dim year + + New values: 566 / 17183 (3.29%) country year Asia 1954 Asia 1959 Asia 1985 Europe 1988 Oceania (SDG) 2021 ~ Column under_five_mortality (changed metadata, new data, changed data) + + description: Population by country and year. + + description_short: Population by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + processing_level: major + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 566 / 17183 (3.29%) country year under_five_mortality Asia 1954 23.499590 Asia 1959 21.089043 Asia 1985 9.154759 Europe 1988 1.607566 Oceania (SDG) 2021 2.030216 ~ Changed values: 33 / 17183 (0.19%) country year under_five_mortality - under_five_mortality + Oceania 1992 3.186560 2.144604 Oceania 2001 3.085631 1.953530 Oceania 2007 2.757867 1.853336 Oceania 2010 2.570570 1.748418 Oceania 2014 2.387494 1.607337 = Table long_run_child_mortality ~ Dim country + + New values: 320 / 44783 (0.71%) year country 1964 European Union (27) 2014 European Union (27) 1973 Oceania 2008 Oceania (SDG) 1961 South America ~ Dim year + + New values: 320 / 44783 (0.71%) country year European Union (27) 1964 European Union (27) 2014 Oceania 1973 Oceania (SDG) 2008 South America 1961 ~ Column share_dying_first_five_years (changed metadata, new data) + + description: Population by country and year. + + description_short: Population by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + processing_level: major + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 320 / 44783 (0.71%) country year share_dying_first_five_years European Union (27) 1964 NaN European Union (27) 2014 NaN Oceania 1973 NaN Oceania (SDG) 2008 NaN South America 1961 NaN ~ Column share_surviving_first_five_years (changed metadata, new data) + + description: Population by country and year. + + description_short: Population by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + processing_level: major + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 320 / 44783 (0.71%) country year share_surviving_first_five_years European Union (27) 1964 NaN European Union (27) 2014 NaN Oceania 1973 NaN Oceania (SDG) 2008 NaN South America 1961 NaN ~ Column under_five_mortality (changed metadata, new data, changed data) + + description: Population by country and year. + + description_short: Population by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. + + - producer: Various sources + + title: Population + + description: |- + + Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources. + + + + You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources + + citation_full: |- + + The long-run data on population is based on various sources, described on this page: https://ourworldindata.org/population-sources + + attribution: Population based on various sources (2024) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2024-07-11' + + date_published: '2024-07-15' + + license: + + name: CC BY 4.0 + + url: https://creativecommons.org/licenses/by/4.0/ + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + processing_level: major + + attribution: Gapminder (2022); UN WPP (2024) + + New values: 320 / 44783 (0.71%) country year under_five_mortality European Union (27) 1964 3.862478 European Union (27) 2014 0.433198 Oceania 1973 3.681263 Oceania (SDG) 2008 2.671963 South America 1961 15.857803 ~ Changed values: 279 / 44783 (0.62%) country year under_five_mortality - under_five_mortality + Africa 1947 34.021000 33.257763 Africa 1987 16.960001 16.153416 Europe 1997 1.796000 1.232658 Europe 2004 1.155000 0.881757 Oceania 1996 3.109185 2.019052 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-11-05 10:32:18 UTC Execution time: 721.96 seconds