johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where combined_key = "Navarra, Spain" and country_or_region = "Spain" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
825884 | 825884 | 2021-06-06 | Spain | Navarra | 62720 | 1177 | 3905 | 57638 | 42.6954 | -1.6761 | 2021-06-07 04:22:51 | Navarra, Spain | ||
2586289 | 2586289 | 2021-06-05 | Spain | Navarra | 62720 | 1177 | 3905 | 57638 | 42.6954 | -1.6761 | 2021-06-06 04:24:03 | Navarra, Spain | ||
2315603 | 2315603 | 2021-06-04 | Spain | Navarra | 62720 | 1177 | 3905 | 57638 | 42.6954 | -1.6761 | 2021-06-05 04:23:03 | Navarra, Spain | ||
1448888 | 1448888 | 2021-06-03 | Spain | Navarra | 62662 | 1176 | 3905 | 57581 | 42.6954 | -1.6761 | 2021-06-04 04:23:37 | Navarra, Spain | ||
1708612 | 1708612 | 2021-06-02 | Spain | Navarra | 62583 | 1176 | 3905 | 57502 | 42.6954 | -1.6761 | 2021-06-03 04:23:32 | Navarra, Spain | ||
2104430 | 2104430 | 2021-06-01 | Spain | Navarra | 62490 | 1175 | 3905 | 57410 | 42.6954 | -1.6761 | 2021-06-02 04:24:34 | Navarra, Spain | ||
1189046 | 1189046 | 2021-05-31 | Spain | Navarra | 62422 | 1174 | 3905 | 57343 | 42.6954 | -1.6761 | 2021-06-01 04:23:09 | Navarra, Spain | ||
3089723 | 3089723 | 2021-05-30 | Spain | Navarra | 62232 | 1171 | 3905 | 57156 | 42.6954 | -1.6761 | 2021-05-31 03:08:59 | Navarra, Spain | ||
51092 | 51092 | 2021-05-29 | Spain | Navarra | 62232 | 1171 | 3905 | 57156 | 42.6954 | -1.6761 | 2021-05-30 04:20:55 | Navarra, Spain | ||
20671 | 20671 | 2021-05-28 | Spain | Navarra | 62232 | 1171 | 3905 | 57156 | 42.6954 | -1.6761 | 2021-05-29 04:20:41 | Navarra, Spain | ||
1807046 | 1807046 | 2021-05-27 | Spain | Navarra | 62154 | 1171 | 3905 | 57078 | 42.6954 | -1.6761 | 2021-05-28 04:20:36 | Navarra, Spain | ||
1310469 | 1310469 | 2021-05-26 | Spain | Navarra | 62060 | 1170 | 3905 | 56985 | 42.6954 | -1.6761 | 2021-05-27 04:20:59 | Navarra, Spain | ||
83395 | 83395 | 2021-05-25 | Spain | Navarra | 62007 | 1170 | 3905 | 56932 | 42.6954 | -1.6761 | 2021-05-26 04:20:35 | Navarra, Spain | ||
1413357 | 1413357 | 2021-05-24 | Spain | Navarra | 61948 | 1170 | 3905 | 56873 | 42.6954 | -1.6761 | 2021-05-25 04:21:08 | Navarra, Spain | ||
1771643 | 1771643 | 2021-05-23 | Spain | Navarra | 61811 | 1170 | 3905 | 56736 | 42.6954 | -1.6761 | 2021-05-24 04:20:53 | Navarra, Spain | ||
726798 | 726798 | 2021-05-22 | Spain | Navarra | 61811 | 1170 | 3905 | 56736 | 42.6954 | -1.6761 | 2021-05-23 04:20:51 | Navarra, Spain | ||
1952813 | 1952813 | 2021-05-21 | Spain | Navarra | 61811 | 1170 | 3905 | 56736 | 42.6954 | -1.6761 | 2021-05-22 04:20:45 | Navarra, Spain | ||
1913512 | 1913512 | 2021-05-20 | Spain | Navarra | 61740 | 1170 | 3905 | 56665 | 42.6954 | -1.6761 | 2021-05-21 04:20:43 | Navarra, Spain | ||
2256033 | 2256033 | 2021-05-19 | Spain | Navarra | 61682 | 1170 | 3905 | 56607 | 42.6954 | -1.6761 | 2021-05-20 04:21:05 | Navarra, Spain | ||
2391071 | 2391071 | 2021-05-18 | Spain | Navarra | 61606 | 1170 | 3905 | 56531 | 42.6954 | -1.6761 | 2021-05-19 04:20:42 | Navarra, Spain | ||
3574896 | 3574896 | 2021-05-17 | Spain | Navarra | 61544 | 1170 | 3905 | 56469 | 42.6954 | -1.6761 | 2021-05-18 04:20:33 | Navarra, Spain | ||
2939626 | 2939626 | 2021-05-16 | Spain | Navarra | 61340 | 1168 | 3905 | 56267 | 42.6954 | -1.6761 | 2021-05-17 04:20:34 | Navarra, Spain | ||
1873256 | 1873256 | 2021-05-15 | Spain | Navarra | 61340 | 1168 | 3905 | 56267 | 42.6954 | -1.6761 | 2021-05-16 04:20:49 | Navarra, Spain | ||
1082225 | 1082225 | 2021-05-14 | Spain | Navarra | 61340 | 1168 | 3905 | 56267 | 42.6954 | -1.6761 | 2021-05-15 04:20:58 | Navarra, Spain | ||
3054491 | 3054491 | 2021-05-13 | Spain | Navarra | 61267 | 1168 | 3905 | 56194 | 42.6954 | -1.6761 | 2021-05-14 04:20:41 | Navarra, Spain | ||
2004961 | 2004961 | 2021-05-12 | Spain | Navarra | 61178 | 1166 | 3905 | 56107 | 42.6954 | -1.6761 | 2021-05-13 04:20:51 | Navarra, Spain | ||
3954792 | 3954792 | 2021-05-11 | Spain | Navarra | 61110 | 1163 | 3905 | 56042 | 42.6954 | -1.6761 | 2021-05-12 04:21:29 | Navarra, Spain | ||
2821071 | 2821071 | 2021-05-10 | Spain | Navarra | 61032 | 1167 | 3905 | 55960 | 42.6954 | -1.6761 | 2021-05-11 04:20:41 | Navarra, Spain | ||
1425403 | 1425403 | 2021-05-09 | Spain | Navarra | 60753 | 1164 | 3905 | 55684 | 42.6954 | -1.6761 | 2021-05-10 04:20:38 | Navarra, Spain | ||
1552271 | 1552271 | 2021-05-08 | Spain | Navarra | 60753 | 1164 | 3905 | 55684 | 42.6954 | -1.6761 | 2021-05-09 04:20:35 | Navarra, Spain | ||
2502329 | 2502329 | 2021-05-07 | Spain | Navarra | 60753 | 1164 | 3905 | 55684 | 42.6954 | -1.6761 | 2021-05-08 04:21:04 | Navarra, Spain | ||
3113785 | 3113785 | 2021-05-06 | Spain | Navarra | 60625 | 1165 | 3905 | 55555 | 42.6954 | -1.6761 | 2021-05-07 04:20:40 | Navarra, Spain | ||
646252 | 646252 | 2021-05-05 | Spain | Navarra | 60487 | 1165 | 3905 | 55417 | 42.6954 | -1.6761 | 2021-05-06 04:20:38 | Navarra, Spain | ||
3675952 | 3675952 | 2021-05-04 | Spain | Navarra | 60376 | 1164 | 3905 | 55307 | 42.6954 | -1.6761 | 2021-05-05 04:20:43 | Navarra, Spain | ||
2761219 | 2761219 | 2021-05-03 | Spain | Navarra | 60249 | 1163 | 3905 | 55181 | 42.6954 | -1.6761 | 2021-05-04 04:20:34 | Navarra, Spain | ||
2451072 | 2451072 | 2021-05-02 | Spain | Navarra | 59870 | 1156 | 3905 | 54809 | 42.6954 | -1.6761 | 2021-05-03 04:20:39 | Navarra, Spain | ||
2825085 | 2825085 | 2021-05-01 | Spain | Navarra | 59870 | 1156 | 3905 | 54809 | 42.6954 | -1.6761 | 2021-05-02 04:20:48 | Navarra, Spain | ||
380493 | 380493 | 2021-04-30 | Spain | Navarra | 59870 | 1156 | 3905 | 54809 | 42.6954 | -1.6761 | 2021-05-01 04:20:47 | Navarra, Spain | ||
1636616 | 1636616 | 2021-04-29 | Spain | Navarra | 59722 | 1155 | 3905 | 54662 | 42.6954 | -1.6761 | 2021-04-30 04:21:03 | Navarra, Spain | ||
3393695 | 3393695 | 2021-04-28 | Spain | Navarra | 59538 | 1154 | 3905 | 54479 | 42.6954 | -1.6761 | 2021-04-29 04:20:55 | Navarra, Spain | ||
3702411 | 3702411 | 2021-04-27 | Spain | Navarra | 59378 | 1152 | 3905 | 54321 | 42.6954 | -1.6761 | 2021-04-28 04:20:32 | Navarra, Spain | ||
888420 | 888420 | 2021-04-26 | Spain | Navarra | 59233 | 1151 | 3905 | 54177 | 42.6954 | -1.6761 | 2021-04-27 04:20:52 | Navarra, Spain | ||
955165 | 955165 | 2021-04-25 | Spain | Navarra | 58786 | 1144 | 3905 | 53737 | 42.6954 | -1.6761 | 2021-04-26 04:21:04 | Navarra, Spain | ||
3924312 | 3924312 | 2021-04-24 | Spain | Navarra | 58786 | 1144 | 3905 | 53737 | 42.6954 | -1.6761 | 2021-04-25 04:20:32 | Navarra, Spain | ||
1409343 | 1409343 | 2021-04-23 | Spain | Navarra | 58786 | 1144 | 3905 | 53737 | 42.6954 | -1.6761 | 2021-04-24 04:20:38 | Navarra, Spain | ||
1568406 | 1568406 | 2021-04-22 | Spain | Navarra | 58592 | 1144 | 3905 | 53543 | 42.6954 | -1.6761 | 2021-04-23 04:20:52 | Navarra, Spain | ||
3242627 | 3242627 | 2021-04-21 | Spain | Navarra | 58406 | 1141 | 3905 | 53360 | 42.6954 | -1.6761 | 2021-04-22 04:20:53 | Navarra, Spain | ||
2021023 | 2021023 | 2021-04-20 | Spain | Navarra | 58034 | 1138 | 3905 | 52991 | 42.6954 | -1.6761 | 2021-04-21 04:21:14 | Navarra, Spain | ||
2411144 | 2411144 | 2021-04-19 | Spain | Navarra | 58034 | 1138 | 3905 | 52991 | 42.6954 | -1.6761 | 2021-04-20 04:20:41 | Navarra, Spain | ||
3129821 | 3129821 | 2021-04-18 | Spain | Navarra | 57581 | 1137 | 3905 | 52539 | 42.6954 | -1.6761 | 2021-04-19 04:20:57 | Navarra, Spain | ||
983249 | 983249 | 2021-04-17 | Spain | Navarra | 57581 | 1137 | 3905 | 52539 | 42.6954 | -1.6761 | 2021-04-18 04:20:41 | Navarra, Spain | ||
170344 | 170344 | 2021-04-16 | Spain | Navarra | 57581 | 1137 | 3905 | 52539 | 42.6954 | -1.6761 | 2021-04-17 04:20:40 | Navarra, Spain | ||
2549175 | 2549175 | 2021-04-15 | Spain | Navarra | 57378 | 1134 | 3905 | 52339 | 42.6954 | -1.6761 | 2021-04-16 04:20:46 | Navarra, Spain | ||
1842245 | 1842245 | 2021-04-14 | Spain | Navarra | 57180 | 1134 | 3905 | 52141 | 42.6954 | -1.6761 | 2021-04-15 04:20:54 | Navarra, Spain | ||
2571979 | 2571979 | 2021-04-13 | Spain | Navarra | 56959 | 1136 | 3905 | 51918 | 42.6954 | -1.6761 | 2021-04-14 04:20:41 | Navarra, Spain | ||
36730 | 36730 | 2021-04-12 | Spain | Navarra | 56771 | 1136 | 3905 | 51730 | 42.6954 | -1.6761 | 2021-04-13 04:20:37 | Navarra, Spain | ||
3883889 | 3883889 | 2021-04-11 | Spain | Navarra | 56129 | 1126 | 3905 | 51098 | 42.6954 | -1.6761 | 2021-04-12 04:21:00 | Navarra, Spain | ||
2983557 | 2983557 | 2021-04-10 | Spain | Navarra | 56129 | 1126 | 3905 | 51098 | 42.6954 | -1.6761 | 2021-04-11 04:20:56 | Navarra, Spain | ||
605989 | 605989 | 2021-04-09 | Spain | Navarra | 56129 | 1126 | 3905 | 51098 | 42.6954 | -1.6761 | 2021-04-10 04:20:59 | Navarra, Spain | ||
2646053 | 2646053 | 2021-04-08 | Spain | Navarra | 55818 | 1125 | 3905 | 50788 | 42.6954 | -1.6761 | 2021-04-09 04:21:13 | Navarra, Spain | ||
2247695 | 2247695 | 2021-04-07 | Spain | Navarra | 55584 | 1124 | 3905 | 50555 | 42.6954 | -1.6761 | 2021-04-08 04:21:13 | Navarra, Spain | ||
3003605 | 3003605 | 2021-04-06 | Spain | Navarra | 55359 | 1123 | 3905 | 50331 | 42.6954 | -1.6761 | 2021-04-07 04:20:53 | Navarra, Spain | ||
3085600 | 3085600 | 2021-04-05 | Spain | Navarra | 55164 | 1123 | 3905 | 50136 | 42.6954 | -1.6761 | 2021-04-06 04:20:32 | Navarra, Spain | ||
388523 | 388523 | 2021-04-04 | Spain | Navarra | 54832 | 1122 | 3905 | 49805 | 42.6954 | -1.6761 | 2021-04-05 04:20:35 | Navarra, Spain | ||
3710439 | 3710439 | 2021-04-03 | Spain | Navarra | 54832 | 1122 | 3905 | 49805 | 42.6954 | -1.6761 | 2021-04-04 04:20:49 | Navarra, Spain | ||
241555 | 241555 | 2021-04-02 | Spain | Navarra | 54479 | 1121 | 3905 | 49453 | 42.6954 | -1.6761 | 2021-04-03 04:20:44 | Navarra, Spain | ||
1302352 | 1302352 | 2021-04-01 | Spain | Navarra | 54479 | 1121 | 3905 | 49453 | 42.6954 | -1.6761 | 2021-04-02 04:20:36 | Navarra, Spain | ||
638224 | 638224 | 2021-03-31 | Spain | Navarra | 54315 | 1121 | 3905 | 49289 | 42.6954 | -1.6761 | 2021-04-01 04:27:05 | Navarra, Spain | ||
3643853 | 3643853 | 2021-03-30 | Spain | Navarra | 54145 | 1121 | 3905 | 49119 | 42.6954 | -1.6761 | 2021-03-31 04:26:25 | Navarra, Spain | ||
1290306 | 1290306 | 2021-03-29 | Spain | Navarra | 53949 | 1121 | 3905 | 48923 | 42.6954 | -1.6761 | 2021-03-30 04:26:23 | Navarra, Spain | ||
1536228 | 1536228 | 2021-03-28 | Spain | Navarra | 53517 | 1117 | 3905 | 48495 | 42.6954 | -1.6761 | 2021-03-29 04:28:35 | Navarra, Spain | ||
1219868 | 1219868 | 2021-03-27 | Spain | Navarra | 53517 | 1117 | 3905 | 48495 | 42.6954 | -1.6761 | 2021-03-28 05:28:10 | Navarra, Spain | ||
1881286 | 1881286 | 2021-03-26 | Spain | Navarra | 53517 | 1117 | 3905 | 48495 | 42.6954 | -1.6761 | 2021-03-27 05:25:04 | Navarra, Spain | ||
1980916 | 1980916 | 2021-03-25 | Spain | Navarra | 53298 | 1116 | 3905 | 48277 | 42.6954 | -1.6761 | 2021-03-26 05:26:55 | Navarra, Spain | ||
2781294 | 2781294 | 2021-03-24 | Spain | Navarra | 52952 | 1116 | 3905 | 47931 | 42.6954 | -1.6761 | 2021-03-25 05:27:00 | Navarra, Spain | ||
1798939 | 1798939 | 2021-03-23 | Spain | Navarra | 52952 | 1116 | 3905 | 47931 | 42.6954 | -1.6761 | 2021-03-24 05:25:40 | Navarra, Spain | ||
1204107 | 1204107 | 2021-03-22 | Spain | Navarra | 52827 | 1116 | 3905 | 47806 | 42.6954 | -1.6761 | 2021-03-23 05:26:18 | Navarra, Spain | ||
3369629 | 3369629 | 2021-03-21 | Spain | Navarra | 52453 | 1113 | 3905 | 47435 | 42.6954 | -1.6761 | 2021-03-22 05:25:43 | Navarra, Spain | ||
1744839 | 1744839 | 2021-03-20 | Spain | Navarra | 52453 | 1113 | 3905 | 47435 | 42.6954 | -1.6761 | 2021-03-21 05:25:44 | Navarra, Spain | ||
3421219 | 3421219 | 2021-03-19 | Spain | Navarra | 52453 | 1113 | 3905 | 47435 | 42.6954 | -1.6761 | 2021-03-20 05:25:46 | Navarra, Spain | ||
3453157 | 3453157 | 2021-03-18 | Spain | Navarra | 52453 | 1113 | 3905 | 47435 | 42.6954 | -1.6761 | 2021-03-19 05:26:09 | Navarra, Spain | ||
3621381 | 3621381 | 2021-03-17 | Spain | Navarra | 52376 | 1113 | 3905 | 47358 | 42.6954 | -1.6761 | 2021-03-18 05:26:22 | Navarra, Spain | ||
702705 | 702705 | 2021-03-16 | Spain | Navarra | 52277 | 1111 | 3905 | 47261 | 42.6954 | -1.6761 | 2021-03-17 05:25:07 | Navarra, Spain | ||
2056183 | 2056183 | 2021-03-15 | Spain | Navarra | 52204 | 1110 | 3905 | 47189 | 42.6954 | -1.6761 | 2021-03-16 05:25:13 | Navarra, Spain | ||
1732795 | 1732795 | 2021-03-14 | Spain | Navarra | 52054 | 1109 | 3905 | 47040 | 42.6954 | -1.6761 | 2021-03-15 05:25:51 | Navarra, Spain | ||
1580452 | 1580452 | 2021-03-13 | Spain | Navarra | 52054 | 1109 | 3905 | 47040 | 42.6954 | -1.6761 | 2021-03-14 05:25:37 | 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]);