johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,298 rows where country_or_region = "Spain" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 20
- Andalusia 448
- Aragon 448
- Asturias 448
- Baleares 448
- C. Valenciana 448
- Canarias 448
- Cantabria 448
- Castilla - La Mancha 448
- Castilla y Leon 448
- Catalonia 448
- Ceuta 448
- Extremadura 448
- Galicia 448
- La Rioja 448
- Madrid 448
- Melilla 448
- Murcia 448
- Navarra 448
- Pais Vasco 448
- Unknown 443
country_or_region 1
- Spain · 9,008 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8631 | 8631 | 2020-10-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, Spain | ||||
12642 | 12642 | 2021-01-26 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-27 05:23:41 | Unknown, Spain | ||||
20673 | 20673 | 2021-05-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
36732 | 36732 | 2021-04-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Spain | ||||
51094 | 51094 | 2021-05-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
55107 | 55107 | 2021-03-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-03-08 05:24:48 | Unknown, Spain | ||||
61812 | 61812 | 2020-07-23 | Spain | Cantabria | 2410 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-24 05:30:40 | Cantabria, Spain | ||
61823 | 61823 | 2020-07-23 | Spain | Ceuta | 164 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-24 05:30:40 | Ceuta, Spain | ||
61869 | 61869 | 2020-07-23 | Spain | Galicia | 9554 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-24 05:30:40 | Galicia, Spain | ||
62016 | 62016 | 2020-07-23 | Spain | Murcia | 1881 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-24 05:30:40 | Murcia, Spain | ||
62065 | 62065 | 2020-07-23 | Spain | Pais Vasco | 14958 | 1563 | 16160 | 0 | 42.9896 | -2.6189 | 2020-07-24 05:30:40 | Pais Vasco, Spain | ||
62186 | 62186 | 2020-07-23 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-24 05:30:40 | Unknown, Spain | ||||
75390 | 75390 | 2020-12-03 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-04 05:27:27 | Unknown, Spain | ||||
79387 | 79387 | 2020-10-14 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-15 04:24:28 | Unknown, Spain | ||||
83397 | 83397 | 2021-05-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
98157 | 98157 | 2020-08-04 | Spain | Ceuta | 166 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-08-05 04:34:43 | Ceuta, Spain | ||
98416 | 98416 | 2020-08-04 | Spain | Pais Vasco | 16750 | 1565 | 16160 | 0 | 42.9896 | -2.6189 | 2020-08-05 04:34:43 | Pais Vasco, Spain | ||
98547 | 98547 | 2020-08-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-05 04:34:43 | Unknown, Spain | ||||
107756 | 107756 | 2021-06-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
121739 | 121739 | 2020-07-19 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-20 05:34:40 | Cantabria, Spain | ||
121750 | 121750 | 2020-07-19 | Spain | Ceuta | 164 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-20 05:34:40 | Ceuta, Spain | ||
121802 | 121802 | 2020-07-19 | Spain | Galicia | 9494 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-20 05:34:40 | Galicia, Spain | ||
121956 | 121956 | 2020-07-19 | Spain | Murcia | 1786 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-20 05:34:40 | Murcia, Spain | ||
122008 | 122008 | 2020-07-19 | Spain | Pais Vasco | 14177 | 1563 | 16160 | 0 | 42.9896 | -2.6189 | 2020-07-20 05:34:40 | Pais Vasco, Spain | ||
122138 | 122138 | 2020-07-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-20 05:34:40 | Unknown, Spain | ||||
123005 | 123005 | 2020-11-18 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-19 05:25:23 | Unknown, Spain | ||||
146270 | 146270 | 2020-08-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-16 04:27:42 | Unknown, Spain | ||||
154284 | 154284 | 2021-01-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-09 05:22:18 | Unknown, Spain | ||||
170346 | 170346 | 2021-04-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-17 04:20:40 | Unknown, Spain | ||||
177057 | 177057 | 2020-07-27 | Spain | Cantabria | 2436 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-28 04:58:43 | Cantabria, Spain | ||
177068 | 177068 | 2020-07-27 | Spain | Ceuta | 164 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-28 04:58:43 | Ceuta, Spain | ||
177120 | 177120 | 2020-07-27 | Spain | Galicia | 9635 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-28 04:58:43 | Galicia, Spain | ||
177274 | 177274 | 2020-07-27 | Spain | Murcia | 2091 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-28 04:58:43 | Murcia, Spain | ||
177326 | 177326 | 2020-07-27 | Spain | Pais Vasco | 15524 | 1566 | 16160 | 0 | 42.9896 | -2.6189 | 2020-07-28 04:58:43 | Pais Vasco, Spain | ||
177456 | 177456 | 2020-07-27 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-28 04:58:43 | Unknown, Spain | ||||
182342 | 182342 | 2021-02-21 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-22 05:24:21 | Unknown, Spain | ||||
190370 | 190370 | 2021-01-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-12 05:22:15 | Unknown, Spain | ||||
194365 | 194365 | 2020-08-31 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, Spain | ||||
202557 | 202557 | 2020-12-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-26 05:22:28 | Unknown, Spain | ||||
206552 | 206552 | 2020-08-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-20 04:27:43 | Unknown, Spain | ||||
210540 | 210540 | 2020-10-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-30 04:24:49 | Unknown, Spain | ||||
217045 | 217045 | 2020-06-08 | Spain | Cantabria | 2323 | 202 | 2287 | 0 | 43.1828 | -3.9878 | 2020-06-09 03:33:03 | Cantabria, Spain | ||
217056 | 217056 | 2020-06-08 | Spain | Ceuta | 163 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-06-09 03:33:03 | Ceuta, Spain | ||
217090 | 217090 | 2020-06-08 | Spain | Extremadura | 2977 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-09 03:33:03 | Extremadura, Spain | ||
217100 | 217100 | 2020-06-08 | Spain | Galicia | 9141 | 609 | 9204 | 0 | 42.5751 | -8.1339 | 2020-06-09 03:33:03 | Galicia, Spain | ||
217218 | 217218 | 2020-06-08 | Spain | Melilla | 122 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-06-09 03:33:03 | Melilla, Spain | ||
217234 | 217234 | 2020-06-08 | Spain | Murcia | 1619 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-09 03:33:03 | Murcia, Spain | ||
217280 | 217280 | 2020-06-08 | Spain | Pais Vasco | 13548 | 1424 | 16160 | 0 | 42.9896 | -2.6189 | 2020-06-09 03:33:03 | Pais Vasco, Spain | ||
217401 | 217401 | 2020-06-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-09 03:33:03 | Unknown, Spain | ||||
237542 | 237542 | 2021-01-18 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-19 05:22:15 | Unknown, Spain | ||||
241557 | 241557 | 2021-04-02 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-03 04:20:44 | Unknown, Spain | ||||
268425 | 268425 | 2020-05-21 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-22 02:36:51 | Unknown, Spain | ||||
272455 | 272455 | 2020-11-10 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-11 05:25:30 | Unknown, Spain | ||||
280485 | 280485 | 2021-02-24 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-25 05:24:57 | Unknown, Spain | ||||
287028 | 287028 | 2020-06-15 | Spain | Cantabria | 2334 | 202 | 2287 | 0 | 43.1828 | -3.9878 | 2020-06-16 04:33:09 | Cantabria, Spain | ||
287039 | 287039 | 2020-06-15 | Spain | Ceuta | 163 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-06-16 04:33:09 | Ceuta, Spain | ||
287078 | 287078 | 2020-06-15 | Spain | Extremadura | 2988 | 508 | 2652 | 0 | 39.4937 | -6.0679 | 2020-06-16 04:33:09 | Extremadura, Spain | ||
287088 | 287088 | 2020-06-15 | Spain | Galicia | 9160 | 609 | 9204 | 0 | 42.5751 | -8.1339 | 2020-06-16 04:33:09 | Galicia, Spain | ||
287222 | 287222 | 2020-06-15 | Spain | Melilla | 124 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-06-16 04:33:09 | Melilla, Spain | ||
287239 | 287239 | 2020-06-15 | Spain | Murcia | 1629 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-06-16 04:33:09 | Murcia, Spain | ||
287288 | 287288 | 2020-06-15 | Spain | Pais Vasco | 13638 | 1424 | 16160 | 0 | 42.9896 | -2.6189 | 2020-06-16 04:33:09 | Pais Vasco, Spain | ||
287420 | 287420 | 2020-06-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-16 04:33:09 | Unknown, Spain | ||||
296317 | 296317 | 2021-07-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
302900 | 302900 | 2020-07-01 | Spain | Cantabria | 2363 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-02 04:33:46 | Cantabria, Spain | ||
302911 | 302911 | 2020-07-01 | Spain | Ceuta | 163 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-02 04:33:46 | Ceuta, Spain | ||
302950 | 302950 | 2020-07-01 | Spain | Extremadura | 3033 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-02 04:33:46 | Extremadura, Spain | ||
302960 | 302960 | 2020-07-01 | Spain | Galicia | 9222 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-02 04:33:46 | Galicia, Spain | ||
303094 | 303094 | 2020-07-01 | Spain | Melilla | 126 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-07-02 04:33:46 | Melilla, Spain | ||
303111 | 303111 | 2020-07-01 | Spain | Murcia | 1690 | 147 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-02 04:33:46 | Murcia, Spain | ||
303160 | 303160 | 2020-07-01 | Spain | Pais Vasco | 13792 | 1560 | 16160 | 0 | 42.9896 | -2.6189 | 2020-07-02 04:33:46 | Pais Vasco, Spain | ||
303292 | 303292 | 2020-07-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-02 04:33:46 | Unknown, Spain | ||||
326834 | 326834 | 2020-07-20 | Spain | Cantabria | 2403 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-21 04:38:46 | Cantabria, Spain | ||
326845 | 326845 | 2020-07-20 | Spain | Ceuta | 164 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-21 04:38:46 | Ceuta, Spain | ||
326897 | 326897 | 2020-07-20 | Spain | Galicia | 9510 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-21 04:38:46 | Galicia, Spain | ||
327051 | 327051 | 2020-07-20 | Spain | Murcia | 1840 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-21 04:38:46 | Murcia, Spain | ||
327103 | 327103 | 2020-07-20 | Spain | Pais Vasco | 14539 | 1563 | 16160 | 0 | 42.9896 | -2.6189 | 2020-07-21 04:38:46 | Pais Vasco, Spain | ||
327233 | 327233 | 2020-07-20 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-21 04:38:46 | Unknown, Spain | ||||
332211 | 332211 | 2021-08-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
340577 | 340577 | 2021-02-03 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-04 05:22:26 | Unknown, Spain | ||||
344573 | 344573 | 2020-09-14 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-15 03:22:50 | Unknown, Spain | ||||
352598 | 352598 | 2021-03-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-03-12 05:26:50 | Unknown, Spain | ||||
367249 | 367249 | 2020-07-16 | Spain | Cantabria | 2380 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-17 04:34:50 | Cantabria, Spain | ||
367260 | 367260 | 2020-07-16 | Spain | Ceuta | 164 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-17 04:34:50 | Ceuta, Spain | ||
367309 | 367309 | 2020-07-16 | Spain | Galicia | 9479 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-17 04:34:50 | Galicia, Spain | ||
367459 | 367459 | 2020-07-16 | Spain | Murcia | 1771 | 148 | 2180 | 0 | 37.9922 | -1.1307 | 2020-07-17 04:34:50 | Murcia, Spain | ||
367508 | 367508 | 2020-07-16 | Spain | Pais Vasco | 14099 | 1563 | 16160 | 0 | 42.9896 | -2.6189 | 2020-07-17 04:34:50 | Pais Vasco, Spain | ||
367640 | 367640 | 2020-07-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 04:34:50 | Unknown, Spain | ||||
371222 | 371222 | 2020-08-08 | Spain | Ceuta | 166 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-08-09 04:34:54 | Ceuta, Spain | ||
371612 | 371612 | 2020-08-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-09 04:34:54 | Unknown, Spain | ||||
376482 | 376482 | 2020-11-06 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-07 05:24:52 | Unknown, Spain | ||||
380495 | 380495 | 2021-04-30 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
388525 | 388525 | 2021-04-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-05 04:20:35 | Unknown, Spain | ||||
392536 | 392536 | 2020-11-27 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-28 05:25:50 | Unknown, Spain | ||||
400569 | 400569 | 2021-06-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
408599 | 408599 | 2021-07-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
415192 | 415192 | 2020-07-05 | Spain | Cantabria | 2364 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-06 04:33:57 | Cantabria, Spain | ||
415203 | 415203 | 2020-07-05 | Spain | Ceuta | 163 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-06 04:33:57 | Ceuta, Spain | ||
415242 | 415242 | 2020-07-05 | Spain | Extremadura | 3047 | 519 | 2652 | 0 | 39.4937 | -6.0679 | 2020-07-06 04:33:57 | Extremadura, Spain | ||
415252 | 415252 | 2020-07-05 | Spain | Galicia | 9251 | 619 | 9204 | 0 | 42.5751 | -8.1339 | 2020-07-06 04:33:57 | Galicia, Spain | ||
415386 | 415386 | 2020-07-05 | Spain | Melilla | 126 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-07-06 04:33:57 | Melilla, 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]);