johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
334 rows where confirmed = 2057 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3552638 | 3552638 | 2022-11-27 | US | Illinois | Edwards | 17047 | 2057 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-11-28 04:21:02 | Edwards, Illinois, US | |
2101118 | 2101118 | 2022-11-26 | US | Illinois | Edwards | 17047 | 2057 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-11-27 04:21:05 | Edwards, Illinois, US | |
488609 | 488609 | 2022-11-25 | US | Illinois | Edwards | 17047 | 2057 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-11-26 04:21:11 | Edwards, Illinois, US | |
3525491 | 3525491 | 2022-11-24 | US | Montana | Valley | 30105 | 2057 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-25 04:21:06 | Valley, Montana, US | |
3524438 | 3524438 | 2022-11-24 | US | Illinois | Edwards | 17047 | 2057 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-11-25 04:21:06 | Edwards, Illinois, US | |
3314274 | 3314274 | 2022-11-23 | US | Montana | Valley | 30105 | 2057 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-24 04:21:09 | Valley, Montana, US | |
3313221 | 3313221 | 2022-11-23 | US | Illinois | Edwards | 17047 | 2057 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-11-24 04:21:09 | Edwards, Illinois, US | |
1622315 | 1622315 | 2022-11-22 | US | Montana | Valley | 30105 | 2057 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-23 04:21:06 | Valley, Montana, US | |
3462203 | 3462203 | 2022-11-21 | US | Montana | Valley | 30105 | 2057 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-22 04:20:47 | Valley, Montana, US | |
1642388 | 1642388 | 2022-11-20 | US | Montana | Valley | 30105 | 2057 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-21 04:21:05 | Valley, Montana, US | |
2065945 | 2065945 | 2022-11-19 | US | Montana | Valley | 30105 | 2057 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-20 04:21:08 | Valley, Montana, US | |
1757339 | 1757339 | 2022-11-18 | US | Montana | Valley | 30105 | 2057 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-11-19 04:21:14 | Valley, Montana, US | |
1755089 | 1755089 | 2022-11-18 | China | Hebei | 2057 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-19 04:21:14 | Hebei, China | |||
2272579 | 2272579 | 2022-10-20 | US | Colorado | Rio Blanco | 8103 | 2057 | 14 | 0 | 39.97913541 | -108.2179009 | 2022-10-21 04:22:23 | Rio Blanco, Colorado, US | |
198914 | 198914 | 2022-10-19 | US | Colorado | Rio Blanco | 8103 | 2057 | 14 | 0 | 39.97913541 | -108.2179009 | 2022-10-20 04:22:59 | Rio Blanco, Colorado, US | |
2035773 | 2035773 | 2022-10-14 | US | Tennessee | Pickett | 47137 | 2057 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-15 04:22:00 | Pickett, Tennessee, US | |
2687387 | 2687387 | 2022-10-03 | US | Michigan | Schoolcraft | 26153 | 2057 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-04 04:22:55 | Schoolcraft, Michigan, US | |
2261454 | 2261454 | 2022-10-02 | US | Michigan | Schoolcraft | 26153 | 2057 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-03 04:23:11 | Schoolcraft, Michigan, US | |
2996980 | 2996980 | 2022-10-01 | US | Michigan | Schoolcraft | 26153 | 2057 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-02 04:21:23 | Schoolcraft, Michigan, US | |
855306 | 855306 | 2022-09-30 | US | Michigan | Schoolcraft | 26153 | 2057 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-10-01 04:23:01 | Schoolcraft, Michigan, US | |
2377232 | 2377232 | 2022-09-29 | US | Michigan | Schoolcraft | 26153 | 2057 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-09-30 04:23:09 | Schoolcraft, Michigan, US | |
1561783 | 1561783 | 2022-09-28 | US | Michigan | Schoolcraft | 26153 | 2057 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-09-29 04:22:34 | Schoolcraft, Michigan, US | |
3996326 | 3996326 | 2022-09-27 | US | Michigan | Schoolcraft | 26153 | 2057 | 18 | 0 | 46.19235734 | -86.19972234 | 2022-09-28 04:23:01 | Schoolcraft, Michigan, US | |
3777108 | 3777108 | 2022-08-30 | US | Texas | Rains | 48379 | 2057 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-08-31 04:20:57 | Rains, Texas, US | |
2831820 | 2831820 | 2022-08-25 | US | Tennessee | Van Buren | 47175 | 2057 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-26 04:21:02 | Van Buren, Tennessee, US | |
993904 | 993904 | 2022-08-16 | US | South Dakota | Turner | 46125 | 2057 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-08-17 04:20:59 | Turner, South Dakota, US | |
2496943 | 2496943 | 2022-08-15 | US | South Dakota | Turner | 46125 | 2057 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-08-16 04:20:58 | Turner, South Dakota, US | |
3650493 | 3650493 | 2022-08-14 | US | South Dakota | Turner | 46125 | 2057 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-08-15 04:20:59 | Turner, South Dakota, US | |
1971499 | 1971499 | 2022-08-13 | US | South Dakota | Turner | 46125 | 2057 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-08-14 04:20:55 | Turner, South Dakota, US | |
2891308 | 2891308 | 2022-08-12 | US | South Dakota | Turner | 46125 | 2057 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-08-13 04:20:52 | Turner, South Dakota, US | |
3910913 | 3910913 | 2022-08-11 | US | South Dakota | Turner | 46125 | 2057 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-08-12 04:20:54 | Turner, South Dakota, US | |
1349230 | 1349230 | 2022-08-10 | US | South Dakota | Turner | 46125 | 2057 | 62 | 0 | 43.3109081 | -97.14865776 | 2022-08-11 04:20:49 | Turner, South Dakota, US | |
1071427 | 1071427 | 2022-08-07 | US | Louisiana | St. Helena | 22091 | 2057 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-08 04:21:08 | St. Helena, Louisiana, US | |
1942015 | 1942015 | 2022-08-06 | US | Louisiana | St. Helena | 22091 | 2057 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-07 04:20:54 | St. Helena, Louisiana, US | |
881814 | 881814 | 2022-08-05 | US | Louisiana | St. Helena | 22091 | 2057 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-06 04:20:56 | St. Helena, Louisiana, US | |
2594643 | 2594643 | 2022-07-25 | US | Colorado | Conejos | 8021 | 2057 | 57 | 0 | 37.201606 | -106.1917488 | 2022-07-26 04:20:58 | Conejos, Colorado, US | |
91775 | 91775 | 2022-07-23 | US | Colorado | Lake | 8065 | 2057 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-24 04:20:47 | Lake, Colorado, US | |
900797 | 900797 | 2022-07-22 | US | Colorado | Lake | 8065 | 2057 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-23 04:20:53 | Lake, Colorado, US | |
959406 | 959406 | 2022-07-19 | US | Arkansas | Monroe | 5095 | 2057 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-07-20 04:20:59 | Monroe, Arkansas, US | |
2191187 | 2191187 | 2022-06-22 | US | Wisconsin | Pepin | 55091 | 2057 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-23 04:20:55 | Pepin, Wisconsin, US | |
3270661 | 3270661 | 2022-06-19 | US | Indiana | Union | 18161 | 2057 | 21 | 0 | 39.62550777 | -84.92497066 | 2022-06-20 04:21:01 | Union, Indiana, US | |
3398573 | 3398573 | 2022-06-18 | US | Indiana | Union | 18161 | 2057 | 21 | 0 | 39.62550777 | -84.92497066 | 2022-06-19 04:20:51 | Union, Indiana, US | |
2312450 | 2312450 | 2022-06-17 | US | Indiana | Union | 18161 | 2057 | 21 | 0 | 39.62550777 | -84.92497066 | 2022-06-18 04:21:10 | Union, Indiana, US | |
3985028 | 3985028 | 2022-06-15 | US | North Dakota | Pembina | 38067 | 2057 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-06-16 04:20:55 | Pembina, North Dakota, US | |
3729166 | 3729166 | 2022-06-07 | US | Tennessee | Hancock | 47067 | 2057 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-08 04:20:55 | Hancock, Tennessee, US | |
3729090 | 3729090 | 2022-06-07 | US | South Dakota | Grant | 46051 | 2057 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-08 04:20:55 | Grant, South Dakota, US | |
3890568 | 3890568 | 2022-06-06 | US | Tennessee | Hancock | 47067 | 2057 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-07 04:21:08 | Hancock, Tennessee, US | |
3890492 | 3890492 | 2022-06-06 | US | South Dakota | Grant | 46051 | 2057 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-07 04:21:08 | Grant, South Dakota, US | |
3510261 | 3510261 | 2022-06-05 | US | South Dakota | Grant | 46051 | 2057 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-06 04:20:57 | Grant, South Dakota, US | |
3530338 | 3530338 | 2022-06-04 | US | South Dakota | Grant | 46051 | 2057 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-05 04:20:55 | Grant, South Dakota, US | |
3136424 | 3136424 | 2022-06-03 | US | South Dakota | Grant | 46051 | 2057 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-04 04:20:58 | Grant, South Dakota, US | |
3581499 | 3581499 | 2022-06-02 | US | South Dakota | Grant | 46051 | 2057 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-03 04:20:58 | Grant, South Dakota, US | |
973792 | 973792 | 2022-06-01 | US | South Dakota | Grant | 46051 | 2057 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-02 05:20:39 | Grant, South Dakota, US | |
1186960 | 1186960 | 2022-05-18 | US | New Mexico | Sierra | 35051 | 2057 | 75 | 0 | 33.13028233 | -107.1925893 | 2022-05-19 04:20:54 | Sierra, New Mexico, US | |
3915845 | 3915845 | 2022-05-01 | China | Sichuan | 2057 | 3 | 0 | 30.6171 | 102.7103 | 2022-05-02 04:21:10 | Sichuan, China | |||
3867344 | 3867344 | 2022-04-05 | China | Jiangsu | 2057 | 0 | 0 | 32.9711 | 119.455 | 2022-04-06 04:20:49 | Jiangsu, China | |||
2481021 | 2481021 | 2022-03-30 | US | Texas | Clay | 48077 | 2057 | 34 | 0 | 33.78686685 | -98.20771198 | 2022-03-31 04:20:56 | Clay, Texas, US | |
2163362 | 2163362 | 2022-03-26 | China | Yunnan | 2057 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-27 04:20:47 | Yunnan, China | |||
2201323 | 2201323 | 2022-03-06 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-03-07 04:20:47 | Presque Isle, Michigan, US | |
2093780 | 2093780 | 2022-03-05 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-03-06 04:20:49 | Presque Isle, Michigan, US | |
2667480 | 2667480 | 2022-03-04 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-03-05 04:21:10 | Presque Isle, Michigan, US | |
1646045 | 1646045 | 2022-03-03 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-03-04 04:21:09 | Presque Isle, Michigan, US | |
1645130 | 1645130 | 2022-03-03 | US | Georgia | Candler | 13043 | 2057 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-03-04 04:21:09 | Candler, Georgia, US | |
2527048 | 2527048 | 2022-03-02 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-03-03 04:21:01 | Presque Isle, Michigan, US | |
2526133 | 2526133 | 2022-03-02 | US | Georgia | Candler | 13043 | 2057 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-03-03 04:21:01 | Candler, Georgia, US | |
2734707 | 2734707 | 2022-02-27 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-02-28 04:21:05 | Presque Isle, Michigan, US | |
3047860 | 3047860 | 2022-02-26 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-02-27 04:21:04 | Presque Isle, Michigan, US | |
576515 | 576515 | 2022-02-25 | US | Michigan | Presque Isle | 26141 | 2057 | 55 | 0 | 45.34018577 | -83.91498656 | 2022-02-26 04:21:12 | Presque Isle, Michigan, US | |
1514149 | 1514149 | 2022-02-24 | US | Puerto Rico | Florida | 72054 | 2057 | 0 | 0 | 18.373715 | -66.560488 | 2022-02-25 04:21:11 | Florida, Puerto Rico, US | |
1301574 | 1301574 | 2022-02-17 | US | West Virginia | Webster | 54101 | 2057 | 28 | 0 | 38.49370949 | -80.4202023 | 2022-02-18 04:21:04 | Webster, West Virginia, US | |
1466855 | 1466855 | 2022-02-10 | US | Puerto Rico | Penuelas | 72111 | 2057 | 0 | 0 | 18.059645 | -66.721572 | 2022-02-11 04:21:09 | Penuelas, Puerto Rico, US | |
2476388 | 2476388 | 2022-02-03 | US | North Dakota | Traill | 38097 | 2057 | 22 | 0 | 47.45367788 | -97.16323288 | 2022-02-04 04:21:10 | Traill, North Dakota, US | |
2474827 | 2474827 | 2022-02-03 | US | Georgia | Seminole | 13253 | 2057 | 27 | 0 | 30.93464824 | -84.86823924 | 2022-02-04 04:21:10 | Seminole, Georgia, US | |
461813 | 461813 | 2022-02-02 | US | North Dakota | Traill | 38097 | 2057 | 22 | 0 | 47.45367788 | -97.16323288 | 2022-02-03 04:21:21 | Traill, North Dakota, US | |
3303185 | 3303185 | 2022-01-30 | US | Tennessee | Moore | 47127 | 2057 | 35 | 0 | 35.27724699 | -86.36230578 | 2022-01-31 04:21:09 | Moore, Tennessee, US | |
3302119 | 3302119 | 2022-01-30 | US | Missouri | Howard | 29089 | 2057 | 22 | 0 | 39.1435761 | -92.69756691 | 2022-01-31 04:21:09 | Howard, Missouri, US | |
3301071 | 3301071 | 2022-01-30 | US | Georgia | Pulaski | 13235 | 2057 | 68 | 0 | 32.23334561 | -83.47549959999998 | 2022-01-31 04:21:09 | Pulaski, Georgia, US | |
3063910 | 3063910 | 2022-01-29 | US | Missouri | Howard | 29089 | 2057 | 22 | 0 | 39.1435761 | -92.69756691 | 2022-01-30 04:21:26 | Howard, Missouri, US | |
3062862 | 3062862 | 2022-01-29 | US | Georgia | Pulaski | 13235 | 2057 | 68 | 0 | 32.23334561 | -83.47549959999998 | 2022-01-30 04:21:26 | Pulaski, Georgia, US | |
3810796 | 3810796 | 2022-01-28 | US | Georgia | Pulaski | 13235 | 2057 | 68 | 0 | 32.23334561 | -83.47549959999998 | 2022-01-29 04:21:10 | Pulaski, Georgia, US | |
1781496 | 1781496 | 2022-01-27 | US | Nebraska | Phelps | 31137 | 2057 | 10 | 0 | 40.51156033 | -99.41461667 | 2022-01-28 04:21:09 | Phelps, Nebraska, US | |
1230809 | 1230809 | 2022-01-24 | US | Texas | Parmer | 48369 | 2057 | 46 | 0 | 34.52993409 | -102.78446679999999 | 2022-01-25 04:21:05 | Parmer, Texas, US | |
1694673 | 1694673 | 2022-01-10 | US | North Carolina | Perquimans | 37143 | 2057 | 17 | 0 | 36.17847453 | -76.40603143 | 2022-01-11 04:22:01 | Perquimans, North Carolina, US | |
1694153 | 1694153 | 2022-01-10 | US | Mississippi | Noxubee | 28103 | 2057 | 44 | 0 | 33.11009499 | -88.56949061 | 2022-01-11 04:22:01 | Noxubee, Mississippi, US | |
128568 | 128568 | 2022-01-09 | US | Mississippi | Noxubee | 28103 | 2057 | 44 | 0 | 33.11009499 | -88.56949061 | 2022-01-10 04:22:07 | Noxubee, Mississippi, US | |
1217403 | 1217403 | 2022-01-08 | US | Mississippi | Noxubee | 28103 | 2057 | 44 | 0 | 33.11009499 | -88.56949061 | 2022-01-09 04:21:46 | Noxubee, Mississippi, US | |
1391496 | 1391496 | 2022-01-07 | US | Mississippi | Noxubee | 28103 | 2057 | 44 | 0 | 33.11009499 | -88.56949061 | 2022-01-08 04:21:53 | Noxubee, Mississippi, US | |
2611119 | 2611119 | 2022-01-06 | US | Indiana | Brown | 18013 | 2057 | 51 | 0 | 39.19605589 | -86.22868909 | 2022-01-07 04:22:09 | Brown, Indiana, US | |
1435138 | 1435138 | 2021-12-28 | US | Oklahoma | Love | 40085 | 2057 | 30 | 0 | 33.95273467 | -97.23906784 | 2021-12-29 03:21:43 | Love, Oklahoma, US | |
733604 | 733604 | 2021-12-27 | US | Texas | Duval | 48131 | 2057 | 61 | 0 | 27.68184592 | -98.50864568 | 2021-12-28 04:21:47 | Duval, Texas, US | |
733099 | 733099 | 2021-12-27 | US | Oklahoma | Love | 40085 | 2057 | 30 | 0 | 33.95273467 | -97.23906784 | 2021-12-28 04:21:47 | Love, Oklahoma, US | |
2114776 | 2114776 | 2021-12-26 | US | Texas | Duval | 48131 | 2057 | 60 | 0 | 27.68184592 | -98.50864568 | 2021-12-27 04:21:58 | Duval, Texas, US | |
2114271 | 2114271 | 2021-12-26 | US | Oklahoma | Love | 40085 | 2057 | 30 | 0 | 33.95273467 | -97.23906784 | 2021-12-27 04:21:58 | Love, Oklahoma, US | |
3607643 | 3607643 | 2021-12-25 | US | Oklahoma | Love | 40085 | 2057 | 30 | 0 | 33.95273467 | -97.23906784 | 2021-12-26 04:21:50 | Love, Oklahoma, US | |
2965961 | 2965961 | 2021-12-24 | US | Oklahoma | Love | 40085 | 2057 | 30 | 0 | 33.95273467 | -97.23906784 | 2021-12-25 04:21:37 | Love, Oklahoma, US | |
2964039 | 2964039 | 2021-12-24 | US | Colorado | Prowers | 8099 | 2057 | 45 | 0 | 37.95544985 | -102.3926052 | 2021-12-25 04:21:37 | Prowers, Colorado, US | |
3818993 | 3818993 | 2021-12-23 | US | Oklahoma | Love | 40085 | 2057 | 30 | 0 | 33.95273467 | -97.23906784 | 2021-12-24 04:21:34 | Love, Oklahoma, US | |
801001 | 801001 | 2021-12-22 | US | Oklahoma | Love | 40085 | 2057 | 29 | 0 | 33.95273467 | -97.23906784 | 2021-12-23 04:21:21 | Love, Oklahoma, US | |
2089220 | 2089220 | 2021-12-14 | US | Iowa | Union | 19175 | 2057 | 41 | 0 | 41.0277278 | -94.24234847 | 2021-12-15 03:22:16 | Union, Iowa, US | |
783637 | 783637 | 2021-12-13 | US | Iowa | Union | 19175 | 2057 | 41 | 0 | 41.0277278 | -94.24234847 | 2021-12-14 04:22:38 | Union, Iowa, 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]);