daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where province_or_state = "Liaoning" and recovered = 287 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, active, day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-01-02 | China | Liaoning | 362 | 2 | 287 | 73 | 41.2956 | 122.6085 | 2021-01-03 05:22:52 | Liaoning, China | ||
2021-01-01 | China | Liaoning | 359 | 2 | 287 | 70 | 41.2956 | 122.6085 | 2021-01-02 05:22:33 | Liaoning, China | ||
2020-12-31 | China | Liaoning | 351 | 2 | 287 | 62 | 41.2956 | 122.6085 | 2021-01-01 05:23:07 | Liaoning, China | ||
2020-12-30 | China | Liaoning | 347 | 2 | 287 | 58 | 41.2956 | 122.6085 | 2020-12-31 05:22:49 | Liaoning, China | ||
2020-12-29 | China | Liaoning | 342 | 2 | 287 | 53 | 41.2956 | 122.6085 | 2020-12-30 05:22:34 | Liaoning, China | ||
2020-12-28 | China | Liaoning | 337 | 2 | 287 | 48 | 41.2956 | 122.6085 | 2020-12-29 05:22:37 | Liaoning, China | ||
2020-12-27 | China | Liaoning | 329 | 2 | 287 | 40 | 41.2956 | 122.6085 | 2020-12-28 05:22:06 | Liaoning, China | ||
2020-12-26 | China | Liaoning | 323 | 2 | 287 | 34 | 41.2956 | 122.6085 | 2020-12-27 05:22:55 | Liaoning, China | ||
2020-12-25 | China | Liaoning | 316 | 2 | 287 | 27 | 41.2956 | 122.6085 | 2020-12-26 05:22:28 | Liaoning, China | ||
2020-12-24 | China | Liaoning | 310 | 2 | 287 | 21 | 41.2956 | 122.6085 | 2020-12-25 05:22:48 | Liaoning, China | ||
2020-12-23 | China | Liaoning | 302 | 2 | 287 | 13 | 41.2956 | 122.6085 | 2020-12-24 05:23:04 | Liaoning, China | ||
2020-12-22 | China | Liaoning | 295 | 2 | 287 | 6 | 41.2956 | 122.6085 | 2020-12-23 05:22:03 | Liaoning, China | ||
2020-12-21 | China | Liaoning | 294 | 2 | 287 | 5 | 41.2956 | 122.6085 | 2020-12-22 05:22:33 | Liaoning, China | ||
2020-12-20 | China | Liaoning | 292 | 2 | 287 | 3 | 41.2956 | 122.6085 | 2020-12-21 05:27:58 | Liaoning, China | ||
2020-12-19 | China | Liaoning | 291 | 2 | 287 | 2 | 41.2956 | 122.6085 | 2020-12-20 05:27:32 | Liaoning, China | ||
2020-12-18 | China | Liaoning | 290 | 2 | 287 | 1 | 41.2956 | 122.6085 | 2020-12-19 05:27:52 | Liaoning, China | ||
2020-12-17 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-18 05:28:18 | Liaoning, China | ||
2020-12-16 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-17 05:28:12 | Liaoning, China | ||
2020-12-15 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-16 05:28:04 | Liaoning, China | ||
2020-12-14 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-15 05:26:38 | Liaoning, China | ||
2020-12-13 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-14 05:26:27 | Liaoning, China | ||
2020-12-12 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-13 05:27:20 | Liaoning, China | ||
2020-12-11 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-12 05:26:19 | Liaoning, China | ||
2020-12-10 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-11 05:26:59 | Liaoning, China | ||
2020-12-09 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-10 05:26:19 | Liaoning, China | ||
2020-12-08 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-09 05:28:01 | Liaoning, China | ||
2020-12-07 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-08 05:27:42 | Liaoning, China | ||
2020-12-06 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-07 05:26:14 | Liaoning, China | ||
2020-12-05 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-06 05:26:18 | Liaoning, China | ||
2020-12-04 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-05 05:27:36 | Liaoning, China | ||
2020-12-03 | China | Liaoning | 289 | 2 | 287 | 0 | 41.2956 | 122.6085 | 2020-12-04 05:27:27 | Liaoning, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;