johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where confirmed = 19520 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3800853 | 3800853 | 2022-08-20 | US | Tennessee | Gibson | 47053 | 19520 | 268 | 0 | 35.99438059 | -88.93358327 | 2022-08-21 04:20:44 | Gibson, Tennessee, US | |
3969252 | 3969252 | 2022-07-05 | US | Pennsylvania | Somerset | 42111 | 19520 | 412 | 0 | 39.97172723 | -79.02699593 | 2022-07-06 04:20:58 | Somerset, Pennsylvania, US | |
3080763 | 3080763 | 2022-07-04 | US | Pennsylvania | Somerset | 42111 | 19520 | 412 | 0 | 39.97172723 | -79.02699593 | 2022-07-05 04:20:45 | Somerset, Pennsylvania, US | |
1770045 | 1770045 | 2022-07-03 | US | Pennsylvania | Somerset | 42111 | 19520 | 412 | 0 | 39.97172723 | -79.02699593 | 2022-07-04 04:20:54 | Somerset, Pennsylvania, US | |
3368031 | 3368031 | 2022-07-02 | US | Pennsylvania | Somerset | 42111 | 19520 | 412 | 0 | 39.97172723 | -79.02699593 | 2022-07-03 04:20:59 | Somerset, Pennsylvania, US | |
596360 | 596360 | 2022-07-01 | US | Pennsylvania | Somerset | 42111 | 19520 | 412 | 0 | 39.97172723 | -79.02699593 | 2022-07-02 04:21:16 | Somerset, Pennsylvania, US | |
3942761 | 3942761 | 2022-06-30 | US | Pennsylvania | Somerset | 42111 | 19520 | 412 | 0 | 39.97172723 | -79.02699593 | 2022-07-01 04:21:10 | Somerset, Pennsylvania, US | |
3982626 | 3982626 | 2022-06-15 | Japan | Port Quarantine | 19520 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
946867 | 946867 | 2022-06-14 | Japan | Port Quarantine | 19520 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2979275 | 2979275 | 2022-06-13 | Japan | Port Quarantine | 19520 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2235401 | 2235401 | 2022-06-12 | Japan | Port Quarantine | 19520 | 8 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
1996146 | 1996146 | 2022-03-01 | US | West Virginia | Harrison | 54033 | 19520 | 238 | 0 | 39.2853852 | -80.37919577 | 2022-03-02 04:21:07 | Harrison, West Virginia, US | |
3858498 | 3858498 | 2022-02-18 | US | Pennsylvania | Crawford | 42039 | 19520 | 299 | 0 | 41.68447709 | -80.10760592 | 2022-02-19 04:21:11 | Crawford, Pennsylvania, US | |
1780481 | 1780481 | 2022-01-27 | US | Indiana | Hancock | 18059 | 19520 | 225 | 0 | 39.82304555 | -85.77566351 | 2022-01-28 04:21:09 | Hancock, Indiana, US | |
1318660 | 1318660 | 2022-01-26 | US | Arizona | Apache | 4001 | 19520 | 567 | 0 | 35.39465006 | -109.4892383 | 2022-01-27 04:21:19 | Apache, Arizona, US | |
2078617 | 2078617 | 2021-09-26 | US | Pennsylvania | Franklin | 42055 | 19520 | 407 | 0 | 39.92956518 | -77.72157791 | 2021-09-27 04:21:16 | Franklin, Pennsylvania, US | |
3744087 | 3744087 | 2021-07-12 | US | Tennessee | Wilson | 47189 | 19520 | 251 | 0 | 36.15496772 | -86.29775884 | 2021-07-13 04:21:18 | Wilson, Tennessee, US | |
36436 | 36436 | 2021-04-12 | Japan | Fukuoka | 19520 | 341 | 18614 | 565 | 33.526032 | 130.666949 | 2021-04-13 04:20:37 | Fukuoka, Japan | ||
2864944 | 2864944 | 2021-01-06 | Russia | Novgorod Oblast | 19520 | 99 | 14234 | 5187 | 58.2843833 | 32.5169757 | 2021-01-07 05:22:03 | Novgorod Oblast, Russia | ||
3695609 | 3695609 | 2020-12-31 | Netherlands | Flevoland | 19520 | 156 | 0 | 19382 | 52.550383 | 5.515162 | 2021-01-01 05:23:07 | Flevoland, Netherlands | ||
2225018 | 2225018 | 2020-12-26 | US | Louisiana | Orleans | 22071 | 19520 | 673 | 0 | 18847 | 30.06971951 | -89.92660315 | 2020-12-27 05:22:55 | Orleans, Louisiana, US |
203765 | 203765 | 2020-12-25 | US | Louisiana | Orleans | 22071 | 19520 | 673 | 0 | 18847 | 30.06971951 | -89.92660315 | 2020-12-26 05:22:28 | Orleans, Louisiana, US |
3692988 | 3692988 | 2020-12-24 | US | Louisiana | Orleans | 22071 | 19520 | 673 | 0 | 18847 | 30.06971951 | -89.92660315 | 2020-12-25 05:22:48 | Orleans, Louisiana, US |
1034624 | 1034624 | 2020-12-15 | Russia | Tula Oblast | 19520 | 577 | 17089 | 1854 | 53.9570701 | 37.3690909 | 2020-12-16 05:28:04 | Tula Oblast, Russia | ||
3785999 | 3785999 | 2020-10-11 | Mexico | Yucatan | 19520 | 1662 | 16980 | 878 | 20.7099 | -89.0943 | 2020-10-12 04:23:45 | Yucatan, 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]);