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 day
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-05-01 | United Kingdom | Wales | 82604 | 0 | 1681 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-02 02:32:27 | Wales, United Kingdom | |
2020-05-02 | United Kingdom | Wales | 82604 | 0 | 1716 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-03 02:32:28 | Wales, United Kingdom | |
2020-05-03 | United Kingdom | Wales | 82604 | 0 | 1743 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-04 02:32:28 | Wales, United Kingdom | |
2020-05-04 | United Kingdom | Wales | 82604 | 0 | 1781 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-05 02:32:34 | Wales, United Kingdom | |
2020-05-05 | United Kingdom | Wales | 82604 | 0 | 1812 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-06 02:32:31 | Wales, United Kingdom | |
2020-05-06 | United Kingdom | Wales | 82604 | 0 | 1849 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-07 02:32:28 | Wales, United Kingdom | |
2020-05-07 | United Kingdom | Wales | 82604 | 0 | 1875 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-08 02:32:32 | Wales, United Kingdom | |
2020-05-08 | United Kingdom | Wales | 82604 | 0 | 1894 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-09 02:32:35 | Wales, United Kingdom | |
2020-05-09 | United Kingdom | Wales | 82604 | 0 | 1911 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-10 02:32:30 | Wales, United Kingdom | |
2020-05-10 | United Kingdom | Wales | 82604 | 0 | 1930 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-11 02:32:30 | Wales, United Kingdom | |
2020-05-11 | United Kingdom | Wales | 82604 | 0 | 1951 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-12 03:32:27 | Wales, United Kingdom | |
2020-05-12 | United Kingdom | Wales | 82604 | 0 | 1970 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-13 03:32:26 | Wales, United Kingdom | |
2020-05-13 | United Kingdom | Wales | 82604 | 0 | 1992 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-14 03:32:28 | Wales, United Kingdom | |
2020-05-14 | United Kingdom | Wales | 82604 | 0 | 2019 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-15 02:33:02 | Wales, United Kingdom | |
2020-05-15 | United Kingdom | Wales | 82604 | 0 | 2038 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-16 02:32:19 | Wales, United Kingdom | |
2020-05-16 | United Kingdom | Wales | 82604 | 0 | 2065 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-17 02:32:32 | Wales, United Kingdom | |
2020-05-17 | United Kingdom | Wales | 82604 | 0 | 2082 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-18 02:32:21 | Wales, United Kingdom | |
2020-05-18 | United Kingdom | Wales | 82604 | 0 | 2101 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-19 02:32:18 | Wales, United Kingdom | |
2020-05-19 | United Kingdom | Wales | 82604 | 0 | 2116 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-20 02:32:19 | Wales, United Kingdom | |
2020-05-20 | United Kingdom | Wales | 82604 | 0 | 2129 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-21 02:32:48 | Wales, United Kingdom | |
2020-05-21 | United Kingdom | Wales | 82604 | 0 | 2145 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-22 02:36:51 | Wales, United Kingdom | |
2020-05-22 | United Kingdom | Wales | 82604 | 0 | 2164 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-23 02:32:42 | Wales, United Kingdom | |
2020-05-23 | United Kingdom | Wales | 82604 | 0 | 2174 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-24 02:32:43 | Wales, United Kingdom | |
2020-05-24 | United Kingdom | Wales | 82604 | 0 | 2195 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-25 02:32:44 | Wales, United Kingdom | |
2020-05-25 | United Kingdom | Wales | 82604 | 0 | 2209 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-26 02:32:35 | Wales, United Kingdom | |
2020-05-26 | United Kingdom | Wales | 82604 | 0 | 2225 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-27 02:32:31 | Wales, United Kingdom | |
2020-05-27 | United Kingdom | Wales | 82604 | 0 | 2243 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-28 02:32:31 | Wales, United Kingdom | |
2020-05-28 | United Kingdom | Wales | 82604 | 0 | 2263 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-29 02:32:50 | Wales, United Kingdom | |
2020-05-29 | United Kingdom | Wales | 82604 | 0 | 2277 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-30 02:32:48 | Wales, United Kingdom | |
2020-05-30 | United Kingdom | Wales | 82604 | 0 | 2294 | 0 | 0 | 52.1307 | -3.7837 | 2020-05-31 02:32:45 | Wales, United Kingdom | |
2020-05-31 | United Kingdom | Wales | 82604 | 0 | 2300 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-01 02:32:46 | Wales, United Kingdom | |
2020-06-01 | United Kingdom | Wales | 82604 | 0 | 2311 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-02 02:33:08 | Wales, United Kingdom | |
2020-06-02 | United Kingdom | Wales | 82604 | 0 | 2319 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-03 02:33:13 | Wales, United Kingdom | |
2020-06-03 | United Kingdom | Wales | 82604 | 0 | 2328 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-04 02:33:14 | Wales, United Kingdom | |
2020-06-04 | United Kingdom | Wales | 82604 | 0 | 2340 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-05 02:33:06 | Wales, United Kingdom | |
2020-06-05 | United Kingdom | Wales | 82604 | 0 | 2348 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-06 02:33:00 | 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 | |
2020-06-07 | United Kingdom | Wales | 82604 | 0 | 2371 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-08 03:33:22 | Wales, United Kingdom | |
2020-06-08 | United Kingdom | Wales | 82604 | 0 | 2380 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-09 03:33:03 | Wales, United Kingdom | |
2020-06-09 | United Kingdom | Wales | 82604 | 0 | 2383 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-10 04:07:00 | Wales, United Kingdom | |
2020-06-10 | United Kingdom | Wales | 82604 | 0 | 2392 | 0 | 0 | 52.1307 | -3.7837 | 2020-06-11 03:33:41 | Wales, United Kingdom | |
2020-06-11 | United Kingdom | Wales | 14581 | 2397 | 0 | 13156 | 52.1307 | -3.7837 | 2020-06-12 05:09:52 | 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 | ||
2020-06-13 | United Kingdom | Wales | 14703 | 2408 | 0 | 13262 | 52.1307 | -3.7837 | 2020-06-14 03:33:15 | Wales, United Kingdom | ||
2020-06-14 | United Kingdom | Wales | 14742 | 2416 | 0 | 13298 | 52.1307 | -3.7837 | 2020-06-15 03:33:14 | Wales, United Kingdom | ||
2020-06-15 | United Kingdom | Wales | 14804 | 2421 | 0 | 13356 | 52.1307 | -3.7837 | 2020-06-16 04:33:09 | Wales, United Kingdom | ||
2020-06-16 | United Kingdom | Wales | 14869 | 2429 | 0 | 13413 | 52.1307 | -3.7837 | 2020-06-17 04:33:21 | Wales, United Kingdom | ||
2020-06-17 | United Kingdom | Wales | 14922 | 2432 | 0 | 13456 | 52.1307 | -3.7837 | 2020-06-18 04:33:18 | Wales, United Kingdom | ||
2020-06-18 | United Kingdom | Wales | 14970 | 2432 | 0 | 13499 | 52.1307 | -3.7837 | 2020-06-19 04:33:17 | Wales, United Kingdom | ||
2020-06-19 | United Kingdom | Wales | 15001 | 2439 | 0 | 13526 | 52.1307 | -3.7837 | 2020-06-20 04:33:19 | Wales, United Kingdom | ||
2020-06-20 | United Kingdom | Wales | 15026 | 2442 | 0 | 13550 | 52.1307 | -3.7837 | 2020-06-21 04:33:19 | Wales, United Kingdom | ||
2020-06-21 | United Kingdom | Wales | 15126 | 2446 | 0 | 13649 | 52.1307 | -3.7837 | 2020-06-22 04:33:20 | Wales, United Kingdom | ||
2020-06-22 | United Kingdom | Wales | 15197 | 2448 | 0 | 13719 | 52.1307 | -3.7837 | 2020-06-23 04:33:22 | Wales, United Kingdom | ||
2020-06-23 | United Kingdom | Wales | 15295 | 2452 | 0 | 13812 | 52.1307 | -3.7837 | 2020-06-24 04:33:28 | Wales, United Kingdom | ||
2020-06-24 | United Kingdom | Wales | 15341 | 2454 | 0 | 13850 | 52.1307 | -3.7837 | 2020-06-25 05:26:54 | Wales, United Kingdom | ||
2020-06-25 | United Kingdom | Wales | 15466 | 2462 | 0 | 13969 | 52.1307 | -3.7837 | 2020-06-26 04:33:43 | Wales, United Kingdom | ||
2020-06-26 | United Kingdom | Wales | 15531 | 2466 | 0 | 14034 | 52.1307 | -3.7837 | 2020-06-27 04:33:35 | Wales, United Kingdom | ||
2020-06-27 | United Kingdom | Wales | 15577 | 2472 | 0 | 14075 | 52.1307 | -3.7837 | 2020-06-28 04:34:04 | Wales, United Kingdom | ||
2020-06-28 | United Kingdom | Wales | 15602 | 2476 | 0 | 14098 | 52.1307 | -3.7837 | 2020-06-29 04:33:44 | Wales, United Kingdom | ||
2020-06-29 | United Kingdom | Wales | 15717 | 2479 | 0 | 14210 | 52.1307 | -3.7837 | 2020-06-30 04:33:48 | Wales, United Kingdom | ||
2020-06-30 | United Kingdom | Wales | 15743 | 2485 | 0 | 14233 | 52.1307 | -3.7837 | 2020-07-01 04:33:52 | Wales, United Kingdom | ||
2020-07-01 | United Kingdom | Wales | 15775 | 2489 | 0 | 14259 | 52.1307 | -3.7837 | 2020-07-02 04:33:46 | Wales, United Kingdom | ||
2020-07-02 | United Kingdom | Wales | 15815 | 2494 | 0 | 14291 | 52.1307 | -3.7837 | 2020-07-03 04:33:54 | Wales, United Kingdom | ||
2020-07-03 | United Kingdom | Wales | 15841 | 2494 | 0 | 14316 | 52.1307 | -3.7837 | 2020-07-04 04:33:51 | 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 | ||
2020-07-05 | United Kingdom | Wales | 15890 | 2502 | 0 | 14359 | 52.1307 | -3.7837 | 2020-07-06 04:33:57 | Wales, United Kingdom | ||
2020-07-06 | United Kingdom | Wales | 15898 | 2505 | 0 | 14367 | 52.1307 | -3.7837 | 2020-07-07 04:34:00 | Wales, United Kingdom | ||
2020-07-07 | United Kingdom | Wales | 15900 | 2507 | 0 | 14366 | 52.1307 | -3.7837 | 2020-07-08 05:33:48 | Wales, United Kingdom | ||
2020-07-08 | United Kingdom | Wales | 15913 | 2509 | 0 | 14375 | 52.1307 | -3.7837 | 2020-07-09 04:34:23 | Wales, United Kingdom | ||
2020-07-09 | United Kingdom | Wales | 15929 | 2513 | 0 | 14389 | 52.1307 | -3.7837 | 2020-07-10 04:34:24 | Wales, United Kingdom | ||
2020-07-10 | United Kingdom | Wales | 15939 | 2514 | 0 | 14399 | 52.1307 | -3.7837 | 2020-07-11 04:34:26 | Wales, United Kingdom | ||
2020-07-11 | United Kingdom | Wales | 15946 | 2515 | 0 | 14405 | 52.1307 | -3.7837 | 2020-07-12 04:34:30 | Wales, United Kingdom | ||
2020-07-12 | United Kingdom | Wales | 15962 | 2517 | 0 | 14421 | 52.1307 | -3.7837 | 2020-07-13 04:43:04 | Wales, United Kingdom | ||
2020-07-13 | United Kingdom | Wales | 15973 | 2519 | 0 | 14432 | 52.1307 | -3.7837 | 2020-07-14 04:34:46 | Wales, United Kingdom | ||
2020-07-14 | United Kingdom | Wales | 16836 | 2520 | 0 | 15293 | 52.1307 | -3.7837 | 2020-07-15 04:34:39 | Wales, United Kingdom | ||
2020-07-15 | United Kingdom | Wales | 16854 | 2520 | 0 | 15309 | 52.1307 | -3.7837 | 2020-07-16 04:44:59 | Wales, United Kingdom | ||
2020-07-16 | United Kingdom | Wales | 16871 | 2522 | 0 | 15326 | 52.1307 | -3.7837 | 2020-07-17 04:34:50 | Wales, United Kingdom | ||
2020-07-17 | United Kingdom | Wales | 16887 | 2523 | 0 | 15341 | 52.1307 | -3.7837 | 2020-07-18 04:34:45 | Wales, United Kingdom | ||
2020-07-18 | United Kingdom | Wales | 16897 | 2523 | 0 | 15351 | 52.1307 | -3.7837 | 2020-07-19 04:34:58 | Wales, United Kingdom | ||
2020-07-19 | United Kingdom | Wales | 16928 | 2523 | 0 | 15381 | 52.1307 | -3.7837 | 2020-07-20 05:34:40 | Wales, United Kingdom | ||
2020-07-20 | United Kingdom | Wales | 16943 | 2523 | 0 | 15396 | 52.1307 | -3.7837 | 2020-07-21 04:38:46 | Wales, United Kingdom | ||
2020-07-21 | United Kingdom | Wales | 16965 | 2524 | 0 | 15418 | 52.1307 | -3.7837 | 2020-07-22 04:34:42 | Wales, United Kingdom | ||
2020-07-22 | United Kingdom | Wales | 16987 | 2524 | 0 | 15439 | 52.1307 | -3.7837 | 2020-07-23 05:15:04 | Wales, United Kingdom | ||
2020-07-23 | United Kingdom | Wales | 17030 | 2525 | 0 | 15482 | 52.1307 | -3.7837 | 2020-07-24 05:30:40 | Wales, United Kingdom | ||
2020-07-24 | United Kingdom | Wales | 17075 | 2526 | 0 | 15527 | 52.1307 | -3.7837 | 2020-07-25 04:47:39 | Wales, United Kingdom | ||
2020-07-25 | United Kingdom | Wales | 17105 | 2528 | 0 | 15557 | 52.1307 | -3.7837 | 2020-07-26 04:35:00 | 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 | ||
2020-07-27 | United Kingdom | Wales | 17170 | 2532 | 0 | 15621 | 52.1307 | -3.7837 | 2020-07-28 04:58:43 | Wales, United Kingdom | ||
2020-07-28 | United Kingdom | Wales | 17170 | 2534 | 0 | 15621 | 52.1307 | -3.7837 | 2020-07-29 04:35:11 | Wales, United Kingdom | ||
2020-07-29 | United Kingdom | Wales | 17223 | 2539 | 0 | 15669 | 52.1307 | -3.7837 | 2020-07-30 04:35:05 | Wales, United Kingdom | ||
2020-07-30 | United Kingdom | Wales | 17232 | 2542 | 0 | 15678 | 52.1307 | -3.7837 | 2020-07-31 04:35:18 | Wales, United Kingdom | ||
2020-07-31 | United Kingdom | Wales | 17258 | 2547 | 0 | 15698 | 52.1307 | -3.7837 | 2020-08-01 04:36:27 | Wales, United Kingdom | ||
2020-08-01 | United Kingdom | Wales | 17279 | 2551 | 0 | 15717 | 52.1307 | -3.7837 | 2020-08-02 04:34:47 | Wales, United Kingdom | ||
2020-08-02 | United Kingdom | Wales | 17315 | 2553 | 0 | 15750 | 52.1307 | -3.7837 | 2020-08-03 04:34:35 | Wales, United Kingdom | ||
2020-08-03 | United Kingdom | Wales | 17339 | 2556 | 0 | 15774 | 52.1307 | -3.7837 | 2020-08-04 04:41:59 | Wales, United Kingdom | ||
2020-08-04 | United Kingdom | Wales | 17361 | 2560 | 0 | 15795 | 52.1307 | -3.7837 | 2020-08-05 04:34:43 | Wales, United Kingdom | ||
2020-08-05 | United Kingdom | Wales | 17374 | 2563 | 0 | 15806 | 52.1307 | -3.7837 | 2020-08-06 04:35:02 | Wales, United Kingdom | ||
2020-08-06 | United Kingdom | Wales | 17389 | 2565 | 0 | 15818 | 52.1307 | -3.7837 | 2020-08-07 04:35:11 | 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 | ||
2020-08-08 | United Kingdom | Wales | 17425 | 2572 | 0 | 15846 | 52.1307 | -3.7837 | 2020-08-09 04:34:54 | Wales, United Kingdom |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;