johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
389 rows where active = 589 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306213 | 1306213 | 2021-07-27 | Latvia | 138572 | 2552 | 135431 | 589 | 56.8796 | 24.6032 | 2021-07-28 04:21:39 | Latvia | |||
3705913 | 3705913 | 2021-07-17 | Chile | Los Lagos | 86574 | 1285 | 84700 | 589 | -41.9198 | -72.1416 | 2021-07-18 04:22:07 | Los Lagos, Chile | ||
2947255 | 2947255 | 2021-07-16 | France | Saint Barthelemy | 1052 | 1 | 462 | 589 | 17.9 | -62.8333 | 2021-07-17 04:22:22 | Saint Barthelemy, France | ||
295911 | 295911 | 2021-07-15 | France | Saint Barthelemy | 1052 | 1 | 462 | 589 | 17.9 | -62.8333 | 2021-07-16 04:21:22 | Saint Barthelemy, France | ||
3631856 | 3631856 | 2021-07-14 | France | Saint Barthelemy | 1052 | 1 | 462 | 589 | 17.9 | -62.8333 | 2021-07-15 04:21:48 | Saint Barthelemy, France | ||
578731 | 578731 | 2021-07-13 | France | Saint Barthelemy | 1052 | 1 | 462 | 589 | 17.9 | -62.8333 | 2021-07-14 04:21:35 | Saint Barthelemy, France | ||
3740980 | 3740980 | 2021-07-12 | France | Saint Barthelemy | 1052 | 1 | 462 | 589 | 17.9 | -62.8333 | 2021-07-13 04:21:18 | Saint Barthelemy, France | ||
3659493 | 3659493 | 2021-07-11 | France | Saint Barthelemy | 1052 | 1 | 462 | 589 | 17.9 | -62.8333 | 2021-07-12 04:21:34 | Saint Barthelemy, France | ||
2765006 | 2765006 | 2021-07-01 | Mauritania | 20894 | 489 | 19816 | 589 | 21.0079 | -10.9408 | 2021-07-02 04:21:47 | Mauritania | |||
2295233 | 2295233 | 2021-06-24 | Chile | Arica y Parinacota | 24638 | 473 | 23576 | 589 | -18.594 | -69.4785 | 2021-06-25 04:21:33 | Arica y Parinacota, Chile | ||
2887988 | 2887988 | 2021-06-20 | Ukraine | Chernihiv Oblast | 57417 | 1338 | 55490 | 589 | 51.4982 | 31.2893 | 2021-06-21 04:21:41 | Chernihiv Oblast, Ukraine | ||
107246 | 107246 | 2021-06-19 | Chile | Tarapaca | 38372 | 714 | 37069 | 589 | -19.9232 | -69.5132 | 2021-06-20 04:21:48 | Tarapaca, Chile | ||
825621 | 825621 | 2021-06-06 | Japan | Shizuoka | 8638 | 139 | 7910 | 589 | 34.916975 | 138.40778400000002 | 2021-06-07 04:22:51 | Shizuoka, Japan | ||
2586102 | 2586102 | 2021-06-05 | Mozambique | 71082 | 837 | 69656 | 589 | -18.665695 | 35.529562 | 2021-06-06 04:24:03 | Mozambique | |||
2318938 | 2318938 | 2021-06-04 | Ukraine | Sevastopol* | 15036 | 689 | 13758 | 589 | 44.6054 | 33.522 | 2021-06-05 04:23:03 | Sevastopol*, Ukraine | ||
1310178 | 1310178 | 2021-05-26 | Japan | Gunma | 7702 | 133 | 6980 | 589 | 36.504479 | 138.985605 | 2021-05-27 04:20:59 | Gunma, Japan | ||
1551978 | 1551978 | 2021-05-08 | Japan | Fukushima | 3788 | 127 | 3072 | 589 | 37.378867 | 140.223295 | 2021-05-09 04:20:35 | Fukushima, Japan | ||
645735 | 645735 | 2021-05-05 | Chile | Arica y Parinacota | 20514 | 401 | 19524 | 589 | -18.594 | -69.4785 | 2021-05-06 04:20:38 | Arica y Parinacota, Chile | ||
2450781 | 2450781 | 2021-05-02 | Japan | Gunma | 6175 | 104 | 5482 | 589 | 36.504479 | 138.985605 | 2021-05-03 04:20:39 | Gunma, Japan | ||
379964 | 379964 | 2021-04-30 | Canada | Nova Scotia | 2427 | 67 | 1771 | 589 | 44.682 | -63.7443 | 2021-05-01 04:20:47 | Nova Scotia, Canada | ||
3702124 | 3702124 | 2021-04-27 | Japan | Ibaraki | 7970 | 133 | 7248 | 589 | 36.303588 | 140.319591 | 2021-04-28 04:20:32 | Ibaraki, Japan | ||
2645894 | 2645894 | 2021-04-08 | Pakistan | Balochistan | 20097 | 213 | 19295 | 589 | 28.328492 | 65.898403 | 2021-04-09 04:21:13 | Balochistan, Pakistan | ||
3085160 | 3085160 | 2021-04-05 | Colombia | Sucre | 23470 | 862 | 22019 | 589 | 8.814 | -74.7233 | 2021-04-06 04:20:32 | Sucre, Colombia | ||
641599 | 641599 | 2021-03-31 | Malaysia | Kelantan | 6250 | 23 | 5638 | 589 | 6.1254 | 102.2381 | 2021-04-01 04:27:05 | Kelantan, Malaysia | ||
3667570 | 3667570 | 2021-03-06 | India | Himachal Pradesh | 59059 | 997 | 57473 | 589 | 31.927213 | 77.233081 | 2021-03-07 05:21:54 | Himachal Pradesh, India | ||
1618531 | 1618531 | 2021-03-05 | US | North Carolina | Camden | 37029 | 594 | 5 | 0 | 589 | 36.33804939 | -76.15568396 | 2021-03-06 04:23:41 | Camden, North Carolina, US |
1616191 | 1616191 | 2021-03-05 | India | Himachal Pradesh | 59014 | 997 | 57428 | 589 | 31.927213 | 77.233081 | 2021-03-06 04:23:41 | Himachal Pradesh, India | ||
2209748 | 2209748 | 2021-03-04 | US | Nebraska | Nemaha | 31127 | 602 | 13 | 0 | 589 | 40.38514847 | -95.85433992 | 2021-03-05 05:26:29 | Nemaha, Nebraska, US |
1001196 | 1001196 | 2021-03-01 | US | Puerto Rico | Orocovis | 72107 | 589 | 0 | 0 | 589 | 18.215046 | -66.433604 | 2021-03-02 05:23:30 | Orocovis, Puerto Rico, US |
3068761 | 3068761 | 2021-02-27 | US | Puerto Rico | Quebradillas | 72115 | 589 | 0 | 0 | 589 | 18.439692 | -66.926113 | 2021-02-28 05:22:20 | Quebradillas, Puerto Rico, US |
2186345 | 2186345 | 2021-02-26 | US | Puerto Rico | Quebradillas | 72115 | 589 | 0 | 0 | 589 | 18.439692 | -66.926113 | 2021-02-27 05:22:28 | Quebradillas, Puerto Rico, US |
1937917 | 1937917 | 2021-02-23 | US | Kentucky | Trimble | 21223 | 592 | 3 | 0 | 589 | 38.61056487 | -85.33775972 | 2021-02-24 05:29:16 | Trimble, Kentucky, US |
3601932 | 3601932 | 2021-02-17 | US | Georgia | Wheeler | 13309 | 611 | 22 | 0 | 589 | 32.12009104 | -82.72574721 | 2021-02-18 05:22:58 | Wheeler, Georgia, US |
3601816 | 3601816 | 2021-02-17 | US | Georgia | Crawford | 13079 | 603 | 14 | 0 | 589 | 32.71391813 | -83.98061238 | 2021-02-18 05:22:58 | Crawford, Georgia, US |
3052217 | 3052217 | 2021-02-16 | US | Nebraska | Burt | 31021 | 599 | 10 | 0 | 589 | 41.85056773 | -96.32605633 | 2021-02-17 05:23:10 | Burt, Nebraska, US |
3051067 | 3051067 | 2021-02-16 | US | Georgia | Wheeler | 13309 | 611 | 22 | 0 | 589 | 32.12009104 | -82.72574721 | 2021-02-17 05:23:10 | Wheeler, Georgia, US |
1341399 | 1341399 | 2021-02-15 | US | Texas | Jim Hogg | 48247 | 682 | 14 | 0 | 589 | 27.04453923 | -98.6968187 | 2021-02-16 05:24:38 | Jim Hogg, Texas, US |
1339166 | 1339166 | 2021-02-15 | US | Georgia | Wheeler | 13309 | 611 | 22 | 0 | 589 | 32.12009104 | -82.72574721 | 2021-02-16 05:24:38 | Wheeler, Georgia, US |
2286928 | 2286928 | 2021-02-14 | US | West Virginia | Ritchie | 54085 | 598 | 9 | 0 | 589 | 39.18094587 | -81.06356878 | 2021-02-15 05:24:49 | Ritchie, West Virginia, US |
2286550 | 2286550 | 2021-02-14 | US | Texas | Jim Hogg | 48247 | 682 | 14 | 0 | 589 | 27.04453923 | -98.6968187 | 2021-02-15 05:24:49 | Jim Hogg, Texas, US |
2640608 | 2640608 | 2021-02-11 | US | South Dakota | Moody | 46101 | 605 | 16 | 0 | 589 | 44.02266214 | -96.67081159 | 2021-02-12 05:23:29 | Moody, South Dakota, US |
3981899 | 3981899 | 2021-02-10 | US | Virginia | Essex | 51057 | 593 | 4 | 0 | 589 | 37.93357639 | -76.94230311 | 2021-02-11 05:23:55 | Essex, Virginia, US |
3981771 | 3981771 | 2021-02-10 | US | Texas | Red River | 48387 | 665 | 34 | 0 | 589 | 33.61886692 | -95.04841765 | 2021-02-11 05:23:55 | Red River, Texas, US |
3981463 | 3981463 | 2021-02-10 | US | South Dakota | Moody | 46101 | 605 | 16 | 0 | 589 | 44.02266214 | -96.67081159 | 2021-02-11 05:23:55 | Moody, South Dakota, US |
3980025 | 3980025 | 2021-02-10 | US | Kentucky | Owen | 21187 | 596 | 7 | 0 | 589 | 38.51679143 | -84.82404619 | 2021-02-11 05:23:55 | Owen, Kentucky, US |
3979104 | 3979104 | 2021-02-10 | US | Arkansas | Woodruff | 5147 | 597 | 8 | 0 | 589 | 35.18902527 | -91.2439489 | 2021-02-11 05:23:55 | Woodruff, Arkansas, US |
1530001 | 1530001 | 2021-02-09 | US | Nebraska | Richardson | 31147 | 605 | 16 | 0 | 589 | 40.1247415 | -95.71755036 | 2021-02-10 05:22:41 | Richardson, Nebraska, US |
1529345 | 1529345 | 2021-02-09 | US | Kentucky | Owen | 21187 | 596 | 7 | 0 | 589 | 38.51679143 | -84.82404619 | 2021-02-10 05:22:41 | Owen, Kentucky, US |
1675771 | 1675771 | 2021-02-07 | US | Virginia | Covington | 51580 | 593 | 4 | 0 | 589 | 37.7824656 | -79.98631446 | 2021-02-08 05:22:39 | Covington, Virginia, US |
1675165 | 1675165 | 2021-02-07 | US | Puerto Rico | Anasco | 72011 | 589 | 0 | 0 | 589 | 18.287985 | -67.120611 | 2021-02-08 05:22:39 | Anasco, Puerto Rico, US |
1674005 | 1674005 | 2021-02-07 | US | Maine | Knox | 23013 | 593 | 4 | 0 | 589 | 44.11486325 | -69.10529169 | 2021-02-08 05:22:39 | Knox, Maine, US |
1672361 | 1672361 | 2021-02-07 | Gabon | 11457 | 71 | 10797 | 589 | -0.8037 | 11.6094 | 2021-02-08 05:22:39 | Gabon | |||
976466 | 976466 | 2021-02-06 | US | Maine | Knox | 23013 | 593 | 4 | 0 | 589 | 44.11486325 | -69.10529169 | 2021-02-07 05:23:00 | Knox, Maine, US |
974822 | 974822 | 2021-02-06 | Gabon | 11457 | 71 | 10797 | 589 | -0.8037 | 11.6094 | 2021-02-07 05:23:00 | Gabon | |||
1591549 | 1591549 | 2021-02-05 | US | Virginia | Northumberland | 51133 | 602 | 13 | 0 | 589 | 37.89202088 | -76.41949732 | 2021-02-06 05:23:55 | Northumberland, Virginia, US |
1588080 | 1588080 | 2021-02-05 | Gabon | 11457 | 71 | 10797 | 589 | -0.8037 | 11.6094 | 2021-02-06 05:23:55 | Gabon | |||
1679741 | 1679741 | 2021-02-01 | US | Vermont | Addison | 50001 | 597 | 8 | 0 | 589 | 44.03217337 | -73.14130877 | 2021-02-02 05:22:49 | Addison, Vermont, US |
2571103 | 2571103 | 2021-01-25 | US | Washington | Klickitat | 53039 | 593 | 4 | 0 | 589 | 45.87325839 | -120.7913598 | 2021-01-26 05:22:02 | Klickitat, Washington, US |
2570961 | 2570961 | 2021-01-25 | US | Virginia | Bland | 51021 | 596 | 7 | 0 | 589 | 37.13128068 | -81.13599391 | 2021-01-26 05:22:02 | Bland, Virginia, US |
2567455 | 2567455 | 2021-01-25 | Chile | Magallanes | 19430 | 266 | 18575 | 589 | -52.368 | -70.9863 | 2021-01-26 05:22:02 | Magallanes, Chile | ||
2468039 | 2468039 | 2021-01-22 | US | Iowa | Taylor | 19173 | 598 | 9 | 0 | 589 | 40.73710579 | -94.69778563 | 2021-01-23 05:22:03 | Taylor, Iowa, US |
2467396 | 2467396 | 2021-01-22 | US | Colorado | Archuleta | 8007 | 605 | 1 | 0 | 589 | 37.19474156 | -107.0476867 | 2021-01-23 05:22:03 | Archuleta, Colorado, US |
2466815 | 2466815 | 2021-01-22 | Japan | Hiroshima | 4577 | 82 | 3906 | 589 | 34.605309000000005 | 132.788719 | 2021-01-23 05:22:03 | Hiroshima, Japan | ||
437077 | 437077 | 2021-01-21 | US | Minnesota | Koochiching | 27071 | 599 | 10 | 0 | 589 | 48.24539665 | -93.78352843 | 2021-01-22 05:22:10 | Koochiching, Minnesota, US |
910255 | 910255 | 2021-01-19 | US | Nebraska | Jefferson | 31095 | 590 | 1 | 0 | 589 | 40.17584531 | -97.142601 | 2021-01-20 05:21:54 | Jefferson, Nebraska, US |
239318 | 239318 | 2021-01-18 | US | Nebraska | Jefferson | 31095 | 590 | 1 | 0 | 589 | 40.17584531 | -97.142601 | 2021-01-19 05:22:15 | Jefferson, Nebraska, US |
239109 | 239109 | 2021-01-18 | US | Missouri | Caldwell | 29025 | 597 | 8 | 0 | 589 | 39.65620858 | -93.98308093 | 2021-01-19 05:22:15 | Caldwell, Missouri, US |
3505378 | 3505378 | 2021-01-17 | US | Montana | Stillwater | 30095 | 599 | 10 | 0 | 589 | 45.67071407 | -109.3950061 | 2021-01-18 05:22:34 | Stillwater, Montana, US |
3503208 | 3503208 | 2021-01-17 | Colombia | La Guajira | 15019 | 574 | 13856 | 589 | 11.3548 | -72.5205 | 2021-01-18 05:22:34 | La Guajira, Colombia | ||
3503142 | 3503142 | 2021-01-17 | Chile | Arica y Parinacota | 11780 | 244 | 10947 | 589 | -18.594 | -69.4785 | 2021-01-18 05:22:34 | Arica y Parinacota, Chile | ||
3103309 | 3103309 | 2021-01-16 | US | Missouri | Caldwell | 29025 | 596 | 7 | 0 | 589 | 39.65620858 | -93.98308093 | 2021-01-17 05:22:17 | Caldwell, Missouri, US |
3517059 | 3517059 | 2021-01-15 | US | Michigan | Missaukee | 26113 | 602 | 13 | 0 | 589 | 44.33772443 | -85.09256478 | 2021-01-16 05:22:40 | Missaukee, Michigan, US |
3880076 | 3880076 | 2021-01-14 | US | Arkansas | Montgomery | 5097 | 611 | 22 | 0 | 589 | 34.53704874 | -93.65824478 | 2021-01-15 05:22:24 | Montgomery, Arkansas, US |
3309334 | 3309334 | 2021-01-13 | US | Indiana | Switzerland | 18155 | 595 | 6 | 0 | 589 | 38.82767338 | -85.03022429 | 2021-01-14 05:22:32 | Switzerland, Indiana, US |
3309230 | 3309230 | 2021-01-13 | US | Illinois | Pulaski | 17153 | 592 | 3 | 0 | 589 | 37.22631423 | -89.13085001 | 2021-01-14 05:22:32 | Pulaski, Illinois, US |
776549 | 776549 | 2021-01-12 | US | New Mexico | Sierra | 35051 | 628 | 39 | 0 | 589 | 33.13028233 | -107.1925893 | 2021-01-13 05:22:15 | Sierra, New Mexico, US |
776069 | 776069 | 2021-01-12 | US | Minnesota | Lake | 27075 | 604 | 15 | 0 | 589 | 47.64270764 | -91.44557998 | 2021-01-13 05:22:15 | Lake, Minnesota, US |
775169 | 775169 | 2021-01-12 | US | Georgia | Lanier | 13173 | 599 | 10 | 0 | 589 | 31.038285700000007 | -83.06472457 | 2021-01-13 05:22:15 | Lanier, Georgia, US |
774357 | 774357 | 2021-01-12 | Japan | Gunma | 2948 | 56 | 2303 | 589 | 36.504479 | 138.985605 | 2021-01-13 05:22:15 | Gunma, Japan | ||
190945 | 190945 | 2021-01-11 | US | Georgia | Treutlen | 13283 | 605 | 16 | 0 | 589 | 32.40422134 | -82.56904553 | 2021-01-12 05:22:15 | Treutlen, Georgia, US |
155527 | 155527 | 2021-01-08 | US | Maine | Hancock | 23009 | 611 | 22 | 0 | 589 | 44.59816444 | -68.38401854 | 2021-01-09 05:22:18 | Hancock, Maine, US |
2543337 | 2543337 | 2021-01-07 | US | Missouri | Oregon | 29149 | 592 | 3 | 0 | 589 | 36.68710164 | -91.4033755 | 2021-01-08 05:22:42 | Oregon, Missouri, US |
2542242 | 2542242 | 2021-01-07 | US | Georgia | Miller | 13201 | 592 | 3 | 0 | 589 | 31.16568912 | -84.73151117 | 2021-01-08 05:22:42 | Miller, Georgia, US |
1065342 | 1065342 | 2021-01-04 | US | West Virginia | Pleasants | 54073 | 595 | 6 | 0 | 589 | 39.37091679 | -81.16771771 | 2021-01-05 05:21:49 | Pleasants, West Virginia, US |
1065035 | 1065035 | 2021-01-04 | US | Texas | Presidio | 48377 | 540 | 16 | 0 | 589 | 29.99954402 | -104.2408079 | 2021-01-05 05:21:49 | Presidio, Texas, US |
1063053 | 1063053 | 2021-01-04 | US | Iowa | Lucas | 19117 | 597 | 8 | 0 | 589 | 41.02958964 | -93.32780803 | 2021-01-05 05:21:49 | Lucas, Iowa, US |
1138604 | 1138604 | 2021-01-01 | US | Minnesota | Lac qui Parle | 27073 | 603 | 14 | 0 | 589 | 44.9973857 | -96.17488219 | 2021-01-02 05:22:33 | Lac qui Parle, Minnesota, US |
1137988 | 1137988 | 2021-01-01 | US | Indiana | Martin | 18101 | 601 | 12 | 0 | 589 | 38.7099921 | -86.80373186 | 2021-01-02 05:22:33 | Martin, Indiana, US |
3697210 | 3697210 | 2020-12-31 | US | Minnesota | Lac qui Parle | 27073 | 603 | 14 | 0 | 589 | 44.9973857 | -96.17488219 | 2021-01-01 05:23:07 | Lac qui Parle, Minnesota, US |
3696637 | 3696637 | 2020-12-31 | US | Iowa | Adair | 19001 | 606 | 17 | 0 | 589 | 41.33075609 | -94.47105874 | 2021-01-01 05:23:07 | Adair, Iowa, US |
3695498 | 3695498 | 2020-12-31 | Japan | Gifu | 2292 | 34 | 1669 | 589 | 35.778671 | 137.055925 | 2021-01-01 05:23:07 | Gifu, Japan | ||
1012193 | 1012193 | 2020-12-30 | US | Missouri | Douglas | 29067 | 608 | 19 | 0 | 589 | 36.9325593 | -92.49905109 | 2020-12-31 05:22:49 | Douglas, Missouri, US |
767215 | 767215 | 2020-12-29 | US | Georgia | Wilkinson | 13319 | 607 | 18 | 0 | 589 | 32.80291082 | -83.17140684 | 2020-12-30 05:22:34 | Wilkinson, Georgia, US |
3781221 | 3781221 | 2020-12-27 | US | Virginia | Dickenson | 51051 | 593 | 4 | 0 | 589 | 37.12560977 | -82.35124171 | 2020-12-28 05:22:06 | Dickenson, Virginia, US |
3691753 | 3691753 | 2020-12-24 | Sierra Leone | 2531 | 76 | 1866 | 589 | 8.460555000000001 | -11.779889 | 2020-12-25 05:22:48 | Sierra Leone | |||
3691270 | 3691270 | 2020-12-24 | Chile | Los Rios | 8206 | 80 | 7537 | 589 | -40.231 | -72.3311 | 2020-12-25 05:22:48 | Los Rios, Chile | ||
3772097 | 3772097 | 2020-12-22 | US | New York | Delaware | 36025 | 596 | 7 | 0 | 589 | 42.19837623 | -74.96709306 | 2020-12-23 05:22:03 | Delaware, New York, US |
3771049 | 3771049 | 2020-12-22 | US | Iowa | Davis | 19051 | 607 | 18 | 0 | 589 | 40.74773536 | -92.41005468 | 2020-12-23 05:22:03 | Davis, Iowa, US |
1904062 | 1904062 | 2020-12-18 | US | South Dakota | Tripp | 46123 | 599 | 10 | 0 | 589 | 43.34459388 | -99.8854891 | 2020-12-19 05:27:52 | Tripp, South Dakota, US |
1901956 | 1901956 | 2020-12-18 | US | Georgia | Evans | 13109 | 602 | 13 | 0 | 589 | 32.15328841 | -81.8870105 | 2020-12-19 05:27:52 | Evans, Georgia, 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]);