johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
336 rows where confirmed = 2078 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219594 | 219594 | 2022-12-26 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-27 04:21:07 | Alger, Michigan, US | |
3224051 | 3224051 | 2022-12-25 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-26 04:21:06 | Alger, Michigan, US | |
1019965 | 1019965 | 2022-12-24 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-25 04:21:04 | Alger, Michigan, US | |
691988 | 691988 | 2022-12-23 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-24 04:21:02 | Alger, Michigan, US | |
2181198 | 2181198 | 2022-12-22 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-23 04:21:04 | Alger, Michigan, US | |
453002 | 453002 | 2022-12-21 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-22 04:20:56 | Alger, Michigan, US | |
2953001 | 2953001 | 2022-12-20 | US | Michigan | Alger | 26003 | 2078 | 18 | 0 | 46.41292944 | -86.60260122 | 2022-12-21 04:21:03 | Alger, Michigan, US | |
869788 | 869788 | 2022-12-11 | US | Illinois | Edwards | 17047 | 2078 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-12-12 04:21:01 | Edwards, Illinois, US | |
258318 | 258318 | 2022-12-10 | US | Illinois | Edwards | 17047 | 2078 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-12-11 04:20:50 | Edwards, Illinois, US | |
3937032 | 3937032 | 2022-12-09 | US | Illinois | Edwards | 17047 | 2078 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-12-10 04:21:02 | Edwards, Illinois, US | |
1621572 | 1621572 | 2022-11-22 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-23 04:21:06 | Greenwood, Kansas, US | |
3461460 | 3461460 | 2022-11-21 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-22 04:20:47 | Greenwood, Kansas, US | |
1641645 | 1641645 | 2022-11-20 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-21 04:21:05 | Greenwood, Kansas, US | |
2065202 | 2065202 | 2022-11-19 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-20 04:21:08 | Greenwood, Kansas, US | |
1756596 | 1756596 | 2022-11-18 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-19 04:21:14 | Greenwood, Kansas, US | |
3027589 | 3027589 | 2022-11-17 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-18 04:21:15 | Greenwood, Kansas, US | |
2487300 | 2487300 | 2022-11-16 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-17 04:21:11 | Greenwood, Kansas, US | |
293311 | 293311 | 2022-11-15 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-16 04:21:09 | Greenwood, Kansas, US | |
3598341 | 3598341 | 2022-11-14 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-15 04:21:16 | Greenwood, Kansas, US | |
313199 | 313199 | 2022-11-13 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-14 04:21:09 | Greenwood, Kansas, US | |
311702 | 311702 | 2022-11-13 | China | Liaoning | 2078 | 2 | 0 | 41.2956 | 122.6085 | 2022-11-14 04:21:09 | Liaoning, China | |||
64360 | 64360 | 2022-11-12 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-13 04:21:14 | Greenwood, Kansas, US | |
2928522 | 2928522 | 2022-11-11 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-12 04:20:41 | Greenwood, Kansas, US | |
2507358 | 2507358 | 2022-11-10 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-11 04:21:22 | Greenwood, Kansas, US | |
2432233 | 2432233 | 2022-11-09 | US | Kansas | Greenwood | 20073 | 2078 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-10 04:21:16 | Greenwood, Kansas, US | |
711106 | 711106 | 2022-11-01 | US | Colorado | Rio Blanco | 8103 | 2078 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-11-02 04:22:09 | Rio Blanco, Colorado, US | |
3574026 | 3574026 | 2022-09-19 | US | Virginia | Williamsburg | 51830 | 2078 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-20 04:22:48 | Williamsburg, Virginia, US | |
1396682 | 1396682 | 2022-09-02 | US | Tennessee | Van Buren | 47175 | 2078 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-09-03 04:21:04 | Van Buren, Tennessee, US | |
2346492 | 2346492 | 2022-08-31 | US | Texas | Crosby | 48107 | 2078 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-09-01 04:21:03 | Crosby, Texas, US | |
2324882 | 2324882 | 2022-08-24 | US | Louisiana | St. Helena | 22091 | 2078 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-25 04:21:13 | St. Helena, Louisiana, US | |
994359 | 994359 | 2022-08-16 | US | Virginia | Lancaster | 51103 | 2078 | 35 | 0 | 37.71889653 | -76.46400482 | 2022-08-17 04:20:59 | Lancaster, Virginia, US | |
2497398 | 2497398 | 2022-08-15 | US | Virginia | Lancaster | 51103 | 2078 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-08-16 04:20:58 | Lancaster, Virginia, US | |
3547057 | 3547057 | 2022-08-08 | US | Wisconsin | Menominee | 55078 | 2078 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-08-09 04:20:34 | Menominee, Wisconsin, US | |
1070504 | 1070504 | 2022-08-07 | US | Colorado | Conejos | 8021 | 2078 | 57 | 0 | 37.201606 | -106.1917488 | 2022-08-08 04:21:08 | Conejos, Colorado, US | |
2338774 | 2338774 | 2022-07-27 | US | Virginia | Middlesex | 51119 | 2078 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-07-28 04:20:56 | Middlesex, Virginia, US | |
1489975 | 1489975 | 2022-07-26 | US | North Dakota | Benson | 38005 | 2078 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-07-27 04:21:04 | Benson, North Dakota, US | |
1488108 | 1488108 | 2022-07-26 | US | Arkansas | Prairie | 5117 | 2078 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-07-27 04:21:04 | Prairie, Arkansas, US | |
2593843 | 2593843 | 2022-07-25 | China | Tianjin | 2078 | 3 | 0 | 39.3054 | 117.323 | 2022-07-26 04:20:58 | Tianjin, China | |||
962469 | 962469 | 2022-07-19 | US | Wisconsin | Pepin | 55091 | 2078 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-07-20 04:20:59 | Pepin, Wisconsin, US | |
1770292 | 1770292 | 2022-07-03 | US | Tennessee | Hancock | 47067 | 2078 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-07-04 04:20:54 | Hancock, Tennessee, US | |
3368278 | 3368278 | 2022-07-02 | US | Tennessee | Hancock | 47067 | 2078 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-07-03 04:20:59 | Hancock, Tennessee, US | |
596607 | 596607 | 2022-07-01 | US | Tennessee | Hancock | 47067 | 2078 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-07-02 04:21:16 | Hancock, Tennessee, US | |
3942003 | 3942003 | 2022-06-30 | US | Missouri | Oregon | 29149 | 2078 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-07-01 04:21:10 | Oregon, Missouri, US | |
2491961 | 2491961 | 2022-06-29 | US | Missouri | Oregon | 29149 | 2078 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-30 04:21:01 | Oregon, Missouri, US | |
2241343 | 2241343 | 2022-06-28 | US | Missouri | Oregon | 29149 | 2078 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-29 04:20:59 | Oregon, Missouri, US | |
2149585 | 2149585 | 2022-06-27 | US | Missouri | Oregon | 29149 | 2078 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-28 04:20:58 | Oregon, Missouri, US | |
477386 | 477386 | 2022-06-26 | US | Missouri | Oregon | 29149 | 2078 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-27 04:21:00 | Oregon, Missouri, US | |
940761 | 940761 | 2022-06-25 | US | Missouri | Oregon | 29149 | 2078 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-26 04:21:02 | Oregon, Missouri, US | |
3348581 | 3348581 | 2022-06-24 | US | Missouri | Oregon | 29149 | 2078 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-25 04:20:57 | Oregon, Missouri, US | |
2311100 | 2311100 | 2022-06-17 | China | Inner Mongolia | 2078 | 1 | 0 | 44.0935 | 113.9448 | 2022-06-18 04:21:10 | Inner Mongolia, China | |||
1112910 | 1112910 | 2022-05-21 | US | Virginia | Fairfax City | 51600 | 2078 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-05-22 04:20:52 | Fairfax City, Virginia, US | |
1172534 | 1172534 | 2022-05-20 | US | Virginia | Fairfax City | 51600 | 2078 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-05-21 04:20:58 | Fairfax City, Virginia, US | |
3586151 | 3586151 | 2022-05-17 | US | West Virginia | Pocahontas | 54075 | 2078 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-05-18 04:20:50 | Pocahontas, West Virginia, US | |
1507108 | 1507108 | 2022-05-16 | US | West Virginia | Pocahontas | 54075 | 2078 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-05-17 04:20:59 | Pocahontas, West Virginia, US | |
1507107 | 1507107 | 2022-05-16 | US | West Virginia | Pleasants | 54073 | 2078 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-05-17 04:20:59 | Pleasants, West Virginia, US | |
658124 | 658124 | 2022-05-13 | China | Sichuan | 2078 | 3 | 0 | 30.6171 | 102.7103 | 2022-05-14 04:20:48 | Sichuan, China | |||
2115531 | 2115531 | 2022-04-08 | China | Yunnan | 2078 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-09 04:20:42 | Yunnan, China | |||
2115515 | 2115515 | 2022-04-08 | China | Jiangsu | 2078 | 0 | 0 | 32.9711 | 119.455 | 2022-04-09 04:20:42 | Jiangsu, China | |||
3320055 | 3320055 | 2022-04-07 | China | Yunnan | 2078 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-08 04:20:48 | Yunnan, China | |||
2751690 | 2751690 | 2022-04-04 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-05 04:20:48 | Allendale, South Carolina, US | |
3733036 | 3733036 | 2022-04-03 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-04 04:20:51 | Allendale, South Carolina, US | |
502471 | 502471 | 2022-04-02 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-03 04:20:48 | Allendale, South Carolina, US | |
3353456 | 3353456 | 2022-04-01 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-02 04:20:47 | Allendale, South Carolina, US | |
1542761 | 1542761 | 2022-03-31 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-01 04:20:28 | Allendale, South Carolina, US | |
2480774 | 2480774 | 2022-03-30 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-31 04:20:56 | Allendale, South Carolina, US | |
160815 | 160815 | 2022-03-29 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-30 04:20:45 | Allendale, South Carolina, US | |
3241130 | 3241130 | 2022-03-21 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-22 04:20:54 | Allendale, South Carolina, US | |
27203 | 27203 | 2022-03-20 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-21 04:20:50 | Allendale, South Carolina, US | |
1659213 | 1659213 | 2022-03-19 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-20 04:20:45 | Allendale, South Carolina, US | |
338739 | 338739 | 2022-03-18 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-19 04:20:47 | Allendale, South Carolina, US | |
697192 | 697192 | 2022-03-17 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-18 04:20:55 | Allendale, South Carolina, US | |
2322135 | 2322135 | 2022-03-16 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-17 04:20:56 | Allendale, South Carolina, US | |
264335 | 264335 | 2022-03-15 | US | South Carolina | Allendale | 45005 | 2078 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-03-16 04:20:50 | Allendale, South Carolina, US | |
3628725 | 3628725 | 2022-03-13 | US | Georgia | Candler | 13043 | 2078 | 93 | 0 | 32.40209349 | -82.07702563 | 2022-03-14 04:20:46 | Candler, Georgia, US | |
951633 | 951633 | 2022-03-12 | US | Georgia | Candler | 13043 | 2078 | 93 | 0 | 32.40209349 | -82.07702563 | 2022-03-13 04:20:49 | Candler, Georgia, US | |
357094 | 357094 | 2022-03-11 | US | Georgia | Candler | 13043 | 2078 | 93 | 0 | 32.40209349 | -82.07702563 | 2022-03-12 04:20:50 | Candler, Georgia, US | |
1551452 | 1551452 | 2022-03-07 | US | West Virginia | Gilmer | 54021 | 2078 | 18 | 0 | 38.9251277 | -80.85952723 | 2022-03-08 04:20:54 | Gilmer, West Virginia, US | |
2202354 | 2202354 | 2022-03-06 | US | Puerto Rico | Adjuntas | 72001 | 2078 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-03-07 04:20:47 | Adjuntas, Puerto Rico, US | |
1514598 | 1514598 | 2022-02-24 | US | Texas | Ochiltree | 48357 | 2078 | 46 | 0 | 36.27829105 | -100.8158184 | 2022-02-25 04:21:11 | Ochiltree, Texas, US | |
1511806 | 1511806 | 2022-02-24 | US | Alabama | Perry | 1105 | 2078 | 43 | 0 | 32.64048341 | -87.29770589 | 2022-02-25 04:21:11 | Perry, Alabama, US | |
1058247 | 1058247 | 2022-02-23 | US | Alabama | Perry | 1105 | 2078 | 43 | 0 | 32.64048341 | -87.29770589 | 2022-02-24 04:21:14 | Perry, Alabama, US | |
3720152 | 3720152 | 2022-02-21 | US | Missouri | St. Clair | 29185 | 2078 | 31 | 0 | 38.03699437 | -93.77631447 | 2022-02-22 04:21:01 | St. Clair, Missouri, US | |
3719562 | 3719562 | 2022-02-21 | US | Kentucky | Bracken | 21023 | 2078 | 23 | 0 | 38.69158994 | -84.08532444 | 2022-02-22 04:21:01 | Bracken, Kentucky, US | |
3913986 | 3913986 | 2022-02-20 | US | Missouri | St. Clair | 29185 | 2078 | 31 | 0 | 38.03699437 | -93.77631447 | 2022-02-21 04:21:05 | St. Clair, Missouri, US | |
3877544 | 3877544 | 2022-02-19 | US | Missouri | St. Clair | 29185 | 2078 | 31 | 0 | 38.03699437 | -93.77631447 | 2022-02-20 04:21:00 | St. Clair, Missouri, US | |
3857800 | 3857800 | 2022-02-18 | US | Missouri | St. Clair | 29185 | 2078 | 31 | 0 | 38.03699437 | -93.77631447 | 2022-02-19 04:21:11 | St. Clair, Missouri, US | |
1300823 | 1300823 | 2022-02-17 | US | Puerto Rico | Penuelas | 72111 | 2078 | 0 | 0 | 18.059645 | -66.721572 | 2022-02-18 04:21:04 | Penuelas, Puerto Rico, US | |
1300037 | 1300037 | 2022-02-17 | US | Montana | Beaverhead | 30001 | 2078 | 25 | 0 | 45.13434354 | -112.89846940000001 | 2022-02-18 04:21:04 | Beaverhead, Montana, US | |
1300019 | 1300019 | 2022-02-17 | US | Missouri | St. Clair | 29185 | 2078 | 31 | 0 | 38.03699437 | -93.77631447 | 2022-02-18 04:21:04 | St. Clair, Missouri, US | |
3823209 | 3823209 | 2022-02-16 | US | Puerto Rico | Penuelas | 72111 | 2078 | 0 | 0 | 18.059645 | -66.721572 | 2022-02-17 04:20:56 | Penuelas, Puerto Rico, US | |
3673046 | 3673046 | 2022-02-15 | US | Kentucky | Cumberland | 21057 | 2078 | 25 | 0 | 36.78926125 | -85.39050034 | 2022-02-16 04:21:10 | Cumberland, Kentucky, US | |
187547 | 187547 | 2022-02-13 | US | Kentucky | Trimble | 21223 | 2078 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-14 04:20:51 | Trimble, Kentucky, US | |
317393 | 317393 | 2022-02-12 | US | Kentucky | Trimble | 21223 | 2078 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-13 04:21:00 | Trimble, Kentucky, US | |
234719 | 234719 | 2022-02-11 | US | Kentucky | Trimble | 21223 | 2078 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-12 04:21:06 | Trimble, Kentucky, US | |
2474948 | 2474948 | 2022-02-03 | US | Illinois | Hamilton | 17065 | 2078 | 28 | 0 | 38.08163641 | -88.53883373 | 2022-02-04 04:21:10 | Hamilton, Illinois, US | |
460373 | 460373 | 2022-02-02 | US | Illinois | Hamilton | 17065 | 2078 | 28 | 0 | 38.08163641 | -88.53883373 | 2022-02-03 04:21:21 | Hamilton, Illinois, US | |
979769 | 979769 | 2022-02-01 | US | Georgia | Heard | 13149 | 2078 | 44 | 0 | 33.29686567 | -85.12886832 | 2022-02-02 04:21:09 | Heard, Georgia, US | |
1782899 | 1782899 | 2022-01-27 | US | West Virginia | Ritchie | 54085 | 2078 | 27 | 0 | 39.18094587 | -81.06356878 | 2022-01-28 04:21:09 | Ritchie, West Virginia, US | |
1320210 | 1320210 | 2022-01-26 | US | Montana | Deer Lodge | 30023 | 2078 | 29 | 0 | 46.05953325 | -113.073353 | 2022-01-27 04:21:19 | Deer Lodge, Montana, US | |
1319152 | 1319152 | 2022-01-26 | US | Idaho | Fremont | 16043 | 2078 | 22 | 0 | 44.22800938 | -111.48099429999999 | 2022-01-27 04:21:19 | Fremont, Idaho, 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]);