johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Spain" and province_or_state = "Canarias" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026637 | 1026637 | 2020-10-17 | Spain | Canarias | 15572 | 251 | 1537 | 13784 | 28.2916 | -16.6291 | 2020-10-18 04:24:25 | Canarias, Spain | ||
2857132 | 2857132 | 2020-10-16 | Spain | Canarias | 15572 | 251 | 1537 | 13784 | 28.2916 | -16.6291 | 2020-10-17 04:24:12 | Canarias, Spain | ||
786662 | 786662 | 2020-10-15 | Spain | Canarias | 15425 | 250 | 1537 | 13638 | 28.2916 | -16.6291 | 2020-10-16 04:24:01 | Canarias, Spain | ||
79373 | 79373 | 2020-10-14 | Spain | Canarias | 15303 | 250 | 1537 | 13516 | 28.2916 | -16.6291 | 2020-10-15 04:24:28 | Canarias, Spain | ||
3782188 | 3782188 | 2020-10-13 | Spain | Canarias | 15236 | 248 | 1537 | 13451 | 28.2916 | -16.6291 | 2020-10-14 04:24:05 | Canarias, Spain | ||
2291728 | 2291728 | 2020-10-12 | Spain | Canarias | 15173 | 247 | 1537 | 13389 | 28.2916 | -16.6291 | 2020-10-13 04:24:02 | Canarias, Spain | ||
3786180 | 3786180 | 2020-10-11 | Spain | Canarias | 14775 | 241 | 1537 | 12997 | 28.2916 | -16.6291 | 2020-10-12 04:23:45 | Canarias, Spain | ||
2602318 | 2602318 | 2020-10-10 | Spain | Canarias | 14775 | 241 | 1537 | 12997 | 28.2916 | -16.6291 | 2020-10-11 04:23:46 | Canarias, Spain | ||
817851 | 817851 | 2020-10-09 | Spain | Canarias | 14775 | 241 | 1537 | 12997 | 28.2916 | -16.6291 | 2020-10-10 04:23:57 | Canarias, Spain | ||
2689966 | 2689966 | 2020-10-08 | Spain | Canarias | 14588 | 240 | 1537 | 12811 | 28.2916 | -16.6291 | 2020-10-09 04:23:59 | Canarias, Spain | ||
1042108 | 1042108 | 2020-10-07 | Spain | Canarias | 14463 | 239 | 1537 | 12687 | 28.2916 | -16.6291 | 2020-10-08 04:23:56 | Canarias, Spain | ||
3117769 | 3117769 | 2020-10-06 | Spain | Canarias | 14347 | 239 | 1537 | 12571 | 28.2916 | -16.6291 | 2020-10-07 04:23:40 | Canarias, Spain | ||
3802181 | 3802181 | 2020-10-05 | Spain | Canarias | 14271 | 237 | 1537 | 12497 | 28.2916 | -16.6291 | 2020-10-06 04:23:33 | Canarias, Spain | ||
1823071 | 1823071 | 2020-10-04 | Spain | Canarias | 13880 | 236 | 1537 | 12107 | 28.2916 | -16.6291 | 2020-10-05 04:23:33 | Canarias, Spain | ||
2514455 | 2514455 | 2020-10-03 | Spain | Canarias | 13880 | 236 | 1537 | 12107 | 28.2916 | -16.6291 | 2020-10-04 04:23:44 | Canarias, Spain | ||
3389673 | 3389673 | 2020-10-02 | Spain | Canarias | 13880 | 236 | 1537 | 12107 | 28.2916 | -16.6291 | 2020-10-03 04:23:40 | Canarias, Spain | ||
2379914 | 2379914 | 2020-10-01 | Spain | Canarias | 13676 | 232 | 1537 | 11907 | 28.2916 | -16.6291 | 2020-10-02 04:23:51 | Canarias, Spain | ||
1046100 | 1046100 | 2020-09-30 | Spain | Canarias | 13485 | 232 | 1537 | 11716 | 28.2916 | -16.6291 | 2020-10-01 04:23:42 | Canarias, Spain | ||
967181 | 967181 | 2020-09-29 | Spain | Canarias | 13243 | 232 | 1537 | 11474 | 28.2916 | -16.6291 | 2020-09-30 04:23:33 | Canarias, Spain | ||
1515678 | 1515678 | 2020-09-28 | Spain | Canarias | 13243 | 232 | 1537 | 11474 | 28.2916 | -16.6291 | 2020-09-29 04:23:42 | Canarias, Spain | ||
2582266 | 2582266 | 2020-09-27 | Spain | Canarias | 12762 | 220 | 1537 | 11005 | 28.2916 | -16.6291 | 2020-09-28 04:23:00 | Canarias, Spain | ||
2614318 | 2614318 | 2020-09-26 | Spain | Canarias | 12762 | 220 | 1537 | 11005 | 28.2916 | -16.6291 | 2020-09-27 04:23:00 | Canarias, Spain | ||
2813033 | 2813033 | 2020-09-25 | Spain | Canarias | 12762 | 220 | 1537 | 11005 | 28.2916 | -16.6291 | 2020-09-26 04:23:00 | Canarias, Spain | ||
2606310 | 2606310 | 2020-09-24 | Spain | Canarias | 12487 | 218 | 1537 | 10732 | 28.2916 | -16.6291 | 2020-09-25 04:23:00 | Canarias, Spain | ||
2654053 | 2654053 | 2020-09-23 | Spain | Canarias | 12350 | 218 | 1537 | 10595 | 28.2916 | -16.6291 | 2020-09-24 04:23:00 | Canarias, Spain | ||
3316502 | 3316502 | 2020-09-22 | Spain | Canarias | 12193 | 216 | 1537 | 10440 | 28.2916 | -16.6291 | 2020-09-23 04:23:00 | Canarias, Spain | ||
2837101 | 2837101 | 2020-09-21 | Spain | Canarias | 12027 | 214 | 1537 | 10276 | 28.2916 | -16.6291 | 2020-09-22 04:23:00 | Canarias, Spain | ||
3093705 | 3093705 | 2020-09-20 | Spain | Canarias | 11479 | 209 | 1537 | 9733 | 28.2916 | -16.6291 | 2020-09-21 04:23:00 | Canarias, Spain | ||
2455055 | 2455055 | 2020-09-19 | Spain | Canarias | 11479 | 209 | 1537 | 9733 | 28.2916 | -16.6291 | 2020-09-20 04:22:00 | Canarias, Spain | ||
2849124 | 2849124 | 2020-09-18 | Spain | Canarias | 11479 | 209 | 1537 | 9733 | 28.2916 | -16.6291 | 2020-09-19 04:22:00 | Canarias, Spain | ||
1121873 | 1121873 | 2020-09-17 | Spain | Canarias | 11310 | 207 | 1537 | 9566 | 28.2916 | -16.6291 | 2020-09-18 05:05:00 | Canarias, Spain | ||
666562 | 666562 | 2020-09-16 | Spain | Canarias | 11161 | 205 | 1537 | 9419 | 28.2916 | -16.6291 | 2020-09-17 04:22:00 | Canarias, Spain | ||
2729287 | 2729287 | 2020-09-15 | Spain | Canarias | 10969 | 200 | 1537 | 9232 | 28.2916 | -16.6291 | 2020-09-16 04:22:53 | Canarias, Spain | ||
344559 | 344559 | 2020-09-14 | Spain | Canarias | 10859 | 194 | 1537 | 9128 | 28.2916 | -16.6291 | 2020-09-15 03:22:50 | Canarias, Spain | ||
2868998 | 2868998 | 2020-09-13 | Spain | Canarias | 10133 | 189 | 1537 | 8407 | 28.2916 | -16.6291 | 2020-09-14 04:26:00 | Canarias, Spain | ||
547037 | 547037 | 2020-09-12 | Spain | Canarias | 10133 | 189 | 1537 | 8407 | 28.2916 | -16.6291 | 2020-09-13 04:30:52 | Canarias, Spain | ||
1444866 | 1444866 | 2020-09-11 | Spain | Canarias | 10133 | 189 | 1537 | 8407 | 28.2916 | -16.6291 | 2020-09-12 04:25:05 | Canarias, Spain | ||
1173467 | 1173467 | 2020-09-10 | Spain | Canarias | 9861 | 189 | 1537 | 8135 | 28.2916 | -16.6291 | 2020-09-11 04:46:23 | Canarias, Spain | ||
2171832 | 2171832 | 2020-09-09 | Spain | Canarias | 9602 | 189 | 1537 | 7876 | 28.2916 | -16.6291 | 2020-09-10 04:29:01 | Canarias, Spain | ||
1244041 | 1244041 | 2020-09-08 | Spain | Canarias | 9380 | 187 | 1537 | 7656 | 28.2916 | -16.6291 | 2020-09-09 04:28:48 | Canarias, Spain | ||
427620 | 427620 | 2020-09-07 | Spain | Canarias | 9184 | 185 | 1537 | 7462 | 28.2916 | -16.6291 | 2020-09-08 04:28:25 | Canarias, Spain | ||
3161905 | 3161905 | 2020-09-06 | Spain | Canarias | 8302 | 179 | 1537 | 6586 | 28.2916 | -16.6291 | 2020-09-07 04:28:30 | Canarias, Spain | ||
813860 | 813860 | 2020-09-05 | Spain | Canarias | 8302 | 179 | 1537 | 6586 | 28.2916 | -16.6291 | 2020-09-06 04:28:33 | Canarias, Spain | ||
2662060 | 2662060 | 2020-09-04 | Spain | Canarias | 8302 | 179 | 1537 | 6586 | 28.2916 | -16.6291 | 2020-09-05 04:28:19 | Canarias, Spain | ||
1354600 | 1354600 | 2020-09-03 | Spain | Canarias | 7927 | 178 | 1537 | 6212 | 28.2916 | -16.6291 | 2020-09-04 04:28:26 | Canarias, Spain | ||
1105837 | 1105837 | 2020-09-02 | Spain | Canarias | 7566 | 175 | 1537 | 5854 | 28.2916 | -16.6291 | 2020-09-03 04:28:22 | Canarias, Spain | ||
2060166 | 2060166 | 2020-09-01 | Spain | Canarias | 7302 | 174 | 1537 | 5591 | 28.2916 | -16.6291 | 2020-09-02 04:28:25 | Canarias, Spain | ||
194351 | 194351 | 2020-08-31 | Spain | Canarias | 7068 | 174 | 1537 | 5357 | 28.2916 | -16.6291 | 2020-09-01 04:28:31 | Canarias, Spain | ||
3932310 | 3932310 | 2020-08-30 | Spain | Canarias | 6126 | 172 | 1537 | 4417 | 28.2916 | -16.6291 | 2020-08-31 04:28:27 | Canarias, Spain | ||
609972 | 609972 | 2020-08-29 | Spain | Canarias | 6126 | 172 | 1537 | 4417 | 28.2916 | -16.6291 | 2020-08-30 04:28:22 | Canarias, Spain | ||
1523467 | 1523467 | 2020-08-28 | Spain | Canarias | 6126 | 172 | 1537 | 4417 | 28.2916 | -16.6291 | 2020-08-29 04:28:19 | Canarias, Spain | ||
2510468 | 2510468 | 2020-08-27 | Spain | Canarias | 5851 | 171 | 1537 | 4143 | 28.2916 | -16.6291 | 2020-08-28 04:28:11 | Canarias, Spain | ||
1996928 | 1996928 | 2020-08-26 | Spain | Canarias | 5516 | 169 | 1537 | 3810 | 28.2916 | -16.6291 | 2020-08-27 04:28:15 | Canarias, Spain | ||
3562852 | 3562852 | 2020-08-25 | Spain | Canarias | 5225 | 168 | 1537 | 3520 | 28.2916 | -16.6291 | 2020-08-26 04:28:11 | Canarias, Spain | ||
2991556 | 2991556 | 2020-08-24 | Spain | Canarias | 4990 | 167 | 1537 | 3286 | 28.2916 | -16.6291 | 2020-08-25 04:28:02 | Canarias, Spain | ||
2215951 | 2215951 | 2020-08-23 | Spain | Canarias | 4288 | 167 | 1537 | 2584 | 28.2916 | -16.6291 | 2020-08-24 04:27:56 | Canarias, Spain | ||
2299733 | 2299733 | 2020-08-22 | Spain | Canarias | 4288 | 167 | 1537 | 2584 | 28.2916 | -16.6291 | 2020-08-23 04:27:48 | Canarias, Spain | ||
1479840 | 1479840 | 2020-08-21 | Spain | Canarias | 4288 | 167 | 1537 | 2584 | 28.2916 | -16.6291 | 2020-08-22 04:27:49 | Canarias, Spain | ||
3484589 | 3484589 | 2020-08-20 | Spain | Canarias | 4114 | 166 | 1537 | 2411 | 28.2916 | -16.6291 | 2020-08-21 04:27:41 | Canarias, Spain | ||
206538 | 206538 | 2020-08-19 | Spain | Canarias | 3925 | 166 | 1537 | 2222 | 28.2916 | -16.6291 | 2020-08-20 04:27:43 | Canarias, Spain | ||
3178292 | 3178292 | 2020-08-18 | Spain | Canarias | 3781 | 166 | 1537 | 2078 | 28.2916 | -16.6291 | 2020-08-19 04:27:00 | Canarias, Spain | ||
837896 | 837896 | 2020-08-17 | Spain | Canarias | 3690 | 166 | 1537 | 1987 | 28.2916 | -16.6291 | 2020-08-18 04:27:56 | Canarias, Spain | ||
1556254 | 1556254 | 2020-08-16 | Spain | Canarias | 3323 | 164 | 1537 | 1622 | 28.2916 | -16.6291 | 2020-08-17 04:27:20 | Canarias, Spain | ||
146256 | 146256 | 2020-08-15 | Spain | Canarias | 3323 | 164 | 1537 | 1622 | 28.2916 | -16.6291 | 2020-08-16 04:27:42 | Canarias, Spain | ||
1612531 | 1612531 | 2020-08-14 | Spain | Canarias | 3323 | 164 | 1537 | 1622 | 28.2916 | -16.6291 | 2020-08-15 04:27:31 | Canarias, Spain | ||
583115 | 583115 | 2020-08-13 | Spain | Canarias | 3208 | 164 | 1537 | 1507 | 28.2916 | -16.6291 | 2020-08-14 04:51:19 | Canarias, Spain | ||
3531734 | 3531734 | 2020-08-12 | Spain | Canarias | 3107 | 164 | 1537 | 1406 | 28.2916 | -16.6291 | 2020-08-13 04:29:15 | Canarias, Spain | ||
662583 | 662583 | 2020-08-11 | Spain | Canarias | 3041 | 164 | 1537 | 1340 | 28.2916 | -16.6291 | 2020-08-12 04:27:29 | Canarias, Spain | ||
1920233 | 1920233 | 2020-08-10 | Spain | Canarias | 2955 | 164 | 1537 | 1254 | 28.2916 | -16.6291 | 2020-08-11 04:35:08 | Canarias, Spain | ||
3923042 | 3923042 | 2020-08-09 | Spain | Canarias | 2798 | 162 | 1537 | 1099 | 28.2916 | -16.6291 | 2020-08-10 04:34:55 | Canarias, Spain | ||
371210 | 371210 | 2020-08-08 | Spain | Canarias | 2798 | 162 | 1537 | 1099 | 28.2916 | -16.6291 | 2020-08-09 04:34:54 | Canarias, Spain | ||
458394 | 458394 | 2020-08-07 | Spain | Canarias | 2798 | 162 | 1537 | 1099 | 28.2916 | -16.6291 | 2020-08-08 04:34:53 | Canarias, Spain | ||
3612079 | 3612079 | 2020-08-06 | Spain | Canarias | 2743 | 162 | 1537 | 1044 | 28.2916 | -16.6291 | 2020-08-07 04:35:11 | Canarias, Spain | ||
3792909 | 3792909 | 2020-08-05 | Spain | Canarias | 2711 | 162 | 1537 | 1012 | 28.2916 | -16.6291 | 2020-08-06 04:35:02 | Canarias, Spain | ||
98145 | 98145 | 2020-08-04 | Spain | Canarias | 2695 | 162 | 1537 | 996 | 28.2916 | -16.6291 | 2020-08-05 04:34:43 | Canarias, Spain | ||
2740028 | 2740028 | 2020-08-03 | Spain | Canarias | 2687 | 162 | 1537 | 988 | 28.2916 | -16.6291 | 2020-08-04 04:41:59 | Canarias, Spain | ||
2807780 | 2807780 | 2020-08-02 | Spain | Canarias | 2631 | 162 | 1537 | 932 | 28.2916 | -16.6291 | 2020-08-03 04:34:35 | Canarias, Spain | ||
753348 | 753348 | 2020-08-01 | Spain | Canarias | 2631 | 162 | 1537 | 932 | 28.2916 | -16.6291 | 2020-08-02 04:34:47 | Canarias, Spain | ||
3264513 | 3264513 | 2020-07-31 | Spain | Canarias | 2631 | 162 | 1537 | 932 | 28.2916 | -16.6291 | 2020-08-01 04:36:27 | Canarias, Spain | ||
1928220 | 1928220 | 2020-07-30 | Spain | Canarias | 2623 | 162 | 1537 | 924 | 28.2916 | -16.6291 | 2020-07-31 04:35:18 | Canarias, Spain | ||
2958388 | 2958388 | 2020-07-29 | Spain | Canarias | 2617 | 162 | 1537 | 918 | 28.2916 | -16.6291 | 2020-07-30 04:35:05 | Canarias, Spain | ||
3185004 | 3185004 | 2020-07-28 | Spain | Canarias | 2610 | 162 | 1537 | 911 | 28.2916 | -16.6291 | 2020-07-29 04:35:11 | Canarias, Spain | ||
177056 | 177056 | 2020-07-27 | Spain | Canarias | 2608 | 162 | 1537 | 909 | 28.2916 | -16.6291 | 2020-07-28 04:58:43 | Canarias, Spain | ||
442369 | 442369 | 2020-07-26 | Spain | Canarias | 2578 | 162 | 1537 | 879 | 28.2916 | -16.6291 | 2020-07-27 04:35:02 | Canarias, Spain | ||
1502613 | 1502613 | 2020-07-25 | Spain | Canarias | 2578 | 162 | 1537 | 879 | 28.2916 | -16.6291 | 2020-07-26 04:35:00 | Canarias, Spain | ||
2563583 | 2563583 | 2020-07-24 | Spain | Canarias | 2578 | 162 | 1537 | 879 | 28.2916 | -16.6291 | 2020-07-25 04:47:39 | Canarias, Spain | ||
61811 | 61811 | 2020-07-23 | Spain | Canarias | 2570 | 162 | 1537 | 871 | 28.2916 | -16.6291 | 2020-07-24 05:30:40 | Canarias, Spain | ||
844603 | 844603 | 2020-07-22 | Spain | Canarias | 2564 | 162 | 1537 | 865 | 28.2916 | -16.6291 | 2020-07-23 05:15:04 | Canarias, Spain | ||
1707342 | 1707342 | 2020-07-21 | Spain | Canarias | 2553 | 162 | 1537 | 854 | 28.2916 | -16.6291 | 2020-07-22 04:34:42 | Canarias, Spain | ||
326833 | 326833 | 2020-07-20 | Spain | Canarias | 2551 | 162 | 1537 | 852 | 28.2916 | -16.6291 | 2020-07-21 04:38:46 | Canarias, Spain | ||
121738 | 121738 | 2020-07-19 | Spain | Canarias | 2483 | 162 | 1537 | 784 | 28.2916 | -16.6291 | 2020-07-20 05:34:40 | Canarias, Spain | ||
3205127 | 3205127 | 2020-07-18 | Spain | Canarias | 2483 | 162 | 1537 | 784 | 28.2916 | -16.6291 | 2020-07-19 04:34:58 | Canarias, Spain | ||
2708429 | 2708429 | 2020-07-17 | Spain | Canarias | 2483 | 162 | 1537 | 784 | 28.2916 | -16.6291 | 2020-07-18 04:34:45 | Canarias, Spain | ||
367248 | 367248 | 2020-07-16 | Spain | Canarias | 2481 | 162 | 1537 | 782 | 28.2916 | -16.6291 | 2020-07-17 04:34:50 | Canarias, Spain | ||
2747916 | 2747916 | 2020-07-15 | Spain | Canarias | 2467 | 162 | 1537 | 768 | 28.2916 | -16.6291 | 2020-07-16 04:44:59 | Canarias, Spain | ||
2158560 | 2158560 | 2020-07-14 | Spain | Canarias | 2461 | 162 | 1537 | 762 | 28.2916 | -16.6291 | 2020-07-15 04:34:39 | Canarias, Spain | ||
3491201 | 3491201 | 2020-07-13 | Spain | Canarias | 2457 | 162 | 1537 | 758 | 28.2916 | -16.6291 | 2020-07-14 04:34:46 | Canarias, Spain | ||
3737463 | 3737463 | 2020-07-12 | Spain | Canarias | 2450 | 162 | 1537 | 751 | 28.2916 | -16.6291 | 2020-07-13 04:43:04 | Canarias, Spain | ||
3435858 | 3435858 | 2020-07-11 | Spain | Canarias | 2450 | 162 | 1537 | 751 | 28.2916 | -16.6291 | 2020-07-12 04:34:30 | Canarias, Spain | ||
3237356 | 3237356 | 2020-07-10 | Spain | Canarias | 2450 | 162 | 1537 | 751 | 28.2916 | -16.6291 | 2020-07-11 04:34:26 | Canarias, Spain |
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]);