johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where deaths = 217 and province_or_state = "Cantabria" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1920234 | 1920234 | 2020-08-10 | Spain | Cantabria | 2746 | 217 | 2287 | 242 | 43.1828 | -3.9878 | 2020-08-11 04:35:08 | Cantabria, Spain | ||
3923043 | 3923043 | 2020-08-09 | Spain | Cantabria | 2653 | 217 | 2287 | 149 | 43.1828 | -3.9878 | 2020-08-10 04:34:55 | Cantabria, Spain | ||
371211 | 371211 | 2020-08-08 | Spain | Cantabria | 2653 | 217 | 2287 | 149 | 43.1828 | -3.9878 | 2020-08-09 04:34:54 | Cantabria, Spain | ||
458395 | 458395 | 2020-08-07 | Spain | Cantabria | 2653 | 217 | 2287 | 149 | 43.1828 | -3.9878 | 2020-08-08 04:34:53 | Cantabria, Spain | ||
3612080 | 3612080 | 2020-08-06 | Spain | Cantabria | 2623 | 217 | 2287 | 119 | 43.1828 | -3.9878 | 2020-08-07 04:35:11 | Cantabria, Spain | ||
3792910 | 3792910 | 2020-08-05 | Spain | Cantabria | 2604 | 217 | 2287 | 100 | 43.1828 | -3.9878 | 2020-08-06 04:35:02 | Cantabria, Spain | ||
98146 | 98146 | 2020-08-04 | Spain | Cantabria | 2567 | 217 | 2287 | 63 | 43.1828 | -3.9878 | 2020-08-05 04:34:43 | Cantabria, Spain | ||
2740029 | 2740029 | 2020-08-03 | Spain | Cantabria | 2532 | 217 | 2287 | 28 | 43.1828 | -3.9878 | 2020-08-04 04:41:59 | Cantabria, Spain | ||
2807781 | 2807781 | 2020-08-02 | Spain | Cantabria | 2469 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-08-03 04:34:35 | Cantabria, Spain | ||
753349 | 753349 | 2020-08-01 | Spain | Cantabria | 2469 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-08-02 04:34:47 | Cantabria, Spain | ||
3264514 | 3264514 | 2020-07-31 | Spain | Cantabria | 2469 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-08-01 04:36:27 | Cantabria, Spain | ||
1928221 | 1928221 | 2020-07-30 | Spain | Cantabria | 2455 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-31 04:35:18 | Cantabria, Spain | ||
2958389 | 2958389 | 2020-07-29 | Spain | Cantabria | 2448 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-30 04:35:05 | Cantabria, Spain | ||
3185005 | 3185005 | 2020-07-28 | Spain | Cantabria | 2447 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-29 04:35:11 | Cantabria, Spain | ||
177057 | 177057 | 2020-07-27 | Spain | Cantabria | 2436 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-28 04:58:43 | Cantabria, Spain | ||
442370 | 442370 | 2020-07-26 | Spain | Cantabria | 2419 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-27 04:35:02 | Cantabria, Spain | ||
1502614 | 1502614 | 2020-07-25 | Spain | Cantabria | 2419 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-26 04:35:00 | Cantabria, Spain | ||
2563584 | 2563584 | 2020-07-24 | Spain | Cantabria | 2419 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-25 04:47:39 | Cantabria, Spain | ||
61812 | 61812 | 2020-07-23 | Spain | Cantabria | 2410 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-24 05:30:40 | Cantabria, Spain | ||
844604 | 844604 | 2020-07-22 | Spain | Cantabria | 2406 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-23 05:15:04 | Cantabria, Spain | ||
1707343 | 1707343 | 2020-07-21 | Spain | Cantabria | 2405 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-22 04:34:42 | Cantabria, Spain | ||
326834 | 326834 | 2020-07-20 | Spain | Cantabria | 2403 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-21 04:38:46 | Cantabria, Spain | ||
121739 | 121739 | 2020-07-19 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-20 05:34:40 | Cantabria, Spain | ||
3205128 | 3205128 | 2020-07-18 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-19 04:34:58 | Cantabria, Spain | ||
2708430 | 2708430 | 2020-07-17 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-18 04:34:45 | Cantabria, Spain |
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]);