johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Brazil" and province_or_state = "Sao Paulo" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3879329 | 3879329 | 2021-01-14 | Brazil | Sao Paulo | 1590829 | 49289 | 1376887 | 164653 | -23.5505 | -46.6333 | 2021-01-15 05:22:24 | Sao Paulo, Brazil | ||
3307956 | 3307956 | 2021-01-13 | Brazil | Sao Paulo | 1577119 | 48985 | 1373425 | 154709 | -23.5505 | -46.6333 | 2021-01-14 05:22:32 | Sao Paulo, Brazil | ||
774101 | 774101 | 2021-01-12 | Brazil | Sao Paulo | 1561844 | 48662 | 1370112 | 143070 | -23.5505 | -46.6333 | 2021-01-13 05:22:15 | Sao Paulo, Brazil | ||
189822 | 189822 | 2021-01-11 | Brazil | Sao Paulo | 1549142 | 48379 | 1370112 | 130651 | -23.5505 | -46.6333 | 2021-01-12 05:22:15 | Sao Paulo, Brazil | ||
2625625 | 2625625 | 2021-01-10 | Brazil | Sao Paulo | 1546132 | 48351 | 1360789 | 136992 | -23.5505 | -46.6333 | 2021-01-11 05:21:50 | Sao Paulo, Brazil | ||
3899713 | 3899713 | 2021-01-09 | Brazil | Sao Paulo | 1540513 | 48298 | 1350513 | 141702 | -23.5505 | -46.6333 | 2021-01-10 05:22:12 | Sao Paulo, Brazil | ||
153736 | 153736 | 2021-01-08 | Brazil | Sao Paulo | 1528952 | 48029 | 1340014 | 140909 | -23.5505 | -46.6333 | 2021-01-09 05:22:18 | Sao Paulo, Brazil | ||
2541160 | 2541160 | 2021-01-07 | Brazil | Sao Paulo | 1515158 | 47768 | 1336589 | 130801 | -23.5505 | -46.6333 | 2021-01-08 05:22:42 | Sao Paulo, Brazil | ||
2864469 | 2864469 | 2021-01-06 | Brazil | Sao Paulo | 1501085 | 47511 | 1324431 | 129143 | -23.5505 | -46.6333 | 2021-01-07 05:22:03 | Sao Paulo, Brazil | ||
3034056 | 3034056 | 2021-01-05 | Brazil | Sao Paulo | 1486551 | 47222 | 1324431 | 114898 | -23.5505 | -46.6333 | 2021-01-06 05:22:16 | Sao Paulo, Brazil | ||
1061601 | 1061601 | 2021-01-04 | Brazil | Sao Paulo | 1473670 | 46888 | 1314843 | 111939 | -23.5505 | -46.6333 | 2021-01-05 05:21:49 | Sao Paulo, Brazil | ||
3230204 | 3230204 | 2021-01-03 | Brazil | Sao Paulo | 1471422 | 46845 | 1294620 | 129957 | -23.5505 | -46.6333 | 2021-01-04 05:22:02 | Sao Paulo, Brazil | ||
2227274 | 2227274 | 2021-01-02 | Brazil | Sao Paulo | 1467953 | 46808 | 1294620 | 126525 | -23.5505 | -46.6333 | 2021-01-03 05:22:52 | Sao Paulo, Brazil | ||
1136638 | 1136638 | 2021-01-01 | Brazil | Sao Paulo | 1466191 | 46775 | 1287986 | 131430 | -23.5505 | -46.6333 | 2021-01-02 05:22:33 | Sao Paulo, Brazil | ||
3695244 | 3695244 | 2020-12-31 | Brazil | Sao Paulo | 1462297 | 46717 | 1287986 | 127594 | -23.5505 | -46.6333 | 2021-01-01 05:23:07 | Sao Paulo, Brazil | ||
1010059 | 1010059 | 2020-12-30 | Brazil | Sao Paulo | 1452078 | 46477 | 1278967 | 126634 | -23.5505 | -46.6333 | 2020-12-31 05:22:49 | Sao Paulo, Brazil | ||
766074 | 766074 | 2020-12-29 | Brazil | Sao Paulo | 1440229 | 46195 | 1278967 | 115067 | -23.5505 | -46.6333 | 2020-12-30 05:22:34 | Sao Paulo, Brazil | ||
3761338 | 3761338 | 2020-12-28 | Brazil | Sao Paulo | 1427752 | 45902 | 1270469 | 111381 | -23.5505 | -46.6333 | 2020-12-29 05:22:37 | Sao Paulo, Brazil | ||
3777658 | 3777658 | 2020-12-27 | Brazil | Sao Paulo | 1426176 | 45863 | 1260722 | 119591 | -23.5505 | -46.6333 | 2020-12-28 05:22:06 | Sao Paulo, Brazil | ||
2223263 | 2223263 | 2020-12-26 | Brazil | Sao Paulo | 1423340 | 45808 | 1250993 | 126539 | -23.5505 | -46.6333 | 2020-12-27 05:22:55 | Sao Paulo, Brazil | ||
202010 | 202010 | 2020-12-25 | Brazil | Sao Paulo | 1422087 | 45795 | 1222776 | 153516 | -23.5505 | -46.6333 | 2020-12-26 05:22:28 | Sao Paulo, Brazil | ||
3691233 | 3691233 | 2020-12-24 | Brazil | Sao Paulo | 1418491 | 45758 | 1222776 | 149957 | -23.5505 | -46.6333 | 2020-12-25 05:22:48 | Sao Paulo, Brazil | ||
2406585 | 2406585 | 2020-12-23 | Brazil | Sao Paulo | 1409140 | 45576 | 1222776 | 140788 | -23.5505 | -46.6333 | 2020-12-24 05:23:04 | Sao Paulo, Brazil | ||
3769631 | 3769631 | 2020-12-22 | Brazil | Sao Paulo | 1398757 | 45395 | 1222776 | 130586 | -23.5505 | -46.6333 | 2020-12-23 05:22:03 | Sao Paulo, Brazil | ||
927447 | 927447 | 2020-12-21 | Brazil | Sao Paulo | 1388043 | 45136 | 1222776 | 120131 | -23.5505 | -46.6333 | 2020-12-22 05:22:33 | Sao Paulo, Brazil | ||
2119468 | 2119468 | 2020-12-20 | Brazil | Sao Paulo | 1384100 | 45029 | 1205561 | 133510 | -23.5505 | -46.6333 | 2020-12-21 05:27:58 | Sao Paulo, Brazil | ||
2930975 | 2930975 | 2020-12-19 | Brazil | Sao Paulo | 1384100 | 45029 | 1196775 | 142296 | -23.5505 | -46.6333 | 2020-12-20 05:27:32 | Sao Paulo, Brazil | ||
1900921 | 1900921 | 2020-12-18 | Brazil | Sao Paulo | 1371653 | 44878 | 1195792 | 130983 | -23.5505 | -46.6333 | 2020-12-19 05:27:52 | Sao Paulo, Brazil | ||
2127747 | 2127747 | 2020-12-17 | Brazil | Sao Paulo | 1361731 | 44681 | 1189305 | 127745 | -23.5505 | -46.6333 | 2020-12-18 05:28:18 | Sao Paulo, Brazil | ||
3149347 | 3149347 | 2020-12-16 | Brazil | Sao Paulo | 1341428 | 44282 | 1189305 | 107841 | -23.5505 | -46.6333 | 2020-12-17 05:28:12 | Sao Paulo, Brazil | ||
1034128 | 1034128 | 2020-12-15 | Brazil | Sao Paulo | 1341428 | 44282 | 1189305 | 107841 | -23.5505 | -46.6333 | 2020-12-16 05:28:04 | Sao Paulo, Brazil | ||
1751022 | 1751022 | 2020-12-14 | Brazil | Sao Paulo | 1337016 | 44050 | 1185217 | 107749 | -23.5505 | -46.6333 | 2020-12-15 05:26:38 | Sao Paulo, Brazil | ||
3847542 | 3847542 | 2020-12-13 | Brazil | Sao Paulo | 1334703 | 44018 | 1180726 | 109959 | -23.5505 | -46.6333 | 2020-12-14 05:26:27 | Sao Paulo, Brazil | ||
845324 | 845324 | 2020-12-12 | Brazil | Sao Paulo | 1333763 | 43971 | 1166823 | 122969 | -23.5505 | -46.6333 | 2020-12-13 05:27:20 | Sao Paulo, Brazil | ||
860431 | 860431 | 2020-12-11 | Brazil | Sao Paulo | 1325162 | 43802 | 1166823 | 114537 | -23.5505 | -46.6333 | 2020-12-12 05:26:19 | Sao Paulo, Brazil | ||
1599973 | 1599973 | 2020-12-10 | Brazil | Sao Paulo | 1316371 | 43661 | 1165927 | 106783 | -23.5505 | -46.6333 | 2020-12-11 05:26:59 | Sao Paulo, Brazil | ||
2974982 | 2974982 | 2020-12-09 | Brazil | Sao Paulo | 1306585 | 43461 | 1157066 | 106058 | -23.5505 | -46.6333 | 2020-12-10 05:26:19 | Sao Paulo, Brazil | ||
1818542 | 1818542 | 2020-12-08 | Brazil | Sao Paulo | 1296801 | 43282 | 1157066 | 96453 | -23.5505 | -46.6333 | 2020-12-09 05:28:01 | Sao Paulo, Brazil | ||
2347178 | 2347178 | 2020-12-07 | Brazil | Sao Paulo | 1288878 | 43040 | 1141481 | 104357 | -23.5505 | -46.6333 | 2020-12-08 05:27:42 | Sao Paulo, Brazil | ||
1006048 | 1006048 | 2020-12-06 | Brazil | Sao Paulo | 1287762 | 43015 | 1135106 | 109641 | -23.5505 | -46.6333 | 2020-12-07 05:26:14 | Sao Paulo, Brazil | ||
1632057 | 1632057 | 2020-12-05 | Brazil | Sao Paulo | 1285087 | 42969 | 1135106 | 107012 | -23.5505 | -46.6333 | 2020-12-06 05:26:18 | Sao Paulo, Brazil | ||
3859585 | 3859585 | 2020-12-04 | Brazil | Sao Paulo | 1276149 | 42788 | 1126589 | 106772 | -23.5505 | -46.6333 | 2020-12-05 05:27:36 | Sao Paulo, Brazil | ||
74843 | 74843 | 2020-12-03 | Brazil | Sao Paulo | 1267912 | 42637 | 1124966 | 100309 | -23.5505 | -46.6333 | 2020-12-04 05:27:27 | Sao Paulo, Brazil | ||
738055 | 738055 | 2020-12-02 | Brazil | Sao Paulo | 1259704 | 42456 | 1124966 | 92282 | -23.5505 | -46.6333 | 2020-12-03 05:28:22 | Sao Paulo, Brazil | ||
2537149 | 2537149 | 2020-12-01 | Brazil | Sao Paulo | 1250590 | 42290 | 1114557 | 93743 | -23.5505 | -46.6333 | 2020-12-02 05:27:41 | Sao Paulo, Brazil | ||
1583918 | 1583918 | 2020-11-30 | Brazil | Sao Paulo | 1241653 | 42095 | 1084660 | 114898 | -23.5505 | -46.6333 | 2020-12-01 05:26:18 | Sao Paulo, Brazil | ||
3566321 | 3566321 | 2020-11-29 | Brazil | Sao Paulo | 1240473 | 42076 | 1084660 | 113737 | -23.5505 | -46.6333 | 2020-11-30 05:26:13 | Sao Paulo, Brazil | ||
2934986 | 2934986 | 2020-11-28 | Brazil | Sao Paulo | 1238094 | 42048 | 1084660 | 111386 | -23.5505 | -46.6333 | 2020-11-29 05:25:55 | Sao Paulo, Brazil | ||
391989 | 391989 | 2020-11-27 | Brazil | Sao Paulo | 1233587 | 41902 | 1084660 | 107025 | -23.5505 | -46.6333 | 2020-11-28 05:25:50 | Sao Paulo, Brazil | ||
923436 | 923436 | 2020-11-26 | Brazil | Sao Paulo | 1229267 | 41773 | 1084660 | 102834 | -23.5505 | -46.6333 | 2020-11-27 05:26:53 | Sao Paulo, Brazil | ||
1972341 | 1972341 | 2020-11-25 | Brazil | Sao Paulo | 1224744 | 41601 | 1084660 | 98483 | -23.5505 | -46.6333 | 2020-11-26 05:27:44 | Sao Paulo, Brazil | ||
1350072 | 1350072 | 2020-11-24 | Brazil | Sao Paulo | 1215844 | 41455 | 1084660 | 89729 | -23.5505 | -46.6333 | 2020-11-25 05:27:20 | Sao Paulo, Brazil | ||
678067 | 678067 | 2020-11-23 | Brazil | Sao Paulo | 1210625 | 41276 | 1082032 | 87317 | -23.5505 | -46.6333 | 2020-11-24 05:27:31 | Sao Paulo, Brazil | ||
3189743 | 3189743 | 2020-11-22 | Brazil | Sao Paulo | 1209588 | 41267 | 1082032 | 86289 | -23.5505 | -46.6333 | 2020-11-23 05:25:26 | Sao Paulo, Brazil | ||
3836237 | 3836237 | 2020-11-21 | Brazil | Sao Paulo | 1205435 | 41256 | 1076616 | 87563 | -23.5505 | -46.6333 | 2020-11-22 05:25:45 | Sao Paulo, Brazil | ||
2701265 | 2701265 | 2020-11-20 | Brazil | Sao Paulo | 1200348 | 41179 | 1076616 | 82553 | -23.5505 | -46.6333 | 2020-11-21 05:25:51 | Sao Paulo, Brazil | ||
821325 | 821325 | 2020-11-19 | Brazil | Sao Paulo | 1191290 | 41074 | 1076073 | 74143 | -23.5505 | -46.6333 | 2020-11-20 05:26:28 | Sao Paulo, Brazil | ||
122459 | 122459 | 2020-11-18 | Brazil | Sao Paulo | 1184496 | 40927 | 1075200 | 68369 | -23.5505 | -46.6333 | 2020-11-19 05:25:23 | Sao Paulo, Brazil | ||
3338347 | 3338347 | 2020-11-17 | Brazil | Sao Paulo | 1178075 | 40749 | 1073039 | 64287 | -23.5505 | -46.6333 | 2020-11-18 05:40:31 | Sao Paulo, Brazil | ||
3169392 | 3169392 | 2020-11-16 | Brazil | Sao Paulo | 1169377 | 40576 | 1068284 | 60517 | -23.5505 | -46.6333 | 2020-11-17 05:25:54 | Sao Paulo, Brazil | ||
2879960 | 2879960 | 2020-11-15 | Brazil | Sao Paulo | 1168640 | 40564 | 1051778 | 76298 | -23.5505 | -46.6333 | 2020-11-16 05:25:57 | Sao Paulo, Brazil | ||
2914938 | 2914938 | 2020-11-14 | Brazil | Sao Paulo | 1167422 | 40549 | 1051778 | 75095 | -23.5505 | -46.6333 | 2020-11-15 05:26:53 | Sao Paulo, Brazil | ||
2784760 | 2784760 | 2020-11-13 | Brazil | Sao Paulo | 1162782 | 40202 | 1051778 | 70802 | -23.5505 | -46.6333 | 2020-11-14 05:25:37 | Sao Paulo, Brazil | ||
864525 | 864525 | 2020-11-12 | Brazil | Sao Paulo | 1156652 | 40202 | 1051778 | 64672 | -23.5505 | -46.6333 | 2020-11-13 05:25:30 | Sao Paulo, Brazil | ||
3440570 | 3440570 | 2020-11-11 | Brazil | Sao Paulo | 1150872 | 39907 | 1049348 | 61617 | -23.5505 | -46.6333 | 2020-11-12 05:25:55 | Sao Paulo, Brazil | ||
271910 | 271910 | 2020-11-10 | Brazil | Sao Paulo | 1147451 | 39717 | 1023885 | 62334 | -23.5505 | -46.6333 | 2020-11-11 05:25:30 | Sao Paulo, Brazil | ||
1988387 | 1988387 | 2020-11-09 | Brazil | Sao Paulo | 1125936 | 39717 | 1023885 | 62334 | -23.5505 | -46.6333 | 2020-11-10 05:40:07 | Sao Paulo, Brazil | ||
1728239 | 1728239 | 2020-11-08 | Brazil | Sao Paulo | 1125936 | 39717 | 1023885 | 62334 | -23.5505 | -46.6333 | 2020-11-09 05:25:45 | Sao Paulo, Brazil | ||
1543699 | 1543699 | 2020-11-07 | Brazil | Sao Paulo | 1125936 | 39717 | 1023885 | 62334 | -23.5505 | -46.6333 | 2020-11-08 05:24:56 | Sao Paulo, Brazil | ||
375937 | 375937 | 2020-11-06 | Brazil | Sao Paulo | 1125936 | 39717 | 1023885 | 62334 | -23.5505 | -46.6333 | 2020-11-07 05:24:52 | Sao Paulo, Brazil | ||
891875 | 891875 | 2020-11-05 | Brazil | Sao Paulo | 1125936 | 39717 | 1023085 | 60665 | -23.5505 | -46.6333 | 2020-11-06 05:24:55 | Sao Paulo, Brazil | ||
2918937 | 2918937 | 2020-11-04 | Brazil | Sao Paulo | 1123299 | 39549 | 1023085 | 60665 | -23.5505 | -46.6333 | 2020-11-05 06:05:03 | Sao Paulo, Brazil | ||
2497774 | 2497774 | 2020-11-03 | Brazil | Sao Paulo | 1118544 | 39364 | 1017876 | 61304 | -23.5505 | -46.6333 | 2020-11-04 05:25:09 | Sao Paulo, Brazil | ||
3303949 | 3303949 | 2020-11-02 | Brazil | Sao Paulo | 1117795 | 39346 | 1012267 | 66182 | -23.5505 | -46.6333 | 2020-11-03 06:00:16 | Sao Paulo, Brazil | ||
3409198 | 3409198 | 2020-11-01 | Brazil | Sao Paulo | 1117147 | 39331 | 1005729 | 72087 | -23.5505 | -46.6333 | 2020-11-02 05:25:04 | Sao Paulo, Brazil | ||
2079687 | 2079687 | 2020-10-31 | Brazil | Sao Paulo | 1116127 | 39311 | 999718 | 77098 | -23.5505 | -46.6333 | 2020-11-01 04:36:19 | Sao Paulo, Brazil | ||
2243140 | 2243140 | 2020-10-30 | Brazil | Sao Paulo | 1113788 | 39255 | 999089 | 75444 | -23.5505 | -46.6333 | 2020-10-31 04:24:44 | Sao Paulo, Brazil | ||
209995 | 209995 | 2020-10-29 | Brazil | Sao Paulo | 1108860 | 39119 | 998541 | 71200 | -23.5505 | -46.6333 | 2020-10-30 04:24:49 | Sao Paulo, Brazil | ||
754057 | 754057 | 2020-10-28 | Brazil | Sao Paulo | 1103582 | 39007 | 995809 | 68766 | -23.5505 | -46.6333 | 2020-10-29 04:24:49 | Sao Paulo, Brazil | ||
1452342 | 1452342 | 2020-10-27 | Brazil | Sao Paulo | 1098207 | 38885 | 989305 | 70017 | -23.5505 | -46.6333 | 2020-10-28 04:24:39 | Sao Paulo, Brazil | ||
3480066 | 3480066 | 2020-10-26 | Brazil | Sao Paulo | 1092843 | 38753 | 908199 | 145891 | -23.5505 | -46.6333 | 2020-10-27 04:24:45 | Sao Paulo, Brazil | ||
8087 | 8087 | 2020-10-25 | Brazil | Sao Paulo | 1091980 | 38747 | 908199 | 145034 | -23.5505 | -46.6333 | 2020-10-26 04:25:02 | Sao Paulo, Brazil | ||
3651324 | 3651324 | 2020-10-24 | Brazil | Sao Paulo | 1089255 | 38726 | 908199 | 142330 | -23.5505 | -46.6333 | 2020-10-25 04:24:36 | Sao Paulo, Brazil | ||
1053579 | 1053579 | 2020-10-23 | Brazil | Sao Paulo | 1083641 | 38608 | 908199 | 136834 | -23.5505 | -46.6333 | 2020-10-24 04:24:46 | Sao Paulo, Brazil | ||
1177249 | 1177249 | 2020-10-22 | Brazil | Sao Paulo | 1076939 | 38482 | 908199 | 130258 | -23.5505 | -46.6333 | 2020-10-23 04:24:46 | Sao Paulo, Brazil | ||
2191354 | 2191354 | 2020-10-21 | Brazil | Sao Paulo | 1073261 | 38371 | 908199 | 126691 | -23.5505 | -46.6333 | 2020-10-22 04:24:27 | Sao Paulo, Brazil | ||
3990365 | 3990365 | 2020-10-20 | Brazil | Sao Paulo | 1068962 | 38246 | 908199 | 122517 | -23.5505 | -46.6333 | 2020-10-21 04:24:14 | Sao Paulo, Brazil | ||
1794385 | 1794385 | 2020-10-19 | Brazil | Sao Paulo | 1064039 | 38035 | 908199 | 117805 | -23.5505 | -46.6333 | 2020-10-20 04:24:22 | Sao Paulo, Brazil | ||
762069 | 762069 | 2020-10-18 | Brazil | Sao Paulo | 1063602 | 38020 | 908199 | 116443 | -23.5505 | -46.6333 | 2020-10-19 04:24:16 | Sao Paulo, Brazil | ||
1026107 | 1026107 | 2020-10-17 | Brazil | Sao Paulo | 1062634 | 37992 | 908199 | 116443 | -23.5505 | -46.6333 | 2020-10-18 04:24:25 | Sao Paulo, Brazil | ||
2856602 | 2856602 | 2020-10-16 | Brazil | Sao Paulo | 1057240 | 37870 | 908199 | 111171 | -23.5505 | -46.6333 | 2020-10-17 04:24:12 | Sao Paulo, Brazil | ||
786132 | 786132 | 2020-10-15 | Brazil | Sao Paulo | 1051613 | 37690 | 908199 | 105724 | -23.5505 | -46.6333 | 2020-10-16 04:24:01 | Sao Paulo, Brazil | ||
78843 | 78843 | 2020-10-14 | Brazil | Sao Paulo | 1045060 | 37541 | 908199 | 99320 | -23.5505 | -46.6333 | 2020-10-15 04:24:28 | Sao Paulo, Brazil | ||
3781658 | 3781658 | 2020-10-13 | Brazil | Sao Paulo | 1039029 | 37314 | 908199 | 93516 | -23.5505 | -46.6333 | 2020-10-14 04:24:05 | Sao Paulo, Brazil | ||
2291198 | 2291198 | 2020-10-12 | Brazil | Sao Paulo | 1038344 | 37279 | 908199 | 92866 | -23.5505 | -46.6333 | 2020-10-13 04:24:02 | Sao Paulo, Brazil | ||
3785651 | 3785651 | 2020-10-11 | Brazil | Sao Paulo | 1037660 | 37256 | 908199 | 92205 | -23.5505 | -46.6333 | 2020-10-12 04:23:45 | Sao Paulo, Brazil | ||
2601789 | 2601789 | 2020-10-10 | Brazil | Sao Paulo | 1034816 | 37223 | 898416 | 99177 | -23.5505 | -46.6333 | 2020-10-11 04:23:46 | Sao Paulo, Brazil | ||
817322 | 817322 | 2020-10-09 | Brazil | Sao Paulo | 1028190 | 37068 | 898416 | 92706 | -23.5505 | -46.6333 | 2020-10-10 04:23:57 | Sao Paulo, Brazil | ||
2689437 | 2689437 | 2020-10-08 | Brazil | Sao Paulo | 1022404 | 36884 | 898416 | 87104 | -23.5505 | -46.6333 | 2020-10-09 04:23:59 | Sao Paulo, Brazil | ||
1041579 | 1041579 | 2020-10-07 | Brazil | Sao Paulo | 1016755 | 36669 | 895004 | 85082 | -23.5505 | -46.6333 | 2020-10-08 04:23:56 | Sao Paulo, Brazil |
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]);