johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69 rows where active = 21 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 · 69 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015161 | 3015161 | 2021-08-01 | China | Hubei | 68198 | 4512 | 63665 | 21 | 30.9756 | 112.2707 | 2021-08-02 04:21:36 | Hubei, China | ||
3903794 | 3903794 | 2021-07-31 | China | Shaanxi | 656 | 3 | 632 | 21 | 35.1917 | 108.8701 | 2021-08-01 04:21:50 | Shaanxi, China | ||
3296009 | 3296009 | 2021-07-30 | China | Zhejiang | 1395 | 1 | 1373 | 21 | 29.1832 | 120.0934 | 2021-07-31 04:21:35 | Zhejiang, China | ||
3089243 | 3089243 | 2021-05-30 | China | Shaanxi | 616 | 3 | 592 | 21 | 35.1917 | 108.8701 | 2021-05-31 03:08:59 | Shaanxi, China | ||
50612 | 50612 | 2021-05-29 | China | Shaanxi | 616 | 3 | 592 | 21 | 35.1917 | 108.8701 | 2021-05-30 04:20:55 | Shaanxi, China | ||
1412887 | 1412887 | 2021-05-24 | China | Yunnan | 352 | 2 | 329 | 21 | 24.974 | 101.487 | 2021-05-25 04:21:08 | Yunnan, China | ||
3053992 | 3053992 | 2021-05-13 | China | Fujian | 598 | 1 | 576 | 21 | 26.0789 | 117.9874 | 2021-05-14 04:20:41 | Fujian, China | ||
2004462 | 2004462 | 2021-05-12 | China | Fujian | 597 | 1 | 575 | 21 | 26.0789 | 117.9874 | 2021-05-13 04:20:51 | Fujian, China | ||
3113316 | 3113316 | 2021-05-06 | China | Zhejiang | 1344 | 1 | 1322 | 21 | 29.1832 | 120.0934 | 2021-05-07 04:20:40 | Zhejiang, China | ||
645783 | 645783 | 2021-05-05 | China | Zhejiang | 1344 | 1 | 1322 | 21 | 29.1832 | 120.0934 | 2021-05-06 04:20:38 | Zhejiang, China | ||
3675483 | 3675483 | 2021-05-04 | China | Zhejiang | 1344 | 1 | 1322 | 21 | 29.1832 | 120.0934 | 2021-05-05 04:20:43 | Zhejiang, China | ||
2760750 | 2760750 | 2021-05-03 | China | Zhejiang | 1344 | 1 | 1322 | 21 | 29.1832 | 120.0934 | 2021-05-04 04:20:34 | Zhejiang, China | ||
2450603 | 2450603 | 2021-05-02 | China | Zhejiang | 1344 | 1 | 1322 | 21 | 29.1832 | 120.0934 | 2021-05-03 04:20:39 | Zhejiang, China | ||
2824616 | 2824616 | 2021-05-01 | China | Zhejiang | 1344 | 1 | 1322 | 21 | 29.1832 | 120.0934 | 2021-05-02 04:20:48 | Zhejiang, China | ||
380024 | 380024 | 2021-04-30 | China | Zhejiang | 1344 | 1 | 1322 | 21 | 29.1832 | 120.0934 | 2021-05-01 04:20:47 | Zhejiang, China | ||
605490 | 605490 | 2021-04-09 | China | Fujian | 576 | 1 | 554 | 21 | 26.0789 | 117.9874 | 2021-04-10 04:20:59 | Fujian, China | ||
1798464 | 1798464 | 2021-03-23 | China | Sichuan | 939 | 3 | 915 | 21 | 30.6171 | 102.7103 | 2021-03-24 05:25:40 | Sichuan, China | ||
471220 | 471220 | 2021-02-19 | China | Heilongjiang | 1610 | 13 | 1576 | 21 | 47.862 | 127.7615 | 2021-02-20 05:22:51 | Heilongjiang, China | ||
2211494 | 2211494 | 2021-01-30 | China | Tianjin | 343 | 3 | 319 | 21 | 39.3054 | 117.323 | 2021-01-31 05:22:42 | Tianjin, China | ||
3308025 | 3308025 | 2021-01-13 | China | Shaanxi | 524 | 3 | 500 | 21 | 35.1917 | 108.8701 | 2021-01-14 05:22:32 | Shaanxi, China | ||
774170 | 774170 | 2021-01-12 | China | Shaanxi | 524 | 3 | 500 | 21 | 35.1917 | 108.8701 | 2021-01-13 05:22:15 | Shaanxi, China | ||
3899786 | 3899786 | 2021-01-09 | China | Sichuan | 857 | 3 | 833 | 21 | 30.6171 | 102.7103 | 2021-01-10 05:22:12 | Sichuan, China | ||
766135 | 766135 | 2020-12-29 | China | Inner Mongolia | 361 | 1 | 339 | 21 | 44.0935 | 113.9448 | 2020-12-30 05:22:34 | Inner Mongolia, China | ||
3777707 | 3777707 | 2020-12-27 | China | Fujian | 508 | 1 | 486 | 21 | 26.0789 | 117.9874 | 2020-12-28 05:22:06 | Fujian, China | ||
3777719 | 3777719 | 2020-12-27 | China | Inner Mongolia | 358 | 1 | 336 | 21 | 44.0935 | 113.9448 | 2020-12-28 05:22:06 | Inner Mongolia, China | ||
2223310 | 2223310 | 2020-12-26 | China | Beijing | 971 | 9 | 941 | 21 | 40.1824 | 116.4142 | 2020-12-27 05:22:55 | Beijing, China | ||
2223312 | 2223312 | 2020-12-26 | China | Fujian | 508 | 1 | 486 | 21 | 26.0789 | 117.9874 | 2020-12-27 05:22:55 | Fujian, China | ||
202059 | 202059 | 2020-12-25 | China | Fujian | 508 | 1 | 486 | 21 | 26.0789 | 117.9874 | 2020-12-26 05:22:28 | Fujian, China | ||
3691298 | 3691298 | 2020-12-24 | China | Liaoning | 310 | 2 | 287 | 21 | 41.2956 | 122.6085 | 2020-12-25 05:22:48 | Liaoning, China | ||
2406634 | 2406634 | 2020-12-23 | China | Fujian | 507 | 1 | 485 | 21 | 26.0789 | 117.9874 | 2020-12-24 05:23:04 | Fujian, China | ||
1006117 | 1006117 | 2020-12-06 | China | Shaanxi | 502 | 3 | 478 | 21 | 35.1917 | 108.8701 | 2020-12-07 05:26:14 | Shaanxi, China | ||
1583979 | 1583979 | 2020-11-30 | China | Inner Mongolia | 327 | 1 | 305 | 21 | 44.0935 | 113.9448 | 2020-12-01 05:26:18 | Inner Mongolia, China | ||
754105 | 754105 | 2020-10-28 | China | Fujian | 432 | 1 | 410 | 21 | 26.0789 | 117.9874 | 2020-10-29 04:24:49 | Fujian, China | ||
1177317 | 1177317 | 2020-10-22 | China | Shaanxi | 438 | 3 | 414 | 21 | 35.1917 | 108.8701 | 2020-10-23 04:24:46 | Shaanxi, China | ||
2191422 | 2191422 | 2020-10-21 | China | Shaanxi | 438 | 3 | 414 | 21 | 35.1917 | 108.8701 | 2020-10-22 04:24:27 | Shaanxi, China | ||
2613839 | 2613839 | 2020-09-26 | China | Guangdong | 1814 | 8 | 1785 | 21 | 23.3417 | 113.4244 | 2020-09-27 04:23:00 | Guangdong, China | ||
2836622 | 2836622 | 2020-09-21 | China | Guangdong | 1803 | 8 | 1774 | 21 | 23.3417 | 113.4244 | 2020-09-22 04:23:00 | Guangdong, China | ||
3093227 | 3093227 | 2020-09-20 | China | Guangdong | 1800 | 8 | 1771 | 21 | 23.3417 | 113.4244 | 2020-09-21 04:23:00 | Guangdong, China | ||
1172989 | 1172989 | 2020-09-10 | China | Guangdong | 1774 | 8 | 1745 | 21 | 23.3417 | 113.4244 | 2020-09-11 04:46:23 | Guangdong, China | ||
3161449 | 3161449 | 2020-09-06 | China | Sichuan | 658 | 3 | 634 | 21 | 30.6171 | 102.7103 | 2020-09-07 04:28:30 | Sichuan, China | ||
1354144 | 1354144 | 2020-09-03 | China | Sichuan | 656 | 3 | 632 | 21 | 30.6171 | 102.7103 | 2020-09-04 04:28:26 | Sichuan, China | ||
1479362 | 1479362 | 2020-08-21 | China | Guangdong | 1725 | 8 | 1696 | 21 | 23.3417 | 113.4244 | 2020-08-22 04:27:49 | Guangdong, China | ||
1612071 | 1612071 | 2020-08-14 | China | Shaanxi | 348 | 3 | 324 | 21 | 35.1917 | 108.8701 | 2020-08-15 04:27:31 | Shaanxi, China | ||
3531256 | 3531256 | 2020-08-12 | China | Guangdong | 1707 | 8 | 1678 | 21 | 23.3417 | 113.4244 | 2020-08-13 04:29:15 | Guangdong, China | ||
1920572 | 1920572 | 2020-08-10 | China | Shandong | 816 | 7 | 788 | 21 | 36.3427 | 118.1498 | 2020-08-11 04:35:08 | Shandong, China | ||
2306379 | 2306379 | 2020-06-28 | China | Gansu | 163 | 2 | 140 | 21 | 35.7518 | 104.2861 | 2020-06-29 04:33:44 | Gansu, China | ||
2039714 | 2039714 | 2020-06-27 | China | Gansu | 163 | 2 | 140 | 21 | 35.7518 | 104.2861 | 2020-06-28 04:34:04 | Gansu, China | ||
1135995 | 1135995 | 2020-06-26 | China | Gansu | 162 | 2 | 139 | 21 | 35.7518 | 104.2861 | 2020-06-27 04:33:35 | Gansu, China | ||
2700622 | 2700622 | 2020-06-24 | China | Gansu | 161 | 2 | 138 | 21 | 35.7518 | 104.2861 | 2020-06-25 05:26:54 | Gansu, China | ||
2386795 | 2386795 | 2020-06-16 | China | Shanghai | 695 | 7 | 667 | 21 | 31.201999999999998 | 121.4491 | 2020-06-17 04:33:21 | Shanghai, China | ||
2386800 | 2386800 | 2020-06-16 | China | Sichuan | 589 | 3 | 565 | 21 | 30.6171 | 102.7103 | 2020-06-17 04:33:21 | Sichuan, China | ||
287358 | 287358 | 2020-06-15 | China | Shanghai | 695 | 7 | 667 | 21 | 31.202 | 121.4491 | 2020-06-16 04:33:09 | Shanghai, China | ||
287363 | 287363 | 2020-06-15 | China | Sichuan | 588 | 3 | 564 | 21 | 30.6171 | 102.7103 | 2020-06-16 04:33:09 | Sichuan, China | ||
1837314 | 1837314 | 2020-06-14 | China | Sichuan | 587 | 3 | 563 | 21 | 30.6171 | 102.7103 | 2020-06-15 03:33:14 | Sichuan, China | ||
1210923 | 1210923 | 2020-06-09 | China | Sichuan | 582 | 3 | 558 | 21 | 30.6171 | 102.7103 | 2020-06-10 04:07:00 | Sichuan, China | ||
217350 | 217350 | 2020-06-08 | China | Sichuan | 582 | 3 | 558 | 21 | 30.6171 | 102.7103 | 2020-06-09 03:33:03 | Sichuan, China | ||
573992 | 573992 | 2020-06-06 | China | Inner Mongolia | 235 | 1 | 213 | 21 | 44.0935 | 113.9448 | 2020-06-07 03:53:30 | Inner Mongolia, China | ||
1269689 | 1269689 | 2020-06-05 | China | Inner Mongolia | 235 | 1 | 213 | 21 | 44.0935 | 113.9448 | 2020-06-06 02:33:00 | Inner Mongolia, China | ||
1281165 | 1281165 | 2020-06-04 | China | Inner Mongolia | 235 | 1 | 213 | 21 | 44.0935 | 113.9448 | 2020-06-05 02:33:06 | Inner Mongolia, China | ||
3330947 | 3330947 | 2020-05-11 | China | Jilin | 127 | 1 | 105 | 21 | 43.6661 | 126.1923 | 2020-05-12 03:32:27 | Jilin, China | ||
3459562 | 3459562 | 2020-05-10 | China | Jilin | 127 | 1 | 105 | 21 | 43.6661 | 126.1923 | 2020-05-11 02:32:30 | Jilin, China | ||
2043287 | 2043287 | 2020-05-02 | China | Shanxi | 197 | 0 | 176 | 21 | 37.5777 | 112.2922 | 2020-05-03 02:32:28 | Shanxi, China | ||
522280 | 522280 | 2020-04-21 | China | Macau | 45 | 0 | 24 | 21 | 22.1667 | 113.55 | 2020-04-21 11:31:51 | Macau, China | ||
522308 | 522308 | 2020-04-21 | China | Shaanxi | 277 | 3 | 253 | 21 | 35.1917 | 108.8701 | 2020-04-21 03:01:26 | Shaanxi, China | ||
418788 | 418788 | 2020-04-18 | China | Zhejiang | 1268 | 1 | 1246 | 21 | 29.1832 | 120.0934 | 2020-04-17 02:46:34 | Zhejiang, China | ||
50260 | 50260 | 2020-04-17 | China | Zhejiang | 1268 | 1 | 1246 | 21 | 29.1832 | 120.0934 | 2020-04-17 02:46:34 | Zhejiang, China | ||
860078 | 860078 | 2020-04-15 | China | Fujian | 353 | 1 | 331 | 21 | 26.0789 | 117.9874 | 2020-04-15 01:53:31 | Fujian, China | ||
3562036 | 3562036 | 2020-04-08 | China | Shandong | 783 | 7 | 755 | 21 | 36.3427 | 118.1498 | 2020-04-08 01:47:35 | Shandong, China | ||
919102 | 919102 | 2020-03-26 | China | Macau | 31 | 0 | 10 | 21 | 22.1667 | 113.55 | 2020-03-26 03:08:32 | Macau, 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]);