johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where country_or_region = "Colombia" and province_or_state = "San Andres y Providencia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462650 | 2462650 | 2021-09-14 | Colombia | San Andres y Providencia | 6832 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-15 03:22:37 | San Andres y Providencia, Colombia | |||
1385489 | 1385489 | 2021-09-13 | Colombia | San Andres y Providencia | 6830 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-14 04:21:41 | San Andres y Providencia, Colombia | |||
1884858 | 1884858 | 2021-09-12 | Colombia | San Andres y Providencia | 6830 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-13 04:21:15 | San Andres y Providencia, Colombia | |||
3805761 | 3805761 | 2021-09-11 | Colombia | San Andres y Providencia | 6828 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-12 04:21:13 | San Andres y Providencia, Colombia | |||
3448701 | 3448701 | 2021-09-10 | Colombia | San Andres y Providencia | 6828 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-11 04:21:30 | San Andres y Providencia, Colombia | |||
1262647 | 1262647 | 2021-09-09 | Colombia | San Andres y Providencia | 6826 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-10 04:21:20 | San Andres y Providencia, Colombia | |||
2279017 | 2279017 | 2021-09-08 | Colombia | San Andres y Providencia | 6823 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-09 04:21:27 | San Andres y Providencia, Colombia | |||
641796 | 641796 | 2021-09-07 | Colombia | San Andres y Providencia | 6822 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-08 04:21:31 | San Andres y Providencia, Colombia | |||
3193859 | 3193859 | 2021-09-06 | Colombia | San Andres y Providencia | 6819 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-07 04:21:35 | San Andres y Providencia, Colombia | |||
3280727 | 3280727 | 2021-09-05 | Colombia | San Andres y Providencia | 6819 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-06 04:21:22 | San Andres y Providencia, Colombia | |||
249141 | 249141 | 2021-09-04 | Colombia | San Andres y Providencia | 6819 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-05 04:21:33 | San Andres y Providencia, Colombia | |||
3974422 | 3974422 | 2021-09-03 | Colombia | San Andres y Providencia | 6807 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-04 04:21:28 | San Andres y Providencia, Colombia | |||
177884 | 177884 | 2021-09-02 | Colombia | San Andres y Providencia | 6803 | 134 | 0 | 12.5567 | -81.7185 | 2021-09-03 04:21:20 | San Andres y Providencia, Colombia | |||
66919 | 66919 | 2021-09-01 | Colombia | San Andres y Providencia | 6802 | 133 | 0 | 12.5567 | -81.7185 | 2021-09-02 04:21:15 | San Andres y Providencia, Colombia | |||
2067761 | 2067761 | 2021-08-31 | Colombia | San Andres y Providencia | 6799 | 133 | 0 | 12.5567 | -81.7185 | 2021-09-01 04:21:38 | San Andres y Providencia, Colombia | |||
1775215 | 1775215 | 2021-08-30 | Colombia | San Andres y Providencia | 6797 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-31 04:21:46 | San Andres y Providencia, Colombia | |||
3891789 | 3891789 | 2021-08-29 | Colombia | San Andres y Providencia | 6797 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-30 04:21:23 | San Andres y Providencia, Colombia | |||
2792892 | 2792892 | 2021-08-28 | Colombia | San Andres y Providencia | 6797 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-29 04:21:14 | San Andres y Providencia, Colombia | |||
2923051 | 2923051 | 2021-08-27 | Colombia | San Andres y Providencia | 6796 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-28 04:21:28 | San Andres y Providencia, Colombia | |||
1596065 | 1596065 | 2021-08-26 | Colombia | San Andres y Providencia | 6796 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-27 04:21:37 | San Andres y Providencia, Colombia | |||
32274 | 32274 | 2021-08-25 | Colombia | San Andres y Providencia | 6795 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-26 04:21:28 | San Andres y Providencia, Colombia | |||
3105313 | 3105313 | 2021-08-24 | Colombia | San Andres y Providencia | 6795 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-25 04:21:41 | San Andres y Providencia, Colombia | |||
3165484 | 3165484 | 2021-08-23 | Colombia | San Andres y Providencia | 6794 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-24 04:21:19 | San Andres y Providencia, Colombia | |||
2175411 | 2175411 | 2021-08-22 | Colombia | San Andres y Providencia | 6794 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-23 04:21:27 | San Andres y Providencia, Colombia | |||
3555507 | 3555507 | 2021-08-21 | Colombia | San Andres y Providencia | 6794 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-22 04:21:29 | San Andres y Providencia, Colombia | |||
1853849 | 1853849 | 2021-08-20 | Colombia | San Andres y Providencia | 6794 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-21 04:21:38 | San Andres y Providencia, Colombia | |||
511556 | 511556 | 2021-08-19 | Colombia | San Andres y Providencia | 6786 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-20 04:21:33 | San Andres y Providencia, Colombia | |||
2518035 | 2518035 | 2021-08-18 | Colombia | San Andres y Providencia | 6786 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-19 04:21:15 | San Andres y Providencia, Colombia | |||
245127 | 245127 | 2021-08-17 | Colombia | San Andres y Providencia | 6783 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-18 04:21:35 | San Andres y Providencia, Colombia | |||
1604090 | 1604090 | 2021-08-16 | Colombia | San Andres y Providencia | 6782 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-17 04:21:49 | San Andres y Providencia, Colombia | |||
103184 | 103184 | 2021-08-15 | Colombia | San Andres y Providencia | 6782 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-16 04:21:31 | San Andres y Providencia, Colombia | |||
507542 | 507542 | 2021-08-14 | Colombia | San Andres y Providencia | 6782 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-15 04:21:41 | San Andres y Providencia, Colombia | |||
1483414 | 1483414 | 2021-08-13 | Colombia | San Andres y Providencia | 6779 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-14 04:21:25 | San Andres y Providencia, Colombia | |||
2899544 | 2899544 | 2021-08-12 | Colombia | San Andres y Providencia | 6778 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-13 04:21:24 | San Andres y Providencia, Colombia | |||
1342148 | 1342148 | 2021-08-11 | Colombia | San Andres y Providencia | 6769 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-12 04:21:25 | San Andres y Providencia, Colombia | |||
2351295 | 2351295 | 2021-08-10 | Colombia | San Andres y Providencia | 6769 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-11 04:21:58 | San Andres y Providencia, Colombia | |||
649824 | 649824 | 2021-08-09 | Colombia | San Andres y Providencia | 6763 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-10 04:21:27 | San Andres y Providencia, Colombia | |||
589486 | 589486 | 2021-08-08 | Colombia | San Andres y Providencia | 6762 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-09 04:21:24 | San Andres y Providencia, Colombia | |||
2203498 | 2203498 | 2021-08-07 | Colombia | San Andres y Providencia | 6761 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-08 04:21:33 | San Andres y Providencia, Colombia | |||
1117448 | 1117448 | 2021-08-06 | Colombia | San Andres y Providencia | 6760 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-07 04:21:30 | San Andres y Providencia, Colombia | |||
1956385 | 1956385 | 2021-08-05 | Colombia | San Andres y Providencia | 6760 | 133 | 0 | 12.5567 | -81.7185 | 2021-08-06 04:21:18 | San Andres y Providencia, Colombia | |||
331764 | 331764 | 2021-08-04 | Colombia | San Andres y Providencia | 6758 | 133 | 6590 | 35 | 12.5567 | -81.7185 | 2021-08-05 04:21:51 | San Andres y Providencia, Colombia | ||
3468035 | 3468035 | 2021-08-03 | Colombia | San Andres y Providencia | 6754 | 133 | 6552 | 69 | 12.5567 | -81.7185 | 2021-08-04 04:21:25 | San Andres y Providencia, Colombia | ||
3683309 | 3683309 | 2021-08-02 | Colombia | San Andres y Providencia | 6736 | 133 | 6549 | 54 | 12.5567 | -81.7185 | 2021-08-03 04:21:39 | San Andres y Providencia, Colombia | ||
3015208 | 3015208 | 2021-08-01 | Colombia | San Andres y Providencia | 6732 | 133 | 6548 | 51 | 12.5567 | -81.7185 | 2021-08-02 04:21:36 | San Andres y Providencia, Colombia | ||
3903831 | 3903831 | 2021-07-31 | Colombia | San Andres y Providencia | 6730 | 133 | 6539 | 58 | 12.5567 | -81.7185 | 2021-08-01 04:21:50 | San Andres y Providencia, Colombia | ||
3296036 | 3296036 | 2021-07-30 | Colombia | San Andres y Providencia | 6724 | 133 | 6538 | 53 | 12.5567 | -81.7185 | 2021-07-31 04:21:35 | San Andres y Providencia, Colombia | ||
3385247 | 3385247 | 2021-07-29 | Colombia | San Andres y Providencia | 6721 | 133 | 6536 | 52 | 12.5567 | -81.7185 | 2021-07-30 04:21:34 | San Andres y Providencia, Colombia | ||
408152 | 408152 | 2021-07-28 | Colombia | San Andres y Providencia | 6719 | 133 | 6525 | 61 | 12.5567 | -81.7185 | 2021-07-29 04:21:33 | San Andres y Providencia, Colombia | ||
1306013 | 1306013 | 2021-07-27 | Colombia | San Andres y Providencia | 6712 | 133 | 6513 | 66 | 12.5567 | -81.7185 | 2021-07-28 04:21:39 | San Andres y Providencia, Colombia | ||
3218156 | 3218156 | 2021-07-26 | Colombia | San Andres y Providencia | 6705 | 133 | 6498 | 74 | 12.5567 | -81.7185 | 2021-07-27 04:21:18 | San Andres y Providencia, Colombia | ||
1378365 | 1378365 | 2021-07-25 | Colombia | San Andres y Providencia | 6703 | 133 | 6488 | 82 | 12.5567 | -81.7185 | 2021-07-26 04:21:28 | San Andres y Providencia, Colombia | ||
1330105 | 1330105 | 2021-07-24 | Colombia | San Andres y Providencia | 6700 | 133 | 6443 | 124 | 12.5567 | -81.7185 | 2021-07-25 04:22:12 | San Andres y Providencia, Colombia | ||
3137409 | 3137409 | 2021-07-23 | Colombia | San Andres y Providencia | 6647 | 133 | 6430 | 84 | 12.5567 | -81.7185 | 2021-07-24 00:21:36 | San Andres y Providencia, Colombia | ||
3476169 | 3476169 | 2021-07-22 | Colombia | San Andres y Providencia | 6647 | 133 | 6430 | 84 | 12.5567 | -81.7185 | 2021-07-23 04:21:29 | San Andres y Providencia, Colombia | ||
3331388 | 3331388 | 2021-07-21 | Colombia | San Andres y Providencia | 6646 | 133 | 6414 | 99 | 12.5567 | -81.7185 | 2021-07-22 04:21:19 | San Andres y Providencia, Colombia | ||
2371369 | 2371369 | 2021-07-20 | Colombia | San Andres y Providencia | 6598 | 133 | 6397 | 68 | 12.5567 | -81.7185 | 2021-07-21 04:21:40 | San Andres y Providencia, Colombia | ||
483448 | 483448 | 2021-07-19 | Colombia | San Andres y Providencia | 6598 | 133 | 6390 | 75 | 12.5567 | -81.7185 | 2021-07-20 04:21:48 | San Andres y Providencia, Colombia | ||
2673671 | 2673671 | 2021-07-18 | Colombia | San Andres y Providencia | 6598 | 133 | 6373 | 92 | 12.5567 | -81.7185 | 2021-07-19 04:21:24 | San Andres y Providencia, Colombia | ||
3705983 | 3705983 | 2021-07-17 | Colombia | San Andres y Providencia | 6598 | 132 | 6369 | 97 | 12.5567 | -81.7185 | 2021-07-18 04:22:07 | San Andres y Providencia, Colombia | ||
2947214 | 2947214 | 2021-07-16 | Colombia | San Andres y Providencia | 6581 | 131 | 6365 | 85 | 12.5567 | -81.7185 | 2021-07-17 04:22:22 | San Andres y Providencia, Colombia | ||
295870 | 295870 | 2021-07-15 | Colombia | San Andres y Providencia | 6554 | 130 | 6357 | 67 | 12.5567 | -81.7185 | 2021-07-16 04:21:22 | San Andres y Providencia, Colombia | ||
3631815 | 3631815 | 2021-07-14 | Colombia | San Andres y Providencia | 6546 | 130 | 6347 | 69 | 12.5567 | -81.7185 | 2021-07-15 04:21:48 | San Andres y Providencia, Colombia | ||
578690 | 578690 | 2021-07-13 | Colombia | San Andres y Providencia | 6535 | 130 | 6344 | 61 | 12.5567 | -81.7185 | 2021-07-14 04:21:35 | San Andres y Providencia, Colombia | ||
3740939 | 3740939 | 2021-07-12 | Colombia | San Andres y Providencia | 6522 | 130 | 6331 | 61 | 12.5567 | -81.7185 | 2021-07-13 04:21:18 | San Andres y Providencia, Colombia | ||
3659452 | 3659452 | 2021-07-11 | Colombia | San Andres y Providencia | 6522 | 128 | 6313 | 81 | 12.5567 | -81.7185 | 2021-07-12 04:21:34 | San Andres y Providencia, Colombia | ||
625736 | 625736 | 2021-07-10 | Colombia | San Andres y Providencia | 6521 | 128 | 6313 | 80 | 12.5567 | -81.7185 | 2021-07-11 04:21:43 | San Andres y Providencia, Colombia | ||
829455 | 829455 | 2021-07-09 | Colombia | San Andres y Providencia | 6516 | 128 | 6280 | 108 | 12.5567 | -81.7185 | 2021-07-10 04:21:25 | San Andres y Providencia, Colombia | ||
778219 | 778219 | 2021-07-08 | Colombia | San Andres y Providencia | 6513 | 128 | 6280 | 105 | 12.5567 | -81.7185 | 2021-07-09 04:21:21 | San Andres y Providencia, Colombia | ||
1440441 | 1440441 | 2021-07-07 | Colombia | San Andres y Providencia | 6499 | 128 | 6265 | 106 | 12.5567 | -81.7185 | 2021-07-08 04:21:26 | San Andres y Providencia, Colombia | ||
2693546 | 2693546 | 2021-07-06 | Colombia | San Andres y Providencia | 6458 | 128 | 6225 | 105 | 12.5567 | -81.7185 | 2021-07-07 04:21:20 | San Andres y Providencia, Colombia | ||
1932295 | 1932295 | 2021-07-05 | Colombia | San Andres y Providencia | 6420 | 128 | 6196 | 96 | 12.5567 | -81.7185 | 2021-07-06 04:21:32 | San Andres y Providencia, Colombia | ||
1165026 | 1165026 | 2021-07-04 | Colombia | San Andres y Providencia | 6413 | 127 | 6180 | 106 | 12.5567 | -81.7185 | 2021-07-05 04:21:28 | San Andres y Providencia, Colombia | ||
1495460 | 1495460 | 2021-07-03 | Colombia | San Andres y Providencia | 6398 | 127 | 6154 | 117 | 12.5567 | -81.7185 | 2021-07-04 04:21:38 | San Andres y Providencia, Colombia | ||
2071775 | 2071775 | 2021-07-02 | Colombia | San Andres y Providencia | 6378 | 127 | 6095 | 156 | 12.5567 | -81.7185 | 2021-07-03 04:21:37 | San Andres y Providencia, Colombia | ||
2764791 | 2764791 | 2021-07-01 | Colombia | San Andres y Providencia | 6325 | 127 | 6080 | 118 | 12.5567 | -81.7185 | 2021-07-02 04:21:47 | San Andres y Providencia, Colombia | ||
1892999 | 1892999 | 2021-06-30 | Colombia | San Andres y Providencia | 6295 | 124 | 6070 | 101 | 12.5567 | -81.7185 | 2021-07-01 04:21:19 | San Andres y Providencia, Colombia | ||
400122 | 400122 | 2021-06-29 | Colombia | San Andres y Providencia | 6274 | 124 | 6055 | 95 | 12.5567 | -81.7185 | 2021-06-30 04:21:41 | San Andres y Providencia, Colombia | ||
3125365 | 3125365 | 2021-06-28 | Colombia | San Andres y Providencia | 6264 | 124 | 6051 | 89 | 12.5567 | -81.7185 | 2021-06-29 04:21:28 | San Andres y Providencia, Colombia | ||
2589860 | 2589860 | 2021-06-27 | Colombia | San Andres y Providencia | 6256 | 123 | 6044 | 89 | 12.5567 | -81.7185 | 2021-06-28 04:21:29 | San Andres y Providencia, Colombia | ||
3958364 | 3958364 | 2021-06-26 | Colombia | San Andres y Providencia | 6251 | 123 | 6031 | 97 | 12.5567 | -81.7185 | 2021-06-27 04:21:39 | San Andres y Providencia, Colombia | ||
1712183 | 1712183 | 2021-06-25 | Colombia | San Andres y Providencia | 6241 | 123 | 6004 | 114 | 12.5567 | -81.7185 | 2021-06-26 04:21:43 | San Andres y Providencia, Colombia | ||
2295308 | 2295308 | 2021-06-24 | Colombia | San Andres y Providencia | 6215 | 123 | 5995 | 97 | 12.5567 | -81.7185 | 2021-06-25 04:21:33 | San Andres y Providencia, Colombia | ||
2422748 | 2422748 | 2021-06-23 | Colombia | San Andres y Providencia | 6187 | 123 | 5982 | 82 | 12.5567 | -81.7185 | 2021-06-24 04:21:55 | San Andres y Providencia, Colombia | ||
562825 | 562825 | 2021-06-22 | Colombia | San Andres y Providencia | 6184 | 122 | 5965 | 97 | 12.5567 | -81.7185 | 2021-06-23 04:21:46 | San Andres y Providencia, Colombia | ||
3358527 | 3358527 | 2021-06-21 | Colombia | San Andres y Providencia | 6166 | 122 | 5940 | 104 | 12.5567 | -81.7185 | 2021-06-22 04:21:34 | San Andres y Providencia, Colombia | ||
2884226 | 2884226 | 2021-06-20 | Colombia | San Andres y Providencia | 6155 | 121 | 5931 | 103 | 12.5567 | -81.7185 | 2021-06-21 04:21:41 | San Andres y Providencia, Colombia | ||
107309 | 107309 | 2021-06-19 | Colombia | San Andres y Providencia | 6155 | 121 | 5922 | 112 | 12.5567 | -81.7185 | 2021-06-20 04:21:48 | San Andres y Providencia, Colombia | ||
1125452 | 1125452 | 2021-06-18 | Colombia | San Andres y Providencia | 6142 | 120 | 5890 | 132 | 12.5567 | -81.7185 | 2021-06-19 04:22:33 | San Andres y Providencia, Colombia | ||
2911030 | 2911030 | 2021-06-17 | Colombia | San Andres y Providencia | 6099 | 120 | 5850 | 129 | 12.5567 | -81.7185 | 2021-06-18 04:22:16 | San Andres y Providencia, Colombia | ||
3030148 | 3030148 | 2021-06-16 | Colombia | San Andres y Providencia | 6008 | 118 | 5816 | 74 | 12.5567 | -81.7185 | 2021-06-17 04:22:36 | San Andres y Providencia, Colombia | ||
2339254 | 2339254 | 2021-06-15 | Colombia | San Andres y Providencia | 5982 | 118 | 5790 | 74 | 12.5567 | -81.7185 | 2021-06-16 04:22:32 | San Andres y Providencia, Colombia | ||
1563950 | 1563950 | 2021-06-14 | Colombia | San Andres y Providencia | 5982 | 118 | 5790 | 74 | 12.5567 | -81.7185 | 2021-06-15 04:22:22 | San Andres y Providencia, Colombia | ||
3381233 | 3381233 | 2021-06-13 | Colombia | San Andres y Providencia | 5982 | 116 | 5782 | 84 | 12.5567 | -81.7185 | 2021-06-14 04:22:46 | San Andres y Providencia, Colombia | ||
1736367 | 1736367 | 2021-06-12 | Colombia | San Andres y Providencia | 5982 | 115 | 5761 | 106 | 12.5567 | -81.7185 | 2021-06-13 04:22:44 | San Andres y Providencia, Colombia | ||
3970408 | 3970408 | 2021-06-11 | Colombia | San Andres y Providencia | 5959 | 113 | 5737 | 109 | 12.5567 | -81.7185 | 2021-06-12 04:22:22 | San Andres y Providencia, Colombia | ||
2716830 | 2716830 | 2021-06-10 | Colombia | San Andres y Providencia | 5939 | 113 | 5686 | 140 | 12.5567 | -81.7185 | 2021-06-11 04:23:20 | San Andres y Providencia, Colombia | ||
522715 | 522715 | 2021-06-09 | Colombia | San Andres y Providencia | 5900 | 113 | 5661 | 126 | 12.5567 | -81.7185 | 2021-06-10 04:23:17 | San Andres y Providencia, Colombia | ||
3472155 | 3472155 | 2021-06-08 | Colombia | San Andres y Providencia | 5889 | 112 | 5622 | 155 | 12.5567 | -81.7185 | 2021-06-09 04:23:31 | San Andres y Providencia, Colombia | ||
3145439 | 3145439 | 2021-06-07 | Colombia | San Andres y Providencia | 5889 | 112 | 5622 | 155 | 12.5567 | -81.7185 | 2021-06-08 04:22:35 | San Andres y Providencia, Colombia |
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]);