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 = "C. Valenciana" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2017018 | 2017018 | 2022-09-20 | Spain | C. Valenciana | 1550009 | 10011 | 0 | 39.484 | -0.7533 | 2022-09-21 04:23:22 | C. Valenciana, Spain | |||
3570891 | 3570891 | 2022-09-19 | Spain | C. Valenciana | 1549064 | 10006 | 0 | 39.484 | -0.7533 | 2022-09-20 04:22:48 | C. Valenciana, Spain | |||
419630 | 419630 | 2022-09-18 | Spain | C. Valenciana | 1549064 | 10006 | 0 | 39.484 | -0.7533 | 2022-09-19 04:21:49 | C. Valenciana, Spain | |||
3373654 | 3373654 | 2022-09-17 | Spain | C. Valenciana | 1549064 | 10006 | 0 | 39.484 | -0.7533 | 2022-09-18 04:22:50 | C. Valenciana, Spain | |||
2355762 | 2355762 | 2022-09-16 | Spain | C. Valenciana | 1549064 | 10006 | 0 | 39.484 | -0.7533 | 2022-09-17 04:20:19 | C. Valenciana, Spain | |||
3986919 | 3986919 | 2022-09-15 | Spain | C. Valenciana | 1547962 | 10000 | 0 | 39.484 | -0.7533 | 2022-09-16 04:21:19 | C. Valenciana, Spain | |||
1889436 | 1889436 | 2022-09-14 | Spain | C. Valenciana | 1547962 | 10000 | 0 | 39.484 | -0.7533 | 2022-09-15 04:21:02 | C. Valenciana, Spain | |||
372491 | 372491 | 2022-09-13 | Spain | C. Valenciana | 1547962 | 10000 | 0 | 39.484 | -0.7533 | 2022-09-14 04:20:44 | C. Valenciana, Spain | |||
2395094 | 2395094 | 2022-09-12 | Spain | C. Valenciana | 1546998 | 9996 | 0 | 39.484 | -0.7533 | 2022-09-13 04:20:57 | C. Valenciana, Spain | |||
3766172 | 3766172 | 2022-09-11 | Spain | C. Valenciana | 1546998 | 9996 | 0 | 39.484 | -0.7533 | 2022-09-12 04:20:58 | C. Valenciana, Spain | |||
3824747 | 3824747 | 2022-09-10 | Spain | C. Valenciana | 1546998 | 9996 | 0 | 39.484 | -0.7533 | 2022-09-11 04:20:50 | C. Valenciana, Spain | |||
963204 | 963204 | 2022-09-09 | Spain | C. Valenciana | 1546998 | 9996 | 0 | 39.484 | -0.7533 | 2022-09-10 04:21:10 | C. Valenciana, Spain | |||
253606 | 253606 | 2022-09-08 | Spain | C. Valenciana | 1545814 | 9976 | 0 | 39.484 | -0.7533 | 2022-09-09 04:21:11 | C. Valenciana, Spain | |||
3745404 | 3745404 | 2022-09-07 | Spain | C. Valenciana | 1545814 | 9976 | 0 | 39.484 | -0.7533 | 2022-09-08 04:21:02 | C. Valenciana, Spain | |||
115044 | 115044 | 2022-09-06 | Spain | C. Valenciana | 1545814 | 9976 | 0 | 39.484 | -0.7533 | 2022-09-07 04:20:59 | C. Valenciana, Spain | |||
2634016 | 2634016 | 2022-09-05 | Spain | C. Valenciana | 1544665 | 9968 | 0 | 39.484 | -0.7533 | 2022-09-06 04:21:02 | C. Valenciana, Spain | |||
2987580 | 2987580 | 2022-09-04 | Spain | C. Valenciana | 1544665 | 9968 | 0 | 39.484 | -0.7533 | 2022-09-05 04:21:01 | C. Valenciana, Spain | |||
2713265 | 2713265 | 2022-09-03 | Spain | C. Valenciana | 1544665 | 9968 | 0 | 39.484 | -0.7533 | 2022-09-04 04:21:22 | C. Valenciana, Spain | |||
1393970 | 1393970 | 2022-09-02 | Spain | C. Valenciana | 1544665 | 9968 | 0 | 39.484 | -0.7533 | 2022-09-03 04:21:04 | C. Valenciana, Spain | |||
3547799 | 3547799 | 2022-09-01 | Spain | C. Valenciana | 1543519 | 9950 | 0 | 39.484 | -0.7533 | 2022-09-02 04:21:07 | C. Valenciana, Spain | |||
2343719 | 2343719 | 2022-08-31 | Spain | C. Valenciana | 1543519 | 9950 | 0 | 39.484 | -0.7533 | 2022-09-01 04:21:03 | C. Valenciana, Spain | |||
3774199 | 3774199 | 2022-08-30 | Spain | C. Valenciana | 1543519 | 9950 | 0 | 39.484 | -0.7533 | 2022-08-31 04:20:57 | C. Valenciana, Spain | |||
1680795 | 1680795 | 2022-08-29 | Spain | C. Valenciana | 1542354 | 9938 | 0 | 39.484 | -0.7533 | 2022-08-30 04:21:03 | C. Valenciana, Spain | |||
1877279 | 1877279 | 2022-08-28 | Spain | C. Valenciana | 1542354 | 9938 | 0 | 39.484 | -0.7533 | 2022-08-29 04:21:06 | C. Valenciana, Spain | |||
2096406 | 2096406 | 2022-08-27 | Spain | C. Valenciana | 1542354 | 9938 | 0 | 39.484 | -0.7533 | 2022-08-28 04:21:02 | C. Valenciana, Spain | |||
1532221 | 1532221 | 2022-08-26 | Spain | C. Valenciana | 1542354 | 9938 | 0 | 39.484 | -0.7533 | 2022-08-27 04:20:57 | C. Valenciana, Spain | |||
2829108 | 2829108 | 2022-08-25 | Spain | C. Valenciana | 1541004 | 9921 | 0 | 39.484 | -0.7533 | 2022-08-26 04:21:02 | C. Valenciana, Spain | |||
2323641 | 2323641 | 2022-08-24 | Spain | C. Valenciana | 1541004 | 9921 | 0 | 39.484 | -0.7533 | 2022-08-25 04:21:13 | C. Valenciana, Spain | |||
1251050 | 1251050 | 2022-08-23 | Spain | C. Valenciana | 1541004 | 9921 | 0 | 39.484 | -0.7533 | 2022-08-24 04:20:46 | C. Valenciana, Spain | |||
2853154 | 2853154 | 2022-08-22 | Spain | C. Valenciana | 1539557 | 9901 | 0 | 39.484 | -0.7533 | 2022-08-23 04:20:56 | C. Valenciana, Spain | |||
2403126 | 2403126 | 2022-08-21 | Spain | C. Valenciana | 1539557 | 9901 | 0 | 39.484 | -0.7533 | 2022-08-22 04:20:38 | C. Valenciana, Spain | |||
3798204 | 3798204 | 2022-08-20 | Spain | C. Valenciana | 1539557 | 9901 | 0 | 39.484 | -0.7533 | 2022-08-21 04:20:44 | C. Valenciana, Spain | |||
2363790 | 2363790 | 2022-08-19 | Spain | C. Valenciana | 1539557 | 9901 | 0 | 39.484 | -0.7533 | 2022-08-20 04:21:01 | C. Valenciana, Spain | |||
1161461 | 1161461 | 2022-08-18 | Spain | C. Valenciana | 1538581 | 9870 | 0 | 39.484 | -0.7533 | 2022-08-19 04:20:54 | C. Valenciana, Spain | |||
3950785 | 3950785 | 2022-08-17 | Spain | C. Valenciana | 1538581 | 9870 | 0 | 39.484 | -0.7533 | 2022-08-18 04:21:11 | C. Valenciana, Spain | |||
991287 | 991287 | 2022-08-16 | Spain | C. Valenciana | 1538581 | 9870 | 0 | 39.484 | -0.7533 | 2022-08-17 04:20:59 | C. Valenciana, Spain | |||
2494326 | 2494326 | 2022-08-15 | Spain | C. Valenciana | 1536883 | 9860 | 0 | 39.484 | -0.7533 | 2022-08-16 04:20:58 | C. Valenciana, Spain | |||
3647876 | 3647876 | 2022-08-14 | Spain | C. Valenciana | 1536883 | 9860 | 0 | 39.484 | -0.7533 | 2022-08-15 04:20:59 | C. Valenciana, Spain | |||
1968882 | 1968882 | 2022-08-13 | Spain | C. Valenciana | 1536883 | 9860 | 0 | 39.484 | -0.7533 | 2022-08-14 04:20:55 | C. Valenciana, Spain | |||
2888691 | 2888691 | 2022-08-12 | Spain | C. Valenciana | 1536883 | 9860 | 0 | 39.484 | -0.7533 | 2022-08-13 04:20:52 | C. Valenciana, Spain | |||
3908296 | 3908296 | 2022-08-11 | Spain | C. Valenciana | 1534887 | 9831 | 0 | 39.484 | -0.7533 | 2022-08-12 04:20:54 | C. Valenciana, Spain | |||
1346613 | 1346613 | 2022-08-10 | Spain | C. Valenciana | 1534887 | 9831 | 0 | 39.484 | -0.7533 | 2022-08-11 04:20:49 | C. Valenciana, Spain | |||
1086368 | 1086368 | 2022-08-09 | Spain | C. Valenciana | 1534887 | 9831 | 0 | 39.484 | -0.7533 | 2022-08-10 04:20:57 | C. Valenciana, Spain | |||
3543783 | 3543783 | 2022-08-08 | Spain | C. Valenciana | 1532223 | 9814 | 0 | 39.484 | -0.7533 | 2022-08-09 04:20:34 | C. Valenciana, Spain | |||
1070186 | 1070186 | 2022-08-07 | Spain | C. Valenciana | 1532223 | 9814 | 0 | 39.484 | -0.7533 | 2022-08-08 04:21:08 | C. Valenciana, Spain | |||
1940774 | 1940774 | 2022-08-06 | Spain | C. Valenciana | 1532223 | 9814 | 0 | 39.484 | -0.7533 | 2022-08-07 04:20:54 | C. Valenciana, Spain | |||
880573 | 880573 | 2022-08-05 | Spain | C. Valenciana | 1532223 | 9814 | 0 | 39.484 | -0.7533 | 2022-08-06 04:20:56 | C. Valenciana, Spain | |||
2008984 | 2008984 | 2022-08-04 | Spain | C. Valenciana | 1529728 | 9771 | 0 | 39.484 | -0.7533 | 2022-08-05 04:20:52 | C. Valenciana, Spain | |||
1098411 | 1098411 | 2022-08-03 | Spain | C. Valenciana | 1529728 | 9771 | 0 | 39.484 | -0.7533 | 2022-08-04 04:20:58 | C. Valenciana, Spain | |||
1405336 | 1405336 | 2022-08-02 | Spain | C. Valenciana | 1529728 | 9771 | 0 | 39.484 | -0.7533 | 2022-08-03 04:20:59 | C. Valenciana, Spain | |||
3617374 | 3617374 | 2022-08-01 | Spain | C. Valenciana | 1526806 | 9739 | 0 | 39.484 | -0.7533 | 2022-08-02 04:20:53 | C. Valenciana, Spain | |||
3871854 | 3871854 | 2022-07-31 | Spain | C. Valenciana | 1526806 | 9739 | 0 | 39.484 | -0.7533 | 2022-08-01 04:21:03 | C. Valenciana, Spain | |||
674608 | 674608 | 2022-07-30 | Spain | C. Valenciana | 1526806 | 9739 | 0 | 39.484 | -0.7533 | 2022-07-31 04:21:02 | C. Valenciana, Spain | |||
1783807 | 1783807 | 2022-07-29 | Spain | C. Valenciana | 1526806 | 9739 | 0 | 39.484 | -0.7533 | 2022-07-30 04:20:42 | C. Valenciana, Spain | |||
1066170 | 1066170 | 2022-07-28 | Spain | C. Valenciana | 1523287 | 9703 | 0 | 39.484 | -0.7533 | 2022-07-29 04:20:45 | C. Valenciana, Spain | |||
2335689 | 2335689 | 2022-07-27 | Spain | C. Valenciana | 1523287 | 9703 | 0 | 39.484 | -0.7533 | 2022-07-28 04:20:56 | C. Valenciana, Spain | |||
1487879 | 1487879 | 2022-07-26 | Spain | C. Valenciana | 1523287 | 9703 | 0 | 39.484 | -0.7533 | 2022-07-27 04:21:04 | C. Valenciana, Spain | |||
2594325 | 2594325 | 2022-07-25 | Spain | C. Valenciana | 1518781 | 9669 | 0 | 39.484 | -0.7533 | 2022-07-26 04:20:58 | C. Valenciana, Spain | |||
896440 | 896440 | 2022-07-24 | Spain | C. Valenciana | 1518781 | 9669 | 0 | 39.484 | -0.7533 | 2022-07-25 04:20:51 | C. Valenciana, Spain | |||
91434 | 91434 | 2022-07-23 | Spain | C. Valenciana | 1518781 | 9669 | 0 | 39.484 | -0.7533 | 2022-07-24 04:20:47 | C. Valenciana, Spain | |||
900456 | 900456 | 2022-07-22 | Spain | C. Valenciana | 1518781 | 9669 | 0 | 39.484 | -0.7533 | 2022-07-23 04:20:53 | C. Valenciana, Spain | |||
670592 | 670592 | 2022-07-21 | Spain | C. Valenciana | 1514025 | 9606 | 0 | 39.484 | -0.7533 | 2022-07-22 04:21:15 | C. Valenciana, Spain | |||
1608555 | 1608555 | 2022-07-20 | Spain | C. Valenciana | 1514025 | 9606 | 0 | 39.484 | -0.7533 | 2022-07-21 04:21:10 | C. Valenciana, Spain | |||
959188 | 959188 | 2022-07-19 | Spain | C. Valenciana | 1514025 | 9606 | 0 | 39.484 | -0.7533 | 2022-07-20 04:20:59 | C. Valenciana, Spain | |||
3210575 | 3210575 | 2022-07-18 | Spain | C. Valenciana | 1508602 | 9593 | 0 | 39.484 | -0.7533 | 2022-07-19 04:20:58 | C. Valenciana, Spain | |||
3405750 | 3405750 | 2022-07-17 | Spain | C. Valenciana | 1508602 | 9593 | 0 | 39.484 | -0.7533 | 2022-07-18 04:20:59 | C. Valenciana, Spain | |||
2151950 | 2151950 | 2022-07-16 | Spain | C. Valenciana | 1508602 | 9593 | 0 | 39.484 | -0.7533 | 2022-07-17 04:21:15 | C. Valenciana, Spain | |||
2419183 | 2419183 | 2022-07-15 | Spain | C. Valenciana | 1508602 | 9593 | 0 | 39.484 | -0.7533 | 2022-07-16 04:21:05 | C. Valenciana, Spain | |||
3429258 | 3429258 | 2022-07-14 | Spain | C. Valenciana | 1502107 | 9557 | 0 | 39.484 | -0.7533 | 2022-07-15 04:20:53 | C. Valenciana, Spain | |||
3109778 | 3109778 | 2022-07-13 | Spain | C. Valenciana | 1502107 | 9557 | 0 | 39.484 | -0.7533 | 2022-07-14 04:20:57 | C. Valenciana, Spain | |||
630201 | 630201 | 2022-07-12 | Spain | C. Valenciana | 1502107 | 9557 | 0 | 39.484 | -0.7533 | 2022-07-13 04:20:58 | C. Valenciana, Spain | |||
1211845 | 1211845 | 2022-07-11 | Spain | C. Valenciana | 1494467 | 9540 | 0 | 39.484 | -0.7533 | 2022-07-12 04:20:51 | C. Valenciana, Spain | |||
2789327 | 2789327 | 2022-07-10 | Spain | C. Valenciana | 1494467 | 9540 | 0 | 39.484 | -0.7533 | 2022-07-11 04:20:46 | C. Valenciana, Spain | |||
142280 | 142280 | 2022-07-09 | Spain | C. Valenciana | 1494467 | 9540 | 0 | 39.484 | -0.7533 | 2022-07-10 04:20:54 | C. Valenciana, Spain | |||
1417380 | 1417380 | 2022-07-08 | Spain | C. Valenciana | 1494467 | 9540 | 0 | 39.484 | -0.7533 | 2022-07-09 04:20:59 | C. Valenciana, Spain | |||
2741305 | 2741305 | 2022-07-07 | Spain | C. Valenciana | 1485613 | 9517 | 0 | 39.484 | -0.7533 | 2022-07-08 04:20:56 | C. Valenciana, Spain | |||
1200100 | 1200100 | 2022-07-06 | Spain | C. Valenciana | 1485613 | 9517 | 0 | 39.484 | -0.7533 | 2022-07-07 04:20:55 | C. Valenciana, Spain | |||
3966843 | 3966843 | 2022-07-05 | Spain | C. Valenciana | 1485613 | 9517 | 0 | 39.484 | -0.7533 | 2022-07-06 04:20:58 | C. Valenciana, Spain | |||
3078354 | 3078354 | 2022-07-04 | Spain | C. Valenciana | 1477267 | 9507 | 0 | 39.484 | -0.7533 | 2022-07-05 04:20:45 | C. Valenciana, Spain | |||
1767636 | 1767636 | 2022-07-03 | Spain | C. Valenciana | 1477267 | 9507 | 0 | 39.484 | -0.7533 | 2022-07-04 04:20:54 | C. Valenciana, Spain | |||
3365622 | 3365622 | 2022-07-02 | Spain | C. Valenciana | 1477267 | 9507 | 0 | 39.484 | -0.7533 | 2022-07-03 04:20:59 | C. Valenciana, Spain | |||
593951 | 593951 | 2022-07-01 | Spain | C. Valenciana | 1477267 | 9507 | 0 | 39.484 | -0.7533 | 2022-07-02 04:21:16 | C. Valenciana, Spain | |||
3940352 | 3940352 | 2022-06-30 | Spain | C. Valenciana | 1468478 | 9490 | 0 | 39.484 | -0.7533 | 2022-07-01 04:21:10 | C. Valenciana, Spain | |||
2490310 | 2490310 | 2022-06-29 | Spain | C. Valenciana | 1468478 | 9490 | 0 | 39.484 | -0.7533 | 2022-06-30 04:21:01 | C. Valenciana, Spain | |||
2239692 | 2239692 | 2022-06-28 | Spain | C. Valenciana | 1468478 | 9490 | 0 | 39.484 | -0.7533 | 2022-06-29 04:20:59 | C. Valenciana, Spain | |||
2147934 | 2147934 | 2022-06-27 | Spain | C. Valenciana | 1463999 | 9486 | 0 | 39.484 | -0.7533 | 2022-06-28 04:20:58 | C. Valenciana, Spain | |||
475735 | 475735 | 2022-06-26 | Spain | C. Valenciana | 1463999 | 9486 | 0 | 39.484 | -0.7533 | 2022-06-27 04:21:00 | C. Valenciana, Spain | |||
939110 | 939110 | 2022-06-25 | Spain | C. Valenciana | 1463999 | 9486 | 0 | 39.484 | -0.7533 | 2022-06-26 04:21:02 | C. Valenciana, Spain | |||
3346930 | 3346930 | 2022-06-24 | Spain | C. Valenciana | 1463999 | 9486 | 0 | 39.484 | -0.7533 | 2022-06-25 04:20:57 | C. Valenciana, Spain | |||
1648671 | 1648671 | 2022-06-23 | Spain | C. Valenciana | 1459187 | 9467 | 0 | 39.484 | -0.7533 | 2022-06-24 04:20:58 | C. Valenciana, Spain | |||
2187906 | 2187906 | 2022-06-22 | Spain | C. Valenciana | 1459187 | 9467 | 0 | 39.484 | -0.7533 | 2022-06-23 04:20:55 | C. Valenciana, Spain | |||
166337 | 166337 | 2022-06-21 | Spain | C. Valenciana | 1459187 | 9467 | 0 | 39.484 | -0.7533 | 2022-06-22 04:20:54 | C. Valenciana, Spain | |||
1763620 | 1763620 | 2022-06-20 | Spain | C. Valenciana | 1455334 | 9458 | 0 | 39.484 | -0.7533 | 2022-06-21 04:20:56 | C. Valenciana, Spain | |||
3269806 | 3269806 | 2022-06-19 | Spain | C. Valenciana | 1455334 | 9458 | 0 | 39.484 | -0.7533 | 2022-06-20 04:21:01 | C. Valenciana, Spain | |||
3397718 | 3397718 | 2022-06-18 | Spain | C. Valenciana | 1455334 | 9458 | 0 | 39.484 | -0.7533 | 2022-06-19 04:20:51 | C. Valenciana, Spain | |||
2311595 | 2311595 | 2022-06-17 | Spain | C. Valenciana | 1455334 | 9458 | 0 | 39.484 | -0.7533 | 2022-06-18 04:21:10 | C. Valenciana, Spain | |||
559099 | 559099 | 2022-06-16 | Spain | C. Valenciana | 1451846 | 9442 | 0 | 39.484 | -0.7533 | 2022-06-17 04:20:56 | C. Valenciana, Spain | |||
3982901 | 3982901 | 2022-06-15 | Spain | C. Valenciana | 1451846 | 9442 | 0 | 39.484 | -0.7533 | 2022-06-16 04:20:55 | C. Valenciana, Spain | |||
947142 | 947142 | 2022-06-14 | Spain | C. Valenciana | 1451846 | 9442 | 0 | 39.484 | -0.7533 | 2022-06-15 04:20:54 | C. Valenciana, Spain | |||
2979550 | 2979550 | 2022-06-13 | Spain | C. Valenciana | 1448702 | 9437 | 0 | 39.484 | -0.7533 | 2022-06-14 04:20:52 | C. Valenciana, 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]);