johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
30 rows where confirmed = 14584 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
115588 | 115588 | 2022-09-06 | US | Georgia | Liberty | 13179 | 14584 | 155 | 0 | 31.82588896 | -81.49251135 | 2022-09-07 04:20:59 | Liberty, Georgia, US | |
2634560 | 2634560 | 2022-09-05 | US | Georgia | Liberty | 13179 | 14584 | 155 | 0 | 31.82588896 | -81.49251135 | 2022-09-06 04:21:02 | Liberty, Georgia, US | |
2988124 | 2988124 | 2022-09-04 | US | Georgia | Liberty | 13179 | 14584 | 155 | 0 | 31.82588896 | -81.49251135 | 2022-09-05 04:21:01 | Liberty, Georgia, US | |
2713809 | 2713809 | 2022-09-03 | US | Georgia | Liberty | 13179 | 14584 | 155 | 0 | 31.82588896 | -81.49251135 | 2022-09-04 04:21:22 | Liberty, Georgia, US | |
1394514 | 1394514 | 2022-09-02 | US | Georgia | Liberty | 13179 | 14584 | 155 | 0 | 31.82588896 | -81.49251135 | 2022-09-03 04:21:04 | Liberty, Georgia, US | |
3548343 | 3548343 | 2022-09-01 | US | Georgia | Liberty | 13179 | 14584 | 155 | 0 | 31.82588896 | -81.49251135 | 2022-09-02 04:21:07 | Liberty, Georgia, US | |
2344263 | 2344263 | 2022-08-31 | US | Georgia | Liberty | 13179 | 14584 | 155 | 0 | 31.82588896 | -81.49251135 | 2022-09-01 04:21:03 | Liberty, Georgia, US | |
2596239 | 2596239 | 2022-07-25 | US | New Mexico | Otero | 35035 | 14584 | 200 | 0 | 32.61348406 | -105.7417604 | 2022-07-26 04:20:58 | Otero, New Mexico, US | |
897285 | 897285 | 2022-07-24 | US | Indiana | Shelby | 18145 | 14584 | 184 | 0 | 39.52305623 | -85.7915857 | 2022-07-25 04:20:51 | Shelby, Indiana, US | |
92279 | 92279 | 2022-07-23 | US | Indiana | Shelby | 18145 | 14584 | 184 | 0 | 39.52305623 | -85.7915857 | 2022-07-24 04:20:47 | Shelby, Indiana, US | |
901301 | 901301 | 2022-07-22 | US | Indiana | Shelby | 18145 | 14584 | 184 | 0 | 39.52305623 | -85.7915857 | 2022-07-23 04:20:53 | Shelby, Indiana, US | |
1224368 | 1224368 | 2022-04-14 | US | Georgia | Catoosa | 13047 | 14584 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-15 04:20:57 | Catoosa, Georgia, US | |
2014176 | 2014176 | 2022-02-06 | US | Kentucky | Scott | 21209 | 14584 | 85 | 0 | 38.29622293 | -84.5816631 | 2022-02-07 04:21:05 | Scott, Kentucky, US | |
1295505 | 1295505 | 2022-02-05 | US | Kentucky | Scott | 21209 | 14584 | 85 | 0 | 38.29622293 | -84.5816631 | 2022-02-06 04:21:00 | Scott, Kentucky, US | |
2328833 | 2328833 | 2022-02-04 | US | Kentucky | Scott | 21209 | 14584 | 85 | 0 | 38.29622293 | -84.5816631 | 2022-02-05 04:21:05 | Scott, Kentucky, US | |
2473749 | 2473749 | 2022-02-03 | China | Hong Kong | 14584 | 213 | 0 | 22.3 | 114.2 | 2022-02-04 04:21:10 | Hong Kong, China | |||
3427432 | 3427432 | 2022-01-21 | US | Ohio | Lawrence | 39087 | 14584 | 218 | 0 | 38.59743452 | -82.53466552 | 2022-01-22 04:21:13 | Lawrence, Ohio, US | |
1663414 | 1663414 | 2021-12-12 | US | Tennessee | Robertson | 47147 | 14584 | 206 | 0 | 36.52454807 | -86.87346725 | 2021-12-13 04:22:02 | Robertson, Tennessee, US | |
1778910 | 1778910 | 2021-08-30 | US | Wisconsin | La Crosse | 55063 | 14584 | 95 | 0 | 43.90632465 | -91.11451093 | 2021-08-31 04:21:46 | La Crosse, Wisconsin, US | |
512806 | 512806 | 2021-08-19 | US | Indiana | Madison | 18095 | 14584 | 353 | 0 | 40.16143691 | -85.71964711 | 2021-08-20 04:21:33 | Madison, Indiana, US | |
3904043 | 3904043 | 2021-07-31 | Mali | 14584 | 532 | 13945 | 107 | 17.570692 | -3.996166000000001 | 2021-08-01 04:21:50 | Mali | |||
2591004 | 2591004 | 2021-06-27 | US | Illinois | Kankakee | 17091 | 14584 | 216 | 0 | 41.13746989 | -87.86205334 | 2021-06-28 04:21:29 | Kankakee, Illinois, US | |
3959508 | 3959508 | 2021-06-26 | US | Illinois | Kankakee | 17091 | 14584 | 216 | 0 | 41.13746989 | -87.86205334 | 2021-06-27 04:21:39 | Kankakee, Illinois, US | |
1713327 | 1713327 | 2021-06-25 | US | Illinois | Kankakee | 17091 | 14584 | 216 | 0 | 41.13746989 | -87.86205334 | 2021-06-26 04:21:43 | Kankakee, Illinois, US | |
2007658 | 2007658 | 2021-05-12 | US | Tennessee | Washington | 47179 | 14584 | 244 | 0 | 36.29472368 | -82.49454720000001 | 2021-05-13 04:20:51 | Washington, Tennessee, US | |
383674 | 383674 | 2021-04-30 | US | West Virginia | Kanawha | 54039 | 14584 | 331 | 0 | 38.33860077 | -81.52857054 | 2021-05-01 04:20:47 | Kanawha, West Virginia, US | |
3926676 | 3926676 | 2021-04-24 | US | Pennsylvania | Franklin | 42055 | 14584 | 356 | 0 | 39.92956518 | -77.72157791 | 2021-04-25 04:20:32 | Franklin, Pennsylvania, US | |
2215219 | 2215219 | 2021-01-30 | US | Wisconsin | Marathon | 55073 | 14584 | 201 | 0 | 14383 | 44.89792533 | -89.75863384 | 2021-01-31 05:22:42 | Marathon, Wisconsin, US |
2933367 | 2933367 | 2020-12-19 | US | New Hampshire | Hillsborough | 33011 | 14584 | 384 | 0 | 14200 | 42.91537785 | -71.7200253 | 2020-12-20 05:27:32 | Hillsborough, New Hampshire, US |
1026210 | 1026210 | 2020-10-17 | Colombia | Risaralda | 14584 | 313 | 12371 | 1900 | 5.3158 | -75.9928 | 2020-10-18 04:24:25 | Risaralda, 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]);