johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 28844 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 8
- Peru 7
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2259929 | 2259929 | 2022-10-02 | Peru | Huancavelica | 28844 | 1312 | 0 | -13.023888 | -75.00277 | 2022-10-03 04:23:11 | Huancavelica, Peru | |||
2995455 | 2995455 | 2022-10-01 | Peru | Huancavelica | 28844 | 1312 | 0 | -13.023888 | -75.00277 | 2022-10-02 04:21:23 | Huancavelica, Peru | |||
853781 | 853781 | 2022-09-30 | Peru | Huancavelica | 28844 | 1312 | 0 | -13.023888 | -75.00277 | 2022-10-01 04:23:01 | Huancavelica, Peru | |||
2375707 | 2375707 | 2022-09-29 | Peru | Huancavelica | 28844 | 1312 | 0 | -13.023888 | -75.00277 | 2022-09-30 04:23:09 | Huancavelica, Peru | |||
1560258 | 1560258 | 2022-09-28 | Peru | Huancavelica | 28844 | 1312 | 0 | -13.023888 | -75.00277 | 2022-09-29 04:22:34 | Huancavelica, Peru | |||
3994801 | 3994801 | 2022-09-27 | Peru | Huancavelica | 28844 | 1312 | 0 | -13.023888 | -75.00277 | 2022-09-28 04:23:01 | Huancavelica, Peru | |||
2769129 | 2769129 | 2022-09-26 | Peru | Huancavelica | 28844 | 1312 | 0 | -13.023888 | -75.00277 | 2022-09-27 04:23:01 | Huancavelica, Peru | |||
971292 | 971292 | 2022-06-01 | US | Alabama | Etowah | 1055 | 28844 | 652 | 0 | 34.04567266 | -86.04051873 | 2022-06-02 05:20:39 | Etowah, Alabama, US | |
2478981 | 2478981 | 2022-03-30 | US | Illinois | LaSalle | 17099 | 28844 | 381 | 0 | 41.34426129999999 | -88.88633881 | 2022-03-31 04:20:56 | LaSalle, Illinois, US | |
1080763 | 1080763 | 2021-12-09 | US | South Carolina | Pickens | 45077 | 28844 | 496 | 0 | 34.88807695 | -82.72791551 | 2021-12-10 04:22:28 | Pickens, South Carolina, US | |
3575672 | 3575672 | 2021-05-17 | US | Indiana | Elkhart | 18039 | 28844 | 443 | 0 | 41.59761169 | -85.85875695 | 2021-05-18 04:20:33 | Elkhart, Indiana, US | |
2548994 | 2548994 | 2021-04-15 | Netherlands | Drenthe | 28844 | 337 | 0 | 28474 | 52.862485 | 6.618435000000002 | 2021-04-16 04:20:46 | Drenthe, Netherlands | ||
1581663 | 1581663 | 2021-03-13 | US | Louisiana | Orleans | 22071 | 28844 | 770 | 0 | 30.06971951 | -89.92660315 | 2021-03-14 05:25:37 | Orleans, Louisiana, US | |
1839442 | 1839442 | 2021-03-12 | US | Louisiana | Orleans | 22071 | 28844 | 770 | 0 | 30.06971951 | -89.92660315 | 2021-03-13 05:25:15 | Orleans, Louisiana, US | |
184545 | 184545 | 2021-02-21 | US | Ohio | Stark | 39151 | 28844 | 864 | 0 | 27980 | 40.81482476 | -81.36437305 | 2021-02-22 05:24:21 | Stark, Ohio, US |
969222 | 969222 | 2020-09-29 | US | North Carolina | Mecklenburg | 37119 | 28844 | 354 | 0 | 28490 | 35.24469268 | -80.8317671 | 2020-09-30 04:23:33 | Mecklenburg, North Carolina, US |
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]);