johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
288 rows where active = 771 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 24
- US 238
- Russia 12
- Colombia 7
- Germany 3
- Japan 3
- Chile 2
- India 2
- Lesotho 2
- Mexico 2
- Sweden 2
- Ukraine 2
- Australia 1
- Azerbaijan 1
- Barbados 1
- China 1
- France 1
- Italy 1
- Latvia 1
- Mauritania 1
- Netherlands 1
- Pakistan 1
- Tajikistan 1
- Uzbekistan 1
- Zimbabwe 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3903814 | 3903814 | 2021-07-31 | Colombia | Casanare | 34092 | 866 | 32455 | 771 | 5.7589 | -71.5724 | 2021-08-01 04:21:50 | Casanare, Colombia | ||
3296192 | 3296192 | 2021-07-30 | Japan | Ishikawa | 5014 | 118 | 4125 | 771 | 36.769464 | 136.771027 | 2021-07-31 04:21:35 | Ishikawa, Japan | ||
1330210 | 1330210 | 2021-07-24 | India | Punjab | 598741 | 16258 | 581712 | 771 | 30.841465000000003 | 75.40879 | 2021-07-25 04:22:12 | Punjab, India | ||
1932495 | 1932495 | 2021-07-05 | Latvia | 137653 | 2528 | 134354 | 771 | 56.8796 | 24.6032 | 2021-07-06 04:21:32 | Latvia | |||
3358889 | 3358889 | 2021-06-21 | Russia | Kursk Oblast | 39830 | 896 | 38163 | 771 | 51.6568453 | 36.4852695 | 2021-06-22 04:21:34 | Kursk Oblast, Russia | ||
1711980 | 1711980 | 2021-06-02 | Zimbabwe | 39031 | 1599 | 36661 | 771 | -19.015438 | 29.154857 | 2021-06-03 04:23:32 | Zimbabwe | |||
3089668 | 3089668 | 2021-05-30 | Russia | Smolensk Oblast | 31020 | 1021 | 29228 | 771 | 55.03434960000001 | 33.0192065 | 2021-05-31 03:08:59 | Smolensk Oblast, Russia | ||
2255996 | 2255996 | 2021-05-19 | Russia | Zabaykalsky Krai | 42818 | 654 | 41393 | 771 | 52.248521 | 115.956325 | 2021-05-20 04:21:05 | Zabaykalsky Krai, Russia | ||
1872808 | 1872808 | 2021-05-15 | Colombia | Meta | 48895 | 1149 | 46975 | 771 | 3.272 | -73.0877 | 2021-05-16 04:20:49 | Meta, Colombia | ||
2761113 | 2761113 | 2021-05-03 | Russia | Chuvashia Republic | 24368 | 1376 | 22221 | 771 | 55.4259922 | 47.0849429 | 2021-05-04 04:20:34 | Chuvashia Republic, Russia | ||
2450966 | 2450966 | 2021-05-02 | Russia | Chuvashia Republic | 24313 | 1373 | 22169 | 771 | 55.4259922 | 47.0849429 | 2021-05-03 04:20:39 | Chuvashia Republic, Russia | ||
2020909 | 2020909 | 2021-04-20 | Russia | Astrakhan Oblast | 32161 | 712 | 30678 | 771 | 47.1878186 | 47.608851 | 2021-04-21 04:21:14 | Astrakhan Oblast, Russia | ||
3003533 | 3003533 | 2021-04-06 | Russia | North Ossetia - Alania Republic | 16433 | 166 | 15496 | 771 | 42.79336110000001 | 44.6324493 | 2021-04-07 04:20:53 | North Ossetia - Alania Republic, Russia | ||
1732635 | 1732635 | 2021-03-14 | Pakistan | Azad Jammu and Kashmir | 11017 | 320 | 9926 | 771 | 34.027401 | 73.947253 | 2021-03-15 05:25:51 | Azad Jammu and Kashmir, Pakistan | ||
3669351 | 3669351 | 2021-03-06 | US | Minnesota | Marshall | 27089 | 786 | 15 | 0 | 771 | 48.35825983 | -96.37017407 | 2021-03-07 05:21:54 | Marshall, Minnesota, US |
1619432 | 1619432 | 2021-03-05 | US | Texas | Presidio | 48377 | 730 | 24 | 0 | 771 | 29.99954402 | -104.2408079 | 2021-03-06 04:23:41 | Presidio, Texas, US |
1617893 | 1617893 | 2021-03-05 | US | Michigan | Manistee | 26101 | 792 | 21 | 0 | 771 | 44.33352407 | -86.05626916 | 2021-03-06 04:23:41 | Manistee, Michigan, US |
2210843 | 2210843 | 2021-03-04 | US | Texas | Presidio | 48377 | 730 | 24 | 0 | 771 | 29.99954402 | -104.2408079 | 2021-03-05 05:26:29 | Presidio, Texas, US |
2208156 | 2208156 | 2021-03-04 | US | Arkansas | Nevada | 5099 | 794 | 23 | 0 | 771 | 33.66340119 | -93.30632432 | 2021-03-05 05:26:29 | Nevada, Arkansas, US |
1092676 | 1092676 | 2021-03-03 | US | Oregon | Clatsop | 41007 | 777 | 6 | 0 | 771 | 45.99712889 | -123.660711 | 2021-03-04 05:24:24 | Clatsop, Oregon, US |
1090577 | 1090577 | 2021-03-03 | US | Arkansas | Nevada | 5099 | 794 | 23 | 0 | 771 | 33.66340119 | -93.30632432 | 2021-03-04 05:24:24 | Nevada, Arkansas, US |
1000096 | 1000096 | 2021-03-01 | US | Michigan | Missaukee | 26113 | 788 | 17 | 0 | 771 | 44.33772443 | -85.09256478 | 2021-03-02 05:23:30 | Missaukee, Michigan, US |
2367691 | 2367691 | 2021-02-28 | Russia | Chuvashia Republic | 21398 | 1034 | 19593 | 771 | 55.4259922 | 47.0849429 | 2021-03-01 05:23:01 | Chuvashia Republic, Russia | ||
3069462 | 3069462 | 2021-02-27 | US | West Virginia | Braxton | 54007 | 772 | 1 | 0 | 771 | 38.70036159 | -80.72011184 | 2021-02-28 05:22:20 | Braxton, West Virginia, US |
3066817 | 3066817 | 2021-02-27 | US | Georgia | Jenkins | 13165 | 810 | 39 | 0 | 771 | 32.79248718 | -81.96040187 | 2021-02-28 05:22:20 | Jenkins, Georgia, US |
3066193 | 3066193 | 2021-02-27 | Russia | Chuvashia Republic | 21343 | 1028 | 19544 | 771 | 55.4259922 | 47.0849429 | 2021-02-28 05:22:20 | Chuvashia Republic, Russia | ||
2187046 | 2187046 | 2021-02-26 | US | West Virginia | Braxton | 54007 | 772 | 1 | 0 | 771 | 38.70036159 | -80.72011184 | 2021-02-27 05:22:28 | Braxton, West Virginia, US |
1860998 | 1860998 | 2021-02-25 | US | Tennessee | Van Buren | 47175 | 804 | 20 | 0 | 771 | 35.69864497 | -85.45221699 | 2021-02-26 05:22:40 | Van Buren, Tennessee, US |
283176 | 283176 | 2021-02-24 | US | Tennessee | Van Buren | 47175 | 801 | 20 | 0 | 771 | 35.69864497 | -85.45221699 | 2021-02-25 05:24:57 | Van Buren, Tennessee, US |
283076 | 283076 | 2021-02-24 | US | South Dakota | Spink | 46115 | 796 | 25 | 0 | 771 | 44.93837606 | -98.34626602 | 2021-02-25 05:24:57 | Spink, South Dakota, US |
281377 | 281377 | 2021-02-24 | US | Iowa | Ida | 19093 | 803 | 32 | 0 | 771 | 42.38696136 | -95.51355387 | 2021-02-25 05:24:57 | Ida, Iowa, US |
280132 | 280132 | 2021-02-24 | India | Jammu and Kashmir | 126093 | 1955 | 123367 | 771 | 33.75943 | 76.612638 | 2021-02-25 05:24:57 | Jammu and Kashmir, India | ||
1939444 | 1939444 | 2021-02-23 | US | Tennessee | Van Buren | 47175 | 801 | 20 | 0 | 771 | 35.69864497 | -85.45221699 | 2021-02-24 05:29:16 | Van Buren, Tennessee, US |
1939344 | 1939344 | 2021-02-23 | US | South Dakota | Spink | 46115 | 796 | 25 | 0 | 771 | 44.93837606 | -98.34626602 | 2021-02-24 05:29:16 | Spink, South Dakota, US |
1938101 | 1938101 | 2021-02-23 | US | Michigan | Manistee | 26101 | 792 | 21 | 0 | 771 | 44.33352407 | -86.05626916 | 2021-02-24 05:29:16 | Manistee, Michigan, US |
1936245 | 1936245 | 2021-02-23 | Chile | OHiggins | 29316 | 753 | 27792 | 771 | -34.5755 | -71.0022 | 2021-02-24 05:29:16 | OHiggins, Chile | ||
534169 | 534169 | 2021-02-22 | US | West Virginia | Braxton | 54007 | 772 | 1 | 0 | 771 | 38.70036159 | -80.72011184 | 2021-02-23 05:23:41 | Braxton, West Virginia, US |
533599 | 533599 | 2021-02-22 | US | South Dakota | Spink | 46115 | 796 | 25 | 0 | 771 | 44.93837606 | -98.34626602 | 2021-02-23 05:23:41 | Spink, South Dakota, US |
184933 | 184933 | 2021-02-21 | US | South Dakota | Spink | 46115 | 796 | 25 | 0 | 771 | 44.93837606 | -98.34626602 | 2021-02-22 05:24:21 | Spink, South Dakota, US |
181748 | 181748 | 2021-02-21 | Barbados | 2772 | 31 | 1970 | 771 | 13.1939 | -59.5432 | 2021-02-22 05:24:21 | Barbados | |||
745207 | 745207 | 2021-02-20 | US | South Dakota | Spink | 46115 | 796 | 25 | 0 | 771 | 44.93837606 | -98.34626602 | 2021-02-21 05:24:33 | Spink, South Dakota, US |
1154315 | 1154315 | 2021-02-18 | US | Iowa | Ida | 19093 | 803 | 32 | 0 | 771 | 42.38696136 | -95.51355387 | 2021-02-19 05:24:16 | Ida, Iowa, US |
3051826 | 3051826 | 2021-02-16 | US | Michigan | Manistee | 26101 | 792 | 21 | 0 | 771 | 44.33352407 | -86.05626916 | 2021-02-17 05:23:10 | Manistee, Michigan, US |
2285172 | 2285172 | 2021-02-14 | US | Minnesota | Pope | 27121 | 776 | 5 | 0 | 771 | 45.58606667 | -95.44451209 | 2021-02-15 05:24:49 | Pope, Minnesota, US |
2284303 | 2284303 | 2021-02-14 | US | Georgia | Treutlen | 13283 | 793 | 22 | 0 | 771 | 32.40422134 | -82.56904553 | 2021-02-15 05:24:49 | Treutlen, Georgia, US |
2680924 | 2680924 | 2021-02-13 | US | Texas | Hansford | 48195 | 981 | 18 | 0 | 771 | 36.27743284 | -101.3545796 | 2021-02-14 05:23:43 | Hansford, Texas, US |
2680383 | 2680383 | 2021-02-13 | US | Oklahoma | Latimer | 40077 | 779 | 8 | 0 | 771 | 34.87844729 | -95.25215049 | 2021-02-14 05:23:43 | Latimer, Oklahoma, US |
2678331 | 2678331 | 2021-02-13 | US | Arkansas | Perry | 5105 | 778 | 7 | 0 | 771 | 34.9459153 | -92.94372564 | 2021-02-14 05:23:43 | Perry, Arkansas, US |
2677677 | 2677677 | 2021-02-13 | Colombia | Magdalena | 31592 | 1222 | 29599 | 771 | 10.4113 | -74.4057 | 2021-02-14 05:23:43 | Magdalena, Colombia | ||
3542955 | 3542955 | 2021-02-12 | US | West Virginia | Pleasants | 54073 | 788 | 17 | 0 | 771 | 39.37091679 | -81.16771771 | 2021-02-13 05:22:12 | Pleasants, West Virginia, US |
3542016 | 3542016 | 2021-02-12 | US | Oklahoma | Latimer | 40077 | 779 | 8 | 0 | 771 | 34.87844729 | -95.25215049 | 2021-02-13 05:22:12 | Latimer, Oklahoma, US |
3540375 | 3540375 | 2021-02-12 | US | Idaho | Boundary | 16021 | 781 | 10 | 0 | 771 | 48.76684761 | -116.4630179 | 2021-02-13 05:22:12 | Boundary, Idaho, US |
2641218 | 2641218 | 2021-02-11 | US | West Virginia | Pleasants | 54073 | 788 | 17 | 0 | 771 | 39.37091679 | -81.16771771 | 2021-02-12 05:23:29 | Pleasants, West Virginia, US |
3982073 | 3982073 | 2021-02-10 | US | West Virginia | Pleasants | 54073 | 788 | 17 | 0 | 771 | 39.37091679 | -81.16771771 | 2021-02-11 05:23:55 | Pleasants, West Virginia, US |
1528846 | 1528846 | 2021-02-09 | US | Idaho | Valley | 16085 | 776 | 5 | 0 | 771 | 44.76728382 | -115.5676773 | 2021-02-10 05:22:41 | Valley, Idaho, US |
977659 | 977659 | 2021-02-06 | US | Puerto Rico | Juana Diaz | 72075 | 771 | 0 | 0 | 771 | 18.050764 | -66.49458100000001 | 2021-02-07 05:23:00 | Juana Diaz, Puerto Rico, US |
1686479 | 1686479 | 2021-02-02 | US | Montana | Carbon | 30009 | 782 | 11 | 0 | 771 | 45.22850116 | -109.0274047 | 2021-02-03 05:22:52 | Carbon, Montana, US |
1460612 | 1460612 | 2021-01-31 | US | Georgia | Pulaski | 13235 | 804 | 33 | 0 | 771 | 32.23334561 | -83.47549959999998 | 2021-02-01 05:22:53 | Pulaski, Georgia, US |
2214373 | 2214373 | 2021-01-30 | US | Puerto Rico | Aguas Buenas | 72007 | 771 | 0 | 0 | 771 | 18.251619 | -66.126806 | 2021-01-31 05:22:42 | Aguas Buenas, Puerto Rico, US |
2213221 | 2213221 | 2021-01-30 | US | Maine | Sagadahoc | 23023 | 772 | 1 | 0 | 771 | 43.95415864 | -69.85074999 | 2021-01-31 05:22:42 | Sagadahoc, Maine, US |
1899102 | 1899102 | 2021-01-29 | US | Missouri | Ripley | 29181 | 781 | 10 | 0 | 771 | 36.65460667 | -90.85990261 | 2021-01-30 05:22:49 | Ripley, Missouri, US |
1761185 | 1761185 | 2021-01-24 | US | Missouri | Dent | 29065 | 781 | 10 | 0 | 771 | 37.60663134 | -91.50790473 | 2021-01-25 05:22:16 | Dent, Missouri, US |
1760519 | 1760519 | 2021-01-24 | US | Iowa | Pocahontas | 19151 | 782 | 11 | 0 | 771 | 42.73420133 | -94.67862564 | 2021-01-25 05:22:16 | Pocahontas, Iowa, US |
438043 | 438043 | 2021-01-21 | US | Pennsylvania | Potter | 42105 | 788 | 17 | 0 | 771 | 41.74471626 | -77.89559864 | 2021-01-22 05:22:10 | Potter, Pennsylvania, US |
437164 | 437164 | 2021-01-21 | US | Mississippi | Kemper | 28069 | 791 | 20 | 0 | 771 | 32.75462946 | -88.64105766 | 2021-01-22 05:22:10 | Kemper, Mississippi, US |
436806 | 436806 | 2021-01-21 | US | Kentucky | Pendleton | 21191 | 772 | 1 | 0 | 771 | 38.69607718 | -84.35599463 | 2021-01-22 05:22:10 | Pendleton, Kentucky, US |
1094877 | 1094877 | 2021-01-20 | US | Georgia | Evans | 13109 | 787 | 16 | 0 | 771 | 32.15328841 | -81.8870105 | 2021-01-21 05:22:01 | Evans, Georgia, US |
240559 | 240559 | 2021-01-18 | US | Virginia | Dickenson | 51051 | 782 | 11 | 0 | 771 | 37.12560977 | -82.35124171 | 2021-01-19 05:22:15 | Dickenson, Virginia, US |
239956 | 239956 | 2021-01-18 | US | Puerto Rico | Camuy | 72027 | 771 | 0 | 0 | 771 | 18.418578 | -66.860206 | 2021-01-19 05:22:15 | Camuy, Puerto Rico, US |
3504788 | 3504788 | 2021-01-17 | US | Kentucky | Martin | 21159 | 781 | 10 | 0 | 771 | 37.79990579 | -82.51247478 | 2021-01-18 05:22:34 | Martin, Kentucky, US |
3503166 | 3503166 | 2021-01-17 | China | Hebei | 1157 | 7 | 379 | 771 | 37.8957 | 114.9042 | 2021-01-18 05:22:34 | Hebei, China | ||
190575 | 190575 | 2021-01-11 | US | Arkansas | Pike | 5109 | 785 | 14 | 0 | 771 | 34.16250414 | -93.65789349 | 2021-01-12 05:22:15 | Pike, Arkansas, US |
3903352 | 3903352 | 2021-01-09 | US | Virginia | Rockbridge | 51163 | 778 | 7 | 0 | 771 | 37.81204314 | -79.44605905 | 2021-01-10 05:22:12 | Rockbridge, Virginia, US |
2544128 | 2544128 | 2021-01-07 | US | Puerto Rico | Cidra | 72041 | 771 | 0 | 0 | 771 | 18.173559 | -66.161179 | 2021-01-08 05:22:42 | Cidra, Puerto Rico, US |
2543765 | 2543765 | 2021-01-07 | US | North Carolina | Swain | 37173 | 779 | 8 | 0 | 771 | 35.48665845 | -83.48748932 | 2021-01-08 05:22:42 | Swain, North Carolina, US |
2542819 | 2542819 | 2021-01-07 | US | Kentucky | Knott | 21119 | 785 | 14 | 0 | 771 | 37.35388197 | -82.94981134 | 2021-01-08 05:22:42 | Knott, Kentucky, US |
2228720 | 2228720 | 2021-01-02 | US | Iowa | Keokuk | 19107 | 796 | 25 | 0 | 771 | 41.33649833 | -92.1785067 | 2021-01-03 05:22:52 | Keokuk, Iowa, US |
1138734 | 1138734 | 2021-01-01 | US | Mississippi | Webster | 28155 | 789 | 18 | 0 | 771 | 33.61300486 | -89.28392912 | 2021-01-02 05:22:33 | Webster, Mississippi, US |
1013636 | 1013636 | 2020-12-30 | US | Virginia | Galax | 51640 | 806 | 35 | 0 | 771 | 36.66601852 | -80.91703124 | 2020-12-31 05:22:49 | Galax, Virginia, US |
1013333 | 1013333 | 2020-12-30 | US | Texas | Callahan | 48059 | 749 | 17 | 0 | 771 | 32.29760619 | -99.37326312 | 2020-12-31 05:22:49 | Callahan, Texas, US |
1012340 | 1012340 | 2020-12-30 | US | Nebraska | Box Butte | 31013 | 779 | 8 | 0 | 771 | 42.22079243 | -103.0878834 | 2020-12-31 05:22:49 | Box Butte, Nebraska, US |
769708 | 769708 | 2020-12-29 | US | Virginia | Richmond | 51159 | 776 | 5 | 0 | 771 | 37.937575 | -76.72920628 | 2020-12-30 05:22:34 | Richmond, Virginia, US |
768929 | 768929 | 2020-12-29 | US | Oregon | Hood River | 41027 | 783 | 12 | 0 | 771 | 45.51872811 | -121.65520359999998 | 2020-12-30 05:22:34 | Hood River, Oregon, US |
768079 | 768079 | 2020-12-29 | US | Minnesota | Swift | 27151 | 785 | 14 | 0 | 771 | 45.2829032 | -95.68264092 | 2020-12-30 05:22:34 | Swift, Minnesota, US |
3763299 | 3763299 | 2020-12-28 | US | Minnesota | Jackson | 27063 | 779 | 8 | 0 | 771 | 43.67423373 | -95.15398258 | 2020-12-29 05:22:37 | Jackson, Minnesota, US |
3778718 | 3778718 | 2020-12-27 | US | Georgia | Jasper | 13159 | 778 | 7 | 0 | 771 | 33.31535543 | -83.68844964 | 2020-12-28 05:22:06 | Jasper, Georgia, US |
2226261 | 2226261 | 2020-12-26 | US | Puerto Rico | Morovis | 72101 | 771 | 0 | 0 | 771 | 18.316963 | -66.420383 | 2020-12-27 05:22:55 | Morovis, Puerto Rico, US |
2223838 | 2223838 | 2020-12-26 | Tajikistan | 13518 | 90 | 12657 | 771 | 38.861 | 71.2761 | 2020-12-27 05:22:55 | Tajikistan | |||
3772497 | 3772497 | 2020-12-22 | US | Oregon | Morrow | 41049 | 779 | 8 | 0 | 771 | 45.41846568 | -119.584546 | 2020-12-23 05:22:03 | Morrow, Oregon, US |
2130852 | 2130852 | 2020-12-17 | US | South Dakota | Grant | 46051 | 791 | 20 | 0 | 771 | 45.1723937 | -96.77002276 | 2020-12-18 05:28:18 | Grant, South Dakota, US |
2129254 | 2129254 | 2020-12-17 | US | Kansas | Cloud | 20029 | 790 | 19 | 0 | 771 | 39.48028352 | -97.64925343 | 2020-12-18 05:28:18 | Cloud, Kansas, US |
2128350 | 2128350 | 2020-12-17 | US | Alabama | Crenshaw | 1041 | 803 | 32 | 0 | 771 | 31.72941803 | -86.31593104 | 2020-12-18 05:28:18 | Crenshaw, Alabama, US |
3150603 | 3150603 | 2020-12-16 | US | Illinois | Massac | 17127 | 789 | 18 | 0 | 771 | 37.22078441 | -88.71036614 | 2020-12-17 05:28:12 | Massac, Illinois, US |
3150340 | 3150340 | 2020-12-16 | US | Georgia | Bleckley | 13023 | 804 | 33 | 0 | 771 | 32.43829035 | -83.33035166 | 2020-12-17 05:28:12 | Bleckley, Georgia, US |
3149950 | 3149950 | 2020-12-16 | US | Alabama | Crenshaw | 1041 | 803 | 32 | 0 | 771 | 31.72941803 | -86.31593104 | 2020-12-17 05:28:12 | Crenshaw, Alabama, US |
1034778 | 1034778 | 2020-12-15 | US | Alabama | Wilcox | 1131 | 790 | 19 | 0 | 771 | 31.98773215 | -87.30891118 | 2020-12-16 05:28:04 | Wilcox, Alabama, US |
1034215 | 1034215 | 2020-12-15 | Colombia | Caqueta | 14056 | 498 | 12787 | 771 | 0.8699 | -73.8419 | 2020-12-16 05:28:04 | Caqueta, Colombia | ||
1754866 | 1754866 | 2020-12-14 | US | Wyoming | Lincoln | 56023 | 781 | 10 | 0 | 771 | 42.26376367 | -110.6563997 | 2020-12-15 05:26:38 | Lincoln, Wyoming, US |
3851271 | 3851271 | 2020-12-13 | US | West Virginia | Mason | 54053 | 782 | 11 | 0 | 771 | 38.77071799 | -82.02524219 | 2020-12-14 05:26:27 | Mason, West Virginia, US |
862500 | 862500 | 2020-12-11 | US | Mississippi | Noxubee | 28103 | 788 | 17 | 0 | 771 | 33.11009499 | -88.56949061 | 2020-12-12 05:26:19 | Noxubee, Mississippi, 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]);