owid / etl

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

Happiness report fiona #2805

Closed spoonerf closed 3 months ago

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

Login: ssh owid@staging-site-happiness-report-fiona

chart-diff: ✅ No charts for review.
data-diff: ❌ Found differences ```diff = Dataset garden/artificial_intelligence/2024-06-03/epoch_aggregates_countries = Table epoch_aggregates_countries ~ Dataset garden/happiness/2024-06-09/happiness (new version) + + The World Happiness Report is a partnership of Gallup, the Oxford Wellbeing Research Centre, the UN Sustainable Development Solutions Network, and the WHR’s Editorial Board. + + It reviews the state of happiness in the world today and shows how the science of happiness explains personal and national variations in happiness. - - Life evaluations from the Gallup World Poll provide the basis for the annual happiness rankings. They are based on answers to the main life evaluation question asked in the poll. - - - - This is called the Cantril ladder: it asks respondents to think of a ladder, with the best possible life for them being a 10 and the worst possible life being a 0. They are then asked to rate their own current lives on that 0 to 10 scale. - - - - The rankings are calculated by the source based on nationally representative samples for the three years prior to the year of the report, so that data for the 2023 report will draw from survey data from 2020-2022. We show the data for final year of the three-year survey period, i.e. we show the 2020-2022 survey data as 2022. - - - - The only exception is the data for the 2012 report, which uses survey data from 2005-2011, we show this data as the final year of the survey data - 2011. - - - - The number of people and countries surveyed varies year to year, but typically more than 100,000 people in 130 countries participate in the Gallup World Poll each year. - - - - The rankings are based entirely on the survey scores, using the Gallup weights to make the estimates representative. - - - - Cantril ladder data from for current and previous reports can be found at: - - - - 2023: https://happiness-report.s3.amazonaws.com/2023/DataForFigure2.1WHR2023.xls - - - - 2022: https://happiness-report.s3.amazonaws.com/2022/Appendix_2_Data_for_Figure_2.1.xls - - - - 2021: https://happiness-report.s3.amazonaws.com/2021/DataForFigure2.1WHR2021C2.xls - - - - 2020: https://happiness-report.s3.amazonaws.com/2020/WHR20_DataForFigure2.1.xls - - - - 2019: https://s3.amazonaws.com/happiness-report/2019/Chapter2OnlineData.xls - - - - 2018: https://s3.amazonaws.com/happiness-report/2018/WHR2018Chapter2OnlineData.xls - - - - 2017: https://s3.amazonaws.com/happiness-report/2017/online-data-chapter-2-whr-2017.xlsx - - - - 2016: https://s3.amazonaws.com/happiness-report/2016/Online-data-for-chapter-2-whr-2016.xlsx - - - - 2015: https://s3.amazonaws.com/happiness-report/2015/Chapter2OnlineData_Expanded-with-Trust-and-Governance.xlsx - - - - 2012: https://happiness-report.s3.amazonaws.com/2012/2012.xlsx - - sources: - - - name: World Happiness Report (2023) - - url: https://worldhappiness.report - - date_accessed: '2023-03-20' - - published_by: |- - - Helliwell, J. F., Layard, R., Sachs, J. D., De Neve, J.-E., Aknin, L. B., & Wang, S. (Eds.). (2023). World Happiness Report 2023. New York: Sustainable Development Solutions Network. - - version: '2023-03-20' ? ^ ^ - + + version: '2024-06-09' ? ^ ^ + + + update_period_days: 365 ~ Table happiness (changed metadata) - - title: World Happiness Report (2023) + + description: |- + + The World Happiness Report is a partnership of Gallup, the Oxford Wellbeing Research Centre, the UN Sustainable Development Solutions Network, and the WHR’s Editorial Board. + + It reviews the state of happiness in the world today and shows how the science of happiness explains personal and national variations in happiness. + + primary_key: + + - country + + - year ~ Column cantril_ladder_score (changed metadata, new data, changed data) + + description_short: |- + + Average of survey responses to the 'Cantril Ladder' question in the Gallup World Poll. The survey question asks respondents to think of a ladder, with the best possible life for them being a 10, and the worst possible life being a 0. + + description_key: + + - |- + + The Cantril ladder asks respondents to think of a ladder, with the best possible life for them being a 10 and the worst possible life being a 0. They are then asked to rate their own current lives on that 0 to 10 scale. + + - |- + + The rankings are calculated by the source based on nationally representative samples for the three years prior to the year of the report, so that data for the 2024 report will draw from survey data from 2021-2023. We show the data for final year of the three-year survey period, i.e. we show the 2021-2023 survey data as 2023. + + - |- + + The only exception is the data for the 2012 report, which uses survey data from 2005-2011, we show this data as the final year of the survey data - 2011. + + - |- + + The number of people and countries surveyed varies year to year, but typically more than 100,000 people in 130 countries participate in the Gallup World Poll each year. + + - The rankings are based entirely on the survey scores, using the Gallup weights to make the estimates representative. + + origins: + + - producer: 'University of Oxford: Wellbeing Research Centre' + + title: World Happiness Report + + description: |- + + The World Happiness Report is a partnership of Gallup, the Oxford Wellbeing Research Centre, the UN Sustainable Development Solutions Network, and the WHR’s Editorial Board. + + It reviews the state of happiness in the world today and shows how the science of happiness explains personal and national variations in happiness. + + citation_full: |- + + Helliwell, J. F., Layard, R., Sachs, J. D., De Neve, J.-E., Aknin, L. B., & Wang, S. (Eds.). (2024). World Happiness Report 2024. University of Oxford: Wellbeing Research Centre. + + version_producer: 2024 + + url_main: https://worldhappiness.report/ed/2024/ + + url_download: https://happiness-report.s3.amazonaws.com/2024/DataForFigure2.1+with+sub+bars+2024.xls + + date_accessed: '2024-06-09' + + date_published: '2024-03-08' + + license: + + name: '' + + - 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 (2023) + + attribution_short: Population + + url_main: https://ourworldindata.org/population-sources + + date_accessed: '2023-03-31' + + date_published: '2023-03-31' + + license: + + name: CC BY 4.0 + + licenses: + + - name: Creative Commons BY 4.0 + + url: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing + + - name: CC BY 3.0 + + url: https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt + + - name: CC BY 3.0 IGO + + url: http://creativecommons.org/licenses/by/3.0/igo/ + + processing_level: major + + presentation: + + title_public: Self-reported life satisfaction + + attribution_short: WHR + + attribution: World Happiness Report (2012-2024) + + topic_tags: + + - Happiness & Life Satisfaction + + description_processing: Average of regions is calculated by taking a population-weighted average over all countries within + + that region. + + New values: 264 / 1787 (14.77%) cantril_ladder_score 7.5715 4.9753 6.6480 6.3788 4.1969 ~ Changed values: 1522 / 1787 (85.17%) cantril_ladder_score - cantril_ladder_score + 7.1229 1.859000 7.0636 4.471300 6.4940 6.171800 4.2920 5.477073 6.8670 7.235363 ~ Column country (changed metadata, new data, changed data) - - {} + + origins: + + - producer: 'University of Oxford: Wellbeing Research Centre' + + title: World Happiness Report + + description: |- + + The World Happiness Report is a partnership of Gallup, the Oxford Wellbeing Research Centre, the UN Sustainable Development Solutions Network, and the WHR’s Editorial Board. + + It reviews the state of happiness in the world today and shows how the science of happiness explains personal and national variations in happiness. + + citation_full: |- + + Helliwell, J. F., Layard, R., Sachs, J. D., De Neve, J.-E., Aknin, L. B., & Wang, S. (Eds.). (2024). World Happiness Report 2024. University of Oxford: Wellbeing Research Centre. + + version_producer: 2024 + + url_main: https://worldhappiness.report/ed/2024/ + + url_download: https://happiness-report.s3.amazonaws.com/2024/DataForFigure2.1+with+sub+bars+2024.xls + + date_accessed: '2024-06-09' + + date_published: '2024-03-08' + + license: + + name: '' + + New values: 264 / 1787 (14.77%) country Switzerland Turkey United Arab Emirates Uruguay Yemen ~ Changed values: 1505 / 1787 (84.22%) country - country + New Zealand Afghanistan Tanzania Liberia Azerbaijan Malaysia Iraq Niger Nepal Spain ~ Column level_0 (new data) + + New values: 264 / 1787 (14.77%) level_0 1531 1624 1659 1704 1763 ~ Column year (new data, changed data) + + New values: 264 / 1787 (14.77%) year 2020 2023 2016 2017 2021 ~ Changed values: 1386 / 1787 (77.56%) year - year + 2020.0 2014 2018.0 2022 2015.0 2021 2014.0 2017 2011.0 2014 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-06-13 10:23:09 UTC Execution time: 17.30 seconds