johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
382 rows where confirmed = 1576 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952731 | 2952731 | 2022-12-20 | US | Kansas | Rooks | 20163 | 1576 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-21 04:21:03 | Rooks, Kansas, US | |
3175133 | 3175133 | 2022-12-19 | US | Kansas | Rooks | 20163 | 1576 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-20 04:21:04 | Rooks, Kansas, US | |
1629650 | 1629650 | 2022-12-18 | US | Kansas | Rooks | 20163 | 1576 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-19 04:21:03 | Rooks, Kansas, US | |
505029 | 505029 | 2022-12-17 | US | Kansas | Rooks | 20163 | 1576 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-18 04:21:03 | Rooks, Kansas, US | |
3325601 | 3325601 | 2022-12-16 | US | Kansas | Rooks | 20163 | 1576 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-17 04:21:04 | Rooks, Kansas, US | |
544113 | 544113 | 2022-12-15 | US | Kansas | Rooks | 20163 | 1576 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-16 04:21:01 | Rooks, Kansas, US | |
349641 | 349641 | 2022-12-14 | US | Kansas | Rooks | 20163 | 1576 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-12-15 04:20:58 | Rooks, Kansas, US | |
2102561 | 2102561 | 2022-11-26 | US | North Dakota | Sioux | 38085 | 1576 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-11-27 04:21:05 | Sioux, North Dakota, US | |
490052 | 490052 | 2022-11-25 | US | North Dakota | Sioux | 38085 | 1576 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-11-26 04:21:11 | Sioux, North Dakota, US | |
992118 | 992118 | 2022-08-16 | US | Indiana | Ohio | 18115 | 1576 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-17 04:20:59 | Ohio, Indiana, US | |
2495157 | 2495157 | 2022-08-15 | US | Indiana | Ohio | 18115 | 1576 | 19 | 0 | 38.955305 | -84.96515993 | 2022-08-16 04:20:58 | Ohio, Indiana, US | |
1087007 | 1087007 | 2022-08-09 | US | Idaho | Caribou | 16029 | 1576 | 30 | 0 | 42.77149116 | -111.5597683 | 2022-08-10 04:20:57 | Caribou, Idaho, US | |
3544422 | 3544422 | 2022-08-08 | US | Idaho | Caribou | 16029 | 1576 | 30 | 0 | 42.77149116 | -111.5597683 | 2022-08-09 04:20:34 | Caribou, Idaho, US | |
1070885 | 1070885 | 2022-08-07 | US | Illinois | Gallatin | 17059 | 1576 | 18 | 0 | 37.76430935 | -88.22953869 | 2022-08-08 04:21:08 | Gallatin, Illinois, US | |
1070825 | 1070825 | 2022-08-07 | US | Idaho | Caribou | 16029 | 1576 | 30 | 0 | 42.77149116 | -111.5597683 | 2022-08-08 04:21:08 | Caribou, Idaho, US | |
1941473 | 1941473 | 2022-08-06 | US | Illinois | Gallatin | 17059 | 1576 | 18 | 0 | 37.76430935 | -88.22953869 | 2022-08-07 04:20:54 | Gallatin, Illinois, US | |
1941413 | 1941413 | 2022-08-06 | US | Idaho | Caribou | 16029 | 1576 | 30 | 0 | 42.77149116 | -111.5597683 | 2022-08-07 04:20:54 | Caribou, Idaho, US | |
881272 | 881272 | 2022-08-05 | US | Illinois | Gallatin | 17059 | 1576 | 18 | 0 | 37.76430935 | -88.22953869 | 2022-08-06 04:20:56 | Gallatin, Illinois, US | |
881212 | 881212 | 2022-08-05 | US | Idaho | Caribou | 16029 | 1576 | 30 | 0 | 42.77149116 | -111.5597683 | 2022-08-06 04:20:56 | Caribou, Idaho, US | |
1611307 | 1611307 | 2022-07-20 | US | Texas | Carson | 48065 | 1576 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-07-21 04:21:10 | Carson, Texas, US | |
961940 | 961940 | 2022-07-19 | US | Texas | Carson | 48065 | 1576 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-07-20 04:20:59 | Carson, Texas, US | |
3213835 | 3213835 | 2022-07-18 | US | Wisconsin | Iron | 55051 | 1576 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-07-19 04:20:58 | Iron, Wisconsin, US | |
632331 | 632331 | 2022-07-12 | US | North Dakota | Ransom | 38073 | 1576 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-07-13 04:20:58 | Ransom, North Dakota, US | |
2490986 | 2490986 | 2022-06-29 | US | Illinois | Calhoun | 17013 | 1576 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-06-30 04:21:01 | Calhoun, Illinois, US | |
3984359 | 3984359 | 2022-06-15 | US | Minnesota | Norman | 27107 | 1576 | 14 | 0 | 47.32628443 | -96.45620947 | 2022-06-16 04:20:55 | Norman, Minnesota, US | |
3187452 | 3187452 | 2022-05-30 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-31 04:20:51 | Owsley, Kentucky, US | |
3199601 | 3199601 | 2022-05-29 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-30 04:20:50 | Owsley, Kentucky, US | |
2726479 | 2726479 | 2022-05-28 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-29 04:20:53 | Owsley, Kentucky, US | |
1315660 | 1315660 | 2022-05-27 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-28 04:21:07 | Owsley, Kentucky, US | |
1851452 | 1851452 | 2022-05-26 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-27 04:20:56 | Owsley, Kentucky, US | |
2049328 | 2049328 | 2022-05-25 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-26 04:20:50 | Owsley, Kentucky, US | |
3000766 | 3000766 | 2022-05-24 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-25 04:20:56 | Owsley, Kentucky, US | |
3595783 | 3595783 | 2022-05-23 | US | Puerto Rico | Las Marias | 72083 | 1576 | 0 | 0 | 18.23679 | -66.98362 | 2022-05-24 04:20:57 | Las Marias, Puerto Rico, US | |
3594487 | 3594487 | 2022-05-23 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-24 04:20:57 | Owsley, Kentucky, US | |
623339 | 623339 | 2022-05-22 | US | Kentucky | Owsley | 21189 | 1576 | 27 | 0 | 37.42823949 | -83.68811419 | 2022-05-26 04:20:50 | Owsley, Kentucky, US | |
2333224 | 2333224 | 2022-05-08 | US | Mississippi | Quitman | 28119 | 1576 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-09 04:20:54 | Quitman, Mississippi, US | |
362186 | 362186 | 2022-05-07 | US | Mississippi | Quitman | 28119 | 1576 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-08 04:20:49 | Quitman, Mississippi, US | |
1399537 | 1399537 | 2022-05-06 | US | Mississippi | Quitman | 28119 | 1576 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-07 04:21:09 | Quitman, Mississippi, US | |
2599892 | 2599892 | 2022-05-05 | US | Mississippi | Quitman | 28119 | 1576 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-06 04:21:00 | Quitman, Mississippi, US | |
3267341 | 3267341 | 2022-05-04 | US | Mississippi | Quitman | 28119 | 1576 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-05 04:20:55 | Quitman, Mississippi, US | |
1573980 | 1573980 | 2022-05-03 | US | Mississippi | Quitman | 28119 | 1576 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-04 04:20:59 | Quitman, Mississippi, US | |
1572953 | 1572953 | 2022-05-03 | US | Georgia | Hancock | 13141 | 1576 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-04 04:20:59 | Hancock, Georgia, US | |
465240 | 465240 | 2022-05-02 | US | Mississippi | Quitman | 28119 | 1576 | 31 | 0 | 34.25157572 | -90.28908 | 2022-05-03 04:21:00 | Quitman, Mississippi, US | |
464213 | 464213 | 2022-05-02 | US | Georgia | Hancock | 13141 | 1576 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-03 04:21:00 | Hancock, Georgia, US | |
3916852 | 3916852 | 2022-05-01 | US | Georgia | Hancock | 13141 | 1576 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-02 04:21:10 | Hancock, Georgia, US | |
2841656 | 2841656 | 2022-04-30 | US | Georgia | Hancock | 13141 | 1576 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-01 04:20:57 | Hancock, Georgia, US | |
1157969 | 1157969 | 2022-04-29 | US | Georgia | Hancock | 13141 | 1576 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-04-30 04:21:05 | Hancock, Georgia, US | |
1697151 | 1697151 | 2022-04-28 | US | Georgia | Hancock | 13141 | 1576 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-04-29 04:20:59 | Hancock, Georgia, US | |
3852634 | 3852634 | 2022-04-27 | US | Georgia | Hancock | 13141 | 1576 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-04-28 04:20:47 | Hancock, Georgia, US | |
1436719 | 1436719 | 2022-03-28 | New Zealand | Cook Islands | 1576 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-29 04:20:46 | Cook Islands, New Zealand | |||
2201530 | 2201530 | 2022-03-06 | US | Missouri | Clark | 29045 | 1576 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-07 04:20:47 | Clark, Missouri, US | |
2093987 | 2093987 | 2022-03-05 | US | Missouri | Clark | 29045 | 1576 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-06 04:20:49 | Clark, Missouri, US | |
2667687 | 2667687 | 2022-03-04 | US | Missouri | Clark | 29045 | 1576 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-05 04:21:10 | Clark, Missouri, US | |
2527255 | 2527255 | 2022-03-02 | US | Missouri | Clark | 29045 | 1576 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-03 04:21:01 | Clark, Missouri, US | |
945454 | 945454 | 2022-02-28 | US | Oregon | Harney | 41025 | 1576 | 36 | 0 | 43.06422669 | -118.96663059999999 | 2022-03-01 04:21:09 | Harney, Oregon, US | |
2735414 | 2735414 | 2022-02-27 | US | North Dakota | Bottineau | 38009 | 1576 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-02-28 04:21:05 | Bottineau, North Dakota, US | |
3048567 | 3048567 | 2022-02-26 | US | North Dakota | Bottineau | 38009 | 1576 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-02-27 04:21:04 | Bottineau, North Dakota, US | |
577222 | 577222 | 2022-02-25 | US | North Dakota | Bottineau | 38009 | 1576 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-02-26 04:21:12 | Bottineau, North Dakota, US | |
1513798 | 1513798 | 2022-02-24 | US | North Dakota | Bottineau | 38009 | 1576 | 25 | 0 | 48.79106111 | -100.8378166 | 2022-02-25 04:21:11 | Bottineau, North Dakota, US | |
3915054 | 3915054 | 2022-02-20 | US | Texas | Brooks | 48047 | 1576 | 50 | 0 | 27.03103197 | -98.21808402 | 2022-02-21 04:21:05 | Brooks, Texas, US | |
1781057 | 1781057 | 2022-01-27 | US | Michigan | Montmorency | 26119 | 1576 | 44 | 0 | 45.0275929 | -84.12696227 | 2022-01-28 04:21:09 | Montmorency, Michigan, US | |
1319885 | 1319885 | 2022-01-26 | US | Michigan | Montmorency | 26119 | 1576 | 44 | 0 | 45.0275929 | -84.12696227 | 2022-01-27 04:21:19 | Montmorency, Michigan, US | |
3428020 | 3428020 | 2022-01-21 | US | Texas | Delta | 48119 | 1576 | 22 | 0 | 33.38570922 | -95.66921122 | 2022-01-22 04:21:13 | Delta, Texas, US | |
3687917 | 3687917 | 2022-01-13 | US | Alaska | Sitka | 2220 | 1576 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-01-14 04:21:54 | Sitka, Alaska, US | |
3614457 | 3614457 | 2022-01-12 | US | Kentucky | Crittenden | 21055 | 1576 | 39 | 0 | 37.35839237 | -88.08826090000002 | 2022-01-13 08:00:09 | Crittenden, Kentucky, US | |
3613501 | 3613501 | 2022-01-12 | US | Alaska | Sitka | 2220 | 1576 | 6 | 0 | 57.24124555 | -135.3206587 | 2022-01-13 08:00:09 | Sitka, Alaska, US | |
1695890 | 1695890 | 2022-01-10 | US | Wisconsin | Pepin | 55091 | 1576 | 15 | 0 | 44.58307413 | -91.99949611 | 2022-01-11 04:22:01 | Pepin, Wisconsin, US | |
1695425 | 1695425 | 2022-01-10 | US | Texas | Hamilton | 48193 | 1576 | 29 | 0 | 31.70470573 | -98.11083887 | 2022-01-11 04:22:01 | Hamilton, Texas, US | |
129514 | 129514 | 2022-01-09 | US | Puerto Rico | Santa Isabel | 72133 | 1576 | 0 | 0 | 17.994525 | -66.388913 | 2022-01-10 04:22:07 | Santa Isabel, Puerto Rico, US | |
128067 | 128067 | 2022-01-09 | US | Kansas | Pratt | 20151 | 1576 | 29 | 0 | 37.64780729 | -98.73922153 | 2022-01-10 04:22:07 | Pratt, Kansas, US | |
1216902 | 1216902 | 2022-01-08 | US | Kansas | Pratt | 20151 | 1576 | 29 | 0 | 37.64780729 | -98.73922153 | 2022-01-09 04:21:46 | Pratt, Kansas, US | |
1390995 | 1390995 | 2022-01-07 | US | Kansas | Pratt | 20151 | 1576 | 29 | 0 | 37.64780729 | -98.73922153 | 2022-01-08 04:21:53 | Pratt, Kansas, US | |
1285468 | 1285468 | 2022-01-05 | US | West Virginia | Doddridge | 54017 | 1576 | 15 | 0 | 39.27057157 | -80.70671527 | 2022-01-06 04:22:09 | Doddridge, West Virginia, US | |
1288983 | 1288983 | 2022-01-04 | US | Tennessee | Moore | 47127 | 1576 | 32 | 0 | 35.27724699 | -86.36230578 | 2022-01-05 04:21:59 | Moore, Tennessee, US | |
1286999 | 1286999 | 2022-01-04 | US | Illinois | Hamilton | 17065 | 1576 | 25 | 0 | 38.08163641 | -88.53883373 | 2022-01-05 04:21:59 | Hamilton, Illinois, US | |
3522656 | 3522656 | 2022-01-02 | US | Texas | Somervell | 48425 | 1576 | 26 | 0 | 32.22236802 | -97.77403489 | 2022-01-03 02:22:25 | Somervell, Texas, US | |
4001855 | 4001855 | 2021-12-30 | US | Texas | Red River | 48387 | 1576 | 57 | 0 | 33.61886692 | -95.04841765 | 2021-12-31 04:21:50 | Red River, Texas, US | |
2115314 | 2115314 | 2021-12-26 | US | Wyoming | Platte | 56031 | 1576 | 35 | 0 | 42.13299116 | -104.96633100000001 | 2021-12-27 04:21:58 | Platte, Wyoming, US | |
3608686 | 3608686 | 2021-12-25 | US | Wyoming | Platte | 56031 | 1576 | 35 | 0 | 42.13299116 | -104.96633100000001 | 2021-12-26 04:21:50 | Platte, Wyoming, US | |
2967004 | 2967004 | 2021-12-24 | US | Wyoming | Platte | 56031 | 1576 | 35 | 0 | 42.13299116 | -104.96633100000001 | 2021-12-25 04:21:37 | Platte, Wyoming, US | |
3820036 | 3820036 | 2021-12-23 | US | Wyoming | Platte | 56031 | 1576 | 35 | 0 | 42.13299116 | -104.96633100000001 | 2021-12-24 04:21:34 | Platte, Wyoming, US | |
3817251 | 3817251 | 2021-12-23 | US | Georgia | Johnson | 13167 | 1576 | 64 | 0 | 32.70211082 | -82.66166794 | 2021-12-24 04:21:34 | Johnson, Georgia, US | |
802044 | 802044 | 2021-12-22 | US | Wyoming | Platte | 56031 | 1576 | 35 | 0 | 42.13299116 | -104.96633100000001 | 2021-12-23 04:21:21 | Platte, Wyoming, US | |
3831703 | 3831703 | 2021-12-21 | US | Texas | Terry | 48445 | 1576 | 71 | 0 | 33.17402785 | -102.3354521 | 2021-12-22 04:21:54 | Terry, Texas, US | |
3829754 | 3829754 | 2021-12-21 | US | Kansas | Ellsworth | 20053 | 1576 | 31 | 0 | 38.69677695 | -98.20462799 | 2021-12-22 04:21:54 | Ellsworth, Kansas, US | |
1256057 | 1256057 | 2021-12-20 | US | Kansas | Ellsworth | 20053 | 1576 | 31 | 0 | 38.69677695 | -98.20462799 | 2021-12-21 03:21:27 | Ellsworth, Kansas, US | |
2904831 | 2904831 | 2021-12-19 | US | Indiana | Martin | 18101 | 1576 | 19 | 0 | 38.7099921 | -86.80373186 | 2021-12-20 04:21:43 | Martin, Indiana, US | |
1259904 | 1259904 | 2021-12-18 | US | Indiana | Martin | 18101 | 1576 | 19 | 0 | 38.7099921 | -86.80373186 | 2021-12-19 04:21:11 | Martin, Indiana, US | |
2399932 | 2399932 | 2021-12-17 | US | Indiana | Martin | 18101 | 1576 | 19 | 0 | 38.7099921 | -86.80373186 | 2021-12-18 02:22:20 | Martin, Indiana, US | |
1718383 | 1718383 | 2021-12-16 | US | Montana | Sanders | 30089 | 1576 | 40 | 0 | 47.67657534 | -115.1329916 | 2021-12-17 04:22:14 | Sanders, Montana, US | |
3658772 | 3658772 | 2021-12-10 | US | Texas | Mitchell | 48335 | 1576 | 43 | 0 | 32.30623474 | -100.9212058 | 2021-12-11 04:22:45 | Mitchell, Texas, US | |
1079829 | 1079829 | 2021-12-09 | US | Missouri | Gentry | 29075 | 1576 | 28 | 0 | 40.21097916 | -94.40944419 | 2021-12-10 04:22:28 | Gentry, Missouri, US | |
1741870 | 1741870 | 2021-12-05 | US | Kansas | Pawnee | 20145 | 1576 | 21 | 0 | 38.18108732 | -99.23692334 | 2021-12-06 04:22:34 | Pawnee, Kansas, US | |
139302 | 139302 | 2021-12-04 | US | Kansas | Pawnee | 20145 | 1576 | 21 | 0 | 38.18108732 | -99.23692334 | 2021-12-05 04:22:25 | Pawnee, Kansas, US | |
2198348 | 2198348 | 2021-12-03 | US | Puerto Rico | Cabo Rojo | 72023 | 1576 | 0 | 0 | 18.040993 | -67.154391 | 2021-12-04 04:22:18 | Cabo Rojo, Puerto Rico, US | |
2196955 | 2196955 | 2021-12-03 | US | Kansas | Pawnee | 20145 | 1576 | 21 | 0 | 38.18108732 | -99.23692334 | 2021-12-04 04:22:18 | Pawnee, Kansas, US | |
3403004 | 3403004 | 2021-11-30 | US | Maine | Piscataquis | 23021 | 1576 | 13 | 0 | 45.83839062 | -69.2860223 | 2021-12-01 04:22:29 | Piscataquis, Maine, US | |
761054 | 761054 | 2021-11-26 | US | Puerto Rico | Camuy | 72027 | 1576 | 0 | 0 | 18.418578 | -66.860206 | 2021-11-27 04:22:45 | Camuy, Puerto Rico, US | |
1805471 | 1805471 | 2021-11-25 | US | Puerto Rico | Camuy | 72027 | 1576 | 0 | 0 | 18.418578 | -66.860206 | 2021-11-26 04:22:33 | Camuy, Puerto Rico, US | |
906905 | 906905 | 2021-11-24 | US | Puerto Rico | Camuy | 72027 | 1576 | 0 | 0 | 18.418578 | -66.860206 | 2021-11-25 04:22:33 | Camuy, Puerto Rico, 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]);