johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Yunnan" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 2
- China 936
- Mainland China 37
province_or_state 1
- Yunnan · 973 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
641768 | 641768 | 2021-09-07 | China | Yunnan | 1162 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-08 04:21:31 | Yunnan, China | |||
649796 | 649796 | 2021-08-09 | China | Yunnan | 914 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-08-10 04:21:27 | Yunnan, China | |||
653810 | 653810 | 2021-10-22 | China | Yunnan | 1557 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-23 04:21:32 | Yunnan, China | |||
657715 | 657715 | 2020-03-09 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
658129 | 658129 | 2022-05-13 | China | Yunnan | 2125 | 2 | 0 | 24.974 | 101.487 | 2022-05-14 04:20:48 | Yunnan, China | |||
670114 | 670114 | 2022-07-21 | China | Yunnan | 2202 | 2 | 0 | 24.974 | 101.487 | 2022-07-22 04:21:15 | Yunnan, China | |||
674130 | 674130 | 2022-07-30 | China | Yunnan | 2207 | 2 | 0 | 24.974 | 101.487 | 2022-07-31 04:21:02 | Yunnan, China | |||
682155 | 682155 | 2021-10-24 | China | Yunnan | 1558 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-25 04:22:31 | Yunnan, China | |||
686171 | 686171 | 2021-11-13 | China | Yunnan | 1635 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-14 04:21:31 | Yunnan, China | |||
690188 | 690188 | 2022-12-23 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-24 04:21:02 | Yunnan, China | |||
694204 | 694204 | 2022-03-17 | China | Yunnan | 2032 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-18 04:20:55 | Yunnan, China | |||
698219 | 698219 | 2021-11-04 | China | Yunnan | 1578 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-05 04:21:54 | Yunnan, China | |||
706249 | 706249 | 2021-09-29 | China | Yunnan | 1415 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-30 04:21:20 | Yunnan, China | |||
710265 | 710265 | 2022-11-01 | China | Yunnan | 2673 | 2 | 0 | 24.974 | 101.487 | 2022-11-02 04:22:09 | Yunnan, China | |||
714280 | 714280 | 2021-11-12 | China | Yunnan | 1631 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-13 04:21:38 | Yunnan, China | |||
718297 | 718297 | 2022-12-04 | China | Yunnan | 4698 | 2 | 0 | 24.974 | 101.487 | 2022-12-05 04:20:58 | Yunnan, China | |||
722312 | 722312 | 2021-11-20 | China | Yunnan | 1658 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-21 04:22:13 | Yunnan, China | |||
730342 | 730342 | 2021-12-27 | China | Yunnan | 1806 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-28 04:21:47 | Yunnan, China | |||
746159 | 746159 | 2022-04-23 | China | Yunnan | 2114 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-24 04:20:56 | Yunnan, China | |||
758142 | 758142 | 2021-11-26 | China | Yunnan | 1683 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-27 04:22:45 | Yunnan, China | |||
770163 | 770163 | 2021-10-23 | China | Yunnan | 1558 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-24 04:21:22 | Yunnan, China | |||
782205 | 782205 | 2021-12-13 | China | Yunnan | 1770 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-14 04:22:38 | Yunnan, China | |||
794229 | 794229 | 2022-10-24 | China | Yunnan | 2642 | 2 | 0 | 24.974 | 101.487 | 2022-10-25 04:21:53 | Yunnan, China | |||
798244 | 798244 | 2021-12-22 | China | Yunnan | 1790 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-23 04:21:21 | Yunnan, China | |||
809406 | 809406 | 2021-09-20 | China | Yunnan | 1330 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-21 04:21:26 | Yunnan, China | |||
833442 | 833442 | 2022-12-02 | China | Yunnan | 4368 | 2 | 0 | 24.974 | 101.487 | 2022-12-03 04:21:02 | Yunnan, China | |||
849414 | 849414 | 2022-11-02 | China | Yunnan | 2678 | 2 | 0 | 24.974 | 101.487 | 2022-11-03 04:22:05 | Yunnan, China | |||
853430 | 853430 | 2022-09-30 | China | Yunnan | 2411 | 2 | 0 | 24.974 | 101.487 | 2022-10-01 04:23:01 | Yunnan, China | |||
864410 | 864410 | 2020-01-23 | Mainland China | Yunnan | 2 | 0 | 0 | 24.974 | 101.487 | 1/23/20 17:00 | ||||
868614 | 868614 | 2022-12-11 | China | Yunnan | 4975 | 2 | 0 | 24.974 | 101.487 | 2022-12-12 04:21:01 | Yunnan, China | |||
876079 | 876079 | 2022-03-27 | China | Yunnan | 2058 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-28 04:20:33 | Yunnan, China | |||
880095 | 880095 | 2022-08-05 | China | Yunnan | 2222 | 2 | 0 | 24.974 | 101.487 | 2022-08-06 04:20:56 | Yunnan, China | |||
895962 | 895962 | 2022-07-24 | China | Yunnan | 2205 | 2 | 0 | 24.974 | 101.487 | 2022-07-25 04:20:51 | Yunnan, China | |||
899978 | 899978 | 2022-07-22 | China | Yunnan | 2203 | 2 | 0 | 24.974 | 101.487 | 2022-07-23 04:20:53 | Yunnan, China | |||
903993 | 903993 | 2021-11-24 | China | Yunnan | 1678 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-25 04:22:33 | Yunnan, China | |||
912023 | 912023 | 2022-10-29 | China | Yunnan | 2659 | 2 | 0 | 24.974 | 101.487 | 2022-10-30 04:22:14 | Yunnan, China | |||
919499 | 919499 | 2022-03-08 | China | Yunnan | 1987 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-09 04:20:59 | Yunnan, China | |||
934615 | 934615 | 2021-10-16 | China | Yunnan | 1540 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-17 04:21:29 | Yunnan, China | |||
938632 | 938632 | 2022-06-25 | China | Yunnan | 2173 | 2 | 0 | 24.974 | 101.487 | 2022-06-26 04:21:02 | Yunnan, China | |||
942648 | 942648 | 2022-02-28 | China | Yunnan | 1956 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-01 04:21:09 | Yunnan, China | |||
946664 | 946664 | 2022-06-14 | China | Yunnan | 2157 | 2 | 0 | 24.974 | 101.487 | 2022-06-15 04:20:54 | Yunnan, China | |||
950680 | 950680 | 2022-03-12 | China | Yunnan | 2004 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-13 04:20:49 | Yunnan, China | |||
958710 | 958710 | 2022-07-19 | China | Yunnan | 2196 | 2 | 0 | 24.974 | 101.487 | 2022-07-20 04:20:59 | Yunnan, China | |||
962726 | 962726 | 2022-09-09 | China | Yunnan | 2310 | 2 | 0 | 24.974 | 101.487 | 2022-09-10 04:21:10 | Yunnan, China | |||
970734 | 970734 | 2022-06-01 | China | Yunnan | 2149 | 2 | 0 | 24.974 | 101.487 | 2022-06-02 05:20:39 | Yunnan, China | |||
978763 | 978763 | 2022-02-01 | China | Yunnan | 1881 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-02 04:21:09 | Yunnan, China | |||
986793 | 986793 | 2021-10-04 | China | Yunnan | 1459 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-05 04:21:27 | Yunnan, China | |||
990809 | 990809 | 2022-08-16 | China | Yunnan | 2241 | 2 | 0 | 24.974 | 101.487 | 2022-08-17 04:20:59 | Yunnan, China | |||
1014148 | 1014148 | 2021-11-21 | China | Yunnan | 1664 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-22 04:22:20 | Yunnan, China | |||
1018165 | 1018165 | 2022-12-24 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-25 04:21:04 | Yunnan, China | |||
1022181 | 1022181 | 2022-11-04 | China | Yunnan | 2703 | 2 | 0 | 24.974 | 101.487 | 2022-11-05 04:21:52 | Yunnan, China | |||
1030190 | 1030190 | 2021-12-06 | China | Yunnan | 1749 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-07 04:22:34 | Yunnan, China | |||
1049653 | 1049653 | 2022-11-06 | China | Yunnan | 2725 | 2 | 0 | 24.974 | 101.487 | 2022-11-07 04:21:26 | Yunnan, China | |||
1057664 | 1057664 | 2022-02-23 | China | Yunnan | 1923 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-24 04:21:14 | Yunnan, China | |||
1065692 | 1065692 | 2022-07-28 | China | Yunnan | 2206 | 2 | 0 | 24.974 | 101.487 | 2022-07-29 04:20:45 | Yunnan, China | |||
1069708 | 1069708 | 2022-08-07 | China | Yunnan | 2223 | 2 | 0 | 24.974 | 101.487 | 2022-08-08 04:21:08 | Yunnan, China | |||
1073724 | 1073724 | 2022-12-28 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-29 04:21:01 | Yunnan, China | |||
1077739 | 1077739 | 2021-12-09 | China | Yunnan | 1761 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-10 04:22:28 | Yunnan, China | |||
1085646 | 1085646 | 2020-02-22 | Mainland China | Yunnan | 174 | 2 | 107 | 24.974 | 101.487 | 2020-02-22T04:43:02 | ||||
1085890 | 1085890 | 2022-08-09 | China | Yunnan | 2225 | 2 | 0 | 24.974 | 101.487 | 2022-08-10 04:20:57 | Yunnan, China | |||
1097933 | 1097933 | 2022-08-03 | China | Yunnan | 2215 | 2 | 0 | 24.974 | 101.487 | 2022-08-04 04:20:58 | Yunnan, China | |||
1109389 | 1109389 | 2022-05-21 | China | Yunnan | 2135 | 2 | 0 | 24.974 | 101.487 | 2022-05-22 04:20:52 | Yunnan, China | |||
1113404 | 1113404 | 2022-01-11 | China | Yunnan | 1838 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-12 04:21:44 | Yunnan, China | |||
1117420 | 1117420 | 2021-08-06 | China | Yunnan | 884 | 2 | 0 | 24.974 | 101.487 | 2021-08-07 04:21:30 | Yunnan, China | |||
1140727 | 1140727 | 2022-01-23 | China | Yunnan | 1863 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-24 04:21:12 | Yunnan, China | |||
1144743 | 1144743 | 2021-12-01 | China | Yunnan | 1710 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-02 04:22:37 | Yunnan, China | |||
1148760 | 1148760 | 2022-12-12 | China | Yunnan | 4991 | 2 | 0 | 24.974 | 101.487 | 2022-12-13 04:21:01 | Yunnan, China | |||
1152656 | 1152656 | 2020-03-02 | Mainland China | Yunnan | 174 | 2 | 168 | 24.974 | 101.487 | 2020-03-02T06:23:04 | ||||
1156967 | 1156967 | 2022-04-29 | China | Yunnan | 2119 | 2 | 0 | 24.974 | 101.487 | 2022-04-30 04:21:05 | Yunnan, China | |||
1160983 | 1160983 | 2022-08-18 | China | Yunnan | 2251 | 2 | 0 | 24.974 | 101.487 | 2022-08-19 04:20:54 | Yunnan, China | |||
1169013 | 1169013 | 2022-05-20 | China | Yunnan | 2133 | 2 | 0 | 24.974 | 101.487 | 2022-05-21 04:20:58 | Yunnan, China | |||
1176944 | 1176944 | 2020-03-18 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
1184560 | 1184560 | 2022-05-18 | China | Yunnan | 2132 | 2 | 0 | 24.974 | 101.487 | 2022-05-19 04:20:54 | Yunnan, China | |||
1192465 | 1192465 | 2020-02-14 | Mainland China | Yunnan | 162 | 0 | 36 | 24.974 | 101.487 | 2020-02-14T12:53:02 | ||||
1199622 | 1199622 | 2022-07-06 | China | Yunnan | 2178 | 2 | 0 | 24.974 | 101.487 | 2022-07-07 04:20:55 | Yunnan, China | |||
1211367 | 1211367 | 2022-07-11 | China | Yunnan | 2182 | 2 | 0 | 24.974 | 101.487 | 2022-07-12 04:20:51 | Yunnan, China | |||
1215382 | 1215382 | 2022-01-08 | China | Yunnan | 1830 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-09 04:21:46 | Yunnan, China | |||
1223413 | 1223413 | 2022-04-14 | China | Yunnan | 2108 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-15 04:20:57 | Yunnan, China | |||
1227428 | 1227428 | 2022-01-24 | China | Yunnan | 1867 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-25 04:21:05 | Yunnan, China | |||
1231444 | 1231444 | 2021-11-28 | China | Yunnan | 1697 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-29 04:22:30 | Yunnan, China | |||
1235460 | 1235460 | 2021-09-27 | China | Yunnan | 1402 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-28 04:21:28 | Yunnan, China | |||
1239476 | 1239476 | 2022-11-28 | China | Yunnan | 3828 | 2 | 0 | 24.974 | 101.487 | 2022-11-29 04:21:05 | Yunnan, China | |||
1243367 | 1243367 | 2020-02-17 | Mainland China | Yunnan | 171 | 0 | 47 | 24.974 | 101.487 | 2020-02-17T10:23:04 | ||||
1250572 | 1250572 | 2022-08-23 | China | Yunnan | 2266 | 2 | 0 | 24.974 | 101.487 | 2022-08-24 04:20:46 | Yunnan, China | |||
1254587 | 1254587 | 2021-12-20 | China | Yunnan | 1785 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-21 03:21:27 | Yunnan, China | |||
1258603 | 1258603 | 2021-12-18 | China | Yunnan | 1783 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-19 04:21:11 | Yunnan, China | |||
1262619 | 1262619 | 2021-09-09 | China | Yunnan | 1183 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-10 04:21:20 | Yunnan, China | |||
1274103 | 1274103 | 2021-10-03 | China | Yunnan | 1454 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-04 04:21:31 | Yunnan, China | |||
1281804 | 1281804 | 2022-01-05 | China | Yunnan | 1825 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-06 04:22:09 | Yunnan, China | |||
1285820 | 1285820 | 2022-01-04 | China | Yunnan | 1823 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-05 04:21:59 | Yunnan, China | |||
1293850 | 1293850 | 2022-02-05 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-06 04:21:00 | Yunnan, China | |||
1297867 | 1297867 | 2022-02-17 | China | Yunnan | 1896 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-18 04:21:04 | Yunnan, China | |||
1305769 | 1305769 | 2020-01-28 | Mainland China | Yunnan | 44 | 0 | 0 | 24.974 | 101.487 | 1/28/20 23:00 | ||||
1314014 | 1314014 | 2022-05-27 | China | Yunnan | 2143 | 2 | 0 | 24.974 | 101.487 | 2022-05-28 04:21:07 | Yunnan, China | |||
1318029 | 1318029 | 2022-01-26 | China | Yunnan | 1872 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-27 04:21:19 | Yunnan, China | |||
1322045 | 1322045 | 2021-11-14 | China | Yunnan | 1640 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-15 04:21:36 | Yunnan, China | |||
1326062 | 1326062 | 2022-04-26 | China | Yunnan | 2116 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-27 04:20:52 | Yunnan, China | |||
1334091 | 1334091 | 2021-09-28 | China | Yunnan | 1410 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-29 04:21:45 | Yunnan, China | |||
1342120 | 1342120 | 2021-08-11 | China | Yunnan | 929 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-08-12 04:21:25 | Yunnan, China | |||
1346135 | 1346135 | 2022-08-10 | China | Yunnan | 2229 | 2 | 0 | 24.974 | 101.487 | 2022-08-11 04:20:49 | Yunnan, 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]);