johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where country_or_region = "Russia" and province_or_state = "Irkutsk Oblast" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3070230 | 3070230 | 2021-11-23 | Russia | Irkutsk Oblast | 134521 | 6027 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-24 04:22:14 | Irkutsk Oblast, Russia | |||
3749328 | 3749328 | 2021-11-22 | Russia | Irkutsk Oblast | 133923 | 5996 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-23 04:22:39 | Irkutsk Oblast, Russia | |||
1014535 | 1014535 | 2021-11-21 | Russia | Irkutsk Oblast | 133326 | 5967 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-22 04:22:20 | Irkutsk Oblast, Russia | |||
722699 | 722699 | 2021-11-20 | Russia | Irkutsk Oblast | 132725 | 5937 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-21 04:22:13 | Irkutsk Oblast, Russia | |||
162229 | 162229 | 2021-11-19 | Russia | Irkutsk Oblast | 132127 | 5908 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-20 04:22:17 | Irkutsk Oblast, Russia | |||
3289116 | 3289116 | 2021-11-18 | Russia | Irkutsk Oblast | 131533 | 5878 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-19 04:21:40 | Irkutsk Oblast, Russia | |||
447572 | 447572 | 2021-11-17 | Russia | Irkutsk Oblast | 130946 | 5846 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-18 04:21:33 | Irkutsk Oblast, Russia | |||
3342822 | 3342822 | 2021-11-16 | Russia | Irkutsk Oblast | 130364 | 5817 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-17 04:21:48 | Irkutsk Oblast, Russia | |||
2287658 | 2287658 | 2021-11-15 | Russia | Irkutsk Oblast | 129788 | 5798 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-16 04:21:10 | Irkutsk Oblast, Russia | |||
1322432 | 1322432 | 2021-11-14 | Russia | Irkutsk Oblast | 129210 | 5769 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-15 04:21:36 | Irkutsk Oblast, Russia | |||
686558 | 686558 | 2021-11-13 | Russia | Irkutsk Oblast | 128629 | 5738 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-14 04:21:31 | Irkutsk Oblast, Russia | |||
714667 | 714667 | 2021-11-12 | Russia | Irkutsk Oblast | 128056 | 5708 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-13 04:21:38 | Irkutsk Oblast, Russia | |||
28617 | 28617 | 2021-11-11 | Russia | Irkutsk Oblast | 127489 | 5680 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-12 04:22:01 | Irkutsk Oblast, Russia | |||
2845056 | 2845056 | 2021-11-10 | Russia | Irkutsk Oblast | 126930 | 5657 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-11 04:21:45 | Irkutsk Oblast, Russia | |||
87326 | 87326 | 2021-11-09 | Russia | Irkutsk Oblast | 126378 | 5626 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-10 04:21:38 | Irkutsk Oblast, Russia | |||
3639754 | 3639754 | 2021-11-08 | Russia | Irkutsk Oblast | 125841 | 5597 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-09 04:21:36 | Irkutsk Oblast, Russia | |||
2000862 | 2000862 | 2021-11-07 | Russia | Irkutsk Oblast | 125305 | 5568 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-08 04:21:43 | Irkutsk Oblast, Russia | |||
495853 | 495853 | 2021-11-06 | Russia | Irkutsk Oblast | 124764 | 5540 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-07 04:21:53 | Irkutsk Oblast, Russia | |||
3121708 | 3121708 | 2021-11-05 | Russia | Irkutsk Oblast | 124226 | 5513 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-06 04:21:51 | Irkutsk Oblast, Russia | |||
698606 | 698606 | 2021-11-04 | Russia | Irkutsk Oblast | 123705 | 5487 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-05 04:21:54 | Irkutsk Oblast, Russia | |||
276384 | 276384 | 2021-11-03 | Russia | Irkutsk Oblast | 123200 | 5459 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-04 04:22:20 | Irkutsk Oblast, Russia | |||
43909 | 43909 | 2021-11-02 | Russia | Irkutsk Oblast | 122709 | 5433 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-03 06:22:09 | Irkutsk Oblast, Russia | |||
3511605 | 3511605 | 2021-11-01 | Russia | Irkutsk Oblast | 122225 | 5408 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-02 04:22:03 | Irkutsk Oblast, Russia | |||
288197 | 288197 | 2021-10-31 | Russia | Irkutsk Oblast | 121744 | 5386 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-01 04:22:01 | Irkutsk Oblast, Russia | |||
2721203 | 2721203 | 2021-10-30 | Russia | Irkutsk Oblast | 121254 | 5358 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-31 04:22:08 | Irkutsk Oblast, Russia | |||
567305 | 567305 | 2021-10-29 | Russia | Irkutsk Oblast | 120776 | 5331 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-30 04:22:03 | Irkutsk Oblast, Russia | |||
4547 | 4547 | 2021-10-28 | Russia | Irkutsk Oblast | 120313 | 5305 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-29 04:22:03 | Irkutsk Oblast, Russia | |||
534937 | 534937 | 2021-10-27 | Russia | Irkutsk Oblast | 119864 | 5277 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-28 04:22:08 | Irkutsk Oblast, Russia | |||
3492374 | 3492374 | 2021-10-26 | Russia | Irkutsk Oblast | 119430 | 5250 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-27 04:22:32 | Irkutsk Oblast, Russia | |||
3794096 | 3794096 | 2021-10-25 | Russia | Irkutsk Oblast | 119001 | 5225 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-26 04:22:09 | Irkutsk Oblast, Russia | |||
682542 | 682542 | 2021-10-24 | Russia | Irkutsk Oblast | 118570 | 5196 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-25 04:22:31 | Irkutsk Oblast, Russia | |||
770550 | 770550 | 2021-10-23 | Russia | Irkutsk Oblast | 118135 | 5172 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-24 04:21:22 | Irkutsk Oblast, Russia | |||
654197 | 654197 | 2021-10-22 | Russia | Irkutsk Oblast | 117705 | 5147 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-23 04:21:32 | Irkutsk Oblast, Russia | |||
2123944 | 2123944 | 2021-10-21 | Russia | Irkutsk Oblast | 117282 | 5124 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-22 04:21:14 | Irkutsk Oblast, Russia | |||
443556 | 443556 | 2021-10-20 | Russia | Irkutsk Oblast | 116864 | 5100 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-21 04:21:18 | Irkutsk Oblast, Russia | |||
597875 | 597875 | 2021-10-19 | Russia | Irkutsk Oblast | 116465 | 5078 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-20 04:21:00 | Irkutsk Oblast, Russia | |||
2044052 | 2044052 | 2021-10-18 | Russia | Irkutsk Oblast | 116070 | 5055 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-19 04:20:54 | Irkutsk Oblast, Russia | |||
1909413 | 1909413 | 2021-10-17 | Russia | Irkutsk Oblast | 115673 | 5036 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-18 04:21:10 | Irkutsk Oblast, Russia | |||
935002 | 935002 | 2021-10-16 | Russia | Irkutsk Oblast | 115274 | 5017 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-17 04:21:29 | Irkutsk Oblast, Russia | |||
2943557 | 2943557 | 2021-10-15 | Russia | Irkutsk Oblast | 114873 | 4999 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-16 04:21:15 | Irkutsk Oblast, Russia | |||
491837 | 491837 | 2021-10-14 | Russia | Irkutsk Oblast | 114470 | 4983 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-15 04:21:26 | Irkutsk Oblast, Russia | |||
634125 | 634125 | 2021-10-13 | Russia | Irkutsk Oblast | 114072 | 4969 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-14 04:21:29 | Irkutsk Oblast, Russia | |||
1491803 | 1491803 | 2021-10-12 | Russia | Irkutsk Oblast | 113677 | 4957 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-13 04:20:51 | Irkutsk Oblast, Russia | |||
3007536 | 3007536 | 2021-10-11 | Russia | Irkutsk Oblast | 113285 | 4944 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-12 04:21:09 | Irkutsk Oblast, Russia | |||
423552 | 423552 | 2021-10-10 | Russia | Irkutsk Oblast | 112889 | 4932 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-11 04:21:31 | Irkutsk Oblast, Russia | |||
2876409 | 2876409 | 2021-10-09 | Russia | Irkutsk Oblast | 112491 | 4922 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-10 04:21:38 | Irkutsk Oblast, Russia | |||
2959575 | 2959575 | 2021-10-08 | Russia | Irkutsk Oblast | 112096 | 4911 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-09 04:21:34 | Irkutsk Oblast, Russia | |||
467613 | 467613 | 2021-10-07 | Russia | Irkutsk Oblast | 111706 | 4900 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-08 04:21:25 | Irkutsk Oblast, Russia | |||
2458993 | 2458993 | 2021-10-06 | Russia | Irkutsk Oblast | 111320 | 4889 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-07 04:21:36 | Irkutsk Oblast, Russia | |||
3832687 | 3832687 | 2021-10-05 | Russia | Irkutsk Oblast | 110941 | 4877 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-06 04:21:33 | Irkutsk Oblast, Russia | |||
987180 | 987180 | 2021-10-04 | Russia | Irkutsk Oblast | 110570 | 4866 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-05 04:21:27 | Irkutsk Oblast, Russia | |||
1274490 | 1274490 | 2021-10-03 | Russia | Irkutsk Oblast | 110196 | 4854 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-04 04:21:31 | Irkutsk Oblast, Russia | |||
3928243 | 3928243 | 2021-10-02 | Russia | Irkutsk Oblast | 109820 | 4843 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-03 04:21:24 | Irkutsk Oblast, Russia | |||
2132223 | 2132223 | 2021-10-01 | Russia | Irkutsk Oblast | 109440 | 4831 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-02 04:21:25 | Irkutsk Oblast, Russia | |||
2773180 | 2773180 | 2021-09-30 | Russia | Irkutsk Oblast | 109059 | 4820 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-01 04:21:35 | Irkutsk Oblast, Russia | |||
706636 | 706636 | 2021-09-29 | Russia | Irkutsk Oblast | 108682 | 4807 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-30 04:21:20 | Irkutsk Oblast, Russia | |||
1334478 | 1334478 | 2021-09-28 | Russia | Irkutsk Oblast | 108307 | 4795 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-29 04:21:45 | Irkutsk Oblast, Russia | |||
1235847 | 1235847 | 2021-09-27 | Russia | Irkutsk Oblast | 107937 | 4784 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-28 04:21:28 | Irkutsk Oblast, Russia | |||
2076148 | 2076148 | 2021-09-26 | Russia | Irkutsk Oblast | 107564 | 4773 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-27 04:21:16 | Irkutsk Oblast, Russia | |||
1724700 | 1724700 | 2021-09-25 | Russia | Irkutsk Oblast | 107189 | 4761 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-26 04:21:29 | Irkutsk Oblast, Russia | |||
1921420 | 1921420 | 2021-09-24 | Russia | Irkutsk Oblast | 106810 | 4748 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-25 04:21:31 | Irkutsk Oblast, Russia | |||
601891 | 601891 | 2021-09-23 | Russia | Irkutsk Oblast | 106430 | 4734 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-24 04:21:44 | Irkutsk Oblast, Russia | |||
3011535 | 3011535 | 2021-09-22 | Russia | Irkutsk Oblast | 106056 | 4722 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-23 04:21:43 | Irkutsk Oblast, Russia | |||
3757673 | 3757673 | 2021-09-21 | Russia | Irkutsk Oblast | 105687 | 4709 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-22 04:21:45 | Irkutsk Oblast, Russia | |||
809776 | 809776 | 2021-09-20 | Russia | Irkutsk Oblast | 105320 | 4697 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-21 04:21:26 | Irkutsk Oblast, Russia | |||
1814975 | 1814975 | 2021-09-19 | Russia | Irkutsk Oblast | 104952 | 4685 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-20 04:21:22 | Irkutsk Oblast, Russia | |||
16555 | 16555 | 2021-09-18 | Russia | Irkutsk Oblast | 104582 | 4672 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-19 04:21:34 | Irkutsk Oblast, Russia | |||
2618240 | 2618240 | 2021-09-17 | Russia | Irkutsk Oblast | 104206 | 4660 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-18 04:21:24 | Irkutsk Oblast, Russia | |||
2808948 | 2808948 | 2021-09-16 | Russia | Irkutsk Oblast | 103828 | 4647 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-17 04:21:46 | Irkutsk Oblast, Russia | |||
1374693 | 1374693 | 2021-09-15 | Russia | Irkutsk Oblast | 103455 | 4632 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-16 04:22:19 | Irkutsk Oblast, Russia | |||
2462992 | 2462992 | 2021-09-14 | Russia | Irkutsk Oblast | 103083 | 4620 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-15 03:22:37 | Irkutsk Oblast, Russia | |||
1385831 | 1385831 | 2021-09-13 | Russia | Irkutsk Oblast | 102714 | 4607 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-14 04:21:41 | Irkutsk Oblast, Russia | |||
1885200 | 1885200 | 2021-09-12 | Russia | Irkutsk Oblast | 102343 | 4595 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-13 04:21:15 | Irkutsk Oblast, Russia | |||
3806103 | 3806103 | 2021-09-11 | Russia | Irkutsk Oblast | 101971 | 4581 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-12 04:21:13 | Irkutsk Oblast, Russia | |||
3449043 | 3449043 | 2021-09-10 | Russia | Irkutsk Oblast | 101593 | 4565 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-11 04:21:30 | Irkutsk Oblast, Russia | |||
1262989 | 1262989 | 2021-09-09 | Russia | Irkutsk Oblast | 101213 | 4551 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-10 04:21:20 | Irkutsk Oblast, Russia | |||
2279359 | 2279359 | 2021-09-08 | Russia | Irkutsk Oblast | 100838 | 4540 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-09 04:21:27 | Irkutsk Oblast, Russia | |||
642138 | 642138 | 2021-09-07 | Russia | Irkutsk Oblast | 100466 | 4530 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-08 04:21:31 | Irkutsk Oblast, Russia | |||
3194201 | 3194201 | 2021-09-06 | Russia | Irkutsk Oblast | 100089 | 4515 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-07 04:21:35 | Irkutsk Oblast, Russia | |||
3281069 | 3281069 | 2021-09-05 | Russia | Irkutsk Oblast | 99709 | 4501 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-06 04:21:22 | Irkutsk Oblast, Russia | |||
249483 | 249483 | 2021-09-04 | Russia | Irkutsk Oblast | 99325 | 4489 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-05 04:21:33 | Irkutsk Oblast, Russia | |||
3974764 | 3974764 | 2021-09-03 | Russia | Irkutsk Oblast | 98938 | 4474 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-04 04:21:28 | Irkutsk Oblast, Russia | |||
178226 | 178226 | 2021-09-02 | Russia | Irkutsk Oblast | 98553 | 4460 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-03 04:21:20 | Irkutsk Oblast, Russia | |||
67261 | 67261 | 2021-09-01 | Russia | Irkutsk Oblast | 98164 | 4446 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-02 04:21:15 | Irkutsk Oblast, Russia | |||
2068103 | 2068103 | 2021-08-31 | Russia | Irkutsk Oblast | 97771 | 4435 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-01 04:21:38 | Irkutsk Oblast, Russia | |||
1775557 | 1775557 | 2021-08-30 | Russia | Irkutsk Oblast | 97376 | 4428 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-31 04:21:46 | Irkutsk Oblast, Russia | |||
3892131 | 3892131 | 2021-08-29 | Russia | Irkutsk Oblast | 96979 | 4414 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-30 04:21:23 | Irkutsk Oblast, Russia | |||
2793234 | 2793234 | 2021-08-28 | Russia | Irkutsk Oblast | 96581 | 4401 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-29 04:21:14 | Irkutsk Oblast, Russia | |||
2923393 | 2923393 | 2021-08-27 | Russia | Irkutsk Oblast | 96182 | 4387 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-28 04:21:28 | Irkutsk Oblast, Russia | |||
1596407 | 1596407 | 2021-08-26 | Russia | Irkutsk Oblast | 95781 | 4375 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-27 04:21:37 | Irkutsk Oblast, Russia | |||
32616 | 32616 | 2021-08-25 | Russia | Irkutsk Oblast | 95382 | 4361 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-26 04:21:28 | Irkutsk Oblast, Russia | |||
3105655 | 3105655 | 2021-08-24 | Russia | Irkutsk Oblast | 94984 | 4343 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-25 04:21:41 | Irkutsk Oblast, Russia | |||
3165826 | 3165826 | 2021-08-23 | Russia | Irkutsk Oblast | 94589 | 4326 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-24 04:21:19 | Irkutsk Oblast, Russia | |||
2175753 | 2175753 | 2021-08-22 | Russia | Irkutsk Oblast | 94194 | 4307 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-23 04:21:27 | Irkutsk Oblast, Russia | |||
3555849 | 3555849 | 2021-08-21 | Russia | Irkutsk Oblast | 93795 | 4289 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-22 04:21:29 | Irkutsk Oblast, Russia | |||
1854191 | 1854191 | 2021-08-20 | Russia | Irkutsk Oblast | 93393 | 4270 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-21 04:21:38 | Irkutsk Oblast, Russia | |||
511898 | 511898 | 2021-08-19 | Russia | Irkutsk Oblast | 92993 | 4251 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-20 04:21:33 | Irkutsk Oblast, Russia | |||
2518377 | 2518377 | 2021-08-18 | Russia | Irkutsk Oblast | 92594 | 4230 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-19 04:21:15 | Irkutsk Oblast, Russia | |||
245469 | 245469 | 2021-08-17 | Russia | Irkutsk Oblast | 92196 | 4206 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-18 04:21:35 | Irkutsk Oblast, Russia | |||
1604432 | 1604432 | 2021-08-16 | Russia | Irkutsk Oblast | 91802 | 4180 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-17 04:21:49 | Irkutsk Oblast, Russia |
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]);