johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where country_or_region = "Sweden" and province_or_state = "Jamtland Harjedalen" sorted by fips
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
427643 | 427643 | 2020-09-07 | Sweden | Jamtland Harjedalen | 1210 | 64 | 0 | 1146 | 63.1712 | 14.9592 | 2020-09-08 04:28:25 | Jamtland Harjedalen, Sweden | ||
431677 | 431677 | 2022-11-03 | Sweden | Jamtland Harjedalen | 34388 | 205 | 0 | 63.1712 | 14.9592 | 2022-11-04 04:22:11 | Jamtland Harjedalen, Sweden | |||
435667 | 435667 | 2021-01-21 | Sweden | Jamtland Harjedalen | 5535 | 99 | 0 | 5436 | 63.1712 | 14.9592 | 2021-01-22 05:22:10 | Jamtland Harjedalen, Sweden | ||
442489 | 442489 | 2020-07-26 | Sweden | Jamtland Harjedalen | 1113 | 59 | 0 | 1054 | 63.1712 | 14.9592 | 2020-07-27 04:35:02 | Jamtland Harjedalen, Sweden | ||
443671 | 443671 | 2021-10-20 | Sweden | Jamtland Harjedalen | 13182 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-21 04:21:18 | Jamtland Harjedalen, Sweden | |||
447687 | 447687 | 2021-11-17 | Sweden | Jamtland Harjedalen | 13317 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-18 04:21:33 | Jamtland Harjedalen, Sweden | |||
451707 | 451707 | 2022-12-21 | Sweden | Jamtland Harjedalen | 34818 | 210 | 0 | 63.1712 | 14.9592 | 2022-12-22 04:20:56 | Jamtland Harjedalen, Sweden | |||
458514 | 458514 | 2020-08-07 | Sweden | Jamtland Harjedalen | 1153 | 59 | 0 | 1094 | 63.1712 | 14.9592 | 2020-08-08 04:34:53 | Jamtland Harjedalen, Sweden | ||
459696 | 459696 | 2022-02-02 | Sweden | Jamtland Harjedalen | 29009 | 145 | 0 | 63.1712 | 14.9592 | 2022-02-03 04:21:21 | Jamtland Harjedalen, Sweden | |||
463713 | 463713 | 2022-05-02 | Sweden | Jamtland Harjedalen | 32732 | 168 | 0 | 63.1712 | 14.9592 | 2022-05-03 04:21:00 | Jamtland Harjedalen, Sweden | |||
467728 | 467728 | 2021-10-07 | Sweden | Jamtland Harjedalen | 13138 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-08 04:21:25 | Jamtland Harjedalen, Sweden | |||
471723 | 471723 | 2021-02-19 | Sweden | Jamtland Harjedalen | 6485 | 113 | 0 | 6372 | 63.1712 | 14.9592 | 2021-02-20 05:22:51 | Jamtland Harjedalen, Sweden | ||
475760 | 475760 | 2022-06-26 | Sweden | Jamtland Harjedalen | 32947 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-27 04:21:00 | Jamtland Harjedalen, Sweden | |||
479910 | 479910 | 2022-11-08 | Sweden | Jamtland Harjedalen | 34388 | 205 | 0 | 63.1712 | 14.9592 | 2022-11-09 04:21:22 | Jamtland Harjedalen, Sweden | |||
483905 | 483905 | 2021-07-19 | Sweden | Jamtland Harjedalen | 12557 | 121 | 0 | 12436 | 63.1712 | 14.9592 | 2021-07-20 04:21:48 | Jamtland Harjedalen, Sweden | ||
487940 | 487940 | 2022-11-25 | Sweden | Jamtland Harjedalen | 34521 | 206 | 0 | 63.1712 | 14.9592 | 2022-11-26 04:21:11 | Jamtland Harjedalen, Sweden | |||
491952 | 491952 | 2021-10-14 | Sweden | Jamtland Harjedalen | 13160 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-15 04:21:26 | Jamtland Harjedalen, Sweden | |||
495968 | 495968 | 2021-11-06 | Sweden | Jamtland Harjedalen | 13269 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-07 04:21:53 | Jamtland Harjedalen, Sweden | |||
499985 | 499985 | 2022-04-02 | Sweden | Jamtland Harjedalen | 32568 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-03 04:20:48 | Jamtland Harjedalen, Sweden | |||
504004 | 504004 | 2022-12-17 | Sweden | Jamtland Harjedalen | 34818 | 210 | 0 | 63.1712 | 14.9592 | 2022-12-18 04:21:03 | Jamtland Harjedalen, Sweden | |||
507999 | 507999 | 2021-08-14 | Sweden | Jamtland Harjedalen | 12713 | 121 | 0 | 63.1712 | 14.9592 | 2021-08-15 04:21:41 | Jamtland Harjedalen, Sweden | |||
512013 | 512013 | 2021-08-19 | Sweden | Jamtland Harjedalen | 12754 | 121 | 0 | 63.1712 | 14.9592 | 2021-08-20 04:21:33 | Jamtland Harjedalen, Sweden | |||
516048 | 516048 | 2022-10-15 | Sweden | Jamtland Harjedalen | 34232 | 197 | 0 | 63.1712 | 14.9592 | 2022-10-16 04:22:39 | Jamtland Harjedalen, Sweden | |||
523169 | 523169 | 2021-06-09 | Sweden | Jamtland Harjedalen | 12480 | 121 | 0 | 12359 | 63.1712 | 14.9592 | 2021-06-10 04:23:17 | Jamtland Harjedalen, Sweden | ||
529868 | 529868 | 2020-07-04 | Sweden | Jamtland Harjedalen | 1059 | 54 | 0 | 1005 | 63.1712 | 14.9592 | 2020-07-05 04:33:46 | Jamtland Harjedalen, Sweden | ||
531017 | 531017 | 2021-02-22 | Sweden | Jamtland Harjedalen | 6485 | 113 | 0 | 6372 | 63.1712 | 14.9592 | 2021-02-23 05:23:41 | Jamtland Harjedalen, Sweden | ||
535052 | 535052 | 2021-10-27 | Sweden | Jamtland Harjedalen | 13229 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-28 04:22:08 | Jamtland Harjedalen, Sweden | |||
539072 | 539072 | 2022-10-26 | Sweden | Jamtland Harjedalen | 34267 | 197 | 0 | 63.1712 | 14.9592 | 2022-10-27 04:22:01 | Jamtland Harjedalen, Sweden | |||
543088 | 543088 | 2022-12-15 | Sweden | Jamtland Harjedalen | 34818 | 210 | 0 | 63.1712 | 14.9592 | 2022-12-16 04:21:01 | Jamtland Harjedalen, Sweden | |||
547060 | 547060 | 2020-09-12 | Sweden | Jamtland Harjedalen | 1218 | 64 | 0 | 1154 | 63.1712 | 14.9592 | 2020-09-13 04:30:52 | Jamtland Harjedalen, Sweden | ||
551090 | 551090 | 2021-12-08 | Sweden | Jamtland Harjedalen | 13578 | 129 | 0 | 63.1712 | 14.9592 | 2021-12-09 04:22:49 | Jamtland Harjedalen, Sweden | |||
555106 | 555106 | 2022-01-16 | Sweden | Jamtland Harjedalen | 19636 | 130 | 0 | 63.1712 | 14.9592 | 2022-01-17 04:21:08 | Jamtland Harjedalen, Sweden | |||
559124 | 559124 | 2022-06-16 | Sweden | Jamtland Harjedalen | 32904 | 176 | 0 | 63.1712 | 14.9592 | 2022-06-17 04:20:56 | Jamtland Harjedalen, Sweden | |||
563281 | 563281 | 2021-06-22 | Sweden | Jamtland Harjedalen | 12508 | 121 | 0 | 12387 | 63.1712 | 14.9592 | 2021-06-23 04:21:46 | Jamtland Harjedalen, Sweden | ||
567420 | 567420 | 2021-10-29 | Sweden | Jamtland Harjedalen | 13246 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-30 04:22:03 | Jamtland Harjedalen, Sweden | |||
573999 | 573999 | 2020-06-06 | Sweden | Jamtland Harjedalen | 792 | 33 | 0 | 759 | 63.1712 | 14.9592 | 2020-06-07 03:53:30 | Jamtland Harjedalen, Sweden | ||
575149 | 575149 | 2022-02-25 | Sweden | Jamtland Harjedalen | 31843 | 146 | 0 | 63.1712 | 14.9592 | 2022-02-26 04:21:12 | Jamtland Harjedalen, Sweden | |||
579147 | 579147 | 2021-07-13 | Sweden | Jamtland Harjedalen | 12554 | 121 | 0 | 12433 | 63.1712 | 14.9592 | 2021-07-14 04:21:35 | Jamtland Harjedalen, Sweden | ||
583138 | 583138 | 2020-08-13 | Sweden | Jamtland Harjedalen | 1160 | 60 | 0 | 1100 | 63.1712 | 14.9592 | 2020-08-14 04:51:19 | Jamtland Harjedalen, Sweden | ||
589943 | 589943 | 2021-08-08 | Sweden | Jamtland Harjedalen | 12651 | 121 | 0 | 63.1712 | 14.9592 | 2021-08-09 04:21:24 | Jamtland Harjedalen, Sweden | |||
593976 | 593976 | 2022-07-01 | Sweden | Jamtland Harjedalen | 32999 | 180 | 0 | 63.1712 | 14.9592 | 2022-07-02 04:21:16 | Jamtland Harjedalen, Sweden | |||
597990 | 597990 | 2021-10-19 | Sweden | Jamtland Harjedalen | 13177 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-20 04:21:00 | Jamtland Harjedalen, Sweden | |||
602006 | 602006 | 2021-09-23 | Sweden | Jamtland Harjedalen | 13070 | 126 | 0 | 63.1712 | 14.9592 | 2021-09-24 04:21:44 | Jamtland Harjedalen, Sweden | |||
606000 | 606000 | 2021-04-09 | Sweden | Jamtland Harjedalen | 9223 | 118 | 0 | 9105 | 63.1712 | 14.9592 | 2021-04-10 04:20:59 | Jamtland Harjedalen, Sweden | ||
609995 | 609995 | 2020-08-29 | Sweden | Jamtland Harjedalen | 1178 | 64 | 0 | 1114 | 63.1712 | 14.9592 | 2020-08-30 04:28:22 | Jamtland Harjedalen, Sweden | ||
613999 | 613999 | 2021-02-08 | Sweden | Jamtland Harjedalen | 6021 | 100 | 0 | 5921 | 63.1712 | 14.9592 | 2021-02-09 05:23:30 | Jamtland Harjedalen, Sweden | ||
618182 | 618182 | 2022-11-05 | Sweden | Jamtland Harjedalen | 34388 | 205 | 0 | 63.1712 | 14.9592 | 2022-11-06 04:21:24 | Jamtland Harjedalen, Sweden | |||
622196 | 622196 | 2022-05-22 | Sweden | Jamtland Harjedalen | 32847 | 176 | 0 | 63.1712 | 14.9592 | 2022-05-26 04:20:50 | Jamtland Harjedalen, Sweden | |||
626193 | 626193 | 2021-07-10 | Sweden | Jamtland Harjedalen | 12548 | 121 | 0 | 12427 | 63.1712 | 14.9592 | 2021-07-11 04:21:43 | Jamtland Harjedalen, Sweden | ||
630226 | 630226 | 2022-07-12 | Sweden | Jamtland Harjedalen | 33055 | 180 | 0 | 63.1712 | 14.9592 | 2022-07-13 04:20:58 | Jamtland Harjedalen, Sweden | |||
634240 | 634240 | 2021-10-13 | Sweden | Jamtland Harjedalen | 13156 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-14 04:21:29 | Jamtland Harjedalen, Sweden | |||
638235 | 638235 | 2021-03-31 | Sweden | Jamtland Harjedalen | 8519 | 118 | 0 | 8401 | 63.1712 | 14.9592 | 2021-04-01 04:27:05 | Jamtland Harjedalen, Sweden | ||
642253 | 642253 | 2021-09-07 | Sweden | Jamtland Harjedalen | 12931 | 126 | 0 | 63.1712 | 14.9592 | 2021-09-08 04:21:31 | Jamtland Harjedalen, Sweden | |||
646263 | 646263 | 2021-05-05 | Sweden | Jamtland Harjedalen | 11214 | 120 | 0 | 11094 | 63.1712 | 14.9592 | 2021-05-06 04:20:38 | Jamtland Harjedalen, Sweden | ||
650281 | 650281 | 2021-08-09 | Sweden | Jamtland Harjedalen | 12651 | 121 | 0 | 63.1712 | 14.9592 | 2021-08-10 04:21:27 | Jamtland Harjedalen, Sweden | |||
654312 | 654312 | 2021-10-22 | Sweden | Jamtland Harjedalen | 13198 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-23 04:21:32 | Jamtland Harjedalen, Sweden | |||
658631 | 658631 | 2022-05-13 | Sweden | Jamtland Harjedalen | 32805 | 175 | 0 | 63.1712 | 14.9592 | 2022-05-14 04:20:48 | Jamtland Harjedalen, Sweden | |||
662606 | 662606 | 2020-08-11 | Sweden | Jamtland Harjedalen | 1153 | 60 | 0 | 1093 | 63.1712 | 14.9592 | 2020-08-12 04:27:29 | Jamtland Harjedalen, Sweden | ||
666585 | 666585 | 2020-09-16 | Sweden | Jamtland Harjedalen | 1220 | 64 | 0 | 1156 | 63.1712 | 14.9592 | 2020-09-17 04:22:00 | Jamtland Harjedalen, Sweden | ||
670617 | 670617 | 2022-07-21 | Sweden | Jamtland Harjedalen | 33191 | 180 | 0 | 63.1712 | 14.9592 | 2022-07-22 04:21:15 | Jamtland Harjedalen, Sweden | |||
674633 | 674633 | 2022-07-30 | Sweden | Jamtland Harjedalen | 33288 | 180 | 0 | 63.1712 | 14.9592 | 2022-07-31 04:21:02 | Jamtland Harjedalen, Sweden | |||
678622 | 678622 | 2020-11-23 | Sweden | Jamtland Harjedalen | 2342 | 67 | 0 | 2275 | 63.1712 | 14.9592 | 2020-11-24 05:27:31 | Jamtland Harjedalen, Sweden | ||
682657 | 682657 | 2021-10-24 | Sweden | Jamtland Harjedalen | 13198 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-25 04:22:31 | Jamtland Harjedalen, Sweden | |||
686673 | 686673 | 2021-11-13 | Sweden | Jamtland Harjedalen | 13290 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-14 04:21:31 | Jamtland Harjedalen, Sweden | |||
690693 | 690693 | 2022-12-23 | Sweden | Jamtland Harjedalen | 34965 | 210 | 0 | 63.1712 | 14.9592 | 2022-12-24 04:21:02 | Jamtland Harjedalen, Sweden | |||
694706 | 694706 | 2022-03-17 | Sweden | Jamtland Harjedalen | 32385 | 165 | 0 | 63.1712 | 14.9592 | 2022-03-18 04:20:55 | Jamtland Harjedalen, Sweden | |||
698721 | 698721 | 2021-11-04 | Sweden | Jamtland Harjedalen | 13266 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-05 04:21:54 | Jamtland Harjedalen, Sweden | |||
702716 | 702716 | 2021-03-16 | Sweden | Jamtland Harjedalen | 7665 | 117 | 0 | 7548 | 63.1712 | 14.9592 | 2021-03-17 05:25:07 | Jamtland Harjedalen, Sweden | ||
706751 | 706751 | 2021-09-29 | Sweden | Jamtland Harjedalen | 13105 | 126 | 0 | 63.1712 | 14.9592 | 2021-09-30 04:21:20 | Jamtland Harjedalen, Sweden | |||
710770 | 710770 | 2022-11-01 | Sweden | Jamtland Harjedalen | 34347 | 197 | 0 | 63.1712 | 14.9592 | 2022-11-02 04:22:09 | Jamtland Harjedalen, Sweden | |||
714782 | 714782 | 2021-11-12 | Sweden | Jamtland Harjedalen | 13290 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-13 04:21:38 | Jamtland Harjedalen, Sweden | |||
718802 | 718802 | 2022-12-04 | Sweden | Jamtland Harjedalen | 34578 | 206 | 0 | 63.1712 | 14.9592 | 2022-12-05 04:20:58 | Jamtland Harjedalen, Sweden | |||
722814 | 722814 | 2021-11-20 | Sweden | Jamtland Harjedalen | 13329 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-21 04:22:13 | Jamtland Harjedalen, Sweden | |||
726809 | 726809 | 2021-05-22 | Sweden | Jamtland Harjedalen | 12176 | 120 | 0 | 12056 | 63.1712 | 14.9592 | 2021-05-23 04:20:51 | Jamtland Harjedalen, Sweden | ||
730844 | 730844 | 2021-12-27 | Sweden | Jamtland Harjedalen | 14136 | 129 | 0 | 63.1712 | 14.9592 | 2021-12-28 04:21:47 | Jamtland Harjedalen, Sweden | |||
737465 | 737465 | 2020-06-12 | Sweden | Jamtland Harjedalen | 862 | 39 | 0 | 823 | 63.1712 | 14.9592 | 2020-06-13 03:33:14 | Jamtland Harjedalen, Sweden | ||
738611 | 738611 | 2020-12-02 | Sweden | Jamtland Harjedalen | 2928 | 69 | 0 | 2859 | 63.1712 | 14.9592 | 2020-12-03 05:28:22 | Jamtland Harjedalen, Sweden | ||
742625 | 742625 | 2021-02-20 | Sweden | Jamtland Harjedalen | 6485 | 113 | 0 | 6372 | 63.1712 | 14.9592 | 2021-02-21 05:24:33 | Jamtland Harjedalen, Sweden | ||
746661 | 746661 | 2022-04-23 | Sweden | Jamtland Harjedalen | 32691 | 168 | 0 | 63.1712 | 14.9592 | 2022-04-24 04:20:56 | Jamtland Harjedalen, Sweden | |||
753468 | 753468 | 2020-08-01 | Sweden | Jamtland Harjedalen | 1134 | 59 | 0 | 1075 | 63.1712 | 14.9592 | 2020-08-02 04:34:47 | Jamtland Harjedalen, Sweden | ||
754611 | 754611 | 2020-10-28 | Sweden | Jamtland Harjedalen | 1626 | 64 | 0 | 1562 | 63.1712 | 14.9592 | 2020-10-29 04:24:49 | Jamtland Harjedalen, Sweden | ||
758644 | 758644 | 2021-11-26 | Sweden | Jamtland Harjedalen | 13404 | 128 | 0 | 63.1712 | 14.9592 | 2021-11-27 04:22:45 | Jamtland Harjedalen, Sweden | |||
762622 | 762622 | 2020-10-18 | Sweden | Jamtland Harjedalen | 1512 | 64 | 0 | 1448 | 63.1712 | 14.9592 | 2020-10-19 04:24:16 | Jamtland Harjedalen, Sweden | ||
766630 | 766630 | 2020-12-29 | Sweden | Jamtland Harjedalen | 4327 | 70 | 0 | 4257 | 63.1712 | 14.9592 | 2020-12-30 05:22:34 | Jamtland Harjedalen, Sweden | ||
770665 | 770665 | 2021-10-23 | Sweden | Jamtland Harjedalen | 13198 | 128 | 0 | 63.1712 | 14.9592 | 2021-10-24 04:21:22 | Jamtland Harjedalen, Sweden | |||
774658 | 774658 | 2021-01-12 | Sweden | Jamtland Harjedalen | 5137 | 85 | 0 | 5052 | 63.1712 | 14.9592 | 2021-01-13 05:22:15 | Jamtland Harjedalen, Sweden | ||
778676 | 778676 | 2021-07-08 | Sweden | Jamtland Harjedalen | 12540 | 121 | 0 | 12419 | 63.1712 | 14.9592 | 2021-07-09 04:21:21 | Jamtland Harjedalen, Sweden | ||
782707 | 782707 | 2021-12-13 | Sweden | Jamtland Harjedalen | 13663 | 129 | 0 | 63.1712 | 14.9592 | 2021-12-14 04:22:38 | Jamtland Harjedalen, Sweden | |||
786685 | 786685 | 2020-10-15 | Sweden | Jamtland Harjedalen | 1507 | 64 | 0 | 1443 | 63.1712 | 14.9592 | 2020-10-16 04:24:01 | Jamtland Harjedalen, Sweden | ||
790694 | 790694 | 2021-02-04 | Sweden | Jamtland Harjedalen | 5979 | 100 | 0 | 5879 | 63.1712 | 14.9592 | 2021-02-05 05:22:38 | Jamtland Harjedalen, Sweden | ||
794734 | 794734 | 2022-10-24 | Sweden | Jamtland Harjedalen | 34267 | 197 | 0 | 63.1712 | 14.9592 | 2022-10-25 04:21:53 | Jamtland Harjedalen, Sweden | |||
798746 | 798746 | 2021-12-22 | Sweden | Jamtland Harjedalen | 14033 | 129 | 0 | 63.1712 | 14.9592 | 2021-12-23 04:21:21 | Jamtland Harjedalen, Sweden | |||
809891 | 809891 | 2021-09-20 | Sweden | Jamtland Harjedalen | 13043 | 126 | 0 | 63.1712 | 14.9592 | 2021-09-21 04:21:26 | Jamtland Harjedalen, Sweden | |||
813883 | 813883 | 2020-09-05 | Sweden | Jamtland Harjedalen | 1205 | 64 | 0 | 1141 | 63.1712 | 14.9592 | 2020-09-06 04:28:33 | Jamtland Harjedalen, Sweden | ||
817874 | 817874 | 2020-10-09 | Sweden | Jamtland Harjedalen | 1378 | 64 | 0 | 1314 | 63.1712 | 14.9592 | 2020-10-10 04:23:57 | Jamtland Harjedalen, Sweden | ||
821880 | 821880 | 2020-11-19 | Sweden | Jamtland Harjedalen | 2207 | 67 | 0 | 2140 | 63.1712 | 14.9592 | 2020-11-20 05:26:28 | Jamtland Harjedalen, Sweden | ||
825895 | 825895 | 2021-06-06 | Sweden | Jamtland Harjedalen | 12445 | 120 | 0 | 12325 | 63.1712 | 14.9592 | 2021-06-07 04:22:51 | Jamtland Harjedalen, Sweden | ||
829912 | 829912 | 2021-07-09 | Sweden | Jamtland Harjedalen | 12548 | 121 | 0 | 12427 | 63.1712 | 14.9592 | 2021-07-10 04:21:25 | Jamtland Harjedalen, Sweden | ||
833947 | 833947 | 2022-12-02 | Sweden | Jamtland Harjedalen | 34578 | 206 | 0 | 63.1712 | 14.9592 | 2022-12-03 04:21:02 | Jamtland Harjedalen, Sweden | |||
837919 | 837919 | 2020-08-17 | Sweden | Jamtland Harjedalen | 1171 | 60 | 0 | 1111 | 63.1712 | 14.9592 | 2020-08-18 04:27:56 | Jamtland Harjedalen, Sweden |
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]);