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 combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
latitude 22 ✖
combined_key 21 ✖
- Andalusia, Spain 960
- Aragon, Spain 960
- Asturias, Spain 960
- Baleares, Spain 960
- C. Valenciana, Spain 960
- Canarias, Spain 960
- Cantabria, Spain 960
- Castilla - La Mancha, Spain 960
- Castilla y Leon, Spain 960
- Catalonia, Spain 960
- Ceuta, Spain 960
- Extremadura, Spain 960
- Galicia, Spain 960
- La Rioja, Spain 960
- Madrid, Spain 960
- Melilla, Spain 960
- Murcia, Spain 960
- Navarra, Spain 960
- Pais Vasco, Spain 960
- Unknown, Spain 955
- Spain 53
province_or_state 20
- Andalusia 960
- Aragon 960
- Asturias 960
- Baleares 960
- C. Valenciana 960
- Canarias 960
- Cantabria 960
- Castilla - La Mancha 960
- Castilla y Leon 960
- Catalonia 960
- Ceuta 960
- Extremadura 960
- Galicia 960
- La Rioja 960
- Madrid 960
- Melilla 960
- Murcia 960
- Navarra 960
- Pais Vasco 960
- Unknown 955
country_or_region 1
- Spain · 19,298 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40154 | 40154 | 2020-03-05 | Spain | 259 | 3 | 2 | 40.0 | -4.0 | 2020-03-05T17:43:03 | |||||
62488 | 62488 | 2020-03-07 | Spain | 500 | 10 | 30 | 40.0 | -4.0 | 2020-03-07T17:43:05 | |||||
98826 | 98826 | 2020-03-04 | Spain | 222 | 2 | 2 | 40.0 | -4.0 | 2020-03-04T20:43:02 | |||||
107080 | 107080 | 2020-02-15 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
261043 | 261043 | 2020-03-03 | Spain | 165 | 1 | 2 | 40.0 | -4.0 | 2020-03-03T23:53:03 | |||||
339625 | 339625 | 2020-03-21 | Spain | 25374 | 1375 | 2125 | 40.4637 | -3.7492 | 2020-03-21T13:13:30 | |||||
479179 | 479179 | 2020-02-25 | Spain | 6 | 0 | 2 | 2020-02-25T21:33:02 | |||||||
562528 | 562528 | 2020-03-01 | Spain | 84 | 0 | 2 | 40.0 | -4.0 | 2020-03-01T23:33:03 | |||||
566729 | 566729 | 2020-02-06 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
617435 | 617435 | 2020-02-27 | Spain | 15 | 0 | 2 | 2020-02-27T13:23:02 | |||||||
657692 | 657692 | 2020-03-09 | Spain | 1073 | 28 | 32 | 40.0 | -4.0 | 2020-03-09T18:13:11 | |||||
1085683 | 1085683 | 2020-02-22 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1152663 | 1152663 | 2020-03-02 | Spain | 120 | 0 | 2 | 40.0 | -4.0 | 2020-03-02T14:43:05 | |||||
1176878 | 1176878 | 2020-03-18 | Spain | 13910 | 623 | 1081 | 40.4637 | -3.7492 | 2020-03-18T13:13:13 | |||||
1192499 | 1192499 | 2020-02-14 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
1243401 | 1243401 | 2020-02-17 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1366102 | 1366102 | 2020-02-08 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
1463465 | 1463465 | 2020-03-15 | Spain | 7798 | 289 | 517 | 40.4637 | -3.7492 | 2020-03-15T18:20:18 | |||||
1526874 | 1526874 | 2020-03-19 | Spain | 17963 | 830 | 1107 | 40.4637 | -3.7492 | 2020-03-19T20:13:08 | |||||
1527213 | 1527213 | 2020-03-08 | Spain | 673 | 17 | 30 | 40.0 | -4.0 | 2020-03-08T20:33:02 | |||||
1559706 | 1559706 | 2020-02-13 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
1720096 | 1720096 | 2020-02-19 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1783127 | 1783127 | 2020-02-18 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1888754 | 1888754 | 2020-02-16 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
2091722 | 2091722 | 2020-02-05 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
2111090 | 2111090 | 2020-03-14 | Spain | 6391 | 195 | 517 | 40.4637 | -3.7492 | 2020-03-14T22:13:11 | |||||
2127435 | 2127435 | 2020-03-11 | Spain | 2277 | 54 | 183 | 40.0 | -4.0 | 2020-03-11T20:53:02 | |||||
2135765 | 2135765 | 2020-02-21 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
2255115 | 2255115 | 2020-03-16 | Spain | 9942 | 342 | 530 | 40.4637 | -3.7492 | 2020-03-16T20:13:11 | |||||
2263504 | 2263504 | 2020-02-20 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
2282865 | 2282865 | 2020-03-12 | Spain | 2277 | 55 | 183 | 40.0 | -4.0 | 2020-03-12T01:17:58 | |||||
2379285 | 2379285 | 2020-02-02 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
2509791 | 2509791 | 2020-02-26 | Spain | 13 | 0 | 2 | 2020-02-26T20:43:02 | |||||||
2567296 | 2567296 | 2020-02-12 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
2860601 | 2860601 | 2020-02-03 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
2883948 | 2883948 | 2020-02-28 | Spain | 32 | 0 | 2 | 2020-02-28T15:33:03 | |||||||
3089054 | 3089054 | 2020-02-10 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
3173394 | 3173394 | 2020-02-23 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
3177495 | 3177495 | 2020-03-06 | Spain | 400 | 5 | 2 | 40.0 | -4.0 | 2020-03-06T20:13:13 | |||||
3197755 | 3197755 | 2020-02-11 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
3205821 | 3205821 | 2020-02-29 | Spain | 45 | 0 | 2 | 2020-02-29T19:13:08 | |||||||
3222061 | 3222061 | 2020-02-07 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
3362423 | 3362423 | 2020-02-09 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
3413197 | 3413197 | 2020-02-01 | Spain | 1 | 0 | 0 | 2/1/2020 2:13 | |||||||
3471939 | 3471939 | 2020-02-04 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
3551250 | 3551250 | 2020-02-24 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
3733922 | 3733922 | 2020-03-20 | Spain | 20410 | 1043 | 1588 | 40.4637 | -3.7492 | 2020-03-20T17:43:03 | |||||
3752819 | 3752819 | 2020-03-10 | Spain | 1695 | 35 | 32 | 40.0 | -4.0 | 2020-03-10T23:53:02 | |||||
3765434 | 3765434 | 2020-03-13 | Spain | 5232 | 133 | 193 | 40.4637 | -3.7492 | 2020-03-11T20:00:00 | |||||
3891309 | 3891309 | 2020-03-17 | Spain | 11748 | 533 | 1028 | 40.4637 | -3.7492 | 2020-03-17T20:53:02 | |||||
617 | 617 | 2021-12-02 | Spain | Andalusia | 824982 | 11347 | 0 | 37.5443 | -4.7278 | 2021-12-03 04:23:05 | Andalusia, Spain | |||
4633 | 4633 | 2021-10-28 | Spain | Andalusia | 807896 | 11267 | 0 | 37.5443 | -4.7278 | 2021-10-29 04:22:03 | Andalusia, Spain | |||
8612 | 8612 | 2020-10-25 | Spain | Andalusia | 106298 | 2270 | 10671 | 93357 | 37.5443 | -4.7278 | 2020-10-26 04:25:02 | Andalusia, Spain | ||
12623 | 12623 | 2021-01-26 | Spain | Andalusia | 373028 | 6007 | 10671 | 356350 | 37.5443 | -4.7278 | 2021-01-27 05:23:41 | Andalusia, Spain | ||
16641 | 16641 | 2021-09-18 | Spain | Andalusia | 797042 | 11028 | 0 | 37.5443 | -4.7278 | 2021-09-19 04:21:34 | Andalusia, Spain | |||
20654 | 20654 | 2021-05-28 | Spain | Andalusia | 581880 | 9880 | 10671 | 561329 | 37.5443 | -4.7278 | 2021-05-29 04:20:41 | Andalusia, Spain | ||
24688 | 24688 | 2022-03-20 | Spain | Andalusia | 1376249 | 13067 | 0 | 37.5443 | -4.7278 | 2022-03-21 04:20:50 | Andalusia, Spain | |||
28703 | 28703 | 2021-11-11 | Spain | Andalusia | 811665 | 11300 | 0 | 37.5443 | -4.7278 | 2021-11-12 04:22:01 | Andalusia, Spain | |||
32702 | 32702 | 2021-08-25 | Spain | Andalusia | 779057 | 10616 | 0 | 37.5443 | -4.7278 | 2021-08-26 04:21:28 | Andalusia, Spain | |||
36713 | 36713 | 2021-04-12 | Spain | Andalusia | 523865 | 9362 | 10671 | 503832 | 37.5443 | -4.7278 | 2021-04-13 04:20:37 | Andalusia, Spain | ||
43995 | 43995 | 2021-11-02 | Spain | Andalusia | 808943 | 11271 | 0 | 37.5443 | -4.7278 | 2021-11-03 06:22:09 | Andalusia, Spain | |||
51075 | 51075 | 2021-05-29 | Spain | Andalusia | 581880 | 9880 | 10671 | 561329 | 37.5443 | -4.7278 | 2021-05-30 04:20:55 | Andalusia, Spain | ||
55088 | 55088 | 2021-03-07 | Spain | Andalusia | 482590 | 8566 | 10671 | 463353 | 37.5443 | -4.7278 | 2021-03-08 05:24:48 | Andalusia, Spain | ||
61756 | 61756 | 2020-07-23 | Spain | Andalusia | 14214 | 1435 | 10671 | 2108 | 37.5443 | -4.7278 | 2020-07-24 05:30:40 | Andalusia, Spain | ||
63352 | 63352 | 2022-11-12 | Spain | Andalusia | 1603271 | 14780 | 0 | 37.5443 | -4.7278 | 2022-11-13 04:21:14 | Andalusia, Spain | |||
67347 | 67347 | 2021-09-01 | Spain | Andalusia | 786357 | 10810 | 0 | 37.5443 | -4.7278 | 2021-09-02 04:21:15 | Andalusia, Spain | |||
71378 | 71378 | 2022-02-07 | Spain | Andalusia | 1275373 | 12199 | 0 | 37.5443 | -4.7278 | 2022-02-08 04:21:15 | Andalusia, Spain | |||
75371 | 75371 | 2020-12-03 | Spain | Andalusia | 237397 | 4251 | 10671 | 222475 | 37.5443 | -4.7278 | 2020-12-04 05:27:27 | Andalusia, Spain | ||
79368 | 79368 | 2020-10-14 | Spain | Andalusia | 81773 | 2053 | 10671 | 69049 | 37.5443 | -4.7278 | 2020-10-15 04:24:28 | Andalusia, Spain | ||
83378 | 83378 | 2021-05-25 | Spain | Andalusia | 577638 | 9867 | 10671 | 557100 | 37.5443 | -4.7278 | 2021-05-26 04:20:35 | Andalusia, Spain | ||
87412 | 87412 | 2021-11-09 | Spain | Andalusia | 810542 | 11287 | 0 | 37.5443 | -4.7278 | 2021-11-10 04:21:38 | Andalusia, Spain | |||
91430 | 91430 | 2022-07-23 | Spain | Andalusia | 1560568 | 14090 | 0 | 37.5443 | -4.7278 | 2022-07-24 04:20:47 | Andalusia, Spain | |||
98087 | 98087 | 2020-08-04 | Spain | Andalusia | 15839 | 1437 | 10671 | 3731 | 37.5443 | -4.7278 | 2020-08-05 04:34:43 | Andalusia, Spain | ||
99613 | 99613 | 2022-01-14 | Spain | Andalusia | 1109652 | 11641 | 0 | 37.5443 | -4.7278 | 2022-01-15 04:21:07 | Andalusia, Spain | |||
103612 | 103612 | 2021-08-15 | Spain | Andalusia | 756270 | 10396 | 0 | 37.5443 | -4.7278 | 2021-08-16 04:21:31 | Andalusia, Spain | |||
107737 | 107737 | 2021-06-19 | Spain | Andalusia | 606879 | 10009 | 10671 | 586199 | 37.5443 | -4.7278 | 2021-06-20 04:21:48 | Andalusia, Spain | ||
115040 | 115040 | 2022-09-06 | Spain | Andalusia | 1579031 | 14393 | 0 | 37.5443 | -4.7278 | 2022-09-07 04:20:59 | Andalusia, Spain | |||
121680 | 121680 | 2020-07-19 | Spain | Andalusia | 13731 | 1435 | 10671 | 1625 | 37.5443 | -4.7278 | 2020-07-20 05:34:40 | Andalusia, Spain | ||
122986 | 122986 | 2020-11-18 | Spain | Andalusia | 205359 | 3424 | 10671 | 191264 | 37.5443 | -4.7278 | 2020-11-19 05:25:23 | Andalusia, Spain | ||
127020 | 127020 | 2022-01-09 | Spain | Andalusia | 1041565 | 11537 | 0 | 37.5443 | -4.7278 | 2022-01-10 04:22:07 | Andalusia, Spain | |||
131040 | 131040 | 2022-10-04 | Spain | Andalusia | 1589947 | 14572 | 0 | 37.5443 | -4.7278 | 2022-10-05 04:23:06 | Andalusia, Spain | |||
138258 | 138258 | 2021-12-04 | Spain | Andalusia | 826194 | 11350 | 0 | 37.5443 | -4.7278 | 2021-12-05 04:22:25 | Andalusia, Spain | |||
142276 | 142276 | 2022-07-09 | Spain | Andalusia | 1545050 | 13945 | 0 | 37.5443 | -4.7278 | 2022-07-10 04:20:54 | Andalusia, Spain | |||
146251 | 146251 | 2020-08-15 | Spain | Andalusia | 18937 | 1445 | 10671 | 6821 | 37.5443 | -4.7278 | 2020-08-16 04:27:42 | Andalusia, Spain | ||
150271 | 150271 | 2021-11-29 | Spain | Andalusia | 821926 | 11337 | 0 | 37.5443 | -4.7278 | 2021-11-30 04:22:53 | Andalusia, Spain | |||
154265 | 154265 | 2021-01-08 | Spain | Andalusia | 276669 | 5251 | 10671 | 260747 | 37.5443 | -4.7278 | 2021-01-09 05:22:18 | Andalusia, Spain | ||
158300 | 158300 | 2022-03-29 | Spain | Andalusia | 1399804 | 13171 | 0 | 37.5443 | -4.7278 | 2022-03-30 04:20:45 | Andalusia, Spain | |||
162315 | 162315 | 2021-11-19 | Spain | Andalusia | 815420 | 11317 | 0 | 37.5443 | -4.7278 | 2021-11-20 04:22:17 | Andalusia, Spain | |||
166333 | 166333 | 2022-06-21 | Spain | Andalusia | 1518723 | 13839 | 0 | 37.5443 | -4.7278 | 2022-06-22 04:20:54 | Andalusia, Spain | |||
170327 | 170327 | 2021-04-16 | Spain | Andalusia | 530392 | 9415 | 10671 | 510306 | 37.5443 | -4.7278 | 2021-04-17 04:20:40 | Andalusia, Spain | ||
176998 | 176998 | 2020-07-27 | Spain | Andalusia | 14607 | 1436 | 10671 | 2500 | 37.5443 | -4.7278 | 2020-07-28 04:58:43 | Andalusia, Spain | ||
178312 | 178312 | 2021-09-02 | Spain | Andalusia | 787610 | 10836 | 0 | 37.5443 | -4.7278 | 2021-09-03 04:21:20 | Andalusia, Spain | |||
182323 | 182323 | 2021-02-21 | Spain | Andalusia | 468648 | 7946 | 10671 | 450031 | 37.5443 | -4.7278 | 2021-02-22 05:24:21 | Andalusia, Spain | ||
186358 | 186358 | 2022-02-13 | Spain | Andalusia | 1294854 | 12360 | 0 | 37.5443 | -4.7278 | 2022-02-14 04:20:51 | Andalusia, Spain | |||
190351 | 190351 | 2021-01-11 | Spain | Andalusia | 286415 | 5329 | 10671 | 270415 | 37.5443 | -4.7278 | 2021-01-12 05:22:15 | Andalusia, Spain | ||
194346 | 194346 | 2020-08-31 | Spain | Andalusia | 29808 | 1493 | 10671 | 17644 | 37.5443 | -4.7278 | 2020-09-01 04:28:31 | Andalusia, Spain | ||
198549 | 198549 | 2022-10-19 | Spain | Andalusia | 1593061 | 14611 | 0 | 37.5443 | -4.7278 | 2022-10-20 04:22:59 | Andalusia, Spain | |||
202538 | 202538 | 2020-12-25 | Spain | Andalusia | 257755 | 4950 | 10671 | 242134 | 37.5443 | -4.7278 | 2020-12-26 05:22:28 | Andalusia, Spain | ||
206533 | 206533 | 2020-08-19 | Spain | Andalusia | 21508 | 1456 | 10671 | 9381 | 37.5443 | -4.7278 | 2020-08-20 04:27:43 | Andalusia, Spain | ||
210521 | 210521 | 2020-10-29 | Spain | Andalusia | 125003 | 2432 | 10671 | 111900 | 37.5443 | -4.7278 | 2020-10-30 04:24:49 | Andalusia, 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]);