charts_with_manual_year (view)

Data license: CC-BY

100 rows

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE VIEW charts_with_manual_year AS
SELECT id,
    title,
    printf("https://owid.cloud/admin/charts/%s/edit", id) AS edit_url
FROM charts
WHERE (
        (
            json_extract(config, "$.maxTime") IS NOT NULL
            AND json_extract(config, "$.maxTime") != "earliest"
            AND json_extract(config, "$.maxTime") != "latest"
        )
        OR (
            json_extract(config, "$.map.time") != "latest"
            AND json_extract(config, "$.hasMapTab") = TRUE
        )
    )
    AND json_extract(config, "$.isPublished");