daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Chile" and province_or_state = "Valparaiso" 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 | Valparaiso | 464364 | 6259 | 0 | -33.0472 | -71.6127 | 2022-12-03 04:21:02 | Valparaiso, Chile | |||
2020-08-17 | Chile | Valparaiso | 20433 | 616 | 18300 | 1517 | -33.0472 | -71.6127 | 2020-08-18 04:27:56 | Valparaiso, Chile | ||
2020-07-22 | Chile | Valparaiso | 15914 | 427 | 14045 | 1442 | -33.0472 | -71.6127 | 2020-07-23 05:15:04 | Valparaiso, Chile | ||
2020-12-12 | Chile | Valparaiso | 33420 | 1181 | 31639 | 600 | -33.0472 | -71.6127 | 2020-12-13 05:27:20 | Valparaiso, Chile | ||
2022-11-02 | Chile | Valparaiso | 443550 | 6154 | 0 | -33.0472 | -71.6127 | 2022-11-03 04:22:05 | Valparaiso, Chile | |||
2022-09-30 | Chile | Valparaiso | 429996 | 6097 | 0 | -33.0472 | -71.6127 | 2022-10-01 04:23:01 | Valparaiso, Chile | |||
2020-12-11 | Chile | Valparaiso | 33320 | 1177 | 31547 | 596 | -33.0472 | -71.6127 | 2020-12-12 05:26:19 | Valparaiso, Chile | ||
2020-11-12 | Chile | Valparaiso | 31163 | 1096 | 29604 | 463 | -33.0472 | -71.6127 | 2020-11-13 05:25:30 | Valparaiso, Chile | ||
2022-12-11 | Chile | Valparaiso | 467833 | 6283 | 0 | -33.0472 | -71.6127 | 2022-12-12 04:21:01 | Valparaiso, Chile | |||
2020-05-24 | Chile | Valparaiso | 2230 | 48 | 0 | 2182 | -33.0472 | -71.6127 | 2020-05-25 02:32:44 | Valparaiso, Chile | ||
2022-03-27 | Chile | Valparaiso | 295459 | 5459 | 0 | -33.0472 | -71.6127 | 2022-03-28 04:20:33 | Valparaiso, Chile | |||
2022-08-05 | Chile | Valparaiso | 397735 | 5940 | 0 | -33.0472 | -71.6127 | 2022-08-06 04:20:56 | Valparaiso, Chile | |||
2020-07-07 | Chile | Valparaiso | 13433 | 292 | 11154 | 1987 | -33.0472 | -71.6127 | 2020-07-08 05:33:48 | Valparaiso, Chile | ||
2021-04-26 | Chile | Valparaiso | 83104 | 2234 | 77023 | 3847 | -33.0472 | -71.6127 | 2021-04-27 04:20:52 | Valparaiso, Chile | ||
2020-11-05 | Chile | Valparaiso | 30671 | 1075 | 29167 | 429 | -33.0472 | -71.6127 | 2020-11-06 05:24:55 | Valparaiso, Chile | ||
2022-07-24 | Chile | Valparaiso | 387747 | 5888 | 0 | -33.0472 | -71.6127 | 2022-07-25 04:20:51 | Valparaiso, Chile | |||
2022-07-22 | Chile | Valparaiso | 386145 | 5882 | 0 | -33.0472 | -71.6127 | 2022-07-23 04:20:53 | Valparaiso, Chile | |||
2021-11-24 | Chile | Valparaiso | 132261 | 3530 | 0 | -33.0472 | -71.6127 | 2021-11-25 04:22:33 | Valparaiso, Chile | |||
2021-01-19 | Chile | Valparaiso | 40265 | 1323 | 37492 | 1450 | -33.0472 | -71.6127 | 2021-01-20 05:21:54 | Valparaiso, Chile | ||
2022-10-29 | Chile | Valparaiso | 441869 | 6149 | 0 | -33.0472 | -71.6127 | 2022-10-30 04:22:14 | Valparaiso, Chile | |||
2022-03-08 | Chile | Valparaiso | 272580 | 4084 | 0 | -33.0472 | -71.6127 | 2022-03-09 04:20:59 | Valparaiso, Chile | |||
2020-11-26 | Chile | Valparaiso | 32110 | 1140 | 30512 | 458 | -33.0472 | -71.6127 | 2020-11-27 05:26:53 | Valparaiso, Chile | ||
2020-12-21 | Chile | Valparaiso | 34466 | 1214 | 32460 | 792 | -33.0472 | -71.6127 | 2020-12-22 05:22:33 | Valparaiso, Chile | ||
2021-10-16 | Chile | Valparaiso | 124553 | 3477 | 0 | -33.0472 | -71.6127 | 2021-10-17 04:21:29 | Valparaiso, Chile | |||
2022-06-25 | Chile | Valparaiso | 360343 | 5725 | 0 | -33.0472 | -71.6127 | 2022-06-26 04:21:02 | Valparaiso, Chile | |||
2022-02-28 | Chile | Valparaiso | 259187 | 3985 | 0 | -33.0472 | -71.6127 | 2022-03-01 04:21:09 | Valparaiso, Chile | |||
2022-06-14 | Chile | Valparaiso | 343319 | 5683 | 0 | -33.0472 | -71.6127 | 2022-06-15 04:20:54 | Valparaiso, Chile | |||
2022-03-12 | Chile | Valparaiso | 279627 | 4141 | 0 | -33.0472 | -71.6127 | 2022-03-13 04:20:49 | Valparaiso, Chile | |||
2021-04-25 | Chile | Valparaiso | 82562 | 2217 | 76370 | 3975 | -33.0472 | -71.6127 | 2021-04-26 04:21:04 | Valparaiso, Chile | ||
2022-07-19 | Chile | Valparaiso | 383668 | 5862 | 0 | -33.0472 | -71.6127 | 2022-07-20 04:20:59 | Valparaiso, Chile | |||
2022-09-09 | Chile | Valparaiso | 422571 | 6044 | 0 | -33.0472 | -71.6127 | 2022-09-10 04:21:10 | Valparaiso, Chile | |||
2020-09-29 | Chile | Valparaiso | 27321 | 862 | 25602 | 857 | -33.0472 | -71.6127 | 2020-09-30 04:23:33 | Valparaiso, Chile | ||
2022-06-01 | Chile | Valparaiso | 326132 | 5639 | 0 | -33.0472 | -71.6127 | 2022-06-02 05:20:39 | Valparaiso, Chile | |||
2021-02-06 | Chile | Valparaiso | 44519 | 1441 | 41738 | 1340 | -33.0472 | -71.6127 | 2021-02-07 05:23:00 | Valparaiso, Chile | ||
2022-02-01 | Chile | Valparaiso | 174839 | 3698 | 0 | -33.0472 | -71.6127 | 2022-02-02 04:21:09 | Valparaiso, Chile | |||
2021-04-17 | Chile | Valparaiso | 77896 | 2129 | 71164 | 4603 | -33.0472 | -71.6127 | 2021-04-18 04:20:41 | Valparaiso, Chile | ||
2021-10-04 | Chile | Valparaiso | 123604 | 3466 | 0 | -33.0472 | -71.6127 | 2021-10-05 04:21:27 | Valparaiso, Chile | |||
2022-08-16 | Chile | Valparaiso | 407533 | 5976 | 0 | -33.0472 | -71.6127 | 2022-08-17 04:20:59 | Valparaiso, Chile | |||
2020-05-23 | Chile | Valparaiso | 2116 | 44 | 0 | 2072 | -33.0472 | -71.6127 | 2020-05-24 02:32:43 | Valparaiso, Chile | ||
2021-03-01 | Chile | Valparaiso | 50590 | 1604 | 46861 | 2125 | -33.0472 | -71.6127 | 2021-03-02 05:23:30 | Valparaiso, Chile | ||
2020-07-09 | Chile | Valparaiso | 13797 | 312 | 11615 | 1870 | -33.0472 | -71.6127 | 2020-07-10 04:34:24 | Valparaiso, Chile | ||
2020-12-06 | Chile | Valparaiso | 32938 | 1165 | 31184 | 589 | -33.0472 | -71.6127 | 2020-12-07 05:26:14 | Valparaiso, Chile | ||
2020-12-30 | Chile | Valparaiso | 35500 | 1238 | 33507 | 755 | -33.0472 | -71.6127 | 2020-12-31 05:22:49 | Valparaiso, Chile | ||
2021-11-21 | Chile | Valparaiso | 131602 | 3522 | 0 | -33.0472 | -71.6127 | 2021-11-22 04:22:20 | Valparaiso, Chile | |||
2022-12-24 | Chile | Valparaiso | 472454 | 6325 | 0 | -33.0472 | -71.6127 | 2022-12-25 04:21:04 | Valparaiso, Chile | |||
2022-11-04 | Chile | Valparaiso | 444996 | 6158 | 0 | -33.0472 | -71.6127 | 2022-11-05 04:21:52 | Valparaiso, Chile | |||
2020-10-17 | Chile | Valparaiso | 29241 | 979 | 27433 | 829 | -33.0472 | -71.6127 | 2020-10-18 04:24:25 | Valparaiso, Chile | ||
2021-12-06 | Chile | Valparaiso | 134951 | 3572 | 0 | -33.0472 | -71.6127 | 2021-12-07 04:22:34 | Valparaiso, Chile | |||
2020-12-15 | Chile | Valparaiso | 33725 | 1190 | 31955 | 580 | -33.0472 | -71.6127 | 2020-12-16 05:28:04 | Valparaiso, Chile | ||
2020-05-26 | Chile | Valparaiso | 2455 | 57 | 0 | 2398 | -33.0472 | -71.6127 | 2020-05-27 02:32:31 | Valparaiso, Chile | ||
2020-10-07 | Chile | Valparaiso | 28273 | 909 | 26408 | 956 | -33.0472 | -71.6127 | 2020-10-08 04:23:56 | Valparaiso, Chile | ||
2020-09-30 | Chile | Valparaiso | 27442 | 862 | 25713 | 867 | -33.0472 | -71.6127 | 2020-10-01 04:23:42 | Valparaiso, Chile | ||
2022-11-06 | Chile | Valparaiso | 447027 | 6169 | 0 | -33.0472 | -71.6127 | 2022-11-07 04:21:26 | Valparaiso, Chile | |||
2020-10-23 | Chile | Valparaiso | 29755 | 1009 | 27959 | 787 | -33.0472 | -71.6127 | 2020-10-24 04:24:46 | Valparaiso, Chile | ||
2022-02-23 | Chile | Valparaiso | 247333 | 3885 | 0 | -33.0472 | -71.6127 | 2022-02-24 04:21:14 | Valparaiso, Chile | |||
2021-01-04 | Chile | Valparaiso | 36565 | 1261 | 34174 | 1130 | -33.0472 | -71.6127 | 2021-01-05 05:21:49 | Valparaiso, Chile | ||
2022-07-28 | Chile | Valparaiso | 390756 | 5901 | 0 | -33.0472 | -71.6127 | 2022-07-29 04:20:45 | Valparaiso, Chile | |||
2022-08-07 | Chile | Valparaiso | 399765 | 5949 | 0 | -33.0472 | -71.6127 | 2022-08-08 04:21:08 | Valparaiso, Chile | |||
2022-12-28 | Chile | Valparaiso | 473856 | 6331 | 0 | -33.0472 | -71.6127 | 2022-12-29 04:21:01 | Valparaiso, Chile | |||
2021-12-09 | Chile | Valparaiso | 135353 | 3580 | 0 | -33.0472 | -71.6127 | 2021-12-10 04:22:28 | Valparaiso, Chile | |||
2021-05-14 | Chile | Valparaiso | 90925 | 2434 | 85642 | 2849 | -33.0472 | -71.6127 | 2021-05-15 04:20:58 | Valparaiso, Chile | ||
2022-08-09 | Chile | Valparaiso | 400914 | 5951 | 0 | -33.0472 | -71.6127 | 2022-08-10 04:20:57 | Valparaiso, Chile | |||
2021-03-03 | Chile | Valparaiso | 51040 | 1605 | 47394 | 2041 | -33.0472 | -71.6127 | 2021-03-04 05:24:24 | Valparaiso, Chile | ||
2021-01-20 | Chile | Valparaiso | 40456 | 1323 | 37768 | 1365 | -33.0472 | -71.6127 | 2021-01-21 05:22:01 | Valparaiso, Chile | ||
2022-08-03 | Chile | Valparaiso | 395429 | 5916 | 0 | -33.0472 | -71.6127 | 2022-08-04 04:20:58 | Valparaiso, Chile | |||
2020-05-25 | Chile | Valparaiso | 2305 | 53 | 0 | 2252 | -33.0472 | -71.6127 | 2020-05-26 02:32:35 | Valparaiso, Chile | ||
2020-09-02 | Chile | Valparaiso | 23308 | 703 | 21069 | 1536 | -33.0472 | -71.6127 | 2020-09-03 04:28:22 | Valparaiso, Chile | ||
2022-05-21 | Chile | Valparaiso | 316421 | 5627 | 0 | -33.0472 | -71.6127 | 2022-05-22 04:20:52 | Valparaiso, Chile | |||
2022-01-11 | Chile | Valparaiso | 140793 | 3650 | 0 | -33.0472 | -71.6127 | 2022-01-12 04:21:44 | Valparaiso, Chile | |||
2021-08-06 | Chile | Valparaiso | 120939 | 3300 | 0 | -33.0472 | -71.6127 | 2021-08-07 04:21:30 | Valparaiso, Chile | |||
2020-09-17 | Chile | Valparaiso | 25740 | 805 | 23660 | 1275 | -33.0472 | -71.6127 | 2020-09-18 05:05:00 | Valparaiso, Chile | ||
2021-06-18 | Chile | Valparaiso | 109340 | 2794 | 102772 | 3774 | -33.0472 | -71.6127 | 2021-06-19 04:22:33 | Valparaiso, Chile | ||
2020-06-26 | Chile | Valparaiso | 10797 | 204 | 0 | 10593 | -33.0472 | -71.6127 | 2020-06-27 04:33:35 | Valparaiso, Chile | ||
2021-01-01 | Chile | Valparaiso | 35982 | 1258 | 33726 | 998 | -33.0472 | -71.6127 | 2021-01-02 05:22:33 | Valparaiso, Chile | ||
2022-01-23 | Chile | Valparaiso | 153269 | 3674 | 0 | -33.0472 | -71.6127 | 2022-01-24 04:21:12 | Valparaiso, Chile | |||
2021-12-01 | Chile | Valparaiso | 133933 | 3550 | 0 | -33.0472 | -71.6127 | 2021-12-02 04:22:37 | Valparaiso, Chile | |||
2022-12-12 | Chile | Valparaiso | 468085 | 6290 | 0 | -33.0472 | -71.6127 | 2022-12-13 04:21:01 | Valparaiso, Chile | |||
2021-02-18 | Chile | Valparaiso | 47151 | 1521 | 44084 | 1546 | -33.0472 | -71.6127 | 2021-02-19 05:24:16 | Valparaiso, Chile | ||
2022-04-29 | Chile | Valparaiso | 306860 | 5579 | 0 | -33.0472 | -71.6127 | 2022-04-30 04:21:05 | Valparaiso, Chile | |||
2022-08-18 | Chile | Valparaiso | 409033 | 5976 | 0 | -33.0472 | -71.6127 | 2022-08-19 04:20:54 | Valparaiso, Chile | |||
2021-07-04 | Chile | Valparaiso | 115898 | 3004 | 110674 | 2220 | -33.0472 | -71.6127 | 2021-07-05 04:21:28 | Valparaiso, Chile | ||
2022-05-20 | Chile | Valparaiso | 315607 | 5624 | 0 | -33.0472 | -71.6127 | 2022-05-21 04:20:58 | Valparaiso, Chile | |||
2020-09-10 | Chile | Valparaiso | 24605 | 766 | 22442 | 1397 | -33.0472 | -71.6127 | 2020-09-11 04:46:23 | Valparaiso, Chile | ||
2020-10-22 | Chile | Valparaiso | 29681 | 1002 | 27883 | 796 | -33.0472 | -71.6127 | 2020-10-23 04:24:46 | Valparaiso, Chile | ||
2022-05-18 | Chile | Valparaiso | 313956 | 5623 | 0 | -33.0472 | -71.6127 | 2022-05-19 04:20:54 | Valparaiso, Chile | |||
2021-05-31 | Chile | Valparaiso | 98897 | 2587 | 92978 | 3332 | -33.0472 | -71.6127 | 2021-06-01 04:23:09 | Valparaiso, Chile | ||
2020-06-17 | Chile | Valparaiso | 8253 | 141 | 0 | 8112 | -33.0472 | -71.6127 | 2020-06-18 04:33:18 | Valparaiso, Chile | ||
2022-07-06 | Chile | Valparaiso | 372884 | 5762 | 0 | -33.0472 | -71.6127 | 2022-07-07 04:20:55 | Valparaiso, Chile | |||
2021-03-22 | Chile | Valparaiso | 60173 | 1788 | 54666 | 3719 | -33.0472 | -71.6127 | 2021-03-23 05:26:18 | Valparaiso, Chile | ||
2020-06-09 | Chile | Valparaiso | 5391 | 85 | 0 | 5306 | -33.0472 | -71.6127 | 2020-06-10 04:07:00 | Valparaiso, Chile | ||
2022-07-11 | Chile | Valparaiso | 377905 | 5810 | 0 | -33.0472 | -71.6127 | 2022-07-12 04:20:51 | Valparaiso, Chile | |||
2022-01-08 | Chile | Valparaiso | 139864 | 3647 | 0 | -33.0472 | -71.6127 | 2022-01-09 04:21:46 | Valparaiso, Chile | |||
2021-03-27 | Chile | Valparaiso | 63349 | 1818 | 57307 | 4224 | -33.0472 | -71.6127 | 2021-03-28 05:28:10 | Valparaiso, Chile | ||
2022-04-14 | Chile | Valparaiso | 302969 | 5541 | 0 | -33.0472 | -71.6127 | 2022-04-15 04:20:57 | Valparaiso, Chile | |||
2022-01-24 | Chile | Valparaiso | 155129 | 3676 | 0 | -33.0472 | -71.6127 | 2022-01-25 04:21:05 | Valparaiso, Chile | |||
2021-11-28 | Chile | Valparaiso | 133422 | 3549 | 0 | -33.0472 | -71.6127 | 2021-11-29 04:22:30 | Valparaiso, Chile | |||
2021-09-27 | Chile | Valparaiso | 123246 | 3464 | 0 | -33.0472 | -71.6127 | 2021-09-28 04:21:28 | Valparaiso, Chile | |||
2022-11-28 | Chile | Valparaiso | 462330 | 6246 | 0 | -33.0472 | -71.6127 | 2022-11-29 04:21:05 | Valparaiso, Chile | |||
2020-09-08 | Chile | Valparaiso | 24328 | 754 | 22107 | 1467 | -33.0472 | -71.6127 | 2020-09-09 04:28:48 | Valparaiso, Chile | ||
2022-08-23 | Chile | Valparaiso | 413014 | 5992 | 0 | -33.0472 | -71.6127 | 2022-08-24 04:20:46 | Valparaiso, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;