daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where confirmed = 5692 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 146
- Malaysia 2
- Saint Vincent and the Grenadines 2
- United Kingdom 2
- Chile 1
- Colombia 1
- Djibouti 1
- Japan 1
- Mexico 1
- New Zealand 1
- Russia 1
- Trinidad and Tobago 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Georgia | Berrien | 13019 | 5692 | 95 | 0 | 31.27590016 | -83.2252992 | 2022-12-30 04:21:04 | Berrien, Georgia, US | |
2022-12-28 | US | Georgia | Berrien | 13019 | 5692 | 95 | 0 | 31.27590016 | -83.2252992 | 2022-12-29 04:21:01 | Berrien, Georgia, US | |
2022-12-26 | US | Alaska | Northwest Arctic | 2188 | 5692 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-27 04:21:07 | Northwest Arctic, Alaska, US | |
2022-12-25 | US | Alaska | Northwest Arctic | 2188 | 5692 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-26 04:21:06 | Northwest Arctic, Alaska, US | |
2022-12-24 | US | Alaska | Northwest Arctic | 2188 | 5692 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-25 04:21:04 | Northwest Arctic, Alaska, US | |
2022-12-23 | US | Alaska | Northwest Arctic | 2188 | 5692 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-24 04:21:02 | Northwest Arctic, Alaska, US | |
2022-12-22 | US | Alaska | Northwest Arctic | 2188 | 5692 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-23 04:21:04 | Northwest Arctic, Alaska, US | |
2022-12-21 | US | Alaska | Northwest Arctic | 2188 | 5692 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-22 04:20:56 | Northwest Arctic, Alaska, US | |
2022-12-20 | US | Alaska | Northwest Arctic | 2188 | 5692 | 21 | 0 | 67.04919196 | -159.7503946 | 2022-12-21 04:21:03 | Northwest Arctic, Alaska, US | |
2022-12-06 | US | Illinois | Clark | 17023 | 5692 | 54 | 0 | 39.33425789 | -87.78705622 | 2022-12-07 04:20:58 | Clark, Illinois, US | |
2022-12-04 | US | Colorado | Elbert | 8039 | 5692 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-12-05 04:20:58 | Elbert, Colorado, US | |
2022-12-03 | US | Colorado | Elbert | 8039 | 5692 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-12-04 04:20:56 | Elbert, Colorado, US | |
2022-12-02 | US | Colorado | Elbert | 8039 | 5692 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-12-03 04:21:02 | Elbert, Colorado, US | |
2022-11-27 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-28 04:21:02 | Dawson, Nebraska, US | |
2022-11-26 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-27 04:21:05 | Dawson, Nebraska, US | |
2022-11-25 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-26 04:21:11 | Dawson, Nebraska, US | |
2022-11-24 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-25 04:21:06 | Dawson, Nebraska, US | |
2022-11-23 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-24 04:21:09 | Dawson, Nebraska, US | |
2022-11-22 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-23 04:21:06 | Dawson, Nebraska, US | |
2022-11-21 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-22 04:20:47 | Dawson, Nebraska, US | |
2022-11-20 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-21 04:21:05 | Dawson, Nebraska, US | |
2022-11-19 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-20 04:21:08 | Dawson, Nebraska, US | |
2022-11-18 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-19 04:21:14 | Dawson, Nebraska, US | |
2022-11-17 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-18 04:21:15 | Dawson, Nebraska, US | |
2022-11-16 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-17 04:21:11 | Dawson, Nebraska, US | |
2022-11-15 | US | Nebraska | Dawson | 31047 | 5692 | 87 | 0 | 40.87028216 | -99.8201461 | 2022-11-16 04:21:09 | Dawson, Nebraska, US | |
2022-11-06 | US | Kentucky | Knott | 21119 | 5692 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-11-07 04:21:26 | Knott, Kentucky, US | |
2022-11-05 | US | Kentucky | Knott | 21119 | 5692 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-11-06 04:21:24 | Knott, Kentucky, US | |
2022-11-04 | US | Kentucky | Knott | 21119 | 5692 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-11-05 04:21:52 | Knott, Kentucky, US | |
2022-11-03 | US | Kentucky | Knott | 21119 | 5692 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-11-04 04:22:11 | Knott, Kentucky, US | |
2022-11-02 | US | Kentucky | Knott | 21119 | 5692 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-11-03 04:22:05 | Knott, Kentucky, US | |
2022-11-01 | US | Kentucky | Knott | 21119 | 5692 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-11-02 04:22:09 | Knott, Kentucky, US | |
2022-10-31 | US | Kentucky | Knott | 21119 | 5692 | 73 | 0 | 37.35388197 | -82.94981134 | 2022-11-01 04:22:36 | Knott, Kentucky, US | |
2022-10-17 | US | Puerto Rico | Santa Isabel | 72133 | 5692 | 0 | 0 | 17.994525 | -66.388913 | 2022-10-18 04:22:42 | Santa Isabel, Puerto Rico, US | |
2022-09-28 | US | Puerto Rico | Orocovis | 72107 | 5692 | 0 | 0 | 18.215046 | -66.433604 | 2022-09-29 04:22:34 | Orocovis, Puerto Rico, US | |
2022-09-15 | US | Missouri | Vernon | 29217 | 5692 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-16 04:21:19 | Vernon, Missouri, US | |
2022-09-14 | US | Missouri | Vernon | 29217 | 5692 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-15 04:21:02 | Vernon, Missouri, US | |
2022-09-13 | US | Missouri | Vernon | 29217 | 5692 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-14 04:20:44 | Vernon, Missouri, US | |
2022-09-12 | US | Missouri | Vernon | 29217 | 5692 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-13 04:20:57 | Vernon, Missouri, US | |
2022-09-11 | US | Missouri | Vernon | 29217 | 5692 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-12 04:20:58 | Vernon, Missouri, US | |
2022-09-10 | US | Missouri | Vernon | 29217 | 5692 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-11 04:20:50 | Vernon, Missouri, US | |
2022-09-09 | US | Missouri | Vernon | 29217 | 5692 | 111 | 0 | 37.8457799 | -94.34127305 | 2022-09-10 04:21:10 | Vernon, Missouri, US | |
2022-09-01 | US | Missouri | Ray | 29177 | 5692 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-02 04:21:07 | Ray, Missouri, US | |
2022-08-31 | US | Missouri | Ray | 29177 | 5692 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-09-01 04:21:03 | Ray, Missouri, US | |
2022-08-30 | US | Missouri | Ray | 29177 | 5692 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-08-31 04:20:57 | Ray, Missouri, US | |
2022-08-29 | US | Missouri | Ray | 29177 | 5692 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-08-30 04:21:03 | Ray, Missouri, US | |
2022-08-28 | US | Missouri | Ray | 29177 | 5692 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-08-29 04:21:06 | Ray, Missouri, US | |
2022-08-27 | US | Missouri | Ray | 29177 | 5692 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-08-28 04:21:02 | Ray, Missouri, US | |
2022-08-26 | US | Missouri | Ray | 29177 | 5692 | 97 | 0 | 39.3537468 | -93.98905745 | 2022-08-27 04:20:57 | Ray, Missouri, US | |
2022-08-18 | US | Illinois | Richland | 17159 | 5692 | 76 | 0 | 38.71240969 | -88.08475366 | 2022-08-19 04:20:54 | Richland, Illinois, US | |
2022-08-10 | US | Ohio | Carroll | 39019 | 5692 | 129 | 0 | 40.5789686 | -81.09178213 | 2022-08-11 04:20:49 | Carroll, Ohio, US | |
2022-08-09 | US | Ohio | Carroll | 39019 | 5692 | 129 | 0 | 40.5789686 | -81.09178213 | 2022-08-10 04:20:57 | Carroll, Ohio, US | |
2022-08-08 | US | Ohio | Carroll | 39019 | 5692 | 129 | 0 | 40.5789686 | -81.09178213 | 2022-08-09 04:20:34 | Carroll, Ohio, US | |
2022-08-07 | US | Ohio | Carroll | 39019 | 5692 | 129 | 0 | 40.5789686 | -81.09178213 | 2022-08-08 04:21:08 | Carroll, Ohio, US | |
2022-08-06 | US | Ohio | Carroll | 39019 | 5692 | 129 | 0 | 40.5789686 | -81.09178213 | 2022-08-07 04:20:54 | Carroll, Ohio, US | |
2022-08-05 | US | Ohio | Carroll | 39019 | 5692 | 129 | 0 | 40.5789686 | -81.09178213 | 2022-08-06 04:20:56 | Carroll, Ohio, US | |
2022-08-04 | US | Ohio | Carroll | 39019 | 5692 | 129 | 0 | 40.5789686 | -81.09178213 | 2022-08-05 04:20:52 | Carroll, Ohio, US | |
2022-06-28 | US | Texas | Lampasas | 48281 | 5692 | 92 | 0 | 31.19531316 | -98.24206613 | 2022-06-29 04:20:59 | Lampasas, Texas, US | |
2022-06-26 | US | Idaho | Payette | 16075 | 5692 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-06-27 04:21:00 | Payette, Idaho, US | |
2022-06-25 | US | Idaho | Payette | 16075 | 5692 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-06-26 04:21:02 | Payette, Idaho, US | |
2022-06-24 | US | Idaho | Payette | 16075 | 5692 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-06-25 04:20:57 | Payette, Idaho, US | |
2022-06-17 | US | Puerto Rico | Quebradillas | 72115 | 5692 | 0 | 0 | 18.439692 | -66.926113 | 2022-06-18 04:21:10 | Quebradillas, Puerto Rico, US | |
2022-06-02 | US | Maine | Sagadahoc | 23023 | 5692 | 34 | 0 | 43.95415864 | -69.85074999 | 2022-06-03 04:20:58 | Sagadahoc, Maine, US | |
2022-06-02 | New Zealand | Cook Islands | 5692 | 1 | 0 | -21.2367 | -159.7777 | 2022-06-03 04:20:58 | Cook Islands, New Zealand | |||
2022-05-21 | US | Alabama | Barbour | 1005 | 5692 | 98 | 0 | 31.868263 | -85.3871286 | 2022-05-22 04:20:52 | Barbour, Alabama, US | |
2022-05-20 | US | Alabama | Barbour | 1005 | 5692 | 98 | 0 | 31.868263 | -85.3871286 | 2022-05-21 04:20:58 | Barbour, Alabama, US | |
2022-05-09 | US | Arkansas | Arkansas | 5001 | 5692 | 79 | 0 | 34.29145151 | -91.37277296 | 2022-05-10 04:20:50 | Arkansas, Arkansas, US | |
2022-05-03 | US | Wisconsin | Jackson | 55053 | 5692 | 43 | 0 | 44.31864893 | -90.80566792 | 2022-05-04 04:20:59 | Jackson, Wisconsin, US | |
2022-04-27 | US | Virginia | Staunton | 51790 | 5692 | 118 | 0 | 38.15965544 | -79.05979937 | 2022-04-28 04:20:47 | Staunton, Virginia, US | |
2022-03-17 | US | Alaska | Nome | 2180 | 5692 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-03-18 04:20:55 | Nome, Alaska, US | |
2022-03-16 | US | Alaska | Nome | 2180 | 5692 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-03-17 04:20:56 | Nome, Alaska, US | |
2022-03-15 | US | Puerto Rico | Juncos | 72077 | 5692 | 0 | 0 | 18.223793 | -65.909109 | 2022-03-16 04:20:50 | Juncos, Puerto Rico, US | |
2022-03-14 | US | Puerto Rico | Juncos | 72077 | 5692 | 0 | 0 | 18.223793 | -65.909109 | 2022-03-15 04:20:47 | Juncos, Puerto Rico, US | |
2022-03-03 | US | New Mexico | San Miguel | 35047 | 5692 | 50 | 0 | 35.48014807 | -104.8163562 | 2022-03-04 04:21:09 | San Miguel, New Mexico, US | |
2022-02-27 | US | Tennessee | Fentress | 47049 | 5692 | 115 | 0 | 36.38128818 | -84.92870012 | 2022-02-28 04:21:05 | Fentress, Tennessee, US | |
2022-02-27 | US | Hawaii | Out of HI | 80015 | 5692 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-28 04:21:05 | Out of HI, Hawaii, US | |
2022-02-26 | US | Tennessee | Fentress | 47049 | 5692 | 115 | 0 | 36.38128818 | -84.92870012 | 2022-02-27 04:21:04 | Fentress, Tennessee, US | |
2022-02-23 | US | Missouri | Henry | 29083 | 5692 | 77 | 0 | 38.38482826 | -93.79293734 | 2022-02-24 04:21:14 | Henry, Missouri, US | |
2022-02-21 | US | Missouri | Stone | 29209 | 5692 | 108 | 0 | 36.75000327 | -93.45256475 | 2022-02-22 04:21:01 | Stone, Missouri, US | |
2022-02-20 | US | Missouri | Stone | 29209 | 5692 | 108 | 0 | 36.75000327 | -93.45256475 | 2022-02-21 04:21:05 | Stone, Missouri, US | |
2022-02-19 | US | Missouri | Stone | 29209 | 5692 | 108 | 0 | 36.75000327 | -93.45256475 | 2022-02-20 04:21:00 | Stone, Missouri, US | |
2022-02-18 | US | Missouri | Stone | 29209 | 5692 | 108 | 0 | 36.75000327 | -93.45256475 | 2022-02-19 04:21:11 | Stone, Missouri, US | |
2022-02-15 | US | Louisiana | St. James | 22093 | 5692 | 75 | 0 | 30.02531716 | -90.80212061 | 2022-02-16 04:21:10 | St. James, Louisiana, US | |
2022-02-08 | US | Colorado | Morgan | 8087 | 5692 | 137 | 0 | 40.26279810000001 | -103.8093302 | 2022-02-09 04:21:04 | Morgan, Colorado, US | |
2022-01-28 | United Kingdom | Turks and Caicos Islands | 5692 | 34 | 0 | 21.69400000000001 | -71.7979 | 2022-01-29 04:21:10 | Turks and Caicos Islands, United Kingdom | |||
2022-01-21 | US | Tennessee | Grainger | 47057 | 5692 | 96 | 0 | 36.27469206 | -83.51254721 | 2022-01-22 04:21:13 | Grainger, Tennessee, US | |
2022-01-11 | US | Oklahoma | Caddo | 40015 | 5692 | 138 | 0 | 35.17364557 | -98.37534464 | 2022-01-12 04:21:44 | Caddo, Oklahoma, US | |
2022-01-10 | US | Oklahoma | Caddo | 40015 | 5692 | 138 | 0 | 35.17364557 | -98.37534464 | 2022-01-11 04:22:01 | Caddo, Oklahoma, US | |
2022-01-09 | US | Oklahoma | Caddo | 40015 | 5692 | 138 | 0 | 35.17364557 | -98.37534464 | 2022-01-10 04:22:07 | Caddo, Oklahoma, US | |
2022-01-09 | US | Georgia | Toombs | 13279 | 5692 | 177 | 0 | 32.12059861 | -82.32957247 | 2022-01-10 04:22:07 | Toombs, Georgia, US | |
2022-01-08 | US | Oklahoma | Caddo | 40015 | 5692 | 138 | 0 | 35.17364557 | -98.37534464 | 2022-01-09 04:21:46 | Caddo, Oklahoma, US | |
2022-01-08 | US | Georgia | Toombs | 13279 | 5692 | 177 | 0 | 32.12059861 | -82.32957247 | 2022-01-09 04:21:46 | Toombs, Georgia, US | |
2022-01-07 | US | Oklahoma | Caddo | 40015 | 5692 | 138 | 0 | 35.17364557 | -98.37534464 | 2022-01-08 04:21:53 | Caddo, Oklahoma, US | |
2022-01-07 | US | Georgia | Toombs | 13279 | 5692 | 177 | 0 | 32.12059861 | -82.32957247 | 2022-01-08 04:21:53 | Toombs, Georgia, US | |
2022-01-06 | US | Oklahoma | Caddo | 40015 | 5692 | 138 | 0 | 35.17364557 | -98.37534464 | 2022-01-07 04:22:09 | Caddo, Oklahoma, US | |
2022-01-06 | US | Georgia | Toombs | 13279 | 5692 | 177 | 0 | 32.12059861 | -82.32957247 | 2022-01-07 04:22:09 | Toombs, Georgia, US | |
2022-01-05 | US | Oklahoma | Caddo | 40015 | 5692 | 138 | 0 | 35.17364557 | -98.37534464 | 2022-01-06 04:22:09 | Caddo, Oklahoma, US | |
2022-01-05 | US | Georgia | Toombs | 13279 | 5692 | 177 | 0 | 32.12059861 | -82.32957247 | 2022-01-06 04:22:09 | Toombs, Georgia, US | |
2022-01-04 | US | Kentucky | Marshall | 21157 | 5692 | 86 | 0 | 36.88007070000001 | -88.32803576 | 2022-01-05 04:21:59 | Marshall, Kentucky, US | |
2021-12-24 | US | Puerto Rico | Toa Baja | 72137 | 5692 | 0 | 0 | 18.431445999999998 | -66.213553 | 2021-12-25 04:21:37 | Toa Baja, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;