johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
244 rows where active = 1041 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 190
- Russia 15
- Chile 8
- Colombia 4
- India 4
- Japan 3
- Sweden 3
- United Kingdom 3
- Brazil 2
- Italy 2
- Angola 1
- Cote d'Ivoire 1
- Guinea-Bissau 1
- Guyana 1
- Malaysia 1
- Mexico 1
- Pakistan 1
- Peru 1
- Sierra Leone 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378437 | 1378437 | 2021-07-25 | Guyana | 22150 | 527 | 20582 | 1041 | 4.860416000000002 | -58.93018000000001 | 2021-07-26 04:21:28 | Guyana | |||
483552 | 483552 | 2021-07-19 | India | Puducherry | 119745 | 1778 | 116926 | 1041 | 11.882658 | 78.86498 | 2021-07-20 04:21:48 | Puducherry, India | ||
2947147 | 2947147 | 2021-07-16 | Chile | Maule | 98413 | 1607 | 95765 | 1041 | -35.5183 | -71.6885 | 2021-07-17 04:22:22 | Maule, Chile | ||
3663246 | 3663246 | 2021-07-11 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 1041 | 49.3723 | -2.3644 | 2021-07-12 04:21:34 | Channel Islands, United Kingdom | ||
629530 | 629530 | 2021-07-10 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 1041 | 49.3723 | -2.3644 | 2021-07-11 04:21:43 | Channel Islands, United Kingdom | ||
833249 | 833249 | 2021-07-09 | United Kingdom | Channel Islands | 0 | 0 | 4078 | 1041 | 49.3723 | -2.3644 | 2021-07-10 04:21:25 | Channel Islands, United Kingdom | ||
2071861 | 2071861 | 2021-07-02 | India | Delhi | 1434374 | 24983 | 1408350 | 1041 | 28.646519 | 77.10898 | 2021-07-03 04:21:37 | Delhi, India | ||
2590214 | 2590214 | 2021-06-27 | Russia | Khakassia Republic | 24642 | 581 | 23020 | 1041 | 53.72258845 | 91.44293627 | 2021-06-28 04:21:29 | Khakassia Republic, Russia | ||
3033932 | 3033932 | 2021-06-16 | Ukraine | Zaporizhia Oblast | 104150 | 2410 | 100699 | 1041 | 47.8388 | 35.1396 | 2021-06-17 04:22:36 | Zaporizhia Oblast, Ukraine | ||
2717248 | 2717248 | 2021-06-10 | Sierra Leone | 4289 | 82 | 3166 | 1041 | 8.460555000000001 | -11.779889 | 2021-06-11 04:23:20 | Sierra Leone | |||
2716765 | 2716765 | 2021-06-10 | Chile | Nuble | 31802 | 530 | 30231 | 1041 | -36.7226 | -71.7622 | 2021-06-11 04:23:20 | Nuble, Chile | ||
1806490 | 1806490 | 2021-05-27 | Brazil | Piaui | 269732 | 5863 | 262203 | 1041 | -7.7183 | -42.7289 | 2021-05-28 04:20:36 | Piaui, Brazil | ||
2760949 | 2760949 | 2021-05-03 | Japan | Okayama | 4245 | 47 | 3157 | 1041 | 34.89246 | 133.826252 | 2021-05-04 04:20:34 | Okayama, Japan | ||
887981 | 887981 | 2021-04-26 | Colombia | Tolima | 68914 | 2203 | 65670 | 1041 | 4.0925 | -75.1545 | 2021-04-27 04:20:52 | Tolima, Colombia | ||
3924264 | 3924264 | 2021-04-24 | Russia | Tver Oblast | 39500 | 857 | 37602 | 1041 | 57.1134475 | 35.174442799999994 | 2021-04-25 04:20:32 | Tver Oblast, Russia | ||
1408838 | 1408838 | 2021-04-23 | Chile | Tarapaca | 32702 | 595 | 31066 | 1041 | -19.9232 | -69.5132 | 2021-04-24 04:20:38 | Tarapaca, Chile | ||
2020510 | 2020510 | 2021-04-20 | Chile | Coquimbo | 30397 | 586 | 28770 | 1041 | -29.959 | -71.3389 | 2021-04-21 04:21:14 | Coquimbo, Chile | ||
1841948 | 1841948 | 2021-04-14 | Japan | Chiba | 30992 | 596 | 29355 | 1041 | 35.510141 | 140.198917 | 2021-04-15 04:20:54 | Chiba, Japan | ||
1289801 | 1289801 | 2021-03-29 | Chile | Tarapaca | 28421 | 508 | 26872 | 1041 | -19.9232 | -69.5132 | 2021-03-30 04:26:23 | Tarapaca, Chile | ||
1980800 | 1980800 | 2021-03-25 | Russia | Amur Oblast | 21761 | 229 | 20491 | 1041 | 52.8032368 | 128.437295 | 2021-03-26 05:26:55 | Amur Oblast, Russia | ||
352500 | 352500 | 2021-03-11 | Russia | Kamchatka Krai | 13791 | 149 | 12601 | 1041 | 57.1914882 | 160.03838190000005 | 2021-03-12 05:26:50 | Kamchatka Krai, Russia | ||
3669606 | 3669606 | 2021-03-06 | US | Montana | Dawson | 30021 | 1069 | 28 | 0 | 1041 | 47.26584855 | -104.89444170000002 | 2021-03-07 05:21:54 | Dawson, Montana, US |
3667459 | 3667459 | 2021-03-06 | Colombia | Boyaca | 46586 | 1101 | 44444 | 1041 | 5.4545 | -73.362 | 2021-03-07 05:21:54 | Boyaca, Colombia | ||
1618854 | 1618854 | 2021-03-05 | US | Oregon | Hood River | 41027 | 1070 | 29 | 0 | 1041 | 45.51872811 | -121.65520359999998 | 2021-03-06 04:23:41 | Hood River, Oregon, US |
1618227 | 1618227 | 2021-03-05 | US | Montana | Dawson | 30021 | 1069 | 28 | 0 | 1041 | 47.26584855 | -104.89444170000002 | 2021-03-06 04:23:41 | Dawson, Montana, US |
1616080 | 1616080 | 2021-03-05 | Colombia | Boyaca | 46586 | 1101 | 44444 | 1041 | 5.4545 | -73.362 | 2021-03-06 04:23:41 | Boyaca, Colombia | ||
2210571 | 2210571 | 2021-03-04 | US | Tennessee | Clay | 47027 | 1085 | 30 | 0 | 1041 | 36.55151008 | -85.53930419 | 2021-03-05 05:26:29 | Clay, Tennessee, US |
2210265 | 2210265 | 2021-03-04 | US | Oregon | Hood River | 41027 | 1070 | 29 | 0 | 1041 | 45.51872811 | -121.65520359999998 | 2021-03-05 05:26:29 | Hood River, Oregon, US |
2209638 | 2209638 | 2021-03-04 | US | Montana | Dawson | 30021 | 1069 | 28 | 0 | 1041 | 47.26584855 | -104.89444170000002 | 2021-03-05 05:26:29 | Dawson, Montana, US |
2209519 | 2209519 | 2021-03-04 | US | Missouri | Bollinger | 29017 | 1053 | 12 | 0 | 1041 | 37.32449052 | -90.02725304 | 2021-03-05 05:26:29 | Bollinger, Missouri, US |
1092992 | 1092992 | 2021-03-03 | US | Tennessee | Clay | 47027 | 1085 | 30 | 0 | 1041 | 36.55151008 | -85.53930419 | 2021-03-04 05:24:24 | Clay, Tennessee, US |
1092059 | 1092059 | 2021-03-03 | US | Montana | Dawson | 30021 | 1069 | 28 | 0 | 1041 | 47.26584855 | -104.89444170000002 | 2021-03-04 05:24:24 | Dawson, Montana, US |
1091940 | 1091940 | 2021-03-03 | US | Missouri | Bollinger | 29017 | 1053 | 12 | 0 | 1041 | 37.32449052 | -90.02725304 | 2021-03-04 05:24:24 | Bollinger, Missouri, US |
3257064 | 3257064 | 2021-03-02 | US | Tennessee | Clay | 47027 | 1085 | 30 | 0 | 1041 | 36.55151008 | -85.53930419 | 2021-03-03 05:23:28 | Clay, Tennessee, US |
3256131 | 3256131 | 2021-03-02 | US | Montana | Dawson | 30021 | 1069 | 28 | 0 | 1041 | 47.26584855 | -104.89444170000002 | 2021-03-03 05:23:28 | Dawson, Montana, US |
3256012 | 3256012 | 2021-03-02 | US | Missouri | Bollinger | 29017 | 1053 | 12 | 0 | 1041 | 37.32449052 | -90.02725304 | 2021-03-03 05:23:28 | Bollinger, Missouri, US |
1002121 | 1002121 | 2021-03-01 | Malaysia | Sabah | 52991 | 375 | 51575 | 1041 | 5.9788 | 116.0753 | 2021-03-02 05:23:30 | Sabah, Malaysia | ||
1000304 | 1000304 | 2021-03-01 | US | Missouri | Bollinger | 29017 | 1053 | 12 | 0 | 1041 | 37.32449052 | -90.02725304 | 2021-03-02 05:23:30 | Bollinger, Missouri, US |
999258 | 999258 | 2021-03-01 | US | Georgia | Johnson | 13167 | 1088 | 47 | 0 | 1041 | 32.70211082 | -82.66166794 | 2021-03-02 05:23:30 | Johnson, Georgia, US |
2369362 | 2369362 | 2021-02-28 | US | Missouri | Bollinger | 29017 | 1053 | 12 | 0 | 1041 | 37.32449052 | -90.02725304 | 2021-03-01 05:23:01 | Bollinger, Missouri, US |
3069589 | 3069589 | 2021-02-27 | US | Wyoming | Big Horn | 56003 | 1071 | 30 | 0 | 1041 | 44.52405055 | -107.9960365 | 2021-02-28 05:22:20 | Big Horn, Wyoming, US |
3069470 | 3069470 | 2021-02-27 | US | West Virginia | Grant | 54023 | 1067 | 26 | 0 | 1041 | 39.10314817 | -79.19440518 | 2021-02-28 05:22:20 | Grant, West Virginia, US |
2187173 | 2187173 | 2021-02-26 | US | Wyoming | Big Horn | 56003 | 1071 | 30 | 0 | 1041 | 44.52405055 | -107.9960365 | 2021-02-27 05:22:28 | Big Horn, Wyoming, US |
2185448 | 2185448 | 2021-02-26 | US | Missouri | Bollinger | 29017 | 1053 | 12 | 0 | 1041 | 37.32449052 | -90.02725304 | 2021-02-27 05:22:28 | Bollinger, Missouri, US |
1860600 | 1860600 | 2021-02-25 | US | Oklahoma | Washita | 40149 | 1050 | 9 | 0 | 1041 | 35.29071824 | -98.99180434 | 2021-02-26 05:22:40 | Washita, Oklahoma, US |
283517 | 283517 | 2021-02-24 | US | Virginia | Giles | 51071 | 1052 | 11 | 0 | 1041 | 37.31234791 | -80.70636931 | 2021-02-25 05:24:57 | Giles, Virginia, US |
282778 | 282778 | 2021-02-24 | US | Oklahoma | Washita | 40149 | 1050 | 9 | 0 | 1041 | 35.29071824 | -98.99180434 | 2021-02-25 05:24:57 | Washita, Oklahoma, US |
282315 | 282315 | 2021-02-24 | US | Nevada | Humboldt | 32013 | 1054 | 13 | 0 | 1041 | 41.40692186 | -118.1109427 | 2021-02-25 05:24:57 | Humboldt, Nevada, US |
1938583 | 1938583 | 2021-02-23 | US | Nevada | Humboldt | 32013 | 1054 | 13 | 0 | 1041 | 41.40692186 | -118.1109427 | 2021-02-24 05:29:16 | Humboldt, Nevada, US |
1937270 | 1937270 | 2021-02-23 | US | Georgia | Johnson | 13167 | 1088 | 47 | 0 | 1041 | 32.70211082 | -82.66166794 | 2021-02-24 05:29:16 | Johnson, Georgia, US |
1936806 | 1936806 | 2021-02-23 | US | Alabama | Conecuh | 1035 | 1064 | 23 | 0 | 1041 | 31.43401703 | -86.99320044 | 2021-02-24 05:29:16 | Conecuh, Alabama, US |
531525 | 531525 | 2021-02-22 | US | Georgia | Johnson | 13167 | 1088 | 47 | 0 | 1041 | 32.70211082 | -82.66166794 | 2021-02-23 05:23:41 | Johnson, Georgia, US |
531061 | 531061 | 2021-02-22 | US | Alabama | Conecuh | 1035 | 1064 | 23 | 0 | 1041 | 31.43401703 | -86.99320044 | 2021-02-23 05:23:41 | Conecuh, Alabama, US |
530650 | 530650 | 2021-02-22 | India | Delhi | 638028 | 10901 | 626086 | 1041 | 28.646519 | 77.10898 | 2021-02-23 05:23:41 | Delhi, India | ||
530544 | 530544 | 2021-02-22 | Colombia | Caldas | 46305 | 966 | 44298 | 1041 | 5.2983 | -75.2479 | 2021-02-23 05:23:41 | Caldas, Colombia | ||
184635 | 184635 | 2021-02-21 | US | Oklahoma | Washita | 40149 | 1049 | 8 | 0 | 1041 | 35.29071824 | -98.99180434 | 2021-02-22 05:24:21 | Washita, Oklahoma, US |
182395 | 182395 | 2021-02-21 | US | Alabama | Conecuh | 1035 | 1064 | 23 | 0 | 1041 | 31.43401703 | -86.99320044 | 2021-02-22 05:24:21 | Conecuh, Alabama, US |
742669 | 742669 | 2021-02-20 | US | Alabama | Conecuh | 1035 | 1064 | 23 | 0 | 1041 | 31.43401703 | -86.99320044 | 2021-02-21 05:24:33 | Conecuh, Alabama, US |
473130 | 473130 | 2021-02-19 | US | Minnesota | Kanabec | 27065 | 1060 | 19 | 0 | 1041 | 45.9459309 | -93.29275192 | 2021-02-20 05:22:51 | Kanabec, Minnesota, US |
3051598 | 3051598 | 2021-02-16 | US | Kentucky | Lewis | 21135 | 1071 | 30 | 0 | 1041 | 38.53184419 | -83.37735618 | 2021-02-17 05:23:10 | Lewis, Kentucky, US |
2680575 | 2680575 | 2021-02-13 | US | Puerto Rico | Manati | 72091 | 1041 | 0 | 0 | 1041 | 18.420473 | -66.490461 | 2021-02-14 05:23:43 | Manati, Puerto Rico, US |
2677770 | 2677770 | 2021-02-13 | India | Delhi | 636796 | 10889 | 624866 | 1041 | 28.646519 | 77.10898 | 2021-02-14 05:23:43 | Delhi, India | ||
3542208 | 3542208 | 2021-02-12 | US | Puerto Rico | Manati | 72091 | 1041 | 0 | 0 | 1041 | 18.420473 | -66.490461 | 2021-02-13 05:22:12 | Manati, Puerto Rico, US |
3540645 | 3540645 | 2021-02-12 | US | Iowa | Guthrie | 19077 | 1069 | 28 | 0 | 1041 | 41.68378965 | -94.50111014 | 2021-02-13 05:22:12 | Guthrie, Iowa, US |
613380 | 613380 | 2021-02-08 | Angola | 20112 | 475 | 18596 | 1041 | -11.2027 | 17.8739 | 2021-02-09 05:23:30 | Angola | |||
1674199 | 1674199 | 2021-02-07 | US | Minnesota | Pennington | 27113 | 1057 | 16 | 0 | 1041 | 48.06642577 | -96.0370814 | 2021-02-08 05:22:39 | Pennington, Minnesota, US |
1591415 | 1591415 | 2021-02-05 | US | Texas | Ward | 48475 | 985 | 18 | 0 | 1041 | 31.50999644 | -103.0927909 | 2021-02-06 05:23:55 | Ward, Texas, US |
1588197 | 1588197 | 2021-02-05 | Japan | Kyoto | 8683 | 129 | 7513 | 1041 | 35.253815 | 135.443341 | 2021-02-06 05:23:55 | Kyoto, Japan | ||
342282 | 342282 | 2021-02-03 | US | Montana | Park | 30067 | 1048 | 7 | 0 | 1041 | 45.48965095 | -110.52643940000002 | 2021-02-04 05:22:26 | Park, Montana, US |
1679227 | 1679227 | 2021-02-01 | US | Puerto Rico | Naranjito | 72105 | 1041 | 0 | 0 | 1041 | 18.288019 | -66.252703 | 2021-02-02 05:22:49 | Naranjito, Puerto Rico, US |
1900221 | 1900221 | 2021-01-29 | US | Texas | Eastland | 48133 | 1045 | 28 | 0 | 1041 | 32.32743996 | -98.83243566 | 2021-01-30 05:22:49 | Eastland, Texas, US |
2483799 | 2483799 | 2021-01-28 | US | Mississippi | Perry | 28111 | 1072 | 31 | 0 | 1041 | 31.17161885 | -88.99281835 | 2021-01-29 05:22:23 | Perry, Mississippi, US |
2483525 | 2483525 | 2021-01-28 | US | Maine | Somerset | 23025 | 1066 | 25 | 0 | 1041 | 45.51229767 | -69.95995554 | 2021-01-29 05:22:23 | Somerset, Maine, US |
2483386 | 2483386 | 2021-01-28 | US | Kentucky | Larue | 21123 | 1048 | 7 | 0 | 1041 | 37.54567114 | -85.70138352 | 2021-01-29 05:22:23 | Larue, Kentucky, US |
2568675 | 2568675 | 2021-01-25 | US | Illinois | Massac | 17127 | 1071 | 30 | 0 | 1041 | 37.22078441 | -88.71036614 | 2021-01-26 05:22:02 | Massac, Illinois, US |
2430363 | 2430363 | 2021-01-23 | US | West Virginia | Barbour | 54001 | 1057 | 16 | 0 | 1041 | 39.1307219 | -80.00350858 | 2021-01-24 05:22:35 | Barbour, West Virginia, US |
2426698 | 2426698 | 2021-01-23 | Chile | OHiggins | 24682 | 639 | 23002 | 1041 | -34.5755 | -71.0022 | 2021-01-24 05:22:35 | OHiggins, Chile | ||
2470155 | 2470155 | 2021-01-22 | US | Virginia | King George | 51099 | 1052 | 11 | 0 | 1041 | 38.26818502 | -77.15852768 | 2021-01-23 05:22:03 | King George, Virginia, US |
239789 | 239789 | 2021-01-18 | US | Oklahoma | Haskell | 40061 | 1048 | 7 | 0 | 1041 | 35.22257600000001 | -95.11513306 | 2021-01-19 05:22:15 | Haskell, Oklahoma, US |
238947 | 238947 | 2021-01-18 | US | Minnesota | Faribault | 27043 | 1057 | 16 | 0 | 1041 | 43.67381499 | -93.94787458 | 2021-01-19 05:22:15 | Faribault, Minnesota, US |
3105040 | 3105040 | 2021-01-16 | US | Wyoming | Lincoln | 56023 | 1052 | 11 | 0 | 1041 | 42.26376367 | -110.6563997 | 2021-01-17 05:22:17 | Lincoln, Wyoming, US |
3310460 | 3310460 | 2021-01-13 | US | New York | Seneca | 36099 | 1085 | 44 | 0 | 1041 | 42.78081007 | -76.82497064 | 2021-01-14 05:22:32 | Seneca, New York, US |
2627695 | 2627695 | 2021-01-10 | US | Mississippi | Noxubee | 28103 | 1062 | 21 | 0 | 1041 | 33.11009499 | -88.56949061 | 2021-01-11 05:21:50 | Noxubee, Mississippi, US |
2625742 | 2625742 | 2021-01-10 | Cote d'Ivoire | 23750 | 139 | 22570 | 1041 | 7.54 | -5.5471 | 2021-01-11 05:21:50 | Cote d'Ivoire | |||
3901195 | 3901195 | 2021-01-09 | US | Iowa | Union | 19175 | 1060 | 19 | 0 | 1041 | 41.0277278 | -94.24234847 | 2021-01-10 05:22:12 | Union, Iowa, US |
157547 | 157547 | 2021-01-08 | US | Wisconsin | Price | 55099 | 1047 | 6 | 0 | 1041 | 45.68051754 | -90.3609888 | 2021-01-09 05:22:18 | Price, Wisconsin, US |
2544001 | 2544001 | 2021-01-07 | US | Oklahoma | Woods | 40151 | 1046 | 5 | 0 | 1041 | 36.76705782 | -98.86573064 | 2021-01-08 05:22:42 | Woods, Oklahoma, US |
2543766 | 2543766 | 2021-01-07 | US | North Carolina | Transylvania | 37175 | 1052 | 11 | 0 | 1041 | 35.20383864 | -82.79638423 | 2021-01-08 05:22:42 | Transylvania, North Carolina, US |
2866810 | 2866810 | 2021-01-06 | US | Nebraska | Otoe | 31131 | 1043 | 2 | 0 | 1041 | 40.64843556 | -96.13374142 | 2021-01-07 05:22:03 | Otoe, Nebraska, US |
2866176 | 2866176 | 2021-01-06 | US | Kentucky | Spencer | 21215 | 1046 | 5 | 0 | 1041 | 38.03223971 | -85.32749335 | 2021-01-07 05:22:03 | Spencer, Kentucky, US |
3035592 | 3035592 | 2021-01-05 | US | Kansas | Jackson | 20085 | 1051 | 10 | 0 | 1041 | 39.41673394 | -95.79356799 | 2021-01-06 05:22:16 | Jackson, Kansas, US |
1065319 | 1065319 | 2021-01-04 | US | West Virginia | Hampshire | 54027 | 1055 | 14 | 0 | 1041 | 39.32103553 | -78.60826476 | 2021-01-05 05:21:49 | Hampshire, West Virginia, US |
1065100 | 1065100 | 2021-01-04 | US | Texas | Zapata | 48505 | 1289 | 10 | 0 | 1041 | 27.00156391 | -99.16987152 | 2021-01-05 05:21:49 | Zapata, Texas, US |
1063203 | 1063203 | 2021-01-04 | US | Kentucky | Anderson | 21005 | 1044 | 3 | 0 | 1041 | 38.00671029 | -84.99171713 | 2021-01-05 05:21:49 | Anderson, Kentucky, US |
1063137 | 1063137 | 2021-01-04 | US | Kansas | Jackson | 20085 | 1051 | 10 | 0 | 1041 | 39.41673394 | -95.79356799 | 2021-01-05 05:21:49 | Jackson, Kansas, US |
3233703 | 3233703 | 2021-01-03 | US | Texas | Zapata | 48505 | 1289 | 10 | 0 | 1041 | 27.00156391 | -99.16987152 | 2021-01-04 05:22:02 | Zapata, Texas, US |
3232287 | 3232287 | 2021-01-03 | US | Mississippi | Smith | 28129 | 1061 | 20 | 0 | 1041 | 32.01744532 | -89.50644846 | 2021-01-04 05:22:02 | Smith, Mississippi, US |
1137521 | 1137521 | 2021-01-01 | US | Colorado | Pitkin | 8097 | 1273 | 4 | 0 | 1041 | 39.21720112 | -106.9310027 | 2021-01-02 05:22:33 | Pitkin, Colorado, US |
3695864 | 3695864 | 2020-12-31 | US | Alabama | Lamar | 1075 | 1056 | 15 | 0 | 1041 | 33.77995024 | -88.09668032 | 2021-01-01 05:23:07 | Lamar, Alabama, US |
767154 | 767154 | 2020-12-29 | US | Georgia | Meriwether | 13199 | 1061 | 20 | 0 | 1041 | 33.04163534 | -84.68859732 | 2020-12-30 05:22:34 | Meriwether, Georgia, US |
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]);