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 last_update
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1404423 | 1404423 | 2020-05-14 | Spain | Madrid | 65693 | 8779 | 40199 | 16715 | 40.4168 | -3.7038 | 2020-05-15 02:33:02 | Madrid, Spain | ||
3276249 | 3276249 | 2020-05-15 | Spain | Madrid | 66005 | 8809 | 40383 | 16813 | 40.4168 | -3.7038 | 2020-05-16 02:32:19 | Madrid, Spain | ||
1829533 | 1829533 | 2020-05-16 | Spain | Madrid | 66210 | 8826 | 40586 | 16798 | 40.4168 | -3.7038 | 2020-05-17 02:32:32 | Madrid, Spain | ||
3416299 | 3416299 | 2020-05-17 | Spain | Madrid | 66210 | 8826 | 40586 | 16798 | 40.4168 | -3.7038 | 2020-05-18 02:32:21 | Madrid, Spain | ||
3260905 | 3260905 | 2020-05-18 | Spain | Madrid | 66302 | 8863 | 40736 | 16703 | 40.4168 | -3.7038 | 2020-05-19 02:32:18 | Madrid, Spain | ||
2390167 | 2390167 | 2020-05-19 | Spain | Madrid | 66643 | 8894 | 0 | 57749 | 40.4168 | -3.7038 | 2020-05-20 02:32:19 | Madrid, Spain | ||
1431904 | 1431904 | 2020-05-20 | Spain | Madrid | 66860 | 8912 | 0 | 57948 | 40.4168 | -3.7038 | 2020-05-21 02:32:48 | Madrid, Spain | ||
268321 | 268321 | 2020-05-21 | Spain | Madrid | 67049 | 8931 | 0 | 58118 | 40.4168 | -3.7038 | 2020-05-22 02:36:51 | Madrid, Spain | ||
1864815 | 1864815 | 2020-05-22 | Spain | Madrid | 67425 | 8944 | 0 | 58481 | 40.4168 | -3.7038 | 2020-05-23 02:32:42 | Madrid, Spain | ||
997792 | 997792 | 2020-05-23 | Spain | Madrid | 67610 | 8956 | 0 | 58654 | 40.4168 | -3.7038 | 2020-05-24 02:32:43 | Madrid, Spain | ||
875601 | 875601 | 2020-05-24 | Spain | Madrid | 67871 | 8977 | 0 | 58894 | 40.4168 | -3.7038 | 2020-05-25 02:32:44 | Madrid, Spain | ||
1104921 | 1104921 | 2020-05-25 | Spain | Madrid | 67932 | 8686 | 0 | 59246 | 40.4168 | -3.7038 | 2020-05-26 02:32:35 | Madrid, Spain | ||
1041191 | 1041191 | 2020-05-26 | Spain | Madrid | 68066 | 8691 | 40736 | 18639 | 40.4168 | -3.7038 | 2020-05-27 02:32:31 | Madrid, Spain | ||
2548228 | 2548228 | 2020-05-27 | Spain | Madrid | 68066 | 8691 | 40736 | 18639 | 40.4168 | -3.7038 | 2020-05-28 02:32:31 | Madrid, Spain | ||
2712263 | 2712263 | 2020-05-28 | Spain | Madrid | 68451 | 8691 | 40736 | 19024 | 40.4168 | -3.7038 | 2020-05-29 02:32:50 | Madrid, Spain | ||
1790384 | 1790384 | 2020-05-29 | Spain | Madrid | 68597 | 8691 | 40736 | 19170 | 40.4168 | -3.7038 | 2020-05-30 02:32:48 | Madrid, Spain | ||
3638843 | 3638843 | 2020-05-30 | Spain | Madrid | 68740 | 8691 | 40736 | 19313 | 40.4168 | -3.7038 | 2020-05-31 02:32:45 | Madrid, Spain | ||
1793950 | 1793950 | 2020-05-31 | Spain | Madrid | 68830 | 8691 | 40736 | 19403 | 40.4168 | -3.7038 | 2020-06-01 02:32:46 | Madrid, Spain | ||
805359 | 805359 | 2020-06-01 | Spain | Madrid | 68852 | 8691 | 40736 | 19425 | 40.4168 | -3.7038 | 2020-06-02 02:33:08 | Madrid, Spain | ||
2555822 | 2555822 | 2020-06-02 | Spain | Madrid | 68960 | 8691 | 40736 | 19533 | 40.4168 | -3.7038 | 2020-06-03 02:33:13 | Madrid, Spain | ||
3866780 | 3866780 | 2020-06-03 | Spain | Madrid | 69112 | 8691 | 40736 | 19685 | 40.4168 | -3.7038 | 2020-06-04 02:33:14 | Madrid, Spain | ||
1281225 | 1281225 | 2020-06-04 | Spain | Madrid | 69236 | 8691 | 40736 | 19809 | 40.4168 | -3.7038 | 2020-06-05 02:33:06 | Madrid, Spain | ||
1269753 | 1269753 | 2020-06-05 | Spain | Madrid | 69423 | 8691 | 40736 | 19996 | 40.4168 | -3.7038 | 2020-06-06 02:33:00 | Madrid, Spain | ||
574056 | 574056 | 2020-06-06 | Spain | Madrid | 69562 | 8691 | 40736 | 20135 | 40.4168 | -3.7038 | 2020-06-07 03:53:30 | Madrid, Spain | ||
2800000 | 2800000 | 2020-06-07 | Spain | Madrid | 69641 | 8691 | 40736 | 20214 | 40.4168 | -3.7038 | 2020-06-08 03:33:22 | Madrid, Spain | ||
217204 | 217204 | 2020-06-08 | Spain | Madrid | 69695 | 8691 | 40736 | 20268 | 40.4168 | -3.7038 | 2020-06-09 03:33:03 | Madrid, Spain | ||
1210777 | 1210777 | 2020-06-09 | Spain | Madrid | 69804 | 8691 | 40736 | 20377 | 40.4168 | -3.7038 | 2020-06-10 04:07:00 | Madrid, Spain | ||
2863941 | 2863941 | 2020-06-10 | Spain | Madrid | 69895 | 8691 | 40736 | 20468 | 40.4168 | -3.7038 | 2020-06-11 03:33:41 | Madrid, Spain | ||
1273498 | 1273498 | 2020-06-11 | Spain | Madrid | 70051 | 8691 | 40736 | 20624 | 40.4168 | -3.7038 | 2020-06-12 05:09:52 | Madrid, Spain | ||
737528 | 737528 | 2020-06-12 | Spain | Madrid | 70231 | 8691 | 40736 | 20804 | 40.4168 | -3.7038 | 2020-06-13 03:33:14 | Madrid, Spain | ||
3061208 | 3061208 | 2020-06-13 | Spain | Madrid | 70398 | 8691 | 40736 | 20971 | 40.4168 | -3.7038 | 2020-06-14 03:33:15 | Madrid, Spain | ||
1837156 | 1837156 | 2020-06-14 | Spain | Madrid | 70521 | 8691 | 40736 | 21094 | 40.4168 | -3.7038 | 2020-06-15 03:33:14 | Madrid, Spain | ||
287205 | 287205 | 2020-06-15 | Spain | Madrid | 70570 | 8691 | 40736 | 21143 | 40.4168 | -3.7038 | 2020-06-16 04:33:09 | Madrid, Spain | ||
2386642 | 2386642 | 2020-06-16 | Spain | Madrid | 70675 | 8691 | 40736 | 21248 | 40.4168 | -3.7038 | 2020-06-17 04:33:21 | Madrid, Spain | ||
1195879 | 1195879 | 2020-06-17 | Spain | Madrid | 70799 | 8691 | 40736 | 21372 | 40.4168 | -3.7038 | 2020-06-18 04:33:18 | Madrid, Spain | ||
3682676 | 3682676 | 2020-06-18 | Spain | Madrid | 70934 | 8691 | 40736 | 21507 | 40.4168 | -3.7038 | 2020-06-19 04:33:17 | Madrid, Spain | ||
1691527 | 1691527 | 2020-06-19 | Spain | Madrid | 71007 | 8416 | 40736 | 21855 | 40.4168 | -3.7038 | 2020-06-20 04:33:19 | Madrid, Spain | ||
2437949 | 2437949 | 2020-06-20 | Spain | Madrid | 71144 | 8416 | 40736 | 21992 | 40.4168 | -3.7038 | 2020-06-21 04:33:19 | Madrid, Spain | ||
3249356 | 3249356 | 2020-06-21 | Spain | Madrid | 71223 | 8416 | 40736 | 22071 | 40.4168 | -3.7038 | 2020-06-22 04:33:20 | Madrid, Spain | ||
1510617 | 1510617 | 2020-06-22 | Spain | Madrid | 71248 | 8416 | 40736 | 22096 | 40.4168 | -3.7038 | 2020-06-23 04:33:22 | Madrid, Spain | ||
1522423 | 1522423 | 2020-06-23 | Spain | Madrid | 71359 | 8416 | 40736 | 22207 | 40.4168 | -3.7038 | 2020-06-24 04:33:28 | Madrid, Spain | ||
2700738 | 2700738 | 2020-06-24 | Spain | Madrid | 71434 | 8416 | 40736 | 22282 | 40.4168 | -3.7038 | 2020-06-25 05:26:54 | Madrid, Spain | ||
2625098 | 2625098 | 2020-06-25 | Spain | Madrid | 71579 | 8417 | 40736 | 22426 | 40.4168 | -3.7038 | 2020-06-26 04:33:43 | Madrid, Spain | ||
1136111 | 1136111 | 2020-06-26 | Spain | Madrid | 71632 | 8418 | 40736 | 22478 | 40.4168 | -3.7038 | 2020-06-27 04:33:35 | Madrid, Spain | ||
2039830 | 2039830 | 2020-06-27 | Spain | Madrid | 71839 | 8420 | 40736 | 22683 | 40.4168 | -3.7038 | 2020-06-28 04:34:04 | Madrid, Spain | ||
2306495 | 2306495 | 2020-06-28 | Spain | Madrid | 71881 | 8421 | 40736 | 22724 | 40.4168 | -3.7038 | 2020-06-29 04:33:44 | Madrid, Spain | ||
2632932 | 2632932 | 2020-06-29 | Spain | Madrid | 71885 | 8421 | 40736 | 22728 | 40.4168 | -3.7038 | 2020-06-30 04:33:48 | Madrid, Spain | ||
2974455 | 2974455 | 2020-06-30 | Spain | Madrid | 71950 | 8425 | 40736 | 22789 | 40.4168 | -3.7038 | 2020-07-01 04:33:52 | Madrid, Spain | ||
303077 | 303077 | 2020-07-01 | Spain | Madrid | 72033 | 8427 | 40736 | 22870 | 40.4168 | -3.7038 | 2020-07-02 04:33:46 | Madrid, Spain | ||
3045386 | 3045386 | 2020-07-02 | Spain | Madrid | 72096 | 8428 | 40736 | 22932 | 40.4168 | -3.7038 | 2020-07-03 04:33:54 | Madrid, Spain | ||
2234592 | 2234592 | 2020-07-03 | Spain | Madrid | 72168 | 8439 | 40736 | 22993 | 40.4168 | -3.7038 | 2020-07-04 04:33:51 | Madrid, Spain | ||
529931 | 529931 | 2020-07-04 | Spain | Madrid | 72168 | 8439 | 40736 | 22993 | 40.4168 | -3.7038 | 2020-07-05 04:33:46 | Madrid, Spain | ||
415369 | 415369 | 2020-07-05 | Spain | Madrid | 72168 | 8439 | 40736 | 22993 | 40.4168 | -3.7038 | 2020-07-06 04:33:57 | Madrid, Spain | ||
2684904 | 2684904 | 2020-07-06 | Spain | Madrid | 72269 | 8439 | 40736 | 23094 | 40.4168 | -3.7038 | 2020-07-07 04:34:00 | Madrid, Spain | ||
887344 | 887344 | 2020-07-07 | Spain | Madrid | 72336 | 8440 | 40736 | 23160 | 40.4168 | -3.7038 | 2020-07-08 05:33:48 | Madrid, Spain | ||
2222735 | 2222735 | 2020-07-08 | Spain | Madrid | 72409 | 8441 | 40736 | 23232 | 40.4168 | -3.7038 | 2020-07-09 04:34:23 | Madrid, Spain | ||
1005519 | 1005519 | 2020-07-09 | Spain | Madrid | 72469 | 8442 | 40736 | 23291 | 40.4168 | -3.7038 | 2020-07-10 04:34:24 | Madrid, Spain | ||
3237534 | 3237534 | 2020-07-10 | Spain | Madrid | 72532 | 8441 | 40736 | 23355 | 40.4168 | -3.7038 | 2020-07-11 04:34:26 | Madrid, Spain | ||
3436036 | 3436036 | 2020-07-11 | Spain | Madrid | 72532 | 8441 | 40736 | 23355 | 40.4168 | -3.7038 | 2020-07-12 04:34:30 | Madrid, Spain | ||
3737641 | 3737641 | 2020-07-12 | Spain | Madrid | 72532 | 8441 | 40736 | 23355 | 40.4168 | -3.7038 | 2020-07-13 04:43:04 | Madrid, Spain | ||
3491378 | 3491378 | 2020-07-13 | Spain | Madrid | 72649 | 8442 | 40736 | 23471 | 40.4168 | -3.7038 | 2020-07-14 04:34:46 | Madrid, Spain | ||
2158737 | 2158737 | 2020-07-14 | Spain | Madrid | 72695 | 8442 | 40736 | 23517 | 40.4168 | -3.7038 | 2020-07-15 04:34:39 | Madrid, Spain | ||
2748093 | 2748093 | 2020-07-15 | Spain | Madrid | 72797 | 8444 | 40736 | 23617 | 40.4168 | -3.7038 | 2020-07-16 04:44:59 | Madrid, Spain | ||
367425 | 367425 | 2020-07-16 | Spain | Madrid | 72882 | 8445 | 40736 | 23701 | 40.4168 | -3.7038 | 2020-07-17 04:34:50 | Madrid, Spain | ||
2708612 | 2708612 | 2020-07-17 | Spain | Madrid | 73026 | 8446 | 40736 | 23844 | 40.4168 | -3.7038 | 2020-07-18 04:34:45 | Madrid, Spain | ||
3205311 | 3205311 | 2020-07-18 | Spain | Madrid | 73026 | 8446 | 40736 | 23844 | 40.4168 | -3.7038 | 2020-07-19 04:34:58 | Madrid, Spain | ||
121922 | 121922 | 2020-07-19 | Spain | Madrid | 73026 | 8446 | 40736 | 23844 | 40.4168 | -3.7038 | 2020-07-20 05:34:40 | Madrid, Spain | ||
327017 | 327017 | 2020-07-20 | Spain | Madrid | 73296 | 8447 | 40736 | 24113 | 40.4168 | -3.7038 | 2020-07-21 04:38:46 | Madrid, Spain | ||
1707526 | 1707526 | 2020-07-21 | Spain | Madrid | 73445 | 8448 | 40736 | 24261 | 40.4168 | -3.7038 | 2020-07-22 04:34:42 | Madrid, Spain | ||
844787 | 844787 | 2020-07-22 | Spain | Madrid | 73552 | 8449 | 40736 | 24367 | 40.4168 | -3.7038 | 2020-07-23 05:15:04 | Madrid, Spain | ||
61985 | 61985 | 2020-07-23 | Spain | Madrid | 73767 | 8450 | 40736 | 24581 | 40.4168 | -3.7038 | 2020-07-24 05:30:40 | Madrid, Spain | ||
2563767 | 2563767 | 2020-07-24 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-25 04:47:39 | Madrid, Spain | ||
1502797 | 1502797 | 2020-07-25 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-26 04:35:00 | Madrid, Spain | ||
442553 | 442553 | 2020-07-26 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-27 04:35:02 | Madrid, Spain | ||
177240 | 177240 | 2020-07-27 | Spain | Madrid | 74700 | 8451 | 40736 | 25513 | 40.4168 | -3.7038 | 2020-07-28 04:58:43 | Madrid, Spain | ||
3185189 | 3185189 | 2020-07-28 | Spain | Madrid | 74886 | 8451 | 40736 | 25699 | 40.4168 | -3.7038 | 2020-07-29 04:35:11 | Madrid, Spain | ||
2958573 | 2958573 | 2020-07-29 | Spain | Madrid | 75110 | 8452 | 40736 | 25922 | 40.4168 | -3.7038 | 2020-07-30 04:35:05 | Madrid, Spain | ||
1928405 | 1928405 | 2020-07-30 | Spain | Madrid | 75552 | 8452 | 40736 | 26364 | 40.4168 | -3.7038 | 2020-07-31 04:35:18 | Madrid, Spain | ||
3264698 | 3264698 | 2020-07-31 | Spain | Madrid | 76145 | 8453 | 40736 | 26956 | 40.4168 | -3.7038 | 2020-08-01 04:36:27 | Madrid, Spain | ||
753533 | 753533 | 2020-08-01 | Spain | Madrid | 76145 | 8453 | 40736 | 26956 | 40.4168 | -3.7038 | 2020-08-02 04:34:47 | Madrid, Spain | ||
2807965 | 2807965 | 2020-08-02 | Spain | Madrid | 76145 | 8453 | 40736 | 26956 | 40.4168 | -3.7038 | 2020-08-03 04:34:35 | Madrid, Spain | ||
2740213 | 2740213 | 2020-08-03 | Spain | Madrid | 76145 | 8453 | 40736 | 26956 | 40.4168 | -3.7038 | 2020-08-04 04:41:59 | Madrid, Spain | ||
98330 | 98330 | 2020-08-04 | Spain | Madrid | 77918 | 8457 | 40736 | 28725 | 40.4168 | -3.7038 | 2020-08-05 04:34:43 | Madrid, Spain | ||
3793094 | 3793094 | 2020-08-05 | Spain | Madrid | 78531 | 8457 | 40736 | 29338 | 40.4168 | -3.7038 | 2020-08-06 04:35:02 | Madrid, Spain | ||
3612264 | 3612264 | 2020-08-06 | Spain | Madrid | 79262 | 8457 | 40736 | 30069 | 40.4168 | -3.7038 | 2020-08-07 04:35:11 | Madrid, Spain | ||
458579 | 458579 | 2020-08-07 | Spain | Madrid | 80673 | 8458 | 40736 | 31479 | 40.4168 | -3.7038 | 2020-08-08 04:34:53 | Madrid, Spain | ||
371395 | 371395 | 2020-08-08 | Spain | Madrid | 80673 | 8458 | 40736 | 31479 | 40.4168 | -3.7038 | 2020-08-09 04:34:54 | Madrid, Spain | ||
3923227 | 3923227 | 2020-08-09 | Spain | Madrid | 80673 | 8458 | 40736 | 31479 | 40.4168 | -3.7038 | 2020-08-10 04:34:55 | Madrid, Spain | ||
1920418 | 1920418 | 2020-08-10 | Spain | Madrid | 83120 | 8464 | 40736 | 33920 | 40.4168 | -3.7038 | 2020-08-11 04:35:08 | Madrid, Spain | ||
662592 | 662592 | 2020-08-11 | Spain | Madrid | 83606 | 8464 | 40736 | 34406 | 40.4168 | -3.7038 | 2020-08-12 04:27:29 | Madrid, Spain | ||
3531743 | 3531743 | 2020-08-12 | Spain | Madrid | 83606 | 8464 | 40736 | 34406 | 40.4168 | -3.7038 | 2020-08-13 04:29:15 | Madrid, Spain | ||
583124 | 583124 | 2020-08-13 | Spain | Madrid | 86752 | 8471 | 40736 | 37545 | 40.4168 | -3.7038 | 2020-08-14 04:51:19 | Madrid, Spain | ||
1612540 | 1612540 | 2020-08-14 | Spain | Madrid | 87967 | 8481 | 40736 | 38750 | 40.4168 | -3.7038 | 2020-08-15 04:27:31 | Madrid, Spain | ||
146265 | 146265 | 2020-08-15 | Spain | Madrid | 87967 | 8481 | 40736 | 38750 | 40.4168 | -3.7038 | 2020-08-16 04:27:42 | Madrid, Spain | ||
1556263 | 1556263 | 2020-08-16 | Spain | Madrid | 87967 | 8481 | 40736 | 38750 | 40.4168 | -3.7038 | 2020-08-17 04:27:20 | Madrid, Spain | ||
837905 | 837905 | 2020-08-17 | Spain | Madrid | 93359 | 8488 | 40736 | 44135 | 40.4168 | -3.7038 | 2020-08-18 04:27:56 | Madrid, Spain | ||
3178301 | 3178301 | 2020-08-18 | Spain | Madrid | 94978 | 8503 | 40736 | 45739 | 40.4168 | -3.7038 | 2020-08-19 04:27:00 | Madrid, Spain | ||
206547 | 206547 | 2020-08-19 | Spain | Madrid | 97185 | 8518 | 40736 | 47931 | 40.4168 | -3.7038 | 2020-08-20 04:27:43 | Madrid, Spain | ||
3484598 | 3484598 | 2020-08-20 | Spain | Madrid | 99529 | 8526 | 40736 | 50267 | 40.4168 | -3.7038 | 2020-08-21 04:27:41 | Madrid, Spain | ||
1479849 | 1479849 | 2020-08-21 | Spain | Madrid | 102382 | 8537 | 40736 | 53109 | 40.4168 | -3.7038 | 2020-08-22 04:27:49 | 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]);