johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
197 rows where confirmed = 3817 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1629894 | 1629894 | 2022-12-18 | US | Maryland | Kent | 24029 | 3817 | 73 | 0 | 39.24976208 | -76.04741541 | 2022-12-19 04:21:03 | Kent, Maryland, US | |
505273 | 505273 | 2022-12-17 | US | Maryland | Kent | 24029 | 3817 | 73 | 0 | 39.24976208 | -76.04741541 | 2022-12-18 04:21:03 | Kent, Maryland, US | |
3325845 | 3325845 | 2022-12-16 | US | Maryland | Kent | 24029 | 3817 | 73 | 0 | 39.24976208 | -76.04741541 | 2022-12-17 04:21:04 | Kent, Maryland, US | |
1831136 | 1831136 | 2022-10-25 | US | Illinois | Cumberland | 17035 | 3817 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-10-26 04:22:19 | Cumberland, Illinois, US | |
3097248 | 3097248 | 2022-10-09 | China | Shaanxi | 3817 | 3 | 0 | 35.1917 | 108.8701 | 2022-10-10 04:22:32 | Shaanxi, China | |||
2020152 | 2020152 | 2022-09-20 | US | Virginia | Westmoreland | 51193 | 3817 | 56 | 0 | 38.11021557 | -76.80213247 | 2022-09-21 04:23:22 | Westmoreland, Virginia, US | |
420839 | 420839 | 2022-09-18 | US | Louisiana | Claiborne | 22027 | 3817 | 79 | 0 | 32.82308512 | -92.99526883 | 2022-09-19 04:21:49 | Claiborne, Louisiana, US | |
3374863 | 3374863 | 2022-09-17 | US | Louisiana | Claiborne | 22027 | 3817 | 79 | 0 | 32.82308512 | -92.99526883 | 2022-09-18 04:22:50 | Claiborne, Louisiana, US | |
2356971 | 2356971 | 2022-09-16 | US | Louisiana | Claiborne | 22027 | 3817 | 79 | 0 | 32.82308512 | -92.99526883 | 2022-09-17 04:20:19 | Claiborne, Louisiana, US | |
2406090 | 2406090 | 2022-08-21 | US | Texas | Wilbarger | 48487 | 3817 | 89 | 0 | 34.07945812 | -99.24178437 | 2022-08-22 04:20:38 | Wilbarger, Texas, US | |
3801168 | 3801168 | 2022-08-20 | US | Texas | Wilbarger | 48487 | 3817 | 89 | 0 | 34.07945812 | -99.24178437 | 2022-08-21 04:20:44 | Wilbarger, Texas, US | |
2366754 | 2366754 | 2022-08-19 | US | Texas | Wilbarger | 48487 | 3817 | 89 | 0 | 34.07945812 | -99.24178437 | 2022-08-20 04:21:01 | Wilbarger, Texas, US | |
3650958 | 3650958 | 2022-08-14 | US | Virginia | Martinsville | 51690 | 3817 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-08-15 04:20:59 | Martinsville, Virginia, US | |
1971964 | 1971964 | 2022-08-13 | US | Virginia | Martinsville | 51690 | 3817 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-08-14 04:20:55 | Martinsville, Virginia, US | |
2891773 | 2891773 | 2022-08-12 | US | Virginia | Martinsville | 51690 | 3817 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-08-13 04:20:52 | Martinsville, Virginia, US | |
2011440 | 2011440 | 2022-08-04 | US | Puerto Rico | Hormigueros | 72067 | 3817 | 0 | 0 | 18.134532 | -67.113972 | 2022-08-05 04:20:52 | Hormigueros, Puerto Rico, US | |
3620614 | 3620614 | 2022-08-01 | US | Wisconsin | Buffalo | 55011 | 3817 | 12 | 0 | 44.37835084 | -91.75332578 | 2022-08-02 04:20:53 | Buffalo, Wisconsin, US | |
1066502 | 1066502 | 2022-07-28 | US | Colorado | Grand | 8049 | 3817 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-07-29 04:20:45 | Grand, Colorado, US | |
3111688 | 3111688 | 2022-07-13 | US | New Mexico | Los Alamos | 35028 | 3817 | 17 | 0 | 35.86631386 | -106.3134985 | 2022-07-14 04:20:57 | Los Alamos, New Mexico, US | |
633439 | 633439 | 2022-07-12 | US | Wisconsin | Bayfield | 55007 | 3817 | 42 | 0 | 46.52868768 | -91.19716729 | 2022-07-13 04:20:58 | Bayfield, Wisconsin, US | |
630848 | 630848 | 2022-07-12 | US | Idaho | Gem | 16045 | 3817 | 80 | 0 | 44.06482372 | -116.398376 | 2022-07-13 04:20:58 | Gem, Idaho, US | |
1212492 | 1212492 | 2022-07-11 | US | Idaho | Gem | 16045 | 3817 | 80 | 0 | 44.06482372 | -116.398376 | 2022-07-12 04:20:51 | Gem, Idaho, US | |
1417723 | 1417723 | 2022-07-08 | US | Colorado | Las Animas | 8071 | 3817 | 45 | 0 | 37.3153406 | -104.0376458 | 2022-07-09 04:20:59 | Las Animas, Colorado, US | |
2239893 | 2239893 | 2022-06-28 | US | Arkansas | Howard | 5061 | 3817 | 52 | 0 | 34.09007427 | -93.9934871 | 2022-06-29 04:20:59 | Howard, Arkansas, US | |
3348755 | 3348755 | 2022-06-24 | US | Nebraska | Saline | 31151 | 3817 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-06-25 04:20:57 | Saline, Nebraska, US | |
1650496 | 1650496 | 2022-06-23 | US | Nebraska | Saline | 31151 | 3817 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-06-24 04:20:58 | Saline, Nebraska, US | |
1648761 | 1648761 | 2022-06-23 | US | Alabama | Lamar | 1075 | 3817 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-06-24 04:20:58 | Lamar, Alabama, US | |
2189731 | 2189731 | 2022-06-22 | US | Nebraska | Saline | 31151 | 3817 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-06-23 04:20:55 | Saline, Nebraska, US | |
168162 | 168162 | 2022-06-21 | US | Nebraska | Saline | 31151 | 3817 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-06-22 04:20:54 | Saline, Nebraska, US | |
1765445 | 1765445 | 2022-06-20 | US | Nebraska | Saline | 31151 | 3817 | 12 | 0 | 40.52418865 | -97.14085859 | 2022-06-21 04:20:56 | Saline, Nebraska, US | |
3161026 | 3161026 | 2022-06-09 | US | Virginia | Patrick | 51141 | 3817 | 97 | 0 | 36.6801638 | -80.2865648 | 2022-06-10 04:20:55 | Patrick, Virginia, US | |
2049629 | 2049629 | 2022-05-25 | US | Minnesota | Renville | 27129 | 3817 | 56 | 0 | 44.72836381 | -94.94553734 | 2022-05-26 04:20:50 | Renville, Minnesota, US | |
3001067 | 3001067 | 2022-05-24 | US | Minnesota | Renville | 27129 | 3817 | 56 | 0 | 44.72836381 | -94.94553734 | 2022-05-25 04:20:56 | Renville, Minnesota, US | |
623640 | 623640 | 2022-05-22 | US | Minnesota | Renville | 27129 | 3817 | 56 | 0 | 44.72836381 | -94.94553734 | 2022-05-26 04:20:50 | Renville, Minnesota, US | |
2087262 | 2087262 | 2022-05-15 | US | Virginia | Appomattox | 51011 | 3817 | 53 | 0 | 37.37569884 | -78.81340003 | 2022-05-16 04:20:47 | Appomattox, Virginia, US | |
3357972 | 3357972 | 2022-05-14 | US | Virginia | Appomattox | 51011 | 3817 | 53 | 0 | 37.37569884 | -78.81340003 | 2022-05-15 04:20:53 | Appomattox, Virginia, US | |
661617 | 661617 | 2022-05-13 | US | Virginia | Appomattox | 51011 | 3817 | 53 | 0 | 37.37569884 | -78.81340003 | 2022-05-14 04:20:48 | Appomattox, Virginia, US | |
2533883 | 2533883 | 2022-05-12 | US | Arkansas | Franklin | 5047 | 3817 | 73 | 0 | 35.51202821 | -93.89299569 | 2022-05-13 04:20:51 | Franklin, Arkansas, US | |
3445329 | 3445329 | 2022-05-11 | US | Arkansas | Franklin | 5047 | 3817 | 73 | 0 | 35.51202821 | -93.89299569 | 2022-05-12 04:20:54 | Franklin, Arkansas, US | |
3535946 | 3535946 | 2022-05-10 | US | Arkansas | Franklin | 5047 | 3817 | 73 | 0 | 35.51202821 | -93.89299569 | 2022-05-11 04:20:48 | Franklin, Arkansas, US | |
2333595 | 2333595 | 2022-05-08 | US | New Mexico | Socorro | 35053 | 3817 | 88 | 0 | 34.00715494 | -106.9298354 | 2022-05-09 04:20:54 | Socorro, New Mexico, US | |
362557 | 362557 | 2022-05-07 | US | New Mexico | Socorro | 35053 | 3817 | 88 | 0 | 34.00715494 | -106.9298354 | 2022-05-08 04:20:49 | Socorro, New Mexico, US | |
1399908 | 1399908 | 2022-05-06 | US | New Mexico | Socorro | 35053 | 3817 | 88 | 0 | 34.00715494 | -106.9298354 | 2022-05-07 04:21:09 | Socorro, New Mexico, US | |
1326612 | 1326612 | 2022-04-26 | US | Alabama | Crenshaw | 1041 | 3817 | 99 | 0 | 31.72941803 | -86.31593104 | 2022-04-27 04:20:52 | Crenshaw, Alabama, US | |
2309222 | 2309222 | 2022-04-20 | US | Missouri | Moniteau | 29135 | 3817 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-21 04:20:46 | Moniteau, Missouri, US | |
2253361 | 2253361 | 2022-04-19 | US | Missouri | Moniteau | 29135 | 3817 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-20 04:20:45 | Moniteau, Missouri, US | |
1847911 | 1847911 | 2022-04-18 | US | Missouri | Moniteau | 29135 | 3817 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-19 04:21:00 | Moniteau, Missouri, US | |
3418855 | 3418855 | 2022-04-17 | US | Missouri | Moniteau | 29135 | 3817 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-18 04:21:12 | Moniteau, Missouri, US | |
305804 | 305804 | 2022-04-16 | US | Missouri | Moniteau | 29135 | 3817 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-17 04:20:59 | Moniteau, Missouri, US | |
2671749 | 2671749 | 2022-04-15 | US | Missouri | Moniteau | 29135 | 3817 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-16 04:20:48 | Moniteau, Missouri, US | |
1225534 | 1225534 | 2022-04-14 | US | Missouri | Moniteau | 29135 | 3817 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-15 04:20:57 | Moniteau, Missouri, US | |
1655187 | 1655187 | 2022-04-09 | US | Puerto Rico | Yauco | 72153 | 3817 | 0 | 0 | 18.080374 | -66.858814 | 2022-04-10 04:20:52 | Yauco, Puerto Rico, US | |
2118509 | 2118509 | 2022-04-08 | US | Puerto Rico | Yauco | 72153 | 3817 | 0 | 0 | 18.080374 | -66.858814 | 2022-04-09 04:20:42 | Yauco, Puerto Rico, US | |
3730678 | 3730678 | 2022-04-03 | US | American Samoa | 60 | 3817 | 4 | 0 | -14.270999999999999 | -170.132 | 2022-04-04 04:20:51 | American Samoa, US | ||
500113 | 500113 | 2022-04-02 | US | American Samoa | 60 | 3817 | 4 | 0 | -14.270999999999999 | -170.132 | 2022-04-03 04:20:48 | American Samoa, US | ||
3351098 | 3351098 | 2022-04-01 | US | American Samoa | 60 | 3817 | 4 | 0 | -14.270999999999999 | -170.132 | 2022-04-02 04:20:47 | American Samoa, US | ||
921668 | 921668 | 2022-03-08 | US | Missouri | Wright | 29229 | 3817 | 79 | 0 | 37.27029221 | -92.46914488 | 2022-03-09 04:20:59 | Wright, Missouri, US | |
2734046 | 2734046 | 2022-02-27 | US | Illinois | Massac | 17127 | 3817 | 65 | 0 | 37.22078441 | -88.71036614 | 2022-02-28 04:21:05 | Massac, Illinois, US | |
3047199 | 3047199 | 2022-02-26 | US | Illinois | Massac | 17127 | 3817 | 65 | 0 | 37.22078441 | -88.71036614 | 2022-02-27 04:21:04 | Massac, Illinois, US | |
575854 | 575854 | 2022-02-25 | US | Illinois | Massac | 17127 | 3817 | 65 | 0 | 37.22078441 | -88.71036614 | 2022-02-26 04:21:12 | Massac, Illinois, US | |
3823702 | 3823702 | 2022-02-16 | US | Texas | Young | 48503 | 3817 | 82 | 0 | 33.17659707 | -98.68790885 | 2022-02-17 04:20:56 | Young, Texas, US | |
3075610 | 3075610 | 2022-02-09 | US | Maine | Sagadahoc | 23023 | 3817 | 25 | 0 | 43.95415864 | -69.85074999 | 2022-02-10 04:21:14 | Sagadahoc, Maine, US | |
1365623 | 1365623 | 2022-02-08 | US | Utah | San Juan | 49037 | 3817 | 47 | 0 | 37.62762978 | -109.80337140000002 | 2022-02-09 04:21:04 | San Juan, Utah, US | |
2016317 | 2016317 | 2022-02-06 | US | Wyoming | Lincoln | 56023 | 3817 | 28 | 0 | 42.26376367 | -110.6563997 | 2022-02-07 04:21:05 | Lincoln, Wyoming, US | |
1297646 | 1297646 | 2022-02-05 | US | Wyoming | Lincoln | 56023 | 3817 | 28 | 0 | 42.26376367 | -110.6563997 | 2022-02-06 04:21:00 | Lincoln, Wyoming, US | |
2330974 | 2330974 | 2022-02-04 | US | Wyoming | Lincoln | 56023 | 3817 | 28 | 0 | 42.26376367 | -110.6563997 | 2022-02-05 04:21:05 | Lincoln, Wyoming, US | |
460139 | 460139 | 2022-02-02 | US | Georgia | Brantley | 13025 | 3817 | 96 | 0 | 31.19576557 | -81.97743999 | 2022-02-03 04:21:21 | Brantley, Georgia, US | |
3428419 | 3428419 | 2022-01-21 | US | West Virginia | Barbour | 54001 | 3817 | 58 | 0 | 39.1307219 | -80.00350858 | 2022-01-22 04:21:13 | Barbour, West Virginia, US | |
1961629 | 1961629 | 2022-01-20 | US | Indiana | Carroll | 18015 | 3817 | 49 | 0 | 40.580783200000006 | -86.56198812 | 2022-01-21 04:21:09 | Carroll, Indiana, US | |
1475117 | 1475117 | 2022-01-17 | US | Tennessee | Unicoi | 47171 | 3817 | 82 | 0 | 36.10890856 | -82.43709629 | 2022-01-18 04:21:04 | Unicoi, Tennessee, US | |
1474091 | 1474091 | 2022-01-17 | US | Missouri | Texas | 29215 | 3817 | 76 | 0 | 37.31728859 | -91.96564727 | 2022-01-18 04:21:04 | Texas, Missouri, US | |
1472606 | 1472606 | 2022-01-17 | US | Arkansas | Hempstead | 5057 | 3817 | 51 | 0 | 33.73325583 | -93.66935133 | 2022-01-18 04:21:04 | Hempstead, Arkansas, US | |
558316 | 558316 | 2022-01-16 | US | Wisconsin | Adams | 55001 | 3817 | 44 | 0 | 43.96974651 | -89.76782777 | 2022-01-17 04:21:08 | Adams, Wisconsin, US | |
556765 | 556765 | 2022-01-16 | US | Missouri | Texas | 29215 | 3817 | 76 | 0 | 37.31728859 | -91.96564727 | 2022-01-17 04:21:08 | Texas, Missouri, US | |
3844037 | 3844037 | 2022-01-15 | US | Wisconsin | Adams | 55001 | 3817 | 44 | 0 | 43.96974651 | -89.76782777 | 2022-01-16 04:21:12 | Adams, Wisconsin, US | |
3842486 | 3842486 | 2022-01-15 | US | Missouri | Texas | 29215 | 3817 | 76 | 0 | 37.31728859 | -91.96564727 | 2022-01-16 04:21:12 | Texas, Missouri, US | |
3840541 | 3840541 | 2022-01-15 | Japan | Yamagata | 3817 | 56 | 0 | 38.448396 | 140.102154 | 2022-01-16 04:21:12 | Yamagata, Japan | |||
102852 | 102852 | 2022-01-14 | US | Wisconsin | Adams | 55001 | 3817 | 44 | 0 | 43.96974651 | -89.76782777 | 2022-01-15 04:21:07 | Adams, Wisconsin, US | |
3690686 | 3690686 | 2022-01-13 | US | Texas | Reeves | 48389 | 3817 | 64 | 0 | 31.32323325 | -103.69038959999999 | 2022-01-14 04:21:54 | Reeves, Texas, US | |
3615004 | 3615004 | 2022-01-12 | US | Missouri | New Madrid | 29143 | 3817 | 72 | 0 | 36.59666326 | -89.66070007 | 2022-01-13 08:00:09 | New Madrid, Missouri, US | |
1695455 | 1695455 | 2022-01-10 | US | Texas | Jones | 48253 | 3817 | 81 | 0 | 32.73997145 | -99.87861576 | 2022-01-11 04:22:01 | Jones, Texas, US | |
2904855 | 2904855 | 2021-12-19 | US | Indiana | Starke | 18149 | 3817 | 76 | 0 | 41.27890281 | -86.64686895 | 2021-12-20 04:21:43 | Starke, Indiana, US | |
1259928 | 1259928 | 2021-12-18 | US | Indiana | Starke | 18149 | 3817 | 76 | 0 | 41.27890281 | -86.64686895 | 2021-12-19 04:21:11 | Starke, Indiana, US | |
2399956 | 2399956 | 2021-12-17 | US | Indiana | Starke | 18149 | 3817 | 76 | 0 | 41.27890281 | -86.64686895 | 2021-12-18 02:22:20 | Starke, Indiana, US | |
1717709 | 1717709 | 2021-12-16 | US | Kansas | Sumner | 20191 | 3817 | 62 | 0 | 37.23682549 | -97.47721621 | 2021-12-17 04:22:14 | Sumner, Kansas, US | |
3497543 | 3497543 | 2021-12-15 | US | Kansas | Sumner | 20191 | 3817 | 62 | 0 | 37.23682549 | -97.47721621 | 2021-12-16 04:22:11 | Sumner, Kansas, US | |
3497170 | 3497170 | 2021-12-15 | US | Illinois | Douglas | 17041 | 3817 | 38 | 0 | 39.76768052 | -88.21854195 | 2021-12-16 04:22:11 | Douglas, Illinois, US | |
1079856 | 1079856 | 2021-12-09 | US | Missouri | McDonald | 29119 | 3817 | 56 | 0 | 36.62869595 | -94.34867205 | 2021-12-10 04:22:28 | McDonald, Missouri, US | |
552188 | 552188 | 2021-12-08 | US | Kentucky | Hart | 21099 | 3817 | 76 | 0 | 37.29943898 | -85.88461055 | 2021-12-09 04:22:49 | Hart, Kentucky, US | |
1233484 | 1233484 | 2021-11-28 | US | Mississippi | Tishomingo | 28141 | 3817 | 93 | 0 | 34.74023475 | -88.23917219 | 2021-11-29 04:22:30 | Tishomingo, Mississippi, US | |
1360191 | 1360191 | 2021-11-27 | US | Mississippi | Tishomingo | 28141 | 3817 | 93 | 0 | 34.74023475 | -88.23917219 | 2021-11-28 04:22:43 | Tishomingo, Mississippi, US | |
760182 | 760182 | 2021-11-26 | US | Mississippi | Tishomingo | 28141 | 3817 | 93 | 0 | 34.74023475 | -88.23917219 | 2021-11-27 04:22:45 | Tishomingo, Mississippi, US | |
1804599 | 1804599 | 2021-11-25 | US | Mississippi | Tishomingo | 28141 | 3817 | 93 | 0 | 34.74023475 | -88.23917219 | 2021-11-26 04:22:33 | Tishomingo, Mississippi, US | |
906033 | 906033 | 2021-11-24 | US | Mississippi | Tishomingo | 28141 | 3817 | 93 | 0 | 34.74023475 | -88.23917219 | 2021-11-25 04:22:33 | Tishomingo, Mississippi, US | |
162681 | 162681 | 2021-11-19 | US | Colorado | Routt | 8107 | 3817 | 24 | 0 | 40.48596505 | -106.9905548 | 2021-11-20 04:22:17 | Routt, Colorado, US | |
3345580 | 3345580 | 2021-11-16 | US | Tennessee | Johnson | 47091 | 3817 | 52 | 0 | 36.45523950000001 | -81.84886538 | 2021-11-17 04:21:48 | Johnson, Tennessee, US | |
2001769 | 2001769 | 2021-11-07 | US | Indiana | LaGrange | 18087 | 3817 | 86 | 0 | 41.64232188 | -85.42674232 | 2021-11-08 04:21:43 | LaGrange, Indiana, US | |
700100 | 700100 | 2021-11-04 | US | Michigan | Wexford | 26165 | 3817 | 55 | 0 | 44.33853602 | -85.57712739 | 2021-11-05 04:21:54 | Wexford, Michigan, US | |
277878 | 277878 | 2021-11-03 | US | Michigan | Wexford | 26165 | 3817 | 55 | 0 | 44.33853602 | -85.57712739 | 2021-11-04 04:22:20 | Wexford, Michigan, US | |
290946 | 290946 | 2021-10-31 | US | Tennessee | Haywood | 47075 | 3817 | 76 | 0 | 35.58332824 | -89.28536625 | 2021-11-01 04:22:01 | Haywood, Tennessee, 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]);