johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where confirmed = 15697 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176628 | 3176628 | 2022-12-19 | US | South Carolina | Newberry | 45071 | 15697 | 210 | 0 | 34.28629098 | -81.59935761 | 2022-12-20 04:21:04 | Newberry, South Carolina, US | |
1631145 | 1631145 | 2022-12-18 | US | South Carolina | Newberry | 45071 | 15697 | 210 | 0 | 34.28629098 | -81.59935761 | 2022-12-19 04:21:03 | Newberry, South Carolina, US | |
506524 | 506524 | 2022-12-17 | US | South Carolina | Newberry | 45071 | 15697 | 210 | 0 | 34.28629098 | -81.59935761 | 2022-12-18 04:21:03 | Newberry, South Carolina, US | |
3327096 | 3327096 | 2022-12-16 | US | South Carolina | Newberry | 45071 | 15697 | 210 | 0 | 34.28629098 | -81.59935761 | 2022-12-17 04:21:04 | Newberry, South Carolina, US | |
545608 | 545608 | 2022-12-15 | US | South Carolina | Newberry | 45071 | 15697 | 210 | 0 | 34.28629098 | -81.59935761 | 2022-12-16 04:21:01 | Newberry, South Carolina, US | |
351136 | 351136 | 2022-12-14 | US | South Carolina | Newberry | 45071 | 15697 | 210 | 0 | 34.28629098 | -81.59935761 | 2022-12-15 04:20:58 | Newberry, South Carolina, US | |
310724 | 310724 | 2022-12-13 | US | South Carolina | Newberry | 45071 | 15697 | 210 | 0 | 34.28629098 | -81.59935761 | 2022-12-14 04:21:04 | Newberry, South Carolina, US | |
1755810 | 1755810 | 2022-11-18 | US | Arkansas | Mississippi | 5093 | 15697 | 226 | 0 | 35.76271485 | -90.0519437 | 2022-11-19 04:21:14 | Mississippi, Arkansas, US | |
434957 | 434957 | 2022-11-03 | US | Wisconsin | Waupaca | 55135 | 15697 | 260 | 0 | 44.47068056 | -88.96534501 | 2022-11-04 04:22:11 | Waupaca, Wisconsin, US | |
232721 | 232721 | 2022-05-31 | US | West Virginia | Marion | 54049 | 15697 | 181 | 0 | 39.50984542 | -80.24244659 | 2022-06-01 04:20:55 | Marion, West Virginia, US | |
335997 | 335997 | 2022-03-18 | Malaysia | Perlis | 15697 | 169 | 0 | 6.4449 | 100.2048 | 2022-03-19 04:20:47 | Perlis, Malaysia | |||
1514396 | 1514396 | 2022-02-24 | US | Tennessee | Roane | 47145 | 15697 | 221 | 0 | 35.84923189 | -84.52458689 | 2022-02-25 04:21:11 | Roane, Tennessee, US | |
3673139 | 3673139 | 2022-02-15 | US | Louisiana | Acadia | 22001 | 15697 | 283 | 0 | 30.295064899999996 | -92.41419698 | 2022-02-16 04:21:10 | Acadia, Louisiana, US | |
1700361 | 1700361 | 2022-01-03 | Japan | Nara | 15697 | 149 | 0 | 34.317451 | 135.871644 | 2022-01-04 04:22:17 | Nara, Japan | |||
2170551 | 2170551 | 2022-01-01 | US | Tennessee | Robertson | 47147 | 15697 | 233 | 0 | 36.52454807 | -86.87346725 | 2022-01-02 04:20:52 | Robertson, Tennessee, US | |
1434735 | 1434735 | 2021-12-28 | US | New Jersey | Cape May | 34009 | 15697 | 251 | 0 | 39.15008829 | -74.80170244 | 2021-12-29 03:21:43 | Cape May, New Jersey, US | |
2721366 | 2721366 | 2021-10-30 | US | Alabama | Cullman | 1043 | 15697 | 296 | 0 | 34.13020303 | -86.86888037 | 2021-10-31 04:22:08 | Cullman, Alabama, US | |
443426 | 443426 | 2021-10-20 | Mali | 15697 | 558 | 0 | 17.570692 | -3.996166000000001 | 2021-10-21 04:21:18 | Mali | ||||
1237038 | 1237038 | 2021-09-27 | US | Kentucky | Daviess | 21059 | 15697 | 237 | 0 | 37.73028906 | -87.09019479999998 | 2021-09-28 04:21:28 | Daviess, Kentucky, US | |
3479505 | 3479505 | 2021-07-22 | US | Texas | Potter | 48375 | 15697 | 463 | 0 | 35.40133773 | -101.893964 | 2021-07-23 04:21:29 | Potter, Texas, US | |
1711408 | 1711408 | 2021-06-02 | US | Texas | Guadalupe | 48187 | 15697 | 216 | 0 | 29.58165339 | -97.94786822 | 2021-06-03 04:23:32 | Guadalupe, Texas, US | |
3663862 | 3663862 | 2021-03-09 | Russia | Tyva Republic | 15697 | 193 | 14644 | 860 | 51.4017149 | 93.8582593 | 2021-03-10 05:24:35 | Tyva Republic, Russia | ||
437798 | 437798 | 2021-01-21 | US | Ohio | Clermont | 39025 | 15697 | 191 | 0 | 15506 | 39.04847534 | -84.15375786 | 2021-01-22 05:22:10 | Clermont, Ohio, US |
202449 | 202449 | 2020-12-25 | Russia | Chuvashia Republic | 15697 | 463 | 14038 | 1196 | 55.4259922 | 47.0849429 | 2020-12-26 05:22:28 | Chuvashia Republic, Russia | ||
741866 | 741866 | 2020-12-02 | US | Wisconsin | Racine | 55101 | 15697 | 183 | 0 | 15514 | 42.74753117 | -88.05941254 | 2020-12-03 05:28:22 | Racine, Wisconsin, US |
786660 | 786660 | 2020-10-15 | Spain | Baleares | 15697 | 325 | 1533 | 13839 | 39.710358 | 2.995148 | 2020-10-16 04:24:01 | Baleares, Spain | ||
2607243 | 2607243 | 2020-09-24 | US | Iowa | Polk | 19153 | 15697 | 261 | 0 | 15436 | 41.68679484 | -93.57767461 | 2020-09-25 04:23:00 | Polk, Iowa, US |
3162192 | 3162192 | 2020-09-06 | US | California | Stanislaus | 6099 | 15697 | 306 | 0 | 15477 | 37.55862499 | -120.9970722 | 2020-09-07 04:28:30 | Stanislaus, California, US |
2386790 | 2386790 | 2020-06-16 | United Kingdom | Scotland | 15697 | 4113 | 0 | 13249 | 56.4907 | -4.2026 | 2020-06-17 04:33:21 | Scotland, United Kingdom |
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]);