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 = "Aragon" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1090359 | 1090359 | 2021-03-03 | Spain | Aragon | 107224 | 3286 | 3772 | 100166 | 41.5976 | -0.9057 | 2021-03-04 05:24:24 | Aragon, Spain | ||
1041095 | 1041095 | 2020-05-26 | Spain | Aragon | 5600 | 826 | 3772 | 1002 | 41.5976 | -0.9057 | 2020-05-27 02:32:31 | Aragon, Spain | ||
2548132 | 2548132 | 2020-05-27 | Spain | Aragon | 5600 | 826 | 3772 | 1002 | 41.5976 | -0.9057 | 2020-05-28 02:32:31 | Aragon, Spain | ||
2207938 | 2207938 | 2021-03-04 | Spain | Aragon | 107398 | 3297 | 3772 | 100329 | 41.5976 | -0.9057 | 2021-03-05 05:26:29 | Aragon, Spain | ||
55089 | 55089 | 2021-03-07 | Spain | Aragon | 107568 | 3303 | 3772 | 100493 | 41.5976 | -0.9057 | 2021-03-08 05:24:48 | Aragon, Spain | ||
1616527 | 1616527 | 2021-03-05 | Spain | Aragon | 107568 | 3303 | 3772 | 100493 | 41.5976 | -0.9057 | 2021-03-06 04:23:41 | Aragon, Spain | ||
3667906 | 3667906 | 2021-03-06 | Spain | Aragon | 107568 | 3303 | 3772 | 100493 | 41.5976 | -0.9057 | 2021-03-07 05:21:54 | Aragon, Spain | ||
2359751 | 2359751 | 2021-03-08 | Spain | Aragon | 107850 | 3312 | 3772 | 100766 | 41.5976 | -0.9057 | 2021-03-09 05:28:19 | Aragon, Spain | ||
3663892 | 3663892 | 2021-03-09 | Spain | Aragon | 107954 | 3319 | 3772 | 100863 | 41.5976 | -0.9057 | 2021-03-10 05:24:35 | Aragon, Spain | ||
3962804 | 3962804 | 2021-03-10 | Spain | Aragon | 108122 | 3320 | 3772 | 101030 | 41.5976 | -0.9057 | 2021-03-11 05:25:48 | Aragon, Spain | ||
352580 | 352580 | 2021-03-11 | Spain | Aragon | 108265 | 3329 | 3772 | 101164 | 41.5976 | -0.9057 | 2021-03-12 05:26:50 | Aragon, Spain | ||
1580436 | 1580436 | 2021-03-13 | Spain | Aragon | 108416 | 3333 | 3772 | 101311 | 41.5976 | -0.9057 | 2021-03-14 05:25:37 | Aragon, Spain | ||
1732779 | 1732779 | 2021-03-14 | Spain | Aragon | 108416 | 3333 | 3772 | 101311 | 41.5976 | -0.9057 | 2021-03-15 05:25:51 | Aragon, Spain | ||
1838215 | 1838215 | 2021-03-12 | Spain | Aragon | 108416 | 3333 | 3772 | 101311 | 41.5976 | -0.9057 | 2021-03-13 05:25:15 | Aragon, Spain | ||
2056167 | 2056167 | 2021-03-15 | Spain | Aragon | 108693 | 3341 | 3772 | 101580 | 41.5976 | -0.9057 | 2021-03-16 05:25:13 | Aragon, Spain | ||
702689 | 702689 | 2021-03-16 | Spain | Aragon | 108799 | 3343 | 3772 | 101684 | 41.5976 | -0.9057 | 2021-03-17 05:25:07 | Aragon, Spain | ||
3621365 | 3621365 | 2021-03-17 | Spain | Aragon | 108940 | 3351 | 3772 | 101817 | 41.5976 | -0.9057 | 2021-03-18 05:26:22 | Aragon, Spain | ||
1744823 | 1744823 | 2021-03-20 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-21 05:25:44 | Aragon, Spain | ||
3369613 | 3369613 | 2021-03-21 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-22 05:25:43 | Aragon, Spain | ||
3421203 | 3421203 | 2021-03-19 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-20 05:25:46 | Aragon, Spain | ||
3453141 | 3453141 | 2021-03-18 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-19 05:26:09 | Aragon, Spain | ||
1204091 | 1204091 | 2021-03-22 | Spain | Aragon | 109579 | 3365 | 3772 | 102442 | 41.5976 | -0.9057 | 2021-03-23 05:26:18 | Aragon, Spain | ||
1798923 | 1798923 | 2021-03-23 | Spain | Aragon | 109683 | 3372 | 3772 | 102539 | 41.5976 | -0.9057 | 2021-03-24 05:25:40 | Aragon, Spain | ||
2781278 | 2781278 | 2021-03-24 | Spain | Aragon | 109683 | 3372 | 3772 | 102539 | 41.5976 | -0.9057 | 2021-03-25 05:27:00 | Aragon, Spain | ||
1980900 | 1980900 | 2021-03-25 | Spain | Aragon | 110002 | 3371 | 3772 | 102859 | 41.5976 | -0.9057 | 2021-03-26 05:26:55 | Aragon, Spain | ||
1219852 | 1219852 | 2021-03-27 | Spain | Aragon | 110163 | 3372 | 3772 | 103019 | 41.5976 | -0.9057 | 2021-03-28 05:28:10 | Aragon, Spain | ||
1536212 | 1536212 | 2021-03-28 | Spain | Aragon | 110163 | 3372 | 3772 | 103019 | 41.5976 | -0.9057 | 2021-03-29 04:28:35 | Aragon, Spain | ||
1881270 | 1881270 | 2021-03-26 | Spain | Aragon | 110163 | 3372 | 3772 | 103019 | 41.5976 | -0.9057 | 2021-03-27 05:25:04 | Aragon, Spain | ||
1290290 | 1290290 | 2021-03-29 | Spain | Aragon | 110530 | 3334 | 3772 | 103424 | 41.5976 | -0.9057 | 2021-03-30 04:26:23 | Aragon, Spain | ||
3643837 | 3643837 | 2021-03-30 | Spain | Aragon | 110668 | 3339 | 3772 | 103557 | 41.5976 | -0.9057 | 2021-03-31 04:26:25 | Aragon, Spain | ||
638208 | 638208 | 2021-03-31 | Spain | Aragon | 110894 | 3344 | 3772 | 103778 | 41.5976 | -0.9057 | 2021-04-01 04:27:05 | Aragon, Spain | ||
241539 | 241539 | 2021-04-02 | Spain | Aragon | 111089 | 3348 | 3772 | 103969 | 41.5976 | -0.9057 | 2021-04-03 04:20:44 | Aragon, Spain | ||
1302336 | 1302336 | 2021-04-01 | Spain | Aragon | 111089 | 3348 | 3772 | 103969 | 41.5976 | -0.9057 | 2021-04-02 04:20:36 | Aragon, Spain | ||
388507 | 388507 | 2021-04-04 | Spain | Aragon | 111339 | 3351 | 3772 | 104216 | 41.5976 | -0.9057 | 2021-04-05 04:20:35 | Aragon, Spain | ||
3710423 | 3710423 | 2021-04-03 | Spain | Aragon | 111339 | 3351 | 3772 | 104216 | 41.5976 | -0.9057 | 2021-04-04 04:20:49 | Aragon, Spain | ||
3085584 | 3085584 | 2021-04-05 | Spain | Aragon | 111611 | 3357 | 3772 | 104482 | 41.5976 | -0.9057 | 2021-04-06 04:20:32 | Aragon, Spain | ||
3003589 | 3003589 | 2021-04-06 | Spain | Aragon | 111836 | 3358 | 3772 | 104706 | 41.5976 | -0.9057 | 2021-04-07 04:20:53 | Aragon, Spain | ||
2247679 | 2247679 | 2021-04-07 | Spain | Aragon | 112210 | 3364 | 3772 | 105074 | 41.5976 | -0.9057 | 2021-04-08 04:21:13 | Aragon, Spain | ||
2646037 | 2646037 | 2021-04-08 | Spain | Aragon | 112531 | 3371 | 3772 | 105388 | 41.5976 | -0.9057 | 2021-04-09 04:21:13 | Aragon, Spain | ||
605973 | 605973 | 2021-04-09 | Spain | Aragon | 112848 | 3375 | 3772 | 105701 | 41.5976 | -0.9057 | 2021-04-10 04:20:59 | Aragon, Spain | ||
2983541 | 2983541 | 2021-04-10 | Spain | Aragon | 112848 | 3375 | 3772 | 105701 | 41.5976 | -0.9057 | 2021-04-11 04:20:56 | Aragon, Spain | ||
3883873 | 3883873 | 2021-04-11 | Spain | Aragon | 112848 | 3375 | 3772 | 105701 | 41.5976 | -0.9057 | 2021-04-12 04:21:00 | Aragon, Spain | ||
2712120 | 2712120 | 2020-05-28 | Spain | Aragon | 5656 | 826 | 3772 | 1058 | 41.5976 | -0.9057 | 2020-05-29 02:32:50 | Aragon, Spain | ||
3276179 | 3276179 | 2020-05-15 | Spain | Aragon | 5432 | 837 | 3534 | 1061 | 41.5976 | -0.9057 | 2020-05-16 02:32:19 | Aragon, Spain | ||
36714 | 36714 | 2021-04-12 | Spain | Aragon | 113436 | 3384 | 3772 | 106280 | 41.5976 | -0.9057 | 2021-04-13 04:20:37 | Aragon, Spain | ||
2571963 | 2571963 | 2021-04-13 | Spain | Aragon | 113630 | 3386 | 3772 | 106472 | 41.5976 | -0.9057 | 2021-04-14 04:20:41 | Aragon, Spain | ||
1842229 | 1842229 | 2021-04-14 | Spain | Aragon | 113963 | 3391 | 3772 | 106800 | 41.5976 | -0.9057 | 2021-04-15 04:20:54 | Aragon, Spain | ||
2549159 | 2549159 | 2021-04-15 | Spain | Aragon | 114218 | 3391 | 3772 | 107055 | 41.5976 | -0.9057 | 2021-04-16 04:20:46 | Aragon, Spain | ||
1790240 | 1790240 | 2020-05-29 | Spain | Aragon | 5671 | 826 | 3772 | 1073 | 41.5976 | -0.9057 | 2020-05-30 02:32:48 | Aragon, Spain | ||
170328 | 170328 | 2021-04-16 | Spain | Aragon | 114511 | 3393 | 3772 | 107346 | 41.5976 | -0.9057 | 2021-04-17 04:20:40 | Aragon, Spain | ||
983233 | 983233 | 2021-04-17 | Spain | Aragon | 114511 | 3393 | 3772 | 107346 | 41.5976 | -0.9057 | 2021-04-18 04:20:41 | Aragon, Spain | ||
3129805 | 3129805 | 2021-04-18 | Spain | Aragon | 114511 | 3393 | 3772 | 107346 | 41.5976 | -0.9057 | 2021-04-19 04:20:57 | Aragon, Spain | ||
2021007 | 2021007 | 2021-04-20 | Spain | Aragon | 115206 | 3407 | 3772 | 108027 | 41.5976 | -0.9057 | 2021-04-21 04:21:14 | Aragon, Spain | ||
2411128 | 2411128 | 2021-04-19 | Spain | Aragon | 115206 | 3407 | 3772 | 108027 | 41.5976 | -0.9057 | 2021-04-20 04:20:41 | Aragon, Spain | ||
1404353 | 1404353 | 2020-05-14 | Spain | Aragon | 5389 | 836 | 3471 | 1082 | 41.5976 | -0.9057 | 2020-05-15 02:33:02 | Aragon, Spain | ||
3638699 | 3638699 | 2020-05-30 | Spain | Aragon | 5680 | 826 | 3772 | 1082 | 41.5976 | -0.9057 | 2020-05-31 02:32:45 | Aragon, Spain | ||
3242611 | 3242611 | 2021-04-21 | Spain | Aragon | 115746 | 3415 | 3772 | 108559 | 41.5976 | -0.9057 | 2021-04-22 04:20:53 | Aragon, Spain | ||
1568390 | 1568390 | 2021-04-22 | Spain | Aragon | 116084 | 3420 | 3772 | 108892 | 41.5976 | -0.9057 | 2021-04-23 04:20:52 | Aragon, Spain | ||
955149 | 955149 | 2021-04-25 | Spain | Aragon | 116374 | 3423 | 3772 | 109179 | 41.5976 | -0.9057 | 2021-04-26 04:21:04 | Aragon, Spain | ||
1409327 | 1409327 | 2021-04-23 | Spain | Aragon | 116374 | 3423 | 3772 | 109179 | 41.5976 | -0.9057 | 2021-04-24 04:20:38 | Aragon, Spain | ||
3924296 | 3924296 | 2021-04-24 | Spain | Aragon | 116374 | 3423 | 3772 | 109179 | 41.5976 | -0.9057 | 2021-04-25 04:20:32 | Aragon, Spain | ||
1793806 | 1793806 | 2020-05-31 | Spain | Aragon | 5691 | 826 | 3772 | 1093 | 41.5976 | -0.9057 | 2020-06-01 02:32:46 | Aragon, Spain | ||
805165 | 805165 | 2020-06-01 | Spain | Aragon | 5695 | 826 | 3772 | 1097 | 41.5976 | -0.9057 | 2020-06-02 02:33:08 | Aragon, Spain | ||
888404 | 888404 | 2021-04-26 | Spain | Aragon | 116959 | 3428 | 3772 | 109759 | 41.5976 | -0.9057 | 2021-04-27 04:20:52 | Aragon, Spain | ||
3702395 | 3702395 | 2021-04-27 | Spain | Aragon | 117255 | 3427 | 3772 | 110056 | 41.5976 | -0.9057 | 2021-04-28 04:20:32 | Aragon, Spain | ||
3393679 | 3393679 | 2021-04-28 | Spain | Aragon | 117618 | 3437 | 3772 | 110409 | 41.5976 | -0.9057 | 2021-04-29 04:20:55 | Aragon, Spain | ||
1636600 | 1636600 | 2021-04-29 | Spain | Aragon | 117986 | 3437 | 3772 | 110777 | 41.5976 | -0.9057 | 2021-04-30 04:21:03 | Aragon, Spain | ||
380477 | 380477 | 2021-04-30 | Spain | Aragon | 118361 | 3437 | 3772 | 111152 | 41.5976 | -0.9057 | 2021-05-01 04:20:47 | Aragon, Spain | ||
2451056 | 2451056 | 2021-05-02 | Spain | Aragon | 118361 | 3437 | 3772 | 111152 | 41.5976 | -0.9057 | 2021-05-03 04:20:39 | Aragon, Spain | ||
2825069 | 2825069 | 2021-05-01 | Spain | Aragon | 118361 | 3437 | 3772 | 111152 | 41.5976 | -0.9057 | 2021-05-02 04:20:48 | Aragon, Spain | ||
2555629 | 2555629 | 2020-06-02 | Spain | Aragon | 5711 | 826 | 3772 | 1113 | 41.5976 | -0.9057 | 2020-06-03 02:33:13 | Aragon, Spain | ||
2761203 | 2761203 | 2021-05-03 | Spain | Aragon | 119153 | 3444 | 3772 | 111937 | 41.5976 | -0.9057 | 2021-05-04 04:20:34 | Aragon, Spain | ||
3675936 | 3675936 | 2021-05-04 | Spain | Aragon | 119340 | 3446 | 3772 | 112122 | 41.5976 | -0.9057 | 2021-05-05 04:20:43 | Aragon, Spain | ||
646236 | 646236 | 2021-05-05 | Spain | Aragon | 119698 | 3454 | 3772 | 112472 | 41.5976 | -0.9057 | 2021-05-06 04:20:38 | Aragon, Spain | ||
3113769 | 3113769 | 2021-05-06 | Spain | Aragon | 120025 | 3454 | 3772 | 112799 | 41.5976 | -0.9057 | 2021-05-07 04:20:40 | Aragon, Spain | ||
1425387 | 1425387 | 2021-05-09 | Spain | Aragon | 120282 | 3452 | 3772 | 113058 | 41.5976 | -0.9057 | 2021-05-10 04:20:38 | Aragon, Spain | ||
1552255 | 1552255 | 2021-05-08 | Spain | Aragon | 120282 | 3452 | 3772 | 113058 | 41.5976 | -0.9057 | 2021-05-09 04:20:35 | Aragon, Spain | ||
2502313 | 2502313 | 2021-05-07 | Spain | Aragon | 120282 | 3452 | 3772 | 113058 | 41.5976 | -0.9057 | 2021-05-08 04:21:04 | Aragon, Spain | ||
3866586 | 3866586 | 2020-06-03 | Spain | Aragon | 5731 | 826 | 3772 | 1133 | 41.5976 | -0.9057 | 2020-06-04 02:33:14 | Aragon, Spain | ||
2821055 | 2821055 | 2021-05-10 | Spain | Aragon | 120814 | 3460 | 3772 | 113582 | 41.5976 | -0.9057 | 2021-05-11 04:20:41 | Aragon, Spain | ||
1281031 | 1281031 | 2020-06-04 | Spain | Aragon | 5734 | 826 | 3772 | 1136 | 41.5976 | -0.9057 | 2020-06-05 02:33:06 | Aragon, Spain | ||
3954776 | 3954776 | 2021-05-11 | Spain | Aragon | 120965 | 3463 | 3772 | 113730 | 41.5976 | -0.9057 | 2021-05-12 04:21:29 | Aragon, Spain | ||
2004945 | 2004945 | 2021-05-12 | Spain | Aragon | 121190 | 3473 | 3772 | 113945 | 41.5976 | -0.9057 | 2021-05-13 04:20:51 | Aragon, Spain | ||
3054475 | 3054475 | 2021-05-13 | Spain | Aragon | 121429 | 3474 | 3772 | 114183 | 41.5976 | -0.9057 | 2021-05-14 04:20:41 | Aragon, Spain | ||
1082209 | 1082209 | 2021-05-14 | Spain | Aragon | 121653 | 3481 | 3772 | 114400 | 41.5976 | -0.9057 | 2021-05-15 04:20:58 | Aragon, Spain | ||
1873240 | 1873240 | 2021-05-15 | Spain | Aragon | 121653 | 3481 | 3772 | 114400 | 41.5976 | -0.9057 | 2021-05-16 04:20:49 | Aragon, Spain | ||
2939610 | 2939610 | 2021-05-16 | Spain | Aragon | 121653 | 3481 | 3772 | 114400 | 41.5976 | -0.9057 | 2021-05-17 04:20:34 | Aragon, Spain | ||
3574880 | 3574880 | 2021-05-17 | Spain | Aragon | 122063 | 3492 | 3772 | 114799 | 41.5976 | -0.9057 | 2021-05-18 04:20:33 | Aragon, Spain | ||
2391055 | 2391055 | 2021-05-18 | Spain | Aragon | 122193 | 3490 | 3772 | 114931 | 41.5976 | -0.9057 | 2021-05-19 04:20:42 | Aragon, Spain | ||
2256017 | 2256017 | 2021-05-19 | Spain | Aragon | 122451 | 3494 | 3772 | 115185 | 41.5976 | -0.9057 | 2021-05-20 04:21:05 | Aragon, Spain | ||
1913496 | 1913496 | 2021-05-20 | Spain | Aragon | 122692 | 3496 | 3772 | 115424 | 41.5976 | -0.9057 | 2021-05-21 04:20:43 | Aragon, Spain | ||
726782 | 726782 | 2021-05-22 | Spain | Aragon | 122929 | 3500 | 3772 | 115657 | 41.5976 | -0.9057 | 2021-05-23 04:20:51 | Aragon, Spain | ||
1771627 | 1771627 | 2021-05-23 | Spain | Aragon | 122929 | 3500 | 3772 | 115657 | 41.5976 | -0.9057 | 2021-05-24 04:20:53 | Aragon, Spain | ||
1952797 | 1952797 | 2021-05-21 | Spain | Aragon | 122929 | 3500 | 3772 | 115657 | 41.5976 | -0.9057 | 2021-05-22 04:20:45 | Aragon, Spain | ||
1269550 | 1269550 | 2020-06-05 | Spain | Aragon | 5757 | 826 | 3772 | 1159 | 41.5976 | -0.9057 | 2020-06-06 02:33:00 | Aragon, Spain | ||
1413341 | 1413341 | 2021-05-24 | Spain | Aragon | 123333 | 3504 | 3772 | 116057 | 41.5976 | -0.9057 | 2021-05-25 04:21:08 | Aragon, Spain | ||
83379 | 83379 | 2021-05-25 | Spain | Aragon | 123454 | 3503 | 3772 | 116179 | 41.5976 | -0.9057 | 2021-05-26 04:20:35 | Aragon, Spain | ||
1310453 | 1310453 | 2021-05-26 | Spain | Aragon | 123612 | 3505 | 3772 | 116335 | 41.5976 | -0.9057 | 2021-05-27 04:20:59 | Aragon, Spain | ||
1807030 | 1807030 | 2021-05-27 | Spain | Aragon | 123770 | 3506 | 3772 | 116492 | 41.5976 | -0.9057 | 2021-05-28 04:20:36 | Aragon, Spain | ||
20655 | 20655 | 2021-05-28 | Spain | Aragon | 123905 | 3504 | 3772 | 116629 | 41.5976 | -0.9057 | 2021-05-29 04:20:41 | Aragon, 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]);