johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where recovered = 2484 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
825628 | 825628 | 2021-06-06 | Japan | Wakayama | 2637 | 45 | 2484 | 108 | 33.911879 | 135.505446 | 2021-06-07 04:22:51 | Wakayama, Japan | ||
3254209 | 3254209 | 2021-03-02 | Liechtenstein | 2653 | 55 | 2484 | 114 | 47.14 | 9.55 | 2021-03-03 05:23:28 | Liechtenstein | |||
998501 | 998501 | 2021-03-01 | Liechtenstein | 2652 | 55 | 2484 | 113 | 47.14 | 9.55 | 2021-03-02 05:23:30 | Liechtenstein | |||
2367559 | 2367559 | 2021-02-28 | Liechtenstein | 2648 | 55 | 2484 | 109 | 47.14 | 9.55 | 2021-03-01 05:23:01 | Liechtenstein | |||
3066061 | 3066061 | 2021-02-27 | Liechtenstein | 2643 | 55 | 2484 | 104 | 47.14 | 9.55 | 2021-02-28 05:22:20 | Liechtenstein | |||
2183645 | 2183645 | 2021-02-26 | Liechtenstein | 2642 | 55 | 2484 | 103 | 47.14 | 9.55 | 2021-02-27 05:22:28 | Liechtenstein | |||
1858067 | 1858067 | 2021-02-25 | Liechtenstein | 2640 | 55 | 2484 | 101 | 47.14 | 9.55 | 2021-02-26 05:22:40 | Liechtenstein | |||
280245 | 280245 | 2021-02-24 | Liechtenstein | 2633 | 55 | 2484 | 94 | 47.14 | 9.55 | 2021-02-25 05:24:57 | Liechtenstein | |||
1936513 | 1936513 | 2021-02-23 | Liechtenstein | 2627 | 55 | 2484 | 88 | 47.14 | 9.55 | 2021-02-24 05:29:16 | Liechtenstein | |||
530768 | 530768 | 2021-02-22 | Liechtenstein | 2624 | 55 | 2484 | 85 | 47.14 | 9.55 | 2021-02-23 05:23:41 | Liechtenstein | |||
182102 | 182102 | 2021-02-21 | Liechtenstein | 2620 | 55 | 2484 | 81 | 47.14 | 9.55 | 2021-02-22 05:24:21 | Liechtenstein | |||
742376 | 742376 | 2021-02-20 | Liechtenstein | 2619 | 55 | 2484 | 80 | 47.14 | 9.55 | 2021-02-21 05:24:33 | Liechtenstein | |||
471474 | 471474 | 2021-02-19 | Liechtenstein | 2619 | 55 | 2484 | 80 | 47.14 | 9.55 | 2021-02-20 05:22:51 | Liechtenstein | |||
1153183 | 1153183 | 2021-02-18 | Liechtenstein | 2617 | 55 | 2484 | 78 | 47.14 | 9.55 | 2021-02-19 05:24:16 | Liechtenstein | |||
966967 | 966967 | 2020-09-29 | Malta | 3035 | 34 | 2484 | 517 | 35.9375 | 14.3754 | 2020-09-30 04:23:33 | Malta | |||
1483228 | 1483228 | 2020-08-21 | Malaysia | W.P. Kuala Lumpur | 2550 | 18 | 2484 | 48 | 3.139 | 101.6869 | 2020-08-22 04:27:49 | W.P. Kuala Lumpur, Malaysia | ||
371234 | 371234 | 2020-08-08 | Colombia | Choco | 3168 | 114 | 2484 | 570 | 5.2528 | -76.82600000000002 | 2020-08-09 04:34:54 | Choco, Colombia | ||
3185385 | 3185385 | 2020-07-28 | Russia | Tomsk Oblast | 3979 | 31 | 2484 | 1464 | 58.6124279 | 82.04753149999998 | 2020-07-29 04:35:11 | Tomsk Oblast, Russia | ||
2158768 | 2158768 | 2020-07-14 | Mexico | Morelos | 3389 | 750 | 2484 | 155 | 18.6813 | -99.1013 | 2020-07-15 04:34:39 | Morelos, Mexico |
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]);