johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56 rows where confirmed = 10254 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453648 | 453648 | 2022-12-21 | US | New York | Orleans | 36073 | 10254 | 126 | 0 | 43.2516977 | -78.2320066 | 2022-12-22 04:20:56 | Orleans, New York, US | |
3766982 | 3766982 | 2022-09-11 | US | Indiana | Jasper | 18073 | 10254 | 155 | 0 | 41.02078733 | -87.11553319 | 2022-09-12 04:20:58 | Jasper, Indiana, US | |
3825557 | 3825557 | 2022-09-10 | US | Indiana | Jasper | 18073 | 10254 | 155 | 0 | 41.02078733 | -87.11553319 | 2022-09-11 04:20:50 | Jasper, Indiana, US | |
964014 | 964014 | 2022-09-09 | US | Indiana | Jasper | 18073 | 10254 | 155 | 0 | 41.02078733 | -87.11553319 | 2022-09-10 04:21:10 | Jasper, Indiana, US | |
1101127 | 1101127 | 2022-08-03 | US | Tennessee | Weakley | 47183 | 10254 | 165 | 0 | 36.29896232 | -88.71990865 | 2022-08-04 04:20:58 | Weakley, Tennessee, US | |
896790 | 896790 | 2022-07-24 | US | Colorado | Montrose | 8085 | 10254 | 170 | 0 | 38.40214114 | -108.2639022 | 2022-07-25 04:20:51 | Montrose, Colorado, US | |
3940616 | 3940616 | 2022-06-30 | US | California | Lassen | 6035 | 10254 | 64 | 0 | 40.67311306 | -120.5935099 | 2022-07-01 04:21:10 | Lassen, California, US | |
2490574 | 2490574 | 2022-06-29 | US | California | Lassen | 6035 | 10254 | 64 | 0 | 40.67311306 | -120.5935099 | 2022-06-30 04:21:01 | Lassen, California, US | |
2239956 | 2239956 | 2022-06-28 | US | California | Lassen | 6035 | 10254 | 64 | 0 | 40.67311306 | -120.5935099 | 2022-06-29 04:20:59 | Lassen, California, US | |
2191135 | 2191135 | 2022-06-22 | US | West Virginia | Wayne | 54099 | 10254 | 127 | 0 | 38.14901357 | -82.42287994 | 2022-06-23 04:20:55 | Wayne, West Virginia, US | |
2601222 | 2601222 | 2022-05-05 | US | Texas | Medina | 48325 | 10254 | 198 | 0 | 29.3557301 | -99.11030298 | 2022-05-06 04:21:00 | Medina, Texas, US | |
3724460 | 3724460 | 2022-04-25 | US | New York | Otsego | 36077 | 10254 | 88 | 0 | 42.63492579 | -75.03151402 | 2022-04-26 04:20:51 | Otsego, New York, US | |
1849403 | 1849403 | 2022-04-18 | US | Virginia | Wise | 51195 | 10254 | 198 | 0 | 36.9746148 | -82.62410519 | 2022-04-19 04:21:00 | Wise, Virginia, US | |
1993912 | 1993912 | 2022-03-01 | US | Iowa | Webster | 19187 | 10254 | 153 | 0 | 42.42853483 | -94.17987389 | 2022-03-02 04:21:07 | Webster, Iowa, US | |
944086 | 944086 | 2022-02-28 | US | Iowa | Webster | 19187 | 10254 | 153 | 0 | 42.42853483 | -94.17987389 | 2022-03-01 04:21:09 | Webster, Iowa, US | |
2735478 | 2735478 | 2022-02-27 | US | Ohio | Clinton | 39027 | 10254 | 169 | 0 | 39.41485808 | -83.80852286 | 2022-02-28 04:21:05 | Clinton, Ohio, US | |
2734277 | 2734277 | 2022-02-27 | US | Iowa | Webster | 19187 | 10254 | 153 | 0 | 42.42853483 | -94.17987389 | 2022-02-28 04:21:05 | Webster, Iowa, US | |
3049224 | 3049224 | 2022-02-26 | US | Texas | Chambers | 48071 | 10254 | 69 | 0 | 29.70972016 | -94.67154501 | 2022-02-27 04:21:04 | Chambers, Texas, US | |
3047430 | 3047430 | 2022-02-26 | US | Iowa | Webster | 19187 | 10254 | 153 | 0 | 42.42853483 | -94.17987389 | 2022-02-27 04:21:04 | Webster, Iowa, US | |
576085 | 576085 | 2022-02-25 | US | Iowa | Webster | 19187 | 10254 | 153 | 0 | 42.42853483 | -94.17987389 | 2022-02-26 04:21:12 | Webster, Iowa, US | |
1512661 | 1512661 | 2022-02-24 | US | Iowa | Webster | 19187 | 10254 | 153 | 0 | 42.42853483 | -94.17987389 | 2022-02-25 04:21:11 | Webster, Iowa, US | |
1059102 | 1059102 | 2022-02-23 | US | Iowa | Webster | 19187 | 10254 | 153 | 0 | 42.42853483 | -94.17987389 | 2022-02-24 04:21:14 | Webster, Iowa, US | |
3822180 | 3822180 | 2022-02-16 | US | Minnesota | McLeod | 27085 | 10254 | 101 | 0 | 44.82367677 | -94.27287017 | 2022-02-17 04:20:56 | McLeod, Minnesota, US | |
3673938 | 3673938 | 2022-02-15 | US | North Carolina | Alexander | 37003 | 10254 | 127 | 0 | 35.922379600000006 | -81.17751948 | 2022-02-16 04:21:10 | Alexander, North Carolina, US | |
2644789 | 2644789 | 2022-02-14 | US | Texas | Brown | 48049 | 10254 | 209 | 0 | 31.77430356 | -98.99907113 | 2022-02-15 04:21:09 | Brown, Texas, US | |
1464132 | 1464132 | 2022-02-10 | Liechtenstein | 10254 | 74 | 0 | 47.14 | 9.55 | 2022-02-11 04:21:09 | Liechtenstein | ||||
980349 | 980349 | 2022-02-01 | US | Kentucky | Floyd | 21071 | 10254 | 151 | 0 | 37.56213922 | -82.74750924 | 2022-02-02 04:21:09 | Floyd, Kentucky, US | |
3688278 | 3688278 | 2022-01-13 | US | Georgia | Effingham | 13103 | 10254 | 176 | 0 | 32.36616021 | -81.34280942 | 2022-01-14 04:21:54 | Effingham, Georgia, US | |
2197848 | 2197848 | 2021-12-03 | US | New York | Cattaraugus | 36009 | 10254 | 164 | 0 | 42.24778241 | -78.67923096 | 2021-12-04 04:22:18 | Cattaraugus, New York, US | |
3512792 | 3512792 | 2021-11-01 | US | Kentucky | Christian | 21047 | 10254 | 128 | 0 | 36.89267803 | -87.49055367 | 2021-11-02 04:22:03 | Christian, Kentucky, US | |
290945 | 290945 | 2021-10-31 | US | Tennessee | Hawkins | 47073 | 10254 | 166 | 0 | 36.44355426 | -82.94885298 | 2021-11-01 04:22:01 | Hawkins, Tennessee, US | |
535826 | 535826 | 2021-10-27 | US | Indiana | Grant | 18053 | 10254 | 221 | 0 | 40.51587228 | -85.65468702 | 2021-10-28 04:22:08 | Grant, Indiana, US | |
655459 | 655459 | 2021-10-22 | US | Kentucky | Pulaski | 21199 | 10254 | 171 | 0 | 37.10466131 | -84.57629079 | 2021-10-23 04:21:32 | Pulaski, Kentucky, US | |
3105390 | 3105390 | 2021-08-24 | Iceland | 10254 | 30 | 0 | 64.9631 | -19.0208 | 2021-08-25 04:21:41 | Iceland | ||||
3332092 | 3332092 | 2021-07-21 | US | California | Napa | 6055 | 10254 | 81 | 0 | 38.50735751 | -122.332839 | 2021-07-22 04:21:19 | Napa, California, US | |
579233 | 579233 | 2021-07-13 | US | Alabama | St. Clair | 1115 | 10254 | 250 | 0 | 33.71902176 | -86.31029372 | 2021-07-14 04:21:35 | St. Clair, Alabama, US | |
3741482 | 3741482 | 2021-07-12 | US | Alabama | St. Clair | 1115 | 10254 | 250 | 0 | 33.71902176 | -86.31029372 | 2021-07-13 04:21:18 | St. Clair, Alabama, US | |
1933948 | 1933948 | 2021-07-05 | US | Louisiana | Lafourche | 22057 | 10254 | 205 | 0 | 29.52470226 | -90.40976986 | 2021-07-06 04:21:32 | Lafourche, Louisiana, US | |
1166679 | 1166679 | 2021-07-04 | US | Louisiana | Lafourche | 22057 | 10254 | 205 | 0 | 29.52470226 | -90.40976986 | 2021-07-05 04:21:28 | Lafourche, Louisiana, US | |
1497113 | 1497113 | 2021-07-03 | US | Louisiana | Lafourche | 22057 | 10254 | 205 | 0 | 29.52470226 | -90.40976986 | 2021-07-04 04:21:38 | Lafourche, Louisiana, US | |
2073428 | 2073428 | 2021-07-02 | US | Louisiana | Lafourche | 22057 | 10254 | 205 | 0 | 29.52470226 | -90.40976986 | 2021-07-03 04:21:37 | Lafourche, Louisiana, US | |
107464 | 107464 | 2021-06-19 | Japan | Ibaraki | 10254 | 161 | 9795 | 298 | 36.303588 | 140.319591 | 2021-06-20 04:21:48 | Ibaraki, Japan | ||
2452469 | 2452469 | 2021-05-02 | US | Minnesota | Carver | 27019 | 10254 | 45 | 0 | 44.82017001 | -93.8009918 | 2021-05-03 04:20:39 | Carver, Minnesota, US | |
2783310 | 2783310 | 2021-03-24 | US | North Carolina | Harnett | 37085 | 10254 | 162 | 0 | 35.36731853 | -78.87243571 | 2021-03-25 05:27:00 | Harnett, North Carolina, US | |
1338334 | 1338334 | 2021-02-15 | Lesotho | 10254 | 243 | 2990 | 7021 | -29.61 | 28.2336 | 2021-02-16 05:24:38 | Lesotho | |||
1096436 | 1096436 | 2021-01-20 | US | North Carolina | Randolph | 37151 | 10254 | 157 | 0 | 10097 | 35.71015088 | -79.80570339 | 2021-01-21 05:22:01 | Randolph, North Carolina, US |
3102947 | 3102947 | 2021-01-16 | US | Louisiana | Livingston | 22063 | 10254 | 139 | 0 | 10115 | 30.44143993 | -90.73061664 | 2021-01-17 05:22:17 | Livingston, Louisiana, US |
3516909 | 3516909 | 2021-01-15 | US | Louisiana | Livingston | 22063 | 10254 | 139 | 0 | 10115 | 30.44143993 | -90.73061664 | 2021-01-16 05:22:40 | Livingston, Louisiana, US |
3764708 | 3764708 | 2020-12-28 | US | Texas | Johnson | 48251 | 10254 | 149 | 0 | 10059 | 32.37877812 | -97.36615819 | 2020-12-29 05:22:37 | Johnson, Texas, US |
1035387 | 1035387 | 2020-12-15 | US | Illinois | McLean | 17113 | 10254 | 73 | 0 | 10181 | 40.48996987 | -88.84621113 | 2020-12-16 05:28:04 | McLean, Illinois, US |
925165 | 925165 | 2020-11-26 | US | Louisiana | Calcasieu | 22019 | 10254 | 243 | 0 | 10011 | 30.22931235 | -93.35400434 | 2020-11-27 05:26:53 | Calcasieu, Louisiana, US |
1974070 | 1974070 | 2020-11-25 | US | Louisiana | Calcasieu | 22019 | 10254 | 243 | 0 | 10011 | 30.22931235 | -93.35400434 | 2020-11-26 05:27:44 | Calcasieu, Louisiana, US |
2081519 | 2081519 | 2020-10-31 | US | Massachusetts | Hampden | 25013 | 10254 | 708 | 0 | 9437 | 42.13440424 | -72.63235561 | 2020-11-01 04:36:19 | Hampden, Massachusetts, US |
3611977 | 3611977 | 2020-08-06 | US | Washington | Yakima | 53077 | 10254 | 219 | 0 | 10035 | 46.45738486 | -120.7380126 | 2020-08-07 04:35:11 | Yakima, Washington, US |
2808172 | 2808172 | 2020-08-02 | Peru | Ucayali | 10254 | 1240 | 0 | 9014 | -9.621718 | -73.444929 | 2020-08-03 04:34:35 | Ucayali, Peru | ||
303272 | 303272 | 2020-07-01 | Italy | Toscana | 10254 | 1106 | 8825 | 323 | 43.76923077 | 11.25588885 | 2020-07-02 04:33:46 | Toscana, Italy |
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]);