⚠️ 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

402 rows where country_or_region = "Spain" and province_or_state = "Melilla" sorted by day descending

View and edit SQL

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

province_or_state

  • Melilla · 402

country_or_region

  • Spain · 402
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168762 2021-06-19 Spain Melilla     9222 97 125 9000 35.2923 -2.9381 2021-06-20 04:21:48 Melilla, Spain
686287 2021-06-18 Spain Melilla     9222 97 125 9000 35.2923 -2.9381 2021-06-19 04:22:33 Melilla, Spain
958344 2021-06-17 Spain Melilla     9212 97 125 8990 35.2923 -2.9381 2021-06-18 04:22:16 Melilla, Spain
1281709 2021-06-16 Spain Melilla     9209 97 125 8987 35.2923 -2.9381 2021-06-17 04:22:36 Melilla, Spain
682299 2021-06-15 Spain Melilla     9207 97 125 8985 35.2923 -2.9381 2021-06-16 04:22:32 Melilla, Spain
372853 2021-06-14 Spain Melilla     9206 97 125 8984 35.2923 -2.9381 2021-06-15 04:22:22 Melilla, Spain
1223669 2021-06-13 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-14 04:22:46 Melilla, Spain
80950 2021-06-12 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-13 04:22:44 Melilla, Spain
970253 2021-06-11 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-12 04:22:22 Melilla, Spain
1438826 2021-06-10 Spain Melilla     9201 97 125 8979 35.2923 -2.9381 2021-06-11 04:23:20 Melilla, Spain
1157325 2021-06-09 Spain Melilla     9200 97 125 8978 35.2923 -2.9381 2021-06-10 04:23:17 Melilla, Spain
1231641 2021-06-08 Spain Melilla     9190 97 125 8968 35.2923 -2.9381 2021-06-09 04:23:31 Melilla, Spain
360637 2021-06-07 Spain Melilla     9176 97 125 8954 35.2923 -2.9381 2021-06-08 04:22:35 Melilla, Spain
1076265 2021-06-06 Spain Melilla     9165 97 125 8943 35.2923 -2.9381 2021-06-07 04:22:51 Melilla, Spain
1613657 2021-06-05 Spain Melilla     9165 97 125 8943 35.2923 -2.9381 2021-06-06 04:24:03 Melilla, Spain
1125943 2021-06-04 Spain Melilla     9165 97 125 8943 35.2923 -2.9381 2021-06-05 04:23:03 Melilla, Spain
318399 2021-06-03 Spain Melilla     9156 97 125 8934 35.2923 -2.9381 2021-06-04 04:23:37 Melilla, Spain
1133912 2021-06-02 Spain Melilla     9148 97 125 8926 35.2923 -2.9381 2021-06-03 04:23:32 Melilla, Spain
292089 2021-06-01 Spain Melilla     9137 97 125 8915 35.2923 -2.9381 2021-06-02 04:24:34 Melilla, Spain
1652040 2021-05-31 Spain Melilla     9124 97 125 8902 35.2923 -2.9381 2021-06-01 04:23:09 Melilla, Spain
981268 2021-05-30 Spain Melilla     9098 97 125 8876 35.2923 -2.9381 2021-05-31 03:08:59 Melilla, Spain
841649 2021-05-29 Spain Melilla     9098 97 125 8876 35.2923 -2.9381 2021-05-30 04:20:55 Melilla, Spain
698221 2021-05-28 Spain Melilla     9098 97 125 8876 35.2923 -2.9381 2021-05-29 04:20:41 Melilla, Spain
1369722 2021-05-27 Spain Melilla     9088 97 125 8866 35.2923 -2.9381 2021-05-28 04:20:36 Melilla, Spain
1292806 2021-05-26 Spain Melilla     9073 97 125 8851 35.2923 -2.9381 2021-05-27 04:20:59 Melilla, Spain
603177 2021-05-25 Spain Melilla     9064 97 125 8842 35.2923 -2.9381 2021-05-26 04:20:35 Melilla, Spain
1365735 2021-05-24 Spain Melilla     9043 97 125 8821 35.2923 -2.9381 2021-05-25 04:21:08 Melilla, Spain
420248 2021-05-23 Spain Melilla     9019 97 125 8797 35.2923 -2.9381 2021-05-24 04:20:53 Melilla, Spain
54587 2021-05-22 Spain Melilla     9019 97 125 8797 35.2923 -2.9381 2021-05-23 04:20:51 Melilla, Spain
368866 2021-05-21 Spain Melilla     9019 97 125 8797 35.2923 -2.9381 2021-05-22 04:20:45 Melilla, Spain
1024665 2021-05-20 Spain Melilla     9004 97 125 8782 35.2923 -2.9381 2021-05-21 04:20:43 Melilla, Spain
1679291 2021-05-19 Spain Melilla     8990 97 125 8768 35.2923 -2.9381 2021-05-20 04:21:05 Melilla, Spain
65278 2021-05-18 Spain Melilla     8983 97 125 8761 35.2923 -2.9381 2021-05-19 04:20:42 Melilla, Spain
1243350 2021-05-17 Spain Melilla     8962 97 125 8740 35.2923 -2.9381 2021-05-18 04:20:33 Melilla, Spain
1068198 2021-05-16 Spain Melilla     8932 96 125 8711 35.2923 -2.9381 2021-05-17 04:20:34 Melilla, Spain
505326 2021-05-15 Spain Melilla     8932 96 125 8711 35.2923 -2.9381 2021-05-16 04:20:49 Melilla, Spain
892931 2021-05-14 Spain Melilla     8932 96 125 8711 35.2923 -2.9381 2021-05-15 04:20:58 Melilla, Spain
532266 2021-05-13 Spain Melilla     8924 96 125 8703 35.2923 -2.9381 2021-05-14 04:20:41 Melilla, Spain
1719553 2021-05-12 Spain Melilla     8913 96 125 8692 35.2923 -2.9381 2021-05-13 04:20:51 Melilla, Spain
1723539 2021-05-11 Spain Melilla     8892 96 125 8671 35.2923 -2.9381 2021-05-12 04:21:29 Melilla, Spain
1165296 2021-05-10 Spain Melilla     8866 95 125 8646 35.2923 -2.9381 2021-05-11 04:20:41 Melilla, Spain
1169282 2021-05-09 Spain Melilla     8826 94 125 8607 35.2923 -2.9381 2021-05-10 04:20:38 Melilla, Spain
1660069 2021-05-08 Spain Melilla     8826 94 125 8607 35.2923 -2.9381 2021-05-09 04:20:35 Melilla, Spain
800167 2021-05-07 Spain Melilla     8826 94 125 8607 35.2923 -2.9381 2021-05-08 04:21:04 Melilla, Spain
1219682 2021-05-06 Spain Melilla     8787 93 125 8569 35.2923 -2.9381 2021-05-07 04:20:40 Melilla, Spain
416262 2021-05-05 Spain Melilla     8772 92 125 8555 35.2923 -2.9381 2021-05-06 04:20:38 Melilla, Spain
674283 2021-05-04 Spain Melilla     8753 90 125 8538 35.2923 -2.9381 2021-05-05 04:20:43 Melilla, Spain
1088307 2021-05-03 Spain Melilla     8735 89 125 8521 35.2923 -2.9381 2021-05-04 04:20:34 Melilla, Spain
1727525 2021-05-02 Spain Melilla     8705 89 125 8491 35.2923 -2.9381 2021-05-03 04:20:39 Melilla, Spain
1084321 2021-05-01 Spain Melilla     8705 89 125 8491 35.2923 -2.9381 2021-05-02 04:20:48 Melilla, Spain
1388849 2021-04-30 Spain Melilla     8705 89 125 8491 35.2923 -2.9381 2021-05-01 04:20:47 Melilla, Spain
38668 2021-04-29 Spain Melilla     8693 89 125 8479 35.2923 -2.9381 2021-04-30 04:21:03 Melilla, Spain
12241 2021-04-28 Spain Melilla     8677 89 125 8463 35.2923 -2.9381 2021-04-29 04:20:55 Melilla, Spain
853624 2021-04-27 Spain Melilla     8650 89 125 8436 35.2923 -2.9381 2021-04-28 04:20:32 Melilla, Spain
1064212 2021-04-26 Spain Melilla     8636 89 125 8422 35.2923 -2.9381 2021-04-27 04:20:52 Melilla, Spain
1476462 2021-04-25 Spain Melilla     8563 88 125 8350 35.2923 -2.9381 2021-04-26 04:21:04 Melilla, Spain
744083 2021-04-24 Spain Melilla     8563 88 125 8350 35.2923 -2.9381 2021-04-25 04:20:32 Melilla, Spain
1430882 2021-04-23 Spain Melilla     8563 88 125 8350 35.2923 -2.9381 2021-04-24 04:20:38 Melilla, Spain
96711 2021-04-22 Spain Melilla     8518 88 125 8305 35.2923 -2.9381 2021-04-23 04:20:52 Melilla, Spain
849638 2021-04-21 Spain Melilla     8485 88 125 8272 35.2923 -2.9381 2021-04-22 04:20:53 Melilla, Spain
827256 2021-04-20 Spain Melilla     8430 86 125 8362 35.2923 -2.9381 2021-04-21 04:21:14 Melilla, Spain
770967 2021-04-19 Spain Melilla     8430 86 125 8219 35.2923 -2.9381 2021-04-20 04:20:41 Melilla, Spain
1416276 2021-04-18 Spain Melilla     8384 86 125 8173 35.2923 -2.9381 2021-04-19 04:20:57 Melilla, Spain
985253 2021-04-17 Spain Melilla     8384 86 125 8173 35.2923 -2.9381 2021-04-18 04:20:41 Melilla, Spain
238316 2021-04-16 Spain Melilla     8384 86 125 8173 35.2923 -2.9381 2021-04-17 04:20:40 Melilla, Spain
580045 2021-04-15 Spain Melilla     8349 86 125 8138 35.2923 -2.9381 2021-04-16 04:20:46 Melilla, Spain
1266673 2021-04-14 Spain Melilla     8318 86 125 8107 35.2923 -2.9381 2021-04-15 04:20:54 Melilla, Spain
702206 2021-04-13 Spain Melilla     8279 85 125 8069 35.2923 -2.9381 2021-04-14 04:20:41 Melilla, Spain
1671319 2021-04-12 Spain Melilla     8254 85 125 8044 35.2923 -2.9381 2021-04-13 04:20:37 Melilla, Spain
785024 2021-04-11 Spain Melilla     8159 84 125 7950 35.2923 -2.9381 2021-04-12 04:21:00 Melilla, Spain
1392835 2021-04-10 Spain Melilla     8159 84 125 7950 35.2923 -2.9381 2021-04-11 04:20:56 Melilla, Spain
966266 2021-04-09 Spain Melilla     8159 84 125 7950 35.2923 -2.9381 2021-04-10 04:20:59 Melilla, Spain
690270 2021-04-08 Spain Melilla     8120 84 125 7911 35.2923 -2.9381 2021-04-09 04:21:13 Melilla, Spain
1277722 2021-04-07 Spain Melilla     8072 83 125 7864 35.2923 -2.9381 2021-04-08 04:21:13 Melilla, Spain
88741 2021-04-06 Spain Melilla     8015 83 125 7807 35.2923 -2.9381 2021-04-07 04:20:53 Melilla, Spain
123123 2021-04-05 Spain Melilla     7976 82 125 7769 35.2923 -2.9381 2021-04-06 04:20:32 Melilla, Spain
73625 2021-04-04 Spain Melilla     7935 82 125 7728 35.2923 -2.9381 2021-04-05 04:20:35 Melilla, Spain
792241 2021-04-03 Spain Melilla     7935 82 125 7728 35.2923 -2.9381 2021-04-04 04:20:49 Melilla, Spain
1020679 2021-04-02 Spain Melilla     7904 79 125 7700 35.2923 -2.9381 2021-04-03 04:20:44 Melilla, Spain
1350841 2021-04-01 Spain Melilla     7904 79 125 7700 35.2923 -2.9381 2021-04-02 04:20:36 Melilla, Spain
1691227 2021-03-31 Spain Melilla     7861 79 125 7657 35.2923 -2.9381 2021-04-01 04:27:05 Melilla, Spain
873596 2021-03-30 Spain Melilla     7827 79 125 7623 35.2923 -2.9381 2021-03-31 04:26:25 Melilla, Spain
1400643 2021-03-29 Spain Melilla     7783 79 125 7579 35.2923 -2.9381 2021-03-30 04:26:23 Melilla, Spain
1625046 2021-03-28 Spain Melilla     7726 78 125 7523 35.2923 -2.9381 2021-03-29 04:28:35 Melilla, Spain
1472476 2021-03-27 Spain Melilla     7726 78 125 7523 35.2923 -2.9381 2021-03-28 05:28:10 Melilla, Spain
721023 2021-03-26 Spain Melilla     7726 78 125 7523 35.2923 -2.9381 2021-03-27 05:25:04 Melilla, Spain
1617642 2021-03-25 Spain Melilla     7699 78 125 7496 35.2923 -2.9381 2021-03-26 05:26:55 Melilla, Spain
470303 2021-03-24 Spain Melilla     7634 78 125 7431 35.2923 -2.9381 2021-03-25 05:27:00 Melilla, Spain
1585343 2021-03-23 Spain Melilla     7634 78 125 7431 35.2923 -2.9381 2021-03-24 05:25:40 Melilla, Spain
717037 2021-03-22 Spain Melilla     7602 78 125 7399 35.2923 -2.9381 2021-03-23 05:26:18 Melilla, Spain
1675305 2021-03-21 Spain Melilla     7489 77 125 7287 35.2923 -2.9381 2021-03-22 05:25:43 Melilla, Spain
1747244 2021-03-20 Spain Melilla     7489 77 125 7287 35.2923 -2.9381 2021-03-21 05:25:44 Melilla, Spain
230366 2021-03-19 Spain Melilla     7489 77 125 7287 35.2923 -2.9381 2021-03-20 05:25:46 Melilla, Spain
478301 2021-03-18 Spain Melilla     7489 77 125 7287 35.2923 -2.9381 2021-03-19 05:26:09 Melilla, Spain
1426896 2021-03-17 Spain Melilla     7443 76 125 7242 35.2923 -2.9381 2021-03-18 05:26:22 Melilla, Spain
1593484 2021-03-16 Spain Melilla     7394 76 125 7193 35.2923 -2.9381 2021-03-17 05:25:07 Melilla, Spain
1176483 2021-03-15 Spain Melilla     7345 76 125 7144 35.2923 -2.9381 2021-03-16 05:25:13 Melilla, Spain
276168 2021-03-14 Spain Melilla     7281 74 125 7082 35.2923 -2.9381 2021-03-15 05:25:51 Melilla, Spain
1161310 2021-03-13 Spain Melilla     7281 74 125 7082 35.2923 -2.9381 2021-03-14 05:25:37 Melilla, Spain
22817 2021-03-12 Spain Melilla     7281 74 125 7082 35.2923 -2.9381 2021-03-13 05:25:15 Melilla, 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]);