daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Chile" and province_or_state = "Aysen" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-02 | Chile | Aysen | 34113 | 209 | 0 | -45.9864 | -73.7669 | 2022-12-03 04:21:02 | Aysen, Chile | |||
2020-08-17 | Chile | Aysen | 98 | 1 | 85 | 12 | -45.9864 | -73.7669 | 2020-08-18 04:27:56 | Aysen, Chile | ||
2020-07-22 | Chile | Aysen | 69 | 1 | 52 | 16 | -45.9864 | -73.7669 | 2020-07-23 05:15:04 | Aysen, Chile | ||
2020-12-12 | Chile | Aysen | 1327 | 15 | 1274 | 38 | -45.9864 | -73.7669 | 2020-12-13 05:27:20 | Aysen, Chile | ||
2022-11-02 | Chile | Aysen | 32605 | 202 | 0 | -45.9864 | -73.7669 | 2022-11-03 04:22:05 | Aysen, Chile | |||
2022-09-30 | Chile | Aysen | 31635 | 200 | 0 | -45.9864 | -73.7669 | 2022-10-01 04:23:01 | Aysen, Chile | |||
2020-12-11 | Chile | Aysen | 1322 | 15 | 1261 | 46 | -45.9864 | -73.7669 | 2020-12-12 05:26:19 | Aysen, Chile | ||
2020-11-12 | Chile | Aysen | 1136 | 8 | 1080 | 48 | -45.9864 | -73.7669 | 2020-11-13 05:25:30 | Aysen, Chile | ||
2022-12-11 | Chile | Aysen | 34406 | 210 | 0 | -45.9864 | -73.7669 | 2022-12-12 04:21:01 | Aysen, Chile | |||
2020-05-24 | Chile | Aysen | 8 | 0 | 0 | 8 | -45.9864 | -73.7669 | 2020-05-25 02:32:44 | Aysen, Chile | ||
2022-03-27 | Chile | Aysen | 24345 | 173 | 0 | -45.9864 | -73.7669 | 2022-03-28 04:20:33 | Aysen, Chile | |||
2022-08-05 | Chile | Aysen | 28886 | 190 | 0 | -45.9864 | -73.7669 | 2022-08-06 04:20:56 | Aysen, Chile | |||
2020-07-07 | Chile | Aysen | 48 | 0 | 37 | 11 | -45.9864 | -73.7669 | 2020-07-08 05:33:48 | Aysen, Chile | ||
2021-04-26 | Chile | Aysen | 4169 | 30 | 3927 | 212 | -45.9864 | -73.7669 | 2021-04-27 04:20:52 | Aysen, Chile | ||
2020-11-05 | Chile | Aysen | 1082 | 6 | 1015 | 61 | -45.9864 | -73.7669 | 2020-11-06 05:24:55 | Aysen, Chile | ||
2022-07-24 | Chile | Aysen | 28105 | 188 | 0 | -45.9864 | -73.7669 | 2022-07-25 04:20:51 | Aysen, Chile | |||
2022-07-22 | Chile | Aysen | 27986 | 188 | 0 | -45.9864 | -73.7669 | 2022-07-23 04:20:53 | Aysen, Chile | |||
2021-11-24 | Chile | Aysen | 9477 | 80 | 0 | -45.9864 | -73.7669 | 2021-11-25 04:22:33 | Aysen, Chile | |||
2021-01-19 | Chile | Aysen | 2110 | 18 | 1870 | 222 | -45.9864 | -73.7669 | 2021-01-20 05:21:54 | Aysen, Chile | ||
2022-10-29 | Chile | Aysen | 32481 | 202 | 0 | -45.9864 | -73.7669 | 2022-10-30 04:22:14 | Aysen, Chile | |||
2022-03-08 | Chile | Aysen | 22250 | 135 | 0 | -45.9864 | -73.7669 | 2022-03-09 04:20:59 | Aysen, Chile | |||
2020-11-26 | Chile | Aysen | 1236 | 13 | 1181 | 42 | -45.9864 | -73.7669 | 2020-11-27 05:26:53 | Aysen, Chile | ||
2020-12-21 | Chile | Aysen | 1399 | 15 | 1325 | 59 | -45.9864 | -73.7669 | 2020-12-22 05:22:33 | Aysen, Chile | ||
2021-10-16 | Chile | Aysen | 8407 | 79 | 0 | -45.9864 | -73.7669 | 2021-10-17 04:21:29 | Aysen, Chile | |||
2022-06-25 | Chile | Aysen | 26461 | 187 | 0 | -45.9864 | -73.7669 | 2022-06-26 04:21:02 | Aysen, Chile | |||
2022-02-28 | Chile | Aysen | 21046 | 126 | 0 | -45.9864 | -73.7669 | 2022-03-01 04:21:09 | Aysen, Chile | |||
2022-06-14 | Chile | Aysen | 25820 | 186 | 0 | -45.9864 | -73.7669 | 2022-06-15 04:20:54 | Aysen, Chile | |||
2022-03-12 | Chile | Aysen | 22809 | 138 | 0 | -45.9864 | -73.7669 | 2022-03-13 04:20:49 | Aysen, Chile | |||
2021-04-25 | Chile | Aysen | 4148 | 30 | 3907 | 211 | -45.9864 | -73.7669 | 2021-04-26 04:21:04 | Aysen, Chile | ||
2022-07-19 | Chile | Aysen | 27776 | 187 | 0 | -45.9864 | -73.7669 | 2022-07-20 04:20:59 | Aysen, Chile | |||
2022-09-09 | Chile | Aysen | 31223 | 196 | 0 | -45.9864 | -73.7669 | 2022-09-10 04:21:10 | Aysen, Chile | |||
2020-09-29 | Chile | Aysen | 417 | 1 | 242 | 174 | -45.9864 | -73.7669 | 2020-09-30 04:23:33 | Aysen, Chile | ||
2022-06-01 | Chile | Aysen | 25401 | 185 | 0 | -45.9864 | -73.7669 | 2022-06-02 05:20:39 | Aysen, Chile | |||
2021-02-06 | Chile | Aysen | 2631 | 21 | 2464 | 146 | -45.9864 | -73.7669 | 2021-02-07 05:23:00 | Aysen, Chile | ||
2022-02-01 | Chile | Aysen | 13143 | 104 | 0 | -45.9864 | -73.7669 | 2022-02-02 04:21:09 | Aysen, Chile | |||
2021-04-17 | Chile | Aysen | 3915 | 30 | 3736 | 149 | -45.9864 | -73.7669 | 2021-04-18 04:20:41 | Aysen, Chile | ||
2021-10-04 | Chile | Aysen | 8345 | 78 | 0 | -45.9864 | -73.7669 | 2021-10-05 04:21:27 | Aysen, Chile | |||
2022-08-16 | Chile | Aysen | 29875 | 192 | 0 | -45.9864 | -73.7669 | 2022-08-17 04:20:59 | Aysen, Chile | |||
2020-05-23 | Chile | Aysen | 8 | 0 | 0 | 8 | -45.9864 | -73.7669 | 2020-05-24 02:32:43 | Aysen, Chile | ||
2021-03-01 | Chile | Aysen | 3085 | 25 | 2986 | 74 | -45.9864 | -73.7669 | 2021-03-02 05:23:30 | Aysen, Chile | ||
2020-07-09 | Chile | Aysen | 49 | 0 | 40 | 9 | -45.9864 | -73.7669 | 2020-07-10 04:34:24 | Aysen, Chile | ||
2020-12-06 | Chile | Aysen | 1288 | 15 | 1236 | 37 | -45.9864 | -73.7669 | 2020-12-07 05:26:14 | Aysen, Chile | ||
2020-12-30 | Chile | Aysen | 1552 | 15 | 1410 | 127 | -45.9864 | -73.7669 | 2020-12-31 05:22:49 | Aysen, Chile | ||
2021-11-21 | Chile | Aysen | 9345 | 80 | 0 | -45.9864 | -73.7669 | 2021-11-22 04:22:20 | Aysen, Chile | |||
2022-12-24 | Chile | Aysen | 34814 | 211 | 0 | -45.9864 | -73.7669 | 2022-12-25 04:21:04 | Aysen, Chile | |||
2022-11-04 | Chile | Aysen | 32698 | 202 | 0 | -45.9864 | -73.7669 | 2022-11-05 04:21:52 | Aysen, Chile | |||
2020-10-17 | Chile | Aysen | 824 | 2 | 630 | 192 | -45.9864 | -73.7669 | 2020-10-18 04:24:25 | Aysen, Chile | ||
2021-12-06 | Chile | Aysen | 9939 | 84 | 0 | -45.9864 | -73.7669 | 2021-12-07 04:22:34 | Aysen, Chile | |||
2020-12-15 | Chile | Aysen | 1344 | 15 | 1288 | 41 | -45.9864 | -73.7669 | 2020-12-16 05:28:04 | Aysen, Chile | ||
2020-05-26 | Chile | Aysen | 12 | 0 | 0 | 12 | -45.9864 | -73.7669 | 2020-05-27 02:32:31 | Aysen, Chile | ||
2020-10-07 | Chile | Aysen | 600 | 1 | 384 | 215 | -45.9864 | -73.7669 | 2020-10-08 04:23:56 | Aysen, Chile | ||
2020-09-30 | Chile | Aysen | 453 | 1 | 264 | 188 | -45.9864 | -73.7669 | 2020-10-01 04:23:42 | Aysen, Chile | ||
2022-11-06 | Chile | Aysen | 32863 | 203 | 0 | -45.9864 | -73.7669 | 2022-11-07 04:21:26 | Aysen, Chile | |||
2020-10-23 | Chile | Aysen | 951 | 2 | 752 | 197 | -45.9864 | -73.7669 | 2020-10-24 04:24:46 | Aysen, Chile | ||
2022-02-23 | Chile | Aysen | 20016 | 119 | 0 | -45.9864 | -73.7669 | 2022-02-24 04:21:14 | Aysen, Chile | |||
2021-01-04 | Chile | Aysen | 1644 | 15 | 1511 | 118 | -45.9864 | -73.7669 | 2021-01-05 05:21:49 | Aysen, Chile | ||
2022-07-28 | Chile | Aysen | 28359 | 188 | 0 | -45.9864 | -73.7669 | 2022-07-29 04:20:45 | Aysen, Chile | |||
2022-08-07 | Chile | Aysen | 29051 | 190 | 0 | -45.9864 | -73.7669 | 2022-08-08 04:21:08 | Aysen, Chile | |||
2022-12-28 | Chile | Aysen | 34923 | 211 | 0 | -45.9864 | -73.7669 | 2022-12-29 04:21:01 | Aysen, Chile | |||
2021-12-09 | Chile | Aysen | 10005 | 87 | 0 | -45.9864 | -73.7669 | 2021-12-10 04:22:28 | Aysen, Chile | |||
2021-05-14 | Chile | Aysen | 4811 | 31 | 4507 | 273 | -45.9864 | -73.7669 | 2021-05-15 04:20:58 | Aysen, Chile | ||
2022-08-09 | Chile | Aysen | 29153 | 190 | 0 | -45.9864 | -73.7669 | 2022-08-10 04:20:57 | Aysen, Chile | |||
2021-03-03 | Chile | Aysen | 3102 | 25 | 3006 | 71 | -45.9864 | -73.7669 | 2021-03-04 05:24:24 | Aysen, Chile | ||
2021-01-20 | Chile | Aysen | 2156 | 18 | 1920 | 218 | -45.9864 | -73.7669 | 2021-01-21 05:22:01 | Aysen, Chile | ||
2022-08-03 | Chile | Aysen | 28694 | 188 | 0 | -45.9864 | -73.7669 | 2022-08-04 04:20:58 | Aysen, Chile | |||
2020-05-25 | Chile | Aysen | 10 | 0 | 0 | 10 | -45.9864 | -73.7669 | 2020-05-26 02:32:35 | Aysen, Chile | ||
2020-09-02 | Chile | Aysen | 124 | 1 | 105 | 18 | -45.9864 | -73.7669 | 2020-09-03 04:28:22 | Aysen, Chile | ||
2022-05-21 | Chile | Aysen | 25270 | 185 | 0 | -45.9864 | -73.7669 | 2022-05-22 04:20:52 | Aysen, Chile | |||
2022-01-11 | Chile | Aysen | 10467 | 99 | 0 | -45.9864 | -73.7669 | 2022-01-12 04:21:44 | Aysen, Chile | |||
2021-08-06 | Chile | Aysen | 8069 | 72 | 0 | -45.9864 | -73.7669 | 2021-08-07 04:21:30 | Aysen, Chile | |||
2020-09-17 | Chile | Aysen | 188 | 1 | 140 | 47 | -45.9864 | -73.7669 | 2020-09-18 05:05:00 | Aysen, Chile | ||
2021-06-18 | Chile | Aysen | 7203 | 52 | 6686 | 465 | -45.9864 | -73.7669 | 2021-06-19 04:22:33 | Aysen, Chile | ||
2020-06-26 | Chile | Aysen | 30 | 0 | 0 | 30 | -45.9864 | -73.7669 | 2020-06-27 04:33:35 | Aysen, Chile | ||
2021-01-01 | Chile | Aysen | 1588 | 15 | 1436 | 137 | -45.9864 | -73.7669 | 2021-01-02 05:22:33 | Aysen, Chile | ||
2022-01-23 | Chile | Aysen | 11353 | 101 | 0 | -45.9864 | -73.7669 | 2022-01-24 04:21:12 | Aysen, Chile | |||
2021-12-01 | Chile | Aysen | 9747 | 82 | 0 | -45.9864 | -73.7669 | 2021-12-02 04:22:37 | Aysen, Chile | |||
2022-12-12 | Chile | Aysen | 34419 | 210 | 0 | -45.9864 | -73.7669 | 2022-12-13 04:21:01 | Aysen, Chile | |||
2021-02-18 | Chile | Aysen | 2902 | 23 | 2757 | 122 | -45.9864 | -73.7669 | 2021-02-19 05:24:16 | Aysen, Chile | ||
2022-04-29 | Chile | Aysen | 24999 | 184 | 0 | -45.9864 | -73.7669 | 2022-04-30 04:21:05 | Aysen, Chile | |||
2022-08-18 | Chile | Aysen | 30024 | 192 | 0 | -45.9864 | -73.7669 | 2022-08-19 04:20:54 | Aysen, Chile | |||
2021-07-04 | Chile | Aysen | 7779 | 64 | 7489 | 226 | -45.9864 | -73.7669 | 2021-07-05 04:21:28 | Aysen, Chile | ||
2022-05-20 | Chile | Aysen | 25248 | 185 | 0 | -45.9864 | -73.7669 | 2022-05-21 04:20:58 | Aysen, Chile | |||
2020-09-10 | Chile | Aysen | 143 | 1 | 125 | 17 | -45.9864 | -73.7669 | 2020-09-11 04:46:23 | Aysen, Chile | ||
2020-10-22 | Chile | Aysen | 929 | 2 | 737 | 190 | -45.9864 | -73.7669 | 2020-10-23 04:24:46 | Aysen, Chile | ||
2022-05-18 | Chile | Aysen | 25220 | 184 | 0 | -45.9864 | -73.7669 | 2022-05-19 04:20:54 | Aysen, Chile | |||
2021-05-31 | Chile | Aysen | 5935 | 35 | 5420 | 480 | -45.9864 | -73.7669 | 2021-06-01 04:23:09 | Aysen, Chile | ||
2020-06-17 | Chile | Aysen | 26 | 0 | 0 | 26 | -45.9864 | -73.7669 | 2020-06-18 04:33:18 | Aysen, Chile | ||
2022-07-06 | Chile | Aysen | 27073 | 187 | 0 | -45.9864 | -73.7669 | 2022-07-07 04:20:55 | Aysen, Chile | |||
2021-03-22 | Chile | Aysen | 3373 | 26 | 3246 | 101 | -45.9864 | -73.7669 | 2021-03-23 05:26:18 | Aysen, Chile | ||
2020-06-09 | Chile | Aysen | 21 | 0 | 0 | 21 | -45.9864 | -73.7669 | 2020-06-10 04:07:00 | Aysen, Chile | ||
2022-07-11 | Chile | Aysen | 27363 | 187 | 0 | -45.9864 | -73.7669 | 2022-07-12 04:20:51 | Aysen, Chile | |||
2022-01-08 | Chile | Aysen | 10406 | 99 | 0 | -45.9864 | -73.7669 | 2022-01-09 04:21:46 | Aysen, Chile | |||
2021-03-27 | Chile | Aysen | 3456 | 28 | 3317 | 111 | -45.9864 | -73.7669 | 2021-03-28 05:28:10 | Aysen, Chile | ||
2022-04-14 | Chile | Aysen | 24799 | 179 | 0 | -45.9864 | -73.7669 | 2022-04-15 04:20:57 | Aysen, Chile | |||
2022-01-24 | Chile | Aysen | 11463 | 101 | 0 | -45.9864 | -73.7669 | 2022-01-25 04:21:05 | Aysen, Chile | |||
2021-11-28 | Chile | Aysen | 9642 | 81 | 0 | -45.9864 | -73.7669 | 2021-11-29 04:22:30 | Aysen, Chile | |||
2021-09-27 | Chile | Aysen | 8302 | 78 | 0 | -45.9864 | -73.7669 | 2021-09-28 04:21:28 | Aysen, Chile | |||
2022-11-28 | Chile | Aysen | 33979 | 209 | 0 | -45.9864 | -73.7669 | 2022-11-29 04:21:05 | Aysen, Chile | |||
2020-09-08 | Chile | Aysen | 136 | 1 | 116 | 19 | -45.9864 | -73.7669 | 2020-09-09 04:28:48 | Aysen, Chile | ||
2022-08-23 | Chile | Aysen | 30469 | 194 | 0 | -45.9864 | -73.7669 | 2022-08-24 04:20:46 | Aysen, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;