johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
143 rows where confirmed = 5573 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329479 | 329479 | 2022-12-27 | US | Maine | Washington | 23029 | 5573 | 67 | 0 | 45.01607142 | -67.62813524 | 2022-12-28 04:21:04 | Washington, Maine, US | |
219628 | 219628 | 2022-12-26 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-27 04:21:07 | Iosco, Michigan, US | |
219552 | 219552 | 2022-12-26 | US | Maine | Washington | 23029 | 5573 | 67 | 0 | 45.01607142 | -67.62813524 | 2022-12-27 04:21:07 | Washington, Maine, US | |
3224085 | 3224085 | 2022-12-25 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-26 04:21:06 | Iosco, Michigan, US | |
3224009 | 3224009 | 2022-12-25 | US | Maine | Washington | 23029 | 5573 | 67 | 0 | 45.01607142 | -67.62813524 | 2022-12-26 04:21:06 | Washington, Maine, US | |
1019999 | 1019999 | 2022-12-24 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-25 04:21:04 | Iosco, Michigan, US | |
1019923 | 1019923 | 2022-12-24 | US | Maine | Washington | 23029 | 5573 | 67 | 0 | 45.01607142 | -67.62813524 | 2022-12-25 04:21:04 | Washington, Maine, US | |
692022 | 692022 | 2022-12-23 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-24 04:21:02 | Iosco, Michigan, US | |
2181232 | 2181232 | 2022-12-22 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-23 04:21:04 | Iosco, Michigan, US | |
453036 | 453036 | 2022-12-21 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-22 04:20:56 | Iosco, Michigan, US | |
2953035 | 2953035 | 2022-12-20 | US | Michigan | Iosco | 26069 | 5573 | 169 | 0 | 44.35486835 | -83.63484895 | 2022-12-21 04:21:03 | Iosco, Michigan, US | |
2819511 | 2819511 | 2022-12-03 | US | Puerto Rico | Comerio | 72045 | 5573 | 0 | 0 | 18.224687 | -66.221622 | 2022-12-04 04:20:56 | Comerio, Puerto Rico, US | |
3555240 | 3555240 | 2022-11-27 | US | Wisconsin | Taylor | 55119 | 5573 | 77 | 0 | 45.21179252 | -90.5004405 | 2022-11-28 04:21:02 | Taylor, Wisconsin, US | |
2103720 | 2103720 | 2022-11-26 | US | Wisconsin | Taylor | 55119 | 5573 | 77 | 0 | 45.21179252 | -90.5004405 | 2022-11-27 04:21:05 | Taylor, Wisconsin, US | |
491211 | 491211 | 2022-11-25 | US | Wisconsin | Taylor | 55119 | 5573 | 77 | 0 | 45.21179252 | -90.5004405 | 2022-11-26 04:21:11 | Taylor, Wisconsin, US | |
3526833 | 3526833 | 2022-11-24 | US | Virginia | New Kent | 51127 | 5573 | 41 | 0 | 37.50694406 | -76.99828634 | 2022-11-25 04:21:06 | New Kent, Virginia, US | |
3315616 | 3315616 | 2022-11-23 | US | Virginia | New Kent | 51127 | 5573 | 41 | 0 | 37.50694406 | -76.99828634 | 2022-11-24 04:21:09 | New Kent, Virginia, US | |
3600573 | 3600573 | 2022-11-14 | US | Wisconsin | Adams | 55001 | 5573 | 68 | 0 | 43.96974651 | -89.76782777 | 2022-11-15 04:21:16 | Adams, Wisconsin, US | |
482286 | 482286 | 2022-11-08 | US | Pennsylvania | Montour | 42093 | 5573 | 96 | 0 | 41.03023987 | -76.66345939 | 2022-11-09 04:21:22 | Montour, Pennsylvania, US | |
480873 | 480873 | 2022-11-08 | US | Kansas | Dickinson | 20041 | 5573 | 92 | 0 | 38.86600962 | -97.15532383 | 2022-11-09 04:21:22 | Dickinson, Kansas, US | |
2441436 | 2441436 | 2022-11-07 | US | Pennsylvania | Montour | 42093 | 5573 | 96 | 0 | 41.03023987 | -76.66345939 | 2022-11-08 04:21:21 | Montour, Pennsylvania, US | |
2440023 | 2440023 | 2022-11-07 | US | Kansas | Dickinson | 20041 | 5573 | 92 | 0 | 38.86600962 | -97.15532383 | 2022-11-08 04:21:21 | Dickinson, Kansas, US | |
1052534 | 1052534 | 2022-11-06 | US | Pennsylvania | Montour | 42093 | 5573 | 96 | 0 | 41.03023987 | -76.66345939 | 2022-11-07 04:21:26 | Montour, Pennsylvania, US | |
1051121 | 1051121 | 2022-11-06 | US | Kansas | Dickinson | 20041 | 5573 | 92 | 0 | 38.86600962 | -97.15532383 | 2022-11-07 04:21:26 | Dickinson, Kansas, US | |
620558 | 620558 | 2022-11-05 | US | Pennsylvania | Montour | 42093 | 5573 | 96 | 0 | 41.03023987 | -76.66345939 | 2022-11-06 04:21:24 | Montour, Pennsylvania, US | |
619145 | 619145 | 2022-11-05 | US | Kansas | Dickinson | 20041 | 5573 | 92 | 0 | 38.86600962 | -97.15532383 | 2022-11-06 04:21:24 | Dickinson, Kansas, US | |
1025062 | 1025062 | 2022-11-04 | US | Pennsylvania | Montour | 42093 | 5573 | 96 | 0 | 41.03023987 | -76.66345939 | 2022-11-05 04:21:52 | Montour, Pennsylvania, US | |
1023649 | 1023649 | 2022-11-04 | US | Kansas | Dickinson | 20041 | 5573 | 92 | 0 | 38.86600962 | -97.15532383 | 2022-11-05 04:21:52 | Dickinson, Kansas, US | |
434053 | 434053 | 2022-11-03 | US | Pennsylvania | Montour | 42093 | 5573 | 96 | 0 | 41.03023987 | -76.66345939 | 2022-11-04 04:22:11 | Montour, Pennsylvania, US | |
432640 | 432640 | 2022-11-03 | US | Kansas | Dickinson | 20041 | 5573 | 92 | 0 | 38.86600962 | -97.15532383 | 2022-11-04 04:22:11 | Dickinson, Kansas, US | |
431877 | 431877 | 2022-11-03 | US | Arkansas | Phillips | 5107 | 5573 | 103 | 0 | 34.43268455 | -90.84800154 | 2022-11-04 04:22:11 | Phillips, Arkansas, US | |
852295 | 852295 | 2022-11-02 | US | Pennsylvania | Montour | 42093 | 5573 | 96 | 0 | 41.03023987 | -76.66345939 | 2022-11-03 04:22:05 | Montour, Pennsylvania, US | |
850882 | 850882 | 2022-11-02 | US | Kansas | Dickinson | 20041 | 5573 | 92 | 0 | 38.86600962 | -97.15532383 | 2022-11-03 04:22:05 | Dickinson, Kansas, US | |
2757543 | 2757543 | 2022-10-18 | US | Colorado | Elbert | 8039 | 5573 | 45 | 0 | 39.28656773 | -104.1358721 | 2022-10-19 04:22:26 | Elbert, Colorado, US | |
3217016 | 3217016 | 2022-10-12 | US | Puerto Rico | Adjuntas | 72001 | 5573 | 0 | 0 | 18.180117 | -66.754367 | 2022-10-13 04:22:39 | Adjuntas, Puerto Rico, US | |
131510 | 131510 | 2022-10-04 | US | Georgia | Berrien | 13019 | 5573 | 90 | 0 | 31.27590016 | -83.2252992 | 2022-10-05 04:23:06 | Berrien, Georgia, US | |
2686457 | 2686457 | 2022-10-03 | US | Georgia | Berrien | 13019 | 5573 | 90 | 0 | 31.27590016 | -83.2252992 | 2022-10-04 04:22:55 | Berrien, Georgia, US | |
2260524 | 2260524 | 2022-10-02 | US | Georgia | Berrien | 13019 | 5573 | 90 | 0 | 31.27590016 | -83.2252992 | 2022-10-03 04:23:11 | Berrien, Georgia, US | |
2996050 | 2996050 | 2022-10-01 | US | Georgia | Berrien | 13019 | 5573 | 90 | 0 | 31.27590016 | -83.2252992 | 2022-10-02 04:21:23 | Berrien, Georgia, US | |
854376 | 854376 | 2022-09-30 | US | Georgia | Berrien | 13019 | 5573 | 90 | 0 | 31.27590016 | -83.2252992 | 2022-10-01 04:23:01 | Berrien, Georgia, US | |
2376302 | 2376302 | 2022-09-29 | US | Georgia | Berrien | 13019 | 5573 | 90 | 0 | 31.27590016 | -83.2252992 | 2022-09-30 04:23:09 | Berrien, Georgia, US | |
1560853 | 1560853 | 2022-09-28 | US | Georgia | Berrien | 13019 | 5573 | 90 | 0 | 31.27590016 | -83.2252992 | 2022-09-29 04:22:34 | Berrien, Georgia, US | |
1627075 | 1627075 | 2022-09-22 | US | Puerto Rico | Santa Isabel | 72133 | 5573 | 0 | 0 | 17.994525 | -66.388913 | 2022-09-23 04:23:13 | Santa Isabel, Puerto Rico, US | |
2636901 | 2636901 | 2022-09-05 | US | Texas | Milam | 48331 | 5573 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-06 04:21:02 | Milam, Texas, US | |
2990465 | 2990465 | 2022-09-04 | US | Texas | Milam | 48331 | 5573 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-05 04:21:01 | Milam, Texas, US | |
2716150 | 2716150 | 2022-09-03 | US | Texas | Milam | 48331 | 5573 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-04 04:21:22 | Milam, Texas, US | |
1396855 | 1396855 | 2022-09-02 | US | Texas | Milam | 48331 | 5573 | 106 | 0 | 30.7858183 | -96.97718698 | 2022-09-03 04:21:04 | Milam, Texas, US | |
1251550 | 1251550 | 2022-08-23 | US | Georgia | Dodge | 13091 | 5573 | 160 | 0 | 32.17265114 | -83.16948926 | 2022-08-24 04:20:46 | Dodge, Georgia, US | |
2853654 | 2853654 | 2022-08-22 | US | Georgia | Dodge | 13091 | 5573 | 160 | 0 | 32.17265114 | -83.16948926 | 2022-08-23 04:20:56 | Dodge, Georgia, US | |
2403626 | 2403626 | 2022-08-21 | US | Georgia | Dodge | 13091 | 5573 | 160 | 0 | 32.17265114 | -83.16948926 | 2022-08-22 04:20:38 | Dodge, Georgia, US | |
3798704 | 3798704 | 2022-08-20 | US | Georgia | Dodge | 13091 | 5573 | 160 | 0 | 32.17265114 | -83.16948926 | 2022-08-21 04:20:44 | Dodge, Georgia, US | |
2364290 | 2364290 | 2022-08-19 | US | Georgia | Dodge | 13091 | 5573 | 160 | 0 | 32.17265114 | -83.16948926 | 2022-08-20 04:21:01 | Dodge, Georgia, US | |
1161961 | 1161961 | 2022-08-18 | US | Georgia | Dodge | 13091 | 5573 | 160 | 0 | 32.17265114 | -83.16948926 | 2022-08-19 04:20:54 | Dodge, Georgia, US | |
3951285 | 3951285 | 2022-08-17 | US | Georgia | Dodge | 13091 | 5573 | 160 | 0 | 32.17265114 | -83.16948926 | 2022-08-18 04:21:11 | Dodge, Georgia, US | |
1068880 | 1068880 | 2022-07-28 | US | Tennessee | Unicoi | 47171 | 5573 | 97 | 0 | 36.10890856 | -82.43709629 | 2022-07-29 04:20:45 | Unicoi, Tennessee, US | |
2594423 | 2594423 | 2022-07-25 | US | Alabama | Marengo | 1091 | 5573 | 108 | 0 | 32.24767634 | -87.78796182 | 2022-07-26 04:20:58 | Marengo, Alabama, US | |
3212148 | 3212148 | 2022-07-18 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-19 04:20:58 | Winston, Mississippi, US | |
3407323 | 3407323 | 2022-07-17 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-18 04:20:59 | Winston, Mississippi, US | |
2153523 | 2153523 | 2022-07-16 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-17 04:21:15 | Winston, Mississippi, US | |
2420756 | 2420756 | 2022-07-15 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-16 04:21:05 | Winston, Mississippi, US | |
3430831 | 3430831 | 2022-07-14 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-15 04:20:53 | Winston, Mississippi, US | |
3111351 | 3111351 | 2022-07-13 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-14 04:20:57 | Winston, Mississippi, US | |
631774 | 631774 | 2022-07-12 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-13 04:20:58 | Winston, Mississippi, US | |
1213418 | 1213418 | 2022-07-11 | US | Mississippi | Winston | 28159 | 5573 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-07-12 04:20:51 | Winston, Mississippi, US | |
478161 | 478161 | 2022-06-26 | US | Puerto Rico | Aibonito | 72009 | 5573 | 0 | 0 | 18.131361 | -66.264131 | 2022-06-27 04:21:00 | Aibonito, Puerto Rico, US | |
3270987 | 3270987 | 2022-06-19 | US | Kentucky | Spencer | 21215 | 5573 | 61 | 0 | 38.03223971 | -85.32749335 | 2022-06-20 04:21:01 | Spencer, Kentucky, US | |
3398899 | 3398899 | 2022-06-18 | US | Kentucky | Spencer | 21215 | 5573 | 61 | 0 | 38.03223971 | -85.32749335 | 2022-06-19 04:20:51 | Spencer, Kentucky, US | |
2312776 | 2312776 | 2022-06-17 | US | Kentucky | Spencer | 21215 | 5573 | 61 | 0 | 38.03223971 | -85.32749335 | 2022-06-18 04:21:10 | Spencer, Kentucky, US | |
560280 | 560280 | 2022-06-16 | US | Kentucky | Spencer | 21215 | 5573 | 61 | 0 | 38.03223971 | -85.32749335 | 2022-06-17 04:20:56 | Spencer, Kentucky, US | |
3984082 | 3984082 | 2022-06-15 | US | Kentucky | Spencer | 21215 | 5573 | 61 | 0 | 38.03223971 | -85.32749335 | 2022-06-16 04:20:55 | Spencer, Kentucky, US | |
948323 | 948323 | 2022-06-14 | US | Kentucky | Spencer | 21215 | 5573 | 61 | 0 | 38.03223971 | -85.32749335 | 2022-06-15 04:20:54 | Spencer, Kentucky, US | |
2980731 | 2980731 | 2022-06-13 | US | Kentucky | Spencer | 21215 | 5573 | 61 | 0 | 38.03223971 | -85.32749335 | 2022-06-14 04:20:52 | Spencer, Kentucky, US | |
3510392 | 3510392 | 2022-06-05 | US | Tennessee | Union | 47173 | 5573 | 77 | 0 | 36.28590426 | -83.83651902 | 2022-06-06 04:20:57 | Union, Tennessee, US | |
3583845 | 3583845 | 2022-05-17 | US | Iowa | Henry | 19087 | 5573 | 74 | 0 | 40.98767962 | -91.54436349 | 2022-05-18 04:20:50 | Henry, Iowa, US | |
1504802 | 1504802 | 2022-05-16 | US | Iowa | Henry | 19087 | 5573 | 74 | 0 | 40.98767962 | -91.54436349 | 2022-05-17 04:20:59 | Henry, Iowa, US | |
2085161 | 2085161 | 2022-05-15 | US | Iowa | Henry | 19087 | 5573 | 74 | 0 | 40.98767962 | -91.54436349 | 2022-05-16 04:20:47 | Henry, Iowa, US | |
3355871 | 3355871 | 2022-05-14 | US | Iowa | Henry | 19087 | 5573 | 74 | 0 | 40.98767962 | -91.54436349 | 2022-05-15 04:20:53 | Henry, Iowa, US | |
659516 | 659516 | 2022-05-13 | US | Iowa | Henry | 19087 | 5573 | 74 | 0 | 40.98767962 | -91.54436349 | 2022-05-14 04:20:48 | Henry, Iowa, US | |
2534599 | 2534599 | 2022-05-12 | US | Iowa | Henry | 19087 | 5573 | 74 | 0 | 40.98767962 | -91.54436349 | 2022-05-13 04:20:51 | Henry, Iowa, US | |
3446333 | 3446333 | 2022-05-11 | US | Louisiana | Assumption | 22007 | 5573 | 70 | 0 | 29.89946234 | -91.06461642 | 2022-05-12 04:20:54 | Assumption, Louisiana, US | |
3446045 | 3446045 | 2022-05-11 | US | Iowa | Henry | 19087 | 5573 | 74 | 0 | 40.98767962 | -91.54436349 | 2022-05-12 04:20:54 | Henry, Iowa, US | |
223773 | 223773 | 2022-05-09 | US | Minnesota | Waseca | 27161 | 5573 | 39 | 0 | 44.02211116 | -93.58720034 | 2022-05-10 04:20:50 | Waseca, Minnesota, US | |
2481359 | 2481359 | 2022-03-30 | US | Virginia | Page | 51139 | 5573 | 119 | 0 | 38.61807452 | -78.48797204 | 2022-03-31 04:20:56 | Page, Virginia, US | |
3025456 | 3025456 | 2022-03-23 | US | Texas | Moore | 48341 | 5573 | 110 | 0 | 35.83769242 | -101.8930281 | 2022-03-24 04:20:43 | Moore, Texas, US | |
1646155 | 1646155 | 2022-03-03 | US | Mississippi | Chickasaw | 28017 | 5573 | 95 | 0 | 33.91983202 | -88.9481545 | 2022-03-04 04:21:09 | Chickasaw, Mississippi, US | |
2732857 | 2732857 | 2022-02-27 | Colombia | Guaviare | 5573 | 105 | 0 | 1.0654 | -73.2603 | 2022-02-28 04:21:05 | Guaviare, Colombia | |||
1512880 | 1512880 | 2022-02-24 | US | Kentucky | Simpson | 21213 | 5573 | 82 | 0 | 36.74058474 | -86.58047435 | 2022-02-25 04:21:11 | Simpson, Kentucky, US | |
1059321 | 1059321 | 2022-02-23 | US | Kentucky | Simpson | 21213 | 5573 | 82 | 0 | 36.74058474 | -86.58047435 | 2022-02-24 04:21:14 | Simpson, Kentucky, US | |
189077 | 189077 | 2022-02-13 | US | Tennessee | Wayne | 47181 | 5573 | 53 | 0 | 35.23868267 | -87.78644456 | 2022-02-14 04:20:51 | Wayne, Tennessee, US | |
1781440 | 1781440 | 2022-01-27 | US | Nebraska | Cass | 31025 | 5573 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-01-28 04:21:09 | Cass, Nebraska, US | |
3464790 | 3464790 | 2022-01-18 | US | Colorado | Delta | 8029 | 5573 | 125 | 0 | 38.86246243 | -107.86313419999999 | 2022-01-19 04:21:23 | Delta, Colorado, US | |
3842985 | 3842985 | 2022-01-15 | US | Ohio | Henry | 39069 | 5573 | 99 | 0 | 41.333964200000004 | -84.06830637 | 2022-01-16 04:21:12 | Henry, Ohio, US | |
3616257 | 3616257 | 2022-01-12 | US | Texas | Palo Pinto | 48363 | 5573 | 132 | 0 | 32.75310985 | -98.31319001 | 2022-01-13 08:00:09 | Palo Pinto, Texas, US | |
1115393 | 1115393 | 2022-01-11 | US | Mississippi | George | 28039 | 5573 | 80 | 0 | 30.86259065 | -88.64436789 | 2022-01-12 04:21:44 | George, Mississippi, US | |
1114980 | 1114980 | 2022-01-11 | US | Kentucky | Clay | 21051 | 5573 | 69 | 0 | 37.16451126 | -83.712575 | 2022-01-12 04:21:44 | Clay, Kentucky, US | |
3519823 | 3519823 | 2022-01-02 | US | Alabama | Marion | 1093 | 5573 | 132 | 0 | 34.13697363 | -87.88704173 | 2022-01-03 02:22:25 | Marion, Alabama, US | |
784553 | 784553 | 2021-12-13 | US | New Hampshire | Sullivan | 33019 | 5573 | 41 | 0 | 43.36094111 | -72.22203125 | 2021-12-14 04:22:38 | Sullivan, New Hampshire, US | |
1234243 | 1234243 | 2021-11-28 | US | Oregon | Coos | 41011 | 5573 | 106 | 0 | 43.17406868 | -124.0594514 | 2021-11-29 04:22:30 | Coos, Oregon, US | |
1360950 | 1360950 | 2021-11-27 | US | Oregon | Coos | 41011 | 5573 | 106 | 0 | 43.17406868 | -124.0594514 | 2021-11-28 04:22:43 | Coos, Oregon, US | |
760941 | 760941 | 2021-11-26 | US | Oregon | Coos | 41011 | 5573 | 106 | 0 | 43.17406868 | -124.0594514 | 2021-11-27 04:22:45 | Coos, Oregon, 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]);