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 = "Dagestan Republic" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026544 | 1026544 | 2020-10-17 | Russia | Dagestan Republic | 14856 | 712 | 13050 | 1094 | 43.05749160000001 | 47.1332224 | 2020-10-18 04:24:25 | Dagestan Republic, Russia | ||
2857039 | 2857039 | 2020-10-16 | Russia | Dagestan Republic | 14769 | 709 | 12961 | 1099 | 43.05749160000001 | 47.1332224 | 2020-10-17 04:24:12 | Dagestan Republic, Russia | ||
786569 | 786569 | 2020-10-15 | Russia | Dagestan Republic | 14681 | 705 | 12868 | 1108 | 43.05749160000001 | 47.1332224 | 2020-10-16 04:24:01 | Dagestan Republic, Russia | ||
79280 | 79280 | 2020-10-14 | Russia | Dagestan Republic | 14597 | 696 | 12782 | 1119 | 43.05749160000001 | 47.1332224 | 2020-10-15 04:24:28 | Dagestan Republic, Russia | ||
3782095 | 3782095 | 2020-10-13 | Russia | Dagestan Republic | 14512 | 690 | 12693 | 1129 | 43.05749160000001 | 47.1332224 | 2020-10-14 04:24:05 | Dagestan Republic, Russia | ||
2291635 | 2291635 | 2020-10-12 | Russia | Dagestan Republic | 14427 | 684 | 12615 | 1128 | 43.05749160000001 | 47.1332224 | 2020-10-13 04:24:02 | Dagestan Republic, Russia | ||
3786088 | 3786088 | 2020-10-11 | Russia | Dagestan Republic | 14345 | 681 | 12523 | 1141 | 43.05749160000001 | 47.1332224 | 2020-10-12 04:23:45 | Dagestan Republic, Russia | ||
2602226 | 2602226 | 2020-10-10 | Russia | Dagestan Republic | 14264 | 678 | 12421 | 1165 | 43.05749160000001 | 47.1332224 | 2020-10-11 04:23:46 | Dagestan Republic, Russia | ||
817759 | 817759 | 2020-10-09 | Russia | Dagestan Republic | 14182 | 672 | 12327 | 1183 | 43.05749160000001 | 47.1332224 | 2020-10-10 04:23:57 | Dagestan Republic, Russia | ||
2689874 | 2689874 | 2020-10-08 | Russia | Dagestan Republic | 14100 | 666 | 12238 | 1196 | 43.05749160000001 | 47.1332224 | 2020-10-09 04:23:59 | Dagestan Republic, Russia | ||
1042016 | 1042016 | 2020-10-07 | Russia | Dagestan Republic | 14018 | 663 | 12148 | 1207 | 43.05749160000001 | 47.1332224 | 2020-10-08 04:23:56 | Dagestan Republic, Russia | ||
3117677 | 3117677 | 2020-10-06 | Russia | Dagestan Republic | 13935 | 656 | 12056 | 1223 | 43.05749160000001 | 47.1332224 | 2020-10-07 04:23:40 | Dagestan Republic, Russia | ||
3802089 | 3802089 | 2020-10-05 | Russia | Dagestan Republic | 13852 | 647 | 11980 | 1225 | 43.05749160000001 | 47.1332224 | 2020-10-06 04:23:33 | Dagestan Republic, Russia | ||
1822979 | 1822979 | 2020-10-04 | Russia | Dagestan Republic | 13768 | 642 | 11899 | 1227 | 43.05749160000001 | 47.1332224 | 2020-10-05 04:23:33 | Dagestan Republic, Russia | ||
2514363 | 2514363 | 2020-10-03 | Russia | Dagestan Republic | 13684 | 640 | 11809 | 1235 | 43.05749160000001 | 47.1332224 | 2020-10-04 04:23:44 | Dagestan Republic, Russia | ||
3389581 | 3389581 | 2020-10-02 | Russia | Dagestan Republic | 13599 | 638 | 11729 | 1232 | 43.05749160000001 | 47.1332224 | 2020-10-03 04:23:40 | Dagestan Republic, Russia | ||
2379822 | 2379822 | 2020-10-01 | Russia | Dagestan Republic | 13514 | 629 | 11642 | 1243 | 43.05749160000001 | 47.1332224 | 2020-10-02 04:23:51 | Dagestan Republic, Russia | ||
1046008 | 1046008 | 2020-09-30 | Russia | Dagestan Republic | 13429 | 621 | 11563 | 1245 | 43.05749160000001 | 47.1332224 | 2020-10-01 04:23:42 | Dagestan Republic, Russia | ||
967089 | 967089 | 2020-09-29 | Russia | Dagestan Republic | 13347 | 612 | 11481 | 1254 | 43.05749160000001 | 47.1332224 | 2020-09-30 04:23:33 | Dagestan Republic, Russia | ||
1515586 | 1515586 | 2020-09-28 | Russia | Dagestan Republic | 13264 | 604 | 11412 | 1248 | 43.05749160000001 | 47.1332224 | 2020-09-29 04:23:42 | Dagestan Republic, Russia | ||
2582174 | 2582174 | 2020-09-27 | Russia | Dagestan Republic | 13182 | 597 | 11336 | 1249 | 43.0574916 | 47.1332224 | 2020-09-28 04:23:00 | Dagestan Republic, Russia | ||
2614226 | 2614226 | 2020-09-26 | Russia | Dagestan Republic | 13100 | 589 | 11261 | 1250 | 43.0574916 | 47.1332224 | 2020-09-27 04:23:00 | Dagestan Republic, Russia | ||
2812941 | 2812941 | 2020-09-25 | Russia | Dagestan Republic | 13016 | 580 | 11186 | 1250 | 43.0574916 | 47.1332224 | 2020-09-26 04:23:00 | Dagestan Republic, Russia | ||
2606218 | 2606218 | 2020-09-24 | Russia | Dagestan Republic | 12933 | 571 | 11110 | 1252 | 43.0574916 | 47.1332224 | 2020-09-25 04:23:00 | Dagestan Republic, Russia | ||
2653961 | 2653961 | 2020-09-23 | Russia | Dagestan Republic | 12851 | 564 | 11033 | 1254 | 43.0574916 | 47.1332224 | 2020-09-24 04:23:00 | Dagestan Republic, Russia | ||
3316410 | 3316410 | 2020-09-22 | Russia | Dagestan Republic | 12768 | 557 | 10958 | 1253 | 43.0574916 | 47.1332224 | 2020-09-23 04:23:00 | Dagestan Republic, Russia | ||
2837009 | 2837009 | 2020-09-21 | Russia | Dagestan Republic | 12685 | 552 | 10891 | 1242 | 43.0574916 | 47.1332224 | 2020-09-22 04:23:00 | Dagestan Republic, Russia | ||
3093613 | 3093613 | 2020-09-20 | Russia | Dagestan Republic | 12600 | 547 | 10823 | 1230 | 43.0574916 | 47.1332224 | 2020-09-21 04:23:00 | Dagestan Republic, Russia | ||
2454963 | 2454963 | 2020-09-19 | Russia | Dagestan Republic | 12514 | 543 | 10744 | 1227 | 43.0574916 | 47.1332224 | 2020-09-20 04:22:00 | Dagestan Republic, Russia | ||
2849032 | 2849032 | 2020-09-18 | Russia | Dagestan Republic | 12429 | 538 | 10669 | 1222 | 43.0574916 | 47.1332224 | 2020-09-19 04:22:00 | Dagestan Republic, Russia | ||
1121781 | 1121781 | 2020-09-17 | Russia | Dagestan Republic | 12345 | 533 | 10597 | 1215 | 43.0574916 | 47.1332224 | 2020-09-18 05:05:00 | Dagestan Republic, Russia | ||
666470 | 666470 | 2020-09-16 | Russia | Dagestan Republic | 12260 | 529 | 10533 | 1198 | 43.0574916 | 47.1332224 | 2020-09-17 04:22:00 | Dagestan Republic, Russia | ||
2729195 | 2729195 | 2020-09-15 | Russia | Dagestan Republic | 12175 | 528 | 10468 | 1179 | 43.05749160000001 | 47.1332224 | 2020-09-16 04:22:53 | Dagestan Republic, Russia | ||
344467 | 344467 | 2020-09-14 | Russia | Dagestan Republic | 12092 | 524 | 10401 | 1167 | 43.05749160000001 | 47.1332224 | 2020-09-15 03:22:50 | Dagestan Republic, Russia | ||
2868906 | 2868906 | 2020-09-13 | Russia | Dagestan Republic | 12008 | 523 | 10331 | 1154 | 43.0574916 | 47.1332224 | 2020-09-14 04:26:00 | Dagestan Republic, Russia | ||
546945 | 546945 | 2020-09-12 | Russia | Dagestan Republic | 11925 | 521 | 10268 | 1136 | 43.05749160000001 | 47.1332224 | 2020-09-13 04:30:52 | Dagestan Republic, Russia | ||
1444774 | 1444774 | 2020-09-11 | Russia | Dagestan Republic | 11842 | 517 | 10204 | 1121 | 43.05749160000001 | 47.1332224 | 2020-09-12 04:25:05 | Dagestan Republic, Russia | ||
1173375 | 1173375 | 2020-09-10 | Russia | Dagestan Republic | 11760 | 515 | 10138 | 1107 | 43.05749160000001 | 47.1332224 | 2020-09-11 04:46:23 | Dagestan Republic, Russia | ||
2171740 | 2171740 | 2020-09-09 | Russia | Dagestan Republic | 11678 | 514 | 10080 | 1084 | 43.05749160000001 | 47.1332224 | 2020-09-10 04:29:01 | Dagestan Republic, Russia | ||
1243949 | 1243949 | 2020-09-08 | Russia | Dagestan Republic | 11598 | 512 | 10025 | 1061 | 43.05749160000001 | 47.1332224 | 2020-09-09 04:28:48 | Dagestan Republic, Russia | ||
427528 | 427528 | 2020-09-07 | Russia | Dagestan Republic | 11520 | 510 | 9977 | 1033 | 43.05749160000001 | 47.1332224 | 2020-09-08 04:28:25 | Dagestan Republic, Russia | ||
3161813 | 3161813 | 2020-09-06 | Russia | Dagestan Republic | 11442 | 507 | 9928 | 1007 | 43.05749160000001 | 47.1332224 | 2020-09-07 04:28:30 | Dagestan Republic, Russia | ||
813768 | 813768 | 2020-09-05 | Russia | Dagestan Republic | 11367 | 507 | 9877 | 983 | 43.05749160000001 | 47.1332224 | 2020-09-06 04:28:33 | Dagestan Republic, Russia | ||
2661968 | 2661968 | 2020-09-04 | Russia | Dagestan Republic | 11292 | 506 | 9829 | 957 | 43.05749160000001 | 47.1332224 | 2020-09-05 04:28:19 | Dagestan Republic, Russia | ||
1354508 | 1354508 | 2020-09-03 | Russia | Dagestan Republic | 11219 | 505 | 9786 | 928 | 43.05749160000001 | 47.1332224 | 2020-09-04 04:28:26 | Dagestan Republic, Russia | ||
1105745 | 1105745 | 2020-09-02 | Russia | Dagestan Republic | 11145 | 502 | 9745 | 898 | 43.05749160000001 | 47.1332224 | 2020-09-03 04:28:22 | Dagestan Republic, Russia | ||
2060074 | 2060074 | 2020-09-01 | Russia | Dagestan Republic | 11073 | 499 | 9697 | 877 | 43.05749160000001 | 47.1332224 | 2020-09-02 04:28:25 | Dagestan Republic, Russia | ||
194259 | 194259 | 2020-08-31 | Russia | Dagestan Republic | 10999 | 497 | 9650 | 852 | 43.05749160000001 | 47.1332224 | 2020-09-01 04:28:31 | Dagestan Republic, Russia | ||
3932218 | 3932218 | 2020-08-30 | Russia | Dagestan Republic | 10928 | 495 | 9611 | 822 | 43.05749160000001 | 47.1332224 | 2020-08-31 04:28:27 | Dagestan Republic, Russia | ||
609880 | 609880 | 2020-08-29 | Russia | Dagestan Republic | 10858 | 495 | 9569 | 794 | 43.05749160000001 | 47.1332224 | 2020-08-30 04:28:22 | Dagestan Republic, Russia | ||
1523375 | 1523375 | 2020-08-28 | Russia | Dagestan Republic | 10788 | 494 | 9525 | 769 | 43.05749160000001 | 47.1332224 | 2020-08-29 04:28:19 | Dagestan Republic, Russia | ||
2510376 | 2510376 | 2020-08-27 | Russia | Dagestan Republic | 10716 | 489 | 9479 | 748 | 43.05749160000001 | 47.1332224 | 2020-08-28 04:28:11 | Dagestan Republic, Russia | ||
1996836 | 1996836 | 2020-08-26 | Russia | Dagestan Republic | 10651 | 487 | 9433 | 731 | 43.05749160000001 | 47.1332224 | 2020-08-27 04:28:15 | Dagestan Republic, Russia | ||
3562760 | 3562760 | 2020-08-25 | Russia | Dagestan Republic | 10586 | 485 | 9391 | 710 | 43.05749160000001 | 47.1332224 | 2020-08-26 04:28:11 | Dagestan Republic, Russia | ||
2991464 | 2991464 | 2020-08-24 | Russia | Dagestan Republic | 10521 | 485 | 9350 | 686 | 43.05749160000001 | 47.1332224 | 2020-08-25 04:28:02 | Dagestan Republic, Russia | ||
2215859 | 2215859 | 2020-08-23 | Russia | Dagestan Republic | 10458 | 483 | 9307 | 668 | 43.05749160000001 | 47.1332224 | 2020-08-24 04:27:56 | Dagestan Republic, Russia | ||
2299641 | 2299641 | 2020-08-22 | Russia | Dagestan Republic | 10395 | 482 | 9261 | 652 | 43.05749160000001 | 47.1332224 | 2020-08-23 04:27:48 | Dagestan Republic, Russia | ||
1479748 | 1479748 | 2020-08-21 | Russia | Dagestan Republic | 10334 | 478 | 9219 | 637 | 43.05749160000001 | 47.1332224 | 2020-08-22 04:27:49 | Dagestan Republic, Russia | ||
3484497 | 3484497 | 2020-08-20 | Russia | Dagestan Republic | 10272 | 477 | 9175 | 620 | 43.05749160000001 | 47.1332224 | 2020-08-21 04:27:41 | Dagestan Republic, Russia | ||
206446 | 206446 | 2020-08-19 | Russia | Dagestan Republic | 10210 | 474 | 9130 | 606 | 43.05749160000001 | 47.1332224 | 2020-08-20 04:27:43 | Dagestan Republic, Russia | ||
3178200 | 3178200 | 2020-08-18 | Russia | Dagestan Republic | 10151 | 470 | 9087 | 594 | 43.0574916 | 47.1332224 | 2020-08-19 04:27:00 | Dagestan Republic, Russia | ||
837804 | 837804 | 2020-08-17 | Russia | Dagestan Republic | 10091 | 470 | 9043 | 578 | 43.05749160000001 | 47.1332224 | 2020-08-18 04:27:56 | Dagestan Republic, Russia | ||
1556162 | 1556162 | 2020-08-16 | Russia | Dagestan Republic | 10032 | 469 | 9001 | 562 | 43.05749160000001 | 47.1332224 | 2020-08-17 04:27:20 | Dagestan Republic, Russia | ||
146164 | 146164 | 2020-08-15 | Russia | Dagestan Republic | 9974 | 469 | 8957 | 548 | 43.05749160000001 | 47.1332224 | 2020-08-16 04:27:42 | Dagestan Republic, Russia | ||
1612439 | 1612439 | 2020-08-14 | Russia | Dagestan Republic | 9917 | 467 | 8914 | 536 | 43.05749160000001 | 47.1332224 | 2020-08-15 04:27:31 | Dagestan Republic, Russia | ||
583023 | 583023 | 2020-08-13 | Russia | Dagestan Republic | 9861 | 464 | 8869 | 528 | 43.05749160000001 | 47.1332224 | 2020-08-14 04:51:19 | Dagestan Republic, Russia | ||
3531642 | 3531642 | 2020-08-12 | Russia | Dagestan Republic | 9812 | 461 | 8819 | 532 | 43.05749160000001 | 47.1332224 | 2020-08-13 04:29:15 | Dagestan Republic, Russia | ||
662491 | 662491 | 2020-08-11 | Russia | Dagestan Republic | 9763 | 458 | 8775 | 530 | 43.05749160000001 | 47.1332224 | 2020-08-12 04:27:29 | Dagestan Republic, Russia | ||
1920271 | 1920271 | 2020-08-10 | Russia | Dagestan Republic | 9714 | 455 | 8730 | 529 | 43.05749160000001 | 47.1332224 | 2020-08-11 04:35:08 | Dagestan Republic, Russia | ||
3923080 | 3923080 | 2020-08-09 | Russia | Dagestan Republic | 9665 | 454 | 8686 | 525 | 43.05749160000001 | 47.1332224 | 2020-08-10 04:34:55 | Dagestan Republic, Russia | ||
371248 | 371248 | 2020-08-08 | Russia | Dagestan Republic | 9613 | 453 | 8644 | 516 | 43.05749160000001 | 47.1332224 | 2020-08-09 04:34:54 | Dagestan Republic, Russia | ||
458432 | 458432 | 2020-08-07 | Russia | Dagestan Republic | 9565 | 451 | 8598 | 516 | 43.05749160000001 | 47.1332224 | 2020-08-08 04:34:53 | Dagestan Republic, Russia | ||
3612117 | 3612117 | 2020-08-06 | Russia | Dagestan Republic | 9517 | 449 | 8551 | 517 | 43.05749160000001 | 47.1332224 | 2020-08-07 04:35:11 | Dagestan Republic, Russia | ||
3792947 | 3792947 | 2020-08-05 | Russia | Dagestan Republic | 9475 | 447 | 8501 | 527 | 43.05749160000001 | 47.1332224 | 2020-08-06 04:35:02 | Dagestan Republic, Russia | ||
98183 | 98183 | 2020-08-04 | Russia | Dagestan Republic | 9435 | 446 | 8443 | 546 | 43.05749160000001 | 47.1332224 | 2020-08-05 04:34:43 | Dagestan Republic, Russia | ||
2740066 | 2740066 | 2020-08-03 | Russia | Dagestan Republic | 9392 | 445 | 8389 | 558 | 43.05749160000001 | 47.1332224 | 2020-08-04 04:41:59 | Dagestan Republic, Russia | ||
2807818 | 2807818 | 2020-08-02 | Russia | Dagestan Republic | 9350 | 445 | 8338 | 567 | 43.05749160000001 | 47.1332224 | 2020-08-03 04:34:35 | Dagestan Republic, Russia | ||
753386 | 753386 | 2020-08-01 | Russia | Dagestan Republic | 9308 | 445 | 8288 | 575 | 43.05749160000001 | 47.1332224 | 2020-08-02 04:34:47 | Dagestan Republic, Russia | ||
3264551 | 3264551 | 2020-07-31 | Russia | Dagestan Republic | 9266 | 445 | 8229 | 592 | 43.05749160000001 | 47.1332224 | 2020-08-01 04:36:27 | Dagestan Republic, Russia | ||
1928258 | 1928258 | 2020-07-30 | Russia | Dagestan Republic | 9223 | 445 | 8174 | 604 | 43.05749160000001 | 47.1332224 | 2020-07-31 04:35:18 | Dagestan Republic, Russia | ||
2958426 | 2958426 | 2020-07-29 | Russia | Dagestan Republic | 9183 | 444 | 8111 | 628 | 43.05749160000001 | 47.1332224 | 2020-07-30 04:35:05 | Dagestan Republic, Russia | ||
3185042 | 3185042 | 2020-07-28 | Russia | Dagestan Republic | 9143 | 442 | 8051 | 650 | 43.05749160000001 | 47.1332224 | 2020-07-29 04:35:11 | Dagestan Republic, Russia | ||
177094 | 177094 | 2020-07-27 | Russia | Dagestan Republic | 9103 | 442 | 8029 | 632 | 43.05749160000001 | 47.1332224 | 2020-07-28 04:58:43 | Dagestan Republic, Russia | ||
442407 | 442407 | 2020-07-26 | Russia | Dagestan Republic | 9062 | 439 | 7971 | 652 | 43.05749160000001 | 47.1332224 | 2020-07-27 04:35:02 | Dagestan Republic, Russia | ||
1502651 | 1502651 | 2020-07-25 | Russia | Dagestan Republic | 9021 | 436 | 7908 | 677 | 43.05749160000001 | 47.1332224 | 2020-07-26 04:35:00 | Dagestan Republic, Russia | ||
2563621 | 2563621 | 2020-07-24 | Russia | Dagestan Republic | 8981 | 433 | 7857 | 691 | 43.05749160000001 | 47.1332224 | 2020-07-25 04:47:39 | Dagestan Republic, Russia | ||
61844 | 61844 | 2020-07-23 | Russia | Dagestan Republic | 8941 | 431 | 7806 | 704 | 43.05749160000001 | 47.1332224 | 2020-07-24 05:30:40 | Dagestan Republic, Russia | ||
844641 | 844641 | 2020-07-22 | Russia | Dagestan Republic | 8901 | 430 | 7727 | 744 | 43.05749160000001 | 47.1332224 | 2020-07-23 05:15:04 | Dagestan Republic, Russia | ||
1707380 | 1707380 | 2020-07-21 | Russia | Dagestan Republic | 8860 | 428 | 7638 | 794 | 43.05749160000001 | 47.1332224 | 2020-07-22 04:34:42 | Dagestan Republic, Russia | ||
326871 | 326871 | 2020-07-20 | Russia | Dagestan Republic | 8819 | 427 | 7554 | 838 | 43.05749160000001 | 47.1332224 | 2020-07-21 04:38:46 | Dagestan Republic, Russia | ||
121776 | 121776 | 2020-07-19 | Russia | Dagestan Republic | 8778 | 426 | 7467 | 885 | 43.05749160000001 | 47.1332224 | 2020-07-20 05:34:40 | Dagestan Republic, Russia | ||
3205165 | 3205165 | 2020-07-18 | Russia | Dagestan Republic | 8735 | 424 | 7371 | 940 | 43.05749160000001 | 47.1332224 | 2020-07-19 04:34:58 | Dagestan Republic, Russia | ||
2708467 | 2708467 | 2020-07-17 | Russia | Dagestan Republic | 8691 | 422 | 7238 | 1031 | 43.05749160000001 | 47.1332224 | 2020-07-18 04:34:45 | Dagestan Republic, Russia | ||
367286 | 367286 | 2020-07-16 | Russia | Dagestan Republic | 8647 | 419 | 7150 | 1078 | 43.05749160000001 | 47.1332224 | 2020-07-17 04:34:50 | Dagestan Republic, Russia | ||
2747954 | 2747954 | 2020-07-15 | Russia | Dagestan Republic | 8602 | 419 | 7019 | 1164 | 43.05749160000001 | 47.1332224 | 2020-07-16 04:44:59 | Dagestan Republic, Russia | ||
2158598 | 2158598 | 2020-07-14 | Russia | Dagestan Republic | 8560 | 417 | 6931 | 1212 | 43.05749160000001 | 47.1332224 | 2020-07-15 04:34:39 | Dagestan Republic, Russia | ||
3491239 | 3491239 | 2020-07-13 | Russia | Dagestan Republic | 8514 | 415 | 6849 | 1250 | 43.05749160000001 | 47.1332224 | 2020-07-14 04:34:46 | Dagestan Republic, Russia | ||
3737501 | 3737501 | 2020-07-12 | Russia | Dagestan Republic | 8468 | 413 | 6761 | 1294 | 43.05749160000001 | 47.1332224 | 2020-07-13 04:43:04 | Dagestan Republic, Russia | ||
3435896 | 3435896 | 2020-07-11 | Russia | Dagestan Republic | 8422 | 410 | 6670 | 1342 | 43.05749160000001 | 47.1332224 | 2020-07-12 04:34:30 | Dagestan Republic, Russia | ||
3237394 | 3237394 | 2020-07-10 | Russia | Dagestan Republic | 8374 | 407 | 6571 | 1396 | 43.05749160000001 | 47.1332224 | 2020-07-11 04:34:26 | Dagestan Republic, 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]);