johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
351 rows where confirmed = 1873 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952687 | 2952687 | 2022-12-20 | US | Kansas | Harper | 20077 | 1873 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-21 04:21:03 | Harper, Kansas, US | |
3175089 | 3175089 | 2022-12-19 | US | Kansas | Harper | 20077 | 1873 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-20 04:21:04 | Harper, Kansas, US | |
1629606 | 1629606 | 2022-12-18 | US | Kansas | Harper | 20077 | 1873 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-19 04:21:03 | Harper, Kansas, US | |
504985 | 504985 | 2022-12-17 | US | Kansas | Harper | 20077 | 1873 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-18 04:21:03 | Harper, Kansas, US | |
3325557 | 3325557 | 2022-12-16 | US | Kansas | Harper | 20077 | 1873 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-17 04:21:04 | Harper, Kansas, US | |
544069 | 544069 | 2022-12-15 | US | Kansas | Harper | 20077 | 1873 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-16 04:21:01 | Harper, Kansas, US | |
349597 | 349597 | 2022-12-14 | US | Kansas | Harper | 20077 | 1873 | 29 | 0 | 37.19175361 | -98.07578384 | 2022-12-15 04:20:58 | Harper, Kansas, US | |
292625 | 292625 | 2022-11-15 | US | Colorado | Clear Creek | 8019 | 1873 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-11-16 04:21:09 | Clear Creek, Colorado, US | |
542131 | 542131 | 2022-10-26 | US | Virginia | Mathews | 51115 | 1873 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-10-27 04:22:01 | Mathews, Virginia, US | |
256367 | 256367 | 2022-09-08 | US | Texas | Coleman | 48083 | 1873 | 73 | 0 | 31.76736834 | -99.45240766 | 2022-09-09 04:21:11 | Coleman, Texas, US | |
2829329 | 2829329 | 2022-08-25 | US | Arkansas | Newton | 5101 | 1873 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-08-26 04:21:02 | Newton, Arkansas, US | |
991842 | 991842 | 2022-08-16 | US | Georgia | Miller | 13201 | 1873 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-08-17 04:20:59 | Miller, Georgia, US | |
2494881 | 2494881 | 2022-08-15 | US | Georgia | Miller | 13201 | 1873 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-08-16 04:20:58 | Miller, Georgia, US | |
3648431 | 3648431 | 2022-08-14 | US | Georgia | Miller | 13201 | 1873 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-08-15 04:20:59 | Miller, Georgia, US | |
1969437 | 1969437 | 2022-08-13 | US | Georgia | Miller | 13201 | 1873 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-08-14 04:20:55 | Miller, Georgia, US | |
2889246 | 2889246 | 2022-08-12 | US | Georgia | Miller | 13201 | 1873 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-08-13 04:20:52 | Miller, Georgia, US | |
3908851 | 3908851 | 2022-08-11 | US | Georgia | Miller | 13201 | 1873 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-08-12 04:20:54 | Miller, Georgia, US | |
1347168 | 1347168 | 2022-08-10 | US | Georgia | Miller | 13201 | 1873 | 31 | 0 | 31.16568912 | -84.73151117 | 2022-08-11 04:20:49 | Miller, Georgia, US | |
1070933 | 1070933 | 2022-08-07 | US | Illinois | Pulaski | 17153 | 1873 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-08-08 04:21:08 | Pulaski, Illinois, US | |
1941521 | 1941521 | 2022-08-06 | US | Illinois | Pulaski | 17153 | 1873 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-08-07 04:20:54 | Pulaski, Illinois, US | |
881320 | 881320 | 2022-08-05 | US | Illinois | Pulaski | 17153 | 1873 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-08-06 04:20:56 | Pulaski, Illinois, US | |
2335879 | 2335879 | 2022-07-27 | US | Arkansas | Dallas | 5039 | 1873 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-07-28 04:20:56 | Dallas, Arkansas, US | |
958684 | 958684 | 2022-07-19 | China | Guangxi | 1873 | 2 | 0 | 23.8298 | 108.7881 | 2022-07-20 04:20:59 | Guangxi, China | |||
3969811 | 3969811 | 2022-07-05 | US | Texas | Winkler | 48495 | 1873 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-07-06 04:20:58 | Winkler, Texas, US | |
3890799 | 3890799 | 2022-06-06 | US | Texas | Mitchell | 48335 | 1873 | 49 | 0 | 32.30623474 | -100.9212058 | 2022-06-07 04:21:08 | Mitchell, Texas, US | |
3889643 | 3889643 | 2022-06-06 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-06-07 04:21:08 | Powell, Montana, US | |
3509412 | 3509412 | 2022-06-05 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-06-06 04:20:57 | Powell, Montana, US | |
3529489 | 3529489 | 2022-06-04 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-06-05 04:20:55 | Powell, Montana, US | |
3135575 | 3135575 | 2022-06-03 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-06-04 04:20:58 | Powell, Montana, US | |
3580650 | 3580650 | 2022-06-02 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-06-03 04:20:58 | Powell, Montana, US | |
972943 | 972943 | 2022-06-01 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-06-02 05:20:39 | Powell, Montana, US | |
231250 | 231250 | 2022-05-31 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-06-01 04:20:55 | Powell, Montana, US | |
3188724 | 3188724 | 2022-05-30 | US | Puerto Rico | Ceiba | 72037 | 1873 | 0 | 0 | 18.251818 | -65.666416 | 2022-05-31 04:20:51 | Ceiba, Puerto Rico, US | |
3188015 | 3188015 | 2022-05-30 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-05-31 04:20:51 | Powell, Montana, US | |
3200164 | 3200164 | 2022-05-29 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-05-30 04:20:50 | Powell, Montana, US | |
2727042 | 2727042 | 2022-05-28 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-05-29 04:20:53 | Powell, Montana, US | |
1316223 | 1316223 | 2022-05-27 | US | Montana | Powell | 30077 | 1873 | 29 | 0 | 46.85538891 | -112.9359164 | 2022-05-28 04:21:07 | Powell, Montana, US | |
2029145 | 2029145 | 2022-04-24 | US | Alabama | Greene | 1063 | 1873 | 48 | 0 | 32.85504247 | -87.95684022 | 2022-04-25 04:20:56 | Greene, Alabama, US | |
746720 | 746720 | 2022-04-23 | US | Alabama | Greene | 1063 | 1873 | 48 | 0 | 32.85504247 | -87.95684022 | 2022-04-24 04:20:56 | Greene, Alabama, US | |
3437205 | 3437205 | 2022-04-22 | US | Alabama | Greene | 1063 | 1873 | 48 | 0 | 32.85504247 | -87.95684022 | 2022-04-23 04:20:50 | Greene, Alabama, US | |
1846608 | 1846608 | 2022-04-18 | US | Colorado | Lake | 8065 | 1873 | 2 | 0 | 39.20278823 | -106.35556969999999 | 2022-04-19 04:21:00 | Lake, Colorado, US | |
161077 | 161077 | 2022-03-29 | US | Texas | Crosby | 48107 | 1873 | 45 | 0 | 33.61431553 | -101.30003640000001 | 2022-03-30 04:20:45 | Crosby, Texas, US | |
1469443 | 1469443 | 2022-03-24 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-25 04:20:46 | Russell, Kansas, US | |
3023617 | 3023617 | 2022-03-23 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-24 04:20:43 | Russell, Kansas, US | |
1906539 | 1906539 | 2022-03-22 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-23 04:20:48 | Russell, Kansas, US | |
3239670 | 3239670 | 2022-03-21 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-22 04:20:54 | Russell, Kansas, US | |
25743 | 25743 | 2022-03-20 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-21 04:20:50 | Russell, Kansas, US | |
1657753 | 1657753 | 2022-03-19 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-20 04:20:45 | Russell, Kansas, US | |
337279 | 337279 | 2022-03-18 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-19 04:20:47 | Russell, Kansas, US | |
695732 | 695732 | 2022-03-17 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-18 04:20:55 | Russell, Kansas, US | |
2320675 | 2320675 | 2022-03-16 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-17 04:20:56 | Russell, Kansas, US | |
262875 | 262875 | 2022-03-15 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-16 04:20:50 | Russell, Kansas, US | |
2265234 | 2265234 | 2022-03-14 | US | Kansas | Russell | 20167 | 1873 | 37 | 0 | 38.91462787 | -98.76254297 | 2022-03-15 04:20:47 | Russell, Kansas, US | |
2645259 | 2645259 | 2022-02-14 | US | West Virginia | Pendleton | 54071 | 1873 | 16 | 0 | 38.68314479 | -79.35084086 | 2022-02-15 04:21:09 | Pendleton, West Virginia, US | |
74707 | 74707 | 2022-02-07 | US | Wyoming | Sublette | 56035 | 1873 | 25 | 0 | 42.76558279 | -109.91309220000001 | 2022-02-08 04:21:15 | Sublette, Wyoming, US | |
980759 | 980759 | 2022-02-01 | US | Mississippi | Humphreys | 28053 | 1873 | 40 | 0 | 33.12825718 | -90.52252707 | 2022-02-02 04:21:09 | Humphreys, Mississippi, US | |
979469 | 979469 | 2022-02-01 | US | Arkansas | Prairie | 5117 | 1873 | 33 | 0 | 34.83624419 | -91.55162157 | 2022-02-02 04:21:09 | Prairie, Arkansas, US | |
1780165 | 1780165 | 2022-01-27 | US | Georgia | Clinch | 13065 | 1873 | 37 | 0 | 30.91395822 | -82.70432472 | 2022-01-28 04:21:09 | Clinch, Georgia, US | |
2053167 | 2053167 | 2022-01-25 | US | Kansas | Ellsworth | 20053 | 1873 | 30 | 0 | 38.69677695 | -98.20462799 | 2022-01-26 04:21:07 | Ellsworth, Kansas, US | |
1228898 | 1228898 | 2022-01-24 | US | Kansas | Ellsworth | 20053 | 1873 | 30 | 0 | 38.69677695 | -98.20462799 | 2022-01-25 04:21:05 | Ellsworth, Kansas, US | |
1143928 | 1143928 | 2022-01-23 | US | Texas | Archer | 48009 | 1873 | 24 | 0 | 33.61569967 | -98.68754589 | 2022-01-24 04:21:12 | Archer, Texas, US | |
1962638 | 1962638 | 2022-01-20 | US | Nebraska | Hamilton | 31081 | 1873 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-01-21 04:21:09 | Hamilton, Nebraska, US | |
3688281 | 3688281 | 2022-01-13 | US | Georgia | Evans | 13109 | 1873 | 58 | 0 | 32.15328841 | -81.8870105 | 2022-01-14 04:21:54 | Evans, Georgia, US | |
1392382 | 1392382 | 2022-01-07 | US | Puerto Rico | Barceloneta | 72017 | 1873 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-01-08 04:21:53 | Barceloneta, Puerto Rico, US | |
2611320 | 2611320 | 2022-01-06 | US | Kansas | Cloud | 20029 | 1873 | 33 | 0 | 39.48028352 | -97.64925343 | 2022-01-07 04:22:09 | Cloud, Kansas, US | |
1283262 | 1283262 | 2022-01-05 | US | Kansas | Cloud | 20029 | 1873 | 33 | 0 | 39.48028352 | -97.64925343 | 2022-01-06 04:22:09 | Cloud, Kansas, US | |
3521078 | 3521078 | 2022-01-02 | US | Michigan | Iron | 26071 | 1873 | 71 | 0 | 46.20974132 | -88.53136251 | 2022-01-03 02:22:25 | Iron, Michigan, US | |
2170758 | 2170758 | 2022-01-01 | US | Texas | Parmer | 48369 | 1873 | 44 | 0 | 34.52993409 | -102.78446679999999 | 2022-01-02 04:20:52 | Parmer, Texas, US | |
2169208 | 2169208 | 2022-01-01 | US | Michigan | Iron | 26071 | 1873 | 71 | 0 | 46.20974132 | -88.53136251 | 2022-01-02 04:20:52 | Iron, Michigan, US | |
2778639 | 2778639 | 2021-12-31 | US | Michigan | Iron | 26071 | 1873 | 71 | 0 | 46.20974132 | -88.53136251 | 2022-01-01 04:22:14 | Iron, Michigan, US | |
4000296 | 4000296 | 2021-12-30 | US | Michigan | Iron | 26071 | 1873 | 71 | 0 | 46.20974132 | -88.53136251 | 2021-12-31 04:21:50 | Iron, Michigan, US | |
1670103 | 1670103 | 2021-12-29 | US | Michigan | Iron | 26071 | 1873 | 71 | 0 | 46.20974132 | -88.53136251 | 2021-12-30 04:21:25 | Iron, Michigan, US | |
2115246 | 2115246 | 2021-12-26 | US | Wisconsin | Forest | 55041 | 1873 | 40 | 0 | 45.66678019 | -88.77084892 | 2021-12-27 04:21:58 | Forest, Wisconsin, US | |
2113011 | 2113011 | 2021-12-26 | US | Kansas | Linn | 20107 | 1873 | 22 | 0 | 38.21267844 | -94.84254089 | 2021-12-27 04:21:58 | Linn, Kansas, US | |
3608618 | 3608618 | 2021-12-25 | US | Wisconsin | Forest | 55041 | 1873 | 40 | 0 | 45.66678019 | -88.77084892 | 2021-12-26 04:21:50 | Forest, Wisconsin, US | |
3606383 | 3606383 | 2021-12-25 | US | Kansas | Linn | 20107 | 1873 | 22 | 0 | 38.21267844 | -94.84254089 | 2021-12-26 04:21:50 | Linn, Kansas, US | |
2966936 | 2966936 | 2021-12-24 | US | Wisconsin | Forest | 55041 | 1873 | 40 | 0 | 45.66678019 | -88.77084892 | 2021-12-25 04:21:37 | Forest, Wisconsin, US | |
2964701 | 2964701 | 2021-12-24 | US | Kansas | Linn | 20107 | 1873 | 22 | 0 | 38.21267844 | -94.84254089 | 2021-12-25 04:21:37 | Linn, Kansas, US | |
3817733 | 3817733 | 2021-12-23 | US | Kansas | Linn | 20107 | 1873 | 22 | 0 | 38.21267844 | -94.84254089 | 2021-12-24 04:21:34 | Linn, Kansas, US | |
801976 | 801976 | 2021-12-22 | US | Wisconsin | Forest | 55041 | 1873 | 40 | 0 | 45.66678019 | -88.77084892 | 2021-12-23 04:21:21 | Forest, Wisconsin, US | |
799741 | 799741 | 2021-12-22 | US | Kansas | Linn | 20107 | 1873 | 22 | 0 | 38.21267844 | -94.84254089 | 2021-12-23 04:21:21 | Linn, Kansas, US | |
2400717 | 2400717 | 2021-12-17 | US | Missouri | Douglas | 29067 | 1873 | 63 | 0 | 36.9325593 | -92.49905109 | 2021-12-18 02:22:20 | Douglas, Missouri, US | |
3655956 | 3655956 | 2021-12-10 | US | Alabama | Coosa | 1037 | 1873 | 48 | 0 | 32.93690146 | -86.24847739 | 2021-12-11 04:22:45 | Coosa, Alabama, US | |
552144 | 552144 | 2021-12-08 | US | Kentucky | Bath | 21011 | 1873 | 33 | 0 | 38.14735938 | -83.74588932 | 2021-12-09 04:22:49 | Bath, Kentucky, US | |
3403313 | 3403313 | 2021-11-30 | US | Missouri | Barton | 29011 | 1873 | 31 | 0 | 37.50207671 | -94.34757022 | 2021-12-01 04:22:29 | Barton, Missouri, US | |
1232116 | 1232116 | 2021-11-28 | US | Arkansas | Fulton | 5049 | 1873 | 67 | 0 | 36.38177105 | -91.81729127 | 2021-11-29 04:22:30 | Fulton, Arkansas, US | |
1358823 | 1358823 | 2021-11-27 | US | Arkansas | Fulton | 5049 | 1873 | 67 | 0 | 36.38177105 | -91.81729127 | 2021-11-28 04:22:43 | Fulton, Arkansas, US | |
3749728 | 3749728 | 2021-11-22 | US | Colorado | Archuleta | 8007 | 1873 | 9 | 0 | 37.19474156 | -107.04768670000001 | 2021-11-23 04:22:39 | Archuleta, Colorado, US | |
1017289 | 1017289 | 2021-11-21 | US | Tennessee | Houston | 47083 | 1873 | 45 | 0 | 36.28872054 | -87.71878828 | 2021-11-22 04:22:20 | Houston, Tennessee, US | |
725453 | 725453 | 2021-11-20 | US | Tennessee | Houston | 47083 | 1873 | 45 | 0 | 36.28872054 | -87.71878828 | 2021-11-21 04:22:13 | Houston, Tennessee, US | |
449296 | 449296 | 2021-11-17 | US | Missouri | Linn | 29115 | 1873 | 27 | 0 | 39.87001769 | -93.10704106 | 2021-11-18 04:21:33 | Linn, Missouri, US | |
3345236 | 3345236 | 2021-11-16 | US | Oregon | Curry | 41015 | 1873 | 33 | 0 | 42.45911325 | -124.15728200000001 | 2021-11-17 04:21:48 | Curry, Oregon, US | |
3345180 | 3345180 | 2021-11-16 | US | Oklahoma | Haskell | 40061 | 1873 | 29 | 0 | 35.22257600000001 | -95.11513306 | 2021-11-17 04:21:48 | Haskell, Oklahoma, US | |
2290016 | 2290016 | 2021-11-15 | US | Oklahoma | Haskell | 40061 | 1873 | 29 | 0 | 35.22257600000001 | -95.11513306 | 2021-11-16 04:21:10 | Haskell, Oklahoma, US | |
2289213 | 2289213 | 2021-11-15 | US | Minnesota | Pope | 27121 | 1873 | 10 | 0 | 45.58606667 | -95.44451209 | 2021-11-16 04:21:10 | Pope, Minnesota, US | |
1324790 | 1324790 | 2021-11-14 | US | Oklahoma | Haskell | 40061 | 1873 | 29 | 0 | 35.22257600000001 | -95.11513306 | 2021-11-15 04:21:36 | Haskell, Oklahoma, US | |
688916 | 688916 | 2021-11-13 | US | Oklahoma | Haskell | 40061 | 1873 | 29 | 0 | 35.22257600000001 | -95.11513306 | 2021-11-14 04:21:31 | Haskell, Oklahoma, US | |
717025 | 717025 | 2021-11-12 | US | Oklahoma | Haskell | 40061 | 1873 | 29 | 0 | 35.22257600000001 | -95.11513306 | 2021-11-13 04:21:38 | Haskell, Oklahoma, US | |
3642312 | 3642312 | 2021-11-08 | US | Puerto Rico | Manati | 72091 | 1873 | 0 | 0 | 18.420473 | -66.490461 | 2021-11-09 04:21:36 | Manati, Puerto Rico, US | |
2003420 | 2003420 | 2021-11-07 | US | Puerto Rico | Manati | 72091 | 1873 | 0 | 0 | 18.420473 | -66.490461 | 2021-11-08 04:21:43 | Manati, 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]);