daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
205 rows where active = 1186 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-04 | India | Haryana | 768903 | 9486 | 758231 | 1186 | 29.20004 | 76.332824 | 2021-07-05 04:21:28 | Haryana, India | ||
2021-06-29 | Russia | Khanty-Mansi Autonomous Okrug | 59763 | 809 | 57768 | 1186 | 61.0259025 | 69.0982628 | 2021-06-30 04:21:41 | Khanty-Mansi Autonomous Okrug, Russia | ||
2021-06-18 | Timor-Leste | 8602 | 19 | 7397 | 1186 | -8.874217 | 125.727539 | 2021-06-19 04:22:33 | Timor-Leste | |||
2021-06-01 | Russia | Ulyanovsk Oblast | 56022 | 1405 | 53431 | 1186 | 54.1463177 | 47.2324921 | 2021-06-02 04:24:34 | Ulyanovsk Oblast, Russia | ||
2021-05-30 | Pakistan | Azad Jammu and Kashmir | 19232 | 543 | 17503 | 1186 | 34.027401 | 73.947253 | 2021-05-31 03:08:59 | Azad Jammu and Kashmir, Pakistan | ||
2021-04-22 | Russia | Tyumen Oblast | 34741 | 449 | 33106 | 1186 | 58.8206488 | 70.36588370000001 | 2021-04-23 04:20:52 | Tyumen Oblast, Russia | ||
2021-04-17 | Chile | Tarapaca | 31784 | 582 | 30016 | 1186 | -19.9232 | -69.5132 | 2021-04-18 04:20:41 | Tarapaca, Chile | ||
2021-03-25 | Malaysia | W.P. Kuala Lumpur | 37439 | 116 | 36137 | 1186 | 3.139 | 101.6869 | 2021-03-26 05:26:55 | W.P. Kuala Lumpur, Malaysia | ||
2021-03-06 | US | Kansas | Ellsworth | 20053 | 1211 | 25 | 0 | 1186 | 38.69677695 | -98.20462799 | 2021-03-07 05:21:54 | Ellsworth, Kansas, US |
2021-03-06 | US | Iowa | Appanoose | 19007 | 1233 | 47 | 0 | 1186 | 40.74324454 | -92.86865906 | 2021-03-07 05:21:54 | Appanoose, Iowa, US |
2021-03-06 | US | Illinois | Cumberland | 17035 | 1204 | 18 | 0 | 1186 | 39.27432424 | -88.2401158 | 2021-03-07 05:21:54 | Cumberland, Illinois, US |
2021-03-05 | US | South Carolina | Calhoun | 45017 | 1222 | 36 | 0 | 1186 | 33.66926881 | -80.77722168 | 2021-03-06 04:23:41 | Calhoun, South Carolina, US |
2021-03-05 | US | Kentucky | Jackson | 21109 | 1215 | 29 | 0 | 1186 | 37.41866422 | -83.99825483 | 2021-03-06 04:23:41 | Jackson, Kentucky, US |
2021-03-05 | US | Kansas | Ellsworth | 20053 | 1211 | 25 | 0 | 1186 | 38.69677695 | -98.20462799 | 2021-03-06 04:23:41 | Ellsworth, Kansas, US |
2021-03-05 | US | Iowa | Appanoose | 19007 | 1233 | 47 | 0 | 1186 | 40.74324454 | -92.86865906 | 2021-03-06 04:23:41 | Appanoose, Iowa, US |
2021-03-05 | US | Georgia | Telfair | 13271 | 1240 | 54 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-03-06 04:23:41 | Telfair, Georgia, US |
2021-03-04 | US | Iowa | Appanoose | 19007 | 1233 | 47 | 0 | 1186 | 40.74324454 | -92.86865906 | 2021-03-05 05:26:29 | Appanoose, Iowa, US |
2021-03-04 | US | Georgia | Telfair | 13271 | 1240 | 54 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-03-05 05:26:29 | Telfair, Georgia, US |
2021-03-04 | US | Arkansas | Van Buren | 5141 | 1206 | 20 | 0 | 1186 | 35.58095779 | -92.51295036 | 2021-03-05 05:26:29 | Van Buren, Arkansas, US |
2021-03-03 | US | Mississippi | Perry | 28111 | 1221 | 35 | 0 | 1186 | 31.17161885 | -88.99281835 | 2021-03-04 05:24:24 | Perry, Mississippi, US |
2021-03-03 | US | Georgia | Telfair | 13271 | 1240 | 54 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-03-04 05:24:24 | Telfair, Georgia, US |
2021-03-02 | US | Georgia | Telfair | 13271 | 1240 | 54 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-03-03 05:23:28 | Telfair, Georgia, US |
2021-03-02 | Russia | Tula Oblast | 33273 | 1278 | 30809 | 1186 | 53.9570701 | 37.3690909 | 2021-03-03 05:23:28 | Tula Oblast, Russia | ||
2021-03-01 | US | Mississippi | Montgomery | 28097 | 1224 | 38 | 0 | 1186 | 33.49419589 | -89.61729103 | 2021-03-02 05:23:30 | Montgomery, Mississippi, US |
2021-03-01 | US | Georgia | Telfair | 13271 | 1239 | 53 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-03-02 05:23:30 | Telfair, Georgia, US |
2021-02-27 | US | Virginia | Bristol | 51520 | 1215 | 29 | 0 | 1186 | 36.6163024 | -82.16359122 | 2021-02-28 05:22:20 | Bristol, Virginia, US |
2021-02-27 | US | Georgia | Telfair | 13271 | 1239 | 53 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-02-28 05:22:20 | Telfair, Georgia, US |
2021-02-24 | US | Georgia | Telfair | 13271 | 1238 | 52 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-02-25 05:24:57 | Telfair, Georgia, US |
2021-02-23 | US | Georgia | Telfair | 13271 | 1238 | 52 | 0 | 1186 | 31.92829517 | -82.93491155 | 2021-02-24 05:29:16 | Telfair, Georgia, US |
2021-02-23 | US | Colorado | Gunnison | 8051 | 1208 | 6 | 0 | 1186 | 38.66611652 | -107.0320729 | 2021-02-24 05:29:16 | Gunnison, Colorado, US |
2021-02-21 | US | Virginia | Goochland | 51075 | 1194 | 8 | 0 | 1186 | 37.71714806 | -77.90381514 | 2021-02-22 05:24:21 | Goochland, Virginia, US |
2021-02-18 | US | Minnesota | Pennington | 27113 | 1202 | 16 | 0 | 1186 | 48.06642577 | -96.0370814 | 2021-02-19 05:24:16 | Pennington, Minnesota, US |
2021-02-16 | US | New Mexico | San Miguel | 35047 | 1196 | 10 | 0 | 1186 | 35.48014807 | -104.8163562 | 2021-02-17 05:23:10 | San Miguel, New Mexico, US |
2021-02-12 | US | Michigan | Gogebic | 26053 | 1232 | 46 | 0 | 1186 | 46.40862701 | -89.69377193 | 2021-02-13 05:22:12 | Gogebic, Michigan, US |
2021-02-12 | US | Georgia | Brooks | 13027 | 1227 | 41 | 0 | 1186 | 30.83922642 | -83.58303423 | 2021-02-13 05:22:12 | Brooks, Georgia, US |
2021-02-10 | US | Illinois | Massac | 17127 | 1217 | 31 | 0 | 1186 | 37.22078441 | -88.71036614 | 2021-02-11 05:23:55 | Massac, Illinois, US |
2021-02-05 | US | Oklahoma | Johnston | 40069 | 1203 | 17 | 0 | 1186 | 34.31440473 | -96.66011537 | 2021-02-06 05:23:55 | Johnston, Oklahoma, US |
2021-02-03 | US | Illinois | Mercer | 17131 | 1217 | 31 | 0 | 1186 | 41.20596782 | -90.74290052 | 2021-02-04 05:22:26 | Mercer, Illinois, US |
2021-02-02 | US | Wisconsin | Price | 55099 | 1193 | 7 | 0 | 1186 | 45.68051754 | -90.3609888 | 2021-02-03 05:22:52 | Price, Wisconsin, US |
2021-02-02 | US | Illinois | De Witt | 17039 | 1208 | 22 | 0 | 1186 | 40.17514519 | -88.90959682 | 2021-02-03 05:22:52 | De Witt, Illinois, US |
2021-02-01 | US | Illinois | Mason | 17125 | 1227 | 41 | 0 | 1186 | 40.23917274 | -89.91824452 | 2021-02-02 05:22:49 | Mason, Illinois, US |
2021-02-01 | US | Illinois | De Witt | 17039 | 1208 | 22 | 0 | 1186 | 40.17514519 | -88.90959682 | 2021-02-02 05:22:49 | De Witt, Illinois, US |
2021-01-31 | US | Illinois | De Witt | 17039 | 1208 | 22 | 0 | 1186 | 40.17514519 | -88.90959682 | 2021-02-01 05:22:53 | De Witt, Illinois, US |
2021-01-31 | Russia | Mari El Republic | 10663 | 156 | 9321 | 1186 | 56.5767504 | 47.8817512 | 2021-02-01 05:22:53 | Mari El Republic, Russia | ||
2021-01-30 | US | Ohio | Noble | 39121 | 1223 | 37 | 0 | 1186 | 39.76818851 | -81.45937183 | 2021-01-31 05:22:42 | Noble, Ohio, US |
2021-01-29 | US | South Dakota | Todd | 46121 | 1211 | 25 | 0 | 1186 | 43.19338568 | -100.7195503 | 2021-01-30 05:22:49 | Todd, South Dakota, US |
2021-01-29 | US | South Carolina | Bamberg | 45009 | 1228 | 42 | 0 | 1186 | 33.21927586 | -81.05659969 | 2021-01-30 05:22:49 | Bamberg, South Carolina, US |
2021-01-29 | US | Ohio | Noble | 39121 | 1223 | 37 | 0 | 1186 | 39.76818851 | -81.45937183 | 2021-01-30 05:22:49 | Noble, Ohio, US |
2021-01-28 | US | South Dakota | Todd | 46121 | 1211 | 25 | 0 | 1186 | 43.19338568 | -100.7195503 | 2021-01-29 05:22:23 | Todd, South Dakota, US |
2021-01-26 | US | Washington | Asotin | 53003 | 1212 | 26 | 0 | 1186 | 46.18894415 | -117.2022851 | 2021-01-27 05:23:41 | Asotin, Washington, US |
2021-01-26 | US | Illinois | Piatt | 17147 | 1198 | 12 | 0 | 1186 | 40.01360584 | -88.59319339 | 2021-01-27 05:23:41 | Piatt, Illinois, US |
2021-01-24 | US | Alabama | Macon | 1087 | 1223 | 37 | 0 | 1186 | 32.38759944 | -85.69267724 | 2021-01-25 05:22:16 | Macon, Alabama, US |
2021-01-23 | US | Mississippi | Yalobusha | 28161 | 1220 | 34 | 0 | 1186 | 34.02824175 | -89.70762049999998 | 2021-01-24 05:22:35 | Yalobusha, Mississippi, US |
2021-01-22 | US | South Carolina | Saluda | 45081 | 1217 | 31 | 0 | 1186 | 34.00795823 | -81.72713237 | 2021-01-23 05:22:03 | Saluda, South Carolina, US |
2021-01-22 | US | Iowa | Winnebago | 19189 | 1215 | 29 | 0 | 1186 | 43.37751174 | -93.73407298 | 2021-01-23 05:22:03 | Winnebago, Iowa, US |
2021-01-20 | US | Puerto Rico | Canovanas | 72029 | 1186 | 0 | 0 | 1186 | 18.328802 | -65.887612 | 2021-01-21 05:22:01 | Canovanas, Puerto Rico, US |
2021-01-19 | US | Puerto Rico | Canovanas | 72029 | 1186 | 0 | 0 | 1186 | 18.328802 | -65.887612 | 2021-01-20 05:21:54 | Canovanas, Puerto Rico, US |
2021-01-19 | US | New York | Seneca | 36099 | 1232 | 46 | 0 | 1186 | 42.78081007 | -76.82497064 | 2021-01-20 05:21:54 | Seneca, New York, US |
2021-01-19 | US | Iowa | Grundy | 19075 | 1212 | 26 | 0 | 1186 | 42.40183723 | -92.78829551 | 2021-01-20 05:21:54 | Grundy, Iowa, US |
2021-01-17 | Russia | Mari El Republic | 10028 | 138 | 8704 | 1186 | 56.5767504 | 47.8817512 | 2021-01-18 05:22:34 | Mari El Republic, Russia | ||
2021-01-12 | US | Texas | Hutchinson | 48233 | 2268 | 53 | 0 | 1186 | 35.84006574 | -101.3546643 | 2021-01-13 05:22:15 | Hutchinson, Texas, US |
2021-01-11 | US | Puerto Rico | Juncos | 72077 | 1186 | 0 | 0 | 1186 | 18.223793 | -65.909109 | 2021-01-12 05:22:15 | Juncos, Puerto Rico, US |
2021-01-11 | US | Missouri | Wright | 29229 | 1210 | 24 | 0 | 1186 | 37.27029221 | -92.46914488 | 2021-01-12 05:22:15 | Wright, Missouri, US |
2021-01-10 | US | New York | Washington | 36115 | 1205 | 19 | 0 | 1186 | 43.31153794 | -73.43043448 | 2021-01-11 05:21:50 | Washington, New York, US |
2021-01-09 | US | Wisconsin | Richland | 55103 | 1199 | 13 | 0 | 1186 | 43.3762778 | -90.43012729 | 2021-01-10 05:22:12 | Richland, Wisconsin, US |
2021-01-06 | US | Louisiana | LaSalle | 22059 | 1209 | 23 | 0 | 1186 | 31.67884782 | -92.15907765 | 2021-01-07 05:22:03 | LaSalle, Louisiana, US |
2021-01-05 | US | Virginia | Nottoway | 51135 | 1210 | 24 | 0 | 1186 | 37.1435975 | -78.05065922 | 2021-01-06 05:22:16 | Nottoway, Virginia, US |
2021-01-05 | US | Ohio | Carroll | 39019 | 1216 | 30 | 0 | 1186 | 40.5789686 | -81.09178213 | 2021-01-06 05:22:16 | Carroll, Ohio, US |
2021-01-01 | US | Massachusetts | Franklin | 25011 | 1278 | 65 | 0 | 1186 | 42.58119713 | -72.58602547 | 2021-01-02 05:22:33 | Franklin, Massachusetts, US |
2020-12-31 | US | Massachusetts | Franklin | 25011 | 1278 | 65 | 0 | 1186 | 42.58119713 | -72.58602547 | 2021-01-01 05:23:07 | Franklin, Massachusetts, US |
2020-12-27 | US | New Hampshire | Cheshire | 33005 | 1192 | 6 | 0 | 1186 | 42.92015988 | -72.25311043 | 2020-12-28 05:22:06 | Cheshire, New Hampshire, US |
2020-12-27 | US | Alabama | Randolph | 1111 | 1216 | 30 | 0 | 1186 | 33.29526734 | -85.45708831 | 2020-12-28 05:22:06 | Randolph, Alabama, US |
2020-12-25 | US | Virginia | Warren | 51187 | 1217 | 31 | 0 | 1186 | 38.90847745 | -78.20280433 | 2020-12-26 05:22:28 | Warren, Virginia, US |
2020-12-25 | US | Virginia | Mecklenburg | 51117 | 1224 | 38 | 0 | 1186 | 36.67882005 | -78.36131056 | 2020-12-26 05:22:28 | Mecklenburg, Virginia, US |
2020-12-25 | US | Georgia | Grady | 13131 | 1218 | 32 | 0 | 1186 | 30.87454847 | -84.23418364 | 2020-12-26 05:22:28 | Grady, Georgia, US |
2020-12-24 | US | Indiana | Owen | 18119 | 1218 | 32 | 0 | 1186 | 39.31145587 | -86.83900724 | 2020-12-25 05:22:48 | Owen, Indiana, US |
2020-12-22 | US | Texas | Cass | 48067 | 1146 | 43 | 0 | 1186 | 33.07499881 | -94.34646905 | 2020-12-23 05:22:03 | Cass, Texas, US |
2020-12-22 | US | Minnesota | Cottonwood | 27033 | 1198 | 12 | 0 | 1186 | 44.00715262 | -95.18138802 | 2020-12-23 05:22:03 | Cottonwood, Minnesota, US |
2020-12-22 | US | Iowa | Butler | 19023 | 1203 | 17 | 0 | 1186 | 42.73172833 | -92.79015971 | 2020-12-23 05:22:03 | Butler, Iowa, US |
2020-12-22 | US | Georgia | Putnam | 13237 | 1217 | 31 | 0 | 1186 | 33.32056115 | -83.37552891 | 2020-12-23 05:22:03 | Putnam, Georgia, US |
2020-12-21 | US | Nebraska | Unassigned | 90031 | 1188 | 2 | 0 | 1186 | 42.8997274 | 0.0 | 2020-12-22 05:22:33 | Unassigned, Nebraska, US |
2020-12-21 | Russia | Tyumen Oblast | 21753 | 180 | 20387 | 1186 | 58.8206488 | 70.36588370000001 | 2020-12-22 05:22:33 | Tyumen Oblast, Russia | ||
2020-12-20 | US | North Dakota | Barnes | 38003 | 1196 | 23 | 0 | 1186 | 46.93579637 | -98.06605978 | 2020-12-21 05:27:58 | Barnes, North Dakota, US |
2020-12-20 | US | Nebraska | Unassigned | 90031 | 1187 | 1 | 0 | 1186 | 42.8997274 | 0.0 | 2020-12-21 05:27:58 | Unassigned, Nebraska, US |
2020-12-20 | US | Georgia | Dodge | 13091 | 1245 | 59 | 0 | 1186 | 32.17265114 | -83.16948926 | 2020-12-21 05:27:58 | Dodge, Georgia, US |
2020-12-19 | US | Georgia | Crisp | 13081 | 1223 | 37 | 0 | 1186 | 31.92289565 | -83.76811843 | 2020-12-20 05:27:32 | Crisp, Georgia, US |
2020-12-17 | US | Kentucky | Lincoln | 21137 | 1207 | 21 | 0 | 1186 | 37.45475628 | -84.6565327 | 2020-12-18 05:28:18 | Lincoln, Kentucky, US |
2020-12-17 | US | Georgia | Fannin | 13111 | 1226 | 40 | 0 | 1186 | 34.86430205 | -84.316964 | 2020-12-18 05:28:18 | Fannin, Georgia, US |
2020-12-16 | US | New York | Livingston | 36051 | 1206 | 20 | 0 | 1186 | 42.72596275 | -77.77966158 | 2020-12-17 05:28:12 | Livingston, New York, US |
2020-12-15 | US | New York | Columbia | 36021 | 1244 | 58 | 0 | 1186 | 42.24819348 | -73.63089095 | 2020-12-16 05:28:04 | Columbia, New York, US |
2020-12-15 | US | Arkansas | Randolph | 5121 | 1223 | 37 | 0 | 1186 | 36.3415714 | -91.02455531 | 2020-12-16 05:28:04 | Randolph, Arkansas, US |
2020-12-09 | US | Montana | Glacier | 30035 | 1208 | 22 | 0 | 1186 | 48.70513576 | -112.9934235 | 2020-12-10 05:26:19 | Glacier, Montana, US |
2020-12-09 | US | Mississippi | Tishomingo | 28141 | 1233 | 47 | 0 | 1186 | 34.74023475 | -88.23917219 | 2020-12-10 05:26:19 | Tishomingo, Mississippi, US |
2020-12-09 | US | Kentucky | Clay | 21051 | 1194 | 8 | 0 | 1186 | 37.16451126 | -83.712575 | 2020-12-10 05:26:19 | Clay, Kentucky, US |
2020-12-08 | US | Kentucky | Ohio | 21183 | 1204 | 18 | 0 | 1186 | 37.47751843 | -86.85368087 | 2020-12-09 05:28:01 | Ohio, Kentucky, US |
2020-12-07 | US | New York | Cayuga | 36011 | 1196 | 10 | 0 | 1186 | 42.91261714 | -76.55731592 | 2020-12-08 05:27:42 | Cayuga, New York, US |
2020-12-04 | US | Texas | Upshur | 48459 | 1187 | 22 | 0 | 1186 | 32.73706798 | -94.93999853 | 2020-12-05 05:27:36 | Upshur, Texas, US |
2020-12-04 | US | Illinois | Crawford | 17033 | 1199 | 13 | 0 | 1186 | 39.0032229 | -87.75954624 | 2020-12-05 05:27:36 | Crawford, Illinois, US |
2020-12-03 | US | Ohio | Hardin | 39065 | 1221 | 35 | 0 | 1186 | 40.66015414 | -83.65929931 | 2020-12-04 05:27:27 | Hardin, Ohio, US |
2020-12-01 | US | Alabama | Bibb | 1007 | 1204 | 18 | 0 | 1186 | 32.99642064 | -87.12511459999997 | 2020-12-02 05:27:41 | Bibb, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;