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 = "Madrid" sorted by active descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1244050 | 1244050 | 2020-09-08 | Spain | Madrid | 149262 | 8780 | 40736 | 99746 | 40.4168 | -3.7038 | 2020-09-09 04:28:48 | Madrid, Spain | ||
427629 | 427629 | 2020-09-07 | Spain | Madrid | 146341 | 8748 | 40736 | 96857 | 40.4168 | -3.7038 | 2020-09-08 04:28:25 | Madrid, Spain | ||
813869 | 813869 | 2020-09-05 | Spain | Madrid | 136901 | 8728 | 40736 | 87437 | 40.4168 | -3.7038 | 2020-09-06 04:28:33 | Madrid, Spain | ||
2662069 | 2662069 | 2020-09-04 | Spain | Madrid | 136901 | 8728 | 40736 | 87437 | 40.4168 | -3.7038 | 2020-09-05 04:28:19 | Madrid, Spain | ||
3161914 | 3161914 | 2020-09-06 | Spain | Madrid | 136901 | 8728 | 40736 | 87437 | 40.4168 | -3.7038 | 2020-09-07 04:28:30 | Madrid, Spain | ||
1354609 | 1354609 | 2020-09-03 | Spain | Madrid | 133656 | 8692 | 40736 | 84228 | 40.4168 | -3.7038 | 2020-09-04 04:28:26 | Madrid, Spain | ||
1105846 | 1105846 | 2020-09-02 | Spain | Madrid | 130579 | 8676 | 40736 | 81167 | 40.4168 | -3.7038 | 2020-09-03 04:28:22 | Madrid, Spain | ||
2060175 | 2060175 | 2020-09-01 | Spain | Madrid | 128178 | 8662 | 40736 | 78780 | 40.4168 | -3.7038 | 2020-09-02 04:28:25 | Madrid, Spain | ||
332206 | 332206 | 2021-08-04 | Spain | Madrid | 830399 | 15563 | 40736 | 774100 | 40.4168 | -3.7038 | 2021-08-05 04:21:51 | Madrid, Spain | ||
3468477 | 3468477 | 2021-08-03 | Spain | Madrid | 826332 | 15550 | 40736 | 770046 | 40.4168 | -3.7038 | 2021-08-04 04:21:25 | Madrid, Spain | ||
194360 | 194360 | 2020-08-31 | Spain | Madrid | 126057 | 8648 | 40736 | 76673 | 40.4168 | -3.7038 | 2020-09-01 04:28:31 | Madrid, Spain | ||
3683751 | 3683751 | 2021-08-02 | Spain | Madrid | 822778 | 15533 | 40736 | 766509 | 40.4168 | -3.7038 | 2021-08-03 04:21:39 | Madrid, Spain | ||
3015650 | 3015650 | 2021-08-01 | Spain | Madrid | 815663 | 15531 | 40736 | 759396 | 40.4168 | -3.7038 | 2021-08-02 04:21:36 | Madrid, Spain | ||
3296478 | 3296478 | 2021-07-30 | Spain | Madrid | 815663 | 15531 | 40736 | 759396 | 40.4168 | -3.7038 | 2021-07-31 04:21:35 | Madrid, Spain | ||
3904273 | 3904273 | 2021-07-31 | Spain | Madrid | 815663 | 15531 | 40736 | 759396 | 40.4168 | -3.7038 | 2021-08-01 04:21:50 | Madrid, Spain | ||
3385689 | 3385689 | 2021-07-29 | Spain | Madrid | 810583 | 15529 | 40736 | 754318 | 40.4168 | -3.7038 | 2021-07-30 04:21:34 | Madrid, Spain | ||
408594 | 408594 | 2021-07-28 | Spain | Madrid | 805674 | 15520 | 40736 | 749418 | 40.4168 | -3.7038 | 2021-07-29 04:21:33 | Madrid, Spain | ||
1306455 | 1306455 | 2021-07-27 | Spain | Madrid | 800530 | 15511 | 40736 | 744283 | 40.4168 | -3.7038 | 2021-07-28 04:21:39 | Madrid, Spain | ||
3218598 | 3218598 | 2021-07-26 | Spain | Madrid | 795937 | 15509 | 40736 | 739692 | 40.4168 | -3.7038 | 2021-07-27 04:21:18 | Madrid, Spain | ||
1330547 | 1330547 | 2021-07-24 | Spain | Madrid | 788287 | 15508 | 40736 | 732043 | 40.4168 | -3.7038 | 2021-07-25 04:22:12 | Madrid, Spain | ||
1378807 | 1378807 | 2021-07-25 | Spain | Madrid | 788287 | 15508 | 40736 | 732043 | 40.4168 | -3.7038 | 2021-07-26 04:21:28 | Madrid, Spain | ||
3137851 | 3137851 | 2021-07-23 | Spain | Madrid | 788287 | 15508 | 40736 | 732043 | 40.4168 | -3.7038 | 2021-07-24 00:21:36 | Madrid, Spain | ||
3476611 | 3476611 | 2021-07-22 | Spain | Madrid | 783478 | 15509 | 40736 | 727233 | 40.4168 | -3.7038 | 2021-07-23 04:21:29 | Madrid, Spain | ||
3331830 | 3331830 | 2021-07-21 | Spain | Madrid | 778350 | 15505 | 40736 | 722109 | 40.4168 | -3.7038 | 2021-07-22 04:21:19 | Madrid, Spain | ||
2371811 | 2371811 | 2021-07-20 | Spain | Madrid | 773332 | 15506 | 40736 | 717090 | 40.4168 | -3.7038 | 2021-07-21 04:21:40 | Madrid, Spain | ||
483890 | 483890 | 2021-07-19 | Spain | Madrid | 768874 | 15501 | 40736 | 712637 | 40.4168 | -3.7038 | 2021-07-20 04:21:48 | Madrid, Spain | ||
2674113 | 2674113 | 2021-07-18 | Spain | Madrid | 761716 | 15502 | 40736 | 705478 | 40.4168 | -3.7038 | 2021-07-19 04:21:24 | Madrid, Spain | ||
2947656 | 2947656 | 2021-07-16 | Spain | Madrid | 761716 | 15502 | 40736 | 705478 | 40.4168 | -3.7038 | 2021-07-17 04:22:22 | Madrid, Spain | ||
3706425 | 3706425 | 2021-07-17 | Spain | Madrid | 761716 | 15502 | 40736 | 705478 | 40.4168 | -3.7038 | 2021-07-18 04:22:07 | Madrid, Spain | ||
296312 | 296312 | 2021-07-15 | Spain | Madrid | 757649 | 15494 | 40736 | 701419 | 40.4168 | -3.7038 | 2021-07-16 04:21:22 | Madrid, Spain | ||
3632257 | 3632257 | 2021-07-14 | Spain | Madrid | 753730 | 15487 | 40736 | 697507 | 40.4168 | -3.7038 | 2021-07-15 04:21:48 | Madrid, Spain | ||
579132 | 579132 | 2021-07-13 | Spain | Madrid | 749955 | 15486 | 40736 | 693733 | 40.4168 | -3.7038 | 2021-07-14 04:21:35 | Madrid, Spain | ||
609981 | 609981 | 2020-08-29 | Spain | Madrid | 118600 | 8604 | 40736 | 69260 | 40.4168 | -3.7038 | 2020-08-30 04:28:22 | Madrid, Spain | ||
1523476 | 1523476 | 2020-08-28 | Spain | Madrid | 118600 | 8604 | 40736 | 69260 | 40.4168 | -3.7038 | 2020-08-29 04:28:19 | Madrid, Spain | ||
3932319 | 3932319 | 2020-08-30 | Spain | Madrid | 118600 | 8604 | 40736 | 69260 | 40.4168 | -3.7038 | 2020-08-31 04:28:27 | Madrid, Spain | ||
3741381 | 3741381 | 2021-07-12 | Spain | Madrid | 747259 | 15483 | 40736 | 691040 | 40.4168 | -3.7038 | 2021-07-13 04:21:18 | Madrid, Spain | ||
626178 | 626178 | 2021-07-10 | Spain | Madrid | 743109 | 15479 | 40736 | 686894 | 40.4168 | -3.7038 | 2021-07-11 04:21:43 | Madrid, Spain | ||
829897 | 829897 | 2021-07-09 | Spain | Madrid | 743109 | 15479 | 40736 | 686894 | 40.4168 | -3.7038 | 2021-07-10 04:21:25 | Madrid, Spain | ||
3659894 | 3659894 | 2021-07-11 | Spain | Madrid | 743109 | 15479 | 40736 | 686894 | 40.4168 | -3.7038 | 2021-07-12 04:21:34 | Madrid, Spain | ||
778661 | 778661 | 2021-07-08 | Spain | Madrid | 741040 | 15476 | 40736 | 684828 | 40.4168 | -3.7038 | 2021-07-09 04:21:21 | Madrid, Spain | ||
1440883 | 1440883 | 2021-07-07 | Spain | Madrid | 739192 | 15469 | 40736 | 682987 | 40.4168 | -3.7038 | 2021-07-08 04:21:26 | Madrid, Spain | ||
2693988 | 2693988 | 2021-07-06 | Spain | Madrid | 737334 | 15469 | 40736 | 681129 | 40.4168 | -3.7038 | 2021-07-07 04:21:20 | Madrid, Spain | ||
1932737 | 1932737 | 2021-07-05 | Spain | Madrid | 736016 | 15466 | 40736 | 679814 | 40.4168 | -3.7038 | 2021-07-06 04:21:32 | Madrid, Spain | ||
1165468 | 1165468 | 2021-07-04 | Spain | Madrid | 733770 | 15458 | 40736 | 677576 | 40.4168 | -3.7038 | 2021-07-05 04:21:28 | Madrid, Spain | ||
1495902 | 1495902 | 2021-07-03 | Spain | Madrid | 733770 | 15458 | 40736 | 677576 | 40.4168 | -3.7038 | 2021-07-04 04:21:38 | Madrid, Spain | ||
2072217 | 2072217 | 2021-07-02 | Spain | Madrid | 733770 | 15458 | 40736 | 677576 | 40.4168 | -3.7038 | 2021-07-03 04:21:37 | Madrid, Spain | ||
2765233 | 2765233 | 2021-07-01 | Spain | Madrid | 733004 | 15453 | 40736 | 676815 | 40.4168 | -3.7038 | 2021-07-02 04:21:47 | Madrid, Spain | ||
1893441 | 1893441 | 2021-06-30 | Spain | Madrid | 732007 | 15450 | 40736 | 675821 | 40.4168 | -3.7038 | 2021-07-01 04:21:19 | Madrid, Spain | ||
400564 | 400564 | 2021-06-29 | Spain | Madrid | 731035 | 15440 | 40736 | 674859 | 40.4168 | -3.7038 | 2021-06-30 04:21:41 | Madrid, Spain | ||
3125807 | 3125807 | 2021-06-28 | Spain | Madrid | 730260 | 15420 | 40736 | 674104 | 40.4168 | -3.7038 | 2021-06-29 04:21:28 | Madrid, Spain | ||
1712625 | 1712625 | 2021-06-25 | Spain | Madrid | 729222 | 15419 | 40736 | 673067 | 40.4168 | -3.7038 | 2021-06-26 04:21:43 | Madrid, Spain | ||
2590302 | 2590302 | 2021-06-27 | Spain | Madrid | 729222 | 15419 | 40736 | 673067 | 40.4168 | -3.7038 | 2021-06-28 04:21:29 | Madrid, Spain | ||
3958806 | 3958806 | 2021-06-26 | Spain | Madrid | 729222 | 15419 | 40736 | 673067 | 40.4168 | -3.7038 | 2021-06-27 04:21:39 | Madrid, Spain | ||
2295750 | 2295750 | 2021-06-24 | Spain | Madrid | 728659 | 15419 | 40736 | 672504 | 40.4168 | -3.7038 | 2021-06-25 04:21:33 | Madrid, Spain | ||
2423190 | 2423190 | 2021-06-23 | Spain | Madrid | 728107 | 15412 | 40736 | 671959 | 40.4168 | -3.7038 | 2021-06-24 04:21:55 | Madrid, Spain | ||
563267 | 563267 | 2021-06-22 | Spain | Madrid | 727592 | 15409 | 40736 | 671447 | 40.4168 | -3.7038 | 2021-06-23 04:21:46 | Madrid, Spain | ||
3358969 | 3358969 | 2021-06-21 | Spain | Madrid | 727091 | 15408 | 40736 | 670947 | 40.4168 | -3.7038 | 2021-06-22 04:21:34 | Madrid, Spain | ||
107751 | 107751 | 2021-06-19 | Spain | Madrid | 726171 | 15402 | 40736 | 670033 | 40.4168 | -3.7038 | 2021-06-20 04:21:48 | Madrid, Spain | ||
1125894 | 1125894 | 2021-06-18 | Spain | Madrid | 726171 | 15402 | 40736 | 670033 | 40.4168 | -3.7038 | 2021-06-19 04:22:33 | Madrid, Spain | ||
2884668 | 2884668 | 2021-06-20 | Spain | Madrid | 726171 | 15402 | 40736 | 670033 | 40.4168 | -3.7038 | 2021-06-21 04:21:41 | Madrid, Spain | ||
2911472 | 2911472 | 2021-06-17 | Spain | Madrid | 725722 | 15393 | 40736 | 669593 | 40.4168 | -3.7038 | 2021-06-18 04:22:16 | Madrid, Spain | ||
3030588 | 3030588 | 2021-06-16 | Spain | Madrid | 725241 | 15393 | 40736 | 669112 | 40.4168 | -3.7038 | 2021-06-17 04:22:36 | Madrid, Spain | ||
2339694 | 2339694 | 2021-06-15 | Spain | Madrid | 724685 | 15388 | 40736 | 668561 | 40.4168 | -3.7038 | 2021-06-16 04:22:32 | Madrid, Spain | ||
1564390 | 1564390 | 2021-06-14 | Spain | Madrid | 724243 | 15378 | 40736 | 668129 | 40.4168 | -3.7038 | 2021-06-15 04:22:22 | Madrid, Spain | ||
1736807 | 1736807 | 2021-06-12 | Spain | Madrid | 723206 | 15378 | 40736 | 667092 | 40.4168 | -3.7038 | 2021-06-13 04:22:44 | Madrid, Spain | ||
3381673 | 3381673 | 2021-06-13 | Spain | Madrid | 723206 | 15378 | 40736 | 667092 | 40.4168 | -3.7038 | 2021-06-14 04:22:46 | Madrid, Spain | ||
3970848 | 3970848 | 2021-06-11 | Spain | Madrid | 723206 | 15378 | 40736 | 667092 | 40.4168 | -3.7038 | 2021-06-12 04:22:22 | Madrid, Spain | ||
2717270 | 2717270 | 2021-06-10 | Spain | Madrid | 722667 | 15376 | 40736 | 666555 | 40.4168 | -3.7038 | 2021-06-11 04:23:20 | Madrid, Spain | ||
523155 | 523155 | 2021-06-09 | Spain | Madrid | 722100 | 15373 | 40736 | 665991 | 40.4168 | -3.7038 | 2021-06-10 04:23:17 | Madrid, Spain | ||
3472595 | 3472595 | 2021-06-08 | Spain | Madrid | 721384 | 15364 | 40736 | 665284 | 40.4168 | -3.7038 | 2021-06-09 04:23:31 | Madrid, Spain | ||
3145879 | 3145879 | 2021-06-07 | Spain | Madrid | 720815 | 15351 | 40736 | 664728 | 40.4168 | -3.7038 | 2021-06-08 04:22:35 | Madrid, Spain | ||
825881 | 825881 | 2021-06-06 | Spain | Madrid | 719515 | 15341 | 40736 | 663438 | 40.4168 | -3.7038 | 2021-06-07 04:22:51 | Madrid, Spain | ||
2315600 | 2315600 | 2021-06-04 | Spain | Madrid | 719515 | 15341 | 40736 | 663438 | 40.4168 | -3.7038 | 2021-06-05 04:23:03 | Madrid, Spain | ||
2586286 | 2586286 | 2021-06-05 | Spain | Madrid | 719515 | 15341 | 40736 | 663438 | 40.4168 | -3.7038 | 2021-06-06 04:24:03 | Madrid, Spain | ||
1448885 | 1448885 | 2021-06-03 | Spain | Madrid | 718743 | 15307 | 40736 | 662700 | 40.4168 | -3.7038 | 2021-06-04 04:23:37 | Madrid, Spain | ||
1708609 | 1708609 | 2021-06-02 | Spain | Madrid | 717880 | 15307 | 40736 | 661837 | 40.4168 | -3.7038 | 2021-06-03 04:23:32 | Madrid, Spain | ||
2104427 | 2104427 | 2021-06-01 | Spain | Madrid | 717030 | 15295 | 40736 | 660999 | 40.4168 | -3.7038 | 2021-06-02 04:24:34 | Madrid, Spain | ||
1189043 | 1189043 | 2021-05-31 | Spain | Madrid | 716173 | 15287 | 40736 | 660150 | 40.4168 | -3.7038 | 2021-06-01 04:23:09 | Madrid, Spain | ||
20668 | 20668 | 2021-05-28 | Spain | Madrid | 714616 | 15285 | 40736 | 658595 | 40.4168 | -3.7038 | 2021-05-29 04:20:41 | Madrid, Spain | ||
51089 | 51089 | 2021-05-29 | Spain | Madrid | 714616 | 15285 | 40736 | 658595 | 40.4168 | -3.7038 | 2021-05-30 04:20:55 | Madrid, Spain | ||
3089720 | 3089720 | 2021-05-30 | Spain | Madrid | 714616 | 15285 | 40736 | 658595 | 40.4168 | -3.7038 | 2021-05-31 03:08:59 | Madrid, Spain | ||
2510477 | 2510477 | 2020-08-27 | Spain | Madrid | 115159 | 8600 | 40736 | 65823 | 40.4168 | -3.7038 | 2020-08-28 04:28:11 | Madrid, Spain | ||
1807043 | 1807043 | 2021-05-27 | Spain | Madrid | 713592 | 15277 | 40736 | 657579 | 40.4168 | -3.7038 | 2021-05-28 04:20:36 | Madrid, Spain | ||
1310466 | 1310466 | 2021-05-26 | Spain | Madrid | 712519 | 15267 | 40736 | 656516 | 40.4168 | -3.7038 | 2021-05-27 04:20:59 | Madrid, Spain | ||
83392 | 83392 | 2021-05-25 | Spain | Madrid | 711411 | 15243 | 40736 | 655432 | 40.4168 | -3.7038 | 2021-05-26 04:20:35 | Madrid, Spain | ||
1413354 | 1413354 | 2021-05-24 | Spain | Madrid | 710024 | 15205 | 40736 | 654083 | 40.4168 | -3.7038 | 2021-05-25 04:21:08 | Madrid, Spain | ||
726795 | 726795 | 2021-05-22 | Spain | Madrid | 708721 | 15201 | 40736 | 652784 | 40.4168 | -3.7038 | 2021-05-23 04:20:51 | Madrid, Spain | ||
1771640 | 1771640 | 2021-05-23 | Spain | Madrid | 708721 | 15201 | 40736 | 652784 | 40.4168 | -3.7038 | 2021-05-24 04:20:53 | Madrid, Spain | ||
1952810 | 1952810 | 2021-05-21 | Spain | Madrid | 708721 | 15201 | 40736 | 652784 | 40.4168 | -3.7038 | 2021-05-22 04:20:45 | Madrid, Spain | ||
1913509 | 1913509 | 2021-05-20 | Spain | Madrid | 707480 | 15199 | 40736 | 651545 | 40.4168 | -3.7038 | 2021-05-21 04:20:43 | Madrid, Spain | ||
2256030 | 2256030 | 2021-05-19 | Spain | Madrid | 706306 | 15196 | 40736 | 650374 | 40.4168 | -3.7038 | 2021-05-20 04:21:05 | Madrid, Spain | ||
2391068 | 2391068 | 2021-05-18 | Spain | Madrid | 704832 | 15189 | 40736 | 648907 | 40.4168 | -3.7038 | 2021-05-19 04:20:42 | Madrid, Spain | ||
3574893 | 3574893 | 2021-05-17 | Spain | Madrid | 703560 | 15170 | 40736 | 647654 | 40.4168 | -3.7038 | 2021-05-18 04:20:33 | Madrid, Spain | ||
1082222 | 1082222 | 2021-05-14 | Spain | Madrid | 701437 | 15164 | 40736 | 645537 | 40.4168 | -3.7038 | 2021-05-15 04:20:58 | Madrid, Spain | ||
1873253 | 1873253 | 2021-05-15 | Spain | Madrid | 701437 | 15164 | 40736 | 645537 | 40.4168 | -3.7038 | 2021-05-16 04:20:49 | Madrid, Spain | ||
2939623 | 2939623 | 2021-05-16 | Spain | Madrid | 701437 | 15164 | 40736 | 645537 | 40.4168 | -3.7038 | 2021-05-17 04:20:34 | Madrid, Spain | ||
3054488 | 3054488 | 2021-05-13 | Spain | Madrid | 700152 | 15162 | 40736 | 644254 | 40.4168 | -3.7038 | 2021-05-14 04:20:41 | Madrid, Spain | ||
2004958 | 2004958 | 2021-05-12 | Spain | Madrid | 698584 | 15155 | 40736 | 642693 | 40.4168 | -3.7038 | 2021-05-13 04:20:51 | Madrid, Spain | ||
3954789 | 3954789 | 2021-05-11 | Spain | Madrid | 697084 | 15135 | 40736 | 641213 | 40.4168 | -3.7038 | 2021-05-12 04:21:29 | Madrid, Spain | ||
2821068 | 2821068 | 2021-05-10 | Spain | Madrid | 695627 | 15105 | 40736 | 639786 | 40.4168 | -3.7038 | 2021-05-11 04:20:41 | Madrid, 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]);