daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

40 rows where active = 4190 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 10

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-07-25 Nigeria       171111 2132 164789 4190 9.082 8.6753 2021-07-26 04:21:28 Nigeria
2021-07-20 Malaysia Sabah     76454 580 71684 4190 5.9788 116.0753 2021-07-21 04:21:40 Sabah, Malaysia
2021-07-16 Russia Zabaykalsky Krai     51831 833 46808 4190 52.248521 115.956325 2021-07-17 04:22:22 Zabaykalsky Krai, Russia
2021-05-21 Malaysia Kelantan     21307 102 17015 4190 6.1254 102.2381 2021-05-22 04:20:45 Kelantan, Malaysia
2021-04-15 Chile Valparaiso     76425 2088 70147 4190 -33.0472 -71.6127 2021-04-16 04:20:46 Valparaiso, Chile
2021-04-03 Netherlands Curacao     9635 44 5401 4190 12.1696 -68.99 2021-04-04 04:20:49 Curacao, Netherlands
2021-02-22 Germany Brandenburg     74955 2914 67924 4190 52.4125 12.5316 2021-02-23 05:23:41 Brandenburg, Germany
2021-02-15 US Missouri Lincoln 29113 4220 30 0 4190 39.05345619 -90.95588181 2021-02-16 05:24:38 Lincoln, Missouri, US
2021-02-12 US Oklahoma Delaware 40041 4249 59 0 4190 36.40823634 -94.80325046 2021-02-13 05:22:12 Delaware, Oklahoma, US
2021-02-08 India Chhattisgarh     307790 3744 299856 4190 21.264705 82.035366 2021-02-09 05:23:30 Chhattisgarh, India
2021-01-30 US Minnesota Benton 27009 4278 88 0 4190 45.69804958 -93.99514135 2021-01-31 05:22:42 Benton, Minnesota, US
2021-01-30 US Kentucky Boyd 21019 4225 35 0 4190 38.36176608 -82.68652187 2021-01-31 05:22:42 Boyd, Kentucky, US
2021-01-27 US Wisconsin Marinette 55075 4250 60 0 4190 45.38553432 -88.03324599999998 2021-01-28 05:22:24 Marinette, Wisconsin, US
2021-01-27 US Nevada Elko 32007 4230 40 0 4190 41.14531606 -115.3577619 2021-01-28 05:22:24 Elko, Nevada, US
2021-01-27 US Massachusetts Berkshire 25003 4394 191 0 4190 42.37428441 -73.20524838 2021-01-28 05:22:24 Berkshire, Massachusetts, US
2021-01-25 US North Dakota Williams 38105 4224 35 0 4190 48.34522353 -103.4793387 2021-01-26 05:22:02 Williams, North Dakota, US
2021-01-23 US Ohio Huron 39077 4287 97 0 4190 41.14651175 -82.59867951 2021-01-24 05:22:35 Huron, Ohio, US
2021-01-22 US Michigan St. Joseph 26149 4261 71 0 4190 41.91441767 -85.52797979 2021-01-23 05:22:03 St. Joseph, Michigan, US
2021-01-19 US Utah Summit 49043 4196 6 0 4190 40.86688146 -110.9535882 2021-01-20 05:21:54 Summit, Utah, US
2021-01-15 US Iowa Marshall 19127 4251 61 0 4190 42.03586837 -92.9990819 2021-01-16 05:22:40 Marshall, Iowa, US
2021-01-10 Russia Irkutsk Oblast     43169 1339 37640 4190 56.6370122 104.719221 2021-01-11 05:21:50 Irkutsk Oblast, Russia
2021-01-07 US New Mexico Curry 35009 4240 50 0 4190 34.57421077 -103.3468876 2021-01-08 05:22:42 Curry, New Mexico, US
2021-01-02 US Minnesota Otter Tail 27111 4241 51 0 4190 46.40846929 -95.70835255 2021-01-03 05:22:52 Otter Tail, Minnesota, US
2020-12-31 Russia Tver Oblast     22269 453 17626 4190 57.1134475 35.174442799999994 2021-01-01 05:23:07 Tver Oblast, Russia
2020-12-15 US Georgia Barrow 13013 4250 60 0 4190 33.99148694 -83.71436292 2020-12-16 05:28:04 Barrow, Georgia, US
2020-12-07 US Illinois Boone 17007 4227 37 0 4190 42.32359279 -88.82345779 2020-12-08 05:27:42 Boone, Illinois, US
2020-11-29 US Pennsylvania Blair 42013 4253 63 0 4190 40.47961444 -78.34917412 2020-11-30 05:26:13 Blair, Pennsylvania, US
2020-11-08 US Minnesota St. Louis 27137 4267 77 0 4190 47.6048407 -92.46879855 2020-11-09 05:25:45 St. Louis, Minnesota, US
2020-10-27 US South Dakota Pennington 46103 4239 49 0 4190 44.0025835 -102.8240777 2020-10-28 04:24:39 Pennington, South Dakota, US
2020-10-05 US Louisiana Rapides 22079 4339 149 0 4190 31.19778499 -92.52997303 2020-10-06 04:23:33 Rapides, Louisiana, US
2020-10-05 Germany Baden-Wurttemberg     50934 1890 45107 4190 48.6616 9.3501 2020-10-06 04:23:33 Baden-Wurttemberg, Germany
2020-09-20 US New Jersey Gloucester 34015 4414 224 0 4190 39.71581067 -75.13995546 2020-09-21 04:23:00 Gloucester, New Jersey, US
2020-09-11 US Georgia Whitfield 13313 4247 57 0 4190 34.80987459 -84.96093476 2020-09-12 04:25:05 Whitfield, Georgia, US
2020-09-10 Albania       10860 324 6346 4190 41.1533 20.1683 2020-09-11 04:46:23 Albania
2020-08-17 US Florida Santa Rosa 12113 4237 47 0 4190 30.693414500000006 -87.02458128 2020-08-18 04:27:56 Santa Rosa, Florida, US
2020-07-30 Russia Nizhny Novgorod Oblast     23647 379 19078 4190 55.47180329999999 44.091159399999995 2020-07-31 04:35:18 Nizhny Novgorod Oblast, Russia
2020-07-19 Russia Chelyabinsk Oblast     9682 88 5404 4190 54.4223954 61.1865846 2020-07-20 05:34:40 Chelyabinsk Oblast, Russia
2020-07-13 Sudan       10250 657 5403 4190 12.8628 30.2176 2020-07-14 04:34:46 Sudan
2020-06-27 Russia Irkutsk Oblast     6575 55 2330 4190 56.6370122 104.719221 2020-06-28 04:34:04 Irkutsk Oblast, Russia
2020-06-22 US Indiana Lake 18089 4437 247 0 4190 41.41874274 -87.38277575 2020-06-23 04:33:22 Lake, Indiana, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;