daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
57 rows where confirmed = 8997 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-22 | US | Virginia | Russell | 51167 | 8997 | 127 | 0 | 36.9302832 | -82.10095486 | 2022-12-23 04:21:04 | Russell, Virginia, US | |
2022-12-08 | US | Tennessee | Lauderdale | 47097 | 8997 | 114 | 0 | 35.75893438 | -89.6301591 | 2022-12-09 04:21:05 | Lauderdale, Tennessee, US | |
2022-11-18 | US | Tennessee | Hardeman | 47069 | 8997 | 131 | 0 | 35.20772017 | -88.99161161 | 2022-11-19 04:21:14 | Hardeman, Tennessee, US | |
2022-11-08 | US | Tennessee | McNairy | 47109 | 8997 | 138 | 0 | 35.17468549 | -88.5647812 | 2022-11-09 04:21:22 | McNairy, Tennessee, US | |
2022-10-25 | US | Maryland | Dorchester | 24019 | 8997 | 113 | 0 | 38.45413522 | -76.02752426 | 2022-10-26 04:22:19 | Dorchester, Maryland, US | |
2022-10-04 | US | Kansas | Miami | 20121 | 8997 | 105 | 0 | 38.56383358 | -94.83832189 | 2022-10-05 04:23:06 | Miami, Kansas, US | |
2022-10-03 | US | Kansas | Miami | 20121 | 8997 | 105 | 0 | 38.56383358 | -94.83832189 | 2022-10-04 04:22:55 | Miami, Kansas, US | |
2022-10-02 | US | Kansas | Miami | 20121 | 8997 | 105 | 0 | 38.56383358 | -94.83832189 | 2022-10-03 04:23:11 | Miami, Kansas, US | |
2022-10-01 | US | Kansas | Miami | 20121 | 8997 | 105 | 0 | 38.56383358 | -94.83832189 | 2022-10-02 04:21:23 | Miami, Kansas, US | |
2022-09-30 | US | Kansas | Miami | 20121 | 8997 | 105 | 0 | 38.56383358 | -94.83832189 | 2022-10-01 04:23:01 | Miami, Kansas, US | |
2022-09-29 | US | Kansas | Miami | 20121 | 8997 | 105 | 0 | 38.56383358 | -94.83832189 | 2022-09-30 04:23:09 | Miami, Kansas, US | |
2022-09-28 | US | Kansas | Miami | 20121 | 8997 | 105 | 0 | 38.56383358 | -94.83832189 | 2022-09-29 04:22:34 | Miami, Kansas, US | |
2022-09-19 | US | Louisiana | De Soto | 22031 | 8997 | 141 | 0 | 32.05457447 | -93.74130302 | 2022-09-20 04:22:48 | De Soto, Louisiana, US | |
2022-09-06 | US | West Virginia | Mingo | 54059 | 8997 | 127 | 0 | 37.73048351 | -82.13338365 | 2022-09-07 04:20:59 | Mingo, West Virginia, US | |
2022-08-11 | US | Tennessee | Henry | 47079 | 8997 | 165 | 0 | 36.33160906 | -88.30121797 | 2022-08-12 04:20:54 | Henry, Tennessee, US | |
2022-06-15 | US | Tennessee | Hardin | 47071 | 8997 | 150 | 0 | 35.19732531 | -88.18593755 | 2022-06-16 04:20:55 | Hardin, Tennessee, US | |
2022-05-18 | US | Texas | Hill | 48217 | 8997 | 192 | 0 | 31.99045053 | -97.13423143 | 2022-05-19 04:20:54 | Hill, Texas, US | |
2022-05-14 | US | Tennessee | Carroll | 47017 | 8997 | 156 | 0 | 35.97366108 | -88.45189331 | 2022-05-15 04:20:53 | Carroll, Tennessee, US | |
2022-05-13 | US | Tennessee | Carroll | 47017 | 8997 | 156 | 0 | 35.97366108 | -88.45189331 | 2022-05-14 04:20:48 | Carroll, Tennessee, US | |
2022-03-06 | US | Tennessee | Scott | 47151 | 8997 | 111 | 0 | 36.42325673 | -84.50360494 | 2022-03-07 04:20:47 | Scott, Tennessee, US | |
2022-03-05 | US | Tennessee | Scott | 47151 | 8997 | 111 | 0 | 36.42325673 | -84.50360494 | 2022-03-06 04:20:49 | Scott, Tennessee, US | |
2022-02-03 | US | Illinois | Morgan | 17137 | 8997 | 114 | 0 | 39.71654544 | -90.20255104 | 2022-02-04 04:21:10 | Morgan, Illinois, US | |
2022-02-02 | US | Illinois | Morgan | 17137 | 8997 | 114 | 0 | 39.71654544 | -90.20255104 | 2022-02-03 04:21:21 | Morgan, Illinois, US | |
2022-02-02 | US | Arkansas | Boone | 5009 | 8997 | 146 | 0 | 36.3084504 | -93.09374925 | 2022-02-03 04:21:21 | Boone, Arkansas, US | |
2022-01-31 | US | Texas | Lamar | 48277 | 8997 | 231 | 0 | 33.66981763 | -95.57404777 | 2022-02-01 04:21:11 | Lamar, Texas, US | |
2022-01-03 | US | Nevada | Elko | 32007 | 8997 | 124 | 0 | 41.14531606 | -115.3577619 | 2022-01-04 04:22:17 | Elko, Nevada, US | |
2021-12-07 | US | Georgia | Effingham | 13103 | 8997 | 175 | 0 | 32.36616021 | -81.34280942 | 2021-12-08 04:22:46 | Effingham, Georgia, US | |
2021-11-30 | US | Arkansas | Crittenden | 5035 | 8997 | 180 | 0 | 35.21247318 | -90.30839406 | 2021-12-01 04:22:29 | Crittenden, Arkansas, US | |
2021-11-11 | US | Ohio | Jefferson | 39081 | 8997 | 229 | 0 | 40.38614126 | -80.76259514 | 2021-11-12 04:22:01 | Jefferson, Ohio, US | |
2021-10-01 | US | Maryland | Allegany | 24001 | 8997 | 233 | 0 | 39.62357628 | -78.69280486 | 2021-10-02 04:21:25 | Allegany, Maryland, US | |
2021-09-10 | US | New York | Oswego | 36075 | 8997 | 98 | 0 | 43.42778894 | -76.14635194 | 2021-09-11 04:21:30 | Oswego, New York, US | |
2021-08-22 | US | Tennessee | Tipton | 47167 | 8997 | 109 | 0 | 35.501942 | -89.73694895 | 2021-08-23 04:21:27 | Tipton, Tennessee, US | |
2021-07-27 | US | New York | Chautauqua | 36013 | 8997 | 146 | 0 | 42.22769210000001 | -79.36691763 | 2021-07-28 04:21:39 | Chautauqua, New York, US | |
2021-07-22 | US | West Virginia | Cabell | 54011 | 8997 | 178 | 0 | 38.42424062 | -82.23855912 | 2021-07-23 04:21:29 | Cabell, West Virginia, US | |
2021-06-05 | US | Ohio | Columbiana | 39029 | 8997 | 232 | 0 | 40.76932373 | -80.78094576 | 2021-06-06 04:24:03 | Columbiana, Ohio, US | |
2021-05-14 | US | Georgia | Fayette | 13113 | 8997 | 169 | 0 | 33.41357794 | -84.49089434 | 2021-05-15 04:20:58 | Fayette, Georgia, US | |
2021-04-23 | Colombia | Putumayo | 8997 | 336 | 8380 | 281 | 0.436 | -75.5277 | 2021-04-24 04:20:38 | Putumayo, Colombia | ||
2021-04-22 | US | Missouri | Cass | 29037 | 8997 | 107 | 0 | 38.64789422 | -94.353399 | 2021-04-23 04:20:52 | Cass, Missouri, US | |
2021-04-07 | Sweden | Jamtland Harjedalen | 8997 | 118 | 0 | 8879 | 63.1712 | 14.9592 | 2021-04-08 04:21:13 | Jamtland Harjedalen, Sweden | ||
2021-04-06 | US | North Carolina | Caldwell | 37027 | 8997 | 102 | 0 | 35.95204977 | -81.54799522 | 2021-04-07 04:20:53 | Caldwell, North Carolina, US | |
2021-03-11 | Suriname | 8997 | 176 | 8505 | 316 | 3.9193 | -56.0278 | 2021-03-12 05:26:50 | Suriname | |||
2021-03-10 | US | California | Sutter | 6101 | 8997 | 101 | 0 | 39.03417539 | -121.6945899 | 2021-03-11 05:25:48 | Sutter, California, US | |
2021-02-23 | US | California | Napa | 6055 | 8997 | 70 | 0 | 8929 | 38.50735751 | -122.332839 | 2021-02-24 05:29:16 | Napa, California, US |
2021-01-05 | US | Louisiana | Livingston | 22063 | 8997 | 129 | 0 | 8868 | 30.44143993 | -90.73061664 | 2021-01-06 05:22:16 | Livingston, Louisiana, US |
2020-12-21 | Mexico | Morelos | 8997 | 1374 | 0 | 7623 | 18.6813 | -99.1013 | 2020-12-22 05:22:33 | Morelos, Mexico | ||
2020-12-19 | US | New York | Albany | 36001 | 8997 | 179 | 0 | 8818 | 42.60060306 | -73.97723916 | 2020-12-20 05:27:32 | Albany, New York, US |
2020-11-28 | US | Illinois | Peoria | 17143 | 8997 | 129 | 0 | 8868 | 40.78702156 | -89.76078901 | 2020-11-29 05:25:55 | Peoria, Illinois, US |
2020-10-27 | Russia | Tver Oblast | 8997 | 304 | 5204 | 3489 | 57.1134475 | 35.174442799999994 | 2020-10-28 04:24:39 | Tver Oblast, Russia | ||
2020-10-24 | US | Colorado | Jefferson | 8059 | 8997 | 308 | 0 | 7596 | 39.58635604 | -105.2517692 | 2020-10-25 04:24:36 | Jefferson, Colorado, US |
2020-10-24 | Russia | Karachay-Cherkess Republic | 8997 | 30 | 5290 | 3677 | 43.7368326 | 41.7267991 | 2020-10-25 04:24:36 | Karachay-Cherkess Republic, Russia | ||
2020-10-10 | Italy | Sicilia | 8997 | 335 | 4519 | 4143 | 38.11569725 | 13.362356699999998 | 2020-10-11 04:23:46 | Sicilia, Italy | ||
2020-10-07 | Russia | Yaroslavl Oblast | 8997 | 47 | 8371 | 579 | 57.77819760000001 | 39.0021095 | 2020-10-08 04:23:56 | Yaroslavl Oblast, Russia | ||
2020-09-06 | US | Colorado | Arapahoe | 8005 | 8997 | 376 | 0 | 7930 | 39.64977461 | -104.3353617 | 2020-09-07 04:28:30 | Arapahoe, Colorado, US |
2020-08-25 | US | Florida | Volusia | 12127 | 8997 | 182 | 0 | 8815 | 29.05858895 | -81.18263252 | 2020-08-26 04:28:11 | Volusia, Florida, US |
2020-07-09 | Peru | Ica | 8997 | 1586 | 0 | 7411 | -14.235097 | -75.574821 | 2020-07-10 04:34:24 | Ica, Peru | ||
2020-06-17 | Morocco | 8997 | 213 | 7993 | 791 | 31.7917 | -7.0926 | 2020-06-18 04:33:18 | Morocco | |||
2020-05-28 | Algeria | 8997 | 630 | 5277 | 3090 | 28.0339 | 1.6596 | 2020-05-29 02:32:50 | Algeria |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;