johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
144 rows where active = 13 and country_or_region = "China" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, day (date), last_update (date)
province_or_state 20
country_or_region 1
- China · 144 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3467999 | 3467999 | 2021-08-03 | China | Shandong | 896 | 7 | 876 | 13 | 36.3427 | 118.1498 | 2021-08-04 04:21:25 | Shandong, China | ||
3903772 | 3903772 | 2021-07-31 | China | Beijing | 1089 | 9 | 1067 | 13 | 40.1824 | 116.4142 | 2021-08-01 04:21:50 | Beijing, China | ||
3295977 | 3295977 | 2021-07-30 | China | Beijing | 1089 | 9 | 1067 | 13 | 40.1824 | 116.4142 | 2021-07-31 04:21:35 | Beijing, China | ||
3385188 | 3385188 | 2021-07-29 | China | Beijing | 1089 | 9 | 1067 | 13 | 40.1824 | 116.4142 | 2021-07-30 04:21:34 | Beijing, China | ||
3476120 | 3476120 | 2021-07-22 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-23 04:21:29 | Henan, China | ||
3331339 | 3331339 | 2021-07-21 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-22 04:21:19 | Henan, China | ||
2371320 | 2371320 | 2021-07-20 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-21 04:21:40 | Henan, China | ||
483399 | 483399 | 2021-07-19 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-20 04:21:48 | Henan, China | ||
2673622 | 2673622 | 2021-07-18 | China | Henan | 1326 | 22 | 1291 | 13 | 33.882 | 113.614 | 2021-07-19 04:21:24 | Henan, China | ||
3705939 | 3705939 | 2021-07-17 | China | Jiangsu | 751 | 0 | 738 | 13 | 32.9711 | 119.455 | 2021-07-18 04:22:07 | Jiangsu, China | ||
2947177 | 2947177 | 2021-07-16 | China | Shaanxi | 640 | 3 | 624 | 13 | 35.1917 | 108.8701 | 2021-07-17 04:22:22 | Shaanxi, China | ||
3631778 | 3631778 | 2021-07-14 | China | Shaanxi | 637 | 3 | 621 | 13 | 35.1917 | 108.8701 | 2021-07-15 04:21:48 | Shaanxi, China | ||
3631783 | 3631783 | 2021-07-14 | China | Tianjin | 408 | 3 | 392 | 13 | 39.3054 | 117.323 | 2021-07-15 04:21:48 | Tianjin, China | ||
578653 | 578653 | 2021-07-13 | China | Shaanxi | 637 | 3 | 621 | 13 | 35.1917 | 108.8701 | 2021-07-14 04:21:35 | Shaanxi, China | ||
578658 | 578658 | 2021-07-13 | China | Tianjin | 408 | 3 | 392 | 13 | 39.3054 | 117.323 | 2021-07-14 04:21:35 | Tianjin, China | ||
3740907 | 3740907 | 2021-07-12 | China | Tianjin | 407 | 3 | 391 | 13 | 39.3054 | 117.323 | 2021-07-13 04:21:18 | Tianjin, China | ||
3125321 | 3125321 | 2021-06-28 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-29 04:21:28 | Jiangsu, China | ||
2589816 | 2589816 | 2021-06-27 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-28 04:21:29 | Jiangsu, China | ||
3958320 | 3958320 | 2021-06-26 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-27 04:21:39 | Jiangsu, China | ||
1712139 | 1712139 | 2021-06-25 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-26 04:21:43 | Jiangsu, China | ||
2295264 | 2295264 | 2021-06-24 | China | Jiangsu | 742 | 0 | 729 | 13 | 32.9711 | 119.455 | 2021-06-25 04:21:33 | Jiangsu, China | ||
3358490 | 3358490 | 2021-06-21 | China | Shaanxi | 624 | 3 | 608 | 13 | 35.1917 | 108.8701 | 2021-06-22 04:21:34 | Shaanxi, China | ||
3381174 | 3381174 | 2021-06-13 | China | Beijing | 1070 | 9 | 1048 | 13 | 40.1824 | 116.4142 | 2021-06-14 04:22:46 | Beijing, China | ||
1872777 | 1872777 | 2021-05-15 | China | Shaanxi | 600 | 3 | 584 | 13 | 35.1917 | 108.8701 | 2021-05-16 04:20:49 | Shaanxi, China | ||
2450593 | 2450593 | 2021-05-02 | China | Shaanxi | 590 | 3 | 574 | 13 | 35.1917 | 108.8701 | 2021-05-03 04:20:39 | Shaanxi, China | ||
2824606 | 2824606 | 2021-05-01 | China | Shaanxi | 590 | 3 | 574 | 13 | 35.1917 | 108.8701 | 2021-05-02 04:20:48 | Shaanxi, China | ||
1841766 | 1841766 | 2021-04-14 | China | Shaanxi | 578 | 3 | 562 | 13 | 35.1917 | 108.8701 | 2021-04-15 04:20:54 | Shaanxi, China | ||
605510 | 605510 | 2021-04-09 | China | Shaanxi | 576 | 3 | 560 | 13 | 35.1917 | 108.8701 | 2021-04-10 04:20:59 | Shaanxi, China | ||
3643379 | 3643379 | 2021-03-30 | China | Tianjin | 373 | 3 | 357 | 13 | 39.3054 | 117.323 | 2021-03-31 04:26:25 | Tianjin, China | ||
1089874 | 1089874 | 2021-03-03 | China | Beijing | 1049 | 9 | 1027 | 13 | 40.1824 | 116.4142 | 2021-03-04 05:24:24 | Beijing, China | ||
2183399 | 2183399 | 2021-02-26 | China | Jilin | 573 | 3 | 557 | 13 | 43.6661 | 126.1923 | 2021-02-27 05:22:28 | Jilin, China | ||
181848 | 181848 | 2021-02-21 | China | Heilongjiang | 1610 | 13 | 1584 | 13 | 47.862 | 127.7615 | 2021-02-22 05:24:21 | Heilongjiang, China | ||
742139 | 742139 | 2021-02-20 | China | Sichuan | 885 | 3 | 869 | 13 | 30.6171 | 102.7103 | 2021-02-21 05:24:33 | Sichuan, China | ||
742140 | 742140 | 2021-02-20 | China | Tianjin | 351 | 3 | 335 | 13 | 39.3054 | 117.323 | 2021-02-21 05:24:33 | Tianjin, China | ||
471238 | 471238 | 2021-02-19 | China | Tianjin | 351 | 3 | 335 | 13 | 39.3054 | 117.323 | 2021-02-20 05:22:51 | Tianjin, China | ||
1152952 | 1152952 | 2021-02-18 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-19 05:24:16 | Zhejiang, China | ||
3600872 | 3600872 | 2021-02-17 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-18 05:22:58 | Zhejiang, China | ||
3049998 | 3049998 | 2021-02-16 | China | Shaanxi | 547 | 3 | 531 | 13 | 35.1917 | 108.8701 | 2021-02-17 05:23:10 | Shaanxi, China | ||
3050003 | 3050003 | 2021-02-16 | China | Tianjin | 349 | 3 | 333 | 13 | 39.3054 | 117.323 | 2021-02-17 05:23:10 | Tianjin, China | ||
3050007 | 3050007 | 2021-02-16 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-17 05:23:10 | Zhejiang, China | ||
1338097 | 1338097 | 2021-02-15 | China | Shaanxi | 547 | 3 | 531 | 13 | 35.1917 | 108.8701 | 2021-02-16 05:24:38 | Shaanxi, China | ||
1338106 | 1338106 | 2021-02-15 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-16 05:24:38 | Zhejiang, China | ||
2283257 | 2283257 | 2021-02-14 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-15 05:24:49 | Zhejiang, China | ||
2677657 | 2677657 | 2021-02-13 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-14 05:23:43 | Zhejiang, China | ||
3539261 | 3539261 | 2021-02-12 | China | Fujian | 548 | 1 | 534 | 13 | 26.0789 | 117.9874 | 2021-02-13 05:22:12 | Fujian, China | ||
3539290 | 3539290 | 2021-02-12 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-13 05:22:12 | Zhejiang, China | ||
2637553 | 2637553 | 2021-02-11 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-12 05:23:29 | Zhejiang, China | ||
3978408 | 3978408 | 2021-02-10 | China | Zhejiang | 1320 | 1 | 1306 | 13 | 29.1832 | 120.0934 | 2021-02-11 05:23:55 | Zhejiang, China | ||
790209 | 790209 | 2021-02-04 | China | Sichuan | 873 | 3 | 857 | 13 | 30.6171 | 102.7103 | 2021-02-05 05:22:38 | Sichuan, China | ||
340101 | 340101 | 2021-02-03 | China | Sichuan | 873 | 3 | 857 | 13 | 30.6171 | 102.7103 | 2021-02-04 05:22:26 | Sichuan, China | ||
1684327 | 1684327 | 2021-02-02 | China | Sichuan | 873 | 3 | 857 | 13 | 30.6171 | 102.7103 | 2021-02-03 05:22:52 | Sichuan, China | ||
1896972 | 1896972 | 2021-01-29 | China | Liaoning | 397 | 2 | 382 | 13 | 41.2956 | 122.6085 | 2021-01-30 05:22:49 | Liaoning, China | ||
2481788 | 2481788 | 2021-01-28 | China | Liaoning | 397 | 2 | 382 | 13 | 41.2956 | 122.6085 | 2021-01-29 05:22:23 | Liaoning, China | ||
3153407 | 3153407 | 2021-01-27 | China | Fujian | 536 | 1 | 522 | 13 | 26.0789 | 117.9874 | 2021-01-28 05:22:24 | Fujian, China | ||
2426728 | 2426728 | 2021-01-23 | China | Shanxi | 237 | 0 | 224 | 13 | 37.5777 | 112.2922 | 2021-01-24 05:22:35 | Shanxi, China | ||
3503184 | 3503184 | 2021-01-17 | China | Sichuan | 863 | 3 | 847 | 13 | 30.6171 | 102.7103 | 2021-01-18 05:22:34 | Sichuan, China | ||
3230281 | 3230281 | 2021-01-03 | China | Yunnan | 230 | 2 | 215 | 13 | 24.974 | 101.487 | 2021-01-04 05:22:02 | Yunnan, China | ||
2227351 | 2227351 | 2021-01-02 | China | Yunnan | 230 | 2 | 215 | 13 | 24.974 | 101.487 | 2021-01-03 05:22:52 | Yunnan, China | ||
1136715 | 1136715 | 2021-01-01 | China | Yunnan | 230 | 2 | 215 | 13 | 24.974 | 101.487 | 2021-01-02 05:22:33 | Yunnan, China | ||
3695321 | 3695321 | 2020-12-31 | China | Yunnan | 230 | 2 | 215 | 13 | 24.974 | 101.487 | 2021-01-01 05:23:07 | Yunnan, China | ||
1010136 | 1010136 | 2020-12-30 | China | Yunnan | 229 | 2 | 214 | 13 | 24.974 | 101.487 | 2020-12-31 05:22:49 | Yunnan, China | ||
766143 | 766143 | 2020-12-29 | China | Shaanxi | 505 | 3 | 489 | 13 | 35.1917 | 108.8701 | 2020-12-30 05:22:34 | Shaanxi, China | ||
766151 | 766151 | 2020-12-29 | China | Yunnan | 229 | 2 | 214 | 13 | 24.974 | 101.487 | 2020-12-30 05:22:34 | Yunnan, China | ||
202057 | 202057 | 2020-12-25 | China | Beijing | 963 | 9 | 941 | 13 | 40.1824 | 116.4142 | 2020-12-26 05:22:28 | Beijing, China | ||
3691303 | 3691303 | 2020-12-24 | China | Shandong | 861 | 7 | 841 | 13 | 36.3427 | 118.1498 | 2020-12-25 05:22:48 | Shandong, China | ||
2406650 | 2406650 | 2020-12-23 | China | Liaoning | 302 | 2 | 287 | 13 | 41.2956 | 122.6085 | 2020-12-24 05:23:04 | Liaoning, China | ||
2406655 | 2406655 | 2020-12-23 | China | Shandong | 861 | 7 | 841 | 13 | 36.3427 | 118.1498 | 2020-12-24 05:23:04 | Shandong, China | ||
3769701 | 3769701 | 2020-12-22 | China | Shandong | 861 | 7 | 841 | 13 | 36.3427 | 118.1498 | 2020-12-23 05:22:03 | Shandong, China | ||
927517 | 927517 | 2020-12-21 | China | Shandong | 861 | 7 | 841 | 13 | 36.3427 | 118.1498 | 2020-12-22 05:22:33 | Shandong, China | ||
2119538 | 2119538 | 2020-12-20 | China | Shandong | 861 | 7 | 841 | 13 | 36.3427 | 118.1498 | 2020-12-21 05:27:58 | Shandong, China | ||
2931045 | 2931045 | 2020-12-19 | China | Shandong | 861 | 7 | 841 | 13 | 36.3427 | 118.1498 | 2020-12-20 05:27:32 | Shandong, China | ||
1900991 | 1900991 | 2020-12-18 | China | Shandong | 861 | 7 | 841 | 13 | 36.3427 | 118.1498 | 2020-12-19 05:27:52 | Shandong, China | ||
3149424 | 3149424 | 2020-12-16 | China | Yunnan | 226 | 2 | 211 | 13 | 24.974 | 101.487 | 2020-12-17 05:28:12 | Yunnan, China | ||
1034205 | 1034205 | 2020-12-15 | China | Yunnan | 226 | 2 | 211 | 13 | 24.974 | 101.487 | 2020-12-16 05:28:04 | Yunnan, China | ||
122532 | 122532 | 2020-11-18 | China | Tianjin | 291 | 3 | 275 | 13 | 39.3054 | 117.323 | 2020-11-19 05:25:23 | Tianjin, China | ||
891948 | 891948 | 2020-11-05 | China | Tianjin | 275 | 3 | 259 | 13 | 39.3054 | 117.323 | 2020-11-06 05:24:55 | Tianjin, China | ||
2919010 | 2919010 | 2020-11-04 | China | Tianjin | 273 | 3 | 257 | 13 | 39.3054 | 117.323 | 2020-11-05 06:05:03 | Tianjin, China | ||
754130 | 754130 | 2020-10-28 | China | Tianjin | 263 | 3 | 247 | 13 | 39.3054 | 117.323 | 2020-10-29 04:24:49 | Tianjin, China | ||
1794454 | 1794454 | 2020-10-19 | China | Shandong | 845 | 7 | 825 | 13 | 36.3427 | 118.1498 | 2020-10-20 04:24:22 | Shandong, China | ||
762138 | 762138 | 2020-10-18 | China | Shandong | 845 | 7 | 825 | 13 | 36.3427 | 118.1498 | 2020-10-19 04:24:16 | Shandong, China | ||
1026176 | 1026176 | 2020-10-17 | China | Shandong | 845 | 7 | 825 | 13 | 36.3427 | 118.1498 | 2020-10-18 04:24:25 | Shandong, China | ||
3781727 | 3781727 | 2020-10-13 | China | Shandong | 844 | 7 | 824 | 13 | 36.3427 | 118.1498 | 2020-10-14 04:24:05 | Shandong, China | ||
817370 | 817370 | 2020-10-09 | China | Fujian | 414 | 1 | 400 | 13 | 26.0789 | 117.9874 | 2020-10-10 04:23:57 | Fujian, China | ||
2848644 | 2848644 | 2020-09-18 | China | Fujian | 394 | 1 | 380 | 13 | 26.0789 | 117.9874 | 2020-09-19 04:22:00 | Fujian, China | ||
1121393 | 1121393 | 2020-09-17 | China | Fujian | 393 | 1 | 379 | 13 | 26.0789 | 117.9874 | 2020-09-18 05:05:00 | Fujian, China | ||
2868518 | 2868518 | 2020-09-13 | China | Fujian | 390 | 1 | 376 | 13 | 26.0789 | 117.9874 | 2020-09-14 04:26:00 | Fujian, China | ||
2171352 | 2171352 | 2020-09-09 | China | Fujian | 387 | 1 | 373 | 13 | 26.0789 | 117.9874 | 2020-09-10 04:29:01 | Fujian, China | ||
2171373 | 2171373 | 2020-09-09 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-10 04:29:01 | Shandong, China | ||
1243581 | 1243581 | 2020-09-08 | China | Shaanxi | 378 | 3 | 362 | 13 | 35.1917 | 108.8701 | 2020-09-09 04:28:48 | Shaanxi, China | ||
1243582 | 1243582 | 2020-09-08 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-09 04:28:48 | Shandong, China | ||
427161 | 427161 | 2020-09-07 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-08 04:28:25 | Shandong, China | ||
3161425 | 3161425 | 2020-09-06 | China | Fujian | 386 | 1 | 372 | 13 | 26.0789 | 117.9874 | 2020-09-07 04:28:30 | Fujian, China | ||
3161446 | 3161446 | 2020-09-06 | China | Shandong | 831 | 7 | 811 | 13 | 36.3427 | 118.1498 | 2020-09-07 04:28:30 | Shandong, China | ||
813380 | 813380 | 2020-09-05 | China | Fujian | 386 | 1 | 372 | 13 | 26.0789 | 117.9874 | 2020-09-06 04:28:33 | Fujian, China | ||
1354120 | 1354120 | 2020-09-03 | China | Fujian | 384 | 1 | 370 | 13 | 26.0789 | 117.9874 | 2020-09-04 04:28:26 | Fujian, China | ||
1354145 | 1354145 | 2020-09-03 | China | Tianjin | 230 | 3 | 214 | 13 | 39.3054 | 117.323 | 2020-09-04 04:28:26 | Tianjin, China | ||
1105357 | 1105357 | 2020-09-02 | China | Fujian | 383 | 1 | 369 | 13 | 26.0789 | 117.9874 | 2020-09-03 04:28:22 | Fujian, China | ||
2059686 | 2059686 | 2020-09-01 | China | Fujian | 383 | 1 | 369 | 13 | 26.0789 | 117.9874 | 2020-09-02 04:28:25 | Fujian, China | ||
2059688 | 2059688 | 2020-09-01 | China | Guangdong | 1742 | 8 | 1721 | 13 | 23.3417 | 113.4244 | 2020-09-02 04:28:25 | Guangdong, China | ||
2059692 | 2059692 | 2020-09-01 | China | Hebei | 365 | 6 | 346 | 13 | 37.8957 | 114.9042 | 2020-09-02 04:28:25 | Hebei, 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]);