daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
74 rows where active = 2711 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-20 | India | Himachal Pradesh | 200410 | 3442 | 194257 | 2711 | 31.927213 | 77.233081 | 2021-06-21 04:21:41 | Himachal Pradesh, India | ||
2021-05-18 | Ukraine | Luhansk Oblast | 25396 | 833 | 21852 | 2711 | 48.574 | 39.3078 | 2021-05-19 04:20:42 | Luhansk Oblast, Ukraine | ||
2021-04-22 | Germany | Saarland | 35633 | 946 | 32250 | 2711 | 49.3964 | 7.023 | 2021-04-23 04:20:52 | Saarland, Germany | ||
2021-04-13 | Maldives | 25759 | 67 | 22981 | 2711 | 3.2028 | 73.2207 | 2021-04-14 04:20:41 | Maldives | |||
2021-04-07 | Madagascar | 26127 | 469 | 22947 | 2711 | -18.766947 | 46.869107 | 2021-04-08 04:21:13 | Madagascar | |||
2021-04-05 | Netherlands | Unknown | 2523 | 28 | 0 | 2711 | 2021-04-06 04:20:32 | Unknown, Netherlands | ||||
2021-02-28 | US | Illinois | Iroquois | 17075 | 2771 | 60 | 0 | 2711 | 40.74717633 | -87.82466784 | 2021-03-01 05:23:01 | Iroquois, Illinois, US |
2021-02-25 | US | Idaho | Latah | 16057 | 2717 | 6 | 0 | 2711 | 46.81587887 | -116.7113698 | 2021-02-26 05:22:40 | Latah, Idaho, US |
2021-02-25 | US | California | Glenn | 6021 | 2707 | 15 | 0 | 2711 | 39.59875897 | -122.3938452 | 2021-02-26 05:22:40 | Glenn, California, US |
2021-02-23 | US | Oregon | Klamath | 41035 | 2765 | 54 | 0 | 2711 | 42.68762984 | -121.64964609999998 | 2021-02-24 05:29:16 | Klamath, Oregon, US |
2021-02-20 | Russia | Udmurt Republic | 27473 | 588 | 24174 | 2711 | 57.1961165 | 52.69598320000001 | 2021-02-21 05:24:33 | Udmurt Republic, Russia | ||
2021-02-17 | Russia | Kostroma Oblast | 17928 | 334 | 14883 | 2711 | 58.424756 | 44.2533273 | 2021-02-18 05:22:58 | Kostroma Oblast, Russia | ||
2021-02-11 | US | Tennessee | Overton | 47133 | 2851 | 57 | 0 | 2711 | 36.34117832 | -85.28989535 | 2021-02-12 05:23:29 | Overton, Tennessee, US |
2021-02-08 | US | Louisiana | Jefferson Davis | 22053 | 2793 | 82 | 0 | 2711 | 30.26896765 | -92.81210004 | 2021-02-09 05:23:30 | Jefferson Davis, Louisiana, US |
2021-02-05 | US | Missouri | Howell | 29091 | 2753 | 42 | 0 | 2711 | 36.77383887 | -91.88683935 | 2021-02-06 05:23:55 | Howell, Missouri, US |
2021-02-03 | US | Mississippi | Scott | 28123 | 2769 | 58 | 0 | 2711 | 32.406704100000006 | -89.53789439 | 2021-02-04 05:22:26 | Scott, Mississippi, US |
2021-02-02 | US | Virginia | Charlottesville | 51540 | 2750 | 39 | 0 | 2711 | 38.03527919 | -78.48569588 | 2021-02-03 05:22:52 | Charlottesville, Virginia, US |
2021-02-01 | US | South Dakota | Lawrence | 46081 | 2752 | 41 | 0 | 2711 | 44.35919441 | -103.7929428 | 2021-02-02 05:22:49 | Lawrence, South Dakota, US |
2021-02-01 | US | Georgia | Stephens | 13257 | 2778 | 67 | 0 | 2711 | 34.55151201 | -83.29405315 | 2021-02-02 05:22:49 | Stephens, Georgia, US |
2021-01-30 | US | South Dakota | Yankton | 46135 | 2739 | 28 | 0 | 2711 | 43.00924485 | -97.39467635 | 2021-01-31 05:22:42 | Yankton, South Dakota, US |
2021-01-29 | Russia | Ivanovo Oblast | 26429 | 741 | 22977 | 2711 | 56.9167446 | 41.43521370000001 | 2021-01-30 05:22:49 | Ivanovo Oblast, Russia | ||
2021-01-28 | Russia | Murmansk Oblast | 42643 | 808 | 39124 | 2711 | 68.00004179999999 | 33.9999151 | 2021-01-29 05:22:23 | Murmansk Oblast, Russia | ||
2021-01-27 | US | Iowa | Jones | 19105 | 2761 | 50 | 0 | 2711 | 42.12118609 | -91.13139641 | 2021-01-28 05:22:24 | Jones, Iowa, US |
2021-01-24 | US | Idaho | Cassia | 16031 | 2733 | 22 | 0 | 2711 | 42.28347888 | -113.6012409 | 2021-01-25 05:22:16 | Cassia, Idaho, US |
2021-01-23 | US | Illinois | Perry | 17145 | 2764 | 53 | 0 | 2711 | 38.08510853 | -89.36856219 | 2021-01-24 05:22:35 | Perry, Illinois, US |
2021-01-20 | US | Arkansas | Poinsett | 5111 | 2781 | 70 | 0 | 2711 | 35.57433534 | -90.66268713 | 2021-01-21 05:22:01 | Poinsett, Arkansas, US |
2021-01-19 | US | Colorado | Montrose | 8085 | 3018 | 52 | 0 | 2711 | 38.40214114 | -108.26390220000002 | 2021-01-20 05:21:54 | Montrose, Colorado, US |
2021-01-14 | US | Missouri | Platte | 29165 | 2737 | 26 | 0 | 2711 | 39.38154439 | -94.77068479 | 2021-01-15 05:22:24 | Platte, Missouri, US |
2021-01-09 | US | North Carolina | Scotland | 37165 | 2768 | 57 | 0 | 2711 | 34.8386299 | -79.4757978 | 2021-01-10 05:22:12 | Scotland, North Carolina, US |
2021-01-09 | US | Kentucky | Boyle | 21021 | 2716 | 5 | 0 | 2711 | 37.62680923 | -84.8633779 | 2021-01-10 05:22:12 | Boyle, Kentucky, US |
2021-01-02 | US | Kentucky | Graves | 21083 | 2760 | 49 | 0 | 2711 | 36.72292505 | -88.65143315 | 2021-01-03 05:22:52 | Graves, Kentucky, US |
2021-01-02 | US | Illinois | Lee | 17103 | 2741 | 30 | 0 | 2711 | 41.74583951 | -89.29977132 | 2021-01-03 05:22:52 | Lee, Illinois, US |
2021-01-01 | US | Ohio | Knox | 39083 | 2783 | 72 | 0 | 2711 | 40.39830217 | -82.42027563 | 2021-01-02 05:22:33 | Knox, Ohio, US |
2020-12-27 | US | Arkansas | Unassigned | 90005 | 2711 | 0 | 0 | 2711 | 36.38177105 | 0.0 | 2020-12-28 05:22:06 | Unassigned, Arkansas, US |
2020-12-25 | Japan | Aichi | 15203 | 188 | 12304 | 2711 | 35.035551 | 137.211621 | 2020-12-26 05:22:28 | Aichi, Japan | ||
2020-12-23 | US | Iowa | Jasper | 19099 | 2762 | 51 | 0 | 2711 | 41.68576082 | -93.05567785 | 2020-12-24 05:23:04 | Jasper, Iowa, US |
2020-12-20 | US | North Carolina | Franklin | 37069 | 2748 | 37 | 0 | 2711 | 36.081519 | -78.28708884 | 2020-12-21 05:27:58 | Franklin, North Carolina, US |
2020-12-16 | US | Illinois | Franklin | 17055 | 2746 | 35 | 0 | 2711 | 37.99189086 | -88.92567818 | 2020-12-17 05:28:12 | Franklin, Illinois, US |
2020-12-15 | US | Washington | Skagit | 53057 | 2741 | 30 | 0 | 2711 | 48.48171488 | -121.766131 | 2020-12-16 05:28:04 | Skagit, Washington, US |
2020-12-15 | US | South Dakota | Brookings | 46011 | 2735 | 24 | 0 | 2711 | 44.36974375 | -96.79079945 | 2020-12-16 05:28:04 | Brookings, South Dakota, US |
2020-12-14 | Spain | Ceuta | 2930 | 56 | 163 | 2711 | 35.8894 | -5.3213 | 2020-12-15 05:26:38 | Ceuta, Spain | ||
2020-12-11 | US | Minnesota | McLeod | 27085 | 2740 | 29 | 0 | 2711 | 44.82367677 | -94.27287017 | 2020-12-12 05:26:19 | McLeod, Minnesota, US |
2020-12-10 | Chile | Metropolitana | 308692 | 10487 | 295494 | 2711 | -33.4376 | -70.6505 | 2020-12-11 05:26:59 | Metropolitana, Chile | ||
2020-12-05 | US | Kentucky | Laurel | 21125 | 2722 | 11 | 0 | 2711 | 37.10975748 | -84.11321779 | 2020-12-06 05:26:18 | Laurel, Kentucky, US |
2020-12-01 | Italy | Molise | 4773 | 120 | 1942 | 2711 | 41.55774754 | 14.65916051 | 2020-12-02 05:27:41 | Molise, Italy | ||
2020-11-28 | US | North Carolina | Surry | 37171 | 2755 | 44 | 0 | 2711 | 36.41689489 | -80.69102283 | 2020-11-29 05:25:55 | Surry, North Carolina, US |
2020-11-22 | Qatar | 137229 | 236 | 134282 | 2711 | 25.3548 | 51.1839 | 2020-11-23 05:25:26 | Qatar | |||
2020-11-17 | US | South Carolina | Kershaw | 45055 | 2769 | 58 | 0 | 2711 | 34.33988254 | -80.58763164 | 2020-11-18 05:40:31 | Kershaw, South Carolina, US |
2020-11-09 | Qatar | 134433 | 232 | 131490 | 2711 | 25.3548 | 51.1839 | 2020-11-10 05:40:07 | Qatar | |||
2020-10-20 | US | Arizona | Yavapai | 4025 | 2798 | 87 | 0 | 2711 | 34.59933926 | -112.5538588 | 2020-10-21 04:24:14 | Yavapai, Arizona, US |
2020-10-15 | US | Indiana | Johnson | 18081 | 2849 | 138 | 0 | 2711 | 39.48994426 | -86.10149107 | 2020-10-16 04:24:01 | Johnson, Indiana, US |
2020-10-15 | Russia | Samara Oblast | 13578 | 216 | 10651 | 2711 | 53.2128813 | 50.8914633 | 2020-10-16 04:24:01 | Samara Oblast, Russia | ||
2020-10-12 | US | Connecticut | New London | 9011 | 2837 | 126 | 0 | 2711 | 41.48896435 | -72.10430976 | 2020-10-13 04:24:02 | New London, Connecticut, US |
2020-10-11 | US | Pennsylvania | Lackawanna | 42069 | 2928 | 217 | 0 | 2711 | 41.43564672 | -75.60379201 | 2020-10-12 04:23:45 | Lackawanna, Pennsylvania, US |
2020-10-09 | Russia | Kalmykia Republic | 7119 | 77 | 4331 | 2711 | 46.2313018 | 45.3275745 | 2020-10-10 04:23:57 | Kalmykia Republic, Russia | ||
2020-10-08 | US | Ohio | Pickaway | 39129 | 2749 | 38 | 0 | 2711 | 39.64170392 | -83.0243386 | 2020-10-09 04:23:59 | Pickaway, Ohio, US |
2020-10-01 | US | Illinois | Kankakee | 17091 | 2788 | 77 | 0 | 2711 | 41.13746989 | -87.86205334 | 2020-10-02 04:23:51 | Kankakee, Illinois, US |
2020-09-30 | Ukraine | Volyn Oblast | 8059 | 168 | 5180 | 2711 | 50.7472 | 25.3254 | 2020-10-01 04:23:42 | Volyn Oblast, Ukraine | ||
2020-09-16 | US | Delaware | Kent | 10001 | 2827 | 116 | 0 | 2711 | 39.08646628 | -75.56884914 | 2020-09-17 04:22:00 | Kent, Delaware, US |
2020-09-06 | US | Puerto Rico | Bayamon | 72021 | 2711 | 0 | 0 | 2711 | 18.34946 | -66.168435 | 2020-09-07 04:28:30 | Bayamon, Puerto Rico, US |
2020-08-28 | US | Georgia | Clarke | 13059 | 2737 | 26 | 0 | 2711 | 33.95436462 | -83.37124007 | 2020-08-29 04:28:19 | Clarke, Georgia, US |
2020-08-25 | US | Michigan | Washtenaw | 26161 | 2826 | 115 | 0 | 2711 | 42.253105 | -83.83853204 | 2020-08-26 04:28:11 | Washtenaw, Michigan, US |
2020-08-15 | US | Wisconsin | Kenosha | 55059 | 2771 | 60 | 0 | 2711 | 42.57639354 | -88.04051686 | 2020-08-16 04:27:42 | Kenosha, Wisconsin, US |
2020-07-30 | US | Florida | Clay | 12019 | 2758 | 47 | 0 | 2711 | 29.98319144 | -81.85609986 | 2020-07-31 04:35:18 | Clay, Florida, US |
2020-07-27 | US | North Carolina | Gaston | 37071 | 2736 | 25 | 0 | 2711 | 35.29373559 | -81.17477045 | 2020-07-28 04:58:43 | Gaston, North Carolina, US |
2020-07-25 | US | Utah | Southwest Utah | 2733 | 22 | 0 | 2711 | 37.85447192 | -111.4418764 | 2020-07-26 04:35:00 | Southwest Utah, Utah, US | |
2020-07-24 | US | Tennessee | Unassigned | 90047 | 188 | 3 | 0 | 2711 | 36.55606529 | 0.0 | 2020-07-25 04:47:39 | Unassigned, Tennessee, US |
2020-07-24 | US | Arizona | Coconino | 4005 | 2821 | 110 | 0 | 2711 | 35.83883429 | -111.7707178 | 2020-07-25 04:47:39 | Coconino, Arizona, US |
2020-07-21 | US | California | Merced | 6047 | 2727 | 15 | 0 | 2711 | 37.18922369 | -120.7209035 | 2020-07-22 04:34:42 | Merced, California, US |
2020-07-15 | India | Punjab | 8799 | 221 | 5867 | 2711 | 30.841465000000003 | 75.40879 | 2020-07-16 04:44:59 | Punjab, India | ||
2020-07-06 | Peru | Tumbes | 3164 | 453 | 0 | 2711 | -3.857496 | -80.54525500000003 | 2020-07-07 04:34:00 | Tumbes, Peru | ||
2020-05-21 | US | North Carolina | Mecklenburg | 37119 | 2780 | 69 | 0 | 2711 | 35.24469268 | -80.8317671 | 2020-05-22 02:36:51 | Mecklenburg, North Carolina, US |
2020-05-20 | US | North Carolina | Mecklenburg | 37119 | 2780 | 69 | 0 | 2711 | 35.24469268 | -80.8317671 | 2020-05-21 02:32:48 | Mecklenburg, North Carolina, US |
2020-05-09 | Bahrain | 4774 | 8 | 2055 | 2711 | 26.0275 | 50.55 | 2020-05-10 02:32:30 | Bahrain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;