johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,298 rows where country_or_region = "United Kingdom" sorted by day descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)
province_or_state
- Channel Islands 318
- Gibraltar 318
- Cayman Islands 313
- Montserrat 311
- Bermuda 310
- Isle of Man 309
- Anguilla 301
- British Virgin Islands 301
- Turks and Caicos Islands 301
- Falkland Islands (Malvinas) 291
- England 226
- Northern Ireland 226
- Scotland 226
- Unknown 226
- Wales 226
- United Kingdom 9
- Falkland Islands (Islas Malvinas) 3
- UK 2
country_or_region
- United Kingdom · 4,298 ✖
| Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93323 | 93323 | 2021-01-22 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-23 05:22:03 | Anguilla, United Kingdom | ||
| 93324 | 93324 | 2021-01-22 | United Kingdom | Bermuda | 684 | 12 | 625 | 47 | 32.3078 | -64.7505 | 2021-01-23 05:22:03 | Bermuda, United Kingdom | ||
| 93325 | 93325 | 2021-01-22 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-23 05:22:03 | British Virgin Islands, United Kingdom | ||
| 93326 | 93326 | 2021-01-22 | United Kingdom | Cayman Islands | 382 | 2 | 346 | 34 | 19.3133 | -81.2546 | 2021-01-23 05:22:03 | Cayman Islands, United Kingdom | ||
| 93327 | 93327 | 2021-01-22 | United Kingdom | Channel Islands | 3414 | 78 | 3148 | 188 | 49.3723 | -2.3644 | 2021-01-23 05:22:03 | Channel Islands, United Kingdom | ||
| 93328 | 93328 | 2021-01-22 | United Kingdom | England | 3129156 | 84190 | 0 | 3044966 | 52.3555 | -1.1743 | 2021-01-23 05:22:03 | England, United Kingdom | ||
| 93329 | 93329 | 2021-01-22 | United Kingdom | Falkland Islands (Malvinas) | 35 | 0 | 29 | 6 | -51.7963 | -59.5236 | 2021-01-23 05:22:03 | Falkland Islands (Malvinas), United Kingdom | ||
| 93330 | 93330 | 2021-01-22 | United Kingdom | Gibraltar | 3905 | 59 | 3097 | 749 | 36.1408 | -5.3536 | 2021-01-23 05:22:03 | Gibraltar, United Kingdom | ||
| 93331 | 93331 | 2021-01-22 | United Kingdom | Isle of Man | 432 | 25 | 357 | 50 | 54.2361 | -4.5481 | 2021-01-23 05:22:03 | Isle of Man, United Kingdom | ||
| 93332 | 93332 | 2021-01-22 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-23 05:22:03 | Montserrat, United Kingdom | ||
| 93333 | 93333 | 2021-01-22 | United Kingdom | Northern Ireland | 99216 | 1704 | 0 | 97512 | 54.7877 | -6.4923 | 2021-01-23 05:22:03 | Northern Ireland, United Kingdom | ||
| 93334 | 93334 | 2021-01-22 | United Kingdom | Scotland | 169699 | 5628 | 0 | 164071 | 56.4907 | -4.2026 | 2021-01-23 05:22:03 | Scotland, United Kingdom | ||
| 93335 | 93335 | 2021-01-22 | United Kingdom | Turks and Caicos Islands | 1193 | 7 | 954 | 232 | 21.694000000000006 | -71.7979 | 2021-01-23 05:22:03 | Turks and Caicos Islands, United Kingdom | ||
| 93336 | 93336 | 2021-01-22 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-01-23 05:22:03 | Unknown, United Kingdom | ||||
| 93337 | 93337 | 2021-01-22 | United Kingdom | Wales | 185836 | 4459 | 0 | 181377 | 52.1307 | -3.7837 | 2021-01-23 05:22:03 | Wales, United Kingdom | ||
| 306229 | 306229 | 2021-01-21 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-22 05:22:10 | Anguilla, United Kingdom | ||
| 306230 | 306230 | 2021-01-21 | United Kingdom | Bermuda | 684 | 12 | 611 | 61 | 32.3078 | -64.7505 | 2021-01-22 05:22:10 | Bermuda, United Kingdom | ||
| 306231 | 306231 | 2021-01-21 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-22 05:22:10 | British Virgin Islands, United Kingdom | ||
| 306232 | 306232 | 2021-01-21 | United Kingdom | Cayman Islands | 382 | 2 | 346 | 34 | 19.3133 | -81.2546 | 2021-01-22 05:22:10 | Cayman Islands, United Kingdom | ||
| 306233 | 306233 | 2021-01-21 | United Kingdom | Channel Islands | 3407 | 78 | 3148 | 181 | 49.3723 | -2.3644 | 2021-01-22 05:22:10 | Channel Islands, United Kingdom | ||
| 306234 | 306234 | 2021-01-21 | United Kingdom | England | 3092041 | 82939 | 0 | 3009102 | 52.3555 | -1.1743 | 2021-01-22 05:22:10 | England, United Kingdom | ||
| 306235 | 306235 | 2021-01-21 | United Kingdom | Falkland Islands (Malvinas) | 35 | 0 | 29 | 6 | -51.7963 | -59.5236 | 2021-01-22 05:22:10 | Falkland Islands (Malvinas), United Kingdom | ||
| 306236 | 306236 | 2021-01-21 | United Kingdom | Gibraltar | 3881 | 59 | 3033 | 789 | 36.1408 | -5.3536 | 2021-01-22 05:22:10 | Gibraltar, United Kingdom | ||
| 306237 | 306237 | 2021-01-21 | United Kingdom | Isle of Man | 432 | 25 | 357 | 50 | 54.2361 | -4.5481 | 2021-01-22 05:22:10 | Isle of Man, United Kingdom | ||
| 306238 | 306238 | 2021-01-21 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-22 05:22:10 | Montserrat, United Kingdom | ||
| 306239 | 306239 | 2021-01-21 | United Kingdom | Northern Ireland | 98351 | 1692 | 0 | 96659 | 54.7877 | -6.4923 | 2021-01-22 05:22:10 | Northern Ireland, United Kingdom | ||
| 306240 | 306240 | 2021-01-21 | United Kingdom | Scotland | 168219 | 5557 | 0 | 162662 | 56.4907 | -4.2026 | 2021-01-22 05:22:10 | Scotland, United Kingdom | ||
| 306241 | 306241 | 2021-01-21 | United Kingdom | Turks and Caicos Islands | 1164 | 7 | 935 | 222 | 21.694000000000006 | -71.7979 | 2021-01-22 05:22:10 | Turks and Caicos Islands, United Kingdom | ||
| 306242 | 306242 | 2021-01-21 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-01-22 05:22:10 | Unknown, United Kingdom | ||||
| 306243 | 306243 | 2021-01-21 | United Kingdom | Wales | 185035 | 4392 | 0 | 180643 | 52.1307 | -3.7837 | 2021-01-22 05:22:10 | Wales, United Kingdom | ||
| 897280 | 897280 | 2021-01-20 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-21 05:22:01 | Anguilla, United Kingdom | ||
| 897281 | 897281 | 2021-01-20 | United Kingdom | Bermuda | 684 | 12 | 611 | 61 | 32.3078 | -64.7505 | 2021-01-21 05:22:01 | Bermuda, United Kingdom | ||
| 897282 | 897282 | 2021-01-20 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-21 05:22:01 | British Virgin Islands, United Kingdom | ||
| 897283 | 897283 | 2021-01-20 | United Kingdom | Cayman Islands | 381 | 2 | 341 | 38 | 19.3133 | -81.2546 | 2021-01-21 05:22:01 | Cayman Islands, United Kingdom | ||
| 897284 | 897284 | 2021-01-20 | United Kingdom | Channel Islands | 3398 | 78 | 3107 | 213 | 49.3723 | -2.3644 | 2021-01-21 05:22:01 | Channel Islands, United Kingdom | ||
| 897285 | 897285 | 2021-01-20 | United Kingdom | England | 3057670 | 81805 | 0 | 2975865 | 52.3555 | -1.1743 | 2021-01-21 05:22:01 | England, United Kingdom | ||
| 897286 | 897286 | 2021-01-20 | United Kingdom | Falkland Islands (Malvinas) | 35 | 0 | 29 | 6 | -51.7963 | -59.5236 | 2021-01-21 05:22:01 | Falkland Islands (Malvinas), United Kingdom | ||
| 897287 | 897287 | 2021-01-20 | United Kingdom | Gibraltar | 3845 | 53 | 2994 | 798 | 36.1408 | -5.3536 | 2021-01-21 05:22:01 | Gibraltar, United Kingdom | ||
| 897288 | 897288 | 2021-01-20 | United Kingdom | Isle of Man | 432 | 25 | 357 | 50 | 54.2361 | -4.5481 | 2021-01-21 05:22:01 | Isle of Man, United Kingdom | ||
| 897289 | 897289 | 2021-01-20 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-21 05:22:01 | Montserrat, United Kingdom | ||
| 897290 | 897290 | 2021-01-20 | United Kingdom | Northern Ireland | 97619 | 1671 | 0 | 95948 | 54.7877 | -6.4923 | 2021-01-21 05:22:01 | Northern Ireland, United Kingdom | ||
| 897291 | 897291 | 2021-01-20 | United Kingdom | Scotland | 166583 | 5468 | 0 | 161115 | 56.4907 | -4.2026 | 2021-01-21 05:22:01 | Scotland, United Kingdom | ||
| 897292 | 897292 | 2021-01-20 | United Kingdom | Turks and Caicos Islands | 1125 | 7 | 931 | 187 | 21.694000000000006 | -71.7979 | 2021-01-21 05:22:01 | Turks and Caicos Islands, United Kingdom | ||
| 897293 | 897293 | 2021-01-20 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-01-21 05:22:01 | Unknown, United Kingdom | ||||
| 897294 | 897294 | 2021-01-20 | United Kingdom | Wales | 183882 | 4346 | 0 | 179536 | 52.1307 | -3.7837 | 2021-01-21 05:22:01 | Wales, United Kingdom | ||
| 325847 | 325847 | 2021-01-19 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-20 05:21:54 | Anguilla, United Kingdom | ||
| 325848 | 325848 | 2021-01-19 | United Kingdom | Bermuda | 684 | 12 | 603 | 69 | 32.3078 | -64.7505 | 2021-01-20 05:21:54 | Bermuda, United Kingdom | ||
| 325849 | 325849 | 2021-01-19 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-20 05:21:54 | British Virgin Islands, United Kingdom | ||
| 325850 | 325850 | 2021-01-19 | United Kingdom | Cayman Islands | 381 | 2 | 334 | 45 | 19.3133 | -81.2546 | 2021-01-20 05:21:54 | Cayman Islands, United Kingdom | ||
| 325851 | 325851 | 2021-01-19 | United Kingdom | Channel Islands | 3386 | 78 | 3107 | 201 | 49.3723 | -2.3644 | 2021-01-20 05:21:54 | Channel Islands, United Kingdom | ||
| 325852 | 325852 | 2021-01-19 | United Kingdom | England | 3022609 | 80143 | 0 | 2942466 | 52.3555 | -1.1743 | 2021-01-20 05:21:54 | England, United Kingdom | ||
| 325853 | 325853 | 2021-01-19 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-20 05:21:54 | Falkland Islands (Malvinas), United Kingdom | ||
| 325854 | 325854 | 2021-01-19 | United Kingdom | Gibraltar | 3793 | 47 | 2914 | 832 | 36.1408 | -5.3536 | 2021-01-20 05:21:54 | Gibraltar, United Kingdom | ||
| 325855 | 325855 | 2021-01-19 | United Kingdom | Isle of Man | 432 | 25 | 354 | 53 | 54.2361 | -4.5481 | 2021-01-20 05:21:54 | Isle of Man, United Kingdom | ||
| 325856 | 325856 | 2021-01-19 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-20 05:21:54 | Montserrat, United Kingdom | ||
| 325857 | 325857 | 2021-01-19 | United Kingdom | Northern Ireland | 96714 | 1649 | 0 | 95065 | 54.7877 | -6.4923 | 2021-01-20 05:21:54 | Northern Ireland, United Kingdom | ||
| 325858 | 325858 | 2021-01-19 | United Kingdom | Scotland | 164927 | 5376 | 0 | 159551 | 56.4907 | -4.2026 | 2021-01-20 05:21:54 | Scotland, United Kingdom | ||
| 325859 | 325859 | 2021-01-19 | United Kingdom | Turks and Caicos Islands | 1105 | 7 | 902 | 196 | 21.694000000000006 | -71.7979 | 2021-01-20 05:21:54 | Turks and Caicos Islands, United Kingdom | ||
| 325860 | 325860 | 2021-01-19 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-01-20 05:21:54 | Unknown, United Kingdom | ||||
| 325861 | 325861 | 2021-01-19 | United Kingdom | Wales | 182599 | 4302 | 0 | 178297 | 52.1307 | -3.7837 | 2021-01-20 05:21:54 | Wales, United Kingdom | ||
| 577833 | 577833 | 2021-01-18 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-19 05:22:15 | Anguilla, United Kingdom | ||
| 577834 | 577834 | 2021-01-18 | United Kingdom | Bermuda | 683 | 12 | 598 | 73 | 32.3078 | -64.7505 | 2021-01-19 05:22:15 | Bermuda, United Kingdom | ||
| 577835 | 577835 | 2021-01-18 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-19 05:22:15 | British Virgin Islands, United Kingdom | ||
| 577836 | 577836 | 2021-01-18 | United Kingdom | Cayman Islands | 380 | 2 | 330 | 48 | 19.3133 | -81.2546 | 2021-01-19 05:22:15 | Cayman Islands, United Kingdom | ||
| 577837 | 577837 | 2021-01-18 | United Kingdom | Channel Islands | 3370 | 78 | 3073 | 219 | 49.3723 | -2.3644 | 2021-01-19 05:22:15 | Channel Islands, United Kingdom | ||
| 577838 | 577838 | 2021-01-18 | United Kingdom | England | 2992238 | 78636 | 0 | 2913602 | 52.3555 | -1.1743 | 2021-01-19 05:22:15 | England, United Kingdom | ||
| 577839 | 577839 | 2021-01-18 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-19 05:22:15 | Falkland Islands (Malvinas), United Kingdom | ||
| 577840 | 577840 | 2021-01-18 | United Kingdom | Gibraltar | 3712 | 45 | 2840 | 827 | 36.1408 | -5.3536 | 2021-01-19 05:22:15 | Gibraltar, United Kingdom | ||
| 577841 | 577841 | 2021-01-18 | United Kingdom | Isle of Man | 432 | 25 | 354 | 53 | 54.2361 | -4.5481 | 2021-01-19 05:22:15 | Isle of Man, United Kingdom | ||
| 577842 | 577842 | 2021-01-18 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-19 05:22:15 | Montserrat, United Kingdom | ||
| 577843 | 577843 | 2021-01-18 | United Kingdom | Northern Ireland | 96001 | 1625 | 0 | 94376 | 54.7877 | -6.4923 | 2021-01-19 05:22:15 | Northern Ireland, United Kingdom | ||
| 577844 | 577844 | 2021-01-18 | United Kingdom | Scotland | 163762 | 5305 | 0 | 158457 | 56.4907 | -4.2026 | 2021-01-19 05:22:15 | Scotland, United Kingdom | ||
| 577845 | 577845 | 2021-01-18 | United Kingdom | Turks and Caicos Islands | 1105 | 7 | 902 | 196 | 21.694000000000006 | -71.7979 | 2021-01-19 05:22:15 | Turks and Caicos Islands, United Kingdom | ||
| 577846 | 577846 | 2021-01-18 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-01-19 05:22:15 | Unknown, United Kingdom | ||||
| 577847 | 577847 | 2021-01-18 | United Kingdom | Wales | 181493 | 4294 | 0 | 177199 | 52.1307 | -3.7837 | 2021-01-19 05:22:15 | Wales, United Kingdom | ||
| 542396 | 542396 | 2021-01-17 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-18 05:22:34 | Anguilla, United Kingdom | ||
| 542397 | 542397 | 2021-01-17 | United Kingdom | Bermuda | 670 | 12 | 583 | 75 | 32.3078 | -64.7505 | 2021-01-18 05:22:34 | Bermuda, United Kingdom | ||
| 542398 | 542398 | 2021-01-17 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-18 05:22:34 | British Virgin Islands, United Kingdom | ||
| 542399 | 542399 | 2021-01-17 | United Kingdom | Cayman Islands | 374 | 2 | 328 | 44 | 19.3133 | -81.2546 | 2021-01-18 05:22:34 | Cayman Islands, United Kingdom | ||
| 542400 | 542400 | 2021-01-17 | United Kingdom | Channel Islands | 3363 | 78 | 3049 | 236 | 49.3723 | -2.3644 | 2021-01-18 05:22:34 | Channel Islands, United Kingdom | ||
| 542401 | 542401 | 2021-01-17 | United Kingdom | England | 2958104 | 78076 | 0 | 2880028 | 52.3555 | -1.1743 | 2021-01-18 05:22:34 | England, United Kingdom | ||
| 542402 | 542402 | 2021-01-17 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-18 05:22:34 | Falkland Islands (Malvinas), United Kingdom | ||
| 542403 | 542403 | 2021-01-17 | United Kingdom | Gibraltar | 3670 | 43 | 2689 | 938 | 36.1408 | -5.3536 | 2021-01-18 05:22:34 | Gibraltar, United Kingdom | ||
| 542404 | 542404 | 2021-01-17 | United Kingdom | Isle of Man | 428 | 25 | 354 | 49 | 54.2361 | -4.5481 | 2021-01-18 05:22:34 | Isle of Man, United Kingdom | ||
| 542405 | 542405 | 2021-01-17 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-18 05:22:34 | Montserrat, United Kingdom | ||
| 542406 | 542406 | 2021-01-17 | United Kingdom | Northern Ireland | 95361 | 1606 | 0 | 93755 | 54.7877 | -6.4923 | 2021-01-18 05:22:34 | Northern Ireland, United Kingdom | ||
| 542407 | 542407 | 2021-01-17 | United Kingdom | Scotland | 162333 | 5305 | 0 | 157028 | 56.4907 | -4.2026 | 2021-01-18 05:22:34 | Scotland, United Kingdom | ||
| 542408 | 542408 | 2021-01-17 | United Kingdom | Turks and Caicos Islands | 1102 | 6 | 890 | 206 | 21.694000000000006 | -71.7979 | 2021-01-18 05:22:34 | Turks and Caicos Islands, United Kingdom | ||
| 542409 | 542409 | 2021-01-17 | United Kingdom | Unknown | 0 | 0 | 0 | 0 | 2021-01-18 05:22:34 | Unknown, United Kingdom | ||||
| 542410 | 542410 | 2021-01-17 | United Kingdom | Wales | 180161 | 4274 | 0 | 175887 | 52.1307 | -3.7837 | 2021-01-18 05:22:34 | Wales, United Kingdom | ||
| 623184 | 623184 | 2021-01-16 | United Kingdom | Anguilla | 15 | 0 | 15 | 0 | 18.2206 | -63.0686 | 2021-01-17 05:22:17 | Anguilla, United Kingdom | ||
| 623185 | 623185 | 2021-01-16 | United Kingdom | Bermuda | 670 | 12 | 583 | 75 | 32.3078 | -64.7505 | 2021-01-17 05:22:17 | Bermuda, United Kingdom | ||
| 623186 | 623186 | 2021-01-16 | United Kingdom | British Virgin Islands | 114 | 1 | 95 | 18 | 18.4207 | -64.64 | 2021-01-17 05:22:17 | British Virgin Islands, United Kingdom | ||
| 623187 | 623187 | 2021-01-16 | United Kingdom | Cayman Islands | 374 | 2 | 328 | 44 | 19.3133 | -81.2546 | 2021-01-17 05:22:17 | Cayman Islands, United Kingdom | ||
| 623188 | 623188 | 2021-01-16 | United Kingdom | Channel Islands | 3356 | 76 | 2997 | 283 | 49.3723 | -2.3644 | 2021-01-17 05:22:17 | Channel Islands, United Kingdom | ||
| 623189 | 623189 | 2021-01-16 | United Kingdom | England | 2922841 | 77478 | 0 | 2845363 | 52.3555 | -1.1743 | 2021-01-17 05:22:17 | England, United Kingdom | ||
| 623190 | 623190 | 2021-01-16 | United Kingdom | Falkland Islands (Malvinas) | 32 | 0 | 27 | 5 | -51.7963 | -59.5236 | 2021-01-17 05:22:17 | Falkland Islands (Malvinas), United Kingdom | ||
| 623191 | 623191 | 2021-01-16 | United Kingdom | Gibraltar | 3637 | 34 | 2588 | 1015 | 36.1408 | -5.3536 | 2021-01-17 05:22:17 | Gibraltar, United Kingdom | ||
| 623192 | 623192 | 2021-01-16 | United Kingdom | Isle of Man | 419 | 25 | 354 | 40 | 54.2361 | -4.5481 | 2021-01-17 05:22:17 | Isle of Man, United Kingdom | ||
| 623193 | 623193 | 2021-01-16 | United Kingdom | Montserrat | 13 | 1 | 12 | 0 | 16.742498 | -62.187366 | 2021-01-17 05:22:17 | Montserrat, 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] INTEGER,
[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]);