johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
70 rows where country_or_region = "United Kingdom", province_or_state = "Saint Helena, Ascension and Tristan da Cunha" and recovered = 2 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, last_update (date)
province_or_state 1
- Saint Helena, Ascension and Tristan da Cunha · 70 ✖
country_or_region 1
- United Kingdom · 70 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3342243 | 3342243 | 2020-11-17 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 3 | 0 | 2 | 1 | -7.9467 | -14.3559 | 2020-11-18 05:40:31 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3173288 | 3173288 | 2020-11-16 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 3 | 0 | 2 | 1 | -7.9467 | -14.3559 | 2020-11-17 05:25:54 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2883856 | 2883856 | 2020-11-15 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-16 05:25:57 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2918834 | 2918834 | 2020-11-14 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-15 05:26:53 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2788656 | 2788656 | 2020-11-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-14 05:25:37 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
868421 | 868421 | 2020-11-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-13 05:25:30 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3444465 | 3444465 | 2020-11-11 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-12 05:25:55 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
275805 | 275805 | 2020-11-10 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-11 05:25:30 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1992282 | 1992282 | 2020-11-09 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-10 05:40:07 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1732134 | 1732134 | 2020-11-08 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-09 05:25:45 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1547594 | 1547594 | 2020-11-07 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-08 05:24:56 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
379832 | 379832 | 2020-11-06 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-07 05:24:52 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
895770 | 895770 | 2020-11-05 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-06 05:24:55 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2922832 | 2922832 | 2020-11-04 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-05 06:05:03 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2501668 | 2501668 | 2020-11-03 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-04 05:25:09 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3307843 | 3307843 | 2020-11-02 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-03 06:00:16 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3413092 | 3413092 | 2020-11-01 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-02 05:25:04 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2083581 | 2083581 | 2020-10-31 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-11-01 04:36:19 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2247034 | 2247034 | 2020-10-30 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-31 04:24:44 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
213889 | 213889 | 2020-10-29 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-30 04:24:49 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
757951 | 757951 | 2020-10-28 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-29 04:24:49 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1456235 | 1456235 | 2020-10-27 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-28 04:24:39 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3483959 | 3483959 | 2020-10-26 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-27 04:24:45 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
11980 | 11980 | 2020-10-25 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-26 04:25:02 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3655217 | 3655217 | 2020-10-24 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-25 04:24:36 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1057472 | 1057472 | 2020-10-23 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-24 04:24:46 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1181142 | 1181142 | 2020-10-22 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-23 04:24:46 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2195247 | 2195247 | 2020-10-21 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-22 04:24:27 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3994258 | 3994258 | 2020-10-20 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-21 04:24:14 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1798278 | 1798278 | 2020-10-19 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-20 04:24:22 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
765961 | 765961 | 2020-10-18 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-19 04:24:16 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1029999 | 1029999 | 2020-10-17 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-18 04:24:25 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2860494 | 2860494 | 2020-10-16 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-17 04:24:12 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
790023 | 790023 | 2020-10-15 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-16 04:24:01 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
82734 | 82734 | 2020-10-14 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-15 04:24:28 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3785549 | 3785549 | 2020-10-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-14 04:24:05 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2295089 | 2295089 | 2020-10-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-13 04:24:02 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3789541 | 3789541 | 2020-10-11 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-12 04:23:45 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2605679 | 2605679 | 2020-10-10 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-11 04:23:46 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
821212 | 821212 | 2020-10-09 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-10 04:23:57 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2693327 | 2693327 | 2020-10-08 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-09 04:23:59 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1045469 | 1045469 | 2020-10-07 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-08 04:23:56 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3121130 | 3121130 | 2020-10-06 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-07 04:23:40 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3805542 | 3805542 | 2020-10-05 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-06 04:23:33 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1826432 | 1826432 | 2020-10-04 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-05 04:23:33 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2517816 | 2517816 | 2020-10-03 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-04 04:23:44 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3393034 | 3393034 | 2020-10-02 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-03 04:23:40 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2383275 | 2383275 | 2020-10-01 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-02 04:23:51 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1049461 | 1049461 | 2020-09-30 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-10-01 04:23:42 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
970542 | 970542 | 2020-09-29 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-30 04:23:33 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1519039 | 1519039 | 2020-09-28 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-29 04:23:42 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2585627 | 2585627 | 2020-09-27 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-28 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2617679 | 2617679 | 2020-09-26 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-27 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2816394 | 2816394 | 2020-09-25 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-26 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2609671 | 2609671 | 2020-09-24 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-25 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2657414 | 2657414 | 2020-09-23 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-24 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3319863 | 3319863 | 2020-09-22 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-23 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2840462 | 2840462 | 2020-09-21 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-22 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3097065 | 3097065 | 2020-09-20 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-21 04:23:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2458415 | 2458415 | 2020-09-19 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-20 04:22:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2852484 | 2852484 | 2020-09-18 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-19 04:22:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1125233 | 1125233 | 2020-09-17 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-18 05:05:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
669922 | 669922 | 2020-09-16 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-17 04:22:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2732647 | 2732647 | 2020-09-15 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-16 04:22:53 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
347919 | 347919 | 2020-09-14 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-15 03:22:50 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2872358 | 2872358 | 2020-09-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-14 04:26:00 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
550397 | 550397 | 2020-09-12 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-13 04:30:52 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1448226 | 1448226 | 2020-09-11 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-12 04:25:05 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
1176827 | 1176827 | 2020-09-10 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-11 04:46:23 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
2175192 | 2175192 | 2020-09-09 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2 | 0 | 2 | 0 | -7.9467 | -14.3559 | 2020-09-10 04:29:01 | Saint Helena, Ascension and Tristan da Cunha, 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]);