johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Chile" and province_or_state = "Coquimbo" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687252 | 3687252 | 2022-01-13 | Chile | Coquimbo | 55968 | 1109 | 0 | -29.959 | -71.3389 | 2022-01-14 04:21:54 | Coquimbo, Chile | |||
3612836 | 3612836 | 2022-01-12 | Chile | Coquimbo | 55784 | 1107 | 0 | -29.959 | -71.3389 | 2022-01-13 08:00:09 | Coquimbo, Chile | |||
1113361 | 1113361 | 2022-01-11 | Chile | Coquimbo | 55648 | 1107 | 0 | -29.959 | -71.3389 | 2022-01-12 04:21:44 | Coquimbo, Chile | |||
1692089 | 1692089 | 2022-01-10 | Chile | Coquimbo | 55525 | 1107 | 0 | -29.959 | -71.3389 | 2022-01-11 04:22:01 | Coquimbo, Chile | |||
126504 | 126504 | 2022-01-09 | Chile | Coquimbo | 55422 | 1105 | 0 | -29.959 | -71.3389 | 2022-01-10 04:22:07 | Coquimbo, Chile | |||
1215339 | 1215339 | 2022-01-08 | Chile | Coquimbo | 55327 | 1104 | 0 | -29.959 | -71.3389 | 2022-01-09 04:21:46 | Coquimbo, Chile | |||
1389432 | 1389432 | 2022-01-07 | Chile | Coquimbo | 55226 | 1102 | 0 | -29.959 | -71.3389 | 2022-01-08 04:21:53 | Coquimbo, Chile | |||
2609819 | 2609819 | 2022-01-06 | Chile | Coquimbo | 55132 | 1100 | 0 | -29.959 | -71.3389 | 2022-01-07 04:22:09 | Coquimbo, Chile | |||
1281761 | 1281761 | 2022-01-05 | Chile | Coquimbo | 55057 | 1100 | 0 | -29.959 | -71.3389 | 2022-01-06 04:22:09 | Coquimbo, Chile | |||
1285777 | 1285777 | 2022-01-04 | Chile | Coquimbo | 55007 | 1100 | 0 | -29.959 | -71.3389 | 2022-01-05 04:21:59 | Coquimbo, Chile | |||
1700121 | 1700121 | 2022-01-03 | Chile | Coquimbo | 54970 | 1100 | 0 | -29.959 | -71.3389 | 2022-01-04 04:22:17 | Coquimbo, Chile | |||
3519204 | 3519204 | 2022-01-02 | Chile | Coquimbo | 54934 | 1099 | 0 | -29.959 | -71.3389 | 2022-01-03 02:22:25 | Coquimbo, Chile | |||
2167334 | 2167334 | 2022-01-01 | Chile | Coquimbo | 54884 | 1096 | 0 | -29.959 | -71.3389 | 2022-01-02 04:20:52 | Coquimbo, Chile | |||
2776765 | 2776765 | 2021-12-31 | Chile | Coquimbo | 54839 | 1093 | 0 | -29.959 | -71.3389 | 2022-01-01 04:22:14 | Coquimbo, Chile | |||
3998422 | 3998422 | 2021-12-30 | Chile | Coquimbo | 54788 | 1093 | 0 | -29.959 | -71.3389 | 2021-12-31 04:21:50 | Coquimbo, Chile | |||
1668229 | 1668229 | 2021-12-29 | Chile | Coquimbo | 54729 | 1093 | 0 | -29.959 | -71.3389 | 2021-12-30 04:21:25 | Coquimbo, Chile | |||
1432338 | 1432338 | 2021-12-28 | Chile | Coquimbo | 54694 | 1093 | 0 | -29.959 | -71.3389 | 2021-12-29 03:21:43 | Coquimbo, Chile | |||
730299 | 730299 | 2021-12-27 | Chile | Coquimbo | 54662 | 1093 | 0 | -29.959 | -71.3389 | 2021-12-28 04:21:47 | Coquimbo, Chile | |||
2111471 | 2111471 | 2021-12-26 | Chile | Coquimbo | 54641 | 1093 | 0 | -29.959 | -71.3389 | 2021-12-27 04:21:58 | Coquimbo, Chile | |||
3604843 | 3604843 | 2021-12-25 | Chile | Coquimbo | 54583 | 1092 | 0 | -29.959 | -71.3389 | 2021-12-26 04:21:50 | Coquimbo, Chile | |||
2963161 | 2963161 | 2021-12-24 | Chile | Coquimbo | 54528 | 1092 | 0 | -29.959 | -71.3389 | 2021-12-25 04:21:37 | Coquimbo, Chile | |||
3816193 | 3816193 | 2021-12-23 | Chile | Coquimbo | 54478 | 1088 | 0 | -29.959 | -71.3389 | 2021-12-24 04:21:34 | Coquimbo, Chile | |||
798201 | 798201 | 2021-12-22 | Chile | Coquimbo | 54447 | 1083 | 0 | -29.959 | -71.3389 | 2021-12-23 04:21:21 | Coquimbo, Chile | |||
3828241 | 3828241 | 2021-12-21 | Chile | Coquimbo | 54423 | 1083 | 0 | -29.959 | -71.3389 | 2021-12-22 04:21:54 | Coquimbo, Chile | |||
1254544 | 1254544 | 2021-12-20 | Chile | Coquimbo | 54380 | 1083 | 0 | -29.959 | -71.3389 | 2021-12-21 03:21:27 | Coquimbo, Chile | |||
2903487 | 2903487 | 2021-12-19 | Chile | Coquimbo | 54340 | 1082 | 0 | -29.959 | -71.3389 | 2021-12-20 04:21:43 | Coquimbo, Chile | |||
1258560 | 1258560 | 2021-12-18 | Chile | Coquimbo | 54301 | 1081 | 0 | -29.959 | -71.3389 | 2021-12-19 04:21:11 | Coquimbo, Chile | |||
2398588 | 2398588 | 2021-12-17 | Chile | Coquimbo | 54239 | 1079 | 0 | -29.959 | -71.3389 | 2021-12-18 02:22:20 | Coquimbo, Chile | |||
1716126 | 1716126 | 2021-12-16 | Chile | Coquimbo | 54193 | 1078 | 0 | -29.959 | -71.3389 | 2021-12-17 04:22:14 | Coquimbo, Chile | |||
3495960 | 3495960 | 2021-12-15 | Chile | Coquimbo | 54133 | 1074 | 0 | -29.959 | -71.3389 | 2021-12-16 04:22:11 | Coquimbo, Chile | |||
2087745 | 2087745 | 2021-12-14 | Chile | Coquimbo | 54087 | 1074 | 0 | -29.959 | -71.3389 | 2021-12-15 03:22:16 | Coquimbo, Chile | |||
782162 | 782162 | 2021-12-13 | Chile | Coquimbo | 54023 | 1074 | 0 | -29.959 | -71.3389 | 2021-12-14 04:22:38 | Coquimbo, Chile | |||
1660197 | 1660197 | 2021-12-12 | Chile | Coquimbo | 53957 | 1074 | 0 | -29.959 | -71.3389 | 2021-12-13 04:22:02 | Coquimbo, Chile | |||
1664213 | 1664213 | 2021-12-11 | Chile | Coquimbo | 53880 | 1073 | 0 | -29.959 | -71.3389 | 2021-12-12 04:22:12 | Coquimbo, Chile | |||
3655365 | 3655365 | 2021-12-10 | Chile | Coquimbo | 53715 | 1069 | 0 | -29.959 | -71.3389 | 2021-12-11 04:22:45 | Coquimbo, Chile | |||
1077696 | 1077696 | 2021-12-09 | Chile | Coquimbo | 53715 | 1069 | 0 | -29.959 | -71.3389 | 2021-12-10 04:22:28 | Coquimbo, Chile | |||
550545 | 550545 | 2021-12-08 | Chile | Coquimbo | 53609 | 1066 | 0 | -29.959 | -71.3389 | 2021-12-09 04:22:49 | Coquimbo, Chile | |||
404065 | 404065 | 2021-12-07 | Chile | Coquimbo | 53548 | 1066 | 0 | -29.959 | -71.3389 | 2021-12-08 04:22:46 | Coquimbo, Chile | |||
1030147 | 1030147 | 2021-12-06 | Chile | Coquimbo | 53492 | 1066 | 0 | -29.959 | -71.3389 | 2021-12-07 04:22:34 | Coquimbo, Chile | |||
1740310 | 1740310 | 2021-12-05 | Chile | Coquimbo | 53412 | 1064 | 0 | -29.959 | -71.3389 | 2021-12-06 04:22:34 | Coquimbo, Chile | |||
137742 | 137742 | 2021-12-04 | Chile | Coquimbo | 53311 | 1063 | 0 | -29.959 | -71.3389 | 2021-12-05 04:22:25 | Coquimbo, Chile | |||
2195395 | 2195395 | 2021-12-03 | Chile | Coquimbo | 53218 | 1063 | 0 | -29.959 | -71.3389 | 2021-12-04 04:22:18 | Coquimbo, Chile | |||
101 | 101 | 2021-12-02 | Chile | Coquimbo | 53112 | 1062 | 0 | -29.959 | -71.3389 | 2021-12-03 04:23:05 | Coquimbo, Chile | |||
1144700 | 1144700 | 2021-12-01 | Chile | Coquimbo | 53017 | 1059 | 0 | -29.959 | -71.3389 | 2021-12-02 04:22:37 | Coquimbo, Chile | |||
3401212 | 3401212 | 2021-11-30 | Chile | Coquimbo | 52922 | 1059 | 0 | -29.959 | -71.3389 | 2021-12-01 04:22:29 | Coquimbo, Chile | |||
149755 | 149755 | 2021-11-29 | Chile | Coquimbo | 52847 | 1059 | 0 | -29.959 | -71.3389 | 2021-11-30 04:22:53 | Coquimbo, Chile | |||
1231401 | 1231401 | 2021-11-28 | Chile | Coquimbo | 52752 | 1058 | 0 | -29.959 | -71.3389 | 2021-11-29 04:22:30 | Coquimbo, Chile | |||
1358108 | 1358108 | 2021-11-27 | Chile | Coquimbo | 52638 | 1057 | 0 | -29.959 | -71.3389 | 2021-11-28 04:22:43 | Coquimbo, Chile | |||
758099 | 758099 | 2021-11-26 | Chile | Coquimbo | 52477 | 1055 | 0 | -29.959 | -71.3389 | 2021-11-27 04:22:45 | Coquimbo, Chile | |||
1802516 | 1802516 | 2021-11-25 | Chile | Coquimbo | 52336 | 1055 | 0 | -29.959 | -71.3389 | 2021-11-26 04:22:33 | Coquimbo, Chile | |||
903950 | 903950 | 2021-11-24 | Chile | Coquimbo | 52242 | 1053 | 0 | -29.959 | -71.3389 | 2021-11-25 04:22:33 | Coquimbo, Chile | |||
3069800 | 3069800 | 2021-11-23 | Chile | Coquimbo | 52142 | 1053 | 0 | -29.959 | -71.3389 | 2021-11-24 04:22:14 | Coquimbo, Chile | |||
3748898 | 3748898 | 2021-11-22 | Chile | Coquimbo | 52034 | 1053 | 0 | -29.959 | -71.3389 | 2021-11-23 04:22:39 | Coquimbo, Chile | |||
1014105 | 1014105 | 2021-11-21 | Chile | Coquimbo | 51926 | 1053 | 0 | -29.959 | -71.3389 | 2021-11-22 04:22:20 | Coquimbo, Chile | |||
722269 | 722269 | 2021-11-20 | Chile | Coquimbo | 51815 | 1051 | 0 | -29.959 | -71.3389 | 2021-11-21 04:22:13 | Coquimbo, Chile | |||
161799 | 161799 | 2021-11-19 | Chile | Coquimbo | 51728 | 1050 | 0 | -29.959 | -71.3389 | 2021-11-20 04:22:17 | Coquimbo, Chile | |||
3288686 | 3288686 | 2021-11-18 | Chile | Coquimbo | 51602 | 1047 | 0 | -29.959 | -71.3389 | 2021-11-19 04:21:40 | Coquimbo, Chile | |||
447142 | 447142 | 2021-11-17 | Chile | Coquimbo | 51493 | 1046 | 0 | -29.959 | -71.3389 | 2021-11-18 04:21:33 | Coquimbo, Chile | |||
3342392 | 3342392 | 2021-11-16 | Chile | Coquimbo | 51406 | 1046 | 0 | -29.959 | -71.3389 | 2021-11-17 04:21:48 | Coquimbo, Chile | |||
2287228 | 2287228 | 2021-11-15 | Chile | Coquimbo | 51330 | 1046 | 0 | -29.959 | -71.3389 | 2021-11-16 04:21:10 | Coquimbo, Chile | |||
1322002 | 1322002 | 2021-11-14 | Chile | Coquimbo | 51249 | 1045 | 0 | -29.959 | -71.3389 | 2021-11-15 04:21:36 | Coquimbo, Chile | |||
686128 | 686128 | 2021-11-13 | Chile | Coquimbo | 51172 | 1045 | 0 | -29.959 | -71.3389 | 2021-11-14 04:21:31 | Coquimbo, Chile | |||
714237 | 714237 | 2021-11-12 | Chile | Coquimbo | 51049 | 1044 | 0 | -29.959 | -71.3389 | 2021-11-13 04:21:38 | Coquimbo, Chile | |||
28187 | 28187 | 2021-11-11 | Chile | Coquimbo | 50951 | 1043 | 0 | -29.959 | -71.3389 | 2021-11-12 04:22:01 | Coquimbo, Chile | |||
2844626 | 2844626 | 2021-11-10 | Chile | Coquimbo | 50853 | 1039 | 0 | -29.959 | -71.3389 | 2021-11-11 04:21:45 | Coquimbo, Chile | |||
86896 | 86896 | 2021-11-09 | Chile | Coquimbo | 50777 | 1039 | 0 | -29.959 | -71.3389 | 2021-11-10 04:21:38 | Coquimbo, Chile | |||
3639324 | 3639324 | 2021-11-08 | Chile | Coquimbo | 50713 | 1039 | 0 | -29.959 | -71.3389 | 2021-11-09 04:21:36 | Coquimbo, Chile | |||
2000432 | 2000432 | 2021-11-07 | Chile | Coquimbo | 50606 | 1039 | 0 | -29.959 | -71.3389 | 2021-11-08 04:21:43 | Coquimbo, Chile | |||
495423 | 495423 | 2021-11-06 | Chile | Coquimbo | 50493 | 1039 | 0 | -29.959 | -71.3389 | 2021-11-07 04:21:53 | Coquimbo, Chile | |||
3121278 | 3121278 | 2021-11-05 | Chile | Coquimbo | 50388 | 1038 | 0 | -29.959 | -71.3389 | 2021-11-06 04:21:51 | Coquimbo, Chile | |||
698176 | 698176 | 2021-11-04 | Chile | Coquimbo | 50292 | 1037 | 0 | -29.959 | -71.3389 | 2021-11-05 04:21:54 | Coquimbo, Chile | |||
275954 | 275954 | 2021-11-03 | Chile | Coquimbo | 50234 | 1037 | 0 | -29.959 | -71.3389 | 2021-11-04 04:22:20 | Coquimbo, Chile | |||
43479 | 43479 | 2021-11-02 | Chile | Coquimbo | 50197 | 1037 | 0 | -29.959 | -71.3389 | 2021-11-03 06:22:09 | Coquimbo, Chile | |||
3511175 | 3511175 | 2021-11-01 | Chile | Coquimbo | 50142 | 1037 | 0 | -29.959 | -71.3389 | 2021-11-02 04:22:03 | Coquimbo, Chile | |||
287767 | 287767 | 2021-10-31 | Chile | Coquimbo | 50062 | 1035 | 0 | -29.959 | -71.3389 | 2021-11-01 04:22:01 | Coquimbo, Chile | |||
2720773 | 2720773 | 2021-10-30 | Chile | Coquimbo | 49990 | 1035 | 0 | -29.959 | -71.3389 | 2021-10-31 04:22:08 | Coquimbo, Chile | |||
566875 | 566875 | 2021-10-29 | Chile | Coquimbo | 49912 | 1034 | 0 | -29.959 | -71.3389 | 2021-10-30 04:22:03 | Coquimbo, Chile | |||
4117 | 4117 | 2021-10-28 | Chile | Coquimbo | 49840 | 1034 | 0 | -29.959 | -71.3389 | 2021-10-29 04:22:03 | Coquimbo, Chile | |||
534507 | 534507 | 2021-10-27 | Chile | Coquimbo | 49765 | 1033 | 0 | -29.959 | -71.3389 | 2021-10-28 04:22:08 | Coquimbo, Chile | |||
3491944 | 3491944 | 2021-10-26 | Chile | Coquimbo | 49715 | 1033 | 0 | -29.959 | -71.3389 | 2021-10-27 04:22:32 | Coquimbo, Chile | |||
3793666 | 3793666 | 2021-10-25 | Chile | Coquimbo | 49649 | 1033 | 0 | -29.959 | -71.3389 | 2021-10-26 04:22:09 | Coquimbo, Chile | |||
682112 | 682112 | 2021-10-24 | Chile | Coquimbo | 49594 | 1033 | 0 | -29.959 | -71.3389 | 2021-10-25 04:22:31 | Coquimbo, Chile | |||
770120 | 770120 | 2021-10-23 | Chile | Coquimbo | 49520 | 1033 | 0 | -29.959 | -71.3389 | 2021-10-24 04:21:22 | Coquimbo, Chile | |||
653767 | 653767 | 2021-10-22 | Chile | Coquimbo | 49444 | 1033 | 0 | -29.959 | -71.3389 | 2021-10-23 04:21:32 | Coquimbo, Chile | |||
2123514 | 2123514 | 2021-10-21 | Chile | Coquimbo | 49376 | 1033 | 0 | -29.959 | -71.3389 | 2021-10-22 04:21:14 | Coquimbo, Chile | |||
443126 | 443126 | 2021-10-20 | Chile | Coquimbo | 49333 | 1032 | 0 | -29.959 | -71.3389 | 2021-10-21 04:21:18 | Coquimbo, Chile | |||
597445 | 597445 | 2021-10-19 | Chile | Coquimbo | 49309 | 1032 | 0 | -29.959 | -71.3389 | 2021-10-20 04:21:00 | Coquimbo, Chile | |||
2043622 | 2043622 | 2021-10-18 | Chile | Coquimbo | 49283 | 1032 | 0 | -29.959 | -71.3389 | 2021-10-19 04:20:54 | Coquimbo, Chile | |||
1908983 | 1908983 | 2021-10-17 | Chile | Coquimbo | 49249 | 1031 | 0 | -29.959 | -71.3389 | 2021-10-18 04:21:10 | Coquimbo, Chile | |||
934572 | 934572 | 2021-10-16 | Chile | Coquimbo | 49216 | 1030 | 0 | -29.959 | -71.3389 | 2021-10-17 04:21:29 | Coquimbo, Chile | |||
2943127 | 2943127 | 2021-10-15 | Chile | Coquimbo | 49188 | 1029 | 0 | -29.959 | -71.3389 | 2021-10-16 04:21:15 | Coquimbo, Chile | |||
491407 | 491407 | 2021-10-14 | Chile | Coquimbo | 49143 | 1029 | 0 | -29.959 | -71.3389 | 2021-10-15 04:21:26 | Coquimbo, Chile | |||
633695 | 633695 | 2021-10-13 | Chile | Coquimbo | 49116 | 1029 | 0 | -29.959 | -71.3389 | 2021-10-14 04:21:29 | Coquimbo, Chile | |||
1491373 | 1491373 | 2021-10-12 | Chile | Coquimbo | 49108 | 1029 | 0 | -29.959 | -71.3389 | 2021-10-13 04:20:51 | Coquimbo, Chile | |||
3007106 | 3007106 | 2021-10-11 | Chile | Coquimbo | 49100 | 1029 | 0 | -29.959 | -71.3389 | 2021-10-12 04:21:09 | Coquimbo, Chile | |||
423122 | 423122 | 2021-10-10 | Chile | Coquimbo | 49070 | 1029 | 0 | -29.959 | -71.3389 | 2021-10-11 04:21:31 | Coquimbo, Chile | |||
2875979 | 2875979 | 2021-10-09 | Chile | Coquimbo | 49032 | 1029 | 0 | -29.959 | -71.3389 | 2021-10-10 04:21:38 | Coquimbo, Chile | |||
2959145 | 2959145 | 2021-10-08 | Chile | Coquimbo | 48997 | 1028 | 0 | -29.959 | -71.3389 | 2021-10-09 04:21:34 | Coquimbo, Chile | |||
467183 | 467183 | 2021-10-07 | Chile | Coquimbo | 48974 | 1250 | 0 | -29.959 | -71.3389 | 2021-10-08 04:21:25 | Coquimbo, Chile | |||
2458563 | 2458563 | 2021-10-06 | Chile | Coquimbo | 48959 | 1028 | 0 | -29.959 | -71.3389 | 2021-10-07 04:21:36 | Coquimbo, Chile |
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]);