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)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3254440 | 3254440 | 2021-03-02 | Spain | Ceuta | 4678 | 82 | 163 | 4433 | 35.8894 | -5.3213 | 2021-03-03 05:23:28 | Ceuta, Spain | ||
998732 | 998732 | 2021-03-01 | Spain | Ceuta | 4616 | 82 | 163 | 4371 | 35.8894 | -5.3213 | 2021-03-02 05:23:30 | Ceuta, Spain | ||
2367790 | 2367790 | 2021-02-28 | Spain | Ceuta | 4562 | 81 | 163 | 4318 | 35.8894 | -5.3213 | 2021-03-01 05:23:01 | Ceuta, Spain | ||
3066292 | 3066292 | 2021-02-27 | Spain | Ceuta | 4562 | 81 | 163 | 4318 | 35.8894 | -5.3213 | 2021-02-28 05:22:20 | Ceuta, Spain | ||
2183876 | 2183876 | 2021-02-26 | Spain | Ceuta | 4562 | 81 | 163 | 4318 | 35.8894 | -5.3213 | 2021-02-27 05:22:28 | Ceuta, Spain | ||
1858298 | 1858298 | 2021-02-25 | Spain | Ceuta | 4548 | 81 | 163 | 4304 | 35.8894 | -5.3213 | 2021-02-26 05:22:40 | Ceuta, Spain | ||
280476 | 280476 | 2021-02-24 | Spain | Ceuta | 4540 | 79 | 163 | 4298 | 35.8894 | -5.3213 | 2021-02-25 05:24:57 | Ceuta, Spain | ||
1936744 | 1936744 | 2021-02-23 | Spain | Ceuta | 4522 | 79 | 163 | 4280 | 35.8894 | -5.3213 | 2021-02-24 05:29:16 | Ceuta, Spain | ||
530999 | 530999 | 2021-02-22 | Spain | Ceuta | 4505 | 79 | 163 | 4263 | 35.8894 | -5.3213 | 2021-02-23 05:23:41 | Ceuta, Spain | ||
182333 | 182333 | 2021-02-21 | Spain | Ceuta | 4475 | 77 | 163 | 4235 | 35.8894 | -5.3213 | 2021-02-22 05:24:21 | Ceuta, Spain | ||
742607 | 742607 | 2021-02-20 | Spain | Ceuta | 4475 | 77 | 163 | 4235 | 35.8894 | -5.3213 | 2021-02-21 05:24:33 | Ceuta, Spain | ||
471705 | 471705 | 2021-02-19 | Spain | Ceuta | 4475 | 77 | 163 | 4235 | 35.8894 | -5.3213 | 2021-02-20 05:22:51 | Ceuta, Spain | ||
1153414 | 1153414 | 2021-02-18 | Spain | Ceuta | 4467 | 77 | 163 | 4227 | 35.8894 | -5.3213 | 2021-02-19 05:24:16 | Ceuta, Spain | ||
3601334 | 3601334 | 2021-02-17 | Spain | Ceuta | 4449 | 76 | 163 | 4210 | 35.8894 | -5.3213 | 2021-02-18 05:22:58 | Ceuta, Spain | ||
3050469 | 3050469 | 2021-02-16 | Spain | Ceuta | 4413 | 76 | 163 | 4174 | 35.8894 | -5.3213 | 2021-02-17 05:23:10 | Ceuta, Spain | ||
1338568 | 1338568 | 2021-02-15 | Spain | Ceuta | 4391 | 76 | 163 | 4152 | 35.8894 | -5.3213 | 2021-02-16 05:24:38 | Ceuta, Spain | ||
2283719 | 2283719 | 2021-02-14 | Spain | Ceuta | 4324 | 75 | 163 | 4086 | 35.8894 | -5.3213 | 2021-02-15 05:24:49 | Ceuta, Spain | ||
2678119 | 2678119 | 2021-02-13 | Spain | Ceuta | 4324 | 75 | 163 | 4086 | 35.8894 | -5.3213 | 2021-02-14 05:23:43 | Ceuta, Spain | ||
3539752 | 3539752 | 2021-02-12 | Spain | Ceuta | 4324 | 75 | 163 | 4086 | 35.8894 | -5.3213 | 2021-02-13 05:22:12 | Ceuta, Spain | ||
2638015 | 2638015 | 2021-02-11 | Spain | Ceuta | 4295 | 75 | 163 | 4057 | 35.8894 | -5.3213 | 2021-02-12 05:23:29 | Ceuta, Spain | ||
3978870 | 3978870 | 2021-02-10 | Spain | Ceuta | 4275 | 75 | 163 | 4037 | 35.8894 | -5.3213 | 2021-02-11 05:23:55 | Ceuta, Spain | ||
1528190 | 1528190 | 2021-02-09 | Spain | Ceuta | 4239 | 75 | 163 | 4001 | 35.8894 | -5.3213 | 2021-02-10 05:22:41 | Ceuta, Spain | ||
613981 | 613981 | 2021-02-08 | Spain | Ceuta | 4208 | 75 | 163 | 3970 | 35.8894 | -5.3213 | 2021-02-09 05:23:30 | Ceuta, Spain | ||
1672750 | 1672750 | 2021-02-07 | Spain | Ceuta | 4138 | 74 | 163 | 3901 | 35.8894 | -5.3213 | 2021-02-08 05:22:39 | Ceuta, Spain | ||
975211 | 975211 | 2021-02-06 | Spain | Ceuta | 4138 | 74 | 163 | 3901 | 35.8894 | -5.3213 | 2021-02-07 05:23:00 | Ceuta, Spain | ||
1588469 | 1588469 | 2021-02-05 | Spain | Ceuta | 4138 | 74 | 163 | 3901 | 35.8894 | -5.3213 | 2021-02-06 05:23:55 | Ceuta, Spain | ||
790676 | 790676 | 2021-02-04 | Spain | Ceuta | 4117 | 74 | 163 | 3880 | 35.8894 | -5.3213 | 2021-02-05 05:22:38 | Ceuta, Spain | ||
340568 | 340568 | 2021-02-03 | Spain | Ceuta | 4074 | 72 | 163 | 3839 | 35.8894 | -5.3213 | 2021-02-04 05:22:26 | Ceuta, Spain | ||
1684794 | 1684794 | 2021-02-02 | Spain | Ceuta | 4032 | 72 | 163 | 3797 | 35.8894 | -5.3213 | 2021-02-03 05:22:52 | Ceuta, Spain | ||
1676764 | 1676764 | 2021-02-01 | Spain | Ceuta | 3986 | 72 | 163 | 3751 | 35.8894 | -5.3213 | 2021-02-02 05:22:49 | Ceuta, Spain | ||
1460052 | 1460052 | 2021-01-31 | Spain | Ceuta | 3904 | 71 | 163 | 3670 | 35.8894 | -5.3213 | 2021-02-01 05:22:53 | Ceuta, Spain | ||
2211960 | 2211960 | 2021-01-30 | Spain | Ceuta | 3904 | 71 | 163 | 3670 | 35.8894 | -5.3213 | 2021-01-31 05:22:42 | Ceuta, Spain | ||
1897447 | 1897447 | 2021-01-29 | Spain | Ceuta | 3904 | 71 | 163 | 3670 | 35.8894 | -5.3213 | 2021-01-30 05:22:49 | Ceuta, Spain | ||
2482263 | 2482263 | 2021-01-28 | Spain | Ceuta | 3871 | 68 | 163 | 3640 | 35.8894 | -5.3213 | 2021-01-29 05:22:23 | Ceuta, Spain | ||
3153898 | 3153898 | 2021-01-27 | Spain | Ceuta | 3817 | 68 | 163 | 3586 | 35.8894 | -5.3213 | 2021-01-28 05:22:24 | Ceuta, Spain | ||
12633 | 12633 | 2021-01-26 | Spain | Ceuta | 3791 | 68 | 163 | 3560 | 35.8894 | -5.3213 | 2021-01-27 05:23:41 | Ceuta, Spain | ||
2567957 | 2567957 | 2021-01-25 | Spain | Ceuta | 3746 | 68 | 163 | 3515 | 35.8894 | -5.3213 | 2021-01-26 05:22:02 | 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]);