28:null 29:["$","title",null,{"children":"AA Periodical Poetry Tabular Data Viewer 中 | Melanie Walsh | Observable"}] 2e:T539,table = new Tabulator("#table-container", { height: 645, autoColumns: true, maxWidth: 100, columnDefaults: { headerMenu: columnHeaderMenu, //maxWidth: 500, headerFilter: "input", headerFilterPlaceholder: "Search", headerFilterLiveFilter: true }, columns: [ { title: "Year", field: "year", formatter: function (cell, formatterParams, onRendered) { const value = cell.getValue(); const date = new Date(value); const year = date.getFullYear(); return year; } } ], clipboard: true, // eanble clipboard copy and paste clipboardPasteAction: "replace", layout: tableLayout, layoutColumnsOnNewData: true, movableColumns: movableColumns, movableRows: movableRows, selectable: selectableRows, rowContextMenu: rowContextMenu, pagination: pagination, paginationSize: paginationSize, paginationSizeSelector: pageSizes, renderVerticalBuffer: 300, // set virtual DOM buffer to 300px debugInvalidOptions: true, // tabulator warnings debugEventsExternal: ["tableBuilding", "dataLoaded", "tableBuilt"], // log specified tabulator events data: table_data, persistenceMode: "local", persistenceID: dataUrl, persistentLayout: true, persistence: { sort: true, filter: true, group: true, columns: true } })2f:T7f9,function setupFilterRow(table) { const table_data = table.getData(); if (!Array.isArray(table_data) || table_data.length === 0) { console.error("Table data is empty or not an array."); return; } const filterColumns = Object.keys(table_data[0]).map((key) => ({ title: key.charAt(0).toUpperCase() + key.slice(1).replace(/_/g, " "), field: key })); // Define variables for input elements const fieldEl = document.getElementById("filter-field"); const typeEl = document.getElementById("filter-type"); const valueEl = document.getElementById("filter-value"); if (!fieldEl || !typeEl || !valueEl) { console.error( "One or more elements not found: filter-field, filter-type, filter-value" ); return; } // Clear previous options fieldEl.innerHTML = ""; typeEl.innerHTML = ""; // Populate filter-field options filterColumns.forEach((col) => { const option = document.createElement("option"); option.value = col.field; option.textContent = col.title; fieldEl.appendChild(option); }); // Populate filter-type options const filterTypes = ["=", "<", "<=", ">", ">=", "!=", "like"]; filterTypes.forEach((type) => { const option = document.createElement("option"); option.value = type; option.textContent = type; typeEl.appendChild(option); }); // Trigger setFilter function with correct parameters function updateFilter() { const filterVal = fieldEl.value; const typeVal = typeEl.value; if (filterVal) { table.setFilter(filterVal, typeVal, valueEl.value); } } // Update filters on value change fieldEl.addEventListener("change", updateFilter); typeEl.addEventListener("change", updateFilter); valueEl.addEventListener("keyup", updateFilter); // Clear filters on "Clear Filters" button click document .getElementById("filter-clear") .addEventListener("click", function () { fieldEl.value = ""; typeEl.value = "="; valueEl.value = ""; table.clearFilter(); }); }30:[] 2c:{"id":"d26a73a377141f3c","slug":null,"title":"AA Periodical Poetry Tabular Data Viewer 中","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-07-16T16:42:20.348Z","update_time":"$D2025-01-10T20:36:55.385Z","view_time":null,"first_public_time":"$D2024-07-24T22:39:00.127Z","has_unpublished_edits":null,"fork":{"id":"206a0a693c40b3fa","slug":null,"title":"AA Periodical Poetry Tabular Data Viewer 中","owner":{"id":"1be53ef47b72f2b5","login":"juans","name":"Juans"}},"stars":0,"starred":false,"owner":{"type":"team","id":"64cb03831ce357a8","login":"mellymeldubs","name":"Melanie Walsh","avatar_url":"https://avatars-next.observableusercontent.com/b844e0b83b020387c8c7f8e02189c8037f7dda15061c591e49ca2fc69da49fca","tier":"pro_2024"},"version":687,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"e1772ab3096311b8","login":"mellymeldubs","name":"Melanie Walsh","avatar_url":"https://avatars-next.observableusercontent.com/b844e0b83b020387c8c7f8e02189c8037f7dda15061c591e49ca2fc69da49fca","tier":null}],"members":[{"type":"team","id":"64cb03831ce357a8","login":"mellymeldubs","name":"Melanie Walsh","avatar_url":"https://avatars-next.observableusercontent.com/b844e0b83b020387c8c7f8e02189c8037f7dda15061c591e49ca2fc69da49fca","tier":"pro_2024","role":"editor"},{"type":"individual","id":"e1772ab3096311b8","login":"mellymeldubs","name":"Melanie Walsh","avatar_url":"https://avatars-next.observableusercontent.com/b844e0b83b020387c8c7f8e02189c8037f7dda15061c591e49ca2fc69da49fca","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"AA Periodical Poetry Tabular Data Viewer 中","cells":[{"id":0,"value":"# AA Periodical Poetry Tabular Data Viewer 中\n\nUse this [Tabular Data Viewer 中](https://twitter.com/hashtag/TabularDataViewer?src=hashtag_click) notebook 📓 to view sample datasets or preview any public\n[Apache Arrow](https://observablehq.com/@randomfractals/apache-arrow), \n**CSV**, [**GeoJSON**](https://www.rfc-editor.org/rfc/rfc7946.html) or **JSON array** data with [Summary Table](https://observablehq.com/@observablehq/summary-table) and [Tabulator](http://tabulator.info/). Just paste your data url to fetch it. \n\nAlso, try our [Data Table](https://github.com/RandomFractals/vscode-data-table/releases) 🈸 notebook 📓 cell ⌗ output renderer extension with [VSCode Notebooks](https://marketplace.visualstudio.com/search?target=VSCode&category=Notebooks&sortBy=Installs) 📚.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":19,"value":"viewof dataSet = Inputs.select(dataSets, {\n label: html`Dataset`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"viewof dataUrl = Inputs.text({\n label: html`Copy raw dataset url`,\n placeholder: \"type data url and click fetch\",\n value: `${\n dataUrlParam\n ? dataUrlParam\n : \"https://raw.githubusercontent.com/melaniewalsh/responsible-datasets-in-context/main/datasets/aa-periodical-poetry/\" +\n dataSet\n }`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"shareLink = md `*share a link to your [data](https://observablehq.com/@randomfractals/tabular-data-viewer?dataUrl=${dataUrl})*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":427,"value":"columns = raw_data.columns;","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":429,"value":"viewof selectedColumns = Inputs.checkbox(columns, {\n label: \"Select Columns\",\n value: preselectedColumns\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"preselectedColumns = [\n \"year\",\n \"gender (if known)\",\n \"published in (city\",\n \"Magazine Type\",\n \"author (first last)\",\n \"venue\",\n \"edited by\",\n \"form (if known)\",\n \"themes\",\n \"second venue\",\n \"published in (city)\",\n \"month\"\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":431,"value":"column_data = {\n const selected = new Set(selectedColumns);\n return summary_data.map(row => {\n let newRow = {};\n for (let key in row) {\n if (selected.has(key)) {\n newRow[key] = row[key];\n }\n }\n return newRow;\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":460,"value":"// Function to copy text to clipboard\nfunction copyToClipboard(text) {\n const tempInput = document.createElement(\"input\");\n tempInput.value = text;\n document.body.appendChild(tempInput);\n tempInput.select();\n document.execCommand(\"copy\");\n document.body.removeChild(tempInput);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":462,"value":"// Create the copy URL button\nviewof copyUrlButton = Inputs.button(\n html`Copy Raw Data URL `,\n {\n reduce: () => {\n copyToClipboard(dataUrl);\n alert(\"URL copied to clipboard: \" + dataUrl);\n }\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":59,"value":"viewof dataSummaryView = SummaryTable(column_data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"## Tabular Data View","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":219,"value":"viewof tableOptions = Inputs.form([\n Inputs.button(\"Download Data\", {\n reduce: () => table.download(\"csv\", dataSet),\n className: \"custom-button\"\n })\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":464,"value":"viewof twobuttons = html`\n

\n ${viewof tableOptions} ${viewof copyUrlButton}\n

\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":617,"value":"filterRow = html`

\n \n \n \n \n

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":682,"value":"viewof datasetHeader = html`

${md`Featured Dataset: **${dataSet}**`}