30:[] 2e:{"title":"","cells":[{"id":0,"value":"html`\n

SPARCS

Companion Notebook to bit.ly/loadsparcs, a tool to traverse and visualize NY's Statewide Planning and Research Cooperative System (SPARCS).

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":10,"value":"html`\n

Query

The data, is organized by year. Here are the respective urls:

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"urls={return {\n \"2009\":{url:\"https://health.data.ny.gov/resource/s8d9-z734\"},\n \"2010\":{url:\"https://health.data.ny.gov/resource/dpew-wqcg\"},\n \"2011\":{url:\"https://health.data.ny.gov/resource/n5y9-zanf\"},\n \"2012\":{url:\"https://health.data.ny.gov/resource/rv8x-4fm3\"},\n \"2013\":{url:\"https://health.data.ny.gov/resource/tdf6-7fpk\"},\n \"2014\":{url:\"https://health.data.ny.gov/resource/pzzw-8zdv\"},\n \"2015\":{url:\"https://health.data.ny.gov/resource/82xm-y6g8\"},\n \"2016\":{url:\"https://health.data.ny.gov/resource/gnzp-ekau\"}\n}}","pinned":false,"hidden":false,"mode":"ojs"},{"id":27,"value":"html`\n

Type SQL SELECT query after chosing years, and then click \"Get Data\":

\n\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"html`\n

Methods

UI functions, ran to define user interaction:\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":99,"value":"selectYears(document.getElementById('yearsDiv'))","pinned":false,"hidden":false,"mode":"ojs"},{"id":46,"value":"selectYears=(yearsDiv)=>{\n yearsDiv.innerHTML='' // reset\n Object.keys(urls).forEach(yr=>{\n var sp = document.createElement('span')\n sp.innerHTML=` [${yr}] `\n yearsDiv.appendChild(sp)\n console.log(yr)\n })\n return html`

selectYears - lists years with urls where the SQL query will be applied

`\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}