daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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

12 rows where country_or_region = "Belgium" and day = "2020-12-30" sorted by day descending

✎ View and edit SQL

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

Suggested facets: deaths, last_update (date)

country_or_region 1

  • Belgium · 12 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-12-30 Belgium Antwerp     79005 0 0 79005 51.2195 4.4024 2020-12-31 05:22:49 Antwerp, Belgium
2020-12-30 Belgium Brussels     81252 0 0 81252 50.8503 4.3517 2020-12-31 05:22:49 Brussels, Belgium
2020-12-30 Belgium East Flanders     64629 0 0 64629 51.0362 3.7373 2020-12-31 05:22:49 East Flanders, Belgium
2020-12-30 Belgium Flemish Brabant     48953 0 0 48953 50.9167 4.5833 2020-12-31 05:22:49 Flemish Brabant, Belgium
2020-12-30 Belgium Hainaut     101770 0 0 101770 50.5257 4.0621 2020-12-31 05:22:49 Hainaut, Belgium
2020-12-30 Belgium Liege     96618 0 0 96618 50.4496 5.8492 2020-12-31 05:22:49 Liege, Belgium
2020-12-30 Belgium Limburg     29041 0 0 29041 50.9739 5.3420000000000005 2020-12-31 05:22:49 Limburg, Belgium
2020-12-30 Belgium Luxembourg     18312 0 0 18312 50.0547 5.4677 2020-12-31 05:22:49 Luxembourg, Belgium
2020-12-30 Belgium Namur     35312 0 0 35312 50.331 4.8221 2020-12-31 05:22:49 Namur, Belgium
2020-12-30 Belgium Unknown     10614 19441 0 0     2020-12-31 05:22:49 Unknown, Belgium
2020-12-30 Belgium Walloon Brabant     24999 0 0 24999 50.4 4.35 2020-12-31 05:22:49 Walloon Brabant, Belgium
2020-12-30 Belgium West Flanders     53737 0 0 53737 51.0536 3.1458 2020-12-31 05:22:49 West Flanders, Belgium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;