johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where country_or_region = "US", "day" is on date 2021-02-26 and province_or_state = "Georgia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 161 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2184320 | 2184320 | 2021-02-26 | US | Georgia | Appling | 13001 | 2204 | 62 | 0 | 2142 | 31.74847232 | -82.28909114 | 2021-02-27 05:22:28 | Appling, Georgia, US |
2184321 | 2184321 | 2021-02-26 | US | Georgia | Atkinson | 13003 | 976 | 19 | 0 | 957 | 31.29633502 | -82.87545866 | 2021-02-27 05:22:28 | Atkinson, Georgia, US |
2184322 | 2184322 | 2021-02-26 | US | Georgia | Bacon | 13005 | 1350 | 34 | 0 | 1316 | 31.55456473 | -82.45936528 | 2021-02-27 05:22:28 | Bacon, Georgia, US |
2184323 | 2184323 | 2021-02-26 | US | Georgia | Baker | 13007 | 220 | 7 | 0 | 213 | 31.32669878 | -84.44218806 | 2021-02-27 05:22:28 | Baker, Georgia, US |
2184324 | 2184324 | 2021-02-26 | US | Georgia | Baldwin | 13009 | 4271 | 108 | 0 | 4163 | 33.06882326 | -83.24701748 | 2021-02-27 05:22:28 | Baldwin, Georgia, US |
2184325 | 2184325 | 2021-02-26 | US | Georgia | Banks | 13011 | 1683 | 32 | 0 | 1651 | 34.35607081 | -83.49644388 | 2021-02-27 05:22:28 | Banks, Georgia, US |
2184326 | 2184326 | 2021-02-26 | US | Georgia | Barrow | 13013 | 8900 | 116 | 0 | 8784 | 33.99148694 | -83.71436292 | 2021-02-27 05:22:28 | Barrow, Georgia, US |
2184327 | 2184327 | 2021-02-26 | US | Georgia | Bartow | 13015 | 12905 | 197 | 0 | 12708 | 34.23732119 | -84.83887523 | 2021-02-27 05:22:28 | Bartow, Georgia, US |
2184328 | 2184328 | 2021-02-26 | US | Georgia | Ben Hill | 13017 | 2015 | 73 | 0 | 1942 | 31.76095874 | -83.22145359 | 2021-02-27 05:22:28 | Ben Hill, Georgia, US |
2184329 | 2184329 | 2021-02-26 | US | Georgia | Berrien | 13019 | 1701 | 40 | 0 | 1661 | 31.27590016 | -83.22529920000002 | 2021-02-27 05:22:28 | Berrien, Georgia, US |
2184330 | 2184330 | 2021-02-26 | US | Georgia | Bibb | 13021 | 14796 | 374 | 0 | 14422 | 32.80904227 | -83.70489165 | 2021-02-27 05:22:28 | Bibb, Georgia, US |
2184331 | 2184331 | 2021-02-26 | US | Georgia | Bleckley | 13023 | 1407 | 49 | 0 | 1358 | 32.43829035 | -83.33035166 | 2021-02-27 05:22:28 | Bleckley, Georgia, US |
2184332 | 2184332 | 2021-02-26 | US | Georgia | Brantley | 13025 | 1506 | 29 | 0 | 1477 | 31.19576557 | -81.97743999 | 2021-02-27 05:22:28 | Brantley, Georgia, US |
2184333 | 2184333 | 2021-02-26 | US | Georgia | Brooks | 13027 | 1280 | 45 | 0 | 1235 | 30.83922642 | -83.58303423 | 2021-02-27 05:22:28 | Brooks, Georgia, US |
2184334 | 2184334 | 2021-02-26 | US | Georgia | Bryan | 13029 | 3172 | 33 | 0 | 3139 | 32.00979311 | -81.44002948 | 2021-02-27 05:22:28 | Bryan, Georgia, US |
2184335 | 2184335 | 2021-02-26 | US | Georgia | Bulloch | 13031 | 6365 | 91 | 0 | 6274 | 32.39577406 | -81.74811421 | 2021-02-27 05:22:28 | Bulloch, Georgia, US |
2184336 | 2184336 | 2021-02-26 | US | Georgia | Burke | 13033 | 2379 | 51 | 0 | 2328 | 33.05917989 | -81.99928721 | 2021-02-27 05:22:28 | Burke, Georgia, US |
2184337 | 2184337 | 2021-02-26 | US | Georgia | Butts | 13035 | 2646 | 73 | 0 | 2573 | 33.283094500000004 | -83.95435040000002 | 2021-02-27 05:22:28 | Butts, Georgia, US |
2184338 | 2184338 | 2021-02-26 | US | Georgia | Calhoun | 13037 | 571 | 15 | 0 | 556 | 31.53169785 | -84.62725131 | 2021-02-27 05:22:28 | Calhoun, Georgia, US |
2184339 | 2184339 | 2021-02-26 | US | Georgia | Camden | 13039 | 3689 | 30 | 0 | 3659 | 30.92951916 | -81.66601818 | 2021-02-27 05:22:28 | Camden, Georgia, US |
2184340 | 2184340 | 2021-02-26 | US | Georgia | Candler | 13043 | 903 | 59 | 0 | 844 | 32.40209349 | -82.07702563 | 2021-02-27 05:22:28 | Candler, Georgia, US |
2184341 | 2184341 | 2021-02-26 | US | Georgia | Carroll | 13045 | 10509 | 210 | 0 | 10299 | 33.58138199 | -85.07976677 | 2021-02-27 05:22:28 | Carroll, Georgia, US |
2184342 | 2184342 | 2021-02-26 | US | Georgia | Catoosa | 13047 | 5544 | 63 | 0 | 5481 | 34.89872298 | -85.13757014 | 2021-02-27 05:22:28 | Catoosa, Georgia, US |
2184343 | 2184343 | 2021-02-26 | US | Georgia | Charlton | 13049 | 1300 | 27 | 0 | 1273 | 30.78371028 | -82.13951596 | 2021-02-27 05:22:28 | Charlton, Georgia, US |
2184344 | 2184344 | 2021-02-26 | US | Georgia | Chatham | 13051 | 20684 | 367 | 0 | 20317 | 32.00043026 | -81.12489526 | 2021-02-27 05:22:28 | Chatham, Georgia, US |
2184345 | 2184345 | 2021-02-26 | US | Georgia | Chattahoochee | 13053 | 3063 | 11 | 0 | 3052 | 32.34341231 | -84.78809239 | 2021-02-27 05:22:28 | Chattahoochee, Georgia, US |
2184346 | 2184346 | 2021-02-26 | US | Georgia | Chattooga | 13055 | 2556 | 66 | 0 | 2490 | 34.47197698 | -85.34535662 | 2021-02-27 05:22:28 | Chattooga, Georgia, US |
2184347 | 2184347 | 2021-02-26 | US | Georgia | Cherokee | 13057 | 27233 | 262 | 0 | 26971 | 34.24393976 | -84.47431861 | 2021-02-27 05:22:28 | Cherokee, Georgia, US |
2184348 | 2184348 | 2021-02-26 | US | Georgia | Clarke | 13059 | 14048 | 118 | 0 | 13930 | 33.95436462 | -83.37124007 | 2021-02-27 05:22:28 | Clarke, Georgia, US |
2184349 | 2184349 | 2021-02-26 | US | Georgia | Clay | 13061 | 230 | 3 | 0 | 227 | 31.62221166 | -84.97713865 | 2021-02-27 05:22:28 | Clay, Georgia, US |
2184350 | 2184350 | 2021-02-26 | US | Georgia | Clayton | 13063 | 23124 | 386 | 0 | 22738 | 33.54187245 | -84.35594188 | 2021-02-27 05:22:28 | Clayton, Georgia, US |
2184351 | 2184351 | 2021-02-26 | US | Georgia | Clinch | 13065 | 910 | 23 | 0 | 887 | 30.91395822 | -82.70432472 | 2021-02-27 05:22:28 | Clinch, Georgia, US |
2184352 | 2184352 | 2021-02-26 | US | Georgia | Cobb | 13067 | 69090 | 903 | 0 | 68187 | 33.94243204 | -84.5761255 | 2021-02-27 05:22:28 | Cobb, Georgia, US |
2184353 | 2184353 | 2021-02-26 | US | Georgia | Coffee | 13069 | 5176 | 150 | 0 | 5026 | 31.54892966 | -82.85492059999999 | 2021-02-27 05:22:28 | Coffee, Georgia, US |
2184354 | 2184354 | 2021-02-26 | US | Georgia | Colquitt | 13071 | 4365 | 100 | 0 | 4265 | 31.18810588 | -83.7677946 | 2021-02-27 05:22:28 | Colquitt, Georgia, US |
2184355 | 2184355 | 2021-02-26 | US | Georgia | Columbia | 13073 | 15648 | 185 | 0 | 15463 | 33.54534185 | -82.263524 | 2021-02-27 05:22:28 | Columbia, Georgia, US |
2184356 | 2184356 | 2021-02-26 | US | Georgia | Cook | 13075 | 1702 | 39 | 0 | 1663 | 31.16068491 | -83.42947229 | 2021-02-27 05:22:28 | Cook, Georgia, US |
2184357 | 2184357 | 2021-02-26 | US | Georgia | Coweta | 13077 | 12804 | 160 | 0 | 12644 | 33.35334302 | -84.76129976 | 2021-02-27 05:22:28 | Coweta, Georgia, US |
2184358 | 2184358 | 2021-02-26 | US | Georgia | Crawford | 13079 | 618 | 16 | 0 | 602 | 32.71391813 | -83.98061238 | 2021-02-27 05:22:28 | Crawford, Georgia, US |
2184359 | 2184359 | 2021-02-26 | US | Georgia | Crisp | 13081 | 1908 | 60 | 0 | 1848 | 31.92289565 | -83.76811843 | 2021-02-27 05:22:28 | Crisp, Georgia, US |
2184360 | 2184360 | 2021-02-26 | US | Georgia | Dade | 13083 | 1263 | 10 | 0 | 1253 | 34.854916700000004 | -85.50490424 | 2021-02-27 05:22:28 | Dade, Georgia, US |
2184361 | 2184361 | 2021-02-26 | US | Georgia | Dawson | 13085 | 2783 | 35 | 0 | 2748 | 34.44244079 | -84.16964071 | 2021-02-27 05:22:28 | Dawson, Georgia, US |
2184362 | 2184362 | 2021-02-26 | US | Georgia | DeKalb | 13089 | 56643 | 821 | 0 | 55822 | 33.76944049 | -84.22396017 | 2021-02-27 05:22:28 | DeKalb, Georgia, US |
2184363 | 2184363 | 2021-02-26 | US | Georgia | Decatur | 13087 | 2734 | 65 | 0 | 2669 | 30.87967778 | -84.57619536 | 2021-02-27 05:22:28 | Decatur, Georgia, US |
2184364 | 2184364 | 2021-02-26 | US | Georgia | Dodge | 13091 | 2063 | 98 | 0 | 1965 | 32.17265114 | -83.16948926 | 2021-02-27 05:22:28 | Dodge, Georgia, US |
2184365 | 2184365 | 2021-02-26 | US | Georgia | Dooly | 13093 | 987 | 40 | 0 | 947 | 32.15630737 | -83.79746561 | 2021-02-27 05:22:28 | Dooly, Georgia, US |
2184366 | 2184366 | 2021-02-26 | US | Georgia | Dougherty | 13095 | 7042 | 279 | 0 | 6763 | 31.53328528 | -84.21722377 | 2021-02-27 05:22:28 | Dougherty, Georgia, US |
2184367 | 2184367 | 2021-02-26 | US | Georgia | Douglas | 13097 | 13355 | 179 | 0 | 13176 | 33.70291126 | -84.77026156 | 2021-02-27 05:22:28 | Douglas, Georgia, US |
2184368 | 2184368 | 2021-02-26 | US | Georgia | Early | 13099 | 1116 | 44 | 0 | 1072 | 31.32155345 | -84.90255207 | 2021-02-27 05:22:28 | Early, Georgia, US |
2184369 | 2184369 | 2021-02-26 | US | Georgia | Echols | 13101 | 449 | 6 | 0 | 443 | 30.71101099 | -82.89687287 | 2021-02-27 05:22:28 | Echols, Georgia, US |
2184370 | 2184370 | 2021-02-26 | US | Georgia | Effingham | 13103 | 4166 | 60 | 0 | 4106 | 32.36616021 | -81.34280942 | 2021-02-27 05:22:28 | Effingham, Georgia, US |
2184371 | 2184371 | 2021-02-26 | US | Georgia | Elbert | 13105 | 2205 | 61 | 0 | 2144 | 34.11302332 | -82.83936148 | 2021-02-27 05:22:28 | Elbert, Georgia, US |
2184372 | 2184372 | 2021-02-26 | US | Georgia | Emanuel | 13107 | 2451 | 78 | 0 | 2373 | 32.59221302 | -82.30239915 | 2021-02-27 05:22:28 | Emanuel, Georgia, US |
2184373 | 2184373 | 2021-02-26 | US | Georgia | Evans | 13109 | 907 | 22 | 0 | 885 | 32.15328841 | -81.8870105 | 2021-02-27 05:22:28 | Evans, Georgia, US |
2184374 | 2184374 | 2021-02-26 | US | Georgia | Fannin | 13111 | 2174 | 60 | 0 | 2114 | 34.86430205 | -84.316964 | 2021-02-27 05:22:28 | Fannin, Georgia, US |
2184375 | 2184375 | 2021-02-26 | US | Georgia | Fayette | 13113 | 7931 | 142 | 0 | 7789 | 33.41357794 | -84.49089434 | 2021-02-27 05:22:28 | Fayette, Georgia, US |
2184376 | 2184376 | 2021-02-26 | US | Georgia | Floyd | 13115 | 10961 | 196 | 0 | 10765 | 34.26268279 | -85.21577392 | 2021-02-27 05:22:28 | Floyd, Georgia, US |
2184377 | 2184377 | 2021-02-26 | US | Georgia | Forsyth | 13117 | 19306 | 148 | 0 | 19158 | 34.22604035 | -84.12315129999998 | 2021-02-27 05:22:28 | Forsyth, Georgia, US |
2184378 | 2184378 | 2021-02-26 | US | Georgia | Franklin | 13119 | 2535 | 42 | 0 | 2493 | 34.37525597 | -83.23159927 | 2021-02-27 05:22:28 | Franklin, Georgia, US |
2184379 | 2184379 | 2021-02-26 | US | Georgia | Fulton | 13121 | 85040 | 1116 | 0 | 83924 | 33.79216944 | -84.46319413 | 2021-02-27 05:22:28 | Fulton, Georgia, US |
2184380 | 2184380 | 2021-02-26 | US | Georgia | Gilmer | 13123 | 2749 | 74 | 0 | 2675 | 34.69316688 | -84.45802506 | 2021-02-27 05:22:28 | Gilmer, Georgia, US |
2184381 | 2184381 | 2021-02-26 | US | Georgia | Glascock | 13125 | 254 | 16 | 0 | 238 | 33.22879932 | -82.61297636 | 2021-02-27 05:22:28 | Glascock, Georgia, US |
2184382 | 2184382 | 2021-02-26 | US | Georgia | Glynn | 13127 | 7535 | 160 | 0 | 7375 | 31.23279254 | -81.53811412 | 2021-02-27 05:22:28 | Glynn, Georgia, US |
2184383 | 2184383 | 2021-02-26 | US | Georgia | Gordon | 13129 | 7457 | 102 | 0 | 7355 | 34.50487351 | -84.87296253 | 2021-02-27 05:22:28 | Gordon, Georgia, US |
2184384 | 2184384 | 2021-02-26 | US | Georgia | Grady | 13131 | 1990 | 55 | 0 | 1935 | 30.87454847 | -84.23418364 | 2021-02-27 05:22:28 | Grady, Georgia, US |
2184385 | 2184385 | 2021-02-26 | US | Georgia | Greene | 13133 | 1703 | 52 | 0 | 1651 | 33.5769205 | -83.17139104 | 2021-02-27 05:22:28 | Greene, Georgia, US |
2184386 | 2184386 | 2021-02-26 | US | Georgia | Gwinnett | 13135 | 91710 | 947 | 0 | 90763 | 33.96044201 | -84.02137802 | 2021-02-27 05:22:28 | Gwinnett, Georgia, US |
2184387 | 2184387 | 2021-02-26 | US | Georgia | Habersham | 13137 | 4816 | 142 | 0 | 4674 | 34.63331566 | -83.53094677 | 2021-02-27 05:22:28 | Habersham, Georgia, US |
2184388 | 2184388 | 2021-02-26 | US | Georgia | Hall | 13139 | 25434 | 396 | 0 | 25038 | 34.32207823 | -83.81896936 | 2021-02-27 05:22:28 | Hall, Georgia, US |
2184389 | 2184389 | 2021-02-26 | US | Georgia | Hancock | 13141 | 878 | 57 | 0 | 821 | 33.2721566 | -82.99766919 | 2021-02-27 05:22:28 | Hancock, Georgia, US |
2184390 | 2184390 | 2021-02-26 | US | Georgia | Haralson | 13143 | 2440 | 77 | 0 | 2363 | 33.79602175 | -85.21005667 | 2021-02-27 05:22:28 | Haralson, Georgia, US |
2184391 | 2184391 | 2021-02-26 | US | Georgia | Harris | 13145 | 2319 | 47 | 0 | 2272 | 32.73709786 | -84.90538572 | 2021-02-27 05:22:28 | Harris, Georgia, US |
2184392 | 2184392 | 2021-02-26 | US | Georgia | Hart | 13147 | 2248 | 50 | 0 | 2198 | 34.34626973 | -82.96567682 | 2021-02-27 05:22:28 | Hart, Georgia, US |
2184393 | 2184393 | 2021-02-26 | US | Georgia | Heard | 13149 | 803 | 16 | 0 | 787 | 33.29686567 | -85.12886832 | 2021-02-27 05:22:28 | Heard, Georgia, US |
2184394 | 2184394 | 2021-02-26 | US | Georgia | Henry | 13151 | 21425 | 265 | 0 | 21160 | 33.4533428 | -84.14814659999998 | 2021-02-27 05:22:28 | Henry, Georgia, US |
2184395 | 2184395 | 2021-02-26 | US | Georgia | Houston | 13153 | 13336 | 220 | 0 | 13116 | 32.45802497 | -83.66879087 | 2021-02-27 05:22:28 | Houston, Georgia, US |
2184396 | 2184396 | 2021-02-26 | US | Georgia | Irwin | 13155 | 883 | 25 | 0 | 858 | 31.60213036 | -83.27501387 | 2021-02-27 05:22:28 | Irwin, Georgia, US |
2184397 | 2184397 | 2021-02-26 | US | Georgia | Jackson | 13157 | 9030 | 131 | 0 | 8899 | 34.13794553 | -83.56814788 | 2021-02-27 05:22:28 | Jackson, Georgia, US |
2184398 | 2184398 | 2021-02-26 | US | Georgia | Jasper | 13159 | 1295 | 32 | 0 | 1263 | 33.31535543 | -83.68844964 | 2021-02-27 05:22:28 | Jasper, Georgia, US |
2184399 | 2184399 | 2021-02-26 | US | Georgia | Jeff Davis | 13161 | 1762 | 44 | 0 | 1718 | 31.80405727 | -82.63724870000001 | 2021-02-27 05:22:28 | Jeff Davis, Georgia, US |
2184400 | 2184400 | 2021-02-26 | US | Georgia | Jefferson | 13163 | 1857 | 58 | 0 | 1799 | 33.05867328 | -82.41609057 | 2021-02-27 05:22:28 | Jefferson, Georgia, US |
2184401 | 2184401 | 2021-02-26 | US | Georgia | Jenkins | 13165 | 809 | 39 | 0 | 770 | 32.79248718 | -81.96040187 | 2021-02-27 05:22:28 | Jenkins, Georgia, US |
2184402 | 2184402 | 2021-02-26 | US | Georgia | Johnson | 13167 | 1090 | 47 | 0 | 1043 | 32.70211082 | -82.66166794 | 2021-02-27 05:22:28 | Johnson, Georgia, US |
2184403 | 2184403 | 2021-02-26 | US | Georgia | Jones | 13169 | 1891 | 43 | 0 | 1848 | 33.02512137 | -83.56019163 | 2021-02-27 05:22:28 | Jones, Georgia, US |
2184404 | 2184404 | 2021-02-26 | US | Georgia | Lamar | 13171 | 1870 | 48 | 0 | 1822 | 33.07841647 | -84.14263877 | 2021-02-27 05:22:28 | Lamar, Georgia, US |
2184405 | 2184405 | 2021-02-26 | US | Georgia | Lanier | 13173 | 738 | 11 | 0 | 727 | 31.038285700000007 | -83.06472457 | 2021-02-27 05:22:28 | Lanier, Georgia, US |
2184406 | 2184406 | 2021-02-26 | US | Georgia | Laurens | 13175 | 5342 | 154 | 0 | 5188 | 32.46325233 | -82.92221316 | 2021-02-27 05:22:28 | Laurens, Georgia, US |
2184407 | 2184407 | 2021-02-26 | US | Georgia | Lee | 13177 | 2576 | 51 | 0 | 2525 | 31.779330600000005 | -84.14324253 | 2021-02-27 05:22:28 | Lee, Georgia, US |
2184408 | 2184408 | 2021-02-26 | US | Georgia | Liberty | 13179 | 3108 | 50 | 0 | 3058 | 31.82588896 | -81.49251135 | 2021-02-27 05:22:28 | Liberty, Georgia, US |
2184409 | 2184409 | 2021-02-26 | US | Georgia | Lincoln | 13181 | 741 | 21 | 0 | 720 | 33.79201475 | -82.45024131 | 2021-02-27 05:22:28 | Lincoln, Georgia, US |
2184410 | 2184410 | 2021-02-26 | US | Georgia | Long | 13183 | 799 | 12 | 0 | 787 | 31.75218791 | -81.74952375 | 2021-02-27 05:22:28 | Long, Georgia, US |
2184411 | 2184411 | 2021-02-26 | US | Georgia | Lowndes | 13185 | 11486 | 186 | 0 | 11300 | 30.83568832 | -83.27056716 | 2021-02-27 05:22:28 | Lowndes, Georgia, US |
2184412 | 2184412 | 2021-02-26 | US | Georgia | Lumpkin | 13187 | 2764 | 60 | 0 | 2704 | 34.57286511 | -84.00425681 | 2021-02-27 05:22:28 | Lumpkin, Georgia, US |
2184413 | 2184413 | 2021-02-26 | US | Georgia | Macon | 13193 | 786 | 26 | 0 | 760 | 32.35207048 | -84.04234127 | 2021-02-27 05:22:28 | Macon, Georgia, US |
2184414 | 2184414 | 2021-02-26 | US | Georgia | Madison | 13195 | 3024 | 46 | 0 | 2978 | 34.12920917 | -83.21218732 | 2021-02-27 05:22:28 | Madison, Georgia, US |
2184415 | 2184415 | 2021-02-26 | US | Georgia | Marion | 13197 | 529 | 15 | 0 | 514 | 32.3483402 | -84.52733571 | 2021-02-27 05:22:28 | Marion, Georgia, US |
2184416 | 2184416 | 2021-02-26 | US | Georgia | McDuffie | 13189 | 2275 | 43 | 0 | 2232 | 33.47851918 | -82.48252774 | 2021-02-27 05:22:28 | McDuffie, Georgia, US |
2184417 | 2184417 | 2021-02-26 | US | Georgia | McIntosh | 13191 | 730 | 15 | 0 | 715 | 31.49683595 | -81.40163426 | 2021-02-27 05:22:28 | McIntosh, Georgia, US |
2184418 | 2184418 | 2021-02-26 | US | Georgia | Meriwether | 13199 | 1844 | 57 | 0 | 1787 | 33.04163534 | -84.68859732 | 2021-02-27 05:22:28 | Meriwether, Georgia, US |
2184419 | 2184419 | 2021-02-26 | US | Georgia | Miller | 13201 | 764 | 9 | 0 | 755 | 31.16568912 | -84.73151117 | 2021-02-27 05:22:28 | Miller, 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]);