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 "last_update" is on date 2020-06-21 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-06-20 China Anhui     991 6 985 0 31.8257 117.2264 2020-06-21 04:33:19 Anhui, China
2020-06-20 China Beijing     821 9 584 228 40.1824 116.4142 2020-06-21 04:33:19 Beijing, China
2020-06-20 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-21 04:33:19 Chongqing, China
2020-06-20 China Fujian     363 1 357 5 26.0789 117.9874 2020-06-21 04:33:19 Fujian, China
2020-06-20 China Gansu     151 2 137 12 35.7518 104.2861 2020-06-21 04:33:19 Gansu, China
2020-06-20 China Guangdong     1634 8 1614 12 23.3417 113.4244 2020-06-21 04:33:19 Guangdong, China
2020-06-20 China Guangxi     254 2 252 0 23.8298 108.7881 2020-06-21 04:33:19 Guangxi, China
2020-06-20 China Guizhou     147 2 145 0 26.8154 106.8748 2020-06-21 04:33:19 Guizhou, China
2020-06-20 China Hainan     171 6 163 2 19.1959 109.7453 2020-06-21 04:33:19 Hainan, China
2020-06-20 China Hebei     344 6 322 16 37.8957 114.9042 2020-06-21 04:33:19 Hebei, China
2020-06-20 China Heilongjiang     947 13 934 0 47.861999999999995 127.7615 2020-06-21 04:33:19 Heilongjiang, China
2020-06-20 China Henan     1276 22 1254 0 33.882 113.61399999999999 2020-06-21 04:33:19 Henan, China
2020-06-20 China Hong Kong     1128 4 1077 46 22.3 114.2 2020-06-21 04:33:19 Hong Kong, China
2020-06-20 China Hubei     68135 4512 63623 0 30.9756 112.2707 2020-06-21 04:33:19 Hubei, China
2020-06-20 China Hunan     1019 4 1015 0 27.6104 111.7088 2020-06-21 04:33:19 Hunan, China
2020-06-20 China Inner Mongolia     238 1 235 2 44.0935 113.9448 2020-06-21 04:33:19 Inner Mongolia, China
2020-06-20 China Jiangsu     653 0 653 0 32.9711 119.455 2020-06-21 04:33:19 Jiangsu, China
2020-06-20 China Jiangxi     932 1 931 0 27.614 115.7221 2020-06-21 04:33:19 Jiangxi, China
2020-06-20 China Jilin     155 2 153 0 43.6661 126.1923 2020-06-21 04:33:19 Jilin, China
2020-06-20 China Liaoning     153 2 147 4 41.2956 122.6085 2020-06-21 04:33:19 Liaoning, China
2020-06-20 China Macau     45 0 45 0 22.1667 113.55 2020-06-21 04:33:19 Macau, China
2020-06-20 China Ningxia     75 0 75 0 37.2692 106.1655 2020-06-21 04:33:19 Ningxia, China
2020-06-20 China Qinghai     18 0 18 0 35.7452 95.9956 2020-06-21 04:33:19 Qinghai, China
2020-06-20 China Shaanxi     316 3 306 7 35.1917 108.8701 2020-06-21 04:33:19 Shaanxi, China
2020-06-20 China Shandong     792 7 785 0 36.3427 118.1498 2020-06-21 04:33:19 Shandong, China
2020-06-20 China Shanghai     698 7 668 23 31.201999999999998 121.4491 2020-06-21 04:33:19 Shanghai, China
2020-06-20 China Shanxi     198 0 198 0 37.5777 112.2922 2020-06-21 04:33:19 Shanxi, China
2020-06-20 China Sichuan     589 3 570 16 30.6171 102.7103 2020-06-21 04:33:19 Sichuan, China
2020-06-20 China Tianjin     197 3 191 3 39.3054 117.323 2020-06-21 04:33:19 Tianjin, China
2020-06-20 China Tibet     1 0 1 0 31.6927 88.0924 2020-06-21 04:33:19 Tibet, China
2020-06-20 China Xinjiang     76 3 73 0 41.1129 85.2401 2020-06-21 04:33:19 Xinjiang, China
2020-06-20 China Yunnan     185 2 183 0 24.974 101.48700000000001 2020-06-21 04:33:19 Yunnan, China
2020-06-20 China Zhejiang     1269 1 1267 1 29.1832 120.0934 2020-06-21 04:33:19 Zhejiang, China
2020-06-20 China Unknown     3481 0 0 0     2020-06-21 04:33:19 Unknown, China

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;