Vaccination Delivery Rates
data = vaccinations.map(d => {
return {
...d,
Date: parser(d.Date), // number of reviews (comments) on that story
Distributed: +d.Distributed,
Administered: +d.Administered,
Rate: Math.round((d.Administered * 100) / d.Distributed)
}
})
Inputs.table(data) //, {columns: ["Date","Location", "Distributed", "Administered"]}
parser = d3.timeParse("%m/%d/%Y")
data
state_data = data.filter(d => states_arr.includes(d.Location))
vax_table
.groupby('Location')
.view(5)
vax_table = aq.from(state_data)
vals = vax_table
.groupby('Date')
.rollup({ rate: op.mean('Rate') })
plot_plot = Plot.plot({
x: {domain: [new Date("2020-12-30"), new Date("2021-02-11")],grid:false, ticks:10},
y: {domain: [0, 100]}, grid: true,
width:width,
marginLeft:60,
marks:[
Plot.line(state_data, {x: "Date", y:"Rate", z:"Location", stroke:"lightgrey"}),
Plot.line(vals.objects(),{x: 'Date', y:'rate', stroke:"rgb(46, 114, 101)", strokeWidth:3}), //#2e7265 hex and rgb values are accepted
]
})
states_arr = us.usaStates.map(d => d.abbreviation)
the_series = tidy(
state_data,
groupBy(
'Location',
groupBy.entries({
mapEntry: ([key, values]) => ({ name: key, values }),
mapLeaf: (d => d.Rate < 100 ? d.Rate : 100)
})
)
)
tidy_dates = state_data.map(d => d.Date)
dates_col = {
const new_format = d3.timeFormat("%Y-%m-%d")
return tidy_dates.map(k => new_format(k))
}
dates_set = [...new Set(dates_col)]
dates_arr = (Array.from(dates_set))
final_dates = dates_arr.map(d3.utcParse("%Y-%m-%d"))
final_data = ({ y: 'Deployment %', series: the_series, dates: final_dates })
import {data as ref_data} from "@caupolicandiaz/d/05f1d8b8dc90a213"
import { LineChart } from '@d3/multi-line-chart'
LineChart(state_data, {
width,
x: (d) => d.Date,
y: (d) => d.Rate,
z: (d) => d.Location
})
Appendix
import { aq, op } from '@uwdata/arquero'
import {
tidy,
pivotLonger,
groupBy,
mutate,
distinct,
map,
summarize,
mean,
total
} from '@pbeshai/tidyjs'
us = import('https://cdn.skypack.dev/typed-usa-states@2.0.1?min')
d3 = require("d3@6")
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
