johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where combined_key = "Extremadura, Spain" and country_or_region = "Spain" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- Extremadura 860
country_or_region 1
- Spain · 860 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
710752 | 710752 | 2022-11-01 | Spain | Extremadura | 305532 | 2648 | 0 | 39.4937 | -6.0679 | 2022-11-02 04:22:09 | Extremadura, Spain | |||
714764 | 714764 | 2021-11-12 | Spain | Extremadura | 103642 | 1990 | 0 | 39.4937 | -6.0679 | 2021-11-13 04:21:38 | Extremadura, Spain | |||
718784 | 718784 | 2022-12-04 | Spain | Extremadura | 306951 | 2664 | 0 | 39.4937 | -6.0679 | 2022-12-05 04:20:58 | Extremadura, Spain | |||
722796 | 722796 | 2021-11-20 | Spain | Extremadura | 104002 | 1992 | 0 | 39.4937 | -6.0679 | 2021-11-21 04:22:13 | Extremadura, Spain | |||
730826 | 730826 | 2021-12-27 | Spain | Extremadura | 121327 | 2011 | 0 | 39.4937 | -6.0679 | 2021-12-28 04:21:47 | Extremadura, Spain | |||
746643 | 746643 | 2022-04-23 | Spain | Extremadura | 258511 | 2306 | 0 | 39.4937 | -6.0679 | 2022-04-24 04:20:56 | Extremadura, Spain | |||
758626 | 758626 | 2021-11-26 | Spain | Extremadura | 104409 | 1995 | 0 | 39.4937 | -6.0679 | 2021-11-27 04:22:45 | Extremadura, Spain | |||
770647 | 770647 | 2021-10-23 | Spain | Extremadura | 103110 | 1992 | 0 | 39.4937 | -6.0679 | 2021-10-24 04:21:22 | Extremadura, Spain | |||
782689 | 782689 | 2021-12-13 | Spain | Extremadura | 106977 | 2001 | 0 | 39.4937 | -6.0679 | 2021-12-14 04:22:38 | Extremadura, Spain | |||
794716 | 794716 | 2022-10-24 | Spain | Extremadura | 305130 | 2645 | 0 | 39.4937 | -6.0679 | 2022-10-25 04:21:53 | Extremadura, Spain | |||
798728 | 798728 | 2021-12-22 | Spain | Extremadura | 112670 | 2008 | 0 | 39.4937 | -6.0679 | 2021-12-23 04:21:21 | Extremadura, Spain | |||
809873 | 809873 | 2021-09-20 | Spain | Extremadura | 102057 | 1963 | 0 | 39.4937 | -6.0679 | 2021-09-21 04:21:26 | Extremadura, Spain | |||
833929 | 833929 | 2022-12-02 | Spain | Extremadura | 306951 | 2664 | 0 | 39.4937 | -6.0679 | 2022-12-03 04:21:02 | Extremadura, Spain | |||
849901 | 849901 | 2022-11-02 | Spain | Extremadura | 305532 | 2648 | 0 | 39.4937 | -6.0679 | 2022-11-03 04:22:05 | Extremadura, Spain | |||
853917 | 853917 | 2022-09-30 | Spain | Extremadura | 303713 | 2637 | 0 | 39.4937 | -6.0679 | 2022-10-01 04:23:01 | Extremadura, Spain | |||
869101 | 869101 | 2022-12-11 | Spain | Extremadura | 307199 | 2666 | 0 | 39.4937 | -6.0679 | 2022-12-12 04:21:01 | Extremadura, Spain | |||
875556 | 875556 | 2020-05-24 | Spain | Extremadura | 3047 | 506 | 0 | 2541 | 39.4937 | -6.0679 | 2020-05-25 02:32:44 | Extremadura, Spain | ||
876563 | 876563 | 2022-03-27 | Spain | Extremadura | 250928 | 2269 | 0 | 39.4937 | -6.0679 | 2022-03-28 04:20:33 | Extremadura, Spain | |||
880580 | 880580 | 2022-08-05 | Spain | Extremadura | 298749 | 2566 | 0 | 39.4937 | -6.0679 | 2022-08-06 04:20:56 | Extremadura, Spain | |||
896447 | 896447 | 2022-07-24 | Spain | Extremadura | 295788 | 2535 | 0 | 39.4937 | -6.0679 | 2022-07-25 04:20:51 | Extremadura, Spain | |||
900463 | 900463 | 2022-07-22 | Spain | Extremadura | 295788 | 2535 | 0 | 39.4937 | -6.0679 | 2022-07-23 04:20:53 | Extremadura, Spain | |||
904477 | 904477 | 2021-11-24 | Spain | Extremadura | 104269 | 1994 | 0 | 39.4937 | -6.0679 | 2021-11-25 04:22:33 | Extremadura, Spain | |||
912510 | 912510 | 2022-10-29 | Spain | Extremadura | 305532 | 2648 | 0 | 39.4937 | -6.0679 | 2022-10-30 04:22:14 | Extremadura, Spain | |||
919983 | 919983 | 2022-03-08 | Spain | Extremadura | 239555 | 2244 | 0 | 39.4937 | -6.0679 | 2022-03-09 04:20:59 | Extremadura, Spain | |||
935099 | 935099 | 2021-10-16 | Spain | Extremadura | 102908 | 2000 | 0 | 39.4937 | -6.0679 | 2021-10-17 04:21:29 | Extremadura, Spain | |||
939117 | 939117 | 2022-06-25 | Spain | Extremadura | 283019 | 2449 | 0 | 39.4937 | -6.0679 | 2022-06-26 04:21:02 | Extremadura, Spain | |||
943132 | 943132 | 2022-02-28 | Spain | Extremadura | 233837 | 2225 | 0 | 39.4937 | -6.0679 | 2022-03-01 04:21:09 | Extremadura, Spain | |||
947149 | 947149 | 2022-06-14 | Spain | Extremadura | 279130 | 2426 | 0 | 39.4937 | -6.0679 | 2022-06-15 04:20:54 | Extremadura, Spain | |||
951164 | 951164 | 2022-03-12 | Spain | Extremadura | 241992 | 2249 | 0 | 39.4937 | -6.0679 | 2022-03-13 04:20:49 | Extremadura, Spain | |||
959195 | 959195 | 2022-07-19 | Spain | Extremadura | 294664 | 2518 | 0 | 39.4937 | -6.0679 | 2022-07-20 04:20:59 | Extremadura, Spain | |||
963211 | 963211 | 2022-09-09 | Spain | Extremadura | 302530 | 2621 | 0 | 39.4937 | -6.0679 | 2022-09-10 04:21:10 | Extremadura, Spain | |||
971219 | 971219 | 2022-06-01 | Spain | Extremadura | 275553 | 2404 | 0 | 39.4937 | -6.0679 | 2022-06-02 05:20:39 | Extremadura, Spain | |||
979247 | 979247 | 2022-02-01 | Spain | Extremadura | 213256 | 2136 | 0 | 39.4937 | -6.0679 | 2022-02-02 04:21:09 | Extremadura, Spain | |||
987277 | 987277 | 2021-10-04 | Spain | Extremadura | 102557 | 1987 | 0 | 39.4937 | -6.0679 | 2021-10-05 04:21:27 | Extremadura, Spain | |||
991294 | 991294 | 2022-08-16 | Spain | Extremadura | 299996 | 2592 | 0 | 39.4937 | -6.0679 | 2022-08-17 04:20:59 | Extremadura, Spain | |||
997747 | 997747 | 2020-05-23 | Spain | Extremadura | 3048 | 507 | 0 | 2541 | 39.4937 | -6.0679 | 2020-05-24 02:32:43 | Extremadura, Spain | ||
1014632 | 1014632 | 2021-11-21 | Spain | Extremadura | 104002 | 1992 | 0 | 39.4937 | -6.0679 | 2021-11-22 04:22:20 | Extremadura, Spain | |||
1018652 | 1018652 | 2022-12-24 | Spain | Extremadura | 307939 | 2671 | 0 | 39.4937 | -6.0679 | 2022-12-25 04:21:04 | Extremadura, Spain | |||
1022668 | 1022668 | 2022-11-04 | Spain | Extremadura | 305800 | 2652 | 0 | 39.4937 | -6.0679 | 2022-11-05 04:21:52 | Extremadura, Spain | |||
1030674 | 1030674 | 2021-12-06 | Spain | Extremadura | 105208 | 1999 | 0 | 39.4937 | -6.0679 | 2021-12-07 04:22:34 | Extremadura, Spain | |||
1050140 | 1050140 | 2022-11-06 | Spain | Extremadura | 305800 | 2652 | 0 | 39.4937 | -6.0679 | 2022-11-07 04:21:26 | Extremadura, Spain | |||
1058148 | 1058148 | 2022-02-23 | Spain | Extremadura | 232940 | 2220 | 0 | 39.4937 | -6.0679 | 2022-02-24 04:21:14 | Extremadura, Spain | |||
1066177 | 1066177 | 2022-07-28 | Spain | Extremadura | 296622 | 2545 | 0 | 39.4937 | -6.0679 | 2022-07-29 04:20:45 | Extremadura, Spain | |||
1070193 | 1070193 | 2022-08-07 | Spain | Extremadura | 298749 | 2566 | 0 | 39.4937 | -6.0679 | 2022-08-08 04:21:08 | Extremadura, Spain | |||
1074211 | 1074211 | 2022-12-28 | Spain | Extremadura | 307939 | 2671 | 0 | 39.4937 | -6.0679 | 2022-12-29 04:21:01 | Extremadura, Spain | |||
1078223 | 1078223 | 2021-12-09 | Spain | Extremadura | 106021 | 2000 | 0 | 39.4937 | -6.0679 | 2021-12-10 04:22:28 | Extremadura, Spain | |||
1086375 | 1086375 | 2022-08-09 | Spain | Extremadura | 299248 | 2578 | 0 | 39.4937 | -6.0679 | 2022-08-10 04:20:57 | Extremadura, Spain | |||
1098418 | 1098418 | 2022-08-03 | Spain | Extremadura | 298163 | 2555 | 0 | 39.4937 | -6.0679 | 2022-08-04 04:20:58 | Extremadura, Spain | |||
1104876 | 1104876 | 2020-05-25 | Spain | Extremadura | 2952 | 506 | 0 | 2446 | 39.4937 | -6.0679 | 2020-05-26 02:32:35 | Extremadura, Spain | ||
1109874 | 1109874 | 2022-05-21 | Spain | Extremadura | 272427 | 2369 | 0 | 39.4937 | -6.0679 | 2022-05-22 04:20:52 | Extremadura, Spain | |||
1113888 | 1113888 | 2022-01-11 | Spain | Extremadura | 163115 | 2041 | 0 | 39.4937 | -6.0679 | 2022-01-12 04:21:44 | Extremadura, Spain | |||
1117887 | 1117887 | 2021-08-06 | Spain | Extremadura | 91365 | 1830 | 0 | 39.4937 | -6.0679 | 2021-08-07 04:21:30 | Extremadura, Spain | |||
1141211 | 1141211 | 2022-01-23 | Spain | Extremadura | 192367 | 2083 | 0 | 39.4937 | -6.0679 | 2022-01-24 04:21:12 | Extremadura, Spain | |||
1145227 | 1145227 | 2021-12-01 | Spain | Extremadura | 104938 | 1998 | 0 | 39.4937 | -6.0679 | 2021-12-02 04:22:37 | Extremadura, Spain | |||
1149247 | 1149247 | 2022-12-12 | Spain | Extremadura | 307199 | 2666 | 0 | 39.4937 | -6.0679 | 2022-12-13 04:21:01 | Extremadura, Spain | |||
1157451 | 1157451 | 2022-04-29 | Spain | Extremadura | 261981 | 2319 | 0 | 39.4937 | -6.0679 | 2022-04-30 04:21:05 | Extremadura, Spain | |||
1161468 | 1161468 | 2022-08-18 | Spain | Extremadura | 299996 | 2592 | 0 | 39.4937 | -6.0679 | 2022-08-19 04:20:54 | Extremadura, Spain | |||
1169498 | 1169498 | 2022-05-20 | Spain | Extremadura | 270744 | 2360 | 0 | 39.4937 | -6.0679 | 2022-05-21 04:20:58 | Extremadura, Spain | |||
1185045 | 1185045 | 2022-05-18 | Spain | Extremadura | 270744 | 2360 | 0 | 39.4937 | -6.0679 | 2022-05-19 04:20:54 | Extremadura, Spain | |||
1200107 | 1200107 | 2022-07-06 | Spain | Extremadura | 288654 | 2466 | 0 | 39.4937 | -6.0679 | 2022-07-07 04:20:55 | Extremadura, Spain | |||
1211852 | 1211852 | 2022-07-11 | Spain | Extremadura | 290792 | 2478 | 0 | 39.4937 | -6.0679 | 2022-07-12 04:20:51 | Extremadura, Spain | |||
1215866 | 1215866 | 2022-01-08 | Spain | Extremadura | 151836 | 2029 | 0 | 39.4937 | -6.0679 | 2022-01-09 04:21:46 | Extremadura, Spain | |||
1223897 | 1223897 | 2022-04-14 | Spain | Extremadura | 255370 | 2292 | 0 | 39.4937 | -6.0679 | 2022-04-15 04:20:57 | Extremadura, Spain | |||
1227912 | 1227912 | 2022-01-24 | Spain | Extremadura | 197589 | 2100 | 0 | 39.4937 | -6.0679 | 2022-01-25 04:21:05 | Extremadura, Spain | |||
1231928 | 1231928 | 2021-11-28 | Spain | Extremadura | 104409 | 1995 | 0 | 39.4937 | -6.0679 | 2021-11-29 04:22:30 | Extremadura, Spain | |||
1235944 | 1235944 | 2021-09-27 | Spain | Extremadura | 102284 | 1977 | 0 | 39.4937 | -6.0679 | 2021-09-28 04:21:28 | Extremadura, Spain | |||
1239963 | 1239963 | 2022-11-28 | Spain | Extremadura | 306732 | 2660 | 0 | 39.4937 | -6.0679 | 2022-11-29 04:21:05 | Extremadura, Spain | |||
1251057 | 1251057 | 2022-08-23 | Spain | Extremadura | 300737 | 2600 | 0 | 39.4937 | -6.0679 | 2022-08-24 04:20:46 | Extremadura, Spain | |||
1255071 | 1255071 | 2021-12-20 | Spain | Extremadura | 110301 | 2008 | 0 | 39.4937 | -6.0679 | 2021-12-21 03:21:27 | Extremadura, Spain | |||
1259087 | 1259087 | 2021-12-18 | Spain | Extremadura | 108754 | 2007 | 0 | 39.4937 | -6.0679 | 2021-12-19 04:21:11 | Extremadura, Spain | |||
1263086 | 1263086 | 2021-09-09 | Spain | Extremadura | 101438 | 1912 | 0 | 39.4937 | -6.0679 | 2021-09-10 04:21:20 | Extremadura, Spain | |||
1274587 | 1274587 | 2021-10-03 | Spain | Extremadura | 102466 | 1983 | 0 | 39.4937 | -6.0679 | 2021-10-04 04:21:31 | Extremadura, Spain | |||
1282288 | 1282288 | 2022-01-05 | Spain | Extremadura | 146613 | 2025 | 0 | 39.4937 | -6.0679 | 2022-01-06 04:22:09 | Extremadura, Spain | |||
1286304 | 1286304 | 2022-01-04 | Spain | Extremadura | 143102 | 2020 | 0 | 39.4937 | -6.0679 | 2022-01-05 04:21:59 | Extremadura, Spain | |||
1294334 | 1294334 | 2022-02-05 | Spain | Extremadura | 216411 | 2147 | 0 | 39.4937 | -6.0679 | 2022-02-06 04:21:00 | Extremadura, Spain | |||
1298351 | 1298351 | 2022-02-17 | Spain | Extremadura | 230021 | 2204 | 0 | 39.4937 | -6.0679 | 2022-02-18 04:21:04 | Extremadura, Spain | |||
1314499 | 1314499 | 2022-05-27 | Spain | Extremadura | 274816 | 2392 | 0 | 39.4937 | -6.0679 | 2022-05-28 04:21:07 | Extremadura, Spain | |||
1318513 | 1318513 | 2022-01-26 | Spain | Extremadura | 203102 | 2113 | 0 | 39.4937 | -6.0679 | 2022-01-27 04:21:19 | Extremadura, Spain | |||
1322529 | 1322529 | 2021-11-14 | Spain | Extremadura | 103642 | 1990 | 0 | 39.4937 | -6.0679 | 2021-11-15 04:21:36 | Extremadura, Spain | |||
1326546 | 1326546 | 2022-04-26 | Spain | Extremadura | 259972 | 2317 | 0 | 39.4937 | -6.0679 | 2022-04-27 04:20:52 | Extremadura, Spain | |||
1334575 | 1334575 | 2021-09-28 | Spain | Extremadura | 102333 | 1980 | 0 | 39.4937 | -6.0679 | 2021-09-29 04:21:45 | Extremadura, Spain | |||
1342587 | 1342587 | 2021-08-11 | Spain | Extremadura | 93112 | 1835 | 0 | 39.4937 | -6.0679 | 2021-08-12 04:21:25 | Extremadura, Spain | |||
1346620 | 1346620 | 2022-08-10 | Spain | Extremadura | 299248 | 2578 | 0 | 39.4937 | -6.0679 | 2022-08-11 04:20:49 | Extremadura, Spain | |||
1358635 | 1358635 | 2021-11-27 | Spain | Extremadura | 104409 | 1995 | 0 | 39.4937 | -6.0679 | 2021-11-28 04:22:43 | Extremadura, Spain | |||
1362651 | 1362651 | 2022-02-08 | Spain | Extremadura | 221944 | 2172 | 0 | 39.4937 | -6.0679 | 2022-02-09 04:21:04 | Extremadura, Spain | |||
1366779 | 1366779 | 2022-10-28 | Spain | Extremadura | 305532 | 2648 | 0 | 39.4937 | -6.0679 | 2022-10-29 04:21:13 | Extremadura, Spain | |||
1370795 | 1370795 | 2022-09-21 | Spain | Extremadura | 303145 | 2630 | 0 | 39.4937 | -6.0679 | 2022-09-22 04:22:56 | Extremadura, Spain | |||
1374790 | 1374790 | 2021-09-15 | Spain | Extremadura | 101811 | 1940 | 0 | 39.4937 | -6.0679 | 2021-09-16 04:22:19 | Extremadura, Spain | |||
1385928 | 1385928 | 2021-09-13 | Spain | Extremadura | 101690 | 1932 | 0 | 39.4937 | -6.0679 | 2021-09-14 04:21:41 | Extremadura, Spain | |||
1389959 | 1389959 | 2022-01-07 | Spain | Extremadura | 151836 | 2029 | 0 | 39.4937 | -6.0679 | 2022-01-08 04:21:53 | Extremadura, Spain | |||
1393977 | 1393977 | 2022-09-02 | Spain | Extremadura | 301952 | 2613 | 0 | 39.4937 | -6.0679 | 2022-09-03 04:21:04 | Extremadura, Spain | |||
1397992 | 1397992 | 2022-05-06 | Spain | Extremadura | 265557 | 2333 | 0 | 39.4937 | -6.0679 | 2022-05-07 04:21:09 | Extremadura, Spain | |||
1405343 | 1405343 | 2022-08-02 | Spain | Extremadura | 298163 | 2555 | 0 | 39.4937 | -6.0679 | 2022-08-03 04:20:59 | Extremadura, Spain | |||
1417387 | 1417387 | 2022-07-08 | Spain | Extremadura | 290792 | 2478 | 0 | 39.4937 | -6.0679 | 2022-07-09 04:20:59 | Extremadura, Spain | |||
1421403 | 1421403 | 2022-06-08 | Spain | Extremadura | 277482 | 2418 | 0 | 39.4937 | -6.0679 | 2022-06-09 04:20:54 | Extremadura, Spain | |||
1431859 | 1431859 | 2020-05-20 | Spain | Extremadura | 3040 | 504 | 0 | 2536 | 39.4937 | -6.0679 | 2020-05-21 02:32:48 | Extremadura, Spain | ||
1432865 | 1432865 | 2021-12-28 | Spain | Extremadura | 123955 | 2012 | 0 | 39.4937 | -6.0679 | 2021-12-29 03:21:43 | Extremadura, Spain | |||
1436882 | 1436882 | 2022-03-28 | Spain | Extremadura | 250928 | 2269 | 0 | 39.4937 | -6.0679 | 2022-03-29 04:20:46 | Extremadura, Spain | |||
1464383 | 1464383 | 2022-02-10 | Spain | Extremadura | 224552 | 2181 | 0 | 39.4937 | -6.0679 | 2022-02-11 04:21:09 | Extremadura, Spain | |||
1468399 | 1468399 | 2022-03-24 | Spain | Extremadura | 248458 | 2267 | 0 | 39.4937 | -6.0679 | 2022-03-25 04:20:46 | Extremadura, 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]);