charts_without_origin_url (view)

Data license: CC-BY

142 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: isPublished

Next page

CREATE VIEW charts_without_origin_url AS
select title,
    group_concat(t.name) as tags,
    printf("https://owid.cloud/admin/charts/%d/edit", c.id) AS URL,
    CASE
        WHEN JSON_EXTRACT(config, "$.isPublished") IS NOT NULL THEN TRUE
        ELSE FALSE
    END AS isPublished
from charts c
    left join chart_tags ct on c.id = ct.chartId
    left join tags t on ct.tagId = t.id
where (
        trim(json_extract(config, "$.originUrl")) = ""
        OR json_extract(config, "$.originUrl") IS NULL
    )
group by c.title
order by 2,
    1;