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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3073696 | 3073696 | 2021-11-23 | United Kingdom | Wales | 493571 | 9036 | 0 | 52.1307 | -3.7837 | 2021-11-24 04:22:14 | Wales, United Kingdom | |||
3752794 | 3752794 | 2021-11-22 | United Kingdom | Wales | 491640 | 9027 | 0 | 52.1307 | -3.7837 | 2021-11-23 04:22:39 | Wales, United Kingdom | |||
1018001 | 1018001 | 2021-11-21 | United Kingdom | Wales | 487152 | 9016 | 0 | 52.1307 | -3.7837 | 2021-11-22 04:22:20 | Wales, United Kingdom | |||
726165 | 726165 | 2021-11-20 | United Kingdom | Wales | 484744 | 9008 | 0 | 52.1307 | -3.7837 | 2021-11-21 04:22:13 | Wales, United Kingdom | |||
165695 | 165695 | 2021-11-19 | United Kingdom | Wales | 484744 | 8994 | 0 | 52.1307 | -3.7837 | 2021-11-20 04:22:17 | Wales, United Kingdom | |||
3292582 | 3292582 | 2021-11-18 | United Kingdom | Wales | 482288 | 8978 | 0 | 52.1307 | -3.7837 | 2021-11-19 04:21:40 | Wales, United Kingdom | |||
451038 | 451038 | 2021-11-17 | United Kingdom | Wales | 479712 | 8974 | 0 | 52.1307 | -3.7837 | 2021-11-18 04:21:33 | Wales, United Kingdom | |||
3346288 | 3346288 | 2021-11-16 | United Kingdom | Wales | 477295 | 8962 | 0 | 52.1307 | -3.7837 | 2021-11-17 04:21:48 | Wales, United Kingdom | |||
2291124 | 2291124 | 2021-11-15 | United Kingdom | Wales | 475375 | 8954 | 0 | 52.1307 | -3.7837 | 2021-11-16 04:21:10 | Wales, United Kingdom | |||
1325898 | 1325898 | 2021-11-14 | United Kingdom | Wales | 470856 | 8944 | 0 | 52.1307 | -3.7837 | 2021-11-15 04:21:36 | Wales, United Kingdom | |||
690024 | 690024 | 2021-11-13 | United Kingdom | Wales | 468197 | 8935 | 0 | 52.1307 | -3.7837 | 2021-11-14 04:21:31 | Wales, United Kingdom | |||
718133 | 718133 | 2021-11-12 | United Kingdom | Wales | 468197 | 8919 | 0 | 52.1307 | -3.7837 | 2021-11-13 04:21:38 | Wales, United Kingdom | |||
32083 | 32083 | 2021-11-11 | United Kingdom | Wales | 465413 | 8903 | 0 | 52.1307 | -3.7837 | 2021-11-12 04:22:01 | Wales, United Kingdom | |||
2848522 | 2848522 | 2021-11-10 | United Kingdom | Wales | 463279 | 8890 | 0 | 52.1307 | -3.7837 | 2021-11-11 04:21:45 | Wales, United Kingdom | |||
90792 | 90792 | 2021-11-09 | United Kingdom | Wales | 461109 | 8875 | 0 | 52.1307 | -3.7837 | 2021-11-10 04:21:38 | Wales, United Kingdom | |||
3643220 | 3643220 | 2021-11-08 | United Kingdom | Wales | 459325 | 8864 | 0 | 52.1307 | -3.7837 | 2021-11-09 04:21:36 | Wales, United Kingdom | |||
2004328 | 2004328 | 2021-11-07 | United Kingdom | Wales | 455023 | 8854 | 0 | 52.1307 | -3.7837 | 2021-11-08 04:21:43 | Wales, United Kingdom | |||
499319 | 499319 | 2021-11-06 | United Kingdom | Wales | 452440 | 8842 | 0 | 52.1307 | -3.7837 | 2021-11-07 04:21:53 | Wales, United Kingdom | |||
3125174 | 3125174 | 2021-11-05 | United Kingdom | Wales | 452440 | 8835 | 0 | 52.1307 | -3.7837 | 2021-11-06 04:21:51 | Wales, United Kingdom | |||
702072 | 702072 | 2021-11-04 | United Kingdom | Wales | 450455 | 8826 | 0 | 52.1307 | -3.7837 | 2021-11-05 04:21:54 | Wales, United Kingdom | |||
279850 | 279850 | 2021-11-03 | United Kingdom | Wales | 447655 | 8818 | 0 | 52.1307 | -3.7837 | 2021-11-04 04:22:20 | Wales, United Kingdom | |||
47375 | 47375 | 2021-11-02 | United Kingdom | Wales | 445163 | 8804 | 0 | 52.1307 | -3.7837 | 2021-11-03 06:22:09 | Wales, United Kingdom | |||
3515071 | 3515071 | 2021-11-01 | United Kingdom | Wales | 442953 | 8794 | 0 | 52.1307 | -3.7837 | 2021-11-02 04:22:03 | Wales, United Kingdom | |||
291662 | 291662 | 2021-10-31 | United Kingdom | Wales | 437972 | 8784 | 0 | 52.1307 | -3.7837 | 2021-11-01 04:22:01 | Wales, United Kingdom | |||
2724668 | 2724668 | 2021-10-30 | United Kingdom | Wales | 434956 | 8765 | 0 | 52.1307 | -3.7837 | 2021-10-31 04:22:08 | Wales, United Kingdom | |||
570770 | 570770 | 2021-10-29 | United Kingdom | Wales | 434956 | 8749 | 0 | 52.1307 | -3.7837 | 2021-10-30 04:22:03 | Wales, United Kingdom | |||
8012 | 8012 | 2021-10-28 | United Kingdom | Wales | 432395 | 8734 | 0 | 52.1307 | -3.7837 | 2021-10-29 04:22:03 | Wales, United Kingdom | |||
538402 | 538402 | 2021-10-27 | United Kingdom | Wales | 429731 | 8720 | 0 | 52.1307 | -3.7837 | 2021-10-28 04:22:08 | Wales, United Kingdom | |||
3495839 | 3495839 | 2021-10-26 | United Kingdom | Wales | 427150 | 8707 | 0 | 52.1307 | -3.7837 | 2021-10-27 04:22:32 | Wales, United Kingdom | |||
3797561 | 3797561 | 2021-10-25 | United Kingdom | Wales | 418980 | 8692 | 0 | 52.1307 | -3.7837 | 2021-10-26 04:22:09 | Wales, United Kingdom | |||
686007 | 686007 | 2021-10-24 | United Kingdom | Wales | 418980 | 8686 | 0 | 52.1307 | -3.7837 | 2021-10-25 04:22:31 | Wales, United Kingdom | |||
774015 | 774015 | 2021-10-23 | United Kingdom | Wales | 415829 | 8671 | 0 | 52.1307 | -3.7837 | 2021-10-24 04:21:22 | Wales, United Kingdom | |||
657662 | 657662 | 2021-10-22 | United Kingdom | Wales | 415829 | 8662 | 0 | 52.1307 | -3.7837 | 2021-10-23 04:21:32 | Wales, United Kingdom | |||
2127409 | 2127409 | 2021-10-21 | United Kingdom | Wales | 412534 | 8658 | 0 | 52.1307 | -3.7837 | 2021-10-22 04:21:14 | Wales, United Kingdom | |||
447021 | 447021 | 2021-10-20 | United Kingdom | Wales | 408294 | 8638 | 0 | 52.1307 | -3.7837 | 2021-10-21 04:21:18 | Wales, United Kingdom | |||
601340 | 601340 | 2021-10-19 | United Kingdom | Wales | 404844 | 8622 | 0 | 52.1307 | -3.7837 | 2021-10-20 04:21:00 | Wales, United Kingdom | |||
2047517 | 2047517 | 2021-10-18 | United Kingdom | Wales | 401644 | 8610 | 0 | 52.1307 | -3.7837 | 2021-10-19 04:20:54 | Wales, United Kingdom | |||
1912878 | 1912878 | 2021-10-17 | United Kingdom | Wales | 395247 | 8596 | 0 | 52.1307 | -3.7837 | 2021-10-18 04:21:10 | Wales, United Kingdom | |||
938467 | 938467 | 2021-10-16 | United Kingdom | Wales | 392282 | 8586 | 0 | 52.1307 | -3.7837 | 2021-10-17 04:21:29 | Wales, United Kingdom | |||
2947022 | 2947022 | 2021-10-15 | United Kingdom | Wales | 392282 | 8573 | 0 | 52.1307 | -3.7837 | 2021-10-16 04:21:15 | Wales, United Kingdom | |||
495302 | 495302 | 2021-10-14 | United Kingdom | Wales | 389152 | 8562 | 0 | 52.1307 | -3.7837 | 2021-10-15 04:21:26 | Wales, United Kingdom | |||
637590 | 637590 | 2021-10-13 | United Kingdom | Wales | 386516 | 8545 | 0 | 52.1307 | -3.7837 | 2021-10-14 04:21:29 | Wales, United Kingdom | |||
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 |
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]);