37:null 38:["$","title",null,{"children":"Ohio Cities | Charles Redmond | Observable"}] 3e:[{"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":1637590101698.565,"size":126884}] 3c:{"id":"61fb734cbb920bea","slug":"ohio-cities/2","title":"Ohio Cities","thumbnail":"6db9390a76e121d94b9c25dae4cc95956ac67a6e12fa39c757bc7e82af78e241","access_level":"public","create_time":"$D2021-11-22T14:05:31.749Z","update_time":"$D2021-11-29T14:21:37.612Z","view_time":null,"first_public_time":"$D2021-11-22T14:05:58.651Z","has_unpublished_edits":null,"fork":{"id":"c829d31717e70bf1","slug":"cheerio-template","title":"Cheerio Template","owner":{"id":"66151b62b45d9fca","login":"credmond","name":"Charles Redmond"}},"stars":1,"starred":false,"owner":{"type":"team","id":"66151b62b45d9fca","login":"credmond","name":"Charles Redmond","avatar_url":"https://avatars-next.observableusercontent.com/50425ed9f407a7b47d1c471a09963f335e0652ab9acc237869e2d7949fb04a77","tier":"starter_2024","bio":"","following":false},"version":168,"publish_version":168,"role":null,"authored":false,"authors":[{"type":"individual","id":"37a987477e8b6db3","login":"credmond","name":"Charles Redmond","avatar_url":"https://avatars-next.observableusercontent.com/50425ed9f407a7b47d1c471a09963f335e0652ab9acc237869e2d7949fb04a77","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"37a987477e8b6db3","login":"credmond","name":"Charles Redmond","avatar_url":"https://avatars-next.observableusercontent.com/50425ed9f407a7b47d1c471a09963f335e0652ab9acc237869e2d7949fb04a77","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":17,"collection":{"id":"ca5bcd03a6965c18","slug":"fall21-ds-b-1","title":"Fall21 DS B 1","owner":{"id":"66151b62b45d9fca","login":"credmond","name":"Charles Redmond"}},"type":"notebook","body":{"titling":"auto","title":"Ohio Cities","cells":[{"id":0,"value":"# Ohio Cities","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"page = FileAttachment(\"https _en.wikipedia.org_wiki_List_of_municipalities_in_Ohio.htm\").text()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"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":149,"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","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":"$W3e","stdlib":"1"}} 3d:"$3c:body"