Remember COVID-19 ?
Showing Covid Time Series for
I graduated my undergrad in 2020, and the COVID-19 pandemic was a significant part of my final semester. I still remember the fear and uncertainty that gripped the world as the virus spread rapidly across countries. The pandemic changed the way we live, work, and interact with each other. We all learned how to adapt to a new normal, wearing masks, social distancing, and working from home. Venturing about the job market mid 2020 was difficult, but I was lucky to have found a role through my personal data projects then.
This page gives a brief look at how COVID-19 affected different countries. It shows how Datasette and the Observable framework can work together. Our interactive dashboard displays the number of COVID-19 deaths in a country over time. Using simple queries, we show real-time data from 2020 to 2022, giving a historical view of the pandemic.
This interactive display helps understand how COVID-19 changed over time. You can explore and analyze the data to see how the pandemic affected different places.
const country = view(Inputs.select(countries, {
value: "Albania",
label: "Country : "
}));
Plot.plot({
y: {
grid: true,
label: `Time Series of Covid Deaths : ${country}`
},
width: width,
marginLeft: 60,
marks: [
Plot.line(data_with_dates, {
x: "end_date",
y: "total_deaths",
title: "Covid Numbers",
tip: true
})
],
x: { label: "Date" },
y: { label: "Number of Deaths" }
})
Fetch data
const country_sql = `select end_date as date, expected_deaths from economist_excess_deaths where country = "${country}" `
country_sql
const data = d3.json(
`https://covid-19.datasettes.com/covid/economist_excess_deaths.json?country__exact=${country}&_sort_desc=end_date&_shape=array`
);
const data_with_dates = data.map(function(d) {
d.end_date = d3.timeParse("%Y-%m-%d")(d.end_date);
return d;
})
Inputs.table(data_with_dates)
Fetch list of countries
const countriess_sql = "select country from economist_excess_deaths group by country"
const countries = fetch(
`https://covid-19.datasettes.com/covid.json?sql=${encodeURIComponent(
countriess_sql
)}&_size=max&_shape=arrayfirst`
).then((r) => r.json());
countries