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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2732651 | 2732651 | 2020-09-15 | United Kingdom | Wales | 19681 | 2596 | 0 | 18084 | 52.1307 | -3.7837 | 2020-09-16 04:22:53 | Wales, United Kingdom | ||
347923 | 347923 | 2020-09-14 | United Kingdom | Wales | 19573 | 2594 | 0 | 17976 | 52.1307 | -3.7837 | 2020-09-15 03:22:50 | Wales, United Kingdom | ||
2872362 | 2872362 | 2020-09-13 | United Kingdom | Wales | 19390 | 2594 | 0 | 17793 | 52.1307 | -3.7837 | 2020-09-14 04:26:00 | Wales, United Kingdom | ||
550401 | 550401 | 2020-09-12 | United Kingdom | Wales | 19228 | 2593 | 0 | 17631 | 52.1307 | -3.7837 | 2020-09-13 04:30:52 | Wales, United Kingdom | ||
1448230 | 1448230 | 2020-09-11 | United Kingdom | Wales | 19064 | 2593 | 0 | 17467 | 52.1307 | -3.7837 | 2020-09-12 04:25:05 | Wales, United Kingdom | ||
1176831 | 1176831 | 2020-09-10 | United Kingdom | Wales | 18931 | 2592 | 0 | 17334 | 52.1307 | -3.7837 | 2020-09-11 04:46:23 | Wales, United Kingdom | ||
2175196 | 2175196 | 2020-09-09 | United Kingdom | Wales | 18829 | 2592 | 0 | 17232 | 52.1307 | -3.7837 | 2020-09-10 04:29:01 | Wales, United Kingdom | ||
1247405 | 1247405 | 2020-09-08 | United Kingdom | Wales | 18664 | 2591 | 0 | 17067 | 52.1307 | -3.7837 | 2020-09-09 04:28:48 | Wales, United Kingdom | ||
430984 | 430984 | 2020-09-07 | United Kingdom | Wales | 18514 | 2591 | 0 | 16917 | 52.1307 | -3.7837 | 2020-09-08 04:28:25 | Wales, United Kingdom | ||
3165269 | 3165269 | 2020-09-06 | United Kingdom | Wales | 18381 | 2590 | 0 | 16784 | 52.1307 | -3.7837 | 2020-09-07 04:28:30 | Wales, United Kingdom | ||
817224 | 817224 | 2020-09-05 | United Kingdom | Wales | 18283 | 2590 | 0 | 16686 | 52.1307 | -3.7837 | 2020-09-06 04:28:33 | Wales, United Kingdom | ||
2665424 | 2665424 | 2020-09-04 | United Kingdom | Wales | 18206 | 2590 | 0 | 16610 | 52.1307 | -3.7837 | 2020-09-05 04:28:19 | Wales, United Kingdom | ||
1357964 | 1357964 | 2020-09-03 | United Kingdom | Wales | 18155 | 2590 | 0 | 16559 | 52.1307 | -3.7837 | 2020-09-04 04:28:26 | Wales, United Kingdom | ||
1109201 | 1109201 | 2020-09-02 | United Kingdom | Wales | 18105 | 2590 | 0 | 16509 | 52.1307 | -3.7837 | 2020-09-03 04:28:22 | Wales, United Kingdom | ||
2063530 | 2063530 | 2020-09-01 | United Kingdom | Wales | 18063 | 2590 | 0 | 16467 | 52.1307 | -3.7837 | 2020-09-02 04:28:25 | Wales, United Kingdom | ||
197715 | 197715 | 2020-08-31 | United Kingdom | Wales | 18012 | 2589 | 0 | 16417 | 52.1307 | -3.7837 | 2020-09-01 04:28:31 | Wales, United Kingdom | ||
3935670 | 3935670 | 2020-08-30 | United Kingdom | Wales | 17973 | 2588 | 0 | 16378 | 52.1307 | -3.7837 | 2020-08-31 04:28:27 | Wales, United Kingdom | ||
613332 | 613332 | 2020-08-29 | United Kingdom | Wales | 17917 | 2587 | 0 | 16322 | 52.1307 | -3.7837 | 2020-08-30 04:28:22 | Wales, United Kingdom | ||
1526827 | 1526827 | 2020-08-28 | United Kingdom | Wales | 17877 | 2587 | 0 | 16282 | 52.1307 | -3.7837 | 2020-08-29 04:28:19 | Wales, United Kingdom | ||
2513828 | 2513828 | 2020-08-27 | United Kingdom | Wales | 17843 | 2587 | 0 | 16248 | 52.1307 | -3.7837 | 2020-08-28 04:28:11 | Wales, United Kingdom | ||
2000288 | 2000288 | 2020-08-26 | United Kingdom | Wales | 17808 | 2587 | 0 | 16214 | 52.1307 | -3.7837 | 2020-08-27 04:28:15 | Wales, United Kingdom | ||
3566212 | 3566212 | 2020-08-25 | United Kingdom | Wales | 17774 | 2587 | 0 | 16181 | 52.1307 | -3.7837 | 2020-08-26 04:28:11 | Wales, United Kingdom | ||
2994916 | 2994916 | 2020-08-24 | United Kingdom | Wales | 17746 | 2586 | 0 | 16153 | 52.1307 | -3.7837 | 2020-08-25 04:28:02 | Wales, United Kingdom | ||
2219311 | 2219311 | 2020-08-23 | United Kingdom | Wales | 17727 | 2586 | 0 | 16135 | 52.1307 | -3.7837 | 2020-08-24 04:27:56 | Wales, United Kingdom | ||
2303093 | 2303093 | 2020-08-22 | United Kingdom | Wales | 17707 | 2586 | 0 | 16117 | 52.1307 | -3.7837 | 2020-08-23 04:27:48 | Wales, United Kingdom | ||
1483199 | 1483199 | 2020-08-21 | United Kingdom | Wales | 17673 | 2586 | 0 | 16084 | 52.1307 | -3.7837 | 2020-08-22 04:27:49 | Wales, United Kingdom | ||
3487948 | 3487948 | 2020-08-20 | United Kingdom | Wales | 17639 | 2585 | 0 | 16050 | 52.1307 | -3.7837 | 2020-08-21 04:27:41 | Wales, United Kingdom | ||
209897 | 209897 | 2020-08-19 | United Kingdom | Wales | 17620 | 2585 | 0 | 16031 | 52.1307 | -3.7837 | 2020-08-20 04:27:43 | Wales, United Kingdom | ||
3181649 | 3181649 | 2020-08-18 | United Kingdom | Wales | 17599 | 2584 | 0 | 16010 | 52.1307 | -3.7837 | 2020-08-19 04:27:00 | Wales, United Kingdom | ||
841253 | 841253 | 2020-08-17 | United Kingdom | Wales | 17575 | 2582 | 0 | 15986 | 52.1307 | -3.7837 | 2020-08-18 04:27:56 | Wales, United Kingdom | ||
1559609 | 1559609 | 2020-08-16 | United Kingdom | Wales | 17561 | 2581 | 0 | 15975 | 52.1307 | -3.7837 | 2020-08-17 04:27:20 | Wales, United Kingdom | ||
149611 | 149611 | 2020-08-15 | United Kingdom | Wales | 17543 | 2580 | 0 | 15957 | 52.1307 | -3.7837 | 2020-08-16 04:27:42 | Wales, United Kingdom | ||
1615886 | 1615886 | 2020-08-14 | United Kingdom | Wales | 17484 | 2580 | 0 | 15898 | 52.1307 | -3.7837 | 2020-08-15 04:27:31 | Wales, United Kingdom | ||
586470 | 586470 | 2020-08-13 | United Kingdom | Wales | 17484 | 2578 | 0 | 15898 | 52.1307 | -3.7837 | 2020-08-14 04:51:19 | Wales, United Kingdom | ||
3535087 | 3535087 | 2020-08-12 | United Kingdom | Wales | 17484 | 2576 | 0 | 15898 | 52.1307 | -3.7837 | 2020-08-13 04:29:15 | Wales, United Kingdom | ||
662677 | 662677 | 2020-08-11 | United Kingdom | Wales | 17463 | 2574 | 0 | 15884 | 52.1307 | -3.7837 | 2020-08-12 04:27:29 | Wales, United Kingdom | ||
1920662 | 1920662 | 2020-08-10 | United Kingdom | Wales | 17463 | 2574 | 0 | 15884 | 52.1307 | -3.7837 | 2020-08-11 04:35:08 | Wales, United Kingdom | ||
3923471 | 3923471 | 2020-08-09 | United Kingdom | Wales | 17451 | 2572 | 0 | 15872 | 52.1307 | -3.7837 | 2020-08-10 04:34:55 | Wales, United Kingdom | ||
371639 | 371639 | 2020-08-08 | United Kingdom | Wales | 17425 | 2572 | 0 | 15846 | 52.1307 | -3.7837 | 2020-08-09 04:34:54 | Wales, United Kingdom | ||
458823 | 458823 | 2020-08-07 | United Kingdom | Wales | 17406 | 2570 | 0 | 15828 | 52.1307 | -3.7837 | 2020-08-08 04:34:53 | Wales, United Kingdom | ||
3612508 | 3612508 | 2020-08-06 | United Kingdom | Wales | 17389 | 2565 | 0 | 15818 | 52.1307 | -3.7837 | 2020-08-07 04:35:11 | Wales, United Kingdom | ||
3793338 | 3793338 | 2020-08-05 | United Kingdom | Wales | 17374 | 2563 | 0 | 15806 | 52.1307 | -3.7837 | 2020-08-06 04:35:02 | Wales, United Kingdom | ||
98574 | 98574 | 2020-08-04 | United Kingdom | Wales | 17361 | 2560 | 0 | 15795 | 52.1307 | -3.7837 | 2020-08-05 04:34:43 | Wales, United Kingdom | ||
2740457 | 2740457 | 2020-08-03 | United Kingdom | Wales | 17339 | 2556 | 0 | 15774 | 52.1307 | -3.7837 | 2020-08-04 04:41:59 | Wales, United Kingdom | ||
2808209 | 2808209 | 2020-08-02 | United Kingdom | Wales | 17315 | 2553 | 0 | 15750 | 52.1307 | -3.7837 | 2020-08-03 04:34:35 | Wales, United Kingdom | ||
753777 | 753777 | 2020-08-01 | United Kingdom | Wales | 17279 | 2551 | 0 | 15717 | 52.1307 | -3.7837 | 2020-08-02 04:34:47 | Wales, United Kingdom | ||
3264942 | 3264942 | 2020-07-31 | United Kingdom | Wales | 17258 | 2547 | 0 | 15698 | 52.1307 | -3.7837 | 2020-08-01 04:36:27 | Wales, United Kingdom | ||
1928648 | 1928648 | 2020-07-30 | United Kingdom | Wales | 17232 | 2542 | 0 | 15678 | 52.1307 | -3.7837 | 2020-07-31 04:35:18 | Wales, United Kingdom | ||
2958816 | 2958816 | 2020-07-29 | United Kingdom | Wales | 17223 | 2539 | 0 | 15669 | 52.1307 | -3.7837 | 2020-07-30 04:35:05 | Wales, United Kingdom | ||
3185433 | 3185433 | 2020-07-28 | United Kingdom | Wales | 17170 | 2534 | 0 | 15621 | 52.1307 | -3.7837 | 2020-07-29 04:35:11 | Wales, United Kingdom | ||
177483 | 177483 | 2020-07-27 | United Kingdom | Wales | 17170 | 2532 | 0 | 15621 | 52.1307 | -3.7837 | 2020-07-28 04:58:43 | Wales, United Kingdom | ||
442796 | 442796 | 2020-07-26 | United Kingdom | Wales | 17125 | 2530 | 0 | 15576 | 52.1307 | -3.7837 | 2020-07-27 04:35:02 | Wales, United Kingdom | ||
1503039 | 1503039 | 2020-07-25 | United Kingdom | Wales | 17105 | 2528 | 0 | 15557 | 52.1307 | -3.7837 | 2020-07-26 04:35:00 | Wales, United Kingdom | ||
2564010 | 2564010 | 2020-07-24 | United Kingdom | Wales | 17075 | 2526 | 0 | 15527 | 52.1307 | -3.7837 | 2020-07-25 04:47:39 | Wales, United Kingdom | ||
62212 | 62212 | 2020-07-23 | United Kingdom | Wales | 17030 | 2525 | 0 | 15482 | 52.1307 | -3.7837 | 2020-07-24 05:30:40 | Wales, United Kingdom | ||
845030 | 845030 | 2020-07-22 | United Kingdom | Wales | 16987 | 2524 | 0 | 15439 | 52.1307 | -3.7837 | 2020-07-23 05:15:04 | Wales, United Kingdom | ||
1707769 | 1707769 | 2020-07-21 | United Kingdom | Wales | 16965 | 2524 | 0 | 15418 | 52.1307 | -3.7837 | 2020-07-22 04:34:42 | Wales, United Kingdom | ||
327260 | 327260 | 2020-07-20 | United Kingdom | Wales | 16943 | 2523 | 0 | 15396 | 52.1307 | -3.7837 | 2020-07-21 04:38:46 | Wales, United Kingdom | ||
122165 | 122165 | 2020-07-19 | United Kingdom | Wales | 16928 | 2523 | 0 | 15381 | 52.1307 | -3.7837 | 2020-07-20 05:34:40 | Wales, United Kingdom | ||
3205554 | 3205554 | 2020-07-18 | United Kingdom | Wales | 16897 | 2523 | 0 | 15351 | 52.1307 | -3.7837 | 2020-07-19 04:34:58 | Wales, United Kingdom | ||
2708857 | 2708857 | 2020-07-17 | United Kingdom | Wales | 16887 | 2523 | 0 | 15341 | 52.1307 | -3.7837 | 2020-07-18 04:34:45 | Wales, United Kingdom | ||
367666 | 367666 | 2020-07-16 | United Kingdom | Wales | 16871 | 2522 | 0 | 15326 | 52.1307 | -3.7837 | 2020-07-17 04:34:50 | Wales, United Kingdom | ||
2748334 | 2748334 | 2020-07-15 | United Kingdom | Wales | 16854 | 2520 | 0 | 15309 | 52.1307 | -3.7837 | 2020-07-16 04:44:59 | Wales, United Kingdom | ||
2158978 | 2158978 | 2020-07-14 | United Kingdom | Wales | 16836 | 2520 | 0 | 15293 | 52.1307 | -3.7837 | 2020-07-15 04:34:39 | Wales, United Kingdom | ||
3491619 | 3491619 | 2020-07-13 | United Kingdom | Wales | 15973 | 2519 | 0 | 14432 | 52.1307 | -3.7837 | 2020-07-14 04:34:46 | Wales, United Kingdom | ||
3737882 | 3737882 | 2020-07-12 | United Kingdom | Wales | 15962 | 2517 | 0 | 14421 | 52.1307 | -3.7837 | 2020-07-13 04:43:04 | Wales, United Kingdom | ||
3436277 | 3436277 | 2020-07-11 | United Kingdom | Wales | 15946 | 2515 | 0 | 14405 | 52.1307 | -3.7837 | 2020-07-12 04:34:30 | Wales, United Kingdom | ||
3237775 | 3237775 | 2020-07-10 | United Kingdom | Wales | 15939 | 2514 | 0 | 14399 | 52.1307 | -3.7837 | 2020-07-11 04:34:26 | Wales, United Kingdom | ||
1005760 | 1005760 | 2020-07-09 | United Kingdom | Wales | 15929 | 2513 | 0 | 14389 | 52.1307 | -3.7837 | 2020-07-10 04:34:24 | Wales, United Kingdom | ||
2222975 | 2222975 | 2020-07-08 | United Kingdom | Wales | 15913 | 2509 | 0 | 14375 | 52.1307 | -3.7837 | 2020-07-09 04:34:23 | Wales, United Kingdom | ||
887584 | 887584 | 2020-07-07 | United Kingdom | Wales | 15900 | 2507 | 0 | 14366 | 52.1307 | -3.7837 | 2020-07-08 05:33:48 | Wales, United Kingdom | ||
2685144 | 2685144 | 2020-07-06 | United Kingdom | Wales | 15898 | 2505 | 0 | 14367 | 52.1307 | -3.7837 | 2020-07-07 04:34:00 | Wales, United Kingdom | ||
415609 | 415609 | 2020-07-05 | United Kingdom | Wales | 15890 | 2502 | 0 | 14359 | 52.1307 | -3.7837 | 2020-07-06 04:33:57 | Wales, United Kingdom | ||
530171 | 530171 | 2020-07-04 | United Kingdom | Wales | 15875 | 2497 | 0 | 14345 | 52.1307 | -3.7837 | 2020-07-05 04:33:46 | Wales, United Kingdom | ||
2234832 | 2234832 | 2020-07-03 | United Kingdom | Wales | 15841 | 2494 | 0 | 14316 | 52.1307 | -3.7837 | 2020-07-04 04:33:51 | Wales, United Kingdom | ||
3045627 | 3045627 | 2020-07-02 | United Kingdom | Wales | 15815 | 2494 | 0 | 14291 | 52.1307 | -3.7837 | 2020-07-03 04:33:54 | Wales, United Kingdom | ||
303318 | 303318 | 2020-07-01 | United Kingdom | Wales | 15775 | 2489 | 0 | 14259 | 52.1307 | -3.7837 | 2020-07-02 04:33:46 | Wales, United Kingdom | ||
2974696 | 2974696 | 2020-06-30 | United Kingdom | Wales | 15743 | 2485 | 0 | 14233 | 52.1307 | -3.7837 | 2020-07-01 04:33:52 | Wales, United Kingdom | ||
2633173 | 2633173 | 2020-06-29 | United Kingdom | Wales | 15717 | 2479 | 0 | 14210 | 52.1307 | -3.7837 | 2020-06-30 04:33:48 | Wales, United Kingdom | ||
2306736 | 2306736 | 2020-06-28 | United Kingdom | Wales | 15602 | 2476 | 0 | 14098 | 52.1307 | -3.7837 | 2020-06-29 04:33:44 | Wales, United Kingdom | ||
2040071 | 2040071 | 2020-06-27 | United Kingdom | Wales | 15577 | 2472 | 0 | 14075 | 52.1307 | -3.7837 | 2020-06-28 04:34:04 | Wales, United Kingdom | ||
1136352 | 1136352 | 2020-06-26 | United Kingdom | Wales | 15531 | 2466 | 0 | 14034 | 52.1307 | -3.7837 | 2020-06-27 04:33:35 | Wales, United Kingdom | ||
2625339 | 2625339 | 2020-06-25 | United Kingdom | Wales | 15466 | 2462 | 0 | 13969 | 52.1307 | -3.7837 | 2020-06-26 04:33:43 | Wales, United Kingdom | ||
2700979 | 2700979 | 2020-06-24 | United Kingdom | Wales | 15341 | 2454 | 0 | 13850 | 52.1307 | -3.7837 | 2020-06-25 05:26:54 | Wales, United Kingdom | ||
1522664 | 1522664 | 2020-06-23 | United Kingdom | Wales | 15295 | 2452 | 0 | 13812 | 52.1307 | -3.7837 | 2020-06-24 04:33:28 | Wales, United Kingdom | ||
1510858 | 1510858 | 2020-06-22 | United Kingdom | Wales | 15197 | 2448 | 0 | 13719 | 52.1307 | -3.7837 | 2020-06-23 04:33:22 | Wales, United Kingdom | ||
3249597 | 3249597 | 2020-06-21 | United Kingdom | Wales | 15126 | 2446 | 0 | 13649 | 52.1307 | -3.7837 | 2020-06-22 04:33:20 | Wales, United Kingdom | ||
2438190 | 2438190 | 2020-06-20 | United Kingdom | Wales | 15026 | 2442 | 0 | 13550 | 52.1307 | -3.7837 | 2020-06-21 04:33:19 | Wales, United Kingdom | ||
1691768 | 1691768 | 2020-06-19 | United Kingdom | Wales | 15001 | 2439 | 0 | 13526 | 52.1307 | -3.7837 | 2020-06-20 04:33:19 | Wales, United Kingdom | ||
3682917 | 3682917 | 2020-06-18 | United Kingdom | Wales | 14970 | 2432 | 0 | 13499 | 52.1307 | -3.7837 | 2020-06-19 04:33:17 | Wales, United Kingdom | ||
1196120 | 1196120 | 2020-06-17 | United Kingdom | Wales | 14922 | 2432 | 0 | 13456 | 52.1307 | -3.7837 | 2020-06-18 04:33:18 | Wales, United Kingdom | ||
2386883 | 2386883 | 2020-06-16 | United Kingdom | Wales | 14869 | 2429 | 0 | 13413 | 52.1307 | -3.7837 | 2020-06-17 04:33:21 | Wales, United Kingdom | ||
287446 | 287446 | 2020-06-15 | United Kingdom | Wales | 14804 | 2421 | 0 | 13356 | 52.1307 | -3.7837 | 2020-06-16 04:33:09 | Wales, United Kingdom | ||
1837397 | 1837397 | 2020-06-14 | United Kingdom | Wales | 14742 | 2416 | 0 | 13298 | 52.1307 | -3.7837 | 2020-06-15 03:33:14 | Wales, United Kingdom | ||
3061449 | 3061449 | 2020-06-13 | United Kingdom | Wales | 14703 | 2408 | 0 | 13262 | 52.1307 | -3.7837 | 2020-06-14 03:33:15 | Wales, United Kingdom | ||
737769 | 737769 | 2020-06-12 | United Kingdom | Wales | 14658 | 2401 | 0 | 13223 | 52.1307 | -3.7837 | 2020-06-13 03:33:14 | Wales, United Kingdom | ||
1273739 | 1273739 | 2020-06-11 | United Kingdom | Wales | 14581 | 2397 | 0 | 13156 | 52.1307 | -3.7837 | 2020-06-12 05:09:52 | Wales, United Kingdom | ||
2864399 | 2864399 | 2020-06-10 | United Kingdom | Wales | 82604 | 0 | 2392 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-11 03:33:41 | Wales, United Kingdom | |
1211218 | 1211218 | 2020-06-09 | United Kingdom | Wales | 82604 | 0 | 2383 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-10 04:07:00 | Wales, United Kingdom | |
217645 | 217645 | 2020-06-08 | United Kingdom | Wales | 82604 | 0 | 2380 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-09 03:33:03 | 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]);