johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where confirmed = 19996 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
961578 | 961578 | 2022-07-19 | US | Pennsylvania | Lawrence | 42073 | 19996 | 426 | 0 | 40.99206278 | -80.33393706 | 2022-07-20 04:20:59 | Lawrence, Pennsylvania, US | |
959323 | 959323 | 2022-07-19 | US | Alaska | Kenai Peninsula | 2122 | 19996 | 110 | 0 | 60.24429722 | -151.5388884 | 2022-07-20 04:20:59 | Kenai Peninsula, Alaska, US | |
3212965 | 3212965 | 2022-07-18 | US | Pennsylvania | Lawrence | 42073 | 19996 | 426 | 0 | 40.99206278 | -80.33393706 | 2022-07-19 04:20:58 | Lawrence, Pennsylvania, US | |
3210710 | 3210710 | 2022-07-18 | US | Alaska | Kenai Peninsula | 2122 | 19996 | 110 | 0 | 60.24429722 | -151.5388884 | 2022-07-19 04:20:58 | Kenai Peninsula, Alaska, US | |
3408140 | 3408140 | 2022-07-17 | US | Pennsylvania | Lawrence | 42073 | 19996 | 426 | 0 | 40.99206278 | -80.33393706 | 2022-07-18 04:20:59 | Lawrence, Pennsylvania, US | |
3405885 | 3405885 | 2022-07-17 | US | Alaska | Kenai Peninsula | 2122 | 19996 | 110 | 0 | 60.24429722 | -151.5388884 | 2022-07-18 04:20:59 | Kenai Peninsula, Alaska, US | |
2154340 | 2154340 | 2022-07-16 | US | Pennsylvania | Lawrence | 42073 | 19996 | 426 | 0 | 40.99206278 | -80.33393706 | 2022-07-17 04:21:15 | Lawrence, Pennsylvania, US | |
2152085 | 2152085 | 2022-07-16 | US | Alaska | Kenai Peninsula | 2122 | 19996 | 110 | 0 | 60.24429722 | -151.5388884 | 2022-07-17 04:21:15 | Kenai Peninsula, Alaska, US | |
2421573 | 2421573 | 2022-07-15 | US | Pennsylvania | Lawrence | 42073 | 19996 | 426 | 0 | 40.99206278 | -80.33393706 | 2022-07-16 04:21:05 | Lawrence, Pennsylvania, US | |
2419318 | 2419318 | 2022-07-15 | US | Alaska | Kenai Peninsula | 2122 | 19996 | 110 | 0 | 60.24429722 | -151.5388884 | 2022-07-16 04:21:05 | Kenai Peninsula, Alaska, US | |
3431648 | 3431648 | 2022-07-14 | US | Pennsylvania | Lawrence | 42073 | 19996 | 426 | 0 | 40.99206278 | -80.33393706 | 2022-07-15 04:20:53 | Lawrence, Pennsylvania, US | |
3429393 | 3429393 | 2022-07-14 | US | Alaska | Kenai Peninsula | 2122 | 19996 | 110 | 0 | 60.24429722 | -151.5388884 | 2022-07-15 04:20:53 | Kenai Peninsula, Alaska, US | |
3112168 | 3112168 | 2022-07-13 | US | Pennsylvania | Lawrence | 42073 | 19996 | 426 | 0 | 40.99206278 | -80.33393706 | 2022-07-14 04:20:57 | Lawrence, Pennsylvania, US | |
3109913 | 3109913 | 2022-07-13 | US | Alaska | Kenai Peninsula | 2122 | 19996 | 110 | 0 | 60.24429722 | -151.5388884 | 2022-07-14 04:20:57 | Kenai Peninsula, Alaska, US | |
3189362 | 3189362 | 2022-05-30 | US | Virginia | Lynchburg | 51680 | 19996 | 267 | 0 | 37.40021399 | -79.19888138 | 2022-05-31 04:20:51 | Lynchburg, Virginia, US | |
3201511 | 3201511 | 2022-05-29 | US | Virginia | Lynchburg | 51680 | 19996 | 267 | 0 | 37.40021399 | -79.19888138 | 2022-05-30 04:20:50 | Lynchburg, Virginia, US | |
2728389 | 2728389 | 2022-05-28 | US | Virginia | Lynchburg | 51680 | 19996 | 267 | 0 | 37.40021399 | -79.19888138 | 2022-05-29 04:20:53 | Lynchburg, Virginia, US | |
1317570 | 1317570 | 2022-05-27 | US | Virginia | Lynchburg | 51680 | 19996 | 267 | 0 | 37.40021399 | -79.19888138 | 2022-05-28 04:21:07 | Lynchburg, Virginia, US | |
3447334 | 3447334 | 2022-05-11 | US | Ohio | Marion | 39101 | 19996 | 268 | 0 | 40.58610662 | -83.15736305 | 2022-05-12 04:20:54 | Marion, Ohio, US | |
3537951 | 3537951 | 2022-05-10 | US | Ohio | Marion | 39101 | 19996 | 268 | 0 | 40.58610662 | -83.15736305 | 2022-05-11 04:20:48 | Marion, Ohio, US | |
224486 | 224486 | 2022-05-09 | US | Ohio | Marion | 39101 | 19996 | 268 | 0 | 40.58610662 | -83.15736305 | 2022-05-10 04:20:50 | Marion, Ohio, US | |
2333871 | 2333871 | 2022-05-08 | US | Ohio | Marion | 39101 | 19996 | 268 | 0 | 40.58610662 | -83.15736305 | 2022-05-09 04:20:54 | Marion, Ohio, US | |
362833 | 362833 | 2022-05-07 | US | Ohio | Marion | 39101 | 19996 | 268 | 0 | 40.58610662 | -83.15736305 | 2022-05-08 04:20:49 | Marion, Ohio, US | |
1400184 | 1400184 | 2022-05-06 | US | Ohio | Marion | 39101 | 19996 | 268 | 0 | 40.58610662 | -83.15736305 | 2022-05-07 04:21:09 | Marion, Ohio, US | |
2600539 | 2600539 | 2022-05-05 | US | Ohio | Marion | 39101 | 19996 | 268 | 0 | 40.58610662 | -83.15736305 | 2022-05-06 04:21:00 | Marion, Ohio, US | |
2012546 | 2012546 | 2022-02-06 | Colombia | Putumayo | 19996 | 748 | 0 | 0.436 | -75.5277 | 2022-02-07 04:21:05 | Putumayo, Colombia | |||
1117199 | 1117199 | 2022-01-11 | US | Wyoming | Laramie | 56021 | 19996 | 239 | 0 | 41.30702520000001 | -104.6887497 | 2022-01-12 04:21:44 | Laramie, Wyoming, US | |
1289418 | 1289418 | 2022-01-04 | US | Virginia | Spotsylvania | 51177 | 19996 | 185 | 0 | 38.18574462 | -77.655399 | 2022-01-05 04:21:59 | Spotsylvania, Virginia, US | |
3930688 | 3930688 | 2021-10-02 | US | Pennsylvania | Beaver | 42007 | 19996 | 432 | 0 | 40.6825484 | -80.34921611 | 2021-10-03 04:21:24 | Beaver, Pennsylvania, US | |
605281 | 605281 | 2021-09-23 | US | Wisconsin | Washington | 55131 | 19996 | 214 | 0 | 43.36863664 | -88.22974712 | 2021-09-24 04:21:44 | Washington, Wisconsin, US | |
955070 | 955070 | 2021-04-25 | Russia | Karachay-Cherkess Republic | 19996 | 73 | 19859 | 64 | 43.7368326 | 41.7267991 | 2021-04-26 04:21:04 | Karachay-Cherkess Republic, Russia | ||
1841518 | 1841518 | 2021-03-12 | US | Wisconsin | Winnebago | 55139 | 19996 | 205 | 0 | 44.06886922 | -88.64477096 | 2021-03-13 05:25:15 | Winnebago, Wisconsin, US | |
1674680 | 1674680 | 2021-02-07 | US | New York | Dutchess | 36027 | 19996 | 381 | 0 | 19615 | 41.76486060000001 | -73.74356679 | 2021-02-08 05:22:39 | Dutchess, New York, US |
790075 | 790075 | 2021-02-04 | Angola | 19996 | 473 | 18381 | 1142 | -11.2027 | 17.8739 | 2021-02-05 05:22:38 | Angola | |||
1898291 | 1898291 | 2021-01-29 | US | Indiana | Vanderburgh | 18163 | 19996 | 343 | 0 | 19653 | 38.02658833 | -87.58763124 | 2021-01-30 05:22:49 | Vanderburgh, Indiana, US |
2228095 | 2228095 | 2021-01-02 | US | California | Solano | 6095 | 19996 | 97 | 0 | 19910 | 38.26827353 | -121.9357113 | 2021-01-03 05:22:52 | Solano, California, US |
2407355 | 2407355 | 2020-12-23 | US | Arkansas | Washington | 5143 | 19996 | 212 | 0 | 19784 | 35.976844 | -94.21800746 | 2020-12-24 05:23:04 | Washington, Arkansas, US |
3785993 | 3785993 | 2020-10-11 | Mexico | Sinaloa | 19996 | 3398 | 15948 | 650 | 25.1721 | -107.4795 | 2020-10-12 04:23:45 | Sinaloa, Mexico |
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]);