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-11-08" 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-11-08 China Anhui     991 6 985 0 31.8257 117.2264 2020-11-09 05:25:45 Anhui, China
2020-11-08 China Beijing     945 9 929 7 40.1824 116.4142 2020-11-09 05:25:45 Beijing, China
2020-11-08 China Chongqing     589 6 580 3 30.0572 107.874 2020-11-09 05:25:45 Chongqing, China
2020-11-08 China Fujian     456 1 419 36 26.0789 117.9874 2020-11-09 05:25:45 Fujian, China
2020-11-08 China Gansu     180 2 176 2 35.7518 104.2861 2020-11-09 05:25:45 Gansu, China
2020-11-08 China Guangdong     1949 8 1904 37 23.3417 113.4244 2020-11-09 05:25:45 Guangdong, China
2020-11-08 China Guangxi     260 2 258 0 23.8298 108.7881 2020-11-09 05:25:45 Guangxi, China
2020-11-08 China Guizhou     147 2 145 0 26.8154 106.8748 2020-11-09 05:25:45 Guizhou, China
2020-11-08 China Hainan     171 6 165 0 19.1959 109.7453 2020-11-09 05:25:45 Hainan, China
2020-11-08 China Hebei     373 6 361 6 37.8957 114.9042 2020-11-09 05:25:45 Hebei, China
2020-11-08 China Heilongjiang     949 13 935 1 47.862 127.7615 2020-11-09 05:25:45 Heilongjiang, China
2020-11-08 China Henan     1286 22 1258 6 33.882 113.614 2020-11-09 05:25:45 Henan, China
2020-11-08 China Hong Kong     5374 107 5144 123 22.3 114.2 2020-11-09 05:25:45 Hong Kong, China
2020-11-08 China Hubei     68147 4512 63627 8 30.9756 112.2707 2020-11-09 05:25:45 Hubei, China
2020-11-08 China Hunan     1020 4 1015 1 27.6104 111.7088 2020-11-09 05:25:45 Hunan, China
2020-11-08 China Inner Mongolia     305 1 272 32 44.0935 113.9448 2020-11-09 05:25:45 Inner Mongolia, China
2020-11-08 China Jiangsu     675 0 666 9 32.9711 119.455 2020-11-09 05:25:45 Jiangsu, China
2020-11-08 China Jiangxi     935 1 934 0 27.614 115.7221 2020-11-09 05:25:45 Jiangxi, China
2020-11-08 China Jilin     157 2 155 0 43.6661 126.1923 2020-11-09 05:25:45 Jilin, China
2020-11-08 China Liaoning     285 2 279 4 41.2956 122.6085 2020-11-09 05:25:45 Liaoning, China
2020-11-08 China Macau     46 0 46 0 22.1667 113.55 2020-11-09 05:25:45 Macau, China
2020-11-08 China Ningxia     75 0 75 0 37.2692 106.1655 2020-11-09 05:25:45 Ningxia, China
2020-11-08 China Qinghai     18 0 18 0 35.7452 95.9956 2020-11-09 05:25:45 Qinghai, China
2020-11-08 China Shaanxi     478 3 432 43 35.1917 108.8701 2020-11-09 05:25:45 Shaanxi, China
2020-11-08 China Shandong     848 7 839 2 36.3427 118.1498 2020-11-09 05:25:45 Shandong, China
2020-11-08 China Shanghai     1254 7 1143 104 31.202 121.4491 2020-11-09 05:25:45 Shanghai, China
2020-11-08 China Shanxi     218 0 213 5 37.5777 112.2922 2020-11-09 05:25:45 Shanxi, China
2020-11-08 China Sichuan     773 3 727 43 30.6171 102.7103 2020-11-09 05:25:45 Sichuan, China
2020-11-08 China Tianjin     276 3 263 10 39.3054 117.323 2020-11-09 05:25:45 Tianjin, China
2020-11-08 China Tibet     1 0 1 0 31.6927 88.0924 2020-11-09 05:25:45 Tibet, China
2020-11-08 China Xinjiang     980 3 918 59 41.1129 85.2401 2020-11-09 05:25:45 Xinjiang, China
2020-11-08 China Yunnan     214 2 208 4 24.974 101.487 2020-11-09 05:25:45 Yunnan, China
2020-11-08 China Zhejiang     1290 1 1279 10 29.1832 120.0934 2020-11-09 05:25:45 Zhejiang, China
2020-11-08 China Unknown     6151 0 0 0     2020-11-09 05:25:45 Unknown, China

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;