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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2463092 | 2463092 | 2021-09-14 | Spain | Madrid | 884983 | 16011 | 0 | 40.4168 | -3.7038 | 2021-09-15 03:22:37 | Madrid, Spain | |||
1385931 | 1385931 | 2021-09-13 | Spain | Madrid | 884428 | 15991 | 0 | 40.4168 | -3.7038 | 2021-09-14 04:21:41 | Madrid, Spain | |||
1885300 | 1885300 | 2021-09-12 | Spain | Madrid | 883491 | 15984 | 0 | 40.4168 | -3.7038 | 2021-09-13 04:21:15 | Madrid, Spain | |||
3806203 | 3806203 | 2021-09-11 | Spain | Madrid | 883491 | 15984 | 0 | 40.4168 | -3.7038 | 2021-09-12 04:21:13 | Madrid, Spain | |||
3449143 | 3449143 | 2021-09-10 | Spain | Madrid | 883491 | 15984 | 0 | 40.4168 | -3.7038 | 2021-09-11 04:21:30 | Madrid, Spain | |||
1263089 | 1263089 | 2021-09-09 | Spain | Madrid | 882840 | 15971 | 0 | 40.4168 | -3.7038 | 2021-09-10 04:21:20 | Madrid, Spain | |||
2279459 | 2279459 | 2021-09-08 | Spain | Madrid | 882120 | 15963 | 0 | 40.4168 | -3.7038 | 2021-09-09 04:21:27 | Madrid, Spain | |||
642238 | 642238 | 2021-09-07 | Spain | Madrid | 881222 | 15953 | 0 | 40.4168 | -3.7038 | 2021-09-08 04:21:31 | Madrid, Spain | |||
3194301 | 3194301 | 2021-09-06 | Spain | Madrid | 880529 | 15935 | 0 | 40.4168 | -3.7038 | 2021-09-07 04:21:35 | Madrid, Spain | |||
3281169 | 3281169 | 2021-09-05 | Spain | Madrid | 879118 | 15918 | 0 | 40.4168 | -3.7038 | 2021-09-06 04:21:22 | Madrid, Spain | |||
249583 | 249583 | 2021-09-04 | Spain | Madrid | 879118 | 15918 | 0 | 40.4168 | -3.7038 | 2021-09-05 04:21:33 | Madrid, Spain | |||
3974864 | 3974864 | 2021-09-03 | Spain | Madrid | 879118 | 15918 | 0 | 40.4168 | -3.7038 | 2021-09-04 04:21:28 | Madrid, Spain | |||
178326 | 178326 | 2021-09-02 | Spain | Madrid | 878157 | 15901 | 0 | 40.4168 | -3.7038 | 2021-09-03 04:21:20 | Madrid, Spain | |||
67361 | 67361 | 2021-09-01 | Spain | Madrid | 876956 | 15884 | 0 | 40.4168 | -3.7038 | 2021-09-02 04:21:15 | Madrid, Spain | |||
2068203 | 2068203 | 2021-08-31 | Spain | Madrid | 875815 | 15840 | 0 | 40.4168 | -3.7038 | 2021-09-01 04:21:38 | Madrid, Spain | |||
1775657 | 1775657 | 2021-08-30 | Spain | Madrid | 874732 | 15792 | 0 | 40.4168 | -3.7038 | 2021-08-31 04:21:46 | Madrid, Spain | |||
3892231 | 3892231 | 2021-08-29 | Spain | Madrid | 872690 | 15787 | 0 | 40.4168 | -3.7038 | 2021-08-30 04:21:23 | Madrid, Spain | |||
2793334 | 2793334 | 2021-08-28 | Spain | Madrid | 872690 | 15787 | 0 | 40.4168 | -3.7038 | 2021-08-29 04:21:14 | Madrid, Spain | |||
2923493 | 2923493 | 2021-08-27 | Spain | Madrid | 872690 | 15787 | 0 | 40.4168 | -3.7038 | 2021-08-28 04:21:28 | Madrid, Spain | |||
1596507 | 1596507 | 2021-08-26 | Spain | Madrid | 871241 | 15780 | 0 | 40.4168 | -3.7038 | 2021-08-27 04:21:37 | Madrid, Spain | |||
32716 | 32716 | 2021-08-25 | Spain | Madrid | 869607 | 15773 | 0 | 40.4168 | -3.7038 | 2021-08-26 04:21:28 | Madrid, Spain | |||
3105755 | 3105755 | 2021-08-24 | Spain | Madrid | 867974 | 15764 | 0 | 40.4168 | -3.7038 | 2021-08-25 04:21:41 | Madrid, Spain | |||
3165926 | 3165926 | 2021-08-23 | Spain | Madrid | 866452 | 15756 | 0 | 40.4168 | -3.7038 | 2021-08-24 04:21:19 | Madrid, Spain | |||
2175853 | 2175853 | 2021-08-22 | Spain | Madrid | 863791 | 15754 | 0 | 40.4168 | -3.7038 | 2021-08-23 04:21:27 | Madrid, Spain | |||
3555949 | 3555949 | 2021-08-21 | Spain | Madrid | 863791 | 15754 | 0 | 40.4168 | -3.7038 | 2021-08-22 04:21:29 | Madrid, Spain | |||
1854291 | 1854291 | 2021-08-20 | Spain | Madrid | 863791 | 15754 | 0 | 40.4168 | -3.7038 | 2021-08-21 04:21:38 | Madrid, Spain | |||
511998 | 511998 | 2021-08-19 | Spain | Madrid | 862201 | 15746 | 0 | 40.4168 | -3.7038 | 2021-08-20 04:21:33 | Madrid, Spain | |||
2518477 | 2518477 | 2021-08-18 | Spain | Madrid | 860180 | 15731 | 0 | 40.4168 | -3.7038 | 2021-08-19 04:21:15 | Madrid, Spain | |||
245569 | 245569 | 2021-08-17 | Spain | Madrid | 858204 | 15689 | 0 | 40.4168 | -3.7038 | 2021-08-18 04:21:35 | Madrid, Spain | |||
1604532 | 1604532 | 2021-08-16 | Spain | Madrid | 856249 | 15667 | 0 | 40.4168 | -3.7038 | 2021-08-17 04:21:49 | Madrid, Spain | |||
103626 | 103626 | 2021-08-15 | Spain | Madrid | 852736 | 15666 | 0 | 40.4168 | -3.7038 | 2021-08-16 04:21:31 | Madrid, Spain | |||
507984 | 507984 | 2021-08-14 | Spain | Madrid | 852736 | 15666 | 0 | 40.4168 | -3.7038 | 2021-08-15 04:21:41 | Madrid, Spain | |||
1483856 | 1483856 | 2021-08-13 | Spain | Madrid | 852736 | 15666 | 0 | 40.4168 | -3.7038 | 2021-08-14 04:21:25 | Madrid, Spain | |||
2899986 | 2899986 | 2021-08-12 | Spain | Madrid | 850549 | 15656 | 0 | 40.4168 | -3.7038 | 2021-08-13 04:21:24 | Madrid, Spain | |||
1342590 | 1342590 | 2021-08-11 | Spain | Madrid | 847772 | 15642 | 0 | 40.4168 | -3.7038 | 2021-08-12 04:21:25 | Madrid, Spain | |||
2351737 | 2351737 | 2021-08-10 | Spain | Madrid | 844763 | 15624 | 0 | 40.4168 | -3.7038 | 2021-08-11 04:21:58 | Madrid, Spain | |||
650266 | 650266 | 2021-08-09 | Spain | Madrid | 842119 | 15616 | 0 | 40.4168 | -3.7038 | 2021-08-10 04:21:27 | Madrid, Spain | |||
589928 | 589928 | 2021-08-08 | Spain | Madrid | 837188 | 15587 | 0 | 40.4168 | -3.7038 | 2021-08-09 04:21:24 | Madrid, Spain | |||
2203940 | 2203940 | 2021-08-07 | Spain | Madrid | 837188 | 15587 | 0 | 40.4168 | -3.7038 | 2021-08-08 04:21:33 | Madrid, Spain | |||
1117890 | 1117890 | 2021-08-06 | Spain | Madrid | 837188 | 15587 | 0 | 40.4168 | -3.7038 | 2021-08-07 04:21:30 | Madrid, Spain | |||
1956827 | 1956827 | 2021-08-05 | Spain | Madrid | 834064 | 15577 | 0 | 40.4168 | -3.7038 | 2021-08-06 04:21:18 | 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 | ||
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 | ||
3904273 | 3904273 | 2021-07-31 | Spain | Madrid | 815663 | 15531 | 40736 | 759396 | 40.4168 | -3.7038 | 2021-08-01 04:21:50 | 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 | ||
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 | ||
1378807 | 1378807 | 2021-07-25 | Spain | Madrid | 788287 | 15508 | 40736 | 732043 | 40.4168 | -3.7038 | 2021-07-26 04:21:28 | 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 | ||
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 | ||
3706425 | 3706425 | 2021-07-17 | Spain | Madrid | 761716 | 15502 | 40736 | 705478 | 40.4168 | -3.7038 | 2021-07-18 04:22:07 | 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 | ||
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 | ||
3741381 | 3741381 | 2021-07-12 | Spain | Madrid | 747259 | 15483 | 40736 | 691040 | 40.4168 | -3.7038 | 2021-07-13 04:21:18 | 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 | ||
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 | ||
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 | ||
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 | ||
1712625 | 1712625 | 2021-06-25 | Spain | Madrid | 729222 | 15419 | 40736 | 673067 | 40.4168 | -3.7038 | 2021-06-26 04:21:43 | 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 | ||
2884668 | 2884668 | 2021-06-20 | Spain | Madrid | 726171 | 15402 | 40736 | 670033 | 40.4168 | -3.7038 | 2021-06-21 04:21:41 | 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 | ||
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 | ||
3381673 | 3381673 | 2021-06-13 | Spain | Madrid | 723206 | 15378 | 40736 | 667092 | 40.4168 | -3.7038 | 2021-06-14 04:22:46 | 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 | ||
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 |
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]);