johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
75 rows where country_or_region = "China" and "last_update" is on date 2020-03-16 sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 19
country_or_region 1
- China · 75 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2255383 | 2255383 | 2020-03-16 | China | Unknown | 0 | 0 | 0 | 2020-03-16T14:38:45 | ||||||
339724 | 339724 | 2020-03-21 | China | Hainan | 168 | 6 | 161 | 19.1959 | 109.7453 | 2020-03-16T14:38:45 | ||||
1176947 | 1176947 | 2020-03-18 | China | Hainan | 168 | 6 | 161 | 19.1959 | 109.7453 | 2020-03-16T14:38:45 | ||||
1526952 | 1526952 | 2020-03-19 | China | Hainan | 168 | 6 | 161 | 19.1959 | 109.7453 | 2020-03-16T14:38:45 | ||||
2147059 | 2147059 | 2020-03-23 | China | Hainan | 168 | 6 | 161 | 1 | 19.1959 | 109.7453 | 2020-03-16 13:49:01 | Hainan, China | ||
2255168 | 2255168 | 2020-03-16 | China | Hainan | 168 | 6 | 161 | 19.1959 | 109.7453 | 2020-03-16T14:38:45 | ||||
3734008 | 3734008 | 2020-03-20 | China | Hainan | 168 | 6 | 161 | 19.1959 | 109.7453 | 2020-03-16T14:38:45 | ||||
3891372 | 3891372 | 2020-03-17 | China | Hainan | 168 | 6 | 161 | 19.1959 | 109.7453 | 2020-03-16T14:38:45 | ||||
2255282 | 2255282 | 2020-03-16 | China | Macau | 11 | 0 | 10 | 22.1667 | 113.55 | 2020-03-16T00:22:10 | ||||
2255172 | 2255172 | 2020-03-16 | China | Hong Kong | 155 | 4 | 84 | 22.3 | 114.2 | 2020-03-16T14:38:45 | ||||
2255122 | 2255122 | 2020-03-16 | China | Guangdong | 1361 | 8 | 1306 | 23.3417 | 113.4244 | 2020-03-16T01:53:03 | ||||
2255154 | 2255154 | 2020-03-16 | China | Guangxi | 252 | 2 | 248 | 23.8298 | 108.7881 | 2020-03-16T14:38:45 | ||||
339720 | 339720 | 2020-03-21 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
1132546 | 1132546 | 2020-03-25 | China | Yunnan | 176 | 2 | 172 | 2 | 24.974 | 101.487 | 2020-03-16 23:37:18 | Yunnan, China | ||
1176944 | 1176944 | 2020-03-18 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
1479054 | 1479054 | 2020-03-24 | China | Yunnan | 176 | 2 | 172 | 2 | 24.974 | 101.487 | 2020-03-16 23:37:18 | Yunnan, China | ||
1526951 | 1526951 | 2020-03-19 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
2147111 | 2147111 | 2020-03-23 | China | Yunnan | 176 | 2 | 172 | 2 | 24.974 | 101.48700000000001 | 2020-03-16 23:37:18 | Yunnan, China | ||
2255165 | 2255165 | 2020-03-16 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
3734005 | 3734005 | 2020-03-20 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
3891369 | 3891369 | 2020-03-17 | China | Yunnan | 176 | 2 | 172 | 24.974 | 101.487 | 2020-03-16T23:53:02 | ||||
2255176 | 2255176 | 2020-03-16 | China | Guizhou | 146 | 2 | 144 | 26.8154 | 106.8748 | 2020-03-16T14:38:45 | ||||
2255125 | 2255125 | 2020-03-16 | China | Zhejiang | 1231 | 1 | 1216 | 29.1832 | 120.0934 | 2020-03-16T14:38:45 | ||||
2255112 | 2255112 | 2020-03-16 | China | Hubei | 67798 | 3099 | 55142 | 30.9756 | 112.2707 | 2020-03-16T14:38:45 | ||||
2255145 | 2255145 | 2020-03-16 | China | Shanghai | 355 | 3 | 325 | 31.202 | 121.4491 | 2020-03-16T14:38:45 | ||||
2255155 | 2255155 | 2020-03-16 | China | Shaanxi | 245 | 2 | 233 | 35.1917 | 108.8701 | 2020-03-16T14:38:45 | ||||
2255136 | 2255136 | 2020-03-16 | China | Shandong | 760 | 7 | 746 | 36.3427 | 118.1498 | 2020-03-16T14:38:45 | ||||
43124 | 43124 | 2020-04-13 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
50223 | 50223 | 2020-04-17 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
339772 | 339772 | 2020-03-21 | China | Ningxia | 75 | 0 | 75 | 37.2692 | 106.1655 | 2020-03-16T14:38:45 | ||||
418751 | 418751 | 2020-04-18 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
522289 | 522289 | 2020-04-21 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
589061 | 589061 | 2020-04-05 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
809018 | 809018 | 2020-03-27 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
860111 | 860111 | 2020-04-15 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
919111 | 919111 | 2020-03-26 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
934217 | 934217 | 2020-04-16 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
1132514 | 1132514 | 2020-03-25 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
1176990 | 1176990 | 2020-03-18 | China | Ningxia | 75 | 0 | 75 | 37.2692 | 106.1655 | 2020-03-16T14:38:45 | ||||
1199223 | 1199223 | 2020-04-22 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
1250172 | 1250172 | 2020-04-10 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
1385063 | 1385063 | 2020-04-19 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
1459193 | 1459193 | 2020-04-24 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
1479022 | 1479022 | 2020-03-24 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
1526998 | 1526998 | 2020-03-19 | China | Ningxia | 75 | 0 | 75 | 37.2692 | 106.1655 | 2020-03-16T14:38:45 | ||||
2147081 | 2147081 | 2020-03-23 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
2255203 | 2255203 | 2020-03-16 | China | Ningxia | 75 | 0 | 75 | 37.2692 | 106.1655 | 2020-03-16T14:38:45 | ||||
2473371 | 2473371 | 2020-04-20 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
2524779 | 2524779 | 2020-04-23 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
2566987 | 2566987 | 2020-04-11 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
2578150 | 2578150 | 2020-04-12 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:00 | Ningxia, China | ||
3021691 | 3021691 | 2020-04-07 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3338027 | 3338027 | 2020-04-14 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3364750 | 3364750 | 2020-04-01 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3502792 | 3502792 | 2020-04-25 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3562016 | 3562016 | 2020-04-08 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3589262 | 3589262 | 2020-04-27 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3592443 | 3592443 | 2020-04-26 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3734058 | 3734058 | 2020-03-20 | China | Ningxia | 75 | 0 | 75 | 37.2692 | 106.1655 | 2020-03-16T14:38:45 | ||||
3740516 | 3740516 | 2020-04-03 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3815843 | 3815843 | 2020-03-31 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3891402 | 3891402 | 2020-03-17 | China | Ningxia | 75 | 0 | 75 | 37.2692 | 106.1655 | 2020-03-16T14:38:45 | ||||
3949909 | 3949909 | 2020-04-09 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
2255143 | 2255143 | 2020-03-16 | China | Beijing | 452 | 8 | 360 | 40.1824 | 116.4142 | 2020-03-16T14:38:45 | ||||
2255184 | 2255184 | 2020-03-16 | China | Liaoning | 125 | 1 | 115 | 41.2956 | 122.6085 | 2020-03-16T14:38:45 | ||||
339755 | 339755 | 2020-03-21 | China | Jilin | 93 | 1 | 92 | 43.6661 | 126.1923 | 2020-03-16T00:22:10 | ||||
1176972 | 1176972 | 2020-03-18 | China | Jilin | 93 | 1 | 92 | 43.6661 | 126.1923 | 2020-03-16T00:22:10 | ||||
1526985 | 1526985 | 2020-03-19 | China | Jilin | 93 | 1 | 92 | 43.6661 | 126.1923 | 2020-03-16T00:22:10 | ||||
2255195 | 2255195 | 2020-03-16 | China | Jilin | 93 | 1 | 92 | 43.6661 | 126.1923 | 2020-03-16T00:22:10 | ||||
3734040 | 3734040 | 2020-03-20 | China | Jilin | 93 | 1 | 92 | 43.6661 | 126.1923 | 2020-03-16T00:22:10 | ||||
3891395 | 3891395 | 2020-03-17 | China | Jilin | 93 | 1 | 92 | 43.6661 | 126.1923 | 2020-03-16T00:22:10 | ||||
1176989 | 1176989 | 2020-03-18 | China | Inner Mongolia | 75 | 1 | 73 | 44.0935 | 113.9448 | 2020-03-16T14:38:45 | ||||
2255202 | 2255202 | 2020-03-16 | China | Inner Mongolia | 75 | 1 | 73 | 44.0935 | 113.9448 | 2020-03-16T14:38:45 | ||||
3891401 | 3891401 | 2020-03-17 | China | Inner Mongolia | 75 | 1 | 73 | 44.0935 | 113.9448 | 2020-03-16T14:38:45 | ||||
2255142 | 2255142 | 2020-03-16 | China | Heilongjiang | 482 | 13 | 455 | 47.862 | 127.7615 | 2020-03-16T14:38:45 |
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]);