daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where active = 4122 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-13 | Uzbekistan | 116918 | 778 | 112018 | 4122 | 41.377491 | 64.585262 | 2021-07-14 04:21:35 | Uzbekistan | |||
2021-07-07 | India | Tripura | 69019 | 703 | 64194 | 4122 | 23.746783 | 91.743565 | 2021-07-08 04:21:26 | Tripura, India | ||
2021-05-27 | Italy | Basilicata | 26188 | 572 | 21494 | 4122 | 40.63947052 | 15.80514834 | 2021-05-28 04:20:36 | Basilicata, Italy | ||
2021-05-17 | Ukraine | Chernihiv Oblast | 55624 | 1244 | 50258 | 4122 | 51.4982 | 31.2893 | 2021-05-18 04:20:33 | Chernihiv Oblast, Ukraine | ||
2021-05-05 | Morocco | 512656 | 9043 | 499491 | 4122 | 31.7917 | -7.0926 | 2021-05-06 04:20:38 | Morocco | |||
2021-02-27 | US | Illinois | Livingston | 17105 | 4198 | 76 | 0 | 4122 | 40.89188292 | -88.55784752 | 2021-02-28 05:22:20 | Livingston, Illinois, US |
2021-02-27 | US | Georgia | Effingham | 13103 | 4182 | 60 | 0 | 4122 | 32.36616021 | -81.34280942 | 2021-02-28 05:22:20 | Effingham, Georgia, US |
2021-02-23 | US | Louisiana | Lincoln | 22061 | 4210 | 88 | 0 | 4122 | 32.6003154 | -92.6659741 | 2021-02-24 05:29:16 | Lincoln, Louisiana, US |
2021-02-22 | US | Idaho | Bingham | 16011 | 4184 | 62 | 0 | 4122 | 43.21672879999999 | -112.3978437 | 2021-02-23 05:23:41 | Bingham, Idaho, US |
2021-02-04 | US | Washington | Skagit | 53057 | 4175 | 53 | 0 | 4122 | 48.48171488 | -121.766131 | 2021-02-05 05:22:38 | Skagit, Washington, US |
2021-02-03 | Botswana | 22738 | 148 | 18468 | 4122 | -22.3285 | 24.6849 | 2021-02-04 05:22:26 | Botswana | |||
2021-02-02 | US | Wisconsin | Pierce | 55093 | 4160 | 38 | 0 | 4122 | 44.71850291 | -92.4224416 | 2021-02-03 05:22:52 | Pierce, Wisconsin, US |
2021-02-02 | Botswana | 22738 | 148 | 18468 | 4122 | -22.3285 | 24.6849 | 2021-02-03 05:22:52 | Botswana | |||
2021-02-01 | Botswana | 22738 | 148 | 18468 | 4122 | -22.3285 | 24.6849 | 2021-02-02 05:22:49 | Botswana | |||
2021-01-17 | US | Louisiana | Vermilion | 22113 | 4213 | 91 | 0 | 4122 | 29.83517605 | -92.30292538 | 2021-01-18 05:22:34 | Vermilion, Louisiana, US |
2021-01-13 | US | Oklahoma | Carter | 40019 | 4141 | 19 | 0 | 4122 | 34.25103751 | -97.28552485 | 2021-01-14 05:22:32 | Carter, Oklahoma, US |
2021-01-10 | US | New York | Ontario | 36069 | 4197 | 75 | 0 | 4122 | 42.85145728 | -77.30874425 | 2021-01-11 05:21:50 | Ontario, New York, US |
2021-01-01 | US | Minnesota | Chisago | 27025 | 4149 | 27 | 0 | 4122 | 45.5021011 | -92.90861945 | 2021-01-02 05:22:33 | Chisago, Minnesota, US |
2020-12-31 | US | Minnesota | Chisago | 27025 | 4149 | 27 | 0 | 4122 | 45.5021011 | -92.90861945 | 2021-01-01 05:23:07 | Chisago, Minnesota, US |
2020-12-27 | US | Ohio | Ross | 39141 | 4218 | 96 | 0 | 4122 | 39.33705391 | -83.06000914 | 2020-12-28 05:22:06 | Ross, Ohio, US |
2020-12-24 | US | New York | Chemung | 36015 | 4211 | 89 | 0 | 4122 | 42.13891056 | -76.7638805 | 2020-12-25 05:22:48 | Chemung, New York, US |
2020-12-23 | US | Ohio | Hancock | 39063 | 4208 | 86 | 0 | 4122 | 41.00250487 | -83.66838948 | 2020-12-24 05:23:04 | Hancock, Ohio, US |
2020-12-16 | US | Wisconsin | Barron | 55005 | 4172 | 50 | 0 | 4122 | 45.42372701 | -91.84833627 | 2020-12-17 05:28:12 | Barron, Wisconsin, US |
2020-12-15 | US | Virginia | Stafford | 51179 | 4145 | 23 | 0 | 4122 | 38.41758738 | -77.45917053 | 2020-12-16 05:28:04 | Stafford, Virginia, US |
2020-12-15 | Russia | Novgorod Oblast | 14964 | 97 | 10745 | 4122 | 58.2843833 | 32.5169757 | 2020-12-16 05:28:04 | Novgorod Oblast, Russia | ||
2020-12-14 | Ukraine | Kirovohrad Oblast | 7225 | 203 | 2900 | 4122 | 48.5079 | 32.2623 | 2020-12-15 05:26:38 | Kirovohrad Oblast, Ukraine | ||
2020-12-12 | US | South Carolina | Orangeburg | 45075 | 4262 | 140 | 0 | 4122 | 33.4391073 | -80.79886287 | 2020-12-13 05:27:20 | Orangeburg, South Carolina, US |
2020-12-11 | US | Wisconsin | Sauk | 55111 | 4146 | 24 | 0 | 4122 | 43.42574087 | -89.94966132 | 2020-12-12 05:26:19 | Sauk, Wisconsin, US |
2020-12-08 | US | Indiana | Bartholomew | 18005 | 4204 | 82 | 0 | 4122 | 39.20744865 | -85.89558181 | 2020-12-09 05:28:01 | Bartholomew, Indiana, US |
2020-11-13 | US | New Mexico | San Juan | 35045 | 4330 | 208 | 0 | 4122 | 36.50838318 | -108.320437 | 2020-11-14 05:25:37 | San Juan, New Mexico, US |
2020-11-09 | US | North Carolina | Davidson | 37057 | 4170 | 48 | 0 | 4122 | 35.79115496 | -80.21256572 | 2020-11-10 05:40:07 | Davidson, North Carolina, US |
2020-11-01 | Russia | Chelyabinsk Oblast | 19159 | 163 | 14874 | 4122 | 54.4223954 | 61.1865846 | 2020-11-02 05:25:04 | Chelyabinsk Oblast, Russia | ||
2020-10-05 | US | Minnesota | Washington | 27163 | 4180 | 58 | 0 | 4122 | 45.03864533 | -92.88429635 | 2020-10-06 04:23:33 | Washington, Minnesota, US |
2020-09-16 | US | Oregon | Washington | 41067 | 4180 | 58 | 0 | 4122 | 45.55972701 | -123.0955257 | 2020-09-17 04:22:00 | Washington, Oregon, US |
2020-09-09 | US | Georgia | Whitfield | 13313 | 4177 | 55 | 0 | 4122 | 34.80987459 | -84.96093476 | 2020-09-10 04:29:01 | Whitfield, Georgia, US |
2020-09-01 | US | Florida | Okaloosa | 12091 | 4199 | 77 | 0 | 4122 | 30.69143028 | -86.59267105 | 2020-09-02 04:28:25 | Okaloosa, Florida, US |
2020-08-15 | US | Texas | Brazos | 48041 | 4421 | 51 | 0 | 4122 | 30.663644800000004 | -96.30205577 | 2020-08-16 04:27:42 | Brazos, Texas, US |
2020-07-10 | Algeria | 18242 | 996 | 13124 | 4122 | 28.0339 | 1.6596 | 2020-07-11 04:34:26 | Algeria | |||
2020-07-09 | US | Oklahoma | Oklahoma | 40109 | 4194 | 72 | 0 | 4122 | 35.55140095 | -97.40716948 | 2020-07-10 04:34:24 | Oklahoma, Oklahoma, US |
2020-07-08 | Mexico | Ciudad de Mexico | 54405 | 7303 | 42980 | 4122 | 19.4326 | -99.1332 | 2020-07-09 04:34:23 | Ciudad de Mexico, Mexico | ||
2020-05-14 | US | Colorado | Denver | 8031 | 5395 | 323 | 0 | 4122 | 39.76018276 | -104.87256950000001 | 2020-05-15 02:33:02 | Denver, Colorado, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;