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 = "Melilla" 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
- Melilla · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2717271 | 2717271 | 2021-06-10 | Spain | Melilla | 9201 | 97 | 125 | 8979 | 35.2923 | -2.9381 | 2021-06-11 04:23:20 | Melilla, Spain | ||
523156 | 523156 | 2021-06-09 | Spain | Melilla | 9200 | 97 | 125 | 8978 | 35.2923 | -2.9381 | 2021-06-10 04:23:17 | Melilla, Spain | ||
3472596 | 3472596 | 2021-06-08 | Spain | Melilla | 9190 | 97 | 125 | 8968 | 35.2923 | -2.9381 | 2021-06-09 04:23:31 | Melilla, Spain | ||
3145880 | 3145880 | 2021-06-07 | Spain | Melilla | 9176 | 97 | 125 | 8954 | 35.2923 | -2.9381 | 2021-06-08 04:22:35 | Melilla, Spain | ||
825882 | 825882 | 2021-06-06 | Spain | Melilla | 9165 | 97 | 125 | 8943 | 35.2923 | -2.9381 | 2021-06-07 04:22:51 | Melilla, Spain | ||
2586287 | 2586287 | 2021-06-05 | Spain | Melilla | 9165 | 97 | 125 | 8943 | 35.2923 | -2.9381 | 2021-06-06 04:24:03 | Melilla, Spain | ||
2315601 | 2315601 | 2021-06-04 | Spain | Melilla | 9165 | 97 | 125 | 8943 | 35.2923 | -2.9381 | 2021-06-05 04:23:03 | Melilla, Spain | ||
1448886 | 1448886 | 2021-06-03 | Spain | Melilla | 9156 | 97 | 125 | 8934 | 35.2923 | -2.9381 | 2021-06-04 04:23:37 | Melilla, Spain | ||
1708610 | 1708610 | 2021-06-02 | Spain | Melilla | 9148 | 97 | 125 | 8926 | 35.2923 | -2.9381 | 2021-06-03 04:23:32 | Melilla, Spain | ||
2104428 | 2104428 | 2021-06-01 | Spain | Melilla | 9137 | 97 | 125 | 8915 | 35.2923 | -2.9381 | 2021-06-02 04:24:34 | Melilla, Spain | ||
1189044 | 1189044 | 2021-05-31 | Spain | Melilla | 9124 | 97 | 125 | 8902 | 35.2923 | -2.9381 | 2021-06-01 04:23:09 | Melilla, Spain | ||
3089721 | 3089721 | 2021-05-30 | Spain | Melilla | 9098 | 97 | 125 | 8876 | 35.2923 | -2.9381 | 2021-05-31 03:08:59 | Melilla, Spain | ||
51090 | 51090 | 2021-05-29 | Spain | Melilla | 9098 | 97 | 125 | 8876 | 35.2923 | -2.9381 | 2021-05-30 04:20:55 | Melilla, Spain | ||
20669 | 20669 | 2021-05-28 | Spain | Melilla | 9098 | 97 | 125 | 8876 | 35.2923 | -2.9381 | 2021-05-29 04:20:41 | Melilla, Spain | ||
1807044 | 1807044 | 2021-05-27 | Spain | Melilla | 9088 | 97 | 125 | 8866 | 35.2923 | -2.9381 | 2021-05-28 04:20:36 | Melilla, Spain | ||
1310467 | 1310467 | 2021-05-26 | Spain | Melilla | 9073 | 97 | 125 | 8851 | 35.2923 | -2.9381 | 2021-05-27 04:20:59 | Melilla, Spain | ||
83393 | 83393 | 2021-05-25 | Spain | Melilla | 9064 | 97 | 125 | 8842 | 35.2923 | -2.9381 | 2021-05-26 04:20:35 | Melilla, Spain | ||
1413355 | 1413355 | 2021-05-24 | Spain | Melilla | 9043 | 97 | 125 | 8821 | 35.2923 | -2.9381 | 2021-05-25 04:21:08 | Melilla, Spain | ||
1771641 | 1771641 | 2021-05-23 | Spain | Melilla | 9019 | 97 | 125 | 8797 | 35.2923 | -2.9381 | 2021-05-24 04:20:53 | Melilla, Spain | ||
726796 | 726796 | 2021-05-22 | Spain | Melilla | 9019 | 97 | 125 | 8797 | 35.2923 | -2.9381 | 2021-05-23 04:20:51 | Melilla, Spain | ||
1952811 | 1952811 | 2021-05-21 | Spain | Melilla | 9019 | 97 | 125 | 8797 | 35.2923 | -2.9381 | 2021-05-22 04:20:45 | Melilla, Spain | ||
1913510 | 1913510 | 2021-05-20 | Spain | Melilla | 9004 | 97 | 125 | 8782 | 35.2923 | -2.9381 | 2021-05-21 04:20:43 | Melilla, Spain | ||
2256031 | 2256031 | 2021-05-19 | Spain | Melilla | 8990 | 97 | 125 | 8768 | 35.2923 | -2.9381 | 2021-05-20 04:21:05 | Melilla, Spain | ||
2391069 | 2391069 | 2021-05-18 | Spain | Melilla | 8983 | 97 | 125 | 8761 | 35.2923 | -2.9381 | 2021-05-19 04:20:42 | Melilla, Spain | ||
3574894 | 3574894 | 2021-05-17 | Spain | Melilla | 8962 | 97 | 125 | 8740 | 35.2923 | -2.9381 | 2021-05-18 04:20:33 | Melilla, Spain | ||
2939624 | 2939624 | 2021-05-16 | Spain | Melilla | 8932 | 96 | 125 | 8711 | 35.2923 | -2.9381 | 2021-05-17 04:20:34 | Melilla, Spain | ||
1873254 | 1873254 | 2021-05-15 | Spain | Melilla | 8932 | 96 | 125 | 8711 | 35.2923 | -2.9381 | 2021-05-16 04:20:49 | Melilla, Spain | ||
1082223 | 1082223 | 2021-05-14 | Spain | Melilla | 8932 | 96 | 125 | 8711 | 35.2923 | -2.9381 | 2021-05-15 04:20:58 | Melilla, Spain | ||
3054489 | 3054489 | 2021-05-13 | Spain | Melilla | 8924 | 96 | 125 | 8703 | 35.2923 | -2.9381 | 2021-05-14 04:20:41 | Melilla, Spain | ||
2004959 | 2004959 | 2021-05-12 | Spain | Melilla | 8913 | 96 | 125 | 8692 | 35.2923 | -2.9381 | 2021-05-13 04:20:51 | Melilla, Spain | ||
3954790 | 3954790 | 2021-05-11 | Spain | Melilla | 8892 | 96 | 125 | 8671 | 35.2923 | -2.9381 | 2021-05-12 04:21:29 | Melilla, Spain | ||
2821069 | 2821069 | 2021-05-10 | Spain | Melilla | 8866 | 95 | 125 | 8646 | 35.2923 | -2.9381 | 2021-05-11 04:20:41 | Melilla, Spain | ||
1425401 | 1425401 | 2021-05-09 | Spain | Melilla | 8826 | 94 | 125 | 8607 | 35.2923 | -2.9381 | 2021-05-10 04:20:38 | Melilla, Spain | ||
1552269 | 1552269 | 2021-05-08 | Spain | Melilla | 8826 | 94 | 125 | 8607 | 35.2923 | -2.9381 | 2021-05-09 04:20:35 | Melilla, Spain | ||
2502327 | 2502327 | 2021-05-07 | Spain | Melilla | 8826 | 94 | 125 | 8607 | 35.2923 | -2.9381 | 2021-05-08 04:21:04 | Melilla, Spain | ||
3113783 | 3113783 | 2021-05-06 | Spain | Melilla | 8787 | 93 | 125 | 8569 | 35.2923 | -2.9381 | 2021-05-07 04:20:40 | Melilla, Spain | ||
646250 | 646250 | 2021-05-05 | Spain | Melilla | 8772 | 92 | 125 | 8555 | 35.2923 | -2.9381 | 2021-05-06 04:20:38 | Melilla, Spain | ||
3675950 | 3675950 | 2021-05-04 | Spain | Melilla | 8753 | 90 | 125 | 8538 | 35.2923 | -2.9381 | 2021-05-05 04:20:43 | Melilla, Spain | ||
2761217 | 2761217 | 2021-05-03 | Spain | Melilla | 8735 | 89 | 125 | 8521 | 35.2923 | -2.9381 | 2021-05-04 04:20:34 | Melilla, Spain | ||
2451070 | 2451070 | 2021-05-02 | Spain | Melilla | 8705 | 89 | 125 | 8491 | 35.2923 | -2.9381 | 2021-05-03 04:20:39 | Melilla, Spain | ||
2825083 | 2825083 | 2021-05-01 | Spain | Melilla | 8705 | 89 | 125 | 8491 | 35.2923 | -2.9381 | 2021-05-02 04:20:48 | Melilla, Spain | ||
380491 | 380491 | 2021-04-30 | Spain | Melilla | 8705 | 89 | 125 | 8491 | 35.2923 | -2.9381 | 2021-05-01 04:20:47 | Melilla, Spain | ||
1636614 | 1636614 | 2021-04-29 | Spain | Melilla | 8693 | 89 | 125 | 8479 | 35.2923 | -2.9381 | 2021-04-30 04:21:03 | Melilla, Spain | ||
3393693 | 3393693 | 2021-04-28 | Spain | Melilla | 8677 | 89 | 125 | 8463 | 35.2923 | -2.9381 | 2021-04-29 04:20:55 | Melilla, Spain | ||
3702409 | 3702409 | 2021-04-27 | Spain | Melilla | 8650 | 89 | 125 | 8436 | 35.2923 | -2.9381 | 2021-04-28 04:20:32 | Melilla, Spain | ||
888418 | 888418 | 2021-04-26 | Spain | Melilla | 8636 | 89 | 125 | 8422 | 35.2923 | -2.9381 | 2021-04-27 04:20:52 | Melilla, Spain | ||
955163 | 955163 | 2021-04-25 | Spain | Melilla | 8563 | 88 | 125 | 8350 | 35.2923 | -2.9381 | 2021-04-26 04:21:04 | Melilla, Spain | ||
3924310 | 3924310 | 2021-04-24 | Spain | Melilla | 8563 | 88 | 125 | 8350 | 35.2923 | -2.9381 | 2021-04-25 04:20:32 | Melilla, Spain | ||
1409341 | 1409341 | 2021-04-23 | Spain | Melilla | 8563 | 88 | 125 | 8350 | 35.2923 | -2.9381 | 2021-04-24 04:20:38 | Melilla, Spain | ||
1568404 | 1568404 | 2021-04-22 | Spain | Melilla | 8518 | 88 | 125 | 8305 | 35.2923 | -2.9381 | 2021-04-23 04:20:52 | Melilla, Spain | ||
3242625 | 3242625 | 2021-04-21 | Spain | Melilla | 8485 | 88 | 125 | 8272 | 35.2923 | -2.9381 | 2021-04-22 04:20:53 | Melilla, Spain | ||
2021021 | 2021021 | 2021-04-20 | Spain | Melilla | 8430 | 86 | 125 | 8219 | 35.2923 | -2.9381 | 2021-04-21 04:21:14 | Melilla, Spain | ||
2411142 | 2411142 | 2021-04-19 | Spain | Melilla | 8430 | 86 | 125 | 8219 | 35.2923 | -2.9381 | 2021-04-20 04:20:41 | Melilla, Spain | ||
3129819 | 3129819 | 2021-04-18 | Spain | Melilla | 8384 | 86 | 125 | 8173 | 35.2923 | -2.9381 | 2021-04-19 04:20:57 | Melilla, Spain | ||
983247 | 983247 | 2021-04-17 | Spain | Melilla | 8384 | 86 | 125 | 8173 | 35.2923 | -2.9381 | 2021-04-18 04:20:41 | Melilla, Spain | ||
170342 | 170342 | 2021-04-16 | Spain | Melilla | 8384 | 86 | 125 | 8173 | 35.2923 | -2.9381 | 2021-04-17 04:20:40 | Melilla, Spain | ||
2549173 | 2549173 | 2021-04-15 | Spain | Melilla | 8349 | 86 | 125 | 8138 | 35.2923 | -2.9381 | 2021-04-16 04:20:46 | Melilla, Spain | ||
1842243 | 1842243 | 2021-04-14 | Spain | Melilla | 8318 | 86 | 125 | 8107 | 35.2923 | -2.9381 | 2021-04-15 04:20:54 | Melilla, Spain | ||
2571977 | 2571977 | 2021-04-13 | Spain | Melilla | 8279 | 85 | 125 | 8069 | 35.2923 | -2.9381 | 2021-04-14 04:20:41 | Melilla, Spain | ||
36728 | 36728 | 2021-04-12 | Spain | Melilla | 8254 | 85 | 125 | 8044 | 35.2923 | -2.9381 | 2021-04-13 04:20:37 | Melilla, Spain | ||
3883887 | 3883887 | 2021-04-11 | Spain | Melilla | 8159 | 84 | 125 | 7950 | 35.2923 | -2.9381 | 2021-04-12 04:21:00 | Melilla, Spain | ||
2983555 | 2983555 | 2021-04-10 | Spain | Melilla | 8159 | 84 | 125 | 7950 | 35.2923 | -2.9381 | 2021-04-11 04:20:56 | Melilla, Spain | ||
605987 | 605987 | 2021-04-09 | Spain | Melilla | 8159 | 84 | 125 | 7950 | 35.2923 | -2.9381 | 2021-04-10 04:20:59 | Melilla, Spain | ||
2646051 | 2646051 | 2021-04-08 | Spain | Melilla | 8120 | 84 | 125 | 7911 | 35.2923 | -2.9381 | 2021-04-09 04:21:13 | Melilla, Spain | ||
2247693 | 2247693 | 2021-04-07 | Spain | Melilla | 8072 | 83 | 125 | 7864 | 35.2923 | -2.9381 | 2021-04-08 04:21:13 | Melilla, Spain | ||
3003603 | 3003603 | 2021-04-06 | Spain | Melilla | 8015 | 83 | 125 | 7807 | 35.2923 | -2.9381 | 2021-04-07 04:20:53 | Melilla, Spain | ||
3085598 | 3085598 | 2021-04-05 | Spain | Melilla | 7976 | 82 | 125 | 7769 | 35.2923 | -2.9381 | 2021-04-06 04:20:32 | Melilla, Spain | ||
388521 | 388521 | 2021-04-04 | Spain | Melilla | 7935 | 82 | 125 | 7728 | 35.2923 | -2.9381 | 2021-04-05 04:20:35 | Melilla, Spain | ||
3710437 | 3710437 | 2021-04-03 | Spain | Melilla | 7935 | 82 | 125 | 7728 | 35.2923 | -2.9381 | 2021-04-04 04:20:49 | Melilla, Spain | ||
241553 | 241553 | 2021-04-02 | Spain | Melilla | 7904 | 79 | 125 | 7700 | 35.2923 | -2.9381 | 2021-04-03 04:20:44 | Melilla, Spain | ||
1302350 | 1302350 | 2021-04-01 | Spain | Melilla | 7904 | 79 | 125 | 7700 | 35.2923 | -2.9381 | 2021-04-02 04:20:36 | Melilla, Spain | ||
638222 | 638222 | 2021-03-31 | Spain | Melilla | 7861 | 79 | 125 | 7657 | 35.2923 | -2.9381 | 2021-04-01 04:27:05 | Melilla, Spain | ||
3643851 | 3643851 | 2021-03-30 | Spain | Melilla | 7827 | 79 | 125 | 7623 | 35.2923 | -2.9381 | 2021-03-31 04:26:25 | Melilla, Spain | ||
1290304 | 1290304 | 2021-03-29 | Spain | Melilla | 7783 | 79 | 125 | 7579 | 35.2923 | -2.9381 | 2021-03-30 04:26:23 | Melilla, Spain | ||
1536226 | 1536226 | 2021-03-28 | Spain | Melilla | 7726 | 78 | 125 | 7523 | 35.2923 | -2.9381 | 2021-03-29 04:28:35 | Melilla, Spain | ||
1219866 | 1219866 | 2021-03-27 | Spain | Melilla | 7726 | 78 | 125 | 7523 | 35.2923 | -2.9381 | 2021-03-28 05:28:10 | Melilla, Spain | ||
1881284 | 1881284 | 2021-03-26 | Spain | Melilla | 7726 | 78 | 125 | 7523 | 35.2923 | -2.9381 | 2021-03-27 05:25:04 | Melilla, Spain | ||
1980914 | 1980914 | 2021-03-25 | Spain | Melilla | 7699 | 78 | 125 | 7496 | 35.2923 | -2.9381 | 2021-03-26 05:26:55 | Melilla, Spain | ||
2781292 | 2781292 | 2021-03-24 | Spain | Melilla | 7634 | 78 | 125 | 7431 | 35.2923 | -2.9381 | 2021-03-25 05:27:00 | Melilla, Spain | ||
1798937 | 1798937 | 2021-03-23 | Spain | Melilla | 7634 | 78 | 125 | 7431 | 35.2923 | -2.9381 | 2021-03-24 05:25:40 | Melilla, Spain | ||
1204105 | 1204105 | 2021-03-22 | Spain | Melilla | 7602 | 78 | 125 | 7399 | 35.2923 | -2.9381 | 2021-03-23 05:26:18 | Melilla, Spain | ||
3369627 | 3369627 | 2021-03-21 | Spain | Melilla | 7489 | 77 | 125 | 7287 | 35.2923 | -2.9381 | 2021-03-22 05:25:43 | Melilla, Spain | ||
1744837 | 1744837 | 2021-03-20 | Spain | Melilla | 7489 | 77 | 125 | 7287 | 35.2923 | -2.9381 | 2021-03-21 05:25:44 | Melilla, Spain | ||
3421217 | 3421217 | 2021-03-19 | Spain | Melilla | 7489 | 77 | 125 | 7287 | 35.2923 | -2.9381 | 2021-03-20 05:25:46 | Melilla, Spain | ||
3453155 | 3453155 | 2021-03-18 | Spain | Melilla | 7489 | 77 | 125 | 7287 | 35.2923 | -2.9381 | 2021-03-19 05:26:09 | Melilla, Spain | ||
3621379 | 3621379 | 2021-03-17 | Spain | Melilla | 7443 | 76 | 125 | 7242 | 35.2923 | -2.9381 | 2021-03-18 05:26:22 | Melilla, Spain | ||
702703 | 702703 | 2021-03-16 | Spain | Melilla | 7394 | 76 | 125 | 7193 | 35.2923 | -2.9381 | 2021-03-17 05:25:07 | Melilla, Spain | ||
2056181 | 2056181 | 2021-03-15 | Spain | Melilla | 7345 | 76 | 125 | 7144 | 35.2923 | -2.9381 | 2021-03-16 05:25:13 | Melilla, Spain | ||
1732793 | 1732793 | 2021-03-14 | Spain | Melilla | 7281 | 74 | 125 | 7082 | 35.2923 | -2.9381 | 2021-03-15 05:25:51 | Melilla, Spain | ||
1580450 | 1580450 | 2021-03-13 | Spain | Melilla | 7281 | 74 | 125 | 7082 | 35.2923 | -2.9381 | 2021-03-14 05:25:37 | Melilla, Spain | ||
1838229 | 1838229 | 2021-03-12 | Spain | Melilla | 7281 | 74 | 125 | 7082 | 35.2923 | -2.9381 | 2021-03-13 05:25:15 | Melilla, Spain | ||
352594 | 352594 | 2021-03-11 | Spain | Melilla | 7247 | 74 | 125 | 7048 | 35.2923 | -2.9381 | 2021-03-12 05:26:50 | Melilla, Spain | ||
3962818 | 3962818 | 2021-03-10 | Spain | Melilla | 7221 | 74 | 125 | 7022 | 35.2923 | -2.9381 | 2021-03-11 05:25:48 | Melilla, Spain | ||
3663906 | 3663906 | 2021-03-09 | Spain | Melilla | 7184 | 74 | 125 | 6985 | 35.2923 | -2.9381 | 2021-03-10 05:24:35 | Melilla, Spain | ||
2359765 | 2359765 | 2021-03-08 | Spain | Melilla | 7184 | 73 | 125 | 6986 | 35.2923 | -2.9381 | 2021-03-09 05:28:19 | Melilla, Spain | ||
55103 | 55103 | 2021-03-07 | Spain | Melilla | 7098 | 72 | 125 | 6901 | 35.2923 | -2.9381 | 2021-03-08 05:24:48 | Melilla, Spain | ||
3667920 | 3667920 | 2021-03-06 | Spain | Melilla | 7098 | 72 | 125 | 6901 | 35.2923 | -2.9381 | 2021-03-07 05:21:54 | Melilla, Spain | ||
1616541 | 1616541 | 2021-03-05 | Spain | Melilla | 7098 | 72 | 125 | 6901 | 35.2923 | -2.9381 | 2021-03-06 04:23:41 | Melilla, Spain | ||
2207952 | 2207952 | 2021-03-04 | Spain | Melilla | 7070 | 72 | 125 | 6873 | 35.2923 | -2.9381 | 2021-03-05 05:26:29 | Melilla, Spain | ||
1090373 | 1090373 | 2021-03-03 | Spain | Melilla | 7047 | 72 | 125 | 6850 | 35.2923 | -2.9381 | 2021-03-04 05:24:24 | Melilla, 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]);