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 = "Ceuta" 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
- Ceuta · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2717266 | 2717266 | 2021-06-10 | Spain | Ceuta | 5948 | 116 | 163 | 5669 | 35.8894 | -5.3213 | 2021-06-11 04:23:20 | Ceuta, Spain | ||
523151 | 523151 | 2021-06-09 | Spain | Ceuta | 5946 | 116 | 163 | 5667 | 35.8894 | -5.3213 | 2021-06-10 04:23:17 | Ceuta, Spain | ||
3472591 | 3472591 | 2021-06-08 | Spain | Ceuta | 5943 | 116 | 163 | 5664 | 35.8894 | -5.3213 | 2021-06-09 04:23:31 | Ceuta, Spain | ||
3145875 | 3145875 | 2021-06-07 | Spain | Ceuta | 5943 | 116 | 163 | 5664 | 35.8894 | -5.3213 | 2021-06-08 04:22:35 | Ceuta, Spain | ||
825877 | 825877 | 2021-06-06 | Spain | Ceuta | 5909 | 116 | 163 | 5630 | 35.8894 | -5.3213 | 2021-06-07 04:22:51 | Ceuta, Spain | ||
2586282 | 2586282 | 2021-06-05 | Spain | Ceuta | 5909 | 116 | 163 | 5630 | 35.8894 | -5.3213 | 2021-06-06 04:24:03 | Ceuta, Spain | ||
2315596 | 2315596 | 2021-06-04 | Spain | Ceuta | 5909 | 115 | 163 | 5631 | 35.8894 | -5.3213 | 2021-06-05 04:23:03 | Ceuta, Spain | ||
1448881 | 1448881 | 2021-06-03 | Spain | Ceuta | 5909 | 115 | 163 | 5631 | 35.8894 | -5.3213 | 2021-06-04 04:23:37 | Ceuta, Spain | ||
1708605 | 1708605 | 2021-06-02 | Spain | Ceuta | 5896 | 115 | 163 | 5618 | 35.8894 | -5.3213 | 2021-06-03 04:23:32 | Ceuta, Spain | ||
2104423 | 2104423 | 2021-06-01 | Spain | Ceuta | 5879 | 115 | 163 | 5601 | 35.8894 | -5.3213 | 2021-06-02 04:24:34 | Ceuta, Spain | ||
1189039 | 1189039 | 2021-05-31 | Spain | Ceuta | 5872 | 115 | 163 | 5594 | 35.8894 | -5.3213 | 2021-06-01 04:23:09 | Ceuta, Spain | ||
3089716 | 3089716 | 2021-05-30 | Spain | Ceuta | 5829 | 114 | 163 | 5552 | 35.8894 | -5.3213 | 2021-05-31 03:08:59 | Ceuta, Spain | ||
51085 | 51085 | 2021-05-29 | Spain | Ceuta | 5829 | 114 | 163 | 5552 | 35.8894 | -5.3213 | 2021-05-30 04:20:55 | Ceuta, Spain | ||
20664 | 20664 | 2021-05-28 | Spain | Ceuta | 5829 | 114 | 163 | 5552 | 35.8894 | -5.3213 | 2021-05-29 04:20:41 | Ceuta, Spain | ||
1807039 | 1807039 | 2021-05-27 | Spain | Ceuta | 5826 | 114 | 163 | 5549 | 35.8894 | -5.3213 | 2021-05-28 04:20:36 | Ceuta, Spain | ||
1310462 | 1310462 | 2021-05-26 | Spain | Ceuta | 5817 | 114 | 163 | 5540 | 35.8894 | -5.3213 | 2021-05-27 04:20:59 | Ceuta, Spain | ||
83388 | 83388 | 2021-05-25 | Spain | Ceuta | 5810 | 114 | 163 | 5533 | 35.8894 | -5.3213 | 2021-05-26 04:20:35 | Ceuta, Spain | ||
1413350 | 1413350 | 2021-05-24 | Spain | Ceuta | 5795 | 114 | 163 | 5518 | 35.8894 | -5.3213 | 2021-05-25 04:21:08 | Ceuta, Spain | ||
1771636 | 1771636 | 2021-05-23 | Spain | Ceuta | 5790 | 114 | 163 | 5513 | 35.8894 | -5.3213 | 2021-05-24 04:20:53 | Ceuta, Spain | ||
726791 | 726791 | 2021-05-22 | Spain | Ceuta | 5790 | 114 | 163 | 5513 | 35.8894 | -5.3213 | 2021-05-23 04:20:51 | Ceuta, Spain | ||
1952806 | 1952806 | 2021-05-21 | Spain | Ceuta | 5790 | 114 | 163 | 5513 | 35.8894 | -5.3213 | 2021-05-22 04:20:45 | Ceuta, Spain | ||
1913505 | 1913505 | 2021-05-20 | Spain | Ceuta | 5789 | 114 | 163 | 5512 | 35.8894 | -5.3213 | 2021-05-21 04:20:43 | Ceuta, Spain | ||
2256026 | 2256026 | 2021-05-19 | Spain | Ceuta | 5780 | 114 | 163 | 5503 | 35.8894 | -5.3213 | 2021-05-20 04:21:05 | Ceuta, Spain | ||
2391064 | 2391064 | 2021-05-18 | Spain | Ceuta | 5779 | 114 | 163 | 5502 | 35.8894 | -5.3213 | 2021-05-19 04:20:42 | Ceuta, Spain | ||
3574889 | 3574889 | 2021-05-17 | Spain | Ceuta | 5779 | 114 | 163 | 5502 | 35.8894 | -5.3213 | 2021-05-18 04:20:33 | Ceuta, Spain | ||
2939619 | 2939619 | 2021-05-16 | Spain | Ceuta | 5776 | 113 | 163 | 5500 | 35.8894 | -5.3213 | 2021-05-17 04:20:34 | Ceuta, Spain | ||
1873249 | 1873249 | 2021-05-15 | Spain | Ceuta | 5776 | 113 | 163 | 5500 | 35.8894 | -5.3213 | 2021-05-16 04:20:49 | Ceuta, Spain | ||
1082218 | 1082218 | 2021-05-14 | Spain | Ceuta | 5776 | 113 | 163 | 5500 | 35.8894 | -5.3213 | 2021-05-15 04:20:58 | Ceuta, Spain | ||
3054484 | 3054484 | 2021-05-13 | Spain | Ceuta | 5773 | 113 | 163 | 5497 | 35.8894 | -5.3213 | 2021-05-14 04:20:41 | Ceuta, Spain | ||
2004954 | 2004954 | 2021-05-12 | Spain | Ceuta | 5772 | 112 | 163 | 5497 | 35.8894 | -5.3213 | 2021-05-13 04:20:51 | Ceuta, Spain | ||
3954785 | 3954785 | 2021-05-11 | Spain | Ceuta | 5772 | 112 | 163 | 5497 | 35.8894 | -5.3213 | 2021-05-12 04:21:29 | Ceuta, Spain | ||
2821064 | 2821064 | 2021-05-10 | Spain | Ceuta | 5771 | 112 | 163 | 5496 | 35.8894 | -5.3213 | 2021-05-11 04:20:41 | Ceuta, Spain | ||
1425396 | 1425396 | 2021-05-09 | Spain | Ceuta | 5770 | 109 | 163 | 5498 | 35.8894 | -5.3213 | 2021-05-10 04:20:38 | Ceuta, Spain | ||
1552264 | 1552264 | 2021-05-08 | Spain | Ceuta | 5770 | 109 | 163 | 5498 | 35.8894 | -5.3213 | 2021-05-09 04:20:35 | Ceuta, Spain | ||
2502322 | 2502322 | 2021-05-07 | Spain | Ceuta | 5770 | 109 | 163 | 5498 | 35.8894 | -5.3213 | 2021-05-08 04:21:04 | Ceuta, Spain | ||
3113778 | 3113778 | 2021-05-06 | Spain | Ceuta | 5769 | 109 | 163 | 5497 | 35.8894 | -5.3213 | 2021-05-07 04:20:40 | Ceuta, Spain | ||
646245 | 646245 | 2021-05-05 | Spain | Ceuta | 5768 | 108 | 163 | 5497 | 35.8894 | -5.3213 | 2021-05-06 04:20:38 | Ceuta, Spain | ||
3675945 | 3675945 | 2021-05-04 | Spain | Ceuta | 5766 | 107 | 163 | 5496 | 35.8894 | -5.3213 | 2021-05-05 04:20:43 | Ceuta, Spain | ||
2761212 | 2761212 | 2021-05-03 | Spain | Ceuta | 5764 | 106 | 163 | 5495 | 35.8894 | -5.3213 | 2021-05-04 04:20:34 | Ceuta, Spain | ||
2451065 | 2451065 | 2021-05-02 | Spain | Ceuta | 5753 | 104 | 163 | 5486 | 35.8894 | -5.3213 | 2021-05-03 04:20:39 | Ceuta, Spain | ||
2825078 | 2825078 | 2021-05-01 | Spain | Ceuta | 5753 | 104 | 163 | 5486 | 35.8894 | -5.3213 | 2021-05-02 04:20:48 | Ceuta, Spain | ||
380486 | 380486 | 2021-04-30 | Spain | Ceuta | 5753 | 104 | 163 | 5486 | 35.8894 | -5.3213 | 2021-05-01 04:20:47 | Ceuta, Spain | ||
1636609 | 1636609 | 2021-04-29 | Spain | Ceuta | 5751 | 104 | 163 | 5484 | 35.8894 | -5.3213 | 2021-04-30 04:21:03 | Ceuta, Spain | ||
3393688 | 3393688 | 2021-04-28 | Spain | Ceuta | 5746 | 104 | 163 | 5479 | 35.8894 | -5.3213 | 2021-04-29 04:20:55 | Ceuta, Spain | ||
3702404 | 3702404 | 2021-04-27 | Spain | Ceuta | 5736 | 104 | 163 | 5469 | 35.8894 | -5.3213 | 2021-04-28 04:20:32 | Ceuta, Spain | ||
888413 | 888413 | 2021-04-26 | Spain | Ceuta | 5725 | 103 | 163 | 5459 | 35.8894 | -5.3213 | 2021-04-27 04:20:52 | Ceuta, Spain | ||
955158 | 955158 | 2021-04-25 | Spain | Ceuta | 5699 | 103 | 163 | 5433 | 35.8894 | -5.3213 | 2021-04-26 04:21:04 | Ceuta, Spain | ||
3924305 | 3924305 | 2021-04-24 | Spain | Ceuta | 5699 | 103 | 163 | 5433 | 35.8894 | -5.3213 | 2021-04-25 04:20:32 | Ceuta, Spain | ||
1409336 | 1409336 | 2021-04-23 | Spain | Ceuta | 5699 | 103 | 163 | 5433 | 35.8894 | -5.3213 | 2021-04-24 04:20:38 | Ceuta, Spain | ||
1568399 | 1568399 | 2021-04-22 | Spain | Ceuta | 5682 | 102 | 163 | 5417 | 35.8894 | -5.3213 | 2021-04-23 04:20:52 | Ceuta, Spain | ||
3242620 | 3242620 | 2021-04-21 | Spain | Ceuta | 5664 | 101 | 163 | 5400 | 35.8894 | -5.3213 | 2021-04-22 04:20:53 | Ceuta, Spain | ||
2021016 | 2021016 | 2021-04-20 | Spain | Ceuta | 5639 | 101 | 163 | 5375 | 35.8894 | -5.3213 | 2021-04-21 04:21:14 | Ceuta, Spain | ||
2411137 | 2411137 | 2021-04-19 | Spain | Ceuta | 5639 | 101 | 163 | 5375 | 35.8894 | -5.3213 | 2021-04-20 04:20:41 | Ceuta, Spain | ||
3129814 | 3129814 | 2021-04-18 | Spain | Ceuta | 5589 | 100 | 163 | 5326 | 35.8894 | -5.3213 | 2021-04-19 04:20:57 | Ceuta, Spain | ||
983242 | 983242 | 2021-04-17 | Spain | Ceuta | 5589 | 100 | 163 | 5326 | 35.8894 | -5.3213 | 2021-04-18 04:20:41 | Ceuta, Spain | ||
170337 | 170337 | 2021-04-16 | Spain | Ceuta | 5589 | 100 | 163 | 5326 | 35.8894 | -5.3213 | 2021-04-17 04:20:40 | Ceuta, Spain | ||
2549168 | 2549168 | 2021-04-15 | Spain | Ceuta | 5573 | 99 | 163 | 5311 | 35.8894 | -5.3213 | 2021-04-16 04:20:46 | Ceuta, Spain | ||
1842238 | 1842238 | 2021-04-14 | Spain | Ceuta | 5561 | 99 | 163 | 5299 | 35.8894 | -5.3213 | 2021-04-15 04:20:54 | Ceuta, Spain | ||
2571972 | 2571972 | 2021-04-13 | Spain | Ceuta | 5515 | 99 | 163 | 5253 | 35.8894 | -5.3213 | 2021-04-14 04:20:41 | Ceuta, Spain | ||
36723 | 36723 | 2021-04-12 | Spain | Ceuta | 5489 | 99 | 163 | 5227 | 35.8894 | -5.3213 | 2021-04-13 04:20:37 | Ceuta, Spain | ||
3883882 | 3883882 | 2021-04-11 | Spain | Ceuta | 5416 | 99 | 163 | 5154 | 35.8894 | -5.3213 | 2021-04-12 04:21:00 | Ceuta, Spain | ||
2983550 | 2983550 | 2021-04-10 | Spain | Ceuta | 5416 | 99 | 163 | 5154 | 35.8894 | -5.3213 | 2021-04-11 04:20:56 | Ceuta, Spain | ||
605982 | 605982 | 2021-04-09 | Spain | Ceuta | 5416 | 99 | 163 | 5154 | 35.8894 | -5.3213 | 2021-04-10 04:20:59 | Ceuta, Spain | ||
2646046 | 2646046 | 2021-04-08 | Spain | Ceuta | 5373 | 99 | 163 | 5111 | 35.8894 | -5.3213 | 2021-04-09 04:21:13 | Ceuta, Spain | ||
2247688 | 2247688 | 2021-04-07 | Spain | Ceuta | 5327 | 98 | 163 | 5066 | 35.8894 | -5.3213 | 2021-04-08 04:21:13 | Ceuta, Spain | ||
3003598 | 3003598 | 2021-04-06 | Spain | Ceuta | 5294 | 98 | 163 | 5033 | 35.8894 | -5.3213 | 2021-04-07 04:20:53 | Ceuta, Spain | ||
3085593 | 3085593 | 2021-04-05 | Spain | Ceuta | 5258 | 98 | 163 | 4997 | 35.8894 | -5.3213 | 2021-04-06 04:20:32 | Ceuta, Spain | ||
388516 | 388516 | 2021-04-04 | Spain | Ceuta | 5203 | 96 | 163 | 4944 | 35.8894 | -5.3213 | 2021-04-05 04:20:35 | Ceuta, Spain | ||
3710432 | 3710432 | 2021-04-03 | Spain | Ceuta | 5203 | 96 | 163 | 4944 | 35.8894 | -5.3213 | 2021-04-04 04:20:49 | Ceuta, Spain | ||
241548 | 241548 | 2021-04-02 | Spain | Ceuta | 5155 | 96 | 163 | 4896 | 35.8894 | -5.3213 | 2021-04-03 04:20:44 | Ceuta, Spain | ||
1302345 | 1302345 | 2021-04-01 | Spain | Ceuta | 5155 | 96 | 163 | 4896 | 35.8894 | -5.3213 | 2021-04-02 04:20:36 | Ceuta, Spain | ||
638217 | 638217 | 2021-03-31 | Spain | Ceuta | 5121 | 95 | 163 | 4863 | 35.8894 | -5.3213 | 2021-04-01 04:27:05 | Ceuta, Spain | ||
3643846 | 3643846 | 2021-03-30 | Spain | Ceuta | 5094 | 95 | 163 | 4836 | 35.8894 | -5.3213 | 2021-03-31 04:26:25 | Ceuta, Spain | ||
1290299 | 1290299 | 2021-03-29 | Spain | Ceuta | 5066 | 93 | 163 | 4810 | 35.8894 | -5.3213 | 2021-03-30 04:26:23 | Ceuta, Spain | ||
1536221 | 1536221 | 2021-03-28 | Spain | Ceuta | 5023 | 93 | 163 | 4767 | 35.8894 | -5.3213 | 2021-03-29 04:28:35 | Ceuta, Spain | ||
1219861 | 1219861 | 2021-03-27 | Spain | Ceuta | 5023 | 93 | 163 | 4767 | 35.8894 | -5.3213 | 2021-03-28 05:28:10 | Ceuta, Spain | ||
1881279 | 1881279 | 2021-03-26 | Spain | Ceuta | 5023 | 93 | 163 | 4767 | 35.8894 | -5.3213 | 2021-03-27 05:25:04 | Ceuta, Spain | ||
1980909 | 1980909 | 2021-03-25 | Spain | Ceuta | 5008 | 93 | 163 | 4752 | 35.8894 | -5.3213 | 2021-03-26 05:26:55 | Ceuta, Spain | ||
2781287 | 2781287 | 2021-03-24 | Spain | Ceuta | 4984 | 93 | 163 | 4728 | 35.8894 | -5.3213 | 2021-03-25 05:27:00 | Ceuta, Spain | ||
1798932 | 1798932 | 2021-03-23 | Spain | Ceuta | 4984 | 93 | 163 | 4728 | 35.8894 | -5.3213 | 2021-03-24 05:25:40 | Ceuta, Spain | ||
1204100 | 1204100 | 2021-03-22 | Spain | Ceuta | 4970 | 91 | 163 | 4716 | 35.8894 | -5.3213 | 2021-03-23 05:26:18 | Ceuta, Spain | ||
3369622 | 3369622 | 2021-03-21 | Spain | Ceuta | 4906 | 88 | 163 | 4655 | 35.8894 | -5.3213 | 2021-03-22 05:25:43 | Ceuta, Spain | ||
1744832 | 1744832 | 2021-03-20 | Spain | Ceuta | 4906 | 88 | 163 | 4655 | 35.8894 | -5.3213 | 2021-03-21 05:25:44 | Ceuta, Spain | ||
3421212 | 3421212 | 2021-03-19 | Spain | Ceuta | 4906 | 88 | 163 | 4655 | 35.8894 | -5.3213 | 2021-03-20 05:25:46 | Ceuta, Spain | ||
3453150 | 3453150 | 2021-03-18 | Spain | Ceuta | 4906 | 88 | 163 | 4655 | 35.8894 | -5.3213 | 2021-03-19 05:26:09 | Ceuta, Spain | ||
3621374 | 3621374 | 2021-03-17 | Spain | Ceuta | 4872 | 87 | 163 | 4622 | 35.8894 | -5.3213 | 2021-03-18 05:26:22 | Ceuta, Spain | ||
702698 | 702698 | 2021-03-16 | Spain | Ceuta | 4856 | 87 | 163 | 4606 | 35.8894 | -5.3213 | 2021-03-17 05:25:07 | Ceuta, Spain | ||
2056176 | 2056176 | 2021-03-15 | Spain | Ceuta | 4837 | 87 | 163 | 4587 | 35.8894 | -5.3213 | 2021-03-16 05:25:13 | Ceuta, Spain | ||
1732788 | 1732788 | 2021-03-14 | Spain | Ceuta | 4802 | 87 | 163 | 4552 | 35.8894 | -5.3213 | 2021-03-15 05:25:51 | Ceuta, Spain | ||
1580445 | 1580445 | 2021-03-13 | Spain | Ceuta | 4802 | 87 | 163 | 4552 | 35.8894 | -5.3213 | 2021-03-14 05:25:37 | Ceuta, Spain | ||
1838224 | 1838224 | 2021-03-12 | Spain | Ceuta | 4802 | 87 | 163 | 4552 | 35.8894 | -5.3213 | 2021-03-13 05:25:15 | Ceuta, Spain | ||
352589 | 352589 | 2021-03-11 | Spain | Ceuta | 4796 | 86 | 163 | 4547 | 35.8894 | -5.3213 | 2021-03-12 05:26:50 | Ceuta, Spain | ||
3962813 | 3962813 | 2021-03-10 | Spain | Ceuta | 4781 | 86 | 163 | 4532 | 35.8894 | -5.3213 | 2021-03-11 05:25:48 | Ceuta, Spain | ||
3663901 | 3663901 | 2021-03-09 | Spain | Ceuta | 4767 | 86 | 163 | 4518 | 35.8894 | -5.3213 | 2021-03-10 05:24:35 | Ceuta, Spain | ||
2359760 | 2359760 | 2021-03-08 | Spain | Ceuta | 4752 | 86 | 163 | 4503 | 35.8894 | -5.3213 | 2021-03-09 05:28:19 | Ceuta, Spain | ||
55098 | 55098 | 2021-03-07 | Spain | Ceuta | 4723 | 86 | 163 | 4474 | 35.8894 | -5.3213 | 2021-03-08 05:24:48 | Ceuta, Spain | ||
3667915 | 3667915 | 2021-03-06 | Spain | Ceuta | 4723 | 86 | 163 | 4474 | 35.8894 | -5.3213 | 2021-03-07 05:21:54 | Ceuta, Spain | ||
1616536 | 1616536 | 2021-03-05 | Spain | Ceuta | 4723 | 86 | 163 | 4474 | 35.8894 | -5.3213 | 2021-03-06 04:23:41 | Ceuta, Spain | ||
2207947 | 2207947 | 2021-03-04 | Spain | Ceuta | 4704 | 85 | 163 | 4456 | 35.8894 | -5.3213 | 2021-03-05 05:26:29 | Ceuta, Spain | ||
1090368 | 1090368 | 2021-03-03 | Spain | Ceuta | 4693 | 83 | 163 | 4447 | 35.8894 | -5.3213 | 2021-03-04 05:24:24 | Ceuta, 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]);