johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where confirmed = 5610 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076684 | 1076684 | 2022-12-28 | US | Puerto Rico | Penuelas | 72111 | 5610 | 0 | 0 | 18.059645 | -66.721572 | 2022-12-29 04:21:01 | Penuelas, Puerto Rico, US | |
3175684 | 3175684 | 2022-12-19 | US | Missouri | Clinton | 29049 | 5610 | 127 | 0 | 39.6013098 | -94.40465394 | 2022-12-20 04:21:04 | Clinton, Missouri, US | |
1630201 | 1630201 | 2022-12-18 | US | Missouri | Clinton | 29049 | 5610 | 127 | 0 | 39.6013098 | -94.40465394 | 2022-12-19 04:21:03 | Clinton, Missouri, US | |
505580 | 505580 | 2022-12-17 | US | Missouri | Clinton | 29049 | 5610 | 127 | 0 | 39.6013098 | -94.40465394 | 2022-12-18 04:21:03 | Clinton, Missouri, US | |
3326152 | 3326152 | 2022-12-16 | US | Missouri | Clinton | 29049 | 5610 | 127 | 0 | 39.6013098 | -94.40465394 | 2022-12-17 04:21:04 | Clinton, Missouri, US | |
544664 | 544664 | 2022-12-15 | US | Missouri | Clinton | 29049 | 5610 | 127 | 0 | 39.6013098 | -94.40465394 | 2022-12-16 04:21:01 | Clinton, Missouri, US | |
350192 | 350192 | 2022-12-14 | US | Missouri | Clinton | 29049 | 5610 | 127 | 0 | 39.6013098 | -94.40465394 | 2022-12-15 04:20:58 | Clinton, Missouri, US | |
309780 | 309780 | 2022-12-13 | US | Missouri | Clinton | 29049 | 5610 | 127 | 0 | 39.6013098 | -94.40465394 | 2022-12-14 04:21:04 | Clinton, Missouri, US | |
869284 | 869284 | 2022-12-11 | US | Arkansas | Cross | 5037 | 5610 | 100 | 0 | 35.29631396 | -90.77185818 | 2022-12-12 04:21:01 | Cross, Arkansas, US | |
257814 | 257814 | 2022-12-10 | US | Arkansas | Cross | 5037 | 5610 | 100 | 0 | 35.29631396 | -90.77185818 | 2022-12-11 04:20:50 | Cross, Arkansas, US | |
3936528 | 3936528 | 2022-12-09 | US | Arkansas | Cross | 5037 | 5610 | 100 | 0 | 35.29631396 | -90.77185818 | 2022-12-10 04:21:02 | Cross, Arkansas, US | |
1985530 | 1985530 | 2022-12-07 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-08 04:21:07 | Tattnall, Georgia, US | |
3715053 | 3715053 | 2022-12-06 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-07 04:20:58 | Tattnall, Georgia, US | |
2418465 | 2418465 | 2022-12-05 | US | Wisconsin | Taylor | 55119 | 5610 | 77 | 0 | 45.21179252 | -90.5004405 | 2022-12-06 04:21:03 | Taylor, Wisconsin, US | |
2415758 | 2415758 | 2022-12-05 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-06 04:21:03 | Tattnall, Georgia, US | |
719366 | 719366 | 2022-12-04 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-05 04:20:58 | Tattnall, Georgia, US | |
2817655 | 2817655 | 2022-12-03 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-04 04:20:56 | Tattnall, Georgia, US | |
834511 | 834511 | 2022-12-02 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-03 04:21:02 | Tattnall, Georgia, US | |
2137041 | 2137041 | 2022-12-01 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-02 04:21:07 | Tattnall, Georgia, US | |
1965457 | 1965457 | 2022-11-30 | US | Georgia | Tattnall | 13267 | 5610 | 143 | 0 | 32.04785085 | -82.05539188 | 2022-12-01 04:21:03 | Tattnall, Georgia, US | |
1243181 | 1243181 | 2022-11-28 | US | West Virginia | Taylor | 54091 | 5610 | 82 | 0 | 39.33602617 | -80.0421439 | 2022-11-29 04:21:05 | Taylor, West Virginia, US | |
295235 | 295235 | 2022-11-15 | US | Texas | Scurry | 48415 | 5610 | 107 | 0 | 32.74613808 | -100.9162664 | 2022-11-16 04:21:09 | Scurry, Texas, US | |
3600265 | 3600265 | 2022-11-14 | US | Texas | Scurry | 48415 | 5610 | 107 | 0 | 32.74613808 | -100.9162664 | 2022-11-15 04:21:16 | Scurry, Texas, US | |
711428 | 711428 | 2022-11-01 | US | Illinois | Clay | 17025 | 5610 | 73 | 0 | 38.75388572 | -88.48914513 | 2022-11-02 04:22:09 | Clay, Illinois, US | |
1831292 | 1831292 | 2022-10-25 | US | Indiana | Rush | 18139 | 5610 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-26 04:22:19 | Rush, Indiana, US | |
1831281 | 1831281 | 2022-10-25 | US | Indiana | Orange | 18117 | 5610 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-26 04:22:19 | Orange, Indiana, US | |
795553 | 795553 | 2022-10-24 | US | Indiana | Rush | 18139 | 5610 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-25 04:21:53 | Rush, Indiana, US | |
795542 | 795542 | 2022-10-24 | US | Indiana | Orange | 18117 | 5610 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-25 04:21:53 | Orange, Indiana, US | |
3278008 | 3278008 | 2022-10-23 | US | Indiana | Rush | 18139 | 5610 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-24 04:22:29 | Rush, Indiana, US | |
3277997 | 3277997 | 2022-10-23 | US | Indiana | Orange | 18117 | 5610 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-24 04:22:29 | Orange, Indiana, US | |
2269046 | 2269046 | 2022-10-22 | US | Indiana | Rush | 18139 | 5610 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-23 04:22:46 | Rush, Indiana, US | |
2269035 | 2269035 | 2022-10-22 | US | Indiana | Orange | 18117 | 5610 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-23 04:22:46 | Orange, Indiana, US | |
1593346 | 1593346 | 2022-10-21 | US | Indiana | Rush | 18139 | 5610 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-22 04:22:53 | Rush, Indiana, US | |
1593335 | 1593335 | 2022-10-21 | US | Indiana | Orange | 18117 | 5610 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-22 04:22:53 | Orange, Indiana, US | |
2273062 | 2273062 | 2022-10-20 | US | Indiana | Rush | 18139 | 5610 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-21 04:22:23 | Rush, Indiana, US | |
2273051 | 2273051 | 2022-10-20 | US | Indiana | Orange | 18117 | 5610 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-21 04:22:23 | Orange, Indiana, US | |
199397 | 199397 | 2022-10-19 | US | Indiana | Rush | 18139 | 5610 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-10-20 04:22:59 | Rush, Indiana, US | |
199386 | 199386 | 2022-10-19 | US | Indiana | Orange | 18117 | 5610 | 100 | 0 | 38.5411892 | -86.49523093 | 2022-10-20 04:22:59 | Orange, Indiana, US | |
1371157 | 1371157 | 2022-09-21 | US | Colorado | Teller | 8119 | 5610 | 60 | 0 | 38.88133511 | -105.1614893 | 2022-09-22 04:22:56 | Teller, Colorado, US | |
3572278 | 3572278 | 2022-09-19 | US | Michigan | Osceola | 26133 | 5610 | 86 | 0 | 43.98992088 | -85.32566756 | 2022-09-20 04:22:48 | Osceola, Michigan, US | |
421017 | 421017 | 2022-09-18 | US | Michigan | Osceola | 26133 | 5610 | 86 | 0 | 43.98992088 | -85.32566756 | 2022-09-19 04:21:49 | Osceola, Michigan, US | |
3375041 | 3375041 | 2022-09-17 | US | Michigan | Osceola | 26133 | 5610 | 86 | 0 | 43.98992088 | -85.32566756 | 2022-09-18 04:22:50 | Osceola, Michigan, US | |
2357149 | 2357149 | 2022-09-16 | US | Michigan | Osceola | 26133 | 5610 | 86 | 0 | 43.98992088 | -85.32566756 | 2022-09-17 04:20:19 | Osceola, Michigan, US | |
3988306 | 3988306 | 2022-09-15 | US | Michigan | Osceola | 26133 | 5610 | 86 | 0 | 43.98992088 | -85.32566756 | 2022-09-16 04:21:19 | Osceola, Michigan, US | |
1890823 | 1890823 | 2022-09-14 | US | Michigan | Osceola | 26133 | 5610 | 86 | 0 | 43.98992088 | -85.32566756 | 2022-09-15 04:21:02 | Osceola, Michigan, US | |
373878 | 373878 | 2022-09-13 | US | Michigan | Osceola | 26133 | 5610 | 86 | 0 | 43.98992088 | -85.32566756 | 2022-09-14 04:20:44 | Osceola, Michigan, US | |
961608 | 961608 | 2022-07-19 | US | Pennsylvania | Wyoming | 42131 | 5610 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-20 04:20:59 | Wyoming, Pennsylvania, US | |
3212995 | 3212995 | 2022-07-18 | US | Pennsylvania | Wyoming | 42131 | 5610 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-19 04:20:58 | Wyoming, Pennsylvania, US | |
3408170 | 3408170 | 2022-07-17 | US | Pennsylvania | Wyoming | 42131 | 5610 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-18 04:20:59 | Wyoming, Pennsylvania, US | |
2154370 | 2154370 | 2022-07-16 | US | Pennsylvania | Wyoming | 42131 | 5610 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-17 04:21:15 | Wyoming, Pennsylvania, US | |
2421603 | 2421603 | 2022-07-15 | US | Pennsylvania | Wyoming | 42131 | 5610 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-16 04:21:05 | Wyoming, Pennsylvania, US | |
3431678 | 3431678 | 2022-07-14 | US | Pennsylvania | Wyoming | 42131 | 5610 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-15 04:20:53 | Wyoming, Pennsylvania, US | |
3112198 | 3112198 | 2022-07-13 | US | Pennsylvania | Wyoming | 42131 | 5610 | 113 | 0 | 41.51955538 | -76.01074915 | 2022-07-14 04:20:57 | Wyoming, Pennsylvania, US | |
1424107 | 1424107 | 2022-06-08 | US | Tennessee | Union | 47173 | 5610 | 77 | 0 | 36.28590426 | -83.83651902 | 2022-06-09 04:20:54 | Union, Tennessee, US | |
3596370 | 3596370 | 2022-05-23 | US | Virginia | Fredericksburg | 51630 | 5610 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-05-24 04:20:57 | Fredericksburg, Virginia, US | |
3897527 | 3897527 | 2022-05-19 | US | Maine | Sagadahoc | 23023 | 5610 | 32 | 0 | 43.95415864 | -69.85074999 | 2022-05-20 04:20:57 | Sagadahoc, Maine, US | |
1503870 | 1503870 | 2022-05-16 | Saint Kitts and Nevis | 5610 | 43 | 0 | 17.357822 | -62.782998 | 2022-05-17 04:20:59 | Saint Kitts and Nevis | ||||
3420416 | 3420416 | 2022-04-17 | US | West Virginia | McDowell | 54047 | 5610 | 73 | 0 | 37.38002939 | -81.65083669 | 2022-04-18 04:21:12 | McDowell, West Virginia, US | |
3418391 | 3418391 | 2022-04-17 | US | Kentucky | Simpson | 21213 | 5610 | 90 | 0 | 36.74058474 | -86.58047435 | 2022-04-18 04:21:12 | Simpson, Kentucky, US | |
307365 | 307365 | 2022-04-16 | US | West Virginia | McDowell | 54047 | 5610 | 73 | 0 | 37.38002939 | -81.65083669 | 2022-04-17 04:20:59 | McDowell, West Virginia, US | |
305340 | 305340 | 2022-04-16 | US | Kentucky | Simpson | 21213 | 5610 | 90 | 0 | 36.74058474 | -86.58047435 | 2022-04-17 04:20:59 | Simpson, Kentucky, US | |
2673310 | 2673310 | 2022-04-15 | US | West Virginia | McDowell | 54047 | 5610 | 73 | 0 | 37.38002939 | -81.65083669 | 2022-04-16 04:20:48 | McDowell, West Virginia, US | |
2671285 | 2671285 | 2022-04-15 | US | Kentucky | Simpson | 21213 | 5610 | 90 | 0 | 36.74058474 | -86.58047435 | 2022-04-16 04:20:48 | Simpson, Kentucky, US | |
1225070 | 1225070 | 2022-04-14 | US | Kentucky | Simpson | 21213 | 5610 | 90 | 0 | 36.74058474 | -86.58047435 | 2022-04-15 04:20:57 | Simpson, Kentucky, US | |
2444228 | 2444228 | 2022-04-13 | US | Kentucky | Simpson | 21213 | 5610 | 90 | 0 | 36.74058474 | -86.58047435 | 2022-04-13 23:21:06 | Simpson, Kentucky, US | |
1949985 | 1949985 | 2022-04-12 | US | Kentucky | Simpson | 21213 | 5610 | 90 | 0 | 36.74058474 | -86.58047435 | 2022-04-13 04:21:03 | Simpson, Kentucky, US | |
3207738 | 3207738 | 2022-04-11 | US | Kentucky | Simpson | 21213 | 5610 | 90 | 0 | 36.74058474 | -86.58047435 | 2022-04-12 04:20:49 | Simpson, Kentucky, US | |
1439998 | 1439998 | 2022-03-28 | US | Virginia | Staunton | 51790 | 5610 | 110 | 0 | 38.15965544 | -79.05979937 | 2022-03-29 04:20:46 | Staunton, Virginia, US | |
877736 | 877736 | 2022-03-27 | US | Kentucky | Simpson | 21213 | 5610 | 89 | 0 | 36.74058474 | -86.58047435 | 2022-03-28 04:20:33 | Simpson, Kentucky, US | |
2165019 | 2165019 | 2022-03-26 | US | Kentucky | Simpson | 21213 | 5610 | 89 | 0 | 36.74058474 | -86.58047435 | 2022-03-27 04:20:47 | Simpson, Kentucky, US | |
1721955 | 1721955 | 2022-03-25 | US | Kentucky | Simpson | 21213 | 5610 | 89 | 0 | 36.74058474 | -86.58047435 | 2022-03-26 04:20:23 | Simpson, Kentucky, US | |
1469765 | 1469765 | 2022-03-24 | US | Michigan | Menominee | 26109 | 5610 | 69 | 0 | 45.58038692 | -87.55370409 | 2022-03-25 04:20:46 | Menominee, Michigan, US | |
1469572 | 1469572 | 2022-03-24 | US | Kentucky | Simpson | 21213 | 5610 | 89 | 0 | 36.74058474 | -86.58047435 | 2022-03-25 04:20:46 | Simpson, Kentucky, US | |
3023939 | 3023939 | 2022-03-23 | US | Michigan | Menominee | 26109 | 5610 | 69 | 0 | 45.58038692 | -87.55370409 | 2022-03-24 04:20:43 | Menominee, Michigan, US | |
3023746 | 3023746 | 2022-03-23 | US | Kentucky | Simpson | 21213 | 5610 | 89 | 0 | 36.74058474 | -86.58047435 | 2022-03-24 04:20:43 | Simpson, Kentucky, US | |
1906668 | 1906668 | 2022-03-22 | US | Kentucky | Simpson | 21213 | 5610 | 89 | 0 | 36.74058474 | -86.58047435 | 2022-03-23 04:20:48 | Simpson, Kentucky, US | |
3239799 | 3239799 | 2022-03-21 | US | Kentucky | Simpson | 21213 | 5610 | 89 | 0 | 36.74058474 | -86.58047435 | 2022-03-22 04:20:54 | Simpson, Kentucky, US | |
920935 | 920935 | 2022-03-08 | US | Iowa | Washington | 19183 | 5610 | 76 | 0 | 41.33577126 | -91.71725711 | 2022-03-09 04:20:59 | Washington, Iowa, US | |
1549222 | 1549222 | 2022-03-07 | US | Iowa | Washington | 19183 | 5610 | 76 | 0 | 41.33577126 | -91.71725711 | 2022-03-08 04:20:54 | Washington, Iowa, US | |
2200891 | 2200891 | 2022-03-06 | US | Iowa | Washington | 19183 | 5610 | 76 | 0 | 41.33577126 | -91.71725711 | 2022-03-07 04:20:47 | Washington, Iowa, US | |
2093348 | 2093348 | 2022-03-05 | US | Iowa | Washington | 19183 | 5610 | 76 | 0 | 41.33577126 | -91.71725711 | 2022-03-06 04:20:49 | Washington, Iowa, US | |
2668890 | 2668890 | 2022-03-04 | US | Texas | Frio | 48163 | 5610 | 90 | 0 | 28.86751206 | -99.10804207 | 2022-03-05 04:21:10 | Frio, Texas, US | |
2667048 | 2667048 | 2022-03-04 | US | Iowa | Washington | 19183 | 5610 | 76 | 0 | 41.33577126 | -91.71725711 | 2022-03-05 04:21:10 | Washington, Iowa, US | |
1647455 | 1647455 | 2022-03-03 | US | Texas | Frio | 48163 | 5610 | 90 | 0 | 28.86751206 | -99.10804207 | 2022-03-04 04:21:09 | Frio, Texas, US | |
1645613 | 1645613 | 2022-03-03 | US | Iowa | Washington | 19183 | 5610 | 76 | 0 | 41.33577126 | -91.71725711 | 2022-03-04 04:21:09 | Washington, Iowa, US | |
2526616 | 2526616 | 2022-03-02 | US | Iowa | Washington | 19183 | 5610 | 76 | 0 | 41.33577126 | -91.71725711 | 2022-03-03 04:21:01 | Washington, Iowa, US | |
2736577 | 2736577 | 2022-02-27 | US | Wisconsin | Jackson | 55053 | 5610 | 41 | 0 | 44.31864893 | -90.80566792 | 2022-02-28 04:21:05 | Jackson, Wisconsin, US | |
3049730 | 3049730 | 2022-02-26 | US | Wisconsin | Jackson | 55053 | 5610 | 41 | 0 | 44.31864893 | -90.80566792 | 2022-02-27 04:21:04 | Jackson, Wisconsin, US | |
578385 | 578385 | 2022-02-25 | US | Wisconsin | Jackson | 55053 | 5610 | 41 | 0 | 44.31864893 | -90.80566792 | 2022-02-26 04:21:12 | Jackson, Wisconsin, US | |
3912934 | 3912934 | 2022-02-20 | US | Hawaii | Out of HI | 80015 | 5610 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-21 04:21:05 | Out of HI, Hawaii, US | |
1961559 | 1961559 | 2022-01-20 | US | Illinois | Jersey | 17083 | 5610 | 59 | 0 | 39.08869046 | -90.35393073 | 2022-01-21 04:21:09 | Jersey, Illinois, US | |
1475185 | 1475185 | 2022-01-17 | US | Texas | DeWitt | 48123 | 5610 | 86 | 0 | 29.08101855 | -97.35681170000001 | 2022-01-18 04:21:04 | DeWitt, Texas, US | |
3615839 | 3615839 | 2022-01-12 | US | Puerto Rico | Rio Grande | 72119 | 5610 | 0 | 0 | 18.346329 | -65.813742 | 2022-01-13 08:00:09 | Rio Grande, Puerto Rico, US | |
1692449 | 1692449 | 2022-01-10 | Netherlands | Unknown | 5610 | 33 | 0 | 2022-01-11 04:22:01 | Unknown, Netherlands | |||||
732281 | 732281 | 2021-12-27 | US | Minnesota | Pine | 27115 | 5610 | 48 | 0 | 46.12105238 | -92.74070188 | 2021-12-28 04:21:47 | Pine, Minnesota, US | |
2113340 | 2113340 | 2021-12-26 | US | Michigan | Houghton | 26061 | 5610 | 71 | 0 | 46.89988536 | -88.68495385 | 2021-12-27 04:21:58 | Houghton, Michigan, US | |
3606712 | 3606712 | 2021-12-25 | US | Michigan | Houghton | 26061 | 5610 | 71 | 0 | 46.89988536 | -88.68495385 | 2021-12-26 04:21:50 | Houghton, Michigan, US | |
2965030 | 2965030 | 2021-12-24 | US | Michigan | Houghton | 26061 | 5610 | 71 | 0 | 46.89988536 | -88.68495385 | 2021-12-25 04:21:37 | Houghton, Michigan, US | |
3818062 | 3818062 | 2021-12-23 | US | Michigan | Houghton | 26061 | 5610 | 71 | 0 | 46.89988536 | -88.68495385 | 2021-12-24 04:21:34 | Houghton, Michigan, US | |
800070 | 800070 | 2021-12-22 | US | Michigan | Houghton | 26061 | 5610 | 71 | 0 | 46.89988536 | -88.68495385 | 2021-12-23 04:21:21 | Houghton, 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]);