33:[{"id":"6e359d63bab38c43b2a18c7dce2c8d056495ac684652549b8ddc764082484f1767ec39257660fe84d06cb1294548ee27c857e8f731001b6685762c45a7d67f5b","href":"https://static.observableusercontent.com/files/6e359d63bab38c43b2a18c7dce2c8d056495ac684652549b8ddc764082484f1767ec39257660fe84d06cb1294548ee27c857e8f731001b6685762c45a7d67f5b","name":"https _en.wikipedia.org_wiki_List_of_municipalities_in_Ohio.htm","type":"text/html","lastModified":1637597255605.824,"size":126884}] 32:{"title":"Ohio Cities","cells":[{"id":0,"value":"# Ohio Cities","pinned":false,"hidden":false,"mode":"md"},{"id":87,"value":"page = FileAttachment(\"https _en.wikipedia.org_wiki_List_of_municipalities_in_Ohio.htm\").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\").attr(\"href\")\n url = \"https://en.wikipedia.org\" + url\n result.push({city:city,population:population,url:url})\n }\n }\n return result\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":149,"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":155,"value":"html `${table(\n data.filter(record => record.population > 100000)\n .sort((a,b)=>b.population - a.population)\n)}`","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":true,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}