daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
250 rows where confirmed = 3253 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Iowa | Cass | 19029 | 3253 | 86 | 0 | 41.33149454 | -94.92792482 | 2022-12-30 04:21:04 | Cass, Iowa, US | |
2022-12-28 | US | Iowa | Cass | 19029 | 3253 | 86 | 0 | 41.33149454 | -94.92792482 | 2022-12-29 04:21:01 | Cass, Iowa, US | |
2022-11-17 | US | Virginia | Clarke | 51043 | 3253 | 55 | 0 | 39.11271747 | -77.99199425 | 2022-11-18 04:21:15 | Clarke, Virginia, US | |
2022-11-06 | US | Kentucky | Elliott | 21063 | 3253 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-11-07 04:21:26 | Elliott, Kentucky, US | |
2022-11-05 | US | Kentucky | Elliott | 21063 | 3253 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-11-06 04:21:24 | Elliott, Kentucky, US | |
2022-11-04 | US | Kentucky | Elliott | 21063 | 3253 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-11-05 04:21:52 | Elliott, Kentucky, US | |
2022-11-03 | US | Kentucky | Elliott | 21063 | 3253 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-11-04 04:22:11 | Elliott, Kentucky, US | |
2022-11-02 | US | Kentucky | Elliott | 21063 | 3253 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-11-03 04:22:05 | Elliott, Kentucky, US | |
2022-11-01 | US | Kentucky | Elliott | 21063 | 3253 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-11-02 04:22:09 | Elliott, Kentucky, US | |
2022-10-31 | US | Kentucky | Elliott | 21063 | 3253 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-11-01 04:22:36 | Elliott, Kentucky, US | |
2022-10-21 | US | Arkansas | Lee | 5077 | 3253 | 66 | 0 | 34.78498904 | -90.78383866 | 2022-10-22 04:22:53 | Lee, Arkansas, US | |
2022-09-06 | US | Georgia | Long | 13183 | 3253 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-09-07 04:20:59 | Long, Georgia, US | |
2022-09-05 | US | Georgia | Long | 13183 | 3253 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-09-06 04:21:02 | Long, Georgia, US | |
2022-09-04 | US | Georgia | Long | 13183 | 3253 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-09-05 04:21:01 | Long, Georgia, US | |
2022-09-03 | US | Georgia | Long | 13183 | 3253 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-09-04 04:21:22 | Long, Georgia, US | |
2022-09-02 | US | Georgia | Long | 13183 | 3253 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-09-03 04:21:04 | Long, Georgia, US | |
2022-09-01 | US | Georgia | Long | 13183 | 3253 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-09-02 04:21:07 | Long, Georgia, US | |
2022-08-31 | US | Texas | Callahan | 48059 | 3253 | 75 | 0 | 32.29760619 | -99.37326312 | 2022-09-01 04:21:03 | Callahan, Texas, US | |
2022-08-31 | US | Georgia | Long | 13183 | 3253 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-09-01 04:21:03 | Long, Georgia, US | |
2022-08-25 | US | North Dakota | Barnes | 38003 | 3253 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-08-26 04:21:02 | Barnes, North Dakota, US | |
2022-08-24 | China | Henan | 3253 | 22 | 0 | 33.882 | 113.614 | 2022-08-25 04:21:13 | Henan, China | |||
2022-08-23 | US | Idaho | Idaho | 16049 | 3253 | 54 | 0 | 45.84721541 | -115.4634436 | 2022-08-24 04:20:46 | Idaho, Idaho, US | |
2022-08-22 | US | Idaho | Idaho | 16049 | 3253 | 54 | 0 | 45.84721541 | -115.4634436 | 2022-08-23 04:20:56 | Idaho, Idaho, US | |
2022-08-15 | US | West Virginia | Summers | 54089 | 3253 | 56 | 0 | 37.65390597 | -80.86009693 | 2022-08-16 04:20:58 | Summers, West Virginia, US | |
2022-08-10 | US | Colorado | Rio Grande | 8105 | 3253 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-08-11 04:20:49 | Rio Grande, Colorado, US | |
2022-08-10 | China | Zhejiang | 3253 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-11 04:20:49 | Zhejiang, China | |||
2022-07-31 | US | Colorado | Park | 8093 | 3253 | 22 | 0 | 39.120926 | -105.7182065 | 2022-08-01 04:21:03 | Park, Colorado, US | |
2022-06-27 | US | Minnesota | Chippewa | 27023 | 3253 | 48 | 0 | 45.02343421 | -95.56403693 | 2022-06-28 04:20:58 | Chippewa, Minnesota, US | |
2022-06-22 | US | California | Mono | 6051 | 3253 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-06-23 04:20:55 | Mono, California, US | |
2022-06-10 | US | Tennessee | Jackson | 47087 | 3253 | 63 | 0 | 36.36380466 | -85.67239905 | 2022-06-11 04:21:01 | Jackson, Tennessee, US | |
2022-06-09 | US | Missouri | Osage | 29151 | 3253 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-06-10 04:20:55 | Osage, Missouri, US | |
2022-06-08 | US | Ohio | Noble | 39121 | 3253 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-06-09 04:20:54 | Noble, Ohio, US | |
2022-06-08 | US | Missouri | Osage | 29151 | 3253 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-06-09 04:20:54 | Osage, Missouri, US | |
2022-06-07 | US | Ohio | Noble | 39121 | 3253 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-06-08 04:20:55 | Noble, Ohio, US | |
2022-06-07 | US | Missouri | Osage | 29151 | 3253 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-06-08 04:20:55 | Osage, Missouri, US | |
2022-06-06 | US | Ohio | Noble | 39121 | 3253 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-06-07 04:21:08 | Noble, Ohio, US | |
2022-06-06 | US | Missouri | Osage | 29151 | 3253 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-06-07 04:21:08 | Osage, Missouri, US | |
2022-06-05 | US | Ohio | Noble | 39121 | 3253 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-06-06 04:20:57 | Noble, Ohio, US | |
2022-06-05 | US | Missouri | Osage | 29151 | 3253 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-06-06 04:20:57 | Osage, Missouri, US | |
2022-06-04 | US | Ohio | Noble | 39121 | 3253 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-06-05 04:20:55 | Noble, Ohio, US | |
2022-06-04 | US | Missouri | Osage | 29151 | 3253 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-06-05 04:20:55 | Osage, Missouri, US | |
2022-06-03 | US | Ohio | Noble | 39121 | 3253 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-06-04 04:20:58 | Noble, Ohio, US | |
2022-06-03 | US | Missouri | Osage | 29151 | 3253 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-06-04 04:20:58 | Osage, Missouri, US | |
2022-06-02 | US | Ohio | Noble | 39121 | 3253 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-06-03 04:20:58 | Noble, Ohio, US | |
2022-06-02 | US | Maryland | Kent | 24029 | 3253 | 66 | 0 | 39.24976208 | -76.04741541 | 2022-06-03 04:20:58 | Kent, Maryland, US | |
2022-06-01 | US | Puerto Rico | Guayanilla | 72059 | 3253 | 0 | 0 | 18.039942 | -66.79186 | 2022-06-02 05:20:39 | Guayanilla, Puerto Rico, US | |
2022-05-15 | US | Minnesota | Cottonwood | 27033 | 3253 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-05-16 04:20:47 | Cottonwood, Minnesota, US | |
2022-05-14 | US | Minnesota | Cottonwood | 27033 | 3253 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-05-15 04:20:53 | Cottonwood, Minnesota, US | |
2022-05-13 | US | Minnesota | Cottonwood | 27033 | 3253 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-05-14 04:20:48 | Cottonwood, Minnesota, US | |
2022-05-12 | US | Minnesota | Cottonwood | 27033 | 3253 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-05-13 04:20:51 | Cottonwood, Minnesota, US | |
2022-05-01 | US | Virginia | Brunswick | 51025 | 3253 | 47 | 0 | 36.76366949 | -77.8593436 | 2022-05-02 04:21:10 | Brunswick, Virginia, US | |
2022-04-30 | US | Virginia | Brunswick | 51025 | 3253 | 47 | 0 | 36.76366949 | -77.8593436 | 2022-05-01 04:20:57 | Brunswick, Virginia, US | |
2022-04-29 | US | Virginia | Brunswick | 51025 | 3253 | 47 | 0 | 36.76366949 | -77.8593436 | 2022-04-30 04:21:05 | Brunswick, Virginia, US | |
2022-04-27 | US | North Dakota | McKenzie | 38053 | 3253 | 25 | 0 | 47.7413337 | -103.395905 | 2022-04-28 04:20:47 | McKenzie, North Dakota, US | |
2022-04-26 | US | North Dakota | McKenzie | 38053 | 3253 | 25 | 0 | 47.74133370000001 | -103.395905 | 2022-04-27 04:20:52 | McKenzie, North Dakota, US | |
2022-04-25 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-26 04:20:51 | Amite, Mississippi, US | |
2022-04-24 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-25 04:20:56 | Amite, Mississippi, US | |
2022-04-23 | US | Puerto Rico | Loiza | 72087 | 3253 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-04-24 04:20:56 | Loiza, Puerto Rico, US | |
2022-04-23 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-24 04:20:56 | Amite, Mississippi, US | |
2022-04-22 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-23 04:20:50 | Amite, Mississippi, US | |
2022-04-21 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-22 04:20:45 | Amite, Mississippi, US | |
2022-04-20 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-21 04:20:46 | Amite, Mississippi, US | |
2022-04-19 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-20 04:20:45 | Amite, Mississippi, US | |
2022-04-18 | US | Mississippi | Amite | 28005 | 3253 | 69 | 0 | 31.17467303 | -90.80501621 | 2022-04-19 04:21:00 | Amite, Mississippi, US | |
2022-04-13 | US | Texas | Jackson | 48239 | 3253 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-04-13 23:21:06 | Jackson, Texas, US | |
2022-04-12 | US | Texas | Jackson | 48239 | 3253 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-04-13 04:21:03 | Jackson, Texas, US | |
2022-04-12 | US | Michigan | Gogebic | 26053 | 3253 | 69 | 0 | 46.40862701 | -89.69377193 | 2022-04-13 04:21:03 | Gogebic, Michigan, US | |
2022-04-11 | US | Virginia | Westmoreland | 51193 | 3253 | 50 | 0 | 38.11021557 | -76.80213247 | 2022-04-12 04:20:49 | Westmoreland, Virginia, US | |
2022-04-11 | US | Texas | Jackson | 48239 | 3253 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-04-12 04:20:49 | Jackson, Texas, US | |
2022-04-11 | US | Michigan | Gogebic | 26053 | 3253 | 69 | 0 | 46.40862701 | -89.69377193 | 2022-04-12 04:20:49 | Gogebic, Michigan, US | |
2022-04-10 | US | Texas | Jackson | 48239 | 3253 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-04-11 04:21:02 | Jackson, Texas, US | |
2022-04-10 | US | Michigan | Gogebic | 26053 | 3253 | 69 | 0 | 46.40862701 | -89.69377193 | 2022-04-11 04:21:02 | Gogebic, Michigan, US | |
2022-04-09 | US | Texas | Jackson | 48239 | 3253 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-04-10 04:20:52 | Jackson, Texas, US | |
2022-04-09 | US | Michigan | Gogebic | 26053 | 3253 | 69 | 0 | 46.40862701 | -89.69377193 | 2022-04-10 04:20:52 | Gogebic, Michigan, US | |
2022-04-08 | US | Texas | Jackson | 48239 | 3253 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-04-09 04:20:42 | Jackson, Texas, US | |
2022-04-08 | US | Michigan | Gogebic | 26053 | 3253 | 69 | 0 | 46.40862701 | -89.69377193 | 2022-04-09 04:20:42 | Gogebic, Michigan, US | |
2022-04-07 | US | Michigan | Gogebic | 26053 | 3253 | 69 | 0 | 46.40862701 | -89.69377193 | 2022-04-08 04:20:48 | Gogebic, Michigan, US | |
2022-04-06 | US | Michigan | Gogebic | 26053 | 3253 | 69 | 0 | 46.40862701 | -89.69377193 | 2022-04-07 04:20:53 | Gogebic, Michigan, US | |
2022-03-24 | US | Virginia | Rockbridge | 51163 | 3253 | 75 | 0 | 37.81204314 | -79.44605905 | 2022-03-25 04:20:46 | Rockbridge, Virginia, US | |
2022-03-22 | US | Texas | Comanche | 48093 | 3253 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-03-23 04:20:48 | Comanche, Texas, US | |
2022-03-21 | US | Wisconsin | Bayfield | 55007 | 3253 | 39 | 0 | 46.52868768 | -91.19716729 | 2022-03-22 04:20:54 | Bayfield, Wisconsin, US | |
2022-03-14 | US | Montana | Roosevelt | 30085 | 3253 | 72 | 0 | 48.29607488 | -105.00792679999999 | 2022-03-15 04:20:47 | Roosevelt, Montana, US | |
2022-03-13 | US | Louisiana | Caldwell | 22021 | 3253 | 52 | 0 | 32.0902519 | -92.11752148 | 2022-03-14 04:20:46 | Caldwell, Louisiana, US | |
2022-03-12 | US | Louisiana | Caldwell | 22021 | 3253 | 52 | 0 | 32.0902519 | -92.11752148 | 2022-03-13 04:20:49 | Caldwell, Louisiana, US | |
2022-03-11 | US | Louisiana | Caldwell | 22021 | 3253 | 52 | 0 | 32.0902519 | -92.11752148 | 2022-03-12 04:20:50 | Caldwell, Louisiana, US | |
2022-03-04 | US | Ohio | Morgan | 39115 | 3253 | 57 | 0 | 39.62081738 | -81.85308173 | 2022-03-05 04:21:10 | Morgan, Ohio, US | |
2022-03-03 | US | North Carolina | Mitchell | 37121 | 3253 | 34 | 0 | 36.01059309 | -82.1582442 | 2022-03-04 04:21:09 | Mitchell, North Carolina, US | |
2022-02-27 | US | Vermont | Orange | 50017 | 3253 | 11 | 0 | 44.00470222 | -72.37640104 | 2022-02-28 04:21:05 | Orange, Vermont, US | |
2022-02-26 | US | Vermont | Orange | 50017 | 3253 | 11 | 0 | 44.00470222 | -72.37640104 | 2022-02-27 04:21:04 | Orange, Vermont, US | |
2022-02-25 | US | Vermont | Orange | 50017 | 3253 | 11 | 0 | 44.00470222 | -72.37640104 | 2022-02-26 04:21:12 | Orange, Vermont, US | |
2022-02-17 | US | Virginia | Southampton | 51175 | 3253 | 80 | 0 | 36.72231125 | -77.10642712 | 2022-02-18 04:21:04 | Southampton, Virginia, US | |
2022-02-16 | US | Virginia | Greensville | 51081 | 3253 | 33 | 0 | 36.67878901 | -77.56351439 | 2022-02-17 04:20:56 | Greensville, Virginia, US | |
2022-02-10 | US | North Dakota | Walsh | 38099 | 3253 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-02-11 04:21:09 | Walsh, North Dakota, US | |
2022-02-05 | Russia | Chukotka Autonomous Okrug | 3253 | 40 | 0 | 66.0006475 | 169.4900869 | 2022-02-06 04:21:00 | Chukotka Autonomous Okrug, Russia | |||
2022-02-03 | US | Michigan | Benzie | 26019 | 3253 | 60 | 0 | 44.63899297 | -86.01608482 | 2022-02-04 04:21:10 | Benzie, Michigan, US | |
2022-02-02 | US | Michigan | Benzie | 26019 | 3253 | 60 | 0 | 44.63899297 | -86.01608482 | 2022-02-03 04:21:21 | Benzie, Michigan, US | |
2022-01-30 | US | Wisconsin | Rusk | 55107 | 3253 | 45 | 0 | 45.47498854 | -91.1333012 | 2022-01-31 04:21:09 | Rusk, Wisconsin, US | |
2022-01-29 | US | Wisconsin | Rusk | 55107 | 3253 | 45 | 0 | 45.47498854 | -91.1333012 | 2022-01-30 04:21:26 | Rusk, Wisconsin, US | |
2022-01-28 | US | Wisconsin | Rusk | 55107 | 3253 | 45 | 0 | 45.47498854 | -91.1333012 | 2022-01-29 04:21:10 | Rusk, Wisconsin, US | |
2022-01-25 | US | Kentucky | Washington | 21229 | 3253 | 54 | 0 | 37.75599461 | -85.17407732 | 2022-01-26 04:21:07 | Washington, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;