johns_hopkins_csse_daily_reports
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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755953 | 2755953 | 2022-12-29 | US | Texas | Castro | 48069 | 2690 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-30 04:21:04 | Castro, Texas, US | |
2755911 | 2755911 | 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 | |
2755763 | 2755763 | 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 | |
2755481 | 2755481 | 2022-12-29 | US | Oklahoma | Marshall | 40095 | 5465 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-30 04:21:04 | Marshall, Oklahoma, US | |
2755197 | 2755197 | 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 | |
2754821 | 2754821 | 2022-12-29 | US | Missouri | Iron | 29093 | 2597 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-30 04:21:04 | Iron, Missouri, US | |
2754458 | 2754458 | 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 | |
2754432 | 2754432 | 2022-12-29 | US | Louisiana | Plaquemines | 22075 | 7688 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-30 04:21:04 | Plaquemines, Louisiana, US | |
2754180 | 2754180 | 2022-12-29 | US | Kansas | Cloud | 20029 | 2608 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-30 04:21:04 | Cloud, Kansas, US | |
2754100 | 2754100 | 2022-12-29 | US | Iowa | Franklin | 19069 | 2890 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-30 04:21:04 | Franklin, Iowa, US | |
2753899 | 2753899 | 2022-12-29 | US | Illinois | Greene | 17061 | 4205 | 48 | 0 | 39.35907414 | -90.388865 | 2022-12-30 04:21:04 | Greene, Illinois, US | |
2753885 | 2753885 | 2022-12-29 | US | Illinois | Crawford | 17033 | 7687 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-30 04:21:04 | Crawford, Illinois, US | |
2753432 | 2753432 | 2022-12-29 | US | Arkansas | Scott | 5127 | 2784 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-30 04:21:04 | Scott, Arkansas, US | |
2753424 | 2753424 | 2022-12-29 | US | Arkansas | Pike | 5109 | 2858 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-30 04:21:04 | Pike, Arkansas, US | |
2753319 | 2753319 | 2022-12-29 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-30 04:21:04 | Wilcox, Alabama, US | |
1076959 | 1076959 | 2022-12-28 | US | Texas | Castro | 48069 | 2690 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-29 04:21:01 | Castro, Texas, US | |
1076917 | 1076917 | 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 | |
1076769 | 1076769 | 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 | |
1076487 | 1076487 | 2022-12-28 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-29 04:21:01 | Marshall, Oklahoma, US | |
1076203 | 1076203 | 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 | |
1075827 | 1075827 | 2022-12-28 | US | Missouri | Iron | 29093 | 2597 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-29 04:21:01 | Iron, Missouri, US | |
1075464 | 1075464 | 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 | |
1075438 | 1075438 | 2022-12-28 | US | Louisiana | Plaquemines | 22075 | 7688 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-29 04:21:01 | Plaquemines, Louisiana, US | |
1075186 | 1075186 | 2022-12-28 | US | Kansas | Cloud | 20029 | 2608 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-29 04:21:01 | Cloud, Kansas, US | |
1075106 | 1075106 | 2022-12-28 | US | Iowa | Franklin | 19069 | 2890 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-29 04:21:01 | Franklin, Iowa, US | |
1074905 | 1074905 | 2022-12-28 | US | Illinois | Greene | 17061 | 4204 | 48 | 0 | 39.35907414 | -90.388865 | 2022-12-29 04:21:01 | Greene, Illinois, US | |
1074891 | 1074891 | 2022-12-28 | US | Illinois | Crawford | 17033 | 7683 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-29 04:21:01 | Crawford, Illinois, US | |
1074438 | 1074438 | 2022-12-28 | US | Arkansas | Scott | 5127 | 2784 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-29 04:21:01 | Scott, Arkansas, US | |
1074430 | 1074430 | 2022-12-28 | US | Arkansas | Pike | 5109 | 2858 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-29 04:21:01 | Pike, Arkansas, US | |
1074325 | 1074325 | 2022-12-28 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-29 04:21:01 | Wilcox, Alabama, US | |
330956 | 330956 | 2022-12-27 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-28 04:21:04 | Castro, Texas, US | |
330914 | 330914 | 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 | |
330766 | 330766 | 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 | |
330532 | 330532 | 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 | |
330484 | 330484 | 2022-12-27 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-28 04:21:04 | Marshall, Oklahoma, US | |
330200 | 330200 | 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 | |
329824 | 329824 | 2022-12-27 | US | Missouri | Iron | 29093 | 2597 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-28 04:21:04 | Iron, Missouri, US | |
329461 | 329461 | 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 | |
329435 | 329435 | 2022-12-27 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-28 04:21:04 | Plaquemines, Louisiana, US | |
329183 | 329183 | 2022-12-27 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-28 04:21:04 | Cloud, Kansas, US | |
329103 | 329103 | 2022-12-27 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-28 04:21:04 | Franklin, Iowa, US | |
328888 | 328888 | 2022-12-27 | US | Illinois | Crawford | 17033 | 7677 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-28 04:21:04 | Crawford, Illinois, US | |
328435 | 328435 | 2022-12-27 | US | Arkansas | Scott | 5127 | 2785 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-28 04:21:04 | Scott, Arkansas, US | |
328427 | 328427 | 2022-12-27 | US | Arkansas | Pike | 5109 | 2854 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-28 04:21:04 | Pike, Arkansas, US | |
328322 | 328322 | 2022-12-27 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-28 04:21:04 | Wilcox, Alabama, US | |
221029 | 221029 | 2022-12-26 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-27 04:21:07 | Castro, Texas, US | |
220987 | 220987 | 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 | |
220839 | 220839 | 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 | |
220605 | 220605 | 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 | |
220557 | 220557 | 2022-12-26 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-27 04:21:07 | Marshall, Oklahoma, US | |
220273 | 220273 | 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 | |
219897 | 219897 | 2022-12-26 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-27 04:21:07 | Iron, Missouri, US | |
219534 | 219534 | 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 | |
219508 | 219508 | 2022-12-26 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-27 04:21:07 | Plaquemines, Louisiana, US | |
219256 | 219256 | 2022-12-26 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-27 04:21:07 | Cloud, Kansas, US | |
219176 | 219176 | 2022-12-26 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-27 04:21:07 | Franklin, Iowa, US | |
218961 | 218961 | 2022-12-26 | US | Illinois | Crawford | 17033 | 7667 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-27 04:21:07 | Crawford, Illinois, US | |
218508 | 218508 | 2022-12-26 | US | Arkansas | Scott | 5127 | 2783 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-27 04:21:07 | Scott, Arkansas, US | |
218500 | 218500 | 2022-12-26 | US | Arkansas | Pike | 5109 | 2853 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-27 04:21:07 | Pike, Arkansas, US | |
218395 | 218395 | 2022-12-26 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-27 04:21:07 | Wilcox, Alabama, US | |
3225486 | 3225486 | 2022-12-25 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-26 04:21:06 | Castro, Texas, US | |
3225444 | 3225444 | 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 | |
3225296 | 3225296 | 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 | |
3225062 | 3225062 | 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 | |
3225014 | 3225014 | 2022-12-25 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-26 04:21:06 | Marshall, Oklahoma, US | |
3224730 | 3224730 | 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 | |
3224354 | 3224354 | 2022-12-25 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-26 04:21:06 | Iron, Missouri, US | |
3223991 | 3223991 | 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 | |
3223965 | 3223965 | 2022-12-25 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-26 04:21:06 | Plaquemines, Louisiana, US | |
3223713 | 3223713 | 2022-12-25 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-26 04:21:06 | Cloud, Kansas, US | |
3223633 | 3223633 | 2022-12-25 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-26 04:21:06 | Franklin, Iowa, US | |
3223418 | 3223418 | 2022-12-25 | US | Illinois | Crawford | 17033 | 7667 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-26 04:21:06 | Crawford, Illinois, US | |
3222965 | 3222965 | 2022-12-25 | US | Arkansas | Scott | 5127 | 2782 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-26 04:21:06 | Scott, Arkansas, US | |
3222957 | 3222957 | 2022-12-25 | US | Arkansas | Pike | 5109 | 2853 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-26 04:21:06 | Pike, Arkansas, US | |
3222852 | 3222852 | 2022-12-25 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-26 04:21:06 | Wilcox, Alabama, US | |
1021400 | 1021400 | 2022-12-24 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-25 04:21:04 | Castro, Texas, US | |
1021358 | 1021358 | 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 | |
1021210 | 1021210 | 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 | |
1020976 | 1020976 | 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 | |
1020928 | 1020928 | 2022-12-24 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-25 04:21:04 | Marshall, Oklahoma, US | |
1020644 | 1020644 | 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 | |
1020268 | 1020268 | 2022-12-24 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-25 04:21:04 | Iron, Missouri, US | |
1019905 | 1019905 | 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 | |
1019879 | 1019879 | 2022-12-24 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-25 04:21:04 | Plaquemines, Louisiana, US | |
1019627 | 1019627 | 2022-12-24 | US | Kansas | Cloud | 20029 | 2595 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-25 04:21:04 | Cloud, Kansas, US | |
1019547 | 1019547 | 2022-12-24 | US | Iowa | Franklin | 19069 | 2869 | 48 | 0 | 42.73270384 | -93.26256925 | 2022-12-25 04:21:04 | Franklin, Iowa, US | |
1019332 | 1019332 | 2022-12-24 | US | Illinois | Crawford | 17033 | 7667 | 48 | 0 | 39.0032229 | -87.75954624 | 2022-12-25 04:21:04 | Crawford, Illinois, US | |
1018879 | 1018879 | 2022-12-24 | US | Arkansas | Scott | 5127 | 2782 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-25 04:21:04 | Scott, Arkansas, US | |
1018871 | 1018871 | 2022-12-24 | US | Arkansas | Pike | 5109 | 2853 | 48 | 0 | 34.16250414 | -93.65789349 | 2022-12-25 04:21:04 | Pike, Arkansas, US | |
1018766 | 1018766 | 2022-12-24 | US | Alabama | Wilcox | 1131 | 3516 | 48 | 0 | 31.98773215 | -87.30891118 | 2022-12-25 04:21:04 | Wilcox, Alabama, US | |
693423 | 693423 | 2022-12-23 | US | Texas | Castro | 48069 | 2671 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-12-24 04:21:02 | Castro, Texas, US | |
693381 | 693381 | 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 | |
693233 | 693233 | 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 | |
692999 | 692999 | 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 | |
692951 | 692951 | 2022-12-23 | US | Oklahoma | Marshall | 40095 | 5449 | 48 | 0 | 34.02311222 | -96.76855464 | 2022-12-24 04:21:02 | Marshall, Oklahoma, US | |
692667 | 692667 | 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 | |
692291 | 692291 | 2022-12-23 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-24 04:21:02 | Iron, Missouri, US | |
691928 | 691928 | 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 | |
691902 | 691902 | 2022-12-23 | US | Louisiana | Plaquemines | 22075 | 7651 | 48 | 0 | 29.42245447 | -89.60322085 | 2022-12-24 04:21:02 | Plaquemines, Louisiana, US | |
691650 | 691650 | 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 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]);