daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17,620 rows where deaths = 48 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
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-29 | US | Texas | Castro | 48069 | 2690 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-30 04:21:04 | Castro, Texas, US | |
2022-12-29 | US | Tennessee | Van Buren | 47175 | 2191 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-30 04:21:04 | Van Buren, Tennessee, US | |
2022-12-29 | US | South Dakota | Butte | 46019 | 3173 | 48 | 0 | 44.90608745 | -103.5079318 | 2022-12-30 04:21:04 | Butte, South Dakota, US | |
2022-12-29 | US | Oklahoma | Marshall | 40095 | 5465 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-30 04:21:04 | Marshall, Oklahoma, US | |
2022-12-29 | US | North Carolina | Avery | 37011 | 5402 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-30 04:21:04 | Avery, North Carolina, US | |
2022-12-29 | US | Missouri | Iron | 29093 | 2597 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-30 04:21:04 | Iron, Missouri, US | |
2022-12-29 | US | Louisiana | West Feliciana | 22125 | 3200 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-30 04:21:04 | West Feliciana, Louisiana, US | |
2022-12-29 | US | Louisiana | Plaquemines | 22075 | 7688 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-30 04:21:04 | Plaquemines, Louisiana, US | |
2022-12-29 | US | Kansas | Cloud | 20029 | 2608 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-30 04:21:04 | Cloud, Kansas, US | |
2022-12-29 | US | Iowa | Franklin | 19069 | 2890 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-30 04:21:04 | Franklin, Iowa, US | |
2022-12-29 | US | Illinois | Greene | 17061 | 4205 | 48 | 0 | 39.35907414 | -90.388865 | 2022-12-30 04:21:04 | Greene, Illinois, US | |
2022-12-29 | US | Illinois | Crawford | 17033 | 7687 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-30 04:21:04 | Crawford, Illinois, US | |
2022-12-29 | US | Arkansas | Scott | 5127 | 2784 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-30 04:21:04 | Scott, Arkansas, US | |
2022-12-29 | US | Arkansas | Pike | 5109 | 2858 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-30 04:21:04 | Pike, Arkansas, US | |
2022-12-29 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-30 04:21:04 | Wilcox, Alabama, US | |
2022-12-28 | US | Texas | Castro | 48069 | 2690 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-29 04:21:01 | Castro, Texas, US | |
2022-12-28 | US | Tennessee | Van Buren | 47175 | 2191 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-29 04:21:01 | Van Buren, Tennessee, US | |
2022-12-28 | US | South Dakota | Butte | 46019 | 3173 | 48 | 0 | 44.90608745 | -103.5079318 | 2022-12-29 04:21:01 | Butte, South Dakota, US | |
2022-12-28 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-29 04:21:01 | Marshall, Oklahoma, US | |
2022-12-28 | US | North Carolina | Avery | 37011 | 5402 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-29 04:21:01 | Avery, North Carolina, US | |
2022-12-28 | US | Missouri | Iron | 29093 | 2597 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-29 04:21:01 | Iron, Missouri, US | |
2022-12-28 | US | Louisiana | West Feliciana | 22125 | 3200 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-29 04:21:01 | West Feliciana, Louisiana, US | |
2022-12-28 | US | Louisiana | Plaquemines | 22075 | 7688 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-29 04:21:01 | Plaquemines, Louisiana, US | |
2022-12-28 | US | Kansas | Cloud | 20029 | 2608 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-29 04:21:01 | Cloud, Kansas, US | |
2022-12-28 | US | Iowa | Franklin | 19069 | 2890 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-29 04:21:01 | Franklin, Iowa, US | |
2022-12-28 | US | Illinois | Greene | 17061 | 4204 | 48 | 0 | 39.35907414 | -90.388865 | 2022-12-29 04:21:01 | Greene, Illinois, US | |
2022-12-28 | US | Illinois | Crawford | 17033 | 7683 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-29 04:21:01 | Crawford, Illinois, US | |
2022-12-28 | US | Arkansas | Scott | 5127 | 2784 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-29 04:21:01 | Scott, Arkansas, US | |
2022-12-28 | US | Arkansas | Pike | 5109 | 2858 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-29 04:21:01 | Pike, Arkansas, US | |
2022-12-28 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-29 04:21:01 | Wilcox, Alabama, US | |
2022-12-27 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-28 04:21:04 | Castro, Texas, US | |
2022-12-27 | US | Tennessee | Van Buren | 47175 | 2191 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-28 04:21:04 | Van Buren, Tennessee, US | |
2022-12-27 | US | South Dakota | Butte | 46019 | 3168 | 48 | 0 | 44.90608745 | -103.5079318 | 2022-12-28 04:21:04 | Butte, South Dakota, US | |
2022-12-27 | US | Oregon | Hood River | 41027 | 4544 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-12-28 04:21:04 | Hood River, Oregon, US | |
2022-12-27 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-28 04:21:04 | Marshall, Oklahoma, US | |
2022-12-27 | US | North Carolina | Avery | 37011 | 5402 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-28 04:21:04 | Avery, North Carolina, US | |
2022-12-27 | US | Missouri | Iron | 29093 | 2597 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-28 04:21:04 | Iron, Missouri, US | |
2022-12-27 | US | Louisiana | West Feliciana | 22125 | 3180 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-28 04:21:04 | West Feliciana, Louisiana, US | |
2022-12-27 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-28 04:21:04 | Plaquemines, Louisiana, US | |
2022-12-27 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-28 04:21:04 | Cloud, Kansas, US | |
2022-12-27 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-28 04:21:04 | Franklin, Iowa, US | |
2022-12-27 | US | Illinois | Crawford | 17033 | 7677 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-28 04:21:04 | Crawford, Illinois, US | |
2022-12-27 | US | Arkansas | Scott | 5127 | 2785 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-28 04:21:04 | Scott, Arkansas, US | |
2022-12-27 | US | Arkansas | Pike | 5109 | 2854 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-28 04:21:04 | Pike, Arkansas, US | |
2022-12-27 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-28 04:21:04 | Wilcox, Alabama, US | |
2022-12-26 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-27 04:21:07 | Castro, Texas, US | |
2022-12-26 | US | Tennessee | Van Buren | 47175 | 2191 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-27 04:21:07 | Van Buren, Tennessee, US | |
2022-12-26 | US | South Dakota | Butte | 46019 | 3168 | 48 | 0 | 44.90608745 | -103.5079318 | 2022-12-27 04:21:07 | Butte, South Dakota, US | |
2022-12-26 | US | Oregon | Hood River | 41027 | 4544 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-12-27 04:21:07 | Hood River, Oregon, US | |
2022-12-26 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-27 04:21:07 | Marshall, Oklahoma, US | |
2022-12-26 | US | North Carolina | Avery | 37011 | 5402 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-27 04:21:07 | Avery, North Carolina, US | |
2022-12-26 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-27 04:21:07 | Iron, Missouri, US | |
2022-12-26 | US | Louisiana | West Feliciana | 22125 | 3180 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-27 04:21:07 | West Feliciana, Louisiana, US | |
2022-12-26 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-27 04:21:07 | Plaquemines, Louisiana, US | |
2022-12-26 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-27 04:21:07 | Cloud, Kansas, US | |
2022-12-26 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-27 04:21:07 | Franklin, Iowa, US | |
2022-12-26 | US | Illinois | Crawford | 17033 | 7667 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-27 04:21:07 | Crawford, Illinois, US | |
2022-12-26 | US | Arkansas | Scott | 5127 | 2783 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-27 04:21:07 | Scott, Arkansas, US | |
2022-12-26 | US | Arkansas | Pike | 5109 | 2853 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-27 04:21:07 | Pike, Arkansas, US | |
2022-12-26 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-27 04:21:07 | Wilcox, Alabama, US | |
2022-12-25 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-26 04:21:06 | Castro, Texas, US | |
2022-12-25 | US | Tennessee | Van Buren | 47175 | 2191 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-26 04:21:06 | Van Buren, Tennessee, US | |
2022-12-25 | US | South Dakota | Butte | 46019 | 3168 | 48 | 0 | 44.90608745 | -103.5079318 | 2022-12-26 04:21:06 | Butte, South Dakota, US | |
2022-12-25 | US | Oregon | Hood River | 41027 | 4544 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-12-26 04:21:06 | Hood River, Oregon, US | |
2022-12-25 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-26 04:21:06 | Marshall, Oklahoma, US | |
2022-12-25 | US | North Carolina | Avery | 37011 | 5402 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-26 04:21:06 | Avery, North Carolina, US | |
2022-12-25 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-26 04:21:06 | Iron, Missouri, US | |
2022-12-25 | US | Louisiana | West Feliciana | 22125 | 3180 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-26 04:21:06 | West Feliciana, Louisiana, US | |
2022-12-25 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-26 04:21:06 | Plaquemines, Louisiana, US | |
2022-12-25 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-26 04:21:06 | Cloud, Kansas, US | |
2022-12-25 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-26 04:21:06 | Franklin, Iowa, US | |
2022-12-25 | US | Illinois | Crawford | 17033 | 7667 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-26 04:21:06 | Crawford, Illinois, US | |
2022-12-25 | US | Arkansas | Scott | 5127 | 2782 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-26 04:21:06 | Scott, Arkansas, US | |
2022-12-25 | US | Arkansas | Pike | 5109 | 2853 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-26 04:21:06 | Pike, Arkansas, US | |
2022-12-25 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-26 04:21:06 | Wilcox, Alabama, US | |
2022-12-24 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-25 04:21:04 | Castro, Texas, US | |
2022-12-24 | US | Tennessee | Van Buren | 47175 | 2191 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-25 04:21:04 | Van Buren, Tennessee, US | |
2022-12-24 | US | South Dakota | Butte | 46019 | 3168 | 48 | 0 | 44.90608745 | -103.5079318 | 2022-12-25 04:21:04 | Butte, South Dakota, US | |
2022-12-24 | US | Oregon | Hood River | 41027 | 4544 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-12-25 04:21:04 | Hood River, Oregon, US | |
2022-12-24 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-25 04:21:04 | Marshall, Oklahoma, US | |
2022-12-24 | US | North Carolina | Avery | 37011 | 5402 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-25 04:21:04 | Avery, North Carolina, US | |
2022-12-24 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-25 04:21:04 | Iron, Missouri, US | |
2022-12-24 | US | Louisiana | West Feliciana | 22125 | 3180 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-25 04:21:04 | West Feliciana, Louisiana, US | |
2022-12-24 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-25 04:21:04 | Plaquemines, Louisiana, US | |
2022-12-24 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-25 04:21:04 | Cloud, Kansas, US | |
2022-12-24 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-25 04:21:04 | Franklin, Iowa, US | |
2022-12-24 | US | Illinois | Crawford | 17033 | 7667 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-25 04:21:04 | Crawford, Illinois, US | |
2022-12-24 | US | Arkansas | Scott | 5127 | 2782 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-25 04:21:04 | Scott, Arkansas, US | |
2022-12-24 | US | Arkansas | Pike | 5109 | 2853 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-25 04:21:04 | Pike, Arkansas, US | |
2022-12-24 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-25 04:21:04 | Wilcox, Alabama, US | |
2022-12-23 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-24 04:21:02 | Castro, Texas, US | |
2022-12-23 | US | Tennessee | Van Buren | 47175 | 2191 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-24 04:21:02 | Van Buren, Tennessee, US | |
2022-12-23 | US | South Dakota | Butte | 46019 | 3168 | 48 | 0 | 44.90608745 | -103.5079318 | 2022-12-24 04:21:02 | Butte, South Dakota, US | |
2022-12-23 | US | Oregon | Hood River | 41027 | 4544 | 48 | 0 | 45.51872811 | -121.6552036 | 2022-12-24 04:21:02 | Hood River, Oregon, US | |
2022-12-23 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-24 04:21:02 | Marshall, Oklahoma, US | |
2022-12-23 | US | North Carolina | Avery | 37011 | 5402 | 48 | 0 | 36.07569796 | -81.92308483 | 2022-12-24 04:21:02 | Avery, North Carolina, US | |
2022-12-23 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-24 04:21:02 | Iron, Missouri, US | |
2022-12-23 | US | Louisiana | West Feliciana | 22125 | 3180 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-24 04:21:02 | West Feliciana, Louisiana, US | |
2022-12-23 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-24 04:21:02 | Plaquemines, Louisiana, US | |
2022-12-23 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-24 04:21:02 | Cloud, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;