johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
360 rows where confirmed = 2333 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330059 | 330059 | 2022-12-27 | US | Nevada | Pershing | 32027 | 2333 | 32 | 0 | 40.44003782 | -118.4005641 | 2022-12-28 04:21:04 | Pershing, Nevada, US | |
220132 | 220132 | 2022-12-26 | US | Nevada | Pershing | 32027 | 2333 | 32 | 0 | 40.44003782 | -118.4005641 | 2022-12-27 04:21:07 | Pershing, Nevada, US | |
3224589 | 3224589 | 2022-12-25 | US | Nevada | Pershing | 32027 | 2333 | 32 | 0 | 40.44003782 | -118.4005641 | 2022-12-26 04:21:06 | Pershing, Nevada, US | |
1020503 | 1020503 | 2022-12-24 | US | Nevada | Pershing | 32027 | 2333 | 32 | 0 | 40.44003782 | -118.4005641 | 2022-12-25 04:21:04 | Pershing, Nevada, US | |
692526 | 692526 | 2022-12-23 | US | Nevada | Pershing | 32027 | 2333 | 32 | 0 | 40.44003782 | -118.4005641 | 2022-12-24 04:21:02 | Pershing, Nevada, US | |
2181736 | 2181736 | 2022-12-22 | US | Nevada | Pershing | 32027 | 2333 | 32 | 0 | 40.44003782 | -118.4005641 | 2022-12-23 04:21:04 | Pershing, Nevada, US | |
454908 | 454908 | 2022-12-21 | US | West Virginia | Tucker | 54093 | 2333 | 39 | 0 | 39.11240885 | -79.57053576 | 2022-12-22 04:20:56 | Tucker, West Virginia, US | |
453540 | 453540 | 2022-12-21 | US | Nevada | Pershing | 32027 | 2333 | 32 | 0 | 40.44003782 | -118.4005641 | 2022-12-22 04:20:56 | Pershing, Nevada, US | |
2954907 | 2954907 | 2022-12-20 | US | West Virginia | Tucker | 54093 | 2333 | 39 | 0 | 39.11240885 | -79.57053576 | 2022-12-21 04:21:03 | Tucker, West Virginia, US | |
1150857 | 1150857 | 2022-12-12 | US | Missouri | Harrison | 29081 | 2333 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-12-13 04:21:01 | Harrison, Missouri, US | |
870711 | 870711 | 2022-12-11 | US | Missouri | Harrison | 29081 | 2333 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-12-12 04:21:01 | Harrison, Missouri, US | |
259241 | 259241 | 2022-12-10 | US | Missouri | Harrison | 29081 | 2333 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-12-11 04:20:50 | Harrison, Missouri, US | |
3937955 | 3937955 | 2022-12-09 | US | Missouri | Harrison | 29081 | 2333 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-12-10 04:21:02 | Harrison, Missouri, US | |
3379287 | 3379287 | 2022-12-08 | US | Missouri | Harrison | 29081 | 2333 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-12-09 04:21:05 | Harrison, Missouri, US | |
1986558 | 1986558 | 2022-12-07 | US | Missouri | Harrison | 29081 | 2333 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-12-08 04:21:07 | Harrison, Missouri, US | |
1985171 | 1985171 | 2022-12-07 | US | Arkansas | Prairie | 5117 | 2333 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-08 04:21:07 | Prairie, Arkansas, US | |
3716081 | 3716081 | 2022-12-06 | US | Missouri | Harrison | 29081 | 2333 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-12-07 04:20:58 | Harrison, Missouri, US | |
3714694 | 3714694 | 2022-12-06 | US | Arkansas | Prairie | 5117 | 2333 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-12-07 04:20:58 | Prairie, Arkansas, US | |
2440687 | 2440687 | 2022-11-07 | US | Missouri | Oregon | 29149 | 2333 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-08 04:21:21 | Oregon, Missouri, US | |
1051785 | 1051785 | 2022-11-06 | US | Missouri | Oregon | 29149 | 2333 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-07 04:21:26 | Oregon, Missouri, US | |
619809 | 619809 | 2022-11-05 | US | Missouri | Oregon | 29149 | 2333 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-06 04:21:24 | Oregon, Missouri, US | |
1024313 | 1024313 | 2022-11-04 | US | Missouri | Oregon | 29149 | 2333 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-05 04:21:52 | Oregon, Missouri, US | |
433304 | 433304 | 2022-11-03 | US | Missouri | Oregon | 29149 | 2333 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-04 04:22:11 | Oregon, Missouri, US | |
851546 | 851546 | 2022-11-02 | US | Missouri | Oregon | 29149 | 2333 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-03 04:22:05 | Oregon, Missouri, US | |
712397 | 712397 | 2022-11-01 | US | Missouri | Oregon | 29149 | 2333 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-02 04:22:09 | Oregon, Missouri, US | |
1833317 | 1833317 | 2022-10-25 | US | Texas | Live Oak | 48297 | 2333 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-10-26 04:22:19 | Live Oak, Texas, US | |
1831442 | 1831442 | 2022-10-25 | US | Kansas | Ellsworth | 20053 | 2333 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-10-26 04:22:19 | Ellsworth, Kansas, US | |
797578 | 797578 | 2022-10-24 | US | Texas | Live Oak | 48297 | 2333 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-10-25 04:21:53 | Live Oak, Texas, US | |
795703 | 795703 | 2022-10-24 | US | Kansas | Ellsworth | 20053 | 2333 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-10-25 04:21:53 | Ellsworth, Kansas, US | |
3280033 | 3280033 | 2022-10-23 | US | Texas | Live Oak | 48297 | 2333 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-10-24 04:22:29 | Live Oak, Texas, US | |
3278158 | 3278158 | 2022-10-23 | US | Kansas | Ellsworth | 20053 | 2333 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-10-24 04:22:29 | Ellsworth, Kansas, US | |
2271071 | 2271071 | 2022-10-22 | US | Texas | Live Oak | 48297 | 2333 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-10-23 04:22:46 | Live Oak, Texas, US | |
2269196 | 2269196 | 2022-10-22 | US | Kansas | Ellsworth | 20053 | 2333 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-10-23 04:22:46 | Ellsworth, Kansas, US | |
1595371 | 1595371 | 2022-10-21 | US | Texas | Live Oak | 48297 | 2333 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-10-22 04:22:53 | Live Oak, Texas, US | |
1593496 | 1593496 | 2022-10-21 | US | Kansas | Ellsworth | 20053 | 2333 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-10-22 04:22:53 | Ellsworth, Kansas, US | |
2273212 | 2273212 | 2022-10-20 | US | Kansas | Ellsworth | 20053 | 2333 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-10-21 04:22:23 | Ellsworth, Kansas, US | |
199547 | 199547 | 2022-10-19 | US | Kansas | Ellsworth | 20053 | 2333 | 33 | 0 | 38.69677695 | -98.20462799 | 2022-10-20 04:22:59 | Ellsworth, Kansas, US | |
2260705 | 2260705 | 2022-10-02 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-03 04:23:11 | Fremont, Idaho, US | |
2996231 | 2996231 | 2022-10-01 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-02 04:21:23 | Fremont, Idaho, US | |
854557 | 854557 | 2022-09-30 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-10-01 04:23:01 | Fremont, Idaho, US | |
2376483 | 2376483 | 2022-09-29 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-30 04:23:09 | Fremont, Idaho, US | |
1561034 | 1561034 | 2022-09-28 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-29 04:22:34 | Fremont, Idaho, US | |
3995577 | 3995577 | 2022-09-27 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-28 04:23:01 | Fremont, Idaho, US | |
2771401 | 2771401 | 2022-09-26 | US | North Dakota | Traill | 38097 | 2333 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-09-27 04:23:01 | Traill, North Dakota, US | |
2769905 | 2769905 | 2022-09-26 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-27 04:23:01 | Fremont, Idaho, US | |
1977558 | 1977558 | 2022-09-25 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-26 04:20:52 | Fremont, Idaho, US | |
2650725 | 2650725 | 2022-09-24 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-25 04:23:31 | Fremont, Idaho, US | |
385165 | 385165 | 2022-09-23 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-24 04:21:40 | Fremont, Idaho, US | |
1625231 | 1625231 | 2022-09-22 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-23 04:23:13 | Fremont, Idaho, US | |
1371435 | 1371435 | 2022-09-21 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-22 04:22:56 | Fremont, Idaho, US | |
2018941 | 2018941 | 2022-09-20 | US | New Mexico | Sierra | 35051 | 2333 | 85 | 0 | 33.13028233 | -107.1925893 | 2022-09-21 04:23:22 | Sierra, New Mexico, US | |
2017665 | 2017665 | 2022-09-20 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-21 04:23:22 | Fremont, Idaho, US | |
3572814 | 3572814 | 2022-09-19 | US | New Mexico | Sierra | 35051 | 2333 | 85 | 0 | 33.13028233 | -107.1925893 | 2022-09-20 04:22:48 | Sierra, New Mexico, US | |
3571538 | 3571538 | 2022-09-19 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-20 04:22:48 | Fremont, Idaho, US | |
420277 | 420277 | 2022-09-18 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-19 04:21:49 | Fremont, Idaho, US | |
3374301 | 3374301 | 2022-09-17 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-18 04:22:50 | Fremont, Idaho, US | |
2356409 | 2356409 | 2022-09-16 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-17 04:20:19 | Fremont, Idaho, US | |
3987566 | 3987566 | 2022-09-15 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-16 04:21:19 | Fremont, Idaho, US | |
1890083 | 1890083 | 2022-09-14 | US | Idaho | Fremont | 16043 | 2333 | 30 | 0 | 44.22800938 | -111.4809943 | 2022-09-15 04:21:02 | Fremont, Idaho, US | |
256822 | 256822 | 2022-09-08 | US | West Virginia | Pocahontas | 54075 | 2333 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-09-09 04:21:11 | Pocahontas, West Virginia, US | |
115191 | 115191 | 2022-09-06 | US | Alaska | Southeast Fairbanks | 2240 | 2333 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-07 04:20:59 | Southeast Fairbanks, Alaska, US | |
2634163 | 2634163 | 2022-09-05 | US | Alaska | Southeast Fairbanks | 2240 | 2333 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-06 04:21:02 | Southeast Fairbanks, Alaska, US | |
2987727 | 2987727 | 2022-09-04 | US | Alaska | Southeast Fairbanks | 2240 | 2333 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-05 04:21:01 | Southeast Fairbanks, Alaska, US | |
2713412 | 2713412 | 2022-09-03 | US | Alaska | Southeast Fairbanks | 2240 | 2333 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-04 04:21:22 | Southeast Fairbanks, Alaska, US | |
1394117 | 1394117 | 2022-09-02 | US | Alaska | Southeast Fairbanks | 2240 | 2333 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-03 04:21:04 | Southeast Fairbanks, Alaska, US | |
3547946 | 3547946 | 2022-09-01 | US | Alaska | Southeast Fairbanks | 2240 | 2333 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-02 04:21:07 | Southeast Fairbanks, Alaska, US | |
2343866 | 2343866 | 2022-08-31 | US | Alaska | Southeast Fairbanks | 2240 | 2333 | 20 | 0 | 63.87692095 | -143.2127643 | 2022-09-01 04:21:03 | Southeast Fairbanks, Alaska, US | |
3776957 | 3776957 | 2022-08-30 | US | Texas | Clay | 48077 | 2333 | 38 | 0 | 33.78686685 | -98.20771198 | 2022-08-31 04:20:57 | Clay, Texas, US | |
1880466 | 1880466 | 2022-08-28 | US | West Virginia | Doddridge | 54017 | 2333 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-08-29 04:21:06 | Doddridge, West Virginia, US | |
2099593 | 2099593 | 2022-08-27 | US | West Virginia | Doddridge | 54017 | 2333 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-08-28 04:21:02 | Doddridge, West Virginia, US | |
1535408 | 1535408 | 2022-08-26 | US | West Virginia | Doddridge | 54017 | 2333 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-08-27 04:20:57 | Doddridge, West Virginia, US | |
2832295 | 2832295 | 2022-08-25 | US | West Virginia | Doddridge | 54017 | 2333 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-08-26 04:21:02 | Doddridge, West Virginia, US | |
3647382 | 3647382 | 2022-08-14 | China | Jiangsu | 2333 | 0 | 0 | 32.9711 | 119.455 | 2022-08-15 04:20:59 | Jiangsu, China | |||
3910760 | 3910760 | 2022-08-11 | US | Puerto Rico | Las Marias | 72083 | 2333 | 0 | 0 | 18.23679 | -66.98362 | 2022-08-12 04:20:54 | Las Marias, Puerto Rico, US | |
1086897 | 1086897 | 2022-08-09 | US | Georgia | Heard | 13149 | 2333 | 57 | 0 | 33.29686567 | -85.12886832 | 2022-08-10 04:20:57 | Heard, Georgia, US | |
3544312 | 3544312 | 2022-08-08 | US | Georgia | Heard | 13149 | 2333 | 57 | 0 | 33.29686567 | -85.12886832 | 2022-08-09 04:20:34 | Heard, Georgia, US | |
1071371 | 1071371 | 2022-08-07 | US | Kentucky | Trimble | 21223 | 2333 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-08 04:21:08 | Trimble, Kentucky, US | |
1070715 | 1070715 | 2022-08-07 | US | Georgia | Heard | 13149 | 2333 | 57 | 0 | 33.29686567 | -85.12886832 | 2022-08-08 04:21:08 | Heard, Georgia, US | |
1941959 | 1941959 | 2022-08-06 | US | Kentucky | Trimble | 21223 | 2333 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-07 04:20:54 | Trimble, Kentucky, US | |
1941303 | 1941303 | 2022-08-06 | US | Georgia | Heard | 13149 | 2333 | 57 | 0 | 33.29686567 | -85.12886832 | 2022-08-07 04:20:54 | Heard, Georgia, US | |
881758 | 881758 | 2022-08-05 | US | Kentucky | Trimble | 21223 | 2333 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-06 04:20:56 | Trimble, Kentucky, US | |
881102 | 881102 | 2022-08-05 | US | Georgia | Heard | 13149 | 2333 | 57 | 0 | 33.29686567 | -85.12886832 | 2022-08-06 04:20:56 | Heard, Georgia, US | |
2010169 | 2010169 | 2022-08-04 | US | Kentucky | Trimble | 21223 | 2333 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-05 04:20:52 | Trimble, Kentucky, US | |
2009513 | 2009513 | 2022-08-04 | US | Georgia | Heard | 13149 | 2333 | 57 | 0 | 33.29686567 | -85.12886832 | 2022-08-05 04:20:52 | Heard, Georgia, US | |
1099596 | 1099596 | 2022-08-03 | US | Kentucky | Trimble | 21223 | 2333 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-04 04:20:58 | Trimble, Kentucky, US | |
1098940 | 1098940 | 2022-08-03 | US | Georgia | Heard | 13149 | 2333 | 57 | 0 | 33.29686567 | -85.12886832 | 2022-08-04 04:20:58 | Heard, Georgia, US | |
1406521 | 1406521 | 2022-08-02 | US | Kentucky | Trimble | 21223 | 2333 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-03 04:20:59 | Trimble, Kentucky, US | |
3618559 | 3618559 | 2022-08-01 | US | Kentucky | Trimble | 21223 | 2333 | 42 | 0 | 38.61056487 | -85.33775972 | 2022-08-02 04:20:53 | Trimble, Kentucky, US | |
1488860 | 1488860 | 2022-07-26 | US | Kansas | Cloud | 20029 | 2333 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-27 04:21:04 | Cloud, Kansas, US | |
2595306 | 2595306 | 2022-07-25 | US | Kansas | Cloud | 20029 | 2333 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-26 04:20:58 | Cloud, Kansas, US | |
897421 | 897421 | 2022-07-24 | US | Kansas | Cloud | 20029 | 2333 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-25 04:20:51 | Cloud, Kansas, US | |
92415 | 92415 | 2022-07-23 | US | Kansas | Cloud | 20029 | 2333 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-24 04:20:47 | Cloud, Kansas, US | |
901437 | 901437 | 2022-07-22 | US | Kansas | Cloud | 20029 | 2333 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-23 04:20:53 | Cloud, Kansas, US | |
671573 | 671573 | 2022-07-21 | US | Kansas | Cloud | 20029 | 2333 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-22 04:21:15 | Cloud, Kansas, US | |
1609536 | 1609536 | 2022-07-20 | US | Kansas | Cloud | 20029 | 2333 | 42 | 0 | 39.48028352 | -97.64925343 | 2022-07-21 04:21:10 | Cloud, Kansas, US | |
3967729 | 3967729 | 2022-07-05 | US | Iowa | Clarke | 19039 | 2333 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-06 04:20:58 | Clarke, Iowa, US | |
3079240 | 3079240 | 2022-07-04 | US | Iowa | Clarke | 19039 | 2333 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-05 04:20:45 | Clarke, Iowa, US | |
1768522 | 1768522 | 2022-07-03 | US | Iowa | Clarke | 19039 | 2333 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-04 04:20:54 | Clarke, Iowa, US | |
3366508 | 3366508 | 2022-07-02 | US | Iowa | Clarke | 19039 | 2333 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-03 04:20:59 | Clarke, Iowa, US | |
594837 | 594837 | 2022-07-01 | US | Iowa | Clarke | 19039 | 2333 | 37 | 0 | 41.02868181 | -93.78499767 | 2022-07-02 04:21:16 | Clarke, Iowa, 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]);