charts_without_tag (view)

Data license: CC-BY

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: edit_url

CREATE VIEW charts_without_tag AS
select id,
    title,
    "https://owid.cloud/admin/variables/" || variableId as edit_url,
    "https://owid.cloud/admin/charts/" || id || "/edit" as chart_edit_url
from charts c
    join (
        select chartId,
            max(variableId) as variableId
        from chart_variables
        group by chartId
    ) cv on c.id = cv.chartId
where id not in (
        select chartId
        from chart_tags
    )
    and json_extract(config, "$.isPublished")
order by id;