johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
251 rows where confirmed = 3614 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331425 | 331425 | 2022-12-27 | US | West Virginia | Summers | 54089 | 3614 | 63 | 0 | 37.65390597 | -80.86009693 | 2022-12-28 04:21:04 | Summers, West Virginia, US | |
1985290 | 1985290 | 2022-12-07 | US | Colorado | Moffat | 8081 | 3614 | 55 | 0 | 40.61810999 | -108.2070876 | 2022-12-08 04:21:07 | Moffat, Colorado, US | |
3599167 | 3599167 | 2022-11-14 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-15 04:21:16 | Seward, Nebraska, US | |
314025 | 314025 | 2022-11-13 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-14 04:21:09 | Seward, Nebraska, US | |
65186 | 65186 | 2022-11-12 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-13 04:21:14 | Seward, Nebraska, US | |
2929348 | 2929348 | 2022-11-11 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-12 04:20:41 | Seward, Nebraska, US | |
2508184 | 2508184 | 2022-11-10 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-11 04:21:22 | Seward, Nebraska, US | |
2433059 | 2433059 | 2022-11-09 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-10 04:21:16 | Seward, Nebraska, US | |
481715 | 481715 | 2022-11-08 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-09 04:21:22 | Seward, Nebraska, US | |
2440865 | 2440865 | 2022-11-07 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-08 04:21:21 | Seward, Nebraska, US | |
1051963 | 1051963 | 2022-11-06 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-07 04:21:26 | Seward, Nebraska, US | |
619987 | 619987 | 2022-11-05 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-06 04:21:24 | Seward, Nebraska, US | |
1024491 | 1024491 | 2022-11-04 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-05 04:21:52 | Seward, Nebraska, US | |
433482 | 433482 | 2022-11-03 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-04 04:22:11 | Seward, Nebraska, US | |
851724 | 851724 | 2022-11-02 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-03 04:22:05 | Seward, Nebraska, US | |
712575 | 712575 | 2022-11-01 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-02 04:22:09 | Seward, Nebraska, US | |
3287024 | 3287024 | 2022-10-31 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-11-01 04:22:36 | Seward, Nebraska, US | |
322057 | 322057 | 2022-10-30 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-10-31 04:21:36 | Seward, Nebraska, US | |
914333 | 914333 | 2022-10-29 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-10-30 04:22:14 | Seward, Nebraska, US | |
1368602 | 1368602 | 2022-10-28 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-10-29 04:21:13 | Seward, Nebraska, US | |
3040457 | 3040457 | 2022-10-27 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-10-28 04:22:31 | Seward, Nebraska, US | |
540877 | 540877 | 2022-10-26 | US | Nebraska | Seward | 31159 | 3614 | 50 | 0 | 40.87241834 | -97.139673 | 2022-10-27 04:22:01 | Seward, Nebraska, US | |
2274923 | 2274923 | 2022-10-20 | US | Tennessee | Stewart | 47161 | 3614 | 64 | 0 | 36.50235092 | -87.83920548 | 2022-10-21 04:22:23 | Stewart, Tennessee, US | |
2758093 | 2758093 | 2022-10-18 | US | Iowa | Butler | 19023 | 3614 | 57 | 0 | 42.73172833 | -92.79015971 | 2022-10-19 04:22:26 | Butler, Iowa, US | |
2025927 | 2025927 | 2022-10-17 | US | Iowa | Butler | 19023 | 3614 | 57 | 0 | 42.73172833 | -92.79015971 | 2022-10-18 04:22:42 | Butler, Iowa, US | |
2160705 | 2160705 | 2022-10-16 | US | Iowa | Butler | 19023 | 3614 | 57 | 0 | 42.73172833 | -92.79015971 | 2022-10-17 04:20:31 | Butler, Iowa, US | |
516902 | 516902 | 2022-10-15 | US | Iowa | Butler | 19023 | 3614 | 57 | 0 | 42.73172833 | -92.79015971 | 2022-10-16 04:22:39 | Butler, Iowa, US | |
2033959 | 2033959 | 2022-10-14 | US | Iowa | Butler | 19023 | 3614 | 57 | 0 | 42.73172833 | -92.79015971 | 2022-10-15 04:22:00 | Butler, Iowa, US | |
3754647 | 3754647 | 2022-10-13 | US | Iowa | Butler | 19023 | 3614 | 57 | 0 | 42.73172833 | -92.79015971 | 2022-10-14 04:22:28 | Butler, Iowa, US | |
3215472 | 3215472 | 2022-10-12 | US | Iowa | Butler | 19023 | 3614 | 57 | 0 | 42.73172833 | -92.79015971 | 2022-10-13 04:22:39 | Butler, Iowa, US | |
2358429 | 2358429 | 2022-09-16 | US | Tennessee | Jackson | 47087 | 3614 | 65 | 0 | 36.36380466 | -85.67239905 | 2022-09-17 04:20:19 | Jackson, Tennessee, US | |
2323154 | 2323154 | 2022-08-24 | China | Shaanxi | 3614 | 3 | 0 | 35.1917 | 108.8701 | 2022-08-25 04:21:13 | Shaanxi, China | |||
2010192 | 2010192 | 2022-08-04 | US | Louisiana | Claiborne | 22027 | 3614 | 79 | 0 | 32.82308512 | -92.99526883 | 2022-08-05 04:20:52 | Claiborne, Louisiana, US | |
1407904 | 1407904 | 2022-08-02 | US | South Dakota | Clay | 46027 | 3614 | 22 | 0 | 42.91296147 | -96.97656917 | 2022-08-03 04:20:59 | Clay, South Dakota, US | |
3619942 | 3619942 | 2022-08-01 | US | South Dakota | Clay | 46027 | 3614 | 22 | 0 | 42.91296147 | -96.97656917 | 2022-08-02 04:20:53 | Clay, South Dakota, US | |
3874422 | 3874422 | 2022-07-31 | US | South Dakota | Clay | 46027 | 3614 | 22 | 0 | 42.91296147 | -96.97656917 | 2022-08-01 04:21:03 | Clay, South Dakota, US | |
677176 | 677176 | 2022-07-30 | US | South Dakota | Clay | 46027 | 3614 | 22 | 0 | 42.91296147 | -96.97656917 | 2022-07-31 04:21:02 | Clay, South Dakota, US | |
1786375 | 1786375 | 2022-07-29 | US | South Dakota | Clay | 46027 | 3614 | 22 | 0 | 42.91296147 | -96.97656917 | 2022-07-30 04:20:42 | Clay, South Dakota, US | |
1068738 | 1068738 | 2022-07-28 | US | South Dakota | Clay | 46027 | 3614 | 22 | 0 | 42.91296147 | -96.97656917 | 2022-07-29 04:20:45 | Clay, South Dakota, US | |
2338257 | 2338257 | 2022-07-27 | US | South Dakota | Clay | 46027 | 3614 | 22 | 0 | 42.91296147 | -96.97656917 | 2022-07-28 04:20:56 | Clay, South Dakota, US | |
1490023 | 1490023 | 2022-07-26 | US | North Dakota | Walsh | 38099 | 3614 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-07-27 04:21:04 | Walsh, North Dakota, US | |
1202304 | 1202304 | 2022-07-06 | US | Ohio | Monroe | 39111 | 3614 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-07-07 04:20:55 | Monroe, Ohio, US | |
3969047 | 3969047 | 2022-07-05 | US | Ohio | Monroe | 39111 | 3614 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-07-06 04:20:58 | Monroe, Ohio, US | |
3080558 | 3080558 | 2022-07-04 | US | Ohio | Monroe | 39111 | 3614 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-07-05 04:20:45 | Monroe, Ohio, US | |
1769840 | 1769840 | 2022-07-03 | US | Ohio | Monroe | 39111 | 3614 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-07-04 04:20:54 | Monroe, Ohio, US | |
3367826 | 3367826 | 2022-07-02 | US | Ohio | Monroe | 39111 | 3614 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-07-03 04:20:59 | Monroe, Ohio, US | |
596155 | 596155 | 2022-07-01 | US | Ohio | Monroe | 39111 | 3614 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-07-02 04:21:16 | Monroe, Ohio, US | |
3942811 | 3942811 | 2022-06-30 | US | Puerto Rico | Jayuya | 72073 | 3614 | 0 | 0 | 18.211446 | -66.58878 | 2022-07-01 04:21:10 | Jayuya, Puerto Rico, US | |
3942556 | 3942556 | 2022-06-30 | US | Ohio | Monroe | 39111 | 3614 | 81 | 0 | 39.72984936 | -81.08464734 | 2022-07-01 04:21:10 | Monroe, Ohio, US | |
3941205 | 3941205 | 2022-06-30 | US | Indiana | Tipton | 18159 | 3614 | 88 | 0 | 40.31123252 | -86.05234925 | 2022-07-01 04:21:10 | Tipton, Indiana, US | |
2491163 | 2491163 | 2022-06-29 | US | Indiana | Tipton | 18159 | 3614 | 88 | 0 | 40.31123252 | -86.05234925 | 2022-06-30 04:21:01 | Tipton, Indiana, US | |
2151016 | 2151016 | 2022-06-27 | US | Virginia | Martinsville | 51690 | 3614 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-06-28 04:20:58 | Martinsville, Virginia, US | |
2150363 | 2150363 | 2022-06-27 | US | Puerto Rico | Arroyo | 72015 | 3614 | 0 | 0 | 17.998457 | -66.056546 | 2022-06-28 04:20:58 | Arroyo, Puerto Rico, US | |
169491 | 169491 | 2022-06-21 | US | Washington | Jefferson | 53031 | 3614 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-06-22 04:20:54 | Jefferson, Washington, US | |
166616 | 166616 | 2022-06-21 | US | California | Plumas | 6063 | 3614 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-06-22 04:20:54 | Plumas, California, US | |
1766774 | 1766774 | 2022-06-20 | US | Washington | Jefferson | 53031 | 3614 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-06-21 04:20:56 | Jefferson, Washington, US | |
1763899 | 1763899 | 2022-06-20 | US | California | Plumas | 6063 | 3614 | 13 | 0 | 40.00355989 | -120.8395236 | 2022-06-21 04:20:56 | Plumas, California, US | |
3272960 | 3272960 | 2022-06-19 | US | Washington | Jefferson | 53031 | 3614 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-06-20 04:21:01 | Jefferson, Washington, US | |
3400872 | 3400872 | 2022-06-18 | US | Washington | Jefferson | 53031 | 3614 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-06-19 04:20:51 | Jefferson, Washington, US | |
2314749 | 2314749 | 2022-06-17 | US | Washington | Jefferson | 53031 | 3614 | 30 | 0 | 47.75003077 | -123.5609704 | 2022-06-18 04:21:10 | Jefferson, Washington, US | |
2238349 | 2238349 | 2022-06-12 | US | Tennessee | Lewis | 47101 | 3614 | 61 | 0 | 35.52853208 | -87.49022694 | 2022-06-13 04:21:14 | Lewis, Tennessee, US | |
3897088 | 3897088 | 2022-05-19 | US | Indiana | Parke | 18121 | 3614 | 49 | 0 | 39.77202286 | -87.20375833 | 2022-05-20 04:20:57 | Parke, Indiana, US | |
1185872 | 1185872 | 2022-05-18 | US | Indiana | Parke | 18121 | 3614 | 49 | 0 | 39.77202286 | -87.20375833 | 2022-05-19 04:20:54 | Parke, Indiana, US | |
3536718 | 3536718 | 2022-05-10 | US | Iowa | Wright | 19197 | 3614 | 63 | 0 | 42.73305373 | -93.73515113 | 2022-05-11 04:20:48 | Wright, Iowa, US | |
223253 | 223253 | 2022-05-09 | US | Iowa | Wright | 19197 | 3614 | 63 | 0 | 42.73305373 | -93.73515113 | 2022-05-10 04:20:50 | Wright, Iowa, US | |
2332638 | 2332638 | 2022-05-08 | US | Iowa | Wright | 19197 | 3614 | 63 | 0 | 42.73305373 | -93.73515113 | 2022-05-09 04:20:54 | Wright, Iowa, US | |
361600 | 361600 | 2022-05-07 | US | Iowa | Wright | 19197 | 3614 | 63 | 0 | 42.73305373 | -93.73515113 | 2022-05-08 04:20:49 | Wright, Iowa, US | |
1398951 | 1398951 | 2022-05-06 | US | Iowa | Wright | 19197 | 3614 | 63 | 0 | 42.73305373 | -93.73515113 | 2022-05-07 04:21:09 | Wright, Iowa, US | |
2599545 | 2599545 | 2022-05-05 | US | Louisiana | Caldwell | 22021 | 3614 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-06 04:21:00 | Caldwell, Louisiana, US | |
2599306 | 2599306 | 2022-05-05 | US | Iowa | Wright | 19197 | 3614 | 63 | 0 | 42.73305373 | -93.73515113 | 2022-05-06 04:21:00 | Wright, Iowa, US | |
3268518 | 3268518 | 2022-05-04 | US | Texas | Bandera | 48019 | 3614 | 77 | 0 | 29.74619598 | -99.24598147 | 2022-05-05 04:20:55 | Bandera, Texas, US | |
3266994 | 3266994 | 2022-05-04 | US | Louisiana | Caldwell | 22021 | 3614 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-05 04:20:55 | Caldwell, Louisiana, US | |
3266755 | 3266755 | 2022-05-04 | US | Iowa | Wright | 19197 | 3614 | 63 | 0 | 42.73305373 | -93.73515113 | 2022-05-05 04:20:55 | Wright, Iowa, US | |
1575157 | 1575157 | 2022-05-03 | US | Texas | Bandera | 48019 | 3614 | 77 | 0 | 29.74619598 | -99.24598147 | 2022-05-04 04:20:59 | Bandera, Texas, US | |
1573633 | 1573633 | 2022-05-03 | US | Louisiana | Caldwell | 22021 | 3614 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-04 04:20:59 | Caldwell, Louisiana, US | |
466417 | 466417 | 2022-05-02 | US | Texas | Bandera | 48019 | 3614 | 77 | 0 | 29.74619598 | -99.24598147 | 2022-05-03 04:21:00 | Bandera, Texas, US | |
464893 | 464893 | 2022-05-02 | US | Louisiana | Caldwell | 22021 | 3614 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-05-03 04:21:00 | Caldwell, Louisiana, US | |
3919056 | 3919056 | 2022-05-01 | US | Texas | Bandera | 48019 | 3614 | 77 | 0 | 29.74619598 | -99.24598147 | 2022-05-02 04:21:10 | Bandera, Texas, US | |
2843860 | 2843860 | 2022-04-30 | US | Texas | Bandera | 48019 | 3614 | 77 | 0 | 29.74619598 | -99.24598147 | 2022-05-01 04:20:57 | Bandera, Texas, US | |
3723193 | 3723193 | 2022-04-25 | US | Illinois | Greene | 17061 | 3614 | 45 | 0 | 39.35907414 | -90.388865 | 2022-04-26 04:20:51 | Greene, Illinois, US | |
2029761 | 2029761 | 2022-04-24 | US | Illinois | Greene | 17061 | 3614 | 45 | 0 | 39.35907414 | -90.388865 | 2022-04-25 04:20:56 | Greene, Illinois, US | |
747336 | 747336 | 2022-04-23 | US | Illinois | Greene | 17061 | 3614 | 45 | 0 | 39.35907414 | -90.388865 | 2022-04-24 04:20:56 | Greene, Illinois, US | |
3437821 | 3437821 | 2022-04-22 | US | Illinois | Greene | 17061 | 3614 | 45 | 0 | 39.35907414 | -90.388865 | 2022-04-23 04:20:50 | Greene, Illinois, US | |
2893406 | 2893406 | 2022-04-21 | US | Illinois | Greene | 17061 | 3614 | 45 | 0 | 39.35907414 | -90.388865 | 2022-04-22 04:20:45 | Greene, Illinois, US | |
158647 | 158647 | 2022-03-29 | US | Colorado | Las Animas | 8071 | 3614 | 43 | 0 | 37.3153406 | -104.03764579999999 | 2022-03-30 04:20:45 | Las Animas, Colorado, US | |
1437218 | 1437218 | 2022-03-28 | US | Colorado | Las Animas | 8071 | 3614 | 43 | 0 | 37.3153406 | -104.03764579999999 | 2022-03-29 04:20:46 | Las Animas, Colorado, US | |
877715 | 877715 | 2022-03-27 | US | Kentucky | Monroe | 21171 | 3614 | 75 | 0 | 36.71225341 | -85.71596443 | 2022-03-28 04:20:33 | Monroe, Kentucky, US | |
2164998 | 2164998 | 2022-03-26 | US | Kentucky | Monroe | 21171 | 3614 | 75 | 0 | 36.71225341 | -85.71596443 | 2022-03-27 04:20:47 | Monroe, Kentucky, US | |
1721934 | 1721934 | 2022-03-25 | US | Kentucky | Monroe | 21171 | 3614 | 75 | 0 | 36.71225341 | -85.71596443 | 2022-03-26 04:20:23 | Monroe, Kentucky, US | |
1469551 | 1469551 | 2022-03-24 | US | Kentucky | Monroe | 21171 | 3614 | 75 | 0 | 36.71225341 | -85.71596443 | 2022-03-25 04:20:46 | Monroe, Kentucky, US | |
3023725 | 3023725 | 2022-03-23 | US | Kentucky | Monroe | 21171 | 3614 | 75 | 0 | 36.71225341 | -85.71596443 | 2022-03-24 04:20:43 | Monroe, Kentucky, US | |
1906647 | 1906647 | 2022-03-22 | US | Kentucky | Monroe | 21171 | 3614 | 75 | 0 | 36.71225341 | -85.71596443 | 2022-03-23 04:20:48 | Monroe, Kentucky, US | |
3239778 | 3239778 | 2022-03-21 | US | Kentucky | Monroe | 21171 | 3614 | 75 | 0 | 36.71225341 | -85.71596443 | 2022-03-22 04:20:54 | Monroe, Kentucky, US | |
697996 | 697996 | 2022-03-17 | US | Wyoming | Goshen | 56015 | 3614 | 56 | 0 | 42.08798185 | -104.3534743 | 2022-03-18 04:20:55 | Goshen, Wyoming, US | |
2322939 | 2322939 | 2022-03-16 | US | Wyoming | Goshen | 56015 | 3614 | 56 | 0 | 42.08798185 | -104.3534743 | 2022-03-17 04:20:56 | Goshen, Wyoming, US | |
265139 | 265139 | 2022-03-15 | US | Wyoming | Goshen | 56015 | 3614 | 56 | 0 | 42.08798185 | -104.3534743 | 2022-03-16 04:20:50 | Goshen, Wyoming, US | |
2265441 | 2265441 | 2022-03-14 | US | Louisiana | West Carroll | 22123 | 3614 | 61 | 0 | 32.78550125 | -91.461201 | 2022-03-15 04:20:47 | West Carroll, Louisiana, US | |
3629507 | 3629507 | 2022-03-13 | US | Louisiana | West Carroll | 22123 | 3614 | 61 | 0 | 32.78550125 | -91.461201 | 2022-03-14 04:20:46 | West Carroll, Louisiana, US | |
952415 | 952415 | 2022-03-12 | US | Louisiana | West Carroll | 22123 | 3614 | 61 | 0 | 32.78550125 | -91.461201 | 2022-03-13 04:20:49 | West Carroll, Louisiana, US | |
357876 | 357876 | 2022-03-11 | US | Louisiana | West Carroll | 22123 | 3614 | 61 | 0 | 32.78550125 | -91.461201 | 2022-03-12 04:20:50 | West Carroll, Louisiana, 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]);