owid / etl

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

📊 conflict: ucdp update #3201

Closed lucasrodes closed 2 months ago

lucasrodes commented 2 months ago

[tracking issue]

View diff without step copy

Tasks

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

Login: ssh owid@staging-site-update-ucdp-2

chart-diff: ✅
  • 37/37 reviewed charts
    • Modified: 37/37
    • New: 0/0
data-diff: ❌ Found differences ```diff ~ Dataset garden/countries/2024-08-27/gleditsch (new version) - - short_name: gleditsch_no_population ? -------------- + + short_name: gleditsch - - version: '2024-01-08' ? ^ ^^ + + version: '2024-08-27' ? ^ ^^ + + Table gleditsch_regions + + Column number_countries + + Column population = Table gleditsch_countries ~ Dim id + + New values: 197 / 20418 (0.96%) year id 2023 57 2023 370 2023 501 2023 692 2023 830 ~ Dim year + + New values: 197 / 20418 (0.96%) id year 57 2023 370 2023 501 2023 692 2023 830 2023 ~ Column country (new data) + + New values: 197 / 20418 (0.96%) id year country 57 2023 Saint Vincent and the Grenadines 370 2023 Belarus 501 2023 Kenya 692 2023 Bahrain 830 2023 Singapore = Table gleditsch + Dataset garden/war/2024-08-26/ucdp + + Table ucdp + + Column number_deaths_ongoing_conflicts + + Column number_deaths_ongoing_conflicts_high + + Column number_deaths_ongoing_conflicts_low + + Column number_ongoing_conflicts + + Column number_new_conflicts + + Column number_ongoing_conflicts_per_country + + Column number_ongoing_conflicts_per_country_pair + + Column number_new_conflicts_per_country + + Column number_new_conflicts_per_country_pair + + Column number_deaths_ongoing_conflicts_per_capita + + Column number_deaths_ongoing_conflicts_high_per_capita + + Column number_deaths_ongoing_conflicts_low_per_capita + + Table ucdp_country + + Column participated_in_conflict + + Column number_participants + + Table ucdp_locations + + Column is_location_of_conflict + + Column number_deaths + + Column number_deaths_low + + Column number_deaths_high + + Column death_rate + + Column death_rate_low + + Column death_rate_high + + Column number_locations + Dataset garden/war/2024-08-26/ucdp_prio + + Table ucdp_prio + + Column number_deaths_ongoing_conflicts + + Column number_deaths_ongoing_conflicts_high + + Column number_deaths_ongoing_conflicts_low + + Column number_deaths_ongoing_conflicts_per_capita + + Column number_deaths_ongoing_conflicts_high_per_capita + + Column number_deaths_ongoing_conflicts_low_per_capita 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-08-29 18:13:29 UTC Execution time: 24.86 seconds