johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Irkutsk Oblast" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, recovered, active, last_update, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
531 | 531 | 2021-12-02 | Russia | Irkutsk Oblast | 139931 | 6256 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-03 04:23:05 | 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 | |||
16555 | 16555 | 2021-09-18 | Russia | Irkutsk Oblast | 104582 | 4672 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-19 04:21:34 | Irkutsk Oblast, Russia | |||
24602 | 24602 | 2022-03-20 | Russia | Irkutsk Oblast | 277338 | 8132 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-21 04:20:50 | 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 | |||
32616 | 32616 | 2021-08-25 | Russia | Irkutsk Oblast | 95382 | 4361 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-26 04:21:28 | 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 | |||
61913 | 61913 | 2020-07-23 | Russia | Irkutsk Oblast | 12152 | 144 | 6991 | 5017 | 56.6370122 | 104.71922099999999 | 2020-07-24 05:30:40 | 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 | |||
71292 | 71292 | 2022-02-07 | Russia | Irkutsk Oblast | 183755 | 7536 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-08 04:21:15 | 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 | |||
98256 | 98256 | 2020-08-04 | Russia | Irkutsk Oblast | 13988 | 182 | 9158 | 4648 | 56.6370122 | 104.71922099999999 | 2020-08-05 04:34:43 | Irkutsk Oblast, Russia | ||
99527 | 99527 | 2022-01-14 | Russia | Irkutsk Oblast | 160895 | 7143 | 0 | 56.6370122 | 104.71922099999999 | 2022-01-15 04:21:07 | Irkutsk Oblast, Russia | |||
103526 | 103526 | 2021-08-15 | Russia | Irkutsk Oblast | 91406 | 4146 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-16 04:21:31 | Irkutsk Oblast, Russia | |||
126934 | 126934 | 2022-01-09 | Russia | Irkutsk Oblast | 159570 | 7063 | 0 | 56.6370122 | 104.71922099999999 | 2022-01-10 04:22:07 | Irkutsk Oblast, Russia | |||
138172 | 138172 | 2021-12-04 | Russia | Irkutsk Oblast | 141138 | 6313 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-05 04:22:25 | Irkutsk Oblast, Russia | |||
150185 | 150185 | 2021-11-29 | Russia | Irkutsk Oblast | 138129 | 6179 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-30 04:22:53 | Irkutsk Oblast, Russia | |||
158214 | 158214 | 2022-03-29 | Russia | Irkutsk Oblast | 285560 | 8225 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-30 04:20:45 | 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 | |||
177167 | 177167 | 2020-07-27 | Russia | Irkutsk Oblast | 12813 | 154 | 7503 | 5156 | 56.6370122 | 104.71922099999999 | 2020-07-28 04:58:43 | 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 | |||
186272 | 186272 | 2022-02-13 | Russia | Irkutsk Oblast | 202223 | 7619 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-14 04:20:51 | Irkutsk Oblast, Russia | |||
217141 | 217141 | 2020-06-08 | Russia | Irkutsk Oblast | 2877 | 16 | 725 | 2136 | 56.6370122 | 104.71922099999999 | 2020-06-09 03:33:03 | Irkutsk Oblast, Russia | ||
233444 | 233444 | 2022-02-11 | Russia | Irkutsk Oblast | 195036 | 7595 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-12 04:21:06 | 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 | |||
249483 | 249483 | 2021-09-04 | Russia | Irkutsk Oblast | 99325 | 4489 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-05 04:21:33 | Irkutsk Oblast, Russia | |||
261734 | 261734 | 2022-03-15 | Russia | Irkutsk Oblast | 271937 | 8069 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-16 04:20:50 | 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 | |||
288197 | 288197 | 2021-10-31 | Russia | Irkutsk Oblast | 121744 | 5386 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-01 04:22:01 | Irkutsk Oblast, Russia | |||
304070 | 304070 | 2022-04-16 | Russia | Irkutsk Oblast | 290135 | 8358 | 0 | 56.6370122 | 104.71922099999999 | 2022-04-17 04:20:59 | Irkutsk Oblast, Russia | |||
316118 | 316118 | 2022-02-12 | Russia | Irkutsk Oblast | 198751 | 7610 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-13 04:21:00 | Irkutsk Oblast, Russia | |||
336138 | 336138 | 2022-03-18 | Russia | Irkutsk Oblast | 275287 | 8109 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-19 04:20:47 | Irkutsk Oblast, Russia | |||
356528 | 356528 | 2022-03-11 | Russia | Irkutsk Oblast | 265832 | 8013 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-12 04:20:50 | Irkutsk Oblast, Russia | |||
367354 | 367354 | 2020-07-16 | Russia | Irkutsk Oblast | 10881 | 109 | 5625 | 5147 | 56.6370122 | 104.71922099999999 | 2020-07-17 04:34:50 | Irkutsk Oblast, Russia | ||
371321 | 371321 | 2020-08-08 | Russia | Irkutsk Oblast | 14500 | 206 | 10285 | 4009 | 56.6370122 | 104.71922099999999 | 2020-08-09 04:34:54 | Irkutsk Oblast, Russia | ||
404495 | 404495 | 2021-12-07 | Russia | Irkutsk Oblast | 142933 | 6393 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-08 04:22:46 | 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 | |||
442480 | 442480 | 2020-07-26 | Russia | Irkutsk Oblast | 12648 | 150 | 7423 | 5075 | 56.6370122 | 104.71922099999999 | 2020-07-27 04:35:02 | 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 | |||
447572 | 447572 | 2021-11-17 | Russia | Irkutsk Oblast | 130946 | 5846 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-18 04:21:33 | Irkutsk Oblast, Russia | |||
458505 | 458505 | 2020-08-07 | Russia | Irkutsk Oblast | 14381 | 206 | 10065 | 4110 | 56.6370122 | 104.71922099999999 | 2020-08-08 04:34:53 | Irkutsk Oblast, Russia | ||
459581 | 459581 | 2022-02-02 | Russia | Irkutsk Oblast | 172461 | 7454 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-03 04:21:21 | 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 | |||
491837 | 491837 | 2021-10-14 | Russia | Irkutsk Oblast | 114470 | 4983 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-15 04:21:26 | 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 | |||
499870 | 499870 | 2022-04-02 | Russia | Irkutsk Oblast | 287385 | 8260 | 0 | 56.6370122 | 104.71922099999999 | 2022-04-03 04:20:48 | Irkutsk Oblast, Russia | |||
507884 | 507884 | 2021-08-14 | Russia | Irkutsk Oblast | 91009 | 4111 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-15 04:21:41 | 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 | |||
534937 | 534937 | 2021-10-27 | Russia | Irkutsk Oblast | 119864 | 5277 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-28 04:22:08 | Irkutsk Oblast, Russia | |||
550975 | 550975 | 2021-12-08 | Russia | Irkutsk Oblast | 143534 | 6411 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-09 04:22:49 | Irkutsk Oblast, Russia | |||
554991 | 554991 | 2022-01-16 | Russia | Irkutsk Oblast | 161529 | 7176 | 0 | 56.6370122 | 104.71922099999999 | 2022-01-17 04:21: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 | |||
573993 | 573993 | 2020-06-06 | Russia | Irkutsk Oblast | 2613 | 16 | 638 | 1959 | 56.6370122 | 104.71922099999999 | 2020-06-07 03:53:30 | Irkutsk Oblast, Russia | ||
575034 | 575034 | 2022-02-25 | Russia | Irkutsk Oblast | 235291 | 7795 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-26 04:21:12 | 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 | |||
601891 | 601891 | 2021-09-23 | Russia | Irkutsk Oblast | 106430 | 4734 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-24 04:21:44 | 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 | |||
642138 | 642138 | 2021-09-07 | Russia | Irkutsk Oblast | 100466 | 4530 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-08 04:21:31 | Irkutsk Oblast, Russia | |||
650166 | 650166 | 2021-08-09 | Russia | Irkutsk Oblast | 89015 | 3958 | 0 | 56.6370122 | 104.71922099999999 | 2021-08-10 04:21:27 | 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 | |||
682542 | 682542 | 2021-10-24 | Russia | Irkutsk Oblast | 118570 | 5196 | 0 | 56.6370122 | 104.71922099999999 | 2021-10-25 04:22:31 | 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 | |||
694591 | 694591 | 2022-03-17 | Russia | Irkutsk Oblast | 274194 | 8096 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-18 04:20:55 | 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 | |||
706636 | 706636 | 2021-09-29 | Russia | Irkutsk Oblast | 108682 | 4807 | 0 | 56.6370122 | 104.71922099999999 | 2021-09-30 04:21:20 | 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 | |||
722699 | 722699 | 2021-11-20 | Russia | Irkutsk Oblast | 132725 | 5937 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-21 04:22:13 | Irkutsk Oblast, Russia | |||
730729 | 730729 | 2021-12-27 | Russia | Irkutsk Oblast | 154592 | 6855 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-28 04:21:47 | Irkutsk Oblast, Russia | |||
746546 | 746546 | 2022-04-23 | Russia | Irkutsk Oblast | 290941 | 8393 | 0 | 56.6370122 | 104.71922099999999 | 2022-04-24 04:20:56 | Irkutsk Oblast, Russia | |||
753459 | 753459 | 2020-08-01 | Russia | Irkutsk Oblast | 13568 | 176 | 8799 | 4593 | 56.6370122 | 104.71922099999999 | 2020-08-02 04:34:47 | Irkutsk Oblast, Russia | ||
758529 | 758529 | 2021-11-26 | Russia | Irkutsk Oblast | 136330 | 6095 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-27 04:22:45 | 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 | |||
782592 | 782592 | 2021-12-13 | Russia | Irkutsk Oblast | 146543 | 6531 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-14 04:22:38 | Irkutsk Oblast, Russia | |||
798631 | 798631 | 2021-12-22 | Russia | Irkutsk Oblast | 151825 | 6753 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-23 04:21:21 | 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 | |||
844714 | 844714 | 2020-07-22 | Russia | Irkutsk Oblast | 11976 | 132 | 6762 | 5082 | 56.6370122 | 104.71922099999999 | 2020-07-23 05:15:04 | Irkutsk Oblast, Russia | ||
876466 | 876466 | 2022-03-27 | Russia | Irkutsk Oblast | 283915 | 8206 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-28 04:20:33 | Irkutsk Oblast, Russia | |||
904380 | 904380 | 2021-11-24 | Russia | Irkutsk Oblast | 135124 | 6046 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-25 04:22:33 | Irkutsk Oblast, Russia | |||
919886 | 919886 | 2022-03-08 | Russia | Irkutsk Oblast | 260147 | 7967 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-09 04:20:59 | 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 | |||
943035 | 943035 | 2022-02-28 | Russia | Irkutsk Oblast | 242643 | 7844 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-01 04:21:09 | Irkutsk Oblast, Russia | |||
951067 | 951067 | 2022-03-12 | Russia | Irkutsk Oblast | 267641 | 8027 | 0 | 56.6370122 | 104.71922099999999 | 2022-03-13 04:20:49 | Irkutsk Oblast, Russia | |||
979150 | 979150 | 2022-02-01 | Russia | Irkutsk Oblast | 171344 | 7439 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-02 04:21:09 | 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 | |||
1014535 | 1014535 | 2021-11-21 | Russia | Irkutsk Oblast | 133326 | 5967 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-22 04:22:20 | Irkutsk Oblast, Russia | |||
1030577 | 1030577 | 2021-12-06 | Russia | Irkutsk Oblast | 142335 | 6366 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-07 04:22:34 | Irkutsk Oblast, Russia | |||
1058051 | 1058051 | 2022-02-23 | Russia | Irkutsk Oblast | 230575 | 7765 | 0 | 56.6370122 | 104.71922099999999 | 2022-02-24 04:21:14 | Irkutsk Oblast, Russia | |||
1078126 | 1078126 | 2021-12-09 | Russia | Irkutsk Oblast | 144137 | 6435 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-10 04:22:28 | Irkutsk Oblast, Russia | |||
1113791 | 1113791 | 2022-01-11 | Russia | Irkutsk Oblast | 160116 | 7094 | 0 | 56.6370122 | 104.71922099999999 | 2022-01-12 04:21:44 | Irkutsk Oblast, Russia | |||
1141114 | 1141114 | 2022-01-23 | Russia | Irkutsk Oblast | 164618 | 7298 | 0 | 56.6370122 | 104.71922099999999 | 2022-01-24 04:21:12 | Irkutsk Oblast, Russia | |||
1145130 | 1145130 | 2021-12-01 | Russia | Irkutsk Oblast | 139327 | 6229 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-02 04:22:37 | Irkutsk Oblast, Russia | |||
1210714 | 1210714 | 2020-06-09 | Russia | Irkutsk Oblast | 3083 | 18 | 820 | 2245 | 56.6370122 | 104.71922099999999 | 2020-06-10 04:07:00 | Irkutsk Oblast, Russia | ||
1215769 | 1215769 | 2022-01-08 | Russia | Irkutsk Oblast | 159272 | 7048 | 0 | 56.6370122 | 104.71922099999999 | 2022-01-09 04:21:46 | Irkutsk Oblast, Russia | |||
1223800 | 1223800 | 2022-04-14 | Russia | Irkutsk Oblast | 289842 | 8348 | 0 | 56.6370122 | 104.71922099999999 | 2022-04-15 04:20:57 | Irkutsk Oblast, Russia | |||
1227815 | 1227815 | 2022-01-24 | Russia | Irkutsk Oblast | 165169 | 7315 | 0 | 56.6370122 | 104.71922099999999 | 2022-01-25 04:21:05 | Irkutsk Oblast, Russia | |||
1231831 | 1231831 | 2021-11-28 | Russia | Irkutsk Oblast | 137531 | 6151 | 0 | 56.6370122 | 104.71922099999999 | 2021-11-29 04:22:30 | 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 | |||
1254974 | 1254974 | 2021-12-20 | Russia | Irkutsk Oblast | 150670 | 6703 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-21 03:21:27 | Irkutsk Oblast, Russia | |||
1258990 | 1258990 | 2021-12-18 | Russia | Irkutsk Oblast | 149501 | 6648 | 0 | 56.6370122 | 104.71922099999999 | 2021-12-19 04:21:11 | 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 |
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]);