daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,033 rows where active = 154 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-18 | Ukraine | Mykolaiv Oblast | 70202 | 1858 | 68190 | 154 | 46.975 | 31.9946 | 2021-07-19 04:21:24 | Mykolaiv Oblast, Ukraine | ||
2021-07-05 | Kosovo | 107800 | 2265 | 105381 | 154 | 42.602636 | 20.902977 | 2021-07-06 04:21:32 | Kosovo | |||
2021-07-04 | Japan | Fukui | 1327 | 35 | 1138 | 154 | 35.846614 | 136.22465400000002 | 2021-07-05 04:21:28 | Fukui, Japan | ||
2021-06-30 | India | Chandigarh | 61670 | 808 | 60708 | 154 | 30.733839 | 76.76827800000002 | 2021-07-01 04:21:19 | Chandigarh, India | ||
2021-06-29 | Chile | Magallanes | 28845 | 451 | 28240 | 154 | -52.368 | -70.9863 | 2021-06-30 04:21:41 | Magallanes, Chile | ||
2021-06-25 | Germany | Saarland | 41435 | 1019 | 40270 | 154 | 49.3964 | 7.023 | 2021-06-26 04:21:43 | Saarland, Germany | ||
2021-06-21 | Japan | Okayama | 7580 | 124 | 7302 | 154 | 34.89246 | 133.826252 | 2021-06-22 04:21:34 | Okayama, Japan | ||
2021-06-15 | Japan | Gifu | 9110 | 181 | 8775 | 154 | 35.778671 | 137.055925 | 2021-06-16 04:22:32 | Gifu, Japan | ||
2021-06-13 | Japan | Miyagi | 9029 | 84 | 8791 | 154 | 38.446859 | 140.927086 | 2021-06-14 04:22:46 | Miyagi, Japan | ||
2021-06-07 | India | Dadra and Nagar Haveli and Daman and Diu | 10419 | 4 | 10261 | 154 | 20.194742 | 73.080901 | 2021-06-08 04:22:35 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-06-06 | Saint Lucia | 5133 | 80 | 4899 | 154 | 13.9094 | -60.9789 | 2021-06-07 04:22:51 | Saint Lucia | |||
2021-06-04 | Japan | Nara | 7857 | 118 | 7585 | 154 | 34.317451 | 135.871644 | 2021-06-05 04:23:03 | Nara, Japan | ||
2021-05-31 | Japan | Nagasaki | 2892 | 65 | 2673 | 154 | 33.235712 | 129.608033 | 2021-06-01 04:23:09 | Nagasaki, Japan | ||
2021-05-28 | Colombia | Guaviare | 2975 | 43 | 2778 | 154 | 1.0654 | -73.2603 | 2021-05-29 04:20:41 | Guaviare, Colombia | ||
2021-05-20 | Japan | Ehime | 2648 | 68 | 2426 | 154 | 33.624835 | 132.856842 | 2021-05-21 04:20:43 | Ehime, Japan | ||
2021-05-19 | Japan | Port Quarantine | 2889 | 3 | 2732 | 154 | 2021-05-20 04:21:05 | Port Quarantine, Japan | ||||
2021-05-18 | Senegal | 40896 | 1128 | 39614 | 154 | 14.4974 | -14.4524 | 2021-05-19 04:20:42 | Senegal | |||
2021-05-18 | Saint Vincent and the Grenadines | 1940 | 12 | 1774 | 154 | 12.9843 | -61.2872 | 2021-05-19 04:20:42 | Saint Vincent and the Grenadines | |||
2021-05-15 | Japan | Yamanashi | 1396 | 19 | 1223 | 154 | 35.612364 | 138.61148899999998 | 2021-05-16 04:20:49 | Yamanashi, Japan | ||
2021-05-14 | Japan | Yamanashi | 1387 | 19 | 1214 | 154 | 35.612364 | 138.61148899999998 | 2021-05-15 04:20:58 | Yamanashi, Japan | ||
2021-05-14 | Bhutan | 1276 | 1 | 1121 | 154 | 27.5142 | 90.4336 | 2021-05-15 04:20:58 | Bhutan | |||
2021-05-13 | Japan | Toyama | 1451 | 32 | 1265 | 154 | 36.637464 | 137.26934599999998 | 2021-05-14 04:20:41 | Toyama, Japan | ||
2021-05-10 | Saint Lucia | 4690 | 75 | 4461 | 154 | 13.9094 | -60.9789 | 2021-05-11 04:20:41 | Saint Lucia | |||
2021-05-04 | Liechtenstein | 3041 | 57 | 2830 | 154 | 47.14 | 9.55 | 2021-05-05 04:20:43 | Liechtenstein | |||
2021-04-30 | Senegal | 40344 | 1107 | 39083 | 154 | 14.4974 | -14.4524 | 2021-05-01 04:20:47 | Senegal | |||
2021-04-28 | China | Hong Kong | 11755 | 209 | 11392 | 154 | 22.3 | 114.2 | 2021-04-29 04:20:55 | Hong Kong, China | ||
2021-04-20 | Niger | 5140 | 191 | 4795 | 154 | 17.607789 | 8.081666 | 2021-04-21 04:21:14 | Niger | |||
2021-04-18 | Canada | New Brunswick | 1788 | 33 | 1601 | 154 | 46.5653 | -66.4619 | 2021-04-19 04:20:57 | New Brunswick, Canada | ||
2021-04-15 | South Sudan | 10416 | 114 | 10148 | 154 | 6.877000000000002 | 31.307 | 2021-04-16 04:20:46 | South Sudan | |||
2021-04-08 | Japan | Tokushima | 639 | 21 | 464 | 154 | 33.919178 | 134.242091 | 2021-04-09 04:21:13 | Tokushima, Japan | ||
2021-04-03 | Japan | Wakayama | 1336 | 18 | 1164 | 154 | 33.911879 | 135.505446 | 2021-04-04 04:20:49 | Wakayama, Japan | ||
2021-04-03 | Canada | New Brunswick | 1641 | 30 | 1457 | 154 | 46.5653 | -66.4619 | 2021-04-04 04:20:49 | New Brunswick, Canada | ||
2021-04-02 | Japan | Aomori | 1058 | 20 | 884 | 154 | 40.781541 | 140.828896 | 2021-04-03 04:20:44 | Aomori, Japan | ||
2021-03-28 | Colombia | Putumayo | 8169 | 322 | 7693 | 154 | 0.436 | -75.5277 | 2021-03-29 04:28:35 | Putumayo, Colombia | ||
2021-03-23 | Russia | Altai Republic | 16564 | 187 | 16223 | 154 | 50.7114101 | 86.8572186 | 2021-03-24 05:25:40 | Altai Republic, Russia | ||
2021-03-22 | Russia | Altai Republic | 16558 | 187 | 16217 | 154 | 50.7114101 | 86.8572186 | 2021-03-23 05:26:18 | Altai Republic, Russia | ||
2021-03-21 | Trinidad and Tobago | 7855 | 140 | 7561 | 154 | 10.6918 | -61.2225 | 2021-03-22 05:25:43 | Trinidad and Tobago | |||
2021-03-20 | Timor-Leste | 271 | 0 | 117 | 154 | -8.874217 | 125.727539 | 2021-03-21 05:25:44 | Timor-Leste | |||
2021-03-19 | Sao Tome and Principe | 2123 | 34 | 1935 | 154 | 0.1864 | 6.6131 | 2021-03-20 05:25:46 | Sao Tome and Principe | |||
2021-03-15 | Russia | Magadan Oblast | 8207 | 98 | 7955 | 154 | 62.48858785 | 153.9903764 | 2021-03-16 05:25:13 | Magadan Oblast, Russia | ||
2021-03-13 | Colombia | Putumayo | 7997 | 316 | 7527 | 154 | 0.436 | -75.5277 | 2021-03-14 05:25:37 | Putumayo, Colombia | ||
2021-03-10 | Netherlands | Curacao | 4862 | 22 | 4686 | 154 | 12.1696 | -68.99 | 2021-03-11 05:25:48 | Curacao, Netherlands | ||
2021-02-27 | Japan | Tochigi | 4090 | 66 | 3870 | 154 | 36.689912 | 139.819213 | 2021-02-28 05:22:20 | Tochigi, Japan | ||
2021-02-26 | Japan | Tochigi | 4078 | 66 | 3858 | 154 | 36.689912 | 139.819213 | 2021-02-27 05:22:28 | Tochigi, Japan | ||
2021-02-24 | US | Oklahoma | Cimarron | 40025 | 155 | 1 | 0 | 154 | 36.74817177 | -102.5173885 | 2021-02-25 05:24:57 | Cimarron, Oklahoma, US |
2021-02-23 | US | North Dakota | Divide | 38023 | 157 | 2 | 0 | 154 | 48.814938700000006 | -103.4873611 | 2021-02-24 05:29:16 | Divide, North Dakota, US |
2021-02-22 | Belize | 12255 | 314 | 11787 | 154 | 17.1899 | -88.4976 | 2021-02-23 05:23:41 | Belize | |||
2021-02-19 | Trinidad and Tobago | 7666 | 138 | 7374 | 154 | 10.6918 | -61.2225 | 2021-02-20 05:22:51 | Trinidad and Tobago | |||
2021-02-18 | Trinidad and Tobago | 7666 | 138 | 7374 | 154 | 10.6918 | -61.2225 | 2021-02-19 05:24:16 | Trinidad and Tobago | |||
2021-02-14 | Japan | Yamaguchi | 1354 | 35 | 1165 | 154 | 34.201190000000004 | 131.573293 | 2021-02-15 05:24:49 | Yamaguchi, Japan | ||
2021-02-13 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-14 05:23:43 | Wheatland, Montana, US |
2021-02-12 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-13 05:22:12 | Wheatland, Montana, US |
2021-02-12 | Equatorial Guinea | 5663 | 87 | 5422 | 154 | 1.6508 | 10.2679 | 2021-02-13 05:22:12 | Equatorial Guinea | |||
2021-02-11 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-12 05:23:29 | Wheatland, Montana, US |
2021-02-11 | Equatorial Guinea | 5663 | 87 | 5422 | 154 | 1.6508 | 10.2679 | 2021-02-12 05:23:29 | Equatorial Guinea | |||
2021-02-10 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-11 05:23:55 | Wheatland, Montana, US |
2021-02-09 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-10 05:22:41 | Wheatland, Montana, US |
2021-02-09 | US | Colorado | Gilpin | 8047 | 175 | 3 | 0 | 154 | 39.85646523 | -105.5252597 | 2021-02-10 05:22:41 | Gilpin, Colorado, US |
2021-02-08 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-09 05:23:30 | Wheatland, Montana, US |
2021-02-07 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-08 05:22:39 | Wheatland, Montana, US |
2021-02-07 | Chile | Aysen | 2662 | 23 | 2485 | 154 | -45.9864 | -73.7669 | 2021-02-08 05:22:39 | Aysen, Chile | ||
2021-02-06 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-07 05:23:00 | Wheatland, Montana, US |
2021-02-05 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-06 05:23:55 | Wheatland, Montana, US |
2021-02-04 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-05 05:22:38 | Wheatland, Montana, US |
2021-02-03 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-04 05:22:26 | Wheatland, Montana, US |
2021-02-02 | US | Montana | Wheatland | 30107 | 160 | 6 | 0 | 154 | 46.46652491 | -109.8464636 | 2021-02-03 05:22:52 | Wheatland, Montana, US |
2021-01-29 | Japan | Ehime | 977 | 18 | 805 | 154 | 33.624835 | 132.856842 | 2021-01-30 05:22:49 | Ehime, Japan | ||
2021-01-27 | Japan | Wakayama | 1024 | 13 | 857 | 154 | 33.911879 | 135.505446 | 2021-01-28 05:22:24 | Wakayama, Japan | ||
2021-01-25 | US | Mississippi | Issaquena | 28055 | 160 | 6 | 0 | 154 | 32.72531359 | -90.97392828 | 2021-01-26 05:22:02 | Issaquena, Mississippi, US |
2021-01-24 | US | Montana | McCone | 30055 | 154 | 0 | 0 | 154 | 47.64469406 | -105.7944994 | 2021-01-25 05:22:16 | McCone, Montana, US |
2021-01-24 | US | Mississippi | Issaquena | 28055 | 160 | 6 | 0 | 154 | 32.72531359 | -90.97392828 | 2021-01-25 05:22:16 | Issaquena, Mississippi, US |
2021-01-23 | US | Montana | McCone | 30055 | 154 | 0 | 0 | 154 | 47.64469406 | -105.7944994 | 2021-01-24 05:22:35 | McCone, Montana, US |
2021-01-23 | US | Mississippi | Issaquena | 28055 | 160 | 6 | 0 | 154 | 32.72531359 | -90.97392828 | 2021-01-24 05:22:35 | Issaquena, Mississippi, US |
2021-01-22 | US | Mississippi | Issaquena | 28055 | 160 | 6 | 0 | 154 | 32.72531359 | -90.97392828 | 2021-01-23 05:22:03 | Issaquena, Mississippi, US |
2021-01-21 | US | Missouri | Mercer | 29129 | 156 | 2 | 0 | 154 | 40.42212303 | -93.5682959 | 2021-01-22 05:22:10 | Mercer, Missouri, US |
2021-01-21 | US | Mississippi | Issaquena | 28055 | 160 | 6 | 0 | 154 | 32.72531359 | -90.97392828 | 2021-01-22 05:22:10 | Issaquena, Mississippi, US |
2021-01-20 | US | Kentucky | Robertson | 21201 | 163 | 9 | 0 | 154 | 38.51923469 | -84.05055616 | 2021-01-21 05:22:01 | Robertson, Kentucky, US |
2021-01-20 | Japan | Yamanashi | 869 | 12 | 703 | 154 | 35.612364 | 138.61148899999998 | 2021-01-21 05:22:01 | Yamanashi, Japan | ||
2021-01-19 | US | Missouri | Mercer | 29129 | 156 | 2 | 0 | 154 | 40.42212303 | -93.5682959 | 2021-01-20 05:21:54 | Mercer, Missouri, US |
2021-01-18 | US | Missouri | Mercer | 29129 | 156 | 2 | 0 | 154 | 40.42212303 | -93.5682959 | 2021-01-19 05:22:15 | Mercer, Missouri, US |
2021-01-16 | US | Puerto Rico | Jayuya | 72073 | 154 | 0 | 0 | 154 | 18.211446 | -66.58878 | 2021-01-17 05:22:17 | Jayuya, Puerto Rico, US |
2021-01-15 | US | Puerto Rico | Jayuya | 72073 | 154 | 0 | 0 | 154 | 18.211446 | -66.58878 | 2021-01-16 05:22:40 | Jayuya, Puerto Rico, US |
2021-01-15 | US | Maine | Piscataquis | 23021 | 155 | 1 | 0 | 154 | 45.83839062 | -69.2860223 | 2021-01-16 05:22:40 | Piscataquis, Maine, US |
2021-01-14 | US | Colorado | Custer | 8027 | 167 | 2 | 0 | 154 | 38.10883162 | -105.3683478 | 2021-01-15 05:22:24 | Custer, Colorado, US |
2021-01-12 | US | Delaware | Unassigned | 90010 | 154 | 0 | 0 | 154 | 39.57992638 | 0.0 | 2021-01-13 05:22:15 | Unassigned, Delaware, US |
2021-01-12 | US | Colorado | Custer | 8027 | 166 | 2 | 0 | 154 | 38.10883162 | -105.3683478 | 2021-01-13 05:22:15 | Custer, Colorado, US |
2021-01-11 | US | Delaware | Unassigned | 90010 | 154 | 0 | 0 | 154 | 39.57992638 | 0.0 | 2021-01-12 05:22:15 | Unassigned, Delaware, US |
2021-01-11 | US | Colorado | Custer | 8027 | 166 | 2 | 0 | 154 | 38.10883162 | -105.3683478 | 2021-01-12 05:22:15 | Custer, Colorado, US |
2021-01-10 | US | Missouri | Knox | 29103 | 156 | 2 | 0 | 154 | 40.12699751 | -92.14780832 | 2021-01-11 05:21:50 | Knox, Missouri, US |
2021-01-10 | US | Delaware | Unassigned | 90010 | 154 | 0 | 0 | 154 | 39.57992638 | 0.0 | 2021-01-11 05:21:50 | Unassigned, Delaware, US |
2021-01-10 | US | Colorado | Custer | 8027 | 165 | 2 | 0 | 154 | 38.10883162 | -105.3683478 | 2021-01-11 05:21:50 | Custer, Colorado, US |
2021-01-09 | US | Missouri | Knox | 29103 | 156 | 2 | 0 | 154 | 40.12699751 | -92.14780832 | 2021-01-10 05:22:12 | Knox, Missouri, US |
2021-01-09 | US | Colorado | Custer | 8027 | 165 | 2 | 0 | 154 | 38.10883162 | -105.3683478 | 2021-01-10 05:22:12 | Custer, Colorado, US |
2021-01-08 | US | Missouri | Knox | 29103 | 156 | 2 | 0 | 154 | 40.12699751 | -92.14780832 | 2021-01-09 05:22:18 | Knox, Missouri, US |
2021-01-07 | US | Missouri | Knox | 29103 | 156 | 2 | 0 | 154 | 40.12699751 | -92.14780832 | 2021-01-08 05:22:42 | Knox, Missouri, US |
2021-01-07 | US | Hawaii | Kauai | 15007 | 155 | 1 | 0 | 154 | 22.03935037 | -159.5966786 | 2021-01-08 05:22:42 | Kauai, Hawaii, US |
2021-01-06 | US | West Virginia | Calhoun | 54013 | 154 | 0 | 0 | 154 | 38.84315422 | -81.11934872 | 2021-01-07 05:22:03 | Calhoun, West Virginia, US |
2021-01-06 | US | Missouri | Knox | 29103 | 156 | 2 | 0 | 154 | 40.12699751 | -92.14780832 | 2021-01-07 05:22:03 | Knox, Missouri, US |
2021-01-06 | India | Meghalaya | 13525 | 141 | 13230 | 154 | 25.536934 | 91.278882 | 2021-01-07 05:22:03 | Meghalaya, India | ||
2021-01-05 | US | Texas | Shackelford | 48417 | 146 | 1 | 0 | 154 | 32.73587756 | -99.35401337 | 2021-01-06 05:22:16 | Shackelford, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;