johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where "day" is on date 2020-05-27 and province_or_state = "Georgia" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2546093 | 2546093 | 2020-05-27 | US | Georgia | Glascock | 13125 | 1 | 0 | 0 | 1 | 33.22879932 | -82.61297636 | 2020-05-28 02:32:31 | Glascock, Georgia, US |
2547700 | 2547700 | 2020-05-27 | US | Georgia | Taliaferro | 13265 | 1 | 0 | 0 | 1 | 33.56543317 | -82.88136816 | 2020-05-28 02:32:31 | Taliaferro, Georgia, US |
2547994 | 2547994 | 2020-05-27 | US | Georgia | Webster | 13307 | 11 | 1 | 0 | 10 | 32.04066113 | -84.54742852 | 2020-05-28 02:32:31 | Webster, Georgia, US |
2546098 | 2546098 | 2020-05-27 | US | Georgia | Glynn | 13127 | 102 | 1 | 0 | 101 | 31.23279254 | -81.53811412 | 2020-05-28 02:32:31 | Glynn, Georgia, US |
2546604 | 2546604 | 2020-05-27 | US | Georgia | Laurens | 13175 | 104 | 1 | 0 | 103 | 32.46325233 | -82.92221316 | 2020-05-28 02:32:31 | Laurens, Georgia, US |
2547096 | 2547096 | 2020-05-27 | US | Georgia | Oconee | 13219 | 109 | 5 | 0 | 104 | 33.83749973 | -83.43679568 | 2020-05-28 02:32:31 | Oconee, Georgia, US |
2547278 | 2547278 | 2020-05-27 | US | Georgia | Polk | 13233 | 107 | 1 | 0 | 106 | 34.00267074 | -85.18677781 | 2020-05-28 02:32:31 | Polk, Georgia, US |
2545801 | 2545801 | 2020-05-27 | US | Georgia | Dawson | 13085 | 108 | 1 | 0 | 107 | 34.44244079 | -84.16964071 | 2020-05-28 02:32:31 | Dawson, Georgia, US |
2547903 | 2547903 | 2020-05-27 | US | Georgia | Walker | 13295 | 109 | 0 | 0 | 109 | 34.73376362 | -85.30165174 | 2020-05-28 02:32:31 | Walker, Georgia, US |
2547343 | 2547343 | 2020-05-27 | US | Georgia | Quitman | 13239 | 12 | 1 | 0 | 11 | 31.86728114 | -85.01773177 | 2020-05-28 02:32:31 | Quitman, Georgia, US |
2546946 | 2546946 | 2020-05-27 | US | Georgia | Monroe | 13207 | 118 | 8 | 0 | 110 | 33.014289 | -83.92097166 | 2020-05-28 02:32:31 | Monroe, Georgia, US |
2545636 | 2545636 | 2020-05-27 | US | Georgia | Clayton | 13063 | 1189 | 46 | 0 | 1143 | 33.54187245 | -84.35594188 | 2020-05-28 02:32:31 | Clayton, Georgia, US |
2545513 | 2545513 | 2020-05-27 | US | Georgia | Catoosa | 13047 | 115 | 0 | 0 | 115 | 34.89872298 | -85.13757014 | 2020-05-28 02:32:31 | Catoosa, Georgia, US |
2545401 | 2545401 | 2020-05-27 | US | Georgia | Burke | 13033 | 123 | 5 | 0 | 118 | 33.05917989 | -81.99928721 | 2020-05-28 02:32:31 | Burke, Georgia, US |
2546853 | 2546853 | 2020-05-27 | US | Georgia | McIntosh | 13191 | 12 | 0 | 0 | 12 | 31.49683595 | -81.40163426 | 2020-05-28 02:32:31 | McIntosh, Georgia, US |
2545435 | 2545435 | 2020-05-27 | US | Georgia | Calhoun | 13037 | 130 | 5 | 0 | 125 | 31.53169785 | -84.62725131 | 2020-05-28 02:32:31 | Calhoun, Georgia, US |
2546106 | 2546106 | 2020-05-27 | US | Georgia | Gordon | 13129 | 142 | 15 | 0 | 127 | 34.50487351 | -84.87296253 | 2020-05-28 02:32:31 | Gordon, Georgia, US |
2545463 | 2545463 | 2020-05-27 | US | Georgia | Candler | 13043 | 13 | 0 | 0 | 13 | 32.40209349 | -82.07702563 | 2020-05-28 02:32:31 | Candler, Georgia, US |
2545178 | 2545178 | 2020-05-27 | US | Georgia | Appling | 13001 | 143 | 13 | 0 | 130 | 31.74847232 | -82.28909114 | 2020-05-28 02:32:31 | Appling, Georgia, US |
2547643 | 2547643 | 2020-05-27 | US | Georgia | Stephens | 13257 | 132 | 2 | 0 | 130 | 34.55151201 | -83.29405315 | 2020-05-28 02:32:31 | Stephens, Georgia, US |
2547801 | 2547801 | 2020-05-27 | US | Georgia | Unassigned | 90013 | 1372 | 0 | 0 | 1372 | 34.91369188 | 0.0 | 2020-05-28 02:32:31 | Unassigned, Georgia, US |
2546709 | 2546709 | 2020-05-27 | US | Georgia | Long | 13183 | 15 | 1 | 0 | 14 | 31.75218791 | -81.74952375 | 2020-05-28 02:32:31 | Long, Georgia, US |
2546087 | 2546087 | 2020-05-27 | US | Georgia | Gilmer | 13123 | 145 | 0 | 0 | 145 | 34.69316688 | -84.45802506 | 2020-05-28 02:32:31 | Gilmer, Georgia, US |
2547500 | 2547500 | 2020-05-27 | US | Georgia | Schley | 13249 | 16 | 1 | 0 | 15 | 32.2654021 | -84.31258912 | 2020-05-28 02:32:31 | Schley, Georgia, US |
2547784 | 2547784 | 2020-05-27 | US | Georgia | Twiggs | 13289 | 15 | 0 | 0 | 15 | 32.67435595 | -83.43078662 | 2020-05-28 02:32:31 | Twiggs, Georgia, US |
2545819 | 2545819 | 2020-05-27 | US | Georgia | Decatur | 13087 | 161 | 4 | 0 | 157 | 30.87967778 | -84.57619536 | 2020-05-28 02:32:31 | Decatur, Georgia, US |
2547356 | 2547356 | 2020-05-27 | US | Georgia | Randolph | 13243 | 176 | 19 | 0 | 157 | 31.76622818 | -84.75732369 | 2020-05-28 02:32:31 | Randolph, Georgia, US |
2546665 | 2546665 | 2020-05-27 | US | Georgia | Lincoln | 13181 | 16 | 0 | 0 | 16 | 33.79201475 | -82.45024131 | 2020-05-28 02:32:31 | Lincoln, Georgia, US |
2547345 | 2547345 | 2020-05-27 | US | Georgia | Rabun | 13241 | 17 | 1 | 0 | 16 | 34.88389445 | -83.40304637 | 2020-05-28 02:32:31 | Rabun, Georgia, US |
2545863 | 2545863 | 2020-05-27 | US | Georgia | Dooly | 13093 | 176 | 12 | 0 | 164 | 32.15630737 | -83.79746561 | 2020-05-28 02:32:31 | Dooly, Georgia, US |
2545867 | 2545867 | 2020-05-27 | US | Georgia | Dougherty | 13095 | 1784 | 144 | 0 | 1640 | 31.53328528 | -84.21722377 | 2020-05-28 02:32:31 | Dougherty, Georgia, US |
2546388 | 2546388 | 2020-05-27 | US | Georgia | Jackson | 13157 | 171 | 5 | 0 | 166 | 34.13794553 | -83.56814788 | 2020-05-28 02:32:31 | Jackson, Georgia, US |
2546209 | 2546209 | 2020-05-27 | US | Georgia | Hancock | 13141 | 192 | 22 | 0 | 170 | 33.2721566 | -82.99766919 | 2020-05-28 02:32:31 | Hancock, Georgia, US |
2546447 | 2546447 | 2020-05-27 | US | Georgia | Jenkins | 13165 | 19 | 1 | 0 | 18 | 32.79248718 | -81.96040187 | 2020-05-28 02:32:31 | Jenkins, Georgia, US |
2546591 | 2546591 | 2020-05-27 | US | Georgia | Lanier | 13173 | 20 | 2 | 0 | 18 | 31.03828570000001 | -83.06472457 | 2020-05-28 02:32:31 | Lanier, Georgia, US |
2547918 | 2547918 | 2020-05-27 | US | Georgia | Warren | 13301 | 18 | 0 | 0 | 18 | 33.41146451 | -82.67795848 | 2020-05-28 02:32:31 | Warren, Georgia, US |
2547976 | 2547976 | 2020-05-27 | US | Georgia | Wayne | 13305 | 18 | 0 | 0 | 18 | 31.5521809 | -81.91894878 | 2020-05-28 02:32:31 | Wayne, Georgia, US |
2547725 | 2547725 | 2020-05-27 | US | Georgia | Terrell | 13273 | 215 | 26 | 0 | 189 | 31.77527543 | -84.44069698 | 2020-05-28 02:32:31 | Terrell, Georgia, US |
2548082 | 2548082 | 2020-05-27 | US | Georgia | Worth | 13321 | 209 | 20 | 0 | 189 | 31.55162306 | -83.85090513 | 2020-05-28 02:32:31 | Worth, Georgia, US |
2547158 | 2547158 | 2020-05-27 | US | Georgia | Out of GA | 80013 | 1925 | 29 | 0 | 1896 | 34.91369188 | 0.0 | 2020-05-28 02:32:31 | Out of GA, Georgia, US |
2547710 | 2547710 | 2020-05-27 | US | Georgia | Tattnall | 13267 | 19 | 0 | 0 | 19 | 32.04785085 | -82.05539188 | 2020-05-28 02:32:31 | Tattnall, Georgia, US |
2547712 | 2547712 | 2020-05-27 | US | Georgia | Taylor | 13269 | 21 | 2 | 0 | 19 | 32.55792548 | -84.25077141 | 2020-05-28 02:32:31 | Taylor, Georgia, US |
2545420 | 2545420 | 2020-05-27 | US | Georgia | Butts | 13035 | 219 | 21 | 0 | 198 | 33.283094500000004 | -83.95435040000002 | 2020-05-28 02:32:31 | Butts, Georgia, US |
2545894 | 2545894 | 2020-05-27 | US | Georgia | Early | 13099 | 239 | 30 | 0 | 209 | 31.32155345 | -84.90255207 | 2020-05-28 02:32:31 | Early, Georgia, US |
2547917 | 2547917 | 2020-05-27 | US | Georgia | Ware | 13299 | 223 | 14 | 0 | 209 | 31.05449097 | -82.42224148 | 2020-05-28 02:32:31 | Ware, Georgia, US |
2545746 | 2545746 | 2020-05-27 | US | Georgia | Crisp | 13081 | 226 | 7 | 0 | 219 | 31.92289565 | -83.76811843 | 2020-05-28 02:32:31 | Crisp, Georgia, US |
2545544 | 2545544 | 2020-05-27 | US | Georgia | Chattooga | 13055 | 24 | 2 | 0 | 22 | 34.47197698 | -85.34535662 | 2020-05-28 02:32:31 | Chattooga, Georgia, US |
2547757 | 2547757 | 2020-05-27 | US | Georgia | Towns | 13281 | 23 | 1 | 0 | 22 | 34.91369188 | -83.74107459999998 | 2020-05-28 02:32:31 | Towns, Georgia, US |
2545964 | 2545964 | 2020-05-27 | US | Georgia | Fayette | 13113 | 235 | 13 | 0 | 222 | 33.41357794 | -84.49089434 | 2020-05-28 02:32:31 | Fayette, Georgia, US |
2547736 | 2547736 | 2020-05-27 | US | Georgia | Tift | 13277 | 238 | 15 | 0 | 223 | 31.45743864 | -83.5236119 | 2020-05-28 02:32:31 | Tift, Georgia, US |
2546376 | 2546376 | 2020-05-27 | US | Georgia | Irwin | 13155 | 24 | 1 | 0 | 23 | 31.60213036 | -83.27501387 | 2020-05-28 02:32:31 | Irwin, Georgia, US |
2545686 | 2545686 | 2020-05-27 | US | Georgia | Columbia | 13073 | 237 | 7 | 0 | 230 | 33.54534185 | -82.263524 | 2020-05-28 02:32:31 | Columbia, Georgia, US |
2547911 | 2547911 | 2020-05-27 | US | Georgia | Walton | 13297 | 242 | 12 | 0 | 230 | 33.78017694 | -83.73552314 | 2020-05-28 02:32:31 | Walton, Georgia, US |
2545987 | 2545987 | 2020-05-27 | US | Georgia | Floyd | 13115 | 253 | 15 | 0 | 238 | 34.26268279 | -85.21577392 | 2020-05-28 02:32:31 | Floyd, Georgia, US |
2546189 | 2546189 | 2020-05-27 | US | Georgia | Hall | 13139 | 2422 | 42 | 0 | 2380 | 34.32207823 | -83.81896936 | 2020-05-28 02:32:31 | Hall, Georgia, US |
2547593 | 2547593 | 2020-05-27 | US | Georgia | Spalding | 13255 | 264 | 20 | 0 | 244 | 33.26310031 | -84.28013991 | 2020-05-28 02:32:31 | Spalding, Georgia, US |
2545613 | 2545613 | 2020-05-27 | US | Georgia | Clarke | 13059 | 259 | 13 | 0 | 246 | 33.95436462 | -83.37124007 | 2020-05-28 02:32:31 | Clarke, Georgia, US |
2547863 | 2547863 | 2020-05-27 | US | Georgia | Upson | 13293 | 280 | 34 | 0 | 246 | 32.87920671 | -84.30024826 | 2020-05-28 02:32:31 | Upson, Georgia, US |
2545667 | 2545667 | 2020-05-27 | US | Georgia | Coffee | 13069 | 262 | 13 | 0 | 249 | 31.54892966 | -82.85492059999999 | 2020-05-28 02:32:31 | Coffee, Georgia, US |
2545928 | 2545928 | 2020-05-27 | US | Georgia | Emanuel | 13107 | 27 | 2 | 0 | 25 | 32.59221302 | -82.30239915 | 2020-05-28 02:32:31 | Emanuel, Georgia, US |
2547771 | 2547771 | 2020-05-27 | US | Georgia | Troup | 13285 | 268 | 10 | 0 | 258 | 33.03349196 | -85.02812115 | 2020-05-28 02:32:31 | Troup, Georgia, US |
2545775 | 2545775 | 2020-05-27 | US | Georgia | Dade | 13083 | 27 | 1 | 0 | 26 | 34.854916700000004 | -85.50490424 | 2020-05-28 02:32:31 | Dade, Georgia, US |
2546252 | 2546252 | 2020-05-27 | US | Georgia | Hart | 13147 | 26 | 0 | 0 | 26 | 34.34626973 | -82.96567682 | 2020-05-28 02:32:31 | Hart, Georgia, US |
2546720 | 2546720 | 2020-05-27 | US | Georgia | Lowndes | 13185 | 268 | 4 | 0 | 264 | 30.83568832 | -83.27056716 | 2020-05-28 02:32:31 | Lowndes, Georgia, US |
2547420 | 2547420 | 2020-05-27 | US | Georgia | Rockdale | 13247 | 276 | 9 | 0 | 267 | 33.65145002 | -84.02202167 | 2020-05-28 02:32:31 | Rockdale, Georgia, US |
2545660 | 2545660 | 2020-05-27 | US | Georgia | Cobb | 13067 | 2907 | 157 | 0 | 2750 | 33.94243204 | -84.5761255 | 2020-05-28 02:32:31 | Cobb, Georgia, US |
2545734 | 2545734 | 2020-05-27 | US | Georgia | Crawford | 13079 | 28 | 0 | 0 | 28 | 32.71391813 | -83.98061238 | 2020-05-28 02:32:31 | Crawford, Georgia, US |
2546265 | 2546265 | 2020-05-27 | US | Georgia | Heard | 13149 | 30 | 2 | 0 | 28 | 33.29686567 | -85.12886832 | 2020-05-28 02:32:31 | Heard, Georgia, US |
2547732 | 2547732 | 2020-05-27 | US | Georgia | Thomas | 13275 | 324 | 31 | 0 | 293 | 30.86392347 | -83.91847289 | 2020-05-28 02:32:31 | Thomas, Georgia, US |
2547191 | 2547191 | 2020-05-27 | US | Georgia | Paulding | 13223 | 305 | 11 | 0 | 294 | 33.91969522 | -84.86848792 | 2020-05-28 02:32:31 | Paulding, Georgia, US |
2545240 | 2545240 | 2020-05-27 | US | Georgia | Barrow | 13013 | 316 | 13 | 0 | 303 | 33.99148694 | -83.71436292 | 2020-05-28 02:32:31 | Barrow, Georgia, US |
2548025 | 2548025 | 2020-05-27 | US | Georgia | Whitfield | 13313 | 311 | 7 | 0 | 304 | 34.80987459 | -84.96093476 | 2020-05-28 02:32:31 | Whitfield, Georgia, US |
2546409 | 2546409 | 2020-05-27 | US | Georgia | Jasper | 13159 | 32 | 1 | 0 | 31 | 33.31535543 | -83.68844964 | 2020-05-28 02:32:31 | Jasper, Georgia, US |
2546423 | 2546423 | 2020-05-27 | US | Georgia | Jefferson | 13163 | 32 | 1 | 0 | 31 | 33.05867328 | -82.41609057 | 2020-05-28 02:32:31 | Jefferson, Georgia, US |
2545223 | 2545223 | 2020-05-27 | US | Georgia | Baldwin | 13009 | 337 | 26 | 0 | 311 | 33.06882326 | -83.24701748 | 2020-05-28 02:32:31 | Baldwin, Georgia, US |
2545220 | 2545220 | 2020-05-27 | US | Georgia | Baker | 13007 | 34 | 2 | 0 | 32 | 31.32669878 | -84.44218806 | 2020-05-28 02:32:31 | Baker, Georgia, US |
2545538 | 2545538 | 2020-05-27 | US | Georgia | Charlton | 13049 | 33 | 1 | 0 | 32 | 30.78371028 | -82.13951596 | 2020-05-28 02:32:31 | Charlton, Georgia, US |
2548034 | 2548034 | 2020-05-27 | US | Georgia | Wilkes | 13317 | 33 | 1 | 0 | 32 | 33.78290391 | -82.74286107 | 2020-05-28 02:32:31 | Wilkes, Georgia, US |
2545543 | 2545543 | 2020-05-27 | US | Georgia | Chattahoochee | 13053 | 33 | 0 | 0 | 33 | 32.34341231 | -84.78809239 | 2020-05-28 02:32:31 | Chattahoochee, Georgia, US |
2547721 | 2547721 | 2020-05-27 | US | Georgia | Telfair | 13271 | 34 | 1 | 0 | 33 | 31.92829517 | -82.93491155 | 2020-05-28 02:32:31 | Telfair, Georgia, US |
2547055 | 2547055 | 2020-05-27 | US | Georgia | Newton | 13217 | 341 | 11 | 0 | 330 | 33.55514538 | -83.84547140000002 | 2020-05-28 02:32:31 | Newton, Georgia, US |
2546183 | 2546183 | 2020-05-27 | US | Georgia | Gwinnett | 13135 | 3480 | 126 | 0 | 3354 | 33.96044201 | -84.02137802 | 2020-05-28 02:32:31 | Gwinnett, Georgia, US |
2546418 | 2546418 | 2020-05-27 | US | Georgia | Jeff Davis | 13161 | 35 | 1 | 0 | 34 | 31.80405727 | -82.63724870000001 | 2020-05-28 02:32:31 | Jeff Davis, Georgia, US |
2546471 | 2546471 | 2020-05-27 | US | Georgia | Jones | 13169 | 34 | 0 | 0 | 34 | 33.02512137 | -83.56019163 | 2020-05-28 02:32:31 | Jones, Georgia, US |
2546627 | 2546627 | 2020-05-27 | US | Georgia | Lee | 13177 | 363 | 23 | 0 | 340 | 31.779330600000005 | -84.14324253 | 2020-05-28 02:32:31 | Lee, Georgia, US |
2546326 | 2546326 | 2020-05-27 | US | Georgia | Houston | 13153 | 362 | 16 | 0 | 346 | 32.45802497 | -83.66879087 | 2020-05-28 02:32:31 | Houston, Georgia, US |
2545809 | 2545809 | 2020-05-27 | US | Georgia | DeKalb | 13089 | 3573 | 111 | 0 | 3462 | 33.76944049 | -84.22396017 | 2020-05-28 02:32:31 | DeKalb, Georgia, US |
2545621 | 2545621 | 2020-05-27 | US | Georgia | Clay | 13061 | 37 | 2 | 0 | 35 | 31.62221166 | -84.97713865 | 2020-05-28 02:32:31 | Clay, Georgia, US |
2545203 | 2545203 | 2020-05-27 | US | Georgia | Atkinson | 13003 | 38 | 2 | 0 | 36 | 31.29633502 | -82.87545866 | 2020-05-28 02:32:31 | Atkinson, Georgia, US |
2546991 | 2546991 | 2020-05-27 | US | Georgia | Morgan | 13211 | 37 | 0 | 0 | 37 | 33.59232073 | -83.49129491 | 2020-05-28 02:32:31 | Morgan, Georgia, US |
2547326 | 2547326 | 2020-05-27 | US | Georgia | Pulaski | 13235 | 39 | 2 | 0 | 37 | 32.23334561 | -83.47549959999998 | 2020-05-28 02:32:31 | Pulaski, Georgia, US |
2547698 | 2547698 | 2020-05-27 | US | Georgia | Talbot | 13263 | 38 | 1 | 0 | 37 | 32.69642758 | -84.53351366 | 2020-05-28 02:32:31 | Talbot, Georgia, US |
2546222 | 2546222 | 2020-05-27 | US | Georgia | Haralson | 13143 | 40 | 2 | 0 | 38 | 33.79602175 | -85.21005667 | 2020-05-28 02:32:31 | Haralson, Georgia, US |
2546930 | 2546930 | 2020-05-27 | US | Georgia | Mitchell | 13205 | 412 | 32 | 0 | 380 | 31.22483255 | -84.19381821 | 2020-05-28 02:32:31 | Mitchell, Georgia, US |
2545725 | 2545725 | 2020-05-27 | US | Georgia | Coweta | 13077 | 397 | 8 | 0 | 389 | 33.35334302 | -84.76129976 | 2020-05-28 02:32:31 | Coweta, Georgia, US |
2545294 | 2545294 | 2020-05-27 | US | Georgia | Berrien | 13019 | 39 | 0 | 0 | 39 | 31.27590016 | -83.22529920000002 | 2020-05-28 02:32:31 | Berrien, Georgia, US |
2545957 | 2545957 | 2020-05-27 | US | Georgia | Fannin | 13111 | 40 | 1 | 0 | 39 | 34.86430205 | -84.316964 | 2020-05-28 02:32:31 | Fannin, Georgia, US |
2546008 | 2546008 | 2020-05-27 | US | Georgia | Franklin | 13119 | 41 | 1 | 0 | 40 | 34.37525597 | -83.23159927 | 2020-05-28 02:32:31 | Franklin, Georgia, US |
2546914 | 2546914 | 2020-05-27 | US | Georgia | Miller | 13201 | 40 | 0 | 0 | 40 | 31.16568912 | -84.73151117 | 2020-05-28 02:32:31 | Miller, Georgia, US |
2547235 | 2547235 | 2020-05-27 | US | Georgia | Pickens | 13227 | 43 | 3 | 0 | 40 | 34.46589159 | -84.46406611 | 2020-05-28 02:32:31 | Pickens, 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]);