johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where country_or_region = "China" and "last_update" is on date 2020-04-24 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 15
country_or_region 1
- China · 31 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3589213 | 3589213 | 2020-04-27 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-04-24 12:04:47 | Anhui, China | ||
3589222 | 3589222 | 2020-04-27 | China | Chongqing | 579 | 6 | 573 | 0 | 30.0572 | 107.874 | 2020-04-24 00:43:27 | Chongqing, China | ||
3589250 | 3589250 | 2020-04-27 | China | Jiangsu | 653 | 0 | 646 | 7 | 32.9711 | 119.455 | 2020-04-24 01:27:14 | Jiangsu, China | ||
3589283 | 3589283 | 2020-04-27 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
3592395 | 3592395 | 2020-04-26 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-04-24 12:04:47 | Anhui, China | ||
3592404 | 3592404 | 2020-04-26 | China | Chongqing | 579 | 6 | 573 | 0 | 30.0572 | 107.874 | 2020-04-24 00:43:27 | Chongqing, China | ||
3592431 | 3592431 | 2020-04-26 | China | Jiangsu | 653 | 0 | 646 | 7 | 32.9711 | 119.455 | 2020-04-24 01:27:14 | Jiangsu, China | ||
3592461 | 3592461 | 2020-04-26 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
3502744 | 3502744 | 2020-04-25 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-04-24 12:04:47 | Anhui, China | ||
3502753 | 3502753 | 2020-04-25 | China | Chongqing | 579 | 6 | 573 | 0 | 30.0572 | 107.874 | 2020-04-24 00:43:27 | Chongqing, China | ||
3502780 | 3502780 | 2020-04-25 | China | Jiangsu | 653 | 0 | 646 | 7 | 32.9711 | 119.455 | 2020-04-24 01:27:14 | Jiangsu, China | ||
3502810 | 3502810 | 2020-04-25 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
1459145 | 1459145 | 2020-04-24 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-04-24 12:04:47 | Anhui, China | ||
1459154 | 1459154 | 2020-04-24 | China | Chongqing | 579 | 6 | 573 | 0 | 30.0572 | 107.874 | 2020-04-24 00:43:27 | Chongqing, China | ||
1459176 | 1459176 | 2020-04-24 | China | Hong Kong | 1035 | 4 | 725 | 306 | 22.3 | 114.2 | 2020-04-24 12:45:30 | Hong Kong, China | ||
1459181 | 1459181 | 2020-04-24 | China | Jiangsu | 653 | 0 | 646 | 7 | 32.9711 | 119.455 | 2020-04-24 01:27:14 | Jiangsu, China | ||
1459211 | 1459211 | 2020-04-24 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
1459221 | 1459221 | 2020-04-24 | China | Zhejiang | 1268 | 1 | 1256 | 11 | 29.1832 | 120.0934 | 2020-04-24 01:36:27 | Zhejiang, China | ||
2524733 | 2524733 | 2020-04-23 | China | Beijing | 593 | 8 | 524 | 61 | 40.1824 | 116.4142 | 2020-04-24 01:36:27 | Beijing, China | ||
2524740 | 2524740 | 2020-04-23 | China | Chongqing | 579 | 6 | 573 | 0 | 30.0572 | 107.874 | 2020-04-24 00:43:27 | Chongqing, China | ||
2524748 | 2524748 | 2020-04-23 | China | Fujian | 355 | 1 | 346 | 8 | 26.0789 | 117.9874 | 2020-04-24 01:43:34 | Fujian, China | ||
2524755 | 2524755 | 2020-04-23 | China | Guangdong | 1585 | 8 | 1528 | 49 | 23.3417 | 113.4244 | 2020-04-24 01:27:14 | Guangdong, China | ||
2524760 | 2524760 | 2020-04-23 | China | Heilongjiang | 928 | 13 | 485 | 430 | 47.862 | 127.7615 | 2020-04-24 01:32:22 | Heilongjiang, China | ||
2524763 | 2524763 | 2020-04-23 | China | Hubei | 68128 | 4512 | 63569 | 47 | 30.9756 | 112.2707 | 2020-04-24 01:35:26 | Hubei, China | ||
2524767 | 2524767 | 2020-04-23 | China | Jiangsu | 653 | 0 | 646 | 7 | 32.9711 | 119.455 | 2020-04-24 01:27:14 | Jiangsu, China | ||
2524769 | 2524769 | 2020-04-23 | China | Jilin | 108 | 1 | 99 | 8 | 43.6661 | 126.1923 | 2020-04-24 00:43:27 | Jilin, China | ||
2524798 | 2524798 | 2020-04-23 | China | Shanghai | 641 | 7 | 533 | 101 | 31.202 | 121.4491 | 2020-04-24 00:43:27 | Shanghai, China | ||
2524800 | 2524800 | 2020-04-23 | China | Sichuan | 561 | 3 | 558 | 0 | 30.6171 | 102.7103 | 2020-04-24 01:27:14 | Sichuan, China | ||
2524809 | 2524809 | 2020-04-23 | China | Yunnan | 184 | 2 | 180 | 2 | 24.974 | 101.487 | 2020-04-24 00:43:27 | Yunnan, China | ||
2524810 | 2524810 | 2020-04-23 | China | Zhejiang | 1268 | 1 | 1256 | 11 | 29.1832 | 120.0934 | 2020-04-24 01:36:27 | Zhejiang, China | ||
2524999 | 2524999 | 2020-04-23 | China | Unknown | 2664 | 0 | 0 | 0 | 2020-04-24 03:30:50 | Unknown, 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]);