johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
417 rows where confirmed = 2140 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754202 | 2754202 | 2022-12-29 | US | Kansas | Greenwood | 20073 | 2140 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-30 04:21:04 | Greenwood, Kansas, US | |
1075208 | 1075208 | 2022-12-28 | US | Kansas | Greenwood | 20073 | 2140 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-29 04:21:01 | Greenwood, Kansas, US | |
3554854 | 3554854 | 2022-11-27 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-28 04:21:02 | Rains, Texas, US | |
2103334 | 2103334 | 2022-11-26 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-27 04:21:05 | Rains, Texas, US | |
490825 | 490825 | 2022-11-25 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-26 04:21:11 | Rains, Texas, US | |
3526654 | 3526654 | 2022-11-24 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-25 04:21:06 | Rains, Texas, US | |
3315437 | 3315437 | 2022-11-23 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-24 04:21:09 | Rains, Texas, US | |
1623478 | 1623478 | 2022-11-22 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-23 04:21:06 | Rains, Texas, US | |
3463366 | 3463366 | 2022-11-21 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-22 04:20:47 | Rains, Texas, US | |
1643551 | 1643551 | 2022-11-20 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-21 04:21:05 | Rains, Texas, US | |
2067108 | 2067108 | 2022-11-19 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-20 04:21:08 | Rains, Texas, US | |
1758502 | 1758502 | 2022-11-18 | US | Texas | Rains | 48379 | 2140 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-11-19 04:21:14 | Rains, Texas, US | |
293549 | 293549 | 2022-11-15 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-16 04:21:09 | St. Helena, Louisiana, US | |
3598579 | 3598579 | 2022-11-14 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-15 04:21:16 | St. Helena, Louisiana, US | |
313437 | 313437 | 2022-11-13 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-14 04:21:09 | St. Helena, Louisiana, US | |
64598 | 64598 | 2022-11-12 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-13 04:21:14 | St. Helena, Louisiana, US | |
2928760 | 2928760 | 2022-11-11 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-12 04:20:41 | St. Helena, Louisiana, US | |
2507596 | 2507596 | 2022-11-10 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-11 04:21:22 | St. Helena, Louisiana, US | |
2432471 | 2432471 | 2022-11-09 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-10 04:21:16 | St. Helena, Louisiana, US | |
481127 | 481127 | 2022-11-08 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-09 04:21:22 | St. Helena, Louisiana, US | |
2440277 | 2440277 | 2022-11-07 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-08 04:21:21 | St. Helena, Louisiana, US | |
1051375 | 1051375 | 2022-11-06 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-07 04:21:26 | St. Helena, Louisiana, US | |
619399 | 619399 | 2022-11-05 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-06 04:21:24 | St. Helena, Louisiana, US | |
1023903 | 1023903 | 2022-11-04 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-05 04:21:52 | St. Helena, Louisiana, US | |
434365 | 434365 | 2022-11-03 | US | Tennessee | Van Buren | 47175 | 2140 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-11-04 04:22:11 | Van Buren, Tennessee, US | |
432894 | 432894 | 2022-11-03 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-04 04:22:11 | St. Helena, Louisiana, US | |
851136 | 851136 | 2022-11-02 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-03 04:22:05 | St. Helena, Louisiana, US | |
711987 | 711987 | 2022-11-01 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-02 04:22:09 | St. Helena, Louisiana, US | |
3286436 | 3286436 | 2022-10-31 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-11-01 04:22:36 | St. Helena, Louisiana, US | |
321469 | 321469 | 2022-10-30 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-31 04:21:36 | St. Helena, Louisiana, US | |
913745 | 913745 | 2022-10-29 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-30 04:22:14 | St. Helena, Louisiana, US | |
1368014 | 1368014 | 2022-10-28 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-29 04:21:13 | St. Helena, Louisiana, US | |
3039869 | 3039869 | 2022-10-27 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-28 04:22:31 | St. Helena, Louisiana, US | |
540289 | 540289 | 2022-10-26 | US | Louisiana | St. Helena | 22091 | 2140 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-27 04:22:01 | St. Helena, Louisiana, US | |
3280187 | 3280187 | 2022-10-23 | US | Virginia | Buena Vista | 51530 | 2140 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-10-24 04:22:29 | Buena Vista, Virginia, US | |
2271225 | 2271225 | 2022-10-22 | US | Virginia | Buena Vista | 51530 | 2140 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-10-23 04:22:46 | Buena Vista, Virginia, US | |
1595525 | 1595525 | 2022-10-21 | US | Virginia | Buena Vista | 51530 | 2140 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-10-22 04:22:53 | Buena Vista, Virginia, US | |
2273950 | 2273950 | 2022-10-20 | US | Montana | Powell | 30077 | 2140 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-10-21 04:22:23 | Powell, Montana, US | |
200285 | 200285 | 2022-10-19 | US | Montana | Powell | 30077 | 2140 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-10-20 04:22:59 | Powell, Montana, US | |
2758946 | 2758946 | 2022-10-18 | US | Montana | Powell | 30077 | 2140 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-10-19 04:22:26 | Powell, Montana, US | |
2028183 | 2028183 | 2022-10-17 | US | Virginia | Williamsburg | 51830 | 2140 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-18 04:22:42 | Williamsburg, Virginia, US | |
2026780 | 2026780 | 2022-10-17 | US | Montana | Powell | 30077 | 2140 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-10-18 04:22:42 | Powell, Montana, US | |
3214678 | 3214678 | 2022-10-12 | US | Alabama | Greene | 1063 | 2140 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-10-13 04:22:39 | Greene, Alabama, US | |
3250527 | 3250527 | 2022-10-11 | US | Alabama | Greene | 1063 | 2140 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-10-12 04:22:51 | Greene, Alabama, US | |
2967786 | 2967786 | 2022-10-10 | US | Alabama | Greene | 1063 | 2140 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-10-11 04:23:05 | Greene, Alabama, US | |
3097822 | 3097822 | 2022-10-09 | US | Alabama | Greene | 1063 | 2140 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-10-10 04:22:32 | Greene, Alabama, US | |
4003047 | 4003047 | 2022-10-08 | US | Alabama | Greene | 1063 | 2140 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-10-09 04:21:16 | Greene, Alabama, US | |
396644 | 396644 | 2022-10-07 | US | Alabama | Greene | 1063 | 2140 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-10-08 04:22:56 | Greene, Alabama, US | |
2529761 | 2529761 | 2022-10-06 | US | Alabama | Greene | 1063 | 2140 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-10-07 04:23:08 | Greene, Alabama, US | |
1373805 | 1373805 | 2022-09-21 | US | Virginia | Bland | 51021 | 2140 | 26 | 0 | 37.13128068 | -81.13599391 | 2022-09-22 04:22:56 | Bland, Virginia, US | |
3748589 | 3748589 | 2022-09-07 | US | West Virginia | Calhoun | 54013 | 2140 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-08 04:21:02 | Calhoun, West Virginia, US | |
2325104 | 2325104 | 2022-08-24 | US | Minnesota | Pipestone | 27117 | 2140 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-08-25 04:21:13 | Pipestone, Minnesota, US | |
1252513 | 1252513 | 2022-08-23 | US | Minnesota | Pipestone | 27117 | 2140 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-08-24 04:20:46 | Pipestone, Minnesota, US | |
2854617 | 2854617 | 2022-08-22 | US | Minnesota | Pipestone | 27117 | 2140 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-08-23 04:20:56 | Pipestone, Minnesota, US | |
2404589 | 2404589 | 2022-08-21 | US | Minnesota | Pipestone | 27117 | 2140 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-08-22 04:20:38 | Pipestone, Minnesota, US | |
3799667 | 3799667 | 2022-08-20 | US | Minnesota | Pipestone | 27117 | 2140 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-08-21 04:20:44 | Pipestone, Minnesota, US | |
2365253 | 2365253 | 2022-08-19 | US | Minnesota | Pipestone | 27117 | 2140 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-08-20 04:21:01 | Pipestone, Minnesota, US | |
1162924 | 1162924 | 2022-08-18 | US | Minnesota | Pipestone | 27117 | 2140 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-08-19 04:20:54 | Pipestone, Minnesota, US | |
2497607 | 2497607 | 2022-08-15 | US | Wisconsin | Pepin | 55091 | 2140 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-08-16 04:20:58 | Pepin, Wisconsin, US | |
2494555 | 2494555 | 2022-08-15 | US | Arkansas | Prairie | 5117 | 2140 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-08-16 04:20:58 | Prairie, Arkansas, US | |
3648248 | 3648248 | 2022-08-14 | US | Colorado | Yuma | 8125 | 2140 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-15 04:20:59 | Yuma, Colorado, US | |
1487943 | 1487943 | 2022-07-26 | US | Alabama | Choctaw | 1023 | 2140 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-07-27 04:21:04 | Choctaw, Alabama, US | |
1650366 | 1650366 | 2022-06-23 | US | Montana | Blaine | 30005 | 2140 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-06-24 04:20:58 | Blaine, Montana, US | |
2189601 | 2189601 | 2022-06-22 | US | Montana | Blaine | 30005 | 2140 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-06-23 04:20:55 | Blaine, Montana, US | |
168032 | 168032 | 2022-06-21 | US | Montana | Blaine | 30005 | 2140 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-06-22 04:20:54 | Blaine, Montana, US | |
1765315 | 1765315 | 2022-06-20 | US | Montana | Blaine | 30005 | 2140 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-06-21 04:20:56 | Blaine, Montana, US | |
3271501 | 3271501 | 2022-06-19 | US | Montana | Blaine | 30005 | 2140 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-06-20 04:21:01 | Blaine, Montana, US | |
3399413 | 3399413 | 2022-06-18 | US | Montana | Blaine | 30005 | 2140 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-06-19 04:20:51 | Blaine, Montana, US | |
2313290 | 2313290 | 2022-06-17 | US | Montana | Blaine | 30005 | 2140 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-06-18 04:21:10 | Blaine, Montana, US | |
948002 | 948002 | 2022-06-14 | US | Indiana | Warren | 18171 | 2140 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-06-15 04:20:54 | Warren, Indiana, US | |
2980410 | 2980410 | 2022-06-13 | US | Indiana | Warren | 18171 | 2140 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-06-14 04:20:52 | Warren, Indiana, US | |
3160687 | 3160687 | 2022-06-09 | US | Texas | Clay | 48077 | 2140 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-06-10 04:20:55 | Clay, Texas, US | |
3158564 | 3158564 | 2022-06-09 | US | Idaho | Boundary | 16021 | 2140 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-06-10 04:20:55 | Boundary, Idaho, US | |
1424585 | 1424585 | 2022-06-08 | US | West Virginia | Gilmer | 54021 | 2140 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-06-09 04:20:54 | Gilmer, West Virginia, US | |
1422031 | 1422031 | 2022-06-08 | US | Idaho | Boundary | 16021 | 2140 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-06-09 04:20:54 | Boundary, Idaho, US | |
3527992 | 3527992 | 2022-06-04 | US | Arkansas | Searcy | 5129 | 2140 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-06-05 04:20:55 | Searcy, Arkansas, US | |
1851977 | 1851977 | 2022-05-26 | US | Montana | Beaverhead | 30001 | 2140 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-27 04:20:56 | Beaverhead, Montana, US | |
2049853 | 2049853 | 2022-05-25 | US | Montana | Beaverhead | 30001 | 2140 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-26 04:20:50 | Beaverhead, Montana, US | |
2047682 | 2047682 | 2022-05-25 | China | Yunnan | 2140 | 2 | 0 | 24.974 | 101.487 | 2022-05-26 04:20:50 | Yunnan, China | |||
3001291 | 3001291 | 2022-05-24 | US | Montana | Beaverhead | 30001 | 2140 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-25 04:20:56 | Beaverhead, Montana, US | |
3000179 | 3000179 | 2022-05-24 | US | Georgia | Seminole | 13253 | 2140 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-25 04:20:56 | Seminole, Georgia, US | |
3595012 | 3595012 | 2022-05-23 | US | Montana | Beaverhead | 30001 | 2140 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-24 04:20:57 | Beaverhead, Montana, US | |
3593900 | 3593900 | 2022-05-23 | US | Georgia | Seminole | 13253 | 2140 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-24 04:20:57 | Seminole, Georgia, US | |
623864 | 623864 | 2022-05-22 | US | Montana | Beaverhead | 30001 | 2140 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-26 04:20:50 | Beaverhead, Montana, US | |
621693 | 621693 | 2022-05-22 | China | Yunnan | 2140 | 2 | 0 | 24.974 | 101.487 | 2022-05-26 04:20:50 | Yunnan, China | |||
1111560 | 1111560 | 2022-05-21 | US | Montana | Beaverhead | 30001 | 2140 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-22 04:20:52 | Beaverhead, Montana, US | |
1110448 | 1110448 | 2022-05-21 | US | Georgia | Seminole | 13253 | 2140 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-22 04:20:52 | Seminole, Georgia, US | |
1171184 | 1171184 | 2022-05-20 | US | Montana | Beaverhead | 30001 | 2140 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-21 04:20:58 | Beaverhead, Montana, US | |
1170072 | 1170072 | 2022-05-20 | US | Georgia | Seminole | 13253 | 2140 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-21 04:20:58 | Seminole, Georgia, US | |
3896835 | 3896835 | 2022-05-19 | US | Georgia | Seminole | 13253 | 2140 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-20 04:20:57 | Seminole, Georgia, US | |
1185619 | 1185619 | 2022-05-18 | US | Georgia | Seminole | 13253 | 2140 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-19 04:20:54 | Seminole, Georgia, US | |
1845774 | 1845774 | 2022-04-18 | China | Jiangsu | 2140 | 0 | 0 | 32.9711 | 119.455 | 2022-04-19 04:21:00 | Jiangsu, China | |||
2803936 | 2803936 | 2022-04-06 | US | Texas | Live Oak | 48297 | 2140 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-07 04:20:53 | Live Oak, Texas, US | |
3870705 | 3870705 | 2022-04-05 | US | Texas | Live Oak | 48297 | 2140 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-06 04:20:49 | Live Oak, Texas, US | |
2752047 | 2752047 | 2022-04-04 | US | Texas | Live Oak | 48297 | 2140 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-05 04:20:48 | Live Oak, Texas, US | |
2751981 | 2751981 | 2022-04-04 | US | Texas | Gaines | 48165 | 2140 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-04-05 04:20:48 | Gaines, Texas, US | |
2750615 | 2750615 | 2022-04-04 | US | Minnesota | Jackson | 27063 | 2140 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-05 04:20:48 | Jackson, Minnesota, US | |
3733393 | 3733393 | 2022-04-03 | US | Texas | Live Oak | 48297 | 2140 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-04 04:20:51 | Live Oak, Texas, US | |
3733327 | 3733327 | 2022-04-03 | US | Texas | Gaines | 48165 | 2140 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-04-04 04:20:51 | Gaines, Texas, US | |
3732028 | 3732028 | 2022-04-03 | US | Mississippi | Claiborne | 28021 | 2140 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-04 04:20:51 | Claiborne, Mississippi, 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]);