johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
330 rows where confirmed = 2181 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
872117 | 872117 | 2022-12-11 | US | Virginia | Buena Vista | 51530 | 2181 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-12 04:21:01 | Buena Vista, Virginia, US | |
260647 | 260647 | 2022-12-10 | US | Virginia | Buena Vista | 51530 | 2181 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-11 04:20:50 | Buena Vista, Virginia, US | |
3939361 | 3939361 | 2022-12-09 | US | Virginia | Buena Vista | 51530 | 2181 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-10 04:21:02 | Buena Vista, Virginia, US | |
1987964 | 1987964 | 2022-12-07 | US | Virginia | Buena Vista | 51530 | 2181 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-12-08 04:21:07 | Buena Vista, Virginia, US | |
2434364 | 2434364 | 2022-11-09 | US | Virginia | Williamsburg | 51830 | 2181 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-10 04:21:16 | Williamsburg, Virginia, US | |
2433558 | 2433558 | 2022-11-09 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-10 04:21:16 | Grant, Oregon, US | |
482214 | 482214 | 2022-11-08 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-09 04:21:22 | Grant, Oregon, US | |
2441364 | 2441364 | 2022-11-07 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-08 04:21:21 | Grant, Oregon, US | |
1052462 | 1052462 | 2022-11-06 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-07 04:21:26 | Grant, Oregon, US | |
620486 | 620486 | 2022-11-05 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-06 04:21:24 | Grant, Oregon, US | |
1024990 | 1024990 | 2022-11-04 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-05 04:21:52 | Grant, Oregon, US | |
433981 | 433981 | 2022-11-03 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-04 04:22:11 | Grant, Oregon, US | |
852223 | 852223 | 2022-11-02 | US | Oregon | Grant | 41023 | 2181 | 26 | 0 | 44.49024544 | -119.0068631 | 2022-11-03 04:22:05 | Grant, Oregon, US | |
3041700 | 3041700 | 2022-10-27 | US | Virginia | Lancaster | 51103 | 2181 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-10-28 04:22:31 | Lancaster, Virginia, US | |
1830580 | 1830580 | 2022-10-25 | US | Alaska | Dillingham | 2070 | 2181 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-26 04:22:19 | Dillingham, Alaska, US | |
798027 | 798027 | 2022-10-24 | US | Wyoming | Johnson | 56019 | 2181 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-10-25 04:21:53 | Johnson, Wyoming, US | |
794841 | 794841 | 2022-10-24 | US | Alaska | Dillingham | 2070 | 2181 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-25 04:21:53 | Dillingham, Alaska, US | |
3280482 | 3280482 | 2022-10-23 | US | Wyoming | Johnson | 56019 | 2181 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-10-24 04:22:29 | Johnson, Wyoming, US | |
3277296 | 3277296 | 2022-10-23 | US | Alaska | Dillingham | 2070 | 2181 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-24 04:22:29 | Dillingham, Alaska, US | |
2271520 | 2271520 | 2022-10-22 | US | Wyoming | Johnson | 56019 | 2181 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-10-23 04:22:46 | Johnson, Wyoming, US | |
2268334 | 2268334 | 2022-10-22 | US | Alaska | Dillingham | 2070 | 2181 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-23 04:22:46 | Dillingham, Alaska, US | |
1595820 | 1595820 | 2022-10-21 | US | Wyoming | Johnson | 56019 | 2181 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-10-22 04:22:53 | Johnson, Wyoming, US | |
1592634 | 1592634 | 2022-10-21 | US | Alaska | Dillingham | 2070 | 2181 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-22 04:22:53 | Dillingham, Alaska, US | |
2275536 | 2275536 | 2022-10-20 | US | Wyoming | Johnson | 56019 | 2181 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-10-21 04:22:23 | Johnson, Wyoming, US | |
2272350 | 2272350 | 2022-10-20 | US | Alaska | Dillingham | 2070 | 2181 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-21 04:22:23 | Dillingham, Alaska, US | |
201871 | 201871 | 2022-10-19 | US | Wyoming | Johnson | 56019 | 2181 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-10-20 04:22:59 | Johnson, Wyoming, US | |
198685 | 198685 | 2022-10-19 | US | Alaska | Dillingham | 2070 | 2181 | 12 | 0 | 59.79603738 | -158.2381942 | 2022-10-20 04:22:59 | Dillingham, Alaska, US | |
2760532 | 2760532 | 2022-10-18 | US | Wyoming | Johnson | 56019 | 2181 | 21 | 0 | 44.04057166 | -106.5845174 | 2022-10-19 04:22:26 | Johnson, Wyoming, US | |
3998116 | 3998116 | 2022-09-27 | US | West Virginia | Calhoun | 54013 | 2181 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-28 04:23:01 | Calhoun, West Virginia, US | |
2772444 | 2772444 | 2022-09-26 | US | West Virginia | Calhoun | 54013 | 2181 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-27 04:23:01 | Calhoun, West Virginia, US | |
1980097 | 1980097 | 2022-09-25 | US | West Virginia | Calhoun | 54013 | 2181 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-26 04:20:52 | Calhoun, West Virginia, US | |
1979729 | 1979729 | 2022-09-25 | US | Texas | Hansford | 48195 | 2181 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-09-26 04:20:52 | Hansford, Texas, US | |
2653264 | 2653264 | 2022-09-24 | US | West Virginia | Calhoun | 54013 | 2181 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-25 04:23:31 | Calhoun, West Virginia, US | |
2652896 | 2652896 | 2022-09-24 | US | Texas | Hansford | 48195 | 2181 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-09-25 04:23:31 | Hansford, Texas, US | |
387704 | 387704 | 2022-09-23 | US | West Virginia | Calhoun | 54013 | 2181 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-09-24 04:21:40 | Calhoun, West Virginia, US | |
387336 | 387336 | 2022-09-23 | US | Texas | Hansford | 48195 | 2181 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-09-24 04:21:40 | Hansford, Texas, US | |
2017237 | 2017237 | 2022-09-20 | US | Arkansas | Monroe | 5095 | 2181 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-09-21 04:23:22 | Monroe, Arkansas, US | |
2637297 | 2637297 | 2022-09-05 | US | Wisconsin | Pepin | 55091 | 2181 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-09-06 04:21:02 | Pepin, Wisconsin, US | |
2635377 | 2635377 | 2022-09-05 | US | Michigan | Lake | 26085 | 2181 | 39 | 0 | 43.99050893 | -85.802173 | 2022-09-06 04:21:02 | Lake, Michigan, US | |
2988941 | 2988941 | 2022-09-04 | US | Michigan | Lake | 26085 | 2181 | 39 | 0 | 43.99050893 | -85.802173 | 2022-09-05 04:21:01 | Lake, Michigan, US | |
2714626 | 2714626 | 2022-09-03 | US | Michigan | Lake | 26085 | 2181 | 39 | 0 | 43.99050893 | -85.802173 | 2022-09-04 04:21:22 | Lake, Michigan, US | |
1395331 | 1395331 | 2022-09-02 | US | Michigan | Lake | 26085 | 2181 | 39 | 0 | 43.99050893 | -85.802173 | 2022-09-03 04:21:04 | Lake, Michigan, US | |
3549160 | 3549160 | 2022-09-01 | US | Michigan | Lake | 26085 | 2181 | 39 | 0 | 43.99050893 | -85.802173 | 2022-09-02 04:21:07 | Lake, Michigan, US | |
2345846 | 2345846 | 2022-08-31 | US | North Dakota | Pembina | 38067 | 2181 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-09-01 04:21:03 | Pembina, North Dakota, US | |
2345080 | 2345080 | 2022-08-31 | US | Michigan | Lake | 26085 | 2181 | 39 | 0 | 43.99050893 | -85.802173 | 2022-09-01 04:21:03 | Lake, Michigan, US | |
2323870 | 2323870 | 2022-08-24 | US | Arkansas | Prairie | 5117 | 2181 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-08-25 04:21:13 | Prairie, Arkansas, US | |
3954010 | 3954010 | 2022-08-17 | US | West Virginia | Tucker | 54093 | 2181 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-08-18 04:21:11 | Tucker, West Virginia, US | |
992227 | 992227 | 2022-08-16 | US | Iowa | Palo Alto | 19147 | 2181 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-08-17 04:20:59 | Palo Alto, Iowa, US | |
992198 | 992198 | 2022-08-16 | US | Iowa | Howard | 19089 | 2181 | 37 | 0 | 43.35671042 | -92.31702714 | 2022-08-17 04:20:59 | Howard, Iowa, US | |
2495266 | 2495266 | 2022-08-15 | US | Iowa | Palo Alto | 19147 | 2181 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-08-16 04:20:58 | Palo Alto, Iowa, US | |
2495237 | 2495237 | 2022-08-15 | US | Iowa | Howard | 19089 | 2181 | 37 | 0 | 43.35671042 | -92.31702714 | 2022-08-16 04:20:58 | Howard, Iowa, US | |
3648816 | 3648816 | 2022-08-14 | US | Iowa | Palo Alto | 19147 | 2181 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-08-15 04:20:59 | Palo Alto, Iowa, US | |
3648787 | 3648787 | 2022-08-14 | US | Iowa | Howard | 19089 | 2181 | 37 | 0 | 43.35671042 | -92.31702714 | 2022-08-15 04:20:59 | Howard, Iowa, US | |
1969822 | 1969822 | 2022-08-13 | US | Iowa | Palo Alto | 19147 | 2181 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-08-14 04:20:55 | Palo Alto, Iowa, US | |
1969793 | 1969793 | 2022-08-13 | US | Iowa | Howard | 19089 | 2181 | 37 | 0 | 43.35671042 | -92.31702714 | 2022-08-14 04:20:55 | Howard, Iowa, US | |
2889631 | 2889631 | 2022-08-12 | US | Iowa | Palo Alto | 19147 | 2181 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-08-13 04:20:52 | Palo Alto, Iowa, US | |
2889602 | 2889602 | 2022-08-12 | US | Iowa | Howard | 19089 | 2181 | 37 | 0 | 43.35671042 | -92.31702714 | 2022-08-13 04:20:52 | Howard, Iowa, US | |
3909236 | 3909236 | 2022-08-11 | US | Iowa | Palo Alto | 19147 | 2181 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-08-12 04:20:54 | Palo Alto, Iowa, US | |
3909207 | 3909207 | 2022-08-11 | US | Iowa | Howard | 19089 | 2181 | 37 | 0 | 43.35671042 | -92.31702714 | 2022-08-12 04:20:54 | Howard, Iowa, US | |
1347553 | 1347553 | 2022-08-10 | US | Iowa | Palo Alto | 19147 | 2181 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-08-11 04:20:49 | Palo Alto, Iowa, US | |
1347524 | 1347524 | 2022-08-10 | US | Iowa | Howard | 19089 | 2181 | 37 | 0 | 43.35671042 | -92.31702714 | 2022-08-11 04:20:49 | Howard, Iowa, US | |
2150709 | 2150709 | 2022-06-27 | US | Texas | Dallam | 48111 | 2181 | 40 | 0 | 36.27787176 | -102.6020725 | 2022-06-28 04:20:58 | Dallam, Texas, US | |
478603 | 478603 | 2022-06-26 | US | Texas | Live Oak | 48297 | 2181 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-27 04:21:00 | Live Oak, Texas, US | |
478510 | 478510 | 2022-06-26 | US | Texas | Dallam | 48111 | 2181 | 40 | 0 | 36.27787176 | -102.6020725 | 2022-06-27 04:21:00 | Dallam, Texas, US | |
941885 | 941885 | 2022-06-25 | US | Texas | Dallam | 48111 | 2181 | 40 | 0 | 36.27787176 | -102.6020725 | 2022-06-26 04:21:02 | Dallam, Texas, US | |
3349705 | 3349705 | 2022-06-24 | US | Texas | Dallam | 48111 | 2181 | 40 | 0 | 36.27787176 | -102.6020725 | 2022-06-25 04:20:57 | Dallam, Texas, US | |
167377 | 167377 | 2022-06-21 | US | Kansas | Pawnee | 20145 | 2181 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-06-22 04:20:54 | Pawnee, Kansas, US | |
1764660 | 1764660 | 2022-06-20 | US | Kansas | Pawnee | 20145 | 2181 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-06-21 04:20:56 | Pawnee, Kansas, US | |
3270846 | 3270846 | 2022-06-19 | US | Kansas | Pawnee | 20145 | 2181 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-06-20 04:21:01 | Pawnee, Kansas, US | |
3398758 | 3398758 | 2022-06-18 | US | Kansas | Pawnee | 20145 | 2181 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-06-19 04:20:51 | Pawnee, Kansas, US | |
2312635 | 2312635 | 2022-06-17 | US | Kansas | Pawnee | 20145 | 2181 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-06-18 04:21:10 | Pawnee, Kansas, US | |
560139 | 560139 | 2022-06-16 | US | Kansas | Pawnee | 20145 | 2181 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-06-17 04:20:56 | Pawnee, Kansas, US | |
3983941 | 3983941 | 2022-06-15 | US | Kansas | Pawnee | 20145 | 2181 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-06-16 04:20:55 | Pawnee, Kansas, US | |
3727039 | 3727039 | 2022-06-07 | US | Georgia | Heard | 13149 | 2181 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-06-08 04:20:55 | Heard, Georgia, US | |
3888441 | 3888441 | 2022-06-06 | US | Georgia | Heard | 13149 | 2181 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-06-07 04:21:08 | Heard, Georgia, US | |
3508210 | 3508210 | 2022-06-05 | US | Georgia | Heard | 13149 | 2181 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-06-06 04:20:57 | Heard, Georgia, US | |
3528287 | 3528287 | 2022-06-04 | US | Georgia | Heard | 13149 | 2181 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-06-05 04:20:55 | Heard, Georgia, US | |
3134373 | 3134373 | 2022-06-03 | US | Georgia | Heard | 13149 | 2181 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-06-04 04:20:58 | Heard, Georgia, US | |
3579448 | 3579448 | 2022-06-02 | US | Georgia | Heard | 13149 | 2181 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-06-03 04:20:58 | Heard, Georgia, US | |
971741 | 971741 | 2022-06-01 | US | Georgia | Heard | 13149 | 2181 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-06-02 05:20:39 | Heard, Georgia, US | |
232706 | 232706 | 2022-05-31 | US | West Virginia | Doddridge | 54017 | 2181 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-06-01 04:20:55 | Doddridge, West Virginia, US | |
3000422 | 3000422 | 2022-05-24 | US | Indiana | Martin | 18101 | 2181 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-25 04:20:56 | Martin, Indiana, US | |
3594143 | 3594143 | 2022-05-23 | US | Indiana | Martin | 18101 | 2181 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-24 04:20:57 | Martin, Indiana, US | |
1504594 | 1504594 | 2022-05-16 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-17 04:20:59 | Hamilton, Illinois, US | |
2084953 | 2084953 | 2022-05-15 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-16 04:20:47 | Hamilton, Illinois, US | |
3355663 | 3355663 | 2022-05-14 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-15 04:20:53 | Hamilton, Illinois, US | |
659308 | 659308 | 2022-05-13 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-14 04:20:48 | Hamilton, Illinois, US | |
2534391 | 2534391 | 2022-05-12 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-13 04:20:51 | Hamilton, Illinois, US | |
3445837 | 3445837 | 2022-05-11 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-12 04:20:54 | Hamilton, Illinois, US | |
3538843 | 3538843 | 2022-05-10 | US | Virginia | Northampton | 51131 | 2181 | 64 | 0 | 37.34062933 | -75.87751591 | 2022-05-11 04:20:48 | Northampton, Virginia, US | |
225378 | 225378 | 2022-05-09 | US | Virginia | Northampton | 51131 | 2181 | 64 | 0 | 37.34062933 | -75.87751591 | 2022-05-10 04:20:50 | Northampton, Virginia, US | |
222989 | 222989 | 2022-05-09 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-10 04:20:50 | Hamilton, Illinois, US | |
2599042 | 2599042 | 2022-05-05 | US | Illinois | Hamilton | 17065 | 2181 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-05-06 04:21:00 | Hamilton, Illinois, US | |
1907630 | 1907630 | 2022-03-22 | US | North Dakota | Traill | 38097 | 2181 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-03-23 04:20:48 | Traill, North Dakota, US | |
3240761 | 3240761 | 2022-03-21 | US | North Dakota | Traill | 38097 | 2181 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-03-22 04:20:54 | Traill, North Dakota, US | |
26834 | 26834 | 2022-03-20 | US | North Dakota | Traill | 38097 | 2181 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-03-21 04:20:50 | Traill, North Dakota, US | |
1658844 | 1658844 | 2022-03-19 | US | North Dakota | Traill | 38097 | 2181 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-03-20 04:20:45 | Traill, North Dakota, US | |
338370 | 338370 | 2022-03-18 | US | North Dakota | Traill | 38097 | 2181 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-03-19 04:20:47 | Traill, North Dakota, US | |
696823 | 696823 | 2022-03-17 | US | North Dakota | Traill | 38097 | 2181 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-03-18 04:20:55 | Traill, North Dakota, US | |
2528555 | 2528555 | 2022-03-02 | US | Texas | Ochiltree | 48357 | 2181 | 47 | 0 | 36.27829105 | -100.8158184 | 2022-03-03 04:21:01 | Ochiltree, 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]);