johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
308 rows where confirmed = 2055 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2559770 | 2559770 | 2022-11-29 | US | Texas | Mitchell | 48335 | 2055 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-11-30 04:21:07 | Mitchell, Texas, US | |
1242844 | 1242844 | 2022-11-28 | US | Texas | Mitchell | 48335 | 2055 | 50 | 0 | 32.30623474 | -100.9212058 | 2022-11-29 04:21:05 | Mitchell, Texas, US | |
1621262 | 1621262 | 2022-11-22 | US | Illinois | Edwards | 17047 | 2055 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-11-23 04:21:06 | Edwards, Illinois, US | |
3026082 | 3026082 | 2022-11-17 | China | Hebei | 2055 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-18 04:21:15 | Hebei, China | |||
2485793 | 2485793 | 2022-11-16 | China | Hebei | 2055 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-17 04:21:11 | Hebei, China | |||
291804 | 291804 | 2022-11-15 | China | Hebei | 2055 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-16 04:21:09 | Hebei, China | |||
2430736 | 2430736 | 2022-11-09 | China | Liaoning | 2055 | 2 | 0 | 41.2956 | 122.6085 | 2022-11-10 04:21:16 | Liaoning, China | |||
3253135 | 3253135 | 2022-10-11 | US | Tennessee | Pickett | 47137 | 2055 | 38 | 0 | 36.55606529 | -85.077633 | 2022-10-12 04:22:51 | Pickett, Tennessee, US | |
133052 | 133052 | 2022-10-04 | US | North Carolina | Camden | 37029 | 2055 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-10-05 04:23:06 | Camden, North Carolina, US | |
2687999 | 2687999 | 2022-10-03 | US | North Carolina | Camden | 37029 | 2055 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-10-04 04:22:55 | Camden, North Carolina, US | |
2262066 | 2262066 | 2022-10-02 | US | North Carolina | Camden | 37029 | 2055 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-10-03 04:23:11 | Camden, North Carolina, US | |
2997592 | 2997592 | 2022-10-01 | US | North Carolina | Camden | 37029 | 2055 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-10-02 04:21:23 | Camden, North Carolina, US | |
855918 | 855918 | 2022-09-30 | US | North Carolina | Camden | 37029 | 2055 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-10-01 04:23:01 | Camden, North Carolina, US | |
2377844 | 2377844 | 2022-09-29 | US | North Carolina | Camden | 37029 | 2055 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-30 04:23:09 | Camden, North Carolina, US | |
1562395 | 1562395 | 2022-09-28 | US | North Carolina | Camden | 37029 | 2055 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-09-29 04:22:34 | Camden, North Carolina, US | |
2637150 | 2637150 | 2022-09-05 | US | Virginia | Williamsburg | 51830 | 2055 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-06 04:21:02 | Williamsburg, Virginia, US | |
1681040 | 1681040 | 2022-08-29 | US | Arkansas | Woodruff | 5147 | 2055 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-08-30 04:21:03 | Woodruff, Arkansas, US | |
1880301 | 1880301 | 2022-08-28 | US | Virginia | Buena Vista | 51530 | 2055 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-08-29 04:21:06 | Buena Vista, Virginia, US | |
1877524 | 1877524 | 2022-08-28 | US | Arkansas | Woodruff | 5147 | 2055 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-08-29 04:21:06 | Woodruff, Arkansas, US | |
2099428 | 2099428 | 2022-08-27 | US | Virginia | Buena Vista | 51530 | 2055 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-08-28 04:21:02 | Buena Vista, Virginia, US | |
2096651 | 2096651 | 2022-08-27 | US | Arkansas | Woodruff | 5147 | 2055 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-08-28 04:21:02 | Woodruff, Arkansas, US | |
1535243 | 1535243 | 2022-08-26 | US | Virginia | Buena Vista | 51530 | 2055 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-08-27 04:20:57 | Buena Vista, Virginia, US | |
1099652 | 1099652 | 2022-08-03 | US | Louisiana | St. Helena | 22091 | 2055 | 25 | 0 | 30.82210324 | -90.71013176 | 2022-08-04 04:20:58 | St. Helena, Louisiana, US | |
673866 | 673866 | 2022-07-21 | US | Wisconsin | Menominee | 55078 | 2055 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-22 04:21:15 | Menominee, Wisconsin, US | |
1608784 | 1608784 | 2022-07-20 | US | Arkansas | Prairie | 5117 | 2055 | 43 | 0 | 34.83624419 | -91.55162157 | 2022-07-21 04:21:10 | Prairie, Arkansas, US | |
961284 | 961284 | 2022-07-19 | US | North Dakota | Benson | 38005 | 2055 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-07-20 04:20:59 | Benson, North Dakota, US | |
2789699 | 2789699 | 2022-07-10 | US | Colorado | Yuma | 8125 | 2055 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-07-11 04:20:46 | Yuma, Colorado, US | |
142652 | 142652 | 2022-07-09 | US | Colorado | Yuma | 8125 | 2055 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-07-10 04:20:54 | Yuma, Colorado, US | |
560750 | 560750 | 2022-06-16 | US | Missouri | Oregon | 29149 | 2055 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-17 04:20:56 | Oregon, Missouri, US | |
3984552 | 3984552 | 2022-06-15 | US | Missouri | Oregon | 29149 | 2055 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-16 04:20:55 | Oregon, Missouri, US | |
949269 | 949269 | 2022-06-14 | US | North Dakota | Pembina | 38067 | 2055 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-06-15 04:20:54 | Pembina, North Dakota, US | |
948793 | 948793 | 2022-06-14 | US | Missouri | Oregon | 29149 | 2055 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-15 04:20:54 | Oregon, Missouri, US | |
2981677 | 2981677 | 2022-06-13 | US | North Dakota | Pembina | 38067 | 2055 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-06-14 04:20:52 | Pembina, North Dakota, US | |
2981201 | 2981201 | 2022-06-13 | US | Missouri | Oregon | 29149 | 2055 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-14 04:20:52 | Oregon, Missouri, US | |
2237327 | 2237327 | 2022-06-12 | US | Missouri | Oregon | 29149 | 2055 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-13 04:21:14 | Oregon, Missouri, US | |
3143525 | 3143525 | 2022-06-11 | US | Missouri | Oregon | 29149 | 2055 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-12 04:20:53 | Oregon, Missouri, US | |
1946441 | 1946441 | 2022-06-10 | US | Missouri | Oregon | 29149 | 2055 | 37 | 0 | 36.68710164 | -91.4033755 | 2022-06-11 04:21:01 | Oregon, Missouri, US | |
3890934 | 3890934 | 2022-06-06 | US | Virginia | Buena Vista | 51530 | 2055 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-06-07 04:21:08 | Buena Vista, Virginia, US | |
3530414 | 3530414 | 2022-06-04 | US | Tennessee | Hancock | 47067 | 2055 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-05 04:20:55 | Hancock, Tennessee, US | |
3136500 | 3136500 | 2022-06-03 | US | Tennessee | Hancock | 47067 | 2055 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-04 04:20:58 | Hancock, Tennessee, US | |
3581575 | 3581575 | 2022-06-02 | US | Tennessee | Hancock | 47067 | 2055 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-03 04:20:58 | Hancock, Tennessee, US | |
973868 | 973868 | 2022-06-01 | US | Tennessee | Hancock | 47067 | 2055 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-02 05:20:39 | Hancock, Tennessee, US | |
232175 | 232175 | 2022-05-31 | US | Tennessee | Hancock | 47067 | 2055 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-06-01 04:20:55 | Hancock, Tennessee, US | |
232099 | 232099 | 2022-05-31 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-06-01 04:20:55 | Grant, South Dakota, US | |
3188864 | 3188864 | 2022-05-30 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-31 04:20:51 | Grant, South Dakota, US | |
3201013 | 3201013 | 2022-05-29 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-30 04:20:50 | Grant, South Dakota, US | |
2727891 | 2727891 | 2022-05-28 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-29 04:20:53 | Grant, South Dakota, US | |
1317072 | 1317072 | 2022-05-27 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-28 04:21:07 | Grant, South Dakota, US | |
1852864 | 1852864 | 2022-05-26 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-27 04:20:56 | Grant, South Dakota, US | |
2050740 | 2050740 | 2022-05-25 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-26 04:20:50 | Grant, South Dakota, US | |
624751 | 624751 | 2022-05-22 | US | South Dakota | Grant | 46051 | 2055 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-26 04:20:50 | Grant, South Dakota, US | |
2536732 | 2536732 | 2022-05-12 | US | Virginia | Fairfax City | 51600 | 2055 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-05-13 04:20:51 | Fairfax City, Virginia, US | |
2253414 | 2253414 | 2022-04-19 | US | Montana | Carbon | 30009 | 2055 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-04-20 04:20:45 | Carbon, Montana, US | |
1949725 | 1949725 | 2022-04-12 | US | Iowa | Keokuk | 19107 | 2055 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-13 04:21:03 | Keokuk, Iowa, US | |
3207478 | 3207478 | 2022-04-11 | US | Iowa | Keokuk | 19107 | 2055 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-12 04:20:49 | Keokuk, Iowa, US | |
1577364 | 1577364 | 2022-04-10 | US | Iowa | Keokuk | 19107 | 2055 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-11 04:21:02 | Keokuk, Iowa, US | |
1653606 | 1653606 | 2022-04-09 | US | Iowa | Keokuk | 19107 | 2055 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-10 04:20:52 | Keokuk, Iowa, US | |
2116928 | 2116928 | 2022-04-08 | US | Iowa | Keokuk | 19107 | 2055 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-09 04:20:42 | Keokuk, Iowa, US | |
3321452 | 3321452 | 2022-04-07 | US | Iowa | Keokuk | 19107 | 2055 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-08 04:20:48 | Keokuk, Iowa, US | |
2801988 | 2801988 | 2022-04-06 | US | Iowa | Keokuk | 19107 | 2055 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-07 04:20:53 | Keokuk, Iowa, US | |
1467915 | 1467915 | 2022-03-24 | China | Yunnan | 2055 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-25 04:20:46 | Yunnan, China | |||
2143680 | 2143680 | 2022-03-09 | US | West Virginia | Pleasants | 54073 | 2055 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-03-10 04:20:48 | Pleasants, West Virginia, US | |
2528736 | 2528736 | 2022-03-02 | US | Virginia | Madison | 51113 | 2055 | 36 | 0 | 38.41531222 | -78.28220331 | 2022-03-03 04:21:01 | Madison, Virginia, US | |
1060652 | 1060652 | 2022-02-23 | US | South Carolina | Allendale | 45005 | 2055 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-02-24 04:21:14 | Allendale, South Carolina, US | |
1060590 | 1060590 | 2022-02-23 | US | Puerto Rico | Florida | 72054 | 2055 | 0 | 0 | 18.373715 | -66.560488 | 2022-02-24 04:21:14 | Florida, Puerto Rico, US | |
2450253 | 2450253 | 2022-02-22 | US | West Virginia | Gilmer | 54021 | 2055 | 18 | 0 | 38.9251277 | -80.85952723 | 2022-02-23 04:21:09 | Gilmer, West Virginia, US | |
2449513 | 2449513 | 2022-02-22 | US | Puerto Rico | Florida | 72054 | 2055 | 0 | 0 | 18.373715 | -66.560488 | 2022-02-23 04:21:09 | Florida, Puerto Rico, US | |
3720926 | 3720926 | 2022-02-21 | US | Puerto Rico | Florida | 72054 | 2055 | 0 | 0 | 18.373715 | -66.560488 | 2022-02-22 04:21:01 | Florida, Puerto Rico, US | |
2643130 | 2643130 | 2022-02-14 | US | Kentucky | Bracken | 21023 | 2055 | 23 | 0 | 38.69158994 | -84.08532444 | 2022-02-15 04:21:09 | Bracken, Kentucky, US | |
187781 | 187781 | 2022-02-13 | US | Minnesota | Clearwater | 27029 | 2055 | 29 | 0 | 47.57992111 | -95.37790562 | 2022-02-14 04:20:51 | Clearwater, Minnesota, US | |
317627 | 317627 | 2022-02-12 | US | Minnesota | Clearwater | 27029 | 2055 | 29 | 0 | 47.57992111 | -95.37790562 | 2022-02-13 04:21:00 | Clearwater, Minnesota, US | |
234953 | 234953 | 2022-02-11 | US | Minnesota | Clearwater | 27029 | 2055 | 29 | 0 | 47.57992111 | -95.37790562 | 2022-02-12 04:21:06 | Clearwater, Minnesota, US | |
2477337 | 2477337 | 2022-02-03 | US | Virginia | Northampton | 51131 | 2055 | 52 | 0 | 37.34062933 | -75.87751591 | 2022-02-04 04:21:10 | Northampton, Virginia, US | |
2660925 | 2660925 | 2022-01-31 | US | Texas | Jim Hogg | 48247 | 2055 | 20 | 0 | 27.04453923 | -98.69681870000001 | 2022-02-01 04:21:11 | Jim Hogg, Texas, US | |
3809725 | 3809725 | 2022-01-28 | China | Heilongjiang | 2055 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-01-29 04:21:10 | Heilongjiang, China | |||
1963948 | 1963948 | 2022-01-20 | US | Virginia | Poquoson | 51735 | 2055 | 24 | 0 | 37.14259351 | -76.35798148 | 2022-01-21 04:21:09 | Poquoson, Virginia, US | |
3690898 | 3690898 | 2022-01-13 | US | Virginia | Sussex | 51183 | 2055 | 31 | 0 | 36.92432914 | -77.25791182 | 2022-01-14 04:21:54 | Sussex, Virginia, US | |
1115465 | 1115465 | 2022-01-11 | US | Missouri | Bollinger | 29017 | 2055 | 36 | 0 | 37.32449052 | -90.02725304 | 2022-01-12 04:21:44 | Bollinger, Missouri, US | |
1115321 | 1115321 | 2022-01-11 | US | Minnesota | Koochiching | 27071 | 2055 | 32 | 0 | 48.24539665 | -93.78352843 | 2022-01-12 04:21:44 | Koochiching, Minnesota, US | |
1283553 | 1283553 | 2022-01-05 | US | Maine | Piscataquis | 23021 | 2055 | 23 | 0 | 45.83839062 | -69.2860223 | 2022-01-06 04:22:09 | Piscataquis, Maine, US | |
1670517 | 1670517 | 2021-12-29 | US | Nebraska | Colfax | 31037 | 2055 | 21 | 0 | 41.57486951 | -97.0868542 | 2021-12-30 04:21:25 | Colfax, Nebraska, US | |
3817071 | 3817071 | 2021-12-23 | US | Colorado | Prowers | 8099 | 2055 | 45 | 0 | 37.95544985 | -102.3926052 | 2021-12-24 04:21:34 | Prowers, Colorado, US | |
798897 | 798897 | 2021-12-22 | US | Arkansas | Bradley | 5011 | 2055 | 42 | 0 | 33.46755808 | -92.15980837 | 2021-12-23 04:21:21 | Bradley, Arkansas, US | |
1079424 | 1079424 | 2021-12-09 | US | Louisiana | Claiborne | 22027 | 2055 | 66 | 0 | 32.82308512 | -92.99526883 | 2021-12-10 04:22:28 | Claiborne, Louisiana, US | |
1146887 | 1146887 | 2021-12-01 | US | Missouri | Ripley | 29181 | 2055 | 25 | 0 | 36.65460667 | -90.85990261 | 2021-12-02 04:22:37 | Ripley, Missouri, US | |
1233284 | 1233284 | 2021-11-28 | US | Michigan | Leelanau | 26089 | 2055 | 32 | 0 | 44.94430054 | -85.80150326 | 2021-11-29 04:22:30 | Leelanau, Michigan, US | |
1359991 | 1359991 | 2021-11-27 | US | Michigan | Leelanau | 26089 | 2055 | 32 | 0 | 44.94430054 | -85.80150326 | 2021-11-28 04:22:43 | Leelanau, Michigan, US | |
759982 | 759982 | 2021-11-26 | US | Michigan | Leelanau | 26089 | 2055 | 32 | 0 | 44.94430054 | -85.80150326 | 2021-11-27 04:22:45 | Leelanau, Michigan, US | |
1804399 | 1804399 | 2021-11-25 | US | Michigan | Leelanau | 26089 | 2055 | 32 | 0 | 44.94430054 | -85.80150326 | 2021-11-26 04:22:33 | Leelanau, Michigan, US | |
1804130 | 1804130 | 2021-11-25 | US | Kentucky | Carroll | 21041 | 2055 | 30 | 0 | 38.66599534 | -85.12601074 | 2021-11-26 04:22:33 | Carroll, Kentucky, US | |
905833 | 905833 | 2021-11-24 | US | Michigan | Leelanau | 26089 | 2055 | 32 | 0 | 44.94430054 | -85.80150326 | 2021-11-25 04:22:33 | Leelanau, Michigan, US | |
3072444 | 3072444 | 2021-11-23 | US | North Dakota | Mountrail | 38061 | 2055 | 29 | 0 | 48.20197971 | -102.3555315 | 2021-11-24 04:22:14 | Mountrail, North Dakota, US | |
3069783 | 3069783 | 2021-11-23 | Canada | Northwest Territories | 2055 | 12 | 0 | 64.8255 | -124.8457 | 2021-11-24 04:22:14 | Northwest Territories,Canada | |||
3752169 | 3752169 | 2021-11-22 | US | Texas | Camp | 48063 | 2055 | 67 | 0 | 32.97195142 | -94.97790104 | 2021-11-23 04:22:39 | Camp, Texas, US | |
1017376 | 1017376 | 2021-11-21 | US | Texas | Camp | 48063 | 2055 | 67 | 0 | 32.97195142 | -94.97790104 | 2021-11-22 04:22:20 | Camp, Texas, US | |
725540 | 725540 | 2021-11-20 | US | Texas | Camp | 48063 | 2055 | 67 | 0 | 32.97195142 | -94.97790104 | 2021-11-21 04:22:13 | Camp, Texas, US | |
89070 | 89070 | 2021-11-09 | US | Missouri | Pemiscot | 29155 | 2055 | 44 | 0 | 36.2130572 | -89.78742322 | 2021-11-10 04:21:38 | Pemiscot, Missouri, US | |
3641498 | 3641498 | 2021-11-08 | US | Missouri | Pemiscot | 29155 | 2055 | 44 | 0 | 36.2130572 | -89.78742322 | 2021-11-09 04:21:36 | Pemiscot, Missouri, US | |
2002606 | 2002606 | 2021-11-07 | US | Missouri | Pemiscot | 29155 | 2055 | 44 | 0 | 36.2130572 | -89.78742322 | 2021-11-08 04:21:43 | Pemiscot, Missouri, US | |
3123452 | 3123452 | 2021-11-05 | US | Missouri | Pemiscot | 29155 | 2055 | 44 | 0 | 36.2130572 | -89.78742322 | 2021-11-06 04:21:51 | Pemiscot, Missouri, 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]);