johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
406 rows where confirmed = 1391 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954279 | 2954279 | 2022-12-20 | US | South Dakota | Lyman | 46085 | 1391 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-21 04:21:03 | Lyman, South Dakota, US | |
3176681 | 3176681 | 2022-12-19 | US | South Dakota | Lyman | 46085 | 1391 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-20 04:21:04 | Lyman, South Dakota, US | |
1631198 | 1631198 | 2022-12-18 | US | South Dakota | Lyman | 46085 | 1391 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-19 04:21:03 | Lyman, South Dakota, US | |
506577 | 506577 | 2022-12-17 | US | South Dakota | Lyman | 46085 | 1391 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-18 04:21:03 | Lyman, South Dakota, US | |
3327149 | 3327149 | 2022-12-16 | US | South Dakota | Lyman | 46085 | 1391 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-17 04:21:04 | Lyman, South Dakota, US | |
545661 | 545661 | 2022-12-15 | US | South Dakota | Lyman | 46085 | 1391 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-16 04:21:01 | Lyman, South Dakota, US | |
351189 | 351189 | 2022-12-14 | US | South Dakota | Lyman | 46085 | 1391 | 13 | 0 | 43.89522709 | -99.85201878 | 2022-12-15 04:20:58 | Lyman, South Dakota, US | |
2418204 | 2418204 | 2022-12-05 | US | Virginia | Craig | 51045 | 1391 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-06 04:21:03 | Craig, Virginia, US | |
2139524 | 2139524 | 2022-12-01 | US | Virginia | King and Queen | 51097 | 1391 | 14 | 0 | 37.71044922 | -76.88689628 | 2022-12-02 04:21:07 | King and Queen, Virginia, US | |
293346 | 293346 | 2022-11-15 | US | Kansas | Ottawa | 20143 | 1391 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-11-16 04:21:09 | Ottawa, Kansas, US | |
3598376 | 3598376 | 2022-11-14 | US | Kansas | Ottawa | 20143 | 1391 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-11-15 04:21:16 | Ottawa, Kansas, US | |
313234 | 313234 | 2022-11-13 | US | Kansas | Ottawa | 20143 | 1391 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-11-14 04:21:09 | Ottawa, Kansas, US | |
64395 | 64395 | 2022-11-12 | US | Kansas | Ottawa | 20143 | 1391 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-11-13 04:21:14 | Ottawa, Kansas, US | |
2928557 | 2928557 | 2022-11-11 | US | Kansas | Ottawa | 20143 | 1391 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-11-12 04:20:41 | Ottawa, Kansas, US | |
2507393 | 2507393 | 2022-11-10 | US | Kansas | Ottawa | 20143 | 1391 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-11-11 04:21:22 | Ottawa, Kansas, US | |
2432268 | 2432268 | 2022-11-09 | US | Kansas | Ottawa | 20143 | 1391 | 24 | 0 | 39.13237408 | -97.65020313 | 2022-11-10 04:21:16 | Ottawa, Kansas, US | |
2438527 | 2438527 | 2022-11-07 | China | Gansu | 1391 | 2 | 0 | 35.7518 | 104.2861 | 2022-11-08 04:21:21 | Gansu, China | |||
3997504 | 3997504 | 2022-09-27 | US | South Dakota | Day | 46037 | 1391 | 36 | 0 | 45.367281 | -97.60737498 | 2022-09-28 04:23:01 | Day, South Dakota, US | |
2771832 | 2771832 | 2022-09-26 | US | South Dakota | Day | 46037 | 1391 | 36 | 0 | 45.367281 | -97.60737498 | 2022-09-27 04:23:01 | Day, South Dakota, US | |
1979485 | 1979485 | 2022-09-25 | US | South Dakota | Day | 46037 | 1391 | 36 | 0 | 45.367281 | -97.60737498 | 2022-09-26 04:20:52 | Day, South Dakota, US | |
2652652 | 2652652 | 2022-09-24 | US | South Dakota | Day | 46037 | 1391 | 36 | 0 | 45.367281 | -97.60737498 | 2022-09-25 04:23:31 | Day, South Dakota, US | |
387092 | 387092 | 2022-09-23 | US | South Dakota | Day | 46037 | 1391 | 36 | 0 | 45.367281 | -97.60737498 | 2022-09-24 04:21:40 | Day, South Dakota, US | |
1627158 | 1627158 | 2022-09-22 | US | South Dakota | Day | 46037 | 1391 | 36 | 0 | 45.367281 | -97.60737498 | 2022-09-23 04:23:13 | Day, South Dakota, US | |
1373362 | 1373362 | 2022-09-21 | US | South Dakota | Day | 46037 | 1391 | 36 | 0 | 45.367281 | -97.60737498 | 2022-09-22 04:22:56 | Day, South Dakota, US | |
3777003 | 3777003 | 2022-08-30 | US | Texas | Garza | 48169 | 1391 | 29 | 0 | 33.17969345 | -101.2984114 | 2022-08-31 04:20:57 | Garza, Texas, US | |
1681158 | 1681158 | 2022-08-29 | US | Colorado | Saguache | 8109 | 1391 | 12 | 0 | 38.08054629 | -106.282466 | 2022-08-30 04:21:03 | Saguache, Colorado, US | |
1877642 | 1877642 | 2022-08-28 | US | Colorado | Saguache | 8109 | 1391 | 12 | 0 | 38.08054629 | -106.282466 | 2022-08-29 04:21:06 | Saguache, Colorado, US | |
2096769 | 2096769 | 2022-08-27 | US | Colorado | Saguache | 8109 | 1391 | 12 | 0 | 38.08054629 | -106.282466 | 2022-08-28 04:21:02 | Saguache, Colorado, US | |
1532584 | 1532584 | 2022-08-26 | US | Colorado | Saguache | 8109 | 1391 | 12 | 0 | 38.08054629 | -106.282466 | 2022-08-27 04:20:57 | Saguache, Colorado, US | |
1163157 | 1163157 | 2022-08-18 | US | Montana | Broadwater | 30007 | 1391 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-08-19 04:20:54 | Broadwater, Montana, US | |
3952481 | 3952481 | 2022-08-17 | US | Montana | Broadwater | 30007 | 1391 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-08-18 04:21:11 | Broadwater, Montana, US | |
993880 | 993880 | 2022-08-16 | US | South Dakota | Kingsbury | 46077 | 1391 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-17 04:20:59 | Kingsbury, South Dakota, US | |
992983 | 992983 | 2022-08-16 | US | Montana | Broadwater | 30007 | 1391 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-08-17 04:20:59 | Broadwater, Montana, US | |
2496919 | 2496919 | 2022-08-15 | US | South Dakota | Kingsbury | 46077 | 1391 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-16 04:20:58 | Kingsbury, South Dakota, US | |
2496022 | 2496022 | 2022-08-15 | US | Montana | Broadwater | 30007 | 1391 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-08-16 04:20:58 | Broadwater, Montana, US | |
3650469 | 3650469 | 2022-08-14 | US | South Dakota | Kingsbury | 46077 | 1391 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-15 04:20:59 | Kingsbury, South Dakota, US | |
3649572 | 3649572 | 2022-08-14 | US | Montana | Broadwater | 30007 | 1391 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-08-15 04:20:59 | Broadwater, Montana, US | |
1971475 | 1971475 | 2022-08-13 | US | South Dakota | Kingsbury | 46077 | 1391 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-14 04:20:55 | Kingsbury, South Dakota, US | |
1970578 | 1970578 | 2022-08-13 | US | Montana | Broadwater | 30007 | 1391 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-08-14 04:20:55 | Broadwater, Montana, US | |
2891284 | 2891284 | 2022-08-12 | US | South Dakota | Kingsbury | 46077 | 1391 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-13 04:20:52 | Kingsbury, South Dakota, US | |
2890387 | 2890387 | 2022-08-12 | US | Montana | Broadwater | 30007 | 1391 | 21 | 0 | 46.33277565 | -111.4955813 | 2022-08-13 04:20:52 | Broadwater, Montana, US | |
3911067 | 3911067 | 2022-08-11 | US | Texas | Crane | 48103 | 1391 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-08-12 04:20:54 | Crane, Texas, US | |
3910889 | 3910889 | 2022-08-11 | US | South Dakota | Kingsbury | 46077 | 1391 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-12 04:20:54 | Kingsbury, South Dakota, US | |
1349420 | 1349420 | 2022-08-10 | US | Texas | Goliad | 48175 | 1391 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-08-11 04:20:49 | Goliad, Texas, US | |
1349206 | 1349206 | 2022-08-10 | US | South Dakota | Kingsbury | 46077 | 1391 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-11 04:20:49 | Kingsbury, South Dakota, US | |
1089175 | 1089175 | 2022-08-09 | US | Texas | Goliad | 48175 | 1391 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-08-10 04:20:57 | Goliad, Texas, US | |
1088717 | 1088717 | 2022-08-09 | US | Oregon | Wallowa | 41063 | 1391 | 17 | 0 | 45.57894064 | -117.183538 | 2022-08-10 04:20:57 | Wallowa, Oregon, US | |
1087123 | 1087123 | 2022-08-09 | US | Illinois | Scott | 17171 | 1391 | 13 | 0 | 39.6429169 | -90.47814431 | 2022-08-10 04:20:57 | Scott, Illinois, US | |
3546132 | 3546132 | 2022-08-08 | US | Oregon | Wallowa | 41063 | 1391 | 17 | 0 | 45.57894064 | -117.183538 | 2022-08-09 04:20:34 | Wallowa, Oregon, US | |
3544538 | 3544538 | 2022-08-08 | US | Illinois | Scott | 17171 | 1391 | 13 | 0 | 39.6429169 | -90.47814431 | 2022-08-09 04:20:34 | Scott, Illinois, US | |
1072535 | 1072535 | 2022-08-07 | US | Oregon | Wallowa | 41063 | 1391 | 17 | 0 | 45.57894064 | -117.183538 | 2022-08-08 04:21:08 | Wallowa, Oregon, US | |
1943123 | 1943123 | 2022-08-06 | US | Oregon | Wallowa | 41063 | 1391 | 17 | 0 | 45.57894064 | -117.183538 | 2022-08-07 04:20:54 | Wallowa, Oregon, US | |
882922 | 882922 | 2022-08-05 | US | Oregon | Wallowa | 41063 | 1391 | 17 | 0 | 45.57894064 | -117.183538 | 2022-08-06 04:20:56 | Wallowa, Oregon, US | |
2011333 | 2011333 | 2022-08-04 | US | Oregon | Wallowa | 41063 | 1391 | 17 | 0 | 45.57894064 | -117.183538 | 2022-08-05 04:20:52 | Wallowa, Oregon, US | |
673414 | 673414 | 2022-07-21 | US | Texas | Hartley | 48205 | 1391 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-07-22 04:21:15 | Hartley, Texas, US | |
3081447 | 3081447 | 2022-07-04 | US | Virginia | Norton | 51720 | 1391 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-07-05 04:20:45 | Norton, Virginia, US | |
1769772 | 1769772 | 2022-07-03 | US | North Dakota | Sioux | 38085 | 1391 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-07-04 04:20:54 | Sioux, North Dakota, US | |
3365129 | 3365129 | 2022-07-02 | China | Jiangxi | 1391 | 1 | 0 | 27.614 | 115.7221 | 2022-07-03 04:20:59 | Jiangxi, China | |||
230421 | 230421 | 2022-05-31 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-06-01 04:20:55 | Fremont, Iowa, US | |
3187186 | 3187186 | 2022-05-30 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-05-31 04:20:51 | Fremont, Iowa, US | |
3199335 | 3199335 | 2022-05-29 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-05-30 04:20:50 | Fremont, Iowa, US | |
2726213 | 2726213 | 2022-05-28 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-05-29 04:20:53 | Fremont, Iowa, US | |
1315394 | 1315394 | 2022-05-27 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-05-28 04:21:07 | Fremont, Iowa, US | |
1851186 | 1851186 | 2022-05-26 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-05-27 04:20:56 | Fremont, Iowa, US | |
2049062 | 2049062 | 2022-05-25 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-05-26 04:20:50 | Fremont, Iowa, US | |
623073 | 623073 | 2022-05-22 | US | Iowa | Fremont | 19071 | 1391 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-05-26 04:20:50 | Fremont, Iowa, US | |
360139 | 360139 | 2022-05-07 | China | Hunan | 1391 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-08 04:20:49 | Hunan, China | |||
1397490 | 1397490 | 2022-05-06 | China | Hunan | 1391 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-07 04:21:09 | Hunan, China | |||
2308988 | 2308988 | 2022-04-20 | US | Minnesota | Big Stone | 27011 | 1391 | 8 | 0 | 45.42712824 | -96.41403739 | 2022-04-21 04:20:46 | Big Stone, Minnesota, US | |
264159 | 264159 | 2022-03-15 | US | Oregon | Lake | 41037 | 1391 | 25 | 0 | 42.79246693 | -120.38501629999999 | 2022-03-16 04:20:50 | Lake, Oregon, US | |
3631397 | 3631397 | 2022-03-13 | US | Washington | Ferry | 53019 | 1391 | 28 | 0 | 48.471143100000006 | -118.5154041 | 2022-03-14 04:20:46 | Ferry, Washington, US | |
954305 | 954305 | 2022-03-12 | US | Washington | Ferry | 53019 | 1391 | 28 | 0 | 48.471143100000006 | -118.5154041 | 2022-03-13 04:20:49 | Ferry, Washington, US | |
359766 | 359766 | 2022-03-11 | US | Washington | Ferry | 53019 | 1391 | 28 | 0 | 48.471143100000006 | -118.5154041 | 2022-03-12 04:20:50 | Ferry, Washington, US | |
921045 | 921045 | 2022-03-08 | US | Kansas | Washington | 20201 | 1391 | 20 | 0 | 39.78420784 | -97.08753229999999 | 2022-03-09 04:20:59 | Washington, Kansas, US | |
1549332 | 1549332 | 2022-03-07 | US | Kansas | Washington | 20201 | 1391 | 20 | 0 | 39.78420784 | -97.08753229999999 | 2022-03-08 04:20:54 | Washington, Kansas, US | |
2201001 | 2201001 | 2022-03-06 | US | Kansas | Washington | 20201 | 1391 | 20 | 0 | 39.78420784 | -97.08753229999999 | 2022-03-07 04:20:47 | Washington, Kansas, US | |
2093458 | 2093458 | 2022-03-05 | US | Kansas | Washington | 20201 | 1391 | 20 | 0 | 39.78420784 | -97.08753229999999 | 2022-03-06 04:20:49 | Washington, Kansas, US | |
2667158 | 2667158 | 2022-03-04 | US | Kansas | Washington | 20201 | 1391 | 20 | 0 | 39.78420784 | -97.08753229999999 | 2022-03-05 04:21:10 | Washington, Kansas, US | |
2658745 | 2658745 | 2022-01-31 | US | Idaho | Power | 16077 | 1391 | 18 | 0 | 42.69254894 | -112.83957420000002 | 2022-02-01 04:21:11 | Power, Idaho, US | |
1230488 | 1230488 | 2022-01-24 | US | South Dakota | Hamlin | 46057 | 1391 | 40 | 0 | 44.67385954 | -97.18829593 | 2022-01-25 04:21:05 | Hamlin, South Dakota, US | |
1962337 | 1962337 | 2022-01-20 | US | Minnesota | Wilkin | 27167 | 1391 | 19 | 0 | 46.35721532 | -96.4684375 | 2022-01-21 04:21:09 | Wilkin, Minnesota, US | |
3467653 | 3467653 | 2022-01-18 | US | West Virginia | Calhoun | 54013 | 1391 | 9 | 0 | 38.84315422 | -81.11934872 | 2022-01-19 04:21:23 | Calhoun, West Virginia, US | |
3688266 | 3688266 | 2022-01-13 | US | Georgia | Crawford | 13079 | 1391 | 48 | 0 | 32.71391813 | -83.98061238 | 2022-01-14 04:21:54 | Crawford, Georgia, US | |
2612829 | 2612829 | 2022-01-06 | US | Puerto Rico | Santa Isabel | 72133 | 1391 | 0 | 0 | 17.994525 | -66.388913 | 2022-01-07 04:22:09 | Santa Isabel, Puerto Rico, US | |
2611850 | 2611850 | 2022-01-06 | US | Mississippi | Franklin | 28037 | 1391 | 33 | 0 | 31.47786634 | -90.89672989 | 2022-01-07 04:22:09 | Franklin, Mississippi, US | |
1434219 | 1434219 | 2021-12-28 | US | Michigan | Lake | 26085 | 1391 | 31 | 0 | 43.99050893 | -85.802173 | 2021-12-29 03:21:43 | Lake, Michigan, US | |
732180 | 732180 | 2021-12-27 | US | Michigan | Lake | 26085 | 1391 | 31 | 0 | 43.99050893 | -85.802173 | 2021-12-28 04:21:47 | Lake, Michigan, US | |
3819437 | 3819437 | 2021-12-23 | US | Texas | Archer | 48009 | 1391 | 24 | 0 | 33.61569967 | -98.68754589 | 2021-12-24 04:21:34 | Archer, Texas, US | |
2905509 | 2905509 | 2021-12-19 | US | Mississippi | Choctaw | 28019 | 1391 | 27 | 0 | 33.34598242 | -89.24809382 | 2021-12-20 04:21:43 | Choctaw, Mississippi, US | |
1260582 | 1260582 | 2021-12-18 | US | Mississippi | Choctaw | 28019 | 1391 | 27 | 0 | 33.34598242 | -89.24809382 | 2021-12-19 04:21:11 | Choctaw, Mississippi, US | |
2401925 | 2401925 | 2021-12-17 | US | Texas | Hansford | 48195 | 1391 | 27 | 0 | 36.27743284 | -101.3545796 | 2021-12-18 02:22:20 | Hansford, Texas, US | |
2400610 | 2400610 | 2021-12-17 | US | Mississippi | Choctaw | 28019 | 1391 | 27 | 0 | 33.34598242 | -89.24809382 | 2021-12-18 02:22:20 | Choctaw, Mississippi, US | |
1718486 | 1718486 | 2021-12-16 | US | Nebraska | Wayne | 31179 | 1391 | 7 | 0 | 42.20934475 | -97.11926964 | 2021-12-17 04:22:14 | Wayne, Nebraska, US | |
3499761 | 3499761 | 2021-12-15 | US | Wisconsin | Pepin | 55091 | 1391 | 12 | 0 | 44.58307413 | -91.99949611 | 2021-12-16 04:22:11 | Pepin, Wisconsin, US | |
3498226 | 3498226 | 2021-12-15 | US | Montana | Valley | 30105 | 1391 | 31 | 0 | 48.36435097 | -106.6669635 | 2021-12-16 04:22:11 | Valley, Montana, US | |
1663452 | 1663452 | 2021-12-12 | US | Texas | Blanco | 48031 | 1391 | 28 | 0 | 30.26640707 | -98.3999852 | 2021-12-13 04:22:02 | Blanco, Texas, US | |
1667468 | 1667468 | 2021-12-11 | US | Texas | Blanco | 48031 | 1391 | 28 | 0 | 30.26640707 | -98.3999852 | 2021-12-12 04:22:12 | Blanco, Texas, US | |
1080246 | 1080246 | 2021-12-09 | US | North Carolina | Graham | 37075 | 1391 | 28 | 0 | 35.3506925 | -83.83369267 | 2021-12-10 04:22:28 | Graham, North Carolina, US | |
1078363 | 1078363 | 2021-12-09 | US | Alaska | Southeast Fairbanks | 2240 | 1391 | 12 | 0 | 63.87692095 | -143.2127643 | 2021-12-10 04:22:28 | Southeast Fairbanks, Alaska, US | |
551212 | 551212 | 2021-12-08 | US | Alaska | Southeast Fairbanks | 2240 | 1391 | 12 | 0 | 63.87692095 | -143.2127643 | 2021-12-09 04:22:49 | Southeast Fairbanks, Alaska, 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]);