43:["$","title",null,{"children":"Homework 4 - UFO Sightings Dashboard | joffreycodes | Observable"}] 4b:[{"id":"b6b97028ae178b0da715d945ad25b4b7e4474e74e82d3735a779b7d258b7dbdafda59945a806f5f0446f683bcb440de6dcade34f88e2a725e84e5b75a92d65b8","href":"https://static.observableusercontent.com/files/b6b97028ae178b0da715d945ad25b4b7e4474e74e82d3735a779b7d258b7dbdafda59945a806f5f0446f683bcb440de6dcade34f88e2a725e84e5b75a92d65b8","name":"ufo-sightings-QueryResult11k.csv","type":"text/csv","lastModified":1634011038820.935,"size":828840}] 47:{"id":"993692fffda09df2","slug":"homework-4-ufo-sightings-dashboard","title":"Homework 4 - UFO Sightings Dashboard","thumbnail":"3490e9dcaaa700a08c5b5294083ad9aae6c93f67679978a66e02c8fb2fde4d60","access_level":"public","create_time":"$D2021-10-12T03:57:18.820Z","update_time":"$D2021-10-16T19:31:23.402Z","view_time":null,"first_public_time":"$D2021-10-12T03:58:38.137Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"f9892825073e583b","login":"joffreycodes","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a3daa83fe1a1a6ddc1321466109b203411d300f9eb047199eabc07754c3e37be","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1197,"publish_version":1197,"role":null,"authored":false,"authors":[{"type":"individual","id":"296a7098bf6416f0","login":"joffreycodes","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a3daa83fe1a1a6ddc1321466109b203411d300f9eb047199eabc07754c3e37be","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"296a7098bf6416f0","login":"joffreycodes","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a3daa83fe1a1a6ddc1321466109b203411d300f9eb047199eabc07754c3e37be","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Homework 4 - UFO Sightings Dashboard","cells":[{"id":0,"value":"# Homework 4 - UFO Sightings Dashboard","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"Data was obtained from the UFO Sightings dataset @
https://data.world/timothyrenner/ufo-sightings
using the following query:
`SELECT city, state, date_time, shape, city_latitude as latitude, city_longitude as longitude \nFROM nuforc_reports \nWHERE date_time BETWEEN '2019-01-01 12:00:00' AND '2021-09-24 23:30:00'\nAND city_latitude IS NOT NULL\nAND city_longitude IS NOT NULL\nAND shape IS NOT NULL;`","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"data = d3.csvParse(await FileAttachment(\"ufo-sightings-QueryResult11k.csv\").text(), d3.autoType)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":756,"value":"color = d3.scaleOrdinal(d3.schemeTableau10 )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"viewof table = Inputs.table(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":505,"value":"viewof rawFreq = Plot.plot({\n width:1200,\n x: {\n domain: d3.groupSort(data, g => -g.length, d => d.shape)\n },\n y: {\n grid: true\n },\n marks: [\n Plot.barY(data, Plot.groupX({y: \"count\"}, {x: \"shape\", fill:\"shape\"})),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":852,"value":"grid = html`

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"# DateSlider\nDate Range:
${dateFilter.range[0].toDateString()} - ${dateFilter.range[1].toDateString()}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"viewof dateFilter = rangeSlider(data, d=>d.date_time)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":947,"value":"dateFilter","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":737,"value":"# Shape Filter","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":608,"value":"viewof shapes = Inputs.checkbox(data.map(d => d.shape), {\n label: \"Shapes\", \n unique: \"true\",\n sort: \"ascending\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":623,"value":"filteredData = dateFilter.data.filter(d => shapes.includes(d.shape))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"map = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":536,"value":"viewof colors = Swatches({\n color: d3.scaleOrdinal(filteredData.map(d => d.shape).sort(), d3.schemeTableau10),\n columns: \"300px\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"stateFreq = Plot.plot({\n x: {\n domain: d3.groupSort(filteredData, g => -g.length, d => d.state)\n },\n y: {\n grid: true\n },\n width: 1200,\n marks: [\n Plot.barY(filteredData, Plot.groupX({y: \"count\"}, {x: \"state\", fill:\"shape\"})),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"monthFreq = Plot.plot({\n y: {\n grid: true,\n },\n x: {\n tickFormat: Plot.formatMonth()\n },\n width: 1200,\n marks: [\n Plot.barY(filteredData, Plot.groupX({y: \"count\"}, {x: d=>d.date_time.getUTCMonth(), fill:\"shape\"})),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":854,"value":"class Cell {\n constructor(element) {\n this.element = element;\n element.style.position = \"relative\";\n }\n get width() {\n return resizer(this.element, \"clientWidth\");\n }\n get height() {\n return resizer(this.element, \"clientHeight\");\n }\n embed(content) {\n content.style.position = \"absolute\";\n content.style.width = \"100%\";\n content.style.height = \"100%\";\n if (this.element.firstChild) this.element.replaceChild(content, this.element.firstChild);\n else this.element.appendChild(content);\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":878,"value":"cellA.embed(viewof dateFilter)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":880,"value":"cellB.embed(map)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":958,"value":"cellC.embed(viewof shapes)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":882,"value":"\ncellD.embed(monthFreq)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":925,"value":"cellE.embed(stateFreq)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":856,"value":"function resizer(element, dimension = \"clientWidth\") {\n return Generators.observe(notify => {\n let width = notify(element[dimension]);\n const resized = () => {\n let w = element[dimension];\n if (w !== width) notify(width = w);\n };\n window.addEventListener(\"resize\", resized);\n return () => window.removeEventListener(\"resize\", resized);\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":858,"value":"cellA = new Cell(grid.querySelector(\"[name=a]\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":859,"value":"cellB = new Cell(grid.querySelector(\"[name=b]\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":861,"value":"cellC = new Cell(grid.querySelector(\"[name=c]\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":915,"value":"cellD = new Cell(grid.querySelector(\"[name=d]\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1109,"value":"cellE = new Cell(grid.querySelector(\"[name=e]\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":866,"value":"widthA = cellA.width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":869,"value":"widthB = cellB.width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":872,"value":"widthC = cellC.width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":867,"value":"heightA = cellA.height","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":924,"value":"heightD = cellD.height","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":873,"value":"heightB = cellB.height","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":875,"value":"heightC = cellC.height","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":537,"value":"import {swatches as Swatches} from \"@d3/color-legend\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"import {topojson, d3, us, path, projection} from '@d3/u-s-state-capitals'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"import {rangeSlider} from \"@bumbeishvili/utils\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 42:null