⚠️ 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 = "Ceuta" sorted by day descending

View and edit SQL

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

province_or_state

  • Ceuta · 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
223222 2021-06-14 Spain Ceuta     5968 116 163 5689 35.8894 -5.3213 2021-06-15 04:22:22 Ceuta, Spain
215254 2021-06-13 Spain Ceuta     5957 116 163 5678 35.8894 -5.3213 2021-06-14 04:22:46 Ceuta, Spain
281824 2021-06-12 Spain Ceuta     5957 116 163 5678 35.8894 -5.3213 2021-06-13 04:22:44 Ceuta, Spain
1633923 2021-06-11 Spain Ceuta     5957 116 163 5678 35.8894 -5.3213 2021-06-12 04:22:22 Ceuta, Spain
663209 2021-06-10 Spain Ceuta     5948 116 163 5669 35.8894 -5.3213 2021-06-11 04:23:20 Ceuta, Spain
882313 2021-06-09 Spain Ceuta     5946 116 163 5667 35.8894 -5.3213 2021-06-10 04:23:17 Ceuta, Spain
1710312 2021-06-08 Spain Ceuta     5943 116 163 5664 35.8894 -5.3213 2021-06-09 04:23:31 Ceuta, Spain
1466156 2021-06-07 Spain Ceuta     5943 116 163 5664 35.8894 -5.3213 2021-06-08 04:22:35 Ceuta, Spain
993923 2021-06-06 Spain Ceuta     5909 116 163 5630 35.8894 -5.3213 2021-06-07 04:22:51 Ceuta, Spain
158713 2021-06-05 Spain Ceuta     5909 116 163 5630 35.8894 -5.3213 2021-06-06 04:24:03 Ceuta, Spain
1516698 2021-06-04 Spain Ceuta     5909 115 163 5631 35.8894 -5.3213 2021-06-05 04:23:03 Ceuta, Spain
1141009 2021-06-03 Spain Ceuta     5909 115 163 5631 35.8894 -5.3213 2021-06-04 04:23:37 Ceuta, Spain
427453 2021-06-02 Spain Ceuta     5896 115 163 5618 35.8894 -5.3213 2021-06-03 04:23:32 Ceuta, Spain
539960 2021-06-01 Spain Ceuta     5879 115 163 5601 35.8894 -5.3213 2021-06-02 04:24:34 Ceuta, Spain
787145 2021-05-31 Spain Ceuta     5872 115 163 5594 35.8894 -5.3213 2021-06-01 04:23:09 Ceuta, Spain
1330543 2021-05-30 Spain Ceuta     5829 114 163 5552 35.8894 -5.3213 2021-05-31 03:08:59 Ceuta, Spain
67752 2021-05-29 Spain Ceuta     5829 114 163 5552 35.8894 -5.3213 2021-05-30 04:20:55 Ceuta, Spain
195938 2021-05-28 Spain Ceuta     5829 114 163 5552 35.8894 -5.3213 2021-05-29 04:20:41 Ceuta, Spain
939197 2021-05-27 Spain Ceuta     5826 114 163 5549 35.8894 -5.3213 2021-05-28 04:20:36 Ceuta, Spain
1226871 2021-05-26 Spain Ceuta     5817 114 163 5540 35.8894 -5.3213 2021-05-27 04:20:59 Ceuta, Spain
1338510 2021-05-25 Spain Ceuta     5810 114 163 5533 35.8894 -5.3213 2021-05-26 04:20:35 Ceuta, Spain
203342 2021-05-24 Spain Ceuta     5795 114 163 5518 35.8894 -5.3213 2021-05-25 04:21:08 Ceuta, Spain
99506 2021-05-23 Spain Ceuta     5790 114 163 5513 35.8894 -5.3213 2021-05-24 04:20:53 Ceuta, Spain
524025 2021-05-22 Spain Ceuta     5790 114 163 5513 35.8894 -5.3213 2021-05-23 04:20:51 Ceuta, Spain
859720 2021-05-21 Spain Ceuta     5790 114 163 5513 35.8894 -5.3213 2021-05-22 04:20:45 Ceuta, Spain
721143 2021-05-20 Spain Ceuta     5789 114 163 5512 35.8894 -5.3213 2021-05-21 04:20:43 Ceuta, Spain
408274 2021-05-19 Spain Ceuta     5780 114 163 5503 35.8894 -5.3213 2021-05-20 04:21:05 Ceuta, Spain
783160 2021-05-18 Spain Ceuta     5779 114 163 5502 35.8894 -5.3213 2021-05-19 04:20:42 Ceuta, Spain
1423302 2021-05-17 Spain Ceuta     5779 114 163 5502 35.8894 -5.3213 2021-05-18 04:20:33 Ceuta, Spain
740488 2021-05-16 Spain Ceuta     5776 113 163 5500 35.8894 -5.3213 2021-05-17 04:20:34 Ceuta, Spain
1117021 2021-05-15 Spain Ceuta     5776 113 163 5500 35.8894 -5.3213 2021-05-16 04:20:49 Ceuta, Spain
1587530 2021-05-14 Spain Ceuta     5776 113 163 5500 35.8894 -5.3213 2021-05-15 04:20:58 Ceuta, Spain
1675447 2021-05-13 Spain Ceuta     5773 113 163 5497 35.8894 -5.3213 2021-05-14 04:20:41 Ceuta, Spain
803074 2021-05-12 Spain Ceuta     5772 112 163 5497 35.8894 -5.3213 2021-05-13 04:20:51 Ceuta, Spain
1181462 2021-05-11 Spain Ceuta     5772 112 163 5497 35.8894 -5.3213 2021-05-12 04:21:29 Ceuta, Spain
325252 2021-05-10 Spain Ceuta     5771 112 163 5496 35.8894 -5.3213 2021-05-11 04:20:41 Ceuta, Spain
604399 2021-05-09 Spain Ceuta     5770 109 163 5498 35.8894 -5.3213 2021-05-10 04:20:38 Ceuta, Spain
986146 2021-05-08 Spain Ceuta     5770 109 163 5498 35.8894 -5.3213 2021-05-09 04:20:35 Ceuta, Spain
434628 2021-05-07 Spain Ceuta     5770 109 163 5498 35.8894 -5.3213 2021-05-08 04:21:04 Ceuta, Spain
901409 2021-05-06 Spain Ceuta     5769 109 163 5497 35.8894 -5.3213 2021-05-07 04:20:40 Ceuta, Spain
71735 2021-05-05 Spain Ceuta     5768 108 163 5497 35.8894 -5.3213 2021-05-06 04:20:38 Ceuta, Spain
791128 2021-05-04 Spain Ceuta     5766 107 163 5496 35.8894 -5.3213 2021-05-05 04:20:43 Ceuta, Spain
1613658 2021-05-03 Spain Ceuta     5764 106 163 5495 35.8894 -5.3213 2021-05-04 04:20:34 Ceuta, Spain
886296 2021-05-02 Spain Ceuta     5753 104 163 5486 35.8894 -5.3213 2021-05-03 04:20:39 Ceuta, Spain
512001 2021-05-01 Spain Ceuta     5753 104 163 5486 35.8894 -5.3213 2021-05-02 04:20:48 Ceuta, Spain
14937 2021-04-30 Spain Ceuta     5753 104 163 5486 35.8894 -5.3213 2021-05-01 04:20:47 Ceuta, Spain
1125041 2021-04-29 Spain Ceuta     5751 104 163 5484 35.8894 -5.3213 2021-04-30 04:21:03 Ceuta, Spain
462338 2021-04-28 Spain Ceuta     5746 104 163 5479 35.8894 -5.3213 2021-04-29 04:20:55 Ceuta, Spain
1315044 2021-04-27 Spain Ceuta     5736 104 163 5469 35.8894 -5.3213 2021-04-28 04:20:32 Ceuta, Spain
1549471 2021-04-26 Spain Ceuta     5725 103 163 5459 35.8894 -5.3213 2021-04-27 04:20:52 Ceuta, Spain
1629938 2021-04-25 Spain Ceuta     5699 103 163 5433 35.8894 -5.3213 2021-04-26 04:21:04 Ceuta, Spain
354078 2021-04-24 Spain Ceuta     5699 103 163 5433 35.8894 -5.3213 2021-04-25 04:20:32 Ceuta, Spain
725127 2021-04-23 Spain Ceuta     5699 103 163 5433 35.8894 -5.3213 2021-04-24 04:20:38 Ceuta, Spain
1470139 2021-04-22 Spain Ceuta     5682 102 163 5417 35.8894 -5.3213 2021-04-23 04:20:52 Ceuta, Spain
1222887 2021-04-21 Spain Ceuta     5664 101 163 5400 35.8894 -5.3213 2021-04-22 04:20:53 Ceuta, Spain
458354 2021-04-20 Spain Ceuta     5639 101 163 5549 35.8894 -5.3213 2021-04-21 04:21:14 Ceuta, Spain
1300542 2021-04-19 Spain Ceuta     5639 101 163 5375 35.8894 -5.3213 2021-04-20 04:20:41 Ceuta, Spain
1070121 2021-04-18 Spain Ceuta     5589 100 163 5326 35.8894 -5.3213 2021-04-19 04:20:57 Ceuta, Spain
1046003 2021-04-17 Spain Ceuta     5589 100 163 5326 35.8894 -5.3213 2021-04-18 04:20:41 Ceuta, Spain
597279 2021-04-16 Spain Ceuta     5589 100 163 5326 35.8894 -5.3213 2021-04-17 04:20:40 Ceuta, Spain
1621695 2021-04-15 Spain Ceuta     5573 99 163 5311 35.8894 -5.3213 2021-04-16 04:20:46 Ceuta, Spain
951126 2021-04-14 Spain Ceuta     5561 99 163 5299 35.8894 -5.3213 2021-04-15 04:20:54 Ceuta, Spain
593295 2021-04-13 Spain Ceuta     5515 99 163 5253 35.8894 -5.3213 2021-04-14 04:20:41 Ceuta, Spain
33234 2021-04-12 Spain Ceuta     5489 99 163 5227 35.8894 -5.3213 2021-04-13 04:20:37 Ceuta, Spain
1372249 2021-04-11 Spain Ceuta     5416 99 163 5154 35.8894 -5.3213 2021-04-12 04:21:00 Ceuta, Spain
1667501 2021-04-10 Spain Ceuta     5416 99 163 5154 35.8894 -5.3213 2021-04-11 04:20:56 Ceuta, Spain
1160117 2021-04-09 Spain Ceuta     5416 99 163 5154 35.8894 -5.3213 2021-04-10 04:20:59 Ceuta, Spain
1057952 2021-04-08 Spain Ceuta     5373 99 163 5111 35.8894 -5.3213 2021-04-09 04:21:13 Ceuta, Spain
1500741 2021-04-07 Spain Ceuta     5327 98 163 5066 35.8894 -5.3213 2021-04-08 04:21:13 Ceuta, Spain
1207946 2021-04-06 Spain Ceuta     5294 98 163 5033 35.8894 -5.3213 2021-04-07 04:20:53 Ceuta, Spain
123247 2021-04-05 Spain Ceuta     5258 98 163 4997 35.8894 -5.3213 2021-04-06 04:20:32 Ceuta, Spain
1255048 2021-04-04 Spain Ceuta     5203 96 163 4944 35.8894 -5.3213 2021-04-05 04:20:35 Ceuta, Spain
1129025 2021-04-03 Spain Ceuta     5203 96 163 4944 35.8894 -5.3213 2021-04-04 04:20:49 Ceuta, Spain
270416 2021-04-02 Spain Ceuta     5155 96 163 4896 35.8894 -5.3213 2021-04-03 04:20:44 Ceuta, Spain
1173748 2021-04-01 Spain Ceuta     5155 96 163 4896 35.8894 -5.3213 2021-04-02 04:20:36 Ceuta, Spain
516059 2021-03-31 Spain Ceuta     5121 95 163 4863 35.8894 -5.3213 2021-04-01 04:27:05 Ceuta, Spain
289788 2021-03-30 Spain Ceuta     5094 95 163 4836 35.8894 -5.3213 2021-03-31 04:26:25 Ceuta, Spain
1575325 2021-03-29 Spain Ceuta     5066 93 163 4810 35.8894 -5.3213 2021-03-30 04:26:23 Ceuta, Spain
631602 2021-03-28 Spain Ceuta     5023 93 163 4767 35.8894 -5.3213 2021-03-29 04:28:35 Ceuta, Spain
608383 2021-03-27 Spain Ceuta     5023 93 163 4767 35.8894 -5.3213 2021-03-28 05:28:10 Ceuta, Spain
1334526 2021-03-26 Spain Ceuta     5023 93 163 4767 35.8894 -5.3213 2021-03-27 05:25:04 Ceuta, Spain
150965 2021-03-25 Spain Ceuta     5008 93 163 4752 35.8894 -5.3213 2021-03-26 05:26:55 Ceuta, Spain
1598486 2021-03-24 Spain Ceuta     4984 93 163 4728 35.8894 -5.3213 2021-03-25 05:27:00 Ceuta, Spain
404290 2021-03-23 Spain Ceuta     4984 93 163 4728 35.8894 -5.3213 2021-03-24 05:25:40 Ceuta, Spain
1387827 2021-03-22 Spain Ceuta     4970 91 163 4716 35.8894 -5.3213 2021-03-23 05:26:18 Ceuta, Spain
305314 2021-03-21 Spain Ceuta     4906 88 163 4655 35.8894 -5.3213 2021-03-22 05:25:43 Ceuta, Spain
254363 2021-03-20 Spain Ceuta     4906 88 163 4655 35.8894 -5.3213 2021-03-21 05:25:44 Ceuta, Spain
1231119 2021-03-19 Spain Ceuta     4906 88 163 4655 35.8894 -5.3213 2021-03-20 05:25:46 Ceuta, Spain
975044 2021-03-18 Spain Ceuta     4906 88 163 4655 35.8894 -5.3213 2021-03-19 05:26:09 Ceuta, Spain
1532679 2021-03-17 Spain Ceuta     4872 87 163 4622 35.8894 -5.3213 2021-03-18 05:26:22 Ceuta, Spain
55873 2021-03-16 Spain Ceuta     4856 87 163 4606 35.8894 -5.3213 2021-03-17 05:25:07 Ceuta, Spain
563186 2021-03-15 Spain Ceuta     4837 87 163 4587 35.8894 -5.3213 2021-03-16 05:25:13 Ceuta, Spain
851755 2021-03-14 Spain Ceuta     4802 87 163 4552 35.8894 -5.3213 2021-03-15 05:25:51 Ceuta, Spain
943180 2021-03-13 Spain Ceuta     4802 87 163 4552 35.8894 -5.3213 2021-03-14 05:25:37 Ceuta, Spain
1311060 2021-03-12 Spain Ceuta     4802 87 163 4552 35.8894 -5.3213 2021-03-13 05:25:15 Ceuta, Spain
1077898 2021-03-11 Spain Ceuta     4796 86 163 4547 35.8894 -5.3213 2021-03-12 05:26:50 Ceuta, Spain
955110 2021-03-10 Spain Ceuta     4781 86 163 4532 35.8894 -5.3213 2021-03-11 05:25:48 Ceuta, Spain
543943 2021-03-09 Spain Ceuta     4767 86 163 4518 35.8894 -5.3213 2021-03-10 05:24:35 Ceuta, Spain
1520681 2021-03-08 Spain Ceuta     4752 86 163 4503 35.8894 -5.3213 2021-03-09 05:28:19 Ceuta, Spain
866962 2021-03-07 Spain Ceuta     4723 86 163 4474 35.8894 -5.3213 2021-03-08 05:24:48 Ceuta, 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]);