johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where country_or_region = "China" and recovered = 133 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- China · 47 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3793341 | 3793341 | 2020-08-05 | China | Xinjiang | 773 | 3 | 133 | 637 | 41.1129 | 85.2401 | 2020-08-06 04:35:02 | Xinjiang, China | ||
2548219 | 2548219 | 2020-05-27 | China | Jilin | 155 | 2 | 133 | 20 | 43.6661 | 126.1923 | 2020-05-28 02:32:31 | Jilin, China | ||
2566977 | 2566977 | 2020-04-11 | China | Liaoning | 145 | 2 | 133 | 10 | 41.2956 | 122.6085 | 2020-04-11 00:29:01 | Liaoning, China | ||
3561984 | 3561984 | 2020-04-08 | China | Gansu | 139 | 2 | 133 | 4 | 37.8099 | 101.0583 | 2020-04-08 03:06:39 | Gansu, China | ||
3021713 | 3021713 | 2020-04-07 | China | Shanxi | 138 | 0 | 133 | 5 | 37.5777 | 112.2922 | 2020-04-05 00:58:54 | Shanxi, China | ||
3627395 | 3627395 | 2020-04-06 | China | Shanxi | 138 | 0 | 133 | 5 | 37.5777 | 112.2922 | 4/5/20 0:58 | Shanxi, China | ||
589083 | 589083 | 2020-04-05 | China | Shanxi | 138 | 0 | 133 | 5 | 37.5777 | 112.2922 | 2020-04-05 00:58:54 | Shanxi, China | ||
1750726 | 1750726 | 2020-04-04 | China | Shanxi | 137 | 0 | 133 | 4 | 37.5777 | 112.2922 | 3/31/20 23:35 | Shanxi, China | ||
3740537 | 3740537 | 2020-04-03 | China | Shanxi | 137 | 0 | 133 | 4 | 37.5777 | 112.2922 | 2020-03-31 23:35:56 | Shanxi, China | ||
3701567 | 3701567 | 2020-04-02 | China | Shanxi | 137 | 0 | 133 | 4 | 37.5777 | 112.2922 | 3/31/20 23:35 | Shanxi, China | ||
3364771 | 3364771 | 2020-04-01 | China | Shanxi | 137 | 0 | 133 | 4 | 37.5777 | 112.2922 | 2020-03-31 23:35:56 | Shanxi, China | ||
3815864 | 3815864 | 2020-03-31 | China | Shanxi | 136 | 0 | 133 | 3 | 37.5777 | 112.2922 | 2020-03-29 00:20:15 | Shanxi, China | ||
1872416 | 1872416 | 2020-03-30 | China | Shanxi | 136 | 0 | 133 | 3 | 37.5777 | 112.2922 | 3/29/20 0:20 | Shanxi, China | ||
1872422 | 1872422 | 2020-03-30 | China | Tianjin | 174 | 3 | 133 | 38 | 39.3054 | 117.323 | 3/30/20 8:42 | Tianjin, China | ||
2875653 | 2875653 | 2020-03-29 | China | Shanxi | 136 | 0 | 133 | 3 | 37.5777 | 112.2922 | 3/29/20 0:20 | Shanxi, China | ||
2875659 | 2875659 | 2020-03-29 | China | Tianjin | 166 | 3 | 133 | 30 | 39.3054 | 117.323 | 3/29/20 6:13 | Tianjin, China | ||
3946989 | 3946989 | 2020-03-28 | China | Shanxi | 135 | 0 | 133 | 2 | 37.5777 | 112.2922 | 3/25/20 23:21 | Shanxi, China | ||
3946995 | 3946995 | 2020-03-28 | China | Tianjin | 161 | 3 | 133 | 25 | 39.3054 | 117.323 | 3/28/20 8:36 | Tianjin, China | ||
809039 | 809039 | 2020-03-27 | China | Shanxi | 135 | 0 | 133 | 2 | 37.5777 | 112.2922 | 2020-03-25 23:21:31 | Shanxi, China | ||
809045 | 809045 | 2020-03-27 | China | Tianjin | 155 | 3 | 133 | 19 | 39.3054 | 117.323 | 2020-03-27 10:48:42 | Tianjin, China | ||
919132 | 919132 | 2020-03-26 | China | Shanxi | 135 | 0 | 133 | 2 | 37.5777 | 112.2922 | 2020-03-25 23:21:31 | Shanxi, China | ||
919138 | 919138 | 2020-03-26 | China | Tianjin | 151 | 3 | 133 | 15 | 39.3054 | 117.323 | 2020-03-26 04:38:20 | Tianjin, China | ||
1132534 | 1132534 | 2020-03-25 | China | Shanxi | 134 | 0 | 133 | 1 | 37.5777 | 112.2922 | 2020-03-23 23:25:43 | Shanxi, China | ||
1132540 | 1132540 | 2020-03-25 | China | Tianjin | 145 | 3 | 133 | 9 | 39.3054 | 117.323 | 2020-03-24 14:16:21 | Tianjin, China | ||
1479042 | 1479042 | 2020-03-24 | China | Shanxi | 134 | 0 | 133 | 1 | 37.5777 | 112.2922 | 2020-03-23 23:25:43 | Shanxi, China | ||
1479048 | 1479048 | 2020-03-24 | China | Tianjin | 145 | 3 | 133 | 9 | 39.3054 | 117.323 | 2020-03-24 14:16:21 | Tianjin, China | ||
2147099 | 2147099 | 2020-03-23 | China | Shanxi | 133 | 0 | 133 | 0 | 37.5777 | 112.2922 | 2020-03-13 08:56:40 | Shanxi, China | ||
2147105 | 2147105 | 2020-03-23 | China | Tianjin | 141 | 3 | 133 | 5 | 39.3054 | 117.323 | 2020-03-23 03:57:57 | Tianjin, China | ||
2910622 | 2910622 | 2020-03-22 | China | Tianjin | 137 | 3 | 133 | 1 | 39.3054 | 117.323 | 3/20/20 4:33 | Tianjin, China | ||
2910631 | 2910631 | 2020-03-22 | China | Shanxi | 133 | 0 | 133 | 0 | 37.5777 | 112.2922 | 3/13/20 8:56 | Shanxi, China | ||
339737 | 339737 | 2020-03-21 | China | Tianjin | 137 | 3 | 133 | 39.3054 | 117.323 | 2020-03-19T23:43:03 | ||||
339740 | 339740 | 2020-03-21 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
3734018 | 3734018 | 2020-03-20 | China | Tianjin | 137 | 3 | 133 | 39.3054 | 117.323 | 2020-03-19T23:43:03 | ||||
3734025 | 3734025 | 2020-03-20 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
1526962 | 1526962 | 2020-03-19 | China | Tianjin | 137 | 3 | 133 | 39.3054 | 117.323 | 2020-03-19T23:43:03 | ||||
1526964 | 1526964 | 2020-03-19 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
1176956 | 1176956 | 2020-03-18 | China | Tianjin | 136 | 3 | 133 | 39.3054 | 117.323 | 2020-03-15T18:20:18 | ||||
1176958 | 1176958 | 2020-03-18 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
3891381 | 3891381 | 2020-03-17 | China | Tianjin | 136 | 3 | 133 | 39.3054 | 117.323 | 2020-03-15T18:20:18 | ||||
3891383 | 3891383 | 2020-03-17 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
2255178 | 2255178 | 2020-03-16 | China | Tianjin | 136 | 3 | 133 | 39.3054 | 117.323 | 2020-03-15T18:20:18 | ||||
2255183 | 2255183 | 2020-03-16 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
1463515 | 1463515 | 2020-03-15 | China | Tianjin | 136 | 3 | 133 | 39.3054 | 117.323 | 2020-03-15T18:20:18 | ||||
1463519 | 1463519 | 2020-03-15 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
2111140 | 2111140 | 2020-03-14 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
3765307 | 3765307 | 2020-03-13 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
2127472 | 2127472 | 2020-03-11 | China | Guizhou | 146 | 2 | 133 | 26.8154 | 106.8748 | 2020-03-11T02:33:03 |
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]);