johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
341 rows where confirmed = 2058 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717399 | 3717399 | 2022-12-06 | US | Texas | Stephens | 48429 | 2058 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-07 04:20:58 | Stephens, Texas, US | |
2418104 | 2418104 | 2022-12-05 | US | Texas | Stephens | 48429 | 2058 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-06 04:21:03 | Stephens, Texas, US | |
721712 | 721712 | 2022-12-04 | US | Texas | Stephens | 48429 | 2058 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-05 04:20:58 | Stephens, Texas, US | |
2820001 | 2820001 | 2022-12-03 | US | Texas | Stephens | 48429 | 2058 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-04 04:20:56 | Stephens, Texas, US | |
836857 | 836857 | 2022-12-02 | US | Texas | Stephens | 48429 | 2058 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-03 04:21:02 | Stephens, Texas, US | |
2139387 | 2139387 | 2022-12-01 | US | Texas | Stephens | 48429 | 2058 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-02 04:21:07 | Stephens, Texas, US | |
1967803 | 1967803 | 2022-11-30 | US | Texas | Stephens | 48429 | 2058 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-01 04:21:03 | Stephens, Texas, US | |
851336 | 851336 | 2022-11-02 | US | Minnesota | Lac qui Parle | 27073 | 2058 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-11-03 04:22:05 | Lac qui Parle, Minnesota, US | |
712187 | 712187 | 2022-11-01 | US | Minnesota | Lac qui Parle | 27073 | 2058 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-11-02 04:22:09 | Lac qui Parle, Minnesota, US | |
3286636 | 3286636 | 2022-10-31 | US | Minnesota | Lac qui Parle | 27073 | 2058 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-11-01 04:22:36 | Lac qui Parle, Minnesota, US | |
321669 | 321669 | 2022-10-30 | US | Minnesota | Lac qui Parle | 27073 | 2058 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-10-31 04:21:36 | Lac qui Parle, Minnesota, US | |
913945 | 913945 | 2022-10-29 | US | Minnesota | Lac qui Parle | 27073 | 2058 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-10-30 04:22:14 | Lac qui Parle, Minnesota, US | |
1368214 | 1368214 | 2022-10-28 | US | Minnesota | Lac qui Parle | 27073 | 2058 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-10-29 04:21:13 | Lac qui Parle, Minnesota, US | |
3041596 | 3041596 | 2022-10-27 | US | Texas | Winkler | 48495 | 2058 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-10-28 04:22:31 | Winkler, Texas, US | |
3040069 | 3040069 | 2022-10-27 | US | Minnesota | Lac qui Parle | 27073 | 2058 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-10-28 04:22:31 | Lac qui Parle, Minnesota, US | |
542016 | 542016 | 2022-10-26 | US | Texas | Winkler | 48495 | 2058 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-10-27 04:22:01 | Winkler, Texas, US | |
2162519 | 2162519 | 2022-10-16 | US | Tennessee | Pickett | 47137 | 2058 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-17 04:20:31 | Pickett, Tennessee, US | |
518716 | 518716 | 2022-10-15 | US | Tennessee | Pickett | 47137 | 2058 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-16 04:22:39 | Pickett, Tennessee, US | |
118178 | 118178 | 2022-09-06 | US | Virginia | Williamsburg | 51830 | 2058 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-07 04:20:59 | Williamsburg, Virginia, US | |
2636931 | 2636931 | 2022-09-05 | US | Texas | Refugio | 48391 | 2058 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-09-06 04:21:02 | Refugio, Texas, US | |
2990495 | 2990495 | 2022-09-04 | US | Texas | Refugio | 48391 | 2058 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-09-05 04:21:01 | Refugio, Texas, US | |
2716180 | 2716180 | 2022-09-03 | US | Texas | Refugio | 48391 | 2058 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-09-04 04:21:22 | Refugio, Texas, US | |
1396885 | 1396885 | 2022-09-02 | US | Texas | Refugio | 48391 | 2058 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-09-03 04:21:04 | Refugio, Texas, US | |
2346628 | 2346628 | 2022-08-31 | US | Texas | Rains | 48379 | 2058 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-09-01 04:21:03 | Rains, Texas, US | |
1534933 | 1534933 | 2022-08-26 | US | Tennessee | Van Buren | 47175 | 2058 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-27 04:20:57 | Van Buren, Tennessee, US | |
2012169 | 2012169 | 2022-08-04 | US | West Virginia | Calhoun | 54013 | 2058 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-08-05 04:20:52 | Calhoun, West Virginia, US | |
1066511 | 1066511 | 2022-07-28 | US | Colorado | Lake | 8065 | 2058 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-29 04:20:45 | Lake, Colorado, US | |
2336030 | 2336030 | 2022-07-27 | US | Colorado | Lake | 8065 | 2058 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-28 04:20:56 | Lake, Colorado, US | |
1488220 | 1488220 | 2022-07-26 | US | Colorado | Lake | 8065 | 2058 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-27 04:21:04 | Lake, Colorado, US | |
1488197 | 1488197 | 2022-07-26 | US | Colorado | Conejos | 8021 | 2058 | 57 | 0 | 37.201606 | -106.1917488 | 2022-07-27 04:21:04 | Conejos, Colorado, US | |
2594666 | 2594666 | 2022-07-25 | US | Colorado | Lake | 8065 | 2058 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-26 04:20:58 | Lake, Colorado, US | |
896781 | 896781 | 2022-07-24 | US | Colorado | Lake | 8065 | 2058 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-07-25 04:20:51 | Lake, Colorado, US | |
633415 | 633415 | 2022-07-12 | US | West Virginia | Pendleton | 54071 | 2058 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-07-13 04:20:58 | Pendleton, West Virginia, US | |
1215059 | 1215059 | 2022-07-11 | US | West Virginia | Pendleton | 54071 | 2058 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-07-12 04:20:51 | Pendleton, West Virginia, US | |
1651952 | 1651952 | 2022-06-23 | US | Wisconsin | Pepin | 55091 | 2058 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-24 04:20:58 | Pepin, Wisconsin, US | |
1947446 | 1947446 | 2022-06-10 | US | Tennessee | Hancock | 47067 | 2058 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-11 04:21:01 | Hancock, Tennessee, US | |
3160585 | 3160585 | 2022-06-09 | US | Tennessee | Hancock | 47067 | 2058 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-10 04:20:55 | Hancock, Tennessee, US | |
1424052 | 1424052 | 2022-06-08 | US | Tennessee | Hancock | 47067 | 2058 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-09 04:20:54 | Hancock, Tennessee, US | |
3186348 | 3186348 | 2022-05-30 | US | Alabama | Choctaw | 1023 | 2058 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-05-31 04:20:51 | Choctaw, Alabama, US | |
3198497 | 3198497 | 2022-05-29 | US | Alabama | Choctaw | 1023 | 2058 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-05-30 04:20:50 | Choctaw, Alabama, US | |
2725375 | 2725375 | 2022-05-28 | US | Alabama | Choctaw | 1023 | 2058 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-05-29 04:20:53 | Choctaw, Alabama, US | |
1314556 | 1314556 | 2022-05-27 | US | Alabama | Choctaw | 1023 | 2058 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-05-28 04:21:07 | Choctaw, Alabama, US | |
2309275 | 2309275 | 2022-04-20 | US | Montana | Carbon | 30009 | 2058 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-04-21 04:20:46 | Carbon, Montana, US | |
1849311 | 1849311 | 2022-04-18 | US | Virginia | Falls Church | 51610 | 2058 | 16 | 0 | 38.88485255 | -77.17560759 | 2022-04-19 04:21:00 | Falls Church, Virginia, US | |
876079 | 876079 | 2022-03-27 | China | Yunnan | 2058 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-28 04:20:33 | Yunnan, China | |||
2322839 | 2322839 | 2022-03-16 | US | West Virginia | Pleasants | 54073 | 2058 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-17 04:20:56 | Pleasants, West Virginia, US | |
265039 | 265039 | 2022-03-15 | US | West Virginia | Pleasants | 54073 | 2058 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-16 04:20:50 | Pleasants, West Virginia, US | |
263266 | 263266 | 2022-03-15 | US | Minnesota | Lake | 27075 | 2058 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-03-16 04:20:50 | Lake, Minnesota, US | |
2200408 | 2200408 | 2022-03-06 | US | Georgia | Candler | 13043 | 2058 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-03-07 04:20:47 | Candler, Georgia, US | |
2094873 | 2094873 | 2022-03-05 | US | Puerto Rico | Sabana Grande | 72121 | 2058 | 0 | 0 | 18.08282 | -66.943758 | 2022-03-06 04:20:49 | Sabana Grande, Puerto Rico, US | |
2092865 | 2092865 | 2022-03-05 | US | Georgia | Candler | 13043 | 2058 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-03-06 04:20:49 | Candler, Georgia, US | |
2666565 | 2666565 | 2022-03-04 | US | Georgia | Candler | 13043 | 2058 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-03-05 04:21:10 | Candler, Georgia, US | |
1993427 | 1993427 | 2022-03-01 | US | Georgia | Candler | 13043 | 2058 | 91 | 0 | 32.40209349 | -82.07702563 | 2022-03-02 04:21:07 | Candler, Georgia, US | |
2735827 | 2735827 | 2022-02-27 | US | South Carolina | Allendale | 45005 | 2058 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-02-28 04:21:05 | Allendale, South Carolina, US | |
3048980 | 3048980 | 2022-02-26 | US | South Carolina | Allendale | 45005 | 2058 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-02-27 04:21:04 | Allendale, South Carolina, US | |
577635 | 577635 | 2022-02-25 | US | South Carolina | Allendale | 45005 | 2058 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-02-26 04:21:12 | Allendale, South Carolina, US | |
1514211 | 1514211 | 2022-02-24 | US | South Carolina | Allendale | 45005 | 2058 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-02-25 04:21:11 | Allendale, South Carolina, US | |
3674719 | 3674719 | 2022-02-15 | US | Texas | Dallam | 48111 | 2058 | 38 | 0 | 36.27787176 | -102.60207249999999 | 2022-02-16 04:21:10 | Dallam, Texas, US | |
236013 | 236013 | 2022-02-11 | US | Puerto Rico | Penuelas | 72111 | 2058 | 0 | 0 | 18.059645 | -66.721572 | 2022-02-12 04:21:06 | Penuelas, Puerto Rico, US | |
1295940 | 1295940 | 2022-02-05 | US | Missouri | Gentry | 29075 | 2058 | 28 | 0 | 40.21097916 | -94.40944419 | 2022-02-06 04:21:00 | Gentry, Missouri, US | |
461198 | 461198 | 2022-02-02 | US | Mississippi | Kemper | 28069 | 2058 | 43 | 0 | 32.75462946 | -88.64105766 | 2022-02-03 04:21:21 | Kemper, Mississippi, US | |
460220 | 460220 | 2022-02-02 | US | Georgia | Macon | 13193 | 2058 | 47 | 0 | 32.35207048 | -84.04234127 | 2022-02-03 04:21:21 | Macon, Georgia, US | |
459891 | 459891 | 2022-02-02 | US | Arkansas | Nevada | 5099 | 2058 | 42 | 0 | 33.66340119 | -93.30632432 | 2022-02-03 04:21:21 | Nevada, Arkansas, US | |
3065203 | 3065203 | 2022-01-29 | US | Texas | Red River | 48387 | 2058 | 59 | 0 | 33.61886692 | -95.04841765 | 2022-01-30 04:21:26 | Red River, Texas, US | |
1142308 | 1142308 | 2022-01-23 | US | Kentucky | Edmonson | 21061 | 2058 | 35 | 0 | 37.21218923 | -86.23955613 | 2022-01-24 04:21:12 | Edmonson, Kentucky, US | |
2834226 | 2834226 | 2022-01-22 | US | Kentucky | Edmonson | 21061 | 2058 | 35 | 0 | 37.21218923 | -86.23955613 | 2022-01-23 04:21:13 | Edmonson, Kentucky, US | |
3426344 | 3426344 | 2022-01-21 | US | Kentucky | Edmonson | 21061 | 2058 | 35 | 0 | 37.21218923 | -86.23955613 | 2022-01-22 04:21:13 | Edmonson, Kentucky, US | |
1961986 | 1961986 | 2022-01-20 | US | Kentucky | Lee | 21129 | 2058 | 44 | 0 | 37.59645942 | -83.71513901 | 2022-01-21 04:21:09 | Lee, Kentucky, US | |
1473886 | 1473886 | 2022-01-17 | US | Minnesota | Stevens | 27149 | 2058 | 11 | 0 | 45.58613007 | -96.00163705 | 2022-01-18 04:21:04 | Stevens, Minnesota, US | |
556560 | 556560 | 2022-01-16 | US | Minnesota | Stevens | 27149 | 2058 | 11 | 0 | 45.58613007 | -96.00163705 | 2022-01-17 04:21:08 | Stevens, Minnesota, US | |
3842281 | 3842281 | 2022-01-15 | US | Minnesota | Stevens | 27149 | 2058 | 11 | 0 | 45.58613007 | -96.00163705 | 2022-01-16 04:21:12 | Stevens, Minnesota, US | |
101096 | 101096 | 2022-01-14 | US | Minnesota | Stevens | 27149 | 2058 | 11 | 0 | 45.58613007 | -96.00163705 | 2022-01-15 04:21:07 | Stevens, Minnesota, US | |
3688084 | 3688084 | 2022-01-13 | US | Colorado | Bent | 8011 | 2058 | 46 | 0 | 37.95474293 | -103.0720195 | 2022-01-14 04:21:54 | Bent, Colorado, US | |
1390047 | 1390047 | 2022-01-07 | US | Alabama | Lowndes | 1085 | 2058 | 68 | 0 | 32.1597283 | -86.65158371 | 2022-01-08 04:21:53 | Lowndes, Alabama, US | |
1281805 | 1281805 | 2022-01-05 | China | Zhejiang | 2058 | 1 | 0 | 29.1832 | 120.0934 | 2022-01-06 04:22:09 | Zhejiang, China | |||
2112167 | 2112167 | 2021-12-26 | US | Arkansas | Bradley | 5011 | 2058 | 42 | 0 | 33.46755808 | -92.15980837 | 2021-12-27 04:21:58 | Bradley, Arkansas, US | |
3605721 | 3605721 | 2021-12-25 | US | Colorado | Prowers | 8099 | 2058 | 45 | 0 | 37.95544985 | -102.3926052 | 2021-12-26 04:21:50 | Prowers, Colorado, US | |
3605539 | 3605539 | 2021-12-25 | US | Arkansas | Bradley | 5011 | 2058 | 42 | 0 | 33.46755808 | -92.15980837 | 2021-12-26 04:21:50 | Bradley, Arkansas, US | |
2963857 | 2963857 | 2021-12-24 | US | Arkansas | Bradley | 5011 | 2058 | 42 | 0 | 33.46755808 | -92.15980837 | 2021-12-25 04:21:37 | Bradley, Arkansas, US | |
3816889 | 3816889 | 2021-12-23 | US | Arkansas | Bradley | 5011 | 2058 | 42 | 0 | 33.46755808 | -92.15980837 | 2021-12-24 04:21:34 | Bradley, Arkansas, US | |
785815 | 785815 | 2021-12-13 | US | Virginia | Westmoreland | 51193 | 2058 | 39 | 0 | 38.11021557 | -76.80213247 | 2021-12-14 04:22:38 | Westmoreland, Virginia, US | |
1661925 | 1661925 | 2021-12-12 | US | Louisiana | Claiborne | 22027 | 2058 | 66 | 0 | 32.82308512 | -92.99526883 | 2021-12-13 04:22:02 | Claiborne, Louisiana, US | |
1665941 | 1665941 | 2021-12-11 | US | Louisiana | Claiborne | 22027 | 2058 | 66 | 0 | 32.82308512 | -92.99526883 | 2021-12-12 04:22:12 | Claiborne, Louisiana, US | |
3657093 | 3657093 | 2021-12-10 | US | Louisiana | Claiborne | 22027 | 2058 | 66 | 0 | 32.82308512 | -92.99526883 | 2021-12-11 04:22:45 | Claiborne, Louisiana, US | |
1079165 | 1079165 | 2021-12-09 | US | Iowa | Shelby | 19165 | 2058 | 42 | 0 | 41.6850066 | -95.31015553 | 2021-12-10 04:22:28 | Shelby, Iowa, US | |
553042 | 553042 | 2021-12-08 | US | New York | Schuyler | 36097 | 2058 | 20 | 0 | 42.39184015 | -76.8773299 | 2021-12-09 04:22:49 | Schuyler, New York, US | |
552014 | 552014 | 2021-12-08 | US | Iowa | Shelby | 19165 | 2058 | 42 | 0 | 41.6850066 | -95.31015553 | 2021-12-09 04:22:49 | Shelby, Iowa, US | |
3073071 | 3073071 | 2021-11-23 | US | Texas | Camp | 48063 | 2058 | 67 | 0 | 32.97195142 | -94.97790104 | 2021-11-24 04:22:14 | Camp, Texas, US | |
3751624 | 3751624 | 2021-11-22 | US | Ohio | Morgan | 39115 | 2058 | 39 | 0 | 39.62081738 | -81.85308173 | 2021-11-23 04:22:39 | Morgan, Ohio, US | |
448326 | 448326 | 2021-11-17 | US | Idaho | Shoshone | 16079 | 2058 | 63 | 0 | 47.35364087 | -115.89167490000001 | 2021-11-18 04:21:33 | Shoshone, Idaho, US | |
1323300 | 1323300 | 2021-11-14 | US | Indiana | Blackford | 18009 | 2058 | 43 | 0 | 40.47388153 | -85.32499702 | 2021-11-15 04:21:36 | Blackford, Indiana, US | |
715100 | 715100 | 2021-11-12 | US | Colorado | Las Animas | 8071 | 2058 | 26 | 0 | 37.3153406 | -104.03764579999999 | 2021-11-13 04:21:38 | Las Animas, Colorado, US | |
31113 | 31113 | 2021-11-11 | US | Pennsylvania | Potter | 42105 | 2058 | 51 | 0 | 41.74471626 | -77.89559864 | 2021-11-12 04:22:01 | Potter, Pennsylvania, US | |
2846232 | 2846232 | 2021-11-10 | US | Kentucky | Breathitt | 21025 | 2058 | 36 | 0 | 37.52333168 | -83.31959161 | 2021-11-11 04:21:45 | Breathitt, Kentucky, US | |
3641121 | 3641121 | 2021-11-08 | US | Maine | Washington | 23029 | 2058 | 23 | 0 | 45.01607142 | -67.62813524 | 2021-11-09 04:21:36 | Washington, Maine, US | |
2004261 | 2004261 | 2021-11-07 | US | Wyoming | Big Horn | 56003 | 2058 | 54 | 0 | 44.52405055 | -107.9960365 | 2021-11-08 04:21:43 | Big Horn, Wyoming, US | |
2002229 | 2002229 | 2021-11-07 | US | Maine | Washington | 23029 | 2058 | 23 | 0 | 45.01607142 | -67.62813524 | 2021-11-08 04:21:43 | Washington, Maine, US | |
499252 | 499252 | 2021-11-06 | US | Wyoming | Big Horn | 56003 | 2058 | 54 | 0 | 44.52405055 | -107.9960365 | 2021-11-07 04:21:53 | Big Horn, Wyoming, US | |
497220 | 497220 | 2021-11-06 | US | Maine | Washington | 23029 | 2058 | 23 | 0 | 45.01607142 | -67.62813524 | 2021-11-07 04:21:53 | Washington, Maine, US | |
3125107 | 3125107 | 2021-11-05 | US | Wyoming | Big Horn | 56003 | 2058 | 54 | 0 | 44.52405055 | -107.9960365 | 2021-11-06 04:21:51 | Big Horn, Wyoming, 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]);