johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,730 rows where country_or_region = "United Kingdom" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 20
- England 1,073
- Guernsey 1,073
- Jersey 1,073
- Northern Ireland 1,073
- Pitcairn Islands 1,073
- Scotland 1,073
- Unknown 1,073
- Wales 1,073
- Channel Islands 1,024
- Gibraltar 1,024
- Cayman Islands 1,019
- Montserrat 1,017
- Bermuda 1,016
- Isle of Man 1,015
- Saint Helena, Ascension and Tristan da Cunha 1,010
- British Virgin Islands 1,007
- Turks and Caicos Islands 1,007
- Falkland Islands (Malvinas) 997
- Anguilla 907
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 19,630 ✖
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
399922 | 399922 | 2022-10-07 | United Kingdom | Anguilla | 3866 | 12 | 0 | 18.2206 | -63.0686 | 2022-10-08 04:22:56 | Anguilla, United Kingdom | |||
403912 | 403912 | 2021-06-29 | United Kingdom | Anguilla | 109 | 0 | 109 | 0 | 18.2206 | -63.0686 | 2021-06-30 04:21:41 | Anguilla, United Kingdom | ||
407946 | 407946 | 2021-12-07 | United Kingdom | Anguilla | 1469 | 4 | 0 | 18.2206 | -63.0686 | 2021-12-08 04:22:46 | Anguilla, United Kingdom | |||
411942 | 411942 | 2021-07-28 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-29 04:21:33 | Anguilla, United Kingdom | ||
415136 | 415136 | 2020-07-05 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-06 04:33:57 | Anguilla, United Kingdom | ||
418700 | 418700 | 2020-04-18 | United Kingdom | Anguilla | 3 | 0 | 1 | 2 | 18.2206 | -63.0686 | 2020-04-18 22:32:28 | Anguilla, United Kingdom | ||
422993 | 422993 | 2022-09-18 | United Kingdom | Anguilla | 3856 | 12 | 0 | 18.2206 | -63.0686 | 2022-09-19 04:21:49 | Anguilla, United Kingdom | |||
427002 | 427002 | 2021-10-10 | United Kingdom | Anguilla | 544 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-11 04:21:31 | Anguilla, United Kingdom | |||
430969 | 430969 | 2020-09-07 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-08 04:28:25 | Anguilla, United Kingdom | ||
435015 | 435015 | 2022-11-03 | United Kingdom | Anguilla | 3866 | 12 | 0 | 18.2206 | -63.0686 | 2022-11-04 04:22:11 | Anguilla, United Kingdom | |||
438998 | 438998 | 2021-01-21 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-22 05:22:10 | Anguilla, United Kingdom | ||
442314 | 442314 | 2020-07-26 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-27 04:35:02 | Anguilla, United Kingdom | ||
447006 | 447006 | 2021-10-20 | United Kingdom | Anguilla | 743 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-21 04:21:18 | Anguilla, United Kingdom | |||
451023 | 451023 | 2021-11-17 | United Kingdom | Anguilla | 1175 | 4 | 0 | 18.2206 | -63.0686 | 2021-11-18 04:21:33 | Anguilla, United Kingdom | |||
455045 | 455045 | 2022-12-21 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-22 04:20:56 | Anguilla, United Kingdom | |||
458339 | 458339 | 2020-08-07 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-08-08 04:34:53 | Anguilla, United Kingdom | ||
463032 | 463032 | 2022-02-02 | United Kingdom | Anguilla | 2361 | 8 | 0 | 18.2206 | -63.0686 | 2022-02-03 04:21:21 | Anguilla, United Kingdom | |||
467049 | 467049 | 2022-05-02 | United Kingdom | Anguilla | 2788 | 9 | 0 | 18.2206 | -63.0686 | 2022-05-03 04:21:00 | Anguilla, United Kingdom | |||
471063 | 471063 | 2021-10-07 | United Kingdom | Anguilla | 499 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-08 04:21:25 | Anguilla, United Kingdom | |||
475054 | 475054 | 2021-02-19 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-20 05:22:51 | Anguilla, United Kingdom | ||
479096 | 479096 | 2022-06-26 | United Kingdom | Anguilla | 3411 | 9 | 0 | 18.2206 | -63.0686 | 2022-06-27 04:21:00 | Anguilla, United Kingdom | |||
483248 | 483248 | 2022-11-08 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-11-09 04:21:22 | Anguilla, United Kingdom | |||
487238 | 487238 | 2021-07-19 | United Kingdom | Anguilla | 113 | 0 | 111 | 2 | 18.2206 | -63.0686 | 2021-07-20 04:21:48 | Anguilla, United Kingdom | ||
491278 | 491278 | 2022-11-25 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-11-26 04:21:11 | Anguilla, United Kingdom | |||
495287 | 495287 | 2021-10-14 | United Kingdom | Anguilla | 644 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-15 04:21:26 | Anguilla, United Kingdom | |||
499304 | 499304 | 2021-11-06 | United Kingdom | Anguilla | 1039 | 1 | 0 | 18.2206 | -63.0686 | 2021-11-07 04:21:53 | Anguilla, United Kingdom | |||
503321 | 503321 | 2022-04-02 | United Kingdom | Anguilla | 2700 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-03 04:20:48 | Anguilla, United Kingdom | |||
507342 | 507342 | 2022-12-17 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-18 04:21:03 | Anguilla, United Kingdom | |||
511332 | 511332 | 2021-08-14 | United Kingdom | Anguilla | 127 | 0 | 0 | 18.2206 | -63.0686 | 2021-08-15 04:21:41 | Anguilla, United Kingdom | |||
515346 | 515346 | 2021-08-19 | United Kingdom | Anguilla | 154 | 0 | 0 | 18.2206 | -63.0686 | 2021-08-20 04:21:33 | Anguilla, United Kingdom | |||
519386 | 519386 | 2022-10-15 | United Kingdom | Anguilla | 3866 | 12 | 0 | 18.2206 | -63.0686 | 2022-10-16 04:22:39 | Anguilla, United Kingdom | |||
522238 | 522238 | 2020-04-21 | United Kingdom | Anguilla | 3 | 0 | 1 | 2 | 18.2206 | -63.0686 | 2020-04-21 23:30:30 | Anguilla, United Kingdom | ||
526502 | 526502 | 2021-06-09 | United Kingdom | Anguilla | 109 | 0 | 109 | 0 | 18.2206 | -63.0686 | 2021-06-10 04:23:17 | Anguilla, United Kingdom | ||
529698 | 529698 | 2020-07-04 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-05 04:33:46 | Anguilla, United Kingdom | ||
534348 | 534348 | 2021-02-22 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-23 05:23:41 | Anguilla, United Kingdom | ||
538387 | 538387 | 2021-10-27 | United Kingdom | Anguilla | 859 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-28 04:22:08 | Anguilla, United Kingdom | |||
542410 | 542410 | 2022-10-26 | United Kingdom | Anguilla | 3866 | 12 | 0 | 18.2206 | -63.0686 | 2022-10-27 04:22:01 | Anguilla, United Kingdom | |||
546426 | 546426 | 2022-12-15 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-16 04:21:01 | Anguilla, United Kingdom | |||
550386 | 550386 | 2020-09-12 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-13 04:30:52 | Anguilla, United Kingdom | ||
554426 | 554426 | 2021-12-08 | United Kingdom | Anguilla | 1469 | 4 | 0 | 18.2206 | -63.0686 | 2021-12-09 04:22:49 | Anguilla, United Kingdom | |||
558442 | 558442 | 2022-01-16 | United Kingdom | Anguilla | 2109 | 7 | 0 | 18.2206 | -63.0686 | 2022-01-17 04:21:08 | Anguilla, United Kingdom | |||
562460 | 562460 | 2022-06-16 | United Kingdom | Anguilla | 3374 | 9 | 0 | 18.2206 | -63.0686 | 2022-06-17 04:20:56 | Anguilla, United Kingdom | |||
566614 | 566614 | 2021-06-22 | United Kingdom | Anguilla | 109 | 0 | 109 | 0 | 18.2206 | -63.0686 | 2021-06-23 04:21:46 | Anguilla, United Kingdom | ||
570755 | 570755 | 2021-10-29 | United Kingdom | Anguilla | 892 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-30 04:22:03 | Anguilla, United Kingdom | |||
573847 | 573847 | 2020-06-06 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-06-07 03:53:30 | Anguilla, United Kingdom | ||
578485 | 578485 | 2022-02-25 | United Kingdom | Anguilla | 2528 | 9 | 0 | 18.2206 | -63.0686 | 2022-02-26 04:21:12 | Anguilla, United Kingdom | |||
582480 | 582480 | 2021-07-13 | United Kingdom | Anguilla | 111 | 0 | 109 | 2 | 18.2206 | -63.0686 | 2021-07-14 04:21:35 | Anguilla, United Kingdom | ||
586455 | 586455 | 2020-08-13 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-08-14 04:51:19 | Anguilla, United Kingdom | ||
589009 | 589009 | 2020-04-05 | United Kingdom | Anguilla | 3 | 0 | 0 | 3 | 18.2206 | -63.0686 | 2020-04-05 23:06:26 | Anguilla, United Kingdom | ||
593276 | 593276 | 2021-08-08 | United Kingdom | Anguilla | 113 | 0 | 0 | 18.2206 | -63.0686 | 2021-08-09 04:21:24 | Anguilla, United Kingdom | |||
597312 | 597312 | 2022-07-01 | United Kingdom | Anguilla | 3456 | 9 | 0 | 18.2206 | -63.0686 | 2022-07-02 04:21:16 | Anguilla, United Kingdom | |||
601325 | 601325 | 2021-10-19 | United Kingdom | Anguilla | 698 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-20 04:21:00 | Anguilla, United Kingdom | |||
605340 | 605340 | 2021-09-23 | United Kingdom | Anguilla | 350 | 1 | 0 | 18.2206 | -63.0686 | 2021-09-24 04:21:44 | Anguilla, United Kingdom | |||
609333 | 609333 | 2021-04-09 | United Kingdom | Anguilla | 25 | 0 | 22 | 3 | 18.2206 | -63.0686 | 2021-04-10 04:20:59 | Anguilla, United Kingdom | ||
613317 | 613317 | 2020-08-29 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-08-30 04:28:22 | Anguilla, United Kingdom | ||
617330 | 617330 | 2021-02-08 | United Kingdom | Anguilla | 17 | 0 | 15 | 2 | 18.2206 | -63.0686 | 2021-02-09 05:23:30 | Anguilla, United Kingdom | ||
621520 | 621520 | 2022-11-05 | United Kingdom | Anguilla | 3866 | 12 | 0 | 18.2206 | -63.0686 | 2022-11-06 04:21:24 | Anguilla, United Kingdom | |||
625532 | 625532 | 2022-05-22 | United Kingdom | Anguilla | 3203 | 9 | 0 | 18.2206 | -63.0686 | 2022-05-26 04:20:50 | Anguilla, United Kingdom | |||
629526 | 629526 | 2021-07-10 | United Kingdom | Anguilla | 111 | 0 | 109 | 2 | 18.2206 | -63.0686 | 2021-07-11 04:21:43 | Anguilla, United Kingdom | ||
633563 | 633563 | 2022-07-12 | United Kingdom | Anguilla | 3496 | 9 | 0 | 18.2206 | -63.0686 | 2022-07-13 04:20:58 | Anguilla, United Kingdom | |||
637575 | 637575 | 2021-10-13 | United Kingdom | Anguilla | 644 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-14 04:21:29 | Anguilla, United Kingdom | |||
641566 | 641566 | 2021-03-31 | United Kingdom | Anguilla | 25 | 0 | 21 | 4 | 18.2206 | -63.0686 | 2021-04-01 04:27:05 | Anguilla, United Kingdom | ||
645586 | 645586 | 2021-09-07 | United Kingdom | Anguilla | 296 | 0 | 0 | 18.2206 | -63.0686 | 2021-09-08 04:21:31 | Anguilla, United Kingdom | |||
649596 | 649596 | 2021-05-05 | United Kingdom | Anguilla | 95 | 0 | 35 | 60 | 18.2206 | -63.0686 | 2021-05-06 04:20:38 | Anguilla, United Kingdom | ||
653614 | 653614 | 2021-08-09 | United Kingdom | Anguilla | 113 | 0 | 0 | 18.2206 | -63.0686 | 2021-08-10 04:21:27 | Anguilla, United Kingdom | |||
657647 | 657647 | 2021-10-22 | United Kingdom | Anguilla | 793 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-23 04:21:32 | Anguilla, United Kingdom | |||
661967 | 661967 | 2022-05-13 | United Kingdom | Anguilla | 2984 | 9 | 0 | 18.2206 | -63.0686 | 2022-05-14 04:20:48 | Anguilla, United Kingdom | |||
662662 | 662662 | 2020-08-11 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-08-12 04:27:29 | Anguilla, United Kingdom | ||
669911 | 669911 | 2020-09-16 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-09-17 04:22:00 | Anguilla, United Kingdom | ||
673954 | 673954 | 2022-07-21 | United Kingdom | Anguilla | 3535 | 9 | 0 | 18.2206 | -63.0686 | 2022-07-22 04:21:15 | Anguilla, United Kingdom | |||
677970 | 677970 | 2022-07-30 | United Kingdom | Anguilla | 3580 | 10 | 0 | 18.2206 | -63.0686 | 2022-07-31 04:21:02 | Anguilla, United Kingdom | |||
681952 | 681952 | 2020-11-23 | United Kingdom | Anguilla | 4 | 0 | 3 | 1 | 18.2206 | -63.0686 | 2020-11-24 05:27:31 | Anguilla, United Kingdom | ||
685992 | 685992 | 2021-10-24 | United Kingdom | Anguilla | 793 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-25 04:22:31 | Anguilla, United Kingdom | |||
690009 | 690009 | 2021-11-13 | United Kingdom | Anguilla | 1137 | 4 | 0 | 18.2206 | -63.0686 | 2021-11-14 04:21:31 | Anguilla, United Kingdom | |||
694031 | 694031 | 2022-12-23 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-24 04:21:02 | Anguilla, United Kingdom | |||
698042 | 698042 | 2022-03-17 | United Kingdom | Anguilla | 2595 | 9 | 0 | 18.2206 | -63.0686 | 2022-03-18 04:20:55 | Anguilla, United Kingdom | |||
702057 | 702057 | 2021-11-04 | United Kingdom | Anguilla | 1019 | 1 | 0 | 18.2206 | -63.0686 | 2021-11-05 04:21:54 | Anguilla, United Kingdom | |||
706047 | 706047 | 2021-03-16 | United Kingdom | Anguilla | 21 | 0 | 18 | 3 | 18.2206 | -63.0686 | 2021-03-17 05:25:07 | Anguilla, United Kingdom | ||
710085 | 710085 | 2021-09-29 | United Kingdom | Anguilla | 409 | 1 | 0 | 18.2206 | -63.0686 | 2021-09-30 04:21:20 | Anguilla, United Kingdom | |||
714108 | 714108 | 2022-11-01 | United Kingdom | Anguilla | 3866 | 12 | 0 | 18.2206 | -63.0686 | 2022-11-02 04:22:09 | Anguilla, United Kingdom | |||
718118 | 718118 | 2021-11-12 | United Kingdom | Anguilla | 1109 | 3 | 0 | 18.2206 | -63.0686 | 2021-11-13 04:21:38 | Anguilla, United Kingdom | |||
722140 | 722140 | 2022-12-04 | United Kingdom | Anguilla | 3904 | 12 | 0 | 18.2206 | -63.0686 | 2022-12-05 04:20:58 | Anguilla, United Kingdom | |||
726150 | 726150 | 2021-11-20 | United Kingdom | Anguilla | 1268 | 3 | 0 | 18.2206 | -63.0686 | 2021-11-21 04:22:13 | Anguilla, United Kingdom | |||
730142 | 730142 | 2021-05-22 | United Kingdom | Anguilla | 109 | 0 | 107 | 2 | 18.2206 | -63.0686 | 2021-05-23 04:20:51 | Anguilla, United Kingdom | ||
734180 | 734180 | 2021-12-27 | United Kingdom | Anguilla | 1646 | 5 | 0 | 18.2206 | -63.0686 | 2021-12-28 04:21:47 | Anguilla, United Kingdom | |||
737295 | 737295 | 2020-06-12 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-06-13 03:33:14 | Anguilla, United Kingdom | ||
741941 | 741941 | 2020-12-02 | United Kingdom | Anguilla | 6 | 0 | 3 | 3 | 18.2206 | -63.0686 | 2020-12-03 05:28:22 | Anguilla, United Kingdom | ||
745956 | 745956 | 2021-02-20 | United Kingdom | Anguilla | 18 | 0 | 18 | 0 | 18.2206 | -63.0686 | 2021-02-21 05:24:33 | Anguilla, United Kingdom | ||
749997 | 749997 | 2022-04-23 | United Kingdom | Anguilla | 2731 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-24 04:20:56 | Anguilla, United Kingdom | |||
753293 | 753293 | 2020-08-01 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-08-02 04:34:47 | Anguilla, United Kingdom | ||
757940 | 757940 | 2020-10-28 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-10-29 04:24:49 | Anguilla, United Kingdom | ||
761980 | 761980 | 2021-11-26 | United Kingdom | Anguilla | 1334 | 3 | 0 | 18.2206 | -63.0686 | 2021-11-27 04:22:45 | Anguilla, United Kingdom | |||
765950 | 765950 | 2020-10-18 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-10-19 04:24:16 | Anguilla, United Kingdom | ||
769960 | 769960 | 2020-12-29 | United Kingdom | Anguilla | 13 | 0 | 12 | 1 | 18.2206 | -63.0686 | 2020-12-30 05:22:34 | Anguilla, United Kingdom | ||
774000 | 774000 | 2021-10-23 | United Kingdom | Anguilla | 793 | 1 | 0 | 18.2206 | -63.0686 | 2021-10-24 04:21:22 | Anguilla, United Kingdom | |||
777988 | 777988 | 2021-01-12 | United Kingdom | Anguilla | 15 | 0 | 13 | 2 | 18.2206 | -63.0686 | 2021-01-13 05:22:15 | Anguilla, United Kingdom | ||
782009 | 782009 | 2021-07-08 | United Kingdom | Anguilla | 111 | 0 | 109 | 2 | 18.2206 | -63.0686 | 2021-07-09 04:21:21 | Anguilla, United Kingdom | ||
786043 | 786043 | 2021-12-13 | United Kingdom | Anguilla | 1523 | 4 | 0 | 18.2206 | -63.0686 | 2021-12-14 04:22:38 | Anguilla, United Kingdom | |||
790012 | 790012 | 2020-10-15 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-10-16 04:24:01 | Anguilla, United Kingdom | ||
794025 | 794025 | 2021-02-04 | United Kingdom | Anguilla | 17 | 0 | 15 | 2 | 18.2206 | -63.0686 | 2021-02-05 05:22:38 | Anguilla, 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]);