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 = "Tarapaca" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2043630 | 2043630 | 2021-10-18 | Chile | Tarapaca | 42025 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-19 04:20:54 | Tarapaca, Chile | |||
1908991 | 1908991 | 2021-10-17 | Chile | Tarapaca | 41998 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-18 04:21:10 | Tarapaca, Chile | |||
934580 | 934580 | 2021-10-16 | Chile | Tarapaca | 41955 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-17 04:21:29 | Tarapaca, Chile | |||
2943135 | 2943135 | 2021-10-15 | Chile | Tarapaca | 41910 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-16 04:21:15 | Tarapaca, Chile | |||
491415 | 491415 | 2021-10-14 | Chile | Tarapaca | 41888 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-15 04:21:26 | Tarapaca, Chile | |||
633703 | 633703 | 2021-10-13 | Chile | Tarapaca | 41867 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-14 04:21:29 | Tarapaca, Chile | |||
1491381 | 1491381 | 2021-10-12 | Chile | Tarapaca | 41830 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-13 04:20:51 | Tarapaca, Chile | |||
3007114 | 3007114 | 2021-10-11 | Chile | Tarapaca | 41810 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-12 04:21:09 | Tarapaca, Chile | |||
423130 | 423130 | 2021-10-10 | Chile | Tarapaca | 41777 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-11 04:21:31 | Tarapaca, Chile | |||
2875987 | 2875987 | 2021-10-09 | Chile | Tarapaca | 41761 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-10 04:21:38 | Tarapaca, Chile | |||
2959153 | 2959153 | 2021-10-08 | Chile | Tarapaca | 41723 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-09 04:21:34 | Tarapaca, Chile | |||
467191 | 467191 | 2021-10-07 | Chile | Tarapaca | 41706 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-08 04:21:25 | Tarapaca, Chile | |||
2458571 | 2458571 | 2021-10-06 | Chile | Tarapaca | 41663 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-07 04:21:36 | Tarapaca, Chile | |||
3832265 | 3832265 | 2021-10-05 | Chile | Tarapaca | 41649 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-06 04:21:33 | Tarapaca, Chile | |||
986758 | 986758 | 2021-10-04 | Chile | Tarapaca | 41619 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-05 04:21:27 | Tarapaca, Chile | |||
1274068 | 1274068 | 2021-10-03 | Chile | Tarapaca | 41580 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-04 04:21:31 | Tarapaca, Chile | |||
3927821 | 3927821 | 2021-10-02 | Chile | Tarapaca | 41557 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-03 04:21:24 | Tarapaca, Chile | |||
2131801 | 2131801 | 2021-10-01 | Chile | Tarapaca | 41536 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-02 04:21:25 | Tarapaca, Chile | |||
2772758 | 2772758 | 2021-09-30 | Chile | Tarapaca | 41498 | 810 | 0 | -19.9232 | -69.5132 | 2021-10-01 04:21:35 | Tarapaca, Chile | |||
706214 | 706214 | 2021-09-29 | Chile | Tarapaca | 41467 | 810 | 0 | -19.9232 | -69.5132 | 2021-09-30 04:21:20 | Tarapaca, Chile | |||
1334056 | 1334056 | 2021-09-28 | Chile | Tarapaca | 41452 | 810 | 0 | -19.9232 | -69.5132 | 2021-09-29 04:21:45 | Tarapaca, Chile | |||
1235425 | 1235425 | 2021-09-27 | Chile | Tarapaca | 41423 | 810 | 0 | -19.9232 | -69.5132 | 2021-09-28 04:21:28 | Tarapaca, Chile | |||
2075726 | 2075726 | 2021-09-26 | Chile | Tarapaca | 41403 | 810 | 0 | -19.9232 | -69.5132 | 2021-09-27 04:21:16 | Tarapaca, Chile | |||
1724278 | 1724278 | 2021-09-25 | Chile | Tarapaca | 41386 | 810 | 0 | -19.9232 | -69.5132 | 2021-09-26 04:21:29 | Tarapaca, Chile | |||
1920998 | 1920998 | 2021-09-24 | Chile | Tarapaca | 41375 | 809 | 0 | -19.9232 | -69.5132 | 2021-09-25 04:21:31 | Tarapaca, Chile | |||
601469 | 601469 | 2021-09-23 | Chile | Tarapaca | 41348 | 809 | 0 | -19.9232 | -69.5132 | 2021-09-24 04:21:44 | Tarapaca, Chile | |||
3011130 | 3011130 | 2021-09-22 | Chile | Tarapaca | 41327 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-23 04:21:43 | Tarapaca, Chile | |||
3757268 | 3757268 | 2021-09-21 | Chile | Tarapaca | 41317 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-22 04:21:45 | Tarapaca, Chile | |||
809371 | 809371 | 2021-09-20 | Chile | Tarapaca | 41310 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-21 04:21:26 | Tarapaca, Chile | |||
1814570 | 1814570 | 2021-09-19 | Chile | Tarapaca | 41304 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-20 04:21:22 | Tarapaca, Chile | |||
16150 | 16150 | 2021-09-18 | Chile | Tarapaca | 41288 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-19 04:21:34 | Tarapaca, Chile | |||
2617835 | 2617835 | 2021-09-17 | Chile | Tarapaca | 41261 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-18 04:21:24 | Tarapaca, Chile | |||
2808543 | 2808543 | 2021-09-16 | Chile | Tarapaca | 41240 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-17 04:21:46 | Tarapaca, Chile | |||
1374288 | 1374288 | 2021-09-15 | Chile | Tarapaca | 41212 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-16 04:22:19 | Tarapaca, Chile | |||
2462587 | 2462587 | 2021-09-14 | Chile | Tarapaca | 41195 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-15 03:22:37 | Tarapaca, Chile | |||
1385426 | 1385426 | 2021-09-13 | Chile | Tarapaca | 41182 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-14 04:21:41 | Tarapaca, Chile | |||
1884795 | 1884795 | 2021-09-12 | Chile | Tarapaca | 41163 | 808 | 0 | -19.9232 | -69.5132 | 2021-09-13 04:21:15 | Tarapaca, Chile | |||
3805698 | 3805698 | 2021-09-11 | Chile | Tarapaca | 41154 | 806 | 0 | -19.9232 | -69.5132 | 2021-09-12 04:21:13 | Tarapaca, Chile | |||
3448638 | 3448638 | 2021-09-10 | Chile | Tarapaca | 41141 | 806 | 0 | -19.9232 | -69.5132 | 2021-09-11 04:21:30 | Tarapaca, Chile | |||
1262584 | 1262584 | 2021-09-09 | Chile | Tarapaca | 41121 | 806 | 0 | -19.9232 | -69.5132 | 2021-09-10 04:21:20 | Tarapaca, Chile | |||
2278954 | 2278954 | 2021-09-08 | Chile | Tarapaca | 41112 | 806 | 0 | -19.9232 | -69.5132 | 2021-09-09 04:21:27 | Tarapaca, Chile | |||
641733 | 641733 | 2021-09-07 | Chile | Tarapaca | 41105 | 805 | 0 | -19.9232 | -69.5132 | 2021-09-08 04:21:31 | Tarapaca, Chile | |||
3193796 | 3193796 | 2021-09-06 | Chile | Tarapaca | 41098 | 805 | 0 | -19.9232 | -69.5132 | 2021-09-07 04:21:35 | Tarapaca, Chile | |||
3280664 | 3280664 | 2021-09-05 | Chile | Tarapaca | 41086 | 805 | 0 | -19.9232 | -69.5132 | 2021-09-06 04:21:22 | Tarapaca, Chile | |||
249078 | 249078 | 2021-09-04 | Chile | Tarapaca | 41076 | 805 | 0 | -19.9232 | -69.5132 | 2021-09-05 04:21:33 | Tarapaca, Chile | |||
3974359 | 3974359 | 2021-09-03 | Chile | Tarapaca | 41060 | 805 | 0 | -19.9232 | -69.5132 | 2021-09-04 04:21:28 | Tarapaca, Chile | |||
177821 | 177821 | 2021-09-02 | Chile | Tarapaca | 41052 | 803 | 0 | -19.9232 | -69.5132 | 2021-09-03 04:21:20 | Tarapaca, Chile | |||
66856 | 66856 | 2021-09-01 | Chile | Tarapaca | 41040 | 803 | 0 | -19.9232 | -69.5132 | 2021-09-02 04:21:15 | Tarapaca, Chile | |||
2067698 | 2067698 | 2021-08-31 | Chile | Tarapaca | 41014 | 803 | 0 | -19.9232 | -69.5132 | 2021-09-01 04:21:38 | Tarapaca, Chile | |||
1775152 | 1775152 | 2021-08-30 | Chile | Tarapaca | 41004 | 803 | 0 | -19.9232 | -69.5132 | 2021-08-31 04:21:46 | Tarapaca, Chile | |||
3891726 | 3891726 | 2021-08-29 | Chile | Tarapaca | 40992 | 803 | 0 | -19.9232 | -69.5132 | 2021-08-30 04:21:23 | Tarapaca, Chile | |||
2792829 | 2792829 | 2021-08-28 | Chile | Tarapaca | 40970 | 803 | 0 | -19.9232 | -69.5132 | 2021-08-29 04:21:14 | Tarapaca, Chile | |||
2922988 | 2922988 | 2021-08-27 | Chile | Tarapaca | 40960 | 803 | 0 | -19.9232 | -69.5132 | 2021-08-28 04:21:28 | Tarapaca, Chile | |||
1596002 | 1596002 | 2021-08-26 | Chile | Tarapaca | 40945 | 802 | 0 | -19.9232 | -69.5132 | 2021-08-27 04:21:37 | Tarapaca, Chile | |||
32211 | 32211 | 2021-08-25 | Chile | Tarapaca | 40921 | 801 | 0 | -19.9232 | -69.5132 | 2021-08-26 04:21:28 | Tarapaca, Chile | |||
3105250 | 3105250 | 2021-08-24 | Chile | Tarapaca | 40915 | 801 | 0 | -19.9232 | -69.5132 | 2021-08-25 04:21:41 | Tarapaca, Chile | |||
3165421 | 3165421 | 2021-08-23 | Chile | Tarapaca | 40910 | 801 | 0 | -19.9232 | -69.5132 | 2021-08-24 04:21:19 | Tarapaca, Chile | |||
2175348 | 2175348 | 2021-08-22 | Chile | Tarapaca | 40890 | 800 | 0 | -19.9232 | -69.5132 | 2021-08-23 04:21:27 | Tarapaca, Chile | |||
3555444 | 3555444 | 2021-08-21 | Chile | Tarapaca | 40870 | 800 | 0 | -19.9232 | -69.5132 | 2021-08-22 04:21:29 | Tarapaca, Chile | |||
1853786 | 1853786 | 2021-08-20 | Chile | Tarapaca | 40813 | 799 | 0 | -19.9232 | -69.5132 | 2021-08-21 04:21:38 | Tarapaca, Chile | |||
511493 | 511493 | 2021-08-19 | Chile | Tarapaca | 40793 | 799 | 0 | -19.9232 | -69.5132 | 2021-08-20 04:21:33 | Tarapaca, Chile | |||
2517972 | 2517972 | 2021-08-18 | Chile | Tarapaca | 40815 | 798 | 0 | -19.9232 | -69.5132 | 2021-08-19 04:21:15 | Tarapaca, Chile | |||
245064 | 245064 | 2021-08-17 | Chile | Tarapaca | 40799 | 798 | 0 | -19.9232 | -69.5132 | 2021-08-18 04:21:35 | Tarapaca, Chile | |||
1604027 | 1604027 | 2021-08-16 | Chile | Tarapaca | 40789 | 798 | 0 | -19.9232 | -69.5132 | 2021-08-17 04:21:49 | Tarapaca, Chile | |||
103121 | 103121 | 2021-08-15 | Chile | Tarapaca | 40776 | 797 | 0 | -19.9232 | -69.5132 | 2021-08-16 04:21:31 | Tarapaca, Chile | |||
507479 | 507479 | 2021-08-14 | Chile | Tarapaca | 40756 | 797 | 0 | -19.9232 | -69.5132 | 2021-08-15 04:21:41 | Tarapaca, Chile | |||
1483351 | 1483351 | 2021-08-13 | Chile | Tarapaca | 40734 | 796 | 0 | -19.9232 | -69.5132 | 2021-08-14 04:21:25 | Tarapaca, Chile | |||
2899481 | 2899481 | 2021-08-12 | Chile | Tarapaca | 40755 | 796 | 0 | -19.9232 | -69.5132 | 2021-08-13 04:21:24 | Tarapaca, Chile | |||
1342085 | 1342085 | 2021-08-11 | Chile | Tarapaca | 40666 | 794 | 0 | -19.9232 | -69.5132 | 2021-08-12 04:21:25 | Tarapaca, Chile | |||
2351232 | 2351232 | 2021-08-10 | Chile | Tarapaca | 40625 | 794 | 0 | -19.9232 | -69.5132 | 2021-08-11 04:21:58 | Tarapaca, Chile | |||
649761 | 649761 | 2021-08-09 | Chile | Tarapaca | 40597 | 794 | 0 | -19.9232 | -69.5132 | 2021-08-10 04:21:27 | Tarapaca, Chile | |||
589423 | 589423 | 2021-08-08 | Chile | Tarapaca | 40570 | 793 | 0 | -19.9232 | -69.5132 | 2021-08-09 04:21:24 | Tarapaca, Chile | |||
2203435 | 2203435 | 2021-08-07 | Chile | Tarapaca | 40551 | 793 | 0 | -19.9232 | -69.5132 | 2021-08-08 04:21:33 | Tarapaca, Chile | |||
1117385 | 1117385 | 2021-08-06 | Chile | Tarapaca | 40521 | 792 | 0 | -19.9232 | -69.5132 | 2021-08-07 04:21:30 | Tarapaca, Chile | |||
1956322 | 1956322 | 2021-08-05 | Chile | Tarapaca | 40454 | 791 | 0 | -19.9232 | -69.5132 | 2021-08-06 04:21:18 | Tarapaca, Chile | |||
331701 | 331701 | 2021-08-04 | Chile | Tarapaca | 40428 | 787 | 39435 | 206 | -19.9232 | -69.5132 | 2021-08-05 04:21:51 | Tarapaca, Chile | ||
3467972 | 3467972 | 2021-08-03 | Chile | Tarapaca | 40393 | 787 | 39384 | 222 | -19.9232 | -69.5132 | 2021-08-04 04:21:25 | Tarapaca, Chile | ||
3683246 | 3683246 | 2021-08-02 | Chile | Tarapaca | 40352 | 787 | 39360 | 205 | -19.9232 | -69.5132 | 2021-08-03 04:21:39 | Tarapaca, Chile | ||
3015145 | 3015145 | 2021-08-01 | Chile | Tarapaca | 40334 | 784 | 39337 | 213 | -19.9232 | -69.5132 | 2021-08-02 04:21:36 | Tarapaca, Chile | ||
3903768 | 3903768 | 2021-07-31 | Chile | Tarapaca | 40311 | 782 | 39315 | 214 | -19.9232 | -69.5132 | 2021-08-01 04:21:50 | Tarapaca, Chile | ||
3295973 | 3295973 | 2021-07-30 | Chile | Tarapaca | 40265 | 782 | 39282 | 201 | -19.9232 | -69.5132 | 2021-07-31 04:21:35 | Tarapaca, Chile | ||
3385184 | 3385184 | 2021-07-29 | Chile | Tarapaca | 40240 | 779 | 39266 | 195 | -19.9232 | -69.5132 | 2021-07-30 04:21:34 | Tarapaca, Chile | ||
408089 | 408089 | 2021-07-28 | Chile | Tarapaca | 40200 | 775 | 39244 | 181 | -19.9232 | -69.5132 | 2021-07-29 04:21:33 | Tarapaca, Chile | ||
1305950 | 1305950 | 2021-07-27 | Chile | Tarapaca | 40192 | 775 | 39229 | 188 | -19.9232 | -69.5132 | 2021-07-28 04:21:39 | Tarapaca, Chile | ||
3218093 | 3218093 | 2021-07-26 | Chile | Tarapaca | 40184 | 775 | 39208 | 201 | -19.9232 | -69.5132 | 2021-07-27 04:21:18 | Tarapaca, Chile | ||
1378302 | 1378302 | 2021-07-25 | Chile | Tarapaca | 40150 | 772 | 39182 | 196 | -19.9232 | -69.5132 | 2021-07-26 04:21:28 | Tarapaca, Chile | ||
1330042 | 1330042 | 2021-07-24 | Chile | Tarapaca | 40125 | 771 | 39153 | 201 | -19.9232 | -69.5132 | 2021-07-25 04:22:12 | Tarapaca, Chile | ||
3137346 | 3137346 | 2021-07-23 | Chile | Tarapaca | 40095 | 771 | 39119 | 205 | -19.9232 | -69.5132 | 2021-07-24 00:21:36 | Tarapaca, Chile | ||
3476106 | 3476106 | 2021-07-22 | Chile | Tarapaca | 40067 | 768 | 39092 | 207 | -19.9232 | -69.5132 | 2021-07-23 04:21:29 | Tarapaca, Chile | ||
3331325 | 3331325 | 2021-07-21 | Chile | Tarapaca | 39988 | 764 | 39028 | 196 | -19.9232 | -69.5132 | 2021-07-22 04:21:19 | Tarapaca, Chile | ||
2371306 | 2371306 | 2021-07-20 | Chile | Tarapaca | 39928 | 764 | 38954 | 210 | -19.9232 | -69.5132 | 2021-07-21 04:21:40 | Tarapaca, Chile | ||
483385 | 483385 | 2021-07-19 | Chile | Tarapaca | 39835 | 764 | 38851 | 220 | -19.9232 | -69.5132 | 2021-07-20 04:21:48 | Tarapaca, Chile | ||
2673608 | 2673608 | 2021-07-18 | Chile | Tarapaca | 39817 | 764 | 38822 | 231 | -19.9232 | -69.5132 | 2021-07-19 04:21:24 | Tarapaca, Chile | ||
3705920 | 3705920 | 2021-07-17 | Chile | Tarapaca | 39803 | 764 | 38800 | 239 | -19.9232 | -69.5132 | 2021-07-18 04:22:07 | Tarapaca, Chile | ||
2947151 | 2947151 | 2021-07-16 | Chile | Tarapaca | 39740 | 763 | 38715 | 262 | -19.9232 | -69.5132 | 2021-07-17 04:22:22 | Tarapaca, Chile | ||
295807 | 295807 | 2021-07-15 | Chile | Tarapaca | 39649 | 762 | 38627 | 260 | -19.9232 | -69.5132 | 2021-07-16 04:21:22 | Tarapaca, Chile | ||
3631752 | 3631752 | 2021-07-14 | Chile | Tarapaca | 39560 | 757 | 38551 | 252 | -19.9232 | -69.5132 | 2021-07-15 04:21:48 | Tarapaca, Chile | ||
578627 | 578627 | 2021-07-13 | Chile | Tarapaca | 39541 | 757 | 38502 | 282 | -19.9232 | -69.5132 | 2021-07-14 04:21:35 | Tarapaca, Chile | ||
3740876 | 3740876 | 2021-07-12 | Chile | Tarapaca | 39515 | 757 | 38457 | 301 | -19.9232 | -69.5132 | 2021-07-13 04:21:18 | Tarapaca, Chile | ||
3659389 | 3659389 | 2021-07-11 | Chile | Tarapaca | 39485 | 755 | 38407 | 323 | -19.9232 | -69.5132 | 2021-07-12 04:21:34 | Tarapaca, 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]);