johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where deaths = 5783 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3950685 | 3950685 | 2022-08-17 | Russia | Bashkortostan Republic | 294356 | 5783 | 0 | 54.8573563 | 57.1439682 | 2022-08-18 04:21:11 | Bashkortostan Republic, Russia | |||
1656659 | 1656659 | 2022-03-19 | Russia | Saratov Oblast | 233787 | 5783 | 0 | 51.652055499999996 | 46.86319520000001 | 2022-03-20 04:20:45 | Saratov Oblast, Russia | |||
3859483 | 3859483 | 2022-02-18 | Ukraine | Zaporizhia Oblast | 208555 | 5783 | 0 | 47.8388 | 35.1396 | 2022-02-19 04:21:11 | Zaporizhia Oblast, Ukraine | |||
1960659 | 1960659 | 2022-01-20 | Mexico | Tabasco | 162674 | 5783 | 0 | 17.8409 | -92.6189 | 2022-01-21 04:21:09 | Tabasco, Mexico | |||
3226554 | 3226554 | 2022-01-19 | Mexico | Tabasco | 162674 | 5783 | 0 | 17.8409 | -92.6189 | 2022-01-20 04:21:07 | Tabasco, Mexico | |||
798626 | 798626 | 2021-12-22 | Russia | Chelyabinsk Oblast | 140503 | 5783 | 0 | 54.4223954 | 61.1865846 | 2021-12-23 04:21:21 | Chelyabinsk Oblast, Russia | |||
404861 | 404861 | 2021-12-07 | US | California | Orange | 6059 | 337045 | 5783 | 0 | 33.70147516 | -117.76459979999998 | 2021-12-08 04:22:46 | Orange, California, US | |
1334496 | 1334496 | 2021-09-28 | Russia | Krasnoyarsk Krai | 115327 | 5783 | 0 | 63.3233807 | 97.09799740000001 | 2021-09-29 04:21:45 | Krasnoyarsk Krai, Russia | |||
1980769 | 1980769 | 2021-03-25 | Peru | Arequipa | 64523 | 5783 | 0 | 58740 | -15.843524 | -72.475539 | 2021-03-26 05:26:55 | Arequipa, Peru | ||
1632542 | 1632542 | 2020-12-05 | Russia | Saint Petersburg | 144400 | 5783 | 83558 | 55059 | 59.9606739 | 30.158655100000004 | 2020-12-06 05:26:18 | Saint Petersburg, Russia | ||
3409618 | 3409618 | 2020-11-01 | Poland | 379902 | 5783 | 146595 | 227524 | 51.9194 | 19.1451 | 2020-11-02 05:25:04 | Poland | |||
2661555 | 2661555 | 2020-09-04 | Canada | Quebec | 63173 | 5783 | 55724 | 1666 | 52.9399 | -73.5491 | 2020-09-05 04:28:19 | Quebec, Canada | ||
1354095 | 1354095 | 2020-09-03 | Canada | Quebec | 62988 | 5783 | 55615 | 1590 | 52.9399 | -73.5491 | 2020-09-04 04:28:26 | Quebec, Canada |
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]);