31:[{"id":"297999e4b6a81b5e0a4344f2f7d2d420ecad5a03cb3fb7a3848e61bc4060ba8f1fbabef896f5f07cac249bf21637842e27c5531a93644faa0eb78cc39efb2471","href":"https://static.observableusercontent.com/files/297999e4b6a81b5e0a4344f2f7d2d420ecad5a03cb3fb7a3848e61bc4060ba8f1fbabef896f5f07cac249bf21637842e27c5531a93644faa0eb78cc39efb2471","name":"https _en.wikipedia.org_wiki_List_of_cities_in_Ohio.txt","type":"text/plain","lastModified":1633698918643.117,"size":196753}] 2f:{"title":"Ohio Cities Example","cells":[{"id":0,"value":"# Ohio Cities Example","pinned":false,"hidden":false,"mode":"md"},{"id":87,"value":"page = FileAttachment(\"https _en.wikipedia.org_wiki_List_of_cities_in_Ohio.txt\").text()","pinned":true,"hidden":false,"mode":"ojs"},{"id":90,"value":"data = {\n const $ = cheerio.load(page)\n const table = $(\"table\").eq(1)\n const rows = table.find(\"tr\")\n const result = []\n for(let i = 1; i < rows.length; i = i + 1){\n const row = rows.eq(i)\n const cells = row.find(\"td\")\n if(cells.length == 3){\n const city = cells.eq(0).text()\n let population = cells.eq(1).text()\n population = population.split(\",\")\n population = population[0]+population[1]\n population = parseInt(population)\n let url = cells.eq(0).find(\"a\").eq(0).attr(\"href\")\n url = url.split(\" \")\n url = url[0]\n url = \"https://en.wikipedia.org\"+url\n result.push({\n city:city,\n population:population,\n url:url\n })\n }\n }\n return result\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"table = (data) => {\n let table = ``\n for(let i = 0; i < data.length; i = i + 1){\n table = table + ` `\n }\n table = table + `

${data[i].population}

`\n return table\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":137,"value":"html`${table(data.filter(d => d.population > 200000))}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":17,"value":"_____________________________________________","pinned":false,"hidden":false,"mode":"html"},{"id":3,"value":"cheerio = require('https://bundle.run/cheerio@1.0.0-rc.2')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}