daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,034 rows where country_or_region = "Ecuador" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: active, day (date), last_update (date)
country_or_region 1
- Ecuador · 1,034 ✖
province_or_state 0
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-01 | Ecuador | 6 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-01T23:33:03 | |||||
2020-03-02 | Ecuador | 6 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-01T23:33:03 | |||||
2020-03-03 | Ecuador | 7 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-03T15:13:26 | |||||
2020-03-04 | Ecuador | 10 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-04T19:33:03 | |||||
2020-03-05 | Ecuador | 13 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-05T17:53:02 | |||||
2020-03-07 | Ecuador | 13 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-05T17:53:02 | |||||
2020-03-06 | Ecuador | 13 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-05T17:53:02 | |||||
2020-03-08 | Ecuador | 14 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-08T05:23:03 | |||||
2020-03-09 | Ecuador | 15 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-09T09:03:03 | |||||
2020-03-10 | Ecuador | 15 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-09T09:03:03 | |||||
2020-03-11 | Ecuador | 17 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-11T09:33:12 | |||||
2020-03-12 | Ecuador | 17 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-11T09:33:12 | |||||
2020-03-13 | Ecuador | 17 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-11T20:00:00 | |||||
2020-03-15 | Ecuador | 28 | 2 | 0 | -1.8312 | -78.1834 | 2020-03-14T22:53:02 | |||||
2020-03-14 | Ecuador | 28 | 2 | 0 | -1.8312 | -78.1834 | 2020-03-14T22:53:02 | |||||
2020-03-16 | Ecuador | 37 | 2 | 0 | -1.8312 | -78.1834 | 2020-03-16T02:33:08 | |||||
2020-03-17 | Ecuador | 58 | 2 | 0 | -1.8312 | -78.1834 | 2020-03-17T03:13:15 | |||||
2020-03-18 | Ecuador | 111 | 2 | 0 | -1.8312 | -78.1834 | 2020-03-18T03:13:19 | |||||
2020-03-19 | Ecuador | 199 | 3 | 0 | -1.8312 | -78.1834 | 2020-03-19T17:13:14 | |||||
2020-03-20 | Ecuador | 367 | 5 | 0 | -1.8312 | -78.1834 | 2020-03-20T20:43:02 | |||||
2020-03-21 | Ecuador | 506 | 7 | 3 | -1.8312 | -78.1834 | 2020-03-21T20:43:02 | |||||
2020-03-22 | Ecuador | 789 | 14 | 3 | 772 | -1.8312 | -78.1834 | 3/22/20 23:45 | Ecuador | |||
2020-03-23 | Ecuador | 981 | 18 | 3 | 960 | -1.8312 | -78.1834 | 2020-03-23 23:19:21 | Ecuador | |||
2020-03-24 | Ecuador | 1082 | 27 | 3 | 1052 | -1.8312 | -78.1834 | 2020-03-24 23:37:15 | Ecuador | |||
2020-03-25 | Ecuador | 1173 | 28 | 3 | 1142 | -1.8312 | -78.1834 | 2020-03-25 23:33:04 | Ecuador | |||
2020-03-26 | Ecuador | 1403 | 34 | 3 | 1366 | -1.8312 | -78.1834 | 2020-03-26 23:48:18 | Ecuador | |||
2020-03-27 | Ecuador | 1595 | 36 | 3 | 1556 | -1.8312 | -78.1834 | 2020-03-27 23:23:03 | Ecuador | |||
2020-03-28 | Ecuador | 1823 | 48 | 3 | 1772 | -1.8312 | -78.1834 | 3/28/20 23:05 | Ecuador | |||
2020-03-29 | Ecuador | 1924 | 58 | 3 | 1863 | -1.8312 | -78.1834 | 3/29/20 23:08 | Ecuador | |||
2020-03-30 | Ecuador | 1962 | 60 | 3 | 1899 | -1.8312 | -78.1834 | 3/30/20 22:52 | Ecuador | |||
2020-03-31 | Ecuador | 2240 | 75 | 54 | 2111 | -1.8312 | -78.1834 | 2020-03-31 23:43:43 | Ecuador | |||
2020-04-01 | Ecuador | 2748 | 93 | 58 | 2597 | -1.8312 | -78.1834 | 2020-04-01 21:58:34 | Ecuador | |||
2020-04-02 | Ecuador | 3163 | 120 | 65 | 2978 | -1.8312 | -78.1834 | 4/2/20 23:25 | Ecuador | |||
2020-04-03 | Ecuador | 3368 | 145 | 65 | 3158 | -1.8312 | -78.1834 | 2020-04-03 22:46:20 | Ecuador | |||
2020-04-04 | Ecuador | 3465 | 172 | 100 | 3193 | -1.8312 | -78.1834 | 4/4/20 23:34 | Ecuador | |||
2020-04-05 | Ecuador | 3646 | 180 | 100 | 3366 | -1.8312 | -78.1834 | 2020-04-05 23:06:26 | Ecuador | |||
2020-04-07 | Ecuador | 3747 | 191 | 100 | 3456 | -1.8312 | -78.1834 | 2020-04-07 23:04:29 | Ecuador | |||
2020-04-06 | Ecuador | 3747 | 191 | 100 | 3456 | -1.8312 | -78.1834 | 4/6/20 23:21 | Ecuador | |||
2020-04-08 | Ecuador | 4450 | 242 | 140 | 4068 | -1.8312 | -78.1834 | 2020-04-08 22:51:39 | Ecuador | |||
2020-04-09 | Ecuador | 4965 | 272 | 339 | 4354 | -1.8312 | -78.1834 | 2020-04-09 23:02:19 | Ecuador | |||
2020-04-10 | Ecuador | 7161 | 297 | 368 | 6496 | -1.8312 | -78.1834 | 2020-04-10 22:53:48 | Ecuador | |||
2020-04-11 | Ecuador | 7257 | 315 | 411 | 6531 | -1.8312 | -78.1834 | 2020-04-11 22:45:13 | Ecuador | |||
2020-04-12 | Ecuador | 7466 | 333 | 501 | 6632 | -1.8312 | -78.1834 | 2020-04-12 23:17:00 | Ecuador | |||
2020-04-13 | Ecuador | 7529 | 355 | 597 | 6577 | -1.8312 | -78.1834 | 2020-04-13 23:07:34 | Ecuador | |||
2020-04-14 | Ecuador | 7603 | 369 | 696 | 6538 | -1.8312 | -78.1834 | 2020-04-14 23:33:12 | Ecuador | |||
2020-04-15 | Ecuador | 7858 | 388 | 780 | 6690 | -1.8312 | -78.1834 | 2020-04-15 22:56:32 | Ecuador | |||
2020-04-16 | Ecuador | 8225 | 403 | 838 | 6984 | -1.8312 | -78.1834 | 2020-04-16 23:30:31 | Ecuador | |||
2020-04-17 | Ecuador | 8450 | 421 | 838 | 7191 | -1.8312 | -78.1834 | 2020-04-17 23:30:32 | Ecuador | |||
2020-04-18 | Ecuador | 9022 | 456 | 1008 | 7558 | -1.8312 | -78.1834 | 2020-04-18 22:32:28 | Ecuador | |||
2020-04-19 | Ecuador | 9468 | 474 | 1061 | 7933 | -1.8312 | -78.1834 | 2020-04-19 23:40:41 | Ecuador | |||
2020-04-20 | Ecuador | 10128 | 507 | 1150 | 8471 | -1.8312 | -78.1834 | 2020-04-20 23:36:27 | Ecuador | |||
2020-04-21 | Ecuador | 10398 | 520 | 1207 | 8671 | -1.8312 | -78.1834 | 2020-04-21 23:30:30 | Ecuador | |||
2020-04-22 | Ecuador | 10850 | 537 | 1262 | 9051 | -1.8312 | -78.1834 | 2020-04-22 23:30:32 | Ecuador | |||
2020-04-23 | Ecuador | 11183 | 560 | 1328 | 9295 | -1.8312 | -78.1834 | 2020-04-24 03:30:31 | Ecuador | |||
2020-04-24 | Ecuador | 22719 | 576 | 1366 | 20777 | -1.8312 | -78.1834 | 2020-04-25 06:30:33 | Ecuador | |||
2020-04-25 | Ecuador | 22719 | 576 | 1366 | 20777 | -1.8312 | -78.1834 | 2020-04-26 02:30:31 | Ecuador | |||
2020-04-26 | Ecuador | 22719 | 576 | 1366 | 20777 | -1.8312 | -78.1834 | 2020-04-27 02:30:33 | Ecuador | |||
2020-04-27 | Ecuador | 23240 | 663 | 1557 | 21020 | -1.8312 | -78.1834 | 2020-04-28 02:30:32 | Ecuador | |||
2020-04-28 | Ecuador | 24258 | 871 | 1557 | 21830 | -1.8312 | -78.1834 | 2020-04-29 02:32:29 | Ecuador | |||
2020-04-29 | Ecuador | 24675 | 883 | 1557 | 22235 | -1.8312 | -78.1834 | 2020-04-30 02:32:27 | Ecuador | |||
2020-04-30 | Ecuador | 24934 | 900 | 1558 | 22476 | -1.8312 | -78.1834 | 2020-05-01 02:32:28 | Ecuador | |||
2020-05-01 | Ecuador | 26336 | 1063 | 1913 | 23360 | -1.8312 | -78.1834 | 2020-05-02 02:32:27 | Ecuador | |||
2020-05-02 | Ecuador | 27464 | 1371 | 2132 | 23961 | -1.8312 | -78.1834 | 2020-05-03 02:32:28 | Ecuador | |||
2020-05-08 | Ecuador | 28818 | 1704 | 3433 | 23681 | -1.8312 | -78.1834 | 2020-05-09 02:32:35 | Ecuador | |||
2020-05-09 | Ecuador | 29071 | 1717 | 3433 | 23921 | -1.8312 | -78.1834 | 2020-05-10 02:32:30 | Ecuador | |||
2020-05-11 | Ecuador | 29509 | 2145 | 3433 | 23931 | -1.8312 | -78.1834 | 2020-05-12 03:32:27 | Ecuador | |||
2020-05-03 | Ecuador | 29538 | 1564 | 3300 | 24674 | -1.8312 | -78.1834 | 2020-05-04 02:32:28 | Ecuador | |||
2020-05-10 | Ecuador | 29559 | 2127 | 3433 | 23999 | -1.8312 | -78.1834 | 2020-05-11 02:32:30 | Ecuador | |||
2020-05-07 | Ecuador | 30298 | 1654 | 3433 | 25211 | -1.8312 | -78.1834 | 2020-05-08 02:32:32 | Ecuador | |||
2020-05-12 | Ecuador | 30419 | 2327 | 3433 | 24659 | -1.8312 | -78.1834 | 2020-05-13 03:32:26 | Ecuador | |||
2020-05-13 | Ecuador | 30486 | 2334 | 3433 | 24719 | -1.8312 | -78.1834 | 2020-05-14 03:32:28 | Ecuador | |||
2020-05-14 | Ecuador | 30502 | 2338 | 3433 | 24731 | -1.8312 | -78.1834 | 2020-05-15 02:33:02 | Ecuador | |||
2020-05-15 | Ecuador | 31467 | 2594 | 3433 | 25440 | -1.8312 | -78.1834 | 2020-05-16 02:32:19 | Ecuador | |||
2020-05-05 | Ecuador | 31881 | 1569 | 3433 | 26879 | -1.8312 | -78.1834 | 2020-05-06 02:32:31 | Ecuador | |||
2020-05-06 | Ecuador | 31881 | 1618 | 3433 | 26830 | -1.8312 | -78.1834 | 2020-05-07 02:32:28 | Ecuador | |||
2020-05-04 | Ecuador | 31881 | 1569 | 3433 | 26879 | -1.8312 | -78.1834 | 2020-05-05 02:32:34 | Ecuador | |||
2020-05-16 | Ecuador | 32763 | 2688 | 3433 | 26642 | -1.8312 | -78.1834 | 2020-05-17 02:32:32 | Ecuador | |||
2020-05-17 | Ecuador | 33182 | 2736 | 3433 | 27013 | -1.8312 | -78.1834 | 2020-05-18 02:32:21 | Ecuador | |||
2020-05-18 | Ecuador | 33582 | 2799 | 3433 | 27350 | -1.8312 | -78.1834 | 2020-05-19 02:32:18 | Ecuador | |||
2020-05-19 | Ecuador | 34151 | 2839 | 3457 | 27855 | -1.8312 | -78.1834 | 2020-05-20 02:32:19 | Ecuador | |||
2020-05-20 | Ecuador | 34854 | 2888 | 3557 | 28409 | -1.8312 | -78.1834 | 2020-05-21 02:32:48 | Ecuador | |||
2020-05-21 | Ecuador | 35306 | 2939 | 3557 | 28810 | -1.8312 | -78.1834 | 2020-05-22 02:36:51 | Ecuador | |||
2020-05-22 | Ecuador | 35828 | 3056 | 3557 | 29215 | -1.8312 | -78.1834 | 2020-05-23 02:32:42 | Ecuador | |||
2020-05-23 | Ecuador | 36258 | 3096 | 3557 | 29605 | -1.8312 | -78.1834 | 2020-05-24 02:32:43 | Ecuador | |||
2020-05-24 | Ecuador | 36756 | 3108 | 3560 | 30088 | -1.8312 | -78.1834 | 2020-05-25 02:32:44 | Ecuador | |||
2020-05-26 | Ecuador | 37355 | 3203 | 18003 | 16149 | -1.8312 | -78.1834 | 2020-05-27 02:32:31 | Ecuador | |||
2020-05-25 | Ecuador | 37355 | 3203 | 18003 | 16149 | -1.8312 | -78.1834 | 2020-05-26 02:32:35 | Ecuador | |||
2020-05-27 | Ecuador | 38103 | 3275 | 18425 | 16403 | -1.8312 | -78.1834 | 2020-05-28 02:32:31 | Ecuador | |||
2020-05-28 | Ecuador | 38471 | 3313 | 18425 | 16733 | -1.8312 | -78.1834 | 2020-05-29 02:32:50 | Ecuador | |||
2020-05-29 | Ecuador | 38571 | 3334 | 19190 | 16047 | -1.8312 | -78.1834 | 2020-05-30 02:32:48 | Ecuador | |||
2020-05-30 | Ecuador | 38571 | 3334 | 19190 | 16047 | -1.8312 | -78.1834 | 2020-05-31 02:32:45 | Ecuador | |||
2020-06-01 | Ecuador | 39098 | 3358 | 19592 | 16148 | -1.8312 | -78.1834 | 2020-06-02 02:33:08 | Ecuador | |||
2020-05-31 | Ecuador | 39098 | 3358 | 19592 | 16148 | -1.8312 | -78.1834 | 2020-06-01 02:32:46 | Ecuador | |||
2020-06-02 | Ecuador | 40414 | 3438 | 20019 | 16957 | -1.8312 | -78.1834 | 2020-06-03 02:33:13 | Ecuador | |||
2020-06-04 | Ecuador | 40966 | 3486 | 20019 | 17461 | -1.8312 | -78.1834 | 2020-06-05 02:33:06 | Ecuador | |||
2020-06-03 | Ecuador | 40966 | 3486 | 20019 | 17461 | -1.8312 | -78.1834 | 2020-06-04 02:33:14 | Ecuador | |||
2020-06-05 | Ecuador | 41575 | 3534 | 20568 | 17473 | -1.8312 | -78.1834 | 2020-06-06 02:33:00 | Ecuador | |||
2020-06-06 | Ecuador | 42728 | 3608 | 21020 | 18100 | -1.8312 | -78.1834 | 2020-06-07 03:53:30 | Ecuador | |||
2020-06-07 | Ecuador | 43120 | 3621 | 21020 | 18479 | -1.8312 | -78.1834 | 2020-06-08 03:33:22 | Ecuador | |||
2020-06-08 | Ecuador | 43378 | 3642 | 21020 | 18716 | -1.8312 | -78.1834 | 2020-06-09 03:33:03 | Ecuador |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;