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 = "Arica y Parinacota" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
day (date) >30 ✖
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- …
province_or_state 1
- Arica y Parinacota · 954 ✖
country_or_region 1
- Chile · 954 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431810 | 1431810 | 2020-05-20 | Chile | Arica y Parinacota | 424 | 7 | 0 | 417 | -18.594 | -69.4785 | 2020-05-21 02:32:48 | Arica y Parinacota, Chile | ||
268227 | 268227 | 2020-05-21 | Chile | Arica y Parinacota | 453 | 7 | 0 | 446 | -18.594 | -69.4785 | 2020-05-22 02:36:51 | Arica y Parinacota, Chile | ||
1864721 | 1864721 | 2020-05-22 | Chile | Arica y Parinacota | 471 | 7 | 0 | 464 | -18.594 | -69.4785 | 2020-05-23 02:32:42 | Arica y Parinacota, Chile | ||
997698 | 997698 | 2020-05-23 | Chile | Arica y Parinacota | 482 | 7 | 0 | 475 | -18.594 | -69.4785 | 2020-05-24 02:32:43 | Arica y Parinacota, Chile | ||
875507 | 875507 | 2020-05-24 | Chile | Arica y Parinacota | 498 | 7 | 0 | 491 | -18.594 | -69.4785 | 2020-05-25 02:32:44 | Arica y Parinacota, Chile | ||
1104827 | 1104827 | 2020-05-25 | Chile | Arica y Parinacota | 513 | 7 | 0 | 506 | -18.594 | -69.4785 | 2020-05-26 02:32:35 | Arica y Parinacota, Chile | ||
1041097 | 1041097 | 2020-05-26 | Chile | Arica y Parinacota | 522 | 7 | 0 | 515 | -18.594 | -69.4785 | 2020-05-27 02:32:31 | Arica y Parinacota, Chile | ||
2548134 | 2548134 | 2020-05-27 | Chile | Arica y Parinacota | 541 | 7 | 0 | 534 | -18.594 | -69.4785 | 2020-05-28 02:32:31 | Arica y Parinacota, Chile | ||
2712124 | 2712124 | 2020-05-28 | Chile | Arica y Parinacota | 562 | 7 | 0 | 555 | -18.594 | -69.4785 | 2020-05-29 02:32:50 | Arica y Parinacota, Chile | ||
1790244 | 1790244 | 2020-05-29 | Chile | Arica y Parinacota | 582 | 7 | 0 | 575 | -18.594 | -69.4785 | 2020-05-30 02:32:48 | Arica y Parinacota, Chile | ||
3638703 | 3638703 | 2020-05-30 | Chile | Arica y Parinacota | 588 | 7 | 0 | 581 | -18.594 | -69.4785 | 2020-05-31 02:32:45 | Arica y Parinacota, Chile | ||
1793810 | 1793810 | 2020-05-31 | Chile | Arica y Parinacota | 619 | 7 | 0 | 612 | -18.594 | -69.4785 | 2020-06-01 02:32:46 | Arica y Parinacota, Chile | ||
805169 | 805169 | 2020-06-01 | Chile | Arica y Parinacota | 636 | 8 | 0 | 628 | -18.594 | -69.4785 | 2020-06-02 02:33:08 | Arica y Parinacota, Chile | ||
2555633 | 2555633 | 2020-06-02 | Chile | Arica y Parinacota | 654 | 0 | 0 | 654 | -18.594 | -69.4785 | 2020-06-03 02:33:13 | Arica y Parinacota, Chile | ||
3866590 | 3866590 | 2020-06-03 | Chile | Arica y Parinacota | 701 | 0 | 0 | 701 | -18.594 | -69.4785 | 2020-06-04 02:33:14 | Arica y Parinacota, Chile | ||
1281035 | 1281035 | 2020-06-04 | Chile | Arica y Parinacota | 736 | 8 | 0 | 728 | -18.594 | -69.4785 | 2020-06-05 02:33:06 | Arica y Parinacota, Chile | ||
1269554 | 1269554 | 2020-06-05 | Chile | Arica y Parinacota | 782 | 9 | 0 | 773 | -18.594 | -69.4785 | 2020-06-06 02:33:00 | Arica y Parinacota, Chile | ||
573857 | 573857 | 2020-06-06 | Chile | Arica y Parinacota | 819 | 9 | 0 | 810 | -18.594 | -69.4785 | 2020-06-07 03:53:30 | Arica y Parinacota, Chile | ||
2799801 | 2799801 | 2020-06-07 | Chile | Arica y Parinacota | 850 | 10 | 0 | 840 | -18.594 | -69.4785 | 2020-06-08 03:33:22 | Arica y Parinacota, Chile | ||
217004 | 217004 | 2020-06-08 | Chile | Arica y Parinacota | 874 | 8 | 0 | 866 | -18.594 | -69.4785 | 2020-06-09 03:33:03 | Arica y Parinacota, Chile | ||
1210577 | 1210577 | 2020-06-09 | Chile | Arica y Parinacota | 914 | 8 | 0 | 906 | -18.594 | -69.4785 | 2020-06-10 04:07:00 | Arica y Parinacota, Chile | ||
2863719 | 2863719 | 2020-06-10 | Chile | Arica y Parinacota | 930 | 10 | 0 | 920 | -18.594 | -69.4785 | 2020-06-11 03:33:41 | Arica y Parinacota, Chile | ||
1273275 | 1273275 | 2020-06-11 | Chile | Arica y Parinacota | 967 | 10 | 0 | 957 | -18.594 | -69.4785 | 2020-06-12 05:09:52 | Arica y Parinacota, Chile | ||
737305 | 737305 | 2020-06-12 | Chile | Arica y Parinacota | 1011 | 10 | 0 | 1001 | -18.594 | -69.4785 | 2020-06-13 03:33:14 | Arica y Parinacota, Chile | ||
3060985 | 3060985 | 2020-06-13 | Chile | Arica y Parinacota | 1062 | 10 | 0 | 1052 | -18.594 | -69.4785 | 2020-06-14 03:33:15 | Arica y Parinacota, Chile | ||
1836933 | 1836933 | 2020-06-14 | Chile | Arica y Parinacota | 1109 | 11 | 0 | 1098 | -18.594 | -69.4785 | 2020-06-15 03:33:14 | Arica y Parinacota, Chile | ||
286982 | 286982 | 2020-06-15 | Chile | Arica y Parinacota | 1139 | 11 | 0 | 1128 | -18.594 | -69.4785 | 2020-06-16 04:33:09 | Arica y Parinacota, Chile | ||
2386419 | 2386419 | 2020-06-16 | Chile | Arica y Parinacota | 1156 | 11 | 0 | 1145 | -18.594 | -69.4785 | 2020-06-17 04:33:21 | Arica y Parinacota, Chile | ||
1195656 | 1195656 | 2020-06-17 | Chile | Arica y Parinacota | 1218 | 11 | 0 | 1207 | -18.594 | -69.4785 | 2020-06-18 04:33:18 | Arica y Parinacota, Chile | ||
3682453 | 3682453 | 2020-06-18 | Chile | Arica y Parinacota | 1239 | 12 | 0 | 1227 | -18.594 | -69.4785 | 2020-06-19 04:33:17 | Arica y Parinacota, Chile | ||
1691304 | 1691304 | 2020-06-19 | Chile | Arica y Parinacota | 1295 | 12 | 0 | 1283 | -18.594 | -69.4785 | 2020-06-20 04:33:19 | Arica y Parinacota, Chile | ||
2437726 | 2437726 | 2020-06-20 | Chile | Arica y Parinacota | 1325 | 12 | 0 | 1313 | -18.594 | -69.4785 | 2020-06-21 04:33:19 | Arica y Parinacota, Chile | ||
3249133 | 3249133 | 2020-06-21 | Chile | Arica y Parinacota | 1371 | 12 | 0 | 1359 | -18.594 | -69.4785 | 2020-06-22 04:33:20 | Arica y Parinacota, Chile | ||
1510394 | 1510394 | 2020-06-22 | Chile | Arica y Parinacota | 1420 | 12 | 0 | 1408 | -18.594 | -69.4785 | 2020-06-23 04:33:22 | Arica y Parinacota, Chile | ||
1522200 | 1522200 | 2020-06-23 | Chile | Arica y Parinacota | 1443 | 12 | 0 | 1431 | -18.594 | -69.4785 | 2020-06-24 04:33:28 | Arica y Parinacota, Chile | ||
2700515 | 2700515 | 2020-06-24 | Chile | Arica y Parinacota | 1473 | 15 | 0 | 1458 | -18.594 | -69.4785 | 2020-06-25 05:26:54 | Arica y Parinacota, Chile | ||
2624875 | 2624875 | 2020-06-25 | Chile | Arica y Parinacota | 1511 | 16 | 0 | 1495 | -18.594 | -69.4785 | 2020-06-26 04:33:43 | Arica y Parinacota, Chile | ||
1135888 | 1135888 | 2020-06-26 | Chile | Arica y Parinacota | 1549 | 19 | 0 | 1530 | -18.594 | -69.4785 | 2020-06-27 04:33:35 | Arica y Parinacota, Chile | ||
2039607 | 2039607 | 2020-06-27 | Chile | Arica y Parinacota | 1611 | 20 | 0 | 1591 | -18.594 | -69.4785 | 2020-06-28 04:34:04 | Arica y Parinacota, Chile | ||
2306272 | 2306272 | 2020-06-28 | Chile | Arica y Parinacota | 1649 | 20 | 0 | 1629 | -18.594 | -69.4785 | 2020-06-29 04:33:44 | Arica y Parinacota, Chile | ||
2632709 | 2632709 | 2020-06-29 | Chile | Arica y Parinacota | 1685 | 20 | 1299 | 366 | -18.594 | -69.4785 | 2020-06-30 04:33:48 | Arica y Parinacota, Chile | ||
2974232 | 2974232 | 2020-06-30 | Chile | Arica y Parinacota | 1713 | 20 | 1340 | 353 | -18.594 | -69.4785 | 2020-07-01 04:33:52 | Arica y Parinacota, Chile | ||
302854 | 302854 | 2020-07-01 | Chile | Arica y Parinacota | 1776 | 20 | 1377 | 379 | -18.594 | -69.4785 | 2020-07-02 04:33:46 | Arica y Parinacota, Chile | ||
3045163 | 3045163 | 2020-07-02 | Chile | Arica y Parinacota | 1832 | 21 | 1408 | 403 | -18.594 | -69.4785 | 2020-07-03 04:33:54 | Arica y Parinacota, Chile | ||
2234369 | 2234369 | 2020-07-03 | Chile | Arica y Parinacota | 1889 | 22 | 1447 | 420 | -18.594 | -69.4785 | 2020-07-04 04:33:51 | Arica y Parinacota, Chile | ||
529708 | 529708 | 2020-07-04 | Chile | Arica y Parinacota | 1949 | 22 | 1497 | 430 | -18.594 | -69.4785 | 2020-07-05 04:33:46 | Arica y Parinacota, Chile | ||
415146 | 415146 | 2020-07-05 | Chile | Arica y Parinacota | 2006 | 22 | 1530 | 454 | -18.594 | -69.4785 | 2020-07-06 04:33:57 | Arica y Parinacota, Chile | ||
2684681 | 2684681 | 2020-07-06 | Chile | Arica y Parinacota | 2087 | 22 | 1571 | 494 | -18.594 | -69.4785 | 2020-07-07 04:34:00 | Arica y Parinacota, Chile | ||
887121 | 887121 | 2020-07-07 | Chile | Arica y Parinacota | 2119 | 22 | 1621 | 476 | -18.594 | -69.4785 | 2020-07-08 05:33:48 | Arica y Parinacota, Chile | ||
2222512 | 2222512 | 2020-07-08 | Chile | Arica y Parinacota | 2179 | 24 | 1673 | 482 | -18.594 | -69.4785 | 2020-07-09 04:34:23 | Arica y Parinacota, Chile | ||
1005296 | 1005296 | 2020-07-09 | Chile | Arica y Parinacota | 2273 | 24 | 1706 | 543 | -18.594 | -69.4785 | 2020-07-10 04:34:24 | Arica y Parinacota, Chile | ||
3237311 | 3237311 | 2020-07-10 | Chile | Arica y Parinacota | 2322 | 26 | 1753 | 543 | -18.594 | -69.4785 | 2020-07-11 04:34:26 | Arica y Parinacota, Chile | ||
3435813 | 3435813 | 2020-07-11 | Chile | Arica y Parinacota | 2395 | 26 | 1801 | 568 | -18.594 | -69.4785 | 2020-07-12 04:34:30 | Arica y Parinacota, Chile | ||
3737418 | 3737418 | 2020-07-12 | Chile | Arica y Parinacota | 2467 | 28 | 1862 | 577 | -18.594 | -69.4785 | 2020-07-13 04:43:04 | Arica y Parinacota, Chile | ||
3491156 | 3491156 | 2020-07-13 | Chile | Arica y Parinacota | 2562 | 28 | 1920 | 614 | -18.594 | -69.4785 | 2020-07-14 04:34:46 | Arica y Parinacota, Chile | ||
2158515 | 2158515 | 2020-07-14 | Chile | Arica y Parinacota | 2638 | 28 | 1965 | 645 | -18.594 | -69.4785 | 2020-07-15 04:34:39 | Arica y Parinacota, Chile | ||
2747871 | 2747871 | 2020-07-15 | Chile | Arica y Parinacota | 2735 | 31 | 2025 | 679 | -18.594 | -69.4785 | 2020-07-16 04:44:59 | Arica y Parinacota, Chile | ||
367203 | 367203 | 2020-07-16 | Chile | Arica y Parinacota | 2840 | 32 | 2093 | 715 | -18.594 | -69.4785 | 2020-07-17 04:34:50 | Arica y Parinacota, Chile | ||
2708384 | 2708384 | 2020-07-17 | Chile | Arica y Parinacota | 2936 | 34 | 2141 | 761 | -18.594 | -69.4785 | 2020-07-18 04:34:45 | Arica y Parinacota, Chile | ||
3205082 | 3205082 | 2020-07-18 | Chile | Arica y Parinacota | 3012 | 35 | 2199 | 778 | -18.594 | -69.4785 | 2020-07-19 04:34:58 | Arica y Parinacota, Chile | ||
121693 | 121693 | 2020-07-19 | Chile | Arica y Parinacota | 3056 | 36 | 2260 | 760 | -18.594 | -69.4785 | 2020-07-20 05:34:40 | Arica y Parinacota, Chile | ||
326788 | 326788 | 2020-07-20 | Chile | Arica y Parinacota | 3056 | 36 | 2260 | 760 | -18.594 | -69.4785 | 2020-07-21 04:38:46 | Arica y Parinacota, Chile | ||
844558 | 844558 | 2020-07-22 | Chile | Arica y Parinacota | 3291 | 40 | 2425 | 826 | -18.594 | -69.4785 | 2020-07-23 05:15:04 | Arica y Parinacota, Chile | ||
1707297 | 1707297 | 2020-07-21 | Chile | Arica y Parinacota | 3291 | 40 | 2425 | 826 | -18.594 | -69.4785 | 2020-07-22 04:34:42 | Arica y Parinacota, Chile | ||
61769 | 61769 | 2020-07-23 | Chile | Arica y Parinacota | 3482 | 41 | 2583 | 858 | -18.594 | -69.4785 | 2020-07-24 05:30:40 | Arica y Parinacota, Chile | ||
2563538 | 2563538 | 2020-07-24 | Chile | Arica y Parinacota | 3627 | 43 | 2671 | 913 | -18.594 | -69.4785 | 2020-07-25 04:47:39 | Arica y Parinacota, Chile | ||
1502568 | 1502568 | 2020-07-25 | Chile | Arica y Parinacota | 3727 | 46 | 2791 | 890 | -18.594 | -69.4785 | 2020-07-26 04:35:00 | Arica y Parinacota, Chile | ||
442324 | 442324 | 2020-07-26 | Chile | Arica y Parinacota | 3862 | 47 | 2879 | 936 | -18.594 | -69.4785 | 2020-07-27 04:35:02 | Arica y Parinacota, Chile | ||
177011 | 177011 | 2020-07-27 | Chile | Arica y Parinacota | 3939 | 51 | 2958 | 930 | -18.594 | -69.4785 | 2020-07-28 04:58:43 | Arica y Parinacota, Chile | ||
3184959 | 3184959 | 2020-07-28 | Chile | Arica y Parinacota | 4060 | 51 | 3075 | 934 | -18.594 | -69.4785 | 2020-07-29 04:35:11 | Arica y Parinacota, Chile | ||
2958343 | 2958343 | 2020-07-29 | Chile | Arica y Parinacota | 4159 | 51 | 3160 | 948 | -18.594 | -69.4785 | 2020-07-30 04:35:05 | Arica y Parinacota, Chile | ||
1928175 | 1928175 | 2020-07-30 | Chile | Arica y Parinacota | 4257 | 56 | 3270 | 931 | -18.594 | -69.4785 | 2020-07-31 04:35:18 | Arica y Parinacota, Chile | ||
3264468 | 3264468 | 2020-07-31 | Chile | Arica y Parinacota | 4343 | 58 | 3371 | 914 | -18.594 | -69.4785 | 2020-08-01 04:36:27 | Arica y Parinacota, Chile | ||
753303 | 753303 | 2020-08-01 | Chile | Arica y Parinacota | 4450 | 60 | 3496 | 894 | -18.594 | -69.4785 | 2020-08-02 04:34:47 | Arica y Parinacota, Chile | ||
2807735 | 2807735 | 2020-08-02 | Chile | Arica y Parinacota | 4525 | 63 | 3606 | 856 | -18.594 | -69.4785 | 2020-08-03 04:34:35 | Arica y Parinacota, Chile | ||
2739983 | 2739983 | 2020-08-03 | Chile | Arica y Parinacota | 4584 | 68 | 3687 | 829 | -18.594 | -69.4785 | 2020-08-04 04:41:59 | Arica y Parinacota, Chile | ||
98100 | 98100 | 2020-08-04 | Chile | Arica y Parinacota | 4662 | 68 | 3831 | 763 | -18.594 | -69.4785 | 2020-08-05 04:34:43 | Arica y Parinacota, Chile | ||
3792864 | 3792864 | 2020-08-05 | Chile | Arica y Parinacota | 4727 | 68 | 3930 | 729 | -18.594 | -69.4785 | 2020-08-06 04:35:02 | Arica y Parinacota, Chile | ||
3612034 | 3612034 | 2020-08-06 | Chile | Arica y Parinacota | 4825 | 73 | 4062 | 690 | -18.594 | -69.4785 | 2020-08-07 04:35:11 | Arica y Parinacota, Chile | ||
458349 | 458349 | 2020-08-07 | Chile | Arica y Parinacota | 4911 | 74 | 4152 | 685 | -18.594 | -69.4785 | 2020-08-08 04:34:53 | Arica y Parinacota, Chile | ||
371165 | 371165 | 2020-08-08 | Chile | Arica y Parinacota | 4988 | 76 | 4237 | 675 | -18.594 | -69.4785 | 2020-08-09 04:34:54 | Arica y Parinacota, Chile | ||
3922997 | 3922997 | 2020-08-09 | Chile | Arica y Parinacota | 5138 | 77 | 4318 | 743 | -18.594 | -69.4785 | 2020-08-10 04:34:55 | Arica y Parinacota, Chile | ||
1920188 | 1920188 | 2020-08-10 | Chile | Arica y Parinacota | 5241 | 78 | 4393 | 770 | -18.594 | -69.4785 | 2020-08-11 04:35:08 | Arica y Parinacota, Chile | ||
662085 | 662085 | 2020-08-11 | Chile | Arica y Parinacota | 5334 | 78 | 4519 | 737 | -18.594 | -69.4785 | 2020-08-12 04:27:29 | Arica y Parinacota, Chile | ||
3531236 | 3531236 | 2020-08-12 | Chile | Arica y Parinacota | 5451 | 78 | 4613 | 760 | -18.594 | -69.4785 | 2020-08-13 04:29:15 | Arica y Parinacota, Chile | ||
582617 | 582617 | 2020-08-13 | Chile | Arica y Parinacota | 5512 | 80 | 4666 | 766 | -18.594 | -69.4785 | 2020-08-14 04:51:19 | Arica y Parinacota, Chile | ||
1612033 | 1612033 | 2020-08-14 | Chile | Arica y Parinacota | 5595 | 81 | 4754 | 760 | -18.594 | -69.4785 | 2020-08-15 04:27:31 | Arica y Parinacota, Chile | ||
145758 | 145758 | 2020-08-15 | Chile | Arica y Parinacota | 5692 | 82 | 4829 | 781 | -18.594 | -69.4785 | 2020-08-16 04:27:42 | Arica y Parinacota, Chile | ||
1555756 | 1555756 | 2020-08-16 | Chile | Arica y Parinacota | 5779 | 85 | 4911 | 783 | -18.594 | -69.4785 | 2020-08-17 04:27:20 | Arica y Parinacota, Chile | ||
837398 | 837398 | 2020-08-17 | Chile | Arica y Parinacota | 5848 | 85 | 4986 | 777 | -18.594 | -69.4785 | 2020-08-18 04:27:56 | Arica y Parinacota, Chile | ||
3177794 | 3177794 | 2020-08-18 | Chile | Arica y Parinacota | 5899 | 85 | 5083 | 731 | -18.594 | -69.4785 | 2020-08-19 04:27:00 | Arica y Parinacota, Chile | ||
206040 | 206040 | 2020-08-19 | Chile | Arica y Parinacota | 5935 | 85 | 5162 | 688 | -18.594 | -69.4785 | 2020-08-20 04:27:43 | Arica y Parinacota, Chile | ||
3484091 | 3484091 | 2020-08-20 | Chile | Arica y Parinacota | 6004 | 93 | 5259 | 652 | -18.594 | -69.4785 | 2020-08-21 04:27:41 | Arica y Parinacota, Chile | ||
1479342 | 1479342 | 2020-08-21 | Chile | Arica y Parinacota | 6083 | 95 | 5364 | 624 | -18.594 | -69.4785 | 2020-08-22 04:27:49 | Arica y Parinacota, Chile | ||
2299235 | 2299235 | 2020-08-22 | Chile | Arica y Parinacota | 6167 | 97 | 5429 | 641 | -18.594 | -69.4785 | 2020-08-23 04:27:48 | Arica y Parinacota, Chile | ||
2215453 | 2215453 | 2020-08-23 | Chile | Arica y Parinacota | 6210 | 98 | 5501 | 611 | -18.594 | -69.4785 | 2020-08-24 04:27:56 | Arica y Parinacota, Chile | ||
2991058 | 2991058 | 2020-08-24 | Chile | Arica y Parinacota | 6290 | 100 | 5561 | 629 | -18.594 | -69.4785 | 2020-08-25 04:28:02 | Arica y Parinacota, Chile | ||
3562354 | 3562354 | 2020-08-25 | Chile | Arica y Parinacota | 6330 | 100 | 5627 | 603 | -18.594 | -69.4785 | 2020-08-26 04:28:11 | Arica y Parinacota, Chile | ||
1996430 | 1996430 | 2020-08-26 | Chile | Arica y Parinacota | 6375 | 100 | 5702 | 573 | -18.594 | -69.4785 | 2020-08-27 04:28:15 | Arica y Parinacota, Chile | ||
2509970 | 2509970 | 2020-08-27 | Chile | Arica y Parinacota | 6419 | 104 | 5764 | 551 | -18.594 | -69.4785 | 2020-08-28 04:28:11 | Arica y Parinacota, 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]);