3e:null 3f:["$","title",null,{"children":"BCAI SoLE Data Navigator | Andrew Nicklin | Observable"}] 45:T7a6,overview_matrix = Plot.plot({ color: { legend: true, scheme: "warm", nice: true, type: "log", label: "Count of Primary Series Values (or if categorized, the smallest number across all categories)" }, x: { tickRotate: 30, label: "Place" }, y: { label: "Topic > Metric (Series Count)" }, marks: [ Plot.cell(metricPlaceMap, { x: (d) => d.place_display_label, y: (d) => d.metric_display_label, fill: (d) => d.seriesValueCount, opacity: (d) => (d.hasSeriesValues ? 1 : 0.1) }), Plot.text(metricPlaceMap, { x: (d) => d.place_display_label, y: (d) => d.metric_display_label, text: (d) => (d.hasTrend ? "T" : undefined), fill: "white", fontWeight: "bold", fontSize: "1.5em", dx: 5, dy: 1 }), Plot.text(metricPlaceMap, { x: (d) => d.place_display_label, y: (d) => d.metric_display_label, text: (d) => d.hasSeriesValues ? (d.hasCategories ? "C" : undefined) : undefined, fill: "white", fontWeight: "bold", fontSize: "1.5em", dx: -5, dy: 1 }), Plot.cell(metricPlaceMap, { x: (d) => d.place_display_label, y: (d) => d.metric_display_label, fill: "black", opacity: 0, title: (d) => d.series_display_label }) ], width: width, marginLeft: 275, marginRight: 100, marginBottom: 150, caption: htl.html`What does each metric/place look like?

If a metric isn't in this list (e.g. Broadband coverage), there is no data for it at all
No box indicates primary series isn't specified
Light grey denotes no values in the primary series for that place
A box with color indicates the count of values for the primary series (see top of chart)
C denotes the primary series has categories
T denotes trend information should be available (5 or more SeriesValues)

Note: selecting a database file does not upload it anywhere; it just stays in your browser tab. Each time you visit this page you will need to repeat this process.

BCAI Database Summary: Records per table`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":637,"value":"---\n## Metric by Place View\nThis graph visualizes the presence (or lack) of a primary series for every Metric/Place combination. Refer to the notes below the graph for help interpreting.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":705,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":861,"value":"---\n### Quick Data Explorer\nThis explorer helps you view data in a similar manner to the website MVP.\n\n(When selecting a new place, topic, or metric, the primary series will be chosen by default.)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":797,"value":"viewof explorer2SelectedCity = Inputs.select(bcai.Place, {\n format: d => d.PlaceDescription?.[selectedLanguage.code]?.display_label || d.id,\n label: 'Select a place'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1339,"value":"${selectedLanguage.code ? explorer2SelectedCity.PlaceDescription?.[selectedLanguage.code]?.display_details || 'description missing' : \"(select a language to display the place description here)\" }","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":801,"value":"viewof explorer2SelectedTopic = Inputs.select(bcai.Topic, {\n format: d => d.TopicDescription?.[selectedLanguage.code]?.display_label || d.id,\n label: 'Select a topic'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1328,"value":"${selectedLanguage.code ? explorer2SelectedTopic.TopicDescription?.[selectedLanguage.code]?.display_details || 'description missing' : \"(select a language to display the topic description here)\" }","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":806,"value":"viewof explorer2SelectedMetric = Inputs.select(explorer2SelectedTopic.Metric, {\n format: d => d.MetricDescription?.[selectedLanguage.code]?.display_label || d.id,\n label: 'Select a metric'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1344,"value":"${selectedLanguage.code ? explorer2SelectedMetric.MetricDescription?.[selectedLanguage.code]?.display_details || 'description missing' : \"(select a language to display the metric description here)\" }","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":816,"value":"viewof explorer2SelectedSeries = Inputs.select(explorer2SelectedMetric.Series, {\n format: d => d.SeriesDescription?.[selectedLanguage.code]?.display_axis_primary || d.id,\n label: 'Select a series',\n value: explorer2SelectedMetric.MetricSeries?.find(ms => ms.place_id === explorer2SelectedCity.id)?.Series\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1356,"value":"${selectedLanguage.code ? explorer2SelectedSeries.SeriesDescription?.[selectedLanguage.code]?.display_details || 'details/description missing' : \"(select a language to display the series details/description here)\" }","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1289,"value":"Graph view\n\nAlways shows a timeline; if you see multiple timelines or multiple dots at the same place on the horizontal axis, this is likely a categorized series. Unlike the website, values are here are not formatted to be more human-readable. Hover over dots to see values.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":834,"value":"Plot.plot({\n x: {\n label: \"Date\"\n },\n y: {\n label:\n explorer2SelectedSeries.SeriesDescription?.[selectedLanguage.code]\n ?.display_axis_primary || explorer2SelectedSeries.id\n },\n marks: [\n Plot.lineY(explorer2SelectedSeriesValue, {\n x: (d) => d.date,\n y: (d) => d.value,\n z: (d) => d.Category\n }),\n Plot.dot(explorer2SelectedSeriesValue, {\n x: (d) => d.date,\n y: (d) => d.value,\n z: (d) => d.Category,\n r: 5,\n fill: \"blue\",\n title: (d) =>\n `${\n d.Category?.CategoryDescription?.display_label ||\n d.Category?.id ||\n \"(uncategorized)\"\n } : ${d.value}`\n })\n ],\n width: width,\n marginLeft: 75\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1287,"value":"Table view","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":830,"value":"viewof explorer2SelectedSeriesValue = Inputs.table(\n explorer2SelectedSeries?.SeriesValueByPlace?.[explorer2SelectedCity.id] || [],\n {\n label: \"Table view\",\n columns: [\n \"date\",\n \"category_id\",\n \"datasource_ids\",\n \"value\",\n \"delta\",\n \"trend\"\n ]\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1379,"value":"## Multi-selection Explorer\n\nThe multi-selection explorer allows you, ultimately, to view Series Values (as a table) while allowing arbitrary filtering for Place, Topic, Metric, and Series.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":163,"value":"Select one or more places by checking the boxes in the leftmost column of the list.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":181,"value":"viewof selectedPlace = Inputs.table(bcai.Place.map(p => {\n return {\n id: p.id,\n display_label: p.PlaceDescription?.[selectedLanguage.code]?.display_label || '[missing]',\n display_on_website: p.display_on_website\n }\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":190,"value":"Select one or more topics:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":159,"value":"viewof selectedTopics = Inputs.table(bcai.Topic, { label: \"Select a topic\"} )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"Select one or more metrics:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":166,"value":"viewof selectedMetric = Inputs.table(selectedTopics.flatMap(t => t.Metric || []), {columns: [\"topic_id\", \"id\", \"display_order\", \"primary_series_id\", \"display_on_website\"], format: {id: d => d.split(\"-\").pop()}})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"Select one or more series:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":170,"value":"viewof selectedSeries = Inputs.table(selectedMetric.flatMap(s => s.Series || []), {columns: [\"metric_id\", \"id\", \"frequency\", \"value_type\", \"display_min_value\", \"display_max_value\", \"display_on_website\"]})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"Series values based upon above selections:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":176,"value":"viewof selectedSeriesValue = Inputs.table(\n selectedSeries.flatMap((s) => s.SeriesValue || []),\n {\n columns: [\n \"series_id\",\n \"place_id\",\n \"date\",\n \"category_id\",\n \"datasource_ids\",\n \"value\",\n \"delta\",\n \"trend\"\n ]\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1226,"value":"---\n\n## Hierarchy explorer\nThe hierarchy explorer allows you to explore the data starting at the Topic level, then by Metric, then by Series. There are additional capabilities which are not possible in other views, such as viewing all series values, grouped by place. This also allows you to see associated metadata and other attributes which might otherwise be invisible on the website or in other explorers on this page. To expand items, look for black triangles ( ) and click. Generally an expansion will show you the first 20 items, but you can always click the `...more` to load the next 20. Properties which start with a lower case letter are directly from the database; properties which start with an upper case letter have been added by the processing engine on this web page to allow for easier navigation.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":145,"value":"topics = bcai.Topic","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1220,"value":"---\n\n## Raw Database Explorer\nThis view allows you to examine tables as they appear in the original database file that you uploaded.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1206,"value":"viewof selectedTable = Inputs.select(bcai._tables, {\n label: \"Select a raw table\",\n value: \"Topic\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1211,"value":"rawDataOfSelectedTable = await await dbClient.query(\n `SELECT * FROM ${selectedTable} ORDER BY 1`\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1217,"value":"Inputs.table(rawDataOfSelectedTable)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1235,"value":"---\n\n## Scratchpad\n\n(This area may have temporary javascript code which needs to be persisted between sessions. The work here does not affect anything in the other sections of this page.)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1164,"value":"seriesWithCategories = [\n ...new Set(\n bcai.SeriesValue.filter((sv) => sv.category_id).map((sv) => sv.series_id)\n )\n]\n .map((id) => bcai.Series.find((s) => s.id === id))\n .map((s) => ({\n series_id: s.id,\n topic: s.Metric.Topic.TopicDescription.EN.display_label,\n metric: s.Metric.MetricDescription.EN.display_label,\n series: s.SeriesDescription.EN.display_axis_primary,\n label: s.SeriesDescription.EN.display_label,\n chart: s.chart_type\n }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"viewof table = Inputs.table(bcai.Series.map(s => {\n return {\n id: s.id,\n topic_label: s.Metric.Topic.TopicDescription?.[selectedLanguage.code]?.display_label || '[missing]',\n metric_label: s.Metric.MetricDescription?.[selectedLanguage.code]?.display_label || '[missing]',\n series_label: s.SeriesDescription?.[selectedLanguage.code]?.display_label || '[missing]'\n }\n}), {\n sort: 'topic_label'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1228,"value":"---\n\n## under the hood\nThis area contains all the code to load the selected database, process it for use on this page, and some page styling code","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1364,"value":"","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":685,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1095,"value":"dbClient = sqliteFile.sqlite()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W48","stdlib":"1"}} 44:"$43:body"