johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
200 rows where confirmed = 5992 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1987143 | 1987143 | 2022-12-07 | US | Ohio | Meigs | 39105 | 5992 | 102 | 0 | 39.09224872 | -82.0305041 | 2022-12-08 04:21:07 | Meigs, Ohio, US | |
3716666 | 3716666 | 2022-12-06 | US | Ohio | Meigs | 39105 | 5992 | 101 | 0 | 39.09224872 | -82.0305041 | 2022-12-07 04:20:58 | Meigs, Ohio, US | |
2417371 | 2417371 | 2022-12-05 | US | Ohio | Meigs | 39105 | 5992 | 101 | 0 | 39.09224872 | -82.0305041 | 2022-12-06 04:21:03 | Meigs, Ohio, US | |
720979 | 720979 | 2022-12-04 | US | Ohio | Meigs | 39105 | 5992 | 101 | 0 | 39.09224872 | -82.0305041 | 2022-12-05 04:20:58 | Meigs, Ohio, US | |
2819268 | 2819268 | 2022-12-03 | US | Ohio | Meigs | 39105 | 5992 | 101 | 0 | 39.09224872 | -82.0305041 | 2022-12-04 04:20:56 | Meigs, Ohio, US | |
836124 | 836124 | 2022-12-02 | US | Ohio | Meigs | 39105 | 5992 | 101 | 0 | 39.09224872 | -82.0305041 | 2022-12-03 04:21:02 | Meigs, Ohio, US | |
2138654 | 2138654 | 2022-12-01 | US | Ohio | Meigs | 39105 | 5992 | 101 | 0 | 39.09224872 | -82.0305041 | 2022-12-02 04:21:07 | Meigs, Ohio, US | |
2431339 | 2431339 | 2022-11-09 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-10 04:21:16 | Randolph, Alabama, US | |
479995 | 479995 | 2022-11-08 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-09 04:21:22 | Randolph, Alabama, US | |
2439145 | 2439145 | 2022-11-07 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-08 04:21:21 | Randolph, Alabama, US | |
1050243 | 1050243 | 2022-11-06 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-07 04:21:26 | Randolph, Alabama, US | |
618267 | 618267 | 2022-11-05 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-06 04:21:24 | Randolph, Alabama, US | |
1022771 | 1022771 | 2022-11-04 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-05 04:21:52 | Randolph, Alabama, US | |
431762 | 431762 | 2022-11-03 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-04 04:22:11 | Randolph, Alabama, US | |
850004 | 850004 | 2022-11-02 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-03 04:22:05 | Randolph, Alabama, US | |
710855 | 710855 | 2022-11-01 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-02 04:22:09 | Randolph, Alabama, US | |
3285304 | 3285304 | 2022-10-31 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-11-01 04:22:36 | Randolph, Alabama, US | |
320337 | 320337 | 2022-10-30 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-10-31 04:21:36 | Randolph, Alabama, US | |
912613 | 912613 | 2022-10-29 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-10-30 04:22:14 | Randolph, Alabama, US | |
1366882 | 1366882 | 2022-10-28 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-10-29 04:21:13 | Randolph, Alabama, US | |
3038737 | 3038737 | 2022-10-27 | US | Alabama | Randolph | 1111 | 5992 | 77 | 0 | 33.29526734 | -85.45708831 | 2022-10-28 04:22:31 | Randolph, Alabama, US | |
3250999 | 3250999 | 2022-10-11 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-12 04:22:51 | Mitchell, Georgia, US | |
2968258 | 2968258 | 2022-10-10 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-11 04:23:05 | Mitchell, Georgia, US | |
3098294 | 3098294 | 2022-10-09 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-10 04:22:32 | Mitchell, Georgia, US | |
4003519 | 4003519 | 2022-10-08 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-09 04:21:16 | Mitchell, Georgia, US | |
397116 | 397116 | 2022-10-07 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-08 04:22:56 | Mitchell, Georgia, US | |
2530233 | 2530233 | 2022-10-06 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-07 04:23:08 | Mitchell, Georgia, US | |
1811627 | 1811627 | 2022-10-05 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-06 04:21:22 | Mitchell, Georgia, US | |
131601 | 131601 | 2022-10-04 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-05 04:23:06 | Mitchell, Georgia, US | |
2686548 | 2686548 | 2022-10-03 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-04 04:22:55 | Mitchell, Georgia, US | |
2260615 | 2260615 | 2022-10-02 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-03 04:23:11 | Mitchell, Georgia, US | |
2996141 | 2996141 | 2022-10-01 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-02 04:21:23 | Mitchell, Georgia, US | |
854467 | 854467 | 2022-09-30 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-01 04:23:01 | Mitchell, Georgia, US | |
2376393 | 2376393 | 2022-09-29 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-09-30 04:23:09 | Mitchell, Georgia, US | |
1560944 | 1560944 | 2022-09-28 | US | Georgia | Mitchell | 13205 | 5992 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-09-29 04:22:34 | Mitchell, Georgia, US | |
1977143 | 1977143 | 2022-09-25 | US | Arkansas | Randolph | 5121 | 5992 | 98 | 0 | 36.3415714 | -91.02455531 | 2022-09-26 04:20:52 | Randolph, Arkansas, US | |
2650310 | 2650310 | 2022-09-24 | US | Arkansas | Randolph | 5121 | 5992 | 98 | 0 | 36.3415714 | -91.02455531 | 2022-09-25 04:23:31 | Randolph, Arkansas, US | |
2637315 | 2637315 | 2022-09-05 | US | Wisconsin | Vilas | 55125 | 5992 | 95 | 0 | 46.05467334 | -89.51719204 | 2022-09-06 04:21:02 | Vilas, Wisconsin, US | |
1396680 | 1396680 | 2022-09-02 | US | Tennessee | Unicoi | 47171 | 5992 | 99 | 0 | 36.10890856 | -82.43709629 | 2022-09-03 04:21:04 | Unicoi, Tennessee, US | |
3775074 | 3775074 | 2022-08-30 | US | Iowa | Bremer | 19017 | 5992 | 85 | 0 | 42.77461496 | -92.31795937 | 2022-08-31 04:20:57 | Bremer, Iowa, US | |
1681670 | 1681670 | 2022-08-29 | US | Iowa | Bremer | 19017 | 5992 | 85 | 0 | 42.77461496 | -92.31795937 | 2022-08-30 04:21:03 | Bremer, Iowa, US | |
1878154 | 1878154 | 2022-08-28 | US | Iowa | Bremer | 19017 | 5992 | 85 | 0 | 42.77461496 | -92.31795937 | 2022-08-29 04:21:06 | Bremer, Iowa, US | |
2097281 | 2097281 | 2022-08-27 | US | Iowa | Bremer | 19017 | 5992 | 85 | 0 | 42.77461496 | -92.31795937 | 2022-08-28 04:21:02 | Bremer, Iowa, US | |
1533096 | 1533096 | 2022-08-26 | US | Iowa | Bremer | 19017 | 5992 | 85 | 0 | 42.77461496 | -92.31795937 | 2022-08-27 04:20:57 | Bremer, Iowa, US | |
2829983 | 2829983 | 2022-08-25 | US | Iowa | Bremer | 19017 | 5992 | 85 | 0 | 42.77461496 | -92.31795937 | 2022-08-26 04:21:02 | Bremer, Iowa, US | |
2324516 | 2324516 | 2022-08-24 | US | Iowa | Bremer | 19017 | 5992 | 85 | 0 | 42.77461496 | -92.31795937 | 2022-08-25 04:21:13 | Bremer, Iowa, US | |
3873007 | 3873007 | 2022-07-31 | US | Kentucky | McCreary | 21147 | 5992 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-08-01 04:21:03 | McCreary, Kentucky, US | |
675761 | 675761 | 2022-07-30 | US | Kentucky | McCreary | 21147 | 5992 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-07-31 04:21:02 | McCreary, Kentucky, US | |
1784960 | 1784960 | 2022-07-29 | US | Kentucky | McCreary | 21147 | 5992 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-07-30 04:20:42 | McCreary, Kentucky, US | |
1067323 | 1067323 | 2022-07-28 | US | Kentucky | McCreary | 21147 | 5992 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-07-29 04:20:45 | McCreary, Kentucky, US | |
2336842 | 2336842 | 2022-07-27 | US | Kentucky | McCreary | 21147 | 5992 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-07-28 04:20:56 | McCreary, Kentucky, US | |
1489032 | 1489032 | 2022-07-26 | US | Kentucky | McCreary | 21147 | 5992 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-07-27 04:21:04 | McCreary, Kentucky, US | |
2595478 | 2595478 | 2022-07-25 | US | Kentucky | McCreary | 21147 | 5992 | 84 | 0 | 36.73874143 | -84.48102924 | 2022-07-26 04:20:58 | McCreary, Kentucky, US | |
903171 | 903171 | 2022-07-22 | US | Tennessee | Wayne | 47181 | 5992 | 73 | 0 | 35.23868267 | -87.78644456 | 2022-07-23 04:20:53 | Wayne, Tennessee, US | |
962388 | 962388 | 2022-07-19 | US | West Virginia | Lincoln | 54043 | 5992 | 84 | 0 | 38.172154 | -82.07017953 | 2022-07-20 04:20:59 | Lincoln, West Virginia, US | |
630721 | 630721 | 2022-07-12 | US | Georgia | Grady | 13131 | 5992 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-07-13 04:20:58 | Grady, Georgia, US | |
1212365 | 1212365 | 2022-07-11 | US | Georgia | Grady | 13131 | 5992 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-07-12 04:20:51 | Grady, Georgia, US | |
2789847 | 2789847 | 2022-07-10 | US | Georgia | Grady | 13131 | 5992 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-07-11 04:20:46 | Grady, Georgia, US | |
142800 | 142800 | 2022-07-09 | US | Georgia | Grady | 13131 | 5992 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-07-10 04:20:54 | Grady, Georgia, US | |
1417900 | 1417900 | 2022-07-08 | US | Georgia | Grady | 13131 | 5992 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-07-09 04:20:59 | Grady, Georgia, US | |
2741825 | 2741825 | 2022-07-07 | US | Georgia | Grady | 13131 | 5992 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-07-08 04:20:56 | Grady, Georgia, US | |
1200620 | 1200620 | 2022-07-06 | US | Georgia | Grady | 13131 | 5992 | 113 | 0 | 30.87454847 | -84.23418364 | 2022-07-07 04:20:55 | Grady, Georgia, US | |
2239670 | 2239670 | 2022-06-28 | Saint Kitts and Nevis | 5992 | 43 | 0 | 17.357822 | -62.782998 | 2022-06-29 04:20:59 | Saint Kitts and Nevis | ||||
1651794 | 1651794 | 2022-06-23 | US | Virginia | Staunton | 51790 | 5992 | 117 | 0 | 38.15965544 | -79.05979937 | 2022-06-24 04:20:58 | Staunton, Virginia, US | |
1764919 | 1764919 | 2022-06-20 | US | Maryland | Talbot | 24041 | 5992 | 89 | 0 | 38.76618159 | -76.10882561 | 2022-06-21 04:20:56 | Talbot, Maryland, US | |
3271105 | 3271105 | 2022-06-19 | US | Maryland | Talbot | 24041 | 5992 | 89 | 0 | 38.76618159 | -76.10882561 | 2022-06-20 04:21:01 | Talbot, Maryland, US | |
3399017 | 3399017 | 2022-06-18 | US | Maryland | Talbot | 24041 | 5992 | 89 | 0 | 38.76618159 | -76.10882561 | 2022-06-19 04:20:51 | Talbot, Maryland, US | |
2312894 | 2312894 | 2022-06-17 | US | Maryland | Talbot | 24041 | 5992 | 89 | 0 | 38.76618159 | -76.10882561 | 2022-06-18 04:21:10 | Talbot, Maryland, US | |
949763 | 949763 | 2022-06-14 | US | South Dakota | Yankton | 46135 | 5992 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-06-15 04:20:54 | Yankton, South Dakota, US | |
2982171 | 2982171 | 2022-06-13 | US | South Dakota | Yankton | 46135 | 5992 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-06-14 04:20:52 | Yankton, South Dakota, US | |
2238297 | 2238297 | 2022-06-12 | US | South Dakota | Yankton | 46135 | 5992 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-06-13 04:21:14 | Yankton, South Dakota, US | |
3144495 | 3144495 | 2022-06-11 | US | South Dakota | Yankton | 46135 | 5992 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-06-12 04:20:53 | Yankton, South Dakota, US | |
1947411 | 1947411 | 2022-06-10 | US | South Dakota | Yankton | 46135 | 5992 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-06-11 04:21:01 | Yankton, South Dakota, US | |
3160550 | 3160550 | 2022-06-09 | US | South Dakota | Yankton | 46135 | 5992 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-06-10 04:20:55 | Yankton, South Dakota, US | |
1424017 | 1424017 | 2022-06-08 | US | South Dakota | Yankton | 46135 | 5992 | 59 | 0 | 43.00924485 | -97.39467635 | 2022-06-09 04:20:54 | Yankton, South Dakota, US | |
973454 | 973454 | 2022-06-01 | US | Oklahoma | Beckham | 40009 | 5992 | 106 | 0 | 35.26862449 | -99.68128023 | 2022-06-02 05:20:39 | Beckham, Oklahoma, US | |
231761 | 231761 | 2022-05-31 | US | Oklahoma | Beckham | 40009 | 5992 | 106 | 0 | 35.26862449 | -99.68128023 | 2022-06-01 04:20:55 | Beckham, Oklahoma, US | |
3188526 | 3188526 | 2022-05-30 | US | Oklahoma | Beckham | 40009 | 5992 | 106 | 0 | 35.26862449 | -99.68128023 | 2022-05-31 04:20:51 | Beckham, Oklahoma, US | |
3200675 | 3200675 | 2022-05-29 | US | Oklahoma | Beckham | 40009 | 5992 | 106 | 0 | 35.26862449 | -99.68128023 | 2022-05-30 04:20:50 | Beckham, Oklahoma, US | |
2727553 | 2727553 | 2022-05-28 | US | Oklahoma | Beckham | 40009 | 5992 | 106 | 0 | 35.26862449 | -99.68128023 | 2022-05-29 04:20:53 | Beckham, Oklahoma, US | |
1316734 | 1316734 | 2022-05-27 | US | Oklahoma | Beckham | 40009 | 5992 | 106 | 0 | 35.26862449 | -99.68128023 | 2022-05-28 04:21:07 | Beckham, Oklahoma, US | |
1852526 | 1852526 | 2022-05-26 | US | Oklahoma | Beckham | 40009 | 5992 | 106 | 0 | 35.26862449 | -99.68128023 | 2022-05-27 04:20:56 | Beckham, Oklahoma, US | |
3447443 | 3447443 | 2022-05-11 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-12 04:20:54 | Texas, Oklahoma, US | |
3446586 | 3446586 | 2022-05-11 | US | Minnesota | Meeker | 27093 | 5992 | 75 | 0 | 45.12328869 | -94.52839455 | 2022-05-12 04:20:54 | Meeker, Minnesota, US | |
3538060 | 3538060 | 2022-05-10 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-11 04:20:48 | Texas, Oklahoma, US | |
224595 | 224595 | 2022-05-09 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-10 04:20:50 | Texas, Oklahoma, US | |
2333980 | 2333980 | 2022-05-08 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-09 04:20:54 | Texas, Oklahoma, US | |
362942 | 362942 | 2022-05-07 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-08 04:20:49 | Texas, Oklahoma, US | |
1400293 | 1400293 | 2022-05-06 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-07 04:21:09 | Texas, Oklahoma, US | |
2600648 | 2600648 | 2022-05-05 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-06 04:21:00 | Texas, Oklahoma, US | |
3268097 | 3268097 | 2022-05-04 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-05 04:20:55 | Texas, Oklahoma, US | |
1574736 | 1574736 | 2022-05-03 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-04 04:20:59 | Texas, Oklahoma, US | |
465996 | 465996 | 2022-05-02 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-03 04:21:00 | Texas, Oklahoma, US | |
3918635 | 3918635 | 2022-05-01 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-02 04:21:10 | Texas, Oklahoma, US | |
2843439 | 2843439 | 2022-04-30 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-05-01 04:20:57 | Texas, Oklahoma, US | |
1159752 | 1159752 | 2022-04-29 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-30 04:21:05 | Texas, Oklahoma, US | |
1698934 | 1698934 | 2022-04-28 | US | Oklahoma | Texas | 40139 | 5992 | 54 | 0 | 36.74777635 | -101.4889765 | 2022-04-29 04:20:59 | Texas, Oklahoma, US | |
2309266 | 2309266 | 2022-04-20 | US | Missouri | Washington | 29221 | 5992 | 140 | 0 | 37.96130078 | -90.87948158 | 2022-04-21 04:20:46 | Washington, Missouri, US | |
2253405 | 2253405 | 2022-04-19 | US | Missouri | Washington | 29221 | 5992 | 140 | 0 | 37.96130078 | -90.87948158 | 2022-04-20 04:20:45 | Washington, Missouri, US | |
1847955 | 1847955 | 2022-04-18 | US | Missouri | Washington | 29221 | 5992 | 140 | 0 | 37.96130078 | -90.87948158 | 2022-04-19 04:21:00 | Washington, Missouri, 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]);