daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 6886 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-06-30 | Spain | Pais Vasco | 733840 | 6886 | 0 | 42.9896 | -2.6189 | 2022-07-01 04:21:10 | Pais Vasco, Spain | |||
2022-06-29 | Spain | Pais Vasco | 733840 | 6886 | 0 | 42.9896 | -2.6189 | 2022-06-30 04:21:01 | Pais Vasco, Spain | |||
2022-06-28 | Spain | Pais Vasco | 733840 | 6886 | 0 | 42.9896 | -2.6189 | 2022-06-29 04:20:59 | Pais Vasco, Spain | |||
2022-06-14 | Russia | Volgograd Oblast | 223275 | 6886 | 0 | 49.6048339 | 44.2903582 | 2022-06-15 04:20:54 | Volgograd Oblast, Russia | |||
2022-06-13 | Russia | Volgograd Oblast | 223157 | 6886 | 0 | 49.6048339 | 44.2903582 | 2022-06-14 04:20:52 | Volgograd Oblast, Russia | |||
2022-06-12 | Russia | Volgograd Oblast | 223036 | 6886 | 0 | 49.6048339 | 44.2903582 | 2022-06-13 04:21:14 | Volgograd Oblast, Russia | |||
2022-04-03 | US | California | Orange | 6059 | 587408 | 6886 | 0 | 33.70147516 | -117.76459979999998 | 2022-04-04 04:20:51 | Orange, California, US | |
2022-04-02 | US | California | Orange | 6059 | 587408 | 6886 | 0 | 33.70147516 | -117.76459979999998 | 2022-04-03 04:20:48 | Orange, California, US | |
2022-04-01 | US | California | Orange | 6059 | 587408 | 6886 | 0 | 33.70147516 | -117.76459979999998 | 2022-04-02 04:20:47 | Orange, California, US | |
2022-04-01 | Brazil | Alagoas | 296226 | 6886 | 0 | -9.5713 | -36.782 | 2022-04-02 04:20:47 | Alagoas, Brazil | |||
2022-03-11 | Russia | Stavropol Krai | 188494 | 6886 | 0 | 44.86325770000001 | 43.4406913 | 2022-03-12 04:20:50 | Stavropol Krai, Russia | |||
2022-02-09 | Brazil | Rondonia | 341370 | 6886 | 0 | -11.5057 | -63.5806 | 2022-02-10 04:21:14 | Rondonia, Brazil | |||
2022-02-06 | Korea, South | 1044963 | 6886 | 0 | 35.90775700000001 | 127.766922 | 2022-02-07 04:21:05 | Korea, South | ||||
2021-12-01 | Italy | Puglia | 279751 | 6886 | 0 | 41.12559576 | 16.86736689 | 2021-12-02 04:22:37 | Puglia, Italy | |||
2021-11-16 | Mexico | Tamaulipas | 102332 | 6886 | 0 | 24.2669 | -98.8363 | 2021-11-17 04:21:48 | Tamaulipas, Mexico | |||
2021-11-15 | Mexico | Tamaulipas | 102318 | 6886 | 0 | 24.2669 | -98.8363 | 2021-11-16 04:21:10 | Tamaulipas, Mexico | |||
2021-08-10 | Peru | Junin | 82381 | 6886 | 0 | -11.541783 | -74.876968 | 2021-08-11 04:21:58 | Junin, Peru | |||
2021-07-06 | Italy | Toscana | 244584 | 6886 | 236217 | 1481 | 43.76923077 | 11.25588885 | 2021-07-07 04:21:20 | Toscana, Italy | ||
2021-04-17 | Lebanon | 508503 | 6886 | 423848 | 77769 | 33.8547 | 35.8623 | 2021-04-18 04:20:41 | Lebanon | |||
2021-03-10 | Greece | 212091 | 6886 | 93764 | 111441 | 39.0742 | 21.8243 | 2021-03-11 05:25:48 | Greece |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;