daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
371 rows where confirmed = 2022 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-22 | US | Arkansas | Dallas | 5039 | 2022 | 38 | 0 | 33.97042763 | -92.65167437 | 2022-12-23 04:21:04 | Dallas, Arkansas, US | |
2022-12-11 | US | Kentucky | Owsley | 21189 | 2022 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-12-12 04:21:01 | Owsley, Kentucky, US | |
2022-12-10 | US | Kentucky | Owsley | 21189 | 2022 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-12-11 04:20:50 | Owsley, Kentucky, US | |
2022-12-09 | US | Kentucky | Owsley | 21189 | 2022 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-12-10 04:21:02 | Owsley, Kentucky, US | |
2022-12-08 | US | Kentucky | Owsley | 21189 | 2022 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-12-09 04:21:05 | Owsley, Kentucky, US | |
2022-12-07 | US | Kentucky | Owsley | 21189 | 2022 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-12-08 04:21:07 | Owsley, Kentucky, US | |
2022-12-06 | US | Kentucky | Owsley | 21189 | 2022 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-12-07 04:20:58 | Owsley, Kentucky, US | |
2022-12-05 | US | Kentucky | Owsley | 21189 | 2022 | 32 | 0 | 37.42823949 | -83.68811419 | 2022-12-06 04:21:03 | Owsley, Kentucky, US | |
2022-10-12 | US | Minnesota | Lac qui Parle | 27073 | 2022 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-10-13 04:22:39 | Lac qui Parle, Minnesota, US | |
2022-10-11 | US | Minnesota | Lac qui Parle | 27073 | 2022 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-10-12 04:22:51 | Lac qui Parle, Minnesota, US | |
2022-10-10 | US | Minnesota | Lac qui Parle | 27073 | 2022 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-10-11 04:23:05 | Lac qui Parle, Minnesota, US | |
2022-10-09 | US | Minnesota | Lac qui Parle | 27073 | 2022 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-10-10 04:22:32 | Lac qui Parle, Minnesota, US | |
2022-10-08 | US | Minnesota | Lac qui Parle | 27073 | 2022 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-10-09 04:21:16 | Lac qui Parle, Minnesota, US | |
2022-10-07 | US | Minnesota | Lac qui Parle | 27073 | 2022 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-10-08 04:22:56 | Lac qui Parle, Minnesota, US | |
2022-10-06 | US | Minnesota | Lac qui Parle | 27073 | 2022 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-10-07 04:23:08 | Lac qui Parle, Minnesota, US | |
2022-09-02 | China | Hebei | 2022 | 7 | 0 | 37.8957 | 114.9042 | 2022-09-03 04:21:04 | Hebei, China | |||
2022-08-18 | US | Texas | Rains | 48379 | 2022 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-08-19 04:20:54 | Rains, Texas, US | |
2022-08-17 | US | Texas | Rains | 48379 | 2022 | 59 | 0 | 32.87109387 | -95.79232691 | 2022-08-18 04:21:11 | Rains, Texas, US | |
2022-08-16 | US | Virginia | Williamsburg | 51830 | 2022 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-08-17 04:20:59 | Williamsburg, Virginia, US | |
2022-08-16 | US | Texas | Refugio | 48391 | 2022 | 38 | 0 | 28.3238976 | -97.15766311 | 2022-08-17 04:20:59 | Refugio, Texas, US | |
2022-08-14 | US | Virginia | Buena Vista | 51530 | 2022 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-08-15 04:20:59 | Buena Vista, Virginia, US | |
2022-08-13 | US | Virginia | Buena Vista | 51530 | 2022 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-08-14 04:20:55 | Buena Vista, Virginia, US | |
2022-08-12 | US | Virginia | Buena Vista | 51530 | 2022 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-08-13 04:20:52 | Buena Vista, Virginia, US | |
2022-07-24 | US | West Virginia | Calhoun | 54013 | 2022 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-25 04:20:51 | Calhoun, West Virginia, US | |
2022-07-23 | US | West Virginia | Calhoun | 54013 | 2022 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-24 04:20:47 | Calhoun, West Virginia, US | |
2022-07-22 | US | West Virginia | Calhoun | 54013 | 2022 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-23 04:20:53 | Calhoun, West Virginia, US | |
2022-07-19 | US | Alabama | Greene | 1063 | 2022 | 51 | 0 | 32.85504247 | -87.95684022 | 2022-07-20 04:20:59 | Greene, Alabama, US | |
2022-07-18 | US | Texas | Hansford | 48195 | 2022 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-07-19 04:20:58 | Hansford, Texas, US | |
2022-07-18 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-19 04:20:58 | Franklin, Mississippi, US | |
2022-07-17 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-18 04:20:59 | Franklin, Mississippi, US | |
2022-07-16 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-17 04:21:15 | Franklin, Mississippi, US | |
2022-07-15 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-16 04:21:05 | Franklin, Mississippi, US | |
2022-07-14 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-15 04:20:53 | Franklin, Mississippi, US | |
2022-07-13 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-14 04:20:57 | Franklin, Mississippi, US | |
2022-07-13 | US | Colorado | Conejos | 8021 | 2022 | 57 | 0 | 37.201606 | -106.1917488 | 2022-07-14 04:20:57 | Conejos, Colorado, US | |
2022-07-12 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-13 04:20:58 | Franklin, Mississippi, US | |
2022-07-11 | US | Mississippi | Franklin | 28037 | 2022 | 38 | 0 | 31.47786634 | -90.89672989 | 2022-07-12 04:20:51 | Franklin, Mississippi, US | |
2022-07-03 | US | Wisconsin | Menominee | 55078 | 2022 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-04 04:20:54 | Menominee, Wisconsin, US | |
2022-07-02 | US | Wisconsin | Menominee | 55078 | 2022 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-03 04:20:59 | Menominee, Wisconsin, US | |
2022-07-01 | US | Wisconsin | Menominee | 55078 | 2022 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-02 04:21:16 | Menominee, Wisconsin, US | |
2022-06-29 | US | Wisconsin | Menominee | 55078 | 2022 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-06-30 04:21:01 | Menominee, Wisconsin, US | |
2022-06-28 | US | Wisconsin | Menominee | 55078 | 2022 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-06-29 04:20:59 | Menominee, Wisconsin, US | |
2022-06-28 | US | Georgia | Taylor | 13269 | 2022 | 54 | 0 | 32.55792548 | -84.25077141 | 2022-06-29 04:20:59 | Taylor, Georgia, US | |
2022-06-27 | US | Georgia | Taylor | 13269 | 2022 | 54 | 0 | 32.55792548 | -84.25077141 | 2022-06-28 04:20:58 | Taylor, Georgia, US | |
2022-06-26 | US | Georgia | Taylor | 13269 | 2022 | 54 | 0 | 32.55792548 | -84.25077141 | 2022-06-27 04:21:00 | Taylor, Georgia, US | |
2022-06-25 | US | Georgia | Taylor | 13269 | 2022 | 54 | 0 | 32.55792548 | -84.25077141 | 2022-06-26 04:21:02 | Taylor, Georgia, US | |
2022-06-24 | US | Georgia | Taylor | 13269 | 2022 | 54 | 0 | 32.55792548 | -84.25077141 | 2022-06-25 04:20:57 | Taylor, Georgia, US | |
2022-06-23 | US | Georgia | Taylor | 13269 | 2022 | 54 | 0 | 32.55792548 | -84.25077141 | 2022-06-24 04:20:58 | Taylor, Georgia, US | |
2022-06-22 | US | Georgia | Taylor | 13269 | 2022 | 54 | 0 | 32.55792548 | -84.25077141 | 2022-06-23 04:20:55 | Taylor, Georgia, US | |
2022-06-20 | US | Colorado | Yuma | 8125 | 2022 | 25 | 0 | 40.00346839 | -102.4258673 | 2022-06-21 04:20:56 | Yuma, Colorado, US | |
2022-06-12 | US | Illinois | Schuyler | 17169 | 2022 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-13 04:21:14 | Schuyler, Illinois, US | |
2022-06-11 | US | Illinois | Schuyler | 17169 | 2022 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-12 04:20:53 | Schuyler, Illinois, US | |
2022-06-10 | US | Illinois | Schuyler | 17169 | 2022 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-11 04:21:01 | Schuyler, Illinois, US | |
2022-06-07 | US | Kansas | Ellsworth | 20053 | 2022 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-06-08 04:20:55 | Ellsworth, Kansas, US | |
2022-06-06 | US | Kansas | Ellsworth | 20053 | 2022 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-06-07 04:21:08 | Ellsworth, Kansas, US | |
2022-06-05 | US | Kansas | Ellsworth | 20053 | 2022 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-06-06 04:20:57 | Ellsworth, Kansas, US | |
2022-06-04 | US | Kansas | Ellsworth | 20053 | 2022 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-06-05 04:20:55 | Ellsworth, Kansas, US | |
2022-06-03 | US | Kansas | Ellsworth | 20053 | 2022 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-06-04 04:20:58 | Ellsworth, Kansas, US | |
2022-06-02 | US | Kansas | Ellsworth | 20053 | 2022 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-06-03 04:20:58 | Ellsworth, Kansas, US | |
2022-06-01 | US | Kansas | Ellsworth | 20053 | 2022 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-06-02 05:20:39 | Ellsworth, Kansas, US | |
2022-05-26 | US | New Mexico | Quay | 35037 | 2022 | 57 | 0 | 35.10403332 | -103.5481727 | 2022-05-27 04:20:56 | Quay, New Mexico, US | |
2022-05-25 | US | New Mexico | Quay | 35037 | 2022 | 56 | 0 | 35.10403332 | -103.5481727 | 2022-05-26 04:20:50 | Quay, New Mexico, US | |
2022-05-24 | US | Minnesota | Pipestone | 27117 | 2022 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-25 04:20:56 | Pipestone, Minnesota, US | |
2022-05-22 | US | New Mexico | Quay | 35037 | 2022 | 56 | 0 | 35.10403332 | -103.5481727 | 2022-05-26 04:20:50 | Quay, New Mexico, US | |
2022-05-12 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-05-13 04:20:51 | Oregon, Missouri, US | |
2022-05-11 | US | West Virginia | Tucker | 54093 | 2022 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-05-12 04:20:54 | Tucker, West Virginia, US | |
2022-05-11 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-05-12 04:20:54 | Oregon, Missouri, US | |
2022-05-10 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-05-11 04:20:48 | Oregon, Missouri, US | |
2022-05-09 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-05-10 04:20:50 | Oregon, Missouri, US | |
2022-05-08 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-05-09 04:20:54 | Oregon, Missouri, US | |
2022-05-07 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-05-08 04:20:49 | Oregon, Missouri, US | |
2022-05-06 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-05-07 04:21:09 | Oregon, Missouri, US | |
2022-05-05 | US | Indiana | Union | 18161 | 2022 | 21 | 0 | 39.62550777 | -84.92497066 | 2022-05-06 04:21:00 | Union, Indiana, US | |
2022-05-04 | US | Indiana | Union | 18161 | 2022 | 21 | 0 | 39.62550777 | -84.92497066 | 2022-05-05 04:20:55 | Union, Indiana, US | |
2022-04-26 | US | West Virginia | Pocahontas | 54075 | 2022 | 30 | 0 | 38.32758728 | -80.00993811 | 2022-04-27 04:20:52 | Pocahontas, West Virginia, US | |
2022-04-06 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-07 04:20:53 | Oregon, Missouri, US | |
2022-04-05 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-06 04:20:49 | Oregon, Missouri, US | |
2022-04-04 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-05 04:20:48 | Oregon, Missouri, US | |
2022-04-03 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-04 04:20:51 | Oregon, Missouri, US | |
2022-04-02 | US | Puerto Rico | Rincon | 72117 | 2022 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-04-03 04:20:48 | Rincon, Puerto Rico, US | |
2022-04-02 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-03 04:20:48 | Oregon, Missouri, US | |
2022-04-01 | US | Puerto Rico | Rincon | 72117 | 2022 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-04-02 04:20:47 | Rincon, Puerto Rico, US | |
2022-04-01 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-02 04:20:47 | Oregon, Missouri, US | |
2022-03-31 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-01 04:20:28 | Oregon, Missouri, US | |
2022-03-30 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-03-31 04:20:56 | Oregon, Missouri, US | |
2022-03-29 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-03-30 04:20:45 | Oregon, Missouri, US | |
2022-03-28 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-03-29 04:20:46 | Oregon, Missouri, US | |
2022-03-27 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-03-28 04:20:33 | Oregon, Missouri, US | |
2022-03-26 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-03-27 04:20:47 | Oregon, Missouri, US | |
2022-03-25 | US | Missouri | Oregon | 29149 | 2022 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-03-26 04:20:23 | Oregon, Missouri, US | |
2022-03-17 | US | Nebraska | Custer | 31041 | 2022 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-03-18 04:20:55 | Custer, Nebraska, US | |
2022-03-14 | US | Minnesota | Murray | 27101 | 2022 | 15 | 0 | 44.02216709 | -95.76328482 | 2022-03-15 04:20:47 | Murray, Minnesota, US | |
2022-03-08 | US | Nebraska | Custer | 31041 | 2022 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-03-09 04:20:59 | Custer, Nebraska, US | |
2022-03-06 | US | Nebraska | Custer | 31041 | 2022 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-03-07 04:20:47 | Custer, Nebraska, US | |
2022-03-05 | US | Nebraska | Custer | 31041 | 2022 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-03-06 04:20:49 | Custer, Nebraska, US | |
2022-03-04 | US | Nebraska | Custer | 31041 | 2022 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-03-05 04:21:10 | Custer, Nebraska, US | |
2022-03-02 | US | Idaho | Boundary | 16021 | 2022 | 57 | 0 | 48.76684761 | -116.4630179 | 2022-03-03 04:21:01 | Boundary, Idaho, US | |
2022-03-01 | US | Iowa | Howard | 19089 | 2022 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-03-02 04:21:07 | Howard, Iowa, US | |
2022-02-28 | US | Iowa | Howard | 19089 | 2022 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-03-01 04:21:09 | Howard, Iowa, US | |
2022-02-27 | US | Iowa | Howard | 19089 | 2022 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-28 04:21:05 | Howard, Iowa, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;