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 = "Navarra" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
714770 | 714770 | 2021-11-12 | Spain | Navarra | 84397 | 1256 | 0 | 42.6954 | -1.6761 | 2021-11-13 04:21:38 | Navarra, Spain | |||
718790 | 718790 | 2022-12-04 | Spain | Navarra | 256528 | 1729 | 0 | 42.6954 | -1.6761 | 2022-12-05 04:20:58 | Navarra, Spain | |||
722802 | 722802 | 2021-11-20 | Spain | Navarra | 85762 | 1257 | 0 | 42.6954 | -1.6761 | 2021-11-21 04:22:13 | Navarra, Spain | |||
730832 | 730832 | 2021-12-27 | Spain | Navarra | 112130 | 1288 | 0 | 42.6954 | -1.6761 | 2021-12-28 04:21:47 | Navarra, Spain | |||
746649 | 746649 | 2022-04-23 | Spain | Navarra | 237512 | 1532 | 0 | 42.6954 | -1.6761 | 2022-04-24 04:20:56 | Navarra, Spain | |||
758632 | 758632 | 2021-11-26 | Spain | Navarra | 87702 | 1262 | 0 | 42.6954 | -1.6761 | 2021-11-27 04:22:45 | Navarra, Spain | |||
770653 | 770653 | 2021-10-23 | Spain | Navarra | 83082 | 1251 | 0 | 42.6954 | -1.6761 | 2021-10-24 04:21:22 | Navarra, Spain | |||
782695 | 782695 | 2021-12-13 | Spain | Navarra | 96576 | 1272 | 0 | 42.6954 | -1.6761 | 2021-12-14 04:22:38 | Navarra, Spain | |||
794722 | 794722 | 2022-10-24 | Spain | Navarra | 255923 | 1714 | 0 | 42.6954 | -1.6761 | 2022-10-25 04:21:53 | Navarra, Spain | |||
798734 | 798734 | 2021-12-22 | Spain | Navarra | 103563 | 1282 | 0 | 42.6954 | -1.6761 | 2021-12-23 04:21:21 | Navarra, Spain | |||
809879 | 809879 | 2021-09-20 | Spain | Navarra | 82356 | 1238 | 0 | 42.6954 | -1.6761 | 2021-09-21 04:21:26 | Navarra, Spain | |||
833935 | 833935 | 2022-12-02 | Spain | Navarra | 256528 | 1729 | 0 | 42.6954 | -1.6761 | 2022-12-03 04:21:02 | Navarra, Spain | |||
849907 | 849907 | 2022-11-02 | Spain | Navarra | 256042 | 1716 | 0 | 42.6954 | -1.6761 | 2022-11-03 04:22:05 | Navarra, Spain | |||
853923 | 853923 | 2022-09-30 | Spain | Navarra | 255511 | 1707 | 0 | 42.6954 | -1.6761 | 2022-10-01 04:23:01 | Navarra, Spain | |||
869107 | 869107 | 2022-12-11 | Spain | Navarra | 256691 | 1730 | 0 | 42.6954 | -1.6761 | 2022-12-12 04:21:01 | Navarra, Spain | |||
876569 | 876569 | 2022-03-27 | Spain | Navarra | 229788 | 1512 | 0 | 42.6954 | -1.6761 | 2022-03-28 04:20:33 | Navarra, Spain | |||
880586 | 880586 | 2022-08-05 | Spain | Navarra | 254397 | 1675 | 0 | 42.6954 | -1.6761 | 2022-08-06 04:20:56 | Navarra, Spain | |||
896453 | 896453 | 2022-07-24 | Spain | Navarra | 285575 | 1652 | 0 | 42.6954 | -1.6761 | 2022-07-25 04:20:51 | Navarra, Spain | |||
900469 | 900469 | 2022-07-22 | Spain | Navarra | 285575 | 1652 | 0 | 42.6954 | -1.6761 | 2022-07-23 04:20:53 | Navarra, Spain | |||
904483 | 904483 | 2021-11-24 | Spain | Navarra | 86986 | 1260 | 0 | 42.6954 | -1.6761 | 2021-11-25 04:22:33 | Navarra, Spain | |||
912516 | 912516 | 2022-10-29 | Spain | Navarra | 256042 | 1716 | 0 | 42.6954 | -1.6761 | 2022-10-30 04:22:14 | Navarra, Spain | |||
919989 | 919989 | 2022-03-08 | Spain | Navarra | 224767 | 1502 | 0 | 42.6954 | -1.6761 | 2022-03-09 04:20:59 | Navarra, Spain | |||
935105 | 935105 | 2021-10-16 | Spain | Navarra | 82830 | 1250 | 0 | 42.6954 | -1.6761 | 2021-10-17 04:21:29 | Navarra, Spain | |||
939123 | 939123 | 2022-06-25 | Spain | Navarra | 245405 | 1591 | 0 | 42.6954 | -1.6761 | 2022-06-26 04:21:02 | Navarra, Spain | |||
943138 | 943138 | 2022-02-28 | Spain | Navarra | 222441 | 1491 | 0 | 42.6954 | -1.6761 | 2022-03-01 04:21:09 | Navarra, Spain | |||
947155 | 947155 | 2022-06-14 | Spain | Navarra | 243683 | 1579 | 0 | 42.6954 | -1.6761 | 2022-06-15 04:20:54 | Navarra, Spain | |||
951170 | 951170 | 2022-03-12 | Spain | Navarra | 225674 | 1505 | 0 | 42.6954 | -1.6761 | 2022-03-13 04:20:49 | Navarra, Spain | |||
959201 | 959201 | 2022-07-19 | Spain | Navarra | 251737 | 1627 | 0 | 42.6954 | -1.6761 | 2022-07-20 04:20:59 | Navarra, Spain | |||
963217 | 963217 | 2022-09-09 | Spain | Navarra | 255170 | 1702 | 0 | 42.6954 | -1.6761 | 2022-09-10 04:21:10 | Navarra, Spain | |||
971225 | 971225 | 2022-06-01 | Spain | Navarra | 241887 | 1568 | 0 | 42.6954 | -1.6761 | 2022-06-02 05:20:39 | Navarra, Spain | |||
979253 | 979253 | 2022-02-01 | Spain | Navarra | 209018 | 1420 | 0 | 42.6954 | -1.6761 | 2022-02-02 04:21:09 | Navarra, Spain | |||
987283 | 987283 | 2021-10-04 | Spain | Navarra | 82623 | 1246 | 0 | 42.6954 | -1.6761 | 2021-10-05 04:21:27 | Navarra, Spain | |||
991300 | 991300 | 2022-08-16 | Spain | Navarra | 254750 | 1690 | 0 | 42.6954 | -1.6761 | 2022-08-17 04:20:59 | Navarra, Spain | |||
1014638 | 1014638 | 2021-11-21 | Spain | Navarra | 85762 | 1257 | 0 | 42.6954 | -1.6761 | 2021-11-22 04:22:20 | Navarra, Spain | |||
1018658 | 1018658 | 2022-12-24 | Spain | Navarra | 257097 | 1739 | 0 | 42.6954 | -1.6761 | 2022-12-25 04:21:04 | Navarra, Spain | |||
1022674 | 1022674 | 2022-11-04 | Spain | Navarra | 256126 | 1717 | 0 | 42.6954 | -1.6761 | 2022-11-05 04:21:52 | Navarra, Spain | |||
1030680 | 1030680 | 2021-12-06 | Spain | Navarra | 90457 | 1266 | 0 | 42.6954 | -1.6761 | 2021-12-07 04:22:34 | Navarra, Spain | |||
1050146 | 1050146 | 2022-11-06 | Spain | Navarra | 256126 | 1717 | 0 | 42.6954 | -1.6761 | 2022-11-07 04:21:26 | Navarra, Spain | |||
1058154 | 1058154 | 2022-02-23 | Spain | Navarra | 221838 | 1490 | 0 | 42.6954 | -1.6761 | 2022-02-24 04:21:14 | Navarra, Spain | |||
1066183 | 1066183 | 2022-07-28 | Spain | Navarra | 253244 | 1646 | 0 | 42.6954 | -1.6761 | 2022-07-29 04:20:45 | Navarra, Spain | |||
1070199 | 1070199 | 2022-08-07 | Spain | Navarra | 254397 | 1675 | 0 | 42.6954 | -1.6761 | 2022-08-08 04:21:08 | Navarra, Spain | |||
1074217 | 1074217 | 2022-12-28 | Spain | Navarra | 257097 | 1739 | 0 | 42.6954 | -1.6761 | 2022-12-29 04:21:01 | Navarra, Spain | |||
1078229 | 1078229 | 2021-12-09 | Spain | Navarra | 93654 | 1268 | 0 | 42.6954 | -1.6761 | 2021-12-10 04:22:28 | Navarra, Spain | |||
1086381 | 1086381 | 2022-08-09 | Spain | Navarra | 254551 | 1681 | 0 | 42.6954 | -1.6761 | 2022-08-10 04:20:57 | Navarra, Spain | |||
1098424 | 1098424 | 2022-08-03 | Spain | Navarra | 254045 | 1658 | 0 | 42.6954 | -1.6761 | 2022-08-04 04:20:58 | Navarra, Spain | |||
1109880 | 1109880 | 2022-05-21 | Spain | Navarra | 240528 | 1562 | 0 | 42.6954 | -1.6761 | 2022-05-22 04:20:52 | Navarra, Spain | |||
1113894 | 1113894 | 2022-01-11 | Spain | Navarra | 165110 | 1324 | 0 | 42.6954 | -1.6761 | 2022-01-12 04:21:44 | Navarra, Spain | |||
1117893 | 1117893 | 2021-08-06 | Spain | Navarra | 77812 | 1195 | 0 | 42.6954 | -1.6761 | 2021-08-07 04:21:30 | Navarra, Spain | |||
1141217 | 1141217 | 2022-01-23 | Spain | Navarra | 190994 | 1370 | 0 | 42.6954 | -1.6761 | 2022-01-24 04:21:12 | Navarra, Spain | |||
1145233 | 1145233 | 2021-12-01 | Spain | Navarra | 89324 | 1264 | 0 | 42.6954 | -1.6761 | 2021-12-02 04:22:37 | Navarra, Spain | |||
1149253 | 1149253 | 2022-12-12 | Spain | Navarra | 256691 | 1730 | 0 | 42.6954 | -1.6761 | 2022-12-13 04:21:01 | Navarra, Spain | |||
1157457 | 1157457 | 2022-04-29 | Spain | Navarra | 240920 | 1544 | 0 | 42.6954 | -1.6761 | 2022-04-30 04:21:05 | Navarra, Spain | |||
1161474 | 1161474 | 2022-08-18 | Spain | Navarra | 254750 | 1690 | 0 | 42.6954 | -1.6761 | 2022-08-19 04:20:54 | Navarra, Spain | |||
1169504 | 1169504 | 2022-05-20 | Spain | Navarra | 239819 | 1561 | 0 | 42.6954 | -1.6761 | 2022-05-21 04:20:58 | Navarra, Spain | |||
1185051 | 1185051 | 2022-05-18 | Spain | Navarra | 239819 | 1561 | 0 | 42.6954 | -1.6761 | 2022-05-19 04:20:54 | Navarra, Spain | |||
1200113 | 1200113 | 2022-07-06 | Spain | Navarra | 247939 | 1603 | 0 | 42.6954 | -1.6761 | 2022-07-07 04:20:55 | Navarra, Spain | |||
1211858 | 1211858 | 2022-07-11 | Spain | Navarra | 248707 | 1607 | 0 | 42.6954 | -1.6761 | 2022-07-12 04:20:51 | Navarra, Spain | |||
1215872 | 1215872 | 2022-01-08 | Spain | Navarra | 152302 | 1310 | 0 | 42.6954 | -1.6761 | 2022-01-09 04:21:46 | Navarra, Spain | |||
1223903 | 1223903 | 2022-04-14 | Spain | Navarra | 233989 | 1522 | 0 | 42.6954 | -1.6761 | 2022-04-15 04:20:57 | Navarra, Spain | |||
1227918 | 1227918 | 2022-01-24 | Spain | Navarra | 195469 | 1379 | 0 | 42.6954 | -1.6761 | 2022-01-25 04:21:05 | Navarra, Spain | |||
1231934 | 1231934 | 2021-11-28 | Spain | Navarra | 87702 | 1262 | 0 | 42.6954 | -1.6761 | 2021-11-29 04:22:30 | Navarra, Spain | |||
1235950 | 1235950 | 2021-09-27 | Spain | Navarra | 82454 | 1244 | 0 | 42.6954 | -1.6761 | 2021-09-28 04:21:28 | Navarra, Spain | |||
1239969 | 1239969 | 2022-11-28 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-11-29 04:21:05 | Navarra, Spain | |||
1251063 | 1251063 | 2022-08-23 | Spain | Navarra | 254903 | 1696 | 0 | 42.6954 | -1.6761 | 2022-08-24 04:20:46 | Navarra, Spain | |||
1255077 | 1255077 | 2021-12-20 | Spain | Navarra | 101316 | 1278 | 0 | 42.6954 | -1.6761 | 2021-12-21 03:21:27 | Navarra, Spain | |||
1259093 | 1259093 | 2021-12-18 | Spain | Navarra | 99552 | 1273 | 0 | 42.6954 | -1.6761 | 2021-12-19 04:21:11 | Navarra, Spain | |||
1263092 | 1263092 | 2021-09-09 | Spain | Navarra | 81957 | 1231 | 0 | 42.6954 | -1.6761 | 2021-09-10 04:21:20 | Navarra, Spain | |||
1274593 | 1274593 | 2021-10-03 | Spain | Navarra | 82553 | 1246 | 0 | 42.6954 | -1.6761 | 2021-10-04 04:21:31 | Navarra, Spain | |||
1282294 | 1282294 | 2022-01-05 | Spain | Navarra | 146350 | 1309 | 0 | 42.6954 | -1.6761 | 2022-01-06 04:22:09 | Navarra, Spain | |||
1286310 | 1286310 | 2022-01-04 | Spain | Navarra | 142069 | 1307 | 0 | 42.6954 | -1.6761 | 2022-01-05 04:21:59 | Navarra, Spain | |||
1294340 | 1294340 | 2022-02-05 | Spain | Navarra | 211932 | 1426 | 0 | 42.6954 | -1.6761 | 2022-02-06 04:21:00 | Navarra, Spain | |||
1298357 | 1298357 | 2022-02-17 | Spain | Navarra | 220156 | 1477 | 0 | 42.6954 | -1.6761 | 2022-02-18 04:21:04 | Navarra, Spain | |||
1314505 | 1314505 | 2022-05-27 | Spain | Navarra | 241495 | 1564 | 0 | 42.6954 | -1.6761 | 2022-05-28 04:21:07 | Navarra, Spain | |||
1318519 | 1318519 | 2022-01-26 | Spain | Navarra | 199976 | 1391 | 0 | 42.6954 | -1.6761 | 2022-01-27 04:21:19 | Navarra, Spain | |||
1322535 | 1322535 | 2021-11-14 | Spain | Navarra | 84397 | 1256 | 0 | 42.6954 | -1.6761 | 2021-11-15 04:21:36 | Navarra, Spain | |||
1326552 | 1326552 | 2022-04-26 | Spain | Navarra | 238893 | 1534 | 0 | 42.6954 | -1.6761 | 2022-04-27 04:20:52 | Navarra, Spain | |||
1334581 | 1334581 | 2021-09-28 | Spain | Navarra | 82480 | 1245 | 0 | 42.6954 | -1.6761 | 2021-09-29 04:21:45 | Navarra, Spain | |||
1342593 | 1342593 | 2021-08-11 | Spain | Navarra | 78832 | 1199 | 0 | 42.6954 | -1.6761 | 2021-08-12 04:21:25 | Navarra, Spain | |||
1346626 | 1346626 | 2022-08-10 | Spain | Navarra | 254551 | 1681 | 0 | 42.6954 | -1.6761 | 2022-08-11 04:20:49 | Navarra, Spain | |||
1358641 | 1358641 | 2021-11-27 | Spain | Navarra | 87702 | 1262 | 0 | 42.6954 | -1.6761 | 2021-11-28 04:22:43 | Navarra, Spain | |||
1362657 | 1362657 | 2022-02-08 | Spain | Navarra | 215791 | 1438 | 0 | 42.6954 | -1.6761 | 2022-02-09 04:21:04 | Navarra, Spain | |||
1366785 | 1366785 | 2022-10-28 | Spain | Navarra | 256042 | 1716 | 0 | 42.6954 | -1.6761 | 2022-10-29 04:21:13 | Navarra, Spain | |||
1370801 | 1370801 | 2022-09-21 | Spain | Navarra | 255317 | 1705 | 0 | 42.6954 | -1.6761 | 2022-09-22 04:22:56 | Navarra, Spain | |||
1374796 | 1374796 | 2021-09-15 | Spain | Navarra | 82211 | 1234 | 0 | 42.6954 | -1.6761 | 2021-09-16 04:22:19 | Navarra, Spain | |||
1385934 | 1385934 | 2021-09-13 | Spain | Navarra | 82144 | 1232 | 0 | 42.6954 | -1.6761 | 2021-09-14 04:21:41 | Navarra, Spain | |||
1389965 | 1389965 | 2022-01-07 | Spain | Navarra | 152302 | 1310 | 0 | 42.6954 | -1.6761 | 2022-01-08 04:21:53 | Navarra, Spain | |||
1393983 | 1393983 | 2022-09-02 | Spain | Navarra | 255096 | 1701 | 0 | 42.6954 | -1.6761 | 2022-09-03 04:21:04 | Navarra, Spain | |||
1397998 | 1397998 | 2022-05-06 | Spain | Navarra | 244882 | 1547 | 0 | 42.6954 | -1.6761 | 2022-05-07 04:21:09 | Navarra, Spain | |||
1405349 | 1405349 | 2022-08-02 | Spain | Navarra | 254045 | 1658 | 0 | 42.6954 | -1.6761 | 2022-08-03 04:20:59 | Navarra, Spain | |||
1417393 | 1417393 | 2022-07-08 | Spain | Navarra | 248707 | 1607 | 0 | 42.6954 | -1.6761 | 2022-07-09 04:20:59 | Navarra, Spain | |||
1421409 | 1421409 | 2022-06-08 | Spain | Navarra | 242858 | 1574 | 0 | 42.6954 | -1.6761 | 2022-06-09 04:20:54 | Navarra, Spain | |||
1432871 | 1432871 | 2021-12-28 | Spain | Navarra | 115366 | 1294 | 0 | 42.6954 | -1.6761 | 2021-12-29 03:21:43 | Navarra, Spain | |||
1436888 | 1436888 | 2022-03-28 | Spain | Navarra | 229788 | 1512 | 0 | 42.6954 | -1.6761 | 2022-03-29 04:20:46 | Navarra, Spain | |||
1464389 | 1464389 | 2022-02-10 | Spain | Navarra | 217101 | 1448 | 0 | 42.6954 | -1.6761 | 2022-02-11 04:21:09 | Navarra, Spain | |||
1468405 | 1468405 | 2022-03-24 | Spain | Navarra | 228522 | 1511 | 0 | 42.6954 | -1.6761 | 2022-03-25 04:20:46 | Navarra, Spain | |||
1472420 | 1472420 | 2022-01-17 | Spain | Navarra | 179838 | 1348 | 0 | 42.6954 | -1.6761 | 2022-01-18 04:21:04 | Navarra, Spain | |||
1483859 | 1483859 | 2021-08-13 | Spain | Navarra | 79288 | 1201 | 0 | 42.6954 | -1.6761 | 2021-08-14 04:21:25 | Navarra, Spain | |||
1487892 | 1487892 | 2022-07-26 | Spain | Navarra | 253244 | 1646 | 0 | 42.6954 | -1.6761 | 2022-07-27 04:21:04 | Navarra, Spain | |||
1491906 | 1491906 | 2021-10-12 | Spain | Navarra | 82742 | 1248 | 0 | 42.6954 | -1.6761 | 2021-10-13 04:20:51 | Navarra, Spain | |||
1503905 | 1503905 | 2022-05-16 | Spain | Navarra | 239219 | 1554 | 0 | 42.6954 | -1.6761 | 2022-05-17 04:20:59 | Navarra, 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]);