johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
653 rows where deaths = 5 and province_or_state = "West Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3752603 | 3752603 | 2021-11-22 | US | West Virginia | Calhoun | 54013 | 1046 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-23 04:22:39 | Calhoun, West Virginia, US | |
1017810 | 1017810 | 2021-11-21 | US | West Virginia | Calhoun | 54013 | 1046 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-22 04:22:20 | Calhoun, West Virginia, US | |
725974 | 725974 | 2021-11-20 | US | West Virginia | Calhoun | 54013 | 1043 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-21 04:22:13 | Calhoun, West Virginia, US | |
165504 | 165504 | 2021-11-19 | US | West Virginia | Calhoun | 54013 | 1038 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-20 04:22:17 | Calhoun, West Virginia, US | |
3292391 | 3292391 | 2021-11-18 | US | West Virginia | Calhoun | 54013 | 1031 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-19 04:21:40 | Calhoun, West Virginia, US | |
450847 | 450847 | 2021-11-17 | US | West Virginia | Calhoun | 54013 | 1016 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-18 04:21:33 | Calhoun, West Virginia, US | |
3346097 | 3346097 | 2021-11-16 | US | West Virginia | Calhoun | 54013 | 1011 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-17 04:21:48 | Calhoun, West Virginia, US | |
2290933 | 2290933 | 2021-11-15 | US | West Virginia | Calhoun | 54013 | 1008 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-16 04:21:10 | Calhoun, West Virginia, US | |
1325707 | 1325707 | 2021-11-14 | US | West Virginia | Calhoun | 54013 | 1003 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-15 04:21:36 | Calhoun, West Virginia, US | |
689833 | 689833 | 2021-11-13 | US | West Virginia | Calhoun | 54013 | 1002 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-14 04:21:31 | Calhoun, West Virginia, US | |
717942 | 717942 | 2021-11-12 | US | West Virginia | Calhoun | 54013 | 998 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-13 04:21:38 | Calhoun, West Virginia, US | |
31892 | 31892 | 2021-11-11 | US | West Virginia | Calhoun | 54013 | 991 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-12 04:22:01 | Calhoun, West Virginia, US | |
2848331 | 2848331 | 2021-11-10 | US | West Virginia | Calhoun | 54013 | 988 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-11 04:21:45 | Calhoun, West Virginia, US | |
90601 | 90601 | 2021-11-09 | US | West Virginia | Calhoun | 54013 | 982 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-10 04:21:38 | Calhoun, West Virginia, US | |
3643029 | 3643029 | 2021-11-08 | US | West Virginia | Calhoun | 54013 | 979 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-09 04:21:36 | Calhoun, West Virginia, US | |
2004137 | 2004137 | 2021-11-07 | US | West Virginia | Calhoun | 54013 | 978 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-08 04:21:43 | Calhoun, West Virginia, US | |
499128 | 499128 | 2021-11-06 | US | West Virginia | Calhoun | 54013 | 978 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-07 04:21:53 | Calhoun, West Virginia, US | |
3124983 | 3124983 | 2021-11-05 | US | West Virginia | Calhoun | 54013 | 972 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-06 04:21:51 | Calhoun, West Virginia, US | |
701881 | 701881 | 2021-11-04 | US | West Virginia | Calhoun | 54013 | 968 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-05 04:21:54 | Calhoun, West Virginia, US | |
279659 | 279659 | 2021-11-03 | US | West Virginia | Calhoun | 54013 | 963 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-04 04:22:20 | Calhoun, West Virginia, US | |
47184 | 47184 | 2021-11-02 | US | West Virginia | Calhoun | 54013 | 959 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-03 06:22:09 | Calhoun, West Virginia, US | |
3514880 | 3514880 | 2021-11-01 | US | West Virginia | Calhoun | 54013 | 960 | 5 | 0 | 38.84315422 | -81.11934872 | 2021-11-02 04:22:03 | Calhoun, West Virginia, US | |
2812268 | 2812268 | 2021-09-16 | US | West Virginia | Wirt | 54105 | 637 | 5 | 0 | 39.02775007 | -81.37473928 | 2021-09-17 04:21:46 | Wirt, West Virginia, US | |
1378012 | 1378012 | 2021-09-15 | US | West Virginia | Wirt | 54105 | 636 | 5 | 0 | 39.02775007 | -81.37473928 | 2021-09-16 04:22:19 | Wirt, West Virginia, US | |
70530 | 70530 | 2021-09-01 | US | West Virginia | Braxton | 54007 | 1250 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-09-02 04:21:15 | Braxton, West Virginia, US | |
2071372 | 2071372 | 2021-08-31 | US | West Virginia | Braxton | 54007 | 1243 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-09-01 04:21:38 | Braxton, West Virginia, US | |
1778826 | 1778826 | 2021-08-30 | US | West Virginia | Braxton | 54007 | 1233 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-08-31 04:21:46 | Braxton, West Virginia, US | |
1935906 | 1935906 | 2021-07-05 | US | West Virginia | Braxton | 54007 | 1018 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-07-06 04:21:32 | Braxton, West Virginia, US | |
1168637 | 1168637 | 2021-07-04 | US | West Virginia | Braxton | 54007 | 1018 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-07-05 04:21:28 | Braxton, West Virginia, US | |
1499071 | 1499071 | 2021-07-03 | US | West Virginia | Braxton | 54007 | 1018 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-07-04 04:21:38 | Braxton, West Virginia, US | |
2075386 | 2075386 | 2021-07-02 | US | West Virginia | Braxton | 54007 | 1018 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-07-03 04:21:37 | Braxton, West Virginia, US | |
2768402 | 2768402 | 2021-07-01 | US | West Virginia | Braxton | 54007 | 1018 | 5 | 0 | 38.70036159 | -80.72011184 | 2021-07-02 04:21:47 | Braxton, West Virginia, US | |
1916684 | 1916684 | 2021-05-20 | US | West Virginia | Gilmer | 54021 | 870 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-21 04:20:43 | Gilmer, West Virginia, US | |
2259205 | 2259205 | 2021-05-19 | US | West Virginia | Gilmer | 54021 | 868 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-20 04:21:05 | Gilmer, West Virginia, US | |
2394243 | 2394243 | 2021-05-18 | US | West Virginia | Gilmer | 54021 | 868 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-19 04:20:42 | Gilmer, West Virginia, US | |
3578068 | 3578068 | 2021-05-17 | US | West Virginia | Gilmer | 54021 | 867 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-18 04:20:33 | Gilmer, West Virginia, US | |
2942798 | 2942798 | 2021-05-16 | US | West Virginia | Gilmer | 54021 | 866 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-17 04:20:34 | Gilmer, West Virginia, US | |
1876428 | 1876428 | 2021-05-15 | US | West Virginia | Gilmer | 54021 | 863 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-16 04:20:49 | Gilmer, West Virginia, US | |
1085397 | 1085397 | 2021-05-14 | US | West Virginia | Gilmer | 54021 | 861 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-15 04:20:58 | Gilmer, West Virginia, US | |
3057663 | 3057663 | 2021-05-13 | US | West Virginia | Gilmer | 54021 | 857 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-14 04:20:41 | Gilmer, West Virginia, US | |
2008133 | 2008133 | 2021-05-12 | US | West Virginia | Gilmer | 54021 | 854 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-13 04:20:51 | Gilmer, West Virginia, US | |
3957964 | 3957964 | 2021-05-11 | US | West Virginia | Gilmer | 54021 | 854 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-12 04:21:29 | Gilmer, West Virginia, US | |
2824243 | 2824243 | 2021-05-10 | US | West Virginia | Gilmer | 54021 | 843 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-11 04:20:41 | Gilmer, West Virginia, US | |
1428575 | 1428575 | 2021-05-09 | US | West Virginia | Gilmer | 54021 | 834 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-10 04:20:38 | Gilmer, West Virginia, US | |
1555443 | 1555443 | 2021-05-08 | US | West Virginia | Gilmer | 54021 | 826 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-09 04:20:35 | Gilmer, West Virginia, US | |
2505501 | 2505501 | 2021-05-07 | US | West Virginia | Gilmer | 54021 | 823 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-08 04:21:04 | Gilmer, West Virginia, US | |
3116957 | 3116957 | 2021-05-06 | US | West Virginia | Gilmer | 54021 | 815 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-07 04:20:40 | Gilmer, West Virginia, US | |
649424 | 649424 | 2021-05-05 | US | West Virginia | Gilmer | 54021 | 802 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-06 04:20:38 | Gilmer, West Virginia, US | |
3679124 | 3679124 | 2021-05-04 | US | West Virginia | Gilmer | 54021 | 802 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-05 04:20:43 | Gilmer, West Virginia, US | |
2764391 | 2764391 | 2021-05-03 | US | West Virginia | Gilmer | 54021 | 798 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-04 04:20:34 | Gilmer, West Virginia, US | |
2454244 | 2454244 | 2021-05-02 | US | West Virginia | Gilmer | 54021 | 791 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-03 04:20:39 | Gilmer, West Virginia, US | |
2828257 | 2828257 | 2021-05-01 | US | West Virginia | Gilmer | 54021 | 783 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-02 04:20:48 | Gilmer, West Virginia, US | |
383665 | 383665 | 2021-04-30 | US | West Virginia | Gilmer | 54021 | 765 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-05-01 04:20:47 | Gilmer, West Virginia, US | |
1639788 | 1639788 | 2021-04-29 | US | West Virginia | Gilmer | 54021 | 762 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-04-30 04:21:03 | Gilmer, West Virginia, US | |
3396867 | 3396867 | 2021-04-28 | US | West Virginia | Gilmer | 54021 | 750 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-04-29 04:20:55 | Gilmer, West Virginia, US | |
3705583 | 3705583 | 2021-04-27 | US | West Virginia | Gilmer | 54021 | 746 | 5 | 0 | 38.9251277 | -80.85952723 | 2021-04-28 04:20:32 | Gilmer, West Virginia, US | |
1841442 | 1841442 | 2021-03-12 | US | West Virginia | Webster | 54101 | 338 | 5 | 0 | 38.49370949 | -80.4202023 | 2021-03-13 05:25:15 | Webster, West Virginia, US | |
355791 | 355791 | 2021-03-11 | US | West Virginia | Pendleton | 54071 | 622 | 5 | 0 | 38.68314479 | -79.35084086 | 2021-03-12 05:26:50 | Pendleton, West Virginia, US | |
3966015 | 3966015 | 2021-03-10 | US | West Virginia | Pendleton | 54071 | 622 | 5 | 0 | 38.68314479 | -79.35084086 | 2021-03-11 05:25:48 | Pendleton, West Virginia, US | |
3667103 | 3667103 | 2021-03-09 | US | West Virginia | Pendleton | 54071 | 621 | 5 | 0 | 38.68314479 | -79.35084086 | 2021-03-10 05:24:35 | Pendleton, West Virginia, US | |
2362962 | 2362962 | 2021-03-08 | US | West Virginia | Pendleton | 54071 | 620 | 5 | 0 | 38.68314479 | -79.35084086 | 2021-03-09 05:28:19 | Pendleton, West Virginia, US | |
58300 | 58300 | 2021-03-07 | US | West Virginia | Pendleton | 54071 | 620 | 5 | 0 | 38.68314479 | -79.35084086 | 2021-03-08 05:24:48 | Pendleton, West Virginia, US | |
3671117 | 3671117 | 2021-03-06 | US | West Virginia | Pendleton | 54071 | 622 | 5 | 0 | 617 | 38.68314479 | -79.35084086 | 2021-03-07 05:21:54 | Pendleton, West Virginia, US |
1619710 | 1619710 | 2021-03-05 | US | West Virginia | Clay | 54015 | 382 | 5 | 0 | 377 | 38.46231092 | -81.07652217 | 2021-03-06 04:23:41 | Clay, West Virginia, US |
1619738 | 1619738 | 2021-03-05 | US | West Virginia | Pendleton | 54071 | 622 | 5 | 0 | 617 | 38.68314479 | -79.35084086 | 2021-03-06 04:23:41 | Pendleton, West Virginia, US |
2211121 | 2211121 | 2021-03-04 | US | West Virginia | Clay | 54015 | 379 | 5 | 0 | 374 | 38.46231092 | -81.07652217 | 2021-03-05 05:26:29 | Clay, West Virginia, US |
2211149 | 2211149 | 2021-03-04 | US | West Virginia | Pendleton | 54071 | 622 | 5 | 0 | 617 | 38.68314479 | -79.35084086 | 2021-03-05 05:26:29 | Pendleton, West Virginia, US |
1093542 | 1093542 | 2021-03-03 | US | West Virginia | Clay | 54015 | 378 | 5 | 0 | 373 | 38.46231092 | -81.07652217 | 2021-03-04 05:24:24 | Clay, West Virginia, US |
1093570 | 1093570 | 2021-03-03 | US | West Virginia | Pendleton | 54071 | 621 | 5 | 0 | 616 | 38.68314479 | -79.35084086 | 2021-03-04 05:24:24 | Pendleton, West Virginia, US |
3257614 | 3257614 | 2021-03-02 | US | West Virginia | Clay | 54015 | 376 | 5 | 0 | 371 | 38.46231092 | -81.07652217 | 2021-03-03 05:23:28 | Clay, West Virginia, US |
3257642 | 3257642 | 2021-03-02 | US | West Virginia | Pendleton | 54071 | 621 | 5 | 0 | 616 | 38.68314479 | -79.35084086 | 2021-03-03 05:23:28 | Pendleton, West Virginia, US |
1001906 | 1001906 | 2021-03-01 | US | West Virginia | Clay | 54015 | 376 | 5 | 0 | 371 | 38.46231092 | -81.07652217 | 2021-03-02 05:23:30 | Clay, West Virginia, US |
1001934 | 1001934 | 2021-03-01 | US | West Virginia | Pendleton | 54071 | 619 | 5 | 0 | 614 | 38.68314479 | -79.35084086 | 2021-03-02 05:23:30 | Pendleton, West Virginia, US |
2370964 | 2370964 | 2021-02-28 | US | West Virginia | Clay | 54015 | 376 | 5 | 0 | 371 | 38.46231092 | -81.07652217 | 2021-03-01 05:23:01 | Clay, West Virginia, US |
2370992 | 2370992 | 2021-02-28 | US | West Virginia | Pendleton | 54071 | 619 | 5 | 0 | 614 | 38.68314479 | -79.35084086 | 2021-03-01 05:23:01 | Pendleton, West Virginia, US |
3069494 | 3069494 | 2021-02-27 | US | West Virginia | Pendleton | 54071 | 619 | 5 | 0 | 614 | 38.68314479 | -79.35084086 | 2021-02-28 05:22:20 | Pendleton, West Virginia, US |
2187078 | 2187078 | 2021-02-26 | US | West Virginia | Pendleton | 54071 | 619 | 5 | 0 | 614 | 38.68314479 | -79.35084086 | 2021-02-27 05:22:28 | Pendleton, West Virginia, US |
1861500 | 1861500 | 2021-02-25 | US | West Virginia | Pendleton | 54071 | 618 | 5 | 0 | 613 | 38.68314479 | -79.35084086 | 2021-02-26 05:22:40 | Pendleton, West Virginia, US |
283678 | 283678 | 2021-02-24 | US | West Virginia | Pendleton | 54071 | 618 | 5 | 0 | 613 | 38.68314479 | -79.35084086 | 2021-02-25 05:24:57 | Pendleton, West Virginia, US |
1939946 | 1939946 | 2021-02-23 | US | West Virginia | Pendleton | 54071 | 617 | 5 | 0 | 612 | 38.68314479 | -79.35084086 | 2021-02-24 05:29:16 | Pendleton, West Virginia, US |
534201 | 534201 | 2021-02-22 | US | West Virginia | Pendleton | 54071 | 617 | 5 | 0 | 612 | 38.68314479 | -79.35084086 | 2021-02-23 05:23:41 | Pendleton, West Virginia, US |
185535 | 185535 | 2021-02-21 | US | West Virginia | Pendleton | 54071 | 617 | 5 | 0 | 612 | 38.68314479 | -79.35084086 | 2021-02-22 05:24:21 | Pendleton, West Virginia, US |
745809 | 745809 | 2021-02-20 | US | West Virginia | Pendleton | 54071 | 617 | 5 | 0 | 612 | 38.68314479 | -79.35084086 | 2021-02-21 05:24:33 | Pendleton, West Virginia, US |
474907 | 474907 | 2021-02-19 | US | West Virginia | Pendleton | 54071 | 617 | 5 | 0 | 612 | 38.68314479 | -79.35084086 | 2021-02-20 05:22:51 | Pendleton, West Virginia, US |
1156616 | 1156616 | 2021-02-18 | US | West Virginia | Pendleton | 54071 | 615 | 5 | 0 | 610 | 38.68314479 | -79.35084086 | 2021-02-19 05:24:16 | Pendleton, West Virginia, US |
3604536 | 3604536 | 2021-02-17 | US | West Virginia | Pendleton | 54071 | 613 | 5 | 0 | 608 | 38.68314479 | -79.35084086 | 2021-02-18 05:22:58 | Pendleton, West Virginia, US |
3053671 | 3053671 | 2021-02-16 | US | West Virginia | Pendleton | 54071 | 613 | 5 | 0 | 608 | 38.68314479 | -79.35084086 | 2021-02-17 05:23:10 | Pendleton, West Virginia, US |
1341770 | 1341770 | 2021-02-15 | US | West Virginia | Pendleton | 54071 | 610 | 5 | 0 | 605 | 38.68314479 | -79.35084086 | 2021-02-16 05:24:38 | Pendleton, West Virginia, US |
2286921 | 2286921 | 2021-02-14 | US | West Virginia | Pendleton | 54071 | 609 | 5 | 0 | 604 | 38.68314479 | -79.35084086 | 2021-02-15 05:24:49 | Pendleton, West Virginia, US |
2681321 | 2681321 | 2021-02-13 | US | West Virginia | Pendleton | 54071 | 607 | 5 | 0 | 602 | 38.68314479 | -79.35084086 | 2021-02-14 05:23:43 | Pendleton, West Virginia, US |
3542954 | 3542954 | 2021-02-12 | US | West Virginia | Pendleton | 54071 | 607 | 5 | 0 | 602 | 38.68314479 | -79.35084086 | 2021-02-13 05:22:12 | Pendleton, West Virginia, US |
2641217 | 2641217 | 2021-02-11 | US | West Virginia | Pendleton | 54071 | 604 | 5 | 0 | 599 | 38.68314479 | -79.35084086 | 2021-02-12 05:23:29 | Pendleton, West Virginia, US |
3982072 | 3982072 | 2021-02-10 | US | West Virginia | Pendleton | 54071 | 602 | 5 | 0 | 597 | 38.68314479 | -79.35084086 | 2021-02-11 05:23:55 | Pendleton, West Virginia, US |
1531392 | 1531392 | 2021-02-09 | US | West Virginia | Pendleton | 54071 | 602 | 5 | 0 | 597 | 38.68314479 | -79.35084086 | 2021-02-10 05:22:41 | Pendleton, West Virginia, US |
617156 | 617156 | 2021-02-08 | US | West Virginia | Doddridge | 54017 | 432 | 5 | 0 | 427 | 39.27057157 | -80.70671527 | 2021-02-09 05:23:30 | Doddridge, West Virginia, US |
1675925 | 1675925 | 2021-02-07 | US | West Virginia | Doddridge | 54017 | 431 | 5 | 0 | 426 | 39.27057157 | -80.70671527 | 2021-02-08 05:22:39 | Doddridge, West Virginia, US |
978386 | 978386 | 2021-02-06 | US | West Virginia | Doddridge | 54017 | 427 | 5 | 0 | 422 | 39.27057157 | -80.70671527 | 2021-02-07 05:23:00 | Doddridge, West Virginia, US |
1591644 | 1591644 | 2021-02-05 | US | West Virginia | Doddridge | 54017 | 421 | 5 | 0 | 416 | 39.27057157 | -80.70671527 | 2021-02-06 05:23:55 | Doddridge, West Virginia, US |
793851 | 793851 | 2021-02-04 | US | West Virginia | Doddridge | 54017 | 421 | 5 | 0 | 416 | 39.27057157 | -80.70671527 | 2021-02-05 05:22:38 | Doddridge, West Virginia, US |
343743 | 343743 | 2021-02-03 | US | West Virginia | Doddridge | 54017 | 417 | 5 | 0 | 412 | 39.27057157 | -80.70671527 | 2021-02-04 05:22:26 | Doddridge, West Virginia, 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]);