daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
141 rows where confirmed = 5459 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-18 | US | Illinois | Johnson | 17087 | 5459 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-19 04:21:03 | Johnson, Illinois, US | |
2022-12-17 | US | Illinois | Johnson | 17087 | 5459 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-18 04:21:03 | Johnson, Illinois, US | |
2022-12-16 | US | Illinois | Johnson | 17087 | 5459 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-12-17 04:21:04 | Johnson, Illinois, US | |
2022-12-14 | US | Puerto Rico | Guayanilla | 72059 | 5459 | 0 | 0 | 18.039942 | -66.79186 | 2022-12-15 04:20:58 | Guayanilla, Puerto Rico, US | |
2022-12-14 | US | Arkansas | Hempstead | 5057 | 5459 | 79 | 0 | 33.73325583 | -93.66935133 | 2022-12-15 04:20:58 | Hempstead, Arkansas, US | |
2022-11-15 | US | Tennessee | Polk | 47139 | 5459 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-16 04:21:09 | Polk, Tennessee, US | |
2022-11-14 | US | Tennessee | Polk | 47139 | 5459 | 89 | 0 | 35.12245443 | -84.52075859 | 2022-11-15 04:21:16 | Polk, Tennessee, US | |
2022-10-31 | US | Arkansas | Sharp | 5135 | 5459 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-11-01 04:22:36 | Sharp, Arkansas, US | |
2022-10-30 | US | Arkansas | Sharp | 5135 | 5459 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-10-31 04:21:36 | Sharp, Arkansas, US | |
2022-10-29 | US | Arkansas | Sharp | 5135 | 5459 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-10-30 04:22:14 | Sharp, Arkansas, US | |
2022-10-18 | US | Texas | Deaf Smith | 48117 | 5459 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-10-19 04:22:26 | Deaf Smith, Texas, US | |
2022-10-17 | US | Texas | Deaf Smith | 48117 | 5459 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-10-18 04:22:42 | Deaf Smith, Texas, US | |
2022-10-16 | US | Texas | Deaf Smith | 48117 | 5459 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-10-17 04:20:31 | Deaf Smith, Texas, US | |
2022-10-16 | US | Colorado | Alamosa | 8003 | 5459 | 63 | 0 | 37.57250606 | -105.7885451 | 2022-10-17 04:20:31 | Alamosa, Colorado, US | |
2022-10-15 | US | Texas | Deaf Smith | 48117 | 5459 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-10-16 04:22:39 | Deaf Smith, Texas, US | |
2022-10-15 | US | Colorado | Alamosa | 8003 | 5459 | 63 | 0 | 37.57250606 | -105.7885451 | 2022-10-16 04:22:39 | Alamosa, Colorado, US | |
2022-10-14 | US | Texas | Deaf Smith | 48117 | 5459 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-10-15 04:22:00 | Deaf Smith, Texas, US | |
2022-10-14 | US | Colorado | Alamosa | 8003 | 5459 | 63 | 0 | 37.57250606 | -105.7885451 | 2022-10-15 04:22:00 | Alamosa, Colorado, US | |
2022-10-12 | US | Colorado | Chaffee | 8015 | 5459 | 56 | 0 | 38.74745778 | -106.1926573 | 2022-10-13 04:22:39 | Chaffee, Colorado, US | |
2022-10-11 | US | Colorado | Chaffee | 8015 | 5459 | 56 | 0 | 38.74745778 | -106.1926573 | 2022-10-12 04:22:51 | Chaffee, Colorado, US | |
2022-09-20 | US | Georgia | Cook | 13075 | 5459 | 78 | 0 | 31.16068491 | -83.42947229 | 2022-09-21 04:23:22 | Cook, Georgia, US | |
2022-09-19 | US | Georgia | Cook | 13075 | 5459 | 78 | 0 | 31.16068491 | -83.42947229 | 2022-09-20 04:22:48 | Cook, Georgia, US | |
2022-09-18 | US | Georgia | Cook | 13075 | 5459 | 78 | 0 | 31.16068491 | -83.42947229 | 2022-09-19 04:21:49 | Cook, Georgia, US | |
2022-09-17 | US | Georgia | Cook | 13075 | 5459 | 78 | 0 | 31.16068491 | -83.42947229 | 2022-09-18 04:22:50 | Cook, Georgia, US | |
2022-09-16 | US | Georgia | Cook | 13075 | 5459 | 78 | 0 | 31.16068491 | -83.42947229 | 2022-09-17 04:20:19 | Cook, Georgia, US | |
2022-09-15 | US | Georgia | Cook | 13075 | 5459 | 78 | 0 | 31.16068491 | -83.42947229 | 2022-09-16 04:21:19 | Cook, Georgia, US | |
2022-09-14 | US | Georgia | Cook | 13075 | 5459 | 78 | 0 | 31.16068491 | -83.42947229 | 2022-09-15 04:21:02 | Cook, Georgia, US | |
2022-08-24 | US | Colorado | Elbert | 8039 | 5459 | 44 | 0 | 39.28656773 | -104.1358721 | 2022-08-25 04:21:13 | Elbert, Colorado, US | |
2022-08-07 | US | Texas | Limestone | 48293 | 5459 | 125 | 0 | 31.5454767 | -96.58095444 | 2022-08-08 04:21:08 | Limestone, Texas, US | |
2022-08-06 | US | Texas | Limestone | 48293 | 5459 | 125 | 0 | 31.5454767 | -96.58095444 | 2022-08-07 04:20:54 | Limestone, Texas, US | |
2022-08-05 | US | Texas | Limestone | 48293 | 5459 | 125 | 0 | 31.5454767 | -96.58095444 | 2022-08-06 04:20:56 | Limestone, Texas, US | |
2022-07-27 | US | Tennessee | Johnson | 47091 | 5459 | 98 | 0 | 36.4552395 | -81.84886538 | 2022-07-28 04:20:56 | Johnson, Tennessee, US | |
2022-07-19 | US | Indiana | Spencer | 18147 | 5459 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-07-20 04:20:59 | Spencer, Indiana, US | |
2022-07-10 | US | Puerto Rico | Salinas | 72123 | 5459 | 0 | 0 | 18.010387 | -66.256592 | 2022-07-11 04:20:46 | Salinas, Puerto Rico, US | |
2022-07-06 | US | Maryland | Somerset | 24039 | 5459 | 76 | 0 | 38.1163542 | -75.75118623 | 2022-07-07 04:20:55 | Somerset, Maryland, US | |
2022-06-29 | US | Puerto Rico | Villalba | 72149 | 5459 | 0 | 0 | 18.127951 | -66.473115 | 2022-06-30 04:21:01 | Villalba, Puerto Rico, US | |
2022-06-27 | US | Wisconsin | Green Lake | 55047 | 5459 | 64 | 0 | 43.80025981 | -89.04679553 | 2022-06-28 04:20:58 | Green Lake, Wisconsin, US | |
2022-06-20 | US | Virginia | King George | 51099 | 5459 | 39 | 0 | 38.26818502 | -77.15852768 | 2022-06-21 04:20:56 | King George, Virginia, US | |
2022-06-14 | US | Georgia | Haralson | 13143 | 5459 | 176 | 0 | 33.79602175 | -85.21005667 | 2022-06-15 04:20:54 | Haralson, Georgia, US | |
2022-06-13 | US | Georgia | Haralson | 13143 | 5459 | 176 | 0 | 33.79602175 | -85.21005667 | 2022-06-14 04:20:52 | Haralson, Georgia, US | |
2022-06-12 | US | Georgia | Haralson | 13143 | 5459 | 176 | 0 | 33.79602175 | -85.21005667 | 2022-06-13 04:21:14 | Haralson, Georgia, US | |
2022-06-11 | US | Georgia | Haralson | 13143 | 5459 | 176 | 0 | 33.79602175 | -85.21005667 | 2022-06-12 04:20:53 | Haralson, Georgia, US | |
2022-06-10 | US | Georgia | Haralson | 13143 | 5459 | 176 | 0 | 33.79602175 | -85.21005667 | 2022-06-11 04:21:01 | Haralson, Georgia, US | |
2022-06-09 | US | Georgia | Haralson | 13143 | 5459 | 176 | 0 | 33.79602175 | -85.21005667 | 2022-06-10 04:20:55 | Haralson, Georgia, US | |
2022-06-08 | US | Georgia | Haralson | 13143 | 5459 | 176 | 0 | 33.79602175 | -85.21005667 | 2022-06-09 04:20:54 | Haralson, Georgia, US | |
2022-05-26 | US | Missouri | McDonald | 29119 | 5459 | 73 | 0 | 36.62869595 | -94.34867205 | 2022-05-27 04:20:56 | McDonald, Missouri, US | |
2022-05-25 | US | Missouri | McDonald | 29119 | 5459 | 73 | 0 | 36.62869595 | -94.34867205 | 2022-05-26 04:20:50 | McDonald, Missouri, US | |
2022-05-25 | US | Illinois | Union | 17181 | 5459 | 65 | 0 | 37.47119609 | -89.25548938 | 2022-05-26 04:20:50 | Union, Illinois, US | |
2022-05-24 | US | Missouri | McDonald | 29119 | 5459 | 73 | 0 | 36.62869595 | -94.34867205 | 2022-05-25 04:20:56 | McDonald, Missouri, US | |
2022-05-23 | US | Missouri | McDonald | 29119 | 5459 | 73 | 0 | 36.62869595 | -94.34867205 | 2022-05-24 04:20:57 | McDonald, Missouri, US | |
2022-05-22 | US | Missouri | McDonald | 29119 | 5459 | 73 | 0 | 36.62869595 | -94.34867205 | 2022-05-26 04:20:50 | McDonald, Missouri, US | |
2022-05-22 | US | Illinois | Union | 17181 | 5459 | 65 | 0 | 37.47119609 | -89.25548938 | 2022-05-26 04:20:50 | Union, Illinois, US | |
2022-05-21 | US | Missouri | McDonald | 29119 | 5459 | 73 | 0 | 36.62869595 | -94.34867205 | 2022-05-22 04:20:52 | McDonald, Missouri, US | |
2022-05-20 | US | Missouri | McDonald | 29119 | 5459 | 73 | 0 | 36.62869595 | -94.34867205 | 2022-05-21 04:20:58 | McDonald, Missouri, US | |
2022-05-18 | US | Tennessee | Union | 47173 | 5459 | 75 | 0 | 36.28590426 | -83.83651902 | 2022-05-19 04:20:54 | Union, Tennessee, US | |
2022-04-07 | US | Puerto Rico | Manati | 72091 | 5459 | 0 | 0 | 18.420473 | -66.490461 | 2022-04-08 04:20:48 | Manati, Puerto Rico, US | |
2022-03-24 | Russia | Chukotka Autonomous Okrug | 5459 | 41 | 0 | 66.0006475 | 169.4900869 | 2022-03-25 04:20:46 | Chukotka Autonomous Okrug, Russia | |||
2022-02-17 | US | Maryland | Talbot | 24041 | 5459 | 80 | 0 | 38.76618159 | -76.10882561 | 2022-02-18 04:21:04 | Talbot, Maryland, US | |
2022-02-12 | US | Puerto Rico | Vega Alta | 72143 | 5459 | 0 | 0 | 18.409346 | -66.33725 | 2022-02-13 04:21:00 | Vega Alta, Puerto Rico, US | |
2022-02-02 | US | Wisconsin | Jackson | 55053 | 5459 | 40 | 0 | 44.31864893 | -90.80566792 | 2022-02-03 04:21:21 | Jackson, Wisconsin, US | |
2022-01-25 | US | Missouri | Nodaway | 29147 | 5459 | 41 | 0 | 40.36079813 | -94.88133008 | 2022-01-26 04:21:07 | Nodaway, Missouri, US | |
2022-01-24 | US | North Carolina | Transylvania | 37175 | 5459 | 56 | 0 | 35.20383864 | -82.79638423 | 2022-01-25 04:21:05 | Transylvania, North Carolina, US | |
2022-01-22 | US | Tennessee | Haywood | 47075 | 5459 | 83 | 0 | 35.58332824 | -89.28536625 | 2022-01-23 04:21:13 | Haywood, Tennessee, US | |
2022-01-20 | US | Virginia | Carroll | 51035 | 5459 | 114 | 0 | 36.73066666 | -80.73455942 | 2022-01-21 04:21:09 | Carroll, Virginia, US | |
2022-01-18 | US | Oklahoma | Adair | 40001 | 5459 | 64 | 0 | 35.88494195 | -94.65859267 | 2022-01-19 04:21:23 | Adair, Oklahoma, US | |
2022-01-17 | US | Oklahoma | Adair | 40001 | 5459 | 64 | 0 | 35.88494195 | -94.65859267 | 2022-01-18 04:21:04 | Adair, Oklahoma, US | |
2022-01-16 | US | Texas | Kleberg | 48273 | 5459 | 133 | 0 | 27.42435506 | -97.69894948 | 2022-01-17 04:21:08 | Kleberg, Texas, US | |
2022-01-16 | US | Oklahoma | Adair | 40001 | 5459 | 64 | 0 | 35.88494195 | -94.65859267 | 2022-01-17 04:21:08 | Adair, Oklahoma, US | |
2022-01-15 | US | Oklahoma | Adair | 40001 | 5459 | 64 | 0 | 35.88494195 | -94.65859267 | 2022-01-16 04:21:12 | Adair, Oklahoma, US | |
2022-01-14 | US | Oklahoma | Adair | 40001 | 5459 | 64 | 0 | 35.88494195 | -94.65859267 | 2022-01-15 04:21:07 | Adair, Oklahoma, US | |
2022-01-13 | US | Oklahoma | Adair | 40001 | 5459 | 64 | 0 | 35.88494195 | -94.65859267 | 2022-01-14 04:21:54 | Adair, Oklahoma, US | |
2022-01-12 | US | Oklahoma | Adair | 40001 | 5459 | 64 | 0 | 35.88494195 | -94.65859267 | 2022-01-13 08:00:09 | Adair, Oklahoma, US | |
2021-12-27 | US | Virginia | Petersburg | 51730 | 5459 | 109 | 0 | 37.20530399 | -77.39368102 | 2021-12-28 04:21:47 | Petersburg, Virginia, US | |
2021-12-17 | United Kingdom | Guernsey | 5459 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-12-18 02:22:20 | Guernsey, United Kingdom | ||
2021-12-15 | US | Montana | Ravalli | 30081 | 5459 | 128 | 0 | 46.08520862 | -114.11891640000002 | 2021-12-16 04:22:11 | Ravalli, Montana, US | |
2021-11-30 | US | Vermont | Rutland | 50021 | 5459 | 31 | 0 | 43.57723578 | -73.03741676 | 2021-12-01 04:22:29 | Rutland, Vermont, US | |
2021-11-21 | US | North Carolina | Pasquotank | 37139 | 5459 | 107 | 0 | 36.26723798 | -76.25134778 | 2021-11-22 04:22:20 | Pasquotank, North Carolina, US | |
2021-11-20 | US | North Carolina | Pasquotank | 37139 | 5459 | 107 | 0 | 36.26723798 | -76.25134778 | 2021-11-21 04:22:13 | Pasquotank, North Carolina, US | |
2021-11-19 | US | North Carolina | Pasquotank | 37139 | 5459 | 107 | 0 | 36.26723798 | -76.25134778 | 2021-11-20 04:22:17 | Pasquotank, North Carolina, US | |
2021-11-09 | US | Kentucky | Boyle | 21021 | 5459 | 81 | 0 | 37.62680923 | -84.8633779 | 2021-11-10 04:21:38 | Boyle, Kentucky, US | |
2021-10-25 | US | Tennessee | Macon | 47111 | 5459 | 93 | 0 | 36.53157855 | -86.00778595 | 2021-10-26 04:22:09 | Macon, Tennessee, US | |
2021-10-05 | US | Iowa | Jasper | 19099 | 5459 | 76 | 0 | 41.68576082 | -93.05567785 | 2021-10-06 04:21:33 | Jasper, Iowa, US | |
2021-10-04 | US | Iowa | Jasper | 19099 | 5459 | 76 | 0 | 41.68576082 | -93.05567785 | 2021-10-05 04:21:27 | Jasper, Iowa, US | |
2021-10-03 | US | New Hampshire | Belknap | 33001 | 5459 | 116 | 0 | 43.51637314 | -71.41684235 | 2021-10-04 04:21:31 | Belknap, New Hampshire, US | |
2021-10-03 | US | Iowa | Jasper | 19099 | 5459 | 76 | 0 | 41.68576082 | -93.05567785 | 2021-10-04 04:21:31 | Jasper, Iowa, US | |
2021-10-02 | US | New Hampshire | Belknap | 33001 | 5459 | 116 | 0 | 43.51637314 | -71.41684235 | 2021-10-03 04:21:24 | Belknap, New Hampshire, US | |
2021-10-02 | US | Iowa | Jasper | 19099 | 5459 | 76 | 0 | 41.68576082 | -93.05567785 | 2021-10-03 04:21:24 | Jasper, Iowa, US | |
2021-10-01 | US | New Hampshire | Belknap | 33001 | 5459 | 116 | 0 | 43.51637314 | -71.41684235 | 2021-10-02 04:21:25 | Belknap, New Hampshire, US | |
2021-10-01 | US | Iowa | Jasper | 19099 | 5459 | 76 | 0 | 41.68576082 | -93.05567785 | 2021-10-02 04:21:25 | Jasper, Iowa, US | |
2021-09-30 | US | Iowa | Jasper | 19099 | 5459 | 76 | 0 | 41.68576082 | -93.05567785 | 2021-10-01 04:21:35 | Jasper, Iowa, US | |
2021-09-29 | US | Iowa | Jasper | 19099 | 5459 | 76 | 0 | 41.68576082 | -93.05567785 | 2021-09-30 04:21:20 | Jasper, Iowa, US | |
2021-09-22 | US | Missouri | Howell | 29091 | 5459 | 67 | 0 | 36.77383887 | -91.88683935 | 2021-09-23 04:21:43 | Howell, Missouri, US | |
2021-09-09 | US | South Carolina | Chester | 45023 | 5459 | 91 | 0 | 34.69249168 | -81.1583216 | 2021-09-10 04:21:20 | Chester, South Carolina, US | |
2021-09-09 | US | Illinois | Livingston | 17105 | 5459 | 94 | 0 | 40.89188292 | -88.55784752 | 2021-09-10 04:21:20 | Livingston, Illinois, US | |
2021-09-03 | US | Ohio | Auglaize | 39011 | 5459 | 88 | 0 | 40.55998859 | -84.22421429999999 | 2021-09-04 04:21:28 | Auglaize, Ohio, US | |
2021-08-23 | US | Utah | TriCounty | 5459 | 44 | 0 | 40.12491499 | -109.5174415 | 2021-08-24 04:21:19 | TriCounty, Utah, US | ||
2021-08-23 | US | Mississippi | Bolivar | 28011 | 5459 | 139 | 0 | 33.79696941 | -90.87372121 | 2021-08-24 04:21:19 | Bolivar, Mississippi, US | |
2021-08-21 | Liberia | 5459 | 148 | 0 | 6.4280550000000005 | -9.429499 | 2021-08-22 04:21:29 | Liberia | ||||
2021-08-19 | US | Virginia | Washington | 51191 | 5459 | 115 | 0 | 36.72341572 | -81.95666289 | 2021-08-20 04:21:33 | Washington, Virginia, US | |
2021-08-12 | US | Ohio | Seneca | 39147 | 5459 | 134 | 0 | 41.12351311 | -83.12783209 | 2021-08-13 04:21:24 | Seneca, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;