daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
175 rows where active = 1400 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-03 | Guinea | 25992 | 234 | 24358 | 1400 | 9.9456 | -9.6966 | 2021-08-04 04:21:25 | Guinea | |||
2021-06-26 | Nigeria | 167465 | 2119 | 163946 | 1400 | 9.082 | 8.6753 | 2021-06-27 04:21:39 | Nigeria | |||
2021-05-07 | India | Ladakh | 15023 | 152 | 13471 | 1400 | 34.1526 | 77.5771 | 2021-05-08 04:21:04 | Ladakh, India | ||
2021-05-01 | India | Ladakh | 14086 | 144 | 12542 | 1400 | 34.1526 | 77.5771 | 2021-05-02 04:20:48 | Ladakh, India | ||
2021-04-13 | Russia | Murmansk Oblast | 49838 | 1124 | 47314 | 1400 | 68.00004179999999 | 33.9999151 | 2021-04-14 04:20:41 | Murmansk Oblast, Russia | ||
2021-03-23 | Russia | Novosibirsk Oblast | 38062 | 1580 | 35082 | 1400 | 54.9720169 | 79.48139240000002 | 2021-03-24 05:25:40 | Novosibirsk Oblast, Russia | ||
2021-03-20 | Russia | Novosibirsk Oblast | 37782 | 1564 | 34818 | 1400 | 54.9720169 | 79.48139240000002 | 2021-03-21 05:25:44 | Novosibirsk Oblast, Russia | ||
2021-03-19 | Italy | Molise | 11861 | 415 | 10046 | 1400 | 41.55774754 | 14.65916051 | 2021-03-20 05:25:46 | Molise, Italy | ||
2021-03-14 | India | Andhra Pradesh | 891861 | 7184 | 883277 | 1400 | 15.9129 | 79.74 | 2021-03-15 05:25:51 | Andhra Pradesh, India | ||
2021-03-06 | US | Iowa | Allamakee | 19005 | 1448 | 48 | 0 | 1400 | 43.28383218 | -91.37860922 | 2021-03-07 05:21:54 | Allamakee, Iowa, US |
2021-03-02 | US | Iowa | Madison | 19121 | 1418 | 18 | 0 | 1400 | 41.33081904 | -94.01554631 | 2021-03-03 05:23:28 | Madison, Iowa, US |
2021-03-01 | Rwanda | 18986 | 264 | 17322 | 1400 | -1.9403 | 29.8739 | 2021-03-02 05:23:30 | Rwanda | |||
2021-02-27 | US | Mississippi | Yalobusha | 28161 | 1437 | 37 | 0 | 1400 | 34.02824175 | -89.70762049999998 | 2021-02-28 05:22:20 | Yalobusha, Mississippi, US |
2021-02-25 | US | Vermont | Bennington | 50003 | 1409 | 9 | 0 | 1400 | 43.03519828 | -73.09048868 | 2021-02-26 05:22:40 | Bennington, Vermont, US |
2021-02-23 | US | Nebraska | Seward | 31159 | 1426 | 26 | 0 | 1400 | 40.87241834 | -97.139673 | 2021-02-24 05:29:16 | Seward, Nebraska, US |
2021-02-18 | US | Texas | Panola | 48365 | 1710 | 59 | 0 | 1400 | 32.163959600000005 | -94.30552481 | 2021-02-19 05:24:16 | Panola, Texas, US |
2021-02-18 | US | Louisiana | Winn | 22127 | 1439 | 39 | 0 | 1400 | 31.94449367 | -92.63789413 | 2021-02-19 05:24:16 | Winn, Louisiana, US |
2021-02-17 | US | Oklahoma | Love | 40085 | 1408 | 8 | 0 | 1400 | 33.95273467 | -97.23906784 | 2021-02-18 05:22:58 | Love, Oklahoma, US |
2021-02-14 | US | Colorado | Bent | 8011 | 1426 | 21 | 0 | 1400 | 37.95474293 | -103.0720195 | 2021-02-15 05:24:49 | Bent, Colorado, US |
2021-02-12 | US | Tennessee | Lewis | 47101 | 1448 | 24 | 0 | 1400 | 35.52853208 | -87.49022694 | 2021-02-13 05:22:12 | Lewis, Tennessee, US |
2021-02-11 | US | Texas | Pecos | 48371 | 1140 | 31 | 0 | 1400 | 30.78097267 | -102.7241261 | 2021-02-12 05:23:29 | Pecos, Texas, US |
2021-02-03 | US | Missouri | Ray | 29177 | 1420 | 20 | 0 | 1400 | 39.3537468 | -93.98905745 | 2021-02-04 05:22:26 | Ray, Missouri, US |
2021-01-28 | US | Wisconsin | Marquette | 55077 | 1426 | 26 | 0 | 1400 | 43.81911946 | -89.40073763 | 2021-01-29 05:22:23 | Marquette, Wisconsin, US |
2021-01-28 | US | Missouri | Clinton | 29049 | 1460 | 60 | 0 | 1400 | 39.6013098 | -94.40465394 | 2021-01-29 05:22:23 | Clinton, Missouri, US |
2021-01-28 | US | Kentucky | Anderson | 21005 | 1412 | 12 | 0 | 1400 | 38.00671029 | -84.99171713 | 2021-01-29 05:22:23 | Anderson, Kentucky, US |
2021-01-27 | US | Texas | Jackson | 48239 | 1464 | 23 | 0 | 1400 | 28.95472367 | -96.57749563 | 2021-01-28 05:22:24 | Jackson, Texas, US |
2021-01-27 | US | Montana | Glacier | 30035 | 1429 | 29 | 0 | 1400 | 48.70513576 | -112.9934235 | 2021-01-28 05:22:24 | Glacier, Montana, US |
2021-01-26 | US | Kansas | Atchison | 20005 | 1412 | 12 | 0 | 1400 | 39.53185661 | -95.30870026 | 2021-01-27 05:23:41 | Atchison, Kansas, US |
2021-01-26 | US | Illinois | Moultrie | 17139 | 1420 | 20 | 0 | 1400 | 39.64187451 | -88.62099969 | 2021-01-27 05:23:41 | Moultrie, Illinois, US |
2021-01-25 | US | Michigan | Clare | 26035 | 1467 | 67 | 0 | 1400 | 43.98794227 | -84.84819859999998 | 2021-01-26 05:22:02 | Clare, Michigan, US |
2021-01-25 | US | Kansas | Atchison | 20005 | 1412 | 12 | 0 | 1400 | 39.53185661 | -95.30870026 | 2021-01-26 05:22:02 | Atchison, Kansas, US |
2021-01-25 | US | Alabama | Washington | 1129 | 1427 | 27 | 0 | 1400 | 31.4092794 | -88.20689944 | 2021-01-26 05:22:02 | Washington, Alabama, US |
2021-01-24 | US | Tennessee | Sequatchie | 47153 | 1365 | 19 | 0 | 1400 | 35.36979721 | -85.41022136 | 2021-01-25 05:22:16 | Sequatchie, Tennessee, US |
2021-01-22 | US | Missouri | Pike | 29163 | 1417 | 17 | 0 | 1400 | 39.34310674 | -91.16980779 | 2021-01-23 05:22:03 | Pike, Missouri, US |
2021-01-21 | US | Ohio | Paulding | 39125 | 1432 | 32 | 0 | 1400 | 41.11676341 | -84.5801017 | 2021-01-22 05:22:10 | Paulding, Ohio, US |
2021-01-18 | US | Illinois | Edgar | 17045 | 1432 | 32 | 0 | 1400 | 39.6809186 | -87.74759563 | 2021-01-19 05:22:15 | Edgar, Illinois, US |
2021-01-17 | US | Kansas | Jefferson | 20087 | 1425 | 25 | 0 | 1400 | 39.2347941 | -95.38289232 | 2021-01-18 05:22:34 | Jefferson, Kansas, US |
2021-01-17 | US | Indiana | Franklin | 18047 | 1434 | 34 | 0 | 1400 | 39.4142482 | -85.06062647 | 2021-01-18 05:22:34 | Franklin, Indiana, US |
2021-01-16 | US | Kansas | Jefferson | 20087 | 1425 | 25 | 0 | 1400 | 39.2347941 | -95.38289232 | 2021-01-17 05:22:17 | Jefferson, Kansas, US |
2021-01-15 | US | Texas | Tyler | 48457 | 1501 | 18 | 0 | 1400 | 30.77031716 | -94.37690895 | 2021-01-16 05:22:40 | Tyler, Texas, US |
2021-01-15 | US | Kansas | Jefferson | 20087 | 1425 | 25 | 0 | 1400 | 39.2347941 | -95.38289232 | 2021-01-16 05:22:40 | Jefferson, Kansas, US |
2021-01-15 | US | Florida | Calhoun | 12013 | 1432 | 32 | 0 | 1400 | 30.40666734 | -85.19394153 | 2021-01-16 05:22:40 | Calhoun, Florida, US |
2021-01-14 | US | Arkansas | Hempstead | 5057 | 1411 | 11 | 0 | 1400 | 33.73325583 | -93.66935133 | 2021-01-15 05:22:24 | Hempstead, Arkansas, US |
2021-01-12 | US | Georgia | Lamar | 13171 | 1435 | 35 | 0 | 1400 | 33.07841647 | -84.14263877 | 2021-01-13 05:22:15 | Lamar, Georgia, US |
2021-01-10 | US | Wisconsin | Lafayette | 55065 | 1406 | 6 | 0 | 1400 | 42.66005229 | -90.1317729 | 2021-01-11 05:21:50 | Lafayette, Wisconsin, US |
2021-01-10 | US | Illinois | Hancock | 17067 | 1422 | 22 | 0 | 1400 | 40.40423981 | -91.16313899 | 2021-01-11 05:21:50 | Hancock, Illinois, US |
2021-01-08 | US | Missouri | Texas | 29215 | 1419 | 19 | 0 | 1400 | 37.31728859 | -91.96564727 | 2021-01-09 05:22:18 | Texas, Missouri, US |
2021-01-08 | US | Arkansas | Izard | 5065 | 1420 | 20 | 0 | 1400 | 36.09604046 | -91.90847954 | 2021-01-09 05:22:18 | Izard, Arkansas, US |
2021-01-07 | US | Texas | Wilbarger | 48487 | 1493 | 39 | 0 | 1400 | 34.07945812 | -99.24178437 | 2021-01-08 05:22:42 | Wilbarger, Texas, US |
2021-01-07 | US | Mississippi | Clay | 28025 | 1430 | 30 | 0 | 1400 | 33.65358105 | -88.77784255 | 2021-01-08 05:22:42 | Clay, Mississippi, US |
2021-01-06 | US | Mississippi | Clay | 28025 | 1430 | 30 | 0 | 1400 | 33.65358105 | -88.77784255 | 2021-01-07 05:22:03 | Clay, Mississippi, US |
2021-01-06 | US | Georgia | Mitchell | 13205 | 1454 | 54 | 0 | 1400 | 31.22483255 | -84.19381821 | 2021-01-07 05:22:03 | Mitchell, Georgia, US |
2021-01-04 | US | Washington | Unassigned | 90053 | 1404 | 4 | 0 | 1400 | 48.82227976 | 0.0 | 2021-01-05 05:21:49 | Unassigned, Washington, US |
2021-01-04 | US | New York | Orleans | 36073 | 1464 | 64 | 0 | 1400 | 43.2516977 | -78.2320066 | 2021-01-05 05:21:49 | Orleans, New York, US |
2021-01-03 | US | Washington | Unassigned | 90053 | 1404 | 4 | 0 | 1400 | 48.82227976 | 0.0 | 2021-01-04 05:22:02 | Unassigned, Washington, US |
2021-01-02 | US | Iowa | Harrison | 19085 | 1458 | 58 | 0 | 1400 | 41.68330137 | -95.81558439 | 2021-01-03 05:22:52 | Harrison, Iowa, US |
2021-01-01 | US | Florida | Lafayette | 12067 | 1422 | 22 | 0 | 1400 | 29.98484137 | -83.18166636 | 2021-01-02 05:22:33 | Lafayette, Florida, US |
2020-12-31 | US | Florida | Lafayette | 12067 | 1422 | 22 | 0 | 1400 | 29.98484137 | -83.18166636 | 2021-01-01 05:23:07 | Lafayette, Florida, US |
2020-12-29 | US | Missouri | Morgan | 29141 | 1423 | 23 | 0 | 1400 | 38.4181765 | -92.88791859 | 2020-12-30 05:22:34 | Morgan, Missouri, US |
2020-12-28 | US | Michigan | Out of MI | 80026 | 1410 | 10 | 0 | 1400 | 47.63197653 | 0.0 | 2020-12-29 05:22:37 | Out of MI, Michigan, US |
2020-12-23 | US | Nebraska | Colfax | 31037 | 1417 | 17 | 0 | 1400 | 41.57486951 | -97.0868542 | 2020-12-24 05:23:04 | Colfax, Nebraska, US |
2020-12-18 | US | New Hampshire | Unassigned | 90033 | 1400 | 0 | 0 | 1400 | 44.69063265 | 0.0 | 2020-12-19 05:27:52 | Unassigned, New Hampshire, US |
2020-12-16 | US | Virginia | Smyth | 51173 | 1439 | 39 | 0 | 1400 | 36.84455636 | -81.53344948 | 2020-12-17 05:28:12 | Smyth, Virginia, US |
2020-12-16 | US | Pennsylvania | Clinton | 42035 | 1416 | 16 | 0 | 1400 | 41.23255967 | -77.63785995 | 2020-12-17 05:28:12 | Clinton, Pennsylvania, US |
2020-12-13 | US | Iowa | Wright | 19197 | 1410 | 10 | 0 | 1400 | 42.73305373 | -93.73515113 | 2020-12-14 05:26:27 | Wright, Iowa, US |
2020-12-12 | US | Tennessee | Hickman | 47081 | 1461 | 20 | 0 | 1400 | 35.80609681 | -87.47643507 | 2020-12-13 05:27:20 | Hickman, Tennessee, US |
2020-12-12 | US | Maryland | Somerset | 24039 | 1411 | 11 | 0 | 1400 | 38.1163542 | -75.75118623 | 2020-12-13 05:27:20 | Somerset, Maryland, US |
2020-12-12 | US | Georgia | Franklin | 13119 | 1425 | 25 | 0 | 1400 | 34.37525597 | -83.23159927 | 2020-12-13 05:27:20 | Franklin, Georgia, US |
2020-12-11 | US | Georgia | Chattooga | 13055 | 1438 | 38 | 0 | 1400 | 34.47197698 | -85.34535662 | 2020-12-12 05:26:19 | Chattooga, Georgia, US |
2020-12-10 | US | Nebraska | Washington | 31177 | 1414 | 14 | 0 | 1400 | 41.52815707 | -96.22019892 | 2020-12-11 05:26:59 | Washington, Nebraska, US |
2020-12-10 | US | Mississippi | Hancock | 28045 | 1445 | 45 | 0 | 1400 | 30.41830223 | -89.48851033 | 2020-12-11 05:26:59 | Hancock, Mississippi, US |
2020-12-09 | US | South Carolina | Clarendon | 45027 | 1470 | 70 | 0 | 1400 | 33.66610974 | -80.21647898 | 2020-12-10 05:26:19 | Clarendon, South Carolina, US |
2020-11-30 | US | Alabama | Marion | 1093 | 1436 | 36 | 0 | 1400 | 34.13697363 | -87.88704173 | 2020-12-01 05:26:18 | Marion, Alabama, US |
2020-11-27 | US | Minnesota | Le Sueur | 27079 | 1411 | 11 | 0 | 1400 | 44.37136597 | -93.72844721 | 2020-11-28 05:25:50 | Le Sueur, Minnesota, US |
2020-11-27 | Russia | Adygea Republic | 7773 | 63 | 6310 | 1400 | 44.6939006 | 40.1520421 | 2020-11-28 05:25:50 | Adygea Republic, Russia | ||
2020-11-23 | US | West Virginia | Raleigh | 54081 | 1415 | 15 | 0 | 1400 | 37.76936795 | -81.2456041 | 2020-11-24 05:27:31 | Raleigh, West Virginia, US |
2020-11-21 | US | Tennessee | Campbell | 47013 | 1429 | 21 | 0 | 1400 | 36.40355516 | -84.15108559999999 | 2020-11-22 05:25:45 | Campbell, Tennessee, US |
2020-11-20 | US | Michigan | Houghton | 26061 | 1411 | 11 | 0 | 1400 | 46.89988536 | -88.68495385 | 2020-11-21 05:25:51 | Houghton, Michigan, US |
2020-11-17 | US | Wyoming | Sheridan | 56033 | 1409 | 9 | 0 | 1400 | 44.79048913 | -106.8862389 | 2020-11-18 05:40:31 | Sheridan, Wyoming, US |
2020-11-17 | US | Minnesota | Becker | 27005 | 1404 | 4 | 0 | 1400 | 46.93479392 | -95.67158144 | 2020-11-18 05:40:31 | Becker, Minnesota, US |
2020-11-17 | Russia | Vologda Oblast | 9151 | 74 | 7677 | 1400 | 60.0391461 | 43.1215213 | 2020-11-18 05:40:31 | Vologda Oblast, Russia | ||
2020-11-13 | US | Missouri | Dunklin | 29069 | 1413 | 13 | 0 | 1400 | 36.27167174 | -90.09122243 | 2020-11-14 05:25:37 | Dunklin, Missouri, US |
2020-11-12 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-13 05:25:30 | Congo (Brazzaville) | |||
2020-11-11 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-12 05:25:55 | Congo (Brazzaville) | |||
2020-11-10 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-11 05:25:30 | Congo (Brazzaville) | |||
2020-11-09 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-10 05:40:07 | Congo (Brazzaville) | |||
2020-11-08 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-09 05:25:45 | Congo (Brazzaville) | |||
2020-11-07 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-08 05:24:56 | Congo (Brazzaville) | |||
2020-11-06 | Congo (Brazzaville) | 5379 | 92 | 3887 | 1400 | -0.228 | 15.8277 | 2020-11-07 05:24:52 | Congo (Brazzaville) | |||
2020-11-04 | US | Michigan | Eaton | 26045 | 1412 | 12 | 0 | 1400 | 42.59599185 | -84.83740035 | 2020-11-05 06:05:03 | Eaton, Michigan, US |
2020-11-01 | US | Iowa | Crawford | 19047 | 1415 | 15 | 0 | 1400 | 42.03718237 | -95.3819718 | 2020-11-02 05:25:04 | Crawford, Iowa, US |
2020-10-31 | India | Tripura | 30794 | 346 | 29048 | 1400 | 23.746783 | 91.743565 | 2020-11-01 04:36:19 | Tripura, India | ||
2020-10-30 | US | Missouri | Callaway | 29027 | 1405 | 5 | 0 | 1400 | 38.83674754 | -91.92186505 | 2020-10-31 04:24:44 | Callaway, Missouri, US |
2020-10-30 | US | Maine | York | 23031 | 1420 | 20 | 0 | 1400 | 43.47808377 | -70.71052375 | 2020-10-31 04:24:44 | York, Maine, US |
2020-10-28 | US | Connecticut | Windham | 9015 | 1419 | 19 | 0 | 1400 | 41.82972709 | -71.98182316 | 2020-10-29 04:24:49 | Windham, Connecticut, US |
2020-10-27 | US | Texas | Hardin | 48199 | 924 | 34 | 0 | 1400 | 30.33364686 | -94.38931817 | 2020-10-28 04:24:39 | Hardin, Texas, US |
2020-10-27 | US | Tennessee | Henderson | 47077 | 1412 | 26 | 0 | 1400 | 35.65581134 | -88.38600175 | 2020-10-28 04:24:39 | Henderson, Tennessee, US |
2020-10-25 | US | Pennsylvania | Northumberland | 42097 | 1511 | 111 | 0 | 1400 | 40.84785433 | -76.70798222 | 2020-10-26 04:25:02 | Northumberland, Pennsylvania, US |
2020-10-24 | Pakistan | Islamabad | 18921 | 210 | 17311 | 1400 | 33.665087 | 73.121219 | 2020-10-25 04:24:36 | Islamabad, Pakistan | ||
2020-10-22 | Sweden | Varmland | 1475 | 75 | 0 | 1400 | 59.7294 | 13.2354 | 2020-10-23 04:24:46 | Varmland, Sweden |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;