johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "Pakistan" and province_or_state = "Gilgit-Baltistan" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
475 | 475 | 2021-12-02 | Pakistan | Gilgit-Baltistan | 10413 | 186 | 0 | 35.792146 | 74.982138 | 2021-12-03 04:23:05 | Gilgit-Baltistan, 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 | |||
16499 | 16499 | 2021-09-18 | Pakistan | Gilgit-Baltistan | 10240 | 182 | 0 | 35.792146 | 74.982138 | 2021-09-19 04:21:34 | Gilgit-Baltistan, 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 | |||
28561 | 28561 | 2021-11-11 | Pakistan | Gilgit-Baltistan | 10400 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-12 04:22:01 | Gilgit-Baltistan, 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 | |||
43853 | 43853 | 2021-11-02 | Pakistan | Gilgit-Baltistan | 10391 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-03 06:22:09 | Gilgit-Baltistan, 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 | |||
67205 | 67205 | 2021-09-01 | Pakistan | Gilgit-Baltistan | 9952 | 173 | 0 | 35.792146 | 74.982138 | 2021-09-02 04:21:15 | Gilgit-Baltistan, 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 | |||
87270 | 87270 | 2021-11-09 | Pakistan | Gilgit-Baltistan | 10395 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-10 04:21:38 | Gilgit-Baltistan, 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 | |||
99471 | 99471 | 2022-01-14 | Pakistan | Gilgit-Baltistan | 10439 | 186 | 0 | 35.792146 | 74.982138 | 2022-01-15 04:21:07 | Gilgit-Baltistan, 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 | |||
114898 | 114898 | 2022-09-06 | Pakistan | Gilgit-Baltistan | 12033 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-07 04:20:59 | Gilgit-Baltistan, Pakistan | |||
126878 | 126878 | 2022-01-09 | Pakistan | Gilgit-Baltistan | 10432 | 186 | 0 | 35.792146 | 74.982138 | 2022-01-10 04:22:07 | Gilgit-Baltistan, Pakistan | |||
130898 | 130898 | 2022-10-04 | Pakistan | Gilgit-Baltistan | 12059 | 191 | 0 | 35.792146 | 74.982138 | 2022-10-05 04:23:06 | Gilgit-Baltistan, Pakistan | |||
138116 | 138116 | 2021-12-04 | Pakistan | Gilgit-Baltistan | 10413 | 186 | 0 | 35.792146 | 74.982138 | 2021-12-05 04:22:25 | Gilgit-Baltistan, Pakistan | |||
142134 | 142134 | 2022-07-09 | Pakistan | Gilgit-Baltistan | 11770 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-10 04:20:54 | Gilgit-Baltistan, Pakistan | |||
150129 | 150129 | 2021-11-29 | Pakistan | Gilgit-Baltistan | 10411 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-30 04:22:53 | Gilgit-Baltistan, Pakistan | |||
158158 | 158158 | 2022-03-29 | Pakistan | Gilgit-Baltistan | 11700 | 191 | 0 | 35.792146 | 74.982138 | 2022-03-30 04:20:45 | Gilgit-Baltistan, Pakistan | |||
162173 | 162173 | 2021-11-19 | Pakistan | Gilgit-Baltistan | 10406 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-20 04:22:17 | Gilgit-Baltistan, Pakistan | |||
166191 | 166191 | 2022-06-21 | Pakistan | Gilgit-Baltistan | 11753 | 191 | 0 | 35.792146 | 74.982138 | 2022-06-22 04:20:54 | Gilgit-Baltistan, Pakistan | |||
178170 | 178170 | 2021-09-02 | Pakistan | Gilgit-Baltistan | 9993 | 174 | 0 | 35.792146 | 74.982138 | 2021-09-03 04:21:20 | Gilgit-Baltistan, Pakistan | |||
186216 | 186216 | 2022-02-13 | Pakistan | Gilgit-Baltistan | 11193 | 189 | 0 | 35.792146 | 74.982138 | 2022-02-14 04:20:51 | Gilgit-Baltistan, Pakistan | |||
198407 | 198407 | 2022-10-19 | Pakistan | Gilgit-Baltistan | 12059 | 191 | 0 | 35.792146 | 74.982138 | 2022-10-20 04:22:59 | Gilgit-Baltistan, Pakistan | |||
218128 | 218128 | 2022-12-26 | Pakistan | Gilgit-Baltistan | 12088 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-27 04:21:07 | Gilgit-Baltistan, Pakistan | |||
222141 | 222141 | 2022-05-09 | Pakistan | Gilgit-Baltistan | 11745 | 191 | 0 | 35.792146 | 74.982138 | 2022-05-10 04:20:50 | Gilgit-Baltistan, Pakistan | |||
229373 | 229373 | 2022-05-31 | Pakistan | Gilgit-Baltistan | 11749 | 191 | 0 | 35.792146 | 74.982138 | 2022-06-01 04:20:55 | Gilgit-Baltistan, Pakistan | |||
233388 | 233388 | 2022-02-11 | Pakistan | Gilgit-Baltistan | 11116 | 189 | 0 | 35.792146 | 74.982138 | 2022-02-12 04:21:06 | Gilgit-Baltistan, Pakistan | |||
245413 | 245413 | 2021-08-17 | Pakistan | Gilgit-Baltistan | 9482 | 168 | 0 | 35.792146 | 74.982138 | 2021-08-18 04:21:35 | Gilgit-Baltistan, Pakistan | |||
249427 | 249427 | 2021-09-04 | Pakistan | Gilgit-Baltistan | 10039 | 175 | 0 | 35.792146 | 74.982138 | 2021-09-05 04:21:33 | Gilgit-Baltistan, Pakistan | |||
253460 | 253460 | 2022-09-08 | Pakistan | Gilgit-Baltistan | 12036 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-09 04:21:11 | Gilgit-Baltistan, Pakistan | |||
257478 | 257478 | 2022-12-10 | Pakistan | Gilgit-Baltistan | 12085 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-11 04:20:50 | Gilgit-Baltistan, Pakistan | |||
261678 | 261678 | 2022-03-15 | Pakistan | Gilgit-Baltistan | 11648 | 191 | 0 | 35.792146 | 74.982138 | 2022-03-16 04:20:50 | Gilgit-Baltistan, Pakistan | |||
276328 | 276328 | 2021-11-03 | Pakistan | Gilgit-Baltistan | 10392 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-04 04:22:20 | Gilgit-Baltistan, Pakistan | |||
288141 | 288141 | 2021-10-31 | Pakistan | Gilgit-Baltistan | 10390 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-01 04:22:01 | Gilgit-Baltistan, Pakistan | |||
292161 | 292161 | 2022-11-15 | Pakistan | Gilgit-Baltistan | 12076 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-16 04:21:09 | Gilgit-Baltistan, Pakistan | |||
304014 | 304014 | 2022-04-16 | Pakistan | Gilgit-Baltistan | 11729 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-17 04:20:59 | Gilgit-Baltistan, Pakistan | |||
308033 | 308033 | 2022-12-13 | Pakistan | Gilgit-Baltistan | 12087 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-14 04:21:04 | Gilgit-Baltistan, Pakistan | |||
312049 | 312049 | 2022-11-13 | Pakistan | Gilgit-Baltistan | 12075 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-14 04:21:09 | Gilgit-Baltistan, Pakistan | |||
316062 | 316062 | 2022-02-12 | Pakistan | Gilgit-Baltistan | 11183 | 189 | 0 | 35.792146 | 74.982138 | 2022-02-13 04:21:00 | Gilgit-Baltistan, Pakistan | |||
320081 | 320081 | 2022-10-30 | Pakistan | Gilgit-Baltistan | 12070 | 191 | 0 | 35.792146 | 74.982138 | 2022-10-31 04:21:36 | Gilgit-Baltistan, Pakistan | |||
328055 | 328055 | 2022-12-27 | Pakistan | Gilgit-Baltistan | 12088 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-28 04:21:04 | Gilgit-Baltistan, Pakistan | |||
336082 | 336082 | 2022-03-18 | Pakistan | Gilgit-Baltistan | 11662 | 191 | 0 | 35.792146 | 74.982138 | 2022-03-19 04:20:47 | Gilgit-Baltistan, Pakistan | |||
348445 | 348445 | 2022-12-14 | Pakistan | Gilgit-Baltistan | 12087 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-15 04:20:58 | Gilgit-Baltistan, Pakistan | |||
356472 | 356472 | 2022-03-11 | Pakistan | Gilgit-Baltistan | 11620 | 191 | 0 | 35.792146 | 74.982138 | 2022-03-12 04:20:50 | Gilgit-Baltistan, Pakistan | |||
360488 | 360488 | 2022-05-07 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-05-08 04:20:49 | Gilgit-Baltistan, Pakistan | |||
372345 | 372345 | 2022-09-13 | Pakistan | Gilgit-Baltistan | 12041 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-14 04:20:44 | Gilgit-Baltistan, Pakistan | |||
384372 | 384372 | 2022-09-23 | Pakistan | Gilgit-Baltistan | 12056 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-24 04:21:40 | Gilgit-Baltistan, Pakistan | |||
396413 | 396413 | 2022-10-07 | Pakistan | Gilgit-Baltistan | 12059 | 191 | 0 | 35.792146 | 74.982138 | 2022-10-08 04:22:56 | Gilgit-Baltistan, Pakistan | |||
404439 | 404439 | 2021-12-07 | Pakistan | Gilgit-Baltistan | 10414 | 186 | 0 | 35.792146 | 74.982138 | 2021-12-08 04:22:46 | Gilgit-Baltistan, Pakistan | |||
419484 | 419484 | 2022-09-18 | Pakistan | Gilgit-Baltistan | 12056 | 191 | 0 | 35.792146 | 74.982138 | 2022-09-19 04:21:49 | Gilgit-Baltistan, Pakistan | |||
423496 | 423496 | 2021-10-10 | Pakistan | Gilgit-Baltistan | 10350 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-11 04:21:31 | Gilgit-Baltistan, Pakistan | |||
431506 | 431506 | 2022-11-03 | Pakistan | Gilgit-Baltistan | 12071 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-04 04:22:11 | Gilgit-Baltistan, Pakistan | |||
443500 | 443500 | 2021-10-20 | Pakistan | Gilgit-Baltistan | 10374 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-21 04:21:18 | Gilgit-Baltistan, Pakistan | |||
447516 | 447516 | 2021-11-17 | Pakistan | Gilgit-Baltistan | 10404 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-18 04:21:33 | Gilgit-Baltistan, Pakistan | |||
451536 | 451536 | 2022-12-21 | Pakistan | Gilgit-Baltistan | 12087 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-22 04:20:56 | Gilgit-Baltistan, Pakistan | |||
459525 | 459525 | 2022-02-02 | Pakistan | Gilgit-Baltistan | 10768 | 189 | 0 | 35.792146 | 74.982138 | 2022-02-03 04:21:21 | Gilgit-Baltistan, Pakistan | |||
463542 | 463542 | 2022-05-02 | Pakistan | Gilgit-Baltistan | 11737 | 191 | 0 | 35.792146 | 74.982138 | 2022-05-03 04:21:00 | Gilgit-Baltistan, Pakistan | |||
467557 | 467557 | 2021-10-07 | Pakistan | Gilgit-Baltistan | 10341 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-08 04:21:25 | Gilgit-Baltistan, Pakistan | |||
475589 | 475589 | 2022-06-26 | Pakistan | Gilgit-Baltistan | 11759 | 191 | 0 | 35.792146 | 74.982138 | 2022-06-27 04:21:00 | Gilgit-Baltistan, Pakistan | |||
479739 | 479739 | 2022-11-08 | Pakistan | Gilgit-Baltistan | 12072 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-09 04:21:22 | Gilgit-Baltistan, Pakistan | |||
487769 | 487769 | 2022-11-25 | Pakistan | Gilgit-Baltistan | 12078 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-26 04:21:11 | Gilgit-Baltistan, Pakistan | |||
491781 | 491781 | 2021-10-14 | Pakistan | Gilgit-Baltistan | 10363 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-15 04:21:26 | Gilgit-Baltistan, Pakistan | |||
495797 | 495797 | 2021-11-06 | Pakistan | Gilgit-Baltistan | 10394 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-07 04:21:53 | Gilgit-Baltistan, Pakistan | |||
499814 | 499814 | 2022-04-02 | Pakistan | Gilgit-Baltistan | 11710 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-03 04:20:48 | Gilgit-Baltistan, Pakistan | |||
503833 | 503833 | 2022-12-17 | Pakistan | Gilgit-Baltistan | 12087 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-18 04:21:03 | Gilgit-Baltistan, Pakistan | |||
507828 | 507828 | 2021-08-14 | Pakistan | Gilgit-Baltistan | 9316 | 163 | 0 | 35.792146 | 74.982138 | 2021-08-15 04:21:41 | Gilgit-Baltistan, Pakistan | |||
511842 | 511842 | 2021-08-19 | Pakistan | Gilgit-Baltistan | 9526 | 169 | 0 | 35.792146 | 74.982138 | 2021-08-20 04:21:33 | Gilgit-Baltistan, Pakistan | |||
515877 | 515877 | 2022-10-15 | Pakistan | Gilgit-Baltistan | 12059 | 191 | 0 | 35.792146 | 74.982138 | 2022-10-16 04:22:39 | Gilgit-Baltistan, Pakistan | |||
534881 | 534881 | 2021-10-27 | Pakistan | Gilgit-Baltistan | 10387 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-28 04:22:08 | Gilgit-Baltistan, Pakistan | |||
538901 | 538901 | 2022-10-26 | Pakistan | Gilgit-Baltistan | 12059 | 191 | 0 | 35.792146 | 74.982138 | 2022-10-27 04:22:01 | Gilgit-Baltistan, Pakistan | |||
542917 | 542917 | 2022-12-15 | Pakistan | Gilgit-Baltistan | 12087 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-16 04:21:01 | Gilgit-Baltistan, Pakistan | |||
550919 | 550919 | 2021-12-08 | Pakistan | Gilgit-Baltistan | 10422 | 186 | 0 | 35.792146 | 74.982138 | 2021-12-09 04:22:49 | Gilgit-Baltistan, Pakistan | |||
554935 | 554935 | 2022-01-16 | Pakistan | Gilgit-Baltistan | 10445 | 187 | 0 | 35.792146 | 74.982138 | 2022-01-17 04:21:08 | Gilgit-Baltistan, Pakistan | |||
558953 | 558953 | 2022-06-16 | Pakistan | Gilgit-Baltistan | 11753 | 191 | 0 | 35.792146 | 74.982138 | 2022-06-17 04:20:56 | Gilgit-Baltistan, Pakistan | |||
567249 | 567249 | 2021-10-29 | Pakistan | Gilgit-Baltistan | 10390 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-30 04:22:03 | Gilgit-Baltistan, Pakistan | |||
574978 | 574978 | 2022-02-25 | Pakistan | Gilgit-Baltistan | 11461 | 190 | 0 | 35.792146 | 74.982138 | 2022-02-26 04:21:12 | Gilgit-Baltistan, Pakistan | |||
589772 | 589772 | 2021-08-08 | Pakistan | Gilgit-Baltistan | 8796 | 153 | 0 | 35.792146 | 74.982138 | 2021-08-09 04:21:24 | Gilgit-Baltistan, Pakistan | |||
593805 | 593805 | 2022-07-01 | Pakistan | Gilgit-Baltistan | 11761 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-02 04:21:16 | Gilgit-Baltistan, Pakistan | |||
597819 | 597819 | 2021-10-19 | Pakistan | Gilgit-Baltistan | 10370 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-20 04:21:00 | Gilgit-Baltistan, Pakistan | |||
601835 | 601835 | 2021-09-23 | Pakistan | Gilgit-Baltistan | 10286 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-24 04:21:44 | Gilgit-Baltistan, Pakistan | |||
618011 | 618011 | 2022-11-05 | Pakistan | Gilgit-Baltistan | 12071 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-06 04:21:24 | Gilgit-Baltistan, Pakistan | |||
622025 | 622025 | 2022-05-22 | Pakistan | Gilgit-Baltistan | 11748 | 191 | 0 | 35.792146 | 74.982138 | 2022-05-26 04:20:50 | Gilgit-Baltistan, Pakistan | |||
630055 | 630055 | 2022-07-12 | Pakistan | Gilgit-Baltistan | 11770 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-13 04:20:58 | Gilgit-Baltistan, Pakistan | |||
634069 | 634069 | 2021-10-13 | Pakistan | Gilgit-Baltistan | 10361 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-14 04:21:29 | Gilgit-Baltistan, Pakistan | |||
642082 | 642082 | 2021-09-07 | Pakistan | Gilgit-Baltistan | 10084 | 179 | 0 | 35.792146 | 74.982138 | 2021-09-08 04:21:31 | Gilgit-Baltistan, Pakistan | |||
650110 | 650110 | 2021-08-09 | Pakistan | Gilgit-Baltistan | 8876 | 157 | 0 | 35.792146 | 74.982138 | 2021-08-10 04:21:27 | Gilgit-Baltistan, Pakistan | |||
654141 | 654141 | 2021-10-22 | Pakistan | Gilgit-Baltistan | 10382 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-23 04:21:32 | Gilgit-Baltistan, Pakistan | |||
658460 | 658460 | 2022-05-13 | Pakistan | Gilgit-Baltistan | 11745 | 191 | 0 | 35.792146 | 74.982138 | 2022-05-14 04:20:48 | Gilgit-Baltistan, Pakistan | |||
670446 | 670446 | 2022-07-21 | Pakistan | Gilgit-Baltistan | 11810 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-22 04:21:15 | Gilgit-Baltistan, Pakistan | |||
674462 | 674462 | 2022-07-30 | Pakistan | Gilgit-Baltistan | 11870 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-31 04:21:02 | Gilgit-Baltistan, Pakistan | |||
682486 | 682486 | 2021-10-24 | Pakistan | Gilgit-Baltistan | 10383 | 186 | 0 | 35.792146 | 74.982138 | 2021-10-25 04:22:31 | Gilgit-Baltistan, Pakistan | |||
686502 | 686502 | 2021-11-13 | Pakistan | Gilgit-Baltistan | 10400 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-14 04:21:31 | Gilgit-Baltistan, Pakistan | |||
690522 | 690522 | 2022-12-23 | Pakistan | Gilgit-Baltistan | 12088 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-24 04:21:02 | Gilgit-Baltistan, Pakistan | |||
694535 | 694535 | 2022-03-17 | Pakistan | Gilgit-Baltistan | 11657 | 191 | 0 | 35.792146 | 74.982138 | 2022-03-18 04:20:55 | Gilgit-Baltistan, Pakistan | |||
698550 | 698550 | 2021-11-04 | Pakistan | Gilgit-Baltistan | 10392 | 186 | 0 | 35.792146 | 74.982138 | 2021-11-05 04:21:54 | Gilgit-Baltistan, Pakistan | |||
706580 | 706580 | 2021-09-29 | Pakistan | Gilgit-Baltistan | 10321 | 184 | 0 | 35.792146 | 74.982138 | 2021-09-30 04:21:20 | Gilgit-Baltistan, Pakistan | |||
710599 | 710599 | 2022-11-01 | Pakistan | Gilgit-Baltistan | 12070 | 191 | 0 | 35.792146 | 74.982138 | 2022-11-02 04:22:09 | Gilgit-Baltistan, 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]);