johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
187 rows where confirmed = 4517 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954335 | 2954335 | 2022-12-20 | US | Tennessee | Grundy | 47061 | 4517 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-12-21 04:21:03 | Grundy, Tennessee, US | |
350502 | 350502 | 2022-12-14 | US | New Mexico | Los Alamos | 35028 | 4517 | 23 | 0 | 35.86631386 | -106.3134985 | 2022-12-15 04:20:58 | Los Alamos, New Mexico, US | |
2487765 | 2487765 | 2022-11-16 | US | Minnesota | Redwood | 27127 | 4517 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-11-17 04:21:11 | Redwood, Minnesota, US | |
293776 | 293776 | 2022-11-15 | US | Minnesota | Redwood | 27127 | 4517 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-11-16 04:21:09 | Redwood, Minnesota, US | |
3598806 | 3598806 | 2022-11-14 | US | Minnesota | Redwood | 27127 | 4517 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-11-15 04:21:16 | Redwood, Minnesota, US | |
313664 | 313664 | 2022-11-13 | US | Minnesota | Redwood | 27127 | 4517 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-11-14 04:21:09 | Redwood, Minnesota, US | |
64825 | 64825 | 2022-11-12 | US | Minnesota | Redwood | 27127 | 4517 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-11-13 04:21:14 | Redwood, Minnesota, US | |
2928987 | 2928987 | 2022-11-11 | US | Minnesota | Redwood | 27127 | 4517 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-11-12 04:20:41 | Redwood, Minnesota, US | |
2507823 | 2507823 | 2022-11-10 | US | Minnesota | Redwood | 27127 | 4517 | 55 | 0 | 44.40555844 | -95.25207021 | 2022-11-11 04:21:22 | Redwood, Minnesota, US | |
480922 | 480922 | 2022-11-08 | US | Kansas | Osage | 20139 | 4517 | 66 | 0 | 38.65235984 | -95.72707998 | 2022-11-09 04:21:22 | Osage, Kansas, US | |
2440072 | 2440072 | 2022-11-07 | US | Kansas | Osage | 20139 | 4517 | 66 | 0 | 38.65235984 | -95.72707998 | 2022-11-08 04:21:21 | Osage, Kansas, US | |
1051170 | 1051170 | 2022-11-06 | US | Kansas | Osage | 20139 | 4517 | 66 | 0 | 38.65235984 | -95.72707998 | 2022-11-07 04:21:26 | Osage, Kansas, US | |
619194 | 619194 | 2022-11-05 | US | Kansas | Osage | 20139 | 4517 | 66 | 0 | 38.65235984 | -95.72707998 | 2022-11-06 04:21:24 | Osage, Kansas, US | |
1023698 | 1023698 | 2022-11-04 | US | Kansas | Osage | 20139 | 4517 | 66 | 0 | 38.65235984 | -95.72707998 | 2022-11-05 04:21:52 | Osage, Kansas, US | |
432689 | 432689 | 2022-11-03 | US | Kansas | Osage | 20139 | 4517 | 66 | 0 | 38.65235984 | -95.72707998 | 2022-11-04 04:22:11 | Osage, Kansas, US | |
850931 | 850931 | 2022-11-02 | US | Kansas | Osage | 20139 | 4517 | 66 | 0 | 38.65235984 | -95.72707998 | 2022-11-03 04:22:05 | Osage, Kansas, US | |
1979923 | 1979923 | 2022-09-25 | US | Virginia | Appomattox | 51011 | 4517 | 58 | 0 | 37.37569884 | -78.81340003 | 2022-09-26 04:20:52 | Appomattox, Virginia, US | |
2653090 | 2653090 | 2022-09-24 | US | Virginia | Appomattox | 51011 | 4517 | 58 | 0 | 37.37569884 | -78.81340003 | 2022-09-25 04:23:31 | Appomattox, Virginia, US | |
2652211 | 2652211 | 2022-09-24 | US | North Dakota | Richland | 38077 | 4517 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-09-25 04:23:31 | Richland, North Dakota, US | |
387530 | 387530 | 2022-09-23 | US | Virginia | Appomattox | 51011 | 4517 | 58 | 0 | 37.37569884 | -78.81340003 | 2022-09-24 04:21:40 | Appomattox, Virginia, US | |
3987134 | 3987134 | 2022-09-15 | US | Arkansas | Madison | 5087 | 4517 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-09-16 04:21:19 | Madison, Arkansas, US | |
3768880 | 3768880 | 2022-09-11 | US | Tennessee | Trousdale | 47169 | 4517 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-09-12 04:20:58 | Trousdale, Tennessee, US | |
3827455 | 3827455 | 2022-09-10 | US | Tennessee | Trousdale | 47169 | 4517 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-09-11 04:20:50 | Trousdale, Tennessee, US | |
1880392 | 1880392 | 2022-08-28 | US | Virginia | Rockbridge | 51163 | 4517 | 89 | 0 | 37.81204314 | -79.44605905 | 2022-08-29 04:21:06 | Rockbridge, Virginia, US | |
1878385 | 1878385 | 2022-08-28 | US | Kentucky | Estill | 21065 | 4517 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-29 04:21:06 | Estill, Kentucky, US | |
2099519 | 2099519 | 2022-08-27 | US | Virginia | Rockbridge | 51163 | 4517 | 89 | 0 | 37.81204314 | -79.44605905 | 2022-08-28 04:21:02 | Rockbridge, Virginia, US | |
2097512 | 2097512 | 2022-08-27 | US | Kentucky | Estill | 21065 | 4517 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-28 04:21:02 | Estill, Kentucky, US | |
1535334 | 1535334 | 2022-08-26 | US | Virginia | Rockbridge | 51163 | 4517 | 89 | 0 | 37.81204314 | -79.44605905 | 2022-08-27 04:20:57 | Rockbridge, Virginia, US | |
1533327 | 1533327 | 2022-08-26 | US | Kentucky | Estill | 21065 | 4517 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-27 04:20:57 | Estill, Kentucky, US | |
2830214 | 2830214 | 2022-08-25 | US | Kentucky | Estill | 21065 | 4517 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-26 04:21:02 | Estill, Kentucky, US | |
2324747 | 2324747 | 2022-08-24 | US | Kentucky | Estill | 21065 | 4517 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-25 04:21:13 | Estill, Kentucky, US | |
1252156 | 1252156 | 2022-08-23 | US | Kentucky | Estill | 21065 | 4517 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-24 04:20:46 | Estill, Kentucky, US | |
1251708 | 1251708 | 2022-08-23 | US | Idaho | Minidoka | 16067 | 4517 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-08-24 04:20:46 | Minidoka, Idaho, US | |
2854260 | 2854260 | 2022-08-22 | US | Kentucky | Estill | 21065 | 4517 | 52 | 0 | 37.69241417 | -83.95956369 | 2022-08-23 04:20:56 | Estill, Kentucky, US | |
2853812 | 2853812 | 2022-08-22 | US | Idaho | Minidoka | 16067 | 4517 | 65 | 0 | 42.85518524 | -113.6357257 | 2022-08-23 04:20:56 | Minidoka, Idaho, US | |
992144 | 992144 | 2022-08-16 | US | Indiana | Vermillion | 18165 | 4517 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-08-17 04:20:59 | Vermillion, Indiana, US | |
2495183 | 2495183 | 2022-08-15 | US | Indiana | Vermillion | 18165 | 4517 | 80 | 0 | 39.8523352 | -87.46160542 | 2022-08-16 04:20:58 | Vermillion, Indiana, US | |
1349854 | 1349854 | 2022-08-10 | US | Wisconsin | Burnett | 55013 | 4517 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-08-11 04:20:49 | Burnett, Wisconsin, US | |
1089425 | 1089425 | 2022-08-09 | US | Virginia | Greene | 51079 | 4517 | 64 | 0 | 38.29545894 | -78.46525378 | 2022-08-10 04:20:57 | Greene, Virginia, US | |
2011816 | 2011816 | 2022-08-04 | US | Texas | Houston | 48225 | 4517 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-08-05 04:20:52 | Houston, Texas, US | |
3432118 | 3432118 | 2022-07-14 | US | Texas | Lamb | 48279 | 4517 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-07-15 04:20:53 | Lamb, Texas, US | |
3079122 | 3079122 | 2022-07-04 | US | Illinois | White | 17193 | 4517 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-05 04:20:45 | White, Illinois, US | |
1768404 | 1768404 | 2022-07-03 | US | Illinois | White | 17193 | 4517 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-04 04:20:54 | White, Illinois, US | |
3366390 | 3366390 | 2022-07-02 | US | Illinois | White | 17193 | 4517 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-03 04:20:59 | White, Illinois, US | |
594719 | 594719 | 2022-07-01 | US | Illinois | White | 17193 | 4517 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-02 04:21:16 | White, Illinois, US | |
2149452 | 2149452 | 2022-06-27 | US | Mississippi | Holmes | 28051 | 4517 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-06-28 04:20:58 | Holmes, Mississippi, US | |
477253 | 477253 | 2022-06-26 | US | Mississippi | Holmes | 28051 | 4517 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-06-27 04:21:00 | Holmes, Mississippi, US | |
940628 | 940628 | 2022-06-25 | US | Mississippi | Holmes | 28051 | 4517 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-06-26 04:21:02 | Holmes, Mississippi, US | |
3348448 | 3348448 | 2022-06-24 | US | Mississippi | Holmes | 28051 | 4517 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-06-25 04:20:57 | Holmes, Mississippi, US | |
1650189 | 1650189 | 2022-06-23 | US | Mississippi | Holmes | 28051 | 4517 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-06-24 04:20:58 | Holmes, Mississippi, US | |
1649890 | 1649890 | 2022-06-23 | US | Louisiana | Jackson | 22049 | 4517 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-06-24 04:20:58 | Jackson, Louisiana, US | |
2189424 | 2189424 | 2022-06-22 | US | Mississippi | Holmes | 28051 | 4517 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-06-23 04:20:55 | Holmes, Mississippi, US | |
167855 | 167855 | 2022-06-21 | US | Mississippi | Holmes | 28051 | 4517 | 104 | 0 | 33.12345854 | -90.08923538 | 2022-06-22 04:20:54 | Holmes, Mississippi, US | |
950071 | 950071 | 2022-06-14 | US | Texas | Shelby | 48419 | 4517 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-06-15 04:20:54 | Shelby, Texas, US | |
2982479 | 2982479 | 2022-06-13 | US | Texas | Shelby | 48419 | 4517 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-06-14 04:20:52 | Shelby, Texas, US | |
2235873 | 2235873 | 2022-06-12 | US | Arkansas | Grant | 5053 | 4517 | 62 | 0 | 34.29017991 | -92.42320562 | 2022-06-13 04:21:14 | Grant, Arkansas, US | |
2084503 | 2084503 | 2022-05-15 | US | California | Colusa | 6011 | 4517 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-16 04:20:47 | Colusa, California, US | |
3355213 | 3355213 | 2022-05-14 | US | California | Colusa | 6011 | 4517 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-15 04:20:53 | Colusa, California, US | |
658858 | 658858 | 2022-05-13 | US | California | Colusa | 6011 | 4517 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-05-14 04:20:48 | Colusa, California, US | |
224768 | 224768 | 2022-05-09 | US | Puerto Rico | Quebradillas | 72115 | 4517 | 0 | 0 | 18.439692 | -66.926113 | 2022-05-10 04:20:50 | Quebradillas, Puerto Rico, US | |
2030202 | 2030202 | 2022-04-24 | US | Kentucky | Lewis | 21135 | 4517 | 84 | 0 | 38.53184419 | -83.37735618 | 2022-04-25 04:20:56 | Lewis, Kentucky, US | |
747777 | 747777 | 2022-04-23 | US | Kentucky | Lewis | 21135 | 4517 | 84 | 0 | 38.53184419 | -83.37735618 | 2022-04-24 04:20:56 | Lewis, Kentucky, US | |
3438262 | 3438262 | 2022-04-22 | US | Kentucky | Lewis | 21135 | 4517 | 84 | 0 | 38.53184419 | -83.37735618 | 2022-04-23 04:20:50 | Lewis, Kentucky, US | |
2893847 | 2893847 | 2022-04-21 | US | Kentucky | Lewis | 21135 | 4517 | 84 | 0 | 38.53184419 | -83.37735618 | 2022-04-22 04:20:45 | Lewis, Kentucky, US | |
2308719 | 2308719 | 2022-04-20 | US | Kentucky | Lewis | 21135 | 4517 | 84 | 0 | 38.53184419 | -83.37735618 | 2022-04-21 04:20:46 | Lewis, Kentucky, US | |
2252858 | 2252858 | 2022-04-19 | US | Kentucky | Lewis | 21135 | 4517 | 84 | 0 | 38.53184419 | -83.37735618 | 2022-04-20 04:20:45 | Lewis, Kentucky, US | |
1847408 | 1847408 | 2022-04-18 | US | Kentucky | Lewis | 21135 | 4517 | 84 | 0 | 38.53184419 | -83.37735618 | 2022-04-19 04:21:00 | Lewis, Kentucky, US | |
3420435 | 3420435 | 2022-04-17 | US | West Virginia | Taylor | 54091 | 4517 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-04-18 04:21:12 | Taylor, West Virginia, US | |
307384 | 307384 | 2022-04-16 | US | West Virginia | Taylor | 54091 | 4517 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-04-17 04:20:59 | Taylor, West Virginia, US | |
2673329 | 2673329 | 2022-04-15 | US | West Virginia | Taylor | 54091 | 4517 | 73 | 0 | 39.33602617 | -80.0421439 | 2022-04-16 04:20:48 | Taylor, West Virginia, US | |
161444 | 161444 | 2022-03-29 | US | Washington | Asotin | 53003 | 4517 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-30 04:20:45 | Asotin, Washington, US | |
1440015 | 1440015 | 2022-03-28 | US | Washington | Asotin | 53003 | 4517 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-29 04:20:46 | Asotin, Washington, US | |
879696 | 879696 | 2022-03-27 | US | Washington | Asotin | 53003 | 4517 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-28 04:20:33 | Asotin, Washington, US | |
2166979 | 2166979 | 2022-03-26 | US | Washington | Asotin | 53003 | 4517 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-27 04:20:47 | Asotin, Washington, US | |
1723915 | 1723915 | 2022-03-25 | US | Washington | Asotin | 53003 | 4517 | 65 | 0 | 46.18894415 | -117.2022851 | 2022-03-26 04:20:23 | Asotin, Washington, US | |
2322915 | 2322915 | 2022-03-16 | US | Wisconsin | Sawyer | 55113 | 4517 | 59 | 0 | 45.87931905 | -91.14504927 | 2022-03-17 04:20:56 | Sawyer, Wisconsin, US | |
1868687 | 1868687 | 2022-03-10 | US | Texas | Robertson | 48395 | 4517 | 75 | 0 | 31.02539637 | -96.51272246 | 2022-03-11 04:20:50 | Robertson, Texas, US | |
3045965 | 3045965 | 2022-02-26 | China | Guangdong | 4517 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-27 04:21:04 | Guangdong, China | |||
3915399 | 3915399 | 2022-02-20 | US | Virginia | New Kent | 51127 | 4517 | 30 | 0 | 37.50694406 | -76.99828634 | 2022-02-21 04:21:05 | New Kent, Virginia, US | |
3878957 | 3878957 | 2022-02-19 | US | Virginia | New Kent | 51127 | 4517 | 30 | 0 | 37.50694406 | -76.99828634 | 2022-02-20 04:21:00 | New Kent, Virginia, US | |
3859213 | 3859213 | 2022-02-18 | US | Virginia | New Kent | 51127 | 4517 | 30 | 0 | 37.50694406 | -76.99828634 | 2022-02-19 04:21:11 | New Kent, Virginia, US | |
316400 | 316400 | 2022-02-12 | US | Arkansas | Drew | 5043 | 4517 | 58 | 0 | 33.59035001 | -91.71777921 | 2022-02-13 04:21:00 | Drew, Arkansas, US | |
2475421 | 2475421 | 2022-02-03 | US | Kentucky | Rockcastle | 21203 | 4517 | 51 | 0 | 37.36642393 | -84.31176452 | 2022-02-04 04:21:10 | Rockcastle, Kentucky, US | |
2475371 | 2475371 | 2022-02-03 | US | Kentucky | Henry | 21103 | 4517 | 44 | 0 | 38.44942688 | -85.11587507 | 2022-02-04 04:21:10 | Henry, Kentucky, US | |
982034 | 982034 | 2022-02-01 | US | Texas | Fayette | 48149 | 4517 | 98 | 0 | 29.87788372 | -96.92076062 | 2022-02-02 04:21:09 | Fayette, Texas, US | |
1319354 | 1319354 | 2022-01-26 | US | Indiana | Starke | 18149 | 4517 | 87 | 0 | 41.27890281 | -86.64686895 | 2022-01-27 04:21:19 | Starke, Indiana, US | |
1229086 | 1229086 | 2022-01-24 | US | Kentucky | Spencer | 21215 | 4517 | 44 | 0 | 38.03223971 | -85.32749335 | 2022-01-25 04:21:05 | Spencer, Kentucky, US | |
3425349 | 3425349 | 2022-01-21 | US | Alabama | Randolph | 1111 | 4517 | 69 | 0 | 33.29526734 | -85.45708831 | 2022-01-22 04:21:13 | Randolph, Alabama, US | |
1961694 | 1961694 | 2022-01-20 | US | Indiana | Spencer | 18147 | 4517 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-01-21 04:21:09 | Spencer, Indiana, US | |
1116728 | 1116728 | 2022-01-11 | US | Texas | Karnes | 48255 | 4517 | 58 | 0 | 28.90705334 | -97.85960149 | 2022-01-12 04:21:44 | Karnes, Texas, US | |
1288201 | 1288201 | 2022-01-04 | US | New Mexico | Grant | 35017 | 4517 | 64 | 0 | 32.73911281 | -108.3827845 | 2022-01-05 04:21:59 | Grant, New Mexico, US | |
3999499 | 3999499 | 2021-12-30 | US | Georgia | Monroe | 13207 | 4517 | 154 | 0 | 33.014289 | -83.92097166 | 2021-12-31 04:21:50 | Monroe, Georgia, US | |
1668589 | 1668589 | 2021-12-29 | Netherlands | Unknown | 4517 | 32 | 0 | 2021-12-30 04:21:25 | Unknown, Netherlands | |||||
2113248 | 2113248 | 2021-12-26 | US | Louisiana | West Baton Rouge | 22121 | 4517 | 79 | 0 | 30.46058217 | -91.30989571 | 2021-12-27 04:21:58 | West Baton Rouge, Louisiana, US | |
3606620 | 3606620 | 2021-12-25 | US | Louisiana | West Baton Rouge | 22121 | 4517 | 79 | 0 | 30.46058217 | -91.30989571 | 2021-12-26 04:21:50 | West Baton Rouge, Louisiana, US | |
2964938 | 2964938 | 2021-12-24 | US | Louisiana | West Baton Rouge | 22121 | 4517 | 79 | 0 | 30.46058217 | -91.30989571 | 2021-12-25 04:21:37 | West Baton Rouge, Louisiana, US | |
3819553 | 3819553 | 2021-12-23 | US | Texas | Jasper | 48241 | 4517 | 165 | 0 | 30.74685667 | -94.02667579 | 2021-12-24 04:21:34 | Jasper, Texas, US | |
3817970 | 3817970 | 2021-12-23 | US | Louisiana | West Baton Rouge | 22121 | 4517 | 79 | 0 | 30.46058217 | -91.30989571 | 2021-12-24 04:21:34 | West Baton Rouge, Louisiana, US | |
2907031 | 2907031 | 2021-12-19 | US | Virginia | Caroline | 51033 | 4517 | 56 | 0 | 38.02679129 | -77.34901405 | 2021-12-20 04:21:43 | Caroline, Virginia, US | |
1262104 | 1262104 | 2021-12-18 | US | Virginia | Caroline | 51033 | 4517 | 56 | 0 | 38.02679129 | -77.34901405 | 2021-12-19 04:21:11 | Caroline, Virginia, 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]);