daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where deaths = 519 and province_or_state = "Extremadura" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-29 | Spain | Extremadura | 3345 | 519 | 2652 | 174 | 39.4937 | -6.0679 | 2020-07-30 04:35:05 | Extremadura, Spain | ||
2020-07-28 | Spain | Extremadura | 3322 | 519 | 2652 | 151 | 39.4937 | -6.0679 | 2020-07-29 04:35:11 | Extremadura, Spain | ||
2020-07-27 | Spain | Extremadura | 3316 | 519 | 2652 | 145 | 39.4937 | -6.0679 | 2020-07-28 04:58:43 | Extremadura, Spain | ||
2020-07-26 | Spain | Extremadura | 3302 | 519 | 2652 | 131 | 39.4937 | -6.0679 | 2020-07-27 04:35:02 | Extremadura, Spain | ||
2020-07-25 | Spain | Extremadura | 3302 | 519 | 2652 | 131 | 39.4937 | -6.0679 | 2020-07-26 04:35:00 | Extremadura, Spain | ||
2020-07-24 | Spain | Extremadura | 3302 | 519 | 2652 | 131 | 39.4937 | -6.0679 | 2020-07-25 04:47:39 | Extremadura, Spain | ||
2020-07-23 | Spain | Extremadura | 3298 | 519 | 2652 | 127 | 39.4937 | -6.0679 | 2020-07-24 05:30:40 | Extremadura, Spain | ||
2020-07-22 | Spain | Extremadura | 3295 | 519 | 2652 | 124 | 39.4937 | -6.0679 | 2020-07-23 05:15:04 | Extremadura, Spain | ||
2020-07-21 | Spain | Extremadura | 3278 | 519 | 2652 | 107 | 39.4937 | -6.0679 | 2020-07-22 04:34:42 | Extremadura, Spain | ||
2020-07-20 | Spain | Extremadura | 3266 | 519 | 2652 | 95 | 39.4937 | -6.0679 | 2020-07-21 04:38:46 | Extremadura, Spain | ||
2020-07-19 | Spain | Extremadura | 3243 | 519 | 2652 | 72 | 39.4937 | -6.0679 | 2020-07-20 05:34:40 | Extremadura, Spain | ||
2020-07-18 | Spain | Extremadura | 3243 | 519 | 2652 | 72 | 39.4937 | -6.0679 | 2020-07-19 04:34:58 | Extremadura, Spain | ||
2020-07-17 | Spain | Extremadura | 3243 | 519 | 2652 | 72 | 39.4937 | -6.0679 | 2020-07-18 04:34:45 | Extremadura, Spain | ||
2020-07-16 | Spain | Extremadura | 3218 | 519 | 2652 | 47 | 39.4937 | -6.0679 | 2020-07-17 04:34:50 | Extremadura, Spain | ||
2020-07-15 | Spain | Extremadura | 3208 | 519 | 2652 | 37 | 39.4937 | -6.0679 | 2020-07-16 04:44:59 | Extremadura, Spain | ||
2020-07-14 | Spain | Extremadura | 3202 | 519 | 2652 | 31 | 39.4937 | -6.0679 | 2020-07-15 04:34:39 | Extremadura, Spain | ||
2020-07-13 | Spain | Extremadura | 3191 | 519 | 2652 | 20 | 39.4937 | -6.0679 | 2020-07-14 04:34:46 | Extremadura, Spain | ||
2020-07-12 | Spain | Extremadura | 3106 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-13 04:43:04 | Extremadura, Spain | ||
2020-07-11 | Spain | Extremadura | 3106 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-12 04:34:30 | Extremadura, Spain | ||
2020-07-10 | Spain | Extremadura | 3106 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-11 04:34:26 | Extremadura, Spain | ||
2020-07-09 | Spain | Extremadura | 3082 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-10 04:34:24 | Extremadura, Spain | ||
2020-07-08 | Spain | Extremadura | 3076 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-09 04:34:23 | Extremadura, Spain | ||
2020-07-07 | Spain | Extremadura | 3066 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-08 05:33:48 | Extremadura, Spain | ||
2020-07-06 | Spain | Extremadura | 3064 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-07 04:34:00 | Extremadura, Spain | ||
2020-07-05 | Spain | Extremadura | 3047 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-06 04:33:57 | Extremadura, Spain | ||
2020-07-04 | Spain | Extremadura | 3047 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-05 04:33:46 | Extremadura, Spain | ||
2020-07-03 | Spain | Extremadura | 3047 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-04 04:33:51 | Extremadura, Spain | ||
2020-07-02 | Spain | Extremadura | 3040 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-03 04:33:54 | Extremadura, Spain | ||
2020-07-01 | Spain | Extremadura | 3033 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-02 04:33:46 | Extremadura, Spain | ||
2020-06-30 | Spain | Extremadura | 3030 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-01 04:33:52 | Extremadura, Spain | ||
2020-06-29 | Spain | Extremadura | 3027 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-30 04:33:48 | Extremadura, Spain | ||
2020-06-28 | Spain | Extremadura | 3026 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-29 04:33:44 | Extremadura, Spain | ||
2020-06-27 | Spain | Extremadura | 3026 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-28 04:34:04 | Extremadura, Spain | ||
2020-06-26 | Spain | Extremadura | 3025 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-27 04:33:35 | Extremadura, Spain | ||
2020-06-25 | Spain | Extremadura | 3019 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-26 04:33:43 | Extremadura, Spain | ||
2020-06-24 | Spain | Extremadura | 3017 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-25 05:26:54 | Extremadura, Spain | ||
2020-06-23 | Spain | Extremadura | 3011 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-24 04:33:28 | Extremadura, Spain | ||
2020-06-22 | Spain | Extremadura | 3010 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-23 04:33:22 | Extremadura, Spain | ||
2020-06-21 | Spain | Extremadura | 3006 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-22 04:33:20 | Extremadura, Spain | ||
2020-06-20 | Spain | Extremadura | 3001 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-21 04:33:19 | Extremadura, Spain | ||
2020-06-19 | Spain | Extremadura | 3000 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-20 04:33:19 | Extremadura, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;