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)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1152797 | 1152797 | 2020-03-02 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-02T15:03:23 | ||||
1160815 | 1160815 | 2022-04-29 | United Kingdom | Jersey | 49778 | 126 | 0 | 49.2138 | -2.1358 | 2022-04-30 04:21:05 | Jersey, United Kingdom | |||
1164833 | 1164833 | 2022-08-18 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-19 04:20:54 | Jersey, United Kingdom | |||
1172862 | 1172862 | 2022-05-20 | United Kingdom | Jersey | 50439 | 129 | 0 | 49.2138 | -2.1358 | 2022-05-21 04:20:58 | Jersey, United Kingdom | |||
1177183 | 1177183 | 2020-03-18 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-18T12:13:09 | ||||
1188409 | 1188409 | 2022-05-18 | United Kingdom | Jersey | 50233 | 127 | 0 | 49.2138 | -2.1358 | 2022-05-19 04:20:54 | Jersey, United Kingdom | |||
1192545 | 1192545 | 2020-02-14 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-14T23:33:02 | ||||
1203471 | 1203471 | 2022-07-06 | United Kingdom | Jersey | 53889 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-07 04:20:55 | Jersey, United Kingdom | |||
1215216 | 1215216 | 2022-07-11 | United Kingdom | Jersey | 55473 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-12 04:20:51 | Jersey, United Kingdom | |||
1227261 | 1227261 | 2022-04-14 | United Kingdom | Jersey | 48529 | 121 | 0 | 49.2138 | -2.1358 | 2022-04-15 04:20:57 | Jersey, United Kingdom | |||
1243329 | 1243329 | 2022-11-28 | United Kingdom | Jersey | 62826 | 142 | 0 | 49.2138 | -2.1358 | 2022-11-29 04:21:05 | Jersey, United Kingdom | |||
1243447 | 1243447 | 2020-02-17 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-17T23:13:06 | ||||
1254422 | 1254422 | 2022-08-23 | United Kingdom | Jersey | 58733 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-24 04:20:46 | Jersey, United Kingdom | |||
1301715 | 1301715 | 2022-02-17 | United Kingdom | Jersey | 35072 | 108 | 0 | 49.2138 | -2.1358 | 2022-02-18 04:21:04 | Jersey, United Kingdom | |||
1305829 | 1305829 | 2020-01-28 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/28/20 23:00 | ||||
1317863 | 1317863 | 2022-05-27 | United Kingdom | Jersey | 50611 | 129 | 0 | 49.2138 | -2.1358 | 2022-05-28 04:21:07 | Jersey, United Kingdom | |||
1329910 | 1329910 | 2022-04-26 | United Kingdom | Jersey | 49575 | 124 | 0 | 49.2138 | -2.1358 | 2022-04-27 04:20:52 | Jersey, United Kingdom | |||
1349985 | 1349985 | 2022-08-10 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-11 04:20:49 | Jersey, United Kingdom | |||
1366136 | 1366136 | 2020-02-08 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-08T23:33:06 | ||||
1370145 | 1370145 | 2022-10-28 | United Kingdom | Jersey | 61656 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-29 04:21:13 | Jersey, United Kingdom | |||
1374161 | 1374161 | 2022-09-21 | United Kingdom | Jersey | 59555 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-22 04:22:56 | Jersey, United Kingdom | |||
1397342 | 1397342 | 2022-09-02 | United Kingdom | Jersey | 58890 | 136 | 0 | 49.2138 | -2.1358 | 2022-09-03 04:21:04 | Jersey, United Kingdom | |||
1401356 | 1401356 | 2022-05-06 | United Kingdom | Jersey | 50033 | 127 | 0 | 49.2138 | -2.1358 | 2022-05-07 04:21:09 | Jersey, United Kingdom | |||
1408708 | 1408708 | 2022-08-02 | United Kingdom | Jersey | 58003 | 133 | 0 | 49.2138 | -2.1358 | 2022-08-03 04:20:59 | Jersey, United Kingdom | |||
1420751 | 1420751 | 2022-07-08 | United Kingdom | Jersey | 55473 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-09 04:20:59 | Jersey, United Kingdom | |||
1424767 | 1424767 | 2022-06-08 | United Kingdom | Jersey | 50740 | 129 | 0 | 49.2138 | -2.1358 | 2022-06-09 04:20:54 | Jersey, United Kingdom | |||
1440246 | 1440246 | 2022-03-28 | United Kingdom | Jersey | 45146 | 119 | 0 | 49.2138 | -2.1358 | 2022-03-29 04:20:46 | Jersey, United Kingdom | |||
1463743 | 1463743 | 2020-03-15 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-15T18:20:18 | ||||
1471763 | 1471763 | 2022-03-24 | United Kingdom | Jersey | 44492 | 118 | 0 | 49.2138 | -2.1358 | 2022-03-25 04:20:46 | Jersey, United Kingdom | |||
1491251 | 1491251 | 2022-07-26 | United Kingdom | Jersey | 57541 | 132 | 0 | 49.2138 | -2.1358 | 2022-07-27 04:21:04 | Jersey, United Kingdom | |||
1507263 | 1507263 | 2022-05-16 | United Kingdom | Jersey | 50233 | 127 | 0 | 49.2138 | -2.1358 | 2022-05-17 04:20:59 | Jersey, United Kingdom | |||
1515071 | 1515071 | 2022-02-24 | United Kingdom | Jersey | 36420 | 111 | 0 | 49.2138 | -2.1358 | 2022-02-25 04:21:11 | Jersey, United Kingdom | |||
1527187 | 1527187 | 2020-03-19 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-19T10:13:14 | ||||
1527478 | 1527478 | 2020-03-08 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-08T14:43:03 | ||||
1527572 | 1527572 | 2020-01-30 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/30/20 16:00 | ||||
1535593 | 1535593 | 2022-08-26 | United Kingdom | Jersey | 58890 | 136 | 0 | 49.2138 | -2.1358 | 2022-08-27 04:20:57 | Jersey, United Kingdom | |||
1543621 | 1543621 | 2022-03-31 | United Kingdom | Jersey | 46356 | 120 | 0 | 49.2138 | -2.1358 | 2022-04-01 04:20:28 | Jersey, United Kingdom | |||
1551634 | 1551634 | 2022-03-07 | United Kingdom | Jersey | 38796 | 114 | 0 | 49.2138 | -2.1358 | 2022-03-08 04:20:54 | Jersey, United Kingdom | |||
1559751 | 1559751 | 2020-02-13 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-13T14:13:06 | ||||
1563760 | 1563760 | 2022-09-28 | United Kingdom | Jersey | 59874 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-29 04:22:34 | Jersey, United Kingdom | |||
1575799 | 1575799 | 2022-05-03 | United Kingdom | Jersey | 49810 | 126 | 0 | 49.2138 | -2.1358 | 2022-05-04 04:20:59 | Jersey, United Kingdom | |||
1579815 | 1579815 | 2022-04-10 | United Kingdom | Jersey | 47746 | 121 | 0 | 49.2138 | -2.1358 | 2022-04-11 04:21:02 | Jersey, United Kingdom | |||
1595875 | 1595875 | 2022-10-21 | United Kingdom | Jersey | 61389 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-22 04:22:53 | Jersey, United Kingdom | |||
1611927 | 1611927 | 2022-07-20 | United Kingdom | Jersey | 56803 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-21 04:21:10 | Jersey, United Kingdom | |||
1623941 | 1623941 | 2022-11-22 | United Kingdom | Jersey | 62589 | 142 | 0 | 49.2138 | -2.1358 | 2022-11-23 04:21:06 | Jersey, United Kingdom | |||
1627957 | 1627957 | 2022-09-22 | United Kingdom | Jersey | 59555 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-23 04:23:13 | Jersey, United Kingdom | |||
1631973 | 1631973 | 2022-12-18 | United Kingdom | Jersey | 64316 | 144 | 0 | 49.2138 | -2.1358 | 2022-12-19 04:21:03 | Jersey, United Kingdom | |||
1644014 | 1644014 | 2022-11-20 | United Kingdom | Jersey | 62589 | 142 | 0 | 49.2138 | -2.1358 | 2022-11-21 04:21:05 | Jersey, United Kingdom | |||
1648025 | 1648025 | 2022-03-03 | United Kingdom | Jersey | 38159 | 113 | 0 | 49.2138 | -2.1358 | 2022-03-04 04:21:09 | Jersey, United Kingdom | |||
1652042 | 1652042 | 2022-06-23 | United Kingdom | Jersey | 51792 | 131 | 0 | 49.2138 | -2.1358 | 2022-06-24 04:20:58 | Jersey, United Kingdom | |||
1656057 | 1656057 | 2022-04-09 | United Kingdom | Jersey | 47746 | 121 | 0 | 49.2138 | -2.1358 | 2022-04-10 04:20:52 | Jersey, United Kingdom | |||
1660073 | 1660073 | 2022-03-19 | United Kingdom | Jersey | 42675 | 116 | 0 | 49.2138 | -2.1358 | 2022-03-20 04:20:45 | Jersey, United Kingdom | |||
1684167 | 1684167 | 2022-08-29 | United Kingdom | Jersey | 58890 | 136 | 0 | 49.2138 | -2.1358 | 2022-08-30 04:21:03 | Jersey, United Kingdom | |||
1699997 | 1699997 | 2022-04-28 | United Kingdom | Jersey | 49717 | 124 | 0 | 49.2138 | -2.1358 | 2022-04-29 04:20:59 | Jersey, United Kingdom | |||
1720142 | 1720142 | 2020-02-19 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-19T23:23:02 | ||||
1724146 | 1724146 | 2022-03-25 | United Kingdom | Jersey | 44859 | 118 | 0 | 49.2138 | -2.1358 | 2022-03-26 04:20:23 | Jersey, United Kingdom | |||
1758965 | 1758965 | 2022-11-18 | United Kingdom | Jersey | 62589 | 142 | 0 | 49.2138 | -2.1358 | 2022-11-19 04:21:14 | Jersey, United Kingdom | |||
1766991 | 1766991 | 2022-06-20 | United Kingdom | Jersey | 51792 | 131 | 0 | 49.2138 | -2.1358 | 2022-06-21 04:20:56 | Jersey, United Kingdom | |||
1771007 | 1771007 | 2022-07-03 | United Kingdom | Jersey | 53889 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-04 04:20:54 | Jersey, United Kingdom | |||
1783173 | 1783173 | 2020-02-18 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-18T23:13:11 | ||||
1787179 | 1787179 | 2022-07-29 | United Kingdom | Jersey | 58003 | 133 | 0 | 49.2138 | -2.1358 | 2022-07-30 04:20:42 | Jersey, United Kingdom | |||
1802403 | 1802403 | 2020-01-22 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 1/22/2020 17:00 | ||||
1814443 | 1814443 | 2022-10-05 | United Kingdom | Jersey | 60252 | 139 | 0 | 49.2138 | -2.1358 | 2022-10-06 04:21:22 | Jersey, United Kingdom | |||
1833821 | 1833821 | 2022-10-25 | United Kingdom | Jersey | 61389 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-26 04:22:19 | Jersey, United Kingdom | |||
1849638 | 1849638 | 2022-04-18 | United Kingdom | Jersey | 48529 | 121 | 0 | 49.2138 | -2.1358 | 2022-04-19 04:21:00 | Jersey, United Kingdom | |||
1853655 | 1853655 | 2022-05-26 | United Kingdom | Jersey | 50439 | 129 | 0 | 49.2138 | -2.1358 | 2022-05-27 04:20:56 | Jersey, United Kingdom | |||
1869141 | 1869141 | 2022-03-10 | United Kingdom | Jersey | 40111 | 115 | 0 | 49.2138 | -2.1358 | 2022-03-11 04:20:50 | Jersey, United Kingdom | |||
1880651 | 1880651 | 2022-08-28 | United Kingdom | Jersey | 58890 | 136 | 0 | 49.2138 | -2.1358 | 2022-08-29 04:21:06 | Jersey, United Kingdom | |||
1888800 | 1888800 | 2020-02-16 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-16T23:53:01 | ||||
1892809 | 1892809 | 2022-09-14 | United Kingdom | Jersey | 59270 | 137 | 0 | 49.2138 | -2.1358 | 2022-09-15 04:21:02 | Jersey, United Kingdom | |||
1908859 | 1908859 | 2022-03-22 | United Kingdom | Jersey | 43796 | 116 | 0 | 49.2138 | -2.1358 | 2022-03-23 04:20:48 | Jersey, United Kingdom | |||
1944146 | 1944146 | 2022-08-06 | United Kingdom | Jersey | 58331 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-07 04:20:54 | Jersey, United Kingdom | |||
1948161 | 1948161 | 2022-06-10 | United Kingdom | Jersey | 51132 | 129 | 0 | 49.2138 | -2.1358 | 2022-06-11 04:21:01 | Jersey, United Kingdom | |||
1952176 | 1952176 | 2022-04-12 | United Kingdom | Jersey | 48162 | 121 | 0 | 49.2138 | -2.1358 | 2022-04-13 04:21:03 | Jersey, United Kingdom | |||
1968241 | 1968241 | 2022-11-30 | United Kingdom | Jersey | 62826 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-01 04:21:03 | Jersey, United Kingdom | |||
1972254 | 1972254 | 2022-08-13 | United Kingdom | Jersey | 58536 | 135 | 0 | 49.2138 | -2.1358 | 2022-08-14 04:20:55 | Jersey, United Kingdom | |||
1980284 | 1980284 | 2022-09-25 | United Kingdom | Jersey | 59874 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-26 04:20:52 | Jersey, United Kingdom | |||
1988314 | 1988314 | 2022-12-07 | United Kingdom | Jersey | 63128 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-08 04:21:07 | Jersey, United Kingdom | |||
1996322 | 1996322 | 2022-03-01 | United Kingdom | Jersey | 37499 | 112 | 0 | 49.2138 | -2.1358 | 2022-03-02 04:21:07 | Jersey, United Kingdom | |||
2012356 | 2012356 | 2022-08-04 | United Kingdom | Jersey | 58003 | 133 | 0 | 49.2138 | -2.1358 | 2022-08-05 04:20:52 | Jersey, United Kingdom | |||
2020391 | 2020391 | 2022-09-20 | United Kingdom | Jersey | 59555 | 138 | 0 | 49.2138 | -2.1358 | 2022-09-21 04:23:22 | Jersey, United Kingdom | |||
2028421 | 2028421 | 2022-10-17 | United Kingdom | Jersey | 61048 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-18 04:22:42 | Jersey, United Kingdom | |||
2032432 | 2032432 | 2022-04-24 | United Kingdom | Jersey | 49322 | 123 | 0 | 49.2138 | -2.1358 | 2022-04-25 04:20:56 | Jersey, United Kingdom | |||
2036453 | 2036453 | 2022-10-14 | United Kingdom | Jersey | 61048 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-15 04:22:00 | Jersey, United Kingdom | |||
2051531 | 2051531 | 2022-05-25 | United Kingdom | Jersey | 50439 | 129 | 0 | 49.2138 | -2.1358 | 2022-05-26 04:20:50 | Jersey, United Kingdom | |||
2067571 | 2067571 | 2022-11-19 | United Kingdom | Jersey | 62589 | 142 | 0 | 49.2138 | -2.1358 | 2022-11-20 04:21:08 | Jersey, United Kingdom | |||
2087622 | 2087622 | 2022-05-15 | United Kingdom | Jersey | 50033 | 127 | 0 | 49.2138 | -2.1358 | 2022-05-16 04:20:47 | Jersey, United Kingdom | |||
2091756 | 2091756 | 2020-02-05 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-05T23:13:12 | ||||
2095760 | 2095760 | 2022-03-05 | United Kingdom | Jersey | 38480 | 113 | 0 | 49.2138 | -2.1358 | 2022-03-06 04:20:49 | Jersey, United Kingdom | |||
2099778 | 2099778 | 2022-08-27 | United Kingdom | Jersey | 58890 | 136 | 0 | 49.2138 | -2.1358 | 2022-08-28 04:21:02 | Jersey, United Kingdom | |||
2103797 | 2103797 | 2022-11-26 | United Kingdom | Jersey | 62826 | 142 | 0 | 49.2138 | -2.1358 | 2022-11-27 04:21:05 | Jersey, United Kingdom | |||
2111359 | 2111359 | 2020-03-14 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-14T10:13:09 | ||||
2119379 | 2119379 | 2022-04-08 | United Kingdom | Jersey | 47746 | 121 | 0 | 49.2138 | -2.1358 | 2022-04-09 04:20:42 | Jersey, United Kingdom | |||
2127670 | 2127670 | 2020-03-11 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-11T10:53:02 | ||||
2135816 | 2135816 | 2020-02-21 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-02-21T13:03:09 | ||||
2139825 | 2139825 | 2022-12-01 | United Kingdom | Jersey | 62826 | 142 | 0 | 49.2138 | -2.1358 | 2022-12-02 04:21:07 | Jersey, United Kingdom | |||
2143836 | 2143836 | 2022-03-09 | United Kingdom | Jersey | 39802 | 115 | 0 | 49.2138 | -2.1358 | 2022-03-10 04:20:48 | Jersey, United Kingdom | |||
2151305 | 2151305 | 2022-06-27 | United Kingdom | Jersey | 51792 | 131 | 0 | 49.2138 | -2.1358 | 2022-06-28 04:20:58 | Jersey, United Kingdom | |||
2155322 | 2155322 | 2022-07-16 | United Kingdom | Jersey | 56803 | 131 | 0 | 49.2138 | -2.1358 | 2022-07-17 04:21:15 | Jersey, United Kingdom | |||
2163199 | 2163199 | 2022-10-16 | United Kingdom | Jersey | 61048 | 141 | 0 | 49.2138 | -2.1358 | 2022-10-17 04:20:31 | 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]);