dataviz + interactive analytics
Published
Edited
md`Show items that have slots, in response to canceled appointments reappearing on the site`
unfilteredWithSlots = apiLocationsUnfiltered.locations.filter(loc => loc.json.slots.length > 0)
unrecognizedLocations = apiLocations.locations.filter(row => newIds.has(row.id)).map(formatLocForTable)
aq.from(unrecognizedLocations)
.view()
recognizedLocations = apiLocations.locations.filter(row => !newIds.has(row.id)).map(formatLocForTable)
aq.from(recognizedLocations)
.view()
md`These locations are in the sheet but not in the API... perhaps they were renamed?`
maybeStaleLocations = sheetLocations.filter(row => maybeStaleIds.has(Number(row['locations/id'])))
aq.from(maybeStaleLocations)
.view()
formatLocForTable = loc => {
return {
...loc,
address: loc.address.join(" ")
}
}
sheetLocations = d3.csv('https://docs.google.com/spreadsheets/d/e/2PACX-1vTmgw0Qvj65TWlhxOprndjA702WPTLFsUVXlpV18hWEH5KR_I0JpY30W1Ki6JnIKwEmxvxzkvR0hJw2/pub?output=csv')
apiLocations = d3.json('https://admin.nycvaccinelist.com/api/locations')
apiLocationsUnfiltered = d3.json('https://admin.nycvaccinelist.com/api/locations_unfiltered')
apiIds = apiLocations.locations.map(loc => loc.id)
sheetIds = sheetLocations.map(row => Number(row['locations/id']))
md`Check items from API that are new`
newIds = {
const sheetIdSet = new Set(sheetIds);
return new Set(apiIds.filter(id => !sheetIdSet.has(id)))
}
maybeStaleIds = {
const apiIdSet = new Set(apiIds);
return new Set(sheetIds.filter(id => !apiIdSet.has(id)))
}
md`
## Related reading
https://observablehq.com/@uwdata/introducing-arquero
`
d3 = require("d3@5")
import { aq, op } from '@uwdata/arquero'
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.
