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 = "England" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1495258 | 1495258 | 2021-10-12 | United Kingdom | England | 7000356 | 141986 | 0 | 52.3555 | -1.1743 | 2021-10-13 04:20:51 | England, United Kingdom | |||
3010991 | 3010991 | 2021-10-11 | United Kingdom | England | 6967915 | 141890 | 0 | 52.3555 | -1.1743 | 2021-10-12 04:21:09 | England, United Kingdom | |||
427007 | 427007 | 2021-10-10 | United Kingdom | England | 6936327 | 141793 | 0 | 52.3555 | -1.1743 | 2021-10-11 04:21:31 | England, United Kingdom | |||
2879864 | 2879864 | 2021-10-09 | United Kingdom | England | 6906211 | 141711 | 0 | 52.3555 | -1.1743 | 2021-10-10 04:21:38 | England, United Kingdom | |||
2963030 | 2963030 | 2021-10-08 | United Kingdom | England | 6876192 | 141617 | 0 | 52.3555 | -1.1743 | 2021-10-09 04:21:34 | England, United Kingdom | |||
471068 | 471068 | 2021-10-07 | United Kingdom | England | 6845186 | 141522 | 0 | 52.3555 | -1.1743 | 2021-10-08 04:21:25 | England, United Kingdom | |||
2462448 | 2462448 | 2021-10-06 | United Kingdom | England | 6812848 | 141427 | 0 | 52.3555 | -1.1743 | 2021-10-07 04:21:36 | England, United Kingdom | |||
3836141 | 3836141 | 2021-10-05 | United Kingdom | England | 6780567 | 141348 | 0 | 52.3555 | -1.1743 | 2021-10-06 04:21:33 | England, United Kingdom | |||
990634 | 990634 | 2021-10-04 | United Kingdom | England | 6752536 | 141252 | 0 | 52.3555 | -1.1743 | 2021-10-05 04:21:27 | England, United Kingdom | |||
1277944 | 1277944 | 2021-10-03 | United Kingdom | England | 6725105 | 141168 | 0 | 52.3555 | -1.1743 | 2021-10-04 04:21:31 | England, United Kingdom | |||
3931697 | 3931697 | 2021-10-02 | United Kingdom | England | 6700702 | 141090 | 0 | 52.3555 | -1.1743 | 2021-10-03 04:21:24 | England, United Kingdom | |||
2135677 | 2135677 | 2021-10-01 | United Kingdom | England | 6674820 | 141017 | 0 | 52.3555 | -1.1743 | 2021-10-02 04:21:25 | England, United Kingdom | |||
2776634 | 2776634 | 2021-09-30 | United Kingdom | England | 6646963 | 140915 | 0 | 52.3555 | -1.1743 | 2021-10-01 04:21:35 | England, United Kingdom | |||
710090 | 710090 | 2021-09-29 | United Kingdom | England | 6617892 | 140820 | 0 | 52.3555 | -1.1743 | 2021-09-30 04:21:20 | England, United Kingdom | |||
1337932 | 1337932 | 2021-09-28 | United Kingdom | England | 6590514 | 140727 | 0 | 52.3555 | -1.1743 | 2021-09-29 04:21:45 | England, United Kingdom | |||
1239301 | 1239301 | 2021-09-27 | United Kingdom | England | 6561706 | 140639 | 0 | 52.3555 | -1.1743 | 2021-09-28 04:21:28 | England, United Kingdom | |||
2079602 | 2079602 | 2021-09-26 | United Kingdom | England | 6532847 | 140555 | 0 | 52.3555 | -1.1743 | 2021-09-27 04:21:16 | England, United Kingdom | |||
1728154 | 1728154 | 2021-09-25 | United Kingdom | England | 6507849 | 140479 | 0 | 52.3555 | -1.1743 | 2021-09-26 04:21:29 | England, United Kingdom | |||
1924874 | 1924874 | 2021-09-24 | United Kingdom | England | 6481363 | 140390 | 0 | 52.3555 | -1.1743 | 2021-09-25 04:21:31 | England, United Kingdom | |||
605345 | 605345 | 2021-09-23 | United Kingdom | England | 6453164 | 140290 | 0 | 52.3555 | -1.1743 | 2021-09-24 04:21:44 | England, United Kingdom | |||
3014989 | 3014989 | 2021-09-22 | United Kingdom | England | 6425056 | 140181 | 0 | 52.3555 | -1.1743 | 2021-09-23 04:21:43 | England, United Kingdom | |||
3761127 | 3761127 | 2021-09-21 | United Kingdom | England | 6398633 | 140067 | 0 | 52.3555 | -1.1743 | 2021-09-22 04:21:45 | England, United Kingdom | |||
813230 | 813230 | 2021-09-20 | United Kingdom | England | 6374123 | 139968 | 0 | 52.3555 | -1.1743 | 2021-09-21 04:21:26 | England, United Kingdom | |||
1818429 | 1818429 | 2021-09-19 | United Kingdom | England | 6347616 | 139852 | 0 | 52.3555 | -1.1743 | 2021-09-20 04:21:22 | England, United Kingdom | |||
20009 | 20009 | 2021-09-18 | United Kingdom | England | 6326046 | 139750 | 0 | 52.3555 | -1.1743 | 2021-09-19 04:21:34 | England, United Kingdom | |||
2621694 | 2621694 | 2021-09-17 | United Kingdom | England | 6303792 | 139648 | 0 | 52.3555 | -1.1743 | 2021-09-18 04:21:24 | England, United Kingdom | |||
2812402 | 2812402 | 2021-09-16 | United Kingdom | England | 6281236 | 139518 | 0 | 52.3555 | -1.1743 | 2021-09-17 04:21:46 | England, United Kingdom | |||
1378146 | 1378146 | 2021-09-15 | United Kingdom | England | 6258872 | 139400 | 0 | 52.3555 | -1.1743 | 2021-09-16 04:22:19 | England, United Kingdom | |||
2466445 | 2466445 | 2021-09-14 | United Kingdom | England | 6237505 | 139278 | 0 | 52.3555 | -1.1743 | 2021-09-15 03:22:37 | England, United Kingdom | |||
1389284 | 1389284 | 2021-09-13 | United Kingdom | England | 6218198 | 139152 | 0 | 52.3555 | -1.1743 | 2021-09-14 04:21:41 | England, United Kingdom | |||
1888653 | 1888653 | 2021-09-12 | United Kingdom | England | 6197654 | 139074 | 0 | 52.3555 | -1.1743 | 2021-09-13 04:21:15 | England, United Kingdom | |||
3809556 | 3809556 | 2021-09-11 | United Kingdom | England | 6178293 | 138972 | 0 | 52.3555 | -1.1743 | 2021-09-12 04:21:13 | England, United Kingdom | |||
3452496 | 3452496 | 2021-09-10 | United Kingdom | England | 6155149 | 138864 | 0 | 52.3555 | -1.1743 | 2021-09-11 04:21:30 | England, United Kingdom | |||
1266442 | 1266442 | 2021-09-09 | United Kingdom | England | 6129372 | 138753 | 0 | 52.3555 | -1.1743 | 2021-09-10 04:21:20 | England, United Kingdom | |||
2282812 | 2282812 | 2021-09-08 | United Kingdom | England | 6102850 | 138616 | 0 | 52.3555 | -1.1743 | 2021-09-09 04:21:27 | England, United Kingdom | |||
645591 | 645591 | 2021-09-07 | United Kingdom | England | 6074040 | 138500 | 0 | 52.3555 | -1.1743 | 2021-09-08 04:21:31 | England, United Kingdom | |||
3197654 | 3197654 | 2021-09-06 | United Kingdom | England | 6046799 | 138371 | 0 | 52.3555 | -1.1743 | 2021-09-07 04:21:35 | England, United Kingdom | |||
3284522 | 3284522 | 2021-09-05 | United Kingdom | England | 6019976 | 138242 | 0 | 52.3555 | -1.1743 | 2021-09-06 04:21:22 | England, United Kingdom | |||
252936 | 252936 | 2021-09-04 | United Kingdom | England | 5993444 | 138120 | 0 | 52.3555 | -1.1743 | 2021-09-05 04:21:33 | England, United Kingdom | |||
3978217 | 3978217 | 2021-09-03 | United Kingdom | England | 5964760 | 138001 | 0 | 52.3555 | -1.1743 | 2021-09-04 04:21:28 | England, United Kingdom | |||
181679 | 181679 | 2021-09-02 | United Kingdom | England | 5933034 | 137877 | 0 | 52.3555 | -1.1743 | 2021-09-03 04:21:20 | England, United Kingdom | |||
70714 | 70714 | 2021-09-01 | United Kingdom | England | 5904664 | 137772 | 0 | 52.3555 | -1.1743 | 2021-09-02 04:21:15 | England, United Kingdom | |||
2071556 | 2071556 | 2021-08-31 | United Kingdom | England | 5880134 | 137670 | 0 | 52.3555 | -1.1743 | 2021-09-01 04:21:38 | England, United Kingdom | |||
1779010 | 1779010 | 2021-08-30 | United Kingdom | England | 5859405 | 137568 | 0 | 52.3555 | -1.1743 | 2021-08-31 04:21:46 | England, United Kingdom | |||
3895584 | 3895584 | 2021-08-29 | United Kingdom | England | 5838323 | 137475 | 0 | 52.3555 | -1.1743 | 2021-08-30 04:21:23 | England, United Kingdom | |||
2796687 | 2796687 | 2021-08-28 | United Kingdom | England | 5816071 | 137361 | 0 | 52.3555 | -1.1743 | 2021-08-29 04:21:14 | England, United Kingdom | |||
2926846 | 2926846 | 2021-08-27 | United Kingdom | England | 5791272 | 137256 | 0 | 52.3555 | -1.1743 | 2021-08-28 04:21:28 | England, United Kingdom | |||
1599860 | 1599860 | 2021-08-26 | United Kingdom | England | 5764066 | 137142 | 0 | 52.3555 | -1.1743 | 2021-08-27 04:21:37 | England, United Kingdom | |||
36069 | 36069 | 2021-08-25 | United Kingdom | England | 5734967 | 137034 | 0 | 52.3555 | -1.1743 | 2021-08-26 04:21:28 | England, United Kingdom | |||
3109108 | 3109108 | 2021-08-24 | United Kingdom | England | 5707906 | 136948 | 0 | 52.3555 | -1.1743 | 2021-08-25 04:21:41 | England, United Kingdom | |||
3169279 | 3169279 | 2021-08-23 | United Kingdom | England | 5684645 | 136844 | 0 | 52.3555 | -1.1743 | 2021-08-24 04:21:19 | England, United Kingdom | |||
2179206 | 2179206 | 2021-08-22 | United Kingdom | England | 5660725 | 136747 | 0 | 52.3555 | -1.1743 | 2021-08-23 04:21:27 | England, United Kingdom | |||
3559302 | 3559302 | 2021-08-21 | United Kingdom | England | 5635046 | 136637 | 0 | 52.3555 | -1.1743 | 2021-08-22 04:21:29 | England, United Kingdom | |||
1857644 | 1857644 | 2021-08-20 | United Kingdom | England | 5608339 | 136540 | 0 | 52.3555 | -1.1743 | 2021-08-21 04:21:38 | England, United Kingdom | |||
515351 | 515351 | 2021-08-19 | United Kingdom | England | 5579087 | 136432 | 0 | 52.3555 | -1.1743 | 2021-08-20 04:21:33 | England, United Kingdom | |||
2521830 | 2521830 | 2021-08-18 | United Kingdom | England | 5549621 | 136333 | 0 | 52.3555 | -1.1743 | 2021-08-19 04:21:15 | England, United Kingdom | |||
248922 | 248922 | 2021-08-17 | United Kingdom | England | 5521231 | 136244 | 0 | 52.3555 | -1.1743 | 2021-08-18 04:21:35 | England, United Kingdom | |||
1607885 | 1607885 | 2021-08-16 | United Kingdom | England | 5498742 | 136155 | 0 | 52.3555 | -1.1743 | 2021-08-17 04:21:49 | England, United Kingdom | |||
106979 | 106979 | 2021-08-15 | United Kingdom | England | 5475833 | 136077 | 0 | 52.3555 | -1.1743 | 2021-08-16 04:21:31 | England, United Kingdom | |||
511337 | 511337 | 2021-08-14 | United Kingdom | England | 5453294 | 136002 | 0 | 52.3555 | -1.1743 | 2021-08-15 04:21:41 | England, United Kingdom | |||
1487209 | 1487209 | 2021-08-13 | United Kingdom | England | 5426971 | 135916 | 0 | 52.3555 | -1.1743 | 2021-08-14 04:21:25 | England, United Kingdom | |||
2903339 | 2903339 | 2021-08-12 | United Kingdom | England | 5398629 | 135835 | 0 | 52.3555 | -1.1743 | 2021-08-13 04:21:24 | England, United Kingdom | |||
1345943 | 1345943 | 2021-08-11 | United Kingdom | England | 5370904 | 135744 | 0 | 52.3555 | -1.1743 | 2021-08-12 04:21:25 | England, United Kingdom | |||
2355090 | 2355090 | 2021-08-10 | United Kingdom | England | 5344609 | 135666 | 0 | 52.3555 | -1.1743 | 2021-08-11 04:21:58 | England, United Kingdom | |||
653619 | 653619 | 2021-08-09 | United Kingdom | England | 5324191 | 135593 | 0 | 52.3555 | -1.1743 | 2021-08-10 04:21:27 | England, United Kingdom | |||
593281 | 593281 | 2021-08-08 | United Kingdom | England | 5302555 | 135519 | 0 | 52.3555 | -1.1743 | 2021-08-09 04:21:24 | England, United Kingdom | |||
2207293 | 2207293 | 2021-08-07 | United Kingdom | England | 5278675 | 135452 | 0 | 52.3555 | -1.1743 | 2021-08-08 04:21:33 | England, United Kingdom | |||
1121243 | 1121243 | 2021-08-06 | United Kingdom | England | 5253181 | 135362 | 0 | 52.3555 | -1.1743 | 2021-08-07 04:21:30 | England, United Kingdom | |||
1960180 | 1960180 | 2021-08-05 | United Kingdom | England | 5225224 | 135277 | 0 | 52.3555 | -1.1743 | 2021-08-06 04:21:18 | England, United Kingdom | |||
335559 | 335559 | 2021-08-04 | United Kingdom | England | 5199102 | 135188 | 0 | 5084893 | 52.3555 | -1.1743 | 2021-08-05 04:21:51 | England, United Kingdom | ||
3471830 | 3471830 | 2021-08-03 | United Kingdom | England | 5173082 | 135109 | 0 | 5058974 | 52.3555 | -1.1743 | 2021-08-04 04:21:25 | England, United Kingdom | ||
3687104 | 3687104 | 2021-08-02 | United Kingdom | England | 5154292 | 135039 | 0 | 5040307 | 52.3555 | -1.1743 | 2021-08-03 04:21:39 | England, United Kingdom | ||
3019003 | 3019003 | 2021-08-01 | United Kingdom | England | 5135378 | 134963 | 0 | 5021410 | 52.3555 | -1.1743 | 2021-08-02 04:21:36 | England, United Kingdom | ||
3907626 | 3907626 | 2021-07-31 | United Kingdom | England | 5114064 | 134889 | 0 | 5000148 | 52.3555 | -1.1743 | 2021-08-01 04:21:50 | England, United Kingdom | ||
3299831 | 3299831 | 2021-07-30 | United Kingdom | England | 5090505 | 134816 | 0 | 4976643 | 52.3555 | -1.1743 | 2021-07-31 04:21:35 | England, United Kingdom | ||
3389042 | 3389042 | 2021-07-29 | United Kingdom | England | 5064671 | 134726 | 0 | 4950864 | 52.3555 | -1.1743 | 2021-07-30 04:21:34 | England, United Kingdom | ||
411947 | 411947 | 2021-07-28 | United Kingdom | England | 5037630 | 134653 | 0 | 4923890 | 52.3555 | -1.1743 | 2021-07-29 04:21:33 | England, United Kingdom | ||
1309808 | 1309808 | 2021-07-27 | United Kingdom | England | 5013664 | 134583 | 0 | 4899997 | 52.3555 | -1.1743 | 2021-07-28 04:21:39 | England, United Kingdom | ||
3221951 | 3221951 | 2021-07-26 | United Kingdom | England | 4993657 | 134522 | 0 | 4880111 | 52.3555 | -1.1743 | 2021-07-27 04:21:18 | England, United Kingdom | ||
1382160 | 1382160 | 2021-07-25 | United Kingdom | England | 4972040 | 134452 | 0 | 4858506 | 52.3555 | -1.1743 | 2021-07-26 04:21:28 | England, United Kingdom | ||
1333900 | 1333900 | 2021-07-24 | United Kingdom | England | 4947127 | 134390 | 0 | 4833619 | 52.3555 | -1.1743 | 2021-07-25 04:22:12 | England, United Kingdom | ||
3141204 | 3141204 | 2021-07-23 | United Kingdom | England | 4918669 | 134330 | 0 | 4805235 | 52.3555 | -1.1743 | 2021-07-24 00:21:36 | England, United Kingdom | ||
3479964 | 3479964 | 2021-07-22 | United Kingdom | England | 4886612 | 134262 | 0 | 4773234 | 52.3555 | -1.1743 | 2021-07-23 04:21:29 | England, United Kingdom | ||
3335183 | 3335183 | 2021-07-21 | United Kingdom | England | 4851264 | 134188 | 0 | 4737944 | 52.3555 | -1.1743 | 2021-07-22 04:21:19 | England, United Kingdom | ||
2375164 | 2375164 | 2021-07-20 | United Kingdom | England | 4812460 | 134140 | 0 | 4699203 | 52.3555 | -1.1743 | 2021-07-21 04:21:40 | England, United Kingdom | ||
487243 | 487243 | 2021-07-19 | United Kingdom | England | 4769632 | 134086 | 0 | 4656457 | 52.3555 | -1.1743 | 2021-07-20 04:21:48 | England, United Kingdom | ||
2677466 | 2677466 | 2021-07-18 | United Kingdom | England | 4735387 | 134010 | 0 | 4622227 | 52.3555 | -1.1743 | 2021-07-19 04:21:24 | England, United Kingdom | ||
3709778 | 3709778 | 2021-07-17 | United Kingdom | England | 4691172 | 133950 | 0 | 4578033 | 52.3555 | -1.1743 | 2021-07-18 04:22:07 | England, United Kingdom | ||
2951009 | 2951009 | 2021-07-16 | United Kingdom | England | 4640922 | 133901 | 0 | 4527818 | 52.3555 | -1.1743 | 2021-07-17 04:22:22 | England, United Kingdom | ||
299665 | 299665 | 2021-07-15 | United Kingdom | England | 4594159 | 133857 | 0 | 4481097 | 52.3555 | -1.1743 | 2021-07-16 04:21:22 | England, United Kingdom | ||
3635610 | 3635610 | 2021-07-14 | United Kingdom | England | 4550298 | 133812 | 0 | 4437280 | 52.3555 | -1.1743 | 2021-07-15 04:21:48 | England, United Kingdom | ||
582485 | 582485 | 2021-07-13 | United Kingdom | England | 4512957 | 133774 | 0 | 4399975 | 52.3555 | -1.1743 | 2021-07-14 04:21:35 | England, United Kingdom | ||
3744734 | 3744734 | 2021-07-12 | United Kingdom | England | 4480518 | 133734 | 0 | 4367581 | 52.3555 | -1.1743 | 2021-07-13 04:21:18 | England, United Kingdom | ||
3663247 | 3663247 | 2021-07-11 | United Kingdom | England | 4450372 | 133700 | 0 | 4337441 | 52.3555 | -1.1743 | 2021-07-12 04:21:34 | England, United Kingdom | ||
629531 | 629531 | 2021-07-10 | United Kingdom | England | 4422370 | 133672 | 0 | 4309464 | 52.3555 | -1.1743 | 2021-07-11 04:21:43 | England, United Kingdom | ||
833250 | 833250 | 2021-07-09 | United Kingdom | England | 4393205 | 133638 | 0 | 4280325 | 52.3555 | -1.1743 | 2021-07-10 04:21:25 | England, United Kingdom | ||
782014 | 782014 | 2021-07-08 | United Kingdom | England | 4362481 | 133596 | 0 | 4249623 | 52.3555 | -1.1743 | 2021-07-09 04:21:21 | England, United Kingdom | ||
1444236 | 1444236 | 2021-07-07 | United Kingdom | England | 4334634 | 133566 | 0 | 4221807 | 52.3555 | -1.1743 | 2021-07-08 04:21:26 | England, United Kingdom | ||
2697341 | 2697341 | 2021-07-06 | United Kingdom | England | 4307618 | 133538 | 0 | 4194819 | 52.3555 | -1.1743 | 2021-07-07 04:21:20 | England, United Kingdom | ||
1936090 | 1936090 | 2021-07-05 | United Kingdom | England | 4282762 | 133516 | 0 | 4169993 | 52.3555 | -1.1743 | 2021-07-06 04:21:32 | England, 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]);