daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where active = 5540 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-26 | Spain | Ceuta | 5817 | 114 | 163 | 5540 | 35.8894 | -5.3213 | 2021-05-27 04:20:59 | Ceuta, Spain | ||
2021-04-15 | Italy | Basilicata | 21669 | 496 | 15633 | 5540 | 40.63947052 | 15.80514834 | 2021-04-16 04:20:46 | Basilicata, Italy | ||
2021-03-02 | US | Tennessee | Jefferson | 47089 | 5657 | 119 | 0 | 5540 | 36.04818632 | -83.45148924 | 2021-03-03 05:23:28 | Jefferson, Tennessee, US |
2021-01-29 | US | Ohio | Ross | 39141 | 5663 | 123 | 0 | 5540 | 39.33705391 | -83.06000914 | 2021-01-30 05:22:49 | Ross, Ohio, US |
2021-01-21 | US | Virginia | Lynchburg | 51680 | 5606 | 66 | 0 | 5540 | 37.40021399 | -79.19888138 | 2021-01-22 05:22:10 | Lynchburg, Virginia, US |
2021-01-08 | US | West Virginia | Wood | 54107 | 5598 | 58 | 0 | 5540 | 39.20967886 | -81.5162836 | 2021-01-09 05:22:18 | Wood, West Virginia, US |
2020-12-18 | US | Texas | Maverick | 48323 | 4532 | 185 | 0 | 5540 | 28.7429195 | -100.3157686 | 2020-12-19 05:27:52 | Maverick, Texas, US |
2020-11-09 | US | Tennessee | Wilson | 47189 | 5635 | 67 | 0 | 5540 | 36.15496772 | -86.29775884 | 2020-11-10 05:40:07 | Wilson, Tennessee, US |
2020-10-14 | Russia | Saratov Oblast | 17447 | 128 | 11779 | 5540 | 51.6520555 | 46.86319520000001 | 2020-10-15 04:24:28 | Saratov Oblast, Russia | ||
2020-09-05 | US | Arkansas | Benton | 5007 | 5599 | 59 | 0 | 5540 | 36.33644656 | -94.25680817 | 2020-09-06 04:28:33 | Benton, Arkansas, US |
2020-08-29 | US | South Carolina | Lexington | 45063 | 5676 | 136 | 0 | 5540 | 33.89665987 | -81.27146426 | 2020-08-30 04:28:22 | Lexington, South Carolina, US |
2020-08-08 | US | Kansas | Johnson | 20091 | 5643 | 103 | 0 | 5540 | 38.88548175 | -94.82250877 | 2020-08-09 04:34:54 | Johnson, Kansas, US |
2020-05-17 | US | California | Riverside | 6065 | 5794 | 245 | 0 | 5540 | 33.74314981 | -115.9933578 | 2020-05-18 02:32:21 | Riverside, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;