johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
167 rows where confirmed = 4635 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1074969 | 1074969 | 2022-12-28 | US | Illinois | Wabash | 17185 | 4635 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-12-29 04:21:01 | Wabash, Illinois, US | |
545772 | 545772 | 2022-12-15 | US | Tennessee | Trousdale | 47169 | 4635 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-12-16 04:21:01 | Trousdale, Tennessee, US | |
422932 | 422932 | 2022-09-18 | US | Wisconsin | Washburn | 55129 | 4635 | 47 | 0 | 45.89838588 | -91.79050449 | 2022-09-19 04:21:49 | Washburn, Wisconsin, US | |
3376956 | 3376956 | 2022-09-17 | US | Wisconsin | Washburn | 55129 | 4635 | 47 | 0 | 45.89838588 | -91.79050449 | 2022-09-18 04:22:50 | Washburn, Wisconsin, US | |
2359064 | 2359064 | 2022-09-16 | US | Wisconsin | Washburn | 55129 | 4635 | 47 | 0 | 45.89838588 | -91.79050449 | 2022-09-17 04:20:19 | Washburn, Wisconsin, US | |
3768893 | 3768893 | 2022-09-11 | US | Texas | Andrews | 48003 | 4635 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-12 04:20:58 | Andrews, Texas, US | |
3827468 | 3827468 | 2022-09-10 | US | Texas | Andrews | 48003 | 4635 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-11 04:20:50 | Andrews, Texas, US | |
965925 | 965925 | 2022-09-09 | US | Texas | Andrews | 48003 | 4635 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-10 04:21:10 | Andrews, Texas, US | |
256847 | 256847 | 2022-09-08 | US | Wisconsin | Burnett | 55013 | 4635 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-09-09 04:21:11 | Burnett, Wisconsin, US | |
254341 | 254341 | 2022-09-08 | US | Illinois | Mercer | 17131 | 4635 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-09-09 04:21:11 | Mercer, Illinois, US | |
2713446 | 2713446 | 2022-09-03 | US | Arkansas | Clay | 5021 | 4635 | 97 | 0 | 36.36826212 | -90.4148172 | 2022-09-04 04:21:22 | Clay, Arkansas, US | |
3548580 | 3548580 | 2022-09-01 | US | Indiana | Carroll | 18015 | 4635 | 71 | 0 | 40.5807832 | -86.56198812 | 2022-09-02 04:21:07 | Carroll, Indiana, US | |
2344500 | 2344500 | 2022-08-31 | US | Indiana | Carroll | 18015 | 4635 | 71 | 0 | 40.5807832 | -86.56198812 | 2022-09-01 04:21:03 | Carroll, Indiana, US | |
1683977 | 1683977 | 2022-08-29 | US | West Virginia | Braxton | 54007 | 4635 | 48 | 0 | 38.70036159 | -80.72011184 | 2022-08-30 04:21:03 | Braxton, West Virginia, US | |
992256 | 992256 | 2022-08-16 | US | Kansas | Atchison | 20005 | 4635 | 38 | 0 | 39.53185661 | -95.30870026 | 2022-08-17 04:20:59 | Atchison, Kansas, US | |
2495295 | 2495295 | 2022-08-15 | US | Kansas | Atchison | 20005 | 4635 | 38 | 0 | 39.53185661 | -95.30870026 | 2022-08-16 04:20:58 | Atchison, Kansas, US | |
2495003 | 2495003 | 2022-08-15 | US | Illinois | Carroll | 17015 | 4635 | 49 | 0 | 42.06823429 | -89.93395545 | 2022-08-16 04:20:58 | Carroll, Illinois, US | |
3648845 | 3648845 | 2022-08-14 | US | Kansas | Atchison | 20005 | 4635 | 38 | 0 | 39.53185661 | -95.30870026 | 2022-08-15 04:20:59 | Atchison, Kansas, US | |
1969851 | 1969851 | 2022-08-13 | US | Kansas | Atchison | 20005 | 4635 | 38 | 0 | 39.53185661 | -95.30870026 | 2022-08-14 04:20:55 | Atchison, Kansas, US | |
2889660 | 2889660 | 2022-08-12 | US | Kansas | Atchison | 20005 | 4635 | 38 | 0 | 39.53185661 | -95.30870026 | 2022-08-13 04:20:52 | Atchison, Kansas, US | |
3909265 | 3909265 | 2022-08-11 | US | Kansas | Atchison | 20005 | 4635 | 38 | 0 | 39.53185661 | -95.30870026 | 2022-08-12 04:20:54 | Atchison, Kansas, US | |
1347582 | 1347582 | 2022-08-10 | US | Kansas | Atchison | 20005 | 4635 | 38 | 0 | 39.53185661 | -95.30870026 | 2022-08-11 04:20:49 | Atchison, Kansas, US | |
1068614 | 1068614 | 2022-07-28 | US | Puerto Rico | Comerio | 72045 | 4635 | 0 | 0 | 18.224687 | -66.221622 | 2022-07-29 04:20:45 | Comerio, Puerto Rico, US | |
2742565 | 2742565 | 2022-07-07 | US | Louisiana | Winn | 22127 | 4635 | 64 | 0 | 31.94449367 | -92.63789413 | 2022-07-08 04:20:56 | Winn, Louisiana, US | |
2190188 | 2190188 | 2022-06-22 | US | Oklahoma | Marshall | 40095 | 4635 | 46 | 0 | 34.02311222 | -96.76855464 | 2022-06-23 04:20:55 | Marshall, Oklahoma, US | |
168619 | 168619 | 2022-06-21 | US | Oklahoma | Marshall | 40095 | 4635 | 46 | 0 | 34.02311222 | -96.76855464 | 2022-06-22 04:20:54 | Marshall, Oklahoma, US | |
1765902 | 1765902 | 2022-06-20 | US | Oklahoma | Marshall | 40095 | 4635 | 46 | 0 | 34.02311222 | -96.76855464 | 2022-06-21 04:20:56 | Marshall, Oklahoma, US | |
3272431 | 3272431 | 2022-06-19 | US | Tennessee | Benton | 47005 | 4635 | 94 | 0 | 36.07110411 | -88.06849355 | 2022-06-20 04:21:01 | Benton, Tennessee, US | |
3272088 | 3272088 | 2022-06-19 | US | Oklahoma | Marshall | 40095 | 4635 | 46 | 0 | 34.02311222 | -96.76855464 | 2022-06-20 04:21:01 | Marshall, Oklahoma, US | |
3400000 | 3400000 | 2022-06-18 | US | Oklahoma | Marshall | 40095 | 4635 | 46 | 0 | 34.02311222 | -96.76855464 | 2022-06-19 04:20:51 | Marshall, Oklahoma, US | |
2313877 | 2313877 | 2022-06-17 | US | Oklahoma | Marshall | 40095 | 4635 | 46 | 0 | 34.02311222 | -96.76855464 | 2022-06-18 04:21:10 | Marshall, Oklahoma, US | |
561381 | 561381 | 2022-06-16 | US | Oklahoma | Marshall | 40095 | 4635 | 46 | 0 | 34.02311222 | -96.76855464 | 2022-06-17 04:20:56 | Marshall, Oklahoma, US | |
560812 | 560812 | 2022-06-16 | US | Montana | Hill | 30041 | 4635 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-06-17 04:20:56 | Hill, Montana, US | |
3985375 | 3985375 | 2022-06-15 | US | Puerto Rico | Naguabo | 72103 | 4635 | 0 | 0 | 18.230637 | -65.753897 | 2022-06-16 04:20:55 | Naguabo, Puerto Rico, US | |
3984614 | 3984614 | 2022-06-15 | US | Montana | Hill | 30041 | 4635 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-06-16 04:20:55 | Hill, Montana, US | |
948855 | 948855 | 2022-06-14 | US | Montana | Hill | 30041 | 4635 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-06-15 04:20:54 | Hill, Montana, US | |
2981263 | 2981263 | 2022-06-13 | US | Montana | Hill | 30041 | 4635 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-06-14 04:20:52 | Hill, Montana, US | |
2237389 | 2237389 | 2022-06-12 | US | Montana | Hill | 30041 | 4635 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-06-13 04:21:14 | Hill, Montana, US | |
3143587 | 3143587 | 2022-06-11 | US | Montana | Hill | 30041 | 4635 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-06-12 04:20:53 | Hill, Montana, US | |
1946503 | 1946503 | 2022-06-10 | US | Montana | Hill | 30041 | 4635 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-06-11 04:21:01 | Hill, Montana, US | |
3530660 | 3530660 | 2022-06-04 | US | Texas | Panola | 48365 | 4635 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-06-05 04:20:55 | Panola, Texas, US | |
2536603 | 2536603 | 2022-05-12 | US | Texas | Reeves | 48389 | 4635 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-05-13 04:20:51 | Reeves, Texas, US | |
225133 | 225133 | 2022-05-09 | US | Texas | Jones | 48253 | 4635 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-05-10 04:20:50 | Jones, Texas, US | |
2334518 | 2334518 | 2022-05-08 | US | Texas | Jones | 48253 | 4635 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-05-09 04:20:54 | Jones, Texas, US | |
363480 | 363480 | 2022-05-07 | US | Texas | Jones | 48253 | 4635 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-05-08 04:20:49 | Jones, Texas, US | |
1573820 | 1573820 | 2022-05-03 | US | Michigan | Roscommon | 26143 | 4635 | 114 | 0 | 44.33473082 | -84.61067651 | 2022-05-04 04:20:59 | Roscommon, Michigan, US | |
465080 | 465080 | 2022-05-02 | US | Michigan | Roscommon | 26143 | 4635 | 114 | 0 | 44.33473082 | -84.61067651 | 2022-05-03 04:21:00 | Roscommon, Michigan, US | |
463925 | 463925 | 2022-05-02 | US | Arkansas | Sharp | 5135 | 4635 | 105 | 0 | 36.16258158 | -91.47819342 | 2022-05-03 04:21:00 | Sharp, Arkansas, US | |
3917719 | 3917719 | 2022-05-01 | US | Michigan | Roscommon | 26143 | 4635 | 114 | 0 | 44.33473082 | -84.61067651 | 2022-05-02 04:21:10 | Roscommon, Michigan, US | |
3916564 | 3916564 | 2022-05-01 | US | Arkansas | Sharp | 5135 | 4635 | 105 | 0 | 36.16258158 | -91.47819342 | 2022-05-02 04:21:10 | Sharp, Arkansas, US | |
2842523 | 2842523 | 2022-04-30 | US | Michigan | Roscommon | 26143 | 4635 | 114 | 0 | 44.33473082 | -84.61067651 | 2022-05-01 04:20:57 | Roscommon, Michigan, US | |
2841368 | 2841368 | 2022-04-30 | US | Arkansas | Sharp | 5135 | 4635 | 105 | 0 | 36.16258158 | -91.47819342 | 2022-05-01 04:20:57 | Sharp, Arkansas, US | |
1158836 | 1158836 | 2022-04-29 | US | Michigan | Roscommon | 26143 | 4635 | 114 | 0 | 44.33473082 | -84.61067651 | 2022-04-30 04:21:05 | Roscommon, Michigan, US | |
1157681 | 1157681 | 2022-04-29 | US | Arkansas | Sharp | 5135 | 4635 | 105 | 0 | 36.16258158 | -91.47819342 | 2022-04-30 04:21:05 | Sharp, Arkansas, US | |
1698018 | 1698018 | 2022-04-28 | US | Michigan | Roscommon | 26143 | 4635 | 114 | 0 | 44.33473082 | -84.61067651 | 2022-04-29 04:20:59 | Roscommon, Michigan, US | |
1696863 | 1696863 | 2022-04-28 | US | Arkansas | Sharp | 5135 | 4635 | 105 | 0 | 36.16258158 | -91.47819342 | 2022-04-29 04:20:59 | Sharp, Arkansas, US | |
3853501 | 3853501 | 2022-04-27 | US | Michigan | Roscommon | 26143 | 4635 | 114 | 0 | 44.33473082 | -84.61067651 | 2022-04-28 04:20:47 | Roscommon, Michigan, US | |
2254805 | 2254805 | 2022-04-19 | US | Virginia | New Kent | 51127 | 4635 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-04-20 04:20:45 | New Kent, Virginia, US | |
1579679 | 1579679 | 2022-04-10 | US | Wisconsin | Adams | 55001 | 4635 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-04-11 04:21:02 | Adams, Wisconsin, US | |
1655921 | 1655921 | 2022-04-09 | US | Wisconsin | Adams | 55001 | 4635 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-04-10 04:20:52 | Adams, Wisconsin, US | |
2119243 | 2119243 | 2022-04-08 | US | Wisconsin | Adams | 55001 | 4635 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-04-09 04:20:42 | Adams, Wisconsin, US | |
3323767 | 3323767 | 2022-04-07 | US | Wisconsin | Adams | 55001 | 4635 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-04-08 04:20:48 | Adams, Wisconsin, US | |
26191 | 26191 | 2022-03-20 | US | Mississippi | Calhoun | 28013 | 4635 | 70 | 0 | 33.93683395 | -89.33686647 | 2022-03-21 04:20:50 | Calhoun, Mississippi, US | |
1658201 | 1658201 | 2022-03-19 | US | Mississippi | Calhoun | 28013 | 4635 | 70 | 0 | 33.93683395 | -89.33686647 | 2022-03-20 04:20:45 | Calhoun, Mississippi, US | |
337727 | 337727 | 2022-03-18 | US | Mississippi | Calhoun | 28013 | 4635 | 70 | 0 | 33.93683395 | -89.33686647 | 2022-03-19 04:20:47 | Calhoun, Mississippi, US | |
696180 | 696180 | 2022-03-17 | US | Mississippi | Calhoun | 28013 | 4635 | 70 | 0 | 33.93683395 | -89.33686647 | 2022-03-18 04:20:55 | Calhoun, Mississippi, US | |
2321123 | 2321123 | 2022-03-16 | US | Mississippi | Calhoun | 28013 | 4635 | 70 | 0 | 33.93683395 | -89.33686647 | 2022-03-17 04:20:56 | Calhoun, Mississippi, US | |
263323 | 263323 | 2022-03-15 | US | Mississippi | Calhoun | 28013 | 4635 | 70 | 0 | 33.93683395 | -89.33686647 | 2022-03-16 04:20:50 | Calhoun, Mississippi, US | |
2265682 | 2265682 | 2022-03-14 | US | Mississippi | Calhoun | 28013 | 4635 | 70 | 0 | 33.93683395 | -89.33686647 | 2022-03-15 04:20:47 | Calhoun, Mississippi, US | |
1646338 | 1646338 | 2022-03-03 | US | Missouri | Texas | 29215 | 4635 | 91 | 0 | 37.31728859 | -91.96564727 | 2022-03-04 04:21:09 | Texas, Missouri, US | |
1645149 | 1645149 | 2022-03-03 | US | Georgia | Crisp | 13081 | 4635 | 131 | 0 | 31.92289565 | -83.76811843 | 2022-03-04 04:21:09 | Crisp, Georgia, US | |
943031 | 943031 | 2022-02-28 | Russia | Chukotka Autonomous Okrug | 4635 | 41 | 0 | 66.0006475 | 169.4900869 | 2022-03-01 04:21:09 | Chukotka Autonomous Okrug, Russia | |||
2735035 | 2735035 | 2022-02-27 | US | Montana | Lincoln | 30053 | 4635 | 81 | 0 | 48.54265777 | -115.4046155 | 2022-02-28 04:21:05 | Lincoln, Montana, US | |
3048188 | 3048188 | 2022-02-26 | US | Montana | Lincoln | 30053 | 4635 | 81 | 0 | 48.54265777 | -115.4046155 | 2022-02-27 04:21:04 | Lincoln, Montana, US | |
576843 | 576843 | 2022-02-25 | US | Montana | Lincoln | 30053 | 4635 | 81 | 0 | 48.54265777 | -115.4046155 | 2022-02-26 04:21:12 | Lincoln, Montana, US | |
1298429 | 1298429 | 2022-02-17 | US | Alabama | Hale | 1065 | 4635 | 97 | 0 | 32.76039258 | -87.63284988 | 2022-02-18 04:21:04 | Hale, Alabama, US | |
2013222 | 2013222 | 2022-02-06 | US | Arkansas | Phillips | 5107 | 4635 | 84 | 0 | 34.43268455 | -90.84800154 | 2022-02-07 04:21:05 | Phillips, Arkansas, US | |
1475254 | 1475254 | 2022-01-17 | US | Texas | Karnes | 48255 | 4635 | 58 | 0 | 28.90705334 | -97.85960149 | 2022-01-18 04:21:04 | Karnes, Texas, US | |
1473203 | 1473203 | 2022-01-17 | US | Indiana | Fountain | 18045 | 4635 | 79 | 0 | 40.12361933 | -87.24217689 | 2022-01-18 04:21:04 | Fountain, Indiana, US | |
1115531 | 1115531 | 2022-01-11 | US | Missouri | Nodaway | 29147 | 4635 | 40 | 0 | 40.36079813 | -94.88133008 | 2022-01-12 04:21:44 | Nodaway, Missouri, US | |
1694259 | 1694259 | 2022-01-10 | US | Missouri | Nodaway | 29147 | 4635 | 39 | 0 | 40.36079813 | -94.88133008 | 2022-01-11 04:22:01 | Nodaway, Missouri, US | |
1255315 | 1255315 | 2021-12-20 | US | California | Calaveras | 6009 | 4635 | 91 | 0 | 38.20537103 | -120.55291299999999 | 2021-12-21 03:21:27 | Calaveras, California, US | |
1719874 | 1719874 | 2021-12-16 | US | West Virginia | Upshur | 54097 | 4635 | 72 | 0 | 38.89285061 | -80.23689136 | 2021-12-17 04:22:14 | Upshur, West Virginia, US | |
3498055 | 3498055 | 2021-12-15 | US | Mississippi | Yazoo | 28163 | 4635 | 93 | 0 | 32.77890365 | -90.39656148 | 2021-12-16 04:22:11 | Yazoo, Mississippi, US | |
3656089 | 3656089 | 2021-12-10 | US | Arkansas | Jackson | 5067 | 4635 | 47 | 0 | 35.59802983 | -91.21494602 | 2021-12-11 04:22:45 | Jackson, Arkansas, US | |
3688 | 3688 | 2021-12-02 | US | Virginia | Isle of Wight | 51093 | 4635 | 92 | 0 | 36.90579348 | -76.70842863 | 2021-12-03 04:23:05 | Isle of Wight, Virginia, US | |
1232403 | 1232403 | 2021-11-28 | US | Georgia | Chattooga | 13055 | 4635 | 106 | 0 | 34.47197698 | -85.34535662 | 2021-11-29 04:22:30 | Chattooga, Georgia, US | |
1359110 | 1359110 | 2021-11-27 | US | Georgia | Chattooga | 13055 | 4635 | 106 | 0 | 34.47197698 | -85.34535662 | 2021-11-28 04:22:43 | Chattooga, Georgia, US | |
759101 | 759101 | 2021-11-26 | US | Georgia | Chattooga | 13055 | 4635 | 106 | 0 | 34.47197698 | -85.34535662 | 2021-11-27 04:22:45 | Chattooga, Georgia, US | |
1803518 | 1803518 | 2021-11-25 | US | Georgia | Chattooga | 13055 | 4635 | 106 | 0 | 34.47197698 | -85.34535662 | 2021-11-26 04:22:33 | Chattooga, Georgia, US | |
904952 | 904952 | 2021-11-24 | US | Georgia | Chattooga | 13055 | 4635 | 106 | 0 | 34.47197698 | -85.34535662 | 2021-11-25 04:22:33 | Chattooga, Georgia, US | |
3343756 | 3343756 | 2021-11-16 | US | Indiana | Scott | 18143 | 4635 | 78 | 0 | 38.68672078 | -85.74627859 | 2021-11-17 04:21:48 | Scott, Indiana, US | |
29382 | 29382 | 2021-11-11 | US | Illinois | Bureau | 17011 | 4635 | 94 | 0 | 41.40385234 | -89.5283051 | 2021-11-12 04:22:01 | Bureau, Illinois, US | |
2845821 | 2845821 | 2021-11-10 | US | Illinois | Bureau | 17011 | 4635 | 94 | 0 | 41.40385234 | -89.5283051 | 2021-11-11 04:21:45 | Bureau, Illinois, US | |
535523 | 535523 | 2021-10-27 | US | Georgia | Dawson | 13085 | 4635 | 68 | 0 | 34.44244079 | -84.16964071 | 2021-10-28 04:22:08 | Dawson, Georgia, US | |
3794701 | 3794701 | 2021-10-25 | US | Georgia | Gilmer | 13123 | 4635 | 133 | 0 | 34.69316688 | -84.45802506 | 2021-10-26 04:22:09 | Gilmer, Georgia, US | |
1911439 | 1911439 | 2021-10-17 | US | New York | Chenango | 36017 | 4635 | 86 | 0 | 42.49430041 | -75.60887553 | 2021-10-18 04:21:10 | Chenango, New York, US | |
2946029 | 2946029 | 2021-10-15 | US | Pennsylvania | Greene | 42059 | 4635 | 52 | 0 | 39.85746531 | -80.22357106 | 2021-10-16 04:21:15 | Greene, Pennsylvania, US | |
3833996 | 3833996 | 2021-10-05 | US | Louisiana | Jefferson Davis | 22053 | 4635 | 121 | 0 | 30.26896765 | -92.81210004 | 2021-10-06 04:21:33 | Jefferson Davis, Louisiana, US | |
2776372 | 2776372 | 2021-09-30 | US | Virginia | Prince George | 51149 | 4635 | 35 | 0 | 37.18497668 | -77.22922187 | 2021-10-01 04:21:35 | Prince George, Virginia, 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]);