johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
124 rows where confirmed = 5621 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755586 | 2755586 | 2022-12-29 | US | Pennsylvania | Juniata | 42067 | 5621 | 191 | 0 | 40.53358749 | -77.3997513 | 2022-12-30 04:21:04 | Juniata, Pennsylvania, US | |
1076592 | 1076592 | 2022-12-28 | US | Pennsylvania | Juniata | 42067 | 5621 | 191 | 0 | 40.53358749 | -77.3997513 | 2022-12-29 04:21:01 | Juniata, Pennsylvania, US | |
3380966 | 3380966 | 2022-12-08 | US | Wisconsin | Taylor | 55119 | 5621 | 77 | 0 | 45.21179252 | -90.5004405 | 2022-12-09 04:21:05 | Taylor, Wisconsin, US | |
480567 | 480567 | 2022-11-08 | US | Illinois | Clark | 17023 | 5621 | 53 | 0 | 39.33425789 | -87.78705622 | 2022-11-09 04:21:22 | Clark, Illinois, US | |
2439717 | 2439717 | 2022-11-07 | US | Illinois | Clark | 17023 | 5621 | 53 | 0 | 39.33425789 | -87.78705622 | 2022-11-08 04:21:21 | Clark, Illinois, US | |
431981 | 431981 | 2022-11-03 | US | Colorado | Elbert | 8039 | 5621 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-11-04 04:22:11 | Elbert, Colorado, US | |
711589 | 711589 | 2022-11-01 | US | Indiana | Rush | 18139 | 5621 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-11-02 04:22:09 | Rush, Indiana, US | |
3286038 | 3286038 | 2022-10-31 | US | Indiana | Rush | 18139 | 5621 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-11-01 04:22:36 | Rush, Indiana, US | |
321071 | 321071 | 2022-10-30 | US | Indiana | Rush | 18139 | 5621 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-31 04:21:36 | Rush, Indiana, US | |
913347 | 913347 | 2022-10-29 | US | Indiana | Rush | 18139 | 5621 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-30 04:22:14 | Rush, Indiana, US | |
1367616 | 1367616 | 2022-10-28 | US | Indiana | Rush | 18139 | 5621 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-29 04:21:13 | Rush, Indiana, US | |
3039471 | 3039471 | 2022-10-27 | US | Indiana | Rush | 18139 | 5621 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-28 04:22:31 | Rush, Indiana, US | |
539891 | 539891 | 2022-10-26 | US | Indiana | Rush | 18139 | 5621 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-27 04:22:01 | Rush, Indiana, US | |
255254 | 255254 | 2022-09-08 | US | Missouri | New Madrid | 29143 | 5621 | 87 | 0 | 36.59666326 | -89.66070007 | 2022-09-09 04:21:11 | New Madrid, Missouri, US | |
3747052 | 3747052 | 2022-09-07 | US | Missouri | New Madrid | 29143 | 5621 | 87 | 0 | 36.59666326 | -89.66070007 | 2022-09-08 04:21:02 | New Madrid, Missouri, US | |
116692 | 116692 | 2022-09-06 | US | Missouri | New Madrid | 29143 | 5621 | 87 | 0 | 36.59666326 | -89.66070007 | 2022-09-07 04:20:59 | New Madrid, Missouri, US | |
2635664 | 2635664 | 2022-09-05 | US | Missouri | New Madrid | 29143 | 5621 | 87 | 0 | 36.59666326 | -89.66070007 | 2022-09-06 04:21:02 | New Madrid, Missouri, US | |
2989228 | 2989228 | 2022-09-04 | US | Missouri | New Madrid | 29143 | 5621 | 87 | 0 | 36.59666326 | -89.66070007 | 2022-09-05 04:21:01 | New Madrid, Missouri, US | |
2714913 | 2714913 | 2022-09-03 | US | Missouri | New Madrid | 29143 | 5621 | 87 | 0 | 36.59666326 | -89.66070007 | 2022-09-04 04:21:22 | New Madrid, Missouri, US | |
1395618 | 1395618 | 2022-09-02 | US | Missouri | New Madrid | 29143 | 5621 | 87 | 0 | 36.59666326 | -89.66070007 | 2022-09-03 04:21:04 | New Madrid, Missouri, US | |
1086882 | 1086882 | 2022-08-09 | US | Georgia | Franklin | 13119 | 5621 | 104 | 0 | 34.37525597 | -83.23159927 | 2022-08-10 04:20:57 | Franklin, Georgia, US | |
3544297 | 3544297 | 2022-08-08 | US | Georgia | Franklin | 13119 | 5621 | 104 | 0 | 34.37525597 | -83.23159927 | 2022-08-09 04:20:34 | Franklin, Georgia, US | |
1070700 | 1070700 | 2022-08-07 | US | Georgia | Franklin | 13119 | 5621 | 104 | 0 | 34.37525597 | -83.23159927 | 2022-08-08 04:21:08 | Franklin, Georgia, US | |
1941288 | 1941288 | 2022-08-06 | US | Georgia | Franklin | 13119 | 5621 | 104 | 0 | 34.37525597 | -83.23159927 | 2022-08-07 04:20:54 | Franklin, Georgia, US | |
881087 | 881087 | 2022-08-05 | US | Georgia | Franklin | 13119 | 5621 | 104 | 0 | 34.37525597 | -83.23159927 | 2022-08-06 04:20:56 | Franklin, Georgia, US | |
2009498 | 2009498 | 2022-08-04 | US | Georgia | Franklin | 13119 | 5621 | 104 | 0 | 34.37525597 | -83.23159927 | 2022-08-05 04:20:52 | Franklin, Georgia, US | |
1098925 | 1098925 | 2022-08-03 | US | Georgia | Franklin | 13119 | 5621 | 104 | 0 | 34.37525597 | -83.23159927 | 2022-08-04 04:20:58 | Franklin, Georgia, US | |
959714 | 959714 | 2022-07-19 | US | Georgia | Haralson | 13143 | 5621 | 178 | 0 | 33.79602175 | -85.21005667 | 2022-07-20 04:20:59 | Haralson, Georgia, US | |
3211101 | 3211101 | 2022-07-18 | US | Georgia | Haralson | 13143 | 5621 | 178 | 0 | 33.79602175 | -85.21005667 | 2022-07-19 04:20:58 | Haralson, Georgia, US | |
3406276 | 3406276 | 2022-07-17 | US | Georgia | Haralson | 13143 | 5621 | 178 | 0 | 33.79602175 | -85.21005667 | 2022-07-18 04:20:59 | Haralson, Georgia, US | |
2152476 | 2152476 | 2022-07-16 | US | Georgia | Haralson | 13143 | 5621 | 178 | 0 | 33.79602175 | -85.21005667 | 2022-07-17 04:21:15 | Haralson, Georgia, US | |
2419709 | 2419709 | 2022-07-15 | US | Georgia | Haralson | 13143 | 5621 | 178 | 0 | 33.79602175 | -85.21005667 | 2022-07-16 04:21:05 | Haralson, Georgia, US | |
3429784 | 3429784 | 2022-07-14 | US | Georgia | Haralson | 13143 | 5621 | 178 | 0 | 33.79602175 | -85.21005667 | 2022-07-15 04:20:53 | Haralson, Georgia, US | |
3110304 | 3110304 | 2022-07-13 | US | Georgia | Haralson | 13143 | 5621 | 178 | 0 | 33.79602175 | -85.21005667 | 2022-07-14 04:20:57 | Haralson, Georgia, US | |
1200280 | 1200280 | 2022-07-06 | US | Arkansas | Clark | 5019 | 5621 | 82 | 0 | 34.04613432 | -93.17484713 | 2022-07-07 04:20:55 | Clark, Arkansas, US | |
3969648 | 3969648 | 2022-07-05 | US | Texas | Gillespie | 48171 | 5621 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-07-06 04:20:58 | Gillespie, Texas, US | |
1947501 | 1947501 | 2022-06-10 | US | Tennessee | Union | 47173 | 5621 | 78 | 0 | 36.28590426 | -83.83651902 | 2022-06-11 04:21:01 | Union, Tennessee, US | |
1575524 | 1575524 | 2022-05-03 | US | Virginia | Page | 51139 | 5621 | 120 | 0 | 38.61807452 | -78.48797204 | 2022-05-04 04:20:59 | Page, Virginia, US | |
466784 | 466784 | 2022-05-02 | US | Virginia | Page | 51139 | 5621 | 120 | 0 | 38.61807452 | -78.48797204 | 2022-05-03 04:21:00 | Page, Virginia, US | |
3853558 | 3853558 | 2022-04-27 | US | Minnesota | Martin | 27091 | 5621 | 64 | 0 | 43.67429718 | -94.55099908 | 2022-04-28 04:20:47 | Martin, Minnesota, US | |
2253105 | 2253105 | 2022-04-19 | US | Michigan | Otsego | 26137 | 5621 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-04-20 04:20:45 | Otsego, Michigan, US | |
1847655 | 1847655 | 2022-04-18 | US | Michigan | Otsego | 26137 | 5621 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-04-19 04:21:00 | Otsego, Michigan, US | |
3418599 | 3418599 | 2022-04-17 | US | Michigan | Otsego | 26137 | 5621 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-04-18 04:21:12 | Otsego, Michigan, US | |
305548 | 305548 | 2022-04-16 | US | Michigan | Otsego | 26137 | 5621 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-04-17 04:20:59 | Otsego, Michigan, US | |
2671493 | 2671493 | 2022-04-15 | US | Michigan | Otsego | 26137 | 5621 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-04-16 04:20:48 | Otsego, Michigan, US | |
1225278 | 1225278 | 2022-04-14 | US | Michigan | Otsego | 26137 | 5621 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-04-15 04:20:57 | Otsego, Michigan, US | |
2444436 | 2444436 | 2022-04-13 | US | Michigan | Otsego | 26137 | 5621 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-04-13 23:21:06 | Otsego, Michigan, US | |
1950178 | 1950178 | 2022-04-12 | US | Michigan | Menominee | 26109 | 5621 | 70 | 0 | 45.58038692 | -87.55370409 | 2022-04-13 04:21:03 | Menominee, Michigan, US | |
3207931 | 3207931 | 2022-04-11 | US | Michigan | Menominee | 26109 | 5621 | 70 | 0 | 45.58038692 | -87.55370409 | 2022-04-12 04:20:49 | Menominee, Michigan, US | |
1577817 | 1577817 | 2022-04-10 | US | Michigan | Menominee | 26109 | 5621 | 70 | 0 | 45.58038692 | -87.55370409 | 2022-04-11 04:21:02 | Menominee, Michigan, US | |
1654059 | 1654059 | 2022-04-09 | US | Michigan | Menominee | 26109 | 5621 | 70 | 0 | 45.58038692 | -87.55370409 | 2022-04-10 04:20:52 | Menominee, Michigan, US | |
2117381 | 2117381 | 2022-04-08 | US | Michigan | Menominee | 26109 | 5621 | 70 | 0 | 45.58038692 | -87.55370409 | 2022-04-09 04:20:42 | Menominee, Michigan, US | |
3321905 | 3321905 | 2022-04-07 | US | Michigan | Menominee | 26109 | 5621 | 70 | 0 | 45.58038692 | -87.55370409 | 2022-04-08 04:20:48 | Menominee, Michigan, US | |
2802441 | 2802441 | 2022-04-06 | US | Michigan | Menominee | 26109 | 5621 | 70 | 0 | 45.58038692 | -87.55370409 | 2022-04-07 04:20:53 | Menominee, Michigan, US | |
1543373 | 1543373 | 2022-03-31 | US | Virginia | Staunton | 51790 | 5621 | 110 | 0 | 38.15965544 | -79.05979937 | 2022-04-01 04:20:28 | Staunton, Virginia, US | |
2481386 | 2481386 | 2022-03-30 | US | Virginia | Staunton | 51790 | 5621 | 110 | 0 | 38.15965544 | -79.05979937 | 2022-03-31 04:20:56 | Staunton, Virginia, US | |
3239883 | 3239883 | 2022-03-21 | US | Maine | Franklin | 23007 | 5621 | 57 | 0 | 44.97330019 | -70.44381045 | 2022-03-22 04:20:54 | Franklin, Maine, US | |
25956 | 25956 | 2022-03-20 | US | Maine | Franklin | 23007 | 5621 | 57 | 0 | 44.97330019 | -70.44381045 | 2022-03-21 04:20:50 | Franklin, Maine, US | |
1657966 | 1657966 | 2022-03-19 | US | Maine | Franklin | 23007 | 5621 | 57 | 0 | 44.97330019 | -70.44381045 | 2022-03-20 04:20:45 | Franklin, Maine, US | |
337492 | 337492 | 2022-03-18 | US | Maine | Franklin | 23007 | 5621 | 57 | 0 | 44.97330019 | -70.44381045 | 2022-03-19 04:20:47 | Franklin, Maine, US | |
235995 | 235995 | 2022-02-11 | US | Puerto Rico | Juncos | 72077 | 5621 | 0 | 0 | 18.223793 | -65.909109 | 2022-02-12 04:21:06 | Juncos, Puerto Rico, US | |
2016296 | 2016296 | 2022-02-06 | US | Wisconsin | Vernon | 55123 | 5621 | 83 | 0 | 43.59422667 | -90.8324691 | 2022-02-07 04:21:05 | Vernon, Wisconsin, US | |
1297625 | 1297625 | 2022-02-05 | US | Wisconsin | Vernon | 55123 | 5621 | 83 | 0 | 43.59422667 | -90.8324691 | 2022-02-06 04:21:00 | Vernon, Wisconsin, US | |
2330953 | 2330953 | 2022-02-04 | US | Wisconsin | Vernon | 55123 | 5621 | 83 | 0 | 43.59422667 | -90.8324691 | 2022-02-05 04:21:05 | Vernon, Wisconsin, US | |
1782114 | 1782114 | 2022-01-27 | US | Puerto Rico | Canovanas | 72029 | 5621 | 0 | 0 | 18.328802 | -65.887612 | 2022-01-28 04:21:09 | Canovanas, Puerto Rico, US | |
1320186 | 1320186 | 2022-01-26 | US | Missouri | Stoddard | 29207 | 5621 | 112 | 0 | 36.85571651 | -89.9444155 | 2022-01-27 04:21:19 | Stoddard, Missouri, US | |
1229099 | 1229099 | 2022-01-24 | US | Kentucky | Woodford | 21239 | 5621 | 39 | 0 | 38.04178222 | -84.7417556 | 2022-01-25 04:21:05 | Woodford, Kentucky, US | |
1228661 | 1228661 | 2022-01-24 | US | Illinois | Shelby | 17173 | 5621 | 63 | 0 | 39.39133527 | -88.80611122 | 2022-01-25 04:21:05 | Shelby, Illinois, US | |
3521170 | 3521170 | 2022-01-02 | US | Minnesota | Lyon | 27083 | 5621 | 66 | 0 | 44.41327865 | -95.83806103 | 2022-01-03 02:22:25 | Lyon, Minnesota, US | |
2169300 | 2169300 | 2022-01-01 | US | Minnesota | Lyon | 27083 | 5621 | 66 | 0 | 44.41327865 | -95.83806103 | 2022-01-02 04:20:52 | Lyon, Minnesota, US | |
2778731 | 2778731 | 2021-12-31 | US | Minnesota | Lyon | 27083 | 5621 | 66 | 0 | 44.41327865 | -95.83806103 | 2022-01-01 04:22:14 | Lyon, Minnesota, US | |
4000388 | 4000388 | 2021-12-30 | US | Minnesota | Lyon | 27083 | 5621 | 66 | 0 | 44.41327865 | -95.83806103 | 2021-12-31 04:21:50 | Lyon, Minnesota, US | |
553741 | 553741 | 2021-12-08 | US | Tennessee | Macon | 47111 | 5621 | 100 | 0 | 36.53157855 | -86.00778595 | 2021-12-09 04:22:49 | Macon, Tennessee, US | |
407247 | 407247 | 2021-12-07 | US | Tennessee | Henry | 47079 | 5621 | 95 | 0 | 36.33160906 | -88.30121797 | 2021-12-08 04:22:46 | Henry, Tennessee, US | |
3494271 | 3494271 | 2021-10-26 | US | Nebraska | Madison | 31119 | 5621 | 44 | 0 | 41.91676024 | -97.6005481 | 2021-10-27 04:22:32 | Madison, Nebraska, US | |
3795993 | 3795993 | 2021-10-25 | US | Nebraska | Madison | 31119 | 5621 | 44 | 0 | 41.91676024 | -97.6005481 | 2021-10-26 04:22:09 | Madison, Nebraska, US | |
684439 | 684439 | 2021-10-24 | US | Nebraska | Madison | 31119 | 5621 | 44 | 0 | 41.91676024 | -97.6005481 | 2021-10-25 04:22:31 | Madison, Nebraska, US | |
772447 | 772447 | 2021-10-23 | US | Nebraska | Madison | 31119 | 5621 | 44 | 0 | 41.91676024 | -97.6005481 | 2021-10-24 04:21:22 | Madison, Nebraska, US | |
656094 | 656094 | 2021-10-22 | US | Nebraska | Madison | 31119 | 5621 | 44 | 0 | 41.91676024 | -97.6005481 | 2021-10-23 04:21:32 | Madison, Nebraska, US | |
2125841 | 2125841 | 2021-10-21 | US | Nebraska | Madison | 31119 | 5621 | 44 | 0 | 41.91676024 | -97.6005481 | 2021-10-22 04:21:14 | Madison, Nebraska, US | |
1235632 | 1235632 | 2021-09-27 | Japan | Aomori | 5621 | 35 | 0 | 40.781541 | 140.828896 | 2021-09-28 04:21:28 | Aomori, Japan | |||
2621278 | 2621278 | 2021-09-17 | US | Texas | Upshur | 48459 | 5621 | 97 | 0 | 32.73706798 | -94.93999853 | 2021-09-18 04:21:24 | Upshur, Texas, US | |
2463906 | 2463906 | 2021-09-14 | US | Indiana | Montgomery | 18107 | 5621 | 101 | 0 | 40.04034823 | -86.89335024 | 2021-09-15 03:22:37 | Montgomery, Indiana, US | |
3808174 | 3808174 | 2021-09-11 | US | New York | Tompkins | 36109 | 5621 | 56 | 0 | 42.44945765 | -76.47229843 | 2021-09-12 04:21:13 | Tompkins, New York, US | |
252244 | 252244 | 2021-09-04 | US | Tennessee | Lincoln | 47103 | 5621 | 74 | 0 | 35.13738622 | -86.58910106 | 2021-09-05 04:21:33 | Lincoln, Tennessee, US | |
1777234 | 1777234 | 2021-08-30 | US | Missouri | Camden | 29029 | 5621 | 111 | 0 | 38.02199522 | -92.76083747 | 2021-08-31 04:21:46 | Camden, Missouri, US | |
35995 | 35995 | 2021-08-25 | US | Wisconsin | Shawano | 55115 | 5621 | 85 | 0 | 44.78902246 | -88.76443896 | 2021-08-26 04:21:28 | Shawano, Wisconsin, US | |
248100 | 248100 | 2021-08-17 | US | South Carolina | Newberry | 45071 | 5621 | 110 | 0 | 34.28629098 | -81.59935761 | 2021-08-18 04:21:35 | Newberry, South Carolina, US | |
1485006 | 1485006 | 2021-08-13 | US | Kentucky | Nelson | 21179 | 5621 | 63 | 0 | 37.80335779 | -85.4657193 | 2021-08-14 04:21:25 | Nelson, Kentucky, US | |
591246 | 591246 | 2021-08-08 | US | Michigan | Cass | 26027 | 5621 | 78 | 0 | 41.91522292 | -85.99405727 | 2021-08-09 04:21:24 | Cass, Michigan, US | |
2205258 | 2205258 | 2021-08-07 | US | Michigan | Cass | 26027 | 5621 | 78 | 0 | 41.91522292 | -85.99405727 | 2021-08-08 04:21:33 | Cass, Michigan, US | |
1119208 | 1119208 | 2021-08-06 | US | Michigan | Cass | 26027 | 5621 | 78 | 0 | 41.91522292 | -85.99405727 | 2021-08-07 04:21:30 | Cass, Michigan, US | |
484036 | 484036 | 2021-07-19 | US | Arizona | Graham | 4009 | 5621 | 85 | 0 | 32.93166885 | -109.8882178 | 2021-07-20 04:21:48 | Graham, Arizona, US | |
625914 | 625914 | 2021-07-10 | Japan | Shiga | 5621 | 90 | 5446 | 85 | 35.21582700000001 | 136.138064 | 2021-07-11 04:21:43 | Shiga, Japan | ||
1449588 | 1449588 | 2021-06-03 | US | Illinois | Knox | 17095 | 5621 | 152 | 0 | 40.93148779 | -90.21330340000002 | 2021-06-04 04:23:37 | Knox, Illinois, US | |
3679130 | 3679130 | 2021-05-04 | US | West Virginia | Harrison | 54033 | 5621 | 74 | 0 | 39.2853852 | -80.37919577 | 2021-05-05 04:20:43 | Harrison, West Virginia, US | |
888809 | 888809 | 2021-04-26 | US | Florida | Gadsden | 12039 | 5621 | 93 | 0 | 30.57796289 | -84.61915825 | 2021-04-27 04:20:52 | Gadsden, Florida, US | |
955554 | 955554 | 2021-04-25 | US | Florida | Gadsden | 12039 | 5621 | 93 | 0 | 30.57796289 | -84.61915825 | 2021-04-26 04:21:04 | Gadsden, Florida, US | |
2022404 | 2022404 | 2021-04-20 | US | Michigan | St. Joseph | 26149 | 5621 | 93 | 0 | 41.91441767 | -85.52797979 | 2021-04-21 04:21:14 | St. Joseph, Michigan, US | |
2021707 | 2021707 | 2021-04-20 | US | Illinois | Grundy | 17063 | 5621 | 71 | 0 | 41.28569601 | -88.41905692 | 2021-04-21 04:21:14 | Grundy, Illinois, 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]);