daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where province_or_state = "Canarias" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, day (date), last_update (date)
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-14 | Spain | Canarias | 2275 | 151 | 1496 | 628 | 28.2916 | -16.6291 | 2020-05-15 02:33:02 | Canarias, Spain | ||
2020-05-15 | Spain | Canarias | 2280 | 151 | 1506 | 623 | 28.2916 | -16.6291 | 2020-05-16 02:32:19 | Canarias, Spain | ||
2020-05-16 | Spain | Canarias | 2284 | 151 | 1524 | 609 | 28.2916 | -16.6291 | 2020-05-17 02:32:32 | Canarias, Spain | ||
2020-05-17 | Spain | Canarias | 2284 | 151 | 1524 | 609 | 28.2916 | -16.6291 | 2020-05-18 02:32:21 | Canarias, Spain | ||
2020-05-18 | Spain | Canarias | 2294 | 153 | 1537 | 604 | 28.2916 | -16.6291 | 2020-05-19 02:32:18 | Canarias, Spain | ||
2020-05-19 | Spain | Canarias | 2294 | 155 | 0 | 2139 | 28.2916 | -16.6291 | 2020-05-20 02:32:19 | Canarias, Spain | ||
2020-05-20 | Spain | Canarias | 2300 | 155 | 0 | 2145 | 28.2916 | -16.6291 | 2020-05-21 02:32:48 | Canarias, Spain | ||
2020-05-21 | Spain | Canarias | 2307 | 155 | 0 | 2152 | 28.2916 | -16.6291 | 2020-05-22 02:36:51 | Canarias, Spain | ||
2020-05-22 | Spain | Canarias | 2312 | 155 | 0 | 2157 | 28.2916 | -16.6291 | 2020-05-23 02:32:42 | Canarias, Spain | ||
2020-05-23 | Spain | Canarias | 2321 | 157 | 0 | 2164 | 28.2916 | -16.6291 | 2020-05-24 02:32:43 | Canarias, Spain | ||
2020-05-24 | Spain | Canarias | 2322 | 157 | 0 | 2165 | 28.2916 | -16.6291 | 2020-05-25 02:32:44 | Canarias, Spain | ||
2020-05-25 | Spain | Canarias | 2317 | 150 | 0 | 2167 | 28.2916 | -16.6291 | 2020-05-26 02:32:35 | Canarias, Spain | ||
2020-05-26 | Spain | Canarias | 2323 | 150 | 1537 | 636 | 28.2916 | -16.6291 | 2020-05-27 02:32:31 | Canarias, Spain | ||
2020-05-27 | Spain | Canarias | 2323 | 150 | 1537 | 636 | 28.2916 | -16.6291 | 2020-05-28 02:32:31 | Canarias, Spain | ||
2020-05-28 | Spain | Canarias | 2327 | 151 | 1537 | 639 | 28.2916 | -16.6291 | 2020-05-29 02:32:50 | Canarias, Spain | ||
2020-05-29 | Spain | Canarias | 2333 | 151 | 1537 | 645 | 28.2916 | -16.6291 | 2020-05-30 02:32:48 | Canarias, Spain | ||
2020-05-30 | Spain | Canarias | 2343 | 151 | 1537 | 655 | 28.2916 | -16.6291 | 2020-05-31 02:32:45 | Canarias, Spain | ||
2020-05-31 | Spain | Canarias | 2345 | 151 | 1537 | 657 | 28.2916 | -16.6291 | 2020-06-01 02:32:46 | Canarias, Spain | ||
2020-06-01 | Spain | Canarias | 2347 | 151 | 1537 | 659 | 28.2916 | -16.6291 | 2020-06-02 02:33:08 | Canarias, Spain | ||
2020-06-02 | Spain | Canarias | 2351 | 151 | 1537 | 663 | 28.2916 | -16.6291 | 2020-06-03 02:33:13 | Canarias, Spain | ||
2020-06-03 | Spain | Canarias | 2357 | 151 | 1537 | 669 | 28.2916 | -16.6291 | 2020-06-04 02:33:14 | Canarias, Spain | ||
2020-06-04 | Spain | Canarias | 2361 | 151 | 1537 | 673 | 28.2916 | -16.6291 | 2020-06-05 02:33:06 | Canarias, Spain | ||
2020-06-05 | Spain | Canarias | 2362 | 151 | 1537 | 674 | 28.2916 | -16.6291 | 2020-06-06 02:33:00 | Canarias, Spain | ||
2020-06-06 | Spain | Canarias | 2364 | 151 | 1537 | 676 | 28.2916 | -16.6291 | 2020-06-07 03:53:30 | Canarias, Spain | ||
2020-06-07 | Spain | Canarias | 2369 | 151 | 1537 | 681 | 28.2916 | -16.6291 | 2020-06-08 03:33:22 | Canarias, Spain | ||
2020-06-08 | Spain | Canarias | 2370 | 151 | 1537 | 682 | 28.2916 | -16.6291 | 2020-06-09 03:33:03 | Canarias, Spain | ||
2020-06-09 | Spain | Canarias | 2372 | 151 | 1537 | 684 | 28.2916 | -16.6291 | 2020-06-10 04:07:00 | Canarias, Spain | ||
2020-06-10 | Spain | Canarias | 2372 | 151 | 1537 | 684 | 28.2916 | -16.6291 | 2020-06-11 03:33:41 | Canarias, Spain | ||
2020-06-11 | Spain | Canarias | 2371 | 151 | 1537 | 683 | 28.2916 | -16.6291 | 2020-06-12 05:09:52 | Canarias, Spain | ||
2020-06-12 | Spain | Canarias | 2374 | 151 | 1537 | 686 | 28.2916 | -16.6291 | 2020-06-13 03:33:14 | Canarias, Spain | ||
2020-06-13 | Spain | Canarias | 2377 | 151 | 1537 | 689 | 28.2916 | -16.6291 | 2020-06-14 03:33:15 | Canarias, Spain | ||
2020-06-14 | Spain | Canarias | 2378 | 151 | 1537 | 690 | 28.2916 | -16.6291 | 2020-06-15 03:33:14 | Canarias, Spain | ||
2020-06-15 | Spain | Canarias | 2378 | 151 | 1537 | 690 | 28.2916 | -16.6291 | 2020-06-16 04:33:09 | Canarias, Spain | ||
2020-06-16 | Spain | Canarias | 2382 | 151 | 1537 | 694 | 28.2916 | -16.6291 | 2020-06-17 04:33:21 | Canarias, Spain | ||
2020-06-17 | Spain | Canarias | 2382 | 151 | 1537 | 694 | 28.2916 | -16.6291 | 2020-06-18 04:33:18 | Canarias, Spain | ||
2020-06-18 | Spain | Canarias | 2398 | 151 | 1537 | 710 | 28.2916 | -16.6291 | 2020-06-19 04:33:17 | Canarias, Spain | ||
2020-06-19 | Spain | Canarias | 2402 | 162 | 1537 | 703 | 28.2916 | -16.6291 | 2020-06-20 04:33:19 | Canarias, Spain | ||
2020-06-20 | Spain | Canarias | 2402 | 162 | 1537 | 703 | 28.2916 | -16.6291 | 2020-06-21 04:33:19 | Canarias, Spain | ||
2020-06-21 | Spain | Canarias | 2414 | 162 | 1537 | 715 | 28.2916 | -16.6291 | 2020-06-22 04:33:20 | Canarias, Spain | ||
2020-06-22 | Spain | Canarias | 2414 | 162 | 1537 | 715 | 28.2916 | -16.6291 | 2020-06-23 04:33:22 | Canarias, Spain | ||
2020-06-23 | Spain | Canarias | 2415 | 162 | 1537 | 716 | 28.2916 | -16.6291 | 2020-06-24 04:33:28 | Canarias, Spain | ||
2020-06-24 | Spain | Canarias | 2421 | 162 | 1537 | 722 | 28.2916 | -16.6291 | 2020-06-25 05:26:54 | Canarias, Spain | ||
2020-06-25 | Spain | Canarias | 2423 | 162 | 1537 | 724 | 28.2916 | -16.6291 | 2020-06-26 04:33:43 | Canarias, Spain | ||
2020-06-26 | Spain | Canarias | 2426 | 162 | 1537 | 727 | 28.2916 | -16.6291 | 2020-06-27 04:33:35 | Canarias, Spain | ||
2020-06-27 | Spain | Canarias | 2427 | 162 | 1537 | 728 | 28.2916 | -16.6291 | 2020-06-28 04:34:04 | Canarias, Spain | ||
2020-06-28 | Spain | Canarias | 2427 | 162 | 1537 | 728 | 28.2916 | -16.6291 | 2020-06-29 04:33:44 | Canarias, Spain | ||
2020-06-29 | Spain | Canarias | 2427 | 162 | 1537 | 728 | 28.2916 | -16.6291 | 2020-06-30 04:33:48 | Canarias, Spain | ||
2020-06-30 | Spain | Canarias | 2427 | 162 | 1537 | 728 | 28.2916 | -16.6291 | 2020-07-01 04:33:52 | Canarias, Spain | ||
2020-07-01 | Spain | Canarias | 2432 | 162 | 1537 | 733 | 28.2916 | -16.6291 | 2020-07-02 04:33:46 | Canarias, Spain | ||
2020-07-02 | Spain | Canarias | 2431 | 162 | 1537 | 732 | 28.2916 | -16.6291 | 2020-07-03 04:33:54 | Canarias, Spain | ||
2020-07-03 | Spain | Canarias | 2436 | 162 | 1537 | 737 | 28.2916 | -16.6291 | 2020-07-04 04:33:51 | Canarias, Spain | ||
2020-07-04 | Spain | Canarias | 2436 | 162 | 1537 | 737 | 28.2916 | -16.6291 | 2020-07-05 04:33:46 | Canarias, Spain | ||
2020-07-05 | Spain | Canarias | 2436 | 162 | 1537 | 737 | 28.2916 | -16.6291 | 2020-07-06 04:33:57 | Canarias, Spain | ||
2020-07-06 | Spain | Canarias | 2441 | 162 | 1537 | 742 | 28.2916 | -16.6291 | 2020-07-07 04:34:00 | Canarias, Spain | ||
2020-07-07 | Spain | Canarias | 2443 | 162 | 1537 | 744 | 28.2916 | -16.6291 | 2020-07-08 05:33:48 | Canarias, Spain | ||
2020-07-08 | Spain | Canarias | 2444 | 162 | 1537 | 745 | 28.2916 | -16.6291 | 2020-07-09 04:34:23 | Canarias, Spain | ||
2020-07-09 | Spain | Canarias | 2451 | 162 | 1537 | 752 | 28.2916 | -16.6291 | 2020-07-10 04:34:24 | Canarias, Spain | ||
2020-07-10 | Spain | Canarias | 2450 | 162 | 1537 | 751 | 28.2916 | -16.6291 | 2020-07-11 04:34:26 | Canarias, Spain | ||
2020-07-11 | Spain | Canarias | 2450 | 162 | 1537 | 751 | 28.2916 | -16.6291 | 2020-07-12 04:34:30 | Canarias, Spain | ||
2020-07-12 | Spain | Canarias | 2450 | 162 | 1537 | 751 | 28.2916 | -16.6291 | 2020-07-13 04:43:04 | Canarias, Spain | ||
2020-07-13 | Spain | Canarias | 2457 | 162 | 1537 | 758 | 28.2916 | -16.6291 | 2020-07-14 04:34:46 | Canarias, Spain | ||
2020-07-14 | Spain | Canarias | 2461 | 162 | 1537 | 762 | 28.2916 | -16.6291 | 2020-07-15 04:34:39 | Canarias, Spain | ||
2020-07-15 | Spain | Canarias | 2467 | 162 | 1537 | 768 | 28.2916 | -16.6291 | 2020-07-16 04:44:59 | Canarias, Spain | ||
2020-07-16 | Spain | Canarias | 2481 | 162 | 1537 | 782 | 28.2916 | -16.6291 | 2020-07-17 04:34:50 | Canarias, Spain | ||
2020-07-17 | Spain | Canarias | 2483 | 162 | 1537 | 784 | 28.2916 | -16.6291 | 2020-07-18 04:34:45 | Canarias, Spain | ||
2020-07-18 | Spain | Canarias | 2483 | 162 | 1537 | 784 | 28.2916 | -16.6291 | 2020-07-19 04:34:58 | Canarias, Spain | ||
2020-07-19 | Spain | Canarias | 2483 | 162 | 1537 | 784 | 28.2916 | -16.6291 | 2020-07-20 05:34:40 | Canarias, Spain | ||
2020-07-20 | Spain | Canarias | 2551 | 162 | 1537 | 852 | 28.2916 | -16.6291 | 2020-07-21 04:38:46 | Canarias, Spain | ||
2020-07-21 | Spain | Canarias | 2553 | 162 | 1537 | 854 | 28.2916 | -16.6291 | 2020-07-22 04:34:42 | Canarias, Spain | ||
2020-07-22 | Spain | Canarias | 2564 | 162 | 1537 | 865 | 28.2916 | -16.6291 | 2020-07-23 05:15:04 | Canarias, Spain | ||
2020-07-23 | Spain | Canarias | 2570 | 162 | 1537 | 871 | 28.2916 | -16.6291 | 2020-07-24 05:30:40 | Canarias, Spain | ||
2020-07-24 | Spain | Canarias | 2578 | 162 | 1537 | 879 | 28.2916 | -16.6291 | 2020-07-25 04:47:39 | Canarias, Spain | ||
2020-07-25 | Spain | Canarias | 2578 | 162 | 1537 | 879 | 28.2916 | -16.6291 | 2020-07-26 04:35:00 | Canarias, Spain | ||
2020-07-26 | Spain | Canarias | 2578 | 162 | 1537 | 879 | 28.2916 | -16.6291 | 2020-07-27 04:35:02 | Canarias, Spain | ||
2020-07-27 | Spain | Canarias | 2608 | 162 | 1537 | 909 | 28.2916 | -16.6291 | 2020-07-28 04:58:43 | Canarias, Spain | ||
2020-07-28 | Spain | Canarias | 2610 | 162 | 1537 | 911 | 28.2916 | -16.6291 | 2020-07-29 04:35:11 | Canarias, Spain | ||
2020-07-29 | Spain | Canarias | 2617 | 162 | 1537 | 918 | 28.2916 | -16.6291 | 2020-07-30 04:35:05 | Canarias, Spain | ||
2020-07-30 | Spain | Canarias | 2623 | 162 | 1537 | 924 | 28.2916 | -16.6291 | 2020-07-31 04:35:18 | Canarias, Spain | ||
2020-07-31 | Spain | Canarias | 2631 | 162 | 1537 | 932 | 28.2916 | -16.6291 | 2020-08-01 04:36:27 | Canarias, Spain | ||
2020-08-01 | Spain | Canarias | 2631 | 162 | 1537 | 932 | 28.2916 | -16.6291 | 2020-08-02 04:34:47 | Canarias, Spain | ||
2020-08-02 | Spain | Canarias | 2631 | 162 | 1537 | 932 | 28.2916 | -16.6291 | 2020-08-03 04:34:35 | Canarias, Spain | ||
2020-08-03 | Spain | Canarias | 2687 | 162 | 1537 | 988 | 28.2916 | -16.6291 | 2020-08-04 04:41:59 | Canarias, Spain | ||
2020-08-04 | Spain | Canarias | 2695 | 162 | 1537 | 996 | 28.2916 | -16.6291 | 2020-08-05 04:34:43 | Canarias, Spain | ||
2020-08-05 | Spain | Canarias | 2711 | 162 | 1537 | 1012 | 28.2916 | -16.6291 | 2020-08-06 04:35:02 | Canarias, Spain | ||
2020-08-06 | Spain | Canarias | 2743 | 162 | 1537 | 1044 | 28.2916 | -16.6291 | 2020-08-07 04:35:11 | Canarias, Spain | ||
2020-08-07 | Spain | Canarias | 2798 | 162 | 1537 | 1099 | 28.2916 | -16.6291 | 2020-08-08 04:34:53 | Canarias, Spain | ||
2020-08-08 | Spain | Canarias | 2798 | 162 | 1537 | 1099 | 28.2916 | -16.6291 | 2020-08-09 04:34:54 | Canarias, Spain | ||
2020-08-09 | Spain | Canarias | 2798 | 162 | 1537 | 1099 | 28.2916 | -16.6291 | 2020-08-10 04:34:55 | Canarias, Spain | ||
2020-08-10 | Spain | Canarias | 2955 | 164 | 1537 | 1254 | 28.2916 | -16.6291 | 2020-08-11 04:35:08 | Canarias, Spain | ||
2020-08-11 | Spain | Canarias | 3041 | 164 | 1537 | 1340 | 28.2916 | -16.6291 | 2020-08-12 04:27:29 | Canarias, Spain | ||
2020-08-12 | Spain | Canarias | 3107 | 164 | 1537 | 1406 | 28.2916 | -16.6291 | 2020-08-13 04:29:15 | Canarias, Spain | ||
2020-08-13 | Spain | Canarias | 3208 | 164 | 1537 | 1507 | 28.2916 | -16.6291 | 2020-08-14 04:51:19 | Canarias, Spain | ||
2020-08-14 | Spain | Canarias | 3323 | 164 | 1537 | 1622 | 28.2916 | -16.6291 | 2020-08-15 04:27:31 | Canarias, Spain | ||
2020-08-15 | Spain | Canarias | 3323 | 164 | 1537 | 1622 | 28.2916 | -16.6291 | 2020-08-16 04:27:42 | Canarias, Spain | ||
2020-08-16 | Spain | Canarias | 3323 | 164 | 1537 | 1622 | 28.2916 | -16.6291 | 2020-08-17 04:27:20 | Canarias, Spain | ||
2020-08-17 | Spain | Canarias | 3690 | 166 | 1537 | 1987 | 28.2916 | -16.6291 | 2020-08-18 04:27:56 | Canarias, Spain | ||
2020-08-18 | Spain | Canarias | 3781 | 166 | 1537 | 2078 | 28.2916 | -16.6291 | 2020-08-19 04:27:00 | Canarias, Spain | ||
2020-08-19 | Spain | Canarias | 3925 | 166 | 1537 | 2222 | 28.2916 | -16.6291 | 2020-08-20 04:27:43 | Canarias, Spain | ||
2020-08-20 | Spain | Canarias | 4114 | 166 | 1537 | 2411 | 28.2916 | -16.6291 | 2020-08-21 04:27:41 | Canarias, Spain | ||
2020-08-21 | Spain | Canarias | 4288 | 167 | 1537 | 2584 | 28.2916 | -16.6291 | 2020-08-22 04:27:49 | Canarias, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;