johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
85 rows where country_or_region = "Mainland China" and recovered = 1 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, latitude, longitude, last_update, day (date), last_update (date)
province_or_state 19
country_or_region 1
- Mainland China · 85 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3752991 | 3752991 | 2020-03-10 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
657876 | 657876 | 2020-03-09 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1527383 | 1527383 | 2020-03-08 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
62640 | 62640 | 2020-03-07 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
3177628 | 3177628 | 2020-03-06 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
40270 | 40270 | 2020-03-05 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
98931 | 98931 | 2020-03-04 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
261135 | 261135 | 2020-03-03 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1152743 | 1152743 | 2020-03-02 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
562596 | 562596 | 2020-03-01 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
3205878 | 3205878 | 2020-02-29 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2883997 | 2883997 | 2020-02-28 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
617476 | 617476 | 2020-02-27 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2509829 | 2509829 | 2020-02-26 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
479206 | 479206 | 2020-02-25 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
3551266 | 3551266 | 2020-02-24 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
3173407 | 3173407 | 2020-02-23 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1085696 | 1085696 | 2020-02-22 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2135778 | 2135778 | 2020-02-21 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2263514 | 2263514 | 2020-02-20 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1720106 | 1720106 | 2020-02-19 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1783137 | 1783137 | 2020-02-18 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1243411 | 1243411 | 2020-02-17 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1888764 | 1888764 | 2020-02-16 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
107090 | 107090 | 2020-02-15 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1192509 | 1192509 | 2020-02-14 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
1559715 | 1559715 | 2020-02-13 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2567304 | 2567304 | 2020-02-12 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
566696 | 566696 | 2020-02-06 | Mainland China | Ningxia | 40 | 0 | 1 | 37.2692 | 106.1655 | 2020-02-06T02:13:15 | ||||
2091688 | 2091688 | 2020-02-05 | Mainland China | Ningxia | 34 | 0 | 1 | 37.2692 | 106.1655 | 2020-02-04T02:13:18 | ||||
3471903 | 3471903 | 2020-02-04 | Mainland China | Jilin | 42 | 0 | 1 | 43.6661 | 126.1923 | 2020-02-04T00:23:05 | ||||
3471904 | 3471904 | 2020-02-04 | Mainland China | Inner Mongolia | 35 | 0 | 1 | 44.0935 | 113.9448 | 2020-02-04T03:03:07 | ||||
3471905 | 3471905 | 2020-02-04 | Mainland China | Ningxia | 34 | 0 | 1 | 37.2692 | 106.1655 | 2020-02-04T02:13:18 | ||||
2860555 | 2860555 | 2020-02-03 | Mainland China | Fujian | 179 | 0 | 1 | 26.0789 | 117.9874 | 2020-02-03T11:33:13 | ||||
2860561 | 2860561 | 2020-02-03 | Mainland China | Liaoning | 74 | 0 | 1 | 41.2956 | 122.6085 | 2020-02-03T17:11:34 | ||||
2860564 | 2860564 | 2020-02-03 | Mainland China | Tianjin | 60 | 0 | 1 | 39.3054 | 117.323 | 2020-02-03T13:53:03 | ||||
2860567 | 2860567 | 2020-02-03 | Mainland China | Inner Mongolia | 34 | 0 | 1 | 44.0935 | 113.9448 | 2020-02-03T03:03:09 | ||||
2860568 | 2860568 | 2020-02-03 | Mainland China | Jilin | 31 | 0 | 1 | 43.6661 | 126.1923 | 2020-02-03T00:53:03 | ||||
2860569 | 2860569 | 2020-02-03 | Mainland China | Ningxia | 31 | 0 | 1 | 37.2692 | 106.1655 | 2020-02-03T08:33:03 | ||||
2379247 | 2379247 | 2020-02-02 | Mainland China | Liaoning | 70 | 0 | 1 | 41.2956 | 122.6085 | 2020-02-02T18:03:05 | ||||
2379251 | 2379251 | 2020-02-02 | Mainland China | Tianjin | 48 | 0 | 1 | 39.3054 | 117.323 | 2020-02-02T09:43:01 | ||||
2379254 | 2379254 | 2020-02-02 | Mainland China | Inner Mongolia | 27 | 0 | 1 | 44.0935 | 113.9448 | 2020-02-02T03:43:01 | ||||
2379255 | 2379255 | 2020-02-02 | Mainland China | Jilin | 23 | 0 | 1 | 43.6661 | 126.1923 | 2020-02-02T02:33:02 | ||||
3413159 | 3413159 | 2020-02-01 | Mainland China | Liaoning | 64 | 0 | 1 | 41.2956 | 122.6085 | 2/1/2020 15:23 | ||||
3413160 | 3413160 | 2020-02-01 | Mainland China | Hainan | 62 | 1 | 1 | 19.1959 | 109.7453 | 2/1/2020 8:43 | ||||
3413161 | 3413161 | 2020-02-01 | Mainland China | Shanxi | 47 | 0 | 1 | 37.5777 | 112.2922 | 2/1/2020 1:52 | ||||
3413166 | 3413166 | 2020-02-01 | Mainland China | Inner Mongolia | 23 | 0 | 1 | 44.0935 | 113.9448 | 2/1/2020 5:37 | ||||
3413170 | 3413170 | 2020-02-01 | Mainland China | Jilin | 17 | 0 | 1 | 43.6661 | 126.1923 | 2/1/2020 1:52 | ||||
3761182 | 3761182 | 2020-01-31 | Mainland China | Chongqing | 211 | 0 | 1 | 30.0572 | 107.874 | 1/31/2020 23:59 | ||||
3761184 | 3761184 | 2020-01-31 | Mainland China | Sichuan | 177 | 1 | 1 | 30.6171 | 102.7103 | 1/31/2020 23:59 | ||||
3761191 | 3761191 | 2020-01-31 | Mainland China | Yunnan | 83 | 0 | 1 | 24.974 | 101.487 | 1/31/2020 23:59 | ||||
3761194 | 3761194 | 2020-01-31 | Mainland China | Hainan | 52 | 1 | 1 | 19.1959 | 109.7453 | 1/31/2020 23:59 | ||||
3761195 | 3761195 | 2020-01-31 | Mainland China | Liaoning | 48 | 0 | 1 | 41.2956 | 122.6085 | 1/31/2020 23:59 | ||||
3761196 | 3761196 | 2020-01-31 | Mainland China | Shanxi | 39 | 0 | 1 | 37.5777 | 112.2922 | 1/31/2020 23:59 | ||||
3761201 | 3761201 | 2020-01-31 | Mainland China | Inner Mongolia | 20 | 0 | 1 | 44.0935 | 113.9448 | 1/31/2020 23:59 | ||||
3761203 | 3761203 | 2020-01-31 | Mainland China | Jilin | 14 | 0 | 1 | 43.6661 | 126.1923 | 1/31/2020 23:59 | ||||
1527496 | 1527496 | 2020-01-30 | Mainland China | Chongqing | 182 | 0 | 1 | 30.0572 | 107.874 | 1/30/20 16:00 | ||||
1527498 | 1527498 | 2020-01-30 | Mainland China | Shandong | 158 | 0 | 1 | 36.3427 | 118.1498 | 1/30/20 16:00 | ||||
1527499 | 1527499 | 2020-01-30 | Mainland China | Sichuan | 142 | 1 | 1 | 30.6171 | 102.7103 | 1/30/20 16:00 | ||||
1527500 | 1527500 | 2020-01-30 | Mainland China | Jiangsu | 129 | 0 | 1 | 32.9711 | 119.455 | 1/30/20 16:00 | ||||
1527508 | 1527508 | 2020-01-30 | Mainland China | Hainan | 46 | 1 | 1 | 19.1959 | 109.7453 | 1/30/20 16:00 | ||||
1527510 | 1527510 | 2020-01-30 | Mainland China | Liaoning | 41 | 0 | 1 | 41.2956 | 122.6085 | 1/30/20 16:00 | ||||
1527511 | 1527511 | 2020-01-30 | Mainland China | Shanxi | 35 | 0 | 1 | 37.5777 | 112.2922 | 1/30/20 16:00 | ||||
1527516 | 1527516 | 2020-01-30 | Mainland China | Jilin | 14 | 0 | 1 | 43.6661 | 126.1923 | 1/30/20 16:00 | ||||
1527518 | 1527518 | 2020-01-30 | Mainland China | Guizhou | 12 | 0 | 1 | 26.8154 | 106.8748 | 1/30/20 16:00 | ||||
197842 | 197842 | 2020-01-29 | Mainland China | Henan | 206 | 2 | 1 | 33.882 | 113.614 | 1/29/20 19:30 | ||||
197844 | 197844 | 2020-01-29 | Mainland China | Chongqing | 147 | 0 | 1 | 30.0572 | 107.874 | 1/29/20 19:30 | ||||
197845 | 197845 | 2020-01-29 | Mainland China | Shandong | 130 | 0 | 1 | 36.3427 | 118.1498 | 1/29/20 19:30 | ||||
197848 | 197848 | 2020-01-29 | Mainland China | Sichuan | 108 | 1 | 1 | 30.6171 | 102.7103 | 1/29/20 19:30 | ||||
197849 | 197849 | 2020-01-29 | Mainland China | Jiangsu | 99 | 0 | 1 | 32.9711 | 119.455 | 1/29/20 19:30 | ||||
197857 | 197857 | 2020-01-29 | Mainland China | Liaoning | 39 | 0 | 1 | 41.2956 | 122.6085 | 1/29/20 19:30 | ||||
197860 | 197860 | 2020-01-29 | Mainland China | Shanxi | 27 | 0 | 1 | 37.5777 | 112.2922 | 1/29/20 19:30 | ||||
197866 | 197866 | 2020-01-29 | Mainland China | Guizhou | 9 | 0 | 1 | 26.8154 | 106.8748 | 1/29/20 19:30 | ||||
1305765 | 1305765 | 2020-01-28 | Mainland China | Jiangsu | 70 | 0 | 1 | 32.9711 | 119.455 | 1/28/20 23:00 | ||||
3753058 | 3753058 | 2020-01-27 | Mainland China | Zhejiang | 128 | 0 | 1 | 29.1832 | 120.0934 | 1/27/20 23:59 | ||||
3753069 | 3753069 | 2020-01-27 | Mainland China | Jiangsu | 47 | 0 | 1 | 32.9711 | 119.455 | 1/27/20 23:59 | ||||
415833 | 415833 | 2020-01-26 | Mainland China | Zhejiang | 104 | 0 | 1 | 29.1832 | 120.0934 | 1/26/20 16:00 | ||||
415841 | 415841 | 2020-01-26 | Mainland China | Shanghai | 40 | 1 | 1 | 31.202 | 121.4491 | 1/26/20 16:00 | ||||
415845 | 415845 | 2020-01-26 | Mainland China | Jiangsu | 33 | 0 | 1 | 32.9711 | 119.455 | 1/26/20 16:00 | ||||
2938934 | 2938934 | 2020-01-25 | Mainland China | Zhejiang | 62 | 0 | 1 | 29.1832 | 120.0934 | 1/25/20 17:00 | ||||
2938939 | 2938939 | 2020-01-25 | Mainland China | Shanghai | 33 | 0 | 1 | 31.202 | 121.4491 | 1/25/20 17:00 | ||||
2938947 | 2938947 | 2020-01-25 | Mainland China | Jiangsu | 18 | 0 | 1 | 32.9711 | 119.455 | 1/25/20 17:00 | ||||
197761 | 197761 | 2020-01-24 | Mainland China | Zhejiang | 43 | 0 | 1 | 29.1832 | 120.0934 | 1/24/20 17:00 | ||||
197762 | 197762 | 2020-01-24 | Mainland China | Beijing | 36 | 0 | 1 | 40.1824 | 116.4142 | 1/24/20 17:00 | ||||
197766 | 197766 | 2020-01-24 | Mainland China | Shanghai | 20 | 0 | 1 | 31.202 | 121.4491 | 1/24/20 17:00 |
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]);