daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where deaths = 2573 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-12-12 | US | New York | Richmond | 36085 | 214335 | 2573 | 0 | 40.58582155 | -74.14808598 | 2022-12-13 04:21:01 | Richmond, New York, US | |
2022-11-20 | US | Kentucky | Jefferson | 21111 | 273215 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-21 04:21:05 | Jefferson, Kentucky, US | |
2022-11-19 | US | Kentucky | Jefferson | 21111 | 273215 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-20 04:21:08 | Jefferson, Kentucky, US | |
2022-11-18 | US | Kentucky | Jefferson | 21111 | 273215 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-19 04:21:14 | Jefferson, Kentucky, US | |
2022-11-17 | US | Kentucky | Jefferson | 21111 | 273215 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-18 04:21:15 | Jefferson, Kentucky, US | |
2022-11-16 | US | Kentucky | Jefferson | 21111 | 273215 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-17 04:21:11 | Jefferson, Kentucky, US | |
2022-11-15 | US | Kentucky | Jefferson | 21111 | 273215 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-16 04:21:09 | Jefferson, Kentucky, US | |
2022-11-14 | US | Kentucky | Jefferson | 21111 | 273215 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-15 04:21:16 | Jefferson, Kentucky, US | |
2022-11-13 | US | Kentucky | Jefferson | 21111 | 272395 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-14 04:21:09 | Jefferson, Kentucky, US | |
2022-11-12 | US | Kentucky | Jefferson | 21111 | 272395 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-13 04:21:14 | Jefferson, Kentucky, US | |
2022-11-11 | US | Kentucky | Jefferson | 21111 | 272395 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-12 04:20:41 | Jefferson, Kentucky, US | |
2022-11-10 | US | Kentucky | Jefferson | 21111 | 272395 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-11 04:21:22 | Jefferson, Kentucky, US | |
2022-11-09 | US | Kentucky | Jefferson | 21111 | 272395 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-10 04:21:16 | Jefferson, Kentucky, US | |
2022-11-08 | US | Kentucky | Jefferson | 21111 | 272395 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-09 04:21:22 | Jefferson, Kentucky, US | |
2022-11-07 | US | Kentucky | Jefferson | 21111 | 272395 | 2573 | 0 | 38.18664655 | -85.65931031 | 2022-11-08 04:21:21 | Jefferson, Kentucky, US | |
2022-09-30 | Russia | Khanty-Mansi Autonomous Okrug | 242901 | 2573 | 0 | 61.0259025 | 69.0982628 | 2022-10-01 04:23:01 | Khanty-Mansi Autonomous Okrug, Russia | |||
2022-09-29 | Russia | Khanty-Mansi Autonomous Okrug | 242474 | 2573 | 0 | 61.0259025 | 69.0982628 | 2022-09-30 04:23:09 | Khanty-Mansi Autonomous Okrug, Russia | |||
2022-09-25 | Japan | Hokkaido | 735575 | 2573 | 0 | 43.385711 | 142.552318 | 2022-09-26 04:20:52 | Hokkaido, Japan | |||
2022-08-28 | Russia | Kemerovo Oblast | 177866 | 2573 | 0 | 54.5335781 | 87.342861 | 2022-08-29 04:21:06 | Kemerovo Oblast, Russia | |||
2022-08-28 | Japan | Aichi | 1179502 | 2573 | 0 | 35.035551 | 137.211621 | 2022-08-29 04:21:06 | Aichi, Japan | |||
2022-08-17 | Colombia | Meta | 106994 | 2573 | 0 | 3.272 | -73.0877 | 2022-08-18 04:21:11 | Meta, Colombia | |||
2022-08-16 | Colombia | Meta | 106994 | 2573 | 0 | 3.272 | -73.0877 | 2022-08-17 04:20:59 | Meta, Colombia | |||
2022-08-15 | Colombia | Meta | 106994 | 2573 | 0 | 3.272 | -73.0877 | 2022-08-16 04:20:58 | Meta, Colombia | |||
2022-08-14 | Colombia | Meta | 106994 | 2573 | 0 | 3.272 | -73.0877 | 2022-08-15 04:20:59 | Meta, Colombia | |||
2022-08-13 | Colombia | Meta | 106994 | 2573 | 0 | 3.272 | -73.0877 | 2022-08-14 04:20:55 | Meta, Colombia | |||
2022-08-12 | Colombia | Meta | 106994 | 2573 | 0 | 3.272 | -73.0877 | 2022-08-13 04:20:52 | Meta, Colombia | |||
2022-08-11 | Colombia | Meta | 106994 | 2573 | 0 | 3.272 | -73.0877 | 2022-08-12 04:20:54 | Meta, Colombia | |||
2022-08-08 | US | Maryland | Baltimore | 24005 | 151697 | 2573 | 0 | 39.45784712 | -76.62911955 | 2022-08-09 04:20:34 | Baltimore, Maryland, US | |
2022-04-24 | US | Massachusetts | Worcester | 25027 | 194940 | 2573 | 0 | 42.35026951 | -71.90493363 | 2022-04-25 04:20:56 | Worcester, Massachusetts, US | |
2022-04-23 | US | Massachusetts | Worcester | 25027 | 194940 | 2573 | 0 | 42.35026951 | -71.90493363 | 2022-04-24 04:20:56 | Worcester, Massachusetts, US | |
2022-04-22 | US | Massachusetts | Worcester | 25027 | 194940 | 2573 | 0 | 42.35026951 | -71.90493363 | 2022-04-23 04:20:50 | Worcester, Massachusetts, US | |
2022-04-21 | US | Massachusetts | Worcester | 25027 | 194746 | 2573 | 0 | 42.35026951 | -71.90493363 | 2022-04-22 04:20:45 | Worcester, Massachusetts, US | |
2022-04-20 | US | Massachusetts | Worcester | 25027 | 194523 | 2573 | 0 | 42.35026951 | -71.90493363 | 2022-04-21 04:20:46 | Worcester, Massachusetts, US | |
2022-03-10 | Finland | 713103 | 2573 | 0 | 61.92411 | 25.748151 | 2022-03-11 04:20:50 | Finland | ||||
2022-03-09 | Finland | 703052 | 2573 | 0 | 61.92411 | 25.748151 | 2022-03-10 04:20:48 | Finland | ||||
2022-02-07 | Malawi | 84844 | 2573 | 0 | -13.2543 | 34.3015 | 2022-02-08 04:21:15 | Malawi | ||||
2022-01-14 | Colombia | Cesar | 95867 | 2573 | 0 | 9.3373 | -73.6536 | 2022-01-15 04:21:07 | Cesar, Colombia | |||
2021-11-18 | Italy | Abruzzo | 85480 | 2573 | 0 | 42.35122196 | 13.39843823 | 2021-11-19 04:21:40 | Abruzzo, Italy | |||
2021-11-10 | Russia | Omsk Oblast | 102802 | 2573 | 0 | 56.09352629999999 | 73.5099936 | 2021-11-11 04:21:45 | Omsk Oblast, Russia | |||
2021-11-09 | Ukraine | Mykolaiv Oblast | 92866 | 2573 | 0 | 46.975 | 31.9946 | 2021-11-10 04:21:38 | Mykolaiv Oblast, Ukraine | |||
2021-10-14 | US | Connecticut | Hartford | 9003 | 96958 | 2573 | 0 | 41.80283011 | -72.73103891 | 2021-10-15 04:21:26 | Hartford, Connecticut, US | |
2021-09-18 | Russia | Volgograd Oblast | 87943 | 2573 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-09-19 04:21:34 | Volgograd Oblast, Russia | |||
2021-09-07 | Nigeria | 196487 | 2573 | 0 | 9.082 | 8.6753 | 2021-09-08 04:21:31 | Nigeria | ||||
2021-08-30 | Latvia | 142400 | 2573 | 0 | 56.8796 | 24.6032 | 2021-08-31 04:21:46 | Latvia | ||||
2021-08-29 | Latvia | 142319 | 2573 | 0 | 56.8796 | 24.6032 | 2021-08-30 04:21:23 | Latvia | ||||
2021-08-28 | Latvia | 142123 | 2573 | 0 | 56.8796 | 24.6032 | 2021-08-29 04:21:14 | Latvia | ||||
2021-08-27 | Latvia | 141867 | 2573 | 0 | 56.8796 | 24.6032 | 2021-08-28 04:21:28 | Latvia | ||||
2021-08-26 | Denmark | 341549 | 2573 | 0 | 56.2639 | 9.5018 | 2021-08-27 04:21:37 | Denmark | ||||
2021-08-16 | Russia | Tula Oblast | 49516 | 2573 | 0 | 53.9570701 | 37.369090899999996 | 2021-08-17 04:21:49 | Tula Oblast, Russia | |||
2021-08-09 | Mexico | Durango | 39155 | 2573 | 0 | 24.5593 | -104.6588 | 2021-08-10 04:21:27 | Durango, Mexico | |||
2021-08-08 | Mexico | Durango | 39105 | 2573 | 0 | 24.5593 | -104.6588 | 2021-08-09 04:21:24 | Durango, Mexico | |||
2021-08-07 | Mexico | Durango | 39048 | 2573 | 0 | 24.5593 | -104.6588 | 2021-08-08 04:21:33 | Durango, Mexico | |||
2021-05-19 | Netherlands | Noord-Holland | 268486 | 2573 | 0 | 265429 | 52.60090600000001 | 4.918688 | 2021-05-20 04:21:05 | Noord-Holland, Netherlands | ||
2021-05-01 | Brazil | Tocantins | 160685 | 2573 | 141518 | 16372 | -10.1753 | -48.2982 | 2021-05-02 04:20:48 | Tocantins, Brazil | ||
2021-04-07 | US | Texas | El Paso | 48141 | 110366 | 2573 | 0 | 31.76980765 | -106.2363275 | 2021-04-08 04:21:13 | El Paso, Texas, US | |
2021-03-16 | Ethiopia | 178108 | 2573 | 144488 | 31047 | 9.145 | 40.4897 | 2021-03-17 05:25:07 | Ethiopia | |||
2021-03-09 | Russia | Nizhny Novgorod Oblast | 100019 | 2573 | 92857 | 4589 | 55.47180329999999 | 44.0911594 | 2021-03-10 05:24:35 | Nizhny Novgorod Oblast, Russia | ||
2021-02-21 | Ukraine | Kiev | 134506 | 2573 | 91803 | 40130 | 50.4501 | 30.5234 | 2021-02-22 05:24:21 | Kiev, Ukraine | ||
2021-02-02 | Germany | Rheinland-Pfalz | 93372 | 2573 | 80660 | 10479 | 50.1183 | 7.309 | 2021-02-03 05:22:52 | Rheinland-Pfalz, Germany | ||
2021-01-21 | Lithuania | 175745 | 2573 | 148796 | 22532 | 55.1694 | 23.8813 | 2021-01-22 05:22:10 | Lithuania | |||
2021-01-06 | Italy | Puglia | 96946 | 2573 | 40345 | 54028 | 41.12559576 | 16.86736689 | 2021-01-07 05:22:03 | Puglia, Italy | ||
2020-10-26 | Brazil | Rio Grande do Norte | 80403 | 2573 | 42040 | 35305 | -5.4026 | -36.9541 | 2020-10-27 04:24:45 | Rio Grande do Norte, Brazil | ||
2020-10-12 | Peru | Ancash | 24054 | 2573 | 0 | 21481 | -9.407125 | -77.67179499999997 | 2020-10-13 04:24:02 | Ancash, Peru | ||
2020-09-01 | Brazil | Distrito Federal | 163498 | 2573 | 144413 | 16512 | -15.7998 | -47.8645 | 2020-09-02 04:28:25 | Distrito Federal, Brazil | ||
2020-06-24 | Indonesia | 49009 | 2573 | 19658 | 26778 | -0.7893 | 113.9213 | 2020-06-25 05:26:54 | Indonesia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;