johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain" and province_or_state = "Catalonia" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
province_or_state 1
- Catalonia · 960 ✖
country_or_region 1
- Spain · 960 ✖
combined_key 1 ✖
- Catalonia, Spain 960
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2455059 | 2455059 | 2020-09-19 | Spain | Catalonia | 128901 | 5797 | 26203 | 96901 | 41.5912 | 1.5209 | 2020-09-20 04:22:00 | Catalonia, Spain | ||
2849128 | 2849128 | 2020-09-18 | Spain | Catalonia | 128901 | 5797 | 26203 | 96901 | 41.5912 | 1.5209 | 2020-09-19 04:22:00 | Catalonia, Spain | ||
3093709 | 3093709 | 2020-09-20 | Spain | Catalonia | 128901 | 5797 | 26203 | 96901 | 41.5912 | 1.5209 | 2020-09-21 04:23:00 | Catalonia, Spain | ||
1121877 | 1121877 | 2020-09-17 | Spain | Catalonia | 127544 | 5796 | 26203 | 95545 | 41.5912 | 1.5209 | 2020-09-18 05:05:00 | Catalonia, Spain | ||
666566 | 666566 | 2020-09-16 | Spain | Catalonia | 126234 | 5787 | 26203 | 94244 | 41.5912 | 1.5209 | 2020-09-17 04:22:00 | Catalonia, Spain | ||
344563 | 344563 | 2020-09-14 | Spain | Catalonia | 123393 | 5780 | 26203 | 91410 | 41.5912 | 1.5209 | 2020-09-15 03:22:50 | Catalonia, Spain | ||
2729291 | 2729291 | 2020-09-15 | Spain | Catalonia | 123393 | 5780 | 26203 | 91410 | 41.5912 | 1.5209 | 2020-09-16 04:22:53 | Catalonia, Spain | ||
547041 | 547041 | 2020-09-12 | Spain | Catalonia | 122320 | 5780 | 26203 | 90337 | 41.5912 | 1.5209 | 2020-09-13 04:30:52 | Catalonia, Spain | ||
1444870 | 1444870 | 2020-09-11 | Spain | Catalonia | 122320 | 5780 | 26203 | 90337 | 41.5912 | 1.5209 | 2020-09-12 04:25:05 | Catalonia, Spain | ||
2869002 | 2869002 | 2020-09-13 | Spain | Catalonia | 122320 | 5780 | 26203 | 90337 | 41.5912 | 1.5209 | 2020-09-14 04:26:00 | Catalonia, Spain | ||
1173471 | 1173471 | 2020-09-10 | Spain | Catalonia | 121054 | 5773 | 26203 | 89078 | 41.5912 | 1.5209 | 2020-09-11 04:46:23 | Catalonia, Spain | ||
2171836 | 2171836 | 2020-09-09 | Spain | Catalonia | 119839 | 5773 | 26203 | 87863 | 41.5912 | 1.5209 | 2020-09-10 04:29:01 | Catalonia, Spain | ||
1244045 | 1244045 | 2020-09-08 | Spain | Catalonia | 118974 | 5770 | 26203 | 87001 | 41.5912 | 1.5209 | 2020-09-09 04:28:48 | Catalonia, Spain | ||
427624 | 427624 | 2020-09-07 | Spain | Catalonia | 118233 | 5769 | 26203 | 86261 | 41.5912 | 1.5209 | 2020-09-08 04:28:25 | Catalonia, Spain | ||
813864 | 813864 | 2020-09-05 | Spain | Catalonia | 114987 | 5761 | 26203 | 83023 | 41.5912 | 1.5209 | 2020-09-06 04:28:33 | Catalonia, Spain | ||
2662064 | 2662064 | 2020-09-04 | Spain | Catalonia | 114987 | 5761 | 26203 | 83023 | 41.5912 | 1.5209 | 2020-09-05 04:28:19 | Catalonia, Spain | ||
3161909 | 3161909 | 2020-09-06 | Spain | Catalonia | 114987 | 5761 | 26203 | 83023 | 41.5912 | 1.5209 | 2020-09-07 04:28:30 | Catalonia, Spain | ||
1354604 | 1354604 | 2020-09-03 | Spain | Catalonia | 113569 | 5758 | 26203 | 81608 | 41.5912 | 1.5209 | 2020-09-04 04:28:26 | Catalonia, Spain | ||
332201 | 332201 | 2021-08-04 | Spain | Catalonia | 846752 | 14883 | 26203 | 805666 | 41.5912 | 1.5209 | 2021-08-05 04:21:51 | Catalonia, Spain | ||
1105841 | 1105841 | 2020-09-02 | Spain | Catalonia | 112230 | 5757 | 26203 | 80270 | 41.5912 | 1.5209 | 2020-09-03 04:28:22 | Catalonia, Spain | ||
3468472 | 3468472 | 2021-08-03 | Spain | Catalonia | 843391 | 14872 | 26203 | 802316 | 41.5912 | 1.5209 | 2021-08-04 04:21:25 | Catalonia, Spain | ||
3683746 | 3683746 | 2021-08-02 | Spain | Catalonia | 840025 | 14843 | 26203 | 798979 | 41.5912 | 1.5209 | 2021-08-03 04:21:39 | Catalonia, Spain | ||
3015645 | 3015645 | 2021-08-01 | Spain | Catalonia | 830538 | 14813 | 26203 | 789522 | 41.5912 | 1.5209 | 2021-08-02 04:21:36 | Catalonia, Spain | ||
3296473 | 3296473 | 2021-07-30 | Spain | Catalonia | 830538 | 14813 | 26203 | 789522 | 41.5912 | 1.5209 | 2021-07-31 04:21:35 | Catalonia, Spain | ||
3904268 | 3904268 | 2021-07-31 | Spain | Catalonia | 830538 | 14813 | 26203 | 789522 | 41.5912 | 1.5209 | 2021-08-01 04:21:50 | Catalonia, Spain | ||
2060170 | 2060170 | 2020-09-01 | Spain | Catalonia | 110667 | 5749 | 26203 | 78715 | 41.5912 | 1.5209 | 2020-09-02 04:28:25 | Catalonia, Spain | ||
3385684 | 3385684 | 2021-07-29 | Spain | Catalonia | 826896 | 14802 | 26203 | 785891 | 41.5912 | 1.5209 | 2021-07-30 04:21:34 | Catalonia, Spain | ||
408589 | 408589 | 2021-07-28 | Spain | Catalonia | 822712 | 14798 | 26203 | 781711 | 41.5912 | 1.5209 | 2021-07-29 04:21:33 | Catalonia, Spain | ||
194355 | 194355 | 2020-08-31 | Spain | Catalonia | 110017 | 5741 | 26203 | 78073 | 41.5912 | 1.5209 | 2020-09-01 04:28:31 | Catalonia, Spain | ||
1306450 | 1306450 | 2021-07-27 | Spain | Catalonia | 817730 | 14787 | 26203 | 776740 | 41.5912 | 1.5209 | 2021-07-28 04:21:39 | Catalonia, Spain | ||
3218593 | 3218593 | 2021-07-26 | Spain | Catalonia | 812128 | 14785 | 26203 | 771140 | 41.5912 | 1.5209 | 2021-07-27 04:21:18 | Catalonia, Spain | ||
1330542 | 1330542 | 2021-07-24 | Spain | Catalonia | 798594 | 14778 | 26203 | 757613 | 41.5912 | 1.5209 | 2021-07-25 04:22:12 | Catalonia, Spain | ||
1378802 | 1378802 | 2021-07-25 | Spain | Catalonia | 798594 | 14778 | 26203 | 757613 | 41.5912 | 1.5209 | 2021-07-26 04:21:28 | Catalonia, Spain | ||
3137846 | 3137846 | 2021-07-23 | Spain | Catalonia | 798594 | 14778 | 26203 | 757613 | 41.5912 | 1.5209 | 2021-07-24 00:21:36 | Catalonia, Spain | ||
3476606 | 3476606 | 2021-07-22 | Spain | Catalonia | 792669 | 14773 | 26203 | 751693 | 41.5912 | 1.5209 | 2021-07-23 04:21:29 | Catalonia, Spain | ||
609976 | 609976 | 2020-08-29 | Spain | Catalonia | 106811 | 5741 | 26203 | 74867 | 41.5912 | 1.5209 | 2020-08-30 04:28:22 | Catalonia, Spain | ||
1523471 | 1523471 | 2020-08-28 | Spain | Catalonia | 106811 | 5741 | 26203 | 74867 | 41.5912 | 1.5209 | 2020-08-29 04:28:19 | Catalonia, Spain | ||
3932314 | 3932314 | 2020-08-30 | Spain | Catalonia | 106811 | 5741 | 26203 | 74867 | 41.5912 | 1.5209 | 2020-08-31 04:28:27 | Catalonia, Spain | ||
3331825 | 3331825 | 2021-07-21 | Spain | Catalonia | 785624 | 14769 | 26203 | 744652 | 41.5912 | 1.5209 | 2021-07-22 04:21:19 | Catalonia, Spain | ||
2371806 | 2371806 | 2021-07-20 | Spain | Catalonia | 777439 | 14767 | 26203 | 736469 | 41.5912 | 1.5209 | 2021-07-21 04:21:40 | Catalonia, Spain | ||
2510472 | 2510472 | 2020-08-27 | Spain | Catalonia | 105429 | 5741 | 26203 | 73485 | 41.5912 | 1.5209 | 2020-08-28 04:28:11 | Catalonia, Spain | ||
483885 | 483885 | 2021-07-19 | Spain | Catalonia | 769996 | 14764 | 26203 | 729029 | 41.5912 | 1.5209 | 2021-07-20 04:21:48 | Catalonia, Spain | ||
1996932 | 1996932 | 2020-08-26 | Spain | Catalonia | 104084 | 5740 | 26203 | 72141 | 41.5912 | 1.5209 | 2020-08-27 04:28:15 | Catalonia, Spain | ||
2674108 | 2674108 | 2021-07-18 | Spain | Catalonia | 752417 | 14762 | 26203 | 711452 | 41.5912 | 1.5209 | 2021-07-19 04:21:24 | Catalonia, Spain | ||
2947651 | 2947651 | 2021-07-16 | Spain | Catalonia | 752417 | 14762 | 26203 | 711452 | 41.5912 | 1.5209 | 2021-07-17 04:22:22 | Catalonia, Spain | ||
3706420 | 3706420 | 2021-07-17 | Spain | Catalonia | 752417 | 14762 | 26203 | 711452 | 41.5912 | 1.5209 | 2021-07-18 04:22:07 | Catalonia, Spain | ||
3562856 | 3562856 | 2020-08-25 | Spain | Catalonia | 102817 | 5727 | 26203 | 70887 | 41.5912 | 1.5209 | 2020-08-26 04:28:11 | Catalonia, Spain | ||
296307 | 296307 | 2021-07-15 | Spain | Catalonia | 742782 | 14761 | 26203 | 701818 | 41.5912 | 1.5209 | 2021-07-16 04:21:22 | Catalonia, Spain | ||
2991560 | 2991560 | 2020-08-24 | Spain | Catalonia | 102032 | 5725 | 26203 | 70104 | 41.5912 | 1.5209 | 2020-08-25 04:28:02 | Catalonia, Spain | ||
3632252 | 3632252 | 2021-07-14 | Spain | Catalonia | 734229 | 14758 | 26203 | 693268 | 41.5912 | 1.5209 | 2021-07-15 04:21:48 | Catalonia, Spain | ||
579127 | 579127 | 2021-07-13 | Spain | Catalonia | 725462 | 14757 | 26203 | 684502 | 41.5912 | 1.5209 | 2021-07-14 04:21:35 | Catalonia, Spain | ||
1479844 | 1479844 | 2020-08-21 | Spain | Catalonia | 98462 | 5724 | 26203 | 66535 | 41.5912 | 1.5209 | 2020-08-22 04:27:49 | Catalonia, Spain | ||
2215955 | 2215955 | 2020-08-23 | Spain | Catalonia | 98462 | 5724 | 26203 | 66535 | 41.5912 | 1.5209 | 2020-08-24 04:27:56 | Catalonia, Spain | ||
2299737 | 2299737 | 2020-08-22 | Spain | Catalonia | 98462 | 5724 | 26203 | 66535 | 41.5912 | 1.5209 | 2020-08-23 04:27:48 | Catalonia, Spain | ||
626173 | 626173 | 2021-07-10 | Spain | Catalonia | 696621 | 14756 | 26203 | 655662 | 41.5912 | 1.5209 | 2021-07-11 04:21:43 | Catalonia, Spain | ||
829892 | 829892 | 2021-07-09 | Spain | Catalonia | 696621 | 14756 | 26203 | 655662 | 41.5912 | 1.5209 | 2021-07-10 04:21:25 | Catalonia, Spain | ||
3659889 | 3659889 | 2021-07-11 | Spain | Catalonia | 696621 | 14756 | 26203 | 655662 | 41.5912 | 1.5209 | 2021-07-12 04:21:34 | Catalonia, Spain | ||
3741376 | 3741376 | 2021-07-12 | Spain | Catalonia | 696621 | 14756 | 26203 | 655662 | 41.5912 | 1.5209 | 2021-07-13 04:21:18 | Catalonia, Spain | ||
3484593 | 3484593 | 2020-08-20 | Spain | Catalonia | 97234 | 5722 | 26203 | 65309 | 41.5912 | 1.5209 | 2020-08-21 04:27:41 | Catalonia, Spain | ||
778656 | 778656 | 2021-07-08 | Spain | Catalonia | 686599 | 14755 | 26203 | 645641 | 41.5912 | 1.5209 | 2021-07-09 04:21:21 | Catalonia, Spain | ||
206542 | 206542 | 2020-08-19 | Spain | Catalonia | 96139 | 5718 | 26203 | 64218 | 41.5912 | 1.5209 | 2020-08-20 04:27:43 | Catalonia, Spain | ||
1440878 | 1440878 | 2021-07-07 | Spain | Catalonia | 681811 | 14743 | 26203 | 640865 | 41.5912 | 1.5209 | 2021-07-08 04:21:26 | Catalonia, Spain | ||
2693983 | 2693983 | 2021-07-06 | Spain | Catalonia | 675671 | 14743 | 26203 | 634725 | 41.5912 | 1.5209 | 2021-07-07 04:21:20 | Catalonia, Spain | ||
3178296 | 3178296 | 2020-08-18 | Spain | Catalonia | 95123 | 5712 | 26203 | 63208 | 41.5912 | 1.5209 | 2020-08-19 04:27:00 | Catalonia, Spain | ||
1932732 | 1932732 | 2021-07-05 | Spain | Catalonia | 670410 | 14741 | 26203 | 629466 | 41.5912 | 1.5209 | 2021-07-06 04:21:32 | Catalonia, Spain | ||
837900 | 837900 | 2020-08-17 | Spain | Catalonia | 94702 | 5710 | 26203 | 62789 | 41.5912 | 1.5209 | 2020-08-18 04:27:56 | Catalonia, Spain | ||
1165463 | 1165463 | 2021-07-04 | Spain | Catalonia | 658025 | 14739 | 26203 | 617083 | 41.5912 | 1.5209 | 2021-07-05 04:21:28 | Catalonia, Spain | ||
1495897 | 1495897 | 2021-07-03 | Spain | Catalonia | 658025 | 14739 | 26203 | 617083 | 41.5912 | 1.5209 | 2021-07-04 04:21:38 | Catalonia, Spain | ||
2072212 | 2072212 | 2021-07-02 | Spain | Catalonia | 658025 | 14739 | 26203 | 617083 | 41.5912 | 1.5209 | 2021-07-03 04:21:37 | Catalonia, Spain | ||
2765228 | 2765228 | 2021-07-01 | Spain | Catalonia | 652898 | 14737 | 26203 | 611958 | 41.5912 | 1.5209 | 2021-07-02 04:21:47 | Catalonia, Spain | ||
1893436 | 1893436 | 2021-06-30 | Spain | Catalonia | 647694 | 14736 | 26203 | 606755 | 41.5912 | 1.5209 | 2021-07-01 04:21:19 | Catalonia, Spain | ||
400559 | 400559 | 2021-06-29 | Spain | Catalonia | 644151 | 14736 | 26203 | 603212 | 41.5912 | 1.5209 | 2021-06-30 04:21:41 | Catalonia, Spain | ||
146260 | 146260 | 2020-08-15 | Spain | Catalonia | 91982 | 5709 | 26203 | 60070 | 41.5912 | 1.5209 | 2020-08-16 04:27:42 | Catalonia, Spain | ||
1556258 | 1556258 | 2020-08-16 | Spain | Catalonia | 91982 | 5709 | 26203 | 60070 | 41.5912 | 1.5209 | 2020-08-17 04:27:20 | Catalonia, Spain | ||
1612535 | 1612535 | 2020-08-14 | Spain | Catalonia | 91982 | 5709 | 26203 | 60070 | 41.5912 | 1.5209 | 2020-08-15 04:27:31 | Catalonia, Spain | ||
3125802 | 3125802 | 2021-06-28 | Spain | Catalonia | 641306 | 14733 | 26203 | 600370 | 41.5912 | 1.5209 | 2021-06-29 04:21:28 | Catalonia, Spain | ||
1712620 | 1712620 | 2021-06-25 | Spain | Catalonia | 639380 | 14731 | 26203 | 598446 | 41.5912 | 1.5209 | 2021-06-26 04:21:43 | Catalonia, Spain | ||
2590297 | 2590297 | 2021-06-27 | Spain | Catalonia | 639380 | 14731 | 26203 | 598446 | 41.5912 | 1.5209 | 2021-06-28 04:21:29 | Catalonia, Spain | ||
3958801 | 3958801 | 2021-06-26 | Spain | Catalonia | 639380 | 14731 | 26203 | 598446 | 41.5912 | 1.5209 | 2021-06-27 04:21:39 | Catalonia, Spain | ||
2295745 | 2295745 | 2021-06-24 | Spain | Catalonia | 638516 | 14731 | 26203 | 597582 | 41.5912 | 1.5209 | 2021-06-25 04:21:33 | Catalonia, Spain | ||
2423185 | 2423185 | 2021-06-23 | Spain | Catalonia | 637252 | 14729 | 26203 | 596320 | 41.5912 | 1.5209 | 2021-06-24 04:21:55 | Catalonia, Spain | ||
563262 | 563262 | 2021-06-22 | Spain | Catalonia | 636053 | 14728 | 26203 | 595122 | 41.5912 | 1.5209 | 2021-06-23 04:21:46 | Catalonia, Spain | ||
3358964 | 3358964 | 2021-06-21 | Spain | Catalonia | 634903 | 14714 | 26203 | 593986 | 41.5912 | 1.5209 | 2021-06-22 04:21:34 | Catalonia, Spain | ||
107746 | 107746 | 2021-06-19 | Spain | Catalonia | 634247 | 14714 | 26203 | 593330 | 41.5912 | 1.5209 | 2021-06-20 04:21:48 | Catalonia, Spain | ||
1125889 | 1125889 | 2021-06-18 | Spain | Catalonia | 634247 | 14714 | 26203 | 593330 | 41.5912 | 1.5209 | 2021-06-19 04:22:33 | Catalonia, Spain | ||
2884663 | 2884663 | 2021-06-20 | Spain | Catalonia | 634247 | 14714 | 26203 | 593330 | 41.5912 | 1.5209 | 2021-06-21 04:21:41 | Catalonia, Spain | ||
2911467 | 2911467 | 2021-06-17 | Spain | Catalonia | 633391 | 14713 | 26203 | 592475 | 41.5912 | 1.5209 | 2021-06-18 04:22:16 | Catalonia, Spain | ||
3030583 | 3030583 | 2021-06-16 | Spain | Catalonia | 632455 | 14713 | 26203 | 591539 | 41.5912 | 1.5209 | 2021-06-17 04:22:36 | Catalonia, Spain | ||
2339689 | 2339689 | 2021-06-15 | Spain | Catalonia | 631554 | 14695 | 26203 | 590656 | 41.5912 | 1.5209 | 2021-06-16 04:22:32 | Catalonia, Spain | ||
1564385 | 1564385 | 2021-06-14 | Spain | Catalonia | 630929 | 14691 | 26203 | 590035 | 41.5912 | 1.5209 | 2021-06-15 04:22:22 | Catalonia, Spain | ||
583119 | 583119 | 2020-08-13 | Spain | Catalonia | 90890 | 5709 | 26203 | 58978 | 41.5912 | 1.5209 | 2020-08-14 04:51:19 | Catalonia, Spain | ||
1736802 | 1736802 | 2021-06-12 | Spain | Catalonia | 629718 | 14691 | 26203 | 588824 | 41.5912 | 1.5209 | 2021-06-13 04:22:44 | Catalonia, Spain | ||
3381668 | 3381668 | 2021-06-13 | Spain | Catalonia | 629718 | 14691 | 26203 | 588824 | 41.5912 | 1.5209 | 2021-06-14 04:22:46 | Catalonia, Spain | ||
3970843 | 3970843 | 2021-06-11 | Spain | Catalonia | 629718 | 14691 | 26203 | 588824 | 41.5912 | 1.5209 | 2021-06-12 04:22:22 | Catalonia, Spain | ||
2717265 | 2717265 | 2021-06-10 | Spain | Catalonia | 629143 | 14690 | 26203 | 588250 | 41.5912 | 1.5209 | 2021-06-11 04:23:20 | Catalonia, Spain | ||
3531738 | 3531738 | 2020-08-12 | Spain | Catalonia | 89909 | 5706 | 26203 | 58000 | 41.5912 | 1.5209 | 2020-08-13 04:29:15 | Catalonia, Spain | ||
523150 | 523150 | 2021-06-09 | Spain | Catalonia | 618757 | 14606 | 26203 | 577948 | 41.5912 | 1.5209 | 2021-06-10 04:23:17 | Catalonia, Spain | ||
3472590 | 3472590 | 2021-06-08 | Spain | Catalonia | 617767 | 14606 | 26203 | 576958 | 41.5912 | 1.5209 | 2021-06-09 04:23:31 | Catalonia, Spain | ||
3145874 | 3145874 | 2021-06-07 | Spain | Catalonia | 617193 | 14599 | 26203 | 576391 | 41.5912 | 1.5209 | 2021-06-08 04:22:35 | Catalonia, Spain | ||
825876 | 825876 | 2021-06-06 | Spain | Catalonia | 615478 | 14595 | 26203 | 574680 | 41.5912 | 1.5209 | 2021-06-07 04:22:51 | Catalonia, 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]);