daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where active = 4498 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-21 | Russia | Zabaykalsky Krai | 53403 | 867 | 48038 | 4498 | 52.248521 | 115.956325 | 2021-07-22 04:21:19 | Zabaykalsky Krai, Russia | ||
2021-07-18 | Russia | Smolensk Oblast | 38915 | 1239 | 33178 | 4498 | 55.03434960000001 | 33.0192065 | 2021-07-19 04:21:24 | Smolensk Oblast, Russia | ||
2021-04-12 | Russia | Saratov Oblast | 56560 | 876 | 51186 | 4498 | 51.6520555 | 46.86319520000001 | 2021-04-13 04:20:37 | Saratov Oblast, Russia | ||
2021-03-30 | Russia | Saratov Oblast | 54632 | 809 | 49325 | 4498 | 51.6520555 | 46.86319520000001 | 2021-03-31 04:26:25 | Saratov Oblast, Russia | ||
2021-03-24 | Italy | Basilicata | 18618 | 430 | 13690 | 4498 | 40.63947052 | 15.80514834 | 2021-03-25 05:27:00 | Basilicata, Italy | ||
2021-03-02 | US | Nevada | Elko | 32007 | 4549 | 51 | 0 | 4498 | 41.14531606 | -115.3577619 | 2021-03-03 05:23:28 | Elko, Nevada, US |
2021-02-28 | US | Missouri | Taney | 29213 | 4586 | 88 | 0 | 4498 | 36.65465345 | -93.04075153 | 2021-03-01 05:23:01 | Taney, Missouri, US |
2021-02-24 | US | Indiana | Shelby | 18145 | 4588 | 90 | 0 | 4498 | 39.52305623 | -85.79158570000001 | 2021-02-25 05:24:57 | Shelby, Indiana, US |
2021-02-21 | US | Kentucky | Nelson | 21179 | 4531 | 33 | 0 | 4498 | 37.80335779 | -85.4657193 | 2021-02-22 05:24:21 | Nelson, Kentucky, US |
2021-02-16 | US | Wisconsin | Dunn | 55033 | 4524 | 26 | 0 | 4498 | 44.94562799 | -91.8962481 | 2021-02-17 05:23:10 | Dunn, Wisconsin, US |
2021-02-11 | US | Tennessee | Franklin | 47051 | 4583 | 79 | 0 | 4498 | 35.15634626 | -86.09201039 | 2021-02-12 05:23:29 | Franklin, Tennessee, US |
2021-02-10 | US | Ohio | Sandusky | 39143 | 4611 | 113 | 0 | 4498 | 41.35624126 | -83.137872 | 2021-02-11 05:23:55 | Sandusky, Ohio, US |
2021-02-05 | US | Oklahoma | Pontotoc | 40123 | 4537 | 39 | 0 | 4498 | 34.72959848 | -96.68337199 | 2021-02-06 05:23:55 | Pontotoc, Oklahoma, US |
2021-01-24 | US | Ohio | Lawrence | 39087 | 4579 | 81 | 0 | 4498 | 38.59743452 | -82.53466552 | 2021-01-25 05:22:16 | Lawrence, Ohio, US |
2021-01-23 | US | Wyoming | Campbell | 56005 | 4547 | 49 | 0 | 4498 | 44.24886082 | -105.5474404 | 2021-01-24 05:22:35 | Campbell, Wyoming, US |
2021-01-22 | US | Wyoming | Campbell | 56005 | 4547 | 49 | 0 | 4498 | 44.24886082 | -105.5474404 | 2021-01-23 05:22:03 | Campbell, Wyoming, US |
2021-01-22 | US | Texas | Hunt | 48231 | 4213 | 112 | 0 | 4498 | 33.12351514 | -96.08551032 | 2021-01-23 05:22:03 | Hunt, Texas, US |
2021-01-21 | US | Texas | Hunt | 48231 | 4213 | 112 | 0 | 4498 | 33.12351514 | -96.08551032 | 2021-01-22 05:22:10 | Hunt, Texas, US |
2021-01-20 | US | Oklahoma | Carter | 40019 | 4519 | 21 | 0 | 4498 | 34.25103751 | -97.28552485 | 2021-01-21 05:22:01 | Carter, Oklahoma, US |
2021-01-19 | US | Colorado | Garfield | 8045 | 4752 | 38 | 0 | 4498 | 39.59921777 | -107.902708 | 2021-01-20 05:21:54 | Garfield, Colorado, US |
2021-01-04 | US | Illinois | Clinton | 17027 | 4573 | 75 | 0 | 4498 | 38.60704876 | -89.42385254 | 2021-01-05 05:21:49 | Clinton, Illinois, US |
2020-12-20 | US | South Carolina | Lancaster | 45057 | 4576 | 78 | 0 | 4498 | 34.68270843 | -80.70513032 | 2020-12-21 05:27:58 | Lancaster, South Carolina, US |
2020-12-14 | US | Tennessee | Hamblen | 47063 | 4528 | 68 | 0 | 4498 | 36.21990035 | -83.26586179 | 2020-12-15 05:26:38 | Hamblen, Tennessee, US |
2020-11-11 | Russia | Komi Republic | 16044 | 257 | 11289 | 4498 | 63.9881421 | 54.3326073 | 2020-11-12 05:25:55 | Komi Republic, Russia | ||
2020-11-01 | US | Colorado | Larimer | 8069 | 5206 | 63 | 0 | 4498 | 40.66671597 | -105.4625784 | 2020-11-02 05:25:04 | Larimer, Colorado, US |
2020-11-01 | US | Alabama | Etowah | 1055 | 4552 | 54 | 0 | 4498 | 34.04567266 | -86.04051873 | 2020-11-02 05:25:04 | Etowah, Alabama, US |
2020-10-31 | US | North Dakota | Grand Forks | 38035 | 4687 | 22 | 0 | 4498 | 47.92093639 | -97.45450447 | 2020-11-01 04:36:19 | Grand Forks, North Dakota, US |
2020-10-28 | Pakistan | Sindh | 144765 | 2611 | 137656 | 4498 | 26.009446 | 68.77680699999999 | 2020-10-29 04:24:49 | Sindh, Pakistan | ||
2020-10-10 | US | Washington | Franklin | 53021 | 4564 | 66 | 0 | 4498 | 46.53351425 | -118.9018212 | 2020-10-11 04:23:46 | Franklin, Washington, US |
2020-09-14 | US | North Carolina | Gaston | 37071 | 4568 | 70 | 0 | 4498 | 35.29373559 | -81.17477045 | 2020-09-15 03:22:50 | Gaston, North Carolina, US |
2020-09-09 | Ukraine | Chernivtsi Oblast | 11581 | 304 | 6779 | 4498 | 48.2917 | 25.9352 | 2020-09-10 04:29:01 | Chernivtsi Oblast, Ukraine | ||
2020-08-20 | US | Illinois | St. Clair | 17163 | 4664 | 166 | 0 | 4498 | 38.46996033 | -89.93063427 | 2020-08-21 04:27:41 | St. Clair, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;