daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
84 rows where deaths = 1860 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-15 | US | Colorado | El Paso | 8041 | 232085 | 1860 | 0 | 38.83240149 | -104.5251411 | 2022-12-16 04:21:01 | El Paso, Colorado, US | |
2022-12-14 | US | Colorado | El Paso | 8041 | 231986 | 1860 | 0 | 38.83240149 | -104.5251411 | 2022-12-15 04:20:58 | El Paso, Colorado, US | |
2022-12-13 | US | Colorado | El Paso | 8041 | 231658 | 1860 | 0 | 38.83240149 | -104.5251411 | 2022-12-14 04:21:04 | El Paso, Colorado, US | |
2022-10-05 | Germany | Saarland | 420530 | 1860 | 0 | 49.3964 | 7.023 | 2022-10-06 04:21:22 | Saarland, Germany | |||
2022-10-03 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-04 04:22:55 | Genesee, Michigan, US | |
2022-10-02 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-03 04:23:11 | Genesee, Michigan, US | |
2022-10-01 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-02 04:21:23 | Genesee, Michigan, US | |
2022-09-30 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-10-01 04:23:01 | Genesee, Michigan, US | |
2022-09-29 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-09-30 04:23:09 | Genesee, Michigan, US | |
2022-09-28 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-09-29 04:22:34 | Genesee, Michigan, US | |
2022-09-27 | US | Michigan | Genesee | 26049 | 117504 | 1860 | 0 | 43.02244215 | -83.70589709 | 2022-09-28 04:23:01 | Genesee, Michigan, US | |
2022-09-12 | US | Maryland | Baltimore City | 24510 | 135153 | 1860 | 0 | 39.30211911 | -76.61151012 | 2022-09-13 04:20:57 | Baltimore City, Maryland, US | |
2022-09-02 | Chile | Antofagasta | 163016 | 1860 | 0 | -23.6509 | -70.3975 | 2022-09-03 04:21:04 | Antofagasta, Chile | |||
2022-07-24 | US | Indiana | Lake | 18089 | 116864 | 1860 | 0 | 41.41874274 | -87.38277575 | 2022-07-25 04:20:51 | Lake, Indiana, US | |
2022-07-23 | US | Indiana | Lake | 18089 | 116864 | 1860 | 0 | 41.41874274 | -87.38277575 | 2022-07-24 04:20:47 | Lake, Indiana, US | |
2022-07-22 | US | Indiana | Lake | 18089 | 116864 | 1860 | 0 | 41.41874274 | -87.38277575 | 2022-07-23 04:20:53 | Lake, Indiana, US | |
2022-06-23 | Russia | Pskov Oblast | 111113 | 1860 | 0 | 57.5358729 | 28.8586826 | 2022-06-24 04:20:58 | Pskov Oblast, Russia | |||
2022-05-26 | US | California | Alameda | 6001 | 296604 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-27 04:20:56 | Alameda, California, US | |
2022-05-25 | US | California | Alameda | 6001 | 293996 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-26 04:20:50 | Alameda, California, US | |
2022-05-24 | US | California | Alameda | 6001 | 293940 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-25 04:20:56 | Alameda, California, US | |
2022-05-22 | US | California | Alameda | 6001 | 290516 | 1860 | 0 | 37.64629437 | -121.8929271 | 2022-05-26 04:20:50 | Alameda, California, US | |
2022-05-18 | US | New Mexico | Bernalillo | 35001 | 150336 | 1860 | 0 | 35.05163625 | -106.6703554 | 2022-05-19 04:20:54 | Bernalillo, New Mexico, US | |
2022-04-29 | Russia | Kabardino-Balkarian Republic | 61543 | 1860 | 0 | 43.4806048 | 43.5978976 | 2022-04-30 04:21:05 | Kabardino-Balkarian Republic, Russia | |||
2022-04-11 | Russia | Orel Oblast | 109841 | 1860 | 0 | 52.96854329999999 | 36.0692477 | 2022-04-12 04:20:49 | Orel Oblast, Russia | |||
2022-03-30 | US | Pennsylvania | Delaware | 42045 | 109673 | 1860 | 0 | 39.91680171 | -75.40243663 | 2022-03-31 04:20:56 | Delaware, Pennsylvania, US | |
2022-03-14 | US | Massachusetts | Norfolk | 25021 | 129557 | 1860 | 0 | 42.16073095 | -71.20530408 | 2022-03-15 04:20:47 | Norfolk, Massachusetts, US | |
2022-03-12 | Japan | Hokkaido | 193611 | 1860 | 0 | 43.385711 | 142.55231799999999 | 2022-03-13 04:20:49 | Hokkaido, Japan | |||
2022-01-26 | Brazil | Acre | 96532 | 1860 | 0 | -9.0238 | -70.812 | 2022-01-27 04:21:19 | Acre, Brazil | |||
2022-01-13 | US | Wisconsin | Milwaukee | 55079 | 222069 | 1860 | 0 | 43.00486062 | -87.96733172 | 2022-01-14 04:21:54 | Milwaukee, Wisconsin, US | |
2021-12-20 | Russia | Khakassia Republic | 52644 | 1860 | 0 | 53.72258845 | 91.44293627 | 2021-12-21 03:21:27 | Khakassia Republic, Russia | |||
2021-11-21 | Germany | Hamburg | 106945 | 1860 | 0 | 53.5511 | 9.9937 | 2021-11-22 04:22:20 | Hamburg, Germany | |||
2021-11-20 | Mongolia | 651951 | 1860 | 0 | 46.8625 | 103.8467 | 2021-11-21 04:22:13 | Mongolia | ||||
2021-11-20 | Germany | Hamburg | 106945 | 1860 | 0 | 53.5511 | 9.9937 | 2021-11-21 04:22:13 | Hamburg, Germany | |||
2021-11-19 | Germany | Hamburg | 106945 | 1860 | 0 | 53.5511 | 9.9937 | 2021-11-20 04:22:17 | Hamburg, Germany | |||
2021-11-15 | Ukraine | Rivne Oblast | 112806 | 1860 | 0 | 50.6199 | 26.2516 | 2021-11-16 04:21:10 | Rivne Oblast, Ukraine | |||
2021-11-12 | Ukraine | Cherkasy Oblast | 108835 | 1860 | 0 | 49.4444 | 32.0598 | 2021-11-13 04:21:38 | Cherkasy Oblast, Ukraine | |||
2021-11-09 | US | Maryland | Baltimore | 24005 | 77648 | 1860 | 0 | 39.45784712 | -76.62911955 | 2021-11-10 04:21:38 | Baltimore, Maryland, US | |
2021-11-04 | India | Puducherry | 128134 | 1860 | 0 | 11.882658000000001 | 78.86498 | 2021-11-05 04:21:54 | Puducherry, India | |||
2021-10-30 | Russia | Bryansk Oblast | 75808 | 1860 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-10-31 04:22:08 | Bryansk Oblast, Russia | |||
2021-10-21 | Russia | Smolensk Oblast | 56251 | 1860 | 0 | 55.03434960000001 | 33.0192065 | 2021-10-22 04:21:14 | Smolensk Oblast, Russia | |||
2021-10-05 | Senegal | 73806 | 1860 | 0 | 14.4974 | -14.4524 | 2021-10-06 04:21:33 | Senegal | ||||
2021-10-04 | Senegal | 73802 | 1860 | 0 | 14.4974 | -14.4524 | 2021-10-05 04:21:27 | Senegal | ||||
2021-10-03 | Senegal | 73800 | 1860 | 0 | 14.4974 | -14.4524 | 2021-10-04 04:21:31 | Senegal | ||||
2021-10-02 | Malaysia | Kedah | 136119 | 1860 | 0 | 6.1184 | 100.3685 | 2021-10-03 04:21:24 | Kedah, Malaysia | |||
2021-10-02 | India | Manipur | 120879 | 1860 | 0 | 24.738975 | 93.882541 | 2021-10-03 04:21:24 | Manipur, India | |||
2021-09-29 | Jamaica | 83486 | 1860 | 0 | 18.1096 | -77.2975 | 2021-09-30 04:21:20 | Jamaica | ||||
2021-09-16 | US | Massachusetts | Worcester | 25027 | 86561 | 1860 | 0 | 42.35026951 | -71.90493363 | 2021-09-17 04:21:46 | Worcester, Massachusetts, US | |
2021-09-08 | Ukraine | Chernivtsi Oblast | 82846 | 1860 | 0 | 48.2917 | 25.9352 | 2021-09-09 04:21:27 | Chernivtsi Oblast, Ukraine | |||
2021-08-11 | US | New York | Richmond | 36085 | 78771 | 1860 | 0 | 40.58582155 | -74.14808598 | 2021-08-12 04:21:25 | Richmond, New York, US | |
2021-08-03 | Brazil | Roraima | 120410 | 1860 | 112425 | 5969 | -2.7376 | -62.0751 | 2021-08-04 04:21:25 | Roraima, Brazil | ||
2021-07-22 | Ukraine | Mykolaiv Oblast | 70245 | 1860 | 68218 | 167 | 46.975 | 31.9946 | 2021-07-23 04:21:29 | Mykolaiv Oblast, Ukraine | ||
2021-07-21 | Ukraine | Mykolaiv Oblast | 70226 | 1860 | 68213 | 153 | 46.975 | 31.9946 | 2021-07-22 04:21:19 | Mykolaiv Oblast, Ukraine | ||
2021-07-19 | Russia | Ulyanovsk Oblast | 62512 | 1860 | 58577 | 2075 | 54.1463177 | 47.2324921 | 2021-07-20 04:21:48 | Ulyanovsk Oblast, Russia | ||
2021-07-10 | United Arab Emirates | 648702 | 1860 | 626800 | 20042 | 23.424076 | 53.847818 | 2021-07-11 04:21:43 | United Arab Emirates | |||
2021-07-03 | Ukraine | Poltava Oblast | 77909 | 1860 | 75731 | 318 | 49.5883 | 34.5514 | 2021-07-04 04:21:38 | Poltava Oblast, Ukraine | ||
2021-06-14 | Mexico | Nayarit | 12401 | 1860 | 0 | 10541 | 21.7514 | -104.8455 | 2021-06-15 04:22:22 | Nayarit, Mexico | ||
2021-06-13 | Mexico | Nayarit | 12396 | 1860 | 0 | 10536 | 21.7514 | -104.8455 | 2021-06-14 04:22:46 | Nayarit, Mexico | ||
2021-06-12 | Mexico | Nayarit | 12386 | 1860 | 0 | 10526 | 21.7514 | -104.8455 | 2021-06-13 04:22:44 | Nayarit, Mexico | ||
2021-05-06 | Korea, South | 126044 | 1860 | 116022 | 8162 | 35.90775700000001 | 127.766922 | 2021-05-07 04:20:40 | Korea, South | |||
2021-04-15 | US | Pennsylvania | Allegheny | 42003 | 93194 | 1860 | 0 | 40.46809875 | -79.98167747 | 2021-04-16 04:20:46 | Allegheny, Pennsylvania, US | |
2021-04-14 | US | Pennsylvania | Allegheny | 42003 | 92778 | 1860 | 0 | 40.46809875 | -79.98167747 | 2021-04-15 04:20:54 | Allegheny, Pennsylvania, US | |
2021-04-01 | US | New Jersey | Union | 34039 | 64600 | 1860 | 0 | 40.65835409 | -74.30680092 | 2021-04-02 04:20:36 | Union, New Jersey, US | |
2021-03-31 | US | New Jersey | Union | 34039 | 64169 | 1860 | 0 | 40.65835409 | -74.30680092 | 2021-04-01 04:27:05 | Union, New Jersey, US | |
2021-03-23 | Brazil | Tocantins | 135018 | 1860 | 114046 | 18292 | -10.1753 | -48.2982 | 2021-03-24 05:25:40 | Tocantins, Brazil | ||
2021-03-19 | Netherlands | Gelderland | 131957 | 1860 | 0 | 129922 | 52.061738 | 5.939114 | 2021-03-20 05:25:46 | Gelderland, Netherlands | ||
2021-03-09 | US | Massachusetts | Essex | 25009 | 84932 | 1860 | 0 | 42.6687626 | -70.94687179 | 2021-03-10 05:24:35 | Essex, Massachusetts, US | |
2021-03-07 | Colombia | Cordoba | 38486 | 1860 | 35608 | 1018 | 8.0493 | -75.574 | 2021-03-08 05:24:48 | Cordoba, Colombia | ||
2021-02-04 | Germany | Sachsen-Anhalt | 53358 | 1860 | 45846 | 6154 | 51.9503 | 11.6923 | 2021-02-05 05:22:38 | Sachsen-Anhalt, Germany | ||
2021-01-31 | US | Michigan | Macomb | 26099 | 55852 | 1860 | 0 | 53992 | 42.69158356 | -82.92752801 | 2021-02-01 05:22:53 | Macomb, Michigan, US |
2021-01-30 | US | Michigan | Macomb | 26099 | 55852 | 1860 | 0 | 53992 | 42.69158356 | -82.92752801 | 2021-01-31 05:22:42 | Macomb, Michigan, US |
2021-01-19 | Germany | Berlin | 113055 | 1860 | 98093 | 13873 | 52.52 | 13.405 | 2021-01-20 05:21:54 | Berlin, Germany | ||
2021-01-18 | US | Illinois | Unassigned | 90017 | 99 | 1860 | 0 | 0 | 42.36542373 | 0.0 | 2021-01-19 05:22:15 | Unassigned, Illinois, US |
2021-01-12 | US | Texas | El Paso | 48141 | 83804 | 1860 | 0 | 102225 | 31.76980765 | -106.2363275 | 2021-01-13 05:22:15 | El Paso, Texas, US |
2021-01-09 | Ukraine | Lviv Oblast | 64491 | 1860 | 49749 | 12882 | 49.8397 | 24.0297 | 2021-01-10 05:22:12 | Lviv Oblast, Ukraine | ||
2020-12-27 | US | Florida | Palm Beach | 12099 | 80239 | 1860 | 0 | 78379 | 26.64676272 | -80.46536002 | 2020-12-28 05:22:06 | Palm Beach, Florida, US |
2020-12-26 | US | Florida | Palm Beach | 12099 | 79830 | 1860 | 0 | 77970 | 26.64676272 | -80.46536002 | 2020-12-27 05:22:55 | Palm Beach, Florida, US |
2020-12-24 | India | Jammu and Kashmir | 119344 | 1860 | 113944 | 3540 | 33.75943 | 76.612638 | 2020-12-25 05:22:48 | Jammu and Kashmir, India | ||
2020-11-10 | Spain | Aragon | 64835 | 1860 | 3772 | 59203 | 41.5976 | -0.9057 | 2020-11-11 05:25:30 | Aragon, Spain | ||
2020-11-09 | Spain | Aragon | 64835 | 1860 | 3772 | 59203 | 41.5976 | -0.9057 | 2020-11-10 05:40:07 | Aragon, Spain | ||
2020-11-09 | Mexico | Quintana Roo | 13821 | 1860 | 11673 | 288 | 19.1817 | -88.4791 | 2020-11-10 05:40:07 | Quintana Roo, Mexico | ||
2020-09-12 | Portugal | 63310 | 1860 | 43894 | 17556 | 39.3999 | -8.2245 | 2020-09-13 04:30:52 | Portugal | |||
2020-09-04 | Peru | Junin | 15504 | 1860 | 0 | 13644 | -11.541783 | -74.876968 | 2020-09-05 04:28:19 | Junin, Peru | ||
2020-08-20 | Germany | Baden-Wurttemberg | 39227 | 1860 | 35788 | 1845 | 48.6616 | 9.3501 | 2020-08-21 04:27:41 | Baden-Wurttemberg, Germany | ||
2020-08-19 | Germany | Baden-Wurttemberg | 38968 | 1860 | 35704 | 1666 | 48.6616 | 9.3501 | 2020-08-20 04:27:43 | Baden-Wurttemberg, Germany |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;