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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- …
province_or_state 1
- Aragon · 393 ✖
country_or_region 1
- Spain · 393 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2717257 | 2717257 | 2021-06-10 | Spain | Aragon | 125373 | 3525 | 3772 | 118076 | 41.5976 | -0.9057 | 2021-06-11 04:23:20 | Aragon, Spain | ||
523142 | 523142 | 2021-06-09 | Spain | Aragon | 125270 | 3523 | 3772 | 117975 | 41.5976 | -0.9057 | 2021-06-10 04:23:17 | Aragon, Spain | ||
3472582 | 3472582 | 2021-06-08 | Spain | Aragon | 125159 | 3521 | 3772 | 117866 | 41.5976 | -0.9057 | 2021-06-09 04:23:31 | Aragon, Spain | ||
3145866 | 3145866 | 2021-06-07 | Spain | Aragon | 125083 | 3521 | 3772 | 117790 | 41.5976 | -0.9057 | 2021-06-08 04:22:35 | Aragon, Spain | ||
825868 | 825868 | 2021-06-06 | Spain | Aragon | 124819 | 3517 | 3772 | 117530 | 41.5976 | -0.9057 | 2021-06-07 04:22:51 | Aragon, Spain | ||
2586273 | 2586273 | 2021-06-05 | Spain | Aragon | 124819 | 3517 | 3772 | 117530 | 41.5976 | -0.9057 | 2021-06-06 04:24:03 | Aragon, Spain | ||
2315587 | 2315587 | 2021-06-04 | Spain | Aragon | 124819 | 3517 | 3772 | 117530 | 41.5976 | -0.9057 | 2021-06-05 04:23:03 | Aragon, Spain | ||
1448872 | 1448872 | 2021-06-03 | Spain | Aragon | 124671 | 3511 | 3772 | 117388 | 41.5976 | -0.9057 | 2021-06-04 04:23:37 | Aragon, Spain | ||
1708596 | 1708596 | 2021-06-02 | Spain | Aragon | 124517 | 3511 | 3772 | 117234 | 41.5976 | -0.9057 | 2021-06-03 04:23:32 | Aragon, Spain | ||
2104414 | 2104414 | 2021-06-01 | Spain | Aragon | 124368 | 3511 | 3772 | 117085 | 41.5976 | -0.9057 | 2021-06-02 04:24:34 | Aragon, Spain | ||
1189030 | 1189030 | 2021-05-31 | Spain | Aragon | 124235 | 3509 | 3772 | 116954 | 41.5976 | -0.9057 | 2021-06-01 04:23:09 | Aragon, Spain | ||
3089707 | 3089707 | 2021-05-30 | Spain | Aragon | 123905 | 3504 | 3772 | 116629 | 41.5976 | -0.9057 | 2021-05-31 03:08:59 | Aragon, Spain | ||
51076 | 51076 | 2021-05-29 | Spain | Aragon | 123905 | 3504 | 3772 | 116629 | 41.5976 | -0.9057 | 2021-05-30 04:20:55 | 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 | ||
1807030 | 1807030 | 2021-05-27 | Spain | Aragon | 123770 | 3506 | 3772 | 116492 | 41.5976 | -0.9057 | 2021-05-28 04:20:36 | 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 | ||
83379 | 83379 | 2021-05-25 | Spain | Aragon | 123454 | 3503 | 3772 | 116179 | 41.5976 | -0.9057 | 2021-05-26 04:20:35 | 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 | ||
1771627 | 1771627 | 2021-05-23 | Spain | Aragon | 122929 | 3500 | 3772 | 115657 | 41.5976 | -0.9057 | 2021-05-24 04:20:53 | 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 | ||
1952797 | 1952797 | 2021-05-21 | Spain | Aragon | 122929 | 3500 | 3772 | 115657 | 41.5976 | -0.9057 | 2021-05-22 04:20:45 | 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 | ||
2256017 | 2256017 | 2021-05-19 | Spain | Aragon | 122451 | 3494 | 3772 | 115185 | 41.5976 | -0.9057 | 2021-05-20 04:21:05 | 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 | ||
3574880 | 3574880 | 2021-05-17 | Spain | Aragon | 122063 | 3492 | 3772 | 114799 | 41.5976 | -0.9057 | 2021-05-18 04:20:33 | 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 | ||
1873240 | 1873240 | 2021-05-15 | Spain | Aragon | 121653 | 3481 | 3772 | 114400 | 41.5976 | -0.9057 | 2021-05-16 04:20:49 | 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 | ||
3054475 | 3054475 | 2021-05-13 | Spain | Aragon | 121429 | 3474 | 3772 | 114183 | 41.5976 | -0.9057 | 2021-05-14 04:20:41 | 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 | ||
3954776 | 3954776 | 2021-05-11 | Spain | Aragon | 120965 | 3463 | 3772 | 113730 | 41.5976 | -0.9057 | 2021-05-12 04:21:29 | 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 | ||
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 | ||
3113769 | 3113769 | 2021-05-06 | Spain | Aragon | 120025 | 3454 | 3772 | 112799 | 41.5976 | -0.9057 | 2021-05-07 04:20:40 | 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 | ||
3675936 | 3675936 | 2021-05-04 | Spain | Aragon | 119340 | 3446 | 3772 | 112122 | 41.5976 | -0.9057 | 2021-05-05 04:20:43 | 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 | ||
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 | ||
380477 | 380477 | 2021-04-30 | Spain | Aragon | 118361 | 3437 | 3772 | 111152 | 41.5976 | -0.9057 | 2021-05-01 04:20:47 | 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 | ||
3393679 | 3393679 | 2021-04-28 | Spain | Aragon | 117618 | 3437 | 3772 | 110409 | 41.5976 | -0.9057 | 2021-04-29 04:20:55 | 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 | ||
888404 | 888404 | 2021-04-26 | Spain | Aragon | 116959 | 3428 | 3772 | 109759 | 41.5976 | -0.9057 | 2021-04-27 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 | ||
3924296 | 3924296 | 2021-04-24 | Spain | Aragon | 116374 | 3423 | 3772 | 109179 | 41.5976 | -0.9057 | 2021-04-25 04:20:32 | 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 | ||
1568390 | 1568390 | 2021-04-22 | Spain | Aragon | 116084 | 3420 | 3772 | 108892 | 41.5976 | -0.9057 | 2021-04-23 04:20:52 | 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 | ||
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 | ||
3129805 | 3129805 | 2021-04-18 | Spain | Aragon | 114511 | 3393 | 3772 | 107346 | 41.5976 | -0.9057 | 2021-04-19 04:20:57 | 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 | ||
170328 | 170328 | 2021-04-16 | Spain | Aragon | 114511 | 3393 | 3772 | 107346 | 41.5976 | -0.9057 | 2021-04-17 04:20:40 | 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 | ||
1842229 | 1842229 | 2021-04-14 | Spain | Aragon | 113963 | 3391 | 3772 | 106800 | 41.5976 | -0.9057 | 2021-04-15 04:20:54 | 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 | ||
36714 | 36714 | 2021-04-12 | Spain | Aragon | 113436 | 3384 | 3772 | 106280 | 41.5976 | -0.9057 | 2021-04-13 04:20:37 | 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 | ||
2983541 | 2983541 | 2021-04-10 | Spain | Aragon | 112848 | 3375 | 3772 | 105701 | 41.5976 | -0.9057 | 2021-04-11 04:20:56 | 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 | ||
2646037 | 2646037 | 2021-04-08 | Spain | Aragon | 112531 | 3371 | 3772 | 105388 | 41.5976 | -0.9057 | 2021-04-09 04:21:13 | 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 | ||
3003589 | 3003589 | 2021-04-06 | Spain | Aragon | 111836 | 3358 | 3772 | 104706 | 41.5976 | -0.9057 | 2021-04-07 04:20:53 | 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 | ||
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 | ||
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 | ||
638208 | 638208 | 2021-03-31 | Spain | Aragon | 110894 | 3344 | 3772 | 103778 | 41.5976 | -0.9057 | 2021-04-01 04:27:05 | 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 | ||
1290290 | 1290290 | 2021-03-29 | Spain | Aragon | 110530 | 3334 | 3772 | 103424 | 41.5976 | -0.9057 | 2021-03-30 04:26:23 | 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 | ||
1219852 | 1219852 | 2021-03-27 | Spain | Aragon | 110163 | 3372 | 3772 | 103019 | 41.5976 | -0.9057 | 2021-03-28 05:28:10 | 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 | ||
1980900 | 1980900 | 2021-03-25 | Spain | Aragon | 110002 | 3371 | 3772 | 102859 | 41.5976 | -0.9057 | 2021-03-26 05:26:55 | 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 | ||
1798923 | 1798923 | 2021-03-23 | Spain | Aragon | 109683 | 3372 | 3772 | 102539 | 41.5976 | -0.9057 | 2021-03-24 05:25:40 | 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 | ||
3369613 | 3369613 | 2021-03-21 | Spain | Aragon | 109093 | 3354 | 3772 | 101967 | 41.5976 | -0.9057 | 2021-03-22 05:25:43 | 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 | ||
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 | ||
3621365 | 3621365 | 2021-03-17 | Spain | Aragon | 108940 | 3351 | 3772 | 101817 | 41.5976 | -0.9057 | 2021-03-18 05:26:22 | 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 | ||
2056167 | 2056167 | 2021-03-15 | Spain | Aragon | 108693 | 3341 | 3772 | 101580 | 41.5976 | -0.9057 | 2021-03-16 05:25:13 | 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 | ||
1580436 | 1580436 | 2021-03-13 | Spain | Aragon | 108416 | 3333 | 3772 | 101311 | 41.5976 | -0.9057 | 2021-03-14 05:25:37 | 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 | ||
352580 | 352580 | 2021-03-11 | Spain | Aragon | 108265 | 3329 | 3772 | 101164 | 41.5976 | -0.9057 | 2021-03-12 05:26:50 | 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 | ||
3663892 | 3663892 | 2021-03-09 | Spain | Aragon | 107954 | 3319 | 3772 | 100863 | 41.5976 | -0.9057 | 2021-03-10 05:24:35 | 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 | ||
55089 | 55089 | 2021-03-07 | Spain | Aragon | 107568 | 3303 | 3772 | 100493 | 41.5976 | -0.9057 | 2021-03-08 05:24:48 | 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 | ||
1616527 | 1616527 | 2021-03-05 | Spain | Aragon | 107568 | 3303 | 3772 | 100493 | 41.5976 | -0.9057 | 2021-03-06 04:23:41 | 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 | ||
1090359 | 1090359 | 2021-03-03 | Spain | Aragon | 107224 | 3286 | 3772 | 100166 | 41.5976 | -0.9057 | 2021-03-04 05:24:24 | 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]);