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

:bar_chart: oecd: Official Development Assistance data #3168

Closed paarriagadap closed 2 months ago

paarriagadap commented 3 months ago

Main issue: https://github.com/owid/owid-issues/issues/1620

Given the lack of documentation, this PR has taken longer than expected. We still want to make adjustments, but probably after Stockholm.

Also in this issue:

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

Login: ssh owid@staging-site-upload-oecd-oda-data

chart-diff: ✅
  • 29/29 reviewed charts
    • Modified: 29/29
    • New: 0/0
data-diff: ✅ No differences found ```diff + Dataset garden/oecd/2024-08-21/official_development_assistance + + Table official_development_assistance + + Column i_oda_grant_equivalents + + Column i_oda_net_disbursements + + Column oda_bilateral_2_grant_equivalents + + Column oda_bilateral_2_net_disbursements + + Column oda_multilateral_2_grant_equivalents + + Column oda_multilateral_2_net_disbursements + + Column ii_oof_net_disbursements + + Column iii_officially_supported_export_credits_net_disbursements + + Column iv_private_flows_market_terms_net_disbursements + + Column oda_share_gni_net_disbursements + + Column oda_share_gni_grant_equivalents + + Column oda_bilateral_grant_equivalents + + Column oda_multilateral_grant_equivalents + + Column oda_grant_equivalents + + Column flows_share_gni_net_disbursements + + Column flows_net_disbursements + + Column v_net_private_grants_net_disbursements + + Column flows_share_gni_grant_equivalents + + Column i_oda_net_disbursements_per_capita + + Column oda_grant_equivalents_per_capita + + Column i_oda_net_disbursements_share_gni_2 + + Column oda_grant_equivalents_share_gni_2 + + Column oda_inverted + + Column development_food_aid_recipient + + Column grants_recipient + + Column humanitarian_aid_recipient + + Column loans_recipient + + Column oda_recipient + + Column oda_share_gni_recipient + + Column technical_cooperation_recipient + + Column oda_recipient_per_capita + + Column grants_recipient_per_capita + + Column loans_recipient_per_capita + + Column technical_cooperation_recipient_per_capita + + Column development_food_aid_recipient_per_capita + + Column humanitarian_aid_recipient_per_capita + + Column oda_by_sector 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-09-17 12:56:00 UTC Execution time: 10.02 seconds

Marigold commented 2 months ago

@paarriagadap ignore the error about Variables used in charts will not be deleted automatically: .... It's unrelated to the PR and should be fixed once you merge it.

paarriagadap commented 2 months ago

@lucasrodes Would it be possible for you to review this one on Tuesday? Let me know if you can't!