Published
Edited
Apr 5, 2020
1 fork
Importers
Insert cell
Insert cell
confirmedGlobal = d3.csv(
"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv"
)
Insert cell
deathGlobal = d3.csv(
"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv"
)
Insert cell
confirmedUS = d3.csv(
"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv"
)
Insert cell
deathUS = d3.csv(
"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_US.csv"
)
Insert cell
tidy = (raw, type, regionKey, subRegionKey) => {
const data = [];
for (const d of raw) {
for (const column of Object.keys(d)) {
const date = parseDateMDY(column);
if (date === null) {
continue;
}
data.push(
{
type,
region: d[regionKey],
subRegion: d[subRegionKey],
lat: +d["Lat"],
long: +(d["Long"] || d["Long_"]),
ymd: d3.timeFormat("%Y-%m-%d")(date),
date,
total: parseInt(d[column], 10),
},
);
}
}
return data;
}
Insert cell
dataGlobal = [
...tidy(confirmedGlobal, "confirmed", "Country/Region", "Province/State"),
...tidy(deathGlobal, "death", "Country/Region", "Province/State"),
].sort((a, b) =>
d3.ascending(a.date, b.date)
)
Insert cell
dataUS = [
...tidy(confirmedUS, "confirmed", "Province_State", "Admin2"),
...tidy(deathUS, "death", "Province_State", "Admin2"),
].sort((a, b) =>
d3.ascending(a.date, b.date)
)
Insert cell
data = dataGlobal
Insert cell
d3 = require("d3@5", "d3-array@2")
Insert cell
parseDateMDY = d3.timeParse("%m/%d/%y")
Insert cell

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.
Learn more