johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
514 rows where active = 422 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3299823 | 3299823 | 2021-07-30 | Ukraine | Zaporizhia Oblast | 105237 | 2457 | 102358 | 422 | 47.8388 | 35.1396 | 2021-07-31 04:21:35 | Zaporizhia Oblast, Ukraine | ||
3218168 | 3218168 | 2021-07-26 | Cote d'Ivoire | 49647 | 324 | 48901 | 422 | 7.54 | -5.5471 | 2021-07-27 04:21:18 | Cote d'Ivoire | |||
3706163 | 3706163 | 2021-07-17 | Japan | Shizuoka | 9813 | 153 | 9238 | 422 | 34.916975 | 138.40778400000002 | 2021-07-18 04:22:07 | Shizuoka, Japan | ||
1440921 | 1440921 | 2021-07-07 | Togo | 14140 | 132 | 13586 | 422 | 8.6195 | 0.8248 | 2021-07-08 04:21:26 | Togo | |||
1440376 | 1440376 | 2021-07-07 | Chile | Nuble | 34419 | 579 | 33418 | 422 | -36.7226 | -71.7622 | 2021-07-08 04:21:26 | Nuble, Chile | ||
1165174 | 1165174 | 2021-07-04 | Japan | Fukuoka | 35638 | 522 | 34694 | 422 | 33.526032 | 130.666949 | 2021-07-05 04:21:28 | Fukuoka, Japan | ||
2423032 | 2423032 | 2021-06-23 | Pakistan | Azad Jammu and Kashmir | 20064 | 574 | 19068 | 422 | 34.027401 | 73.947253 | 2021-06-24 04:21:55 | Azad Jammu and Kashmir, Pakistan | ||
3359002 | 3359002 | 2021-06-21 | Tajikistan | 13731 | 91 | 13218 | 422 | 38.861 | 71.2761 | 2021-06-22 04:21:34 | Tajikistan | |||
1708288 | 1708288 | 2021-06-02 | Israel | 839517 | 6415 | 832680 | 422 | 31.046051 | 34.851612 | 2021-06-03 04:23:32 | Israel | |||
1806535 | 1806535 | 2021-05-27 | Chile | Magallanes | 27581 | 399 | 26760 | 422 | -52.368 | -70.9863 | 2021-05-28 04:20:36 | Magallanes, Chile | ||
1413064 | 1413064 | 2021-05-24 | Japan | Fukushima | 4468 | 133 | 3913 | 422 | 37.378867 | 140.223295 | 2021-05-25 04:21:08 | Fukushima, Japan | ||
2390799 | 2390799 | 2021-05-18 | Japan | Niigata | 2892 | 34 | 2436 | 422 | 37.521819 | 138.918647 | 2021-05-19 04:20:42 | Niigata, Japan | ||
646156 | 646156 | 2021-05-05 | Russia | Kamchatka Krai | 14494 | 230 | 13842 | 422 | 57.1914882 | 160.03838190000005 | 2021-05-06 04:20:38 | Kamchatka Krai, Russia | ||
2454457 | 2454457 | 2021-05-02 | Malaysia | Terengganu | 4421 | 15 | 3984 | 422 | 5.3117 | 103.1324 | 2021-05-03 04:20:39 | Terengganu, Malaysia | ||
380383 | 380383 | 2021-04-30 | Russia | Buryatia Republic | 37144 | 846 | 35876 | 422 | 52.7182426 | 109.492143 | 2021-05-01 04:20:47 | Buryatia Republic, Russia | ||
3393599 | 3393599 | 2021-04-28 | Russia | Kamchatka Krai | 14435 | 230 | 13783 | 422 | 57.1914882 | 160.03838190000005 | 2021-04-29 04:20:55 | Kamchatka Krai, Russia | ||
3702315 | 3702315 | 2021-04-27 | Russia | Kamchatka Krai | 14427 | 230 | 13775 | 422 | 57.1914882 | 160.03838190000005 | 2021-04-28 04:20:32 | Kamchatka Krai, Russia | ||
888190 | 888190 | 2021-04-26 | Malta | 30189 | 413 | 29354 | 422 | 35.9375 | 14.3754 | 2021-04-27 04:20:52 | Malta | |||
1409047 | 1409047 | 2021-04-23 | Japan | Ehime | 2132 | 29 | 1681 | 422 | 33.624835 | 132.856842 | 2021-04-24 04:20:38 | Ehime, Japan | ||
983151 | 983151 | 2021-04-17 | Russia | Kalmykia Republic | 20269 | 330 | 19517 | 422 | 46.2313018 | 45.3275745 | 2021-04-18 04:20:41 | Kalmykia Republic, Russia | ||
2983438 | 2983438 | 2021-04-10 | Russia | Adygea Republic | 14209 | 168 | 13619 | 422 | 44.6939006 | 40.1520421 | 2021-04-11 04:20:56 | Adygea Republic, Russia | ||
2359327 | 2359327 | 2021-03-08 | Colombia | Sucre | 20928 | 788 | 19718 | 422 | 8.814 | -74.7233 | 2021-03-09 05:28:19 | Sucre, Colombia | ||
3669154 | 3669154 | 2021-03-06 | US | Louisiana | Unassigned | 90022 | 422 | 0 | 0 | 422 | 32.83121059 | 0.0 | 2021-03-07 05:21:54 | Unassigned, Louisiana, US |
3667471 | 3667471 | 2021-03-06 | Colombia | Huila | 49931 | 1739 | 47770 | 422 | 2.5359 | -75.5277 | 2021-03-07 05:21:54 | Huila, Colombia | ||
1617775 | 1617775 | 2021-03-05 | US | Louisiana | Unassigned | 90022 | 422 | 0 | 0 | 422 | 32.83121059 | 0.0 | 2021-03-06 04:23:41 | Unassigned, Louisiana, US |
1616092 | 1616092 | 2021-03-05 | Colombia | Huila | 49931 | 1739 | 47770 | 422 | 2.5359 | -75.5277 | 2021-03-06 04:23:41 | Huila, Colombia | ||
1092490 | 1092490 | 2021-03-03 | US | North Dakota | Sargent | 38081 | 417 | 6 | 0 | 422 | 46.10830372 | -97.63217159 | 2021-03-04 05:24:24 | Sargent, North Dakota, US |
1091524 | 1091524 | 2021-03-03 | US | Kentucky | Owsley | 21189 | 432 | 10 | 0 | 422 | 37.42823949 | -83.68811419 | 2021-03-04 05:24:24 | Owsley, Kentucky, US |
3256170 | 3256170 | 2021-03-02 | US | Montana | Teton | 30099 | 427 | 5 | 0 | 422 | 47.83741052 | -112.2410688 | 2021-03-03 05:23:28 | Teton, Montana, US |
1000854 | 1000854 | 2021-03-01 | US | North Dakota | Sargent | 38081 | 417 | 6 | 0 | 422 | 46.10830372 | -97.63217159 | 2021-03-02 05:23:30 | Sargent, North Dakota, US |
1000462 | 1000462 | 2021-03-01 | US | Montana | Teton | 30099 | 427 | 5 | 0 | 422 | 47.83741052 | -112.2410688 | 2021-03-02 05:23:30 | Teton, Montana, US |
998630 | 998630 | 2021-03-01 | Russia | Chechen Republic | 11310 | 111 | 10777 | 422 | 43.39761470000001 | 45.6985005 | 2021-03-02 05:23:30 | Chechen Republic, Russia | ||
2369912 | 2369912 | 2021-02-28 | US | North Dakota | Sargent | 38081 | 416 | 6 | 0 | 422 | 46.10830372 | -97.63217159 | 2021-03-01 05:23:01 | Sargent, North Dakota, US |
3068414 | 3068414 | 2021-02-27 | US | North Dakota | Sargent | 38081 | 416 | 6 | 0 | 422 | 46.10830372 | -97.63217159 | 2021-02-28 05:22:20 | Sargent, North Dakota, US |
745591 | 745591 | 2021-02-20 | US | Vermont | Lamoille | 50015 | 424 | 2 | 0 | 422 | 44.60353043 | -72.64356694 | 2021-02-21 05:24:33 | Lamoille, Vermont, US |
743555 | 743555 | 2021-02-20 | US | Iowa | Wayne | 19185 | 443 | 21 | 0 | 422 | 40.73969028 | -93.32752197 | 2021-02-21 05:24:33 | Wayne, Iowa, US |
472786 | 472786 | 2021-02-19 | US | Kentucky | Carlisle | 21039 | 423 | 1 | 0 | 422 | 36.85372876 | -88.96692220000001 | 2021-02-20 05:22:51 | Carlisle, Kentucky, US |
472653 | 472653 | 2021-02-19 | US | Iowa | Wayne | 19185 | 443 | 21 | 0 | 422 | 40.73969028 | -93.32752197 | 2021-02-20 05:22:51 | Wayne, Iowa, US |
471202 | 471202 | 2021-02-19 | Chile | Magallanes | 21353 | 304 | 20627 | 422 | -52.368 | -70.9863 | 2021-02-20 05:22:51 | Magallanes, Chile | ||
1154362 | 1154362 | 2021-02-18 | US | Iowa | Wayne | 19185 | 443 | 21 | 0 | 422 | 40.73969028 | -93.32752197 | 2021-02-19 05:24:16 | Wayne, Iowa, US |
1340003 | 1340003 | 2021-02-15 | US | Minnesota | Mahnomen | 27087 | 429 | 7 | 0 | 422 | 47.32557075 | -95.80921485 | 2021-02-16 05:24:38 | Mahnomen, Minnesota, US |
2285154 | 2285154 | 2021-02-14 | US | Minnesota | Mahnomen | 27087 | 429 | 7 | 0 | 422 | 47.32557075 | -95.80921485 | 2021-02-15 05:24:49 | Mahnomen, Minnesota, US |
2284406 | 2284406 | 2021-02-14 | US | Illinois | Gallatin | 17059 | 426 | 4 | 0 | 422 | 37.76430935 | -88.22953869 | 2021-02-15 05:24:49 | Gallatin, Illinois, US |
2283135 | 2283135 | 2021-02-14 | Barbados | 2061 | 23 | 1616 | 422 | 13.1939 | -59.5432 | 2021-02-15 05:24:49 | Barbados | |||
2679554 | 2679554 | 2021-02-13 | US | Minnesota | Mahnomen | 27087 | 429 | 7 | 0 | 422 | 47.32557075 | -95.80921485 | 2021-02-14 05:23:43 | Mahnomen, Minnesota, US |
2677535 | 2677535 | 2021-02-13 | Barbados | 2061 | 23 | 1616 | 422 | 13.1939 | -59.5432 | 2021-02-14 05:23:43 | Barbados | |||
3540439 | 3540439 | 2021-02-12 | US | Illinois | Gallatin | 17059 | 425 | 3 | 0 | 422 | 37.76430935 | -88.22953869 | 2021-02-13 05:22:12 | Gallatin, Illinois, US |
2640429 | 2640429 | 2021-02-11 | US | Puerto Rico | Aibonito | 72009 | 422 | 0 | 0 | 422 | 18.131361 | -66.264131 | 2021-02-12 05:23:29 | Aibonito, Puerto Rico, US |
3979218 | 3979218 | 2021-02-10 | US | Colorado | Rio Blanco | 8103 | 450 | 3 | 0 | 422 | 39.97913541 | -108.2179009 | 2021-02-11 05:23:55 | Rio Blanco, Colorado, US |
3978338 | 3978338 | 2021-02-10 | Cabo Verde | 14543 | 138 | 13983 | 422 | 16.5388 | -23.0418 | 2021-02-11 05:23:55 | Cabo Verde | |||
615427 | 615427 | 2021-02-08 | US | Minnesota | Norman | 27107 | 430 | 8 | 0 | 422 | 47.32628443 | -96.45620947 | 2021-02-09 05:23:30 | Norman, Minnesota, US |
1674196 | 1674196 | 2021-02-07 | US | Minnesota | Norman | 27107 | 430 | 8 | 0 | 422 | 47.32628443 | -96.45620947 | 2021-02-08 05:22:39 | Norman, Minnesota, US |
978386 | 978386 | 2021-02-06 | US | West Virginia | Doddridge | 54017 | 427 | 5 | 0 | 422 | 39.27057157 | -80.70671527 | 2021-02-07 05:23:00 | Doddridge, West Virginia, US |
976657 | 976657 | 2021-02-06 | US | Minnesota | Norman | 27107 | 430 | 8 | 0 | 422 | 47.32628443 | -96.45620947 | 2021-02-07 05:23:00 | Norman, Minnesota, US |
792031 | 792031 | 2021-02-04 | US | Michigan | Mackinac | 26097 | 425 | 3 | 0 | 422 | 46.07028979 | -85.04980537 | 2021-02-05 05:22:38 | Mackinac, Michigan, US |
340314 | 340314 | 2021-02-03 | Japan | Tochigi | 3803 | 49 | 3332 | 422 | 36.689912 | 139.819213 | 2021-02-04 05:22:26 | Tochigi, Japan | ||
1687825 | 1687825 | 2021-02-02 | US | Virginia | Fairfax City | 51600 | 434 | 12 | 0 | 422 | 38.85157547 | -77.29779640000002 | 2021-02-03 05:22:52 | Fairfax City, Virginia, US |
1686101 | 1686101 | 2021-02-02 | US | Michigan | Alger | 26003 | 425 | 3 | 0 | 422 | 46.41292944 | -86.60260122 | 2021-02-03 05:22:52 | Alger, Michigan, US |
1677257 | 1677257 | 2021-02-01 | US | Georgia | Echols | 13101 | 428 | 6 | 0 | 422 | 30.71101099 | -82.89687287 | 2021-02-02 05:22:49 | Echols, Georgia, US |
1676369 | 1676369 | 2021-02-01 | France | Reunion | 9996 | 46 | 9528 | 422 | -21.1151 | 55.5364 | 2021-02-02 05:22:49 | Reunion, France | ||
1460545 | 1460545 | 2021-01-31 | US | Georgia | Echols | 13101 | 428 | 6 | 0 | 422 | 30.71101099 | -82.89687287 | 2021-02-01 05:22:53 | Echols, Georgia, US |
15558 | 15558 | 2021-01-26 | US | Texas | Sutton | 48435 | 379 | 6 | 0 | 422 | 30.49856623 | -100.5382014 | 2021-01-27 05:23:41 | Sutton, Texas, US |
14473 | 14473 | 2021-01-26 | US | Nevada | Lander | 32015 | 430 | 8 | 0 | 422 | 39.9332233 | -117.0397075 | 2021-01-27 05:23:41 | Lander, Nevada, US |
1761487 | 1761487 | 2021-01-24 | US | New Mexico | Los Alamos | 35028 | 424 | 2 | 0 | 422 | 35.86631386 | -106.3134985 | 2021-01-25 05:22:16 | Los Alamos, New Mexico, US |
1759140 | 1759140 | 2021-01-24 | Colombia | Choco | 5829 | 176 | 5231 | 422 | 5.2528 | -76.82600000000002 | 2021-01-25 05:22:16 | Choco, Colombia | ||
2428913 | 2428913 | 2021-01-23 | US | Montana | Pondera | 30073 | 425 | 3 | 0 | 422 | 48.22773388 | -112.2252703 | 2021-01-24 05:22:35 | Pondera, Montana, US |
1095644 | 1095644 | 2021-01-20 | US | Maine | Waldo | 23027 | 440 | 18 | 0 | 422 | 44.4858305 | -69.12061935 | 2021-01-21 05:22:01 | Waldo, Maine, US |
911420 | 911420 | 2021-01-19 | US | Texas | Wheeler | 48483 | 530 | 9 | 0 | 422 | 35.40114335 | -100.2699514 | 2021-01-20 05:21:54 | Wheeler, Texas, US |
3505449 | 3505449 | 2021-01-17 | US | Nebraska | Morrill | 31123 | 437 | 15 | 0 | 422 | 41.71711774 | -103.0061405 | 2021-01-18 05:22:34 | Morrill, Nebraska, US |
3515601 | 3515601 | 2021-01-15 | Russia | Jewish Autonomous Okrug | 3957 | 85 | 3450 | 422 | 48.57527615 | 132.66307460000002 | 2021-01-16 05:22:40 | Jewish Autonomous Okrug, Russia | ||
3882411 | 3882411 | 2021-01-14 | US | South Dakota | Aurora | 46003 | 433 | 11 | 0 | 422 | 43.71757685 | -98.56050467 | 2021-01-15 05:22:24 | Aurora, South Dakota, US |
3881666 | 3881666 | 2021-01-14 | US | Nebraska | Morrill | 31123 | 436 | 14 | 0 | 422 | 41.71711774 | -103.0061405 | 2021-01-15 05:22:24 | Morrill, Nebraska, US |
3311038 | 3311038 | 2021-01-13 | US | South Dakota | Aurora | 46003 | 433 | 11 | 0 | 422 | 43.71757685 | -98.56050467 | 2021-01-14 05:22:32 | Aurora, South Dakota, US |
3310511 | 3310511 | 2021-01-13 | US | North Carolina | Gates | 37073 | 434 | 12 | 0 | 422 | 36.44667547 | -76.69749701 | 2021-01-14 05:22:32 | Gates, North Carolina, US |
3309159 | 3309159 | 2021-01-13 | US | Illinois | Calhoun | 17013 | 423 | 1 | 0 | 422 | 39.16840183 | -90.66330078 | 2021-01-14 05:22:32 | Calhoun, Illinois, US |
775658 | 775658 | 2021-01-12 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-13 05:22:15 | Morris, Kansas, US |
191379 | 191379 | 2021-01-11 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-12 05:22:15 | Morris, Kansas, US |
2629404 | 2629404 | 2021-01-10 | US | Wisconsin | Florence | 55037 | 434 | 12 | 0 | 422 | 45.84963535 | -88.39804137 | 2021-01-11 05:21:50 | Florence, Wisconsin, US |
2627804 | 2627804 | 2021-01-10 | US | Missouri | Ozark | 29153 | 427 | 5 | 0 | 422 | 36.64916339 | -92.44459066 | 2021-01-11 05:21:50 | Ozark, Missouri, US |
2627182 | 2627182 | 2021-01-10 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-11 05:21:50 | Morris, Kansas, US |
3903492 | 3903492 | 2021-01-09 | US | Wisconsin | Florence | 55037 | 434 | 12 | 0 | 422 | 45.84963535 | -88.39804137 | 2021-01-10 05:22:12 | Florence, Wisconsin, US |
3903228 | 3903228 | 2021-01-09 | US | Vermont | Addison | 50001 | 426 | 4 | 0 | 422 | 44.03217337 | -73.14130877 | 2021-01-10 05:22:12 | Addison, Vermont, US |
3901270 | 3901270 | 2021-01-09 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-10 05:22:12 | Morris, Kansas, US |
157515 | 157515 | 2021-01-08 | US | Wisconsin | Florence | 55037 | 434 | 12 | 0 | 422 | 45.84963535 | -88.39804137 | 2021-01-09 05:22:18 | Florence, Wisconsin, US |
156836 | 156836 | 2021-01-08 | US | South Dakota | Deuel | 46039 | 429 | 7 | 0 | 422 | 44.75994309 | -96.66943645 | 2021-01-09 05:22:18 | Deuel, South Dakota, US |
155293 | 155293 | 2021-01-08 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-09 05:22:18 | Morris, Kansas, US |
2542717 | 2542717 | 2021-01-07 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-08 05:22:42 | Morris, Kansas, US |
2542048 | 2542048 | 2021-01-07 | US | Colorado | Rio Grande | 8105 | 567 | 9 | 0 | 422 | 37.5836865 | -106.3847838 | 2021-01-08 05:22:42 | Rio Grande, Colorado, US |
2866026 | 2866026 | 2021-01-06 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-07 05:22:03 | Morris, Kansas, US |
3035621 | 3035621 | 2021-01-05 | US | Kansas | Ottawa | 20143 | 430 | 8 | 0 | 422 | 39.13237408 | -97.65020313 | 2021-01-06 05:22:16 | Ottawa, Kansas, US |
3035613 | 3035613 | 2021-01-05 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-06 05:22:16 | Morris, Kansas, US |
1063166 | 1063166 | 2021-01-04 | US | Kansas | Ottawa | 20143 | 430 | 8 | 0 | 422 | 39.13237408 | -97.65020313 | 2021-01-05 05:21:49 | Ottawa, Kansas, US |
1063158 | 1063158 | 2021-01-04 | US | Kansas | Morris | 20127 | 439 | 17 | 0 | 422 | 38.68827511 | -96.65128437 | 2021-01-05 05:21:49 | Morris, Kansas, US |
2230722 | 2230722 | 2021-01-02 | US | Texas | San Jacinto | 48407 | 1031 | 19 | 0 | 422 | 30.57933681 | -95.16260304 | 2021-01-03 05:22:52 | San Jacinto, Texas, US |
2228079 | 2228079 | 2021-01-02 | US | California | Plumas | 6063 | 422 | 1 | 0 | 422 | 40.00355989 | -120.8395236 | 2021-01-03 05:22:52 | Plumas, California, US |
1138330 | 1138330 | 2021-01-01 | US | Kentucky | Owen | 21187 | 428 | 6 | 0 | 422 | 38.51679143 | -84.82404619 | 2021-01-02 05:22:33 | Owen, Kentucky, US |
3696936 | 3696936 | 2020-12-31 | US | Kentucky | Owen | 21187 | 428 | 6 | 0 | 422 | 38.51679143 | -84.82404619 | 2021-01-01 05:23:07 | Owen, Kentucky, US |
1011751 | 1011751 | 2020-12-30 | US | Kentucky | Owen | 21187 | 428 | 6 | 0 | 422 | 38.51679143 | -84.82404619 | 2020-12-31 05:22:49 | Owen, Kentucky, US |
1011478 | 1011478 | 2020-12-30 | US | Iowa | Decatur | 19053 | 425 | 3 | 0 | 422 | 40.73742757 | -93.78645949 | 2020-12-31 05:22:49 | Decatur, Iowa, US |
1011343 | 1011343 | 2020-12-30 | US | Illinois | Stark | 17175 | 441 | 19 | 0 | 422 | 41.09309773 | -89.79745866 | 2020-12-31 05:22:49 | Stark, Illinois, 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]);