johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where country_or_region = "United Kingdom" and province_or_state = "Guernsey" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28061 | 28061 | 2022-03-20 | United Kingdom | Guernsey | 17849 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-21 04:20:50 | Guernsey, United Kingdom | |||
40329 | 40329 | 2020-03-05 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-05T14:53:03 | ||||
62721 | 62721 | 2020-03-07 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-07T11:13:04 | ||||
66727 | 66727 | 2022-11-12 | United Kingdom | Guernsey | 32562 | 65 | 0 | 49.448196 | -2.58949 | 2022-11-13 04:21:14 | Guernsey, United Kingdom | |||
94804 | 94804 | 2022-07-23 | United Kingdom | Guernsey | 29601 | 54 | 0 | 49.448196 | -2.58949 | 2022-07-24 04:20:47 | Guernsey, United Kingdom | |||
98986 | 98986 | 2020-03-04 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-04T12:53:03 | ||||
107127 | 107127 | 2020-02-15 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-02-15T23:13:05 | ||||
118414 | 118414 | 2022-09-06 | United Kingdom | Guernsey | 30767 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-07 04:20:59 | Guernsey, United Kingdom | |||
134415 | 134415 | 2022-10-04 | United Kingdom | Guernsey | 31309 | 63 | 0 | 49.448196 | -2.58949 | 2022-10-05 04:23:06 | Guernsey, United Kingdom | |||
145649 | 145649 | 2022-07-09 | United Kingdom | Guernsey | 28098 | 49 | 0 | 49.448196 | -2.58949 | 2022-07-10 04:20:54 | Guernsey, United Kingdom | |||
161673 | 161673 | 2022-03-29 | United Kingdom | Guernsey | 20785 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-30 04:20:45 | Guernsey, United Kingdom | |||
169706 | 169706 | 2022-06-21 | United Kingdom | Guernsey | 26131 | 47 | 0 | 49.448196 | -2.58949 | 2022-06-22 04:20:54 | Guernsey, United Kingdom | |||
197826 | 197826 | 2020-01-24 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/24/20 17:00 | ||||
197917 | 197917 | 2020-01-29 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/29/20 19:30 | ||||
201924 | 201924 | 2022-10-19 | United Kingdom | Guernsey | 31836 | 63 | 0 | 49.448196 | -2.58949 | 2022-10-20 04:22:59 | Guernsey, United Kingdom | |||
221645 | 221645 | 2022-12-26 | United Kingdom | Guernsey | 33910 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-27 04:21:07 | Guernsey, United Kingdom | |||
225656 | 225656 | 2022-05-09 | United Kingdom | Guernsey | 24832 | 45 | 0 | 49.448196 | -2.58949 | 2022-05-10 04:20:50 | Guernsey, United Kingdom | |||
232888 | 232888 | 2022-05-31 | United Kingdom | Guernsey | 25579 | 47 | 0 | 49.448196 | -2.58949 | 2022-06-01 04:20:55 | Guernsey, United Kingdom | |||
256976 | 256976 | 2022-09-08 | United Kingdom | Guernsey | 30883 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-09 04:21:11 | Guernsey, United Kingdom | |||
260995 | 260995 | 2022-12-10 | United Kingdom | Guernsey | 33080 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-11 04:20:50 | Guernsey, United Kingdom | |||
261192 | 261192 | 2020-03-03 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-03T11:43:02 | ||||
265193 | 265193 | 2022-03-15 | United Kingdom | Guernsey | 15630 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-16 04:20:50 | Guernsey, United Kingdom | |||
295678 | 295678 | 2022-11-15 | United Kingdom | Guernsey | 32562 | 65 | 0 | 49.448196 | -2.58949 | 2022-11-16 04:21:09 | Guernsey, United Kingdom | |||
307529 | 307529 | 2022-04-16 | United Kingdom | Guernsey | 23684 | 43 | 0 | 49.448196 | -2.58949 | 2022-04-17 04:20:59 | Guernsey, United Kingdom | |||
311550 | 311550 | 2022-12-13 | United Kingdom | Guernsey | 33080 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-14 04:21:04 | Guernsey, United Kingdom | |||
315566 | 315566 | 2022-11-13 | United Kingdom | Guernsey | 32562 | 65 | 0 | 49.448196 | -2.58949 | 2022-11-14 04:21:09 | Guernsey, United Kingdom | |||
323598 | 323598 | 2022-10-30 | United Kingdom | Guernsey | 32324 | 64 | 0 | 49.448196 | -2.58949 | 2022-10-31 04:21:36 | Guernsey, United Kingdom | |||
331572 | 331572 | 2022-12-27 | United Kingdom | Guernsey | 33910 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-28 04:21:04 | Guernsey, United Kingdom | |||
339597 | 339597 | 2022-03-18 | United Kingdom | Guernsey | 17849 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-19 04:20:47 | Guernsey, United Kingdom | |||
339952 | 339952 | 2020-03-21 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-21T10:13:08 | ||||
351962 | 351962 | 2022-12-14 | United Kingdom | Guernsey | 33080 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-15 04:20:58 | Guernsey, United Kingdom | |||
359987 | 359987 | 2022-03-11 | United Kingdom | Guernsey | 15630 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-12 04:20:50 | Guernsey, United Kingdom | |||
364003 | 364003 | 2022-05-07 | United Kingdom | Guernsey | 24832 | 45 | 0 | 49.448196 | -2.58949 | 2022-05-08 04:20:49 | Guernsey, United Kingdom | |||
375862 | 375862 | 2022-09-13 | United Kingdom | Guernsey | 30883 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-14 04:20:44 | Guernsey, United Kingdom | |||
387889 | 387889 | 2022-09-23 | United Kingdom | Guernsey | 31099 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-24 04:21:40 | Guernsey, United Kingdom | |||
399930 | 399930 | 2022-10-07 | United Kingdom | Guernsey | 31545 | 63 | 0 | 49.448196 | -2.58949 | 2022-10-08 04:22:56 | Guernsey, United Kingdom | |||
415903 | 415903 | 2020-01-26 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/26/20 16:00 | ||||
423001 | 423001 | 2022-09-18 | United Kingdom | Guernsey | 30992 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-19 04:21:49 | Guernsey, United Kingdom | |||
435023 | 435023 | 2022-11-03 | United Kingdom | Guernsey | 32466 | 64 | 0 | 49.448196 | -2.58949 | 2022-11-04 04:22:11 | Guernsey, United Kingdom | |||
455053 | 455053 | 2022-12-21 | United Kingdom | Guernsey | 33910 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-22 04:20:56 | Guernsey, United Kingdom | |||
467057 | 467057 | 2022-05-02 | United Kingdom | Guernsey | 24573 | 43 | 0 | 49.448196 | -2.58949 | 2022-05-03 04:21:00 | Guernsey, United Kingdom | |||
479104 | 479104 | 2022-06-26 | United Kingdom | Guernsey | 26541 | 47 | 0 | 49.448196 | -2.58949 | 2022-06-27 04:21:00 | Guernsey, United Kingdom | |||
479250 | 479250 | 2020-02-25 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-02-25T15:23:04 | ||||
483256 | 483256 | 2022-11-08 | United Kingdom | Guernsey | 32466 | 64 | 0 | 49.448196 | -2.58949 | 2022-11-09 04:21:22 | Guernsey, United Kingdom | |||
491286 | 491286 | 2022-11-25 | United Kingdom | Guernsey | 32766 | 65 | 0 | 49.448196 | -2.58949 | 2022-11-26 04:21:11 | Guernsey, United Kingdom | |||
503329 | 503329 | 2022-04-02 | United Kingdom | Guernsey | 22257 | 31 | 0 | 49.448196 | -2.58949 | 2022-04-03 04:20:48 | Guernsey, United Kingdom | |||
507350 | 507350 | 2022-12-17 | United Kingdom | Guernsey | 33449 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-18 04:21:03 | Guernsey, United Kingdom | |||
519394 | 519394 | 2022-10-15 | United Kingdom | Guernsey | 31836 | 63 | 0 | 49.448196 | -2.58949 | 2022-10-16 04:22:39 | Guernsey, United Kingdom | |||
542418 | 542418 | 2022-10-26 | United Kingdom | Guernsey | 32324 | 64 | 0 | 49.448196 | -2.58949 | 2022-10-27 04:22:01 | Guernsey, United Kingdom | |||
546434 | 546434 | 2022-12-15 | United Kingdom | Guernsey | 33449 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-16 04:21:01 | Guernsey, United Kingdom | |||
562468 | 562468 | 2022-06-16 | United Kingdom | Guernsey | 26131 | 47 | 0 | 49.448196 | -2.58949 | 2022-06-17 04:20:56 | Guernsey, United Kingdom | |||
562643 | 562643 | 2020-03-01 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-01T10:13:19 | ||||
566764 | 566764 | 2020-02-06 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-02-06T23:23:02 | ||||
578493 | 578493 | 2022-02-25 | United Kingdom | Guernsey | 13503 | 31 | 0 | 49.448196 | -2.58949 | 2022-02-26 04:21:12 | Guernsey, United Kingdom | |||
597320 | 597320 | 2022-07-01 | United Kingdom | Guernsey | 27101 | 48 | 0 | 49.448196 | -2.58949 | 2022-07-02 04:21:16 | Guernsey, United Kingdom | |||
617522 | 617522 | 2020-02-27 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-02-27T12:13:14 | ||||
621528 | 621528 | 2022-11-05 | United Kingdom | Guernsey | 32466 | 64 | 0 | 49.448196 | -2.58949 | 2022-11-06 04:21:24 | Guernsey, United Kingdom | |||
625540 | 625540 | 2022-05-22 | United Kingdom | Guernsey | 25579 | 47 | 0 | 49.448196 | -2.58949 | 2022-05-26 04:20:50 | Guernsey, United Kingdom | |||
633571 | 633571 | 2022-07-12 | United Kingdom | Guernsey | 28098 | 49 | 0 | 49.448196 | -2.58949 | 2022-07-13 04:20:58 | Guernsey, United Kingdom | |||
657974 | 657974 | 2020-03-09 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-09T14:33:03 | ||||
661975 | 661975 | 2022-05-13 | United Kingdom | Guernsey | 25042 | 46 | 0 | 49.448196 | -2.58949 | 2022-05-14 04:20:48 | Guernsey, United Kingdom | |||
673962 | 673962 | 2022-07-21 | United Kingdom | Guernsey | 29601 | 54 | 0 | 49.448196 | -2.58949 | 2022-07-22 04:21:15 | Guernsey, United Kingdom | |||
677978 | 677978 | 2022-07-30 | United Kingdom | Guernsey | 29924 | 54 | 0 | 49.448196 | -2.58949 | 2022-07-31 04:21:02 | Guernsey, United Kingdom | |||
694039 | 694039 | 2022-12-23 | United Kingdom | Guernsey | 33910 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-24 04:21:02 | Guernsey, United Kingdom | |||
698050 | 698050 | 2022-03-17 | United Kingdom | Guernsey | 17849 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-18 04:20:55 | Guernsey, United Kingdom | |||
714116 | 714116 | 2022-11-01 | United Kingdom | Guernsey | 32324 | 64 | 0 | 49.448196 | -2.58949 | 2022-11-02 04:22:09 | Guernsey, United Kingdom | |||
722148 | 722148 | 2022-12-04 | United Kingdom | Guernsey | 32900 | 65 | 0 | 49.448196 | -2.58949 | 2022-12-05 04:20:58 | Guernsey, United Kingdom | |||
750005 | 750005 | 2022-04-23 | United Kingdom | Guernsey | 24201 | 43 | 0 | 49.448196 | -2.58949 | 2022-04-24 04:20:56 | Guernsey, United Kingdom | |||
798080 | 798080 | 2022-10-24 | United Kingdom | Guernsey | 32118 | 63 | 0 | 49.448196 | -2.58949 | 2022-10-25 04:21:53 | Guernsey, United Kingdom | |||
837293 | 837293 | 2022-12-02 | United Kingdom | Guernsey | 32900 | 65 | 0 | 49.448196 | -2.58949 | 2022-12-03 04:21:02 | Guernsey, United Kingdom | |||
853265 | 853265 | 2022-11-02 | United Kingdom | Guernsey | 32466 | 64 | 0 | 49.448196 | -2.58949 | 2022-11-03 04:22:05 | Guernsey, United Kingdom | |||
857281 | 857281 | 2022-09-30 | United Kingdom | Guernsey | 31309 | 63 | 0 | 49.448196 | -2.58949 | 2022-10-01 04:23:01 | Guernsey, United Kingdom | |||
864448 | 864448 | 2020-01-23 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 1/23/20 17:00 | ||||
872465 | 872465 | 2022-12-11 | United Kingdom | Guernsey | 33080 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-12 04:21:01 | Guernsey, United Kingdom | |||
879925 | 879925 | 2022-03-27 | United Kingdom | Guernsey | 20785 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-28 04:20:33 | Guernsey, United Kingdom | |||
883943 | 883943 | 2022-08-05 | United Kingdom | Guernsey | 30198 | 60 | 0 | 49.448196 | -2.58949 | 2022-08-06 04:20:56 | Guernsey, United Kingdom | |||
899810 | 899810 | 2022-07-24 | United Kingdom | Guernsey | 29601 | 54 | 0 | 49.448196 | -2.58949 | 2022-07-25 04:20:51 | Guernsey, United Kingdom | |||
903826 | 903826 | 2022-07-22 | United Kingdom | Guernsey | 29601 | 54 | 0 | 49.448196 | -2.58949 | 2022-07-23 04:20:53 | Guernsey, United Kingdom | |||
915874 | 915874 | 2022-10-29 | United Kingdom | Guernsey | 32324 | 64 | 0 | 49.448196 | -2.58949 | 2022-10-30 04:22:14 | Guernsey, United Kingdom | |||
923345 | 923345 | 2022-03-08 | United Kingdom | Guernsey | 14434 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-09 04:20:59 | Guernsey, United Kingdom | |||
942479 | 942479 | 2022-06-25 | United Kingdom | Guernsey | 26541 | 47 | 0 | 49.448196 | -2.58949 | 2022-06-26 04:21:02 | Guernsey, United Kingdom | |||
946494 | 946494 | 2022-02-28 | United Kingdom | Guernsey | 13503 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-01 04:21:09 | Guernsey, United Kingdom | |||
950511 | 950511 | 2022-06-14 | United Kingdom | Guernsey | 25874 | 47 | 0 | 49.448196 | -2.58949 | 2022-06-15 04:20:54 | Guernsey, United Kingdom | |||
954526 | 954526 | 2022-03-12 | United Kingdom | Guernsey | 15630 | 31 | 0 | 49.448196 | -2.58949 | 2022-03-13 04:20:49 | Guernsey, United Kingdom | |||
962558 | 962558 | 2022-07-19 | United Kingdom | Guernsey | 29045 | 50 | 0 | 49.448196 | -2.58949 | 2022-07-20 04:20:59 | Guernsey, United Kingdom | |||
966574 | 966574 | 2022-09-09 | United Kingdom | Guernsey | 30883 | 62 | 0 | 49.448196 | -2.58949 | 2022-09-10 04:21:10 | Guernsey, United Kingdom | |||
974581 | 974581 | 2022-06-01 | United Kingdom | Guernsey | 25703 | 47 | 0 | 49.448196 | -2.58949 | 2022-06-02 05:20:39 | Guernsey, United Kingdom | |||
994657 | 994657 | 2022-08-16 | United Kingdom | Guernsey | 30365 | 62 | 0 | 49.448196 | -2.58949 | 2022-08-17 04:20:59 | Guernsey, United Kingdom | |||
1022016 | 1022016 | 2022-12-24 | United Kingdom | Guernsey | 33910 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-25 04:21:04 | Guernsey, United Kingdom | |||
1026032 | 1026032 | 2022-11-04 | United Kingdom | Guernsey | 32466 | 64 | 0 | 49.448196 | -2.58949 | 2022-11-05 04:21:52 | Guernsey, United Kingdom | |||
1053504 | 1053504 | 2022-11-06 | United Kingdom | Guernsey | 32466 | 64 | 0 | 49.448196 | -2.58949 | 2022-11-07 04:21:26 | Guernsey, United Kingdom | |||
1061510 | 1061510 | 2022-02-23 | United Kingdom | Guernsey | 13503 | 31 | 0 | 49.448196 | -2.58949 | 2022-02-24 04:21:14 | Guernsey, United Kingdom | |||
1069540 | 1069540 | 2022-07-28 | United Kingdom | Guernsey | 29924 | 54 | 0 | 49.448196 | -2.58949 | 2022-07-29 04:20:45 | Guernsey, United Kingdom | |||
1073556 | 1073556 | 2022-08-07 | United Kingdom | Guernsey | 30198 | 60 | 0 | 49.448196 | -2.58949 | 2022-08-08 04:21:08 | Guernsey, United Kingdom | |||
1077575 | 1077575 | 2022-12-28 | United Kingdom | Guernsey | 33910 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-29 04:21:01 | Guernsey, United Kingdom | |||
1085735 | 1085735 | 2020-02-22 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-02-22T23:33:06 | ||||
1089738 | 1089738 | 2022-08-09 | United Kingdom | Guernsey | 30198 | 60 | 0 | 49.448196 | -2.58949 | 2022-08-10 04:20:57 | Guernsey, United Kingdom | |||
1101781 | 1101781 | 2022-08-03 | United Kingdom | Guernsey | 30198 | 60 | 0 | 49.448196 | -2.58949 | 2022-08-04 04:20:58 | Guernsey, United Kingdom | |||
1113236 | 1113236 | 2022-05-21 | United Kingdom | Guernsey | 25328 | 47 | 0 | 49.448196 | -2.58949 | 2022-05-22 04:20:52 | Guernsey, United Kingdom | |||
1152611 | 1152611 | 2022-12-12 | United Kingdom | Guernsey | 33080 | 66 | 0 | 49.448196 | -2.58949 | 2022-12-13 04:21:01 | Guernsey, 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]);