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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193714 | 193714 | 2021-01-11 | United Kingdom | England | 2705964 | 90452 | 0 | 2634430 | 52.3555 | -1.1743 | 2021-01-12 05:22:15 | England, United Kingdom | ||
2629517 | 2629517 | 2021-01-10 | United Kingdom | England | 2664129 | 89377 | 0 | 2593090 | 52.3555 | -1.1743 | 2021-01-11 05:21:50 | England, United Kingdom | ||
3903605 | 3903605 | 2021-01-09 | United Kingdom | England | 2613838 | 88347 | 0 | 2543297 | 52.3555 | -1.1743 | 2021-01-10 05:22:12 | England, United Kingdom | ||
157628 | 157628 | 2021-01-08 | United Kingdom | England | 2559581 | 87371 | 0 | 2489911 | 52.3555 | -1.1743 | 2021-01-09 05:22:18 | England, United Kingdom | ||
2545052 | 2545052 | 2021-01-07 | United Kingdom | England | 2497824 | 86449 | 0 | 2429310 | 52.3555 | -1.1743 | 2021-01-08 05:22:42 | England, United Kingdom | ||
2868361 | 2868361 | 2021-01-06 | United Kingdom | England | 2450983 | 85531 | 0 | 2383473 | 52.3555 | -1.1743 | 2021-01-07 05:22:03 | England, United Kingdom | ||
3037948 | 3037948 | 2021-01-05 | United Kingdom | England | 2394923 | 84649 | 0 | 2328297 | 52.3555 | -1.1743 | 2021-01-06 05:22:16 | England, United Kingdom | ||
1065493 | 1065493 | 2021-01-04 | United Kingdom | England | 2339983 | 83793 | 0 | 2274141 | 52.3555 | -1.1743 | 2021-01-05 05:21:49 | England, United Kingdom | ||
3234096 | 3234096 | 2021-01-03 | United Kingdom | England | 2286803 | 83003 | 0 | 2221331 | 52.3555 | -1.1743 | 2021-01-04 05:22:02 | England, United Kingdom | ||
2231165 | 2231165 | 2021-01-02 | United Kingdom | England | 2239950 | 82319 | 0 | 2174870 | 52.3555 | -1.1743 | 2021-01-03 05:22:52 | England, United Kingdom | ||
1140529 | 1140529 | 2021-01-01 | United Kingdom | England | 2190702 | 81593 | 0 | 2125971 | 52.3555 | -1.1743 | 2021-01-02 05:22:33 | England, United Kingdom | ||
3699135 | 3699135 | 2020-12-31 | United Kingdom | England | 2139956 | 80904 | 0 | 2075838 | 52.3555 | -1.1743 | 2021-01-01 05:23:07 | England, United Kingdom | ||
1013950 | 1013950 | 2020-12-30 | United Kingdom | England | 2090446 | 80203 | 0 | 2027148 | 52.3555 | -1.1743 | 2020-12-31 05:22:49 | England, United Kingdom | ||
769965 | 769965 | 2020-12-29 | United Kingdom | England | 2046892 | 79548 | 0 | 1984513 | 52.3555 | -1.1743 | 2020-12-30 05:22:34 | England, United Kingdom | ||
3765229 | 3765229 | 2020-12-28 | United Kingdom | England | 1999728 | 78934 | 0 | 1937709 | 52.3555 | -1.1743 | 2020-12-29 05:22:37 | England, United Kingdom | ||
3781549 | 3781549 | 2020-12-27 | United Kingdom | England | 1963217 | 78319 | 0 | 1901520 | 52.3555 | -1.1743 | 2020-12-28 05:22:06 | England, United Kingdom | ||
2227154 | 2227154 | 2020-12-26 | United Kingdom | England | 1937598 | 77707 | 0 | 1876147 | 52.3555 | -1.1743 | 2020-12-27 05:22:55 | England, United Kingdom | ||
205901 | 205901 | 2020-12-25 | United Kingdom | England | 1906291 | 77114 | 0 | 1845015 | 52.3555 | -1.1743 | 2020-12-26 05:22:28 | England, United Kingdom | ||
3695124 | 3695124 | 2020-12-24 | United Kingdom | England | 1874731 | 76556 | 0 | 1814025 | 52.3555 | -1.1743 | 2020-12-25 05:22:48 | England, United Kingdom | ||
2410476 | 2410476 | 2020-12-23 | United Kingdom | England | 1839170 | 76053 | 0 | 1778932 | 52.3555 | -1.1743 | 2020-12-24 05:23:04 | England, United Kingdom | ||
3773522 | 3773522 | 2020-12-22 | United Kingdom | England | 1804923 | 75534 | 0 | 1745310 | 52.3555 | -1.1743 | 2020-12-23 05:22:03 | England, United Kingdom | ||
931338 | 931338 | 2020-12-21 | United Kingdom | England | 1772635 | 74995 | 0 | 1713630 | 52.3555 | -1.1743 | 2020-12-22 05:22:33 | England, United Kingdom | ||
2123359 | 2123359 | 2020-12-20 | United Kingdom | England | 1743893 | 74489 | 0 | 1685086 | 52.3555 | -1.1743 | 2020-12-21 05:27:58 | England, United Kingdom | ||
2934866 | 2934866 | 2020-12-19 | United Kingdom | England | 1711738 | 74034 | 0 | 1653172 | 52.3555 | -1.1743 | 2020-12-20 05:27:32 | England, United Kingdom | ||
1904812 | 1904812 | 2020-12-18 | United Kingdom | England | 1688963 | 73577 | 0 | 1630838 | 52.3555 | -1.1743 | 2020-12-19 05:27:52 | England, United Kingdom | ||
2131638 | 2131638 | 2020-12-17 | United Kingdom | England | 1664511 | 73099 | 0 | 1606789 | 52.3555 | -1.1743 | 2020-12-18 05:28:18 | England, United Kingdom | ||
3153238 | 3153238 | 2020-12-16 | United Kingdom | England | 1642110 | 72636 | 0 | 1584826 | 52.3555 | -1.1743 | 2020-12-17 05:28:12 | England, United Kingdom | ||
1038019 | 1038019 | 2020-12-15 | United Kingdom | England | 1618678 | 72250 | 0 | 1561931 | 52.3555 | -1.1743 | 2020-12-16 05:28:04 | England, United Kingdom | ||
1754913 | 1754913 | 2020-12-14 | United Kingdom | England | 1602174 | 71842 | 0 | 1545894 | 52.3555 | -1.1743 | 2020-12-15 05:26:38 | England, United Kingdom | ||
3851433 | 3851433 | 2020-12-13 | United Kingdom | England | 1584292 | 71420 | 0 | 1528206 | 52.3555 | -1.1743 | 2020-12-14 05:26:27 | England, United Kingdom | ||
849215 | 849215 | 2020-12-12 | United Kingdom | England | 1567128 | 71010 | 0 | 1511180 | 52.3555 | -1.1743 | 2020-12-13 05:27:20 | England, United Kingdom | ||
864322 | 864322 | 2020-12-11 | United Kingdom | England | 1549660 | 70599 | 0 | 1494152 | 52.3555 | -1.1743 | 2020-12-12 05:26:19 | England, United Kingdom | ||
1603864 | 1603864 | 2020-12-10 | United Kingdom | England | 1531761 | 70175 | 0 | 1476606 | 52.3555 | -1.1743 | 2020-12-11 05:26:59 | England, United Kingdom | ||
2978873 | 2978873 | 2020-12-09 | United Kingdom | England | 1514139 | 69768 | 0 | 1459403 | 52.3555 | -1.1743 | 2020-12-10 05:26:19 | England, United Kingdom | ||
1822433 | 1822433 | 2020-12-08 | United Kingdom | England | 1501179 | 69387 | 0 | 1446894 | 52.3555 | -1.1743 | 2020-12-09 05:28:01 | England, United Kingdom | ||
2351069 | 2351069 | 2020-12-07 | United Kingdom | England | 1490720 | 68989 | 0 | 1436973 | 52.3555 | -1.1743 | 2020-12-08 05:27:42 | England, United Kingdom | ||
1009939 | 1009939 | 2020-12-06 | United Kingdom | England | 1479097 | 68610 | 0 | 1425527 | 52.3555 | -1.1743 | 2020-12-07 05:26:14 | England, United Kingdom | ||
1635948 | 1635948 | 2020-12-05 | United Kingdom | England | 1464803 | 68247 | 0 | 1411434 | 52.3555 | -1.1743 | 2020-12-06 05:26:18 | England, United Kingdom | ||
3863476 | 3863476 | 2020-12-04 | United Kingdom | England | 1452137 | 67902 | 0 | 1399112 | 52.3555 | -1.1743 | 2020-12-05 05:27:36 | England, United Kingdom | ||
78734 | 78734 | 2020-12-03 | United Kingdom | England | 1438725 | 67482 | 0 | 1386124 | 52.3555 | -1.1743 | 2020-12-04 05:27:27 | England, United Kingdom | ||
741946 | 741946 | 2020-12-02 | United Kingdom | England | 1426733 | 67072 | 0 | 1374460 | 52.3555 | -1.1743 | 2020-12-03 05:28:22 | England, United Kingdom | ||
2541040 | 2541040 | 2020-12-01 | United Kingdom | England | 1413410 | 66724 | 0 | 1361692 | 52.3555 | -1.1743 | 2020-12-02 05:27:41 | England, United Kingdom | ||
1587809 | 1587809 | 2020-11-30 | United Kingdom | England | 1401792 | 66365 | 0 | 1350605 | 52.3555 | -1.1743 | 2020-12-01 05:26:18 | England, United Kingdom | ||
3570212 | 3570212 | 2020-11-29 | United Kingdom | England | 1390923 | 65980 | 0 | 1339925 | 52.3555 | -1.1743 | 2020-11-30 05:26:13 | England, United Kingdom | ||
2938877 | 2938877 | 2020-11-28 | United Kingdom | England | 1380869 | 65557 | 0 | 1330065 | 52.3555 | -1.1743 | 2020-11-29 05:25:55 | England, United Kingdom | ||
395880 | 395880 | 2020-11-27 | United Kingdom | England | 1367546 | 65168 | 0 | 1317139 | 52.3555 | -1.1743 | 2020-11-28 05:25:50 | England, United Kingdom | ||
927327 | 927327 | 2020-11-26 | United Kingdom | England | 1355272 | 64781 | 0 | 1305316 | 52.3555 | -1.1743 | 2020-11-27 05:26:53 | England, United Kingdom | ||
1976232 | 1976232 | 2020-11-25 | United Kingdom | England | 1340635 | 64401 | 0 | 1291090 | 52.3555 | -1.1743 | 2020-11-26 05:27:44 | England, United Kingdom | ||
1353963 | 1353963 | 2020-11-24 | United Kingdom | England | 1324742 | 63965 | 0 | 1275801 | 52.3555 | -1.1743 | 2020-11-25 05:27:20 | England, United Kingdom | ||
681957 | 681957 | 2020-11-23 | United Kingdom | England | 1314888 | 63542 | 0 | 1266482 | 52.3555 | -1.1743 | 2020-11-24 05:27:31 | England, United Kingdom | ||
3193633 | 3193633 | 2020-11-22 | United Kingdom | England | 1301559 | 63113 | 0 | 1253347 | 52.3555 | -1.1743 | 2020-11-23 05:25:26 | England, United Kingdom | ||
3840127 | 3840127 | 2020-11-21 | United Kingdom | England | 1284891 | 62693 | 0 | 1237049 | 52.3555 | -1.1743 | 2020-11-22 05:25:45 | England, United Kingdom | ||
2705155 | 2705155 | 2020-11-20 | United Kingdom | England | 1267276 | 62280 | 0 | 1219700 | 52.3555 | -1.1743 | 2020-11-21 05:25:51 | England, United Kingdom | ||
825215 | 825215 | 2020-11-19 | United Kingdom | England | 1249431 | 61873 | 0 | 1202291 | 52.3555 | -1.1743 | 2020-11-20 05:26:28 | England, United Kingdom | ||
126349 | 126349 | 2020-11-18 | United Kingdom | England | 1229140 | 61466 | 0 | 1182416 | 52.3555 | -1.1743 | 2020-11-19 05:25:23 | England, United Kingdom | ||
3342237 | 3342237 | 2020-11-17 | United Kingdom | England | 1211951 | 61022 | 0 | 1165650 | 52.3555 | -1.1743 | 2020-11-18 05:40:31 | England, United Kingdom | ||
3173282 | 3173282 | 2020-11-16 | United Kingdom | England | 1194402 | 60644 | 0 | 1148619 | 52.3555 | -1.1743 | 2020-11-17 05:25:54 | England, United Kingdom | ||
2883850 | 2883850 | 2020-11-15 | United Kingdom | England | 1174979 | 60282 | 0 | 1129387 | 52.3555 | -1.1743 | 2020-11-16 05:25:57 | England, United Kingdom | ||
2918828 | 2918828 | 2020-11-14 | United Kingdom | England | 1152981 | 59907 | 0 | 1107532 | 52.3555 | -1.1743 | 2020-11-15 05:26:53 | England, United Kingdom | ||
2788650 | 2788650 | 2020-11-13 | United Kingdom | England | 1128683 | 59540 | 0 | 1083630 | 52.3555 | -1.1743 | 2020-11-14 05:25:37 | England, United Kingdom | ||
868415 | 868415 | 2020-11-12 | United Kingdom | England | 1104143 | 59188 | 0 | 1059370 | 52.3555 | -1.1743 | 2020-11-13 05:25:30 | England, United Kingdom | ||
3444459 | 3444459 | 2020-11-11 | United Kingdom | England | 1073300 | 58831 | 0 | 1028996 | 52.3555 | -1.1743 | 2020-11-12 05:25:55 | England, United Kingdom | ||
275799 | 275799 | 2020-11-10 | United Kingdom | England | 1053330 | 58514 | 0 | 1009504 | 52.3555 | -1.1743 | 2020-11-11 05:25:30 | England, United Kingdom | ||
1992276 | 1992276 | 2020-11-09 | United Kingdom | England | 1034708 | 58185 | 0 | 991342 | 52.3555 | -1.1743 | 2020-11-10 05:40:07 | England, United Kingdom | ||
1732128 | 1732128 | 2020-11-08 | United Kingdom | England | 1015672 | 57781 | 0 | 972481 | 52.3555 | -1.1743 | 2020-11-09 05:25:45 | England, United Kingdom | ||
1547588 | 1547588 | 2020-11-07 | United Kingdom | England | 997379 | 57434 | 0 | 954315 | 52.3555 | -1.1743 | 2020-11-08 05:24:56 | England, United Kingdom | ||
379826 | 379826 | 2020-11-06 | United Kingdom | England | 975504 | 57086 | 0 | 932768 | 52.3555 | -1.1743 | 2020-11-07 05:24:52 | England, United Kingdom | ||
895764 | 895764 | 2020-11-05 | United Kingdom | England | 955236 | 56747 | 0 | 912803 | 52.3555 | -1.1743 | 2020-11-06 05:24:55 | England, United Kingdom | ||
2922826 | 2922826 | 2020-11-04 | United Kingdom | England | 934099 | 56447 | 0 | 891963 | 52.3555 | -1.1743 | 2020-11-05 06:05:03 | England, United Kingdom | ||
2501662 | 2501662 | 2020-11-03 | United Kingdom | England | 912236 | 56164 | 0 | 870488 | 52.3555 | -1.1743 | 2020-11-04 05:25:09 | England, United Kingdom | ||
3307837 | 3307837 | 2020-11-02 | United Kingdom | England | 894906 | 55860 | 0 | 853517 | 52.3555 | -1.1743 | 2020-11-03 06:00:16 | England, United Kingdom | ||
3413086 | 3413086 | 2020-11-01 | United Kingdom | England | 879046 | 55581 | 0 | 837782 | 52.3555 | -1.1743 | 2020-11-02 05:25:04 | England, United Kingdom | ||
2083575 | 2083575 | 2020-10-31 | United Kingdom | England | 858444 | 55298 | 0 | 817312 | 52.3555 | -1.1743 | 2020-11-01 04:36:19 | England, United Kingdom | ||
2247028 | 2247028 | 2020-10-30 | United Kingdom | England | 839580 | 55021 | 0 | 798726 | 52.3555 | -1.1743 | 2020-10-31 04:24:44 | England, United Kingdom | ||
213883 | 213883 | 2020-10-29 | United Kingdom | England | 818759 | 54737 | 0 | 778131 | 52.3555 | -1.1743 | 2020-10-30 04:24:49 | England, United Kingdom | ||
757945 | 757945 | 2020-10-28 | United Kingdom | England | 799019 | 54484 | 0 | 758605 | 52.3555 | -1.1743 | 2020-10-29 04:24:49 | England, United Kingdom | ||
1456229 | 1456229 | 2020-10-27 | United Kingdom | England | 777774 | 54256 | 0 | 737596 | 52.3555 | -1.1743 | 2020-10-28 04:24:39 | England, United Kingdom | ||
3483953 | 3483953 | 2020-10-26 | United Kingdom | England | 758145 | 54030 | 0 | 718289 | 52.3555 | -1.1743 | 2020-10-27 04:24:45 | England, United Kingdom | ||
11974 | 11974 | 2020-10-25 | United Kingdom | England | 740262 | 53812 | 0 | 700496 | 52.3555 | -1.1743 | 2020-10-26 04:25:02 | England, United Kingdom | ||
3655211 | 3655211 | 2020-10-24 | United Kingdom | England | 723775 | 53605 | 0 | 684146 | 52.3555 | -1.1743 | 2020-10-25 04:24:36 | England, United Kingdom | ||
1057466 | 1057466 | 2020-10-23 | United Kingdom | England | 704443 | 53431 | 0 | 664955 | 52.3555 | -1.1743 | 2020-10-24 04:24:46 | England, United Kingdom | ||
1181136 | 1181136 | 2020-10-22 | United Kingdom | England | 687327 | 53248 | 0 | 648027 | 52.3555 | -1.1743 | 2020-10-23 04:24:46 | England, United Kingdom | ||
2195241 | 2195241 | 2020-10-21 | United Kingdom | England | 669973 | 53062 | 0 | 630833 | 52.3555 | -1.1743 | 2020-10-22 04:24:27 | England, United Kingdom | ||
3994252 | 3994252 | 2020-10-20 | United Kingdom | England | 647025 | 52866 | 0 | 608029 | 52.3555 | -1.1743 | 2020-10-21 04:24:14 | England, United Kingdom | ||
1798272 | 1798272 | 2020-10-19 | United Kingdom | England | 629211 | 52689 | 0 | 590428 | 52.3555 | -1.1743 | 2020-10-20 04:24:22 | England, United Kingdom | ||
765955 | 765955 | 2020-10-18 | United Kingdom | England | 612846 | 52534 | 0 | 574135 | 52.3555 | -1.1743 | 2020-10-19 04:24:16 | England, United Kingdom | ||
1029993 | 1029993 | 2020-10-17 | United Kingdom | England | 598142 | 52410 | 0 | 559490 | 52.3555 | -1.1743 | 2020-10-18 04:24:25 | England, United Kingdom | ||
2860488 | 2860488 | 2020-10-16 | United Kingdom | England | 584843 | 52242 | 0 | 546319 | 52.3555 | -1.1743 | 2020-10-17 04:24:12 | England, United Kingdom | ||
790017 | 790017 | 2020-10-15 | United Kingdom | England | 572667 | 52117 | 0 | 534263 | 52.3555 | -1.1743 | 2020-10-16 04:24:01 | England, United Kingdom | ||
82728 | 82728 | 2020-10-14 | United Kingdom | England | 556528 | 51993 | 0 | 518235 | 52.3555 | -1.1743 | 2020-10-15 04:24:28 | England, United Kingdom | ||
3785543 | 3785543 | 2020-10-13 | United Kingdom | England | 540396 | 51889 | 0 | 502211 | 52.3555 | -1.1743 | 2020-10-14 04:24:05 | England, United Kingdom | ||
2295083 | 2295083 | 2020-10-12 | United Kingdom | England | 526086 | 51795 | 0 | 488025 | 52.3555 | -1.1743 | 2020-10-13 04:24:02 | England, United Kingdom | ||
3789535 | 3789535 | 2020-10-11 | United Kingdom | England | 514439 | 51701 | 0 | 476421 | 52.3555 | -1.1743 | 2020-10-12 04:23:45 | England, United Kingdom | ||
2605673 | 2605673 | 2020-10-10 | United Kingdom | England | 504056 | 51595 | 0 | 466100 | 52.3555 | -1.1743 | 2020-10-11 04:23:46 | England, United Kingdom | ||
821206 | 821206 | 2020-10-09 | United Kingdom | England | 491428 | 51508 | 0 | 453526 | 52.3555 | -1.1743 | 2020-10-10 04:23:57 | England, United Kingdom | ||
2693321 | 2693321 | 2020-10-08 | United Kingdom | England | 480656 | 51426 | 0 | 442833 | 52.3555 | -1.1743 | 2020-10-09 04:23:59 | England, United Kingdom | ||
1045463 | 1045463 | 2020-10-07 | United Kingdom | England | 465704 | 51346 | 0 | 427951 | 52.3555 | -1.1743 | 2020-10-08 04:23:56 | England, United Kingdom | ||
3121124 | 3121124 | 2020-10-06 | United Kingdom | England | 454176 | 51258 | 0 | 416488 | 52.3555 | -1.1743 | 2020-10-07 04:23:40 | England, United Kingdom | ||
3805536 | 3805536 | 2020-10-05 | United Kingdom | England | 441528 | 51189 | 0 | 403903 | 52.3555 | -1.1743 | 2020-10-06 04:23:33 | England, United Kingdom | ||
1826426 | 1826426 | 2020-10-04 | United Kingdom | England | 430843 | 51135 | 0 | 393237 | 52.3555 | -1.1743 | 2020-10-05 04:23:33 | 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]);