etl icon indicating copy to clipboard operation
etl copied to clipboard

📊 mpox: get data from the WHO Shiny App

Open spoonerf opened this issue 1 year ago • 1 comments
trafficstars

Hey @Marigold - it looks like the data for suspected cases is base64 encoded in the WHO Shiny App. I've had a go at extracting it here, but not sure how solid the snapshot method is.

This could be a new source of suspected cases and deaths from the WHO, but annoyingly they don't include data for either of these prior to 2024, when I think there were suspected cases from Sept 2023.

spoonerf avatar Sep 18 '24 13:09 spoonerf

Quick links (staging server):

Site Dev Site Preview Admin Wizard Docs

Login: ssh owid@staging-site-mpox-who

chart-diff: ❌
  • 0/1 reviewed charts
  • Modified: 0/0
  • New: 0/1
  • Rejected: 0
data-diff: ❌ Found differences
= Dataset garden/artificial_intelligence/2024-02-05/chess
  = Table chess
    ~ Column elo_rating (changed data)
        ~ Changed values: 5 / 39 (12.82%)
                         entity  year  elo_rating -  elo_rating +
          Computer chess engine  1994          2321          2314
          Computer chess engine  2009          3237          3227
          Computer chess engine  2010          3237          3227
          Computer chess engine  2011          3237          3236
          Computer chess engine  2023          3591          3586
= Dataset garden/climate/2023-12-20/surface_temperature
  = Table surface_temperature
    ~ Dim country
-       - Removed values: 195 / 198120 (0.10%)
                time        country
          2024-09-15     Azerbaijan
          2024-09-15 Cayman Islands
          2024-09-15        Iceland
          2024-09-15     Mauritania
          2024-09-15          Syria
    ~ Dim time
-       - Removed values: 195 / 198120 (0.10%)
                 country       time
              Azerbaijan 2024-09-15
          Cayman Islands 2024-09-15
                 Iceland 2024-09-15
              Mauritania 2024-09-15
                   Syria 2024-09-15
    ~ Column anomaly_above_0 (changed metadata, changed data)
-       -       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 13-October-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^^^^
+       +       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 08-July-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^
-       -     url_main: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
        ?                                                        -                 --- ^^^
+       +     url_main: https://cds.climate.copernicus.eu/cdsapp#!/dataset/reanalysis-era5-single-levels-monthly-means?tab=overview
        ?                                                 +++++++++                         ^^^^
-       -     date_accessed: '2024-10-13'
        ?                          -  ^^
+       +     date_accessed: '2024-09-09'
        ?                           + ^^
-       -       url: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
+       +       url: https://cds.climate.copernicus.eu/api/v2/terms/static/licence-to-use-copernicus-products.pdf

-       - Removed values: 195 / 198120 (0.10%)
                 country       time  anomaly_above_0
              Azerbaijan 2024-09-15         0.462318
          Cayman Islands 2024-09-15         0.991404
                 Iceland 2024-09-15              NaN
              Mauritania 2024-09-15              NaN
                   Syria 2024-09-15         0.533661
        ~ Changed values: 178 / 198120 (0.09%)
            country       time  anomaly_above_0 -  anomaly_above_0 +
           Eswatini 2024-07-15           1.658533           1.688419
           Ethiopia 2024-07-15           1.084501           1.096569
            Georgia 2024-07-15           0.436285           0.445435
          Palestine 2024-07-15           1.805534           1.794146
          Sri Lanka 2024-07-15           0.765444           0.761246
    ~ Column anomaly_below_0 (changed metadata, changed data)
-       -       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 13-October-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^^^^
+       +       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 08-July-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^
-       -     url_main: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
        ?                                                        -                 --- ^^^
+       +     url_main: https://cds.climate.copernicus.eu/cdsapp#!/dataset/reanalysis-era5-single-levels-monthly-means?tab=overview
        ?                                                 +++++++++                         ^^^^
-       -     date_accessed: '2024-10-13'
        ?                          -  ^^
+       +     date_accessed: '2024-09-09'
        ?                           + ^^
-       -       url: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
+       +       url: https://cds.climate.copernicus.eu/api/v2/terms/static/licence-to-use-copernicus-products.pdf

