johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where country_or_region = "Ecuador" and recovered = 3433 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3261026 | 3261026 | 2020-05-18 | Ecuador | 33582 | 2799 | 3433 | 27350 | -1.8312 | -78.1834 | 2020-05-19 02:32:18 | Ecuador | |||
3416420 | 3416420 | 2020-05-17 | Ecuador | 33182 | 2736 | 3433 | 27013 | -1.8312 | -78.1834 | 2020-05-18 02:32:21 | Ecuador | |||
1829654 | 1829654 | 2020-05-16 | Ecuador | 32763 | 2688 | 3433 | 26642 | -1.8312 | -78.1834 | 2020-05-17 02:32:32 | Ecuador | |||
3276370 | 3276370 | 2020-05-15 | Ecuador | 31467 | 2594 | 3433 | 25440 | -1.8312 | -78.1834 | 2020-05-16 02:32:19 | Ecuador | |||
1404544 | 1404544 | 2020-05-14 | Ecuador | 30502 | 2338 | 3433 | 24731 | -1.8312 | -78.1834 | 2020-05-15 02:33:02 | Ecuador | |||
3847304 | 3847304 | 2020-05-13 | Ecuador | 30486 | 2334 | 3433 | 24719 | -1.8312 | -78.1834 | 2020-05-14 03:32:28 | Ecuador | |||
2581511 | 2581511 | 2020-05-12 | Ecuador | 30419 | 2327 | 3433 | 24659 | -1.8312 | -78.1834 | 2020-05-13 03:32:26 | Ecuador | |||
3331045 | 3331045 | 2020-05-11 | Ecuador | 29509 | 2145 | 3433 | 23931 | -1.8312 | -78.1834 | 2020-05-12 03:32:27 | Ecuador | |||
3459660 | 3459660 | 2020-05-10 | Ecuador | 29559 | 2127 | 3433 | 23999 | -1.8312 | -78.1834 | 2020-05-11 02:32:30 | Ecuador | |||
2899201 | 2899201 | 2020-05-09 | Ecuador | 29071 | 1717 | 3433 | 23921 | -1.8312 | -78.1834 | 2020-05-10 02:32:30 | Ecuador | |||
114250 | 114250 | 2020-05-08 | Ecuador | 28818 | 1704 | 3433 | 23681 | -1.8312 | -78.1834 | 2020-05-09 02:32:35 | Ecuador | |||
3295693 | 3295693 | 2020-05-07 | Ecuador | 30298 | 1654 | 3433 | 25211 | -1.8312 | -78.1834 | 2020-05-08 02:32:32 | Ecuador | |||
2110914 | 2110914 | 2020-05-06 | Ecuador | 31881 | 1618 | 3433 | 26830 | -1.8312 | -78.1834 | 2020-05-07 02:32:28 | Ecuador | |||
1931954 | 1931954 | 2020-05-05 | Ecuador | 31881 | 1569 | 3433 | 26879 | -1.8312 | -78.1834 | 2020-05-06 02:32:31 | Ecuador | |||
3084817 | 3084817 | 2020-05-04 | Ecuador | 31881 | 1569 | 3433 | 26879 | -1.8312 | -78.1834 | 2020-05-05 02:32:34 | Ecuador |
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]);