johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
398 rows where confirmed = 2145 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2181751 | 2181751 | 2022-12-22 | US | New Hampshire | Unassigned | 90033 | 2145 | 7 | 0 | 44.69063265 | 0.0 | 2022-12-23 04:21:04 | Unassigned, New Hampshire, US | |
1052846 | 1052846 | 2022-11-06 | US | Tennessee | Van Buren | 47175 | 2145 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-11-07 04:21:26 | Van Buren, Tennessee, US | |
433384 | 433384 | 2022-11-03 | US | Montana | Powell | 30077 | 2145 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-11-04 04:22:11 | Powell, Montana, US | |
851626 | 851626 | 2022-11-02 | US | Montana | Powell | 30077 | 2145 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-11-03 04:22:05 | Powell, Montana, US | |
712477 | 712477 | 2022-11-01 | US | Montana | Powell | 30077 | 2145 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-11-02 04:22:09 | Powell, Montana, US | |
3286926 | 3286926 | 2022-10-31 | US | Montana | Powell | 30077 | 2145 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-11-01 04:22:36 | Powell, Montana, US | |
321959 | 321959 | 2022-10-30 | US | Montana | Powell | 30077 | 2145 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-10-31 04:21:36 | Powell, Montana, US | |
914235 | 914235 | 2022-10-29 | US | Montana | Powell | 30077 | 2145 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-10-30 04:22:14 | Powell, Montana, US | |
1368504 | 1368504 | 2022-10-28 | US | Montana | Powell | 30077 | 2145 | 31 | 0 | 46.85538891 | -112.9359164 | 2022-10-29 04:21:13 | Powell, Montana, US | |
201688 | 201688 | 2022-10-19 | US | Virginia | Williamsburg | 51830 | 2145 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-20 04:22:59 | Williamsburg, Virginia, US | |
2529995 | 2529995 | 2022-10-06 | US | Colorado | Conejos | 8021 | 2145 | 57 | 0 | 37.201606 | -106.1917488 | 2022-10-07 04:23:08 | Conejos, Colorado, US | |
1563460 | 1563460 | 2022-09-28 | US | Virginia | Lancaster | 51103 | 2145 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-09-29 04:22:34 | Lancaster, Virginia, US | |
2017150 | 2017150 | 2022-09-20 | US | Alaska | Dillingham | 2070 | 2145 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-21 04:23:22 | Dillingham, Alaska, US | |
3571023 | 3571023 | 2022-09-19 | US | Alaska | Dillingham | 2070 | 2145 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-20 04:22:48 | Dillingham, Alaska, US | |
419762 | 419762 | 2022-09-18 | US | Alaska | Dillingham | 2070 | 2145 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-19 04:21:49 | Dillingham, Alaska, US | |
3373786 | 3373786 | 2022-09-17 | US | Alaska | Dillingham | 2070 | 2145 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-18 04:22:50 | Dillingham, Alaska, US | |
2355894 | 2355894 | 2022-09-16 | US | Alaska | Dillingham | 2070 | 2145 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-17 04:20:19 | Dillingham, Alaska, US | |
3987051 | 3987051 | 2022-09-15 | US | Alaska | Dillingham | 2070 | 2145 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-16 04:21:19 | Dillingham, Alaska, US | |
1889568 | 1889568 | 2022-09-14 | US | Alaska | Dillingham | 2070 | 2145 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-09-15 04:21:02 | Dillingham, Alaska, US | |
2398411 | 2398411 | 2022-09-12 | US | Wyoming | Johnson | 56019 | 2145 | 20 | 0 | 44.04057166 | -106.5845174 | 2022-09-13 04:20:57 | Johnson, Wyoming, US | |
3769489 | 3769489 | 2022-09-11 | US | Wyoming | Johnson | 56019 | 2145 | 20 | 0 | 44.04057166 | -106.5845174 | 2022-09-12 04:20:58 | Johnson, Wyoming, US | |
3828064 | 3828064 | 2022-09-10 | US | Wyoming | Johnson | 56019 | 2145 | 20 | 0 | 44.04057166 | -106.5845174 | 2022-09-11 04:20:50 | Johnson, Wyoming, US | |
966521 | 966521 | 2022-09-09 | US | Wyoming | Johnson | 56019 | 2145 | 20 | 0 | 44.04057166 | -106.5845174 | 2022-09-10 04:21:10 | Johnson, Wyoming, US | |
256923 | 256923 | 2022-09-08 | US | Wyoming | Johnson | 56019 | 2145 | 20 | 0 | 44.04057166 | -106.5845174 | 2022-09-09 04:21:11 | Johnson, Wyoming, US | |
3748721 | 3748721 | 2022-09-07 | US | Wyoming | Johnson | 56019 | 2145 | 20 | 0 | 44.04057166 | -106.5845174 | 2022-09-08 04:21:02 | Johnson, Wyoming, US | |
118361 | 118361 | 2022-09-06 | US | Wyoming | Johnson | 56019 | 2145 | 20 | 0 | 44.04057166 | -106.5845174 | 2022-09-07 04:20:59 | Johnson, Wyoming, US | |
2989676 | 2989676 | 2022-09-04 | US | North Dakota | Benson | 38005 | 2145 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-09-05 04:21:01 | Benson, North Dakota, US | |
1251422 | 1251422 | 2022-08-23 | US | Colorado | Yuma | 8125 | 2145 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-24 04:20:46 | Yuma, Colorado, US | |
2855950 | 2855950 | 2022-08-22 | US | Texas | Floyd | 48153 | 2145 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-08-23 04:20:56 | Floyd, Texas, US | |
2853526 | 2853526 | 2022-08-22 | US | Colorado | Yuma | 8125 | 2145 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-23 04:20:56 | Yuma, Colorado, US | |
2403498 | 2403498 | 2022-08-21 | US | Colorado | Yuma | 8125 | 2145 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-22 04:20:38 | Yuma, Colorado, US | |
3798576 | 3798576 | 2022-08-20 | US | Colorado | Yuma | 8125 | 2145 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-21 04:20:44 | Yuma, Colorado, US | |
2364162 | 2364162 | 2022-08-19 | US | Colorado | Yuma | 8125 | 2145 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-20 04:21:01 | Yuma, Colorado, US | |
1164742 | 1164742 | 2022-08-18 | US | Wisconsin | Pepin | 55091 | 2145 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-08-19 04:20:54 | Pepin, Wisconsin, US | |
1161833 | 1161833 | 2022-08-18 | US | Colorado | Yuma | 8125 | 2145 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-19 04:20:54 | Yuma, Colorado, US | |
3951157 | 3951157 | 2022-08-17 | US | Colorado | Yuma | 8125 | 2145 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-18 04:21:11 | Yuma, Colorado, US | |
3620030 | 3620030 | 2022-08-01 | US | Tennessee | Hancock | 47067 | 2145 | 39 | 0 | 36.52692871 | -83.22375847 | 2022-08-02 04:20:53 | Hancock, Tennessee, US | |
3874786 | 3874786 | 2022-07-31 | US | Texas | Somervell | 48425 | 2145 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-01 04:21:03 | Somervell, Texas, US | |
677540 | 677540 | 2022-07-30 | US | Texas | Somervell | 48425 | 2145 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-07-31 04:21:02 | Somervell, Texas, US | |
1786739 | 1786739 | 2022-07-29 | US | Texas | Somervell | 48425 | 2145 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-07-30 04:20:42 | Somervell, Texas, US | |
2154414 | 2154414 | 2022-07-16 | US | Puerto Rico | Las Marias | 72083 | 2145 | 0 | 0 | 18.23679 | -66.98362 | 2022-07-17 04:21:15 | Las Marias, Puerto Rico, US | |
2421647 | 2421647 | 2022-07-15 | US | Puerto Rico | Las Marias | 72083 | 2145 | 0 | 0 | 18.23679 | -66.98362 | 2022-07-16 04:21:05 | Las Marias, Puerto Rico, US | |
3109283 | 3109283 | 2022-07-13 | China | Inner Mongolia | 2145 | 1 | 0 | 44.0935 | 113.9448 | 2022-07-14 04:20:57 | Inner Mongolia, China | |||
630955 | 630955 | 2022-07-12 | US | Illinois | Schuyler | 17169 | 2145 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-07-13 04:20:58 | Schuyler, Illinois, US | |
3970058 | 3970058 | 2022-07-05 | US | West Virginia | Pleasants | 54073 | 2145 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-07-06 04:20:58 | Pleasants, West Virginia, US | |
167661 | 167661 | 2022-06-21 | US | Michigan | Baraga | 26013 | 2145 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-22 04:20:54 | Baraga, Michigan, US | |
167573 | 167573 | 2022-06-21 | US | Louisiana | Red River | 22081 | 2145 | 53 | 0 | 32.09530039 | -93.34213308 | 2022-06-22 04:20:54 | Red River, Louisiana, US | |
1764944 | 1764944 | 2022-06-20 | US | Michigan | Baraga | 26013 | 2145 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-21 04:20:56 | Baraga, Michigan, US | |
3271130 | 3271130 | 2022-06-19 | US | Michigan | Baraga | 26013 | 2145 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-20 04:21:01 | Baraga, Michigan, US | |
3270666 | 3270666 | 2022-06-19 | US | Indiana | Warren | 18171 | 2145 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-06-20 04:21:01 | Warren, Indiana, US | |
3399042 | 3399042 | 2022-06-18 | US | Michigan | Baraga | 26013 | 2145 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-19 04:20:51 | Baraga, Michigan, US | |
3398578 | 3398578 | 2022-06-18 | US | Indiana | Warren | 18171 | 2145 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-06-19 04:20:51 | Warren, Indiana, US | |
2312919 | 2312919 | 2022-06-17 | US | Michigan | Baraga | 26013 | 2145 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-18 04:21:10 | Baraga, Michigan, US | |
2312455 | 2312455 | 2022-06-17 | US | Indiana | Warren | 18171 | 2145 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-06-18 04:21:10 | Warren, Indiana, US | |
560423 | 560423 | 2022-06-16 | US | Michigan | Baraga | 26013 | 2145 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-17 04:20:56 | Baraga, Michigan, US | |
559205 | 559205 | 2022-06-16 | US | Alabama | Perry | 1105 | 2145 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-06-17 04:20:56 | Perry, Alabama, US | |
3984225 | 3984225 | 2022-06-15 | US | Michigan | Baraga | 26013 | 2145 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-16 04:20:55 | Baraga, Michigan, US | |
3160972 | 3160972 | 2022-06-09 | US | Virginia | Fairfax City | 51600 | 2145 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-06-10 04:20:55 | Fairfax City, Virginia, US | |
3197955 | 3197955 | 2022-05-29 | China | Yunnan | 2145 | 2 | 0 | 24.974 | 101.487 | 2022-05-30 04:20:50 | Yunnan, China | |||
3917830 | 3917830 | 2022-05-01 | US | Mississippi | Claiborne | 28021 | 2145 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-02 04:21:10 | Claiborne, Mississippi, US | |
2842634 | 2842634 | 2022-04-30 | US | Mississippi | Claiborne | 28021 | 2145 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-01 04:20:57 | Claiborne, Mississippi, US | |
1160312 | 1160312 | 2022-04-29 | US | Texas | Live Oak | 48297 | 2145 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-04-30 04:21:05 | Live Oak, Texas, US | |
1158947 | 1158947 | 2022-04-29 | US | Mississippi | Claiborne | 28021 | 2145 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-30 04:21:05 | Claiborne, Mississippi, US | |
1698129 | 1698129 | 2022-04-28 | US | Mississippi | Claiborne | 28021 | 2145 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-29 04:20:59 | Claiborne, Mississippi, US | |
3853612 | 3853612 | 2022-04-27 | US | Mississippi | Claiborne | 28021 | 2145 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-28 04:20:47 | Claiborne, Mississippi, US | |
1328042 | 1328042 | 2022-04-26 | US | Mississippi | Claiborne | 28021 | 2145 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-04-27 04:20:52 | Claiborne, Mississippi, US | |
1578923 | 1578923 | 2022-04-10 | US | Puerto Rico | Penuelas | 72111 | 2145 | 0 | 0 | 18.059645 | -66.721572 | 2022-04-11 04:21:02 | Penuelas, Puerto Rico, US | |
2804159 | 2804159 | 2022-04-06 | US | Virginia | Northampton | 51131 | 2145 | 63 | 0 | 37.34062933 | -75.87751591 | 2022-04-07 04:20:53 | Northampton, Virginia, US | |
3869574 | 3869574 | 2022-04-05 | US | Montana | Sanders | 30089 | 2145 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-04-06 04:20:49 | Sanders, Montana, US | |
3353669 | 3353669 | 2022-04-01 | US | Texas | Archer | 48009 | 2145 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-04-02 04:20:47 | Archer, Texas, US | |
879743 | 879743 | 2022-03-27 | US | West Virginia | Doddridge | 54017 | 2145 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-28 04:20:33 | Doddridge, West Virginia, US | |
2167026 | 2167026 | 2022-03-26 | US | West Virginia | Doddridge | 54017 | 2145 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-27 04:20:47 | Doddridge, West Virginia, US | |
1723962 | 1723962 | 2022-03-25 | US | West Virginia | Doddridge | 54017 | 2145 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-26 04:20:23 | Doddridge, West Virginia, US | |
1471579 | 1471579 | 2022-03-24 | US | West Virginia | Doddridge | 54017 | 2145 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-25 04:20:46 | Doddridge, West Virginia, US | |
3025753 | 3025753 | 2022-03-23 | US | West Virginia | Doddridge | 54017 | 2145 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-24 04:20:43 | Doddridge, West Virginia, US | |
1908675 | 1908675 | 2022-03-22 | US | West Virginia | Doddridge | 54017 | 2145 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-23 04:20:48 | Doddridge, West Virginia, US | |
3241806 | 3241806 | 2022-03-21 | US | West Virginia | Doddridge | 54017 | 2145 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-03-22 04:20:54 | Doddridge, West Virginia, US | |
3240038 | 3240038 | 2022-03-21 | US | Minnesota | Clearwater | 27029 | 2145 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-03-22 04:20:54 | Clearwater, Minnesota, US | |
3629284 | 3629284 | 2022-03-13 | US | Kansas | Norton | 20137 | 2145 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-03-14 04:20:46 | Norton, Kansas, US | |
952192 | 952192 | 2022-03-12 | US | Kansas | Norton | 20137 | 2145 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-03-13 04:20:49 | Norton, Kansas, US | |
357653 | 357653 | 2022-03-11 | US | Kansas | Norton | 20137 | 2145 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-03-12 04:20:50 | Norton, Kansas, US | |
1866805 | 1866805 | 2022-03-10 | US | Kansas | Norton | 20137 | 2145 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-03-11 04:20:50 | Norton, Kansas, US | |
2141566 | 2141566 | 2022-03-09 | US | Kentucky | Crittenden | 21055 | 2145 | 45 | 0 | 37.35839237 | -88.08826090000002 | 2022-03-10 04:20:48 | Crittenden, Kentucky, US | |
2141500 | 2141500 | 2022-03-09 | US | Kansas | Norton | 20137 | 2145 | 37 | 0 | 39.78443827 | -99.90286639 | 2022-03-10 04:20:48 | Norton, Kansas, US | |
921077 | 921077 | 2022-03-08 | US | Kentucky | Crittenden | 21055 | 2145 | 45 | 0 | 37.35839237 | -88.08826090000002 | 2022-03-09 04:20:59 | Crittenden, Kentucky, US | |
1549364 | 1549364 | 2022-03-07 | US | Kentucky | Crittenden | 21055 | 2145 | 45 | 0 | 37.35839237 | -88.08826090000002 | 2022-03-08 04:20:54 | Crittenden, Kentucky, US | |
2201033 | 2201033 | 2022-03-06 | US | Kentucky | Crittenden | 21055 | 2145 | 45 | 0 | 37.35839237 | -88.08826090000002 | 2022-03-07 04:20:47 | Crittenden, Kentucky, US | |
2093490 | 2093490 | 2022-03-05 | US | Kentucky | Crittenden | 21055 | 2145 | 45 | 0 | 37.35839237 | -88.08826090000002 | 2022-03-06 04:20:49 | Crittenden, Kentucky, US | |
2667190 | 2667190 | 2022-03-04 | US | Kentucky | Crittenden | 21055 | 2145 | 45 | 0 | 37.35839237 | -88.08826090000002 | 2022-03-05 04:21:10 | Crittenden, Kentucky, US | |
1645756 | 1645756 | 2022-03-03 | US | Kentucky | Cumberland | 21057 | 2145 | 28 | 0 | 36.78926125 | -85.39050034 | 2022-03-04 04:21:09 | Cumberland, Kentucky, US | |
2735106 | 2735106 | 2022-02-27 | US | Nebraska | Hamilton | 31081 | 2145 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-28 04:21:05 | Hamilton, Nebraska, US | |
2733962 | 2733962 | 2022-02-27 | US | Idaho | Fremont | 16043 | 2145 | 25 | 0 | 44.22800938 | -111.48099429999999 | 2022-02-28 04:21:05 | Fremont, Idaho, US | |
3048259 | 3048259 | 2022-02-26 | US | Nebraska | Hamilton | 31081 | 2145 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-27 04:21:04 | Hamilton, Nebraska, US | |
3047115 | 3047115 | 2022-02-26 | US | Idaho | Fremont | 16043 | 2145 | 25 | 0 | 44.22800938 | -111.48099429999999 | 2022-02-27 04:21:04 | Fremont, Idaho, US | |
576914 | 576914 | 2022-02-25 | US | Nebraska | Hamilton | 31081 | 2145 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-26 04:21:12 | Hamilton, Nebraska, US | |
575770 | 575770 | 2022-02-25 | US | Idaho | Fremont | 16043 | 2145 | 25 | 0 | 44.22800938 | -111.48099429999999 | 2022-02-26 04:21:12 | Fremont, Idaho, US | |
1513322 | 1513322 | 2022-02-24 | US | Missouri | Iron | 29093 | 2145 | 36 | 0 | 37.55487945 | -90.7735296 | 2022-02-25 04:21:11 | Iron, Missouri, US | |
1512735 | 1512735 | 2022-02-24 | US | Kansas | Norton | 20137 | 2145 | 38 | 0 | 39.78443827 | -99.90286639 | 2022-02-25 04:21:11 | Norton, Kansas, US | |
1059786 | 1059786 | 2022-02-23 | US | Missouri | Monroe | 29137 | 2145 | 40 | 0 | 39.49593978 | -92.00043978 | 2022-02-24 04:21:14 | Monroe, Missouri, US | |
1059176 | 1059176 | 2022-02-23 | US | Kansas | Norton | 20137 | 2145 | 38 | 0 | 39.78443827 | -99.90286639 | 2022-02-24 04:21:14 | Norton, Kansas, 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]);