2b:null 2c:["$","title",null,{"children":"Data Insights Insights | ikesau | Observable"}] 31:[] 2f:{"id":"42e525f48c8becb1","slug":"data-insights-insights","title":"Data Insights Insights","thumbnail":"571875fda47dc63e254b9179748ed58224bb60c2ea403e384f68ceb1648c9cc8","access_level":"public","create_time":"$D2024-10-18T15:16:31.338Z","update_time":"$D2024-10-18T15:46:15.993Z","view_time":null,"first_public_time":"$D2024-10-18T15:16:31.338Z","fork":{"id":"2d704b817fae862f","slug":"scratchpad","title":"scratchpad","owner":{"id":"2299edab1244ee80","login":"ikesau","name":"ikesau"}},"stars":0,"starred":false,"owner":{"type":"team","id":"2299edab1244ee80","login":"ikesau","name":"ikesau","avatar_url":"https://avatars-next.observableusercontent.com/2c9b79e1f724e178262a9c61abb970dde273f055a54014ae9aef6c5c298882aa","tier":"starter_2024"},"version":499,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b7d57f3cb9c3785b","login":"ikesau","name":"ikesau","avatar_url":"https://avatars-next.observableusercontent.com/2c9b79e1f724e178262a9c61abb970dde273f055a54014ae9aef6c5c298882aa","tier":null}],"members":[{"type":"team","id":"2299edab1244ee80","login":"ikesau","name":"ikesau","avatar_url":"https://avatars-next.observableusercontent.com/2c9b79e1f724e178262a9c61abb970dde273f055a54014ae9aef6c5c298882aa","tier":"starter_2024","role":"editor"},{"type":"individual","id":"b7d57f3cb9c3785b","login":"ikesau","name":"ikesau","avatar_url":"https://avatars-next.observableusercontent.com/2c9b79e1f724e178262a9c61abb970dde273f055a54014ae9aef6c5c298882aa","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Data Insights Insights","cells":[{"id":0,"value":"# Data Insights Insights\n\nA minimal overview of Our World in Data's [Data Insight](https://ourworldindata.org/data-insights) coverage.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":424,"value":"html`\n

Topics with zero Data Insights

Expand to see all

${tag}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":453,"value":"## Search Data Insight content","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":455,"value":"viewof search = Inputs.search(\n dataInsights.map((dataInsight) => dataInsight.markdown)\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":461,"value":"{\n if (search.length === dataInsights.length)\n return md`_Try searching for \"internet\", \"GDP\", etc..._`;\n if (search.length === 0) return md`_No results_`;\n\n return md`\n### Results\n${search\n .map((result) => `* ${result.slice(0, result.indexOf(\")\") + 1)}`)\n .join(\"\\n\")}\n`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":443,"value":"## Data insights by topic","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":396,"value":"md`\n${Object.entries(dataInsightsByTag)\n .sort((a, b) => b[1].length - a[1].length)\n .map(\n ([tag, dataInsights]) => `### ${tag}\n${dataInsights\n .map(\n (dataInsight) =>\n `* [${dataInsight.title}](https://ourworldindata.org/data-insights/${dataInsight.slug})`\n )\n .join(\"\\n\")}`\n )\n .join(\"\\n\\n\")}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":421,"value":"___\n### Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":373,"value":"dataInsights = fetch(\n \"https://datasette-public.owid.io/owid.json?sql=SELECT%0D%0A++p.slug%2C%0D%0A++p.title%2C%0D%0A++p.markdown%2C%0D%0A++JSON_GROUP_ARRAY%28t.name%29+AS+tags%0D%0AFROM%0D%0A++posts_gdocs+p%0D%0A++JOIN+posts_gdocs_x_tags+pxt+ON+p.id+%3D+pxt.gdocId%0D%0A++JOIN+tags+t+ON+t.id+%3D+pxt.tagId%0D%0AWHERE%0D%0A++type+%3D+%27data-insight%27%0D%0A++AND+p.published+%3D+1%0D%0AGROUP+BY%0D%0A++p.slug\"\n)\n .then((res) => res.json())\n .then((json) =>\n json.rows.map((row) => ({\n slug: row[0],\n title: row[1],\n markdown:\n `[${row[1]}](https://ourworldindata.org/data-insights/${row[0]})` +\n row[2].toLowerCase(),\n tags: JSON.parse(row[3]) || []\n }))\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":380,"value":"dataInsightsByTag = {\n const counts = {};\n for (const dataInsight of dataInsights) {\n for (const tag of dataInsight.tags) {\n if (counts[tag]) {\n counts[tag].push(dataInsight);\n } else {\n counts[tag] = [dataInsight];\n }\n }\n }\n return counts;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":385,"value":"allTagNames = fetch(\n \"https://datasette-public.owid.io/owid.json?sql=SELECT+name+FROM+tags\"\n)\n .then((res) => res.json())\n .then((json) => json.rows.flat())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":392,"value":"tagsMissingDataInsights = allTagNames\n .filter((tag) => !dataInsightsByTag[tag])\n .filter((tag) => !TAGS_TO_IGNORE.includes(tag))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":432,"value":"TAGS_TO_IGNORE = [\n \"Uncategorized\",\n \"Abstract\",\n \"Entries\",\n \"tag-graph-root\",\n \"SDG Tracker\",\n \"Short updates and facts\",\n \"core-econ.org\",\n \"World Regions\",\n \"Projects\",\n \"System\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 30:"$2f:body"