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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
805243 | 805243 | 2020-06-01 | Russia | Dagestan Republic | 5096 | 260 | 4442 | 394 | 43.05749160000001 | 47.1332224 | 2020-06-02 02:33:08 | Dagestan Republic, Russia | ||
2555707 | 2555707 | 2020-06-02 | Russia | Dagestan Republic | 5228 | 271 | 4457 | 500 | 43.05749160000001 | 47.1332224 | 2020-06-03 02:33:13 | Dagestan Republic, Russia | ||
3866664 | 3866664 | 2020-06-03 | Russia | Dagestan Republic | 5341 | 287 | 4477 | 577 | 43.05749160000001 | 47.1332224 | 2020-06-04 02:33:14 | Dagestan Republic, Russia | ||
1281109 | 1281109 | 2020-06-04 | Russia | Dagestan Republic | 5463 | 287 | 4497 | 679 | 43.05749160000001 | 47.1332224 | 2020-06-05 02:33:06 | Dagestan Republic, Russia | ||
1269629 | 1269629 | 2020-06-05 | Russia | Dagestan Republic | 5587 | 288 | 4520 | 779 | 43.05749160000001 | 47.1332224 | 2020-06-06 02:33:00 | Dagestan Republic, Russia | ||
573932 | 573932 | 2020-06-06 | Russia | Dagestan Republic | 5743 | 298 | 4537 | 908 | 43.05749160000001 | 47.1332224 | 2020-06-07 03:53:30 | Dagestan Republic, Russia | ||
2799876 | 2799876 | 2020-06-07 | Russia | Dagestan Republic | 5858 | 303 | 4562 | 993 | 43.05749160000001 | 47.1332224 | 2020-06-08 03:33:22 | Dagestan Republic, Russia | ||
217079 | 217079 | 2020-06-08 | Russia | Dagestan Republic | 5970 | 308 | 4587 | 1075 | 43.05749160000001 | 47.1332224 | 2020-06-09 03:33:03 | Dagestan Republic, Russia | ||
1210652 | 1210652 | 2020-06-09 | Russia | Dagestan Republic | 6077 | 309 | 4611 | 1157 | 43.05749160000001 | 47.1332224 | 2020-06-10 04:07:00 | Dagestan Republic, Russia | ||
2863802 | 2863802 | 2020-06-10 | Russia | Dagestan Republic | 6175 | 309 | 4636 | 1230 | 43.05749160000001 | 47.1332224 | 2020-06-11 03:33:41 | Dagestan Republic, Russia | ||
1273358 | 1273358 | 2020-06-11 | Russia | Dagestan Republic | 6272 | 309 | 4662 | 1301 | 43.05749160000001 | 47.1332224 | 2020-06-12 05:09:52 | Dagestan Republic, Russia | ||
737388 | 737388 | 2020-06-12 | Russia | Dagestan Republic | 6367 | 309 | 4688 | 1370 | 43.05749160000001 | 47.1332224 | 2020-06-13 03:33:14 | Dagestan Republic, Russia | ||
3061068 | 3061068 | 2020-06-13 | Russia | Dagestan Republic | 6463 | 313 | 4710 | 1440 | 43.05749160000001 | 47.1332224 | 2020-06-14 03:33:15 | Dagestan Republic, Russia | ||
1837016 | 1837016 | 2020-06-14 | Russia | Dagestan Republic | 6557 | 316 | 4731 | 1510 | 43.05749160000001 | 47.1332224 | 2020-06-15 03:33:14 | Dagestan Republic, Russia | ||
287065 | 287065 | 2020-06-15 | Russia | Dagestan Republic | 6652 | 319 | 4754 | 1579 | 43.05749160000001 | 47.1332224 | 2020-06-16 04:33:09 | Dagestan Republic, Russia | ||
2386502 | 2386502 | 2020-06-16 | Russia | Dagestan Republic | 6745 | 328 | 4780 | 1637 | 43.05749160000001 | 47.1332224 | 2020-06-17 04:33:21 | Dagestan Republic, Russia | ||
1195739 | 1195739 | 2020-06-17 | Russia | Dagestan Republic | 6837 | 335 | 4802 | 1700 | 43.05749160000001 | 47.1332224 | 2020-06-18 04:33:18 | Dagestan Republic, Russia | ||
3682536 | 3682536 | 2020-06-18 | Russia | Dagestan Republic | 6927 | 338 | 4824 | 1765 | 43.05749160000001 | 47.1332224 | 2020-06-19 04:33:17 | Dagestan Republic, Russia | ||
1691387 | 1691387 | 2020-06-19 | Russia | Dagestan Republic | 7015 | 341 | 4854 | 1820 | 43.05749160000001 | 47.1332224 | 2020-06-20 04:33:19 | Dagestan Republic, Russia | ||
2437809 | 2437809 | 2020-06-20 | Russia | Dagestan Republic | 7103 | 344 | 4905 | 1854 | 43.05749160000001 | 47.1332224 | 2020-06-21 04:33:19 | Dagestan Republic, Russia | ||
3249216 | 3249216 | 2020-06-21 | Russia | Dagestan Republic | 7188 | 348 | 4936 | 1904 | 43.05749160000001 | 47.1332224 | 2020-06-22 04:33:20 | Dagestan Republic, Russia | ||
1510477 | 1510477 | 2020-06-22 | Russia | Dagestan Republic | 7267 | 351 | 4956 | 1960 | 43.05749160000001 | 47.1332224 | 2020-06-23 04:33:22 | Dagestan Republic, Russia | ||
1522283 | 1522283 | 2020-06-23 | Russia | Dagestan Republic | 7340 | 357 | 4997 | 1986 | 43.05749160000001 | 47.1332224 | 2020-06-24 04:33:28 | Dagestan Republic, Russia | ||
2700598 | 2700598 | 2020-06-24 | Russia | Dagestan Republic | 7415 | 360 | 5465 | 1590 | 43.05749160000001 | 47.1332224 | 2020-06-25 05:26:54 | Dagestan Republic, Russia | ||
2624958 | 2624958 | 2020-06-25 | Russia | Dagestan Republic | 7488 | 364 | 5468 | 1656 | 43.05749160000001 | 47.1332224 | 2020-06-26 04:33:43 | Dagestan Republic, Russia | ||
1135971 | 1135971 | 2020-06-26 | Russia | Dagestan Republic | 7561 | 367 | 5491 | 1703 | 43.05749160000001 | 47.1332224 | 2020-06-27 04:33:35 | Dagestan Republic, Russia | ||
2039690 | 2039690 | 2020-06-27 | Russia | Dagestan Republic | 7636 | 369 | 5525 | 1742 | 43.05749160000001 | 47.1332224 | 2020-06-28 04:34:04 | Dagestan Republic, Russia | ||
2306355 | 2306355 | 2020-06-28 | Russia | Dagestan Republic | 7707 | 371 | 5615 | 1721 | 43.05749160000001 | 47.1332224 | 2020-06-29 04:33:44 | Dagestan Republic, Russia | ||
2632792 | 2632792 | 2020-06-29 | Russia | Dagestan Republic | 7775 | 373 | 5682 | 1720 | 43.05749160000001 | 47.1332224 | 2020-06-30 04:33:48 | Dagestan Republic, Russia | ||
2974315 | 2974315 | 2020-06-30 | Russia | Dagestan Republic | 7840 | 374 | 5775 | 1691 | 43.05749160000001 | 47.1332224 | 2020-07-01 04:33:52 | Dagestan Republic, Russia | ||
302937 | 302937 | 2020-07-01 | Russia | Dagestan Republic | 7905 | 380 | 5824 | 1701 | 43.05749160000001 | 47.1332224 | 2020-07-02 04:33:46 | Dagestan Republic, Russia | ||
3045246 | 3045246 | 2020-07-02 | Russia | Dagestan Republic | 7968 | 383 | 5902 | 1683 | 43.05749160000001 | 47.1332224 | 2020-07-03 04:33:54 | Dagestan Republic, Russia | ||
2234452 | 2234452 | 2020-07-03 | Russia | Dagestan Republic | 8025 | 386 | 5997 | 1642 | 43.05749160000001 | 47.1332224 | 2020-07-04 04:33:51 | Dagestan Republic, Russia | ||
529791 | 529791 | 2020-07-04 | Russia | Dagestan Republic | 8080 | 389 | 6067 | 1624 | 43.05749160000001 | 47.1332224 | 2020-07-05 04:33:46 | Dagestan Republic, Russia | ||
415229 | 415229 | 2020-07-05 | Russia | Dagestan Republic | 8132 | 391 | 6124 | 1617 | 43.05749160000001 | 47.1332224 | 2020-07-06 04:33:57 | Dagestan Republic, Russia | ||
2684764 | 2684764 | 2020-07-06 | Russia | Dagestan Republic | 8184 | 393 | 6187 | 1604 | 43.05749160000001 | 47.1332224 | 2020-07-07 04:34:00 | Dagestan Republic, Russia | ||
887204 | 887204 | 2020-07-07 | Russia | Dagestan Republic | 8232 | 397 | 6273 | 1562 | 43.05749160000001 | 47.1332224 | 2020-07-08 05:33:48 | Dagestan Republic, Russia | ||
2222595 | 2222595 | 2020-07-08 | Russia | Dagestan Republic | 8280 | 400 | 6354 | 1526 | 43.05749160000001 | 47.1332224 | 2020-07-09 04:34:23 | Dagestan Republic, Russia | ||
1005379 | 1005379 | 2020-07-09 | Russia | Dagestan Republic | 8327 | 404 | 6468 | 1455 | 43.05749160000001 | 47.1332224 | 2020-07-10 04:34:24 | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);