johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where country_or_region = "China" and recovered = 259 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 4
- Inner Mongolia 29
- Liaoning 9
- Guangxi 2
- Tianjin 1
country_or_region 1
- China · 41 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2537201 | 2537201 | 2020-12-01 | China | Guangxi | 263 | 2 | 259 | 2 | 23.8298 | 108.7881 | 2020-12-02 05:27:41 | Guangxi, China | ||
1583970 | 1583970 | 2020-11-30 | China | Guangxi | 263 | 2 | 259 | 2 | 23.8298 | 108.7881 | 2020-12-01 05:26:18 | Guangxi, China | ||
891948 | 891948 | 2020-11-05 | China | Tianjin | 275 | 3 | 259 | 13 | 39.3054 | 117.323 | 2020-11-06 05:24:55 | Tianjin, China | ||
1045631 | 1045631 | 2020-09-30 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-10-01 04:23:42 | Inner Mongolia, China | ||
966712 | 966712 | 2020-09-29 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-09-30 04:23:33 | Inner Mongolia, China | ||
1515209 | 1515209 | 2020-09-28 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-09-29 04:23:42 | Inner Mongolia, China | ||
2581797 | 2581797 | 2020-09-27 | China | Inner Mongolia | 266 | 1 | 259 | 6 | 44.0935 | 113.9448 | 2020-09-28 04:23:00 | Inner Mongolia, China | ||
2613849 | 2613849 | 2020-09-26 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-27 04:23:00 | Inner Mongolia, China | ||
2812564 | 2812564 | 2020-09-25 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-26 04:23:00 | Inner Mongolia, China | ||
2605841 | 2605841 | 2020-09-24 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-25 04:23:00 | Inner Mongolia, China | ||
2653584 | 2653584 | 2020-09-23 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-24 04:23:00 | Inner Mongolia, China | ||
3316033 | 3316033 | 2020-09-22 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-23 04:23:00 | Inner Mongolia, China | ||
2836632 | 2836632 | 2020-09-21 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-22 04:23:00 | Inner Mongolia, China | ||
3093237 | 3093237 | 2020-09-20 | China | Inner Mongolia | 263 | 1 | 259 | 3 | 44.0935 | 113.9448 | 2020-09-21 04:23:00 | Inner Mongolia, China | ||
2454587 | 2454587 | 2020-09-19 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-20 04:22:00 | Inner Mongolia, China | ||
2848656 | 2848656 | 2020-09-18 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-19 04:22:00 | Inner Mongolia, China | ||
1121405 | 1121405 | 2020-09-17 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-18 05:05:00 | Inner Mongolia, China | ||
666094 | 666094 | 2020-09-16 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-17 04:22:00 | Inner Mongolia, China | ||
2728819 | 2728819 | 2020-09-15 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-16 04:22:53 | Inner Mongolia, China | ||
344091 | 344091 | 2020-09-14 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-15 03:22:50 | Inner Mongolia, China | ||
2868530 | 2868530 | 2020-09-13 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-14 04:26:00 | Inner Mongolia, China | ||
546569 | 546569 | 2020-09-12 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-13 04:30:52 | Inner Mongolia, China | ||
1444398 | 1444398 | 2020-09-11 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-12 04:25:05 | Inner Mongolia, China | ||
1172999 | 1172999 | 2020-09-10 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-11 04:46:23 | Inner Mongolia, China | ||
2171364 | 2171364 | 2020-09-09 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-10 04:29:01 | Inner Mongolia, China | ||
1243573 | 1243573 | 2020-09-08 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-09 04:28:48 | Inner Mongolia, China | ||
427152 | 427152 | 2020-09-07 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-08 04:28:25 | Inner Mongolia, China | ||
3161437 | 3161437 | 2020-09-06 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-07 04:28:30 | Inner Mongolia, China | ||
3161441 | 3161441 | 2020-09-06 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-07 04:28:30 | Liaoning, China | ||
813392 | 813392 | 2020-09-05 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-06 04:28:33 | Inner Mongolia, China | ||
813396 | 813396 | 2020-09-05 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-06 04:28:33 | Liaoning, China | ||
2661592 | 2661592 | 2020-09-04 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-05 04:28:19 | Inner Mongolia, China | ||
2661596 | 2661596 | 2020-09-04 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-05 04:28:19 | Liaoning, China | ||
1354132 | 1354132 | 2020-09-03 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-04 04:28:26 | Inner Mongolia, China | ||
1354136 | 1354136 | 2020-09-03 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-04 04:28:26 | Liaoning, China | ||
1105369 | 1105369 | 2020-09-02 | China | Inner Mongolia | 261 | 1 | 259 | 1 | 44.0935 | 113.9448 | 2020-09-03 04:28:22 | Inner Mongolia, China | ||
1105373 | 1105373 | 2020-09-02 | China | Liaoning | 263 | 2 | 259 | 2 | 41.2956 | 122.6085 | 2020-09-03 04:28:22 | Liaoning, China | ||
2059702 | 2059702 | 2020-09-01 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-09-02 04:28:25 | Liaoning, China | ||
193887 | 193887 | 2020-08-31 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-09-01 04:28:31 | Liaoning, China | ||
3931846 | 3931846 | 2020-08-30 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-08-31 04:28:27 | Liaoning, China | ||
609508 | 609508 | 2020-08-29 | China | Liaoning | 262 | 2 | 259 | 1 | 41.2956 | 122.6085 | 2020-08-30 04:28:22 | Liaoning, China |
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]);