johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9 rows where recovered = 3660 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829614 | 829614 | 2021-07-09 | Japan | Kagoshima | 3727 | 39 | 3660 | 28 | 31.009484000000004 | 130.430665 | 2021-07-10 04:21:25 | Kagoshima, Japan | ||
2677865 | 2677865 | 2021-02-13 | Japan | Tochigi | 3954 | 58 | 3660 | 236 | 36.689912 | 139.819213 | 2021-02-14 05:23:43 | Tochigi, Japan | ||
3761489 | 3761489 | 2020-12-28 | Gambia | 3793 | 123 | 3660 | 10 | 13.4432 | -15.3101 | 2020-12-29 05:22:37 | Gambia | |||
3777809 | 3777809 | 2020-12-27 | Gambia | 3793 | 123 | 3660 | 10 | 13.4432 | -15.3101 | 2020-12-28 05:22:06 | Gambia | |||
2497984 | 2497984 | 2020-11-03 | India | Sikkim | 4004 | 73 | 3660 | 271 | 27.571671 | 88.472712 | 2020-11-04 05:25:09 | Sikkim, India | ||
887514 | 887514 | 2020-07-07 | Russia | Stavropol Krai | 5728 | 106 | 3660 | 1962 | 44.86325770000001 | 43.4406913 | 2020-07-08 05:33:48 | Stavropol Krai, Russia | ||
2685074 | 2685074 | 2020-07-06 | Russia | Stavropol Krai | 5649 | 104 | 3660 | 1885 | 44.86325770000001 | 43.4406913 | 2020-07-07 04:34:00 | Stavropol Krai, Russia | ||
574217 | 574217 | 2020-06-06 | Mexico | Tabasco | 5293 | 640 | 3660 | 993 | 17.8409 | -92.6189 | 2020-06-07 03:53:30 | Tabasco, Mexico | ||
3416483 | 3416483 | 2020-05-17 | Morocco | 6870 | 192 | 3660 | 3018 | 31.7917 | -7.0926 | 2020-05-18 02:32:21 | Morocco |
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]);