johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where active = 39 and country_or_region = "China" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update (date)
province_or_state 11
country_or_region 1
- China · 53 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1305980 | 1305980 | 2021-07-27 | China | Sichuan | 1145 | 3 | 1103 | 39 | 30.6171 | 102.7103 | 2021-07-28 04:21:39 | Sichuan, China | ||
3218123 | 3218123 | 2021-07-26 | China | Sichuan | 1140 | 3 | 1098 | 39 | 30.6171 | 102.7103 | 2021-07-27 04:21:18 | Sichuan, China | ||
2947181 | 2947181 | 2021-07-16 | China | Sichuan | 1122 | 3 | 1080 | 39 | 30.6171 | 102.7103 | 2021-07-17 04:22:22 | Sichuan, China | ||
295813 | 295813 | 2021-07-15 | China | Fujian | 700 | 1 | 660 | 39 | 26.0789 | 117.9874 | 2021-07-16 04:21:22 | Fujian, China | ||
562797 | 562797 | 2021-06-22 | China | Yunnan | 391 | 2 | 350 | 39 | 24.974 | 101.487 | 2021-06-23 04:21:46 | Yunnan, China | ||
3358499 | 3358499 | 2021-06-21 | China | Yunnan | 391 | 2 | 350 | 39 | 24.974 | 101.487 | 2021-06-22 04:21:34 | Yunnan, China | ||
2884169 | 2884169 | 2021-06-20 | China | Fujian | 652 | 1 | 612 | 39 | 26.0789 | 117.9874 | 2021-06-21 04:21:41 | Fujian, China | ||
2884198 | 2884198 | 2021-06-20 | China | Yunnan | 391 | 2 | 350 | 39 | 24.974 | 101.487 | 2021-06-21 04:21:41 | Yunnan, China | ||
107252 | 107252 | 2021-06-19 | China | Fujian | 651 | 1 | 611 | 39 | 26.0789 | 117.9874 | 2021-06-20 04:21:48 | Fujian, China | ||
1125425 | 1125425 | 2021-06-18 | China | Zhejiang | 1377 | 1 | 1337 | 39 | 29.1832 | 120.0934 | 2021-06-19 04:22:33 | Zhejiang, China | ||
1708142 | 1708142 | 2021-06-02 | China | Zhejiang | 1364 | 1 | 1324 | 39 | 29.1832 | 120.0934 | 2021-06-03 04:23:32 | Zhejiang, China | ||
2103960 | 2103960 | 2021-06-01 | China | Zhejiang | 1364 | 1 | 1324 | 39 | 29.1832 | 120.0934 | 2021-06-02 04:24:34 | Zhejiang, China | ||
1188576 | 1188576 | 2021-05-31 | China | Zhejiang | 1364 | 1 | 1324 | 39 | 29.1832 | 120.0934 | 2021-06-01 04:23:09 | Zhejiang, China | ||
3089253 | 3089253 | 2021-05-30 | China | Zhejiang | 1364 | 1 | 1324 | 39 | 29.1832 | 120.0934 | 2021-05-31 03:08:59 | Zhejiang, China | ||
50622 | 50622 | 2021-05-29 | China | Zhejiang | 1364 | 1 | 1324 | 39 | 29.1832 | 120.0934 | 2021-05-30 04:20:55 | Zhejiang, China | ||
20201 | 20201 | 2021-05-28 | China | Zhejiang | 1364 | 1 | 1324 | 39 | 29.1832 | 120.0934 | 2021-05-29 04:20:41 | Zhejiang, China | ||
2004491 | 2004491 | 2021-05-12 | China | Yunnan | 348 | 2 | 307 | 39 | 24.974 | 101.487 | 2021-05-13 04:20:51 | Yunnan, China | ||
36233 | 36233 | 2021-04-12 | China | Guangdong | 2301 | 8 | 2254 | 39 | 23.3417 | 113.4244 | 2021-04-13 04:20:37 | Guangdong, China | ||
2983060 | 2983060 | 2021-04-10 | China | Guangdong | 2296 | 8 | 2249 | 39 | 23.3417 | 113.4244 | 2021-04-11 04:20:56 | Guangdong, China | ||
3003128 | 3003128 | 2021-04-06 | China | Shanghai | 1904 | 7 | 1858 | 39 | 31.202 | 121.4491 | 2021-04-07 04:20:53 | Shanghai, China | ||
3085103 | 3085103 | 2021-04-05 | China | Guangdong | 2289 | 8 | 2242 | 39 | 23.3417 | 113.4244 | 2021-04-06 04:20:32 | Guangdong, China | ||
637727 | 637727 | 2021-03-31 | China | Guangdong | 2282 | 8 | 2235 | 39 | 23.3417 | 113.4244 | 2021-04-01 04:27:05 | Guangdong, China | ||
3620906 | 3620906 | 2021-03-17 | China | Sichuan | 937 | 3 | 895 | 39 | 30.6171 | 102.7103 | 2021-03-18 05:26:22 | Sichuan, China | ||
702228 | 702228 | 2021-03-16 | China | Shanghai | 1841 | 7 | 1795 | 39 | 31.202 | 121.4491 | 2021-03-17 05:25:07 | Shanghai, China | ||
54630 | 54630 | 2021-03-07 | China | Sichuan | 920 | 3 | 878 | 39 | 30.6171 | 102.7103 | 2021-03-08 05:24:48 | Sichuan, China | ||
3539259 | 3539259 | 2021-02-12 | China | Beijing | 1046 | 9 | 998 | 39 | 40.1824 | 116.4142 | 2021-02-13 05:22:12 | Beijing, China | ||
2637522 | 2637522 | 2021-02-11 | China | Beijing | 1046 | 9 | 998 | 39 | 40.1824 | 116.4142 | 2021-02-12 05:23:29 | Beijing, China | ||
2466609 | 2466609 | 2021-01-22 | China | Guangdong | 2099 | 8 | 2052 | 39 | 23.3417 | 113.4244 | 2021-01-23 05:22:03 | Guangdong, China | ||
1093892 | 1093892 | 2021-01-20 | China | Guangdong | 2094 | 8 | 2047 | 39 | 23.3417 | 113.4244 | 2021-01-21 05:22:01 | Guangdong, China | ||
3308003 | 3308003 | 2021-01-13 | China | Beijing | 999 | 9 | 951 | 39 | 40.1824 | 116.4142 | 2021-01-14 05:22:32 | Beijing, China | ||
2541207 | 2541207 | 2021-01-07 | China | Beijing | 995 | 9 | 947 | 39 | 40.1824 | 116.4142 | 2021-01-08 05:22:42 | Beijing, China | ||
3034111 | 3034111 | 2021-01-05 | China | Hebei | 412 | 6 | 367 | 39 | 37.8957 | 114.9042 | 2021-01-06 05:22:16 | Hebei, China | ||
3230251 | 3230251 | 2021-01-03 | China | Beijing | 992 | 9 | 944 | 39 | 40.1824 | 116.4142 | 2021-01-04 05:22:02 | Beijing, China | ||
927520 | 927520 | 2020-12-21 | China | Sichuan | 843 | 3 | 801 | 39 | 30.6171 | 102.7103 | 2020-12-22 05:22:33 | Sichuan, China | ||
2127820 | 2127820 | 2020-12-17 | China | Sichuan | 839 | 3 | 797 | 39 | 30.6171 | 102.7103 | 2020-12-18 05:28:18 | Sichuan, China | ||
738104 | 738104 | 2020-12-02 | China | Fujian | 490 | 1 | 450 | 39 | 26.0789 | 117.9874 | 2020-12-03 05:28:22 | Fujian, China | ||
923505 | 923505 | 2020-11-26 | China | Shaanxi | 497 | 3 | 455 | 39 | 35.1917 | 108.8701 | 2020-11-27 05:26:53 | Shaanxi, China | ||
923509 | 923509 | 2020-11-26 | China | Sichuan | 801 | 3 | 759 | 39 | 30.6171 | 102.7103 | 2020-11-27 05:26:53 | Sichuan, China | ||
3189791 | 3189791 | 2020-11-22 | China | Fujian | 474 | 1 | 434 | 39 | 26.0789 | 117.9874 | 2020-11-23 05:25:26 | Fujian, China | ||
864573 | 864573 | 2020-11-12 | China | Fujian | 460 | 1 | 420 | 39 | 26.0789 | 117.9874 | 2020-11-13 05:25:30 | Fujian, China | ||
3440618 | 3440618 | 2020-11-11 | China | Fujian | 460 | 1 | 420 | 39 | 26.0789 | 117.9874 | 2020-11-12 05:25:55 | Fujian, China | ||
1988435 | 1988435 | 2020-11-09 | China | Fujian | 459 | 1 | 419 | 39 | 26.0789 | 117.9874 | 2020-11-10 05:40:07 | Fujian, China | ||
2497846 | 2497846 | 2020-11-03 | China | Sichuan | 757 | 3 | 715 | 39 | 30.6171 | 102.7103 | 2020-11-04 05:25:09 | Sichuan, China | ||
1053629 | 1053629 | 2020-10-23 | China | Guangdong | 1904 | 8 | 1857 | 39 | 23.3417 | 113.4244 | 2020-10-24 04:24:46 | Guangdong, China | ||
2191404 | 2191404 | 2020-10-21 | China | Guangdong | 1895 | 8 | 1848 | 39 | 23.3417 | 113.4244 | 2020-10-22 04:24:27 | Guangdong, China | ||
78915 | 78915 | 2020-10-14 | China | Sichuan | 723 | 3 | 681 | 39 | 30.6171 | 102.7103 | 2020-10-15 04:24:28 | Sichuan, China | ||
3781730 | 3781730 | 2020-10-13 | China | Sichuan | 723 | 3 | 681 | 39 | 30.6171 | 102.7103 | 2020-10-14 04:24:05 | Sichuan, China | ||
2728829 | 2728829 | 2020-09-15 | China | Shanghai | 950 | 7 | 904 | 39 | 31.202 | 121.4491 | 2020-09-16 04:22:53 | Shanghai, China | ||
1612067 | 1612067 | 2020-08-14 | China | Liaoning | 261 | 2 | 220 | 39 | 41.2956 | 122.6085 | 2020-08-15 04:27:31 | Liaoning, China | ||
442346 | 442346 | 2020-07-26 | China | Beijing | 929 | 9 | 881 | 39 | 40.1824 | 116.4142 | 2020-07-27 04:35:02 | Beijing, China | ||
2386560 | 2386560 | 2020-06-16 | China | Hong Kong | 1112 | 4 | 1069 | 39 | 22.3 | 114.2 | 2020-06-17 04:33:21 | Hong Kong, China | ||
2110846 | 2110846 | 2020-05-06 | China | Shaanxi | 308 | 3 | 266 | 39 | 35.1917 | 108.8701 | 2020-05-07 02:32:28 | Shaanxi, China | ||
1250139 | 1250139 | 2020-04-10 | China | Fujian | 351 | 1 | 311 | 39 | 26.0789 | 117.9874 | 2020-04-10 01:01:27 | 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]);