johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
348 rows where confirmed = 2066 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311067 | 311067 | 2022-12-13 | US | Texas | Mitchell | 48335 | 2066 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-14 04:21:04 | Mitchell, Texas, US | |
1152128 | 1152128 | 2022-12-12 | US | Texas | Mitchell | 48335 | 2066 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-13 04:21:01 | Mitchell, Texas, US | |
871982 | 871982 | 2022-12-11 | US | Texas | Mitchell | 48335 | 2066 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-12 04:21:01 | Mitchell, Texas, US | |
260512 | 260512 | 2022-12-10 | US | Texas | Mitchell | 48335 | 2066 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-11 04:20:50 | Mitchell, Texas, US | |
3939226 | 3939226 | 2022-12-09 | US | Texas | Mitchell | 48335 | 2066 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-10 04:21:02 | Mitchell, Texas, US | |
3380558 | 3380558 | 2022-12-08 | US | Texas | Mitchell | 48335 | 2066 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-09 04:21:05 | Mitchell, Texas, US | |
1987829 | 1987829 | 2022-12-07 | US | Texas | Mitchell | 48335 | 2066 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-12-08 04:21:07 | Mitchell, Texas, US | |
2063695 | 2063695 | 2022-11-19 | China | Hebei | 2066 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-20 04:21:08 | Hebei, China | |||
482854 | 482854 | 2022-11-08 | US | Texas | Winkler | 48495 | 2066 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-11-09 04:21:22 | Winkler, Texas, US | |
2442004 | 2442004 | 2022-11-07 | US | Texas | Winkler | 48495 | 2066 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-11-08 04:21:21 | Winkler, Texas, US | |
797402 | 797402 | 2022-10-24 | US | Tennessee | Pickett | 47137 | 2066 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-25 04:21:53 | Pickett, Tennessee, US | |
3775242 | 3775242 | 2022-08-30 | US | Kansas | Pratt | 20151 | 2066 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-08-31 04:20:57 | Pratt, Kansas, US | |
3774444 | 3774444 | 2022-08-30 | US | Arkansas | Woodruff | 5147 | 2066 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-08-31 04:20:57 | Woodruff, Arkansas, US | |
1683507 | 1683507 | 2022-08-29 | US | Tennessee | Van Buren | 47175 | 2066 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-30 04:21:03 | Van Buren, Tennessee, US | |
1683123 | 1683123 | 2022-08-29 | US | Oregon | Grant | 41023 | 2066 | 23 | 0 | 44.49024544 | -119.0068631 | 2022-08-30 04:21:03 | Grant, Oregon, US | |
1681838 | 1681838 | 2022-08-29 | US | Kansas | Pratt | 20151 | 2066 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-08-30 04:21:03 | Pratt, Kansas, US | |
1879607 | 1879607 | 2022-08-28 | US | Oregon | Grant | 41023 | 2066 | 23 | 0 | 44.49024544 | -119.0068631 | 2022-08-29 04:21:06 | Grant, Oregon, US | |
1878322 | 1878322 | 2022-08-28 | US | Kansas | Pratt | 20151 | 2066 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-08-29 04:21:06 | Pratt, Kansas, US | |
2098734 | 2098734 | 2022-08-27 | US | Oregon | Grant | 41023 | 2066 | 23 | 0 | 44.49024544 | -119.0068631 | 2022-08-28 04:21:02 | Grant, Oregon, US | |
2097449 | 2097449 | 2022-08-27 | US | Kansas | Pratt | 20151 | 2066 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-08-28 04:21:02 | Pratt, Kansas, US | |
1534549 | 1534549 | 2022-08-26 | US | Oregon | Grant | 41023 | 2066 | 23 | 0 | 44.49024544 | -119.0068631 | 2022-08-27 04:20:57 | Grant, Oregon, US | |
1533264 | 1533264 | 2022-08-26 | US | Kansas | Pratt | 20151 | 2066 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-08-27 04:20:57 | Pratt, Kansas, US | |
2830151 | 2830151 | 2022-08-25 | US | Kansas | Pratt | 20151 | 2066 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-08-26 04:21:02 | Pratt, Kansas, US | |
2324684 | 2324684 | 2022-08-24 | US | Kansas | Pratt | 20151 | 2066 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-08-25 04:21:13 | Pratt, Kansas, US | |
1164477 | 1164477 | 2022-08-18 | US | Virginia | Bland | 51021 | 2066 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-19 04:20:54 | Bland, Virginia, US | |
2495280 | 2495280 | 2022-08-15 | US | Iowa | Unassigned | 90019 | 2066 | 0 | 0 | 43.38107862 | 0.0 | 2022-08-16 04:20:58 | Unassigned, Iowa, US | |
1349685 | 1349685 | 2022-08-10 | US | Virginia | Lancaster | 51103 | 2066 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-08-11 04:20:49 | Lancaster, Virginia, US | |
1068966 | 1068966 | 2022-07-28 | US | Texas | Floyd | 48153 | 2066 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-07-29 04:20:45 | Floyd, Texas, US | |
1608073 | 1608073 | 2022-07-20 | China | Tianjin | 2066 | 3 | 0 | 39.3054 | 117.323 | 2022-07-21 04:21:10 | Tianjin, China | |||
1770917 | 1770917 | 2022-07-03 | US | Wisconsin | Pepin | 55091 | 2066 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-07-04 04:20:54 | Pepin, Wisconsin, US | |
3368903 | 3368903 | 2022-07-02 | US | Wisconsin | Pepin | 55091 | 2066 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-07-03 04:20:59 | Pepin, Wisconsin, US | |
597232 | 597232 | 2022-07-01 | US | Wisconsin | Pepin | 55091 | 2066 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-07-02 04:21:16 | Pepin, Wisconsin, US | |
1766845 | 1766845 | 2022-06-20 | US | West Virginia | Tucker | 54093 | 2066 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-21 04:20:56 | Tucker, West Virginia, US | |
3273031 | 3273031 | 2022-06-19 | US | West Virginia | Tucker | 54093 | 2066 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-20 04:21:01 | Tucker, West Virginia, US | |
3400943 | 3400943 | 2022-06-18 | US | West Virginia | Tucker | 54093 | 2066 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-19 04:20:51 | Tucker, West Virginia, US | |
2314820 | 2314820 | 2022-06-17 | US | West Virginia | Tucker | 54093 | 2066 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-18 04:21:10 | Tucker, West Virginia, US | |
2314251 | 2314251 | 2022-06-17 | US | Tennessee | Hancock | 47067 | 2066 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-18 04:21:10 | Hancock, Tennessee, US | |
562324 | 562324 | 2022-06-16 | US | West Virginia | Tucker | 54093 | 2066 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-17 04:20:56 | Tucker, West Virginia, US | |
561755 | 561755 | 2022-06-16 | US | Tennessee | Hancock | 47067 | 2066 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-17 04:20:56 | Hancock, Tennessee, US | |
3986126 | 3986126 | 2022-06-15 | US | West Virginia | Tucker | 54093 | 2066 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-16 04:20:55 | Tucker, West Virginia, US | |
3985557 | 3985557 | 2022-06-15 | US | Tennessee | Hancock | 47067 | 2066 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-16 04:20:55 | Hancock, Tennessee, US | |
950367 | 950367 | 2022-06-14 | US | West Virginia | Tucker | 54093 | 2066 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-15 04:20:54 | Tucker, West Virginia, US | |
949798 | 949798 | 2022-06-14 | US | Tennessee | Hancock | 47067 | 2066 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-15 04:20:54 | Hancock, Tennessee, US | |
1423311 | 1423311 | 2022-06-08 | US | New Mexico | Quay | 35037 | 2066 | 58 | 0 | 35.10403332 | -103.5481727 | 2022-06-09 04:20:54 | Quay, New Mexico, US | |
3188206 | 3188206 | 2022-05-30 | US | New Mexico | Sierra | 35051 | 2066 | 75 | 0 | 33.13028233 | -107.1925893 | 2022-05-31 04:20:51 | Sierra, New Mexico, US | |
3200355 | 3200355 | 2022-05-29 | US | New Mexico | Sierra | 35051 | 2066 | 75 | 0 | 33.13028233 | -107.1925893 | 2022-05-30 04:20:50 | Sierra, New Mexico, US | |
2727233 | 2727233 | 2022-05-28 | US | New Mexico | Sierra | 35051 | 2066 | 75 | 0 | 33.13028233 | -107.1925893 | 2022-05-29 04:20:53 | Sierra, New Mexico, US | |
1316414 | 1316414 | 2022-05-27 | US | New Mexico | Sierra | 35051 | 2066 | 75 | 0 | 33.13028233 | -107.1925893 | 2022-05-28 04:21:07 | Sierra, New Mexico, US | |
3583082 | 3583082 | 2022-05-17 | US | Alaska | Southeast Fairbanks | 2240 | 2066 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-05-18 04:20:50 | Southeast Fairbanks, Alaska, US | |
1504039 | 1504039 | 2022-05-16 | US | Alaska | Southeast Fairbanks | 2240 | 2066 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-05-17 04:20:59 | Southeast Fairbanks, Alaska, US | |
2084398 | 2084398 | 2022-05-15 | US | Alaska | Southeast Fairbanks | 2240 | 2066 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-05-16 04:20:47 | Southeast Fairbanks, Alaska, US | |
3355108 | 3355108 | 2022-05-14 | US | Alaska | Southeast Fairbanks | 2240 | 2066 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-05-15 04:20:53 | Southeast Fairbanks, Alaska, US | |
658753 | 658753 | 2022-05-13 | US | Alaska | Southeast Fairbanks | 2240 | 2066 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-05-14 04:20:48 | Southeast Fairbanks, Alaska, US | |
2533836 | 2533836 | 2022-05-12 | US | Alaska | Southeast Fairbanks | 2240 | 2066 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-05-13 04:20:51 | Southeast Fairbanks, Alaska, US | |
3445282 | 3445282 | 2022-05-11 | US | Alaska | Southeast Fairbanks | 2240 | 2066 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-05-12 04:20:54 | Southeast Fairbanks, Alaska, US | |
2601556 | 2601556 | 2022-05-05 | US | West Virginia | Pocahontas | 54075 | 2066 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-05-06 04:21:00 | Pocahontas, West Virginia, US | |
2597858 | 2597858 | 2022-05-05 | China | Sichuan | 2066 | 3 | 0 | 30.6171 | 102.7103 | 2022-05-06 04:21:00 | Sichuan, China | |||
3919542 | 3919542 | 2022-05-01 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-05-02 04:21:10 | Pleasants, West Virginia, US | |
2844346 | 2844346 | 2022-04-30 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-05-01 04:20:57 | Pleasants, West Virginia, US | |
1160659 | 1160659 | 2022-04-29 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-04-30 04:21:05 | Pleasants, West Virginia, US | |
1699841 | 1699841 | 2022-04-28 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-04-29 04:20:59 | Pleasants, West Virginia, US | |
3853806 | 3853806 | 2022-04-27 | US | Montana | Carbon | 30009 | 2066 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-04-28 04:20:47 | Carbon, Montana, US | |
1327930 | 1327930 | 2022-04-26 | US | Michigan | Presque Isle | 26141 | 2066 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-27 04:20:52 | Presque Isle, Michigan, US | |
3723884 | 3723884 | 2022-04-25 | US | Michigan | Presque Isle | 26141 | 2066 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-26 04:20:51 | Presque Isle, Michigan, US | |
2030452 | 2030452 | 2022-04-24 | US | Michigan | Presque Isle | 26141 | 2066 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-25 04:20:56 | Presque Isle, Michigan, US | |
748027 | 748027 | 2022-04-23 | US | Michigan | Presque Isle | 26141 | 2066 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-24 04:20:56 | Presque Isle, Michigan, US | |
3438512 | 3438512 | 2022-04-22 | US | Michigan | Presque Isle | 26141 | 2066 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-23 04:20:50 | Presque Isle, Michigan, US | |
2894097 | 2894097 | 2022-04-21 | US | Michigan | Presque Isle | 26141 | 2066 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-22 04:20:45 | Presque Isle, Michigan, US | |
2308969 | 2308969 | 2022-04-20 | US | Michigan | Presque Isle | 26141 | 2066 | 58 | 0 | 45.34018577 | -83.91498656 | 2022-04-21 04:20:46 | Presque Isle, Michigan, US | |
2253412 | 2253412 | 2022-04-19 | US | Montana | Blaine | 30005 | 2066 | 32 | 0 | 48.43175214 | -108.9582723 | 2022-04-20 04:20:45 | Blaine, Montana, US | |
2446263 | 2446263 | 2022-04-13 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-04-13 23:21:06 | Pleasants, West Virginia, US | |
1952020 | 1952020 | 2022-04-12 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-04-13 04:21:03 | Pleasants, West Virginia, US | |
1579659 | 1579659 | 2022-04-10 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-04-11 04:21:02 | Pleasants, West Virginia, US | |
1655901 | 1655901 | 2022-04-09 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-04-10 04:20:52 | Pleasants, West Virginia, US | |
2119223 | 2119223 | 2022-04-08 | US | West Virginia | Pleasants | 54073 | 2066 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-04-09 04:20:42 | Pleasants, West Virginia, US | |
2802510 | 2802510 | 2022-04-06 | US | Minnesota | Lake | 27075 | 2066 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-04-07 04:20:53 | Lake, Minnesota, US | |
3869279 | 3869279 | 2022-04-05 | US | Minnesota | Lake | 27075 | 2066 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-04-06 04:20:49 | Lake, Minnesota, US | |
1539773 | 1539773 | 2022-03-31 | China | Yunnan | 2066 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-01 04:20:28 | Yunnan, China | |||
2477786 | 2477786 | 2022-03-30 | China | Yunnan | 2066 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-31 04:20:56 | Yunnan, China | |||
3630733 | 3630733 | 2022-03-13 | US | Puerto Rico | Sabana Grande | 72121 | 2066 | 0 | 0 | 18.08282 | -66.943758 | 2022-03-14 04:20:46 | Sabana Grande, Puerto Rico, US | |
1645141 | 1645141 | 2022-03-03 | US | Georgia | Clinch | 13065 | 2066 | 39 | 0 | 30.91395822 | -82.70432472 | 2022-03-04 04:21:09 | Clinch, Georgia, US | |
2736505 | 2736505 | 2022-02-27 | US | West Virginia | Gilmer | 54021 | 2066 | 18 | 0 | 38.9251277 | -80.85952723 | 2022-02-28 04:21:05 | Gilmer, West Virginia, US | |
3049658 | 3049658 | 2022-02-26 | US | West Virginia | Gilmer | 54021 | 2066 | 18 | 0 | 38.9251277 | -80.85952723 | 2022-02-27 04:21:04 | Gilmer, West Virginia, US | |
578313 | 578313 | 2022-02-25 | US | West Virginia | Gilmer | 54021 | 2066 | 18 | 0 | 38.9251277 | -80.85952723 | 2022-02-26 04:21:12 | Gilmer, West Virginia, US | |
1514889 | 1514889 | 2022-02-24 | US | West Virginia | Gilmer | 54021 | 2066 | 18 | 0 | 38.9251277 | -80.85952723 | 2022-02-25 04:21:11 | Gilmer, West Virginia, US | |
3875370 | 3875370 | 2022-02-19 | China | Heilongjiang | 2066 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-02-20 04:21:00 | Heilongjiang, China | |||
3855626 | 3855626 | 2022-02-18 | China | Heilongjiang | 2066 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-02-19 04:21:11 | Heilongjiang, China | |||
1299429 | 1299429 | 2022-02-17 | US | Kentucky | Bracken | 21023 | 2066 | 23 | 0 | 38.69158994 | -84.08532444 | 2022-02-18 04:21:04 | Bracken, Kentucky, US | |
1297845 | 1297845 | 2022-02-17 | China | Heilongjiang | 2066 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-02-18 04:21:04 | Heilongjiang, China | |||
3823529 | 3823529 | 2022-02-16 | US | Texas | Franklin | 48159 | 2066 | 38 | 0 | 33.17653242 | -95.21917243 | 2022-02-17 04:20:56 | Franklin, Texas, US | |
3820231 | 3820231 | 2022-02-16 | China | Heilongjiang | 2066 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-02-17 04:20:56 | Heilongjiang, China | |||
3671445 | 3671445 | 2022-02-15 | China | Heilongjiang | 2066 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-02-16 04:21:10 | Heilongjiang, China | |||
2643720 | 2643720 | 2022-02-14 | US | Missouri | St. Clair | 29185 | 2066 | 31 | 0 | 38.03699437 | -93.77631447 | 2022-02-15 04:21:09 | St. Clair, Missouri, US | |
2641546 | 2641546 | 2022-02-14 | China | Heilongjiang | 2066 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-02-15 04:21:09 | Heilongjiang, China | |||
1465561 | 1465561 | 2022-02-10 | US | Kentucky | Trimble | 21223 | 2066 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-11 04:21:09 | Trimble, Kentucky, US | |
74608 | 74608 | 2022-02-07 | US | West Virginia | Tyler | 54095 | 2066 | 27 | 0 | 39.46811972 | -80.88772676 | 2022-02-08 04:21:15 | Tyler, West Virginia, US | |
1295949 | 1295949 | 2022-02-05 | US | Missouri | Iron | 29093 | 2066 | 35 | 0 | 37.55487945 | -90.7735296 | 2022-02-06 04:21:00 | Iron, Missouri, US | |
2475891 | 2475891 | 2022-02-03 | US | Missouri | Monroe | 29137 | 2066 | 38 | 0 | 39.49593978 | -92.00043978 | 2022-02-04 04:21:10 | Monroe, Missouri, US | |
461461 | 461461 | 2022-02-02 | US | Nebraska | Hamilton | 31081 | 2066 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-03 04:21:21 | Hamilton, Nebraska, US | |
979942 | 979942 | 2022-02-01 | US | Illinois | Hamilton | 17065 | 2066 | 28 | 0 | 38.08163641 | -88.53883373 | 2022-02-02 04:21:09 | Hamilton, Illinois, 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]);