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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3073686 | 3073686 | 2021-11-23 | United Kingdom | England | 8421911 | 147063 | 0 | 52.3555 | -1.1743 | 2021-11-24 04:22:14 | England, United Kingdom | |||
3752784 | 3752784 | 2021-11-22 | United Kingdom | England | 8385361 | 146944 | 0 | 52.3555 | -1.1743 | 2021-11-23 04:22:39 | England, United Kingdom | |||
1017991 | 1017991 | 2021-11-21 | United Kingdom | England | 8349363 | 146844 | 0 | 52.3555 | -1.1743 | 2021-11-22 04:22:20 | England, United Kingdom | |||
726155 | 726155 | 2021-11-20 | United Kingdom | England | 8316395 | 146746 | 0 | 52.3555 | -1.1743 | 2021-11-21 04:22:13 | England, United Kingdom | |||
165685 | 165685 | 2021-11-19 | United Kingdom | England | 8281117 | 146641 | 0 | 52.3555 | -1.1743 | 2021-11-20 04:22:17 | England, United Kingdom | |||
3292572 | 3292572 | 2021-11-18 | United Kingdom | England | 8244111 | 146534 | 0 | 52.3555 | -1.1743 | 2021-11-19 04:21:40 | England, United Kingdom | |||
451028 | 451028 | 2021-11-17 | United Kingdom | England | 8205448 | 146428 | 0 | 52.3555 | -1.1743 | 2021-11-18 04:21:33 | England, United Kingdom | |||
3346278 | 3346278 | 2021-11-16 | United Kingdom | England | 8175202 | 146333 | 0 | 52.3555 | -1.1743 | 2021-11-17 04:21:48 | England, United Kingdom | |||
2291114 | 2291114 | 2021-11-15 | United Kingdom | England | 8144766 | 146199 | 0 | 52.3555 | -1.1743 | 2021-11-16 04:21:10 | England, United Kingdom | |||
1325888 | 1325888 | 2021-11-14 | United Kingdom | England | 8113757 | 146063 | 0 | 52.3555 | -1.1743 | 2021-11-15 04:21:36 | England, United Kingdom | |||
690014 | 690014 | 2021-11-13 | United Kingdom | England | 8084740 | 145955 | 0 | 52.3555 | -1.1743 | 2021-11-14 04:21:31 | England, United Kingdom | |||
718123 | 718123 | 2021-11-12 | United Kingdom | England | 8051924 | 145838 | 0 | 52.3555 | -1.1743 | 2021-11-13 04:21:38 | England, United Kingdom | |||
32073 | 32073 | 2021-11-11 | United Kingdom | England | 8020241 | 145731 | 0 | 52.3555 | -1.1743 | 2021-11-12 04:22:01 | England, United Kingdom | |||
2848512 | 2848512 | 2021-11-10 | United Kingdom | England | 7984769 | 145603 | 0 | 52.3555 | -1.1743 | 2021-11-11 04:21:45 | England, United Kingdom | |||
90782 | 90782 | 2021-11-09 | United Kingdom | England | 7953228 | 145474 | 0 | 52.3555 | -1.1743 | 2021-11-10 04:21:38 | England, United Kingdom | |||
3643210 | 3643210 | 2021-11-08 | United Kingdom | England | 7925681 | 145343 | 0 | 52.3555 | -1.1743 | 2021-11-09 04:21:36 | England, United Kingdom | |||
2004318 | 2004318 | 2021-11-07 | United Kingdom | England | 7901039 | 145215 | 0 | 52.3555 | -1.1743 | 2021-11-08 04:21:43 | England, United Kingdom | |||
499309 | 499309 | 2021-11-06 | United Kingdom | England | 7877720 | 145092 | 0 | 52.3555 | -1.1743 | 2021-11-07 04:21:53 | England, United Kingdom | |||
3125164 | 3125164 | 2021-11-05 | United Kingdom | England | 7852005 | 144957 | 0 | 52.3555 | -1.1743 | 2021-11-06 04:21:51 | England, United Kingdom | |||
702062 | 702062 | 2021-11-04 | United Kingdom | England | 7823979 | 144826 | 0 | 52.3555 | -1.1743 | 2021-11-05 04:21:54 | England, United Kingdom | |||
279840 | 279840 | 2021-11-03 | United Kingdom | England | 7794507 | 144695 | 0 | 52.3555 | -1.1743 | 2021-11-04 04:22:20 | England, United Kingdom | |||
47365 | 47365 | 2021-11-02 | United Kingdom | England | 7760671 | 144560 | 0 | 52.3555 | -1.1743 | 2021-11-03 06:22:09 | England, United Kingdom | |||
3515061 | 3515061 | 2021-11-01 | United Kingdom | England | 7732441 | 144428 | 0 | 52.3555 | -1.1743 | 2021-11-02 04:22:03 | England, United Kingdom | |||
291652 | 291652 | 2021-10-31 | United Kingdom | England | 7700753 | 144282 | 0 | 52.3555 | -1.1743 | 2021-11-01 04:22:01 | England, United Kingdom | |||
2724658 | 2724658 | 2021-10-30 | United Kingdom | England | 7669614 | 144131 | 0 | 52.3555 | -1.1743 | 2021-10-31 04:22:08 | England, United Kingdom | |||
570760 | 570760 | 2021-10-29 | United Kingdom | England | 7633950 | 144007 | 0 | 52.3555 | -1.1743 | 2021-10-30 04:22:03 | England, United Kingdom | |||
8002 | 8002 | 2021-10-28 | United Kingdom | England | 7597473 | 143875 | 0 | 52.3555 | -1.1743 | 2021-10-29 04:22:03 | England, United Kingdom | |||
538392 | 538392 | 2021-10-27 | United Kingdom | England | 7564400 | 143718 | 0 | 52.3555 | -1.1743 | 2021-10-28 04:22:08 | England, United Kingdom | |||
3495829 | 3495829 | 2021-10-26 | United Kingdom | England | 7526898 | 143578 | 0 | 52.3555 | -1.1743 | 2021-10-27 04:22:32 | England, United Kingdom | |||
3797551 | 3797551 | 2021-10-25 | United Kingdom | England | 7494992 | 143447 | 0 | 52.3555 | -1.1743 | 2021-10-26 04:22:09 | England, United Kingdom | |||
685997 | 685997 | 2021-10-24 | United Kingdom | England | 7462144 | 143324 | 0 | 52.3555 | -1.1743 | 2021-10-25 04:22:31 | England, United Kingdom | |||
774005 | 774005 | 2021-10-23 | United Kingdom | England | 7430143 | 143204 | 0 | 52.3555 | -1.1743 | 2021-10-24 04:21:22 | England, United Kingdom | |||
657652 | 657652 | 2021-10-22 | United Kingdom | England | 7388884 | 143073 | 0 | 52.3555 | -1.1743 | 2021-10-23 04:21:32 | England, United Kingdom | |||
2127399 | 2127399 | 2021-10-21 | United Kingdom | England | 7347703 | 142958 | 0 | 52.3555 | -1.1743 | 2021-10-22 04:21:14 | England, United Kingdom | |||
447011 | 447011 | 2021-10-20 | United Kingdom | England | 7303864 | 142843 | 0 | 52.3555 | -1.1743 | 2021-10-21 04:21:18 | England, United Kingdom | |||
601330 | 601330 | 2021-10-19 | United Kingdom | England | 7262958 | 142727 | 0 | 52.3555 | -1.1743 | 2021-10-20 04:21:00 | England, United Kingdom | |||
2047507 | 2047507 | 2021-10-18 | United Kingdom | England | 7226658 | 142618 | 0 | 52.3555 | -1.1743 | 2021-10-19 04:20:54 | England, United Kingdom | |||
1912868 | 1912868 | 2021-10-17 | United Kingdom | England | 7187635 | 142521 | 0 | 52.3555 | -1.1743 | 2021-10-18 04:21:10 | England, United Kingdom | |||
938457 | 938457 | 2021-10-16 | United Kingdom | England | 7149533 | 142412 | 0 | 52.3555 | -1.1743 | 2021-10-17 04:21:29 | England, United Kingdom | |||
2947012 | 2947012 | 2021-10-15 | United Kingdom | England | 7110513 | 142307 | 0 | 52.3555 | -1.1743 | 2021-10-16 04:21:15 | England, United Kingdom | |||
495292 | 495292 | 2021-10-14 | United Kingdom | England | 7073467 | 142199 | 0 | 52.3555 | -1.1743 | 2021-10-15 04:21:26 | England, United Kingdom | |||
637580 | 637580 | 2021-10-13 | United Kingdom | England | 7035489 | 142085 | 0 | 52.3555 | -1.1743 | 2021-10-14 04:21:29 | England, United Kingdom | |||
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 |
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]);