31:T10a4,table = (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).localeCompare(JSON.stringify(b)); let res = as > bs ? 1 : as < bs ? -1 : 0; 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; }32:T7b3,function SearchForm({ object = "", uid = DOM.uid("autosuggestion").id, placeholder = "", description = "", description2 = "", identifier = "", format = (d) => d, suggestion = () => [] } = {}) { const input = htl.html``; const tag = htl.html`

${description}

`; const input2 = htl.html``; const tag2 = htl.html`

${description2}

`; const datalist = htl.html``; const form = htl.html`

${input}${tag}${input2}${tag2}${datalist}`; let results = []; form.value = ""; // starting value form.onsubmit = (event) => event.preventDefault(); function getValueByKey(object, key) { return Object.values(object).find(value => object[value] === key); } form.onchange = (event) => { const value = event.target.value; form.value = results.find((d) => format(d) == value) || ""; input.blur(); // removes keyboard focus from the element upon submission form.dispatchEvent(new CustomEvent("input")); input2.value= object.find(obj => obj.title === value)["identifier"] }; form.dispatchEvent(new CustomEvent("input2")); // "cache" const options = new Map(); const getOption = async (text) => options.get(text) || (text ? options.set(text, await suggestion(text)) : options.set(text, []), options.get(text)); input.oninput = async (event) => { let value = event.target.value; results = await getOption(value); d3.select(`#${uid}`) .selectAll("option") .data(results) .join("option") .attr("value", format); }; return form; }33:[] 2f:{"title":"Select individual Medicaid Datasets","cells":[{"id":474,"value":"# Select individual Medicaid Datasets","pinned":false,"hidden":false,"mode":"md"},{"id":477,"value":"Start by typing in the search box and get the data set in the object below (ie. NADAC)","pinned":false,"hidden":false,"mode":"md"},{"id":117,"value":"viewof wiki = SearchForm({\n placeholder: \"Type-in to search...\",\n object: Medicaid,\n description: \"Searching Medicaid open data titles\",\n description2: \"Corresponding identifier\",\n\n suggestion: async (text) => {\n const res = Medicaid.map(dat =>{return dat.title});\n console.log(res.filter(str=>str.includes(text)))\n //identifier: \"kiii\"\n return res;\n },\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"data = (await fetch(`https://data.medicaid.gov/api/1/datastore/query/${Medicaid.find(obj => obj.title === wiki)[\"identifier\"]}/0`)).json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":269,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":488,"value":"# Explore All Medicaid Datasets using an Identifier","pinned":false,"hidden":false,"mode":"md"},{"id":69,"value":"Medicaid = (await fetch(\"https://data.medicaid.gov/api/1/metastore/schemas/dataset/items\")).json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":498,"value":"## EXAMPLE API CALL:","pinned":false,"hidden":false,"mode":"md"},{"id":501,"value":"State Drug Utilization Data (SDUD) has been reported by states since the start of the Medicaid Drug Rebate Program for covered outpatient drugs paid for by state Medicaid agencies.","pinned":false,"hidden":false,"mode":"md"},{"id":493,"value":"State_Drug_Utilization_Data_2022 = (await fetch(`https://data.medicaid.gov/api/1/datastore/query/200c2cba-e58d-4a95-aa60-14b99736808d/0`)).json()","pinned":true,"hidden":false,"mode":"ojs"},{"id":486,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":77,"value":"table(\n Medicaid.slice(0, 1000).map(\n ({ title, identifier}) => ({\n Title: md`**${title}**`,\n Identifier: md`**${identifier}**`,\n \n })\n )\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":75,"value":"____","pinned":false,"hidden":false,"mode":"md"},{"id":84,"value":"md`

\n\n--- \n\n## Appendix\n\n*A few cells used to implement this notebook lie below. Click the left margin to toggle them open if you wish.*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":92,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":94,"value":"identity = i => i","pinned":false,"hidden":false,"mode":"ojs"},{"id":96,"value":"defaultOptions = ({ columns: {}, style: 'normal', paged: 10 })","pinned":true,"hidden":false,"mode":"ojs"},{"id":100,"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"},{"id":98,"value":"d3 = require('d3@5')","pinned":true,"hidden":false,"mode":"ojs"},{"id":80,"value":"import { table2 } from \"@tmcw/tables/2\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":114,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":408,"value":"async function fetchAll(url, maxPolls = null) {\n const allResults = []\n\n if (maxPolls == null) maxPolls = Infinity\n \n for (let i = 0; i < maxPolls; i++) {\n const offset = i * 10000\n let queryUrl = `${url}?limit=10000&offset=${offset}`\n \n const results = (await (await fetch(queryUrl)).json()).results\n results.forEach(result => allResults.push(result))\n \n if (results.length < 10000) {\n break \n }\n }\n \n return allResults\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":303,"value":"import {Text} from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}