johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
150 rows where confirmed = 4655 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2180608 | 2180608 | 2022-12-22 | US | Illinois | Mason | 17125 | 4655 | 66 | 0 | 40.23917274 | -89.91824452 | 2022-12-23 04:21:04 | Mason, Illinois, US | |
311277 | 311277 | 2022-12-13 | US | Virginia | Patrick | 51141 | 4655 | 102 | 0 | 36.6801638 | -80.2865648 | 2022-12-14 04:21:04 | Patrick, Virginia, US | |
63571 | 63571 | 2022-11-12 | US | Arkansas | Madison | 5087 | 4655 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-11-13 04:21:14 | Madison, Arkansas, US | |
2927733 | 2927733 | 2022-11-11 | US | Arkansas | Madison | 5087 | 4655 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-11-12 04:20:41 | Madison, Arkansas, US | |
2506569 | 2506569 | 2022-11-10 | US | Arkansas | Madison | 5087 | 4655 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-11-11 04:21:22 | Madison, Arkansas, US | |
2160566 | 2160566 | 2022-10-16 | US | Illinois | Moultrie | 17139 | 4655 | 50 | 0 | 39.64187451 | -88.62099969 | 2022-10-17 04:20:31 | Moultrie, Illinois, US | |
516763 | 516763 | 2022-10-15 | US | Illinois | Moultrie | 17139 | 4655 | 50 | 0 | 39.64187451 | -88.62099969 | 2022-10-16 04:22:39 | Moultrie, Illinois, US | |
2033820 | 2033820 | 2022-10-14 | US | Illinois | Moultrie | 17139 | 4655 | 50 | 0 | 39.64187451 | -88.62099969 | 2022-10-15 04:22:00 | Moultrie, Illinois, US | |
3754508 | 3754508 | 2022-10-13 | US | Illinois | Moultrie | 17139 | 4655 | 50 | 0 | 39.64187451 | -88.62099969 | 2022-10-14 04:22:28 | Moultrie, Illinois, US | |
117913 | 117913 | 2022-09-06 | US | Texas | Llano | 48299 | 4655 | 98 | 0 | 30.70645047 | -98.68475262 | 2022-09-07 04:20:59 | Llano, Texas, US | |
1879731 | 1879731 | 2022-08-28 | US | Puerto Rico | Guayanilla | 72059 | 4655 | 0 | 0 | 18.039942 | -66.79186 | 2022-08-29 04:21:06 | Guayanilla, Puerto Rico, US | |
1101657 | 1101657 | 2022-08-03 | US | Wisconsin | Crawford | 55023 | 4655 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-08-04 04:20:58 | Crawford, Wisconsin, US | |
2982452 | 2982452 | 2022-06-13 | US | Texas | Panola | 48365 | 4655 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-06-14 04:20:52 | Panola, Texas, US | |
2237175 | 2237175 | 2022-06-12 | US | Mississippi | Calhoun | 28013 | 4655 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-13 04:21:14 | Calhoun, Mississippi, US | |
3143373 | 3143373 | 2022-06-11 | US | Mississippi | Calhoun | 28013 | 4655 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-12 04:20:53 | Calhoun, Mississippi, US | |
1946289 | 1946289 | 2022-06-10 | US | Mississippi | Calhoun | 28013 | 4655 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-11 04:21:01 | Calhoun, Mississippi, US | |
3159428 | 3159428 | 2022-06-09 | US | Mississippi | Calhoun | 28013 | 4655 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-10 04:20:55 | Calhoun, Mississippi, US | |
1422895 | 1422895 | 2022-06-08 | US | Mississippi | Calhoun | 28013 | 4655 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-09 04:20:54 | Calhoun, Mississippi, US | |
3728009 | 3728009 | 2022-06-07 | US | Mississippi | Calhoun | 28013 | 4655 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-08 04:20:55 | Calhoun, Mississippi, US | |
3889411 | 3889411 | 2022-06-06 | US | Mississippi | Calhoun | 28013 | 4655 | 71 | 0 | 33.93683395 | -89.33686647 | 2022-06-07 04:21:08 | Calhoun, Mississippi, US | |
2048468 | 2048468 | 2022-05-25 | US | Colorado | Alamosa | 8003 | 4655 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-05-26 04:20:50 | Alamosa, Colorado, US | |
3002444 | 3002444 | 2022-05-24 | US | Texas | Jones | 48253 | 4655 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-05-25 04:20:56 | Jones, Texas, US | |
3000093 | 3000093 | 2022-05-24 | US | Georgia | Crisp | 13081 | 4655 | 137 | 0 | 31.92289565 | -83.76811843 | 2022-05-25 04:20:56 | Crisp, Georgia, US | |
3596165 | 3596165 | 2022-05-23 | US | Texas | Jones | 48253 | 4655 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-05-24 04:20:57 | Jones, Texas, US | |
3593814 | 3593814 | 2022-05-23 | US | Georgia | Crisp | 13081 | 4655 | 137 | 0 | 31.92289565 | -83.76811843 | 2022-05-24 04:20:57 | Crisp, Georgia, US | |
1112781 | 1112781 | 2022-05-21 | US | Texas | Reeves | 48389 | 4655 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-05-22 04:20:52 | Reeves, Texas, US | |
1110362 | 1110362 | 2022-05-21 | US | Georgia | Crisp | 13081 | 4655 | 137 | 0 | 31.92289565 | -83.76811843 | 2022-05-22 04:20:52 | Crisp, Georgia, US | |
1169986 | 1169986 | 2022-05-20 | US | Georgia | Crisp | 13081 | 4655 | 137 | 0 | 31.92289565 | -83.76811843 | 2022-05-21 04:20:58 | Crisp, Georgia, US | |
3896749 | 3896749 | 2022-05-19 | US | Georgia | Crisp | 13081 | 4655 | 137 | 0 | 31.92289565 | -83.76811843 | 2022-05-20 04:20:57 | Crisp, Georgia, US | |
1185533 | 1185533 | 2022-05-18 | US | Georgia | Crisp | 13081 | 4655 | 137 | 0 | 31.92289565 | -83.76811843 | 2022-05-19 04:20:54 | Crisp, Georgia, US | |
1329774 | 1329774 | 2022-04-26 | US | Wisconsin | Adams | 55001 | 4655 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-04-27 04:20:52 | Adams, Wisconsin, US | |
1543138 | 1543138 | 2022-03-31 | US | Texas | Montague | 48337 | 4655 | 127 | 0 | 33.67521893 | -97.72500958 | 2022-04-01 04:20:28 | Montague, Texas, US | |
2735942 | 2735942 | 2022-02-27 | US | Tennessee | Bledsoe | 47007 | 4655 | 53 | 0 | 35.59942968 | -85.20611967 | 2022-02-28 04:21:05 | Bledsoe, Tennessee, US | |
3049095 | 3049095 | 2022-02-26 | US | Tennessee | Bledsoe | 47007 | 4655 | 53 | 0 | 35.59942968 | -85.20611967 | 2022-02-27 04:21:04 | Bledsoe, Tennessee, US | |
1058226 | 1058226 | 2022-02-23 | US | Alabama | Hale | 1065 | 4655 | 98 | 0 | 32.76039258 | -87.63284988 | 2022-02-24 04:21:14 | Hale, Alabama, US | |
3719590 | 3719590 | 2022-02-21 | US | Kentucky | Garrard | 21079 | 4655 | 69 | 0 | 37.638866799999995 | -84.53289319 | 2022-02-22 04:21:01 | Garrard, Kentucky, US | |
1298533 | 1298533 | 2022-02-17 | US | Arkansas | Cross | 5037 | 4655 | 75 | 0 | 35.29631396 | -90.77185818 | 2022-02-18 04:21:04 | Cross, Arkansas, US | |
461498 | 461498 | 2022-02-02 | US | Nebraska | Saunders | 31155 | 4655 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2022-02-03 04:21:21 | Saunders, Nebraska, US | |
2660615 | 2660615 | 2022-01-31 | US | South Carolina | Hampton | 45049 | 4655 | 76 | 0 | 32.77419582 | -81.13845571 | 2022-02-01 04:21:11 | Hampton, South Carolina, US | |
3303032 | 3303032 | 2022-01-30 | US | South Carolina | Hampton | 45049 | 4655 | 76 | 0 | 32.77419582 | -81.13845571 | 2022-01-31 04:21:09 | Hampton, South Carolina, US | |
3064823 | 3064823 | 2022-01-29 | US | South Carolina | Hampton | 45049 | 4655 | 76 | 0 | 32.77419582 | -81.13845571 | 2022-01-30 04:21:26 | Hampton, South Carolina, US | |
3812757 | 3812757 | 2022-01-28 | US | South Carolina | Hampton | 45049 | 4655 | 76 | 0 | 32.77419582 | -81.13845571 | 2022-01-29 04:21:10 | Hampton, South Carolina, US | |
2833745 | 2833745 | 2022-01-22 | US | Hawaii | Out of HI | 80015 | 4655 | 11 | 0 | 22.03935037 | 0.0 | 2022-01-23 04:21:13 | Out of HI, Hawaii, US | |
3466085 | 3466085 | 2022-01-18 | US | Missouri | Henry | 29083 | 4655 | 66 | 0 | 38.38482826 | -93.79293734 | 2022-01-19 04:21:23 | Henry, Missouri, US | |
1694605 | 1694605 | 2022-01-10 | US | North Carolina | Anson | 37007 | 4655 | 86 | 0 | 34.97403241 | -80.09953279 | 2022-01-11 04:22:01 | Anson, North Carolina, US | |
799949 | 799949 | 2021-12-22 | US | Louisiana | Morehouse | 22067 | 4655 | 117 | 0 | 32.81686191 | -91.80421614 | 2021-12-23 04:21:21 | Morehouse, Louisiana, US | |
1719297 | 1719297 | 2021-12-16 | US | Tennessee | Grainger | 47057 | 4655 | 75 | 0 | 36.27469206 | -83.51254721 | 2021-12-17 04:22:14 | Grainger, Tennessee, US | |
1078968 | 1078968 | 2021-12-09 | US | Illinois | Saline | 17165 | 4655 | 73 | 0 | 37.75332999 | -88.54119706 | 2021-12-10 04:22:28 | Saline, Illinois, US | |
406734 | 406734 | 2021-12-07 | US | Ohio | Adams | 39001 | 4655 | 115 | 0 | 38.84541072 | -83.4718964 | 2021-12-08 04:22:46 | Adams, Ohio, US | |
1742771 | 1742771 | 2021-12-05 | US | New York | Delaware | 36025 | 4655 | 53 | 0 | 42.19837623 | -74.96709306 | 2021-12-06 04:22:34 | Delaware, New York, US | |
1740913 | 1740913 | 2021-12-05 | US | Alabama | Geneva | 1061 | 4655 | 136 | 0 | 31.09389027 | -85.83572839 | 2021-12-06 04:22:34 | Geneva, Alabama, US | |
138345 | 138345 | 2021-12-04 | US | Alabama | Geneva | 1061 | 4655 | 136 | 0 | 31.09389027 | -85.83572839 | 2021-12-05 04:22:25 | Geneva, Alabama, US | |
2198129 | 2198129 | 2021-12-03 | US | Ohio | Pike | 39131 | 4655 | 80 | 0 | 39.07634001 | -83.06769584 | 2021-12-04 04:22:18 | Pike, Ohio, US | |
3071477 | 3071477 | 2021-11-23 | US | Kentucky | Mercer | 21167 | 4655 | 80 | 0 | 37.81474237 | -84.87488475 | 2021-11-24 04:22:14 | Mercer, Kentucky, US | |
3289412 | 3289412 | 2021-11-18 | US | Arkansas | Johnson | 5071 | 4655 | 58 | 0 | 35.56759135 | -93.46036368 | 2021-11-19 04:21:40 | Johnson, Arkansas, US | |
2003553 | 2003553 | 2021-11-07 | US | South Dakota | Meade | 46093 | 4655 | 49 | 0 | 44.56676791 | -102.71627409999999 | 2021-11-08 04:21:43 | Meade, South Dakota, US | |
498544 | 498544 | 2021-11-06 | US | South Dakota | Meade | 46093 | 4655 | 49 | 0 | 44.56676791 | -102.71627409999999 | 2021-11-07 04:21:53 | Meade, South Dakota, US | |
3124399 | 3124399 | 2021-11-05 | US | South Dakota | Meade | 46093 | 4655 | 49 | 0 | 44.56676791 | -102.71627409999999 | 2021-11-06 04:21:51 | Meade, South Dakota, US | |
3794658 | 3794658 | 2021-10-25 | US | Georgia | Butts | 13035 | 4655 | 113 | 0 | 33.283094500000004 | -83.95435040000002 | 2021-10-26 04:22:09 | Butts, Georgia, US | |
445416 | 445416 | 2021-10-20 | US | Nebraska | Dakota | 31043 | 4655 | 65 | 0 | 42.39040144 | -96.56656425 | 2021-10-21 04:21:18 | Dakota, Nebraska, US | |
935436 | 935436 | 2021-10-16 | US | Colorado | Logan | 8075 | 4655 | 84 | 0 | 40.7249637 | -103.110817 | 2021-10-17 04:21:29 | Logan, Colorado, US | |
2132420 | 2132420 | 2021-10-01 | US | Alabama | Pike | 1109 | 4655 | 100 | 0 | 31.80396383 | -85.9408295 | 2021-10-02 04:21:25 | Pike, Alabama, US | |
2773334 | 2773334 | 2021-09-30 | US | Alabama | Clarke | 1025 | 4655 | 80 | 0 | 31.68099859 | -87.83548597 | 2021-10-01 04:21:35 | Clarke, Alabama, US | |
1238728 | 1238728 | 2021-09-27 | US | Texas | Fannin | 48147 | 4655 | 132 | 0 | 33.59564294 | -96.10751083 | 2021-09-28 04:21:28 | Fannin, Texas, US | |
2079029 | 2079029 | 2021-09-26 | US | Texas | Fannin | 48147 | 4655 | 132 | 0 | 33.59564294 | -96.10751083 | 2021-09-27 04:21:16 | Fannin, Texas, US | |
1727581 | 1727581 | 2021-09-25 | US | Texas | Fannin | 48147 | 4655 | 131 | 0 | 33.59564294 | -96.10751083 | 2021-09-26 04:21:29 | Fannin, Texas, US | |
3014145 | 3014145 | 2021-09-22 | US | South Carolina | Clarendon | 45027 | 4655 | 133 | 0 | 33.66610974 | -80.21647898 | 2021-09-23 04:21:43 | Clarendon, South Carolina, US | |
3013562 | 3013562 | 2021-09-22 | US | New York | Columbia | 36021 | 4655 | 108 | 0 | 42.24819348 | -73.63089095 | 2021-09-23 04:21:43 | Columbia, New York, US | |
809964 | 809964 | 2021-09-20 | US | Alabama | Marion | 1093 | 4655 | 115 | 0 | 34.13697363 | -87.88704173 | 2021-09-21 04:21:26 | Marion, Alabama, US | |
1389245 | 1389245 | 2021-09-13 | US | Wyoming | Teton | 56039 | 4655 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-09-14 04:21:41 | Teton, Wyoming, US | |
2176180 | 2176180 | 2021-08-22 | US | Colorado | La Plata | 8067 | 4655 | 49 | 0 | 37.28632032 | -107.8429014 | 2021-08-23 04:21:27 | La Plata, Colorado, US | |
246472 | 246472 | 2021-08-17 | US | Iowa | Jasper | 19099 | 4655 | 73 | 0 | 41.68576082 | -93.05567785 | 2021-08-18 04:21:35 | Jasper, Iowa, US | |
1605435 | 1605435 | 2021-08-16 | US | Iowa | Jasper | 19099 | 4655 | 73 | 0 | 41.68576082 | -93.05567785 | 2021-08-17 04:21:49 | Jasper, Iowa, US | |
104529 | 104529 | 2021-08-15 | US | Iowa | Jasper | 19099 | 4655 | 73 | 0 | 41.68576082 | -93.05567785 | 2021-08-16 04:21:31 | Jasper, Iowa, US | |
508887 | 508887 | 2021-08-14 | US | Iowa | Jasper | 19099 | 4655 | 73 | 0 | 41.68576082 | -93.05567785 | 2021-08-15 04:21:41 | Jasper, Iowa, US | |
1484759 | 1484759 | 2021-08-13 | US | Iowa | Jasper | 19099 | 4655 | 73 | 0 | 41.68576082 | -93.05567785 | 2021-08-14 04:21:25 | Jasper, Iowa, US | |
2900889 | 2900889 | 2021-08-12 | US | Iowa | Jasper | 19099 | 4655 | 73 | 0 | 41.68576082 | -93.05567785 | 2021-08-13 04:21:24 | Jasper, Iowa, US | |
1343493 | 1343493 | 2021-08-11 | US | Iowa | Jasper | 19099 | 4655 | 73 | 0 | 41.68576082 | -93.05567785 | 2021-08-12 04:21:25 | Jasper, Iowa, US | |
333020 | 333020 | 2021-08-04 | US | Indiana | Montgomery | 18107 | 4655 | 92 | 0 | 40.04034823 | -86.89335024 | 2021-08-05 04:21:51 | Montgomery, Indiana, US | |
3387712 | 3387712 | 2021-07-29 | US | North Carolina | Haywood | 37087 | 4655 | 99 | 0 | 35.55269063 | -82.98196486 | 2021-07-30 04:21:34 | Haywood, North Carolina, US | |
1306659 | 1306659 | 2021-07-27 | US | Arkansas | Miller | 5091 | 4655 | 37 | 0 | 33.31403423 | -93.89285258 | 2021-07-28 04:21:39 | Miller, Arkansas, US | |
1330646 | 1330646 | 2021-07-24 | US | Alabama | Russell | 1113 | 4655 | 42 | 0 | 32.28725256 | -85.18415324 | 2021-07-25 04:22:12 | Russell, Alabama, US | |
3633834 | 3633834 | 2021-07-14 | US | Missouri | Camden | 29029 | 4655 | 95 | 0 | 38.02199522 | -92.76083747 | 2021-07-15 04:21:48 | Camden, Missouri, US | |
1935926 | 1935926 | 2021-07-05 | US | West Virginia | Marion | 54049 | 4655 | 52 | 0 | 39.50984542 | -80.24244659 | 2021-07-06 04:21:32 | Marion, West Virginia, US | |
1168657 | 1168657 | 2021-07-04 | US | West Virginia | Marion | 54049 | 4655 | 52 | 0 | 39.50984542 | -80.24244659 | 2021-07-05 04:21:28 | Marion, West Virginia, US | |
1499091 | 1499091 | 2021-07-03 | US | West Virginia | Marion | 54049 | 4655 | 52 | 0 | 39.50984542 | -80.24244659 | 2021-07-04 04:21:38 | Marion, West Virginia, US | |
2075406 | 2075406 | 2021-07-02 | US | West Virginia | Marion | 54049 | 4655 | 52 | 0 | 39.50984542 | -80.24244659 | 2021-07-03 04:21:37 | Marion, West Virginia, US | |
2768422 | 2768422 | 2021-07-01 | US | West Virginia | Marion | 54049 | 4655 | 52 | 0 | 39.50984542 | -80.24244659 | 2021-07-02 04:21:47 | Marion, West Virginia, US | |
1895997 | 1895997 | 2021-06-30 | US | South Dakota | Codington | 46029 | 4655 | 83 | 0 | 44.97788119 | -97.18827677 | 2021-07-01 04:21:19 | Codington, South Dakota, US | |
403120 | 403120 | 2021-06-29 | US | South Dakota | Codington | 46029 | 4655 | 83 | 0 | 44.97788119 | -97.18827677 | 2021-06-30 04:21:41 | Codington, South Dakota, US | |
3128363 | 3128363 | 2021-06-28 | US | South Dakota | Codington | 46029 | 4655 | 83 | 0 | 44.97788119 | -97.18827677 | 2021-06-29 04:21:28 | Codington, South Dakota, US | |
2885781 | 2885781 | 2021-06-20 | US | Kentucky | Hopkins | 21107 | 4655 | 148 | 0 | 37.30939025 | -87.54670406 | 2021-06-21 04:21:41 | Hopkins, Kentucky, US | |
1739426 | 1739426 | 2021-06-12 | US | Tennessee | Cheatham | 47021 | 4655 | 56 | 0 | 36.26136216 | -87.08903581 | 2021-06-13 04:22:44 | Cheatham, Tennessee, US | |
524687 | 524687 | 2021-06-09 | US | Mississippi | Panola | 28107 | 4655 | 110 | 0 | 34.36398677 | -89.95064249 | 2021-06-10 04:23:17 | Panola, Mississippi, US | |
1710948 | 1710948 | 2021-06-02 | US | Oregon | Yamhill | 41071 | 4655 | 78 | 0 | 45.23330449 | -123.3086963 | 2021-06-03 04:23:32 | Yamhill, Oregon, US | |
1709490 | 1709490 | 2021-06-02 | US | Iowa | Des Moines | 19057 | 4655 | 67 | 0 | 40.92012606 | -91.18326592 | 2021-06-03 04:23:32 | Des Moines, Iowa, US | |
1709101 | 1709101 | 2021-06-02 | US | Georgia | Effingham | 13103 | 4655 | 69 | 0 | 32.36616021 | -81.34280942 | 2021-06-03 04:23:32 | Effingham, Georgia, US | |
2104919 | 2104919 | 2021-06-01 | US | Georgia | Effingham | 13103 | 4655 | 69 | 0 | 32.36616021 | -81.34280942 | 2021-06-02 04:24:34 | Effingham, Georgia, US | |
1952535 | 1952535 | 2021-05-21 | Japan | Mie | 4655 | 101 | 4085 | 469 | 34.508018 | 136.376013 | 2021-05-22 04:20:45 | Mie, Japan | ||
1916482 | 1916482 | 2021-05-20 | US | Utah | Wasatch | 49051 | 4655 | 22 | 0 | 40.33110236 | -111.1691419 | 2021-05-21 04:20:43 | Wasatch, Utah, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);