johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
139 rows where active = 15 and country_or_region = "China" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 18
country_or_region 1
- China · 139 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903785 | 3903785 | 2021-07-31 | China | Hunan | 1083 | 4 | 1064 | 15 | 27.6104 | 111.7088 | 2021-08-01 04:21:50 | Hunan, China | ||
1330056 | 1330056 | 2021-07-24 | China | Henan | 1328 | 22 | 1291 | 15 | 33.882 | 113.614 | 2021-07-25 04:22:12 | Henan, China | ||
2371332 | 2371332 | 2021-07-20 | China | Shaanxi | 645 | 3 | 627 | 15 | 35.1917 | 108.8701 | 2021-07-21 04:21:40 | Shaanxi, China | ||
483411 | 483411 | 2021-07-19 | China | Shaanxi | 645 | 3 | 627 | 15 | 35.1917 | 108.8701 | 2021-07-20 04:21:48 | Shaanxi, China | ||
3705946 | 3705946 | 2021-07-17 | China | Shaanxi | 642 | 3 | 624 | 15 | 35.1917 | 108.8701 | 2021-07-18 04:22:07 | Shaanxi, China | ||
3705951 | 3705951 | 2021-07-17 | China | Tianjin | 412 | 3 | 394 | 15 | 39.3054 | 117.323 | 2021-07-18 04:22:07 | Tianjin, China | ||
1712124 | 1712124 | 2021-06-25 | China | Beijing | 1076 | 9 | 1052 | 15 | 40.1824 | 116.4142 | 2021-06-26 04:21:43 | Beijing, China | ||
2422689 | 2422689 | 2021-06-23 | China | Beijing | 1075 | 9 | 1051 | 15 | 40.1824 | 116.4142 | 2021-06-24 04:21:55 | Beijing, China | ||
562766 | 562766 | 2021-06-22 | China | Beijing | 1075 | 9 | 1051 | 15 | 40.1824 | 116.4142 | 2021-06-23 04:21:46 | Beijing, China | ||
3358468 | 3358468 | 2021-06-21 | China | Beijing | 1075 | 9 | 1051 | 15 | 40.1824 | 116.4142 | 2021-06-22 04:21:34 | Beijing, China | ||
2884182 | 2884182 | 2021-06-20 | China | Jiangsu | 740 | 0 | 725 | 15 | 32.9711 | 119.455 | 2021-06-21 04:21:41 | Jiangsu, China | ||
2910971 | 2910971 | 2021-06-17 | China | Beijing | 1072 | 9 | 1048 | 15 | 40.1824 | 116.4142 | 2021-06-18 04:22:16 | Beijing, China | ||
2910993 | 2910993 | 2021-06-17 | China | Shaanxi | 622 | 3 | 604 | 15 | 35.1917 | 108.8701 | 2021-06-18 04:22:16 | Shaanxi, China | ||
3030089 | 3030089 | 2021-06-16 | China | Beijing | 1072 | 9 | 1048 | 15 | 40.1824 | 116.4142 | 2021-06-17 04:22:36 | Beijing, China | ||
1563906 | 1563906 | 2021-06-14 | China | Jiangsu | 736 | 0 | 721 | 15 | 32.9711 | 119.455 | 2021-06-15 04:22:22 | Jiangsu, China | ||
3381189 | 3381189 | 2021-06-13 | China | Jiangsu | 736 | 0 | 721 | 15 | 32.9711 | 119.455 | 2021-06-14 04:22:46 | Jiangsu, China | ||
1708141 | 1708141 | 2021-06-02 | China | Yunnan | 353 | 2 | 336 | 15 | 24.974 | 101.487 | 2021-06-03 04:23:32 | Yunnan, China | ||
82912 | 82912 | 2021-05-25 | China | Liaoning | 425 | 2 | 408 | 15 | 41.2956 | 122.6085 | 2021-05-26 04:20:35 | Liaoning, China | ||
1412874 | 1412874 | 2021-05-24 | China | Liaoning | 425 | 2 | 408 | 15 | 41.2956 | 122.6085 | 2021-05-25 04:21:08 | Liaoning, China | ||
726319 | 726319 | 2021-05-22 | China | Shaanxi | 609 | 3 | 591 | 15 | 35.1917 | 108.8701 | 2021-05-23 04:20:51 | Shaanxi, China | ||
1952334 | 1952334 | 2021-05-21 | China | Shaanxi | 609 | 3 | 591 | 15 | 35.1917 | 108.8701 | 2021-05-22 04:20:45 | Shaanxi, China | ||
1913029 | 1913029 | 2021-05-20 | China | Liaoning | 423 | 2 | 406 | 15 | 41.2956 | 122.6085 | 2021-05-21 04:20:43 | Liaoning, China | ||
2255550 | 2255550 | 2021-05-19 | China | Liaoning | 423 | 2 | 406 | 15 | 41.2956 | 122.6085 | 2021-05-20 04:21:05 | Liaoning, China | ||
2571504 | 2571504 | 2021-04-13 | China | Sichuan | 958 | 3 | 940 | 15 | 30.6171 | 102.7103 | 2021-04-14 04:20:41 | Sichuan, China | ||
637754 | 637754 | 2021-03-31 | China | Yunnan | 247 | 2 | 230 | 15 | 24.974 | 101.487 | 2021-04-01 04:27:05 | Yunnan, China | ||
1535754 | 1535754 | 2021-03-28 | China | Tianjin | 373 | 3 | 355 | 15 | 39.3054 | 117.323 | 2021-03-29 04:28:35 | Tianjin, China | ||
1880812 | 1880812 | 2021-03-26 | China | Tianjin | 372 | 3 | 354 | 15 | 39.3054 | 117.323 | 2021-03-27 05:25:04 | Tianjin, China | ||
1579978 | 1579978 | 2021-03-13 | China | Tianjin | 362 | 3 | 344 | 15 | 39.3054 | 117.323 | 2021-03-14 05:25:37 | Tianjin, China | ||
1837757 | 1837757 | 2021-03-12 | China | Tianjin | 362 | 3 | 344 | 15 | 39.3054 | 117.323 | 2021-03-13 05:25:15 | Tianjin, China | ||
352122 | 352122 | 2021-03-11 | China | Tianjin | 361 | 3 | 343 | 15 | 39.3054 | 117.323 | 2021-03-12 05:26:50 | Tianjin, China | ||
3962346 | 3962346 | 2021-03-10 | China | Tianjin | 361 | 3 | 343 | 15 | 39.3054 | 117.323 | 2021-03-11 05:25:48 | Tianjin, China | ||
3663434 | 3663434 | 2021-03-09 | China | Tianjin | 361 | 3 | 343 | 15 | 39.3054 | 117.323 | 2021-03-10 05:24:35 | Tianjin, China | ||
2359293 | 2359293 | 2021-03-08 | China | Tianjin | 361 | 3 | 343 | 15 | 39.3054 | 117.323 | 2021-03-09 05:28:19 | Tianjin, China | ||
54631 | 54631 | 2021-03-07 | China | Tianjin | 361 | 3 | 343 | 15 | 39.3054 | 117.323 | 2021-03-08 05:24:48 | Tianjin, China | ||
3667448 | 3667448 | 2021-03-06 | China | Tianjin | 361 | 3 | 343 | 15 | 39.3054 | 117.323 | 2021-03-07 05:21:54 | Tianjin, China | ||
1089901 | 1089901 | 2021-03-03 | China | Tianjin | 357 | 3 | 339 | 15 | 39.3054 | 117.323 | 2021-03-04 05:24:24 | Tianjin, China | ||
2183409 | 2183409 | 2021-02-26 | China | Tianjin | 355 | 3 | 337 | 15 | 39.3054 | 117.323 | 2021-02-27 05:22:28 | Tianjin, China | ||
530531 | 530531 | 2021-02-22 | China | Sichuan | 887 | 3 | 869 | 15 | 30.6171 | 102.7103 | 2021-02-23 05:23:41 | Sichuan, China | ||
181865 | 181865 | 2021-02-21 | China | Sichuan | 887 | 3 | 869 | 15 | 30.6171 | 102.7103 | 2021-02-22 05:24:21 | Sichuan, China | ||
3600856 | 3600856 | 2021-02-17 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-18 05:22:58 | Jiangsu, China | ||
3049991 | 3049991 | 2021-02-16 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-17 05:23:10 | Jiangsu, China | ||
1338090 | 1338090 | 2021-02-15 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-16 05:24:38 | Jiangsu, China | ||
1338102 | 1338102 | 2021-02-15 | China | Tianjin | 349 | 3 | 331 | 15 | 39.3054 | 117.323 | 2021-02-16 05:24:38 | Tianjin, China | ||
2283241 | 2283241 | 2021-02-14 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-15 05:24:49 | Jiangsu, China | ||
2283253 | 2283253 | 2021-02-14 | China | Tianjin | 349 | 3 | 331 | 15 | 39.3054 | 117.323 | 2021-02-15 05:24:49 | Tianjin, China | ||
2677641 | 2677641 | 2021-02-13 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-14 05:23:43 | Jiangsu, China | ||
3539274 | 3539274 | 2021-02-12 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-13 05:22:12 | Jiangsu, China | ||
3539286 | 3539286 | 2021-02-12 | China | Tianjin | 348 | 3 | 330 | 15 | 39.3054 | 117.323 | 2021-02-13 05:22:12 | Tianjin, China | ||
2637524 | 2637524 | 2021-02-11 | China | Fujian | 548 | 1 | 532 | 15 | 26.0789 | 117.9874 | 2021-02-12 05:23:29 | Fujian, China | ||
2637537 | 2637537 | 2021-02-11 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-12 05:23:29 | Jiangsu, China | ||
2637549 | 2637549 | 2021-02-11 | China | Tianjin | 347 | 3 | 329 | 15 | 39.3054 | 117.323 | 2021-02-12 05:23:29 | Tianjin, China | ||
3978392 | 3978392 | 2021-02-10 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-11 05:23:55 | Jiangsu, China | ||
3978404 | 3978404 | 2021-02-10 | China | Tianjin | 347 | 3 | 329 | 15 | 39.3054 | 117.323 | 2021-02-11 05:23:55 | Tianjin, China | ||
1527712 | 1527712 | 2021-02-09 | China | Jiangsu | 703 | 0 | 688 | 15 | 32.9711 | 119.455 | 2021-02-10 05:22:41 | Jiangsu, China | ||
613490 | 613490 | 2021-02-08 | China | Fujian | 546 | 1 | 530 | 15 | 26.0789 | 117.9874 | 2021-02-09 05:23:30 | Fujian, China | ||
613515 | 613515 | 2021-02-08 | China | Tianjin | 346 | 3 | 328 | 15 | 39.3054 | 117.323 | 2021-02-09 05:23:30 | Tianjin, China | ||
1672259 | 1672259 | 2021-02-07 | China | Fujian | 545 | 1 | 529 | 15 | 26.0789 | 117.9874 | 2021-02-08 05:22:39 | Fujian, China | ||
1672284 | 1672284 | 2021-02-07 | China | Tianjin | 346 | 3 | 328 | 15 | 39.3054 | 117.323 | 2021-02-08 05:22:39 | Tianjin, China | ||
974720 | 974720 | 2021-02-06 | China | Fujian | 545 | 1 | 529 | 15 | 26.0789 | 117.9874 | 2021-02-07 05:23:00 | Fujian, China | ||
974745 | 974745 | 2021-02-06 | China | Tianjin | 346 | 3 | 328 | 15 | 39.3054 | 117.323 | 2021-02-07 05:23:00 | Tianjin, China | ||
1684303 | 1684303 | 2021-02-02 | China | Fujian | 541 | 1 | 525 | 15 | 26.0789 | 117.9874 | 2021-02-03 05:22:52 | Fujian, China | ||
1684319 | 1684319 | 2021-02-02 | China | Liaoning | 402 | 2 | 385 | 15 | 41.2956 | 122.6085 | 2021-02-03 05:22:52 | Liaoning, China | ||
1676273 | 1676273 | 2021-02-01 | China | Fujian | 541 | 1 | 525 | 15 | 26.0789 | 117.9874 | 2021-02-02 05:22:49 | Fujian, China | ||
1676289 | 1676289 | 2021-02-01 | China | Liaoning | 402 | 2 | 385 | 15 | 41.2956 | 122.6085 | 2021-02-02 05:22:49 | Liaoning, China | ||
1459561 | 1459561 | 2021-01-31 | China | Fujian | 541 | 1 | 525 | 15 | 26.0789 | 117.9874 | 2021-02-01 05:22:53 | Fujian, China | ||
1896956 | 1896956 | 2021-01-29 | China | Fujian | 539 | 1 | 523 | 15 | 26.0789 | 117.9874 | 2021-01-30 05:22:49 | Fujian, China | ||
12158 | 12158 | 2021-01-26 | China | Liaoning | 397 | 2 | 380 | 15 | 41.2956 | 122.6085 | 2021-01-27 05:23:41 | Liaoning, China | ||
2567466 | 2567466 | 2021-01-25 | China | Fujian | 536 | 1 | 520 | 15 | 26.0789 | 117.9874 | 2021-01-26 05:22:02 | Fujian, China | ||
1759098 | 1759098 | 2021-01-24 | China | Fujian | 535 | 1 | 519 | 15 | 26.0789 | 117.9874 | 2021-01-25 05:22:16 | Fujian, China | ||
237055 | 237055 | 2021-01-18 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-19 05:22:15 | Inner Mongolia, China | ||
237072 | 237072 | 2021-01-18 | China | Zhejiang | 1314 | 1 | 1298 | 15 | 29.1832 | 120.0934 | 2021-01-19 05:22:15 | Zhejiang, China | ||
3503172 | 3503172 | 2021-01-17 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-18 05:22:34 | Inner Mongolia, China | ||
3101255 | 3101255 | 2021-01-16 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-17 05:22:17 | Inner Mongolia, China | ||
3515217 | 3515217 | 2021-01-15 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-16 05:22:40 | Inner Mongolia, China | ||
3879390 | 3879390 | 2021-01-14 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-15 05:22:24 | Inner Mongolia, China | ||
3308017 | 3308017 | 2021-01-13 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-14 05:22:32 | Inner Mongolia, China | ||
774162 | 774162 | 2021-01-12 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-13 05:22:15 | Inner Mongolia, China | ||
189883 | 189883 | 2021-01-11 | China | Inner Mongolia | 366 | 1 | 350 | 15 | 44.0935 | 113.9448 | 2021-01-12 05:22:15 | Inner Mongolia, China | ||
1136707 | 1136707 | 2021-01-01 | China | Shaanxi | 508 | 3 | 490 | 15 | 35.1917 | 108.8701 | 2021-01-02 05:22:33 | Shaanxi, China | ||
3761407 | 3761407 | 2020-12-28 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-29 05:22:37 | Shaanxi, China | ||
3777727 | 3777727 | 2020-12-27 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-28 05:22:06 | Shaanxi, China | ||
2223324 | 2223324 | 2020-12-26 | China | Inner Mongolia | 352 | 1 | 336 | 15 | 44.0935 | 113.9448 | 2020-12-27 05:22:55 | Inner Mongolia, China | ||
2223332 | 2223332 | 2020-12-26 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-27 05:22:55 | Shaanxi, China | ||
202071 | 202071 | 2020-12-25 | China | Inner Mongolia | 352 | 1 | 336 | 15 | 44.0935 | 113.9448 | 2020-12-26 05:22:28 | Inner Mongolia, China | ||
202079 | 202079 | 2020-12-25 | China | Shaanxi | 505 | 3 | 487 | 15 | 35.1917 | 108.8701 | 2020-12-26 05:22:28 | Shaanxi, China | ||
3691294 | 3691294 | 2020-12-24 | China | Inner Mongolia | 352 | 1 | 336 | 15 | 44.0935 | 113.9448 | 2020-12-25 05:22:48 | Inner Mongolia, China | ||
923510 | 923510 | 2020-11-26 | China | Tianjin | 299 | 3 | 281 | 15 | 39.3054 | 117.323 | 2020-11-27 05:26:53 | Tianjin, China | ||
3169467 | 3169467 | 2020-11-16 | China | Xinjiang | 980 | 3 | 962 | 15 | 41.1129 | 85.2401 | 2020-11-17 05:25:54 | Xinjiang, China | ||
271983 | 271983 | 2020-11-10 | China | Tianjin | 283 | 3 | 265 | 15 | 39.3054 | 117.323 | 2020-11-11 05:25:30 | Tianjin, China | ||
2497847 | 2497847 | 2020-11-03 | China | Tianjin | 273 | 3 | 255 | 15 | 39.3054 | 117.323 | 2020-11-04 05:25:09 | Tianjin, China | ||
210068 | 210068 | 2020-10-29 | China | Tianjin | 265 | 3 | 247 | 15 | 39.3054 | 117.323 | 2020-10-30 04:24:49 | Tianjin, China | ||
3651397 | 3651397 | 2020-10-24 | China | Tianjin | 260 | 3 | 242 | 15 | 39.3054 | 117.323 | 2020-10-25 04:24:36 | Tianjin, China | ||
3785699 | 3785699 | 2020-10-11 | China | Fujian | 416 | 1 | 400 | 15 | 26.0789 | 117.9874 | 2020-10-12 04:23:45 | Fujian, China | ||
1041627 | 1041627 | 2020-10-07 | China | Fujian | 413 | 1 | 397 | 15 | 26.0789 | 117.9874 | 2020-10-08 04:23:56 | Fujian, China | ||
3117288 | 3117288 | 2020-10-06 | China | Fujian | 413 | 1 | 397 | 15 | 26.0789 | 117.9874 | 2020-10-07 04:23:40 | Fujian, China | ||
2581785 | 2581785 | 2020-09-27 | China | Fujian | 403 | 1 | 387 | 15 | 26.0789 | 117.9874 | 2020-09-28 04:23:00 | Fujian, China | ||
2613837 | 2613837 | 2020-09-26 | China | Fujian | 401 | 1 | 385 | 15 | 26.0789 | 117.9874 | 2020-09-27 04:23:00 | Fujian, China | ||
2836620 | 2836620 | 2020-09-21 | China | Fujian | 396 | 1 | 380 | 15 | 26.0789 | 117.9874 | 2020-09-22 04:23:00 | Fujian, China | ||
2836644 | 2836644 | 2020-09-21 | China | Sichuan | 672 | 3 | 654 | 15 | 30.6171 | 102.7103 | 2020-09-22 04:23:00 | Sichuan, China | ||
3093225 | 3093225 | 2020-09-20 | China | Fujian | 396 | 1 | 380 | 15 | 26.0789 | 117.9874 | 2020-09-21 04:23:00 | Fujian, 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]);