daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where "last_update" is on date 2020-06-03 and province_or_state = "Georgia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-02 | US | Georgia | Mitchell | 13205 | 413 | 32 | 0 | 381 | 31.22483255 | -84.19381821 | 2020-06-03 02:33:13 | Mitchell, Georgia, US |
2020-06-02 | US | Georgia | Monroe | 13207 | 121 | 11 | 0 | 110 | 33.014289 | -83.92097166 | 2020-06-03 02:33:13 | Monroe, Georgia, US |
2020-06-02 | US | Georgia | Montgomery | 13209 | 11 | 0 | 0 | 11 | 32.17201038 | -82.53527476 | 2020-06-03 02:33:13 | Montgomery, Georgia, US |
2020-06-02 | US | Georgia | Morgan | 13211 | 38 | 0 | 0 | 38 | 33.59232073 | -83.49129491 | 2020-06-03 02:33:13 | Morgan, Georgia, US |
2020-06-02 | US | Georgia | Murray | 13213 | 96 | 1 | 0 | 95 | 34.78897608 | -84.74993177 | 2020-06-03 02:33:13 | Murray, Georgia, US |
2020-06-02 | US | Georgia | Muscogee | 13215 | 637 | 18 | 0 | 619 | 32.50931999 | -84.87142262 | 2020-06-03 02:33:13 | Muscogee, Georgia, US |
2020-06-02 | US | Georgia | Newton | 13217 | 370 | 11 | 0 | 359 | 33.55514538 | -83.84547140000002 | 2020-06-03 02:33:13 | Newton, Georgia, US |
2020-06-02 | US | Georgia | Oconee | 13219 | 116 | 8 | 0 | 108 | 33.83749973 | -83.43679568 | 2020-06-03 02:33:13 | Oconee, Georgia, US |
2020-06-02 | US | Georgia | Oglethorpe | 13221 | 62 | 7 | 0 | 55 | 33.878629600000004 | -83.08278123 | 2020-06-03 02:33:13 | Oglethorpe, Georgia, US |
2020-06-02 | US | Georgia | Out of GA | 80013 | 2144 | 32 | 0 | 2112 | 34.91369188 | 0.0 | 2020-06-03 02:33:13 | Out of GA, Georgia, US |
2020-06-02 | US | Georgia | Paulding | 13223 | 330 | 11 | 0 | 319 | 33.91969522 | -84.86848792 | 2020-06-03 02:33:13 | Paulding, Georgia, US |
2020-06-02 | US | Georgia | Peach | 13225 | 74 | 4 | 0 | 70 | 32.56934316 | -83.82937 | 2020-06-03 02:33:13 | Peach, Georgia, US |
2020-06-02 | US | Georgia | Pickens | 13227 | 48 | 3 | 0 | 45 | 34.46589159 | -84.46406611 | 2020-06-03 02:33:13 | Pickens, Georgia, US |
2020-06-02 | US | Georgia | Pierce | 13229 | 100 | 3 | 0 | 97 | 31.35928155 | -82.21598442 | 2020-06-03 02:33:13 | Pierce, Georgia, US |
2020-06-02 | US | Georgia | Pike | 13231 | 54 | 3 | 0 | 51 | 33.09310242 | -84.38790389 | 2020-06-03 02:33:13 | Pike, Georgia, US |
2020-06-02 | US | Georgia | Polk | 13233 | 126 | 1 | 0 | 125 | 34.00267074 | -85.18677781 | 2020-06-03 02:33:13 | Polk, Georgia, US |
2020-06-02 | US | Georgia | Pulaski | 13235 | 42 | 2 | 0 | 40 | 32.23334561 | -83.47549959999998 | 2020-06-03 02:33:13 | Pulaski, Georgia, US |
2020-06-02 | US | Georgia | Putnam | 13237 | 93 | 9 | 0 | 84 | 33.32056115 | -83.37552891 | 2020-06-03 02:33:13 | Putnam, Georgia, US |
2020-06-02 | US | Georgia | Quitman | 13239 | 12 | 1 | 0 | 11 | 31.86728114 | -85.01773177 | 2020-06-03 02:33:13 | Quitman, Georgia, US |
2020-06-02 | US | Georgia | Rabun | 13241 | 23 | 1 | 0 | 22 | 34.88389445 | -83.40304637 | 2020-06-03 02:33:13 | Rabun, Georgia, US |
2020-06-02 | US | Georgia | Randolph | 13243 | 179 | 19 | 0 | 160 | 31.76622818 | -84.75732369 | 2020-06-03 02:33:13 | Randolph, Georgia, US |
2020-06-02 | US | Georgia | Richmond | 13245 | 598 | 25 | 0 | 573 | 33.35777107 | -82.07026432 | 2020-06-03 02:33:13 | Richmond, Georgia, US |
2020-06-02 | US | Georgia | Rockdale | 13247 | 289 | 8 | 0 | 281 | 33.65145002 | -84.02202167 | 2020-06-03 02:33:13 | Rockdale, Georgia, US |
2020-06-02 | US | Georgia | Schley | 13249 | 16 | 1 | 0 | 15 | 32.2654021 | -84.31258912 | 2020-06-03 02:33:13 | Schley, Georgia, US |
2020-06-02 | US | Georgia | Screven | 13251 | 55 | 3 | 0 | 52 | 32.74976524 | -81.60779441 | 2020-06-03 02:33:13 | Screven, Georgia, US |
2020-06-02 | US | Georgia | Seminole | 13253 | 45 | 2 | 0 | 43 | 30.93464824 | -84.86823924 | 2020-06-03 02:33:13 | Seminole, Georgia, US |
2020-06-02 | US | Georgia | Spalding | 13255 | 277 | 22 | 0 | 255 | 33.26310031 | -84.28013991 | 2020-06-03 02:33:13 | Spalding, Georgia, US |
2020-06-02 | US | Georgia | Stephens | 13257 | 147 | 2 | 0 | 145 | 34.55151201 | -83.29405315 | 2020-06-03 02:33:13 | Stephens, Georgia, US |
2020-06-02 | US | Georgia | Stewart | 13259 | 52 | 1 | 0 | 51 | 32.07996777 | -84.83208037 | 2020-06-03 02:33:13 | Stewart, Georgia, US |
2020-06-02 | US | Georgia | Sumter | 13261 | 489 | 44 | 0 | 445 | 32.03650571 | -84.19821492 | 2020-06-03 02:33:13 | Sumter, Georgia, US |
2020-06-02 | US | Georgia | Talbot | 13263 | 39 | 2 | 0 | 37 | 32.69642758 | -84.53351366 | 2020-06-03 02:33:13 | Talbot, Georgia, US |
2020-06-02 | US | Georgia | Taliaferro | 13265 | 1 | 0 | 0 | 1 | 33.56543317 | -82.88136816 | 2020-06-03 02:33:13 | Taliaferro, Georgia, US |
2020-06-02 | US | Georgia | Tattnall | 13267 | 27 | 0 | 0 | 27 | 32.04785085 | -82.05539188 | 2020-06-03 02:33:13 | Tattnall, Georgia, US |
2020-06-02 | US | Georgia | Taylor | 13269 | 22 | 2 | 0 | 20 | 32.55792548 | -84.25077141 | 2020-06-03 02:33:13 | Taylor, Georgia, US |
2020-06-02 | US | Georgia | Telfair | 13271 | 37 | 1 | 0 | 36 | 31.92829517 | -82.93491155 | 2020-06-03 02:33:13 | Telfair, Georgia, US |
2020-06-02 | US | Georgia | Terrell | 13273 | 213 | 26 | 0 | 187 | 31.77527543 | -84.44069698 | 2020-06-03 02:33:13 | Terrell, Georgia, US |
2020-06-02 | US | Georgia | Thomas | 13275 | 332 | 32 | 0 | 300 | 30.86392347 | -83.91847289 | 2020-06-03 02:33:13 | Thomas, Georgia, US |
2020-06-02 | US | Georgia | Tift | 13277 | 270 | 18 | 0 | 252 | 31.45743864 | -83.5236119 | 2020-06-03 02:33:13 | Tift, Georgia, US |
2020-06-02 | US | Georgia | Toombs | 13279 | 56 | 4 | 0 | 52 | 32.12059861 | -82.32957247 | 2020-06-03 02:33:13 | Toombs, Georgia, US |
2020-06-02 | US | Georgia | Towns | 13281 | 24 | 1 | 0 | 23 | 34.91369188 | -83.74107459999998 | 2020-06-03 02:33:13 | Towns, Georgia, US |
2020-06-02 | US | Georgia | Treutlen | 13283 | 12 | 0 | 0 | 12 | 32.40422134 | -82.56904553 | 2020-06-03 02:33:13 | Treutlen, Georgia, US |
2020-06-02 | US | Georgia | Troup | 13285 | 320 | 11 | 0 | 309 | 33.03349196 | -85.02812115 | 2020-06-03 02:33:13 | Troup, Georgia, US |
2020-06-02 | US | Georgia | Turner | 13287 | 128 | 13 | 0 | 115 | 31.71612656 | -83.62069378 | 2020-06-03 02:33:13 | Turner, Georgia, US |
2020-06-02 | US | Georgia | Twiggs | 13289 | 17 | 1 | 0 | 16 | 32.67435595 | -83.43078662 | 2020-06-03 02:33:13 | Twiggs, Georgia, US |
2020-06-02 | US | Georgia | Unassigned | 90013 | 1561 | 0 | 0 | 1561 | 34.91369188 | 0.0 | 2020-06-03 02:33:13 | Unassigned, Georgia, US |
2020-06-02 | US | Georgia | Union | 13291 | 46 | 1 | 0 | 45 | 34.82995757 | -83.98967069 | 2020-06-03 02:33:13 | Union, Georgia, US |
2020-06-02 | US | Georgia | Upson | 13293 | 284 | 34 | 0 | 250 | 32.87920671 | -84.30024826 | 2020-06-03 02:33:13 | Upson, Georgia, US |
2020-06-02 | US | Georgia | Walker | 13295 | 162 | 0 | 0 | 162 | 34.73376362 | -85.30165174 | 2020-06-03 02:33:13 | Walker, Georgia, US |
2020-06-02 | US | Georgia | Walton | 13297 | 269 | 12 | 0 | 257 | 33.78017694 | -83.73552314 | 2020-06-03 02:33:13 | Walton, Georgia, US |
2020-06-02 | US | Georgia | Ware | 13299 | 228 | 14 | 0 | 214 | 31.05449097 | -82.42224148 | 2020-06-03 02:33:13 | Ware, Georgia, US |
2020-06-02 | US | Georgia | Warren | 13301 | 18 | 0 | 0 | 18 | 33.41146451 | -82.67795848 | 2020-06-03 02:33:13 | Warren, Georgia, US |
2020-06-02 | US | Georgia | Washington | 13303 | 74 | 1 | 0 | 73 | 32.96711864 | -82.79357039 | 2020-06-03 02:33:13 | Washington, Georgia, US |
2020-06-02 | US | Georgia | Wayne | 13305 | 20 | 0 | 0 | 20 | 31.5521809 | -81.91894878 | 2020-06-03 02:33:13 | Wayne, Georgia, US |
2020-06-02 | US | Georgia | Webster | 13307 | 13 | 1 | 0 | 12 | 32.04066113 | -84.54742852 | 2020-06-03 02:33:13 | Webster, Georgia, US |
2020-06-02 | US | Georgia | Wheeler | 13309 | 13 | 0 | 0 | 13 | 32.12009104 | -82.72574721 | 2020-06-03 02:33:13 | Wheeler, Georgia, US |
2020-06-02 | US | Georgia | White | 13311 | 103 | 3 | 0 | 100 | 34.64624278 | -83.74905525 | 2020-06-03 02:33:13 | White, Georgia, US |
2020-06-02 | US | Georgia | Whitfield | 13313 | 391 | 7 | 0 | 384 | 34.80987459 | -84.96093476 | 2020-06-03 02:33:13 | Whitfield, Georgia, US |
2020-06-02 | US | Georgia | Wilcox | 13315 | 117 | 13 | 0 | 104 | 31.97496928 | -83.43438555 | 2020-06-03 02:33:13 | Wilcox, Georgia, US |
2020-06-02 | US | Georgia | Wilkes | 13317 | 33 | 1 | 0 | 32 | 33.78290391 | -82.74286107 | 2020-06-03 02:33:13 | Wilkes, Georgia, US |
2020-06-02 | US | Georgia | Wilkinson | 13319 | 70 | 7 | 0 | 63 | 32.80291082 | -83.17140684 | 2020-06-03 02:33:13 | Wilkinson, Georgia, US |
2020-06-02 | US | Georgia | Worth | 13321 | 223 | 21 | 0 | 202 | 31.55162306 | -83.85090513 | 2020-06-03 02:33:13 | Worth, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;