johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where "last_update" is on date 2020-05-29 and province_or_state = "Georgia" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2710908 | 2710908 | 2020-05-28 | US | Georgia | Mitchell | 13205 | 409 | 32 | 0 | 377 | 31.22483255 | -84.19381821 | 2020-05-29 02:32:50 | Mitchell, Georgia, US |
2710924 | 2710924 | 2020-05-28 | US | Georgia | Monroe | 13207 | 119 | 8 | 0 | 111 | 33.014289 | -83.92097166 | 2020-05-29 02:32:50 | Monroe, Georgia, US |
2710943 | 2710943 | 2020-05-28 | US | Georgia | Montgomery | 13209 | 9 | 0 | 0 | 9 | 32.17201038 | -82.53527476 | 2020-05-29 02:32:50 | Montgomery, Georgia, US |
2710969 | 2710969 | 2020-05-28 | US | Georgia | Morgan | 13211 | 37 | 0 | 0 | 37 | 33.59232073 | -83.49129491 | 2020-05-29 02:32:50 | Morgan, Georgia, US |
2710992 | 2710992 | 2020-05-28 | US | Georgia | Murray | 13213 | 85 | 1 | 0 | 84 | 34.78897608 | -84.74993177 | 2020-05-29 02:32:50 | Murray, Georgia, US |
2710996 | 2710996 | 2020-05-28 | US | Georgia | Muscogee | 13215 | 593 | 17 | 0 | 576 | 32.50931999 | -84.87142262 | 2020-05-29 02:32:50 | Muscogee, Georgia, US |
2711033 | 2711033 | 2020-05-28 | US | Georgia | Newton | 13217 | 344 | 11 | 0 | 333 | 33.55514538 | -83.84547140000002 | 2020-05-29 02:32:50 | Newton, Georgia, US |
2711075 | 2711075 | 2020-05-28 | US | Georgia | Oconee | 13219 | 111 | 5 | 0 | 106 | 33.83749973 | -83.43679568 | 2020-05-29 02:32:50 | Oconee, Georgia, US |
2711081 | 2711081 | 2020-05-28 | US | Georgia | Oglethorpe | 13221 | 58 | 6 | 0 | 52 | 33.878629600000004 | -83.08278123 | 2020-05-29 02:32:50 | Oglethorpe, Georgia, US |
2711137 | 2711137 | 2020-05-28 | US | Georgia | Out of GA | 80013 | 1903 | 31 | 0 | 1872 | 34.91369188 | 0.0 | 2020-05-29 02:32:50 | Out of GA, Georgia, US |
2711170 | 2711170 | 2020-05-28 | US | Georgia | Paulding | 13223 | 309 | 11 | 0 | 298 | 33.91969522 | -84.86848792 | 2020-05-29 02:32:50 | Paulding, Georgia, US |
2711175 | 2711175 | 2020-05-28 | US | Georgia | Peach | 13225 | 70 | 4 | 0 | 66 | 32.56934316 | -83.82937 | 2020-05-29 02:32:50 | Peach, Georgia, US |
2711214 | 2711214 | 2020-05-28 | US | Georgia | Pickens | 13227 | 45 | 4 | 0 | 41 | 34.46589159 | -84.46406611 | 2020-05-29 02:32:50 | Pickens, Georgia, US |
2711217 | 2711217 | 2020-05-28 | US | Georgia | Pierce | 13229 | 97 | 3 | 0 | 94 | 31.35928155 | -82.21598442 | 2020-05-29 02:32:50 | Pierce, Georgia, US |
2711224 | 2711224 | 2020-05-28 | US | Georgia | Pike | 13231 | 54 | 2 | 0 | 52 | 33.09310242 | -84.38790389 | 2020-05-29 02:32:50 | Pike, Georgia, US |
2711257 | 2711257 | 2020-05-28 | US | Georgia | Polk | 13233 | 113 | 1 | 0 | 112 | 34.00267074 | -85.18677781 | 2020-05-29 02:32:50 | Polk, Georgia, US |
2711305 | 2711305 | 2020-05-28 | US | Georgia | Pulaski | 13235 | 40 | 2 | 0 | 38 | 32.23334561 | -83.47549959999998 | 2020-05-29 02:32:50 | Pulaski, Georgia, US |
2711313 | 2711313 | 2020-05-28 | US | Georgia | Putnam | 13237 | 88 | 9 | 0 | 79 | 33.32056115 | -83.37552891 | 2020-05-29 02:32:50 | Putnam, Georgia, US |
2711322 | 2711322 | 2020-05-28 | US | Georgia | Quitman | 13239 | 12 | 1 | 0 | 11 | 31.86728114 | -85.01773177 | 2020-05-29 02:32:50 | Quitman, Georgia, US |
2711324 | 2711324 | 2020-05-28 | US | Georgia | Rabun | 13241 | 19 | 1 | 0 | 18 | 34.88389445 | -83.40304637 | 2020-05-29 02:32:50 | Rabun, Georgia, US |
2711335 | 2711335 | 2020-05-28 | US | Georgia | Randolph | 13243 | 177 | 19 | 0 | 158 | 31.76622818 | -84.75732369 | 2020-05-29 02:32:50 | Randolph, Georgia, US |
2711372 | 2711372 | 2020-05-28 | US | Georgia | Richmond | 13245 | 576 | 22 | 0 | 554 | 33.35777107 | -82.07026432 | 2020-05-29 02:32:50 | Richmond, Georgia, US |
2711399 | 2711399 | 2020-05-28 | US | Georgia | Rockdale | 13247 | 278 | 8 | 0 | 270 | 33.65145002 | -84.02202167 | 2020-05-29 02:32:50 | Rockdale, Georgia, US |
2711479 | 2711479 | 2020-05-28 | US | Georgia | Schley | 13249 | 16 | 1 | 0 | 15 | 32.2654021 | -84.31258912 | 2020-05-29 02:32:50 | Schley, Georgia, US |
2711499 | 2711499 | 2020-05-28 | US | Georgia | Screven | 13251 | 50 | 2 | 0 | 48 | 32.74976524 | -81.60779441 | 2020-05-29 02:32:50 | Screven, Georgia, US |
2711505 | 2711505 | 2020-05-28 | US | Georgia | Seminole | 13253 | 44 | 2 | 0 | 42 | 30.93464824 | -84.86823924 | 2020-05-29 02:32:50 | Seminole, Georgia, US |
2711572 | 2711572 | 2020-05-28 | US | Georgia | Spalding | 13255 | 267 | 21 | 0 | 246 | 33.26310031 | -84.28013991 | 2020-05-29 02:32:50 | Spalding, Georgia, US |
2711622 | 2711622 | 2020-05-28 | US | Georgia | Stephens | 13257 | 136 | 2 | 0 | 134 | 34.55151201 | -83.29405315 | 2020-05-29 02:32:50 | Stephens, Georgia, US |
2711631 | 2711631 | 2020-05-28 | US | Georgia | Stewart | 13259 | 51 | 1 | 0 | 50 | 32.07996777 | -84.83208037 | 2020-05-29 02:32:50 | Stewart, Georgia, US |
2711662 | 2711662 | 2020-05-28 | US | Georgia | Sumter | 13261 | 466 | 41 | 0 | 425 | 32.03650571 | -84.19821492 | 2020-05-29 02:32:50 | Sumter, Georgia, US |
2711678 | 2711678 | 2020-05-28 | US | Georgia | Talbot | 13263 | 38 | 1 | 0 | 37 | 32.69642758 | -84.53351366 | 2020-05-29 02:32:50 | Talbot, Georgia, US |
2711680 | 2711680 | 2020-05-28 | US | Georgia | Taliaferro | 13265 | 1 | 0 | 0 | 1 | 33.56543317 | -82.88136816 | 2020-05-29 02:32:50 | Taliaferro, Georgia, US |
2711690 | 2711690 | 2020-05-28 | US | Georgia | Tattnall | 13267 | 20 | 0 | 0 | 20 | 32.04785085 | -82.05539188 | 2020-05-29 02:32:50 | Tattnall, Georgia, US |
2711692 | 2711692 | 2020-05-28 | US | Georgia | Taylor | 13269 | 22 | 2 | 0 | 20 | 32.55792548 | -84.25077141 | 2020-05-29 02:32:50 | Taylor, Georgia, US |
2711701 | 2711701 | 2020-05-28 | US | Georgia | Telfair | 13271 | 36 | 1 | 0 | 35 | 31.92829517 | -82.93491155 | 2020-05-29 02:32:50 | Telfair, Georgia, US |
2711705 | 2711705 | 2020-05-28 | US | Georgia | Terrell | 13273 | 213 | 26 | 0 | 187 | 31.77527543 | -84.44069698 | 2020-05-29 02:32:50 | Terrell, Georgia, US |
2711712 | 2711712 | 2020-05-28 | US | Georgia | Thomas | 13275 | 324 | 31 | 0 | 293 | 30.86392347 | -83.91847289 | 2020-05-29 02:32:50 | Thomas, Georgia, US |
2711716 | 2711716 | 2020-05-28 | US | Georgia | Tift | 13277 | 247 | 16 | 0 | 231 | 31.45743864 | -83.5236119 | 2020-05-29 02:32:50 | Tift, Georgia, US |
2711735 | 2711735 | 2020-05-28 | US | Georgia | Toombs | 13279 | 55 | 4 | 0 | 51 | 32.12059861 | -82.32957247 | 2020-05-29 02:32:50 | Toombs, Georgia, US |
2711737 | 2711737 | 2020-05-28 | US | Georgia | Towns | 13281 | 23 | 1 | 0 | 22 | 34.91369188 | -83.74107459999998 | 2020-05-29 02:32:50 | Towns, Georgia, US |
2711744 | 2711744 | 2020-05-28 | US | Georgia | Treutlen | 13283 | 8 | 0 | 0 | 8 | 32.40422134 | -82.56904553 | 2020-05-29 02:32:50 | Treutlen, Georgia, US |
2711751 | 2711751 | 2020-05-28 | US | Georgia | Troup | 13285 | 283 | 10 | 0 | 273 | 33.03349196 | -85.02812115 | 2020-05-29 02:32:50 | Troup, Georgia, US |
2711759 | 2711759 | 2020-05-28 | US | Georgia | Turner | 13287 | 114 | 12 | 0 | 102 | 31.71612656 | -83.62069378 | 2020-05-29 02:32:50 | Turner, Georgia, US |
2711764 | 2711764 | 2020-05-28 | US | Georgia | Twiggs | 13289 | 15 | 0 | 0 | 15 | 32.67435595 | -83.43078662 | 2020-05-29 02:32:50 | Twiggs, Georgia, US |
2711781 | 2711781 | 2020-05-28 | US | Georgia | Unassigned | 90013 | 1319 | 0 | 0 | 1319 | 34.91369188 | 0.0 | 2020-05-29 02:32:50 | Unassigned, Georgia, US |
2711825 | 2711825 | 2020-05-28 | US | Georgia | Union | 13291 | 43 | 1 | 0 | 42 | 34.82995757 | -83.98967069 | 2020-05-29 02:32:50 | Union, Georgia, US |
2711843 | 2711843 | 2020-05-28 | US | Georgia | Upson | 13293 | 280 | 34 | 0 | 246 | 32.87920671 | -84.30024826 | 2020-05-29 02:32:50 | Upson, Georgia, US |
2711883 | 2711883 | 2020-05-28 | US | Georgia | Walker | 13295 | 112 | 0 | 0 | 112 | 34.73376362 | -85.30165174 | 2020-05-29 02:32:50 | Walker, Georgia, US |
2711891 | 2711891 | 2020-05-28 | US | Georgia | Walton | 13297 | 246 | 12 | 0 | 234 | 33.78017694 | -83.73552314 | 2020-05-29 02:32:50 | Walton, Georgia, US |
2711897 | 2711897 | 2020-05-28 | US | Georgia | Ware | 13299 | 225 | 14 | 0 | 211 | 31.05449097 | -82.42224148 | 2020-05-29 02:32:50 | Ware, Georgia, US |
2711898 | 2711898 | 2020-05-28 | US | Georgia | Warren | 13301 | 18 | 0 | 0 | 18 | 33.41146451 | -82.67795848 | 2020-05-29 02:32:50 | Warren, Georgia, US |
2711922 | 2711922 | 2020-05-28 | US | Georgia | Washington | 13303 | 74 | 1 | 0 | 73 | 32.96711864 | -82.79357039 | 2020-05-29 02:32:50 | Washington, Georgia, US |
2711956 | 2711956 | 2020-05-28 | US | Georgia | Wayne | 13305 | 18 | 0 | 0 | 18 | 31.5521809 | -81.91894878 | 2020-05-29 02:32:50 | Wayne, Georgia, US |
2711974 | 2711974 | 2020-05-28 | US | Georgia | Webster | 13307 | 11 | 1 | 0 | 10 | 32.04066113 | -84.54742852 | 2020-05-29 02:32:50 | Webster, Georgia, US |
2711996 | 2711996 | 2020-05-28 | US | Georgia | Wheeler | 13309 | 13 | 0 | 0 | 13 | 32.12009104 | -82.72574721 | 2020-05-29 02:32:50 | Wheeler, Georgia, US |
2711999 | 2711999 | 2020-05-28 | US | Georgia | White | 13311 | 99 | 3 | 0 | 96 | 34.64624278 | -83.74905525 | 2020-05-29 02:32:50 | White, Georgia, US |
2712005 | 2712005 | 2020-05-28 | US | Georgia | Whitfield | 13313 | 322 | 7 | 0 | 315 | 34.80987459 | -84.96093476 | 2020-05-29 02:32:50 | Whitfield, Georgia, US |
2712013 | 2712013 | 2020-05-28 | US | Georgia | Wilcox | 13315 | 106 | 13 | 0 | 93 | 31.97496928 | -83.43438555 | 2020-05-29 02:32:50 | Wilcox, Georgia, US |
2712014 | 2712014 | 2020-05-28 | US | Georgia | Wilkes | 13317 | 33 | 1 | 0 | 32 | 33.78290391 | -82.74286107 | 2020-05-29 02:32:50 | Wilkes, Georgia, US |
2712017 | 2712017 | 2020-05-28 | US | Georgia | Wilkinson | 13319 | 68 | 4 | 0 | 64 | 32.80291082 | -83.17140684 | 2020-05-29 02:32:50 | Wilkinson, Georgia, US |
2712062 | 2712062 | 2020-05-28 | US | Georgia | Worth | 13321 | 208 | 21 | 0 | 187 | 31.55162306 | -83.85090513 | 2020-05-29 02:32:50 | Worth, 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]);