daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
327 rows where confirmed = 2099 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-07 | US | Tennessee | Pickett | 47137 | 2099 | 38 | 0 | 36.55606529 | -85.077633 | 2022-12-08 04:21:07 | Pickett, Tennessee, US | |
2022-12-06 | US | Tennessee | Pickett | 47137 | 2099 | 38 | 0 | 36.55606529 | -85.077633 | 2022-12-07 04:20:58 | Pickett, Tennessee, US | |
2022-09-13 | US | Georgia | Irwin | 13155 | 2099 | 52 | 0 | 31.60213036 | -83.27501387 | 2022-09-14 04:20:44 | Irwin, Georgia, US | |
2022-09-12 | US | Georgia | Irwin | 13155 | 2099 | 52 | 0 | 31.60213036 | -83.27501387 | 2022-09-13 04:20:57 | Irwin, Georgia, US | |
2022-09-11 | US | Georgia | Irwin | 13155 | 2099 | 52 | 0 | 31.60213036 | -83.27501387 | 2022-09-12 04:20:58 | Irwin, Georgia, US | |
2022-09-10 | US | Georgia | Irwin | 13155 | 2099 | 52 | 0 | 31.60213036 | -83.27501387 | 2022-09-11 04:20:50 | Irwin, Georgia, US | |
2022-09-09 | US | Tennessee | Van Buren | 47175 | 2099 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-09-10 04:21:10 | Van Buren, Tennessee, US | |
2022-09-09 | US | Georgia | Irwin | 13155 | 2099 | 52 | 0 | 31.60213036 | -83.27501387 | 2022-09-10 04:21:10 | Irwin, Georgia, US | |
2022-09-08 | US | Montana | Powell | 30077 | 2099 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-09 04:21:11 | Powell, Montana, US | |
2022-09-08 | US | Georgia | Irwin | 13155 | 2099 | 52 | 0 | 31.60213036 | -83.27501387 | 2022-09-09 04:21:11 | Irwin, Georgia, US | |
2022-09-07 | US | Montana | Powell | 30077 | 2099 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-08 04:21:02 | Powell, Montana, US | |
2022-09-07 | US | Georgia | Irwin | 13155 | 2099 | 52 | 0 | 31.60213036 | -83.27501387 | 2022-09-08 04:21:02 | Irwin, Georgia, US | |
2022-09-06 | US | South Dakota | Turner | 46125 | 2099 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-09-07 04:20:59 | Turner, South Dakota, US | |
2022-09-06 | US | Montana | Powell | 30077 | 2099 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-07 04:20:59 | Powell, Montana, US | |
2022-09-05 | US | South Dakota | Turner | 46125 | 2099 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-09-06 04:21:02 | Turner, South Dakota, US | |
2022-09-05 | US | Montana | Powell | 30077 | 2099 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-06 04:21:02 | Powell, Montana, US | |
2022-09-04 | US | South Dakota | Turner | 46125 | 2099 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-09-05 04:21:01 | Turner, South Dakota, US | |
2022-09-04 | US | Montana | Powell | 30077 | 2099 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-05 04:21:01 | Powell, Montana, US | |
2022-09-03 | US | South Dakota | Turner | 46125 | 2099 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-09-04 04:21:22 | Turner, South Dakota, US | |
2022-09-03 | US | Montana | Powell | 30077 | 2099 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-04 04:21:22 | Powell, Montana, US | |
2022-09-02 | US | South Dakota | Turner | 46125 | 2099 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-09-03 04:21:04 | Turner, South Dakota, US | |
2022-09-02 | US | Montana | Powell | 30077 | 2099 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-03 04:21:04 | Powell, Montana, US | |
2022-09-01 | US | South Dakota | Turner | 46125 | 2099 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-09-02 04:21:07 | Turner, South Dakota, US | |
2022-08-31 | US | South Dakota | Turner | 46125 | 2099 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-09-01 04:21:03 | Turner, South Dakota, US | |
2022-08-29 | US | Colorado | Conejos | 8021 | 2099 | 57 | 0 | 37.201606 | -106.1917488 | 2022-08-30 04:21:03 | Conejos, Colorado, US | |
2022-08-21 | US | Wisconsin | Menominee | 55078 | 2099 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-08-22 04:20:38 | Menominee, Wisconsin, US | |
2022-08-20 | US | Wisconsin | Menominee | 55078 | 2099 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-08-21 04:20:44 | Menominee, Wisconsin, US | |
2022-08-19 | US | Wisconsin | Menominee | 55078 | 2099 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-08-20 04:21:01 | Menominee, Wisconsin, US | |
2022-08-18 | US | Wisconsin | Menominee | 55078 | 2099 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-08-19 04:20:54 | Menominee, Wisconsin, US | |
2022-08-15 | US | Michigan | Lake | 26085 | 2099 | 39 | 0 | 43.99050893 | -85.802173 | 2022-08-16 04:20:58 | Lake, Michigan, US | |
2022-08-14 | US | Michigan | Lake | 26085 | 2099 | 39 | 0 | 43.99050893 | -85.802173 | 2022-08-15 04:20:59 | Lake, Michigan, US | |
2022-08-13 | US | Michigan | Lake | 26085 | 2099 | 39 | 0 | 43.99050893 | -85.802173 | 2022-08-14 04:20:55 | Lake, Michigan, US | |
2022-08-12 | US | Michigan | Lake | 26085 | 2099 | 39 | 0 | 43.99050893 | -85.802173 | 2022-08-13 04:20:52 | Lake, Michigan, US | |
2022-08-11 | US | Michigan | Lake | 26085 | 2099 | 39 | 0 | 43.99050893 | -85.802173 | 2022-08-12 04:20:54 | Lake, Michigan, US | |
2022-08-10 | US | Michigan | Lake | 26085 | 2099 | 39 | 0 | 43.99050893 | -85.802173 | 2022-08-11 04:20:49 | Lake, Michigan, US | |
2022-08-09 | US | Michigan | Lake | 26085 | 2099 | 39 | 0 | 43.99050893 | -85.802173 | 2022-08-10 04:20:57 | Lake, Michigan, US | |
2022-08-03 | US | Arkansas | Monroe | 5095 | 2099 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-08-04 04:20:58 | Monroe, Arkansas, US | |
2022-07-19 | US | Indiana | Union | 18161 | 2099 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-07-20 04:20:59 | Union, Indiana, US | |
2022-07-11 | US | West Virginia | Tucker | 54093 | 2099 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-07-12 04:20:51 | Tucker, West Virginia, US | |
2022-06-23 | US | Virginia | Buena Vista | 51530 | 2099 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-06-24 04:20:58 | Buena Vista, Virginia, US | |
2022-06-19 | US | Puerto Rico | Ceiba | 72037 | 2099 | 0 | 0 | 18.251818 | -65.666416 | 2022-06-20 04:21:01 | Ceiba, Puerto Rico, US | |
2022-06-14 | US | West Virginia | Pleasants | 54073 | 2099 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-06-15 04:20:54 | Pleasants, West Virginia, US | |
2022-06-13 | US | West Virginia | Pocahontas | 54075 | 2099 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-06-14 04:20:52 | Pocahontas, West Virginia, US | |
2022-06-13 | US | West Virginia | Pleasants | 54073 | 2099 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-06-14 04:20:52 | Pleasants, West Virginia, US | |
2022-06-03 | US | Puerto Rico | Guanica | 72055 | 2099 | 0 | 0 | 17.982429 | -66.919643 | 2022-06-04 04:20:58 | Guanica, Puerto Rico, US | |
2022-05-23 | US | Virginia | Fairfax City | 51600 | 2099 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-05-24 04:20:57 | Fairfax City, Virginia, US | |
2022-05-21 | US | Texas | Clay | 48077 | 2099 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-22 04:20:52 | Clay, Texas, US | |
2022-05-10 | US | Idaho | Boundary | 16021 | 2099 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-11 04:20:48 | Boundary, Idaho, US | |
2022-05-09 | US | Idaho | Boundary | 16021 | 2099 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-05-10 04:20:50 | Boundary, Idaho, US | |
2022-05-08 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-09 04:20:54 | Gilmer, West Virginia, US | |
2022-05-07 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-08 04:20:49 | Gilmer, West Virginia, US | |
2022-05-06 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-07 04:21:09 | Gilmer, West Virginia, US | |
2022-05-05 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-06 04:21:00 | Gilmer, West Virginia, US | |
2022-05-04 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-05 04:20:55 | Gilmer, West Virginia, US | |
2022-05-03 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-04 04:20:59 | Gilmer, West Virginia, US | |
2022-05-02 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-03 04:21:00 | Gilmer, West Virginia, US | |
2022-05-01 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-02 04:21:10 | Gilmer, West Virginia, US | |
2022-04-30 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-05-01 04:20:57 | Gilmer, West Virginia, US | |
2022-04-29 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-04-30 04:21:05 | Gilmer, West Virginia, US | |
2022-04-28 | US | West Virginia | Gilmer | 54021 | 2099 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-04-29 04:20:59 | Gilmer, West Virginia, US | |
2022-04-09 | US | Puerto Rico | Sabana Grande | 72121 | 2099 | 0 | 0 | 18.08282 | -66.943758 | 2022-04-10 04:20:52 | Sabana Grande, Puerto Rico, US | |
2022-03-23 | US | Missouri | St. Clair | 29185 | 2099 | 33 | 0 | 38.03699437 | -93.77631447 | 2022-03-24 04:20:43 | St. Clair, Missouri, US | |
2022-03-21 | US | Missouri | St. Clair | 29185 | 2099 | 33 | 0 | 38.03699437 | -93.77631447 | 2022-03-22 04:20:54 | St. Clair, Missouri, US | |
2022-03-16 | US | Puerto Rico | Florida | 72054 | 2099 | 0 | 0 | 18.373715 | -66.560488 | 2022-03-17 04:20:56 | Florida, Puerto Rico, US | |
2022-03-14 | US | Puerto Rico | Adjuntas | 72001 | 2099 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-03-15 04:20:47 | Adjuntas, Puerto Rico, US | |
2022-03-13 | US | Puerto Rico | Adjuntas | 72001 | 2099 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-03-14 04:20:46 | Adjuntas, Puerto Rico, US | |
2022-03-10 | US | Georgia | Clinch | 13065 | 2099 | 40 | 0 | 30.91395822 | -82.70432472 | 2022-03-11 04:20:50 | Clinch, Georgia, US | |
2022-03-09 | US | Kentucky | Bracken | 21023 | 2099 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-10 04:20:48 | Bracken, Kentucky, US | |
2022-03-08 | US | Puerto Rico | Penuelas | 72111 | 2099 | 0 | 0 | 18.059645 | -66.721572 | 2022-03-09 04:20:59 | Penuelas, Puerto Rico, US | |
2022-03-08 | US | Kentucky | Bracken | 21023 | 2099 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-09 04:20:59 | Bracken, Kentucky, US | |
2022-03-07 | US | Puerto Rico | Penuelas | 72111 | 2099 | 0 | 0 | 18.059645 | -66.721572 | 2022-03-08 04:20:54 | Penuelas, Puerto Rico, US | |
2022-03-07 | US | Kentucky | Bracken | 21023 | 2099 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-08 04:20:54 | Bracken, Kentucky, US | |
2022-03-06 | US | Puerto Rico | Penuelas | 72111 | 2099 | 0 | 0 | 18.059645 | -66.721572 | 2022-03-07 04:20:47 | Penuelas, Puerto Rico, US | |
2022-03-06 | US | Kentucky | Bracken | 21023 | 2099 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-07 04:20:47 | Bracken, Kentucky, US | |
2022-03-05 | US | Kentucky | Bracken | 21023 | 2099 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-06 04:20:49 | Bracken, Kentucky, US | |
2022-03-04 | US | Kentucky | Bracken | 21023 | 2099 | 24 | 0 | 38.69158994 | -84.08532444 | 2022-03-05 04:21:10 | Bracken, Kentucky, US | |
2022-03-01 | US | Texas | Somervell | 48425 | 2099 | 35 | 0 | 32.22236802 | -97.77403489 | 2022-03-02 04:21:07 | Somervell, Texas, US | |
2022-03-01 | US | Louisiana | Red River | 22081 | 2099 | 52 | 0 | 32.09530039 | -93.34213308 | 2022-03-02 04:21:07 | Red River, Louisiana, US | |
2022-02-28 | US | Texas | Somervell | 48425 | 2099 | 35 | 0 | 32.22236802 | -97.77403489 | 2022-03-01 04:21:09 | Somervell, Texas, US | |
2022-02-28 | US | Louisiana | Red River | 22081 | 2099 | 52 | 0 | 32.09530039 | -93.34213308 | 2022-03-01 04:21:09 | Red River, Louisiana, US | |
2022-02-27 | US | Louisiana | Red River | 22081 | 2099 | 52 | 0 | 32.09530039 | -93.34213308 | 2022-02-28 04:21:05 | Red River, Louisiana, US | |
2022-02-26 | US | Louisiana | Red River | 22081 | 2099 | 52 | 0 | 32.09530039 | -93.34213308 | 2022-02-27 04:21:04 | Red River, Louisiana, US | |
2022-02-25 | US | Louisiana | Red River | 22081 | 2099 | 52 | 0 | 32.09530039 | -93.34213308 | 2022-02-26 04:21:12 | Red River, Louisiana, US | |
2022-02-21 | US | Georgia | Macon | 13193 | 2099 | 48 | 0 | 32.35207048 | -84.04234127 | 2022-02-22 04:21:01 | Macon, Georgia, US | |
2022-02-17 | US | Mississippi | Choctaw | 28019 | 2099 | 31 | 0 | 33.34598242 | -89.24809382 | 2022-02-18 04:21:04 | Choctaw, Mississippi, US | |
2022-02-09 | US | Virginia | Northampton | 51131 | 2099 | 53 | 0 | 37.34062933 | -75.87751591 | 2022-02-10 04:21:14 | Northampton, Virginia, US | |
2022-02-09 | US | Texas | Live Oak | 48297 | 2099 | 40 | 0 | 28.35101362 | -98.1246786 | 2022-02-10 04:21:14 | Live Oak, Texas, US | |
2022-02-03 | US | Kentucky | Livingston | 21139 | 2099 | 51 | 0 | 37.21137452 | -88.34797529 | 2022-02-04 04:21:10 | Livingston, Kentucky, US | |
2022-02-03 | US | Kentucky | Gallatin | 21077 | 2099 | 45 | 0 | 38.75398691 | -84.8558382 | 2022-02-04 04:21:10 | Gallatin, Kentucky, US | |
2022-02-02 | US | Tennessee | Moore | 47127 | 2099 | 36 | 0 | 35.27724699 | -86.36230578 | 2022-02-03 04:21:21 | Moore, Tennessee, US | |
2022-01-31 | US | West Virginia | Clay | 54015 | 2099 | 31 | 0 | 38.46231092 | -81.07652217 | 2022-02-01 04:21:11 | Clay, West Virginia, US | |
2022-01-31 | US | Idaho | Washington | 16087 | 2099 | 52 | 0 | 44.45275475 | -116.78476880000001 | 2022-02-01 04:21:11 | Washington, Idaho, US | |
2022-01-30 | US | Idaho | Clearwater | 16035 | 2099 | 29 | 0 | 46.67459924 | -115.6622393 | 2022-01-31 04:21:09 | Clearwater, Idaho, US | |
2022-01-29 | US | Idaho | Clearwater | 16035 | 2099 | 29 | 0 | 46.67459924 | -115.6622393 | 2022-01-30 04:21:26 | Clearwater, Idaho, US | |
2022-01-27 | US | Nebraska | Box Butte | 31013 | 2099 | 8 | 0 | 42.22079243 | -103.08788340000001 | 2022-01-28 04:21:09 | Box Butte, Nebraska, US | |
2022-01-24 | US | Texas | Runnels | 48399 | 2099 | 59 | 0 | 31.8314342 | -99.97616148 | 2022-01-25 04:21:05 | Runnels, Texas, US | |
2022-01-13 | Japan | Shimane | 2099 | 5 | 0 | 35.07076 | 132.55406399999998 | 2022-01-14 04:21:54 | Shimane, Japan | |||
2022-01-12 | US | Minnesota | Yellow Medicine | 27173 | 2099 | 25 | 0 | 44.71710183 | -95.86842453 | 2022-01-13 08:00:09 | Yellow Medicine, Minnesota, US | |
2022-01-06 | US | Texas | Callahan | 48059 | 2099 | 61 | 0 | 32.29760619 | -99.37326312 | 2022-01-07 04:22:09 | Callahan, Texas, US | |
2022-01-04 | US | West Virginia | Roane | 54087 | 2099 | 28 | 0 | 38.71622686 | -81.35243568 | 2022-01-05 04:21:59 | Roane, West Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;