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 = "Extremadura" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
628 | 628 | 2021-12-02 | Spain | Extremadura | 105058 | 1999 | 0 | 39.4937 | -6.0679 | 2021-12-03 04:23:05 | Extremadura, Spain | |||
4644 | 4644 | 2021-10-28 | Spain | Extremadura | 103204 | 1993 | 0 | 39.4937 | -6.0679 | 2021-10-29 04:22:03 | Extremadura, Spain | |||
16652 | 16652 | 2021-09-18 | Spain | Extremadura | 101930 | 1950 | 0 | 39.4937 | -6.0679 | 2021-09-19 04:21:34 | Extremadura, Spain | |||
24699 | 24699 | 2022-03-20 | Spain | Extremadura | 246259 | 2258 | 0 | 39.4937 | -6.0679 | 2022-03-21 04:20:50 | Extremadura, Spain | |||
28714 | 28714 | 2021-11-11 | Spain | Extremadura | 103587 | 1990 | 0 | 39.4937 | -6.0679 | 2021-11-12 04:22:01 | Extremadura, Spain | |||
32713 | 32713 | 2021-08-25 | Spain | Extremadura | 98545 | 1869 | 0 | 39.4937 | -6.0679 | 2021-08-26 04:21:28 | Extremadura, Spain | |||
44006 | 44006 | 2021-11-02 | Spain | Extremadura | 103276 | 1989 | 0 | 39.4937 | -6.0679 | 2021-11-03 06:22:09 | Extremadura, Spain | |||
63363 | 63363 | 2022-11-12 | Spain | Extremadura | 306122 | 2654 | 0 | 39.4937 | -6.0679 | 2022-11-13 04:21:14 | Extremadura, Spain | |||
67358 | 67358 | 2021-09-01 | Spain | Extremadura | 100438 | 1889 | 0 | 39.4937 | -6.0679 | 2021-09-02 04:21:15 | Extremadura, Spain | |||
71389 | 71389 | 2022-02-07 | Spain | Extremadura | 220471 | 2166 | 0 | 39.4937 | -6.0679 | 2022-02-08 04:21:15 | Extremadura, Spain | |||
87423 | 87423 | 2021-11-09 | Spain | Extremadura | 103471 | 1989 | 0 | 39.4937 | -6.0679 | 2021-11-10 04:21:38 | Extremadura, Spain | |||
91441 | 91441 | 2022-07-23 | Spain | Extremadura | 295788 | 2535 | 0 | 39.4937 | -6.0679 | 2022-07-24 04:20:47 | Extremadura, Spain | |||
99624 | 99624 | 2022-01-14 | Spain | Extremadura | 173807 | 2054 | 0 | 39.4937 | -6.0679 | 2022-01-15 04:21:07 | Extremadura, Spain | |||
103623 | 103623 | 2021-08-15 | Spain | Extremadura | 93958 | 1836 | 0 | 39.4937 | -6.0679 | 2021-08-16 04:21:31 | Extremadura, Spain | |||
115051 | 115051 | 2022-09-06 | Spain | Extremadura | 302193 | 2618 | 0 | 39.4937 | -6.0679 | 2022-09-07 04:20:59 | Extremadura, Spain | |||
127031 | 127031 | 2022-01-09 | Spain | Extremadura | 151836 | 2029 | 0 | 39.4937 | -6.0679 | 2022-01-10 04:22:07 | Extremadura, Spain | |||
131051 | 131051 | 2022-10-04 | Spain | Extremadura | 303875 | 2639 | 0 | 39.4937 | -6.0679 | 2022-10-05 04:23:06 | Extremadura, Spain | |||
138269 | 138269 | 2021-12-04 | Spain | Extremadura | 105208 | 1999 | 0 | 39.4937 | -6.0679 | 2021-12-05 04:22:25 | Extremadura, Spain | |||
142287 | 142287 | 2022-07-09 | Spain | Extremadura | 290792 | 2478 | 0 | 39.4937 | -6.0679 | 2022-07-10 04:20:54 | Extremadura, Spain | |||
150282 | 150282 | 2021-11-29 | Spain | Extremadura | 104650 | 1997 | 0 | 39.4937 | -6.0679 | 2021-11-30 04:22:53 | Extremadura, Spain | |||
158311 | 158311 | 2022-03-29 | Spain | Extremadura | 252313 | 2273 | 0 | 39.4937 | -6.0679 | 2022-03-30 04:20:45 | Extremadura, Spain | |||
162326 | 162326 | 2021-11-19 | Spain | Extremadura | 104002 | 1992 | 0 | 39.4937 | -6.0679 | 2021-11-20 04:22:17 | Extremadura, Spain | |||
166344 | 166344 | 2022-06-21 | Spain | Extremadura | 281330 | 2445 | 0 | 39.4937 | -6.0679 | 2022-06-22 04:20:54 | Extremadura, Spain | |||
178323 | 178323 | 2021-09-02 | Spain | Extremadura | 100587 | 1893 | 0 | 39.4937 | -6.0679 | 2021-09-03 04:21:20 | Extremadura, Spain | |||
186369 | 186369 | 2022-02-13 | Spain | Extremadura | 225595 | 2181 | 0 | 39.4937 | -6.0679 | 2022-02-14 04:20:51 | Extremadura, Spain | |||
198560 | 198560 | 2022-10-19 | Spain | Extremadura | 304622 | 2641 | 0 | 39.4937 | -6.0679 | 2022-10-20 04:22:59 | Extremadura, Spain | |||
218281 | 218281 | 2022-12-26 | Spain | Extremadura | 307939 | 2671 | 0 | 39.4937 | -6.0679 | 2022-12-27 04:21:07 | Extremadura, Spain | |||
222294 | 222294 | 2022-05-09 | Spain | Extremadura | 267260 | 2337 | 0 | 39.4937 | -6.0679 | 2022-05-10 04:20:50 | Extremadura, Spain | |||
229526 | 229526 | 2022-05-31 | Spain | Extremadura | 274816 | 2392 | 0 | 39.4937 | -6.0679 | 2022-06-01 04:20:55 | Extremadura, Spain | |||
233541 | 233541 | 2022-02-11 | Spain | Extremadura | 225595 | 2181 | 0 | 39.4937 | -6.0679 | 2022-02-12 04:21:06 | Extremadura, Spain | |||
245566 | 245566 | 2021-08-17 | Spain | Extremadura | 95167 | 1845 | 0 | 39.4937 | -6.0679 | 2021-08-18 04:21:35 | Extremadura, Spain | |||
249580 | 249580 | 2021-09-04 | Spain | Extremadura | 100794 | 1897 | 0 | 39.4937 | -6.0679 | 2021-09-05 04:21:33 | Extremadura, Spain | |||
253613 | 253613 | 2022-09-08 | Spain | Extremadura | 302193 | 2618 | 0 | 39.4937 | -6.0679 | 2022-09-09 04:21:11 | Extremadura, Spain | |||
257631 | 257631 | 2022-12-10 | Spain | Extremadura | 307199 | 2666 | 0 | 39.4937 | -6.0679 | 2022-12-11 04:20:50 | Extremadura, Spain | |||
261831 | 261831 | 2022-03-15 | Spain | Extremadura | 243485 | 2253 | 0 | 39.4937 | -6.0679 | 2022-03-16 04:20:50 | Extremadura, Spain | |||
276481 | 276481 | 2021-11-03 | Spain | Extremadura | 103316 | 1989 | 0 | 39.4937 | -6.0679 | 2021-11-04 04:22:20 | Extremadura, Spain | |||
288294 | 288294 | 2021-10-31 | Spain | Extremadura | 103217 | 1989 | 0 | 39.4937 | -6.0679 | 2021-11-01 04:22:01 | Extremadura, Spain | |||
292314 | 292314 | 2022-11-15 | Spain | Extremadura | 306122 | 2654 | 0 | 39.4937 | -6.0679 | 2022-11-16 04:21:09 | Extremadura, Spain | |||
304167 | 304167 | 2022-04-16 | Spain | Extremadura | 255370 | 2292 | 0 | 39.4937 | -6.0679 | 2022-04-17 04:20:59 | Extremadura, Spain | |||
308186 | 308186 | 2022-12-13 | Spain | Extremadura | 307199 | 2666 | 0 | 39.4937 | -6.0679 | 2022-12-14 04:21:04 | Extremadura, Spain | |||
312202 | 312202 | 2022-11-13 | Spain | Extremadura | 306122 | 2654 | 0 | 39.4937 | -6.0679 | 2022-11-14 04:21:09 | Extremadura, Spain | |||
316215 | 316215 | 2022-02-12 | Spain | Extremadura | 225595 | 2181 | 0 | 39.4937 | -6.0679 | 2022-02-13 04:21:00 | Extremadura, Spain | |||
320234 | 320234 | 2022-10-30 | Spain | Extremadura | 305532 | 2648 | 0 | 39.4937 | -6.0679 | 2022-10-31 04:21:36 | Extremadura, Spain | |||
328208 | 328208 | 2022-12-27 | Spain | Extremadura | 307939 | 2671 | 0 | 39.4937 | -6.0679 | 2022-12-28 04:21:04 | Extremadura, Spain | |||
336235 | 336235 | 2022-03-18 | Spain | Extremadura | 246259 | 2258 | 0 | 39.4937 | -6.0679 | 2022-03-19 04:20:47 | Extremadura, Spain | |||
348598 | 348598 | 2022-12-14 | Spain | Extremadura | 307199 | 2666 | 0 | 39.4937 | -6.0679 | 2022-12-15 04:20:58 | Extremadura, Spain | |||
356625 | 356625 | 2022-03-11 | Spain | Extremadura | 241992 | 2249 | 0 | 39.4937 | -6.0679 | 2022-03-12 04:20:50 | Extremadura, Spain | |||
360641 | 360641 | 2022-05-07 | Spain | Extremadura | 265557 | 2333 | 0 | 39.4937 | -6.0679 | 2022-05-08 04:20:49 | Extremadura, Spain | |||
372498 | 372498 | 2022-09-13 | Spain | Extremadura | 302690 | 2624 | 0 | 39.4937 | -6.0679 | 2022-09-14 04:20:44 | Extremadura, Spain | |||
384525 | 384525 | 2022-09-23 | Spain | Extremadura | 303341 | 2630 | 0 | 39.4937 | -6.0679 | 2022-09-24 04:21:40 | Extremadura, Spain | |||
396566 | 396566 | 2022-10-07 | Spain | Extremadura | 304106 | 2639 | 0 | 39.4937 | -6.0679 | 2022-10-08 04:22:56 | Extremadura, Spain | |||
404592 | 404592 | 2021-12-07 | Spain | Extremadura | 105668 | 1999 | 0 | 39.4937 | -6.0679 | 2021-12-08 04:22:46 | Extremadura, Spain | |||
419637 | 419637 | 2022-09-18 | Spain | Extremadura | 302932 | 2628 | 0 | 39.4937 | -6.0679 | 2022-09-19 04:21:49 | Extremadura, Spain | |||
423649 | 423649 | 2021-10-10 | Spain | Extremadura | 102687 | 1992 | 0 | 39.4937 | -6.0679 | 2021-10-11 04:21:31 | Extremadura, Spain | |||
431659 | 431659 | 2022-11-03 | Spain | Extremadura | 305532 | 2648 | 0 | 39.4937 | -6.0679 | 2022-11-04 04:22:11 | Extremadura, Spain | |||
443653 | 443653 | 2021-10-20 | Spain | Extremadura | 103041 | 1998 | 0 | 39.4937 | -6.0679 | 2021-10-21 04:21:18 | Extremadura, Spain | |||
447669 | 447669 | 2021-11-17 | Spain | Extremadura | 103865 | 1991 | 0 | 39.4937 | -6.0679 | 2021-11-18 04:21:33 | Extremadura, Spain | |||
451689 | 451689 | 2022-12-21 | Spain | Extremadura | 307529 | 2667 | 0 | 39.4937 | -6.0679 | 2022-12-22 04:20:56 | Extremadura, Spain | |||
459678 | 459678 | 2022-02-02 | Spain | Extremadura | 214806 | 2141 | 0 | 39.4937 | -6.0679 | 2022-02-03 04:21:21 | Extremadura, Spain | |||
463695 | 463695 | 2022-05-02 | Spain | Extremadura | 261981 | 2319 | 0 | 39.4937 | -6.0679 | 2022-05-03 04:21:00 | Extremadura, Spain | |||
467710 | 467710 | 2021-10-07 | Spain | Extremadura | 102653 | 1989 | 0 | 39.4937 | -6.0679 | 2021-10-08 04:21:25 | Extremadura, Spain | |||
475742 | 475742 | 2022-06-26 | Spain | Extremadura | 283019 | 2449 | 0 | 39.4937 | -6.0679 | 2022-06-27 04:21:00 | Extremadura, Spain | |||
479892 | 479892 | 2022-11-08 | Spain | Extremadura | 305800 | 2652 | 0 | 39.4937 | -6.0679 | 2022-11-09 04:21:22 | Extremadura, Spain | |||
487922 | 487922 | 2022-11-25 | Spain | Extremadura | 306732 | 2660 | 0 | 39.4937 | -6.0679 | 2022-11-26 04:21:11 | Extremadura, Spain | |||
491934 | 491934 | 2021-10-14 | Spain | Extremadura | 102873 | 1994 | 0 | 39.4937 | -6.0679 | 2021-10-15 04:21:26 | Extremadura, Spain | |||
495950 | 495950 | 2021-11-06 | Spain | Extremadura | 103382 | 1989 | 0 | 39.4937 | -6.0679 | 2021-11-07 04:21:53 | Extremadura, Spain | |||
499967 | 499967 | 2022-04-02 | Spain | Extremadura | 253230 | 2279 | 0 | 39.4937 | -6.0679 | 2022-04-03 04:20:48 | Extremadura, Spain | |||
503986 | 503986 | 2022-12-17 | Spain | Extremadura | 307529 | 2667 | 0 | 39.4937 | -6.0679 | 2022-12-18 04:21:03 | Extremadura, Spain | |||
507981 | 507981 | 2021-08-14 | Spain | Extremadura | 93958 | 1836 | 0 | 39.4937 | -6.0679 | 2021-08-15 04:21:41 | Extremadura, Spain | |||
511995 | 511995 | 2021-08-19 | Spain | Extremadura | 96115 | 1854 | 0 | 39.4937 | -6.0679 | 2021-08-20 04:21:33 | Extremadura, Spain | |||
516030 | 516030 | 2022-10-15 | Spain | Extremadura | 304622 | 2641 | 0 | 39.4937 | -6.0679 | 2022-10-16 04:22:39 | Extremadura, Spain | |||
535034 | 535034 | 2021-10-27 | Spain | Extremadura | 103197 | 1993 | 0 | 39.4937 | -6.0679 | 2021-10-28 04:22:08 | Extremadura, Spain | |||
539054 | 539054 | 2022-10-26 | Spain | Extremadura | 305130 | 2645 | 0 | 39.4937 | -6.0679 | 2022-10-27 04:22:01 | Extremadura, Spain | |||
543070 | 543070 | 2022-12-15 | Spain | Extremadura | 307199 | 2666 | 0 | 39.4937 | -6.0679 | 2022-12-16 04:21:01 | Extremadura, Spain | |||
551072 | 551072 | 2021-12-08 | Spain | Extremadura | 105668 | 1999 | 0 | 39.4937 | -6.0679 | 2021-12-09 04:22:49 | Extremadura, Spain | |||
555088 | 555088 | 2022-01-16 | Spain | Extremadura | 173807 | 2054 | 0 | 39.4937 | -6.0679 | 2022-01-17 04:21:08 | Extremadura, Spain | |||
559106 | 559106 | 2022-06-16 | Spain | Extremadura | 279130 | 2426 | 0 | 39.4937 | -6.0679 | 2022-06-17 04:20:56 | Extremadura, Spain | |||
567402 | 567402 | 2021-10-29 | Spain | Extremadura | 103217 | 1989 | 0 | 39.4937 | -6.0679 | 2021-10-30 04:22:03 | Extremadura, Spain | |||
575131 | 575131 | 2022-02-25 | Spain | Extremadura | 233837 | 2225 | 0 | 39.4937 | -6.0679 | 2022-02-26 04:21:12 | Extremadura, Spain | |||
589925 | 589925 | 2021-08-08 | Spain | Extremadura | 91365 | 1830 | 0 | 39.4937 | -6.0679 | 2021-08-09 04:21:24 | Extremadura, Spain | |||
593958 | 593958 | 2022-07-01 | Spain | Extremadura | 286695 | 2463 | 0 | 39.4937 | -6.0679 | 2022-07-02 04:21:16 | Extremadura, Spain | |||
597972 | 597972 | 2021-10-19 | Spain | Extremadura | 103012 | 1999 | 0 | 39.4937 | -6.0679 | 2021-10-20 04:21:00 | Extremadura, Spain | |||
601988 | 601988 | 2021-09-23 | Spain | Extremadura | 102163 | 1973 | 0 | 39.4937 | -6.0679 | 2021-09-24 04:21:44 | Extremadura, Spain | |||
618164 | 618164 | 2022-11-05 | Spain | Extremadura | 305800 | 2652 | 0 | 39.4937 | -6.0679 | 2022-11-06 04:21:24 | Extremadura, Spain | |||
622178 | 622178 | 2022-05-22 | Spain | Extremadura | 272427 | 2369 | 0 | 39.4937 | -6.0679 | 2022-05-26 04:20:50 | Extremadura, Spain | |||
630208 | 630208 | 2022-07-12 | Spain | Extremadura | 292214 | 2491 | 0 | 39.4937 | -6.0679 | 2022-07-13 04:20:58 | Extremadura, Spain | |||
634222 | 634222 | 2021-10-13 | Spain | Extremadura | 102824 | 1994 | 0 | 39.4937 | -6.0679 | 2021-10-14 04:21:29 | Extremadura, Spain | |||
642235 | 642235 | 2021-09-07 | Spain | Extremadura | 101223 | 1907 | 0 | 39.4937 | -6.0679 | 2021-09-08 04:21:31 | Extremadura, Spain | |||
650263 | 650263 | 2021-08-09 | Spain | Extremadura | 92360 | 1835 | 0 | 39.4937 | -6.0679 | 2021-08-10 04:21:27 | Extremadura, Spain | |||
654294 | 654294 | 2021-10-22 | Spain | Extremadura | 103110 | 1992 | 0 | 39.4937 | -6.0679 | 2021-10-23 04:21:32 | Extremadura, Spain | |||
658613 | 658613 | 2022-05-13 | Spain | Extremadura | 269218 | 2351 | 0 | 39.4937 | -6.0679 | 2022-05-14 04:20:48 | Extremadura, Spain | |||
670599 | 670599 | 2022-07-21 | Spain | Extremadura | 294664 | 2518 | 0 | 39.4937 | -6.0679 | 2022-07-22 04:21:15 | Extremadura, Spain | |||
674615 | 674615 | 2022-07-30 | Spain | Extremadura | 297465 | 2549 | 0 | 39.4937 | -6.0679 | 2022-07-31 04:21:02 | Extremadura, Spain | |||
682639 | 682639 | 2021-10-24 | Spain | Extremadura | 103110 | 1992 | 0 | 39.4937 | -6.0679 | 2021-10-25 04:22:31 | Extremadura, Spain | |||
686655 | 686655 | 2021-11-13 | Spain | Extremadura | 103642 | 1990 | 0 | 39.4937 | -6.0679 | 2021-11-14 04:21:31 | Extremadura, Spain | |||
690675 | 690675 | 2022-12-23 | Spain | Extremadura | 307939 | 2671 | 0 | 39.4937 | -6.0679 | 2022-12-24 04:21:02 | Extremadura, Spain | |||
694688 | 694688 | 2022-03-17 | Spain | Extremadura | 243485 | 2253 | 0 | 39.4937 | -6.0679 | 2022-03-18 04:20:55 | Extremadura, Spain | |||
698703 | 698703 | 2021-11-04 | Spain | Extremadura | 103342 | 1989 | 0 | 39.4937 | -6.0679 | 2021-11-05 04:21:54 | Extremadura, Spain | |||
706733 | 706733 | 2021-09-29 | Spain | Extremadura | 102388 | 1981 | 0 | 39.4937 | -6.0679 | 2021-09-30 04:21:20 | Extremadura, Spain | |||
710752 | 710752 | 2022-11-01 | Spain | Extremadura | 305532 | 2648 | 0 | 39.4937 | -6.0679 | 2022-11-02 04:22:09 | 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]);