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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3535077 | 3535077 | 2020-08-12 | United Kingdom | England | 270971 | 49873 | 0 | 228899 | 52.3555 | -1.1743 | 2020-08-13 04:29:15 | England, United Kingdom | ||
662667 | 662667 | 2020-08-11 | United Kingdom | England | 269011 | 49853 | 0 | 227111 | 52.3555 | -1.1743 | 2020-08-12 04:27:29 | England, United Kingdom | ||
1920283 | 1920283 | 2020-08-10 | United Kingdom | England | 269011 | 49833 | 0 | 227111 | 52.3555 | -1.1743 | 2020-08-11 04:35:08 | England, United Kingdom | ||
3923092 | 3923092 | 2020-08-09 | United Kingdom | England | 268312 | 49810 | 0 | 226364 | 52.3555 | -1.1743 | 2020-08-10 04:34:55 | England, United Kingdom | ||
371260 | 371260 | 2020-08-08 | United Kingdom | England | 267324 | 49792 | 0 | 225384 | 52.3555 | -1.1743 | 2020-08-09 04:34:54 | England, United Kingdom | ||
458444 | 458444 | 2020-08-07 | United Kingdom | England | 266645 | 49774 | 0 | 224759 | 52.3555 | -1.1743 | 2020-08-08 04:34:53 | England, United Kingdom | ||
3612129 | 3612129 | 2020-08-06 | United Kingdom | England | 265849 | 49755 | 0 | 224054 | 52.3555 | -1.1743 | 2020-08-07 04:35:11 | England, United Kingdom | ||
3792959 | 3792959 | 2020-08-05 | United Kingdom | England | 265023 | 49738 | 0 | 223274 | 52.3555 | -1.1743 | 2020-08-06 04:35:02 | England, United Kingdom | ||
98195 | 98195 | 2020-08-04 | United Kingdom | England | 264219 | 49731 | 0 | 222533 | 52.3555 | -1.1743 | 2020-08-05 04:34:43 | England, United Kingdom | ||
2740078 | 2740078 | 2020-08-03 | United Kingdom | England | 263602 | 49711 | 0 | 222004 | 52.3555 | -1.1743 | 2020-08-04 04:41:59 | England, United Kingdom | ||
2807830 | 2807830 | 2020-08-02 | United Kingdom | England | 262746 | 49692 | 0 | 221157 | 52.3555 | -1.1743 | 2020-08-03 04:34:35 | England, United Kingdom | ||
753398 | 753398 | 2020-08-01 | United Kingdom | England | 262070 | 49677 | 0 | 220486 | 52.3555 | -1.1743 | 2020-08-02 04:34:47 | England, United Kingdom | ||
3264563 | 3264563 | 2020-07-31 | United Kingdom | England | 261348 | 49661 | 0 | 219836 | 52.3555 | -1.1743 | 2020-08-01 04:36:27 | England, United Kingdom | ||
1928270 | 1928270 | 2020-07-30 | United Kingdom | England | 260534 | 49635 | 0 | 219136 | 52.3555 | -1.1743 | 2020-07-31 04:35:18 | England, United Kingdom | ||
2958438 | 2958438 | 2020-07-29 | United Kingdom | England | 259722 | 49621 | 0 | 218362 | 52.3555 | -1.1743 | 2020-07-30 04:35:05 | England, United Kingdom | ||
3185054 | 3185054 | 2020-07-28 | United Kingdom | England | 259022 | 49600 | 0 | 217740 | 52.3555 | -1.1743 | 2020-07-29 04:35:11 | England, United Kingdom | ||
177106 | 177106 | 2020-07-27 | United Kingdom | England | 258475 | 49580 | 0 | 217312 | 52.3555 | -1.1743 | 2020-07-28 04:58:43 | England, United Kingdom | ||
442419 | 442419 | 2020-07-26 | United Kingdom | England | 257859 | 49564 | 0 | 216703 | 52.3555 | -1.1743 | 2020-07-27 04:35:02 | England, United Kingdom | ||
1502663 | 1502663 | 2020-07-25 | United Kingdom | England | 257138 | 49536 | 0 | 215995 | 52.3555 | -1.1743 | 2020-07-26 04:35:00 | England, United Kingdom | ||
2563633 | 2563633 | 2020-07-24 | United Kingdom | England | 256428 | 49516 | 0 | 215346 | 52.3555 | -1.1743 | 2020-07-25 04:47:39 | England, United Kingdom | ||
61855 | 61855 | 2020-07-23 | United Kingdom | England | 255740 | 49499 | 0 | 214781 | 52.3555 | -1.1743 | 2020-07-24 05:30:40 | England, United Kingdom | ||
844653 | 844653 | 2020-07-22 | United Kingdom | England | 255038 | 49466 | 0 | 214132 | 52.3555 | -1.1743 | 2020-07-23 05:15:04 | England, United Kingdom | ||
1707392 | 1707392 | 2020-07-21 | United Kingdom | England | 254519 | 49432 | 0 | 213691 | 52.3555 | -1.1743 | 2020-07-22 04:34:42 | England, United Kingdom | ||
326883 | 326883 | 2020-07-20 | United Kingdom | England | 254120 | 49402 | 0 | 213402 | 52.3555 | -1.1743 | 2020-07-21 04:38:46 | England, United Kingdom | ||
121788 | 121788 | 2020-07-19 | United Kingdom | England | 253585 | 49373 | 0 | 212879 | 52.3555 | -1.1743 | 2020-07-20 05:34:40 | England, United Kingdom | ||
3205177 | 3205177 | 2020-07-18 | United Kingdom | England | 252913 | 49351 | 0 | 212233 | 52.3555 | -1.1743 | 2020-07-19 04:34:58 | England, United Kingdom | ||
2708479 | 2708479 | 2020-07-17 | United Kingdom | England | 252117 | 49323 | 0 | 211477 | 52.3555 | -1.1743 | 2020-07-18 04:34:45 | England, United Kingdom | ||
367297 | 367297 | 2020-07-16 | United Kingdom | England | 251482 | 49292 | 0 | 210954 | 52.3555 | -1.1743 | 2020-07-17 04:34:50 | England, United Kingdom | ||
2747965 | 2747965 | 2020-07-15 | United Kingdom | England | 250885 | 49274 | 0 | 210423 | 52.3555 | -1.1743 | 2020-07-16 04:44:59 | England, United Kingdom | ||
2158609 | 2158609 | 2020-07-14 | United Kingdom | England | 250379 | 49235 | 0 | 210000 | 52.3555 | -1.1743 | 2020-07-15 04:34:39 | England, United Kingdom | ||
3491250 | 3491250 | 2020-07-13 | United Kingdom | England | 250007 | 49197 | 0 | 209762 | 52.3555 | -1.1743 | 2020-07-14 04:34:46 | England, United Kingdom | ||
3737512 | 3737512 | 2020-07-12 | United Kingdom | England | 249510 | 49155 | 0 | 209276 | 52.3555 | -1.1743 | 2020-07-13 04:43:04 | England, United Kingdom | ||
3435907 | 3435907 | 2020-07-11 | United Kingdom | England | 248895 | 49126 | 0 | 208682 | 52.3555 | -1.1743 | 2020-07-12 04:34:30 | England, United Kingdom | ||
3237405 | 3237405 | 2020-07-10 | United Kingdom | England | 248089 | 49093 | 0 | 208023 | 52.3555 | -1.1743 | 2020-07-11 04:34:26 | England, United Kingdom | ||
1005390 | 1005390 | 2020-07-09 | United Kingdom | England | 247609 | 49051 | 0 | 207591 | 52.3555 | -1.1743 | 2020-07-10 04:34:24 | England, United Kingdom | ||
2222606 | 2222606 | 2020-07-08 | United Kingdom | England | 246992 | 48995 | 0 | 207056 | 52.3555 | -1.1743 | 2020-07-09 04:34:23 | England, United Kingdom | ||
887215 | 887215 | 2020-07-07 | United Kingdom | England | 246386 | 48951 | 0 | 206571 | 52.3555 | -1.1743 | 2020-07-08 05:33:48 | England, United Kingdom | ||
2684775 | 2684775 | 2020-07-06 | United Kingdom | England | 245814 | 48910 | 0 | 206151 | 52.3555 | -1.1743 | 2020-07-07 04:34:00 | England, United Kingdom | ||
415240 | 415240 | 2020-07-05 | United Kingdom | England | 245483 | 48862 | 0 | 205836 | 52.3555 | -1.1743 | 2020-07-06 04:33:57 | England, United Kingdom | ||
529802 | 529802 | 2020-07-04 | United Kingdom | England | 244991 | 48818 | 0 | 205365 | 52.3555 | -1.1743 | 2020-07-05 04:33:46 | England, United Kingdom | ||
2234463 | 2234463 | 2020-07-03 | United Kingdom | England | 244412 | 48772 | 0 | 204845 | 52.3555 | -1.1743 | 2020-07-04 04:33:51 | England, United Kingdom | ||
3045257 | 3045257 | 2020-07-02 | United Kingdom | England | 243910 | 48727 | 0 | 204476 | 52.3555 | -1.1743 | 2020-07-03 04:33:54 | England, United Kingdom | ||
302948 | 302948 | 2020-07-01 | United Kingdom | England | 160764 | 48672 | 0 | 121410 | 52.3555 | -1.1743 | 2020-07-02 04:33:46 | England, United Kingdom | ||
2974326 | 2974326 | 2020-06-30 | United Kingdom | England | 160587 | 48628 | 0 | 121400 | 52.3555 | -1.1743 | 2020-07-01 04:33:52 | England, United Kingdom | ||
2632803 | 2632803 | 2020-06-29 | United Kingdom | England | 160391 | 48557 | 0 | 121355 | 52.3555 | -1.1743 | 2020-06-30 04:33:48 | England, United Kingdom | ||
2306366 | 2306366 | 2020-06-28 | United Kingdom | England | 160292 | 48494 | 0 | 121277 | 52.3555 | -1.1743 | 2020-06-29 04:33:44 | England, United Kingdom | ||
2039701 | 2039701 | 2020-06-27 | United Kingdom | England | 160150 | 48432 | 0 | 121168 | 52.3555 | -1.1743 | 2020-06-28 04:34:04 | England, United Kingdom | ||
1135982 | 1135982 | 2020-06-26 | United Kingdom | England | 159958 | 48371 | 0 | 121070 | 52.3555 | -1.1743 | 2020-06-27 04:33:35 | England, United Kingdom | ||
2624969 | 2624969 | 2020-06-25 | United Kingdom | England | 159696 | 48301 | 0 | 120990 | 52.3555 | -1.1743 | 2020-06-26 04:33:43 | England, United Kingdom | ||
2700609 | 2700609 | 2020-06-24 | United Kingdom | England | 159435 | 48204 | 0 | 120867 | 52.3555 | -1.1743 | 2020-06-25 05:26:54 | England, United Kingdom | ||
1522294 | 1522294 | 2020-06-23 | United Kingdom | England | 159328 | 48111 | 0 | 120901 | 52.3555 | -1.1743 | 2020-06-24 04:33:28 | England, United Kingdom | ||
1510488 | 1510488 | 2020-06-22 | United Kingdom | England | 159118 | 48022 | 0 | 120966 | 52.3555 | -1.1743 | 2020-06-23 04:33:22 | England, United Kingdom | ||
3249227 | 3249227 | 2020-06-21 | United Kingdom | England | 158940 | 47948 | 0 | 120802 | 52.3555 | -1.1743 | 2020-06-22 04:33:20 | England, United Kingdom | ||
2437820 | 2437820 | 2020-06-20 | United Kingdom | England | 158725 | 47881 | 0 | 120626 | 52.3555 | -1.1743 | 2020-06-21 04:33:19 | England, United Kingdom | ||
1691398 | 1691398 | 2020-06-19 | United Kingdom | England | 158401 | 47805 | 0 | 120422 | 52.3555 | -1.1743 | 2020-06-20 04:33:19 | England, United Kingdom | ||
3682547 | 3682547 | 2020-06-18 | United Kingdom | England | 158078 | 47729 | 0 | 120266 | 52.3555 | -1.1743 | 2020-06-19 04:33:17 | England, United Kingdom | ||
1195750 | 1195750 | 2020-06-17 | United Kingdom | England | 157797 | 47650 | 0 | 120105 | 52.3555 | -1.1743 | 2020-06-18 04:33:18 | England, United Kingdom | ||
2386513 | 2386513 | 2020-06-16 | United Kingdom | England | 157545 | 47559 | 0 | 120021 | 52.3555 | -1.1743 | 2020-06-17 04:33:21 | England, United Kingdom | ||
287076 | 287076 | 2020-06-15 | United Kingdom | England | 157293 | 47456 | 0 | 119994 | 52.3555 | -1.1743 | 2020-06-16 04:33:09 | England, United Kingdom | ||
1837027 | 1837027 | 2020-06-14 | United Kingdom | England | 157074 | 47364 | 0 | 119808 | 52.3555 | -1.1743 | 2020-06-15 03:33:14 | England, United Kingdom | ||
3061079 | 3061079 | 2020-06-13 | United Kingdom | England | 156782 | 47245 | 0 | 119542 | 52.3555 | -1.1743 | 2020-06-14 03:33:15 | England, United Kingdom | ||
737399 | 737399 | 2020-06-12 | United Kingdom | England | 156410 | 47160 | 0 | 119341 | 52.3555 | -1.1743 | 2020-06-13 03:33:14 | England, United Kingdom | ||
1273369 | 1273369 | 2020-06-11 | United Kingdom | England | 156018 | 47038 | 0 | 119135 | 52.3555 | -1.1743 | 2020-06-12 05:09:52 | England, United Kingdom | ||
2864396 | 2864396 | 2020-06-10 | United Kingdom | England | 82601 | 0 | 46930 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-11 03:33:41 | England, United Kingdom | |
1211215 | 1211215 | 2020-06-09 | United Kingdom | England | 82601 | 0 | 46788 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-10 04:07:00 | England, United Kingdom | |
217642 | 217642 | 2020-06-08 | United Kingdom | England | 82601 | 0 | 46661 | 0 | 0 | 52.3555 | -1.1743 | 2020-06-09 03:33:03 | 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]);