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 rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date)
Link | rowid ▲ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4002973 | 4002973 | 2022-10-08 | Spain | Melilla | 24817 | 167 | 0 | 35.2923 | -2.9381 | 2022-10-09 04:21:16 | Melilla, Spain | |||
3998953 | 3998953 | 2021-12-30 | Spain | Melilla | 12793 | 121 | 0 | 35.2923 | -2.9381 | 2021-12-31 04:21:50 | Melilla, Spain | |||
3994941 | 3994941 | 2022-09-27 | Spain | Melilla | 24786 | 167 | 0 | 35.2923 | -2.9381 | 2022-09-28 04:23:01 | Melilla, Spain | |||
3990905 | 3990905 | 2020-10-20 | Spain | Melilla | 1885 | 11 | 125 | 1749 | 35.2923 | -2.9381 | 2020-10-21 04:24:14 | Melilla, Spain | ||
3986930 | 3986930 | 2022-09-15 | Spain | Melilla | 24714 | 167 | 0 | 35.2923 | -2.9381 | 2022-09-16 04:21:19 | Melilla, Spain | |||
3982912 | 3982912 | 2022-06-15 | Spain | Melilla | 22254 | 155 | 0 | 35.2923 | -2.9381 | 2022-06-16 04:20:55 | Melilla, Spain | |||
3978875 | 3978875 | 2021-02-10 | Spain | Melilla | 6495 | 60 | 125 | 6310 | 35.2923 | -2.9381 | 2021-02-11 05:23:55 | Melilla, Spain | ||
3974865 | 3974865 | 2021-09-03 | Spain | Melilla | 10666 | 102 | 0 | 35.2923 | -2.9381 | 2021-09-04 04:21:28 | Melilla, Spain | |||
3970849 | 3970849 | 2021-06-11 | Spain | Melilla | 9201 | 97 | 125 | 8979 | 35.2923 | -2.9381 | 2021-06-12 04:22:22 | Melilla, Spain | ||
3966854 | 3966854 | 2022-07-05 | Spain | Melilla | 23065 | 159 | 0 | 35.2923 | -2.9381 | 2022-07-06 04:20:58 | 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 | ||
3958807 | 3958807 | 2021-06-26 | Spain | Melilla | 9257 | 97 | 125 | 9035 | 35.2923 | -2.9381 | 2021-06-27 04:21:39 | 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 | ||
3950796 | 3950796 | 2022-08-17 | Spain | Melilla | 24560 | 172 | 0 | 35.2923 | -2.9381 | 2022-08-18 04:21:11 | Melilla, Spain | |||
3940363 | 3940363 | 2022-06-30 | Spain | Melilla | 22627 | 158 | 0 | 35.2923 | -2.9381 | 2022-07-01 04:21:10 | Melilla, Spain | |||
3936349 | 3936349 | 2022-12-09 | Spain | Melilla | 25046 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-10 04:21:02 | Melilla, Spain | |||
3932320 | 3932320 | 2020-08-30 | Spain | Melilla | 300 | 2 | 125 | 173 | 35.2923 | -2.9381 | 2020-08-31 04:28:27 | Melilla, Spain | ||
3928344 | 3928344 | 2021-10-02 | Spain | Melilla | 11003 | 107 | 0 | 35.2923 | -2.9381 | 2021-10-03 04:21:24 | 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 | ||
3923244 | 3923244 | 2020-08-09 | Spain | Melilla | 151 | 2 | 125 | 24 | 35.2923 | -2.9381 | 2020-08-10 04:34:55 | Melilla, Spain | ||
3916338 | 3916338 | 2022-05-01 | Spain | Melilla | 21073 | 155 | 0 | 35.2923 | -2.9381 | 2022-05-02 04:21:10 | Melilla, Spain | |||
3912322 | 3912322 | 2022-02-20 | Spain | Melilla | 20076 | 147 | 0 | 35.2923 | -2.9381 | 2022-02-21 04:21:05 | Melilla, Spain | |||
3908307 | 3908307 | 2022-08-11 | Spain | Melilla | 24469 | 171 | 0 | 35.2923 | -2.9381 | 2022-08-12 04:20:54 | Melilla, Spain | |||
3904274 | 3904274 | 2021-07-31 | Spain | Melilla | 9641 | 97 | 125 | 9419 | 35.2923 | -2.9381 | 2021-08-01 04:21:50 | Melilla, Spain | ||
3900257 | 3900257 | 2021-01-09 | Spain | Melilla | 4728 | 44 | 125 | 4559 | 35.2923 | -2.9381 | 2021-01-10 05:22:12 | Melilla, Spain | ||
3896265 | 3896265 | 2022-05-19 | Spain | Melilla | 21537 | 154 | 0 | 35.2923 | -2.9381 | 2022-05-20 04:20:57 | Melilla, Spain | |||
3892232 | 3892232 | 2021-08-29 | Spain | Melilla | 10494 | 101 | 0 | 35.2923 | -2.9381 | 2021-08-30 04:21:23 | Melilla, Spain | |||
3887923 | 3887923 | 2022-06-06 | Spain | Melilla | 22067 | 154 | 0 | 35.2923 | -2.9381 | 2022-06-07 04:21:08 | 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 | ||
3879873 | 3879873 | 2021-01-14 | Spain | Melilla | 5005 | 48 | 125 | 4832 | 35.2923 | -2.9381 | 2021-01-15 05:22:24 | Melilla, Spain | ||
3875880 | 3875880 | 2022-02-19 | Spain | Melilla | 20076 | 147 | 0 | 35.2923 | -2.9381 | 2022-02-20 04:21:00 | Melilla, Spain | |||
3871865 | 3871865 | 2022-07-31 | Spain | Melilla | 24225 | 167 | 0 | 35.2923 | -2.9381 | 2022-08-01 04:21:03 | Melilla, Spain | |||
3867848 | 3867848 | 2022-04-05 | Spain | Melilla | 20711 | 154 | 0 | 35.2923 | -2.9381 | 2022-04-06 04:20:49 | Melilla, Spain | |||
3866794 | 3866794 | 2020-06-03 | Spain | Melilla | 122 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-06-04 02:33:14 | Melilla, Spain | ||
3860128 | 3860128 | 2020-12-04 | Spain | Melilla | 4152 | 43 | 125 | 3984 | 35.2923 | -2.9381 | 2020-12-05 05:27:36 | Melilla, Spain | ||
3856136 | 3856136 | 2022-02-18 | Spain | Melilla | 20076 | 147 | 0 | 35.2923 | -2.9381 | 2022-02-19 04:21:11 | Melilla, Spain | |||
3852120 | 3852120 | 2022-04-27 | Spain | Melilla | 20968 | 154 | 0 | 35.2923 | -2.9381 | 2022-04-28 04:20:47 | Melilla, Spain | |||
3848085 | 3848085 | 2020-12-13 | Spain | Melilla | 4242 | 42 | 125 | 4075 | 35.2923 | -2.9381 | 2020-12-14 05:26:27 | Melilla, Spain | ||
3840813 | 3840813 | 2022-01-15 | Spain | Melilla | 16175 | 124 | 0 | 35.2923 | -2.9381 | 2022-01-16 04:21:12 | Melilla, Spain | |||
3836779 | 3836779 | 2020-11-21 | Spain | Melilla | 3853 | 35 | 125 | 3693 | 35.2923 | -2.9381 | 2020-11-22 05:25:45 | Melilla, Spain | ||
3832788 | 3832788 | 2021-10-05 | Spain | Melilla | 11018 | 108 | 0 | 35.2923 | -2.9381 | 2021-10-06 04:21:33 | Melilla, Spain | |||
3828772 | 3828772 | 2021-12-21 | Spain | Melilla | 12086 | 117 | 0 | 35.2923 | -2.9381 | 2021-12-22 04:21:54 | Melilla, Spain | |||
3824758 | 3824758 | 2022-09-10 | Spain | Melilla | 24709 | 167 | 0 | 35.2923 | -2.9381 | 2022-09-11 04:20:50 | Melilla, Spain | |||
3820741 | 3820741 | 2022-02-16 | Spain | Melilla | 20028 | 147 | 0 | 35.2923 | -2.9381 | 2022-02-17 04:20:56 | Melilla, Spain | |||
3816724 | 3816724 | 2021-12-23 | Spain | Melilla | 12224 | 119 | 0 | 35.2923 | -2.9381 | 2021-12-24 04:21:34 | Melilla, Spain | |||
3810235 | 3810235 | 2022-01-28 | Spain | Melilla | 18878 | 127 | 0 | 35.2923 | -2.9381 | 2022-01-29 04:21:10 | Melilla, Spain | |||
3806204 | 3806204 | 2021-09-11 | Spain | Melilla | 10797 | 102 | 0 | 35.2923 | -2.9381 | 2021-09-12 04:21:13 | Melilla, Spain | |||
3802191 | 3802191 | 2020-10-05 | Spain | Melilla | 1130 | 5 | 125 | 1000 | 35.2923 | -2.9381 | 2020-10-06 04:23:33 | Melilla, Spain | ||
3798215 | 3798215 | 2022-08-20 | Spain | Melilla | 24617 | 173 | 0 | 35.2923 | -2.9381 | 2022-08-21 04:20:44 | Melilla, Spain | |||
3794197 | 3794197 | 2021-10-25 | Spain | Melilla | 11058 | 112 | 0 | 35.2923 | -2.9381 | 2021-10-26 04:22:09 | Melilla, Spain | |||
3793111 | 3793111 | 2020-08-05 | Spain | Melilla | 144 | 2 | 125 | 17 | 35.2923 | -2.9381 | 2020-08-06 04:35:02 | Melilla, Spain | ||
3786190 | 3786190 | 2020-10-11 | Spain | Melilla | 1273 | 6 | 125 | 1142 | 35.2923 | -2.9381 | 2020-10-12 04:23:45 | Melilla, Spain | ||
3782198 | 3782198 | 2020-10-13 | Spain | Melilla | 1448 | 9 | 125 | 1314 | 35.2923 | -2.9381 | 2020-10-14 04:24:05 | Melilla, Spain | ||
3778201 | 3778201 | 2020-12-27 | Spain | Melilla | 4411 | 43 | 125 | 4243 | 35.2923 | -2.9381 | 2020-12-28 05:22:06 | Melilla, Spain | ||
3774210 | 3774210 | 2022-08-30 | Spain | Melilla | 24674 | 167 | 0 | 35.2923 | -2.9381 | 2022-08-31 04:20:57 | Melilla, Spain | |||
3770174 | 3770174 | 2020-12-22 | Spain | Melilla | 4392 | 43 | 125 | 4224 | 35.2923 | -2.9381 | 2020-12-23 05:22:03 | Melilla, Spain | ||
3766183 | 3766183 | 2022-09-11 | Spain | Melilla | 24709 | 167 | 0 | 35.2923 | -2.9381 | 2022-09-12 04:20:58 | Melilla, Spain | |||
3761881 | 3761881 | 2020-12-28 | Spain | Melilla | 4445 | 43 | 125 | 4277 | 35.2923 | -2.9381 | 2020-12-29 05:22:37 | Melilla, Spain | ||
3757774 | 3757774 | 2021-09-21 | Spain | Melilla | 10920 | 106 | 0 | 35.2923 | -2.9381 | 2021-09-22 04:21:45 | Melilla, Spain | |||
3753779 | 3753779 | 2022-10-13 | Spain | Melilla | 24817 | 167 | 0 | 35.2923 | -2.9381 | 2022-10-14 04:22:28 | Melilla, Spain | |||
3749429 | 3749429 | 2021-11-22 | Spain | Melilla | 11168 | 113 | 0 | 35.2923 | -2.9381 | 2021-11-23 04:22:39 | Melilla, Spain | |||
3745415 | 3745415 | 2022-09-07 | Spain | Melilla | 24695 | 167 | 0 | 35.2923 | -2.9381 | 2022-09-08 04:21:02 | Melilla, Spain | |||
3741382 | 3741382 | 2021-07-12 | Spain | Melilla | 9384 | 97 | 125 | 9162 | 35.2923 | -2.9381 | 2021-07-13 04:21:18 | Melilla, Spain | ||
3737658 | 3737658 | 2020-07-12 | Spain | Melilla | 126 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-07-13 04:43:04 | Melilla, Spain | ||
3730536 | 3730536 | 2022-04-03 | Spain | Melilla | 20678 | 154 | 0 | 35.2923 | -2.9381 | 2022-04-04 04:20:51 | Melilla, Spain | |||
3726521 | 3726521 | 2022-06-07 | Spain | Melilla | 22130 | 154 | 0 | 35.2923 | -2.9381 | 2022-06-08 04:20:55 | Melilla, Spain | |||
3722504 | 3722504 | 2022-04-25 | Spain | Melilla | 20907 | 154 | 0 | 35.2923 | -2.9381 | 2022-04-26 04:20:51 | Melilla, Spain | |||
3718488 | 3718488 | 2022-02-21 | Spain | Melilla | 20105 | 147 | 0 | 35.2923 | -2.9381 | 2022-02-22 04:21:01 | Melilla, Spain | |||
3714475 | 3714475 | 2022-12-06 | Spain | Melilla | 25021 | 169 | 0 | 35.2923 | -2.9381 | 2022-12-07 04:20:58 | 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 | ||
3706426 | 3706426 | 2021-07-17 | Spain | Melilla | 9438 | 97 | 125 | 9216 | 35.2923 | -2.9381 | 2021-07-18 04:22:07 | 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 | ||
3695787 | 3695787 | 2020-12-31 | Spain | Melilla | 4540 | 43 | 125 | 4372 | 35.2923 | -2.9381 | 2021-01-01 05:23:07 | Melilla, Spain | ||
3691776 | 3691776 | 2020-12-24 | Spain | Melilla | 4411 | 43 | 125 | 4243 | 35.2923 | -2.9381 | 2020-12-25 05:22:48 | Melilla, Spain | ||
3687783 | 3687783 | 2022-01-13 | Spain | Melilla | 15866 | 124 | 0 | 35.2923 | -2.9381 | 2022-01-14 04:21:54 | Melilla, Spain | |||
3683752 | 3683752 | 2021-08-02 | Spain | Melilla | 9717 | 99 | 125 | 9493 | 35.2923 | -2.9381 | 2021-08-03 04:21:39 | Melilla, Spain | ||
3682693 | 3682693 | 2020-06-18 | Spain | Melilla | 124 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-06-19 04:33:17 | 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 | ||
3671955 | 3671955 | 2022-02-15 | Spain | Melilla | 19992 | 146 | 0 | 35.2923 | -2.9381 | 2022-02-16 04:21:10 | 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 | ||
3663906 | 3663906 | 2021-03-09 | Spain | Melilla | 7184 | 74 | 125 | 6985 | 35.2923 | -2.9381 | 2021-03-10 05:24:35 | Melilla, Spain | ||
3659895 | 3659895 | 2021-07-11 | Spain | Melilla | 9330 | 97 | 125 | 9108 | 35.2923 | -2.9381 | 2021-07-12 04:21:34 | Melilla, Spain | ||
3655896 | 3655896 | 2021-12-10 | Spain | Melilla | 11549 | 115 | 0 | 35.2923 | -2.9381 | 2021-12-11 04:22:45 | Melilla, Spain | |||
3651864 | 3651864 | 2020-10-24 | Spain | Melilla | 2094 | 11 | 125 | 1958 | 35.2923 | -2.9381 | 2020-10-25 04:24:36 | Melilla, Spain | ||
3647887 | 3647887 | 2022-08-14 | Spain | Melilla | 24522 | 172 | 0 | 35.2923 | -2.9381 | 2022-08-15 04:20:59 | 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 | ||
3639855 | 3639855 | 2021-11-08 | Spain | Melilla | 11085 | 112 | 0 | 35.2923 | -2.9381 | 2021-11-09 04:21:36 | Melilla, Spain | |||
3638855 | 3638855 | 2020-05-30 | Spain | Melilla | 121 | 2 | 125 | 0 | 35.2923 | -2.9381 | 2020-05-31 02:32:45 | Melilla, Spain | ||
3632258 | 3632258 | 2021-07-14 | Spain | Melilla | 9415 | 97 | 125 | 9193 | 35.2923 | -2.9381 | 2021-07-15 04:21:48 | Melilla, Spain | ||
3628260 | 3628260 | 2022-03-13 | Spain | Melilla | 20384 | 152 | 0 | 35.2923 | -2.9381 | 2022-03-14 04:20:46 | 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 | ||
3617385 | 3617385 | 2022-08-01 | Spain | Melilla | 24225 | 167 | 0 | 35.2923 | -2.9381 | 2022-08-02 04:20:53 | Melilla, Spain | |||
3613367 | 3613367 | 2022-01-12 | Spain | Melilla | 15499 | 124 | 0 | 35.2923 | -2.9381 | 2022-01-13 08:00:09 | Melilla, Spain | |||
3612281 | 3612281 | 2020-08-06 | Spain | Melilla | 148 | 2 | 125 | 21 | 35.2923 | -2.9381 | 2020-08-07 04:35:11 | Melilla, Spain | ||
3605374 | 3605374 | 2021-12-25 | Spain | Melilla | 12224 | 119 | 0 | 35.2923 | -2.9381 | 2021-12-26 04:21:50 | Melilla, Spain | |||
3601339 | 3601339 | 2021-02-17 | Spain | Melilla | 6697 | 62 | 125 | 6510 | 35.2923 | -2.9381 | 2021-02-18 05:22:58 | Melilla, Spain | ||
3597348 | 3597348 | 2022-11-14 | Spain | Melilla | 24949 | 168 | 0 | 35.2923 | -2.9381 | 2022-11-15 04:21:16 | Melilla, Spain | |||
3593330 | 3593330 | 2022-05-23 | Spain | Melilla | 21663 | 154 | 0 | 35.2923 | -2.9381 | 2022-05-24 04:20:57 | Melilla, Spain | |||
3582946 | 3582946 | 2022-05-17 | Spain | Melilla | 21537 | 154 | 0 | 35.2923 | -2.9381 | 2022-05-18 04:20:50 | Melilla, Spain | |||
3578930 | 3578930 | 2022-06-02 | Spain | Melilla | 21971 | 154 | 0 | 35.2923 | -2.9381 | 2022-06-03 04:20:58 | 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]);