johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where province_or_state = "Channel Islands" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- Channel Islands · 924 ✖
country_or_region 1
- United Kingdom 924
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
395879 | 395879 | 2020-11-27 | United Kingdom | Channel Islands | 0 | 0 | 960 | 210 | 49.3723 | -2.3644 | 2020-11-28 05:25:50 | Channel Islands, United Kingdom | ||
399926 | 399926 | 2022-10-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-10-08 04:22:56 | Channel Islands, United Kingdom | |||
403916 | 403916 | 2021-06-29 | United Kingdom | Channel Islands | 0 | 0 | 3994 | 242 | 49.3723 | -2.3644 | 2021-06-30 04:21:41 | Channel Islands, United Kingdom | ||
407950 | 407950 | 2021-12-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-12-08 04:22:46 | Channel Islands, United Kingdom | |||
411946 | 411946 | 2021-07-28 | United Kingdom | Channel Islands | 0 | 0 | 6033 | 2917 | 49.3723 | -2.3644 | 2021-07-29 04:21:33 | Channel Islands, United Kingdom | ||
415205 | 415205 | 2020-07-05 | United Kingdom | Channel Islands | 0 | 0 | 512 | 12 | 49.3723 | -2.3644 | 2020-07-06 04:33:57 | Channel Islands, United Kingdom | ||
418710 | 418710 | 2020-04-18 | United Kingdom | Channel Islands | 0 | 0 | 73 | 390 | 49.3723 | -2.3644 | 2020-04-18 22:32:28 | Channel Islands, United Kingdom | ||
422997 | 422997 | 2022-09-18 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-09-19 04:21:49 | Channel Islands, United Kingdom | |||
427006 | 427006 | 2021-10-10 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-11 04:21:31 | Channel Islands, United Kingdom | |||
430973 | 430973 | 2020-09-07 | United Kingdom | Channel Islands | 0 | 0 | 575 | 5 | 49.3723 | -2.3644 | 2020-09-08 04:28:25 | Channel Islands, United Kingdom | ||
435019 | 435019 | 2022-11-03 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-11-04 04:22:11 | Channel Islands, United Kingdom | |||
439002 | 439002 | 2021-01-21 | United Kingdom | Channel Islands | 0 | 0 | 3148 | 181 | 49.3723 | -2.3644 | 2021-01-22 05:22:10 | Channel Islands, United Kingdom | ||
442383 | 442383 | 2020-07-26 | United Kingdom | Channel Islands | 0 | 0 | 533 | 4 | 49.3723 | -2.3644 | 2020-07-27 04:35:02 | Channel Islands, United Kingdom | ||
447010 | 447010 | 2021-10-20 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-21 04:21:18 | Channel Islands, United Kingdom | |||
451027 | 451027 | 2021-11-17 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-18 04:21:33 | Channel Islands, United Kingdom | |||
455049 | 455049 | 2022-12-21 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-12-22 04:20:56 | Channel Islands, United Kingdom | |||
458408 | 458408 | 2020-08-07 | United Kingdom | Channel Islands | 0 | 0 | 533 | 17 | 49.3723 | -2.3644 | 2020-08-08 04:34:53 | Channel Islands, United Kingdom | ||
463036 | 463036 | 2022-02-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-02-03 04:21:21 | Channel Islands, United Kingdom | |||
467053 | 467053 | 2022-05-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-05-03 04:21:00 | Channel Islands, United Kingdom | |||
471067 | 471067 | 2021-10-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-08 04:21:25 | Channel Islands, United Kingdom | |||
475058 | 475058 | 2021-02-19 | United Kingdom | Channel Islands | 0 | 0 | 3821 | 117 | 49.3723 | -2.3644 | 2021-02-20 05:22:51 | Channel Islands, United Kingdom | ||
479100 | 479100 | 2022-06-26 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-06-27 04:21:00 | Channel Islands, United Kingdom | |||
483252 | 483252 | 2022-11-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-11-09 04:21:22 | Channel Islands, United Kingdom | |||
487242 | 487242 | 2021-07-19 | United Kingdom | Channel Islands | 0 | 0 | 4448 | 2928 | 49.3723 | -2.3644 | 2021-07-20 04:21:48 | Channel Islands, United Kingdom | ||
491282 | 491282 | 2022-11-25 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-11-26 04:21:11 | Channel Islands, United Kingdom | |||
495291 | 495291 | 2021-10-14 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-15 04:21:26 | Channel Islands, United Kingdom | |||
499308 | 499308 | 2021-11-06 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-07 04:21:53 | Channel Islands, United Kingdom | |||
503325 | 503325 | 2022-04-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-04-03 04:20:48 | Channel Islands, United Kingdom | |||
507346 | 507346 | 2022-12-17 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-12-18 04:21:03 | Channel Islands, United Kingdom | |||
511336 | 511336 | 2021-08-14 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-15 04:21:41 | Channel Islands, United Kingdom | |||
515350 | 515350 | 2021-08-19 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-20 04:21:33 | Channel Islands, United Kingdom | |||
519390 | 519390 | 2022-10-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-10-16 04:22:39 | Channel Islands, United Kingdom | |||
522248 | 522248 | 2020-04-21 | United Kingdom | Channel Islands | 0 | 0 | 256 | 216 | 49.3723 | -2.3644 | 2020-04-21 23:30:30 | Channel Islands, United Kingdom | ||
526506 | 526506 | 2021-06-09 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 41 | 49.3723 | -2.3644 | 2021-06-10 04:23:17 | Channel Islands, United Kingdom | ||
529767 | 529767 | 2020-07-04 | United Kingdom | Channel Islands | 0 | 0 | 512 | 12 | 49.3723 | -2.3644 | 2020-07-05 04:33:46 | Channel Islands, United Kingdom | ||
534352 | 534352 | 2021-02-22 | United Kingdom | Channel Islands | 0 | 0 | 3858 | 87 | 49.3723 | -2.3644 | 2021-02-23 05:23:41 | Channel Islands, United Kingdom | ||
538391 | 538391 | 2021-10-27 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-28 04:22:08 | Channel Islands, United Kingdom | |||
542414 | 542414 | 2022-10-26 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-10-27 04:22:01 | Channel Islands, United Kingdom | |||
546430 | 546430 | 2022-12-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-12-16 04:21:01 | Channel Islands, United Kingdom | |||
550390 | 550390 | 2020-09-12 | United Kingdom | Channel Islands | 0 | 0 | 575 | 10 | 49.3723 | -2.3644 | 2020-09-13 04:30:52 | Channel Islands, United Kingdom | ||
554430 | 554430 | 2021-12-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-12-09 04:22:49 | Channel Islands, United Kingdom | |||
558446 | 558446 | 2022-01-16 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-01-17 04:21:08 | Channel Islands, United Kingdom | |||
562464 | 562464 | 2022-06-16 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-06-17 04:20:56 | Channel Islands, United Kingdom | |||
566618 | 566618 | 2021-06-22 | United Kingdom | Channel Islands | 0 | 0 | 3994 | 70 | 49.3723 | -2.3644 | 2021-06-23 04:21:46 | Channel Islands, United Kingdom | ||
570759 | 570759 | 2021-10-29 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-30 04:22:03 | Channel Islands, United Kingdom | |||
573910 | 573910 | 2020-06-06 | United Kingdom | Channel Islands | 0 | 0 | 512 | 5 | 49.3723 | -2.3644 | 2020-06-07 03:53:30 | Channel Islands, United Kingdom | ||
578489 | 578489 | 2022-02-25 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-02-26 04:21:12 | Channel Islands, United Kingdom | |||
582484 | 582484 | 2021-07-13 | United Kingdom | Channel Islands | 0 | 0 | 4162 | 1641 | 49.3723 | -2.3644 | 2021-07-14 04:21:35 | Channel Islands, United Kingdom | ||
586459 | 586459 | 2020-08-13 | United Kingdom | Channel Islands | 0 | 0 | 545 | 11 | 49.3723 | -2.3644 | 2020-08-14 04:51:19 | Channel Islands, United Kingdom | ||
589019 | 589019 | 2020-04-05 | United Kingdom | Channel Islands | 0 | 0 | 27 | 276 | 49.3723 | -2.3644 | 2020-04-05 23:06:26 | Channel Islands, United Kingdom | ||
593280 | 593280 | 2021-08-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-09 04:21:24 | Channel Islands, United Kingdom | |||
597316 | 597316 | 2022-07-01 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-07-02 04:21:16 | Channel Islands, United Kingdom | |||
601329 | 601329 | 2021-10-19 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-20 04:21:00 | Channel Islands, United Kingdom | |||
605344 | 605344 | 2021-09-23 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-24 04:21:44 | Channel Islands, United Kingdom | |||
609337 | 609337 | 2021-04-09 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 9 | 49.3723 | -2.3644 | 2021-04-10 04:20:59 | Channel Islands, United Kingdom | ||
613321 | 613321 | 2020-08-29 | United Kingdom | Channel Islands | 0 | 0 | 545 | 32 | 49.3723 | -2.3644 | 2020-08-30 04:28:22 | Channel Islands, United Kingdom | ||
617334 | 617334 | 2021-02-08 | United Kingdom | Channel Islands | 0 | 0 | 3428 | 407 | 49.3723 | -2.3644 | 2021-02-09 05:23:30 | Channel Islands, United Kingdom | ||
621524 | 621524 | 2022-11-05 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-11-06 04:21:24 | Channel Islands, United Kingdom | |||
625536 | 625536 | 2022-05-22 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-05-26 04:20:50 | Channel Islands, United Kingdom | |||
629530 | 629530 | 2021-07-10 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 1041 | 49.3723 | -2.3644 | 2021-07-11 04:21:43 | Channel Islands, United Kingdom | ||
633567 | 633567 | 2022-07-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-07-13 04:20:58 | Channel Islands, United Kingdom | |||
637579 | 637579 | 2021-10-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-14 04:21:29 | Channel Islands, United Kingdom | |||
641570 | 641570 | 2021-03-31 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 7 | 49.3723 | -2.3644 | 2021-04-01 04:27:05 | Channel Islands, United Kingdom | ||
645590 | 645590 | 2021-09-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-08 04:21:31 | Channel Islands, United Kingdom | |||
649600 | 649600 | 2021-05-05 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 14 | 49.3723 | -2.3644 | 2021-05-06 04:20:38 | Channel Islands, United Kingdom | ||
653618 | 653618 | 2021-08-09 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-10 04:21:27 | Channel Islands, United Kingdom | |||
657651 | 657651 | 2021-10-22 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-23 04:21:32 | Channel Islands, United Kingdom | |||
661971 | 661971 | 2022-05-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-05-14 04:20:48 | Channel Islands, United Kingdom | |||
662666 | 662666 | 2020-08-11 | United Kingdom | Channel Islands | 0 | 0 | 545 | 7 | 49.3723 | -2.3644 | 2020-08-12 04:27:29 | Channel Islands, United Kingdom | ||
669915 | 669915 | 2020-09-16 | United Kingdom | Channel Islands | 0 | 0 | 575 | 16 | 49.3723 | -2.3644 | 2020-09-17 04:22:00 | Channel Islands, United Kingdom | ||
673958 | 673958 | 2022-07-21 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-07-22 04:21:15 | Channel Islands, United Kingdom | |||
677974 | 677974 | 2022-07-30 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-07-31 04:21:02 | Channel Islands, United Kingdom | |||
681956 | 681956 | 2020-11-23 | United Kingdom | Channel Islands | 0 | 0 | 887 | 159 | 49.3723 | -2.3644 | 2020-11-24 05:27:31 | Channel Islands, United Kingdom | ||
685996 | 685996 | 2021-10-24 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-25 04:22:31 | Channel Islands, United Kingdom | |||
690013 | 690013 | 2021-11-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-14 04:21:31 | Channel Islands, United Kingdom | |||
694035 | 694035 | 2022-12-23 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-12-24 04:21:02 | Channel Islands, United Kingdom | |||
698046 | 698046 | 2022-03-17 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-03-18 04:20:55 | Channel Islands, United Kingdom | |||
702061 | 702061 | 2021-11-04 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-05 04:21:54 | Channel Islands, United Kingdom | |||
706051 | 706051 | 2021-03-16 | United Kingdom | Channel Islands | 0 | 0 | 3965 | 0 | 49.3723 | -2.3644 | 2021-03-17 05:25:07 | Channel Islands, United Kingdom | ||
710089 | 710089 | 2021-09-29 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-30 04:21:20 | Channel Islands, United Kingdom | |||
714112 | 714112 | 2022-11-01 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-11-02 04:22:09 | Channel Islands, United Kingdom | |||
718122 | 718122 | 2021-11-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-13 04:21:38 | Channel Islands, United Kingdom | |||
722144 | 722144 | 2022-12-04 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-12-05 04:20:58 | Channel Islands, United Kingdom | |||
726154 | 726154 | 2021-11-20 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-21 04:22:13 | Channel Islands, United Kingdom | |||
730146 | 730146 | 2021-05-22 | United Kingdom | Channel Islands | 0 | 0 | 3956 | 17 | 49.3723 | -2.3644 | 2021-05-23 04:20:51 | Channel Islands, United Kingdom | ||
734184 | 734184 | 2021-12-27 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-12-28 04:21:47 | Channel Islands, United Kingdom | |||
737364 | 737364 | 2020-06-12 | United Kingdom | Channel Islands | 0 | 0 | 512 | 5 | 49.3723 | -2.3644 | 2020-06-13 03:33:14 | Channel Islands, United Kingdom | ||
741945 | 741945 | 2020-12-02 | United Kingdom | Channel Islands | 0 | 0 | 1012 | 337 | 49.3723 | -2.3644 | 2020-12-03 05:28:22 | Channel Islands, United Kingdom | ||
745960 | 745960 | 2021-02-20 | United Kingdom | Channel Islands | 0 | 0 | 3829 | 111 | 49.3723 | -2.3644 | 2021-02-21 05:24:33 | Channel Islands, United Kingdom | ||
750001 | 750001 | 2022-04-23 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2022-04-24 04:20:56 | Channel Islands, United Kingdom | |||
753362 | 753362 | 2020-08-01 | United Kingdom | Channel Islands | 0 | 0 | 533 | 7 | 49.3723 | -2.3644 | 2020-08-02 04:34:47 | Channel Islands, United Kingdom | ||
757944 | 757944 | 2020-10-28 | United Kingdom | Channel Islands | 0 | 0 | 710 | 75 | 49.3723 | -2.3644 | 2020-10-29 04:24:49 | Channel Islands, United Kingdom | ||
761984 | 761984 | 2021-11-26 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-27 04:22:45 | Channel Islands, United Kingdom | |||
765954 | 765954 | 2020-10-18 | United Kingdom | Channel Islands | 0 | 0 | 649 | 51 | 49.3723 | -2.3644 | 2020-10-19 04:24:16 | Channel Islands, United Kingdom | ||
769964 | 769964 | 2020-12-29 | United Kingdom | Channel Islands | 0 | 0 | 2180 | 767 | 49.3723 | -2.3644 | 2020-12-30 05:22:34 | Channel Islands, United Kingdom | ||
774004 | 774004 | 2021-10-23 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-24 04:21:22 | Channel Islands, United Kingdom | |||
777992 | 777992 | 2021-01-12 | United Kingdom | Channel Islands | 0 | 0 | 2948 | 287 | 49.3723 | -2.3644 | 2021-01-13 05:22:15 | Channel Islands, United Kingdom | ||
782013 | 782013 | 2021-07-08 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 737 | 49.3723 | -2.3644 | 2021-07-09 04:21:21 | Channel Islands, United Kingdom | ||
786047 | 786047 | 2021-12-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-12-14 04:22:38 | Channel Islands, United Kingdom | |||
790016 | 790016 | 2020-10-15 | United Kingdom | Channel Islands | 0 | 0 | 648 | 52 | 49.3723 | -2.3644 | 2020-10-16 04:24:01 | Channel Islands, United Kingdom |
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]);