johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
347 rows where confirmed = 1972 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1965090 | 1965090 | 2022-11-30 | US | Arkansas | Newton | 5101 | 1972 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-12-01 04:21:03 | Newton, Arkansas, US | |
2559644 | 2559644 | 2022-11-29 | US | Texas | Coleman | 48083 | 1972 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-11-30 04:21:07 | Coleman, Texas, US | |
2557104 | 2557104 | 2022-11-29 | US | Arkansas | Newton | 5101 | 1972 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-11-30 04:21:07 | Newton, Arkansas, US | |
1242718 | 1242718 | 2022-11-28 | US | Texas | Coleman | 48083 | 1972 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-11-29 04:21:05 | Coleman, Texas, US | |
293055 | 293055 | 2022-11-15 | US | Illinois | Pulaski | 17153 | 1972 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-11-16 04:21:09 | Pulaski, Illinois, US | |
2433482 | 2433482 | 2022-11-09 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-10 04:21:16 | Coal, Oklahoma, US | |
482138 | 482138 | 2022-11-08 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-09 04:21:22 | Coal, Oklahoma, US | |
2441288 | 2441288 | 2022-11-07 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-08 04:21:21 | Coal, Oklahoma, US | |
1052386 | 1052386 | 2022-11-06 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-07 04:21:26 | Coal, Oklahoma, US | |
620410 | 620410 | 2022-11-05 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-06 04:21:24 | Coal, Oklahoma, US | |
1024914 | 1024914 | 2022-11-04 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-05 04:21:52 | Coal, Oklahoma, US | |
433905 | 433905 | 2022-11-03 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-04 04:22:11 | Coal, Oklahoma, US | |
852147 | 852147 | 2022-11-02 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-03 04:22:05 | Coal, Oklahoma, US | |
712998 | 712998 | 2022-11-01 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-02 04:22:09 | Coal, Oklahoma, US | |
3287447 | 3287447 | 2022-10-31 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-01 04:22:36 | Coal, Oklahoma, US | |
322480 | 322480 | 2022-10-30 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-31 04:21:36 | Coal, Oklahoma, US | |
914756 | 914756 | 2022-10-29 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-30 04:22:14 | Coal, Oklahoma, US | |
1369025 | 1369025 | 2022-10-28 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-29 04:21:13 | Coal, Oklahoma, US | |
3040880 | 3040880 | 2022-10-27 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-28 04:22:31 | Coal, Oklahoma, US | |
2494686 | 2494686 | 2022-08-15 | US | Colorado | Rio Blanco | 8103 | 1972 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-16 04:20:58 | Rio Blanco, Colorado, US | |
903229 | 903229 | 2022-07-22 | US | Texas | Crosby | 48107 | 1972 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-07-23 04:20:53 | Crosby, Texas, US | |
3078438 | 3078438 | 2022-07-04 | US | Alabama | Greene | 1063 | 1972 | 51 | 0 | 32.85504247 | -87.95684022 | 2022-07-05 04:20:45 | Greene, Alabama, US | |
1649912 | 1649912 | 2022-06-23 | US | Louisiana | St. Helena | 22091 | 1972 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-06-24 04:20:58 | St. Helena, Louisiana, US | |
3985697 | 3985697 | 2022-06-15 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-16 04:20:55 | Floyd, Texas, US | |
949938 | 949938 | 2022-06-14 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-15 04:20:54 | Floyd, Texas, US | |
947483 | 947483 | 2022-06-14 | US | Colorado | Lake | 8065 | 1972 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-06-15 04:20:54 | Lake, Colorado, US | |
2982346 | 2982346 | 2022-06-13 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-14 04:20:52 | Floyd, Texas, US | |
2238472 | 2238472 | 2022-06-12 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-13 04:21:14 | Floyd, Texas, US | |
3527987 | 3527987 | 2022-06-04 | US | Arkansas | Prairie | 5117 | 1972 | 41 | 0 | 34.83624419 | -91.55162157 | 2022-06-05 04:20:55 | Prairie, Arkansas, US | |
3134073 | 3134073 | 2022-06-03 | US | Arkansas | Prairie | 5117 | 1972 | 41 | 0 | 34.83624419 | -91.55162157 | 2022-06-04 04:20:58 | Prairie, Arkansas, US | |
3899070 | 3899070 | 2022-05-19 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-20 04:20:57 | Hamilton, Texas, US | |
1187854 | 1187854 | 2022-05-18 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-19 04:20:54 | Hamilton, Texas, US | |
3585751 | 3585751 | 2022-05-17 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-18 04:20:50 | Hamilton, Texas, US | |
1506708 | 1506708 | 2022-05-16 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-17 04:20:59 | Hamilton, Texas, US | |
2087067 | 2087067 | 2022-05-15 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-16 04:20:47 | Hamilton, Texas, US | |
3357777 | 3357777 | 2022-05-14 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-15 04:20:53 | Hamilton, Texas, US | |
661422 | 661422 | 2022-05-13 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-14 04:20:48 | Hamilton, Texas, US | |
3537848 | 3537848 | 2022-05-10 | US | North Dakota | Benson | 38005 | 1972 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-05-11 04:20:48 | Benson, North Dakota, US | |
3919541 | 3919541 | 2022-05-01 | US | West Virginia | Pendleton | 54071 | 1972 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-02 04:21:10 | Pendleton, West Virginia, US | |
2844345 | 2844345 | 2022-04-30 | US | West Virginia | Pendleton | 54071 | 1972 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-01 04:20:57 | Pendleton, West Virginia, US | |
1160658 | 1160658 | 2022-04-29 | US | West Virginia | Pendleton | 54071 | 1972 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-04-30 04:21:05 | Pendleton, West Virginia, US | |
1329820 | 1329820 | 2022-04-26 | US | Wisconsin | Pepin | 55091 | 1972 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-04-27 04:20:52 | Pepin, Wisconsin, US | |
3725774 | 3725774 | 2022-04-25 | US | Wisconsin | Pepin | 55091 | 1972 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-04-26 04:20:51 | Pepin, Wisconsin, US | |
2893686 | 2893686 | 2022-04-21 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-22 04:20:45 | Clay, Kansas, US | |
2308558 | 2308558 | 2022-04-20 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-21 04:20:46 | Clay, Kansas, US | |
2252697 | 2252697 | 2022-04-19 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-20 04:20:45 | Clay, Kansas, US | |
1847247 | 1847247 | 2022-04-18 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-19 04:21:00 | Clay, Kansas, US | |
3418191 | 3418191 | 2022-04-17 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-18 04:21:12 | Clay, Kansas, US | |
305140 | 305140 | 2022-04-16 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-17 04:20:59 | Clay, Kansas, US | |
2671085 | 2671085 | 2022-04-15 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-16 04:20:48 | Clay, Kansas, US | |
3322659 | 3322659 | 2022-04-07 | US | North Dakota | Pembina | 38067 | 1972 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-08 04:20:48 | Pembina, North Dakota, US | |
3867337 | 3867337 | 2022-04-05 | China | Hebei | 1972 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-06 04:20:49 | Hebei, China | |||
3731114 | 3731114 | 2022-04-03 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-04 04:20:51 | Taylor, Georgia, US | |
500549 | 500549 | 2022-04-02 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-03 04:20:48 | Taylor, Georgia, US | |
3351534 | 3351534 | 2022-04-01 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-02 04:20:47 | Taylor, Georgia, US | |
1540839 | 1540839 | 2022-03-31 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-01 04:20:28 | Taylor, Georgia, US | |
2091912 | 2091912 | 2022-03-05 | China | Yunnan | 1972 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-06 04:20:49 | Yunnan, China | |||
2527572 | 2527572 | 2022-03-02 | US | New Mexico | Quay | 35037 | 1972 | 48 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-03 04:21:01 | Quay, New Mexico, US | |
1994866 | 1994866 | 2022-03-01 | US | New Mexico | Quay | 35037 | 1972 | 48 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-02 04:21:07 | Quay, New Mexico, US | |
2734779 | 2734779 | 2022-02-27 | US | Minnesota | Pipestone | 27117 | 1972 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-02-28 04:21:05 | Pipestone, Minnesota, US | |
3047932 | 3047932 | 2022-02-26 | US | Minnesota | Pipestone | 27117 | 1972 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-02-27 04:21:04 | Pipestone, Minnesota, US | |
576587 | 576587 | 2022-02-25 | US | Minnesota | Pipestone | 27117 | 1972 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-02-26 04:21:12 | Pipestone, Minnesota, US | |
575532 | 575532 | 2022-02-25 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-26 04:21:12 | Glades, Florida, US | |
1512108 | 1512108 | 2022-02-24 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-25 04:21:11 | Glades, Florida, US | |
1058549 | 1058549 | 2022-02-23 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-24 04:21:14 | Glades, Florida, US | |
2447472 | 2447472 | 2022-02-22 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-23 04:21:09 | Glades, Florida, US | |
3718885 | 3718885 | 2022-02-21 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-22 04:21:01 | Glades, Florida, US | |
3912719 | 3912719 | 2022-02-20 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-21 04:21:05 | Glades, Florida, US | |
3876277 | 3876277 | 2022-02-19 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-20 04:21:00 | Glades, Florida, US | |
3856533 | 3856533 | 2022-02-18 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-19 04:21:11 | Glades, Florida, US | |
3821831 | 3821831 | 2022-02-16 | US | Kentucky | Crittenden | 21055 | 1972 | 41 | 0 | 37.35839237 | -88.08826090000002 | 2022-02-17 04:20:56 | Crittenden, Kentucky, US | |
2643487 | 2643487 | 2022-02-14 | US | Minnesota | Lake | 27075 | 1972 | 27 | 0 | 47.64270764 | -91.44557998 | 2022-02-15 04:21:09 | Lake, Minnesota, US | |
188059 | 188059 | 2022-02-13 | US | Montana | Carbon | 30009 | 1972 | 27 | 0 | 45.22850116 | -109.0274047 | 2022-02-14 04:20:51 | Carbon, Montana, US | |
317905 | 317905 | 2022-02-12 | US | Montana | Carbon | 30009 | 1972 | 27 | 0 | 45.22850116 | -109.0274047 | 2022-02-13 04:21:00 | Carbon, Montana, US | |
235231 | 235231 | 2022-02-11 | US | Montana | Carbon | 30009 | 1972 | 27 | 0 | 45.22850116 | -109.0274047 | 2022-02-12 04:21:06 | Carbon, Montana, US | |
234169 | 234169 | 2022-02-11 | US | Idaho | Boundary | 16021 | 1972 | 56 | 0 | 48.76684761 | -116.4630179 | 2022-02-12 04:21:06 | Boundary, Idaho, US | |
3077416 | 3077416 | 2022-02-09 | US | Virginia | Madison | 51113 | 1972 | 30 | 0 | 38.41531222 | -78.28220331 | 2022-02-10 04:21:14 | Madison, Virginia, US | |
1363555 | 1363555 | 2022-02-08 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-09 04:21:04 | Howard, Iowa, US | |
72293 | 72293 | 2022-02-07 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-08 04:21:15 | Howard, Iowa, US | |
2013909 | 2013909 | 2022-02-06 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-07 04:21:05 | Howard, Iowa, US | |
1295238 | 1295238 | 2022-02-05 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-06 04:21:00 | Howard, Iowa, US | |
1294561 | 1294561 | 2022-02-05 | US | Arkansas | Searcy | 5129 | 1972 | 38 | 0 | 35.9109364 | -92.69936482 | 2022-02-06 04:21:00 | Searcy, Arkansas, US | |
2328566 | 2328566 | 2022-02-04 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-05 04:21:05 | Howard, Iowa, US | |
2475439 | 2475439 | 2022-02-03 | US | Kentucky | Wolfe | 21237 | 1972 | 17 | 0 | 37.73941626 | -83.49303612 | 2022-02-04 04:21:10 | Wolfe, Kentucky, US | |
2475157 | 2475157 | 2022-02-03 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-04 04:21:10 | Howard, Iowa, US | |
460582 | 460582 | 2022-02-02 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-03 04:21:21 | Howard, Iowa, US | |
2052755 | 2052755 | 2022-01-25 | US | Georgia | Seminole | 13253 | 1972 | 27 | 0 | 30.93464824 | -84.86823924 | 2022-01-26 04:21:07 | Seminole, Georgia, US | |
1229512 | 1229512 | 2022-01-24 | US | Missouri | DeKalb | 29063 | 1972 | 40 | 0 | 39.89201062 | -94.40476508 | 2022-01-25 04:21:05 | DeKalb, Missouri, US | |
3690846 | 3690846 | 2022-01-13 | US | Virginia | Lexington | 51678 | 1972 | 38 | 0 | 37.78258621 | -79.44262866 | 2022-01-14 04:21:54 | Lexington, Virginia, US | |
3688273 | 3688273 | 2022-01-13 | US | Georgia | Dooly | 13093 | 1972 | 62 | 0 | 32.15630737 | -83.79746561 | 2022-01-14 04:21:54 | Dooly, Georgia, US | |
3613951 | 3613951 | 2022-01-12 | US | Georgia | Towns | 13281 | 1972 | 90 | 0 | 34.91369188 | -83.74107459999998 | 2022-01-13 08:00:09 | Towns, Georgia, US | |
3520748 | 3520748 | 2022-01-02 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-03 02:22:25 | Marshall, Kansas, US | |
2168878 | 2168878 | 2022-01-01 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-02 04:20:52 | Marshall, Kansas, US | |
2778309 | 2778309 | 2021-12-31 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-01 04:22:14 | Marshall, Kansas, US | |
3999966 | 3999966 | 2021-12-30 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2021-12-31 04:21:50 | Marshall, Kansas, US | |
3999254 | 3999254 | 2021-12-30 | US | Colorado | Bent | 8011 | 1972 | 44 | 0 | 37.95474293 | -103.0720195 | 2021-12-31 04:21:50 | Bent, Colorado, US | |
1669773 | 1669773 | 2021-12-29 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2021-12-30 04:21:25 | Marshall, Kansas, US | |
2112346 | 2112346 | 2021-12-26 | US | Colorado | Park | 8093 | 1972 | 16 | 0 | 39.120926000000004 | -105.7182065 | 2021-12-27 04:21:58 | Park, Colorado, US | |
1256143 | 1256143 | 2021-12-20 | US | Kentucky | Bath | 21011 | 1972 | 34 | 0 | 38.14735938 | -83.74588932 | 2021-12-21 03:21:27 | Bath, Kentucky, US | |
1260664 | 1260664 | 2021-12-18 | US | Missouri | Bollinger | 29017 | 1972 | 34 | 0 | 37.32449052 | -90.02725304 | 2021-12-19 04:21:11 | Bollinger, 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]);