daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
155 rows where confirmed = 5209 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-26 | US | Illinois | Hancock | 17067 | 5209 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-27 04:21:07 | Hancock, Illinois, US | |
2022-12-25 | US | Illinois | Hancock | 17067 | 5209 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-26 04:21:06 | Hancock, Illinois, US | |
2022-12-24 | US | Illinois | Hancock | 17067 | 5209 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-25 04:21:04 | Hancock, Illinois, US | |
2022-12-23 | US | Illinois | Hancock | 17067 | 5209 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-24 04:21:02 | Hancock, Illinois, US | |
2022-12-09 | US | Puerto Rico | Jayuya | 72073 | 5209 | 0 | 0 | 18.211446 | -66.58878 | 2022-12-10 04:21:02 | Jayuya, Puerto Rico, US | |
2022-12-08 | US | Puerto Rico | Patillas | 72109 | 5209 | 0 | 0 | 18.03174 | -66.012242 | 2022-12-09 04:21:05 | Patillas, Puerto Rico, US | |
2022-11-03 | China | Fujian | 5209 | 1 | 0 | 26.0789 | 117.9874 | 2022-11-04 04:22:11 | Fujian, China | |||
2022-09-24 | US | Tennessee | Benton | 47005 | 5209 | 99 | 0 | 36.07110411 | -88.06849355 | 2022-09-25 04:23:31 | Benton, Tennessee, US | |
2022-09-23 | US | Tennessee | Benton | 47005 | 5209 | 99 | 0 | 36.07110411 | -88.06849355 | 2022-09-24 04:21:40 | Benton, Tennessee, US | |
2022-09-13 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-14 04:20:44 | Calhoun, Mississippi, US | |
2022-09-12 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-13 04:20:57 | Calhoun, Mississippi, US | |
2022-09-11 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-12 04:20:58 | Calhoun, Mississippi, US | |
2022-09-10 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-11 04:20:50 | Calhoun, Mississippi, US | |
2022-09-09 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-10 04:21:10 | Calhoun, Mississippi, US | |
2022-09-08 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-09 04:21:11 | Calhoun, Mississippi, US | |
2022-09-07 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-08 04:21:02 | Calhoun, Mississippi, US | |
2022-09-06 | US | Mississippi | Calhoun | 28013 | 5209 | 74 | 0 | 33.93683395 | -89.33686647 | 2022-09-07 04:20:59 | Calhoun, Mississippi, US | |
2022-09-05 | US | Arkansas | Lincoln | 5079 | 5209 | 69 | 0 | 33.95317155 | -91.74002806 | 2022-09-06 04:21:02 | Lincoln, Arkansas, US | |
2022-08-28 | US | Arkansas | Hempstead | 5057 | 5209 | 73 | 0 | 33.73325583 | -93.66935133 | 2022-08-29 04:21:06 | Hempstead, Arkansas, US | |
2022-08-07 | US | Virginia | Buchanan | 51027 | 5209 | 128 | 0 | 37.26818323 | -82.03749726 | 2022-08-08 04:21:08 | Buchanan, Virginia, US | |
2022-08-07 | US | Kentucky | Powell | 21197 | 5209 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-08-08 04:21:08 | Powell, Kentucky, US | |
2022-08-07 | US | Kentucky | Garrard | 21079 | 5209 | 83 | 0 | 37.6388668 | -84.53289319 | 2022-08-08 04:21:08 | Garrard, Kentucky, US | |
2022-08-06 | US | Virginia | Buchanan | 51027 | 5209 | 128 | 0 | 37.26818323 | -82.03749726 | 2022-08-07 04:20:54 | Buchanan, Virginia, US | |
2022-08-06 | US | Kentucky | Powell | 21197 | 5209 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-08-07 04:20:54 | Powell, Kentucky, US | |
2022-08-06 | US | Kentucky | Garrard | 21079 | 5209 | 83 | 0 | 37.6388668 | -84.53289319 | 2022-08-07 04:20:54 | Garrard, Kentucky, US | |
2022-08-05 | US | Virginia | Buchanan | 51027 | 5209 | 128 | 0 | 37.26818323 | -82.03749726 | 2022-08-06 04:20:56 | Buchanan, Virginia, US | |
2022-08-05 | US | Kentucky | Powell | 21197 | 5209 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-08-06 04:20:56 | Powell, Kentucky, US | |
2022-08-05 | US | Kentucky | Garrard | 21079 | 5209 | 83 | 0 | 37.6388668 | -84.53289319 | 2022-08-06 04:20:56 | Garrard, Kentucky, US | |
2022-08-04 | US | Kentucky | Powell | 21197 | 5209 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-08-05 04:20:52 | Powell, Kentucky, US | |
2022-08-04 | US | Kentucky | Garrard | 21079 | 5209 | 83 | 0 | 37.6388668 | -84.53289319 | 2022-08-05 04:20:52 | Garrard, Kentucky, US | |
2022-08-03 | US | Kentucky | Powell | 21197 | 5209 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-08-04 04:20:58 | Powell, Kentucky, US | |
2022-08-03 | US | Kentucky | Garrard | 21079 | 5209 | 83 | 0 | 37.6388668 | -84.53289319 | 2022-08-04 04:20:58 | Garrard, Kentucky, US | |
2022-08-02 | US | Kentucky | Powell | 21197 | 5209 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-08-03 04:20:59 | Powell, Kentucky, US | |
2022-08-02 | US | Kentucky | Garrard | 21079 | 5209 | 83 | 0 | 37.6388668 | -84.53289319 | 2022-08-03 04:20:59 | Garrard, Kentucky, US | |
2022-08-01 | US | Kentucky | Powell | 21197 | 5209 | 45 | 0 | 37.83218794 | -83.82553961 | 2022-08-02 04:20:53 | Powell, Kentucky, US | |
2022-08-01 | US | Kentucky | Garrard | 21079 | 5209 | 83 | 0 | 37.6388668 | -84.53289319 | 2022-08-02 04:20:53 | Garrard, Kentucky, US | |
2022-07-26 | US | Virginia | New Kent | 51127 | 5209 | 34 | 0 | 37.50694406 | -76.99828634 | 2022-07-27 04:21:04 | New Kent, Virginia, US | |
2022-07-24 | US | Tennessee | Humphreys | 47085 | 5209 | 77 | 0 | 36.03958805 | -87.77992872 | 2022-07-25 04:20:51 | Humphreys, Tennessee, US | |
2022-07-21 | US | West Virginia | Barbour | 54001 | 5209 | 74 | 0 | 39.1307219 | -80.00350858 | 2022-07-22 04:21:15 | Barbour, West Virginia, US | |
2022-06-23 | US | Louisiana | Concordia | 22029 | 5209 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-06-24 04:20:58 | Concordia, Louisiana, US | |
2022-06-20 | US | Texas | Limestone | 48293 | 5209 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-06-21 04:20:56 | Limestone, Texas, US | |
2022-06-19 | US | Texas | Limestone | 48293 | 5209 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-06-20 04:21:01 | Limestone, Texas, US | |
2022-06-06 | US | Illinois | Richland | 17159 | 5209 | 74 | 0 | 38.71240969 | -88.08475366 | 2022-06-07 04:21:08 | Richland, Illinois, US | |
2022-06-02 | US | Virginia | Prince Edward | 51147 | 5209 | 75 | 0 | 37.22554789 | -78.43597949 | 2022-06-03 04:20:58 | Prince Edward, Virginia, US | |
2022-05-20 | US | Tennessee | Johnson | 47091 | 5209 | 95 | 0 | 36.4552395 | -81.84886538 | 2022-05-21 04:20:58 | Johnson, Tennessee, US | |
2022-05-16 | US | Illinois | Edgar | 17045 | 5209 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-05-17 04:20:59 | Edgar, Illinois, US | |
2022-05-15 | US | Illinois | Edgar | 17045 | 5209 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-05-16 04:20:47 | Edgar, Illinois, US | |
2022-05-14 | US | Illinois | Edgar | 17045 | 5209 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-05-15 04:20:53 | Edgar, Illinois, US | |
2022-05-13 | US | Illinois | Edgar | 17045 | 5209 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-05-14 04:20:48 | Edgar, Illinois, US | |
2022-05-03 | US | Arizona | La Paz | 4012 | 5209 | 144 | 0 | 33.72854224 | -113.9810029 | 2022-05-04 04:20:59 | La Paz, Arizona, US | |
2022-05-02 | US | Arizona | La Paz | 4012 | 5209 | 144 | 0 | 33.72854224 | -113.9810029 | 2022-05-03 04:21:00 | La Paz, Arizona, US | |
2022-05-01 | US | Arizona | La Paz | 4012 | 5209 | 144 | 0 | 33.72854224 | -113.9810029 | 2022-05-02 04:21:10 | La Paz, Arizona, US | |
2022-04-30 | US | Arizona | La Paz | 4012 | 5209 | 144 | 0 | 33.72854224 | -113.9810029 | 2022-05-01 04:20:57 | La Paz, Arizona, US | |
2022-04-29 | US | Arizona | La Paz | 4012 | 5209 | 144 | 0 | 33.72854224 | -113.9810029 | 2022-04-30 04:21:05 | La Paz, Arizona, US | |
2022-04-28 | US | Arizona | La Paz | 4012 | 5209 | 144 | 0 | 33.72854224 | -113.9810029 | 2022-04-29 04:20:59 | La Paz, Arizona, US | |
2022-04-27 | US | Arizona | La Paz | 4012 | 5209 | 144 | 0 | 33.72854224 | -113.9810029 | 2022-04-28 04:20:47 | La Paz, Arizona, US | |
2022-04-03 | US | Wisconsin | Vilas | 55125 | 5209 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-04-04 04:20:51 | Vilas, Wisconsin, US | |
2022-04-02 | US | Wisconsin | Vilas | 55125 | 5209 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-04-03 04:20:48 | Vilas, Wisconsin, US | |
2022-04-01 | US | Wisconsin | Vilas | 55125 | 5209 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-04-02 04:20:47 | Vilas, Wisconsin, US | |
2022-03-31 | US | Wisconsin | Vilas | 55125 | 5209 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-04-01 04:20:28 | Vilas, Wisconsin, US | |
2022-03-30 | US | Wisconsin | Vilas | 55125 | 5209 | 89 | 0 | 46.05467334 | -89.51719204 | 2022-03-31 04:20:56 | Vilas, Wisconsin, US | |
2022-03-27 | US | New Mexico | Lincoln | 35027 | 5209 | 65 | 0 | 33.74526079 | -105.4586166 | 2022-03-28 04:20:33 | Lincoln, New Mexico, US | |
2022-03-26 | US | New Mexico | Lincoln | 35027 | 5209 | 65 | 0 | 33.74526079 | -105.4586166 | 2022-03-27 04:20:47 | Lincoln, New Mexico, US | |
2022-03-25 | US | New Mexico | Lincoln | 35027 | 5209 | 65 | 0 | 33.74526079 | -105.4586166 | 2022-03-26 04:20:23 | Lincoln, New Mexico, US | |
2022-03-16 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-17 04:20:56 | Spencer, Indiana, US | |
2022-03-15 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-16 04:20:50 | Spencer, Indiana, US | |
2022-03-14 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-15 04:20:47 | Spencer, Indiana, US | |
2022-03-13 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-14 04:20:46 | Spencer, Indiana, US | |
2022-03-12 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-13 04:20:49 | Spencer, Indiana, US | |
2022-03-11 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-12 04:20:50 | Spencer, Indiana, US | |
2022-03-10 | US | North Carolina | Caswell | 37033 | 5209 | 44 | 0 | 36.39312665 | -79.33353281 | 2022-03-11 04:20:50 | Caswell, North Carolina, US | |
2022-03-10 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-11 04:20:50 | Spencer, Indiana, US | |
2022-03-09 | US | Indiana | Spencer | 18147 | 5209 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-10 04:20:48 | Spencer, Indiana, US | |
2022-03-06 | US | Virginia | Dinwiddie | 51053 | 5209 | 83 | 0 | 37.07544585 | -77.63451754 | 2022-03-07 04:20:47 | Dinwiddie, Virginia, US | |
2022-03-05 | US | Virginia | Dinwiddie | 51053 | 5209 | 83 | 0 | 37.07544585 | -77.63451754 | 2022-03-06 04:20:49 | Dinwiddie, Virginia, US | |
2022-03-04 | US | Virginia | Dinwiddie | 51053 | 5209 | 83 | 0 | 37.07544585 | -77.63451754 | 2022-03-05 04:21:10 | Dinwiddie, Virginia, US | |
2022-03-01 | US | Puerto Rico | Cidra | 72041 | 5209 | 0 | 0 | 18.173559 | -66.161179 | 2022-03-02 04:21:07 | Cidra, Puerto Rico, US | |
2022-02-28 | US | West Virginia | Lewis | 54041 | 5209 | 78 | 0 | 38.9947249 | -80.49988181 | 2022-03-01 04:21:09 | Lewis, West Virginia, US | |
2022-02-28 | US | Puerto Rico | Cidra | 72041 | 5209 | 0 | 0 | 18.173559 | -66.161179 | 2022-03-01 04:21:09 | Cidra, Puerto Rico, US | |
2022-02-15 | US | Ohio | Carroll | 39019 | 5209 | 126 | 0 | 40.578968599999996 | -81.09178213 | 2022-02-16 04:21:10 | Carroll, Ohio, US | |
2022-02-11 | US | Texas | Moore | 48341 | 5209 | 104 | 0 | 35.83769242 | -101.8930281 | 2022-02-12 04:21:06 | Moore, Texas, US | |
2022-02-07 | US | Minnesota | Wabasha | 27157 | 5209 | 15 | 0 | 44.28424356 | -92.23121312 | 2022-02-08 04:21:15 | Wabasha, Minnesota, US | |
2022-02-03 | US | Minnesota | Waseca | 27161 | 5209 | 38 | 0 | 44.02211116 | -93.58720034 | 2022-02-04 04:21:10 | Waseca, Minnesota, US | |
2022-02-02 | US | Missouri | Crawford | 29055 | 5209 | 91 | 0 | 37.97663738 | -91.30528104 | 2022-02-03 04:21:21 | Crawford, Missouri, US | |
2022-01-27 | US | West Virginia | Hampshire | 54027 | 5209 | 62 | 0 | 39.32103553 | -78.60826476 | 2022-01-28 04:21:09 | Hampshire, West Virginia, US | |
2022-01-26 | US | Maryland | Garrett | 24023 | 5209 | 106 | 0 | 39.52786077 | -79.27355126 | 2022-01-27 04:21:19 | Garrett, Maryland, US | |
2022-01-26 | US | Kentucky | Russell | 21207 | 5209 | 73 | 0 | 36.99308373 | -85.06070117 | 2022-01-27 04:21:19 | Russell, Kentucky, US | |
2022-01-25 | US | Kentucky | Anderson | 21005 | 5209 | 59 | 0 | 38.00671029 | -84.99171713 | 2022-01-26 04:21:07 | Anderson, Kentucky, US | |
2022-01-06 | US | Ohio | Van Wert | 39161 | 5209 | 126 | 0 | 40.8554138 | -84.59111700000003 | 2022-01-07 04:22:09 | Van Wert, Ohio, US | |
2021-12-04 | US | Puerto Rico | Toa Baja | 72137 | 5209 | 0 | 0 | 18.431445999999998 | -66.213553 | 2021-12-05 04:22:25 | Toa Baja, Puerto Rico, US | |
2021-11-29 | US | Texas | Howard | 48227 | 5209 | 143 | 0 | 32.30621324 | -101.4356444 | 2021-11-30 04:22:53 | Howard, Texas, US | |
2021-11-17 | US | Missouri | Polk | 29167 | 5209 | 50 | 0 | 37.616229600000004 | -93.39828174 | 2021-11-18 04:21:33 | Polk, Missouri, US | |
2021-11-15 | US | Virginia | Prince George | 51149 | 5209 | 48 | 0 | 37.18497668 | -77.22922187 | 2021-11-16 04:21:10 | Prince George, Virginia, US | |
2021-11-04 | US | Virginia | Petersburg | 51730 | 5209 | 108 | 0 | 37.20530399 | -77.39368102 | 2021-11-05 04:21:54 | Petersburg, Virginia, US | |
2021-11-04 | US | Missouri | Lawrence | 29109 | 5209 | 107 | 0 | 37.10626634 | -93.83293097 | 2021-11-05 04:21:54 | Lawrence, Missouri, US | |
2021-10-26 | US | New York | Tioga | 36107 | 5209 | 72 | 0 | 42.16852837 | -76.30835812 | 2021-10-27 04:22:32 | Tioga, New York, US | |
2021-10-26 | US | Kentucky | Clark | 21049 | 5209 | 39 | 0 | 37.9689263 | -84.14615986 | 2021-10-27 04:22:32 | Clark, Kentucky, US | |
2021-10-09 | US | Missouri | Laclede | 29105 | 5209 | 126 | 0 | 37.65896829 | -92.5888493 | 2021-10-10 04:21:38 | Laclede, Missouri, US | |
2021-09-30 | US | Kansas | Lyon | 20111 | 5209 | 91 | 0 | 38.45576156 | -96.15275715 | 2021-10-01 04:21:35 | Lyon, Kansas, US | |
2021-09-29 | US | Kansas | Lyon | 20111 | 5209 | 91 | 0 | 38.45576156 | -96.15275715 | 2021-09-30 04:21:20 | Lyon, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;