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 = "Asturias" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533687 | 2533687 | 2022-05-12 | Spain | Asturias | 226247 | 2763 | 0 | 43.3614 | -5.8593 | 2022-05-13 04:20:51 | Asturias, Spain | |||
3445133 | 3445133 | 2022-05-11 | Spain | Asturias | 226247 | 2763 | 0 | 43.3614 | -5.8593 | 2022-05-12 04:20:54 | Asturias, Spain | |||
3535750 | 3535750 | 2022-05-10 | Spain | Asturias | 226247 | 2763 | 0 | 43.3614 | -5.8593 | 2022-05-11 04:20:48 | Asturias, Spain | |||
222285 | 222285 | 2022-05-09 | Spain | Asturias | 226247 | 2763 | 0 | 43.3614 | -5.8593 | 2022-05-10 04:20:50 | Asturias, Spain | |||
2331670 | 2331670 | 2022-05-08 | Spain | Asturias | 224409 | 2738 | 0 | 43.3614 | -5.8593 | 2022-05-09 04:20:54 | Asturias, Spain | |||
360632 | 360632 | 2022-05-07 | Spain | Asturias | 224409 | 2738 | 0 | 43.3614 | -5.8593 | 2022-05-08 04:20:49 | Asturias, Spain | |||
1397983 | 1397983 | 2022-05-06 | Spain | Asturias | 224409 | 2738 | 0 | 43.3614 | -5.8593 | 2022-05-07 04:21:09 | Asturias, Spain | |||
2598338 | 2598338 | 2022-05-05 | Spain | Asturias | 222494 | 2729 | 0 | 43.3614 | -5.8593 | 2022-05-06 04:21:00 | Asturias, Spain | |||
3265787 | 3265787 | 2022-05-04 | Spain | Asturias | 222494 | 2729 | 0 | 43.3614 | -5.8593 | 2022-05-05 04:20:55 | Asturias, Spain | |||
1572426 | 1572426 | 2022-05-03 | Spain | Asturias | 222494 | 2729 | 0 | 43.3614 | -5.8593 | 2022-05-04 04:20:59 | Asturias, Spain | |||
463686 | 463686 | 2022-05-02 | Spain | Asturias | 220365 | 2710 | 0 | 43.3614 | -5.8593 | 2022-05-03 04:21:00 | Asturias, Spain | |||
3916325 | 3916325 | 2022-05-01 | Spain | Asturias | 220365 | 2710 | 0 | 43.3614 | -5.8593 | 2022-05-02 04:21:10 | Asturias, Spain | |||
2841129 | 2841129 | 2022-04-30 | Spain | Asturias | 220365 | 2710 | 0 | 43.3614 | -5.8593 | 2022-05-01 04:20:57 | Asturias, Spain | |||
1157442 | 1157442 | 2022-04-29 | Spain | Asturias | 220365 | 2710 | 0 | 43.3614 | -5.8593 | 2022-04-30 04:21:05 | Asturias, Spain | |||
1696624 | 1696624 | 2022-04-28 | Spain | Asturias | 217881 | 2688 | 0 | 43.3614 | -5.8593 | 2022-04-29 04:20:59 | Asturias, Spain | |||
3852107 | 3852107 | 2022-04-27 | Spain | Asturias | 217881 | 2688 | 0 | 43.3614 | -5.8593 | 2022-04-28 04:20:47 | Asturias, Spain | |||
1326537 | 1326537 | 2022-04-26 | Spain | Asturias | 217881 | 2688 | 0 | 43.3614 | -5.8593 | 2022-04-27 04:20:52 | Asturias, Spain | |||
3722491 | 3722491 | 2022-04-25 | Spain | Asturias | 215756 | 2671 | 0 | 43.3614 | -5.8593 | 2022-04-26 04:20:51 | Asturias, Spain | |||
2029059 | 2029059 | 2022-04-24 | Spain | Asturias | 215756 | 2671 | 0 | 43.3614 | -5.8593 | 2022-04-25 04:20:56 | Asturias, Spain | |||
746634 | 746634 | 2022-04-23 | Spain | Asturias | 215756 | 2671 | 0 | 43.3614 | -5.8593 | 2022-04-24 04:20:56 | Asturias, Spain | |||
3437119 | 3437119 | 2022-04-22 | Spain | Asturias | 215756 | 2671 | 0 | 43.3614 | -5.8593 | 2022-04-23 04:20:50 | Asturias, Spain | |||
2892704 | 2892704 | 2022-04-21 | Spain | Asturias | 213558 | 2661 | 0 | 43.3614 | -5.8593 | 2022-04-22 04:20:45 | Asturias, Spain | |||
2307576 | 2307576 | 2022-04-20 | Spain | Asturias | 213558 | 2661 | 0 | 43.3614 | -5.8593 | 2022-04-21 04:20:46 | Asturias, Spain | |||
2251715 | 2251715 | 2022-04-19 | Spain | Asturias | 213558 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-20 04:20:45 | Asturias, Spain | |||
1846265 | 1846265 | 2022-04-18 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-19 04:21:00 | Asturias, Spain | |||
3417209 | 3417209 | 2022-04-17 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-18 04:21:12 | Asturias, Spain | |||
304158 | 304158 | 2022-04-16 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-17 04:20:59 | Asturias, Spain | |||
2670103 | 2670103 | 2022-04-15 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-16 04:20:48 | Asturias, Spain | |||
1223888 | 1223888 | 2022-04-14 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-15 04:20:57 | Asturias, Spain | |||
2443046 | 2443046 | 2022-04-13 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-13 23:21:06 | Asturias, Spain | |||
1948803 | 1948803 | 2022-04-12 | Spain | Asturias | 210439 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-13 04:21:03 | Asturias, Spain | |||
3206556 | 3206556 | 2022-04-11 | Spain | Asturias | 209030 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-12 04:20:49 | Asturias, Spain | |||
1576442 | 1576442 | 2022-04-10 | Spain | Asturias | 209030 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-11 04:21:02 | Asturias, Spain | |||
1652684 | 1652684 | 2022-04-09 | Spain | Asturias | 209030 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-10 04:20:52 | Asturias, Spain | |||
2116006 | 2116006 | 2022-04-08 | Spain | Asturias | 209030 | 2624 | 0 | 43.3614 | -5.8593 | 2022-04-09 04:20:42 | Asturias, Spain | |||
3320530 | 3320530 | 2022-04-07 | Spain | Asturias | 207692 | 2606 | 0 | 43.3614 | -5.8593 | 2022-04-08 04:20:48 | Asturias, Spain | |||
2801066 | 2801066 | 2022-04-06 | Spain | Asturias | 207692 | 2606 | 0 | 43.3614 | -5.8593 | 2022-04-07 04:20:53 | Asturias, Spain | |||
3867835 | 3867835 | 2022-04-05 | Spain | Asturias | 207692 | 2606 | 0 | 43.3614 | -5.8593 | 2022-04-06 04:20:49 | Asturias, Spain | |||
2749177 | 2749177 | 2022-04-04 | Spain | Asturias | 206817 | 2598 | 0 | 43.3614 | -5.8593 | 2022-04-05 04:20:48 | Asturias, Spain | |||
3730523 | 3730523 | 2022-04-03 | Spain | Asturias | 206817 | 2598 | 0 | 43.3614 | -5.8593 | 2022-04-04 04:20:51 | Asturias, Spain | |||
499958 | 499958 | 2022-04-02 | Spain | Asturias | 206817 | 2598 | 0 | 43.3614 | -5.8593 | 2022-04-03 04:20:48 | Asturias, Spain | |||
3350943 | 3350943 | 2022-04-01 | Spain | Asturias | 206817 | 2598 | 0 | 43.3614 | -5.8593 | 2022-04-02 04:20:47 | Asturias, Spain | |||
1540248 | 1540248 | 2022-03-31 | Spain | Asturias | 205070 | 2590 | 0 | 43.3614 | -5.8593 | 2022-04-01 04:20:28 | Asturias, Spain | |||
2478261 | 2478261 | 2022-03-30 | Spain | Asturias | 205070 | 2590 | 0 | 43.3614 | -5.8593 | 2022-03-31 04:20:56 | Asturias, Spain | |||
158302 | 158302 | 2022-03-29 | Spain | Asturias | 205070 | 2590 | 0 | 43.3614 | -5.8593 | 2022-03-30 04:20:45 | Asturias, Spain | |||
1436873 | 1436873 | 2022-03-28 | Spain | Asturias | 203333 | 2582 | 0 | 43.3614 | -5.8593 | 2022-03-29 04:20:46 | Asturias, Spain | |||
876554 | 876554 | 2022-03-27 | Spain | Asturias | 203333 | 2582 | 0 | 43.3614 | -5.8593 | 2022-03-28 04:20:33 | Asturias, Spain | |||
2163837 | 2163837 | 2022-03-26 | Spain | Asturias | 203333 | 2582 | 0 | 43.3614 | -5.8593 | 2022-03-27 04:20:47 | Asturias, Spain | |||
1720773 | 1720773 | 2022-03-25 | Spain | Asturias | 203333 | 2582 | 0 | 43.3614 | -5.8593 | 2022-03-26 04:20:23 | Asturias, Spain | |||
1468390 | 1468390 | 2022-03-24 | Spain | Asturias | 201625 | 2578 | 0 | 43.3614 | -5.8593 | 2022-03-25 04:20:46 | Asturias, Spain | |||
3022564 | 3022564 | 2022-03-23 | Spain | Asturias | 201625 | 2578 | 0 | 43.3614 | -5.8593 | 2022-03-24 04:20:43 | Asturias, Spain | |||
1905486 | 1905486 | 2022-03-22 | Spain | Asturias | 201625 | 2578 | 0 | 43.3614 | -5.8593 | 2022-03-23 04:20:48 | Asturias, Spain | |||
3238617 | 3238617 | 2022-03-21 | Spain | Asturias | 199853 | 2568 | 0 | 43.3614 | -5.8593 | 2022-03-22 04:20:54 | Asturias, Spain | |||
24690 | 24690 | 2022-03-20 | Spain | Asturias | 199853 | 2568 | 0 | 43.3614 | -5.8593 | 2022-03-21 04:20:50 | Asturias, Spain | |||
1656700 | 1656700 | 2022-03-19 | Spain | Asturias | 199853 | 2568 | 0 | 43.3614 | -5.8593 | 2022-03-20 04:20:45 | Asturias, Spain | |||
336226 | 336226 | 2022-03-18 | Spain | Asturias | 199853 | 2568 | 0 | 43.3614 | -5.8593 | 2022-03-19 04:20:47 | Asturias, Spain | |||
694679 | 694679 | 2022-03-17 | Spain | Asturias | 198338 | 2561 | 0 | 43.3614 | -5.8593 | 2022-03-18 04:20:55 | Asturias, Spain | |||
2319622 | 2319622 | 2022-03-16 | Spain | Asturias | 198338 | 2561 | 0 | 43.3614 | -5.8593 | 2022-03-17 04:20:56 | Asturias, Spain | |||
261822 | 261822 | 2022-03-15 | Spain | Asturias | 198338 | 2561 | 0 | 43.3614 | -5.8593 | 2022-03-16 04:20:50 | Asturias, Spain | |||
2264181 | 2264181 | 2022-03-14 | Spain | Asturias | 197400 | 2519 | 0 | 43.3614 | -5.8593 | 2022-03-15 04:20:47 | Asturias, Spain | |||
3628247 | 3628247 | 2022-03-13 | Spain | Asturias | 197400 | 2519 | 0 | 43.3614 | -5.8593 | 2022-03-14 04:20:46 | Asturias, Spain | |||
951155 | 951155 | 2022-03-12 | Spain | Asturias | 197400 | 2519 | 0 | 43.3614 | -5.8593 | 2022-03-13 04:20:49 | Asturias, Spain | |||
356616 | 356616 | 2022-03-11 | Spain | Asturias | 197400 | 2519 | 0 | 43.3614 | -5.8593 | 2022-03-12 04:20:50 | Asturias, Spain | |||
1865768 | 1865768 | 2022-03-10 | Spain | Asturias | 197065 | 2515 | 0 | 43.3614 | -5.8593 | 2022-03-11 04:20:50 | Asturias, Spain | |||
2140463 | 2140463 | 2022-03-09 | Spain | Asturias | 196571 | 2515 | 0 | 43.3614 | -5.8593 | 2022-03-10 04:20:48 | Asturias, Spain | |||
919974 | 919974 | 2022-03-08 | Spain | Asturias | 196388 | 2510 | 0 | 43.3614 | -5.8593 | 2022-03-09 04:20:59 | Asturias, Spain | |||
1548261 | 1548261 | 2022-03-07 | Spain | Asturias | 196194 | 2505 | 0 | 43.3614 | -5.8593 | 2022-03-08 04:20:54 | Asturias, Spain | |||
2199930 | 2199930 | 2022-03-06 | Spain | Asturias | 195213 | 2501 | 0 | 43.3614 | -5.8593 | 2022-03-07 04:20:47 | Asturias, Spain | |||
2092387 | 2092387 | 2022-03-05 | Spain | Asturias | 195213 | 2501 | 0 | 43.3614 | -5.8593 | 2022-03-06 04:20:49 | Asturias, Spain | |||
2666087 | 2666087 | 2022-03-04 | Spain | Asturias | 195213 | 2501 | 0 | 43.3614 | -5.8593 | 2022-03-05 04:21:10 | Asturias, Spain | |||
1644652 | 1644652 | 2022-03-03 | Spain | Asturias | 195009 | 2500 | 0 | 43.3614 | -5.8593 | 2022-03-04 04:21:09 | Asturias, Spain | |||
2525655 | 2525655 | 2022-03-02 | Spain | Asturias | 194709 | 2498 | 0 | 43.3614 | -5.8593 | 2022-03-03 04:21:01 | Asturias, Spain | |||
1992949 | 1992949 | 2022-03-01 | Spain | Asturias | 194379 | 2493 | 0 | 43.3614 | -5.8593 | 2022-03-02 04:21:07 | Asturias, Spain | |||
943123 | 943123 | 2022-02-28 | Spain | Asturias | 193358 | 2476 | 0 | 43.3614 | -5.8593 | 2022-03-01 04:21:09 | Asturias, Spain | |||
2733314 | 2733314 | 2022-02-27 | Spain | Asturias | 193358 | 2476 | 0 | 43.3614 | -5.8593 | 2022-02-28 04:21:05 | Asturias, Spain | |||
3046467 | 3046467 | 2022-02-26 | Spain | Asturias | 193358 | 2476 | 0 | 43.3614 | -5.8593 | 2022-02-27 04:21:04 | Asturias, Spain | |||
575122 | 575122 | 2022-02-25 | Spain | Asturias | 193358 | 2476 | 0 | 43.3614 | -5.8593 | 2022-02-26 04:21:12 | Asturias, Spain | |||
1511698 | 1511698 | 2022-02-24 | Spain | Asturias | 192892 | 2445 | 0 | 43.3614 | -5.8593 | 2022-02-25 04:21:11 | Asturias, Spain | |||
1058139 | 1058139 | 2022-02-23 | Spain | Asturias | 192317 | 2444 | 0 | 43.3614 | -5.8593 | 2022-02-24 04:21:14 | Asturias, Spain | |||
2447062 | 2447062 | 2022-02-22 | Spain | Asturias | 191919 | 2441 | 0 | 43.3614 | -5.8593 | 2022-02-23 04:21:09 | Asturias, Spain | |||
3718475 | 3718475 | 2022-02-21 | Spain | Asturias | 191500 | 2439 | 0 | 43.3614 | -5.8593 | 2022-02-22 04:21:01 | Asturias, Spain | |||
3912309 | 3912309 | 2022-02-20 | Spain | Asturias | 190376 | 2426 | 0 | 43.3614 | -5.8593 | 2022-02-21 04:21:05 | Asturias, Spain | |||
3875867 | 3875867 | 2022-02-19 | Spain | Asturias | 190376 | 2426 | 0 | 43.3614 | -5.8593 | 2022-02-20 04:21:00 | Asturias, Spain | |||
3856123 | 3856123 | 2022-02-18 | Spain | Asturias | 190376 | 2426 | 0 | 43.3614 | -5.8593 | 2022-02-19 04:21:11 | Asturias, Spain | |||
1298342 | 1298342 | 2022-02-17 | Spain | Asturias | 189803 | 2423 | 0 | 43.3614 | -5.8593 | 2022-02-18 04:21:04 | Asturias, Spain | |||
3820728 | 3820728 | 2022-02-16 | Spain | Asturias | 189177 | 2419 | 0 | 43.3614 | -5.8593 | 2022-02-17 04:20:56 | Asturias, Spain | |||
3671942 | 3671942 | 2022-02-15 | Spain | Asturias | 188565 | 2414 | 0 | 43.3614 | -5.8593 | 2022-02-16 04:21:10 | Asturias, Spain | |||
2642043 | 2642043 | 2022-02-14 | Spain | Asturias | 187967 | 2374 | 0 | 43.3614 | -5.8593 | 2022-02-15 04:21:09 | Asturias, Spain | |||
186360 | 186360 | 2022-02-13 | Spain | Asturias | 186129 | 2364 | 0 | 43.3614 | -5.8593 | 2022-02-14 04:20:51 | Asturias, Spain | |||
316206 | 316206 | 2022-02-12 | Spain | Asturias | 186129 | 2364 | 0 | 43.3614 | -5.8593 | 2022-02-13 04:21:00 | Asturias, Spain | |||
233532 | 233532 | 2022-02-11 | Spain | Asturias | 186129 | 2364 | 0 | 43.3614 | -5.8593 | 2022-02-12 04:21:06 | Asturias, Spain | |||
1464374 | 1464374 | 2022-02-10 | Spain | Asturias | 185170 | 2361 | 0 | 43.3614 | -5.8593 | 2022-02-11 04:21:09 | Asturias, Spain | |||
3074335 | 3074335 | 2022-02-09 | Spain | Asturias | 184335 | 2357 | 0 | 43.3614 | -5.8593 | 2022-02-10 04:21:14 | Asturias, Spain | |||
1362642 | 1362642 | 2022-02-08 | Spain | Asturias | 183259 | 2353 | 0 | 43.3614 | -5.8593 | 2022-02-09 04:21:04 | Asturias, Spain | |||
71380 | 71380 | 2022-02-07 | Spain | Asturias | 182327 | 2349 | 0 | 43.3614 | -5.8593 | 2022-02-08 04:21:15 | Asturias, Spain | |||
2012996 | 2012996 | 2022-02-06 | Spain | Asturias | 178165 | 2327 | 0 | 43.3614 | -5.8593 | 2022-02-07 04:21:05 | Asturias, Spain | |||
1294325 | 1294325 | 2022-02-05 | Spain | Asturias | 178165 | 2327 | 0 | 43.3614 | -5.8593 | 2022-02-06 04:21:00 | Asturias, Spain | |||
2327653 | 2327653 | 2022-02-04 | Spain | Asturias | 178165 | 2327 | 0 | 43.3614 | -5.8593 | 2022-02-05 04:21:05 | Asturias, Spain | |||
2474244 | 2474244 | 2022-02-03 | Spain | Asturias | 178165 | 2327 | 0 | 43.3614 | -5.8593 | 2022-02-04 04:21:10 | Asturias, Spain | |||
459669 | 459669 | 2022-02-02 | Spain | Asturias | 176969 | 2319 | 0 | 43.3614 | -5.8593 | 2022-02-03 04:21:21 | 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]);