johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where deaths = 4921 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
499636 | 499636 | 2022-04-02 | Italy | Friuli Venezia Giulia | 336823 | 4921 | 0 | 45.6494354 | 13.76813649 | 2022-04-03 04:20:48 | Friuli Venezia Giulia, Italy | |||
2052017 | 2052017 | 2022-01-25 | Netherlands | Zuid-Holland | 922074 | 4921 | 0 | 51.937835 | 4.462114 | 2022-01-26 04:21:07 | Zuid-Holland, Netherlands | |||
3836112 | 3836112 | 2021-10-05 | Ukraine | Dnipropetrovsk Oblast | 152910 | 4921 | 0 | 48.4647 | 35.0462 | 2021-10-06 04:21:33 | Dnipropetrovsk Oblast, Ukraine | |||
1334582 | 1334582 | 2021-09-28 | Spain | Pais Vasco | 260145 | 4921 | 0 | 42.9896 | -2.6189 | 2021-09-29 04:21:45 | Pais Vasco, Spain | |||
2103833 | 2103833 | 2021-06-01 | Azerbaijan | 334132 | 4921 | 325040 | 4171 | 40.1431 | 47.5769 | 2021-06-02 04:24:34 | Azerbaijan | |||
2820747 | 2820747 | 2021-05-10 | Ireland | 253189 | 4921 | 23364 | 224904 | 53.1424 | -7.6921 | 2021-05-11 04:20:41 | Ireland | |||
1425079 | 1425079 | 2021-05-09 | Ireland | 252809 | 4921 | 23364 | 224524 | 53.1424 | -7.6921 | 2021-05-10 04:20:38 | Ireland | |||
3113461 | 3113461 | 2021-05-06 | Ireland | 251474 | 4921 | 23364 | 223189 | 53.1424 | -7.6921 | 2021-05-07 04:20:40 | Ireland | |||
1881083 | 1881083 | 2021-03-26 | Mexico | San Luis Potosi | 60089 | 4921 | 0 | 55168 | 22.1565 | -100.9855 | 2021-03-27 05:25:04 | San Luis Potosi, Mexico | ||
742474 | 742474 | 2021-02-20 | Peru | Ica | 39671 | 4921 | 0 | 34750 | -14.235097 | -75.574821 | 2021-02-21 05:24:33 | Ica, Peru | ||
1676550 | 1676550 | 2021-02-01 | Mexico | Chihuahua | 40845 | 4921 | 0 | 35924 | 28.633000000000006 | -106.0691 | 2021-02-02 05:22:49 | Chihuahua, Mexico | ||
2227445 | 2227445 | 2021-01-02 | Greece | 139709 | 4921 | 93764 | 41024 | 39.0742 | 21.8243 | 2021-01-03 05:22:52 | Greece | |||
1026098 | 1026098 | 2020-10-17 | Brazil | Parana | 198744 | 4921 | 140100 | 53723 | -25.2521 | -52.0215 | 2020-10-18 04:24:25 | Parana, Brazil | ||
1243977 | 1243977 | 2020-09-08 | Russia | Moscow | 267742 | 4921 | 223502 | 39319 | 55.7504461 | 37.6174943 | 2020-09-09 04:28:48 | Moscow, Russia |
Advanced export
JSON shape: default, array, newline-delimited
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]);