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 = "Wales" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1495268 | 1495268 | 2021-10-12 | United Kingdom | Wales | 384250 | 8532 | 0 | 52.1307 | -3.7837 | 2021-10-13 04:20:51 | Wales, United Kingdom | |||
3011001 | 3011001 | 2021-10-11 | United Kingdom | Wales | 382203 | 8517 | 0 | 52.1307 | -3.7837 | 2021-10-12 04:21:09 | Wales, United Kingdom | |||
427017 | 427017 | 2021-10-10 | United Kingdom | Wales | 377734 | 8509 | 0 | 52.1307 | -3.7837 | 2021-10-11 04:21:31 | Wales, United Kingdom | |||
2879874 | 2879874 | 2021-10-09 | United Kingdom | Wales | 377734 | 8497 | 0 | 52.1307 | -3.7837 | 2021-10-10 04:21:38 | Wales, United Kingdom | |||
2963040 | 2963040 | 2021-10-08 | United Kingdom | Wales | 372029 | 8491 | 0 | 52.1307 | -3.7837 | 2021-10-09 04:21:34 | Wales, United Kingdom | |||
471078 | 471078 | 2021-10-07 | United Kingdom | Wales | 372029 | 8482 | 0 | 52.1307 | -3.7837 | 2021-10-08 04:21:25 | Wales, United Kingdom | |||
2462458 | 2462458 | 2021-10-06 | United Kingdom | Wales | 368629 | 8469 | 0 | 52.1307 | -3.7837 | 2021-10-07 04:21:36 | Wales, United Kingdom | |||
3836151 | 3836151 | 2021-10-05 | United Kingdom | Wales | 366624 | 8453 | 0 | 52.1307 | -3.7837 | 2021-10-06 04:21:33 | Wales, United Kingdom | |||
990644 | 990644 | 2021-10-04 | United Kingdom | Wales | 364866 | 8445 | 0 | 52.1307 | -3.7837 | 2021-10-05 04:21:27 | Wales, United Kingdom | |||
1277954 | 1277954 | 2021-10-03 | United Kingdom | Wales | 360881 | 8437 | 0 | 52.1307 | -3.7837 | 2021-10-04 04:21:31 | Wales, United Kingdom | |||
3931707 | 3931707 | 2021-10-02 | United Kingdom | Wales | 358550 | 8431 | 0 | 52.1307 | -3.7837 | 2021-10-03 04:21:24 | Wales, United Kingdom | |||
2135687 | 2135687 | 2021-10-01 | United Kingdom | Wales | 358550 | 8419 | 0 | 52.1307 | -3.7837 | 2021-10-02 04:21:25 | Wales, United Kingdom | |||
2776644 | 2776644 | 2021-09-30 | United Kingdom | Wales | 355542 | 8406 | 0 | 52.1307 | -3.7837 | 2021-10-01 04:21:35 | Wales, United Kingdom | |||
710100 | 710100 | 2021-09-29 | United Kingdom | Wales | 352939 | 8393 | 0 | 52.1307 | -3.7837 | 2021-09-30 04:21:20 | Wales, United Kingdom | |||
1337942 | 1337942 | 2021-09-28 | United Kingdom | Wales | 349570 | 8373 | 0 | 52.1307 | -3.7837 | 2021-09-29 04:21:45 | Wales, United Kingdom | |||
1239311 | 1239311 | 2021-09-27 | United Kingdom | Wales | 347300 | 8363 | 0 | 52.1307 | -3.7837 | 2021-09-28 04:21:28 | Wales, United Kingdom | |||
2079612 | 2079612 | 2021-09-26 | United Kingdom | Wales | 341641 | 8350 | 0 | 52.1307 | -3.7837 | 2021-09-27 04:21:16 | Wales, United Kingdom | |||
1728164 | 1728164 | 2021-09-25 | United Kingdom | Wales | 338338 | 8338 | 0 | 52.1307 | -3.7837 | 2021-09-26 04:21:29 | Wales, United Kingdom | |||
1924884 | 1924884 | 2021-09-24 | United Kingdom | Wales | 338338 | 8330 | 0 | 52.1307 | -3.7837 | 2021-09-25 04:21:31 | Wales, United Kingdom | |||
605355 | 605355 | 2021-09-23 | United Kingdom | Wales | 335611 | 8320 | 0 | 52.1307 | -3.7837 | 2021-09-24 04:21:44 | Wales, United Kingdom | |||
3014999 | 3014999 | 2021-09-22 | United Kingdom | Wales | 333135 | 8309 | 0 | 52.1307 | -3.7837 | 2021-09-23 04:21:43 | Wales, United Kingdom | |||
3761137 | 3761137 | 2021-09-21 | United Kingdom | Wales | 330650 | 8304 | 0 | 52.1307 | -3.7837 | 2021-09-22 04:21:45 | Wales, United Kingdom | |||
813240 | 813240 | 2021-09-20 | United Kingdom | Wales | 328074 | 8293 | 0 | 52.1307 | -3.7837 | 2021-09-21 04:21:26 | Wales, United Kingdom | |||
1818439 | 1818439 | 2021-09-19 | United Kingdom | Wales | 322816 | 8281 | 0 | 52.1307 | -3.7837 | 2021-09-20 04:21:22 | Wales, United Kingdom | |||
20019 | 20019 | 2021-09-18 | United Kingdom | Wales | 320099 | 8278 | 0 | 52.1307 | -3.7837 | 2021-09-19 04:21:34 | Wales, United Kingdom | |||
2621704 | 2621704 | 2021-09-17 | United Kingdom | Wales | 320099 | 8270 | 0 | 52.1307 | -3.7837 | 2021-09-18 04:21:24 | Wales, United Kingdom | |||
2812412 | 2812412 | 2021-09-16 | United Kingdom | Wales | 317481 | 8251 | 0 | 52.1307 | -3.7837 | 2021-09-17 04:21:46 | Wales, United Kingdom | |||
1378156 | 1378156 | 2021-09-15 | United Kingdom | Wales | 314590 | 8236 | 0 | 52.1307 | -3.7837 | 2021-09-16 04:22:19 | Wales, United Kingdom | |||
2466455 | 2466455 | 2021-09-14 | United Kingdom | Wales | 312292 | 8215 | 0 | 52.1307 | -3.7837 | 2021-09-15 03:22:37 | Wales, United Kingdom | |||
1389294 | 1389294 | 2021-09-13 | United Kingdom | Wales | 310368 | 8205 | 0 | 52.1307 | -3.7837 | 2021-09-14 04:21:41 | Wales, United Kingdom | |||
1888663 | 1888663 | 2021-09-12 | United Kingdom | Wales | 306060 | 8198 | 0 | 52.1307 | -3.7837 | 2021-09-13 04:21:15 | Wales, United Kingdom | |||
3809566 | 3809566 | 2021-09-11 | United Kingdom | Wales | 303743 | 8190 | 0 | 52.1307 | -3.7837 | 2021-09-12 04:21:13 | Wales, United Kingdom | |||
3452506 | 3452506 | 2021-09-10 | United Kingdom | Wales | 303743 | 8183 | 0 | 52.1307 | -3.7837 | 2021-09-11 04:21:30 | Wales, United Kingdom | |||
1266452 | 1266452 | 2021-09-09 | United Kingdom | Wales | 301276 | 8172 | 0 | 52.1307 | -3.7837 | 2021-09-10 04:21:20 | Wales, United Kingdom | |||
2282822 | 2282822 | 2021-09-08 | United Kingdom | Wales | 298979 | 8158 | 0 | 52.1307 | -3.7837 | 2021-09-09 04:21:27 | Wales, United Kingdom | |||
645601 | 645601 | 2021-09-07 | United Kingdom | Wales | 296310 | 8151 | 0 | 52.1307 | -3.7837 | 2021-09-08 04:21:31 | Wales, United Kingdom | |||
3197664 | 3197664 | 2021-09-06 | United Kingdom | Wales | 293806 | 8142 | 0 | 52.1307 | -3.7837 | 2021-09-07 04:21:35 | Wales, United Kingdom | |||
3284532 | 3284532 | 2021-09-05 | United Kingdom | Wales | 288645 | 8134 | 0 | 52.1307 | -3.7837 | 2021-09-06 04:21:22 | Wales, United Kingdom | |||
252946 | 252946 | 2021-09-04 | United Kingdom | Wales | 286256 | 8124 | 0 | 52.1307 | -3.7837 | 2021-09-05 04:21:33 | Wales, United Kingdom | |||
3978227 | 3978227 | 2021-09-03 | United Kingdom | Wales | 286256 | 8115 | 0 | 52.1307 | -3.7837 | 2021-09-04 04:21:28 | Wales, United Kingdom | |||
181689 | 181689 | 2021-09-02 | United Kingdom | Wales | 283865 | 8107 | 0 | 52.1307 | -3.7837 | 2021-09-03 04:21:20 | Wales, United Kingdom | |||
70724 | 70724 | 2021-09-01 | United Kingdom | Wales | 281590 | 8095 | 0 | 52.1307 | -3.7837 | 2021-09-02 04:21:15 | Wales, United Kingdom | |||
2071566 | 2071566 | 2021-08-31 | United Kingdom | Wales | 278262 | 8092 | 0 | 52.1307 | -3.7837 | 2021-09-01 04:21:38 | Wales, United Kingdom | |||
1779020 | 1779020 | 2021-08-30 | United Kingdom | Wales | 274390 | 8085 | 0 | 52.1307 | -3.7837 | 2021-08-31 04:21:46 | Wales, United Kingdom | |||
3895594 | 3895594 | 2021-08-29 | United Kingdom | Wales | 274390 | 8080 | 0 | 52.1307 | -3.7837 | 2021-08-30 04:21:23 | Wales, United Kingdom | |||
2796697 | 2796697 | 2021-08-28 | United Kingdom | Wales | 272034 | 8072 | 0 | 52.1307 | -3.7837 | 2021-08-29 04:21:14 | Wales, United Kingdom | |||
2926856 | 2926856 | 2021-08-27 | United Kingdom | Wales | 272034 | 8066 | 0 | 52.1307 | -3.7837 | 2021-08-28 04:21:28 | Wales, United Kingdom | |||
1599870 | 1599870 | 2021-08-26 | United Kingdom | Wales | 270243 | 8059 | 0 | 52.1307 | -3.7837 | 2021-08-27 04:21:37 | Wales, United Kingdom | |||
36079 | 36079 | 2021-08-25 | United Kingdom | Wales | 267854 | 8057 | 0 | 52.1307 | -3.7837 | 2021-08-26 04:21:28 | Wales, United Kingdom | |||
3109118 | 3109118 | 2021-08-24 | United Kingdom | Wales | 266149 | 8053 | 0 | 52.1307 | -3.7837 | 2021-08-25 04:21:41 | Wales, United Kingdom | |||
3169289 | 3169289 | 2021-08-23 | United Kingdom | Wales | 264756 | 8049 | 0 | 52.1307 | -3.7837 | 2021-08-24 04:21:19 | Wales, United Kingdom | |||
2179216 | 2179216 | 2021-08-22 | United Kingdom | Wales | 261509 | 8046 | 0 | 52.1307 | -3.7837 | 2021-08-23 04:21:27 | Wales, United Kingdom | |||
3559312 | 3559312 | 2021-08-21 | United Kingdom | Wales | 259883 | 8044 | 0 | 52.1307 | -3.7837 | 2021-08-22 04:21:29 | Wales, United Kingdom | |||
1857654 | 1857654 | 2021-08-20 | United Kingdom | Wales | 259883 | 8043 | 0 | 52.1307 | -3.7837 | 2021-08-21 04:21:38 | Wales, United Kingdom | |||
515361 | 515361 | 2021-08-19 | United Kingdom | Wales | 258155 | 8039 | 0 | 52.1307 | -3.7837 | 2021-08-20 04:21:33 | Wales, United Kingdom | |||
2521840 | 2521840 | 2021-08-18 | United Kingdom | Wales | 256675 | 8036 | 0 | 52.1307 | -3.7837 | 2021-08-19 04:21:15 | Wales, United Kingdom | |||
248932 | 248932 | 2021-08-17 | United Kingdom | Wales | 255302 | 8034 | 0 | 52.1307 | -3.7837 | 2021-08-18 04:21:35 | Wales, United Kingdom | |||
1607895 | 1607895 | 2021-08-16 | United Kingdom | Wales | 254541 | 8033 | 0 | 52.1307 | -3.7837 | 2021-08-17 04:21:49 | Wales, United Kingdom | |||
106989 | 106989 | 2021-08-15 | United Kingdom | Wales | 252147 | 8032 | 0 | 52.1307 | -3.7837 | 2021-08-16 04:21:31 | Wales, United Kingdom | |||
511347 | 511347 | 2021-08-14 | United Kingdom | Wales | 251048 | 8027 | 0 | 52.1307 | -3.7837 | 2021-08-15 04:21:41 | Wales, United Kingdom | |||
1487219 | 1487219 | 2021-08-13 | United Kingdom | Wales | 251048 | 8022 | 0 | 52.1307 | -3.7837 | 2021-08-14 04:21:25 | Wales, United Kingdom | |||
2903349 | 2903349 | 2021-08-12 | United Kingdom | Wales | 249958 | 8021 | 0 | 52.1307 | -3.7837 | 2021-08-13 04:21:24 | Wales, United Kingdom | |||
1345953 | 1345953 | 2021-08-11 | United Kingdom | Wales | 248112 | 8016 | 0 | 52.1307 | -3.7837 | 2021-08-12 04:21:25 | Wales, United Kingdom | |||
2355100 | 2355100 | 2021-08-10 | United Kingdom | Wales | 248112 | 8016 | 0 | 52.1307 | -3.7837 | 2021-08-11 04:21:58 | Wales, United Kingdom | |||
653629 | 653629 | 2021-08-09 | United Kingdom | Wales | 247569 | 8012 | 0 | 52.1307 | -3.7837 | 2021-08-10 04:21:27 | Wales, United Kingdom | |||
593291 | 593291 | 2021-08-08 | United Kingdom | Wales | 246205 | 8011 | 0 | 52.1307 | -3.7837 | 2021-08-09 04:21:24 | Wales, United Kingdom | |||
2207303 | 2207303 | 2021-08-07 | United Kingdom | Wales | 245341 | 8011 | 0 | 52.1307 | -3.7837 | 2021-08-08 04:21:33 | Wales, United Kingdom | |||
1121253 | 1121253 | 2021-08-06 | United Kingdom | Wales | 245341 | 8010 | 0 | 52.1307 | -3.7837 | 2021-08-07 04:21:30 | Wales, United Kingdom | |||
1960190 | 1960190 | 2021-08-05 | United Kingdom | Wales | 244538 | 8008 | 0 | 52.1307 | -3.7837 | 2021-08-06 04:21:18 | Wales, United Kingdom | |||
335569 | 335569 | 2021-08-04 | United Kingdom | Wales | 243857 | 8007 | 0 | 238237 | 52.1307 | -3.7837 | 2021-08-05 04:21:51 | Wales, United Kingdom | ||
3471840 | 3471840 | 2021-08-03 | United Kingdom | Wales | 243249 | 8006 | 0 | 237633 | 52.1307 | -3.7837 | 2021-08-04 04:21:25 | Wales, United Kingdom | ||
3687114 | 3687114 | 2021-08-02 | United Kingdom | Wales | 242668 | 8001 | 0 | 237052 | 52.1307 | -3.7837 | 2021-08-03 04:21:39 | Wales, United Kingdom | ||
3019013 | 3019013 | 2021-08-01 | United Kingdom | Wales | 241562 | 7997 | 0 | 235947 | 52.1307 | -3.7837 | 2021-08-02 04:21:36 | Wales, United Kingdom | ||
3907636 | 3907636 | 2021-07-31 | United Kingdom | Wales | 240843 | 7993 | 0 | 235233 | 52.1307 | -3.7837 | 2021-08-01 04:21:50 | Wales, United Kingdom | ||
3299841 | 3299841 | 2021-07-30 | United Kingdom | Wales | 240843 | 7990 | 0 | 235233 | 52.1307 | -3.7837 | 2021-07-31 04:21:35 | Wales, United Kingdom | ||
3389052 | 3389052 | 2021-07-29 | United Kingdom | Wales | 240019 | 7989 | 0 | 234413 | 52.1307 | -3.7837 | 2021-07-30 04:21:34 | Wales, United Kingdom | ||
411957 | 411957 | 2021-07-28 | United Kingdom | Wales | 239295 | 7987 | 0 | 233692 | 52.1307 | -3.7837 | 2021-07-29 04:21:33 | Wales, United Kingdom | ||
1309818 | 1309818 | 2021-07-27 | United Kingdom | Wales | 238707 | 7983 | 0 | 233110 | 52.1307 | -3.7837 | 2021-07-28 04:21:39 | Wales, United Kingdom | ||
3221961 | 3221961 | 2021-07-26 | United Kingdom | Wales | 238003 | 7980 | 0 | 232406 | 52.1307 | -3.7837 | 2021-07-27 04:21:18 | Wales, United Kingdom | ||
1382170 | 1382170 | 2021-07-25 | United Kingdom | Wales | 236873 | 7977 | 0 | 231278 | 52.1307 | -3.7837 | 2021-07-26 04:21:28 | Wales, United Kingdom | ||
1333910 | 1333910 | 2021-07-24 | United Kingdom | Wales | 235635 | 7973 | 0 | 230040 | 52.1307 | -3.7837 | 2021-07-25 04:22:12 | Wales, United Kingdom | ||
3141214 | 3141214 | 2021-07-23 | United Kingdom | Wales | 235635 | 7969 | 0 | 230040 | 52.1307 | -3.7837 | 2021-07-24 00:21:36 | Wales, United Kingdom | ||
3479974 | 3479974 | 2021-07-22 | United Kingdom | Wales | 234880 | 7965 | 0 | 229286 | 52.1307 | -3.7837 | 2021-07-23 04:21:29 | Wales, United Kingdom | ||
3335193 | 3335193 | 2021-07-21 | United Kingdom | Wales | 234168 | 7964 | 0 | 228578 | 52.1307 | -3.7837 | 2021-07-22 04:21:19 | Wales, United Kingdom | ||
2375174 | 2375174 | 2021-07-20 | United Kingdom | Wales | 233227 | 7963 | 0 | 227638 | 52.1307 | -3.7837 | 2021-07-21 04:21:40 | Wales, United Kingdom | ||
487253 | 487253 | 2021-07-19 | United Kingdom | Wales | 232672 | 7958 | 0 | 227083 | 52.1307 | -3.7837 | 2021-07-20 04:21:48 | Wales, United Kingdom | ||
2677476 | 2677476 | 2021-07-18 | United Kingdom | Wales | 230619 | 7957 | 0 | 225033 | 52.1307 | -3.7837 | 2021-07-19 04:21:24 | Wales, United Kingdom | ||
3709788 | 3709788 | 2021-07-17 | United Kingdom | Wales | 229507 | 7955 | 0 | 223924 | 52.1307 | -3.7837 | 2021-07-18 04:22:07 | Wales, United Kingdom | ||
2951019 | 2951019 | 2021-07-16 | United Kingdom | Wales | 229507 | 7952 | 0 | 223924 | 52.1307 | -3.7837 | 2021-07-17 04:22:22 | Wales, United Kingdom | ||
299675 | 299675 | 2021-07-15 | United Kingdom | Wales | 228424 | 7949 | 0 | 222843 | 52.1307 | -3.7837 | 2021-07-16 04:21:22 | Wales, United Kingdom | ||
3635620 | 3635620 | 2021-07-14 | United Kingdom | Wales | 227563 | 7948 | 0 | 221982 | 52.1307 | -3.7837 | 2021-07-15 04:21:48 | Wales, United Kingdom | ||
582495 | 582495 | 2021-07-13 | United Kingdom | Wales | 226428 | 7946 | 0 | 220848 | 52.1307 | -3.7837 | 2021-07-14 04:21:35 | Wales, United Kingdom | ||
3744744 | 3744744 | 2021-07-12 | United Kingdom | Wales | 225691 | 7944 | 0 | 220112 | 52.1307 | -3.7837 | 2021-07-13 04:21:18 | Wales, United Kingdom | ||
3663257 | 3663257 | 2021-07-11 | United Kingdom | Wales | 224501 | 7943 | 0 | 218922 | 52.1307 | -3.7837 | 2021-07-12 04:21:34 | Wales, United Kingdom | ||
629541 | 629541 | 2021-07-10 | United Kingdom | Wales | 223804 | 7942 | 0 | 218225 | 52.1307 | -3.7837 | 2021-07-11 04:21:43 | Wales, United Kingdom | ||
833260 | 833260 | 2021-07-09 | United Kingdom | Wales | 223804 | 7941 | 0 | 218225 | 52.1307 | -3.7837 | 2021-07-10 04:21:25 | Wales, United Kingdom | ||
782024 | 782024 | 2021-07-08 | United Kingdom | Wales | 223149 | 7940 | 0 | 217571 | 52.1307 | -3.7837 | 2021-07-09 04:21:21 | Wales, United Kingdom | ||
1444246 | 1444246 | 2021-07-07 | United Kingdom | Wales | 222448 | 7940 | 0 | 216870 | 52.1307 | -3.7837 | 2021-07-08 04:21:26 | Wales, United Kingdom | ||
2697351 | 2697351 | 2021-07-06 | United Kingdom | Wales | 221785 | 7939 | 0 | 216207 | 52.1307 | -3.7837 | 2021-07-07 04:21:20 | Wales, United Kingdom | ||
1936100 | 1936100 | 2021-07-05 | United Kingdom | Wales | 221087 | 7939 | 0 | 215510 | 52.1307 | -3.7837 | 2021-07-06 04:21:32 | Wales, 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]);