johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
321 rows where confirmed = 2581 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219897 | 219897 | 2022-12-26 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-27 04:21:07 | Iron, Missouri, US | |
3224354 | 3224354 | 2022-12-25 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-26 04:21:06 | Iron, Missouri, US | |
1020268 | 1020268 | 2022-12-24 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-25 04:21:04 | Iron, Missouri, US | |
692291 | 692291 | 2022-12-23 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-24 04:21:02 | Iron, Missouri, US | |
2181501 | 2181501 | 2022-12-22 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-23 04:21:04 | Iron, Missouri, US | |
453305 | 453305 | 2022-12-21 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-22 04:20:56 | Iron, Missouri, US | |
2953304 | 2953304 | 2022-12-20 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-21 04:21:03 | Iron, Missouri, US | |
2952663 | 2952663 | 2022-12-20 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-21 04:21:03 | Cloud, Kansas, US | |
3175065 | 3175065 | 2022-12-19 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-20 04:21:04 | Cloud, Kansas, US | |
1629582 | 1629582 | 2022-12-18 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-19 04:21:03 | Cloud, Kansas, US | |
504961 | 504961 | 2022-12-17 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-18 04:21:03 | Cloud, Kansas, US | |
3325533 | 3325533 | 2022-12-16 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-17 04:21:04 | Cloud, Kansas, US | |
544045 | 544045 | 2022-12-15 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-16 04:21:01 | Cloud, Kansas, US | |
349573 | 349573 | 2022-12-14 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-15 04:20:58 | Cloud, Kansas, US | |
311118 | 311118 | 2022-12-13 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-14 04:21:04 | Swisher, Texas, US | |
1152179 | 1152179 | 2022-12-12 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-13 04:21:01 | Swisher, Texas, US | |
872033 | 872033 | 2022-12-11 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-12 04:21:01 | Swisher, Texas, US | |
260563 | 260563 | 2022-12-10 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-11 04:20:50 | Swisher, Texas, US | |
3939277 | 3939277 | 2022-12-09 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-10 04:21:02 | Swisher, Texas, US | |
3380763 | 3380763 | 2022-12-08 | US | Virginia | Northumberland | 51133 | 2581 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-12-09 04:21:05 | Northumberland, Virginia, US | |
3380609 | 3380609 | 2022-12-08 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-09 04:21:05 | Swisher, Texas, US | |
1987880 | 1987880 | 2022-12-07 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-08 04:21:07 | Swisher, Texas, US | |
1985491 | 1985491 | 2022-12-07 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-08 04:21:07 | Macon, Georgia, US | |
3715014 | 3715014 | 2022-12-06 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-07 04:20:58 | Macon, Georgia, US | |
2415719 | 2415719 | 2022-12-05 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-06 04:21:03 | Macon, Georgia, US | |
719327 | 719327 | 2022-12-04 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-05 04:20:58 | Macon, Georgia, US | |
2817616 | 2817616 | 2022-12-03 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-04 04:20:56 | Macon, Georgia, US | |
834472 | 834472 | 2022-12-02 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-03 04:21:02 | Macon, Georgia, US | |
2137002 | 2137002 | 2022-12-01 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-02 04:21:07 | Macon, Georgia, US | |
1965418 | 1965418 | 2022-11-30 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-01 04:21:03 | Macon, Georgia, US | |
2486480 | 2486480 | 2022-11-16 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-17 04:21:11 | Cleveland, Arkansas, US | |
292491 | 292491 | 2022-11-15 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-16 04:21:09 | Cleveland, Arkansas, US | |
3597521 | 3597521 | 2022-11-14 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-15 04:21:16 | Cleveland, Arkansas, US | |
312379 | 312379 | 2022-11-13 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-14 04:21:09 | Cleveland, Arkansas, US | |
2760441 | 2760441 | 2022-10-18 | US | West Virginia | Tyler | 54095 | 2581 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-10-19 04:22:26 | Tyler, West Virginia, US | |
2028275 | 2028275 | 2022-10-17 | US | West Virginia | Tyler | 54095 | 2581 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-10-18 04:22:42 | Tyler, West Virginia, US | |
2162513 | 2162513 | 2022-10-16 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-17 04:20:31 | Moore, Tennessee, US | |
518710 | 518710 | 2022-10-15 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-16 04:22:39 | Moore, Tennessee, US | |
2035767 | 2035767 | 2022-10-14 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-15 04:22:00 | Moore, Tennessee, US | |
3756455 | 3756455 | 2022-10-13 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-14 04:22:28 | Moore, Tennessee, US | |
3100898 | 3100898 | 2022-10-09 | US | Washington | Lincoln | 53043 | 2581 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-10-10 04:22:32 | Lincoln, Washington, US | |
4006123 | 4006123 | 2022-10-08 | US | Washington | Lincoln | 53043 | 2581 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-10-09 04:21:16 | Lincoln, Washington, US | |
4003183 | 4003183 | 2022-10-08 | US | Arkansas | Nevada | 5099 | 2581 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-10-09 04:21:16 | Nevada, Arkansas, US | |
399720 | 399720 | 2022-10-07 | US | Washington | Lincoln | 53043 | 2581 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-10-08 04:22:56 | Lincoln, Washington, US | |
396780 | 396780 | 2022-10-07 | US | Arkansas | Nevada | 5099 | 2581 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-10-08 04:22:56 | Nevada, Arkansas, US | |
2529897 | 2529897 | 2022-10-06 | US | Arkansas | Nevada | 5099 | 2581 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-10-07 04:23:08 | Nevada, Arkansas, US | |
1626288 | 1626288 | 2022-09-22 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-23 04:23:13 | Dawson, Montana, US | |
1372492 | 1372492 | 2022-09-21 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-22 04:22:56 | Dawson, Montana, US | |
2018722 | 2018722 | 2022-09-20 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-21 04:23:22 | Dawson, Montana, US | |
3572595 | 3572595 | 2022-09-19 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-20 04:22:48 | Dawson, Montana, US | |
421334 | 421334 | 2022-09-18 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-19 04:21:49 | Dawson, Montana, US | |
3375358 | 3375358 | 2022-09-17 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-18 04:22:50 | Dawson, Montana, US | |
2357466 | 2357466 | 2022-09-16 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-17 04:20:19 | Dawson, Montana, US | |
2831799 | 2831799 | 2022-08-25 | US | Tennessee | Perry | 47135 | 2581 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-08-26 04:21:02 | Perry, Tennessee, US | |
2366260 | 2366260 | 2022-08-19 | US | Puerto Rico | Maunabo | 72095 | 2581 | 0 | 0 | 18.017889 | -65.922235 | 2022-08-20 04:21:01 | Maunabo, Puerto Rico, US | |
3909985 | 3909985 | 2022-08-11 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-12 04:20:54 | Wayne, Missouri, US | |
1348302 | 1348302 | 2022-08-10 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-11 04:20:49 | Wayne, Missouri, US | |
1347287 | 1347287 | 2022-08-10 | US | Illinois | Brown | 17009 | 2581 | 16 | 0 | 39.96209138 | -90.75068024 | 2022-08-11 04:20:49 | Brown, Illinois, US | |
1088057 | 1088057 | 2022-08-09 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-10 04:20:57 | Wayne, Missouri, US | |
3545472 | 3545472 | 2022-08-08 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-09 04:20:34 | Wayne, Missouri, US | |
1071875 | 1071875 | 2022-08-07 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-08 04:21:08 | Wayne, Missouri, US | |
1942463 | 1942463 | 2022-08-06 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-07 04:20:54 | Wayne, Missouri, US | |
882262 | 882262 | 2022-08-05 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-06 04:20:56 | Wayne, Missouri, US | |
1098644 | 1098644 | 2022-08-03 | US | Arkansas | Scott | 5127 | 2581 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-08-04 04:20:58 | Scott, Arkansas, US | |
962288 | 962288 | 2022-07-19 | US | Virginia | Poquoson | 51735 | 2581 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-07-20 04:20:59 | Poquoson, Virginia, US | |
631133 | 631133 | 2022-07-12 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-13 04:20:58 | Mitchell, Iowa, US | |
1212777 | 1212777 | 2022-07-11 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-12 04:20:51 | Mitchell, Iowa, US | |
2790259 | 2790259 | 2022-07-10 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-11 04:20:46 | Mitchell, Iowa, US | |
143212 | 143212 | 2022-07-09 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-10 04:20:54 | Mitchell, Iowa, US | |
1418312 | 1418312 | 2022-07-08 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-09 04:20:59 | Mitchell, Iowa, US | |
2742237 | 2742237 | 2022-07-07 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-08 04:20:56 | Mitchell, Iowa, US | |
1201032 | 1201032 | 2022-07-06 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-07 04:20:55 | Mitchell, Iowa, US | |
3969734 | 3969734 | 2022-07-05 | US | Texas | Morris | 48343 | 2581 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-07-06 04:20:58 | Morris, Texas, US | |
2149146 | 2149146 | 2022-06-27 | US | Louisiana | East Carroll | 22035 | 2581 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-06-28 04:20:58 | East Carroll, Louisiana, US | |
475958 | 475958 | 2022-06-26 | US | Arkansas | Perry | 5105 | 2581 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-06-27 04:21:00 | Perry, Arkansas, US | |
948166 | 948166 | 2022-06-14 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-15 04:20:54 | Marshall, Kansas, US | |
2980574 | 2980574 | 2022-06-13 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-14 04:20:52 | Marshall, Kansas, US | |
2236700 | 2236700 | 2022-06-12 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-13 04:21:14 | Marshall, Kansas, US | |
3142898 | 3142898 | 2022-06-11 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-12 04:20:53 | Marshall, Kansas, US | |
1945814 | 1945814 | 2022-06-10 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-11 04:21:01 | Marshall, Kansas, US | |
3158953 | 3158953 | 2022-06-09 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-10 04:20:55 | Marshall, Kansas, US | |
1422420 | 1422420 | 2022-06-08 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-09 04:20:54 | Marshall, Kansas, US | |
3596371 | 3596371 | 2022-05-23 | US | Virginia | Galax | 51640 | 2581 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-05-24 04:20:57 | Galax, Virginia, US | |
1169803 | 1169803 | 2022-05-20 | US | Colorado | Bent | 8011 | 2581 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-05-21 04:20:58 | Bent, Colorado, US | |
1505384 | 1505384 | 2022-05-16 | US | Minnesota | Yellow Medicine | 27173 | 2581 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-05-17 04:20:59 | Yellow Medicine, Minnesota, US | |
2536138 | 2536138 | 2022-05-12 | US | Puerto Rico | Florida | 72054 | 2581 | 0 | 0 | 18.373715 | -66.560488 | 2022-05-13 04:20:51 | Florida, Puerto Rico, US | |
2599169 | 2599169 | 2022-05-05 | US | Indiana | Newton | 18111 | 2581 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-06 04:21:00 | Newton, Indiana, US | |
3266618 | 3266618 | 2022-05-04 | US | Indiana | Newton | 18111 | 2581 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-05 04:20:55 | Newton, Indiana, US | |
2029174 | 2029174 | 2022-04-24 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-25 04:20:56 | Sumter, Alabama, US | |
746749 | 746749 | 2022-04-23 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-24 04:20:56 | Sumter, Alabama, US | |
3437234 | 3437234 | 2022-04-22 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-23 04:20:50 | Sumter, Alabama, US | |
2892819 | 2892819 | 2022-04-21 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-22 04:20:45 | Sumter, Alabama, US | |
2309847 | 2309847 | 2022-04-20 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-21 04:20:46 | Hughes, Oklahoma, US | |
2253986 | 2253986 | 2022-04-19 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-20 04:20:45 | Hughes, Oklahoma, US | |
1848536 | 1848536 | 2022-04-18 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-19 04:21:00 | Hughes, Oklahoma, US | |
3419480 | 3419480 | 2022-04-17 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-18 04:21:12 | Hughes, Oklahoma, US | |
306429 | 306429 | 2022-04-16 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-17 04:20:59 | Hughes, Oklahoma, US | |
2672374 | 2672374 | 2022-04-15 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-16 04:20:48 | Hughes, Oklahoma, US | |
1226159 | 1226159 | 2022-04-14 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-15 04:20:57 | Hughes, Oklahoma, US | |
338672 | 338672 | 2022-03-18 | US | Puerto Rico | Comerio | 72045 | 2581 | 0 | 0 | 18.224687 | -66.221622 | 2022-03-19 04:20:47 | Comerio, Puerto Rico, 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]);