johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where province_or_state = "Madrid" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, last_update, day (date), last_update (date)
deaths 482 ✖
- 8691 24
- 18185 12
- 19977 8
- 19059 7
- 19815 7
- 19841 7
- 19896 7
- 19947 7
- 19956 7
- 19979 7
- 19991 7
- 20122 7
- 20181 7
- 20223 7
- 8416 6
- 16370 6
- 19930 6
- 16281 5
- 18716 5
- 18738 5
- 8439 4
- 8441 4
- 8450 4
- 8453 4
- 11687 4
- 11828 4
- 14412 4
- 14496 4
- 14705 4
- 15378 4
- 15419 4
- 16207 4
- 16302 4
- 16373 4
- 16634 4
- 17373 4
- 17567 4
- 17709 4
- 17848 4
- 18017 4
- 18422 4
- 18542 4
- 18683 4
- 18701 4
- 18711 4
- 18768 4
- 18794 4
- 18819 4
- 18845 4
- 18919 4
- 18972 4
- 18991 4
- 19001 4
- 19038 4
- 19050 4
- 19057 4
- 19099 4
- 19135 4
- 19228 4
- 19577 4
- 19689 4
- 19736 4
- 8442 3
- 8446 3
- 8457 3
- 8458 3
- 8464 3
- 8481 3
- 8537 3
- 8604 3
- 8728 3
- 8818 3
- 8999 3
- 9213 3
- 9473 3
- 9739 3
- 9979 3
- 10211 3
- 10419 3
- 10842 3
- 11053 3
- 11201 3
- 11352 3
- 11426 3
- 11537 3
- 11637 3
- 11971 3
- 12040 3
- 12266 3
- 12578 3
- 12833 3
- 13255 3
- 13538 3
- 13842 3
- 14104 3
- 14313 3
- 14579 3
- 14803 3
- 14905 3
- 14994 3
- 15087 3
- 15164 3
- 15201 3
- 15285 3
- 15341 3
- 15402 3
- 15458 3
- 15479 3
- 15502 3
- 15508 3
- 15531 3
- 15587 3
- 15666 3
- 15754 3
- 15787 3
- 15918 3
- 15984 3
- 16027 3
- 16078 3
- 16101 3
- 16138 3
- 16159 3
- 16169 3
- 16238 3
- 16265 3
- 16289 3
- 16325 3
- 16342 3
- 16381 3
- 16422 3
- 16477 3
- 16535 3
- 16846 3
- 17071 3
- 17450 3
- 17636 3
- 17803 3
- 17952 3
- 18071 3
- 18498 3
- 18608 3
- 18627 3
- 18779 3
- 18800 3
- 18827 3
- 18880 3
- 18935 3
- 18985 3
- 19006 3
- 19024 3
- 19028 3
- 19037 3
- 19072 3
- 19112 3
- 19181 3
- 19292 3
- 19634 3
- 19715 3
- 19783 3
- 8421 2
- 8451 2
- 8452 2
- 8826 2
- 9246 2
- 10850 2
- 11445 2
- 11888 2
- 14469 2
- 14578 2
- 14811 2
- 15307 2
- 15393 2
- 15469 2
- 15509 2
- 16145 2
- 16167 2
- 16246 2
- 16303 2
- 16356 2
- 16378 2
- 17433 2
- 18366 2
- 18747 2
- 8417 1
- 8418 1
- 8420 1
- 8425 1
- 8427 1
- 8428 1
- 8440 1
- 8444 1
- 8445 1
- 8447 1
- 8448 1
- 8449 1
- 8471 1
- 8488 1
- 8503 1
- 8518 1
- 8526 1
- 8546 1
- 8580 1
- 8592 1
- 8600 1
- 8648 1
- 8662 1
- 8676 1
- 8686 1
- 8692 1
- 8748 1
- 8779 1
- 8780 1
- 8782 1
- 8809 1
- 8817 1
- 8843 1
- 8863 1
- 8894 1
- 8912 1
- 8925 1
- 8931 1
- 8944 1
- 8955 1
- 8956 1
- 8970 1
- 8977 1
- 9023 1
- 9129 1
- 9161 1
- 9190 1
- 9409 1
- 9450 1
- 9502 1
- 9628 1
- 9634 1
- 9637 1
- 9786 1
- 9789 1
- 9837 1
- 9876 1
- 10014 1
- 10059 1
- 10123 1
- 10155 1
- 10247 1
- 10327 1
- 10350 1
- 10403 1
- 10434 1
- 10438 1
- 10747 1
- 10821 1
- 10946 1
- 11011 1
- 11082 1
- 11111 1
- 11158 1
- 11181 1
- 11211 1
- 11250 1
- 11279 1
- 11349 1
- 11359 1
- 11369 1
- 11380 1
- 11413 1
- 11449 1
- 11497 1
- 11556 1
- 11590 1
- 11619 1
- 11635 1
- 11660 1
- 11680 1
- 11683 1
- 11692 1
- 11753 1
- 11827 1
- 11834 1
- 11953 1
- 11996 1
- 12001 1
- 12006 1
- 12020 1
- 12054 1
- 12100 1
- 12149 1
- 12210 1
- 12372 1
- 12425 1
- 12479 1
- 12535 1
- 12610 1
- 12669 1
- 12741 1
- 12804 1
- 12924 1
- 13025 1
- 13080 1
- 13179 1
- 13310 1
- 13381 1
- 13408 1
- 13461 1
- 13631 1
- 13662 1
- 13713 1
- 13793 1
- 13874 1
- 13945 1
- 14015 1
- 14068 1
- 14123 1
- 14211 1
- 14250 1
- 14278 1
- 14337 1
- 14354 1
- 14388 1
- 14431 1
- 14512 1
- 14548 1
- 14564 1
- 14648 1
- 14662 1
- 14689 1
- 14732 1
- 14769 1
- 14785 1
- 14871 1
- 14889 1
- 14916 1
- 14954 1
- 14969 1
- 14990 1
- 15015 1
- 15016 1
- 15041 1
- 15075 1
- 15105 1
- 15135 1
- 15155 1
- 15162 1
- 15170 1
- 15189 1
- 15196 1
- 15199 1
- 15205 1
- 15243 1
- 15267 1
- 15277 1
- 15287 1
- 15295 1
- 15351 1
- 15364 1
- 15373 1
- 15376 1
- 15388 1
- 15408 1
- 15409 1
- 15412 1
- 15420 1
- 15440 1
- 15450 1
- 15453 1
- 15466 1
- 15476 1
- 15483 1
- 15486 1
- 15487 1
- 15494 1
- 15501 1
- 15505 1
- 15506 1
- 15511 1
- 15520 1
- 15529 1
- 15533 1
- 15550 1
- 15563 1
- 15577 1
- 15616 1
- 15624 1
- 15642 1
- 15656 1
- 15667 1
- 15689 1
- 15731 1
- 15746 1
- 15756 1
- 15764 1
- 15773 1
- 15780 1
- 15792 1
- 15840 1
- 15884 1
- 15901 1
- 15935 1
- 15953 1
- 15963 1
- 15971 1
- 15991 1
- 16011 1
- 16014 1
- 16017 1
- 16039 1
- 16051 1
- 16070 1
- 16073 1
- 16080 1
- 16090 1
- 16094 1
- 16096 1
- 16113 1
- 16126 1
- 16130 1
- 16133 1
- 16150 1
- 16155 1
- 16165 1
- 16166 1
- 16172 1
- 16178 1
- 16181 1
- 16186 1
- 16230 1
- 16235 1
- 16236 1
- 16254 1
- 16258 1
- 16270 1
- 16275 1
- 16278 1
- 16280 1
- 16286 1
- 16288 1
- 16290 1
- 16295 1
- 16296 1
- 16299 1
- 16315 1
- 16327 1
- 16330 1
- 16335 1
- 16336 1
- 16343 1
- 16372 1
- 16376 1
- 16377 1
- 16389 1
- 16399 1
- 16403 1
- 16414 1
- 16439 1
- 16462 1
- 16466 1
- 16475 1
- 16482 1
- 16494 1
- 16507 1
- 16521 1
- 16568 1
- 16595 1
- 16615 1
- 16710 1
- 16722 1
- 16761 1
- 16793 1
- 16876 1
- 16896 1
- 16925 1
- 16978 1
- 17139 1
- 17183 1
- 17198 1
- 17299 1
- 17443 1
- 17479 1
- 17501 1
- 17546 1
- 17555 1
- 18721 1
province_or_state 1
- Madrid · 960 ✖
country_or_region 1
- Spain 960
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
2700738 | 2700738 | 2020-06-24 | Spain | Madrid | 71434 | 8416 | 40736 | 22282 | 40.4168 | -3.7038 | 2020-06-25 05:26:54 | 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 | ||
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 | ||
415369 | 415369 | 2020-07-05 | Spain | Madrid | 72168 | 8439 | 40736 | 22993 | 40.4168 | -3.7038 | 2020-07-06 04:33:57 | 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 | ||
2234592 | 2234592 | 2020-07-03 | Spain | Madrid | 72168 | 8439 | 40736 | 22993 | 40.4168 | -3.7038 | 2020-07-04 04:33:51 | 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 | ||
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 | ||
1005519 | 1005519 | 2020-07-09 | Spain | Madrid | 72469 | 8442 | 40736 | 23291 | 40.4168 | -3.7038 | 2020-07-10 04:34:24 | 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 | ||
3491378 | 3491378 | 2020-07-13 | Spain | Madrid | 72649 | 8442 | 40736 | 23471 | 40.4168 | -3.7038 | 2020-07-14 04:34:46 | 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 | ||
121922 | 121922 | 2020-07-19 | Spain | Madrid | 73026 | 8446 | 40736 | 23844 | 40.4168 | -3.7038 | 2020-07-20 05:34:40 | 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 | ||
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 | ||
442553 | 442553 | 2020-07-26 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-27 04:35:02 | 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 | ||
2563767 | 2563767 | 2020-07-24 | Spain | Madrid | 73944 | 8450 | 40736 | 24758 | 40.4168 | -3.7038 | 2020-07-25 04:47:39 | 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 | ||
1928405 | 1928405 | 2020-07-30 | Spain | Madrid | 75552 | 8452 | 40736 | 26364 | 40.4168 | -3.7038 | 2020-07-31 04:35:18 | 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 | ||
753533 | 753533 | 2020-08-01 | Spain | Madrid | 76145 | 8453 | 40736 | 26956 | 40.4168 | -3.7038 | 2020-08-02 04:34:47 | 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 | ||
2807965 | 2807965 | 2020-08-02 | Spain | Madrid | 76145 | 8453 | 40736 | 26956 | 40.4168 | -3.7038 | 2020-08-03 04:34:35 | 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 | ||
98330 | 98330 | 2020-08-04 | Spain | Madrid | 77918 | 8457 | 40736 | 28725 | 40.4168 | -3.7038 | 2020-08-05 04:34:43 | 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 | ||
3793094 | 3793094 | 2020-08-05 | Spain | Madrid | 78531 | 8457 | 40736 | 29338 | 40.4168 | -3.7038 | 2020-08-06 04:35:02 | 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 | ||
458579 | 458579 | 2020-08-07 | Spain | Madrid | 80673 | 8458 | 40736 | 31479 | 40.4168 | -3.7038 | 2020-08-08 04:34:53 | 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 | ||
662592 | 662592 | 2020-08-11 | Spain | Madrid | 83606 | 8464 | 40736 | 34406 | 40.4168 | -3.7038 | 2020-08-12 04:27:29 | 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 | ||
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 | ||
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 | ||
1612540 | 1612540 | 2020-08-14 | Spain | Madrid | 87967 | 8481 | 40736 | 38750 | 40.4168 | -3.7038 | 2020-08-15 04:27:31 | 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 | ||
2215960 | 2215960 | 2020-08-23 | Spain | Madrid | 102382 | 8537 | 40736 | 53109 | 40.4168 | -3.7038 | 2020-08-24 04:27:56 | Madrid, Spain | ||
2299742 | 2299742 | 2020-08-22 | Spain | Madrid | 102382 | 8537 | 40736 | 53109 | 40.4168 | -3.7038 | 2020-08-23 04:27:48 | Madrid, Spain | ||
2991565 | 2991565 | 2020-08-24 | Spain | Madrid | 108374 | 8546 | 40736 | 59092 | 40.4168 | -3.7038 | 2020-08-25 04:28:02 | Madrid, Spain | ||
3562861 | 3562861 | 2020-08-25 | Spain | Madrid | 110300 | 8580 | 40736 | 60984 | 40.4168 | -3.7038 | 2020-08-26 04:28:11 | Madrid, Spain | ||
1996937 | 1996937 | 2020-08-26 | Spain | Madrid | 112514 | 8592 | 40736 | 63186 | 40.4168 | -3.7038 | 2020-08-27 04:28:15 | 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 | ||
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 | ||
194360 | 194360 | 2020-08-31 | Spain | Madrid | 126057 | 8648 | 40736 | 76673 | 40.4168 | -3.7038 | 2020-09-01 04:28:31 | 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 | ||
1105846 | 1105846 | 2020-09-02 | Spain | Madrid | 130579 | 8676 | 40736 | 81167 | 40.4168 | -3.7038 | 2020-09-03 04:28:22 | 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 | ||
217204 | 217204 | 2020-06-08 | Spain | Madrid | 69695 | 8691 | 40736 | 20268 | 40.4168 | -3.7038 | 2020-06-09 03:33:03 | 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 | ||
574056 | 574056 | 2020-06-06 | Spain | Madrid | 69562 | 8691 | 40736 | 20135 | 40.4168 | -3.7038 | 2020-06-07 03:53:30 | 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 | ||
805359 | 805359 | 2020-06-01 | Spain | Madrid | 68852 | 8691 | 40736 | 19425 | 40.4168 | -3.7038 | 2020-06-02 02:33:08 | 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 | ||
1195879 | 1195879 | 2020-06-17 | Spain | Madrid | 70799 | 8691 | 40736 | 21372 | 40.4168 | -3.7038 | 2020-06-18 04:33:18 | 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 | ||
1269753 | 1269753 | 2020-06-05 | Spain | Madrid | 69423 | 8691 | 40736 | 19996 | 40.4168 | -3.7038 | 2020-06-06 02:33:00 | 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 | ||
1281225 | 1281225 | 2020-06-04 | Spain | Madrid | 69236 | 8691 | 40736 | 19809 | 40.4168 | -3.7038 | 2020-06-05 02:33:06 | 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 | ||
1793950 | 1793950 | 2020-05-31 | Spain | Madrid | 68830 | 8691 | 40736 | 19403 | 40.4168 | -3.7038 | 2020-06-01 02:32:46 | 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 | ||
2386642 | 2386642 | 2020-06-16 | Spain | Madrid | 70675 | 8691 | 40736 | 21248 | 40.4168 | -3.7038 | 2020-06-17 04:33:21 | 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 | ||
2555822 | 2555822 | 2020-06-02 | Spain | Madrid | 68960 | 8691 | 40736 | 19533 | 40.4168 | -3.7038 | 2020-06-03 02:33:13 | 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 | ||
2800000 | 2800000 | 2020-06-07 | Spain | Madrid | 69641 | 8691 | 40736 | 20214 | 40.4168 | -3.7038 | 2020-06-08 03:33:22 | 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 | ||
3061208 | 3061208 | 2020-06-13 | Spain | Madrid | 70398 | 8691 | 40736 | 20971 | 40.4168 | -3.7038 | 2020-06-14 03:33:15 | 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 | ||
3682676 | 3682676 | 2020-06-18 | Spain | Madrid | 70934 | 8691 | 40736 | 21507 | 40.4168 | -3.7038 | 2020-06-19 04:33:17 | 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]);