johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

136 rows where deaths = 1179 sorted by day descending

✎ View and edit SQL

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
3027300 3027300 2022-11-17 US Illinois Kane 17089 156889 1179 0   41.93842729 -88.42861412 2022-11-18 04:21:15 Kane, Illinois, US
2489600 2489600 2022-11-16 US Wisconsin Waukesha 55133 133636 1179 0   43.01833055 -88.30431188 2022-11-17 04:21:11 Waukesha, Wisconsin, US
2487011 2487011 2022-11-16 US Illinois Kane 17089 156808 1179 0   41.93842729 -88.42861412 2022-11-17 04:21:11 Kane, Illinois, US
293022 293022 2022-11-15 US Illinois Kane 17089 156743 1179 0   41.93842729 -88.42861412 2022-11-16 04:21:09 Kane, Illinois, US
3598052 3598052 2022-11-14 US Illinois Kane 17089 156673 1179 0   41.93842729 -88.42861412 2022-11-15 04:21:16 Kane, Illinois, US
2509658 2509658 2022-11-10 US Wisconsin Waukesha 55133 133308 1179 0   43.01833055 -88.30431188 2022-11-11 04:21:22 Waukesha, Wisconsin, US
2828593 2828593 2022-08-25 Chile Nuble     127275 1179 0   -36.7226 -71.7622 2022-08-26 04:21:02 Nuble, Chile
2323274 2323274 2022-08-24 India Chandigarh     98526 1179 0   30.733839 76.768278 2022-08-25 04:21:13 Chandigarh, India
3951988 3951988 2022-08-17 US Louisiana Caddo 22017 78223 1179 0   32.57991587 -93.88375652 2022-08-18 04:21:11 Caddo, Louisiana, US
898597 898597 2022-07-24 US Ohio Butler 39017 100235 1179 0   39.44012838 -84.57388716 2022-07-25 04:20:51 Butler, Ohio, US
93591 93591 2022-07-23 US Ohio Butler 39017 100235 1179 0   39.44012838 -84.57388716 2022-07-24 04:20:47 Butler, Ohio, US
902613 902613 2022-07-22 US Ohio Butler 39017 100235 1179 0   39.44012838 -84.57388716 2022-07-23 04:20:53 Butler, Ohio, US
672749 672749 2022-07-21 US Ohio Butler 39017 100235 1179 0   39.44012838 -84.57388716 2022-07-22 04:21:15 Butler, Ohio, US
3507911 3507911 2022-06-05 US Arkansas Pulaski 5119 105642 1179 0   34.77054088 -92.31355101 2022-06-06 04:20:57 Pulaski, Arkansas, US
3527988 3527988 2022-06-04 US Arkansas Pulaski 5119 105580 1179 0   34.77054088 -92.31355101 2022-06-05 04:20:55 Pulaski, Arkansas, US
3134074 3134074 2022-06-03 US Arkansas Pulaski 5119 105485 1179 0   34.77054088 -92.31355101 2022-06-04 04:20:58 Pulaski, Arkansas, US
3186514 3186514 2022-05-30 US Arkansas Pulaski 5119 105056 1179 0   34.77054088 -92.31355101 2022-05-31 04:20:51 Pulaski, Arkansas, US
3198663 3198663 2022-05-29 US Arkansas Pulaski 5119 105056 1179 0   34.77054088 -92.31355101 2022-05-30 04:20:50 Pulaski, Arkansas, US
1572658 1572658 2022-05-03 US Arkansas Pulaski 5119 103515 1179 0   34.77054088 -92.31355101 2022-05-04 04:20:59 Pulaski, Arkansas, US
3869697 3869697 2022-04-05 US Nevada Washoe 32031 104346 1179 0   40.66562265 -119.6631594 2022-04-06 04:20:49 Washoe, Nevada, US
2751039 2751039 2022-04-04 US Nevada Washoe 32031 104346 1179 0   40.66562265 -119.6631594 2022-04-05 04:20:48 Washoe, Nevada, US
3732385 3732385 2022-04-03 US Nevada Washoe 32031 104346 1179 0   40.66562265 -119.6631594 2022-04-04 04:20:51 Washoe, Nevada, US
501820 501820 2022-04-02 US Nevada Washoe 32031 104346 1179 0   40.66562265 -119.6631594 2022-04-03 04:20:48 Washoe, Nevada, US
3352805 3352805 2022-04-01 US Nevada Washoe 32031 104346 1179 0   40.66562265 -119.6631594 2022-04-02 04:20:47 Washoe, Nevada, US
1542110 1542110 2022-03-31 US Nevada Washoe 32031 104346 1179 0   40.66562265 -119.6631594 2022-04-01 04:20:28 Washoe, Nevada, US
2480123 2480123 2022-03-30 US Nevada Washoe 32031 104346 1179 0   40.66562265 -119.6631594 2022-03-31 04:20:56 Washoe, Nevada, US
1907111 1907111 2022-03-22 US Missouri Jackson 29095 96094 1179 0   39.01002188 -94.34724536 2022-03-22 23:20:51 Jackson, Missouri, US
26315 26315 2022-03-20 US Missouri Jackson 29095 96094 1179 0   39.01002188 -94.34724536 2022-03-21 04:20:50 Jackson, Missouri, US
1658325 1658325 2022-03-19 US Missouri Jackson 29095 96094 1179 0   39.01002188 -94.34724536 2022-03-20 04:20:45 Jackson, Missouri, US
337851 337851 2022-03-18 US Missouri Jackson 29095 96094 1179 0   39.01002188 -94.34724536 2022-03-19 04:20:47 Jackson, Missouri, US
696304 696304 2022-03-17 US Missouri Jackson 29095 96094 1179 0   39.01002188 -94.34724536 2022-03-18 04:20:55 Jackson, Missouri, US
1298597 1298597 2022-02-17 US California Contra Costa 6013 195727 1179 0   37.91923498 -121.9289527 2022-02-18 04:21:04 Contra Costa, California, US
3820983 3820983 2022-02-16 US California Contra Costa 6013 195317 1179 0   37.91923498 -121.9289527 2022-02-17 04:20:56 Contra Costa, California, US
186671 186671 2022-02-13 US Colorado Arapahoe 8005 156472 1179 0   39.64977461 -104.3353617 2022-02-14 04:20:51 Arapahoe, Colorado, US
2327581 2327581 2022-02-04 Russia Kostroma Oblast     54441 1179 0   58.424756 44.253327299999995 2022-02-05 04:21:05 Kostroma Oblast, Russia
2327278 2327278 2022-02-04 Guyana       61108 1179 0   4.860416000000002 -58.93018000000001 2022-02-05 04:21:05 Guyana
2475300 2475300 2022-02-03 US Kansas Sedgwick 20173 140691 1179 0   37.6842718 -97.4608198 2022-02-04 04:21:10 Sedgwick, Kansas, US
460725 460725 2022-02-02 US Kansas Sedgwick 20173 140691 1179 0   37.6842718 -97.4608198 2022-02-03 04:21:21 Sedgwick, Kansas, US
2660863 2660863 2022-01-31 US Texas Denton 48121 162119 1179 0   33.20521901 -97.11691153 2022-02-01 04:21:11 Denton, Texas, US
3303280 3303280 2022-01-30 US Texas Denton 48121 160314 1179 0   33.20521901 -97.11691153 2022-01-31 04:21:09 Denton, Texas, US
1692916 1692916 2022-01-10 US Colorado Adams 8001 118197 1179 0   39.87432092 -104.3362578 2022-01-11 04:22:01 Adams, Colorado, US
733015 733015 2021-12-27 US Ohio Lucas 39095 69273 1179 0   41.62101218 -83.65468618 2021-12-28 04:21:47 Lucas, Ohio, US
3605279 3605279 2021-12-25 Russia Kaluga Oblast     64179 1179 0   54.438277299999996 35.5272854 2021-12-26 04:21:50 Kaluga Oblast, Russia
1716665 1716665 2021-12-16 Suriname       51323 1179 0   3.9193 -56.0278 2021-12-17 04:22:14 Suriname
3496499 3496499 2021-12-15 Suriname       51323 1179 0   3.9193 -56.0278 2021-12-16 04:22:11 Suriname
2089624 2089624 2021-12-14 US Michigan Kent 26081 116164 1179 0   43.03197711 -85.54934642 2021-12-15 03:22:16 Kent, Michigan, US
2088284 2088284 2021-12-14 Suriname       51289 1179 0   3.9193 -56.0278 2021-12-15 03:22:16 Suriname
785724 785724 2021-12-13 US Virginia Fairfax 51059 97678 1179 0   38.83677558 -77.27565836 2021-12-14 04:22:38 Fairfax, Virginia, US
784041 784041 2021-12-13 US Michigan Kent 26081 116164 1179 0   43.03197711 -85.54934642 2021-12-14 04:22:38 Kent, Michigan, US
554107 554107 2021-12-08 US Virginia Fairfax 51059 96647 1179 0   38.83677558 -77.27565836 2021-12-09 04:22:49 Fairfax, Virginia, US
2195679 2195679 2021-12-03 Malaysia Kelantan     158258 1179 0   6.1254 102.2381 2021-12-04 04:22:18 Kelantan, Malaysia
448882 448882 2021-11-17 US Louisiana Jefferson 22051 70092 1179 0   29.74075478 -90.11115756 2021-11-18 04:21:33 Jefferson, Louisiana, US
689007 689007 2021-11-13 US Pennsylvania Berks 42011 61463 1179 0   40.41570541 -75.92457766 2021-11-14 04:21:31 Berks, Pennsylvania, US
4475 4475 2021-10-28 Netherlands Overijssel     138448 1179 0   52.444557999999994 6.441722 2021-10-29 04:22:03 Overijssel, Netherlands
937047 937047 2021-10-16 US New York Monroe 36055 83299 1179 0   43.14638895 -77.69322942 2021-10-17 04:21:29 Monroe, New York, US
2945602 2945602 2021-10-15 US New York Monroe 36055 83033 1179 0   43.14638895 -77.69322942 2021-10-16 04:21:15 Monroe, New York, US
495278 495278 2021-10-14 Ukraine Sevastopol*     33679 1179 0   44.6054 33.522 2021-10-15 04:21:26 Sevastopol*, Ukraine
3833162 3833162 2021-10-05 US District of Columbia District of Columbia 11001 61863 1179 0   38.90417773 -77.01655992 2021-10-06 04:21:33 District of Columbia, District of Columbia ,US
987171 987171 2021-10-04 Russia Belgorod Oblast     54683 1179 0   50.7080119 37.5837615 2021-10-05 04:21:27 Belgorod Oblast, Russia
811178 811178 2021-09-20 US Massachusetts Plymouth 25023 55296 1179 0   41.94070556 -70.80802823 2021-09-21 04:21:26 Plymouth, Massachusetts, US
1816377 1816377 2021-09-19 US Massachusetts Plymouth 25023 55002 1179 0   41.94070556 -70.80802823 2021-09-20 04:21:22 Plymouth, Massachusetts, US
17957 17957 2021-09-18 US Massachusetts Plymouth 25023 55002 1179 0   41.94070556 -70.80802823 2021-09-19 04:21:34 Plymouth, Massachusetts, US
16745 16745 2021-09-18 US Alabama Mobile 1097 69989 1179 0   30.78472347 -88.20842409 2021-09-19 04:21:34 Mobile, Alabama, US
2621706 2621706 2021-09-17 Uzbekistan       167268 1179 0   41.377491 64.585262 2021-09-18 04:21:24 Uzbekistan
2619642 2619642 2021-09-17 US Massachusetts Plymouth 25023 55002 1179 0   41.94070556 -70.80802823 2021-09-18 04:21:24 Plymouth, Massachusetts, US
1385519 1385519 2021-09-13 Eswatini       44976 1179 0   -26.5225 31.4659 2021-09-14 04:21:41 Eswatini
2279369 2279369 2021-09-08 Russia Kemerovo Oblast     53066 1179 0   54.53357809999999 87.342861 2021-09-09 04:21:27 Kemerovo Oblast, Russia
3284102 3284102 2021-09-05 US Texas Travis 48453 112339 1179 0   30.33432034 -97.78535620000001 2021-09-06 04:21:22 Travis, Texas, US
2520853 2520853 2021-08-18 US Pennsylvania Lancaster 42071 57904 1179 0   40.03904563 -76.24770128 2021-08-19 04:21:15 Lancaster, Pennsylvania, US
2203829 2203829 2021-08-07 Russia Astrakhan Oblast     45386 1179 0   47.1878186 47.608851 2021-08-08 04:21:33 Astrakhan Oblast, Russia
3015264 3015264 2021-08-01 Germany Mecklenburg-Vorpommern     44415 1179 43000 279 53.6127 12.4296 2021-08-02 04:21:36 Mecklenburg-Vorpommern, Germany
3903887 3903887 2021-07-31 Germany Mecklenburg-Vorpommern     44415 1179 42990 286 53.6127 12.4296 2021-08-01 04:21:50 Mecklenburg-Vorpommern, Germany
3296092 3296092 2021-07-30 Germany Mecklenburg-Vorpommern     44415 1179 42990 268 53.6127 12.4296 2021-07-31 04:21:35 Mecklenburg-Vorpommern, Germany
1306154 1306154 2021-07-27 Jamaica       52141 1179 46892 4070 18.1096 -77.2975 2021-07-28 04:21:39 Jamaica
1712393 1712393 2021-06-25 Malawi       35388 1179 32996 1213 -13.2543 34.3015 2021-06-26 04:21:43 Malawi
1712113 1712113 2021-06-25 Chile Los Lagos     83617 1179 81265 1173 -41.9198 -72.1416 2021-06-26 04:21:43 Los Lagos, Chile
563082 563082 2021-06-22 Namibia       75766 1179 60484 14103 -22.9576 18.4904 2021-06-23 04:21:46 Namibia
3358784 3358784 2021-06-21 Namibia       75766 1179 60484 14103 -22.9576 18.4904 2021-06-22 04:21:34 Namibia
2884671 2884671 2021-06-20 Spain Navarra     63423 1179 3905 58339 42.6954 -1.6761 2021-06-21 04:21:41 Navarra, Spain
107754 107754 2021-06-19 Spain Navarra     63423 1179 3905 58339 42.6954 -1.6761 2021-06-20 04:21:48 Navarra, Spain
1125897 1125897 2021-06-18 Spain Navarra     63423 1179 3905 58339 42.6954 -1.6761 2021-06-19 04:22:33 Navarra, Spain
522846 522846 2021-06-09 Italy P.A. Bolzano     73113 1179 71419 515 46.49933453 11.35662422 2021-06-10 04:23:17 P.A. Bolzano, Italy
2585999 2585999 2021-06-05 Japan Hokkaido     39309 1179 31439 6691 43.385711 142.552318 2021-06-06 04:24:03 Hokkaido, Japan
2315282 2315282 2021-06-04 Italy Calabria     67454 1179 57170 9105 38.90597598 16.59440194 2021-06-05 04:23:03 Calabria, Italy
1711946 1711946 2021-06-02 Ukraine Rivne Oblast     78433 1179 75237 2017 50.6199 26.2516 2021-06-03 04:23:32 Rivne Oblast, Ukraine
2104935 2104935 2021-06-01 US Georgia Gwinnett 13135 102594 1179 0   33.96044201 -84.02137802 2021-06-02 04:24:34 Gwinnett, Georgia, US
1192383 1192383 2021-05-31 Ukraine Ternopil Oblast     69463 1179 65889 2395 49.5535 25.5948 2021-06-01 04:23:09 Ternopil Oblast, Ukraine
1189551 1189551 2021-05-31 US Georgia Gwinnett 13135 102567 1179 0   33.96044201 -84.02137802 2021-06-01 04:23:09 Gwinnett, Georgia, US
3090228 3090228 2021-05-30 US Georgia Gwinnett 13135 102545 1179 0   33.96044201 -84.02137802 2021-05-31 03:08:59 Gwinnett, Georgia, US
51597 51597 2021-05-29 US Georgia Gwinnett 13135 102519 1179 0   33.96044201 -84.02137802 2021-05-30 04:20:55 Gwinnett, Georgia, US
3574558 3574558 2021-05-17 India Puducherry     85952 1179 67390 17383 11.882658 78.86498 2021-05-18 04:20:33 Puducherry, India
3054416 3054416 2021-05-13 Russia Murmansk Oblast     50630 1179 47887 1564 68.00004179999999 33.9999151 2021-05-14 04:20:41 Murmansk Oblast, Russia
3958128 3958128 2021-05-11 Ukraine Sumy Oblast     74593 1179 68087 5327 50.9077 34.7981 2021-05-12 04:21:29 Sumy Oblast, Ukraine
647364 647364 2021-05-05 US Kentucky Jefferson 21111 79913 1179 0   38.18664655 -85.65931031 2021-05-06 04:20:38 Jefferson, Kentucky, US
3675734 3675734 2021-05-04 Mexico Colima     11348 1179 0 10169 19.1223 -104.0072 2021-05-05 04:20:43 Colima, Mexico
2761001 2761001 2021-05-03 Mexico Colima     11320 1179 0 10141 19.1223 -104.0072 2021-05-04 04:20:34 Colima, Mexico
2571516 2571516 2021-04-13 Colombia Boyaca     49226 1179 47107 940 5.4545 -73.362 2021-04-14 04:20:41 Boyaca, Colombia
36267 36267 2021-04-12 Colombia Boyaca     49226 1179 47107 940 5.4545 -73.362 2021-04-13 04:20:37 Boyaca, Colombia
2647346 2647346 2021-04-08 US Massachusetts Hampden 25013 47229 1179 0   42.13440424 -72.63235561 2021-04-09 04:21:13 Hampden, Massachusetts, US
3087469 3087469 2021-04-05 US New Jersey Morris 34027 46036 1179 0   40.86095313 -74.54553709999998 2021-04-06 04:20:32 Morris, New Jersey, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);