johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
29 rows where country_or_region = "Spain" and deaths = 99 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, longitude
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2175854 | 2175854 | 2021-08-22 | Spain | Melilla | 10281 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-23 04:21:27 | Melilla, Spain | |||
3555950 | 3555950 | 2021-08-21 | Spain | Melilla | 10281 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-22 04:21:29 | Melilla, Spain | |||
1854292 | 1854292 | 2021-08-20 | Spain | Melilla | 10281 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-21 04:21:38 | Melilla, Spain | |||
511999 | 511999 | 2021-08-19 | Spain | Melilla | 10239 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-20 04:21:33 | Melilla, Spain | |||
2518478 | 2518478 | 2021-08-18 | Spain | Melilla | 10203 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-19 04:21:15 | Melilla, Spain | |||
245570 | 245570 | 2021-08-17 | Spain | Melilla | 10181 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-18 04:21:35 | Melilla, Spain | |||
1604533 | 1604533 | 2021-08-16 | Spain | Melilla | 10152 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-17 04:21:49 | Melilla, Spain | |||
103627 | 103627 | 2021-08-15 | Spain | Melilla | 10098 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-16 04:21:31 | Melilla, Spain | |||
507985 | 507985 | 2021-08-14 | Spain | Melilla | 10098 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-15 04:21:41 | Melilla, Spain | |||
1483857 | 1483857 | 2021-08-13 | Spain | Melilla | 10098 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-14 04:21:25 | Melilla, Spain | |||
2899987 | 2899987 | 2021-08-12 | Spain | Melilla | 10092 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-13 04:21:24 | Melilla, Spain | |||
1342591 | 1342591 | 2021-08-11 | Spain | Melilla | 10072 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-12 04:21:25 | Melilla, Spain | |||
2351738 | 2351738 | 2021-08-10 | Spain | Melilla | 10047 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-11 04:21:58 | Melilla, Spain | |||
650267 | 650267 | 2021-08-09 | Spain | Melilla | 10024 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-10 04:21:27 | Melilla, Spain | |||
589929 | 589929 | 2021-08-08 | Spain | Melilla | 9968 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-09 04:21:24 | Melilla, Spain | |||
2203941 | 2203941 | 2021-08-07 | Spain | Melilla | 9968 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-08 04:21:33 | Melilla, Spain | |||
1117891 | 1117891 | 2021-08-06 | Spain | Melilla | 9968 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-07 04:21:30 | Melilla, Spain | |||
1956828 | 1956828 | 2021-08-05 | Spain | Melilla | 9940 | 99 | 0 | 35.2923 | -2.9381 | 2021-08-06 04:21:18 | Melilla, Spain | |||
332207 | 332207 | 2021-08-04 | Spain | Melilla | 9880 | 99 | 125 | 9656 | 35.2923 | -2.9381 | 2021-08-05 04:21:51 | Melilla, Spain | ||
3468478 | 3468478 | 2021-08-03 | Spain | Melilla | 9743 | 99 | 125 | 9519 | 35.2923 | -2.9381 | 2021-08-04 04:21:25 | 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 | ||
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 |
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]);