unused_old_datasets (view)

Data license: CC-BY

16 rows

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE VIEW unused_old_datasets AS
SELECT name,
    printf("https://owid.cloud/admin/datasets/%d", id) as url
FROM datasets d
WHERE NOT EXISTS (
        SELECT 1
        FROM chart_variables cv
            JOIN variables v ON cv.variableId = v.id
        WHERE v.datasetId = d.id
    )
    AND isArchived = 0
    AND createdAt <= date('now', '-1 year')
    AND updatedAt <= date('now', '-1 year')
    AND metadataEditedAt <= date('now', '-1 year')
    AND dataEditedAt <= date('now', '-1 year')
    AND description not like '%core-econ%';