daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

34 rows where country_or_region = "China" and day = "2020-09-05" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

country_or_region 1

  • China · 34 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-09-05 China Anhui     991 6 985 0 31.8257 117.2264 2020-09-06 04:28:33 Anhui, China
2020-09-05 China Beijing     935 9 926 0 40.1824 116.4142 2020-09-06 04:28:33 Beijing, China
2020-09-05 China Chongqing     583 6 577 0 30.0572 107.874 2020-09-06 04:28:33 Chongqing, China
2020-09-05 China Fujian     386 1 372 13 26.0789 117.9874 2020-09-06 04:28:33 Fujian, China
2020-09-05 China Gansu     170 2 167 1 35.7518 104.2861 2020-09-06 04:28:33 Gansu, China
2020-09-05 China Guangdong     1763 8 1727 28 23.3417 113.4244 2020-09-06 04:28:33 Guangdong, China
2020-09-05 China Guangxi     257 2 253 2 23.8298 108.7881 2020-09-06 04:28:33 Guangxi, China
2020-09-05 China Guizhou     147 2 145 0 26.8154 106.8748 2020-09-06 04:28:33 Guizhou, China
2020-09-05 China Hainan     171 6 165 0 19.1959 109.7453 2020-09-06 04:28:33 Hainan, China
2020-09-05 China Hebei     365 6 354 5 37.8957 114.9042 2020-09-06 04:28:33 Hebei, China
2020-09-05 China Heilongjiang     948 13 935 0 47.862 127.7615 2020-09-06 04:28:33 Heilongjiang, China
2020-09-05 China Henan     1276 22 1254 0 33.882 113.614 2020-09-06 04:28:33 Henan, China
2020-09-05 China Hong Kong     4857 94 4493 270 22.3 114.2 2020-09-06 04:28:33 Hong Kong, China
2020-09-05 China Hubei     68139 4512 63627 0 30.9756 112.2707 2020-09-06 04:28:33 Hubei, China
2020-09-05 China Hunan     1019 4 1015 0 27.6104 111.7088 2020-09-06 04:28:33 Hunan, China
2020-09-05 China Inner Mongolia     261 1 259 1 44.0935 113.9448 2020-09-06 04:28:33 Inner Mongolia, China
2020-09-05 China Jiangsu     665 0 661 4 32.9711 119.455 2020-09-06 04:28:33 Jiangsu, China
2020-09-05 China Jiangxi     935 1 934 0 27.614 115.7221 2020-09-06 04:28:33 Jiangxi, China
2020-09-05 China Jilin     157 2 155 0 43.6661 126.1923 2020-09-06 04:28:33 Jilin, China
2020-09-05 China Liaoning     263 2 259 2 41.2956 122.6085 2020-09-06 04:28:33 Liaoning, China
2020-09-05 China Macau     46 0 46 0 22.1667 113.55 2020-09-06 04:28:33 Macau, China
2020-09-05 China Ningxia     75 0 75 0 37.2692 106.1655 2020-09-06 04:28:33 Ningxia, China
2020-09-05 China Qinghai     18 0 18 0 35.7452 95.9956 2020-09-06 04:28:33 Qinghai, China
2020-09-05 China Shaanxi     377 3 360 14 35.1917 108.8701 2020-09-06 04:28:33 Shaanxi, China
2020-09-05 China Shandong     831 7 810 14 36.3427 118.1498 2020-09-06 04:28:33 Shandong, China
2020-09-05 China Shanghai     918 7 866 45 31.202 121.4491 2020-09-06 04:28:33 Shanghai, China
2020-09-05 China Shanxi     203 0 201 2 37.5777 112.2922 2020-09-06 04:28:33 Shanxi, China
2020-09-05 China Sichuan     656 3 634 19 30.6171 102.7103 2020-09-06 04:28:33 Sichuan, China
2020-09-05 China Tianjin     231 3 214 14 39.3054 117.323 2020-09-06 04:28:33 Tianjin, China
2020-09-05 China Tibet     1 0 1 0 31.6927 88.0924 2020-09-06 04:28:33 Tibet, China
2020-09-05 China Xinjiang     902 3 889 10 41.1129 85.2401 2020-09-06 04:28:33 Xinjiang, China
2020-09-05 China Yunnan     201 2 192 7 24.974 101.487 2020-09-06 04:28:33 Yunnan, China
2020-09-05 China Zhejiang     1278 1 1268 9 29.1832 120.0934 2020-09-06 04:28:33 Zhejiang, China
2020-09-05 China Unknown     4491 0 0 0     2020-09-06 04:28:33 Unknown, China

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;