johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
552 rows where active = 380 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683281 | 3683281 | 2021-08-02 | China | Yunnan | 841 | 2 | 459 | 380 | 24.974 | 101.487 | 2021-08-03 04:21:39 | Yunnan, China | ||
3903803 | 3903803 | 2021-07-31 | China | Yunnan | 814 | 2 | 432 | 380 | 24.974 | 101.487 | 2021-08-01 04:21:50 | Yunnan, China | ||
411915 | 411915 | 2021-07-28 | Ukraine | Chernihiv Oblast | 57732 | 1353 | 55999 | 380 | 51.4982 | 31.2893 | 2021-07-29 04:21:33 | Chernihiv Oblast, Ukraine | ||
1306077 | 1306077 | 2021-07-27 | Germany | Thuringen | 129129 | 4376 | 124400 | 380 | 51.011 | 10.8453 | 2021-07-28 04:21:39 | Thuringen, Germany | ||
3137565 | 3137565 | 2021-07-23 | Japan | Ishikawa | 4435 | 116 | 3939 | 380 | 36.769464 | 136.771027 | 2021-07-24 00:21:36 | Ishikawa, Japan | ||
3331364 | 3331364 | 2021-07-21 | Colombia | Arauca | 12241 | 386 | 11475 | 380 | 7.0762 | -70.7105 | 2021-07-22 04:21:19 | Arauca, Colombia | ||
2947133 | 2947133 | 2021-07-16 | Canada | Saskatchewan | 49362 | 575 | 48407 | 380 | 52.9399 | -106.4509 | 2021-07-17 04:22:22 | Saskatchewan, Canada | ||
3635582 | 3635582 | 2021-07-14 | Ukraine | Donetsk Oblast | 90970 | 2371 | 88219 | 380 | 48.0159 | 37.8028 | 2021-07-15 04:21:48 | Donetsk Oblast, Ukraine | ||
1165089 | 1165089 | 2021-07-04 | Germany | Schleswig-Holstein | 63921 | 1623 | 61960 | 380 | 54.2194 | 9.6961 | 2021-07-05 04:21:28 | Schleswig-Holstein, Germany | ||
2765077 | 2765077 | 2021-07-01 | Pakistan | Gilgit-Baltistan | 6239 | 111 | 5748 | 380 | 35.792146 | 74.982138 | 2021-07-02 04:21:47 | Gilgit-Baltistan, Pakistan | ||
2764777 | 2764777 | 2021-07-01 | Colombia | Choco | 14384 | 348 | 13656 | 380 | 5.2528 | -76.82600000000002 | 2021-07-02 04:21:47 | Choco, Colombia | ||
3125427 | 3125427 | 2021-06-28 | Germany | Sachsen-Anhalt | 99223 | 3425 | 95460 | 380 | 51.9503 | 11.6923 | 2021-06-29 04:21:28 | Sachsen-Anhalt, Germany | ||
566652 | 566652 | 2021-06-22 | Malaysia | Terengganu | 10992 | 73 | 10539 | 380 | 5.3117 | 103.1324 | 2021-06-23 04:21:46 | Terengganu, Malaysia | ||
3030402 | 3030402 | 2021-06-16 | Montenegro | 100001 | 1603 | 98018 | 380 | 42.708678000000006 | 19.37439 | 2021-06-17 04:22:36 | Montenegro | |||
2104372 | 2104372 | 2021-06-01 | Russia | Sakhalin Oblast | 23004 | 51 | 22573 | 380 | 49.7219665 | 143.448533 | 2021-06-02 04:24:34 | Sakhalin Oblast, Russia | ||
1413285 | 1413285 | 2021-05-24 | Russia | North Ossetia - Alania Republic | 16947 | 206 | 16361 | 380 | 42.79336110000001 | 44.6324493 | 2021-05-25 04:21:08 | North Ossetia - Alania Republic, Russia | ||
1876591 | 1876591 | 2021-05-15 | Ukraine | Sevastopol* | 14406 | 657 | 13369 | 380 | 44.6054 | 33.522 | 2021-05-16 04:20:49 | Sevastopol*, Ukraine | ||
3113513 | 3113513 | 2021-05-06 | Japan | Niigata | 2452 | 25 | 2047 | 380 | 37.521819 | 138.918647 | 2021-05-07 04:20:40 | Niigata, Japan | ||
2450776 | 2450776 | 2021-05-02 | Japan | Ehime | 2381 | 45 | 1956 | 380 | 33.624835 | 132.856842 | 2021-05-03 04:20:39 | Ehime, Japan | ||
3393637 | 3393637 | 2021-04-28 | Russia | Sakhalin Oblast | 22497 | 41 | 22076 | 380 | 49.7219665 | 143.448533 | 2021-04-29 04:20:55 | Sakhalin Oblast, Russia | ||
1568044 | 1568044 | 2021-04-22 | India | Arunachal Pradesh | 17296 | 56 | 16860 | 380 | 27.768456 | 96.384277 | 2021-04-23 04:20:52 | Arunachal Pradesh, India | ||
3710280 | 3710280 | 2021-04-03 | Pakistan | Balochistan | 19734 | 211 | 19143 | 380 | 28.328492 | 65.898403 | 2021-04-04 04:20:49 | Balochistan, Pakistan | ||
2359480 | 2359480 | 2021-03-08 | Japan | Ibaraki | 6012 | 118 | 5514 | 380 | 36.303588 | 140.319591 | 2021-03-09 05:28:19 | Ibaraki, Japan | ||
2208305 | 2208305 | 2021-03-04 | US | Colorado | Washington | 8121 | 417 | 12 | 0 | 380 | 39.97015535 | -103.202587 | 2021-03-05 05:26:29 | Washington, Colorado, US |
2207845 | 2207845 | 2021-03-04 | Russia | Chechen Republic | 11343 | 112 | 10851 | 380 | 43.39761470000001 | 45.6985005 | 2021-03-05 05:26:29 | Chechen Republic, Russia | ||
1090726 | 1090726 | 2021-03-03 | US | Colorado | Washington | 8121 | 416 | 12 | 0 | 380 | 39.97015535 | -103.202587 | 2021-03-04 05:24:24 | Washington, Colorado, US |
3257464 | 3257464 | 2021-03-02 | US | Virginia | Cumberland | 51049 | 386 | 6 | 0 | 380 | 37.51328851 | -78.24398086 | 2021-03-03 05:23:28 | Cumberland, Virginia, US |
2185251 | 2185251 | 2021-02-26 | US | Michigan | Oscoda | 26135 | 399 | 19 | 0 | 380 | 44.68192279 | -84.12939244 | 2021-02-27 05:22:28 | Oscoda, Michigan, US |
1859673 | 1859673 | 2021-02-25 | US | Michigan | Oscoda | 26135 | 399 | 19 | 0 | 380 | 44.68192279 | -84.12939244 | 2021-02-26 05:22:40 | Oscoda, Michigan, US |
282202 | 282202 | 2021-02-24 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-25 05:24:57 | Sheridan, Montana, US |
1938470 | 1938470 | 2021-02-23 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-24 05:29:16 | Sheridan, Montana, US |
532725 | 532725 | 2021-02-22 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-23 05:23:41 | Sheridan, Montana, US |
184059 | 184059 | 2021-02-21 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-22 05:24:21 | Sheridan, Montana, US |
744333 | 744333 | 2021-02-20 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-21 05:24:33 | Sheridan, Montana, US |
474017 | 474017 | 2021-02-19 | US | Oregon | Curry | 41015 | 386 | 6 | 0 | 380 | 42.45911325 | -124.157282 | 2021-02-20 05:22:51 | Curry, Oregon, US |
473431 | 473431 | 2021-02-19 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-20 05:22:51 | Sheridan, Montana, US |
1155140 | 1155140 | 2021-02-18 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-19 05:24:16 | Sheridan, Montana, US |
1153134 | 1153134 | 2021-02-18 | Japan | Ibaraki | 5475 | 100 | 4995 | 380 | 36.303588 | 140.319591 | 2021-02-19 05:24:16 | Ibaraki, Japan | ||
3603060 | 3603060 | 2021-02-17 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-18 05:22:58 | Sheridan, Montana, US |
3052195 | 3052195 | 2021-02-16 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-17 05:23:10 | Sheridan, Montana, US |
1340294 | 1340294 | 2021-02-15 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-16 05:24:38 | Sheridan, Montana, US |
1338203 | 1338203 | 2021-02-15 | Guinea | 14967 | 85 | 14502 | 380 | 9.9456 | -9.6966 | 2021-02-16 05:24:38 | Guinea | |||
2286698 | 2286698 | 2021-02-14 | US | Vermont | Caledonia | 50005 | 385 | 5 | 0 | 380 | 44.46548598 | -72.10314651 | 2021-02-15 05:24:49 | Caledonia, Vermont, US |
2285445 | 2285445 | 2021-02-14 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-15 05:24:49 | Sheridan, Montana, US |
2283354 | 2283354 | 2021-02-14 | Guinea | 14967 | 85 | 14502 | 380 | 9.9456 | -9.6966 | 2021-02-15 05:24:49 | Guinea | |||
2679845 | 2679845 | 2021-02-13 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-14 05:23:43 | Sheridan, Montana, US |
2678285 | 2678285 | 2021-02-13 | US | Arkansas | Calhoun | 5013 | 383 | 3 | 0 | 380 | 33.55598792 | -92.49974403 | 2021-02-14 05:23:43 | Calhoun, Arkansas, US |
3541561 | 3541561 | 2021-02-12 | US | Nebraska | Polk | 31143 | 389 | 9 | 0 | 380 | 41.18813488 | -97.56630712 | 2021-02-13 05:22:12 | Polk, Nebraska, US |
3541478 | 3541478 | 2021-02-12 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-13 05:22:12 | Sheridan, Montana, US |
3539300 | 3539300 | 2021-02-12 | Colombia | Casanare | 11950 | 248 | 11322 | 380 | 5.7589 | -71.5724 | 2021-02-13 05:22:12 | Casanare, Colombia | ||
3539244 | 3539244 | 2021-02-12 | Chile | Atacama | 10975 | 137 | 10458 | 380 | -27.5661 | -70.0503 | 2021-02-13 05:22:12 | Atacama, Chile | ||
2640999 | 2640999 | 2021-02-11 | US | Vermont | Lamoille | 50015 | 382 | 2 | 0 | 380 | 44.60353043 | -72.64356694 | 2021-02-12 05:23:29 | Lamoille, Vermont, US |
2639824 | 2639824 | 2021-02-11 | US | Nebraska | Polk | 31143 | 389 | 9 | 0 | 380 | 41.18813488 | -97.56630712 | 2021-02-12 05:23:29 | Polk, Nebraska, US |
2639741 | 2639741 | 2021-02-11 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-12 05:23:29 | Sheridan, Montana, US |
2639699 | 2639699 | 2021-02-11 | US | Montana | Broadwater | 30007 | 384 | 4 | 0 | 380 | 46.33277565 | -111.4955813 | 2021-02-12 05:23:29 | Broadwater, Montana, US |
2638272 | 2638272 | 2021-02-11 | US | California | Mariposa | 6043 | 385 | 5 | 0 | 380 | 37.57978556 | -119.9073334 | 2021-02-12 05:23:29 | Mariposa, California, US |
3980596 | 3980596 | 2021-02-10 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-11 05:23:55 | Sheridan, Montana, US |
3978358 | 3978358 | 2021-02-10 | Chad | 3568 | 126 | 3062 | 380 | 15.4542 | 18.7322 | 2021-02-11 05:23:55 | Chad | |||
1529916 | 1529916 | 2021-02-09 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-10 05:22:41 | Sheridan, Montana, US |
615707 | 615707 | 2021-02-08 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-09 05:23:30 | Sheridan, Montana, US |
1674476 | 1674476 | 2021-02-07 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-08 05:22:39 | Sheridan, Montana, US |
976937 | 976937 | 2021-02-06 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-07 05:23:00 | Sheridan, Montana, US |
975947 | 975947 | 2021-02-06 | US | Illinois | Putnam | 17155 | 383 | 3 | 0 | 380 | 41.2013541 | -89.2869272 | 2021-02-07 05:23:00 | Putnam, Illinois, US |
1590195 | 1590195 | 2021-02-05 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-06 05:23:55 | Sheridan, Montana, US |
792402 | 792402 | 2021-02-04 | US | Montana | Sheridan | 30091 | 385 | 5 | 0 | 380 | 48.72085833 | -104.503829 | 2021-02-05 05:22:38 | Sheridan, Montana, US |
1687268 | 1687268 | 2021-02-02 | US | Puerto Rico | San German | 72125 | 380 | 0 | 0 | 380 | 18.111484 | -67.03858100000001 | 2021-02-03 05:22:52 | San German, Puerto Rico, US |
1684641 | 1684641 | 2021-02-02 | Pakistan | Azad Jammu and Kashmir | 9073 | 267 | 8426 | 380 | 34.027401 | 73.947253 | 2021-02-03 05:22:52 | Azad Jammu and Kashmir, Pakistan | ||
1676479 | 1676479 | 2021-02-01 | Japan | Gifu | 4137 | 69 | 3688 | 380 | 35.778671 | 137.055925 | 2021-02-02 05:22:49 | Gifu, Japan | ||
1461233 | 1461233 | 2021-01-31 | US | Kentucky | Wolfe | 21237 | 384 | 4 | 0 | 380 | 37.73941626 | -83.49303612 | 2021-02-01 05:22:53 | Wolfe, Kentucky, US |
2211783 | 2211783 | 2021-01-30 | Netherlands | Aruba | 6944 | 59 | 6505 | 380 | 12.5211 | -69.9683 | 2021-01-31 05:22:42 | Aruba, Netherlands | ||
2483569 | 2483569 | 2021-01-28 | US | Michigan | Alcona | 26001 | 403 | 23 | 0 | 380 | 44.6846864 | -83.59507875 | 2021-01-29 05:22:23 | Alcona, Michigan, US |
2427770 | 2427770 | 2021-01-23 | US | Georgia | Talbot | 13263 | 391 | 11 | 0 | 380 | 32.69642758 | -84.53351366 | 2021-01-24 05:22:35 | Talbot, Georgia, US |
2469353 | 2469353 | 2021-01-22 | US | Oklahoma | Harper | 40059 | 383 | 3 | 0 | 380 | 36.78836519 | -99.6679804 | 2021-01-23 05:22:03 | Harper, Oklahoma, US |
1094286 | 1094286 | 2021-01-20 | Russia | Jewish Autonomous Okrug | 4014 | 95 | 3539 | 380 | 48.57527615 | 132.66307460000002 | 2021-01-21 05:22:01 | Jewish Autonomous Okrug, Russia | ||
3506721 | 3506721 | 2021-01-17 | US | Virginia | Mathews | 51115 | 384 | 4 | 0 | 380 | 37.44164146 | -76.34098896 | 2021-01-18 05:22:34 | Mathews, Virginia, US |
3104804 | 3104804 | 2021-01-16 | US | Virginia | Mathews | 51115 | 384 | 4 | 0 | 380 | 37.44164146 | -76.34098896 | 2021-01-17 05:22:17 | Mathews, Virginia, US |
3102420 | 3102420 | 2021-01-16 | US | Illinois | Gallatin | 17059 | 383 | 3 | 0 | 380 | 37.76430935 | -88.22953869 | 2021-01-17 05:22:17 | Gallatin, Illinois, US |
3101398 | 3101398 | 2021-01-16 | India | Manipur | 28835 | 366 | 28089 | 380 | 24.738975 | 93.882541 | 2021-01-17 05:22:17 | Manipur, India | ||
3515430 | 3515430 | 2021-01-15 | Japan | Nara | 2474 | 31 | 2063 | 380 | 34.317451 | 135.871644 | 2021-01-16 05:22:40 | Nara, Japan | ||
157657 | 157657 | 2021-01-08 | Malaysia | Kelantan | 1134 | 9 | 745 | 380 | 6.1254 | 102.2381 | 2021-01-09 05:22:18 | Kelantan, Malaysia | ||
2545081 | 2545081 | 2021-01-07 | Malaysia | Kelantan | 1085 | 9 | 696 | 380 | 6.1254 | 102.2381 | 2021-01-08 05:22:42 | Kelantan, Malaysia | ||
2543516 | 2543516 | 2021-01-07 | US | Nebraska | Sheridan | 31161 | 391 | 11 | 0 | 380 | 42.50284406 | -102.4126613 | 2021-01-08 05:22:42 | Sheridan, Nebraska, US |
2867932 | 2867932 | 2021-01-06 | US | Texas | Sutton | 48435 | 337 | 6 | 0 | 380 | 30.49856623 | -100.5382014 | 2021-01-07 05:22:03 | Sutton, Texas, US |
2867571 | 2867571 | 2021-01-06 | US | South Dakota | Douglas | 46043 | 388 | 8 | 0 | 380 | 43.38520741 | -98.36978007 | 2021-01-07 05:22:03 | Douglas, South Dakota, US |
1065522 | 1065522 | 2021-01-04 | Malaysia | Kelantan | 934 | 9 | 545 | 380 | 6.1254 | 102.2381 | 2021-01-05 05:21:49 | Kelantan, Malaysia | ||
1063394 | 1063394 | 2021-01-04 | US | Maine | Knox | 23013 | 384 | 4 | 0 | 380 | 44.11486325 | -69.10529169 | 2021-01-05 05:21:49 | Knox, Maine, US |
3232995 | 3232995 | 2021-01-03 | US | Oklahoma | Greer | 40055 | 389 | 9 | 0 | 380 | 34.93535801 | -99.5605612 | 2021-01-04 05:22:02 | Greer, Oklahoma, US |
3231787 | 3231787 | 2021-01-03 | US | Kansas | Sheridan | 20179 | 388 | 8 | 0 | 380 | 39.35018161 | -100.4418259 | 2021-01-04 05:22:02 | Sheridan, Kansas, US |
2231025 | 2231025 | 2021-01-02 | US | West Virginia | Tyler | 54095 | 382 | 2 | 0 | 380 | 39.46811972 | -80.88772676 | 2021-01-03 05:22:52 | Tyler, West Virginia, US |
2229633 | 2229633 | 2021-01-02 | US | Nebraska | Thayer | 31169 | 383 | 3 | 0 | 380 | 40.17626377 | -97.59504381 | 2021-01-03 05:22:52 | Thayer, Nebraska, US |
2228856 | 2228856 | 2021-01-02 | US | Kansas | Sheridan | 20179 | 388 | 8 | 0 | 380 | 39.35018161 | -100.4418259 | 2021-01-03 05:22:52 | Sheridan, Kansas, US |
1138220 | 1138220 | 2021-01-01 | US | Kansas | Sheridan | 20179 | 388 | 8 | 0 | 380 | 39.35018161 | -100.4418259 | 2021-01-02 05:22:33 | Sheridan, Kansas, US |
1137840 | 1137840 | 2021-01-01 | US | Illinois | Calhoun | 17013 | 381 | 1 | 0 | 380 | 39.16840183 | -90.66330078 | 2021-01-02 05:22:33 | Calhoun, Illinois, US |
3697621 | 3697621 | 2020-12-31 | US | Nevada | Lander | 32015 | 384 | 4 | 0 | 380 | 39.9332233 | -117.0397075 | 2021-01-01 05:23:07 | Lander, Nevada, US |
3696446 | 3696446 | 2020-12-31 | US | Illinois | Calhoun | 17013 | 381 | 1 | 0 | 380 | 39.16840183 | -90.66330078 | 2021-01-01 05:23:07 | Calhoun, Illinois, US |
3696125 | 3696125 | 2020-12-31 | US | Colorado | Park | 8093 | 429 | 5 | 0 | 380 | 39.120926 | -105.7182065 | 2021-01-01 05:23:07 | Park, Colorado, US |
1013615 | 1013615 | 2020-12-30 | US | Virginia | Clarke | 51043 | 385 | 5 | 0 | 380 | 39.11271747 | -77.99199425 | 2020-12-31 05:22:49 | Clarke, Virginia, US |
1012436 | 1012436 | 2020-12-30 | US | Nevada | Lander | 32015 | 384 | 4 | 0 | 380 | 39.9332233 | -117.0397075 | 2020-12-31 05:22:49 | Lander, Nevada, US |
1011416 | 1011416 | 2020-12-30 | US | Indiana | Ohio | 18115 | 390 | 10 | 0 | 380 | 38.955305 | -84.96515993 | 2020-12-31 05:22:49 | Ohio, Indiana, US |
768328 | 768328 | 2020-12-29 | US | Montana | Pondera | 30073 | 383 | 3 | 0 | 380 | 48.22773388 | -112.2252703 | 2020-12-30 05:22:34 | Pondera, Montana, 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]);