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 = "Astrakhan 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462981 | 2462981 | 2021-09-14 | Russia | Astrakhan Oblast | 56257 | 1566 | 0 | 47.1878186 | 47.608851 | 2021-09-15 03:22:37 | Astrakhan Oblast, Russia | |||
1385820 | 1385820 | 2021-09-13 | Russia | Astrakhan Oblast | 55992 | 1558 | 0 | 47.1878186 | 47.608851 | 2021-09-14 04:21:41 | Astrakhan Oblast, Russia | |||
1885189 | 1885189 | 2021-09-12 | Russia | Astrakhan Oblast | 55722 | 1550 | 0 | 47.1878186 | 47.608851 | 2021-09-13 04:21:15 | Astrakhan Oblast, Russia | |||
3806092 | 3806092 | 2021-09-11 | Russia | Astrakhan Oblast | 55445 | 1541 | 0 | 47.1878186 | 47.608851 | 2021-09-12 04:21:13 | Astrakhan Oblast, Russia | |||
3449032 | 3449032 | 2021-09-10 | Russia | Astrakhan Oblast | 55166 | 1533 | 0 | 47.1878186 | 47.608851 | 2021-09-11 04:21:30 | Astrakhan Oblast, Russia | |||
1262978 | 1262978 | 2021-09-09 | Russia | Astrakhan Oblast | 54882 | 1524 | 0 | 47.1878186 | 47.608851 | 2021-09-10 04:21:20 | Astrakhan Oblast, Russia | |||
2279348 | 2279348 | 2021-09-08 | Russia | Astrakhan Oblast | 54595 | 1516 | 0 | 47.1878186 | 47.608851 | 2021-09-09 04:21:27 | Astrakhan Oblast, Russia | |||
642127 | 642127 | 2021-09-07 | Russia | Astrakhan Oblast | 54309 | 1507 | 0 | 47.1878186 | 47.608851 | 2021-09-08 04:21:31 | Astrakhan Oblast, Russia | |||
3194190 | 3194190 | 2021-09-06 | Russia | Astrakhan Oblast | 54019 | 1499 | 0 | 47.1878186 | 47.608851 | 2021-09-07 04:21:35 | Astrakhan Oblast, Russia | |||
3281058 | 3281058 | 2021-09-05 | Russia | Astrakhan Oblast | 53731 | 1490 | 0 | 47.1878186 | 47.608851 | 2021-09-06 04:21:22 | Astrakhan Oblast, Russia | |||
249472 | 249472 | 2021-09-04 | Russia | Astrakhan Oblast | 53446 | 1479 | 0 | 47.1878186 | 47.608851 | 2021-09-05 04:21:33 | Astrakhan Oblast, Russia | |||
3974753 | 3974753 | 2021-09-03 | Russia | Astrakhan Oblast | 53157 | 1469 | 0 | 47.1878186 | 47.608851 | 2021-09-04 04:21:28 | Astrakhan Oblast, Russia | |||
178215 | 178215 | 2021-09-02 | Russia | Astrakhan Oblast | 52870 | 1458 | 0 | 47.1878186 | 47.608851 | 2021-09-03 04:21:20 | Astrakhan Oblast, Russia | |||
67250 | 67250 | 2021-09-01 | Russia | Astrakhan Oblast | 52580 | 1446 | 0 | 47.1878186 | 47.608851 | 2021-09-02 04:21:15 | Astrakhan Oblast, Russia | |||
2068092 | 2068092 | 2021-08-31 | Russia | Astrakhan Oblast | 52291 | 1435 | 0 | 47.1878186 | 47.608851 | 2021-09-01 04:21:38 | Astrakhan Oblast, Russia | |||
1775546 | 1775546 | 2021-08-30 | Russia | Astrakhan Oblast | 52004 | 1423 | 0 | 47.1878186 | 47.608851 | 2021-08-31 04:21:46 | Astrakhan Oblast, Russia | |||
3892120 | 3892120 | 2021-08-29 | Russia | Astrakhan Oblast | 51718 | 1412 | 0 | 47.1878186 | 47.608851 | 2021-08-30 04:21:23 | Astrakhan Oblast, Russia | |||
2793223 | 2793223 | 2021-08-28 | Russia | Astrakhan Oblast | 51430 | 1400 | 0 | 47.1878186 | 47.608851 | 2021-08-29 04:21:14 | Astrakhan Oblast, Russia | |||
2923382 | 2923382 | 2021-08-27 | Russia | Astrakhan Oblast | 51139 | 1388 | 0 | 47.1878186 | 47.608851 | 2021-08-28 04:21:28 | Astrakhan Oblast, Russia | |||
1596396 | 1596396 | 2021-08-26 | Russia | Astrakhan Oblast | 50849 | 1377 | 0 | 47.1878186 | 47.608851 | 2021-08-27 04:21:37 | Astrakhan Oblast, Russia | |||
32605 | 32605 | 2021-08-25 | Russia | Astrakhan Oblast | 50561 | 1367 | 0 | 47.1878186 | 47.608851 | 2021-08-26 04:21:28 | Astrakhan Oblast, Russia | |||
3105644 | 3105644 | 2021-08-24 | Russia | Astrakhan Oblast | 50278 | 1357 | 0 | 47.1878186 | 47.608851 | 2021-08-25 04:21:41 | Astrakhan Oblast, Russia | |||
3165815 | 3165815 | 2021-08-23 | Russia | Astrakhan Oblast | 49992 | 1346 | 0 | 47.1878186 | 47.608851 | 2021-08-24 04:21:19 | Astrakhan Oblast, Russia | |||
2175742 | 2175742 | 2021-08-22 | Russia | Astrakhan Oblast | 49706 | 1336 | 0 | 47.1878186 | 47.608851 | 2021-08-23 04:21:27 | Astrakhan Oblast, Russia | |||
3555838 | 3555838 | 2021-08-21 | Russia | Astrakhan Oblast | 49417 | 1326 | 0 | 47.1878186 | 47.608851 | 2021-08-22 04:21:29 | Astrakhan Oblast, Russia | |||
1854180 | 1854180 | 2021-08-20 | Russia | Astrakhan Oblast | 49128 | 1315 | 0 | 47.1878186 | 47.608851 | 2021-08-21 04:21:38 | Astrakhan Oblast, Russia | |||
511887 | 511887 | 2021-08-19 | Russia | Astrakhan Oblast | 48838 | 1303 | 0 | 47.1878186 | 47.608851 | 2021-08-20 04:21:33 | Astrakhan Oblast, Russia | |||
2518366 | 2518366 | 2021-08-18 | Russia | Astrakhan Oblast | 48552 | 1292 | 0 | 47.1878186 | 47.608851 | 2021-08-19 04:21:15 | Astrakhan Oblast, Russia | |||
245458 | 245458 | 2021-08-17 | Russia | Astrakhan Oblast | 48260 | 1280 | 0 | 47.1878186 | 47.608851 | 2021-08-18 04:21:35 | Astrakhan Oblast, Russia | |||
1604421 | 1604421 | 2021-08-16 | Russia | Astrakhan Oblast | 47973 | 1269 | 0 | 47.1878186 | 47.608851 | 2021-08-17 04:21:49 | Astrakhan Oblast, Russia | |||
103515 | 103515 | 2021-08-15 | Russia | Astrakhan Oblast | 47685 | 1259 | 0 | 47.1878186 | 47.608851 | 2021-08-16 04:21:31 | Astrakhan Oblast, Russia | |||
507873 | 507873 | 2021-08-14 | Russia | Astrakhan Oblast | 47395 | 1249 | 0 | 47.1878186 | 47.608851 | 2021-08-15 04:21:41 | Astrakhan Oblast, Russia | |||
1483745 | 1483745 | 2021-08-13 | Russia | Astrakhan Oblast | 47103 | 1239 | 0 | 47.1878186 | 47.608851 | 2021-08-14 04:21:25 | Astrakhan Oblast, Russia | |||
2899875 | 2899875 | 2021-08-12 | Russia | Astrakhan Oblast | 46815 | 1229 | 0 | 47.1878186 | 47.608851 | 2021-08-13 04:21:24 | Astrakhan Oblast, Russia | |||
1342479 | 1342479 | 2021-08-11 | Russia | Astrakhan Oblast | 46530 | 1219 | 0 | 47.1878186 | 47.608851 | 2021-08-12 04:21:25 | Astrakhan Oblast, Russia | |||
2351626 | 2351626 | 2021-08-10 | Russia | Astrakhan Oblast | 46248 | 1209 | 0 | 47.1878186 | 47.608851 | 2021-08-11 04:21:58 | Astrakhan Oblast, Russia | |||
650155 | 650155 | 2021-08-09 | Russia | Astrakhan Oblast | 45961 | 1199 | 0 | 47.1878186 | 47.608851 | 2021-08-10 04:21:27 | Astrakhan Oblast, Russia | |||
589817 | 589817 | 2021-08-08 | Russia | Astrakhan Oblast | 45671 | 1189 | 0 | 47.1878186 | 47.608851 | 2021-08-09 04:21:24 | Astrakhan Oblast, Russia | |||
2203829 | 2203829 | 2021-08-07 | Russia | Astrakhan Oblast | 45386 | 1179 | 0 | 47.1878186 | 47.608851 | 2021-08-08 04:21:33 | Astrakhan Oblast, Russia | |||
1117779 | 1117779 | 2021-08-06 | Russia | Astrakhan Oblast | 45107 | 1169 | 0 | 47.1878186 | 47.608851 | 2021-08-07 04:21:30 | Astrakhan Oblast, Russia | |||
1956716 | 1956716 | 2021-08-05 | Russia | Astrakhan Oblast | 44826 | 1159 | 0 | 47.1878186 | 47.608851 | 2021-08-06 04:21:18 | Astrakhan Oblast, Russia | |||
332095 | 332095 | 2021-08-04 | Russia | Astrakhan Oblast | 44538 | 1149 | 36898 | 6491 | 47.1878186 | 47.608851 | 2021-08-05 04:21:51 | Astrakhan Oblast, Russia | ||
3468366 | 3468366 | 2021-08-03 | Russia | Astrakhan Oblast | 44249 | 1138 | 36806 | 6305 | 47.1878186 | 47.608851 | 2021-08-04 04:21:25 | Astrakhan Oblast, Russia | ||
3683640 | 3683640 | 2021-08-02 | Russia | Astrakhan Oblast | 43962 | 1127 | 36709 | 6126 | 47.1878186 | 47.608851 | 2021-08-03 04:21:39 | Astrakhan Oblast, Russia | ||
3015539 | 3015539 | 2021-08-01 | Russia | Astrakhan Oblast | 43676 | 1117 | 36619 | 5940 | 47.1878186 | 47.608851 | 2021-08-02 04:21:36 | Astrakhan Oblast, Russia | ||
3904162 | 3904162 | 2021-07-31 | Russia | Astrakhan Oblast | 43388 | 1107 | 36524 | 5757 | 47.1878186 | 47.608851 | 2021-08-01 04:21:50 | Astrakhan Oblast, Russia | ||
3296367 | 3296367 | 2021-07-30 | Russia | Astrakhan Oblast | 43097 | 1095 | 36437 | 5565 | 47.1878186 | 47.608851 | 2021-07-31 04:21:35 | Astrakhan Oblast, Russia | ||
3385578 | 3385578 | 2021-07-29 | Russia | Astrakhan Oblast | 42807 | 1084 | 36354 | 5369 | 47.1878186 | 47.608851 | 2021-07-30 04:21:34 | Astrakhan Oblast, Russia | ||
408483 | 408483 | 2021-07-28 | Russia | Astrakhan Oblast | 42518 | 1072 | 36263 | 5183 | 47.1878186 | 47.608851 | 2021-07-29 04:21:33 | Astrakhan Oblast, Russia | ||
1306344 | 1306344 | 2021-07-27 | Russia | Astrakhan Oblast | 42229 | 1059 | 36178 | 4992 | 47.1878186 | 47.608851 | 2021-07-28 04:21:39 | Astrakhan Oblast, Russia | ||
3218487 | 3218487 | 2021-07-26 | Russia | Astrakhan Oblast | 41936 | 1047 | 36107 | 4782 | 47.1878186 | 47.608851 | 2021-07-27 04:21:18 | Astrakhan Oblast, Russia | ||
1378696 | 1378696 | 2021-07-25 | Russia | Astrakhan Oblast | 41646 | 1036 | 36064 | 4546 | 47.1878186 | 47.608851 | 2021-07-26 04:21:28 | Astrakhan Oblast, Russia | ||
1330436 | 1330436 | 2021-07-24 | Russia | Astrakhan Oblast | 41355 | 1024 | 36017 | 4314 | 47.1878186 | 47.608851 | 2021-07-25 04:22:12 | Astrakhan Oblast, Russia | ||
3137740 | 3137740 | 2021-07-23 | Russia | Astrakhan Oblast | 41065 | 1011 | 35893 | 4161 | 47.1878186 | 47.608851 | 2021-07-24 00:21:36 | Astrakhan Oblast, Russia | ||
3476500 | 3476500 | 2021-07-22 | Russia | Astrakhan Oblast | 40785 | 999 | 35819 | 3967 | 47.1878186 | 47.608851 | 2021-07-23 04:21:29 | Astrakhan Oblast, Russia | ||
3331719 | 3331719 | 2021-07-21 | Russia | Astrakhan Oblast | 40502 | 988 | 35773 | 3741 | 47.1878186 | 47.608851 | 2021-07-22 04:21:19 | Astrakhan Oblast, Russia | ||
2371700 | 2371700 | 2021-07-20 | Russia | Astrakhan Oblast | 40233 | 977 | 35703 | 3553 | 47.1878186 | 47.608851 | 2021-07-21 04:21:40 | Astrakhan Oblast, Russia | ||
483779 | 483779 | 2021-07-19 | Russia | Astrakhan Oblast | 39967 | 965 | 35642 | 3360 | 47.1878186 | 47.608851 | 2021-07-20 04:21:48 | Astrakhan Oblast, Russia | ||
2674002 | 2674002 | 2021-07-18 | Russia | Astrakhan Oblast | 39710 | 955 | 35607 | 3148 | 47.1878186 | 47.608851 | 2021-07-19 04:21:24 | Astrakhan Oblast, Russia | ||
3706314 | 3706314 | 2021-07-17 | Russia | Astrakhan Oblast | 39457 | 944 | 35569 | 2944 | 47.1878186 | 47.608851 | 2021-07-18 04:22:07 | Astrakhan Oblast, Russia | ||
2947545 | 2947545 | 2021-07-16 | Russia | Astrakhan Oblast | 39201 | 934 | 35503 | 2764 | 47.1878186 | 47.608851 | 2021-07-17 04:22:22 | Astrakhan Oblast, Russia | ||
296201 | 296201 | 2021-07-15 | Russia | Astrakhan Oblast | 38960 | 926 | 35417 | 2617 | 47.1878186 | 47.608851 | 2021-07-16 04:21:22 | Astrakhan Oblast, Russia | ||
3632146 | 3632146 | 2021-07-14 | Russia | Astrakhan Oblast | 38732 | 921 | 35227 | 2584 | 47.1878186 | 47.608851 | 2021-07-15 04:21:48 | Astrakhan Oblast, Russia | ||
579021 | 579021 | 2021-07-13 | Russia | Astrakhan Oblast | 38514 | 916 | 35138 | 2460 | 47.1878186 | 47.608851 | 2021-07-14 04:21:35 | Astrakhan Oblast, Russia | ||
3741270 | 3741270 | 2021-07-12 | Russia | Astrakhan Oblast | 38304 | 911 | 35036 | 2357 | 47.1878186 | 47.608851 | 2021-07-13 04:21:18 | Astrakhan Oblast, Russia | ||
3659783 | 3659783 | 2021-07-11 | Russia | Astrakhan Oblast | 38104 | 906 | 34983 | 2215 | 47.1878186 | 47.608851 | 2021-07-12 04:21:34 | Astrakhan Oblast, Russia | ||
626067 | 626067 | 2021-07-10 | Russia | Astrakhan Oblast | 37889 | 901 | 34927 | 2061 | 47.1878186 | 47.608851 | 2021-07-11 04:21:43 | Astrakhan Oblast, Russia | ||
829786 | 829786 | 2021-07-09 | Russia | Astrakhan Oblast | 37681 | 896 | 34838 | 1947 | 47.1878186 | 47.608851 | 2021-07-10 04:21:25 | Astrakhan Oblast, Russia | ||
778550 | 778550 | 2021-07-08 | Russia | Astrakhan Oblast | 37480 | 892 | 34767 | 1821 | 47.1878186 | 47.608851 | 2021-07-09 04:21:21 | Astrakhan Oblast, Russia | ||
1440772 | 1440772 | 2021-07-07 | Russia | Astrakhan Oblast | 37287 | 888 | 34694 | 1705 | 47.1878186 | 47.608851 | 2021-07-08 04:21:26 | Astrakhan Oblast, Russia | ||
2693877 | 2693877 | 2021-07-06 | Russia | Astrakhan Oblast | 37117 | 884 | 34632 | 1601 | 47.1878186 | 47.608851 | 2021-07-07 04:21:20 | Astrakhan Oblast, Russia | ||
1932626 | 1932626 | 2021-07-05 | Russia | Astrakhan Oblast | 36956 | 881 | 34583 | 1492 | 47.1878186 | 47.608851 | 2021-07-06 04:21:32 | Astrakhan Oblast, Russia | ||
1165357 | 1165357 | 2021-07-04 | Russia | Astrakhan Oblast | 36796 | 878 | 34559 | 1359 | 47.1878186 | 47.608851 | 2021-07-05 04:21:28 | Astrakhan Oblast, Russia | ||
1495791 | 1495791 | 2021-07-03 | Russia | Astrakhan Oblast | 36637 | 874 | 34514 | 1249 | 47.1878186 | 47.608851 | 2021-07-04 04:21:38 | Astrakhan Oblast, Russia | ||
2072106 | 2072106 | 2021-07-02 | Russia | Astrakhan Oblast | 36479 | 870 | 34467 | 1142 | 47.1878186 | 47.608851 | 2021-07-03 04:21:37 | Astrakhan Oblast, Russia | ||
2765122 | 2765122 | 2021-07-01 | Russia | Astrakhan Oblast | 36323 | 866 | 34404 | 1053 | 47.1878186 | 47.608851 | 2021-07-02 04:21:47 | Astrakhan Oblast, Russia | ||
1893330 | 1893330 | 2021-06-30 | Russia | Astrakhan Oblast | 36145 | 861 | 34330 | 954 | 47.1878186 | 47.608851 | 2021-07-01 04:21:19 | Astrakhan Oblast, Russia | ||
400453 | 400453 | 2021-06-29 | Russia | Astrakhan Oblast | 35997 | 857 | 34270 | 870 | 47.1878186 | 47.608851 | 2021-06-30 04:21:41 | Astrakhan Oblast, Russia | ||
3125696 | 3125696 | 2021-06-28 | Russia | Astrakhan Oblast | 35846 | 853 | 34213 | 780 | 47.1878186 | 47.608851 | 2021-06-29 04:21:28 | Astrakhan Oblast, Russia | ||
2590191 | 2590191 | 2021-06-27 | Russia | Astrakhan Oblast | 35712 | 849 | 34151 | 712 | 47.1878186 | 47.608851 | 2021-06-28 04:21:29 | Astrakhan Oblast, Russia | ||
3958695 | 3958695 | 2021-06-26 | Russia | Astrakhan Oblast | 35588 | 844 | 34097 | 647 | 47.1878186 | 47.608851 | 2021-06-27 04:21:39 | Astrakhan Oblast, Russia | ||
1712514 | 1712514 | 2021-06-25 | Russia | Astrakhan Oblast | 35472 | 839 | 34053 | 580 | 47.1878186 | 47.608851 | 2021-06-26 04:21:43 | Astrakhan Oblast, Russia | ||
2295639 | 2295639 | 2021-06-24 | Russia | Astrakhan Oblast | 35367 | 834 | 34007 | 526 | 47.1878186 | 47.608851 | 2021-06-25 04:21:33 | Astrakhan Oblast, Russia | ||
2423079 | 2423079 | 2021-06-23 | Russia | Astrakhan Oblast | 35292 | 830 | 33971 | 491 | 47.1878186 | 47.608851 | 2021-06-24 04:21:55 | Astrakhan Oblast, Russia | ||
563156 | 563156 | 2021-06-22 | Russia | Astrakhan Oblast | 35222 | 825 | 33948 | 449 | 47.1878186 | 47.608851 | 2021-06-23 04:21:46 | Astrakhan Oblast, Russia | ||
3358858 | 3358858 | 2021-06-21 | Russia | Astrakhan Oblast | 35162 | 821 | 33912 | 429 | 47.1878186 | 47.608851 | 2021-06-22 04:21:34 | Astrakhan Oblast, Russia | ||
2884557 | 2884557 | 2021-06-20 | Russia | Astrakhan Oblast | 35106 | 819 | 33897 | 390 | 47.1878186 | 47.608851 | 2021-06-21 04:21:41 | Astrakhan Oblast, Russia | ||
107640 | 107640 | 2021-06-19 | Russia | Astrakhan Oblast | 35055 | 817 | 33876 | 362 | 47.1878186 | 47.608851 | 2021-06-20 04:21:48 | Astrakhan Oblast, Russia | ||
1125783 | 1125783 | 2021-06-18 | Russia | Astrakhan Oblast | 35006 | 815 | 33809 | 382 | 47.1878186 | 47.608851 | 2021-06-19 04:22:33 | Astrakhan Oblast, Russia | ||
2911361 | 2911361 | 2021-06-17 | Russia | Astrakhan Oblast | 34962 | 813 | 33773 | 376 | 47.1878186 | 47.608851 | 2021-06-18 04:22:16 | Astrakhan Oblast, Russia | ||
3030477 | 3030477 | 2021-06-16 | Russia | Astrakhan Oblast | 34921 | 811 | 33701 | 409 | 47.1878186 | 47.608851 | 2021-06-17 04:22:36 | Astrakhan Oblast, Russia | ||
2339583 | 2339583 | 2021-06-15 | Russia | Astrakhan Oblast | 34883 | 809 | 33604 | 470 | 47.1878186 | 47.608851 | 2021-06-16 04:22:32 | Astrakhan Oblast, Russia | ||
1564279 | 1564279 | 2021-06-14 | Russia | Astrakhan Oblast | 34843 | 807 | 33580 | 456 | 47.1878186 | 47.608851 | 2021-06-15 04:22:22 | Astrakhan Oblast, Russia | ||
3381562 | 3381562 | 2021-06-13 | Russia | Astrakhan Oblast | 34804 | 805 | 33505 | 494 | 47.1878186 | 47.608851 | 2021-06-14 04:22:46 | Astrakhan Oblast, Russia | ||
1736696 | 1736696 | 2021-06-12 | Russia | Astrakhan Oblast | 34764 | 803 | 33487 | 474 | 47.1878186 | 47.608851 | 2021-06-13 04:22:44 | Astrakhan Oblast, Russia | ||
3970737 | 3970737 | 2021-06-11 | Russia | Astrakhan Oblast | 34726 | 801 | 33440 | 485 | 47.1878186 | 47.608851 | 2021-06-12 04:22:22 | Astrakhan Oblast, Russia | ||
2717159 | 2717159 | 2021-06-10 | Russia | Astrakhan Oblast | 34671 | 799 | 33333 | 539 | 47.1878186 | 47.608851 | 2021-06-11 04:23:20 | Astrakhan Oblast, Russia | ||
523044 | 523044 | 2021-06-09 | Russia | Astrakhan Oblast | 34632 | 797 | 33228 | 607 | 47.1878186 | 47.608851 | 2021-06-10 04:23:17 | Astrakhan Oblast, Russia | ||
3472484 | 3472484 | 2021-06-08 | Russia | Astrakhan Oblast | 34593 | 795 | 33148 | 650 | 47.1878186 | 47.608851 | 2021-06-09 04:23:31 | Astrakhan Oblast, Russia | ||
3145768 | 3145768 | 2021-06-07 | Russia | Astrakhan Oblast | 34555 | 794 | 33053 | 708 | 47.1878186 | 47.608851 | 2021-06-08 04:22:35 | Astrakhan 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]);