johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64 rows where confirmed = 11250 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753271 | 2753271 | 2022-12-29 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-30 04:21:04 | Covington, Alabama, US | |
1074277 | 1074277 | 2022-12-28 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-29 04:21:01 | Covington, Alabama, US | |
328274 | 328274 | 2022-12-27 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-28 04:21:04 | Covington, Alabama, US | |
218347 | 218347 | 2022-12-26 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-27 04:21:07 | Covington, Alabama, US | |
3222804 | 3222804 | 2022-12-25 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-26 04:21:06 | Covington, Alabama, US | |
1018718 | 1018718 | 2022-12-24 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-25 04:21:04 | Covington, Alabama, US | |
690741 | 690741 | 2022-12-23 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-24 04:21:02 | Covington, Alabama, US | |
2179951 | 2179951 | 2022-12-22 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-23 04:21:04 | Covington, Alabama, US | |
451755 | 451755 | 2022-12-21 | US | Alabama | Covington | 1039 | 11250 | 256 | 0 | 31.2477854 | -86.45050893 | 2022-12-22 04:20:56 | Covington, Alabama, US | |
2415386 | 2415386 | 2022-12-05 | US | Arkansas | Miller | 5091 | 11250 | 200 | 0 | 33.31403423 | -93.89285258 | 2022-12-06 04:21:03 | Miller, Arkansas, US | |
721274 | 721274 | 2022-12-04 | US | Puerto Rico | Vega Alta | 72143 | 11250 | 0 | 0 | 18.409346 | -66.33725 | 2022-12-05 04:20:58 | Vega Alta, Puerto Rico, US | |
718994 | 718994 | 2022-12-04 | US | Arkansas | Miller | 5091 | 11250 | 200 | 0 | 33.31403423 | -93.89285258 | 2022-12-05 04:20:58 | Miller, Arkansas, US | |
2377782 | 2377782 | 2022-09-29 | US | New York | Franklin | 36033 | 11250 | 50 | 0 | 44.59040891 | -74.29926032 | 2022-09-30 04:23:09 | Franklin, New York, US | |
3550751 | 3550751 | 2022-09-01 | US | Texas | Uvalde | 48463 | 11250 | 147 | 0 | 29.35739637 | -99.76229172 | 2022-09-02 04:21:07 | Uvalde, Texas, US | |
1252011 | 1252011 | 2022-08-23 | US | Iowa | Webster | 19187 | 11250 | 169 | 0 | 42.42853483 | -94.17987389 | 2022-08-24 04:20:46 | Webster, Iowa, US | |
2854115 | 2854115 | 2022-08-22 | US | Iowa | Webster | 19187 | 11250 | 169 | 0 | 42.42853483 | -94.17987389 | 2022-08-23 04:20:56 | Webster, Iowa, US | |
2404087 | 2404087 | 2022-08-21 | US | Iowa | Webster | 19187 | 11250 | 169 | 0 | 42.42853483 | -94.17987389 | 2022-08-22 04:20:38 | Webster, Iowa, US | |
3799165 | 3799165 | 2022-08-20 | US | Iowa | Webster | 19187 | 11250 | 169 | 0 | 42.42853483 | -94.17987389 | 2022-08-21 04:20:44 | Webster, Iowa, US | |
2364751 | 2364751 | 2022-08-19 | US | Iowa | Webster | 19187 | 11250 | 169 | 0 | 42.42853483 | -94.17987389 | 2022-08-20 04:21:01 | Webster, Iowa, US | |
1162422 | 1162422 | 2022-08-18 | US | Iowa | Webster | 19187 | 11250 | 169 | 0 | 42.42853483 | -94.17987389 | 2022-08-19 04:20:54 | Webster, Iowa, US | |
3951746 | 3951746 | 2022-08-17 | US | Iowa | Webster | 19187 | 11250 | 169 | 0 | 42.42853483 | -94.17987389 | 2022-08-18 04:21:11 | Webster, Iowa, US | |
1066997 | 1066997 | 2022-07-28 | US | Indiana | Montgomery | 18107 | 11250 | 166 | 0 | 40.04034823 | -86.89335024 | 2022-07-29 04:20:45 | Montgomery, Indiana, US | |
2336516 | 2336516 | 2022-07-27 | US | Indiana | Montgomery | 18107 | 11250 | 166 | 0 | 40.04034823 | -86.89335024 | 2022-07-28 04:20:56 | Montgomery, Indiana, US | |
1610739 | 1610739 | 2022-07-20 | US | Ohio | Highland | 39071 | 11250 | 185 | 0 | 39.1839264 | -83.60331456 | 2022-07-21 04:21:10 | Highland, Ohio, US | |
961372 | 961372 | 2022-07-19 | US | Ohio | Highland | 39071 | 11250 | 185 | 0 | 39.1839264 | -83.60331456 | 2022-07-20 04:20:59 | Highland, Ohio, US | |
3212759 | 3212759 | 2022-07-18 | US | Ohio | Highland | 39071 | 11250 | 185 | 0 | 39.1839264 | -83.60331456 | 2022-07-19 04:20:58 | Highland, Ohio, US | |
3407934 | 3407934 | 2022-07-17 | US | Ohio | Highland | 39071 | 11250 | 185 | 0 | 39.1839264 | -83.60331456 | 2022-07-18 04:20:59 | Highland, Ohio, US | |
2154134 | 2154134 | 2022-07-16 | US | Ohio | Highland | 39071 | 11250 | 185 | 0 | 39.1839264 | -83.60331456 | 2022-07-17 04:21:15 | Highland, Ohio, US | |
2421367 | 2421367 | 2022-07-15 | US | Ohio | Highland | 39071 | 11250 | 185 | 0 | 39.1839264 | -83.60331456 | 2022-07-16 04:21:05 | Highland, Ohio, US | |
3431442 | 3431442 | 2022-07-14 | US | Ohio | Highland | 39071 | 11250 | 185 | 0 | 39.1839264 | -83.60331456 | 2022-07-15 04:20:53 | Highland, Ohio, US | |
3112765 | 3112765 | 2022-07-13 | US | Utah | Wasatch | 49051 | 11250 | 36 | 0 | 40.33110236 | -111.1691419 | 2022-07-14 04:20:57 | Wasatch, Utah, US | |
633188 | 633188 | 2022-07-12 | US | Utah | Wasatch | 49051 | 11250 | 36 | 0 | 40.33110236 | -111.1691419 | 2022-07-13 04:20:58 | Wasatch, Utah, US | |
1214832 | 1214832 | 2022-07-11 | US | Utah | Wasatch | 49051 | 11250 | 36 | 0 | 40.33110236 | -111.1691419 | 2022-07-12 04:20:51 | Wasatch, Utah, US | |
2792314 | 2792314 | 2022-07-10 | US | Utah | Wasatch | 49051 | 11250 | 36 | 0 | 40.33110236 | -111.1691419 | 2022-07-11 04:20:46 | Wasatch, Utah, US | |
145267 | 145267 | 2022-07-09 | US | Utah | Wasatch | 49051 | 11250 | 36 | 0 | 40.33110236 | -111.1691419 | 2022-07-10 04:20:54 | Wasatch, Utah, US | |
1420367 | 1420367 | 2022-07-08 | US | Utah | Wasatch | 49051 | 11250 | 36 | 0 | 40.33110236 | -111.1691419 | 2022-07-09 04:20:59 | Wasatch, Utah, US | |
2744292 | 2744292 | 2022-07-07 | US | Utah | Wasatch | 49051 | 11250 | 36 | 0 | 40.33110236 | -111.1691419 | 2022-07-08 04:20:56 | Wasatch, Utah, US | |
3399685 | 3399685 | 2022-06-18 | US | New York | Otsego | 36077 | 11250 | 93 | 0 | 42.63492579 | -75.03151402 | 2022-06-19 04:20:51 | Otsego, New York, US | |
3001023 | 3001023 | 2022-05-24 | US | Minnesota | Douglas | 27041 | 11250 | 117 | 0 | 45.93348491 | -95.45335469 | 2022-05-25 04:20:56 | Douglas, Minnesota, US | |
1847506 | 1847506 | 2022-04-18 | US | Louisiana | St. Bernard | 22087 | 11250 | 111 | 0 | 29.87761636 | -89.51887093 | 2022-04-19 04:21:00 | St. Bernard, Louisiana, US | |
1226305 | 1226305 | 2022-04-14 | US | Pennsylvania | Venango | 42121 | 11250 | 238 | 0 | 41.40323442 | -79.75845449 | 2022-04-15 04:20:57 | Venango, Pennsylvania, US | |
3869107 | 3869107 | 2022-04-05 | US | Maine | Oxford | 23017 | 11250 | 142 | 0 | 44.49952995 | -70.75682123 | 2022-04-06 04:20:49 | Oxford, Maine, US | |
3671798 | 3671798 | 2022-02-15 | Pakistan | Gilgit-Baltistan | 11250 | 189 | 0 | 35.792146 | 74.982138 | 2022-02-16 04:21:10 | Gilgit-Baltistan, Pakistan | |||
1318142 | 1318142 | 2022-01-26 | India | Dadra and Nagar Haveli and Daman and Diu | 11250 | 4 | 0 | 20.194742 | 73.080901 | 2022-01-27 04:21:19 | Dadra and Nagar Haveli and Daman and Diu, India | |||
2054822 | 2054822 | 2022-01-25 | US | Tennessee | Franklin | 47051 | 11250 | 150 | 0 | 35.15634626 | -86.09201039 | 2022-01-26 04:21:07 | Franklin, Tennessee, US | |
1963392 | 1963392 | 2022-01-20 | US | South Carolina | Newberry | 45071 | 11250 | 154 | 0 | 34.28629098 | -81.59935761 | 2022-01-21 04:21:09 | Newberry, South Carolina, US | |
1494430 | 1494430 | 2021-10-12 | US | South Carolina | Laurens | 45059 | 11250 | 209 | 0 | 34.48244419 | -82.00490796 | 2021-10-13 04:20:51 | Laurens, South Carolina, US | |
3685324 | 3685324 | 2021-08-02 | US | Missouri | Buchanan | 29021 | 11250 | 156 | 0 | 39.65816401 | -94.80138942 | 2021-08-03 04:21:39 | Buchanan, Missouri, US | |
2694919 | 2694919 | 2021-07-06 | US | Iowa | Pottawattamie | 19155 | 11250 | 177 | 0 | 41.33640314 | -95.53907776 | 2021-07-07 04:21:20 | Pottawattamie, Iowa, US | |
2258105 | 2258105 | 2021-05-19 | US | North Carolina | Wayne | 37191 | 11250 | 245 | 0 | 35.36438125 | -78.00027268 | 2021-05-20 04:21:05 | Wayne, North Carolina, US | |
2827286 | 2827286 | 2021-05-01 | US | Ohio | Richland | 39139 | 11250 | 204 | 0 | 40.77180308 | -82.53799609999999 | 2021-05-02 04:20:48 | Richland, Ohio, US | |
3395713 | 3395713 | 2021-04-28 | US | North Carolina | Harnett | 37085 | 11250 | 169 | 0 | 35.36731853 | -78.87243571 | 2021-04-29 04:20:55 | Harnett, North Carolina, US | |
639585 | 639585 | 2021-03-31 | US | Michigan | Muskegon | 26121 | 11250 | 307 | 0 | 43.29123859 | -86.15176712 | 2021-04-01 04:27:05 | Muskegon, Michigan, US | |
1980707 | 1980707 | 2021-03-25 | Mexico | Nayarit | 11250 | 1731 | 0 | 9519 | 21.7514 | -104.8455 | 2021-03-26 05:26:55 | Nayarit, Mexico | ||
3066384 | 3066384 | 2021-02-27 | US | Alabama | Marshall | 1095 | 11250 | 209 | 0 | 11041 | 34.36975964 | -86.30486727 | 2021-02-28 05:22:20 | Marshall, Alabama, US |
2483959 | 2483959 | 2021-01-28 | US | Montana | Gallatin | 30031 | 11250 | 44 | 0 | 11206 | 45.54486106 | -111.1692571 | 2021-01-29 05:22:23 | Gallatin, Montana, US |
190392 | 190392 | 2021-01-11 | Sweden | Vasternorrland | 11250 | 255 | 0 | 10995 | 63.4276 | 17.7292 | 2021-01-12 05:22:15 | Vasternorrland, Sweden | ||
2626195 | 2626195 | 2021-01-10 | Sweden | Vasternorrland | 11250 | 255 | 0 | 10995 | 63.4276 | 17.7292 | 2021-01-11 05:21:50 | Vasternorrland, Sweden | ||
3900283 | 3900283 | 2021-01-09 | Sweden | Vasternorrland | 11250 | 255 | 0 | 10995 | 63.4276 | 17.7292 | 2021-01-10 05:22:12 | Vasternorrland, Sweden | ||
154306 | 154306 | 2021-01-08 | Sweden | Vasternorrland | 11250 | 255 | 0 | 10995 | 63.4276 | 17.7292 | 2021-01-09 05:22:18 | Vasternorrland, Sweden | ||
3036808 | 3036808 | 2021-01-05 | US | Ohio | Trumbull | 39155 | 11250 | 365 | 0 | 10885 | 41.31735028 | -80.76109643 | 2021-01-06 05:22:16 | Trumbull, Ohio, US |
3231244 | 3231244 | 2021-01-03 | US | Georgia | Forsyth | 13117 | 11250 | 81 | 0 | 11169 | 34.22604035 | -84.12315129999998 | 2021-01-04 05:22:02 | Forsyth, Georgia, US |
3786593 | 3786593 | 2020-10-11 | US | Florida | Leon | 12073 | 11250 | 92 | 0 | 11158 | 30.45955727 | -84.27491114 | 2020-10-12 04:23:45 | Leon, Florida, US |
1281076 | 1281076 | 2020-06-04 | Colombia | Capital District | 11250 | 288 | 4494 | 6468 | 4.711 | -74.0721 | 2020-06-05 02:33:06 | Capital District, Colombia |
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]);