3f:null 40:["$","title",null,{"children":"Ohio Cities Example | Adam Gralnick | Observable"}] 46:[{"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":1633962451063.114,"size":196753}] 44:{"id":"1c56b25329e5ce05","slug":"ohio-cities-example","title":"Ohio Cities Example","thumbnail":"c2af61e6e8aa4f09e3bd13ca891a608b70715670b9cbcfc9b44bba790bb05cfd","access_level":"public","create_time":"$D2021-10-11T14:27:31.063Z","update_time":"$D2021-10-11T14:27:31.063Z","view_time":null,"first_public_time":"$D2021-10-11T14:27:36.989Z","has_unpublished_edits":null,"fork":{"id":"3c5ab945a9dbb351","slug":"ohio-cities-example","title":"Ohio Cities Example","owner":{"id":"66151b62b45d9fca","login":"credmond","name":"Charles Redmond"}},"stars":0,"starred":false,"owner":{"type":"team","id":"38e9d7b50a896ca5","login":"agralnick","name":"Adam Gralnick","avatar_url":"https://avatars-next.observableusercontent.com/348764ff12b51259b8f503f000b50ea2c5a5e8eebb4361ded40fa58d93d6f3c0","tier":"starter_2024","bio":"Student at Mercyhurst University. Using this for data science.","following":false},"version":141,"publish_version":141,"role":null,"authored":false,"authors":[{"type":"individual","id":"13ae05683fb5875c","login":"agralnick","name":"Adam Gralnick","avatar_url":"https://avatars-next.observableusercontent.com/348764ff12b51259b8f503f000b50ea2c5a5e8eebb4361ded40fa58d93d6f3c0","tier":null,"bio":"Student at Mercyhurst University. Using this for data science.","following":false}],"members":[{"type":"individual","id":"13ae05683fb5875c","login":"agralnick","name":"Adam Gralnick","avatar_url":"https://avatars-next.observableusercontent.com/348764ff12b51259b8f503f000b50ea2c5a5e8eebb4361ded40fa58d93d6f3c0","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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"html`${table(data.filter(d => d.population > 200000))}`","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":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"