daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,040 rows where deaths = 250 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 | Texas | Hale | 48189 | 8198 | 250 | 0 | 34.07044901 | -101.8268114 | 2022-12-30 04:21:04 | Hale, Texas, US | |
2022-12-29 | US | Oregon | Yamhill | 41071 | 22223 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-30 04:21:04 | Yamhill, Oregon, US | |
2022-12-29 | US | Mississippi | Lowndes | 28087 | 20628 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-30 04:21:04 | Lowndes, Mississippi, US | |
2022-12-28 | US | Texas | Hale | 48189 | 8198 | 250 | 0 | 34.07044901 | -101.8268114 | 2022-12-29 04:21:01 | Hale, Texas, US | |
2022-12-28 | US | Oregon | Yamhill | 41071 | 22223 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-29 04:21:01 | Yamhill, Oregon, US | |
2022-12-28 | US | Mississippi | Lowndes | 28087 | 20628 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-29 04:21:01 | Lowndes, Mississippi, US | |
2022-12-27 | US | Washington | Skagit | 53057 | 27866 | 250 | 0 | 48.48171488 | -121.766131 | 2022-12-28 04:21:04 | Skagit, Washington, US | |
2022-12-27 | US | Oregon | Yamhill | 41071 | 22154 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-28 04:21:04 | Yamhill, Oregon, US | |
2022-12-27 | US | Mississippi | Lowndes | 28087 | 20628 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-28 04:21:04 | Lowndes, Mississippi, US | |
2022-12-26 | US | Washington | Skagit | 53057 | 27866 | 250 | 0 | 48.48171488 | -121.766131 | 2022-12-27 04:21:07 | Skagit, Washington, US | |
2022-12-26 | US | Oregon | Yamhill | 41071 | 22154 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-27 04:21:07 | Yamhill, Oregon, US | |
2022-12-26 | US | Mississippi | Lowndes | 28087 | 20551 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-27 04:21:07 | Lowndes, Mississippi, US | |
2022-12-26 | US | Michigan | Midland | 26111 | 22990 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-27 04:21:07 | Midland, Michigan, US | |
2022-12-25 | US | Washington | Skagit | 53057 | 27866 | 250 | 0 | 48.48171488 | -121.766131 | 2022-12-26 04:21:06 | Skagit, Washington, US | |
2022-12-25 | US | Oregon | Yamhill | 41071 | 22154 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-26 04:21:06 | Yamhill, Oregon, US | |
2022-12-25 | US | Mississippi | Lowndes | 28087 | 20551 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-26 04:21:06 | Lowndes, Mississippi, US | |
2022-12-25 | US | Michigan | Midland | 26111 | 22990 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-26 04:21:06 | Midland, Michigan, US | |
2022-12-24 | US | Washington | Skagit | 53057 | 27866 | 250 | 0 | 48.48171488 | -121.766131 | 2022-12-25 04:21:04 | Skagit, Washington, US | |
2022-12-24 | US | Oregon | Yamhill | 41071 | 22154 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-25 04:21:04 | Yamhill, Oregon, US | |
2022-12-24 | US | Mississippi | Lowndes | 28087 | 20551 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-25 04:21:04 | Lowndes, Mississippi, US | |
2022-12-24 | US | Michigan | Midland | 26111 | 22990 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-25 04:21:04 | Midland, Michigan, US | |
2022-12-23 | US | Washington | Skagit | 53057 | 27866 | 250 | 0 | 48.48171488 | -121.766131 | 2022-12-24 04:21:02 | Skagit, Washington, US | |
2022-12-23 | US | Oregon | Yamhill | 41071 | 22154 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-24 04:21:02 | Yamhill, Oregon, US | |
2022-12-23 | US | Mississippi | Lowndes | 28087 | 20551 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-24 04:21:02 | Lowndes, Mississippi, US | |
2022-12-23 | US | Michigan | Midland | 26111 | 22990 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-24 04:21:02 | Midland, Michigan, US | |
2022-12-22 | US | Washington | Skagit | 53057 | 27866 | 250 | 0 | 48.48171488 | -121.766131 | 2022-12-23 04:21:04 | Skagit, Washington, US | |
2022-12-22 | US | Oregon | Yamhill | 41071 | 22154 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-23 04:21:04 | Yamhill, Oregon, US | |
2022-12-22 | US | Mississippi | Lowndes | 28087 | 20551 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-23 04:21:04 | Lowndes, Mississippi, US | |
2022-12-22 | US | Michigan | Midland | 26111 | 22990 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-23 04:21:04 | Midland, Michigan, US | |
2022-12-21 | US | Washington | Skagit | 53057 | 27866 | 250 | 0 | 48.48171488 | -121.766131 | 2022-12-22 04:20:56 | Skagit, Washington, US | |
2022-12-21 | US | Oregon | Yamhill | 41071 | 22154 | 250 | 0 | 45.23330449 | -123.3086963 | 2022-12-22 04:20:56 | Yamhill, Oregon, US | |
2022-12-21 | US | Mississippi | Lowndes | 28087 | 20551 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-22 04:20:56 | Lowndes, Mississippi, US | |
2022-12-21 | US | Michigan | Midland | 26111 | 22990 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-22 04:20:56 | Midland, Michigan, US | |
2022-12-20 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-21 04:21:03 | Lowndes, Mississippi, US | |
2022-12-20 | US | Michigan | Midland | 26111 | 22990 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-21 04:21:03 | Midland, Michigan, US | |
2022-12-19 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-20 04:21:04 | Lowndes, Mississippi, US | |
2022-12-19 | US | Michigan | Midland | 26111 | 22920 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-20 04:21:04 | Midland, Michigan, US | |
2022-12-18 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-19 04:21:03 | Lowndes, Mississippi, US | |
2022-12-18 | US | Michigan | Midland | 26111 | 22920 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-19 04:21:03 | Midland, Michigan, US | |
2022-12-17 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-18 04:21:03 | Lowndes, Mississippi, US | |
2022-12-17 | US | Michigan | Midland | 26111 | 22920 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-18 04:21:03 | Midland, Michigan, US | |
2022-12-16 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-17 04:21:04 | Lowndes, Mississippi, US | |
2022-12-16 | US | Michigan | Midland | 26111 | 22920 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-17 04:21:04 | Midland, Michigan, US | |
2022-12-15 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-16 04:21:01 | Lowndes, Mississippi, US | |
2022-12-15 | US | Michigan | Midland | 26111 | 22920 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-16 04:21:01 | Midland, Michigan, US | |
2022-12-14 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-15 04:20:58 | Lowndes, Mississippi, US | |
2022-12-14 | US | Michigan | Midland | 26111 | 22920 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-15 04:20:58 | Midland, Michigan, US | |
2022-12-13 | US | Mississippi | Lowndes | 28087 | 20464 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-14 04:21:04 | Lowndes, Mississippi, US | |
2022-12-13 | US | Michigan | Midland | 26111 | 22920 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-14 04:21:04 | Midland, Michigan, US | |
2022-12-12 | US | Mississippi | Lowndes | 28087 | 20397 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-13 04:21:01 | Lowndes, Mississippi, US | |
2022-12-12 | US | Michigan | Midland | 26111 | 22868 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-13 04:21:01 | Midland, Michigan, US | |
2022-12-11 | US | Mississippi | Lowndes | 28087 | 20397 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-12 04:21:01 | Lowndes, Mississippi, US | |
2022-12-11 | US | Michigan | Midland | 26111 | 22868 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-12 04:21:01 | Midland, Michigan, US | |
2022-12-10 | US | Mississippi | Lowndes | 28087 | 20397 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-11 04:20:50 | Lowndes, Mississippi, US | |
2022-12-10 | US | Michigan | Midland | 26111 | 22868 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-11 04:20:50 | Midland, Michigan, US | |
2022-12-09 | US | Mississippi | Lowndes | 28087 | 20397 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-10 04:21:02 | Lowndes, Mississippi, US | |
2022-12-09 | US | Michigan | Midland | 26111 | 22868 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-10 04:21:02 | Midland, Michigan, US | |
2022-12-08 | US | Mississippi | Lowndes | 28087 | 20397 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-09 04:21:05 | Lowndes, Mississippi, US | |
2022-12-08 | US | Michigan | Midland | 26111 | 22868 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-09 04:21:05 | Midland, Michigan, US | |
2022-12-07 | US | Virginia | Shenandoah | 51171 | 13216 | 250 | 0 | 38.85905135 | -78.56813762 | 2022-12-08 04:21:07 | Shenandoah, Virginia, US | |
2022-12-07 | US | Mississippi | Lowndes | 28087 | 20397 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-08 04:21:07 | Lowndes, Mississippi, US | |
2022-12-07 | US | Michigan | Midland | 26111 | 22868 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-08 04:21:07 | Midland, Michigan, US | |
2022-12-06 | US | Mississippi | Lowndes | 28087 | 20397 | 250 | 0 | 33.47386518 | -88.4419153 | 2022-12-07 04:20:58 | Lowndes, Mississippi, US | |
2022-12-06 | US | Michigan | Midland | 26111 | 22868 | 250 | 0 | 43.64330771 | -84.38804374 | 2022-12-07 04:20:58 | Midland, Michigan, US | |
2022-12-06 | US | Alabama | Tallapoosa | 1123 | 13747 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-12-07 04:20:58 | Tallapoosa, Alabama, US | |
2022-12-05 | US | Alabama | Tallapoosa | 1123 | 13747 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-12-06 04:21:03 | Tallapoosa, Alabama, US | |
2022-12-04 | US | Alabama | Tallapoosa | 1123 | 13747 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-12-05 04:20:58 | Tallapoosa, Alabama, US | |
2022-12-03 | US | Alabama | Tallapoosa | 1123 | 13747 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-12-04 04:20:56 | Tallapoosa, Alabama, US | |
2022-12-02 | US | Alabama | Tallapoosa | 1123 | 13747 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-12-03 04:21:02 | Tallapoosa, Alabama, US | |
2022-12-01 | US | Alabama | Tallapoosa | 1123 | 13747 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-12-02 04:21:07 | Tallapoosa, Alabama, US | |
2022-11-30 | US | Oklahoma | Carter | 40019 | 17589 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-12-01 04:21:03 | Carter, Oklahoma, US | |
2022-11-30 | US | Alabama | Tallapoosa | 1123 | 13747 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-12-01 04:21:03 | Tallapoosa, Alabama, US | |
2022-11-29 | US | Oklahoma | Carter | 40019 | 17589 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-30 04:21:07 | Carter, Oklahoma, US | |
2022-11-29 | US | Alabama | Tallapoosa | 1123 | 13720 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-11-30 04:21:07 | Tallapoosa, Alabama, US | |
2022-11-28 | US | Oklahoma | Carter | 40019 | 17589 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-29 04:21:05 | Carter, Oklahoma, US | |
2022-11-28 | US | Alabama | Tallapoosa | 1123 | 13720 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-11-29 04:21:05 | Tallapoosa, Alabama, US | |
2022-11-27 | US | Oklahoma | Carter | 40019 | 17589 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-28 04:21:02 | Carter, Oklahoma, US | |
2022-11-27 | US | Kentucky | Bullitt | 21029 | 27254 | 250 | 0 | 37.97162523 | -85.68955617 | 2022-11-28 04:21:02 | Bullitt, Kentucky, US | |
2022-11-27 | US | Alabama | Tallapoosa | 1123 | 13720 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-11-28 04:21:02 | Tallapoosa, Alabama, US | |
2022-11-26 | US | Oklahoma | Carter | 40019 | 17589 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-27 04:21:05 | Carter, Oklahoma, US | |
2022-11-26 | US | Kentucky | Bullitt | 21029 | 27254 | 250 | 0 | 37.97162523 | -85.68955617 | 2022-11-27 04:21:05 | Bullitt, Kentucky, US | |
2022-11-26 | US | Alabama | Tallapoosa | 1123 | 13720 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-11-27 04:21:05 | Tallapoosa, Alabama, US | |
2022-11-25 | US | Oklahoma | Carter | 40019 | 17589 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-26 04:21:11 | Carter, Oklahoma, US | |
2022-11-25 | US | Kentucky | Bullitt | 21029 | 27254 | 250 | 0 | 37.97162523 | -85.68955617 | 2022-11-26 04:21:11 | Bullitt, Kentucky, US | |
2022-11-25 | US | Alabama | Tallapoosa | 1123 | 13720 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-11-26 04:21:11 | Tallapoosa, Alabama, US | |
2022-11-24 | US | Oklahoma | Carter | 40019 | 17589 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-25 04:21:06 | Carter, Oklahoma, US | |
2022-11-24 | US | Kentucky | Bullitt | 21029 | 27254 | 250 | 0 | 37.97162523 | -85.68955617 | 2022-11-25 04:21:06 | Bullitt, Kentucky, US | |
2022-11-24 | US | Alabama | Tallapoosa | 1123 | 13720 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-11-25 04:21:06 | Tallapoosa, Alabama, US | |
2022-11-23 | US | Oklahoma | Carter | 40019 | 17554 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-24 04:21:09 | Carter, Oklahoma, US | |
2022-11-23 | US | Kentucky | Bullitt | 21029 | 27254 | 250 | 0 | 37.97162523 | -85.68955617 | 2022-11-24 04:21:09 | Bullitt, Kentucky, US | |
2022-11-23 | US | Alabama | Tallapoosa | 1123 | 13720 | 250 | 0 | 32.86698258 | -85.79833053 | 2022-11-24 04:21:09 | Tallapoosa, Alabama, US | |
2022-11-22 | US | Oklahoma | Carter | 40019 | 17554 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-23 04:21:06 | Carter, Oklahoma, US | |
2022-11-22 | US | Kentucky | Bullitt | 21029 | 27254 | 250 | 0 | 37.97162523 | -85.68955617 | 2022-11-23 04:21:06 | Bullitt, Kentucky, US | |
2022-11-22 | US | Georgia | Clarke | 13059 | 33943 | 250 | 0 | 33.95436462 | -83.37124007 | 2022-11-23 04:21:06 | Clarke, Georgia, US | |
2022-11-21 | US | Oklahoma | Carter | 40019 | 17554 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-22 04:20:47 | Carter, Oklahoma, US | |
2022-11-21 | US | Kentucky | Bullitt | 21029 | 27254 | 250 | 0 | 37.97162523 | -85.68955617 | 2022-11-22 04:20:47 | Bullitt, Kentucky, US | |
2022-11-21 | US | Georgia | Clarke | 13059 | 33943 | 250 | 0 | 33.95436462 | -83.37124007 | 2022-11-22 04:20:47 | Clarke, Georgia, US | |
2022-11-20 | US | Oklahoma | Carter | 40019 | 17554 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-21 04:21:05 | Carter, Oklahoma, US | |
2022-11-20 | US | Georgia | Clarke | 13059 | 33943 | 250 | 0 | 33.95436462 | -83.37124007 | 2022-11-21 04:21:05 | Clarke, Georgia, US | |
2022-11-19 | US | Oklahoma | Carter | 40019 | 17554 | 250 | 0 | 34.25103751 | -97.28552485 | 2022-11-20 04:21:08 | Carter, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;