johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where combined_key = "Asturias, Spain" and country_or_region = "Spain" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- …
province_or_state 1
- Asturias 960
country_or_region 1
- Spain · 960 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1104829 | 1104829 | 2020-05-25 | Spain | Asturias | 2380 | 288 | 0 | 2092 | 43.3614 | -5.8593 | 2020-05-26 02:32:35 | Asturias, Spain | ||
2390098 | 2390098 | 2020-05-19 | Spain | Asturias | 2373 | 303 | 0 | 2070 | 43.3614 | -5.8593 | 2020-05-20 02:32:19 | Asturias, Spain | ||
1431812 | 1431812 | 2020-05-20 | Spain | Asturias | 2374 | 304 | 0 | 2070 | 43.3614 | -5.8593 | 2020-05-21 02:32:48 | Asturias, Spain | ||
268229 | 268229 | 2020-05-21 | Spain | Asturias | 2374 | 307 | 0 | 2067 | 43.3614 | -5.8593 | 2020-05-22 02:36:51 | Asturias, Spain | ||
997700 | 997700 | 2020-05-23 | Spain | Asturias | 2377 | 307 | 0 | 2070 | 43.3614 | -5.8593 | 2020-05-24 02:32:43 | Asturias, Spain | ||
1864723 | 1864723 | 2020-05-22 | Spain | Asturias | 2376 | 307 | 0 | 2069 | 43.3614 | -5.8593 | 2020-05-23 02:32:42 | Asturias, Spain | ||
875509 | 875509 | 2020-05-24 | Spain | Asturias | 2397 | 308 | 0 | 2089 | 43.3614 | -5.8593 | 2020-05-25 02:32:44 | Asturias, Spain | ||
1404355 | 1404355 | 2020-05-14 | Spain | Asturias | 2356 | 308 | 1046 | 1002 | 43.3614 | -5.8593 | 2020-05-15 02:33:02 | Asturias, Spain | ||
805173 | 805173 | 2020-06-01 | Spain | Asturias | 2425 | 310 | 1063 | 1052 | 43.3614 | -5.8593 | 2020-06-02 02:33:08 | Asturias, Spain | ||
1041099 | 1041099 | 2020-05-26 | Spain | Asturias | 2399 | 310 | 1063 | 1026 | 43.3614 | -5.8593 | 2020-05-27 02:32:31 | Asturias, Spain | ||
1790246 | 1790246 | 2020-05-29 | Spain | Asturias | 2401 | 310 | 1063 | 1028 | 43.3614 | -5.8593 | 2020-05-30 02:32:48 | Asturias, Spain | ||
1793812 | 1793812 | 2020-05-31 | Spain | Asturias | 2424 | 310 | 1063 | 1051 | 43.3614 | -5.8593 | 2020-06-01 02:32:46 | Asturias, Spain | ||
2548136 | 2548136 | 2020-05-27 | Spain | Asturias | 2399 | 310 | 1063 | 1026 | 43.3614 | -5.8593 | 2020-05-28 02:32:31 | Asturias, Spain | ||
2555637 | 2555637 | 2020-06-02 | Spain | Asturias | 2425 | 310 | 1063 | 1052 | 43.3614 | -5.8593 | 2020-06-03 02:33:13 | Asturias, Spain | ||
2712126 | 2712126 | 2020-05-28 | Spain | Asturias | 2400 | 310 | 1063 | 1027 | 43.3614 | -5.8593 | 2020-05-29 02:32:50 | Asturias, Spain | ||
3276181 | 3276181 | 2020-05-15 | Spain | Asturias | 2359 | 310 | 1053 | 996 | 43.3614 | -5.8593 | 2020-05-16 02:32:19 | Asturias, Spain | ||
3638705 | 3638705 | 2020-05-30 | Spain | Asturias | 2421 | 310 | 1063 | 1048 | 43.3614 | -5.8593 | 2020-05-31 02:32:45 | Asturias, Spain | ||
3866594 | 3866594 | 2020-06-03 | Spain | Asturias | 2425 | 310 | 1063 | 1052 | 43.3614 | -5.8593 | 2020-06-04 02:33:14 | Asturias, Spain | ||
1281039 | 1281039 | 2020-06-04 | Spain | Asturias | 2425 | 311 | 1063 | 1051 | 43.3614 | -5.8593 | 2020-06-05 02:33:06 | Asturias, Spain | ||
1269558 | 1269558 | 2020-06-05 | Spain | Asturias | 2424 | 312 | 1063 | 1049 | 43.3614 | -5.8593 | 2020-06-06 02:33:00 | Asturias, Spain | ||
573861 | 573861 | 2020-06-06 | Spain | Asturias | 2426 | 313 | 1063 | 1050 | 43.3614 | -5.8593 | 2020-06-07 03:53:30 | Asturias, Spain | ||
1829465 | 1829465 | 2020-05-16 | Spain | Asturias | 2366 | 313 | 1055 | 998 | 43.3614 | -5.8593 | 2020-05-17 02:32:32 | Asturias, Spain | ||
3416231 | 3416231 | 2020-05-17 | Spain | Asturias | 2366 | 313 | 1055 | 998 | 43.3614 | -5.8593 | 2020-05-18 02:32:21 | Asturias, Spain | ||
217008 | 217008 | 2020-06-08 | Spain | Asturias | 2429 | 314 | 1063 | 1052 | 43.3614 | -5.8593 | 2020-06-09 03:33:03 | Asturias, Spain | ||
286988 | 286988 | 2020-06-15 | Spain | Asturias | 2437 | 314 | 1063 | 1060 | 43.3614 | -5.8593 | 2020-06-16 04:33:09 | Asturias, Spain | ||
737311 | 737311 | 2020-06-12 | Spain | Asturias | 2435 | 314 | 1063 | 1058 | 43.3614 | -5.8593 | 2020-06-13 03:33:14 | Asturias, Spain | ||
1195662 | 1195662 | 2020-06-17 | Spain | Asturias | 2436 | 314 | 1063 | 1059 | 43.3614 | -5.8593 | 2020-06-18 04:33:18 | Asturias, Spain | ||
1210581 | 1210581 | 2020-06-09 | Spain | Asturias | 2430 | 314 | 1063 | 1053 | 43.3614 | -5.8593 | 2020-06-10 04:07:00 | Asturias, Spain | ||
1273281 | 1273281 | 2020-06-11 | Spain | Asturias | 2431 | 314 | 1063 | 1054 | 43.3614 | -5.8593 | 2020-06-12 05:09:52 | Asturias, Spain | ||
1836939 | 1836939 | 2020-06-14 | Spain | Asturias | 2437 | 314 | 1063 | 1060 | 43.3614 | -5.8593 | 2020-06-15 03:33:14 | Asturias, Spain | ||
2386425 | 2386425 | 2020-06-16 | Spain | Asturias | 2438 | 314 | 1063 | 1061 | 43.3614 | -5.8593 | 2020-06-17 04:33:21 | Asturias, Spain | ||
2799805 | 2799805 | 2020-06-07 | Spain | Asturias | 2427 | 314 | 1063 | 1050 | 43.3614 | -5.8593 | 2020-06-08 03:33:22 | Asturias, Spain | ||
2863725 | 2863725 | 2020-06-10 | Spain | Asturias | 2431 | 314 | 1063 | 1054 | 43.3614 | -5.8593 | 2020-06-11 03:33:41 | Asturias, Spain | ||
3060991 | 3060991 | 2020-06-13 | Spain | Asturias | 2437 | 314 | 1063 | 1060 | 43.3614 | -5.8593 | 2020-06-14 03:33:15 | Asturias, Spain | ||
3682459 | 3682459 | 2020-06-18 | Spain | Asturias | 2435 | 314 | 1063 | 1058 | 43.3614 | -5.8593 | 2020-06-19 04:33:17 | Asturias, Spain | ||
3260837 | 3260837 | 2020-05-18 | Spain | Asturias | 2369 | 317 | 1063 | 989 | 43.3614 | -5.8593 | 2020-05-19 02:32:18 | Asturias, Spain | ||
1510400 | 1510400 | 2020-06-22 | Spain | Asturias | 2435 | 333 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-06-23 04:33:22 | Asturias, Spain | ||
1522206 | 1522206 | 2020-06-23 | Spain | Asturias | 2435 | 333 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-06-24 04:33:28 | Asturias, Spain | ||
1691310 | 1691310 | 2020-06-19 | Spain | Asturias | 2435 | 333 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-06-20 04:33:19 | Asturias, Spain | ||
2437732 | 2437732 | 2020-06-20 | Spain | Asturias | 2435 | 333 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-06-21 04:33:19 | Asturias, Spain | ||
2700521 | 2700521 | 2020-06-24 | Spain | Asturias | 2435 | 333 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-06-25 05:26:54 | Asturias, Spain | ||
3249139 | 3249139 | 2020-06-21 | Spain | Asturias | 2435 | 333 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-06-22 04:33:20 | Asturias, Spain | ||
61775 | 61775 | 2020-07-23 | Spain | Asturias | 2452 | 334 | 1063 | 1055 | 43.3614 | -5.8593 | 2020-07-24 05:30:40 | Asturias, Spain | ||
98106 | 98106 | 2020-08-04 | Spain | Asturias | 2558 | 334 | 1063 | 1161 | 43.3614 | -5.8593 | 2020-08-05 04:34:43 | Asturias, Spain | ||
121699 | 121699 | 2020-07-19 | Spain | Asturias | 2442 | 334 | 1063 | 1045 | 43.3614 | -5.8593 | 2020-07-20 05:34:40 | Asturias, Spain | ||
146253 | 146253 | 2020-08-15 | Spain | Asturias | 2785 | 334 | 1063 | 1388 | 43.3614 | -5.8593 | 2020-08-16 04:27:42 | Asturias, Spain | ||
177017 | 177017 | 2020-07-27 | Spain | Asturias | 2465 | 334 | 1063 | 1068 | 43.3614 | -5.8593 | 2020-07-28 04:58:43 | Asturias, Spain | ||
206535 | 206535 | 2020-08-19 | Spain | Asturias | 2910 | 334 | 1063 | 1513 | 43.3614 | -5.8593 | 2020-08-20 04:27:43 | Asturias, Spain | ||
302860 | 302860 | 2020-07-01 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-02 04:33:46 | Asturias, Spain | ||
326794 | 326794 | 2020-07-20 | Spain | Asturias | 2445 | 334 | 1063 | 1048 | 43.3614 | -5.8593 | 2020-07-21 04:38:46 | Asturias, Spain | ||
367209 | 367209 | 2020-07-16 | Spain | Asturias | 2442 | 334 | 1063 | 1045 | 43.3614 | -5.8593 | 2020-07-17 04:34:50 | Asturias, Spain | ||
371171 | 371171 | 2020-08-08 | Spain | Asturias | 2635 | 334 | 1063 | 1238 | 43.3614 | -5.8593 | 2020-08-09 04:34:54 | Asturias, Spain | ||
415152 | 415152 | 2020-07-05 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-06 04:33:57 | Asturias, Spain | ||
442330 | 442330 | 2020-07-26 | Spain | Asturias | 2454 | 334 | 1063 | 1057 | 43.3614 | -5.8593 | 2020-07-27 04:35:02 | Asturias, Spain | ||
458355 | 458355 | 2020-08-07 | Spain | Asturias | 2635 | 334 | 1063 | 1238 | 43.3614 | -5.8593 | 2020-08-08 04:34:53 | Asturias, Spain | ||
529714 | 529714 | 2020-07-04 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-05 04:33:46 | Asturias, Spain | ||
583112 | 583112 | 2020-08-13 | Spain | Asturias | 2764 | 334 | 1063 | 1367 | 43.3614 | -5.8593 | 2020-08-14 04:51:19 | Asturias, Spain | ||
662580 | 662580 | 2020-08-11 | Spain | Asturias | 2715 | 334 | 1063 | 1318 | 43.3614 | -5.8593 | 2020-08-12 04:27:29 | Asturias, Spain | ||
753309 | 753309 | 2020-08-01 | Spain | Asturias | 2516 | 334 | 1063 | 1119 | 43.3614 | -5.8593 | 2020-08-02 04:34:47 | Asturias, Spain | ||
837893 | 837893 | 2020-08-17 | Spain | Asturias | 2861 | 334 | 1063 | 1464 | 43.3614 | -5.8593 | 2020-08-18 04:27:56 | Asturias, Spain | ||
844564 | 844564 | 2020-07-22 | Spain | Asturias | 2448 | 334 | 1063 | 1051 | 43.3614 | -5.8593 | 2020-07-23 05:15:04 | Asturias, Spain | ||
887127 | 887127 | 2020-07-07 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-08 05:33:48 | Asturias, Spain | ||
1005302 | 1005302 | 2020-07-09 | Spain | Asturias | 2436 | 334 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-07-10 04:34:24 | Asturias, Spain | ||
1135894 | 1135894 | 2020-06-26 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-06-27 04:33:35 | Asturias, Spain | ||
1479837 | 1479837 | 2020-08-21 | Spain | Asturias | 2973 | 334 | 1063 | 1576 | 43.3614 | -5.8593 | 2020-08-22 04:27:49 | Asturias, Spain | ||
1502574 | 1502574 | 2020-07-25 | Spain | Asturias | 2454 | 334 | 1063 | 1057 | 43.3614 | -5.8593 | 2020-07-26 04:35:00 | Asturias, Spain | ||
1556251 | 1556251 | 2020-08-16 | Spain | Asturias | 2785 | 334 | 1063 | 1388 | 43.3614 | -5.8593 | 2020-08-17 04:27:20 | Asturias, Spain | ||
1612528 | 1612528 | 2020-08-14 | Spain | Asturias | 2785 | 334 | 1063 | 1388 | 43.3614 | -5.8593 | 2020-08-15 04:27:31 | Asturias, Spain | ||
1707303 | 1707303 | 2020-07-21 | Spain | Asturias | 2447 | 334 | 1063 | 1050 | 43.3614 | -5.8593 | 2020-07-22 04:34:42 | Asturias, Spain | ||
1920194 | 1920194 | 2020-08-10 | Spain | Asturias | 2701 | 334 | 1063 | 1304 | 43.3614 | -5.8593 | 2020-08-11 04:35:08 | Asturias, Spain | ||
1928181 | 1928181 | 2020-07-30 | Spain | Asturias | 2495 | 334 | 1063 | 1098 | 43.3614 | -5.8593 | 2020-07-31 04:35:18 | Asturias, Spain | ||
2039613 | 2039613 | 2020-06-27 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-06-28 04:34:04 | Asturias, Spain | ||
2158521 | 2158521 | 2020-07-14 | Spain | Asturias | 2442 | 334 | 1063 | 1045 | 43.3614 | -5.8593 | 2020-07-15 04:34:39 | Asturias, Spain | ||
2215948 | 2215948 | 2020-08-23 | Spain | Asturias | 2973 | 334 | 1063 | 1576 | 43.3614 | -5.8593 | 2020-08-24 04:27:56 | Asturias, Spain | ||
2222518 | 2222518 | 2020-07-08 | Spain | Asturias | 2436 | 334 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-07-09 04:34:23 | Asturias, Spain | ||
2234375 | 2234375 | 2020-07-03 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-04 04:33:51 | Asturias, Spain | ||
2299730 | 2299730 | 2020-08-22 | Spain | Asturias | 2973 | 334 | 1063 | 1576 | 43.3614 | -5.8593 | 2020-08-23 04:27:48 | Asturias, Spain | ||
2306278 | 2306278 | 2020-06-28 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-06-29 04:33:44 | Asturias, Spain | ||
2563544 | 2563544 | 2020-07-24 | Spain | Asturias | 2454 | 334 | 1063 | 1057 | 43.3614 | -5.8593 | 2020-07-25 04:47:39 | Asturias, Spain | ||
2624881 | 2624881 | 2020-06-25 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-06-26 04:33:43 | Asturias, Spain | ||
2632715 | 2632715 | 2020-06-29 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-06-30 04:33:48 | Asturias, Spain | ||
2684687 | 2684687 | 2020-07-06 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-07 04:34:00 | Asturias, Spain | ||
2708390 | 2708390 | 2020-07-17 | Spain | Asturias | 2442 | 334 | 1063 | 1045 | 43.3614 | -5.8593 | 2020-07-18 04:34:45 | Asturias, Spain | ||
2739989 | 2739989 | 2020-08-03 | Spain | Asturias | 2552 | 334 | 1063 | 1155 | 43.3614 | -5.8593 | 2020-08-04 04:41:59 | Asturias, Spain | ||
2747877 | 2747877 | 2020-07-15 | Spain | Asturias | 2442 | 334 | 1063 | 1045 | 43.3614 | -5.8593 | 2020-07-16 04:44:59 | Asturias, Spain | ||
2807741 | 2807741 | 2020-08-02 | Spain | Asturias | 2516 | 334 | 1063 | 1119 | 43.3614 | -5.8593 | 2020-08-03 04:34:35 | Asturias, Spain | ||
2958349 | 2958349 | 2020-07-29 | Spain | Asturias | 2480 | 334 | 1063 | 1083 | 43.3614 | -5.8593 | 2020-07-30 04:35:05 | Asturias, Spain | ||
2974238 | 2974238 | 2020-06-30 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-01 04:33:52 | Asturias, Spain | ||
3045169 | 3045169 | 2020-07-02 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-03 04:33:54 | Asturias, Spain | ||
3178289 | 3178289 | 2020-08-18 | Spain | Asturias | 2880 | 334 | 1063 | 1483 | 43.3614 | -5.8593 | 2020-08-19 04:27:00 | Asturias, Spain | ||
3184965 | 3184965 | 2020-07-28 | Spain | Asturias | 2468 | 334 | 1063 | 1071 | 43.3614 | -5.8593 | 2020-07-29 04:35:11 | Asturias, Spain | ||
3205088 | 3205088 | 2020-07-18 | Spain | Asturias | 2442 | 334 | 1063 | 1045 | 43.3614 | -5.8593 | 2020-07-19 04:34:58 | Asturias, Spain | ||
3237317 | 3237317 | 2020-07-10 | Spain | Asturias | 2437 | 334 | 1063 | 1040 | 43.3614 | -5.8593 | 2020-07-11 04:34:26 | Asturias, Spain | ||
3264474 | 3264474 | 2020-07-31 | Spain | Asturias | 2516 | 334 | 1063 | 1119 | 43.3614 | -5.8593 | 2020-08-01 04:36:27 | Asturias, Spain | ||
3435819 | 3435819 | 2020-07-11 | Spain | Asturias | 2437 | 334 | 1063 | 1040 | 43.3614 | -5.8593 | 2020-07-12 04:34:30 | Asturias, Spain | ||
3484586 | 3484586 | 2020-08-20 | Spain | Asturias | 2933 | 334 | 1063 | 1536 | 43.3614 | -5.8593 | 2020-08-21 04:27:41 | Asturias, Spain | ||
3491162 | 3491162 | 2020-07-13 | Spain | Asturias | 2437 | 334 | 1063 | 1040 | 43.3614 | -5.8593 | 2020-07-14 04:34:46 | Asturias, Spain | ||
3531731 | 3531731 | 2020-08-12 | Spain | Asturias | 2733 | 334 | 1063 | 1336 | 43.3614 | -5.8593 | 2020-08-13 04:29:15 | Asturias, Spain | ||
3612040 | 3612040 | 2020-08-06 | Spain | Asturias | 2606 | 334 | 1063 | 1209 | 43.3614 | -5.8593 | 2020-08-07 04:35:11 | Asturias, Spain | ||
3737424 | 3737424 | 2020-07-12 | Spain | Asturias | 2437 | 334 | 1063 | 1040 | 43.3614 | -5.8593 | 2020-07-13 04:43:04 | Asturias, 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]);