johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where deaths = 7444 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2506368 | 2506368 | 2022-11-10 | Spain | Pais Vasco | 780898 | 7444 | 0 | 42.9896 | -2.6189 | 2022-11-11 04:21:22 | Pais Vasco, Spain | |||
2431243 | 2431243 | 2022-11-09 | Spain | Pais Vasco | 780898 | 7444 | 0 | 42.9896 | -2.6189 | 2022-11-10 04:21:16 | Pais Vasco, Spain | |||
479899 | 479899 | 2022-11-08 | Spain | Pais Vasco | 780898 | 7444 | 0 | 42.9896 | -2.6189 | 2022-11-09 04:21:22 | Pais Vasco, Spain | |||
2439049 | 2439049 | 2022-11-07 | Spain | Pais Vasco | 780898 | 7444 | 0 | 42.9896 | -2.6189 | 2022-11-08 04:21:21 | Pais Vasco, Spain | |||
1050147 | 1050147 | 2022-11-06 | Spain | Pais Vasco | 780898 | 7444 | 0 | 42.9896 | -2.6189 | 2022-11-07 04:21:26 | Pais Vasco, Spain | |||
618171 | 618171 | 2022-11-05 | Spain | Pais Vasco | 780898 | 7444 | 0 | 42.9896 | -2.6189 | 2022-11-06 04:21:24 | Pais Vasco, Spain | |||
1022675 | 1022675 | 2022-11-04 | Spain | Pais Vasco | 780898 | 7444 | 0 | 42.9896 | -2.6189 | 2022-11-05 04:21:52 | Pais Vasco, Spain | |||
3730430 | 3730430 | 2022-04-03 | Russia | Chelyabinsk Oblast | 318394 | 7444 | 0 | 54.4223954 | 61.1865846 | 2022-04-04 04:20:51 | Chelyabinsk Oblast, Russia | |||
2012436 | 2012436 | 2022-02-06 | Brazil | Piaui | 351240 | 7444 | 0 | -7.7183 | -42.7289 | 2022-02-07 04:21:05 | Piaui, Brazil | |||
1472071 | 1472071 | 2022-01-17 | India | Uttarakhand | 373249 | 7444 | 0 | 30.156446999999996 | 79.197608 | 2022-01-18 04:21:04 | Uttarakhand, India | |||
1078220 | 1078220 | 2021-12-09 | Spain | Castilla y Leon | 317263 | 7444 | 0 | 41.8357 | -4.3976 | 2021-12-10 04:22:28 | Castilla y Leon, Spain | |||
682572 | 682572 | 2021-10-24 | Russia | Nizhny Novgorod Oblast | 185699 | 7444 | 0 | 55.47180329999999 | 44.091159399999995 | 2021-10-25 04:22:31 | Nizhny Novgorod Oblast, Russia | |||
3970630 | 3970630 | 2021-06-11 | Mexico | Chihuahua | 57145 | 7444 | 0 | 49701 | 28.633000000000006 | -106.0691 | 2021-06-12 04:22:22 | Chihuahua, Mexico | ||
3185208 | 3185208 | 2020-07-28 | Chile | Metropolitana | 253688 | 7444 | 238880 | 7364 | -33.4376 | -70.6505 | 2020-07-29 04:35:11 | Metropolitana, Chile |
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]);