28:null 29:["$","title",null,{"children":"Fire Incidents in the City of Pittsburgh | Andrea Wan | Observable"}] 2e:T93d,vis2 = VegaLite({ data: {values: newJoined}, vconcat: [ //heatmap { data: {values: newJoined}, layer: [{ mark: {type: "rect"}, // The tooltip shows the data as a pop-up selection: { pts: {type: "multi", on:"click", encodings:["x", "y"]} // "mouseover" will allow for hovering; "click" is just a click }, encoding: { y: {field: "year", type: "nominal", title: "Year"}, // y axis x: {field: "neighborhood", type: "nominal", title: "Type"}, // x axis tooltip:[ {field: "year", type: "nominal"}, {field: "totalIncidentsperneigh", type: "quantitative", title: "Total Incidents Per Neighborhood"}, {field: "neighborhood", type: "nominal", title: "Neighborhood"} ], color: { condition: { selection: "pts", // if cell is clicked, it is in "pts" and will be coloured field: "totalIncidentsperneigh", type: "quantitative", scale: {scheme: "blueorange"}, legend: {orient: 'top'} }, // condition value: "gray" // everything else is gray } //color }, //encoding width: 800 }] // layer,layer }, //------------------------------------------------------------------------ //scatterplot { layer: [{ transform: [ {filter: {selection: "pts"}}], mark: {type:"square", filled:true}, selection: {brush: {type: "interval"}}, encoding: { x: {field: "totalIncidentsPerType", type: "quantitative", scale: "linear", "domain": [0, 27], title:'Total Incidents Per Neighborhood'}, // y axis y: {field: "type_description", type: "nominal", title: "Type"}, // x axis tooltip: [ {field: "neighborhood", type: "nominal", title: "Neigborhood"}, {field: "type_description", type: "nominal", title: "Type Description"}, {field: "totalIncidentsPerType", type: "quantitative", title: "Total Incidents Per Type"}, {field: "year", type: "nominal"} ] }, width: 800, height: 800 }] }] //hconcat, vegalite //------------------------------------------------------------------------ }) //vegalite2f:[{"id":"655a2604ace0ae829d7ce08db8471e9bbd4474be65205095b92e8da5dce184b98086512c1a965a06384aaf7e7d60b071d4dc1600bc31c95aae18b4f56b7db354","href":"https://static.observableusercontent.com/files/655a2604ace0ae829d7ce08db8471e9bbd4474be65205095b92e8da5dce184b98086512c1a965a06384aaf7e7d60b071d4dc1600bc31c95aae18b4f56b7db354","name":"cleanFires.csv","type":"text/csv","lastModified":1637888421889.272,"size":1563816},{"id":"3a1763080d6d3f511f903204adb3dc30d5516951318de2a45b058d16ffd852a740d0773289ee458e06e48edbcdb40efa840f11f2545be7866d43bdee4428a692","href":"https://static.observableusercontent.com/files/3a1763080d6d3f511f903204adb3dc30d5516951318de2a45b058d16ffd852a740d0773289ee458e06e48edbcdb40efa840f11f2545be7866d43bdee4428a692","name":"joinedTable@9.csv","type":"text/csv","lastModified":1637979567542.26,"size":1417871},{"id":"d292dd0b1e16440c216bb4178825c003428fb96d9721b8556a79310746a13ea62aec93de4cebfcb1d1022aae675972a2d6722df0bae0bc66a1daef14faf9bca0","href":"https://static.observableusercontent.com/files/d292dd0b1e16440c216bb4178825c003428fb96d9721b8556a79310746a13ea62aec93de4cebfcb1d1022aae675972a2d6722df0bae0bc66a1daef14faf9bca0","name":"NEWjoinedTable@1.csv","type":"text/csv","lastModified":1637979035970.948,"size":1436757},{"id":"2610c71a3a2ecdf5e4eb1e1e8fec7a2c3ba0003185dd6aa44b89d8a99b043f720a910fbc9de412c2415ab75bc9b673fb578d1e172f46755f9ce54747d3b6f26b","href":"https://static.observableusercontent.com/files/2610c71a3a2ecdf5e4eb1e1e8fec7a2c3ba0003185dd6aa44b89d8a99b043f720a910fbc9de412c2415ab75bc9b673fb578d1e172f46755f9ce54747d3b6f26b","name":"neighborhoods@1.topojson","type":"application/octet-stream","lastModified":1637984011257.846,"size":305380},{"id":"3a1763080d6d3f511f903204adb3dc30d5516951318de2a45b058d16ffd852a740d0773289ee458e06e48edbcdb40efa840f11f2545be7866d43bdee4428a692","href":"https://static.observableusercontent.com/files/3a1763080d6d3f511f903204adb3dc30d5516951318de2a45b058d16ffd852a740d0773289ee458e06e48edbcdb40efa840f11f2545be7866d43bdee4428a692","name":"joinedTable-9.csv","type":"text/csv","lastModified":1638282003222.894,"size":1417871}] 2c:{"id":"5fd1b51fecd1c282","slug":null,"title":"Fire Incidents in the City of Pittsburgh","thumbnail":null,"access_level":"unlisted","create_time":"$D2021-11-25T23:55:07.841Z","update_time":"$D2022-01-31T20:14:59.222Z","view_time":null,"first_public_time":null,"has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"d39e0e18b64da313","login":"andreawan","name":"Andrea Wan","avatar_url":"https://avatars-next.observableusercontent.com/d4f747417611070223fce0afcbb3a4e007cf15186939cc05c26bb2e0953632a4","tier":"starter_2024"},"version":2065,"publish_version":2065,"role":null,"authored":false,"authors":[{"type":"individual","id":"d1d094ed1e90901c","login":"d1d094ed1e90901c","name":"Andrea Wan","avatar_url":"https://avatars-next.observableusercontent.com/d4f747417611070223fce0afcbb3a4e007cf15186939cc05c26bb2e0953632a4","tier":null}],"members":[{"type":"individual","id":"d1d094ed1e90901c","login":"d1d094ed1e90901c","name":"Andrea Wan","avatar_url":"https://avatars-next.observableusercontent.com/d4f747417611070223fce0afcbb3a4e007cf15186939cc05c26bb2e0953632a4","tier":null,"role":"editor"},{"type":"individual","id":"d01d15388605def8","login":"fmolinag","name":"Fernanda Molina Galindo","avatar_url":"https://avatars-next.observableusercontent.com/b24651d71fd9be2aab11cc2a7428ddd2bf0daf6a9cbbd782d29bc39dd3841078","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Fire Incidents in the City of Pittsburgh","cells":[{"id":0,"value":"# Fire Incidents in the City of Pittsburgh","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":665,"value":"By Fernanda Molina and Andrea Wan","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":492,"value":"md`

\n## Overview`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":676,"value":"### Introduction","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":679,"value":"Recently (in October) it was Fire Prevention Month, a month dedicated to raising awareness about fire safety. While the elementary school slogan \"stop, drop, and roll\" is both memorable and useful, there are additional fire safety techniques that can come in handy depending on each specific situation.\n\nThis interactive narrative visualization seeks to explore the different fire incidents which have occurred in the city of Pittsburgh. Understanding which types of fire incidents occur, as well as where and how often they occur, shed light on why fire incidents happen in our local community.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":687,"value":"### Purpose and Intended Audience","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":693,"value":"Understanding why and how fire incidents occur is instrumental to our goals of raising awareness on fire safety and educating the public on relevant safety techniques. The data analysis provided here makes clear which fire incidents are most common, and subsequently, which fire safety techniques are most relevant to the local community. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":700,"value":"### Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":704,"value":"The data we are analyzing is provided by the Western Pennsylvania Regional Data Center and includes various parameters related to incidents of fire responded to by the Pittsburgh Bureau of Fire beginning in January 2013 (and updated as late as November 2021). It includes information about the type of incident, the number of alarms, as well as location information such as longitude, latitude, and neighborhood.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":708,"value":"### Research Questions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":712,"value":"The questions we will be answering in this article are the following:\n1. How have fire incidents changed throughout the years? Have there been improvements?\n2. How do fire incidents vary from neighborhood to neighborhood? Are there certain types of incidents which occur more commonly in certain areas?\n3. What types of fire incidents are more common, and where do they occur?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1280,"value":"md`

\n## Visualizations`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1485,"value":"The total count of fire incidents in Pittsburgh throughout the years fluctuates. Looking at the chart below we can see that 2015 has the most amount of fire incidents totaling 1,027, while 2021 has the least amount of fire incidents. However, the data for 2021 does not include the full month of November or the month of December. Therefore, 2019 is the second year that has the least amount of fire incidents.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1356,"value":"vis4 = vl.markBar()\n .width(500)\n .height(500)\n .data(incidentSumPerYear)\n .encode(\n vl.x().fieldN('year').scale({zero: false}),\n vl.y().fieldQ('total'),\n vl.tooltip([\n { field: \"total\", type: \"quantitative\" },\n { field: \"year\", type: \"quantitative\" }\n ])\n )\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1502,"value":"**This highlights how the frequency of fire incidents has decreased throughout the years. Thus, this suggests that people are taking better precautions and this may indicate that the City of Pittsburgh has been working to amend the fire safety guidelines that are communicated to the community.**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1506,"value":"To explore the chart above, hover over each bar chart to see the total number of fire incidents per year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1513,"value":"**What is the breakdown of fire incidents per neighborhood in the City of Pittsburgh?**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1530,"value":"In the city of Pittsburgh, there are around 90 neighborhoods, and the amount of fires they encounter each year varies. We queried the data to categorize the incidents by neighborhood and year because the original dataset did not record the total incidents by neighborhood.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1536,"value":"Use the \"Select\" button to see the average total incidents per neighborhood filtered by year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":793,"value":"vis1 = { \n const selectYear = vl.selectPoint('Select')\n .fields('year') // limit selection by one value for now\n .bind(vl.menu(yearArr)); \n \n return vl.markBar()\n .data(newJoined)\n .params(selectYear)\n .transform(vl.filter(selectYear))\n .encode(\n vl.y().average(\"totalIncidentsperneigh\")\n .scale({type: 'linear', domain: [0, 45]})\n .title('Average Total Incidents Per Neighborhood'),\n vl.x().fieldN(\"neighborhood\")\n .sort(vl.average(\"totalIncidentsperneigh\").order('descending'))\n .title('Neighborhood'),\n vl.tooltip().average(\"totalIncidentsperneigh\"),\n //vl.opacity().if(selectYear, vl.value(0.9)).value(0.2)\n )\n .width(1070)\n .height(400)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1541,"value":"For all years except 2020, Carrick is in the top three neighborhoods with the highest average total incidents, while Squirrel Hill South is among the top ten. This might imply that a large number of residences or apartment complexes are prone to fires. Additionally, these areas may have a high concentration of restaurants too, making fires more likely.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1558,"value":"**This raises the question: what types of fire incidents are these neighborhoods facing each year? **\n\nSince the dataset did not show the total number of incidents by type, year, or neighborhood, SQL queries were created to look for this information.\n\nTake a look at the heatmap below; it shows the year that neighborhoods have the highest number of fire incidents and clicking on a specific neighborhood and year filters the scatterplot below. The scatterplot specifically shows what type of fire incident that neighborhood faced that year. Hovering over the fire incident type shows how many incidents of that type there were that year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":456,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1563,"value":"From the scatterplot, it can be seen that \"Cooking fire\", \"Building fire\", and \"Passenger vehicle fire\" are the most common types of fire incidents in neighborhoods. This is not surprising as driving and cooking are common day-to-day activities for most people, and - especially in more recent times due to the pandemic - more people spend longer periods of time isolating indoors.\n\nFurthermore, the heatmap shows 2016 was the year in which two neighborhoods - Central Business District and South Side Flats\" faced the most amount of fires from 2013-2021. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1235,"value":"vis3 = {\n const selectYear = vl.selectPoint('Select')\n .fields('year')\n .bind(vl.menu(yearArr));\n \n const bg = vl.markGeoshape({stroke: \"grey\", fill: \"lightgrey\", opacity: 0.3})\n .data(vl.topojson(neighborhoods).feature(\"neighborhoods\"))\n .encode(vl.tooltip(\"properties.hood\"))\n\n const incidents = vl.markPoint({filled: true, size: 12})\n .data(newJoined)\n .params(selectYear)\n .transform(vl.filter(selectYear))\n .encode(\n vl.latitude().fieldQ(\"latitude\"),\n vl.longitude().fieldQ(\"longitude\"),\n vl.color().fieldN(\"type_description\").title('Type of Fire'),\n vl.tooltip().fieldN(\"type_description\")\n )\n\n return vl\n .layer(bg, incidents)\n .project(vl.projection(\"mercator\"))\n .width(720)\n .height(720)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1603,"value":"From the map, it can be seen that there are not drastically high concentrations of fire incidents within neighborhoods. The majority of neighborhoods that have fire incidents have them throughout the neighborhood. This means that in general, people living within the same neighborhood, or operating restaurants and other businesses in the same vicinity, experience nearly the **same risks of encountering a fire incident.**\n\nTherefore, it is important to educate everyone in the community about fire safety and awareness.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1630,"value":"md`

\n## Basic Guide to Fire Safety`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1647,"value":"In fire incidents, mere seconds can mean the difference between a safe escape and a tragedy. In the following section, we will introduce the different types of fire incidents that have occurred in the city of Pittsburgh, and discuss fire safety and prevention techniques.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1673,"value":"### Fire Classes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1685,"value":"Fires can be classified based on the materials that are burning. Fires of different classes use different fire extinguishers, and may have different safety techniques involved.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1651,"value":"#### Class A Fires","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1715,"value":"Class A fires are the most common type of fires in everyday households, and the most easy to put out. These fires occur when commonly flammable material, such as wood, plastics, paper, and rubbish catch on fire.\n\nThese fires can be put out with water.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2038,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1969,"value":"*A short video counter of the total number of dumpster/rubbish-related fires in the dataset*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1654,"value":"#### Class B Fires","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1877,"value":"Class B fires are fires that occur when flammable liquids or gases - such as petroleum-based oils and paints, kerosene, gasoline, butane, and propane - catch on fire. This type of fire is more common in industry settings, where such ingredients are more likely to be present.\n\nDo NOT use water on Class B fires! Using water on class B fires can be extremely dangerous. Instead, when putting out Class B fires, the goal should be to reduce the amount of oxygen feeding the fire. Class B Fire extinguishers use dry chemicals such as ammonium phosphate, whose chemical composition is shown below.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1861,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1870,"value":"*Use the 3D viewer above to explore the chemical composition of Ammonium dihydrogen phosphate, which is used in fire extinguishers for this class!*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1659,"value":"#### Class C or E Fires ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1890,"value":"Class C fires (Class E in Australia) are electrical fires which occur due to malfunction of appliances and equipment. This can include common household items such as toasters, washers, and dryers, as well as industrial equipment in business settings.\n\nAs with Class B fires, Class C fires should not be put out with water, because water conducts electricity. Instead, use a fire extinguisher (multipurpose fire extinguishers for Classes A, B, and C are commonly available).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1663,"value":"#### Class D Fires","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1897,"value":"Class D fires are less common in everyday settings as they involve combustible metals, but can still happen.\n\nAn example of a possible cause for class D fires would include electronic devices, such as mobile phones, laptops, and desktop computers, which contain lithium.\n\nClass D fire extinguishers are different from multi-purpose Class A, B, and C fire extinguishers, and are typically only required for industrial settings, although regional ordinances may vary. In the city of Pittsburgh, Class D fire extinguishers are not required for residential settings.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1667,"value":"#### Class K or F Fires","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1924,"value":"Class K fires (Class F in Europe and Australia) are cooking fires, which typically occur as the result of cooking oils like grease, vegetable oil or animal fats.\n\nWater should not be used to put out Class K fires. Streams of water may further disperse the fuel, causing the fire to spread. Instead, the goal should be to reduce the spread of fuel and oxygen intake.\n\nClass K fire extinguishers are common in commercial kitchens, and are used to prevent the further spread of fire in the food service and restaurant industry.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":26,"value":"md`

\n## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"### DuckDB","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":11,"value":"import{DuckDBClient} from '@cmudig/duckdb'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"### Vega-Lite","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"import {vl} from \"@vega/vega-lite-api-v5\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"VegaLite = require(\"vega-embed@5\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"### D3","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":22,"value":"d3 = require('d3@6', 'd3-geo-projection', \"d3-dsv@1\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1635,"value":"### Three.js","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1638,"value":"THREE = {\n const THREE = window.THREE = await require(\"three@0.96/build/three.min.js\");\n await require(\"three@0.96/examples/js/controls/OrbitControls.js\").catch(() => {});\n await require(\"three@0.96/examples/js/loaders/MTLLoader.js\").catch(() => {});\n await require(\"three@0.96/examples/js/loaders/OBJLoader.js\").catch(() => {});\n return THREE;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1643,"value":"// viewport\nheight = 600","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"### Additional Utilities","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":18,"value":"import {printTable} from '@uwdata/data-utilities'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"import {uniqueValid} from '@uwdata/data-utilities'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1746,"value":"import {select} from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2005,"value":"import { youtubePlayer } from \"@radames/youtube-player-api\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":844,"value":"//alarms = [\"0\", \"1\", \"2\",\"3\", \"4\", \"5\",\"6\", \"7\", \"19\"]\nyearArr = [\"2013\", \"2014\", \"2015\",\"2016\", \"2017\", \"2018\",\"2019\", \"2020\", \"2021\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"## Inserting Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":37,"value":"fires = FileAttachment(\"cleanFires.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1001,"value":"neighborhoods = FileAttachment(\"neighborhoods@1.topojson\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"Inputs.table(fires)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":855,"value":"test = FileAttachment(\"joinedTable-9.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":819,"value":"newJoined = FileAttachment(\"NEWjoinedTable@1.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":822,"value":"Inputs.table(newJoined)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"md`

\n## Data Wrangling using DuckDB and SQL`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":215,"value":"client1.describe('cleanFires')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1919,"value":"client1 = DuckDBClient.of([\n await FileAttachment('cleanFires.csv')\n ])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":776,"value":"client2 = DuckDBClient.of([\n await FileAttachment(\"joinedTable-9.csv\")\n ])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":780,"value":"client2.describe('joinedTable-9')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1311,"value":"md`

\n### By Type`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":830,"value":"client1.table(`SELECT date_part('year', alarm_time) as year, type_description, incident_type, count(column00) as total \n FROM 'cleanFires'\n GROUP BY year, type_description, incident_type\n ORDER BY Year ASC`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1302,"value":"incidentSumPerType = client1.query(`SELECT date_part('year', alarm_time) as year, type_description, incident_type, count(column00) as total \n FROM 'cleanFires'\n GROUP BY year, type_description, incident_type\n ORDER BY Year ASC`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1293,"value":"md`

\n### By Neighborhood`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":783,"value":"client2.table(`SELECT year, neighborhood, count(column00) as totalPerNeigh\n FROM 'joinedTable-9' \n GROUP BY year, neighborhood\n ORDER BY totalPerNeigh DESC`)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1298,"value":"incidentSumPerNeigh = client2.query(`SELECT year, neighborhood, count(column00) as totalPerNeigh\n FROM 'joinedTable-9' \n GROUP BY year, neighborhood\n ORDER BY totalPerNeigh DESC`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1474,"value":"md`

\n### By Year`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1343,"value":"client2.table(`SELECT year, count(column00) as total\n FROM 'joinedTable-9'\n GROUP BY year`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1348,"value":"incidentSumPerYear = client2.query(`SELECT year, count(column00) as total\n FROM 'joinedTable-9'\n GROUP BY year`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1928,"value":"md`

\n## References`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1934,"value":"https://www.uclahealth.org/safety/classes-of-fires--fire-extinguishers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1939,"value":"https://pittsburghpa.gov/pli/pli-top-ten-violations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1943,"value":"https://www.ehs.pitt.edu/fire-safety","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1946,"value":"https://www.ehs.pitt.edu/section-ii-fire-safety","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1951,"value":"https://www.ready.gov/home-fires","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1959,"value":"https://vanguard-fire.com/what-are-the-5-different-classes-of-fires/","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W2f","stdlib":"1"}} 2d:"$2c:body"