johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
619 rows where active = 336 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903962 | 3903962 | 2021-07-31 | Italy | P.A. Bolzano | 73797 | 1183 | 72278 | 336 | 46.49933453 | 11.35662422 | 2021-08-01 04:21:50 | P.A. Bolzano, Italy | ||
3385378 | 3385378 | 2021-07-29 | Italy | P.A. Bolzano | 73751 | 1183 | 72232 | 336 | 46.49933453 | 11.35662422 | 2021-07-30 04:21:34 | P.A. Bolzano, Italy | ||
411939 | 411939 | 2021-07-28 | Ukraine | Zaporizhia Oblast | 105137 | 2454 | 102347 | 336 | 47.8388 | 35.1396 | 2021-07-29 04:21:33 | Zaporizhia Oblast, Ukraine | ||
411927 | 411927 | 2021-07-28 | Ukraine | Luhansk Oblast | 27071 | 971 | 25764 | 336 | 48.574 | 39.3078 | 2021-07-29 04:21:33 | Luhansk Oblast, Ukraine | ||
1378284 | 1378284 | 2021-07-25 | Canada | Saskatchewan | 49683 | 578 | 48769 | 336 | 52.9399 | -106.4509 | 2021-07-26 04:21:28 | Saskatchewan, Canada | ||
483540 | 483540 | 2021-07-19 | India | Jharkhand | 346745 | 5122 | 341287 | 336 | 23.654536 | 85.557631 | 2021-07-20 04:21:48 | Jharkhand, India | ||
295962 | 295962 | 2021-07-15 | India | Jharkhand | 346533 | 5120 | 341077 | 336 | 23.654536 | 85.557631 | 2021-07-16 04:21:22 | Jharkhand, India | ||
3635577 | 3635577 | 2021-07-14 | Ukraine | Cherkasy Oblast | 81951 | 1317 | 80298 | 336 | 49.4444 | 32.0598 | 2021-07-15 04:21:48 | Cherkasy Oblast, Ukraine | ||
582452 | 582452 | 2021-07-13 | Ukraine | Cherkasy Oblast | 81938 | 1317 | 80285 | 336 | 49.4444 | 32.0598 | 2021-07-14 04:21:35 | Cherkasy Oblast, Ukraine | ||
2072116 | 2072116 | 2021-07-02 | Russia | Ingushetia Republic | 16233 | 195 | 15702 | 336 | 43.11542075 | 45.01713552 | 2021-07-03 04:21:37 | Ingushetia Republic, Russia | ||
523042 | 523042 | 2021-06-09 | Russia | Amur Oblast | 22902 | 294 | 22272 | 336 | 52.8032368 | 128.437295 | 2021-06-10 04:23:17 | Amur Oblast, Russia | ||
3472310 | 3472310 | 2021-06-08 | Japan | Ibaraki | 9963 | 155 | 9472 | 336 | 36.303588 | 140.319591 | 2021-06-09 04:23:31 | Ibaraki, Japan | ||
3089146 | 3089146 | 2021-05-30 | Bhutan | 1612 | 1 | 1275 | 336 | 27.5142 | 90.4336 | 2021-05-31 03:08:59 | Bhutan | |||
726682 | 726682 | 2021-05-22 | Russia | Amur Oblast | 22611 | 290 | 21985 | 336 | 52.8032368 | 128.437295 | 2021-05-23 04:20:51 | Amur Oblast, Russia | ||
3574786 | 3574786 | 2021-05-17 | Russia | Buryatia Republic | 37632 | 875 | 36421 | 336 | 52.7182426 | 109.492143 | 2021-05-18 04:20:33 | Buryatia Republic, Russia | ||
1081927 | 1081927 | 2021-05-14 | Japan | Aomori | 1926 | 27 | 1563 | 336 | 40.781541 | 140.828896 | 2021-05-15 04:20:58 | Aomori, Japan | ||
3054381 | 3054381 | 2021-05-13 | Russia | Buryatia Republic | 37482 | 869 | 36277 | 336 | 52.7182426 | 109.492143 | 2021-05-14 04:20:41 | Buryatia Republic, Russia | ||
1552180 | 1552180 | 2021-05-08 | Russia | Khakassia Republic | 22512 | 534 | 21642 | 336 | 53.72258845 | 91.44293627 | 2021-05-09 04:20:35 | Khakassia Republic, Russia | ||
2501930 | 2501930 | 2021-05-07 | France | St Martin | 1749 | 14 | 1399 | 336 | 18.0708 | -63.0501 | 2021-05-08 04:21:04 | St Martin, France | ||
3113386 | 3113386 | 2021-05-06 | France | St Martin | 1749 | 14 | 1399 | 336 | 18.0708 | -63.0501 | 2021-05-07 04:20:40 | St Martin, France | ||
3113175 | 3113175 | 2021-05-06 | Andorra | 13363 | 127 | 12900 | 336 | 42.5063 | 1.5218 | 2021-05-07 04:20:40 | Andorra | |||
645992 | 645992 | 2021-05-05 | Japan | Tokushima | 1421 | 47 | 1038 | 336 | 33.919178 | 134.242091 | 2021-05-06 04:20:38 | Tokushima, Japan | ||
645853 | 645853 | 2021-05-05 | France | St Martin | 1749 | 14 | 1399 | 336 | 18.0708 | -63.0501 | 2021-05-06 04:20:38 | St Martin, France | ||
3675553 | 3675553 | 2021-05-04 | France | St Martin | 1749 | 14 | 1399 | 336 | 18.0708 | -63.0501 | 2021-05-05 04:20:43 | St Martin, France | ||
2761128 | 2761128 | 2021-05-03 | Russia | Khakassia Republic | 22416 | 526 | 21554 | 336 | 53.72258845 | 91.44293627 | 2021-05-04 04:20:34 | Khakassia Republic, Russia | ||
2760820 | 2760820 | 2021-05-03 | France | St Martin | 1749 | 14 | 1399 | 336 | 18.0708 | -63.0501 | 2021-05-04 04:20:34 | St Martin, France | ||
2450673 | 2450673 | 2021-05-02 | France | St Martin | 1749 | 14 | 1399 | 336 | 18.0708 | -63.0501 | 2021-05-03 04:20:39 | St Martin, France | ||
3927627 | 3927627 | 2021-04-24 | Uganda | 41575 | 341 | 40898 | 336 | 1.373333 | 32.290275 | 2021-04-25 04:20:32 | Uganda | |||
1412658 | 1412658 | 2021-04-23 | Uganda | 41575 | 341 | 40898 | 336 | 1.373333 | 32.290275 | 2021-04-24 04:20:38 | Uganda | |||
2548843 | 2548843 | 2021-04-15 | India | Tripura | 33875 | 394 | 33145 | 336 | 23.746783 | 91.743565 | 2021-04-16 04:20:46 | Tripura, India | ||
36460 | 36460 | 2021-04-12 | Japan | Okayama | 2974 | 35 | 2603 | 336 | 34.89246 | 133.826252 | 2021-04-13 04:20:37 | Okayama, Japan | ||
36455 | 36455 | 2021-04-12 | Japan | Nagano | 3221 | 44 | 2841 | 336 | 36.132134 | 138.045528 | 2021-04-13 04:20:37 | Nagano, Japan | ||
2645458 | 2645458 | 2021-04-08 | Bahamas | 9339 | 189 | 8814 | 336 | 25.025885 | -78.035889 | 2021-04-09 04:21:13 | Bahamas | |||
3085313 | 3085313 | 2021-04-05 | Japan | Ibaraki | 6892 | 127 | 6429 | 336 | 36.303588 | 140.319591 | 2021-04-06 04:20:32 | Ibaraki, Japan | ||
1290013 | 1290013 | 2021-03-29 | Japan | Fukushima | 2473 | 112 | 2025 | 336 | 37.378867 | 140.223295 | 2021-03-30 04:26:23 | Fukushima, Japan | ||
1881291 | 1881291 | 2021-03-26 | Suriname | 9088 | 177 | 8575 | 336 | 3.9193 | -56.0278 | 2021-03-27 05:25:04 | Suriname | |||
2781236 | 2781236 | 2021-03-24 | Russia | Sakhalin Oblast | 21918 | 38 | 21544 | 336 | 49.7219665 | 143.448533 | 2021-03-25 05:27:00 | Sakhalin Oblast, Russia | ||
1802316 | 1802316 | 2021-03-23 | Malaysia | Negeri Sembilan | 17008 | 31 | 16641 | 336 | 2.7258 | 101.9424 | 2021-03-24 05:25:40 | Negeri Sembilan, Malaysia | ||
1732285 | 1732285 | 2021-03-14 | Chile | Magallanes | 22533 | 333 | 21864 | 336 | -52.368 | -70.9863 | 2021-03-15 05:25:51 | Magallanes, Chile | ||
3671063 | 3671063 | 2021-03-06 | US | Washington | Lincoln | 53043 | 341 | 5 | 0 | 336 | 47.57705241 | -118.4194388 | 2021-03-07 05:21:54 | Lincoln, Washington, US |
3671057 | 3671057 | 2021-03-06 | US | Washington | Jefferson | 53031 | 338 | 2 | 0 | 336 | 47.75003077 | -123.56097040000002 | 2021-03-07 05:21:54 | Jefferson, Washington, US |
3670393 | 3670393 | 2021-03-06 | US | Puerto Rico | Santa Isabel | 72133 | 336 | 0 | 0 | 336 | 17.994525 | -66.388913 | 2021-03-07 05:21:54 | Santa Isabel, Puerto Rico, US |
1619684 | 1619684 | 2021-03-05 | US | Washington | Lincoln | 53043 | 341 | 5 | 0 | 336 | 47.57705241 | -118.4194388 | 2021-03-06 04:23:41 | Lincoln, Washington, US |
1619678 | 1619678 | 2021-03-05 | US | Washington | Jefferson | 53031 | 338 | 2 | 0 | 336 | 47.75003077 | -123.56097040000002 | 2021-03-06 04:23:41 | Jefferson, Washington, US |
2211089 | 2211089 | 2021-03-04 | US | Washington | Jefferson | 53031 | 338 | 2 | 0 | 336 | 47.75003077 | -123.56097040000002 | 2021-03-05 05:26:29 | Jefferson, Washington, US |
2186638 | 2186638 | 2021-02-26 | US | Texas | Culberson | 48109 | 317 | 7 | 0 | 336 | 31.44506775 | -104.5185739 | 2021-02-27 05:22:28 | Culberson, Texas, US |
1861060 | 1861060 | 2021-02-25 | US | Texas | Culberson | 48109 | 317 | 7 | 0 | 336 | 31.44506775 | -104.5185739 | 2021-02-26 05:22:40 | Culberson, Texas, US |
1939776 | 1939776 | 2021-02-23 | US | Virginia | Falls Church | 51610 | 343 | 7 | 0 | 336 | 38.88485255 | -77.17560759 | 2021-02-24 05:29:16 | Falls Church, Virginia, US |
1939506 | 1939506 | 2021-02-23 | US | Texas | Culberson | 48109 | 317 | 7 | 0 | 336 | 31.44506775 | -104.5185739 | 2021-02-24 05:29:16 | Culberson, Texas, US |
1938639 | 1938639 | 2021-02-23 | US | New Mexico | Hidalgo | 35023 | 345 | 9 | 0 | 336 | 31.91383467 | -108.7151824 | 2021-02-24 05:29:16 | Hidalgo, New Mexico, US |
532894 | 532894 | 2021-02-22 | US | New Mexico | Hidalgo | 35023 | 345 | 9 | 0 | 336 | 31.91383467 | -108.7151824 | 2021-02-23 05:23:41 | Hidalgo, New Mexico, US |
532820 | 532820 | 2021-02-22 | US | Nebraska | Stanton | 31167 | 345 | 9 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-02-23 05:23:41 | Stanton, Nebraska, US |
184154 | 184154 | 2021-02-21 | US | Nebraska | Stanton | 31167 | 345 | 9 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-02-22 05:24:21 | Stanton, Nebraska, US |
744428 | 744428 | 2021-02-20 | US | Nebraska | Stanton | 31167 | 345 | 9 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-02-21 05:24:33 | Stanton, Nebraska, US |
473526 | 473526 | 2021-02-19 | US | Nebraska | Stanton | 31167 | 345 | 9 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-02-20 05:22:51 | Stanton, Nebraska, US |
471172 | 471172 | 2021-02-19 | Cabo Verde | 14948 | 142 | 14470 | 336 | 16.5388 | -23.0418 | 2021-02-20 05:22:51 | Cabo Verde | |||
3604447 | 3604447 | 2021-02-17 | US | Virginia | Surry | 51181 | 341 | 5 | 0 | 336 | 37.11781893 | -76.88450012 | 2021-02-18 05:22:58 | Surry, Virginia, US |
3602789 | 3602789 | 2021-02-17 | US | Minnesota | Red Lake | 27125 | 340 | 4 | 0 | 336 | 47.87197525 | -96.09561104 | 2021-02-18 05:22:58 | Red Lake, Minnesota, US |
2286832 | 2286832 | 2021-02-14 | US | Virginia | Surry | 51181 | 341 | 5 | 0 | 336 | 37.11781893 | -76.88450012 | 2021-02-15 05:24:49 | Surry, Virginia, US |
2677607 | 2677607 | 2021-02-13 | Chad | 3622 | 128 | 3158 | 336 | 15.4542 | 18.7322 | 2021-02-14 05:23:43 | Chad | |||
3542865 | 3542865 | 2021-02-12 | US | Virginia | Surry | 51181 | 341 | 5 | 0 | 336 | 37.11781893 | -76.88450012 | 2021-02-13 05:22:12 | Surry, Virginia, US |
3541119 | 3541119 | 2021-02-12 | US | Michigan | Montmorency | 26119 | 353 | 17 | 0 | 336 | 45.0275929 | -84.12696227 | 2021-02-13 05:22:12 | Montmorency, Michigan, US |
2641235 | 2641235 | 2021-02-11 | US | West Virginia | Wirt | 54105 | 338 | 2 | 0 | 336 | 39.02775007 | -81.37473928 | 2021-02-12 05:23:29 | Wirt, West Virginia, US |
2638631 | 2638631 | 2021-02-11 | US | Idaho | Bear Lake | 16007 | 338 | 2 | 0 | 336 | 42.28269683 | -111.32892379999998 | 2021-02-12 05:23:29 | Bear Lake, Idaho, US |
3979486 | 3979486 | 2021-02-10 | US | Idaho | Bear Lake | 16007 | 338 | 2 | 0 | 336 | 42.28269683 | -111.32892379999998 | 2021-02-11 05:23:55 | Bear Lake, Idaho, US |
1529661 | 1529661 | 2021-02-09 | US | Minnesota | Unassigned | 90027 | 404 | 68 | 0 | 336 | 48.77754106 | 0.0 | 2021-02-10 05:22:41 | Unassigned, Minnesota, US |
977032 | 977032 | 2021-02-06 | US | Nebraska | Stanton | 31167 | 345 | 9 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-02-07 05:23:00 | Stanton, Nebraska, US |
792924 | 792924 | 2021-02-04 | US | Oklahoma | Ellis | 40045 | 337 | 1 | 0 | 336 | 36.2180194 | -99.75324573 | 2021-02-05 05:22:38 | Ellis, Oklahoma, US |
340295 | 340295 | 2021-02-03 | Japan | Kumamoto | 3360 | 63 | 2961 | 336 | 32.608154 | 130.74523100000002 | 2021-02-04 05:22:26 | Kumamoto, Japan | ||
1687808 | 1687808 | 2021-02-02 | US | Virginia | Charles City | 51036 | 345 | 9 | 0 | 336 | 37.35358063 | -77.05634116 | 2021-02-03 05:22:52 | Charles City, Virginia, US |
1679778 | 1679778 | 2021-02-01 | US | Virginia | Charles City | 51036 | 345 | 9 | 0 | 336 | 37.35358063 | -77.05634116 | 2021-02-02 05:22:49 | Charles City, Virginia, US |
1678585 | 1678585 | 2021-02-01 | US | Nebraska | Stanton | 31167 | 344 | 8 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-02-02 05:22:49 | Stanton, Nebraska, US |
1461873 | 1461873 | 2021-01-31 | US | Nebraska | Stanton | 31167 | 344 | 8 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-02-01 05:22:53 | Stanton, Nebraska, US |
2213781 | 2213781 | 2021-01-30 | US | Nebraska | Stanton | 31167 | 344 | 8 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-01-31 05:22:42 | Stanton, Nebraska, US |
2482429 | 2482429 | 2021-01-28 | US | Arkansas | Calhoun | 5013 | 338 | 2 | 0 | 336 | 33.55598792 | -92.49974403 | 2021-01-29 05:22:23 | Calhoun, Arkansas, US |
3155559 | 3155559 | 2021-01-27 | US | Missouri | Shelby | 29205 | 341 | 5 | 0 | 336 | 39.79742518 | -92.07634971 | 2021-01-28 05:22:24 | Shelby, Missouri, US |
3155271 | 3155271 | 2021-01-27 | US | Michigan | Ontonagon | 26131 | 354 | 18 | 0 | 336 | 46.665226200000006 | -89.31390481 | 2021-01-28 05:22:24 | Ontonagon, Michigan, US |
14294 | 14294 | 2021-01-26 | US | Missouri | Shelby | 29205 | 341 | 5 | 0 | 336 | 39.79742518 | -92.07634971 | 2021-01-27 05:23:41 | Shelby, Missouri, US |
13870 | 13870 | 2021-01-26 | US | Louisiana | Tensas | 22107 | 341 | 5 | 0 | 336 | 32.00760749 | -91.32915234 | 2021-01-27 05:23:41 | Tensas, Louisiana, US |
12367 | 12367 | 2021-01-26 | Japan | Nara | 2843 | 36 | 2471 | 336 | 34.317451 | 135.871644 | 2021-01-27 05:23:41 | Nara, Japan | ||
2570821 | 2570821 | 2021-01-25 | US | Texas | Mason | 48319 | 303 | 4 | 0 | 336 | 30.71780434 | -99.22629416 | 2021-01-26 05:22:02 | Mason, Texas, US |
1761410 | 1761410 | 2021-01-24 | US | Nebraska | Stanton | 31167 | 344 | 8 | 0 | 336 | 41.9169835 | -97.19394708 | 2021-01-25 05:22:16 | Stanton, Nebraska, US |
2429037 | 2429037 | 2021-01-23 | US | Nevada | Lincoln | 32017 | 337 | 1 | 0 | 336 | 37.64268459 | -114.8790388 | 2021-01-24 05:22:35 | Lincoln, Nevada, US |
1096977 | 1096977 | 2021-01-20 | US | South Dakota | Potter | 46107 | 339 | 3 | 0 | 336 | 45.06583079 | -99.95498503 | 2021-01-21 05:22:01 | Potter, South Dakota, US |
1095987 | 1095987 | 2021-01-20 | US | Missouri | Holt | 29087 | 346 | 10 | 0 | 336 | 40.09799248 | -95.2163888 | 2021-01-21 05:22:01 | Holt, Missouri, US |
911334 | 911334 | 2021-01-19 | US | Texas | Mason | 48319 | 303 | 4 | 0 | 336 | 30.71780434 | -99.22629416 | 2021-01-20 05:21:54 | Mason, Texas, US |
911067 | 911067 | 2021-01-19 | US | South Dakota | Potter | 46107 | 339 | 3 | 0 | 336 | 45.06583079 | -99.95498503 | 2021-01-20 05:21:54 | Potter, South Dakota, US |
909456 | 909456 | 2021-01-19 | US | Kansas | Gove | 20063 | 355 | 19 | 0 | 336 | 38.91588178 | -100.4829321 | 2021-01-20 05:21:54 | Gove, Kansas, US |
238519 | 238519 | 2021-01-18 | US | Kansas | Gove | 20063 | 355 | 19 | 0 | 336 | 38.91588178 | -100.4829321 | 2021-01-19 05:22:15 | Gove, Kansas, US |
3506117 | 3506117 | 2021-01-17 | US | Puerto Rico | Penuelas | 72111 | 336 | 0 | 0 | 336 | 18.059645 | -66.721572 | 2021-01-18 05:22:34 | Penuelas, Puerto Rico, US |
2629062 | 2629062 | 2021-01-10 | US | Texas | Reagan | 48383 | 297 | 7 | 0 | 336 | 31.36607041 | -101.5232659 | 2021-01-11 05:21:50 | Reagan, Texas, US |
2626738 | 2626738 | 2021-01-10 | US | Georgia | Talbot | 13263 | 346 | 10 | 0 | 336 | 32.69642758 | -84.53351366 | 2021-01-11 05:21:50 | Talbot, Georgia, US |
2626470 | 2626470 | 2021-01-10 | US | Colorado | Conejos | 8021 | 384 | 4 | 0 | 336 | 37.201606 | -106.19174879999998 | 2021-01-11 05:21:50 | Conejos, Colorado, US |
3903150 | 3903150 | 2021-01-09 | US | Texas | Reagan | 48383 | 297 | 7 | 0 | 336 | 31.36607041 | -101.5232659 | 2021-01-10 05:22:12 | Reagan, Texas, US |
3902661 | 3902661 | 2021-01-09 | US | Puerto Rico | Adjuntas | 72001 | 336 | 0 | 0 | 336 | 18.180117000000006 | -66.754367 | 2021-01-10 05:22:12 | Adjuntas, Puerto Rico, US |
3901324 | 3901324 | 2021-01-09 | US | Kentucky | Bracken | 21023 | 339 | 3 | 0 | 336 | 38.69158994 | -84.08532444 | 2021-01-10 05:22:12 | Bracken, Kentucky, US |
3900791 | 3900791 | 2021-01-09 | US | Georgia | Marion | 13197 | 346 | 10 | 0 | 336 | 32.3483402 | -84.52733571 | 2021-01-10 05:22:12 | Marion, Georgia, US |
3900558 | 3900558 | 2021-01-09 | US | Colorado | Conejos | 8021 | 383 | 4 | 0 | 336 | 37.201606 | -106.19174879999998 | 2021-01-10 05:22:12 | Conejos, Colorado, US |
157341 | 157341 | 2021-01-08 | US | Virginia | Madison | 51113 | 340 | 4 | 0 | 336 | 38.41531222 | -78.28220331 | 2021-01-09 05:22:18 | Madison, Virginia, US |
156684 | 156684 | 2021-01-08 | US | Puerto Rico | Adjuntas | 72001 | 336 | 0 | 0 | 336 | 18.180117000000006 | -66.754367 | 2021-01-09 05:22:18 | Adjuntas, Puerto Rico, 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]);