johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
6,636 rows where country_or_region = "Pakistan" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, combined_key, day (date)
last_update (date) >30 ✖
- 2022-04-13 14
- 2022-05-26 14
- 2020-06-11 7
- 2020-06-12 7
- 2020-06-13 7
- 2020-06-14 7
- 2020-06-15 7
- 2020-06-16 7
- 2020-06-17 7
- 2020-06-18 7
- 2020-06-19 7
- 2020-06-20 7
- 2020-06-21 7
- 2020-06-22 7
- 2020-06-23 7
- 2020-06-24 7
- 2020-06-25 7
- 2020-06-26 7
- 2020-06-27 7
- 2020-06-28 7
- 2020-06-29 7
- 2020-06-30 7
- 2020-07-01 7
- 2020-07-02 7
- 2020-07-03 7
- 2020-07-04 7
- 2020-07-05 7
- 2020-07-06 7
- 2020-07-07 7
- 2020-07-08 7
- …
province_or_state 7
- Azad Jammu and Kashmir 933
- Balochistan 933
- Gilgit-Baltistan 933
- Islamabad 933
- Khyber Pakhtunkhwa 933
- Punjab 933
- Sindh 933
country_or_region 1
- Pakistan · 6,636 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
473 | 473 | 2021-12-02 | Pakistan | Azad Jammu and Kashmir | 34570 | 742 | 0 | 34.027401 | 73.947253 | 2021-12-03 04:23:05 | Azad Jammu and Kashmir, Pakistan | |||
474 | 474 | 2021-12-02 | Pakistan | Balochistan | 33491 | 360 | 0 | 28.328491999999997 | 65.898403 | 2021-12-03 04:23:05 | Balochistan, Pakistan | |||
475 | 475 | 2021-12-02 | Pakistan | Gilgit-Baltistan | 10413 | 186 | 0 | 35.792146 | 74.982138 | 2021-12-03 04:23:05 | Gilgit-Baltistan, Pakistan | |||
476 | 476 | 2021-12-02 | Pakistan | Islamabad | 107811 | 957 | 0 | 33.665087 | 73.121219 | 2021-12-03 04:23:05 | Islamabad, Pakistan | |||
477 | 477 | 2021-12-02 | Pakistan | Khyber Pakhtunkhwa | 180194 | 5855 | 0 | 34.485332 | 72.09169 | 2021-12-03 04:23:05 | Khyber Pakhtunkhwa, Pakistan | |||
478 | 478 | 2021-12-02 | Pakistan | Punjab | 443310 | 13031 | 0 | 30.811346 | 72.13913199999998 | 2021-12-03 04:23:05 | Punjab, Pakistan | |||
479 | 479 | 2021-12-02 | Pakistan | Sindh | 476233 | 7622 | 0 | 26.009446 | 68.77680699999999 | 2021-12-03 04:23:05 | Sindh, Pakistan | |||
4489 | 4489 | 2021-10-28 | Pakistan | Azad Jammu and Kashmir | 34461 | 740 | 0 | 34.027401 | 73.947253 | 2021-10-29 04:22:03 | Azad Jammu and Kashmir, Pakistan | |||
4490 | 4490 | 2021-10-28 | Pakistan | Balochistan | 33228 | 356 | 0 | 28.328491999999997 | 65.898403 | 2021-10-29 04:22:03 | Balochistan, Pakistan | |||
4491 | 4491 | 2021-10-28 | Pakistan | Gilgit-Baltistan | 10389 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-29 04:22:03 | Gilgit-Baltistan, Pakistan | |||
4492 | 4492 | 2021-10-28 | Pakistan | Islamabad | 106835 | 939 | 0 | 33.665087 | 73.121219 | 2021-10-29 04:22:03 | Islamabad, Pakistan | |||
4493 | 4493 | 2021-10-28 | Pakistan | Khyber Pakhtunkhwa | 177807 | 5738 | 0 | 34.485332 | 72.09169 | 2021-10-29 04:22:03 | Khyber Pakhtunkhwa, Pakistan | |||
4494 | 4494 | 2021-10-28 | Pakistan | Punjab | 439845 | 12909 | 0 | 30.811346 | 72.13913199999998 | 2021-10-29 04:22:03 | Punjab, Pakistan | |||
4495 | 4495 | 2021-10-28 | Pakistan | Sindh | 469122 | 7563 | 0 | 26.009446 | 68.77680699999999 | 2021-10-29 04:22:03 | Sindh, Pakistan | |||
16497 | 16497 | 2021-09-18 | Pakistan | Azad Jammu and Kashmir | 33732 | 729 | 0 | 34.027401 | 73.947253 | 2021-09-19 04:21:34 | Azad Jammu and Kashmir, Pakistan | |||
16498 | 16498 | 2021-09-18 | Pakistan | Balochistan | 32757 | 344 | 0 | 28.328491999999997 | 65.898403 | 2021-09-19 04:21:34 | Balochistan, Pakistan | |||
16499 | 16499 | 2021-09-18 | Pakistan | Gilgit-Baltistan | 10240 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-19 04:21:34 | Gilgit-Baltistan, Pakistan | |||
16500 | 16500 | 2021-09-18 | Pakistan | Islamabad | 104114 | 902 | 0 | 33.665087 | 73.121219 | 2021-09-19 04:21:34 | Islamabad, Pakistan | |||
16501 | 16501 | 2021-09-18 | Pakistan | Khyber Pakhtunkhwa | 171072 | 5395 | 0 | 34.485332 | 72.09169 | 2021-09-19 04:21:34 | Khyber Pakhtunkhwa, Pakistan | |||
16502 | 16502 | 2021-09-18 | Pakistan | Punjab | 421800 | 12396 | 0 | 30.811346 | 72.13913199999998 | 2021-09-19 04:21:34 | Punjab, Pakistan | |||
16503 | 16503 | 2021-09-18 | Pakistan | Sindh | 450126 | 7258 | 0 | 26.009446 | 68.77680699999999 | 2021-09-19 04:21:34 | Sindh, Pakistan | |||
24544 | 24544 | 2022-03-20 | Pakistan | Azad Jammu and Kashmir | 43220 | 792 | 0 | 34.027401 | 73.947253 | 2022-03-21 04:20:50 | Azad Jammu and Kashmir, Pakistan | |||
24545 | 24545 | 2022-03-20 | Pakistan | Balochistan | 35458 | 378 | 0 | 28.328491999999997 | 65.898403 | 2022-03-21 04:20:50 | Balochistan, Pakistan | |||
24546 | 24546 | 2022-03-20 | Pakistan | Gilgit-Baltistan | 11666 | 191 | 0 | 35.792146 | 74.982138 | 2022-03-21 04:20:50 | Gilgit-Baltistan, Pakistan | |||
24547 | 24547 | 2022-03-20 | Pakistan | Islamabad | 134963 | 1022 | 0 | 33.665087 | 73.121219 | 2022-03-21 04:20:50 | Islamabad, Pakistan | |||
24548 | 24548 | 2022-03-20 | Pakistan | Khyber Pakhtunkhwa | 218689 | 6307 | 0 | 34.485332 | 72.09169 | 2022-03-21 04:20:50 | Khyber Pakhtunkhwa, Pakistan | |||
24549 | 24549 | 2022-03-20 | Pakistan | Punjab | 504442 | 13550 | 0 | 30.811346 | 72.13913199999998 | 2022-03-21 04:20:50 | Punjab, Pakistan | |||
24550 | 24550 | 2022-03-20 | Pakistan | Sindh | 573753 | 8091 | 0 | 26.009446 | 68.77680699999999 | 2022-03-21 04:20:50 | Sindh, Pakistan | |||
28559 | 28559 | 2021-11-11 | Pakistan | Azad Jammu and Kashmir | 34501 | 741 | 0 | 34.027401 | 73.947253 | 2021-11-12 04:22:01 | Azad Jammu and Kashmir, Pakistan | |||
28560 | 28560 | 2021-11-11 | Pakistan | Balochistan | 33383 | 358 | 0 | 28.328491999999997 | 65.898403 | 2021-11-12 04:22:01 | Balochistan, Pakistan | |||
28561 | 28561 | 2021-11-11 | Pakistan | Gilgit-Baltistan | 10400 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-12 04:22:01 | Gilgit-Baltistan, Pakistan | |||
28562 | 28562 | 2021-11-11 | Pakistan | Islamabad | 107249 | 947 | 0 | 33.665087 | 73.121219 | 2021-11-12 04:22:01 | Islamabad, Pakistan | |||
28563 | 28563 | 2021-11-11 | Pakistan | Khyber Pakhtunkhwa | 178926 | 5786 | 0 | 34.485332 | 72.09169 | 2021-11-12 04:22:01 | Khyber Pakhtunkhwa, Pakistan | |||
28564 | 28564 | 2021-11-11 | Pakistan | Punjab | 441631 | 12967 | 0 | 30.811346 | 72.13913199999998 | 2021-11-12 04:22:01 | Punjab, Pakistan | |||
28565 | 28565 | 2021-11-11 | Pakistan | Sindh | 473052 | 7599 | 0 | 26.009446 | 68.77680699999999 | 2021-11-12 04:22:01 | Sindh, Pakistan | |||
32558 | 32558 | 2021-08-25 | Pakistan | Azad Jammu and Kashmir | 31294 | 688 | 0 | 34.027401 | 73.947253 | 2021-08-26 04:21:28 | Azad Jammu and Kashmir, Pakistan | |||
32559 | 32559 | 2021-08-25 | Pakistan | Balochistan | 32014 | 338 | 0 | 28.328491999999997 | 65.898403 | 2021-08-26 04:21:28 | Balochistan, Pakistan | |||
32560 | 32560 | 2021-08-25 | Pakistan | Gilgit-Baltistan | 9769 | 171 | 0 | 35.792146 | 74.982138 | 2021-08-26 04:21:28 | Gilgit-Baltistan, Pakistan | |||
32561 | 32561 | 2021-08-25 | Pakistan | Islamabad | 97542 | 856 | 0 | 33.665087 | 73.121219 | 2021-08-26 04:21:28 | Islamabad, Pakistan | |||
32562 | 32562 | 2021-08-25 | Pakistan | Khyber Pakhtunkhwa | 158964 | 4859 | 0 | 34.485332 | 72.09169 | 2021-08-26 04:21:28 | Khyber Pakhtunkhwa, Pakistan | |||
32563 | 32563 | 2021-08-25 | Pakistan | Punjab | 385258 | 11666 | 0 | 30.811346 | 72.13913199999998 | 2021-08-26 04:21:28 | Punjab, Pakistan | |||
32564 | 32564 | 2021-08-25 | Pakistan | Sindh | 425570 | 6742 | 0 | 26.009446 | 68.77680699999999 | 2021-08-26 04:21:28 | Sindh, Pakistan | |||
40218 | 40218 | 2020-03-05 | Pakistan | 5 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-03T04:33:03 | |||||
43851 | 43851 | 2021-11-02 | Pakistan | Azad Jammu and Kashmir | 34487 | 741 | 0 | 34.027401 | 73.947253 | 2021-11-03 06:22:09 | Azad Jammu and Kashmir, Pakistan | |||
43852 | 43852 | 2021-11-02 | Pakistan | Balochistan | 33274 | 356 | 0 | 28.328491999999997 | 65.898403 | 2021-11-03 06:22:09 | Balochistan, Pakistan | |||
43853 | 43853 | 2021-11-02 | Pakistan | Gilgit-Baltistan | 10391 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-03 06:22:09 | Gilgit-Baltistan, Pakistan | |||
43854 | 43854 | 2021-11-02 | Pakistan | Islamabad | 106990 | 940 | 0 | 33.665087 | 73.121219 | 2021-11-03 06:22:09 | Islamabad, Pakistan | |||
43855 | 43855 | 2021-11-02 | Pakistan | Khyber Pakhtunkhwa | 178204 | 5754 | 0 | 34.485332 | 72.09169 | 2021-11-03 06:22:09 | Khyber Pakhtunkhwa, Pakistan | |||
43856 | 43856 | 2021-11-02 | Pakistan | Punjab | 440542 | 12929 | 0 | 30.811346 | 72.13913199999998 | 2021-11-03 06:22:09 | Punjab, Pakistan | |||
43857 | 43857 | 2021-11-02 | Pakistan | Sindh | 470690 | 7571 | 0 | 26.009446 | 68.77680699999999 | 2021-11-03 06:22:09 | Sindh, Pakistan | |||
62568 | 62568 | 2020-03-07 | Pakistan | 6 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-06T13:03:12 | |||||
63208 | 63208 | 2022-11-12 | Pakistan | Azad Jammu and Kashmir | 44333 | 793 | 0 | 34.027401 | 73.947253 | 2022-11-13 04:21:14 | Azad Jammu and Kashmir, Pakistan | |||
63209 | 63209 | 2022-11-12 | Pakistan | Balochistan | 36022 | 378 | 0 | 28.328492 | 65.898403 | 2022-11-13 04:21:14 | Balochistan, Pakistan | |||
63210 | 63210 | 2022-11-12 | Pakistan | Gilgit-Baltistan | 12075 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-13 04:21:14 | Gilgit-Baltistan, Pakistan | |||
63211 | 63211 | 2022-11-12 | Pakistan | Islamabad | 139559 | 1031 | 0 | 33.665087 | 73.121219 | 2022-11-13 04:21:14 | Islamabad, Pakistan | |||
63212 | 63212 | 2022-11-12 | Pakistan | Khyber Pakhtunkhwa | 224580 | 6372 | 0 | 34.485332 | 72.09169 | 2022-11-13 04:21:14 | Khyber Pakhtunkhwa, Pakistan | |||
63213 | 63213 | 2022-11-12 | Pakistan | Punjab | 522880 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-13 04:21:14 | Punjab, Pakistan | |||
63214 | 63214 | 2022-11-12 | Pakistan | Sindh | 595189 | 8248 | 0 | 26.009446 | 68.776807 | 2022-11-13 04:21:14 | Sindh, Pakistan | |||
67203 | 67203 | 2021-09-01 | Pakistan | Azad Jammu and Kashmir | 32380 | 702 | 0 | 34.027401 | 73.947253 | 2021-09-02 04:21:15 | Azad Jammu and Kashmir, Pakistan | |||
67204 | 67204 | 2021-09-01 | Pakistan | Balochistan | 32248 | 339 | 0 | 28.328491999999997 | 65.898403 | 2021-09-02 04:21:15 | Balochistan, Pakistan | |||
67205 | 67205 | 2021-09-01 | Pakistan | Gilgit-Baltistan | 9952 | 173 | 0 | 35.792146 | 74.982138 | 2021-09-02 04:21:15 | Gilgit-Baltistan, Pakistan | |||
67206 | 67206 | 2021-09-01 | Pakistan | Islamabad | 99910 | 866 | 0 | 33.665087 | 73.121219 | 2021-09-02 04:21:15 | Islamabad, Pakistan | |||
67207 | 67207 | 2021-09-01 | Pakistan | Khyber Pakhtunkhwa | 163010 | 5015 | 0 | 34.485332 | 72.09169 | 2021-09-02 04:21:15 | Khyber Pakhtunkhwa, Pakistan | |||
67208 | 67208 | 2021-09-01 | Pakistan | Punjab | 396326 | 11959 | 0 | 30.811346 | 72.13913199999998 | 2021-09-02 04:21:15 | Punjab, Pakistan | |||
67209 | 67209 | 2021-09-01 | Pakistan | Sindh | 433931 | 6924 | 0 | 26.009446 | 68.77680699999999 | 2021-09-02 04:21:15 | Sindh, Pakistan | |||
71234 | 71234 | 2022-02-07 | Pakistan | Azad Jammu and Kashmir | 40826 | 764 | 0 | 34.027401 | 73.947253 | 2022-02-08 04:21:15 | Azad Jammu and Kashmir, Pakistan | |||
71235 | 71235 | 2022-02-07 | Pakistan | Balochistan | 34853 | 372 | 0 | 28.328491999999997 | 65.898403 | 2022-02-08 04:21:15 | Balochistan, Pakistan | |||
71236 | 71236 | 2022-02-07 | Pakistan | Gilgit-Baltistan | 10945 | 189 | 0 | 35.792146 | 74.982138 | 2022-02-08 04:21:15 | Gilgit-Baltistan, Pakistan | |||
71237 | 71237 | 2022-02-07 | Pakistan | Islamabad | 131987 | 990 | 0 | 33.665087 | 73.121219 | 2022-02-08 04:21:15 | Islamabad, Pakistan | |||
71238 | 71238 | 2022-02-07 | Pakistan | Khyber Pakhtunkhwa | 204084 | 6065 | 0 | 34.485332 | 72.09169 | 2022-02-08 04:21:15 | Khyber Pakhtunkhwa, Pakistan | |||
71239 | 71239 | 2022-02-07 | Pakistan | Punjab | 490103 | 13267 | 0 | 30.811346 | 72.13913199999998 | 2022-02-08 04:21:15 | Punjab, Pakistan | |||
71240 | 71240 | 2022-02-07 | Pakistan | Sindh | 553112 | 7906 | 0 | 26.009446 | 68.77680699999999 | 2022-02-08 04:21:15 | Sindh, Pakistan | |||
87268 | 87268 | 2021-11-09 | Pakistan | Azad Jammu and Kashmir | 34495 | 741 | 0 | 34.027401 | 73.947253 | 2021-11-10 04:21:38 | Azad Jammu and Kashmir, Pakistan | |||
87269 | 87269 | 2021-11-09 | Pakistan | Balochistan | 33356 | 358 | 0 | 28.328491999999997 | 65.898403 | 2021-11-10 04:21:38 | Balochistan, Pakistan | |||
87270 | 87270 | 2021-11-09 | Pakistan | Gilgit-Baltistan | 10395 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-10 04:21:38 | Gilgit-Baltistan, Pakistan | |||
87271 | 87271 | 2021-11-09 | Pakistan | Islamabad | 107198 | 947 | 0 | 33.665087 | 73.121219 | 2021-11-10 04:21:38 | Islamabad, Pakistan | |||
87272 | 87272 | 2021-11-09 | Pakistan | Khyber Pakhtunkhwa | 178773 | 5778 | 0 | 34.485332 | 72.09169 | 2021-11-10 04:21:38 | Khyber Pakhtunkhwa, Pakistan | |||
87273 | 87273 | 2021-11-09 | Pakistan | Punjab | 441378 | 12957 | 0 | 30.811346 | 72.13913199999998 | 2021-11-10 04:21:38 | Punjab, Pakistan | |||
87274 | 87274 | 2021-11-09 | Pakistan | Sindh | 472519 | 7599 | 0 | 26.009446 | 68.77680699999999 | 2021-11-10 04:21:38 | Sindh, Pakistan | |||
91286 | 91286 | 2022-07-23 | Pakistan | Azad Jammu and Kashmir | 43515 | 793 | 0 | 34.027401 | 73.947253 | 2022-07-24 04:20:47 | Azad Jammu and Kashmir, Pakistan | |||
91287 | 91287 | 2022-07-23 | Pakistan | Balochistan | 35735 | 378 | 0 | 28.328492 | 65.898403 | 2022-07-24 04:20:47 | Balochistan, Pakistan | |||
91288 | 91288 | 2022-07-23 | Pakistan | Gilgit-Baltistan | 11825 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-24 04:20:47 | Gilgit-Baltistan, Pakistan | |||
91289 | 91289 | 2022-07-23 | Pakistan | Islamabad | 137120 | 1027 | 0 | 33.665087 | 73.121219 | 2022-07-24 04:20:47 | Islamabad, Pakistan | |||
91290 | 91290 | 2022-07-23 | Pakistan | Khyber Pakhtunkhwa | 220863 | 6328 | 0 | 34.485332 | 72.09169 | 2022-07-24 04:20:47 | Khyber Pakhtunkhwa, Pakistan | |||
91291 | 91291 | 2022-07-23 | Pakistan | Punjab | 511548 | 13586 | 0 | 30.811346 | 72.139132 | 2022-07-24 04:20:47 | Punjab, Pakistan | |||
91292 | 91292 | 2022-07-23 | Pakistan | Sindh | 589692 | 8164 | 0 | 26.009446 | 68.776807 | 2022-07-24 04:20:47 | Sindh, Pakistan | |||
98885 | 98885 | 2020-03-04 | Pakistan | 5 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-03T04:33:03 | |||||
99469 | 99469 | 2022-01-14 | Pakistan | Azad Jammu and Kashmir | 34739 | 749 | 0 | 34.027401 | 73.947253 | 2022-01-15 04:21:07 | Azad Jammu and Kashmir, Pakistan | |||
99470 | 99470 | 2022-01-14 | Pakistan | Balochistan | 33684 | 367 | 0 | 28.328491999999997 | 65.898403 | 2022-01-15 04:21:07 | Balochistan, Pakistan | |||
99471 | 99471 | 2022-01-14 | Pakistan | Gilgit-Baltistan | 10439 | 186 | 0 | 35.792146 | 74.982138 | 2022-01-15 04:21:07 | Gilgit-Baltistan, Pakistan | |||
99472 | 99472 | 2022-01-14 | Pakistan | Islamabad | 110597 | 968 | 0 | 33.665087 | 73.121219 | 2022-01-15 04:21:07 | Islamabad, Pakistan | |||
99473 | 99473 | 2022-01-14 | Pakistan | Khyber Pakhtunkhwa | 182100 | 5953 | 0 | 34.485332 | 72.09169 | 2022-01-15 04:21:07 | Khyber Pakhtunkhwa, Pakistan | |||
99474 | 99474 | 2022-01-14 | Pakistan | Punjab | 451408 | 13087 | 0 | 30.811346 | 72.13913199999998 | 2022-01-15 04:21:07 | Punjab, Pakistan | |||
99475 | 99475 | 2022-01-14 | Pakistan | Sindh | 497153 | 7693 | 0 | 26.009446 | 68.77680699999999 | 2022-01-15 04:21:07 | Sindh, Pakistan | |||
103468 | 103468 | 2021-08-15 | Pakistan | Azad Jammu and Kashmir | 29452 | 666 | 0 | 34.027401 | 73.947253 | 2021-08-16 04:21:31 | Azad Jammu and Kashmir, Pakistan | |||
103469 | 103469 | 2021-08-15 | Pakistan | Balochistan | 31583 | 335 | 0 | 28.328491999999997 | 65.898403 | 2021-08-16 04:21:31 | Balochistan, Pakistan | |||
103470 | 103470 | 2021-08-15 | Pakistan | Gilgit-Baltistan | 9396 | 164 | 0 | 35.792146 | 74.982138 | 2021-08-16 04:21:31 | Gilgit-Baltistan, Pakistan | |||
103471 | 103471 | 2021-08-15 | Pakistan | Islamabad | 94108 | 834 | 0 | 33.665087 | 73.121219 | 2021-08-16 04:21:31 | Islamabad, Pakistan | |||
103472 | 103472 | 2021-08-15 | Pakistan | Khyber Pakhtunkhwa | 152625 | 4668 | 0 | 34.485332 | 72.09169 | 2021-08-16 04:21:31 | Khyber Pakhtunkhwa, Pakistan | |||
103473 | 103473 | 2021-08-15 | Pakistan | Punjab | 372750 | 11372 | 0 | 30.811346 | 72.13913199999998 | 2021-08-16 04:21:31 | Punjab, Pakistan |
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]);