johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

22,367 rows where province_or_state = "Georgia" sorted by day descending

View and edit SQL

province_or_state

  • Georgia · 22,367

country_or_region

  • US 22,367
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391163 2020-08-08 US Georgia Appling 13001 645 19 0 626 31.74847232 -82.28909114 2020-08-09 04:34:54 Appling, Georgia, US
391190 2020-08-08 US Georgia Atkinson 13003 317 2 0 315 31.29633502 -82.87545866 2020-08-09 04:34:54 Atkinson, Georgia, US
391204 2020-08-08 US Georgia Bacon 13005 433 7 0 426 31.55456473 -82.45936528 2020-08-09 04:34:54 Bacon, Georgia, US
391207 2020-08-08 US Georgia Baker 13007 63 3 0 60 31.32669878 -84.44218806 2020-08-09 04:34:54 Baker, Georgia, US
391210 2020-08-08 US Georgia Baldwin 13009 1035 39 0 996 33.06882326 -83.24701748 2020-08-09 04:34:54 Baldwin, Georgia, US
391216 2020-08-08 US Georgia Banks 13011 270 4 0 266 34.35607081 -83.49644388 2020-08-09 04:34:54 Banks, Georgia, US
391230 2020-08-08 US Georgia Barrow 13013 1278 32 0 1246 33.99148694 -83.71436292 2020-08-09 04:34:54 Barrow, Georgia, US
391236 2020-08-08 US Georgia Bartow 13015 1853 62 0 1791 34.23732119 -84.83887523 2020-08-09 04:34:54 Bartow, Georgia, US
391267 2020-08-08 US Georgia Ben Hill 13017 416 3 0 413 31.76095874 -83.22145359 2020-08-09 04:34:54 Ben Hill, Georgia, US
391289 2020-08-08 US Georgia Berrien 13019 289 0 0 289 31.27590016 -83.22529920000002 2020-08-09 04:34:54 Berrien, Georgia, US
391295 2020-08-08 US Georgia Bibb 13021 3554 68 0 3486 32.80904227 -83.70489165 2020-08-09 04:34:54 Bibb, Georgia, US
391312 2020-08-08 US Georgia Bleckley 13023 184 7 0 177 32.43829035 -83.33035166 2020-08-09 04:34:54 Bleckley, Georgia, US
391353 2020-08-08 US Georgia Brantley 13025 244 5 0 239 31.19576557 -81.97743999 2020-08-09 04:34:54 Brantley, Georgia, US
391370 2020-08-08 US Georgia Brooks 13027 408 18 0 390 30.83922642 -83.58303423 2020-08-09 04:34:54 Brooks, Georgia, US
391387 2020-08-08 US Georgia Bryan 13029 651 8 0 643 32.00979311 -81.44002948 2020-08-09 04:34:54 Bryan, Georgia, US
391400 2020-08-08 US Georgia Bulloch 13031 1242 14 0 1228 32.39577406 -81.74811421 2020-08-09 04:34:54 Bulloch, Georgia, US
391404 2020-08-08 US Georgia Burke 13033 462 7 0 455 33.05917989 -81.99928721 2020-08-09 04:34:54 Burke, Georgia, US
391423 2020-08-08 US Georgia Butts 13035 487 37 0 450 33.283094500000004 -83.95435040000002 2020-08-09 04:34:54 Butts, Georgia, US
391441 2020-08-08 US Georgia Calhoun 13037 203 6 0 197 31.53169785 -84.62725131 2020-08-09 04:34:54 Calhoun, Georgia, US
391456 2020-08-08 US Georgia Camden 13039 730 5 0 725 30.92951916 -81.66601818 2020-08-09 04:34:54 Camden, Georgia, US
391471 2020-08-08 US Georgia Candler 13043 252 4 0 248 32.40209349 -82.07702563 2020-08-09 04:34:54 Candler, Georgia, US
391487 2020-08-08 US Georgia Carroll 13045 1862 49 0 1813 33.58138199 -85.07976677 2020-08-09 04:34:54 Carroll, Georgia, US
391524 2020-08-08 US Georgia Catoosa 13047 631 9 0 622 34.89872298 -85.13757014 2020-08-09 04:34:54 Catoosa, Georgia, US
391552 2020-08-08 US Georgia Charlton 13049 417 3 0 414 30.78371028 -82.13951596 2020-08-09 04:34:54 Charlton, Georgia, US
391555 2020-08-08 US Georgia Chatham 13051 5665 75 0 5590 32.00043026 -81.12489526 2020-08-09 04:34:54 Chatham, Georgia, US
391557 2020-08-08 US Georgia Chattahoochee 13053 759 1 0 758 32.34341231 -84.78809239 2020-08-09 04:34:54 Chattahoochee, Georgia, US
391558 2020-08-08 US Georgia Chattooga 13055 255 3 0 252 34.47197698 -85.34535662 2020-08-09 04:34:54 Chattooga, Georgia, US
391568 2020-08-08 US Georgia Cherokee 13057 3398 63 0 3335 34.24393976 -84.47431861 2020-08-09 04:34:54 Cherokee, Georgia, US
391631 2020-08-08 US Georgia Clarke 13059 2027 18 0 2009 33.95436462 -83.37124007 2020-08-09 04:34:54 Clarke, Georgia, US
391639 2020-08-08 US Georgia Clay 13061 86 2 0 84 31.62221166 -84.97713865 2020-08-09 04:34:54 Clay, Georgia, US
391654 2020-08-08 US Georgia Clayton 13063 4952 110 0 4842 33.54187245 -84.35594188 2020-08-09 04:34:54 Clayton, Georgia, US
391666 2020-08-08 US Georgia Clinch 13065 192 4 0 188 30.91395822 -82.70432472 2020-08-09 04:34:54 Clinch, Georgia, US
391680 2020-08-08 US Georgia Cobb 13067 13336 319 0 13017 33.94243204 -84.5761255 2020-08-09 04:34:54 Cobb, Georgia, US
391687 2020-08-08 US Georgia Coffee 13069 1447 28 0 1419 31.54892966 -82.85492059999999 2020-08-09 04:34:54 Coffee, Georgia, US
391703 2020-08-08 US Georgia Colquitt 13071 1537 23 0 1514 31.18810588 -83.7677946 2020-08-09 04:34:54 Colquitt, Georgia, US
391706 2020-08-08 US Georgia Columbia 13073 2188 23 0 2165 33.54534185 -82.263524 2020-08-09 04:34:54 Columbia, Georgia, US
391727 2020-08-08 US Georgia Cook 13075 432 6 0 426 31.16068491 -83.42947229 2020-08-09 04:34:54 Cook, Georgia, US
391748 2020-08-08 US Georgia Coweta 13077 1485 22 0 1463 33.35334302 -84.76129976 2020-08-09 04:34:54 Coweta, Georgia, US
391757 2020-08-08 US Georgia Crawford 13079 102 0 0 102 32.71391813 -83.98061238 2020-08-09 04:34:54 Crawford, Georgia, US
391769 2020-08-08 US Georgia Crisp 13081 374 14 0 360 31.92289565 -83.76811843 2020-08-09 04:34:54 Crisp, Georgia, US
391803 2020-08-08 US Georgia Dade 13083 125 1 0 124 34.854916700000004 -85.50490424 2020-08-09 04:34:54 Dade, Georgia, US
391831 2020-08-08 US Georgia Dawson 13085 369 3 0 366 34.44244079 -84.16964071 2020-08-09 04:34:54 Dawson, Georgia, US
391840 2020-08-08 US Georgia DeKalb 13089 13752 237 0 13515 33.76944049 -84.22396017 2020-08-09 04:34:54 DeKalb, Georgia, US
391850 2020-08-08 US Georgia Decatur 13087 770 11 0 759 30.87967778 -84.57619536 2020-08-09 04:34:54 Decatur, Georgia, US
391894 2020-08-08 US Georgia Dodge 13091 210 3 0 207 32.17265114 -83.16948926 2020-08-09 04:34:54 Dodge, Georgia, US
391902 2020-08-08 US Georgia Dooly 13093 252 14 0 238 32.15630737 -83.79746561 2020-08-09 04:34:54 Dooly, Georgia, US
391907 2020-08-08 US Georgia Dougherty 13095 2684 170 0 2514 31.53328528 -84.21722377 2020-08-09 04:34:54 Dougherty, Georgia, US
391909 2020-08-08 US Georgia Douglas 13097 2602 51 0 2551 33.70291126 -84.77026156 2020-08-09 04:34:54 Douglas, Georgia, US
391936 2020-08-08 US Georgia Early 13099 359 32 0 327 31.32155345 -84.90255207 2020-08-09 04:34:54 Early, Georgia, US
391943 2020-08-08 US Georgia Echols 13101 221 2 0 219 30.71101099 -82.89687287 2020-08-09 04:34:54 Echols, Georgia, US
391955 2020-08-08 US Georgia Effingham 13103 719 2 0 717 32.36616021 -81.34280942 2020-08-09 04:34:54 Effingham, Georgia, US
391961 2020-08-08 US Georgia Elbert 13105 354 1 0 353 34.11302332 -82.83936148 2020-08-09 04:34:54 Elbert, Georgia, US
391973 2020-08-08 US Georgia Emanuel 13107 501 9 0 492 32.59221302 -82.30239915 2020-08-09 04:34:54 Emanuel, Georgia, US
391994 2020-08-08 US Georgia Evans 13109 249 1 0 248 32.15328841 -81.8870105 2020-08-09 04:34:54 Evans, Georgia, US
392006 2020-08-08 US Georgia Fannin 13111 329 3 0 326 34.86430205 -84.316964 2020-08-09 04:34:54 Fannin, Georgia, US
392013 2020-08-08 US Georgia Fayette 13113 1100 28 0 1072 33.41357794 -84.49089434 2020-08-09 04:34:54 Fayette, Georgia, US
392037 2020-08-08 US Georgia Floyd 13115 1488 17 0 1471 34.26268279 -85.21577392 2020-08-09 04:34:54 Floyd, Georgia, US
392051 2020-08-08 US Georgia Forsyth 13117 2224 22 0 2202 34.22604035 -84.12315129999998 2020-08-09 04:34:54 Forsyth, Georgia, US
392059 2020-08-08 US Georgia Franklin 13119 396 6 0 390 34.37525597 -83.23159927 2020-08-09 04:34:54 Franklin, Georgia, US
392095 2020-08-08 US Georgia Fulton 13121 20049 430 0 19619 33.79216944 -84.46319413 2020-08-09 04:34:54 Fulton, Georgia, US
392143 2020-08-08 US Georgia Gilmer 13123 616 4 0 612 34.69316688 -84.45802506 2020-08-09 04:34:54 Gilmer, Georgia, US
392149 2020-08-08 US Georgia Glascock 13125 24 0 0 24 33.22879932 -82.61297636 2020-08-09 04:34:54 Glascock, Georgia, US
392154 2020-08-08 US Georgia Glynn 13127 2487 47 0 2440 31.23279254 -81.53811412 2020-08-09 04:34:54 Glynn, Georgia, US
392163 2020-08-08 US Georgia Gordon 13129 1171 23 0 1148 34.50487351 -84.87296253 2020-08-09 04:34:54 Gordon, Georgia, US
392167 2020-08-08 US Georgia Grady 13131 476 5 0 471 30.87454847 -84.23418364 2020-08-09 04:34:54 Grady, Georgia, US
392211 2020-08-08 US Georgia Greene 13133 308 12 0 296 33.5769205 -83.17139104 2020-08-09 04:34:54 Greene, Georgia, US
392251 2020-08-08 US Georgia Gwinnett 13135 19548 260 0 19288 33.96044201 -84.02137802 2020-08-09 04:34:54 Gwinnett, Georgia, US
392253 2020-08-08 US Georgia Habersham 13137 1135 49 0 1086 34.63331566 -83.53094677 2020-08-09 04:34:54 Habersham, Georgia, US
392259 2020-08-08 US Georgia Hall 13139 6035 91 0 5944 34.32207823 -83.81896936 2020-08-09 04:34:54 Hall, Georgia, US
392279 2020-08-08 US Georgia Hancock 13141 315 35 0 280 33.2721566 -82.99766919 2020-08-09 04:34:54 Hancock, Georgia, US
392293 2020-08-08 US Georgia Haralson 13143 208 6 0 202 33.79602175 -85.21005667 2020-08-09 04:34:54 Haralson, Georgia, US
392313 2020-08-08 US Georgia Harris 13145 652 17 0 635 32.73709786 -84.90538572 2020-08-09 04:34:54 Harris, Georgia, US
392324 2020-08-08 US Georgia Hart 13147 300 7 0 293 34.34626973 -82.96567682 2020-08-09 04:34:54 Hart, Georgia, US
392339 2020-08-08 US Georgia Heard 13149 142 4 0 138 33.29686567 -85.12886832 2020-08-09 04:34:54 Heard, Georgia, US
392352 2020-08-08 US Georgia Henry 13151 3320 47 0 3273 33.4533428 -84.14814659999998 2020-08-09 04:34:54 Henry, Georgia, US
392403 2020-08-08 US Georgia Houston 13153 1948 58 0 1890 32.45802497 -83.66879087 2020-08-09 04:34:54 Houston, Georgia, US
392457 2020-08-08 US Georgia Irwin 13155 166 1 0 165 31.60213036 -83.27501387 2020-08-09 04:34:54 Irwin, Georgia, US
392472 2020-08-08 US Georgia Jackson 13157 1059 16 0 1043 34.13794553 -83.56814788 2020-08-09 04:34:54 Jackson, Georgia, US
392493 2020-08-08 US Georgia Jasper 13159 161 1 0 160 33.31535543 -83.68844964 2020-08-09 04:34:54 Jasper, Georgia, US
392503 2020-08-08 US Georgia Jeff Davis 13161 436 8 0 428 31.80405727 -82.63724870000001 2020-08-09 04:34:54 Jeff Davis, Georgia, US
392509 2020-08-08 US Georgia Jefferson 13163 485 7 0 478 33.05867328 -82.41609057 2020-08-09 04:34:54 Jefferson, Georgia, US
392533 2020-08-08 US Georgia Jenkins 13165 243 24 0 219 32.79248718 -81.96040187 2020-08-09 04:34:54 Jenkins, Georgia, US
392544 2020-08-08 US Georgia Johnson 13167 240 11 0 229 32.70211082 -82.66166794 2020-08-09 04:34:54 Johnson, Georgia, US
392557 2020-08-08 US Georgia Jones 13169 302 3 0 299 33.02512137 -83.56019163 2020-08-09 04:34:54 Jones, Georgia, US
392679 2020-08-08 US Georgia Lamar 13171 273 12 0 261 33.07841647 -84.14263877 2020-08-09 04:34:54 Lamar, Georgia, US
392693 2020-08-08 US Georgia Lanier 13173 219 4 0 215 31.03828570000001 -83.06472457 2020-08-09 04:34:54 Lanier, Georgia, US
392709 2020-08-08 US Georgia Laurens 13175 886 8 0 878 32.46325233 -82.92221316 2020-08-09 04:34:54 Laurens, Georgia, US
392732 2020-08-08 US Georgia Lee 13177 535 22 0 513 31.779330600000005 -84.14324253 2020-08-09 04:34:54 Lee, Georgia, US
392762 2020-08-08 US Georgia Liberty 13179 713 3 0 710 31.82588896 -81.49251135 2020-08-09 04:34:54 Liberty, Georgia, US
392770 2020-08-08 US Georgia Lincoln 13181 137 4 0 133 33.79201475 -82.45024131 2020-08-09 04:34:54 Lincoln, Georgia, US
392818 2020-08-08 US Georgia Long 13183 123 1 0 122 31.75218791 -81.74952375 2020-08-09 04:34:54 Long, Georgia, US
392831 2020-08-08 US Georgia Lowndes 13185 3156 44 0 3112 30.83568832 -83.27056716 2020-08-09 04:34:54 Lowndes, Georgia, US
392837 2020-08-08 US Georgia Lumpkin 13187 339 6 0 333 34.57286511 -84.00425681 2020-08-09 04:34:54 Lumpkin, Georgia, US
392854 2020-08-08 US Georgia Macon 13193 177 10 0 167 32.35207048 -84.04234127 2020-08-09 04:34:54 Macon, Georgia, US
392864 2020-08-08 US Georgia Madison 13195 392 6 0 386 34.12920917 -83.21218732 2020-08-09 04:34:54 Madison, Georgia, US
392903 2020-08-08 US Georgia Marion 13197 150 5 0 145 32.3483402 -84.52733571 2020-08-09 04:34:54 Marion, Georgia, US
392968 2020-08-08 US Georgia McDuffie 13189 338 10 0 328 33.47851918 -82.48252774 2020-08-09 04:34:54 McDuffie, Georgia, US
392971 2020-08-08 US Georgia McIntosh 13191 174 2 0 172 31.49683595 -81.40163426 2020-08-09 04:34:54 McIntosh, Georgia, US
393016 2020-08-08 US Georgia Meriwether 13199 384 6 0 378 33.04163534 -84.68859732 2020-08-09 04:34:54 Meriwether, Georgia, US
393036 2020-08-08 US Georgia Miller 13201 142 0 0 142 31.16568912 -84.73151117 2020-08-09 04:34:54 Miller, Georgia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);
Powered by Datasette · Query took 2608.04ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette