johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Shandong" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▲ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
295834 | 295834 | 2021-07-15 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-16 04:21:22 | Shandong, China | ||
331728 | 331728 | 2021-08-04 | China | Shandong | 900 | 7 | 876 | 17 | 36.3427 | 118.1498 | 2021-08-05 04:21:51 | Shandong, China | ||
408116 | 408116 | 2021-07-28 | China | Shandong | 884 | 7 | 876 | 1 | 36.3427 | 118.1498 | 2021-07-29 04:21:33 | Shandong, China | ||
483412 | 483412 | 2021-07-19 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-20 04:21:48 | Shandong, China | ||
578654 | 578654 | 2021-07-13 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-14 04:21:35 | Shandong, China | ||
625700 | 625700 | 2021-07-10 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-11 04:21:43 | Shandong, China | ||
778183 | 778183 | 2021-07-08 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-09 04:21:21 | Shandong, China | ||
829419 | 829419 | 2021-07-09 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-10 04:21:25 | Shandong, China | ||
1164990 | 1164990 | 2021-07-04 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-05 04:21:28 | Shandong, China | ||
1305977 | 1305977 | 2021-07-27 | China | Shandong | 884 | 7 | 876 | 1 | 36.3427 | 118.1498 | 2021-07-28 04:21:39 | Shandong, China | ||
1330069 | 1330069 | 2021-07-24 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-25 04:22:12 | Shandong, China | ||
1378329 | 1378329 | 2021-07-25 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-26 04:21:28 | Shandong, China | ||
1440405 | 1440405 | 2021-07-07 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-08 04:21:26 | Shandong, China | ||
1495424 | 1495424 | 2021-07-03 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-04 04:21:38 | Shandong, China | ||
1892963 | 1892963 | 2021-06-30 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-01 04:21:19 | Shandong, China | ||
1932259 | 1932259 | 2021-07-05 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-06 04:21:32 | Shandong, China | ||
2071739 | 2071739 | 2021-07-02 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-03 04:21:37 | Shandong, China | ||
2371333 | 2371333 | 2021-07-20 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-21 04:21:40 | Shandong, China | ||
2673635 | 2673635 | 2021-07-18 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-19 04:21:24 | Shandong, China | ||
2693510 | 2693510 | 2021-07-06 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-07 04:21:20 | Shandong, China | ||
2764755 | 2764755 | 2021-07-01 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-02 04:21:47 | Shandong, China | ||
2947178 | 2947178 | 2021-07-16 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-17 04:22:22 | Shandong, China | ||
3015172 | 3015172 | 2021-08-01 | China | Shandong | 889 | 7 | 876 | 6 | 36.3427 | 118.1498 | 2021-08-02 04:21:36 | Shandong, China | ||
3137373 | 3137373 | 2021-07-23 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-24 00:21:36 | Shandong, China | ||
3218120 | 3218120 | 2021-07-26 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-27 04:21:18 | Shandong, China | ||
3296000 | 3296000 | 2021-07-30 | China | Shandong | 885 | 7 | 876 | 2 | 36.3427 | 118.1498 | 2021-07-31 04:21:35 | Shandong, China | ||
3331352 | 3331352 | 2021-07-21 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-22 04:21:19 | Shandong, China | ||
3385211 | 3385211 | 2021-07-29 | China | Shandong | 885 | 7 | 876 | 2 | 36.3427 | 118.1498 | 2021-07-30 04:21:34 | Shandong, China | ||
3467999 | 3467999 | 2021-08-03 | China | Shandong | 896 | 7 | 876 | 13 | 36.3427 | 118.1498 | 2021-08-04 04:21:25 | Shandong, China | ||
3476133 | 3476133 | 2021-07-22 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-23 04:21:29 | Shandong, China | ||
3631779 | 3631779 | 2021-07-14 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-15 04:21:48 | Shandong, China | ||
3659416 | 3659416 | 2021-07-11 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-12 04:21:34 | Shandong, China | ||
3683273 | 3683273 | 2021-08-02 | China | Shandong | 890 | 7 | 876 | 7 | 36.3427 | 118.1498 | 2021-08-03 04:21:39 | Shandong, China | ||
3705947 | 3705947 | 2021-07-17 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-18 04:22:07 | Shandong, China | ||
3740903 | 3740903 | 2021-07-12 | China | Shandong | 883 | 7 | 876 | 0 | 36.3427 | 118.1498 | 2021-07-13 04:21:18 | Shandong, China | ||
3903795 | 3903795 | 2021-07-31 | China | Shandong | 886 | 7 | 876 | 3 | 36.3427 | 118.1498 | 2021-08-01 04:21:50 | Shandong, China | ||
107273 | 107273 | 2021-06-19 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-20 04:21:48 | Shandong, China | ||
400086 | 400086 | 2021-06-29 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-30 04:21:41 | Shandong, China | ||
522679 | 522679 | 2021-06-09 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-10 04:23:17 | Shandong, China | ||
562789 | 562789 | 2021-06-22 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-23 04:21:46 | Shandong, China | ||
825405 | 825405 | 2021-06-06 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-07 04:22:51 | Shandong, China | ||
1125416 | 1125416 | 2021-06-18 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-19 04:22:33 | Shandong, China | ||
1563914 | 1563914 | 2021-06-14 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-15 04:22:22 | Shandong, China | ||
1712147 | 1712147 | 2021-06-25 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-26 04:21:43 | Shandong, China | ||
1736331 | 1736331 | 2021-06-12 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-13 04:22:44 | Shandong, China | ||
2295272 | 2295272 | 2021-06-24 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-25 04:21:33 | Shandong, China | ||
2339218 | 2339218 | 2021-06-15 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-16 04:22:32 | Shandong, China | ||
2422712 | 2422712 | 2021-06-23 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-24 04:21:55 | Shandong, China | ||
2585810 | 2585810 | 2021-06-05 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-06 04:24:03 | Shandong, China | ||
2589824 | 2589824 | 2021-06-27 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-28 04:21:29 | Shandong, China | ||
2716794 | 2716794 | 2021-06-10 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-11 04:23:20 | Shandong, China | ||
2884190 | 2884190 | 2021-06-20 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-21 04:21:41 | Shandong, China | ||
2910994 | 2910994 | 2021-06-17 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-18 04:22:16 | Shandong, China | ||
3030112 | 3030112 | 2021-06-16 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-17 04:22:36 | Shandong, China | ||
3125329 | 3125329 | 2021-06-28 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-29 04:21:28 | Shandong, China | ||
3145403 | 3145403 | 2021-06-07 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-08 04:22:35 | Shandong, China | ||
3358491 | 3358491 | 2021-06-21 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-22 04:21:34 | Shandong, China | ||
3381197 | 3381197 | 2021-06-13 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-14 04:22:46 | Shandong, China | ||
3472119 | 3472119 | 2021-06-08 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-09 04:23:31 | Shandong, China | ||
3958328 | 3958328 | 2021-06-26 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-27 04:21:39 | Shandong, China | ||
3970372 | 3970372 | 2021-06-11 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-12 04:22:22 | Shandong, China | ||
1448409 | 1448409 | 2021-06-03 | China | Shandong | 883 | 7 | 874 | 2 | 36.3427 | 118.1498 | 2021-06-04 04:23:37 | Shandong, China | ||
1708133 | 1708133 | 2021-06-02 | China | Shandong | 883 | 7 | 874 | 2 | 36.3427 | 118.1498 | 2021-06-03 04:23:32 | Shandong, China | ||
2315124 | 2315124 | 2021-06-04 | China | Shandong | 883 | 7 | 874 | 2 | 36.3427 | 118.1498 | 2021-06-05 04:23:03 | Shandong, China | ||
20192 | 20192 | 2021-05-28 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-05-29 04:20:41 | Shandong, China | ||
50613 | 50613 | 2021-05-29 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-05-30 04:20:55 | Shandong, China | ||
1188567 | 1188567 | 2021-05-31 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-06-01 04:23:09 | Shandong, China | ||
1806567 | 1806567 | 2021-05-27 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-05-28 04:20:36 | Shandong, China | ||
2103951 | 2103951 | 2021-06-01 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-06-02 04:24:34 | Shandong, China | ||
3089244 | 3089244 | 2021-05-30 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-05-31 03:08:59 | Shandong, China | ||
82917 | 82917 | 2021-05-25 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-26 04:20:35 | Shandong, China | ||
726320 | 726320 | 2021-05-22 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-23 04:20:51 | Shandong, China | ||
1309991 | 1309991 | 2021-05-26 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-27 04:20:59 | Shandong, China | ||
1412879 | 1412879 | 2021-05-24 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-25 04:21:08 | Shandong, China | ||
1771165 | 1771165 | 2021-05-23 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-24 04:20:53 | Shandong, China | ||
1913034 | 1913034 | 2021-05-20 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-21 04:20:43 | Shandong, China | ||
1952335 | 1952335 | 2021-05-21 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-22 04:20:45 | Shandong, China | ||
2255555 | 2255555 | 2021-05-19 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-20 04:21:05 | Shandong, China | ||
1081747 | 1081747 | 2021-05-14 | China | Shandong | 882 | 7 | 871 | 4 | 36.3427 | 118.1498 | 2021-05-15 04:20:58 | Shandong, China | ||
1872778 | 1872778 | 2021-05-15 | China | Shandong | 882 | 7 | 871 | 4 | 36.3427 | 118.1498 | 2021-05-16 04:20:49 | Shandong, China | ||
2004483 | 2004483 | 2021-05-12 | China | Shandong | 881 | 7 | 871 | 3 | 36.3427 | 118.1498 | 2021-05-13 04:20:51 | Shandong, China | ||
2390593 | 2390593 | 2021-05-18 | China | Shandong | 883 | 7 | 871 | 5 | 36.3427 | 118.1498 | 2021-05-19 04:20:42 | Shandong, China | ||
2939148 | 2939148 | 2021-05-16 | China | Shandong | 882 | 7 | 871 | 4 | 36.3427 | 118.1498 | 2021-05-17 04:20:34 | Shandong, China | ||
3054013 | 3054013 | 2021-05-13 | China | Shandong | 881 | 7 | 871 | 3 | 36.3427 | 118.1498 | 2021-05-14 04:20:41 | Shandong, China | ||
3574418 | 3574418 | 2021-05-17 | China | Shandong | 883 | 7 | 871 | 5 | 36.3427 | 118.1498 | 2021-05-18 04:20:33 | Shandong, China | ||
3954314 | 3954314 | 2021-05-11 | China | Shandong | 880 | 7 | 870 | 3 | 36.3427 | 118.1498 | 2021-05-12 04:21:29 | Shandong, China | ||
1424925 | 1424925 | 2021-05-09 | China | Shandong | 879 | 7 | 869 | 3 | 36.3427 | 118.1498 | 2021-05-10 04:20:38 | Shandong, China | ||
1551793 | 1551793 | 2021-05-08 | China | Shandong | 879 | 7 | 869 | 3 | 36.3427 | 118.1498 | 2021-05-09 04:20:35 | Shandong, China | ||
2501851 | 2501851 | 2021-05-07 | China | Shandong | 879 | 7 | 869 | 3 | 36.3427 | 118.1498 | 2021-05-08 04:21:04 | Shandong, China | ||
2820593 | 2820593 | 2021-05-10 | China | Shandong | 879 | 7 | 869 | 3 | 36.3427 | 118.1498 | 2021-05-11 04:20:41 | Shandong, China | ||
645774 | 645774 | 2021-05-05 | China | Shandong | 879 | 7 | 868 | 4 | 36.3427 | 118.1498 | 2021-05-06 04:20:38 | Shandong, China | ||
2760741 | 2760741 | 2021-05-03 | China | Shandong | 878 | 7 | 868 | 3 | 36.3427 | 118.1498 | 2021-05-04 04:20:34 | Shandong, China | ||
3113307 | 3113307 | 2021-05-06 | China | Shandong | 879 | 7 | 868 | 4 | 36.3427 | 118.1498 | 2021-05-07 04:20:40 | Shandong, China | ||
3675474 | 3675474 | 2021-05-04 | China | Shandong | 879 | 7 | 868 | 4 | 36.3427 | 118.1498 | 2021-05-05 04:20:43 | Shandong, China | ||
2450594 | 2450594 | 2021-05-02 | China | Shandong | 876 | 7 | 867 | 2 | 36.3427 | 118.1498 | 2021-05-03 04:20:39 | Shandong, China | ||
2824607 | 2824607 | 2021-05-01 | China | Shandong | 876 | 7 | 867 | 2 | 36.3427 | 118.1498 | 2021-05-02 04:20:48 | Shandong, China | ||
380015 | 380015 | 2021-04-30 | China | Shandong | 876 | 7 | 866 | 3 | 36.3427 | 118.1498 | 2021-05-01 04:20:47 | Shandong, China | ||
1636138 | 1636138 | 2021-04-29 | China | Shandong | 876 | 7 | 866 | 3 | 36.3427 | 118.1498 | 2021-04-30 04:21:03 | Shandong, China | ||
3393217 | 3393217 | 2021-04-28 | China | Shandong | 876 | 7 | 865 | 4 | 36.3427 | 118.1498 | 2021-04-29 04:20:55 | Shandong, China | ||
887942 | 887942 | 2021-04-26 | China | Shandong | 876 | 7 | 864 | 5 | 36.3427 | 118.1498 | 2021-04-27 04:20:52 | Shandong, China |
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]);