johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
372 rows where confirmed = 2135 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3597679 | 3597679 | 2022-11-14 | US | Colorado | Lake | 8065 | 2135 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-15 04:21:16 | Lake, Colorado, US | |
3098979 | 3098979 | 2022-10-09 | US | Louisiana | St. Helena | 22091 | 2135 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-10 04:22:32 | St. Helena, Louisiana, US | |
4004204 | 4004204 | 2022-10-08 | US | Louisiana | St. Helena | 22091 | 2135 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-09 04:21:16 | St. Helena, Louisiana, US | |
397801 | 397801 | 2022-10-07 | US | Louisiana | St. Helena | 22091 | 2135 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-10-08 04:22:56 | St. Helena, Louisiana, US | |
1812943 | 1812943 | 2022-10-05 | US | New Hampshire | Unassigned | 90033 | 2135 | 4 | 0 | 44.69063265 | 0.0 | 2022-10-06 04:21:22 | Unassigned, New Hampshire, US | |
1560706 | 1560706 | 2022-09-28 | US | Colorado | Conejos | 8021 | 2135 | 57 | 0 | 37.201606 | -106.1917488 | 2022-09-29 04:22:34 | Conejos, Colorado, US | |
1560472 | 1560472 | 2022-09-28 | US | Alabama | Greene | 1063 | 2135 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-09-29 04:22:34 | Greene, Alabama, US | |
3995015 | 3995015 | 2022-09-27 | US | Alabama | Greene | 1063 | 2135 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-09-28 04:23:01 | Greene, Alabama, US | |
2769343 | 2769343 | 2022-09-26 | US | Alabama | Greene | 1063 | 2135 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-09-27 04:23:01 | Greene, Alabama, US | |
1976996 | 1976996 | 2022-09-25 | US | Alabama | Greene | 1063 | 2135 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-09-26 04:20:52 | Greene, Alabama, US | |
2650163 | 2650163 | 2022-09-24 | US | Alabama | Greene | 1063 | 2135 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-09-25 04:23:31 | Greene, Alabama, US | |
384603 | 384603 | 2022-09-23 | US | Alabama | Greene | 1063 | 2135 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-09-24 04:21:40 | Greene, Alabama, US | |
1624669 | 1624669 | 2022-09-22 | US | Alabama | Greene | 1063 | 2135 | 52 | 0 | 32.85504247 | -87.95684022 | 2022-09-23 04:23:13 | Greene, Alabama, US | |
372623 | 372623 | 2022-09-13 | US | Alaska | Dillingham | 2070 | 2135 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-14 04:20:44 | Dillingham, Alaska, US | |
2395225 | 2395225 | 2022-09-12 | US | Alaska | Dillingham | 2070 | 2135 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-13 04:20:57 | Dillingham, Alaska, US | |
3766303 | 3766303 | 2022-09-11 | US | Alaska | Dillingham | 2070 | 2135 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-12 04:20:58 | Dillingham, Alaska, US | |
3824878 | 3824878 | 2022-09-10 | US | Alaska | Dillingham | 2070 | 2135 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-11 04:20:50 | Dillingham, Alaska, US | |
963335 | 963335 | 2022-09-09 | US | Alaska | Dillingham | 2070 | 2135 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-10 04:21:10 | Dillingham, Alaska, US | |
253737 | 253737 | 2022-09-08 | US | Alaska | Dillingham | 2070 | 2135 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-09 04:21:11 | Dillingham, Alaska, US | |
3745535 | 3745535 | 2022-09-07 | US | Alaska | Dillingham | 2070 | 2135 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-08 04:21:02 | Dillingham, Alaska, US | |
2855971 | 2855971 | 2022-08-22 | US | Texas | Hansford | 48195 | 2135 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-08-23 04:20:56 | Hansford, Texas, US | |
2403344 | 2403344 | 2022-08-21 | US | Arkansas | Monroe | 5095 | 2135 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-08-22 04:20:38 | Monroe, Arkansas, US | |
3800300 | 3800300 | 2022-08-20 | US | North Dakota | Benson | 38005 | 2135 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-08-21 04:20:44 | Benson, North Dakota, US | |
3798422 | 3798422 | 2022-08-20 | US | Arkansas | Monroe | 5095 | 2135 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-08-21 04:20:44 | Monroe, Arkansas, US | |
2365886 | 2365886 | 2022-08-19 | US | North Dakota | Benson | 38005 | 2135 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-08-20 04:21:01 | Benson, North Dakota, US | |
1087361 | 1087361 | 2022-08-09 | US | Kansas | Ellsworth | 20053 | 2135 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-08-10 04:20:57 | Ellsworth, Kansas, US | |
3544776 | 3544776 | 2022-08-08 | US | Kansas | Ellsworth | 20053 | 2135 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-08-09 04:20:34 | Ellsworth, Kansas, US | |
1071956 | 1071956 | 2022-08-07 | US | Nebraska | Custer | 31041 | 2135 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-08-08 04:21:08 | Custer, Nebraska, US | |
1071179 | 1071179 | 2022-08-07 | US | Kansas | Ellsworth | 20053 | 2135 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-08-08 04:21:08 | Ellsworth, Kansas, US | |
1942544 | 1942544 | 2022-08-06 | US | Nebraska | Custer | 31041 | 2135 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-08-07 04:20:54 | Custer, Nebraska, US | |
1941767 | 1941767 | 2022-08-06 | US | Kansas | Ellsworth | 20053 | 2135 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-08-07 04:20:54 | Ellsworth, Kansas, US | |
882343 | 882343 | 2022-08-05 | US | Nebraska | Custer | 31041 | 2135 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-08-06 04:20:56 | Custer, Nebraska, US | |
881566 | 881566 | 2022-08-05 | US | Kansas | Ellsworth | 20053 | 2135 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-08-06 04:20:56 | Ellsworth, Kansas, US | |
2010754 | 2010754 | 2022-08-04 | US | Nebraska | Custer | 31041 | 2135 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-08-05 04:20:52 | Custer, Nebraska, US | |
2010635 | 2010635 | 2022-08-04 | US | Missouri | Oregon | 29149 | 2135 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-08-05 04:20:52 | Oregon, Missouri, US | |
2009977 | 2009977 | 2022-08-04 | US | Kansas | Ellsworth | 20053 | 2135 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-08-05 04:20:52 | Ellsworth, Kansas, US | |
1100181 | 1100181 | 2022-08-03 | US | Nebraska | Custer | 31041 | 2135 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-08-04 04:20:58 | Custer, Nebraska, US | |
1100062 | 1100062 | 2022-08-03 | US | Missouri | Oregon | 29149 | 2135 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-08-04 04:20:58 | Oregon, Missouri, US | |
1099404 | 1099404 | 2022-08-03 | US | Kansas | Ellsworth | 20053 | 2135 | 32 | 0 | 38.69677695 | -98.20462799 | 2022-08-04 04:20:58 | Ellsworth, Kansas, US | |
1406987 | 1406987 | 2022-08-02 | US | Missouri | Oregon | 29149 | 2135 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-08-03 04:20:59 | Oregon, Missouri, US | |
3619025 | 3619025 | 2022-08-01 | US | Missouri | Oregon | 29149 | 2135 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-08-02 04:20:53 | Oregon, Missouri, US | |
3875079 | 3875079 | 2022-07-31 | US | West Virginia | Tucker | 54093 | 2135 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-08-01 04:21:03 | Tucker, West Virginia, US | |
3873505 | 3873505 | 2022-07-31 | US | Missouri | Oregon | 29149 | 2135 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-08-01 04:21:03 | Oregon, Missouri, US | |
677833 | 677833 | 2022-07-30 | US | West Virginia | Tucker | 54093 | 2135 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-07-31 04:21:02 | Tucker, West Virginia, US | |
676259 | 676259 | 2022-07-30 | US | Missouri | Oregon | 29149 | 2135 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-07-31 04:21:02 | Oregon, Missouri, US | |
1787032 | 1787032 | 2022-07-29 | US | West Virginia | Tucker | 54093 | 2135 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-07-30 04:20:42 | Tucker, West Virginia, US | |
1785458 | 1785458 | 2022-07-29 | US | Missouri | Oregon | 29149 | 2135 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-07-30 04:20:42 | Oregon, Missouri, US | |
1069395 | 1069395 | 2022-07-28 | US | West Virginia | Tucker | 54093 | 2135 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-07-29 04:20:45 | Tucker, West Virginia, US | |
2338914 | 2338914 | 2022-07-27 | US | West Virginia | Tucker | 54093 | 2135 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-07-28 04:20:56 | Tucker, West Virginia, US | |
899372 | 899372 | 2022-07-24 | US | Texas | Somervell | 48425 | 2135 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-07-25 04:20:51 | Somervell, Texas, US | |
94366 | 94366 | 2022-07-23 | US | Texas | Somervell | 48425 | 2135 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-07-24 04:20:47 | Somervell, Texas, US | |
1213760 | 1213760 | 2022-07-11 | US | New Mexico | Quay | 35037 | 2135 | 58 | 0 | 35.10403332 | -103.5481727 | 2022-07-12 04:20:51 | Quay, New Mexico, US | |
3942049 | 3942049 | 2022-06-30 | US | Montana | Carbon | 30009 | 2135 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-01 04:21:10 | Carbon, Montana, US | |
2492007 | 2492007 | 2022-06-29 | US | Montana | Carbon | 30009 | 2135 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-06-30 04:21:01 | Carbon, Montana, US | |
2241389 | 2241389 | 2022-06-28 | US | Montana | Carbon | 30009 | 2135 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-06-29 04:20:59 | Carbon, Montana, US | |
2149631 | 2149631 | 2022-06-27 | US | Montana | Carbon | 30009 | 2135 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-06-28 04:20:58 | Carbon, Montana, US | |
477432 | 477432 | 2022-06-26 | US | Montana | Carbon | 30009 | 2135 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-06-27 04:21:00 | Carbon, Montana, US | |
940807 | 940807 | 2022-06-25 | US | Montana | Carbon | 30009 | 2135 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-06-26 04:21:02 | Carbon, Montana, US | |
3348627 | 3348627 | 2022-06-24 | US | Montana | Carbon | 30009 | 2135 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-06-25 04:20:57 | Carbon, Montana, US | |
1850518 | 1850518 | 2022-05-26 | US | Arkansas | Searcy | 5129 | 2135 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-05-27 04:20:56 | Searcy, Arkansas, US | |
3001046 | 3001046 | 2022-05-24 | US | Minnesota | Marshall | 27089 | 2135 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-05-25 04:20:56 | Marshall, Minnesota, US | |
1109389 | 1109389 | 2022-05-21 | China | Yunnan | 2135 | 2 | 0 | 24.974 | 101.487 | 2022-05-22 04:20:52 | Yunnan, China | |||
2535131 | 2535131 | 2022-05-12 | US | Minnesota | Lake | 27075 | 2135 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-05-13 04:20:51 | Lake, Minnesota, US | |
1574121 | 1574121 | 2022-05-03 | US | Montana | Beaverhead | 30001 | 2135 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-04 04:20:59 | Beaverhead, Montana, US | |
465381 | 465381 | 2022-05-02 | US | Montana | Beaverhead | 30001 | 2135 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-03 04:21:00 | Beaverhead, Montana, US | |
3918020 | 3918020 | 2022-05-01 | US | Montana | Beaverhead | 30001 | 2135 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-02 04:21:10 | Beaverhead, Montana, US | |
2842824 | 2842824 | 2022-04-30 | US | Montana | Beaverhead | 30001 | 2135 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-05-01 04:20:57 | Beaverhead, Montana, US | |
1159137 | 1159137 | 2022-04-29 | US | Montana | Beaverhead | 30001 | 2135 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-04-30 04:21:05 | Beaverhead, Montana, US | |
1698319 | 1698319 | 2022-04-28 | US | Montana | Beaverhead | 30001 | 2135 | 30 | 0 | 45.13434354 | -112.8984694 | 2022-04-29 04:20:59 | Beaverhead, Montana, US | |
1224347 | 1224347 | 2022-04-14 | US | Georgia | Atkinson | 13003 | 2135 | 48 | 0 | 31.29633502 | -82.87545866 | 2022-04-15 04:20:57 | Atkinson, Georgia, US | |
2803490 | 2803490 | 2022-04-06 | US | Puerto Rico | Adjuntas | 72001 | 2135 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-04-07 04:20:53 | Adjuntas, Puerto Rico, US | |
1542974 | 1542974 | 2022-03-31 | US | Texas | Archer | 48009 | 2135 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-04-01 04:20:28 | Archer, Texas, US | |
158885 | 158885 | 2022-03-29 | US | Georgia | Seminole | 13253 | 2135 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-30 04:20:45 | Seminole, Georgia, US | |
696117 | 696117 | 2022-03-17 | US | Minnesota | Jackson | 27063 | 2135 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-03-18 04:20:55 | Jackson, Minnesota, US | |
2322811 | 2322811 | 2022-03-16 | US | West Virginia | Doddridge | 54017 | 2135 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-17 04:20:56 | Doddridge, West Virginia, US | |
2322492 | 2322492 | 2022-03-16 | US | Texas | Live Oak | 48297 | 2135 | 41 | 0 | 28.35101362 | -98.1246786 | 2022-03-17 04:20:56 | Live Oak, Texas, US | |
264692 | 264692 | 2022-03-15 | US | Texas | Live Oak | 48297 | 2135 | 41 | 0 | 28.35101362 | -98.1246786 | 2022-03-16 04:20:50 | Live Oak, Texas, US | |
2267051 | 2267051 | 2022-03-14 | US | Texas | Live Oak | 48297 | 2135 | 41 | 0 | 28.35101362 | -98.1246786 | 2022-03-15 04:20:47 | Live Oak, Texas, US | |
2264640 | 2264640 | 2022-03-14 | US | Georgia | Atkinson | 13003 | 2135 | 47 | 0 | 31.29633502 | -82.87545866 | 2022-03-15 04:20:47 | Atkinson, Georgia, US | |
3631340 | 3631340 | 2022-03-13 | US | Virginia | Northampton | 51131 | 2135 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-14 04:20:46 | Northampton, Virginia, US | |
3631117 | 3631117 | 2022-03-13 | US | Texas | Live Oak | 48297 | 2135 | 41 | 0 | 28.35101362 | -98.1246786 | 2022-03-14 04:20:46 | Live Oak, Texas, US | |
3629986 | 3629986 | 2022-03-13 | US | Montana | Sanders | 30089 | 2135 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-03-14 04:20:46 | Sanders, Montana, US | |
954248 | 954248 | 2022-03-12 | US | Virginia | Northampton | 51131 | 2135 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-13 04:20:49 | Northampton, Virginia, US | |
954025 | 954025 | 2022-03-12 | US | Texas | Live Oak | 48297 | 2135 | 41 | 0 | 28.35101362 | -98.1246786 | 2022-03-13 04:20:49 | Live Oak, Texas, US | |
952894 | 952894 | 2022-03-12 | US | Montana | Sanders | 30089 | 2135 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-03-13 04:20:49 | Sanders, Montana, US | |
359709 | 359709 | 2022-03-11 | US | Virginia | Northampton | 51131 | 2135 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-12 04:20:50 | Northampton, Virginia, US | |
359486 | 359486 | 2022-03-11 | US | Texas | Live Oak | 48297 | 2135 | 41 | 0 | 28.35101362 | -98.1246786 | 2022-03-12 04:20:50 | Live Oak, Texas, US | |
358355 | 358355 | 2022-03-11 | US | Montana | Sanders | 30089 | 2135 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-03-12 04:20:50 | Sanders, Montana, US | |
1868861 | 1868861 | 2022-03-10 | US | Virginia | Northampton | 51131 | 2135 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-11 04:20:50 | Northampton, Virginia, US | |
1868638 | 1868638 | 2022-03-10 | US | Texas | Live Oak | 48297 | 2135 | 40 | 0 | 28.35101362 | -98.1246786 | 2022-03-11 04:20:50 | Live Oak, Texas, US | |
2143333 | 2143333 | 2022-03-09 | US | Texas | Live Oak | 48297 | 2135 | 40 | 0 | 28.35101362 | -98.1246786 | 2022-03-10 04:20:48 | Live Oak, Texas, US | |
2201539 | 2201539 | 2022-03-06 | US | Missouri | DeKalb | 29063 | 2135 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-07 04:20:47 | DeKalb, Missouri, US | |
2093996 | 2093996 | 2022-03-05 | US | Missouri | DeKalb | 29063 | 2135 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-06 04:20:49 | DeKalb, Missouri, US | |
2667696 | 2667696 | 2022-03-04 | US | Missouri | DeKalb | 29063 | 2135 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-05 04:21:10 | DeKalb, Missouri, US | |
1646261 | 1646261 | 2022-03-03 | US | Missouri | DeKalb | 29063 | 2135 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-04 04:21:09 | DeKalb, Missouri, US | |
1645839 | 1645839 | 2022-03-03 | US | Kentucky | Trimble | 21223 | 2135 | 38 | 0 | 38.61056487 | -85.33775972 | 2022-03-04 04:21:09 | Trimble, Kentucky, US | |
2527264 | 2527264 | 2022-03-02 | US | Missouri | DeKalb | 29063 | 2135 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-03 04:21:01 | DeKalb, Missouri, US | |
1994454 | 1994454 | 2022-03-01 | US | Mississippi | Claiborne | 28021 | 2135 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-03-02 04:21:07 | Claiborne, Mississippi, US | |
944628 | 944628 | 2022-02-28 | US | Mississippi | Claiborne | 28021 | 2135 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-03-01 04:21:09 | Claiborne, Mississippi, US | |
1061233 | 1061233 | 2022-02-23 | US | Virginia | Northumberland | 51133 | 2135 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-02-24 04:21:14 | Northumberland, Virginia, 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]);