johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
187 rows where confirmed = 4758 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3552680 | 3552680 | 2022-11-27 | US | Illinois | Mercer | 17131 | 4758 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-11-28 04:21:02 | Mercer, Illinois, US | |
2101160 | 2101160 | 2022-11-26 | US | Illinois | Mercer | 17131 | 4758 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-11-27 04:21:05 | Mercer, Illinois, US | |
488651 | 488651 | 2022-11-25 | US | Illinois | Mercer | 17131 | 4758 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-11-26 04:21:11 | Mercer, Illinois, US | |
3524480 | 3524480 | 2022-11-24 | US | Illinois | Mercer | 17131 | 4758 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-11-25 04:21:06 | Mercer, Illinois, US | |
3313263 | 3313263 | 2022-11-23 | US | Illinois | Mercer | 17131 | 4758 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-11-24 04:21:09 | Mercer, Illinois, US | |
1621468 | 1621468 | 2022-11-22 | US | Iowa | Fayette | 19065 | 4758 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-11-23 04:21:06 | Fayette, Iowa, US | |
1621304 | 1621304 | 2022-11-22 | US | Illinois | Mercer | 17131 | 4758 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-11-23 04:21:06 | Mercer, Illinois, US | |
3461356 | 3461356 | 2022-11-21 | US | Iowa | Fayette | 19065 | 4758 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-11-22 04:20:47 | Fayette, Iowa, US | |
3461192 | 3461192 | 2022-11-21 | US | Illinois | Mercer | 17131 | 4758 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-11-22 04:20:47 | Mercer, Illinois, US | |
1641541 | 1641541 | 2022-11-20 | US | Iowa | Fayette | 19065 | 4758 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-11-21 04:21:05 | Fayette, Iowa, US | |
2065098 | 2065098 | 2022-11-19 | US | Iowa | Fayette | 19065 | 4758 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-11-20 04:21:08 | Fayette, Iowa, US | |
1756492 | 1756492 | 2022-11-18 | US | Iowa | Fayette | 19065 | 4758 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-11-19 04:21:14 | Fayette, Iowa, US | |
3027485 | 3027485 | 2022-11-17 | US | Iowa | Fayette | 19065 | 4758 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-11-18 04:21:15 | Fayette, Iowa, US | |
2487196 | 2487196 | 2022-11-16 | US | Iowa | Fayette | 19065 | 4758 | 84 | 0 | 42.86271799 | -91.8441231 | 2022-11-17 04:21:11 | Fayette, Iowa, US | |
1025103 | 1025103 | 2022-11-04 | US | Puerto Rico | Ciales | 72039 | 4758 | 0 | 0 | 18.28885 | -66.516475 | 2022-11-05 04:21:52 | Ciales, Puerto Rico, US | |
431834 | 431834 | 2022-11-03 | US | Arkansas | Clay | 5021 | 4758 | 100 | 0 | 36.36826212 | -90.4148172 | 2022-11-04 04:22:11 | Clay, Arkansas, US | |
850076 | 850076 | 2022-11-02 | US | Arkansas | Clay | 5021 | 4758 | 100 | 0 | 36.36826212 | -90.4148172 | 2022-11-03 04:22:05 | Clay, Arkansas, US | |
323341 | 323341 | 2022-10-30 | US | Virginia | Rockbridge | 51163 | 4758 | 90 | 0 | 37.81204314 | -79.44605905 | 2022-10-31 04:21:36 | Rockbridge, Virginia, US | |
915617 | 915617 | 2022-10-29 | US | Virginia | Rockbridge | 51163 | 4758 | 90 | 0 | 37.81204314 | -79.44605905 | 2022-10-30 04:22:14 | Rockbridge, Virginia, US | |
1369886 | 1369886 | 2022-10-28 | US | Virginia | Rockbridge | 51163 | 4758 | 90 | 0 | 37.81204314 | -79.44605905 | 2022-10-29 04:21:13 | Rockbridge, Virginia, US | |
1832006 | 1832006 | 2022-10-25 | US | Mississippi | Smith | 28129 | 4758 | 70 | 0 | 32.01744532 | -89.50644846 | 2022-10-26 04:22:19 | Smith, Mississippi, US | |
1831331 | 1831331 | 2022-10-25 | US | Iowa | Cedar | 19031 | 4758 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-26 04:22:19 | Cedar, Iowa, US | |
796267 | 796267 | 2022-10-24 | US | Mississippi | Smith | 28129 | 4758 | 70 | 0 | 32.01744532 | -89.50644846 | 2022-10-25 04:21:53 | Smith, Mississippi, US | |
795592 | 795592 | 2022-10-24 | US | Iowa | Cedar | 19031 | 4758 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-25 04:21:53 | Cedar, Iowa, US | |
3278722 | 3278722 | 2022-10-23 | US | Mississippi | Smith | 28129 | 4758 | 70 | 0 | 32.01744532 | -89.50644846 | 2022-10-24 04:22:29 | Smith, Mississippi, US | |
3278047 | 3278047 | 2022-10-23 | US | Iowa | Cedar | 19031 | 4758 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-24 04:22:29 | Cedar, Iowa, US | |
2269760 | 2269760 | 2022-10-22 | US | Mississippi | Smith | 28129 | 4758 | 70 | 0 | 32.01744532 | -89.50644846 | 2022-10-23 04:22:46 | Smith, Mississippi, US | |
2269085 | 2269085 | 2022-10-22 | US | Iowa | Cedar | 19031 | 4758 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-23 04:22:46 | Cedar, Iowa, US | |
1594060 | 1594060 | 2022-10-21 | US | Mississippi | Smith | 28129 | 4758 | 70 | 0 | 32.01744532 | -89.50644846 | 2022-10-22 04:22:53 | Smith, Mississippi, US | |
1593385 | 1593385 | 2022-10-21 | US | Iowa | Cedar | 19031 | 4758 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-22 04:22:53 | Cedar, Iowa, US | |
2273101 | 2273101 | 2022-10-20 | US | Iowa | Cedar | 19031 | 4758 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-21 04:22:23 | Cedar, Iowa, US | |
199436 | 199436 | 2022-10-19 | US | Iowa | Cedar | 19031 | 4758 | 43 | 0 | 41.77233777 | -91.13246684 | 2022-10-20 04:22:59 | Cedar, Iowa, US | |
2160966 | 2160966 | 2022-10-16 | US | Kentucky | Leslie | 21131 | 4758 | 55 | 0 | 37.09246661 | -83.37999606 | 2022-10-17 04:20:31 | Leslie, Kentucky, US | |
517163 | 517163 | 2022-10-15 | US | Kentucky | Leslie | 21131 | 4758 | 55 | 0 | 37.09246661 | -83.37999606 | 2022-10-16 04:22:39 | Leslie, Kentucky, US | |
2034220 | 2034220 | 2022-10-14 | US | Kentucky | Leslie | 21131 | 4758 | 55 | 0 | 37.09246661 | -83.37999606 | 2022-10-15 04:22:00 | Leslie, Kentucky, US | |
3754908 | 3754908 | 2022-10-13 | US | Kentucky | Leslie | 21131 | 4758 | 55 | 0 | 37.09246661 | -83.37999606 | 2022-10-14 04:22:28 | Leslie, Kentucky, US | |
3215733 | 3215733 | 2022-10-12 | US | Kentucky | Leslie | 21131 | 4758 | 55 | 0 | 37.09246661 | -83.37999606 | 2022-10-13 04:22:39 | Leslie, Kentucky, US | |
3251582 | 3251582 | 2022-10-11 | US | Kentucky | Leslie | 21131 | 4758 | 55 | 0 | 37.09246661 | -83.37999606 | 2022-10-12 04:22:51 | Leslie, Kentucky, US | |
2968841 | 2968841 | 2022-10-10 | US | Kentucky | Leslie | 21131 | 4758 | 55 | 0 | 37.09246661 | -83.37999606 | 2022-10-11 04:23:05 | Leslie, Kentucky, US | |
1879979 | 1879979 | 2022-08-28 | US | Tennessee | Sequatchie | 47153 | 4758 | 71 | 0 | 35.36979721 | -85.41022136 | 2022-08-29 04:21:06 | Sequatchie, Tennessee, US | |
2099106 | 2099106 | 2022-08-27 | US | Tennessee | Sequatchie | 47153 | 4758 | 71 | 0 | 35.36979721 | -85.41022136 | 2022-08-28 04:21:02 | Sequatchie, Tennessee, US | |
2830330 | 2830330 | 2022-08-25 | US | Louisiana | LaSalle | 22059 | 4758 | 64 | 0 | 31.67884782 | -92.15907765 | 2022-08-26 04:21:02 | LaSalle, Louisiana, US | |
1085838 | 1085838 | 2022-08-09 | Canada | Yukon | 4758 | 30 | 0 | 64.2823 | -135.0 | 2022-08-10 04:20:57 | Yukon, Canada | |||
1066522 | 1066522 | 2022-07-28 | US | Colorado | Otero | 8089 | 4758 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-07-29 04:20:45 | Otero, Colorado, US | |
1609774 | 1609774 | 2022-07-20 | US | Louisiana | Jackson | 22049 | 4758 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-07-21 04:21:10 | Jackson, Louisiana, US | |
630897 | 630897 | 2022-07-12 | US | Illinois | Ford | 17053 | 4758 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-07-13 04:20:58 | Ford, Illinois, US | |
1420226 | 1420226 | 2022-07-08 | US | Texas | Jones | 48253 | 4758 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-07-09 04:20:59 | Jones, Texas, US | |
2241690 | 2241690 | 2022-06-28 | US | North Carolina | Avery | 37011 | 4758 | 46 | 0 | 36.07569796 | -81.92308483 | 2022-06-29 04:20:59 | Avery, North Carolina, US | |
2149932 | 2149932 | 2022-06-27 | US | North Carolina | Avery | 37011 | 4758 | 46 | 0 | 36.07569796 | -81.92308483 | 2022-06-28 04:20:58 | Avery, North Carolina, US | |
477733 | 477733 | 2022-06-26 | US | North Carolina | Avery | 37011 | 4758 | 46 | 0 | 36.07569796 | -81.92308483 | 2022-06-27 04:21:00 | Avery, North Carolina, US | |
941108 | 941108 | 2022-06-25 | US | North Carolina | Avery | 37011 | 4758 | 46 | 0 | 36.07569796 | -81.92308483 | 2022-06-26 04:21:02 | Avery, North Carolina, US | |
3348928 | 3348928 | 2022-06-24 | US | North Carolina | Avery | 37011 | 4758 | 46 | 0 | 36.07569796 | -81.92308483 | 2022-06-25 04:20:57 | Avery, North Carolina, US | |
1650669 | 1650669 | 2022-06-23 | US | North Carolina | Avery | 37011 | 4758 | 46 | 0 | 36.07569796 | -81.92308483 | 2022-06-24 04:20:58 | Avery, North Carolina, US | |
2189904 | 2189904 | 2022-06-22 | US | North Carolina | Avery | 37011 | 4758 | 46 | 0 | 36.07569796 | -81.92308483 | 2022-06-23 04:20:55 | Avery, North Carolina, US | |
2188650 | 2188650 | 2022-06-22 | US | Illinois | Piatt | 17147 | 4758 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-06-23 04:20:55 | Piatt, Illinois, US | |
1172184 | 1172184 | 2022-05-20 | US | Tennessee | Polk | 47139 | 4758 | 74 | 0 | 35.12245443 | -84.52075859 | 2022-05-21 04:20:58 | Polk, Tennessee, US | |
1171977 | 1171977 | 2022-05-20 | US | Puerto Rico | San German | 72125 | 4758 | 0 | 0 | 18.111484 | -67.038581 | 2022-05-21 04:20:58 | San German, Puerto Rico, US | |
3898947 | 3898947 | 2022-05-19 | US | Tennessee | Polk | 47139 | 4758 | 74 | 0 | 35.12245443 | -84.52075859 | 2022-05-20 04:20:57 | Polk, Tennessee, US | |
3586170 | 3586170 | 2022-05-17 | US | Wisconsin | Adams | 55001 | 4758 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-05-18 04:20:50 | Adams, Wisconsin, US | |
224735 | 224735 | 2022-05-09 | US | Puerto Rico | Fajardo | 72053 | 4758 | 0 | 0 | 18.318373 | -65.666866 | 2022-05-10 04:20:50 | Fajardo, Puerto Rico, US | |
1327387 | 1327387 | 2022-04-26 | US | Indiana | Starke | 18149 | 4758 | 98 | 0 | 41.27890281 | -86.64686895 | 2022-04-27 04:20:52 | Starke, Indiana, US | |
3723341 | 3723341 | 2022-04-25 | US | Indiana | Starke | 18149 | 4758 | 98 | 0 | 41.27890281 | -86.64686895 | 2022-04-26 04:20:51 | Starke, Indiana, US | |
3320988 | 3320988 | 2022-04-07 | US | Georgia | Appling | 13001 | 4758 | 123 | 0 | 31.74847232 | -82.28909114 | 2022-04-08 04:20:48 | Appling, Georgia, US | |
2802645 | 2802645 | 2022-04-06 | US | Missouri | Andrew | 29003 | 4758 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-04-07 04:20:53 | Andrew, Missouri, US | |
3869414 | 3869414 | 2022-04-05 | US | Missouri | Andrew | 29003 | 4758 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-04-06 04:20:49 | Andrew, Missouri, US | |
2750756 | 2750756 | 2022-04-04 | US | Missouri | Andrew | 29003 | 4758 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-04-05 04:20:48 | Andrew, Missouri, US | |
3732102 | 3732102 | 2022-04-03 | US | Missouri | Andrew | 29003 | 4758 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-04-04 04:20:51 | Andrew, Missouri, US | |
501537 | 501537 | 2022-04-02 | US | Missouri | Andrew | 29003 | 4758 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-04-03 04:20:48 | Andrew, Missouri, US | |
3352522 | 3352522 | 2022-04-01 | US | Missouri | Andrew | 29003 | 4758 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-04-02 04:20:47 | Andrew, Missouri, US | |
1541827 | 1541827 | 2022-03-31 | US | Missouri | Andrew | 29003 | 4758 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-04-01 04:20:28 | Andrew, Missouri, US | |
2481057 | 2481057 | 2022-03-30 | US | Texas | Fayette | 48149 | 4758 | 104 | 0 | 29.87788372 | -96.92076062 | 2022-03-31 04:20:56 | Fayette, Texas, US | |
697068 | 697068 | 2022-03-17 | US | Pennsylvania | Juniata | 42067 | 4758 | 175 | 0 | 40.53358749 | -77.39975129999998 | 2022-03-18 04:20:55 | Juniata, Pennsylvania, US | |
2319939 | 2319939 | 2022-03-16 | US | Colorado | Chaffee | 8015 | 4758 | 47 | 0 | 38.74745778 | -106.19265729999998 | 2022-03-17 04:20:56 | Chaffee, Colorado, US | |
3628473 | 3628473 | 2022-03-13 | US | Arkansas | Phillips | 5107 | 4758 | 96 | 0 | 34.43268455 | -90.84800154 | 2022-03-14 04:20:46 | Phillips, Arkansas, US | |
2448051 | 2448051 | 2022-02-22 | US | Kansas | Dickinson | 20041 | 4758 | 72 | 0 | 38.86600962 | -97.15532383 | 2022-02-23 04:21:09 | Dickinson, Kansas, US | |
2447665 | 2447665 | 2022-02-22 | US | Georgia | Union | 13291 | 4758 | 144 | 0 | 34.82995757 | -83.98967069 | 2022-02-23 04:21:09 | Union, Georgia, US | |
3719464 | 3719464 | 2022-02-21 | US | Kansas | Dickinson | 20041 | 4758 | 72 | 0 | 38.86600962 | -97.15532383 | 2022-02-22 04:21:01 | Dickinson, Kansas, US | |
3821258 | 3821258 | 2022-02-16 | US | Georgia | Hart | 13147 | 4758 | 83 | 0 | 34.34626973 | -82.96567682 | 2022-02-17 04:20:56 | Hart, Georgia, US | |
2642888 | 2642888 | 2022-02-14 | US | Indiana | Rush | 18139 | 4758 | 50 | 0 | 39.62002287 | -85.4655599 | 2022-02-15 04:21:09 | Rush, Indiana, US | |
189657 | 189657 | 2022-02-13 | US | Wisconsin | Taylor | 55119 | 4758 | 66 | 0 | 45.21179252 | -90.5004405 | 2022-02-14 04:20:51 | Taylor, Wisconsin, US | |
319503 | 319503 | 2022-02-12 | US | Wisconsin | Taylor | 55119 | 4758 | 66 | 0 | 45.21179252 | -90.5004405 | 2022-02-13 04:21:00 | Taylor, Wisconsin, US | |
236829 | 236829 | 2022-02-11 | US | Wisconsin | Taylor | 55119 | 4758 | 66 | 0 | 45.21179252 | -90.5004405 | 2022-02-12 04:21:06 | Taylor, Wisconsin, US | |
1363524 | 1363524 | 2022-02-08 | US | Iowa | Carroll | 19027 | 4758 | 61 | 0 | 42.03617207 | -94.86032705 | 2022-02-09 04:21:04 | Carroll, Iowa, US | |
72262 | 72262 | 2022-02-07 | US | Iowa | Carroll | 19027 | 4758 | 61 | 0 | 42.03617207 | -94.86032705 | 2022-02-08 04:21:15 | Carroll, Iowa, US | |
2013878 | 2013878 | 2022-02-06 | US | Iowa | Carroll | 19027 | 4758 | 61 | 0 | 42.03617207 | -94.86032705 | 2022-02-07 04:21:05 | Carroll, Iowa, US | |
1295207 | 1295207 | 2022-02-05 | US | Iowa | Carroll | 19027 | 4758 | 61 | 0 | 42.03617207 | -94.86032705 | 2022-02-06 04:21:00 | Carroll, Iowa, US | |
2328535 | 2328535 | 2022-02-04 | US | Iowa | Carroll | 19027 | 4758 | 61 | 0 | 42.03617207 | -94.86032705 | 2022-02-05 04:21:05 | Carroll, Iowa, US | |
2475126 | 2475126 | 2022-02-03 | US | Iowa | Carroll | 19027 | 4758 | 61 | 0 | 42.03617207 | -94.86032705 | 2022-02-04 04:21:10 | Carroll, Iowa, US | |
460551 | 460551 | 2022-02-02 | US | Iowa | Carroll | 19027 | 4758 | 61 | 0 | 42.03617207 | -94.86032705 | 2022-02-03 04:21:21 | Carroll, Iowa, US | |
2660570 | 2660570 | 2022-01-31 | US | Puerto Rico | San Lorenzo | 72129 | 4758 | 0 | 0 | 18.147987 | -65.976392 | 2022-02-01 04:21:11 | San Lorenzo, Puerto Rico, US | |
1961644 | 1961644 | 2022-01-20 | US | Indiana | Fountain | 18045 | 4758 | 80 | 0 | 40.12361933 | -87.24217689 | 2022-01-21 04:21:09 | Fountain, Indiana, US | |
3615118 | 3615118 | 2022-01-12 | US | Nebraska | Cass | 31025 | 4758 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-01-13 08:00:09 | Cass, Nebraska, US | |
3614646 | 3614646 | 2022-01-12 | US | Maryland | Garrett | 24023 | 4758 | 101 | 0 | 39.52786077 | -79.27355126 | 2022-01-13 08:00:09 | Garrett, Maryland, US | |
801933 | 801933 | 2021-12-22 | US | West Virginia | Nicholas | 54067 | 4758 | 74 | 0 | 38.29617706 | -80.79759588 | 2021-12-23 04:21:21 | Nicholas, West Virginia, US | |
1718326 | 1718326 | 2021-12-16 | US | Missouri | Stoddard | 29207 | 4758 | 108 | 0 | 36.85571651 | -89.9444155 | 2021-12-17 04:22:14 | Stoddard, Missouri, US | |
3497232 | 3497232 | 2021-12-15 | US | Illinois | Saline | 17165 | 4758 | 74 | 0 | 37.75332999 | -88.54119706 | 2021-12-16 04:22:11 | Saline, Illinois, US | |
1032842 | 1032842 | 2021-12-06 | US | Ohio | Gallia | 39053 | 4758 | 84 | 0 | 38.82708533 | -82.31647569 | 2021-12-07 04:22:34 | Gallia, Ohio, US | |
3403588 | 3403588 | 2021-11-30 | US | Nevada | Nye | 32023 | 4758 | 168 | 0 | 38.04264256 | -116.47227020000001 | 2021-12-01 04:22:29 | Nye, Nevada, US | |
3402892 | 3402892 | 2021-11-30 | US | Kentucky | Montgomery | 21173 | 4758 | 63 | 0 | 38.03253032 | -83.9145241 | 2021-12-01 04:22:29 | Montgomery, Kentucky, US | |
152938 | 152938 | 2021-11-29 | US | Tennessee | Hickman | 47081 | 4758 | 78 | 0 | 35.80609681 | -87.47643507 | 2021-11-30 04:22:53 | Hickman, Tennessee, 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]);