johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
11 rows where active = 27 and province_or_state = "Gibraltar" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, day (date)
province_or_state 1
- Gibraltar · 11 ✖
country_or_region 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1715980 | 1715980 | 2021-06-25 | United Kingdom | Gibraltar | 4338 | 94 | 4217 | 27 | 36.1408 | -5.3536 | 2021-06-26 04:21:43 | Gibraltar, United Kingdom | ||
1583801 | 1583801 | 2021-03-13 | United Kingdom | Gibraltar | 4263 | 94 | 4142 | 27 | 36.1408 | -5.3536 | 2021-03-14 05:25:37 | Gibraltar, United Kingdom | ||
355945 | 355945 | 2021-03-11 | United Kingdom | Gibraltar | 4259 | 93 | 4139 | 27 | 36.1408 | -5.3536 | 2021-03-12 05:26:50 | Gibraltar, United Kingdom | ||
2840458 | 2840458 | 2020-09-21 | United Kingdom | Gibraltar | 350 | 0 | 323 | 27 | 36.1408 | -5.3536 | 2020-09-22 04:23:00 | Gibraltar, United Kingdom | ||
3097061 | 3097061 | 2020-09-20 | United Kingdom | Gibraltar | 350 | 0 | 323 | 27 | 36.1408 | -5.3536 | 2020-09-21 04:23:00 | Gibraltar, United Kingdom | ||
2732643 | 2732643 | 2020-09-15 | United Kingdom | Gibraltar | 334 | 0 | 307 | 27 | 36.1408 | -5.3536 | 2020-09-16 04:22:53 | Gibraltar, United Kingdom | ||
347915 | 347915 | 2020-09-14 | United Kingdom | Gibraltar | 330 | 0 | 303 | 27 | 36.1408 | -5.3536 | 2020-09-15 03:22:50 | Gibraltar, United Kingdom | ||
3181641 | 3181641 | 2020-08-18 | United Kingdom | Gibraltar | 222 | 0 | 195 | 27 | 36.1408 | -5.3536 | 2020-08-19 04:27:00 | Gibraltar, United Kingdom | ||
50192 | 50192 | 2020-04-17 | United Kingdom | Gibraltar | 132 | 0 | 105 | 27 | 36.1408 | -5.3536 | 2020-04-17 23:30:32 | Gibraltar, United Kingdom | ||
934186 | 934186 | 2020-04-16 | United Kingdom | Gibraltar | 131 | 0 | 104 | 27 | 36.1408 | -5.3536 | 2020-04-16 23:30:31 | Gibraltar, United Kingdom | ||
860080 | 860080 | 2020-04-15 | United Kingdom | Gibraltar | 131 | 0 | 104 | 27 | 36.1408 | -5.3536 | 2020-04-15 22:56:32 | Gibraltar, United Kingdom |
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]);