johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
181 rows where confirmed = 4308 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3223075 | 3223075 | 2022-12-25 | US | Colorado | Las Animas | 8071 | 4308 | 51 | 0 | 37.3153406 | -104.0376458 | 2022-12-26 04:21:06 | Las Animas, Colorado, US | |
1018989 | 1018989 | 2022-12-24 | US | Colorado | Las Animas | 8071 | 4308 | 51 | 0 | 37.3153406 | -104.0376458 | 2022-12-25 04:21:04 | Las Animas, Colorado, US | |
691012 | 691012 | 2022-12-23 | US | Colorado | Las Animas | 8071 | 4308 | 51 | 0 | 37.3153406 | -104.0376458 | 2022-12-24 04:21:02 | Las Animas, Colorado, US | |
2954802 | 2954802 | 2022-12-20 | US | Virginia | Southampton | 51175 | 4308 | 101 | 0 | 36.72231125 | -77.10642712 | 2022-12-21 04:21:03 | Southampton, Virginia, US | |
259617 | 259617 | 2022-12-10 | US | New York | Yates | 36123 | 4308 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-11 04:20:50 | Yates, New York, US | |
1988209 | 1988209 | 2022-12-07 | US | Wisconsin | Lafayette | 55065 | 4308 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-08 04:21:07 | Lafayette, Wisconsin, US | |
3715670 | 3715670 | 2022-12-06 | US | Louisiana | Caldwell | 22021 | 4308 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-07 04:20:58 | Caldwell, Louisiana, US | |
2416375 | 2416375 | 2022-12-05 | US | Louisiana | Caldwell | 22021 | 4308 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-06 04:21:03 | Caldwell, Louisiana, US | |
719983 | 719983 | 2022-12-04 | US | Louisiana | Caldwell | 22021 | 4308 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-05 04:20:58 | Caldwell, Louisiana, US | |
2818272 | 2818272 | 2022-12-03 | US | Louisiana | Caldwell | 22021 | 4308 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-04 04:20:56 | Caldwell, Louisiana, US | |
835128 | 835128 | 2022-12-02 | US | Louisiana | Caldwell | 22021 | 4308 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-03 04:21:02 | Caldwell, Louisiana, US | |
2137658 | 2137658 | 2022-12-01 | US | Louisiana | Caldwell | 22021 | 4308 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-02 04:21:07 | Caldwell, Louisiana, US | |
1966074 | 1966074 | 2022-11-30 | US | Louisiana | Caldwell | 22021 | 4308 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-01 04:21:03 | Caldwell, Louisiana, US | |
3287105 | 3287105 | 2022-10-31 | US | New Mexico | Los Alamos | 35028 | 4308 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-11-01 04:22:36 | Los Alamos, New Mexico, US | |
134017 | 134017 | 2022-10-04 | US | Texas | Young | 48503 | 4308 | 96 | 0 | 33.17659707 | -98.68790885 | 2022-10-05 04:23:06 | Young, Texas, US | |
2688964 | 2688964 | 2022-10-03 | US | Texas | Young | 48503 | 4308 | 96 | 0 | 33.17659707 | -98.68790885 | 2022-10-04 04:22:55 | Young, Texas, US | |
2998041 | 2998041 | 2022-10-01 | US | Puerto Rico | Hormigueros | 72067 | 4308 | 0 | 0 | 18.134532 | -67.113972 | 2022-10-02 04:21:23 | Hormigueros, Puerto Rico, US | |
2018028 | 2018028 | 2022-09-20 | US | Kansas | Jackson | 20085 | 4308 | 33 | 0 | 39.41673394 | -95.79356799 | 2022-09-21 04:23:22 | Jackson, Kansas, US | |
3571901 | 3571901 | 2022-09-19 | US | Kansas | Jackson | 20085 | 4308 | 33 | 0 | 39.41673394 | -95.79356799 | 2022-09-20 04:22:48 | Jackson, Kansas, US | |
420640 | 420640 | 2022-09-18 | US | Kansas | Jackson | 20085 | 4308 | 33 | 0 | 39.41673394 | -95.79356799 | 2022-09-19 04:21:49 | Jackson, Kansas, US | |
3374664 | 3374664 | 2022-09-17 | US | Kansas | Jackson | 20085 | 4308 | 33 | 0 | 39.41673394 | -95.79356799 | 2022-09-18 04:22:50 | Jackson, Kansas, US | |
2356772 | 2356772 | 2022-09-16 | US | Kansas | Jackson | 20085 | 4308 | 33 | 0 | 39.41673394 | -95.79356799 | 2022-09-17 04:20:19 | Jackson, Kansas, US | |
3987929 | 3987929 | 2022-09-15 | US | Kansas | Jackson | 20085 | 4308 | 33 | 0 | 39.41673394 | -95.79356799 | 2022-09-16 04:21:19 | Jackson, Kansas, US | |
1890446 | 1890446 | 2022-09-14 | US | Kansas | Jackson | 20085 | 4308 | 33 | 0 | 39.41673394 | -95.79356799 | 2022-09-15 04:21:02 | Jackson, Kansas, US | |
254016 | 254016 | 2022-09-08 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-09-09 04:21:11 | Hamilton, Florida, US | |
3745814 | 3745814 | 2022-09-07 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-09-08 04:21:02 | Hamilton, Florida, US | |
118114 | 118114 | 2022-09-06 | US | Virginia | King William | 51101 | 4308 | 48 | 0 | 37.70965316 | -77.09384941 | 2022-09-07 04:20:59 | King William, Virginia, US | |
115454 | 115454 | 2022-09-06 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-09-07 04:20:59 | Hamilton, Florida, US | |
2634426 | 2634426 | 2022-09-05 | US | Florida | Hamilton | 12047 | 4308 | 53 | 0 | 30.49673973 | -82.94998918 | 2022-09-06 04:21:02 | Hamilton, Florida, US | |
2987990 | 2987990 | 2022-09-04 | US | Florida | Hamilton | 12047 | 4308 | 53 | 0 | 30.49673973 | -82.94998918 | 2022-09-05 04:21:01 | Hamilton, Florida, US | |
2713675 | 2713675 | 2022-09-03 | US | Florida | Hamilton | 12047 | 4308 | 53 | 0 | 30.49673973 | -82.94998918 | 2022-09-04 04:21:22 | Hamilton, Florida, US | |
1394380 | 1394380 | 2022-09-02 | US | Florida | Hamilton | 12047 | 4308 | 53 | 0 | 30.49673973 | -82.94998918 | 2022-09-03 04:21:04 | Hamilton, Florida, US | |
3548209 | 3548209 | 2022-09-01 | US | Florida | Hamilton | 12047 | 4308 | 53 | 0 | 30.49673973 | -82.94998918 | 2022-09-02 04:21:07 | Hamilton, Florida, US | |
2344129 | 2344129 | 2022-08-31 | US | Florida | Hamilton | 12047 | 4308 | 53 | 0 | 30.49673973 | -82.94998918 | 2022-09-01 04:21:03 | Hamilton, Florida, US | |
3774609 | 3774609 | 2022-08-30 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-08-31 04:20:57 | Hamilton, Florida, US | |
1681205 | 1681205 | 2022-08-29 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-08-30 04:21:03 | Hamilton, Florida, US | |
1877689 | 1877689 | 2022-08-28 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-08-29 04:21:06 | Hamilton, Florida, US | |
2096816 | 2096816 | 2022-08-27 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-08-28 04:21:02 | Hamilton, Florida, US | |
1532631 | 1532631 | 2022-08-26 | US | Florida | Hamilton | 12047 | 4308 | 56 | 0 | 30.49673973 | -82.94998918 | 2022-08-27 04:20:57 | Hamilton, Florida, US | |
1253491 | 1253491 | 2022-08-23 | US | Puerto Rico | Ciales | 72039 | 4308 | 0 | 0 | 18.28885 | -66.516475 | 2022-08-24 04:20:46 | Ciales, Puerto Rico, US | |
1073197 | 1073197 | 2022-08-07 | US | Virginia | Appomattox | 51011 | 4308 | 55 | 0 | 37.37569884 | -78.81340003 | 2022-08-08 04:21:08 | Appomattox, Virginia, US | |
1943785 | 1943785 | 2022-08-06 | US | Virginia | Appomattox | 51011 | 4308 | 55 | 0 | 37.37569884 | -78.81340003 | 2022-08-07 04:20:54 | Appomattox, Virginia, US | |
883584 | 883584 | 2022-08-05 | US | Virginia | Appomattox | 51011 | 4308 | 55 | 0 | 37.37569884 | -78.81340003 | 2022-08-06 04:20:56 | Appomattox, Virginia, US | |
3617588 | 3617588 | 2022-08-01 | US | Arkansas | Madison | 5087 | 4308 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-08-02 04:20:53 | Madison, Arkansas, US | |
3112834 | 3112834 | 2022-07-13 | US | Virginia | Grayson | 51077 | 4308 | 83 | 0 | 36.65677234 | -81.23215889 | 2022-07-14 04:20:57 | Grayson, Virginia, US | |
3969896 | 3969896 | 2022-07-05 | US | Virginia | Giles | 51071 | 4308 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-07-06 04:20:58 | Giles, Virginia, US | |
941942 | 941942 | 2022-06-25 | US | Texas | Houston | 48225 | 4308 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-06-26 04:21:02 | Houston, Texas, US | |
3986095 | 3986095 | 2022-06-15 | US | West Virginia | Hardy | 54031 | 4308 | 49 | 0 | 39.00683177 | -78.85855301 | 2022-06-16 04:20:55 | Hardy, West Virginia, US | |
2236898 | 2236898 | 2022-06-12 | US | Louisiana | LaSalle | 22059 | 4308 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-13 04:21:14 | LaSalle, Louisiana, US | |
3143096 | 3143096 | 2022-06-11 | US | Louisiana | LaSalle | 22059 | 4308 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-12 04:20:53 | LaSalle, Louisiana, US | |
1946012 | 1946012 | 2022-06-10 | US | Louisiana | LaSalle | 22059 | 4308 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-11 04:21:01 | LaSalle, Louisiana, US | |
3869923 | 3869923 | 2022-04-05 | US | North Carolina | Warren | 37185 | 4308 | 39 | 0 | 36.39728256 | -78.10652228 | 2022-04-06 04:20:49 | Warren, North Carolina, US | |
2751265 | 2751265 | 2022-04-04 | US | North Carolina | Warren | 37185 | 4308 | 39 | 0 | 36.39728256 | -78.10652228 | 2022-04-05 04:20:48 | Warren, North Carolina, US | |
3732611 | 3732611 | 2022-04-03 | US | North Carolina | Warren | 37185 | 4308 | 39 | 0 | 36.39728256 | -78.10652228 | 2022-04-04 04:20:51 | Warren, North Carolina, US | |
502046 | 502046 | 2022-04-02 | US | North Carolina | Warren | 37185 | 4308 | 39 | 0 | 36.39728256 | -78.10652228 | 2022-04-03 04:20:48 | Warren, North Carolina, US | |
3353031 | 3353031 | 2022-04-01 | US | North Carolina | Warren | 37185 | 4308 | 39 | 0 | 36.39728256 | -78.10652228 | 2022-04-02 04:20:47 | Warren, North Carolina, US | |
1542336 | 1542336 | 2022-03-31 | US | North Carolina | Warren | 37185 | 4308 | 39 | 0 | 36.39728256 | -78.10652228 | 2022-04-01 04:20:28 | Warren, North Carolina, US | |
877244 | 877244 | 2022-03-27 | US | Illinois | De Witt | 17039 | 4308 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-03-28 04:20:33 | De Witt, Illinois, US | |
2164527 | 2164527 | 2022-03-26 | US | Illinois | De Witt | 17039 | 4308 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-03-27 04:20:47 | De Witt, Illinois, US | |
1721463 | 1721463 | 2022-03-25 | US | Illinois | De Witt | 17039 | 4308 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-03-26 04:20:23 | De Witt, Illinois, US | |
1469064 | 1469064 | 2022-03-24 | US | Illinois | Bond | 17005 | 4308 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-03-25 04:20:46 | Bond, Illinois, US | |
1468843 | 1468843 | 2022-03-24 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-25 04:20:46 | Union, Florida, US | |
3023238 | 3023238 | 2022-03-23 | US | Illinois | Bond | 17005 | 4308 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-03-24 04:20:43 | Bond, Illinois, US | |
3023017 | 3023017 | 2022-03-23 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-24 04:20:43 | Union, Florida, US | |
1905939 | 1905939 | 2022-03-22 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-23 04:20:48 | Union, Florida, US | |
3239070 | 3239070 | 2022-03-21 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-22 04:20:54 | Union, Florida, US | |
25143 | 25143 | 2022-03-20 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-21 04:20:50 | Union, Florida, US | |
1657153 | 1657153 | 2022-03-19 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-20 04:20:45 | Union, Florida, US | |
339088 | 339088 | 2022-03-18 | US | Texas | Lamb | 48279 | 4308 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-03-19 04:20:47 | Lamb, Texas, US | |
336679 | 336679 | 2022-03-18 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-19 04:20:47 | Union, Florida, US | |
697912 | 697912 | 2022-03-17 | US | West Virginia | Wetzel | 54103 | 4308 | 81 | 0 | 39.6065771 | -80.64016540000001 | 2022-03-18 04:20:55 | Wetzel, West Virginia, US | |
695132 | 695132 | 2022-03-17 | US | Florida | Union | 12125 | 4308 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-03-18 04:20:55 | Union, Florida, US | |
2320075 | 2320075 | 2022-03-16 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-17 04:20:56 | Union, Florida, US | |
262275 | 262275 | 2022-03-15 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-16 04:20:50 | Union, Florida, US | |
2264634 | 2264634 | 2022-03-14 | US | Florida | Union | 12125 | 4308 | 115 | 0 | 30.04412971 | -82.37497443 | 2022-03-15 04:20:47 | Union, Florida, US | |
3628700 | 3628700 | 2022-03-13 | US | Florida | Union | 12125 | 4308 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-03-14 04:20:46 | Union, Florida, US | |
3628390 | 3628390 | 2022-03-13 | US | Alaska | North Slope | 2185 | 4308 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-03-14 04:20:46 | North Slope, Alaska, US | |
951608 | 951608 | 2022-03-12 | US | Florida | Union | 12125 | 4308 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-03-13 04:20:49 | Union, Florida, US | |
951298 | 951298 | 2022-03-12 | US | Alaska | North Slope | 2185 | 4308 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-03-13 04:20:49 | North Slope, Alaska, US | |
357069 | 357069 | 2022-03-11 | US | Florida | Union | 12125 | 4308 | 111 | 0 | 30.04412971 | -82.37497443 | 2022-03-12 04:20:50 | Union, Florida, US | |
356759 | 356759 | 2022-03-11 | US | Alaska | North Slope | 2185 | 4308 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-03-12 04:20:50 | North Slope, Alaska, US | |
71619 | 71619 | 2022-02-07 | US | Arkansas | Sharp | 5135 | 4308 | 86 | 0 | 36.16258158 | -91.47819342 | 2022-02-08 04:21:15 | Sharp, Arkansas, US | |
2014837 | 2014837 | 2022-02-06 | US | Nebraska | Washington | 31177 | 4308 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-07 04:21:05 | Washington, Nebraska, US | |
2013235 | 2013235 | 2022-02-06 | US | Arkansas | Sharp | 5135 | 4308 | 86 | 0 | 36.16258158 | -91.47819342 | 2022-02-07 04:21:05 | Sharp, Arkansas, US | |
1296166 | 1296166 | 2022-02-05 | US | Nebraska | Washington | 31177 | 4308 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-06 04:21:00 | Washington, Nebraska, US | |
1294564 | 1294564 | 2022-02-05 | US | Arkansas | Sharp | 5135 | 4308 | 86 | 0 | 36.16258158 | -91.47819342 | 2022-02-06 04:21:00 | Sharp, Arkansas, US | |
2329494 | 2329494 | 2022-02-04 | US | Nebraska | Washington | 31177 | 4308 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-05 04:21:05 | Washington, Nebraska, US | |
979813 | 979813 | 2022-02-01 | US | Georgia | Putnam | 13237 | 4308 | 92 | 0 | 33.32056115 | -83.37552891 | 2022-02-02 04:21:09 | Putnam, Georgia, US | |
3065000 | 3065000 | 2022-01-29 | US | Tennessee | Unicoi | 47171 | 4308 | 85 | 0 | 36.10890856 | -82.43709629 | 2022-01-30 04:21:26 | Unicoi, Tennessee, US | |
1321538 | 1321538 | 2022-01-26 | US | Virginia | Colonial Heights | 51570 | 4308 | 72 | 0 | 37.26420587 | -77.39609676 | 2022-01-27 04:21:19 | Colonial Heights, Virginia, US | |
2054193 | 2054193 | 2022-01-25 | US | North Carolina | Currituck | 37053 | 4308 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-01-26 04:21:07 | Currituck, North Carolina, US | |
102540 | 102540 | 2022-01-14 | US | Texas | San Jacinto | 48407 | 4308 | 85 | 0 | 30.57933681 | -95.16260304 | 2022-01-15 04:21:07 | San Jacinto, Texas, US | |
4001657 | 4001657 | 2021-12-30 | US | Tennessee | Wayne | 47181 | 4308 | 47 | 0 | 35.23868267 | -87.78644456 | 2021-12-31 04:21:50 | Wayne, Tennessee, US | |
1433209 | 1433209 | 2021-12-28 | US | Colorado | Morgan | 8087 | 4308 | 129 | 0 | 40.26279810000001 | -103.8093302 | 2021-12-29 03:21:43 | Morgan, Colorado, US | |
801611 | 801611 | 2021-12-22 | US | Texas | Moore | 48341 | 4308 | 92 | 0 | 35.83769242 | -101.8930281 | 2021-12-23 04:21:21 | Moore, Texas, US | |
1717203 | 1717203 | 2021-12-16 | US | Georgia | Monroe | 13207 | 4308 | 153 | 0 | 33.014289 | -83.92097166 | 2021-12-17 04:22:14 | Monroe, Georgia, US | |
1032309 | 1032309 | 2021-12-06 | US | Missouri | Miller | 29131 | 4308 | 100 | 0 | 38.21450288 | -92.42610898 | 2021-12-07 04:22:34 | Miller, Missouri, US | |
3402317 | 3402317 | 2021-11-30 | US | Georgia | Sumter | 13261 | 4308 | 137 | 0 | 32.03650571 | -84.19821492 | 2021-12-01 04:22:29 | Sumter, Georgia, US | |
3070889 | 3070889 | 2021-11-23 | US | Georgia | Pierce | 13229 | 4308 | 104 | 0 | 31.35928155 | -82.21598442 | 2021-11-24 04:22:14 | Pierce, Georgia, US | |
3749987 | 3749987 | 2021-11-22 | US | Georgia | Pierce | 13229 | 4308 | 104 | 0 | 31.35928155 | -82.21598442 | 2021-11-23 04:22:39 | Pierce, Georgia, 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]);