johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
942 rows where province_or_state = "Penza Oblast" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, longitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
332143 | 332143 | 2021-08-04 | Russia | Penza Oblast | 57135 | 1689 | 46493 | 8953 | 53.1655415 | 44.78791810000001 | 2021-08-05 04:21:51 | Penza Oblast, Russia | ||
3468414 | 3468414 | 2021-08-03 | Russia | Penza Oblast | 56904 | 1667 | 46456 | 8781 | 53.1655415 | 44.78791810000001 | 2021-08-04 04:21:25 | Penza Oblast, Russia | ||
3683688 | 3683688 | 2021-08-02 | Russia | Penza Oblast | 56668 | 1644 | 46416 | 8608 | 53.1655415 | 44.78791810000001 | 2021-08-03 04:21:39 | Penza Oblast, Russia | ||
3015587 | 3015587 | 2021-08-01 | Russia | Penza Oblast | 56438 | 1623 | 46377 | 8438 | 53.1655415 | 44.78791810000001 | 2021-08-02 04:21:36 | Penza Oblast, Russia | ||
3904210 | 3904210 | 2021-07-31 | Russia | Penza Oblast | 56206 | 1602 | 46335 | 8269 | 53.1655415 | 44.78791810000001 | 2021-08-01 04:21:50 | Penza Oblast, Russia | ||
3296415 | 3296415 | 2021-07-30 | Russia | Penza Oblast | 55972 | 1580 | 46290 | 8102 | 53.1655415 | 44.78791810000001 | 2021-07-31 04:21:35 | Penza Oblast, Russia | ||
3385626 | 3385626 | 2021-07-29 | Russia | Penza Oblast | 55741 | 1557 | 46254 | 7930 | 53.1655415 | 44.78791810000001 | 2021-07-30 04:21:34 | Penza Oblast, Russia | ||
408531 | 408531 | 2021-07-28 | Russia | Penza Oblast | 55506 | 1535 | 46221 | 7750 | 53.1655415 | 44.78791810000001 | 2021-07-29 04:21:33 | Penza Oblast, Russia | ||
1306392 | 1306392 | 2021-07-27 | Russia | Penza Oblast | 55272 | 1512 | 46186 | 7574 | 53.1655415 | 44.78791810000001 | 2021-07-28 04:21:39 | Penza Oblast, Russia | ||
3218535 | 3218535 | 2021-07-26 | Russia | Penza Oblast | 55040 | 1495 | 46148 | 7397 | 53.1655415 | 44.78791810000001 | 2021-07-27 04:21:18 | Penza Oblast, Russia | ||
1378744 | 1378744 | 2021-07-25 | Russia | Penza Oblast | 54811 | 1476 | 46116 | 7219 | 53.1655415 | 44.78791810000001 | 2021-07-26 04:21:28 | Penza Oblast, Russia | ||
1330484 | 1330484 | 2021-07-24 | Russia | Penza Oblast | 54581 | 1457 | 46079 | 7045 | 53.1655415 | 44.78791810000001 | 2021-07-25 04:22:12 | Penza Oblast, Russia | ||
3137788 | 3137788 | 2021-07-23 | Russia | Penza Oblast | 54346 | 1441 | 46046 | 6859 | 53.1655415 | 44.78791810000001 | 2021-07-24 00:21:36 | Penza Oblast, Russia | ||
3476548 | 3476548 | 2021-07-22 | Russia | Penza Oblast | 54115 | 1423 | 46010 | 6682 | 53.1655415 | 44.78791810000001 | 2021-07-23 04:21:29 | Penza Oblast, Russia | ||
3331767 | 3331767 | 2021-07-21 | Russia | Penza Oblast | 53881 | 1404 | 45976 | 6501 | 53.1655415 | 44.78791810000001 | 2021-07-22 04:21:19 | Penza Oblast, Russia | ||
2371748 | 2371748 | 2021-07-20 | Russia | Penza Oblast | 53642 | 1386 | 45945 | 6311 | 53.1655415 | 44.78791810000001 | 2021-07-21 04:21:40 | Penza Oblast, Russia | ||
483827 | 483827 | 2021-07-19 | Russia | Penza Oblast | 53405 | 1368 | 45918 | 6119 | 53.1655415 | 44.78791810000001 | 2021-07-20 04:21:48 | Penza Oblast, Russia | ||
2674050 | 2674050 | 2021-07-18 | Russia | Penza Oblast | 53175 | 1350 | 45893 | 5932 | 53.1655415 | 44.78791810000001 | 2021-07-19 04:21:24 | Penza Oblast, Russia | ||
3706362 | 3706362 | 2021-07-17 | Russia | Penza Oblast | 52946 | 1335 | 45864 | 5747 | 53.1655415 | 44.78791810000001 | 2021-07-18 04:22:07 | Penza Oblast, Russia | ||
2947593 | 2947593 | 2021-07-16 | Russia | Penza Oblast | 52715 | 1317 | 45833 | 5565 | 53.1655415 | 44.78791810000001 | 2021-07-17 04:22:22 | Penza Oblast, Russia | ||
296249 | 296249 | 2021-07-15 | Russia | Penza Oblast | 52488 | 1300 | 45805 | 5383 | 53.1655415 | 44.78791810000001 | 2021-07-16 04:21:22 | Penza Oblast, Russia | ||
3632194 | 3632194 | 2021-07-14 | Russia | Penza Oblast | 52264 | 1283 | 45783 | 5198 | 53.1655415 | 44.78791810000001 | 2021-07-15 04:21:48 | Penza Oblast, Russia | ||
579069 | 579069 | 2021-07-13 | Russia | Penza Oblast | 52042 | 1269 | 45763 | 5010 | 53.1655415 | 44.78791810000001 | 2021-07-14 04:21:35 | Penza Oblast, Russia | ||
3741318 | 3741318 | 2021-07-12 | Russia | Penza Oblast | 51825 | 1254 | 45746 | 4825 | 53.1655415 | 44.78791810000001 | 2021-07-13 04:21:18 | Penza Oblast, Russia | ||
3659831 | 3659831 | 2021-07-11 | Russia | Penza Oblast | 51615 | 1227 | 45732 | 4656 | 53.1655415 | 44.78791810000001 | 2021-07-12 04:21:34 | Penza Oblast, Russia | ||
626115 | 626115 | 2021-07-10 | Russia | Penza Oblast | 51410 | 1206 | 45721 | 4483 | 53.1655415 | 44.78791810000001 | 2021-07-11 04:21:43 | Penza Oblast, Russia | ||
829834 | 829834 | 2021-07-09 | Russia | Penza Oblast | 51220 | 1192 | 45706 | 4322 | 53.1655415 | 44.78791810000001 | 2021-07-10 04:21:25 | Penza Oblast, Russia | ||
778598 | 778598 | 2021-07-08 | Russia | Penza Oblast | 51039 | 1177 | 45685 | 4177 | 53.1655415 | 44.78791810000001 | 2021-07-09 04:21:21 | Penza Oblast, Russia | ||
1440820 | 1440820 | 2021-07-07 | Russia | Penza Oblast | 50864 | 1165 | 45660 | 4039 | 53.1655415 | 44.78791810000001 | 2021-07-08 04:21:26 | Penza Oblast, Russia | ||
2693925 | 2693925 | 2021-07-06 | Russia | Penza Oblast | 50695 | 1148 | 45638 | 3909 | 53.1655415 | 44.78791810000001 | 2021-07-07 04:21:20 | Penza Oblast, Russia | ||
1932674 | 1932674 | 2021-07-05 | Russia | Penza Oblast | 50530 | 1126 | 45608 | 3796 | 53.1655415 | 44.78791810000001 | 2021-07-06 04:21:32 | Penza Oblast, Russia | ||
1165405 | 1165405 | 2021-07-04 | Russia | Penza Oblast | 50369 | 1107 | 45587 | 3675 | 53.1655415 | 44.78791810000001 | 2021-07-05 04:21:28 | Penza Oblast, Russia | ||
1495839 | 1495839 | 2021-07-03 | Russia | Penza Oblast | 50217 | 1093 | 45570 | 3554 | 53.1655415 | 44.78791810000001 | 2021-07-04 04:21:38 | Penza Oblast, Russia | ||
2072154 | 2072154 | 2021-07-02 | Russia | Penza Oblast | 50067 | 1080 | 45549 | 3438 | 53.1655415 | 44.78791810000001 | 2021-07-03 04:21:37 | Penza Oblast, Russia | ||
2765170 | 2765170 | 2021-07-01 | Russia | Penza Oblast | 49920 | 1063 | 45527 | 3330 | 53.1655415 | 44.78791810000001 | 2021-07-02 04:21:47 | Penza Oblast, Russia | ||
1893378 | 1893378 | 2021-06-30 | Russia | Penza Oblast | 49784 | 1045 | 45504 | 3235 | 53.1655415 | 44.78791810000001 | 2021-07-01 04:21:19 | Penza Oblast, Russia | ||
400501 | 400501 | 2021-06-29 | Russia | Penza Oblast | 49654 | 1032 | 45477 | 3145 | 53.1655415 | 44.78791810000001 | 2021-06-30 04:21:41 | Penza Oblast, Russia | ||
3125744 | 3125744 | 2021-06-28 | Russia | Penza Oblast | 49533 | 1017 | 45457 | 3059 | 53.1655415 | 44.78791810000001 | 2021-06-29 04:21:28 | Penza Oblast, Russia | ||
2590239 | 2590239 | 2021-06-27 | Russia | Penza Oblast | 49417 | 1002 | 45439 | 2976 | 53.1655415 | 44.78791810000001 | 2021-06-28 04:21:29 | Penza Oblast, Russia | ||
3958743 | 3958743 | 2021-06-26 | Russia | Penza Oblast | 49305 | 991 | 45425 | 2889 | 53.1655415 | 44.78791810000001 | 2021-06-27 04:21:39 | Penza Oblast, Russia | ||
1712562 | 1712562 | 2021-06-25 | Russia | Penza Oblast | 49201 | 977 | 45409 | 2815 | 53.1655415 | 44.78791810000001 | 2021-06-26 04:21:43 | Penza Oblast, Russia | ||
2295687 | 2295687 | 2021-06-24 | Russia | Penza Oblast | 49102 | 961 | 45391 | 2750 | 53.1655415 | 44.78791810000001 | 2021-06-25 04:21:33 | Penza Oblast, Russia | ||
2423127 | 2423127 | 2021-06-23 | Russia | Penza Oblast | 49013 | 947 | 45374 | 2692 | 53.1655415 | 44.78791810000001 | 2021-06-24 04:21:55 | Penza Oblast, Russia | ||
563204 | 563204 | 2021-06-22 | Russia | Penza Oblast | 48928 | 937 | 45355 | 2636 | 53.1655415 | 44.78791810000001 | 2021-06-23 04:21:46 | Penza Oblast, Russia | ||
3358906 | 3358906 | 2021-06-21 | Russia | Penza Oblast | 48845 | 926 | 45340 | 2579 | 53.1655415 | 44.78791810000001 | 2021-06-22 04:21:34 | Penza Oblast, Russia | ||
2884605 | 2884605 | 2021-06-20 | Russia | Penza Oblast | 48764 | 918 | 45327 | 2519 | 53.1655415 | 44.78791810000001 | 2021-06-21 04:21:41 | Penza Oblast, Russia | ||
107688 | 107688 | 2021-06-19 | Russia | Penza Oblast | 48683 | 912 | 45310 | 2461 | 53.1655415 | 44.78791810000001 | 2021-06-20 04:21:48 | Penza Oblast, Russia | ||
1125831 | 1125831 | 2021-06-18 | Russia | Penza Oblast | 48601 | 906 | 45296 | 2399 | 53.1655415 | 44.78791810000001 | 2021-06-19 04:22:33 | Penza Oblast, Russia | ||
2911409 | 2911409 | 2021-06-17 | Russia | Penza Oblast | 48523 | 901 | 45275 | 2347 | 53.1655415 | 44.78791810000001 | 2021-06-18 04:22:16 | Penza Oblast, Russia | ||
3030525 | 3030525 | 2021-06-16 | Russia | Penza Oblast | 48447 | 896 | 45250 | 2301 | 53.1655415 | 44.78791810000001 | 2021-06-17 04:22:36 | Penza Oblast, Russia | ||
2339631 | 2339631 | 2021-06-15 | Russia | Penza Oblast | 48372 | 891 | 45230 | 2251 | 53.1655415 | 44.78791810000001 | 2021-06-16 04:22:32 | Penza Oblast, Russia | ||
1564327 | 1564327 | 2021-06-14 | Russia | Penza Oblast | 48295 | 885 | 45208 | 2202 | 53.1655415 | 44.78791810000001 | 2021-06-15 04:22:22 | Penza Oblast, Russia | ||
3381610 | 3381610 | 2021-06-13 | Russia | Penza Oblast | 48223 | 880 | 45186 | 2157 | 53.1655415 | 44.78791810000001 | 2021-06-14 04:22:46 | Penza Oblast, Russia | ||
1736744 | 1736744 | 2021-06-12 | Russia | Penza Oblast | 48150 | 874 | 45161 | 2115 | 53.1655415 | 44.78791810000001 | 2021-06-13 04:22:44 | Penza Oblast, Russia | ||
3970785 | 3970785 | 2021-06-11 | Russia | Penza Oblast | 48075 | 868 | 45130 | 2077 | 53.1655415 | 44.78791810000001 | 2021-06-12 04:22:22 | Penza Oblast, Russia | ||
2717207 | 2717207 | 2021-06-10 | Russia | Penza Oblast | 48001 | 863 | 45060 | 2078 | 53.1655415 | 44.78791810000001 | 2021-06-11 04:23:20 | Penza Oblast, Russia | ||
523092 | 523092 | 2021-06-09 | Russia | Penza Oblast | 47927 | 858 | 44992 | 2077 | 53.1655415 | 44.78791810000001 | 2021-06-10 04:23:17 | Penza Oblast, Russia | ||
3472532 | 3472532 | 2021-06-08 | Russia | Penza Oblast | 47852 | 852 | 44941 | 2059 | 53.1655415 | 44.78791810000001 | 2021-06-09 04:23:31 | Penza Oblast, Russia | ||
3145816 | 3145816 | 2021-06-07 | Russia | Penza Oblast | 47779 | 847 | 44887 | 2045 | 53.1655415 | 44.78791810000001 | 2021-06-08 04:22:35 | Penza Oblast, Russia | ||
825818 | 825818 | 2021-06-06 | Russia | Penza Oblast | 47709 | 842 | 44827 | 2040 | 53.1655415 | 44.78791810000001 | 2021-06-07 04:22:51 | Penza Oblast, Russia | ||
2586223 | 2586223 | 2021-06-05 | Russia | Penza Oblast | 47637 | 836 | 44758 | 2043 | 53.1655415 | 44.78791810000001 | 2021-06-06 04:24:03 | Penza Oblast, Russia | ||
2315537 | 2315537 | 2021-06-04 | Russia | Penza Oblast | 47562 | 831 | 44714 | 2017 | 53.1655415 | 44.78791810000001 | 2021-06-05 04:23:03 | Penza Oblast, Russia | ||
1448822 | 1448822 | 2021-06-03 | Russia | Penza Oblast | 47489 | 825 | 44664 | 2000 | 53.1655415 | 44.78791810000001 | 2021-06-04 04:23:37 | Penza Oblast, Russia | ||
1708546 | 1708546 | 2021-06-02 | Russia | Penza Oblast | 47417 | 819 | 44617 | 1981 | 53.1655415 | 44.78791810000001 | 2021-06-03 04:23:32 | Penza Oblast, Russia | ||
2104364 | 2104364 | 2021-06-01 | Russia | Penza Oblast | 47342 | 813 | 44579 | 1950 | 53.1655415 | 44.78791810000001 | 2021-06-02 04:24:34 | Penza Oblast, Russia | ||
1188980 | 1188980 | 2021-05-31 | Russia | Penza Oblast | 47269 | 808 | 44534 | 1927 | 53.1655415 | 44.78791810000001 | 2021-06-01 04:23:09 | Penza Oblast, Russia | ||
3089657 | 3089657 | 2021-05-30 | Russia | Penza Oblast | 47199 | 803 | 44491 | 1905 | 53.1655415 | 44.78791810000001 | 2021-05-31 03:08:59 | Penza Oblast, Russia | ||
51026 | 51026 | 2021-05-29 | Russia | Penza Oblast | 47128 | 798 | 44444 | 1886 | 53.1655415 | 44.78791810000001 | 2021-05-30 04:20:55 | Penza Oblast, Russia | ||
20605 | 20605 | 2021-05-28 | Russia | Penza Oblast | 47054 | 792 | 44388 | 1874 | 53.1655415 | 44.78791810000001 | 2021-05-29 04:20:41 | Penza Oblast, Russia | ||
1806980 | 1806980 | 2021-05-27 | Russia | Penza Oblast | 46982 | 786 | 44317 | 1879 | 53.1655415 | 44.78791810000001 | 2021-05-28 04:20:36 | Penza Oblast, Russia | ||
1310403 | 1310403 | 2021-05-26 | Russia | Penza Oblast | 46909 | 781 | 44247 | 1881 | 53.1655415 | 44.78791810000001 | 2021-05-27 04:20:59 | Penza Oblast, Russia | ||
83329 | 83329 | 2021-05-25 | Russia | Penza Oblast | 46835 | 776 | 44180 | 1879 | 53.1655415 | 44.78791810000001 | 2021-05-26 04:20:35 | Penza Oblast, Russia | ||
1413291 | 1413291 | 2021-05-24 | Russia | Penza Oblast | 46760 | 770 | 44109 | 1881 | 53.1655415 | 44.78791810000001 | 2021-05-25 04:21:08 | Penza Oblast, Russia | ||
1771577 | 1771577 | 2021-05-23 | Russia | Penza Oblast | 46688 | 764 | 44034 | 1890 | 53.1655415 | 44.78791810000001 | 2021-05-24 04:20:53 | Penza Oblast, Russia | ||
726732 | 726732 | 2021-05-22 | Russia | Penza Oblast | 46617 | 759 | 43973 | 1885 | 53.1655415 | 44.78791810000001 | 2021-05-23 04:20:51 | Penza Oblast, Russia | ||
1952747 | 1952747 | 2021-05-21 | Russia | Penza Oblast | 46544 | 754 | 43903 | 1887 | 53.1655415 | 44.78791810000001 | 2021-05-22 04:20:45 | Penza Oblast, Russia | ||
1913446 | 1913446 | 2021-05-20 | Russia | Penza Oblast | 46468 | 748 | 43831 | 1889 | 53.1655415 | 44.78791810000001 | 2021-05-21 04:20:43 | Penza Oblast, Russia | ||
2255967 | 2255967 | 2021-05-19 | Russia | Penza Oblast | 46394 | 743 | 43754 | 1897 | 53.1655415 | 44.78791810000001 | 2021-05-20 04:21:05 | Penza Oblast, Russia | ||
2391005 | 2391005 | 2021-05-18 | Russia | Penza Oblast | 46320 | 737 | 43688 | 1895 | 53.1655415 | 44.78791810000001 | 2021-05-19 04:20:42 | Penza Oblast, Russia | ||
3574830 | 3574830 | 2021-05-17 | Russia | Penza Oblast | 46248 | 732 | 43616 | 1900 | 53.1655415 | 44.78791810000001 | 2021-05-18 04:20:33 | Penza Oblast, Russia | ||
2939560 | 2939560 | 2021-05-16 | Russia | Penza Oblast | 46173 | 726 | 43549 | 1898 | 53.1655415 | 44.78791810000001 | 2021-05-17 04:20:34 | Penza Oblast, Russia | ||
1873190 | 1873190 | 2021-05-15 | Russia | Penza Oblast | 46099 | 720 | 43477 | 1902 | 53.1655415 | 44.78791810000001 | 2021-05-16 04:20:49 | Penza Oblast, Russia | ||
1082159 | 1082159 | 2021-05-14 | Russia | Penza Oblast | 46026 | 715 | 43408 | 1903 | 53.1655415 | 44.78791810000001 | 2021-05-15 04:20:58 | Penza Oblast, Russia | ||
3054425 | 3054425 | 2021-05-13 | Russia | Penza Oblast | 45950 | 710 | 43331 | 1909 | 53.1655415 | 44.78791810000001 | 2021-05-14 04:20:41 | Penza Oblast, Russia | ||
2004895 | 2004895 | 2021-05-12 | Russia | Penza Oblast | 45875 | 706 | 43261 | 1908 | 53.1655415 | 44.78791810000001 | 2021-05-13 04:20:51 | Penza Oblast, Russia | ||
3954726 | 3954726 | 2021-05-11 | Russia | Penza Oblast | 45800 | 701 | 43176 | 1923 | 53.1655415 | 44.78791810000001 | 2021-05-12 04:21:29 | Penza Oblast, Russia | ||
2821005 | 2821005 | 2021-05-10 | Russia | Penza Oblast | 45724 | 695 | 43089 | 1940 | 53.1655415 | 44.78791810000001 | 2021-05-11 04:20:41 | Penza Oblast, Russia | ||
1425337 | 1425337 | 2021-05-09 | Russia | Penza Oblast | 45647 | 690 | 43003 | 1954 | 53.1655415 | 44.78791810000001 | 2021-05-10 04:20:38 | Penza Oblast, Russia | ||
1552205 | 1552205 | 2021-05-08 | Russia | Penza Oblast | 45566 | 686 | 42911 | 1969 | 53.1655415 | 44.78791810000001 | 2021-05-09 04:20:35 | Penza Oblast, Russia | ||
2502263 | 2502263 | 2021-05-07 | Russia | Penza Oblast | 45488 | 682 | 42824 | 1982 | 53.1655415 | 44.78791810000001 | 2021-05-08 04:21:04 | Penza Oblast, Russia | ||
3113719 | 3113719 | 2021-05-06 | Russia | Penza Oblast | 45410 | 676 | 42732 | 2002 | 53.1655415 | 44.78791810000001 | 2021-05-07 04:20:40 | Penza Oblast, Russia | ||
646186 | 646186 | 2021-05-05 | Russia | Penza Oblast | 45330 | 671 | 42648 | 2011 | 53.1655415 | 44.78791810000001 | 2021-05-06 04:20:38 | Penza Oblast, Russia | ||
3675886 | 3675886 | 2021-05-04 | Russia | Penza Oblast | 45248 | 665 | 42555 | 2028 | 53.1655415 | 44.78791810000001 | 2021-05-05 04:20:43 | Penza Oblast, Russia | ||
2761153 | 2761153 | 2021-05-03 | Russia | Penza Oblast | 45162 | 660 | 42466 | 2036 | 53.1655415 | 44.78791810000001 | 2021-05-04 04:20:34 | Penza Oblast, Russia | ||
2451006 | 2451006 | 2021-05-02 | Russia | Penza Oblast | 45078 | 655 | 42391 | 2032 | 53.1655415 | 44.78791810000001 | 2021-05-03 04:20:39 | Penza Oblast, Russia | ||
2825019 | 2825019 | 2021-05-01 | Russia | Penza Oblast | 44993 | 649 | 42309 | 2035 | 53.1655415 | 44.78791810000001 | 2021-05-02 04:20:48 | Penza Oblast, Russia | ||
380427 | 380427 | 2021-04-30 | Russia | Penza Oblast | 44906 | 644 | 42233 | 2029 | 53.1655415 | 44.78791810000001 | 2021-05-01 04:20:47 | Penza Oblast, Russia | ||
1636550 | 1636550 | 2021-04-29 | Russia | Penza Oblast | 44819 | 638 | 42143 | 2038 | 53.1655415 | 44.78791810000001 | 2021-04-30 04:21:03 | Penza Oblast, Russia | ||
3393629 | 3393629 | 2021-04-28 | Russia | Penza Oblast | 44730 | 633 | 42055 | 2042 | 53.1655415 | 44.78791810000001 | 2021-04-29 04:20:55 | Penza Oblast, Russia | ||
3702345 | 3702345 | 2021-04-27 | Russia | Penza Oblast | 44644 | 628 | 41964 | 2052 | 53.1655415 | 44.78791810000001 | 2021-04-28 04:20:32 | Penza 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]);