johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
372 rows where confirmed = 2011 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329105 | 329105 | 2022-12-27 | US | Iowa | Greene | 19073 | 2011 | 28 | 0 | 42.03614551 | -94.39658081 | 2022-12-28 04:21:04 | Greene, Iowa, US | |
219178 | 219178 | 2022-12-26 | US | Iowa | Greene | 19073 | 2011 | 28 | 0 | 42.03614551 | -94.39658081 | 2022-12-27 04:21:07 | Greene, Iowa, US | |
3223635 | 3223635 | 2022-12-25 | US | Iowa | Greene | 19073 | 2011 | 28 | 0 | 42.03614551 | -94.39658081 | 2022-12-26 04:21:06 | Greene, Iowa, US | |
1019549 | 1019549 | 2022-12-24 | US | Iowa | Greene | 19073 | 2011 | 28 | 0 | 42.03614551 | -94.39658081 | 2022-12-25 04:21:04 | Greene, Iowa, US | |
691572 | 691572 | 2022-12-23 | US | Iowa | Greene | 19073 | 2011 | 28 | 0 | 42.03614551 | -94.39658081 | 2022-12-24 04:21:02 | Greene, Iowa, US | |
2180782 | 2180782 | 2022-12-22 | US | Iowa | Greene | 19073 | 2011 | 28 | 0 | 42.03614551 | -94.39658081 | 2022-12-23 04:21:04 | Greene, Iowa, US | |
452586 | 452586 | 2022-12-21 | US | Iowa | Greene | 19073 | 2011 | 28 | 0 | 42.03614551 | -94.39658081 | 2022-12-22 04:20:56 | Greene, Iowa, US | |
2954462 | 2954462 | 2022-12-20 | US | Texas | Delta | 48119 | 2011 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-12-21 04:21:03 | Delta, Texas, US | |
3176864 | 3176864 | 2022-12-19 | US | Texas | Delta | 48119 | 2011 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-12-20 04:21:04 | Delta, Texas, US | |
1631381 | 1631381 | 2022-12-18 | US | Texas | Delta | 48119 | 2011 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-12-19 04:21:03 | Delta, Texas, US | |
506760 | 506760 | 2022-12-17 | US | Texas | Delta | 48119 | 2011 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-12-18 04:21:03 | Delta, Texas, US | |
3327332 | 3327332 | 2022-12-16 | US | Texas | Delta | 48119 | 2011 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-12-17 04:21:04 | Delta, Texas, US | |
545844 | 545844 | 2022-12-15 | US | Texas | Delta | 48119 | 2011 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-12-16 04:21:01 | Delta, Texas, US | |
351372 | 351372 | 2022-12-14 | US | Texas | Delta | 48119 | 2011 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-12-15 04:20:58 | Delta, Texas, US | |
2415360 | 2415360 | 2022-12-05 | US | Arkansas | Dallas | 5039 | 2011 | 38 | 0 | 33.97042763 | -92.65167437 | 2022-12-06 04:21:03 | Dallas, Arkansas, US | |
2531423 | 2531423 | 2022-10-06 | US | Montana | Valley | 30105 | 2011 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-10-07 04:23:08 | Valley, Montana, US | |
1812817 | 1812817 | 2022-10-05 | US | Montana | Valley | 30105 | 2011 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-10-06 04:21:22 | Valley, Montana, US | |
1811764 | 1811764 | 2022-10-05 | US | Illinois | Edwards | 17047 | 2011 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-10-06 04:21:22 | Edwards, Illinois, US | |
132791 | 132791 | 2022-10-04 | US | Montana | Valley | 30105 | 2011 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-10-05 04:23:06 | Valley, Montana, US | |
131738 | 131738 | 2022-10-04 | US | Illinois | Edwards | 17047 | 2011 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-10-05 04:23:06 | Edwards, Illinois, US | |
2687738 | 2687738 | 2022-10-03 | US | Montana | Valley | 30105 | 2011 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-10-04 04:22:55 | Valley, Montana, US | |
2687311 | 2687311 | 2022-10-03 | US | Michigan | Alger | 26003 | 2011 | 15 | 0 | 46.41292944 | -86.60260122 | 2022-10-04 04:22:55 | Alger, Michigan, US | |
2261805 | 2261805 | 2022-10-02 | US | Montana | Valley | 30105 | 2011 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-10-03 04:23:11 | Valley, Montana, US | |
2261378 | 2261378 | 2022-10-02 | US | Michigan | Alger | 26003 | 2011 | 15 | 0 | 46.41292944 | -86.60260122 | 2022-10-03 04:23:11 | Alger, Michigan, US | |
2997331 | 2997331 | 2022-10-01 | US | Montana | Valley | 30105 | 2011 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-10-02 04:21:23 | Valley, Montana, US | |
2996904 | 2996904 | 2022-10-01 | US | Michigan | Alger | 26003 | 2011 | 15 | 0 | 46.41292944 | -86.60260122 | 2022-10-02 04:21:23 | Alger, Michigan, US | |
855657 | 855657 | 2022-09-30 | US | Montana | Valley | 30105 | 2011 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-10-01 04:23:01 | Valley, Montana, US | |
855230 | 855230 | 2022-09-30 | US | Michigan | Alger | 26003 | 2011 | 15 | 0 | 46.41292944 | -86.60260122 | 2022-10-01 04:23:01 | Alger, Michigan, US | |
2377156 | 2377156 | 2022-09-29 | US | Michigan | Alger | 26003 | 2011 | 15 | 0 | 46.41292944 | -86.60260122 | 2022-09-30 04:23:09 | Alger, Michigan, US | |
2376530 | 2376530 | 2022-09-29 | US | Illinois | Edwards | 17047 | 2011 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-09-30 04:23:09 | Edwards, Illinois, US | |
1561707 | 1561707 | 2022-09-28 | US | Michigan | Alger | 26003 | 2011 | 15 | 0 | 46.41292944 | -86.60260122 | 2022-09-29 04:22:34 | Alger, Michigan, US | |
3996250 | 3996250 | 2022-09-27 | US | Michigan | Alger | 26003 | 2011 | 15 | 0 | 46.41292944 | -86.60260122 | 2022-09-28 04:23:01 | Alger, Michigan, US | |
2018070 | 2018070 | 2022-09-20 | US | Kansas | Russell | 20167 | 2011 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-09-21 04:23:22 | Russell, Kansas, US | |
3571943 | 3571943 | 2022-09-19 | US | Kansas | Russell | 20167 | 2011 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-09-20 04:22:48 | Russell, Kansas, US | |
420682 | 420682 | 2022-09-18 | US | Kansas | Russell | 20167 | 2011 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-09-19 04:21:49 | Russell, Kansas, US | |
3374706 | 3374706 | 2022-09-17 | US | Kansas | Russell | 20167 | 2011 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-09-18 04:22:50 | Russell, Kansas, US | |
2356814 | 2356814 | 2022-09-16 | US | Kansas | Russell | 20167 | 2011 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-09-17 04:20:19 | Russell, Kansas, US | |
3987971 | 3987971 | 2022-09-15 | US | Kansas | Russell | 20167 | 2011 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-09-16 04:21:19 | Russell, Kansas, US | |
1890488 | 1890488 | 2022-09-14 | US | Kansas | Russell | 20167 | 2011 | 39 | 0 | 38.91462787 | -98.76254297 | 2022-09-15 04:21:02 | Russell, Kansas, US | |
117051 | 117051 | 2022-09-06 | US | North Carolina | Camden | 37029 | 2011 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-07 04:20:59 | Camden, North Carolina, US | |
2636023 | 2636023 | 2022-09-05 | US | North Carolina | Camden | 37029 | 2011 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-06 04:21:02 | Camden, North Carolina, US | |
2989587 | 2989587 | 2022-09-04 | US | North Carolina | Camden | 37029 | 2011 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-05 04:21:01 | Camden, North Carolina, US | |
2715272 | 2715272 | 2022-09-03 | US | North Carolina | Camden | 37029 | 2011 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-04 04:21:22 | Camden, North Carolina, US | |
1395977 | 1395977 | 2022-09-02 | US | North Carolina | Camden | 37029 | 2011 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-03 04:21:04 | Camden, North Carolina, US | |
3549806 | 3549806 | 2022-09-01 | US | North Carolina | Camden | 37029 | 2011 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-02 04:21:07 | Camden, North Carolina, US | |
2345726 | 2345726 | 2022-08-31 | US | North Carolina | Camden | 37029 | 2011 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-01 04:21:03 | Camden, North Carolina, US | |
1880247 | 1880247 | 2022-08-28 | US | Texas | Winkler | 48495 | 2011 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-29 04:21:06 | Winkler, Texas, US | |
2099374 | 2099374 | 2022-08-27 | US | Texas | Winkler | 48495 | 2011 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-28 04:21:02 | Winkler, Texas, US | |
1535189 | 1535189 | 2022-08-26 | US | Texas | Winkler | 48495 | 2011 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-27 04:20:57 | Winkler, Texas, US | |
2891403 | 2891403 | 2022-08-12 | US | Tennessee | Van Buren | 47175 | 2011 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-13 04:20:52 | Van Buren, Tennessee, US | |
1089141 | 1089141 | 2022-08-09 | US | Texas | Crosby | 48107 | 2011 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-08-10 04:20:57 | Crosby, Texas, US | |
3546599 | 3546599 | 2022-08-08 | US | Texas | Hamilton | 48193 | 2011 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-08-09 04:20:34 | Hamilton, Texas, US | |
1073002 | 1073002 | 2022-08-07 | US | Texas | Hamilton | 48193 | 2011 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-08-08 04:21:08 | Hamilton, Texas, US | |
1943590 | 1943590 | 2022-08-06 | US | Texas | Hamilton | 48193 | 2011 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-08-07 04:20:54 | Hamilton, Texas, US | |
883389 | 883389 | 2022-08-05 | US | Texas | Hamilton | 48193 | 2011 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-08-06 04:20:56 | Hamilton, Texas, US | |
2011800 | 2011800 | 2022-08-04 | US | Texas | Hamilton | 48193 | 2011 | 34 | 0 | 31.70470573 | -98.11083887 | 2022-08-05 04:20:52 | Hamilton, Texas, US | |
962260 | 962260 | 2022-07-19 | US | Virginia | Lancaster | 51103 | 2011 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-07-20 04:20:59 | Lancaster, Virginia, US | |
3213760 | 3213760 | 2022-07-18 | US | West Virginia | Calhoun | 54013 | 2011 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-19 04:20:58 | Calhoun, West Virginia, US | |
3406991 | 3406991 | 2022-07-17 | US | Louisiana | St. Helena | 22091 | 2011 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-07-18 04:20:59 | St. Helena, Louisiana, US | |
2153191 | 2153191 | 2022-07-16 | US | Louisiana | St. Helena | 22091 | 2011 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-07-17 04:21:15 | St. Helena, Louisiana, US | |
2420424 | 2420424 | 2022-07-15 | US | Louisiana | St. Helena | 22091 | 2011 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-07-16 04:21:05 | St. Helena, Louisiana, US | |
2789645 | 2789645 | 2022-07-10 | US | Colorado | Conejos | 8021 | 2011 | 57 | 0 | 37.201606 | -106.1917488 | 2022-07-11 04:20:46 | Conejos, Colorado, US | |
3969460 | 3969460 | 2022-07-05 | US | South Dakota | Turner | 46125 | 2011 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-07-06 04:20:58 | Turner, South Dakota, US | |
3080971 | 3080971 | 2022-07-04 | US | South Dakota | Turner | 46125 | 2011 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-07-05 04:20:45 | Turner, South Dakota, US | |
3078695 | 3078695 | 2022-07-04 | US | Colorado | Lake | 8065 | 2011 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-05 04:20:45 | Lake, Colorado, US | |
1770253 | 1770253 | 2022-07-03 | US | South Dakota | Turner | 46125 | 2011 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-07-04 04:20:54 | Turner, South Dakota, US | |
1767865 | 1767865 | 2022-07-03 | US | Arkansas | Prairie | 5117 | 2011 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-07-04 04:20:54 | Prairie, Arkansas, US | |
3368239 | 3368239 | 2022-07-02 | US | South Dakota | Turner | 46125 | 2011 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-07-03 04:20:59 | Turner, South Dakota, US | |
3365851 | 3365851 | 2022-07-02 | US | Arkansas | Prairie | 5117 | 2011 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-07-03 04:20:59 | Prairie, Arkansas, US | |
3365140 | 3365140 | 2022-07-02 | China | Tianjin | 2011 | 3 | 0 | 39.3054 | 117.323 | 2022-07-03 04:20:59 | Tianjin, China | |||
596568 | 596568 | 2022-07-01 | US | South Dakota | Turner | 46125 | 2011 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-07-02 04:21:16 | Turner, South Dakota, US | |
593469 | 593469 | 2022-07-01 | China | Tianjin | 2011 | 3 | 0 | 39.3054 | 117.323 | 2022-07-02 04:21:16 | Tianjin, China | |||
3942969 | 3942969 | 2022-06-30 | US | South Dakota | Turner | 46125 | 2011 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-07-01 04:21:10 | Turner, South Dakota, US | |
2492927 | 2492927 | 2022-06-29 | US | South Dakota | Turner | 46125 | 2011 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-06-30 04:21:01 | Turner, South Dakota, US | |
2240706 | 2240706 | 2022-06-28 | US | Kansas | Kingman | 20095 | 2011 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-06-29 04:20:59 | Kingman, Kansas, US | |
2148948 | 2148948 | 2022-06-27 | US | Kansas | Kingman | 20095 | 2011 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-06-28 04:20:58 | Kingman, Kansas, US | |
476749 | 476749 | 2022-06-26 | US | Kansas | Kingman | 20095 | 2011 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-06-27 04:21:00 | Kingman, Kansas, US | |
940124 | 940124 | 2022-06-25 | US | Kansas | Kingman | 20095 | 2011 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-06-26 04:21:02 | Kingman, Kansas, US | |
3347944 | 3347944 | 2022-06-24 | US | Kansas | Kingman | 20095 | 2011 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-06-25 04:20:57 | Kingman, Kansas, US | |
1649685 | 1649685 | 2022-06-23 | US | Kansas | Kingman | 20095 | 2011 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-06-24 04:20:58 | Kingman, Kansas, US | |
2188920 | 2188920 | 2022-06-22 | US | Kansas | Kingman | 20095 | 2011 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-06-23 04:20:55 | Kingman, Kansas, US | |
2311967 | 2311967 | 2022-06-17 | US | Colorado | Yuma | 8125 | 2011 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-06-18 04:21:10 | Yuma, Colorado, US | |
3579327 | 3579327 | 2022-06-02 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-06-03 04:20:58 | Glades, Florida, US | |
971620 | 971620 | 2022-06-01 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-06-02 05:20:39 | Glades, Florida, US | |
229927 | 229927 | 2022-05-31 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-06-01 04:20:55 | Glades, Florida, US | |
3186692 | 3186692 | 2022-05-30 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-31 04:20:51 | Glades, Florida, US | |
3198841 | 3198841 | 2022-05-29 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-30 04:20:50 | Glades, Florida, US | |
2725719 | 2725719 | 2022-05-28 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-29 04:20:53 | Glades, Florida, US | |
1314900 | 1314900 | 2022-05-27 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-28 04:21:07 | Glades, Florida, US | |
1850692 | 1850692 | 2022-05-26 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-27 04:20:56 | Glades, Florida, US | |
2048568 | 2048568 | 2022-05-25 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-26 04:20:50 | Glades, Florida, US | |
3000006 | 3000006 | 2022-05-24 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-25 04:20:56 | Glades, Florida, US | |
3593727 | 3593727 | 2022-05-23 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-24 04:20:57 | Glades, Florida, US | |
622579 | 622579 | 2022-05-22 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-26 04:20:50 | Glades, Florida, US | |
1110275 | 1110275 | 2022-05-21 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-22 04:20:52 | Glades, Florida, US | |
1169899 | 1169899 | 2022-05-20 | US | Florida | Glades | 12043 | 2011 | 36 | 0 | 26.95635849 | -81.18996211 | 2022-05-21 04:20:58 | Glades, Florida, US | |
223750 | 223750 | 2022-05-09 | US | Minnesota | Pipestone | 27117 | 2011 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-10 04:20:50 | Pipestone, Minnesota, US | |
2333135 | 2333135 | 2022-05-08 | US | Minnesota | Pipestone | 27117 | 2011 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-09 04:20:54 | Pipestone, Minnesota, US | |
362097 | 362097 | 2022-05-07 | US | Minnesota | Pipestone | 27117 | 2011 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-08 04:20:49 | Pipestone, Minnesota, US | |
1399448 | 1399448 | 2022-05-06 | US | Minnesota | Pipestone | 27117 | 2011 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-07 04:21:09 | Pipestone, Minnesota, 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]);