johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
191 rows where confirmed = 3860 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3461144 | 3461144 | 2022-11-21 | US | Illinois | Cumberland | 17035 | 3860 | 39 | 0 | 39.27432424 | -88.2401158 | 2022-11-22 04:20:47 | Cumberland, Illinois, US | |
133189 | 133189 | 2022-10-04 | US | North Dakota | Walsh | 38099 | 3860 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-10-05 04:23:06 | Walsh, North Dakota, US | |
132253 | 132253 | 2022-10-04 | US | Louisiana | Claiborne | 22027 | 3860 | 80 | 0 | 32.82308512 | -92.99526883 | 2022-10-05 04:23:06 | Claiborne, Louisiana, US | |
2017234 | 2017234 | 2022-09-20 | US | Arkansas | Marion | 5089 | 3860 | 91 | 0 | 36.26844485 | -92.68451899 | 2022-09-21 04:23:22 | Marion, Arkansas, US | |
3766504 | 3766504 | 2022-09-11 | US | Colorado | Grand | 8049 | 3860 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-09-12 04:20:58 | Grand, Colorado, US | |
3825079 | 3825079 | 2022-09-10 | US | Colorado | Grand | 8049 | 3860 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-09-11 04:20:50 | Grand, Colorado, US | |
963536 | 963536 | 2022-09-09 | US | Colorado | Grand | 8049 | 3860 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-09-10 04:21:10 | Grand, Colorado, US | |
3776965 | 3776965 | 2022-08-30 | US | Texas | Comanche | 48093 | 3860 | 78 | 0 | 31.94854689 | -98.55876441 | 2022-08-31 04:20:57 | Comanche, Texas, US | |
3909130 | 3909130 | 2022-08-11 | US | Indiana | Parke | 18121 | 3860 | 51 | 0 | 39.77202286 | -87.20375833 | 2022-08-12 04:20:54 | Parke, Indiana, US | |
1347447 | 1347447 | 2022-08-10 | US | Indiana | Parke | 18121 | 3860 | 51 | 0 | 39.77202286 | -87.20375833 | 2022-08-11 04:20:49 | Parke, Indiana, US | |
2336389 | 2336389 | 2022-07-27 | US | Illinois | Greene | 17061 | 3860 | 46 | 0 | 39.35907414 | -90.388865 | 2022-07-28 04:20:56 | Greene, Illinois, US | |
897971 | 897971 | 2022-07-24 | US | Mississippi | Lawrence | 28077 | 3860 | 57 | 0 | 31.55147224 | -90.10841127 | 2022-07-25 04:20:51 | Lawrence, Mississippi, US | |
92965 | 92965 | 2022-07-23 | US | Mississippi | Lawrence | 28077 | 3860 | 57 | 0 | 31.55147224 | -90.10841127 | 2022-07-24 04:20:47 | Lawrence, Mississippi, US | |
901987 | 901987 | 2022-07-22 | US | Mississippi | Lawrence | 28077 | 3860 | 57 | 0 | 31.55147224 | -90.10841127 | 2022-07-23 04:20:53 | Lawrence, Mississippi, US | |
672123 | 672123 | 2022-07-21 | US | Mississippi | Lawrence | 28077 | 3860 | 57 | 0 | 31.55147224 | -90.10841127 | 2022-07-22 04:21:15 | Lawrence, Mississippi, US | |
1610086 | 1610086 | 2022-07-20 | US | Mississippi | Lawrence | 28077 | 3860 | 57 | 0 | 31.55147224 | -90.10841127 | 2022-07-21 04:21:10 | Lawrence, Mississippi, US | |
960719 | 960719 | 2022-07-19 | US | Mississippi | Lawrence | 28077 | 3860 | 57 | 0 | 31.55147224 | -90.10841127 | 2022-07-20 04:20:59 | Lawrence, Mississippi, US | |
3985665 | 3985665 | 2022-06-15 | US | Texas | Colorado | 48089 | 3860 | 66 | 0 | 29.622098 | -96.5273805 | 2022-06-16 04:20:55 | Colorado, Texas, US | |
3983095 | 3983095 | 2022-06-15 | US | Arkansas | Franklin | 5047 | 3860 | 73 | 0 | 35.51202821 | -93.89299569 | 2022-06-16 04:20:55 | Franklin, Arkansas, US | |
1424466 | 1424466 | 2022-06-08 | US | Virginia | King William | 51101 | 3860 | 44 | 0 | 37.70965316 | -77.09384941 | 2022-06-09 04:20:54 | King William, Virginia, US | |
3507754 | 3507754 | 2022-06-05 | US | Alabama | Crenshaw | 1041 | 3860 | 100 | 0 | 31.72941803 | -86.31593104 | 2022-06-06 04:20:57 | Crenshaw, Alabama, US | |
3527831 | 3527831 | 2022-06-04 | US | Alabama | Crenshaw | 1041 | 3860 | 100 | 0 | 31.72941803 | -86.31593104 | 2022-06-05 04:20:55 | Crenshaw, Alabama, US | |
3133917 | 3133917 | 2022-06-03 | US | Alabama | Crenshaw | 1041 | 3860 | 100 | 0 | 31.72941803 | -86.31593104 | 2022-06-04 04:20:58 | Crenshaw, Alabama, US | |
3578992 | 3578992 | 2022-06-02 | US | Alabama | Crenshaw | 1041 | 3860 | 100 | 0 | 31.72941803 | -86.31593104 | 2022-06-03 04:20:58 | Crenshaw, Alabama, US | |
3898177 | 3898177 | 2022-05-19 | US | New Mexico | Socorro | 35053 | 3860 | 89 | 0 | 34.00715494 | -106.9298354 | 2022-05-20 04:20:57 | Socorro, New Mexico, US | |
1186464 | 1186464 | 2022-05-18 | US | Minnesota | Faribault | 27043 | 3860 | 52 | 0 | 43.67381499 | -93.94787458 | 2022-05-19 04:20:54 | Faribault, Minnesota, US | |
1573391 | 1573391 | 2022-05-03 | US | Iowa | Winneshiek | 19191 | 3860 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-05-04 04:20:59 | Winneshiek, Iowa, US | |
464651 | 464651 | 2022-05-02 | US | Iowa | Winneshiek | 19191 | 3860 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-05-03 04:21:00 | Winneshiek, Iowa, US | |
3917290 | 3917290 | 2022-05-01 | US | Iowa | Winneshiek | 19191 | 3860 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-05-02 04:21:10 | Winneshiek, Iowa, US | |
2842094 | 2842094 | 2022-04-30 | US | Iowa | Winneshiek | 19191 | 3860 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-05-01 04:20:57 | Winneshiek, Iowa, US | |
1158407 | 1158407 | 2022-04-29 | US | Iowa | Winneshiek | 19191 | 3860 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-04-30 04:21:05 | Winneshiek, Iowa, US | |
1697589 | 1697589 | 2022-04-28 | US | Iowa | Winneshiek | 19191 | 3860 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-04-29 04:20:59 | Winneshiek, Iowa, US | |
3853072 | 3853072 | 2022-04-27 | US | Iowa | Winneshiek | 19191 | 3860 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-04-28 04:20:47 | Winneshiek, Iowa, US | |
1949757 | 1949757 | 2022-04-12 | US | Iowa | Tama | 19171 | 3860 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-13 04:21:03 | Tama, Iowa, US | |
3207510 | 3207510 | 2022-04-11 | US | Iowa | Tama | 19171 | 3860 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-12 04:20:49 | Tama, Iowa, US | |
1577396 | 1577396 | 2022-04-10 | US | Iowa | Tama | 19171 | 3860 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-11 04:21:02 | Tama, Iowa, US | |
1653638 | 1653638 | 2022-04-09 | US | Iowa | Tama | 19171 | 3860 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-10 04:20:52 | Tama, Iowa, US | |
2116960 | 2116960 | 2022-04-08 | US | Iowa | Tama | 19171 | 3860 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-09 04:20:42 | Tama, Iowa, US | |
3321484 | 3321484 | 2022-04-07 | US | Iowa | Tama | 19171 | 3860 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-08 04:20:48 | Tama, Iowa, US | |
2802020 | 2802020 | 2022-04-06 | US | Iowa | Tama | 19171 | 3860 | 90 | 0 | 42.07991767 | -92.53266945 | 2022-04-07 04:20:53 | Tama, Iowa, US | |
3733546 | 3733546 | 2022-04-03 | US | Virginia | Buckingham | 51029 | 3860 | 56 | 0 | 37.57242268 | -78.52518834 | 2022-04-04 04:20:51 | Buckingham, Virginia, US | |
502981 | 502981 | 2022-04-02 | US | Virginia | Buckingham | 51029 | 3860 | 56 | 0 | 37.57242268 | -78.52518834 | 2022-04-03 04:20:48 | Buckingham, Virginia, US | |
3353966 | 3353966 | 2022-04-01 | US | Virginia | Buckingham | 51029 | 3860 | 56 | 0 | 37.57242268 | -78.52518834 | 2022-04-02 04:20:47 | Buckingham, Virginia, US | |
877286 | 877286 | 2022-03-27 | US | Illinois | Massac | 17127 | 3860 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-28 04:20:33 | Massac, Illinois, US | |
2164569 | 2164569 | 2022-03-26 | US | Illinois | Massac | 17127 | 3860 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-27 04:20:47 | Massac, Illinois, US | |
1721505 | 1721505 | 2022-03-25 | US | Illinois | Massac | 17127 | 3860 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-26 04:20:23 | Massac, Illinois, US | |
1469122 | 1469122 | 2022-03-24 | US | Illinois | Massac | 17127 | 3860 | 66 | 0 | 37.22078441 | -88.71036614 | 2022-03-25 04:20:46 | Massac, Illinois, US | |
2267052 | 2267052 | 2022-03-14 | US | Texas | Llano | 48299 | 3860 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-15 04:20:47 | Llano, Texas, US | |
3631118 | 3631118 | 2022-03-13 | US | Texas | Llano | 48299 | 3860 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-14 04:20:46 | Llano, Texas, US | |
954026 | 954026 | 2022-03-12 | US | Texas | Llano | 48299 | 3860 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-13 04:20:49 | Llano, Texas, US | |
359487 | 359487 | 2022-03-11 | US | Texas | Llano | 48299 | 3860 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-03-12 04:20:50 | Llano, Texas, US | |
920179 | 920179 | 2022-03-08 | US | Arkansas | Izard | 5065 | 3860 | 65 | 0 | 36.09604046 | -91.90847954 | 2022-03-09 04:20:59 | Izard, Arkansas, US | |
1548466 | 1548466 | 2022-03-07 | US | Arkansas | Izard | 5065 | 3860 | 65 | 0 | 36.09604046 | -91.90847954 | 2022-03-08 04:20:54 | Izard, Arkansas, US | |
2200135 | 2200135 | 2022-03-06 | US | Arkansas | Izard | 5065 | 3860 | 65 | 0 | 36.09604046 | -91.90847954 | 2022-03-07 04:20:47 | Izard, Arkansas, US | |
2092592 | 2092592 | 2022-03-05 | US | Arkansas | Izard | 5065 | 3860 | 65 | 0 | 36.09604046 | -91.90847954 | 2022-03-06 04:20:49 | Izard, Arkansas, US | |
3823824 | 3823824 | 2022-02-16 | US | Virginia | Nottoway | 51135 | 3860 | 79 | 0 | 37.1435975 | -78.05065922 | 2022-02-17 04:20:56 | Nottoway, Virginia, US | |
2660525 | 2660525 | 2022-01-31 | US | Puerto Rico | Coamo | 72043 | 3860 | 0 | 0 | 18.097597 | -66.36014 | 2022-02-01 04:21:11 | Coamo, Puerto Rico, US | |
3302881 | 3302881 | 2022-01-30 | US | Pennsylvania | Fulton | 42057 | 3860 | 58 | 0 | 39.92913544 | -78.11163677 | 2022-01-31 04:21:09 | Fulton, Pennsylvania, US | |
555273 | 555273 | 2022-01-16 | US | Arkansas | Drew | 5043 | 3860 | 58 | 0 | 33.59035001 | -91.71777921 | 2022-01-17 04:21:08 | Drew, Arkansas, US | |
3844007 | 3844007 | 2022-01-15 | US | West Virginia | McDowell | 54047 | 3860 | 56 | 0 | 37.38002939 | -81.65083669 | 2022-01-16 04:21:12 | McDowell, West Virginia, US | |
3614956 | 3614956 | 2022-01-12 | US | Missouri | Clinton | 29049 | 3860 | 101 | 0 | 39.6013098 | -94.40465394 | 2022-01-13 08:00:09 | Clinton, Missouri, US | |
2167909 | 2167909 | 2022-01-01 | US | Alabama | Barbour | 1005 | 3860 | 81 | 0 | 31.868263 | -85.3871286 | 2022-01-02 04:20:52 | Barbour, Alabama, US | |
2779919 | 2779919 | 2021-12-31 | US | Tennessee | Chester | 47023 | 3860 | 81 | 0 | 35.42527478 | -88.6095842 | 2022-01-01 04:22:14 | Chester, Tennessee, US | |
2777340 | 2777340 | 2021-12-31 | US | Alabama | Barbour | 1005 | 3860 | 81 | 0 | 31.868263 | -85.3871286 | 2022-01-01 04:22:14 | Barbour, Alabama, US | |
1256578 | 1256578 | 2021-12-20 | US | Mississippi | Grenada | 28043 | 3860 | 111 | 0 | 33.77036166 | -89.80245083 | 2021-12-21 03:21:27 | Grenada, Mississippi, US | |
2400230 | 2400230 | 2021-12-17 | US | Kentucky | Harrison | 21097 | 3860 | 55 | 0 | 38.44188174 | -84.32869741 | 2021-12-18 02:22:20 | Harrison, Kentucky, US | |
2089841 | 2089841 | 2021-12-14 | US | Missouri | Adair | 29001 | 3860 | 44 | 0 | 40.19058551 | -92.60078167 | 2021-12-15 03:22:16 | Adair, Missouri, US | |
784258 | 784258 | 2021-12-13 | US | Missouri | Adair | 29001 | 3860 | 44 | 0 | 40.19058551 | -92.60078167 | 2021-12-14 04:22:38 | Adair, Missouri, US | |
553302 | 553302 | 2021-12-08 | US | Ohio | Wyandot | 39175 | 3860 | 81 | 0 | 40.84339621 | -83.30734173 | 2021-12-09 04:22:49 | Wyandot, Ohio, US | |
551861 | 551861 | 2021-12-08 | US | Indiana | Fountain | 18045 | 3860 | 66 | 0 | 40.12361933 | -87.24217689 | 2021-12-09 04:22:49 | Fountain, Indiana, US | |
551653 | 551653 | 2021-12-08 | US | Georgia | Tattnall | 13267 | 3860 | 115 | 0 | 32.04785085 | -82.05539188 | 2021-12-09 04:22:49 | Tattnall, Georgia, US | |
1033314 | 1033314 | 2021-12-06 | US | Tennessee | Fentress | 47049 | 3860 | 72 | 0 | 36.38128818 | -84.92870012 | 2021-12-07 04:22:34 | Fentress, Tennessee, US | |
2198720 | 2198720 | 2021-12-03 | US | Texas | Gillespie | 48171 | 3860 | 82 | 0 | 30.31824095 | -98.94676915 | 2021-12-04 04:22:18 | Gillespie, Texas, US | |
1233262 | 1233262 | 2021-11-28 | US | Michigan | Emmet | 26047 | 3860 | 55 | 0 | 45.52625509 | -84.89083249 | 2021-11-29 04:22:30 | Emmet, Michigan, US | |
1359969 | 1359969 | 2021-11-27 | US | Michigan | Emmet | 26047 | 3860 | 55 | 0 | 45.52625509 | -84.89083249 | 2021-11-28 04:22:43 | Emmet, Michigan, US | |
759960 | 759960 | 2021-11-26 | US | Michigan | Emmet | 26047 | 3860 | 55 | 0 | 45.52625509 | -84.89083249 | 2021-11-27 04:22:45 | Emmet, Michigan, US | |
1804377 | 1804377 | 2021-11-25 | US | Michigan | Emmet | 26047 | 3860 | 55 | 0 | 45.52625509 | -84.89083249 | 2021-11-26 04:22:33 | Emmet, Michigan, US | |
905811 | 905811 | 2021-11-24 | US | Michigan | Emmet | 26047 | 3860 | 55 | 0 | 45.52625509 | -84.89083249 | 2021-11-25 04:22:33 | Emmet, Michigan, US | |
448878 | 448878 | 2021-11-17 | US | Louisiana | Grant | 22043 | 3860 | 78 | 0 | 31.59882456 | -92.56124347 | 2021-11-18 04:21:33 | Grant, Louisiana, US | |
687824 | 687824 | 2021-11-13 | US | Kentucky | Rowan | 21205 | 3860 | 33 | 0 | 38.19484205 | -83.42088935 | 2021-11-14 04:21:31 | Rowan, Kentucky, US | |
89357 | 89357 | 2021-11-09 | US | New York | Delaware | 36025 | 3860 | 49 | 0 | 42.19837623 | -74.96709306 | 2021-11-10 04:21:38 | Delaware, New York, US | |
291340 | 291340 | 2021-10-31 | US | Virginia | Gloucester | 51073 | 3860 | 75 | 0 | 37.40809042 | -76.53524337 | 2021-11-01 04:22:01 | Gloucester, Virginia, US | |
2724346 | 2724346 | 2021-10-30 | US | Virginia | Gloucester | 51073 | 3860 | 75 | 0 | 37.40809042 | -76.53524337 | 2021-10-31 04:22:08 | Gloucester, Virginia, US | |
570448 | 570448 | 2021-10-29 | US | Virginia | Gloucester | 51073 | 3860 | 75 | 0 | 37.40809042 | -76.53524337 | 2021-10-30 04:22:03 | Gloucester, Virginia, US | |
3796506 | 3796506 | 2021-10-25 | US | Oregon | Columbia | 41009 | 3860 | 44 | 0 | 45.94464254 | -123.08908980000001 | 2021-10-26 04:22:09 | Columbia, Oregon, US | |
3795325 | 3795325 | 2021-10-25 | US | Kentucky | Letcher | 21133 | 3860 | 65 | 0 | 37.12306748 | -82.85346474 | 2021-10-26 04:22:09 | Letcher, Kentucky, US | |
683927 | 683927 | 2021-10-24 | US | Maryland | Queen Anne's | 24035 | 3860 | 71 | 0 | 39.06198912 | -76.03530977 | 2021-10-25 04:22:31 | Queen Anne's, Maryland, US | |
771935 | 771935 | 2021-10-23 | US | Maryland | Queen Anne's | 24035 | 3860 | 70 | 0 | 39.06198912 | -76.03530977 | 2021-10-24 04:21:22 | Queen Anne's, Maryland, US | |
937584 | 937584 | 2021-10-16 | US | Puerto Rico | Trujillo Alto | 72139 | 3860 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-10-17 04:21:29 | Trujillo Alto, Puerto Rico, US | |
494709 | 494709 | 2021-10-14 | US | Texas | Dimmit | 48127 | 3860 | 45 | 0 | 28.42270064 | -99.75645095 | 2021-10-15 04:21:26 | Dimmit, Texas, US | |
3008139 | 3008139 | 2021-10-11 | US | Georgia | Franklin | 13119 | 3860 | 76 | 0 | 34.37525597 | -83.23159927 | 2021-10-12 04:21:09 | Franklin, Georgia, US | |
424155 | 424155 | 2021-10-10 | US | Georgia | Franklin | 13119 | 3860 | 76 | 0 | 34.37525597 | -83.23159927 | 2021-10-11 04:21:31 | Franklin, Georgia, US | |
2877012 | 2877012 | 2021-10-09 | US | Georgia | Franklin | 13119 | 3860 | 76 | 0 | 34.37525597 | -83.23159927 | 2021-10-10 04:21:38 | Franklin, Georgia, US | |
2960178 | 2960178 | 2021-10-08 | US | Georgia | Franklin | 13119 | 3860 | 76 | 0 | 34.37525597 | -83.23159927 | 2021-10-09 04:21:34 | Franklin, Georgia, US | |
1377381 | 1377381 | 2021-09-15 | US | South Dakota | Meade | 46093 | 3860 | 36 | 0 | 44.56676791 | -102.71627409999999 | 2021-09-16 04:22:19 | Meade, South Dakota, US | |
1387450 | 1387450 | 2021-09-13 | US | Mississippi | Leake | 28079 | 3860 | 81 | 0 | 32.7536828 | -89.52402044 | 2021-09-14 04:21:41 | Leake, Mississippi, US | |
3281250 | 3281250 | 2021-09-05 | US | Alabama | Lawrence | 1079 | 3860 | 100 | 0 | 34.52041498 | -87.31069453 | 2021-09-06 04:21:22 | Lawrence, Alabama, US | |
3894155 | 3894155 | 2021-08-29 | US | New York | Chenango | 36017 | 3860 | 82 | 0 | 42.49430041 | -75.60887553 | 2021-08-30 04:21:23 | Chenango, New York, US | |
2176920 | 2176920 | 2021-08-22 | US | Kentucky | Bell | 21013 | 3860 | 58 | 0 | 36.73355174 | -83.67766671 | 2021-08-23 04:21:27 | Bell, Kentucky, US | |
3556037 | 3556037 | 2021-08-21 | US | Alabama | Marion | 1093 | 3860 | 108 | 0 | 34.13697363 | -87.88704173 | 2021-08-22 04:21:29 | Marion, Alabama, 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]);