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 = "Galicia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2463090 | 2463090 | 2021-09-14 | Spain | Galicia | 185431 | 2605 | 0 | 42.5751 | -8.1339 | 2021-09-15 03:22:37 | Galicia, Spain | |||
1385929 | 1385929 | 2021-09-13 | Spain | Galicia | 185335 | 2601 | 0 | 42.5751 | -8.1339 | 2021-09-14 04:21:41 | Galicia, Spain | |||
1885298 | 1885298 | 2021-09-12 | Spain | Galicia | 184929 | 2595 | 0 | 42.5751 | -8.1339 | 2021-09-13 04:21:15 | Galicia, Spain | |||
3806201 | 3806201 | 2021-09-11 | Spain | Galicia | 184929 | 2595 | 0 | 42.5751 | -8.1339 | 2021-09-12 04:21:13 | Galicia, Spain | |||
3449141 | 3449141 | 2021-09-10 | Spain | Galicia | 184929 | 2595 | 0 | 42.5751 | -8.1339 | 2021-09-11 04:21:30 | Galicia, Spain | |||
1263087 | 1263087 | 2021-09-09 | Spain | Galicia | 184757 | 2592 | 0 | 42.5751 | -8.1339 | 2021-09-10 04:21:20 | Galicia, Spain | |||
2279457 | 2279457 | 2021-09-08 | Spain | Galicia | 184586 | 2589 | 0 | 42.5751 | -8.1339 | 2021-09-09 04:21:27 | Galicia, Spain | |||
642236 | 642236 | 2021-09-07 | Spain | Galicia | 184389 | 2587 | 0 | 42.5751 | -8.1339 | 2021-09-08 04:21:31 | Galicia, Spain | |||
3194299 | 3194299 | 2021-09-06 | Spain | Galicia | 184211 | 2581 | 0 | 42.5751 | -8.1339 | 2021-09-07 04:21:35 | Galicia, Spain | |||
3281167 | 3281167 | 2021-09-05 | Spain | Galicia | 183498 | 2574 | 0 | 42.5751 | -8.1339 | 2021-09-06 04:21:22 | Galicia, Spain | |||
249581 | 249581 | 2021-09-04 | Spain | Galicia | 183498 | 2574 | 0 | 42.5751 | -8.1339 | 2021-09-05 04:21:33 | Galicia, Spain | |||
3974862 | 3974862 | 2021-09-03 | Spain | Galicia | 183498 | 2574 | 0 | 42.5751 | -8.1339 | 2021-09-04 04:21:28 | Galicia, Spain | |||
178324 | 178324 | 2021-09-02 | Spain | Galicia | 183247 | 2571 | 0 | 42.5751 | -8.1339 | 2021-09-03 04:21:20 | Galicia, Spain | |||
67359 | 67359 | 2021-09-01 | Spain | Galicia | 182907 | 2567 | 0 | 42.5751 | -8.1339 | 2021-09-02 04:21:15 | Galicia, Spain | |||
2068201 | 2068201 | 2021-08-31 | Spain | Galicia | 182549 | 2563 | 0 | 42.5751 | -8.1339 | 2021-09-01 04:21:38 | Galicia, Spain | |||
1775655 | 1775655 | 2021-08-30 | Spain | Galicia | 182234 | 2561 | 0 | 42.5751 | -8.1339 | 2021-08-31 04:21:46 | Galicia, Spain | |||
3892229 | 3892229 | 2021-08-29 | Spain | Galicia | 181085 | 2550 | 0 | 42.5751 | -8.1339 | 2021-08-30 04:21:23 | Galicia, Spain | |||
2793332 | 2793332 | 2021-08-28 | Spain | Galicia | 181085 | 2550 | 0 | 42.5751 | -8.1339 | 2021-08-29 04:21:14 | Galicia, Spain | |||
2923491 | 2923491 | 2021-08-27 | Spain | Galicia | 181085 | 2550 | 0 | 42.5751 | -8.1339 | 2021-08-28 04:21:28 | Galicia, Spain | |||
1596505 | 1596505 | 2021-08-26 | Spain | Galicia | 180422 | 2539 | 0 | 42.5751 | -8.1339 | 2021-08-27 04:21:37 | Galicia, Spain | |||
32714 | 32714 | 2021-08-25 | Spain | Galicia | 179884 | 2537 | 0 | 42.5751 | -8.1339 | 2021-08-26 04:21:28 | Galicia, Spain | |||
3105753 | 3105753 | 2021-08-24 | Spain | Galicia | 179283 | 2535 | 0 | 42.5751 | -8.1339 | 2021-08-25 04:21:41 | Galicia, Spain | |||
3165924 | 3165924 | 2021-08-23 | Spain | Galicia | 178783 | 2528 | 0 | 42.5751 | -8.1339 | 2021-08-24 04:21:19 | Galicia, Spain | |||
2175851 | 2175851 | 2021-08-22 | Spain | Galicia | 177071 | 2519 | 0 | 42.5751 | -8.1339 | 2021-08-23 04:21:27 | Galicia, Spain | |||
3555947 | 3555947 | 2021-08-21 | Spain | Galicia | 177071 | 2519 | 0 | 42.5751 | -8.1339 | 2021-08-22 04:21:29 | Galicia, Spain | |||
1854289 | 1854289 | 2021-08-20 | Spain | Galicia | 177071 | 2519 | 0 | 42.5751 | -8.1339 | 2021-08-21 04:21:38 | Galicia, Spain | |||
511996 | 511996 | 2021-08-19 | Spain | Galicia | 176326 | 2516 | 0 | 42.5751 | -8.1339 | 2021-08-20 04:21:33 | Galicia, Spain | |||
2518475 | 2518475 | 2021-08-18 | Spain | Galicia | 175726 | 2511 | 0 | 42.5751 | -8.1339 | 2021-08-19 04:21:15 | Galicia, Spain | |||
245567 | 245567 | 2021-08-17 | Spain | Galicia | 175072 | 2505 | 0 | 42.5751 | -8.1339 | 2021-08-18 04:21:35 | Galicia, Spain | |||
1604530 | 1604530 | 2021-08-16 | Spain | Galicia | 174534 | 2503 | 0 | 42.5751 | -8.1339 | 2021-08-17 04:21:49 | Galicia, Spain | |||
103624 | 103624 | 2021-08-15 | Spain | Galicia | 172612 | 2495 | 0 | 42.5751 | -8.1339 | 2021-08-16 04:21:31 | Galicia, Spain | |||
507982 | 507982 | 2021-08-14 | Spain | Galicia | 172612 | 2495 | 0 | 42.5751 | -8.1339 | 2021-08-15 04:21:41 | Galicia, Spain | |||
1483854 | 1483854 | 2021-08-13 | Spain | Galicia | 172612 | 2495 | 0 | 42.5751 | -8.1339 | 2021-08-14 04:21:25 | Galicia, Spain | |||
2899984 | 2899984 | 2021-08-12 | Spain | Galicia | 171757 | 2491 | 0 | 42.5751 | -8.1339 | 2021-08-13 04:21:24 | Galicia, Spain | |||
1342588 | 1342588 | 2021-08-11 | Spain | Galicia | 170949 | 2486 | 0 | 42.5751 | -8.1339 | 2021-08-12 04:21:25 | Galicia, Spain | |||
2351735 | 2351735 | 2021-08-10 | Spain | Galicia | 170177 | 2481 | 0 | 42.5751 | -8.1339 | 2021-08-11 04:21:58 | Galicia, Spain | |||
650264 | 650264 | 2021-08-09 | Spain | Galicia | 169229 | 2480 | 0 | 42.5751 | -8.1339 | 2021-08-10 04:21:27 | Galicia, Spain | |||
589926 | 589926 | 2021-08-08 | Spain | Galicia | 166418 | 2470 | 0 | 42.5751 | -8.1339 | 2021-08-09 04:21:24 | Galicia, Spain | |||
2203938 | 2203938 | 2021-08-07 | Spain | Galicia | 166418 | 2470 | 0 | 42.5751 | -8.1339 | 2021-08-08 04:21:33 | Galicia, Spain | |||
1117888 | 1117888 | 2021-08-06 | Spain | Galicia | 166418 | 2470 | 0 | 42.5751 | -8.1339 | 2021-08-07 04:21:30 | Galicia, Spain | |||
1956825 | 1956825 | 2021-08-05 | Spain | Galicia | 165304 | 2468 | 0 | 42.5751 | -8.1339 | 2021-08-06 04:21:18 | Galicia, Spain | |||
332204 | 332204 | 2021-08-04 | Spain | Galicia | 164131 | 2465 | 9204 | 152462 | 42.5751 | -8.1339 | 2021-08-05 04:21:51 | Galicia, Spain | ||
3468475 | 3468475 | 2021-08-03 | Spain | Galicia | 162971 | 2461 | 9204 | 151306 | 42.5751 | -8.1339 | 2021-08-04 04:21:25 | Galicia, Spain | ||
3683749 | 3683749 | 2021-08-02 | Spain | Galicia | 161993 | 2453 | 9204 | 150336 | 42.5751 | -8.1339 | 2021-08-03 04:21:39 | Galicia, Spain | ||
3015648 | 3015648 | 2021-08-01 | Spain | Galicia | 158626 | 2444 | 9204 | 146978 | 42.5751 | -8.1339 | 2021-08-02 04:21:36 | Galicia, Spain | ||
3904271 | 3904271 | 2021-07-31 | Spain | Galicia | 158626 | 2444 | 9204 | 146978 | 42.5751 | -8.1339 | 2021-08-01 04:21:50 | Galicia, Spain | ||
3296476 | 3296476 | 2021-07-30 | Spain | Galicia | 158626 | 2444 | 9204 | 146978 | 42.5751 | -8.1339 | 2021-07-31 04:21:35 | Galicia, Spain | ||
3385687 | 3385687 | 2021-07-29 | Spain | Galicia | 157306 | 2442 | 9204 | 145660 | 42.5751 | -8.1339 | 2021-07-30 04:21:34 | Galicia, Spain | ||
408592 | 408592 | 2021-07-28 | Spain | Galicia | 156041 | 2440 | 9204 | 144397 | 42.5751 | -8.1339 | 2021-07-29 04:21:33 | Galicia, Spain | ||
1306453 | 1306453 | 2021-07-27 | Spain | Galicia | 154726 | 2439 | 9204 | 143083 | 42.5751 | -8.1339 | 2021-07-28 04:21:39 | Galicia, Spain | ||
3218596 | 3218596 | 2021-07-26 | Spain | Galicia | 153266 | 2436 | 9204 | 141626 | 42.5751 | -8.1339 | 2021-07-27 04:21:18 | Galicia, Spain | ||
1378805 | 1378805 | 2021-07-25 | Spain | Galicia | 149190 | 2431 | 9204 | 137555 | 42.5751 | -8.1339 | 2021-07-26 04:21:28 | Galicia, Spain | ||
1330545 | 1330545 | 2021-07-24 | Spain | Galicia | 149190 | 2431 | 9204 | 137555 | 42.5751 | -8.1339 | 2021-07-25 04:22:12 | Galicia, Spain | ||
3137849 | 3137849 | 2021-07-23 | Spain | Galicia | 149190 | 2431 | 9204 | 137555 | 42.5751 | -8.1339 | 2021-07-24 00:21:36 | Galicia, Spain | ||
3476609 | 3476609 | 2021-07-22 | Spain | Galicia | 147680 | 2430 | 9204 | 136046 | 42.5751 | -8.1339 | 2021-07-23 04:21:29 | Galicia, Spain | ||
3331828 | 3331828 | 2021-07-21 | Spain | Galicia | 146053 | 2430 | 9204 | 134419 | 42.5751 | -8.1339 | 2021-07-22 04:21:19 | Galicia, Spain | ||
2371809 | 2371809 | 2021-07-20 | Spain | Galicia | 144609 | 2430 | 9204 | 132975 | 42.5751 | -8.1339 | 2021-07-21 04:21:40 | Galicia, Spain | ||
483888 | 483888 | 2021-07-19 | Spain | Galicia | 143265 | 2429 | 9204 | 131632 | 42.5751 | -8.1339 | 2021-07-20 04:21:48 | Galicia, Spain | ||
2674111 | 2674111 | 2021-07-18 | Spain | Galicia | 139652 | 2428 | 9204 | 128020 | 42.5751 | -8.1339 | 2021-07-19 04:21:24 | Galicia, Spain | ||
3706423 | 3706423 | 2021-07-17 | Spain | Galicia | 139652 | 2428 | 9204 | 128020 | 42.5751 | -8.1339 | 2021-07-18 04:22:07 | Galicia, Spain | ||
2947654 | 2947654 | 2021-07-16 | Spain | Galicia | 139652 | 2428 | 9204 | 128020 | 42.5751 | -8.1339 | 2021-07-17 04:22:22 | Galicia, Spain | ||
296310 | 296310 | 2021-07-15 | Spain | Galicia | 138214 | 2428 | 9204 | 126582 | 42.5751 | -8.1339 | 2021-07-16 04:21:22 | Galicia, Spain | ||
3632255 | 3632255 | 2021-07-14 | Spain | Galicia | 136972 | 2426 | 9204 | 125342 | 42.5751 | -8.1339 | 2021-07-15 04:21:48 | Galicia, Spain | ||
579130 | 579130 | 2021-07-13 | Spain | Galicia | 135848 | 2426 | 9204 | 124218 | 42.5751 | -8.1339 | 2021-07-14 04:21:35 | Galicia, Spain | ||
3741379 | 3741379 | 2021-07-12 | Spain | Galicia | 135065 | 2426 | 9204 | 123435 | 42.5751 | -8.1339 | 2021-07-13 04:21:18 | Galicia, Spain | ||
3659892 | 3659892 | 2021-07-11 | Spain | Galicia | 133014 | 2426 | 9204 | 121384 | 42.5751 | -8.1339 | 2021-07-12 04:21:34 | Galicia, Spain | ||
626176 | 626176 | 2021-07-10 | Spain | Galicia | 133014 | 2426 | 9204 | 121384 | 42.5751 | -8.1339 | 2021-07-11 04:21:43 | Galicia, Spain | ||
829895 | 829895 | 2021-07-09 | Spain | Galicia | 133014 | 2426 | 9204 | 121384 | 42.5751 | -8.1339 | 2021-07-10 04:21:25 | Galicia, Spain | ||
778659 | 778659 | 2021-07-08 | Spain | Galicia | 132432 | 2426 | 9204 | 120802 | 42.5751 | -8.1339 | 2021-07-09 04:21:21 | Galicia, Spain | ||
1440881 | 1440881 | 2021-07-07 | Spain | Galicia | 131933 | 2425 | 9204 | 120304 | 42.5751 | -8.1339 | 2021-07-08 04:21:26 | Galicia, Spain | ||
2693986 | 2693986 | 2021-07-06 | Spain | Galicia | 131519 | 2424 | 9204 | 119891 | 42.5751 | -8.1339 | 2021-07-07 04:21:20 | Galicia, Spain | ||
1932735 | 1932735 | 2021-07-05 | Spain | Galicia | 131179 | 2424 | 9204 | 119551 | 42.5751 | -8.1339 | 2021-07-06 04:21:32 | Galicia, Spain | ||
1165466 | 1165466 | 2021-07-04 | Spain | Galicia | 130493 | 2423 | 9204 | 118866 | 42.5751 | -8.1339 | 2021-07-05 04:21:28 | Galicia, Spain | ||
1495900 | 1495900 | 2021-07-03 | Spain | Galicia | 130493 | 2423 | 9204 | 118866 | 42.5751 | -8.1339 | 2021-07-04 04:21:38 | Galicia, Spain | ||
2072215 | 2072215 | 2021-07-02 | Spain | Galicia | 130493 | 2423 | 9204 | 118866 | 42.5751 | -8.1339 | 2021-07-03 04:21:37 | Galicia, Spain | ||
2765231 | 2765231 | 2021-07-01 | Spain | Galicia | 130190 | 2423 | 9204 | 118563 | 42.5751 | -8.1339 | 2021-07-02 04:21:47 | Galicia, Spain | ||
1893439 | 1893439 | 2021-06-30 | Spain | Galicia | 129914 | 2423 | 9204 | 118287 | 42.5751 | -8.1339 | 2021-07-01 04:21:19 | Galicia, Spain | ||
400562 | 400562 | 2021-06-29 | Spain | Galicia | 129735 | 2423 | 9204 | 118108 | 42.5751 | -8.1339 | 2021-06-30 04:21:41 | Galicia, Spain | ||
3125805 | 3125805 | 2021-06-28 | Spain | Galicia | 129571 | 2422 | 9204 | 117945 | 42.5751 | -8.1339 | 2021-06-29 04:21:28 | Galicia, Spain | ||
2590300 | 2590300 | 2021-06-27 | Spain | Galicia | 129180 | 2422 | 9204 | 117554 | 42.5751 | -8.1339 | 2021-06-28 04:21:29 | Galicia, Spain | ||
3958804 | 3958804 | 2021-06-26 | Spain | Galicia | 129180 | 2422 | 9204 | 117554 | 42.5751 | -8.1339 | 2021-06-27 04:21:39 | Galicia, Spain | ||
1712623 | 1712623 | 2021-06-25 | Spain | Galicia | 129180 | 2422 | 9204 | 117554 | 42.5751 | -8.1339 | 2021-06-26 04:21:43 | Galicia, Spain | ||
2295748 | 2295748 | 2021-06-24 | Spain | Galicia | 129039 | 2421 | 9204 | 117414 | 42.5751 | -8.1339 | 2021-06-25 04:21:33 | Galicia, Spain | ||
2423188 | 2423188 | 2021-06-23 | Spain | Galicia | 128920 | 2421 | 9204 | 117295 | 42.5751 | -8.1339 | 2021-06-24 04:21:55 | Galicia, Spain | ||
563265 | 563265 | 2021-06-22 | Spain | Galicia | 128834 | 2421 | 9204 | 117209 | 42.5751 | -8.1339 | 2021-06-23 04:21:46 | Galicia, Spain | ||
3358967 | 3358967 | 2021-06-21 | Spain | Galicia | 128734 | 2421 | 9204 | 117109 | 42.5751 | -8.1339 | 2021-06-22 04:21:34 | Galicia, Spain | ||
2884666 | 2884666 | 2021-06-20 | Spain | Galicia | 128511 | 2418 | 9204 | 116889 | 42.5751 | -8.1339 | 2021-06-21 04:21:41 | Galicia, Spain | ||
107749 | 107749 | 2021-06-19 | Spain | Galicia | 128511 | 2418 | 9204 | 116889 | 42.5751 | -8.1339 | 2021-06-20 04:21:48 | Galicia, Spain | ||
1125892 | 1125892 | 2021-06-18 | Spain | Galicia | 128511 | 2418 | 9204 | 116889 | 42.5751 | -8.1339 | 2021-06-19 04:22:33 | Galicia, Spain | ||
2911470 | 2911470 | 2021-06-17 | Spain | Galicia | 128384 | 2417 | 9204 | 116763 | 42.5751 | -8.1339 | 2021-06-18 04:22:16 | Galicia, Spain | ||
3030586 | 3030586 | 2021-06-16 | Spain | Galicia | 128291 | 2417 | 9204 | 116670 | 42.5751 | -8.1339 | 2021-06-17 04:22:36 | Galicia, Spain | ||
2339692 | 2339692 | 2021-06-15 | Spain | Galicia | 128220 | 2417 | 9204 | 116599 | 42.5751 | -8.1339 | 2021-06-16 04:22:32 | Galicia, Spain | ||
1564388 | 1564388 | 2021-06-14 | Spain | Galicia | 128151 | 2417 | 9204 | 116530 | 42.5751 | -8.1339 | 2021-06-15 04:22:22 | Galicia, Spain | ||
3381671 | 3381671 | 2021-06-13 | Spain | Galicia | 127925 | 2415 | 9204 | 116306 | 42.5751 | -8.1339 | 2021-06-14 04:22:46 | Galicia, Spain | ||
1736805 | 1736805 | 2021-06-12 | Spain | Galicia | 127925 | 2415 | 9204 | 116306 | 42.5751 | -8.1339 | 2021-06-13 04:22:44 | Galicia, Spain | ||
3970846 | 3970846 | 2021-06-11 | Spain | Galicia | 127925 | 2415 | 9204 | 116306 | 42.5751 | -8.1339 | 2021-06-12 04:22:22 | Galicia, Spain | ||
2717268 | 2717268 | 2021-06-10 | Spain | Galicia | 127821 | 2415 | 9204 | 116202 | 42.5751 | -8.1339 | 2021-06-11 04:23:20 | Galicia, Spain | ||
523153 | 523153 | 2021-06-09 | Spain | Galicia | 127731 | 2414 | 9204 | 116113 | 42.5751 | -8.1339 | 2021-06-10 04:23:17 | Galicia, Spain | ||
3472593 | 3472593 | 2021-06-08 | Spain | Galicia | 127656 | 2414 | 9204 | 116038 | 42.5751 | -8.1339 | 2021-06-09 04:23:31 | Galicia, Spain | ||
3145877 | 3145877 | 2021-06-07 | Spain | Galicia | 127561 | 2413 | 9204 | 115944 | 42.5751 | -8.1339 | 2021-06-08 04:22:35 | Galicia, 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]);