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 = "Belgorod 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026537 | 1026537 | 2020-10-17 | Russia | Belgorod Oblast | 10176 | 59 | 8845 | 1272 | 50.7080119 | 37.5837615 | 2020-10-18 04:24:25 | Belgorod Oblast, Russia | ||
2857032 | 2857032 | 2020-10-16 | Russia | Belgorod Oblast | 10080 | 59 | 8735 | 1286 | 50.7080119 | 37.5837615 | 2020-10-17 04:24:12 | Belgorod Oblast, Russia | ||
786562 | 786562 | 2020-10-15 | Russia | Belgorod Oblast | 9989 | 58 | 8722 | 1209 | 50.7080119 | 37.5837615 | 2020-10-16 04:24:01 | Belgorod Oblast, Russia | ||
79273 | 79273 | 2020-10-14 | Russia | Belgorod Oblast | 9895 | 58 | 8688 | 1149 | 50.7080119 | 37.5837615 | 2020-10-15 04:24:28 | Belgorod Oblast, Russia | ||
3782088 | 3782088 | 2020-10-13 | Russia | Belgorod Oblast | 9803 | 58 | 8654 | 1091 | 50.7080119 | 37.5837615 | 2020-10-14 04:24:05 | Belgorod Oblast, Russia | ||
2291628 | 2291628 | 2020-10-12 | Russia | Belgorod Oblast | 9719 | 58 | 8619 | 1042 | 50.7080119 | 37.5837615 | 2020-10-13 04:24:02 | Belgorod Oblast, Russia | ||
3786081 | 3786081 | 2020-10-11 | Russia | Belgorod Oblast | 9642 | 58 | 8612 | 972 | 50.7080119 | 37.5837615 | 2020-10-12 04:23:45 | Belgorod Oblast, Russia | ||
2602219 | 2602219 | 2020-10-10 | Russia | Belgorod Oblast | 9564 | 58 | 8592 | 914 | 50.7080119 | 37.5837615 | 2020-10-11 04:23:46 | Belgorod Oblast, Russia | ||
817752 | 817752 | 2020-10-09 | Russia | Belgorod Oblast | 9488 | 58 | 8524 | 906 | 50.7080119 | 37.5837615 | 2020-10-10 04:23:57 | Belgorod Oblast, Russia | ||
2689867 | 2689867 | 2020-10-08 | Russia | Belgorod Oblast | 9410 | 58 | 8447 | 905 | 50.7080119 | 37.5837615 | 2020-10-09 04:23:59 | Belgorod Oblast, Russia | ||
1042009 | 1042009 | 2020-10-07 | Russia | Belgorod Oblast | 9336 | 58 | 8335 | 943 | 50.7080119 | 37.5837615 | 2020-10-08 04:23:56 | Belgorod Oblast, Russia | ||
3117670 | 3117670 | 2020-10-06 | Russia | Belgorod Oblast | 9267 | 58 | 8269 | 940 | 50.7080119 | 37.5837615 | 2020-10-07 04:23:40 | Belgorod Oblast, Russia | ||
3802082 | 3802082 | 2020-10-05 | Russia | Belgorod Oblast | 9200 | 58 | 8192 | 950 | 50.7080119 | 37.5837615 | 2020-10-06 04:23:33 | Belgorod Oblast, Russia | ||
1822972 | 1822972 | 2020-10-04 | Russia | Belgorod Oblast | 9135 | 58 | 8188 | 889 | 50.7080119 | 37.5837615 | 2020-10-05 04:23:33 | Belgorod Oblast, Russia | ||
2514356 | 2514356 | 2020-10-03 | Russia | Belgorod Oblast | 9067 | 58 | 8161 | 848 | 50.7080119 | 37.5837615 | 2020-10-04 04:23:44 | Belgorod Oblast, Russia | ||
3389574 | 3389574 | 2020-10-02 | Russia | Belgorod Oblast | 9000 | 58 | 8075 | 867 | 50.7080119 | 37.5837615 | 2020-10-03 04:23:40 | Belgorod Oblast, Russia | ||
2379815 | 2379815 | 2020-10-01 | Russia | Belgorod Oblast | 8933 | 58 | 8035 | 840 | 50.7080119 | 37.5837615 | 2020-10-02 04:23:51 | Belgorod Oblast, Russia | ||
1046001 | 1046001 | 2020-09-30 | Russia | Belgorod Oblast | 8864 | 58 | 7978 | 828 | 50.7080119 | 37.5837615 | 2020-10-01 04:23:42 | Belgorod Oblast, Russia | ||
967082 | 967082 | 2020-09-29 | Russia | Belgorod Oblast | 8798 | 58 | 7940 | 800 | 50.7080119 | 37.5837615 | 2020-09-30 04:23:33 | Belgorod Oblast, Russia | ||
1515579 | 1515579 | 2020-09-28 | Russia | Belgorod Oblast | 8735 | 58 | 7853 | 824 | 50.7080119 | 37.5837615 | 2020-09-29 04:23:42 | Belgorod Oblast, Russia | ||
2582167 | 2582167 | 2020-09-27 | Russia | Belgorod Oblast | 8674 | 58 | 7845 | 771 | 50.7080119 | 37.5837615 | 2020-09-28 04:23:00 | Belgorod Oblast, Russia | ||
2614219 | 2614219 | 2020-09-26 | Russia | Belgorod Oblast | 8607 | 58 | 7838 | 711 | 50.7080119 | 37.5837615 | 2020-09-27 04:23:00 | Belgorod Oblast, Russia | ||
2812934 | 2812934 | 2020-09-25 | Russia | Belgorod Oblast | 8546 | 57 | 7748 | 741 | 50.7080119 | 37.5837615 | 2020-09-26 04:23:00 | Belgorod Oblast, Russia | ||
2606211 | 2606211 | 2020-09-24 | Russia | Belgorod Oblast | 8483 | 57 | 7739 | 687 | 50.7080119 | 37.5837615 | 2020-09-25 04:23:00 | Belgorod Oblast, Russia | ||
2653954 | 2653954 | 2020-09-23 | Russia | Belgorod Oblast | 8422 | 57 | 7643 | 722 | 50.7080119 | 37.5837615 | 2020-09-24 04:23:00 | Belgorod Oblast, Russia | ||
3316403 | 3316403 | 2020-09-22 | Russia | Belgorod Oblast | 8365 | 57 | 7584 | 724 | 50.7080119 | 37.5837615 | 2020-09-23 04:23:00 | Belgorod Oblast, Russia | ||
2837002 | 2837002 | 2020-09-21 | Russia | Belgorod Oblast | 8311 | 57 | 7528 | 726 | 50.7080119 | 37.5837615 | 2020-09-22 04:23:00 | Belgorod Oblast, Russia | ||
3093606 | 3093606 | 2020-09-20 | Russia | Belgorod Oblast | 8260 | 57 | 7521 | 682 | 50.7080119 | 37.5837615 | 2020-09-21 04:23:00 | Belgorod Oblast, Russia | ||
2454956 | 2454956 | 2020-09-19 | Russia | Belgorod Oblast | 8208 | 57 | 7521 | 630 | 50.7080119 | 37.5837615 | 2020-09-20 04:22:00 | Belgorod Oblast, Russia | ||
2849025 | 2849025 | 2020-09-18 | Russia | Belgorod Oblast | 8152 | 57 | 7520 | 575 | 50.7080119 | 37.5837615 | 2020-09-19 04:22:00 | Belgorod Oblast, Russia | ||
1121774 | 1121774 | 2020-09-17 | Russia | Belgorod Oblast | 8103 | 57 | 7512 | 534 | 50.7080119 | 37.5837615 | 2020-09-18 05:05:00 | Belgorod Oblast, Russia | ||
666463 | 666463 | 2020-09-16 | Russia | Belgorod Oblast | 8056 | 57 | 7459 | 540 | 50.7080119 | 37.5837615 | 2020-09-17 04:22:00 | Belgorod Oblast, Russia | ||
2729188 | 2729188 | 2020-09-15 | Russia | Belgorod Oblast | 8008 | 55 | 7389 | 564 | 50.7080119 | 37.5837615 | 2020-09-16 04:22:53 | Belgorod Oblast, Russia | ||
344460 | 344460 | 2020-09-14 | Russia | Belgorod Oblast | 7962 | 55 | 7348 | 559 | 50.7080119 | 37.5837615 | 2020-09-15 03:22:50 | Belgorod Oblast, Russia | ||
2868899 | 2868899 | 2020-09-13 | Russia | Belgorod Oblast | 7919 | 55 | 7341 | 523 | 50.7080119 | 37.5837615 | 2020-09-14 04:26:00 | Belgorod Oblast, Russia | ||
546938 | 546938 | 2020-09-12 | Russia | Belgorod Oblast | 7874 | 55 | 7254 | 565 | 50.7080119 | 37.5837615 | 2020-09-13 04:30:52 | Belgorod Oblast, Russia | ||
1444767 | 1444767 | 2020-09-11 | Russia | Belgorod Oblast | 7832 | 55 | 7185 | 592 | 50.7080119 | 37.5837615 | 2020-09-12 04:25:05 | Belgorod Oblast, Russia | ||
1173368 | 1173368 | 2020-09-10 | Russia | Belgorod Oblast | 7786 | 55 | 7120 | 611 | 50.7080119 | 37.5837615 | 2020-09-11 04:46:23 | Belgorod Oblast, Russia | ||
2171733 | 2171733 | 2020-09-09 | Russia | Belgorod Oblast | 7742 | 55 | 7078 | 609 | 50.7080119 | 37.5837615 | 2020-09-10 04:29:01 | Belgorod Oblast, Russia | ||
1243942 | 1243942 | 2020-09-08 | Russia | Belgorod Oblast | 7699 | 54 | 7007 | 638 | 50.7080119 | 37.5837615 | 2020-09-09 04:28:48 | Belgorod Oblast, Russia | ||
427521 | 427521 | 2020-09-07 | Russia | Belgorod Oblast | 7654 | 54 | 6975 | 625 | 50.7080119 | 37.5837615 | 2020-09-08 04:28:25 | Belgorod Oblast, Russia | ||
3161806 | 3161806 | 2020-09-06 | Russia | Belgorod Oblast | 7610 | 54 | 6969 | 587 | 50.7080119 | 37.5837615 | 2020-09-07 04:28:30 | Belgorod Oblast, Russia | ||
813761 | 813761 | 2020-09-05 | Russia | Belgorod Oblast | 7569 | 54 | 6956 | 559 | 50.7080119 | 37.5837615 | 2020-09-06 04:28:33 | Belgorod Oblast, Russia | ||
2661961 | 2661961 | 2020-09-04 | Russia | Belgorod Oblast | 7531 | 54 | 6918 | 559 | 50.7080119 | 37.5837615 | 2020-09-05 04:28:19 | Belgorod Oblast, Russia | ||
1354501 | 1354501 | 2020-09-03 | Russia | Belgorod Oblast | 7491 | 54 | 6860 | 577 | 50.7080119 | 37.5837615 | 2020-09-04 04:28:26 | Belgorod Oblast, Russia | ||
1105738 | 1105738 | 2020-09-02 | Russia | Belgorod Oblast | 7449 | 53 | 6776 | 620 | 50.7080119 | 37.5837615 | 2020-09-03 04:28:22 | Belgorod Oblast, Russia | ||
2060067 | 2060067 | 2020-09-01 | Russia | Belgorod Oblast | 7405 | 53 | 6682 | 670 | 50.7080119 | 37.5837615 | 2020-09-02 04:28:25 | Belgorod Oblast, Russia | ||
194252 | 194252 | 2020-08-31 | Russia | Belgorod Oblast | 7365 | 53 | 6590 | 722 | 50.7080119 | 37.5837615 | 2020-09-01 04:28:31 | Belgorod Oblast, Russia | ||
3932211 | 3932211 | 2020-08-30 | Russia | Belgorod Oblast | 7320 | 53 | 6590 | 677 | 50.7080119 | 37.5837615 | 2020-08-31 04:28:27 | Belgorod Oblast, Russia | ||
609873 | 609873 | 2020-08-29 | Russia | Belgorod Oblast | 7279 | 53 | 6571 | 655 | 50.7080119 | 37.5837615 | 2020-08-30 04:28:22 | Belgorod Oblast, Russia | ||
1523368 | 1523368 | 2020-08-28 | Russia | Belgorod Oblast | 7239 | 51 | 6493 | 695 | 50.7080119 | 37.5837615 | 2020-08-29 04:28:19 | Belgorod Oblast, Russia | ||
2510369 | 2510369 | 2020-08-27 | Russia | Belgorod Oblast | 7195 | 51 | 6418 | 726 | 50.7080119 | 37.5837615 | 2020-08-28 04:28:11 | Belgorod Oblast, Russia | ||
1996829 | 1996829 | 2020-08-26 | Russia | Belgorod Oblast | 7157 | 51 | 6317 | 789 | 50.7080119 | 37.5837615 | 2020-08-27 04:28:15 | Belgorod Oblast, Russia | ||
3562753 | 3562753 | 2020-08-25 | Russia | Belgorod Oblast | 7117 | 51 | 6257 | 809 | 50.7080119 | 37.5837615 | 2020-08-26 04:28:11 | Belgorod Oblast, Russia | ||
2991457 | 2991457 | 2020-08-24 | Russia | Belgorod Oblast | 7074 | 51 | 6185 | 838 | 50.7080119 | 37.5837615 | 2020-08-25 04:28:02 | Belgorod Oblast, Russia | ||
2215852 | 2215852 | 2020-08-23 | Russia | Belgorod Oblast | 7033 | 51 | 6172 | 810 | 50.7080119 | 37.5837615 | 2020-08-24 04:27:56 | Belgorod Oblast, Russia | ||
2299634 | 2299634 | 2020-08-22 | Russia | Belgorod Oblast | 6990 | 51 | 6142 | 797 | 50.7080119 | 37.5837615 | 2020-08-23 04:27:48 | Belgorod Oblast, Russia | ||
1479741 | 1479741 | 2020-08-21 | Russia | Belgorod Oblast | 6944 | 51 | 6086 | 807 | 50.7080119 | 37.5837615 | 2020-08-22 04:27:49 | Belgorod Oblast, Russia | ||
3484490 | 3484490 | 2020-08-20 | Russia | Belgorod Oblast | 6901 | 51 | 6022 | 828 | 50.7080119 | 37.5837615 | 2020-08-21 04:27:41 | Belgorod Oblast, Russia | ||
206439 | 206439 | 2020-08-19 | Russia | Belgorod Oblast | 6854 | 51 | 5985 | 818 | 50.7080119 | 37.5837615 | 2020-08-20 04:27:43 | Belgorod Oblast, Russia | ||
3178193 | 3178193 | 2020-08-18 | Russia | Belgorod Oblast | 6807 | 51 | 5927 | 829 | 50.7080119 | 37.5837615 | 2020-08-19 04:27:00 | Belgorod Oblast, Russia | ||
837797 | 837797 | 2020-08-17 | Russia | Belgorod Oblast | 6762 | 51 | 5852 | 859 | 50.7080119 | 37.5837615 | 2020-08-18 04:27:56 | Belgorod Oblast, Russia | ||
1556155 | 1556155 | 2020-08-16 | Russia | Belgorod Oblast | 6714 | 51 | 5846 | 817 | 50.7080119 | 37.5837615 | 2020-08-17 04:27:20 | Belgorod Oblast, Russia | ||
146157 | 146157 | 2020-08-15 | Russia | Belgorod Oblast | 6665 | 51 | 5828 | 786 | 50.7080119 | 37.5837615 | 2020-08-16 04:27:42 | Belgorod Oblast, Russia | ||
1612432 | 1612432 | 2020-08-14 | Russia | Belgorod Oblast | 6613 | 51 | 5771 | 791 | 50.7080119 | 37.5837615 | 2020-08-15 04:27:31 | Belgorod Oblast, Russia | ||
583016 | 583016 | 2020-08-13 | Russia | Belgorod Oblast | 6562 | 51 | 5723 | 788 | 50.7080119 | 37.5837615 | 2020-08-14 04:51:19 | Belgorod Oblast, Russia | ||
3531635 | 3531635 | 2020-08-12 | Russia | Belgorod Oblast | 6509 | 51 | 5687 | 771 | 50.7080119 | 37.5837615 | 2020-08-13 04:29:15 | Belgorod Oblast, Russia | ||
662484 | 662484 | 2020-08-11 | Russia | Belgorod Oblast | 6461 | 51 | 5611 | 799 | 50.7080119 | 37.5837615 | 2020-08-12 04:27:29 | Belgorod Oblast, Russia | ||
1920211 | 1920211 | 2020-08-10 | Russia | Belgorod Oblast | 6410 | 51 | 5600 | 759 | 50.7080119 | 37.5837615 | 2020-08-11 04:35:08 | Belgorod Oblast, Russia | ||
3923020 | 3923020 | 2020-08-09 | Russia | Belgorod Oblast | 6360 | 51 | 5600 | 709 | 50.7080119 | 37.5837615 | 2020-08-10 04:34:55 | Belgorod Oblast, Russia | ||
371188 | 371188 | 2020-08-08 | Russia | Belgorod Oblast | 6314 | 51 | 5600 | 663 | 50.7080119 | 37.5837615 | 2020-08-09 04:34:54 | Belgorod Oblast, Russia | ||
458372 | 458372 | 2020-08-07 | Russia | Belgorod Oblast | 6269 | 50 | 5592 | 627 | 50.7080119 | 37.5837615 | 2020-08-08 04:34:53 | Belgorod Oblast, Russia | ||
3612057 | 3612057 | 2020-08-06 | Russia | Belgorod Oblast | 6220 | 49 | 5586 | 585 | 50.7080119 | 37.5837615 | 2020-08-07 04:35:11 | Belgorod Oblast, Russia | ||
3792887 | 3792887 | 2020-08-05 | Russia | Belgorod Oblast | 6169 | 49 | 5579 | 541 | 50.7080119 | 37.5837615 | 2020-08-06 04:35:02 | Belgorod Oblast, Russia | ||
98123 | 98123 | 2020-08-04 | Russia | Belgorod Oblast | 6123 | 47 | 5575 | 501 | 50.7080119 | 37.5837615 | 2020-08-05 04:34:43 | Belgorod Oblast, Russia | ||
2740006 | 2740006 | 2020-08-03 | Russia | Belgorod Oblast | 6083 | 47 | 5567 | 469 | 50.7080119 | 37.5837615 | 2020-08-04 04:41:59 | Belgorod Oblast, Russia | ||
2807758 | 2807758 | 2020-08-02 | Russia | Belgorod Oblast | 6042 | 47 | 5567 | 428 | 50.7080119 | 37.5837615 | 2020-08-03 04:34:35 | Belgorod Oblast, Russia | ||
753326 | 753326 | 2020-08-01 | Russia | Belgorod Oblast | 5998 | 47 | 5565 | 386 | 50.7080119 | 37.5837615 | 2020-08-02 04:34:47 | Belgorod Oblast, Russia | ||
3264491 | 3264491 | 2020-07-31 | Russia | Belgorod Oblast | 5952 | 47 | 5547 | 358 | 50.7080119 | 37.5837615 | 2020-08-01 04:36:27 | Belgorod Oblast, Russia | ||
1928198 | 1928198 | 2020-07-30 | Russia | Belgorod Oblast | 5910 | 47 | 5528 | 335 | 50.7080119 | 37.5837615 | 2020-07-31 04:35:18 | Belgorod Oblast, Russia | ||
2958366 | 2958366 | 2020-07-29 | Russia | Belgorod Oblast | 5871 | 46 | 5518 | 307 | 50.7080119 | 37.5837615 | 2020-07-30 04:35:05 | Belgorod Oblast, Russia | ||
3184982 | 3184982 | 2020-07-28 | Russia | Belgorod Oblast | 5829 | 46 | 5507 | 276 | 50.7080119 | 37.5837615 | 2020-07-29 04:35:11 | Belgorod Oblast, Russia | ||
177034 | 177034 | 2020-07-27 | Russia | Belgorod Oblast | 5784 | 46 | 5491 | 247 | 50.7080119 | 37.5837615 | 2020-07-28 04:58:43 | Belgorod Oblast, Russia | ||
442347 | 442347 | 2020-07-26 | Russia | Belgorod Oblast | 5745 | 46 | 5482 | 217 | 50.7080119 | 37.5837615 | 2020-07-27 04:35:02 | Belgorod Oblast, Russia | ||
1502591 | 1502591 | 2020-07-25 | Russia | Belgorod Oblast | 5703 | 46 | 5444 | 213 | 50.7080119 | 37.5837615 | 2020-07-26 04:35:00 | Belgorod Oblast, Russia | ||
2563561 | 2563561 | 2020-07-24 | Russia | Belgorod Oblast | 5656 | 46 | 5349 | 261 | 50.7080119 | 37.5837615 | 2020-07-25 04:47:39 | Belgorod Oblast, Russia | ||
61790 | 61790 | 2020-07-23 | Russia | Belgorod Oblast | 5617 | 46 | 5267 | 304 | 50.7080119 | 37.5837615 | 2020-07-24 05:30:40 | Belgorod Oblast, Russia | ||
844581 | 844581 | 2020-07-22 | Russia | Belgorod Oblast | 5571 | 45 | 5167 | 359 | 50.7080119 | 37.5837615 | 2020-07-23 05:15:04 | Belgorod Oblast, Russia | ||
1707320 | 1707320 | 2020-07-21 | Russia | Belgorod Oblast | 5527 | 43 | 5072 | 412 | 50.7080119 | 37.5837615 | 2020-07-22 04:34:42 | Belgorod Oblast, Russia | ||
326811 | 326811 | 2020-07-20 | Russia | Belgorod Oblast | 5486 | 43 | 5021 | 422 | 50.7080119 | 37.5837615 | 2020-07-21 04:38:46 | Belgorod Oblast, Russia | ||
121716 | 121716 | 2020-07-19 | Russia | Belgorod Oblast | 5441 | 43 | 5004 | 394 | 50.7080119 | 37.5837615 | 2020-07-20 05:34:40 | Belgorod Oblast, Russia | ||
3205105 | 3205105 | 2020-07-18 | Russia | Belgorod Oblast | 5398 | 43 | 4985 | 370 | 50.7080119 | 37.5837615 | 2020-07-19 04:34:58 | Belgorod Oblast, Russia | ||
2708407 | 2708407 | 2020-07-17 | Russia | Belgorod Oblast | 5360 | 43 | 4891 | 426 | 50.7080119 | 37.5837615 | 2020-07-18 04:34:45 | Belgorod Oblast, Russia | ||
367226 | 367226 | 2020-07-16 | Russia | Belgorod Oblast | 5319 | 42 | 4807 | 470 | 50.7080119 | 37.5837615 | 2020-07-17 04:34:50 | Belgorod Oblast, Russia | ||
2747894 | 2747894 | 2020-07-15 | Russia | Belgorod Oblast | 5271 | 42 | 4687 | 542 | 50.7080119 | 37.5837615 | 2020-07-16 04:44:59 | Belgorod Oblast, Russia | ||
2158538 | 2158538 | 2020-07-14 | Russia | Belgorod Oblast | 5227 | 42 | 4596 | 589 | 50.7080119 | 37.5837615 | 2020-07-15 04:34:39 | Belgorod Oblast, Russia | ||
3491179 | 3491179 | 2020-07-13 | Russia | Belgorod Oblast | 5176 | 42 | 4583 | 551 | 50.7080119 | 37.5837615 | 2020-07-14 04:34:46 | Belgorod Oblast, Russia | ||
3737441 | 3737441 | 2020-07-12 | Russia | Belgorod Oblast | 5128 | 42 | 4548 | 538 | 50.7080119 | 37.5837615 | 2020-07-13 04:43:04 | Belgorod Oblast, Russia | ||
3435836 | 3435836 | 2020-07-11 | Russia | Belgorod Oblast | 5085 | 42 | 4520 | 523 | 50.7080119 | 37.5837615 | 2020-07-12 04:34:30 | Belgorod Oblast, Russia | ||
3237334 | 3237334 | 2020-07-10 | Russia | Belgorod Oblast | 5038 | 42 | 4436 | 560 | 50.7080119 | 37.5837615 | 2020-07-11 04:34:26 | Belgorod 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]);