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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185687 | 185687 | 2021-02-21 | United Kingdom | England | 3605373 | 125940 | 0 | 3499013 | 52.3555 | -1.1743 | 2021-02-22 05:24:21 | England, United Kingdom | ||
745961 | 745961 | 2021-02-20 | United Kingdom | England | 3596965 | 125585 | 0 | 3490795 | 52.3555 | -1.1743 | 2021-02-21 05:24:33 | England, United Kingdom | ||
475059 | 475059 | 2021-02-19 | United Kingdom | England | 3588001 | 125197 | 0 | 3482228 | 52.3555 | -1.1743 | 2021-02-20 05:22:51 | England, United Kingdom | ||
1156768 | 1156768 | 2021-02-18 | United Kingdom | England | 3577705 | 124807 | 0 | 3472413 | 52.3555 | -1.1743 | 2021-02-19 05:24:16 | England, United Kingdom | ||
3604688 | 3604688 | 2021-02-17 | United Kingdom | England | 3566965 | 124353 | 0 | 3462050 | 52.3555 | -1.1743 | 2021-02-18 05:22:58 | England, United Kingdom | ||
3053823 | 3053823 | 2021-02-16 | United Kingdom | England | 3556039 | 123915 | 0 | 3451762 | 52.3555 | -1.1743 | 2021-02-17 05:23:10 | England, United Kingdom | ||
1341922 | 1341922 | 2021-02-15 | United Kingdom | England | 3546803 | 123414 | 0 | 3443259 | 52.3555 | -1.1743 | 2021-02-16 05:24:38 | England, United Kingdom | ||
2287073 | 2287073 | 2021-02-14 | United Kingdom | England | 3538194 | 122865 | 0 | 3434860 | 52.3555 | -1.1743 | 2021-02-15 05:24:49 | England, United Kingdom | ||
2681473 | 2681473 | 2021-02-13 | United Kingdom | England | 3528695 | 122345 | 0 | 3425589 | 52.3555 | -1.1743 | 2021-02-14 05:23:43 | England, United Kingdom | ||
3543106 | 3543106 | 2021-02-12 | United Kingdom | England | 3516998 | 121833 | 0 | 3414436 | 52.3555 | -1.1743 | 2021-02-13 05:22:12 | England, United Kingdom | ||
2641369 | 2641369 | 2021-02-11 | United Kingdom | England | 3503699 | 121287 | 0 | 3401794 | 52.3555 | -1.1743 | 2021-02-12 05:23:29 | England, United Kingdom | ||
3982224 | 3982224 | 2021-02-10 | United Kingdom | England | 3491698 | 120697 | 0 | 3390387 | 52.3555 | -1.1743 | 2021-02-11 05:23:55 | England, United Kingdom | ||
1531544 | 1531544 | 2021-02-09 | United Kingdom | England | 3480147 | 120068 | 0 | 3379762 | 52.3555 | -1.1743 | 2021-02-10 05:22:41 | England, United Kingdom | ||
617335 | 617335 | 2021-02-08 | United Kingdom | England | 3469231 | 119440 | 0 | 3369820 | 52.3555 | -1.1743 | 2021-02-09 05:23:30 | England, United Kingdom | ||
1676104 | 1676104 | 2021-02-07 | United Kingdom | England | 3456961 | 118738 | 0 | 3357854 | 52.3555 | -1.1743 | 2021-02-08 05:22:39 | England, United Kingdom | ||
978565 | 978565 | 2021-02-06 | United Kingdom | England | 3442495 | 118073 | 0 | 3343717 | 52.3555 | -1.1743 | 2021-02-07 05:23:00 | England, United Kingdom | ||
1591823 | 1591823 | 2021-02-05 | United Kingdom | England | 3426193 | 117387 | 0 | 3328139 | 52.3555 | -1.1743 | 2021-02-06 05:23:55 | England, United Kingdom | ||
794030 | 794030 | 2021-02-04 | United Kingdom | England | 3408879 | 116616 | 0 | 3311717 | 52.3555 | -1.1743 | 2021-02-05 05:22:38 | England, United Kingdom | ||
343922 | 343922 | 2021-02-03 | United Kingdom | England | 3390350 | 115881 | 0 | 3294005 | 52.3555 | -1.1743 | 2021-02-04 05:22:26 | England, United Kingdom | ||
1688148 | 1688148 | 2021-02-02 | United Kingdom | England | 3373085 | 115009 | 0 | 3277913 | 52.3555 | -1.1743 | 2021-02-03 05:22:52 | England, United Kingdom | ||
1680118 | 1680118 | 2021-02-01 | United Kingdom | England | 3358064 | 114155 | 0 | 3264248 | 52.3555 | -1.1743 | 2021-02-02 05:22:49 | England, United Kingdom | ||
1463406 | 1463406 | 2021-01-31 | United Kingdom | England | 3341249 | 113262 | 0 | 3247801 | 52.3555 | -1.1743 | 2021-02-01 05:22:53 | England, United Kingdom | ||
2215314 | 2215314 | 2021-01-30 | United Kingdom | England | 3322195 | 112363 | 0 | 3229275 | 52.3555 | -1.1743 | 2021-01-31 05:22:42 | England, United Kingdom | ||
1900801 | 1900801 | 2021-01-29 | United Kingdom | England | 3301106 | 111440 | 0 | 3209284 | 52.3555 | -1.1743 | 2021-01-30 05:22:49 | England, United Kingdom | ||
2485617 | 2485617 | 2021-01-28 | United Kingdom | England | 3274397 | 110432 | 0 | 3183699 | 52.3555 | -1.1743 | 2021-01-29 05:22:23 | England, United Kingdom | ||
3157252 | 3157252 | 2021-01-27 | United Kingdom | England | 3248215 | 109322 | 0 | 3158605 | 52.3555 | -1.1743 | 2021-01-28 05:22:24 | England, United Kingdom | ||
15987 | 15987 | 2021-01-26 | United Kingdom | England | 3225301 | 108214 | 0 | 3137259 | 52.3555 | -1.1743 | 2021-01-27 05:23:41 | England, United Kingdom | ||
2571311 | 2571311 | 2021-01-25 | United Kingdom | England | 3207381 | 107168 | 0 | 3120859 | 52.3555 | -1.1743 | 2021-01-26 05:22:02 | England, United Kingdom | ||
1762943 | 1762943 | 2021-01-24 | United Kingdom | England | 3187232 | 106018 | 0 | 3101258 | 52.3555 | -1.1743 | 2021-01-25 05:22:16 | England, United Kingdom | ||
2430550 | 2430550 | 2021-01-23 | United Kingdom | England | 3159652 | 104932 | 0 | 3074229 | 52.3555 | -1.1743 | 2021-01-24 05:22:35 | England, United Kingdom | ||
2470452 | 2470452 | 2021-01-22 | United Kingdom | England | 3129156 | 103785 | 0 | 3044966 | 52.3555 | -1.1743 | 2021-01-23 05:22:03 | England, United Kingdom | ||
439003 | 439003 | 2021-01-21 | United Kingdom | England | 3092041 | 102596 | 0 | 3009102 | 52.3555 | -1.1743 | 2021-01-22 05:22:10 | England, United Kingdom | ||
1097734 | 1097734 | 2021-01-20 | United Kingdom | England | 3057670 | 101392 | 0 | 2975865 | 52.3555 | -1.1743 | 2021-01-21 05:22:01 | England, United Kingdom | ||
911824 | 911824 | 2021-01-19 | United Kingdom | England | 3022609 | 100155 | 0 | 2942466 | 52.3555 | -1.1743 | 2021-01-20 05:21:54 | England, United Kingdom | ||
240887 | 240887 | 2021-01-18 | United Kingdom | England | 2992238 | 98827 | 0 | 2913602 | 52.3555 | -1.1743 | 2021-01-19 05:22:15 | England, United Kingdom | ||
3507004 | 3507004 | 2021-01-17 | United Kingdom | England | 2958104 | 97585 | 0 | 2880028 | 52.3555 | -1.1743 | 2021-01-18 05:22:34 | England, United Kingdom | ||
3105087 | 3105087 | 2021-01-16 | United Kingdom | England | 2922841 | 96356 | 0 | 2845363 | 52.3555 | -1.1743 | 2021-01-17 05:22:17 | England, United Kingdom | ||
3519049 | 3519049 | 2021-01-15 | United Kingdom | England | 2885082 | 95115 | 0 | 2808744 | 52.3555 | -1.1743 | 2021-01-16 05:22:40 | England, United Kingdom | ||
3883221 | 3883221 | 2021-01-14 | United Kingdom | England | 2834341 | 93953 | 0 | 2759142 | 52.3555 | -1.1743 | 2021-01-15 05:22:24 | England, United Kingdom | ||
3311848 | 3311848 | 2021-01-13 | United Kingdom | England | 2789983 | 92786 | 0 | 2715898 | 52.3555 | -1.1743 | 2021-01-14 05:22:32 | England, United Kingdom | ||
777993 | 777993 | 2021-01-12 | United Kingdom | England | 2747085 | 91625 | 0 | 2674400 | 52.3555 | -1.1743 | 2021-01-13 05:22:15 | England, United Kingdom | ||
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 |
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]);