johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
162,920 rows where province_or_state = "Georgia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-04-13 322
- 2022-05-26 322
- 2020-05-08 161
- 2020-05-09 161
- 2020-05-10 161
- 2020-05-11 161
- 2020-05-12 161
- 2020-05-13 161
- 2020-05-14 161
- 2020-05-15 161
- 2020-05-16 161
- 2020-05-17 161
- 2020-05-18 161
- 2020-05-19 161
- 2020-05-20 161
- 2020-05-21 161
- 2020-05-22 161
- 2020-05-23 161
- 2020-05-24 161
- 2020-05-25 161
- 2020-05-26 161
- 2020-05-27 161
- 2020-05-28 161
- 2020-05-29 161
- 2020-05-30 161
- 2020-05-31 161
- 2020-06-01 161
- 2020-06-02 161
- 2020-06-03 161
- 2020-06-04 161
- …
province_or_state 1
- Georgia · 162,920 ✖
country_or_region 1
- US 162,920
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9196 | 9196 | 2020-10-25 | US | Georgia | Taliaferro | 13265 | 27 | 0 | 0 | 27 | 33.56543317 | -82.88136816 | 2020-10-26 04:25:02 | Taliaferro, Georgia, US |
13208 | 13208 | 2021-01-26 | US | Georgia | Taliaferro | 13265 | 102 | 0 | 0 | 102 | 33.56543317 | -82.88136816 | 2021-01-27 05:23:41 | Taliaferro, Georgia, US |
40406 | 40406 | 2020-04-13 | US | Georgia | Appling | 13001 | 11 | 0 | 0 | 11 | 31.74847232 | -82.28909114 | 2020-04-13 23:07:54 | Appling, Georgia, US |
40428 | 40428 | 2020-04-13 | US | Georgia | Atkinson | 13003 | 2 | 0 | 0 | 2 | 31.29633502 | -82.87545866 | 2020-04-13 23:07:54 | Atkinson, Georgia, US |
40440 | 40440 | 2020-04-13 | US | Georgia | Bacon | 13005 | 14 | 0 | 0 | 14 | 31.55456473 | -82.45936528 | 2020-04-13 23:07:54 | Bacon, Georgia, US |
40450 | 40450 | 2020-04-13 | US | Georgia | Banks | 13011 | 7 | 0 | 0 | 7 | 34.35607081 | -83.49644388 | 2020-04-13 23:07:54 | Banks, Georgia, US |
40491 | 40491 | 2020-04-13 | US | Georgia | Ben Hill | 13017 | 8 | 0 | 0 | 8 | 31.76095874 | -83.22145359 | 2020-04-13 23:07:54 | Ben Hill, Georgia, US |
40509 | 40509 | 2020-04-13 | US | Georgia | Berrien | 13019 | 6 | 0 | 0 | 6 | 31.27590016 | -83.22529920000002 | 2020-04-13 23:07:54 | Berrien, Georgia, US |
40528 | 40528 | 2020-04-13 | US | Georgia | Bleckley | 13023 | 3 | 0 | 0 | 3 | 32.43829035 | -83.33035166 | 2020-04-13 23:07:54 | Bleckley, Georgia, US |
40624 | 40624 | 2020-04-13 | US | Georgia | Butts | 13035 | 30 | 0 | 0 | 30 | 33.283094500000004 | -83.95435040000002 | 2020-04-13 23:07:54 | Butts, Georgia, US |
40653 | 40653 | 2020-04-13 | US | Georgia | Camden | 13039 | 22 | 0 | 0 | 22 | 30.92951916 | -81.66601818 | 2020-04-13 23:07:54 | Camden, Georgia, US |
40665 | 40665 | 2020-04-13 | US | Georgia | Candler | 13043 | 4 | 0 | 0 | 4 | 32.40209349 | -82.07702563 | 2020-04-13 23:07:54 | Candler, Georgia, US |
40711 | 40711 | 2020-04-13 | US | Georgia | Catoosa | 13047 | 13 | 0 | 0 | 13 | 34.89872298 | -85.13757014 | 2020-04-13 23:07:54 | Catoosa, Georgia, US |
40735 | 40735 | 2020-04-13 | US | Georgia | Charlton | 13049 | 3 | 0 | 0 | 3 | 30.78371028 | -82.13951596 | 2020-04-13 23:07:54 | Charlton, Georgia, US |
40738 | 40738 | 2020-04-13 | US | Georgia | Chattahoochee | 13053 | 3 | 0 | 0 | 3 | 32.34341231 | -84.78809239 | 2020-04-13 23:07:54 | Chattahoochee, Georgia, US |
40831 | 40831 | 2020-04-13 | US | Georgia | Clinch | 13065 | 6 | 0 | 0 | 6 | 30.91395822 | -82.70432472 | 2020-04-13 23:07:54 | Clinch, Georgia, US |
40865 | 40865 | 2020-04-13 | US | Georgia | Columbia | 13073 | 70 | 0 | 0 | 70 | 33.54534185 | -82.263524 | 2020-04-13 23:07:54 | Columbia, Georgia, US |
40883 | 40883 | 2020-04-13 | US | Georgia | Cook | 13075 | 7 | 0 | 0 | 7 | 31.16068491 | -83.42947229 | 2020-04-13 23:07:54 | Cook, Georgia, US |
40910 | 40910 | 2020-04-13 | US | Georgia | Crawford | 13079 | 3 | 0 | 0 | 3 | 32.71391813 | -83.98061238 | 2020-04-13 23:07:54 | Crawford, Georgia, US |
40990 | 40990 | 2020-04-13 | US | Georgia | Decatur | 13087 | 36 | 0 | 0 | 36 | 30.87967778 | -84.57619536 | 2020-04-13 23:07:54 | Decatur, Georgia, US |
41023 | 41023 | 2020-04-13 | US | Georgia | Dodge | 13091 | 14 | 0 | 0 | 14 | 32.17265114 | -83.16948926 | 2020-04-13 23:07:54 | Dodge, Georgia, US |
41067 | 41067 | 2020-04-13 | US | Georgia | Echols | 13101 | 2 | 0 | 0 | 2 | 30.71101099 | -82.89687287 | 2020-04-13 23:07:54 | Echols, Georgia, US |
41080 | 41080 | 2020-04-13 | US | Georgia | Elbert | 13105 | 3 | 0 | 0 | 3 | 34.11302332 | -82.83936148 | 2020-04-13 23:07:54 | Elbert, Georgia, US |
41088 | 41088 | 2020-04-13 | US | Georgia | Emanuel | 13107 | 9 | 0 | 0 | 9 | 32.59221302 | -82.30239915 | 2020-04-13 23:07:54 | Emanuel, Georgia, US |
41106 | 41106 | 2020-04-13 | US | Georgia | Evans | 13109 | 1 | 0 | 0 | 1 | 32.15328841 | -81.8870105 | 2020-04-13 23:07:54 | Evans, Georgia, US |
41116 | 41116 | 2020-04-13 | US | Georgia | Fannin | 13111 | 9 | 0 | 0 | 9 | 34.86430205 | -84.316964 | 2020-04-13 23:07:54 | Fannin, Georgia, US |
41162 | 41162 | 2020-04-13 | US | Georgia | Franklin | 13119 | 4 | 0 | 0 | 4 | 34.37525597 | -83.23159927 | 2020-04-13 23:07:54 | Franklin, Georgia, US |
41233 | 41233 | 2020-04-13 | US | Georgia | Gilmer | 13123 | 7 | 0 | 0 | 7 | 34.69316688 | -84.45802506 | 2020-04-13 23:07:54 | Gilmer, Georgia, US |
41241 | 41241 | 2020-04-13 | US | Georgia | Glynn | 13127 | 38 | 0 | 0 | 38 | 31.23279254 | -81.53811412 | 2020-04-13 23:07:54 | Glynn, Georgia, US |
41253 | 41253 | 2020-04-13 | US | Georgia | Grady | 13131 | 15 | 0 | 0 | 15 | 30.87454847 | -84.23418364 | 2020-04-13 23:07:54 | Grady, Georgia, US |
41325 | 41325 | 2020-04-13 | US | Georgia | Hall | 13139 | 292 | 0 | 0 | 292 | 34.32207823 | -83.81896936 | 2020-04-13 23:07:54 | Hall, Georgia, US |
41343 | 41343 | 2020-04-13 | US | Georgia | Hancock | 13141 | 3 | 0 | 0 | 3 | 33.2721566 | -82.99766919 | 2020-04-13 23:07:54 | Hancock, Georgia, US |
41355 | 41355 | 2020-04-13 | US | Georgia | Haralson | 13143 | 16 | 0 | 0 | 16 | 33.79602175 | -85.21005667 | 2020-04-13 23:07:54 | Haralson, Georgia, US |
41376 | 41376 | 2020-04-13 | US | Georgia | Hart | 13147 | 4 | 0 | 0 | 4 | 34.34626973 | -82.96567682 | 2020-04-13 23:07:54 | Hart, Georgia, US |
41483 | 41483 | 2020-04-13 | US | Georgia | Irwin | 13155 | 12 | 0 | 0 | 12 | 31.60213036 | -83.27501387 | 2020-04-13 23:07:54 | Irwin, Georgia, US |
41514 | 41514 | 2020-04-13 | US | Georgia | Jasper | 13159 | 8 | 0 | 0 | 8 | 33.31535543 | -83.68844964 | 2020-04-13 23:07:54 | Jasper, Georgia, US |
41523 | 41523 | 2020-04-13 | US | Georgia | Jeff Davis | 13161 | 1 | 0 | 0 | 1 | 31.80405727 | -82.63724870000001 | 2020-04-13 23:07:54 | Jeff Davis, Georgia, US |
41572 | 41572 | 2020-04-13 | US | Georgia | Jones | 13169 | 12 | 0 | 0 | 12 | 33.02512137 | -83.56019163 | 2020-04-13 23:07:54 | Jones, Georgia, US |
41668 | 41668 | 2020-04-13 | US | Georgia | Lamar | 13171 | 18 | 0 | 0 | 18 | 33.07841647 | -84.14263877 | 2020-04-13 23:07:54 | Lamar, Georgia, US |
41679 | 41679 | 2020-04-13 | US | Georgia | Lanier | 13173 | 5 | 0 | 0 | 5 | 31.03828570000001 | -83.06472457 | 2020-04-13 23:07:54 | Lanier, Georgia, US |
41741 | 41741 | 2020-04-13 | US | Georgia | Liberty | 13179 | 18 | 0 | 0 | 18 | 31.82588896 | -81.49251135 | 2020-04-13 23:07:54 | Liberty, Georgia, US |
41749 | 41749 | 2020-04-13 | US | Georgia | Lincoln | 13181 | 9 | 0 | 0 | 9 | 33.79201475 | -82.45024131 | 2020-04-13 23:07:54 | Lincoln, Georgia, US |
41788 | 41788 | 2020-04-13 | US | Georgia | Long | 13183 | 1 | 0 | 0 | 1 | 31.75218791 | -81.74952375 | 2020-04-13 23:07:54 | Long, Georgia, US |
41804 | 41804 | 2020-04-13 | US | Georgia | Lumpkin | 13187 | 9 | 0 | 0 | 9 | 34.57286511 | -84.00425681 | 2020-04-13 23:07:54 | Lumpkin, Georgia, US |
41820 | 41820 | 2020-04-13 | US | Georgia | Macon | 13193 | 25 | 0 | 0 | 25 | 32.35207048 | -84.04234127 | 2020-04-13 23:07:54 | Macon, Georgia, US |
41865 | 41865 | 2020-04-13 | US | Georgia | Marion | 13197 | 10 | 0 | 0 | 10 | 32.3483402 | -84.52733571 | 2020-04-13 23:07:54 | Marion, Georgia, US |
41925 | 41925 | 2020-04-13 | US | Georgia | McIntosh | 3 | 0 | 0 | 3 | 34.91369188 | 0.0 | 2020-04-13 23:07:54 | McIntosh, Georgia, US | |
41963 | 41963 | 2020-04-13 | US | Georgia | Meriwether | 13199 | 23 | 0 | 0 | 23 | 33.04163534 | -84.68859732 | 2020-04-13 23:07:54 | Meriwether, Georgia, US |
41981 | 41981 | 2020-04-13 | US | Georgia | Miller | 13201 | 12 | 0 | 0 | 12 | 31.16568912 | -84.73151117 | 2020-04-13 23:07:54 | Miller, Georgia, US |
42026 | 42026 | 2020-04-13 | US | Georgia | Montgomery | 13209 | 2 | 0 | 0 | 2 | 32.17201038 | -82.53527476 | 2020-04-13 23:07:54 | Montgomery, Georgia, US |
42051 | 42051 | 2020-04-13 | US | Georgia | Morgan | 13211 | 14 | 0 | 0 | 14 | 33.59232073 | -83.49129491 | 2020-04-13 23:07:54 | Morgan, Georgia, US |
42071 | 42071 | 2020-04-13 | US | Georgia | Murray | 13213 | 15 | 0 | 0 | 15 | 34.78897608 | -84.74993177 | 2020-04-13 23:07:54 | Murray, Georgia, US |
42280 | 42280 | 2020-04-13 | US | Georgia | Pike | 13231 | 18 | 0 | 0 | 18 | 33.09310242 | -84.38790389 | 2020-04-13 23:07:54 | Pike, Georgia, US |
42310 | 42310 | 2020-04-13 | US | Georgia | Polk | 13233 | 24 | 0 | 0 | 24 | 34.00267074 | -85.18677781 | 2020-04-13 23:07:54 | Polk, Georgia, US |
42361 | 42361 | 2020-04-13 | US | Georgia | Putnam | 13237 | 7 | 0 | 0 | 7 | 33.32056115 | -83.37552891 | 2020-04-13 23:07:54 | Putnam, Georgia, US |
42369 | 42369 | 2020-04-13 | US | Georgia | Quitman | 13239 | 3 | 0 | 0 | 3 | 31.86728114 | -85.01773177 | 2020-04-13 23:07:54 | Quitman, Georgia, US |
42371 | 42371 | 2020-04-13 | US | Georgia | Rabun | 13241 | 6 | 0 | 0 | 6 | 34.88389445 | -83.40304637 | 2020-04-13 23:07:54 | Rabun, Georgia, US |
42529 | 42529 | 2020-04-13 | US | Georgia | Screven | 13251 | 7 | 0 | 0 | 7 | 32.74976524 | -81.60779441 | 2020-04-13 23:07:54 | Screven, Georgia, US |
42638 | 42638 | 2020-04-13 | US | Georgia | Stephens | 13257 | 19 | 0 | 0 | 19 | 34.55151201 | -83.29405315 | 2020-04-13 23:07:54 | Stephens, Georgia, US |
42646 | 42646 | 2020-04-13 | US | Georgia | Stewart | 13259 | 8 | 0 | 0 | 8 | 32.07996777 | -84.83208037 | 2020-04-13 23:07:54 | Stewart, Georgia, US |
42701 | 42701 | 2020-04-13 | US | Georgia | Tattnall | 13267 | 5 | 0 | 0 | 5 | 32.04785085 | -82.05539188 | 2020-04-13 23:07:54 | Tattnall, Georgia, US |
42711 | 42711 | 2020-04-13 | US | Georgia | Telfair | 13271 | 9 | 0 | 0 | 9 | 31.92829517 | -82.93491155 | 2020-04-13 23:07:54 | Telfair, Georgia, US |
42744 | 42744 | 2020-04-13 | US | Georgia | Towns | 13281 | 3 | 0 | 0 | 3 | 34.91369188 | -83.74107459999998 | 2020-04-13 23:07:54 | Towns, Georgia, US |
42749 | 42749 | 2020-04-13 | US | Georgia | Treutlen | 13283 | 1 | 0 | 0 | 1 | 32.40422134 | -82.56904553 | 2020-04-13 23:07:54 | Treutlen, Georgia, US |
42760 | 42760 | 2020-04-13 | US | Georgia | Turner | 13287 | 37 | 0 | 0 | 37 | 31.71612656 | -83.62069378 | 2020-04-13 23:07:54 | Turner, Georgia, US |
42765 | 42765 | 2020-04-13 | US | Georgia | Twiggs | 13289 | 2 | 0 | 0 | 2 | 32.67435595 | -83.43078662 | 2020-04-13 23:07:54 | Twiggs, Georgia, US |
42872 | 42872 | 2020-04-13 | US | Georgia | Walker | 13295 | 6 | 0 | 0 | 6 | 34.73376362 | -85.30165174 | 2020-04-13 23:07:54 | Walker, Georgia, US |
42886 | 42886 | 2020-04-13 | US | Georgia | Warren | 13301 | 7 | 0 | 0 | 7 | 33.41146451 | -82.67795848 | 2020-04-13 23:07:54 | Warren, Georgia, US |
42909 | 42909 | 2020-04-13 | US | Georgia | Washington | 13303 | 23 | 0 | 0 | 23 | 32.96711864 | -82.79357039 | 2020-04-13 23:07:54 | Washington, Georgia, US |
42942 | 42942 | 2020-04-13 | US | Georgia | Wayne | 13305 | 4 | 0 | 0 | 4 | 31.5521809 | -81.91894878 | 2020-04-13 23:07:54 | Wayne, Georgia, US |
42958 | 42958 | 2020-04-13 | US | Georgia | Webster | 13307 | 3 | 0 | 0 | 3 | 32.04066113 | -84.54742852 | 2020-04-13 23:07:54 | Webster, Georgia, US |
42977 | 42977 | 2020-04-13 | US | Georgia | Wheeler | 13309 | 2 | 0 | 0 | 2 | 32.12009104 | -82.72574721 | 2020-04-13 23:07:54 | Wheeler, Georgia, US |
42979 | 42979 | 2020-04-13 | US | Georgia | White | 13311 | 11 | 0 | 0 | 11 | 34.64624278 | -83.74905525 | 2020-04-13 23:07:54 | White, Georgia, US |
42991 | 42991 | 2020-04-13 | US | Georgia | Wilcox | 13315 | 24 | 0 | 0 | 24 | 31.97496928 | -83.43438555 | 2020-04-13 23:07:54 | Wilcox, Georgia, US |
42992 | 42992 | 2020-04-13 | US | Georgia | Wilkes | 13317 | 6 | 0 | 0 | 6 | 33.78290391 | -82.74286107 | 2020-04-13 23:07:54 | Wilkes, Georgia, US |
47464 | 47464 | 2020-04-17 | US | Georgia | Appling | 13001 | 18 | 0 | 0 | 18 | 31.74847232 | -82.28909114 | 2020-04-17 23:30:52 | Appling, Georgia, US |
47487 | 47487 | 2020-04-17 | US | Georgia | Atkinson | 13003 | 5 | 0 | 0 | 5 | 31.29633502 | -82.87545866 | 2020-04-17 23:30:52 | Atkinson, Georgia, US |
47509 | 47509 | 2020-04-17 | US | Georgia | Banks | 13011 | 13 | 0 | 0 | 13 | 34.35607081 | -83.49644388 | 2020-04-17 23:30:52 | Banks, Georgia, US |
47551 | 47551 | 2020-04-17 | US | Georgia | Ben Hill | 13017 | 13 | 0 | 0 | 13 | 31.76095874 | -83.22145359 | 2020-04-17 23:30:52 | Ben Hill, Georgia, US |
47569 | 47569 | 2020-04-17 | US | Georgia | Berrien | 13019 | 10 | 0 | 0 | 10 | 31.27590016 | -83.22529920000002 | 2020-04-17 23:30:52 | Berrien, Georgia, US |
47588 | 47588 | 2020-04-17 | US | Georgia | Bleckley | 13023 | 4 | 0 | 0 | 4 | 32.43829035 | -83.33035166 | 2020-04-17 23:30:52 | Bleckley, Georgia, US |
47685 | 47685 | 2020-04-17 | US | Georgia | Butts | 13035 | 40 | 0 | 0 | 40 | 33.283094500000004 | -83.95435040000002 | 2020-04-17 23:30:52 | Butts, Georgia, US |
47713 | 47713 | 2020-04-17 | US | Georgia | Camden | 13039 | 27 | 0 | 0 | 27 | 30.92951916 | -81.66601818 | 2020-04-17 23:30:52 | Camden, Georgia, US |
47725 | 47725 | 2020-04-17 | US | Georgia | Candler | 13043 | 4 | 0 | 0 | 4 | 32.40209349 | -82.07702563 | 2020-04-17 23:30:52 | Candler, Georgia, US |
47771 | 47771 | 2020-04-17 | US | Georgia | Catoosa | 13047 | 18 | 0 | 0 | 18 | 34.89872298 | -85.13757014 | 2020-04-17 23:30:52 | Catoosa, Georgia, US |
47795 | 47795 | 2020-04-17 | US | Georgia | Charlton | 13049 | 5 | 0 | 0 | 5 | 30.78371028 | -82.13951596 | 2020-04-17 23:30:52 | Charlton, Georgia, US |
47799 | 47799 | 2020-04-17 | US | Georgia | Chattahoochee | 13053 | 6 | 0 | 0 | 6 | 32.34341231 | -84.78809239 | 2020-04-17 23:30:52 | Chattahoochee, Georgia, US |
47894 | 47894 | 2020-04-17 | US | Georgia | Clinch | 13065 | 7 | 0 | 0 | 7 | 30.91395822 | -82.70432472 | 2020-04-17 23:30:52 | Clinch, Georgia, US |
47973 | 47973 | 2020-04-17 | US | Georgia | Crawford | 13079 | 13 | 0 | 0 | 13 | 32.71391813 | -83.98061238 | 2020-04-17 23:30:52 | Crawford, Georgia, US |
48054 | 48054 | 2020-04-17 | US | Georgia | Decatur | 13087 | 55 | 0 | 0 | 55 | 30.87967778 | -84.57619536 | 2020-04-17 23:30:52 | Decatur, Georgia, US |
48088 | 48088 | 2020-04-17 | US | Georgia | Dodge | 13091 | 19 | 0 | 0 | 19 | 32.17265114 | -83.16948926 | 2020-04-17 23:30:52 | Dodge, Georgia, US |
48132 | 48132 | 2020-04-17 | US | Georgia | Echols | 13101 | 4 | 0 | 0 | 4 | 30.71101099 | -82.89687287 | 2020-04-17 23:30:52 | Echols, Georgia, US |
48145 | 48145 | 2020-04-17 | US | Georgia | Elbert | 13105 | 7 | 0 | 0 | 7 | 34.11302332 | -82.83936148 | 2020-04-17 23:30:52 | Elbert, Georgia, US |
48153 | 48153 | 2020-04-17 | US | Georgia | Emanuel | 13107 | 12 | 0 | 0 | 12 | 32.59221302 | -82.30239915 | 2020-04-17 23:30:52 | Emanuel, Georgia, US |
48170 | 48170 | 2020-04-17 | US | Georgia | Evans | 13109 | 2 | 0 | 0 | 2 | 32.15328841 | -81.8870105 | 2020-04-17 23:30:52 | Evans, Georgia, US |
48180 | 48180 | 2020-04-17 | US | Georgia | Fannin | 13111 | 14 | 0 | 0 | 14 | 34.86430205 | -84.316964 | 2020-04-17 23:30:52 | Fannin, Georgia, US |
48226 | 48226 | 2020-04-17 | US | Georgia | Franklin | 13119 | 10 | 0 | 0 | 10 | 34.37525597 | -83.23159927 | 2020-04-17 23:30:52 | Franklin, Georgia, US |
48298 | 48298 | 2020-04-17 | US | Georgia | Gilmer | 13123 | 10 | 0 | 0 | 10 | 34.69316688 | -84.45802506 | 2020-04-17 23:30:52 | Gilmer, Georgia, US |
48306 | 48306 | 2020-04-17 | US | Georgia | Glynn | 13127 | 46 | 0 | 0 | 46 | 31.23279254 | -81.53811412 | 2020-04-17 23:30:52 | Glynn, Georgia, US |
48407 | 48407 | 2020-04-17 | US | Georgia | Hancock | 13141 | 6 | 0 | 0 | 6 | 33.2721566 | -82.99766919 | 2020-04-17 23:30:52 | Hancock, 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]);