johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
994 rows where country_or_region = "Yemen" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, latitude, last_update, day (date), last_update (date)
recovered 299 ✖
- 0 532
- 1 19
- 1384 14
- 1378 11
- 1375 10
- 1382 10
- 1329 8
- 23 7
- 1379 6
- 1428 6
- 1432 6
- 1435 6
- 1366 5
- 1383 5
- 1419 5
- 1423 5
- 10 4
- 1221 4
- 1427 4
- 1430 4
- 4162 4
- 5 3
- 862 3
- 1211 3
- 1338 3
- 1360 3
- 1425 3
- 1426 3
- 3003 3
- 4166 3
- 6 2
- 11 2
- 14 2
- 17 2
- 695 2
- 863 2
- 1013 2
- 1058 2
- 1266 2
- 1320 2
- 1344 2
- 1396 2
- 1401 2
- 1405 2
- 1407 2
- 1416 2
- 1424 2
- 1431 2
- 1434 2
- 3472 2
- 4154 2
- 4168 2
- 4171 2
- 13 1
- 15 1
- 28 1
- 39 1
- 53 1
- 79 1
- 91 1
- 271 1
- 273 1
- 288 1
- 328 1
- 347 1
- 350 1
- 356 1
- 379 1
- 386 1
- 402 1
- 417 1
- 430 1
- 432 1
- 488 1
- 504 1
- 513 1
- 536 1
- 537 1
- 552 1
- 572 1
- 591 1
- 595 1
- 619 1
- 630 1
- 642 1
- 659 1
- 675 1
- 685 1
- 694 1
- 701 1
- 712 1
- 714 1
- 741 1
- 751 1
- 762 1
- 779 1
- 780 1
- 797 1
- 833 1
- 840 1
- 849 1
- 856 1
- 894 1
- 898 1
- 907 1
- 910 1
- 913 1
- 915 1
- 919 1
- 937 1
- 949 1
- 1009 1
- 1045 1
- 1052 1
- 1055 1
- 1066 1
- 1086 1
- 1090 1
- 1091 1
- 1097 1
- 1098 1
- 1107 1
- 1113 1
- 1123 1
- 1131 1
- 1160 1
- 1175 1
- 1180 1
- 1194 1
- 1197 1
- 1200 1
- 1201 1
- 1203 1
- 1209 1
- 1212 1
- 1215 1
- 1219 1
- 1227 1
- 1235 1
- 1240 1
- 1245 1
- 1250 1
- 1255 1
- 1260 1
- 1275 1
- 1286 1
- 1297 1
- 1307 1
- 1323 1
- 1327 1
- 1328 1
- 1335 1
- 1336 1
- 1354 1
- 1364 1
- 1386 1
- 1387 1
- 1392 1
- 1394 1
- 1399 1
- 1403 1
- 1421 1
- 1422 1
- 1433 1
- 1439 1
- 1442 1
- 1446 1
- 1447 1
- 1451 1
- 1452 1
- 1464 1
- 1469 1
- 1472 1
- 1491 1
- 1500 1
- 1507 1
- 1508 1
- 1520 1
- 1529 1
- 1530 1
- 1534 1
- 1546 1
- 1566 1
- 1577 1
- 1580 1
- 1588 1
- 1590 1
- 1606 1
- 1657 1
- 1667 1
- 1676 1
- 1682 1
- 1691 1
- 1715 1
- 1738 1
- 1772 1
- 1822 1
- 1886 1
- 1946 1
- 1987 1
- 2027 1
- 2053 1
- 2059 1
- 2070 1
- 2128 1
- 2178 1
- 2204 1
- 2209 1
- 2219 1
- 2261 1
- 2281 1
- 2309 1
- 2393 1
- 2454 1
- 2486 1
- 2546 1
- 2630 1
- 2674 1
- 2700 1
- 2731 1
- 2751 1
- 2794 1
- 2875 1
- 2910 1
- 2948 1
- 2966 1
- 2971 1
- 2978 1
- 2983 1
- 2992 1
- 3001 1
- 3008 1
- 3014 1
- 3023 1
- 3042 1
- 3072 1
- 3120 1
- 3159 1
- 3179 1
- 3201 1
- 3245 1
- 3260 1
- 3273 1
- 3306 1
- 3339 1
- 3375 1
- 3399 1
- 3427 1
- 3445 1
- 3484 1
- 3511 1
- 3550 1
- 3571 1
- 3588 1
- 3638 1
- 3675 1
- 3689 1
- 3697 1
- 3727 1
- 3743 1
- 3765 1
- 3775 1
- 3781 1
- 3840 1
- 3846 1
- 3855 1
- 3953 1
- 3958 1
- 3980 1
- 3990 1
- 3995 1
- 4005 1
- 4019 1
- 4025 1
- 4032 1
- 4055 1
- 4068 1
- 4081 1
- 4082 1
- 4087 1
- 4104 1
- 4108 1
- 4111 1
- 4117 1
- 4119 1
- 4128 1
- 4135 1
- 4141 1
- 4142 1
- 4147 1
- 4151 1
- 4156 1
- 4159 1
- 4163 1
- 4185 1
- 4200 1
- 4212 1
- 4232 1
- 4251 1
country_or_region 1
- Yemen · 994 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4004 | 4004 | 2021-12-02 | Yemen | 10006 | 1950 | 0 | 15.552726999999999 | 48.516388 | 2021-12-03 04:23:05 | Yemen | ||||
8019 | 8019 | 2021-10-28 | Yemen | 9751 | 1874 | 0 | 15.552726999999999 | 48.516388 | 2021-10-29 04:22:03 | Yemen | ||||
20026 | 20026 | 2021-09-18 | Yemen | 8630 | 1638 | 0 | 15.552726999999999 | 48.516388 | 2021-09-19 04:21:34 | Yemen | ||||
28078 | 28078 | 2022-03-20 | Yemen | 11801 | 2140 | 0 | 15.552726999999999 | 48.516388 | 2022-03-21 04:20:50 | Yemen | ||||
32090 | 32090 | 2021-11-11 | Yemen | 9907 | 1920 | 0 | 15.552726999999999 | 48.516388 | 2021-11-12 04:22:01 | Yemen | ||||
36086 | 36086 | 2021-08-25 | Yemen | 7625 | 1438 | 0 | 15.552726999999999 | 48.516388 | 2021-08-26 04:21:28 | Yemen | ||||
43339 | 43339 | 2020-04-13 | Yemen | 1 | 0 | 0 | 1 | 15.552726999999999 | 48.516388 | 2020-04-13 23:07:34 | Yemen | |||
47382 | 47382 | 2021-11-02 | Yemen | 9806 | 1894 | 0 | 15.552726999999999 | 48.516388 | 2021-11-03 06:22:09 | Yemen | ||||
50438 | 50438 | 2020-04-17 | Yemen | 1 | 0 | 0 | 1 | 15.552726999999999 | 48.516388 | 2020-04-17 23:30:32 | Yemen | |||
62394 | 62394 | 2020-07-23 | Yemen | 1654 | 461 | 762 | 431 | 15.552726999999999 | 48.516388 | 2020-07-24 05:30:40 | Yemen | |||
70731 | 70731 | 2021-09-01 | Yemen | 7900 | 1480 | 0 | 15.552726999999999 | 48.516388 | 2021-09-02 04:21:15 | Yemen | ||||
74765 | 74765 | 2022-02-07 | Yemen | 11266 | 2028 | 0 | 15.552726999999999 | 48.516388 | 2022-02-08 04:21:15 | Yemen | ||||
90799 | 90799 | 2021-11-09 | Yemen | 9891 | 1915 | 0 | 15.552726999999999 | 48.516388 | 2021-11-10 04:21:38 | Yemen | ||||
103000 | 103000 | 2022-01-14 | Yemen | 10233 | 1988 | 0 | 15.552726999999999 | 48.516388 | 2022-01-15 04:21:07 | Yemen | ||||
106996 | 106996 | 2021-08-15 | Yemen | 7293 | 1403 | 0 | 15.552726999999999 | 48.516388 | 2021-08-16 04:21:31 | Yemen | ||||
122349 | 122349 | 2020-07-19 | Yemen | 1606 | 445 | 712 | 449 | 15.552726999999999 | 48.516388 | 2020-07-20 05:34:40 | Yemen | |||
130407 | 130407 | 2022-01-09 | Yemen | 10197 | 1986 | 0 | 15.552726999999999 | 48.516388 | 2022-01-10 04:22:07 | Yemen | ||||
137602 | 137602 | 2020-04-29 | Yemen | 6 | 0 | 0 | 6 | 15.552726999999999 | 48.516388 | 2020-04-30 02:32:27 | Yemen | |||
141645 | 141645 | 2021-12-04 | Yemen | 10021 | 1953 | 0 | 15.552726999999999 | 48.516388 | 2021-12-05 04:22:25 | Yemen | ||||
153658 | 153658 | 2021-11-29 | Yemen | 9995 | 1949 | 0 | 15.552726999999999 | 48.516388 | 2021-11-30 04:22:53 | Yemen | ||||
161690 | 161690 | 2022-03-29 | Yemen | 11803 | 2143 | 0 | 15.552726999999999 | 48.516388 | 2022-03-30 04:20:45 | Yemen | ||||
165702 | 165702 | 2021-11-19 | Yemen | 9954 | 1935 | 0 | 15.552726999999999 | 48.516388 | 2021-11-20 04:22:17 | Yemen | ||||
181696 | 181696 | 2021-09-02 | Yemen | 7951 | 1486 | 0 | 15.552726999999999 | 48.516388 | 2021-09-03 04:21:20 | Yemen | ||||
189746 | 189746 | 2022-02-13 | Yemen | 11671 | 2103 | 0 | 15.552726999999999 | 48.516388 | 2022-02-14 04:20:51 | Yemen | ||||
228857 | 228857 | 2020-04-30 | Yemen | 6 | 2 | 1 | 3 | 15.552726999999999 | 48.516388 | 2020-05-01 02:32:28 | Yemen | |||
236918 | 236918 | 2022-02-11 | Yemen | 11659 | 2100 | 0 | 15.552726999999999 | 48.516388 | 2022-02-12 04:21:06 | Yemen | ||||
248939 | 248939 | 2021-08-17 | Yemen | 7347 | 1407 | 0 | 15.552726999999999 | 48.516388 | 2021-08-18 04:21:35 | Yemen | ||||
252953 | 252953 | 2021-09-04 | Yemen | 8056 | 1519 | 0 | 15.552726999999999 | 48.516388 | 2021-09-05 04:21:33 | Yemen | ||||
265210 | 265210 | 2022-03-15 | Yemen | 11793 | 2139 | 0 | 15.552726999999999 | 48.516388 | 2022-03-16 04:20:50 | Yemen | ||||
271816 | 271816 | 2020-04-28 | Yemen | 1 | 0 | 0 | 1 | 15.552726999999999 | 48.516388 | 2020-04-29 02:32:29 | Yemen | |||
279857 | 279857 | 2021-11-03 | Yemen | 9810 | 1897 | 0 | 15.552726999999999 | 48.516388 | 2021-11-04 04:22:20 | Yemen | ||||
287629 | 287629 | 2020-06-15 | Yemen | 844 | 208 | 79 | 557 | 15.552726999999999 | 48.516388 | 2020-06-16 04:33:09 | Yemen | |||
291669 | 291669 | 2021-10-31 | Yemen | 9791 | 1889 | 0 | 15.552726999999999 | 48.516388 | 2021-11-01 04:22:01 | Yemen | ||||
303501 | 303501 | 2020-07-01 | Yemen | 1190 | 318 | 504 | 368 | 15.552726999999999 | 48.516388 | 2020-07-02 04:33:46 | Yemen | |||
307546 | 307546 | 2022-04-16 | Yemen | 11817 | 2148 | 0 | 15.552726999999999 | 48.516388 | 2022-04-17 04:20:59 | Yemen | ||||
319592 | 319592 | 2022-02-12 | Yemen | 11664 | 2102 | 0 | 15.552726999999999 | 48.516388 | 2022-02-13 04:21:00 | Yemen | ||||
327444 | 327444 | 2020-07-20 | Yemen | 1619 | 447 | 714 | 458 | 15.552726999999999 | 48.516388 | 2020-07-21 04:38:46 | Yemen | |||
339614 | 339614 | 2022-03-18 | Yemen | 11797 | 2140 | 0 | 15.552726999999999 | 48.516388 | 2022-03-19 04:20:47 | Yemen | ||||
360004 | 360004 | 2022-03-11 | Yemen | 11783 | 2139 | 0 | 15.552726999999999 | 48.516388 | 2022-03-12 04:20:50 | Yemen | ||||
407968 | 407968 | 2021-12-07 | Yemen | 10043 | 1955 | 0 | 15.552726999999999 | 48.516388 | 2021-12-08 04:22:46 | Yemen | ||||
415792 | 415792 | 2020-07-05 | Yemen | 1265 | 338 | 552 | 375 | 15.552726999999999 | 48.516388 | 2020-07-06 04:33:57 | Yemen | |||
427024 | 427024 | 2021-10-10 | Yemen | 9369 | 1778 | 0 | 15.552726999999999 | 48.516388 | 2021-10-11 04:21:31 | Yemen | ||||
447028 | 447028 | 2021-10-20 | Yemen | 9596 | 1821 | 0 | 15.552726999999999 | 48.516388 | 2021-10-21 04:21:18 | Yemen | ||||
451045 | 451045 | 2021-11-17 | Yemen | 9947 | 1929 | 0 | 15.552726999999999 | 48.516388 | 2021-11-18 04:21:33 | Yemen | ||||
463054 | 463054 | 2022-02-02 | Yemen | 11113 | 2018 | 0 | 15.552726999999999 | 48.516388 | 2022-02-03 04:21:21 | Yemen | ||||
471085 | 471085 | 2021-10-07 | Yemen | 9299 | 1765 | 0 | 15.552726999999999 | 48.516388 | 2021-10-08 04:21:25 | Yemen | ||||
495309 | 495309 | 2021-10-14 | Yemen | 9467 | 1793 | 0 | 15.552726999999999 | 48.516388 | 2021-10-15 04:21:26 | Yemen | ||||
499326 | 499326 | 2021-11-06 | Yemen | 9858 | 1907 | 0 | 15.552726999999999 | 48.516388 | 2021-11-07 04:21:53 | Yemen | ||||
503346 | 503346 | 2022-04-02 | Yemen | 11806 | 2143 | 0 | 15.552726999999999 | 48.516388 | 2022-04-03 04:20:48 | Yemen | ||||
511354 | 511354 | 2021-08-14 | Yemen | 7273 | 1401 | 0 | 15.552726999999999 | 48.516388 | 2021-08-15 04:21:41 | Yemen | ||||
515368 | 515368 | 2021-08-19 | Yemen | 7407 | 1414 | 0 | 15.552726999999999 | 48.516388 | 2021-08-20 04:21:33 | Yemen | ||||
522504 | 522504 | 2020-04-21 | Yemen | 1 | 0 | 0 | 1 | 15.552726999999999 | 48.516388 | 2020-04-21 23:30:30 | Yemen | |||
530354 | 530354 | 2020-07-04 | Yemen | 1248 | 337 | 537 | 374 | 15.552726999999999 | 48.516388 | 2020-07-05 04:33:46 | Yemen | |||
538409 | 538409 | 2021-10-27 | Yemen | 9728 | 1868 | 0 | 15.552726999999999 | 48.516388 | 2021-10-28 04:22:08 | Yemen | ||||
554448 | 554448 | 2021-12-08 | Yemen | 10047 | 1956 | 0 | 15.552726999999999 | 48.516388 | 2021-12-09 04:22:49 | Yemen | ||||
558464 | 558464 | 2022-01-16 | Yemen | 10252 | 1990 | 0 | 15.552726999999999 | 48.516388 | 2022-01-17 04:21:08 | Yemen | ||||
570777 | 570777 | 2021-10-29 | Yemen | 9773 | 1877 | 0 | 15.552726999999999 | 48.516388 | 2021-10-30 04:22:03 | Yemen | ||||
578510 | 578510 | 2022-02-25 | Yemen | 11759 | 2131 | 0 | 15.552726999999999 | 48.516388 | 2022-02-26 04:21:12 | Yemen | ||||
601347 | 601347 | 2021-10-19 | Yemen | 9575 | 1813 | 0 | 15.552726999999999 | 48.516388 | 2021-10-20 04:21:00 | Yemen | ||||
605362 | 605362 | 2021-09-23 | Yemen | 8830 | 1664 | 0 | 15.552726999999999 | 48.516388 | 2021-09-24 04:21:44 | Yemen | ||||
637597 | 637597 | 2021-10-13 | Yemen | 9439 | 1789 | 0 | 15.552726999999999 | 48.516388 | 2021-10-14 04:21:29 | Yemen | ||||
645608 | 645608 | 2021-09-07 | Yemen | 8181 | 1534 | 0 | 15.552726999999999 | 48.516388 | 2021-09-08 04:21:31 | Yemen | ||||
653636 | 653636 | 2021-08-09 | Yemen | 7187 | 1389 | 0 | 15.552726999999999 | 48.516388 | 2021-08-10 04:21:27 | Yemen | ||||
657669 | 657669 | 2021-10-22 | Yemen | 9650 | 1835 | 0 | 15.552726999999999 | 48.516388 | 2021-10-23 04:21:32 | Yemen | ||||
686014 | 686014 | 2021-10-24 | Yemen | 9678 | 1840 | 0 | 15.552726999999999 | 48.516388 | 2021-10-25 04:22:31 | Yemen | ||||
690031 | 690031 | 2021-11-13 | Yemen | 9918 | 1923 | 0 | 15.552726999999999 | 48.516388 | 2021-11-14 04:21:31 | Yemen | ||||
698067 | 698067 | 2022-03-17 | Yemen | 11797 | 2140 | 0 | 15.552726999999999 | 48.516388 | 2022-03-18 04:20:55 | Yemen | ||||
702079 | 702079 | 2021-11-04 | Yemen | 9831 | 1901 | 0 | 15.552726999999999 | 48.516388 | 2021-11-05 04:21:54 | Yemen | ||||
710107 | 710107 | 2021-09-29 | Yemen | 9039 | 1715 | 0 | 15.552726999999999 | 48.516388 | 2021-09-30 04:21:20 | Yemen | ||||
718140 | 718140 | 2021-11-12 | Yemen | 9912 | 1921 | 0 | 15.552726999999999 | 48.516388 | 2021-11-13 04:21:38 | Yemen | ||||
726172 | 726172 | 2021-11-20 | Yemen | 9955 | 1938 | 0 | 15.552726999999999 | 48.516388 | 2021-11-21 04:22:13 | Yemen | ||||
734202 | 734202 | 2021-12-27 | Yemen | 10118 | 1984 | 0 | 15.552726999999999 | 48.516388 | 2021-12-28 04:21:47 | Yemen | ||||
737952 | 737952 | 2020-06-12 | Yemen | 632 | 139 | 28 | 465 | 15.552726999999999 | 48.516388 | 2020-06-13 03:33:14 | Yemen | |||
750022 | 750022 | 2022-04-23 | Yemen | 11818 | 2148 | 0 | 15.552726999999999 | 48.516388 | 2022-04-24 04:20:56 | Yemen | ||||
762002 | 762002 | 2021-11-26 | Yemen | 9979 | 1943 | 0 | 15.552726999999999 | 48.516388 | 2021-11-27 04:22:45 | Yemen | ||||
774022 | 774022 | 2021-10-23 | Yemen | 9662 | 1838 | 0 | 15.552726999999999 | 48.516388 | 2021-10-24 04:21:22 | Yemen | ||||
786065 | 786065 | 2021-12-13 | Yemen | 10072 | 1972 | 0 | 15.552726999999999 | 48.516388 | 2021-12-14 04:22:38 | Yemen | ||||
802104 | 802104 | 2021-12-22 | Yemen | 10103 | 1981 | 0 | 15.552726999999999 | 48.516388 | 2021-12-23 04:21:21 | Yemen | ||||
805753 | 805753 | 2020-06-01 | Yemen | 354 | 84 | 14 | 256 | 15.552726999999999 | 48.516388 | 2020-06-02 02:33:08 | Yemen | |||
813247 | 813247 | 2021-09-20 | Yemen | 8718 | 1649 | 0 | 15.552726999999999 | 48.516388 | 2021-09-21 04:21:26 | Yemen | ||||
860326 | 860326 | 2020-04-15 | Yemen | 1 | 0 | 0 | 1 | 15.552726999999999 | 48.516388 | 2020-04-15 22:56:32 | Yemen | |||
879942 | 879942 | 2022-03-27 | Yemen | 11803 | 2142 | 0 | 15.552726999999999 | 48.516388 | 2022-03-28 04:20:33 | Yemen | ||||
887767 | 887767 | 2020-07-07 | Yemen | 1297 | 348 | 591 | 358 | 15.552726999999999 | 48.516388 | 2020-07-08 05:33:48 | Yemen | |||
907853 | 907853 | 2021-11-24 | Yemen | 9972 | 1942 | 0 | 15.552726999999999 | 48.516388 | 2021-11-25 04:22:33 | Yemen | ||||
923362 | 923362 | 2022-03-08 | Yemen | 11781 | 2138 | 0 | 15.552726999999999 | 48.516388 | 2022-03-09 04:20:59 | Yemen | ||||
934432 | 934432 | 2020-04-16 | Yemen | 1 | 0 | 0 | 1 | 15.552726999999999 | 48.516388 | 2020-04-16 23:30:31 | Yemen | |||
938474 | 938474 | 2021-10-16 | Yemen | 9512 | 1802 | 0 | 15.552726999999999 | 48.516388 | 2021-10-17 04:21:29 | Yemen | ||||
946511 | 946511 | 2022-02-28 | Yemen | 11771 | 2135 | 0 | 15.552726999999999 | 48.516388 | 2022-03-01 04:21:09 | Yemen | ||||
954543 | 954543 | 2022-03-12 | Yemen | 11784 | 2139 | 0 | 15.552726999999999 | 48.516388 | 2022-03-13 04:20:49 | Yemen | ||||
982623 | 982623 | 2022-02-01 | Yemen | 11061 | 2013 | 0 | 15.552726999999999 | 48.516388 | 2022-02-02 04:21:09 | Yemen | ||||
990651 | 990651 | 2021-10-04 | Yemen | 9214 | 1743 | 0 | 15.552726999999999 | 48.516388 | 2021-10-05 04:21:27 | Yemen | ||||
1005943 | 1005943 | 2020-07-09 | Yemen | 1356 | 361 | 619 | 376 | 15.552726999999999 | 48.516388 | 2020-07-10 04:34:24 | Yemen | |||
1018008 | 1018008 | 2021-11-21 | Yemen | 9955 | 1938 | 0 | 15.552726999999999 | 48.516388 | 2021-11-22 04:22:20 | Yemen | ||||
1034050 | 1034050 | 2021-12-06 | Yemen | 10034 | 1955 | 0 | 15.552726999999999 | 48.516388 | 2021-12-07 04:22:34 | Yemen | ||||
1061527 | 1061527 | 2022-02-23 | Yemen | 11751 | 2130 | 0 | 15.552726999999999 | 48.516388 | 2022-02-24 04:21:14 | Yemen | ||||
1081599 | 1081599 | 2021-12-09 | Yemen | 10047 | 1957 | 0 | 15.552726999999999 | 48.516388 | 2021-12-10 04:22:28 | Yemen | ||||
1117264 | 1117264 | 2022-01-11 | Yemen | 10208 | 1987 | 0 | 15.552726999999999 | 48.516388 | 2022-01-12 04:21:44 | Yemen | ||||
1136535 | 1136535 | 2020-06-26 | Yemen | 1089 | 293 | 402 | 394 | 15.552726999999999 | 48.516388 | 2020-06-27 04:33:35 | Yemen | |||
1144587 | 1144587 | 2022-01-23 | Yemen | 10585 | 1995 | 0 | 15.552726999999999 | 48.516388 | 2022-01-24 04:21:12 | Yemen | ||||
1148603 | 1148603 | 2021-12-01 | Yemen | 10006 | 1950 | 0 | 15.552726999999999 | 48.516388 | 2021-12-02 04:22:37 | Yemen |
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]);