johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where confirmed = 19306 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1986228 | 1986228 | 2022-12-07 | US | Maryland | Cecil | 24015 | 19306 | 278 | 0 | 39.56647682 | -75.94627411 | 2022-12-08 04:21:07 | Cecil, Maryland, US | |
2493678 | 2493678 | 2022-06-29 | United Kingdom | Gibraltar | 19306 | 104 | 0 | 36.1408 | -5.3536 | 2022-06-30 04:21:01 | Gibraltar, United Kingdom | |||
2243060 | 2243060 | 2022-06-28 | United Kingdom | Gibraltar | 19306 | 104 | 0 | 36.1408 | -5.3536 | 2022-06-29 04:20:59 | Gibraltar, United Kingdom | |||
2151302 | 2151302 | 2022-06-27 | United Kingdom | Gibraltar | 19306 | 104 | 0 | 36.1408 | -5.3536 | 2022-06-28 04:20:58 | Gibraltar, United Kingdom | |||
479103 | 479103 | 2022-06-26 | United Kingdom | Gibraltar | 19306 | 104 | 0 | 36.1408 | -5.3536 | 2022-06-27 04:21:00 | Gibraltar, United Kingdom | |||
942478 | 942478 | 2022-06-25 | United Kingdom | Gibraltar | 19306 | 104 | 0 | 36.1408 | -5.3536 | 2022-06-26 04:21:02 | Gibraltar, United Kingdom | |||
3350298 | 3350298 | 2022-06-24 | United Kingdom | Gibraltar | 19306 | 104 | 0 | 36.1408 | -5.3536 | 2022-06-25 04:20:57 | Gibraltar, United Kingdom | |||
1652039 | 1652039 | 2022-06-23 | United Kingdom | Gibraltar | 19306 | 104 | 0 | 36.1408 | -5.3536 | 2022-06-24 04:20:58 | Gibraltar, United Kingdom | |||
1466528 | 1466528 | 2022-02-10 | US | Ohio | Ashtabula | 39007 | 19306 | 416 | 0 | 41.70860332 | -80.74830218 | 2022-02-11 04:21:09 | Ashtabula, Ohio, US | |
3076364 | 3076364 | 2022-02-09 | US | North Carolina | Franklin | 37069 | 19306 | 65 | 0 | 36.081519 | -78.28708884 | 2022-02-10 04:21:14 | Franklin, North Carolina, US | |
2903787 | 2903787 | 2021-12-19 | Mali | 19306 | 639 | 0 | 17.570692 | -3.996166000000001 | 2021-12-20 04:21:43 | Mali | ||||
1816941 | 1816941 | 2021-09-19 | US | New Jersey | Cumberland | 34011 | 19306 | 455 | 0 | 39.37199394 | -75.10712559 | 2021-09-20 04:21:22 | Cumberland, New Jersey, US | |
2352457 | 2352457 | 2021-08-10 | US | Illinois | McLean | 17113 | 19306 | 195 | 0 | 40.48996987 | -88.84621113 | 2021-08-11 04:21:58 | McLean, Illinois, US | |
1773683 | 1773683 | 2021-05-23 | US | North Carolina | New Hanover | 37129 | 19306 | 167 | 0 | 34.25758282 | -77.87075626 | 2021-05-24 04:20:53 | New Hanover, North Carolina, US | |
728838 | 728838 | 2021-05-22 | US | North Carolina | New Hanover | 37129 | 19306 | 167 | 0 | 34.25758282 | -77.87075626 | 2021-05-23 04:20:51 | New Hanover, North Carolina, US | |
1954853 | 1954853 | 2021-05-21 | US | North Carolina | New Hanover | 37129 | 19306 | 167 | 0 | 34.25758282 | -77.87075626 | 2021-05-22 04:20:45 | New Hanover, North Carolina, US | |
2939968 | 2939968 | 2021-05-16 | US | Colorado | Pueblo | 8101 | 19306 | 406 | 0 | 38.17359144 | -104.5127437 | 2021-05-17 04:20:34 | Pueblo, Colorado, US | |
648195 | 648195 | 2021-05-05 | US | New York | Niagara | 36063 | 19306 | 346 | 0 | 43.19898042 | -78.74777412 | 2021-05-06 04:20:38 | Niagara, New York, US | |
3643449 | 3643449 | 2021-03-30 | France | Mayotte | 19306 | 154 | 2964 | 16188 | -12.8275 | 45.166244 | 2021-03-31 04:26:25 | Mayotte, France | ||
1289902 | 1289902 | 2021-03-29 | France | Mayotte | 19306 | 154 | 2964 | 16188 | -12.8275 | 45.166244 | 2021-03-30 04:26:23 | Mayotte, France | ||
1535824 | 1535824 | 2021-03-28 | France | Mayotte | 19306 | 154 | 2964 | 16188 | -12.8275 | 45.166244 | 2021-03-29 04:28:35 | Mayotte, France | ||
1219464 | 1219464 | 2021-03-27 | France | Mayotte | 19306 | 154 | 2964 | 16188 | -12.8275 | 45.166244 | 2021-03-28 05:28:10 | Mayotte, France | ||
1880882 | 1880882 | 2021-03-26 | France | Mayotte | 19306 | 154 | 2964 | 16188 | -12.8275 | 45.166244 | 2021-03-27 05:25:04 | Mayotte, France | ||
3421060 | 3421060 | 2021-03-19 | Pakistan | Balochistan | 19306 | 203 | 18919 | 184 | 28.328492 | 65.898403 | 2021-03-20 05:25:46 | Balochistan, Pakistan | ||
2359672 | 2359672 | 2021-03-08 | Russia | Karachay-Cherkess Republic | 19306 | 64 | 17641 | 1601 | 43.7368326 | 41.7267991 | 2021-03-09 05:28:19 | Karachay-Cherkess Republic, Russia | ||
2184377 | 2184377 | 2021-02-26 | US | Georgia | Forsyth | 13117 | 19306 | 148 | 0 | 19158 | 34.22604035 | -84.12315129999998 | 2021-02-27 05:22:28 | Forsyth, Georgia, US |
1897338 | 1897338 | 2021-01-29 | Russia | Amur Oblast | 19306 | 139 | 17587 | 1580 | 52.8032368 | 128.437295 | 2021-01-30 05:22:49 | Amur Oblast, Russia | ||
678697 | 678697 | 2020-11-23 | US | Alabama | Mobile | 1097 | 19306 | 358 | 0 | 18948 | 30.78472347 | -88.20842409 | 2020-11-24 05:27:31 | Mobile, Alabama, US |
98129 | 98129 | 2020-08-04 | Colombia | Bolivar | 19306 | 605 | 14448 | 4253 | 8.6704 | -74.03 | 2020-08-05 04:34:43 | Bolivar, 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]);