johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
100 rows where deaths = 2023 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1149154 | 1149154 | 2022-12-12 | Russia | Kaliningrad Oblast | 192232 | 2023 | 0 | 54.7293041 | 21.1489473 | 2022-12-13 04:21:01 | Kaliningrad Oblast, Russia | |||
869008 | 869008 | 2022-12-11 | Russia | Kaliningrad Oblast | 192170 | 2023 | 0 | 54.7293041 | 21.1489473 | 2022-12-12 04:21:01 | Kaliningrad Oblast, Russia | |||
257538 | 257538 | 2022-12-10 | Russia | Kaliningrad Oblast | 192081 | 2023 | 0 | 54.7293041 | 21.1489473 | 2022-12-11 04:20:50 | Kaliningrad Oblast, Russia | |||
3214841 | 3214841 | 2022-10-12 | US | California | Alameda | 6001 | 368492 | 2023 | 0 | 37.64629437 | -121.8929271 | 2022-10-13 04:22:39 | Alameda, California, US | |
3250690 | 3250690 | 2022-10-11 | US | California | Alameda | 6001 | 368483 | 2023 | 0 | 37.64629437 | -121.8929271 | 2022-10-12 04:22:51 | Alameda, California, US | |
2967949 | 2967949 | 2022-10-10 | US | California | Alameda | 6001 | 367482 | 2023 | 0 | 37.64629437 | -121.8929271 | 2022-10-11 04:23:05 | Alameda, California, US | |
3097985 | 3097985 | 2022-10-09 | US | California | Alameda | 6001 | 367460 | 2023 | 0 | 37.64629437 | -121.8929271 | 2022-10-10 04:22:32 | Alameda, California, US | |
4003210 | 4003210 | 2022-10-08 | US | California | Alameda | 6001 | 367453 | 2023 | 0 | 37.64629437 | -121.8929271 | 2022-10-09 04:21:16 | Alameda, California, US | |
396807 | 396807 | 2022-10-07 | US | California | Alameda | 6001 | 367450 | 2023 | 0 | 37.64629437 | -121.8929271 | 2022-10-08 04:22:56 | Alameda, California, US | |
2829109 | 2829109 | 2022-08-25 | Spain | Canarias | 439522 | 2023 | 0 | 28.2916 | -16.6291 | 2022-08-26 04:21:02 | Canarias, Spain | |||
2323642 | 2323642 | 2022-08-24 | Spain | Canarias | 439522 | 2023 | 0 | 28.2916 | -16.6291 | 2022-08-25 04:21:13 | Canarias, Spain | |||
1251051 | 1251051 | 2022-08-23 | Spain | Canarias | 439522 | 2023 | 0 | 28.2916 | -16.6291 | 2022-08-24 04:20:46 | Canarias, Spain | |||
3907716 | 3907716 | 2022-08-11 | Brazil | Acre | 147159 | 2023 | 0 | -9.0238 | -70.812 | 2022-08-12 04:20:54 | Acre, Brazil | |||
1506097 | 1506097 | 2022-05-16 | US | Ohio | Montgomery | 39113 | 128090 | 2023 | 0 | 39.75394919 | -84.29050975 | 2022-05-17 04:20:59 | Montgomery, Ohio, US | |
2086456 | 2086456 | 2022-05-15 | US | Ohio | Montgomery | 39113 | 128090 | 2023 | 0 | 39.75394919 | -84.29050975 | 2022-05-16 04:20:47 | Montgomery, Ohio, US | |
2083954 | 2083954 | 2022-05-15 | Japan | Hokkaido | 329440 | 2023 | 0 | 43.385711 | 142.552318 | 2022-05-16 04:20:47 | Hokkaido, Japan | |||
3357166 | 3357166 | 2022-05-14 | US | Ohio | Montgomery | 39113 | 128090 | 2023 | 0 | 39.75394919 | -84.29050975 | 2022-05-15 04:20:53 | Montgomery, Ohio, US | |
660811 | 660811 | 2022-05-13 | US | Ohio | Montgomery | 39113 | 128090 | 2023 | 0 | 39.75394919 | -84.29050975 | 2022-05-14 04:20:48 | Montgomery, Ohio, US | |
2535894 | 2535894 | 2022-05-12 | US | Ohio | Montgomery | 39113 | 128090 | 2023 | 0 | 39.75394919 | -84.29050975 | 2022-05-13 04:20:51 | Montgomery, Ohio, US | |
3447340 | 3447340 | 2022-05-11 | US | Ohio | Montgomery | 39113 | 127624 | 2023 | 0 | 39.75394919 | -84.29050975 | 2022-05-12 04:20:54 | Montgomery, Ohio, US | |
3265482 | 3265482 | 2022-05-04 | Japan | Aichi | 489899 | 2023 | 0 | 35.035551 | 137.211621 | 2022-05-05 04:20:55 | Aichi, Japan | |||
2254467 | 2254467 | 2022-04-19 | US | Texas | Cameron | 48061 | 103023 | 2023 | 0 | 26.14524221 | -97.48140372 | 2022-04-20 04:20:45 | Cameron, Texas, US | |
2734445 | 2734445 | 2022-02-27 | US | Kentucky | Jefferson | 21111 | 219531 | 2023 | 0 | 38.18664655 | -85.65931031 | 2022-02-28 04:21:05 | Jefferson, Kentucky, US | |
3047598 | 3047598 | 2022-02-26 | US | Kentucky | Jefferson | 21111 | 219531 | 2023 | 0 | 38.18664655 | -85.65931031 | 2022-02-27 04:21:04 | Jefferson, Kentucky, US | |
576253 | 576253 | 2022-02-25 | US | Kentucky | Jefferson | 21111 | 219531 | 2023 | 0 | 38.18664655 | -85.65931031 | 2022-02-26 04:21:12 | Jefferson, Kentucky, US | |
1300523 | 1300523 | 2022-02-17 | US | Ohio | Hamilton | 39061 | 184925 | 2023 | 0 | 39.19673558 | -84.54502924 | 2022-02-18 04:21:04 | Hamilton, Ohio, US | |
2642077 | 2642077 | 2022-02-14 | Sweden | Skane | 328039 | 2023 | 0 | 55.9903 | 13.5958 | 2022-02-15 04:21:09 | Skane, Sweden | |||
186394 | 186394 | 2022-02-13 | Sweden | Skane | 328039 | 2023 | 0 | 55.9903 | 13.5958 | 2022-02-14 04:20:51 | Skane, Sweden | |||
316240 | 316240 | 2022-02-12 | Sweden | Skane | 328039 | 2023 | 0 | 55.9903 | 13.5958 | 2022-02-13 04:21:00 | Skane, Sweden | |||
233566 | 233566 | 2022-02-11 | Sweden | Skane | 328039 | 2023 | 0 | 55.9903 | 13.5958 | 2022-02-12 04:21:06 | Skane, Sweden | |||
1365919 | 1365919 | 2022-02-08 | US | Wisconsin | Milwaukee | 55079 | 263555 | 2023 | 0 | 43.00486062 | -87.96733172 | 2022-02-09 04:21:04 | Milwaukee, Wisconsin, US | |
2328950 | 2328950 | 2022-02-04 | US | Maryland | Prince George's | 24033 | 167086 | 2023 | 0 | 38.83070039 | -76.8496441 | 2022-02-05 04:21:05 | Prince George's, Maryland, US | |
1779654 | 1779654 | 2022-01-27 | Russia | Zabaykalsky Krai | 99941 | 2023 | 0 | 52.248521000000004 | 115.956325 | 2022-01-28 04:21:09 | Zabaykalsky Krai, Russia | |||
1779258 | 1779258 | 2022-01-27 | Estonia | 313685 | 2023 | 0 | 58.5953 | 25.0136 | 2022-01-28 04:21:09 | Estonia | ||||
1392351 | 1392351 | 2022-01-07 | US | Pennsylvania | Montgomery | 42091 | 121302 | 2023 | 0 | 40.21053671 | -75.36652296 | 2022-01-08 04:21:53 | Montgomery, Pennsylvania, US | |
2612311 | 2612311 | 2022-01-06 | US | New York | Richmond | 36085 | 133313 | 2023 | 0 | 40.58582155 | -74.14808598 | 2022-01-07 04:22:09 | Richmond, New York, US | |
2609762 | 2609762 | 2022-01-06 | Brazil | Amapa | 127298 | 2023 | 0 | 0.902 | -52.003 | 2022-01-07 04:22:09 | Amapa, Brazil | |||
1282204 | 1282204 | 2022-01-05 | Russia | Khanty-Mansi Autonomous Okrug | 96461 | 2023 | 0 | 61.0259025 | 69.0982628 | 2022-01-06 04:22:09 | Khanty-Mansi Autonomous Okrug, Russia | |||
1281704 | 1281704 | 2022-01-05 | Brazil | Amapa | 127208 | 2023 | 0 | 0.902 | -52.003 | 2022-01-06 04:22:09 | Amapa, Brazil | |||
1285720 | 1285720 | 2022-01-04 | Brazil | Amapa | 127147 | 2023 | 0 | 0.902 | -52.003 | 2022-01-05 04:21:59 | Amapa, Brazil | |||
1700064 | 1700064 | 2022-01-03 | Brazil | Amapa | 127080 | 2023 | 0 | 0.902 | -52.003 | 2022-01-04 04:22:17 | Amapa, Brazil | |||
3998872 | 3998872 | 2021-12-30 | Russia | Kursk Oblast | 81875 | 2023 | 0 | 51.6568453 | 36.4852695 | 2021-12-31 04:21:50 | Kursk Oblast, Russia | |||
2906180 | 2906180 | 2021-12-19 | US | Ohio | Franklin | 39049 | 189085 | 2023 | 0 | 39.96995815 | -83.01115755 | 2021-12-20 04:21:43 | Franklin, Ohio, US | |
3403163 | 3403163 | 2021-11-30 | US | Minnesota | Hennepin | 27053 | 178049 | 2023 | 0 | 45.00761521 | -93.47694895 | 2021-12-01 04:22:29 | Hennepin, Minnesota, US | |
151706 | 151706 | 2021-11-29 | US | Minnesota | Hennepin | 27053 | 175783 | 2023 | 0 | 45.00761521 | -93.47694895 | 2021-11-30 04:22:53 | Hennepin, Minnesota, US | |
162230 | 162230 | 2021-11-19 | Russia | Ivanovo Oblast | 59679 | 2023 | 0 | 56.9167446 | 41.43521370000001 | 2021-11-20 04:22:17 | Ivanovo Oblast, Russia | |||
90571 | 90571 | 2021-11-09 | US | Washington | King | 53033 | 167673 | 2023 | 0 | 47.49137892 | -121.8346131 | 2021-11-10 04:21:38 | King, Washington, US | |
89304 | 89304 | 2021-11-09 | US | New Jersey | Passaic | 34031 | 82359 | 2023 | 0 | 41.03238628 | -74.29954144 | 2021-11-10 04:21:38 | Passaic, New Jersey, US | |
698595 | 698595 | 2021-11-04 | Russia | Astrakhan Oblast | 67280 | 2023 | 0 | 47.1878186 | 47.608851 | 2021-11-05 04:21:54 | Astrakhan Oblast, Russia | |||
2123477 | 2123477 | 2021-10-21 | Brazil | Roraima | 127106 | 2023 | 0 | -2.7376 | -62.0751 | 2021-10-22 04:21:14 | Roraima, Brazil | |||
1909325 | 1909325 | 2021-10-17 | Montenegro | 137769 | 2023 | 0 | 42.708678000000006 | 19.37439 | 2021-10-18 04:21:10 | Montenegro | ||||
2946996 | 2946996 | 2021-10-15 | Ukraine | Poltava Oblast | 87749 | 2023 | 0 | 49.5883 | 34.5514 | 2021-10-16 04:21:15 | Poltava Oblast, Ukraine | |||
3195596 | 3195596 | 2021-09-06 | US | Massachusetts | Essex | 25009 | 103447 | 2023 | 0 | 42.6687626 | -70.94687179 | 2021-09-07 04:21:35 | Essex, Massachusetts, US | |
3282464 | 3282464 | 2021-09-05 | US | Massachusetts | Essex | 25009 | 103447 | 2023 | 0 | 42.6687626 | -70.94687179 | 2021-09-06 04:21:22 | Essex, Massachusetts, US | |
250878 | 250878 | 2021-09-04 | US | Massachusetts | Essex | 25009 | 103447 | 2023 | 0 | 42.6687626 | -70.94687179 | 2021-09-05 04:21:33 | Essex, Massachusetts, US | |
3976159 | 3976159 | 2021-09-03 | US | Massachusetts | Essex | 25009 | 103447 | 2023 | 0 | 42.6687626 | -70.94687179 | 2021-09-04 04:21:28 | Essex, Massachusetts, US | |
179621 | 179621 | 2021-09-02 | US | Massachusetts | Essex | 25009 | 103291 | 2023 | 0 | 42.6687626 | -70.94687179 | 2021-09-03 04:21:20 | Essex, Massachusetts, US | |
178358 | 178358 | 2021-09-02 | Syria | 28174 | 2023 | 0 | 34.802075 | 38.99681500000001 | 2021-09-03 04:21:20 | Syria | ||||
1342578 | 1342578 | 2021-08-11 | Spain | Asturias | 68647 | 2023 | 0 | 43.3614 | -5.8593 | 2021-08-12 04:21:25 | Asturias, Spain | |||
2351725 | 2351725 | 2021-08-10 | Spain | Asturias | 68474 | 2023 | 0 | 43.3614 | -5.8593 | 2021-08-11 04:21:58 | Asturias, Spain | |||
1117849 | 1117849 | 2021-08-06 | Russia | Ulyanovsk Oblast | 67221 | 2023 | 0 | 54.1463177 | 47.2324921 | 2021-08-07 04:21:30 | Ulyanovsk Oblast, Russia | |||
3683543 | 3683543 | 2021-08-02 | Mexico | Nayarit | 19319 | 2023 | 0 | 17296 | 21.7514 | -104.8455 | 2021-08-03 04:21:39 | Nayarit, Mexico | ||
3331687 | 3331687 | 2021-07-21 | Peru | Ayacucho | 31482 | 2023 | 0 | 29459 | -14.091648 | -74.08344 | 2021-07-22 04:21:19 | Ayacucho, Peru | ||
2371668 | 2371668 | 2021-07-20 | Peru | Ayacucho | 31482 | 2023 | 0 | 29459 | -14.091648 | -74.08344 | 2021-07-21 04:21:40 | Ayacucho, Peru | ||
483747 | 483747 | 2021-07-19 | Peru | Ayacucho | 31482 | 2023 | 0 | 29459 | -14.091648 | -74.08344 | 2021-07-20 04:21:48 | Ayacucho, Peru | ||
2673970 | 2673970 | 2021-07-18 | Peru | Ayacucho | 31432 | 2023 | 0 | 29409 | -14.091648 | -74.08344 | 2021-07-19 04:21:24 | Ayacucho, Peru | ||
2949998 | 2949998 | 2021-07-16 | US | Pennsylvania | Allegheny | 42003 | 102882 | 2023 | 0 | 40.46809875 | -79.98167747 | 2021-07-17 04:22:22 | Allegheny, Pennsylvania, US | |
298654 | 298654 | 2021-07-15 | US | Pennsylvania | Allegheny | 42003 | 102838 | 2023 | 0 | 40.46809875 | -79.98167747 | 2021-07-16 04:21:22 | Allegheny, Pennsylvania, US | |
1893477 | 1893477 | 2021-06-30 | Thailand | 259301 | 2023 | 26873 | 230405 | 15.870032 | 100.992541 | 2021-07-01 04:21:19 | Thailand | |||
1712558 | 1712558 | 2021-06-25 | Russia | Novosibirsk Oblast | 46010 | 2023 | 41169 | 2818 | 54.9720169 | 79.48139240000002 | 2021-06-26 04:21:43 | Novosibirsk Oblast, Russia | ||
825827 | 825827 | 2021-06-06 | Russia | Samara Oblast | 65206 | 2023 | 62235 | 948 | 53.2128813 | 50.8914633 | 2021-06-07 04:22:51 | Samara Oblast, Russia | ||
605638 | 605638 | 2021-04-09 | India | Jammu and Kashmir | 136470 | 2023 | 128332 | 6115 | 33.75943 | 76.612638 | 2021-04-10 04:20:59 | Jammu and Kashmir, India | ||
3713762 | 3713762 | 2021-04-03 | Ukraine | Kharkiv Oblast | 107388 | 2023 | 86360 | 19005 | 49.9935 | 36.2304 | 2021-04-04 04:20:49 | Kharkiv Oblast, Ukraine | ||
1203858 | 1203858 | 2021-03-22 | Kenya | 122040 | 2023 | 90376 | 29641 | -0.0236 | 37.9062 | 2021-03-23 05:26:18 | Kenya | |||
1203785 | 1203785 | 2021-03-22 | Italy | Abruzzo | 62714 | 2023 | 49623 | 11068 | 42.35122196 | 13.39843823 | 2021-03-23 05:26:18 | Abruzzo, Italy | ||
1619861 | 1619861 | 2021-03-05 | Ukraine | Dnipropetrovsk Oblast | 75176 | 2023 | 68958 | 4195 | 48.4647 | 35.0462 | 2021-03-06 04:23:41 | Dnipropetrovsk Oblast, Ukraine | ||
1618405 | 1618405 | 2021-03-05 | US | New Jersey | Hudson | 34017 | 70791 | 2023 | 0 | 68768 | 40.73766234 | -74.07515667 | 2021-03-06 04:23:41 | Hudson, New Jersey, US |
2367652 | 2367652 | 2021-02-28 | Peru | Cajamarca | 32878 | 2023 | 0 | 30855 | -6.430284 | -78.74559599999998 | 2021-03-01 05:23:01 | Cajamarca, Peru | ||
2186358 | 2186358 | 2021-02-26 | US | Puerto Rico | Unassigned | 72999 | 2909 | 2023 | 0 | 886 | 18.459681 | -67.336525 | 2021-02-27 05:22:28 | Unassigned, Puerto Rico, US |
2283287 | 2283287 | 2021-02-14 | Colombia | Tolima | 64490 | 2023 | 61210 | 1257 | 4.0925 | -75.1545 | 2021-02-15 05:24:49 | Tolima, Colombia | ||
3541624 | 3541624 | 2021-02-12 | US | New Jersey | Middlesex | 34023 | 68221 | 2023 | 0 | 66198 | 40.43629879 | -74.41426991 | 2021-02-13 05:22:12 | Middlesex, New Jersey, US |
2638169 | 2638169 | 2021-02-11 | US | Arizona | Pima | 4019 | 105909 | 2023 | 0 | 103886 | 32.0971334 | -111.7890033 | 2021-02-12 05:23:29 | Pima, Arizona, US |
3515292 | 3515292 | 2021-01-15 | Ethiopia | 130326 | 2023 | 115428 | 12875 | 9.145 | 40.4897 | 2021-01-16 05:22:40 | Ethiopia | |||
2975364 | 2975364 | 2020-12-09 | North Macedonia | 69954 | 2023 | 46352 | 21579 | 41.6086 | 21.7453 | 2020-12-10 05:26:19 | North Macedonia | |||
678288 | 678288 | 2020-11-23 | Ireland | 70711 | 2023 | 23364 | 45324 | 53.1424 | -7.6921 | 2020-11-24 05:27:31 | Ireland | |||
3189964 | 3189964 | 2020-11-22 | Ireland | 70461 | 2023 | 23364 | 45074 | 53.1424 | -7.6921 | 2020-11-23 05:25:26 | Ireland | |||
2917443 | 2917443 | 2020-11-14 | US | New York | Suffolk | 36103 | 52942 | 2023 | 0 | 50919 | 40.88320119 | -72.8012172 | 2020-11-15 05:26:53 | Suffolk, New York, US |
2787265 | 2787265 | 2020-11-13 | US | New York | Suffolk | 36103 | 52493 | 2023 | 0 | 50470 | 40.88320119 | -72.8012172 | 2020-11-14 05:25:37 | Suffolk, New York, US |
867030 | 867030 | 2020-11-12 | US | New York | Suffolk | 36103 | 52065 | 2023 | 0 | 50042 | 40.88320119 | -72.8012172 | 2020-11-13 05:25:30 | Suffolk, New York, US |
3443074 | 3443074 | 2020-11-11 | US | New York | Suffolk | 36103 | 51744 | 2023 | 0 | 49721 | 40.88320119 | -72.8012172 | 2020-11-12 05:25:55 | Suffolk, New York, US |
2191923 | 2191923 | 2020-10-21 | Switzerland | 91763 | 2023 | 54600 | 35140 | 46.8182 | 8.2275 | 2020-10-22 04:24:27 | Switzerland | |||
427269 | 427269 | 2020-09-07 | Honduras | 64814 | 2023 | 13828 | 48963 | 15.2 | -86.2419 | 2020-09-08 04:28:25 | Honduras | |||
3932109 | 3932109 | 2020-08-30 | Mexico | Guanajuato | 31253 | 2023 | 26104 | 3126 | 21.019 | -101.2574 | 2020-08-31 04:28:27 | Guanajuato, Mexico | ||
1920506 | 1920506 | 2020-08-10 | Brazil | Paraiba | 90366 | 2023 | 44155 | 44188 | -7.24 | -36.782 | 2020-08-11 04:35:08 | Paraiba, Brazil | ||
3265082 | 3265082 | 2020-07-31 | Philippines | 93354 | 2023 | 65178 | 26153 | 12.879721 | 121.77401699999999 | 2020-07-30 12:35:02 | Philippines | |||
1928539 | 1928539 | 2020-07-30 | Russia | Saint Petersburg | 31302 | 2023 | 23292 | 5987 | 59.960673899999996 | 30.158655100000004 | 2020-07-31 04:35:18 | Saint Petersburg, Russia | ||
3234339 | 3234339 | 2020-07-10 | US | New Jersey | Bergen | 34003 | 20017 | 2023 | 0 | 17994 | 40.96010917 | -74.07164325 | 2020-07-11 04:34:26 | Bergen, New Jersey, US |
415597 | 415597 | 2020-07-05 | Italy | Veneto | 19326 | 2023 | 16915 | 388 | 45.43490485 | 12.33845213 | 2020-07-06 04:33:57 | Veneto, Italy | ||
530159 | 530159 | 2020-07-04 | Italy | Veneto | 19318 | 2023 | 16907 | 388 | 45.43490485 | 12.33845213 | 2020-07-05 04:33:46 | Veneto, Italy | ||
2234820 | 2234820 | 2020-07-03 | Italy | Veneto | 19314 | 2023 | 16901 | 390 | 45.43490485 | 12.33845213 | 2020-07-04 04:33:51 | Veneto, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);