daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
97 rows where deaths = 1876 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-10-16 | US | Maryland | Baltimore City | 24510 | 137785 | 1876 | 0 | 39.30211911 | -76.61151012 | 2022-10-17 04:20:31 | Baltimore City, Maryland, US | |
2022-10-15 | US | Maryland | Baltimore City | 24510 | 137785 | 1876 | 0 | 39.30211911 | -76.61151012 | 2022-10-16 04:22:39 | Baltimore City, Maryland, US | |
2022-10-14 | US | Maryland | Baltimore City | 24510 | 137785 | 1876 | 0 | 39.30211911 | -76.61151012 | 2022-10-15 04:22:00 | Baltimore City, Maryland, US | |
2022-08-24 | US | Oklahoma | Unassigned | 90040 | 9421 | 1876 | 0 | 36.83532655 | 0.0 | 2022-08-25 04:21:13 | Unassigned, Oklahoma, US | |
2022-08-23 | US | Oklahoma | Unassigned | 90040 | 9421 | 1876 | 0 | 36.83532655 | 0.0 | 2022-08-24 04:20:46 | Unassigned, Oklahoma, US | |
2022-08-22 | US | Oklahoma | Unassigned | 90040 | 6476 | 1876 | 0 | 36.83532655 | 0.0 | 2022-08-23 04:20:56 | Unassigned, Oklahoma, US | |
2022-08-21 | US | Oklahoma | Unassigned | 90040 | 3380 | 1876 | 0 | 36.83532655 | 0.0 | 2022-08-22 04:20:38 | Unassigned, Oklahoma, US | |
2022-08-20 | US | Oklahoma | Unassigned | 90040 | 3380 | 1876 | 0 | 36.83532655 | 0.0 | 2022-08-21 04:20:44 | Unassigned, Oklahoma, US | |
2022-08-19 | US | Oklahoma | Unassigned | 90040 | 3380 | 1876 | 0 | 36.83532655 | 0.0 | 2022-08-20 04:21:01 | Unassigned, Oklahoma, US | |
2022-08-19 | US | New Jersey | Camden | 34007 | 148110 | 1876 | 0 | 39.80343818 | -74.96388753 | 2022-08-20 04:21:01 | Camden, New Jersey, US | |
2022-08-18 | US | Oklahoma | Unassigned | 90040 | 3380 | 1876 | 0 | 36.83532655 | 0.0 | 2022-08-19 04:20:54 | Unassigned, Oklahoma, US | |
2022-08-14 | US | New Jersey | Camden | 34007 | 147386 | 1876 | 0 | 39.80343818 | -74.96388753 | 2022-08-15 04:20:59 | Camden, New Jersey, US | |
2022-08-13 | US | New Jersey | Camden | 34007 | 147263 | 1876 | 0 | 39.80343818 | -74.96388753 | 2022-08-14 04:20:55 | Camden, New Jersey, US | |
2022-08-12 | US | New Jersey | Camden | 34007 | 147096 | 1876 | 0 | 39.80343818 | -74.96388753 | 2022-08-13 04:20:52 | Camden, New Jersey, US | |
2022-08-10 | US | Massachusetts | Hampden | 25013 | 151178 | 1876 | 0 | 42.13440424 | -72.63235561 | 2022-08-11 04:20:49 | Hampden, Massachusetts, US | |
2022-08-09 | US | Massachusetts | Hampden | 25013 | 151178 | 1876 | 0 | 42.13440424 | -72.63235561 | 2022-08-10 04:20:57 | Hampden, Massachusetts, US | |
2022-08-08 | US | Massachusetts | Hampden | 25013 | 151178 | 1876 | 0 | 42.13440424 | -72.63235561 | 2022-08-09 04:20:34 | Hampden, Massachusetts, US | |
2022-08-07 | US | Massachusetts | Hampden | 25013 | 151178 | 1876 | 0 | 42.13440424 | -72.63235561 | 2022-08-08 04:21:08 | Hampden, Massachusetts, US | |
2022-08-06 | US | Massachusetts | Hampden | 25013 | 151178 | 1876 | 0 | 42.13440424 | -72.63235561 | 2022-08-07 04:20:54 | Hampden, Massachusetts, US | |
2022-08-05 | US | Massachusetts | Hampden | 25013 | 151178 | 1876 | 0 | 42.13440424 | -72.63235561 | 2022-08-06 04:20:56 | Hampden, Massachusetts, US | |
2022-08-04 | US | Massachusetts | Hampden | 25013 | 151178 | 1876 | 0 | 42.13440424 | -72.63235561 | 2022-08-05 04:20:52 | Hampden, Massachusetts, US | |
2022-07-21 | Russia | Pskov Oblast | 111646 | 1876 | 0 | 57.5358729 | 28.8586826 | 2022-07-22 04:21:15 | Pskov Oblast, Russia | |||
2022-05-03 | US | Georgia | Gwinnett | 13135 | 208764 | 1876 | 0 | 33.96044201 | -84.02137802 | 2022-05-04 04:20:59 | Gwinnett, Georgia, US | |
2022-05-02 | US | Georgia | Gwinnett | 13135 | 208764 | 1876 | 0 | 33.96044201 | -84.02137802 | 2022-05-03 04:21:00 | Gwinnett, Georgia, US | |
2022-05-01 | US | Georgia | Gwinnett | 13135 | 208764 | 1876 | 0 | 33.96044201 | -84.02137802 | 2022-05-02 04:21:10 | Gwinnett, Georgia, US | |
2022-04-30 | US | Georgia | Gwinnett | 13135 | 208764 | 1876 | 0 | 33.96044201 | -84.02137802 | 2022-05-01 04:20:57 | Gwinnett, Georgia, US | |
2022-04-29 | US | Georgia | Gwinnett | 13135 | 208764 | 1876 | 0 | 33.96044201 | -84.02137802 | 2022-04-30 04:21:05 | Gwinnett, Georgia, US | |
2022-04-28 | US | Georgia | Gwinnett | 13135 | 208764 | 1876 | 0 | 33.96044201 | -84.02137802 | 2022-04-29 04:20:59 | Gwinnett, Georgia, US | |
2022-04-27 | US | Georgia | Gwinnett | 13135 | 208764 | 1876 | 0 | 33.96044201 | -84.02137802 | 2022-04-28 04:20:47 | Gwinnett, Georgia, US | |
2022-03-31 | US | Pennsylvania | Lancaster | 42071 | 120748 | 1876 | 0 | 40.03904563 | -76.24770128 | 2022-04-01 04:20:28 | Lancaster, Pennsylvania, US | |
2022-03-30 | US | Pennsylvania | Lancaster | 42071 | 120723 | 1876 | 0 | 40.03904563 | -76.24770128 | 2022-03-31 04:20:56 | Lancaster, Pennsylvania, US | |
2022-03-19 | Chile | Araucania | 206075 | 1876 | 0 | -38.9489 | -72.3311 | 2022-03-20 04:20:45 | Araucania, Chile | |||
2022-01-13 | Spain | Murcia | 237228 | 1876 | 0 | 37.9922 | -1.1307 | 2022-01-14 04:21:54 | Murcia, Spain | |||
2022-01-12 | Spain | Murcia | 230110 | 1876 | 0 | 37.9922 | -1.1307 | 2022-01-13 08:00:09 | Murcia, Spain | |||
2021-12-28 | US | California | San Joaquin | 6077 | 111506 | 1876 | 0 | 37.93433732 | -121.2730061 | 2021-12-29 03:21:43 | San Joaquin, California, US | |
2021-12-23 | US | Georgia | Fulton | 13121 | 144176 | 1876 | 0 | 33.79216944 | -84.46319413 | 2021-12-24 04:21:34 | Fulton, Georgia, US | |
2021-12-08 | India | Puducherry | 129128 | 1876 | 0 | 11.882658000000001 | 78.86498 | 2021-12-09 04:22:49 | Puducherry, India | |||
2021-12-07 | India | Puducherry | 129105 | 1876 | 0 | 11.882658000000001 | 78.86498 | 2021-12-08 04:22:46 | Puducherry, India | |||
2021-11-24 | Germany | Hamburg | 109881 | 1876 | 0 | 53.5511 | 9.9937 | 2021-11-25 04:22:33 | Hamburg, Germany | |||
2021-11-23 | Ukraine | Volyn Oblast | 90511 | 1876 | 0 | 50.7472 | 25.3254 | 2021-11-24 04:22:14 | Volyn Oblast, Ukraine | |||
2021-11-15 | US | Ohio | Franklin | 39049 | 170832 | 1876 | 0 | 39.96995815 | -83.01115755 | 2021-11-16 04:21:10 | Franklin, Ohio, US | |
2021-11-13 | US | Pennsylvania | Montgomery | 42091 | 88756 | 1876 | 0 | 40.21053671 | -75.36652296 | 2021-11-14 04:21:31 | Montgomery, Pennsylvania, US | |
2021-11-05 | Russia | Tver Oblast | 78682 | 1876 | 0 | 57.1134475 | 35.174442799999994 | 2021-11-06 04:21:51 | Tver Oblast, Russia | |||
2021-10-31 | Russia | Bryansk Oblast | 76302 | 1876 | 0 | 52.887331499999995 | 33.41585300000001 | 2021-11-01 04:22:01 | Bryansk Oblast, Russia | |||
2021-10-22 | Senegal | 73880 | 1876 | 0 | 14.4974 | -14.4524 | 2021-10-23 04:21:32 | Senegal | ||||
2021-10-21 | Senegal | 73876 | 1876 | 0 | 14.4974 | -14.4524 | 2021-10-22 04:21:14 | Senegal | ||||
2021-10-09 | Russia | Buryatia Republic | 59795 | 1876 | 0 | 52.718242599999996 | 109.492143 | 2021-10-10 04:21:38 | Buryatia Republic, Russia | |||
2021-10-07 | India | Manipur | 121578 | 1876 | 0 | 24.738975 | 93.882541 | 2021-10-08 04:21:25 | Manipur, India | |||
2021-10-04 | Malaysia | Kedah | 137417 | 1876 | 0 | 6.1184 | 100.3685 | 2021-10-05 04:21:27 | Kedah, Malaysia | |||
2021-09-27 | US | Massachusetts | Worcester | 25027 | 89276 | 1876 | 0 | 42.35026951 | -71.90493363 | 2021-09-28 04:21:28 | Worcester, Massachusetts, US | |
2021-09-27 | Mexico | Colima | 31335 | 1876 | 0 | 19.1223 | -104.0072 | 2021-09-28 04:21:28 | Colima, Mexico | |||
2021-09-26 | US | Massachusetts | Worcester | 25027 | 88580 | 1876 | 0 | 42.35026951 | -71.90493363 | 2021-09-27 04:21:16 | Worcester, Massachusetts, US | |
2021-09-25 | US | Massachusetts | Worcester | 25027 | 88580 | 1876 | 0 | 42.35026951 | -71.90493363 | 2021-09-26 04:21:29 | Worcester, Massachusetts, US | |
2021-09-18 | US | New York | Erie | 36029 | 98209 | 1876 | 0 | 42.76249024 | -78.73063652 | 2021-09-19 04:21:34 | Erie, New York, US | |
2021-08-25 | US | New York | Richmond | 36085 | 81173 | 1876 | 0 | 40.58582155 | -74.14808598 | 2021-08-26 04:21:28 | Richmond, New York, US | |
2021-08-23 | Ukraine | Poltava Oblast | 78828 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-24 04:21:19 | Poltava Oblast, Ukraine | |||
2021-08-22 | Ukraine | Poltava Oblast | 78818 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-23 04:21:27 | Poltava Oblast, Ukraine | |||
2021-08-21 | Ukraine | Poltava Oblast | 78798 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-22 04:21:29 | Poltava Oblast, Ukraine | |||
2021-08-20 | Ukraine | Poltava Oblast | 78765 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-21 04:21:38 | Poltava Oblast, Ukraine | |||
2021-08-19 | Ukraine | Poltava Oblast | 78709 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-20 04:21:33 | Poltava Oblast, Ukraine | |||
2021-08-19 | Ukraine | Mykolaiv Oblast | 70743 | 1876 | 0 | 46.975 | 31.9946 | 2021-08-20 04:21:33 | Mykolaiv Oblast, Ukraine | |||
2021-08-18 | Ukraine | Poltava Oblast | 78671 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-19 04:21:15 | Poltava Oblast, Ukraine | |||
2021-08-17 | Ukraine | Poltava Oblast | 78627 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-18 04:21:35 | Poltava Oblast, Ukraine | |||
2021-08-16 | Ukraine | Poltava Oblast | 78617 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-17 04:21:49 | Poltava Oblast, Ukraine | |||
2021-08-15 | Ukraine | Poltava Oblast | 78610 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-16 04:21:31 | Poltava Oblast, Ukraine | |||
2021-08-14 | Ukraine | Poltava Oblast | 78602 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-15 04:21:41 | Poltava Oblast, Ukraine | |||
2021-08-13 | Ukraine | Poltava Oblast | 78572 | 1876 | 0 | 49.5883 | 34.5514 | 2021-08-14 04:21:25 | Poltava Oblast, Ukraine | |||
2021-07-30 | Russia | Stavropol Krai | 64282 | 1876 | 56503 | 5903 | 44.86325770000001 | 43.4406913 | 2021-07-31 04:21:35 | Stavropol Krai, Russia | ||
2021-07-15 | Brazil | Amapa | 119427 | 1876 | 100523 | 17028 | 0.902 | -52.003 | 2021-07-16 04:21:22 | Amapa, Brazil | ||
2021-07-13 | United Arab Emirates | 653284 | 1876 | 631294 | 20114 | 23.424076 | 53.847818 | 2021-07-14 04:21:35 | United Arab Emirates | |||
2021-07-10 | Russia | Chelyabinsk Oblast | 67169 | 1876 | 62345 | 2948 | 54.4223954 | 61.1865846 | 2021-07-11 04:21:43 | Chelyabinsk Oblast, Russia | ||
2021-07-03 | Ukraine | Khmelnytskyi Oblast | 88950 | 1876 | 86586 | 488 | 49.423 | 26.9871 | 2021-07-04 04:21:38 | Khmelnytskyi Oblast, Ukraine | ||
2021-07-03 | Colombia | Caldas | 90474 | 1876 | 85606 | 2992 | 5.2983 | -75.2479 | 2021-07-04 04:21:38 | Caldas, Colombia | ||
2021-07-02 | Colombia | Risaralda | 76718 | 1876 | 72102 | 2740 | 5.3158 | -75.9928 | 2021-07-03 04:21:37 | Risaralda, Colombia | ||
2021-06-30 | Syria | 25515 | 1876 | 21825 | 1814 | 34.802075 | 38.99681500000001 | 2021-07-01 04:21:19 | Syria | |||
2021-06-11 | Kyrgyzstan | 109193 | 1876 | 102018 | 5299 | 41.20438 | 74.766098 | 2021-06-12 04:22:22 | Kyrgyzstan | |||
2021-05-05 | Colombia | Huila | 54237 | 1876 | 51711 | 650 | 2.5359 | -75.5277 | 2021-05-06 04:20:38 | Huila, Colombia | ||
2021-05-03 | Russia | Tula Oblast | 38665 | 1876 | 36248 | 541 | 53.9570701 | 37.3690909 | 2021-05-04 04:20:34 | Tula Oblast, Russia | ||
2021-04-26 | Japan | Tokyo | 135578 | 1876 | 127263 | 6439 | 35.711343 | 139.446921 | 2021-04-27 04:20:52 | Tokyo, Japan | ||
2021-04-25 | Japan | Tokyo | 135153 | 1876 | 126617 | 6660 | 35.711343 | 139.446921 | 2021-04-26 04:21:04 | Tokyo, Japan | ||
2021-04-20 | India | Telangana | 367901 | 1876 | 319537 | 46488 | 18.1124 | 79.0193 | 2021-04-21 04:21:14 | Telangana, India | ||
2021-04-10 | Ukraine | Kiev Oblast | 105585 | 1876 | 83025 | 20684 | 50.053 | 30.7667 | 2021-04-11 04:20:56 | Kiev Oblast, Ukraine | ||
2021-03-23 | Netherlands | Gelderland | 134739 | 1876 | 0 | 132671 | 52.061738 | 5.939114 | 2021-03-24 05:25:40 | Gelderland, Netherlands | ||
2021-03-21 | US | Massachusetts | Essex | 25009 | 87224 | 1876 | 0 | 42.6687626 | -70.94687179 | 2021-03-22 05:25:43 | Essex, Massachusetts, US | |
2021-03-13 | Russia | Irkutsk Oblast | 58345 | 1876 | 56243 | 226 | 56.6370122 | 104.719221 | 2021-03-14 05:25:37 | Irkutsk Oblast, Russia | ||
2021-03-07 | Kenya | 108827 | 1876 | 87570 | 19381 | -0.0236 | 37.9062 | 2021-03-08 05:24:48 | Kenya | |||
2021-03-04 | Albania | 110521 | 1876 | 72853 | 35792 | 41.1533 | 20.1683 | 2021-03-05 05:26:29 | Albania | |||
2021-03-01 | Peru | Ucayali | 22636 | 1876 | 0 | 20760 | -9.621718 | -73.444929 | 2021-03-02 05:23:30 | Ucayali, Peru | ||
2021-02-24 | Sudan | 30236 | 1876 | 22823 | 5537 | 12.8628 | 30.2176 | 2021-02-25 05:24:57 | Sudan | |||
2021-02-23 | Sudan | 30205 | 1876 | 22823 | 5506 | 12.8628 | 30.2176 | 2021-02-24 05:29:16 | Sudan | |||
2021-02-17 | Belarus | 272273 | 1876 | 261568 | 8829 | 53.7098 | 27.9534 | 2021-02-18 05:22:58 | Belarus | |||
2021-02-02 | Mexico | Morelos | 19348 | 1876 | 0 | 17472 | 18.6813 | -99.1013 | 2021-02-03 05:22:52 | Morelos, Mexico | ||
2021-01-09 | Italy | Friuli Venezia Giulia | 55591 | 1876 | 40825 | 12890 | 45.6494354 | 13.76813649 | 2021-01-10 05:22:12 | Friuli Venezia Giulia, Italy | ||
2021-01-01 | India | Odisha | 329866 | 1876 | 325432 | 2558 | 20.505428 | 84.418059 | 2021-01-02 05:22:33 | Odisha, India | ||
2020-09-25 | Germany | Baden-Wurttemberg | 48135 | 1876 | 42635 | 3946 | 48.6616 | 9.3501 | 2020-09-26 04:23:00 | Baden-Wurttemberg, Germany | ||
2020-08-01 | Brazil | Mato Grosso | 53151 | 1876 | 32149 | 18792 | -12.6819 | -56.9211 | 2020-08-02 04:34:47 | Mato Grosso, Brazil | ||
2020-07-31 | Brazil | Rio Grande do Sul | 66692 | 1876 | 57655 | 7161 | -30.0346 | -51.2177 | 2020-08-01 04:36:27 | Rio Grande do Sul, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;