johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
134 rows where confirmed = 5734 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 13
- US 120
- Japan 2
- Russia 2
- Colombia 1
- Grenada 1
- Italy 1
- Netherlands 1
- Niger 1
- Pakistan 1
- San Marino 1
- Spain 1
- Suriname 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417703 | 2417703 | 2022-12-05 | US | South Carolina | Hampton | 45049 | 5734 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-12-06 04:21:03 | Hampton, South Carolina, US | |
721311 | 721311 | 2022-12-04 | US | South Carolina | Hampton | 45049 | 5734 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-12-05 04:20:58 | Hampton, South Carolina, US | |
2819600 | 2819600 | 2022-12-03 | US | South Carolina | Hampton | 45049 | 5734 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-12-04 04:20:56 | Hampton, South Carolina, US | |
836456 | 836456 | 2022-12-02 | US | South Carolina | Hampton | 45049 | 5734 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-12-03 04:21:02 | Hampton, South Carolina, US | |
2138986 | 2138986 | 2022-12-01 | US | South Carolina | Hampton | 45049 | 5734 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-12-02 04:21:07 | Hampton, South Carolina, US | |
1967402 | 1967402 | 2022-11-30 | US | South Carolina | Hampton | 45049 | 5734 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-12-01 04:21:03 | Hampton, South Carolina, US | |
2559416 | 2559416 | 2022-11-29 | US | South Carolina | Hampton | 45049 | 5734 | 86 | 0 | 32.77419582 | -81.13845571 | 2022-11-30 04:21:07 | Hampton, South Carolina, US | |
3756514 | 3756514 | 2022-10-13 | US | Texas | Burleson | 48051 | 5734 | 68 | 0 | 30.49273808 | -96.62158484 | 2022-10-14 04:22:28 | Burleson, Texas, US | |
3217339 | 3217339 | 2022-10-12 | US | Texas | Burleson | 48051 | 5734 | 68 | 0 | 30.49273808 | -96.62158484 | 2022-10-13 04:22:39 | Burleson, Texas, US | |
132078 | 132078 | 2022-10-04 | US | Kansas | Neosho | 20133 | 5734 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-10-05 04:23:06 | Neosho, Kansas, US | |
2687025 | 2687025 | 2022-10-03 | US | Kansas | Neosho | 20133 | 5734 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-10-04 04:22:55 | Neosho, Kansas, US | |
2261092 | 2261092 | 2022-10-02 | US | Kansas | Neosho | 20133 | 5734 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-10-03 04:23:11 | Neosho, Kansas, US | |
2996618 | 2996618 | 2022-10-01 | US | Kansas | Neosho | 20133 | 5734 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-10-02 04:21:23 | Neosho, Kansas, US | |
854944 | 854944 | 2022-09-30 | US | Kansas | Neosho | 20133 | 5734 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-10-01 04:23:01 | Neosho, Kansas, US | |
2376870 | 2376870 | 2022-09-29 | US | Kansas | Neosho | 20133 | 5734 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-09-30 04:23:09 | Neosho, Kansas, US | |
1561421 | 1561421 | 2022-09-28 | US | Kansas | Neosho | 20133 | 5734 | 77 | 0 | 37.55862897 | -95.30670046 | 2022-09-29 04:22:34 | Neosho, Kansas, US | |
1624797 | 1624797 | 2022-09-22 | US | Arkansas | Logan | 5083 | 5734 | 81 | 0 | 35.21413234 | -93.71951016 | 2022-09-23 04:23:13 | Logan, Arkansas, US | |
3989786 | 3989786 | 2022-09-15 | US | Texas | Limestone | 48293 | 5734 | 128 | 0 | 31.5454767 | -96.58095444 | 2022-09-16 04:21:19 | Limestone, Texas, US | |
1892303 | 1892303 | 2022-09-14 | US | Texas | Limestone | 48293 | 5734 | 128 | 0 | 31.5454767 | -96.58095444 | 2022-09-15 04:21:02 | Limestone, Texas, US | |
374015 | 374015 | 2022-09-13 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-14 04:20:44 | Jasper, Mississippi, US | |
2396617 | 2396617 | 2022-09-12 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-13 04:20:57 | Jasper, Mississippi, US | |
3767695 | 3767695 | 2022-09-11 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-12 04:20:58 | Jasper, Mississippi, US | |
3826270 | 3826270 | 2022-09-10 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-11 04:20:50 | Jasper, Mississippi, US | |
964727 | 964727 | 2022-09-09 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-10 04:21:10 | Jasper, Mississippi, US | |
255129 | 255129 | 2022-09-08 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-09 04:21:11 | Jasper, Mississippi, US | |
3747866 | 3747866 | 2022-09-07 | US | Puerto Rico | Lajas | 72079 | 5734 | 0 | 0 | 18.011661 | -67.040585 | 2022-09-08 04:21:02 | Lajas, Puerto Rico, US | |
3746927 | 3746927 | 2022-09-07 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-08 04:21:02 | Jasper, Mississippi, US | |
116567 | 116567 | 2022-09-06 | US | Mississippi | Jasper | 28061 | 5734 | 76 | 0 | 32.01922104 | -89.11786866 | 2022-09-07 04:20:59 | Jasper, Mississippi, US | |
1785783 | 1785783 | 2022-07-29 | US | New York | Schoharie | 36095 | 5734 | 36 | 0 | 42.58831742 | -74.4433903 | 2022-07-30 04:20:42 | Schoharie, New York, US | |
1067773 | 1067773 | 2022-07-28 | US | Missouri | Crawford | 29055 | 5734 | 107 | 0 | 37.97663738 | -91.30528104 | 2022-07-29 04:20:45 | Crawford, Missouri, US | |
2337292 | 2337292 | 2022-07-27 | US | Missouri | Crawford | 29055 | 5734 | 107 | 0 | 37.97663738 | -91.30528104 | 2022-07-28 04:20:56 | Crawford, Missouri, US | |
1489482 | 1489482 | 2022-07-26 | US | Missouri | Crawford | 29055 | 5734 | 107 | 0 | 37.97663738 | -91.30528104 | 2022-07-27 04:21:04 | Crawford, Missouri, US | |
2595928 | 2595928 | 2022-07-25 | US | Missouri | Crawford | 29055 | 5734 | 107 | 0 | 37.97663738 | -91.30528104 | 2022-07-26 04:20:58 | Crawford, Missouri, US | |
899708 | 899708 | 2022-07-24 | US | Wisconsin | Langlade | 55067 | 5734 | 92 | 0 | 45.26271619 | -89.07483625 | 2022-07-25 04:20:51 | Langlade, Wisconsin, US | |
898043 | 898043 | 2022-07-24 | US | Missouri | Crawford | 29055 | 5734 | 107 | 0 | 37.97663738 | -91.30528104 | 2022-07-25 04:20:51 | Crawford, Missouri, US | |
94702 | 94702 | 2022-07-23 | US | Wisconsin | Langlade | 55067 | 5734 | 92 | 0 | 45.26271619 | -89.07483625 | 2022-07-24 04:20:47 | Langlade, Wisconsin, US | |
93037 | 93037 | 2022-07-23 | US | Missouri | Crawford | 29055 | 5734 | 107 | 0 | 37.97663738 | -91.30528104 | 2022-07-24 04:20:47 | Crawford, Missouri, US | |
903724 | 903724 | 2022-07-22 | US | Wisconsin | Langlade | 55067 | 5734 | 92 | 0 | 45.26271619 | -89.07483625 | 2022-07-23 04:20:53 | Langlade, Wisconsin, US | |
902059 | 902059 | 2022-07-22 | US | Missouri | Crawford | 29055 | 5734 | 107 | 0 | 37.97663738 | -91.30528104 | 2022-07-23 04:20:53 | Crawford, Missouri, US | |
2152135 | 2152135 | 2022-07-16 | US | Arkansas | Conway | 5029 | 5734 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-07-17 04:21:15 | Conway, Arkansas, US | |
3969554 | 3969554 | 2022-07-05 | US | Tennessee | Union | 47173 | 5734 | 78 | 0 | 36.28590426 | -83.83651902 | 2022-07-06 04:20:58 | Union, Tennessee, US | |
3967065 | 3967065 | 2022-07-05 | US | Arkansas | Ouachita | 5103 | 5734 | 109 | 0 | 33.58839816 | -92.87795984 | 2022-07-06 04:20:58 | Ouachita, Arkansas, US | |
169376 | 169376 | 2022-06-21 | US | Virginia | Dinwiddie | 51053 | 5734 | 94 | 0 | 37.07544585 | -77.63451754 | 2022-06-22 04:20:54 | Dinwiddie, Virginia, US | |
1421451 | 1421451 | 2022-06-08 | US | Alabama | Barbour | 1005 | 5734 | 99 | 0 | 31.868263 | -85.3871286 | 2022-06-09 04:20:54 | Barbour, Alabama, US | |
1851863 | 1851863 | 2022-05-26 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-27 04:20:56 | Audrain, Missouri, US | |
2049739 | 2049739 | 2022-05-25 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-26 04:20:50 | Audrain, Missouri, US | |
3001177 | 3001177 | 2022-05-24 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-25 04:20:56 | Audrain, Missouri, US | |
3594898 | 3594898 | 2022-05-23 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-24 04:20:57 | Audrain, Missouri, US | |
623750 | 623750 | 2022-05-22 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-26 04:20:50 | Audrain, Missouri, US | |
1111446 | 1111446 | 2022-05-21 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-22 04:20:52 | Audrain, Missouri, US | |
1171070 | 1171070 | 2022-05-20 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-21 04:20:58 | Audrain, Missouri, US | |
3897833 | 3897833 | 2022-05-19 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-20 04:20:57 | Audrain, Missouri, US | |
1186617 | 1186617 | 2022-05-18 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-05-19 04:20:54 | Audrain, Missouri, US | |
2599630 | 2599630 | 2022-05-05 | US | Maryland | Garrett | 24023 | 5734 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-05-06 04:21:00 | Garrett, Maryland, US | |
3267079 | 3267079 | 2022-05-04 | US | Maryland | Garrett | 24023 | 5734 | 116 | 0 | 39.52786077 | -79.27355126 | 2022-05-05 04:20:55 | Garrett, Maryland, US | |
3853726 | 3853726 | 2022-04-27 | US | Missouri | Henry | 29083 | 5734 | 86 | 0 | 38.38482826 | -93.79293734 | 2022-04-28 04:20:47 | Henry, Missouri, US | |
1328156 | 1328156 | 2022-04-26 | US | Missouri | Henry | 29083 | 5734 | 86 | 0 | 38.38482826 | -93.79293734 | 2022-04-27 04:20:52 | Henry, Missouri, US | |
3724110 | 3724110 | 2022-04-25 | US | Missouri | Henry | 29083 | 5734 | 86 | 0 | 38.38482826 | -93.79293734 | 2022-04-26 04:20:51 | Henry, Missouri, US | |
2030678 | 2030678 | 2022-04-24 | US | Missouri | Henry | 29083 | 5734 | 86 | 0 | 38.38482826 | -93.79293734 | 2022-04-25 04:20:56 | Henry, Missouri, US | |
748253 | 748253 | 2022-04-23 | US | Missouri | Henry | 29083 | 5734 | 86 | 0 | 38.38482826 | -93.79293734 | 2022-04-24 04:20:56 | Henry, Missouri, US | |
3438738 | 3438738 | 2022-04-22 | US | Missouri | Henry | 29083 | 5734 | 86 | 0 | 38.38482826 | -93.79293734 | 2022-04-23 04:20:50 | Henry, Missouri, US | |
2894323 | 2894323 | 2022-04-21 | US | Missouri | Henry | 29083 | 5734 | 86 | 0 | 38.38482826 | -93.79293734 | 2022-04-22 04:20:45 | Henry, Missouri, US | |
1951532 | 1951532 | 2022-04-12 | US | Texas | Austin | 48015 | 5734 | 73 | 0 | 29.88548725 | -96.27736949 | 2022-04-13 04:21:03 | Austin, Texas, US | |
3209405 | 3209405 | 2022-04-11 | US | Texas | Karnes | 48255 | 5734 | 70 | 0 | 28.90705334 | -97.85960149 | 2022-04-12 04:20:49 | Karnes, Texas, US | |
1579291 | 1579291 | 2022-04-10 | US | Texas | Karnes | 48255 | 5734 | 70 | 0 | 28.90705334 | -97.85960149 | 2022-04-11 04:21:02 | Karnes, Texas, US | |
1655533 | 1655533 | 2022-04-09 | US | Texas | Karnes | 48255 | 5734 | 70 | 0 | 28.90705334 | -97.85960149 | 2022-04-10 04:20:52 | Karnes, Texas, US | |
2802647 | 2802647 | 2022-04-06 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-04-07 04:20:53 | Audrain, Missouri, US | |
3869416 | 3869416 | 2022-04-05 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-04-06 04:20:49 | Audrain, Missouri, US | |
2750758 | 2750758 | 2022-04-04 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-04-05 04:20:48 | Audrain, Missouri, US | |
3732104 | 3732104 | 2022-04-03 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-04-04 04:20:51 | Audrain, Missouri, US | |
501539 | 501539 | 2022-04-02 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-04-03 04:20:48 | Audrain, Missouri, US | |
3352524 | 3352524 | 2022-04-01 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-04-02 04:20:47 | Audrain, Missouri, US | |
1541829 | 1541829 | 2022-03-31 | US | Missouri | Audrain | 29007 | 5734 | 111 | 0 | 39.215877 | -91.84242683 | 2022-04-01 04:20:28 | Audrain, Missouri, US | |
2528080 | 2528080 | 2022-03-02 | US | Puerto Rico | Aguada | 72003 | 5734 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-03-03 04:21:01 | Aguada, Puerto Rico, US | |
2527216 | 2527216 | 2022-03-02 | US | Mississippi | Sunflower | 28133 | 5734 | 120 | 0 | 33.60192578 | -90.58882684 | 2022-03-03 04:21:01 | Sunflower, Mississippi, US | |
577102 | 577102 | 2022-02-25 | US | New York | Seneca | 36099 | 5734 | 89 | 0 | 42.78081007 | -76.82497064 | 2022-02-26 04:21:12 | Seneca, New York, US | |
1059383 | 1059383 | 2022-02-23 | US | Louisiana | St. James | 22093 | 5734 | 75 | 0 | 30.02531716 | -90.80212061 | 2022-02-24 04:21:14 | St. James, Louisiana, US | |
3672777 | 3672777 | 2022-02-15 | US | Indiana | Owen | 18119 | 5734 | 107 | 0 | 39.31145587 | -86.83900724 | 2022-02-16 04:21:10 | Owen, Indiana, US | |
1116258 | 1116258 | 2022-01-11 | US | Pennsylvania | Elk | 42047 | 5734 | 81 | 0 | 41.42822061 | -78.64524744 | 2022-01-12 04:21:44 | Elk, Pennsylvania, US | |
1285282 | 1285282 | 2022-01-05 | US | Vermont | Washington | 50023 | 5734 | 36 | 0 | 44.27343241 | -72.61604978 | 2022-01-06 04:22:09 | Washington, Vermont, US | |
1289416 | 1289416 | 2022-01-04 | US | Virginia | Smyth | 51173 | 5734 | 139 | 0 | 36.84455636 | -81.53344948 | 2022-01-05 04:21:59 | Smyth, Virginia, US | |
3522553 | 3522553 | 2022-01-02 | US | Texas | Hockley | 48219 | 5734 | 141 | 0 | 33.60771256 | -102.3431676 | 2022-01-03 02:22:25 | Hockley, Texas, US | |
1258453 | 1258453 | 2021-12-20 | United Kingdom | Guernsey | 5734 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-12-21 03:21:27 | Guernsey, United Kingdom | ||
2904730 | 2904730 | 2021-12-19 | US | Illinois | Logan | 17107 | 5734 | 77 | 0 | 40.12581572 | -89.36638784 | 2021-12-20 04:21:43 | Logan, Illinois, US | |
1259803 | 1259803 | 2021-12-18 | US | Illinois | Logan | 17107 | 5734 | 77 | 0 | 40.12581572 | -89.36638784 | 2021-12-19 04:21:11 | Logan, Illinois, US | |
2399831 | 2399831 | 2021-12-17 | US | Illinois | Logan | 17107 | 5734 | 77 | 0 | 40.12581572 | -89.36638784 | 2021-12-18 02:22:20 | Logan, Illinois, US | |
1662346 | 1662346 | 2021-12-12 | US | Missouri | Laclede | 29105 | 5734 | 149 | 0 | 37.65896829 | -92.5888493 | 2021-12-13 04:22:02 | Laclede, Missouri, US | |
406797 | 406797 | 2021-12-07 | US | Ohio | Perry | 39127 | 5734 | 90 | 0 | 39.73508655 | -82.23804971 | 2021-12-08 04:22:46 | Perry, Ohio, US | |
3289188 | 3289188 | 2021-11-18 | San Marino | 5734 | 92 | 0 | 43.9424 | 12.4578 | 2021-11-19 04:21:40 | San Marino | ||||
2002114 | 2002114 | 2021-11-07 | US | Kentucky | Muhlenberg | 21177 | 5734 | 93 | 0 | 37.21425819 | -87.14632053 | 2021-11-08 04:21:43 | Muhlenberg, Kentucky, US | |
2721033 | 2721033 | 2021-10-30 | Japan | Yamaguchi | 5734 | 93 | 0 | 34.201190000000004 | 131.573293 | 2021-10-31 04:22:08 | Yamaguchi, Japan | |||
535875 | 535875 | 2021-10-27 | US | Indiana | Steuben | 18151 | 5734 | 77 | 0 | 41.64423868 | -85.00101094 | 2021-10-28 04:22:08 | Steuben, Indiana, US | |
2126711 | 2126711 | 2021-10-21 | US | Tennessee | Marion | 47115 | 5734 | 53 | 0 | 35.12997174 | -85.62265895 | 2021-10-22 04:21:14 | Marion, Tennessee, US | |
934711 | 934711 | 2021-10-16 | Grenada | 5734 | 192 | 0 | 12.1165 | -61.678999999999995 | 2021-10-17 04:21:29 | Grenada | ||||
2281830 | 2281830 | 2021-09-08 | US | Pennsylvania | Huntingdon | 42061 | 5734 | 139 | 0 | 40.42162652 | -77.97673273 | 2021-09-09 04:21:27 | Huntingdon, Pennsylvania, US | |
3284448 | 3284448 | 2021-09-05 | US | Wisconsin | Shawano | 55115 | 5734 | 85 | 0 | 44.78902246 | -88.76443896 | 2021-09-06 04:21:22 | Shawano, Wisconsin, US | |
3281955 | 3281955 | 2021-09-05 | US | Indiana | Gibson | 18051 | 5734 | 102 | 0 | 38.30393723 | -87.58054938 | 2021-09-06 04:21:22 | Gibson, Indiana, US | |
252862 | 252862 | 2021-09-04 | US | Wisconsin | Shawano | 55115 | 5734 | 85 | 0 | 44.78902246 | -88.76443896 | 2021-09-05 04:21:33 | Shawano, Wisconsin, US | |
3978143 | 3978143 | 2021-09-03 | US | Wisconsin | Shawano | 55115 | 5734 | 85 | 0 | 44.78902246 | -88.76443896 | 2021-09-04 04:21:28 | Shawano, Wisconsin, US | |
245406 | 245406 | 2021-08-17 | Niger | 5734 | 196 | 0 | 17.607789 | 8.081666 | 2021-08-18 04:21:35 | Niger |
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]);