johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
281 rows where confirmed = 2667 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756425 | 2756425 | 2022-12-29 | US | West Virginia | Tyler | 54095 | 2667 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-12-30 04:21:04 | Tyler, West Virginia, US | |
219387 | 219387 | 2022-12-26 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-27 04:21:07 | Gallatin, Kentucky, US | |
219377 | 219377 | 2022-12-26 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-27 04:21:07 | Cumberland, Kentucky, US | |
3223844 | 3223844 | 2022-12-25 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-26 04:21:06 | Gallatin, Kentucky, US | |
3223834 | 3223834 | 2022-12-25 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-26 04:21:06 | Cumberland, Kentucky, US | |
1019758 | 1019758 | 2022-12-24 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-25 04:21:04 | Gallatin, Kentucky, US | |
1019748 | 1019748 | 2022-12-24 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-25 04:21:04 | Cumberland, Kentucky, US | |
691781 | 691781 | 2022-12-23 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-24 04:21:02 | Gallatin, Kentucky, US | |
691771 | 691771 | 2022-12-23 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-24 04:21:02 | Cumberland, Kentucky, US | |
2180991 | 2180991 | 2022-12-22 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-23 04:21:04 | Gallatin, Kentucky, US | |
2180981 | 2180981 | 2022-12-22 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-23 04:21:04 | Cumberland, Kentucky, US | |
454869 | 454869 | 2022-12-21 | US | West Virginia | Clay | 54015 | 2667 | 53 | 0 | 38.46231092 | -81.07652217 | 2022-12-22 04:20:56 | Clay, West Virginia, US | |
452795 | 452795 | 2022-12-21 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-22 04:20:56 | Gallatin, Kentucky, US | |
452785 | 452785 | 2022-12-21 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-22 04:20:56 | Cumberland, Kentucky, US | |
2954868 | 2954868 | 2022-12-20 | US | West Virginia | Clay | 54015 | 2667 | 53 | 0 | 38.46231092 | -81.07652217 | 2022-12-21 04:21:03 | Clay, West Virginia, US | |
2952794 | 2952794 | 2022-12-20 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-21 04:21:03 | Gallatin, Kentucky, US | |
2952784 | 2952784 | 2022-12-20 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-21 04:21:03 | Cumberland, Kentucky, US | |
3177270 | 3177270 | 2022-12-19 | US | West Virginia | Clay | 54015 | 2667 | 53 | 0 | 38.46231092 | -81.07652217 | 2022-12-20 04:21:04 | Clay, West Virginia, US | |
3175196 | 3175196 | 2022-12-19 | US | Kentucky | Gallatin | 21077 | 2667 | 57 | 0 | 38.75398691 | -84.8558382 | 2022-12-20 04:21:04 | Gallatin, Kentucky, US | |
3175186 | 3175186 | 2022-12-19 | US | Kentucky | Cumberland | 21057 | 2667 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-12-20 04:21:04 | Cumberland, Kentucky, US | |
2488988 | 2488988 | 2022-11-16 | US | Tennessee | Perry | 47135 | 2667 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-17 04:21:11 | Perry, Tennessee, US | |
294999 | 294999 | 2022-11-15 | US | Tennessee | Perry | 47135 | 2667 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-16 04:21:09 | Perry, Tennessee, US | |
293213 | 293213 | 2022-11-15 | US | Iowa | Guthrie | 19077 | 2667 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-11-16 04:21:09 | Guthrie, Iowa, US | |
3600029 | 3600029 | 2022-11-14 | US | Tennessee | Perry | 47135 | 2667 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-15 04:21:16 | Perry, Tennessee, US | |
3598243 | 3598243 | 2022-11-14 | US | Iowa | Guthrie | 19077 | 2667 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-11-15 04:21:16 | Guthrie, Iowa, US | |
314887 | 314887 | 2022-11-13 | US | Tennessee | Perry | 47135 | 2667 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-14 04:21:09 | Perry, Tennessee, US | |
313101 | 313101 | 2022-11-13 | US | Iowa | Guthrie | 19077 | 2667 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-11-14 04:21:09 | Guthrie, Iowa, US | |
66048 | 66048 | 2022-11-12 | US | Tennessee | Perry | 47135 | 2667 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-13 04:21:14 | Perry, Tennessee, US | |
64262 | 64262 | 2022-11-12 | US | Iowa | Guthrie | 19077 | 2667 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-11-13 04:21:14 | Guthrie, Iowa, US | |
2930210 | 2930210 | 2022-11-11 | US | Tennessee | Perry | 47135 | 2667 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-12 04:20:41 | Perry, Tennessee, US | |
2928424 | 2928424 | 2022-11-11 | US | Iowa | Guthrie | 19077 | 2667 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-11-12 04:20:41 | Guthrie, Iowa, US | |
2509046 | 2509046 | 2022-11-10 | US | Tennessee | Perry | 47135 | 2667 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-11 04:21:22 | Perry, Tennessee, US | |
2507260 | 2507260 | 2022-11-10 | US | Iowa | Guthrie | 19077 | 2667 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-11-11 04:21:22 | Guthrie, Iowa, US | |
2432135 | 2432135 | 2022-11-09 | US | Iowa | Guthrie | 19077 | 2667 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-11-10 04:21:16 | Guthrie, Iowa, US | |
1892563 | 1892563 | 2022-09-14 | US | Virginia | Sussex | 51183 | 2667 | 43 | 0 | 36.92432914 | -77.25791182 | 2022-09-15 04:21:02 | Sussex, Virginia, US | |
375618 | 375618 | 2022-09-13 | US | Virginia | Sussex | 51183 | 2667 | 43 | 0 | 36.92432914 | -77.25791182 | 2022-09-14 04:20:44 | Sussex, Virginia, US | |
374522 | 374522 | 2022-09-13 | US | North Carolina | Graham | 37075 | 2667 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-09-14 04:20:44 | Graham, North Carolina, US | |
373424 | 373424 | 2022-09-13 | US | Iowa | Mitchell | 19131 | 2667 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-14 04:20:44 | Mitchell, Iowa, US | |
2397124 | 2397124 | 2022-09-12 | US | North Carolina | Graham | 37075 | 2667 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-09-13 04:20:57 | Graham, North Carolina, US | |
2396026 | 2396026 | 2022-09-12 | US | Iowa | Mitchell | 19131 | 2667 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-13 04:20:57 | Mitchell, Iowa, US | |
3768202 | 3768202 | 2022-09-11 | US | North Carolina | Graham | 37075 | 2667 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-09-12 04:20:58 | Graham, North Carolina, US | |
3767104 | 3767104 | 2022-09-11 | US | Iowa | Mitchell | 19131 | 2667 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-12 04:20:58 | Mitchell, Iowa, US | |
3826777 | 3826777 | 2022-09-10 | US | North Carolina | Graham | 37075 | 2667 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-09-11 04:20:50 | Graham, North Carolina, US | |
3825679 | 3825679 | 2022-09-10 | US | Iowa | Mitchell | 19131 | 2667 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-11 04:20:50 | Mitchell, Iowa, US | |
965234 | 965234 | 2022-09-09 | US | North Carolina | Graham | 37075 | 2667 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-09-10 04:21:10 | Graham, North Carolina, US | |
964136 | 964136 | 2022-09-09 | US | Iowa | Mitchell | 19131 | 2667 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-10 04:21:10 | Mitchell, Iowa, US | |
255636 | 255636 | 2022-09-08 | US | North Carolina | Graham | 37075 | 2667 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-09-09 04:21:11 | Graham, North Carolina, US | |
254538 | 254538 | 2022-09-08 | US | Iowa | Mitchell | 19131 | 2667 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-09 04:21:11 | Mitchell, Iowa, US | |
3747434 | 3747434 | 2022-09-07 | US | North Carolina | Graham | 37075 | 2667 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-09-08 04:21:02 | Graham, North Carolina, US | |
3746336 | 3746336 | 2022-09-07 | US | Iowa | Mitchell | 19131 | 2667 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-08 04:21:02 | Mitchell, Iowa, US | |
2405566 | 2405566 | 2022-08-21 | US | Puerto Rico | Ceiba | 72037 | 2667 | 0 | 0 | 18.251818 | -65.666416 | 2022-08-22 04:20:38 | Ceiba, Puerto Rico, US | |
1164561 | 1164561 | 2022-08-18 | US | Virginia | Poquoson | 51735 | 2667 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-08-19 04:20:54 | Poquoson, Virginia, US | |
3911422 | 3911422 | 2022-08-11 | US | Virginia | Sussex | 51183 | 2667 | 44 | 0 | 36.92432914 | -77.25791182 | 2022-08-12 04:20:54 | Sussex, Virginia, US | |
1407786 | 1407786 | 2022-08-02 | US | Puerto Rico | Guanica | 72055 | 2667 | 0 | 0 | 17.982429 | -66.919643 | 2022-08-03 04:20:59 | Guanica, Puerto Rico, US | |
3619824 | 3619824 | 2022-08-01 | US | Puerto Rico | Guanica | 72055 | 2667 | 0 | 0 | 17.982429 | -66.919643 | 2022-08-02 04:20:53 | Guanica, Puerto Rico, US | |
1069061 | 1069061 | 2022-07-28 | US | Texas | Morris | 48343 | 2667 | 74 | 0 | 33.11304005 | -94.73255695 | 2022-07-29 04:20:45 | Morris, Texas, US | |
1213057 | 1213057 | 2022-07-11 | US | Louisiana | East Carroll | 22035 | 2667 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-07-12 04:20:51 | East Carroll, Louisiana, US | |
2789639 | 2789639 | 2022-07-10 | US | Colorado | Bent | 8011 | 2667 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-11 04:20:46 | Bent, Colorado, US | |
142660 | 142660 | 2022-07-09 | US | Connecticut | Unassigned | 90009 | 2667 | 3 | 0 | 41.85853803 | 0.0 | 2022-07-10 04:20:54 | Unassigned, Connecticut, US | |
142592 | 142592 | 2022-07-09 | US | Colorado | Bent | 8011 | 2667 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-10 04:20:54 | Bent, Colorado, US | |
1417692 | 1417692 | 2022-07-08 | US | Colorado | Bent | 8011 | 2667 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-09 04:20:59 | Bent, Colorado, US | |
2741617 | 2741617 | 2022-07-07 | US | Colorado | Bent | 8011 | 2667 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-07-08 04:20:56 | Bent, Colorado, US | |
1648784 | 1648784 | 2022-06-23 | US | Alabama | Sumter | 1119 | 2667 | 52 | 0 | 32.59117397 | -88.19916205 | 2022-06-24 04:20:58 | Sumter, Alabama, US | |
169389 | 169389 | 2022-06-21 | US | Virginia | Galax | 51640 | 2667 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-06-22 04:20:54 | Galax, Virginia, US | |
3270586 | 3270586 | 2022-06-19 | US | Indiana | Brown | 18013 | 2667 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-06-20 04:21:01 | Brown, Indiana, US | |
3398498 | 3398498 | 2022-06-18 | US | Indiana | Brown | 18013 | 2667 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-06-19 04:20:51 | Brown, Indiana, US | |
2312375 | 2312375 | 2022-06-17 | US | Indiana | Brown | 18013 | 2667 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-06-18 04:21:10 | Brown, Indiana, US | |
559928 | 559928 | 2022-06-16 | US | Indiana | Newton | 18111 | 2667 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-06-17 04:20:56 | Newton, Indiana, US | |
3983730 | 3983730 | 2022-06-15 | US | Indiana | Newton | 18111 | 2667 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-06-16 04:20:55 | Newton, Indiana, US | |
3538783 | 3538783 | 2022-05-10 | US | Virginia | Clarke | 51043 | 2667 | 42 | 0 | 39.11271747 | -77.99199425 | 2022-05-11 04:20:48 | Clarke, Virginia, US | |
3416726 | 3416726 | 2022-04-17 | China | Shandong | 2667 | 7 | 0 | 36.3427 | 118.1498 | 2022-04-18 04:21:12 | Shandong, China | |||
2481518 | 2481518 | 2022-03-30 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-31 04:20:56 | Forest, Wisconsin, US | |
161559 | 161559 | 2022-03-29 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-30 04:20:45 | Forest, Wisconsin, US | |
1440130 | 1440130 | 2022-03-28 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-29 04:20:46 | Forest, Wisconsin, US | |
879811 | 879811 | 2022-03-27 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-28 04:20:33 | Forest, Wisconsin, US | |
2167094 | 2167094 | 2022-03-26 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-27 04:20:47 | Forest, Wisconsin, US | |
1724030 | 1724030 | 2022-03-25 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-26 04:20:23 | Forest, Wisconsin, US | |
1471647 | 1471647 | 2022-03-24 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-25 04:20:46 | Forest, Wisconsin, US | |
1470317 | 1470317 | 2022-03-24 | US | New Mexico | Torrance | 35057 | 2667 | 52 | 0 | 34.64048375 | -105.8508949 | 2022-03-25 04:20:46 | Torrance, New Mexico, US | |
3025821 | 3025821 | 2022-03-23 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-24 04:20:43 | Forest, Wisconsin, US | |
1908743 | 1908743 | 2022-03-22 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-23 04:20:48 | Forest, Wisconsin, US | |
3241874 | 3241874 | 2022-03-21 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-22 04:20:54 | Forest, Wisconsin, US | |
27947 | 27947 | 2022-03-20 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-21 04:20:50 | Forest, Wisconsin, US | |
1659957 | 1659957 | 2022-03-19 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-20 04:20:45 | Forest, Wisconsin, US | |
339483 | 339483 | 2022-03-18 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-19 04:20:47 | Forest, Wisconsin, US | |
697936 | 697936 | 2022-03-17 | US | Wisconsin | Forest | 55041 | 2667 | 51 | 0 | 45.66678019 | -88.77084892 | 2022-03-18 04:20:55 | Forest, Wisconsin, US | |
694876 | 694876 | 2022-03-17 | US | Arkansas | Fulton | 5049 | 2667 | 87 | 0 | 36.38177105 | -91.81729127 | 2022-03-18 04:20:55 | Fulton, Arkansas, US | |
2322879 | 2322879 | 2022-03-16 | US | Wisconsin | Forest | 55041 | 2667 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-17 04:20:56 | Forest, Wisconsin, US | |
265079 | 265079 | 2022-03-15 | US | Wisconsin | Forest | 55041 | 2667 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-16 04:20:50 | Forest, Wisconsin, US | |
262709 | 262709 | 2022-03-15 | US | Iowa | Chickasaw | 19037 | 2667 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-16 04:20:50 | Chickasaw, Iowa, US | |
2265068 | 2265068 | 2022-03-14 | US | Iowa | Chickasaw | 19037 | 2667 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-15 04:20:47 | Chickasaw, Iowa, US | |
3629134 | 3629134 | 2022-03-13 | US | Iowa | Chickasaw | 19037 | 2667 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-14 04:20:46 | Chickasaw, Iowa, US | |
952042 | 952042 | 2022-03-12 | US | Iowa | Chickasaw | 19037 | 2667 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-13 04:20:49 | Chickasaw, Iowa, US | |
357503 | 357503 | 2022-03-11 | US | Iowa | Chickasaw | 19037 | 2667 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-12 04:20:50 | Chickasaw, Iowa, US | |
1866655 | 1866655 | 2022-03-10 | US | Iowa | Chickasaw | 19037 | 2667 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-11 04:20:50 | Chickasaw, Iowa, US | |
2141350 | 2141350 | 2022-03-09 | US | Iowa | Chickasaw | 19037 | 2667 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-10 04:20:48 | Chickasaw, Iowa, US | |
922640 | 922640 | 2022-03-08 | US | Tennessee | Houston | 47083 | 2667 | 59 | 0 | 36.28872054 | -87.71878828 | 2022-03-09 04:20:59 | Houston, Tennessee, US | |
2526366 | 2526366 | 2022-03-02 | US | Illinois | Jasper | 17079 | 2667 | 26 | 0 | 39.01054275 | -88.15437049 | 2022-03-03 04:21:01 | Jasper, Illinois, US | |
1993660 | 1993660 | 2022-03-01 | US | Illinois | Jasper | 17079 | 2667 | 26 | 0 | 39.01054275 | -88.15437049 | 2022-03-02 04:21:07 | Jasper, Illinois, US | |
1992453 | 1992453 | 2022-03-01 | China | Henan | 2667 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-02 04:21:07 | Henan, China |
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]);