25:["$","title",null,{"children":"Florida rankings | Andrew Witherspoon | Observable"}] 49:[{"id":"1c136a88091d6dd43d1c5966e38ceee96d578003361fbd220622ed8803fdca22d81c901ad143986f0f26394afdfab51d45ea1b6762370dc57e8991992a06f95c","href":"https://static.observableusercontent.com/files/1c136a88091d6dd43d1c5966e38ceee96d578003361fbd220622ed8803fdca22d81c901ad143986f0f26394afdfab51d45ea1b6762370dc57e8991992a06f95c","name":"ACSST1Y2021.S1901-2023-03-29T143609.csv","type":"text/csv","lastModified":1680100652777.447,"size":86715},{"id":"feedd09449579f054a9ad2afa5f1ab82402954ac611613a1f31677145f3e2055797c607fe8d097c4f638067165bab851658224ed29176e434f701b560b5df3a7","href":"https://static.observableusercontent.com/files/feedd09449579f054a9ad2afa5f1ab82402954ac611613a1f31677145f3e2055797c607fe8d097c4f638067165bab851658224ed29176e434f701b560b5df3a7","name":"ACSST1Y2021.S1901-2023-03-29T143543.csv","type":"text/csv","lastModified":1680100926477.035,"size":71680},{"id":"57fd7eedc908a9f80f48775f5ca4988539982b2aa3a4159f3c7f1a3cbd733dd95aac380bb7519f7083daa798be862ecc3faa769915872694e5f6c92c33ad09cb","href":"https://static.observableusercontent.com/files/57fd7eedc908a9f80f48775f5ca4988539982b2aa3a4159f3c7f1a3cbd733dd95aac380bb7519f7083daa798be862ecc3faa769915872694e5f6c92c33ad09cb","name":"ACSST1Y2021.S1501-2023-03-29T144056.csv","type":"text/csv","lastModified":1680100937716.18,"size":364334},{"id":"2fdcd1520731ff276bda37dfff94698ea90085fd382a2057a9d5a4a85dec72f497b34be3543df032e9f9c118a7aaed31ca09bff96f1452772de9c5e95029aa08","href":"https://static.observableusercontent.com/files/2fdcd1520731ff276bda37dfff94698ea90085fd382a2057a9d5a4a85dec72f497b34be3543df032e9f9c118a7aaed31ca09bff96f1452772de9c5e95029aa08","name":"ACSDP1Y2021.DP03-2023-03-29T144758.csv","type":"text/csv","lastModified":1680101326335.412,"size":262125}] 29:{"id":"40d86fefd0c1ca9c","slug":null,"title":"Florida rankings","thumbnail":"e0195040483913a6c974aa598cc10a450635b5f9af5a6cd33796bd7013a02103","access_level":"public","create_time":"$D2023-03-29T14:08:18.084Z","update_time":"$D2025-01-22T15:50:19.866Z","view_time":null,"first_public_time":"$D2023-03-29T14:08:18.084Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"e9d0700f86f0bd9d","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":335,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"60290e9aa8cc207b","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"60290e9aa8cc207b","login":"andrewwitherspoon","name":"Andrew Witherspoon","avatar_url":"https://avatars-next.observableusercontent.com/8f490800810ce3ba1c52e327affe1547bdbad849dc781226bd105e2555362cd2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Florida rankings","cells":[{"id":0,"value":"# Florida rankings\nA series of metrics to put Florida's quality of life in context of the other 50 US states","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"## Median income\n[From Census](https://data.census.gov/table?q=median+household+income&g=010XX00US$0400000&tid=ACSST1Y2021.S1901&tp=true)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":88,"value":"Florida ranked ${incomeByStates.sort((a,b) => b.income - a.income).map(d=> d.state).indexOf(\"Florida\")+1}th in median household income in 2021 ($${formatNumber(incomeByStates.find(f=> f.state == \"Florida\").income)})","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":60,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.tickX(incomeByStates, {x:\"income\", \"strokeWidth\": d => d.state == \"Florida\" ? \"3px\" : \"1px\", \"stroke\": d => d.state == \"Florida\" ? \"red\" : \"rgba(0,0,0,0.25)\",})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"acsst1y2021S190120230329t143543 = incomeByStates","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"acsst1y2021S190120230329t143543","database":"$undefined"},{"id":19,"value":"incomeData = FileAttachment(\"ACSST1Y2021.S1901-2023-03-29T143543.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"incomeByStates = Object.entries(incomeData[11]).filter(f=> f[0].includes(\"!!Households!!Estimate\")).map(d=> {\n return {\n state: d[0].split(\"!\")[0],\n income: parseInt(d[1].replace(/,/g, ''))\n }\n}).filter(f=> f.state != \"Puerto Rico\" && f.state != \"District of Columbia\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"## Educational attainment\n[From Census](https://data.census.gov/table?q=education&g=010XX00US$0400000&tid=ACSST1Y2021.S1501&tp=false)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":145,"value":"Florida ranked ${educationByStates.sort((a,b) => b.share - a.share).map(d=> d.state).indexOf(\"Florida\")+1}th in share of population 25-34 years old with a Bachelor's degree or higher 2021 (${educationByStates.find(f=> f.state == \"Florida\").share}%)","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":142,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.tickX(educationByStates, {x:\"share\", \"strokeWidth\": d => d.state == \"Florida\" ? \"3px\" : \"1px\", \"stroke\": d => d.state == \"Florida\" ? \"red\" : \"rgba(0,0,0,0.25)\",})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"acsst1y2021S150120230329t144056 = educationByStates","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"acsst1y2021S150120230329t144056","database":"$undefined"},{"id":133,"value":"educationData = FileAttachment(\"ACSST1Y2021.S1501-2023-03-29T144056.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":135,"value":"educationByStates = Object.entries(educationData[18]).filter(f=> f[0].includes(\"!!Percent!!Estimate\")).map(d=> {\n return {\n state: d[0].split(\"!\")[0],\n share: parseFloat(d[1].split(\"%\")[0])\n }\n}).filter(f=> f.state != \"Puerto Rico\" && f.state != \"District of Columbia\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":183,"value":"## Health insurance\n[From Census](https://data.census.gov/table?q=employment&g=010XX00US$0400000&tid=ACSDP1Y2021.DP03)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":205,"value":"Florida ranked ${insuranceByStates.sort((a,b) => b.share - a.share).map(d=> d.state).indexOf(\"Florida\")+1}th in share of civilian population who had health insurance in 2021 (${insuranceByStates.find(f=> f.state == \"Florida\").share}%)","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":201,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.tickX(insuranceByStates.sort((a,b)=> a.share - b.share), {x:\"share\", \"strokeWidth\": d => d.state == \"Florida\" ? \"3px\" : \"1px\", \"stroke\": d => d.state == \"Florida\" ? \"red\" : \"rgba(0,0,0,0.15)\",})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"acsdp1y2021Dp0320230329t144758 = insuranceByStates","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"acsdp1y2021Dp0320230329t144758","database":"$undefined"},{"id":194,"value":"insuranceByStates = Object.entries(demoData[102]).filter(f=> f[0].split(\"!!\")[1] == \"Percent\").map(d=> {\n return {\n state: d[0].split(\"!\")[0],\n share: parseFloat(d[1].split(\"%\")[0])\n }\n}).filter(f=> f.state != \"Puerto Rico\" && f.state != \"District of Columbia\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":14,"value":"## Employment\n[From Census](https://data.census.gov/table?q=employment&g=010XX00US$0400000&tid=ACSDP1Y2021.DP03)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":178,"value":"Florida ranked ${employmentByStates.sort((a,b) => a.share - b.share).map(d=> d.state).indexOf(\"Florida\")+1}nd in share of civilian population 16+ years old who are unemployed in 2021 (${employmentByStates.find(f=> f.state == \"Florida\").share}%)","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":169,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.tickX(employmentByStates.sort((a,b)=> a.share - b.share), {x:\"share\", \"strokeWidth\": d => d.state == \"Florida\" ? \"3px\" : \"1px\", \"stroke\": d => d.state == \"Florida\" ? \"red\" : \"rgba(0,0,0,0.25)\",})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":190,"value":"acsdp1y2021Dp0320230329t = employmentByStates","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"acsdp1y2021Dp0320230329t","database":"$undefined"},{"id":159,"value":"demoData = FileAttachment(\"ACSDP1Y2021.DP03-2023-03-29T144758.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"employmentByStates = Object.entries(demoData[5]).filter(f=> f[0].split(\"!!\")[1] == \"Percent\").map(d=> {\n return {\n state: d[0].split(\"!\")[0],\n share: parseFloat(d[1].split(\"%\")[0])\n }\n}).filter(f=> f.state != \"Puerto Rico\" && f.state != \"District of Columbia\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":241,"value":"## Poverty level\n[From Census](https://data.census.gov/table?q=employment&g=010XX00US$0400000&tid=ACSDP1Y2021.DP03)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":254,"value":"Florida ranked ${povertyByStates.sort((a,b) => a.share - b.share).map(d=> d.state).indexOf(\"Florida\")+1}th in share of families who's income in the past year was below the poverty level in 2021 (${povertyByStates.find(f=> f.state == \"Florida\").share}%)","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":248,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.tickX(povertyByStates.sort((a,b)=> a.share - b.share), {x:\"share\", \"strokeWidth\": d => d.state == \"Florida\" ? \"3px\" : \"1px\", \"stroke\": d => d.state == \"Florida\" ? \"red\" : \"rgba(0,0,0,0.15)\",})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"povertyByStates","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":244,"value":"povertyByStates = Object.entries(demoData[126]).filter(f=> f[0].split(\"!!\")[1] == \"Percent\").map(d=> {\n return {\n state: d[0].split(\"!\")[0],\n share: parseFloat(d[1].split(\"%\")[0])\n }\n}).filter(f=> f.state != \"Puerto Rico\" && f.state != \"District of Columbia\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":218,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":220,"value":"## Snap benefits\n[From Census](https://data.census.gov/table?q=employment&g=010XX00US$0400000&tid=ACSDP1Y2021.DP03)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"Florida has the ${snapByStates.sort((a,b) => b.share - a.share).map(d=> d.state).indexOf(\"Florida\")+1}th ranked share of population who received SNAP benefits in 2021, ${snapByStates.find(f=> f.state == \"Florida\").share}% ","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":227,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.tickX(snapByStates.sort((a,b)=> a.share - b.share), {x:\"share\", \"strokeWidth\": d => d.state == \"Florida\" ? \"3px\" : \"1px\", \"stroke\": d => d.state == \"Florida\" ? \"red\" : \"rgba(0,0,0,0.15)\",})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":233,"value":"snapByStates","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":224,"value":"snapByStates = Object.entries(demoData[79]).filter(f=> f[0].split(\"!!\")[1] == \"Percent\").map(d=> {\n return {\n state: d[0].split(\"!\")[0],\n share: parseFloat(d[1].split(\"%\")[0])\n }\n}).filter(f=> f.state != \"Puerto Rico\" && f.state != \"District of Columbia\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":266,"value":"## Social Security benefits\n[From Census](https://data.census.gov/table?q=employment&g=010XX00US$0400000&tid=ACSDP1Y2021.DP03)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":272,"value":"Florida has the ${socialSecurityByStates.sort((a,b) => b.income - a.income).map(d=> d.state).indexOf(\"Florida\")+1}th ranked median social security income in 2021, $${formatNumber(socialSecurityByStates.find(f=> f.state == \"Florida\").income)}","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":268,"value":"Plot.plot({\n grid: true,\n marks: [\n Plot.tickX(socialSecurityByStates.sort((a,b)=> a.income - b.income), {x:\"income\", \"strokeWidth\": d => d.state == \"Florida\" ? \"3px\" : \"1px\", \"stroke\": d => d.state == \"Florida\" ? \"red\" : \"rgba(0,0,0,0.15)\",})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"socialSecurityByStates","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":261,"value":"socialSecurityByStates = Object.entries(demoData[72]).filter(f=> f[0].split(\"!!\")[1] == \"Estimate\").map(d=> {\n return {\n state: d[0].split(\"!\")[0],\n income: parseInt(d[1].replace(/,/g, ''))\n }\n}).filter(f=> f.state != \"Puerto Rico\" && f.state != \"District of Columbia\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":257,"value":"