2f:[] 2d:{"title":"Helicopters over Sacramento","cells":[{"id":0,"value":"# Helicopters over Sacramento","pinned":false,"hidden":false,"mode":"md"},{"id":40,"value":"{\n const firstDate = flightsPerDate[0].date;\n const mostRecent = flightsPerDate[flightsPerDate.length - 1];\n const transformed = data.map((d) => {\n const copy = { ...d };\n copy.date = d3.timeFormat(\"%Y-%m-%d\")(parseDate(d.date));\n return copy;\n });\n const table = Inputs.table(transformed, {\n sort: \"date\",\n reverse: true\n });\n return html`

Since ${formatDate(firstDate)} (${\n flightsPerDate.length\n } days ago), there have been ${\n data.length\n } helicopter flight notifications in Sacramento. That's an average of roughly ${Math.round(\n averageFlightsPerday\n )} flights per day.

On the most recent date for which there is data, ${formatDate(\n mostRecent.date\n )}, there were ${\n mostRecent.count\n } notifications for different flights. Here are all of the flights:

${table}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"perDayChart = html`Helicopter flights per day
With 7 day moving average
${Plot.plot(\n {\n y: {\n domain: [0, d3.max(flightsPerDate, (d) => d.count) + 2]\n },\n marks: [\n Plot.line(flightsPerDate, { x: \"date\", y: \"count\", curve: \"natural\" }),\n Plot.lineY(\n flightsPerDate,\n Plot.windowY({\n k: 7,\n curve: \"basis\",\n x: \"date\",\n y: \"count\",\n stroke: \"red\",\n clip: true\n })\n )\n // Plot.ruleY([averageFlightsPerday], { stroke: \"red\" })\n ]\n }\n)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":146,"value":"viewof neighborhoodRowCount = Inputs.range([0, flightsPerNeighborhood.length], {\n label: \"Number of neighborhoods to show\",\n step: 1,\n value: 15\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":96,"value":"html`Helicopter flights per neighborhood, top ${neighborhoodRowCount}
${Plot.plot(\n {\n marginLeft: 190,\n marks: [\n Plot.barX(flightsPerNeighborhood.slice(0, neighborhoodRowCount), {\n x: \"count\",\n y: \"neighborhood\",\n sort: {\n y: \"x\",\n reverse: true\n }\n })\n ]\n }\n)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":30,"value":"averageFlightsPerday = d3.mean(flightsPerDate, (d) => d.count)","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"flightsPerNeighborhood = {\n const rolled = d3.rollup(\n data,\n (values) => values.length,\n (d) => d.neighborhood\n );\n const arr = [];\n rolled.forEach((count, neighborhood) => {\n arr.push({\n neighborhood: neighborhood === \"\" ? \"Unknown\" : neighborhood,\n count\n });\n });\n const sorted = _.orderBy(arr, [\"count\"], [\"desc\"]);\n return sorted;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":14,"value":"flightsPerDate = {\n const rolled = d3.rollup(\n data,\n (values) => values.length,\n (d) => parseDate(d.date)\n );\n const arr = [];\n rolled.forEach((count, date) => {\n arr.push({\n date,\n count\n });\n });\n const sorted = _.orderBy(arr, [\"date\"]);\n return sorted;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"parseDate = d3.timeParse(\"%A, %B %d, %Y\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":45,"value":"formatDate = d3.timeFormat(\"%B %d, %Y\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"data = d3.json(\n \"https://raw.githubusercontent.com/jeremiak/sacramento-helicopter-notifications/main/notifications.json\"\n)","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}