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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3073685 | 3073685 | 2021-11-23 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-24 04:22:14 | Channel Islands, United Kingdom | |||
3752783 | 3752783 | 2021-11-22 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-23 04:22:39 | Channel Islands, United Kingdom | |||
1017990 | 1017990 | 2021-11-21 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-22 04:22:20 | 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 | |||
165684 | 165684 | 2021-11-19 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-20 04:22:17 | Channel Islands, United Kingdom | |||
3292571 | 3292571 | 2021-11-18 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-19 04:21:40 | 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 | |||
3346277 | 3346277 | 2021-11-16 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-17 04:21:48 | Channel Islands, United Kingdom | |||
2291113 | 2291113 | 2021-11-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-16 04:21:10 | Channel Islands, United Kingdom | |||
1325887 | 1325887 | 2021-11-14 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-15 04:21:36 | 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 | |||
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 | |||
32072 | 32072 | 2021-11-11 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-12 04:22:01 | Channel Islands, United Kingdom | |||
2848511 | 2848511 | 2021-11-10 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-11 04:21:45 | Channel Islands, United Kingdom | |||
90781 | 90781 | 2021-11-09 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-10 04:21:38 | Channel Islands, United Kingdom | |||
3643209 | 3643209 | 2021-11-08 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-09 04:21:36 | Channel Islands, United Kingdom | |||
2004317 | 2004317 | 2021-11-07 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-08 04:21:43 | 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 | |||
3125163 | 3125163 | 2021-11-05 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-06 04:21:51 | 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 | |||
279839 | 279839 | 2021-11-03 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-04 04:22:20 | Channel Islands, United Kingdom | |||
47364 | 47364 | 2021-11-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-03 06:22:09 | Channel Islands, United Kingdom | |||
3515060 | 3515060 | 2021-11-01 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-02 04:22:03 | Channel Islands, United Kingdom | |||
291651 | 291651 | 2021-10-31 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-01 04:22:01 | Channel Islands, United Kingdom | |||
2724657 | 2724657 | 2021-10-30 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-31 04:22:08 | 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 | |||
8001 | 8001 | 2021-10-28 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-29 04:22:03 | 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 | |||
3495828 | 3495828 | 2021-10-26 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-27 04:22:32 | Channel Islands, United Kingdom | |||
3797550 | 3797550 | 2021-10-25 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-26 04:22:09 | 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 | |||
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 | |||
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 | |||
2127398 | 2127398 | 2021-10-21 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-22 04:21:14 | 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 | |||
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 | |||
2047506 | 2047506 | 2021-10-18 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-19 04:20:54 | Channel Islands, United Kingdom | |||
1912867 | 1912867 | 2021-10-17 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-18 04:21:10 | Channel Islands, United Kingdom | |||
938456 | 938456 | 2021-10-16 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-17 04:21:29 | Channel Islands, United Kingdom | |||
2947011 | 2947011 | 2021-10-15 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-10-16 04:21:15 | 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 | |||
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 | |||
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 |
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]);