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 = "Cantabria" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026638 | 1026638 | 2020-10-17 | Spain | Cantabria | 7621 | 242 | 2287 | 5092 | 43.1828 | -3.9878 | 2020-10-18 04:24:25 | Cantabria, Spain | ||
2857133 | 2857133 | 2020-10-16 | Spain | Cantabria | 7621 | 242 | 2287 | 5092 | 43.1828 | -3.9878 | 2020-10-17 04:24:12 | Cantabria, Spain | ||
786663 | 786663 | 2020-10-15 | Spain | Cantabria | 7536 | 240 | 2287 | 5009 | 43.1828 | -3.9878 | 2020-10-16 04:24:01 | Cantabria, Spain | ||
79374 | 79374 | 2020-10-14 | Spain | Cantabria | 7478 | 240 | 2287 | 4951 | 43.1828 | -3.9878 | 2020-10-15 04:24:28 | Cantabria, Spain | ||
3782189 | 3782189 | 2020-10-13 | Spain | Cantabria | 7407 | 240 | 2287 | 4880 | 43.1828 | -3.9878 | 2020-10-14 04:24:05 | Cantabria, Spain | ||
2291729 | 2291729 | 2020-10-12 | Spain | Cantabria | 7362 | 237 | 2287 | 4838 | 43.1828 | -3.9878 | 2020-10-13 04:24:02 | Cantabria, Spain | ||
3786181 | 3786181 | 2020-10-11 | Spain | Cantabria | 7192 | 237 | 2287 | 4668 | 43.1828 | -3.9878 | 2020-10-12 04:23:45 | Cantabria, Spain | ||
2602319 | 2602319 | 2020-10-10 | Spain | Cantabria | 7192 | 237 | 2287 | 4668 | 43.1828 | -3.9878 | 2020-10-11 04:23:46 | Cantabria, Spain | ||
817852 | 817852 | 2020-10-09 | Spain | Cantabria | 7192 | 237 | 2287 | 4668 | 43.1828 | -3.9878 | 2020-10-10 04:23:57 | Cantabria, Spain | ||
2689967 | 2689967 | 2020-10-08 | Spain | Cantabria | 7161 | 237 | 2287 | 4637 | 43.1828 | -3.9878 | 2020-10-09 04:23:59 | Cantabria, Spain | ||
1042109 | 1042109 | 2020-10-07 | Spain | Cantabria | 7124 | 237 | 2287 | 4600 | 43.1828 | -3.9878 | 2020-10-08 04:23:56 | Cantabria, Spain | ||
3117770 | 3117770 | 2020-10-06 | Spain | Cantabria | 7082 | 237 | 2287 | 4558 | 43.1828 | -3.9878 | 2020-10-07 04:23:40 | Cantabria, Spain | ||
3802182 | 3802182 | 2020-10-05 | Spain | Cantabria | 7045 | 237 | 2287 | 4521 | 43.1828 | -3.9878 | 2020-10-06 04:23:33 | Cantabria, Spain | ||
1823072 | 1823072 | 2020-10-04 | Spain | Cantabria | 6888 | 235 | 2287 | 4366 | 43.1828 | -3.9878 | 2020-10-05 04:23:33 | Cantabria, Spain | ||
2514456 | 2514456 | 2020-10-03 | Spain | Cantabria | 6888 | 235 | 2287 | 4366 | 43.1828 | -3.9878 | 2020-10-04 04:23:44 | Cantabria, Spain | ||
3389674 | 3389674 | 2020-10-02 | Spain | Cantabria | 6888 | 235 | 2287 | 4366 | 43.1828 | -3.9878 | 2020-10-03 04:23:40 | Cantabria, Spain | ||
2379915 | 2379915 | 2020-10-01 | Spain | Cantabria | 6850 | 235 | 2287 | 4328 | 43.1828 | -3.9878 | 2020-10-02 04:23:51 | Cantabria, Spain | ||
1046101 | 1046101 | 2020-09-30 | Spain | Cantabria | 6806 | 235 | 2287 | 4284 | 43.1828 | -3.9878 | 2020-10-01 04:23:42 | Cantabria, Spain | ||
967182 | 967182 | 2020-09-29 | Spain | Cantabria | 6700 | 234 | 2287 | 4179 | 43.1828 | -3.9878 | 2020-09-30 04:23:33 | Cantabria, Spain | ||
1515679 | 1515679 | 2020-09-28 | Spain | Cantabria | 6700 | 234 | 2287 | 4179 | 43.1828 | -3.9878 | 2020-09-29 04:23:42 | Cantabria, Spain | ||
2582267 | 2582267 | 2020-09-27 | Spain | Cantabria | 6568 | 233 | 2287 | 4048 | 43.1828 | -3.9878 | 2020-09-28 04:23:00 | Cantabria, Spain | ||
2614319 | 2614319 | 2020-09-26 | Spain | Cantabria | 6568 | 233 | 2287 | 4048 | 43.1828 | -3.9878 | 2020-09-27 04:23:00 | Cantabria, Spain | ||
2813034 | 2813034 | 2020-09-25 | Spain | Cantabria | 6568 | 233 | 2287 | 4048 | 43.1828 | -3.9878 | 2020-09-26 04:23:00 | Cantabria, Spain | ||
2606311 | 2606311 | 2020-09-24 | Spain | Cantabria | 6499 | 232 | 2287 | 3980 | 43.1828 | -3.9878 | 2020-09-25 04:23:00 | Cantabria, Spain | ||
2654054 | 2654054 | 2020-09-23 | Spain | Cantabria | 6433 | 232 | 2287 | 3914 | 43.1828 | -3.9878 | 2020-09-24 04:23:00 | Cantabria, Spain | ||
3316503 | 3316503 | 2020-09-22 | Spain | Cantabria | 6366 | 232 | 2287 | 3847 | 43.1828 | -3.9878 | 2020-09-23 04:23:00 | Cantabria, Spain | ||
2837102 | 2837102 | 2020-09-21 | Spain | Cantabria | 6315 | 232 | 2287 | 3796 | 43.1828 | -3.9878 | 2020-09-22 04:23:00 | Cantabria, Spain | ||
3093706 | 3093706 | 2020-09-20 | Spain | Cantabria | 6058 | 231 | 2287 | 3540 | 43.1828 | -3.9878 | 2020-09-21 04:23:00 | Cantabria, Spain | ||
2455056 | 2455056 | 2020-09-19 | Spain | Cantabria | 6058 | 231 | 2287 | 3540 | 43.1828 | -3.9878 | 2020-09-20 04:22:00 | Cantabria, Spain | ||
2849125 | 2849125 | 2020-09-18 | Spain | Cantabria | 6058 | 231 | 2287 | 3540 | 43.1828 | -3.9878 | 2020-09-19 04:22:00 | Cantabria, Spain | ||
1121874 | 1121874 | 2020-09-17 | Spain | Cantabria | 6005 | 228 | 2287 | 3490 | 43.1828 | -3.9878 | 2020-09-18 05:05:00 | Cantabria, Spain | ||
666563 | 666563 | 2020-09-16 | Spain | Cantabria | 5883 | 228 | 2287 | 3368 | 43.1828 | -3.9878 | 2020-09-17 04:22:00 | Cantabria, Spain | ||
2729288 | 2729288 | 2020-09-15 | Spain | Cantabria | 5798 | 227 | 2287 | 3284 | 43.1828 | -3.9878 | 2020-09-16 04:22:53 | Cantabria, Spain | ||
344560 | 344560 | 2020-09-14 | Spain | Cantabria | 5720 | 227 | 2287 | 3206 | 43.1828 | -3.9878 | 2020-09-15 03:22:50 | Cantabria, Spain | ||
2868999 | 2868999 | 2020-09-13 | Spain | Cantabria | 5372 | 227 | 2287 | 2858 | 43.1828 | -3.9878 | 2020-09-14 04:26:00 | Cantabria, Spain | ||
547038 | 547038 | 2020-09-12 | Spain | Cantabria | 5372 | 227 | 2287 | 2858 | 43.1828 | -3.9878 | 2020-09-13 04:30:52 | Cantabria, Spain | ||
1444867 | 1444867 | 2020-09-11 | Spain | Cantabria | 5372 | 227 | 2287 | 2858 | 43.1828 | -3.9878 | 2020-09-12 04:25:05 | Cantabria, Spain | ||
1173468 | 1173468 | 2020-09-10 | Spain | Cantabria | 5221 | 227 | 2287 | 2707 | 43.1828 | -3.9878 | 2020-09-11 04:46:23 | Cantabria, Spain | ||
2171833 | 2171833 | 2020-09-09 | Spain | Cantabria | 5049 | 227 | 2287 | 2535 | 43.1828 | -3.9878 | 2020-09-10 04:29:01 | Cantabria, Spain | ||
1244042 | 1244042 | 2020-09-08 | Spain | Cantabria | 4936 | 227 | 2287 | 2422 | 43.1828 | -3.9878 | 2020-09-09 04:28:48 | Cantabria, Spain | ||
427621 | 427621 | 2020-09-07 | Spain | Cantabria | 4856 | 226 | 2287 | 2343 | 43.1828 | -3.9878 | 2020-09-08 04:28:25 | Cantabria, Spain | ||
3161906 | 3161906 | 2020-09-06 | Spain | Cantabria | 4561 | 225 | 2287 | 2049 | 43.1828 | -3.9878 | 2020-09-07 04:28:30 | Cantabria, Spain | ||
813861 | 813861 | 2020-09-05 | Spain | Cantabria | 4561 | 225 | 2287 | 2049 | 43.1828 | -3.9878 | 2020-09-06 04:28:33 | Cantabria, Spain | ||
2662061 | 2662061 | 2020-09-04 | Spain | Cantabria | 4561 | 225 | 2287 | 2049 | 43.1828 | -3.9878 | 2020-09-05 04:28:19 | Cantabria, Spain | ||
1354601 | 1354601 | 2020-09-03 | Spain | Cantabria | 4415 | 224 | 2287 | 1904 | 43.1828 | -3.9878 | 2020-09-04 04:28:26 | Cantabria, Spain | ||
1105838 | 1105838 | 2020-09-02 | Spain | Cantabria | 4313 | 224 | 2287 | 1802 | 43.1828 | -3.9878 | 2020-09-03 04:28:22 | Cantabria, Spain | ||
2060167 | 2060167 | 2020-09-01 | Spain | Cantabria | 4199 | 221 | 2287 | 1691 | 43.1828 | -3.9878 | 2020-09-02 04:28:25 | Cantabria, Spain | ||
194352 | 194352 | 2020-08-31 | Spain | Cantabria | 4137 | 221 | 2287 | 1629 | 43.1828 | -3.9878 | 2020-09-01 04:28:31 | Cantabria, Spain | ||
3932311 | 3932311 | 2020-08-30 | Spain | Cantabria | 3832 | 221 | 2287 | 1324 | 43.1828 | -3.9878 | 2020-08-31 04:28:27 | Cantabria, Spain | ||
609973 | 609973 | 2020-08-29 | Spain | Cantabria | 3832 | 221 | 2287 | 1324 | 43.1828 | -3.9878 | 2020-08-30 04:28:22 | Cantabria, Spain | ||
1523468 | 1523468 | 2020-08-28 | Spain | Cantabria | 3832 | 221 | 2287 | 1324 | 43.1828 | -3.9878 | 2020-08-29 04:28:19 | Cantabria, Spain | ||
2510469 | 2510469 | 2020-08-27 | Spain | Cantabria | 3740 | 221 | 2287 | 1232 | 43.1828 | -3.9878 | 2020-08-28 04:28:11 | Cantabria, Spain | ||
1996929 | 1996929 | 2020-08-26 | Spain | Cantabria | 3651 | 221 | 2287 | 1143 | 43.1828 | -3.9878 | 2020-08-27 04:28:15 | Cantabria, Spain | ||
3562853 | 3562853 | 2020-08-25 | Spain | Cantabria | 3569 | 221 | 2287 | 1061 | 43.1828 | -3.9878 | 2020-08-26 04:28:11 | Cantabria, Spain | ||
2991557 | 2991557 | 2020-08-24 | Spain | Cantabria | 3518 | 221 | 2287 | 1010 | 43.1828 | -3.9878 | 2020-08-25 04:28:02 | Cantabria, Spain | ||
2215952 | 2215952 | 2020-08-23 | Spain | Cantabria | 3240 | 221 | 2287 | 732 | 43.1828 | -3.9878 | 2020-08-24 04:27:56 | Cantabria, Spain | ||
2299734 | 2299734 | 2020-08-22 | Spain | Cantabria | 3240 | 221 | 2287 | 732 | 43.1828 | -3.9878 | 2020-08-23 04:27:48 | Cantabria, Spain | ||
1479841 | 1479841 | 2020-08-21 | Spain | Cantabria | 3240 | 221 | 2287 | 732 | 43.1828 | -3.9878 | 2020-08-22 04:27:49 | Cantabria, Spain | ||
3484590 | 3484590 | 2020-08-20 | Spain | Cantabria | 3240 | 221 | 2287 | 732 | 43.1828 | -3.9878 | 2020-08-21 04:27:41 | Cantabria, Spain | ||
206539 | 206539 | 2020-08-19 | Spain | Cantabria | 3191 | 220 | 2287 | 684 | 43.1828 | -3.9878 | 2020-08-20 04:27:43 | Cantabria, Spain | ||
3178293 | 3178293 | 2020-08-18 | Spain | Cantabria | 3138 | 220 | 2287 | 631 | 43.1828 | -3.9878 | 2020-08-19 04:27:00 | Cantabria, Spain | ||
837897 | 837897 | 2020-08-17 | Spain | Cantabria | 3119 | 220 | 2287 | 612 | 43.1828 | -3.9878 | 2020-08-18 04:27:56 | Cantabria, Spain | ||
1556255 | 1556255 | 2020-08-16 | Spain | Cantabria | 2930 | 220 | 2287 | 423 | 43.1828 | -3.9878 | 2020-08-17 04:27:20 | Cantabria, Spain | ||
146257 | 146257 | 2020-08-15 | Spain | Cantabria | 2930 | 220 | 2287 | 423 | 43.1828 | -3.9878 | 2020-08-16 04:27:42 | Cantabria, Spain | ||
1612532 | 1612532 | 2020-08-14 | Spain | Cantabria | 2930 | 220 | 2287 | 423 | 43.1828 | -3.9878 | 2020-08-15 04:27:31 | Cantabria, Spain | ||
583116 | 583116 | 2020-08-13 | Spain | Cantabria | 2869 | 220 | 2287 | 362 | 43.1828 | -3.9878 | 2020-08-14 04:51:19 | Cantabria, Spain | ||
3531735 | 3531735 | 2020-08-12 | Spain | Cantabria | 2824 | 220 | 2287 | 317 | 43.1828 | -3.9878 | 2020-08-13 04:29:15 | Cantabria, Spain | ||
662584 | 662584 | 2020-08-11 | Spain | Cantabria | 2759 | 219 | 2287 | 253 | 43.1828 | -3.9878 | 2020-08-12 04:27:29 | Cantabria, Spain | ||
1920234 | 1920234 | 2020-08-10 | Spain | Cantabria | 2746 | 217 | 2287 | 242 | 43.1828 | -3.9878 | 2020-08-11 04:35:08 | Cantabria, Spain | ||
3923043 | 3923043 | 2020-08-09 | Spain | Cantabria | 2653 | 217 | 2287 | 149 | 43.1828 | -3.9878 | 2020-08-10 04:34:55 | Cantabria, Spain | ||
371211 | 371211 | 2020-08-08 | Spain | Cantabria | 2653 | 217 | 2287 | 149 | 43.1828 | -3.9878 | 2020-08-09 04:34:54 | Cantabria, Spain | ||
458395 | 458395 | 2020-08-07 | Spain | Cantabria | 2653 | 217 | 2287 | 149 | 43.1828 | -3.9878 | 2020-08-08 04:34:53 | Cantabria, Spain | ||
3612080 | 3612080 | 2020-08-06 | Spain | Cantabria | 2623 | 217 | 2287 | 119 | 43.1828 | -3.9878 | 2020-08-07 04:35:11 | Cantabria, Spain | ||
3792910 | 3792910 | 2020-08-05 | Spain | Cantabria | 2604 | 217 | 2287 | 100 | 43.1828 | -3.9878 | 2020-08-06 04:35:02 | Cantabria, Spain | ||
98146 | 98146 | 2020-08-04 | Spain | Cantabria | 2567 | 217 | 2287 | 63 | 43.1828 | -3.9878 | 2020-08-05 04:34:43 | Cantabria, Spain | ||
2740029 | 2740029 | 2020-08-03 | Spain | Cantabria | 2532 | 217 | 2287 | 28 | 43.1828 | -3.9878 | 2020-08-04 04:41:59 | Cantabria, Spain | ||
2807781 | 2807781 | 2020-08-02 | Spain | Cantabria | 2469 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-08-03 04:34:35 | Cantabria, Spain | ||
753349 | 753349 | 2020-08-01 | Spain | Cantabria | 2469 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-08-02 04:34:47 | Cantabria, Spain | ||
3264514 | 3264514 | 2020-07-31 | Spain | Cantabria | 2469 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-08-01 04:36:27 | Cantabria, Spain | ||
1928221 | 1928221 | 2020-07-30 | Spain | Cantabria | 2455 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-31 04:35:18 | Cantabria, Spain | ||
2958389 | 2958389 | 2020-07-29 | Spain | Cantabria | 2448 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-30 04:35:05 | Cantabria, Spain | ||
3185005 | 3185005 | 2020-07-28 | Spain | Cantabria | 2447 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-29 04:35:11 | Cantabria, Spain | ||
177057 | 177057 | 2020-07-27 | Spain | Cantabria | 2436 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-28 04:58:43 | Cantabria, Spain | ||
442370 | 442370 | 2020-07-26 | Spain | Cantabria | 2419 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-27 04:35:02 | Cantabria, Spain | ||
1502614 | 1502614 | 2020-07-25 | Spain | Cantabria | 2419 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-26 04:35:00 | Cantabria, Spain | ||
2563584 | 2563584 | 2020-07-24 | Spain | Cantabria | 2419 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-25 04:47:39 | Cantabria, Spain | ||
61812 | 61812 | 2020-07-23 | Spain | Cantabria | 2410 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-24 05:30:40 | Cantabria, Spain | ||
844604 | 844604 | 2020-07-22 | Spain | Cantabria | 2406 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-23 05:15:04 | Cantabria, Spain | ||
1707343 | 1707343 | 2020-07-21 | Spain | Cantabria | 2405 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-22 04:34:42 | Cantabria, Spain | ||
326834 | 326834 | 2020-07-20 | Spain | Cantabria | 2403 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-21 04:38:46 | Cantabria, Spain | ||
121739 | 121739 | 2020-07-19 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-20 05:34:40 | Cantabria, Spain | ||
3205128 | 3205128 | 2020-07-18 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-19 04:34:58 | Cantabria, Spain | ||
2708430 | 2708430 | 2020-07-17 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-18 04:34:45 | Cantabria, Spain | ||
367249 | 367249 | 2020-07-16 | Spain | Cantabria | 2380 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-17 04:34:50 | Cantabria, Spain | ||
2747917 | 2747917 | 2020-07-15 | Spain | Cantabria | 2378 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-16 04:44:59 | Cantabria, Spain | ||
2158561 | 2158561 | 2020-07-14 | Spain | Cantabria | 2375 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-15 04:34:39 | Cantabria, Spain | ||
3491202 | 3491202 | 2020-07-13 | Spain | Cantabria | 2374 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-14 04:34:46 | Cantabria, Spain | ||
3737464 | 3737464 | 2020-07-12 | Spain | Cantabria | 2369 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-13 04:43:04 | Cantabria, Spain | ||
3435859 | 3435859 | 2020-07-11 | Spain | Cantabria | 2369 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-12 04:34:30 | Cantabria, Spain | ||
3237357 | 3237357 | 2020-07-10 | Spain | Cantabria | 2369 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-11 04:34:26 | Cantabria, 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]);