johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where confirmed = 19484 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952968 | 2952968 | 2022-12-20 | US | Maryland | Cecil | 24015 | 19484 | 279 | 0 | 39.56647682 | -75.94627411 | 2022-12-21 04:21:03 | Cecil, Maryland, US | |
2688483 | 2688483 | 2022-10-03 | US | Puerto Rico | Toa Alta | 72135 | 19484 | 0 | 0 | 18.362406 | -66.246616 | 2022-10-04 04:22:55 | Toa Alta, Puerto Rico, US | |
254060 | 254060 | 2022-09-08 | US | Florida | Walton | 12131 | 19484 | 222 | 0 | 30.64204028 | -86.16935664 | 2022-09-09 04:21:11 | Walton, Florida, US | |
3745858 | 3745858 | 2022-09-07 | US | Florida | Walton | 12131 | 19484 | 222 | 0 | 30.64204028 | -86.16935664 | 2022-09-08 04:21:02 | Walton, Florida, US | |
115498 | 115498 | 2022-09-06 | US | Florida | Walton | 12131 | 19484 | 222 | 0 | 30.64204028 | -86.16935664 | 2022-09-07 04:20:59 | Walton, Florida, US | |
2634470 | 2634470 | 2022-09-05 | US | Florida | Walton | 12131 | 19484 | 219 | 0 | 30.64204028 | -86.16935664 | 2022-09-06 04:21:02 | Walton, Florida, US | |
2988034 | 2988034 | 2022-09-04 | US | Florida | Walton | 12131 | 19484 | 219 | 0 | 30.64204028 | -86.16935664 | 2022-09-05 04:21:01 | Walton, Florida, US | |
2713719 | 2713719 | 2022-09-03 | US | Florida | Walton | 12131 | 19484 | 219 | 0 | 30.64204028 | -86.16935664 | 2022-09-04 04:21:22 | Walton, Florida, US | |
1394424 | 1394424 | 2022-09-02 | US | Florida | Walton | 12131 | 19484 | 219 | 0 | 30.64204028 | -86.16935664 | 2022-09-03 04:21:04 | Walton, Florida, US | |
3548253 | 3548253 | 2022-09-01 | US | Florida | Walton | 12131 | 19484 | 219 | 0 | 30.64204028 | -86.16935664 | 2022-09-02 04:21:07 | Walton, Florida, US | |
2344173 | 2344173 | 2022-08-31 | US | Florida | Walton | 12131 | 19484 | 219 | 0 | 30.64204028 | -86.16935664 | 2022-09-01 04:21:03 | Walton, Florida, US | |
3774653 | 3774653 | 2022-08-30 | US | Florida | Walton | 12131 | 19484 | 219 | 0 | 30.64204028 | -86.16935664 | 2022-08-31 04:20:57 | Walton, Florida, US | |
1681249 | 1681249 | 2022-08-29 | US | Florida | Walton | 12131 | 19484 | 220 | 0 | 30.64204028 | -86.16935664 | 2022-08-30 04:21:03 | Walton, Florida, US | |
1877733 | 1877733 | 2022-08-28 | US | Florida | Walton | 12131 | 19484 | 220 | 0 | 30.64204028 | -86.16935664 | 2022-08-29 04:21:06 | Walton, Florida, US | |
2096860 | 2096860 | 2022-08-27 | US | Florida | Walton | 12131 | 19484 | 220 | 0 | 30.64204028 | -86.16935664 | 2022-08-28 04:21:02 | Walton, Florida, US | |
1532675 | 1532675 | 2022-08-26 | US | Florida | Walton | 12131 | 19484 | 220 | 0 | 30.64204028 | -86.16935664 | 2022-08-27 04:20:57 | Walton, Florida, US | |
1164110 | 1164110 | 2022-08-18 | US | Tennessee | Gibson | 47053 | 19484 | 268 | 0 | 35.99438059 | -88.93358327 | 2022-08-19 04:20:54 | Gibson, Tennessee, US | |
3854279 | 3854279 | 2022-04-27 | US | Ohio | Erie | 39043 | 19484 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-28 04:20:47 | Erie, Ohio, US | |
1328709 | 1328709 | 2022-04-26 | US | Ohio | Erie | 39043 | 19484 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-27 04:20:52 | Erie, Ohio, US | |
3724663 | 3724663 | 2022-04-25 | US | Ohio | Erie | 39043 | 19484 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-26 04:20:51 | Erie, Ohio, US | |
2031231 | 2031231 | 2022-04-24 | US | Ohio | Erie | 39043 | 19484 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-25 04:20:56 | Erie, Ohio, US | |
748806 | 748806 | 2022-04-23 | US | Ohio | Erie | 39043 | 19484 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-24 04:20:56 | Erie, Ohio, US | |
3439291 | 3439291 | 2022-04-22 | US | Ohio | Erie | 39043 | 19484 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-23 04:20:50 | Erie, Ohio, US | |
2894876 | 2894876 | 2022-04-21 | US | Ohio | Erie | 39043 | 19484 | 268 | 0 | 41.36796058 | -82.62904521 | 2022-04-22 04:20:45 | Erie, Ohio, US | |
1224392 | 1224392 | 2022-04-14 | US | Georgia | Dougherty | 13095 | 19484 | 492 | 0 | 31.53328528 | -84.21722377 | 2022-04-15 04:20:57 | Dougherty, Georgia, US | |
1511958 | 1511958 | 2022-02-24 | US | California | Humboldt | 6023 | 19484 | 138 | 0 | 40.69923009 | -123.876044 | 2022-02-25 04:21:11 | Humboldt, California, US | |
2016109 | 2016109 | 2022-02-06 | US | Virginia | Roanoke | 51161 | 19484 | 212 | 0 | 37.26865804 | -80.06396753 | 2022-02-07 04:21:05 | Roanoke, Virginia, US | |
1297438 | 1297438 | 2022-02-05 | US | Virginia | Roanoke | 51161 | 19484 | 212 | 0 | 37.26865804 | -80.06396753 | 2022-02-06 04:21:00 | Roanoke, Virginia, US | |
2330766 | 2330766 | 2022-02-04 | US | Virginia | Roanoke | 51161 | 19484 | 212 | 0 | 37.26865804 | -80.06396753 | 2022-02-05 04:21:05 | Roanoke, Virginia, US | |
1671871 | 1671871 | 2021-12-29 | US | Virginia | Stafford | 51179 | 19484 | 116 | 0 | 38.41758738 | -77.45917053 | 2021-12-30 04:21:25 | Stafford, Virginia, US | |
2811943 | 2811943 | 2021-09-16 | US | Texas | Potter | 48375 | 19484 | 520 | 0 | 35.40133773 | -101.893964 | 2021-09-17 04:21:46 | Potter, Texas, US | |
3742205 | 3742205 | 2021-07-12 | US | Indiana | Porter | 18127 | 19484 | 327 | 0 | 41.45986947 | -87.06848888 | 2021-07-13 04:21:18 | Porter, Indiana, US | |
2719313 | 2719313 | 2021-06-10 | US | North Carolina | New Hanover | 37129 | 19484 | 173 | 0 | 34.25758282 | -77.87075626 | 2021-06-11 04:23:20 | New Hanover, North Carolina, US | |
3003978 | 3003978 | 2021-04-06 | US | Florida | Bay | 12005 | 19484 | 376 | 0 | 30.26548745 | -85.62122584 | 2021-04-07 04:20:53 | Bay, Florida, US | |
1744744 | 1744744 | 2021-03-20 | Russia | Karachay-Cherkess Republic | 19484 | 69 | 18123 | 1292 | 43.7368326 | 41.7267991 | 2021-03-21 05:25:44 | Karachay-Cherkess Republic, Russia | ||
3621406 | 3621406 | 2021-03-17 | Sweden | Vastmanland | 19484 | 330 | 0 | 19154 | 59.6714 | 16.2159 | 2021-03-18 05:26:22 | Vastmanland, Sweden | ||
2626635 | 2626635 | 2021-01-10 | US | Georgia | Cherokee | 13057 | 19484 | 137 | 0 | 19347 | 34.24393976 | -84.47431861 | 2021-01-11 05:21:50 | Cherokee, Georgia, US |
923916 | 923916 | 2020-11-26 | Russia | Perm Krai | 19484 | 573 | 13382 | 5529 | 58.5951603 | 56.3159546 | 2020-11-27 05:26:53 | Perm Krai, Russia | ||
1728277 | 1728277 | 2020-11-08 | Chile | Maule | 19484 | 435 | 18531 | 518 | -35.5183 | -71.6885 | 2020-11-09 05:25:45 | Maule, Chile | ||
2582134 | 2582134 | 2020-09-27 | Peru | Cajamarca | 19484 | 1332 | 0 | 18152 | -6.430284 | -78.745596 | 2020-09-28 04:23:00 | Cajamarca, Peru |
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]);