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 day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2463095 | 2463095 | 2021-09-14 | Spain | Navarra | 82171 | 1233 | 0 | 42.6954 | -1.6761 | 2021-09-15 03:22:37 | Navarra, Spain | |||
1385934 | 1385934 | 2021-09-13 | Spain | Navarra | 82144 | 1232 | 0 | 42.6954 | -1.6761 | 2021-09-14 04:21:41 | Navarra, Spain | |||
1885303 | 1885303 | 2021-09-12 | Spain | Navarra | 82003 | 1232 | 0 | 42.6954 | -1.6761 | 2021-09-13 04:21:15 | Navarra, Spain | |||
3806206 | 3806206 | 2021-09-11 | Spain | Navarra | 82003 | 1232 | 0 | 42.6954 | -1.6761 | 2021-09-12 04:21:13 | Navarra, Spain | |||
3449146 | 3449146 | 2021-09-10 | Spain | Navarra | 82003 | 1232 | 0 | 42.6954 | -1.6761 | 2021-09-11 04:21:30 | Navarra, Spain | |||
1263092 | 1263092 | 2021-09-09 | Spain | Navarra | 81957 | 1231 | 0 | 42.6954 | -1.6761 | 2021-09-10 04:21:20 | Navarra, Spain | |||
2279462 | 2279462 | 2021-09-08 | Spain | Navarra | 81878 | 1231 | 0 | 42.6954 | -1.6761 | 2021-09-09 04:21:27 | Navarra, Spain | |||
642241 | 642241 | 2021-09-07 | Spain | Navarra | 81834 | 1230 | 0 | 42.6954 | -1.6761 | 2021-09-08 04:21:31 | Navarra, Spain | |||
3194304 | 3194304 | 2021-09-06 | Spain | Navarra | 81768 | 1229 | 0 | 42.6954 | -1.6761 | 2021-09-07 04:21:35 | Navarra, Spain | |||
3281172 | 3281172 | 2021-09-05 | Spain | Navarra | 81705 | 1227 | 0 | 42.6954 | -1.6761 | 2021-09-06 04:21:22 | Navarra, Spain | |||
249586 | 249586 | 2021-09-04 | Spain | Navarra | 81705 | 1227 | 0 | 42.6954 | -1.6761 | 2021-09-05 04:21:33 | Navarra, Spain | |||
3974867 | 3974867 | 2021-09-03 | Spain | Navarra | 81705 | 1227 | 0 | 42.6954 | -1.6761 | 2021-09-04 04:21:28 | Navarra, Spain | |||
178329 | 178329 | 2021-09-02 | Spain | Navarra | 81637 | 1227 | 0 | 42.6954 | -1.6761 | 2021-09-03 04:21:20 | Navarra, Spain | |||
67364 | 67364 | 2021-09-01 | Spain | Navarra | 81531 | 1226 | 0 | 42.6954 | -1.6761 | 2021-09-02 04:21:15 | Navarra, Spain | |||
2068206 | 2068206 | 2021-08-31 | Spain | Navarra | 81390 | 1226 | 0 | 42.6954 | -1.6761 | 2021-09-01 04:21:38 | Navarra, Spain | |||
1775660 | 1775660 | 2021-08-30 | Spain | Navarra | 81304 | 1224 | 0 | 42.6954 | -1.6761 | 2021-08-31 04:21:46 | Navarra, Spain | |||
3892234 | 3892234 | 2021-08-29 | Spain | Navarra | 81065 | 1219 | 0 | 42.6954 | -1.6761 | 2021-08-30 04:21:23 | Navarra, Spain | |||
2793337 | 2793337 | 2021-08-28 | Spain | Navarra | 81065 | 1219 | 0 | 42.6954 | -1.6761 | 2021-08-29 04:21:14 | Navarra, Spain | |||
2923496 | 2923496 | 2021-08-27 | Spain | Navarra | 81065 | 1219 | 0 | 42.6954 | -1.6761 | 2021-08-28 04:21:28 | Navarra, Spain | |||
1596510 | 1596510 | 2021-08-26 | Spain | Navarra | 80992 | 1218 | 0 | 42.6954 | -1.6761 | 2021-08-27 04:21:37 | Navarra, Spain | |||
32719 | 32719 | 2021-08-25 | Spain | Navarra | 80900 | 1213 | 0 | 42.6954 | -1.6761 | 2021-08-26 04:21:28 | Navarra, Spain | |||
3105758 | 3105758 | 2021-08-24 | Spain | Navarra | 80834 | 1213 | 0 | 42.6954 | -1.6761 | 2021-08-25 04:21:41 | Navarra, Spain | |||
3165929 | 3165929 | 2021-08-23 | Spain | Navarra | 80703 | 1211 | 0 | 42.6954 | -1.6761 | 2021-08-24 04:21:19 | Navarra, Spain | |||
2175856 | 2175856 | 2021-08-22 | Spain | Navarra | 80366 | 1206 | 0 | 42.6954 | -1.6761 | 2021-08-23 04:21:27 | Navarra, Spain | |||
3555952 | 3555952 | 2021-08-21 | Spain | Navarra | 80366 | 1206 | 0 | 42.6954 | -1.6761 | 2021-08-22 04:21:29 | Navarra, Spain | |||
1854294 | 1854294 | 2021-08-20 | Spain | Navarra | 80366 | 1206 | 0 | 42.6954 | -1.6761 | 2021-08-21 04:21:38 | Navarra, Spain | |||
512001 | 512001 | 2021-08-19 | Spain | Navarra | 80227 | 1204 | 0 | 42.6954 | -1.6761 | 2021-08-20 04:21:33 | Navarra, Spain | |||
2518480 | 2518480 | 2021-08-18 | Spain | Navarra | 80072 | 1204 | 0 | 42.6954 | -1.6761 | 2021-08-19 04:21:15 | Navarra, Spain | |||
245572 | 245572 | 2021-08-17 | Spain | Navarra | 79922 | 1204 | 0 | 42.6954 | -1.6761 | 2021-08-18 04:21:35 | Navarra, Spain | |||
1604535 | 1604535 | 2021-08-16 | Spain | Navarra | 79745 | 1203 | 0 | 42.6954 | -1.6761 | 2021-08-17 04:21:49 | Navarra, Spain | |||
103629 | 103629 | 2021-08-15 | Spain | Navarra | 79288 | 1201 | 0 | 42.6954 | -1.6761 | 2021-08-16 04:21:31 | Navarra, Spain | |||
507987 | 507987 | 2021-08-14 | Spain | Navarra | 79288 | 1201 | 0 | 42.6954 | -1.6761 | 2021-08-15 04:21:41 | Navarra, Spain | |||
1483859 | 1483859 | 2021-08-13 | Spain | Navarra | 79288 | 1201 | 0 | 42.6954 | -1.6761 | 2021-08-14 04:21:25 | Navarra, Spain | |||
2899989 | 2899989 | 2021-08-12 | Spain | Navarra | 79069 | 1200 | 0 | 42.6954 | -1.6761 | 2021-08-13 04:21:24 | Navarra, Spain | |||
1342593 | 1342593 | 2021-08-11 | Spain | Navarra | 78832 | 1199 | 0 | 42.6954 | -1.6761 | 2021-08-12 04:21:25 | Navarra, Spain | |||
2351740 | 2351740 | 2021-08-10 | Spain | Navarra | 78613 | 1198 | 0 | 42.6954 | -1.6761 | 2021-08-11 04:21:58 | Navarra, Spain | |||
650269 | 650269 | 2021-08-09 | Spain | Navarra | 78417 | 1196 | 0 | 42.6954 | -1.6761 | 2021-08-10 04:21:27 | Navarra, Spain | |||
589931 | 589931 | 2021-08-08 | Spain | Navarra | 77812 | 1195 | 0 | 42.6954 | -1.6761 | 2021-08-09 04:21:24 | Navarra, Spain | |||
2203943 | 2203943 | 2021-08-07 | Spain | Navarra | 77812 | 1195 | 0 | 42.6954 | -1.6761 | 2021-08-08 04:21:33 | Navarra, Spain | |||
1117893 | 1117893 | 2021-08-06 | Spain | Navarra | 77812 | 1195 | 0 | 42.6954 | -1.6761 | 2021-08-07 04:21:30 | Navarra, Spain | |||
1956830 | 1956830 | 2021-08-05 | Spain | Navarra | 77534 | 1194 | 0 | 42.6954 | -1.6761 | 2021-08-06 04:21: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 | ||
3015653 | 3015653 | 2021-08-01 | Spain | Navarra | 75750 | 1191 | 3905 | 70654 | 42.6954 | -1.6761 | 2021-08-02 04:21:36 | 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 | ||
3296481 | 3296481 | 2021-07-30 | Spain | Navarra | 75750 | 1191 | 3905 | 70654 | 42.6954 | -1.6761 | 2021-07-31 04:21:35 | 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 | ||
3218601 | 3218601 | 2021-07-26 | Spain | Navarra | 74203 | 1188 | 3905 | 69110 | 42.6954 | -1.6761 | 2021-07-27 04:21:18 | 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 | ||
1330550 | 1330550 | 2021-07-24 | Spain | Navarra | 73039 | 1186 | 3905 | 67948 | 42.6954 | -1.6761 | 2021-07-25 04:22:12 | 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 | ||
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 | ||
3706428 | 3706428 | 2021-07-17 | Spain | Navarra | 69840 | 1184 | 3905 | 64751 | 42.6954 | -1.6761 | 2021-07-18 04:22:07 | 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 | ||
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 | ||
3659897 | 3659897 | 2021-07-11 | Spain | Navarra | 66449 | 1184 | 3905 | 61360 | 42.6954 | -1.6761 | 2021-07-12 04:21:34 | 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 | ||
778664 | 778664 | 2021-07-08 | Spain | Navarra | 66175 | 1184 | 3905 | 61086 | 42.6954 | -1.6761 | 2021-07-09 04:21:21 | 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 | ||
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 | ||
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 | ||
1712628 | 1712628 | 2021-06-25 | Spain | Navarra | 63732 | 1184 | 3905 | 58643 | 42.6954 | -1.6761 | 2021-06-26 04:21:43 | 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 | ||
2884671 | 2884671 | 2021-06-20 | Spain | Navarra | 63423 | 1179 | 3905 | 58339 | 42.6954 | -1.6761 | 2021-06-21 04:21:41 | 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 | ||
2911475 | 2911475 | 2021-06-17 | Spain | Navarra | 63375 | 1178 | 3905 | 58292 | 42.6954 | -1.6761 | 2021-06-18 04:22:16 | Navarra, Spain | ||
3030591 | 3030591 | 2021-06-16 | Spain | Navarra | 63323 | 1178 | 3905 | 58240 | 42.6954 | -1.6761 | 2021-06-17 04:22:36 | Navarra, Spain | ||
2339697 | 2339697 | 2021-06-15 | Spain | Navarra | 63261 | 1178 | 3905 | 58178 | 42.6954 | -1.6761 | 2021-06-16 04:22:32 | Navarra, Spain | ||
1564393 | 1564393 | 2021-06-14 | Spain | Navarra | 63225 | 1178 | 3905 | 58142 | 42.6954 | -1.6761 | 2021-06-15 04:22:22 | Navarra, Spain | ||
3381676 | 3381676 | 2021-06-13 | Spain | Navarra | 63087 | 1178 | 3905 | 58004 | 42.6954 | -1.6761 | 2021-06-14 04:22:46 | Navarra, Spain | ||
1736810 | 1736810 | 2021-06-12 | Spain | Navarra | 63087 | 1178 | 3905 | 58004 | 42.6954 | -1.6761 | 2021-06-13 04:22:44 | Navarra, Spain | ||
3970851 | 3970851 | 2021-06-11 | Spain | Navarra | 63087 | 1178 | 3905 | 58004 | 42.6954 | -1.6761 | 2021-06-12 04:22:22 | Navarra, Spain | ||
2717273 | 2717273 | 2021-06-10 | Spain | Navarra | 63027 | 1178 | 3905 | 57944 | 42.6954 | -1.6761 | 2021-06-11 04:23:20 | Navarra, Spain | ||
523158 | 523158 | 2021-06-09 | Spain | Navarra | 62975 | 1178 | 3905 | 57892 | 42.6954 | -1.6761 | 2021-06-10 04:23:17 | Navarra, Spain | ||
3472598 | 3472598 | 2021-06-08 | Spain | Navarra | 62918 | 1178 | 3905 | 57835 | 42.6954 | -1.6761 | 2021-06-09 04:23:31 | Navarra, Spain | ||
3145882 | 3145882 | 2021-06-07 | Spain | Navarra | 62873 | 1178 | 3905 | 57790 | 42.6954 | -1.6761 | 2021-06-08 04:22:35 | 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]);