johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Pitcairn Islands" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 1
- Pitcairn Islands · 973 ✖
country_or_region 1
- United Kingdom 973
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
367889 | 367889 | 2020-07-16 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-07-17 04:34:50 | Pitcairn Islands, United Kingdom | ||
371866 | 371866 | 2020-08-08 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-08-09 04:34:54 | Pitcairn Islands, United Kingdom | ||
375867 | 375867 | 2022-09-13 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-14 04:20:44 | Pitcairn Islands, United Kingdom | |||
379879 | 379879 | 2020-11-06 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-11-07 05:24:52 | Pitcairn Islands, United Kingdom | ||
383893 | 383893 | 2021-04-30 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-05-01 04:20:47 | Pitcairn Islands, United Kingdom | ||
387894 | 387894 | 2022-09-23 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-24 04:21:40 | Pitcairn Islands, United Kingdom | |||
391923 | 391923 | 2021-04-04 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-04-05 04:20:35 | Pitcairn Islands, United Kingdom | ||
395934 | 395934 | 2020-11-27 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-11-28 05:25:50 | Pitcairn Islands, United Kingdom | ||
399935 | 399935 | 2022-10-07 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-08 04:22:56 | Pitcairn Islands, United Kingdom | |||
403964 | 403964 | 2021-06-29 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-06-30 04:21:41 | Pitcairn Islands, United Kingdom | ||
407980 | 407980 | 2021-12-07 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-12-08 04:22:46 | Pitcairn Islands, United Kingdom | ||
411994 | 411994 | 2021-07-28 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-07-29 04:21:33 | Pitcairn Islands, United Kingdom | ||
415830 | 415830 | 2020-07-05 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-07-06 04:33:57 | Pitcairn Islands, United Kingdom | ||
415914 | 415914 | 2020-01-26 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 1/26/20 16:00 | ||||
419005 | 419005 | 2020-04-18 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-04-18 22:32:47 | Pitcairn Islands, United Kingdom | ||
423021 | 423021 | 2022-09-18 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-09-19 04:21:49 | Pitcairn Islands, United Kingdom | ||
427037 | 427037 | 2021-10-10 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-11 04:21:31 | Pitcairn Islands, United Kingdom | ||
431027 | 431027 | 2020-09-07 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-08 04:28:25 | Pitcairn Islands, United Kingdom | ||
435028 | 435028 | 2022-11-03 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-04 04:22:11 | Pitcairn Islands, United Kingdom | |||
439057 | 439057 | 2021-01-21 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-01-22 05:22:10 | Pitcairn Islands, United Kingdom | ||
443025 | 443025 | 2020-07-26 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-07-27 04:35:02 | Pitcairn Islands, United Kingdom | ||
447041 | 447041 | 2021-10-20 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-21 04:21:18 | Pitcairn Islands, United Kingdom | ||
451057 | 451057 | 2021-11-17 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-18 04:21:33 | Pitcairn Islands, United Kingdom | ||
455058 | 455058 | 2022-12-21 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-22 04:20:56 | Pitcairn Islands, United Kingdom | |||
459050 | 459050 | 2020-08-07 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-08-08 04:34:53 | Pitcairn Islands, United Kingdom | ||
463066 | 463066 | 2022-02-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-02-03 04:21:21 | Pitcairn Islands, United Kingdom | ||
467082 | 467082 | 2022-05-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-05-03 04:21:00 | Pitcairn Islands, United Kingdom | ||
471098 | 471098 | 2021-10-07 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-08 04:21:25 | Pitcairn Islands, United Kingdom | ||
475112 | 475112 | 2021-02-19 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-20 05:22:51 | Pitcairn Islands, United Kingdom | ||
479128 | 479128 | 2022-06-26 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-06-27 04:21:00 | Pitcairn Islands, United Kingdom | ||
479260 | 479260 | 2020-02-25 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-02-25T15:23:04 | ||||
483261 | 483261 | 2022-11-08 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-09 04:21:22 | Pitcairn Islands, United Kingdom | |||
487290 | 487290 | 2021-07-19 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-07-20 04:21:48 | Pitcairn Islands, United Kingdom | ||
491291 | 491291 | 2022-11-25 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-26 04:21:11 | Pitcairn Islands, United Kingdom | |||
495322 | 495322 | 2021-10-14 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-15 04:21:26 | Pitcairn Islands, United Kingdom | ||
499338 | 499338 | 2021-11-06 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-07 04:21:53 | Pitcairn Islands, United Kingdom | ||
503354 | 503354 | 2022-04-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-04-03 04:20:48 | Pitcairn Islands, United Kingdom | ||
507355 | 507355 | 2022-12-17 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-18 04:21:03 | Pitcairn Islands, United Kingdom | |||
511384 | 511384 | 2021-08-14 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-08-15 04:21:41 | Pitcairn Islands, United Kingdom | ||
515398 | 515398 | 2021-08-19 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-08-20 04:21:33 | Pitcairn Islands, United Kingdom | ||
519399 | 519399 | 2022-10-15 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-16 04:22:39 | Pitcairn Islands, United Kingdom | |||
522543 | 522543 | 2020-04-21 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-04-21 23:30:50 | Pitcairn Islands, United Kingdom | ||
526557 | 526557 | 2021-06-09 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-06-10 04:23:17 | Pitcairn Islands, United Kingdom | ||
530392 | 530392 | 2020-07-04 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-07-05 04:33:46 | Pitcairn Islands, United Kingdom | ||
534406 | 534406 | 2021-02-22 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-23 05:23:41 | Pitcairn Islands, United Kingdom | ||
538422 | 538422 | 2021-10-27 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-28 04:22:08 | Pitcairn Islands, United Kingdom | ||
542423 | 542423 | 2022-10-26 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-10-27 04:22:01 | Pitcairn Islands, United Kingdom | |||
546439 | 546439 | 2022-12-15 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-16 04:21:01 | Pitcairn Islands, United Kingdom | |||
550444 | 550444 | 2020-09-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-13 04:30:52 | Pitcairn Islands, United Kingdom | ||
554460 | 554460 | 2021-12-08 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-12-09 04:22:49 | Pitcairn Islands, United Kingdom | ||
558476 | 558476 | 2022-01-16 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-01-17 04:21:08 | Pitcairn Islands, United Kingdom | ||
562492 | 562492 | 2022-06-16 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-06-17 04:20:56 | Pitcairn Islands, United Kingdom | ||
562653 | 562653 | 2020-03-01 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-01T10:13:19 | ||||
566667 | 566667 | 2021-06-22 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-06-23 04:21:46 | Pitcairn Islands, United Kingdom | ||
566774 | 566774 | 2020-02-06 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-02-06T23:23:02 | ||||
570790 | 570790 | 2021-10-29 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-30 04:22:03 | Pitcairn Islands, United Kingdom | ||
574502 | 574502 | 2020-06-06 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-06-07 03:53:30 | Pitcairn Islands, United Kingdom | ||
578518 | 578518 | 2022-02-25 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-02-26 04:21:12 | Pitcairn Islands, United Kingdom | ||
582532 | 582532 | 2021-07-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-07-14 04:21:35 | Pitcairn Islands, United Kingdom | ||
586513 | 586513 | 2020-08-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-08-14 04:51:19 | Pitcairn Islands, United Kingdom | ||
589314 | 589314 | 2020-04-05 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-04-05 23:06:45 | Pitcairn Islands, United Kingdom | ||
593328 | 593328 | 2021-08-08 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-08-09 04:21:24 | Pitcairn Islands, United Kingdom | ||
597344 | 597344 | 2022-07-01 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-07-02 04:21:16 | Pitcairn Islands, United Kingdom | ||
601360 | 601360 | 2021-10-19 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-20 04:21:00 | Pitcairn Islands, United Kingdom | ||
605375 | 605375 | 2021-09-23 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-09-24 04:21:44 | Pitcairn Islands, United Kingdom | ||
609389 | 609389 | 2021-04-09 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-04-10 04:20:59 | Pitcairn Islands, United Kingdom | ||
613375 | 613375 | 2020-08-29 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-08-30 04:28:22 | Pitcairn Islands, United Kingdom | ||
617389 | 617389 | 2021-02-08 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-02-09 05:23:30 | Pitcairn Islands, United Kingdom | ||
617532 | 617532 | 2020-02-27 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-02-27T12:13:14 | ||||
621533 | 621533 | 2022-11-05 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-06 04:21:24 | Pitcairn Islands, United Kingdom | |||
625564 | 625564 | 2022-05-22 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-05-26 04:20:50 | Pitcairn Islands, United Kingdom | ||
629578 | 629578 | 2021-07-10 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-07-11 04:21:43 | Pitcairn Islands, United Kingdom | ||
633594 | 633594 | 2022-07-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-07-13 04:20:58 | Pitcairn Islands, United Kingdom | ||
637610 | 637610 | 2021-10-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-14 04:21:29 | Pitcairn Islands, United Kingdom | ||
641624 | 641624 | 2021-03-31 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-04-01 04:27:05 | Pitcairn Islands, United Kingdom | ||
645638 | 645638 | 2021-09-07 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-09-08 04:21:31 | Pitcairn Islands, United Kingdom | ||
649652 | 649652 | 2021-05-05 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-05-06 04:20:38 | Pitcairn Islands, United Kingdom | ||
653666 | 653666 | 2021-08-09 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-08-10 04:21:27 | Pitcairn Islands, United Kingdom | ||
657682 | 657682 | 2021-10-22 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-23 04:21:32 | Pitcairn Islands, United Kingdom | ||
657984 | 657984 | 2020-03-09 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-09T14:33:03 | ||||
662000 | 662000 | 2022-05-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-05-14 04:20:48 | Pitcairn Islands, United Kingdom | ||
665979 | 665979 | 2020-08-11 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-08-12 04:27:29 | Pitcairn Islands, United Kingdom | ||
669969 | 669969 | 2020-09-16 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-09-17 04:22:00 | Pitcairn Islands, United Kingdom | ||
673985 | 673985 | 2022-07-21 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-07-22 04:21:15 | Pitcairn Islands, United Kingdom | ||
678001 | 678001 | 2022-07-30 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-07-31 04:21:02 | Pitcairn Islands, United Kingdom | ||
682011 | 682011 | 2020-11-23 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-11-24 05:27:31 | Pitcairn Islands, United Kingdom | ||
686027 | 686027 | 2021-10-24 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-25 04:22:31 | Pitcairn Islands, United Kingdom | ||
690043 | 690043 | 2021-11-13 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-14 04:21:31 | Pitcairn Islands, United Kingdom | ||
694044 | 694044 | 2022-12-23 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-24 04:21:02 | Pitcairn Islands, United Kingdom | |||
698075 | 698075 | 2022-03-17 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2022-03-18 04:20:55 | Pitcairn Islands, United Kingdom | ||
702091 | 702091 | 2021-11-04 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-05 04:21:54 | Pitcairn Islands, United Kingdom | ||
706105 | 706105 | 2021-03-16 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-03-17 05:25:07 | Pitcairn Islands, United Kingdom | ||
710120 | 710120 | 2021-09-29 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-09-30 04:21:20 | Pitcairn Islands, United Kingdom | ||
714121 | 714121 | 2022-11-01 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-11-02 04:22:09 | Pitcairn Islands, United Kingdom | |||
718152 | 718152 | 2021-11-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-13 04:21:38 | Pitcairn Islands, United Kingdom | ||
722153 | 722153 | 2022-12-04 | United Kingdom | Pitcairn Islands | 4 | 0 | 0 | -24.3768 | -128.3242 | 2022-12-05 04:20:58 | Pitcairn Islands, United Kingdom | |||
726184 | 726184 | 2021-11-20 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-11-21 04:22:13 | Pitcairn Islands, United Kingdom | ||
730198 | 730198 | 2021-05-22 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-05-23 04:20:51 | Pitcairn Islands, United Kingdom | ||
734214 | 734214 | 2021-12-27 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-12-28 04:21:47 | Pitcairn Islands, United Kingdom | ||
737989 | 737989 | 2020-06-12 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-06-13 03:33:14 | 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]);