johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Gunma" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, latitude, last_update, day (date), last_update (date)
active 267 ✖
- 3 15
- 2 9
- 43 6
- 51 6
- 12 5
- 45 5
- 85 5
- 200 4
- 4 4
- 41 4
- 5 4
- 6 4
- 60 4
- 8 4
- 116 3
- 198 3
- 393 3
- 410 3
- 46 3
- 47 3
- 48 3
- 589 3
- 71 3
- 81 3
- 9 3
- 95 3
- 10 2
- 105 2
- 113 2
- 118 2
- 129 2
- 130 2
- 135 2
- 136 2
- 139 2
- 14 2
- 141 2
- 144 2
- 145 2
- 146 2
- 147 2
- 148 2
- 150 2
- 156 2
- 158 2
- 168 2
- 177 2
- 186 2
- 190 2
- 191 2
- 20 2
- 204 2
- 207 2
- 21 2
- 213 2
- 214 2
- 224 2
- 227 2
- 238 2
- 24 2
- 250 2
- 265 2
- 285 2
- 301 2
- 304 2
- 32 2
- 331 2
- 340 2
- 342 2
- 35 2
- 353 2
- 369 2
- 372 2
- 373 2
- 38 2
- 381 2
- 390 2
- 430 2
- 434 2
- 446 2
- 49 2
- 50 2
- 52 2
- 54 2
- 55 2
- 56 2
- 57 2
- 570 2
- 58 2
- 587 2
- 61 2
- 62 2
- 64 2
- 651 2
- 67 2
- 68 2
- 75 2
- 78 2
- 782 2
- 79 2
- 88 2
- 94 2
- 96 2
- 97 2
- 100 1
- 102 1
- 103 1
- 104 1
- 106 1
- 107 1
- 108 1
- 11 1
- 110 1
- 114 1
- 115 1
- 117 1
- 123 1
- 125 1
- 127 1
- 13 1
- 134 1
- 138 1
- 143 1
- 152 1
- 157 1
- 159 1
- 163 1
- 167 1
- 169 1
- 171 1
- 176 1
- 179 1
- 18 1
- 185 1
- 187 1
- 188 1
- 192 1
- 193 1
- 194 1
- 199 1
- 206 1
- 211 1
- 218 1
- 22 1
- 220 1
- 221 1
- 228 1
- 229 1
- 230 1
- 235 1
- 239 1
- 240 1
- 246 1
- 247 1
- 254 1
- 257 1
- 262 1
- 272 1
- 274 1
- 276 1
- 279 1
- 28 1
- 284 1
- 288 1
- 294 1
- 295 1
- 30 1
- 300 1
- 303 1
- 31 1
- 310 1
- 311 1
- 315 1
- 319 1
- 325 1
- 329 1
- 332 1
- 344 1
- 347 1
- 348 1
- 359 1
- 360 1
- 363 1
- 364 1
- 37 1
- 371 1
- 375 1
- 379 1
- 382 1
- 383 1
- 387 1
- 388 1
- 39 1
- 392 1
- 397 1
- 398 1
- 40 1
- 409 1
- 413 1
- 415 1
- 418 1
- 426 1
- 427 1
- 431 1
- 433 1
- 435 1
- 438 1
- 439 1
- 44 1
- 456 1
- 458 1
- 477 1
- 491 1
- 497 1
- 517 1
- 525 1
- 53 1
- 533 1
- 536 1
- 549 1
- 557 1
- 569 1
- 571 1
- 582 1
- 59 1
- 590 1
- 618 1
- 624 1
- 63 1
- 633 1
- 635 1
- 639 1
- 640 1
- 645 1
- 647 1
- 653 1
- 655 1
- 680 1
- 681 1
- 682 1
- 689 1
- 698 1
- 7 1
- 70 1
- 703 1
- 711 1
- 716 1
- 725 1
- 751 1
- 755 1
- 758 1
- 761 1
- 77 1
- 778 1
- 796 1
- 798 1
- 80 1
- 801 1
- 818 1
- 82 1
- 826 1
- 84 1
- 86 1
- 91 1
- 912 1
- 93 1
- 99 1
province_or_state 1
- Gunma · 946 ✖
country_or_region 1
- Japan 946
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
323 | 323 | 2021-12-02 | Japan | Gunma | 16906 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-12-03 04:23:05 | Gunma, Japan | |||
4339 | 4339 | 2021-10-28 | Japan | Gunma | 16765 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-10-29 04:22:03 | Gunma, Japan | |||
16364 | 16364 | 2021-09-18 | Japan | Gunma | 16305 | 168 | 0 | 36.504478999999996 | 138.985605 | 2021-09-19 04:21:34 | Gunma, Japan | |||
24394 | 24394 | 2022-03-20 | Japan | Gunma | 63942 | 275 | 0 | 36.504478999999996 | 138.985605 | 2022-03-21 04:20:50 | Gunma, Japan | |||
28409 | 28409 | 2021-11-11 | Japan | Gunma | 16817 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-12 04:22:01 | Gunma, Japan | |||
32425 | 32425 | 2021-08-25 | Japan | Gunma | 13559 | 158 | 0 | 36.504478999999996 | 138.985605 | 2021-08-26 04:21:28 | Gunma, Japan | |||
43701 | 43701 | 2021-11-02 | Japan | Gunma | 16793 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-03 06:22:09 | Gunma, Japan | |||
63055 | 63055 | 2022-11-12 | Japan | Gunma | 268166 | 534 | 0 | 36.504479 | 138.985605 | 2022-11-13 04:21:14 | Gunma, Japan | |||
67070 | 67070 | 2021-09-01 | Japan | Gunma | 15091 | 159 | 0 | 36.504478999999996 | 138.985605 | 2021-09-02 04:21:15 | Gunma, Japan | |||
71084 | 71084 | 2022-02-07 | Japan | Gunma | 36707 | 204 | 0 | 36.504478999999996 | 138.985605 | 2022-02-08 04:21:15 | Gunma, Japan | |||
87118 | 87118 | 2021-11-09 | Japan | Gunma | 16813 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-10 04:21:38 | Gunma, Japan | |||
91135 | 91135 | 2022-07-23 | Japan | Gunma | 116534 | 331 | 0 | 36.504479 | 138.985605 | 2022-07-24 04:20:47 | Gunma, Japan | |||
99319 | 99319 | 2022-01-14 | Japan | Gunma | 18638 | 181 | 0 | 36.504478999999996 | 138.985605 | 2022-01-15 04:21:07 | Gunma, Japan | |||
103335 | 103335 | 2021-08-15 | Japan | Gunma | 10978 | 155 | 0 | 36.504478999999996 | 138.985605 | 2021-08-16 04:21:31 | Gunma, Japan | |||
114745 | 114745 | 2022-09-06 | Japan | Gunma | 212912 | 434 | 0 | 36.504479 | 138.985605 | 2022-09-07 04:20:59 | Gunma, Japan | |||
126726 | 126726 | 2022-01-09 | Japan | Gunma | 17780 | 178 | 0 | 36.504478999999996 | 138.985605 | 2022-01-10 04:22:07 | Gunma, Japan | |||
130743 | 130743 | 2022-10-04 | Japan | Gunma | 238618 | 473 | 0 | 36.504479 | 138.985605 | 2022-10-05 04:23:06 | Gunma, Japan | |||
137964 | 137964 | 2021-12-04 | Japan | Gunma | 16923 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-12-05 04:22:25 | Gunma, Japan | |||
141981 | 141981 | 2022-07-09 | Japan | Gunma | 100785 | 323 | 0 | 36.504479 | 138.985605 | 2022-07-10 04:20:54 | Gunma, Japan | |||
149977 | 149977 | 2021-11-29 | Japan | Gunma | 16868 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-30 04:22:53 | Gunma, Japan | |||
158006 | 158006 | 2022-03-29 | Japan | Gunma | 68485 | 280 | 0 | 36.504478999999996 | 138.985605 | 2022-03-30 04:20:45 | Gunma, Japan | |||
162021 | 162021 | 2021-11-19 | Japan | Gunma | 16842 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-20 04:22:17 | Gunma, Japan | |||
166038 | 166038 | 2022-06-21 | Japan | Gunma | 97323 | 321 | 0 | 36.504479 | 138.985605 | 2022-06-22 04:20:54 | Gunma, Japan | |||
178035 | 178035 | 2021-09-02 | Japan | Gunma | 15265 | 159 | 0 | 36.504478999999996 | 138.985605 | 2021-09-03 04:21:20 | Gunma, Japan | |||
186064 | 186064 | 2022-02-13 | Japan | Gunma | 41576 | 219 | 0 | 36.504478999999996 | 138.985605 | 2022-02-14 04:20:51 | Gunma, Japan | |||
198252 | 198252 | 2022-10-19 | Japan | Gunma | 246978 | 495 | 0 | 36.504479 | 138.985605 | 2022-10-20 04:22:59 | Gunma, Japan | |||
217973 | 217973 | 2022-12-26 | Japan | Gunma | 362319 | 756 | 0 | 36.504479 | 138.985605 | 2022-12-27 04:21:07 | Gunma, Japan | |||
221989 | 221989 | 2022-05-09 | Japan | Gunma | 87384 | 309 | 0 | 36.504479 | 138.985605 | 2022-05-10 04:20:50 | Gunma, Japan | |||
229220 | 229220 | 2022-05-31 | Japan | Gunma | 94334 | 319 | 0 | 36.504479 | 138.985605 | 2022-06-01 04:20:55 | Gunma, Japan | |||
233236 | 233236 | 2022-02-11 | Japan | Gunma | 40416 | 215 | 0 | 36.504478999999996 | 138.985605 | 2022-02-12 04:21:06 | Gunma, Japan | |||
245278 | 245278 | 2021-08-17 | Japan | Gunma | 11334 | 156 | 0 | 36.504478999999996 | 138.985605 | 2021-08-18 04:21:35 | Gunma, Japan | |||
249292 | 249292 | 2021-09-04 | Japan | Gunma | 15498 | 162 | 0 | 36.504478999999996 | 138.985605 | 2021-09-05 04:21:33 | Gunma, Japan | |||
253307 | 253307 | 2022-09-08 | Japan | Gunma | 216010 | 446 | 0 | 36.504479 | 138.985605 | 2022-09-09 04:21:11 | Gunma, Japan | |||
257323 | 257323 | 2022-12-10 | Japan | Gunma | 322016 | 649 | 0 | 36.504479 | 138.985605 | 2022-12-11 04:20:50 | Gunma, Japan | |||
261526 | 261526 | 2022-03-15 | Japan | Gunma | 60849 | 271 | 0 | 36.504478999999996 | 138.985605 | 2022-03-16 04:20:50 | Gunma, Japan | |||
276176 | 276176 | 2021-11-03 | Japan | Gunma | 16804 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-04 04:22:20 | Gunma, Japan | |||
287989 | 287989 | 2021-10-31 | Japan | Gunma | 16786 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-01 04:22:01 | Gunma, Japan | |||
292006 | 292006 | 2022-11-15 | Japan | Gunma | 271935 | 541 | 0 | 36.504479 | 138.985605 | 2022-11-16 04:21:09 | Gunma, Japan | |||
303862 | 303862 | 2022-04-16 | Japan | Gunma | 78216 | 303 | 0 | 36.504478999999996 | 138.985605 | 2022-04-17 04:20:59 | Gunma, Japan | |||
307878 | 307878 | 2022-12-13 | Japan | Gunma | 328575 | 667 | 0 | 36.504479 | 138.985605 | 2022-12-14 04:21:04 | Gunma, Japan | |||
311894 | 311894 | 2022-11-13 | Japan | Gunma | 269460 | 535 | 0 | 36.504479 | 138.985605 | 2022-11-14 04:21:09 | Gunma, Japan | |||
315910 | 315910 | 2022-02-12 | Japan | Gunma | 40819 | 216 | 0 | 36.504478999999996 | 138.985605 | 2022-02-13 04:21:00 | Gunma, Japan | |||
319926 | 319926 | 2022-10-30 | Japan | Gunma | 253774 | 510 | 0 | 36.504479 | 138.985605 | 2022-10-31 04:21:36 | Gunma, Japan | |||
327900 | 327900 | 2022-12-27 | Japan | Gunma | 365876 | 764 | 0 | 36.504479 | 138.985605 | 2022-12-28 04:21:04 | Gunma, Japan | |||
335930 | 335930 | 2022-03-18 | Japan | Gunma | 62920 | 275 | 0 | 36.504478999999996 | 138.985605 | 2022-03-19 04:20:47 | Gunma, Japan | |||
348290 | 348290 | 2022-12-14 | Japan | Gunma | 331897 | 670 | 0 | 36.504479 | 138.985605 | 2022-12-15 04:20:58 | Gunma, Japan | |||
356320 | 356320 | 2022-03-11 | Japan | Gunma | 58600 | 268 | 0 | 36.504478999999996 | 138.985605 | 2022-03-12 04:20:50 | Gunma, Japan | |||
360336 | 360336 | 2022-05-07 | Japan | Gunma | 86717 | 309 | 0 | 36.504479 | 138.985605 | 2022-05-08 04:20:49 | Gunma, Japan | |||
372190 | 372190 | 2022-09-13 | Japan | Gunma | 221783 | 456 | 0 | 36.504479 | 138.985605 | 2022-09-14 04:20:44 | Gunma, Japan | |||
384217 | 384217 | 2022-09-23 | Japan | Gunma | 231839 | 462 | 0 | 36.504479 | 138.985605 | 2022-09-24 04:21:40 | Gunma, Japan | |||
396258 | 396258 | 2022-10-07 | Japan | Gunma | 240383 | 475 | 0 | 36.504479 | 138.985605 | 2022-10-08 04:22:56 | Gunma, Japan | |||
404287 | 404287 | 2021-12-07 | Japan | Gunma | 16961 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-12-08 04:22:46 | Gunma, Japan | |||
419329 | 419329 | 2022-09-18 | Japan | Gunma | 227541 | 459 | 0 | 36.504479 | 138.985605 | 2022-09-19 04:21:49 | Gunma, Japan | |||
423344 | 423344 | 2021-10-10 | Japan | Gunma | 16653 | 173 | 0 | 36.504478999999996 | 138.985605 | 2021-10-11 04:21:31 | Gunma, Japan | |||
431351 | 431351 | 2022-11-03 | Japan | Gunma | 257891 | 520 | 0 | 36.504479 | 138.985605 | 2022-11-04 04:22:11 | Gunma, Japan | |||
443348 | 443348 | 2021-10-20 | Japan | Gunma | 16710 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-10-21 04:21:18 | Gunma, Japan | |||
447364 | 447364 | 2021-11-17 | Japan | Gunma | 16830 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-18 04:21:33 | Gunma, Japan | |||
451381 | 451381 | 2022-12-21 | Japan | Gunma | 350309 | 715 | 0 | 36.504479 | 138.985605 | 2022-12-22 04:20:56 | Gunma, Japan | |||
459373 | 459373 | 2022-02-02 | Japan | Gunma | 32003 | 193 | 0 | 36.504478999999996 | 138.985605 | 2022-02-03 04:21:21 | Gunma, Japan | |||
463390 | 463390 | 2022-05-02 | Japan | Gunma | 84899 | 309 | 0 | 36.504479 | 138.985605 | 2022-05-03 04:21:00 | Gunma, Japan | |||
467405 | 467405 | 2021-10-07 | Japan | Gunma | 16628 | 173 | 0 | 36.504478999999996 | 138.985605 | 2021-10-08 04:21:25 | Gunma, Japan | |||
475436 | 475436 | 2022-06-26 | Japan | Gunma | 97833 | 322 | 0 | 36.504479 | 138.985605 | 2022-06-27 04:21:00 | Gunma, Japan | |||
479584 | 479584 | 2022-11-08 | Japan | Gunma | 262868 | 528 | 0 | 36.504479 | 138.985605 | 2022-11-09 04:21:22 | Gunma, Japan | |||
487614 | 487614 | 2022-11-25 | Japan | Gunma | 289693 | 578 | 0 | 36.504479 | 138.985605 | 2022-11-26 04:21:11 | Gunma, Japan | |||
491629 | 491629 | 2021-10-14 | Japan | Gunma | 16681 | 174 | 0 | 36.504478999999996 | 138.985605 | 2021-10-15 04:21:26 | Gunma, Japan | |||
495645 | 495645 | 2021-11-06 | Japan | Gunma | 16808 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-07 04:21:53 | Gunma, Japan | |||
499662 | 499662 | 2022-04-02 | Japan | Gunma | 71148 | 286 | 0 | 36.504478999999996 | 138.985605 | 2022-04-03 04:20:48 | Gunma, Japan | |||
503678 | 503678 | 2022-12-17 | Japan | Gunma | 340254 | 693 | 0 | 36.504479 | 138.985605 | 2022-12-18 04:21:03 | Gunma, Japan | |||
507693 | 507693 | 2021-08-14 | Japan | Gunma | 10801 | 155 | 0 | 36.504478999999996 | 138.985605 | 2021-08-15 04:21:41 | Gunma, Japan | |||
511707 | 511707 | 2021-08-19 | Japan | Gunma | 11965 | 156 | 0 | 36.504478999999996 | 138.985605 | 2021-08-20 04:21:33 | Gunma, Japan | |||
515722 | 515722 | 2022-10-15 | Japan | Gunma | 244557 | 487 | 0 | 36.504479 | 138.985605 | 2022-10-16 04:22:39 | Gunma, Japan | |||
534729 | 534729 | 2021-10-27 | Japan | Gunma | 16757 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-10-28 04:22:08 | Gunma, Japan | |||
538746 | 538746 | 2022-10-26 | Japan | Gunma | 251000 | 507 | 0 | 36.504479 | 138.985605 | 2022-10-27 04:22:01 | Gunma, Japan | |||
542762 | 542762 | 2022-12-15 | Japan | Gunma | 334853 | 681 | 0 | 36.504479 | 138.985605 | 2022-12-16 04:21:01 | Gunma, Japan | |||
550767 | 550767 | 2021-12-08 | Japan | Gunma | 16974 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-12-09 04:22:49 | Gunma, Japan | |||
554783 | 554783 | 2022-01-16 | Japan | Gunma | 19216 | 182 | 0 | 36.504478999999996 | 138.985605 | 2022-01-17 04:21:08 | Gunma, Japan | |||
558800 | 558800 | 2022-06-16 | Japan | Gunma | 96672 | 321 | 0 | 36.504479 | 138.985605 | 2022-06-17 04:20:56 | Gunma, Japan | |||
567097 | 567097 | 2021-10-29 | Japan | Gunma | 16780 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-10-30 04:22:03 | Gunma, Japan | |||
574826 | 574826 | 2022-02-25 | Japan | Gunma | 50007 | 244 | 0 | 36.504478999999996 | 138.985605 | 2022-02-26 04:21:12 | Gunma, Japan | |||
589637 | 589637 | 2021-08-08 | Japan | Gunma | 9799 | 155 | 0 | 36.504479 | 138.985605 | 2021-08-09 04:21:24 | Gunma, Japan | |||
593652 | 593652 | 2022-07-01 | Japan | Gunma | 98382 | 322 | 0 | 36.504479 | 138.985605 | 2022-07-02 04:21:16 | Gunma, Japan | |||
597667 | 597667 | 2021-10-19 | Japan | Gunma | 16704 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-10-20 04:21:00 | Gunma, Japan | |||
601683 | 601683 | 2021-09-23 | Japan | Gunma | 16464 | 170 | 0 | 36.504478999999996 | 138.985605 | 2021-09-24 04:21:44 | Gunma, Japan | |||
617856 | 617856 | 2022-11-05 | Japan | Gunma | 259832 | 525 | 0 | 36.504479 | 138.985605 | 2022-11-06 04:21:24 | Gunma, Japan | |||
621872 | 621872 | 2022-05-22 | Japan | Gunma | 93064 | 317 | 0 | 36.504479 | 138.985605 | 2022-05-26 04:20:50 | Gunma, Japan | |||
629902 | 629902 | 2022-07-12 | Japan | Gunma | 102239 | 323 | 0 | 36.504479 | 138.985605 | 2022-07-13 04:20:58 | Gunma, Japan | |||
633917 | 633917 | 2021-10-13 | Japan | Gunma | 16679 | 174 | 0 | 36.504478999999996 | 138.985605 | 2021-10-14 04:21:29 | Gunma, Japan | |||
641947 | 641947 | 2021-09-07 | Japan | Gunma | 15730 | 163 | 0 | 36.504478999999996 | 138.985605 | 2021-09-08 04:21:31 | Gunma, Japan | |||
649975 | 649975 | 2021-08-09 | Japan | Gunma | 9890 | 155 | 0 | 36.504478999999996 | 138.985605 | 2021-08-10 04:21:27 | Gunma, Japan | |||
653989 | 653989 | 2021-10-22 | Japan | Gunma | 16729 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-10-23 04:21:32 | Gunma, Japan | |||
658308 | 658308 | 2022-05-13 | Japan | Gunma | 89060 | 310 | 0 | 36.504479 | 138.985605 | 2022-05-14 04:20:48 | Gunma, Japan | |||
670293 | 670293 | 2022-07-21 | Japan | Gunma | 112480 | 329 | 0 | 36.504479 | 138.985605 | 2022-07-22 04:21:15 | Gunma, Japan | |||
674309 | 674309 | 2022-07-30 | Japan | Gunma | 131359 | 342 | 0 | 36.504479 | 138.985605 | 2022-07-31 04:21:02 | Gunma, Japan | |||
682334 | 682334 | 2021-10-24 | Japan | Gunma | 16741 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-10-25 04:22:31 | Gunma, Japan | |||
686350 | 686350 | 2021-11-13 | Japan | Gunma | 16822 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-14 04:21:31 | Gunma, Japan | |||
690367 | 690367 | 2022-12-23 | Japan | Gunma | 356119 | 732 | 0 | 36.504479 | 138.985605 | 2022-12-24 04:21:02 | Gunma, Japan | |||
694383 | 694383 | 2022-03-17 | Japan | Gunma | 62319 | 274 | 0 | 36.504478999999996 | 138.985605 | 2022-03-18 04:20:55 | Gunma, Japan | |||
698398 | 698398 | 2021-11-04 | Japan | Gunma | 16805 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-05 04:21:54 | Gunma, Japan | |||
706428 | 706428 | 2021-09-29 | Japan | Gunma | 16558 | 172 | 0 | 36.504478999999996 | 138.985605 | 2021-09-30 04:21:20 | Gunma, Japan | |||
710444 | 710444 | 2022-11-01 | Japan | Gunma | 255439 | 512 | 0 | 36.504479 | 138.985605 | 2022-11-02 04:22:09 | Gunma, Japan |
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]);