-       - Removed values: 195 / 198120 (0.10%)
                 country       time  anomaly_below_0
              Azerbaijan 2024-09-15              NaN
          Cayman Islands 2024-09-15              NaN
                 Iceland 2024-09-15        -2.098898
              Mauritania 2024-09-15        -0.597481
                   Syria 2024-09-15              NaN
        ~ Changed values: 18 / 198120 (0.01%)
                   country       time  anomaly_below_0 -  anomaly_below_0 +
                   Armenia 2024-07-15          -0.028605          -0.020540
          Falkland Islands 2024-07-15          -0.020439          -0.020252
                   Ireland 2024-07-15          -0.681512          -0.678696
                Luxembourg 2024-07-15          -0.052393          -0.045513
              South Africa 2024-07-15          -0.076799          -0.077826
    ~ Column temperature_2m (changed metadata, changed data)
-       -       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 13-October-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^^^^
+       +       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 08-July-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^
-       -     url_main: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
        ?                                                        -                 --- ^^^
+       +     url_main: https://cds.climate.copernicus.eu/cdsapp#!/dataset/reanalysis-era5-single-levels-monthly-means?tab=overview
        ?                                                 +++++++++                         ^^^^
-       -     date_accessed: '2024-10-13'
        ?                          -  ^^
+       +     date_accessed: '2024-09-09'
        ?                           + ^^
-       -       url: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
+       +       url: https://cds.climate.copernicus.eu/api/v2/terms/static/licence-to-use-copernicus-products.pdf

-       - Removed values: 195 / 198120 (0.10%)
                 country       time  temperature_2m
              Azerbaijan 2024-09-15       19.739519
          Cayman Islands 2024-09-15       29.171906
                 Iceland 2024-09-15        3.523594
              Mauritania 2024-09-15       31.549084
                   Syria 2024-09-15       27.082411
        ~ Changed values: 187 / 198120 (0.09%)
                               country       time  temperature_2m -  temperature_2m +
          Democratic Republic of Congo 2024-07-15         25.216959         25.217566
                      French Polynesia 2024-07-15         24.805243         24.793869
                                  Mali 2024-07-15         33.311260         33.352962
                             Nicaragua 2024-07-15         26.291531         26.319424
                                 Spain 2024-07-15         24.528801         24.531157
    ~ Column temperature_anomaly (changed metadata, changed data)
-       -       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 13-October-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^^^^
+       +       Hersbach, H., Bell, B., Berrisford, P., Biavati, G., Horányi, A., Muñoz Sabater, J., Nicolas, J., Peubey, C., Radu, R., Rozum, I., Schepers, D., Simmons, A., Soci, C., Dee, D., Thépaut, J-N. (2023): ERA5 monthly averaged data on single levels from 1940 to present. Copernicus Climate Change Service (C3S) Climate Data Store (CDS), DOI: 10.24381/cds.f17050d7 (Accessed on 08-July-2024)
        ?                                                                                                                                                                                                                                                                                                                                                                                          ^^ ^^^^
-       -     url_main: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
        ?                                                        -                 --- ^^^
+       +     url_main: https://cds.climate.copernicus.eu/cdsapp#!/dataset/reanalysis-era5-single-levels-monthly-means?tab=overview
        ?                                                 +++++++++                         ^^^^
-       -     date_accessed: '2024-10-13'
        ?                          -  ^^
+       +     date_accessed: '2024-09-09'
        ?                           + ^^
-       -       url: https://cds.climate.copernicus.eu/datasets/reanalysis-era5-pressure-levels-monthly-means?tab=overview
+       +       url: https://cds.climate.copernicus.eu/api/v2/terms/static/licence-to-use-copernicus-products.pdf

-       - Removed values: 195 / 198120 (0.10%)
                 country       time  temperature_anomaly
              Azerbaijan 2024-09-15             0.462318
          Cayman Islands 2024-09-15             0.991404
                 Iceland 2024-09-15            -2.098898
              Mauritania 2024-09-15            -0.597481
                   Syria 2024-09-15             0.533661
        ~ Changed values: 195 / 198120 (0.10%)
                 country       time  temperature_anomaly -  temperature_anomaly +
              Azerbaijan 2024-07-15              -0.010904               0.004639
          Cayman Islands 2024-07-15               0.813578               0.791605
                 Iceland 2024-07-15              -0.067851              -0.068989
              Mauritania 2024-07-15               0.793327               0.806118
                   Syria 2024-07-15               1.561756               1.554132
