johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
358 rows where confirmed = 2254 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3377889 | 3377889 | 2022-12-08 | US | Arkansas | Monroe | 5095 | 2254 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-12-09 04:21:05 | Monroe, Arkansas, US | |
2418451 | 2418451 | 2022-12-05 | US | Wisconsin | Pepin | 55091 | 2254 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-06 04:21:03 | Pepin, Wisconsin, US | |
2487752 | 2487752 | 2022-11-16 | US | Minnesota | Murray | 27101 | 2254 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-11-17 04:21:11 | Murray, Minnesota, US | |
293763 | 293763 | 2022-11-15 | US | Minnesota | Murray | 27101 | 2254 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-11-16 04:21:09 | Murray, Minnesota, US | |
3598793 | 3598793 | 2022-11-14 | US | Minnesota | Murray | 27101 | 2254 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-11-15 04:21:16 | Murray, Minnesota, US | |
313651 | 313651 | 2022-11-13 | US | Minnesota | Murray | 27101 | 2254 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-11-14 04:21:09 | Murray, Minnesota, US | |
64812 | 64812 | 2022-11-12 | US | Minnesota | Murray | 27101 | 2254 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-11-13 04:21:14 | Murray, Minnesota, US | |
2928974 | 2928974 | 2022-11-11 | US | Minnesota | Murray | 27101 | 2254 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-11-12 04:20:41 | Murray, Minnesota, US | |
2507810 | 2507810 | 2022-11-10 | US | Minnesota | Murray | 27101 | 2254 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-11-11 04:21:22 | Murray, Minnesota, US | |
3286811 | 3286811 | 2022-10-31 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-11-01 04:22:36 | Harrison, Missouri, US | |
321844 | 321844 | 2022-10-30 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-31 04:21:36 | Harrison, Missouri, US | |
914120 | 914120 | 2022-10-29 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-30 04:22:14 | Harrison, Missouri, US | |
1368389 | 1368389 | 2022-10-28 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-29 04:21:13 | Harrison, Missouri, US | |
3040244 | 3040244 | 2022-10-27 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-28 04:22:31 | Harrison, Missouri, US | |
540664 | 540664 | 2022-10-26 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-27 04:22:01 | Harrison, Missouri, US | |
1832478 | 1832478 | 2022-10-25 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-26 04:22:19 | Gates, North Carolina, US | |
1832065 | 1832065 | 2022-10-25 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-26 04:22:19 | Harrison, Missouri, US | |
796739 | 796739 | 2022-10-24 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-25 04:21:53 | Gates, North Carolina, US | |
796326 | 796326 | 2022-10-24 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-25 04:21:53 | Harrison, Missouri, US | |
3279194 | 3279194 | 2022-10-23 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-24 04:22:29 | Gates, North Carolina, US | |
3278781 | 3278781 | 2022-10-23 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-24 04:22:29 | Harrison, Missouri, US | |
2270232 | 2270232 | 2022-10-22 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-23 04:22:46 | Gates, North Carolina, US | |
2269819 | 2269819 | 2022-10-22 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-23 04:22:46 | Harrison, Missouri, US | |
1594532 | 1594532 | 2022-10-21 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-22 04:22:53 | Gates, North Carolina, US | |
1594119 | 1594119 | 2022-10-21 | US | Missouri | Harrison | 29081 | 2254 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-10-22 04:22:53 | Harrison, Missouri, US | |
2274346 | 2274346 | 2022-10-20 | US | North Dakota | Pembina | 38067 | 2254 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-10-21 04:22:23 | Pembina, North Dakota, US | |
2274248 | 2274248 | 2022-10-20 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-21 04:22:23 | Gates, North Carolina, US | |
2273837 | 2273837 | 2022-10-20 | US | Missouri | Hickory | 29085 | 2254 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-21 04:22:23 | Hickory, Missouri, US | |
200583 | 200583 | 2022-10-19 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-20 04:22:59 | Gates, North Carolina, US | |
200172 | 200172 | 2022-10-19 | US | Missouri | Hickory | 29085 | 2254 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-20 04:22:59 | Hickory, Missouri, US | |
2759244 | 2759244 | 2022-10-18 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-19 04:22:26 | Gates, North Carolina, US | |
2758833 | 2758833 | 2022-10-18 | US | Missouri | Hickory | 29085 | 2254 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-19 04:22:26 | Hickory, Missouri, US | |
2027078 | 2027078 | 2022-10-17 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-18 04:22:42 | Gates, North Carolina, US | |
2026667 | 2026667 | 2022-10-17 | US | Missouri | Hickory | 29085 | 2254 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-18 04:22:42 | Hickory, Missouri, US | |
2161856 | 2161856 | 2022-10-16 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-17 04:20:31 | Gates, North Carolina, US | |
2161445 | 2161445 | 2022-10-16 | US | Missouri | Hickory | 29085 | 2254 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-17 04:20:31 | Hickory, Missouri, US | |
518053 | 518053 | 2022-10-15 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-16 04:22:39 | Gates, North Carolina, US | |
517642 | 517642 | 2022-10-15 | US | Missouri | Hickory | 29085 | 2254 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-16 04:22:39 | Hickory, Missouri, US | |
2035110 | 2035110 | 2022-10-14 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-15 04:22:00 | Gates, North Carolina, US | |
2034699 | 2034699 | 2022-10-14 | US | Missouri | Hickory | 29085 | 2254 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-15 04:22:00 | Hickory, Missouri, US | |
3755798 | 3755798 | 2022-10-13 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-14 04:22:28 | Gates, North Carolina, US | |
3216623 | 3216623 | 2022-10-12 | US | North Carolina | Gates | 37073 | 2254 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-10-13 04:22:39 | Gates, North Carolina, US | |
3995871 | 3995871 | 2022-09-27 | US | Iowa | Palo Alto | 19147 | 2254 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-09-28 04:23:01 | Palo Alto, Iowa, US | |
2770199 | 2770199 | 2022-09-26 | US | Iowa | Palo Alto | 19147 | 2254 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-09-27 04:23:01 | Palo Alto, Iowa, US | |
1977852 | 1977852 | 2022-09-25 | US | Iowa | Palo Alto | 19147 | 2254 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-09-26 04:20:52 | Palo Alto, Iowa, US | |
2651019 | 2651019 | 2022-09-24 | US | Iowa | Palo Alto | 19147 | 2254 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-09-25 04:23:31 | Palo Alto, Iowa, US | |
385459 | 385459 | 2022-09-23 | US | Iowa | Palo Alto | 19147 | 2254 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-09-24 04:21:40 | Palo Alto, Iowa, US | |
1625525 | 1625525 | 2022-09-22 | US | Iowa | Palo Alto | 19147 | 2254 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-09-23 04:23:13 | Palo Alto, Iowa, US | |
1371729 | 1371729 | 2022-09-21 | US | Iowa | Palo Alto | 19147 | 2254 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-09-22 04:22:56 | Palo Alto, Iowa, US | |
2987076 | 2987076 | 2022-09-04 | China | Guangxi | 2254 | 2 | 0 | 23.8298 | 108.7881 | 2022-09-05 04:21:01 | Guangxi, China | |||
2712761 | 2712761 | 2022-09-03 | China | Guangxi | 2254 | 2 | 0 | 23.8298 | 108.7881 | 2022-09-04 04:21:22 | Guangxi, China | |||
1393466 | 1393466 | 2022-09-02 | China | Guangxi | 2254 | 2 | 0 | 23.8298 | 108.7881 | 2022-09-03 04:21:04 | Guangxi, China | |||
3547295 | 3547295 | 2022-09-01 | China | Guangxi | 2254 | 2 | 0 | 23.8298 | 108.7881 | 2022-09-02 04:21:07 | Guangxi, China | |||
2343215 | 2343215 | 2022-08-31 | China | Guangxi | 2254 | 2 | 0 | 23.8298 | 108.7881 | 2022-09-01 04:21:03 | Guangxi, China | |||
3774812 | 3774812 | 2022-08-30 | US | Georgia | Wilcox | 13315 | 2254 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-08-31 04:20:57 | Wilcox, Georgia, US | |
3773695 | 3773695 | 2022-08-30 | China | Guangxi | 2254 | 2 | 0 | 23.8298 | 108.7881 | 2022-08-31 04:20:57 | Guangxi, China | |||
1681408 | 1681408 | 2022-08-29 | US | Georgia | Wilcox | 13315 | 2254 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-08-30 04:21:03 | Wilcox, Georgia, US | |
1877892 | 1877892 | 2022-08-28 | US | Georgia | Wilcox | 13315 | 2254 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-08-29 04:21:06 | Wilcox, Georgia, US | |
2097019 | 2097019 | 2022-08-27 | US | Georgia | Wilcox | 13315 | 2254 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-08-28 04:21:02 | Wilcox, Georgia, US | |
1532834 | 1532834 | 2022-08-26 | US | Georgia | Wilcox | 13315 | 2254 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-08-27 04:20:57 | Wilcox, Georgia, US | |
2829721 | 2829721 | 2022-08-25 | US | Georgia | Wilcox | 13315 | 2254 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-08-26 04:21:02 | Wilcox, Georgia, US | |
2324254 | 2324254 | 2022-08-24 | US | Georgia | Wilcox | 13315 | 2254 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-08-25 04:21:13 | Wilcox, Georgia, US | |
3952204 | 3952204 | 2022-08-17 | US | Minnesota | Clearwater | 27029 | 2254 | 31 | 0 | 47.57992111 | -95.37790562 | 2022-08-18 04:21:11 | Clearwater, Minnesota, US | |
992706 | 992706 | 2022-08-16 | US | Minnesota | Clearwater | 27029 | 2254 | 31 | 0 | 47.57992111 | -95.37790562 | 2022-08-17 04:20:59 | Clearwater, Minnesota, US | |
2495745 | 2495745 | 2022-08-15 | US | Minnesota | Clearwater | 27029 | 2254 | 31 | 0 | 47.57992111 | -95.37790562 | 2022-08-16 04:20:58 | Clearwater, Minnesota, US | |
3649295 | 3649295 | 2022-08-14 | US | Minnesota | Clearwater | 27029 | 2254 | 31 | 0 | 47.57992111 | -95.37790562 | 2022-08-15 04:20:59 | Clearwater, Minnesota, US | |
1970301 | 1970301 | 2022-08-13 | US | Minnesota | Clearwater | 27029 | 2254 | 31 | 0 | 47.57992111 | -95.37790562 | 2022-08-14 04:20:55 | Clearwater, Minnesota, US | |
2890110 | 2890110 | 2022-08-12 | US | Minnesota | Clearwater | 27029 | 2254 | 31 | 0 | 47.57992111 | -95.37790562 | 2022-08-13 04:20:52 | Clearwater, Minnesota, US | |
3909715 | 3909715 | 2022-08-11 | US | Minnesota | Clearwater | 27029 | 2254 | 31 | 0 | 47.57992111 | -95.37790562 | 2022-08-12 04:20:54 | Clearwater, Minnesota, US | |
1347367 | 1347367 | 2022-08-10 | US | Illinois | Schuyler | 17169 | 2254 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-08-11 04:20:49 | Schuyler, Illinois, US | |
1408138 | 1408138 | 2022-08-02 | US | Texas | Gaines | 48165 | 2254 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-08-03 04:20:59 | Gaines, Texas, US | |
3874722 | 3874722 | 2022-07-31 | US | Texas | Live Oak | 48297 | 2254 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-08-01 04:21:03 | Live Oak, Texas, US | |
677476 | 677476 | 2022-07-30 | US | Texas | Live Oak | 48297 | 2254 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-07-31 04:21:02 | Live Oak, Texas, US | |
1786675 | 1786675 | 2022-07-29 | US | Texas | Live Oak | 48297 | 2254 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-07-30 04:20:42 | Live Oak, Texas, US | |
673779 | 673779 | 2022-07-21 | US | West Virginia | Doddridge | 54017 | 2254 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-07-22 04:21:15 | Doddridge, West Virginia, US | |
670826 | 670826 | 2022-07-21 | US | Arkansas | Searcy | 5129 | 2254 | 49 | 0 | 35.9109364 | -92.69936482 | 2022-07-22 04:21:15 | Searcy, Arkansas, US | |
1609791 | 1609791 | 2022-07-20 | US | Louisiana | Red River | 22081 | 2254 | 54 | 0 | 32.09530039 | -93.34213308 | 2022-07-21 04:21:10 | Red River, Louisiana, US | |
3432016 | 3432016 | 2022-07-14 | US | Texas | Clay | 48077 | 2254 | 37 | 0 | 33.78686685 | -98.20771198 | 2022-07-15 04:20:53 | Clay, Texas, US | |
2190705 | 2190705 | 2022-06-22 | US | Texas | Franklin | 48159 | 2254 | 43 | 0 | 33.17653242 | -95.21917243 | 2022-06-23 04:20:55 | Franklin, Texas, US | |
1765062 | 1765062 | 2022-06-20 | US | Minnesota | Lake | 27075 | 2254 | 29 | 0 | 47.64270764 | -91.44557998 | 2022-06-21 04:20:56 | Lake, Minnesota, US | |
3271248 | 3271248 | 2022-06-19 | US | Minnesota | Lake | 27075 | 2254 | 29 | 0 | 47.64270764 | -91.44557998 | 2022-06-20 04:21:01 | Lake, Minnesota, US | |
3270918 | 3270918 | 2022-06-19 | US | Kentucky | Gallatin | 21077 | 2254 | 51 | 0 | 38.75398691 | -84.8558382 | 2022-06-20 04:21:01 | Gallatin, Kentucky, US | |
3399160 | 3399160 | 2022-06-18 | US | Minnesota | Lake | 27075 | 2254 | 29 | 0 | 47.64270764 | -91.44557998 | 2022-06-19 04:20:51 | Lake, Minnesota, US | |
3398830 | 3398830 | 2022-06-18 | US | Kentucky | Gallatin | 21077 | 2254 | 51 | 0 | 38.75398691 | -84.8558382 | 2022-06-19 04:20:51 | Gallatin, Kentucky, US | |
2313037 | 2313037 | 2022-06-17 | US | Minnesota | Lake | 27075 | 2254 | 29 | 0 | 47.64270764 | -91.44557998 | 2022-06-18 04:21:10 | Lake, Minnesota, US | |
2312707 | 2312707 | 2022-06-17 | US | Kentucky | Gallatin | 21077 | 2254 | 51 | 0 | 38.75398691 | -84.8558382 | 2022-06-18 04:21:10 | Gallatin, Kentucky, US | |
560706 | 560706 | 2022-06-16 | US | Missouri | DeKalb | 29063 | 2254 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-06-17 04:20:56 | DeKalb, Missouri, US | |
560211 | 560211 | 2022-06-16 | US | Kentucky | Gallatin | 21077 | 2254 | 51 | 0 | 38.75398691 | -84.8558382 | 2022-06-17 04:20:56 | Gallatin, Kentucky, US | |
3984508 | 3984508 | 2022-06-15 | US | Missouri | DeKalb | 29063 | 2254 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-06-16 04:20:55 | DeKalb, Missouri, US | |
3984013 | 3984013 | 2022-06-15 | US | Kentucky | Gallatin | 21077 | 2254 | 51 | 0 | 38.75398691 | -84.8558382 | 2022-06-16 04:20:55 | Gallatin, Kentucky, US | |
948749 | 948749 | 2022-06-14 | US | Missouri | DeKalb | 29063 | 2254 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-06-15 04:20:54 | DeKalb, Missouri, US | |
948254 | 948254 | 2022-06-14 | US | Kentucky | Gallatin | 21077 | 2254 | 51 | 0 | 38.75398691 | -84.8558382 | 2022-06-15 04:20:54 | Gallatin, Kentucky, US | |
947301 | 947301 | 2022-06-14 | US | Arizona | Greenlee | 4011 | 2254 | 34 | 0 | 33.21498827 | -109.2405279 | 2022-06-15 04:20:54 | Greenlee, Arizona, US | |
2981157 | 2981157 | 2022-06-13 | US | Missouri | DeKalb | 29063 | 2254 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-06-14 04:20:52 | DeKalb, Missouri, US | |
2980662 | 2980662 | 2022-06-13 | US | Kentucky | Gallatin | 21077 | 2254 | 51 | 0 | 38.75398691 | -84.8558382 | 2022-06-14 04:20:52 | Gallatin, Kentucky, US | |
2979709 | 2979709 | 2022-06-13 | US | Arizona | Greenlee | 4011 | 2254 | 34 | 0 | 33.21498827 | -109.2405279 | 2022-06-14 04:20:52 | Greenlee, Arizona, US | |
2237283 | 2237283 | 2022-06-12 | US | Missouri | DeKalb | 29063 | 2254 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-06-13 04:21:14 | DeKalb, Missouri, US | |
2235835 | 2235835 | 2022-06-12 | US | Arizona | Greenlee | 4011 | 2254 | 34 | 0 | 33.21498827 | -109.2405279 | 2022-06-13 04:21:14 | Greenlee, Arizona, US | |
3143481 | 3143481 | 2022-06-11 | US | Missouri | DeKalb | 29063 | 2254 | 47 | 0 | 39.89201062 | -94.40476508 | 2022-06-12 04:20:53 | DeKalb, Missouri, US | |
3142033 | 3142033 | 2022-06-11 | US | Arizona | Greenlee | 4011 | 2254 | 34 | 0 | 33.21498827 | -109.2405279 | 2022-06-12 04:20:53 | Greenlee, Arizona, 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]);