johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Nara" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, last_update, day (date), last_update (date)
deaths 295 ✖
- 149 112
- 2 77
- 9 46
- 11 22
- 133 19
- 392 19
- 132 16
- 3 13
- 134 13
- 8 10
- 13 10
- 48 10
- 10 9
- 55 9
- 365 9
- 45 8
- 552 8
- 42 7
- 153 7
- 384 7
- 394 7
- 534 7
- 15 6
- 26 6
- 31 6
- 47 6
- 131 6
- 144 6
- 561 6
- 5 5
- 20 5
- 36 5
- 43 5
- 115 5
- 129 5
- 137 5
- 142 5
- 152 5
- 357 5
- 382 5
- 386 5
- 387 5
- 389 5
- 390 5
- 564 5
- 24 4
- 32 4
- 49 4
- 51 4
- 56 4
- 61 4
- 122 4
- 147 4
- 404 4
- 406 4
- 518 4
- 522 4
- 546 4
- 553 4
- 584 4
- 22 3
- 44 3
- 77 3
- 86 3
- 100 3
- 118 3
- 119 3
- 120 3
- 135 3
- 141 3
- 145 3
- 160 3
- 331 3
- 336 3
- 342 3
- 353 3
- 370 3
- 372 3
- 385 3
- 388 3
- 391 3
- 410 3
- 521 3
- 6 2
- 7 2
- 12 2
- 21 2
- 25 2
- 40 2
- 50 2
- 54 2
- 71 2
- 72 2
- 110 2
- 126 2
- 136 2
- 146 2
- 262 2
- 318 2
- 332 2
- 345 2
- 347 2
- 350 2
- 352 2
- 354 2
- 355 2
- 381 2
- 399 2
- 419 2
- 449 2
- 468 2
- 509 2
- 519 2
- 528 2
- 531 2
- 569 2
- 572 2
- 618 2
- 619 2
- 634 2
- 662 2
- 14 1
- 16 1
- 28 1
- 30 1
- 34 1
- 35 1
- 37 1
- 38 1
- 39 1
- 41 1
- 46 1
- 52 1
- 53 1
- 57 1
- 58 1
- 60 1
- 63 1
- 64 1
- 65 1
- 67 1
- 69 1
- 74 1
- 76 1
- 78 1
- 79 1
- 82 1
- 88 1
- 91 1
- 92 1
- 93 1
- 96 1
- 97 1
- 98 1
- 99 1
- 101 1
- 102 1
- 104 1
- 106 1
- 108 1
- 114 1
- 117 1
- 121 1
- 123 1
- 124 1
- 125 1
- 127 1
- 128 1
- 138 1
- 139 1
- 140 1
- 148 1
- 151 1
- 156 1
- 158 1
- 159 1
- 162 1
- 163 1
- 170 1
- 172 1
- 177 1
- 180 1
- 183 1
- 186 1
- 191 1
- 202 1
- 207 1
- 209 1
- 214 1
- 219 1
- 224 1
- 233 1
- 243 1
- 247 1
- 255 1
- 260 1
- 264 1
- 265 1
- 268 1
- 282 1
- 288 1
- 290 1
- 297 1
- 299 1
- 303 1
- 306 1
- 310 1
- 317 1
- 322 1
- 324 1
- 340 1
- 349 1
- 351 1
- 360 1
- 363 1
- 368 1
- 369 1
- 373 1
- 377 1
- 380 1
- 397 1
- 403 1
- 405 1
- 417 1
- 418 1
- 423 1
- 424 1
- 427 1
- 429 1
- 433 1
- 434 1
- 436 1
- 437 1
- 438 1
- 442 1
- 447 1
- 452 1
- 455 1
- 457 1
- 459 1
- 462 1
- 463 1
- 476 1
- 477 1
- 482 1
- 483 1
- 485 1
- 487 1
- 488 1
- 495 1
- 500 1
- 504 1
- 505 1
- 510 1
- 511 1
- 513 1
- 516 1
- 517 1
- 526 1
- 532 1
- 537 1
- 541 1
- 547 1
- 556 1
- 560 1
- 563 1
- 565 1
- 567 1
- 570 1
- 571 1
- 575 1
- 576 1
- 580 1
- 587 1
- 591 1
- 596 1
- 597 1
- 599 1
- 602 1
- 606 1
- 609 1
- 614 1
- 615 1
- 621 1
- 623 1
- 626 1
- 630 1
- 633 1
- 636 1
- 642 1
- 644 1
- 652 1
- 657 1
- 664 1
- 668 1
province_or_state 1
- Nara · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
341 | 341 | 2021-12-02 | Japan | Nara | 15646 | 149 | 0 | 34.317451 | 135.871644 | 2021-12-03 04:23:05 | Nara, Japan | |||
4357 | 4357 | 2021-10-28 | Japan | Nara | 15584 | 149 | 0 | 34.317451 | 135.871644 | 2021-10-29 04:22:03 | Nara, Japan | |||
8359 | 8359 | 2020-10-25 | Japan | Nara | 617 | 9 | 592 | 16 | 34.317451 | 135.871644 | 2020-10-26 04:25:02 | Nara, Japan | ||
12367 | 12367 | 2021-01-26 | Japan | Nara | 2843 | 36 | 2471 | 336 | 34.317451 | 135.871644 | 2021-01-27 05:23:41 | Nara, Japan | ||
16382 | 16382 | 2021-09-18 | Japan | Nara | 15086 | 144 | 0 | 34.317451 | 135.871644 | 2021-09-19 04:21:34 | Nara, Japan | |||
20397 | 20397 | 2021-05-28 | Japan | Nara | 7719 | 114 | 7287 | 318 | 34.317451 | 135.871644 | 2021-05-29 04:20:41 | Nara, Japan | ||
24412 | 24412 | 2022-03-20 | Japan | Nara | 69419 | 332 | 0 | 34.317451 | 135.871644 | 2022-03-21 04:20:50 | Nara, Japan | |||
28427 | 28427 | 2021-11-11 | Japan | Nara | 15633 | 149 | 0 | 34.317451 | 135.871644 | 2021-11-12 04:22:01 | Nara, Japan | |||
32443 | 32443 | 2021-08-25 | Japan | Nara | 11971 | 135 | 0 | 34.317451 | 135.871644 | 2021-08-26 04:21:28 | Nara, Japan | |||
36457 | 36457 | 2021-04-12 | Japan | Nara | 4488 | 56 | 3781 | 651 | 34.317451 | 135.871644 | 2021-04-13 04:20:37 | Nara, Japan | ||
43719 | 43719 | 2021-11-02 | Japan | Nara | 15605 | 149 | 0 | 34.317451 | 135.871644 | 2021-11-03 06:22:09 | Nara, Japan | |||
50818 | 50818 | 2021-05-29 | Japan | Nara | 7737 | 115 | 7352 | 270 | 34.317451 | 135.871644 | 2021-05-30 04:20:55 | Nara, Japan | ||
54832 | 54832 | 2021-03-07 | Japan | Nara | 3327 | 48 | 3283 | 0 | 34.317451 | 135.871644 | 2021-03-08 05:24:48 | Nara, Japan | ||
62022 | 62022 | 2020-07-23 | Japan | Nara | 180 | 2 | 122 | 56 | 34.317451 | 135.871644 | 2020-07-24 05:30:40 | Nara, Japan | ||
63073 | 63073 | 2022-11-12 | Japan | Nara | 236858 | 564 | 0 | 34.317451 | 135.871644 | 2022-11-13 04:21:14 | Nara, Japan | |||
67088 | 67088 | 2021-09-01 | Japan | Nara | 13373 | 137 | 0 | 34.317451 | 135.871644 | 2021-09-02 04:21:15 | Nara, Japan | |||
71102 | 71102 | 2022-02-07 | Japan | Nara | 32674 | 162 | 0 | 34.317451 | 135.871644 | 2022-02-08 04:21:15 | Nara, Japan | |||
75116 | 75116 | 2020-12-03 | Japan | Nara | 1206 | 13 | 973 | 220 | 34.317451 | 135.871644 | 2020-12-04 05:27:27 | Nara, Japan | ||
79115 | 79115 | 2020-10-14 | Japan | Nara | 598 | 9 | 568 | 21 | 34.317451 | 135.871644 | 2020-10-15 04:24:28 | Nara, Japan | ||
83122 | 83122 | 2021-05-25 | Japan | Nara | 7645 | 108 | 7063 | 474 | 34.317451 | 135.871644 | 2021-05-26 04:20:35 | Nara, Japan | ||
87136 | 87136 | 2021-11-09 | Japan | Nara | 15623 | 149 | 0 | 34.317451 | 135.871644 | 2021-11-10 04:21:38 | Nara, Japan | |||
91153 | 91153 | 2022-07-23 | Japan | Nara | 112084 | 403 | 0 | 34.317451 | 135.871644 | 2022-07-24 04:20:47 | Nara, Japan | |||
98370 | 98370 | 2020-08-04 | Japan | Nara | 274 | 2 | 188 | 84 | 34.317451 | 135.871644 | 2020-08-05 04:34:43 | Nara, Japan | ||
99337 | 99337 | 2022-01-14 | Japan | Nara | 16638 | 149 | 0 | 34.317451 | 135.871644 | 2022-01-15 04:21:07 | Nara, Japan | |||
103353 | 103353 | 2021-08-15 | Japan | Nara | 10286 | 134 | 0 | 34.317451 | 135.871644 | 2021-08-16 04:21:31 | Nara, Japan | |||
107478 | 107478 | 2021-06-19 | Japan | Nara | 8018 | 124 | 7870 | 24 | 34.317451 | 135.871644 | 2021-06-20 04:21:48 | Nara, Japan | ||
114763 | 114763 | 2022-09-06 | Japan | Nara | 202199 | 495 | 0 | 34.317451 | 135.871644 | 2022-09-07 04:20:59 | Nara, Japan | |||
121962 | 121962 | 2020-07-19 | Japan | Nara | 150 | 2 | 100 | 48 | 34.317451 | 135.871644 | 2020-07-20 05:34:40 | Nara, Japan | ||
122731 | 122731 | 2020-11-18 | Japan | Nara | 880 | 11 | 718 | 151 | 34.317451 | 135.871644 | 2020-11-19 05:25:23 | Nara, Japan | ||
126744 | 126744 | 2022-01-09 | Japan | Nara | 16042 | 149 | 0 | 34.317451 | 135.871644 | 2022-01-10 04:22:07 | Nara, Japan | |||
130761 | 130761 | 2022-10-04 | Japan | Nara | 222035 | 531 | 0 | 34.317451 | 135.871644 | 2022-10-05 04:23:06 | Nara, Japan | |||
137982 | 137982 | 2021-12-04 | Japan | Nara | 15647 | 149 | 0 | 34.317451 | 135.871644 | 2021-12-05 04:22:25 | Nara, Japan | |||
141999 | 141999 | 2022-07-09 | Japan | Nara | 97273 | 392 | 0 | 34.317451 | 135.871644 | 2022-07-10 04:20:54 | Nara, Japan | |||
145999 | 145999 | 2020-08-15 | Japan | Nara | 364 | 3 | 291 | 70 | 34.317451 | 135.871644 | 2020-08-16 04:27:42 | Nara, Japan | ||
149995 | 149995 | 2021-11-29 | Japan | Nara | 15645 | 149 | 0 | 34.317451 | 135.871644 | 2021-11-30 04:22:53 | Nara, Japan | |||
154010 | 154010 | 2021-01-08 | Japan | Nara | 2225 | 26 | 1841 | 358 | 34.317451 | 135.871644 | 2021-01-09 05:22:18 | Nara, Japan | ||
158024 | 158024 | 2022-03-29 | Japan | Nara | 72466 | 345 | 0 | 34.317451 | 135.871644 | 2022-03-30 04:20:45 | Nara, Japan | |||
162039 | 162039 | 2021-11-19 | Japan | Nara | 15641 | 149 | 0 | 34.317451 | 135.871644 | 2021-11-20 04:22:17 | Nara, Japan | |||
166056 | 166056 | 2022-06-21 | Japan | Nara | 93602 | 391 | 0 | 34.317451 | 135.871644 | 2022-06-22 04:20:54 | Nara, Japan | |||
170071 | 170071 | 2021-04-16 | Japan | Nara | 4812 | 61 | 4000 | 751 | 34.317451 | 135.871644 | 2021-04-17 04:20:40 | Nara, Japan | ||
177280 | 177280 | 2020-07-27 | Japan | Nara | 206 | 2 | 134 | 70 | 34.317451 | 135.871644 | 2020-07-28 04:58:43 | Nara, Japan | ||
178053 | 178053 | 2021-09-02 | Japan | Nara | 13566 | 138 | 0 | 34.317451 | 135.871644 | 2021-09-03 04:21:20 | Nara, Japan | |||
182067 | 182067 | 2021-02-21 | Japan | Nara | 3260 | 45 | 3149 | 66 | 34.317451 | 135.871644 | 2021-02-22 05:24:21 | Nara, Japan | ||
186082 | 186082 | 2022-02-13 | Japan | Nara | 39350 | 183 | 0 | 34.317451 | 135.871644 | 2022-02-14 04:20:51 | Nara, Japan | |||
190096 | 190096 | 2021-01-11 | Japan | Nara | 2344 | 28 | 1933 | 383 | 34.317451 | 135.871644 | 2021-01-12 05:22:15 | Nara, Japan | ||
194094 | 194094 | 2020-08-31 | Japan | Nara | 512 | 6 | 449 | 57 | 34.317451 | 135.871644 | 2020-09-01 04:28:31 | Nara, Japan | ||
198270 | 198270 | 2022-10-19 | Japan | Nara | 226733 | 547 | 0 | 34.317451 | 135.871644 | 2022-10-20 04:22:59 | Nara, Japan | |||
202283 | 202283 | 2020-12-25 | Japan | Nara | 1773 | 21 | 1467 | 285 | 34.317451 | 135.871644 | 2020-12-26 05:22:28 | Nara, Japan | ||
206281 | 206281 | 2020-08-19 | Japan | Nara | 444 | 3 | 315 | 126 | 34.317451 | 135.871644 | 2020-08-20 04:27:43 | Nara, Japan | ||
210267 | 210267 | 2020-10-29 | Japan | Nara | 627 | 9 | 604 | 14 | 34.317451 | 135.871644 | 2020-10-30 04:24:49 | Nara, Japan | ||
217239 | 217239 | 2020-06-08 | Japan | Nara | 88 | 2 | 89 | 0 | 34.317451 | 135.871644 | 2020-06-09 03:33:03 | Nara, Japan | ||
217991 | 217991 | 2022-12-26 | Japan | Nara | 292334 | 662 | 0 | 34.317451 | 135.871644 | 2022-12-27 04:21:07 | Nara, Japan | |||
222007 | 222007 | 2022-05-09 | Japan | Nara | 85457 | 373 | 0 | 34.317451 | 135.871644 | 2022-05-10 04:20:50 | Nara, Japan | |||
229238 | 229238 | 2022-05-31 | Japan | Nara | 91023 | 386 | 0 | 34.317451 | 135.871644 | 2022-06-01 04:20:55 | Nara, Japan | |||
233254 | 233254 | 2022-02-11 | Japan | Nara | 37706 | 177 | 0 | 34.317451 | 135.871644 | 2022-02-12 04:21:06 | Nara, Japan | |||
237268 | 237268 | 2021-01-18 | Japan | Nara | 2595 | 31 | 2173 | 391 | 34.317451 | 135.871644 | 2021-01-19 05:22:15 | Nara, Japan | ||
241282 | 241282 | 2021-04-02 | Japan | Nara | 3793 | 55 | 3442 | 296 | 34.317451 | 135.871644 | 2021-04-03 04:20:44 | Nara, Japan | ||
245296 | 245296 | 2021-08-17 | Japan | Nara | 10510 | 134 | 0 | 34.317451 | 135.871644 | 2021-08-18 04:21:35 | Nara, Japan | |||
249310 | 249310 | 2021-09-04 | Japan | Nara | 13877 | 140 | 0 | 34.317451 | 135.871644 | 2021-09-05 04:21:33 | Nara, Japan | |||
253325 | 253325 | 2022-09-08 | Japan | Nara | 205303 | 504 | 0 | 34.317451 | 135.871644 | 2022-09-09 04:21:11 | Nara, Japan | |||
257341 | 257341 | 2022-12-10 | Japan | Nara | 268062 | 618 | 0 | 34.317451 | 135.871644 | 2022-12-11 04:20:50 | Nara, Japan | |||
261544 | 261544 | 2022-03-15 | Japan | Nara | 66800 | 322 | 0 | 34.317451 | 135.871644 | 2022-03-16 04:20:50 | Nara, Japan | |||
272182 | 272182 | 2020-11-10 | Japan | Nara | 747 | 11 | 636 | 100 | 34.317451 | 135.871644 | 2020-11-11 05:25:30 | Nara, Japan | ||
276194 | 276194 | 2021-11-03 | Japan | Nara | 15608 | 149 | 0 | 34.317451 | 135.871644 | 2021-11-04 04:22:20 | Nara, Japan | |||
280210 | 280210 | 2021-02-24 | Japan | Nara | 3269 | 45 | 3180 | 44 | 34.317451 | 135.871644 | 2021-02-25 05:24:57 | Nara, Japan | ||
287245 | 287245 | 2020-06-15 | Japan | Nara | 88 | 2 | 90 | 0 | 34.317451 | 135.871644 | 2020-06-16 04:33:09 | Nara, Japan | ||
288007 | 288007 | 2021-10-31 | Japan | Nara | 15602 | 149 | 0 | 34.317451 | 135.871644 | 2021-11-01 04:22:01 | Nara, Japan | |||
292024 | 292024 | 2022-11-15 | Japan | Nara | 244617 | 565 | 0 | 34.317451 | 135.871644 | 2022-11-16 04:21:09 | Nara, Japan | |||
296039 | 296039 | 2021-07-15 | Japan | Nara | 8402 | 132 | 8234 | 36 | 34.317451 | 135.871644 | 2021-07-16 04:21:22 | Nara, Japan | ||
303117 | 303117 | 2020-07-01 | Japan | Nara | 88 | 2 | 90 | 0 | 34.317451 | 135.871644 | 2020-07-02 04:33:46 | Nara, Japan | ||
303880 | 303880 | 2022-04-16 | Japan | Nara | 79744 | 357 | 0 | 34.317451 | 135.871644 | 2022-04-17 04:20:59 | Nara, Japan | |||
307896 | 307896 | 2022-12-13 | Japan | Nara | 271520 | 619 | 0 | 34.317451 | 135.871644 | 2022-12-14 04:21:04 | Nara, Japan | |||
311912 | 311912 | 2022-11-13 | Japan | Nara | 237419 | 564 | 0 | 34.317451 | 135.871644 | 2022-11-14 04:21:09 | Nara, Japan | |||
315928 | 315928 | 2022-02-12 | Japan | Nara | 38665 | 180 | 0 | 34.317451 | 135.871644 | 2022-02-13 04:21:00 | Nara, Japan | |||
319944 | 319944 | 2022-10-30 | Japan | Nara | 230751 | 553 | 0 | 34.317451 | 135.871644 | 2022-10-31 04:21:36 | Nara, Japan | |||
327057 | 327057 | 2020-07-20 | Japan | Nara | 152 | 2 | 103 | 47 | 34.317451 | 135.871644 | 2020-07-21 04:38:46 | Nara, Japan | ||
327918 | 327918 | 2022-12-27 | Japan | Nara | 294447 | 662 | 0 | 34.317451 | 135.871644 | 2022-12-28 04:21:04 | Nara, Japan | |||
331933 | 331933 | 2021-08-04 | Japan | Nara | 9183 | 133 | 8604 | 446 | 34.317451 | 135.871644 | 2021-08-05 04:21:51 | Nara, Japan | ||
335948 | 335948 | 2022-03-18 | Japan | Nara | 68693 | 331 | 0 | 34.317451 | 135.871644 | 2022-03-19 04:20:47 | Nara, Japan | |||
340302 | 340302 | 2021-02-03 | Japan | Nara | 3052 | 40 | 2752 | 260 | 34.317451 | 135.871644 | 2021-02-04 05:22:26 | Nara, Japan | ||
344302 | 344302 | 2020-09-14 | Japan | Nara | 539 | 9 | 509 | 21 | 34.317451 | 135.871644 | 2020-09-15 03:22:50 | Nara, Japan | ||
348308 | 348308 | 2022-12-14 | Japan | Nara | 273412 | 621 | 0 | 34.317451 | 135.871644 | 2022-12-15 04:20:58 | Nara, Japan | |||
352323 | 352323 | 2021-03-11 | Japan | Nara | 3355 | 48 | 3301 | 6 | 34.317451 | 135.871644 | 2021-03-12 05:26:50 | Nara, Japan | ||
356338 | 356338 | 2022-03-11 | Japan | Nara | 64461 | 310 | 0 | 34.317451 | 135.871644 | 2022-03-12 04:20:50 | Nara, Japan | |||
360354 | 360354 | 2022-05-07 | Japan | Nara | 84717 | 372 | 0 | 34.317451 | 135.871644 | 2022-05-08 04:20:49 | Nara, Japan | |||
367465 | 367465 | 2020-07-16 | Japan | Nara | 134 | 2 | 92 | 40 | 34.317451 | 135.871644 | 2020-07-17 04:34:50 | Nara, Japan | ||
371435 | 371435 | 2020-08-08 | Japan | Nara | 315 | 2 | 223 | 90 | 34.317451 | 135.871644 | 2020-08-09 04:34:54 | Nara, Japan | ||
372208 | 372208 | 2022-09-13 | Japan | Nara | 209871 | 511 | 0 | 34.317451 | 135.871644 | 2022-09-14 04:20:44 | Nara, Japan | |||
376209 | 376209 | 2020-11-06 | Japan | Nara | 704 | 10 | 618 | 76 | 34.317451 | 135.871644 | 2020-11-07 05:24:52 | Nara, Japan | ||
380220 | 380220 | 2021-04-30 | Japan | Nara | 6068 | 76 | 4989 | 1003 | 34.317451 | 135.871644 | 2021-05-01 04:20:47 | Nara, Japan | ||
384235 | 384235 | 2022-09-23 | Japan | Nara | 217702 | 521 | 0 | 34.317451 | 135.871644 | 2022-09-24 04:21:40 | Nara, Japan | |||
388250 | 388250 | 2021-04-04 | Japan | Nara | 3877 | 55 | 3473 | 349 | 34.317451 | 135.871644 | 2021-04-05 04:20:35 | Nara, Japan | ||
392262 | 392262 | 2020-11-27 | Japan | Nara | 1064 | 11 | 861 | 192 | 34.317451 | 135.871644 | 2020-11-28 05:25:50 | Nara, Japan | ||
396276 | 396276 | 2022-10-07 | Japan | Nara | 223069 | 534 | 0 | 34.317451 | 135.871644 | 2022-10-08 04:22:56 | Nara, Japan | |||
400291 | 400291 | 2021-06-29 | Japan | Nara | 8186 | 129 | 7980 | 77 | 34.317451 | 135.871644 | 2021-06-30 04:21:41 | Nara, Japan | ||
404305 | 404305 | 2021-12-07 | Japan | Nara | 15647 | 149 | 0 | 34.317451 | 135.871644 | 2021-12-08 04:22:46 | Nara, Japan | |||
408321 | 408321 | 2021-07-28 | Japan | Nara | 8735 | 133 | 8432 | 170 | 34.317451 | 135.871644 | 2021-07-29 04:21:33 | Nara, Japan | ||
415409 | 415409 | 2020-07-05 | Japan | Nara | 91 | 2 | 90 | 0 | 34.317451 | 135.871644 | 2020-07-06 04:33:57 | Nara, Japan | ||
419347 | 419347 | 2022-09-18 | Japan | Nara | 214366 | 518 | 0 | 34.317451 | 135.871644 | 2022-09-19 04:21:49 | Nara, Japan | |||
423362 | 423362 | 2021-10-10 | Japan | Nara | 15471 | 149 | 0 | 34.317451 | 135.871644 | 2021-10-11 04:21:31 | Nara, 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]);