johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
955 rows where country_or_region = "Spain" and province_or_state = "Unknown" sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8631 | 8631 | 2020-10-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, Spain | ||||
12642 | 12642 | 2021-01-26 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-27 05:23:41 | Unknown, Spain | ||||
20673 | 20673 | 2021-05-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
36732 | 36732 | 2021-04-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-13 04:20:37 | Unknown, Spain | ||||
51094 | 51094 | 2021-05-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
55107 | 55107 | 2021-03-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-03-08 05:24:48 | Unknown, Spain | ||||
62186 | 62186 | 2020-07-23 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-24 05:30:40 | Unknown, Spain | ||||
75390 | 75390 | 2020-12-03 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-04 05:27:27 | Unknown, Spain | ||||
79387 | 79387 | 2020-10-14 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-15 04:24:28 | Unknown, Spain | ||||
83397 | 83397 | 2021-05-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
98547 | 98547 | 2020-08-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-05 04:34:43 | Unknown, Spain | ||||
107756 | 107756 | 2021-06-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
122138 | 122138 | 2020-07-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-20 05:34:40 | Unknown, Spain | ||||
123005 | 123005 | 2020-11-18 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-19 05:25:23 | Unknown, Spain | ||||
146270 | 146270 | 2020-08-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-16 04:27:42 | Unknown, Spain | ||||
154284 | 154284 | 2021-01-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-09 05:22:18 | Unknown, Spain | ||||
170346 | 170346 | 2021-04-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-17 04:20:40 | Unknown, Spain | ||||
177456 | 177456 | 2020-07-27 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-28 04:58:43 | Unknown, Spain | ||||
182342 | 182342 | 2021-02-21 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-22 05:24:21 | Unknown, Spain | ||||
190370 | 190370 | 2021-01-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-12 05:22:15 | Unknown, Spain | ||||
194365 | 194365 | 2020-08-31 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-01 04:28:31 | Unknown, Spain | ||||
202557 | 202557 | 2020-12-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-26 05:22:28 | Unknown, Spain | ||||
206552 | 206552 | 2020-08-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-20 04:27:43 | Unknown, Spain | ||||
210540 | 210540 | 2020-10-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-30 04:24:49 | Unknown, Spain | ||||
217401 | 217401 | 2020-06-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-09 03:33:03 | Unknown, Spain | ||||
237542 | 237542 | 2021-01-18 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-19 05:22:15 | Unknown, Spain | ||||
241557 | 241557 | 2021-04-02 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-03 04:20:44 | Unknown, Spain | ||||
268425 | 268425 | 2020-05-21 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-22 02:36:51 | Unknown, Spain | ||||
272455 | 272455 | 2020-11-10 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-11 05:25:30 | Unknown, Spain | ||||
280485 | 280485 | 2021-02-24 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-25 05:24:57 | Unknown, Spain | ||||
287420 | 287420 | 2020-06-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-16 04:33:09 | Unknown, Spain | ||||
296317 | 296317 | 2021-07-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
303292 | 303292 | 2020-07-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-02 04:33:46 | Unknown, Spain | ||||
327233 | 327233 | 2020-07-20 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-21 04:38:46 | Unknown, Spain | ||||
332211 | 332211 | 2021-08-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
340577 | 340577 | 2021-02-03 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-04 05:22:26 | Unknown, Spain | ||||
344573 | 344573 | 2020-09-14 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-15 03:22:50 | Unknown, Spain | ||||
352598 | 352598 | 2021-03-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-03-12 05:26:50 | Unknown, Spain | ||||
367640 | 367640 | 2020-07-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-17 04:34:50 | Unknown, Spain | ||||
371612 | 371612 | 2020-08-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-09 04:34:54 | Unknown, Spain | ||||
376482 | 376482 | 2020-11-06 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-07 05:24:52 | Unknown, Spain | ||||
380495 | 380495 | 2021-04-30 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
388525 | 388525 | 2021-04-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-05 04:20:35 | Unknown, Spain | ||||
392536 | 392536 | 2020-11-27 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-28 05:25:50 | Unknown, Spain | ||||
400569 | 400569 | 2021-06-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
408599 | 408599 | 2021-07-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
415583 | 415583 | 2020-07-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-06 04:33:57 | Unknown, Spain | ||||
427634 | 427634 | 2020-09-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-08 04:28:25 | Unknown, Spain | ||||
435658 | 435658 | 2021-01-21 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-22 05:22:10 | Unknown, Spain | ||||
442769 | 442769 | 2020-07-26 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-27 04:35:02 | Unknown, Spain | ||||
458796 | 458796 | 2020-08-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-08 04:34:53 | Unknown, Spain | ||||
471714 | 471714 | 2021-02-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-20 05:22:51 | Unknown, Spain | ||||
483895 | 483895 | 2021-07-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
523160 | 523160 | 2021-06-09 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
530145 | 530145 | 2020-07-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-05 04:33:46 | Unknown, Spain | ||||
531008 | 531008 | 2021-02-22 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-23 05:23:41 | Unknown, Spain | ||||
547051 | 547051 | 2020-09-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-13 04:30:52 | Unknown, Spain | ||||
563272 | 563272 | 2021-06-22 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
574254 | 574254 | 2020-06-06 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-07 03:53:30 | Unknown, Spain | ||||
579137 | 579137 | 2021-07-13 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
583129 | 583129 | 2020-08-13 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-14 04:51:19 | Unknown, Spain | ||||
605991 | 605991 | 2021-04-09 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-10 04:20:59 | Unknown, Spain | ||||
609986 | 609986 | 2020-08-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-30 04:28:22 | Unknown, Spain | ||||
613990 | 613990 | 2021-02-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-09 05:23:30 | Unknown, Spain | ||||
626183 | 626183 | 2021-07-10 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
638226 | 638226 | 2021-03-31 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-01 04:27:05 | Unknown, Spain | ||||
646254 | 646254 | 2021-05-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
662597 | 662597 | 2020-08-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-12 04:27:29 | Unknown, Spain | ||||
666576 | 666576 | 2020-09-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-17 04:22:00 | Unknown, Spain | ||||
678613 | 678613 | 2020-11-23 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-24 05:27:31 | Unknown, Spain | ||||
702707 | 702707 | 2021-03-16 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-03-17 05:25:07 | Unknown, Spain | ||||
726800 | 726800 | 2021-05-22 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
737743 | 737743 | 2020-06-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-13 03:33:14 | Unknown, Spain | ||||
738602 | 738602 | 2020-12-02 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-03 05:28:22 | Unknown, Spain | ||||
742616 | 742616 | 2021-02-20 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-21 05:24:33 | Unknown, Spain | ||||
753750 | 753750 | 2020-08-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-02 04:34:47 | Unknown, Spain | ||||
754602 | 754602 | 2020-10-28 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-29 04:24:49 | Unknown, Spain | ||||
762613 | 762613 | 2020-10-18 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-19 04:24:16 | Unknown, Spain | ||||
766621 | 766621 | 2020-12-29 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-30 05:22:34 | Unknown, Spain | ||||
774649 | 774649 | 2021-01-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-13 05:22:15 | Unknown, Spain | ||||
778666 | 778666 | 2021-07-08 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
786676 | 786676 | 2020-10-15 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-16 04:24:01 | Unknown, Spain | ||||
790685 | 790685 | 2021-02-04 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-02-05 05:22:38 | Unknown, Spain | ||||
805551 | 805551 | 2020-06-01 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-06-02 02:33:08 | Unknown, Spain | ||||
813874 | 813874 | 2020-09-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-09-06 04:28:33 | Unknown, Spain | ||||
817865 | 817865 | 2020-10-09 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-10 04:23:57 | Unknown, Spain | ||||
821871 | 821871 | 2020-11-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-20 05:26:28 | Unknown, Spain | ||||
825886 | 825886 | 2021-06-06 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
829902 | 829902 | 2021-07-09 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
837910 | 837910 | 2020-08-17 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-08-18 04:27:56 | Unknown, Spain | ||||
845003 | 845003 | 2020-07-22 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-23 05:15:04 | Unknown, Spain | ||||
845871 | 845871 | 2020-12-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-13 05:27:20 | Unknown, Spain | ||||
860978 | 860978 | 2020-12-11 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-12-12 05:26:19 | Unknown, Spain | ||||
865071 | 865071 | 2020-11-12 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-13 05:25:30 | Unknown, Spain | ||||
875705 | 875705 | 2020-05-24 | Spain | Unknown | 0 | 0 | 150376 | 0 | 2020-05-25 02:32:44 | Unknown, Spain | ||||
887558 | 887558 | 2020-07-07 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-07-08 05:33:48 | Unknown, Spain | ||||
888422 | 888422 | 2021-04-26 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | ||||
892420 | 892420 | 2020-11-05 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-06 05:24:55 | Unknown, Spain | ||||
908479 | 908479 | 2021-01-19 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-20 05:21:54 | Unknown, Spain | ||||
923983 | 923983 | 2020-11-26 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-11-27 05:26:53 | Unknown, 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]);