41:null 42:["$","title",null,{"children":"Ohio Cities Example | Brenna Lehotsky | 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":1633962058078.703,"size":196753}] 46:{"id":"67540e8977b65d38","slug":"ohio-cities-example","title":"Ohio Cities Example","thumbnail":"c2af61e6e8aa4f09e3bd13ca891a608b70715670b9cbcfc9b44bba790bb05cfd","access_level":"public","create_time":"$D2021-10-11T14:20:58.078Z","update_time":"$D2021-10-11T14:28:37.413Z","view_time":null,"first_public_time":"$D2021-10-11T14:25:45.929Z","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":"4018f1e927b52e4d","login":"bmlehotsky","name":"Brenna Lehotsky","avatar_url":"https://avatars-next.observableusercontent.com/a1b31ff5f0def4042246bda7235970f0a72c2ba07cbfb072d8d2ac4d3cd53f1c","tier":"starter_2024","bio":"","following":false},"version":144,"publish_version":144,"role":null,"authored":false,"authors":[{"type":"individual","id":"ae19d0f0368fe6e6","login":"bmlehotsky","name":"Brenna Lehotsky","avatar_url":"https://avatars-next.observableusercontent.com/a1b31ff5f0def4042246bda7235970f0a72c2ba07cbfb072d8d2ac4d3cd53f1c","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"ae19d0f0368fe6e6","login":"bmlehotsky","name":"Brenna Lehotsky","avatar_url":"https://avatars-next.observableusercontent.com/a1b31ff5f0def4042246bda7235970f0a72c2ba07cbfb072d8d2ac4d3cd53f1c","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":138,"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":126,"value":"html`${table}`","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":"$W48","stdlib":"1"}} 47:"$46:body"