johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
791 rows where active = 211 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331870 | 331870 | 2021-08-04 | India | Rajasthan | 953733 | 8954 | 944568 | 211 | 26.583423 | 73.847973 | 2021-08-05 04:21:51 | Rajasthan, India | ||
1378514 | 1378514 | 2021-07-25 | Japan | Fukushima | 5326 | 162 | 4953 | 211 | 37.378867 | 140.223295 | 2021-07-26 04:21:28 | Fukushima, Japan | ||
3137581 | 3137581 | 2021-07-23 | Japan | Okayama | 7810 | 127 | 7472 | 211 | 34.89246 | 133.826252 | 2021-07-24 00:21:36 | Okayama, Japan | ||
3137344 | 3137344 | 2021-07-23 | Chile | Nuble | 35061 | 612 | 34238 | 211 | -36.7226 | -71.7622 | 2021-07-24 00:21:36 | Nuble, Chile | ||
3476104 | 3476104 | 2021-07-22 | Chile | Nuble | 35028 | 611 | 34206 | 211 | -36.7226 | -71.7622 | 2021-07-23 04:21:29 | Nuble, Chile | ||
3331759 | 3331759 | 2021-07-21 | Russia | Nenets Autonomous Okrug | 1450 | 10 | 1229 | 211 | 68.27557185 | 57.1686375 | 2021-07-22 04:21:19 | Nenets Autonomous Okrug, Russia | ||
483786 | 483786 | 2021-07-19 | Russia | Chukotka Autonomous Okrug | 991 | 8 | 772 | 211 | 66.0006475 | 169.4900869 | 2021-07-20 04:21:48 | Chukotka Autonomous Okrug, Russia | ||
2674009 | 2674009 | 2021-07-18 | Russia | Chukotka Autonomous Okrug | 984 | 8 | 765 | 211 | 66.0006475 | 169.4900869 | 2021-07-19 04:21:24 | Chukotka Autonomous Okrug, Russia | ||
625832 | 625832 | 2021-07-10 | India | Lakshadweep | 10011 | 49 | 9751 | 211 | 13.6999972 | 72.18333259999999 | 2021-07-11 04:21:43 | Lakshadweep, India | ||
1499235 | 1499235 | 2021-07-03 | Ukraine | Luhansk Oblast | 26639 | 949 | 25479 | 211 | 48.574 | 39.3078 | 2021-07-04 04:21:38 | Luhansk Oblast, Ukraine | ||
2075559 | 2075559 | 2021-07-02 | Ukraine | Vinnytsia Oblast | 71108 | 1690 | 69207 | 211 | 49.2331 | 28.4682 | 2021-07-03 04:21:37 | Vinnytsia Oblast, Ukraine | ||
1893411 | 1893411 | 2021-06-30 | Saint Vincent and the Grenadines | 2225 | 12 | 2002 | 211 | 12.9843 | -61.2872 | 2021-07-01 04:21:19 | Saint Vincent and the Grenadines | |||
400534 | 400534 | 2021-06-29 | Saint Vincent and the Grenadines | 2225 | 12 | 2002 | 211 | 12.9843 | -61.2872 | 2021-06-30 04:21:41 | Saint Vincent and the Grenadines | |||
1125630 | 1125630 | 2021-06-18 | Japan | Shiga | 5474 | 88 | 5175 | 211 | 35.21582700000001 | 136.138064 | 2021-06-19 04:22:33 | Shiga, Japan | ||
2586256 | 2586256 | 2021-06-05 | Saint Vincent and the Grenadines | 2068 | 12 | 1845 | 211 | 12.9843 | -61.2872 | 2021-06-06 04:24:03 | Saint Vincent and the Grenadines | |||
2586210 | 2586210 | 2021-06-05 | Russia | Mari El Republic | 13622 | 255 | 13156 | 211 | 56.5767504 | 47.8817512 | 2021-06-06 04:24:03 | Mari El Republic, Russia | ||
1708517 | 1708517 | 2021-06-02 | Russia | Karachay-Cherkess Republic | 20472 | 139 | 20122 | 211 | 43.7368326 | 41.7267991 | 2021-06-03 04:23:32 | Karachay-Cherkess Republic, Russia | ||
20389 | 20389 | 2021-05-28 | Japan | Kochi | 1398 | 20 | 1167 | 211 | 33.422519 | 133.367307 | 2021-05-29 04:20:41 | Kochi, Japan | ||
1413329 | 1413329 | 2021-05-24 | Senegal | 41142 | 1132 | 39799 | 211 | 14.4974 | -14.4524 | 2021-05-25 04:21:08 | Senegal | |||
726694 | 726694 | 2021-05-22 | Russia | Ingushetia Republic | 15677 | 188 | 15278 | 211 | 43.11542075 | 45.01713552 | 2021-05-23 04:20:51 | Ingushetia Republic, Russia | ||
1913227 | 1913227 | 2021-05-20 | Japan | Iwate | 1300 | 42 | 1047 | 211 | 39.593287 | 141.361777 | 2021-05-21 04:20:43 | Iwate, Japan | ||
3574611 | 3574611 | 2021-05-17 | Japan | Iwate | 1241 | 40 | 990 | 211 | 39.593287 | 141.361777 | 2021-05-18 04:20:33 | Iwate, Japan | ||
3054049 | 3054049 | 2021-05-13 | Colombia | San Andres y Providencia | 4303 | 65 | 4027 | 211 | 12.5567 | -81.7185 | 2021-05-14 04:20:41 | San Andres y Providencia, Colombia | ||
1424888 | 1424888 | 2021-05-09 | Chile | Aysen | 4576 | 31 | 4334 | 211 | -45.9864 | -73.7669 | 2021-05-10 04:20:38 | Aysen, Chile | ||
1551907 | 1551907 | 2021-05-08 | India | Andaman and Nicobar Islands | 6341 | 74 | 6056 | 211 | 11.225999 | 92.968178 | 2021-05-09 04:20:35 | Andaman and Nicobar Islands, India | ||
2450789 | 2450789 | 2021-05-02 | Japan | Kagoshima | 2225 | 28 | 1986 | 211 | 31.009484000000004 | 130.430665 | 2021-05-03 04:20:39 | Kagoshima, Japan | ||
2450557 | 2450557 | 2021-05-02 | Chile | Aysen | 4371 | 30 | 4130 | 211 | -45.9864 | -73.7669 | 2021-05-03 04:20:39 | Aysen, Chile | ||
1640001 | 1640001 | 2021-04-29 | Malaysia | Terengganu | 4158 | 14 | 3933 | 211 | 5.3117 | 103.1324 | 2021-04-30 04:21:03 | Terengganu, Malaysia | ||
3393175 | 3393175 | 2021-04-28 | Chad | 4789 | 170 | 4408 | 211 | 15.4542 | 18.7322 | 2021-04-29 04:20:55 | Chad | |||
954650 | 954650 | 2021-04-25 | Chile | Aysen | 4148 | 30 | 3907 | 211 | -45.9864 | -73.7669 | 2021-04-26 04:21:04 | Aysen, Chile | ||
3883346 | 3883346 | 2021-04-11 | Burkina Faso | 12956 | 152 | 12593 | 211 | 12.2383 | -1.5616 | 2021-04-12 04:21:00 | Burkina Faso | |||
2983014 | 2983014 | 2021-04-10 | Burkina Faso | 12956 | 152 | 12593 | 211 | 12.2383 | -1.5616 | 2021-04-11 04:20:56 | Burkina Faso | |||
241012 | 241012 | 2021-04-02 | Burkina Faso | 12791 | 150 | 12430 | 211 | 12.2383 | -1.5616 | 2021-04-03 04:20:44 | Burkina Faso | |||
1880796 | 1880796 | 2021-03-26 | China | Hong Kong | 11439 | 205 | 11023 | 211 | 22.3 | 114.2 | 2021-03-27 05:25:04 | Hong Kong, China | ||
1204140 | 1204140 | 2021-03-22 | Timor-Leste | 335 | 0 | 124 | 211 | -8.874217 | 125.727539 | 2021-03-23 05:26:18 | Timor-Leste | |||
54828 | 54828 | 2021-03-07 | Japan | Miyagi | 3790 | 25 | 3554 | 211 | 38.446859 | 140.927086 | 2021-03-08 05:24:48 | Miyagi, Japan | ||
3670020 | 3670020 | 2021-03-06 | US | North Dakota | Logan | 38047 | 219 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-03-07 05:21:54 | Logan, North Dakota, US |
3667694 | 3667694 | 2021-03-06 | Mauritania | 17309 | 442 | 16656 | 211 | 21.0079 | -10.9408 | 2021-03-07 05:21:54 | Mauritania | |||
1618641 | 1618641 | 2021-03-05 | US | North Dakota | Logan | 38047 | 219 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-03-06 04:23:41 | Logan, North Dakota, US |
2210052 | 2210052 | 2021-03-04 | US | North Dakota | Logan | 38047 | 219 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-03-05 05:26:29 | Logan, North Dakota, US |
280923 | 280923 | 2021-02-24 | US | Georgia | Baker | 13007 | 218 | 7 | 0 | 211 | 31.32669878 | -84.44218806 | 2021-02-25 05:24:57 | Baker, Georgia, US |
1937191 | 1937191 | 2021-02-23 | US | Georgia | Baker | 13007 | 218 | 7 | 0 | 211 | 31.32669878 | -84.44218806 | 2021-02-24 05:29:16 | Baker, Georgia, US |
531446 | 531446 | 2021-02-22 | US | Georgia | Baker | 13007 | 218 | 7 | 0 | 211 | 31.32669878 | -84.44218806 | 2021-02-23 05:23:41 | Baker, Georgia, US |
183764 | 183764 | 2021-02-21 | US | Minnesota | Lake of the Woods | 27077 | 212 | 1 | 0 | 211 | 48.77217001 | -94.90274472 | 2021-02-22 05:24:21 | Lake of the Woods, Minnesota, US |
744038 | 744038 | 2021-02-20 | US | Minnesota | Lake of the Woods | 27077 | 212 | 1 | 0 | 211 | 48.77217001 | -94.90274472 | 2021-02-21 05:24:33 | Lake of the Woods, Minnesota, US |
473136 | 473136 | 2021-02-19 | US | Minnesota | Lake of the Woods | 27077 | 212 | 1 | 0 | 211 | 48.77217001 | -94.90274472 | 2021-02-20 05:22:51 | Lake of the Woods, Minnesota, US |
1154845 | 1154845 | 2021-02-18 | US | Minnesota | Lake of the Woods | 27077 | 212 | 1 | 0 | 211 | 48.77217001 | -94.90274472 | 2021-02-19 05:24:16 | Lake of the Woods, Minnesota, US |
3603080 | 3603080 | 2021-02-17 | US | Nebraska | Brown | 31017 | 213 | 2 | 0 | 211 | 42.43018907 | -99.92904055 | 2021-02-18 05:22:58 | Brown, Nebraska, US |
3602765 | 3602765 | 2021-02-17 | US | Minnesota | Lake of the Woods | 27077 | 212 | 1 | 0 | 211 | 48.77217001 | -94.90274472 | 2021-02-18 05:22:58 | Lake of the Woods, Minnesota, US |
3052215 | 3052215 | 2021-02-16 | US | Nebraska | Brown | 31017 | 213 | 2 | 0 | 211 | 42.43018907 | -99.92904055 | 2021-02-17 05:23:10 | Brown, Nebraska, US |
3051900 | 3051900 | 2021-02-16 | US | Minnesota | Lake of the Woods | 27077 | 212 | 1 | 0 | 211 | 48.77217001 | -94.90274472 | 2021-02-17 05:23:10 | Lake of the Woods, Minnesota, US |
1340314 | 1340314 | 2021-02-15 | US | Nebraska | Brown | 31017 | 213 | 2 | 0 | 211 | 42.43018907 | -99.92904055 | 2021-02-16 05:24:38 | Brown, Nebraska, US |
1339999 | 1339999 | 2021-02-15 | US | Minnesota | Lake of the Woods | 27077 | 212 | 1 | 0 | 211 | 48.77217001 | -94.90274472 | 2021-02-16 05:24:38 | Lake of the Woods, Minnesota, US |
2285430 | 2285430 | 2021-02-14 | US | Montana | Mineral | 30061 | 211 | 0 | 0 | 211 | 47.15283992 | -115.0015239 | 2021-02-15 05:24:49 | Mineral, Montana, US |
3542218 | 3542218 | 2021-02-12 | US | Puerto Rico | Patillas | 72109 | 211 | 0 | 0 | 211 | 18.03174 | -66.012242 | 2021-02-13 05:22:12 | Patillas, Puerto Rico, US |
3539489 | 3539489 | 2021-02-12 | Japan | Okayama | 2438 | 28 | 2199 | 211 | 34.89246 | 133.826252 | 2021-02-13 05:22:12 | Okayama, Japan | ||
3539152 | 3539152 | 2021-02-12 | Antigua and Barbuda | 419 | 9 | 199 | 211 | 17.0608 | -61.7964 | 2021-02-13 05:22:12 | Antigua and Barbuda | |||
2640481 | 2640481 | 2021-02-11 | US | Puerto Rico | Patillas | 72109 | 211 | 0 | 0 | 211 | 18.03174 | -66.012242 | 2021-02-12 05:23:29 | Patillas, Puerto Rico, US |
3980224 | 3980224 | 2021-02-10 | US | Michigan | Luce | 26095 | 212 | 1 | 0 | 211 | 46.47227431 | -85.54471223 | 2021-02-11 05:23:55 | Luce, Michigan, US |
1529544 | 1529544 | 2021-02-09 | US | Michigan | Luce | 26095 | 212 | 1 | 0 | 211 | 46.47227431 | -85.54471223 | 2021-02-10 05:22:41 | Luce, Michigan, US |
616298 | 616298 | 2021-02-08 | US | Oregon | Harney | 41025 | 217 | 6 | 0 | 211 | 43.06422669 | -118.9666306 | 2021-02-09 05:23:30 | Harney, Oregon, US |
616086 | 616086 | 2021-02-08 | US | North Dakota | Logan | 38047 | 217 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-02-09 05:23:30 | Logan, North Dakota, US |
1675067 | 1675067 | 2021-02-07 | US | Oregon | Harney | 41025 | 217 | 6 | 0 | 211 | 43.06422669 | -118.9666306 | 2021-02-08 05:22:39 | Harney, Oregon, US |
1674855 | 1674855 | 2021-02-07 | US | North Dakota | Logan | 38047 | 217 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-02-08 05:22:39 | Logan, North Dakota, US |
1674461 | 1674461 | 2021-02-07 | US | Montana | Mineral | 30061 | 211 | 0 | 0 | 211 | 47.15283992 | -115.0015239 | 2021-02-08 05:22:39 | Mineral, Montana, US |
977316 | 977316 | 2021-02-06 | US | North Dakota | Logan | 38047 | 217 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-02-07 05:23:00 | Logan, North Dakota, US |
1590574 | 1590574 | 2021-02-05 | US | North Dakota | Logan | 38047 | 217 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-02-06 05:23:55 | Logan, North Dakota, US |
792781 | 792781 | 2021-02-04 | US | North Dakota | Logan | 38047 | 217 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-02-05 05:22:38 | Logan, North Dakota, US |
341828 | 341828 | 2021-02-03 | US | Maine | Piscataquis | 23021 | 212 | 1 | 0 | 211 | 45.83839062 | -69.2860223 | 2021-02-04 05:22:26 | Piscataquis, Maine, US |
1679204 | 1679204 | 2021-02-01 | US | Puerto Rico | Guayanilla | 72059 | 211 | 0 | 0 | 211 | 18.039942 | -66.79186 | 2021-02-02 05:22:49 | Guayanilla, Puerto Rico, US |
1462966 | 1462966 | 2021-01-31 | US | Texas | Schleicher | 48413 | 164 | 6 | 0 | 211 | 30.89740592 | -100.5384842 | 2021-02-01 05:22:53 | Schleicher, Texas, US |
2213671 | 2213671 | 2021-01-30 | US | Montana | Mineral | 30061 | 211 | 0 | 0 | 211 | 47.15283992 | -115.0015239 | 2021-01-31 05:22:42 | Mineral, Montana, US |
1900620 | 1900620 | 2021-01-29 | US | West Virginia | Calhoun | 54013 | 211 | 0 | 0 | 211 | 38.84315422 | -81.11934872 | 2021-01-30 05:22:49 | Calhoun, West Virginia, US |
3154403 | 3154403 | 2021-01-27 | US | Georgia | Glascock | 13125 | 221 | 10 | 0 | 211 | 33.22879932 | -82.61297636 | 2021-01-28 05:22:24 | Glascock, Georgia, US |
14414 | 14414 | 2021-01-26 | US | Nebraska | Hitchcock | 31087 | 214 | 3 | 0 | 211 | 40.17609175 | -101.0416477 | 2021-01-27 05:23:41 | Hitchcock, Nebraska, US |
13106 | 13106 | 2021-01-26 | US | Georgia | Clay | 13061 | 214 | 3 | 0 | 211 | 31.62221166 | -84.97713865 | 2021-01-27 05:23:41 | Clay, Georgia, US |
1759330 | 1759330 | 2021-01-24 | Japan | Saga | 899 | 4 | 684 | 211 | 33.286977 | 130.115738 | 2021-01-25 05:22:16 | Saga, Japan | ||
2469570 | 2469570 | 2021-01-22 | US | Puerto Rico | Sabana Grande | 72121 | 211 | 0 | 0 | 211 | 18.08282 | -66.943758 | 2021-01-23 05:22:03 | Sabana Grande, Puerto Rico, US |
438121 | 438121 | 2021-01-21 | US | Puerto Rico | Sabana Grande | 72121 | 211 | 0 | 0 | 211 | 18.08282 | -66.943758 | 2021-01-22 05:22:10 | Sabana Grande, Puerto Rico, US |
437299 | 437299 | 2021-01-21 | US | Missouri | Putnam | 29171 | 213 | 2 | 0 | 211 | 40.47942497 | -93.02042674 | 2021-01-22 05:22:10 | Putnam, Missouri, US |
1096852 | 1096852 | 2021-01-20 | US | Puerto Rico | Sabana Grande | 72121 | 211 | 0 | 0 | 211 | 18.08282 | -66.943758 | 2021-01-21 05:22:01 | Sabana Grande, Puerto Rico, US |
910868 | 910868 | 2021-01-19 | US | Pennsylvania | Sullivan | 42113 | 218 | 7 | 0 | 211 | 41.44634738 | -76.51246591 | 2021-01-20 05:21:54 | Sullivan, Pennsylvania, US |
910823 | 910823 | 2021-01-19 | US | Pennsylvania | Cameron | 42023 | 217 | 6 | 0 | 211 | 41.43625568 | -78.20376845 | 2021-01-20 05:21:54 | Cameron, Pennsylvania, US |
240629 | 240629 | 2021-01-18 | US | Virginia | Rappahannock | 51157 | 213 | 2 | 0 | 211 | 38.68295619 | -78.15826963 | 2021-01-19 05:22:15 | Rappahannock, Virginia, US |
237027 | 237027 | 2021-01-18 | Chile | Aysen | 2069 | 18 | 1840 | 211 | -45.9864 | -73.7669 | 2021-01-19 05:22:15 | Aysen, Chile | ||
3103802 | 3103802 | 2021-01-16 | US | North Carolina | Tyrrell | 37177 | 215 | 4 | 0 | 211 | 35.87147226 | -76.17055253 | 2021-01-17 05:22:17 | Tyrrell, North Carolina, US |
3882948 | 3882948 | 2021-01-14 | US | Virginia | Norton | 51720 | 214 | 3 | 0 | 211 | 36.93357076 | -82.62750411 | 2021-01-15 05:22:24 | Norton, Virginia, US |
3882332 | 3882332 | 2021-01-14 | US | Puerto Rico | Out of PR | 72888 | 211 | 0 | 0 | 211 | 18.459681 | -67.336525 | 2021-01-15 05:22:24 | Out of PR, Puerto Rico, US |
3880832 | 3880832 | 2021-01-14 | US | Kansas | Chautauqua | 20019 | 214 | 3 | 0 | 211 | 37.14994405 | -96.2454192 | 2021-01-15 05:22:24 | Chautauqua, Kansas, US |
3311335 | 3311335 | 2021-01-13 | US | Texas | Kimble | 48267 | 200 | 6 | 0 | 211 | 30.48678918 | -99.74856473 | 2021-01-14 05:22:32 | Kimble, Texas, US |
3310959 | 3310959 | 2021-01-13 | US | Puerto Rico | Out of PR | 72888 | 211 | 0 | 0 | 211 | 18.459681 | -67.336525 | 2021-01-14 05:22:32 | Out of PR, Puerto Rico, US |
3310262 | 3310262 | 2021-01-13 | US | Nebraska | Franklin | 31061 | 214 | 3 | 0 | 211 | 40.17636348 | -98.95299073 | 2021-01-14 05:22:32 | Franklin, Nebraska, US |
3309459 | 3309459 | 2021-01-13 | US | Kansas | Chautauqua | 20019 | 214 | 3 | 0 | 211 | 37.14994405 | -96.2454192 | 2021-01-14 05:22:32 | Chautauqua, Kansas, US |
776407 | 776407 | 2021-01-12 | US | Nebraska | Franklin | 31061 | 214 | 3 | 0 | 211 | 40.17636348 | -98.95299073 | 2021-01-13 05:22:15 | Franklin, Nebraska, US |
774939 | 774939 | 2021-01-12 | US | Colorado | Baca | 8009 | 243 | 2 | 0 | 211 | 37.31940883 | -102.5603223 | 2021-01-13 05:22:15 | Baca, Colorado, US |
192128 | 192128 | 2021-01-11 | US | Nebraska | Franklin | 31061 | 214 | 3 | 0 | 211 | 40.17636348 | -98.95299073 | 2021-01-12 05:22:15 | Franklin, Nebraska, US |
190499 | 190499 | 2021-01-11 | US | Alaska | Unassigned | 90002 | 211 | 0 | 0 | 211 | 69.31479216 | 0.0 | 2021-01-12 05:22:15 | Unassigned, Alaska, US |
2627931 | 2627931 | 2021-01-10 | US | Nebraska | Franklin | 31061 | 214 | 3 | 0 | 211 | 40.17636348 | -98.95299073 | 2021-01-11 05:21:50 | Franklin, Nebraska, US |
2625632 | 2625632 | 2021-01-10 | Burundi | 986 | 2 | 773 | 211 | -3.3731 | 29.9189 | 2021-01-11 05:21:50 | Burundi | |||
156379 | 156379 | 2021-01-08 | US | North Dakota | Logan | 38047 | 216 | 8 | 0 | 211 | 46.45729487 | -99.47719806 | 2021-01-09 05:22:18 | Logan, North Dakota, 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]);