johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
178 rows where confirmed = 4351 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954949 | 2954949 | 2022-12-20 | US | Wisconsin | Lafayette | 55065 | 4351 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-21 04:21:03 | Lafayette, Wisconsin, US | |
481144 | 481144 | 2022-11-08 | US | Louisiana | West Carroll | 22123 | 4351 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-09 04:21:22 | West Carroll, Louisiana, US | |
2440294 | 2440294 | 2022-11-07 | US | Louisiana | West Carroll | 22123 | 4351 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-08 04:21:21 | West Carroll, Louisiana, US | |
1051392 | 1051392 | 2022-11-06 | US | Louisiana | West Carroll | 22123 | 4351 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-07 04:21:26 | West Carroll, Louisiana, US | |
619416 | 619416 | 2022-11-05 | US | Louisiana | West Carroll | 22123 | 4351 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-06 04:21:24 | West Carroll, Louisiana, US | |
1023920 | 1023920 | 2022-11-04 | US | Louisiana | West Carroll | 22123 | 4351 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-05 04:21:52 | West Carroll, Louisiana, US | |
432911 | 432911 | 2022-11-03 | US | Louisiana | West Carroll | 22123 | 4351 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-04 04:22:11 | West Carroll, Louisiana, US | |
851153 | 851153 | 2022-11-02 | US | Louisiana | West Carroll | 22123 | 4351 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-03 04:22:05 | West Carroll, Louisiana, US | |
3251388 | 3251388 | 2022-10-11 | US | Iowa | Poweshiek | 19157 | 4351 | 63 | 0 | 41.68625425 | -92.53155731 | 2022-10-12 04:22:51 | Poweshiek, Iowa, US | |
2968647 | 2968647 | 2022-10-10 | US | Iowa | Poweshiek | 19157 | 4351 | 63 | 0 | 41.68625425 | -92.53155731 | 2022-10-11 04:23:05 | Poweshiek, Iowa, US | |
3098683 | 3098683 | 2022-10-09 | US | Iowa | Poweshiek | 19157 | 4351 | 63 | 0 | 41.68625425 | -92.53155731 | 2022-10-10 04:22:32 | Poweshiek, Iowa, US | |
4003908 | 4003908 | 2022-10-08 | US | Iowa | Poweshiek | 19157 | 4351 | 63 | 0 | 41.68625425 | -92.53155731 | 2022-10-09 04:21:16 | Poweshiek, Iowa, US | |
397505 | 397505 | 2022-10-07 | US | Iowa | Poweshiek | 19157 | 4351 | 63 | 0 | 41.68625425 | -92.53155731 | 2022-10-08 04:22:56 | Poweshiek, Iowa, US | |
2530622 | 2530622 | 2022-10-06 | US | Iowa | Poweshiek | 19157 | 4351 | 63 | 0 | 41.68625425 | -92.53155731 | 2022-10-07 04:23:08 | Poweshiek, Iowa, US | |
1812016 | 1812016 | 2022-10-05 | US | Iowa | Poweshiek | 19157 | 4351 | 63 | 0 | 41.68625425 | -92.53155731 | 2022-10-06 04:21:22 | Poweshiek, Iowa, US | |
2377529 | 2377529 | 2022-09-29 | US | Missouri | Wright | 29229 | 4351 | 92 | 0 | 37.27029221 | -92.46914488 | 2022-09-30 04:23:09 | Wright, Missouri, US | |
1562080 | 1562080 | 2022-09-28 | US | Missouri | Wright | 29229 | 4351 | 92 | 0 | 37.27029221 | -92.46914488 | 2022-09-29 04:22:34 | Wright, Missouri, US | |
1559878 | 1559878 | 2022-09-28 | China | Fujian | 4351 | 1 | 0 | 26.0789 | 117.9874 | 2022-09-29 04:22:34 | Fujian, China | |||
3996623 | 3996623 | 2022-09-27 | US | Missouri | Wright | 29229 | 4351 | 92 | 0 | 37.27029221 | -92.46914488 | 2022-09-28 04:23:01 | Wright, Missouri, US | |
2771808 | 2771808 | 2022-09-26 | US | South Carolina | Saluda | 45081 | 4351 | 79 | 0 | 34.00795823 | -81.72713237 | 2022-09-27 04:23:01 | Saluda, South Carolina, US | |
2770951 | 2770951 | 2022-09-26 | US | Missouri | Wright | 29229 | 4351 | 92 | 0 | 37.27029221 | -92.46914488 | 2022-09-27 04:23:01 | Wright, Missouri, US | |
1979461 | 1979461 | 2022-09-25 | US | South Carolina | Saluda | 45081 | 4351 | 79 | 0 | 34.00795823 | -81.72713237 | 2022-09-26 04:20:52 | Saluda, South Carolina, US | |
1978604 | 1978604 | 2022-09-25 | US | Missouri | Wright | 29229 | 4351 | 92 | 0 | 37.27029221 | -92.46914488 | 2022-09-26 04:20:52 | Wright, Missouri, US | |
2652628 | 2652628 | 2022-09-24 | US | South Carolina | Saluda | 45081 | 4351 | 79 | 0 | 34.00795823 | -81.72713237 | 2022-09-25 04:23:31 | Saluda, South Carolina, US | |
2651771 | 2651771 | 2022-09-24 | US | Missouri | Wright | 29229 | 4351 | 92 | 0 | 37.27029221 | -92.46914488 | 2022-09-25 04:23:31 | Wright, Missouri, US | |
387068 | 387068 | 2022-09-23 | US | South Carolina | Saluda | 45081 | 4351 | 79 | 0 | 34.00795823 | -81.72713237 | 2022-09-24 04:21:40 | Saluda, South Carolina, US | |
386211 | 386211 | 2022-09-23 | US | Missouri | Wright | 29229 | 4351 | 92 | 0 | 37.27029221 | -92.46914488 | 2022-09-24 04:21:40 | Wright, Missouri, US | |
1627134 | 1627134 | 2022-09-22 | US | South Carolina | Saluda | 45081 | 4351 | 79 | 0 | 34.00795823 | -81.72713237 | 2022-09-23 04:23:13 | Saluda, South Carolina, US | |
1373338 | 1373338 | 2022-09-21 | US | South Carolina | Saluda | 45081 | 4351 | 79 | 0 | 34.00795823 | -81.72713237 | 2022-09-22 04:22:56 | Saluda, South Carolina, US | |
2019568 | 2019568 | 2022-09-20 | US | South Carolina | Saluda | 45081 | 4351 | 79 | 0 | 34.00795823 | -81.72713237 | 2022-09-21 04:23:22 | Saluda, South Carolina, US | |
1164624 | 1164624 | 2022-08-18 | US | Washington | Pacific | 53049 | 4351 | 65 | 0 | 46.55418369 | -123.7285716 | 2022-08-19 04:20:54 | Pacific, Washington, US | |
3953948 | 3953948 | 2022-08-17 | US | Washington | Pacific | 53049 | 4351 | 65 | 0 | 46.55418369 | -123.7285716 | 2022-08-18 04:21:11 | Pacific, Washington, US | |
1347342 | 1347342 | 2022-08-10 | US | Illinois | Mason | 17125 | 4351 | 63 | 0 | 40.23917274 | -89.91824452 | 2022-08-11 04:20:49 | Mason, Illinois, US | |
1086595 | 1086595 | 2022-08-09 | US | Arkansas | Polk | 5113 | 4351 | 151 | 0 | 34.48254879 | -94.22728802 | 2022-08-10 04:20:57 | Polk, Arkansas, US | |
1072318 | 1072318 | 2022-08-07 | US | North Dakota | Richland | 38077 | 4351 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-08-08 04:21:08 | Richland, North Dakota, US | |
1942906 | 1942906 | 2022-08-06 | US | North Dakota | Richland | 38077 | 4351 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-08-07 04:20:54 | Richland, North Dakota, US | |
2597194 | 2597194 | 2022-07-25 | US | Texas | Llano | 48299 | 4351 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-07-26 04:20:58 | Llano, Texas, US | |
1766096 | 1766096 | 2022-06-20 | US | Puerto Rico | Orocovis | 72107 | 4351 | 0 | 0 | 18.215046 | -66.433604 | 2022-06-21 04:20:56 | Orocovis, Puerto Rico, US | |
3270934 | 3270934 | 2022-06-19 | US | Kentucky | Jackson | 21109 | 4351 | 82 | 0 | 37.41866422 | -83.99825483 | 2022-06-20 04:21:01 | Jackson, Kentucky, US | |
3398846 | 3398846 | 2022-06-18 | US | Kentucky | Jackson | 21109 | 4351 | 82 | 0 | 37.41866422 | -83.99825483 | 2022-06-19 04:20:51 | Jackson, Kentucky, US | |
2312723 | 2312723 | 2022-06-17 | US | Kentucky | Jackson | 21109 | 4351 | 82 | 0 | 37.41866422 | -83.99825483 | 2022-06-18 04:21:10 | Jackson, Kentucky, US | |
560227 | 560227 | 2022-06-16 | US | Kentucky | Jackson | 21109 | 4351 | 82 | 0 | 37.41866422 | -83.99825483 | 2022-06-17 04:20:56 | Jackson, Kentucky, US | |
3984029 | 3984029 | 2022-06-15 | US | Kentucky | Jackson | 21109 | 4351 | 82 | 0 | 37.41866422 | -83.99825483 | 2022-06-16 04:20:55 | Jackson, Kentucky, US | |
948270 | 948270 | 2022-06-14 | US | Kentucky | Jackson | 21109 | 4351 | 82 | 0 | 37.41866422 | -83.99825483 | 2022-06-15 04:20:54 | Jackson, Kentucky, US | |
2980678 | 2980678 | 2022-06-13 | US | Kentucky | Jackson | 21109 | 4351 | 82 | 0 | 37.41866422 | -83.99825483 | 2022-06-14 04:20:52 | Jackson, Kentucky, US | |
1853530 | 1853530 | 2022-05-26 | US | Wisconsin | Crawford | 55023 | 4351 | 28 | 0 | 43.23870316 | -90.93073686 | 2022-05-27 04:20:56 | Crawford, Wisconsin, US | |
3584993 | 3584993 | 2022-05-17 | US | North Carolina | Northampton | 37131 | 4351 | 84 | 0 | 36.41736238 | -77.39769443 | 2022-05-18 04:20:50 | Northampton, North Carolina, US | |
1505950 | 1505950 | 2022-05-16 | US | North Carolina | Northampton | 37131 | 4351 | 84 | 0 | 36.41736238 | -77.39769443 | 2022-05-17 04:20:59 | Northampton, North Carolina, US | |
2086309 | 2086309 | 2022-05-15 | US | North Carolina | Northampton | 37131 | 4351 | 84 | 0 | 36.41736238 | -77.39769443 | 2022-05-16 04:20:47 | Northampton, North Carolina, US | |
3357019 | 3357019 | 2022-05-14 | US | North Carolina | Northampton | 37131 | 4351 | 84 | 0 | 36.41736238 | -77.39769443 | 2022-05-15 04:20:53 | Northampton, North Carolina, US | |
660664 | 660664 | 2022-05-13 | US | North Carolina | Northampton | 37131 | 4351 | 84 | 0 | 36.41736238 | -77.39769443 | 2022-05-14 04:20:48 | Northampton, North Carolina, US | |
2535747 | 2535747 | 2022-05-12 | US | North Carolina | Northampton | 37131 | 4351 | 84 | 0 | 36.41736238 | -77.39769443 | 2022-05-13 04:20:51 | Northampton, North Carolina, US | |
3447193 | 3447193 | 2022-05-11 | US | North Carolina | Northampton | 37131 | 4351 | 84 | 0 | 36.41736238 | -77.39769443 | 2022-05-12 04:20:54 | Northampton, North Carolina, US | |
464360 | 464360 | 2022-05-02 | US | Illinois | Bond | 17005 | 4351 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-05-03 04:21:00 | Bond, Illinois, US | |
3916999 | 3916999 | 2022-05-01 | US | Illinois | Bond | 17005 | 4351 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-05-02 04:21:10 | Bond, Illinois, US | |
2841803 | 2841803 | 2022-04-30 | US | Illinois | Bond | 17005 | 4351 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-05-01 04:20:57 | Bond, Illinois, US | |
1158116 | 1158116 | 2022-04-29 | US | Illinois | Bond | 17005 | 4351 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-04-30 04:21:05 | Bond, Illinois, US | |
1699857 | 1699857 | 2022-04-28 | US | West Virginia | Wetzel | 54103 | 4351 | 86 | 0 | 39.6065771 | -80.6401654 | 2022-04-29 04:20:59 | Wetzel, West Virginia, US | |
3854969 | 3854969 | 2022-04-27 | US | Texas | Lamb | 48279 | 4351 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-04-28 04:20:47 | Lamb, Texas, US | |
1329399 | 1329399 | 2022-04-26 | US | Texas | Lamb | 48279 | 4351 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-04-27 04:20:52 | Lamb, Texas, US | |
3725353 | 3725353 | 2022-04-25 | US | Texas | Lamb | 48279 | 4351 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-04-26 04:20:51 | Lamb, Texas, US | |
2031921 | 2031921 | 2022-04-24 | US | Texas | Lamb | 48279 | 4351 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-04-25 04:20:56 | Lamb, Texas, US | |
749496 | 749496 | 2022-04-23 | US | Texas | Lamb | 48279 | 4351 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-04-24 04:20:56 | Lamb, Texas, US | |
3439981 | 3439981 | 2022-04-22 | US | Texas | Lamb | 48279 | 4351 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-04-23 04:20:50 | Lamb, Texas, US | |
2118459 | 2118459 | 2022-04-08 | US | Puerto Rico | Guayama | 72057 | 4351 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-04-09 04:20:42 | Guayama, Puerto Rico, US | |
1866122 | 1866122 | 2022-03-10 | US | Colorado | Otero | 8089 | 4351 | 129 | 0 | 37.9014485 | -103.7173385 | 2022-03-11 04:20:50 | Otero, Colorado, US | |
2528092 | 2528092 | 2022-03-02 | US | Puerto Rico | Camuy | 72027 | 4351 | 0 | 0 | 18.418578 | -66.860206 | 2022-03-03 04:21:01 | Camuy, Puerto Rico, US | |
575321 | 575321 | 2022-02-25 | US | Arkansas | Grant | 5053 | 4351 | 57 | 0 | 34.29017991 | -92.42320562 | 2022-02-26 04:21:12 | Grant, Arkansas, US | |
1511897 | 1511897 | 2022-02-24 | US | Arkansas | Grant | 5053 | 4351 | 57 | 0 | 34.29017991 | -92.42320562 | 2022-02-25 04:21:11 | Grant, Arkansas, US | |
2448536 | 2448536 | 2022-02-22 | US | Minnesota | Roseau | 27135 | 4351 | 43 | 0 | 48.77501878 | -95.81079919 | 2022-02-23 04:21:09 | Roseau, Minnesota, US | |
1466776 | 1466776 | 2022-02-10 | US | Pennsylvania | Montour | 42093 | 4351 | 87 | 0 | 41.03023987 | -76.66345939 | 2022-02-11 04:21:09 | Montour, Pennsylvania, US | |
979548 | 979548 | 2022-02-01 | US | Colorado | Alamosa | 8003 | 4351 | 59 | 0 | 37.57250606 | -105.7885451 | 2022-02-02 04:21:09 | Alamosa, Colorado, US | |
1319187 | 1319187 | 2022-01-26 | US | Illinois | Clark | 17023 | 4351 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-01-27 04:21:19 | Clark, Illinois, US | |
1475152 | 1475152 | 2022-01-17 | US | Texas | Burleson | 48051 | 4351 | 61 | 0 | 30.49273808 | -96.62158484 | 2022-01-18 04:21:04 | Burleson, Texas, US | |
1694185 | 1694185 | 2022-01-10 | US | Missouri | Adair | 29001 | 4351 | 53 | 0 | 40.19058551 | -92.60078167 | 2022-01-11 04:22:01 | Adair, Missouri, US | |
1701303 | 1701303 | 2022-01-03 | US | Idaho | Payette | 16075 | 4351 | 75 | 0 | 44.00545243 | -116.7647695 | 2022-01-04 04:22:17 | Payette, Idaho, US | |
1435705 | 1435705 | 2021-12-28 | US | Texas | Karnes | 48255 | 4351 | 58 | 0 | 28.90705334 | -97.85960149 | 2021-12-29 03:21:43 | Karnes, Texas, US | |
733440 | 733440 | 2021-12-27 | US | South Dakota | Yankton | 46135 | 4351 | 44 | 0 | 43.00924485 | -97.39467635 | 2021-12-28 04:21:47 | Yankton, South Dakota, US | |
3828895 | 3828895 | 2021-12-21 | US | Alaska | Juneau | 2110 | 4351 | 15 | 0 | 58.45031811 | -134.200436 | 2021-12-22 04:21:54 | Juneau, Alaska, US | |
1258329 | 1258329 | 2021-12-20 | US | Wisconsin | Kewaunee | 55061 | 4351 | 49 | 0 | 44.51727459 | -87.61468386 | 2021-12-21 03:21:27 | Kewaunee, Wisconsin, US | |
1255198 | 1255198 | 2021-12-20 | US | Alaska | Juneau | 2110 | 4351 | 15 | 0 | 58.45031811 | -134.200436 | 2021-12-21 03:21:27 | Juneau, Alaska, US | |
1717967 | 1717967 | 2021-12-16 | US | Michigan | Alpena | 26007 | 4351 | 99 | 0 | 45.03477666 | -83.62212411 | 2021-12-17 04:22:14 | Alpena, Michigan, US | |
3497801 | 3497801 | 2021-12-15 | US | Michigan | Alpena | 26007 | 4351 | 99 | 0 | 45.03477666 | -83.62212411 | 2021-12-16 04:22:11 | Alpena, Michigan, US | |
554261 | 554261 | 2021-12-08 | US | West Virginia | Jackson | 54035 | 4351 | 96 | 0 | 38.84263974 | -81.68148753 | 2021-12-09 04:22:49 | Jackson, West Virginia, US | |
553707 | 553707 | 2021-12-08 | US | Tennessee | DeKalb | 47041 | 4351 | 77 | 0 | 35.97616272 | -85.83689361 | 2021-12-09 04:22:49 | DeKalb, Tennessee, US | |
551634 | 551634 | 2021-12-08 | US | Georgia | Pierce | 13229 | 4351 | 106 | 0 | 31.35928155 | -82.21598442 | 2021-12-09 04:22:49 | Pierce, Georgia, US | |
2003368 | 2003368 | 2021-11-07 | US | Pennsylvania | Warren | 42123 | 4351 | 135 | 0 | 41.81304978 | -79.26969577 | 2021-11-08 04:21:43 | Warren, Pennsylvania, US | |
3123378 | 3123378 | 2021-11-05 | US | Missouri | Barry | 29009 | 4351 | 63 | 0 | 36.70978521 | -93.82919888 | 2021-11-06 04:21:51 | Barry, Missouri, US | |
3122662 | 3122662 | 2021-11-05 | US | Indiana | Wells | 18179 | 4351 | 90 | 0 | 40.72934187 | -85.22132966 | 2021-11-06 04:21:51 | Wells, Indiana, US | |
569566 | 569566 | 2021-10-29 | US | Ohio | Fayette | 39047 | 4351 | 69 | 0 | 39.56021306 | -83.4562016 | 2021-10-30 04:22:03 | Fayette, Ohio, US | |
3495114 | 3495114 | 2021-10-26 | US | Tennessee | Grainger | 47057 | 4351 | 66 | 0 | 36.27469206 | -83.51254721 | 2021-10-27 04:22:32 | Grainger, Tennessee, US | |
2046089 | 2046089 | 2021-10-18 | US | New York | Greene | 36039 | 4351 | 86 | 0 | 42.275797 | -74.12384884 | 2021-10-19 04:20:54 | Greene, New York, US | |
1493149 | 1493149 | 2021-10-12 | US | Louisiana | West Baton Rouge | 22121 | 4351 | 71 | 0 | 30.46058217 | -91.30989571 | 2021-10-13 04:20:51 | West Baton Rouge, Louisiana, US | |
2878867 | 2878867 | 2021-10-09 | US | Pennsylvania | Clarion | 42031 | 4351 | 110 | 0 | 41.19265812 | -79.42413524 | 2021-10-10 04:21:38 | Clarion, Pennsylvania, US | |
1924364 | 1924364 | 2021-09-24 | US | Texas | Kleberg | 48273 | 4351 | 121 | 0 | 27.42435506 | -97.69894948 | 2021-09-25 04:21:31 | Kleberg, Texas, US | |
603540 | 603540 | 2021-09-23 | US | Mississippi | Tate | 28137 | 4351 | 101 | 0 | 34.65133709 | -89.94485778 | 2021-09-24 04:21:44 | Tate, Mississippi, US | |
1817275 | 1817275 | 2021-09-19 | US | Ohio | Perry | 39127 | 4351 | 59 | 0 | 39.73508655 | -82.23804971 | 2021-09-20 04:21:22 | Perry, Ohio, US | |
1816979 | 1816979 | 2021-09-19 | US | New Mexico | Rio Arriba | 35039 | 4351 | 83 | 0 | 36.51072137 | -106.69316740000001 | 2021-09-20 04:21:22 | Rio Arriba, New Mexico, US | |
18559 | 18559 | 2021-09-18 | US | New Mexico | Rio Arriba | 35039 | 4351 | 83 | 0 | 36.51072137 | -106.69316740000001 | 2021-09-19 04:21:34 | Rio Arriba, New Mexico, US | |
18273 | 18273 | 2021-09-18 | US | Missouri | Lafayette | 29107 | 4351 | 68 | 0 | 39.06986886 | -93.78076396 | 2021-09-19 04:21:34 | Lafayette, Missouri, 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]);