johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
175 rows where confirmed = 3646 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753547 | 2753547 | 2022-12-29 | US | Colorado | Moffat | 8081 | 3646 | 55 | 0 | 40.61810999 | -108.2070876 | 2022-12-30 04:21:04 | Moffat, Colorado, US | |
2433934 | 2433934 | 2022-11-09 | US | Tennessee | Stewart | 47161 | 3646 | 65 | 0 | 36.50235092 | -87.83920548 | 2022-11-10 04:21:16 | Stewart, Tennessee, US | |
482590 | 482590 | 2022-11-08 | US | Tennessee | Stewart | 47161 | 3646 | 65 | 0 | 36.50235092 | -87.83920548 | 2022-11-09 04:21:22 | Stewart, Tennessee, US | |
2441740 | 2441740 | 2022-11-07 | US | Tennessee | Stewart | 47161 | 3646 | 65 | 0 | 36.50235092 | -87.83920548 | 2022-11-08 04:21:21 | Stewart, Tennessee, US | |
3775136 | 3775136 | 2022-08-30 | US | Iowa | O'Brien | 19141 | 3646 | 72 | 0 | 43.08310673 | -95.62474482 | 2022-08-31 04:20:57 | O'Brien, Iowa, US | |
1681732 | 1681732 | 2022-08-29 | US | Iowa | O'Brien | 19141 | 3646 | 72 | 0 | 43.08310673 | -95.62474482 | 2022-08-30 04:21:03 | O'Brien, Iowa, US | |
1681443 | 1681443 | 2022-08-29 | US | Idaho | Gooding | 16047 | 3646 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-08-30 04:21:03 | Gooding, Idaho, US | |
1878216 | 1878216 | 2022-08-28 | US | Iowa | O'Brien | 19141 | 3646 | 72 | 0 | 43.08310673 | -95.62474482 | 2022-08-29 04:21:06 | O'Brien, Iowa, US | |
2097343 | 2097343 | 2022-08-27 | US | Iowa | O'Brien | 19141 | 3646 | 72 | 0 | 43.08310673 | -95.62474482 | 2022-08-28 04:21:02 | O'Brien, Iowa, US | |
1533158 | 1533158 | 2022-08-26 | US | Iowa | O'Brien | 19141 | 3646 | 72 | 0 | 43.08310673 | -95.62474482 | 2022-08-27 04:20:57 | O'Brien, Iowa, US | |
2830045 | 2830045 | 2022-08-25 | US | Iowa | O'Brien | 19141 | 3646 | 72 | 0 | 43.08310673 | -95.62474482 | 2022-08-26 04:21:02 | O'Brien, Iowa, US | |
2324578 | 2324578 | 2022-08-24 | US | Iowa | O'Brien | 19141 | 3646 | 72 | 0 | 43.08310673 | -95.62474482 | 2022-08-25 04:21:13 | O'Brien, Iowa, US | |
3429325 | 3429325 | 2022-07-14 | US | Alabama | Cleburne | 1029 | 3646 | 69 | 0 | 33.67679204 | -85.52005899 | 2022-07-15 04:20:53 | Cleburne, Alabama, US | |
1200433 | 1200433 | 2022-07-06 | US | Colorado | Gunnison | 8051 | 3646 | 14 | 0 | 38.66611652 | -107.0320729 | 2022-07-07 04:20:55 | Gunnison, Colorado, US | |
1770095 | 1770095 | 2022-07-03 | US | Puerto Rico | Jayuya | 72073 | 3646 | 0 | 0 | 18.211446 | -66.58878 | 2022-07-04 04:20:54 | Jayuya, Puerto Rico, US | |
2311086 | 2311086 | 2022-06-17 | China | Beijing | 3646 | 9 | 0 | 40.1824 | 116.4142 | 2022-06-18 04:21:10 | Beijing, China | |||
948400 | 948400 | 2022-06-14 | US | Louisiana | West Carroll | 22123 | 3646 | 66 | 0 | 32.78550125 | -91.461201 | 2022-06-15 04:20:54 | West Carroll, Louisiana, US | |
2980808 | 2980808 | 2022-06-13 | US | Louisiana | West Carroll | 22123 | 3646 | 66 | 0 | 32.78550125 | -91.461201 | 2022-06-14 04:20:52 | West Carroll, Louisiana, US | |
2236510 | 2236510 | 2022-06-12 | US | Indiana | Parke | 18121 | 3646 | 50 | 0 | 39.77202286 | -87.20375833 | 2022-06-13 04:21:14 | Parke, Indiana, US | |
3142708 | 3142708 | 2022-06-11 | US | Indiana | Parke | 18121 | 3646 | 50 | 0 | 39.77202286 | -87.20375833 | 2022-06-12 04:20:53 | Parke, Indiana, US | |
1945624 | 1945624 | 2022-06-10 | US | Indiana | Parke | 18121 | 3646 | 50 | 0 | 39.77202286 | -87.20375833 | 2022-06-11 04:21:01 | Parke, Indiana, US | |
1187767 | 1187767 | 2022-05-18 | US | Texas | Bandera | 48019 | 3646 | 77 | 0 | 29.74619598 | -99.24598147 | 2022-05-19 04:20:54 | Bandera, Texas, US | |
1507207 | 1507207 | 2022-05-16 | US | Wyoming | Goshen | 56015 | 3646 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-05-17 04:20:59 | Goshen, Wyoming, US | |
2087566 | 2087566 | 2022-05-15 | US | Wyoming | Goshen | 56015 | 3646 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-05-16 04:20:47 | Goshen, Wyoming, US | |
3358276 | 3358276 | 2022-05-14 | US | Wyoming | Goshen | 56015 | 3646 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-05-15 04:20:53 | Goshen, Wyoming, US | |
661921 | 661921 | 2022-05-13 | US | Wyoming | Goshen | 56015 | 3646 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-05-14 04:20:48 | Goshen, Wyoming, US | |
2537004 | 2537004 | 2022-05-12 | US | Wyoming | Goshen | 56015 | 3646 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-05-13 04:20:51 | Goshen, Wyoming, US | |
3448450 | 3448450 | 2022-05-11 | US | Wyoming | Goshen | 56015 | 3646 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-05-12 04:20:54 | Goshen, Wyoming, US | |
3539067 | 3539067 | 2022-05-10 | US | Wyoming | Goshen | 56015 | 3646 | 57 | 0 | 42.08798185 | -104.3534743 | 2022-05-11 04:20:48 | Goshen, Wyoming, US | |
2600770 | 2600770 | 2022-05-05 | US | Puerto Rico | Barceloneta | 72017 | 3646 | 0 | 0 | 18.445533 | -66.560531 | 2022-05-06 04:21:00 | Barceloneta, Puerto Rico, US | |
2443623 | 2443623 | 2022-04-13 | US | Georgia | Rabun | 13241 | 3646 | 96 | 0 | 34.88389445 | -83.40304637 | 2022-04-13 23:21:06 | Rabun, Georgia, US | |
1949380 | 1949380 | 2022-04-12 | US | Georgia | Rabun | 13241 | 3646 | 96 | 0 | 34.88389445 | -83.40304637 | 2022-04-13 04:21:03 | Rabun, Georgia, US | |
3207133 | 3207133 | 2022-04-11 | US | Georgia | Rabun | 13241 | 3646 | 96 | 0 | 34.88389445 | -83.40304637 | 2022-04-12 04:20:49 | Rabun, Georgia, US | |
3320864 | 3320864 | 2022-04-07 | US | Colorado | Grand | 8049 | 3646 | 27 | 0 | 40.10603347 | -106.11780420000001 | 2022-04-08 04:20:48 | Grand, Colorado, US | |
1907167 | 1907167 | 2022-03-22 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-22 23:20:51 | Ste. Genevieve, Missouri, US | |
26371 | 26371 | 2022-03-20 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-21 04:20:50 | Ste. Genevieve, Missouri, US | |
1658381 | 1658381 | 2022-03-19 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-20 04:20:45 | Ste. Genevieve, Missouri, US | |
337907 | 337907 | 2022-03-18 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-19 04:20:47 | Ste. Genevieve, Missouri, US | |
696360 | 696360 | 2022-03-17 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-18 04:20:55 | Ste. Genevieve, Missouri, US | |
2321303 | 2321303 | 2022-03-16 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-17 04:20:56 | Ste. Genevieve, Missouri, US | |
263503 | 263503 | 2022-03-15 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-16 04:20:50 | Ste. Genevieve, Missouri, US | |
2265862 | 2265862 | 2022-03-14 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-15 04:20:47 | Ste. Genevieve, Missouri, US | |
1993865 | 1993865 | 2022-03-01 | US | Iowa | Iowa | 19095 | 3646 | 47 | 0 | 41.68630265 | -92.0643373 | 2022-03-02 04:21:07 | Iowa, Iowa, US | |
944039 | 944039 | 2022-02-28 | US | Iowa | Iowa | 19095 | 3646 | 47 | 0 | 41.68630265 | -92.0643373 | 2022-03-01 04:21:09 | Iowa, Iowa, US | |
2734230 | 2734230 | 2022-02-27 | US | Iowa | Iowa | 19095 | 3646 | 47 | 0 | 41.68630265 | -92.0643373 | 2022-02-28 04:21:05 | Iowa, Iowa, US | |
3047383 | 3047383 | 2022-02-26 | US | Iowa | Iowa | 19095 | 3646 | 47 | 0 | 41.68630265 | -92.0643373 | 2022-02-27 04:21:04 | Iowa, Iowa, US | |
576038 | 576038 | 2022-02-25 | US | Iowa | Iowa | 19095 | 3646 | 47 | 0 | 41.68630265 | -92.0643373 | 2022-02-26 04:21:12 | Iowa, Iowa, US | |
1514770 | 1514770 | 2022-02-24 | US | Virginia | King William | 51101 | 3646 | 33 | 0 | 37.70965316 | -77.09384941 | 2022-02-25 04:21:11 | King William, Virginia, US | |
1512614 | 1512614 | 2022-02-24 | US | Iowa | Iowa | 19095 | 3646 | 47 | 0 | 41.68630265 | -92.0643373 | 2022-02-25 04:21:11 | Iowa, Iowa, US | |
1059055 | 1059055 | 2022-02-23 | US | Iowa | Iowa | 19095 | 3646 | 47 | 0 | 41.68630265 | -92.0643373 | 2022-02-24 04:21:14 | Iowa, Iowa, US | |
1298463 | 1298463 | 2022-02-17 | US | Alabama | Washington | 1129 | 3646 | 53 | 0 | 31.4092794 | -88.20689944 | 2022-02-18 04:21:04 | Washington, Alabama, US | |
2644918 | 2644918 | 2022-02-14 | US | Texas | Madison | 48313 | 3646 | 50 | 0 | 30.96694679 | -95.93003775 | 2022-02-15 04:21:09 | Madison, Texas, US | |
234192 | 234192 | 2022-02-11 | US | Idaho | Minidoka | 16067 | 3646 | 55 | 0 | 42.85518524 | -113.6357257 | 2022-02-12 04:21:06 | Minidoka, Idaho, US | |
3077358 | 3077358 | 2022-02-09 | US | Virginia | Buckingham | 51029 | 3646 | 45 | 0 | 37.57242268 | -78.52518834 | 2022-02-10 04:21:14 | Buckingham, Virginia, US | |
72146 | 72146 | 2022-02-07 | US | Illinois | Wabash | 17185 | 3646 | 21 | 0 | 38.44272901 | -87.84922065 | 2022-02-08 04:21:15 | Wabash, Illinois, US | |
2832638 | 2832638 | 2022-01-22 | China | Shanghai | 3646 | 7 | 0 | 31.201999999999998 | 121.4491 | 2022-01-23 04:21:13 | Shanghai, China | |||
3843731 | 3843731 | 2022-01-15 | US | Texas | Shelby | 48419 | 3646 | 116 | 0 | 31.79211404 | -94.14550696 | 2022-01-16 04:21:12 | Shelby, Texas, US | |
100884 | 100884 | 2022-01-14 | US | Maine | Knox | 23013 | 3646 | 20 | 0 | 44.11486325 | -69.10529169 | 2022-01-15 04:21:07 | Knox, Maine, US | |
3690875 | 3690875 | 2022-01-13 | US | Virginia | Prince Edward | 51147 | 3646 | 54 | 0 | 37.22554789 | -78.43597949 | 2022-01-14 04:21:54 | Prince Edward, Virginia, US | |
3690122 | 3690122 | 2022-01-13 | US | Oregon | Wasco | 41065 | 3646 | 50 | 0 | 45.16292781 | -121.16709540000001 | 2022-01-14 04:21:54 | Wasco, Oregon, US | |
1391636 | 1391636 | 2022-01-07 | US | Missouri | Texas | 29215 | 3646 | 74 | 0 | 37.31728859 | -91.96564727 | 2022-01-08 04:21:53 | Texas, Missouri, US | |
1284920 | 1284920 | 2022-01-05 | US | Tennessee | Crockett | 47033 | 3646 | 75 | 0 | 35.81830662 | -89.14916269 | 2022-01-06 04:22:09 | Crockett, Tennessee, US | |
1288306 | 1288306 | 2022-01-04 | US | North Carolina | Caswell | 37033 | 3646 | 39 | 0 | 36.39312665 | -79.33353281 | 2022-01-05 04:21:59 | Caswell, North Carolina, US | |
3522923 | 3522923 | 2022-01-02 | US | West Virginia | Lewis | 54041 | 3646 | 65 | 0 | 38.9947249 | -80.49988181 | 2022-01-03 02:22:25 | Lewis, West Virginia, US | |
3521116 | 3521116 | 2022-01-02 | US | Michigan | Roscommon | 26143 | 3646 | 101 | 0 | 44.33473082 | -84.61067651 | 2022-01-03 02:22:25 | Roscommon, Michigan, US | |
2171053 | 2171053 | 2022-01-01 | US | West Virginia | Lewis | 54041 | 3646 | 65 | 0 | 38.9947249 | -80.49988181 | 2022-01-02 04:20:52 | Lewis, West Virginia, US | |
2169246 | 2169246 | 2022-01-01 | US | Michigan | Roscommon | 26143 | 3646 | 101 | 0 | 44.33473082 | -84.61067651 | 2022-01-02 04:20:52 | Roscommon, Michigan, US | |
2780484 | 2780484 | 2021-12-31 | US | West Virginia | Lewis | 54041 | 3646 | 65 | 0 | 38.9947249 | -80.49988181 | 2022-01-01 04:22:14 | Lewis, West Virginia, US | |
2778677 | 2778677 | 2021-12-31 | US | Michigan | Roscommon | 26143 | 3646 | 101 | 0 | 44.33473082 | -84.61067651 | 2022-01-01 04:22:14 | Roscommon, Michigan, US | |
4002141 | 4002141 | 2021-12-30 | US | West Virginia | Lewis | 54041 | 3646 | 65 | 0 | 38.9947249 | -80.49988181 | 2021-12-31 04:21:50 | Lewis, West Virginia, US | |
4000334 | 4000334 | 2021-12-30 | US | Michigan | Roscommon | 26143 | 3646 | 101 | 0 | 44.33473082 | -84.61067651 | 2021-12-31 04:21:50 | Roscommon, Michigan, US | |
1670468 | 1670468 | 2021-12-29 | US | Montana | Lincoln | 30053 | 3646 | 73 | 0 | 48.54265777 | -115.4046155 | 2021-12-30 04:21:25 | Lincoln, Montana, US | |
1670141 | 1670141 | 2021-12-29 | US | Michigan | Roscommon | 26143 | 3646 | 101 | 0 | 44.33473082 | -84.61067651 | 2021-12-30 04:21:25 | Roscommon, Michigan, US | |
1434191 | 1434191 | 2021-12-28 | US | Michigan | Cheboygan | 26031 | 3646 | 80 | 0 | 45.44787015 | -84.50122149 | 2021-12-29 03:21:43 | Cheboygan, Michigan, US | |
732474 | 732474 | 2021-12-27 | US | Missouri | Perry | 29157 | 3646 | 40 | 0 | 37.70660776 | -89.82741088 | 2021-12-28 04:21:47 | Perry, Missouri, US | |
732152 | 732152 | 2021-12-27 | US | Michigan | Cheboygan | 26031 | 3646 | 80 | 0 | 45.44787015 | -84.50122149 | 2021-12-28 04:21:47 | Cheboygan, Michigan, US | |
801529 | 801529 | 2021-12-22 | US | Texas | Gonzales | 48177 | 3646 | 87 | 0 | 29.45634206 | -97.49424032 | 2021-12-23 04:21:21 | Gonzales, Texas, US | |
2401495 | 2401495 | 2021-12-17 | US | Pennsylvania | Juniata | 42067 | 3646 | 141 | 0 | 40.53358749 | -77.39975129999998 | 2021-12-18 02:22:20 | Juniata, Pennsylvania, US | |
3658745 | 3658745 | 2021-12-10 | US | Texas | Lamb | 48279 | 3646 | 97 | 0 | 34.06859623 | -102.35162890000001 | 2021-12-11 04:22:45 | Lamb, Texas, US | |
1079649 | 1079649 | 2021-12-09 | US | Minnesota | Hubbard | 27057 | 3646 | 49 | 0 | 47.10778564 | -94.91693868 | 2021-12-10 04:22:28 | Hubbard, Minnesota, US | |
407661 | 407661 | 2021-12-07 | US | Virginia | Louisa | 51109 | 3646 | 53 | 0 | 37.97850256 | -77.96274807 | 2021-12-08 04:22:46 | Louisa, Virginia, US | |
448785 | 448785 | 2021-11-17 | US | Kentucky | Hart | 21099 | 3646 | 69 | 0 | 37.29943898 | -85.88461055 | 2021-11-18 04:21:33 | Hart, Kentucky, US | |
498670 | 498670 | 2021-11-06 | US | Texas | Austin | 48015 | 3646 | 54 | 0 | 29.88548725 | -96.27736949 | 2021-11-07 04:21:53 | Austin, Texas, US | |
698908 | 698908 | 2021-11-04 | US | Arkansas | Logan | 5083 | 3646 | 48 | 0 | 35.21413234 | -93.71951016 | 2021-11-05 04:21:54 | Logan, Arkansas, US | |
3492673 | 3492673 | 2021-10-26 | US | Arkansas | Lincoln | 5079 | 3646 | 57 | 0 | 33.95317155 | -91.74002806 | 2021-10-27 04:22:32 | Lincoln, Arkansas, US | |
773286 | 773286 | 2021-10-23 | US | Tennessee | Fentress | 47049 | 3646 | 66 | 0 | 36.38128818 | -84.92870012 | 2021-10-24 04:21:22 | Fentress, Tennessee, US | |
2045986 | 2045986 | 2021-10-18 | US | Nevada | Churchill | 32001 | 3646 | 60 | 0 | 39.58105744 | -118.3394607 | 2021-10-19 04:20:54 | Churchill, Nevada, US | |
2944777 | 2944777 | 2021-10-15 | US | Kentucky | Johnson | 21115 | 3646 | 46 | 0 | 37.85106355 | -82.8264322 | 2021-10-16 04:21:15 | Johnson, Kentucky, US | |
3010197 | 3010197 | 2021-10-11 | US | South Dakota | Davison | 46035 | 3646 | 69 | 0 | 43.67490933 | -98.14458906 | 2021-10-12 04:21:09 | Davison, South Dakota, US | |
426213 | 426213 | 2021-10-10 | US | South Dakota | Davison | 46035 | 3646 | 69 | 0 | 43.67490933 | -98.14458906 | 2021-10-11 04:21:31 | Davison, South Dakota, US | |
2879070 | 2879070 | 2021-10-09 | US | South Dakota | Davison | 46035 | 3646 | 69 | 0 | 43.67490933 | -98.14458906 | 2021-10-10 04:21:38 | Davison, South Dakota, US | |
2962236 | 2962236 | 2021-10-08 | US | South Dakota | Davison | 46035 | 3646 | 69 | 0 | 43.67490933 | -98.14458906 | 2021-10-09 04:21:34 | Davison, South Dakota, US | |
1237083 | 1237083 | 2021-09-27 | US | Kentucky | Marion | 21155 | 3646 | 40 | 0 | 37.55218078 | -85.26898542 | 2021-09-28 04:21:28 | Marion, Kentucky, US | |
2076007 | 2076007 | 2021-09-26 | Malaysia | Perlis | 3646 | 59 | 0 | 6.4449 | 100.2048 | 2021-09-27 04:21:16 | Perlis, Malaysia | |||
3014628 | 3014628 | 2021-09-22 | US | Virginia | Accomack | 51001 | 3646 | 63 | 0 | 37.76707161 | -75.63234615 | 2021-09-23 04:21:43 | Accomack, Virginia, US | |
3449424 | 3449424 | 2021-09-10 | US | California | Siskiyou | 6093 | 3646 | 35 | 0 | 41.59198861 | -122.54074340000001 | 2021-09-11 04:21:30 | Siskiyou, California, US | |
3893756 | 3893756 | 2021-08-29 | US | Mississippi | Marion | 28091 | 3646 | 88 | 0 | 31.23132643 | -89.8209217 | 2021-08-30 04:21:23 | Marion, Mississippi, US | |
2794859 | 2794859 | 2021-08-28 | US | Mississippi | Marion | 28091 | 3646 | 88 | 0 | 31.23132643 | -89.8209217 | 2021-08-29 04:21:14 | Marion, Mississippi, US | |
2925090 | 2925090 | 2021-08-27 | US | Missouri | Dunklin | 29069 | 3646 | 52 | 0 | 36.27167174 | -90.09122243 | 2021-08-28 04:21:28 | Dunklin, Missouri, US | |
2925018 | 2925018 | 2021-08-27 | US | Mississippi | Marion | 28091 | 3646 | 88 | 0 | 31.23132643 | -89.8209217 | 2021-08-28 04:21:28 | Marion, Mississippi, 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]);