johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
144 rows where deaths = 1731 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2416529 | 2416529 | 2022-12-05 | US | Michigan | Kent | 26081 | 195572 | 1731 | 0 | 43.03197711 | -85.54934642 | 2022-12-06 04:21:03 | Kent, Michigan, US | |
720137 | 720137 | 2022-12-04 | US | Michigan | Kent | 26081 | 195572 | 1731 | 0 | 43.03197711 | -85.54934642 | 2022-12-05 04:20:58 | Kent, Michigan, US | |
2818426 | 2818426 | 2022-12-03 | US | Michigan | Kent | 26081 | 195572 | 1731 | 0 | 43.03197711 | -85.54934642 | 2022-12-04 04:20:56 | Kent, Michigan, US | |
835282 | 835282 | 2022-12-02 | US | Michigan | Kent | 26081 | 195572 | 1731 | 0 | 43.03197711 | -85.54934642 | 2022-12-03 04:21:02 | Kent, Michigan, US | |
2137812 | 2137812 | 2022-12-01 | US | Michigan | Kent | 26081 | 195572 | 1731 | 0 | 43.03197711 | -85.54934642 | 2022-12-02 04:21:07 | Kent, Michigan, US | |
1966228 | 1966228 | 2022-11-30 | US | Michigan | Kent | 26081 | 195572 | 1731 | 0 | 43.03197711 | -85.54934642 | 2022-12-01 04:21:03 | Kent, Michigan, US | |
2558242 | 2558242 | 2022-11-29 | US | Michigan | Kent | 26081 | 195572 | 1731 | 0 | 43.03197711 | -85.54934642 | 2022-11-30 04:21:07 | Kent, Michigan, US | |
796666 | 796666 | 2022-10-24 | US | New York | Monroe | 36055 | 181796 | 1731 | 0 | 43.14638895 | -77.69322942 | 2022-10-25 04:21:53 | Monroe, New York, US | |
3279121 | 3279121 | 2022-10-23 | US | New York | Monroe | 36055 | 181736 | 1731 | 0 | 43.14638895 | -77.69322942 | 2022-10-24 04:22:29 | Monroe, New York, US | |
2270159 | 2270159 | 2022-10-22 | US | New York | Monroe | 36055 | 181645 | 1731 | 0 | 43.14638895 | -77.69322942 | 2022-10-23 04:22:46 | Monroe, New York, US | |
1594459 | 1594459 | 2022-10-21 | US | New York | Monroe | 36055 | 181537 | 1731 | 0 | 43.14638895 | -77.69322942 | 2022-10-22 04:22:53 | Monroe, New York, US | |
3217572 | 3217572 | 2022-10-12 | US | Utah | Salt Lake | 49035 | 390712 | 1731 | 0 | 40.66616532 | -111.9216011 | 2022-10-13 04:22:39 | Salt Lake, Utah, US | |
3253421 | 3253421 | 2022-10-11 | US | Utah | Salt Lake | 49035 | 390712 | 1731 | 0 | 40.66616532 | -111.9216011 | 2022-10-12 04:22:51 | Salt Lake, Utah, US | |
2970680 | 2970680 | 2022-10-10 | US | Utah | Salt Lake | 49035 | 390712 | 1731 | 0 | 40.66616532 | -111.9216011 | 2022-10-11 04:23:05 | Salt Lake, Utah, US | |
3100716 | 3100716 | 2022-10-09 | US | Utah | Salt Lake | 49035 | 390712 | 1731 | 0 | 40.66616532 | -111.9216011 | 2022-10-10 04:22:32 | Salt Lake, Utah, US | |
4005941 | 4005941 | 2022-10-08 | US | Utah | Salt Lake | 49035 | 390712 | 1731 | 0 | 40.66616532 | -111.9216011 | 2022-10-09 04:21:16 | Salt Lake, Utah, US | |
399538 | 399538 | 2022-10-07 | US | Utah | Salt Lake | 49035 | 390712 | 1731 | 0 | 40.66616532 | -111.9216011 | 2022-10-08 04:22:56 | Salt Lake, Utah, US | |
2532655 | 2532655 | 2022-10-06 | US | Utah | Salt Lake | 49035 | 390712 | 1731 | 0 | 40.66616532 | -111.9216011 | 2022-10-07 04:23:08 | Salt Lake, Utah, US | |
1349254 | 1349254 | 2022-08-10 | US | Tennessee | Davidson | 47037 | 215635 | 1731 | 0 | 36.17007426 | -86.78646056 | 2022-08-11 04:20:49 | Davidson, Tennessee, US | |
1089009 | 1089009 | 2022-08-09 | US | Tennessee | Davidson | 47037 | 215364 | 1731 | 0 | 36.17007426 | -86.78646056 | 2022-08-10 04:20:57 | Davidson, Tennessee, US | |
1211455 | 1211455 | 2022-07-11 | Germany | Saarland | 352953 | 1731 | 0 | 49.3964 | 7.023 | 2022-07-12 04:20:51 | Saarland, Germany | |||
2788937 | 2788937 | 2022-07-10 | Germany | Saarland | 351428 | 1731 | 0 | 49.3964 | 7.023 | 2022-07-11 04:20:46 | Saarland, Germany | |||
141890 | 141890 | 2022-07-09 | Germany | Saarland | 351428 | 1731 | 0 | 49.3964 | 7.023 | 2022-07-10 04:20:54 | Saarland, Germany | |||
1416990 | 1416990 | 2022-07-08 | Germany | Saarland | 351428 | 1731 | 0 | 49.3964 | 7.023 | 2022-07-09 04:20:59 | Saarland, Germany | |||
2491624 | 2491624 | 2022-06-29 | US | Massachusetts | Plymouth | 25023 | 126013 | 1731 | 0 | 41.94070556 | -70.80802823 | 2022-06-30 04:21:01 | Plymouth, Massachusetts, US | |
2241006 | 2241006 | 2022-06-28 | US | Massachusetts | Plymouth | 25023 | 125888 | 1731 | 0 | 41.94070556 | -70.80802823 | 2022-06-29 04:20:59 | Plymouth, Massachusetts, US | |
2149248 | 2149248 | 2022-06-27 | US | Massachusetts | Plymouth | 25023 | 125801 | 1731 | 0 | 41.94070556 | -70.80802823 | 2022-06-28 04:20:58 | Plymouth, Massachusetts, US | |
2980241 | 2980241 | 2022-06-13 | US | Illinois | DuPage | 17043 | 237437 | 1731 | 0 | 41.85116968 | -88.08642662 | 2022-06-14 04:20:52 | DuPage, Illinois, US | |
2237900 | 2237900 | 2022-06-12 | US | Ohio | Stark | 39151 | 82906 | 1731 | 0 | 40.81482476 | -81.36437305 | 2022-06-13 04:21:14 | Stark, Ohio, US | |
3144098 | 3144098 | 2022-06-11 | US | Ohio | Stark | 39151 | 82906 | 1731 | 0 | 40.81482476 | -81.36437305 | 2022-06-12 04:20:53 | Stark, Ohio, US | |
3160154 | 3160154 | 2022-06-09 | US | Ohio | Summit | 39153 | 119297 | 1731 | 0 | 41.12464734 | -81.53123079 | 2022-06-10 04:20:55 | Summit, Ohio, US | |
3158620 | 3158620 | 2022-06-09 | US | Illinois | DuPage | 17043 | 236279 | 1731 | 0 | 41.85116968 | -88.08642662 | 2022-06-10 04:20:55 | DuPage, Illinois, US | |
1423621 | 1423621 | 2022-06-08 | US | Ohio | Summit | 39153 | 118434 | 1731 | 0 | 41.12464734 | -81.53123079 | 2022-06-09 04:20:54 | Summit, Ohio, US | |
3728735 | 3728735 | 2022-06-07 | US | Ohio | Summit | 39153 | 118434 | 1731 | 0 | 41.12464734 | -81.53123079 | 2022-06-08 04:20:55 | Summit, Ohio, US | |
3890137 | 3890137 | 2022-06-06 | US | Ohio | Summit | 39153 | 118434 | 1731 | 0 | 41.12464734 | -81.53123079 | 2022-06-07 04:21:08 | Summit, Ohio, US | |
2084023 | 2084023 | 2022-05-15 | Malaysia | Sarawak | 305981 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-16 04:20:47 | Sarawak, Malaysia | |||
3354733 | 3354733 | 2022-05-14 | Malaysia | Sarawak | 305951 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-15 04:20:53 | Sarawak, Malaysia | |||
658378 | 658378 | 2022-05-13 | Malaysia | Sarawak | 305903 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-14 04:20:48 | Sarawak, Malaysia | |||
2533461 | 2533461 | 2022-05-12 | Malaysia | Sarawak | 305846 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-13 04:20:51 | Sarawak, Malaysia | |||
3444907 | 3444907 | 2022-05-11 | Malaysia | Sarawak | 305792 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-12 04:20:54 | Sarawak, Malaysia | |||
3535524 | 3535524 | 2022-05-10 | Malaysia | Sarawak | 305721 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-11 04:20:48 | Sarawak, Malaysia | |||
222059 | 222059 | 2022-05-09 | Malaysia | Sarawak | 305647 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-10 04:20:50 | Sarawak, Malaysia | |||
2331444 | 2331444 | 2022-05-08 | Malaysia | Sarawak | 305608 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-09 04:20:54 | Sarawak, Malaysia | |||
360406 | 360406 | 2022-05-07 | Malaysia | Sarawak | 305574 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-08 04:20:49 | Sarawak, Malaysia | |||
1397757 | 1397757 | 2022-05-06 | Malaysia | Sarawak | 305525 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-07 04:21:09 | Sarawak, Malaysia | |||
2598112 | 2598112 | 2022-05-05 | Malaysia | Sarawak | 305491 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-06 04:21:00 | Sarawak, Malaysia | |||
3265561 | 3265561 | 2022-05-04 | Malaysia | Sarawak | 305467 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-05 04:20:55 | Sarawak, Malaysia | |||
1572200 | 1572200 | 2022-05-03 | Malaysia | Sarawak | 305435 | 1731 | 0 | 1.5533 | 110.3592 | 2022-05-04 04:20:59 | Sarawak, Malaysia | |||
3855055 | 3855055 | 2022-04-27 | US | Texas | Travis | 48453 | 246242 | 1731 | 0 | 30.33432034 | -97.7853562 | 2022-04-28 04:20:47 | Travis, Texas, US | |
1329485 | 1329485 | 2022-04-26 | US | Texas | Travis | 48453 | 245804 | 1731 | 0 | 30.33432034 | -97.78535620000001 | 2022-04-27 04:20:52 | Travis, Texas, US | |
3725439 | 3725439 | 2022-04-25 | US | Texas | Travis | 48453 | 245316 | 1731 | 0 | 30.33432034 | -97.78535620000001 | 2022-04-26 04:20:51 | Travis, Texas, US | |
2032007 | 2032007 | 2022-04-24 | US | Texas | Travis | 48453 | 244825 | 1731 | 0 | 30.33432034 | -97.78535620000001 | 2022-04-25 04:20:56 | Travis, Texas, US | |
749582 | 749582 | 2022-04-23 | US | Texas | Travis | 48453 | 244825 | 1731 | 0 | 30.33432034 | -97.78535620000001 | 2022-04-24 04:20:56 | Travis, Texas, US | |
746332 | 746332 | 2022-04-23 | Japan | Chiba | 411091 | 1731 | 0 | 35.510141 | 140.198917 | 2022-04-24 04:20:56 | Chiba, Japan | |||
3440067 | 3440067 | 2022-04-22 | US | Texas | Travis | 48453 | 244825 | 1731 | 0 | 30.33432034 | -97.78535620000001 | 2022-04-23 04:20:50 | Travis, Texas, US | |
2895652 | 2895652 | 2022-04-21 | US | Texas | Travis | 48453 | 244255 | 1731 | 0 | 30.33432034 | -97.78535620000001 | 2022-04-22 04:20:45 | Travis, Texas, US | |
1907383 | 1907383 | 2022-03-22 | US | New Mexico | Bernalillo | 35001 | 146198 | 1731 | 0 | 35.05163625 | -106.6703554 | 2022-03-23 04:20:48 | Bernalillo, New Mexico, US | |
1904948 | 1904948 | 2022-03-22 | Canada | Manitoba | 134417 | 1731 | 0 | 53.7609 | -98.8139 | 2022-03-23 04:20:48 | Manitoba, Canada | |||
3238079 | 3238079 | 2022-03-21 | Canada | Manitoba | 134313 | 1731 | 0 | 53.7609 | -98.8139 | 2022-03-22 04:20:54 | Manitoba, Canada | |||
575069 | 575069 | 2022-02-25 | Russia | Orel Oblast | 97218 | 1731 | 0 | 52.96854329999999 | 36.0692477 | 2022-02-26 04:21:12 | Orel Oblast, Russia | |||
1472080 | 1472080 | 2022-01-17 | Italy | Calabria | 146790 | 1731 | 0 | 38.90597598 | 16.59440194 | 2022-01-18 04:21:04 | Calabria, Italy | |||
3519410 | 3519410 | 2022-01-02 | Italy | Sardegna | 89800 | 1731 | 0 | 39.21531192 | 9.110616306 | 2022-01-03 02:22:25 | Sardegna, Italy | |||
1670928 | 1670928 | 2021-12-29 | US | Ohio | Hamilton | 39061 | 128424 | 1731 | 0 | 39.19673558 | -84.54502924 | 2021-12-30 04:21:25 | Hamilton, Ohio, US | |
1359922 | 1359922 | 2021-11-27 | US | Maryland | Montgomery | 24031 | 84976 | 1731 | 0 | 39.13676329 | -77.20358245 | 2021-11-28 04:22:43 | Montgomery, Maryland, US | |
759913 | 759913 | 2021-11-26 | US | Maryland | Montgomery | 24031 | 84627 | 1731 | 0 | 39.13676329 | -77.20358245 | 2021-11-27 04:22:45 | Montgomery, Maryland, US | |
1804330 | 1804330 | 2021-11-25 | US | Maryland | Montgomery | 24031 | 84627 | 1731 | 0 | 39.13676329 | -77.20358245 | 2021-11-26 04:22:33 | Montgomery, Maryland, US | |
905764 | 905764 | 2021-11-24 | US | Maryland | Montgomery | 24031 | 84627 | 1731 | 0 | 39.13676329 | -77.20358245 | 2021-11-25 04:22:33 | Montgomery, Maryland, US | |
903854 | 903854 | 2021-11-24 | Angola | 65080 | 1731 | 0 | -11.2027 | 17.8739 | 2021-11-25 04:22:33 | Angola | ||||
3071614 | 3071614 | 2021-11-23 | US | Maryland | Montgomery | 24031 | 84551 | 1731 | 0 | 39.13676329 | -77.20358245 | 2021-11-24 04:22:14 | Montgomery, Maryland, US | |
2846441 | 2846441 | 2021-11-10 | US | Maryland | Prince George's | 24033 | 100520 | 1731 | 0 | 38.83070039 | -76.8496441 | 2021-11-11 04:21:45 | Prince George's, Maryland, US | |
86871 | 86871 | 2021-11-09 | Cameroon | 104348 | 1731 | 0 | 3.8480000000000003 | 11.5021 | 2021-11-10 04:21:38 | Cameroon | ||||
3643198 | 3643198 | 2021-11-08 | Ukraine | Ternopil Oblast | 94814 | 1731 | 0 | 49.5535 | 25.5948 | 2021-11-09 04:21:36 | Ternopil Oblast, Ukraine | |||
3639299 | 3639299 | 2021-11-08 | Cameroon | 104348 | 1731 | 0 | 3.8480000000000003 | 11.5021 | 2021-11-09 04:21:36 | Cameroon | ||||
2000407 | 2000407 | 2021-11-07 | Cameroon | 104348 | 1731 | 0 | 3.8480000000000003 | 11.5021 | 2021-11-08 04:21:43 | Cameroon | ||||
495398 | 495398 | 2021-11-06 | Cameroon | 104348 | 1731 | 0 | 3.8480000000000003 | 11.5021 | 2021-11-07 04:21:53 | Cameroon | ||||
3121253 | 3121253 | 2021-11-05 | Cameroon | 104348 | 1731 | 0 | 3.8480000000000003 | 11.5021 | 2021-11-06 04:21:51 | Cameroon | ||||
698151 | 698151 | 2021-11-04 | Cameroon | 104348 | 1731 | 0 | 3.8480000000000003 | 11.5021 | 2021-11-05 04:21:54 | Cameroon | ||||
275929 | 275929 | 2021-11-03 | Cameroon | 104348 | 1731 | 0 | 3.8480000000000003 | 11.5021 | 2021-11-04 04:22:20 | Cameroon | ||||
2943612 | 2943612 | 2021-10-15 | Russia | Tver Oblast | 70792 | 1731 | 0 | 57.1134475 | 35.174442799999994 | 2021-10-16 04:21:15 | Tver Oblast, Russia | |||
3009798 | 3009798 | 2021-10-11 | US | Ohio | Franklin | 39049 | 160553 | 1731 | 0 | 39.96995815 | -83.01115755 | 2021-10-12 04:21:09 | Franklin, Ohio, US | |
1274592 | 1274592 | 2021-10-03 | Spain | Murcia | 140867 | 1731 | 0 | 37.9922 | -1.1307 | 2021-10-04 04:21:31 | Murcia, Spain | |||
3928345 | 3928345 | 2021-10-02 | Spain | Murcia | 140867 | 1731 | 0 | 37.9922 | -1.1307 | 2021-10-03 04:21:24 | Murcia, Spain | |||
2132325 | 2132325 | 2021-10-01 | Spain | Murcia | 140867 | 1731 | 0 | 37.9922 | -1.1307 | 2021-10-02 04:21:25 | Murcia, Spain | |||
1884999 | 1884999 | 2021-09-12 | Jamaica | 75857 | 1731 | 0 | 18.1096 | -77.2975 | 2021-09-13 04:21:15 | Jamaica | ||||
3284511 | 3284511 | 2021-09-05 | Ukraine | Vinnytsia Oblast | 72764 | 1731 | 0 | 49.2331 | 28.4682 | 2021-09-06 04:21:22 | Vinnytsia Oblast, Ukraine | |||
252925 | 252925 | 2021-09-04 | Ukraine | Vinnytsia Oblast | 72718 | 1731 | 0 | 49.2331 | 28.4682 | 2021-09-05 04:21:33 | Vinnytsia Oblast, Ukraine | |||
3978206 | 3978206 | 2021-09-03 | Ukraine | Vinnytsia Oblast | 72655 | 1731 | 0 | 49.2331 | 28.4682 | 2021-09-04 04:21:28 | Vinnytsia Oblast, Ukraine | |||
1607269 | 1607269 | 2021-08-16 | US | Texas | Cameron | 48061 | 59100 | 1731 | 0 | 26.14524221 | -97.48140372 | 2021-08-17 04:21:49 | Cameron, Texas, US | |
1604346 | 1604346 | 2021-08-16 | Mozambique | 139038 | 1731 | 0 | -18.665695 | 35.529562 | 2021-08-17 04:21:49 | Mozambique | ||||
106363 | 106363 | 2021-08-15 | US | Texas | Cameron | 48061 | 59100 | 1731 | 0 | 26.14524221 | -97.48140372 | 2021-08-16 04:21:31 | Cameron, Texas, US | |
510721 | 510721 | 2021-08-14 | US | Texas | Cameron | 48061 | 59100 | 1731 | 0 | 26.14524221 | -97.48140372 | 2021-08-15 04:21:41 | Cameron, Texas, US | |
1486593 | 1486593 | 2021-08-13 | US | Texas | Cameron | 48061 | 58581 | 1731 | 0 | 26.14524221 | -97.48140372 | 2021-08-14 04:21:25 | Cameron, Texas, US | |
1117827 | 1117827 | 2021-08-06 | Russia | Penza Oblast | 57606 | 1731 | 0 | 53.1655415 | 44.78791810000001 | 2021-08-07 04:21:30 | Penza Oblast, Russia | |||
1309144 | 1309144 | 2021-07-27 | US | Tennessee | Shelby | 47157 | 103214 | 1731 | 0 | 35.1864775 | -89.89692423 | 2021-07-28 04:21:39 | Shelby, Tennessee, US | |
484134 | 484134 | 2021-07-19 | US | California | Fresno | 6019 | 112266 | 1731 | 0 | 36.75733899 | -119.6466953 | 2021-07-20 04:21:48 | Fresno, California, US | |
2674357 | 2674357 | 2021-07-18 | US | California | Fresno | 6019 | 112196 | 1731 | 0 | 36.75733899 | -119.6466953 | 2021-07-19 04:21:24 | Fresno, California, US | |
3125257 | 3125257 | 2021-06-28 | Brazil | Roraima | 111858 | 1731 | 102722 | 7391 | -2.7376 | -62.0751 | 2021-06-29 04:21:28 | Roraima, Brazil | ||
2589752 | 2589752 | 2021-06-27 | Brazil | Roraima | 111844 | 1731 | 102722 | 7267 | -2.7376 | -62.0751 | 2021-06-28 04:21:29 | Roraima, Brazil | ||
3958256 | 3958256 | 2021-06-26 | Brazil | Roraima | 111720 | 1731 | 102722 | 6983 | -2.7376 | -62.0751 | 2021-06-27 04:21:39 | Roraima, Brazil | ||
1712075 | 1712075 | 2021-06-25 | Brazil | Roraima | 111436 | 1731 | 102722 | 6659 | -2.7376 | -62.0751 | 2021-06-26 04:21:43 | Roraima, Brazil |
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]);