41:null 42:["$","title",null,{"children":"Ohio Cities Example | Sakura Gavin | Observable"}] 48:[{"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":1633964567106.065,"size":196753}] 46:{"id":"b039d60040954507","slug":"ohio-cities-example","title":"Ohio Cities Example","thumbnail":"517093831c4d9dc6b3a168ecd68a90f4b03d0c3906e6c2598a2587655bdc336c","access_level":"public","create_time":"$D2021-10-11T15:02:47.106Z","update_time":"$D2021-10-13T16:43:55.171Z","view_time":null,"first_public_time":"$D2021-10-11T16:18:49.581Z","has_unpublished_edits":null,"fork":{"id":"e454aca27b6617be","slug":"ohio-cities-example/2","title":"Ohio Cities Example","owner":{"id":"66151b62b45d9fca","login":"credmond","name":"Charles Redmond"}},"stars":0,"starred":false,"owner":{"type":"team","id":"e6e35eaca7d80d81","login":"sgavin93","name":"Sakura Gavin","avatar_url":null,"tier":"starter_2024","bio":"","following":false},"version":173,"publish_version":173,"role":null,"authored":false,"authors":[{"type":"individual","id":"eab589938d94f1ab","login":"sgavin93","name":"Sakura Gavin","avatar_url":null,"tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"eab589938d94f1ab","login":"sgavin93","name":"Sakura Gavin","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":87,"value":"page = FileAttachment(\"https _en.wikipedia.org_wiki_List_of_cities_in_Ohio.txt\").text()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"table = (data) => { //turning table into function so we can filter in example of below\n let table = ``\n for(let i = 0; i < data.length; i = i + 1){\n table = table + ` `\n \n }\n table = table + `

${data[i].population}

`\n return table\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"html `${table(\n data.filter(d => d.population > 30000)\n)}`","pinned":true,"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":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W48","stdlib":"1"}} 47:"$46:body"