johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
336 rows where confirmed = 1823 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
431992 | 431992 | 2022-11-03 | US | Colorado | Kit Carson | 8063 | 1823 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-11-04 04:22:11 | Kit Carson, Colorado, US | |
711813 | 711813 | 2022-11-01 | US | Kansas | Wabaunsee | 20197 | 1823 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-11-02 04:22:09 | Wabaunsee, Kansas, US | |
3286262 | 3286262 | 2022-10-31 | US | Kansas | Wabaunsee | 20197 | 1823 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-11-01 04:22:36 | Wabaunsee, Kansas, US | |
321295 | 321295 | 2022-10-30 | US | Kansas | Wabaunsee | 20197 | 1823 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-10-31 04:21:36 | Wabaunsee, Kansas, US | |
913571 | 913571 | 2022-10-29 | US | Kansas | Wabaunsee | 20197 | 1823 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-10-30 04:22:14 | Wabaunsee, Kansas, US | |
1367840 | 1367840 | 2022-10-28 | US | Kansas | Wabaunsee | 20197 | 1823 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-10-29 04:21:13 | Wabaunsee, Kansas, US | |
1367073 | 1367073 | 2022-10-28 | US | California | Trinity | 6105 | 1823 | 20 | 0 | 40.6491767 | -123.114713 | 2022-10-29 04:21:13 | Trinity, California, US | |
3039695 | 3039695 | 2022-10-27 | US | Kansas | Wabaunsee | 20197 | 1823 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-10-28 04:22:31 | Wabaunsee, Kansas, US | |
540115 | 540115 | 2022-10-26 | US | Kansas | Wabaunsee | 20197 | 1823 | 24 | 0 | 38.95471985 | -96.20350509 | 2022-10-27 04:22:01 | Wabaunsee, Kansas, US | |
2263225 | 2263225 | 2022-10-02 | US | Washington | San Juan | 53055 | 1823 | 2 | 0 | 48.60182783 | -122.96745 | 2022-10-03 04:23:11 | San Juan, Washington, US | |
2998751 | 2998751 | 2022-10-01 | US | Washington | San Juan | 53055 | 1823 | 2 | 0 | 48.60182783 | -122.96745 | 2022-10-02 04:21:23 | San Juan, Washington, US | |
857077 | 857077 | 2022-09-30 | US | Washington | San Juan | 53055 | 1823 | 2 | 0 | 48.60182783 | -122.96745 | 2022-10-01 04:23:01 | San Juan, Washington, US | |
3650750 | 3650750 | 2022-08-14 | US | Texas | Marion | 48315 | 1823 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-08-15 04:20:59 | Marion, Texas, US | |
1971756 | 1971756 | 2022-08-13 | US | Texas | Marion | 48315 | 1823 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-08-14 04:20:55 | Marion, Texas, US | |
2891565 | 2891565 | 2022-08-12 | US | Texas | Marion | 48315 | 1823 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-08-13 04:20:52 | Marion, Texas, US | |
3909978 | 3909978 | 2022-08-11 | US | Missouri | Sullivan | 29211 | 1823 | 24 | 0 | 40.2099105 | -93.11150106 | 2022-08-12 04:20:54 | Sullivan, Missouri, US | |
1348295 | 1348295 | 2022-08-10 | US | Missouri | Sullivan | 29211 | 1823 | 24 | 0 | 40.2099105 | -93.11150106 | 2022-08-11 04:20:49 | Sullivan, Missouri, US | |
1088050 | 1088050 | 2022-08-09 | US | Missouri | Sullivan | 29211 | 1823 | 24 | 0 | 40.2099105 | -93.11150106 | 2022-08-10 04:20:57 | Sullivan, Missouri, US | |
3545465 | 3545465 | 2022-08-08 | US | Missouri | Sullivan | 29211 | 1823 | 24 | 0 | 40.2099105 | -93.11150106 | 2022-08-09 04:20:34 | Sullivan, Missouri, US | |
1071868 | 1071868 | 2022-08-07 | US | Missouri | Sullivan | 29211 | 1823 | 24 | 0 | 40.2099105 | -93.11150106 | 2022-08-08 04:21:08 | Sullivan, Missouri, US | |
1942456 | 1942456 | 2022-08-06 | US | Missouri | Sullivan | 29211 | 1823 | 24 | 0 | 40.2099105 | -93.11150106 | 2022-08-07 04:20:54 | Sullivan, Missouri, US | |
882255 | 882255 | 2022-08-05 | US | Missouri | Sullivan | 29211 | 1823 | 24 | 0 | 40.2099105 | -93.11150106 | 2022-08-06 04:20:56 | Sullivan, Missouri, US | |
2010572 | 2010572 | 2022-08-04 | US | Missouri | Caldwell | 29025 | 1823 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-05 04:20:52 | Caldwell, Missouri, US | |
1099999 | 1099999 | 2022-08-03 | US | Missouri | Caldwell | 29025 | 1823 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-04 04:20:58 | Caldwell, Missouri, US | |
1406924 | 1406924 | 2022-08-02 | US | Missouri | Caldwell | 29025 | 1823 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-03 04:20:59 | Caldwell, Missouri, US | |
3618962 | 3618962 | 2022-08-01 | US | Missouri | Caldwell | 29025 | 1823 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-02 04:20:53 | Caldwell, Missouri, US | |
3873442 | 3873442 | 2022-07-31 | US | Missouri | Caldwell | 29025 | 1823 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-08-01 04:21:03 | Caldwell, Missouri, US | |
676196 | 676196 | 2022-07-30 | US | Missouri | Caldwell | 29025 | 1823 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-31 04:21:02 | Caldwell, Missouri, US | |
1785395 | 1785395 | 2022-07-29 | US | Missouri | Caldwell | 29025 | 1823 | 39 | 0 | 39.65620858 | -93.98308093 | 2022-07-30 04:20:42 | Caldwell, Missouri, US | |
959935 | 959935 | 2022-07-19 | US | Illinois | Pulaski | 17153 | 1823 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-07-20 04:20:59 | Pulaski, Illinois, US | |
3211322 | 3211322 | 2022-07-18 | US | Illinois | Pulaski | 17153 | 1823 | 21 | 0 | 37.22631423 | -89.13085001 | 2022-07-19 04:20:58 | Pulaski, Illinois, US | |
2790020 | 2790020 | 2022-07-10 | US | Illinois | Edwards | 17047 | 1823 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-07-11 04:20:46 | Edwards, Illinois, US | |
142973 | 142973 | 2022-07-09 | US | Illinois | Edwards | 17047 | 1823 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-07-10 04:20:54 | Edwards, Illinois, US | |
1418073 | 1418073 | 2022-07-08 | US | Illinois | Edwards | 17047 | 1823 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-07-09 04:20:59 | Edwards, Illinois, US | |
942025 | 942025 | 2022-06-25 | US | Texas | Refugio | 48391 | 1823 | 37 | 0 | 28.3238976 | -97.15766311 | 2022-06-26 04:21:02 | Refugio, Texas, US | |
3349845 | 3349845 | 2022-06-24 | US | Texas | Refugio | 48391 | 1823 | 37 | 0 | 28.3238976 | -97.15766311 | 2022-06-25 04:20:57 | Refugio, Texas, US | |
2189347 | 2189347 | 2022-06-22 | US | Minnesota | Lac qui Parle | 27073 | 1823 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-06-23 04:20:55 | Lac qui Parle, Minnesota, US | |
3272498 | 3272498 | 2022-06-19 | US | Tennessee | Pickett | 47137 | 1823 | 36 | 0 | 36.55606529 | -85.077633 | 2022-06-20 04:21:01 | Pickett, Tennessee, US | |
1424412 | 1424412 | 2022-06-08 | US | Virginia | Bland | 51021 | 1823 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-06-09 04:20:54 | Bland, Virginia, US | |
2049607 | 2049607 | 2022-05-25 | US | Minnesota | Mahnomen | 27087 | 1823 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-05-26 04:20:50 | Mahnomen, Minnesota, US | |
3001045 | 3001045 | 2022-05-24 | US | Minnesota | Mahnomen | 27087 | 1823 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-05-25 04:20:56 | Mahnomen, Minnesota, US | |
623618 | 623618 | 2022-05-22 | US | Minnesota | Mahnomen | 27087 | 1823 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-05-26 04:20:50 | Mahnomen, Minnesota, US | |
1112647 | 1112647 | 2022-05-21 | US | Texas | Delta | 48119 | 1823 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-05-22 04:20:52 | Delta, Texas, US | |
1172271 | 1172271 | 2022-05-20 | US | Texas | Delta | 48119 | 1823 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-05-21 04:20:58 | Delta, Texas, US | |
466760 | 466760 | 2022-05-02 | US | Virginia | Lancaster | 51103 | 1823 | 31 | 0 | 37.71889653 | -76.46400482 | 2022-05-03 04:21:00 | Lancaster, Virginia, US | |
160144 | 160144 | 2022-03-29 | US | Nebraska | Wayne | 31179 | 1823 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-03-30 04:20:45 | Wayne, Nebraska, US | |
1659154 | 1659154 | 2022-03-19 | US | Puerto Rico | Guayanilla | 72059 | 1823 | 0 | 0 | 18.039942 | -66.79186 | 2022-03-20 04:20:45 | Guayanilla, Puerto Rico, US | |
921816 | 921816 | 2022-03-08 | US | Nebraska | Wayne | 31179 | 1823 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-03-09 04:20:59 | Wayne, Nebraska, US | |
921594 | 921594 | 2022-03-08 | US | Missouri | Hickory | 29085 | 1823 | 55 | 0 | 37.94163617 | -93.3203037 | 2022-03-09 04:20:59 | Hickory, Missouri, US | |
946034 | 946034 | 2022-02-28 | US | Texas | Rains | 48379 | 1823 | 56 | 0 | 32.87109387 | -95.79232691 | 2022-03-01 04:21:09 | Rains, Texas, US | |
2736225 | 2736225 | 2022-02-27 | US | Texas | Rains | 48379 | 1823 | 56 | 0 | 32.87109387 | -95.79232691 | 2022-02-28 04:21:05 | Rains, Texas, US | |
3049378 | 3049378 | 2022-02-26 | US | Texas | Rains | 48379 | 1823 | 56 | 0 | 32.87109387 | -95.79232691 | 2022-02-27 04:21:04 | Rains, Texas, US | |
1514159 | 1514159 | 2022-02-24 | US | Puerto Rico | Jayuya | 72073 | 1823 | 0 | 0 | 18.211446 | -66.58878 | 2022-02-25 04:21:11 | Jayuya, Puerto Rico, US | |
3915084 | 3915084 | 2022-02-20 | US | Texas | Crosby | 48107 | 1823 | 45 | 0 | 33.61431553 | -101.30003640000001 | 2022-02-21 04:21:05 | Crosby, Texas, US | |
3878642 | 3878642 | 2022-02-19 | US | Texas | Crosby | 48107 | 1823 | 45 | 0 | 33.61431553 | -101.30003640000001 | 2022-02-20 04:21:00 | Crosby, Texas, US | |
2014509 | 2014509 | 2022-02-06 | US | Mississippi | Franklin | 28037 | 1823 | 35 | 0 | 31.47786634 | -90.89672989 | 2022-02-07 04:21:05 | Franklin, Mississippi, US | |
1295838 | 1295838 | 2022-02-05 | US | Mississippi | Franklin | 28037 | 1823 | 35 | 0 | 31.47786634 | -90.89672989 | 2022-02-06 04:21:00 | Franklin, Mississippi, US | |
2329166 | 2329166 | 2022-02-04 | US | Mississippi | Franklin | 28037 | 1823 | 35 | 0 | 31.47786634 | -90.89672989 | 2022-02-05 04:21:05 | Franklin, Mississippi, US | |
3301941 | 3301941 | 2022-01-30 | US | Minnesota | Lake | 27075 | 1823 | 26 | 0 | 47.64270764 | -91.44557998 | 2022-01-31 04:21:09 | Lake, Minnesota, US | |
3063732 | 3063732 | 2022-01-29 | US | Minnesota | Lake | 27075 | 1823 | 26 | 0 | 47.64270764 | -91.44557998 | 2022-01-30 04:21:26 | Lake, Minnesota, US | |
3811666 | 3811666 | 2022-01-28 | US | Minnesota | Lake | 27075 | 1823 | 26 | 0 | 47.64270764 | -91.44557998 | 2022-01-29 04:21:10 | Lake, Minnesota, US | |
1321444 | 1321444 | 2022-01-26 | US | Texas | Swisher | 48437 | 1823 | 30 | 0 | 34.53028891 | -101.73491740000001 | 2022-01-27 04:21:19 | Swisher, Texas, US | |
1318847 | 1318847 | 2022-01-26 | US | Colorado | Lake | 8065 | 1823 | 2 | 0 | 39.20278823 | -106.35556969999999 | 2022-01-27 04:21:19 | Lake, Colorado, US | |
2055112 | 2055112 | 2022-01-25 | US | Texas | Swisher | 48437 | 1823 | 30 | 0 | 34.53028891 | -101.73491740000001 | 2022-01-26 04:21:07 | Swisher, Texas, US | |
1230843 | 1230843 | 2022-01-24 | US | Texas | Swisher | 48437 | 1823 | 30 | 0 | 34.53028891 | -101.73491740000001 | 2022-01-25 04:21:05 | Swisher, Texas, US | |
1143248 | 1143248 | 2022-01-23 | US | North Carolina | Jones | 37103 | 1823 | 38 | 0 | 35.02254606 | -77.35870791 | 2022-01-24 04:21:12 | Jones, North Carolina, US | |
1142974 | 1142974 | 2022-01-23 | US | Nebraska | Custer | 31041 | 1823 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-01-24 04:21:12 | Custer, Nebraska, US | |
2835166 | 2835166 | 2022-01-22 | US | North Carolina | Jones | 37103 | 1823 | 38 | 0 | 35.02254606 | -77.35870791 | 2022-01-23 04:21:13 | Jones, North Carolina, US | |
2834892 | 2834892 | 2022-01-22 | US | Nebraska | Custer | 31041 | 1823 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-01-23 04:21:13 | Custer, Nebraska, US | |
3427284 | 3427284 | 2022-01-21 | US | North Carolina | Jones | 37103 | 1823 | 38 | 0 | 35.02254606 | -77.35870791 | 2022-01-22 04:21:13 | Jones, North Carolina, US | |
3427010 | 3427010 | 2022-01-21 | US | Nebraska | Custer | 31041 | 1823 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-01-22 04:21:13 | Custer, Nebraska, US | |
3228270 | 3228270 | 2022-01-19 | US | Mississippi | Kemper | 28069 | 1823 | 42 | 0 | 32.75462946 | -88.64105766 | 2022-01-20 04:21:07 | Kemper, Mississippi, US | |
1116635 | 1116635 | 2022-01-11 | US | Texas | Castro | 48069 | 1823 | 43 | 0 | 34.53016752 | -102.2617243 | 2022-01-12 04:21:44 | Castro, Texas, US | |
1115473 | 1115473 | 2022-01-11 | US | Missouri | Carroll | 29033 | 1823 | 39 | 0 | 39.42762566 | -93.50626255 | 2022-01-12 04:21:44 | Carroll, Missouri, US | |
1285820 | 1285820 | 2022-01-04 | China | Yunnan | 1823 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-05 04:21:59 | Yunnan, China | |||
1700164 | 1700164 | 2022-01-03 | China | Yunnan | 1823 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-04 04:22:17 | Yunnan, China | |||
3521785 | 3521785 | 2022-01-02 | US | North Carolina | Pamlico | 37137 | 1823 | 26 | 0 | 35.15253315 | -76.66559823 | 2022-01-03 02:22:25 | Pamlico, North Carolina, US | |
2169915 | 2169915 | 2022-01-01 | US | North Carolina | Pamlico | 37137 | 1823 | 26 | 0 | 35.15253315 | -76.66559823 | 2022-01-02 04:20:52 | Pamlico, North Carolina, US | |
2779346 | 2779346 | 2021-12-31 | US | North Carolina | Pamlico | 37137 | 1823 | 26 | 0 | 35.15253315 | -76.66559823 | 2022-01-01 04:22:14 | Pamlico, North Carolina, US | |
4001003 | 4001003 | 2021-12-30 | US | North Carolina | Pamlico | 37137 | 1823 | 26 | 0 | 35.15253315 | -76.66559823 | 2021-12-31 04:21:50 | Pamlico, North Carolina, US | |
1434383 | 1434383 | 2021-12-28 | US | Mississippi | Jefferson Davis | 28065 | 1823 | 43 | 0 | 31.56884708 | -89.82670990000004 | 2021-12-29 03:21:43 | Jefferson Davis, Mississippi, US | |
733378 | 733378 | 2021-12-27 | US | South Dakota | Bon Homme | 46009 | 1823 | 31 | 0 | 42.98914167 | -97.88592746 | 2021-12-28 04:21:47 | Bon Homme, South Dakota, US | |
732299 | 732299 | 2021-12-27 | US | Minnesota | Swift | 27151 | 1823 | 29 | 0 | 45.2829032 | -95.68264092 | 2021-12-28 04:21:47 | Swift, Minnesota, US | |
731484 | 731484 | 2021-12-27 | US | Idaho | Teton | 16081 | 1823 | 8 | 0 | 43.75303583 | -111.2056773 | 2021-12-28 04:21:47 | Teton, Idaho, US | |
1719026 | 1719026 | 2021-12-16 | US | Pennsylvania | Forest | 42053 | 1823 | 31 | 0 | 41.51095103 | -79.23229292 | 2021-12-17 04:22:14 | Forest, Pennsylvania, US | |
1718261 | 1718261 | 2021-12-16 | US | Missouri | Grundy | 29079 | 1823 | 56 | 0 | 40.11406587 | -93.56509276 | 2021-12-17 04:22:14 | Grundy, Missouri, US | |
3496004 | 3496004 | 2021-12-15 | China | Zhejiang | 1823 | 1 | 0 | 29.1832 | 120.0934 | 2021-12-16 04:22:11 | Zhejiang, China | |||
1743445 | 1743445 | 2021-12-05 | US | South Dakota | Todd | 46121 | 1823 | 38 | 0 | 43.19338568 | -100.71955030000001 | 2021-12-06 04:22:34 | Todd, South Dakota, US | |
140877 | 140877 | 2021-12-04 | US | South Dakota | Todd | 46121 | 1823 | 38 | 0 | 43.19338568 | -100.71955030000001 | 2021-12-05 04:22:25 | Todd, South Dakota, US | |
2198530 | 2198530 | 2021-12-03 | US | South Dakota | Todd | 46121 | 1823 | 38 | 0 | 43.19338568 | -100.71955030000001 | 2021-12-04 04:22:18 | Todd, South Dakota, US | |
1017955 | 1017955 | 2021-11-21 | US | Wyoming | Washakie | 56043 | 1823 | 35 | 0 | 43.90451606 | -107.68018700000002 | 2021-11-22 04:22:20 | Washakie, Wyoming, US | |
726119 | 726119 | 2021-11-20 | US | Wyoming | Washakie | 56043 | 1823 | 35 | 0 | 43.90451606 | -107.68018700000002 | 2021-11-21 04:22:13 | Washakie, Wyoming, US | |
165649 | 165649 | 2021-11-19 | US | Wyoming | Washakie | 56043 | 1823 | 35 | 0 | 43.90451606 | -107.68018700000002 | 2021-11-20 04:22:17 | Washakie, Wyoming, US | |
688640 | 688640 | 2021-11-13 | US | New York | Yates | 36123 | 1823 | 30 | 0 | 42.63505484 | -77.10369919 | 2021-11-14 04:21:31 | Yates, New York, US | |
279637 | 279637 | 2021-11-03 | US | Washington | Pacific | 53049 | 1823 | 33 | 0 | 46.55418369 | -123.7285716 | 2021-11-04 04:22:20 | Pacific, Washington, US | |
47162 | 47162 | 2021-11-02 | US | Washington | Pacific | 53049 | 1823 | 33 | 0 | 46.55418369 | -123.7285716 | 2021-11-03 06:22:09 | Pacific, Washington, US | |
3795462 | 3795462 | 2021-10-25 | US | Maine | Washington | 23029 | 1823 | 20 | 0 | 45.01607142 | -67.62813524 | 2021-10-26 04:22:09 | Washington, Maine, US | |
683908 | 683908 | 2021-10-24 | US | Maine | Washington | 23029 | 1823 | 20 | 0 | 45.01607142 | -67.62813524 | 2021-10-25 04:22:31 | Washington, Maine, US | |
771916 | 771916 | 2021-10-23 | US | Maine | Washington | 23029 | 1823 | 20 | 0 | 45.01607142 | -67.62813524 | 2021-10-24 04:21:22 | Washington, Maine, US | |
2045775 | 2045775 | 2021-10-18 | US | Missouri | Linn | 29115 | 1823 | 26 | 0 | 39.87001769 | -93.10704106 | 2021-10-19 04:20:54 | Linn, 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]);