2a:null 2b:["$","title",null,{"children":"Plotting AARP Livability Scores | Christopher L. Keller | Observable"}] 30:T4b0,vl({ data: { values: long_data }, mark: { type: 'point', filled: true, size: 400, color: '#bac5cf' }, title: { text: 'Where the contenders rank', orient: 'top', anchor: 'start', font: 'Benton Gothic Bold', fontSize: 20, color: '#000000' }, encoding: { x: { title: 'AARP Livability Score', field: 'score', type: 'quantitative', scale: { domain: [0, 100] } }, y: { title: 'Category', field: 'category', type: 'nominal', sort: [ "Overall", "Housing", "Neighborhood", "Transportation", "Environment", "Health", "Engagement", "Opportunity" ] }, color: { condition: [ { test: "datum['city'] === 'Albuquerque'", value: "#bf0a30" }, { test: "datum['city'] === 'Huntsville'", value: "Blue" } ], legend: false } }, width: 800, height: 500, config: { axis: { labelFont: 'Benton Gothic', labelFontSize: 13, labelFontWeight: 'normal', titleFont: "Benton Gothic Bold, sans", titleFontSize: 13, titleFontWeight: "normal" } } })31:T2984,html`

category	Overall	Housing	Neighborhood	Transportation	Environment	Health	Engagement	Opportunity
Anchorage	50	46	44	48	47	56	53	58
Aurora	50	46	44	48	47	56	53	58
Brevard County	47	50	43	37	49	47	61	45
Colorado Springs	53	51	56	46	54	67	56	44
Dayton	53	64	51	51	63	42	59	44
Hillsborough County	50	57	54	43	48	47	54	46
Huntsville	55	57	47	40	67	50	54	54
Jacksonville	53	59	45	43	52	48	79	48
Miami-Dade County	52	67	68	68	56	41	32	32
Orange County	53	60	44	38	58	59	52	58
Pensacola	52	55	44	49	68	49	58	44
Pinellas County	55	62	53	48	56	55	68	45
San Antonio	50	60	50	41	48	60	40	54
Lompoc	53	55	57	64	53	65	25	49
Seminole County	54	56	49	40	56	59	55	64
St. Louis	54	72	64	72	53	48	55	15
Sterling Heights	53	44	56	52	56	49	49	68
Houston	50	67	59	47	41	56	35	47
Fort Worth	53	60	57	46	44	57	54	56
Palmdale	45	44	50	52	35	54	29	48
Tacoma	56	49	54	53	63	54	58	62
Lakewood	54	53	51	47	59	55	53	58
Everett	55	56	56	49	58	61	36	71
Spokane	54	55	54	52	57	56	52	55
Vancouver	58	54	56	55	60	60	57	64
Kent	55	50	59	45	55	71	53	54
Kansas City	52	55	57	45	46	47	64	53
St. Joseph	63	97	52	86	53	32	56	68
Albuquerque	52	53	56	54	55	63	49	37
Average	52.90	57.03	52.76	50.31	53.69	53.93	51.69	51.69
ABQ Rank	19.00	20.00	8.00	6.00	14.00	4.00	22.00	27.00

`32:T4e5,inline_csv = "category,Anchorage,Aurora,Brevard County,Colorado Springs,Dayton,Hillsborough County,Huntsville,Jacksonville,Miami-Dade County,Orange County,Pensacola,Pinellas County,San Antonio,Lompoc,Seminole County,St. Louis,Sterling Heights,Houston,Fort Worth,Palmdale,Tacoma,Lakewood,Everett,Spokane,Vancouver,Kent,Kansas City,St. Joseph,Albuquerque,Average,ABQ Rank\nOverall,50,50,47,53,53,50,55,53,52,53,52,55,50,53,54,54,53,50,53,45,56,54,55,54,58,55,52,63,52,52.90,19.00\nHousing,46,46,50,51,64,57,57,59,67,60,55,62,60,55,56,72,44,67,60,44,49,53,56,55,54,50,55,97,53,57.03,20.00\nNeighborhood,44,44,43,56,51,54,47,45,68,44,44,53,50,57,49,64,56,59,57,50,54,51,56,54,56,59,57,52,56,52.76,8.00\nTransportation,48,48,37,46,51,43,40,43,68,38,49,48,41,64,40,72,52,47,46,52,53,47,49,52,55,45,45,86,54,50.31,6.00\nEnvironment,47,47,49,54,63,48,67,52,56,58,68,56,48,53,56,53,56,41,44,35,63,59,58,57,60,55,46,53,55,53.69,14.00\nHealth,56,56,47,67,42,47,50,48,41,59,49,55,60,65,59,48,49,56,57,54,54,55,61,56,60,71,47,32,63,53.93,4.00\nEngagement,53,53,61,56,59,54,54,79,32,52,58,68,40,25,55,55,49,35,54,29,58,53,36,52,57,53,64,56,49,51.69,22.00\nOpportunity,58,58,45,44,44,46,54,48,32,58,44,45,54,49,64,15,68,47,56,48,62,58,71,55,64,54,53,68,37,51.69,27.00"33:T411,vl({ data: { values: plot_data, format: { type: 'json' } }, mark: { type: 'circle', size: 400, color: 'blue' }, title: { text: 'Where the contenders rank', orient: 'top', anchor: 'start', font: 'Benton Gothic Bold', fontSize: 20, color: '#000000' }, transform: [{ flatten: ['scores'] }], encoding: { x: { title: 'Livability Score', field: 'scores', type: 'quantitative', scale: { domain: [0, 100] } }, y: { title: 'Category', field: 'category', type: 'nominal', sort: [ "Overall", "Housing", "Neighborhood", "Transportation", "Environment", "Health", "Engagement", "Opportunity" ] } }, width: 800, height: 500, config: { axis: { labelFont: 'Benton Gothic', labelFontSize: 13, labelFontWeight: 'normal', titleFont: "Benton Gothic Bold, sans", titleFontSize: 13, titleFontWeight: "normal" } } })34:T80c,plot_data = [ { category: "Overall", scores: [ 52, 50, 50, 47, 53, 53, 50, 55, 53, 52, 53, 52, 55, 50, 53, 54, 54, 53, 50, 53 ] }, { category: "Housing", scores: [ 53, 46, 46, 50, 51, 64, 57, 57, 59, 67, 60, 55, 62, 60, 55, 56, 72, 44, 67, 60 ] }, { category: "Neighborhood", scores: [ 56, 44, 44, 43, 56, 51, 54, 47, 45, 68, 44, 44, 53, 50, 57, 49, 64, 56, 59, 57 ] }, { category: "Transportation", scores: [ 54, 48, 48, 37, 46, 51, 43, 40, 43, 68, 38, 49, 48, 41, 64, 40, 72, 52, 47, 46 ] }, { category: "Environment", scores: [ 55, 47, 47, 49, 54, 63, 48, 67, 52, 56, 58, 68, 56, 48, 53, 56, 53, 56, 41, 44 ] }, { category: "Health", scores: [ 63, 56, 56, 47, 67, 42, 47, 50, 48, 41, 59, 49, 55, 60, 65, 59, 48, 49, 56, 57 ] }, { category: "Engagement", scores: [ 49, 53, 53, 61, 56, 59, 54, 71, 79, 32, 52, 58, 68, 40, 25, 55, 55, 49, 35, 54 ] }, { category: "Opportunity", scores: [ 37, 58, 58, 45, 44, 40, 46, 54, 48, 32, 58, 44, 45, 54, 49, 64, 15, 68, 47, 56 ] } ]35:[] 2e:{"id":"a7e998924b38ef6d","slug":"plotting-aarp-livability-scores","title":"Plotting AARP Livability Scores","thumbnail":"10a542a48fcb0191313ce9399d77caa734e16ee4d1f6504efd514bea0881e9f9","access_level":"public","create_time":"$D2020-08-24T18:31:55.612Z","update_time":"$D2021-01-19T23:11:40.698Z","view_time":null,"first_public_time":"$D2020-08-25T19:25:48.220Z","fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"b1060e5bd7932c0c","login":"chrislkeller","name":"Christopher L. Keller","avatar_url":"https://avatars-next.observableusercontent.com/480c1b063ca680d305e90abbeef687017de8de8a546032d2b65d715341bd861a","tier":"starter_2024"},"version":223,"publish_version":223,"role":null,"authored":false,"authors":[{"type":"individual","id":"7e214d36195dad3a","login":"chrislkeller","name":"Christopher L. Keller","avatar_url":"https://avatars-next.observableusercontent.com/480c1b063ca680d305e90abbeef687017de8de8a546032d2b65d715341bd861a","tier":null}],"members":[{"type":"individual","id":"7e214d36195dad3a","login":"chrislkeller","name":"Christopher L. Keller","avatar_url":"https://avatars-next.observableusercontent.com/480c1b063ca680d305e90abbeef687017de8de8a546032d2b65d715341bd861a","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Plotting AARP Livability Scores","cells":[{"id":0,"value":"md`# Plotting AARP Livability Scores`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":130,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":205,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":96,"value":"// data_url = 'https://cors-anywhere.herokuapp.com/https://docs.google.com/spreadsheets/d/e/2PACX-1vQDAxYS4FQ8xI1ki5m87wwQ7ZOC3vexYrioGTlxhhGIIUiF38lCLeuynd2XfTy6H4vKj9FrlaCbi5JG/pub?gid=2092858221&single=true&output=tsv'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":99,"value":"/*data_figures = {\n let objects = [];\n const spreadsheet = await d3\n .tsv(data_url)\n .then(data => data.forEach(d => objects.push(d)));\n return objects;\n}*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":106,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":193,"value":"wide_data = await d3.csvParse(inline_csv)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":117,"value":"long_data = {\n var objects = [];\n wide_data.forEach(function(d) {\n Object.keys(d).forEach(function(colname) {\n if (colname == 'category' || colname == 'ABQ Rank') {\n return;\n }\n objects.push({\n city: colname,\n score: parseInt(d[colname]),\n category: d['category']\n });\n });\n });\n return objects;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":63,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":101,"value":"d3 = require(\"d3@5\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":7,"value":"vl = require.alias({\n \"vega\": \"vega@5.3.1\",\n \"vega-lite\": \"vega-lite@3.0.0\"\n})(\"vega-embed@4\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 2f:"$2e:body"