johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
308 rows where confirmed = 1890 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754871 | 2754871 | 2022-12-29 | US | Missouri | Shannon | 29203 | 1890 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-30 04:21:04 | Shannon, Missouri, US | |
1075877 | 1075877 | 2022-12-28 | US | Missouri | Shannon | 29203 | 1890 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-29 04:21:01 | Shannon, Missouri, US | |
1075694 | 1075694 | 2022-12-28 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-29 04:21:01 | Wilkin, Minnesota, US | |
329874 | 329874 | 2022-12-27 | US | Missouri | Shannon | 29203 | 1890 | 42 | 0 | 37.15772072 | -91.40190382 | 2022-12-28 04:21:04 | Shannon, Missouri, US | |
329691 | 329691 | 2022-12-27 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-28 04:21:04 | Wilkin, Minnesota, US | |
329144 | 329144 | 2022-12-27 | US | Iowa | Pocahontas | 19151 | 1890 | 29 | 0 | 42.73420133 | -94.67862564 | 2022-12-28 04:21:04 | Pocahontas, Iowa, US | |
219764 | 219764 | 2022-12-26 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-27 04:21:07 | Wilkin, Minnesota, US | |
219217 | 219217 | 2022-12-26 | US | Iowa | Pocahontas | 19151 | 1890 | 29 | 0 | 42.73420133 | -94.67862564 | 2022-12-27 04:21:07 | Pocahontas, Iowa, US | |
3224221 | 3224221 | 2022-12-25 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-26 04:21:06 | Wilkin, Minnesota, US | |
3223674 | 3223674 | 2022-12-25 | US | Iowa | Pocahontas | 19151 | 1890 | 29 | 0 | 42.73420133 | -94.67862564 | 2022-12-26 04:21:06 | Pocahontas, Iowa, US | |
1020135 | 1020135 | 2022-12-24 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-25 04:21:04 | Wilkin, Minnesota, US | |
1019588 | 1019588 | 2022-12-24 | US | Iowa | Pocahontas | 19151 | 1890 | 29 | 0 | 42.73420133 | -94.67862564 | 2022-12-25 04:21:04 | Pocahontas, Iowa, US | |
692158 | 692158 | 2022-12-23 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-24 04:21:02 | Wilkin, Minnesota, US | |
691611 | 691611 | 2022-12-23 | US | Iowa | Pocahontas | 19151 | 1890 | 29 | 0 | 42.73420133 | -94.67862564 | 2022-12-24 04:21:02 | Pocahontas, Iowa, US | |
2181368 | 2181368 | 2022-12-22 | US | Minnesota | Wilkin | 27167 | 1890 | 24 | 0 | 46.35721532 | -96.4684375 | 2022-12-23 04:21:04 | Wilkin, Minnesota, US | |
2180821 | 2180821 | 2022-12-22 | US | Iowa | Pocahontas | 19151 | 1890 | 29 | 0 | 42.73420133 | -94.67862564 | 2022-12-23 04:21:04 | Pocahontas, Iowa, US | |
452625 | 452625 | 2022-12-21 | US | Iowa | Pocahontas | 19151 | 1890 | 29 | 0 | 42.73420133 | -94.67862564 | 2022-12-22 04:20:56 | Pocahontas, Iowa, US | |
3714765 | 3714765 | 2022-12-06 | US | California | Trinity | 6105 | 1890 | 22 | 0 | 40.6491767 | -123.114713 | 2022-12-07 04:20:58 | Trinity, California, US | |
719095 | 719095 | 2022-12-04 | US | Colorado | Clear Creek | 8019 | 1890 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-05 04:20:58 | Clear Creek, Colorado, US | |
2817384 | 2817384 | 2022-12-03 | US | Colorado | Clear Creek | 8019 | 1890 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-04 04:20:56 | Clear Creek, Colorado, US | |
834240 | 834240 | 2022-12-02 | US | Colorado | Clear Creek | 8019 | 1890 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-03 04:21:02 | Clear Creek, Colorado, US | |
2136770 | 2136770 | 2022-12-01 | US | Colorado | Clear Creek | 8019 | 1890 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-02 04:21:07 | Clear Creek, Colorado, US | |
1965186 | 1965186 | 2022-11-30 | US | Colorado | Clear Creek | 8019 | 1890 | 13 | 0 | 39.68864463 | -105.6463118 | 2022-12-01 04:21:03 | Clear Creek, Colorado, US | |
1053217 | 1053217 | 2022-11-06 | US | Virginia | Mathews | 51115 | 1890 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-07 04:21:26 | Mathews, Virginia, US | |
621241 | 621241 | 2022-11-05 | US | Virginia | Mathews | 51115 | 1890 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-06 04:21:24 | Mathews, Virginia, US | |
1025745 | 1025745 | 2022-11-04 | US | Virginia | Mathews | 51115 | 1890 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-11-05 04:21:52 | Mathews, Virginia, US | |
2768765 | 2768765 | 2022-09-26 | China | Liaoning | 1890 | 2 | 0 | 41.2956 | 122.6085 | 2022-09-27 04:23:01 | Liaoning, China | |||
2636759 | 2636759 | 2022-09-05 | US | Texas | Brooks | 48047 | 1890 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-09-06 04:21:02 | Brooks, Texas, US | |
2990323 | 2990323 | 2022-09-04 | US | Texas | Brooks | 48047 | 1890 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-09-05 04:21:01 | Brooks, Texas, US | |
2716008 | 2716008 | 2022-09-03 | US | Texas | Brooks | 48047 | 1890 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-09-04 04:21:22 | Brooks, Texas, US | |
1396713 | 1396713 | 2022-09-02 | US | Texas | Brooks | 48047 | 1890 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-09-03 04:21:04 | Brooks, Texas, US | |
3550542 | 3550542 | 2022-09-01 | US | Texas | Brooks | 48047 | 1890 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-09-02 04:21:07 | Brooks, Texas, US | |
3951532 | 3951532 | 2022-08-17 | US | Illinois | Pulaski | 17153 | 1890 | 22 | 0 | 37.22631423 | -89.13085001 | 2022-08-18 04:21:11 | Pulaski, Illinois, US | |
992034 | 992034 | 2022-08-16 | US | Illinois | Pulaski | 17153 | 1890 | 22 | 0 | 37.22631423 | -89.13085001 | 2022-08-17 04:20:59 | Pulaski, Illinois, US | |
1406249 | 1406249 | 2022-08-02 | US | Iowa | Ida | 19093 | 1890 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-03 04:20:59 | Ida, Iowa, US | |
3618287 | 3618287 | 2022-08-01 | US | Iowa | Ida | 19093 | 1890 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-02 04:20:53 | Ida, Iowa, US | |
3872767 | 3872767 | 2022-07-31 | US | Iowa | Ida | 19093 | 1890 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-08-01 04:21:03 | Ida, Iowa, US | |
675521 | 675521 | 2022-07-30 | US | Iowa | Ida | 19093 | 1890 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-07-31 04:21:02 | Ida, Iowa, US | |
1784720 | 1784720 | 2022-07-29 | US | Iowa | Ida | 19093 | 1890 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-07-30 04:20:42 | Ida, Iowa, US | |
1067083 | 1067083 | 2022-07-28 | US | Iowa | Ida | 19093 | 1890 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-07-29 04:20:45 | Ida, Iowa, US | |
2336602 | 2336602 | 2022-07-27 | US | Iowa | Ida | 19093 | 1890 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-07-28 04:20:56 | Ida, Iowa, US | |
3112794 | 3112794 | 2022-07-13 | US | Virginia | Bland | 51021 | 1890 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-07-14 04:20:57 | Bland, Virginia, US | |
3112106 | 3112106 | 2022-07-13 | US | Oregon | Grant | 41023 | 1890 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-07-14 04:20:57 | Grant, Oregon, US | |
633116 | 633116 | 2022-07-12 | US | Texas | Refugio | 48391 | 1890 | 37 | 0 | 28.3238976 | -97.15766311 | 2022-07-13 04:20:58 | Refugio, Texas, US | |
2493197 | 2493197 | 2022-06-29 | US | Texas | Mitchell | 48335 | 1890 | 49 | 0 | 32.30623474 | -100.9212058 | 2022-06-30 04:21:01 | Mitchell, Texas, US | |
941822 | 941822 | 2022-06-25 | US | Tennessee | Van Buren | 47175 | 1890 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-06-26 04:21:02 | Van Buren, Tennessee, US | |
3161063 | 3161063 | 2022-06-09 | US | Virginia | Williamsburg | 51830 | 1890 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-06-10 04:20:55 | Williamsburg, Virginia, US | |
3160399 | 3160399 | 2022-06-09 | US | Puerto Rico | Maunabo | 72095 | 1890 | 0 | 0 | 18.017889 | -65.922235 | 2022-06-10 04:20:55 | Maunabo, Puerto Rico, US | |
3159545 | 3159545 | 2022-06-09 | US | Missouri | Harrison | 29081 | 1890 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-06-10 04:20:55 | Harrison, Missouri, US | |
1423012 | 1423012 | 2022-06-08 | US | Missouri | Harrison | 29081 | 1890 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-06-09 04:20:54 | Harrison, Missouri, US | |
3728126 | 3728126 | 2022-06-07 | US | Missouri | Harrison | 29081 | 1890 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-06-08 04:20:55 | Harrison, Missouri, US | |
3889528 | 3889528 | 2022-06-06 | US | Missouri | Harrison | 29081 | 1890 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-06-07 04:21:08 | Harrison, Missouri, US | |
3509297 | 3509297 | 2022-06-05 | US | Missouri | Harrison | 29081 | 1890 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-06-06 04:20:57 | Harrison, Missouri, US | |
3529374 | 3529374 | 2022-06-04 | US | Missouri | Harrison | 29081 | 1890 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-06-05 04:20:55 | Harrison, Missouri, US | |
3135460 | 3135460 | 2022-06-03 | US | Missouri | Harrison | 29081 | 1890 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-06-04 04:20:58 | Harrison, Missouri, US | |
3596404 | 3596404 | 2022-05-23 | US | Virginia | Middlesex | 51119 | 1890 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-05-24 04:20:57 | Middlesex, Virginia, US | |
1184594 | 1184594 | 2022-05-18 | Colombia | Vaupes | 1890 | 22 | 0 | 0.8554 | -70.812 | 2022-05-19 04:20:54 | Vaupes, Colombia | |||
3582491 | 3582491 | 2022-05-17 | Colombia | Vaupes | 1890 | 22 | 0 | 0.8554 | -70.812 | 2022-05-18 04:20:50 | Vaupes, Colombia | |||
1503448 | 1503448 | 2022-05-16 | Colombia | Vaupes | 1890 | 22 | 0 | 0.8554 | -70.812 | 2022-05-17 04:20:59 | Vaupes, Colombia | |||
2083807 | 2083807 | 2022-05-15 | Colombia | Vaupes | 1890 | 22 | 0 | 0.8554 | -70.812 | 2022-05-16 04:20:47 | Vaupes, Colombia | |||
3354518 | 3354518 | 2022-05-14 | Colombia | Vaupes | 1890 | 22 | 0 | 0.8554 | -70.812 | 2022-05-15 04:20:53 | Vaupes, Colombia | |||
658163 | 658163 | 2022-05-13 | Colombia | Vaupes | 1890 | 22 | 0 | 0.8554 | -70.812 | 2022-05-14 04:20:48 | Vaupes, Colombia | |||
2533246 | 2533246 | 2022-05-12 | Colombia | Vaupes | 1890 | 22 | 0 | 0.8554 | -70.812 | 2022-05-13 04:20:51 | Vaupes, Colombia | |||
2598681 | 2598681 | 2022-05-05 | US | Colorado | Lake | 8065 | 1890 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-05-06 04:21:00 | Lake, Colorado, US | |
2480292 | 2480292 | 2022-03-30 | US | North Carolina | Gates | 37073 | 1890 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-03-31 04:20:56 | Gates, North Carolina, US | |
160333 | 160333 | 2022-03-29 | US | North Carolina | Gates | 37073 | 1890 | 19 | 0 | 36.44667547 | -76.69749701 | 2022-03-30 04:20:45 | Gates, North Carolina, US | |
1865898 | 1865898 | 2022-03-10 | US | Alaska | Chugach | 2063 | 1890 | 9 | 0 | 61.16666 | -149.9 | 2022-03-11 04:20:50 | Chugach, Alaska, US | |
2140593 | 2140593 | 2022-03-09 | US | Alaska | Chugach | 2063 | 1890 | 9 | 0 | 61.16666 | -149.9 | 2022-03-10 04:20:48 | Chugach, Alaska, US | |
1551537 | 1551537 | 2022-03-07 | US | Wisconsin | Menominee | 55078 | 1890 | 13 | 0 | 45.00422544 | -88.70950714 | 2022-03-08 04:20:54 | Menominee, Wisconsin, US | |
316426 | 316426 | 2022-02-12 | US | Arkansas | Monroe | 5095 | 1890 | 28 | 0 | 34.6815935 | -91.20540287 | 2022-02-13 04:21:00 | Monroe, Arkansas, US | |
1467592 | 1467592 | 2022-02-10 | US | West Virginia | Pocahontas | 54075 | 1890 | 25 | 0 | 38.32758728 | -80.00993811 | 2022-02-11 04:21:09 | Pocahontas, West Virginia, US | |
3077662 | 3077662 | 2022-02-09 | US | Wyoming | Sublette | 56035 | 1890 | 26 | 0 | 42.76558279 | -109.91309220000001 | 2022-02-10 04:21:14 | Sublette, Wyoming, US | |
1365666 | 1365666 | 2022-02-08 | US | Virginia | Buena Vista | 51530 | 1890 | 38 | 0 | 37.73484642 | -79.35296097 | 2022-02-09 04:21:04 | Buena Vista, Virginia, US | |
2661161 | 2661161 | 2022-01-31 | US | Virginia | Madison | 51113 | 1890 | 28 | 0 | 38.41531222 | -78.28220331 | 2022-02-01 04:21:11 | Madison, Virginia, US | |
3063941 | 3063941 | 2022-01-29 | US | Missouri | Oregon | 29149 | 1890 | 27 | 0 | 36.68710164 | -91.4033755 | 2022-01-30 04:21:26 | Oregon, Missouri, US | |
1319591 | 1319591 | 2022-01-26 | US | Kentucky | Bracken | 21023 | 1890 | 22 | 0 | 38.69158994 | -84.08532444 | 2022-01-27 04:21:19 | Bracken, Kentucky, US | |
1142941 | 1142941 | 2022-01-23 | US | Montana | Sanders | 30089 | 1890 | 42 | 0 | 47.67657534 | -115.1329916 | 2022-01-24 04:21:12 | Sanders, Montana, US | |
2835880 | 2835880 | 2022-01-22 | US | Texas | Clay | 48077 | 1890 | 26 | 0 | 33.78686685 | -98.20771198 | 2022-01-23 04:21:13 | Clay, Texas, US | |
2834859 | 2834859 | 2022-01-22 | US | Montana | Sanders | 30089 | 1890 | 42 | 0 | 47.67657534 | -115.1329916 | 2022-01-23 04:21:13 | Sanders, Montana, US | |
3426977 | 3426977 | 2022-01-21 | US | Montana | Sanders | 30089 | 1890 | 42 | 0 | 47.67657534 | -115.1329916 | 2022-01-22 04:21:13 | Sanders, Montana, US | |
3465083 | 3465083 | 2022-01-18 | US | Georgia | Wilkinson | 13319 | 1890 | 48 | 0 | 32.80291082 | -83.17140684 | 2022-01-19 04:21:23 | Wilkinson, Georgia, US | |
1472936 | 1472936 | 2022-01-17 | US | Georgia | Heard | 13149 | 1890 | 43 | 0 | 33.29686567 | -85.12886832 | 2022-01-18 04:21:04 | Heard, Georgia, US | |
99961 | 99961 | 2022-01-14 | US | Colorado | Lincoln | 8073 | 1890 | 9 | 0 | 38.98749519 | -103.51366490000001 | 2022-01-15 04:21:07 | Lincoln, Colorado, US | |
1114114 | 1114114 | 2022-01-11 | US | Arkansas | Scott | 5127 | 1890 | 34 | 0 | 34.85588887 | -94.0632176 | 2022-01-12 04:21:44 | Scott, Arkansas, US | |
127570 | 127570 | 2022-01-09 | US | Georgia | Long | 13183 | 1890 | 29 | 0 | 31.75218791 | -81.74952375 | 2022-01-10 04:22:07 | Long, Georgia, US | |
1216405 | 1216405 | 2022-01-08 | US | Georgia | Long | 13183 | 1890 | 29 | 0 | 31.75218791 | -81.74952375 | 2022-01-09 04:21:46 | Long, Georgia, US | |
1390498 | 1390498 | 2022-01-07 | US | Georgia | Long | 13183 | 1890 | 29 | 0 | 31.75218791 | -81.74952375 | 2022-01-08 04:21:53 | Long, Georgia, US | |
2610885 | 2610885 | 2022-01-06 | US | Georgia | Long | 13183 | 1890 | 29 | 0 | 31.75218791 | -81.74952375 | 2022-01-07 04:22:09 | Long, Georgia, US | |
1282926 | 1282926 | 2022-01-05 | US | Idaho | Franklin | 16041 | 1890 | 27 | 0 | 42.18332217 | -111.81496659999999 | 2022-01-06 04:22:09 | Franklin, Idaho, US | |
1282827 | 1282827 | 2022-01-05 | US | Georgia | Long | 13183 | 1890 | 29 | 0 | 31.75218791 | -81.74952375 | 2022-01-06 04:22:09 | Long, Georgia, US | |
1702256 | 1702256 | 2022-01-03 | US | Missouri | Grundy | 29079 | 1890 | 58 | 0 | 40.11406587 | -93.56509276 | 2022-01-04 04:22:17 | Grundy, Missouri, US | |
3521339 | 3521339 | 2022-01-02 | US | Missouri | Grundy | 29079 | 1890 | 58 | 0 | 40.11406587 | -93.56509276 | 2022-01-03 02:22:25 | Grundy, Missouri, US | |
2169469 | 2169469 | 2022-01-01 | US | Missouri | Grundy | 29079 | 1890 | 58 | 0 | 40.11406587 | -93.56509276 | 2022-01-02 04:20:52 | Grundy, Missouri, US | |
2778900 | 2778900 | 2021-12-31 | US | Missouri | Grundy | 29079 | 1890 | 58 | 0 | 40.11406587 | -93.56509276 | 2022-01-01 04:22:14 | Grundy, Missouri, US | |
4000557 | 4000557 | 2021-12-30 | US | Missouri | Grundy | 29079 | 1890 | 58 | 0 | 40.11406587 | -93.56509276 | 2021-12-31 04:21:50 | Grundy, Missouri, US | |
1255135 | 1255135 | 2021-12-20 | US | Alabama | Coosa | 1037 | 1890 | 48 | 0 | 32.93690146 | -86.24847739 | 2021-12-21 03:21:27 | Coosa, Alabama, US | |
3499095 | 3499095 | 2021-12-15 | US | South Dakota | Todd | 46121 | 1890 | 40 | 0 | 43.19338568 | -100.71955030000001 | 2021-12-16 04:22:11 | Todd, South Dakota, US | |
1080211 | 1080211 | 2021-12-09 | US | North Carolina | Alleghany | 37005 | 1890 | 6 | 0 | 36.49360862 | -81.12857041 | 2021-12-10 04:22:28 | Alleghany, North Carolina, US | |
2198672 | 2198672 | 2021-12-03 | US | Texas | Childress | 48075 | 1890 | 22 | 0 | 34.529304100000004 | -100.2077916 | 2021-12-04 04:22:18 | Childress, Texas, US | |
3403446 | 3403446 | 2021-11-30 | US | Montana | Jefferson | 30043 | 1890 | 14 | 0 | 46.14907081 | -112.094396 | 2021-12-01 04:22:29 | Jefferson, Montana, 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]);