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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1972261 | 1972261 | 2022-08-13 | United Kingdom | Wales | 882554 | 10706 | 0 | 52.1307 | -3.7837 | 2022-08-14 04:20:55 | Wales, United Kingdom | |||
2892070 | 2892070 | 2022-08-12 | United Kingdom | Wales | 882554 | 10699 | 0 | 52.1307 | -3.7837 | 2022-08-13 04:20:52 | Wales, United Kingdom | |||
3911675 | 3911675 | 2022-08-11 | United Kingdom | Wales | 882554 | 10695 | 0 | 52.1307 | -3.7837 | 2022-08-12 04:20:54 | Wales, United Kingdom | |||
1349992 | 1349992 | 2022-08-10 | United Kingdom | Wales | 882554 | 10693 | 0 | 52.1307 | -3.7837 | 2022-08-11 04:20:49 | Wales, United Kingdom | |||
1089747 | 1089747 | 2022-08-09 | United Kingdom | Wales | 882004 | 10687 | 0 | 52.1307 | -3.7837 | 2022-08-10 04:20:57 | Wales, United Kingdom | |||
3547162 | 3547162 | 2022-08-08 | United Kingdom | Wales | 882004 | 10684 | 0 | 52.1307 | -3.7837 | 2022-08-09 04:20:34 | Wales, United Kingdom | |||
1073565 | 1073565 | 2022-08-07 | United Kingdom | Wales | 882004 | 10683 | 0 | 52.1307 | -3.7837 | 2022-08-08 04:21:08 | Wales, United Kingdom | |||
1944153 | 1944153 | 2022-08-06 | United Kingdom | Wales | 882004 | 10678 | 0 | 52.1307 | -3.7837 | 2022-08-07 04:20:54 | Wales, United Kingdom | |||
883952 | 883952 | 2022-08-05 | United Kingdom | Wales | 882004 | 10676 | 0 | 52.1307 | -3.7837 | 2022-08-06 04:20:56 | Wales, United Kingdom | |||
2012363 | 2012363 | 2022-08-04 | United Kingdom | Wales | 882004 | 10669 | 0 | 52.1307 | -3.7837 | 2022-08-05 04:20:52 | Wales, United Kingdom | |||
1101790 | 1101790 | 2022-08-03 | United Kingdom | Wales | 882004 | 10666 | 0 | 52.1307 | -3.7837 | 2022-08-04 04:20:58 | Wales, United Kingdom | |||
1408715 | 1408715 | 2022-08-02 | United Kingdom | Wales | 881293 | 10664 | 0 | 52.1307 | -3.7837 | 2022-08-03 04:20:59 | Wales, United Kingdom | |||
3620753 | 3620753 | 2022-08-01 | United Kingdom | Wales | 881293 | 10659 | 0 | 52.1307 | -3.7837 | 2022-08-02 04:20:53 | Wales, United Kingdom | |||
3875233 | 3875233 | 2022-07-31 | United Kingdom | Wales | 881293 | 10652 | 0 | 52.1307 | -3.7837 | 2022-08-01 04:21:03 | Wales, United Kingdom | |||
677987 | 677987 | 2022-07-30 | United Kingdom | Wales | 881293 | 10649 | 0 | 52.1307 | -3.7837 | 2022-07-31 04:21:02 | Wales, United Kingdom | |||
1787186 | 1787186 | 2022-07-29 | United Kingdom | Wales | 881293 | 10648 | 0 | 52.1307 | -3.7837 | 2022-07-30 04:20:42 | Wales, United Kingdom | |||
1069549 | 1069549 | 2022-07-28 | United Kingdom | Wales | 881293 | 10644 | 0 | 52.1307 | -3.7837 | 2022-07-29 04:20:45 | Wales, United Kingdom | |||
2339068 | 2339068 | 2022-07-27 | United Kingdom | Wales | 881293 | 10639 | 0 | 52.1307 | -3.7837 | 2022-07-28 04:20:56 | Wales, United Kingdom | |||
1491258 | 1491258 | 2022-07-26 | United Kingdom | Wales | 880358 | 10631 | 0 | 52.1307 | -3.7837 | 2022-07-27 04:21:04 | Wales, United Kingdom | |||
2597704 | 2597704 | 2022-07-25 | United Kingdom | Wales | 880358 | 10623 | 0 | 52.1307 | -3.7837 | 2022-07-26 04:20:58 | Wales, United Kingdom | |||
899819 | 899819 | 2022-07-24 | United Kingdom | Wales | 880358 | 10616 | 0 | 52.1307 | -3.7837 | 2022-07-25 04:20:51 | Wales, United Kingdom | |||
94813 | 94813 | 2022-07-23 | United Kingdom | Wales | 880358 | 10611 | 0 | 52.1307 | -3.7837 | 2022-07-24 04:20:47 | Wales, United Kingdom | |||
903835 | 903835 | 2022-07-22 | United Kingdom | Wales | 880358 | 10605 | 0 | 52.1307 | -3.7837 | 2022-07-23 04:20:53 | Wales, United Kingdom | |||
673971 | 673971 | 2022-07-21 | United Kingdom | Wales | 880358 | 10595 | 0 | 52.1307 | -3.7837 | 2022-07-22 04:21:15 | Wales, United Kingdom | |||
1611934 | 1611934 | 2022-07-20 | United Kingdom | Wales | 880358 | 10590 | 0 | 52.1307 | -3.7837 | 2022-07-21 04:21:10 | Wales, United Kingdom | |||
962567 | 962567 | 2022-07-19 | United Kingdom | Wales | 878929 | 10585 | 0 | 52.1307 | -3.7837 | 2022-07-20 04:20:59 | Wales, United Kingdom | |||
3213954 | 3213954 | 2022-07-18 | United Kingdom | Wales | 878929 | 10569 | 0 | 52.1307 | -3.7837 | 2022-07-19 04:20:58 | Wales, United Kingdom | |||
3409129 | 3409129 | 2022-07-17 | United Kingdom | Wales | 878929 | 10558 | 0 | 52.1307 | -3.7837 | 2022-07-18 04:20:59 | Wales, United Kingdom | |||
2155329 | 2155329 | 2022-07-16 | United Kingdom | Wales | 878929 | 10551 | 0 | 52.1307 | -3.7837 | 2022-07-17 04:21:15 | Wales, United Kingdom | |||
2422562 | 2422562 | 2022-07-15 | United Kingdom | Wales | 878929 | 10545 | 0 | 52.1307 | -3.7837 | 2022-07-16 04:21:05 | Wales, United Kingdom | |||
3432637 | 3432637 | 2022-07-14 | United Kingdom | Wales | 878929 | 10541 | 0 | 52.1307 | -3.7837 | 2022-07-15 04:20:53 | Wales, United Kingdom | |||
3113157 | 3113157 | 2022-07-13 | United Kingdom | Wales | 878929 | 10532 | 0 | 52.1307 | -3.7837 | 2022-07-14 04:20:57 | Wales, United Kingdom | |||
633580 | 633580 | 2022-07-12 | United Kingdom | Wales | 877490 | 10526 | 0 | 52.1307 | -3.7837 | 2022-07-13 04:20:58 | Wales, United Kingdom | |||
1215223 | 1215223 | 2022-07-11 | United Kingdom | Wales | 877490 | 10516 | 0 | 52.1307 | -3.7837 | 2022-07-12 04:20:51 | Wales, United Kingdom | |||
2792705 | 2792705 | 2022-07-10 | United Kingdom | Wales | 877490 | 10508 | 0 | 52.1307 | -3.7837 | 2022-07-11 04:20:46 | Wales, United Kingdom | |||
145658 | 145658 | 2022-07-09 | United Kingdom | Wales | 877490 | 10496 | 0 | 52.1307 | -3.7837 | 2022-07-10 04:20:54 | Wales, United Kingdom | |||
1420758 | 1420758 | 2022-07-08 | United Kingdom | Wales | 877490 | 10492 | 0 | 52.1307 | -3.7837 | 2022-07-09 04:20:59 | Wales, United Kingdom | |||
2744683 | 2744683 | 2022-07-07 | United Kingdom | Wales | 877490 | 10488 | 0 | 52.1307 | -3.7837 | 2022-07-08 04:20:56 | Wales, United Kingdom | |||
1203478 | 1203478 | 2022-07-06 | United Kingdom | Wales | 877490 | 10485 | 0 | 52.1307 | -3.7837 | 2022-07-07 04:20:55 | Wales, United Kingdom | |||
3970221 | 3970221 | 2022-07-05 | United Kingdom | Wales | 877490 | 10480 | 0 | 52.1307 | -3.7837 | 2022-07-06 04:20:58 | Wales, United Kingdom | |||
3081732 | 3081732 | 2022-07-04 | United Kingdom | Wales | 877490 | 10477 | 0 | 52.1307 | -3.7837 | 2022-07-05 04:20:45 | Wales, United Kingdom | |||
1771014 | 1771014 | 2022-07-03 | United Kingdom | Wales | 877490 | 10474 | 0 | 52.1307 | -3.7837 | 2022-07-04 04:20:54 | Wales, United Kingdom | |||
3369000 | 3369000 | 2022-07-02 | United Kingdom | Wales | 877490 | 10471 | 0 | 52.1307 | -3.7837 | 2022-07-03 04:20:59 | Wales, United Kingdom | |||
597329 | 597329 | 2022-07-01 | United Kingdom | Wales | 877490 | 10466 | 0 | 52.1307 | -3.7837 | 2022-07-02 04:21:16 | Wales, United Kingdom | |||
3943730 | 3943730 | 2022-06-30 | United Kingdom | Wales | 877490 | 10461 | 0 | 52.1307 | -3.7837 | 2022-07-01 04:21:10 | Wales, United Kingdom | |||
2493688 | 2493688 | 2022-06-29 | United Kingdom | Wales | 876295 | 10456 | 0 | 52.1307 | -3.7837 | 2022-06-30 04:21:01 | Wales, United Kingdom | |||
2243070 | 2243070 | 2022-06-28 | United Kingdom | Wales | 876295 | 10451 | 0 | 52.1307 | -3.7837 | 2022-06-29 04:20:59 | Wales, United Kingdom | |||
2151312 | 2151312 | 2022-06-27 | United Kingdom | Wales | 876295 | 10449 | 0 | 52.1307 | -3.7837 | 2022-06-28 04:20:58 | Wales, United Kingdom | |||
479113 | 479113 | 2022-06-26 | United Kingdom | Wales | 876295 | 10448 | 0 | 52.1307 | -3.7837 | 2022-06-27 04:21:00 | Wales, United Kingdom | |||
942488 | 942488 | 2022-06-25 | United Kingdom | Wales | 876295 | 10446 | 0 | 52.1307 | -3.7837 | 2022-06-26 04:21:02 | Wales, United Kingdom | |||
3350308 | 3350308 | 2022-06-24 | United Kingdom | Wales | 876295 | 10443 | 0 | 52.1307 | -3.7837 | 2022-06-25 04:20:57 | Wales, United Kingdom | |||
1652049 | 1652049 | 2022-06-23 | United Kingdom | Wales | 876295 | 10440 | 0 | 52.1307 | -3.7837 | 2022-06-24 04:20:58 | Wales, United Kingdom | |||
2191284 | 2191284 | 2022-06-22 | United Kingdom | Wales | 875497 | 10435 | 0 | 52.1307 | -3.7837 | 2022-06-23 04:20:55 | Wales, United Kingdom | |||
169715 | 169715 | 2022-06-21 | United Kingdom | Wales | 875497 | 10433 | 0 | 52.1307 | -3.7837 | 2022-06-22 04:20:54 | Wales, United Kingdom | |||
1766998 | 1766998 | 2022-06-20 | United Kingdom | Wales | 875497 | 10430 | 0 | 52.1307 | -3.7837 | 2022-06-21 04:20:56 | Wales, United Kingdom | |||
3273184 | 3273184 | 2022-06-19 | United Kingdom | Wales | 875497 | 10428 | 0 | 52.1307 | -3.7837 | 2022-06-20 04:21:01 | Wales, United Kingdom | |||
3401096 | 3401096 | 2022-06-18 | United Kingdom | Wales | 875497 | 10427 | 0 | 52.1307 | -3.7837 | 2022-06-19 04:20:51 | Wales, United Kingdom | |||
2314973 | 2314973 | 2022-06-17 | United Kingdom | Wales | 875497 | 10425 | 0 | 52.1307 | -3.7837 | 2022-06-18 04:21:10 | Wales, United Kingdom | |||
562477 | 562477 | 2022-06-16 | United Kingdom | Wales | 875497 | 10423 | 0 | 52.1307 | -3.7837 | 2022-06-17 04:20:56 | Wales, United Kingdom | |||
3986279 | 3986279 | 2022-06-15 | United Kingdom | Wales | 875029 | 10416 | 0 | 52.1307 | -3.7837 | 2022-06-16 04:20:55 | Wales, United Kingdom | |||
950520 | 950520 | 2022-06-14 | United Kingdom | Wales | 875029 | 10416 | 0 | 52.1307 | -3.7837 | 2022-06-15 04:20:54 | Wales, United Kingdom | |||
2982928 | 2982928 | 2022-06-13 | United Kingdom | Wales | 875029 | 10415 | 0 | 52.1307 | -3.7837 | 2022-06-14 04:20:52 | Wales, United Kingdom | |||
2239054 | 2239054 | 2022-06-12 | United Kingdom | Wales | 875029 | 10411 | 0 | 52.1307 | -3.7837 | 2022-06-13 04:21:14 | Wales, United Kingdom | |||
3145252 | 3145252 | 2022-06-11 | United Kingdom | Wales | 875029 | 10409 | 0 | 52.1307 | -3.7837 | 2022-06-12 04:20:53 | Wales, United Kingdom | |||
1948168 | 1948168 | 2022-06-10 | United Kingdom | Wales | 875029 | 10409 | 0 | 52.1307 | -3.7837 | 2022-06-11 04:21:01 | Wales, United Kingdom | |||
3161307 | 3161307 | 2022-06-09 | United Kingdom | Wales | 875029 | 10408 | 0 | 52.1307 | -3.7837 | 2022-06-10 04:20:55 | Wales, United Kingdom | |||
1424774 | 1424774 | 2022-06-08 | United Kingdom | Wales | 874686 | 10406 | 0 | 52.1307 | -3.7837 | 2022-06-09 04:20:54 | Wales, United Kingdom | |||
3729888 | 3729888 | 2022-06-07 | United Kingdom | Wales | 874686 | 10404 | 0 | 52.1307 | -3.7837 | 2022-06-08 04:20:55 | Wales, United Kingdom | |||
3891290 | 3891290 | 2022-06-06 | United Kingdom | Wales | 874686 | 10402 | 0 | 52.1307 | -3.7837 | 2022-06-07 04:21:08 | Wales, United Kingdom | |||
3511059 | 3511059 | 2022-06-05 | United Kingdom | Wales | 874425 | 10400 | 0 | 52.1307 | -3.7837 | 2022-06-06 04:20:57 | Wales, United Kingdom | |||
3531136 | 3531136 | 2022-06-04 | United Kingdom | Wales | 874425 | 10398 | 0 | 52.1307 | -3.7837 | 2022-06-05 04:20:55 | Wales, United Kingdom | |||
3137222 | 3137222 | 2022-06-03 | United Kingdom | Wales | 874425 | 10398 | 0 | 52.1307 | -3.7837 | 2022-06-04 04:20:58 | Wales, United Kingdom | |||
3582297 | 3582297 | 2022-06-02 | United Kingdom | Wales | 874425 | 10396 | 0 | 52.1307 | -3.7837 | 2022-06-03 04:20:58 | Wales, United Kingdom | |||
974590 | 974590 | 2022-06-01 | United Kingdom | Wales | 874425 | 10395 | 0 | 52.1307 | -3.7837 | 2022-06-02 05:20:39 | Wales, United Kingdom | |||
232897 | 232897 | 2022-05-31 | United Kingdom | Wales | 874425 | 10393 | 0 | 52.1307 | -3.7837 | 2022-06-01 04:20:55 | Wales, United Kingdom | |||
3189662 | 3189662 | 2022-05-30 | United Kingdom | Wales | 874425 | 10391 | 0 | 52.1307 | -3.7837 | 2022-05-31 04:20:51 | Wales, United Kingdom | |||
3201811 | 3201811 | 2022-05-29 | United Kingdom | Wales | 874425 | 10388 | 0 | 52.1307 | -3.7837 | 2022-05-30 04:20:50 | Wales, United Kingdom | |||
2728689 | 2728689 | 2022-05-28 | United Kingdom | Wales | 874425 | 10386 | 0 | 52.1307 | -3.7837 | 2022-05-29 04:20:53 | Wales, United Kingdom | |||
1317870 | 1317870 | 2022-05-27 | United Kingdom | Wales | 874425 | 10385 | 0 | 52.1307 | -3.7837 | 2022-05-28 04:21:07 | Wales, United Kingdom | |||
1853662 | 1853662 | 2022-05-26 | United Kingdom | Wales | 874425 | 10385 | 0 | 52.1307 | -3.7837 | 2022-05-27 04:20:56 | Wales, United Kingdom | |||
2051538 | 2051538 | 2022-05-25 | United Kingdom | Wales | 874373 | 10384 | 0 | 52.1307 | -3.7837 | 2022-05-26 04:20:50 | Wales, United Kingdom | |||
3002976 | 3002976 | 2022-05-24 | United Kingdom | Wales | 874322 | 10381 | 0 | 52.1307 | -3.7837 | 2022-05-25 04:20:56 | Wales, United Kingdom | |||
3596697 | 3596697 | 2022-05-23 | United Kingdom | Wales | 874232 | 10378 | 0 | 52.1307 | -3.7837 | 2022-05-24 04:20:57 | Wales, United Kingdom | |||
625549 | 625549 | 2022-05-22 | United Kingdom | Wales | 874373 | 10373 | 0 | 52.1307 | -3.7837 | 2022-05-26 04:20:50 | Wales, United Kingdom | |||
1113245 | 1113245 | 2022-05-21 | United Kingdom | Wales | 874178 | 10367 | 0 | 52.1307 | -3.7837 | 2022-05-22 04:20:52 | Wales, United Kingdom | |||
1172869 | 1172869 | 2022-05-20 | United Kingdom | Wales | 874178 | 10361 | 0 | 52.1307 | -3.7837 | 2022-05-21 04:20:58 | Wales, United Kingdom | |||
3899632 | 3899632 | 2022-05-19 | United Kingdom | Wales | 874105 | 10359 | 0 | 52.1307 | -3.7837 | 2022-05-20 04:20:57 | Wales, United Kingdom | |||
1188416 | 1188416 | 2022-05-18 | United Kingdom | Wales | 874034 | 10352 | 0 | 52.1307 | -3.7837 | 2022-05-19 04:20:54 | Wales, United Kingdom | |||
3586313 | 3586313 | 2022-05-17 | United Kingdom | Wales | 873963 | 10348 | 0 | 52.1307 | -3.7837 | 2022-05-18 04:20:50 | Wales, United Kingdom | |||
1507270 | 1507270 | 2022-05-16 | United Kingdom | Wales | 873825 | 10342 | 0 | 52.1307 | -3.7837 | 2022-05-17 04:20:59 | Wales, United Kingdom | |||
2087629 | 2087629 | 2022-05-15 | United Kingdom | Wales | 873751 | 10340 | 0 | 52.1307 | -3.7837 | 2022-05-16 04:20:47 | Wales, United Kingdom | |||
3358339 | 3358339 | 2022-05-14 | United Kingdom | Wales | 873751 | 10336 | 0 | 52.1307 | -3.7837 | 2022-05-15 04:20:53 | Wales, United Kingdom | |||
661984 | 661984 | 2022-05-13 | United Kingdom | Wales | 873751 | 10333 | 0 | 52.1307 | -3.7837 | 2022-05-14 04:20:48 | Wales, United Kingdom | |||
2537067 | 2537067 | 2022-05-12 | United Kingdom | Wales | 873670 | 10330 | 0 | 52.1307 | -3.7837 | 2022-05-13 04:20:51 | Wales, United Kingdom | |||
3448513 | 3448513 | 2022-05-11 | United Kingdom | Wales | 873569 | 10327 | 0 | 52.1307 | -3.7837 | 2022-05-12 04:20:54 | Wales, United Kingdom | |||
3539130 | 3539130 | 2022-05-10 | United Kingdom | Wales | 873470 | 10323 | 0 | 52.1307 | -3.7837 | 2022-05-11 04:20:48 | Wales, United Kingdom | |||
225665 | 225665 | 2022-05-09 | United Kingdom | Wales | 873202 | 10319 | 0 | 52.1307 | -3.7837 | 2022-05-10 04:20:50 | Wales, United Kingdom | |||
2335050 | 2335050 | 2022-05-08 | United Kingdom | Wales | 873102 | 10316 | 0 | 52.1307 | -3.7837 | 2022-05-09 04:20:54 | Wales, United Kingdom | |||
364012 | 364012 | 2022-05-07 | United Kingdom | Wales | 873102 | 10313 | 0 | 52.1307 | -3.7837 | 2022-05-08 04:20:49 | Wales, United Kingdom | |||
1401363 | 1401363 | 2022-05-06 | United Kingdom | Wales | 873102 | 10305 | 0 | 52.1307 | -3.7837 | 2022-05-07 04:21:09 | 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]);