johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
137 rows where confirmed = 6093 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2138875 | 2138875 | 2022-12-01 | US | Puerto Rico | Adjuntas | 72001 | 6093 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-02 04:21:07 | Adjuntas, Puerto Rico, US | |
1967291 | 1967291 | 2022-11-30 | US | Puerto Rico | Adjuntas | 72001 | 6093 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-01 04:21:03 | Adjuntas, Puerto Rico, US | |
3554584 | 3554584 | 2022-11-27 | US | Tennessee | Crockett | 47033 | 6093 | 89 | 0 | 35.81830662 | -89.14916269 | 2022-11-28 04:21:02 | Crockett, Tennessee, US | |
3527003 | 3527003 | 2022-11-24 | US | Wisconsin | Green Lake | 55047 | 6093 | 70 | 0 | 43.80025981 | -89.04679553 | 2022-11-25 04:21:06 | Green Lake, Wisconsin, US | |
3215390 | 3215390 | 2022-10-12 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-13 04:22:39 | Fountain, Indiana, US | |
3251239 | 3251239 | 2022-10-11 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-12 04:22:51 | Fountain, Indiana, US | |
2968498 | 2968498 | 2022-10-10 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-11 04:23:05 | Fountain, Indiana, US | |
3101037 | 3101037 | 2022-10-09 | US | Wisconsin | Vilas | 55125 | 6093 | 100 | 0 | 46.05467334 | -89.51719204 | 2022-10-10 04:22:32 | Vilas, Wisconsin, US | |
3098534 | 3098534 | 2022-10-09 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-10 04:22:32 | Fountain, Indiana, US | |
4006262 | 4006262 | 2022-10-08 | US | Wisconsin | Vilas | 55125 | 6093 | 100 | 0 | 46.05467334 | -89.51719204 | 2022-10-09 04:21:16 | Vilas, Wisconsin, US | |
4003759 | 4003759 | 2022-10-08 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-09 04:21:16 | Fountain, Indiana, US | |
399859 | 399859 | 2022-10-07 | US | Wisconsin | Vilas | 55125 | 6093 | 100 | 0 | 46.05467334 | -89.51719204 | 2022-10-08 04:22:56 | Vilas, Wisconsin, US | |
397356 | 397356 | 2022-10-07 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-08 04:22:56 | Fountain, Indiana, US | |
2530473 | 2530473 | 2022-10-06 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-07 04:23:08 | Fountain, Indiana, US | |
1811867 | 1811867 | 2022-10-05 | US | Indiana | Fountain | 18045 | 6093 | 107 | 0 | 40.12361933 | -87.24217689 | 2022-10-06 04:21:22 | Fountain, Indiana, US | |
2831017 | 2831017 | 2022-08-25 | US | New Mexico | Lincoln | 35027 | 6093 | 70 | 0 | 33.74526079 | -105.4586166 | 2022-08-26 04:21:02 | Lincoln, New Mexico, US | |
3910726 | 3910726 | 2022-08-11 | US | Puerto Rico | Barceloneta | 72017 | 6093 | 0 | 0 | 18.445533 | -66.560531 | 2022-08-12 04:20:54 | Barceloneta, Puerto Rico, US | |
1349328 | 1349328 | 2022-08-10 | US | Tennessee | Wayne | 47181 | 6093 | 75 | 0 | 35.23868267 | -87.78644456 | 2022-08-11 04:20:49 | Wayne, Tennessee, US | |
1071745 | 1071745 | 2022-08-07 | US | Mississippi | Sunflower | 28133 | 6093 | 126 | 0 | 33.60192578 | -90.58882684 | 2022-08-08 04:21:08 | Sunflower, Mississippi, US | |
1942333 | 1942333 | 2022-08-06 | US | Mississippi | Sunflower | 28133 | 6093 | 126 | 0 | 33.60192578 | -90.58882684 | 2022-08-07 04:20:54 | Sunflower, Mississippi, US | |
882132 | 882132 | 2022-08-05 | US | Mississippi | Sunflower | 28133 | 6093 | 126 | 0 | 33.60192578 | -90.58882684 | 2022-08-06 04:20:56 | Sunflower, Mississippi, US | |
2010543 | 2010543 | 2022-08-04 | US | Mississippi | Sunflower | 28133 | 6093 | 126 | 0 | 33.60192578 | -90.58882684 | 2022-08-05 04:20:52 | Sunflower, Mississippi, US | |
3874349 | 3874349 | 2022-07-31 | US | Puerto Rico | Utuado | 72141 | 6093 | 0 | 0 | 18.271214 | -66.702984 | 2022-08-01 04:21:03 | Utuado, Puerto Rico, US | |
1069370 | 1069370 | 2022-07-28 | US | West Virginia | Lincoln | 54043 | 6093 | 84 | 0 | 38.172154 | -82.07017953 | 2022-07-29 04:20:45 | Lincoln, West Virginia, US | |
2338728 | 2338728 | 2022-07-27 | US | Virginia | Dinwiddie | 51053 | 6093 | 96 | 0 | 37.07544585 | -77.63451754 | 2022-07-28 04:20:56 | Dinwiddie, Virginia, US | |
2595713 | 2595713 | 2022-07-25 | US | Michigan | Otsego | 26137 | 6093 | 104 | 0 | 45.02085831 | -84.59898295 | 2022-07-26 04:20:58 | Otsego, Michigan, US | |
897828 | 897828 | 2022-07-24 | US | Michigan | Otsego | 26137 | 6093 | 104 | 0 | 45.02085831 | -84.59898295 | 2022-07-25 04:20:51 | Otsego, Michigan, US | |
92822 | 92822 | 2022-07-23 | US | Michigan | Otsego | 26137 | 6093 | 104 | 0 | 45.02085831 | -84.59898295 | 2022-07-24 04:20:47 | Otsego, Michigan, US | |
901844 | 901844 | 2022-07-22 | US | Michigan | Otsego | 26137 | 6093 | 104 | 0 | 45.02085831 | -84.59898295 | 2022-07-23 04:20:53 | Otsego, Michigan, US | |
671980 | 671980 | 2022-07-21 | US | Michigan | Otsego | 26137 | 6093 | 104 | 0 | 45.02085831 | -84.59898295 | 2022-07-22 04:21:15 | Otsego, Michigan, US | |
1609943 | 1609943 | 2022-07-20 | US | Michigan | Otsego | 26137 | 6093 | 104 | 0 | 45.02085831 | -84.59898295 | 2022-07-21 04:21:10 | Otsego, Michigan, US | |
960576 | 960576 | 2022-07-19 | US | Michigan | Otsego | 26137 | 6093 | 104 | 0 | 45.02085831 | -84.59898295 | 2022-07-20 04:20:59 | Otsego, Michigan, US | |
3408177 | 3408177 | 2022-07-17 | US | Puerto Rico | Anasco | 72011 | 6093 | 0 | 0 | 18.287985 | -67.120611 | 2022-07-18 04:20:59 | Anasco, Puerto Rico, US | |
3968875 | 3968875 | 2022-07-05 | US | North Carolina | Greene | 37079 | 6093 | 70 | 0 | 35.48544173 | -77.67578087 | 2022-07-06 04:20:58 | Greene, North Carolina, US | |
3080386 | 3080386 | 2022-07-04 | US | North Carolina | Greene | 37079 | 6093 | 70 | 0 | 35.48544173 | -77.67578087 | 2022-07-05 04:20:45 | Greene, North Carolina, US | |
1769668 | 1769668 | 2022-07-03 | US | North Carolina | Greene | 37079 | 6093 | 70 | 0 | 35.48544173 | -77.67578087 | 2022-07-04 04:20:54 | Greene, North Carolina, US | |
3367654 | 3367654 | 2022-07-02 | US | North Carolina | Greene | 37079 | 6093 | 70 | 0 | 35.48544173 | -77.67578087 | 2022-07-03 04:20:59 | Greene, North Carolina, US | |
595983 | 595983 | 2022-07-01 | US | North Carolina | Greene | 37079 | 6093 | 70 | 0 | 35.48544173 | -77.67578087 | 2022-07-02 04:21:16 | Greene, North Carolina, US | |
3942384 | 3942384 | 2022-06-30 | US | North Carolina | Greene | 37079 | 6093 | 70 | 0 | 35.48544173 | -77.67578087 | 2022-07-01 04:21:10 | Greene, North Carolina, US | |
2492342 | 2492342 | 2022-06-29 | US | North Carolina | Greene | 37079 | 6093 | 70 | 0 | 35.48544173 | -77.67578087 | 2022-06-30 04:21:01 | Greene, North Carolina, US | |
2242957 | 2242957 | 2022-06-28 | US | Wisconsin | Kewaunee | 55061 | 6093 | 60 | 0 | 44.51727459 | -87.61468386 | 2022-06-29 04:20:59 | Kewaunee, Wisconsin, US | |
3349777 | 3349777 | 2022-06-24 | US | Texas | Karnes | 48255 | 6093 | 71 | 0 | 28.90705334 | -97.85960149 | 2022-06-25 04:20:57 | Karnes, Texas, US | |
1651518 | 1651518 | 2022-06-23 | US | Texas | Karnes | 48255 | 6093 | 71 | 0 | 28.90705334 | -97.85960149 | 2022-06-24 04:20:58 | Karnes, Texas, US | |
2190753 | 2190753 | 2022-06-22 | US | Texas | Karnes | 48255 | 6093 | 71 | 0 | 28.90705334 | -97.85960149 | 2022-06-23 04:20:55 | Karnes, Texas, US | |
2982742 | 2982742 | 2022-06-13 | US | West Virginia | Hampshire | 54027 | 6093 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-06-14 04:20:52 | Hampshire, West Virginia, US | |
3537802 | 3537802 | 2022-05-10 | US | North Carolina | Martin | 37117 | 6093 | 93 | 0 | 35.84326734 | -77.10860251 | 2022-05-11 04:20:48 | Martin, North Carolina, US | |
224337 | 224337 | 2022-05-09 | US | North Carolina | Martin | 37117 | 6093 | 93 | 0 | 35.84326734 | -77.10860251 | 2022-05-10 04:20:50 | Martin, North Carolina, US | |
2333722 | 2333722 | 2022-05-08 | US | North Carolina | Martin | 37117 | 6093 | 93 | 0 | 35.84326734 | -77.10860251 | 2022-05-09 04:20:54 | Martin, North Carolina, US | |
362684 | 362684 | 2022-05-07 | US | North Carolina | Martin | 37117 | 6093 | 93 | 0 | 35.84326734 | -77.10860251 | 2022-05-08 04:20:49 | Martin, North Carolina, US | |
1400035 | 1400035 | 2022-05-06 | US | North Carolina | Martin | 37117 | 6093 | 93 | 0 | 35.84326734 | -77.10860251 | 2022-05-07 04:21:09 | Martin, North Carolina, US | |
2600390 | 2600390 | 2022-05-05 | US | North Carolina | Martin | 37117 | 6093 | 93 | 0 | 35.84326734 | -77.10860251 | 2022-05-06 04:21:00 | Martin, North Carolina, US | |
3267839 | 3267839 | 2022-05-04 | US | North Carolina | Martin | 37117 | 6093 | 93 | 0 | 35.84326734 | -77.10860251 | 2022-05-05 04:20:55 | Martin, North Carolina, US | |
1160284 | 1160284 | 2022-04-29 | US | Texas | Jasper | 48241 | 6093 | 187 | 0 | 30.74685667 | -94.02667579 | 2022-04-30 04:21:05 | Jasper, Texas, US | |
2116212 | 2116212 | 2022-04-08 | US | Arkansas | Jackson | 5067 | 6093 | 62 | 0 | 35.59802983 | -91.21494602 | 2022-04-09 04:20:42 | Jackson, Arkansas, US | |
3320736 | 3320736 | 2022-04-07 | US | Arkansas | Jackson | 5067 | 6093 | 62 | 0 | 35.59802983 | -91.21494602 | 2022-04-08 04:20:48 | Jackson, Arkansas, US | |
1437053 | 1437053 | 2022-03-28 | US | Arkansas | Carroll | 5015 | 6093 | 99 | 0 | 36.34038560000001 | -93.54270261 | 2022-03-29 04:20:46 | Carroll, Arkansas, US | |
27758 | 27758 | 2022-03-20 | US | Virginia | Hopewell | 51670 | 6093 | 118 | 0 | 37.29186313 | -77.29754684 | 2022-03-21 04:20:50 | Hopewell, Virginia, US | |
1659768 | 1659768 | 2022-03-19 | US | Virginia | Hopewell | 51670 | 6093 | 118 | 0 | 37.29186313 | -77.29754684 | 2022-03-20 04:20:45 | Hopewell, Virginia, US | |
339294 | 339294 | 2022-03-18 | US | Virginia | Hopewell | 51670 | 6093 | 118 | 0 | 37.29186313 | -77.29754684 | 2022-03-19 04:20:47 | Hopewell, Virginia, US | |
2526779 | 2526779 | 2022-03-02 | US | Kentucky | Harrison | 21097 | 6093 | 62 | 0 | 38.44188174 | -84.32869741 | 2022-03-03 04:21:01 | Harrison, Kentucky, US | |
1514766 | 1514766 | 2022-02-24 | US | Virginia | Hopewell | 51670 | 6093 | 114 | 0 | 37.29186313 | -77.29754684 | 2022-02-25 04:21:11 | Hopewell, Virginia, US | |
2833368 | 2833368 | 2022-01-22 | US | Arkansas | Yell | 5149 | 6093 | 93 | 0 | 35.00292371 | -93.41171338 | 2022-01-23 04:21:13 | Yell, Arkansas, US | |
3466315 | 3466315 | 2022-01-18 | US | Nevada | Douglas | 32005 | 6093 | 75 | 0 | 38.912862 | -119.61713329999999 | 2022-01-19 04:21:23 | Douglas, Nevada, US | |
3690188 | 3690188 | 2022-01-13 | US | Pennsylvania | Warren | 42123 | 6093 | 187 | 0 | 41.81304978 | -79.26969577 | 2022-01-14 04:21:54 | Warren, Pennsylvania, US | |
2612401 | 2612401 | 2022-01-06 | US | North Carolina | Pasquotank | 37139 | 6093 | 111 | 0 | 36.26723798 | -76.25134778 | 2022-01-07 04:22:09 | Pasquotank, North Carolina, US | |
1289014 | 1289014 | 2022-01-04 | US | Tennessee | White | 47185 | 6093 | 115 | 0 | 35.92929884 | -85.45591799 | 2022-01-05 04:21:59 | White, Tennessee, US | |
3607575 | 3607575 | 2021-12-25 | US | Ohio | Perry | 39127 | 6093 | 99 | 0 | 39.73508655 | -82.23804971 | 2021-12-26 04:21:50 | Perry, Ohio, US | |
2965893 | 2965893 | 2021-12-24 | US | Ohio | Perry | 39127 | 6093 | 99 | 0 | 39.73508655 | -82.23804971 | 2021-12-25 04:21:37 | Perry, Ohio, US | |
1664974 | 1664974 | 2021-12-11 | US | Arkansas | Union | 5139 | 6093 | 145 | 0 | 33.16887091 | -92.59746952 | 2021-12-12 04:22:12 | Union, Arkansas, US | |
1079378 | 1079378 | 2021-12-09 | US | Kentucky | Muhlenberg | 21177 | 6093 | 97 | 0 | 37.21425819 | -87.14632053 | 2021-12-10 04:22:28 | Muhlenberg, Kentucky, US | |
3123995 | 3123995 | 2021-11-05 | US | Ohio | Madison | 39097 | 6093 | 87 | 0 | 39.89381073 | -83.40178317 | 2021-11-06 04:21:51 | Madison, Ohio, US | |
3009282 | 3009282 | 2021-10-11 | US | Missouri | Phelps | 29161 | 6093 | 178 | 0 | 37.87736118 | -91.79351727 | 2021-10-12 04:21:09 | Phelps, Missouri, US | |
2876346 | 2876346 | 2021-10-09 | Niger | 6093 | 204 | 0 | 17.607789 | 8.081666 | 2021-10-10 04:21:38 | Niger | ||||
2959512 | 2959512 | 2021-10-08 | Niger | 6093 | 204 | 0 | 17.607789 | 8.081666 | 2021-10-09 04:21:34 | Niger | ||||
708878 | 708878 | 2021-09-29 | US | Ohio | Auglaize | 39011 | 6093 | 95 | 0 | 40.55998859 | -84.22421429999999 | 2021-09-30 04:21:20 | Auglaize, Ohio, US | |
3011264 | 3011264 | 2021-09-22 | Guinea-Bissau | 6093 | 133 | 0 | 11.8037 | -15.1804 | 2021-09-23 04:21:43 | Guinea-Bissau | ||||
812261 | 812261 | 2021-09-20 | US | Pennsylvania | Mifflin | 42087 | 6093 | 184 | 0 | 40.61116939 | -77.61070738 | 2021-09-21 04:21:26 | Mifflin, Pennsylvania, US | |
1815862 | 1815862 | 2021-09-19 | US | Indiana | Gibson | 18051 | 6093 | 106 | 0 | 38.30393723 | -87.58054938 | 2021-09-20 04:21:22 | Gibson, Indiana, US | |
3108026 | 3108026 | 2021-08-24 | US | Oklahoma | McClain | 40087 | 6093 | 75 | 0 | 35.01123903 | -97.44572302 | 2021-08-25 04:21:41 | McClain, Oklahoma, US | |
3168197 | 3168197 | 2021-08-23 | US | Oklahoma | McClain | 40087 | 6093 | 75 | 0 | 35.01123903 | -97.44572302 | 2021-08-24 04:21:19 | McClain, Oklahoma, US | |
2178124 | 2178124 | 2021-08-22 | US | Oklahoma | McClain | 40087 | 6093 | 75 | 0 | 35.01123903 | -97.44572302 | 2021-08-23 04:21:27 | McClain, Oklahoma, US | |
3558220 | 3558220 | 2021-08-21 | US | Oklahoma | McClain | 40087 | 6093 | 75 | 0 | 35.01123903 | -97.44572302 | 2021-08-22 04:21:29 | McClain, Oklahoma, US | |
1856562 | 1856562 | 2021-08-20 | US | Oklahoma | McClain | 40087 | 6093 | 75 | 0 | 35.01123903 | -97.44572302 | 2021-08-21 04:21:38 | McClain, Oklahoma, US | |
514269 | 514269 | 2021-08-19 | US | Oklahoma | McClain | 40087 | 6093 | 75 | 0 | 35.01123903 | -97.44572302 | 2021-08-20 04:21:33 | McClain, Oklahoma, US | |
2520748 | 2520748 | 2021-08-18 | US | Oklahoma | McClain | 40087 | 6093 | 75 | 0 | 35.01123903 | -97.44572302 | 2021-08-19 04:21:15 | McClain, Oklahoma, US | |
3387707 | 3387707 | 2021-07-29 | US | North Carolina | Granville | 37077 | 6093 | 83 | 0 | 36.30337451 | -78.65184241 | 2021-07-30 04:21:34 | Granville, North Carolina, US | |
485255 | 485255 | 2021-07-19 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-20 04:21:48 | Montcalm, Michigan, US | |
2675478 | 2675478 | 2021-07-18 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-19 04:21:24 | Montcalm, Michigan, US | |
3707790 | 3707790 | 2021-07-17 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-18 04:22:07 | Montcalm, Michigan, US | |
3707710 | 3707710 | 2021-07-17 | US | Maryland | St. Mary's | 24037 | 6093 | 132 | 0 | 38.30058422 | -76.60629279999998 | 2021-07-18 04:22:07 | St. Mary's, Maryland, US | |
2949021 | 2949021 | 2021-07-16 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-17 04:22:22 | Montcalm, Michigan, US | |
627814 | 627814 | 2021-07-10 | US | Missouri | Newton | 29145 | 6093 | 80 | 0 | 36.90519407 | -94.3394104 | 2021-07-11 04:21:43 | Newton, Missouri, US | |
780026 | 780026 | 2021-07-08 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-09 04:21:21 | Montcalm, Michigan, US | |
1442248 | 1442248 | 2021-07-07 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-08 04:21:26 | Montcalm, Michigan, US | |
2695353 | 2695353 | 2021-07-06 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-07 04:21:20 | Montcalm, Michigan, US | |
1934102 | 1934102 | 2021-07-05 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-06 04:21:32 | Montcalm, Michigan, US | |
1166833 | 1166833 | 2021-07-04 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-05 04:21:28 | Montcalm, Michigan, US | |
1497267 | 1497267 | 2021-07-03 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-04 04:21:38 | Montcalm, Michigan, US | |
2073582 | 2073582 | 2021-07-02 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-03 04:21:37 | Montcalm, Michigan, US | |
2766598 | 2766598 | 2021-07-01 | US | Michigan | Montcalm | 26117 | 6093 | 114 | 0 | 43.31082541 | -85.15252824 | 2021-07-02 04:21:47 | Montcalm, 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]);