johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
199 rows where confirmed = 4797 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752710 | 2752710 | 2022-12-29 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-30 04:21:04 | Shandong, China | |||
1073716 | 1073716 | 2022-12-28 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-29 04:21:01 | Shandong, China | |||
329403 | 329403 | 2022-12-27 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-28 04:21:04 | Bienville, Louisiana, US | |
327713 | 327713 | 2022-12-27 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-28 04:21:04 | Shandong, China | |||
219476 | 219476 | 2022-12-26 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-27 04:21:07 | Bienville, Louisiana, US | |
217786 | 217786 | 2022-12-26 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-27 04:21:07 | Shandong, China | |||
3223933 | 3223933 | 2022-12-25 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-26 04:21:06 | Bienville, Louisiana, US | |
3222243 | 3222243 | 2022-12-25 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-26 04:21:06 | Shandong, China | |||
1019847 | 1019847 | 2022-12-24 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-25 04:21:04 | Bienville, Louisiana, US | |
1018157 | 1018157 | 2022-12-24 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-25 04:21:04 | Shandong, China | |||
691870 | 691870 | 2022-12-23 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-24 04:21:02 | Bienville, Louisiana, US | |
690180 | 690180 | 2022-12-23 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-24 04:21:02 | Shandong, China | |||
2181080 | 2181080 | 2022-12-22 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-23 04:21:04 | Bienville, Louisiana, US | |
2179390 | 2179390 | 2022-12-22 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-23 04:21:04 | Shandong, China | |||
452884 | 452884 | 2022-12-21 | US | Louisiana | Bienville | 22013 | 4797 | 116 | 0 | 32.34569994 | -93.05398492 | 2022-12-22 04:20:56 | Bienville, Louisiana, US | |
451194 | 451194 | 2022-12-21 | China | Shandong | 4797 | 8 | 0 | 36.3427 | 118.1498 | 2022-12-22 04:20:56 | Shandong, China | |||
3555232 | 3555232 | 2022-11-27 | US | Wisconsin | Richland | 55103 | 4797 | 53 | 0 | 43.3762778 | -90.43012729 | 2022-11-28 04:21:02 | Richland, Wisconsin, US | |
2103712 | 2103712 | 2022-11-26 | US | Wisconsin | Richland | 55103 | 4797 | 53 | 0 | 43.3762778 | -90.43012729 | 2022-11-27 04:21:05 | Richland, Wisconsin, US | |
491203 | 491203 | 2022-11-25 | US | Wisconsin | Richland | 55103 | 4797 | 53 | 0 | 43.3762778 | -90.43012729 | 2022-11-26 04:21:11 | Richland, Wisconsin, US | |
2488546 | 2488546 | 2022-11-16 | US | Oklahoma | Choctaw | 40023 | 4797 | 68 | 0 | 34.02807439 | -95.54771129 | 2022-11-17 04:21:11 | Choctaw, Oklahoma, US | |
294557 | 294557 | 2022-11-15 | US | Oklahoma | Choctaw | 40023 | 4797 | 68 | 0 | 34.02807439 | -95.54771129 | 2022-11-16 04:21:09 | Choctaw, Oklahoma, US | |
3599587 | 3599587 | 2022-11-14 | US | Oklahoma | Choctaw | 40023 | 4797 | 68 | 0 | 34.02807439 | -95.54771129 | 2022-11-15 04:21:16 | Choctaw, Oklahoma, US | |
314445 | 314445 | 2022-11-13 | US | Oklahoma | Choctaw | 40023 | 4797 | 68 | 0 | 34.02807439 | -95.54771129 | 2022-11-14 04:21:09 | Choctaw, Oklahoma, US | |
65606 | 65606 | 2022-11-12 | US | Oklahoma | Choctaw | 40023 | 4797 | 68 | 0 | 34.02807439 | -95.54771129 | 2022-11-13 04:21:14 | Choctaw, Oklahoma, US | |
2929768 | 2929768 | 2022-11-11 | US | Oklahoma | Choctaw | 40023 | 4797 | 68 | 0 | 34.02807439 | -95.54771129 | 2022-11-12 04:20:41 | Choctaw, Oklahoma, US | |
2508604 | 2508604 | 2022-11-10 | US | Oklahoma | Choctaw | 40023 | 4797 | 68 | 0 | 34.02807439 | -95.54771129 | 2022-11-11 04:21:22 | Choctaw, Oklahoma, US | |
3550855 | 3550855 | 2022-09-01 | US | Virginia | Grayson | 51077 | 4797 | 83 | 0 | 36.65677234 | -81.23215889 | 2022-09-02 04:21:07 | Grayson, Virginia, US | |
3651070 | 3651070 | 2022-08-14 | US | West Virginia | Hardy | 54031 | 4797 | 50 | 0 | 39.00683177 | -78.85855301 | 2022-08-15 04:20:59 | Hardy, West Virginia, US | |
3648548 | 3648548 | 2022-08-14 | US | Illinois | Bond | 17005 | 4797 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-08-15 04:20:59 | Bond, Illinois, US | |
1972076 | 1972076 | 2022-08-13 | US | West Virginia | Hardy | 54031 | 4797 | 50 | 0 | 39.00683177 | -78.85855301 | 2022-08-14 04:20:55 | Hardy, West Virginia, US | |
1969554 | 1969554 | 2022-08-13 | US | Illinois | Bond | 17005 | 4797 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-08-14 04:20:55 | Bond, Illinois, US | |
2891885 | 2891885 | 2022-08-12 | US | West Virginia | Hardy | 54031 | 4797 | 50 | 0 | 39.00683177 | -78.85855301 | 2022-08-13 04:20:52 | Hardy, West Virginia, US | |
2889363 | 2889363 | 2022-08-12 | US | Illinois | Bond | 17005 | 4797 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-08-13 04:20:52 | Bond, Illinois, US | |
1070538 | 1070538 | 2022-08-07 | US | Colorado | Otero | 8089 | 4797 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-08-08 04:21:08 | Otero, Colorado, US | |
3618077 | 3618077 | 2022-08-01 | US | Illinois | Hancock | 17067 | 4797 | 48 | 0 | 40.40423981 | -91.16313899 | 2022-08-02 04:20:53 | Hancock, Illinois, US | |
2240527 | 2240527 | 2022-06-28 | US | Indiana | Perry | 18123 | 4797 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-06-29 04:20:59 | Perry, Indiana, US | |
2148769 | 2148769 | 2022-06-27 | US | Indiana | Perry | 18123 | 4797 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-06-28 04:20:58 | Perry, Indiana, US | |
1763857 | 1763857 | 2022-06-20 | US | Arkansas | Sharp | 5135 | 4797 | 108 | 0 | 36.16258158 | -91.47819342 | 2022-06-21 04:20:56 | Sharp, Arkansas, US | |
1947483 | 1947483 | 2022-06-10 | US | Tennessee | Polk | 47139 | 4797 | 77 | 0 | 35.12245443 | -84.52075859 | 2022-06-11 04:21:01 | Polk, Tennessee, US | |
3160622 | 3160622 | 2022-06-09 | US | Tennessee | Polk | 47139 | 4797 | 77 | 0 | 35.12245443 | -84.52075859 | 2022-06-10 04:20:55 | Polk, Tennessee, US | |
973467 | 973467 | 2022-06-01 | US | Oklahoma | Craig | 40035 | 4797 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-02 05:20:39 | Craig, Oklahoma, US | |
231774 | 231774 | 2022-05-31 | US | Oklahoma | Craig | 40035 | 4797 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-06-01 04:20:55 | Craig, Oklahoma, US | |
3188539 | 3188539 | 2022-05-30 | US | Oklahoma | Craig | 40035 | 4797 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-31 04:20:51 | Craig, Oklahoma, US | |
3200688 | 3200688 | 2022-05-29 | US | Oklahoma | Craig | 40035 | 4797 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-30 04:20:50 | Craig, Oklahoma, US | |
2727566 | 2727566 | 2022-05-28 | US | Oklahoma | Craig | 40035 | 4797 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-29 04:20:53 | Craig, Oklahoma, US | |
1316747 | 1316747 | 2022-05-27 | US | Oklahoma | Craig | 40035 | 4797 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-28 04:21:07 | Craig, Oklahoma, US | |
1852539 | 1852539 | 2022-05-26 | US | Oklahoma | Craig | 40035 | 4797 | 55 | 0 | 36.76268118 | -95.20916602 | 2022-05-27 04:20:56 | Craig, Oklahoma, US | |
1112955 | 1112955 | 2022-05-21 | US | Virginia | New Kent | 51127 | 4797 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-05-22 04:20:52 | New Kent, Virginia, US | |
1111039 | 1111039 | 2022-05-21 | US | Kentucky | Powell | 21197 | 4797 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-22 04:20:52 | Powell, Kentucky, US | |
1172579 | 1172579 | 2022-05-20 | US | Virginia | New Kent | 51127 | 4797 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-05-21 04:20:58 | New Kent, Virginia, US | |
1170663 | 1170663 | 2022-05-20 | US | Kentucky | Powell | 21197 | 4797 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-21 04:20:58 | Powell, Kentucky, US | |
3897426 | 3897426 | 2022-05-19 | US | Kentucky | Powell | 21197 | 4797 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-20 04:20:57 | Powell, Kentucky, US | |
1186210 | 1186210 | 2022-05-18 | US | Kentucky | Powell | 21197 | 4797 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-19 04:20:54 | Powell, Kentucky, US | |
3585322 | 3585322 | 2022-05-17 | US | Pennsylvania | Juniata | 42067 | 4797 | 176 | 0 | 40.53358749 | -77.3997513 | 2022-05-18 04:20:50 | Juniata, Pennsylvania, US | |
3584107 | 3584107 | 2022-05-17 | US | Kentucky | Powell | 21197 | 4797 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-18 04:20:50 | Powell, Kentucky, US | |
1506686 | 1506686 | 2022-05-16 | US | Texas | Fayette | 48149 | 4797 | 105 | 0 | 29.87788372 | -96.92076062 | 2022-05-17 04:20:59 | Fayette, Texas, US | |
1506279 | 1506279 | 2022-05-16 | US | Pennsylvania | Juniata | 42067 | 4797 | 176 | 0 | 40.53358749 | -77.3997513 | 2022-05-17 04:20:59 | Juniata, Pennsylvania, US | |
1505064 | 1505064 | 2022-05-16 | US | Kentucky | Powell | 21197 | 4797 | 44 | 0 | 37.83218794 | -83.82553961 | 2022-05-17 04:20:59 | Powell, Kentucky, US | |
2086638 | 2086638 | 2022-05-15 | US | Pennsylvania | Juniata | 42067 | 4797 | 176 | 0 | 40.53358749 | -77.3997513 | 2022-05-16 04:20:47 | Juniata, Pennsylvania, US | |
3357348 | 3357348 | 2022-05-14 | US | Pennsylvania | Juniata | 42067 | 4797 | 176 | 0 | 40.53358749 | -77.3997513 | 2022-05-15 04:20:53 | Juniata, Pennsylvania, US | |
660993 | 660993 | 2022-05-13 | US | Pennsylvania | Juniata | 42067 | 4797 | 176 | 0 | 40.53358749 | -77.3997513 | 2022-05-14 04:20:48 | Juniata, Pennsylvania, US | |
2536076 | 2536076 | 2022-05-12 | US | Pennsylvania | Juniata | 42067 | 4797 | 176 | 0 | 40.53358749 | -77.3997513 | 2022-05-13 04:20:51 | Juniata, Pennsylvania, US | |
3447522 | 3447522 | 2022-05-11 | US | Pennsylvania | Juniata | 42067 | 4797 | 176 | 0 | 40.53358749 | -77.3997513 | 2022-05-12 04:20:54 | Juniata, Pennsylvania, US | |
1224205 | 1224205 | 2022-04-14 | US | Colorado | Chaffee | 8015 | 4797 | 48 | 0 | 38.74745778 | -106.19265729999998 | 2022-04-15 04:20:57 | Chaffee, Colorado, US | |
2803847 | 2803847 | 2022-04-06 | US | Texas | Deaf Smith | 48117 | 4797 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-04-07 04:20:53 | Deaf Smith, Texas, US | |
3870616 | 3870616 | 2022-04-05 | US | Texas | Deaf Smith | 48117 | 4797 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-04-06 04:20:49 | Deaf Smith, Texas, US | |
3868061 | 3868061 | 2022-04-05 | US | Arkansas | Phillips | 5107 | 4797 | 98 | 0 | 34.43268455 | -90.84800154 | 2022-04-06 04:20:49 | Phillips, Arkansas, US | |
2751958 | 2751958 | 2022-04-04 | US | Texas | Deaf Smith | 48117 | 4797 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-04-05 04:20:48 | Deaf Smith, Texas, US | |
2749403 | 2749403 | 2022-04-04 | US | Arkansas | Phillips | 5107 | 4797 | 98 | 0 | 34.43268455 | -90.84800154 | 2022-04-05 04:20:48 | Phillips, Arkansas, US | |
3733304 | 3733304 | 2022-04-03 | US | Texas | Deaf Smith | 48117 | 4797 | 112 | 0 | 34.96522957 | -102.6054267 | 2022-04-04 04:20:51 | Deaf Smith, Texas, US | |
502739 | 502739 | 2022-04-02 | US | Texas | Deaf Smith | 48117 | 4797 | 111 | 0 | 34.96522957 | -102.6054267 | 2022-04-03 04:20:48 | Deaf Smith, Texas, US | |
3353724 | 3353724 | 2022-04-01 | US | Texas | Deaf Smith | 48117 | 4797 | 111 | 0 | 34.96522957 | -102.6054267 | 2022-04-02 04:20:47 | Deaf Smith, Texas, US | |
1541603 | 1541603 | 2022-03-31 | US | Michigan | Iosco | 26069 | 4797 | 139 | 0 | 44.35486835 | -83.63484895 | 2022-04-01 04:20:28 | Iosco, Michigan, US | |
1541237 | 1541237 | 2022-03-31 | US | Kansas | Dickinson | 20041 | 4797 | 77 | 0 | 38.86600962 | -97.15532383 | 2022-04-01 04:20:28 | Dickinson, Kansas, US | |
2479616 | 2479616 | 2022-03-30 | US | Michigan | Iosco | 26069 | 4797 | 139 | 0 | 44.35486835 | -83.63484895 | 2022-03-31 04:20:56 | Iosco, Michigan, US | |
2479250 | 2479250 | 2022-03-30 | US | Kansas | Dickinson | 20041 | 4797 | 77 | 0 | 38.86600962 | -97.15532383 | 2022-03-31 04:20:56 | Dickinson, Kansas, US | |
159657 | 159657 | 2022-03-29 | US | Michigan | Iosco | 26069 | 4797 | 139 | 0 | 44.35486835 | -83.63484895 | 2022-03-30 04:20:45 | Iosco, Michigan, US | |
1438475 | 1438475 | 2022-03-28 | US | Missouri | Clinton | 29049 | 4797 | 117 | 0 | 39.6013098 | -94.40465394 | 2022-03-29 04:20:46 | Clinton, Missouri, US | |
1438228 | 1438228 | 2022-03-28 | US | Michigan | Iosco | 26069 | 4797 | 139 | 0 | 44.35486835 | -83.63484895 | 2022-03-29 04:20:46 | Iosco, Michigan, US | |
1469745 | 1469745 | 2022-03-24 | US | Michigan | Iosco | 26069 | 4797 | 138 | 0 | 44.35486835 | -83.63484895 | 2022-03-25 04:20:46 | Iosco, Michigan, US | |
3023919 | 3023919 | 2022-03-23 | US | Michigan | Iosco | 26069 | 4797 | 138 | 0 | 44.35486835 | -83.63484895 | 2022-03-24 04:20:43 | Iosco, Michigan, US | |
2143462 | 2143462 | 2022-03-09 | US | Vermont | Orange | 50017 | 4797 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-03-10 04:20:48 | Orange, Vermont, US | |
3672175 | 3672175 | 2022-02-15 | US | Arkansas | Randolph | 5121 | 4797 | 74 | 0 | 36.3415714 | -91.02455531 | 2022-02-16 04:21:10 | Randolph, Arkansas, US | |
1364030 | 1364030 | 2022-02-08 | US | Michigan | Osceola | 26133 | 4797 | 70 | 0 | 43.98992088 | -85.32566756 | 2022-02-09 04:21:04 | Osceola, Michigan, US | |
72768 | 72768 | 2022-02-07 | US | Michigan | Osceola | 26133 | 4797 | 70 | 0 | 43.98992088 | -85.32566756 | 2022-02-08 04:21:15 | Osceola, Michigan, US | |
2015883 | 2015883 | 2022-02-06 | US | Texas | Milam | 48331 | 4797 | 93 | 0 | 30.78581830000001 | -96.97718698 | 2022-02-07 04:21:05 | Milam, Texas, US | |
3062399 | 3062399 | 2022-01-29 | US | Alabama | Randolph | 1111 | 4797 | 69 | 0 | 33.29526734 | -85.45708831 | 2022-01-30 04:21:26 | Randolph, Alabama, US | |
3465789 | 3465789 | 2022-01-18 | US | Michigan | Alpena | 26007 | 4797 | 120 | 0 | 45.03477666 | -83.62212411 | 2022-01-19 04:21:23 | Alpena, Michigan, US | |
1473728 | 1473728 | 2022-01-17 | US | Michigan | Alpena | 26007 | 4797 | 120 | 0 | 45.03477666 | -83.62212411 | 2022-01-18 04:21:04 | Alpena, Michigan, US | |
556402 | 556402 | 2022-01-16 | US | Michigan | Alpena | 26007 | 4797 | 120 | 0 | 45.03477666 | -83.62212411 | 2022-01-17 04:21:08 | Alpena, Michigan, US | |
3842123 | 3842123 | 2022-01-15 | US | Michigan | Alpena | 26007 | 4797 | 120 | 0 | 45.03477666 | -83.62212411 | 2022-01-16 04:21:12 | Alpena, Michigan, US | |
100938 | 100938 | 2022-01-14 | US | Michigan | Alpena | 26007 | 4797 | 120 | 0 | 45.03477666 | -83.62212411 | 2022-01-15 04:21:07 | Alpena, Michigan, US | |
732499 | 732499 | 2021-12-27 | US | Missouri | Stoddard | 29207 | 4797 | 110 | 0 | 36.85571651 | -89.9444155 | 2021-12-28 04:21:47 | Stoddard, Missouri, US | |
1662121 | 1662121 | 2021-12-12 | US | Michigan | Wexford | 26165 | 4797 | 79 | 0 | 44.33853602 | -85.57712739 | 2021-12-13 04:22:02 | Wexford, Michigan, US | |
1661190 | 1661190 | 2021-12-12 | US | Georgia | Butts | 13035 | 4797 | 123 | 0 | 33.283094500000004 | -83.95435040000002 | 2021-12-13 04:22:02 | Butts, Georgia, US | |
1666137 | 1666137 | 2021-12-11 | US | Michigan | Wexford | 26165 | 4797 | 79 | 0 | 44.33853602 | -85.57712739 | 2021-12-12 04:22:12 | Wexford, Michigan, US | |
1665206 | 1665206 | 2021-12-11 | US | Georgia | Butts | 13035 | 4797 | 123 | 0 | 33.283094500000004 | -83.95435040000002 | 2021-12-12 04:22:12 | Butts, Georgia, US | |
3657289 | 3657289 | 2021-12-10 | US | Michigan | Wexford | 26165 | 4797 | 79 | 0 | 44.33853602 | -85.57712739 | 2021-12-11 04:22:45 | Wexford, Michigan, US | |
3656358 | 3656358 | 2021-12-10 | US | Georgia | Butts | 13035 | 4797 | 123 | 0 | 33.283094500000004 | -83.95435040000002 | 2021-12-11 04:22:45 | Butts, Georgia, US | |
3656207 | 3656207 | 2021-12-10 | US | Colorado | Delta | 8029 | 4797 | 122 | 0 | 38.86246243 | -107.86313419999999 | 2021-12-11 04:22:45 | Delta, Colorado, 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]);