daily_reports (view)
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
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Wisconsin | Ozaukee | 55089 | 27248 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-30 04:21:04 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-29 | US | Virginia | Albemarle | 51003 | 24259 | 199 | 0 | 38.02080697 | -78.55481085 | 2022-12-30 04:21:04 | Albemarle, Virginia, US | |
2022-12-29 | US | Ohio | Shelby | 39149 | 13082 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-30 04:21:04 | Shelby, Ohio, US | |
2022-12-29 | US | Louisiana | Webster | 22119 | 14117 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-30 04:21:04 | Webster, Louisiana, US | |
2022-12-29 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-30 04:21:04 | Boone, Indiana, US | |
2022-12-28 | US | Wisconsin | Ozaukee | 55089 | 27228 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-29 04:21:01 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-28 | US | Virginia | Albemarle | 51003 | 24259 | 199 | 0 | 38.02080697 | -78.55481085 | 2022-12-29 04:21:01 | Albemarle, Virginia, US | |
2022-12-28 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-29 04:21:01 | Shelby, Ohio, US | |
2022-12-28 | US | Louisiana | Webster | 22119 | 14117 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-29 04:21:01 | Webster, Louisiana, US | |
2022-12-28 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-29 04:21:01 | Boone, Indiana, US | |
2022-12-27 | US | Wisconsin | Ozaukee | 55089 | 27206 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-28 04:21:04 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-27 | US | Virginia | Albemarle | 51003 | 24231 | 199 | 0 | 38.02080697 | -78.55481085 | 2022-12-28 04:21:04 | Albemarle, Virginia, US | |
2022-12-27 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-28 04:21:04 | Shelby, Ohio, US | |
2022-12-27 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-28 04:21:04 | Webster, Louisiana, US | |
2022-12-27 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-28 04:21:04 | Boone, Indiana, US | |
2022-12-26 | US | Wisconsin | Ozaukee | 55089 | 27201 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-27 04:21:07 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-26 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-27 04:21:07 | Shelby, Ohio, US | |
2022-12-26 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-27 04:21:07 | Webster, Louisiana, US | |
2022-12-26 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-27 04:21:07 | Boone, Indiana, US | |
2022-12-25 | US | Wisconsin | Ozaukee | 55089 | 27169 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-26 04:21:06 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-25 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-26 04:21:06 | Shelby, Ohio, US | |
2022-12-25 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-26 04:21:06 | Webster, Louisiana, US | |
2022-12-25 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-26 04:21:06 | Boone, Indiana, US | |
2022-12-24 | US | Wisconsin | Ozaukee | 55089 | 27169 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-25 04:21:04 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-24 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-25 04:21:04 | Shelby, Ohio, US | |
2022-12-24 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-25 04:21:04 | Webster, Louisiana, US | |
2022-12-24 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-25 04:21:04 | Boone, Indiana, US | |
2022-12-23 | US | Wisconsin | Ozaukee | 55089 | 27169 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-24 04:21:02 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-23 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-24 04:21:02 | Shelby, Ohio, US | |
2022-12-23 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-24 04:21:02 | Webster, Louisiana, US | |
2022-12-23 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-24 04:21:02 | Boone, Indiana, US | |
2022-12-22 | US | Wisconsin | Ozaukee | 55089 | 27148 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-23 04:21:04 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-22 | US | Ohio | Shelby | 39149 | 13050 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-23 04:21:04 | Shelby, Ohio, US | |
2022-12-22 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-23 04:21:04 | Webster, Louisiana, US | |
2022-12-22 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-23 04:21:04 | Boone, Indiana, US | |
2022-12-21 | US | Wisconsin | Ozaukee | 55089 | 27113 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-22 04:20:56 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-21 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-22 04:20:56 | Shelby, Ohio, US | |
2022-12-21 | US | Louisiana | Webster | 22119 | 14091 | 199 | 0 | 32.70847669 | -93.33121835 | 2022-12-22 04:20:56 | Webster, Louisiana, US | |
2022-12-21 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-22 04:20:56 | Boone, Indiana, US | |
2022-12-20 | US | Wisconsin | Ozaukee | 55089 | 27097 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-21 04:21:03 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-20 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-21 04:21:03 | Chittenden, Vermont, US | |
2022-12-20 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-21 04:21:03 | Shelby, Ohio, US | |
2022-12-20 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-21 04:21:03 | Boone, Indiana, US | |
2022-12-19 | US | Wisconsin | Ozaukee | 55089 | 27085 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-20 04:21:04 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-19 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-20 04:21:04 | Chittenden, Vermont, US | |
2022-12-19 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-20 04:21:04 | Shelby, Ohio, US | |
2022-12-19 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-20 04:21:04 | Ionia, Michigan, US | |
2022-12-19 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-20 04:21:04 | Boone, Indiana, US | |
2022-12-18 | US | Wisconsin | Ozaukee | 55089 | 27044 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-19 04:21:03 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-18 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-19 04:21:03 | Chittenden, Vermont, US | |
2022-12-18 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-19 04:21:03 | Shelby, Ohio, US | |
2022-12-18 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-19 04:21:03 | Ionia, Michigan, US | |
2022-12-18 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-19 04:21:03 | Boone, Indiana, US | |
2022-12-17 | US | Wisconsin | Ozaukee | 55089 | 27044 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-18 04:21:03 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-17 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-18 04:21:03 | Chittenden, Vermont, US | |
2022-12-17 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-18 04:21:03 | Shelby, Ohio, US | |
2022-12-17 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-18 04:21:03 | Ionia, Michigan, US | |
2022-12-17 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-18 04:21:03 | Boone, Indiana, US | |
2022-12-16 | US | Wisconsin | Ozaukee | 55089 | 27044 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-17 04:21:04 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-16 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-17 04:21:04 | Chittenden, Vermont, US | |
2022-12-16 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-17 04:21:04 | Shelby, Ohio, US | |
2022-12-16 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-17 04:21:04 | Ionia, Michigan, US | |
2022-12-16 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-17 04:21:04 | Boone, Indiana, US | |
2022-12-15 | US | Wisconsin | Ozaukee | 55089 | 27016 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-16 04:21:01 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-15 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-16 04:21:01 | Chittenden, Vermont, US | |
2022-12-15 | US | Ohio | Shelby | 39149 | 13003 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-16 04:21:01 | Shelby, Ohio, US | |
2022-12-15 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-16 04:21:01 | Ionia, Michigan, US | |
2022-12-15 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-16 04:21:01 | Boone, Indiana, US | |
2022-12-14 | US | Wisconsin | Ozaukee | 55089 | 26989 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-15 04:20:58 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-14 | US | Vermont | Chittenden | 50007 | 38735 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-15 04:20:58 | Chittenden, Vermont, US | |
2022-12-14 | US | Ohio | Shelby | 39149 | 12965 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-15 04:20:58 | Shelby, Ohio, US | |
2022-12-14 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-15 04:20:58 | Ionia, Michigan, US | |
2022-12-14 | US | Indiana | Boone | 18011 | 17135 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-15 04:20:58 | Boone, Indiana, US | |
2022-12-13 | US | Wisconsin | Ozaukee | 55089 | 26969 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-14 04:21:04 | Ozaukee, Wisconsin, US | |
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 | |
2022-12-13 | US | Vermont | Chittenden | 50007 | 38664 | 199 | 0 | 44.46322849 | -73.08359212 | 2022-12-14 04:21:04 | Chittenden, Vermont, US | |
2022-12-13 | US | Texas | Hill | 48217 | 9867 | 199 | 0 | 31.99045053 | -97.13423143 | 2022-12-14 04:21:04 | Hill, Texas, US | |
2022-12-13 | US | Ohio | Shelby | 39149 | 12965 | 199 | 0 | 40.33163494 | -84.20258189 | 2022-12-14 04:21:04 | Shelby, Ohio, US | |
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 | |
2022-12-13 | US | Michigan | Ionia | 26067 | 19333 | 199 | 0 | 42.94502238 | -85.07413319 | 2022-12-14 04:21:04 | Ionia, Michigan, US | |
2022-12-13 | US | Indiana | Boone | 18011 | 17102 | 199 | 0 | 40.0509304 | -86.46841646 | 2022-12-14 04:21:04 | Boone, Indiana, US | |
2022-12-12 | US | Wisconsin | Ozaukee | 55089 | 26948 | 199 | 0 | 43.38352225 | -87.94625009 | 2022-12-13 04:21:01 | Ozaukee, Wisconsin, US | |
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 | |
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;