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 = "La Rioja" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714766 | 714766 | 2021-11-12 | Spain | La Rioja | 39946 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-13 04:21:38 | La Rioja, Spain | |||
718786 | 718786 | 2022-12-04 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-05 04:20:58 | La Rioja, Spain | |||
722798 | 722798 | 2021-11-20 | Spain | La Rioja | 40214 | 827 | 0 | 42.2871 | -2.5396 | 2021-11-21 04:22:13 | La Rioja, Spain | |||
730828 | 730828 | 2021-12-27 | Spain | La Rioja | 48856 | 839 | 0 | 42.2871 | -2.5396 | 2021-12-28 04:21:47 | La Rioja, Spain | |||
746645 | 746645 | 2022-04-23 | Spain | La Rioja | 94922 | 917 | 0 | 42.2871 | -2.5396 | 2022-04-24 04:20:56 | La Rioja, Spain | |||
758628 | 758628 | 2021-11-26 | Spain | La Rioja | 40532 | 828 | 0 | 42.2871 | -2.5396 | 2021-11-27 04:22:45 | La Rioja, Spain | |||
770649 | 770649 | 2021-10-23 | Spain | La Rioja | 39608 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-24 04:21:22 | La Rioja, Spain | |||
782691 | 782691 | 2021-12-13 | Spain | La Rioja | 42000 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-14 04:22:38 | La Rioja, Spain | |||
794718 | 794718 | 2022-10-24 | Spain | La Rioja | 109591 | 951 | 0 | 42.2871 | -2.5396 | 2022-10-25 04:21:53 | La Rioja, Spain | |||
798730 | 798730 | 2021-12-22 | Spain | La Rioja | 45655 | 837 | 0 | 42.2871 | -2.5396 | 2021-12-23 04:21:21 | La Rioja, Spain | |||
809875 | 809875 | 2021-09-20 | Spain | La Rioja | 39365 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-21 04:21:26 | La Rioja, Spain | |||
833931 | 833931 | 2022-12-02 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-03 04:21:02 | La Rioja, Spain | |||
849903 | 849903 | 2022-11-02 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-11-03 04:22:05 | La Rioja, Spain | |||
853919 | 853919 | 2022-09-30 | Spain | La Rioja | 108870 | 949 | 0 | 42.2871 | -2.5396 | 2022-10-01 04:23:01 | La Rioja, Spain | |||
869103 | 869103 | 2022-12-11 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-12 04:21:01 | La Rioja, Spain | |||
876565 | 876565 | 2022-03-27 | Spain | La Rioja | 92418 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-28 04:20:33 | La Rioja, Spain | |||
880582 | 880582 | 2022-08-05 | Spain | La Rioja | 107841 | 941 | 0 | 42.2871 | -2.5396 | 2022-08-06 04:20:56 | La Rioja, Spain | |||
896449 | 896449 | 2022-07-24 | Spain | La Rioja | 107173 | 932 | 0 | 42.2871 | -2.5396 | 2022-07-25 04:20:51 | La Rioja, Spain | |||
900465 | 900465 | 2022-07-22 | Spain | La Rioja | 107173 | 932 | 0 | 42.2871 | -2.5396 | 2022-07-23 04:20:53 | La Rioja, Spain | |||
904479 | 904479 | 2021-11-24 | Spain | La Rioja | 40414 | 828 | 0 | 42.2871 | -2.5396 | 2021-11-25 04:22:33 | La Rioja, Spain | |||
912512 | 912512 | 2022-10-29 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-10-30 04:22:14 | La Rioja, Spain | |||
919985 | 919985 | 2022-03-08 | Spain | La Rioja | 90011 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-09 04:20:59 | La Rioja, Spain | |||
935101 | 935101 | 2021-10-16 | Spain | La Rioja | 39564 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-17 04:21:29 | La Rioja, Spain | |||
939119 | 939119 | 2022-06-25 | Spain | La Rioja | 102297 | 925 | 0 | 42.2871 | -2.5396 | 2022-06-26 04:21:02 | La Rioja, Spain | |||
943134 | 943134 | 2022-02-28 | Spain | La Rioja | 88769 | 906 | 0 | 42.2871 | -2.5396 | 2022-03-01 04:21:09 | La Rioja, Spain | |||
947151 | 947151 | 2022-06-14 | Spain | La Rioja | 100877 | 926 | 0 | 42.2871 | -2.5396 | 2022-06-15 04:20:54 | La Rioja, Spain | |||
951166 | 951166 | 2022-03-12 | Spain | La Rioja | 90461 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-13 04:20:49 | La Rioja, Spain | |||
959197 | 959197 | 2022-07-19 | Spain | La Rioja | 106790 | 931 | 0 | 42.2871 | -2.5396 | 2022-07-20 04:20:59 | La Rioja, Spain | |||
963213 | 963213 | 2022-09-09 | Spain | La Rioja | 108475 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-10 04:21:10 | La Rioja, Spain | |||
971221 | 971221 | 2022-06-01 | Spain | La Rioja | 100041 | 924 | 0 | 42.2871 | -2.5396 | 2022-06-02 05:20:39 | La Rioja, Spain | |||
979249 | 979249 | 2022-02-01 | Spain | La Rioja | 83148 | 886 | 0 | 42.2871 | -2.5396 | 2022-02-02 04:21:09 | La Rioja, Spain | |||
987279 | 987279 | 2021-10-04 | Spain | La Rioja | 39499 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-05 04:21:27 | La Rioja, Spain | |||
991296 | 991296 | 2022-08-16 | Spain | La Rioja | 108084 | 943 | 0 | 42.2871 | -2.5396 | 2022-08-17 04:20:59 | La Rioja, Spain | |||
1014634 | 1014634 | 2021-11-21 | Spain | La Rioja | 40214 | 827 | 0 | 42.2871 | -2.5396 | 2021-11-22 04:22:20 | La Rioja, Spain | |||
1018654 | 1018654 | 2022-12-24 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-25 04:21:04 | La Rioja, Spain | |||
1022670 | 1022670 | 2022-11-04 | Spain | La Rioja | 109820 | 954 | 0 | 42.2871 | -2.5396 | 2022-11-05 04:21:52 | La Rioja, Spain | |||
1030676 | 1030676 | 2021-12-06 | Spain | La Rioja | 41008 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-07 04:22:34 | La Rioja, Spain | |||
1050142 | 1050142 | 2022-11-06 | Spain | La Rioja | 109820 | 954 | 0 | 42.2871 | -2.5396 | 2022-11-07 04:21:26 | La Rioja, Spain | |||
1058150 | 1058150 | 2022-02-23 | Spain | La Rioja | 88462 | 904 | 0 | 42.2871 | -2.5396 | 2022-02-24 04:21:14 | La Rioja, Spain | |||
1066179 | 1066179 | 2022-07-28 | Spain | La Rioja | 107372 | 935 | 0 | 42.2871 | -2.5396 | 2022-07-29 04:20:45 | La Rioja, Spain | |||
1070195 | 1070195 | 2022-08-07 | Spain | La Rioja | 107841 | 941 | 0 | 42.2871 | -2.5396 | 2022-08-08 04:21:08 | La Rioja, Spain | |||
1074213 | 1074213 | 2022-12-28 | Spain | La Rioja | 110731 | 959 | 0 | 42.2871 | -2.5396 | 2022-12-29 04:21:01 | La Rioja, Spain | |||
1078225 | 1078225 | 2021-12-09 | Spain | La Rioja | 41448 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-10 04:22:28 | La Rioja, Spain | |||
1086377 | 1086377 | 2022-08-09 | Spain | La Rioja | 107918 | 941 | 0 | 42.2871 | -2.5396 | 2022-08-10 04:20:57 | La Rioja, Spain | |||
1098420 | 1098420 | 2022-08-03 | Spain | La Rioja | 107708 | 939 | 0 | 42.2871 | -2.5396 | 2022-08-04 04:20:58 | La Rioja, Spain | |||
1109876 | 1109876 | 2022-05-21 | Spain | La Rioja | 99119 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-22 04:20:52 | La Rioja, Spain | |||
1113890 | 1113890 | 2022-01-11 | Spain | La Rioja | 64470 | 859 | 0 | 42.2871 | -2.5396 | 2022-01-12 04:21:44 | La Rioja, Spain | |||
1117889 | 1117889 | 2021-08-06 | Spain | La Rioja | 36880 | 798 | 0 | 42.2871 | -2.5396 | 2021-08-07 04:21:30 | La Rioja, Spain | |||
1141213 | 1141213 | 2022-01-23 | Spain | La Rioja | 77806 | 873 | 0 | 42.2871 | -2.5396 | 2022-01-24 04:21:12 | La Rioja, Spain | |||
1145229 | 1145229 | 2021-12-01 | Spain | La Rioja | 40826 | 830 | 0 | 42.2871 | -2.5396 | 2021-12-02 04:22:37 | La Rioja, Spain | |||
1149249 | 1149249 | 2022-12-12 | Spain | La Rioja | 110441 | 958 | 0 | 42.2871 | -2.5396 | 2022-12-13 04:21:01 | La Rioja, Spain | |||
1157453 | 1157453 | 2022-04-29 | Spain | La Rioja | 95906 | 920 | 0 | 42.2871 | -2.5396 | 2022-04-30 04:21:05 | La Rioja, Spain | |||
1161470 | 1161470 | 2022-08-18 | Spain | La Rioja | 108084 | 943 | 0 | 42.2871 | -2.5396 | 2022-08-19 04:20:54 | La Rioja, Spain | |||
1169500 | 1169500 | 2022-05-20 | Spain | La Rioja | 98637 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-21 04:20:58 | La Rioja, Spain | |||
1185047 | 1185047 | 2022-05-18 | Spain | La Rioja | 98637 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-19 04:20:54 | La Rioja, Spain | |||
1200109 | 1200109 | 2022-07-06 | Spain | La Rioja | 104230 | 927 | 0 | 42.2871 | -2.5396 | 2022-07-07 04:20:55 | La Rioja, Spain | |||
1211854 | 1211854 | 2022-07-11 | Spain | La Rioja | 105199 | 928 | 0 | 42.2871 | -2.5396 | 2022-07-12 04:20:51 | La Rioja, Spain | |||
1215868 | 1215868 | 2022-01-08 | Spain | La Rioja | 59541 | 853 | 0 | 42.2871 | -2.5396 | 2022-01-09 04:21:46 | La Rioja, Spain | |||
1223899 | 1223899 | 2022-04-14 | Spain | La Rioja | 93973 | 913 | 0 | 42.2871 | -2.5396 | 2022-04-15 04:20:57 | La Rioja, Spain | |||
1227914 | 1227914 | 2022-01-24 | Spain | La Rioja | 79208 | 879 | 0 | 42.2871 | -2.5396 | 2022-01-25 04:21:05 | La Rioja, Spain | |||
1231930 | 1231930 | 2021-11-28 | Spain | La Rioja | 40532 | 828 | 0 | 42.2871 | -2.5396 | 2021-11-29 04:22:30 | La Rioja, Spain | |||
1235946 | 1235946 | 2021-09-27 | Spain | La Rioja | 39434 | 823 | 0 | 42.2871 | -2.5396 | 2021-09-28 04:21:28 | La Rioja, Spain | |||
1239965 | 1239965 | 2022-11-28 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-29 04:21:05 | La Rioja, Spain | |||
1251059 | 1251059 | 2022-08-23 | Spain | La Rioja | 108214 | 945 | 0 | 42.2871 | -2.5396 | 2022-08-24 04:20:46 | La Rioja, Spain | |||
1255073 | 1255073 | 2021-12-20 | Spain | La Rioja | 44289 | 834 | 0 | 42.2871 | -2.5396 | 2021-12-21 03:21:27 | La Rioja, Spain | |||
1259089 | 1259089 | 2021-12-18 | Spain | La Rioja | 43249 | 832 | 0 | 42.2871 | -2.5396 | 2021-12-19 04:21:11 | La Rioja, Spain | |||
1263088 | 1263088 | 2021-09-09 | Spain | La Rioja | 39197 | 820 | 0 | 42.2871 | -2.5396 | 2021-09-10 04:21:20 | La Rioja, Spain | |||
1274589 | 1274589 | 2021-10-03 | Spain | La Rioja | 39480 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-04 04:21:31 | La Rioja, Spain | |||
1282290 | 1282290 | 2022-01-05 | Spain | La Rioja | 57023 | 851 | 0 | 42.2871 | -2.5396 | 2022-01-06 04:22:09 | La Rioja, Spain | |||
1286306 | 1286306 | 2022-01-04 | Spain | La Rioja | 56062 | 850 | 0 | 42.2871 | -2.5396 | 2022-01-05 04:21:59 | La Rioja, Spain | |||
1294336 | 1294336 | 2022-02-05 | Spain | La Rioja | 83941 | 888 | 0 | 42.2871 | -2.5396 | 2022-02-06 04:21:00 | La Rioja, Spain | |||
1298353 | 1298353 | 2022-02-17 | Spain | La Rioja | 87544 | 904 | 0 | 42.2871 | -2.5396 | 2022-02-18 04:21:04 | La Rioja, Spain | |||
1314501 | 1314501 | 2022-05-27 | Spain | La Rioja | 99738 | 924 | 0 | 42.2871 | -2.5396 | 2022-05-28 04:21:07 | La Rioja, Spain | |||
1318515 | 1318515 | 2022-01-26 | Spain | La Rioja | 80588 | 879 | 0 | 42.2871 | -2.5396 | 2022-01-27 04:21:19 | La Rioja, Spain | |||
1322531 | 1322531 | 2021-11-14 | Spain | La Rioja | 39946 | 825 | 0 | 42.2871 | -2.5396 | 2021-11-15 04:21:36 | La Rioja, Spain | |||
1326548 | 1326548 | 2022-04-26 | Spain | La Rioja | 95335 | 920 | 0 | 42.2871 | -2.5396 | 2022-04-27 04:20:52 | La Rioja, Spain | |||
1334577 | 1334577 | 2021-09-28 | Spain | La Rioja | 39440 | 823 | 0 | 42.2871 | -2.5396 | 2021-09-29 04:21:45 | La Rioja, Spain | |||
1342589 | 1342589 | 2021-08-11 | Spain | La Rioja | 37431 | 806 | 0 | 42.2871 | -2.5396 | 2021-08-12 04:21:25 | La Rioja, Spain | |||
1346622 | 1346622 | 2022-08-10 | Spain | La Rioja | 107918 | 941 | 0 | 42.2871 | -2.5396 | 2022-08-11 04:20:49 | La Rioja, Spain | |||
1358637 | 1358637 | 2021-11-27 | Spain | La Rioja | 40532 | 828 | 0 | 42.2871 | -2.5396 | 2021-11-28 04:22:43 | La Rioja, Spain | |||
1362653 | 1362653 | 2022-02-08 | Spain | La Rioja | 85478 | 894 | 0 | 42.2871 | -2.5396 | 2022-02-09 04:21:04 | La Rioja, Spain | |||
1366781 | 1366781 | 2022-10-28 | Spain | La Rioja | 109722 | 953 | 0 | 42.2871 | -2.5396 | 2022-10-29 04:21:13 | La Rioja, Spain | |||
1370797 | 1370797 | 2022-09-21 | Spain | La Rioja | 108618 | 948 | 0 | 42.2871 | -2.5396 | 2022-09-22 04:22:56 | La Rioja, Spain | |||
1374792 | 1374792 | 2021-09-15 | Spain | La Rioja | 39299 | 822 | 0 | 42.2871 | -2.5396 | 2021-09-16 04:22:19 | La Rioja, Spain | |||
1385930 | 1385930 | 2021-09-13 | Spain | La Rioja | 39267 | 821 | 0 | 42.2871 | -2.5396 | 2021-09-14 04:21:41 | La Rioja, Spain | |||
1389961 | 1389961 | 2022-01-07 | Spain | La Rioja | 59541 | 853 | 0 | 42.2871 | -2.5396 | 2022-01-08 04:21:53 | La Rioja, Spain | |||
1393979 | 1393979 | 2022-09-02 | Spain | La Rioja | 108377 | 947 | 0 | 42.2871 | -2.5396 | 2022-09-03 04:21:04 | La Rioja, Spain | |||
1397994 | 1397994 | 2022-05-06 | Spain | La Rioja | 97089 | 920 | 0 | 42.2871 | -2.5396 | 2022-05-07 04:21:09 | La Rioja, Spain | |||
1405345 | 1405345 | 2022-08-02 | Spain | La Rioja | 107708 | 939 | 0 | 42.2871 | -2.5396 | 2022-08-03 04:20:59 | La Rioja, Spain | |||
1417389 | 1417389 | 2022-07-08 | Spain | La Rioja | 105199 | 928 | 0 | 42.2871 | -2.5396 | 2022-07-09 04:20:59 | La Rioja, Spain | |||
1421405 | 1421405 | 2022-06-08 | Spain | La Rioja | 100521 | 925 | 0 | 42.2871 | -2.5396 | 2022-06-09 04:20:54 | La Rioja, Spain | |||
1432867 | 1432867 | 2021-12-28 | Spain | La Rioja | 49896 | 840 | 0 | 42.2871 | -2.5396 | 2021-12-29 03:21:43 | La Rioja, Spain | |||
1436884 | 1436884 | 2022-03-28 | Spain | La Rioja | 92418 | 910 | 0 | 42.2871 | -2.5396 | 2022-03-29 04:20:46 | La Rioja, Spain | |||
1464385 | 1464385 | 2022-02-10 | Spain | La Rioja | 86169 | 895 | 0 | 42.2871 | -2.5396 | 2022-02-11 04:21:09 | La Rioja, Spain | |||
1468401 | 1468401 | 2022-03-24 | Spain | La Rioja | 91927 | 909 | 0 | 42.2871 | -2.5396 | 2022-03-25 04:20:46 | La Rioja, Spain | |||
1472416 | 1472416 | 2022-01-17 | Spain | La Rioja | 74562 | 864 | 0 | 42.2871 | -2.5396 | 2022-01-18 04:21:04 | La Rioja, Spain | |||
1483855 | 1483855 | 2021-08-13 | Spain | La Rioja | 37650 | 808 | 0 | 42.2871 | -2.5396 | 2021-08-14 04:21:25 | La Rioja, Spain | |||
1487888 | 1487888 | 2022-07-26 | Spain | La Rioja | 107372 | 935 | 0 | 42.2871 | -2.5396 | 2022-07-27 04:21:04 | La Rioja, Spain | |||
1491902 | 1491902 | 2021-10-12 | Spain | La Rioja | 39542 | 823 | 0 | 42.2871 | -2.5396 | 2021-10-13 04:20:51 | La Rioja, Spain | |||
1503901 | 1503901 | 2022-05-16 | Spain | La Rioja | 98175 | 922 | 0 | 42.2871 | -2.5396 | 2022-05-17 04:20:59 | La Rioja, 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]);