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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2463087 | 2463087 | 2021-09-14 | Spain | Catalonia | 906798 | 15475 | 0 | 41.5912 | 1.5209 | 2021-09-15 03:22:37 | Catalonia, Spain | |||
1385926 | 1385926 | 2021-09-13 | Spain | Catalonia | 906168 | 15455 | 0 | 41.5912 | 1.5209 | 2021-09-14 04:21:41 | Catalonia, Spain | |||
1885295 | 1885295 | 2021-09-12 | Spain | Catalonia | 904560 | 15437 | 0 | 41.5912 | 1.5209 | 2021-09-13 04:21:15 | Catalonia, Spain | |||
3806198 | 3806198 | 2021-09-11 | Spain | Catalonia | 904560 | 15437 | 0 | 41.5912 | 1.5209 | 2021-09-12 04:21:13 | Catalonia, Spain | |||
3449138 | 3449138 | 2021-09-10 | Spain | Catalonia | 904560 | 15437 | 0 | 41.5912 | 1.5209 | 2021-09-11 04:21:30 | Catalonia, Spain | |||
1263084 | 1263084 | 2021-09-09 | Spain | Catalonia | 903454 | 15429 | 0 | 41.5912 | 1.5209 | 2021-09-10 04:21:20 | Catalonia, Spain | |||
2279454 | 2279454 | 2021-09-08 | Spain | Catalonia | 902243 | 15414 | 0 | 41.5912 | 1.5209 | 2021-09-09 04:21:27 | Catalonia, Spain | |||
642233 | 642233 | 2021-09-07 | Spain | Catalonia | 900596 | 15391 | 0 | 41.5912 | 1.5209 | 2021-09-08 04:21:31 | Catalonia, Spain | |||
3194296 | 3194296 | 2021-09-06 | Spain | Catalonia | 898290 | 15366 | 0 | 41.5912 | 1.5209 | 2021-09-07 04:21:35 | Catalonia, Spain | |||
3281164 | 3281164 | 2021-09-05 | Spain | Catalonia | 898290 | 15353 | 0 | 41.5912 | 1.5209 | 2021-09-06 04:21:22 | Catalonia, Spain | |||
249578 | 249578 | 2021-09-04 | Spain | Catalonia | 898290 | 15353 | 0 | 41.5912 | 1.5209 | 2021-09-05 04:21:33 | Catalonia, Spain | |||
3974859 | 3974859 | 2021-09-03 | Spain | Catalonia | 898290 | 15353 | 0 | 41.5912 | 1.5209 | 2021-09-04 04:21:28 | Catalonia, Spain | |||
178321 | 178321 | 2021-09-02 | Spain | Catalonia | 897205 | 15322 | 0 | 41.5912 | 1.5209 | 2021-09-03 04:21:20 | Catalonia, Spain | |||
67356 | 67356 | 2021-09-01 | Spain | Catalonia | 893681 | 15256 | 0 | 41.5912 | 1.5209 | 2021-09-02 04:21:15 | Catalonia, Spain | |||
2068198 | 2068198 | 2021-08-31 | Spain | Catalonia | 893045 | 15236 | 0 | 41.5912 | 1.5209 | 2021-09-01 04:21:38 | Catalonia, Spain | |||
1775652 | 1775652 | 2021-08-30 | Spain | Catalonia | 891922 | 15213 | 0 | 41.5912 | 1.5209 | 2021-08-31 04:21:46 | Catalonia, Spain | |||
3892226 | 3892226 | 2021-08-29 | Spain | Catalonia | 889270 | 15173 | 0 | 41.5912 | 1.5209 | 2021-08-30 04:21:23 | Catalonia, Spain | |||
2793329 | 2793329 | 2021-08-28 | Spain | Catalonia | 889270 | 15173 | 0 | 41.5912 | 1.5209 | 2021-08-29 04:21:14 | Catalonia, Spain | |||
2923488 | 2923488 | 2021-08-27 | Spain | Catalonia | 889270 | 15173 | 0 | 41.5912 | 1.5209 | 2021-08-28 04:21:28 | Catalonia, Spain | |||
1596502 | 1596502 | 2021-08-26 | Spain | Catalonia | 887826 | 15132 | 0 | 41.5912 | 1.5209 | 2021-08-27 04:21:37 | Catalonia, Spain | |||
32711 | 32711 | 2021-08-25 | Spain | Catalonia | 887757 | 15129 | 0 | 41.5912 | 1.5209 | 2021-08-26 04:21:28 | Catalonia, Spain | |||
3105750 | 3105750 | 2021-08-24 | Spain | Catalonia | 886082 | 15101 | 0 | 41.5912 | 1.5209 | 2021-08-25 04:21:41 | Catalonia, Spain | |||
3165921 | 3165921 | 2021-08-23 | Spain | Catalonia | 884226 | 15080 | 0 | 41.5912 | 1.5209 | 2021-08-24 04:21:19 | Catalonia, Spain | |||
2175848 | 2175848 | 2021-08-22 | Spain | Catalonia | 880728 | 15062 | 0 | 41.5912 | 1.5209 | 2021-08-23 04:21:27 | Catalonia, Spain | |||
3555944 | 3555944 | 2021-08-21 | Spain | Catalonia | 880728 | 15062 | 0 | 41.5912 | 1.5209 | 2021-08-22 04:21:29 | Catalonia, Spain | |||
1854286 | 1854286 | 2021-08-20 | Spain | Catalonia | 880728 | 15062 | 0 | 41.5912 | 1.5209 | 2021-08-21 04:21:38 | Catalonia, Spain | |||
511993 | 511993 | 2021-08-19 | Spain | Catalonia | 878858 | 15012 | 0 | 41.5912 | 1.5209 | 2021-08-20 04:21:33 | Catalonia, Spain | |||
2518472 | 2518472 | 2021-08-18 | Spain | Catalonia | 876675 | 14994 | 0 | 41.5912 | 1.5209 | 2021-08-19 04:21:15 | Catalonia, Spain | |||
245564 | 245564 | 2021-08-17 | Spain | Catalonia | 874604 | 14985 | 0 | 41.5912 | 1.5209 | 2021-08-18 04:21:35 | Catalonia, Spain | |||
1604527 | 1604527 | 2021-08-16 | Spain | Catalonia | 872755 | 14975 | 0 | 41.5912 | 1.5209 | 2021-08-17 04:21:49 | Catalonia, Spain | |||
103621 | 103621 | 2021-08-15 | Spain | Catalonia | 868586 | 14958 | 0 | 41.5912 | 1.5209 | 2021-08-16 04:21:31 | Catalonia, Spain | |||
507979 | 507979 | 2021-08-14 | Spain | Catalonia | 868586 | 14958 | 0 | 41.5912 | 1.5209 | 2021-08-15 04:21:41 | Catalonia, Spain | |||
1483851 | 1483851 | 2021-08-13 | Spain | Catalonia | 868586 | 14958 | 0 | 41.5912 | 1.5209 | 2021-08-14 04:21:25 | Catalonia, Spain | |||
2899981 | 2899981 | 2021-08-12 | Spain | Catalonia | 866622 | 14954 | 0 | 41.5912 | 1.5209 | 2021-08-13 04:21:24 | Catalonia, Spain | |||
1342585 | 1342585 | 2021-08-11 | Spain | Catalonia | 864089 | 14943 | 0 | 41.5912 | 1.5209 | 2021-08-12 04:21:25 | Catalonia, Spain | |||
2351732 | 2351732 | 2021-08-10 | Spain | Catalonia | 861241 | 14937 | 0 | 41.5912 | 1.5209 | 2021-08-11 04:21:58 | Catalonia, Spain | |||
650261 | 650261 | 2021-08-09 | Spain | Catalonia | 858718 | 14920 | 0 | 41.5912 | 1.5209 | 2021-08-10 04:21:27 | Catalonia, Spain | |||
589923 | 589923 | 2021-08-08 | Spain | Catalonia | 853123 | 14914 | 0 | 41.5912 | 1.5209 | 2021-08-09 04:21:24 | Catalonia, Spain | |||
2203935 | 2203935 | 2021-08-07 | Spain | Catalonia | 853123 | 14914 | 0 | 41.5912 | 1.5209 | 2021-08-08 04:21:33 | Catalonia, Spain | |||
1117885 | 1117885 | 2021-08-06 | Spain | Catalonia | 853123 | 14914 | 0 | 41.5912 | 1.5209 | 2021-08-07 04:21:30 | Catalonia, Spain | |||
1956822 | 1956822 | 2021-08-05 | Spain | Catalonia | 850299 | 14907 | 0 | 41.5912 | 1.5209 | 2021-08-06 04:21:18 | 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 | ||
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 | ||
3904268 | 3904268 | 2021-07-31 | Spain | Catalonia | 830538 | 14813 | 26203 | 789522 | 41.5912 | 1.5209 | 2021-08-01 04:21:50 | 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 | ||
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 | ||
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 | ||
1378802 | 1378802 | 2021-07-25 | Spain | Catalonia | 798594 | 14778 | 26203 | 757613 | 41.5912 | 1.5209 | 2021-07-26 04:21:28 | 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 | ||
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 | ||
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 | ||
483885 | 483885 | 2021-07-19 | Spain | Catalonia | 769996 | 14764 | 26203 | 729029 | 41.5912 | 1.5209 | 2021-07-20 04:21:48 | 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 | ||
3706420 | 3706420 | 2021-07-17 | Spain | Catalonia | 752417 | 14762 | 26203 | 711452 | 41.5912 | 1.5209 | 2021-07-18 04:22:07 | 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 | ||
296307 | 296307 | 2021-07-15 | Spain | Catalonia | 742782 | 14761 | 26203 | 701818 | 41.5912 | 1.5209 | 2021-07-16 04:21:22 | 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 | ||
3741376 | 3741376 | 2021-07-12 | Spain | Catalonia | 696621 | 14756 | 26203 | 655662 | 41.5912 | 1.5209 | 2021-07-13 04:21:18 | 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 | ||
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 | ||
778656 | 778656 | 2021-07-08 | Spain | Catalonia | 686599 | 14755 | 26203 | 645641 | 41.5912 | 1.5209 | 2021-07-09 04:21:21 | 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 | ||
1932732 | 1932732 | 2021-07-05 | Spain | Catalonia | 670410 | 14741 | 26203 | 629466 | 41.5912 | 1.5209 | 2021-07-06 04:21:32 | 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 | ||
3125802 | 3125802 | 2021-06-28 | Spain | Catalonia | 641306 | 14733 | 26203 | 600370 | 41.5912 | 1.5209 | 2021-06-29 04:21:28 | 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 | ||
1712620 | 1712620 | 2021-06-25 | Spain | Catalonia | 639380 | 14731 | 26203 | 598446 | 41.5912 | 1.5209 | 2021-06-26 04:21:43 | 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 | ||
2884663 | 2884663 | 2021-06-20 | Spain | Catalonia | 634247 | 14714 | 26203 | 593330 | 41.5912 | 1.5209 | 2021-06-21 04:21:41 | 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 | ||
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 | ||
3381668 | 3381668 | 2021-06-13 | Spain | Catalonia | 629718 | 14691 | 26203 | 588824 | 41.5912 | 1.5209 | 2021-06-14 04:22:46 | 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 | ||
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 | ||
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 |
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]);