johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19,730 rows where country_or_region = "United Kingdom" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2021-03-14 55
- 2022-04-13 38
- 2022-05-26 38
- 2022-12-26 23
- 2021-02-23 21
- 2020-04-05 19
- 2020-04-07 19
- 2020-04-08 19
- 2020-04-09 19
- 2020-04-10 19
- 2020-04-11 19
- 2020-04-12 19
- 2020-04-13 19
- 2020-04-14 19
- 2020-04-15 19
- 2020-04-16 19
- 2020-04-17 19
- 2020-04-18 19
- 2020-04-19 19
- 2020-04-20 19
- 2020-04-21 19
- 2020-04-22 19
- 2020-04-24 19
- 2020-04-28 19
- 2020-04-29 19
- 2020-04-30 19
- 2020-05-01 19
- 2020-05-02 19
- 2020-05-03 19
- 2020-05-04 19
- …
province_or_state 20
- England 1,066
- Guernsey 1,066
- Jersey 1,066
- Northern Ireland 1,066
- Pitcairn Islands 1,066
- Scotland 1,066
- Unknown 1,066
- Wales 1,066
- Channel Islands 1,020
- Gibraltar 1,020
- Cayman Islands 1,015
- Montserrat 1,013
- Bermuda 1,012
- Isle of Man 1,011
- Saint Helena, Ascension and Tristan da Cunha 1,006
- Anguilla 1,003
- British Virgin Islands 1,003
- Turks and Caicos Islands 1,003
- Falkland Islands (Malvinas) 993
- Falkland Islands (Islas Malvinas) 3
country_or_region 1
- United Kingdom · 19,630 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32068 | 32068 | 2021-11-11 | United Kingdom | Anguilla | 1109 | 3 | 0 | 18.2206 | -63.0686 | 2021-11-12 04:22:01 | Anguilla, United Kingdom | |||
32069 | 32069 | 2021-11-11 | United Kingdom | Bermuda | 5692 | 106 | 0 | 32.3078 | -64.7505 | 2021-11-12 04:22:01 | Bermuda, United Kingdom | |||
32070 | 32070 | 2021-11-11 | United Kingdom | British Virgin Islands | 2745 | 38 | 0 | 18.4207 | -64.64 | 2021-11-12 04:22:01 | British Virgin Islands, United Kingdom | |||
32071 | 32071 | 2021-11-11 | United Kingdom | Cayman Islands | 3427 | 2 | 0 | 19.3133 | -81.2546 | 2021-11-12 04:22:01 | Cayman Islands, United Kingdom | |||
32072 | 32072 | 2021-11-11 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-12 04:22:01 | Channel Islands, United Kingdom | |||
32073 | 32073 | 2021-11-11 | United Kingdom | England | 8020241 | 145731 | 0 | 52.3555 | -1.1743 | 2021-11-12 04:22:01 | England, United Kingdom | |||
32074 | 32074 | 2021-11-11 | United Kingdom | Falkland Islands (Malvinas) | 79 | 0 | 0 | -51.7963 | -59.5236 | 2021-11-12 04:22:01 | Falkland Islands (Malvinas), United Kingdom | |||
32075 | 32075 | 2021-11-11 | United Kingdom | Gibraltar | 6328 | 98 | 0 | 36.1408 | -5.3536 | 2021-11-12 04:22:01 | Gibraltar, United Kingdom | |||
32076 | 32076 | 2021-11-11 | United Kingdom | Isle of Man | 10159 | 64 | 0 | 54.2361 | -4.5481 | 2021-11-12 04:22:01 | Isle of Man, United Kingdom | |||
32077 | 32077 | 2021-11-11 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-12 04:22:01 | Montserrat, United Kingdom | |||
32078 | 32078 | 2021-11-11 | United Kingdom | Northern Ireland | 288686 | 3795 | 0 | 54.7877 | -6.4923 | 2021-11-12 04:22:01 | Northern Ireland, United Kingdom | |||
32079 | 32079 | 2021-11-11 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-11-12 04:22:01 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
32080 | 32080 | 2021-11-11 | United Kingdom | Scotland | 674062 | 12002 | 0 | 56.4907 | -4.2026 | 2021-11-12 04:22:01 | Scotland, United Kingdom | |||
32081 | 32081 | 2021-11-11 | United Kingdom | Turks and Caicos Islands | 3030 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-11-12 04:22:01 | Turks and Caicos Islands, United Kingdom | |||
32082 | 32082 | 2021-11-11 | United Kingdom | Unknown | 0 | 235 | 0 | 55.3781 | -3.436 | 2021-11-12 04:22:01 | Unknown, United Kingdom | |||
32083 | 32083 | 2021-11-11 | United Kingdom | Wales | 465413 | 8903 | 0 | 52.1307 | -3.7837 | 2021-11-12 04:22:01 | Wales, United Kingdom | |||
32095 | 32095 | 2021-11-11 | United Kingdom | Jersey | 11745 | 80 | 0 | 0 | 49.2138 | -2.1358 | 2021-11-12 04:22:01 | Jersey, United Kingdom | ||
32096 | 32096 | 2021-11-11 | United Kingdom | Guernsey | 2494 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-11-12 04:22:01 | Guernsey, United Kingdom | ||
32102 | 32102 | 2021-11-11 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-12 04:22:01 | Pitcairn Islands, United Kingdom | ||
36064 | 36064 | 2021-08-25 | United Kingdom | Anguilla | 174 | 0 | 0 | 18.2206 | -63.0686 | 2021-08-26 04:21:28 | Anguilla, United Kingdom | |||
36065 | 36065 | 2021-08-25 | United Kingdom | Bermuda | 2792 | 33 | 0 | 32.3078 | -64.7505 | 2021-08-26 04:21:28 | Bermuda, United Kingdom | |||
36066 | 36066 | 2021-08-25 | United Kingdom | British Virgin Islands | 2568 | 37 | 0 | 18.4207 | -64.64 | 2021-08-26 04:21:28 | British Virgin Islands, United Kingdom | |||
36067 | 36067 | 2021-08-25 | United Kingdom | Cayman Islands | 669 | 2 | 0 | 19.3133 | -81.2546 | 2021-08-26 04:21:28 | Cayman Islands, United Kingdom | |||
36068 | 36068 | 2021-08-25 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-08-26 04:21:28 | Channel Islands, United Kingdom | |||
36069 | 36069 | 2021-08-25 | United Kingdom | England | 5734967 | 137034 | 0 | 52.3555 | -1.1743 | 2021-08-26 04:21:28 | England, United Kingdom | |||
36070 | 36070 | 2021-08-25 | United Kingdom | Falkland Islands (Malvinas) | 66 | 0 | 0 | -51.7963 | -59.5236 | 2021-08-26 04:21:28 | Falkland Islands (Malvinas), United Kingdom | |||
36071 | 36071 | 2021-08-25 | United Kingdom | Gibraltar | 5308 | 96 | 0 | 36.1408 | -5.3536 | 2021-08-26 04:21:28 | Gibraltar, United Kingdom | |||
36072 | 36072 | 2021-08-25 | United Kingdom | Isle of Man | 6432 | 37 | 0 | 54.2361 | -4.5481 | 2021-08-26 04:21:28 | Isle of Man, United Kingdom | |||
36073 | 36073 | 2021-08-25 | United Kingdom | Montserrat | 25 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-08-26 04:21:28 | Montserrat, United Kingdom | |||
36074 | 36074 | 2021-08-25 | United Kingdom | Northern Ireland | 192008 | 3208 | 0 | 54.7877 | -6.4923 | 2021-08-26 04:21:28 | Northern Ireland, United Kingdom | |||
36075 | 36075 | 2021-08-25 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-08-26 04:21:28 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
36076 | 36076 | 2021-08-25 | United Kingdom | Scotland | 395918 | 10583 | 0 | 56.4907 | -4.2026 | 2021-08-26 04:21:28 | Scotland, United Kingdom | |||
36077 | 36077 | 2021-08-25 | United Kingdom | Turks and Caicos Islands | 2616 | 20 | 0 | 21.69400000000001 | -71.7979 | 2021-08-26 04:21:28 | Turks and Caicos Islands, United Kingdom | |||
36078 | 36078 | 2021-08-25 | United Kingdom | Unknown | 0 | 206 | 0 | 55.3781 | -3.436 | 2021-08-26 04:21:28 | Unknown, United Kingdom | |||
36079 | 36079 | 2021-08-25 | United Kingdom | Wales | 267854 | 8057 | 0 | 52.1307 | -3.7837 | 2021-08-26 04:21:28 | Wales, United Kingdom | |||
36109 | 36109 | 2021-08-25 | United Kingdom | Jersey | 9171 | 76 | 0 | 0 | 49.2138 | -2.1358 | 2021-08-26 04:21:28 | Jersey, United Kingdom | ||
36110 | 36110 | 2021-08-25 | United Kingdom | Guernsey | 1191 | 18 | 0 | 0 | 49.448196 | -2.58949 | 2021-08-26 04:21:28 | Guernsey, United Kingdom | ||
36116 | 36116 | 2021-08-25 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-08-26 04:21:28 | Pitcairn Islands, United Kingdom | ||
40079 | 40079 | 2021-04-12 | United Kingdom | England | 3822371 | 132179 | 0 | 3710561 | 52.3555 | -1.1743 | 2021-04-13 04:20:37 | England, United Kingdom | ||
40084 | 40084 | 2021-04-12 | United Kingdom | Northern Ireland | 118364 | 2947 | 0 | 116235 | 54.7877 | -6.4923 | 2021-04-13 04:20:37 | Northern Ireland, United Kingdom | ||
40086 | 40086 | 2021-04-12 | United Kingdom | Scotland | 222161 | 10068 | 0 | 214531 | 56.4907 | -4.2026 | 2021-04-13 04:20:37 | Scotland, United Kingdom | ||
40088 | 40088 | 2021-04-12 | United Kingdom | Unknown | 0 | 182 | 0 | 0 | 55.3781 | -3.436 | 2021-04-13 04:20:37 | Unknown, United Kingdom | ||
40089 | 40089 | 2021-04-12 | United Kingdom | Wales | 210447 | 7892 | 0 | 204916 | 52.1307 | -3.7837 | 2021-04-13 04:20:37 | Wales, United Kingdom | ||
40123 | 40123 | 2021-04-12 | United Kingdom | Jersey | 3228 | 69 | 0 | 0 | 49.2138 | -2.1358 | 2021-04-13 04:20:37 | Jersey, United Kingdom | ||
40124 | 40124 | 2021-04-12 | United Kingdom | Guernsey | 821 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-04-13 04:20:37 | Guernsey, United Kingdom | ||
40130 | 40130 | 2021-04-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-04-13 04:20:37 | Pitcairn Islands, United Kingdom | ||
40328 | 40328 | 2020-03-05 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-05T14:53:03 | ||||
40329 | 40329 | 2020-03-05 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-05T14:53:03 | ||||
40332 | 40332 | 2020-03-05 | United Kingdom | England | 0 | 7 | 0 | 52.3555 | -1.1743 | 2020-03-05T14:53:03 | ||||
40333 | 40333 | 2020-03-05 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 2020-03-05T14:53:03 | ||||
40334 | 40334 | 2020-03-05 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-05T14:53:03 | ||||
40335 | 40335 | 2020-03-05 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-05T14:53:03 | ||||
40339 | 40339 | 2020-03-05 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-05T14:53:03 | ||||
43140 | 43140 | 2020-04-13 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 0 | 0 | 0 | 0 | -7.9467 | -14.3559 | 2020-04-13 23:07:34 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
43154 | 43154 | 2020-04-13 | United Kingdom | Turks and Caicos Islands | 10 | 1 | 0 | 9 | 21.69400000000001 | -71.7979 | 2020-04-13 23:07:34 | Turks and Caicos Islands, United Kingdom | ||
43333 | 43333 | 2020-04-13 | United Kingdom | Unknown | 88621 | 40 | 0 | 77292 | 55.3781 | -3.436 | 2020-04-13 23:07:34 | United Kingdom | ||
43367 | 43367 | 2020-04-13 | United Kingdom | Jersey | 194 | 4 | 0 | 0 | 49.2138 | -2.1358 | 2020-04-13 23:07:54 | Jersey, United Kingdom | ||
43368 | 43368 | 2020-04-13 | United Kingdom | Guernsey | 218 | 10 | 0 | 0 | 49.448196 | -2.58949 | 2020-04-13 23:07:54 | Guernsey, United Kingdom | ||
43371 | 43371 | 2020-04-13 | United Kingdom | England | 82601 | 0 | 18618 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-13 23:07:54 | England, United Kingdom | |
43372 | 43372 | 2020-04-13 | United Kingdom | Northern Ireland | 82602 | 0 | 226 | 0 | 0 | 54.7877 | -6.4923 | 2020-04-13 23:07:54 | Northern Ireland, United Kingdom | |
43373 | 43373 | 2020-04-13 | United Kingdom | Scotland | 82603 | 0 | 1364 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-13 23:07:54 | Scotland, United Kingdom | |
43374 | 43374 | 2020-04-13 | United Kingdom | Wales | 82604 | 0 | 845 | 0 | 0 | 52.1307 | -3.7837 | 2020-04-13 23:07:54 | Wales, United Kingdom | |
43378 | 43378 | 2020-04-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-04-13 23:07:54 | Pitcairn Islands, United Kingdom | ||
47360 | 47360 | 2021-11-02 | United Kingdom | Anguilla | 944 | 1 | 0 | 18.2206 | -63.0686 | 2021-11-03 06:22:09 | Anguilla, United Kingdom | |||
47361 | 47361 | 2021-11-02 | United Kingdom | Bermuda | 5657 | 104 | 0 | 32.3078 | -64.7505 | 2021-11-03 06:22:09 | Bermuda, United Kingdom | |||
47362 | 47362 | 2021-11-02 | United Kingdom | British Virgin Islands | 2725 | 37 | 0 | 18.4207 | -64.64 | 2021-11-03 06:22:09 | British Virgin Islands, United Kingdom | |||
47363 | 47363 | 2021-11-02 | United Kingdom | Cayman Islands | 1650 | 2 | 0 | 19.3133 | -81.2546 | 2021-11-03 06:22:09 | Cayman Islands, United Kingdom | |||
47364 | 47364 | 2021-11-02 | United Kingdom | Channel Islands | 0 | 0 | 0 | 49.3723 | -2.3644 | 2021-11-03 06:22:09 | Channel Islands, United Kingdom | |||
47365 | 47365 | 2021-11-02 | United Kingdom | England | 7760671 | 144560 | 0 | 52.3555 | -1.1743 | 2021-11-03 06:22:09 | England, United Kingdom | |||
47366 | 47366 | 2021-11-02 | United Kingdom | Falkland Islands (Malvinas) | 69 | 0 | 0 | -51.7963 | -59.5236 | 2021-11-03 06:22:09 | Falkland Islands (Malvinas), United Kingdom | |||
47367 | 47367 | 2021-11-02 | United Kingdom | Gibraltar | 6029 | 98 | 0 | 36.1408 | -5.3536 | 2021-11-03 06:22:09 | Gibraltar, United Kingdom | |||
47368 | 47368 | 2021-11-02 | United Kingdom | Isle of Man | 9796 | 57 | 0 | 54.2361 | -4.5481 | 2021-11-03 06:22:09 | Isle of Man, United Kingdom | |||
47369 | 47369 | 2021-11-02 | United Kingdom | Montserrat | 41 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-03 06:22:09 | Montserrat, United Kingdom | |||
47370 | 47370 | 2021-11-02 | United Kingdom | Northern Ireland | 277334 | 3717 | 0 | 54.7877 | -6.4923 | 2021-11-03 06:22:09 | Northern Ireland, United Kingdom | |||
47371 | 47371 | 2021-11-02 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 4 | 0 | 0 | -7.9467 | -14.3559 | 2021-11-03 06:22:09 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
47372 | 47372 | 2021-11-02 | United Kingdom | Scotland | 647689 | 11857 | 0 | 56.4907 | -4.2026 | 2021-11-03 06:22:09 | Scotland, United Kingdom | |||
47373 | 47373 | 2021-11-02 | United Kingdom | Turks and Caicos Islands | 2989 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-11-03 06:22:09 | Turks and Caicos Islands, United Kingdom | |||
47374 | 47374 | 2021-11-02 | United Kingdom | Unknown | 0 | 231 | 0 | 55.3781 | -3.436 | 2021-11-03 06:22:09 | Unknown, United Kingdom | |||
47375 | 47375 | 2021-11-02 | United Kingdom | Wales | 445163 | 8804 | 0 | 52.1307 | -3.7837 | 2021-11-03 06:22:09 | Wales, United Kingdom | |||
47387 | 47387 | 2021-11-02 | United Kingdom | Jersey | 11158 | 80 | 0 | 0 | 49.2138 | -2.1358 | 2021-11-03 06:22:09 | Jersey, United Kingdom | ||
47388 | 47388 | 2021-11-02 | United Kingdom | Guernsey | 2170 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-11-03 06:22:09 | Guernsey, United Kingdom | ||
47394 | 47394 | 2021-11-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-03 06:22:09 | Pitcairn Islands, United Kingdom | ||
50239 | 50239 | 2020-04-17 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 0 | 0 | 0 | 0 | -7.9467 | -14.3559 | 2020-04-17 23:30:32 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
50253 | 50253 | 2020-04-17 | United Kingdom | Turks and Caicos Islands | 11 | 1 | 0 | 10 | 21.69400000000001 | -71.7979 | 2020-04-17 23:30:32 | Turks and Caicos Islands, United Kingdom | ||
50432 | 50432 | 2020-04-17 | United Kingdom | Unknown | 108692 | 50 | 0 | 94116 | 55.3781 | -3.436 | 2020-04-17 23:30:32 | United Kingdom | ||
50466 | 50466 | 2020-04-17 | United Kingdom | Jersey | 215 | 7 | 0 | 0 | 49.2138 | -2.1358 | 2020-04-17 23:30:52 | Jersey, United Kingdom | ||
50467 | 50467 | 2020-04-17 | United Kingdom | Guernsey | 234 | 13 | 0 | 0 | 49.448196 | -2.58949 | 2020-04-17 23:30:52 | Guernsey, United Kingdom | ||
50470 | 50470 | 2020-04-17 | United Kingdom | England | 82601 | 0 | 23052 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-17 23:30:52 | England, United Kingdom | |
50471 | 50471 | 2020-04-17 | United Kingdom | Northern Ireland | 82602 | 0 | 293 | 0 | 0 | 54.7877 | -6.4923 | 2020-04-17 23:30:52 | Northern Ireland, United Kingdom | |
50472 | 50472 | 2020-04-17 | United Kingdom | Scotland | 82603 | 0 | 1743 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-17 23:30:52 | Scotland, United Kingdom | |
50473 | 50473 | 2020-04-17 | United Kingdom | Wales | 82604 | 0 | 1079 | 0 | 0 | 52.1307 | -3.7837 | 2020-04-17 23:30:52 | Wales, United Kingdom | |
50477 | 50477 | 2020-04-17 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-04-17 23:30:52 | Pitcairn Islands, United Kingdom | ||
54441 | 54441 | 2021-05-29 | United Kingdom | England | 3910803 | 132971 | 0 | 3798418 | 52.3555 | -1.1743 | 2021-05-30 04:20:55 | England, United Kingdom | ||
54446 | 54446 | 2021-05-29 | United Kingdom | Northern Ireland | 122575 | 2980 | 0 | 120422 | 54.7877 | -6.4923 | 2021-05-30 04:20:55 | Northern Ireland, United Kingdom | ||
54448 | 54448 | 2021-05-29 | United Kingdom | Scotland | 234895 | 10143 | 0 | 227227 | 56.4907 | -4.2026 | 2021-05-30 04:20:55 | Scotland, United Kingdom | ||
54450 | 54450 | 2021-05-29 | United Kingdom | Unknown | 0 | 184 | 0 | 0 | 55.3781 | -3.436 | 2021-05-30 04:20:55 | Unknown, United Kingdom | ||
54451 | 54451 | 2021-05-29 | United Kingdom | Wales | 212672 | 7933 | 0 | 207103 | 52.1307 | -3.7837 | 2021-05-30 04:20:55 | Wales, United Kingdom | ||
54484 | 54484 | 2021-05-29 | United Kingdom | Jersey | 3241 | 69 | 0 | 0 | 49.2138 | -2.1358 | 2021-05-30 04:20:55 | Jersey, United Kingdom | ||
54485 | 54485 | 2021-05-29 | United Kingdom | Guernsey | 822 | 17 | 0 | 0 | 49.448196 | -2.58949 | 2021-05-30 04:20:55 | Guernsey, United Kingdom | ||
54491 | 54491 | 2021-05-29 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-05-30 04:20:55 | Pitcairn Islands, United Kingdom |
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]);