johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
316 rows where confirmed = 2707 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756112 | 2756112 | 2022-12-29 | US | Texas | Red River | 48387 | 2707 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-30 04:21:04 | Red River, Texas, US | |
1077118 | 1077118 | 2022-12-28 | US | Texas | Red River | 48387 | 2707 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-29 04:21:01 | Red River, Texas, US | |
1631292 | 1631292 | 2022-12-18 | US | Tennessee | Perry | 47135 | 2707 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-19 04:21:03 | Perry, Tennessee, US | |
546105 | 546105 | 2022-12-15 | US | Virginia | Essex | 51057 | 2707 | 41 | 0 | 37.93357639 | -76.94230311 | 2022-12-16 04:21:01 | Essex, Virginia, US | |
1053225 | 1053225 | 2022-11-06 | US | Virginia | Northampton | 51131 | 2707 | 72 | 0 | 37.34062933 | -75.87751591 | 2022-11-07 04:21:26 | Northampton, Virginia, US | |
621249 | 621249 | 2022-11-05 | US | Virginia | Northampton | 51131 | 2707 | 72 | 0 | 37.34062933 | -75.87751591 | 2022-11-06 04:21:24 | Northampton, Virginia, US | |
1025753 | 1025753 | 2022-11-04 | US | Virginia | Northampton | 51131 | 2707 | 72 | 0 | 37.34062933 | -75.87751591 | 2022-11-05 04:21:52 | Northampton, Virginia, US | |
711678 | 711678 | 2022-11-01 | US | Iowa | Mitchell | 19131 | 2707 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-02 04:22:09 | Mitchell, Iowa, US | |
3286127 | 3286127 | 2022-10-31 | US | Iowa | Mitchell | 19131 | 2707 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-01 04:22:36 | Mitchell, Iowa, US | |
321160 | 321160 | 2022-10-30 | US | Iowa | Mitchell | 19131 | 2707 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-10-31 04:21:36 | Mitchell, Iowa, US | |
913436 | 913436 | 2022-10-29 | US | Iowa | Mitchell | 19131 | 2707 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-10-30 04:22:14 | Mitchell, Iowa, US | |
1367705 | 1367705 | 2022-10-28 | US | Iowa | Mitchell | 19131 | 2707 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-10-29 04:21:13 | Mitchell, Iowa, US | |
3039560 | 3039560 | 2022-10-27 | US | Iowa | Mitchell | 19131 | 2707 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-10-28 04:22:31 | Mitchell, Iowa, US | |
539980 | 539980 | 2022-10-26 | US | Iowa | Mitchell | 19131 | 2707 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-10-27 04:22:01 | Mitchell, Iowa, US | |
3995164 | 3995164 | 2022-09-27 | US | Arkansas | Scott | 5127 | 2707 | 45 | 0 | 34.85588887 | -94.0632176 | 2022-09-28 04:23:01 | Scott, Arkansas, US | |
2769492 | 2769492 | 2022-09-26 | US | Arkansas | Scott | 5127 | 2707 | 45 | 0 | 34.85588887 | -94.0632176 | 2022-09-27 04:23:01 | Scott, Arkansas, US | |
2017520 | 2017520 | 2022-09-20 | US | Georgia | Dooly | 13093 | 2707 | 72 | 0 | 32.15630737 | -83.79746561 | 2022-09-21 04:23:22 | Dooly, Georgia, US | |
3571393 | 3571393 | 2022-09-19 | US | Georgia | Dooly | 13093 | 2707 | 72 | 0 | 32.15630737 | -83.79746561 | 2022-09-20 04:22:48 | Dooly, Georgia, US | |
420132 | 420132 | 2022-09-18 | US | Georgia | Dooly | 13093 | 2707 | 72 | 0 | 32.15630737 | -83.79746561 | 2022-09-19 04:21:49 | Dooly, Georgia, US | |
3374156 | 3374156 | 2022-09-17 | US | Georgia | Dooly | 13093 | 2707 | 72 | 0 | 32.15630737 | -83.79746561 | 2022-09-18 04:22:50 | Dooly, Georgia, US | |
2356264 | 2356264 | 2022-09-16 | US | Georgia | Dooly | 13093 | 2707 | 72 | 0 | 32.15630737 | -83.79746561 | 2022-09-17 04:20:19 | Dooly, Georgia, US | |
3987421 | 3987421 | 2022-09-15 | US | Georgia | Dooly | 13093 | 2707 | 72 | 0 | 32.15630737 | -83.79746561 | 2022-09-16 04:21:19 | Dooly, Georgia, US | |
1889938 | 1889938 | 2022-09-14 | US | Georgia | Dooly | 13093 | 2707 | 72 | 0 | 32.15630737 | -83.79746561 | 2022-09-15 04:21:02 | Dooly, Georgia, US | |
1251362 | 1251362 | 2022-08-23 | US | Colorado | Bent | 8011 | 2707 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-24 04:20:46 | Bent, Colorado, US | |
2853466 | 2853466 | 2022-08-22 | US | Colorado | Bent | 8011 | 2707 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-23 04:20:56 | Bent, Colorado, US | |
2403438 | 2403438 | 2022-08-21 | US | Colorado | Bent | 8011 | 2707 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-22 04:20:38 | Bent, Colorado, US | |
3798516 | 3798516 | 2022-08-20 | US | Colorado | Bent | 8011 | 2707 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-21 04:20:44 | Bent, Colorado, US | |
2364102 | 2364102 | 2022-08-19 | US | Colorado | Bent | 8011 | 2707 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-20 04:21:01 | Bent, Colorado, US | |
1161773 | 1161773 | 2022-08-18 | US | Colorado | Bent | 8011 | 2707 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-08-19 04:20:54 | Bent, Colorado, US | |
2597434 | 2597434 | 2022-07-25 | US | Virginia | Richmond | 51159 | 2707 | 25 | 0 | 37.937575 | -76.72920628 | 2022-07-26 04:20:58 | Richmond, Virginia, US | |
896665 | 896665 | 2022-07-24 | US | Arkansas | Pike | 5109 | 2707 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-25 04:20:51 | Pike, Arkansas, US | |
91659 | 91659 | 2022-07-23 | US | Arkansas | Pike | 5109 | 2707 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-24 04:20:47 | Pike, Arkansas, US | |
900681 | 900681 | 2022-07-22 | US | Arkansas | Pike | 5109 | 2707 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-23 04:20:53 | Pike, Arkansas, US | |
3406943 | 3406943 | 2022-07-17 | US | Kentucky | Wolfe | 21237 | 2707 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-18 04:20:59 | Wolfe, Kentucky, US | |
2153143 | 2153143 | 2022-07-16 | US | Kentucky | Wolfe | 21237 | 2707 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-17 04:21:15 | Wolfe, Kentucky, US | |
2420376 | 2420376 | 2022-07-15 | US | Kentucky | Wolfe | 21237 | 2707 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-16 04:21:05 | Wolfe, Kentucky, US | |
3430451 | 3430451 | 2022-07-14 | US | Kentucky | Wolfe | 21237 | 2707 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-15 04:20:53 | Wolfe, Kentucky, US | |
3112535 | 3112535 | 2022-07-13 | US | Texas | Childress | 48075 | 2707 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-07-14 04:20:57 | Childress, Texas, US | |
3110971 | 3110971 | 2022-07-13 | US | Kentucky | Wolfe | 21237 | 2707 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-14 04:20:57 | Wolfe, Kentucky, US | |
631394 | 631394 | 2022-07-12 | US | Kentucky | Wolfe | 21237 | 2707 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-13 04:20:58 | Wolfe, Kentucky, US | |
1213038 | 1213038 | 2022-07-11 | US | Kentucky | Wolfe | 21237 | 2707 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-07-12 04:20:51 | Wolfe, Kentucky, US | |
2744382 | 2744382 | 2022-07-07 | US | Virginia | Lunenburg | 51111 | 2707 | 39 | 0 | 36.94618528 | -78.24133319 | 2022-07-08 04:20:56 | Lunenburg, Virginia, US | |
1202402 | 1202402 | 2022-07-06 | US | Oklahoma | Pushmataha | 40127 | 2707 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-07-07 04:20:55 | Pushmataha, Oklahoma, US | |
3969145 | 3969145 | 2022-07-05 | US | Oklahoma | Pushmataha | 40127 | 2707 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-07-06 04:20:58 | Pushmataha, Oklahoma, US | |
3967755 | 3967755 | 2022-07-05 | US | Iowa | Humboldt | 19091 | 2707 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-06 04:20:58 | Humboldt, Iowa, US | |
3081381 | 3081381 | 2022-07-04 | US | Virginia | Charlotte | 51037 | 2707 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-07-05 04:20:45 | Charlotte, Virginia, US | |
3080656 | 3080656 | 2022-07-04 | US | Oklahoma | Pushmataha | 40127 | 2707 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-07-05 04:20:45 | Pushmataha, Oklahoma, US | |
3079266 | 3079266 | 2022-07-04 | US | Iowa | Humboldt | 19091 | 2707 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-05 04:20:45 | Humboldt, Iowa, US | |
1769938 | 1769938 | 2022-07-03 | US | Oklahoma | Pushmataha | 40127 | 2707 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-07-04 04:20:54 | Pushmataha, Oklahoma, US | |
1768548 | 1768548 | 2022-07-03 | US | Iowa | Humboldt | 19091 | 2707 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-04 04:20:54 | Humboldt, Iowa, US | |
3367924 | 3367924 | 2022-07-02 | US | Oklahoma | Pushmataha | 40127 | 2707 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-07-03 04:20:59 | Pushmataha, Oklahoma, US | |
3366534 | 3366534 | 2022-07-02 | US | Iowa | Humboldt | 19091 | 2707 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-03 04:20:59 | Humboldt, Iowa, US | |
596253 | 596253 | 2022-07-01 | US | Oklahoma | Pushmataha | 40127 | 2707 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-07-02 04:21:16 | Pushmataha, Oklahoma, US | |
594863 | 594863 | 2022-07-01 | US | Iowa | Humboldt | 19091 | 2707 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-02 04:21:16 | Humboldt, Iowa, US | |
3942654 | 3942654 | 2022-06-30 | US | Oklahoma | Pushmataha | 40127 | 2707 | 45 | 0 | 34.41635232 | -95.37603505 | 2022-07-01 04:21:10 | Pushmataha, Oklahoma, US | |
3941264 | 3941264 | 2022-06-30 | US | Iowa | Humboldt | 19091 | 2707 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-07-01 04:21:10 | Humboldt, Iowa, US | |
2491222 | 2491222 | 2022-06-29 | US | Iowa | Humboldt | 19091 | 2707 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-06-30 04:21:01 | Humboldt, Iowa, US | |
475830 | 475830 | 2022-06-26 | US | Alabama | Lowndes | 1085 | 2707 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-06-27 04:21:00 | Lowndes, Alabama, US | |
939205 | 939205 | 2022-06-25 | US | Alabama | Lowndes | 1085 | 2707 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-06-26 04:21:02 | Lowndes, Alabama, US | |
3347025 | 3347025 | 2022-06-24 | US | Alabama | Lowndes | 1085 | 2707 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-06-25 04:20:57 | Lowndes, Alabama, US | |
562186 | 562186 | 2022-06-16 | US | Virginia | Nelson | 51125 | 2707 | 37 | 0 | 37.78790447 | -78.88498513 | 2022-06-17 04:20:56 | Nelson, Virginia, US | |
1422105 | 1422105 | 2022-06-08 | US | Illinois | Jasper | 17079 | 2707 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-06-09 04:20:54 | Jasper, Illinois, US | |
1421754 | 1421754 | 2022-06-08 | US | Colorado | Prowers | 8099 | 2707 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-06-09 04:20:54 | Prowers, Colorado, US | |
3726868 | 3726868 | 2022-06-07 | US | Colorado | Prowers | 8099 | 2707 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-06-08 04:20:55 | Prowers, Colorado, US | |
3187491 | 3187491 | 2022-05-30 | US | Louisiana | Catahoula | 22025 | 2707 | 55 | 0 | 31.66778967 | -91.84526385 | 2022-05-31 04:20:51 | Catahoula, Louisiana, US | |
3199640 | 3199640 | 2022-05-29 | US | Louisiana | Catahoula | 22025 | 2707 | 55 | 0 | 31.66778967 | -91.84526385 | 2022-05-30 04:20:50 | Catahoula, Louisiana, US | |
2726518 | 2726518 | 2022-05-28 | US | Louisiana | Catahoula | 22025 | 2707 | 55 | 0 | 31.66778967 | -91.84526385 | 2022-05-29 04:20:53 | Catahoula, Louisiana, US | |
1316948 | 1316948 | 2022-05-27 | US | Puerto Rico | Hormigueros | 72067 | 2707 | 0 | 0 | 18.134532 | -67.113972 | 2022-05-28 04:21:07 | Hormigueros, Puerto Rico, US | |
1315699 | 1315699 | 2022-05-27 | US | Louisiana | Catahoula | 22025 | 2707 | 55 | 0 | 31.66778967 | -91.84526385 | 2022-05-28 04:21:07 | Catahoula, Louisiana, US | |
3000483 | 3000483 | 2022-05-24 | US | Iowa | Chickasaw | 19037 | 2707 | 32 | 0 | 43.06001295 | -92.31773347 | 2022-05-25 04:20:56 | Chickasaw, Iowa, US | |
3594204 | 3594204 | 2022-05-23 | US | Iowa | Chickasaw | 19037 | 2707 | 32 | 0 | 43.06001295 | -92.31773347 | 2022-05-24 04:20:57 | Chickasaw, Iowa, US | |
1112876 | 1112876 | 2022-05-21 | US | Virginia | Amelia | 51007 | 2707 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-05-22 04:20:52 | Amelia, Virginia, US | |
1110752 | 1110752 | 2022-05-21 | US | Iowa | Chickasaw | 19037 | 2707 | 32 | 0 | 43.06001295 | -92.31773347 | 2022-05-22 04:20:52 | Chickasaw, Iowa, US | |
1172500 | 1172500 | 2022-05-20 | US | Virginia | Amelia | 51007 | 2707 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-05-21 04:20:58 | Amelia, Virginia, US | |
1170376 | 1170376 | 2022-05-20 | US | Iowa | Chickasaw | 19037 | 2707 | 32 | 0 | 43.06001295 | -92.31773347 | 2022-05-21 04:20:58 | Chickasaw, Iowa, US | |
3897139 | 3897139 | 2022-05-19 | US | Iowa | Chickasaw | 19037 | 2707 | 32 | 0 | 43.06001295 | -92.31773347 | 2022-05-20 04:20:57 | Chickasaw, Iowa, US | |
1185923 | 1185923 | 2022-05-18 | US | Iowa | Chickasaw | 19037 | 2707 | 32 | 0 | 43.06001295 | -92.31773347 | 2022-05-19 04:20:54 | Chickasaw, Iowa, US | |
2086176 | 2086176 | 2022-05-15 | US | New Mexico | Torrance | 35057 | 2707 | 56 | 0 | 34.64048375 | -105.8508949 | 2022-05-16 04:20:47 | Torrance, New Mexico, US | |
3356886 | 3356886 | 2022-05-14 | US | New Mexico | Torrance | 35057 | 2707 | 56 | 0 | 34.64048375 | -105.8508949 | 2022-05-15 04:20:53 | Torrance, New Mexico, US | |
661553 | 661553 | 2022-05-13 | US | Texas | Trinity | 48455 | 2707 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-05-14 04:20:48 | Trinity, Texas, US | |
660531 | 660531 | 2022-05-13 | US | New Mexico | Torrance | 35057 | 2707 | 56 | 0 | 34.64048375 | -105.8508949 | 2022-05-14 04:20:48 | Torrance, New Mexico, US | |
658098 | 658098 | 2022-05-13 | China | Beijing | 2707 | 9 | 0 | 40.1824 | 116.4142 | 2022-05-14 04:20:48 | Beijing, China | |||
1950245 | 1950245 | 2022-04-12 | US | Minnesota | Koochiching | 27071 | 2707 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-04-13 04:21:03 | Koochiching, Minnesota, US | |
3207998 | 3207998 | 2022-04-11 | US | Minnesota | Koochiching | 27071 | 2707 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-04-12 04:20:49 | Koochiching, Minnesota, US | |
1439962 | 1439962 | 2022-03-28 | US | Virginia | Nelson | 51125 | 2707 | 33 | 0 | 37.78790447 | -78.88498513 | 2022-03-29 04:20:46 | Nelson, Virginia, US | |
878466 | 878466 | 2022-03-27 | US | New Mexico | Los Alamos | 35028 | 2707 | 14 | 0 | 35.86631386 | -106.31349850000001 | 2022-03-28 04:20:33 | Los Alamos, New Mexico, US | |
2165749 | 2165749 | 2022-03-26 | US | New Mexico | Los Alamos | 35028 | 2707 | 14 | 0 | 35.86631386 | -106.31349850000001 | 2022-03-27 04:20:47 | Los Alamos, New Mexico, US | |
1722685 | 1722685 | 2022-03-25 | US | New Mexico | Los Alamos | 35028 | 2707 | 14 | 0 | 35.86631386 | -106.31349850000001 | 2022-03-26 04:20:23 | Los Alamos, New Mexico, US | |
1470302 | 1470302 | 2022-03-24 | US | New Mexico | Los Alamos | 35028 | 2707 | 14 | 0 | 35.86631386 | -106.31349850000001 | 2022-03-25 04:20:46 | Los Alamos, New Mexico, US | |
920931 | 920931 | 2022-03-08 | US | Iowa | Union | 19175 | 2707 | 49 | 0 | 41.0277278 | -94.24234847 | 2022-03-09 04:20:59 | Union, Iowa, US | |
1549218 | 1549218 | 2022-03-07 | US | Iowa | Union | 19175 | 2707 | 49 | 0 | 41.0277278 | -94.24234847 | 2022-03-08 04:20:54 | Union, Iowa, US | |
2200887 | 2200887 | 2022-03-06 | US | Iowa | Union | 19175 | 2707 | 49 | 0 | 41.0277278 | -94.24234847 | 2022-03-07 04:20:47 | Union, Iowa, US | |
2200436 | 2200436 | 2022-03-06 | US | Georgia | Early | 13099 | 2707 | 60 | 0 | 31.32155345 | -84.90255207 | 2022-03-07 04:20:47 | Early, Georgia, US | |
2093344 | 2093344 | 2022-03-05 | US | Iowa | Union | 19175 | 2707 | 49 | 0 | 41.0277278 | -94.24234847 | 2022-03-06 04:20:49 | Union, Iowa, US | |
2092893 | 2092893 | 2022-03-05 | US | Georgia | Early | 13099 | 2707 | 60 | 0 | 31.32155345 | -84.90255207 | 2022-03-06 04:20:49 | Early, Georgia, US | |
2667044 | 2667044 | 2022-03-04 | US | Iowa | Union | 19175 | 2707 | 49 | 0 | 41.0277278 | -94.24234847 | 2022-03-05 04:21:10 | Union, Iowa, US | |
2666593 | 2666593 | 2022-03-04 | US | Georgia | Early | 13099 | 2707 | 60 | 0 | 31.32155345 | -84.90255207 | 2022-03-05 04:21:10 | Early, Georgia, US | |
1646718 | 1646718 | 2022-03-03 | US | North Carolina | Perquimans | 37143 | 2707 | 17 | 0 | 36.17847453 | -76.40603143 | 2022-03-04 04:21:09 | Perquimans, North Carolina, US | |
1645609 | 1645609 | 2022-03-03 | US | Iowa | Union | 19175 | 2707 | 49 | 0 | 41.0277278 | -94.24234847 | 2022-03-04 04:21:09 | Union, Iowa, US | |
2526612 | 2526612 | 2022-03-02 | US | Iowa | Union | 19175 | 2707 | 49 | 0 | 41.0277278 | -94.24234847 | 2022-03-03 04:21:01 | Union, 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]);