daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where active = 6405 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-05-17 | Colombia | Atlantico | 260242 | 7983 | 245854 | 6405 | 10.6966 | -74.8741 | 2021-05-18 04:20:33 | Atlantico, Colombia | ||
2021-03-05 | US | Idaho | Madison | 16065 | 6427 | 22 | 0 | 6405 | 43.78141028 | -111.65384740000002 | 2021-03-06 04:23:41 | Madison, Idaho, US |
2021-02-14 | Russia | Chelyabinsk Oblast | 47596 | 909 | 40282 | 6405 | 54.4223954 | 61.1865846 | 2021-02-15 05:24:49 | Chelyabinsk Oblast, Russia | ||
2021-02-11 | US | Arkansas | Lonoke | 5085 | 6512 | 107 | 0 | 6405 | 34.75392199 | -91.88742357 | 2021-02-12 05:23:29 | Lonoke, Arkansas, US |
2021-02-06 | US | Minnesota | Rice | 27131 | 6487 | 82 | 0 | 6405 | 44.3543376 | -93.29658715 | 2021-02-07 05:23:00 | Rice, Minnesota, US |
2021-02-03 | US | Georgia | Gordon | 13129 | 6491 | 86 | 0 | 6405 | 34.50487351 | -84.87296253 | 2021-02-04 05:22:26 | Gordon, Georgia, US |
2021-01-26 | US | South Carolina | Darlington | 45031 | 6531 | 126 | 0 | 6405 | 34.33358335 | -79.96027485 | 2021-01-27 05:23:41 | Darlington, South Carolina, US |
2021-01-09 | Mexico | Campeche | 7385 | 980 | 0 | 6405 | 19.8301 | -90.5349 | 2021-01-10 05:22:12 | Campeche, Mexico | ||
2021-01-08 | Ukraine | Vinnytsia Oblast | 23512 | 414 | 16693 | 6405 | 49.2331 | 28.4682 | 2021-01-09 05:22:18 | Vinnytsia Oblast, Ukraine | ||
2020-12-11 | US | Michigan | Jackson | 26075 | 6522 | 117 | 0 | 6405 | 42.24807035 | -84.42258681 | 2020-12-12 05:26:19 | Jackson, Michigan, US |
2020-12-06 | Russia | Khabarovsk Krai | 26583 | 168 | 20010 | 6405 | 51.6312684 | 136.121524 | 2020-12-07 05:26:14 | Khabarovsk Krai, Russia | ||
2020-12-03 | Italy | Basilicata | 8586 | 158 | 2023 | 6405 | 40.63947052 | 15.80514834 | 2020-12-04 05:27:27 | Basilicata, Italy | ||
2020-12-02 | US | California | San Luis Obispo | 6079 | 6442 | 42 | 0 | 6405 | 35.38822029 | -120.4039028 | 2020-12-03 05:28:22 | San Luis Obispo, California, US |
2020-11-05 | Sweden | Ostergotland | 6659 | 254 | 0 | 6405 | 58.3454 | 15.5198 | 2020-11-06 05:24:55 | Ostergotland, Sweden | ||
2020-10-31 | Ukraine | Zhytomyr Oblast | 14257 | 255 | 7597 | 6405 | 50.2547 | 28.6587 | 2020-11-01 04:36:19 | Zhytomyr Oblast, Ukraine | ||
2020-07-31 | US | Florida | Seminole | 12117 | 6487 | 82 | 0 | 6405 | 28.7158582 | -81.24060348 | 2020-08-01 04:36:27 | Seminole, Florida, US |
2020-07-15 | India | Rajasthan | 26437 | 530 | 19502 | 6405 | 26.583423 | 73.847973 | 2020-07-16 04:44:59 | Rajasthan, India | ||
2020-07-12 | US | California | Kern | 6029 | 6502 | 97 | 0 | 6405 | 35.34329425 | -118.72777959999999 | 2020-07-13 04:43:04 | Kern, California, US |
2020-05-24 | US | Florida | Broward | 12011 | 6697 | 292 | 0 | 6405 | 26.15184651 | -80.48725556 | 2020-05-25 02:32:44 | Broward, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;