daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
256 rows where confirmed = 2422 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-21 | US | Illinois | Schuyler | 17169 | 2422 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-12-22 04:20:56 | Schuyler, Illinois, US | |
2022-12-18 | US | North Dakota | Traill | 38097 | 2422 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-12-19 04:21:03 | Traill, North Dakota, US | |
2022-12-17 | US | North Dakota | Traill | 38097 | 2422 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-12-18 04:21:03 | Traill, North Dakota, US | |
2022-12-16 | US | North Dakota | Traill | 38097 | 2422 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-12-17 04:21:04 | Traill, North Dakota, US | |
2022-12-07 | US | New Mexico | Sierra | 35051 | 2422 | 85 | 0 | 33.13028233 | -107.1925893 | 2022-12-08 04:21:07 | Sierra, New Mexico, US | |
2022-12-06 | US | New Mexico | Sierra | 35051 | 2422 | 85 | 0 | 33.13028233 | -107.1925893 | 2022-12-07 04:20:58 | Sierra, New Mexico, US | |
2022-12-01 | US | Arkansas | Searcy | 5129 | 2422 | 52 | 0 | 35.9109364 | -92.69936482 | 2022-12-02 04:21:07 | Searcy, Arkansas, US | |
2022-11-17 | US | New Mexico | Quay | 35037 | 2422 | 69 | 0 | 35.10403332 | -103.5481727 | 2022-11-18 04:21:15 | Quay, New Mexico, US | |
2022-11-08 | US | West Virginia | Pocahontas | 54075 | 2422 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-09 04:21:22 | Pocahontas, West Virginia, US | |
2022-11-07 | US | West Virginia | Pocahontas | 54075 | 2422 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-08 04:21:21 | Pocahontas, West Virginia, US | |
2022-09-22 | US | Tennessee | Hancock | 47067 | 2422 | 40 | 0 | 36.52692871 | -83.22375847 | 2022-09-23 04:23:13 | Hancock, Tennessee, US | |
2022-09-21 | US | Tennessee | Hancock | 47067 | 2422 | 40 | 0 | 36.52692871 | -83.22375847 | 2022-09-22 04:22:56 | Hancock, Tennessee, US | |
2022-09-20 | US | Tennessee | Hancock | 47067 | 2422 | 40 | 0 | 36.52692871 | -83.22375847 | 2022-09-21 04:23:22 | Hancock, Tennessee, US | |
2022-08-30 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-31 04:20:57 | Claiborne, Mississippi, US | |
2022-08-29 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-30 04:21:03 | Claiborne, Mississippi, US | |
2022-08-28 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-29 04:21:06 | Claiborne, Mississippi, US | |
2022-08-27 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-28 04:21:02 | Claiborne, Mississippi, US | |
2022-08-26 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-27 04:20:57 | Claiborne, Mississippi, US | |
2022-08-25 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-26 04:21:02 | Claiborne, Mississippi, US | |
2022-08-25 | US | Indiana | Switzerland | 18155 | 2422 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-08-26 04:21:02 | Switzerland, Indiana, US | |
2022-08-24 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-25 04:21:13 | Claiborne, Mississippi, US | |
2022-08-24 | US | Indiana | Switzerland | 18155 | 2422 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-08-25 04:21:13 | Switzerland, Indiana, US | |
2022-08-23 | US | Mississippi | Claiborne | 28021 | 2422 | 47 | 0 | 31.97061673 | -90.90702196 | 2022-08-24 04:20:46 | Claiborne, Mississippi, US | |
2022-08-16 | US | Tennessee | Moore | 47127 | 2422 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-08-17 04:20:59 | Moore, Tennessee, US | |
2022-08-09 | US | Arkansas | Nevada | 5099 | 2422 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-08-10 04:20:57 | Nevada, Arkansas, US | |
2022-08-04 | US | Tennessee | Clay | 47027 | 2422 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-08-05 04:20:52 | Clay, Tennessee, US | |
2022-07-28 | US | Arkansas | Cleveland | 5025 | 2422 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-07-29 04:20:45 | Cleveland, Arkansas, US | |
2022-07-24 | US | Virginia | Essex | 51057 | 2422 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-25 04:20:51 | Essex, Virginia, US | |
2022-07-24 | US | Puerto Rico | Ceiba | 72037 | 2422 | 0 | 0 | 18.251818 | -65.666416 | 2022-07-25 04:20:51 | Ceiba, Puerto Rico, US | |
2022-07-23 | US | Virginia | Essex | 51057 | 2422 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-24 04:20:47 | Essex, Virginia, US | |
2022-07-22 | US | Virginia | Essex | 51057 | 2422 | 35 | 0 | 37.93357639 | -76.94230311 | 2022-07-23 04:20:53 | Essex, Virginia, US | |
2022-07-14 | US | Montana | Dawson | 30021 | 2422 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-07-15 04:20:53 | Dawson, Montana, US | |
2022-07-13 | US | Montana | Dawson | 30021 | 2422 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-07-14 04:20:57 | Dawson, Montana, US | |
2022-07-12 | US | Montana | Dawson | 30021 | 2422 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-07-13 04:20:58 | Dawson, Montana, US | |
2022-07-11 | US | Montana | Dawson | 30021 | 2422 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-07-12 04:20:51 | Dawson, Montana, US | |
2022-07-10 | US | Montana | Dawson | 30021 | 2422 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-07-11 04:20:46 | Dawson, Montana, US | |
2022-07-09 | US | Montana | Dawson | 30021 | 2422 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-07-10 04:20:54 | Dawson, Montana, US | |
2022-07-09 | US | Arkansas | Scott | 5127 | 2422 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-07-10 04:20:54 | Scott, Arkansas, US | |
2022-07-08 | US | Montana | Dawson | 30021 | 2422 | 58 | 0 | 47.26584855 | -104.8944417 | 2022-07-09 04:20:59 | Dawson, Montana, US | |
2022-05-24 | US | Virginia | Poquoson | 51735 | 2422 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-05-25 04:20:56 | Poquoson, Virginia, US | |
2022-05-22 | US | Colorado | San Miguel | 8113 | 2422 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-05-26 04:20:50 | San Miguel, Colorado, US | |
2022-05-21 | US | Colorado | San Miguel | 8113 | 2422 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-05-22 04:20:52 | San Miguel, Colorado, US | |
2022-05-04 | US | Illinois | Brown | 17009 | 2422 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-05-05 04:20:55 | Brown, Illinois, US | |
2022-05-03 | US | Illinois | Brown | 17009 | 2422 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-05-04 04:20:59 | Brown, Illinois, US | |
2022-04-28 | US | Kansas | Coffey | 20031 | 2422 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-04-29 04:20:59 | Coffey, Kansas, US | |
2022-04-27 | US | Kansas | Coffey | 20031 | 2422 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-04-28 04:20:47 | Coffey, Kansas, US | |
2022-04-26 | US | Kansas | Coffey | 20031 | 2422 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-04-27 04:20:52 | Coffey, Kansas, US | |
2022-04-25 | US | Kansas | Coffey | 20031 | 2422 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-04-26 04:20:51 | Coffey, Kansas, US | |
2022-04-24 | US | Virginia | Sussex | 51183 | 2422 | 41 | 0 | 36.92432914 | -77.25791182 | 2022-04-25 04:20:56 | Sussex, Virginia, US | |
2022-04-24 | US | Kansas | Coffey | 20031 | 2422 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-04-25 04:20:56 | Coffey, Kansas, US | |
2022-04-23 | US | Virginia | Sussex | 51183 | 2422 | 41 | 0 | 36.92432914 | -77.25791182 | 2022-04-24 04:20:56 | Sussex, Virginia, US | |
2022-04-23 | US | Kansas | Coffey | 20031 | 2422 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-04-24 04:20:56 | Coffey, Kansas, US | |
2022-04-22 | US | Virginia | Sussex | 51183 | 2422 | 41 | 0 | 36.92432914 | -77.25791182 | 2022-04-23 04:20:50 | Sussex, Virginia, US | |
2022-04-22 | US | Kansas | Coffey | 20031 | 2422 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-04-23 04:20:50 | Coffey, Kansas, US | |
2022-04-20 | US | Virginia | Sussex | 51183 | 2422 | 41 | 0 | 36.92432914 | -77.25791182 | 2022-04-21 04:20:46 | Sussex, Virginia, US | |
2022-04-20 | US | Texas | Ochiltree | 48357 | 2422 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-04-21 04:20:46 | Ochiltree, Texas, US | |
2022-04-12 | US | Virginia | Sussex | 51183 | 2422 | 41 | 0 | 36.92432914 | -77.25791182 | 2022-04-13 04:21:03 | Sussex, Virginia, US | |
2022-04-12 | US | New Mexico | Colfax | 35007 | 2422 | 64 | 0 | 36.60569702 | -104.64726740000002 | 2022-04-13 04:21:03 | Colfax, New Mexico, US | |
2022-04-11 | US | Virginia | Sussex | 51183 | 2422 | 41 | 0 | 36.92432914 | -77.25791182 | 2022-04-12 04:20:49 | Sussex, Virginia, US | |
2022-04-11 | US | New Mexico | Colfax | 35007 | 2422 | 64 | 0 | 36.60569702 | -104.64726740000002 | 2022-04-12 04:20:49 | Colfax, New Mexico, US | |
2022-04-05 | US | Virginia | Sussex | 51183 | 2422 | 40 | 0 | 36.92432914 | -77.25791182 | 2022-04-06 04:20:49 | Sussex, Virginia, US | |
2022-04-04 | US | Virginia | Sussex | 51183 | 2422 | 40 | 0 | 36.92432914 | -77.25791182 | 2022-04-05 04:20:48 | Sussex, Virginia, US | |
2022-04-03 | US | Virginia | Sussex | 51183 | 2422 | 40 | 0 | 36.92432914 | -77.25791182 | 2022-04-04 04:20:51 | Sussex, Virginia, US | |
2022-04-02 | US | Virginia | Sussex | 51183 | 2422 | 40 | 0 | 36.92432914 | -77.25791182 | 2022-04-03 04:20:48 | Sussex, Virginia, US | |
2022-04-01 | US | Virginia | Sussex | 51183 | 2422 | 40 | 0 | 36.92432914 | -77.25791182 | 2022-04-02 04:20:47 | Sussex, Virginia, US | |
2022-03-31 | US | Virginia | Sussex | 51183 | 2422 | 40 | 0 | 36.92432914 | -77.25791182 | 2022-04-01 04:20:28 | Sussex, Virginia, US | |
2022-03-22 | US | South Dakota | Roberts | 46109 | 2422 | 52 | 0 | 45.62975048 | -96.94672673 | 2022-03-23 04:20:48 | Roberts, South Dakota, US | |
2022-03-21 | US | South Dakota | Roberts | 46109 | 2422 | 52 | 0 | 45.62975048 | -96.94672673 | 2022-03-22 04:20:54 | Roberts, South Dakota, US | |
2022-03-20 | US | South Dakota | Roberts | 46109 | 2422 | 52 | 0 | 45.62975048 | -96.94672673 | 2022-03-21 04:20:50 | Roberts, South Dakota, US | |
2022-03-19 | US | South Dakota | Roberts | 46109 | 2422 | 52 | 0 | 45.62975048 | -96.94672673 | 2022-03-20 04:20:45 | Roberts, South Dakota, US | |
2022-03-18 | US | South Dakota | Roberts | 46109 | 2422 | 52 | 0 | 45.62975048 | -96.94672673 | 2022-03-19 04:20:47 | Roberts, South Dakota, US | |
2022-03-17 | US | West Virginia | Ritchie | 54085 | 2422 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-03-18 04:20:55 | Ritchie, West Virginia, US | |
2022-02-28 | US | Missouri | Ralls | 29173 | 2422 | 24 | 0 | 39.52817427 | -91.51838643 | 2022-03-01 04:21:09 | Ralls, Missouri, US | |
2022-02-23 | US | Montana | Deer Lodge | 30023 | 2422 | 29 | 0 | 46.05953325 | -113.073353 | 2022-02-24 04:21:14 | Deer Lodge, Montana, US | |
2022-02-22 | US | Texas | Trinity | 48455 | 2422 | 70 | 0 | 31.0879489 | -95.1367187 | 2022-02-23 04:21:09 | Trinity, Texas, US | |
2022-02-09 | US | Texas | Morris | 48343 | 2422 | 64 | 0 | 33.11304005 | -94.73255695 | 2022-02-10 04:21:14 | Morris, Texas, US | |
2022-02-09 | US | Kentucky | Lee | 21129 | 2422 | 45 | 0 | 37.59645942 | -83.71513901 | 2022-02-10 04:21:14 | Lee, Kentucky, US | |
2022-01-31 | US | Georgia | Turner | 13287 | 2422 | 50 | 0 | 31.71612656 | -83.62069378 | 2022-02-01 04:21:11 | Turner, Georgia, US | |
2022-01-23 | US | Arkansas | Stone | 5137 | 2422 | 51 | 0 | 35.86251946 | -92.15684085 | 2022-01-24 04:21:12 | Stone, Arkansas, US | |
2022-01-18 | US | Puerto Rico | Villalba | 72149 | 2422 | 0 | 0 | 18.127951 | -66.473115 | 2022-01-19 04:21:23 | Villalba, Puerto Rico, US | |
2022-01-11 | US | Minnesota | Chippewa | 27023 | 2422 | 43 | 0 | 45.02343421 | -95.56403693 | 2022-01-12 04:21:44 | Chippewa, Minnesota, US | |
2022-01-04 | US | Tennessee | Stewart | 47161 | 2422 | 44 | 0 | 36.50235092 | -87.83920548 | 2022-01-05 04:21:59 | Stewart, Tennessee, US | |
2022-01-01 | US | Colorado | Gunnison | 8051 | 2422 | 13 | 0 | 38.66611652 | -107.0320729 | 2022-01-02 04:20:52 | Gunnison, Colorado, US | |
2021-12-26 | US | Montana | Custer | 30017 | 2422 | 41 | 0 | 46.25319932 | -105.57375259999998 | 2021-12-27 04:21:58 | Custer, Montana, US | |
2021-12-25 | US | Montana | Custer | 30017 | 2422 | 41 | 0 | 46.25319932 | -105.57375259999998 | 2021-12-26 04:21:50 | Custer, Montana, US | |
2021-12-24 | US | Montana | Custer | 30017 | 2422 | 41 | 0 | 46.25319932 | -105.57375259999998 | 2021-12-25 04:21:37 | Custer, Montana, US | |
2021-12-23 | US | Montana | Custer | 30017 | 2422 | 41 | 0 | 46.25319932 | -105.57375259999998 | 2021-12-24 04:21:34 | Custer, Montana, US | |
2021-12-22 | US | Montana | Custer | 30017 | 2422 | 41 | 0 | 46.25319932 | -105.57375259999998 | 2021-12-23 04:21:21 | Custer, Montana, US | |
2021-12-21 | US | Montana | Custer | 30017 | 2422 | 41 | 0 | 46.25319932 | -105.57375259999998 | 2021-12-22 04:21:54 | Custer, Montana, US | |
2021-12-21 | US | Iowa | Cass | 19029 | 2422 | 69 | 0 | 41.33149454 | -94.92792482 | 2021-12-22 04:21:54 | Cass, Iowa, US | |
2021-12-20 | US | Iowa | Cass | 19029 | 2422 | 69 | 0 | 41.33149454 | -94.92792482 | 2021-12-21 03:21:27 | Cass, Iowa, US | |
2021-12-19 | US | North Carolina | Chowan | 37041 | 2422 | 44 | 0 | 36.12908077 | -76.60118385 | 2021-12-20 04:21:43 | Chowan, North Carolina, US | |
2021-12-19 | US | Minnesota | Cottonwood | 27033 | 2422 | 33 | 0 | 44.00715262 | -95.18138802 | 2021-12-20 04:21:43 | Cottonwood, Minnesota, US | |
2021-12-19 | US | Iowa | Cass | 19029 | 2422 | 69 | 0 | 41.33149454 | -94.92792482 | 2021-12-20 04:21:43 | Cass, Iowa, US | |
2021-12-18 | US | North Carolina | Chowan | 37041 | 2422 | 44 | 0 | 36.12908077 | -76.60118385 | 2021-12-19 04:21:11 | Chowan, North Carolina, US | |
2021-12-18 | US | Minnesota | Cottonwood | 27033 | 2422 | 33 | 0 | 44.00715262 | -95.18138802 | 2021-12-19 04:21:11 | Cottonwood, Minnesota, US | |
2021-12-18 | US | Iowa | Cass | 19029 | 2422 | 69 | 0 | 41.33149454 | -94.92792482 | 2021-12-19 04:21:11 | Cass, Iowa, US | |
2021-12-17 | US | North Carolina | Chowan | 37041 | 2422 | 44 | 0 | 36.12908077 | -76.60118385 | 2021-12-18 02:22:20 | Chowan, North Carolina, US | |
2021-12-17 | US | Minnesota | Cottonwood | 27033 | 2422 | 33 | 0 | 44.00715262 | -95.18138802 | 2021-12-18 02:22:20 | Cottonwood, Minnesota, US | |
2021-12-17 | US | Iowa | Cass | 19029 | 2422 | 69 | 0 | 41.33149454 | -94.92792482 | 2021-12-18 02:22:20 | Cass, Iowa, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;