3f:null 40:["$","title",null,{"children":"Ohio Cities Example | Aliyana Albarkishi | Observable"}] 46:[{"id":"8f38eaaa1d04c917e815943e732fd54d4851eb80af6e8022fe66d0d3fcac57297287d275b7308e9718262cefc09200df1acc7788a69c22689fdbf5bdda6fd53f","href":"https://static.observableusercontent.com/files/8f38eaaa1d04c917e815943e732fd54d4851eb80af6e8022fe66d0d3fcac57297287d275b7308e9718262cefc09200df1acc7788a69c22689fdbf5bdda6fd53f","name":"OhioCities.html","type":"text/html","lastModified":1633705832779.449,"size":132010}] 44:{"id":"bc2d46cc12846d67","slug":"ohio-cities-example","title":"Ohio Cities Example","thumbnail":"575281d249c040c01b868caa19febd39441d7bd477b1d7080ad59b013d9f7428","access_level":"public","create_time":"$D2021-10-08T15:04:40.570Z","update_time":"$D2021-10-11T16:14:35.015Z","view_time":null,"first_public_time":"$D2021-10-11T16:16:04.255Z","has_unpublished_edits":null,"fork":{"id":"c829d31717e70bf1","slug":"cheerio-template","title":"Cheerio Template","owner":{"id":"66151b62b45d9fca","login":"credmond","name":"Charles Redmond"}},"stars":0,"starred":false,"owner":{"type":"team","id":"79bb0ba774780635","login":"aliyana2502","name":"Aliyana Albarkishi","avatar_url":null,"tier":"starter_2024","bio":"","following":false},"version":131,"publish_version":131,"role":null,"authored":false,"authors":[{"type":"individual","id":"39adf4b8473b36c1","login":"aliyana2502","name":"Aliyana Albarkishi","avatar_url":null,"tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"39adf4b8473b36c1","login":"aliyana2502","name":"Aliyana Albarkishi","avatar_url":null,"tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Ohio Cities Example","cells":[{"id":0,"value":"# Ohio Cities Example","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"page = FileAttachment(\"OhioCities.html\").text()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"html`${table(\n data.filter(d => d.population > 300000)\n)}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"_____________________________________________","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"cheerio = require('https://bundle.run/cheerio@1.0.0-rc.2')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W46","stdlib":"1"}} 45:"$44:body"