johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,668 rows where deaths = 199 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756479 | 2756479 | 2022-12-29 | US | Wisconsin | Ozaukee | 55089 | 27248 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-30 04:21:04 | Ozaukee, Wisconsin, US | |
2756401 | 2756401 | 2022-12-29 | US | West Virginia | Marion | 54049 | 19713 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-30 04:21:04 | Marion, West Virginia, US | |
2756205 | 2756205 | 2022-12-29 | US | Virginia | Albemarle | 51003 | 24259 | 199 | 0 | 38.02080697 | -78.55481085 | 2022-12-30 04:21:04 | Albemarle, Virginia, US | |
2755422 | 2755422 | 2022-12-29 | US | Ohio | Shelby | 39149 | 13082 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-30 04:21:04 | Shelby, Ohio, US | |
2754455 | 2754455 | 2022-12-29 | US | Louisiana | Webster | 22119 | 14117 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-30 04:21:04 | Webster, Louisiana, US | |
2753978 | 2753978 | 2022-12-29 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-30 04:21:04 | Boone, Indiana, US | |
1077485 | 1077485 | 2022-12-28 | US | Wisconsin | Ozaukee | 55089 | 27228 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-29 04:21:01 | Ozaukee, Wisconsin, US | |
1077407 | 1077407 | 2022-12-28 | US | West Virginia | Marion | 54049 | 19673 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-29 04:21:01 | Marion, West Virginia, US | |
1077211 | 1077211 | 2022-12-28 | US | Virginia | Albemarle | 51003 | 24259 | 199 | 0 | 38.02080697 | -78.55481085 | 2022-12-29 04:21:01 | Albemarle, Virginia, US | |
1076428 | 1076428 | 2022-12-28 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-29 04:21:01 | Shelby, Ohio, US | |
1075461 | 1075461 | 2022-12-28 | US | Louisiana | Webster | 22119 | 14117 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-29 04:21:01 | Webster, Louisiana, US | |
1074984 | 1074984 | 2022-12-28 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-29 04:21:01 | Boone, Indiana, US | |
331482 | 331482 | 2022-12-27 | US | Wisconsin | Ozaukee | 55089 | 27206 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-28 04:21:04 | Ozaukee, Wisconsin, US | |
331404 | 331404 | 2022-12-27 | US | West Virginia | Marion | 54049 | 19642 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-28 04:21:04 | Marion, West Virginia, US | |
331208 | 331208 | 2022-12-27 | US | Virginia | Albemarle | 51003 | 24231 | 199 | 0 | 38.02080697 | -78.55481085 | 2022-12-28 04:21:04 | Albemarle, Virginia, US | |
330425 | 330425 | 2022-12-27 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-28 04:21:04 | Shelby, Ohio, US | |
329458 | 329458 | 2022-12-27 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-28 04:21:04 | Webster, Louisiana, US | |
328981 | 328981 | 2022-12-27 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-28 04:21:04 | Boone, Indiana, US | |
221555 | 221555 | 2022-12-26 | US | Wisconsin | Ozaukee | 55089 | 27201 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-27 04:21:07 | Ozaukee, Wisconsin, US | |
221477 | 221477 | 2022-12-26 | US | West Virginia | Marion | 54049 | 19564 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-27 04:21:07 | Marion, West Virginia, US | |
220498 | 220498 | 2022-12-26 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-27 04:21:07 | Shelby, Ohio, US | |
219531 | 219531 | 2022-12-26 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-27 04:21:07 | Webster, Louisiana, US | |
219054 | 219054 | 2022-12-26 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-27 04:21:07 | Boone, Indiana, US | |
3226012 | 3226012 | 2022-12-25 | US | Wisconsin | Ozaukee | 55089 | 27169 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-26 04:21:06 | Ozaukee, Wisconsin, US | |
3225934 | 3225934 | 2022-12-25 | US | West Virginia | Marion | 54049 | 19564 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-26 04:21:06 | Marion, West Virginia, US | |
3224955 | 3224955 | 2022-12-25 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-26 04:21:06 | Shelby, Ohio, US | |
3223988 | 3223988 | 2022-12-25 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-26 04:21:06 | Webster, Louisiana, US | |
3223511 | 3223511 | 2022-12-25 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-26 04:21:06 | Boone, Indiana, US | |
1021926 | 1021926 | 2022-12-24 | US | Wisconsin | Ozaukee | 55089 | 27169 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-25 04:21:04 | Ozaukee, Wisconsin, US | |
1021848 | 1021848 | 2022-12-24 | US | West Virginia | Marion | 54049 | 19564 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-25 04:21:04 | Marion, West Virginia, US | |
1020869 | 1020869 | 2022-12-24 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-25 04:21:04 | Shelby, Ohio, US | |
1019902 | 1019902 | 2022-12-24 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-25 04:21:04 | Webster, Louisiana, US | |
1019425 | 1019425 | 2022-12-24 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-25 04:21:04 | Boone, Indiana, US | |
693949 | 693949 | 2022-12-23 | US | Wisconsin | Ozaukee | 55089 | 27169 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-24 04:21:02 | Ozaukee, Wisconsin, US | |
693871 | 693871 | 2022-12-23 | US | West Virginia | Marion | 54049 | 19564 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-24 04:21:02 | Marion, West Virginia, US | |
692892 | 692892 | 2022-12-23 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-24 04:21:02 | Shelby, Ohio, US | |
691925 | 691925 | 2022-12-23 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-24 04:21:02 | Webster, Louisiana, US | |
691448 | 691448 | 2022-12-23 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-24 04:21:02 | Boone, Indiana, US | |
2183159 | 2183159 | 2022-12-22 | US | Wisconsin | Ozaukee | 55089 | 27148 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-23 04:21:04 | Ozaukee, Wisconsin, US | |
2183081 | 2183081 | 2022-12-22 | US | West Virginia | Marion | 54049 | 19564 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-23 04:21:04 | Marion, West Virginia, US | |
2182102 | 2182102 | 2022-12-22 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-23 04:21:04 | Shelby, Ohio, US | |
2181135 | 2181135 | 2022-12-22 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-23 04:21:04 | Webster, Louisiana, US | |
2180658 | 2180658 | 2022-12-22 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-23 04:21:04 | Boone, Indiana, US | |
454963 | 454963 | 2022-12-21 | US | Wisconsin | Ozaukee | 55089 | 27113 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-22 04:20:56 | Ozaukee, Wisconsin, US | |
454885 | 454885 | 2022-12-21 | US | West Virginia | Marion | 54049 | 19535 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-22 04:20:56 | Marion, West Virginia, US | |
453906 | 453906 | 2022-12-21 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-22 04:20:56 | Shelby, Ohio, US | |
452939 | 452939 | 2022-12-21 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-22 04:20:56 | Webster, Louisiana, US | |
452462 | 452462 | 2022-12-21 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-22 04:20:56 | Boone, Indiana, US | |
2954962 | 2954962 | 2022-12-20 | US | Wisconsin | Ozaukee | 55089 | 27097 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-21 04:21:03 | Ozaukee, Wisconsin, US | |
2954884 | 2954884 | 2022-12-20 | US | West Virginia | Marion | 54049 | 19507 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-21 04:21:03 | Marion, West Virginia, US | |
2954674 | 2954674 | 2022-12-20 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-21 04:21:03 | Chittenden, Vermont, US | |
2953905 | 2953905 | 2022-12-20 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-21 04:21:03 | Shelby, Ohio, US | |
2952461 | 2952461 | 2022-12-20 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-21 04:21:03 | Boone, Indiana, US | |
3177364 | 3177364 | 2022-12-19 | US | Wisconsin | Ozaukee | 55089 | 27085 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-20 04:21:04 | Ozaukee, Wisconsin, US | |
3177286 | 3177286 | 2022-12-19 | US | West Virginia | Marion | 54049 | 19486 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-20 04:21:04 | Marion, West Virginia, US | |
3177076 | 3177076 | 2022-12-19 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-20 04:21:04 | Chittenden, Vermont, US | |
3176307 | 3176307 | 2022-12-19 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-20 04:21:04 | Shelby, Ohio, US | |
3175436 | 3175436 | 2022-12-19 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-20 04:21:04 | Ionia, Michigan, US | |
3174863 | 3174863 | 2022-12-19 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-20 04:21:04 | Boone, Indiana, US | |
1631881 | 1631881 | 2022-12-18 | US | Wisconsin | Ozaukee | 55089 | 27044 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-19 04:21:03 | Ozaukee, Wisconsin, US | |
1631803 | 1631803 | 2022-12-18 | US | West Virginia | Marion | 54049 | 19436 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-19 04:21:03 | Marion, West Virginia, US | |
1631593 | 1631593 | 2022-12-18 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-19 04:21:03 | Chittenden, Vermont, US | |
1630824 | 1630824 | 2022-12-18 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-19 04:21:03 | Shelby, Ohio, US | |
1629953 | 1629953 | 2022-12-18 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-19 04:21:03 | Ionia, Michigan, US | |
1629380 | 1629380 | 2022-12-18 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-19 04:21:03 | Boone, Indiana, US | |
507260 | 507260 | 2022-12-17 | US | Wisconsin | Ozaukee | 55089 | 27044 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-18 04:21:03 | Ozaukee, Wisconsin, US | |
507182 | 507182 | 2022-12-17 | US | West Virginia | Marion | 54049 | 19436 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-18 04:21:03 | Marion, West Virginia, US | |
506972 | 506972 | 2022-12-17 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-18 04:21:03 | Chittenden, Vermont, US | |
506203 | 506203 | 2022-12-17 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-18 04:21:03 | Shelby, Ohio, US | |
505332 | 505332 | 2022-12-17 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-18 04:21:03 | Ionia, Michigan, US | |
504759 | 504759 | 2022-12-17 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-18 04:21:03 | Boone, Indiana, US | |
3327832 | 3327832 | 2022-12-16 | US | Wisconsin | Ozaukee | 55089 | 27044 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-17 04:21:04 | Ozaukee, Wisconsin, US | |
3327754 | 3327754 | 2022-12-16 | US | West Virginia | Marion | 54049 | 19436 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-17 04:21:04 | Marion, West Virginia, US | |
3327544 | 3327544 | 2022-12-16 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-17 04:21:04 | Chittenden, Vermont, US | |
3326775 | 3326775 | 2022-12-16 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-17 04:21:04 | Shelby, Ohio, US | |
3325904 | 3325904 | 2022-12-16 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-17 04:21:04 | Ionia, Michigan, US | |
3325331 | 3325331 | 2022-12-16 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-17 04:21:04 | Boone, Indiana, US | |
546344 | 546344 | 2022-12-15 | US | Wisconsin | Ozaukee | 55089 | 27016 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-16 04:21:01 | Ozaukee, Wisconsin, US | |
546266 | 546266 | 2022-12-15 | US | West Virginia | Marion | 54049 | 19418 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-16 04:21:01 | Marion, West Virginia, US | |
546056 | 546056 | 2022-12-15 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-16 04:21:01 | Chittenden, Vermont, US | |
545287 | 545287 | 2022-12-15 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-16 04:21:01 | Shelby, Ohio, US | |
544416 | 544416 | 2022-12-15 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-16 04:21:01 | Ionia, Michigan, US | |
543843 | 543843 | 2022-12-15 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-16 04:21:01 | Boone, Indiana, US | |
351872 | 351872 | 2022-12-14 | US | Wisconsin | Ozaukee | 55089 | 26989 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-15 04:20:58 | Ozaukee, Wisconsin, US | |
351794 | 351794 | 2022-12-14 | US | West Virginia | Marion | 54049 | 19400 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-15 04:20:58 | Marion, West Virginia, US | |
351584 | 351584 | 2022-12-14 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-15 04:20:58 | Chittenden, Vermont, US | |
350815 | 350815 | 2022-12-14 | US | Ohio | Shelby | 39149 | 12965 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-15 04:20:58 | Shelby, Ohio, US | |
349944 | 349944 | 2022-12-14 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-15 04:20:58 | Ionia, Michigan, US | |
349371 | 349371 | 2022-12-14 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-15 04:20:58 | Boone, Indiana, US | |
311460 | 311460 | 2022-12-13 | US | Wisconsin | Ozaukee | 55089 | 26969 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-14 04:21:04 | Ozaukee, Wisconsin, US | |
311382 | 311382 | 2022-12-13 | US | West Virginia | Marion | 54049 | 19371 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-14 04:21:04 | Marion, West Virginia, US | |
311172 | 311172 | 2022-12-13 | US | Vermont | Chittenden | 50007 | 38664 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-14 04:21:04 | Chittenden, Vermont, US | |
311008 | 311008 | 2022-12-13 | US | Texas | Hill | 48217 | 9867 | 199 | 0 | 31.99045053 | -97.13423143 | 2022-12-14 04:21:04 | Hill, Texas, US | |
310403 | 310403 | 2022-12-13 | US | Ohio | Shelby | 39149 | 12965 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-14 04:21:04 | Shelby, Ohio, US | |
310257 | 310257 | 2022-12-13 | US | North Carolina | Stokes | 37169 | 14332 | 199 | 0 | 36.4017975 | -80.23893369 | 2022-12-14 04:21:04 | Stokes, North Carolina, US | |
309532 | 309532 | 2022-12-13 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-14 04:21:04 | Ionia, Michigan, US | |
308959 | 308959 | 2022-12-13 | US | Indiana | Boone | 18011 | 17102 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-14 04:21:04 | Boone, Indiana, US | |
1152521 | 1152521 | 2022-12-12 | US | Wisconsin | Ozaukee | 55089 | 26948 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-13 04:21:01 | Ozaukee, Wisconsin, US | |
1152443 | 1152443 | 2022-12-12 | US | West Virginia | Marion | 54049 | 19351 | 199 | 0 | 39.50984542 | -80.24244659 | 2022-12-13 04:21:01 | Marion, West Virginia, US | |
1152233 | 1152233 | 2022-12-12 | US | Vermont | Chittenden | 50007 | 38664 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-13 04:21:01 | Chittenden, Vermont, 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]);