johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where "day" is on date 2020-05-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1403172 | 1403172 | 2020-05-14 | US | Georgia | Mitchell | 13205 | 387 | 32 | 0 | 355 | 31.22483255 | -84.19381821 | 2020-05-15 02:33:02 | Mitchell, Georgia, US |
1403188 | 1403188 | 2020-05-14 | US | Georgia | Monroe | 13207 | 45 | 4 | 0 | 41 | 33.014289 | -83.92097166 | 2020-05-15 02:33:02 | Monroe, Georgia, US |
1403207 | 1403207 | 2020-05-14 | US | Georgia | Montgomery | 13209 | 5 | 0 | 0 | 5 | 32.17201038 | -82.53527476 | 2020-05-15 02:33:02 | Montgomery, Georgia, US |
1403233 | 1403233 | 2020-05-14 | US | Georgia | Morgan | 13211 | 33 | 0 | 0 | 33 | 33.59232073 | -83.49129491 | 2020-05-15 02:33:02 | Morgan, Georgia, US |
1403256 | 1403256 | 2020-05-14 | US | Georgia | Murray | 13213 | 55 | 1 | 0 | 54 | 34.78897608 | -84.74993177 | 2020-05-15 02:33:02 | Murray, Georgia, US |
1403260 | 1403260 | 2020-05-14 | US | Georgia | Muscogee | 13215 | 411 | 15 | 0 | 396 | 32.50931999 | -84.87142262 | 2020-05-15 02:33:02 | Muscogee, Georgia, US |
1403296 | 1403296 | 2020-05-14 | US | Georgia | Newton | 13217 | 263 | 8 | 0 | 255 | 33.55514538 | -83.84547140000002 | 2020-05-15 02:33:02 | Newton, Georgia, US |
1403335 | 1403335 | 2020-05-14 | US | Georgia | Oconee | 13219 | 80 | 0 | 0 | 80 | 33.83749973 | -83.43679568 | 2020-05-15 02:33:02 | Oconee, Georgia, US |
1403341 | 1403341 | 2020-05-14 | US | Georgia | Oglethorpe | 13221 | 55 | 4 | 0 | 51 | 33.878629600000004 | -83.08278123 | 2020-05-15 02:33:02 | Oglethorpe, Georgia, US |
1403398 | 1403398 | 2020-05-14 | US | Georgia | Out of GA | 80013 | 1555 | 23 | 0 | 1532 | 34.91369188 | 0.0 | 2020-05-15 02:33:02 | Out of GA, Georgia, US |
1403431 | 1403431 | 2020-05-14 | US | Georgia | Paulding | 13223 | 236 | 10 | 0 | 226 | 33.91969522 | -84.86848792 | 2020-05-15 02:33:02 | Paulding, Georgia, US |
1403436 | 1403436 | 2020-05-14 | US | Georgia | Peach | 13225 | 69 | 2 | 0 | 67 | 32.56934316 | -83.82937 | 2020-05-15 02:33:02 | Peach, Georgia, US |
1403475 | 1403475 | 2020-05-14 | US | Georgia | Pickens | 13227 | 35 | 3 | 0 | 32 | 34.46589159 | -84.46406611 | 2020-05-15 02:33:02 | Pickens, Georgia, US |
1403478 | 1403478 | 2020-05-14 | US | Georgia | Pierce | 13229 | 69 | 4 | 0 | 65 | 31.35928155 | -82.21598442 | 2020-05-15 02:33:02 | Pierce, Georgia, US |
1403485 | 1403485 | 2020-05-14 | US | Georgia | Pike | 13231 | 44 | 2 | 0 | 42 | 33.09310242 | -84.38790389 | 2020-05-15 02:33:02 | Pike, Georgia, US |
1403518 | 1403518 | 2020-05-14 | US | Georgia | Polk | 13233 | 71 | 0 | 0 | 71 | 34.00267074 | -85.18677781 | 2020-05-15 02:33:02 | Polk, Georgia, US |
1403565 | 1403565 | 2020-05-14 | US | Georgia | Pulaski | 13235 | 38 | 1 | 0 | 37 | 32.23334561 | -83.47549959999998 | 2020-05-15 02:33:02 | Pulaski, Georgia, US |
1403573 | 1403573 | 2020-05-14 | US | Georgia | Putnam | 13237 | 60 | 6 | 0 | 54 | 33.32056115 | -83.37552891 | 2020-05-15 02:33:02 | Putnam, Georgia, US |
1403581 | 1403581 | 2020-05-14 | US | Georgia | Quitman | 13239 | 7 | 1 | 0 | 6 | 31.86728114 | -85.01773177 | 2020-05-15 02:33:02 | Quitman, Georgia, US |
1403583 | 1403583 | 2020-05-14 | US | Georgia | Rabun | 13241 | 14 | 1 | 0 | 13 | 34.88389445 | -83.40304637 | 2020-05-15 02:33:02 | Rabun, Georgia, US |
1403594 | 1403594 | 2020-05-14 | US | Georgia | Randolph | 13243 | 169 | 21 | 0 | 148 | 31.76622818 | -84.75732369 | 2020-05-15 02:33:02 | Randolph, Georgia, US |
1403630 | 1403630 | 2020-05-14 | US | Georgia | Richmond | 13245 | 480 | 17 | 0 | 463 | 33.35777107 | -82.07026432 | 2020-05-15 02:33:02 | Richmond, Georgia, US |
1403656 | 1403656 | 2020-05-14 | US | Georgia | Rockdale | 13247 | 249 | 8 | 0 | 241 | 33.65145002 | -84.02202167 | 2020-05-15 02:33:02 | Rockdale, Georgia, US |
1403735 | 1403735 | 2020-05-14 | US | Georgia | Schley | 13249 | 15 | 1 | 0 | 14 | 32.2654021 | -84.31258912 | 2020-05-15 02:33:02 | Schley, Georgia, US |
1403755 | 1403755 | 2020-05-14 | US | Georgia | Screven | 13251 | 18 | 1 | 0 | 17 | 32.74976524 | -81.60779441 | 2020-05-15 02:33:02 | Screven, Georgia, US |
1403761 | 1403761 | 2020-05-14 | US | Georgia | Seminole | 13253 | 38 | 2 | 0 | 36 | 30.93464824 | -84.86823924 | 2020-05-15 02:33:02 | Seminole, Georgia, US |
1403826 | 1403826 | 2020-05-14 | US | Georgia | Spalding | 13255 | 239 | 12 | 0 | 227 | 33.26310031 | -84.28013991 | 2020-05-15 02:33:02 | Spalding, Georgia, US |
1403875 | 1403875 | 2020-05-14 | US | Georgia | Stephens | 13257 | 94 | 1 | 0 | 93 | 34.55151201 | -83.29405315 | 2020-05-15 02:33:02 | Stephens, Georgia, US |
1403884 | 1403884 | 2020-05-14 | US | Georgia | Stewart | 13259 | 37 | 0 | 0 | 37 | 32.07996777 | -84.83208037 | 2020-05-15 02:33:02 | Stewart, Georgia, US |
1403915 | 1403915 | 2020-05-14 | US | Georgia | Sumter | 13261 | 412 | 38 | 0 | 374 | 32.03650571 | -84.19821492 | 2020-05-15 02:33:02 | Sumter, Georgia, US |
1403931 | 1403931 | 2020-05-14 | US | Georgia | Talbot | 13263 | 27 | 1 | 0 | 26 | 32.69642758 | -84.53351366 | 2020-05-15 02:33:02 | Talbot, Georgia, US |
1403933 | 1403933 | 2020-05-14 | US | Georgia | Taliaferro | 13265 | 1 | 0 | 0 | 1 | 33.56543317 | -82.88136816 | 2020-05-15 02:33:02 | Taliaferro, Georgia, US |
1403943 | 1403943 | 2020-05-14 | US | Georgia | Tattnall | 13267 | 11 | 0 | 0 | 11 | 32.04785085 | -82.05539188 | 2020-05-15 02:33:02 | Tattnall, Georgia, US |
1403945 | 1403945 | 2020-05-14 | US | Georgia | Taylor | 13269 | 22 | 2 | 0 | 20 | 32.55792548 | -84.25077141 | 2020-05-15 02:33:02 | Taylor, Georgia, US |
1403953 | 1403953 | 2020-05-14 | US | Georgia | Telfair | 13271 | 29 | 1 | 0 | 28 | 31.92829517 | -82.93491155 | 2020-05-15 02:33:02 | Telfair, Georgia, US |
1403957 | 1403957 | 2020-05-14 | US | Georgia | Terrell | 13273 | 199 | 24 | 0 | 175 | 31.77527543 | -84.44069698 | 2020-05-15 02:33:02 | Terrell, Georgia, US |
1403963 | 1403963 | 2020-05-14 | US | Georgia | Thomas | 13275 | 276 | 28 | 0 | 248 | 30.86392347 | -83.91847289 | 2020-05-15 02:33:02 | Thomas, Georgia, US |
1403967 | 1403967 | 2020-05-14 | US | Georgia | Tift | 13277 | 170 | 10 | 0 | 160 | 31.45743864 | -83.5236119 | 2020-05-15 02:33:02 | Tift, Georgia, US |
1403986 | 1403986 | 2020-05-14 | US | Georgia | Toombs | 13279 | 43 | 4 | 0 | 39 | 32.12059861 | -82.32957247 | 2020-05-15 02:33:02 | Toombs, Georgia, US |
1403988 | 1403988 | 2020-05-14 | US | Georgia | Towns | 13281 | 21 | 1 | 0 | 20 | 34.91369188 | -83.74107459999998 | 2020-05-15 02:33:02 | Towns, Georgia, US |
1403994 | 1403994 | 2020-05-14 | US | Georgia | Treutlen | 13283 | 7 | 0 | 0 | 7 | 32.40422134 | -82.56904553 | 2020-05-15 02:33:02 | Treutlen, Georgia, US |
1404001 | 1404001 | 2020-05-14 | US | Georgia | Troup | 13285 | 192 | 5 | 0 | 187 | 33.03349196 | -85.02812115 | 2020-05-15 02:33:02 | Troup, Georgia, US |
1404009 | 1404009 | 2020-05-14 | US | Georgia | Turner | 13287 | 81 | 12 | 0 | 69 | 31.71612656 | -83.62069378 | 2020-05-15 02:33:02 | Turner, Georgia, US |
1404014 | 1404014 | 2020-05-14 | US | Georgia | Twiggs | 13289 | 9 | 0 | 0 | 9 | 32.67435595 | -83.43078662 | 2020-05-15 02:33:02 | Twiggs, Georgia, US |
1404031 | 1404031 | 2020-05-14 | US | Georgia | Unassigned | 90013 | 1363 | 0 | 0 | 1363 | 34.91369188 | 0.0 | 2020-05-15 02:33:02 | Unassigned, Georgia, US |
1404075 | 1404075 | 2020-05-14 | US | Georgia | Union | 13291 | 36 | 1 | 0 | 35 | 34.82995757 | -83.98967069 | 2020-05-15 02:33:02 | Union, Georgia, US |
1404093 | 1404093 | 2020-05-14 | US | Georgia | Upson | 13293 | 255 | 27 | 0 | 228 | 32.87920671 | -84.30024826 | 2020-05-15 02:33:02 | Upson, Georgia, US |
1404133 | 1404133 | 2020-05-14 | US | Georgia | Walker | 13295 | 74 | 0 | 0 | 74 | 34.73376362 | -85.30165174 | 2020-05-15 02:33:02 | Walker, Georgia, US |
1404141 | 1404141 | 2020-05-14 | US | Georgia | Walton | 13297 | 158 | 7 | 0 | 151 | 33.78017694 | -83.73552314 | 2020-05-15 02:33:02 | Walton, Georgia, US |
1404146 | 1404146 | 2020-05-14 | US | Georgia | Ware | 13299 | 169 | 12 | 0 | 157 | 31.05449097 | -82.42224148 | 2020-05-15 02:33:02 | Ware, Georgia, US |
1404147 | 1404147 | 2020-05-14 | US | Georgia | Warren | 13301 | 16 | 0 | 0 | 16 | 33.41146451 | -82.67795848 | 2020-05-15 02:33:02 | Warren, Georgia, US |
1404171 | 1404171 | 2020-05-14 | US | Georgia | Washington | 13303 | 63 | 1 | 0 | 62 | 32.96711864 | -82.79357039 | 2020-05-15 02:33:02 | Washington, Georgia, US |
1404205 | 1404205 | 2020-05-14 | US | Georgia | Wayne | 13305 | 14 | 0 | 0 | 14 | 31.5521809 | -81.91894878 | 2020-05-15 02:33:02 | Wayne, Georgia, US |
1404223 | 1404223 | 2020-05-14 | US | Georgia | Webster | 13307 | 11 | 1 | 0 | 10 | 32.04066113 | -84.54742852 | 2020-05-15 02:33:02 | Webster, Georgia, US |
1404244 | 1404244 | 2020-05-14 | US | Georgia | Wheeler | 13309 | 9 | 0 | 0 | 9 | 32.12009104 | -82.72574721 | 2020-05-15 02:33:02 | Wheeler, Georgia, US |
1404247 | 1404247 | 2020-05-14 | US | Georgia | White | 13311 | 88 | 2 | 0 | 86 | 34.64624278 | -83.74905525 | 2020-05-15 02:33:02 | White, Georgia, US |
1404253 | 1404253 | 2020-05-14 | US | Georgia | Whitfield | 13313 | 175 | 6 | 0 | 169 | 34.80987459 | -84.96093476 | 2020-05-15 02:33:02 | Whitfield, Georgia, US |
1404261 | 1404261 | 2020-05-14 | US | Georgia | Wilcox | 13315 | 98 | 12 | 0 | 86 | 31.97496928 | -83.43438555 | 2020-05-15 02:33:02 | Wilcox, Georgia, US |
1404262 | 1404262 | 2020-05-14 | US | Georgia | Wilkes | 13317 | 28 | 1 | 0 | 27 | 33.78290391 | -82.74286107 | 2020-05-15 02:33:02 | Wilkes, Georgia, US |
1404265 | 1404265 | 2020-05-14 | US | Georgia | Wilkinson | 13319 | 40 | 3 | 0 | 37 | 32.80291082 | -83.17140684 | 2020-05-15 02:33:02 | Wilkinson, Georgia, US |
1404309 | 1404309 | 2020-05-14 | US | Georgia | Worth | 13321 | 191 | 17 | 0 | 174 | 31.55162306 | -83.85090513 | 2020-05-15 02:33:02 | 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]);