daily_reports (view)
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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-16 | United Kingdom | Wales | 16871 | 2522 | 0 | 15326 | 52.1307 | -3.7837 | 2020-07-17 04:34:50 | Wales, United Kingdom | ||
2020-08-08 | United Kingdom | Wales | 17425 | 2572 | 0 | 15846 | 52.1307 | -3.7837 | 2020-08-09 04:34:54 | Wales, United Kingdom | ||
2022-09-13 | United Kingdom | Wales | 884498 | 10811 | 0 | 52.1307 | -3.7837 | 2022-09-14 04:20:44 | Wales, United Kingdom | |||
2020-11-06 | United Kingdom | Wales | 58279 | 3161 | 0 | 56297 | 52.1307 | -3.7837 | 2020-11-07 05:24:52 | Wales, United Kingdom | ||
2021-04-30 | United Kingdom | Wales | 211494 | 7914 | 0 | 205944 | 52.1307 | -3.7837 | 2021-05-01 04:20:47 | Wales, United Kingdom | ||
2022-09-23 | United Kingdom | Wales | 885103 | 10827 | 0 | 52.1307 | -3.7837 | 2022-09-24 04:21:40 | Wales, United Kingdom | |||
2021-04-04 | United Kingdom | Wales | 209627 | 7878 | 0 | 204116 | 52.1307 | -3.7837 | 2021-04-05 04:20:35 | Wales, United Kingdom | ||
2020-11-27 | United Kingdom | Wales | 77091 | 3807 | 0 | 74597 | 52.1307 | -3.7837 | 2020-11-28 05:25:50 | Wales, United Kingdom | ||
2022-10-07 | United Kingdom | Wales | 886426 | 10888 | 0 | 52.1307 | -3.7837 | 2022-10-08 04:22:56 | Wales, United Kingdom | |||
2021-06-29 | United Kingdom | Wales | 217732 | 7938 | 0 | 212157 | 52.1307 | -3.7837 | 2021-06-30 04:21:41 | Wales, United Kingdom | ||
2021-12-07 | United Kingdom | Wales | 525225 | 9155 | 0 | 52.1307 | -3.7837 | 2021-12-08 04:22:46 | Wales, United Kingdom | |||
2021-07-28 | United Kingdom | Wales | 239295 | 7987 | 0 | 233692 | 52.1307 | -3.7837 | 2021-07-29 04:21:33 | Wales, United Kingdom | ||
2020-07-05 | United Kingdom | Wales | 15890 | 2502 | 0 | 14359 | 52.1307 | -3.7837 | 2020-07-06 04:33:57 | Wales, United Kingdom | ||
2020-01-26 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 1/26/20 16:00 | ||||
2020-04-18 | United Kingdom | Wales | 82604 | 0 | 1132 | 0 | 0 | 52.1307 | -3.7837 | 2020-04-18 22:32:47 | Wales, United Kingdom | |
2022-09-18 | United Kingdom | Wales | 884792 | 10815 | 0 | 52.1307 | -3.7837 | 2022-09-19 04:21:49 | Wales, United Kingdom | |||
2021-10-10 | United Kingdom | Wales | 377734 | 8509 | 0 | 52.1307 | -3.7837 | 2021-10-11 04:21:31 | Wales, United Kingdom | |||
2020-09-07 | United Kingdom | Wales | 18514 | 2591 | 0 | 16917 | 52.1307 | -3.7837 | 2020-09-08 04:28:25 | Wales, United Kingdom | ||
2022-11-03 | United Kingdom | Wales | 889022 | 11034 | 0 | 52.1307 | -3.7837 | 2022-11-04 04:22:11 | Wales, United Kingdom | |||
2021-01-21 | United Kingdom | Wales | 185035 | 6516 | 0 | 180643 | 52.1307 | -3.7837 | 2021-01-22 05:22:10 | Wales, United Kingdom | ||
2020-07-26 | United Kingdom | Wales | 17125 | 2530 | 0 | 15576 | 52.1307 | -3.7837 | 2020-07-27 04:35:02 | Wales, United Kingdom | ||
2021-10-20 | United Kingdom | Wales | 408294 | 8638 | 0 | 52.1307 | -3.7837 | 2021-10-21 04:21:18 | Wales, United Kingdom | |||
2021-11-17 | United Kingdom | Wales | 479712 | 8974 | 0 | 52.1307 | -3.7837 | 2021-11-18 04:21:33 | Wales, United Kingdom | |||
2022-12-21 | United Kingdom | Wales | 891613 | 11108 | 0 | 52.1307 | -3.7837 | 2022-12-22 04:20:56 | Wales, United Kingdom | |||
2020-08-07 | United Kingdom | Wales | 17406 | 2570 | 0 | 15828 | 52.1307 | -3.7837 | 2020-08-08 04:34:53 | Wales, United Kingdom | ||
2022-02-02 | United Kingdom | Wales | 782388 | 9656 | 0 | 52.1307 | -3.7837 | 2022-02-03 04:21:21 | Wales, United Kingdom | |||
2022-05-02 | United Kingdom | Wales | 872384 | 10292 | 0 | 52.1307 | -3.7837 | 2022-05-03 04:21:00 | Wales, United Kingdom | |||
2021-10-07 | United Kingdom | Wales | 372029 | 8482 | 0 | 52.1307 | -3.7837 | 2021-10-08 04:21:25 | Wales, United Kingdom | |||
2021-02-19 | United Kingdom | Wales | 200989 | 7535 | 0 | 195784 | 52.1307 | -3.7837 | 2021-02-20 05:22:51 | Wales, United Kingdom | ||
2022-06-26 | United Kingdom | Wales | 876295 | 10448 | 0 | 52.1307 | -3.7837 | 2022-06-27 04:21:00 | Wales, United Kingdom | |||
2020-02-25 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-02-25T15:23:04 | ||||
2022-11-08 | United Kingdom | Wales | 889022 | 11053 | 0 | 52.1307 | -3.7837 | 2022-11-09 04:21:22 | Wales, United Kingdom | |||
2021-07-19 | United Kingdom | Wales | 232672 | 7958 | 0 | 227083 | 52.1307 | -3.7837 | 2021-07-20 04:21:48 | Wales, United Kingdom | ||
2022-11-25 | United Kingdom | Wales | 889924 | 11087 | 0 | 52.1307 | -3.7837 | 2022-11-26 04:21:11 | Wales, United Kingdom | |||
2021-10-14 | United Kingdom | Wales | 389152 | 8562 | 0 | 52.1307 | -3.7837 | 2021-10-15 04:21:26 | Wales, United Kingdom | |||
2021-11-06 | United Kingdom | Wales | 452440 | 8842 | 0 | 52.1307 | -3.7837 | 2021-11-07 04:21:53 | Wales, United Kingdom | |||
2022-04-02 | United Kingdom | Wales | 863544 | 10033 | 0 | 52.1307 | -3.7837 | 2022-04-03 04:20:48 | Wales, United Kingdom | |||
2022-12-17 | United Kingdom | Wales | 891613 | 11108 | 0 | 52.1307 | -3.7837 | 2022-12-18 04:21:03 | Wales, United Kingdom | |||
2021-08-14 | United Kingdom | Wales | 251048 | 8027 | 0 | 52.1307 | -3.7837 | 2021-08-15 04:21:41 | Wales, United Kingdom | |||
2021-08-19 | United Kingdom | Wales | 258155 | 8039 | 0 | 52.1307 | -3.7837 | 2021-08-20 04:21:33 | Wales, United Kingdom | |||
2022-10-15 | United Kingdom | Wales | 887192 | 10929 | 0 | 52.1307 | -3.7837 | 2022-10-16 04:22:39 | Wales, United Kingdom | |||
2020-04-21 | United Kingdom | Wales | 82604 | 0 | 1282 | 0 | 0 | 52.1307 | -3.7837 | 2020-04-21 23:30:50 | Wales, United Kingdom | |
2021-06-09 | United Kingdom | Wales | 213411 | 7934 | 0 | 207841 | 52.1307 | -3.7837 | 2021-06-10 04:23:17 | Wales, United Kingdom | ||
2020-07-04 | United Kingdom | Wales | 15875 | 2497 | 0 | 14345 | 52.1307 | -3.7837 | 2020-07-05 04:33:46 | Wales, United Kingdom | ||
2021-02-22 | United Kingdom | Wales | 202007 | 7592 | 0 | 196761 | 52.1307 | -3.7837 | 2021-02-23 05:23:41 | Wales, United Kingdom | ||
2021-10-27 | United Kingdom | Wales | 429731 | 8720 | 0 | 52.1307 | -3.7837 | 2021-10-28 04:22:08 | Wales, United Kingdom | |||
2022-10-26 | United Kingdom | Wales | 887935 | 10986 | 0 | 52.1307 | -3.7837 | 2022-10-27 04:22:01 | Wales, United Kingdom | |||
2022-12-15 | United Kingdom | Wales | 891613 | 11108 | 0 | 52.1307 | -3.7837 | 2022-12-16 04:21:01 | Wales, United Kingdom | |||
2020-09-12 | United Kingdom | Wales | 19228 | 2593 | 0 | 17631 | 52.1307 | -3.7837 | 2020-09-13 04:30:52 | Wales, United Kingdom | ||
2021-12-08 | United Kingdom | Wales | 527538 | 9162 | 0 | 52.1307 | -3.7837 | 2021-12-09 04:22:49 | Wales, United Kingdom | |||
2022-01-16 | United Kingdom | Wales | 740742 | 9496 | 0 | 52.1307 | -3.7837 | 2022-01-17 04:21:08 | Wales, United Kingdom | |||
2022-06-16 | United Kingdom | Wales | 875497 | 10423 | 0 | 52.1307 | -3.7837 | 2022-06-17 04:20:56 | Wales, United Kingdom | |||
2020-03-01 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-01T10:13:19 | ||||
2021-06-22 | United Kingdom | Wales | 215380 | 7935 | 0 | 209808 | 52.1307 | -3.7837 | 2021-06-23 04:21:46 | Wales, United Kingdom | ||
2020-02-06 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-02-06T23:23:02 | ||||
2021-10-29 | United Kingdom | Wales | 434956 | 8749 | 0 | 52.1307 | -3.7837 | 2021-10-30 04:22:03 | Wales, United Kingdom | |||
2020-06-06 | United Kingdom | Wales | 82604 | 0 | 2358 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-07 03:53:30 | Wales, United Kingdom | |
2022-02-25 | United Kingdom | Wales | 812699 | 9803 | 0 | 52.1307 | -3.7837 | 2022-02-26 04:21:12 | Wales, United Kingdom | |||
2021-07-13 | United Kingdom | Wales | 226428 | 7946 | 0 | 220848 | 52.1307 | -3.7837 | 2021-07-14 04:21:35 | Wales, United Kingdom | ||
2020-08-13 | United Kingdom | Wales | 17484 | 2578 | 0 | 15898 | 52.1307 | -3.7837 | 2020-08-14 04:51:19 | Wales, United Kingdom | ||
2020-04-05 | United Kingdom | Wales | 82604 | 0 | 385 | 0 | 0 | 52.1307 | -3.7837 | 2020-04-05 23:06:45 | Wales, United Kingdom | |
2021-08-08 | United Kingdom | Wales | 246205 | 8011 | 0 | 52.1307 | -3.7837 | 2021-08-09 04:21:24 | Wales, United Kingdom | |||
2022-07-01 | United Kingdom | Wales | 877490 | 10466 | 0 | 52.1307 | -3.7837 | 2022-07-02 04:21:16 | Wales, United Kingdom | |||
2021-10-19 | United Kingdom | Wales | 404844 | 8622 | 0 | 52.1307 | -3.7837 | 2021-10-20 04:21:00 | Wales, United Kingdom | |||
2021-09-23 | United Kingdom | Wales | 335611 | 8320 | 0 | 52.1307 | -3.7837 | 2021-09-24 04:21:44 | Wales, United Kingdom | |||
2021-04-09 | United Kingdom | Wales | 210219 | 7888 | 0 | 204691 | 52.1307 | -3.7837 | 2021-04-10 04:20:59 | Wales, United Kingdom | ||
2020-08-29 | United Kingdom | Wales | 17917 | 2587 | 0 | 16322 | 52.1307 | -3.7837 | 2020-08-30 04:28:22 | Wales, United Kingdom | ||
2021-02-08 | United Kingdom | Wales | 196670 | 7261 | 0 | 191669 | 52.1307 | -3.7837 | 2021-02-09 05:23:30 | Wales, United Kingdom | ||
2020-02-27 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-02-27T12:13:14 | ||||
2022-11-05 | United Kingdom | Wales | 889022 | 11042 | 0 | 52.1307 | -3.7837 | 2022-11-06 04:21:24 | Wales, United Kingdom | |||
2022-05-22 | United Kingdom | Wales | 874373 | 10373 | 0 | 52.1307 | -3.7837 | 2022-05-26 04:20:50 | Wales, United Kingdom | |||
2021-07-10 | United Kingdom | Wales | 223804 | 7942 | 0 | 218225 | 52.1307 | -3.7837 | 2021-07-11 04:21:43 | Wales, United Kingdom | ||
2022-07-12 | United Kingdom | Wales | 877490 | 10526 | 0 | 52.1307 | -3.7837 | 2022-07-13 04:20:58 | Wales, United Kingdom | |||
2021-10-13 | United Kingdom | Wales | 386516 | 8545 | 0 | 52.1307 | -3.7837 | 2021-10-14 04:21:29 | Wales, United Kingdom | |||
2021-03-31 | United Kingdom | Wales | 209345 | 7869 | 0 | 203838 | 52.1307 | -3.7837 | 2021-04-01 04:27:05 | Wales, United Kingdom | ||
2021-09-07 | United Kingdom | Wales | 296310 | 8151 | 0 | 52.1307 | -3.7837 | 2021-09-08 04:21:31 | Wales, United Kingdom | |||
2021-05-05 | United Kingdom | Wales | 211692 | 7916 | 0 | 206141 | 52.1307 | -3.7837 | 2021-05-06 04:20:38 | Wales, United Kingdom | ||
2021-08-09 | United Kingdom | Wales | 247569 | 8012 | 0 | 52.1307 | -3.7837 | 2021-08-10 04:21:27 | Wales, United Kingdom | |||
2021-10-22 | United Kingdom | Wales | 415829 | 8662 | 0 | 52.1307 | -3.7837 | 2021-10-23 04:21:32 | Wales, United Kingdom | |||
2020-03-09 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-09T14:33:03 | ||||
2022-05-13 | United Kingdom | Wales | 873751 | 10333 | 0 | 52.1307 | -3.7837 | 2022-05-14 04:20:48 | Wales, United Kingdom | |||
2020-08-11 | United Kingdom | Wales | 17463 | 2574 | 0 | 15884 | 52.1307 | -3.7837 | 2020-08-12 04:27:29 | Wales, United Kingdom | ||
2020-09-16 | United Kingdom | Wales | 19880 | 2599 | 0 | 18283 | 52.1307 | -3.7837 | 2020-09-17 04:22:00 | Wales, United Kingdom | ||
2022-07-21 | United Kingdom | Wales | 880358 | 10595 | 0 | 52.1307 | -3.7837 | 2022-07-22 04:21:15 | Wales, United Kingdom | |||
2022-07-30 | United Kingdom | Wales | 881293 | 10649 | 0 | 52.1307 | -3.7837 | 2022-07-31 04:21:02 | Wales, United Kingdom | |||
2020-11-23 | United Kingdom | Wales | 73233 | 3693 | 0 | 70848 | 52.1307 | -3.7837 | 2020-11-24 05:27:31 | Wales, United Kingdom | ||
2021-10-24 | United Kingdom | Wales | 418980 | 8686 | 0 | 52.1307 | -3.7837 | 2021-10-25 04:22:31 | Wales, United Kingdom | |||
2021-11-13 | United Kingdom | Wales | 468197 | 8935 | 0 | 52.1307 | -3.7837 | 2021-11-14 04:21:31 | Wales, United Kingdom | |||
2022-12-23 | United Kingdom | Wales | 892752 | 11108 | 0 | 52.1307 | -3.7837 | 2022-12-24 04:21:02 | Wales, United Kingdom | |||
2022-03-17 | United Kingdom | Wales | 835770 | 9896 | 0 | 52.1307 | -3.7837 | 2022-03-18 04:20:55 | Wales, United Kingdom | |||
2021-11-04 | United Kingdom | Wales | 450455 | 8826 | 0 | 52.1307 | -3.7837 | 2021-11-05 04:21:54 | Wales, United Kingdom | |||
2021-03-16 | United Kingdom | Wales | 206795 | 7816 | 0 | 201340 | 52.1307 | -3.7837 | 2021-03-17 05:25:07 | Wales, United Kingdom | ||
2021-09-29 | United Kingdom | Wales | 352939 | 8393 | 0 | 52.1307 | -3.7837 | 2021-09-30 04:21:20 | Wales, United Kingdom | |||
2022-11-01 | United Kingdom | Wales | 888547 | 11026 | 0 | 52.1307 | -3.7837 | 2022-11-02 04:22:09 | Wales, United Kingdom | |||
2021-11-12 | United Kingdom | Wales | 468197 | 8919 | 0 | 52.1307 | -3.7837 | 2021-11-13 04:21:38 | Wales, United Kingdom | |||
2022-12-04 | United Kingdom | Wales | 890293 | 11108 | 0 | 52.1307 | -3.7837 | 2022-12-05 04:20:58 | Wales, United Kingdom | |||
2021-11-20 | United Kingdom | Wales | 484744 | 9008 | 0 | 52.1307 | -3.7837 | 2021-11-21 04:22:13 | Wales, United Kingdom | |||
2021-05-22 | United Kingdom | Wales | 212388 | 7930 | 0 | 206824 | 52.1307 | -3.7837 | 2021-05-23 04:20:51 | Wales, United Kingdom | ||
2021-12-27 | United Kingdom | Wales | 582378 | 9270 | 0 | 52.1307 | -3.7837 | 2021-12-28 04:21:47 | Wales, United Kingdom | |||
2020-06-12 | United Kingdom | Wales | 14658 | 2401 | 0 | 13223 | 52.1307 | -3.7837 | 2020-06-13 03:33:14 | Wales, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;