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)
Suggested facets: deaths, active, longitude, day (date), last_update (date)
country_or_region 2
- China 1,024
- Mainland China 49
province_or_state 1
- Yunnan · 1,073 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144 | 144 | 2021-12-02 | China | Yunnan | 1720 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-03 04:23:05 | Yunnan, China | |||
4160 | 4160 | 2021-10-28 | China | Yunnan | 1561 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-29 04:22:03 | Yunnan, China | |||
16185 | 16185 | 2021-09-18 | China | Yunnan | 1309 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-19 04:21:34 | Yunnan, China | |||
24215 | 24215 | 2022-03-20 | China | Yunnan | 2046 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-21 04:20:50 | Yunnan, China | |||
28230 | 28230 | 2021-11-11 | China | Yunnan | 1624 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-12 04:22:01 | Yunnan, China | |||
32246 | 32246 | 2021-08-25 | China | Yunnan | 1031 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-08-26 04:21:28 | Yunnan, China | |||
40157 | 40157 | 2020-03-05 | Mainland China | Yunnan | 174 | 2 | 169 | 24.974 | 101.487 | 2020-03-03T03:43:02 | ||||
43522 | 43522 | 2021-11-02 | China | Yunnan | 1573 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-03 06:22:09 | Yunnan, China | |||
62500 | 62500 | 2020-03-07 | Mainland China | Yunnan | 174 | 2 | 170 | 24.974 | 101.487 | 2020-03-06T03:23:06 | ||||
62876 | 62876 | 2022-11-12 | China | Yunnan | 2831 | 2 | 0 | 24.974 | 101.487 | 2022-11-13 04:21:14 | Yunnan, China | |||
66891 | 66891 | 2021-09-01 | China | Yunnan | 1102 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-02 04:21:15 | Yunnan, China | |||
70905 | 70905 | 2022-02-07 | China | Yunnan | 1884 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-08 04:21:15 | Yunnan, China | |||
86939 | 86939 | 2021-11-09 | China | Yunnan | 1610 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-10 04:21:38 | Yunnan, China | |||
90956 | 90956 | 2022-07-23 | China | Yunnan | 2205 | 2 | 0 | 24.974 | 101.487 | 2022-07-24 04:20:47 | Yunnan, China | |||
98827 | 98827 | 2020-03-04 | Mainland China | Yunnan | 174 | 2 | 169 | 24.974 | 101.487 | 2020-03-03T03:43:02 | ||||
99140 | 99140 | 2022-01-14 | China | Yunnan | 1840 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-15 04:21:07 | Yunnan, China | |||
103156 | 103156 | 2021-08-15 | China | Yunnan | 959 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-08-16 04:21:31 | Yunnan, China | |||
107046 | 107046 | 2020-02-15 | Mainland China | Yunnan | 168 | 0 | 42 | 24.974 | 101.487 | 2020-02-15T06:33:01 | ||||
114566 | 114566 | 2022-09-06 | China | Yunnan | 2292 | 2 | 0 | 24.974 | 101.487 | 2022-09-07 04:20:59 | Yunnan, China | |||
126547 | 126547 | 2022-01-09 | China | Yunnan | 1836 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-10 04:22:07 | Yunnan, China | |||
130564 | 130564 | 2022-10-04 | China | Yunnan | 2460 | 2 | 0 | 24.974 | 101.487 | 2022-10-05 04:23:06 | Yunnan, China | |||
137785 | 137785 | 2021-12-04 | China | Yunnan | 1736 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-05 04:22:25 | Yunnan, China | |||
141802 | 141802 | 2022-07-09 | China | Yunnan | 2180 | 2 | 0 | 24.974 | 101.487 | 2022-07-10 04:20:54 | Yunnan, China | |||
149798 | 149798 | 2021-11-29 | China | Yunnan | 1699 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-30 04:22:53 | Yunnan, China | |||
157827 | 157827 | 2022-03-29 | China | Yunnan | 2064 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-30 04:20:45 | Yunnan, China | |||
161842 | 161842 | 2021-11-19 | China | Yunnan | 1655 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-20 04:22:17 | Yunnan, China | |||
165859 | 165859 | 2022-06-21 | China | Yunnan | 2164 | 2 | 0 | 24.974 | 101.487 | 2022-06-22 04:20:54 | Yunnan, China | |||
177856 | 177856 | 2021-09-02 | China | Yunnan | 1111 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-03 04:21:20 | Yunnan, China | |||
185885 | 185885 | 2022-02-13 | China | Yunnan | 1888 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-14 04:20:51 | Yunnan, China | |||
197776 | 197776 | 2020-01-24 | Mainland China | Yunnan | 5 | 0 | 0 | 24.974 | 101.487 | 1/24/20 17:00 | ||||
197854 | 197854 | 2020-01-29 | Mainland China | Yunnan | 55 | 0 | 0 | 24.974 | 101.487 | 1/29/20 19:30 | ||||
198073 | 198073 | 2022-10-19 | China | Yunnan | 2626 | 2 | 0 | 24.974 | 101.487 | 2022-10-20 04:22:59 | Yunnan, China | |||
217794 | 217794 | 2022-12-26 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-27 04:21:07 | Yunnan, China | |||
221810 | 221810 | 2022-05-09 | China | Yunnan | 2120 | 2 | 0 | 24.974 | 101.487 | 2022-05-10 04:20:50 | Yunnan, China | |||
229041 | 229041 | 2022-05-31 | China | Yunnan | 2149 | 2 | 0 | 24.974 | 101.487 | 2022-06-01 04:20:55 | Yunnan, China | |||
233057 | 233057 | 2022-02-11 | China | Yunnan | 1885 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-12 04:21:06 | Yunnan, China | |||
245099 | 245099 | 2021-08-17 | China | Yunnan | 982 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-08-18 04:21:35 | Yunnan, China | |||
249113 | 249113 | 2021-09-04 | China | Yunnan | 1127 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-05 04:21:33 | Yunnan, China | |||
253128 | 253128 | 2022-09-08 | China | Yunnan | 2304 | 2 | 0 | 24.974 | 101.487 | 2022-09-09 04:21:11 | Yunnan, China | |||
257144 | 257144 | 2022-12-10 | China | Yunnan | 4956 | 2 | 0 | 24.974 | 101.487 | 2022-12-11 04:20:50 | Yunnan, China | |||
261041 | 261041 | 2020-03-03 | Mainland China | Yunnan | 174 | 2 | 169 | 24.974 | 101.487 | 2020-03-03T03:43:02 | ||||
261347 | 261347 | 2022-03-15 | China | Yunnan | 2020 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-16 04:20:50 | Yunnan, China | |||
275997 | 275997 | 2021-11-03 | China | Yunnan | 1576 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-04 04:22:20 | Yunnan, China | |||
287810 | 287810 | 2021-10-31 | China | Yunnan | 1567 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-01 04:22:01 | Yunnan, China | |||
291827 | 291827 | 2022-11-15 | China | Yunnan | 2927 | 2 | 0 | 24.974 | 101.487 | 2022-11-16 04:21:09 | Yunnan, China | |||
303683 | 303683 | 2022-04-16 | China | Yunnan | 2096 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-17 04:20:59 | Yunnan, China | |||
307699 | 307699 | 2022-12-13 | China | Yunnan | 5007 | 2 | 0 | 24.974 | 101.487 | 2022-12-14 04:21:04 | Yunnan, China | |||
311715 | 311715 | 2022-11-13 | China | Yunnan | 2866 | 2 | 0 | 24.974 | 101.487 | 2022-11-14 04:21:09 | Yunnan, China | |||
315731 | 315731 | 2022-02-12 | China | Yunnan | 1887 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-13 04:21:00 | Yunnan, China | |||
319747 | 319747 | 2022-10-30 | China | Yunnan | 2665 | 2 | 0 | 24.974 | 101.487 | 2022-10-31 04:21:36 | Yunnan, China | |||
327721 | 327721 | 2022-12-27 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-28 04:21:04 | Yunnan, China | |||
335751 | 335751 | 2022-03-18 | China | Yunnan | 2038 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-19 04:20:47 | Yunnan, China | |||
339720 | 339720 | 2020-03-21 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
348111 | 348111 | 2022-12-14 | China | Yunnan | 5007 | 2 | 0 | 24.974 | 101.487 | 2022-12-15 04:20:58 | Yunnan, China | |||
356141 | 356141 | 2022-03-11 | China | Yunnan | 2002 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-12 04:20:50 | Yunnan, China | |||
360157 | 360157 | 2022-05-07 | China | Yunnan | 2120 | 2 | 0 | 24.974 | 101.487 | 2022-05-08 04:20:49 | Yunnan, China | |||
372011 | 372011 | 2022-09-13 | China | Yunnan | 2322 | 2 | 0 | 24.974 | 101.487 | 2022-09-14 04:20:44 | Yunnan, China | |||
384038 | 384038 | 2022-09-23 | China | Yunnan | 2374 | 2 | 0 | 24.974 | 101.487 | 2022-09-24 04:21:40 | Yunnan, China | |||
396079 | 396079 | 2022-10-07 | China | Yunnan | 2514 | 2 | 0 | 24.974 | 101.487 | 2022-10-08 04:22:56 | Yunnan, China | |||
404108 | 404108 | 2021-12-07 | China | Yunnan | 1752 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-08 04:22:46 | Yunnan, China | |||
415849 | 415849 | 2020-01-26 | Mainland China | Yunnan | 16 | 0 | 0 | 24.974 | 101.487 | 1/26/20 16:00 | ||||
419150 | 419150 | 2022-09-18 | China | Yunnan | 2342 | 2 | 0 | 24.974 | 101.487 | 2022-09-19 04:21:49 | Yunnan, China | |||
423165 | 423165 | 2021-10-10 | China | Yunnan | 1518 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-11 04:21:31 | Yunnan, China | |||
431172 | 431172 | 2022-11-03 | China | Yunnan | 2684 | 2 | 0 | 24.974 | 101.487 | 2022-11-04 04:22:11 | Yunnan, China | |||
443169 | 443169 | 2021-10-20 | China | Yunnan | 1551 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-21 04:21:18 | Yunnan, China | |||
447185 | 447185 | 2021-11-17 | China | Yunnan | 1652 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-18 04:21:33 | Yunnan, China | |||
451202 | 451202 | 2022-12-21 | China | Yunnan | 5561 | 2 | 0 | 24.974 | 101.487 | 2022-12-22 04:20:56 | Yunnan, China | |||
459194 | 459194 | 2022-02-02 | China | Yunnan | 1882 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-03 04:21:21 | Yunnan, China | |||
463211 | 463211 | 2022-05-02 | China | Yunnan | 2119 | 2 | 0 | 24.974 | 101.487 | 2022-05-03 04:21:00 | Yunnan, China | |||
467226 | 467226 | 2021-10-07 | China | Yunnan | 1491 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-08 04:21:25 | Yunnan, China | |||
475257 | 475257 | 2022-06-26 | China | Yunnan | 2174 | 2 | 0 | 24.974 | 101.487 | 2022-06-27 04:21:00 | Yunnan, China | |||
479150 | 479150 | 2020-02-25 | Mainland China | Yunnan | 174 | 2 | 129 | 24.974 | 101.487 | 2020-02-25T04:53:02 | ||||
479405 | 479405 | 2022-11-08 | China | Yunnan | 2748 | 2 | 0 | 24.974 | 101.487 | 2022-11-09 04:21:22 | Yunnan, China | |||
487435 | 487435 | 2022-11-25 | China | Yunnan | 3612 | 2 | 0 | 24.974 | 101.487 | 2022-11-26 04:21:11 | Yunnan, China | |||
491450 | 491450 | 2021-10-14 | China | Yunnan | 1537 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-15 04:21:26 | Yunnan, China | |||
495466 | 495466 | 2021-11-06 | China | Yunnan | 1594 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-11-07 04:21:53 | Yunnan, China | |||
499483 | 499483 | 2022-04-02 | China | Yunnan | 2069 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-04-03 04:20:48 | Yunnan, China | |||
503499 | 503499 | 2022-12-17 | China | Yunnan | 5063 | 2 | 0 | 24.974 | 101.487 | 2022-12-18 04:21:03 | Yunnan, China | |||
507514 | 507514 | 2021-08-14 | China | Yunnan | 948 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-08-15 04:21:41 | Yunnan, China | |||
511528 | 511528 | 2021-08-19 | China | Yunnan | 997 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-08-20 04:21:33 | Yunnan, China | |||
515543 | 515543 | 2022-10-15 | China | Yunnan | 2602 | 2 | 0 | 24.974 | 101.487 | 2022-10-16 04:22:39 | Yunnan, China | |||
534550 | 534550 | 2021-10-27 | China | Yunnan | 1558 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-28 04:22:08 | Yunnan, China | |||
538567 | 538567 | 2022-10-26 | China | Yunnan | 2649 | 2 | 0 | 24.974 | 101.487 | 2022-10-27 04:22:01 | Yunnan, China | |||
542583 | 542583 | 2022-12-15 | China | Yunnan | 5007 | 2 | 0 | 24.974 | 101.487 | 2022-12-16 04:21:01 | Yunnan, China | |||
550588 | 550588 | 2021-12-08 | China | Yunnan | 1755 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-09 04:22:49 | Yunnan, China | |||
554604 | 554604 | 2022-01-16 | China | Yunnan | 1845 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-17 04:21:08 | Yunnan, China | |||
558621 | 558621 | 2022-06-16 | China | Yunnan | 2157 | 2 | 0 | 24.974 | 101.487 | 2022-06-17 04:20:56 | Yunnan, China | |||
562516 | 562516 | 2020-03-01 | Mainland China | Yunnan | 174 | 2 | 163 | 24.974 | 101.487 | 2020-03-01T07:13:07 | ||||
566686 | 566686 | 2020-02-06 | Mainland China | Yunnan | 133 | 0 | 7 | 24.974 | 101.487 | 2020-02-06T09:43:02 | ||||
566918 | 566918 | 2021-10-29 | China | Yunnan | 1561 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-30 04:22:03 | Yunnan, China | |||
574647 | 574647 | 2022-02-25 | China | Yunnan | 1937 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-26 04:21:12 | Yunnan, China | |||
589458 | 589458 | 2021-08-08 | China | Yunnan | 903 | 2 | 0 | 24.974 | 101.487 | 2021-08-09 04:21:24 | Yunnan, China | |||
593473 | 593473 | 2022-07-01 | China | Yunnan | 2174 | 2 | 0 | 24.974 | 101.487 | 2022-07-02 04:21:16 | Yunnan, China | |||
597488 | 597488 | 2021-10-19 | China | Yunnan | 1551 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-20 04:21:00 | Yunnan, China | |||
601504 | 601504 | 2021-09-23 | China | Yunnan | 1362 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-09-24 04:21:44 | Yunnan, China | |||
617413 | 617413 | 2020-02-27 | Mainland China | Yunnan | 174 | 2 | 150 | 24.974 | 101.487 | 2020-02-27T10:03:07 | ||||
617677 | 617677 | 2022-11-05 | China | Yunnan | 2714 | 2 | 0 | 24.974 | 101.487 | 2022-11-06 04:21:24 | Yunnan, China | |||
621693 | 621693 | 2022-05-22 | China | Yunnan | 2140 | 2 | 0 | 24.974 | 101.487 | 2022-05-26 04:20:50 | Yunnan, China | |||
629723 | 629723 | 2022-07-12 | China | Yunnan | 2184 | 2 | 0 | 24.974 | 101.487 | 2022-07-13 04:20:58 | Yunnan, China | |||
633738 | 633738 | 2021-10-13 | China | Yunnan | 1534 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-10-14 04:21:29 | 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]);