johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
107 rows where country_or_region = "US", deaths = 123 and province_or_state = "Maryland" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309470 | 309470 | 2022-12-13 | US | Maryland | Garrett | 24023 | 6841 | 123 | 0 | 39.52786077 | -79.27355126 | 2022-12-14 04:21:04 | Garrett, Maryland, US | |
1812367 | 1812367 | 2022-10-05 | US | Maryland | Queen Anne's | 24035 | 8266 | 123 | 0 | 39.06198912 | -76.03530977 | 2022-10-06 04:21:22 | Queen Anne's, Maryland, US | |
132341 | 132341 | 2022-10-04 | US | Maryland | Queen Anne's | 24035 | 8262 | 123 | 0 | 39.06198912 | -76.03530977 | 2022-10-05 04:23:06 | Queen Anne's, Maryland, US | |
2687288 | 2687288 | 2022-10-03 | US | Maryland | Queen Anne's | 24035 | 8254 | 123 | 0 | 39.06198912 | -76.03530977 | 2022-10-04 04:22:55 | Queen Anne's, Maryland, US | |
2261355 | 2261355 | 2022-10-02 | US | Maryland | Queen Anne's | 24035 | 8249 | 123 | 0 | 39.06198912 | -76.03530977 | 2022-10-03 04:23:11 | Queen Anne's, Maryland, US | |
2996881 | 2996881 | 2022-10-01 | US | Maryland | Queen Anne's | 24035 | 8249 | 123 | 0 | 39.06198912 | -76.03530977 | 2022-10-02 04:21:23 | Queen Anne's, Maryland, US | |
855207 | 855207 | 2022-09-30 | US | Maryland | Queen Anne's | 24035 | 8249 | 123 | 0 | 39.06198912 | -76.03530977 | 2022-10-01 04:23:01 | Queen Anne's, Maryland, US | |
2377133 | 2377133 | 2022-09-29 | US | Maryland | Queen Anne's | 24035 | 8246 | 123 | 0 | 39.06198912 | -76.03530977 | 2022-09-30 04:23:09 | Queen Anne's, Maryland, US | |
1319789 | 1319789 | 2022-01-26 | US | Maryland | Calvert | 24009 | 10398 | 123 | 0 | 38.53961642 | -76.56820632 | 2022-01-27 04:21:19 | Calvert, Maryland, US | |
716060 | 716060 | 2021-11-12 | US | Maryland | Worcester | 24047 | 5103 | 123 | 0 | 38.21274277 | -75.33200012 | 2021-11-13 04:21:38 | Worcester, Maryland, US | |
30010 | 30010 | 2021-11-11 | US | Maryland | Worcester | 24047 | 5089 | 123 | 0 | 38.21274277 | -75.33200012 | 2021-11-12 04:22:01 | Worcester, Maryland, US | |
2846449 | 2846449 | 2021-11-10 | US | Maryland | Worcester | 24047 | 5080 | 123 | 0 | 38.21274277 | -75.33200012 | 2021-11-11 04:21:45 | Worcester, Maryland, US | |
88719 | 88719 | 2021-11-09 | US | Maryland | Worcester | 24047 | 5076 | 123 | 0 | 38.21274277 | -75.33200012 | 2021-11-10 04:21:38 | Worcester, Maryland, US | |
2822352 | 2822352 | 2021-05-10 | US | Maryland | St. Mary's | 24037 | 5928 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-11 04:20:41 | St. Mary's, Maryland, US | |
1426684 | 1426684 | 2021-05-09 | US | Maryland | St. Mary's | 24037 | 5919 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-10 04:20:38 | St. Mary's, Maryland, US | |
1553552 | 1553552 | 2021-05-08 | US | Maryland | St. Mary's | 24037 | 5913 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-09 04:20:35 | St. Mary's, Maryland, US | |
2503610 | 2503610 | 2021-05-07 | US | Maryland | St. Mary's | 24037 | 5901 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-08 04:21:04 | St. Mary's, Maryland, US | |
3115066 | 3115066 | 2021-05-06 | US | Maryland | St. Mary's | 24037 | 5894 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-07 04:20:40 | St. Mary's, Maryland, US | |
647533 | 647533 | 2021-05-05 | US | Maryland | St. Mary's | 24037 | 5878 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-06 04:20:38 | St. Mary's, Maryland, US | |
3677233 | 3677233 | 2021-05-04 | US | Maryland | St. Mary's | 24037 | 5874 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-05 04:20:43 | St. Mary's, Maryland, US | |
2762500 | 2762500 | 2021-05-03 | US | Maryland | St. Mary's | 24037 | 5868 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-04 04:20:34 | St. Mary's, Maryland, US | |
2452353 | 2452353 | 2021-05-02 | US | Maryland | St. Mary's | 24037 | 5859 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-03 04:20:39 | St. Mary's, Maryland, US | |
2826366 | 2826366 | 2021-05-01 | US | Maryland | St. Mary's | 24037 | 5852 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-02 04:20:48 | St. Mary's, Maryland, US | |
381774 | 381774 | 2021-04-30 | US | Maryland | St. Mary's | 24037 | 5824 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-05-01 04:20:47 | St. Mary's, Maryland, US | |
1637897 | 1637897 | 2021-04-29 | US | Maryland | St. Mary's | 24037 | 5815 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-30 04:21:03 | St. Mary's, Maryland, US | |
3394976 | 3394976 | 2021-04-28 | US | Maryland | St. Mary's | 24037 | 5788 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-29 04:20:55 | St. Mary's, Maryland, US | |
3703692 | 3703692 | 2021-04-27 | US | Maryland | St. Mary's | 24037 | 5773 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-28 04:20:32 | St. Mary's, Maryland, US | |
889701 | 889701 | 2021-04-26 | US | Maryland | St. Mary's | 24037 | 5766 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-27 04:20:52 | St. Mary's, Maryland, US | |
956446 | 956446 | 2021-04-25 | US | Maryland | St. Mary's | 24037 | 5758 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-26 04:21:04 | St. Mary's, Maryland, US | |
3925593 | 3925593 | 2021-04-24 | US | Maryland | St. Mary's | 24037 | 5738 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-25 04:20:32 | St. Mary's, Maryland, US | |
1410624 | 1410624 | 2021-04-23 | US | Maryland | St. Mary's | 24037 | 5726 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-24 04:20:38 | St. Mary's, Maryland, US | |
1569687 | 1569687 | 2021-04-22 | US | Maryland | St. Mary's | 24037 | 5713 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-23 04:20:52 | St. Mary's, Maryland, US | |
3243908 | 3243908 | 2021-04-21 | US | Maryland | St. Mary's | 24037 | 5701 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-22 04:20:53 | St. Mary's, Maryland, US | |
2022304 | 2022304 | 2021-04-20 | US | Maryland | St. Mary's | 24037 | 5697 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-21 04:21:14 | St. Mary's, Maryland, US | |
2412425 | 2412425 | 2021-04-19 | US | Maryland | St. Mary's | 24037 | 5682 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-20 04:20:41 | St. Mary's, Maryland, US | |
3131102 | 3131102 | 2021-04-18 | US | Maryland | St. Mary's | 24037 | 5674 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-19 04:20:57 | St. Mary's, Maryland, US | |
984530 | 984530 | 2021-04-17 | US | Maryland | St. Mary's | 24037 | 5664 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-18 04:20:41 | St. Mary's, Maryland, US | |
171625 | 171625 | 2021-04-16 | US | Maryland | St. Mary's | 24037 | 5649 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-17 04:20:40 | St. Mary's, Maryland, US | |
2550456 | 2550456 | 2021-04-15 | US | Maryland | St. Mary's | 24037 | 5632 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-16 04:20:46 | St. Mary's, Maryland, US | |
1843526 | 1843526 | 2021-04-14 | US | Maryland | St. Mary's | 24037 | 5612 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-15 04:20:54 | St. Mary's, Maryland, US | |
2573260 | 2573260 | 2021-04-13 | US | Maryland | St. Mary's | 24037 | 5596 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-14 04:20:41 | St. Mary's, Maryland, US | |
38011 | 38011 | 2021-04-12 | US | Maryland | St. Mary's | 24037 | 5578 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-13 04:20:37 | St. Mary's, Maryland, US | |
3885170 | 3885170 | 2021-04-11 | US | Maryland | St. Mary's | 24037 | 5564 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-12 04:21:00 | St. Mary's, Maryland, US | |
2984838 | 2984838 | 2021-04-10 | US | Maryland | St. Mary's | 24037 | 5555 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-11 04:20:56 | St. Mary's, Maryland, US | |
607270 | 607270 | 2021-04-09 | US | Maryland | St. Mary's | 24037 | 5545 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-10 04:20:59 | St. Mary's, Maryland, US | |
2647334 | 2647334 | 2021-04-08 | US | Maryland | St. Mary's | 24037 | 5523 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-09 04:21:13 | St. Mary's, Maryland, US | |
2248976 | 2248976 | 2021-04-07 | US | Maryland | St. Mary's | 24037 | 5511 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-08 04:21:13 | St. Mary's, Maryland, US | |
3004886 | 3004886 | 2021-04-06 | US | Maryland | St. Mary's | 24037 | 5499 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-07 04:20:53 | St. Mary's, Maryland, US | |
3086881 | 3086881 | 2021-04-05 | US | Maryland | St. Mary's | 24037 | 5485 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-06 04:20:32 | St. Mary's, Maryland, US | |
389804 | 389804 | 2021-04-04 | US | Maryland | St. Mary's | 24037 | 5477 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-05 04:20:35 | St. Mary's, Maryland, US | |
3711720 | 3711720 | 2021-04-03 | US | Maryland | St. Mary's | 24037 | 5462 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-04 04:20:49 | St. Mary's, Maryland, US | |
242836 | 242836 | 2021-04-02 | US | Maryland | St. Mary's | 24037 | 5453 | 123 | 0 | 38.30058422 | -76.60629279999998 | 2021-04-03 04:20:44 | St. Mary's, Maryland, US | |
3964087 | 3964087 | 2021-03-10 | US | Maryland | Cecil | 24015 | 5072 | 123 | 0 | 39.56647682 | -75.94627411 | 2021-03-11 05:25:48 | Cecil, Maryland, US | |
3665175 | 3665175 | 2021-03-09 | US | Maryland | Cecil | 24015 | 5068 | 123 | 0 | 39.56647682 | -75.94627411 | 2021-03-10 05:24:35 | Cecil, Maryland, US | |
2361034 | 2361034 | 2021-03-08 | US | Maryland | Cecil | 24015 | 5066 | 123 | 0 | 39.56647682 | -75.94627411 | 2021-03-09 05:28:19 | Cecil, Maryland, US | |
56372 | 56372 | 2021-03-07 | US | Maryland | Cecil | 24015 | 5059 | 123 | 0 | 39.56647682 | -75.94627411 | 2021-03-08 05:24:48 | Cecil, Maryland, US | |
3669189 | 3669189 | 2021-03-06 | US | Maryland | Cecil | 24015 | 5053 | 123 | 0 | 4930 | 39.56647682 | -75.94627411 | 2021-03-07 05:21:54 | Cecil, Maryland, US |
1617810 | 1617810 | 2021-03-05 | US | Maryland | Cecil | 24015 | 5046 | 123 | 0 | 4923 | 39.56647682 | -75.94627411 | 2021-03-06 04:23:41 | Cecil, Maryland, US |
3155188 | 3155188 | 2021-01-27 | US | Maryland | Wicomico | 24045 | 6172 | 123 | 0 | 6049 | 38.37301947 | -75.62705831 | 2021-01-28 05:22:24 | Wicomico, Maryland, US |
13923 | 13923 | 2021-01-26 | US | Maryland | Wicomico | 24045 | 6140 | 123 | 0 | 6017 | 38.37301947 | -75.62705831 | 2021-01-27 05:23:41 | Wicomico, Maryland, US |
763881 | 763881 | 2020-10-18 | US | Maryland | Howard | 24027 | 5580 | 123 | 0 | 5457 | 39.25305293 | -76.93126208 | 2020-10-19 04:24:16 | Howard, Maryland, US |
1027919 | 1027919 | 2020-10-17 | US | Maryland | Howard | 24027 | 5566 | 123 | 0 | 5443 | 39.25305293 | -76.93126208 | 2020-10-18 04:24:25 | Howard, Maryland, US |
2858414 | 2858414 | 2020-10-16 | US | Maryland | Howard | 24027 | 5534 | 123 | 0 | 5411 | 39.25305293 | -76.93126208 | 2020-10-17 04:24:12 | Howard, Maryland, US |
787943 | 787943 | 2020-10-15 | US | Maryland | Howard | 24027 | 5508 | 123 | 0 | 5385 | 39.25305293 | -76.93126208 | 2020-10-16 04:24:01 | Howard, Maryland, US |
80654 | 80654 | 2020-10-14 | US | Maryland | Howard | 24027 | 5487 | 123 | 0 | 5364 | 39.25305293 | -76.93126208 | 2020-10-15 04:24:28 | Howard, Maryland, US |
3783469 | 3783469 | 2020-10-13 | US | Maryland | Howard | 24027 | 5473 | 123 | 0 | 5350 | 39.25305293 | -76.93126208 | 2020-10-14 04:24:05 | Howard, Maryland, US |
2293009 | 2293009 | 2020-10-12 | US | Maryland | Howard | 24027 | 5459 | 123 | 0 | 5336 | 39.25305293 | -76.93126208 | 2020-10-13 04:24:02 | Howard, Maryland, US |
3787461 | 3787461 | 2020-10-11 | US | Maryland | Howard | 24027 | 5422 | 123 | 0 | 5299 | 39.25305293 | -76.93126208 | 2020-10-12 04:23:45 | Howard, Maryland, US |
2603599 | 2603599 | 2020-10-10 | US | Maryland | Howard | 24027 | 5391 | 123 | 0 | 5268 | 39.25305293 | -76.93126208 | 2020-10-11 04:23:46 | Howard, Maryland, US |
819132 | 819132 | 2020-10-09 | US | Maryland | Howard | 24027 | 5357 | 123 | 0 | 5234 | 39.25305293 | -76.93126208 | 2020-10-10 04:23:57 | Howard, Maryland, US |
2691247 | 2691247 | 2020-10-08 | US | Maryland | Howard | 24027 | 5322 | 123 | 0 | 5199 | 39.25305293 | -76.93126208 | 2020-10-09 04:23:59 | Howard, Maryland, US |
3119050 | 3119050 | 2020-10-06 | US | Maryland | Howard | 24027 | 5276 | 123 | 0 | 5153 | 39.25305293 | -76.93126208 | 2020-10-07 04:23:40 | Howard, Maryland, US |
3803462 | 3803462 | 2020-10-05 | US | Maryland | Howard | 24027 | 5262 | 123 | 0 | 5139 | 39.25305293 | -76.93126208 | 2020-10-06 04:23:33 | Howard, Maryland, US |
1824352 | 1824352 | 2020-10-04 | US | Maryland | Howard | 24027 | 5234 | 123 | 0 | 5111 | 39.25305293 | -76.93126208 | 2020-10-05 04:23:33 | Howard, Maryland, US |
2515736 | 2515736 | 2020-10-03 | US | Maryland | Howard | 24027 | 5217 | 123 | 0 | 5094 | 39.25305293 | -76.93126208 | 2020-10-04 04:23:44 | Howard, Maryland, US |
2814314 | 2814314 | 2020-09-25 | US | Maryland | Howard | 24027 | 5013 | 123 | 0 | 4890 | 39.25305293 | -76.93126208 | 2020-09-26 04:23:00 | Howard, Maryland, US |
2607591 | 2607591 | 2020-09-24 | US | Maryland | Howard | 24027 | 4997 | 123 | 0 | 4874 | 39.25305293 | -76.93126208 | 2020-09-25 04:23:00 | Howard, Maryland, US |
2655334 | 2655334 | 2020-09-23 | US | Maryland | Howard | 24027 | 4983 | 123 | 0 | 4860 | 39.25305293 | -76.93126208 | 2020-09-24 04:23:00 | Howard, Maryland, US |
2850398 | 2850398 | 2020-09-18 | US | Maryland | Carroll | 24013 | 1891 | 123 | 0 | 1768 | 39.56453592 | -77.02373735 | 2020-09-19 04:22:00 | Carroll, Maryland, US |
1123147 | 1123147 | 2020-09-17 | US | Maryland | Carroll | 24013 | 1888 | 123 | 0 | 1765 | 39.56453592 | -77.02373735 | 2020-09-18 05:05:00 | Carroll, Maryland, US |
667836 | 667836 | 2020-09-16 | US | Maryland | Carroll | 24013 | 1881 | 123 | 0 | 1758 | 39.56453592 | -77.02373735 | 2020-09-17 04:22:00 | Carroll, Maryland, US |
2730561 | 2730561 | 2020-09-15 | US | Maryland | Carroll | 24013 | 1871 | 123 | 0 | 1748 | 39.56453592 | -77.02373735 | 2020-09-16 04:22:53 | Carroll, Maryland, US |
345833 | 345833 | 2020-09-14 | US | Maryland | Carroll | 24013 | 1863 | 123 | 0 | 1740 | 39.56453592 | -77.02373735 | 2020-09-15 03:22:50 | Carroll, Maryland, US |
2870272 | 2870272 | 2020-09-13 | US | Maryland | Carroll | 24013 | 1852 | 123 | 0 | 1729 | 39.56453592 | -77.02373735 | 2020-09-14 04:26:00 | Carroll, Maryland, US |
548311 | 548311 | 2020-09-12 | US | Maryland | Carroll | 24013 | 1842 | 123 | 0 | 1719 | 39.56453592 | -77.02373735 | 2020-09-13 04:30:52 | Carroll, Maryland, US |
1446140 | 1446140 | 2020-09-11 | US | Maryland | Carroll | 24013 | 1820 | 123 | 0 | 1697 | 39.56453592 | -77.02373735 | 2020-09-12 04:25:05 | Carroll, Maryland, US |
1174741 | 1174741 | 2020-09-10 | US | Maryland | Carroll | 24013 | 1815 | 123 | 0 | 1692 | 39.56453592 | -77.02373735 | 2020-09-11 04:46:23 | Carroll, Maryland, US |
2173106 | 2173106 | 2020-09-09 | US | Maryland | Carroll | 24013 | 1807 | 123 | 0 | 1684 | 39.56453592 | -77.02373735 | 2020-09-10 04:29:01 | Carroll, Maryland, US |
1245315 | 1245315 | 2020-09-08 | US | Maryland | Carroll | 24013 | 1796 | 123 | 0 | 1673 | 39.56453592 | -77.02373735 | 2020-09-09 04:28:48 | Carroll, Maryland, US |
428894 | 428894 | 2020-09-07 | US | Maryland | Carroll | 24013 | 1788 | 123 | 0 | 1665 | 39.56453592 | -77.02373735 | 2020-09-08 04:28:25 | Carroll, Maryland, US |
3163179 | 3163179 | 2020-09-06 | US | Maryland | Carroll | 24013 | 1780 | 123 | 0 | 1657 | 39.56453592 | -77.02373735 | 2020-09-07 04:28:30 | Carroll, Maryland, US |
815134 | 815134 | 2020-09-05 | US | Maryland | Carroll | 24013 | 1769 | 123 | 0 | 1646 | 39.56453592 | -77.02373735 | 2020-09-06 04:28:33 | Carroll, Maryland, US |
2663334 | 2663334 | 2020-09-04 | US | Maryland | Carroll | 24013 | 1744 | 123 | 0 | 1621 | 39.56453592 | -77.02373735 | 2020-09-05 04:28:19 | Carroll, Maryland, US |
1355874 | 1355874 | 2020-09-03 | US | Maryland | Carroll | 24013 | 1728 | 123 | 0 | 1605 | 39.56453592 | -77.02373735 | 2020-09-04 04:28:26 | Carroll, Maryland, US |
1107111 | 1107111 | 2020-09-02 | US | Maryland | Carroll | 24013 | 1711 | 123 | 0 | 1588 | 39.56453592 | -77.02373735 | 2020-09-03 04:28:22 | Carroll, Maryland, US |
2061440 | 2061440 | 2020-09-01 | US | Maryland | Carroll | 24013 | 1700 | 123 | 0 | 1577 | 39.56453592 | -77.02373735 | 2020-09-02 04:28:25 | Carroll, Maryland, US |
195625 | 195625 | 2020-08-31 | US | Maryland | Carroll | 24013 | 1694 | 123 | 0 | 1571 | 39.56453592 | -77.02373735 | 2020-09-01 04:28:31 | Carroll, Maryland, US |
3933584 | 3933584 | 2020-08-30 | US | Maryland | Carroll | 24013 | 1686 | 123 | 0 | 1563 | 39.56453592 | -77.02373735 | 2020-08-31 04:28:27 | Carroll, Maryland, US |
611246 | 611246 | 2020-08-29 | US | Maryland | Carroll | 24013 | 1679 | 123 | 0 | 1556 | 39.56453592 | -77.02373735 | 2020-08-30 04:28:22 | Carroll, Maryland, US |
1524741 | 1524741 | 2020-08-28 | US | Maryland | Carroll | 24013 | 1669 | 123 | 0 | 1546 | 39.56453592 | -77.02373735 | 2020-08-29 04:28:19 | Carroll, Maryland, 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]);