daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
188 rows where confirmed = 4326 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-17 | US | Tennessee | Decatur | 47039 | 4326 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-18 04:21:03 | Decatur, Tennessee, US | |
2022-12-16 | US | Tennessee | Decatur | 47039 | 4326 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-17 04:21:04 | Decatur, Tennessee, US | |
2022-12-12 | US | Wisconsin | Lafayette | 55065 | 4326 | 30 | 0 | 42.66005229 | -90.1317729 | 2022-12-13 04:21:01 | Lafayette, Wisconsin, US | |
2022-11-01 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-11-02 04:22:09 | Young, Texas, US | |
2022-10-31 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-11-01 04:22:36 | Young, Texas, US | |
2022-10-30 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-10-31 04:21:36 | Young, Texas, US | |
2022-10-29 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-10-30 04:22:14 | Young, Texas, US | |
2022-10-28 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-10-29 04:21:13 | Young, Texas, US | |
2022-10-27 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-10-28 04:22:31 | Young, Texas, US | |
2022-10-26 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-10-27 04:22:01 | Young, Texas, US | |
2022-10-25 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-10-26 04:22:19 | Young, Texas, US | |
2022-10-24 | US | Texas | Young | 48503 | 4326 | 97 | 0 | 33.17659707 | -98.68790885 | 2022-10-25 04:21:53 | Young, Texas, US | |
2022-10-06 | US | Puerto Rico | Hormigueros | 72067 | 4326 | 0 | 0 | 18.134532 | -67.113972 | 2022-10-07 04:23:08 | Hormigueros, Puerto Rico, US | |
2022-09-26 | US | Michigan | Manistee | 26101 | 4326 | 97 | 0 | 44.33352407 | -86.05626916 | 2022-09-27 04:23:01 | Manistee, Michigan, US | |
2022-09-25 | US | Michigan | Manistee | 26101 | 4326 | 97 | 0 | 44.33352407 | -86.05626916 | 2022-09-26 04:20:52 | Manistee, Michigan, US | |
2022-09-24 | US | Michigan | Manistee | 26101 | 4326 | 97 | 0 | 44.33352407 | -86.05626916 | 2022-09-25 04:23:31 | Manistee, Michigan, US | |
2022-09-23 | US | Michigan | Manistee | 26101 | 4326 | 97 | 0 | 44.33352407 | -86.05626916 | 2022-09-24 04:21:40 | Manistee, Michigan, US | |
2022-09-22 | US | Michigan | Manistee | 26101 | 4326 | 97 | 0 | 44.33352407 | -86.05626916 | 2022-09-23 04:23:13 | Manistee, Michigan, US | |
2022-09-21 | US | Michigan | Manistee | 26101 | 4326 | 97 | 0 | 44.33352407 | -86.05626916 | 2022-09-22 04:22:56 | Manistee, Michigan, US | |
2022-09-20 | US | Michigan | Manistee | 26101 | 4326 | 97 | 0 | 44.33352407 | -86.05626916 | 2022-09-21 04:23:22 | Manistee, Michigan, US | |
2022-09-09 | US | Arkansas | Howard | 5061 | 4326 | 53 | 0 | 34.09007427 | -93.9934871 | 2022-09-10 04:21:10 | Howard, Arkansas, US | |
2022-09-06 | China | Sichuan | 4326 | 3 | 0 | 30.6171 | 102.7103 | 2022-09-07 04:20:59 | Sichuan, China | |||
2022-09-04 | US | Wisconsin | Marquette | 55077 | 4326 | 63 | 0 | 43.81911946 | -89.40073763 | 2022-09-05 04:21:01 | Marquette, Wisconsin, US | |
2022-09-03 | US | Wisconsin | Marquette | 55077 | 4326 | 63 | 0 | 43.81911946 | -89.40073763 | 2022-09-04 04:21:22 | Marquette, Wisconsin, US | |
2022-09-02 | US | Wisconsin | Marquette | 55077 | 4326 | 63 | 0 | 43.81911946 | -89.40073763 | 2022-09-03 04:21:04 | Marquette, Wisconsin, US | |
2022-08-08 | US | Virginia | Appomattox | 51011 | 4326 | 55 | 0 | 37.37569884 | -78.81340003 | 2022-08-09 04:20:34 | Appomattox, Virginia, US | |
2022-07-22 | US | Texas | Bosque | 48035 | 4326 | 70 | 0 | 31.89978581 | -97.63613524 | 2022-07-23 04:20:53 | Bosque, Texas, US | |
2022-07-13 | US | Puerto Rico | Adjuntas | 72001 | 4326 | 0 | 0 | 18.180117 | -66.754367 | 2022-07-14 04:20:57 | Adjuntas, Puerto Rico, US | |
2022-07-11 | US | Virginia | Giles | 51071 | 4326 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-07-12 04:20:51 | Giles, Virginia, US | |
2022-07-01 | US | Tennessee | Trousdale | 47169 | 4326 | 46 | 0 | 36.39026213 | -86.16087954 | 2022-07-02 04:21:16 | Trousdale, Tennessee, US | |
2022-06-18 | US | Puerto Rico | Orocovis | 72107 | 4326 | 0 | 0 | 18.215046 | -66.433604 | 2022-06-19 04:20:51 | Orocovis, Puerto Rico, US | |
2022-06-15 | US | Texas | Lee | 48287 | 4326 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-06-16 04:20:55 | Lee, Texas, US | |
2022-06-13 | US | Tennessee | Cannon | 47015 | 4326 | 67 | 0 | 35.80990797 | -86.05738983 | 2022-06-14 04:20:52 | Cannon, Tennessee, US | |
2022-05-21 | US | Illinois | Carroll | 17015 | 4326 | 48 | 0 | 42.06823429 | -89.93395545 | 2022-05-22 04:20:52 | Carroll, Illinois, US | |
2022-05-20 | US | Illinois | Carroll | 17015 | 4326 | 48 | 0 | 42.06823429 | -89.93395545 | 2022-05-21 04:20:58 | Carroll, Illinois, US | |
2022-04-12 | US | Illinois | De Witt | 17039 | 4326 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-04-13 04:21:03 | De Witt, Illinois, US | |
2022-04-07 | US | West Virginia | Wetzel | 54103 | 4326 | 83 | 0 | 39.6065771 | -80.64016540000001 | 2022-04-08 04:20:48 | Wetzel, West Virginia, US | |
2022-04-07 | US | Texas | Lamb | 48279 | 4326 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-04-08 04:20:48 | Lamb, Texas, US | |
2022-04-06 | US | Puerto Rico | Guayama | 72057 | 4326 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-04-07 04:20:53 | Guayama, Puerto Rico, US | |
2022-03-17 | US | Alaska | North Slope | 2185 | 4326 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-03-18 04:20:55 | North Slope, Alaska, US | |
2022-03-16 | US | Alaska | North Slope | 2185 | 4326 | 11 | 0 | 69.31479216 | -153.4836093 | 2022-03-17 04:20:56 | North Slope, Alaska, US | |
2022-02-27 | US | Illinois | Piatt | 17147 | 4326 | 21 | 0 | 40.01360584 | -88.59319339 | 2022-02-28 04:21:05 | Piatt, Illinois, US | |
2022-02-26 | US | Illinois | Piatt | 17147 | 4326 | 21 | 0 | 40.01360584 | -88.59319339 | 2022-02-27 04:21:04 | Piatt, Illinois, US | |
2022-02-25 | US | Illinois | Piatt | 17147 | 4326 | 21 | 0 | 40.01360584 | -88.59319339 | 2022-02-26 04:21:12 | Piatt, Illinois, US | |
2022-02-22 | US | West Virginia | Taylor | 54091 | 4326 | 62 | 0 | 39.33602617 | -80.0421439 | 2022-02-23 04:21:09 | Taylor, West Virginia, US | |
2022-02-16 | US | Indiana | Franklin | 18047 | 4326 | 53 | 0 | 39.4142482 | -85.06062647 | 2022-02-17 04:20:56 | Franklin, Indiana, US | |
2022-02-15 | US | Illinois | White | 17193 | 4326 | 43 | 0 | 38.08706198 | -88.17657461 | 2022-02-16 04:21:10 | White, Illinois, US | |
2022-01-23 | US | Colorado | Chaffee | 8015 | 4326 | 42 | 0 | 38.74745778 | -106.19265729999998 | 2022-01-24 04:21:12 | Chaffee, Colorado, US | |
2022-01-22 | US | Arkansas | Randolph | 5121 | 4326 | 70 | 0 | 36.3415714 | -91.02455531 | 2022-01-23 04:21:13 | Randolph, Arkansas, US | |
2022-01-19 | US | Illinois | Wayne | 17191 | 4326 | 70 | 0 | 38.42955355 | -88.42586459 | 2022-01-20 04:21:07 | Wayne, Illinois, US | |
2022-01-18 | US | Georgia | Jones | 13169 | 4326 | 100 | 0 | 33.02512137 | -83.56019163 | 2022-01-19 04:21:23 | Jones, Georgia, US | |
2022-01-16 | US | Wisconsin | Vilas | 55125 | 4326 | 78 | 0 | 46.05467334 | -89.51719204 | 2022-01-17 04:21:08 | Vilas, Wisconsin, US | |
2022-01-15 | US | Wisconsin | Vilas | 55125 | 4326 | 78 | 0 | 46.05467334 | -89.51719204 | 2022-01-16 04:21:12 | Vilas, Wisconsin, US | |
2022-01-14 | US | Wisconsin | Vilas | 55125 | 4326 | 78 | 0 | 46.05467334 | -89.51719204 | 2022-01-15 04:21:07 | Vilas, Wisconsin, US | |
2022-01-13 | US | Kansas | Cherokee | 20021 | 4326 | 79 | 0 | 37.16928494 | -94.8462897 | 2022-01-14 04:21:54 | Cherokee, Kansas, US | |
2022-01-12 | US | Puerto Rico | Corozal | 72047 | 4326 | 0 | 0 | 18.304264 | -66.327738 | 2022-01-13 08:00:09 | Corozal, Puerto Rico, US | |
2022-01-12 | US | Kansas | Cherokee | 20021 | 4326 | 79 | 0 | 37.16928494 | -94.8462897 | 2022-01-13 08:00:09 | Cherokee, Kansas, US | |
2022-01-11 | US | Kansas | Cherokee | 20021 | 4326 | 79 | 0 | 37.16928494 | -94.8462897 | 2022-01-12 04:21:44 | Cherokee, Kansas, US | |
2022-01-10 | US | Kansas | Cherokee | 20021 | 4326 | 79 | 0 | 37.16928494 | -94.8462897 | 2022-01-11 04:22:01 | Cherokee, Kansas, US | |
2022-01-02 | US | Kentucky | Allen | 21003 | 4326 | 82 | 0 | 36.75197631 | -86.19457544 | 2022-01-03 02:22:25 | Allen, Kentucky, US | |
2022-01-01 | US | Kentucky | Allen | 21003 | 4326 | 82 | 0 | 36.75197631 | -86.19457544 | 2022-01-02 04:20:52 | Allen, Kentucky, US | |
2021-12-31 | US | Kentucky | Allen | 21003 | 4326 | 82 | 0 | 36.75197631 | -86.19457544 | 2022-01-01 04:22:14 | Allen, Kentucky, US | |
2021-12-30 | US | Kentucky | Allen | 21003 | 4326 | 82 | 0 | 36.75197631 | -86.19457544 | 2021-12-31 04:21:50 | Allen, Kentucky, US | |
2021-12-29 | US | Kentucky | Allen | 21003 | 4326 | 82 | 0 | 36.75197631 | -86.19457544 | 2021-12-30 04:21:25 | Allen, Kentucky, US | |
2021-12-25 | US | Texas | Moore | 48341 | 4326 | 92 | 0 | 35.83769242 | -101.8930281 | 2021-12-26 04:21:50 | Moore, Texas, US | |
2021-12-24 | US | Texas | Moore | 48341 | 4326 | 92 | 0 | 35.83769242 | -101.8930281 | 2021-12-25 04:21:37 | Moore, Texas, US | |
2021-12-20 | US | Georgia | Monroe | 13207 | 4326 | 153 | 0 | 33.014289 | -83.92097166 | 2021-12-21 03:21:27 | Monroe, Georgia, US | |
2021-12-19 | US | Missouri | Stone | 29209 | 4326 | 100 | 0 | 36.75000327 | -93.45256475 | 2021-12-20 04:21:43 | Stone, Missouri, US | |
2021-12-18 | US | Missouri | Audrain | 29007 | 4326 | 81 | 0 | 39.215877 | -91.84242683 | 2021-12-19 04:21:11 | Audrain, Missouri, US | |
2021-12-17 | US | Tennessee | Smith | 47159 | 4326 | 55 | 0 | 36.25359775 | -85.95411046 | 2021-12-18 02:22:20 | Smith, Tennessee, US | |
2021-11-22 | US | Idaho | Elmore | 16039 | 4326 | 50 | 0 | 43.3507101 | -115.4701578 | 2021-11-23 04:22:39 | Elmore, Idaho, US | |
2021-11-09 | US | Georgia | Unassigned | 90013 | 4326 | 7 | 0 | 34.91369188 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Georgia, US | |
2021-11-03 | US | Minnesota | Todd | 27153 | 4326 | 37 | 0 | 46.06996226 | -94.89785296 | 2021-11-04 04:22:20 | Todd, Minnesota, US | |
2021-11-02 | US | Indiana | White | 18181 | 4326 | 65 | 0 | 40.74911165 | -86.86492015 | 2021-11-03 06:22:09 | White, Indiana, US | |
2021-10-30 | US | Missouri | Barry | 29009 | 4326 | 62 | 0 | 36.70978521 | -93.82919888 | 2021-10-31 04:22:08 | Barry, Missouri, US | |
2021-10-27 | US | Ohio | Fayette | 39047 | 4326 | 68 | 0 | 39.56021306 | -83.4562016 | 2021-10-28 04:22:08 | Fayette, Ohio, US | |
2021-10-26 | US | Virginia | Amherst | 51009 | 4326 | 57 | 0 | 37.60308293 | -79.14548696 | 2021-10-27 04:22:32 | Amherst, Virginia, US | |
2021-10-25 | US | Missouri | Dunklin | 29069 | 4326 | 61 | 0 | 36.27167174 | -90.09122243 | 2021-10-26 04:22:09 | Dunklin, Missouri, US | |
2021-10-16 | US | New York | Wyoming | 36121 | 4326 | 57 | 0 | 42.70145109 | -78.22199579 | 2021-10-17 04:21:29 | Wyoming, New York, US | |
2021-10-04 | US | Georgia | Emanuel | 13107 | 4326 | 107 | 0 | 32.59221302 | -82.30239915 | 2021-10-05 04:21:27 | Emanuel, Georgia, US | |
2021-10-01 | US | New York | Chenango | 36017 | 4326 | 86 | 0 | 42.49430041 | -75.60887553 | 2021-10-02 04:21:25 | Chenango, New York, US | |
2021-10-01 | US | Alabama | Winston | 1133 | 4326 | 98 | 0 | 34.15030532 | -87.37325922 | 2021-10-02 04:21:25 | Winston, Alabama, US | |
2021-09-26 | US | West Virginia | Greenbrier | 54025 | 4326 | 79 | 0 | 37.9463652 | -80.45335881 | 2021-09-27 04:21:16 | Greenbrier, West Virginia, US | |
2021-09-16 | US | New York | Tioga | 36107 | 4326 | 66 | 0 | 42.16852837 | -76.30835812 | 2021-09-17 04:21:46 | Tioga, New York, US | |
2021-09-12 | US | Mississippi | Leflore | 28083 | 4326 | 138 | 0 | 33.55545125 | -90.29900733 | 2021-09-13 04:21:15 | Leflore, Mississippi, US | |
2021-09-12 | US | Arkansas | Yell | 5149 | 4326 | 73 | 0 | 35.00292371 | -93.41171338 | 2021-09-13 04:21:15 | Yell, Arkansas, US | |
2021-09-11 | US | Mississippi | Leflore | 28083 | 4326 | 138 | 0 | 33.55545125 | -90.29900733 | 2021-09-12 04:21:13 | Leflore, Mississippi, US | |
2021-09-10 | US | Mississippi | Leflore | 28083 | 4326 | 138 | 0 | 33.55545125 | -90.29900733 | 2021-09-11 04:21:30 | Leflore, Mississippi, US | |
2021-09-04 | US | Arkansas | Poinsett | 5111 | 4326 | 92 | 0 | 35.57433534 | -90.66268713 | 2021-09-05 04:21:33 | Poinsett, Arkansas, US | |
2021-08-29 | US | North Carolina | Jackson | 37099 | 4326 | 58 | 0 | 35.28814273 | -83.14093385 | 2021-08-30 04:21:23 | Jackson, North Carolina, US | |
2021-08-29 | US | Colorado | Summit | 8117 | 4326 | 9 | 0 | 39.63803232 | -106.1150762 | 2021-08-30 04:21:23 | Summit, Colorado, US | |
2021-08-28 | US | North Carolina | Jackson | 37099 | 4326 | 58 | 0 | 35.28814273 | -83.14093385 | 2021-08-29 04:21:14 | Jackson, North Carolina, US | |
2021-08-27 | US | North Carolina | Jackson | 37099 | 4326 | 58 | 0 | 35.28814273 | -83.14093385 | 2021-08-28 04:21:28 | Jackson, North Carolina, US | |
2021-08-25 | US | Virginia | York | 51199 | 4326 | 60 | 0 | 37.24374789 | -76.54412815 | 2021-08-26 04:21:28 | York, Virginia, US | |
2021-08-22 | US | Michigan | Delta | 26041 | 4326 | 95 | 0 | 45.90484910000001 | -86.9080745 | 2021-08-23 04:21:27 | Delta, Michigan, US | |
2021-08-21 | US | Michigan | Delta | 26041 | 4326 | 95 | 0 | 45.90484910000001 | -86.9080745 | 2021-08-22 04:21:29 | Delta, Michigan, US | |
2021-08-20 | US | Michigan | Delta | 26041 | 4326 | 95 | 0 | 45.90484910000001 | -86.9080745 | 2021-08-21 04:21:38 | Delta, Michigan, US | |
2021-08-18 | US | Montana | Silver Bow | 30093 | 4326 | 88 | 0 | 45.90018933 | -112.6620092 | 2021-08-19 04:21:15 | Silver Bow, Montana, US | |
2021-08-14 | US | Texas | Howard | 48227 | 4326 | 104 | 0 | 32.30621324 | -101.4356444 | 2021-08-15 04:21:41 | Howard, Texas, US | |
2021-08-12 | US | South Dakota | Brookings | 46011 | 4326 | 37 | 0 | 44.36974375 | -96.79079945 | 2021-08-13 04:21:24 | Brookings, South Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;