johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,298 rows where country_or_region = "Spain" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2021-04-25 399
- 2022-05-26 40
- 2022-04-13 38
- 2020-05-20 20
- 2020-05-21 20
- 2020-05-22 20
- 2020-05-23 20
- 2020-05-24 20
- 2020-05-25 20
- 2020-05-26 20
- 2020-05-27 20
- 2020-05-28 20
- 2020-05-29 20
- 2020-05-30 20
- 2020-05-31 20
- 2020-06-01 20
- 2020-06-02 20
- 2020-06-03 20
- 2020-06-04 20
- 2020-06-05 20
- 2020-06-06 20
- 2020-06-07 20
- 2020-06-08 20
- 2020-06-09 20
- 2020-06-10 20
- 2020-06-11 20
- 2020-06-12 20
- 2020-06-13 20
- 2020-06-14 20
- 2020-06-15 20
- …
longitude 24 ✖
province_or_state 20
- Andalusia 960
- Aragon 960
- Asturias 960
- Baleares 960
- C. Valenciana 960
- Canarias 960
- Cantabria 960
- Castilla - La Mancha 960
- Castilla y Leon 960
- Catalonia 960
- Ceuta 960
- Extremadura 960
- Galicia 960
- La Rioja 960
- Madrid 960
- Melilla 960
- Murcia 960
- Navarra 960
- Pais Vasco 960
- Unknown 955
country_or_region 1
- Spain · 19,298 ✖
Link | rowid | day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3413197 | 3413197 | 2020-02-01 | Spain | 1 | 0 | 0 | 2/1/2020 2:13 | |||||||
2379285 | 2379285 | 2020-02-02 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
2860601 | 2860601 | 2020-02-03 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
3471939 | 3471939 | 2020-02-04 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
2091722 | 2091722 | 2020-02-05 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
566729 | 566729 | 2020-02-06 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
3222061 | 3222061 | 2020-02-07 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
1366102 | 1366102 | 2020-02-08 | Spain | 1 | 0 | 0 | 2020-02-01T23:43:02 | |||||||
3362423 | 3362423 | 2020-02-09 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
3089054 | 3089054 | 2020-02-10 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
3197755 | 3197755 | 2020-02-11 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
2567296 | 2567296 | 2020-02-12 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
1559706 | 1559706 | 2020-02-13 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
1192499 | 1192499 | 2020-02-14 | Spain | 2 | 0 | 0 | 2020-02-09T20:33:03 | |||||||
107080 | 107080 | 2020-02-15 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1888754 | 1888754 | 2020-02-16 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1243401 | 1243401 | 2020-02-17 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1783127 | 1783127 | 2020-02-18 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1720096 | 1720096 | 2020-02-19 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
2263504 | 2263504 | 2020-02-20 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
2135765 | 2135765 | 2020-02-21 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
1085683 | 1085683 | 2020-02-22 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
3173394 | 3173394 | 2020-02-23 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
3551250 | 3551250 | 2020-02-24 | Spain | 2 | 0 | 2 | 2020-02-15T17:23:04 | |||||||
479179 | 479179 | 2020-02-25 | Spain | 6 | 0 | 2 | 2020-02-25T21:33:02 | |||||||
2509791 | 2509791 | 2020-02-26 | Spain | 13 | 0 | 2 | 2020-02-26T20:43:02 | |||||||
617435 | 617435 | 2020-02-27 | Spain | 15 | 0 | 2 | 2020-02-27T13:23:02 | |||||||
2883948 | 2883948 | 2020-02-28 | Spain | 32 | 0 | 2 | 2020-02-28T15:33:03 | |||||||
3205821 | 3205821 | 2020-02-29 | Spain | 45 | 0 | 2 | 2020-02-29T19:13:08 | |||||||
562528 | 562528 | 2020-03-01 | Spain | 84 | 0 | 2 | 40.0 | -4.0 | 2020-03-01T23:33:03 | |||||
1152663 | 1152663 | 2020-03-02 | Spain | 120 | 0 | 2 | 40.0 | -4.0 | 2020-03-02T14:43:05 | |||||
261043 | 261043 | 2020-03-03 | Spain | 165 | 1 | 2 | 40.0 | -4.0 | 2020-03-03T23:53:03 | |||||
98826 | 98826 | 2020-03-04 | Spain | 222 | 2 | 2 | 40.0 | -4.0 | 2020-03-04T20:43:02 | |||||
40154 | 40154 | 2020-03-05 | Spain | 259 | 3 | 2 | 40.0 | -4.0 | 2020-03-05T17:43:03 | |||||
3177495 | 3177495 | 2020-03-06 | Spain | 400 | 5 | 2 | 40.0 | -4.0 | 2020-03-06T20:13:13 | |||||
62488 | 62488 | 2020-03-07 | Spain | 500 | 10 | 30 | 40.0 | -4.0 | 2020-03-07T17:43:05 | |||||
1527213 | 1527213 | 2020-03-08 | Spain | 673 | 17 | 30 | 40.0 | -4.0 | 2020-03-08T20:33:02 | |||||
657692 | 657692 | 2020-03-09 | Spain | 1073 | 28 | 32 | 40.0 | -4.0 | 2020-03-09T18:13:11 | |||||
3752819 | 3752819 | 2020-03-10 | Spain | 1695 | 35 | 32 | 40.0 | -4.0 | 2020-03-10T23:53:02 | |||||
2127435 | 2127435 | 2020-03-11 | Spain | 2277 | 54 | 183 | 40.0 | -4.0 | 2020-03-11T20:53:02 | |||||
2282865 | 2282865 | 2020-03-12 | Spain | 2277 | 55 | 183 | 40.0 | -4.0 | 2020-03-12T01:17:58 | |||||
3765434 | 3765434 | 2020-03-13 | Spain | 5232 | 133 | 193 | 40.4637 | -3.7492 | 2020-03-11T20:00:00 | |||||
2111090 | 2111090 | 2020-03-14 | Spain | 6391 | 195 | 517 | 40.4637 | -3.7492 | 2020-03-14T22:13:11 | |||||
1463465 | 1463465 | 2020-03-15 | Spain | 7798 | 289 | 517 | 40.4637 | -3.7492 | 2020-03-15T18:20:18 | |||||
2255115 | 2255115 | 2020-03-16 | Spain | 9942 | 342 | 530 | 40.4637 | -3.7492 | 2020-03-16T20:13:11 | |||||
3891309 | 3891309 | 2020-03-17 | Spain | 11748 | 533 | 1028 | 40.4637 | -3.7492 | 2020-03-17T20:53:02 | |||||
1176878 | 1176878 | 2020-03-18 | Spain | 13910 | 623 | 1081 | 40.4637 | -3.7492 | 2020-03-18T13:13:13 | |||||
1526874 | 1526874 | 2020-03-19 | Spain | 17963 | 830 | 1107 | 40.4637 | -3.7492 | 2020-03-19T20:13:08 | |||||
3733922 | 3733922 | 2020-03-20 | Spain | 20410 | 1043 | 1588 | 40.4637 | -3.7492 | 2020-03-20T17:43:03 | |||||
339625 | 339625 | 2020-03-21 | Spain | 25374 | 1375 | 2125 | 40.4637 | -3.7492 | 2020-03-21T13:13:30 | |||||
2910638 | 2910638 | 2020-03-22 | Spain | 28603 | 1756 | 2125 | 24722 | 40.463667 | -3.74922 | 3/22/20 23:45 | Spain | |||
2147250 | 2147250 | 2020-03-23 | Spain | 35136 | 2311 | 3355 | 29470 | 40.463667 | -3.7492199999999998 | 2020-03-23 23:19:21 | Spain | |||
1479196 | 1479196 | 2020-03-24 | Spain | 39885 | 2808 | 3794 | 33283 | 40.463667 | -3.7492199999999998 | 2020-03-24 23:37:15 | Spain | |||
1132692 | 1132692 | 2020-03-25 | Spain | 49515 | 3647 | 5367 | 40501 | 40.463667 | -3.7492199999999998 | 2020-03-25 23:33:04 | Spain | |||
919292 | 919292 | 2020-03-26 | Spain | 57786 | 4365 | 7015 | 46406 | 40.463667 | -3.7492199999999998 | 2020-03-26 23:48:18 | Spain | |||
809200 | 809200 | 2020-03-27 | Spain | 65719 | 5138 | 9357 | 51224 | 40.463667 | -3.7492199999999998 | 2020-03-27 23:23:03 | Spain | |||
3947152 | 3947152 | 2020-03-28 | Spain | 73235 | 5982 | 12285 | 54968 | 40.463667 | -3.74922 | 3/28/20 23:05 | Spain | |||
2875816 | 2875816 | 2020-03-29 | Spain | 80110 | 6803 | 14709 | 58598 | 40.463667 | -3.74922 | 3/29/20 23:08 | Spain | |||
1872580 | 1872580 | 2020-03-30 | Spain | 87956 | 7716 | 16780 | 63460 | 40.463667 | -3.74922 | 3/30/20 22:52 | Spain | |||
3816030 | 3816030 | 2020-03-31 | Spain | 95923 | 8464 | 19259 | 68200 | 40.463667 | -3.7492199999999998 | 2020-03-31 23:43:43 | Spain | |||
3364937 | 3364937 | 2020-04-01 | Spain | 104118 | 9387 | 22647 | 72084 | 40.463667 | -3.7492199999999998 | 2020-04-01 21:58:34 | Spain | |||
3701734 | 3701734 | 2020-04-02 | Spain | 112065 | 10348 | 26743 | 74974 | 40.463667 | -3.74922 | 4/2/20 23:25 | Spain | |||
3740704 | 3740704 | 2020-04-03 | Spain | 119199 | 11198 | 30513 | 77488 | 40.463667 | -3.7492199999999998 | 2020-04-03 22:46:20 | Spain | |||
1750893 | 1750893 | 2020-04-04 | Spain | 126168 | 11947 | 34219 | 80002 | 40.463667 | -3.74922 | 4/4/20 23:34 | Spain | |||
589251 | 589251 | 2020-04-05 | Spain | 131646 | 12641 | 38080 | 80925 | 40.463667 | -3.7492199999999998 | 2020-04-05 23:06:26 | Spain | |||
3627564 | 3627564 | 2020-04-06 | Spain | 136675 | 13341 | 40437 | 82897 | 40.463667 | -3.74922 | 4/6/20 23:21 | Spain | |||
3021882 | 3021882 | 2020-04-07 | Spain | 141942 | 14045 | 43208 | 84689 | 40.463667 | -3.7492199999999998 | 2020-04-07 23:04:29 | Spain | |||
3562207 | 3562207 | 2020-04-08 | Spain | 148220 | 14792 | 48021 | 85407 | 40.463667 | -3.7492199999999998 | 2020-04-08 22:51:39 | Spain | |||
3950100 | 3950100 | 2020-04-09 | Spain | 153222 | 15447 | 52165 | 85610 | 40.463667 | -3.7492199999999998 | 2020-04-09 23:02:19 | Spain | |||
1250363 | 1250363 | 2020-04-10 | Spain | 158273 | 16081 | 55668 | 86524 | 40.463667 | -3.7492199999999998 | 2020-04-10 22:53:48 | Spain | |||
2567178 | 2567178 | 2020-04-11 | Spain | 163027 | 16606 | 59109 | 87312 | 40.463667 | -3.7492199999999998 | 2020-04-11 22:45:13 | Spain | |||
2578341 | 2578341 | 2020-04-12 | Spain | 166831 | 17209 | 62391 | 87231 | 40.463667 | -3.74922 | 2020-04-12 23:17:00 | Spain | |||
43315 | 43315 | 2020-04-13 | Spain | 170099 | 17756 | 64727 | 87616 | 40.463667 | -3.7492199999999998 | 2020-04-13 23:07:34 | Spain | |||
3338218 | 3338218 | 2020-04-14 | Spain | 172541 | 18056 | 67504 | 86981 | 40.463667 | -3.7492199999999998 | 2020-04-14 23:33:12 | Spain | |||
860302 | 860302 | 2020-04-15 | Spain | 177644 | 18708 | 70853 | 88083 | 40.463667 | -3.7492199999999998 | 2020-04-15 22:56:32 | Spain | |||
934408 | 934408 | 2020-04-16 | Spain | 184948 | 19315 | 74797 | 90836 | 40.463667 | -3.7492199999999998 | 2020-04-16 23:30:31 | Spain | |||
50414 | 50414 | 2020-04-17 | Spain | 190839 | 20002 | 74797 | 96040 | 40.463667 | -3.7492199999999998 | 2020-04-17 23:30:32 | Spain | |||
418942 | 418942 | 2020-04-18 | Spain | 191726 | 20043 | 74797 | 96886 | 40.463667 | -3.74922 | 2020-04-18 22:32:28 | Spain | |||
1385254 | 1385254 | 2020-04-19 | Spain | 198674 | 20453 | 77357 | 100864 | 40.463667 | -3.74922 | 2020-04-19 23:40:41 | Spain | |||
2473562 | 2473562 | 2020-04-20 | Spain | 200210 | 20852 | 80587 | 98771 | 40.463667 | -3.7492199999999998 | 2020-04-20 23:36:27 | Spain | |||
522480 | 522480 | 2020-04-21 | Spain | 204178 | 21282 | 82514 | 100382 | 40.463667 | -3.7492199999999998 | 2020-04-21 23:30:30 | Spain | |||
1199414 | 1199414 | 2020-04-22 | Spain | 208389 | 21717 | 85915 | 100757 | 40.463667 | -3.7492199999999998 | 2020-04-22 23:30:32 | Spain | |||
2524964 | 2524964 | 2020-04-23 | Spain | 213024 | 22157 | 89250 | 101617 | 40.463667 | -3.7492199999999998 | 2020-04-24 03:30:31 | Spain | |||
1459375 | 1459375 | 2020-04-24 | Spain | 219764 | 22524 | 92355 | 104885 | 40.463667 | -3.7492199999999998 | 2020-04-25 06:30:33 | Spain | |||
3502974 | 3502974 | 2020-04-25 | Spain | 223759 | 22902 | 95708 | 105149 | 40.463667 | -3.7492199999999998 | 2020-04-26 02:30:31 | Spain | |||
3592625 | 3592625 | 2020-04-26 | Spain | 226629 | 23190 | 117727 | 85712 | 40.463667 | -3.7492199999999998 | 2020-04-27 02:30:33 | Spain | |||
3589447 | 3589447 | 2020-04-27 | Spain | 229422 | 23521 | 120832 | 85069 | 40.463667 | -3.7492199999999998 | 2020-04-28 02:30:32 | Spain | |||
271792 | 271792 | 2020-04-28 | Spain | 232128 | 23822 | 123903 | 84403 | 40.463667 | -3.7492199999999998 | 2020-04-29 02:32:29 | Spain | |||
137578 | 137578 | 2020-04-29 | Spain | 236899 | 24275 | 132929 | 79695 | 40.463667 | -3.7492199999999998 | 2020-04-30 02:32:27 | Spain | |||
228832 | 228832 | 2020-04-30 | Spain | 213435 | 24543 | 112050 | 76842 | 40.463667 | -3.74922 | 2020-05-01 02:32:28 | Spain | |||
1184351 | 1184351 | 2020-05-01 | Spain | 213435 | 24543 | 112050 | 76842 | 40.463667 | -3.74922 | 2020-05-02 02:32:27 | Spain | |||
2043457 | 2043457 | 2020-05-02 | Spain | 216582 | 25100 | 117248 | 74234 | 40.463667 | -3.74922 | 2020-05-03 02:32:28 | Spain | |||
2278781 | 2278781 | 2020-05-03 | Spain | 217466 | 25264 | 118902 | 73300 | 40.463667 | -3.74922 | 2020-05-04 02:32:28 | Spain | |||
3084922 | 3084922 | 2020-05-04 | Spain | 218011 | 25428 | 121343 | 71240 | 40.463667 | -3.74922 | 2020-05-05 02:32:34 | Spain | |||
1932059 | 1932059 | 2020-05-05 | Spain | 219329 | 25613 | 123486 | 70230 | 40.463667 | -3.74922 | 2020-05-06 02:32:31 | Spain | |||
2111019 | 2111019 | 2020-05-06 | Spain | 220325 | 25857 | 126002 | 68466 | 40.463667 | -3.74922 | 2020-05-07 02:32:28 | Spain | |||
3295798 | 3295798 | 2020-05-07 | Spain | 221447 | 26070 | 128511 | 66866 | 40.463667 | -3.74922 | 2020-05-08 02:32:32 | Spain | |||
114355 | 114355 | 2020-05-08 | Spain | 222857 | 26299 | 131148 | 65410 | 40.463667 | -3.74922 | 2020-05-09 02:32:35 | Spain | |||
2899306 | 2899306 | 2020-05-09 | Spain | 223578 | 26478 | 133952 | 63148 | 40.463667 | -3.74922 | 2020-05-10 02:32:30 | Spain | |||
3459765 | 3459765 | 2020-05-10 | Spain | 224350 | 26621 | 136166 | 61563 | 40.463667 | -3.74922 | 2020-05-11 02:32:30 | 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]);