⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

397 rows where country_or_region = "Spain" and province_or_state = "Aragon" sorted by day descending

View and edit SQL

Suggested facets: recovered, day (date), last_update (date)

province_or_state

  • Aragon · 397

country_or_region

  • Spain · 397
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
223213 2021-06-14 Spain Aragon     125662 3530 3772 118360 41.5976 -0.9057 2021-06-15 04:22:22 Aragon, Spain
215245 2021-06-13 Spain Aragon     125490 3530 3772 118188 41.5976 -0.9057 2021-06-14 04:22:46 Aragon, Spain
281815 2021-06-12 Spain Aragon     125490 3530 3772 118188 41.5976 -0.9057 2021-06-13 04:22:44 Aragon, Spain
1633914 2021-06-11 Spain Aragon     125490 3530 3772 118188 41.5976 -0.9057 2021-06-12 04:22:22 Aragon, Spain
663200 2021-06-10 Spain Aragon     125373 3525 3772 118076 41.5976 -0.9057 2021-06-11 04:23:20 Aragon, Spain
882304 2021-06-09 Spain Aragon     125270 3523 3772 117975 41.5976 -0.9057 2021-06-10 04:23:17 Aragon, Spain
1710303 2021-06-08 Spain Aragon     125159 3521 3772 117866 41.5976 -0.9057 2021-06-09 04:23:31 Aragon, Spain
1466147 2021-06-07 Spain Aragon     125083 3521 3772 117790 41.5976 -0.9057 2021-06-08 04:22:35 Aragon, Spain
993914 2021-06-06 Spain Aragon     124819 3517 3772 117530 41.5976 -0.9057 2021-06-07 04:22:51 Aragon, Spain
158704 2021-06-05 Spain Aragon     124819 3517 3772 117530 41.5976 -0.9057 2021-06-06 04:24:03 Aragon, Spain
1516689 2021-06-04 Spain Aragon     124819 3517 3772 117530 41.5976 -0.9057 2021-06-05 04:23:03 Aragon, Spain
1141000 2021-06-03 Spain Aragon     124671 3511 3772 117388 41.5976 -0.9057 2021-06-04 04:23:37 Aragon, Spain
427444 2021-06-02 Spain Aragon     124517 3511 3772 117234 41.5976 -0.9057 2021-06-03 04:23:32 Aragon, Spain
539951 2021-06-01 Spain Aragon     124368 3511 3772 117085 41.5976 -0.9057 2021-06-02 04:24:34 Aragon, Spain
787136 2021-05-31 Spain Aragon     124235 3509 3772 116954 41.5976 -0.9057 2021-06-01 04:23:09 Aragon, Spain
1330534 2021-05-30 Spain Aragon     123905 3504 3772 116629 41.5976 -0.9057 2021-05-31 03:08:59 Aragon, Spain
67743 2021-05-29 Spain Aragon     123905 3504 3772 116629 41.5976 -0.9057 2021-05-30 04:20:55 Aragon, Spain
195929 2021-05-28 Spain Aragon     123905 3504 3772 116629 41.5976 -0.9057 2021-05-29 04:20:41 Aragon, Spain
939188 2021-05-27 Spain Aragon     123770 3506 3772 116492 41.5976 -0.9057 2021-05-28 04:20:36 Aragon, Spain
1226862 2021-05-26 Spain Aragon     123612 3505 3772 116335 41.5976 -0.9057 2021-05-27 04:20:59 Aragon, Spain
1338501 2021-05-25 Spain Aragon     123454 3503 3772 116179 41.5976 -0.9057 2021-05-26 04:20:35 Aragon, Spain
203333 2021-05-24 Spain Aragon     123333 3504 3772 116057 41.5976 -0.9057 2021-05-25 04:21:08 Aragon, Spain
99497 2021-05-23 Spain Aragon     122929 3500 3772 115657 41.5976 -0.9057 2021-05-24 04:20:53 Aragon, Spain
524016 2021-05-22 Spain Aragon     122929 3500 3772 115657 41.5976 -0.9057 2021-05-23 04:20:51 Aragon, Spain
859711 2021-05-21 Spain Aragon     122929 3500 3772 115657 41.5976 -0.9057 2021-05-22 04:20:45 Aragon, Spain
721134 2021-05-20 Spain Aragon     122692 3496 3772 115424 41.5976 -0.9057 2021-05-21 04:20:43 Aragon, Spain
408265 2021-05-19 Spain Aragon     122451 3494 3772 115185 41.5976 -0.9057 2021-05-20 04:21:05 Aragon, Spain
783151 2021-05-18 Spain Aragon     122193 3490 3772 114931 41.5976 -0.9057 2021-05-19 04:20:42 Aragon, Spain
1423293 2021-05-17 Spain Aragon     122063 3492 3772 114799 41.5976 -0.9057 2021-05-18 04:20:33 Aragon, Spain
740479 2021-05-16 Spain Aragon     121653 3481 3772 114400 41.5976 -0.9057 2021-05-17 04:20:34 Aragon, Spain
1117012 2021-05-15 Spain Aragon     121653 3481 3772 114400 41.5976 -0.9057 2021-05-16 04:20:49 Aragon, Spain
1587521 2021-05-14 Spain Aragon     121653 3481 3772 114400 41.5976 -0.9057 2021-05-15 04:20:58 Aragon, Spain
1675438 2021-05-13 Spain Aragon     121429 3474 3772 114183 41.5976 -0.9057 2021-05-14 04:20:41 Aragon, Spain
803065 2021-05-12 Spain Aragon     121190 3473 3772 113945 41.5976 -0.9057 2021-05-13 04:20:51 Aragon, Spain
1181453 2021-05-11 Spain Aragon     120965 3463 3772 113730 41.5976 -0.9057 2021-05-12 04:21:29 Aragon, Spain
325243 2021-05-10 Spain Aragon     120814 3460 3772 113582 41.5976 -0.9057 2021-05-11 04:20:41 Aragon, Spain
604390 2021-05-09 Spain Aragon     120282 3452 3772 113058 41.5976 -0.9057 2021-05-10 04:20:38 Aragon, Spain
986137 2021-05-08 Spain Aragon     120282 3452 3772 113058 41.5976 -0.9057 2021-05-09 04:20:35 Aragon, Spain
434619 2021-05-07 Spain Aragon     120282 3452 3772 113058 41.5976 -0.9057 2021-05-08 04:21:04 Aragon, Spain
901400 2021-05-06 Spain Aragon     120025 3454 3772 112799 41.5976 -0.9057 2021-05-07 04:20:40 Aragon, Spain
71726 2021-05-05 Spain Aragon     119698 3454 3772 112472 41.5976 -0.9057 2021-05-06 04:20:38 Aragon, Spain
791119 2021-05-04 Spain Aragon     119340 3446 3772 112122 41.5976 -0.9057 2021-05-05 04:20:43 Aragon, Spain
1613649 2021-05-03 Spain Aragon     119153 3444 3772 111937 41.5976 -0.9057 2021-05-04 04:20:34 Aragon, Spain
886287 2021-05-02 Spain Aragon     118361 3437 3772 111152 41.5976 -0.9057 2021-05-03 04:20:39 Aragon, Spain
511992 2021-05-01 Spain Aragon     118361 3437 3772 111152 41.5976 -0.9057 2021-05-02 04:20:48 Aragon, Spain
14928 2021-04-30 Spain Aragon     118361 3437 3772 111152 41.5976 -0.9057 2021-05-01 04:20:47 Aragon, Spain
1125032 2021-04-29 Spain Aragon     117986 3437 3772 110777 41.5976 -0.9057 2021-04-30 04:21:03 Aragon, Spain
462329 2021-04-28 Spain Aragon     117618 3437 3772 110409 41.5976 -0.9057 2021-04-29 04:20:55 Aragon, Spain
1315035 2021-04-27 Spain Aragon     117255 3427 3772 110056 41.5976 -0.9057 2021-04-28 04:20:32 Aragon, Spain
1549462 2021-04-26 Spain Aragon     116959 3428 3772 109759 41.5976 -0.9057 2021-04-27 04:20:52 Aragon, Spain
1629929 2021-04-25 Spain Aragon     116374 3423 3772 109179 41.5976 -0.9057 2021-04-26 04:21:04 Aragon, Spain
354069 2021-04-24 Spain Aragon     116374 3423 3772 109179 41.5976 -0.9057 2021-04-25 04:20:32 Aragon, Spain
725118 2021-04-23 Spain Aragon     116374 3423 3772 109179 41.5976 -0.9057 2021-04-24 04:20:38 Aragon, Spain
1470130 2021-04-22 Spain Aragon     116084 3420 3772 108892 41.5976 -0.9057 2021-04-23 04:20:52 Aragon, Spain
1222878 2021-04-21 Spain Aragon     115746 3415 3772 108559 41.5976 -0.9057 2021-04-22 04:20:53 Aragon, Spain
458345 2021-04-20 Spain Aragon     115206 3407 3772 111995 41.5976 -0.9057 2021-04-21 04:21:14 Aragon, Spain
1300533 2021-04-19 Spain Aragon     115206 3407 3772 108027 41.5976 -0.9057 2021-04-20 04:20:41 Aragon, Spain
1070112 2021-04-18 Spain Aragon     114511 3393 3772 107346 41.5976 -0.9057 2021-04-19 04:20:57 Aragon, Spain
1045994 2021-04-17 Spain Aragon     114511 3393 3772 107346 41.5976 -0.9057 2021-04-18 04:20:41 Aragon, Spain
597270 2021-04-16 Spain Aragon     114511 3393 3772 107346 41.5976 -0.9057 2021-04-17 04:20:40 Aragon, Spain
1621686 2021-04-15 Spain Aragon     114218 3391 3772 107055 41.5976 -0.9057 2021-04-16 04:20:46 Aragon, Spain
951117 2021-04-14 Spain Aragon     113963 3391 3772 106800 41.5976 -0.9057 2021-04-15 04:20:54 Aragon, Spain
593286 2021-04-13 Spain Aragon     113630 3386 3772 106472 41.5976 -0.9057 2021-04-14 04:20:41 Aragon, Spain
33225 2021-04-12 Spain Aragon     113436 3384 3772 106280 41.5976 -0.9057 2021-04-13 04:20:37 Aragon, Spain
1372240 2021-04-11 Spain Aragon     112848 3375 3772 105701 41.5976 -0.9057 2021-04-12 04:21:00 Aragon, Spain
1667492 2021-04-10 Spain Aragon     112848 3375 3772 105701 41.5976 -0.9057 2021-04-11 04:20:56 Aragon, Spain
1160108 2021-04-09 Spain Aragon     112848 3375 3772 105701 41.5976 -0.9057 2021-04-10 04:20:59 Aragon, Spain
1057943 2021-04-08 Spain Aragon     112531 3371 3772 105388 41.5976 -0.9057 2021-04-09 04:21:13 Aragon, Spain
1500732 2021-04-07 Spain Aragon     112210 3364 3772 105074 41.5976 -0.9057 2021-04-08 04:21:13 Aragon, Spain
1207937 2021-04-06 Spain Aragon     111836 3358 3772 104706 41.5976 -0.9057 2021-04-07 04:20:53 Aragon, Spain
123238 2021-04-05 Spain Aragon     111611 3357 3772 104482 41.5976 -0.9057 2021-04-06 04:20:32 Aragon, Spain
1255039 2021-04-04 Spain Aragon     111339 3351 3772 104216 41.5976 -0.9057 2021-04-05 04:20:35 Aragon, Spain
1129016 2021-04-03 Spain Aragon     111339 3351 3772 104216 41.5976 -0.9057 2021-04-04 04:20:49 Aragon, Spain
270407 2021-04-02 Spain Aragon     111089 3348 3772 103969 41.5976 -0.9057 2021-04-03 04:20:44 Aragon, Spain
1173739 2021-04-01 Spain Aragon     111089 3348 3772 103969 41.5976 -0.9057 2021-04-02 04:20:36 Aragon, Spain
516050 2021-03-31 Spain Aragon     110894 3344 3772 103778 41.5976 -0.9057 2021-04-01 04:27:05 Aragon, Spain
289779 2021-03-30 Spain Aragon     110668 3339 3772 103557 41.5976 -0.9057 2021-03-31 04:26:25 Aragon, Spain
1575316 2021-03-29 Spain Aragon     110530 3334 3772 103424 41.5976 -0.9057 2021-03-30 04:26:23 Aragon, Spain
631593 2021-03-28 Spain Aragon     110163 3372 3772 103019 41.5976 -0.9057 2021-03-29 04:28:35 Aragon, Spain
608374 2021-03-27 Spain Aragon     110163 3372 3772 103019 41.5976 -0.9057 2021-03-28 05:28:10 Aragon, Spain
1334517 2021-03-26 Spain Aragon     110163 3372 3772 103019 41.5976 -0.9057 2021-03-27 05:25:04 Aragon, Spain
150956 2021-03-25 Spain Aragon     110002 3371 3772 102859 41.5976 -0.9057 2021-03-26 05:26:55 Aragon, Spain
1598477 2021-03-24 Spain Aragon     109683 3372 3772 102539 41.5976 -0.9057 2021-03-25 05:27:00 Aragon, Spain
404281 2021-03-23 Spain Aragon     109683 3372 3772 102539 41.5976 -0.9057 2021-03-24 05:25:40 Aragon, Spain
1387818 2021-03-22 Spain Aragon     109579 3365 3772 102442 41.5976 -0.9057 2021-03-23 05:26:18 Aragon, Spain
305305 2021-03-21 Spain Aragon     109093 3354 3772 101967 41.5976 -0.9057 2021-03-22 05:25:43 Aragon, Spain
254354 2021-03-20 Spain Aragon     109093 3354 3772 101967 41.5976 -0.9057 2021-03-21 05:25:44 Aragon, Spain
1231110 2021-03-19 Spain Aragon     109093 3354 3772 101967 41.5976 -0.9057 2021-03-20 05:25:46 Aragon, Spain
975035 2021-03-18 Spain Aragon     109093 3354 3772 101967 41.5976 -0.9057 2021-03-19 05:26:09 Aragon, Spain
1532670 2021-03-17 Spain Aragon     108940 3351 3772 101817 41.5976 -0.9057 2021-03-18 05:26:22 Aragon, Spain
55864 2021-03-16 Spain Aragon     108799 3343 3772 101684 41.5976 -0.9057 2021-03-17 05:25:07 Aragon, Spain
563177 2021-03-15 Spain Aragon     108693 3341 3772 101580 41.5976 -0.9057 2021-03-16 05:25:13 Aragon, Spain
851746 2021-03-14 Spain Aragon     108416 3333 3772 101311 41.5976 -0.9057 2021-03-15 05:25:51 Aragon, Spain
943171 2021-03-13 Spain Aragon     108416 3333 3772 101311 41.5976 -0.9057 2021-03-14 05:25:37 Aragon, Spain
1311051 2021-03-12 Spain Aragon     108416 3333 3772 101311 41.5976 -0.9057 2021-03-13 05:25:15 Aragon, Spain
1077889 2021-03-11 Spain Aragon     108265 3329 3772 101164 41.5976 -0.9057 2021-03-12 05:26:50 Aragon, Spain
955101 2021-03-10 Spain Aragon     108122 3320 3772 101030 41.5976 -0.9057 2021-03-11 05:25:48 Aragon, Spain
543934 2021-03-09 Spain Aragon     107954 3319 3772 100863 41.5976 -0.9057 2021-03-10 05:24:35 Aragon, Spain
1520672 2021-03-08 Spain Aragon     107850 3312 3772 100766 41.5976 -0.9057 2021-03-09 05:28:19 Aragon, Spain
866953 2021-03-07 Spain Aragon     107568 3303 3772 100493 41.5976 -0.9057 2021-03-08 05:24:48 Aragon, Spain

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);