daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where combined_key = "Chile" and country_or_region = "Chile" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-13 | Chile | 7525 | 82 | 2367 | 5076 | -35.6751 | -71.543 | 2020-04-13 23:07:34 | Chile | |||
2020-04-17 | Chile | 9252 | 116 | 3621 | 5515 | -35.6751 | -71.543 | 2020-04-17 23:30:32 | Chile | |||
2020-05-08 | Chile | 25972 | 294 | 12160 | 13518 | -35.6751 | -71.543 | 2020-05-09 02:32:35 | Chile | |||
2020-04-29 | Chile | 14885 | 216 | 8057 | 6612 | -35.6751 | -71.543 | 2020-04-30 02:32:27 | Chile | |||
2020-04-30 | Chile | 16023 | 227 | 8580 | 7216 | -35.6751 | -71.543 | 2020-05-01 02:32:28 | Chile | |||
2020-04-28 | Chile | 14365 | 207 | 7710 | 6448 | -35.6751 | -71.543 | 2020-04-29 02:32:29 | Chile | |||
2020-04-18 | Chile | 9730 | 126 | 4035 | 5569 | -35.6751 | -71.543 | 2020-04-18 22:32:28 | Chile | |||
2020-04-21 | Chile | 10832 | 147 | 4969 | 5716 | -35.6751 | -71.543 | 2020-04-21 23:30:30 | Chile | |||
2020-04-05 | Chile | 4471 | 34 | 618 | 3819 | -35.6751 | -71.543 | 2020-04-05 23:06:26 | Chile | |||
2020-03-27 | Chile | 1610 | 5 | 43 | 1562 | -35.6751 | -71.543 | 2020-03-27 23:23:03 | Chile | |||
2020-04-15 | Chile | 8273 | 94 | 2937 | 5242 | -35.6751 | -71.543 | 2020-04-15 22:56:32 | Chile | |||
2020-03-26 | Chile | 1306 | 4 | 22 | 1280 | -35.6751 | -71.543 | 2020-03-26 23:48:18 | Chile | |||
2020-04-16 | Chile | 8807 | 105 | 3299 | 5403 | -35.6751 | -71.543 | 2020-04-16 23:30:31 | Chile | |||
2020-03-25 | Chile | 1142 | 3 | 22 | 1117 | -35.6751 | -71.543 | 2020-03-25 23:33:04 | Chile | |||
2020-05-01 | Chile | 17008 | 234 | 9018 | 7756 | -35.6751 | -71.543 | 2020-05-02 02:32:27 | Chile | |||
2020-04-22 | Chile | 11296 | 160 | 5386 | 5750 | -35.6751 | -71.543 | 2020-04-22 23:30:32 | Chile | |||
2020-04-10 | Chile | 6501 | 65 | 1571 | 4865 | -35.6751 | -71.543 | 2020-04-10 22:53:48 | Chile | |||
2020-04-19 | Chile | 10088 | 133 | 4338 | 5617 | -35.6751 | -71.543 | 2020-04-19 23:40:41 | Chile | |||
2020-05-14 | Chile | 37040 | 368 | 15655 | 21017 | -35.6751 | -71.543 | 2020-05-15 02:33:02 | Chile | |||
2020-04-24 | Chile | 12306 | 174 | 6327 | 5805 | -35.6751 | -71.543 | 2020-04-25 06:30:33 | Chile | |||
2020-03-24 | Chile | 922 | 2 | 17 | 903 | -35.6751 | -71.543 | 2020-03-24 23:37:15 | Chile | |||
2020-04-04 | Chile | 4161 | 27 | 528 | 3606 | -35.6751 | -71.543 | 4/4/20 23:34 | Chile | |||
2020-05-16 | Chile | 41428 | 421 | 18014 | 22993 | -35.6751 | -71.543 | 2020-05-17 02:32:32 | Chile | |||
2020-03-30 | Chile | 2449 | 8 | 156 | 2285 | -35.6751 | -71.543 | 3/30/20 22:52 | Chile | |||
2020-05-05 | Chile | 22016 | 275 | 10710 | 11031 | -35.6751 | -71.543 | 2020-05-06 02:32:31 | Chile | |||
2020-05-02 | Chile | 18435 | 247 | 9572 | 8616 | -35.6751 | -71.543 | 2020-05-03 02:32:28 | Chile | |||
2020-05-06 | Chile | 23048 | 281 | 11189 | 11578 | -35.6751 | -71.543 | 2020-05-07 02:32:28 | Chile | |||
2020-03-23 | Chile | 746 | 2 | 11 | 733 | -35.6751 | -71.543 | 2020-03-23 23:19:21 | Chile | |||
2020-05-03 | Chile | 19663 | 260 | 10041 | 9362 | -35.6751 | -71.543 | 2020-05-04 02:32:28 | Chile | |||
2020-05-19 | Chile | 49579 | 509 | 21507 | 27563 | -35.6751 | -71.543 | 2020-05-20 02:32:19 | Chile | |||
2020-04-20 | Chile | 10507 | 139 | 4676 | 5692 | -35.6751 | -71.543 | 2020-04-20 23:36:27 | Chile | |||
2020-04-23 | Chile | 11812 | 168 | 5804 | 5840 | -35.6751 | -71.543 | 2020-04-24 03:30:31 | Chile | |||
2020-04-11 | Chile | 6927 | 73 | 1864 | 4990 | -35.6751 | -71.543 | 2020-04-11 22:45:13 | Chile | |||
2020-04-12 | Chile | 7213 | 80 | 2059 | 5074 | -35.6751 | -71.543 | 2020-04-12 23:17:00 | Chile | |||
2020-05-12 | Chile | 31721 | 335 | 14125 | 17261 | -35.6751 | -71.543 | 2020-05-13 03:32:26 | Chile | |||
2020-03-29 | Chile | 2139 | 7 | 75 | 2057 | -35.6751 | -71.543 | 3/29/20 23:08 | Chile | |||
2020-05-09 | Chile | 27219 | 304 | 12667 | 14248 | -35.6751 | -71.543 | 2020-05-10 02:32:30 | Chile | |||
2020-03-22 | Chile | 632 | 1 | 8 | 623 | -35.6751 | -71.543 | 3/22/20 23:45 | Chile | |||
2020-04-07 | Chile | 5116 | 43 | 898 | 4175 | -35.6751 | -71.543 | 2020-04-07 23:04:29 | Chile | |||
2020-05-04 | Chile | 20643 | 270 | 10415 | 9958 | -35.6751 | -71.543 | 2020-05-05 02:32:34 | Chile | |||
2020-05-18 | Chile | 46059 | 478 | 20165 | 25416 | -35.6751 | -71.543 | 2020-05-19 02:32:18 | Chile | |||
2020-05-15 | Chile | 39542 | 394 | 16614 | 22534 | -35.6751 | -71.543 | 2020-05-16 02:32:19 | Chile | |||
2020-05-07 | Chile | 24581 | 285 | 11664 | 12632 | -35.6751 | -71.543 | 2020-05-08 02:32:32 | Chile | |||
2020-05-11 | Chile | 30063 | 323 | 13605 | 16135 | -35.6751 | -71.543 | 2020-05-12 03:32:27 | Chile | |||
2020-04-14 | Chile | 7917 | 92 | 2646 | 5179 | -35.6751 | -71.543 | 2020-04-14 23:33:12 | Chile | |||
2020-04-01 | Chile | 3031 | 16 | 234 | 2781 | -35.6751 | -71.543 | 2020-04-01 21:58:34 | Chile | |||
2020-05-17 | Chile | 43781 | 450 | 19213 | 24118 | -35.6751 | -71.543 | 2020-05-18 02:32:21 | Chile | |||
2020-05-10 | Chile | 28866 | 312 | 13112 | 15442 | -35.6751 | -71.543 | 2020-05-11 02:32:30 | Chile | |||
2020-04-25 | Chile | 12858 | 181 | 6746 | 5931 | -35.6751 | -71.543 | 2020-04-26 02:30:31 | Chile | |||
2020-04-08 | Chile | 5546 | 48 | 1115 | 4383 | -35.6751 | -71.543 | 2020-04-08 22:51:39 | Chile | |||
2020-04-27 | Chile | 13813 | 198 | 7327 | 6288 | -35.6751 | -71.543 | 2020-04-28 02:30:32 | Chile | |||
2020-04-26 | Chile | 13331 | 189 | 7024 | 6118 | -35.6751 | -71.543 | 2020-04-27 02:30:33 | Chile | |||
2020-04-06 | Chile | 4815 | 37 | 728 | 4050 | -35.6751 | -71.543 | 4/6/20 23:21 | Chile | |||
2020-04-02 | Chile | 3404 | 18 | 335 | 3051 | -35.6751 | -71.543 | 4/2/20 23:25 | Chile | |||
2020-04-03 | Chile | 3737 | 22 | 427 | 3288 | -35.6751 | -71.543 | 2020-04-03 22:46:20 | Chile | |||
2020-03-31 | Chile | 2738 | 12 | 156 | 2570 | -35.6751 | -71.543 | 2020-03-31 23:43:43 | Chile | |||
2020-05-13 | Chile | 34381 | 346 | 14865 | 19170 | -35.6751 | -71.543 | 2020-05-14 03:32:28 | Chile | |||
2020-03-28 | Chile | 1909 | 6 | 61 | 1842 | -35.6751 | -71.543 | 3/28/20 23:05 | Chile | |||
2020-04-09 | Chile | 5972 | 57 | 1274 | 4641 | -35.6751 | -71.543 | 2020-04-09 23:02:19 | Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;