johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
442 rows where active = 517 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 362
- Russia 13
- Mexico 6
- Colombia 5
- Japan 5
- Andorra 4
- Chile 4
- Guinea 3
- India 3
- Italy 3
- Malaysia 3
- Ukraine 3
- Burkina Faso 2
- Cyprus 2
- Germany 2
- Peru 2
- Australia 1
- Cabo Verde 1
- Cote d'Ivoire 1
- Croatia 1
- Denmark 1
- Fiji 1
- Guatemala 1
- Lesotho 1
- Lithuania 1
- Maldives 1
- Malta 1
- Mauritius 1
- Netherlands 1
- North Macedonia 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331697 | 331697 | 2021-08-04 | Chile | Maule | 99886 | 1691 | 97678 | 517 | -35.5183 | -71.6885 | 2021-08-05 04:21:51 | Maule, Chile | ||
3479945 | 3479945 | 2021-07-22 | Ukraine | Lviv Oblast | 137902 | 3676 | 133709 | 517 | 49.8397 | 24.0297 | 2021-07-23 04:21:29 | Lviv Oblast, Ukraine | ||
3331753 | 3331753 | 2021-07-21 | Russia | Magadan Oblast | 9204 | 136 | 8551 | 517 | 62.48858785 | 153.9903764 | 2021-07-22 04:21:19 | Magadan Oblast, Russia | ||
3331515 | 3331515 | 2021-07-21 | Italy | Liguria | 104106 | 4358 | 99231 | 517 | 44.41149315 | 8.9326992 | 2021-07-22 04:21:19 | Liguria, Italy | ||
3741305 | 3741305 | 2021-07-12 | Russia | Mari El Republic | 14965 | 329 | 14119 | 517 | 56.5767504 | 47.8817512 | 2021-07-13 04:21:18 | Mari El Republic, Russia | ||
829525 | 829525 | 2021-07-09 | Guinea | 24020 | 175 | 23328 | 517 | 9.9456 | -9.6966 | 2021-07-10 04:21:25 | Guinea | |||
2693600 | 2693600 | 2021-07-06 | Germany | Hamburg | 77476 | 1597 | 75400 | 517 | 53.5511 | 9.9937 | 2021-07-07 04:21:20 | Hamburg, Germany | ||
2693538 | 2693538 | 2021-07-06 | Colombia | La Guajira | 39924 | 1268 | 38139 | 517 | 11.3548 | -72.5205 | 2021-07-07 04:21:20 | La Guajira, Colombia | ||
2422761 | 2422761 | 2021-06-23 | Croatia | 359302 | 8190 | 350595 | 517 | 45.1 | 15.2 | 2021-06-24 04:21:55 | Croatia | |||
3358743 | 3358743 | 2021-06-21 | Mauritius | 1800 | 18 | 1265 | 517 | -20.348404 | 57.552152 | 2021-06-22 04:21:34 | Mauritius | |||
3145858 | 3145858 | 2021-06-07 | Singapore | 62210 | 33 | 61660 | 517 | 1.2833 | 103.8333 | 2021-06-08 04:22:35 | Singapore | |||
3145471 | 3145471 | 2021-06-07 | Fiji | 751 | 4 | 230 | 517 | -17.7134 | 178.065 | 2021-06-08 04:22:35 | Fiji | |||
3089612 | 3089612 | 2021-05-30 | Russia | Bryansk Oblast | 40211 | 356 | 39338 | 517 | 52.8873315 | 33.41585300000001 | 2021-05-31 03:08:59 | Bryansk Oblast, Russia | ||
20580 | 20580 | 2021-05-28 | Russia | Khakassia Republic | 23062 | 550 | 21995 | 517 | 53.72258845 | 91.44293627 | 2021-05-29 04:20:41 | Khakassia Republic, Russia | ||
2390960 | 2390960 | 2021-05-18 | Russia | Bryansk Oblast | 39357 | 317 | 38523 | 517 | 52.8873315 | 33.41585300000001 | 2021-05-19 04:20:42 | Bryansk Oblast, Russia | ||
3574440 | 3574440 | 2021-05-17 | Colombia | Choco | 9728 | 255 | 8956 | 517 | 5.2528 | -76.82600000000002 | 2021-05-18 04:20:33 | Choco, Colombia | ||
1425287 | 1425287 | 2021-05-09 | Russia | Amur Oblast | 22418 | 287 | 21614 | 517 | 52.8032368 | 128.437295 | 2021-05-10 04:20:38 | Amur Oblast, Russia | ||
2502017 | 2502017 | 2021-05-07 | Italy | Molise | 13385 | 480 | 12388 | 517 | 41.55774754 | 14.65916051 | 2021-05-08 04:21:04 | Molise, Italy | ||
2450961 | 2450961 | 2021-05-02 | Russia | Bryansk Oblast | 38318 | 309 | 37492 | 517 | 52.8873315 | 33.41585300000001 | 2021-05-03 04:20:39 | Bryansk Oblast, Russia | ||
2020677 | 2020677 | 2021-04-20 | India | Lakshadweep | 1335 | 1 | 817 | 517 | 13.6999972 | 72.18333259999999 | 2021-04-21 04:21:14 | Lakshadweep, India | ||
3887224 | 3887224 | 2021-04-11 | Ukraine | Sevastopol* | 13598 | 580 | 12501 | 517 | 44.6054 | 33.522 | 2021-04-12 04:21:00 | Sevastopol*, Ukraine | ||
3003147 | 3003147 | 2021-04-06 | Colombia | Cauca | 28378 | 779 | 27082 | 517 | 2.705 | -76.82600000000002 | 2021-04-07 04:20:53 | Cauca, Colombia | ||
1301836 | 1301836 | 2021-04-01 | Chile | Atacama | 14337 | 172 | 13648 | 517 | -27.5661 | -70.0503 | 2021-04-02 04:20:36 | Atacama, Chile | ||
1535712 | 1535712 | 2021-03-28 | Chile | Atacama | 14035 | 170 | 13348 | 517 | -27.5661 | -70.0503 | 2021-03-29 04:28:35 | Atacama, Chile | ||
1802321 | 1802321 | 2021-03-23 | Malaysia | Sabah | 54356 | 388 | 53451 | 517 | 5.9788 | 116.0753 | 2021-03-24 05:25:40 | Sabah, Malaysia | ||
3620917 | 3620917 | 2021-03-17 | Colombia | Bolivar | 68198 | 1378 | 66303 | 517 | 8.6704 | -74.03 | 2021-03-18 05:26:22 | Bolivar, Colombia | ||
702594 | 702594 | 2021-03-16 | Russia | Bryansk Oblast | 34299 | 269 | 33513 | 517 | 52.8873315 | 33.41585300000001 | 2021-03-17 05:25:07 | Bryansk Oblast, Russia | ||
3670347 | 3670347 | 2021-03-06 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-03-07 05:21:54 | Comerio, Puerto Rico, US |
1618968 | 1618968 | 2021-03-05 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-03-06 04:23:41 | Comerio, Puerto Rico, US |
2210379 | 2210379 | 2021-03-04 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-03-05 05:26:29 | Comerio, Puerto Rico, US |
2208628 | 2208628 | 2021-03-04 | US | Illinois | Edwards | 17047 | 527 | 10 | 0 | 517 | 38.41353228 | -88.05720863 | 2021-03-05 05:26:29 | Edwards, Illinois, US |
1092800 | 1092800 | 2021-03-03 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-03-04 05:24:24 | Comerio, Puerto Rico, US |
3256872 | 3256872 | 2021-03-02 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-03-03 05:23:28 | Comerio, Puerto Rico, US |
3255513 | 3255513 | 2021-03-02 | US | Kentucky | Bracken | 21023 | 521 | 4 | 0 | 517 | 38.69158994 | -84.08532444 | 2021-03-03 05:23:28 | Bracken, Kentucky, US |
1001164 | 1001164 | 2021-03-01 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-03-02 05:23:30 | Comerio, Puerto Rico, US |
2370222 | 2370222 | 2021-02-28 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-03-01 05:23:01 | Comerio, Puerto Rico, US |
3068724 | 3068724 | 2021-02-27 | US | Puerto Rico | Comerio | 72045 | 517 | 0 | 0 | 517 | 18.224687 | -66.221622 | 2021-02-28 05:22:20 | Comerio, Puerto Rico, US |
1859242 | 1859242 | 2021-02-25 | US | Iowa | Van Buren | 19177 | 535 | 18 | 0 | 517 | 40.75326764 | -91.95017958 | 2021-02-26 05:22:40 | Van Buren, Iowa, US |
283343 | 283343 | 2021-02-24 | US | Texas | McCulloch | 48307 | 509 | 15 | 0 | 517 | 31.1925468 | -99.34682807 | 2021-02-25 05:24:57 | McCulloch, Texas, US |
281295 | 281295 | 2021-02-24 | US | Indiana | Ohio | 18115 | 528 | 11 | 0 | 517 | 38.955305 | -84.96515993 | 2021-02-25 05:24:57 | Ohio, Indiana, US |
531943 | 531943 | 2021-02-22 | US | Iowa | Van Buren | 19177 | 535 | 18 | 0 | 517 | 40.75326764 | -91.95017958 | 2021-02-23 05:23:41 | Van Buren, Iowa, US |
3603586 | 3603586 | 2021-02-17 | US | Oklahoma | Grant | 40053 | 524 | 7 | 0 | 517 | 36.796297 | -97.78638765 | 2021-02-18 05:22:58 | Grant, Oklahoma, US |
3603581 | 3603581 | 2021-02-17 | US | Oklahoma | Dewey | 40043 | 523 | 6 | 0 | 517 | 35.98772922 | -99.00730714 | 2021-02-18 05:22:58 | Dewey, Oklahoma, US |
3052721 | 3052721 | 2021-02-16 | US | Oklahoma | Grant | 40053 | 524 | 7 | 0 | 517 | 36.796297 | -97.78638765 | 2021-02-17 05:23:10 | Grant, Oklahoma, US |
2680114 | 2680114 | 2021-02-13 | US | North Carolina | Camden | 37029 | 522 | 5 | 0 | 517 | 36.33804939 | -76.15568396 | 2021-02-14 05:23:43 | Camden, North Carolina, US |
2640436 | 2640436 | 2021-02-11 | US | Puerto Rico | Cabo Rojo | 72023 | 517 | 0 | 0 | 517 | 18.040993 | -67.154391 | 2021-02-12 05:23:29 | Cabo Rojo, Puerto Rico, US |
3978926 | 3978926 | 2021-02-10 | US | Alabama | Choctaw | 1023 | 540 | 23 | 0 | 517 | 32.02227341 | -88.26564429999998 | 2021-02-11 05:23:55 | Choctaw, Alabama, US |
1528246 | 1528246 | 2021-02-09 | US | Alabama | Choctaw | 1023 | 540 | 23 | 0 | 517 | 32.02227341 | -88.26564429999998 | 2021-02-10 05:22:41 | Choctaw, Alabama, US |
614037 | 614037 | 2021-02-08 | US | Alabama | Choctaw | 1023 | 540 | 23 | 0 | 517 | 32.02227341 | -88.26564429999998 | 2021-02-09 05:23:30 | Choctaw, Alabama, US |
1672806 | 1672806 | 2021-02-07 | US | Alabama | Choctaw | 1023 | 540 | 23 | 0 | 517 | 32.02227341 | -88.26564429999998 | 2021-02-08 05:22:39 | Choctaw, Alabama, US |
975267 | 975267 | 2021-02-06 | US | Alabama | Choctaw | 1023 | 540 | 23 | 0 | 517 | 32.02227341 | -88.26564429999998 | 2021-02-07 05:23:00 | Choctaw, Alabama, US |
792302 | 792302 | 2021-02-04 | US | Missouri | Maries | 29125 | 524 | 7 | 0 | 517 | 38.16193985 | -91.92249662 | 2021-02-05 05:22:38 | Maries, Missouri, US |
342194 | 342194 | 2021-02-03 | US | Missouri | Maries | 29125 | 524 | 7 | 0 | 517 | 38.16193985 | -91.92249662 | 2021-02-04 05:22:26 | Maries, Missouri, US |
1685785 | 1685785 | 2021-02-02 | US | Kansas | Greenwood | 20073 | 527 | 10 | 0 | 517 | 37.8774388 | -96.23250453 | 2021-02-03 05:22:52 | Greenwood, Kansas, US |
1677755 | 1677755 | 2021-02-01 | US | Kansas | Greenwood | 20073 | 527 | 10 | 0 | 517 | 37.8774388 | -96.23250453 | 2021-02-02 05:22:49 | Greenwood, Kansas, US |
1461078 | 1461078 | 2021-01-31 | US | Kansas | Ottawa | 20143 | 527 | 10 | 0 | 517 | 39.13237408 | -97.65020313 | 2021-02-01 05:22:53 | Ottawa, Kansas, US |
1460200 | 1460200 | 2021-01-31 | US | Arizona | Greenlee | 4011 | 523 | 6 | 0 | 517 | 33.21498827 | -109.2405279 | 2021-02-01 05:22:53 | Greenlee, Arizona, US |
2212986 | 2212986 | 2021-01-30 | US | Kansas | Ottawa | 20143 | 527 | 10 | 0 | 517 | 39.13237408 | -97.65020313 | 2021-01-31 05:22:42 | Ottawa, Kansas, US |
2212524 | 2212524 | 2021-01-30 | US | Georgia | Randolph | 13243 | 548 | 31 | 0 | 517 | 31.76622818 | -84.75732369 | 2021-01-31 05:22:42 | Randolph, Georgia, US |
1900476 | 1900476 | 2021-01-29 | US | Virginia | Essex | 51057 | 520 | 3 | 0 | 517 | 37.93357639 | -76.94230311 | 2021-01-30 05:22:49 | Essex, Virginia, US |
1899865 | 1899865 | 2021-01-29 | US | Puerto Rico | Barceloneta | 72017 | 517 | 0 | 0 | 517 | 18.445533 | -66.56053100000001 | 2021-01-30 05:22:49 | Barceloneta, Puerto Rico, US |
1898473 | 1898473 | 2021-01-29 | US | Kansas | Ottawa | 20143 | 527 | 10 | 0 | 517 | 39.13237408 | -97.65020313 | 2021-01-30 05:22:49 | Ottawa, Kansas, US |
2484736 | 2484736 | 2021-01-28 | US | Puerto Rico | Salinas | 72123 | 517 | 0 | 0 | 517 | 18.010386999999994 | -66.256592 | 2021-01-29 05:22:23 | Salinas, Puerto Rico, US |
2483436 | 2483436 | 2021-01-28 | US | Kentucky | Trimble | 21223 | 520 | 3 | 0 | 517 | 38.61056487 | -85.33775972 | 2021-01-29 05:22:23 | Trimble, Kentucky, US |
12348 | 12348 | 2021-01-26 | Japan | Gifu | 3944 | 67 | 3360 | 517 | 35.778671 | 137.055925 | 2021-01-27 05:23:41 | Gifu, Japan | ||
1759305 | 1759305 | 2021-01-24 | Japan | Gunma | 3604 | 66 | 3021 | 517 | 36.504479 | 138.985605 | 2021-01-25 05:22:16 | Gunma, Japan | ||
2429665 | 2429665 | 2021-01-23 | US | Puerto Rico | Quebradillas | 72115 | 517 | 0 | 0 | 517 | 18.439692 | -66.926113 | 2021-01-24 05:22:35 | Quebradillas, Puerto Rico, US |
2468861 | 2468861 | 2021-01-22 | US | Nebraska | Dixon | 31051 | 525 | 8 | 0 | 517 | 42.49188363 | -96.86782408 | 2021-01-23 05:22:03 | Dixon, Nebraska, US |
437681 | 437681 | 2021-01-21 | US | North Carolina | Jones | 37103 | 533 | 16 | 0 | 517 | 35.02254606 | -77.35870791 | 2021-01-22 05:22:10 | Jones, North Carolina, US |
437412 | 437412 | 2021-01-21 | US | Nebraska | Dixon | 31051 | 525 | 8 | 0 | 517 | 42.49188363 | -96.86782408 | 2021-01-22 05:22:10 | Dixon, Nebraska, US |
1096412 | 1096412 | 2021-01-20 | US | North Carolina | Jones | 37103 | 533 | 16 | 0 | 517 | 35.02254606 | -77.35870791 | 2021-01-21 05:22:01 | Jones, North Carolina, US |
911485 | 911485 | 2021-01-19 | US | Virginia | Charlotte | 51037 | 527 | 10 | 0 | 517 | 37.01909701 | -78.66314092 | 2021-01-20 05:21:54 | Charlotte, Virginia, US |
240510 | 240510 | 2021-01-18 | US | Vermont | Addison | 50001 | 522 | 5 | 0 | 517 | 44.03217337 | -73.14130877 | 2021-01-19 05:22:15 | Addison, Vermont, US |
238633 | 238633 | 2021-01-18 | US | Kentucky | Gallatin | 21077 | 530 | 13 | 0 | 517 | 38.75398691 | -84.8558382 | 2021-01-19 05:22:15 | Gallatin, Kentucky, US |
238623 | 238623 | 2021-01-18 | US | Kentucky | Cumberland | 21057 | 523 | 6 | 0 | 517 | 36.78926125 | -85.39050034 | 2021-01-19 05:22:15 | Cumberland, Kentucky, US |
3506961 | 3506961 | 2021-01-17 | US | Wyoming | Platte | 56031 | 526 | 9 | 0 | 517 | 42.13299116 | -104.966331 | 2021-01-18 05:22:34 | Platte, Wyoming, US |
3504651 | 3504651 | 2021-01-17 | US | Kansas | Kearny | 20093 | 527 | 10 | 0 | 517 | 38.00017981 | -101.321681 | 2021-01-18 05:22:34 | Kearny, Kansas, US |
3102734 | 3102734 | 2021-01-16 | US | Kansas | Kearny | 20093 | 527 | 10 | 0 | 517 | 38.00017981 | -101.321681 | 2021-01-17 05:22:17 | Kearny, Kansas, US |
3516696 | 3516696 | 2021-01-15 | US | Kansas | Kearny | 20093 | 527 | 10 | 0 | 517 | 38.00017981 | -101.321681 | 2021-01-16 05:22:40 | Kearny, Kansas, US |
3881964 | 3881964 | 2021-01-14 | US | North Dakota | Foster | 38031 | 535 | 19 | 0 | 517 | 47.4571084 | -98.88279923 | 2021-01-15 05:22:24 | Foster, North Dakota, US |
3310591 | 3310591 | 2021-01-13 | US | North Dakota | Foster | 38031 | 533 | 19 | 0 | 517 | 47.4571084 | -98.88279923 | 2021-01-14 05:22:32 | Foster, North Dakota, US |
193109 | 193109 | 2021-01-11 | US | Texas | Coleman | 48083 | 605 | 16 | 0 | 517 | 31.76736834 | -99.45240766 | 2021-01-12 05:22:15 | Coleman, Texas, US |
192457 | 192457 | 2021-01-11 | US | North Dakota | Foster | 38031 | 532 | 19 | 0 | 517 | 47.4571084 | -98.88279923 | 2021-01-12 05:22:15 | Foster, North Dakota, US |
2628912 | 2628912 | 2021-01-10 | US | Texas | Coleman | 48083 | 605 | 16 | 0 | 517 | 31.76736834 | -99.45240766 | 2021-01-11 05:21:50 | Coleman, Texas, US |
2628260 | 2628260 | 2021-01-10 | US | North Dakota | Foster | 38031 | 530 | 19 | 0 | 517 | 47.4571084 | -98.88279923 | 2021-01-11 05:21:50 | Foster, North Dakota, US |
3903000 | 3903000 | 2021-01-09 | US | Texas | Coleman | 48083 | 605 | 16 | 0 | 517 | 31.76736834 | -99.45240766 | 2021-01-10 05:22:12 | Coleman, Texas, US |
3902782 | 3902782 | 2021-01-09 | US | South Carolina | McCormick | 45065 | 526 | 9 | 0 | 517 | 33.90161443 | -82.30794338 | 2021-01-10 05:22:12 | McCormick, South Carolina, US |
3902348 | 3902348 | 2021-01-09 | US | North Dakota | Foster | 38031 | 530 | 19 | 0 | 517 | 47.4571084 | -98.88279923 | 2021-01-10 05:22:12 | Foster, North Dakota, US |
156736 | 156736 | 2021-01-08 | US | Puerto Rico | Naguabo | 72103 | 517 | 0 | 0 | 517 | 18.230637 | -65.753897 | 2021-01-09 05:22:18 | Naguabo, Puerto Rico, US |
154014 | 154014 | 2021-01-08 | Japan | Okinawa | 5759 | 84 | 5158 | 517 | 25.768923 | 126.668016 | 2021-01-09 05:22:18 | Okinawa, Japan | ||
2541997 | 2541997 | 2021-01-07 | US | Colorado | Archuleta | 8007 | 558 | 1 | 0 | 517 | 37.19474156 | -107.0476867 | 2021-01-08 05:22:42 | Archuleta, Colorado, US |
2866755 | 2866755 | 2021-01-06 | US | Nebraska | Burt | 31021 | 527 | 10 | 0 | 517 | 41.85056773 | -96.32605633 | 2021-01-07 05:22:03 | Burt, Nebraska, US |
2865231 | 2865231 | 2021-01-06 | US | Arkansas | Searcy | 5129 | 530 | 13 | 0 | 517 | 35.9109364 | -92.69936482 | 2021-01-07 05:22:03 | Searcy, Arkansas, US |
3037980 | 3037980 | 2021-01-05 | Malaysia | Pahang | 1471 | 8 | 946 | 517 | 3.8126 | 103.3256 | 2021-01-06 05:22:16 | Pahang, Malaysia | ||
3036834 | 3036834 | 2021-01-05 | US | Oklahoma | Coal | 40029 | 521 | 4 | 0 | 517 | 34.58840127 | -96.29798747 | 2021-01-06 05:22:16 | Coal, Oklahoma, US |
3036453 | 3036453 | 2021-01-05 | US | New Hampshire | Sullivan | 33019 | 523 | 6 | 0 | 517 | 43.36094111 | -72.22203125 | 2021-01-06 05:22:16 | Sullivan, New Hampshire, US |
3036342 | 3036342 | 2021-01-05 | US | Nebraska | Burt | 31021 | 526 | 9 | 0 | 517 | 41.85056773 | -96.32605633 | 2021-01-06 05:22:16 | Burt, Nebraska, US |
3036302 | 3036302 | 2021-01-05 | US | Montana | Madison | 30057 | 520 | 3 | 0 | 517 | 45.30080065 | -111.9173017 | 2021-01-06 05:22:16 | Madison, Montana, US |
3036154 | 3036154 | 2021-01-05 | US | Mississippi | Wilkinson | 28157 | 541 | 24 | 0 | 517 | 31.16078225 | -91.31018819 | 2021-01-06 05:22:16 | Wilkinson, Mississippi, US |
1064379 | 1064379 | 2021-01-04 | US | Oklahoma | Coal | 40029 | 521 | 4 | 0 | 517 | 34.58840127 | -96.29798747 | 2021-01-05 05:21:49 | Coal, Oklahoma, US |
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]);