owid / etl

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

:construction: Draft PR for branch guinea-worm-two #2885

Closed antea04 closed 5 days ago

owidbot commented 6 days ago
Quick links (staging server): Site Admin Wizard

Login: ssh owid@staging-site-guinea-worm-two

chart-diff: ✅ No charts for review.
data-diff: ❌ Found differences ```diff = Dataset garden/who/2023-06-29/guinea_worm = Table guinea_worm ~ Dim country + + New values: 196 / 8624 (2.27%) year country 2023 Bahrain 2023 Chad 2023 Ireland 2023 Moldova 2023 Syria ~ Dim year + + New values: 196 / 8624 (2.27%) country year Bahrain 2023 Chad 2023 Ireland 2023 Moldova 2023 Syria 2023 ~ Column certification_status (new data) + + New values: 196 / 8624 (2.27%) country year certification_status Bahrain 2023 NaN Chad 2023 NaN Ireland 2023 NaN Moldova 2023 NaN Syria 2023 NaN ~ Column guinea_worm_reported_cases (new data) + + New values: 196 / 8624 (2.27%) country year guinea_worm_reported_cases Bahrain 2023 0 Chad 2023 9 Ireland 2023 0 Moldova 2023 0 Syria 2023 0 ~ Column year_certified (new data) + + New values: 196 / 8624 (2.27%) country year year_certified Bahrain 2023 NaN Chad 2023 nan Ireland 2023 NaN Moldova 2023 NaN Syria 2023 NaN ~ Dataset garden/who/2024-06-17/guinea_worm (new version) - - version: '2023-06-29' ? ^ ^^ + + version: '2024-06-17' ? ^ ^^ = Table guinea_worm ~ Dim country + + New values: 196 / 8624 (2.27%) year country 2023 Bahrain 2023 Chad 2023 Ireland 2023 Moldova 2023 Syria ~ Dim year + + New values: 196 / 8624 (2.27%) country year Bahrain 2023 Chad 2023 Ireland 2023 Moldova 2023 Syria 2023 ~ Column certification_status (new data) + + New values: 196 / 8624 (2.27%) country year certification_status Bahrain 2023 Certified disease free Chad 2023 Endemic Ireland 2023 Certified disease free Moldova 2023 Certified disease free Syria 2023 Certified disease free ~ Column guinea_worm_reported_cases (new data) + + New values: 196 / 8624 (2.27%) country year guinea_worm_reported_cases Bahrain 2023 0 Chad 2023 9 Ireland 2023 0 Moldova 2023 0 Syria 2023 0 ~ Column year_certified (new data, changed data) + + New values: 196 / 8624 (2.27%) country year year_certified Bahrain 2023 1998 Chad 2023 Endemic Ireland 2023 1998 Moldova 2023 1998 Syria 2023 1998 ~ Changed values: 6863 / 8624 (79.58%) country year year_certified - year_certified + Andorra 2000 nan 1998 Argentina 2013 nan 2000 Papua New Guinea 1999 nan 1997 Switzerland 1994 NaN nan Tuvalu 1984 NaN nan 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-24 15:52:00 UTC Execution time: 19.13 seconds

antea04 commented 5 days ago

original branch merged