2f:null 30:["$","title",null,{"children":"Observable Table of Literature on Indigenous Peoples | Aaron Kyle Dennis | Observable"}] 35:Tf77,table_adjustment = (data, options) => { options = Object.assign({}, defaultOptions, options); const {sortable, rank, paged} = options; let sortKey = undefined; let sortDirection = true; let page = 0; if (sortable && rank) { throw new Error('A table can either be ranked or sortable, but not both'); } let columns = Object.keys(data[0]).map(key => { const opts = options.columns[key] || {}; return { key: key, type: opts.type || typeof data[0][key], options: opts }; }); function bake() { if (sortKey) { data = data.slice().sort((a, b) => { let as = a[sortKey]; let bs = b[sortKey]; // make this sort stable if (as == bs) return JSON.stringify(a) > JSON.stringify(b); let res = as > bs; if (sortDirection) res = !res; return res; }); } let rows = data.slice(page * paged, (page * paged) + paged); let pages = Math.ceil(data.length / paged); return html`

${options.header === false ? `` : html` ${rank ? html`` : ''} ${columns.map(c => { return th(c, sortKey, sortDirection, sortable); })} `} ${rows.map((row, i) => html` ${rank ? html`` : ''} ${columns.map(c => { let displayValue = (c.options.formatter || identity)(row[c.key], i, row); if (displayValue instanceof window.HTMLElement && displayValue.tagName == 'TD') { return displayValue; } return html`` })} `)}


${i + 1}	${displayValue}

${pages ? html`` : ''}

`; } let dom = bake(); function rerender() { dom.firstChild.remove(); dom.appendChild(bake().firstChild); } dom.addEventListener('click', e => { if (e.target.tagName === 'TH' && sortable) { if (sortKey == e.target.dataset.key) { sortDirection = !sortDirection; } sortKey = e.target.dataset.key; rerender(); } if (e.target.tagName === 'BUTTON') { if (e.target.dataset.action) { switch (e.target.dataset.action) { case 'next': page++, rerender(); break; case 'previous': page--, rerender(); break; } } else if (e.target.dataset.page) { page = parseInt(e.target.dataset.page), rerender(); } } }); return dom; }36:[] 33:{"id":"e6635c9d5b5ace2a","slug":"observable-table-of-literature-on-indigenous-peoples","title":"Observable Table of Literature on Indigenous Peoples","thumbnail":"990c787d668db4a0cc32e68f5df57604dedb7db08f5b5efa7cc9e94ddfa3f2e8","access_level":"public","create_time":"$D2019-01-25T13:01:00.760Z","update_time":"$D2021-02-18T15:53:01.095Z","view_time":null,"first_public_time":"$D2019-01-25T16:05:17.017Z","fork":{"id":"6a419dd0e215f527","slug":"learning-toms-table-function-for-observable","title":"Learning Tom's Table Function for Observable","owner":{"id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis"}},"stars":2,"starred":false,"owner":{"type":"team","id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":"starter_2024"},"version":214,"publish_version":214,"role":null,"authored":false,"authors":[{"type":"individual","id":"a7fa3027921865cf","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":null}],"members":[{"type":"individual","id":"a7fa3027921865cf","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":{"id":"63becdb427ae4c93","slug":"learning-by-doing","title":"Learning By Doing","owner":{"id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis"}},"type":"notebook","body":{"title":"Observable Table of Literature on Indigenous Peoples","cells":[{"id":0,"value":"md`# Observable Table of Literature on Indigenous Peoples`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":170,"value":"md`Thanks to everyone for [helping me learn to](https://talk.observablehq.com/t/when-is-it-allowed-to-use-white-space-in-js-object-key-supplying-headers-to-toms-table/1604), especially [@bgchecn](https://beta.observablehq.com/@bryangingechen) for being super generous with his time. This is a proof-of-concept table for a large collection of literature, which I am publishing to help prevent it from getting lost in my notebooks ;)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"table(ip_research_table, {\n title: \"Indigenous Peoples Literature\",\n paged: 40,\n sortable: true,\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"md`This notebooks utilizes Tom's [Tables](https://beta.observablehq.com/@tmcw/tables).\n\nTom's function is called in using \\`import\\`:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"import {table} from \"@tmcw/tables/2\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":183,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":187,"value":"identity = i => i","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"defaultOptions = ({ columns: {}, style: 'normal', paged: 25 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":191,"value":"th = (c, sortKey, sortDirection, sortable) => {\n let {\n options: { title }\n } = c;\n let sortIndicator = sortKey && sortDirection ? \"↑\" : \"↓\";\n let arrow = html`${sortIndicator}`;\n let displayedTitle = title !== undefined ? title : c.key;\n return c.type === \"number\"\n ? html`\n ${arrow}${displayedTitle}\n `\n : html`\n ${displayedTitle}${arrow}\n `;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":67,"value":"md`I'll also need \\`d3.js\\`:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"md`Although it's been years since I worked on it, I want to keep my dataset 'flexible' (read:unwieldy), so I'll use Google Sheets. To make my spreadsheet accessible to JavaScript, I'll [borrow on a trick from Bryan Chen](https://beta.observablehq.com/@bryangingechen/importing-data-from-google-spreadsheets-into-a-notebook-we).`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"md`Essentially, Brian's script will convert all data in a Google TSV to an array of objects. For convenience, the source URL of the script is supplied separatly.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"ip_research_url = `https://docs.google.com/spreadsheets/d/e/2PACX-1vSeqr7E4_zSSBgOIf7bJMFsW1GfKNZj_pFAndcEfiIiM6qLi1rIuRhqSPFYCe2veNesXmv1PGYiDOny/pub?gid=0&single=true&output=tsv`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"ip_research = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let names =[];\n const spreadsheet = await d3.tsv(ip_research_url).then(data => data.forEach(d => names.push(d))); // d3.tsv returns a Promise\n return names;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"md`\nAnd finally, to the table! Here's a first pass a rendering out subset of information. \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"ip_research_table = ip_research.map(({key, \"original file name\":originalFileName, \"Region / Country:\":region ,\"Author(s)\":authors, \"Title / Article Name\":title, Year, \"Journal / Publication\":journal,}) => ({\n authors,\n Year,\n title,\n journal,\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"md`\n It's working a bit crazily for now in the sense that clicking the title will sort data, but see what happens when you clear 'year' several times in a row ;) [Philippe Deschaseaux\n has a fix for this](https://beta.observablehq.com/compare/5a59b457a394ff1c...1e70540aa08c9094), but I haven't implemented it yet...\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"md`I'll move the actual table to the top of this notebook now that it's working so as not to burry the lead ;)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 34:"$33:body"