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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2625140 | 2625140 | 2020-06-25 | Spain | Navarra | 5426 | 528 | 3905 | 993 | 42.6954 | -1.6761 | 2020-06-26 04:33:43 | Navarra, Spain | ||
2700780 | 2700780 | 2020-06-24 | Spain | Navarra | 5426 | 528 | 3905 | 993 | 42.6954 | -1.6761 | 2020-06-25 05:26:54 | Navarra, Spain | ||
1522465 | 1522465 | 2020-06-23 | Spain | Navarra | 5415 | 528 | 3905 | 982 | 42.6954 | -1.6761 | 2020-06-24 04:33:28 | Navarra, Spain | ||
1829543 | 1829543 | 2020-05-16 | Spain | Navarra | 5137 | 501 | 3658 | 978 | 42.6954 | -1.6761 | 2020-05-17 02:32:32 | Navarra, Spain | ||
3416309 | 3416309 | 2020-05-17 | Spain | Navarra | 5137 | 501 | 3658 | 978 | 42.6954 | -1.6761 | 2020-05-18 02:32:21 | Navarra, Spain | ||
2455067 | 2455067 | 2020-09-19 | Spain | Navarra | 14205 | 553 | 3905 | 9747 | 42.6954 | -1.6761 | 2020-09-20 04:22:00 | Navarra, Spain | ||
2849136 | 2849136 | 2020-09-18 | Spain | Navarra | 14205 | 553 | 3905 | 9747 | 42.6954 | -1.6761 | 2020-09-19 04:22:00 | Navarra, Spain | ||
3093717 | 3093717 | 2020-09-20 | Spain | Navarra | 14205 | 553 | 3905 | 9747 | 42.6954 | -1.6761 | 2020-09-21 04:23:00 | Navarra, Spain | ||
1510659 | 1510659 | 2020-06-22 | Spain | Navarra | 5402 | 528 | 3905 | 969 | 42.6954 | -1.6761 | 2020-06-23 04:33:22 | Navarra, Spain | ||
3682718 | 3682718 | 2020-06-18 | Spain | Navarra | 5364 | 490 | 3905 | 969 | 42.6954 | -1.6761 | 2020-06-19 04:33:17 | Navarra, Spain | ||
1195921 | 1195921 | 2020-06-17 | Spain | Navarra | 5359 | 490 | 3905 | 964 | 42.6954 | -1.6761 | 2020-06-18 04:33:18 | Navarra, Spain | ||
1121885 | 1121885 | 2020-09-17 | Spain | Navarra | 13936 | 550 | 3905 | 9481 | 42.6954 | -1.6761 | 2020-09-18 05:05:00 | Navarra, Spain | ||
3249398 | 3249398 | 2020-06-21 | Spain | Navarra | 5381 | 528 | 3905 | 948 | 42.6954 | -1.6761 | 2020-06-22 04:33:20 | Navarra, Spain | ||
2437991 | 2437991 | 2020-06-20 | Spain | Navarra | 5378 | 528 | 3905 | 945 | 42.6954 | -1.6761 | 2020-06-21 04:33:19 | Navarra, Spain | ||
1691569 | 1691569 | 2020-06-19 | Spain | Navarra | 5370 | 528 | 3905 | 937 | 42.6954 | -1.6761 | 2020-06-20 04:33:19 | Navarra, Spain | ||
666574 | 666574 | 2020-09-16 | Spain | Navarra | 13709 | 549 | 3905 | 9255 | 42.6954 | -1.6761 | 2020-09-17 04:22:00 | Navarra, Spain | ||
2386684 | 2386684 | 2020-06-16 | Spain | Navarra | 5312 | 490 | 3905 | 917 | 42.6954 | -1.6761 | 2020-06-17 04:33:21 | Navarra, Spain | ||
287247 | 287247 | 2020-06-15 | Spain | Navarra | 5311 | 490 | 3905 | 916 | 42.6954 | -1.6761 | 2020-06-16 04:33:09 | Navarra, Spain | ||
1837198 | 1837198 | 2020-06-14 | Spain | Navarra | 5311 | 490 | 3905 | 916 | 42.6954 | -1.6761 | 2020-06-15 03:33:14 | Navarra, Spain | ||
3061250 | 3061250 | 2020-06-13 | Spain | Navarra | 5311 | 490 | 3905 | 916 | 42.6954 | -1.6761 | 2020-06-14 03:33:15 | Navarra, Spain | ||
737570 | 737570 | 2020-06-12 | Spain | Navarra | 5308 | 490 | 3905 | 913 | 42.6954 | -1.6761 | 2020-06-13 03:33:14 | Navarra, Spain | ||
1273540 | 1273540 | 2020-06-11 | Spain | Navarra | 5303 | 490 | 3905 | 908 | 42.6954 | -1.6761 | 2020-06-12 05:09:52 | Navarra, Spain | ||
2863983 | 2863983 | 2020-06-10 | Spain | Navarra | 5299 | 490 | 3905 | 904 | 42.6954 | -1.6761 | 2020-06-11 03:33:41 | Navarra, Spain | ||
1210814 | 1210814 | 2020-06-09 | Spain | Navarra | 5295 | 490 | 3905 | 900 | 42.6954 | -1.6761 | 2020-06-10 04:07:00 | Navarra, Spain | ||
217241 | 217241 | 2020-06-08 | Spain | Navarra | 5294 | 490 | 3905 | 899 | 42.6954 | -1.6761 | 2020-06-09 03:33:03 | Navarra, Spain | ||
2729299 | 2729299 | 2020-09-15 | Spain | Navarra | 13407 | 548 | 3905 | 8954 | 42.6954 | -1.6761 | 2020-09-16 04:22:53 | Navarra, Spain | ||
2800037 | 2800037 | 2020-06-07 | Spain | Navarra | 5288 | 490 | 3905 | 893 | 42.6954 | -1.6761 | 2020-06-08 03:33:22 | Navarra, Spain | ||
574093 | 574093 | 2020-06-06 | Spain | Navarra | 5285 | 490 | 3905 | 890 | 42.6954 | -1.6761 | 2020-06-07 03:53:30 | Navarra, Spain | ||
1269790 | 1269790 | 2020-06-05 | Spain | Navarra | 5275 | 490 | 3905 | 880 | 42.6954 | -1.6761 | 2020-06-06 02:33:00 | Navarra, Spain | ||
1281262 | 1281262 | 2020-06-04 | Spain | Navarra | 5265 | 490 | 3905 | 870 | 42.6954 | -1.6761 | 2020-06-05 02:33:06 | Navarra, Spain | ||
3866817 | 3866817 | 2020-06-03 | Spain | Navarra | 5261 | 490 | 3905 | 866 | 42.6954 | -1.6761 | 2020-06-04 02:33:14 | Navarra, Spain | ||
344571 | 344571 | 2020-09-14 | Spain | Navarra | 13104 | 547 | 3905 | 8652 | 42.6954 | -1.6761 | 2020-09-15 03:22:50 | Navarra, Spain | ||
805396 | 805396 | 2020-06-01 | Spain | Navarra | 5259 | 490 | 3905 | 864 | 42.6954 | -1.6761 | 2020-06-02 02:33:08 | Navarra, Spain | ||
2555859 | 2555859 | 2020-06-02 | Spain | Navarra | 5259 | 490 | 3905 | 864 | 42.6954 | -1.6761 | 2020-06-03 02:33:13 | Navarra, Spain | ||
1793980 | 1793980 | 2020-05-31 | Spain | Navarra | 5254 | 490 | 3905 | 859 | 42.6954 | -1.6761 | 2020-06-01 02:32:46 | Navarra, Spain | ||
3638873 | 3638873 | 2020-05-30 | Spain | Navarra | 5247 | 490 | 3905 | 852 | 42.6954 | -1.6761 | 2020-05-31 02:32:45 | Navarra, Spain | ||
1790414 | 1790414 | 2020-05-29 | Spain | Navarra | 5238 | 490 | 3905 | 843 | 42.6954 | -1.6761 | 2020-05-30 02:32:48 | Navarra, Spain | ||
2712293 | 2712293 | 2020-05-28 | Spain | Navarra | 5223 | 490 | 3905 | 828 | 42.6954 | -1.6761 | 2020-05-29 02:32:50 | Navarra, Spain | ||
1041211 | 1041211 | 2020-05-26 | Spain | Navarra | 5199 | 490 | 3905 | 804 | 42.6954 | -1.6761 | 2020-05-27 02:32:31 | Navarra, Spain | ||
2548248 | 2548248 | 2020-05-27 | Spain | Navarra | 5199 | 490 | 3905 | 804 | 42.6954 | -1.6761 | 2020-05-28 02:32:31 | Navarra, Spain | ||
547049 | 547049 | 2020-09-12 | Spain | Navarra | 12232 | 542 | 3905 | 7785 | 42.6954 | -1.6761 | 2020-09-13 04:30:52 | Navarra, Spain | ||
1444878 | 1444878 | 2020-09-11 | Spain | Navarra | 12232 | 542 | 3905 | 7785 | 42.6954 | -1.6761 | 2020-09-12 04:25:05 | Navarra, Spain | ||
2869010 | 2869010 | 2020-09-13 | Spain | Navarra | 12232 | 542 | 3905 | 7785 | 42.6954 | -1.6761 | 2020-09-14 04:26:00 | Navarra, Spain | ||
3260915 | 3260915 | 2020-05-18 | Spain | Navarra | 5178 | 503 | 3905 | 770 | 42.6954 | -1.6761 | 2020-05-19 02:32:18 | Navarra, Spain | ||
332209 | 332209 | 2021-08-04 | Spain | Navarra | 77238 | 1193 | 3905 | 72140 | 42.6954 | -1.6761 | 2021-08-05 04:21:51 | Navarra, Spain | ||
3468480 | 3468480 | 2021-08-03 | Spain | Navarra | 76904 | 1192 | 3905 | 71807 | 42.6954 | -1.6761 | 2021-08-04 04:21:25 | Navarra, Spain | ||
3683754 | 3683754 | 2021-08-02 | Spain | Navarra | 76688 | 1192 | 3905 | 71591 | 42.6954 | -1.6761 | 2021-08-03 04:21:39 | Navarra, Spain | ||
1173479 | 1173479 | 2020-09-10 | Spain | Navarra | 11582 | 540 | 3905 | 7137 | 42.6954 | -1.6761 | 2020-09-11 04:46:23 | Navarra, Spain | ||
2171844 | 2171844 | 2020-09-09 | Spain | Navarra | 11582 | 540 | 3905 | 7137 | 42.6954 | -1.6761 | 2020-09-10 04:29:01 | Navarra, Spain | ||
3015653 | 3015653 | 2021-08-01 | Spain | Navarra | 75750 | 1191 | 3905 | 70654 | 42.6954 | -1.6761 | 2021-08-02 04:21:36 | Navarra, Spain | ||
3296481 | 3296481 | 2021-07-30 | Spain | Navarra | 75750 | 1191 | 3905 | 70654 | 42.6954 | -1.6761 | 2021-07-31 04:21:35 | Navarra, Spain | ||
3904276 | 3904276 | 2021-07-31 | Spain | Navarra | 75750 | 1191 | 3905 | 70654 | 42.6954 | -1.6761 | 2021-08-01 04:21:50 | Navarra, Spain | ||
3385692 | 3385692 | 2021-07-29 | Spain | Navarra | 75360 | 1190 | 3905 | 70265 | 42.6954 | -1.6761 | 2021-07-30 04:21:34 | Navarra, Spain | ||
408597 | 408597 | 2021-07-28 | Spain | Navarra | 74945 | 1188 | 3905 | 69852 | 42.6954 | -1.6761 | 2021-07-29 04:21:33 | Navarra, Spain | ||
1306458 | 1306458 | 2021-07-27 | Spain | Navarra | 74558 | 1188 | 3905 | 69465 | 42.6954 | -1.6761 | 2021-07-28 04:21:39 | Navarra, Spain | ||
1244053 | 1244053 | 2020-09-08 | Spain | Navarra | 11386 | 540 | 3905 | 6941 | 42.6954 | -1.6761 | 2020-09-09 04:28:48 | Navarra, Spain | ||
3218601 | 3218601 | 2021-07-26 | Spain | Navarra | 74203 | 1188 | 3905 | 69110 | 42.6954 | -1.6761 | 2021-07-27 04:21:18 | Navarra, Spain | ||
1330550 | 1330550 | 2021-07-24 | Spain | Navarra | 73039 | 1186 | 3905 | 67948 | 42.6954 | -1.6761 | 2021-07-25 04:22:12 | Navarra, Spain | ||
1378810 | 1378810 | 2021-07-25 | Spain | Navarra | 73039 | 1186 | 3905 | 67948 | 42.6954 | -1.6761 | 2021-07-26 04:21:28 | Navarra, Spain | ||
3137854 | 3137854 | 2021-07-23 | Spain | Navarra | 73039 | 1186 | 3905 | 67948 | 42.6954 | -1.6761 | 2021-07-24 00:21:36 | Navarra, Spain | ||
3476614 | 3476614 | 2021-07-22 | Spain | Navarra | 72577 | 1184 | 3905 | 67488 | 42.6954 | -1.6761 | 2021-07-23 04:21:29 | Navarra, Spain | ||
3331833 | 3331833 | 2021-07-21 | Spain | Navarra | 72098 | 1184 | 3905 | 67009 | 42.6954 | -1.6761 | 2021-07-22 04:21:19 | Navarra, Spain | ||
427632 | 427632 | 2020-09-07 | Spain | Navarra | 11100 | 540 | 3905 | 6655 | 42.6954 | -1.6761 | 2020-09-08 04:28:25 | Navarra, Spain | ||
2371814 | 2371814 | 2021-07-20 | Spain | Navarra | 71622 | 1184 | 3905 | 66533 | 42.6954 | -1.6761 | 2021-07-21 04:21:40 | Navarra, Spain | ||
483893 | 483893 | 2021-07-19 | Spain | Navarra | 71082 | 1184 | 3905 | 65993 | 42.6954 | -1.6761 | 2021-07-20 04:21:48 | Navarra, Spain | ||
2674116 | 2674116 | 2021-07-18 | Spain | Navarra | 69840 | 1184 | 3905 | 64751 | 42.6954 | -1.6761 | 2021-07-19 04:21:24 | Navarra, Spain | ||
2947659 | 2947659 | 2021-07-16 | Spain | Navarra | 69840 | 1184 | 3905 | 64751 | 42.6954 | -1.6761 | 2021-07-17 04:22:22 | Navarra, Spain | ||
3706428 | 3706428 | 2021-07-17 | Spain | Navarra | 69840 | 1184 | 3905 | 64751 | 42.6954 | -1.6761 | 2021-07-18 04:22:07 | Navarra, Spain | ||
296315 | 296315 | 2021-07-15 | Spain | Navarra | 69165 | 1184 | 3905 | 64076 | 42.6954 | -1.6761 | 2021-07-16 04:21:22 | Navarra, Spain | ||
3632260 | 3632260 | 2021-07-14 | Spain | Navarra | 68569 | 1184 | 3905 | 63480 | 42.6954 | -1.6761 | 2021-07-15 04:21:48 | Navarra, Spain | ||
579135 | 579135 | 2021-07-13 | Spain | Navarra | 68051 | 1184 | 3905 | 62962 | 42.6954 | -1.6761 | 2021-07-14 04:21:35 | Navarra, Spain | ||
3741384 | 3741384 | 2021-07-12 | Spain | Navarra | 67461 | 1184 | 3905 | 62372 | 42.6954 | -1.6761 | 2021-07-13 04:21:18 | Navarra, Spain | ||
626181 | 626181 | 2021-07-10 | Spain | Navarra | 66449 | 1184 | 3905 | 61360 | 42.6954 | -1.6761 | 2021-07-11 04:21:43 | Navarra, Spain | ||
829900 | 829900 | 2021-07-09 | Spain | Navarra | 66449 | 1184 | 3905 | 61360 | 42.6954 | -1.6761 | 2021-07-10 04:21:25 | Navarra, Spain | ||
3659897 | 3659897 | 2021-07-11 | Spain | Navarra | 66449 | 1184 | 3905 | 61360 | 42.6954 | -1.6761 | 2021-07-12 04:21:34 | Navarra, Spain | ||
778664 | 778664 | 2021-07-08 | Spain | Navarra | 66175 | 1184 | 3905 | 61086 | 42.6954 | -1.6761 | 2021-07-09 04:21:21 | Navarra, Spain | ||
813872 | 813872 | 2020-09-05 | Spain | Navarra | 10547 | 536 | 3905 | 6106 | 42.6954 | -1.6761 | 2020-09-06 04:28:33 | Navarra, Spain | ||
2662072 | 2662072 | 2020-09-04 | Spain | Navarra | 10547 | 536 | 3905 | 6106 | 42.6954 | -1.6761 | 2020-09-05 04:28:19 | Navarra, Spain | ||
3161917 | 3161917 | 2020-09-06 | Spain | Navarra | 10547 | 536 | 3905 | 6106 | 42.6954 | -1.6761 | 2020-09-07 04:28:30 | Navarra, Spain | ||
1440886 | 1440886 | 2021-07-07 | Spain | Navarra | 65918 | 1184 | 3905 | 60829 | 42.6954 | -1.6761 | 2021-07-08 04:21:26 | Navarra, Spain | ||
2693991 | 2693991 | 2021-07-06 | Spain | Navarra | 65585 | 1184 | 3905 | 60496 | 42.6954 | -1.6761 | 2021-07-07 04:21:20 | Navarra, Spain | ||
1932740 | 1932740 | 2021-07-05 | Spain | Navarra | 65144 | 1184 | 3905 | 60055 | 42.6954 | -1.6761 | 2021-07-06 04:21:32 | Navarra, Spain | ||
1354612 | 1354612 | 2020-09-03 | Spain | Navarra | 10380 | 536 | 3905 | 5939 | 42.6954 | -1.6761 | 2020-09-04 04:28:26 | Navarra, Spain | ||
1165471 | 1165471 | 2021-07-04 | Spain | Navarra | 64133 | 1184 | 3905 | 59044 | 42.6954 | -1.6761 | 2021-07-05 04:21:28 | Navarra, Spain | ||
1495905 | 1495905 | 2021-07-03 | Spain | Navarra | 64133 | 1184 | 3905 | 59044 | 42.6954 | -1.6761 | 2021-07-04 04:21:38 | Navarra, Spain | ||
2072220 | 2072220 | 2021-07-02 | Spain | Navarra | 64133 | 1184 | 3905 | 59044 | 42.6954 | -1.6761 | 2021-07-03 04:21:37 | Navarra, Spain | ||
2765236 | 2765236 | 2021-07-01 | Spain | Navarra | 64012 | 1184 | 3905 | 58923 | 42.6954 | -1.6761 | 2021-07-02 04:21:47 | Navarra, Spain | ||
1893444 | 1893444 | 2021-06-30 | Spain | Navarra | 63945 | 1184 | 3905 | 58856 | 42.6954 | -1.6761 | 2021-07-01 04:21:19 | Navarra, Spain | ||
400567 | 400567 | 2021-06-29 | Spain | Navarra | 63878 | 1184 | 3905 | 58789 | 42.6954 | -1.6761 | 2021-06-30 04:21:41 | Navarra, Spain | ||
3125810 | 3125810 | 2021-06-28 | Spain | Navarra | 63831 | 1184 | 3905 | 58742 | 42.6954 | -1.6761 | 2021-06-29 04:21:28 | Navarra, Spain | ||
1712628 | 1712628 | 2021-06-25 | Spain | Navarra | 63732 | 1184 | 3905 | 58643 | 42.6954 | -1.6761 | 2021-06-26 04:21:43 | Navarra, Spain | ||
2590305 | 2590305 | 2021-06-27 | Spain | Navarra | 63732 | 1184 | 3905 | 58643 | 42.6954 | -1.6761 | 2021-06-28 04:21:29 | Navarra, Spain | ||
3958809 | 3958809 | 2021-06-26 | Spain | Navarra | 63732 | 1184 | 3905 | 58643 | 42.6954 | -1.6761 | 2021-06-27 04:21:39 | Navarra, Spain | ||
2295753 | 2295753 | 2021-06-24 | Spain | Navarra | 63680 | 1182 | 3905 | 58593 | 42.6954 | -1.6761 | 2021-06-25 04:21:33 | Navarra, Spain | ||
2423193 | 2423193 | 2021-06-23 | Spain | Navarra | 63643 | 1181 | 3905 | 58557 | 42.6954 | -1.6761 | 2021-06-24 04:21:55 | Navarra, Spain | ||
563270 | 563270 | 2021-06-22 | Spain | Navarra | 63585 | 1180 | 3905 | 58500 | 42.6954 | -1.6761 | 2021-06-23 04:21:46 | Navarra, Spain | ||
3358972 | 3358972 | 2021-06-21 | Spain | Navarra | 63545 | 1180 | 3905 | 58460 | 42.6954 | -1.6761 | 2021-06-22 04:21:34 | Navarra, Spain | ||
107754 | 107754 | 2021-06-19 | Spain | Navarra | 63423 | 1179 | 3905 | 58339 | 42.6954 | -1.6761 | 2021-06-20 04:21:48 | Navarra, Spain | ||
1125897 | 1125897 | 2021-06-18 | Spain | Navarra | 63423 | 1179 | 3905 | 58339 | 42.6954 | -1.6761 | 2021-06-19 04:22:33 | Navarra, Spain | ||
2884671 | 2884671 | 2021-06-20 | Spain | Navarra | 63423 | 1179 | 3905 | 58339 | 42.6954 | -1.6761 | 2021-06-21 04:21:41 | 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]);