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 = "Jersey" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28063 | 28063 | 2022-03-20 | United Kingdom | Jersey | 42675 | 116 | 0 | 49.2138 | -2.1358 | 2022-03-21 04:20:50 | Jersey, United Kingdom | |||
40328 | 40328 | 2020-03-05 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-05T14:53:03 | ||||
62720 | 62720 | 2020-03-07 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-07T11:13:04 | ||||
66729 | 66729 | 2022-11-12 | United Kingdom | Jersey | 62014 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-13 04:21:14 | Jersey, United Kingdom | |||
94806 | 94806 | 2022-07-23 | United Kingdom | Jersey | 57541 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-24 04:20:47 | Jersey, United Kingdom | |||
98985 | 98985 | 2020-03-04 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-04T12:53:03 | ||||
107126 | 107126 | 2020-02-15 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-15T23:13:05 | ||||
118416 | 118416 | 2022-09-06 | United Kingdom | Jersey | 58890 | 136 | 0 | 49.2138 | -2.1358 | 2022-09-07 04:20:59 | Jersey, United Kingdom | |||
134417 | 134417 | 2022-10-04 | United Kingdom | Jersey | 59874 | 138 | 0 | 49.2138 | -2.1358 | 2022-10-05 04:23:06 | Jersey, United Kingdom | |||
145651 | 145651 | 2022-07-09 | United Kingdom | Jersey | 55473 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-10 04:20:54 | Jersey, United Kingdom | |||
161675 | 161675 | 2022-03-29 | United Kingdom | Jersey | 45770 | 120 | 0 | 49.2138 | -2.1358 | 2022-03-30 04:20:45 | Jersey, United Kingdom | |||
169708 | 169708 | 2022-06-21 | United Kingdom | Jersey | 51792 | 131 | 0 | 49.2138 | -2.1358 | 2022-06-22 04:20:54 | Jersey, United Kingdom | |||
197825 | 197825 | 2020-01-24 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/24/20 17:00 | ||||
197916 | 197916 | 2020-01-29 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/29/20 19:30 | ||||
201926 | 201926 | 2022-10-19 | United Kingdom | Jersey | 61048 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-20 04:22:59 | Jersey, United Kingdom | |||
221647 | 221647 | 2022-12-26 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-27 04:21:07 | Jersey, United Kingdom | |||
225658 | 225658 | 2022-05-09 | United Kingdom | Jersey | 50033 | 127 | 0 | 49.2138 | -2.1358 | 2022-05-10 04:20:50 | Jersey, United Kingdom | |||
232890 | 232890 | 2022-05-31 | United Kingdom | Jersey | 50611 | 129 | 0 | 49.2138 | -2.1358 | 2022-06-01 04:20:55 | Jersey, United Kingdom | |||
256978 | 256978 | 2022-09-08 | United Kingdom | Jersey | 59163 | 136 | 0 | 49.2138 | -2.1358 | 2022-09-09 04:21:11 | Jersey, United Kingdom | |||
260997 | 260997 | 2022-12-10 | United Kingdom | Jersey | 63595 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-11 04:20:50 | Jersey, United Kingdom | |||
261191 | 261191 | 2020-03-03 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-03T11:43:02 | ||||
265195 | 265195 | 2022-03-15 | United Kingdom | Jersey | 41635 | 116 | 0 | 49.2138 | -2.1358 | 2022-03-16 04:20:50 | Jersey, United Kingdom | |||
295680 | 295680 | 2022-11-15 | United Kingdom | Jersey | 62317 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-16 04:21:09 | Jersey, United Kingdom | |||
307531 | 307531 | 2022-04-16 | United Kingdom | Jersey | 48529 | 121 | 0 | 49.2138 | -2.1358 | 2022-04-17 04:20:59 | Jersey, United Kingdom | |||
311552 | 311552 | 2022-12-13 | United Kingdom | Jersey | 63595 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-14 04:21:04 | Jersey, United Kingdom | |||
315568 | 315568 | 2022-11-13 | United Kingdom | Jersey | 62014 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-14 04:21:09 | Jersey, United Kingdom | |||
323600 | 323600 | 2022-10-30 | United Kingdom | Jersey | 61656 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-31 04:21:36 | Jersey, United Kingdom | |||
331574 | 331574 | 2022-12-27 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-28 04:21:04 | Jersey, United Kingdom | |||
339599 | 339599 | 2022-03-18 | United Kingdom | Jersey | 42675 | 116 | 0 | 49.2138 | -2.1358 | 2022-03-19 04:20:47 | Jersey, United Kingdom | |||
339951 | 339951 | 2020-03-21 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-21T10:13:08 | ||||
351964 | 351964 | 2022-12-14 | United Kingdom | Jersey | 63595 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-15 04:20:58 | Jersey, United Kingdom | |||
359989 | 359989 | 2022-03-11 | United Kingdom | Jersey | 40460 | 115 | 0 | 49.2138 | -2.1358 | 2022-03-12 04:20:50 | Jersey, United Kingdom | |||
364005 | 364005 | 2022-05-07 | United Kingdom | Jersey | 50033 | 127 | 0 | 49.2138 | -2.1358 | 2022-05-08 04:20:49 | Jersey, United Kingdom | |||
375864 | 375864 | 2022-09-13 | United Kingdom | Jersey | 59270 | 137 | 0 | 49.2138 | -2.1358 | 2022-09-14 04:20:44 | Jersey, United Kingdom | |||
387891 | 387891 | 2022-09-23 | United Kingdom | Jersey | 59874 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-24 04:21:40 | Jersey, United Kingdom | |||
399932 | 399932 | 2022-10-07 | United Kingdom | Jersey | 60646 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-08 04:22:56 | Jersey, United Kingdom | |||
415902 | 415902 | 2020-01-26 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/26/20 16:00 | ||||
423003 | 423003 | 2022-09-18 | United Kingdom | Jersey | 59555 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-19 04:21:49 | Jersey, United Kingdom | |||
435025 | 435025 | 2022-11-03 | United Kingdom | Jersey | 61656 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-04 04:22:11 | Jersey, United Kingdom | |||
455055 | 455055 | 2022-12-21 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-22 04:20:56 | Jersey, United Kingdom | |||
467059 | 467059 | 2022-05-02 | United Kingdom | Jersey | 49810 | 126 | 0 | 49.2138 | -2.1358 | 2022-05-03 04:21:00 | Jersey, United Kingdom | |||
479106 | 479106 | 2022-06-26 | United Kingdom | Jersey | 51792 | 131 | 0 | 49.2138 | -2.1358 | 2022-06-27 04:21:00 | Jersey, United Kingdom | |||
479249 | 479249 | 2020-02-25 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-25T15:23:04 | ||||
483258 | 483258 | 2022-11-08 | United Kingdom | Jersey | 62014 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-09 04:21:22 | Jersey, United Kingdom | |||
491288 | 491288 | 2022-11-25 | United Kingdom | Jersey | 62826 | 142 | 0 | 49.2138 | -2.1358 | 2022-11-26 04:21:11 | Jersey, United Kingdom | |||
503331 | 503331 | 2022-04-02 | United Kingdom | Jersey | 46596 | 120 | 0 | 49.2138 | -2.1358 | 2022-04-03 04:20:48 | Jersey, United Kingdom | |||
507352 | 507352 | 2022-12-17 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-18 04:21:03 | Jersey, United Kingdom | |||
519396 | 519396 | 2022-10-15 | United Kingdom | Jersey | 61048 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-16 04:22:39 | Jersey, United Kingdom | |||
542420 | 542420 | 2022-10-26 | United Kingdom | Jersey | 61389 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-27 04:22:01 | Jersey, United Kingdom | |||
546436 | 546436 | 2022-12-15 | United Kingdom | Jersey | 63595 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-16 04:21:01 | Jersey, United Kingdom | |||
562470 | 562470 | 2022-06-16 | United Kingdom | Jersey | 51132 | 129 | 0 | 49.2138 | -2.1358 | 2022-06-17 04:20:56 | Jersey, United Kingdom | |||
562642 | 562642 | 2020-03-01 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-01T10:13:19 | ||||
566763 | 566763 | 2020-02-06 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-06T23:23:02 | ||||
578495 | 578495 | 2022-02-25 | United Kingdom | Jersey | 36704 | 112 | 0 | 49.2138 | -2.1358 | 2022-02-26 04:21:12 | Jersey, United Kingdom | |||
597322 | 597322 | 2022-07-01 | United Kingdom | Jersey | 53889 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-02 04:21:16 | Jersey, United Kingdom | |||
617521 | 617521 | 2020-02-27 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-27T12:13:14 | ||||
621530 | 621530 | 2022-11-05 | United Kingdom | Jersey | 62014 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-06 04:21:24 | Jersey, United Kingdom | |||
625542 | 625542 | 2022-05-22 | United Kingdom | Jersey | 50439 | 129 | 0 | 49.2138 | -2.1358 | 2022-05-26 04:20:50 | Jersey, United Kingdom | |||
633573 | 633573 | 2022-07-12 | United Kingdom | Jersey | 55473 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-13 04:20:58 | Jersey, United Kingdom | |||
657973 | 657973 | 2020-03-09 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-09T14:33:03 | ||||
661977 | 661977 | 2022-05-13 | United Kingdom | Jersey | 50033 | 127 | 0 | 49.2138 | -2.1358 | 2022-05-14 04:20:48 | Jersey, United Kingdom | |||
673964 | 673964 | 2022-07-21 | United Kingdom | Jersey | 56803 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-22 04:21:15 | Jersey, United Kingdom | |||
677980 | 677980 | 2022-07-30 | United Kingdom | Jersey | 58003 | 133 | 0 | 49.2138 | -2.1358 | 2022-07-31 04:21:02 | Jersey, United Kingdom | |||
694041 | 694041 | 2022-12-23 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-24 04:21:02 | Jersey, United Kingdom | |||
698052 | 698052 | 2022-03-17 | United Kingdom | Jersey | 42361 | 116 | 0 | 49.2138 | -2.1358 | 2022-03-18 04:20:55 | Jersey, United Kingdom | |||
714118 | 714118 | 2022-11-01 | United Kingdom | Jersey | 61656 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-02 04:22:09 | Jersey, United Kingdom | |||
722150 | 722150 | 2022-12-04 | United Kingdom | Jersey | 63128 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-05 04:20:58 | Jersey, United Kingdom | |||
750007 | 750007 | 2022-04-23 | United Kingdom | Jersey | 49322 | 123 | 0 | 49.2138 | -2.1358 | 2022-04-24 04:20:56 | Jersey, United Kingdom | |||
798082 | 798082 | 2022-10-24 | United Kingdom | Jersey | 61389 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-25 04:21:53 | Jersey, United Kingdom | |||
837295 | 837295 | 2022-12-02 | United Kingdom | Jersey | 63128 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-03 04:21:02 | Jersey, United Kingdom | |||
853267 | 853267 | 2022-11-02 | United Kingdom | Jersey | 61656 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-03 04:22:05 | Jersey, United Kingdom | |||
857283 | 857283 | 2022-09-30 | United Kingdom | Jersey | 59874 | 138 | 0 | 49.2138 | -2.1358 | 2022-10-01 04:23:01 | Jersey, United Kingdom | |||
864447 | 864447 | 2020-01-23 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/23/20 17:00 | ||||
872467 | 872467 | 2022-12-11 | United Kingdom | Jersey | 63595 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-12 04:21:01 | Jersey, United Kingdom | |||
879927 | 879927 | 2022-03-27 | United Kingdom | Jersey | 44859 | 118 | 0 | 49.2138 | -2.1358 | 2022-03-28 04:20:33 | Jersey, United Kingdom | |||
883945 | 883945 | 2022-08-05 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-06 04:20:56 | Jersey, United Kingdom | |||
899812 | 899812 | 2022-07-24 | United Kingdom | Jersey | 57541 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-25 04:20:51 | Jersey, United Kingdom | |||
903828 | 903828 | 2022-07-22 | United Kingdom | Jersey | 57541 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-23 04:20:53 | Jersey, United Kingdom | |||
915876 | 915876 | 2022-10-29 | United Kingdom | Jersey | 61656 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-30 04:22:14 | Jersey, United Kingdom | |||
923347 | 923347 | 2022-03-08 | United Kingdom | Jersey | 39490 | 115 | 0 | 49.2138 | -2.1358 | 2022-03-09 04:20:59 | Jersey, United Kingdom | |||
942481 | 942481 | 2022-06-25 | United Kingdom | Jersey | 51792 | 131 | 0 | 49.2138 | -2.1358 | 2022-06-26 04:21:02 | Jersey, United Kingdom | |||
946496 | 946496 | 2022-02-28 | United Kingdom | Jersey | 36881 | 112 | 0 | 49.2138 | -2.1358 | 2022-03-01 04:21:09 | Jersey, United Kingdom | |||
950513 | 950513 | 2022-06-14 | United Kingdom | Jersey | 51132 | 129 | 0 | 49.2138 | -2.1358 | 2022-06-15 04:20:54 | Jersey, United Kingdom | |||
954528 | 954528 | 2022-03-12 | United Kingdom | Jersey | 40460 | 115 | 0 | 49.2138 | -2.1358 | 2022-03-13 04:20:49 | Jersey, United Kingdom | |||
962560 | 962560 | 2022-07-19 | United Kingdom | Jersey | 56803 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-20 04:20:59 | Jersey, United Kingdom | |||
966576 | 966576 | 2022-09-09 | United Kingdom | Jersey | 59163 | 136 | 0 | 49.2138 | -2.1358 | 2022-09-10 04:21:10 | Jersey, United Kingdom | |||
974583 | 974583 | 2022-06-01 | United Kingdom | Jersey | 50611 | 129 | 0 | 49.2138 | -2.1358 | 2022-06-02 05:20:39 | Jersey, United Kingdom | |||
994659 | 994659 | 2022-08-16 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-17 04:20:59 | Jersey, United Kingdom | |||
1022018 | 1022018 | 2022-12-24 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-25 04:21:04 | Jersey, United Kingdom | |||
1026034 | 1026034 | 2022-11-04 | United Kingdom | Jersey | 62014 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-05 04:21:52 | Jersey, United Kingdom | |||
1053506 | 1053506 | 2022-11-06 | United Kingdom | Jersey | 62014 | 141 | 0 | 49.2138 | -2.1358 | 2022-11-07 04:21:26 | Jersey, United Kingdom | |||
1061512 | 1061512 | 2022-02-23 | United Kingdom | Jersey | 36233 | 110 | 0 | 49.2138 | -2.1358 | 2022-02-24 04:21:14 | Jersey, United Kingdom | |||
1069542 | 1069542 | 2022-07-28 | United Kingdom | Jersey | 57541 | 132 | 0 | 49.2138 | -2.1358 | 2022-07-29 04:20:45 | Jersey, United Kingdom | |||
1073558 | 1073558 | 2022-08-07 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-08 04:21:08 | Jersey, United Kingdom | |||
1077577 | 1077577 | 2022-12-28 | United Kingdom | Jersey | 65130 | 146 | 0 | 49.2138 | -2.1358 | 2022-12-29 04:21:01 | Jersey, United Kingdom | |||
1085734 | 1085734 | 2020-02-22 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-22T23:33:06 | ||||
1089740 | 1089740 | 2022-08-09 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-10 04:20:57 | Jersey, United Kingdom | |||
1101783 | 1101783 | 2022-08-03 | United Kingdom | Jersey | 58003 | 133 | 0 | 49.2138 | -2.1358 | 2022-08-04 04:20:58 | Jersey, United Kingdom | |||
1113238 | 1113238 | 2022-05-21 | United Kingdom | Jersey | 50439 | 129 | 0 | 49.2138 | -2.1358 | 2022-05-22 04:20:52 | Jersey, United Kingdom | |||
1152613 | 1152613 | 2022-12-12 | United Kingdom | Jersey | 63595 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-13 04:21:01 | Jersey, 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]);