⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

407 rows where country_or_region = "Spain" and province_or_state = "Navarra" sorted by day descending

View and edit SQL

Suggested facets: recovered, day (date), last_update (date)

province_or_state

  • Navarra · 407

country_or_region

  • Spain · 407
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
235220 2021-06-24 Spain Navarra     63680 1182 3905 58593 42.6954 -1.6761 2021-06-25 04:21:33 Navarra, Spain
472168 2021-06-23 Spain Navarra     63643 1181 3905 58557 42.6954 -1.6761 2021-06-24 04:21:55 Navarra, Spain
627226 2021-06-22 Spain Navarra     63585 1180 3905 58500 42.6954 -1.6761 2021-06-23 04:21:46 Navarra, Spain
227246 2021-06-21 Spain Navarra     63545 1180 3905 58460 42.6954 -1.6761 2021-06-22 04:21:34 Navarra, Spain
1472768 2021-06-20 Spain Navarra     63423 1179 3905 58339 42.6954 -1.6761 2021-06-21 04:21:41 Navarra, Spain
1304009 2021-06-19 Spain Navarra     63423 1179 3905 58339 42.6954 -1.6761 2021-06-20 04:21:48 Navarra, Spain
303611 2021-06-18 Spain Navarra     63423 1179 3905 58339 42.6954 -1.6761 2021-06-19 04:22:33 Navarra, Spain
886441 2021-06-17 Spain Navarra     63375 1178 3905 58292 42.6954 -1.6761 2021-06-18 04:22:16 Navarra, Spain
42336 2021-06-16 Spain Navarra     63323 1178 3905 58240 42.6954 -1.6761 2021-06-17 04:22:36 Navarra, Spain
1705158 2021-06-15 Spain Navarra     63261 1178 3905 58178 42.6954 -1.6761 2021-06-16 04:22:32 Navarra, Spain
1661429 2021-06-14 Spain Navarra     63225 1178 3905 58142 42.6954 -1.6761 2021-06-15 04:22:22 Navarra, Spain
319505 2021-06-13 Spain Navarra     63087 1178 3905 58004 42.6954 -1.6761 2021-06-14 04:22:46 Navarra, Spain
619250 2021-06-12 Spain Navarra     63087 1178 3905 58004 42.6954 -1.6761 2021-06-13 04:22:44 Navarra, Spain
592259 2021-06-11 Spain Navarra     63087 1178 3905 58004 42.6954 -1.6761 2021-06-12 04:22:22 Navarra, Spain
273137 2021-06-10 Spain Navarra     63027 1178 3905 57944 42.6954 -1.6761 2021-06-11 04:23:20 Navarra, Spain
1638195 2021-06-09 Spain Navarra     62975 1178 3905 57892 42.6954 -1.6761 2021-06-10 04:23:17 Navarra, Spain
1744808 2021-06-08 Spain Navarra     62918 1178 3905 57835 42.6954 -1.6761 2021-06-09 04:23:31 Navarra, Spain
577351 2021-06-07 Spain Navarra     62873 1178 3905 57790 42.6954 -1.6761 2021-06-08 04:22:35 Navarra, Spain
246214 2021-06-06 Spain Navarra     62720 1177 3905 57638 42.6954 -1.6761 2021-06-07 04:22:51 Navarra, Spain
674191 2021-06-05 Spain Navarra     62720 1177 3905 57638 42.6954 -1.6761 2021-06-06 04:24:03 Navarra, Spain
553454 2021-06-04 Spain Navarra     62720 1177 3905 57638 42.6954 -1.6761 2021-06-05 04:23:03 Navarra, Spain
1460851 2021-06-03 Spain Navarra     62662 1176 3905 57581 42.6954 -1.6761 2021-06-04 04:23:37 Navarra, Spain
1399844 2021-06-02 Spain Navarra     62583 1176 3905 57502 42.6954 -1.6761 2021-06-03 04:23:32 Navarra, Spain
1709191 2021-06-01 Spain Navarra     62490 1175 3905 57410 42.6954 -1.6761 2021-06-02 04:24:34 Navarra, Spain
19421 2021-05-31 Spain Navarra     62422 1174 3905 57343 42.6954 -1.6761 2021-06-01 04:23:09 Navarra, Spain
1497814 2021-05-30 Spain Navarra     62232 1171 3905 57156 42.6954 -1.6761 2021-05-31 03:08:59 Navarra, Spain
623237 2021-05-29 Spain Navarra     62232 1171 3905 57156 42.6954 -1.6761 2021-05-30 04:20:55 Navarra, Spain
81093 2021-05-28 Spain Navarra     62232 1171 3905 57156 42.6954 -1.6761 2021-05-29 04:20:41 Navarra, Spain
1426368 2021-05-27 Spain Navarra     62154 1171 3905 57078 42.6954 -1.6761 2021-05-28 04:20:36 Navarra, Spain
1549335 2021-05-26 Spain Navarra     62060 1170 3905 56985 42.6954 -1.6761 2021-05-27 04:20:59 Navarra, Spain
1200911 2021-05-25 Spain Navarra     62007 1170 3905 56932 42.6954 -1.6761 2021-05-26 04:20:35 Navarra, Spain
149904 2021-05-24 Spain Navarra     61948 1170 3905 56873 42.6954 -1.6761 2021-05-25 04:21:08 Navarra, Spain
690057 2021-05-23 Spain Navarra     61811 1170 3905 56736 42.6954 -1.6761 2021-05-24 04:20:53 Navarra, Spain
387671 2021-05-22 Spain Navarra     61811 1170 3905 56736 42.6954 -1.6761 2021-05-23 04:20:51 Navarra, Spain
969986 2021-05-21 Spain Navarra     61811 1170 3905 56736 42.6954 -1.6761 2021-05-22 04:20:45 Navarra, Spain
57948 2021-05-20 Spain Navarra     61740 1170 3905 56665 42.6954 -1.6761 2021-05-21 04:20:43 Navarra, Spain
464210 2021-05-19 Spain Navarra     61682 1170 3905 56607 42.6954 -1.6761 2021-05-20 04:21:05 Navarra, Spain
1276166 2021-05-18 Spain Navarra     61606 1170 3905 56531 42.6954 -1.6761 2021-05-19 04:20:42 Navarra, Spain
231230 2021-05-17 Spain Navarra     61544 1170 3905 56469 42.6954 -1.6761 2021-05-18 04:20:33 Navarra, Spain
1159445 2021-05-16 Spain Navarra     61340 1168 3905 56267 42.6954 -1.6761 2021-05-17 04:20:34 Navarra, Spain
1009001 2021-05-15 Spain Navarra     61340 1168 3905 56267 42.6954 -1.6761 2021-05-16 04:20:49 Navarra, Spain
805113 2021-05-14 Spain Navarra     61340 1168 3905 56267 42.6954 -1.6761 2021-05-15 04:20:58 Navarra, Spain
1192941 2021-05-13 Spain Navarra     61267 1168 3905 56194 42.6954 -1.6761 2021-05-14 04:20:41 Navarra, Spain
686070 2021-05-12 Spain Navarra     61178 1166 3905 56107 42.6954 -1.6761 2021-05-13 04:20:51 Navarra, Spain
129470 2021-05-11 Spain Navarra     61110 1163 3905 56042 42.6954 -1.6761 2021-05-12 04:21:29 Navarra, Spain
1257475 2021-05-10 Spain Navarra     61032 1167 3905 55960 42.6954 -1.6761 2021-05-11 04:20:41 Navarra, Spain
121496 2021-05-09 Spain Navarra     60753 1164 3905 55684 42.6954 -1.6761 2021-05-10 04:20:38 Navarra, Spain
89066 2021-05-08 Spain Navarra     60753 1164 3905 55684 42.6954 -1.6761 2021-05-09 04:20:35 Navarra, Spain
522564 2021-05-07 Spain Navarra     60753 1164 3905 55684 42.6954 -1.6761 2021-05-08 04:21:04 Navarra, Spain
1685188 2021-05-06 Spain Navarra     60625 1165 3905 55555 42.6954 -1.6761 2021-05-07 04:20:40 Navarra, Spain
23407 2021-05-05 Spain Navarra     60487 1165 3905 55417 42.6954 -1.6761 2021-05-06 04:20:38 Navarra, Spain
1331349 2021-05-04 Spain Navarra     60376 1164 3905 55307 42.6954 -1.6761 2021-05-05 04:20:43 Navarra, Spain
1035936 2021-05-03 Spain Navarra     60249 1163 3905 55181 42.6954 -1.6761 2021-05-04 04:20:34 Navarra, Spain
914126 2021-05-02 Spain Navarra     59870 1156 3905 54809 42.6954 -1.6761 2021-05-03 04:20:39 Navarra, Spain
1757092 2021-05-01 Spain Navarra     59870 1156 3905 54809 42.6954 -1.6761 2021-05-02 04:20:48 Navarra, Spain
1456863 2021-04-30 Spain Navarra     59870 1156 3905 54809 42.6954 -1.6761 2021-05-01 04:20:47 Navarra, Spain
1614677 2021-04-29 Spain Navarra     59722 1155 3905 54662 42.6954 -1.6761 2021-04-30 04:21:03 Navarra, Spain
484076 2021-04-28 Spain Navarra     59538 1154 3905 54479 42.6954 -1.6761 2021-04-29 04:20:55 Navarra, Spain
335114 2021-04-27 Spain Navarra     59378 1152 3905 54321 42.6954 -1.6761 2021-04-28 04:20:32 Navarra, Spain
1358159 2021-04-26 Spain Navarra     59233 1151 3905 54177 42.6954 -1.6761 2021-04-27 04:20:52 Navarra, Spain
496115 2021-04-25 Spain Navarra     58786 1144 3905 53737 42.6954 -1.6761 2021-04-26 04:21:04 Navarra, Spain
1112714 2021-04-24 Spain Navarra     58786 1144 3905 53737 42.6954 -1.6761 2021-04-25 04:20:32 Navarra, Spain
488063 2021-04-23 Spain Navarra     58786 1144 3905 53737 42.6954 -1.6761 2021-04-24 04:20:38 Navarra, Spain
1170448 2021-04-22 Spain Navarra     58592 1144 3905 53543 42.6954 -1.6761 2021-04-23 04:20:52 Navarra, Spain
1403919 2021-04-21 Spain Navarra     58406 1141 3905 53360 42.6954 -1.6761 2021-04-22 04:20:53 Navarra, Spain
1713177 2021-04-20 Spain Navarra     58034 1138 3905 57064 42.6954 -1.6761 2021-04-21 04:21:14 Navarra, Spain
607306 2021-04-19 Spain Navarra     58034 1138 3905 52991 42.6954 -1.6761 2021-04-20 04:20:41 Navarra, Spain
918113 2021-04-18 Spain Navarra     57581 1137 3905 52539 42.6954 -1.6761 2021-04-19 04:20:57 Navarra, Spain
1319424 2021-04-17 Spain Navarra     57581 1137 3905 52539 42.6954 -1.6761 2021-04-18 04:20:41 Navarra, Spain
989116 2021-04-16 Spain Navarra     57581 1137 3905 52539 42.6954 -1.6761 2021-04-17 04:20:40 Navarra, Spain
380220 2021-04-15 Spain Navarra     57378 1134 3905 52339 42.6954 -1.6761 2021-04-16 04:20:46 Navarra, Spain
906170 2021-04-14 Spain Navarra     57180 1134 3905 52141 42.6954 -1.6761 2021-04-15 04:20:54 Navarra, Spain
1079397 2021-04-13 Spain Navarra     56959 1136 3905 51918 42.6954 -1.6761 2021-04-14 04:20:41 Navarra, Spain
354633 2021-04-12 Spain Navarra     56771 1136 3905 51730 42.6954 -1.6761 2021-04-13 04:20:37 Navarra, Spain
1181082 2021-04-11 Spain Navarra     56129 1126 3905 51098 42.6954 -1.6761 2021-04-12 04:21:00 Navarra, Spain
1188954 2021-04-10 Spain Navarra     56129 1126 3905 51098 42.6954 -1.6761 2021-04-11 04:20:56 Navarra, Spain
1693140 2021-04-09 Spain Navarra     56129 1126 3905 51098 42.6954 -1.6761 2021-04-10 04:20:59 Navarra, Spain
569379 2021-04-08 Spain Navarra     55818 1125 3905 50788 42.6954 -1.6761 2021-04-09 04:21:13 Navarra, Spain
1346198 2021-04-07 Spain Navarra     55584 1124 3905 50555 42.6954 -1.6761 2021-04-08 04:21:13 Navarra, Spain
350566 2021-04-06 Spain Navarra     55359 1123 3905 50331 42.6954 -1.6761 2021-04-07 04:20:53 Navarra, Spain
1043891 2021-04-05 Spain Navarra     55164 1123 3905 50136 42.6954 -1.6761 2021-04-06 04:20:32 Navarra, Spain
215211 2021-04-04 Spain Navarra     54832 1122 3905 49805 42.6954 -1.6761 2021-04-05 04:20:35 Navarra, Spain
1701170 2021-04-03 Spain Navarra     54832 1122 3905 49805 42.6954 -1.6761 2021-04-04 04:20:49 Navarra, Spain
953859 2021-04-02 Spain Navarra     54479 1121 3905 49453 42.6954 -1.6761 2021-04-03 04:20:44 Navarra, Spain
125483 2021-04-01 Spain Navarra     54479 1121 3905 49453 42.6954 -1.6761 2021-04-02 04:20:36 Navarra, Spain
1516375 2021-03-31 Spain Navarra     54315 1121 3905 49289 42.6954 -1.6761 2021-04-01 04:27:05 Navarra, Spain
1717164 2021-03-30 Spain Navarra     54145 1121 3905 49119 42.6954 -1.6761 2021-03-31 04:26:25 Navarra, Spain
733151 2021-03-29 Spain Navarra     53949 1121 3905 48923 42.6954 -1.6761 2021-03-30 04:26:23 Navarra, Spain
422455 2021-03-28 Spain Navarra     53517 1117 3905 48495 42.6954 -1.6761 2021-03-29 04:28:35 Navarra, Spain
1732846 2021-03-27 Spain Navarra     53517 1117 3905 48495 42.6954 -1.6761 2021-03-28 05:28:10 Navarra, Spain
403289 2021-03-26 Spain Navarra     53517 1117 3905 48495 42.6954 -1.6761 2021-03-27 05:25:04 Navarra, Spain
1354172 2021-03-25 Spain Navarra     53298 1116 3905 48277 42.6954 -1.6761 2021-03-26 05:26:55 Navarra, Spain
507862 2021-03-24 Spain Navarra     52952 1116 3905 47931 42.6954 -1.6761 2021-03-25 05:27:00 Navarra, Spain
1590779 2021-03-23 Spain Navarra     52952 1116 3905 47931 42.6954 -1.6761 2021-03-24 05:25:40 Navarra, Spain
840171 2021-03-22 Spain Navarra     52827 1116 3905 47806 42.6954 -1.6761 2021-03-23 05:26:18 Navarra, Spain
721411 2021-03-21 Spain Navarra     52453 1113 3905 47435 42.6954 -1.6761 2021-03-22 05:25:43 Navarra, Spain
442554 2021-03-20 Spain Navarra     52453 1113 3905 47435 42.6954 -1.6761 2021-03-21 05:25:44 Navarra, Spain
545496 2021-03-19 Spain Navarra     52453 1113 3905 47435 42.6954 -1.6761 2021-03-20 05:25:46 Navarra, Spain
1350185 2021-03-18 Spain Navarra     52453 1113 3905 47435 42.6954 -1.6761 2021-03-19 05:26:09 Navarra, Spain
85079 2021-03-17 Spain Navarra     52376 1113 3905 47358 42.6954 -1.6761 2021-03-18 05:26:22 Navarra, Spain

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);