daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where deaths = 5337 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-23 | US | Puerto Rico | Unassigned | 72999 | 24899 | 5337 | 0 | 18.459681 | -67.336525 | 2022-11-24 04:21:09 | Unassigned, Puerto Rico, US | |
2022-11-15 | Russia | Tula Oblast | 186620 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-16 04:21:09 | Tula Oblast, Russia | |||
2022-11-14 | Russia | Tula Oblast | 186589 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-15 04:21:16 | Tula Oblast, Russia | |||
2022-11-13 | Russia | Tula Oblast | 186560 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-14 04:21:09 | Tula Oblast, Russia | |||
2022-11-12 | Russia | Tula Oblast | 186533 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-13 04:21:14 | Tula Oblast, Russia | |||
2022-11-11 | Russia | Tula Oblast | 186505 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-12 04:20:41 | Tula Oblast, Russia | |||
2022-11-10 | Russia | Tula Oblast | 186475 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-11 04:21:22 | Tula Oblast, Russia | |||
2022-11-09 | Russia | Tula Oblast | 186443 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-10 04:21:16 | Tula Oblast, Russia | |||
2022-11-08 | Russia | Tula Oblast | 186408 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-09 04:21:22 | Tula Oblast, Russia | |||
2022-11-07 | Russia | Tula Oblast | 186377 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-08 04:21:21 | Tula Oblast, Russia | |||
2022-11-06 | Russia | Tula Oblast | 186345 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-07 04:21:26 | Tula Oblast, Russia | |||
2022-11-05 | Russia | Tula Oblast | 186314 | 5337 | 0 | 53.9570701 | 37.3690909 | 2022-11-06 04:21:24 | Tula Oblast, Russia | |||
2022-10-06 | Mexico | Morelos | 91048 | 5337 | 0 | 18.6813 | -99.1013 | 2022-10-07 04:23:08 | Morelos, Mexico | |||
2022-10-05 | Mexico | Morelos | 91048 | 5337 | 0 | 18.6813 | -99.1013 | 2022-10-06 04:21:22 | Morelos, Mexico | |||
2022-10-04 | Mexico | Morelos | 91048 | 5337 | 0 | 18.6813 | -99.1013 | 2022-10-05 04:23:06 | Morelos, Mexico | |||
2022-10-03 | Mexico | Morelos | 91048 | 5337 | 0 | 18.6813 | -99.1013 | 2022-10-04 04:22:55 | Morelos, Mexico | |||
2022-10-02 | Mexico | Morelos | 91043 | 5337 | 0 | 18.6813 | -99.1013 | 2022-10-03 04:23:11 | Morelos, Mexico | |||
2022-10-01 | Mexico | Morelos | 91043 | 5337 | 0 | 18.6813 | -99.1013 | 2022-10-02 04:21:23 | Morelos, Mexico | |||
2022-09-30 | Mexico | Morelos | 91015 | 5337 | 0 | 18.6813 | -99.1013 | 2022-10-01 04:23:01 | Morelos, Mexico | |||
2022-09-29 | Mexico | Morelos | 90984 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-30 04:23:09 | Morelos, Mexico | |||
2022-09-28 | Mexico | Morelos | 90836 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-29 04:22:34 | Morelos, Mexico | |||
2022-09-27 | Mexico | Morelos | 90836 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-28 04:23:01 | Morelos, Mexico | |||
2022-09-26 | Mexico | Morelos | 90836 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-27 04:23:01 | Morelos, Mexico | |||
2022-09-25 | Mexico | Morelos | 90832 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-26 04:20:52 | Morelos, Mexico | |||
2022-09-24 | Mexico | Morelos | 90832 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-25 04:23:31 | Morelos, Mexico | |||
2022-09-23 | Mexico | Morelos | 90794 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-24 04:21:40 | Morelos, Mexico | |||
2022-09-16 | Mexico | Morelos | 90276 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-17 04:20:19 | Morelos, Mexico | |||
2022-09-15 | Mexico | Morelos | 90276 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-16 04:21:19 | Morelos, Mexico | |||
2022-09-14 | Mexico | Morelos | 90276 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-15 04:21:02 | Morelos, Mexico | |||
2022-09-13 | Mexico | Morelos | 90276 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-14 04:20:44 | Morelos, Mexico | |||
2022-09-12 | Mexico | Morelos | 90267 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-13 04:20:57 | Morelos, Mexico | |||
2022-09-11 | Mexico | Morelos | 90267 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-12 04:20:58 | Morelos, Mexico | |||
2022-09-10 | Mexico | Morelos | 90244 | 5337 | 0 | 18.6813 | -99.1013 | 2022-09-11 04:20:50 | Morelos, Mexico | |||
2022-07-22 | Ukraine | Crimea Republic* | 184655 | 5337 | 0 | 45.2835 | 34.2008 | 2022-07-23 04:20:53 | Crimea Republic*, Ukraine | |||
2022-07-21 | Ukraine | Crimea Republic* | 184610 | 5337 | 0 | 45.2835 | 34.2008 | 2022-07-22 04:21:15 | Crimea Republic*, Ukraine | |||
2022-01-30 | Zimbabwe | 229460 | 5337 | 0 | -19.015438 | 29.154857 | 2022-01-31 04:21:09 | Zimbabwe | ||||
2022-01-04 | Venezuela | 445369 | 5337 | 0 | 6.4238 | -66.5897 | 2022-01-05 04:21:59 | Venezuela | ||||
2021-12-28 | US | Texas | Bexar | 48029 | 343245 | 5337 | 0 | 29.44928723 | -98.52019748 | 2021-12-29 03:21:43 | Bexar, Texas, US | |
2021-12-08 | Kenya | 255652 | 5337 | 0 | -0.0236 | 37.9062 | 2021-12-09 04:22:49 | Kenya | ||||
2021-12-07 | Kenya | 255544 | 5337 | 0 | -0.0236 | 37.9062 | 2021-12-08 04:22:46 | Kenya | ||||
2021-09-16 | US | Michigan | Wayne | 26163 | 181053 | 5337 | 0 | 42.28098405 | -83.281255 | 2021-09-17 04:21:46 | Wayne, Michigan, US | |
2021-09-16 | US | California | Orange | 6059 | 313110 | 5337 | 0 | 33.70147516 | -117.76459979999998 | 2021-09-17 04:21:46 | Orange, California, US | |
2021-09-15 | US | Michigan | Wayne | 26163 | 181053 | 5337 | 0 | 42.28098405 | -83.281255 | 2021-09-16 04:22:19 | Wayne, Michigan, US | |
2021-08-25 | US | California | San Bernardino | 6071 | 331207 | 5337 | 0 | 34.84060306 | -116.1774685 | 2021-08-26 04:21:28 | San Bernardino, California, US | |
2021-02-26 | Peru | Arequipa | 59935 | 5337 | 0 | 54598 | -15.843524 | -72.475539 | 2021-02-27 05:22:28 | Arequipa, Peru | ||
2021-02-26 | Pakistan | Punjab | 170817 | 5337 | 160685 | 4795 | 30.811346 | 72.13913199999998 | 2021-02-27 05:22:28 | Punjab, Pakistan | ||
2021-01-08 | Germany | Baden-Wurttemberg | 254652 | 5337 | 210300 | 41639 | 48.6616 | 9.3501 | 2021-01-09 05:22:18 | Baden-Wurttemberg, Germany | ||
2020-12-12 | Mexico | Puebla | 42447 | 5337 | 0 | 37110 | 19.0414 | -98.2063 | 2020-12-13 05:27:20 | Puebla, Mexico | ||
2020-07-14 | Brazil | Para | 130834 | 5337 | 115757 | 7495 | -1.9981 | -54.9306 | 2020-07-15 04:34:39 | Para, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;