johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
159 rows where confirmed = 5012 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754383 | 2754383 | 2022-12-29 | US | Kentucky | Trigg | 21221 | 5012 | 49 | 0 | 36.80767017 | -87.87333656 | 2022-12-30 04:21:04 | Trigg, Kentucky, US | |
1075389 | 1075389 | 2022-12-28 | US | Kentucky | Trigg | 21221 | 5012 | 49 | 0 | 36.80767017 | -87.87333656 | 2022-12-29 04:21:01 | Trigg, Kentucky, US | |
329386 | 329386 | 2022-12-27 | US | Kentucky | Trigg | 21221 | 5012 | 49 | 0 | 36.80767017 | -87.87333656 | 2022-12-28 04:21:04 | Trigg, Kentucky, US | |
1986427 | 1986427 | 2022-12-07 | US | Minnesota | Wadena | 27159 | 5012 | 64 | 0 | 46.58589171 | -94.96968506 | 2022-12-08 04:21:07 | Wadena, Minnesota, US | |
3715950 | 3715950 | 2022-12-06 | US | Minnesota | Wadena | 27159 | 5012 | 64 | 0 | 46.58589171 | -94.96968506 | 2022-12-07 04:20:58 | Wadena, Minnesota, US | |
2416655 | 2416655 | 2022-12-05 | US | Minnesota | Wadena | 27159 | 5012 | 64 | 0 | 46.58589171 | -94.96968506 | 2022-12-06 04:21:03 | Wadena, Minnesota, US | |
721989 | 721989 | 2022-12-04 | US | West Virginia | Morgan | 54065 | 5012 | 76 | 0 | 39.55439028 | -78.26311676 | 2022-12-05 04:20:58 | Morgan, West Virginia, US | |
720263 | 720263 | 2022-12-04 | US | Minnesota | Wadena | 27159 | 5012 | 64 | 0 | 46.58589171 | -94.96968506 | 2022-12-05 04:20:58 | Wadena, Minnesota, US | |
2820278 | 2820278 | 2022-12-03 | US | West Virginia | Morgan | 54065 | 5012 | 76 | 0 | 39.55439028 | -78.26311676 | 2022-12-04 04:20:56 | Morgan, West Virginia, US | |
2818552 | 2818552 | 2022-12-03 | US | Minnesota | Wadena | 27159 | 5012 | 64 | 0 | 46.58589171 | -94.96968506 | 2022-12-04 04:20:56 | Wadena, Minnesota, US | |
837134 | 837134 | 2022-12-02 | US | West Virginia | Morgan | 54065 | 5012 | 76 | 0 | 39.55439028 | -78.26311676 | 2022-12-03 04:21:02 | Morgan, West Virginia, US | |
835408 | 835408 | 2022-12-02 | US | Minnesota | Wadena | 27159 | 5012 | 64 | 0 | 46.58589171 | -94.96968506 | 2022-12-03 04:21:02 | Wadena, Minnesota, US | |
2138179 | 2138179 | 2022-12-01 | US | Montana | Park | 30067 | 5012 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-12-02 04:21:07 | Park, Montana, US | |
2137938 | 2137938 | 2022-12-01 | US | Minnesota | Wadena | 27159 | 5012 | 64 | 0 | 46.58589171 | -94.96968506 | 2022-12-02 04:21:07 | Wadena, Minnesota, US | |
1966595 | 1966595 | 2022-11-30 | US | Montana | Park | 30067 | 5012 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-12-01 04:21:03 | Park, Montana, US | |
2558609 | 2558609 | 2022-11-29 | US | Montana | Park | 30067 | 5012 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-30 04:21:07 | Park, Montana, US | |
1242587 | 1242587 | 2022-11-28 | US | Tennessee | Cannon | 47015 | 5012 | 75 | 0 | 35.80990797 | -86.05738983 | 2022-11-29 04:21:05 | Cannon, Tennessee, US | |
1241683 | 1241683 | 2022-11-28 | US | Montana | Park | 30067 | 5012 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-29 04:21:05 | Park, Montana, US | |
3553671 | 3553671 | 2022-11-27 | US | Montana | Park | 30067 | 5012 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-28 04:21:02 | Park, Montana, US | |
3552633 | 3552633 | 2022-11-27 | US | Illinois | De Witt | 17039 | 5012 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-11-28 04:21:02 | De Witt, Illinois, US | |
2102151 | 2102151 | 2022-11-26 | US | Montana | Park | 30067 | 5012 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-27 04:21:05 | Park, Montana, US | |
2101113 | 2101113 | 2022-11-26 | US | Illinois | De Witt | 17039 | 5012 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-11-27 04:21:05 | De Witt, Illinois, US | |
489642 | 489642 | 2022-11-25 | US | Montana | Park | 30067 | 5012 | 39 | 0 | 45.48965095 | -110.5264394 | 2022-11-26 04:21:11 | Park, Montana, US | |
488604 | 488604 | 2022-11-25 | US | Illinois | De Witt | 17039 | 5012 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-11-26 04:21:11 | De Witt, Illinois, US | |
3524433 | 3524433 | 2022-11-24 | US | Illinois | De Witt | 17039 | 5012 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-11-25 04:21:06 | De Witt, Illinois, US | |
3313216 | 3313216 | 2022-11-23 | US | Illinois | De Witt | 17039 | 5012 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-11-24 04:21:09 | De Witt, Illinois, US | |
2431902 | 2431902 | 2022-11-09 | US | Illinois | Bond | 17005 | 5012 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-11-10 04:21:16 | Bond, Illinois, US | |
2260762 | 2260762 | 2022-10-02 | US | Illinois | Hancock | 17067 | 5012 | 50 | 0 | 40.40423981 | -91.16313899 | 2022-10-03 04:23:11 | Hancock, Illinois, US | |
2998064 | 2998064 | 2022-10-01 | US | Puerto Rico | Penuelas | 72111 | 5012 | 0 | 0 | 18.059645 | -66.721572 | 2022-10-02 04:21:23 | Penuelas, Puerto Rico, US | |
2996288 | 2996288 | 2022-10-01 | US | Illinois | Hancock | 17067 | 5012 | 50 | 0 | 40.40423981 | -91.16313899 | 2022-10-02 04:21:23 | Hancock, Illinois, US | |
854614 | 854614 | 2022-09-30 | US | Illinois | Hancock | 17067 | 5012 | 50 | 0 | 40.40423981 | -91.16313899 | 2022-10-01 04:23:01 | Hancock, Illinois, US | |
2634268 | 2634268 | 2022-09-05 | US | California | Colusa | 6011 | 5012 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-09-06 04:21:02 | Colusa, California, US | |
3775476 | 3775476 | 2022-08-30 | US | Maine | Washington | 23029 | 5012 | 60 | 0 | 45.01607142 | -67.62813524 | 2022-08-31 04:20:57 | Washington, Maine, US | |
1162174 | 1162174 | 2022-08-18 | US | Illinois | Johnson | 17087 | 5012 | 41 | 0 | 37.45939802 | -88.88165419 | 2022-08-19 04:20:54 | Johnson, Illinois, US | |
3620182 | 3620182 | 2022-08-01 | US | Texas | Gonzales | 48177 | 5012 | 103 | 0 | 29.45634206 | -97.49424032 | 2022-08-02 04:20:53 | Gonzales, Texas, US | |
3618766 | 3618766 | 2022-08-01 | US | Michigan | Roscommon | 26143 | 5012 | 120 | 0 | 44.33473082 | -84.61067651 | 2022-08-02 04:20:53 | Roscommon, Michigan, US | |
3873246 | 3873246 | 2022-07-31 | US | Michigan | Roscommon | 26143 | 5012 | 120 | 0 | 44.33473082 | -84.61067651 | 2022-08-01 04:21:03 | Roscommon, Michigan, US | |
676000 | 676000 | 2022-07-30 | US | Michigan | Roscommon | 26143 | 5012 | 120 | 0 | 44.33473082 | -84.61067651 | 2022-07-31 04:21:02 | Roscommon, Michigan, US | |
1785199 | 1785199 | 2022-07-29 | US | Michigan | Roscommon | 26143 | 5012 | 120 | 0 | 44.33473082 | -84.61067651 | 2022-07-30 04:20:42 | Roscommon, Michigan, US | |
1067562 | 1067562 | 2022-07-28 | US | Michigan | Roscommon | 26143 | 5012 | 120 | 0 | 44.33473082 | -84.61067651 | 2022-07-29 04:20:45 | Roscommon, Michigan, US | |
2337081 | 2337081 | 2022-07-27 | US | Michigan | Roscommon | 26143 | 5012 | 120 | 0 | 44.33473082 | -84.61067651 | 2022-07-28 04:20:56 | Roscommon, Michigan, US | |
1489271 | 1489271 | 2022-07-26 | US | Michigan | Roscommon | 26143 | 5012 | 120 | 0 | 44.33473082 | -84.61067651 | 2022-07-27 04:21:04 | Roscommon, Michigan, US | |
903149 | 903149 | 2022-07-22 | US | Tennessee | Polk | 47139 | 5012 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-07-23 04:20:53 | Polk, Tennessee, US | |
1212055 | 1212055 | 2022-07-11 | US | Arkansas | Lincoln | 5079 | 5012 | 69 | 0 | 33.95317155 | -91.74002806 | 2022-07-12 04:20:51 | Lincoln, Arkansas, US | |
2790440 | 2790440 | 2022-07-10 | US | Kentucky | Garrard | 21079 | 5012 | 80 | 0 | 37.6388668 | -84.53289319 | 2022-07-11 04:20:46 | Garrard, Kentucky, US | |
2789537 | 2789537 | 2022-07-10 | US | Arkansas | Lincoln | 5079 | 5012 | 69 | 0 | 33.95317155 | -91.74002806 | 2022-07-11 04:20:46 | Lincoln, Arkansas, US | |
143393 | 143393 | 2022-07-09 | US | Kentucky | Garrard | 21079 | 5012 | 80 | 0 | 37.6388668 | -84.53289319 | 2022-07-10 04:20:54 | Garrard, Kentucky, US | |
1418493 | 1418493 | 2022-07-08 | US | Kentucky | Garrard | 21079 | 5012 | 80 | 0 | 37.6388668 | -84.53289319 | 2022-07-09 04:20:59 | Garrard, Kentucky, US | |
2742418 | 2742418 | 2022-07-07 | US | Kentucky | Garrard | 21079 | 5012 | 80 | 0 | 37.6388668 | -84.53289319 | 2022-07-08 04:20:56 | Garrard, Kentucky, US | |
2741565 | 2741565 | 2022-07-07 | US | California | Inyo | 6027 | 5012 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-07-08 04:20:56 | Inyo, California, US | |
1201213 | 1201213 | 2022-07-06 | US | Kentucky | Garrard | 21079 | 5012 | 80 | 0 | 37.6388668 | -84.53289319 | 2022-07-07 04:20:55 | Garrard, Kentucky, US | |
3967956 | 3967956 | 2022-07-05 | US | Kentucky | Garrard | 21079 | 5012 | 80 | 0 | 37.6388668 | -84.53289319 | 2022-07-06 04:20:58 | Garrard, Kentucky, US | |
3941150 | 3941150 | 2022-06-30 | US | Indiana | Fulton | 18049 | 5012 | 103 | 0 | 41.0469907 | -86.26252745 | 2022-07-01 04:21:10 | Fulton, Indiana, US | |
2491108 | 2491108 | 2022-06-29 | US | Indiana | Fulton | 18049 | 5012 | 103 | 0 | 41.0469907 | -86.26252745 | 2022-06-30 04:21:01 | Fulton, Indiana, US | |
561984 | 561984 | 2022-06-16 | US | Texas | Milam | 48331 | 5012 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-06-17 04:20:56 | Milam, Texas, US | |
1947717 | 1947717 | 2022-06-10 | US | Texas | Scurry | 48415 | 5012 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-11 04:21:01 | Scurry, Texas, US | |
1111390 | 1111390 | 2022-05-21 | US | Mississippi | Jasper | 28061 | 5012 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-22 04:20:52 | Jasper, Mississippi, US | |
1171014 | 1171014 | 2022-05-20 | US | Mississippi | Jasper | 28061 | 5012 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-21 04:20:58 | Jasper, Mississippi, US | |
3897777 | 3897777 | 2022-05-19 | US | Mississippi | Jasper | 28061 | 5012 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-20 04:20:57 | Jasper, Mississippi, US | |
1186561 | 1186561 | 2022-05-18 | US | Mississippi | Jasper | 28061 | 5012 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-19 04:20:54 | Jasper, Mississippi, US | |
3584458 | 3584458 | 2022-05-17 | US | Mississippi | Jasper | 28061 | 5012 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-18 04:20:50 | Jasper, Mississippi, US | |
1505415 | 1505415 | 2022-05-16 | US | Mississippi | Jasper | 28061 | 5012 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-05-17 04:20:59 | Jasper, Mississippi, US | |
466221 | 466221 | 2022-05-02 | US | South Carolina | Hampton | 45049 | 5012 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-05-03 04:21:00 | Hampton, South Carolina, US | |
465605 | 465605 | 2022-05-02 | US | New Mexico | Roosevelt | 35041 | 5012 | 94 | 0 | 34.02097406 | -103.4799493 | 2022-05-03 04:21:00 | Roosevelt, New Mexico, US | |
3918860 | 3918860 | 2022-05-01 | US | South Carolina | Hampton | 45049 | 5012 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-05-02 04:21:10 | Hampton, South Carolina, US | |
2843664 | 2843664 | 2022-04-30 | US | South Carolina | Hampton | 45049 | 5012 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-05-01 04:20:57 | Hampton, South Carolina, US | |
1159977 | 1159977 | 2022-04-29 | US | South Carolina | Hampton | 45049 | 5012 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-04-30 04:21:05 | Hampton, South Carolina, US | |
1699159 | 1699159 | 2022-04-28 | US | South Carolina | Hampton | 45049 | 5012 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-04-29 04:20:59 | Hampton, South Carolina, US | |
3420394 | 3420394 | 2022-04-17 | US | West Virginia | Brooke | 54009 | 5012 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-04-18 04:21:12 | Brooke, West Virginia, US | |
307343 | 307343 | 2022-04-16 | US | West Virginia | Brooke | 54009 | 5012 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-04-17 04:20:59 | Brooke, West Virginia, US | |
2673288 | 2673288 | 2022-04-15 | US | West Virginia | Brooke | 54009 | 5012 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-04-16 04:20:48 | Brooke, West Virginia, US | |
3869930 | 3869930 | 2022-04-05 | US | North Carolina | Yancey | 37199 | 5012 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-06 04:20:49 | Yancey, North Carolina, US | |
1722048 | 1722048 | 2022-03-25 | US | Maine | Sagadahoc | 23023 | 5012 | 29 | 0 | 43.95415864 | -69.85074999 | 2022-03-26 04:20:23 | Sagadahoc, Maine, US | |
3024914 | 3024914 | 2022-03-23 | US | Oregon | Union | 41061 | 5012 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-24 04:20:43 | Union, Oregon, US | |
1907836 | 1907836 | 2022-03-22 | US | Oregon | Union | 41061 | 5012 | 74 | 0 | 45.30915495 | -118.0068979 | 2022-03-23 04:20:48 | Union, Oregon, US | |
3239364 | 3239364 | 2022-03-21 | US | Illinois | Pike | 17149 | 5012 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-22 04:20:54 | Pike, Illinois, US | |
25437 | 25437 | 2022-03-20 | US | Illinois | Pike | 17149 | 5012 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-21 04:20:50 | Pike, Illinois, US | |
1657447 | 1657447 | 2022-03-19 | US | Illinois | Pike | 17149 | 5012 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-20 04:20:45 | Pike, Illinois, US | |
336973 | 336973 | 2022-03-18 | US | Illinois | Pike | 17149 | 5012 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-19 04:20:47 | Pike, Illinois, US | |
2142113 | 2142113 | 2022-03-09 | US | Missouri | New Madrid | 29143 | 5012 | 83 | 0 | 36.59666326 | -89.66070007 | 2022-03-10 04:20:48 | New Madrid, Missouri, US | |
2201981 | 2201981 | 2022-03-06 | US | North Carolina | Madison | 37115 | 5012 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-07 04:20:47 | Madison, North Carolina, US | |
2094438 | 2094438 | 2022-03-05 | US | North Carolina | Madison | 37115 | 5012 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-06 04:20:49 | Madison, North Carolina, US | |
2668138 | 2668138 | 2022-03-04 | US | North Carolina | Madison | 37115 | 5012 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-05 04:21:10 | Madison, North Carolina, US | |
2667357 | 2667357 | 2022-03-04 | US | Maine | Lincoln | 23015 | 5012 | 30 | 0 | 44.05996956 | -69.54227124 | 2022-03-05 04:21:10 | Lincoln, Maine, US | |
1513386 | 1513386 | 2022-02-24 | US | Missouri | Vernon | 29217 | 5012 | 101 | 0 | 37.8457799 | -94.34127305 | 2022-02-25 04:21:11 | Vernon, Missouri, US | |
3915569 | 3915569 | 2022-02-20 | US | Wisconsin | Green Lake | 55047 | 5012 | 58 | 0 | 43.80025981 | -89.04679553 | 2022-02-21 04:21:05 | Green Lake, Wisconsin, US | |
3879127 | 3879127 | 2022-02-19 | US | Wisconsin | Green Lake | 55047 | 5012 | 58 | 0 | 43.80025981 | -89.04679553 | 2022-02-20 04:21:00 | Green Lake, Wisconsin, US | |
3859383 | 3859383 | 2022-02-18 | US | Wisconsin | Green Lake | 55047 | 5012 | 58 | 0 | 43.80025981 | -89.04679553 | 2022-02-19 04:21:11 | Green Lake, Wisconsin, US | |
1301602 | 1301602 | 2022-02-17 | US | Wisconsin | Green Lake | 55047 | 5012 | 59 | 0 | 43.80025981 | -89.04679553 | 2022-02-18 04:21:04 | Green Lake, Wisconsin, US | |
1299608 | 1299608 | 2022-02-17 | US | Maine | Franklin | 23007 | 5012 | 50 | 0 | 44.97330019 | -70.44381045 | 2022-02-18 04:21:04 | Franklin, Maine, US | |
187054 | 187054 | 2022-02-13 | US | Illinois | Edgar | 17045 | 5012 | 56 | 0 | 39.6809186 | -87.74759563 | 2022-02-14 04:20:51 | Edgar, Illinois, US | |
316900 | 316900 | 2022-02-12 | US | Illinois | Edgar | 17045 | 5012 | 56 | 0 | 39.6809186 | -87.74759563 | 2022-02-13 04:21:00 | Edgar, Illinois, US | |
234226 | 234226 | 2022-02-11 | US | Illinois | Edgar | 17045 | 5012 | 56 | 0 | 39.6809186 | -87.74759563 | 2022-02-12 04:21:06 | Edgar, Illinois, US | |
1465068 | 1465068 | 2022-02-10 | US | Illinois | Edgar | 17045 | 5012 | 56 | 0 | 39.6809186 | -87.74759563 | 2022-02-11 04:21:09 | Edgar, Illinois, US | |
1362824 | 1362824 | 2022-02-08 | US | Arkansas | Clark | 5019 | 5012 | 72 | 0 | 34.04613432 | -93.17484713 | 2022-02-09 04:21:04 | Clark, Arkansas, US | |
2658336 | 2658336 | 2022-01-31 | US | California | Del Norte | 6015 | 5012 | 43 | 0 | 41.74228275 | -123.89740630000001 | 2022-02-01 04:21:11 | Del Norte, California, US | |
555898 | 555898 | 2022-01-16 | US | Indiana | LaGrange | 18087 | 5012 | 96 | 0 | 41.64232188 | -85.42674232 | 2022-01-17 04:21:08 | LaGrange, Indiana, US | |
3841619 | 3841619 | 2022-01-15 | US | Indiana | LaGrange | 18087 | 5012 | 96 | 0 | 41.64232188 | -85.42674232 | 2022-01-16 04:21:12 | LaGrange, Indiana, US | |
100434 | 100434 | 2022-01-14 | US | Indiana | LaGrange | 18087 | 5012 | 96 | 0 | 41.64232188 | -85.42674232 | 2022-01-15 04:21:07 | LaGrange, Indiana, US | |
1287877 | 1287877 | 2022-01-04 | US | Missouri | Barry | 29009 | 5012 | 97 | 0 | 36.70978521 | -93.82919888 | 2022-01-05 04:21:59 | Barry, Missouri, 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]);