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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 858
country_or_region 1
- Spain · 19,200 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408599 | 408599 | 2021-07-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
415583 | 415583 | 2020-07-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-06 04:33:57 | Unknown, Spain | ||||
419645 | 419645 | 2022-09-18 | Spain | Unknown | 0 | 0 | 0 | 2022-09-19 04:21:49 | Unknown, Spain | |||||
423657 | 423657 | 2021-10-10 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
427634 | 427634 | 2020-09-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-08 04:28:25 | Unknown, Spain | ||||
431667 | 431667 | 2022-11-03 | Spain | Unknown | 0 | 0 | 0 | 2022-11-04 04:22:11 | Unknown, Spain | |||||
435658 | 435658 | 2021-01-21 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-22 05:22:10 | Unknown, Spain | ||||
442769 | 442769 | 2020-07-26 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-27 04:35:02 | Unknown, Spain | ||||
443661 | 443661 | 2021-10-20 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
447677 | 447677 | 2021-11-17 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
451697 | 451697 | 2022-12-21 | Spain | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Spain | |||||
458796 | 458796 | 2020-08-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-08 04:34:53 | Unknown, Spain | ||||
459686 | 459686 | 2022-02-02 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
463703 | 463703 | 2022-05-02 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
467718 | 467718 | 2021-10-07 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
471714 | 471714 | 2021-02-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-20 05:22:51 | Unknown, Spain | ||||
475750 | 475750 | 2022-06-26 | Spain | Unknown | 0 | 0 | 0 | 2022-06-27 04:21:00 | Unknown, Spain | |||||
479179 | 479179 | 2020-02-25 | Spain | 6 | 0 | 2 | 2020-02-25T21:33:02 | |||||||
479900 | 479900 | 2022-11-08 | Spain | Unknown | 0 | 0 | 0 | 2022-11-09 04:21:22 | Unknown, Spain | |||||
483895 | 483895 | 2021-07-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
487930 | 487930 | 2022-11-25 | Spain | Unknown | 0 | 0 | 0 | 2022-11-26 04:21:11 | Unknown, Spain | |||||
491942 | 491942 | 2021-10-14 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
495958 | 495958 | 2021-11-06 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
499975 | 499975 | 2022-04-02 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
503994 | 503994 | 2022-12-17 | Spain | Unknown | 0 | 0 | 0 | 2022-12-18 04:21:03 | Unknown, Spain | |||||
507989 | 507989 | 2021-08-14 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
512003 | 512003 | 2021-08-19 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
516038 | 516038 | 2022-10-15 | Spain | Unknown | 0 | 0 | 0 | 2022-10-16 04:22:39 | Unknown, Spain | |||||
523160 | 523160 | 2021-06-09 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
530145 | 530145 | 2020-07-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-05 04:33:46 | Unknown, Spain | ||||
531008 | 531008 | 2021-02-22 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-23 05:23:41 | Unknown, Spain | ||||
535042 | 535042 | 2021-10-27 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
539062 | 539062 | 2022-10-26 | Spain | Unknown | 0 | 0 | 0 | 2022-10-27 04:22:01 | Unknown, Spain | |||||
543078 | 543078 | 2022-12-15 | Spain | Unknown | 0 | 0 | 0 | 2022-12-16 04:21:01 | Unknown, Spain | |||||
547051 | 547051 | 2020-09-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-13 04:30:52 | Unknown, Spain | ||||
551080 | 551080 | 2021-12-08 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
555096 | 555096 | 2022-01-16 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
559114 | 559114 | 2022-06-16 | Spain | Unknown | 0 | 0 | 0 | 2022-06-17 04:20:56 | Unknown, Spain | |||||
562528 | 562528 | 2020-03-01 | Spain | 84 | 0 | 2 | 40.0 | -4.0 | 2020-03-01T23:33:03 | |||||
563272 | 563272 | 2021-06-22 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
566729 | 566729 | 2020-02-06 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
567410 | 567410 | 2021-10-29 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
574254 | 574254 | 2020-06-06 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-07 03:53:30 | Unknown, Spain | ||||
575139 | 575139 | 2022-02-25 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
579137 | 579137 | 2021-07-13 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
583129 | 583129 | 2020-08-13 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-14 04:51:19 | Unknown, Spain | ||||
589933 | 589933 | 2021-08-08 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
593966 | 593966 | 2022-07-01 | Spain | Unknown | 0 | 0 | 0 | 2022-07-02 04:21:16 | Unknown, Spain | |||||
597980 | 597980 | 2021-10-19 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
601996 | 601996 | 2021-09-23 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
605991 | 605991 | 2021-04-09 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-10 04:20:59 | Unknown, Spain | ||||
609986 | 609986 | 2020-08-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-30 04:28:22 | Unknown, Spain | ||||
613990 | 613990 | 2021-02-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-09 05:23:30 | Unknown, Spain | ||||
617435 | 617435 | 2020-02-27 | Spain | 15 | 0 | 2 | 2020-02-27T13:23:02 | |||||||
618172 | 618172 | 2022-11-05 | Spain | Unknown | 0 | 0 | 0 | 2022-11-06 04:21:24 | Unknown, Spain | |||||
622186 | 622186 | 2022-05-22 | Spain | Unknown | 0 | 0 | 0 | 2022-05-26 04:20:50 | Unknown, Spain | |||||
626183 | 626183 | 2021-07-10 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
630216 | 630216 | 2022-07-12 | Spain | Unknown | 0 | 0 | 0 | 2022-07-13 04:20:58 | Unknown, Spain | |||||
634230 | 634230 | 2021-10-13 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
638226 | 638226 | 2021-03-31 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-01 04:27:05 | Unknown, Spain | ||||
642243 | 642243 | 2021-09-07 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
646254 | 646254 | 2021-05-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
650271 | 650271 | 2021-08-09 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
654302 | 654302 | 2021-10-22 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
658621 | 658621 | 2022-05-13 | Spain | Unknown | 0 | 0 | 0 | 2022-05-14 04:20:48 | Unknown, Spain | |||||
662597 | 662597 | 2020-08-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-12 04:27:29 | Unknown, Spain | ||||
666576 | 666576 | 2020-09-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-17 04:22:00 | Unknown, Spain | ||||
670607 | 670607 | 2022-07-21 | Spain | Unknown | 0 | 0 | 0 | 2022-07-22 04:21:15 | Unknown, Spain | |||||
674623 | 674623 | 2022-07-30 | Spain | Unknown | 0 | 0 | 0 | 2022-07-31 04:21:02 | Unknown, Spain | |||||
678613 | 678613 | 2020-11-23 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-24 05:27:31 | Unknown, Spain | ||||
682647 | 682647 | 2021-10-24 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
686663 | 686663 | 2021-11-13 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
690683 | 690683 | 2022-12-23 | Spain | Unknown | 0 | 0 | 0 | 2022-12-24 04:21:02 | Unknown, Spain | |||||
694696 | 694696 | 2022-03-17 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
698711 | 698711 | 2021-11-04 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
702707 | 702707 | 2021-03-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-03-17 05:25:07 | Unknown, Spain | ||||
706741 | 706741 | 2021-09-29 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
710760 | 710760 | 2022-11-01 | Spain | Unknown | 0 | 0 | 0 | 2022-11-02 04:22:09 | Unknown, Spain | |||||
714772 | 714772 | 2021-11-12 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
718792 | 718792 | 2022-12-04 | Spain | Unknown | 0 | 0 | 0 | 2022-12-05 04:20:58 | Unknown, Spain | |||||
722804 | 722804 | 2021-11-20 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
726800 | 726800 | 2021-05-22 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
730834 | 730834 | 2021-12-27 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
737743 | 737743 | 2020-06-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-13 03:33:14 | Unknown, Spain | ||||
738602 | 738602 | 2020-12-02 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-03 05:28:22 | Unknown, Spain | ||||
742616 | 742616 | 2021-02-20 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-21 05:24:33 | Unknown, Spain | ||||
746651 | 746651 | 2022-04-23 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
753750 | 753750 | 2020-08-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-02 04:34:47 | Unknown, Spain | ||||
754602 | 754602 | 2020-10-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-29 04:24:49 | Unknown, Spain | ||||
758634 | 758634 | 2021-11-26 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
762613 | 762613 | 2020-10-18 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-19 04:24:16 | Unknown, Spain | ||||
766621 | 766621 | 2020-12-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-30 05:22:34 | Unknown, Spain | ||||
770655 | 770655 | 2021-10-23 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
774649 | 774649 | 2021-01-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-13 05:22:15 | Unknown, Spain | ||||
778666 | 778666 | 2021-07-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
782697 | 782697 | 2021-12-13 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
786676 | 786676 | 2020-10-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, Spain | ||||
790685 | 790685 | 2021-02-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Spain | ||||
794724 | 794724 | 2022-10-24 | Spain | Unknown | 0 | 0 | 0 | 2022-10-25 04:21:53 | Unknown, Spain | |||||
798736 | 798736 | 2021-12-22 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, 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]);