= Dataset garden/democracy/2024-03-07/bmr
  = Table population_regime_years
    ~ Column population_years_in_democracy_consec (changed metadata)
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_years_in_democracy_ws_consec (changed metadata)
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table num_countries_regime_years
    ~ Column num_countries_years_in_democracy_consec (changed metadata)
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_years_in_democracy_ws_consec (changed metadata)
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == '91+' -%>
        ?     -                      -
+       +   <% if category == '91+' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table population_regime
    ~ Column population_regime (changed metadata)
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_regime_ws (changed metadata)
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table num_countries_regime
    ~ Column num_countries_regime (changed metadata)
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_regime_ws (changed metadata)
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- if category == 0 -%>
        ?     -                  -
+       +   <% if category == 0 %>
-       -   <%- elif category == 1 -%>
        ?     -                    -
+       +   <% elif category == 1 %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table bmr
= Dataset garden/democracy/2024-03-07/eiu
  = Table num_people
    ~ Column pop_regime_eiu (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table num_countries
    ~ Column num_regime_eiu (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table eiu
  = Table avg_pop
= Dataset garden/democracy/2024-03-07/fh
  = Table fh
  = Table fh_regions
    ~ Column num_electdem_fh (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- elif category == 'Non-electoral democracy' -%>
        ?     -                                            -
+       +   <% elif category == 'Non-electoral democracy' %>
-       -   <%- elif category == 'Electoral democracy' -%>
        ?     -                                        -
+       +   <% elif category == 'Electoral democracy' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_regime_fh (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- elif category == 'Not free' -%>
        ?     -                             -
+       +   <% elif category == 'Not free' %>
-       -   <%- elif category == 'Partly free' -%>
        ?     -                                -
+       +   <% elif category == 'Partly free' %>
-       -   <%- elif category == 'Free' -%>
        ?     -                         -
+       +   <% elif category == 'Free' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_electdem_fh (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- elif category == 'Non-electoral democracy' -%>
        ?     -                                            -
+       +   <% elif category == 'Non-electoral democracy' %>
-       -   <%- elif category == 'Electoral democracy' -%>
        ?     -                                        -
+       +   <% elif category == 'Electoral democracy' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_regime_fh (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- elif category == 'Not free' -%>
        ?     -                             -
+       +   <% elif category == 'Not free' %>
-       -   <%- elif category == 'Partly free' -%>
        ?     -                                -
+       +   <% elif category == 'Partly free' %>
-       -   <%- elif category == 'Free' -%>
        ?     -                         -
+       +   <% elif category == 'Free' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
= Dataset garden/democracy/2024-03-07/lexical_index
  = Table region_aggregates
    ~ Column num_democracy_lied (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_group_age_electdem_lied (changed metadata)
-       -   <%- if 'years' in category -%>
        ?     -                        -
+       +   <% if 'years' in category %>
-       -   <%- elif category == '-1' -%>
        ?     -                       -
+       +   <% elif category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_group_age_polyarchy_lied (changed metadata)
-       -   <%- if 'years' in category -%>
        ?     -                        -
+       +   <% if 'years' in category %>
-       -   <%- elif category == '-1' -%>
        ?     -                       -
+       +   <% elif category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_regime_lied (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_suffrage_lied (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_democracy_lied (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_group_age_electdem_lied (changed metadata)
-       -   <%- if 'years' in category -%>
        ?     -                        -
+       +   <% if 'years' in category %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_group_age_polyarchy_lied (changed metadata)
-       -   <%- if 'years' in category -%>
        ?     -                        -
+       +   <% if 'years' in category %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_regime_lied (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_suffrage_lied (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table lexical_index
= Dataset garden/democracy/2024-03-07/polity
  = Table polity
  = Table num_people
    ~ Column pop_group_age_dem_polity (changed metadata)
-       -   <%- if 'years' in category -%>
        ?     -                        -
+       +   <% if 'years' in category %>
-       -   <%- elif category == '-1' -%>
        ?     -                       -
+       +   <% elif category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pop_regime_polity (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table num_countries
    ~ Column num_group_age_dem_polity (changed metadata)
-       -   <%- if 'years' in category -%>
        ?     -                        -
+       +   <% if 'years' in category %>
-       -   <%- elif category == '-1' -%>
        ?     -                       -
+       +   <% elif category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_regime_polity (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table avg_pop
= Dataset garden/democracy/2024-03-07/vdem
  = Table vdem_population
    ~ Column population_hoe (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_hog (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_hos (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_regime (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_regime_amb (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_wom_parl (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- elif category == '0% women' -%>
        ?     -                             -
+       +   <% elif category == '0% women' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_years_in_electdem (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column population_years_in_libdem (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table vdem
  = Table vdem_multi_with_regions
    ~ Column civ_libs_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column civ_soc_str_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column corr_exec_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column corr_jud_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column corr_leg_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column corr_publsec_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column corruption_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column delibdem_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column dom_auton_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column egaldem_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column electdem_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column int_auton_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column libdem_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column participdem_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column personalism_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column phys_integr_libs_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column pol_libs_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column priv_libs_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column public_admin_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column rule_of_law_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column socgr_civ_libs_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column socgr_pow_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column terr_contr_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column wom_civ_libs_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column wom_civ_soc_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column wom_emp_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column wom_parl_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column wom_pol_par_vdem (changed metadata)
-       -   <%- if aggregate_method == 'average' -%>
        ?     -                                  -
+       +   <% if aggregate_method == 'average' %>
-       -   <%- elif aggregate_method < 'population-weighted average' -%>
        ?     -                                                       -
+       +   <% elif aggregate_method < 'population-weighted average' %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
  = Table vdem_multi_without_regions
  = Table vdem_num_countries
    ~ Column num_countries_hoe (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_hog (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_hos (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_regime (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_regime_amb (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_wom_parl (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- elif category == '0% women' -%>
        ?     -                             -
+       +   <% elif category == '0% women' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_years_in_electdem (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column num_countries_years_in_libdem (changed metadata)
-       -   <%- if category == '-1' -%>
        ?     -                     -
+       +   <% if category == '-1' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
= Dataset garden/demography/2023-09-27/survivor_percentiles
  = Table survivor_percentiles
    ~ Column age (changed metadata)
-       -   <%- if percentile == 1 -%>
        ?     -                    -
+       +   <% if percentile == 1 %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
= Dataset garden/demography/2023-10-03/life_tables
  = Table life_tables
    ~ Column central_death_rate_mf_ratio (changed metadata)
-       -   <%- if type == "cohort" -%>
        ?     -                     -
+       +   <% if type == "cohort" %>
-       -   <%- elif type == "period" -%>
        ?     -                       -
+       +   <% elif type == "period" %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
    ~ Column life_expectancy (changed metadata)
-       -   <%- if age == '0' -%>
        ?     -               -
+       +   <% if age == '0' %>
-       -   <%- if sex == 'both' -%>
        ?     -                  -
+       +   <% if sex == 'both' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- if sex == 'both' -%>
        ?     -                  -
+       +   <% if sex == 'both' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -     <%- if type == "period" -%>
        ?       -                     -
+       +     <% if type == "period" %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if type == "period" -%>
        ?       -                     -
+       +     <% if type == "period" %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if age != '0' -%>
        ?       -               -
+       +     <% if age != '0' %>
-       -     <%- if type == "period" -%>
        ?       -                     -
+       +     <% if type == "period" %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
    ~ Column life_expectancy_fm_diff (changed metadata)
-       -     <%- if type == "period" -%>
        ?       -                     -
+       +     <% if type == "period" %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if type == "period" -%>
        ?       -                     -
+       +     <% if type == "period" %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
    ~ Column life_expectancy_fm_ratio (changed metadata)
-       -     <%- if type == "period" -%>
        ?       -                     -
+       +     <% if type == "period" %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if type == "period" -%>
        ?       -                     -
+       +     <% if type == "period" %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
= Dataset garden/demography/2023-10-09/life_expectancy
  = Table life_expectancy_only_proj
    ~ Column life_expectancy_0_only_proj (changed metadata)
-       -   <%- if age == 0 -%>
        ?     -             -
+       +   <% if age == 0 %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
    ~ Column life_expectancy_only_proj (changed metadata)
-       -   <%- if age == 0 -%>
        ?     -             -
+       +   <% if age == 0 %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
  = Table life_expectancy_with_proj
    ~ Column life_expectancy_0_with_proj (changed metadata)
-       -   <%- if age == 0 -%>
        ?     -             -
+       +   <% if age == 0 %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if (age == 0) and (sex == 'all') -%>
        ?       -                                  -
+       +     <% if (age == 0) and (sex == 'all') %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
    ~ Column life_expectancy_with_proj (changed metadata)
-       -   <%- if age == 0 -%>
        ?     -             -
+       +   <% if age == 0 %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if (age == 0) and (sex == 'all') -%>
        ?       -                                  -
+       +     <% if (age == 0) and (sex == 'all') %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
  = Table life_expectancy
    ~ Column life_expectancy (changed metadata)
-       -   <%- if age == 0 -%>
        ?     -             -
+       +   <% if age == 0 %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if (age == 0) and (sex == 'all') -%>
        ?       -                                  -
+       +     <% if (age == 0) and (sex == 'all') %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
    ~ Column life_expectancy_0 (changed metadata)
-       -   <%- if age == 0 -%>
        ?     -             -
+       +   <% if age == 0 %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- if sex == 'all' -%>
        ?     -                 -
+       +   <% if sex == 'all' %>
-       -   <%- else -%>
        ?     -      -
+       +   <% else %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
-       -     <%- if age == '0' -%>
        ?       -               -
+       +     <% if age == '0' %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
-       -     <%- if (age == 0) and (sex == 'all') -%>
        ?       -                                  -
+       +     <% if (age == 0) and (sex == 'all') %>
-       -     <%- else -%>
        ?       -      -
+       +     <% else %>
-       -     <%- endif -%>
        ?       -       -
+       +     <% endif %>
= Dataset garden/demography/2023-10-20/broken_limits_le
  = Table broken_limits_le
    ~ Column country_with_max_le (changed metadata)
-       -   Name of the country with the yearly maximum life expectancy registered<%- if (sex == 'female') %> among females<% elif (sex == 'male') %> among males<% endif -%>.
        ?                                                                           -                                                                                     -
+       +   Name of the country with the yearly maximum life expectancy registered<% if (sex == 'female') %> among females<% elif (sex == 'male') %> among males<% endif %>.
    ~ Column life_expectancy (changed metadata)
-       -   <%- if (sex == 'female') -%>
        ?     -                      -
+       +   <% if (sex == 'female') %>
-       -   <%- elif (sex == 'male') -%>
        ?     -                      -
+       +   <% elif (sex == 'male') %>
-       -   <%- elif (sex == 'all') -%>
        ?     -                     -
+       +   <% elif (sex == 'all') %>
-       -   <%- endif -%>
        ?     -       -
+       +   <% endif %>
= Dataset garden/demography/2024-07-12/un_wpp_historical
  = Table estimates
    ~ Column population_estimates (changed metadata)
-       -       <%- if variant != 'estimates' -%> Projections from 2024 onwards are based on the UN's << variant >> scenario. <%- endif -%>
        ?                                     -                                                                                         -
+       +       <%- if variant != 'estimates' %> Projections from 2024 onwards are based on the UN's << variant >> scenario. <%- endif %>
  = Table projections
    ~ Column population (changed metadata)
-       -       <%- if variant != 'estimates' -%> Projections from 2024 onwards are based on the UN's << variant >> scenario. <%- endif -%>
        ?                                     -                                                                                         -
+       +       <%- if variant != 'estimates' %> Projections from 2024 onwards are based on the UN's << variant >> scenario. <%- endif %>
= Dataset garden/health/2024-06-11/isaps_plastic_surgery
  = Table isaps_plastic_surgery
    ~ Column num_procedures (changed metadata)
-       -   <%- if (category_1 == 'all') -%>
        ?     -                          -
+       +   <% if (category_1 == 'all') %>
-       -   <%- elif (category_1 != 'all') and (category_2 == 'all') -%>
        ?     -                                                      -
+       +   <% elif (category_1 != 'all') and (category_2 == 'all') %>
-       -   <%- elif (category_1 != 'all') and (category_2 != 'all') and (procedure_name == 'all') -%>
        ?     -            

...diff too long, truncated...

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-20 10:37:46 UTC Execution time: 6.84 seconds

owidbot avatar Sep 18 '24 13:09 owidbot

@spoonerf what's the status of this PR?

(no urgency, just doing some đź§ą)

lucasrodes avatar Dec 12 '24 10:12 lucasrodes