johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

12 rows where country_or_region = "Belgium" and "last_update" is on date 2022-10-17 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, day (date), last_update (date)

country_or_region 1

  • Belgium · 12 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2159226 2159226 2022-10-16 Belgium Antwerp     739745 0 0   51.2195 4.4024 2022-10-17 04:20:31 Antwerp, Belgium
2159227 2159227 2022-10-16 Belgium Brussels     493152 0 0   50.8503 4.3517 2022-10-17 04:20:31 Brussels, Belgium
2159228 2159228 2022-10-16 Belgium East Flanders     620913 0 0   51.0362 3.7373 2022-10-17 04:20:31 East Flanders, Belgium
2159229 2159229 2022-10-16 Belgium Flemish Brabant     448701 0 0   50.9167 4.5833 2022-10-17 04:20:31 Flemish Brabant, Belgium
2159230 2159230 2022-10-16 Belgium Hainaut     503688 0 0   50.5257 4.0621 2022-10-17 04:20:31 Hainaut, Belgium
2159231 2159231 2022-10-16 Belgium Liege     409210 0 0   50.4496 5.8492 2022-10-17 04:20:31 Liege, Belgium
2159232 2159232 2022-10-16 Belgium Limburg     338831 0 0   50.9739 5.342 2022-10-17 04:20:31 Limburg, Belgium
2159233 2159233 2022-10-16 Belgium Luxembourg     119702 0 0   50.0547 5.4677 2022-10-17 04:20:31 Luxembourg, Belgium
2159234 2159234 2022-10-16 Belgium Namur     197348 0 0   50.331 4.8221 2022-10-17 04:20:31 Namur, Belgium
2159235 2159235 2022-10-16 Belgium Unknown     61649 32776 0       2022-10-17 04:20:31 Unknown, Belgium
2159236 2159236 2022-10-16 Belgium Walloon Brabant     168643 0 0   50.4 4.35 2022-10-17 04:20:31 Walloon Brabant, Belgium
2159237 2159237 2022-10-16 Belgium West Flanders     484982 0 0   51.0536 3.1458 2022-10-17 04:20:31 West Flanders, Belgium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);