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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
185697 | 185697 | 2021-02-21 | United Kingdom | Wales | 201688 | 7577 | 0 | 196451 | 52.1307 | -3.7837 | 2021-02-22 05:24:21 | Wales, United Kingdom | ||
745971 | 745971 | 2021-02-20 | United Kingdom | Wales | 201352 | 7556 | 0 | 196131 | 52.1307 | -3.7837 | 2021-02-21 05:24:33 | Wales, United Kingdom | ||
475069 | 475069 | 2021-02-19 | United Kingdom | Wales | 200989 | 7535 | 0 | 195784 | 52.1307 | -3.7837 | 2021-02-20 05:22:51 | Wales, United Kingdom | ||
1156778 | 1156778 | 2021-02-18 | United Kingdom | Wales | 200456 | 7509 | 0 | 195267 | 52.1307 | -3.7837 | 2021-02-19 05:24:16 | Wales, United Kingdom | ||
3604698 | 3604698 | 2021-02-17 | United Kingdom | Wales | 200166 | 7490 | 0 | 194991 | 52.1307 | -3.7837 | 2021-02-18 05:22:58 | Wales, United Kingdom | ||
3053833 | 3053833 | 2021-02-16 | United Kingdom | Wales | 199793 | 7472 | 0 | 194648 | 52.1307 | -3.7837 | 2021-02-17 05:23:10 | Wales, United Kingdom | ||
1341932 | 1341932 | 2021-02-15 | United Kingdom | Wales | 199518 | 7456 | 0 | 194381 | 52.1307 | -3.7837 | 2021-02-16 05:24:38 | Wales, United Kingdom | ||
2287083 | 2287083 | 2021-02-14 | United Kingdom | Wales | 199155 | 7440 | 0 | 194034 | 52.1307 | -3.7837 | 2021-02-15 05:24:49 | Wales, United Kingdom | ||
2681483 | 2681483 | 2021-02-13 | United Kingdom | Wales | 198761 | 7408 | 0 | 193655 | 52.1307 | -3.7837 | 2021-02-14 05:23:43 | Wales, United Kingdom | ||
3543116 | 3543116 | 2021-02-12 | United Kingdom | Wales | 198362 | 7377 | 0 | 193278 | 52.1307 | -3.7837 | 2021-02-13 05:22:12 | Wales, United Kingdom | ||
2641379 | 2641379 | 2021-02-11 | United Kingdom | Wales | 197754 | 7346 | 0 | 192695 | 52.1307 | -3.7837 | 2021-02-12 05:23:29 | Wales, United Kingdom | ||
3982234 | 3982234 | 2021-02-10 | United Kingdom | Wales | 197344 | 7319 | 0 | 192312 | 52.1307 | -3.7837 | 2021-02-11 05:23:55 | Wales, United Kingdom | ||
1531554 | 1531554 | 2021-02-09 | United Kingdom | Wales | 197021 | 7290 | 0 | 192010 | 52.1307 | -3.7837 | 2021-02-10 05:22:41 | Wales, United Kingdom | ||
617345 | 617345 | 2021-02-08 | United Kingdom | Wales | 196670 | 7261 | 0 | 191669 | 52.1307 | -3.7837 | 2021-02-09 05:23:30 | Wales, United Kingdom | ||
1676114 | 1676114 | 2021-02-07 | United Kingdom | Wales | 196060 | 7240 | 0 | 191071 | 52.1307 | -3.7837 | 2021-02-08 05:22:39 | Wales, United Kingdom | ||
978575 | 978575 | 2021-02-06 | United Kingdom | Wales | 195599 | 7212 | 0 | 190638 | 52.1307 | -3.7837 | 2021-02-07 05:23:00 | Wales, United Kingdom | ||
1591833 | 1591833 | 2021-02-05 | United Kingdom | Wales | 194924 | 7178 | 0 | 190012 | 52.1307 | -3.7837 | 2021-02-06 05:23:55 | Wales, United Kingdom | ||
794040 | 794040 | 2021-02-04 | United Kingdom | Wales | 194525 | 7145 | 0 | 189658 | 52.1307 | -3.7837 | 2021-02-05 05:22:38 | Wales, United Kingdom | ||
343932 | 343932 | 2021-02-03 | United Kingdom | Wales | 193981 | 7111 | 0 | 189149 | 52.1307 | -3.7837 | 2021-02-04 05:22:26 | Wales, United Kingdom | ||
1688158 | 1688158 | 2021-02-02 | United Kingdom | Wales | 193526 | 7067 | 0 | 188744 | 52.1307 | -3.7837 | 2021-02-03 05:22:52 | Wales, United Kingdom | ||
1680128 | 1680128 | 2021-02-01 | United Kingdom | Wales | 192912 | 7027 | 0 | 188137 | 52.1307 | -3.7837 | 2021-02-02 05:22:49 | Wales, United Kingdom | ||
1463416 | 1463416 | 2021-01-31 | United Kingdom | Wales | 192282 | 6989 | 0 | 187528 | 52.1307 | -3.7837 | 2021-02-01 05:22:53 | Wales, United Kingdom | ||
2215324 | 2215324 | 2021-01-30 | United Kingdom | Wales | 191677 | 6962 | 0 | 186957 | 52.1307 | -3.7837 | 2021-01-31 05:22:42 | Wales, United Kingdom | ||
1900811 | 1900811 | 2021-01-29 | United Kingdom | Wales | 190940 | 6924 | 0 | 186245 | 52.1307 | -3.7837 | 2021-01-30 05:22:49 | Wales, United Kingdom | ||
2485627 | 2485627 | 2021-01-28 | United Kingdom | Wales | 190394 | 6862 | 0 | 185728 | 52.1307 | -3.7837 | 2021-01-29 05:22:23 | Wales, United Kingdom | ||
3157262 | 3157262 | 2021-01-27 | United Kingdom | Wales | 189689 | 6818 | 0 | 185079 | 52.1307 | -3.7837 | 2021-01-28 05:22:24 | Wales, United Kingdom | ||
15997 | 15997 | 2021-01-26 | United Kingdom | Wales | 189152 | 6781 | 0 | 184591 | 52.1307 | -3.7837 | 2021-01-27 05:23:41 | Wales, United Kingdom | ||
2571321 | 2571321 | 2021-01-25 | United Kingdom | Wales | 188583 | 6725 | 0 | 184030 | 52.1307 | -3.7837 | 2021-01-26 05:22:02 | Wales, United Kingdom | ||
1762953 | 1762953 | 2021-01-24 | United Kingdom | Wales | 187711 | 6688 | 0 | 183181 | 52.1307 | -3.7837 | 2021-01-25 05:22:16 | Wales, United Kingdom | ||
2430560 | 2430560 | 2021-01-23 | United Kingdom | Wales | 186915 | 6626 | 0 | 182429 | 52.1307 | -3.7837 | 2021-01-24 05:22:35 | Wales, United Kingdom | ||
2470462 | 2470462 | 2021-01-22 | United Kingdom | Wales | 185836 | 6569 | 0 | 181377 | 52.1307 | -3.7837 | 2021-01-23 05:22:03 | Wales, United Kingdom | ||
439013 | 439013 | 2021-01-21 | United Kingdom | Wales | 185035 | 6516 | 0 | 180643 | 52.1307 | -3.7837 | 2021-01-22 05:22:10 | Wales, United Kingdom | ||
1097744 | 1097744 | 2021-01-20 | United Kingdom | Wales | 183882 | 6460 | 0 | 179536 | 52.1307 | -3.7837 | 2021-01-21 05:22:01 | Wales, United Kingdom | ||
911834 | 911834 | 2021-01-19 | United Kingdom | Wales | 182599 | 6406 | 0 | 178297 | 52.1307 | -3.7837 | 2021-01-20 05:21:54 | Wales, United Kingdom | ||
240897 | 240897 | 2021-01-18 | United Kingdom | Wales | 181493 | 6352 | 0 | 177199 | 52.1307 | -3.7837 | 2021-01-19 05:22:15 | Wales, United Kingdom | ||
3507014 | 3507014 | 2021-01-17 | United Kingdom | Wales | 180161 | 6291 | 0 | 175887 | 52.1307 | -3.7837 | 2021-01-18 05:22:34 | Wales, United Kingdom | ||
3105097 | 3105097 | 2021-01-16 | United Kingdom | Wales | 178989 | 6245 | 0 | 174763 | 52.1307 | -3.7837 | 2021-01-17 05:22:17 | Wales, United Kingdom | ||
3519059 | 3519059 | 2021-01-15 | United Kingdom | Wales | 177864 | 6171 | 0 | 173693 | 52.1307 | -3.7837 | 2021-01-16 05:22:40 | Wales, United Kingdom | ||
3883231 | 3883231 | 2021-01-14 | United Kingdom | Wales | 176056 | 6104 | 0 | 171939 | 52.1307 | -3.7837 | 2021-01-15 05:22:24 | Wales, United Kingdom | ||
3311858 | 3311858 | 2021-01-13 | United Kingdom | Wales | 174412 | 6028 | 0 | 170349 | 52.1307 | -3.7837 | 2021-01-14 05:22:32 | Wales, United Kingdom | ||
778003 | 778003 | 2021-01-12 | United Kingdom | Wales | 172879 | 5960 | 0 | 168882 | 52.1307 | -3.7837 | 2021-01-13 05:22:15 | Wales, United Kingdom | ||
193724 | 193724 | 2021-01-11 | United Kingdom | Wales | 171547 | 5897 | 0 | 167566 | 52.1307 | -3.7837 | 2021-01-12 05:22:15 | Wales, United Kingdom | ||
2629527 | 2629527 | 2021-01-10 | United Kingdom | Wales | 169754 | 5814 | 0 | 165790 | 52.1307 | -3.7837 | 2021-01-11 05:21:50 | Wales, United Kingdom | ||
3903615 | 3903615 | 2021-01-09 | United Kingdom | Wales | 168094 | 5751 | 0 | 164175 | 52.1307 | -3.7837 | 2021-01-10 05:22:12 | Wales, United Kingdom | ||
157638 | 157638 | 2021-01-08 | United Kingdom | Wales | 165721 | 5697 | 0 | 161864 | 52.1307 | -3.7837 | 2021-01-09 05:22:18 | Wales, United Kingdom | ||
2545062 | 2545062 | 2021-01-07 | United Kingdom | Wales | 163234 | 5631 | 0 | 159433 | 52.1307 | -3.7837 | 2021-01-08 05:22:42 | Wales, United Kingdom | ||
2868371 | 2868371 | 2021-01-06 | United Kingdom | Wales | 161516 | 5572 | 0 | 157778 | 52.1307 | -3.7837 | 2021-01-07 05:22:03 | Wales, United Kingdom | ||
3037958 | 3037958 | 2021-01-05 | United Kingdom | Wales | 159278 | 5508 | 0 | 155616 | 52.1307 | -3.7837 | 2021-01-06 05:22:16 | Wales, United Kingdom | ||
1065503 | 1065503 | 2021-01-04 | United Kingdom | Wales | 157209 | 5451 | 0 | 153564 | 52.1307 | -3.7837 | 2021-01-05 05:21:49 | Wales, United Kingdom | ||
3234106 | 3234106 | 2021-01-03 | United Kingdom | Wales | 155311 | 5400 | 0 | 151691 | 52.1307 | -3.7837 | 2021-01-04 05:22:02 | Wales, United Kingdom | ||
2231175 | 2231175 | 2021-01-02 | United Kingdom | Wales | 151300 | 5341 | 0 | 147736 | 52.1307 | -3.7837 | 2021-01-03 05:22:52 | Wales, United Kingdom | ||
1140539 | 1140539 | 2021-01-01 | United Kingdom | Wales | 148537 | 5301 | 0 | 145043 | 52.1307 | -3.7837 | 2021-01-02 05:22:33 | Wales, United Kingdom | ||
3699145 | 3699145 | 2020-12-31 | United Kingdom | Wales | 148537 | 5237 | 0 | 145043 | 52.1307 | -3.7837 | 2021-01-01 05:23:07 | Wales, United Kingdom | ||
1013960 | 1013960 | 2020-12-30 | United Kingdom | Wales | 146706 | 5174 | 0 | 143277 | 52.1307 | -3.7837 | 2020-12-31 05:22:49 | Wales, United Kingdom | ||
769975 | 769975 | 2020-12-29 | United Kingdom | Wales | 144425 | 5119 | 0 | 141009 | 52.1307 | -3.7837 | 2020-12-30 05:22:34 | Wales, United Kingdom | ||
3765239 | 3765239 | 2020-12-28 | United Kingdom | Wales | 141915 | 5065 | 0 | 138532 | 52.1307 | -3.7837 | 2020-12-29 05:22:37 | Wales, United Kingdom | ||
3781559 | 3781559 | 2020-12-27 | United Kingdom | Wales | 139642 | 5004 | 0 | 136274 | 52.1307 | -3.7837 | 2020-12-28 05:22:06 | Wales, United Kingdom | ||
2227164 | 2227164 | 2020-12-26 | United Kingdom | Wales | 135500 | 4956 | 0 | 132202 | 52.1307 | -3.7837 | 2020-12-27 05:22:55 | Wales, United Kingdom | ||
205911 | 205911 | 2020-12-25 | United Kingdom | Wales | 133263 | 4907 | 0 | 130000 | 52.1307 | -3.7837 | 2020-12-26 05:22:28 | Wales, United Kingdom | ||
3695134 | 3695134 | 2020-12-24 | United Kingdom | Wales | 133263 | 4862 | 0 | 130000 | 52.1307 | -3.7837 | 2020-12-25 05:22:48 | Wales, United Kingdom | ||
2410486 | 2410486 | 2020-12-23 | United Kingdom | Wales | 131102 | 4808 | 0 | 127902 | 52.1307 | -3.7837 | 2020-12-24 05:23:04 | Wales, United Kingdom | ||
3773532 | 3773532 | 2020-12-22 | United Kingdom | Wales | 128089 | 4757 | 0 | 124940 | 52.1307 | -3.7837 | 2020-12-23 05:22:03 | Wales, United Kingdom | ||
931348 | 931348 | 2020-12-21 | United Kingdom | Wales | 125329 | 4712 | 0 | 122204 | 52.1307 | -3.7837 | 2020-12-22 05:22:33 | Wales, United Kingdom | ||
2123369 | 2123369 | 2020-12-20 | United Kingdom | Wales | 122766 | 4669 | 0 | 119651 | 52.1307 | -3.7837 | 2020-12-21 05:27:58 | Wales, United Kingdom | ||
2934876 | 2934876 | 2020-12-19 | United Kingdom | Wales | 120432 | 4626 | 0 | 117386 | 52.1307 | -3.7837 | 2020-12-20 05:27:32 | Wales, United Kingdom | ||
1904822 | 1904822 | 2020-12-18 | United Kingdom | Wales | 117367 | 4582 | 0 | 114356 | 52.1307 | -3.7837 | 2020-12-19 05:27:52 | Wales, United Kingdom | ||
2131648 | 2131648 | 2020-12-17 | United Kingdom | Wales | 114566 | 4516 | 0 | 111593 | 52.1307 | -3.7837 | 2020-12-18 05:28:18 | Wales, United Kingdom | ||
3153248 | 3153248 | 2020-12-16 | United Kingdom | Wales | 103098 | 4466 | 0 | 100178 | 52.1307 | -3.7837 | 2020-12-17 05:28:12 | Wales, United Kingdom | ||
1038029 | 1038029 | 2020-12-15 | United Kingdom | Wales | 102568 | 4416 | 0 | 99677 | 52.1307 | -3.7837 | 2020-12-16 05:28:04 | Wales, United Kingdom | ||
1754923 | 1754923 | 2020-12-14 | United Kingdom | Wales | 101953 | 4365 | 0 | 99071 | 52.1307 | -3.7837 | 2020-12-15 05:26:38 | Wales, United Kingdom | ||
3851443 | 3851443 | 2020-12-13 | United Kingdom | Wales | 100725 | 4330 | 0 | 97876 | 52.1307 | -3.7837 | 2020-12-14 05:26:27 | Wales, United Kingdom | ||
849225 | 849225 | 2020-12-12 | United Kingdom | Wales | 100725 | 4298 | 0 | 97876 | 52.1307 | -3.7837 | 2020-12-13 05:27:20 | Wales, United Kingdom | ||
864332 | 864332 | 2020-12-11 | United Kingdom | Wales | 98232 | 4255 | 0 | 95414 | 52.1307 | -3.7837 | 2020-12-12 05:26:19 | Wales, United Kingdom | ||
1603874 | 1603874 | 2020-12-10 | United Kingdom | Wales | 95998 | 4225 | 0 | 93209 | 52.1307 | -3.7837 | 2020-12-11 05:26:59 | Wales, United Kingdom | ||
2978883 | 2978883 | 2020-12-09 | United Kingdom | Wales | 94030 | 4184 | 0 | 91274 | 52.1307 | -3.7837 | 2020-12-10 05:26:19 | Wales, United Kingdom | ||
1822443 | 1822443 | 2020-12-08 | United Kingdom | Wales | 91792 | 4155 | 0 | 89067 | 52.1307 | -3.7837 | 2020-12-09 05:28:01 | Wales, United Kingdom | ||
2351079 | 2351079 | 2020-12-07 | United Kingdom | Wales | 91013 | 4124 | 0 | 88302 | 52.1307 | -3.7837 | 2020-12-08 05:27:42 | Wales, United Kingdom | ||
1009949 | 1009949 | 2020-12-06 | United Kingdom | Wales | 88992 | 4090 | 0 | 86283 | 52.1307 | -3.7837 | 2020-12-07 05:26:14 | Wales, United Kingdom | ||
1635958 | 1635958 | 2020-12-05 | United Kingdom | Wales | 87077 | 4061 | 0 | 84382 | 52.1307 | -3.7837 | 2020-12-06 05:26:18 | Wales, United Kingdom | ||
3863486 | 3863486 | 2020-12-04 | United Kingdom | Wales | 85432 | 4034 | 0 | 82761 | 52.1307 | -3.7837 | 2020-12-05 05:27:36 | Wales, United Kingdom | ||
78744 | 78744 | 2020-12-03 | United Kingdom | Wales | 83961 | 4000 | 0 | 81323 | 52.1307 | -3.7837 | 2020-12-04 05:27:27 | Wales, United Kingdom | ||
741956 | 741956 | 2020-12-02 | United Kingdom | Wales | 82489 | 3958 | 0 | 79875 | 52.1307 | -3.7837 | 2020-12-03 05:28:22 | Wales, United Kingdom | ||
2541050 | 2541050 | 2020-12-01 | United Kingdom | Wales | 81009 | 3930 | 0 | 78446 | 52.1307 | -3.7837 | 2020-12-02 05:27:41 | Wales, United Kingdom | ||
1587819 | 1587819 | 2020-11-30 | United Kingdom | Wales | 80342 | 3904 | 0 | 77802 | 52.1307 | -3.7837 | 2020-12-01 05:26:18 | Wales, United Kingdom | ||
3570222 | 3570222 | 2020-11-29 | United Kingdom | Wales | 79540 | 3880 | 0 | 77001 | 52.1307 | -3.7837 | 2020-11-30 05:26:13 | Wales, United Kingdom | ||
2938887 | 2938887 | 2020-11-28 | United Kingdom | Wales | 78536 | 3845 | 0 | 76013 | 52.1307 | -3.7837 | 2020-11-29 05:25:55 | Wales, United Kingdom | ||
395890 | 395890 | 2020-11-27 | United Kingdom | Wales | 77091 | 3807 | 0 | 74597 | 52.1307 | -3.7837 | 2020-11-28 05:25:50 | Wales, United Kingdom | ||
927337 | 927337 | 2020-11-26 | United Kingdom | Wales | 75986 | 3780 | 0 | 73512 | 52.1307 | -3.7837 | 2020-11-27 05:26:53 | Wales, United Kingdom | ||
1976242 | 1976242 | 2020-11-25 | United Kingdom | Wales | 74735 | 3742 | 0 | 72289 | 52.1307 | -3.7837 | 2020-11-26 05:27:44 | Wales, United Kingdom | ||
1353973 | 1353973 | 2020-11-24 | United Kingdom | Wales | 73828 | 3723 | 0 | 71422 | 52.1307 | -3.7837 | 2020-11-25 05:27:20 | Wales, United Kingdom | ||
681967 | 681967 | 2020-11-23 | United Kingdom | Wales | 73233 | 3693 | 0 | 70848 | 52.1307 | -3.7837 | 2020-11-24 05:27:31 | Wales, United Kingdom | ||
3193643 | 3193643 | 2020-11-22 | United Kingdom | Wales | 72341 | 3661 | 0 | 69965 | 52.1307 | -3.7837 | 2020-11-23 05:25:26 | Wales, United Kingdom | ||
3840137 | 3840137 | 2020-11-21 | United Kingdom | Wales | 71533 | 3625 | 0 | 69168 | 52.1307 | -3.7837 | 2020-11-22 05:25:45 | Wales, United Kingdom | ||
2705165 | 2705165 | 2020-11-20 | United Kingdom | Wales | 70517 | 3585 | 0 | 68179 | 52.1307 | -3.7837 | 2020-11-21 05:25:51 | Wales, United Kingdom | ||
825225 | 825225 | 2020-11-19 | United Kingdom | Wales | 69497 | 3557 | 0 | 67190 | 52.1307 | -3.7837 | 2020-11-20 05:26:28 | Wales, United Kingdom | ||
126359 | 126359 | 2020-11-18 | United Kingdom | Wales | 68449 | 3524 | 0 | 66165 | 52.1307 | -3.7837 | 2020-11-19 05:25:23 | Wales, United Kingdom | ||
3342247 | 3342247 | 2020-11-17 | United Kingdom | Wales | 67811 | 3496 | 0 | 65568 | 52.1307 | -3.7837 | 2020-11-18 05:40:31 | Wales, United Kingdom | ||
3173292 | 3173292 | 2020-11-16 | United Kingdom | Wales | 67106 | 3463 | 0 | 64897 | 52.1307 | -3.7837 | 2020-11-17 05:25:54 | Wales, United Kingdom | ||
2883860 | 2883860 | 2020-11-15 | United Kingdom | Wales | 66214 | 3437 | 0 | 64007 | 52.1307 | -3.7837 | 2020-11-16 05:25:57 | Wales, United Kingdom | ||
2918838 | 2918838 | 2020-11-14 | United Kingdom | Wales | 64881 | 3409 | 0 | 62690 | 52.1307 | -3.7837 | 2020-11-15 05:26:53 | 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]);