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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3253899 | 3253899 | 2021-03-02 | Brazil | Sao Paulo | 2054867 | 60014 | 1841560 | 153293 | -23.5505 | -46.6333 | 2021-03-03 05:23:28 | Sao Paulo, Brazil | ||
998191 | 998191 | 2021-03-01 | Brazil | Sao Paulo | 2044699 | 59546 | 1830423 | 154730 | -23.5505 | -46.6333 | 2021-03-02 05:23:30 | Sao Paulo, Brazil | ||
2367249 | 2367249 | 2021-02-28 | Brazil | Sao Paulo | 2041628 | 59493 | 1805549 | 176586 | -23.5505 | -46.6333 | 2021-03-01 05:23:01 | Sao Paulo, Brazil | ||
3065751 | 3065751 | 2021-02-27 | Brazil | Sao Paulo | 2037267 | 59428 | 1805549 | 172290 | -23.5505 | -46.6333 | 2021-02-28 05:22:20 | Sao Paulo, Brazil | ||
2183335 | 2183335 | 2021-02-26 | Brazil | Sao Paulo | 2026125 | 59129 | 1792647 | 174349 | -23.5505 | -46.6333 | 2021-02-27 05:22:28 | Sao Paulo, Brazil | ||
1857757 | 1857757 | 2021-02-25 | Brazil | Sao Paulo | 2014529 | 58873 | 1790461 | 165195 | -23.5505 | -46.6333 | 2021-02-26 05:22:40 | Sao Paulo, Brazil | ||
279935 | 279935 | 2021-02-24 | Brazil | Sao Paulo | 2002640 | 58528 | 1786558 | 157554 | -23.5505 | -46.6333 | 2021-02-25 05:24:57 | Sao Paulo, Brazil | ||
1936203 | 1936203 | 2021-02-23 | Brazil | Sao Paulo | 1990554 | 58199 | 1774964 | 157391 | -23.5505 | -46.6333 | 2021-02-24 05:29:16 | Sao Paulo, Brazil | ||
530458 | 530458 | 2021-02-22 | Brazil | Sao Paulo | 1978477 | 57842 | 1749210 | 171425 | -23.5505 | -46.6333 | 2021-02-23 05:23:41 | Sao Paulo, Brazil | ||
181792 | 181792 | 2021-02-21 | Brazil | Sao Paulo | 1975927 | 57799 | 1749210 | 168918 | -23.5505 | -46.6333 | 2021-02-22 05:24:21 | Sao Paulo, Brazil | ||
742066 | 742066 | 2021-02-20 | Brazil | Sao Paulo | 1971423 | 57743 | 1736276 | 177404 | -23.5505 | -46.6333 | 2021-02-21 05:24:33 | Sao Paulo, Brazil | ||
471164 | 471164 | 2021-02-19 | Brazil | Sao Paulo | 1960564 | 57499 | 1722223 | 180842 | -23.5505 | -46.6333 | 2021-02-20 05:22:51 | Sao Paulo, Brazil | ||
1152874 | 1152874 | 2021-02-18 | Brazil | Sao Paulo | 1949459 | 57240 | 1720128 | 172091 | -23.5505 | -46.6333 | 2021-02-19 05:24:16 | Sao Paulo, Brazil | ||
3600794 | 3600794 | 2021-02-17 | Brazil | Sao Paulo | 1938712 | 56960 | 1716064 | 165688 | -23.5505 | -46.6333 | 2021-02-18 05:22:58 | Sao Paulo, Brazil | ||
3049929 | 3049929 | 2021-02-16 | Brazil | Sao Paulo | 1927410 | 56702 | 1689766 | 180942 | -23.5505 | -46.6333 | 2021-02-17 05:23:10 | Sao Paulo, Brazil | ||
1338028 | 1338028 | 2021-02-15 | Brazil | Sao Paulo | 1915914 | 56304 | 1689766 | 169844 | -23.5505 | -46.6333 | 2021-02-16 05:24:38 | Sao Paulo, Brazil | ||
2283179 | 2283179 | 2021-02-14 | Brazil | Sao Paulo | 1913598 | 56266 | 1646323 | 211009 | -23.5505 | -46.6333 | 2021-02-15 05:24:49 | Sao Paulo, Brazil | ||
2677579 | 2677579 | 2021-02-13 | Brazil | Sao Paulo | 1911411 | 56191 | 1646323 | 208897 | -23.5505 | -46.6333 | 2021-02-14 05:23:43 | Sao Paulo, Brazil | ||
3539212 | 3539212 | 2021-02-12 | Brazil | Sao Paulo | 1901574 | 55971 | 1646323 | 199280 | -23.5505 | -46.6333 | 2021-02-13 05:22:12 | Sao Paulo, Brazil | ||
2637475 | 2637475 | 2021-02-11 | Brazil | Sao Paulo | 1889969 | 55742 | 1638936 | 195291 | -23.5505 | -46.6333 | 2021-02-12 05:23:29 | Sao Paulo, Brazil | ||
3978330 | 3978330 | 2021-02-10 | Brazil | Sao Paulo | 1878802 | 55419 | 1638936 | 184447 | -23.5505 | -46.6333 | 2021-02-11 05:23:55 | Sao Paulo, Brazil | ||
1527650 | 1527650 | 2021-02-09 | Brazil | Sao Paulo | 1864977 | 55087 | 1624672 | 185218 | -23.5505 | -46.6333 | 2021-02-10 05:22:41 | Sao Paulo, Brazil | ||
613441 | 613441 | 2021-02-08 | Brazil | Sao Paulo | 1851776 | 54663 | 1604022 | 190698 | -23.5505 | -46.6333 | 2021-02-09 05:23:30 | Sao Paulo, Brazil | ||
1672210 | 1672210 | 2021-02-07 | Brazil | Sao Paulo | 1849334 | 54614 | 1604022 | 190698 | -23.5505 | -46.6333 | 2021-02-08 05:22:39 | Sao Paulo, Brazil | ||
974671 | 974671 | 2021-02-06 | Brazil | Sao Paulo | 1845086 | 54545 | 1589680 | 189159 | -23.5505 | -46.6333 | 2021-02-07 05:23:00 | Sao Paulo, Brazil | ||
1587929 | 1587929 | 2021-02-05 | Brazil | Sao Paulo | 1833163 | 54324 | 1573945 | 204894 | -23.5505 | -46.6333 | 2021-02-06 05:23:55 | Sao Paulo, Brazil | ||
790136 | 790136 | 2021-02-04 | Brazil | Sao Paulo | 1820941 | 53997 | 1571342 | 195602 | -23.5505 | -46.6333 | 2021-02-05 05:22:38 | Sao Paulo, Brazil | ||
340028 | 340028 | 2021-02-03 | Brazil | Sao Paulo | 1807009 | 53704 | 1565915 | 187390 | -23.5505 | -46.6333 | 2021-02-04 05:22:26 | Sao Paulo, Brazil | ||
1684254 | 1684254 | 2021-02-02 | Brazil | Sao Paulo | 1794019 | 53455 | 1537739 | 202825 | -23.5505 | -46.6333 | 2021-02-03 05:22:52 | Sao Paulo, Brazil | ||
1676224 | 1676224 | 2021-02-01 | Brazil | Sao Paulo | 1779722 | 53090 | 1537739 | 188893 | -23.5505 | -46.6333 | 2021-02-02 05:22:49 | Sao Paulo, Brazil | ||
1459512 | 1459512 | 2021-01-31 | Brazil | Sao Paulo | 1777368 | 53034 | 1524085 | 200249 | -23.5505 | -46.6333 | 2021-02-01 05:22:53 | Sao Paulo, Brazil | ||
2211420 | 2211420 | 2021-01-30 | Brazil | Sao Paulo | 1773024 | 52954 | 1508890 | 211180 | -23.5505 | -46.6333 | 2021-01-31 05:22:42 | Sao Paulo, Brazil | ||
1896907 | 1896907 | 2021-01-29 | Brazil | Sao Paulo | 1759957 | 52722 | 1496420 | 210815 | -23.5505 | -46.6333 | 2021-01-30 05:22:49 | Sao Paulo, Brazil | ||
2481723 | 2481723 | 2021-01-28 | Brazil | Sao Paulo | 1746070 | 52481 | 1463602 | 229987 | -23.5505 | -46.6333 | 2021-01-29 05:22:23 | Sao Paulo, Brazil | ||
3153358 | 3153358 | 2021-01-27 | Brazil | Sao Paulo | 1731294 | 52170 | 1463602 | 215522 | -23.5505 | -46.6333 | 2021-01-28 05:22:24 | Sao Paulo, Brazil | ||
12093 | 12093 | 2021-01-26 | Brazil | Sao Paulo | 1715253 | 51838 | 1463602 | 199813 | -23.5505 | -46.6333 | 2021-01-27 05:23:41 | Sao Paulo, Brazil | ||
2567417 | 2567417 | 2021-01-25 | Brazil | Sao Paulo | 1702294 | 51556 | 1463602 | 187136 | -23.5505 | -46.6333 | 2021-01-26 05:22:02 | Sao Paulo, Brazil | ||
1759049 | 1759049 | 2021-01-24 | Brazil | Sao Paulo | 1699427 | 51502 | 1435128 | 212797 | -23.5505 | -46.6333 | 2021-01-25 05:22:16 | Sao Paulo, Brazil | ||
2426656 | 2426656 | 2021-01-23 | Brazil | Sao Paulo | 1694355 | 51423 | 1420484 | 222448 | -23.5505 | -46.6333 | 2021-01-24 05:22:35 | Sao Paulo, Brazil | ||
2466558 | 2466558 | 2021-01-22 | Brazil | Sao Paulo | 1679759 | 51192 | 1420484 | 208083 | -23.5505 | -46.6333 | 2021-01-23 05:22:03 | Sao Paulo, Brazil | ||
435109 | 435109 | 2021-01-21 | Brazil | Sao Paulo | 1670754 | 50938 | 1420484 | 199332 | -23.5505 | -46.6333 | 2021-01-22 05:22:10 | Sao Paulo, Brazil | ||
1093841 | 1093841 | 2021-01-20 | Brazil | Sao Paulo | 1658636 | 50652 | 1415873 | 192111 | -23.5505 | -46.6333 | 2021-01-21 05:22:01 | Sao Paulo, Brazil | ||
907931 | 907931 | 2021-01-19 | Brazil | Sao Paulo | 1644225 | 50318 | 1415873 | 178034 | -23.5505 | -46.6333 | 2021-01-20 05:21:54 | Sao Paulo, Brazil | ||
236994 | 236994 | 2021-01-18 | Brazil | Sao Paulo | 1628272 | 49987 | 1412310 | 165975 | -23.5505 | -46.6333 | 2021-01-19 05:22:15 | Sao Paulo, Brazil | ||
3503111 | 3503111 | 2021-01-17 | Brazil | Sao Paulo | 1625339 | 49945 | 1390344 | 185050 | -23.5505 | -46.6333 | 2021-01-18 05:22:34 | Sao Paulo, Brazil | ||
3101194 | 3101194 | 2021-01-16 | Brazil | Sao Paulo | 1619619 | 49885 | 1390344 | 179390 | -23.5505 | -46.6333 | 2021-01-17 05:22:17 | Sao Paulo, Brazil | ||
3515156 | 3515156 | 2021-01-15 | Brazil | Sao Paulo | 1605845 | 49600 | 1378152 | 178093 | -23.5505 | -46.6333 | 2021-01-16 05:22:40 | Sao Paulo, Brazil | ||
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 |
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]);