johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
783 rows where active = 214 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903893 | 3903893 | 2021-07-31 | Germany | Sachsen-Anhalt | 99502 | 3454 | 95920 | 214 | 51.9503 | 11.6923 | 2021-08-01 04:21:50 | Sachsen-Anhalt, Germany | ||
3903768 | 3903768 | 2021-07-31 | Chile | Tarapaca | 40311 | 782 | 39315 | 214 | -19.9232 | -69.5132 | 2021-08-01 04:21:50 | Tarapaca, Chile | ||
2673643 | 2673643 | 2021-07-18 | China | Yunnan | 599 | 2 | 383 | 214 | 24.974 | 101.487 | 2021-07-19 04:21:24 | Yunnan, China | ||
1444218 | 1444218 | 2021-07-07 | Ukraine | Mykolaiv Oblast | 70048 | 1851 | 67983 | 214 | 46.975 | 31.9946 | 2021-07-08 04:21:26 | Mykolaiv Oblast, Ukraine | ||
1936070 | 1936070 | 2021-07-05 | Ukraine | Luhansk Oblast | 26642 | 949 | 25479 | 214 | 48.574 | 39.3078 | 2021-07-06 04:21:32 | Luhansk Oblast, Ukraine | ||
2422875 | 2422875 | 2021-06-23 | Italy | Liguria | 103372 | 4349 | 98809 | 214 | 44.41149315 | 8.9326992 | 2021-06-24 04:21:55 | Liguria, Italy | ||
1125505 | 1125505 | 2021-06-18 | Germany | Bremen | 27370 | 482 | 26680 | 214 | 53.0793 | 8.8017 | 2021-06-19 04:22:33 | Bremen, Germany | ||
522866 | 522866 | 2021-06-09 | Japan | Gunma | 7951 | 146 | 7591 | 214 | 36.504479 | 138.985605 | 2021-06-10 04:23:17 | Gunma, Japan | ||
825805 | 825805 | 2021-06-06 | Russia | Mari El Republic | 13643 | 257 | 13172 | 214 | 56.5767504 | 47.8817512 | 2021-06-07 04:22:51 | Mari El Republic, Russia | ||
2315172 | 2315172 | 2021-06-04 | Cote d'Ivoire | 47435 | 306 | 46915 | 214 | 7.54 | -5.5471 | 2021-06-05 04:23:03 | Cote d'Ivoire | |||
2104154 | 2104154 | 2021-06-01 | Japan | Nagano | 4807 | 84 | 4509 | 214 | 36.132134 | 138.045528 | 2021-06-02 04:24:34 | Nagano, Japan | ||
1806779 | 1806779 | 2021-05-27 | Japan | Saga | 2471 | 19 | 2238 | 214 | 33.286977 | 130.115738 | 2021-05-28 04:20:36 | Saga, Japan | ||
83291 | 83291 | 2021-05-25 | Russia | Ingushetia Republic | 15708 | 189 | 15305 | 214 | 43.11542075 | 45.01713552 | 2021-05-26 04:20:35 | Ingushetia Republic, Russia | ||
2255779 | 2255779 | 2021-05-19 | Japan | Yamagata | 1775 | 37 | 1524 | 214 | 38.448396 | 140.102154 | 2021-05-20 04:21:05 | Yamagata, Japan | ||
1082130 | 1082130 | 2021-05-14 | Russia | Karachay-Cherkess Republic | 20235 | 92 | 19929 | 214 | 43.7368326 | 41.7267991 | 2021-05-15 04:20:58 | Karachay-Cherkess Republic, Russia | ||
3054127 | 3054127 | 2021-05-13 | India | Andaman and Nicobar Islands | 6510 | 83 | 6213 | 214 | 11.225999 | 92.968178 | 2021-05-14 04:20:41 | Andaman and Nicobar Islands, India | ||
2004597 | 2004597 | 2021-05-12 | India | Andaman and Nicobar Islands | 6470 | 81 | 6175 | 214 | 11.225999 | 92.968178 | 2021-05-13 04:20:51 | Andaman and Nicobar Islands, India | ||
1636186 | 1636186 | 2021-04-29 | Cote d'Ivoire | 45998 | 286 | 45498 | 214 | 7.54 | -5.5471 | 2021-04-30 04:21:03 | Cote d'Ivoire | |||
2020563 | 2020563 | 2021-04-20 | Colombia | Caqueta | 17347 | 654 | 16479 | 214 | 0.8699 | -73.8419 | 2021-04-21 04:21:14 | Caqueta, Colombia | ||
2571717 | 2571717 | 2021-04-13 | Japan | Shizuoka | 5995 | 121 | 5660 | 214 | 34.916975 | 138.40778400000002 | 2021-04-14 04:20:41 | Shizuoka, Japan | ||
3085080 | 3085080 | 2021-04-05 | Chad | 4595 | 166 | 4215 | 214 | 15.4542 | 18.7322 | 2021-04-06 04:20:32 | Chad | |||
1219577 | 1219577 | 2021-03-27 | Japan | Gunma | 4929 | 99 | 4616 | 214 | 36.504479 | 138.985605 | 2021-03-28 05:28:10 | Gunma, Japan | ||
3621043 | 3621043 | 2021-03-17 | India | Puducherry | 40120 | 673 | 39233 | 214 | 11.882658 | 78.86498 | 2021-03-18 05:26:22 | Puducherry, India | ||
3962399 | 3962399 | 2021-03-10 | Djibouti | 6227 | 63 | 5950 | 214 | 11.8251 | 42.5903 | 2021-03-11 05:25:48 | Djibouti | |||
54812 | 54812 | 2021-03-07 | Japan | Fukushima | 2095 | 81 | 1800 | 214 | 37.378867 | 140.223295 | 2021-03-08 05:24:48 | Fukushima, Japan | ||
3667477 | 3667477 | 2021-03-06 | Colombia | Putumayo | 7929 | 315 | 7400 | 214 | 0.436 | -75.5277 | 2021-03-07 05:21:54 | Putumayo, Colombia | ||
1616098 | 1616098 | 2021-03-05 | Colombia | Putumayo | 7929 | 315 | 7400 | 214 | 0.436 | -75.5277 | 2021-03-06 04:23:41 | Putumayo, Colombia | ||
1092172 | 1092172 | 2021-03-03 | US | Nebraska | Pawnee | 31133 | 215 | 1 | 0 | 214 | 40.13141096 | -96.23705437 | 2021-03-04 05:24:24 | Pawnee, Nebraska, US |
3254887 | 3254887 | 2021-03-02 | US | Georgia | Baker | 13007 | 221 | 7 | 0 | 214 | 31.32669878 | -84.44218806 | 2021-03-03 05:23:28 | Baker, Georgia, US |
3254185 | 3254185 | 2021-03-02 | Japan | Shizuoka | 5169 | 93 | 4862 | 214 | 34.916975 | 138.40778400000002 | 2021-03-03 05:23:28 | Shizuoka, Japan | ||
999179 | 999179 | 2021-03-01 | US | Georgia | Baker | 13007 | 221 | 7 | 0 | 214 | 31.32669878 | -84.44218806 | 2021-03-02 05:23:30 | Baker, Georgia, US |
2368237 | 2368237 | 2021-02-28 | US | Georgia | Baker | 13007 | 221 | 7 | 0 | 214 | 31.32669878 | -84.44218806 | 2021-03-01 05:23:01 | Baker, Georgia, US |
3066071 | 3066071 | 2021-02-27 | Mauritania | 17196 | 440 | 16542 | 214 | 21.0079 | -10.9408 | 2021-02-28 05:22:20 | Mauritania | |||
2183655 | 2183655 | 2021-02-26 | Mauritania | 17187 | 439 | 16534 | 214 | 21.0079 | -10.9408 | 2021-02-27 05:22:28 | Mauritania | |||
532914 | 532914 | 2021-02-22 | US | New Mexico | Union | 35059 | 223 | 9 | 0 | 214 | 36.48126404 | -103.4709624 | 2021-02-23 05:23:41 | Union, New Mexico, US |
532353 | 532353 | 2021-02-22 | US | Michigan | Luce | 26095 | 215 | 1 | 0 | 214 | 46.47227431 | -85.54471223 | 2021-02-23 05:23:41 | Luce, Michigan, US |
183687 | 183687 | 2021-02-21 | US | Michigan | Luce | 26095 | 215 | 1 | 0 | 214 | 46.47227431 | -85.54471223 | 2021-02-22 05:24:21 | Luce, Michigan, US |
743961 | 743961 | 2021-02-20 | US | Michigan | Luce | 26095 | 215 | 1 | 0 | 214 | 46.47227431 | -85.54471223 | 2021-02-21 05:24:33 | Luce, Michigan, US |
473059 | 473059 | 2021-02-19 | US | Michigan | Luce | 26095 | 215 | 1 | 0 | 214 | 46.47227431 | -85.54471223 | 2021-02-20 05:22:51 | Luce, Michigan, US |
3052180 | 3052180 | 2021-02-16 | US | Montana | Mineral | 30061 | 214 | 0 | 0 | 214 | 47.15283992 | -115.0015239 | 2021-02-17 05:23:10 | Mineral, Montana, US |
1338313 | 1338313 | 2021-02-15 | Japan | Shizuoka | 4857 | 92 | 4551 | 214 | 34.916975 | 138.40778400000002 | 2021-02-16 05:24:38 | Shizuoka, Japan | ||
2283464 | 2283464 | 2021-02-14 | Japan | Shizuoka | 4847 | 92 | 4541 | 214 | 34.916975 | 138.40778400000002 | 2021-02-15 05:24:49 | Shizuoka, Japan | ||
2637531 | 2637531 | 2021-02-11 | China | Heilongjiang | 1609 | 13 | 1382 | 214 | 47.862 | 127.7615 | 2021-02-12 05:23:29 | Heilongjiang, China | ||
616895 | 616895 | 2021-02-08 | US | Texas | Schleicher | 48413 | 167 | 6 | 0 | 214 | 30.89740592 | -100.5384842 | 2021-02-09 05:23:30 | Schleicher, Texas, US |
1675664 | 1675664 | 2021-02-07 | US | Texas | Schleicher | 48413 | 167 | 6 | 0 | 214 | 30.89740592 | -100.5384842 | 2021-02-08 05:22:39 | Schleicher, Texas, US |
978125 | 978125 | 2021-02-06 | US | Texas | Schleicher | 48413 | 167 | 6 | 0 | 214 | 30.89740592 | -100.5384842 | 2021-02-07 05:23:00 | Schleicher, Texas, US |
792387 | 792387 | 2021-02-04 | US | Montana | Mineral | 30061 | 214 | 0 | 0 | 214 | 47.15283992 | -115.0015239 | 2021-02-05 05:22:38 | Mineral, Montana, US |
343590 | 343590 | 2021-02-03 | US | Virginia | Craig | 51045 | 217 | 3 | 0 | 214 | 37.48133648 | -80.21072274 | 2021-02-04 05:22:26 | Craig, Virginia, US |
343008 | 343008 | 2021-02-03 | US | Puerto Rico | Guayanilla | 72059 | 214 | 0 | 0 | 214 | 18.039942 | -66.79186 | 2021-02-04 05:22:26 | Guayanilla, Puerto Rico, US |
342279 | 342279 | 2021-02-03 | US | Montana | Mineral | 30061 | 214 | 0 | 0 | 214 | 47.15283992 | -115.0015239 | 2021-02-04 05:22:26 | Mineral, Montana, US |
1687967 | 1687967 | 2021-02-02 | US | West Virginia | Calhoun | 54013 | 214 | 0 | 0 | 214 | 38.84315422 | -81.11934872 | 2021-02-03 05:22:52 | Calhoun, West Virginia, US |
1687816 | 1687816 | 2021-02-02 | US | Virginia | Craig | 51045 | 217 | 3 | 0 | 214 | 37.48133648 | -80.21072274 | 2021-02-03 05:22:52 | Craig, Virginia, US |
1687234 | 1687234 | 2021-02-02 | US | Puerto Rico | Guayanilla | 72059 | 214 | 0 | 0 | 214 | 18.039942 | -66.79186 | 2021-02-03 05:22:52 | Guayanilla, Puerto Rico, US |
1684771 | 1684771 | 2021-02-02 | Sao Tome and Principe | 1283 | 17 | 1052 | 214 | 0.1864 | 6.6131 | 2021-02-03 05:22:52 | Sao Tome and Principe | |||
1679937 | 1679937 | 2021-02-01 | US | West Virginia | Calhoun | 54013 | 214 | 0 | 0 | 214 | 38.84315422 | -81.11934872 | 2021-02-02 05:22:49 | Calhoun, West Virginia, US |
1678852 | 1678852 | 2021-02-01 | US | North Dakota | Burke | 38013 | 214 | 1 | 0 | 214 | 48.79094471 | -102.5182117 | 2021-02-02 05:22:49 | Burke, North Dakota, US |
1463225 | 1463225 | 2021-01-31 | US | West Virginia | Calhoun | 54013 | 214 | 0 | 0 | 214 | 38.84315422 | -81.11934872 | 2021-02-01 05:22:53 | Calhoun, West Virginia, US |
1462140 | 1462140 | 2021-01-31 | US | North Dakota | Burke | 38013 | 213 | 1 | 0 | 214 | 48.79094471 | -102.5182117 | 2021-02-01 05:22:53 | Burke, North Dakota, US |
2483913 | 2483913 | 2021-01-28 | US | Missouri | Putnam | 29171 | 216 | 2 | 0 | 214 | 40.47942497 | -93.02042674 | 2021-01-29 05:22:23 | Putnam, Missouri, US |
3155548 | 3155548 | 2021-01-27 | US | Missouri | Putnam | 29171 | 216 | 2 | 0 | 214 | 40.47942497 | -93.02042674 | 2021-01-28 05:22:24 | Putnam, Missouri, US |
14283 | 14283 | 2021-01-26 | US | Missouri | Putnam | 29171 | 216 | 2 | 0 | 214 | 40.47942497 | -93.02042674 | 2021-01-27 05:23:41 | Putnam, Missouri, US |
2569607 | 2569607 | 2021-01-25 | US | Missouri | Putnam | 29171 | 216 | 2 | 0 | 214 | 40.47942497 | -93.02042674 | 2021-01-26 05:22:02 | Putnam, Missouri, US |
1762061 | 1762061 | 2021-01-24 | US | Puerto Rico | Sabana Grande | 72121 | 214 | 0 | 0 | 214 | 18.08282 | -66.943758 | 2021-01-25 05:22:16 | Sabana Grande, Puerto Rico, US |
1761239 | 1761239 | 2021-01-24 | US | Missouri | Putnam | 29171 | 216 | 2 | 0 | 214 | 40.47942497 | -93.02042674 | 2021-01-25 05:22:16 | Putnam, Missouri, US |
1760592 | 1760592 | 2021-01-24 | US | Kansas | Kiowa | 20097 | 218 | 4 | 0 | 214 | 37.55848695 | -99.2856537 | 2021-01-25 05:22:16 | Kiowa, Kansas, US |
2428199 | 2428199 | 2021-01-23 | US | Kansas | Kiowa | 20097 | 218 | 4 | 0 | 214 | 37.55848695 | -99.2856537 | 2021-01-24 05:22:35 | Kiowa, Kansas, US |
2468101 | 2468101 | 2021-01-22 | US | Kansas | Kiowa | 20097 | 218 | 4 | 0 | 214 | 37.55848695 | -99.2856537 | 2021-01-23 05:22:03 | Kiowa, Kansas, US |
1096778 | 1096778 | 2021-01-20 | US | Pennsylvania | Sullivan | 42113 | 222 | 8 | 0 | 214 | 41.44634738 | -76.51246591 | 2021-01-21 05:22:01 | Sullivan, Pennsylvania, US |
3518283 | 3518283 | 2021-01-15 | US | South Dakota | McPherson | 46089 | 217 | 3 | 0 | 214 | 45.76626028 | -99.22118798 | 2021-01-16 05:22:40 | McPherson, South Dakota, US |
3518123 | 3518123 | 2021-01-15 | US | Puerto Rico | Ceiba | 72037 | 214 | 0 | 0 | 214 | 18.251818 | -65.666416 | 2021-01-16 05:22:40 | Ceiba, Puerto Rico, US |
3880831 | 3880831 | 2021-01-14 | US | Kansas | Chase | 20017 | 217 | 3 | 0 | 214 | 38.30292938 | -96.59563862 | 2021-01-15 05:22:24 | Chase, Kansas, US |
3310576 | 3310576 | 2021-01-13 | US | North Dakota | Adams | 38001 | 219 | 2 | 0 | 214 | 46.09686891 | -102.5285397 | 2021-01-14 05:22:32 | Adams, North Dakota, US |
3309458 | 3309458 | 2021-01-13 | US | Kansas | Chase | 20017 | 217 | 3 | 0 | 214 | 38.30292938 | -96.59563862 | 2021-01-14 05:22:32 | Chase, Kansas, US |
775603 | 775603 | 2021-01-12 | US | Kansas | Chase | 20017 | 217 | 3 | 0 | 214 | 38.30292938 | -96.59563862 | 2021-01-13 05:22:15 | Chase, Kansas, US |
191324 | 191324 | 2021-01-11 | US | Kansas | Chase | 20017 | 217 | 3 | 0 | 214 | 38.30292938 | -96.59563862 | 2021-01-12 05:22:15 | Chase, Kansas, US |
2628261 | 2628261 | 2021-01-10 | US | North Dakota | Golden Valley | 38033 | 218 | 0 | 0 | 214 | 46.94022281 | -103.8465421 | 2021-01-11 05:21:50 | Golden Valley, North Dakota, US |
2627127 | 2627127 | 2021-01-10 | US | Kansas | Chase | 20017 | 217 | 3 | 0 | 214 | 38.30292938 | -96.59563862 | 2021-01-11 05:21:50 | Chase, Kansas, US |
3901215 | 3901215 | 2021-01-09 | US | Kansas | Chase | 20017 | 217 | 3 | 0 | 214 | 38.30292938 | -96.59563862 | 2021-01-10 05:22:12 | Chase, Kansas, US |
3899794 | 3899794 | 2021-01-09 | Colombia | Arauca | 4757 | 137 | 4406 | 214 | 7.0762 | -70.7105 | 2021-01-10 05:22:12 | Arauca, Colombia | ||
157117 | 157117 | 2021-01-08 | US | Texas | Kinney | 48271 | 270 | 3 | 0 | 214 | 29.34967888 | -100.4186638 | 2021-01-09 05:22:18 | Kinney, Texas, US |
156597 | 156597 | 2021-01-08 | US | Oregon | Lake | 41037 | 218 | 4 | 0 | 214 | 42.79246693 | -120.3850163 | 2021-01-09 05:22:18 | Lake, Oregon, US |
155238 | 155238 | 2021-01-08 | US | Kansas | Chase | 20017 | 217 | 3 | 0 | 214 | 38.30292938 | -96.59563862 | 2021-01-09 05:22:18 | Chase, Kansas, US |
2866664 | 2866664 | 2021-01-06 | US | Missouri | Schuyler | 29197 | 215 | 1 | 0 | 214 | 40.46921489 | -92.52311943 | 2021-01-07 05:22:03 | Schuyler, Missouri, US |
2865150 | 2865150 | 2021-01-06 | US | Alaska | Yukon-Koyukuk | 2290 | 218 | 4 | 0 | 214 | 65.50815459 | -151.3907387 | 2021-01-07 05:22:03 | Yukon-Koyukuk, Alaska, US |
3037508 | 3037508 | 2021-01-05 | US | Texas | Schleicher | 48413 | 167 | 6 | 0 | 214 | 30.89740592 | -100.5384842 | 2021-01-06 05:22:16 | Schleicher, Texas, US |
3037345 | 3037345 | 2021-01-05 | US | Texas | Collingsworth | 48087 | 274 | 5 | 0 | 214 | 34.96489496 | -100.2700111 | 2021-01-06 05:22:16 | Collingsworth, Texas, US |
3231435 | 3231435 | 2021-01-03 | US | Illinois | Hardin | 17069 | 221 | 7 | 0 | 214 | 37.51810645 | -88.26873022 | 2021-01-04 05:22:02 | Hardin, Illinois, US |
1138645 | 1138645 | 2021-01-01 | US | Minnesota | Traverse | 27155 | 216 | 2 | 0 | 214 | 45.77298854 | -96.47062949 | 2021-01-02 05:22:33 | Traverse, Minnesota, US |
1138319 | 1138319 | 2021-01-01 | US | Kentucky | Menifee | 21165 | 215 | 1 | 0 | 214 | 37.94090733 | -83.59985712 | 2021-01-02 05:22:33 | Menifee, Kentucky, US |
3697251 | 3697251 | 2020-12-31 | US | Minnesota | Traverse | 27155 | 216 | 2 | 0 | 214 | 45.77298854 | -96.47062949 | 2021-01-01 05:23:07 | Traverse, Minnesota, US |
3696925 | 3696925 | 2020-12-31 | US | Kentucky | Menifee | 21165 | 215 | 1 | 0 | 214 | 37.94090733 | -83.59985712 | 2021-01-01 05:23:07 | Menifee, Kentucky, US |
1013186 | 1013186 | 2020-12-30 | US | South Dakota | Mellette | 46095 | 216 | 2 | 0 | 214 | 43.58078848 | -100.7563186 | 2020-12-31 05:22:49 | Mellette, South Dakota, US |
1011740 | 1011740 | 2020-12-30 | US | Kentucky | Menifee | 21165 | 215 | 1 | 0 | 214 | 37.94090733 | -83.59985712 | 2020-12-31 05:22:49 | Menifee, Kentucky, US |
3778334 | 3778334 | 2020-12-27 | US | Alaska | Unassigned | 90002 | 214 | 0 | 0 | 214 | 69.31479216 | 0.0 | 2020-12-28 05:22:06 | Unassigned, Alaska, US |
205897 | 205897 | 2020-12-25 | United Kingdom | Bermuda | 561 | 9 | 338 | 214 | 32.3078 | -64.7505 | 2020-12-26 05:22:28 | Bermuda, United Kingdom | ||
2406850 | 2406850 | 2020-12-23 | Japan | Kochi | 573 | 6 | 353 | 214 | 33.422519 | 133.367307 | 2020-12-24 05:23:04 | Kochi, Japan | ||
3773042 | 3773042 | 2020-12-22 | US | Texas | Mills | 48333 | 278 | 10 | 0 | 214 | 31.49557106 | -98.59272068 | 2020-12-23 05:22:03 | Mills, Texas, US |
929638 | 929638 | 2020-12-21 | US | Missouri | Reynolds | 29179 | 216 | 2 | 0 | 214 | 37.36085952 | -90.97009925 | 2020-12-22 05:22:33 | Reynolds, Missouri, US |
2121663 | 2121663 | 2020-12-20 | US | Missouri | Scotland | 29199 | 217 | 3 | 0 | 214 | 40.45214695 | -92.14709064 | 2020-12-21 05:27:58 | Scotland, Missouri, US |
2121070 | 2121070 | 2020-12-20 | US | Kentucky | Ballard | 21007 | 217 | 3 | 0 | 214 | 37.05842757 | -88.99427697 | 2020-12-21 05:27:58 | Ballard, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);