Published
Edited
May 4, 2019
1 fork
Importers
10 stars
sql(`SELECT initcap(lower(word)), count(*)
FROM (
SELECT regexp_split_to_table(profile, '[^a-zA-Z-]+') as word
FROM artists
WHERE data_quality = 'Correct' AND profile != ''
LIMIT 10000
) t, wordsets
WHERE word = ANY(items)
GROUP BY lower(word)
ORDER BY count(*) desc
LIMIT 10000`)
clike = function(codeString) {
const codeHtml = Prism.highlight(codeString, Prism.languages.clike, 'clike');
const pageHtml = `<style>${css}</style><pre>${codeHtml}<pre>`;
return html`${pageHtml}`;
}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
