johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "United Kingdom" and province_or_state = "Channel Islands" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1495257 | 1495257 | 2021-10-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-13 04:20:51 | Channel Islands, United Kingdom | |||
3010990 | 3010990 | 2021-10-11 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-12 04:21:09 | 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 | |||
2879863 | 2879863 | 2021-10-09 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-10 04:21:38 | Channel Islands, United Kingdom | |||
2963029 | 2963029 | 2021-10-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-09 04:21:34 | 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 | |||
2462447 | 2462447 | 2021-10-06 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-07 04:21:36 | Channel Islands, United Kingdom | |||
3836140 | 3836140 | 2021-10-05 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-06 04:21:33 | Channel Islands, United Kingdom | |||
990633 | 990633 | 2021-10-04 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-05 04:21:27 | Channel Islands, United Kingdom | |||
1277943 | 1277943 | 2021-10-03 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-04 04:21:31 | Channel Islands, United Kingdom | |||
3931696 | 3931696 | 2021-10-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-03 04:21:24 | Channel Islands, United Kingdom | |||
2135676 | 2135676 | 2021-10-01 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-02 04:21:25 | Channel Islands, United Kingdom | |||
2776633 | 2776633 | 2021-09-30 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-01 04:21:35 | 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 | |||
1337931 | 1337931 | 2021-09-28 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-29 04:21:45 | Channel Islands, United Kingdom | |||
1239300 | 1239300 | 2021-09-27 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-28 04:21:28 | Channel Islands, United Kingdom | |||
2079601 | 2079601 | 2021-09-26 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-27 04:21:16 | Channel Islands, United Kingdom | |||
1728153 | 1728153 | 2021-09-25 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-26 04:21:29 | Channel Islands, United Kingdom | |||
1924873 | 1924873 | 2021-09-24 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-25 04:21:31 | 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 | |||
3014988 | 3014988 | 2021-09-22 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-23 04:21:43 | Channel Islands, United Kingdom | |||
3761126 | 3761126 | 2021-09-21 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-22 04:21:45 | Channel Islands, United Kingdom | |||
813229 | 813229 | 2021-09-20 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-21 04:21:26 | Channel Islands, United Kingdom | |||
1818428 | 1818428 | 2021-09-19 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-20 04:21:22 | Channel Islands, United Kingdom | |||
20008 | 20008 | 2021-09-18 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-19 04:21:34 | Channel Islands, United Kingdom | |||
2621693 | 2621693 | 2021-09-17 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-18 04:21:24 | Channel Islands, United Kingdom | |||
2812401 | 2812401 | 2021-09-16 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-17 04:21:46 | Channel Islands, United Kingdom | |||
1378145 | 1378145 | 2021-09-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-16 04:22:19 | Channel Islands, United Kingdom | |||
2466444 | 2466444 | 2021-09-14 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-15 03:22:37 | Channel Islands, United Kingdom | |||
1389283 | 1389283 | 2021-09-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-14 04:21:41 | Channel Islands, United Kingdom | |||
1888652 | 1888652 | 2021-09-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-13 04:21:15 | Channel Islands, United Kingdom | |||
3809555 | 3809555 | 2021-09-11 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-12 04:21:13 | Channel Islands, United Kingdom | |||
3452495 | 3452495 | 2021-09-10 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-11 04:21:30 | Channel Islands, United Kingdom | |||
1266441 | 1266441 | 2021-09-09 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-10 04:21:20 | Channel Islands, United Kingdom | |||
2282811 | 2282811 | 2021-09-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-09 04:21:27 | 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 | |||
3197653 | 3197653 | 2021-09-06 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-07 04:21:35 | Channel Islands, United Kingdom | |||
3284521 | 3284521 | 2021-09-05 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-06 04:21:22 | Channel Islands, United Kingdom | |||
252935 | 252935 | 2021-09-04 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-05 04:21:33 | Channel Islands, United Kingdom | |||
3978216 | 3978216 | 2021-09-03 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-04 04:21:28 | Channel Islands, United Kingdom | |||
181678 | 181678 | 2021-09-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-03 04:21:20 | Channel Islands, United Kingdom | |||
70713 | 70713 | 2021-09-01 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-02 04:21:15 | Channel Islands, United Kingdom | |||
2071555 | 2071555 | 2021-08-31 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-09-01 04:21:38 | Channel Islands, United Kingdom | |||
1779009 | 1779009 | 2021-08-30 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-31 04:21:46 | Channel Islands, United Kingdom | |||
3895583 | 3895583 | 2021-08-29 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-30 04:21:23 | Channel Islands, United Kingdom | |||
2796686 | 2796686 | 2021-08-28 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-29 04:21:14 | Channel Islands, United Kingdom | |||
2926845 | 2926845 | 2021-08-27 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-28 04:21:28 | Channel Islands, United Kingdom | |||
1599859 | 1599859 | 2021-08-26 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-27 04:21:37 | Channel Islands, United Kingdom | |||
36068 | 36068 | 2021-08-25 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-26 04:21:28 | Channel Islands, United Kingdom | |||
3109107 | 3109107 | 2021-08-24 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-25 04:21:41 | Channel Islands, United Kingdom | |||
3169278 | 3169278 | 2021-08-23 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-24 04:21:19 | Channel Islands, United Kingdom | |||
2179205 | 2179205 | 2021-08-22 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-23 04:21:27 | Channel Islands, United Kingdom | |||
3559301 | 3559301 | 2021-08-21 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-22 04:21:29 | Channel Islands, United Kingdom | |||
1857643 | 1857643 | 2021-08-20 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-21 04:21:38 | 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 | |||
2521829 | 2521829 | 2021-08-18 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-19 04:21:15 | Channel Islands, United Kingdom | |||
248921 | 248921 | 2021-08-17 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-18 04:21:35 | Channel Islands, United Kingdom | |||
1607884 | 1607884 | 2021-08-16 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-17 04:21:49 | Channel Islands, United Kingdom | |||
106978 | 106978 | 2021-08-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-16 04:21:31 | 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 | |||
1487208 | 1487208 | 2021-08-13 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-14 04:21:25 | Channel Islands, United Kingdom | |||
2903338 | 2903338 | 2021-08-12 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-13 04:21:24 | Channel Islands, United Kingdom | |||
1345942 | 1345942 | 2021-08-11 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-12 04:21:25 | Channel Islands, United Kingdom | |||
2355089 | 2355089 | 2021-08-10 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-11 04:21:58 | 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 | |||
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 | |||
2207292 | 2207292 | 2021-08-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-08 04:21:33 | Channel Islands, United Kingdom | |||
1121242 | 1121242 | 2021-08-06 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-07 04:21:30 | Channel Islands, United Kingdom | |||
1960179 | 1960179 | 2021-08-05 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-06 04:21:18 | Channel Islands, United Kingdom | |||
335558 | 335558 | 2021-08-04 | United Kingdom | Channel Islands | 0 | 0 | 8322 | 1095 | 49.3723 | -2.3644 | 2021-08-05 04:21:51 | Channel Islands, United Kingdom | ||
3471829 | 3471829 | 2021-08-03 | United Kingdom | Channel Islands | 0 | 0 | 8282 | 1072 | 49.3723 | -2.3644 | 2021-08-04 04:21:25 | Channel Islands, United Kingdom | ||
3687103 | 3687103 | 2021-08-02 | United Kingdom | Channel Islands | 0 | 0 | 6570 | 2559 | 49.3723 | -2.3644 | 2021-08-03 04:21:39 | Channel Islands, United Kingdom | ||
3019002 | 3019002 | 2021-08-01 | United Kingdom | Channel Islands | 0 | 0 | 6570 | 2559 | 49.3723 | -2.3644 | 2021-08-02 04:21:36 | Channel Islands, United Kingdom | ||
3907625 | 3907625 | 2021-07-31 | United Kingdom | Channel Islands | 0 | 0 | 6564 | 2563 | 49.3723 | -2.3644 | 2021-08-01 04:21:50 | Channel Islands, United Kingdom | ||
3299830 | 3299830 | 2021-07-30 | United Kingdom | Channel Islands | 0 | 0 | 6558 | 2564 | 49.3723 | -2.3644 | 2021-07-31 04:21:35 | Channel Islands, United Kingdom | ||
3389041 | 3389041 | 2021-07-29 | United Kingdom | Channel Islands | 0 | 0 | 6277 | 2764 | 49.3723 | -2.3644 | 2021-07-30 04:21:34 | 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 | ||
1309807 | 1309807 | 2021-07-27 | United Kingdom | Channel Islands | 0 | 0 | 5831 | 3009 | 49.3723 | -2.3644 | 2021-07-28 04:21:39 | Channel Islands, United Kingdom | ||
3221950 | 3221950 | 2021-07-26 | United Kingdom | Channel Islands | 0 | 0 | 5489 | 3217 | 49.3723 | -2.3644 | 2021-07-27 04:21:18 | Channel Islands, United Kingdom | ||
1382159 | 1382159 | 2021-07-25 | United Kingdom | Channel Islands | 0 | 0 | 5188 | 3163 | 49.3723 | -2.3644 | 2021-07-26 04:21:28 | Channel Islands, United Kingdom | ||
1333899 | 1333899 | 2021-07-24 | United Kingdom | Channel Islands | 0 | 0 | 5182 | 3165 | 49.3723 | -2.3644 | 2021-07-25 04:22:12 | Channel Islands, United Kingdom | ||
3141203 | 3141203 | 2021-07-23 | United Kingdom | Channel Islands | 0 | 0 | 5182 | 3159 | 49.3723 | -2.3644 | 2021-07-24 00:21:36 | Channel Islands, United Kingdom | ||
3479963 | 3479963 | 2021-07-22 | United Kingdom | Channel Islands | 0 | 0 | 5022 | 3132 | 49.3723 | -2.3644 | 2021-07-23 04:21:29 | Channel Islands, United Kingdom | ||
3335182 | 3335182 | 2021-07-21 | United Kingdom | Channel Islands | 0 | 0 | 4797 | 3102 | 49.3723 | -2.3644 | 2021-07-22 04:21:19 | Channel Islands, United Kingdom | ||
2375163 | 2375163 | 2021-07-20 | United Kingdom | Channel Islands | 0 | 0 | 4640 | 3040 | 49.3723 | -2.3644 | 2021-07-21 04:21:40 | 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 | ||
2677465 | 2677465 | 2021-07-18 | United Kingdom | Channel Islands | 0 | 0 | 4448 | 2072 | 49.3723 | -2.3644 | 2021-07-19 04:21:24 | Channel Islands, United Kingdom | ||
3709777 | 3709777 | 2021-07-17 | United Kingdom | Channel Islands | 0 | 0 | 4448 | 2072 | 49.3723 | -2.3644 | 2021-07-18 04:22:07 | Channel Islands, United Kingdom | ||
2951008 | 2951008 | 2021-07-16 | United Kingdom | Channel Islands | 0 | 0 | 4281 | 2228 | 49.3723 | -2.3644 | 2021-07-17 04:22:22 | Channel Islands, United Kingdom | ||
299664 | 299664 | 2021-07-15 | United Kingdom | Channel Islands | 0 | 0 | 4281 | 2016 | 49.3723 | -2.3644 | 2021-07-16 04:21:22 | Channel Islands, United Kingdom | ||
3635609 | 3635609 | 2021-07-14 | United Kingdom | Channel Islands | 0 | 0 | 4281 | 1734 | 49.3723 | -2.3644 | 2021-07-15 04:21:48 | 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 | ||
3744733 | 3744733 | 2021-07-12 | United Kingdom | Channel Islands | 0 | 0 | 4162 | 1414 | 49.3723 | -2.3644 | 2021-07-13 04:21:18 | Channel Islands, United Kingdom | ||
3663246 | 3663246 | 2021-07-11 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 1041 | 49.3723 | -2.3644 | 2021-07-12 04:21:34 | 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 | ||
833249 | 833249 | 2021-07-09 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 1041 | 49.3723 | -2.3644 | 2021-07-10 04:21:25 | 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 | ||
1444235 | 1444235 | 2021-07-07 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 634 | 49.3723 | -2.3644 | 2021-07-08 04:21:26 | Channel Islands, United Kingdom | ||
2697340 | 2697340 | 2021-07-06 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 634 | 49.3723 | -2.3644 | 2021-07-07 04:21:20 | Channel Islands, United Kingdom | ||
1936089 | 1936089 | 2021-07-05 | United Kingdom | Channel Islands | 0 | 0 | 3994 | 441 | 49.3723 | -2.3644 | 2021-07-06 04:21:32 | 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]);