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)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
634 | 634 | 2021-12-02 | Spain | Navarra | 89954 | 1264 | 0 | 42.6954 | -1.6761 | 2021-12-03 04:23:05 | Navarra, Spain | |||
4650 | 4650 | 2021-10-28 | Spain | Navarra | 83298 | 1252 | 0 | 42.6954 | -1.6761 | 2021-10-29 04:22:03 | Navarra, Spain | |||
16658 | 16658 | 2021-09-18 | Spain | Navarra | 82288 | 1236 | 0 | 42.6954 | -1.6761 | 2021-09-19 04:21:34 | Navarra, Spain | |||
24705 | 24705 | 2022-03-20 | Spain | Navarra | 227371 | 1510 | 0 | 42.6954 | -1.6761 | 2022-03-21 04:20:50 | Navarra, Spain | |||
28720 | 28720 | 2021-11-11 | Spain | Navarra | 84270 | 1255 | 0 | 42.6954 | -1.6761 | 2021-11-12 04:22:01 | Navarra, Spain | |||
32719 | 32719 | 2021-08-25 | Spain | Navarra | 80900 | 1213 | 0 | 42.6954 | -1.6761 | 2021-08-26 04:21:28 | Navarra, Spain | |||
44012 | 44012 | 2021-11-02 | Spain | Navarra | 83516 | 1253 | 0 | 42.6954 | -1.6761 | 2021-11-03 06:22:09 | Navarra, Spain | |||
63369 | 63369 | 2022-11-12 | Spain | Navarra | 256203 | 1720 | 0 | 42.6954 | -1.6761 | 2022-11-13 04:21:14 | Navarra, Spain | |||
67364 | 67364 | 2021-09-01 | Spain | Navarra | 81531 | 1226 | 0 | 42.6954 | -1.6761 | 2021-09-02 04:21:15 | Navarra, Spain | |||
71395 | 71395 | 2022-02-07 | Spain | Navarra | 214807 | 1434 | 0 | 42.6954 | -1.6761 | 2022-02-08 04:21:15 | Navarra, Spain | |||
87429 | 87429 | 2021-11-09 | Spain | Navarra | 83931 | 1254 | 0 | 42.6954 | -1.6761 | 2021-11-10 04:21:38 | Navarra, Spain | |||
91447 | 91447 | 2022-07-23 | Spain | Navarra | 285575 | 1652 | 0 | 42.6954 | -1.6761 | 2022-07-24 04:20:47 | Navarra, Spain | |||
99630 | 99630 | 2022-01-14 | Spain | Navarra | 174614 | 1335 | 0 | 42.6954 | -1.6761 | 2022-01-15 04:21:07 | Navarra, Spain | |||
103629 | 103629 | 2021-08-15 | Spain | Navarra | 79288 | 1201 | 0 | 42.6954 | -1.6761 | 2021-08-16 04:21:31 | Navarra, Spain | |||
115057 | 115057 | 2022-09-06 | Spain | Navarra | 255134 | 1702 | 0 | 42.6954 | -1.6761 | 2022-09-07 04:20:59 | Navarra, Spain | |||
127037 | 127037 | 2022-01-09 | Spain | Navarra | 152302 | 1310 | 0 | 42.6954 | -1.6761 | 2022-01-10 04:22:07 | Navarra, Spain | |||
131057 | 131057 | 2022-10-04 | Spain | Navarra | 255565 | 1710 | 0 | 42.6954 | -1.6761 | 2022-10-05 04:23:06 | Navarra, Spain | |||
138275 | 138275 | 2021-12-04 | Spain | Navarra | 90457 | 1266 | 0 | 42.6954 | -1.6761 | 2021-12-05 04:22:25 | Navarra, Spain | |||
142293 | 142293 | 2022-07-09 | Spain | Navarra | 248707 | 1607 | 0 | 42.6954 | -1.6761 | 2022-07-10 04:20:54 | Navarra, Spain | |||
150288 | 150288 | 2021-11-29 | Spain | Navarra | 88613 | 1263 | 0 | 42.6954 | -1.6761 | 2021-11-30 04:22:53 | Navarra, Spain | |||
158317 | 158317 | 2022-03-29 | Spain | Navarra | 230735 | 1512 | 0 | 42.6954 | -1.6761 | 2022-03-30 04:20:45 | Navarra, Spain | |||
162332 | 162332 | 2021-11-19 | Spain | Navarra | 85762 | 1257 | 0 | 42.6954 | -1.6761 | 2021-11-20 04:22:17 | Navarra, Spain | |||
166350 | 166350 | 2022-06-21 | Spain | Navarra | 244654 | 1586 | 0 | 42.6954 | -1.6761 | 2022-06-22 04:20:54 | Navarra, Spain | |||
178329 | 178329 | 2021-09-02 | Spain | Navarra | 81637 | 1227 | 0 | 42.6954 | -1.6761 | 2021-09-03 04:21:20 | Navarra, Spain | |||
186375 | 186375 | 2022-02-13 | Spain | Navarra | 217689 | 1457 | 0 | 42.6954 | -1.6761 | 2022-02-14 04:20:51 | Navarra, Spain | |||
198566 | 198566 | 2022-10-19 | Spain | Navarra | 255777 | 1713 | 0 | 42.6954 | -1.6761 | 2022-10-20 04:22:59 | Navarra, Spain | |||
218287 | 218287 | 2022-12-26 | Spain | Navarra | 257097 | 1739 | 0 | 42.6954 | -1.6761 | 2022-12-27 04:21:07 | Navarra, Spain | |||
222300 | 222300 | 2022-05-09 | Spain | Navarra | 238253 | 1548 | 0 | 42.6954 | -1.6761 | 2022-05-10 04:20:50 | Navarra, Spain | |||
229532 | 229532 | 2022-05-31 | Spain | Navarra | 241495 | 1564 | 0 | 42.6954 | -1.6761 | 2022-06-01 04:20:55 | Navarra, Spain | |||
233547 | 233547 | 2022-02-11 | Spain | Navarra | 217689 | 1457 | 0 | 42.6954 | -1.6761 | 2022-02-12 04:21:06 | Navarra, Spain | |||
245572 | 245572 | 2021-08-17 | Spain | Navarra | 79922 | 1204 | 0 | 42.6954 | -1.6761 | 2021-08-18 04:21:35 | Navarra, Spain | |||
249586 | 249586 | 2021-09-04 | Spain | Navarra | 81705 | 1227 | 0 | 42.6954 | -1.6761 | 2021-09-05 04:21:33 | Navarra, Spain | |||
253619 | 253619 | 2022-09-08 | Spain | Navarra | 255134 | 1702 | 0 | 42.6954 | -1.6761 | 2022-09-09 04:21:11 | Navarra, Spain | |||
257637 | 257637 | 2022-12-10 | Spain | Navarra | 256691 | 1730 | 0 | 42.6954 | -1.6761 | 2022-12-11 04:20:50 | Navarra, Spain | |||
261837 | 261837 | 2022-03-15 | Spain | Navarra | 226199 | 1507 | 0 | 42.6954 | -1.6761 | 2022-03-16 04:20:50 | Navarra, Spain | |||
276487 | 276487 | 2021-11-03 | Spain | Navarra | 83564 | 1253 | 0 | 42.6954 | -1.6761 | 2021-11-04 04:22:20 | Navarra, Spain | |||
288300 | 288300 | 2021-10-31 | Spain | Navarra | 83350 | 1252 | 0 | 42.6954 | -1.6761 | 2021-11-01 04:22:01 | Navarra, Spain | |||
292320 | 292320 | 2022-11-15 | Spain | Navarra | 256203 | 1720 | 0 | 42.6954 | -1.6761 | 2022-11-16 04:21:09 | Navarra, Spain | |||
304173 | 304173 | 2022-04-16 | Spain | Navarra | 233989 | 1522 | 0 | 42.6954 | -1.6761 | 2022-04-17 04:20:59 | Navarra, Spain | |||
308192 | 308192 | 2022-12-13 | Spain | Navarra | 256691 | 1730 | 0 | 42.6954 | -1.6761 | 2022-12-14 04:21:04 | Navarra, Spain | |||
312208 | 312208 | 2022-11-13 | Spain | Navarra | 256203 | 1720 | 0 | 42.6954 | -1.6761 | 2022-11-14 04:21:09 | Navarra, Spain | |||
316221 | 316221 | 2022-02-12 | Spain | Navarra | 217689 | 1457 | 0 | 42.6954 | -1.6761 | 2022-02-13 04:21:00 | Navarra, Spain | |||
320240 | 320240 | 2022-10-30 | Spain | Navarra | 256042 | 1716 | 0 | 42.6954 | -1.6761 | 2022-10-31 04:21:36 | Navarra, Spain | |||
328214 | 328214 | 2022-12-27 | Spain | Navarra | 257097 | 1739 | 0 | 42.6954 | -1.6761 | 2022-12-28 04:21:04 | Navarra, Spain | |||
336241 | 336241 | 2022-03-18 | Spain | Navarra | 227371 | 1510 | 0 | 42.6954 | -1.6761 | 2022-03-19 04:20:47 | Navarra, Spain | |||
348604 | 348604 | 2022-12-14 | Spain | Navarra | 256691 | 1730 | 0 | 42.6954 | -1.6761 | 2022-12-15 04:20:58 | Navarra, Spain | |||
356631 | 356631 | 2022-03-11 | Spain | Navarra | 225674 | 1505 | 0 | 42.6954 | -1.6761 | 2022-03-12 04:20:50 | Navarra, Spain | |||
360647 | 360647 | 2022-05-07 | Spain | Navarra | 244882 | 1547 | 0 | 42.6954 | -1.6761 | 2022-05-08 04:20:49 | Navarra, Spain | |||
372504 | 372504 | 2022-09-13 | Spain | Navarra | 255211 | 1703 | 0 | 42.6954 | -1.6761 | 2022-09-14 04:20:44 | Navarra, Spain | |||
384531 | 384531 | 2022-09-23 | Spain | Navarra | 255364 | 1706 | 0 | 42.6954 | -1.6761 | 2022-09-24 04:21:40 | Navarra, Spain | |||
396572 | 396572 | 2022-10-07 | Spain | Navarra | 255640 | 1711 | 0 | 42.6954 | -1.6761 | 2022-10-08 04:22:56 | Navarra, Spain | |||
404598 | 404598 | 2021-12-07 | Spain | Navarra | 92488 | 1267 | 0 | 42.6954 | -1.6761 | 2021-12-08 04:22:46 | Navarra, Spain | |||
419643 | 419643 | 2022-09-18 | Spain | Navarra | 255271 | 1703 | 0 | 42.6954 | -1.6761 | 2022-09-19 04:21:49 | Navarra, Spain | |||
423655 | 423655 | 2021-10-10 | Spain | Navarra | 82678 | 1248 | 0 | 42.6954 | -1.6761 | 2021-10-11 04:21:31 | Navarra, Spain | |||
431665 | 431665 | 2022-11-03 | Spain | Navarra | 256042 | 1716 | 0 | 42.6954 | -1.6761 | 2022-11-04 04:22:11 | Navarra, Spain | |||
443659 | 443659 | 2021-10-20 | Spain | Navarra | 83010 | 1251 | 0 | 42.6954 | -1.6761 | 2021-10-21 04:21:18 | Navarra, Spain | |||
447675 | 447675 | 2021-11-17 | Spain | Navarra | 85201 | 1256 | 0 | 42.6954 | -1.6761 | 2021-11-18 04:21:33 | Navarra, Spain | |||
451695 | 451695 | 2022-12-21 | Spain | Navarra | 256858 | 1736 | 0 | 42.6954 | -1.6761 | 2022-12-22 04:20:56 | Navarra, Spain | |||
459684 | 459684 | 2022-02-02 | Spain | Navarra | 210433 | 1420 | 0 | 42.6954 | -1.6761 | 2022-02-03 04:21:21 | Navarra, Spain | |||
463701 | 463701 | 2022-05-02 | Spain | Navarra | 240920 | 1544 | 0 | 42.6954 | -1.6761 | 2022-05-03 04:21:00 | Navarra, Spain | |||
467716 | 467716 | 2021-10-07 | Spain | Navarra | 82657 | 1247 | 0 | 42.6954 | -1.6761 | 2021-10-08 04:21:25 | Navarra, Spain | |||
475748 | 475748 | 2022-06-26 | Spain | Navarra | 245405 | 1591 | 0 | 42.6954 | -1.6761 | 2022-06-27 04:21:00 | Navarra, Spain | |||
479898 | 479898 | 2022-11-08 | Spain | Navarra | 256126 | 1717 | 0 | 42.6954 | -1.6761 | 2022-11-09 04:21:22 | Navarra, Spain | |||
487928 | 487928 | 2022-11-25 | Spain | Navarra | 256433 | 1723 | 0 | 42.6954 | -1.6761 | 2022-11-26 04:21:11 | Navarra, Spain | |||
491940 | 491940 | 2021-10-14 | Spain | Navarra | 82805 | 1249 | 0 | 42.6954 | -1.6761 | 2021-10-15 04:21:26 | Navarra, Spain | |||
495956 | 495956 | 2021-11-06 | Spain | Navarra | 83702 | 1253 | 0 | 42.6954 | -1.6761 | 2021-11-07 04:21:53 | Navarra, Spain | |||
499973 | 499973 | 2022-04-02 | Spain | Navarra | 231526 | 1515 | 0 | 42.6954 | -1.6761 | 2022-04-03 04:20:48 | Navarra, Spain | |||
503992 | 503992 | 2022-12-17 | Spain | Navarra | 256858 | 1736 | 0 | 42.6954 | -1.6761 | 2022-12-18 04:21:03 | Navarra, Spain | |||
507987 | 507987 | 2021-08-14 | Spain | Navarra | 79288 | 1201 | 0 | 42.6954 | -1.6761 | 2021-08-15 04:21:41 | Navarra, Spain | |||
512001 | 512001 | 2021-08-19 | Spain | Navarra | 80227 | 1204 | 0 | 42.6954 | -1.6761 | 2021-08-20 04:21:33 | Navarra, Spain | |||
516036 | 516036 | 2022-10-15 | Spain | Navarra | 255777 | 1713 | 0 | 42.6954 | -1.6761 | 2022-10-16 04:22:39 | Navarra, Spain | |||
535040 | 535040 | 2021-10-27 | Spain | Navarra | 83260 | 1252 | 0 | 42.6954 | -1.6761 | 2021-10-28 04:22:08 | Navarra, Spain | |||
539060 | 539060 | 2022-10-26 | Spain | Navarra | 255923 | 1714 | 0 | 42.6954 | -1.6761 | 2022-10-27 04:22:01 | Navarra, Spain | |||
543076 | 543076 | 2022-12-15 | Spain | Navarra | 256691 | 1730 | 0 | 42.6954 | -1.6761 | 2022-12-16 04:21:01 | Navarra, Spain | |||
551078 | 551078 | 2021-12-08 | Spain | Navarra | 92488 | 1267 | 0 | 42.6954 | -1.6761 | 2021-12-09 04:22:49 | Navarra, Spain | |||
555094 | 555094 | 2022-01-16 | Spain | Navarra | 174614 | 1335 | 0 | 42.6954 | -1.6761 | 2022-01-17 04:21:08 | Navarra, Spain | |||
559112 | 559112 | 2022-06-16 | Spain | Navarra | 243683 | 1579 | 0 | 42.6954 | -1.6761 | 2022-06-17 04:20:56 | Navarra, Spain | |||
567408 | 567408 | 2021-10-29 | Spain | Navarra | 83350 | 1252 | 0 | 42.6954 | -1.6761 | 2021-10-30 04:22:03 | Navarra, Spain | |||
575137 | 575137 | 2022-02-25 | Spain | Navarra | 222441 | 1491 | 0 | 42.6954 | -1.6761 | 2022-02-26 04:21:12 | Navarra, Spain | |||
589931 | 589931 | 2021-08-08 | Spain | Navarra | 77812 | 1195 | 0 | 42.6954 | -1.6761 | 2021-08-09 04:21:24 | Navarra, Spain | |||
593964 | 593964 | 2022-07-01 | Spain | Navarra | 247057 | 1595 | 0 | 42.6954 | -1.6761 | 2022-07-02 04:21:16 | Navarra, Spain | |||
597978 | 597978 | 2021-10-19 | Spain | Navarra | 82968 | 1251 | 0 | 42.6954 | -1.6761 | 2021-10-20 04:21:00 | Navarra, Spain | |||
601994 | 601994 | 2021-09-23 | Spain | Navarra | 82420 | 1244 | 0 | 42.6954 | -1.6761 | 2021-09-24 04:21:44 | Navarra, Spain | |||
618170 | 618170 | 2022-11-05 | Spain | Navarra | 256126 | 1717 | 0 | 42.6954 | -1.6761 | 2022-11-06 04:21:24 | Navarra, Spain | |||
622184 | 622184 | 2022-05-22 | Spain | Navarra | 240528 | 1562 | 0 | 42.6954 | -1.6761 | 2022-05-26 04:20:50 | Navarra, Spain | |||
630214 | 630214 | 2022-07-12 | Spain | Navarra | 249679 | 1612 | 0 | 42.6954 | -1.6761 | 2022-07-13 04:20:58 | Navarra, Spain | |||
634228 | 634228 | 2021-10-13 | Spain | Navarra | 82786 | 1248 | 0 | 42.6954 | -1.6761 | 2021-10-14 04:21:29 | Navarra, Spain | |||
642241 | 642241 | 2021-09-07 | Spain | Navarra | 81834 | 1230 | 0 | 42.6954 | -1.6761 | 2021-09-08 04:21:31 | Navarra, Spain | |||
650269 | 650269 | 2021-08-09 | Spain | Navarra | 78417 | 1196 | 0 | 42.6954 | -1.6761 | 2021-08-10 04:21:27 | Navarra, Spain | |||
654300 | 654300 | 2021-10-22 | Spain | Navarra | 83082 | 1251 | 0 | 42.6954 | -1.6761 | 2021-10-23 04:21:32 | Navarra, Spain | |||
658619 | 658619 | 2022-05-13 | Spain | Navarra | 239219 | 1554 | 0 | 42.6954 | -1.6761 | 2022-05-14 04:20:48 | Navarra, Spain | |||
670605 | 670605 | 2022-07-21 | Spain | Navarra | 251737 | 1627 | 0 | 42.6954 | -1.6761 | 2022-07-22 04:21:15 | Navarra, Spain | |||
674621 | 674621 | 2022-07-30 | Spain | Navarra | 253631 | 1654 | 0 | 42.6954 | -1.6761 | 2022-07-31 04:21:02 | Navarra, Spain | |||
682645 | 682645 | 2021-10-24 | Spain | Navarra | 83082 | 1251 | 0 | 42.6954 | -1.6761 | 2021-10-25 04:22:31 | Navarra, Spain | |||
686661 | 686661 | 2021-11-13 | Spain | Navarra | 84397 | 1256 | 0 | 42.6954 | -1.6761 | 2021-11-14 04:21:31 | Navarra, Spain | |||
690681 | 690681 | 2022-12-23 | Spain | Navarra | 257097 | 1739 | 0 | 42.6954 | -1.6761 | 2022-12-24 04:21:02 | Navarra, Spain | |||
694694 | 694694 | 2022-03-17 | Spain | Navarra | 226199 | 1507 | 0 | 42.6954 | -1.6761 | 2022-03-18 04:20:55 | Navarra, Spain | |||
698709 | 698709 | 2021-11-04 | Spain | Navarra | 83626 | 1253 | 0 | 42.6954 | -1.6761 | 2021-11-05 04:21:54 | Navarra, Spain | |||
706739 | 706739 | 2021-09-29 | Spain | Navarra | 82507 | 1246 | 0 | 42.6954 | -1.6761 | 2021-09-30 04:21:20 | Navarra, Spain | |||
710758 | 710758 | 2022-11-01 | Spain | Navarra | 256042 | 1716 | 0 | 42.6954 | -1.6761 | 2022-11-02 04:22:09 | 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]);