daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
140 rows where confirmed = 5455 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-26 | US | Arkansas | Drew | 5043 | 5455 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-12-27 04:21:07 | Drew, Arkansas, US | |
2022-12-19 | US | Virginia | Nottoway | 51135 | 5455 | 100 | 0 | 37.1435975 | -78.05065922 | 2022-12-20 04:21:04 | Nottoway, Virginia, US | |
2022-12-19 | US | Tennessee | Benton | 47005 | 5455 | 101 | 0 | 36.07110411 | -88.06849355 | 2022-12-20 04:21:04 | Benton, Tennessee, US | |
2022-12-13 | US | Alabama | Hale | 1065 | 5455 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-12-14 04:21:04 | Hale, Alabama, US | |
2022-12-12 | US | Alabama | Hale | 1065 | 5455 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-12-13 04:21:01 | Hale, Alabama, US | |
2022-12-11 | US | Alabama | Hale | 1065 | 5455 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-12-12 04:21:01 | Hale, Alabama, US | |
2022-12-10 | US | Alabama | Hale | 1065 | 5455 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-12-11 04:20:50 | Hale, Alabama, US | |
2022-12-09 | US | Alabama | Hale | 1065 | 5455 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-12-10 04:21:02 | Hale, Alabama, US | |
2022-12-08 | US | Alabama | Hale | 1065 | 5455 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-12-09 04:21:05 | Hale, Alabama, US | |
2022-12-07 | US | West Virginia | Hardy | 54031 | 5455 | 51 | 0 | 39.00683177 | -78.85855301 | 2022-12-08 04:21:07 | Hardy, West Virginia, US | |
2022-12-07 | US | Alabama | Hale | 1065 | 5455 | 109 | 0 | 32.76039258 | -87.63284988 | 2022-12-08 04:21:07 | Hale, Alabama, US | |
2022-11-23 | US | Maine | Washington | 23029 | 5455 | 64 | 0 | 45.01607142 | -67.62813524 | 2022-11-24 04:21:09 | Washington, Maine, US | |
2022-11-17 | US | Montana | Lincoln | 30053 | 5455 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-11-18 04:21:15 | Lincoln, Montana, US | |
2022-11-16 | US | Montana | Lincoln | 30053 | 5455 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-11-17 04:21:11 | Lincoln, Montana, US | |
2022-11-15 | US | Montana | Lincoln | 30053 | 5455 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-11-16 04:21:09 | Lincoln, Montana, US | |
2022-11-14 | US | Montana | Lincoln | 30053 | 5455 | 92 | 0 | 48.54265777 | -115.4046155 | 2022-11-15 04:21:16 | Lincoln, Montana, US | |
2022-11-10 | US | Puerto Rico | Comerio | 72045 | 5455 | 0 | 0 | 18.224687 | -66.221622 | 2022-11-11 04:21:22 | Comerio, Puerto Rico, US | |
2022-10-31 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-11-01 04:22:36 | Clinton, Missouri, US | |
2022-10-30 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-31 04:21:36 | Clinton, Missouri, US | |
2022-10-29 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-30 04:22:14 | Clinton, Missouri, US | |
2022-10-28 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-29 04:21:13 | Clinton, Missouri, US | |
2022-10-28 | US | Arkansas | Sharp | 5135 | 5455 | 118 | 0 | 36.16258158 | -91.47819342 | 2022-10-29 04:21:13 | Sharp, Arkansas, US | |
2022-10-27 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-28 04:22:31 | Clinton, Missouri, US | |
2022-10-27 | US | Arkansas | Sharp | 5135 | 5455 | 118 | 0 | 36.16258158 | -91.47819342 | 2022-10-28 04:22:31 | Sharp, Arkansas, US | |
2022-10-26 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-27 04:22:01 | Clinton, Missouri, US | |
2022-10-25 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-26 04:22:19 | Clinton, Missouri, US | |
2022-10-24 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-25 04:21:53 | Clinton, Missouri, US | |
2022-10-23 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-24 04:22:29 | Clinton, Missouri, US | |
2022-10-22 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-23 04:22:46 | Clinton, Missouri, US | |
2022-10-21 | US | Missouri | Clinton | 29049 | 5455 | 125 | 0 | 39.6013098 | -94.40465394 | 2022-10-22 04:22:53 | Clinton, Missouri, US | |
2022-10-17 | US | Arkansas | Phillips | 5107 | 5455 | 102 | 0 | 34.43268455 | -90.84800154 | 2022-10-18 04:22:42 | Phillips, Arkansas, US | |
2022-09-20 | US | California | Inyo | 6027 | 5455 | 59 | 0 | 36.51112084 | -117.4111978 | 2022-09-21 04:23:22 | Inyo, California, US | |
2022-09-15 | US | Puerto Rico | Sabana Grande | 72121 | 5455 | 0 | 0 | 18.08282 | -66.943758 | 2022-09-16 04:21:19 | Sabana Grande, Puerto Rico, US | |
2022-08-31 | US | Texas | Scurry | 48415 | 5455 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-09-01 04:21:03 | Scurry, Texas, US | |
2022-08-22 | US | Colorado | Elbert | 8039 | 5455 | 44 | 0 | 39.28656773 | -104.1358721 | 2022-08-23 04:20:56 | Elbert, Colorado, US | |
2022-08-21 | US | Colorado | Elbert | 8039 | 5455 | 44 | 0 | 39.28656773 | -104.1358721 | 2022-08-22 04:20:38 | Elbert, Colorado, US | |
2022-08-03 | US | Texas | Limestone | 48293 | 5455 | 125 | 0 | 31.5454767 | -96.58095444 | 2022-08-04 04:20:58 | Limestone, Texas, US | |
2022-08-03 | US | Alabama | Randolph | 1111 | 5455 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-08-04 04:20:58 | Randolph, Alabama, US | |
2022-08-02 | US | Alabama | Randolph | 1111 | 5455 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-08-03 04:20:59 | Randolph, Alabama, US | |
2022-08-01 | US | Alabama | Randolph | 1111 | 5455 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-08-02 04:20:53 | Randolph, Alabama, US | |
2022-07-31 | US | Alabama | Randolph | 1111 | 5455 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-08-01 04:21:03 | Randolph, Alabama, US | |
2022-07-30 | US | Alabama | Randolph | 1111 | 5455 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-07-31 04:21:02 | Randolph, Alabama, US | |
2022-07-29 | US | Alabama | Randolph | 1111 | 5455 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-07-30 04:20:42 | Randolph, Alabama, US | |
2022-07-26 | US | Tennessee | Johnson | 47091 | 5455 | 98 | 0 | 36.4552395 | -81.84886538 | 2022-07-27 04:21:04 | Johnson, Tennessee, US | |
2022-07-07 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-08 04:20:56 | Winston, Mississippi, US | |
2022-07-06 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-07 04:20:55 | Winston, Mississippi, US | |
2022-07-05 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-06 04:20:58 | Winston, Mississippi, US | |
2022-07-04 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-05 04:20:45 | Winston, Mississippi, US | |
2022-07-03 | US | Puerto Rico | Catano | 72033 | 5455 | 0 | 0 | 18.437269 | -66.143306 | 2022-07-04 04:20:54 | Catano, Puerto Rico, US | |
2022-07-03 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-04 04:20:54 | Winston, Mississippi, US | |
2022-07-02 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-03 04:20:59 | Winston, Mississippi, US | |
2022-07-01 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-02 04:21:16 | Winston, Mississippi, US | |
2022-06-30 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-01 04:21:10 | Winston, Mississippi, US | |
2022-06-29 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-30 04:21:01 | Winston, Mississippi, US | |
2022-06-29 | US | Kentucky | Unassigned | 90021 | 5455 | 12 | 0 | 38.97065142 | 0.0 | 2022-06-30 04:21:01 | Unassigned, Kentucky, US | |
2022-06-28 | US | Mississippi | Winston | 28159 | 5455 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-29 04:20:59 | Winston, Mississippi, US | |
2022-05-31 | US | Arkansas | Columbia | 5027 | 5455 | 97 | 0 | 33.21230701 | -93.22642793 | 2022-06-01 04:20:55 | Columbia, Arkansas, US | |
2022-05-23 | US | West Virginia | Lewis | 54041 | 5455 | 87 | 0 | 38.9947249 | -80.49988181 | 2022-05-24 04:20:57 | Lewis, West Virginia, US | |
2022-05-18 | US | Wisconsin | Iowa | 55049 | 5455 | 29 | 0 | 43.00050278 | -90.13469017 | 2022-05-19 04:20:54 | Iowa, Wisconsin, US | |
2022-03-30 | US | Vermont | Addison | 50001 | 5455 | 15 | 0 | 44.03217337 | -73.14130877 | 2022-03-31 04:20:56 | Addison, Vermont, US | |
2022-03-26 | US | Arkansas | Ouachita | 5103 | 5455 | 104 | 0 | 33.58839816 | -92.87795984 | 2022-03-27 04:20:47 | Ouachita, Arkansas, US | |
2022-03-25 | US | Arkansas | Ouachita | 5103 | 5455 | 103 | 0 | 33.58839816 | -92.87795984 | 2022-03-26 04:20:23 | Ouachita, Arkansas, US | |
2022-03-02 | US | West Virginia | McDowell | 54047 | 5455 | 63 | 0 | 37.38002939 | -81.65083669 | 2022-03-03 04:21:01 | McDowell, West Virginia, US | |
2022-02-17 | US | Georgia | Pierce | 13229 | 5455 | 118 | 0 | 31.35928155 | -82.21598442 | 2022-02-18 04:21:04 | Pierce, Georgia, US | |
2022-02-12 | US | Hawaii | Out of HI | 80015 | 5455 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-13 04:21:00 | Out of HI, Hawaii, US | |
2022-02-11 | US | Puerto Rico | Vega Alta | 72143 | 5455 | 0 | 0 | 18.409346 | -66.33725 | 2022-02-12 04:21:06 | Vega Alta, Puerto Rico, US | |
2022-02-03 | US | Mississippi | Wayne | 28153 | 5455 | 78 | 0 | 31.64135687 | -88.69573913 | 2022-02-04 04:21:10 | Wayne, Mississippi, US | |
2022-02-01 | US | Missouri | Stone | 29209 | 5455 | 105 | 0 | 36.75000327 | -93.45256475 | 2022-02-02 04:21:09 | Stone, Missouri, US | |
2022-01-26 | US | Illinois | Crawford | 17033 | 5455 | 38 | 0 | 39.0032229 | -87.75954624 | 2022-01-27 04:21:19 | Crawford, Illinois, US | |
2022-01-13 | US | Kentucky | Ohio | 21183 | 5455 | 91 | 0 | 37.47751843 | -86.85368087 | 2022-01-14 04:21:54 | Ohio, Kentucky, US | |
2022-01-06 | US | Texas | Howard | 48227 | 5455 | 153 | 0 | 32.30621324 | -101.4356444 | 2022-01-07 04:22:09 | Howard, Texas, US | |
2021-12-14 | US | West Virginia | Greenbrier | 54025 | 5455 | 113 | 0 | 37.9463652 | -80.45335881 | 2021-12-15 03:22:16 | Greenbrier, West Virginia, US | |
2021-12-14 | US | Montana | Ravalli | 30081 | 5455 | 128 | 0 | 46.08520862 | -114.11891640000002 | 2021-12-15 03:22:16 | Ravalli, Montana, US | |
2021-12-08 | US | Illinois | Logan | 17107 | 5455 | 77 | 0 | 40.12581572 | -89.36638784 | 2021-12-09 04:22:49 | Logan, Illinois, US | |
2021-11-22 | US | Georgia | Upson | 13293 | 5455 | 183 | 0 | 32.87920671 | -84.30024826 | 2021-11-23 04:22:39 | Upson, Georgia, US | |
2021-11-13 | US | West Virginia | Marshall | 54051 | 5455 | 116 | 0 | 39.86064362 | -80.66591062 | 2021-11-14 04:21:31 | Marshall, West Virginia, US | |
2021-11-10 | US | Tennessee | Scott | 47151 | 5455 | 61 | 0 | 36.42325673 | -84.50360494 | 2021-11-11 04:21:45 | Scott, Tennessee, US | |
2021-10-11 | US | Tennessee | Hardin | 47071 | 5455 | 81 | 0 | 35.19732531 | -88.18593755 | 2021-10-12 04:21:09 | Hardin, Tennessee, US | |
2021-10-07 | United Kingdom | Bermuda | 5455 | 87 | 0 | 32.3078 | -64.7505 | 2021-10-08 04:21:25 | Bermuda, United Kingdom | |||
2021-10-07 | US | Ohio | Logan | 39091 | 5455 | 96 | 0 | 40.38996525 | -83.76784341 | 2021-10-08 04:21:25 | Logan, Ohio, US | |
2021-10-06 | United Kingdom | Bermuda | 5455 | 87 | 0 | 32.3078 | -64.7505 | 2021-10-07 04:21:36 | Bermuda, United Kingdom | |||
2021-10-05 | US | Indiana | Whitley | 18183 | 5455 | 54 | 0 | 41.13863784 | -85.50791236 | 2021-10-06 04:21:33 | Whitley, Indiana, US | |
2021-09-30 | US | Indiana | Clinton | 18023 | 5455 | 67 | 0 | 40.30319754 | -86.47277257 | 2021-10-01 04:21:35 | Clinton, Indiana, US | |
2021-09-29 | US | Alabama | Chambers | 1017 | 5455 | 135 | 0 | 32.91360079 | -85.39072749 | 2021-09-30 04:21:20 | Chambers, Alabama, US | |
2021-09-28 | US | Tennessee | Carroll | 47017 | 5455 | 92 | 0 | 35.97366108 | -88.45189331 | 2021-09-29 04:21:45 | Carroll, Tennessee, US | |
2021-09-28 | US | Arkansas | Union | 5139 | 5455 | 127 | 0 | 33.16887091 | -92.59746952 | 2021-09-29 04:21:45 | Union, Arkansas, US | |
2021-09-20 | US | Missouri | Webster | 29225 | 5455 | 83 | 0 | 37.2813734 | -92.876329 | 2021-09-21 04:21:26 | Webster, Missouri, US | |
2021-08-29 | US | North Carolina | Watauga | 37189 | 5455 | 33 | 0 | 36.23103603 | -81.70033724 | 2021-08-30 04:21:23 | Watauga, North Carolina, US | |
2021-08-28 | US | North Carolina | Watauga | 37189 | 5455 | 33 | 0 | 36.23103603 | -81.70033724 | 2021-08-29 04:21:14 | Watauga, North Carolina, US | |
2021-08-27 | US | North Carolina | Watauga | 37189 | 5455 | 33 | 0 | 36.23103603 | -81.70033724 | 2021-08-28 04:21:28 | Watauga, North Carolina, US | |
2021-08-25 | US | Oregon | Klamath | 41035 | 5455 | 81 | 0 | 42.68762984 | -121.64964609999998 | 2021-08-26 04:21:28 | Klamath, Oregon, US | |
2021-08-10 | US | Georgia | Effingham | 13103 | 5455 | 77 | 0 | 32.36616021 | -81.34280942 | 2021-08-11 04:21:58 | Effingham, Georgia, US | |
2021-07-30 | US | Ohio | Darke | 39037 | 5455 | 131 | 0 | 40.13412966 | -84.6194517 | 2021-07-31 04:21:35 | Darke, Ohio, US | |
2021-07-26 | US | California | Lassen | 6035 | 5455 | 19 | 0 | 40.67311306 | -120.59350990000002 | 2021-07-27 04:21:18 | Lassen, California, US | |
2021-07-25 | US | California | Nevada | 6057 | 5455 | 72 | 0 | 39.30394768 | -120.7627281 | 2021-07-26 04:21:28 | Nevada, California, US | |
2021-07-17 | Japan | Mie | 5455 | 113 | 5316 | 26 | 34.508018 | 136.376013 | 2021-07-18 04:22:07 | Mie, Japan | ||
2021-07-15 | Saint Lucia | 5455 | 87 | 5241 | 127 | 13.9094 | -60.9789 | 2021-07-16 04:21:22 | Saint Lucia | |||
2021-07-14 | US | Ohio | Sandusky | 39143 | 5455 | 130 | 0 | 41.35624126 | -83.137872 | 2021-07-15 04:21:48 | Sandusky, Ohio, US | |
2021-07-13 | US | Ohio | Sandusky | 39143 | 5455 | 130 | 0 | 41.35624126 | -83.137872 | 2021-07-14 04:21:35 | Sandusky, Ohio, US | |
2021-07-12 | US | Ohio | Sandusky | 39143 | 5455 | 130 | 0 | 41.35624126 | -83.137872 | 2021-07-13 04:21:18 | Sandusky, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;