daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where active = 4956 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-06-02 | Estonia | 129804 | 1259 | 123589 | 4956 | 58.5953 | 25.0136 | 2021-06-03 04:23:32 | Estonia | |||
2021-04-02 | Italy | Basilicata | 19805 | 448 | 14401 | 4956 | 40.63947052 | 15.80514834 | 2021-04-03 04:20:44 | Basilicata, Italy | ||
2021-03-09 | Canada | British Columbia | 85119 | 1393 | 78770 | 4956 | 53.7267 | -127.6476 | 2021-03-10 05:24:35 | British Columbia, Canada | ||
2021-02-24 | US | Florida | Suwannee | 12121 | 5087 | 131 | 0 | 4956 | 30.19746066 | -82.99099670000003 | 2021-02-25 05:24:57 | Suwannee, Florida, US |
2021-02-23 | US | Oklahoma | McClain | 40087 | 5001 | 45 | 0 | 4956 | 35.01123903 | -97.44572302 | 2021-02-24 05:29:16 | McClain, Oklahoma, US |
2021-02-12 | US | Ohio | Lawrence | 39087 | 5048 | 92 | 0 | 4956 | 38.59743452 | -82.53466552 | 2021-02-13 05:22:12 | Lawrence, Ohio, US |
2021-01-30 | US | Texas | Bastrop | 48021 | 5618 | 63 | 0 | 4956 | 30.10370699 | -97.31206354 | 2021-01-31 05:22:42 | Bastrop, Texas, US |
2021-01-25 | US | Arkansas | Mississippi | 5093 | 5059 | 103 | 0 | 4956 | 35.76271485 | -90.05194370000002 | 2021-01-26 05:22:02 | Mississippi, Arkansas, US |
2021-01-24 | US | Indiana | Marshall | 18099 | 5053 | 97 | 0 | 4956 | 41.32467367 | -86.26185087 | 2021-01-25 05:22:16 | Marshall, Indiana, US |
2021-01-19 | US | Florida | Monroe | 12087 | 4993 | 37 | 0 | 4956 | 25.20904673 | -81.07812416 | 2021-01-20 05:21:54 | Monroe, Florida, US |
2021-01-18 | Ukraine | Zhytomyr Oblast | 42720 | 703 | 37061 | 4956 | 50.2547 | 28.6587 | 2021-01-19 05:22:15 | Zhytomyr Oblast, Ukraine | ||
2021-01-12 | US | Wisconsin | Waupaca | 55135 | 5093 | 137 | 0 | 4956 | 44.47068056 | -88.96534501 | 2021-01-13 05:22:15 | Waupaca, Wisconsin, US |
2020-12-03 | US | Pennsylvania | Washington | 42125 | 5029 | 73 | 0 | 4956 | 40.19208869 | -80.24582867 | 2020-12-04 05:27:27 | Washington, Pennsylvania, US |
2020-11-19 | US | New Jersey | Cumberland | 34011 | 5126 | 170 | 0 | 4956 | 39.37199394 | -75.10712559 | 2020-11-20 05:26:28 | Cumberland, New Jersey, US |
2020-11-15 | Russia | Komi Republic | 17113 | 277 | 11880 | 4956 | 63.9881421 | 54.3326073 | 2020-11-16 05:25:57 | Komi Republic, Russia | ||
2020-10-25 | US | Pennsylvania | Luzerne | 42079 | 5152 | 196 | 0 | 4956 | 41.17823008 | -75.98447579 | 2020-10-26 04:25:02 | Luzerne, Pennsylvania, US |
2020-10-08 | US | North Carolina | Robeson | 37155 | 5040 | 84 | 0 | 4956 | 34.64244496 | -79.10250529999998 | 2020-10-09 04:23:59 | Robeson, North Carolina, US |
2020-10-08 | Peru | Pasco | 5227 | 271 | 0 | 4956 | -10.39655 | -75.307635 | 2020-10-09 04:23:59 | Pasco, Peru | ||
2020-09-01 | Russia | Sverdlovsk Oblast | 25432 | 454 | 20022 | 4956 | 58.6414755 | 61.8021546 | 2020-09-02 04:28:25 | Sverdlovsk Oblast, Russia | ||
2020-08-23 | US | California | Solano | 6095 | 4986 | 32 | 0 | 4956 | 38.26827353 | -121.9357113 | 2020-08-24 04:27:56 | Solano, California, US |
2020-08-22 | US | New Jersey | Somerset | 34035 | 5520 | 564 | 0 | 4956 | 40.56465737 | -74.61683016 | 2020-08-23 04:27:48 | Somerset, New Jersey, US |
2020-08-19 | US | New York | Monroe | 36055 | 5241 | 285 | 0 | 4956 | 43.14638895 | -77.69322942 | 2020-08-20 04:27:43 | Monroe, New York, US |
2020-07-12 | India | Haryana | 21240 | 301 | 15983 | 4956 | 29.20004 | 76.332824 | 2020-07-13 04:43:04 | Haryana, India | ||
2020-06-24 | US | Pennsylvania | Bucks | 42017 | 5515 | 559 | 0 | 4956 | 40.33682119 | -75.10836643 | 2020-06-25 05:26:54 | Bucks, Pennsylvania, US |
2020-04-07 | US | Florida | Miami-Dade | 12086 | 4997 | 41 | 0 | 4956 | 25.6112362 | -80.55170587 | 2020-04-07 23:04:49 | Miami-Dade, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;