johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
360 rows where confirmed = 2352 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330977 | 330977 | 2022-12-27 | US | Texas | Dallam | 48111 | 2352 | 44 | 0 | 36.27787176 | -102.6020725 | 2022-12-28 04:21:04 | Dallam, Texas, US | |
221050 | 221050 | 2022-12-26 | US | Texas | Dallam | 48111 | 2352 | 44 | 0 | 36.27787176 | -102.6020725 | 2022-12-27 04:21:07 | Dallam, Texas, US | |
3225507 | 3225507 | 2022-12-25 | US | Texas | Dallam | 48111 | 2352 | 44 | 0 | 36.27787176 | -102.6020725 | 2022-12-26 04:21:06 | Dallam, Texas, US | |
1021421 | 1021421 | 2022-12-24 | US | Texas | Dallam | 48111 | 2352 | 44 | 0 | 36.27787176 | -102.6020725 | 2022-12-25 04:21:04 | Dallam, Texas, US | |
693444 | 693444 | 2022-12-23 | US | Texas | Dallam | 48111 | 2352 | 44 | 0 | 36.27787176 | -102.6020725 | 2022-12-24 04:21:02 | Dallam, Texas, US | |
2182654 | 2182654 | 2022-12-22 | US | Texas | Dallam | 48111 | 2352 | 44 | 0 | 36.27787176 | -102.6020725 | 2022-12-23 04:21:04 | Dallam, Texas, US | |
454458 | 454458 | 2022-12-21 | US | Texas | Dallam | 48111 | 2352 | 44 | 0 | 36.27787176 | -102.6020725 | 2022-12-22 04:20:56 | Dallam, Texas, US | |
308409 | 308409 | 2022-12-13 | US | Arkansas | Prairie | 5117 | 2352 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-14 04:21:04 | Prairie, Arkansas, US | |
2418255 | 2418255 | 2022-12-05 | US | Virginia | Middlesex | 51119 | 2352 | 52 | 0 | 37.63191998 | -76.55064617 | 2022-12-06 04:21:03 | Middlesex, Virginia, US | |
480532 | 480532 | 2022-11-08 | US | Idaho | Fremont | 16043 | 2352 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-09 04:21:22 | Fremont, Idaho, US | |
2441547 | 2441547 | 2022-11-07 | US | South Carolina | Allendale | 45005 | 2352 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-11-08 04:21:21 | Allendale, South Carolina, US | |
2439682 | 2439682 | 2022-11-07 | US | Idaho | Fremont | 16043 | 2352 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-08 04:21:21 | Fremont, Idaho, US | |
1052645 | 1052645 | 2022-11-06 | US | South Carolina | Allendale | 45005 | 2352 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-11-07 04:21:26 | Allendale, South Carolina, US | |
1050780 | 1050780 | 2022-11-06 | US | Idaho | Fremont | 16043 | 2352 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-07 04:21:26 | Fremont, Idaho, US | |
620669 | 620669 | 2022-11-05 | US | South Carolina | Allendale | 45005 | 2352 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-11-06 04:21:24 | Allendale, South Carolina, US | |
618804 | 618804 | 2022-11-05 | US | Idaho | Fremont | 16043 | 2352 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-06 04:21:24 | Fremont, Idaho, US | |
1025173 | 1025173 | 2022-11-04 | US | South Carolina | Allendale | 45005 | 2352 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-11-05 04:21:52 | Allendale, South Carolina, US | |
1023308 | 1023308 | 2022-11-04 | US | Idaho | Fremont | 16043 | 2352 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-05 04:21:52 | Fremont, Idaho, US | |
434164 | 434164 | 2022-11-03 | US | South Carolina | Allendale | 45005 | 2352 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-11-04 04:22:11 | Allendale, South Carolina, US | |
432299 | 432299 | 2022-11-03 | US | Idaho | Fremont | 16043 | 2352 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-04 04:22:11 | Fremont, Idaho, US | |
852406 | 852406 | 2022-11-02 | US | South Carolina | Allendale | 45005 | 2352 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-11-03 04:22:05 | Allendale, South Carolina, US | |
850541 | 850541 | 2022-11-02 | US | Idaho | Fremont | 16043 | 2352 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-11-03 04:22:05 | Fremont, Idaho, US | |
713257 | 713257 | 2022-11-01 | US | South Carolina | Allendale | 45005 | 2352 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-11-02 04:22:09 | Allendale, South Carolina, US | |
2262861 | 2262861 | 2022-10-02 | US | Texas | Gaines | 48165 | 2352 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-10-03 04:23:11 | Gaines, Texas, US | |
2998387 | 2998387 | 2022-10-01 | US | Texas | Gaines | 48165 | 2352 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-10-02 04:21:23 | Gaines, Texas, US | |
856713 | 856713 | 2022-09-30 | US | Texas | Gaines | 48165 | 2352 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-10-01 04:23:01 | Gaines, Texas, US | |
2378639 | 2378639 | 2022-09-29 | US | Texas | Gaines | 48165 | 2352 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-09-30 04:23:09 | Gaines, Texas, US | |
1563190 | 1563190 | 2022-09-28 | US | Texas | Gaines | 48165 | 2352 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-09-29 04:22:34 | Gaines, Texas, US | |
3997733 | 3997733 | 2022-09-27 | US | Texas | Gaines | 48165 | 2352 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-09-28 04:23:01 | Gaines, Texas, US | |
2772061 | 2772061 | 2022-09-26 | US | Texas | Gaines | 48165 | 2352 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-09-27 04:23:01 | Gaines, Texas, US | |
2016538 | 2016538 | 2022-09-20 | China | Yunnan | 2352 | 2 | 0 | 24.974 | 101.487 | 2022-09-21 04:23:22 | Yunnan, China | |||
3549494 | 3549494 | 2022-09-01 | US | Montana | Blaine | 30005 | 2352 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-02 04:21:07 | Blaine, Montana, US | |
2345414 | 2345414 | 2022-08-31 | US | Montana | Blaine | 30005 | 2352 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-09-01 04:21:03 | Blaine, Montana, US | |
3775894 | 3775894 | 2022-08-30 | US | Montana | Blaine | 30005 | 2352 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-08-31 04:20:57 | Blaine, Montana, US | |
3773705 | 3773705 | 2022-08-30 | China | Jiangsu | 2352 | 0 | 0 | 32.9711 | 119.455 | 2022-08-31 04:20:57 | Jiangsu, China | |||
1682490 | 1682490 | 2022-08-29 | US | Montana | Blaine | 30005 | 2352 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-08-30 04:21:03 | Blaine, Montana, US | |
1878974 | 1878974 | 2022-08-28 | US | Montana | Blaine | 30005 | 2352 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-08-29 04:21:06 | Blaine, Montana, US | |
2098101 | 2098101 | 2022-08-27 | US | Montana | Blaine | 30005 | 2352 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-08-28 04:21:02 | Blaine, Montana, US | |
1533916 | 1533916 | 2022-08-26 | US | Montana | Blaine | 30005 | 2352 | 33 | 0 | 48.43175214 | -108.9582723 | 2022-08-27 04:20:57 | Blaine, Montana, US | |
3952021 | 3952021 | 2022-08-17 | US | Louisiana | Red River | 22081 | 2352 | 54 | 0 | 32.09530039 | -93.34213308 | 2022-08-18 04:21:11 | Red River, Louisiana, US | |
3649061 | 3649061 | 2022-08-14 | US | Kentucky | Trimble | 21223 | 2352 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-15 04:20:59 | Trimble, Kentucky, US | |
1970067 | 1970067 | 2022-08-13 | US | Kentucky | Trimble | 21223 | 2352 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-14 04:20:55 | Trimble, Kentucky, US | |
2889876 | 2889876 | 2022-08-12 | US | Kentucky | Trimble | 21223 | 2352 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-13 04:20:52 | Trimble, Kentucky, US | |
3909481 | 3909481 | 2022-08-11 | US | Kentucky | Trimble | 21223 | 2352 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-12 04:20:54 | Trimble, Kentucky, US | |
1347798 | 1347798 | 2022-08-10 | US | Kentucky | Trimble | 21223 | 2352 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-11 04:20:49 | Trimble, Kentucky, US | |
1087553 | 1087553 | 2022-08-09 | US | Kentucky | Trimble | 21223 | 2352 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-10 04:20:57 | Trimble, Kentucky, US | |
3544968 | 3544968 | 2022-08-08 | US | Kentucky | Trimble | 21223 | 2352 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-09 04:20:34 | Trimble, Kentucky, US | |
3872966 | 3872966 | 2022-07-31 | US | Kentucky | Gallatin | 21077 | 2352 | 52 | 0 | 38.75398691 | -84.8558382 | 2022-08-01 04:21:03 | Gallatin, Kentucky, US | |
675720 | 675720 | 2022-07-30 | US | Kentucky | Gallatin | 21077 | 2352 | 52 | 0 | 38.75398691 | -84.8558382 | 2022-07-31 04:21:02 | Gallatin, Kentucky, US | |
1784919 | 1784919 | 2022-07-29 | US | Kentucky | Gallatin | 21077 | 2352 | 52 | 0 | 38.75398691 | -84.8558382 | 2022-07-30 04:20:42 | Gallatin, Kentucky, US | |
1067282 | 1067282 | 2022-07-28 | US | Kentucky | Gallatin | 21077 | 2352 | 52 | 0 | 38.75398691 | -84.8558382 | 2022-07-29 04:20:45 | Gallatin, Kentucky, US | |
2336801 | 2336801 | 2022-07-27 | US | Kentucky | Gallatin | 21077 | 2352 | 52 | 0 | 38.75398691 | -84.8558382 | 2022-07-28 04:20:56 | Gallatin, Kentucky, US | |
1488991 | 1488991 | 2022-07-26 | US | Kentucky | Gallatin | 21077 | 2352 | 52 | 0 | 38.75398691 | -84.8558382 | 2022-07-27 04:21:04 | Gallatin, Kentucky, US | |
2595437 | 2595437 | 2022-07-25 | US | Kentucky | Gallatin | 21077 | 2352 | 52 | 0 | 38.75398691 | -84.8558382 | 2022-07-26 04:20:58 | Gallatin, Kentucky, US | |
2152170 | 2152170 | 2022-07-16 | US | Arkansas | Nevada | 5099 | 2352 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-07-17 04:21:15 | Nevada, Arkansas, US | |
3969479 | 3969479 | 2022-07-05 | US | Tennessee | Clay | 47027 | 2352 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-07-06 04:20:58 | Clay, Tennessee, US | |
3943265 | 3943265 | 2022-06-30 | US | Texas | Red River | 48387 | 2352 | 67 | 0 | 33.61886692 | -95.04841765 | 2022-07-01 04:21:10 | Red River, Texas, US | |
2149724 | 2149724 | 2022-06-27 | US | Nebraska | Hamilton | 31081 | 2352 | 25 | 0 | 40.87349452 | -98.02099117 | 2022-06-28 04:20:58 | Hamilton, Nebraska, US | |
477525 | 477525 | 2022-06-26 | US | Nebraska | Hamilton | 31081 | 2352 | 25 | 0 | 40.87349452 | -98.02099117 | 2022-06-27 04:21:00 | Hamilton, Nebraska, US | |
940900 | 940900 | 2022-06-25 | US | Nebraska | Hamilton | 31081 | 2352 | 25 | 0 | 40.87349452 | -98.02099117 | 2022-06-26 04:21:02 | Hamilton, Nebraska, US | |
2236318 | 2236318 | 2022-06-12 | US | Idaho | Clearwater | 16035 | 2352 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-13 04:21:14 | Clearwater, Idaho, US | |
3142516 | 3142516 | 2022-06-11 | US | Idaho | Clearwater | 16035 | 2352 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-12 04:20:53 | Clearwater, Idaho, US | |
1945432 | 1945432 | 2022-06-10 | US | Idaho | Clearwater | 16035 | 2352 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-06-11 04:21:01 | Clearwater, Idaho, US | |
3887429 | 3887429 | 2022-06-06 | China | Sichuan | 2352 | 3 | 0 | 30.6171 | 102.7103 | 2022-06-07 04:21:08 | Sichuan, China | |||
232210 | 232210 | 2022-05-31 | US | Tennessee | Perry | 47135 | 2352 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-06-01 04:20:55 | Perry, Tennessee, US | |
1187353 | 1187353 | 2022-05-18 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-19 04:20:54 | Woods, Oklahoma, US | |
3585250 | 3585250 | 2022-05-17 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-18 04:20:50 | Woods, Oklahoma, US | |
1506207 | 1506207 | 2022-05-16 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-17 04:20:59 | Woods, Oklahoma, US | |
2086566 | 2086566 | 2022-05-15 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-16 04:20:47 | Woods, Oklahoma, US | |
3357276 | 3357276 | 2022-05-14 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-15 04:20:53 | Woods, Oklahoma, US | |
660921 | 660921 | 2022-05-13 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-14 04:20:48 | Woods, Oklahoma, US | |
2536004 | 2536004 | 2022-05-12 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-13 04:20:51 | Woods, Oklahoma, US | |
3447450 | 3447450 | 2022-05-11 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-12 04:20:54 | Woods, Oklahoma, US | |
3538067 | 3538067 | 2022-05-10 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-11 04:20:48 | Woods, Oklahoma, US | |
3537508 | 3537508 | 2022-05-10 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-11 04:20:48 | Box Butte, Nebraska, US | |
224602 | 224602 | 2022-05-09 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-10 04:20:50 | Woods, Oklahoma, US | |
224043 | 224043 | 2022-05-09 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-10 04:20:50 | Box Butte, Nebraska, US | |
2333987 | 2333987 | 2022-05-08 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-09 04:20:54 | Woods, Oklahoma, US | |
2333428 | 2333428 | 2022-05-08 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-09 04:20:54 | Box Butte, Nebraska, US | |
362949 | 362949 | 2022-05-07 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-08 04:20:49 | Woods, Oklahoma, US | |
362390 | 362390 | 2022-05-07 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-08 04:20:49 | Box Butte, Nebraska, US | |
1400437 | 1400437 | 2022-05-06 | US | Puerto Rico | Guayanilla | 72059 | 2352 | 0 | 0 | 18.039942 | -66.79186 | 2022-05-07 04:21:09 | Guayanilla, Puerto Rico, US | |
1400300 | 1400300 | 2022-05-06 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-07 04:21:09 | Woods, Oklahoma, US | |
1399741 | 1399741 | 2022-05-06 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-07 04:21:09 | Box Butte, Nebraska, US | |
2600655 | 2600655 | 2022-05-05 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-06 04:21:00 | Woods, Oklahoma, US | |
2600096 | 2600096 | 2022-05-05 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-06 04:21:00 | Box Butte, Nebraska, US | |
3268104 | 3268104 | 2022-05-04 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-05 04:20:55 | Woods, Oklahoma, US | |
3267545 | 3267545 | 2022-05-04 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-05 04:20:55 | Box Butte, Nebraska, US | |
1574743 | 1574743 | 2022-05-03 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-04 04:20:59 | Woods, Oklahoma, US | |
1574184 | 1574184 | 2022-05-03 | US | Nebraska | Box Butte | 31013 | 2352 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-05-04 04:20:59 | Box Butte, Nebraska, US | |
466003 | 466003 | 2022-05-02 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-03 04:21:00 | Woods, Oklahoma, US | |
3918642 | 3918642 | 2022-05-01 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-02 04:21:10 | Woods, Oklahoma, US | |
2843446 | 2843446 | 2022-04-30 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-05-01 04:20:57 | Woods, Oklahoma, US | |
1159759 | 1159759 | 2022-04-29 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-04-30 04:21:05 | Woods, Oklahoma, US | |
1159262 | 1159262 | 2022-04-29 | US | Nebraska | Phelps | 31137 | 2352 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-04-30 04:21:05 | Phelps, Nebraska, US | |
1698941 | 1698941 | 2022-04-28 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-04-29 04:20:59 | Woods, Oklahoma, US | |
1698444 | 1698444 | 2022-04-28 | US | Nebraska | Phelps | 31137 | 2352 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-04-29 04:20:59 | Phelps, Nebraska, US | |
3854424 | 3854424 | 2022-04-27 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-04-28 04:20:47 | Woods, Oklahoma, US | |
3853927 | 3853927 | 2022-04-27 | US | Nebraska | Phelps | 31137 | 2352 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-04-28 04:20:47 | Phelps, Nebraska, US | |
1328854 | 1328854 | 2022-04-26 | US | Oklahoma | Woods | 40151 | 2352 | 38 | 0 | 36.76705782 | -98.86573064 | 2022-04-27 04:20:52 | Woods, Oklahoma, 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]);