daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
104 rows where confirmed = 6312 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 99
- Canada 3
- Netherlands 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-22 | US | New York | Schoharie | 36095 | 6312 | 41 | 0 | 42.58831742 | -74.4433903 | 2022-11-23 04:21:06 | Schoharie, New York, US | |
2022-08-29 | US | Tennessee | Wayne | 47181 | 6312 | 75 | 0 | 35.23868267 | -87.78644456 | 2022-08-30 04:21:03 | Wayne, Tennessee, US | |
2022-07-31 | US | West Virginia | McDowell | 54047 | 6312 | 77 | 0 | 37.38002939 | -81.65083669 | 2022-08-01 04:21:03 | McDowell, West Virginia, US | |
2022-07-30 | US | West Virginia | McDowell | 54047 | 6312 | 77 | 0 | 37.38002939 | -81.65083669 | 2022-07-31 04:21:02 | McDowell, West Virginia, US | |
2022-07-29 | US | West Virginia | McDowell | 54047 | 6312 | 77 | 0 | 37.38002939 | -81.65083669 | 2022-07-30 04:20:42 | McDowell, West Virginia, US | |
2022-07-28 | US | Idaho | Jefferson | 16051 | 6312 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-29 04:20:45 | Jefferson, Idaho, US | |
2022-07-27 | US | Idaho | Jefferson | 16051 | 6312 | 65 | 0 | 43.82078483 | -112.3131749 | 2022-07-28 04:20:56 | Jefferson, Idaho, US | |
2022-07-19 | US | West Virginia | Hampshire | 54027 | 6312 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-07-20 04:20:59 | Hampshire, West Virginia, US | |
2022-06-28 | US | Iowa | Benton | 19011 | 6312 | 79 | 0 | 42.08011739 | -92.06463573 | 2022-06-29 04:20:59 | Benton, Iowa, US | |
2022-06-27 | US | Texas | Jasper | 48241 | 6312 | 187 | 0 | 30.74685667 | -94.02667579 | 2022-06-28 04:20:58 | Jasper, Texas, US | |
2022-06-27 | US | Iowa | Benton | 19011 | 6312 | 79 | 0 | 42.08011739 | -92.06463573 | 2022-06-28 04:20:58 | Benton, Iowa, US | |
2022-06-26 | US | Iowa | Benton | 19011 | 6312 | 79 | 0 | 42.08011739 | -92.06463573 | 2022-06-27 04:21:00 | Benton, Iowa, US | |
2022-06-26 | US | Idaho | Blaine | 16013 | 6312 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-06-27 04:21:00 | Blaine, Idaho, US | |
2022-06-25 | US | Iowa | Benton | 19011 | 6312 | 79 | 0 | 42.08011739 | -92.06463573 | 2022-06-26 04:21:02 | Benton, Iowa, US | |
2022-06-25 | US | Idaho | Blaine | 16013 | 6312 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-06-26 04:21:02 | Blaine, Idaho, US | |
2022-06-24 | US | Iowa | Benton | 19011 | 6312 | 79 | 0 | 42.08011739 | -92.06463573 | 2022-06-25 04:20:57 | Benton, Iowa, US | |
2022-06-24 | US | Idaho | Blaine | 16013 | 6312 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-06-25 04:20:57 | Blaine, Idaho, US | |
2022-06-23 | US | Iowa | Benton | 19011 | 6312 | 79 | 0 | 42.08011739 | -92.06463573 | 2022-06-24 04:20:58 | Benton, Iowa, US | |
2022-06-22 | US | Iowa | Benton | 19011 | 6312 | 79 | 0 | 42.08011739 | -92.06463573 | 2022-06-23 04:20:55 | Benton, Iowa, US | |
2022-06-08 | US | Maryland | Caroline | 24011 | 6312 | 81 | 0 | 38.87172293 | -75.82904158 | 2022-06-09 04:20:54 | Caroline, Maryland, US | |
2022-05-04 | US | Maine | Waldo | 23027 | 6312 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-05-05 04:20:55 | Waldo, Maine, US | |
2022-04-25 | US | Tennessee | DeKalb | 47041 | 6312 | 101 | 0 | 35.97616272 | -85.83689361 | 2022-04-26 04:20:51 | DeKalb, Tennessee, US | |
2022-04-24 | US | Tennessee | DeKalb | 47041 | 6312 | 101 | 0 | 35.97616272 | -85.83689361 | 2022-04-25 04:20:56 | DeKalb, Tennessee, US | |
2022-04-23 | US | Tennessee | DeKalb | 47041 | 6312 | 101 | 0 | 35.97616272 | -85.83689361 | 2022-04-24 04:20:56 | DeKalb, Tennessee, US | |
2022-04-11 | US | Puerto Rico | Isabela | 72071 | 6312 | 0 | 0 | 18.44981 | -67.005093 | 2022-04-12 04:20:49 | Isabela, Puerto Rico, US | |
2022-03-24 | US | Michigan | Oceana | 26127 | 6312 | 89 | 0 | 43.64124435 | -86.26726673 | 2022-03-25 04:20:46 | Oceana, Michigan, US | |
2022-03-23 | US | Michigan | Oceana | 26127 | 6312 | 89 | 0 | 43.64124435 | -86.26726673 | 2022-03-24 04:20:43 | Oceana, Michigan, US | |
2022-03-01 | US | Louisiana | Sabine | 22085 | 6312 | 109 | 0 | 31.56388699 | -93.55433981 | 2022-03-02 04:21:07 | Sabine, Louisiana, US | |
2022-02-28 | US | Louisiana | Sabine | 22085 | 6312 | 109 | 0 | 31.56388699 | -93.55433981 | 2022-03-01 04:21:09 | Sabine, Louisiana, US | |
2022-02-27 | US | Louisiana | Sabine | 22085 | 6312 | 109 | 0 | 31.56388699 | -93.55433981 | 2022-02-28 04:21:05 | Sabine, Louisiana, US | |
2022-02-26 | US | Louisiana | Sabine | 22085 | 6312 | 109 | 0 | 31.56388699 | -93.55433981 | 2022-02-27 04:21:04 | Sabine, Louisiana, US | |
2022-02-25 | US | Louisiana | Sabine | 22085 | 6312 | 109 | 0 | 31.56388699 | -93.55433981 | 2022-02-26 04:21:12 | Sabine, Louisiana, US | |
2022-01-29 | US | West Virginia | Hancock | 54029 | 6312 | 130 | 0 | 40.51943859 | -80.57461608 | 2022-01-30 04:21:26 | Hancock, West Virginia, US | |
2022-01-27 | US | Nebraska | Dakota | 31043 | 6312 | 65 | 0 | 42.39040144 | -96.56656425 | 2022-01-28 04:21:09 | Dakota, Nebraska, US | |
2022-01-27 | US | California | Siskiyou | 6093 | 6312 | 66 | 0 | 41.59198861 | -122.54074340000001 | 2022-01-28 04:21:09 | Siskiyou, California, US | |
2022-01-23 | US | Minnesota | Mille Lacs | 27095 | 6312 | 102 | 0 | 45.93705297 | -93.63236823 | 2022-01-24 04:21:12 | Mille Lacs, Minnesota, US | |
2022-01-22 | US | Minnesota | Mille Lacs | 27095 | 6312 | 102 | 0 | 45.93705297 | -93.63236823 | 2022-01-23 04:21:13 | Mille Lacs, Minnesota, US | |
2022-01-21 | US | Minnesota | Mille Lacs | 27095 | 6312 | 102 | 0 | 45.93705297 | -93.63236823 | 2022-01-22 04:21:13 | Mille Lacs, Minnesota, US | |
2022-01-18 | US | Virginia | Smyth | 51173 | 6312 | 141 | 0 | 36.84455636 | -81.53344948 | 2022-01-19 04:21:23 | Smyth, Virginia, US | |
2022-01-18 | US | Virginia | Isle of Wight | 51093 | 6312 | 92 | 0 | 36.90579348 | -76.70842863 | 2022-01-19 04:21:23 | Isle of Wight, Virginia, US | |
2022-01-17 | US | Missouri | Lawrence | 29109 | 6312 | 141 | 0 | 37.10626634 | -93.83293097 | 2022-01-18 04:21:04 | Lawrence, Missouri, US | |
2022-01-16 | US | Missouri | Lawrence | 29109 | 6312 | 141 | 0 | 37.10626634 | -93.83293097 | 2022-01-17 04:21:08 | Lawrence, Missouri, US | |
2022-01-10 | US | Tennessee | Macon | 47111 | 6312 | 119 | 0 | 36.53157855 | -86.00778595 | 2022-01-11 04:22:01 | Macon, Tennessee, US | |
2021-12-20 | US | Nebraska | Lincoln | 31111 | 6312 | 60 | 0 | 41.04658298 | -100.74753740000001 | 2021-12-21 03:21:27 | Lincoln, Nebraska, US | |
2021-12-19 | US | Puerto Rico | Guaynabo | 72061 | 6312 | 0 | 0 | 18.345114000000002 | -66.11452299999999 | 2021-12-20 04:21:43 | Guaynabo, Puerto Rico, US | |
2021-12-15 | US | Pennsylvania | Clarion | 42031 | 6312 | 164 | 0 | 41.19265812 | -79.42413524 | 2021-12-16 04:22:11 | Clarion, Pennsylvania, US | |
2021-11-21 | US | Idaho | Nez Perce | 16069 | 6312 | 102 | 0 | 46.32638236 | -116.75009750000001 | 2021-11-22 04:22:20 | Nez Perce, Idaho, US | |
2021-11-20 | US | Idaho | Nez Perce | 16069 | 6312 | 102 | 0 | 46.32638236 | -116.75009750000001 | 2021-11-21 04:22:13 | Nez Perce, Idaho, US | |
2021-11-19 | US | Idaho | Nez Perce | 16069 | 6312 | 102 | 0 | 46.32638236 | -116.75009750000001 | 2021-11-20 04:22:17 | Nez Perce, Idaho, US | |
2021-11-18 | US | Michigan | Delta | 26041 | 6312 | 114 | 0 | 45.90484910000001 | -86.9080745 | 2021-11-19 04:21:40 | Delta, Michigan, US | |
2021-11-17 | US | Michigan | Delta | 26041 | 6312 | 114 | 0 | 45.90484910000001 | -86.9080745 | 2021-11-18 04:21:33 | Delta, Michigan, US | |
2021-11-15 | US | Georgia | Bryan | 13029 | 6312 | 72 | 0 | 32.00979311 | -81.44002948 | 2021-11-16 04:21:10 | Bryan, Georgia, US | |
2021-11-13 | US | Kentucky | Perry | 21193 | 6312 | 111 | 0 | 37.25023553 | -83.22922731 | 2021-11-14 04:21:31 | Perry, Kentucky, US | |
2021-11-09 | US | Virginia | Danville | 51590 | 6312 | 195 | 0 | 36.58022376 | -79.40395668 | 2021-11-10 04:21:38 | Danville, Virginia, US | |
2021-11-02 | US | Nebraska | Unassigned | 90031 | 6312 | 754 | 0 | 42.8997274 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Nebraska, US | |
2021-11-02 | US | Michigan | Hillsdale | 26059 | 6312 | 124 | 0 | 41.88753639 | -84.59312019 | 2021-11-03 06:22:09 | Hillsdale, Michigan, US | |
2021-11-01 | US | Michigan | Hillsdale | 26059 | 6312 | 124 | 0 | 41.88753639 | -84.59312019 | 2021-11-02 04:22:03 | Hillsdale, Michigan, US | |
2021-10-26 | US | Minnesota | Goodhue | 27049 | 6312 | 85 | 0 | 44.40849741 | -92.72341949999999 | 2021-10-27 04:22:32 | Goodhue, Minnesota, US | |
2021-10-21 | US | Texas | Washington | 48477 | 6312 | 126 | 0 | 30.21498498 | -96.40946246 | 2021-10-22 04:21:14 | Washington, Texas, US | |
2021-10-19 | US | Virginia | Henry | 51089 | 6312 | 150 | 0 | 36.68542395 | -79.87634026 | 2021-10-20 04:21:00 | Henry, Virginia, US | |
2021-10-17 | US | Michigan | Newaygo | 26123 | 6312 | 79 | 0 | 43.554373999999996 | -85.80070107 | 2021-10-18 04:21:10 | Newaygo, Michigan, US | |
2021-10-16 | US | Michigan | Newaygo | 26123 | 6312 | 79 | 0 | 43.554373999999996 | -85.80070107 | 2021-10-17 04:21:29 | Newaygo, Michigan, US | |
2021-10-15 | US | Michigan | Newaygo | 26123 | 6312 | 79 | 0 | 43.554373999999996 | -85.80070107 | 2021-10-16 04:21:15 | Newaygo, Michigan, US | |
2021-10-14 | US | Indiana | Huntington | 18069 | 6312 | 99 | 0 | 40.82907273 | -85.48822092 | 2021-10-15 04:21:26 | Huntington, Indiana, US | |
2021-10-13 | US | North Carolina | Alexander | 37003 | 6312 | 112 | 0 | 35.922379600000006 | -81.17751948 | 2021-10-14 04:21:29 | Alexander, North Carolina, US | |
2021-10-11 | US | South Carolina | Dillon | 45033 | 6312 | 111 | 0 | 34.39007791 | -79.37741872 | 2021-10-12 04:21:09 | Dillon, South Carolina, US | |
2021-09-28 | US | Mississippi | Panola | 28107 | 6312 | 127 | 0 | 34.36398677 | -89.95064249 | 2021-09-29 04:21:45 | Panola, Mississippi, US | |
2021-09-19 | Canada | Nova Scotia | 6312 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-20 04:21:22 | Nova Scotia, Canada | |||
2021-09-18 | Canada | Nova Scotia | 6312 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-19 04:21:34 | Nova Scotia, Canada | |||
2021-09-17 | Canada | Nova Scotia | 6312 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-18 04:21:24 | Nova Scotia, Canada | |||
2021-08-26 | US | Kentucky | Henderson | 21101 | 6312 | 85 | 0 | 37.79344553 | -87.57392021 | 2021-08-27 04:21:37 | Henderson, Kentucky, US | |
2021-08-22 | United Kingdom | Isle of Man | 6312 | 37 | 0 | 54.2361 | -4.5481 | 2021-08-23 04:21:27 | Isle of Man, United Kingdom | |||
2021-07-22 | US | North Carolina | Lenoir | 37107 | 6312 | 128 | 0 | 35.24032589999999 | -77.64245615 | 2021-07-23 04:21:29 | Lenoir, North Carolina, US | |
2021-07-16 | US | Texas | Navarro | 48349 | 6312 | 145 | 0 | 32.04620681 | -96.47428766 | 2021-07-17 04:22:22 | Navarro, Texas, US | |
2021-07-09 | US | Colorado | Garfield | 8045 | 6312 | 52 | 0 | 39.59921777 | -107.902708 | 2021-07-10 04:21:25 | Garfield, Colorado, US | |
2021-06-21 | US | Tennessee | Jefferson | 47089 | 6312 | 126 | 0 | 36.04818632 | -83.45148924 | 2021-06-22 04:21:34 | Jefferson, Tennessee, US | |
2021-06-17 | US | Kansas | Saline | 20169 | 6312 | 144 | 0 | 38.78369175 | -97.65185177 | 2021-06-18 04:22:16 | Saline, Kansas, US | |
2021-06-16 | US | Kansas | Saline | 20169 | 6312 | 144 | 0 | 38.78369175 | -97.65185177 | 2021-06-17 04:22:36 | Saline, Kansas, US | |
2021-06-10 | US | Maryland | Cecil | 24015 | 6312 | 152 | 0 | 39.56647682 | -75.94627411 | 2021-06-11 04:23:20 | Cecil, Maryland, US | |
2021-05-31 | US | Colorado | Eagle | 8037 | 6312 | 24 | 0 | 39.62754308 | -106.6933637 | 2021-06-01 04:23:09 | Eagle, Colorado, US | |
2021-05-30 | US | Colorado | Eagle | 8037 | 6312 | 24 | 0 | 39.62754308 | -106.6933637 | 2021-05-31 03:08:59 | Eagle, Colorado, US | |
2021-05-29 | US | Colorado | Eagle | 8037 | 6312 | 24 | 0 | 39.62754308 | -106.6933637 | 2021-05-30 04:20:55 | Eagle, Colorado, US | |
2021-05-28 | US | Colorado | Eagle | 8037 | 6312 | 24 | 0 | 39.62754308 | -106.6933637 | 2021-05-29 04:20:41 | Eagle, Colorado, US | |
2021-05-09 | US | North Carolina | Columbus | 37047 | 6312 | 151 | 0 | 34.26744084 | -78.65801424 | 2021-05-10 04:20:38 | Columbus, North Carolina, US | |
2021-05-08 | US | North Carolina | Columbus | 37047 | 6312 | 151 | 0 | 34.26744084 | -78.65801424 | 2021-05-09 04:20:35 | Columbus, North Carolina, US | |
2021-05-07 | US | North Carolina | Columbus | 37047 | 6312 | 151 | 0 | 34.26744084 | -78.65801424 | 2021-05-08 04:21:04 | Columbus, North Carolina, US | |
2021-04-20 | US | Mississippi | Lowndes | 28087 | 6312 | 144 | 0 | 33.47386518 | -88.44191529999998 | 2021-04-21 04:21:14 | Lowndes, Mississippi, US | |
2021-04-05 | US | Louisiana | Acadia | 22001 | 6312 | 190 | 0 | 30.2950649 | -92.41419698 | 2021-04-06 04:20:32 | Acadia, Louisiana, US | |
2021-03-29 | US | Ohio | Geauga | 39055 | 6312 | 147 | 0 | 41.49952319 | -81.17935342 | 2021-03-30 04:26:23 | Geauga, Ohio, US | |
2021-03-25 | US | Tennessee | Cumberland | 47035 | 6312 | 124 | 0 | 35.95271721 | -84.99840585 | 2021-03-26 05:26:55 | Cumberland, Tennessee, US | |
2021-03-20 | US | Ohio | Ross | 39141 | 6312 | 144 | 0 | 39.33705391 | -83.06000914 | 2021-03-21 05:25:44 | Ross, Ohio, US | |
2021-03-09 | US | Puerto Rico | Carolina | 72031 | 6312 | 0 | 0 | 18.374986 | -65.95683100000001 | 2021-03-10 05:24:35 | Carolina, Puerto Rico, US | |
2021-02-09 | US | Virginia | Suffolk | 51800 | 6312 | 120 | 0 | 6192 | 36.70155394 | -76.63603554 | 2021-02-10 05:22:41 | Suffolk, Virginia, US |
2021-01-28 | US | Texas | Bowie | 48037 | 6312 | 154 | 0 | 5569 | 33.44626922 | -94.41834132 | 2021-01-29 05:22:23 | Bowie, Texas, US |
2021-01-16 | US | Nebraska | Hall | 31079 | 6312 | 103 | 0 | 6209 | 40.87257079 | -98.50218293 | 2021-01-17 05:22:17 | Hall, Nebraska, US |
2021-01-15 | US | Nebraska | Hall | 31079 | 6312 | 103 | 0 | 6209 | 40.87257079 | -98.50218293 | 2021-01-16 05:22:40 | Hall, Nebraska, US |
2020-12-12 | US | Wyoming | Laramie | 56021 | 6312 | 41 | 0 | 6271 | 41.30702520000001 | -104.6887497 | 2020-12-13 05:27:20 | Laramie, Wyoming, US |
2020-12-01 | Netherlands | Zeeland | 6312 | 103 | 0 | 6210 | 51.47936 | 3.861559 | 2020-12-02 05:27:41 | Zeeland, Netherlands | ||
2020-11-20 | US | Idaho | Twin Falls | 16083 | 6312 | 75 | 0 | 6237 | 42.35440512 | -114.6685381 | 2020-11-21 05:25:51 | Twin Falls, Idaho, US |
2020-11-04 | US | Illinois | Unassigned | 90017 | 6312 | 283 | 0 | 6029 | 42.36542373 | 0.0 | 2020-11-05 06:05:03 | Unassigned, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;