2d:null 2e:["$","title",null,{"children":"Water Consumption In New York City | Michael Fasani | Observable"}] 33:Te24,chart = { // Set the dimensions and margins of the chart const height = 520; // const width = auto; // Comes from the page const margin = { top: 20, right: 70, bottom: 70, left: 70 }; const chartWidth = width - margin.left - margin.right; const chartHeight = height - margin.top - margin.bottom; // Chart Labels const xLabel = "Average gallons of water per person, per day, per year"; const yLabel = "Population - New York City"; // Set the ranges const x = d3.scaleLinear().range([0, chartWidth]); const y = d3.scaleLinear().range([chartHeight, 0]); // Scale the range of the data x.domain([ d3.min(chartData, (d) => d.year) - 2, d3.max(chartData, (d) => d.year) + 2, ]); y.domain([ d3.min(chartData, (d) => d.population) - 150000, d3.max(chartData, (d) => d.population) + 150000, ]); // Calculate Circle Radius const r = d3 .scaleSqrt() .domain([ d3.min(chartData, (d) => d.gallonsPerPersonPerDay), d3.max(chartData, (d) => d.gallonsPerPersonPerDay), ]) .range([5, 25]); // Add an SVG const svg = d3.select(DOM.svg(width, height)); // Add a chart group const chart = svg .append("g") .attr("width", chartWidth) .attr("height", chartHeight) .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); // Add an empty ToolTip const toolTip = d3 .select("body") .append("div") .style("position", "absolute") .style("text-align", "left") .style("padding", "8px") .style("font", "12px sans-serif") .style("background", "white") .style("border", "1px solid #57b6dd") .style("border-radius", "10px") .style("pointer-events", "none") .style("margin-top", "25px") .style("margin-left", "25px") .style("font-size", "12px") .style("opacity", 0); // Draw Circles chart .selectAll(".dot") .data(chartData) .enter() .append("circle") .attr("fill", "#66d2ff") .attr("stroke", "#57b6dd") .attr("cursor", "help") .attr("opacity", "0.5") .attr("r", (d) => r(d.gallonsPerPersonPerDay)) .attr("cx", (d) => x(d.year)) .attr("cy", (d) => y(d.population)) .on("mouseover", (d) => { toolTip .html(` Year: ${d.year}
Gallons per person per day: ${d.gallonsPerPersonPerDay}

Population: ${d3.format(",.2s")(d.population)}
Total gallons per day: ${d3.format(",")(d.millionGallonsPerDay) + "M"}
`) .style("left", d3.event.pageX + "px") .style("top", d3.event.pageY + "px") .style("opacity", 1); }) .on("mousemove", function(d) { toolTip .style("left", d3.event.pageX + "px") .style("top", d3.event.pageY + "px"); }) .on("mouseout", function(d) { toolTip.style("opacity", 0); }); // Add the X Axis chart .append("g") .attr("transform", "translate(0," + chartHeight + ")") .call(d3.axisBottom(x).tickFormat(d3.format("y"))); chart .append("text") .attr("text-anchor", "end") .attr("x", chartWidth - 2) .attr("y", chartHeight - 6) .attr("font-family", "Arial") .attr("font-size", "12px") .text(xLabel); // Add the Y Axis chart.append("g").call(d3.axisLeft(y)); chart .append("text") .attr("text-anchor", "end") .attr("y", 6) .attr("dy", ".75em") .attr("transform", "rotate(-90)") .attr("font-family", "Arial") .attr("font-size", "12px") .text(yLabel); return svg.node(); }34:T4412,data = [{ "meta": { "view": { "id": "ia2d-e54m", "name": "Water Consumption In The New York City", "attribution": "Department of Environmental Protection (DEP)", "attributionLink": "http://www.nyc.gov/html/dep/html/drinking_water/droughthist.shtml", "averageRating": 0, "category": "Environment", "createdAt": 1359591698, "description": "A brief history of water consumption in the New York City Water Supply System (Based on New York City Census population)", "displayType": "table", "downloadCount": 13337, "hideFromCatalog": false, "hideFromDataJson": false, "indexUpdatedAt": 1558119950, "newBackend": true, "numberOfComments": 0, "oid": 31517800, "provenance": "official", "publicationAppendEnabled": false, "publicationDate": 1558119963, "publicationGroup": 647012, "publicationStage": "published", "rowsUpdatedAt": 1558119953, "rowsUpdatedBy": "5fuc-pqz2", "tableId": 16204426, "totalTimesRated": 0, "viewCount": 46672, "viewLastModified": 1581123338, "viewType": "tabular", "approvals": [{ "reviewedAt": 1558119963, "reviewedAutomatically": true, "state": "approved", "submissionId": 1079176, "submissionObject": "public_audience_request", "submissionOutcome": "change_audience", "submittedAt": 1558119963, "workflowId": 2285, "submissionDetails": { "permissionType": "READ" }, "submissionOutcomeApplication": { "failureCount": 0, "status": "success" }, "submitter": { "id": "5fuc-pqz2", "displayName": "NYC OpenData" } }], "columns": [{ "id": -1, "name": "sid", "dataTypeName": "meta_data", "fieldName": ":sid", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": -1, "name": "id", "dataTypeName": "meta_data", "fieldName": ":id", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": -1, "name": "position", "dataTypeName": "meta_data", "fieldName": ":position", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": -1, "name": "created_at", "dataTypeName": "meta_data", "fieldName": ":created_at", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": -1, "name": "created_meta", "dataTypeName": "meta_data", "fieldName": ":created_meta", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": -1, "name": "updated_at", "dataTypeName": "meta_data", "fieldName": ":updated_at", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": -1, "name": "updated_meta", "dataTypeName": "meta_data", "fieldName": ":updated_meta", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": -1, "name": "meta", "dataTypeName": "meta_data", "fieldName": ":meta", "position": 0, "renderTypeName": "meta_data", "format": {}, "flags": ["hidden"] }, { "id": 409045693, "name": "Year", "dataTypeName": "text", "description": "", "fieldName": "year", "position": 1, "renderTypeName": "text", "tableColumnId": 81070439, "width": 68, "cachedContents": { "largest": "2018", "non_null": "40", "null": "0", "top": [{ "item": "1986", "count": "1" }, { "item": "1991", "count": "1" }, { "item": "1982", "count": "1" }, { "item": "2006", "count": "1" }, { "item": "2000", "count": "1" }, { "item": "2002", "count": "1" }, { "item": "1985", "count": "1" }, { "item": "2003", "count": "1" }, { "item": "2014", "count": "1" }, { "item": "1997", "count": "1" }, { "item": "1992", "count": "1" }, { "item": "2009", "count": "1" }, { "item": "1990", "count": "1" }, { "item": "1994", "count": "1" }, { "item": "1983", "count": "1" }, { "item": "1989", "count": "1" }, { "item": "2011", "count": "1" }, { "item": "1979", "count": "1" }, { "item": "2004", "count": "1" }, { "item": "2007", "count": "1" }], "smallest": "1979", "cardinality": "40" }, "format": { "precisionStyle": "standard", "noCommas": "true", "align": "center" } }, { "id": 409045690, "name": "New York City Population", "dataTypeName": "number", "description": "", "fieldName": "new_york_city_population", "position": 2, "renderTypeName": "number", "tableColumnId": 48016568, "width": 240, "cachedContents": { "largest": "8475976", "non_null": "40", "null": "0", "top": [{ "item": "7344175", "count": "1" }, { "item": "7274054", "count": "1" }, { "item": "8108391", "count": "1" }, { "item": "8475976", "count": "1" }, { "item": "7089241", "count": "1" }, { "item": "7102100", "count": "1" }, { "item": "7181224", "count": "1" }, { "item": "7234514", "count": "1" }, { "item": "8437387", "count": "1" }, { "item": "8398739", "count": "1" }, { "item": "8348032", "count": "1" }, { "item": "7335650", "count": "1" }, { "item": "8272963", "count": "1" }, { "item": "8024963.50", "count": "1" }, { "item": "8041649", "count": "1" }, { "item": "8438271", "count": "1" }, { "item": "7697812", "count": "1" }, { "item": "7342476", "count": "1" }, { "item": "7633040", "count": "1" }, { "item": "7773443", "count": "1" }], "smallest": "7071639", "cardinality": "40" }, "format": {} }, { "id": 409045691, "name": "NYC Consumption(Million gallons per day)", "dataTypeName": "number", "fieldName": "nyc_consumption_million_gallons_per_day", "position": 3, "renderTypeName": "number", "tableColumnId": 7413124, "width": 285, "cachedContents": { "largest": "1512", "non_null": "40", "null": "0", "top": [{ "item": "1007.50", "count": "2" }, { "item": "1424", "count": "2" }, { "item": "1009", "count": "1" }, { "item": "1369", "count": "1" }, { "item": "1469", "count": "1" }, { "item": "1382", "count": "1" }, { "item": "1351", "count": "1" }, { "item": "1309", "count": "1" }, { "item": "996", "count": "1" }, { "item": "1135.60", "count": "1" }, { "item": "1368.50", "count": "1" }, { "item": "1002", "count": "1" }, { "item": "1297.90", "count": "1" }, { "item": "1093.70", "count": "1" }, { "item": "1138", "count": "1" }, { "item": "1357.70", "count": "1" }, { "item": "1006.10", "count": "1" }, { "item": "1512", "count": "1" }, { "item": "1465", "count": "1" }, { "item": "1069", "count": "1" }], "smallest": "990.2", "cardinality": "38" }, "format": { "precisionStyle": "standard", "noCommas": "false", "align": "center" } }, { "id": 409045692, "name": "Per Capita(Gallons per person per day)", "dataTypeName": "number", "fieldName": "per_capita_gallons_per_person_per_day", "position": 4, "renderTypeName": "number", "tableColumnId": 7413125, "width": 263, "cachedContents": { "largest": "213", "non_null": "40", "null": "0", "top": [{ "item": "155", "count": "3" }, { "item": "120", "count": "2" }, { "item": "182", "count": "2" }, { "item": "194", "count": "2" }, { "item": "136", "count": "2" }, { "item": "141", "count": "2" }, { "item": "123", "count": "2" }, { "item": "118", "count": "2" }, { "item": "213", "count": "2" }, { "item": "185", "count": "2" }, { "item": "117", "count": "1" }, { "item": "202", "count": "1" }, { "item": "156", "count": "1" }, { "item": "121", "count": "1" }, { "item": "127", "count": "1" }, { "item": "184", "count": "1" }, { "item": "203", "count": "1" }, { "item": "148", "count": "1" }, { "item": "198", "count": "1" }, { "item": "169", "count": "1" }], "smallest": "117", "cardinality": "29" }, "format": { "precisionStyle": "standard", "noCommas": "false", "align": "center" } }], "grants": [{ "inherited": false, "type": "viewer", "flags": ["public"] }], "metadata": { "rdfSubject": "0", "attachments": [{ "filename": "DEP_Data_Dictionary_-_Water_Consumption_in_the_City_of_New_York.xlsx", "assetId": "c4daebf5-6eed-4863-8fbb-a9fb1f2aca0f", "name": "DEP_Data_Dictionary_-_Water_Consumption_in_the_City_of_New_York.xlsx" }], "custom_fields": { "Update": { "Automation": "No", "Date Made Public": "10/17/2017", "Update Frequency": "Annually" }, "Legislative Compliance": { "Geo-coding Attached?": "" }, "Dataset Information": { "Agency": "Department of Environmental Protection (DEP)" } }, "rowLabel": "Water Consumption by Year ", "availableDisplayTypes": ["table", "fatrow", "page"], "renderTypeConfig": { "visible": { "table": true } } }, "owner": { "id": "5fuc-pqz2", "displayName": "NYC OpenData", "profileImageUrlLarge": "/api/users/5fuc-pqz2/profile_images/LARGE", "profileImageUrlMedium": "/api/users/5fuc-pqz2/profile_images/THUMB", "profileImageUrlSmall": "/api/users/5fuc-pqz2/profile_images/TINY", "screenName": "NYC OpenData", "type": "interactive", "userSegment": "site_member", "flags": ["acceptedEula", "mayBeStoriesCoOwner"] }, "query": {}, "rights": ["read"], "tableAuthor": { "id": "5fuc-pqz2", "displayName": "NYC OpenData", "profileImageUrlLarge": "/api/users/5fuc-pqz2/profile_images/LARGE", "profileImageUrlMedium": "/api/users/5fuc-pqz2/profile_images/THUMB", "profileImageUrlSmall": "/api/users/5fuc-pqz2/profile_images/TINY", "screenName": "NYC OpenData", "type": "interactive", "userSegment": "site_member", "flags": ["acceptedEula", "mayBeStoriesCoOwner"] }, "tags": ["dep", "department of environmental protection", "environment", "water", "consumption", "water consumption", "water consumption in the new york city", "healthy living"], "flags": ["default", "restorable", "restorePossibleForType"] } }, "data": [ ["row-vfmc_c6w6-d7kw", "00000000-0000-0000-309B-72920F61CD23", 0, 1558119953, null, 1558119953, null, "{ }", "1979", "7102100", "1512", "213"], ["row-drbm-sbh8.smtf", "00000000-0000-0000-CCE9-B2C554DE2120", 0, 1558119953, null, 1558119953, null, "{ }", "1980", "7071639", "1506", "213"], ["row-v2hk.r4q4_mf7d", "00000000-0000-0000-16D0-B3FC7E7EF91F", 0, 1558119953, null, 1558119953, null, "{ }", "1981", "7089241", "1309", "185"], ["row-adpb_4iew.gz7g", "00000000-0000-0000-DBB0-7810C982F02E", 0, 1558119953, null, 1558119953, null, "{ }", "1982", "7109105", "1382", "194"], ["row-jjxn_gj8n.z4cq", "00000000-0000-0000-6921-782C5F27A1D3", 0, 1558119953, null, 1558119953, null, "{ }", "1983", "7181224", "1424", "198"], ["row-59n9.icaa-p3nx", "00000000-0000-0000-B855-3E4CFBA3CB24", 0, 1558119953, null, 1558119953, null, "{ }", "1984", "7234514", "1465", "203"], ["row-pkkv.f3bt~x6fw", "00000000-0000-0000-DE51-08FC02C0A769", 0, 1558119953, null, 1558119953, null, "{ }", "1985", "7274054", "1326", "182"], ["row-muep-ycgv.u2vk", "00000000-0000-0000-6332-460482D9A281", 0, 1558119953, null, 1558119953, null, "{ }", "1986", "7319246", "1351", "185"], ["row-5t8z.hyfr_ucqa", "00000000-0000-0000-DF58-FD1BB078F9EF", 0, 1558119953, null, 1558119953, null, "{ }", "1987", "7342476", "1447", "197"], ["row-p9s7_sey3-z3s3", "00000000-0000-0000-A8A0-0801D87C54AD", 0, 1558119953, null, 1558119953, null, "{ }", "1988", "7353719", "1484", "202"], ["row-dmwr~yyy2_sjk9", "00000000-0000-0000-8E94-27D0CF80E0FE", 0, 1558119953, null, 1558119953, null, "{ }", "1989", "7344175", "1402", "191"], ["row-2cab_pxta~chpe", "00000000-0000-0000-4227-01BF582AF636", 0, 1558119953, null, 1558119953, null, "{ }", "1990", "7335650", "1424", "194"], ["row-6n3b~r9cc~pbme", "00000000-0000-0000-5863-FBB43A86FE98", 0, 1558119953, null, 1558119953, null, "{ }", "1991", "7374501", "1469", "199"], ["row-rcan_tcrh~qtuq", "00000000-0000-0000-D483-59F388AC126C", 0, 1558119953, null, 1558119953, null, "{ }", "1992", "7428944", "1369", "184"], ["row-4sev_tvsz.b4d6", "00000000-0000-0000-14D5-DA855C3E821E", 0, 1558119953, null, 1558119953, null, "{ }", "1993", "7506166", "1368.50", "182"], ["row-22tm-jsqp-zt8z", "00000000-0000-0000-A59A-69A0F8B56166", 0, 1558119953, null, 1558119953, null, "{ }", "1994", "7570458", "1357.70", "179"], ["row-s9tf~a9vt_yi95", "00000000-0000-0000-2C06-9DC38E790446", 0, 1558119953, null, 1558119953, null, "{ }", "1995", "7633040", "1325.70", "174"], ["row-yrfs_vg8k.uvu8", "00000000-0000-0000-9129-A27E9534CCE0", 0, 1558119953, null, 1558119953, null, "{ }", "1996", "7697812", "1297.90", "169"], ["row-t5gt_mrkh_55c9", "00000000-0000-0000-1203-9A8CCC5C485B", 0, 1558119953, null, 1558119953, null, "{ }", "1997", "7773443", "1205.50", "155"], ["row-2fky_vd6m.p5pm", "00000000-0000-0000-8075-356FDA489F82", 0, 1558119953, null, 1558119953, null, "{ }", "1998", "7858259", "1219.50", "155"], ["row-nzkr.9t48~u87t", "00000000-0000-0000-CC5C-E68039076B4A", 0, 1558119953, null, 1558119953, null, "{ }", "1999", "7947660", "1237.20", "156"], ["row-kzrp-nes4~79fx", "00000000-0000-0000-9AFA-3D04BA1606CA", 0, 1558119953, null, 1558119953, null, "{ }", "2000", "8008278", "1240.40", "155"], ["row-yang-g6vc-yh4s", "00000000-0000-0000-54E1-0776821015D0", 0, 1558119953, null, 1558119953, null, "{ }", "2001", "8024963.50", "1184", "148"], ["row-kww6.7ygk_vbsa", "00000000-0000-0000-24AE-DF17DBFC14B9", 0, 1558119953, null, 1558119953, null, "{ }", "2002", "8041649", "1135.60", "141"], ["row-5gzg.fsy2~m79c", "00000000-0000-0000-5593-86C2D9743057", 0, 1558119953, null, 1558119953, null, "{ }", "2003", "8058334.50", "1093.70", "136"], ["row-5x22.w2z5~d462", "00000000-0000-0000-0CE3-9FC0B79930F8", 0, 1558119953, null, 1558119953, null, "{ }", "2004", "8075020", "1099.50", "136"], ["row-g6a3.y5v5_ng82", "00000000-0000-0000-FF00-FE718FCDCD1C", 0, 1558119953, null, 1558119953, null, "{ }", "2005", "8091705.50", "1138", "141"], ["row-v3ev.ye2n~zxey", "00000000-0000-0000-6007-2A1A1BA0FE65", 0, 1558119953, null, 1558119953, null, "{ }", "2006", "8108391", "1069", "132"], ["row-7tex-h97n~bt8t", "00000000-0000-0000-D90C-A10ABC715ED6", 0, 1558119953, null, 1558119953, null, "{ }", "2007", "8125076.50", "1114", "137"], ["row-durp.z2vh_86yi", "00000000-0000-0000-49CF-CC0573D9CAB0", 0, 1558119953, null, 1558119953, null, "{ }", "2008", "8141762", "1098", "135"], ["row-dtvq_7wvw_x5es", "00000000-0000-0000-17ED-BDF5322BCA75", 0, 1558119953, null, 1558119953, null, "{ }", "2009", "8158447.50", "1007.50", "123"], ["row-r8ye.b3rj_8z8b", "00000000-0000-0000-44E5-A5B1A30C2706", 0, 1558119953, null, 1558119953, null, "{ }", "2010", "8175133", "1039", "127"], ["row-z9ki_qa39_umx4", "00000000-0000-0000-8240-8D845EC1C80A", 0, 1558119953, null, 1558119953, null, "{ }", "2011", "8272963", "1021", "123"], ["row-6ueb~m3n2.7e89", "00000000-0000-0000-211C-0B29396DC8C5", 0, 1558119953, null, 1558119953, null, "{ }", "2012", "8348032", "1009.10", "121"], ["row-sdv4-aisr_qjig", "00000000-0000-0000-109B-F22A4B1B10C0", 0, 1558119953, null, 1558119953, null, "{ }", "2013", "8398739", "1006.10", "120"], ["row-zuqw-shh4-xmqd", "00000000-0000-0000-EF4C-B97BA9A1E8A3", 0, 1558119953, null, 1558119953, null, "{ }", "2014", "8437387", "996", "118"], ["row-wnaz_475w~4swe", "00000000-0000-0000-677D-9EF46DF1528B", 0, 1558119953, null, 1558119953, null, "{ }", "2015", "8468181", "1009", "119"], ["row-5sq8~2yj7~6dra", "00000000-0000-0000-C196-F998A83CFF81", 0, 1558119953, null, 1558119953, null, "{ }", "2016", "8475976", "1002", "118"], ["row-2ck7_mgjh.spus", "00000000-0000-0000-A941-7FC508029717", 0, 1558119953, null, 1558119953, null, "{ }", "2017", "8438271", "990.2", "117"], ["row-wdew_efqt.rce7", "00000000-0000-0000-3FF7-5EB3175B4607", 0, 1558119953, null, 1558119953, null, "{ }", "2018", "8398748", "1007.50", "120"] ] }]35:[] 31:{"id":"2a8c676e4c284a2c","slug":"water-consumption-in-new-york-city","title":"Water Consumption In New York City","thumbnail":"2d5cf67dbbcb582d16e433acac1a79b54f8b5b0a439a09a6f61bbd7f65ed8867","access_level":"public","create_time":"$D2020-02-18T07:52:15.318Z","update_time":"$D2020-02-19T18:25:33.596Z","view_time":null,"first_public_time":"$D2020-02-19T09:06:13.005Z","has_unpublished_edits":null,"fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"6a949d2df2fe1e03","login":"fasani","name":"Michael Fasani","avatar_url":"https://avatars-next.observableusercontent.com/c0f23baf0ebc3d7464d5e4bccfd30a20fb923dfa0793e18cbc01194f84c573e6","tier":"starter_2024","bio":"I have been working as a \"webmaster\" since 1999. Mostly I write JavaScript. I currently like React, Redux, ApolloClient, WebVR, D3, Three.js."},"version":183,"publish_version":183,"role":null,"authored":false,"authors":[{"type":"individual","id":"2ff10d2d472b94ec","login":"fasani","name":"Michael Fasani","avatar_url":"https://avatars-next.observableusercontent.com/c0f23baf0ebc3d7464d5e4bccfd30a20fb923dfa0793e18cbc01194f84c573e6","tier":null,"bio":"I have been working as a \"webmaster\" since 1999. Mostly I write JavaScript. I currently like React, Redux, ApolloClient, WebVR, D3, Three.js."}],"members":[{"type":"individual","id":"2ff10d2d472b94ec","login":"fasani","name":"Michael Fasani","avatar_url":"https://avatars-next.observableusercontent.com/c0f23baf0ebc3d7464d5e4bccfd30a20fb923dfa0793e18cbc01194f84c573e6","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Water Consumption In New York City","cells":[{"id":0,"value":"md`# Water Consumption In New York City`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"md`A brief history of water consumption in the New York City Water Supply System (Based on New York City Census population).`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"md`## Refrence Data\n[Water Consumption In The New York City - cityofnewyork.us](https://data.cityofnewyork.us/Environment/Water-Consumption-In-The-New-York-City/ia2d-e54m)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"md `## Data and imports used for visualisation`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"chartData = function() {\n let dataObject = [];\n\n data[0].data.forEach(function(dataSet) {\n let newDataSet = {};\n\n newDataSet.year = parseInt(dataSet[8]);\n newDataSet.population = parseInt(dataSet[9]);\n newDataSet.millionGallonsPerDay = parseInt(dataSet[10]);\n newDataSet.gallonsPerPersonPerDay = parseInt(dataSet[11]);\n\n dataObject.push(newDataSet);\n });\n \n return dataObject;\n}();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"https://d3js.org/d3.v5.js\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1"}} 32:"$31:body"