daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where deaths = 2477 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-24 | Chile | Los Lagos | 232841 | 2477 | 0 | -41.9198 | -72.1416 | 2022-11-25 04:21:06 | Los Lagos, Chile | |||
2022-11-04 | Ukraine | Sevastopol* | 96003 | 2477 | 0 | 44.6054 | 33.522 | 2022-11-05 04:21:52 | Sevastopol*, Ukraine | |||
2022-10-10 | Germany | Mecklenburg-Vorpommern | 620223 | 2477 | 0 | 53.6127 | 12.4296 | 2022-10-11 04:23:05 | Mecklenburg-Vorpommern, Germany | |||
2022-07-10 | Russia | Kemerovo Oblast | 166579 | 2477 | 0 | 54.5335781 | 87.342861 | 2022-07-11 04:20:46 | Kemerovo Oblast, Russia | |||
2022-06-07 | Italy | Sardegna | 316967 | 2477 | 0 | 39.21531192 | 9.110616306 | 2022-06-08 04:20:55 | Sardegna, Italy | |||
2022-05-21 | Russia | Kursk Oblast | 117939 | 2477 | 0 | 51.6568453 | 36.4852695 | 2022-05-22 04:20:52 | Kursk Oblast, Russia | |||
2022-04-06 | Chile | OHiggins | 147602 | 2477 | 0 | -34.5755 | -71.0022 | 2022-04-07 04:20:53 | OHiggins, Chile | |||
2022-04-05 | Chile | OHiggins | 147434 | 2477 | 0 | -34.5755 | -71.0022 | 2022-04-06 04:20:49 | OHiggins, Chile | |||
2022-04-04 | Chile | OHiggins | 147335 | 2477 | 0 | -34.5755 | -71.0022 | 2022-04-05 04:20:48 | OHiggins, Chile | |||
2022-02-16 | Colombia | Meta | 103832 | 2477 | 0 | 3.272 | -73.0877 | 2022-02-17 04:20:56 | Meta, Colombia | |||
2022-02-15 | Colombia | Meta | 103770 | 2477 | 0 | 3.272 | -73.0877 | 2022-02-16 04:21:10 | Meta, Colombia | |||
2022-02-06 | US | California | Fresno | 6019 | 237417 | 2477 | 0 | 36.75733899 | -119.6466953 | 2022-02-07 04:21:05 | Fresno, California, US | |
2022-02-05 | US | California | Fresno | 6019 | 236209 | 2477 | 0 | 36.75733899 | -119.6466953 | 2022-02-06 04:21:00 | Fresno, California, US | |
2022-02-04 | US | California | Fresno | 6019 | 236174 | 2477 | 0 | 36.75733899 | -119.6466953 | 2022-02-05 04:21:05 | Fresno, California, US | |
2022-01-17 | Russia | Smolensk Oblast | 86783 | 2477 | 0 | 55.03434960000001 | 33.0192065 | 2022-01-18 04:21:04 | Smolensk Oblast, Russia | |||
2022-01-17 | Kuwait | 470478 | 2477 | 0 | 29.311659999999996 | 47.481766 | 2022-01-18 04:21:04 | Kuwait | ||||
2022-01-13 | US | Indiana | Marion | 18097 | 192629 | 2477 | 0 | 39.78163624 | -86.13826325 | 2022-01-14 04:21:54 | Marion, Indiana, US | |
2022-01-11 | US | New York | Westchester | 36119 | 220258 | 2477 | 0 | 41.16278376 | -73.75741653 | 2022-01-12 04:21:44 | Westchester, New York, US | |
2022-01-03 | Jamaica | 95946 | 2477 | 0 | 18.1096 | -77.2975 | 2022-01-04 04:22:17 | Jamaica | ||||
2021-12-31 | US | New Jersey | Ocean | 34029 | 120435 | 2477 | 0 | 39.8895449 | -74.28089251 | 2022-01-01 04:22:14 | Ocean, New Jersey, US | |
2021-11-05 | Ukraine | Khmelnytskyi Oblast | 120708 | 2477 | 0 | 49.423 | 26.9871 | 2021-11-06 04:21:51 | Khmelnytskyi Oblast, Ukraine | |||
2021-10-13 | Russia | Chuvashia Republic | 35227 | 2477 | 0 | 55.4259922 | 47.0849429 | 2021-10-14 04:21:29 | Chuvashia Republic, Russia | |||
2021-10-03 | Russia | Leningrad Oblast | 69894 | 2477 | 0 | 60.185329599999996 | 32.3925325 | 2021-10-04 04:21:31 | Leningrad Oblast, Russia | |||
2021-09-20 | Colombia | Cesar | 88776 | 2477 | 0 | 9.3373 | -73.6536 | 2021-09-21 04:21:26 | Cesar, Colombia | |||
2021-09-19 | Colombia | Cesar | 88748 | 2477 | 0 | 9.3373 | -73.6536 | 2021-09-20 04:21:22 | Cesar, Colombia | |||
2021-09-12 | Russia | Volgograd Oblast | 85896 | 2477 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-13 04:21:15 | Volgograd Oblast, Russia | |||
2021-09-11 | Malaysia | Johor | 162114 | 2477 | 130079 | 29558 | 1.4854 | 103.7618 | 2021-09-12 04:21:13 | Johor, Malaysia | ||
2021-08-30 | Kosovo | 143603 | 2477 | 0 | 42.602636 | 20.902977 | 2021-08-31 04:21:46 | Kosovo | ||||
2021-08-21 | Albania | 138790 | 2477 | 0 | 41.1533 | 20.1683 | 2021-08-22 04:21:29 | Albania | ||||
2021-08-08 | US | Michigan | Oakland | 26125 | 121411 | 2477 | 0 | 42.66090111 | -83.38595416 | 2021-08-09 04:21:24 | Oakland, Michigan, US | |
2021-08-07 | US | Michigan | Oakland | 26125 | 121411 | 2477 | 0 | 42.66090111 | -83.38595416 | 2021-08-08 04:21:33 | Oakland, Michigan, US | |
2021-08-06 | US | Michigan | Oakland | 26125 | 121411 | 2477 | 0 | 42.66090111 | -83.38595416 | 2021-08-07 04:21:30 | Oakland, Michigan, US | |
2021-08-05 | US | Michigan | Oakland | 26125 | 120770 | 2477 | 0 | 42.66090111 | -83.38595416 | 2021-08-06 04:21:18 | Oakland, Michigan, US | |
2021-08-04 | US | Michigan | Oakland | 26125 | 120770 | 2477 | 0 | 42.66090111 | -83.38595416 | 2021-08-05 04:21:51 | Oakland, Michigan, US | |
2021-08-03 | US | Michigan | Oakland | 26125 | 120770 | 2477 | 0 | 42.66090111 | -83.38595416 | 2021-08-04 04:21:25 | Oakland, Michigan, US | |
2021-07-16 | El Salvador | 82852 | 2477 | 75136 | 5239 | 13.7942 | -88.8965 | 2021-07-17 04:22:22 | El Salvador | |||
2021-06-20 | US | Michigan | Macomb | 26099 | 100094 | 2477 | 0 | 42.69158356 | -82.92752801 | 2021-06-21 04:21:41 | Macomb, Michigan, US | |
2021-06-19 | US | Michigan | Macomb | 26099 | 100094 | 2477 | 0 | 42.69158356 | -82.92752801 | 2021-06-20 04:21:48 | Macomb, Michigan, US | |
2021-06-18 | US | Michigan | Macomb | 26099 | 100094 | 2477 | 0 | 42.69158356 | -82.92752801 | 2021-06-19 04:22:33 | Macomb, Michigan, US | |
2021-06-04 | Mexico | Tlaxcala | 19974 | 2477 | 0 | 17497 | 19.3139 | -98.2404 | 2021-06-05 04:23:03 | Tlaxcala, Mexico | ||
2021-04-26 | Denmark | 248326 | 2477 | 236159 | 9690 | 56.2639 | 9.5018 | 2021-04-27 04:20:52 | Denmark | |||
2021-04-16 | Netherlands | Noord-Holland | 237852 | 2477 | 0 | 234992 | 52.60090600000001 | 4.918688 | 2021-04-17 04:20:40 | Noord-Holland, Netherlands | ||
2021-03-08 | US | Florida | Broward | 12011 | 200139 | 2477 | 0 | 26.15184651 | -80.48725556 | 2021-03-09 05:28:19 | Broward, Florida, US | |
2021-01-26 | Lebanon | 285754 | 2477 | 168749 | 114528 | 33.8547 | 35.8623 | 2021-01-27 05:23:41 | Lebanon | |||
2021-01-23 | Russia | Rostov Oblast | 60658 | 2477 | 50219 | 7962 | 47.6222451 | 40.7957942 | 2021-01-24 05:22:35 | Rostov Oblast, Russia | ||
2021-01-19 | US | California | Orange | 6059 | 233486 | 2477 | 0 | 231009 | 33.70147516 | -117.76459979999998 | 2021-01-20 05:21:54 | Orange, California, US |
2021-01-19 | Costa Rica | 186877 | 2477 | 144030 | 40370 | 9.7489 | -83.7534 | 2021-01-20 05:21:54 | Costa Rica | |||
2021-01-10 | Peru | Junin | 28763 | 2477 | 0 | 26286 | -11.541783 | -74.876968 | 2021-01-11 05:21:50 | Junin, Peru | ||
2020-12-05 | Kazakhstan | 179344 | 2477 | 151134 | 25733 | 48.0196 | 66.9237 | 2020-12-06 05:26:18 | Kazakhstan | |||
2020-12-04 | Kazakhstan | 178378 | 2477 | 150271 | 25630 | 48.0196 | 66.9237 | 2020-12-05 05:27:36 | Kazakhstan | |||
2020-12-03 | Kazakhstan | 177386 | 2477 | 149435 | 25474 | 48.0196 | 66.9237 | 2020-12-04 05:27:27 | Kazakhstan | |||
2020-12-02 | Kazakhstan | 176342 | 2477 | 148732 | 25133 | 48.0196 | 66.9237 | 2020-12-03 05:28:22 | Kazakhstan | |||
2020-12-01 | Kazakhstan | 175565 | 2477 | 148043 | 25045 | 48.0196 | 66.9237 | 2020-12-02 05:27:41 | Kazakhstan | |||
2020-11-30 | Kazakhstan | 174563 | 2477 | 147425 | 24661 | 48.0196 | 66.9237 | 2020-12-01 05:26:18 | Kazakhstan | |||
2020-11-29 | Kazakhstan | 173763 | 2477 | 146955 | 24331 | 48.0196 | 66.9237 | 2020-11-30 05:26:13 | Kazakhstan | |||
2020-10-08 | Honduras | 81672 | 2477 | 31089 | 48106 | 15.2 | -86.2419 | 2020-10-09 04:23:59 | Honduras | |||
2020-09-24 | Pakistan | Sindh | 135246 | 2477 | 129101 | 3668 | 26.009446 | 68.776807 | 2020-09-25 04:23:00 | Sindh, Pakistan | ||
2020-09-22 | Peru | Ancash | 21560 | 2477 | 0 | 19083 | -9.407125 | -77.671795 | 2020-09-23 04:23:00 | Ancash, Peru |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;