johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
367 rows where confirmed = 2141 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1623186 | 1623186 | 2022-11-22 | US | South Dakota | Turner | 46125 | 2141 | 63 | 0 | 43.3109081 | -97.14865776 | 2022-11-23 04:21:06 | Turner, South Dakota, US | |
3463074 | 3463074 | 2022-11-21 | US | South Dakota | Turner | 46125 | 2141 | 63 | 0 | 43.3109081 | -97.14865776 | 2022-11-22 04:20:47 | Turner, South Dakota, US | |
3460817 | 3460817 | 2022-11-21 | US | Colorado | Rio Blanco | 8103 | 2141 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-11-22 04:20:47 | Rio Blanco, Colorado, US | |
1643259 | 1643259 | 2022-11-20 | US | South Dakota | Turner | 46125 | 2141 | 63 | 0 | 43.3109081 | -97.14865776 | 2022-11-21 04:21:05 | Turner, South Dakota, US | |
2066816 | 2066816 | 2022-11-19 | US | South Dakota | Turner | 46125 | 2141 | 63 | 0 | 43.3109081 | -97.14865776 | 2022-11-20 04:21:08 | Turner, South Dakota, US | |
1758210 | 1758210 | 2022-11-18 | US | South Dakota | Turner | 46125 | 2141 | 63 | 0 | 43.3109081 | -97.14865776 | 2022-11-19 04:21:14 | Turner, South Dakota, US | |
3029203 | 3029203 | 2022-11-17 | US | South Dakota | Turner | 46125 | 2141 | 63 | 0 | 43.3109081 | -97.14865776 | 2022-11-18 04:21:15 | Turner, South Dakota, US | |
3026927 | 3026927 | 2022-11-17 | US | Colorado | Lake | 8065 | 2141 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-18 04:21:15 | Lake, Colorado, US | |
2488914 | 2488914 | 2022-11-16 | US | South Dakota | Turner | 46125 | 2141 | 63 | 0 | 43.3109081 | -97.14865776 | 2022-11-17 04:21:11 | Turner, South Dakota, US | |
2689315 | 2689315 | 2022-10-03 | US | Wyoming | Platte | 56031 | 2141 | 43 | 0 | 42.13299116 | -104.966331 | 2022-10-04 04:22:55 | Platte, Wyoming, US | |
2263382 | 2263382 | 2022-10-02 | US | Wyoming | Platte | 56031 | 2141 | 43 | 0 | 42.13299116 | -104.966331 | 2022-10-03 04:23:11 | Platte, Wyoming, US | |
2998908 | 2998908 | 2022-10-01 | US | Wyoming | Platte | 56031 | 2141 | 43 | 0 | 42.13299116 | -104.966331 | 2022-10-02 04:21:23 | Platte, Wyoming, US | |
857234 | 857234 | 2022-09-30 | US | Wyoming | Platte | 56031 | 2141 | 43 | 0 | 42.13299116 | -104.966331 | 2022-10-01 04:23:01 | Platte, Wyoming, US | |
2379160 | 2379160 | 2022-09-29 | US | Wyoming | Platte | 56031 | 2141 | 43 | 0 | 42.13299116 | -104.966331 | 2022-09-30 04:23:09 | Platte, Wyoming, US | |
1563711 | 1563711 | 2022-09-28 | US | Wyoming | Platte | 56031 | 2141 | 43 | 0 | 42.13299116 | -104.966331 | 2022-09-29 04:22:34 | Platte, Wyoming, US | |
3998254 | 3998254 | 2022-09-27 | US | Wyoming | Platte | 56031 | 2141 | 43 | 0 | 42.13299116 | -104.966331 | 2022-09-28 04:23:01 | Platte, Wyoming, US | |
1373861 | 1373861 | 2022-09-21 | US | Virginia | Lancaster | 51103 | 2141 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-09-22 04:22:56 | Lancaster, Virginia, US | |
3988538 | 3988538 | 2022-09-15 | US | Missouri | Hickory | 29085 | 2141 | 58 | 0 | 37.94163617 | -93.3203037 | 2022-09-16 04:21:19 | Hickory, Missouri, US | |
1891055 | 1891055 | 2022-09-14 | US | Missouri | Hickory | 29085 | 2141 | 58 | 0 | 37.94163617 | -93.3203037 | 2022-09-15 04:21:02 | Hickory, Missouri, US | |
374110 | 374110 | 2022-09-13 | US | Missouri | Hickory | 29085 | 2141 | 58 | 0 | 37.94163617 | -93.3203037 | 2022-09-14 04:20:44 | Hickory, Missouri, US | |
2396712 | 2396712 | 2022-09-12 | US | Missouri | Hickory | 29085 | 2141 | 58 | 0 | 37.94163617 | -93.3203037 | 2022-09-13 04:20:57 | Hickory, Missouri, US | |
3767790 | 3767790 | 2022-09-11 | US | Missouri | Hickory | 29085 | 2141 | 58 | 0 | 37.94163617 | -93.3203037 | 2022-09-12 04:20:58 | Hickory, Missouri, US | |
3826365 | 3826365 | 2022-09-10 | US | Missouri | Hickory | 29085 | 2141 | 58 | 0 | 37.94163617 | -93.3203037 | 2022-09-11 04:20:50 | Hickory, Missouri, US | |
964822 | 964822 | 2022-09-09 | US | Missouri | Hickory | 29085 | 2141 | 58 | 0 | 37.94163617 | -93.3203037 | 2022-09-10 04:21:10 | Hickory, Missouri, US | |
2326855 | 2326855 | 2022-08-24 | US | West Virginia | Pendleton | 54071 | 2141 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-08-25 04:21:13 | Pendleton, West Virginia, US | |
2323859 | 2323859 | 2022-08-24 | US | Arkansas | Monroe | 5095 | 2141 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-08-25 04:21:13 | Monroe, Arkansas, US | |
2855250 | 2855250 | 2022-08-22 | US | North Dakota | Benson | 38005 | 2141 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-08-23 04:20:56 | Benson, North Dakota, US | |
994372 | 994372 | 2022-08-16 | US | Virginia | Middlesex | 51119 | 2141 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-08-17 04:20:59 | Middlesex, Virginia, US | |
2494698 | 2494698 | 2022-08-15 | US | Colorado | Yuma | 8125 | 2141 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-16 04:20:58 | Yuma, Colorado, US | |
1100538 | 1100538 | 2022-08-03 | US | North Dakota | Pembina | 38067 | 2141 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-08-04 04:20:58 | Pembina, North Dakota, US | |
1212599 | 1212599 | 2022-07-11 | US | Illinois | Schuyler | 17169 | 2141 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-07-12 04:20:51 | Schuyler, Illinois, US | |
2792349 | 2792349 | 2022-07-10 | US | Virginia | Buena Vista | 51530 | 2141 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-07-11 04:20:46 | Buena Vista, Virginia, US | |
145302 | 145302 | 2022-07-09 | US | Virginia | Buena Vista | 51530 | 2141 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-07-10 04:20:54 | Buena Vista, Virginia, US | |
1420402 | 1420402 | 2022-07-08 | US | Virginia | Buena Vista | 51530 | 2141 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-07-09 04:20:59 | Buena Vista, Virginia, US | |
1764856 | 1764856 | 2022-06-20 | US | Louisiana | Red River | 22081 | 2141 | 53 | 0 | 32.09530039 | -93.34213308 | 2022-06-21 04:20:56 | Red River, Louisiana, US | |
3888146 | 3888146 | 2022-06-06 | US | Arkansas | Searcy | 5129 | 2141 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-06-07 04:21:08 | Searcy, Arkansas, US | |
3507915 | 3507915 | 2022-06-05 | US | Arkansas | Searcy | 5129 | 2141 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-06-06 04:20:57 | Searcy, Arkansas, US | |
230910 | 230910 | 2022-05-31 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-06-01 04:20:55 | Presque Isle, Michigan, US | |
230100 | 230100 | 2022-05-31 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-06-01 04:20:55 | Seminole, Georgia, US | |
3187675 | 3187675 | 2022-05-30 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-05-31 04:20:51 | Presque Isle, Michigan, US | |
3186865 | 3186865 | 2022-05-30 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-31 04:20:51 | Seminole, Georgia, US | |
3199824 | 3199824 | 2022-05-29 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-05-30 04:20:50 | Presque Isle, Michigan, US | |
3199014 | 3199014 | 2022-05-29 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-30 04:20:50 | Seminole, Georgia, US | |
2726702 | 2726702 | 2022-05-28 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-05-29 04:20:53 | Presque Isle, Michigan, US | |
2725892 | 2725892 | 2022-05-28 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-29 04:20:53 | Seminole, Georgia, US | |
1315883 | 1315883 | 2022-05-27 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-05-28 04:21:07 | Presque Isle, Michigan, US | |
1315073 | 1315073 | 2022-05-27 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-28 04:21:07 | Seminole, Georgia, US | |
1851675 | 1851675 | 2022-05-26 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-05-27 04:20:56 | Presque Isle, Michigan, US | |
1850865 | 1850865 | 2022-05-26 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-27 04:20:56 | Seminole, Georgia, US | |
2049551 | 2049551 | 2022-05-25 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-05-26 04:20:50 | Presque Isle, Michigan, US | |
2048741 | 2048741 | 2022-05-25 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-26 04:20:50 | Seminole, Georgia, US | |
623562 | 623562 | 2022-05-22 | US | Michigan | Presque Isle | 26141 | 2141 | 59 | 0 | 45.34018577 | -83.91498656 | 2022-05-26 04:20:50 | Presque Isle, Michigan, US | |
622752 | 622752 | 2022-05-22 | US | Georgia | Seminole | 13253 | 2141 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-05-26 04:20:50 | Seminole, Georgia, US | |
1327088 | 1327088 | 2022-04-26 | US | Georgia | Macon | 13193 | 2141 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-27 04:20:52 | Macon, Georgia, US | |
3723042 | 3723042 | 2022-04-25 | US | Georgia | Macon | 13193 | 2141 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-26 04:20:51 | Macon, Georgia, US | |
2029610 | 2029610 | 2022-04-24 | US | Georgia | Macon | 13193 | 2141 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-25 04:20:56 | Macon, Georgia, US | |
747185 | 747185 | 2022-04-23 | US | Georgia | Macon | 13193 | 2141 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-24 04:20:56 | Macon, Georgia, US | |
3439989 | 3439989 | 2022-04-22 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-23 04:20:50 | Live Oak, Texas, US | |
3437670 | 3437670 | 2022-04-22 | US | Georgia | Macon | 13193 | 2141 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-23 04:20:50 | Macon, Georgia, US | |
2895574 | 2895574 | 2022-04-21 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-22 04:20:45 | Live Oak, Texas, US | |
2893255 | 2893255 | 2022-04-21 | US | Georgia | Macon | 13193 | 2141 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-22 04:20:45 | Macon, Georgia, US | |
2310446 | 2310446 | 2022-04-20 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-21 04:20:46 | Live Oak, Texas, US | |
2308127 | 2308127 | 2022-04-20 | US | Georgia | Macon | 13193 | 2141 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-21 04:20:46 | Macon, Georgia, US | |
2254585 | 2254585 | 2022-04-19 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-20 04:20:45 | Live Oak, Texas, US | |
1849135 | 1849135 | 2022-04-18 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-19 04:21:00 | Live Oak, Texas, US | |
3420079 | 3420079 | 2022-04-17 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-18 04:21:12 | Live Oak, Texas, US | |
307028 | 307028 | 2022-04-16 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-17 04:20:59 | Live Oak, Texas, US | |
2672973 | 2672973 | 2022-04-15 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-16 04:20:48 | Live Oak, Texas, US | |
1226758 | 1226758 | 2022-04-14 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-15 04:20:57 | Live Oak, Texas, US | |
2445916 | 2445916 | 2022-04-13 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-13 23:21:06 | Live Oak, Texas, US | |
1951673 | 1951673 | 2022-04-12 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-13 04:21:03 | Live Oak, Texas, US | |
3209426 | 3209426 | 2022-04-11 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-12 04:20:49 | Live Oak, Texas, US | |
3208061 | 3208061 | 2022-04-11 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-12 04:20:49 | Claiborne, Mississippi, US | |
3207994 | 3207994 | 2022-04-11 | US | Minnesota | Jackson | 27063 | 2141 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-12 04:20:49 | Jackson, Minnesota, US | |
1579312 | 1579312 | 2022-04-10 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-11 04:21:02 | Live Oak, Texas, US | |
1577947 | 1577947 | 2022-04-10 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-11 04:21:02 | Claiborne, Mississippi, US | |
1577880 | 1577880 | 2022-04-10 | US | Minnesota | Jackson | 27063 | 2141 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-11 04:21:02 | Jackson, Minnesota, US | |
1655554 | 1655554 | 2022-04-09 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-10 04:20:52 | Live Oak, Texas, US | |
1654189 | 1654189 | 2022-04-09 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-10 04:20:52 | Claiborne, Mississippi, US | |
1654122 | 1654122 | 2022-04-09 | US | Minnesota | Jackson | 27063 | 2141 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-10 04:20:52 | Jackson, Minnesota, US | |
2118876 | 2118876 | 2022-04-08 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-09 04:20:42 | Live Oak, Texas, US | |
2117511 | 2117511 | 2022-04-08 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-09 04:20:42 | Claiborne, Mississippi, US | |
2117444 | 2117444 | 2022-04-08 | US | Minnesota | Jackson | 27063 | 2141 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-09 04:20:42 | Jackson, Minnesota, US | |
3323400 | 3323400 | 2022-04-07 | US | Texas | Live Oak | 48297 | 2141 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-08 04:20:48 | Live Oak, Texas, US | |
3322981 | 3322981 | 2022-04-07 | US | Puerto Rico | Florida | 72054 | 2141 | 0 | 0 | 18.373715 | -66.560488 | 2022-04-08 04:20:48 | Florida, Puerto Rico, US | |
3322035 | 3322035 | 2022-04-07 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-08 04:20:48 | Claiborne, Mississippi, US | |
3321968 | 3321968 | 2022-04-07 | US | Minnesota | Jackson | 27063 | 2141 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-08 04:20:48 | Jackson, Minnesota, US | |
2802571 | 2802571 | 2022-04-06 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-07 04:20:53 | Claiborne, Mississippi, US | |
2802504 | 2802504 | 2022-04-06 | US | Minnesota | Jackson | 27063 | 2141 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-07 04:20:53 | Jackson, Minnesota, US | |
3869340 | 3869340 | 2022-04-05 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-06 04:20:49 | Claiborne, Mississippi, US | |
3869273 | 3869273 | 2022-04-05 | US | Minnesota | Jackson | 27063 | 2141 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-04-06 04:20:49 | Jackson, Minnesota, US | |
2750682 | 2750682 | 2022-04-04 | US | Mississippi | Claiborne | 28021 | 2141 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-05 04:20:48 | Claiborne, Mississippi, US | |
3732262 | 3732262 | 2022-04-03 | US | Montana | Sanders | 30089 | 2141 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-04-04 04:20:51 | Sanders, Montana, US | |
501697 | 501697 | 2022-04-02 | US | Montana | Sanders | 30089 | 2141 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-04-03 04:20:48 | Sanders, Montana, US | |
3352682 | 3352682 | 2022-04-01 | US | Montana | Sanders | 30089 | 2141 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-04-02 04:20:47 | Sanders, Montana, US | |
1541987 | 1541987 | 2022-03-31 | US | Montana | Sanders | 30089 | 2141 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-04-01 04:20:28 | Sanders, Montana, US | |
2480000 | 2480000 | 2022-03-30 | US | Montana | Sanders | 30089 | 2141 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-03-31 04:20:56 | Sanders, Montana, US | |
1470129 | 1470129 | 2022-03-24 | US | Montana | Sanders | 30089 | 2141 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-03-25 04:20:46 | Sanders, Montana, US | |
697456 | 697456 | 2022-03-17 | US | Texas | Dallam | 48111 | 2141 | 40 | 0 | 36.27787176 | -102.60207249999999 | 2022-03-18 04:20:55 | Dallam, Texas, US | |
696475 | 696475 | 2022-03-17 | US | Nebraska | Holt | 31089 | 2141 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-03-18 04:20:55 | Holt, Nebraska, 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]);