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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2517810 | 2517810 | 2020-10-03 | United Kingdom | England | 409534 | 51080 | 0 | 371960 | 52.3555 | -1.1743 | 2020-10-04 04:23:44 | England, United Kingdom | ||
3393028 | 3393028 | 2020-10-02 | United Kingdom | England | 398728 | 51024 | 0 | 361193 | 52.3555 | -1.1743 | 2020-10-03 04:23:40 | England, United Kingdom | ||
2383269 | 2383269 | 2020-10-01 | United Kingdom | England | 393931 | 50955 | 0 | 356454 | 52.3555 | -1.1743 | 2020-10-02 04:23:51 | England, United Kingdom | ||
1049455 | 1049455 | 2020-09-30 | United Kingdom | England | 388342 | 50899 | 0 | 350913 | 52.3555 | -1.1743 | 2020-10-01 04:23:42 | England, United Kingdom | ||
970536 | 970536 | 2020-09-29 | United Kingdom | England | 382686 | 50846 | 0 | 345319 | 52.3555 | -1.1743 | 2020-09-30 04:23:33 | England, United Kingdom | ||
1519033 | 1519033 | 2020-09-28 | United Kingdom | England | 377035 | 50804 | 0 | 339736 | 52.3555 | -1.1743 | 2020-09-29 04:23:42 | England, United Kingdom | ||
2585621 | 2585621 | 2020-09-27 | United Kingdom | England | 373719 | 50757 | 0 | 336433 | 52.3555 | -1.1743 | 2020-09-28 04:23:00 | England, United Kingdom | ||
2617673 | 2617673 | 2020-09-26 | United Kingdom | England | 368919 | 50708 | 0 | 331649 | 52.3555 | -1.1743 | 2020-09-27 04:23:00 | England, United Kingdom | ||
2816388 | 2816388 | 2020-09-25 | United Kingdom | England | 364280 | 50665 | 0 | 327040 | 52.3555 | -1.1743 | 2020-09-26 04:23:00 | England, United Kingdom | ||
2609665 | 2609665 | 2020-09-24 | United Kingdom | England | 358557 | 50630 | 0 | 321348 | 52.3555 | -1.1743 | 2020-09-25 04:23:00 | England, United Kingdom | ||
2657408 | 2657408 | 2020-09-23 | United Kingdom | England | 352925 | 50597 | 0 | 315753 | 52.3555 | -1.1743 | 2020-09-24 04:23:00 | England, United Kingdom | ||
3319857 | 3319857 | 2020-09-22 | United Kingdom | England | 347842 | 50545 | 0 | 310703 | 52.3555 | -1.1743 | 2020-09-23 04:23:00 | England, United Kingdom | ||
2840456 | 2840456 | 2020-09-21 | United Kingdom | England | 343655 | 50513 | 0 | 306552 | 52.3555 | -1.1743 | 2020-09-22 04:23:00 | England, United Kingdom | ||
3097059 | 3097059 | 2020-09-20 | United Kingdom | England | 339901 | 50487 | 0 | 302807 | 52.3555 | -1.1743 | 2020-09-21 04:23:00 | England, United Kingdom | ||
2458409 | 2458409 | 2020-09-19 | United Kingdom | England | 336622 | 50453 | 0 | 299546 | 52.3555 | -1.1743 | 2020-09-20 04:22:00 | England, United Kingdom | ||
2852478 | 2852478 | 2020-09-18 | United Kingdom | England | 332984 | 50431 | 0 | 295930 | 52.3555 | -1.1743 | 2020-09-19 04:22:00 | England, United Kingdom | ||
1125227 | 1125227 | 2020-09-17 | United Kingdom | England | 329213 | 50406 | 0 | 292182 | 52.3555 | -1.1743 | 2020-09-18 05:05:00 | England, United Kingdom | ||
669916 | 669916 | 2020-09-16 | United Kingdom | England | 326425 | 50372 | 0 | 289412 | 52.3555 | -1.1743 | 2020-09-17 04:22:00 | England, United Kingdom | ||
2732641 | 2732641 | 2020-09-15 | United Kingdom | England | 323029 | 50347 | 0 | 286033 | 52.3555 | -1.1743 | 2020-09-16 04:22:53 | England, United Kingdom | ||
347913 | 347913 | 2020-09-14 | United Kingdom | England | 320380 | 50325 | 0 | 283409 | 52.3555 | -1.1743 | 2020-09-15 03:22:50 | England, United Kingdom | ||
2872352 | 2872352 | 2020-09-13 | United Kingdom | England | 318121 | 50308 | 0 | 281157 | 52.3555 | -1.1743 | 2020-09-14 04:26:00 | England, United Kingdom | ||
550391 | 550391 | 2020-09-12 | United Kingdom | England | 315284 | 50290 | 0 | 278325 | 52.3555 | -1.1743 | 2020-09-13 04:30:52 | England, United Kingdom | ||
1448220 | 1448220 | 2020-09-11 | United Kingdom | England | 312276 | 50269 | 0 | 275326 | 52.3555 | -1.1743 | 2020-09-12 04:25:05 | England, United Kingdom | ||
1176821 | 1176821 | 2020-09-10 | United Kingdom | England | 309133 | 50254 | 0 | 272189 | 52.3555 | -1.1743 | 2020-09-11 04:46:23 | England, United Kingdom | ||
2175186 | 2175186 | 2020-09-09 | United Kingdom | England | 306555 | 50239 | 0 | 269624 | 52.3555 | -1.1743 | 2020-09-10 04:29:01 | England, United Kingdom | ||
1247395 | 1247395 | 2020-09-08 | United Kingdom | England | 304269 | 50229 | 0 | 267346 | 52.3555 | -1.1743 | 2020-09-09 04:28:48 | England, United Kingdom | ||
430974 | 430974 | 2020-09-07 | United Kingdom | England | 302175 | 50214 | 0 | 265279 | 52.3555 | -1.1743 | 2020-09-08 04:28:25 | England, United Kingdom | ||
3165259 | 3165259 | 2020-09-06 | United Kingdom | England | 299647 | 50194 | 0 | 262753 | 52.3555 | -1.1743 | 2020-09-07 04:28:30 | England, United Kingdom | ||
817214 | 817214 | 2020-09-05 | United Kingdom | England | 297071 | 50181 | 0 | 260179 | 52.3555 | -1.1743 | 2020-09-06 04:28:33 | England, United Kingdom | ||
2665414 | 2665414 | 2020-09-04 | United Kingdom | England | 295594 | 50169 | 0 | 258713 | 52.3555 | -1.1743 | 2020-09-05 04:28:19 | England, United Kingdom | ||
1357954 | 1357954 | 2020-09-03 | United Kingdom | England | 293925 | 50155 | 0 | 257053 | 52.3555 | -1.1743 | 2020-09-04 04:28:26 | England, United Kingdom | ||
1109191 | 1109191 | 2020-09-02 | United Kingdom | England | 292418 | 50149 | 0 | 255557 | 52.3555 | -1.1743 | 2020-09-03 04:28:22 | England, United Kingdom | ||
2063520 | 2063520 | 2020-09-01 | United Kingdom | England | 291179 | 50136 | 0 | 254325 | 52.3555 | -1.1743 | 2020-09-02 04:28:25 | England, United Kingdom | ||
197705 | 197705 | 2020-08-31 | United Kingdom | England | 290138 | 50127 | 0 | 253286 | 52.3555 | -1.1743 | 2020-09-01 04:28:31 | England, United Kingdom | ||
3935660 | 3935660 | 2020-08-30 | United Kingdom | England | 288989 | 50111 | 0 | 252139 | 52.3555 | -1.1743 | 2020-08-31 04:28:27 | England, United Kingdom | ||
613322 | 613322 | 2020-08-29 | United Kingdom | England | 287502 | 50103 | 0 | 250653 | 52.3555 | -1.1743 | 2020-08-30 04:28:22 | England, United Kingdom | ||
1526817 | 1526817 | 2020-08-28 | United Kingdom | England | 286611 | 50095 | 0 | 249774 | 52.3555 | -1.1743 | 2020-08-29 04:28:19 | England, United Kingdom | ||
2513818 | 2513818 | 2020-08-27 | United Kingdom | England | 285505 | 50084 | 0 | 248677 | 52.3555 | -1.1743 | 2020-08-28 04:28:11 | England, United Kingdom | ||
2000278 | 2000278 | 2020-08-26 | United Kingdom | England | 284155 | 50073 | 0 | 247337 | 52.3555 | -1.1743 | 2020-08-27 04:28:15 | England, United Kingdom | ||
3566202 | 3566202 | 2020-08-25 | United Kingdom | England | 283280 | 50058 | 0 | 246475 | 52.3555 | -1.1743 | 2020-08-26 04:28:11 | England, United Kingdom | ||
2994906 | 2994906 | 2020-08-24 | United Kingdom | England | 282215 | 50039 | 0 | 245426 | 52.3555 | -1.1743 | 2020-08-25 04:28:02 | England, United Kingdom | ||
2219301 | 2219301 | 2020-08-23 | United Kingdom | England | 281457 | 50031 | 0 | 244671 | 52.3555 | -1.1743 | 2020-08-24 04:27:56 | England, United Kingdom | ||
2303083 | 2303083 | 2020-08-22 | United Kingdom | England | 280519 | 50015 | 0 | 243737 | 52.3555 | -1.1743 | 2020-08-23 04:27:48 | England, United Kingdom | ||
1483189 | 1483189 | 2020-08-21 | United Kingdom | England | 279459 | 50004 | 0 | 242694 | 52.3555 | -1.1743 | 2020-08-22 04:27:49 | England, United Kingdom | ||
3487938 | 3487938 | 2020-08-20 | United Kingdom | England | 278551 | 49995 | 0 | 241788 | 52.3555 | -1.1743 | 2020-08-21 04:27:41 | England, United Kingdom | ||
209887 | 209887 | 2020-08-19 | United Kingdom | England | 277516 | 49979 | 0 | 240759 | 52.3555 | -1.1743 | 2020-08-20 04:27:43 | England, United Kingdom | ||
3181639 | 3181639 | 2020-08-18 | United Kingdom | England | 276809 | 49969 | 0 | 240067 | 52.3555 | -1.1743 | 2020-08-19 04:27:00 | England, United Kingdom | ||
841243 | 841243 | 2020-08-17 | United Kingdom | England | 275834 | 49958 | 0 | 239103 | 52.3555 | -1.1743 | 2020-08-18 04:27:56 | England, United Kingdom | ||
1559599 | 1559599 | 2020-08-16 | United Kingdom | England | 275200 | 49939 | 0 | 233128 | 52.3555 | -1.1743 | 2020-08-17 04:27:20 | England, United Kingdom | ||
149601 | 149601 | 2020-08-15 | United Kingdom | England | 274248 | 49927 | 0 | 232176 | 52.3555 | -1.1743 | 2020-08-16 04:27:42 | England, United Kingdom | ||
1615876 | 1615876 | 2020-08-14 | United Kingdom | England | 270971 | 49906 | 0 | 228899 | 52.3555 | -1.1743 | 2020-08-15 04:27:31 | England, United Kingdom | ||
586460 | 586460 | 2020-08-13 | United Kingdom | England | 270971 | 49891 | 0 | 228899 | 52.3555 | -1.1743 | 2020-08-14 04:51:19 | 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]);