johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
130 rows where confirmed = 5315 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 118
- Russia 5
- Bulgaria 1
- Colombia 1
- Germany 1
- Japan 1
- Liberia 1
- Netherlands 1
- New Zealand 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954738 | 2954738 | 2022-12-20 | US | Virginia | Grayson | 51077 | 5315 | 89 | 0 | 36.65677234 | -81.23215889 | 2022-12-21 04:21:03 | Grayson, Virginia, US | |
1149985 | 1149985 | 2022-12-12 | US | Illinois | Piatt | 17147 | 5315 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-12-13 04:21:01 | Piatt, Illinois, US | |
3555000 | 3555000 | 2022-11-27 | US | Virginia | Goochland | 51075 | 5315 | 61 | 0 | 37.71714806 | -77.90381514 | 2022-11-28 04:21:02 | Goochland, Virginia, US | |
2103480 | 2103480 | 2022-11-26 | US | Virginia | Goochland | 51075 | 5315 | 61 | 0 | 37.71714806 | -77.90381514 | 2022-11-27 04:21:05 | Goochland, Virginia, US | |
490971 | 490971 | 2022-11-25 | US | Virginia | Goochland | 51075 | 5315 | 61 | 0 | 37.71714806 | -77.90381514 | 2022-11-26 04:21:11 | Goochland, Virginia, US | |
312909 | 312909 | 2022-11-13 | US | Illinois | Johnson | 17087 | 5315 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-11-14 04:21:09 | Johnson, Illinois, US | |
64070 | 64070 | 2022-11-12 | US | Illinois | Johnson | 17087 | 5315 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-11-13 04:21:14 | Johnson, Illinois, US | |
2929998 | 2929998 | 2022-11-11 | US | Puerto Rico | Penuelas | 72111 | 5315 | 0 | 0 | 18.059645 | -66.721572 | 2022-11-12 04:20:41 | Penuelas, Puerto Rico, US | |
2928232 | 2928232 | 2022-11-11 | US | Illinois | Johnson | 17087 | 5315 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-11-12 04:20:41 | Johnson, Illinois, US | |
2507068 | 2507068 | 2022-11-10 | US | Illinois | Johnson | 17087 | 5315 | 42 | 0 | 37.45939802 | -88.88165419 | 2022-11-11 04:21:22 | Johnson, Illinois, US | |
199831 | 199831 | 2022-10-19 | US | Maine | Washington | 23029 | 5315 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-10-20 04:22:59 | Washington, Maine, US | |
2377556 | 2377556 | 2022-09-29 | US | Montana | Lincoln | 30053 | 5315 | 91 | 0 | 48.54265777 | -115.4046155 | 2022-09-30 04:23:09 | Lincoln, Montana, US | |
1562107 | 1562107 | 2022-09-28 | US | Montana | Lincoln | 30053 | 5315 | 91 | 0 | 48.54265777 | -115.4046155 | 2022-09-29 04:22:34 | Lincoln, Montana, US | |
1560587 | 1560587 | 2022-09-28 | US | Arkansas | Hempstead | 5057 | 5315 | 75 | 0 | 33.73325583 | -93.66935133 | 2022-09-29 04:22:34 | Hempstead, Arkansas, US | |
3996650 | 3996650 | 2022-09-27 | US | Montana | Lincoln | 30053 | 5315 | 91 | 0 | 48.54265777 | -115.4046155 | 2022-09-28 04:23:01 | Lincoln, Montana, US | |
2770978 | 2770978 | 2022-09-26 | US | Montana | Lincoln | 30053 | 5315 | 91 | 0 | 48.54265777 | -115.4046155 | 2022-09-27 04:23:01 | Lincoln, Montana, US | |
1978631 | 1978631 | 2022-09-25 | US | Montana | Lincoln | 30053 | 5315 | 91 | 0 | 48.54265777 | -115.4046155 | 2022-09-26 04:20:52 | Lincoln, Montana, US | |
2651798 | 2651798 | 2022-09-24 | US | Montana | Lincoln | 30053 | 5315 | 91 | 0 | 48.54265777 | -115.4046155 | 2022-09-25 04:23:31 | Lincoln, Montana, US | |
386238 | 386238 | 2022-09-23 | US | Montana | Lincoln | 30053 | 5315 | 91 | 0 | 48.54265777 | -115.4046155 | 2022-09-24 04:21:40 | Lincoln, Montana, US | |
3769190 | 3769190 | 2022-09-11 | US | Virginia | Bristol | 51520 | 5315 | 86 | 0 | 36.6163024 | -82.16359122 | 2022-09-12 04:20:58 | Bristol, Virginia, US | |
3827765 | 3827765 | 2022-09-10 | US | Virginia | Bristol | 51520 | 5315 | 86 | 0 | 36.6163024 | -82.16359122 | 2022-09-11 04:20:50 | Bristol, Virginia, US | |
966222 | 966222 | 2022-09-09 | US | Virginia | Bristol | 51520 | 5315 | 86 | 0 | 36.6163024 | -82.16359122 | 2022-09-10 04:21:10 | Bristol, Virginia, US | |
3548036 | 3548036 | 2022-09-01 | US | Arkansas | Sharp | 5135 | 5315 | 113 | 0 | 36.16258158 | -91.47819342 | 2022-09-02 04:21:07 | Sharp, Arkansas, US | |
1880299 | 1880299 | 2022-08-28 | US | Virginia | Buchanan | 51027 | 5315 | 130 | 0 | 37.26818323 | -82.03749726 | 2022-08-29 04:21:06 | Buchanan, Virginia, US | |
1877503 | 1877503 | 2022-08-28 | US | Arkansas | Phillips | 5107 | 5315 | 101 | 0 | 34.43268455 | -90.84800154 | 2022-08-29 04:21:06 | Phillips, Arkansas, US | |
2099426 | 2099426 | 2022-08-27 | US | Virginia | Buchanan | 51027 | 5315 | 130 | 0 | 37.26818323 | -82.03749726 | 2022-08-28 04:21:02 | Buchanan, Virginia, US | |
1535241 | 1535241 | 2022-08-26 | US | Virginia | Buchanan | 51027 | 5315 | 130 | 0 | 37.26818323 | -82.03749726 | 2022-08-27 04:20:57 | Buchanan, Virginia, US | |
2364105 | 2364105 | 2022-08-19 | US | Colorado | Chaffee | 8015 | 5315 | 52 | 0 | 38.74745778 | -106.1926573 | 2022-08-20 04:21:01 | Chaffee, Colorado, US | |
1100597 | 1100597 | 2022-08-03 | US | Ohio | Holmes | 39075 | 5315 | 185 | 0 | 40.56163713 | -81.92635677 | 2022-08-04 04:20:58 | Holmes, Ohio, US | |
1407522 | 1407522 | 2022-08-02 | US | Ohio | Holmes | 39075 | 5315 | 185 | 0 | 40.56163713 | -81.92635677 | 2022-08-03 04:20:59 | Holmes, Ohio, US | |
3619560 | 3619560 | 2022-08-01 | US | Ohio | Holmes | 39075 | 5315 | 185 | 0 | 40.56163713 | -81.92635677 | 2022-08-02 04:20:53 | Holmes, Ohio, US | |
3874040 | 3874040 | 2022-07-31 | US | Ohio | Holmes | 39075 | 5315 | 185 | 0 | 40.56163713 | -81.92635677 | 2022-08-01 04:21:03 | Holmes, Ohio, US | |
676794 | 676794 | 2022-07-30 | US | Ohio | Holmes | 39075 | 5315 | 185 | 0 | 40.56163713 | -81.92635677 | 2022-07-31 04:21:02 | Holmes, Ohio, US | |
1785993 | 1785993 | 2022-07-29 | US | Ohio | Holmes | 39075 | 5315 | 185 | 0 | 40.56163713 | -81.92635677 | 2022-07-30 04:20:42 | Holmes, Ohio, US | |
1068356 | 1068356 | 2022-07-28 | US | Ohio | Holmes | 39075 | 5315 | 185 | 0 | 40.56163713 | -81.92635677 | 2022-07-29 04:20:45 | Holmes, Ohio, US | |
897963 | 897963 | 2022-07-24 | US | Mississippi | Jasper | 28061 | 5315 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-07-25 04:20:51 | Jasper, Mississippi, US | |
92957 | 92957 | 2022-07-23 | US | Mississippi | Jasper | 28061 | 5315 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-07-24 04:20:47 | Jasper, Mississippi, US | |
901979 | 901979 | 2022-07-22 | US | Mississippi | Jasper | 28061 | 5315 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-07-23 04:20:53 | Jasper, Mississippi, US | |
672115 | 672115 | 2022-07-21 | US | Mississippi | Jasper | 28061 | 5315 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-07-22 04:21:15 | Jasper, Mississippi, US | |
1610078 | 1610078 | 2022-07-20 | US | Mississippi | Jasper | 28061 | 5315 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-07-21 04:21:10 | Jasper, Mississippi, US | |
960711 | 960711 | 2022-07-19 | US | Mississippi | Jasper | 28061 | 5315 | 75 | 0 | 32.01922104 | -89.11786866 | 2022-07-20 04:20:59 | Jasper, Mississippi, US | |
3397949 | 3397949 | 2022-06-18 | US | Arkansas | Randolph | 5121 | 5315 | 89 | 0 | 36.3415714 | -91.02455531 | 2022-06-19 04:20:51 | Randolph, Arkansas, US | |
3000448 | 3000448 | 2022-05-24 | US | Indiana | Sullivan | 18153 | 5315 | 76 | 0 | 39.08952258 | -87.41414469 | 2022-05-25 04:20:56 | Sullivan, Indiana, US | |
3594169 | 3594169 | 2022-05-23 | US | Indiana | Sullivan | 18153 | 5315 | 76 | 0 | 39.08952258 | -87.41414469 | 2022-05-24 04:20:57 | Sullivan, Indiana, US | |
3919586 | 3919586 | 2022-05-01 | US | Wisconsin | Iowa | 55049 | 5315 | 28 | 0 | 43.00050278 | -90.13469017 | 2022-05-02 04:21:10 | Iowa, Wisconsin, US | |
2844390 | 2844390 | 2022-04-30 | US | Wisconsin | Iowa | 55049 | 5315 | 28 | 0 | 43.00050278 | -90.13469017 | 2022-05-01 04:20:57 | Iowa, Wisconsin, US | |
1160703 | 1160703 | 2022-04-29 | US | Wisconsin | Iowa | 55049 | 5315 | 28 | 0 | 43.00050278 | -90.13469017 | 2022-04-30 04:21:05 | Iowa, Wisconsin, US | |
3206711 | 3206711 | 2022-04-11 | US | American Samoa | 60 | 5315 | 11 | 0 | -14.270999999999999 | -170.132 | 2022-04-12 04:20:49 | American Samoa, US | ||
1543382 | 1543382 | 2022-03-31 | US | Virginia | Waynesboro | 51820 | 5315 | 60 | 0 | 38.06451466 | -78.90293905 | 2022-04-01 04:20:28 | Waynesboro, Virginia, US | |
1659507 | 1659507 | 2022-03-19 | US | Texas | Gillespie | 48171 | 5315 | 107 | 0 | 30.31824095 | -98.94676915 | 2022-03-20 04:20:45 | Gillespie, Texas, US | |
339033 | 339033 | 2022-03-18 | US | Texas | Gillespie | 48171 | 5315 | 107 | 0 | 30.31824095 | -98.94676915 | 2022-03-19 04:20:47 | Gillespie, Texas, US | |
1995874 | 1995874 | 2022-03-01 | US | Texas | San Jacinto | 48407 | 5315 | 100 | 0 | 30.57933681 | -95.16260304 | 2022-03-02 04:21:07 | San Jacinto, Texas, US | |
1298566 | 1298566 | 2022-02-17 | US | Arkansas | Ouachita | 5103 | 5315 | 93 | 0 | 33.58839816 | -92.87795984 | 2022-02-18 04:21:04 | Ouachita, Arkansas, US | |
316393 | 316393 | 2022-02-12 | US | Arkansas | Conway | 5029 | 5315 | 52 | 0 | 35.26205537 | -92.70506566 | 2022-02-13 04:21:00 | Conway, Arkansas, US | |
1464902 | 1464902 | 2022-02-10 | US | Georgia | Haralson | 13143 | 5315 | 150 | 0 | 33.79602175 | -85.21005667 | 2022-02-11 04:21:09 | Haralson, Georgia, US | |
1962042 | 1962042 | 2022-01-20 | US | Kentucky | Woodford | 21239 | 5315 | 39 | 0 | 38.04178222 | -84.7417556 | 2022-01-21 04:21:09 | Woodford, Kentucky, US | |
1474843 | 1474843 | 2022-01-17 | US | Puerto Rico | Canovanas | 72029 | 5315 | 0 | 0 | 18.328802 | -65.887612 | 2022-01-18 04:21:04 | Canovanas, Puerto Rico, US | |
558309 | 558309 | 2022-01-16 | US | West Virginia | Upshur | 54097 | 5315 | 77 | 0 | 38.89285061 | -80.23689136 | 2022-01-17 04:21:08 | Upshur, West Virginia, US | |
3614087 | 3614087 | 2022-01-12 | US | Illinois | McDonough | 17109 | 5315 | 74 | 0 | 40.45674722 | -90.67775541 | 2022-01-13 08:00:09 | McDonough, Illinois, US | |
1744021 | 1744021 | 2021-12-05 | US | West Virginia | Greenbrier | 54025 | 5315 | 109 | 0 | 37.9463652 | -80.45335881 | 2021-12-06 04:22:34 | Greenbrier, West Virginia, US | |
449872 | 449872 | 2021-11-17 | US | Ohio | Ottawa | 39123 | 5315 | 103 | 0 | 41.53781826 | -83.0940185 | 2021-11-18 04:21:33 | Ottawa, Ohio, US | |
716386 | 716386 | 2021-11-12 | US | Missouri | Laclede | 29105 | 5315 | 129 | 0 | 37.65896829 | -92.5888493 | 2021-11-13 04:21:38 | Laclede, Missouri, US | |
3123957 | 3123957 | 2021-11-05 | US | Ohio | Champaign | 39021 | 5315 | 84 | 0 | 40.13923427 | -83.76875242 | 2021-11-06 04:21:51 | Champaign, Ohio, US | |
443491 | 443491 | 2021-10-20 | New Zealand | 5315 | 30 | 0 | -40.9006 | 174.886 | 2021-10-21 04:21:18 | New Zealand | ||||
2043839 | 2043839 | 2021-10-18 | Japan | Ehime | 5315 | 82 | 0 | 33.624835 | 132.856842 | 2021-10-19 04:20:54 | Ehime, Japan | |||
3930993 | 3930993 | 2021-10-02 | US | Tennessee | Henry | 47079 | 5315 | 78 | 0 | 36.33160906 | -88.30121797 | 2021-10-03 04:21:24 | Henry, Tennessee, US | |
3011685 | 3011685 | 2021-09-22 | US | Alabama | Chambers | 1017 | 5315 | 133 | 0 | 32.91360079 | -85.39072749 | 2021-09-23 04:21:43 | Chambers, Alabama, US | |
3975678 | 3975678 | 2021-09-03 | US | Indiana | Montgomery | 18107 | 5315 | 96 | 0 | 40.04034823 | -86.89335024 | 2021-09-04 04:21:28 | Montgomery, Indiana, US | |
181377 | 181377 | 2021-09-02 | US | Virginia | Henry | 51089 | 5315 | 130 | 0 | 36.68542395 | -79.87634026 | 2021-09-03 04:21:20 | Henry, Virginia, US | |
32920 | 32920 | 2021-08-25 | US | Arkansas | Miller | 5091 | 5315 | 39 | 0 | 33.31403423 | -93.89285258 | 2021-08-26 04:21:28 | Miller, Arkansas, US | |
512066 | 512066 | 2021-08-19 | US | Alabama | Escambia | 1053 | 5315 | 85 | 0 | 31.1256789 | -87.15918694 | 2021-08-20 04:21:33 | Escambia, Alabama, US | |
246262 | 246262 | 2021-08-17 | US | Illinois | Henry | 17073 | 5315 | 70 | 0 | 41.3533994 | -90.13296166 | 2021-08-18 04:21:35 | Henry, Illinois, US | |
2352316 | 2352316 | 2021-08-10 | US | Georgia | Thomas | 13275 | 5315 | 129 | 0 | 30.86392347 | -83.91847289 | 2021-08-11 04:21:58 | Thomas, Georgia, US | |
650776 | 650776 | 2021-08-09 | US | Georgia | Habersham | 13137 | 5315 | 166 | 0 | 34.63331566 | -83.53094677 | 2021-08-10 04:21:27 | Habersham, Georgia, US | |
2373806 | 2373806 | 2021-07-20 | US | North Carolina | Carteret | 37031 | 5315 | 57 | 0 | 34.8932941 | -76.54120135 | 2021-07-21 04:21:40 | Carteret, North Carolina, US | |
2676151 | 2676151 | 2021-07-18 | US | North Carolina | McDowell | 37111 | 5315 | 63 | 0 | 35.67736232 | -82.0482425 | 2021-07-19 04:21:24 | McDowell, North Carolina, US | |
2673874 | 2673874 | 2021-07-18 | Liberia | 5315 | 148 | 2715 | 2452 | 6.4280550000000005 | -9.429499 | 2021-07-19 04:21:24 | Liberia | |||
3708463 | 3708463 | 2021-07-17 | US | North Carolina | McDowell | 37111 | 5315 | 63 | 0 | 35.67736232 | -82.0482425 | 2021-07-18 04:22:07 | McDowell, North Carolina, US | |
2949694 | 2949694 | 2021-07-16 | US | North Carolina | McDowell | 37111 | 5315 | 63 | 0 | 35.67736232 | -82.0482425 | 2021-07-17 04:22:22 | McDowell, North Carolina, US | |
3663195 | 3663195 | 2021-07-11 | US | Wyoming | Fremont | 56013 | 5315 | 87 | 0 | 43.04183996 | -108.6296893 | 2021-07-12 04:21:34 | Fremont, Wyoming, US | |
629479 | 629479 | 2021-07-10 | US | Wyoming | Fremont | 56013 | 5315 | 87 | 0 | 43.04183996 | -108.6296893 | 2021-07-11 04:21:43 | Fremont, Wyoming, US | |
833198 | 833198 | 2021-07-09 | US | Wyoming | Fremont | 56013 | 5315 | 87 | 0 | 43.04183996 | -108.6296893 | 2021-07-10 04:21:25 | Fremont, Wyoming, US | |
2593117 | 2593117 | 2021-06-27 | US | Texas | Hill | 48217 | 5315 | 110 | 0 | 31.99045053 | -97.13423143 | 2021-06-28 04:21:29 | Hill, Texas, US | |
3961621 | 3961621 | 2021-06-26 | US | Texas | Hill | 48217 | 5315 | 110 | 0 | 31.99045053 | -97.13423143 | 2021-06-27 04:21:39 | Hill, Texas, US | |
3383782 | 3383782 | 2021-06-13 | US | North Dakota | Morton | 38059 | 5315 | 101 | 0 | 46.71681782 | -101.2822377 | 2021-06-14 04:22:46 | Morton, North Dakota, US | |
1738916 | 1738916 | 2021-06-12 | US | North Dakota | Morton | 38059 | 5315 | 101 | 0 | 46.71681782 | -101.2822377 | 2021-06-13 04:22:44 | Morton, North Dakota, US | |
828613 | 828613 | 2021-06-06 | US | Texas | Burnet | 48053 | 5315 | 66 | 0 | 30.78801353 | -98.181887 | 2021-06-07 04:22:51 | Burnet, Texas, US | |
2589018 | 2589018 | 2021-06-05 | US | Texas | Burnet | 48053 | 5315 | 66 | 0 | 30.78801353 | -98.181887 | 2021-06-06 04:24:03 | Burnet, Texas, US | |
1449360 | 1449360 | 2021-06-03 | US | Georgia | Coffee | 13069 | 5315 | 173 | 0 | 31.54892966 | -82.85492059999999 | 2021-06-04 04:23:37 | Coffee, Georgia, US | |
2106697 | 2106697 | 2021-06-01 | US | Oklahoma | McClain | 40087 | 5315 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-06-02 04:24:34 | McClain, Oklahoma, US | |
1191313 | 1191313 | 2021-05-31 | US | Oklahoma | McClain | 40087 | 5315 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-06-01 04:23:09 | McClain, Oklahoma, US | |
3091990 | 3091990 | 2021-05-30 | US | Oklahoma | McClain | 40087 | 5315 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-05-31 03:08:59 | McClain, Oklahoma, US | |
53359 | 53359 | 2021-05-29 | US | Oklahoma | McClain | 40087 | 5315 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-05-30 04:20:55 | McClain, Oklahoma, US | |
22938 | 22938 | 2021-05-28 | US | Oklahoma | McClain | 40087 | 5315 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-05-29 04:20:41 | McClain, Oklahoma, US | |
1809313 | 1809313 | 2021-05-27 | US | Oklahoma | McClain | 40087 | 5315 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-05-28 04:20:36 | McClain, Oklahoma, US | |
1312736 | 1312736 | 2021-05-26 | US | Oklahoma | McClain | 40087 | 5315 | 73 | 0 | 35.01123903 | -97.44572302 | 2021-05-27 04:20:59 | McClain, Oklahoma, US | |
86670 | 86670 | 2021-05-25 | US | Wisconsin | Shawano | 55115 | 5315 | 84 | 0 | 44.78902246 | -88.76443896 | 2021-05-26 04:20:35 | Shawano, Wisconsin, US | |
2023031 | 2023031 | 2021-04-20 | US | North Carolina | Edgecombe | 37065 | 5315 | 107 | 0 | 35.91230639 | -77.59436892 | 2021-04-21 04:21:14 | Edgecombe, North Carolina, US | |
2646866 | 2646866 | 2021-04-08 | US | Indiana | Noble | 18113 | 5315 | 83 | 0 | 41.39672484 | -85.41966713 | 2021-04-09 04:21:13 | Noble, Indiana, US | |
2782233 | 2782233 | 2021-03-24 | US | Iowa | Warren | 19181 | 5315 | 80 | 0 | 41.33559454 | -93.56007641 | 2021-03-25 05:27:00 | Warren, 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]);