johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
345 rows where confirmed = 2225 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2418493 | 2418493 | 2022-12-05 | US | Wyoming | Platte | 56031 | 2225 | 43 | 0 | 42.13299116 | -104.966331 | 2022-12-06 04:21:03 | Platte, Wyoming, US | |
722101 | 722101 | 2022-12-04 | US | Wyoming | Platte | 56031 | 2225 | 43 | 0 | 42.13299116 | -104.966331 | 2022-12-05 04:20:58 | Platte, Wyoming, US | |
2820390 | 2820390 | 2022-12-03 | US | Wyoming | Platte | 56031 | 2225 | 43 | 0 | 42.13299116 | -104.966331 | 2022-12-04 04:20:56 | Platte, Wyoming, US | |
837246 | 837246 | 2022-12-02 | US | Wyoming | Platte | 56031 | 2225 | 43 | 0 | 42.13299116 | -104.966331 | 2022-12-03 04:21:02 | Platte, Wyoming, US | |
2139776 | 2139776 | 2022-12-01 | US | Wyoming | Platte | 56031 | 2225 | 43 | 0 | 42.13299116 | -104.966331 | 2022-12-02 04:21:07 | Platte, Wyoming, US | |
1968192 | 1968192 | 2022-11-30 | US | Wyoming | Platte | 56031 | 2225 | 43 | 0 | 42.13299116 | -104.966331 | 2022-12-01 04:21:03 | Platte, Wyoming, US | |
1966965 | 1966965 | 2022-11-30 | US | North Dakota | Benson | 38005 | 2225 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-12-01 04:21:03 | Benson, North Dakota, US | |
2560206 | 2560206 | 2022-11-29 | US | Wyoming | Platte | 56031 | 2225 | 43 | 0 | 42.13299116 | -104.966331 | 2022-11-30 04:21:07 | Platte, Wyoming, US | |
3463642 | 3463642 | 2022-11-21 | US | West Virginia | Calhoun | 54013 | 2225 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-11-22 04:20:47 | Calhoun, West Virginia, US | |
1643438 | 1643438 | 2022-11-20 | US | Texas | Floyd | 48153 | 2225 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-11-21 04:21:05 | Floyd, Texas, US | |
2066995 | 2066995 | 2022-11-19 | US | Texas | Floyd | 48153 | 2225 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-11-20 04:21:08 | Floyd, Texas, US | |
1758389 | 1758389 | 2022-11-18 | US | Texas | Floyd | 48153 | 2225 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-11-19 04:21:14 | Floyd, Texas, US | |
539266 | 539266 | 2022-10-26 | US | Arkansas | Monroe | 5095 | 2225 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-10-27 04:22:01 | Monroe, Arkansas, US | |
2272627 | 2272627 | 2022-10-20 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-21 04:22:23 | Glades, Florida, US | |
201835 | 201835 | 2022-10-19 | US | Wisconsin | Pepin | 55091 | 2225 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-10-20 04:22:59 | Pepin, Wisconsin, US | |
201768 | 201768 | 2022-10-19 | US | West Virginia | Pendleton | 54071 | 2225 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-20 04:22:59 | Pendleton, West Virginia, US | |
198962 | 198962 | 2022-10-19 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-20 04:22:59 | Glades, Florida, US | |
2760429 | 2760429 | 2022-10-18 | US | West Virginia | Pendleton | 54071 | 2225 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-19 04:22:26 | Pendleton, West Virginia, US | |
2757623 | 2757623 | 2022-10-18 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-19 04:22:26 | Glades, Florida, US | |
2025457 | 2025457 | 2022-10-17 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-18 04:22:42 | Glades, Florida, US | |
2160235 | 2160235 | 2022-10-16 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-17 04:20:31 | Glades, Florida, US | |
516432 | 516432 | 2022-10-15 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-16 04:22:39 | Glades, Florida, US | |
2033489 | 2033489 | 2022-10-14 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-15 04:22:00 | Glades, Florida, US | |
3754177 | 3754177 | 2022-10-13 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-14 04:22:28 | Glades, Florida, US | |
3215002 | 3215002 | 2022-10-12 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-13 04:22:39 | Glades, Florida, US | |
3250851 | 3250851 | 2022-10-11 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-12 04:22:51 | Glades, Florida, US | |
2968110 | 2968110 | 2022-10-10 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-11 04:23:05 | Glades, Florida, US | |
3098146 | 3098146 | 2022-10-09 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-10 04:22:32 | Glades, Florida, US | |
4003371 | 4003371 | 2022-10-08 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-09 04:21:16 | Glades, Florida, US | |
396968 | 396968 | 2022-10-07 | US | Florida | Glades | 12043 | 2225 | 37 | 0 | 26.95635849 | -81.18996211 | 2022-10-08 04:22:56 | Glades, Florida, US | |
2688119 | 2688119 | 2022-10-03 | US | North Dakota | Pembina | 38067 | 2225 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-10-04 04:22:55 | Pembina, North Dakota, US | |
3769397 | 3769397 | 2022-09-11 | US | West Virginia | Tucker | 54093 | 2225 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-09-12 04:20:58 | Tucker, West Virginia, US | |
3827972 | 3827972 | 2022-09-10 | US | West Virginia | Tucker | 54093 | 2225 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-09-11 04:20:50 | Tucker, West Virginia, US | |
966429 | 966429 | 2022-09-09 | US | West Virginia | Tucker | 54093 | 2225 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-09-10 04:21:10 | Tucker, West Virginia, US | |
2987809 | 2987809 | 2022-09-04 | US | Arkansas | Prairie | 5117 | 2225 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-09-05 04:21:01 | Prairie, Arkansas, US | |
2712783 | 2712783 | 2022-09-03 | China | Tianjin | 2225 | 3 | 0 | 39.3054 | 117.323 | 2022-09-04 04:21:22 | Tianjin, China | |||
3648736 | 3648736 | 2022-08-14 | US | Indiana | Warren | 18171 | 2225 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-08-15 04:20:59 | Warren, Indiana, US | |
1969742 | 1969742 | 2022-08-13 | US | Indiana | Warren | 18171 | 2225 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-08-14 04:20:55 | Warren, Indiana, US | |
2889551 | 2889551 | 2022-08-12 | US | Indiana | Warren | 18171 | 2225 | 30 | 0 | 40.34728141 | -87.35602659 | 2022-08-13 04:20:52 | Warren, Indiana, US | |
1089024 | 1089024 | 2022-08-09 | US | Tennessee | Hancock | 47067 | 2225 | 39 | 0 | 36.52692871 | -83.22375847 | 2022-08-10 04:20:57 | Hancock, Tennessee, US | |
1085890 | 1085890 | 2022-08-09 | China | Yunnan | 2225 | 2 | 0 | 24.974 | 101.487 | 2022-08-10 04:20:57 | Yunnan, China | |||
1408111 | 1408111 | 2022-08-02 | US | Texas | Dallam | 48111 | 2225 | 42 | 0 | 36.27787176 | -102.6020725 | 2022-08-03 04:20:59 | Dallam, Texas, US | |
3620149 | 3620149 | 2022-08-01 | US | Texas | Dallam | 48111 | 2225 | 42 | 0 | 36.27787176 | -102.6020725 | 2022-08-02 04:20:53 | Dallam, Texas, US | |
3874629 | 3874629 | 2022-07-31 | US | Texas | Dallam | 48111 | 2225 | 41 | 0 | 36.27787176 | -102.6020725 | 2022-08-01 04:21:03 | Dallam, Texas, US | |
3873769 | 3873769 | 2022-07-31 | US | New Mexico | Quay | 35037 | 2225 | 64 | 0 | 35.10403332 | -103.5481727 | 2022-08-01 04:21:03 | Quay, New Mexico, US | |
677383 | 677383 | 2022-07-30 | US | Texas | Dallam | 48111 | 2225 | 41 | 0 | 36.27787176 | -102.6020725 | 2022-07-31 04:21:02 | Dallam, Texas, US | |
676523 | 676523 | 2022-07-30 | US | New Mexico | Quay | 35037 | 2225 | 64 | 0 | 35.10403332 | -103.5481727 | 2022-07-31 04:21:02 | Quay, New Mexico, US | |
1786582 | 1786582 | 2022-07-29 | US | Texas | Dallam | 48111 | 2225 | 41 | 0 | 36.27787176 | -102.6020725 | 2022-07-30 04:20:42 | Dallam, Texas, US | |
1785722 | 1785722 | 2022-07-29 | US | New Mexico | Quay | 35037 | 2225 | 64 | 0 | 35.10403332 | -103.5481727 | 2022-07-30 04:20:42 | Quay, New Mexico, US | |
959769 | 959769 | 2022-07-19 | US | Georgia | Seminole | 13253 | 2225 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-07-20 04:20:59 | Seminole, Georgia, US | |
3211156 | 3211156 | 2022-07-18 | US | Georgia | Seminole | 13253 | 2225 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-07-19 04:20:58 | Seminole, Georgia, US | |
3406331 | 3406331 | 2022-07-17 | US | Georgia | Seminole | 13253 | 2225 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-07-18 04:20:59 | Seminole, Georgia, US | |
2152531 | 2152531 | 2022-07-16 | US | Georgia | Seminole | 13253 | 2225 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-07-17 04:21:15 | Seminole, Georgia, US | |
2419764 | 2419764 | 2022-07-15 | US | Georgia | Seminole | 13253 | 2225 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-07-16 04:21:05 | Seminole, Georgia, US | |
3430995 | 3430995 | 2022-07-14 | US | Montana | Sanders | 30089 | 2225 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-07-15 04:20:53 | Sanders, Montana, US | |
3429839 | 3429839 | 2022-07-14 | US | Georgia | Seminole | 13253 | 2225 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-07-15 04:20:53 | Seminole, Georgia, US | |
3111515 | 3111515 | 2022-07-13 | US | Montana | Sanders | 30089 | 2225 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-07-14 04:20:57 | Sanders, Montana, US | |
3110359 | 3110359 | 2022-07-13 | US | Georgia | Seminole | 13253 | 2225 | 30 | 0 | 30.93464824 | -84.86823924 | 2022-07-14 04:20:57 | Seminole, Georgia, US | |
631938 | 631938 | 2022-07-12 | US | Montana | Sanders | 30089 | 2225 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-07-13 04:20:58 | Sanders, Montana, US | |
630730 | 630730 | 2022-07-12 | US | Georgia | Heard | 13149 | 2225 | 56 | 0 | 33.29686567 | -85.12886832 | 2022-07-13 04:20:58 | Heard, Georgia, US | |
1213582 | 1213582 | 2022-07-11 | US | Montana | Sanders | 30089 | 2225 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-07-12 04:20:51 | Sanders, Montana, US | |
1212374 | 1212374 | 2022-07-11 | US | Georgia | Heard | 13149 | 2225 | 56 | 0 | 33.29686567 | -85.12886832 | 2022-07-12 04:20:51 | Heard, Georgia, US | |
2791064 | 2791064 | 2022-07-10 | US | Montana | Sanders | 30089 | 2225 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-07-11 04:20:46 | Sanders, Montana, US | |
2789856 | 2789856 | 2022-07-10 | US | Georgia | Heard | 13149 | 2225 | 56 | 0 | 33.29686567 | -85.12886832 | 2022-07-11 04:20:46 | Heard, Georgia, US | |
144017 | 144017 | 2022-07-09 | US | Montana | Sanders | 30089 | 2225 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-07-10 04:20:54 | Sanders, Montana, US | |
142809 | 142809 | 2022-07-09 | US | Georgia | Heard | 13149 | 2225 | 56 | 0 | 33.29686567 | -85.12886832 | 2022-07-10 04:20:54 | Heard, Georgia, US | |
1419117 | 1419117 | 2022-07-08 | US | Montana | Sanders | 30089 | 2225 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-07-09 04:20:59 | Sanders, Montana, US | |
1417909 | 1417909 | 2022-07-08 | US | Georgia | Heard | 13149 | 2225 | 56 | 0 | 33.29686567 | -85.12886832 | 2022-07-09 04:20:59 | Heard, Georgia, US | |
2742129 | 2742129 | 2022-07-07 | US | Indiana | Martin | 18101 | 2225 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-07-08 04:20:56 | Martin, Indiana, US | |
2741834 | 2741834 | 2022-07-07 | US | Georgia | Heard | 13149 | 2225 | 56 | 0 | 33.29686567 | -85.12886832 | 2022-07-08 04:20:56 | Heard, Georgia, US | |
1200924 | 1200924 | 2022-07-06 | US | Indiana | Martin | 18101 | 2225 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-07-07 04:20:55 | Martin, Indiana, US | |
1200629 | 1200629 | 2022-07-06 | US | Georgia | Heard | 13149 | 2225 | 56 | 0 | 33.29686567 | -85.12886832 | 2022-07-07 04:20:55 | Heard, Georgia, US | |
3079518 | 3079518 | 2022-07-04 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-07-05 04:20:45 | Nicholas, Kentucky, US | |
1768800 | 1768800 | 2022-07-03 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-07-04 04:20:54 | Nicholas, Kentucky, US | |
3366786 | 3366786 | 2022-07-02 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-07-03 04:20:59 | Nicholas, Kentucky, US | |
595115 | 595115 | 2022-07-01 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-07-02 04:21:16 | Nicholas, Kentucky, US | |
3943154 | 3943154 | 2022-06-30 | US | Texas | Gaines | 48165 | 2225 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-07-01 04:21:10 | Gaines, Texas, US | |
3941516 | 3941516 | 2022-06-30 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-07-01 04:21:10 | Nicholas, Kentucky, US | |
2493112 | 2493112 | 2022-06-29 | US | Texas | Gaines | 48165 | 2225 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-06-30 04:21:01 | Gaines, Texas, US | |
2491474 | 2491474 | 2022-06-29 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-06-30 04:21:01 | Nicholas, Kentucky, US | |
2240856 | 2240856 | 2022-06-28 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-06-29 04:20:59 | Nicholas, Kentucky, US | |
2149098 | 2149098 | 2022-06-27 | US | Kentucky | Nicholas | 21181 | 2225 | 32 | 0 | 38.33342292 | -84.01889177 | 2022-06-28 04:20:58 | Nicholas, Kentucky, US | |
3348724 | 3348724 | 2022-06-24 | US | Nebraska | Holt | 31089 | 2225 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-06-25 04:20:57 | Holt, Nebraska, US | |
1650465 | 1650465 | 2022-06-23 | US | Nebraska | Holt | 31089 | 2225 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-06-24 04:20:58 | Holt, Nebraska, US | |
2190048 | 2190048 | 2022-06-22 | US | North Dakota | Traill | 38097 | 2225 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-06-23 04:20:55 | Traill, North Dakota, US | |
2189700 | 2189700 | 2022-06-22 | US | Nebraska | Holt | 31089 | 2225 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-06-23 04:20:55 | Holt, Nebraska, US | |
168131 | 168131 | 2022-06-21 | US | Nebraska | Holt | 31089 | 2225 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-06-22 04:20:54 | Holt, Nebraska, US | |
1765414 | 1765414 | 2022-06-20 | US | Nebraska | Holt | 31089 | 2225 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-06-21 04:20:56 | Holt, Nebraska, US | |
1422838 | 1422838 | 2022-06-08 | US | Minnesota | Lake | 27075 | 2225 | 29 | 0 | 47.64270764 | -91.44557998 | 2022-06-09 04:20:54 | Lake, Minnesota, US | |
3727445 | 3727445 | 2022-06-07 | US | Iowa | Montgomery | 19137 | 2225 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-08 04:20:55 | Montgomery, Iowa, US | |
3888847 | 3888847 | 2022-06-06 | US | Iowa | Montgomery | 19137 | 2225 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-07 04:21:08 | Montgomery, Iowa, US | |
3508616 | 3508616 | 2022-06-05 | US | Iowa | Montgomery | 19137 | 2225 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-06 04:20:57 | Montgomery, Iowa, US | |
3528693 | 3528693 | 2022-06-04 | US | Iowa | Montgomery | 19137 | 2225 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-05 04:20:55 | Montgomery, Iowa, US | |
3134779 | 3134779 | 2022-06-03 | US | Iowa | Montgomery | 19137 | 2225 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-04 04:20:58 | Montgomery, Iowa, US | |
3579854 | 3579854 | 2022-06-02 | US | Iowa | Montgomery | 19137 | 2225 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-03 04:20:58 | Montgomery, Iowa, US | |
972147 | 972147 | 2022-06-01 | US | Iowa | Montgomery | 19137 | 2225 | 55 | 0 | 41.03018714 | -95.15642896 | 2022-06-02 05:20:39 | Montgomery, Iowa, US | |
1853375 | 1853375 | 2022-05-26 | US | Virginia | Northampton | 51131 | 2225 | 64 | 0 | 37.34062933 | -75.87751591 | 2022-05-27 04:20:56 | Northampton, Virginia, US | |
2050884 | 2050884 | 2022-05-25 | US | Texas | Archer | 48009 | 2225 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-05-26 04:20:50 | Archer, Texas, US | |
2047666 | 2047666 | 2022-05-25 | China | Jiangsu | 2225 | 0 | 0 | 32.9711 | 119.455 | 2022-05-26 04:20:50 | Jiangsu, China | |||
3002322 | 3002322 | 2022-05-24 | US | Texas | Archer | 48009 | 2225 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-05-25 04:20:56 | Archer, Texas, 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]);