johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
100 rows where confirmed = 7833 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3599865 | 3599865 | 2022-11-14 | US | South Carolina | Edgefield | 45037 | 7833 | 73 | 0 | 33.77221995 | -81.96231108 | 2022-11-15 04:21:16 | Edgefield, South Carolina, US | |
314723 | 314723 | 2022-11-13 | US | South Carolina | Edgefield | 45037 | 7833 | 73 | 0 | 33.77221995 | -81.96231108 | 2022-11-14 04:21:09 | Edgefield, South Carolina, US | |
65884 | 65884 | 2022-11-12 | US | South Carolina | Edgefield | 45037 | 7833 | 73 | 0 | 33.77221995 | -81.96231108 | 2022-11-13 04:21:14 | Edgefield, South Carolina, US | |
2930046 | 2930046 | 2022-11-11 | US | South Carolina | Edgefield | 45037 | 7833 | 73 | 0 | 33.77221995 | -81.96231108 | 2022-11-12 04:20:41 | Edgefield, South Carolina, US | |
2508882 | 2508882 | 2022-11-10 | US | South Carolina | Edgefield | 45037 | 7833 | 73 | 0 | 33.77221995 | -81.96231108 | 2022-11-11 04:21:22 | Edgefield, South Carolina, US | |
2433757 | 2433757 | 2022-11-09 | US | South Carolina | Edgefield | 45037 | 7833 | 73 | 0 | 33.77221995 | -81.96231108 | 2022-11-10 04:21:16 | Edgefield, South Carolina, US | |
482413 | 482413 | 2022-11-08 | US | South Carolina | Edgefield | 45037 | 7833 | 73 | 0 | 33.77221995 | -81.96231108 | 2022-11-09 04:21:22 | Edgefield, South Carolina, US | |
2530034 | 2530034 | 2022-10-06 | US | Colorado | Pitkin | 8097 | 7833 | 8 | 0 | 39.21720112 | -106.9310027 | 2022-10-07 04:23:08 | Pitkin, Colorado, US | |
420762 | 420762 | 2022-09-18 | US | Kentucky | Johnson | 21115 | 7833 | 129 | 0 | 37.85106355 | -82.8264322 | 2022-09-19 04:21:49 | Johnson, Kentucky, US | |
3374786 | 3374786 | 2022-09-17 | US | Kentucky | Johnson | 21115 | 7833 | 129 | 0 | 37.85106355 | -82.8264322 | 2022-09-18 04:22:50 | Johnson, Kentucky, US | |
2356894 | 2356894 | 2022-09-16 | US | Kentucky | Johnson | 21115 | 7833 | 129 | 0 | 37.85106355 | -82.8264322 | 2022-09-17 04:20:19 | Johnson, Kentucky, US | |
3988051 | 3988051 | 2022-09-15 | US | Kentucky | Johnson | 21115 | 7833 | 129 | 0 | 37.85106355 | -82.8264322 | 2022-09-16 04:21:19 | Johnson, Kentucky, US | |
1890568 | 1890568 | 2022-09-14 | US | Kentucky | Johnson | 21115 | 7833 | 129 | 0 | 37.85106355 | -82.8264322 | 2022-09-15 04:21:02 | Johnson, Kentucky, US | |
375093 | 375093 | 2022-09-13 | US | South Dakota | Meade | 46093 | 7833 | 67 | 0 | 44.56676791 | -102.7162741 | 2022-09-14 04:20:44 | Meade, South Dakota, US | |
373623 | 373623 | 2022-09-13 | US | Kentucky | Johnson | 21115 | 7833 | 129 | 0 | 37.85106355 | -82.8264322 | 2022-09-14 04:20:44 | Johnson, Kentucky, US | |
2397695 | 2397695 | 2022-09-12 | US | South Dakota | Meade | 46093 | 7833 | 67 | 0 | 44.56676791 | -102.7162741 | 2022-09-13 04:20:57 | Meade, South Dakota, US | |
2396225 | 2396225 | 2022-09-12 | US | Kentucky | Johnson | 21115 | 7833 | 129 | 0 | 37.85106355 | -82.8264322 | 2022-09-13 04:20:57 | Johnson, Kentucky, US | |
3768773 | 3768773 | 2022-09-11 | US | South Dakota | Meade | 46093 | 7833 | 67 | 0 | 44.56676791 | -102.7162741 | 2022-09-12 04:20:58 | Meade, South Dakota, US | |
3827348 | 3827348 | 2022-09-10 | US | South Dakota | Meade | 46093 | 7833 | 67 | 0 | 44.56676791 | -102.7162741 | 2022-09-11 04:20:50 | Meade, South Dakota, US | |
965805 | 965805 | 2022-09-09 | US | South Dakota | Meade | 46093 | 7833 | 67 | 0 | 44.56676791 | -102.7162741 | 2022-09-10 04:21:10 | Meade, South Dakota, US | |
256207 | 256207 | 2022-09-08 | US | South Dakota | Meade | 46093 | 7833 | 67 | 0 | 44.56676791 | -102.7162741 | 2022-09-09 04:21:11 | Meade, South Dakota, US | |
3748005 | 3748005 | 2022-09-07 | US | South Dakota | Meade | 46093 | 7833 | 67 | 0 | 44.56676791 | -102.7162741 | 2022-09-08 04:21:02 | Meade, South Dakota, US | |
3746625 | 3746625 | 2022-09-07 | US | Louisiana | Jefferson Davis | 22053 | 7833 | 169 | 0 | 30.26896765 | -92.81210004 | 2022-09-08 04:21:02 | Jefferson Davis, Louisiana, US | |
3775412 | 3775412 | 2022-08-30 | US | Louisiana | East Feliciana | 22037 | 7833 | 173 | 0 | 30.84425359 | -91.04976723 | 2022-08-31 04:20:57 | East Feliciana, Louisiana, US | |
1101435 | 1101435 | 2022-08-03 | US | Virginia | Caroline | 51033 | 7833 | 89 | 0 | 38.02679129 | -77.34901405 | 2022-08-04 04:20:58 | Caroline, Virginia, US | |
1490844 | 1490844 | 2022-07-26 | US | Texas | Willacy | 48489 | 7833 | 134 | 0 | 26.47411727 | -97.61535848 | 2022-07-27 04:21:04 | Willacy, Texas, US | |
3211914 | 3211914 | 2022-07-18 | US | Michigan | Dickinson | 26043 | 7833 | 113 | 0 | 46.00999672 | -87.86961634 | 2022-07-19 04:20:58 | Dickinson, Michigan, US | |
3407089 | 3407089 | 2022-07-17 | US | Michigan | Dickinson | 26043 | 7833 | 113 | 0 | 46.00999672 | -87.86961634 | 2022-07-18 04:20:59 | Dickinson, Michigan, US | |
2153289 | 2153289 | 2022-07-16 | US | Michigan | Dickinson | 26043 | 7833 | 113 | 0 | 46.00999672 | -87.86961634 | 2022-07-17 04:21:15 | Dickinson, Michigan, US | |
2420522 | 2420522 | 2022-07-15 | US | Michigan | Dickinson | 26043 | 7833 | 113 | 0 | 46.00999672 | -87.86961634 | 2022-07-16 04:21:05 | Dickinson, Michigan, US | |
3430597 | 3430597 | 2022-07-14 | US | Michigan | Dickinson | 26043 | 7833 | 113 | 0 | 46.00999672 | -87.86961634 | 2022-07-15 04:20:53 | Dickinson, Michigan, US | |
3111117 | 3111117 | 2022-07-13 | US | Michigan | Dickinson | 26043 | 7833 | 113 | 0 | 46.00999672 | -87.86961634 | 2022-07-14 04:20:57 | Dickinson, Michigan, US | |
631540 | 631540 | 2022-07-12 | US | Michigan | Dickinson | 26043 | 7833 | 113 | 0 | 46.00999672 | -87.86961634 | 2022-07-13 04:20:58 | Dickinson, Michigan, US | |
2744411 | 2744411 | 2022-07-07 | US | Virginia | Pulaski | 51155 | 7833 | 141 | 0 | 37.06474963 | -80.71229738 | 2022-07-08 04:20:56 | Pulaski, Virginia, US | |
2741413 | 2741413 | 2022-07-07 | US | Alabama | Pike | 1109 | 7833 | 134 | 0 | 31.80396383 | -85.9408295 | 2022-07-08 04:20:56 | Pike, Alabama, US | |
2238920 | 2238920 | 2022-06-12 | US | Wisconsin | Clark | 55019 | 7833 | 121 | 0 | 44.73483377 | -90.61207486 | 2022-06-13 04:21:14 | Clark, Wisconsin, US | |
3145118 | 3145118 | 2022-06-11 | US | Wisconsin | Clark | 55019 | 7833 | 121 | 0 | 44.73483377 | -90.61207486 | 2022-06-12 04:20:53 | Clark, Wisconsin, US | |
1948034 | 1948034 | 2022-06-10 | US | Wisconsin | Clark | 55019 | 7833 | 121 | 0 | 44.73483377 | -90.61207486 | 2022-06-11 04:21:01 | Clark, Wisconsin, US | |
2534714 | 2534714 | 2022-05-12 | US | Kansas | McPherson | 20113 | 7833 | 128 | 0 | 38.39184858 | -97.64769869 | 2022-05-13 04:20:51 | McPherson, Kansas, US | |
3446160 | 3446160 | 2022-05-11 | US | Kansas | McPherson | 20113 | 7833 | 128 | 0 | 38.39184858 | -97.64769869 | 2022-05-12 04:20:54 | McPherson, Kansas, US | |
3536777 | 3536777 | 2022-05-10 | US | Kansas | McPherson | 20113 | 7833 | 128 | 0 | 38.39184858 | -97.64769869 | 2022-05-11 04:20:48 | McPherson, Kansas, US | |
223312 | 223312 | 2022-05-09 | US | Kansas | McPherson | 20113 | 7833 | 128 | 0 | 38.39184858 | -97.64769869 | 2022-05-10 04:20:50 | McPherson, Kansas, US | |
2332697 | 2332697 | 2022-05-08 | US | Kansas | McPherson | 20113 | 7833 | 128 | 0 | 38.39184858 | -97.64769869 | 2022-05-09 04:20:54 | McPherson, Kansas, US | |
361659 | 361659 | 2022-05-07 | US | Kansas | McPherson | 20113 | 7833 | 128 | 0 | 38.39184858 | -97.64769869 | 2022-05-08 04:20:49 | McPherson, Kansas, US | |
1399010 | 1399010 | 2022-05-06 | US | Kansas | McPherson | 20113 | 7833 | 128 | 0 | 38.39184858 | -97.64769869 | 2022-05-07 04:21:09 | McPherson, Kansas, US | |
2481470 | 2481470 | 2022-03-30 | US | West Virginia | Mineral | 54057 | 7833 | 157 | 0 | 39.41561583 | -78.94104895 | 2022-03-31 04:20:56 | Mineral, West Virginia, US | |
25444 | 25444 | 2022-03-20 | US | Illinois | Saline | 17165 | 7833 | 93 | 0 | 37.75332999 | -88.54119706 | 2022-03-21 04:20:50 | Saline, Illinois, US | |
1657454 | 1657454 | 2022-03-19 | US | Illinois | Saline | 17165 | 7833 | 93 | 0 | 37.75332999 | -88.54119706 | 2022-03-20 04:20:45 | Saline, Illinois, US | |
336980 | 336980 | 2022-03-18 | US | Illinois | Saline | 17165 | 7833 | 93 | 0 | 37.75332999 | -88.54119706 | 2022-03-19 04:20:47 | Saline, Illinois, US | |
1059780 | 1059780 | 2022-02-23 | US | Missouri | Marion | 29127 | 7833 | 113 | 0 | 39.80601912 | -91.62203062 | 2022-02-24 04:21:14 | Marion, Missouri, US | |
1059337 | 1059337 | 2022-02-23 | US | Louisiana | Allen | 22003 | 7833 | 128 | 0 | 30.65385745 | -92.82442028 | 2022-02-24 04:21:14 | Allen, Louisiana, US | |
188022 | 188022 | 2022-02-13 | US | Missouri | Polk | 29167 | 7833 | 86 | 0 | 37.616229600000004 | -93.39828174 | 2022-02-14 04:20:51 | Polk, Missouri, US | |
317868 | 317868 | 2022-02-12 | US | Missouri | Polk | 29167 | 7833 | 86 | 0 | 37.616229600000004 | -93.39828174 | 2022-02-13 04:21:00 | Polk, Missouri, US | |
235194 | 235194 | 2022-02-11 | US | Missouri | Polk | 29167 | 7833 | 86 | 0 | 37.616229600000004 | -93.39828174 | 2022-02-12 04:21:06 | Polk, Missouri, US | |
1466036 | 1466036 | 2022-02-10 | US | Missouri | Polk | 29167 | 7833 | 86 | 0 | 37.616229600000004 | -93.39828174 | 2022-02-11 04:21:09 | Polk, Missouri, US | |
459230 | 459230 | 2022-02-02 | Comoros | 7833 | 160 | 0 | -11.6455 | 43.3333 | 2022-02-03 04:21:21 | Comoros | ||||
3301341 | 3301341 | 2022-01-30 | US | Indiana | Ripley | 18137 | 7833 | 121 | 0 | 39.10235626 | -85.26212744 | 2022-01-31 04:21:09 | Ripley, Indiana, US | |
3063132 | 3063132 | 2022-01-29 | US | Indiana | Ripley | 18137 | 7833 | 121 | 0 | 39.10235626 | -85.26212744 | 2022-01-30 04:21:26 | Ripley, Indiana, US | |
3811066 | 3811066 | 2022-01-28 | US | Indiana | Ripley | 18137 | 7833 | 121 | 0 | 39.10235626 | -85.26212744 | 2022-01-29 04:21:10 | Ripley, Indiana, US | |
1782247 | 1782247 | 2022-01-27 | US | South Dakota | Codington | 46029 | 7833 | 93 | 0 | 44.97788119 | -97.18827677 | 2022-01-28 04:21:09 | Codington, South Dakota, US | |
1140942 | 1140942 | 2022-01-23 | Japan | Wakayama | 7833 | 64 | 0 | 33.911879 | 135.505446 | 2022-01-24 04:21:12 | Wakayama, Japan | |||
801350 | 801350 | 2021-12-22 | US | Tennessee | Campbell | 47013 | 7833 | 121 | 0 | 36.40355516 | -84.15108559999999 | 2021-12-23 04:21:21 | Campbell, Tennessee, US | |
1719896 | 1719896 | 2021-12-16 | US | Wisconsin | Douglas | 55031 | 7833 | 70 | 0 | 46.43222285 | -91.91595768 | 2021-12-17 04:22:14 | Douglas, Wisconsin, US | |
3497239 | 3497239 | 2021-12-15 | US | Illinois | Stephenson | 17177 | 7833 | 117 | 0 | 42.35129217 | -89.662598 | 2021-12-16 04:22:11 | Stephenson, Illinois, US | |
1741132 | 1741132 | 2021-12-05 | US | California | Tuolumne | 6109 | 7833 | 91 | 0 | 38.02644018 | -119.95250929999999 | 2021-12-06 04:22:34 | Tuolumne, California, US | |
1910580 | 1910580 | 2021-10-17 | US | Kentucky | Barren | 21009 | 7833 | 136 | 0 | 36.96469836 | -85.93338945 | 2021-10-18 04:21:10 | Barren, Kentucky, US | |
469935 | 469935 | 2021-10-07 | US | Ohio | Washington | 39167 | 7833 | 147 | 0 | 39.45690571 | -81.49121382 | 2021-10-08 04:21:25 | Washington, Ohio, US | |
706433 | 706433 | 2021-09-29 | Japan | Ishikawa | 7833 | 124 | 0 | 36.769464 | 136.771027 | 2021-09-30 04:21:20 | Ishikawa, Japan | |||
810190 | 810190 | 2021-09-20 | US | Colorado | Eagle | 8037 | 7833 | 31 | 0 | 39.62754308 | -106.6933637 | 2021-09-21 04:21:26 | Eagle, Colorado, US | |
1265256 | 1265256 | 2021-09-09 | US | Ohio | Hancock | 39063 | 7833 | 143 | 0 | 41.00250487 | -83.66838948 | 2021-09-10 04:21:20 | Hancock, Ohio, US | |
252194 | 252194 | 2021-09-04 | US | Tennessee | Bedford | 47003 | 7833 | 136 | 0 | 35.51123746 | -86.45549096 | 2021-09-05 04:21:33 | Bedford, Tennessee, US | |
1604578 | 1604578 | 2021-08-16 | US | Alabama | Blount | 1009 | 7833 | 141 | 0 | 33.98210918 | -86.56790593 | 2021-08-17 04:21:49 | Blount, Alabama, US | |
2901384 | 2901384 | 2021-08-12 | US | Minnesota | Blue Earth | 27013 | 7833 | 44 | 0 | 44.03554215 | -94.06699781 | 2021-08-13 04:21:24 | Blue Earth, Minnesota, US | |
3334786 | 3334786 | 2021-07-21 | US | Texas | Wise | 48497 | 7833 | 129 | 0 | 33.21570665 | -97.65460265 | 2021-07-22 04:21:19 | Wise, Texas, US | |
402812 | 402812 | 2021-06-29 | US | Oklahoma | Garfield | 40047 | 7833 | 139 | 0 | 36.3791334 | -97.78265517 | 2021-06-30 04:21:41 | Garfield, Oklahoma, US | |
3128055 | 3128055 | 2021-06-28 | US | Oklahoma | Garfield | 40047 | 7833 | 139 | 0 | 36.3791334 | -97.78265517 | 2021-06-29 04:21:28 | Garfield, Oklahoma, US | |
2592550 | 2592550 | 2021-06-27 | US | Oklahoma | Garfield | 40047 | 7833 | 139 | 0 | 36.3791334 | -97.78265517 | 2021-06-28 04:21:29 | Garfield, Oklahoma, US | |
3961054 | 3961054 | 2021-06-26 | US | Oklahoma | Garfield | 40047 | 7833 | 139 | 0 | 36.3791334 | -97.78265517 | 2021-06-27 04:21:39 | Garfield, Oklahoma, US | |
1714873 | 1714873 | 2021-06-25 | US | Oklahoma | Garfield | 40047 | 7833 | 139 | 0 | 36.3791334 | -97.78265517 | 2021-06-26 04:21:43 | Garfield, Oklahoma, US | |
2297998 | 2297998 | 2021-06-24 | US | Oklahoma | Garfield | 40047 | 7833 | 139 | 0 | 36.3791334 | -97.78265517 | 2021-06-25 04:21:33 | Garfield, Oklahoma, US | |
2425437 | 2425437 | 2021-06-23 | US | Oklahoma | Garfield | 40047 | 7833 | 139 | 0 | 36.3791334 | -97.78265517 | 2021-06-24 04:21:55 | Garfield, Oklahoma, US | |
2316447 | 2316447 | 2021-06-04 | US | Indiana | Warrick | 18173 | 7833 | 156 | 0 | 38.08922676 | -87.2716085 | 2021-06-05 04:23:03 | Warrick, Indiana, US | |
2107491 | 2107491 | 2021-06-01 | US | Virginia | Lynchburg | 51680 | 7833 | 153 | 0 | 37.40021399 | -79.19888138 | 2021-06-02 04:24:34 | Lynchburg, Virginia, US | |
606590 | 606590 | 2021-04-09 | US | Guam | 66 | 7833 | 136 | 0 | 13.4443 | 144.7937 | 2021-04-10 04:20:59 | Guam, US | ||
3085828 | 3085828 | 2021-04-05 | US | Arkansas | White | 5145 | 7833 | 116 | 0 | 35.25688493 | -91.74908296 | 2021-04-06 04:20:32 | White, Arkansas, US | |
3710590 | 3710590 | 2021-04-03 | US | Arizona | Santa Cruz | 4023 | 7833 | 173 | 0 | 31.52508998 | -110.8479088 | 2021-04-04 04:20:49 | Santa Cruz, Arizona, US | |
2783621 | 2783621 | 2021-03-24 | US | Oregon | Umatilla | 41059 | 7833 | 82 | 0 | 45.59073056 | -118.7353826 | 2021-03-25 05:27:00 | Umatilla, Oregon, US | |
2781794 | 2781794 | 2021-03-24 | US | Georgia | Gordon | 13129 | 7833 | 106 | 0 | 34.50487351 | -84.87296253 | 2021-03-25 05:27:00 | Gordon, Georgia, US | |
1583826 | 1583826 | 2021-03-13 | Malaysia | Kedah | 7833 | 23 | 7649 | 161 | 6.1184 | 100.3685 | 2021-03-14 05:25:37 | Kedah, Malaysia | ||
2211887 | 2211887 | 2021-01-30 | Russia | Magadan Oblast | 7833 | 88 | 7401 | 344 | 62.48858785 | 153.9903764 | 2021-01-31 05:22:42 | Magadan Oblast, Russia | ||
2483538 | 2483538 | 2021-01-28 | US | Maryland | Charles | 24017 | 7833 | 144 | 0 | 7689 | 38.51092331 | -76.98580666 | 2021-01-29 05:22:23 | Charles, Maryland, US |
3149732 | 3149732 | 2020-12-16 | Pakistan | Azad Jammu and Kashmir | 7833 | 194 | 6495 | 1144 | 34.027401 | 73.947253 | 2020-12-17 05:28:12 | Azad Jammu and Kashmir, Pakistan | ||
740623 | 740623 | 2020-12-02 | US | North Carolina | Johnston | 37101 | 7833 | 78 | 0 | 7755 | 35.51745004 | -78.36622717 | 2020-12-03 05:28:22 | Johnston, North Carolina, US |
1988704 | 1988704 | 2020-11-09 | Mauritania | 7833 | 165 | 7485 | 183 | 21.0079 | -10.9408 | 2020-11-10 05:40:07 | Mauritania | |||
3483716 | 3483716 | 2020-10-26 | US | Virginia | Virginia Beach | 51810 | 7833 | 104 | 0 | 7729 | 36.73285734 | -76.04566934 | 2020-10-27 04:24:45 | Virginia Beach, Virginia, US |
3784052 | 3784052 | 2020-10-13 | US | New Jersey | Burlington | 34005 | 7833 | 504 | 0 | 7329 | 39.87681124 | -74.66927768 | 2020-10-14 04:24:05 | Burlington, New Jersey, US |
2609464 | 2609464 | 2020-09-24 | US | Washington | Pierce | 53053 | 7833 | 192 | 0 | 7641 | 47.03892768 | -122.1405958 | 2020-09-25 04:23:00 | Pierce, Washington, US |
2156204 | 2156204 | 2020-07-14 | US | New York | Erie | 36029 | 7833 | 646 | 0 | 7187 | 42.76249024 | -78.73063652 | 2020-07-15 04:34:39 | Erie, New York, US |
1510418 | 1510418 | 2020-06-22 | Germany | Berlin | 7833 | 211 | 6920 | 784 | 52.52 | 13.405 | 2020-06-23 04:33:22 | Berlin, Germany | ||
805691 | 805691 | 2020-06-01 | Morocco | 7833 | 205 | 5893 | 1735 | 31.7917 | -7.0926 | 2020-06-02 02:33:08 | Morocco |
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]);