johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
404 rows where deaths = 593 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755128 | 2755128 | 2022-12-29 | US | New York | Albany | 36001 | 76725 | 593 | 0 | 42.60060306 | -73.97723916 | 2022-12-30 04:21:04 | Albany, New York, US | |
1076134 | 1076134 | 2022-12-28 | US | New York | Albany | 36001 | 76680 | 593 | 0 | 42.60060306 | -73.97723916 | 2022-12-29 04:21:01 | Albany, New York, US | |
1073911 | 1073911 | 2022-12-28 | Japan | Kagoshima | 359642 | 593 | 0 | 31.009484 | 130.430665 | 2022-12-29 04:21:01 | Kagoshima, Japan | |||
2556581 | 2556581 | 2022-11-29 | Japan | Gunma | 297267 | 593 | 0 | 36.504479 | 138.985605 | 2022-11-30 04:21:07 | Gunma, Japan | |||
1623816 | 1623816 | 2022-11-22 | US | Wisconsin | Dane | 55025 | 170776 | 593 | 0 | 43.06601594 | -89.41733797 | 2022-11-23 04:21:06 | Dane, Wisconsin, US | |
1621374 | 1621374 | 2022-11-22 | US | Indiana | Hendricks | 18063 | 45757 | 593 | 0 | 39.76719009 | -86.51037283 | 2022-11-23 04:21:06 | Hendricks, Indiana, US | |
3463704 | 3463704 | 2022-11-21 | US | Wisconsin | Dane | 55025 | 170674 | 593 | 0 | 43.06601594 | -89.41733797 | 2022-11-22 04:20:47 | Dane, Wisconsin, US | |
3461262 | 3461262 | 2022-11-21 | US | Indiana | Hendricks | 18063 | 45757 | 593 | 0 | 39.76719009 | -86.51037283 | 2022-11-22 04:20:47 | Hendricks, Indiana, US | |
1641447 | 1641447 | 2022-11-20 | US | Indiana | Hendricks | 18063 | 45757 | 593 | 0 | 39.76719009 | -86.51037283 | 2022-11-21 04:21:05 | Hendricks, Indiana, US | |
2065004 | 2065004 | 2022-11-19 | US | Indiana | Hendricks | 18063 | 45757 | 593 | 0 | 39.76719009 | -86.51037283 | 2022-11-20 04:21:08 | Hendricks, Indiana, US | |
1756398 | 1756398 | 2022-11-18 | US | Indiana | Hendricks | 18063 | 45757 | 593 | 0 | 39.76719009 | -86.51037283 | 2022-11-19 04:21:14 | Hendricks, Indiana, US | |
3027391 | 3027391 | 2022-11-17 | US | Indiana | Hendricks | 18063 | 45757 | 593 | 0 | 39.76719009 | -86.51037283 | 2022-11-18 04:21:15 | Hendricks, Indiana, US | |
2487102 | 2487102 | 2022-11-16 | US | Indiana | Hendricks | 18063 | 45757 | 593 | 0 | 39.76719009 | -86.51037283 | 2022-11-17 04:21:11 | Hendricks, Indiana, US | |
480723 | 480723 | 2022-11-08 | US | Indiana | Porter | 18127 | 44953 | 593 | 0 | 41.45986947 | -87.06848888 | 2022-11-09 04:21:22 | Porter, Indiana, US | |
2439873 | 2439873 | 2022-11-07 | US | Indiana | Porter | 18127 | 44953 | 593 | 0 | 41.45986947 | -87.06848888 | 2022-11-08 04:21:21 | Porter, Indiana, US | |
1050971 | 1050971 | 2022-11-06 | US | Indiana | Porter | 18127 | 44953 | 593 | 0 | 41.45986947 | -87.06848888 | 2022-11-07 04:21:26 | Porter, Indiana, US | |
618995 | 618995 | 2022-11-05 | US | Indiana | Porter | 18127 | 44953 | 593 | 0 | 41.45986947 | -87.06848888 | 2022-11-06 04:21:24 | Porter, Indiana, US | |
1023499 | 1023499 | 2022-11-04 | US | Indiana | Porter | 18127 | 44953 | 593 | 0 | 41.45986947 | -87.06848888 | 2022-11-05 04:21:52 | Porter, Indiana, US | |
432490 | 432490 | 2022-11-03 | US | Indiana | Porter | 18127 | 44953 | 593 | 0 | 41.45986947 | -87.06848888 | 2022-11-04 04:22:11 | Porter, Indiana, US | |
850732 | 850732 | 2022-11-02 | US | Indiana | Porter | 18127 | 44953 | 593 | 0 | 41.45986947 | -87.06848888 | 2022-11-03 04:22:05 | Porter, Indiana, US | |
3286597 | 3286597 | 2022-10-31 | US | Michigan | Washtenaw | 26161 | 102356 | 593 | 0 | 42.253105 | -83.83853204 | 2022-11-01 04:22:36 | Washtenaw, Michigan, US | |
321630 | 321630 | 2022-10-30 | US | Michigan | Washtenaw | 26161 | 102356 | 593 | 0 | 42.253105 | -83.83853204 | 2022-10-31 04:21:36 | Washtenaw, Michigan, US | |
913906 | 913906 | 2022-10-29 | US | Michigan | Washtenaw | 26161 | 102356 | 593 | 0 | 42.253105 | -83.83853204 | 2022-10-30 04:22:14 | Washtenaw, Michigan, US | |
1368175 | 1368175 | 2022-10-28 | US | Michigan | Washtenaw | 26161 | 102356 | 593 | 0 | 42.253105 | -83.83853204 | 2022-10-29 04:21:13 | Washtenaw, Michigan, US | |
3040030 | 3040030 | 2022-10-27 | US | Michigan | Washtenaw | 26161 | 102356 | 593 | 0 | 42.253105 | -83.83853204 | 2022-10-28 04:22:31 | Washtenaw, Michigan, US | |
540450 | 540450 | 2022-10-26 | US | Michigan | Washtenaw | 26161 | 102356 | 593 | 0 | 42.253105 | -83.83853204 | 2022-10-27 04:22:01 | Washtenaw, Michigan, US | |
1831851 | 1831851 | 2022-10-25 | US | Michigan | Washtenaw | 26161 | 102356 | 593 | 0 | 42.253105 | -83.83853204 | 2022-10-26 04:22:19 | Washtenaw, Michigan, US | |
2161696 | 2161696 | 2022-10-16 | US | New Hampshire | Rockingham | 33015 | 79093 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-17 04:20:31 | Rockingham, New Hampshire, US | |
517893 | 517893 | 2022-10-15 | US | New Hampshire | Rockingham | 33015 | 79093 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-16 04:22:39 | Rockingham, New Hampshire, US | |
2034950 | 2034950 | 2022-10-14 | US | New Hampshire | Rockingham | 33015 | 79093 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-15 04:22:00 | Rockingham, New Hampshire, US | |
3757008 | 3757008 | 2022-10-13 | US | Wisconsin | Brown | 55009 | 97583 | 593 | 0 | 44.4526553 | -88.00411844 | 2022-10-14 04:22:28 | Brown, Wisconsin, US | |
3755930 | 3755930 | 2022-10-13 | US | Ohio | Clermont | 39025 | 61020 | 593 | 0 | 39.04847534 | -84.15375786 | 2022-10-14 04:22:28 | Clermont, Ohio, US | |
3755638 | 3755638 | 2022-10-13 | US | New Hampshire | Rockingham | 33015 | 79058 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-14 04:22:28 | Rockingham, New Hampshire, US | |
3217833 | 3217833 | 2022-10-12 | US | Wisconsin | Brown | 55009 | 97544 | 593 | 0 | 44.4526553 | -88.00411844 | 2022-10-13 04:22:39 | Brown, Wisconsin, US | |
3216755 | 3216755 | 2022-10-12 | US | Ohio | Clermont | 39025 | 60843 | 593 | 0 | 39.04847534 | -84.15375786 | 2022-10-13 04:22:39 | Clermont, Ohio, US | |
3216463 | 3216463 | 2022-10-12 | US | New Hampshire | Rockingham | 33015 | 79007 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-13 04:22:39 | Rockingham, New Hampshire, US | |
3253682 | 3253682 | 2022-10-11 | US | Wisconsin | Brown | 55009 | 97477 | 593 | 0 | 44.4526553 | -88.00411844 | 2022-10-12 04:22:51 | Brown, Wisconsin, US | |
3252604 | 3252604 | 2022-10-11 | US | Ohio | Clermont | 39025 | 60843 | 593 | 0 | 39.04847534 | -84.15375786 | 2022-10-12 04:22:51 | Clermont, Ohio, US | |
3252312 | 3252312 | 2022-10-11 | US | New Hampshire | Rockingham | 33015 | 78972 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-12 04:22:51 | Rockingham, New Hampshire, US | |
2970941 | 2970941 | 2022-10-10 | US | Wisconsin | Brown | 55009 | 97438 | 593 | 0 | 44.4526553 | -88.00411844 | 2022-10-11 04:23:05 | Brown, Wisconsin, US | |
2969571 | 2969571 | 2022-10-10 | US | New Hampshire | Rockingham | 33015 | 78824 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-11 04:23:05 | Rockingham, New Hampshire, US | |
3099607 | 3099607 | 2022-10-09 | US | New Hampshire | Rockingham | 33015 | 78824 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-10 04:22:32 | Rockingham, New Hampshire, US | |
4004832 | 4004832 | 2022-10-08 | US | New Hampshire | Rockingham | 33015 | 78824 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-09 04:21:16 | Rockingham, New Hampshire, US | |
398429 | 398429 | 2022-10-07 | US | New Hampshire | Rockingham | 33015 | 78824 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-08 04:22:56 | Rockingham, New Hampshire, US | |
2531546 | 2531546 | 2022-10-06 | US | New Hampshire | Rockingham | 33015 | 78733 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-07 04:23:08 | Rockingham, New Hampshire, US | |
2529374 | 2529374 | 2022-10-06 | Japan | Gifu | 293898 | 593 | 0 | 35.778671 | 137.055925 | 2022-10-07 04:23:08 | Gifu, Japan | |||
1812940 | 1812940 | 2022-10-05 | US | New Hampshire | Rockingham | 33015 | 78733 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-06 04:21:22 | Rockingham, New Hampshire, US | |
1810768 | 1810768 | 2022-10-05 | Japan | Gifu | 293361 | 593 | 0 | 35.778671 | 137.055925 | 2022-10-06 04:21:22 | Gifu, Japan | |||
132914 | 132914 | 2022-10-04 | US | New Hampshire | Rockingham | 33015 | 78634 | 593 | 0 | 42.98499744 | -71.12883377 | 2022-10-05 04:23:06 | Rockingham, New Hampshire, US | |
2017174 | 2017174 | 2022-09-20 | US | Arizona | Cochise | 4003 | 35943 | 593 | 0 | 31.87934684 | -109.7516088 | 2022-09-21 04:23:22 | Cochise, Arizona, US | |
3571047 | 3571047 | 2022-09-19 | US | Arizona | Cochise | 4003 | 35943 | 593 | 0 | 31.87934684 | -109.7516088 | 2022-09-20 04:22:48 | Cochise, Arizona, US | |
419786 | 419786 | 2022-09-18 | US | Arizona | Cochise | 4003 | 35943 | 593 | 0 | 31.87934684 | -109.7516088 | 2022-09-19 04:21:49 | Cochise, Arizona, US | |
3373810 | 3373810 | 2022-09-17 | US | Arizona | Cochise | 4003 | 35943 | 593 | 0 | 31.87934684 | -109.7516088 | 2022-09-18 04:22:50 | Cochise, Arizona, US | |
2355918 | 2355918 | 2022-09-16 | US | Arizona | Cochise | 4003 | 35943 | 593 | 0 | 31.87934684 | -109.7516088 | 2022-09-17 04:20:19 | Cochise, Arizona, US | |
3987075 | 3987075 | 2022-09-15 | US | Arizona | Cochise | 4003 | 35943 | 593 | 0 | 31.87934684 | -109.7516088 | 2022-09-16 04:21:19 | Cochise, Arizona, US | |
1889592 | 1889592 | 2022-09-14 | US | Arizona | Cochise | 4003 | 35943 | 593 | 0 | 31.87934684 | -109.7516088 | 2022-09-15 04:21:02 | Cochise, Arizona, US | |
2096129 | 2096129 | 2022-08-27 | Japan | Okinawa | 465534 | 593 | 0 | 25.768923 | 126.668016 | 2022-08-28 04:21:02 | Okinawa, Japan | |||
1531944 | 1531944 | 2022-08-26 | Japan | Okinawa | 462636 | 593 | 0 | 25.768923 | 126.668016 | 2022-08-27 04:20:57 | Okinawa, Japan | |||
2831898 | 2831898 | 2022-08-25 | US | Texas | Ellis | 48139 | 53881 | 593 | 0 | 32.34894117 | -96.79371841 | 2022-08-26 04:21:02 | Ellis, Texas, US | |
1252285 | 1252285 | 2022-08-23 | US | Louisiana | Rapides | 22079 | 37014 | 593 | 0 | 31.19778499 | -92.52997303 | 2022-08-24 04:20:46 | Rapides, Louisiana, US | |
1100571 | 1100571 | 2022-08-03 | US | Ohio | Clark | 39023 | 37832 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-08-04 04:20:58 | Clark, Ohio, US | |
1407496 | 1407496 | 2022-08-02 | US | Ohio | Clark | 39023 | 37832 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-08-03 04:20:59 | Clark, Ohio, US | |
3619534 | 3619534 | 2022-08-01 | US | Ohio | Clark | 39023 | 37832 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-08-02 04:20:53 | Clark, Ohio, US | |
3874014 | 3874014 | 2022-07-31 | US | Ohio | Clark | 39023 | 37832 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-08-01 04:21:03 | Clark, Ohio, US | |
676768 | 676768 | 2022-07-30 | US | Ohio | Clark | 39023 | 37832 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-07-31 04:21:02 | Clark, Ohio, US | |
1785967 | 1785967 | 2022-07-29 | US | Ohio | Clark | 39023 | 37832 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-07-30 04:20:42 | Clark, Ohio, US | |
1068330 | 1068330 | 2022-07-28 | US | Ohio | Clark | 39023 | 37832 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-07-29 04:20:45 | Clark, Ohio, US | |
2337849 | 2337849 | 2022-07-27 | US | Ohio | Clark | 39023 | 37434 | 593 | 0 | 39.91592258 | -83.78498252 | 2022-07-28 04:20:56 | Clark, Ohio, US | |
897741 | 897741 | 2022-07-24 | US | Maryland | Washington | 24043 | 37141 | 593 | 0 | 39.60835778 | -77.82002295 | 2022-07-25 04:20:51 | Washington, Maryland, US | |
92735 | 92735 | 2022-07-23 | US | Maryland | Washington | 24043 | 37141 | 593 | 0 | 39.60835778 | -77.82002295 | 2022-07-24 04:20:47 | Washington, Maryland, US | |
901757 | 901757 | 2022-07-22 | US | Maryland | Washington | 24043 | 37141 | 593 | 0 | 39.60835778 | -77.82002295 | 2022-07-23 04:20:53 | Washington, Maryland, US | |
671893 | 671893 | 2022-07-21 | US | Maryland | Washington | 24043 | 37086 | 593 | 0 | 39.60835778 | -77.82002295 | 2022-07-22 04:21:15 | Washington, Maryland, US | |
1611240 | 1611240 | 2022-07-20 | US | Tennessee | Montgomery | 47125 | 54036 | 593 | 0 | 36.49609412 | -87.38550661 | 2022-07-21 04:21:10 | Montgomery, Tennessee, US | |
1213757 | 1213757 | 2022-07-11 | US | New Mexico | McKinley | 35031 | 27954 | 593 | 0 | 35.5800772 | -108.262245 | 2022-07-12 04:20:51 | McKinley, New Mexico, US | |
1213136 | 1213136 | 2022-07-11 | US | Maryland | Harford | 24025 | 42323 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-12 04:20:51 | Harford, Maryland, US | |
2791239 | 2791239 | 2022-07-10 | US | New Mexico | McKinley | 35031 | 27811 | 593 | 0 | 35.5800772 | -108.262245 | 2022-07-11 04:20:46 | McKinley, New Mexico, US | |
2790618 | 2790618 | 2022-07-10 | US | Maryland | Harford | 24025 | 42258 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-11 04:20:46 | Harford, Maryland, US | |
144192 | 144192 | 2022-07-09 | US | New Mexico | McKinley | 35031 | 27811 | 593 | 0 | 35.5800772 | -108.262245 | 2022-07-10 04:20:54 | McKinley, New Mexico, US | |
143571 | 143571 | 2022-07-09 | US | Maryland | Harford | 24025 | 42258 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-10 04:20:54 | Harford, Maryland, US | |
142626 | 142626 | 2022-07-09 | US | Colorado | Mesa | 8077 | 45951 | 593 | 0 | 39.01787888 | -108.469799 | 2022-07-10 04:20:54 | Mesa, Colorado, US | |
1419292 | 1419292 | 2022-07-08 | US | New Mexico | McKinley | 35031 | 27811 | 593 | 0 | 35.5800772 | -108.262245 | 2022-07-09 04:20:59 | McKinley, New Mexico, US | |
1418671 | 1418671 | 2022-07-08 | US | Maryland | Harford | 24025 | 42258 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-09 04:20:59 | Harford, Maryland, US | |
1417726 | 1417726 | 2022-07-08 | US | Colorado | Mesa | 8077 | 45916 | 593 | 0 | 39.01787888 | -108.469799 | 2022-07-09 04:20:59 | Mesa, Colorado, US | |
2742596 | 2742596 | 2022-07-07 | US | Maryland | Harford | 24025 | 42197 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-08 04:20:56 | Harford, Maryland, US | |
2741651 | 2741651 | 2022-07-07 | US | Colorado | Mesa | 8077 | 45876 | 593 | 0 | 39.01787888 | -108.469799 | 2022-07-08 04:20:56 | Mesa, Colorado, US | |
1201391 | 1201391 | 2022-07-06 | US | Maryland | Harford | 24025 | 42154 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-07 04:20:55 | Harford, Maryland, US | |
3968134 | 3968134 | 2022-07-05 | US | Maryland | Harford | 24025 | 41994 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-06 04:20:58 | Harford, Maryland, US | |
3079645 | 3079645 | 2022-07-04 | US | Maryland | Harford | 24025 | 41957 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-05 04:20:45 | Harford, Maryland, US | |
1768927 | 1768927 | 2022-07-03 | US | Maryland | Harford | 24025 | 41957 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-04 04:20:54 | Harford, Maryland, US | |
3366913 | 3366913 | 2022-07-02 | US | Maryland | Harford | 24025 | 41957 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-03 04:20:59 | Harford, Maryland, US | |
596183 | 596183 | 2022-07-01 | US | Ohio | Warren | 39165 | 61457 | 593 | 0 | 39.42581994 | -84.16557457 | 2022-07-02 04:21:16 | Warren, Ohio, US | |
595242 | 595242 | 2022-07-01 | US | Maryland | Harford | 24025 | 41957 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-02 04:21:16 | Harford, Maryland, US | |
3942584 | 3942584 | 2022-06-30 | US | Ohio | Warren | 39165 | 61457 | 593 | 0 | 39.42581994 | -84.16557457 | 2022-07-01 04:21:10 | Warren, Ohio, US | |
3941643 | 3941643 | 2022-06-30 | US | Maryland | Harford | 24025 | 41905 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-07-01 04:21:10 | Harford, Maryland, US | |
2492542 | 2492542 | 2022-06-29 | US | Ohio | Warren | 39165 | 60986 | 593 | 0 | 39.42581994 | -84.16557457 | 2022-06-30 04:21:01 | Warren, Ohio, US | |
2491601 | 2491601 | 2022-06-29 | US | Maryland | Harford | 24025 | 41847 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-06-30 04:21:01 | Harford, Maryland, US | |
2241924 | 2241924 | 2022-06-28 | US | Ohio | Warren | 39165 | 60986 | 593 | 0 | 39.42581994 | -84.16557457 | 2022-06-29 04:20:59 | Warren, Ohio, US | |
2240983 | 2240983 | 2022-06-28 | US | Maryland | Harford | 24025 | 41804 | 593 | 0 | 39.55010644 | -76.3077594 | 2022-06-29 04:20:59 | Harford, Maryland, US | |
2150166 | 2150166 | 2022-06-27 | US | Ohio | Warren | 39165 | 60986 | 593 | 0 | 39.42581994 | -84.16557457 | 2022-06-28 04:20:58 | Warren, Ohio, US | |
2237588 | 2237588 | 2022-06-12 | US | New Mexico | McKinley | 35031 | 26544 | 593 | 0 | 35.5800772 | -108.262245 | 2022-06-13 04:21:14 | McKinley, New Mexico, US |
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]);