johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117 rows where confirmed = 6259 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2951862 | 2951862 | 2022-12-20 | US | Arkansas | Clark | 5019 | 6259 | 90 | 0 | 34.04613432 | -93.17484713 | 2022-12-21 04:21:03 | Clark, Arkansas, US | |
308749 | 308749 | 2022-12-13 | US | Georgia | Pierce | 13229 | 6259 | 142 | 0 | 31.35928155 | -82.21598442 | 2022-12-14 04:21:04 | Pierce, Georgia, US | |
1149810 | 1149810 | 2022-12-12 | US | Georgia | Pierce | 13229 | 6259 | 142 | 0 | 31.35928155 | -82.21598442 | 2022-12-13 04:21:01 | Pierce, Georgia, US | |
869664 | 869664 | 2022-12-11 | US | Georgia | Pierce | 13229 | 6259 | 142 | 0 | 31.35928155 | -82.21598442 | 2022-12-12 04:21:01 | Pierce, Georgia, US | |
258194 | 258194 | 2022-12-10 | US | Georgia | Pierce | 13229 | 6259 | 142 | 0 | 31.35928155 | -82.21598442 | 2022-12-11 04:20:50 | Pierce, Georgia, US | |
257833 | 257833 | 2022-12-10 | US | Arkansas | Lawrence | 5075 | 6259 | 87 | 0 | 36.04188196 | -91.10867198 | 2022-12-11 04:20:50 | Lawrence, Arkansas, US | |
3936908 | 3936908 | 2022-12-09 | US | Georgia | Pierce | 13229 | 6259 | 142 | 0 | 31.35928155 | -82.21598442 | 2022-12-10 04:21:02 | Pierce, Georgia, US | |
3378240 | 3378240 | 2022-12-08 | US | Georgia | Pierce | 13229 | 6259 | 142 | 0 | 31.35928155 | -82.21598442 | 2022-12-09 04:21:05 | Pierce, Georgia, US | |
3251506 | 3251506 | 2022-10-11 | US | Kansas | Sumner | 20191 | 6259 | 80 | 0 | 37.23682549 | -97.47721621 | 2022-10-12 04:22:51 | Sumner, Kansas, US | |
2968765 | 2968765 | 2022-10-10 | US | Kansas | Sumner | 20191 | 6259 | 80 | 0 | 37.23682549 | -97.47721621 | 2022-10-11 04:23:05 | Sumner, Kansas, US | |
3098801 | 3098801 | 2022-10-09 | US | Kansas | Sumner | 20191 | 6259 | 80 | 0 | 37.23682549 | -97.47721621 | 2022-10-10 04:22:32 | Sumner, Kansas, US | |
4004026 | 4004026 | 2022-10-08 | US | Kansas | Sumner | 20191 | 6259 | 80 | 0 | 37.23682549 | -97.47721621 | 2022-10-09 04:21:16 | Sumner, Kansas, US | |
397623 | 397623 | 2022-10-07 | US | Kansas | Sumner | 20191 | 6259 | 80 | 0 | 37.23682549 | -97.47721621 | 2022-10-08 04:22:56 | Sumner, Kansas, US | |
2530740 | 2530740 | 2022-10-06 | US | Kansas | Sumner | 20191 | 6259 | 80 | 0 | 37.23682549 | -97.47721621 | 2022-10-07 04:23:08 | Sumner, Kansas, US | |
2530444 | 2530444 | 2022-10-06 | US | Illinois | Wayne | 17191 | 6259 | 89 | 0 | 38.42955355 | -88.42586459 | 2022-10-07 04:23:08 | Wayne, Illinois, US | |
1812134 | 1812134 | 2022-10-05 | US | Kansas | Sumner | 20191 | 6259 | 80 | 0 | 37.23682549 | -97.47721621 | 2022-10-06 04:21:22 | Sumner, Kansas, US | |
422478 | 422478 | 2022-09-18 | US | Texas | Karnes | 48255 | 6259 | 73 | 0 | 28.90705334 | -97.85960149 | 2022-09-19 04:21:49 | Karnes, Texas, US | |
3376502 | 3376502 | 2022-09-17 | US | Texas | Karnes | 48255 | 6259 | 73 | 0 | 28.90705334 | -97.85960149 | 2022-09-18 04:22:50 | Karnes, Texas, US | |
2358610 | 2358610 | 2022-09-16 | US | Texas | Karnes | 48255 | 6259 | 73 | 0 | 28.90705334 | -97.85960149 | 2022-09-17 04:20:19 | Karnes, Texas, US | |
373154 | 373154 | 2022-09-13 | US | Idaho | Payette | 16075 | 6259 | 89 | 0 | 44.00545243 | -116.7647695 | 2022-09-14 04:20:44 | Payette, Idaho, US | |
2395756 | 2395756 | 2022-09-12 | US | Idaho | Payette | 16075 | 6259 | 89 | 0 | 44.00545243 | -116.7647695 | 2022-09-13 04:20:57 | Payette, Idaho, US | |
118035 | 118035 | 2022-09-06 | US | Vermont | Caledonia | 50005 | 6259 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-09-07 04:20:59 | Caledonia, Vermont, US | |
116003 | 116003 | 2022-09-06 | US | Iowa | Washington | 19183 | 6259 | 81 | 0 | 41.33577126 | -91.71725711 | 2022-09-07 04:20:59 | Washington, Iowa, US | |
2637007 | 2637007 | 2022-09-05 | US | Vermont | Caledonia | 50005 | 6259 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-09-06 04:21:02 | Caledonia, Vermont, US | |
2634975 | 2634975 | 2022-09-05 | US | Iowa | Washington | 19183 | 6259 | 81 | 0 | 41.33577126 | -91.71725711 | 2022-09-06 04:21:02 | Washington, Iowa, US | |
2990571 | 2990571 | 2022-09-04 | US | Vermont | Caledonia | 50005 | 6259 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-09-05 04:21:01 | Caledonia, Vermont, US | |
2988539 | 2988539 | 2022-09-04 | US | Iowa | Washington | 19183 | 6259 | 81 | 0 | 41.33577126 | -91.71725711 | 2022-09-05 04:21:01 | Washington, Iowa, US | |
2716256 | 2716256 | 2022-09-03 | US | Vermont | Caledonia | 50005 | 6259 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-09-04 04:21:22 | Caledonia, Vermont, US | |
2714224 | 2714224 | 2022-09-03 | US | Iowa | Washington | 19183 | 6259 | 81 | 0 | 41.33577126 | -91.71725711 | 2022-09-04 04:21:22 | Washington, Iowa, US | |
1396961 | 1396961 | 2022-09-02 | US | Vermont | Caledonia | 50005 | 6259 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-09-03 04:21:04 | Caledonia, Vermont, US | |
1394929 | 1394929 | 2022-09-02 | US | Iowa | Washington | 19183 | 6259 | 81 | 0 | 41.33577126 | -91.71725711 | 2022-09-03 04:21:04 | Washington, Iowa, US | |
3550790 | 3550790 | 2022-09-01 | US | Vermont | Caledonia | 50005 | 6259 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-09-02 04:21:07 | Caledonia, Vermont, US | |
3548758 | 3548758 | 2022-09-01 | US | Iowa | Washington | 19183 | 6259 | 81 | 0 | 41.33577126 | -91.71725711 | 2022-09-02 04:21:07 | Washington, Iowa, US | |
2346710 | 2346710 | 2022-08-31 | US | Vermont | Caledonia | 50005 | 6259 | 31 | 0 | 44.46548598 | -72.10314651 | 2022-09-01 04:21:03 | Caledonia, Vermont, US | |
2345203 | 2345203 | 2022-08-31 | US | Minnesota | Wabasha | 27157 | 6259 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-09-01 04:21:03 | Wabasha, Minnesota, US | |
2344678 | 2344678 | 2022-08-31 | US | Iowa | Washington | 19183 | 6259 | 81 | 0 | 41.33577126 | -91.71725711 | 2022-09-01 04:21:03 | Washington, Iowa, US | |
3775683 | 3775683 | 2022-08-30 | US | Minnesota | Wabasha | 27157 | 6259 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-08-31 04:20:57 | Wabasha, Minnesota, US | |
1682279 | 1682279 | 2022-08-29 | US | Minnesota | Wabasha | 27157 | 6259 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-08-30 04:21:03 | Wabasha, Minnesota, US | |
1878763 | 1878763 | 2022-08-28 | US | Minnesota | Wabasha | 27157 | 6259 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-08-29 04:21:06 | Wabasha, Minnesota, US | |
2097890 | 2097890 | 2022-08-27 | US | Minnesota | Wabasha | 27157 | 6259 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-08-28 04:21:02 | Wabasha, Minnesota, US | |
1533705 | 1533705 | 2022-08-26 | US | Minnesota | Wabasha | 27157 | 6259 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-08-27 04:20:57 | Wabasha, Minnesota, US | |
2830592 | 2830592 | 2022-08-25 | US | Minnesota | Wabasha | 27157 | 6259 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-08-26 04:21:02 | Wabasha, Minnesota, US | |
3800915 | 3800915 | 2022-08-20 | US | Tennessee | Union | 47173 | 6259 | 79 | 0 | 36.28590426 | -83.83651902 | 2022-08-21 04:20:44 | Union, Tennessee, US | |
1071476 | 1071476 | 2022-08-07 | US | Maryland | Garrett | 24023 | 6259 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-08-08 04:21:08 | Garrett, Maryland, US | |
1942064 | 1942064 | 2022-08-06 | US | Maryland | Garrett | 24023 | 6259 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-08-07 04:20:54 | Garrett, Maryland, US | |
881863 | 881863 | 2022-08-05 | US | Maryland | Garrett | 24023 | 6259 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-08-06 04:20:56 | Garrett, Maryland, US | |
1490995 | 1490995 | 2022-07-26 | US | Virginia | Salem | 51775 | 6259 | 99 | 0 | 37.2836193 | -80.06219455 | 2022-07-27 04:21:04 | Salem, Virginia, US | |
3210811 | 3210811 | 2022-07-18 | US | Arkansas | Sevier | 5133 | 6259 | 75 | 0 | 33.99780401 | -94.2424869 | 2022-07-19 04:20:58 | Sevier, Arkansas, US | |
3890572 | 3890572 | 2022-06-06 | US | Tennessee | Haywood | 47075 | 6259 | 103 | 0 | 35.58332824 | -89.28536625 | 2022-06-07 04:21:08 | Haywood, Tennessee, US | |
2534445 | 2534445 | 2022-05-12 | US | Illinois | Shelby | 17173 | 6259 | 77 | 0 | 39.39133527 | -88.80611122 | 2022-05-13 04:20:51 | Shelby, Illinois, US | |
1327122 | 1327122 | 2022-04-26 | US | Georgia | Stephens | 13257 | 6259 | 157 | 0 | 34.55151201 | -83.29405315 | 2022-04-27 04:20:52 | Stephens, Georgia, US | |
3723076 | 3723076 | 2022-04-25 | US | Georgia | Stephens | 13257 | 6259 | 157 | 0 | 34.55151201 | -83.29405315 | 2022-04-26 04:20:51 | Stephens, Georgia, US | |
2029644 | 2029644 | 2022-04-24 | US | Georgia | Stephens | 13257 | 6259 | 157 | 0 | 34.55151201 | -83.29405315 | 2022-04-25 04:20:56 | Stephens, Georgia, US | |
747219 | 747219 | 2022-04-23 | US | Georgia | Stephens | 13257 | 6259 | 157 | 0 | 34.55151201 | -83.29405315 | 2022-04-24 04:20:56 | Stephens, Georgia, US | |
3437704 | 3437704 | 2022-04-22 | US | Georgia | Stephens | 13257 | 6259 | 157 | 0 | 34.55151201 | -83.29405315 | 2022-04-23 04:20:50 | Stephens, Georgia, US | |
2893289 | 2893289 | 2022-04-21 | US | Georgia | Stephens | 13257 | 6259 | 157 | 0 | 34.55151201 | -83.29405315 | 2022-04-22 04:20:45 | Stephens, Georgia, US | |
2308161 | 2308161 | 2022-04-20 | US | Georgia | Stephens | 13257 | 6259 | 157 | 0 | 34.55151201 | -83.29405315 | 2022-04-21 04:20:46 | Stephens, Georgia, US | |
3207141 | 3207141 | 2022-04-11 | US | Georgia | Stephens | 13257 | 6259 | 154 | 0 | 34.55151201 | -83.29405315 | 2022-04-12 04:20:49 | Stephens, Georgia, US | |
1548585 | 1548585 | 2022-03-07 | US | Colorado | Delta | 8029 | 6259 | 138 | 0 | 38.86246243 | -107.86313419999999 | 2022-03-08 04:20:54 | Delta, Colorado, US | |
2659662 | 2659662 | 2022-01-31 | US | Missouri | Barry | 29009 | 6259 | 101 | 0 | 36.70978521 | -93.82919888 | 2022-02-01 04:21:11 | Barry, Missouri, US | |
3616018 | 3616018 | 2022-01-12 | US | Tennessee | Henry | 47079 | 6259 | 119 | 0 | 36.33160906 | -88.30121797 | 2022-01-13 08:00:09 | Henry, Tennessee, US | |
732735 | 732735 | 2021-12-27 | US | New Mexico | Rio Arriba | 35039 | 6259 | 94 | 0 | 36.51072137 | -106.69316740000001 | 2021-12-28 04:21:47 | Rio Arriba, New Mexico, US | |
3817194 | 3817194 | 2021-12-23 | US | Georgia | Chattahoochee | 13053 | 6259 | 21 | 0 | 32.34341231 | -84.78809239 | 2021-12-24 04:21:34 | Chattahoochee, Georgia, US | |
1257031 | 1257031 | 2021-12-20 | US | New York | Otsego | 36077 | 6259 | 71 | 0 | 42.63492579 | -75.03151402 | 2021-12-21 03:21:27 | Otsego, New York, US | |
1256226 | 1256226 | 2021-12-20 | US | Kentucky | Muhlenberg | 21177 | 6259 | 99 | 0 | 37.21425819 | -87.14632053 | 2021-12-21 03:21:27 | Muhlenberg, Kentucky, US | |
449859 | 449859 | 2021-11-17 | US | Ohio | Madison | 39097 | 6259 | 90 | 0 | 39.89381073 | -83.40178317 | 2021-11-18 04:21:33 | Madison, Ohio, US | |
935201 | 935201 | 2021-10-16 | US | Alabama | Russell | 1113 | 6259 | 58 | 0 | 32.28725256 | -85.18415324 | 2021-10-17 04:21:29 | Russell, Alabama, US | |
2945236 | 2945236 | 2021-10-15 | US | Missouri | Camden | 29029 | 6259 | 122 | 0 | 38.02199522 | -92.76083747 | 2021-10-16 04:21:15 | Camden, Missouri, US | |
635712 | 635712 | 2021-10-13 | US | Mississippi | Bolivar | 28011 | 6259 | 145 | 0 | 33.79696941 | -90.87372121 | 2021-10-14 04:21:29 | Bolivar, Mississippi, US | |
635457 | 635457 | 2021-10-13 | US | Louisiana | St. John the Baptist | 22095 | 6259 | 165 | 0 | 30.12597499 | -90.4753503 | 2021-10-14 04:21:29 | St. John the Baptist, Louisiana, US | |
3010582 | 3010582 | 2021-10-11 | US | Texas | Waller | 48473 | 6259 | 72 | 0 | 30.01058447 | -95.99011759 | 2021-10-12 04:21:09 | Waller, Texas, US | |
988807 | 988807 | 2021-10-04 | US | Mississippi | Marshall | 28093 | 6259 | 128 | 0 | 34.76216286 | -89.50299462 | 2021-10-05 04:21:27 | Marshall, Mississippi, US | |
988072 | 988072 | 2021-10-04 | US | Indiana | Harrison | 18061 | 6259 | 89 | 0 | 38.19467379 | -86.10948271 | 2021-10-05 04:21:27 | Harrison, Indiana, US | |
812692 | 812692 | 2021-09-20 | US | Texas | Hill | 48217 | 6259 | 132 | 0 | 31.99045053 | -97.13423143 | 2021-09-21 04:21:26 | Hill, Texas, US | |
1817891 | 1817891 | 2021-09-19 | US | Texas | Hill | 48217 | 6259 | 132 | 0 | 31.99045053 | -97.13423143 | 2021-09-20 04:21:22 | Hill, Texas, US | |
19471 | 19471 | 2021-09-18 | US | Texas | Hill | 48217 | 6259 | 130 | 0 | 31.99045053 | -97.13423143 | 2021-09-19 04:21:34 | Hill, Texas, US | |
3449939 | 3449939 | 2021-09-10 | US | Indiana | Jackson | 18071 | 6259 | 79 | 0 | 38.90915820000001 | -86.03851889 | 2021-09-11 04:21:30 | Jackson, Indiana, US | |
2069735 | 2069735 | 2021-08-31 | US | Mississippi | Oktibbeha | 28105 | 6259 | 112 | 0 | 33.42491685 | -88.87905132 | 2021-09-01 04:21:38 | Oktibbeha, Mississippi, US | |
1597819 | 1597819 | 2021-08-26 | US | Michigan | Barry | 26015 | 6259 | 73 | 0 | 42.59513984 | -85.30834519 | 2021-08-27 04:21:37 | Barry, Michigan, US | |
34028 | 34028 | 2021-08-25 | US | Michigan | Barry | 26015 | 6259 | 73 | 0 | 42.59513984 | -85.30834519 | 2021-08-26 04:21:28 | Barry, Michigan, US | |
104395 | 104395 | 2021-08-15 | US | Indiana | Cass | 18017 | 6259 | 112 | 0 | 40.76135835 | -86.34830753 | 2021-08-16 04:21:31 | Cass, Indiana, US | |
508753 | 508753 | 2021-08-14 | US | Indiana | Cass | 18017 | 6259 | 112 | 0 | 40.76135835 | -86.34830753 | 2021-08-15 04:21:41 | Cass, Indiana, US | |
1484625 | 1484625 | 2021-08-13 | US | Indiana | Cass | 18017 | 6259 | 112 | 0 | 40.76135835 | -86.34830753 | 2021-08-14 04:21:25 | Cass, Indiana, US | |
829483 | 829483 | 2021-07-09 | Eritrea | 6259 | 29 | 5826 | 404 | 15.1794 | 39.7823 | 2021-07-10 04:21:25 | Eritrea | |||
780046 | 780046 | 2021-07-08 | US | Michigan | St. Joseph | 26149 | 6259 | 101 | 0 | 41.91441767 | -85.52797979 | 2021-07-09 04:21:21 | St. Joseph, Michigan, US | |
1442268 | 1442268 | 2021-07-07 | US | Michigan | St. Joseph | 26149 | 6259 | 101 | 0 | 41.91441767 | -85.52797979 | 2021-07-08 04:21:26 | St. Joseph, Michigan, US | |
2695373 | 2695373 | 2021-07-06 | US | Michigan | St. Joseph | 26149 | 6259 | 101 | 0 | 41.91441767 | -85.52797979 | 2021-07-07 04:21:20 | St. Joseph, Michigan, US | |
3127192 | 3127192 | 2021-06-28 | US | Michigan | St. Joseph | 26149 | 6259 | 100 | 0 | 41.91441767 | -85.52797979 | 2021-06-29 04:21:28 | St. Joseph, Michigan, US | |
565299 | 565299 | 2021-06-22 | US | North Carolina | Lenoir | 37107 | 6259 | 124 | 0 | 35.24032589999999 | -77.64245615 | 2021-06-23 04:21:46 | Lenoir, North Carolina, US | |
2339986 | 2339986 | 2021-06-15 | US | California | Yuba | 6115 | 6259 | 51 | 0 | 39.26255932 | -121.3535644 | 2021-06-16 04:22:32 | Yuba, California, US | |
524412 | 524412 | 2021-06-09 | US | Maine | Penobscot | 23019 | 6259 | 94 | 0 | 45.40194593 | -68.65020455 | 2021-06-10 04:23:17 | Penobscot, Maine, US | |
1954082 | 1954082 | 2021-05-21 | US | Maryland | Cecil | 24015 | 6259 | 139 | 0 | 39.56647682 | -75.94627411 | 2021-05-22 04:20:45 | Cecil, Maryland, US | |
2257545 | 2257545 | 2021-05-19 | US | Mississippi | Lamar | 28073 | 6259 | 86 | 0 | 31.20572971 | -89.5077704 | 2021-05-20 04:21:05 | Lamar, Mississippi, US | |
2763898 | 2763898 | 2021-05-03 | US | Tennessee | Roane | 47145 | 6259 | 105 | 0 | 35.84923189 | -84.52458689 | 2021-05-04 04:20:34 | Roane, Tennessee, US | |
171588 | 171588 | 2021-04-16 | US | Maine | Androscoggin | 23001 | 6259 | 61 | 0 | 44.1664747 | -70.20380627 | 2021-04-17 04:20:40 | Androscoggin, Maine, US | |
2649098 | 2649098 | 2021-04-08 | US | Virginia | Harrisonburg | 51660 | 6259 | 95 | 0 | 38.43542574 | -78.87536254 | 2021-04-09 04:21:13 | Harrisonburg, Virginia, US | |
3004924 | 3004924 | 2021-04-06 | US | Michigan | Clinton | 26037 | 6259 | 75 | 0 | 42.94400871 | -84.60145248 | 2021-04-07 04:20:53 | Clinton, Michigan, US | |
3622141 | 3622141 | 2021-03-17 | US | Indiana | Boone | 18011 | 6259 | 96 | 0 | 40.0509304 | -86.46841646 | 2021-03-18 05:26:22 | Boone, Indiana, US | |
3621094 | 3621094 | 2021-03-17 | Japan | Ibaraki | 6259 | 123 | 5814 | 322 | 36.303588 | 140.319591 | 2021-03-18 05:26:22 | Ibaraki, Japan | ||
2185228 | 2185228 | 2021-02-26 | US | Michigan | Lenawee | 26091 | 6259 | 121 | 0 | 6138 | 41.89475156 | -84.06603727 | 2021-02-27 05:22:28 | Lenawee, Michigan, 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]);