ny_times_us_counties

Table actions
⚠️ 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 license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

92,569 rows where state = "Georgia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Georgia · 92,569 ✖
Link rowid date ▲ county state fips cases deaths
1842998 1842998 2021-10-23 Appling Georgia 13001 3488 103
1842999 1842999 2021-10-23 Atkinson Georgia 13003 1578 34
1843000 1843000 2021-10-23 Bacon Georgia 13005 2516 58
1843001 1843001 2021-10-23 Baker Georgia 13007 368 14
1843002 1843002 2021-10-23 Baldwin Georgia 13009 6660 184
1843003 1843003 2021-10-23 Banks Georgia 13011 2740 60
1843004 1843004 2021-10-23 Barrow Georgia 13013 14644 193
1843005 1843005 2021-10-23 Bartow Georgia 13015 20429 338
1843006 1843006 2021-10-23 Ben Hill Georgia 13017 3221 101
1843007 1843007 2021-10-23 Berrien Georgia 13019 3468 63
1843008 1843008 2021-10-23 Bibb Georgia 13021 25351 615
1843009 1843009 2021-10-23 Bleckley Georgia 13023 2319 73
1843010 1843010 2021-10-23 Brantley Georgia 13025 3109 84
1843011 1843011 2021-10-23 Brooks Georgia 13027 2408 69
1843012 1843012 2021-10-23 Bryan Georgia 13029 6281 66
1843013 1843013 2021-10-23 Bulloch Georgia 13031 11151 193
1843014 1843014 2021-10-23 Burke Georgia 13033 3737 83
1843015 1843015 2021-10-23 Butts Georgia 13035 4651 111
1843016 1843016 2021-10-23 Calhoun Georgia 13037 841 21
1843017 1843017 2021-10-23 Camden Georgia 13039 7933 92
1843018 1843018 2021-10-23 Candler Georgia 13043 1570 86
1843019 1843019 2021-10-23 Carroll Georgia 13045 16350 301
1843020 1843020 2021-10-23 Catoosa Georgia 13047 9507 105
1843021 1843021 2021-10-23 Charlton Georgia 13049 2291 54
1843022 1843022 2021-10-23 Chatham Georgia 13051 38493 676
1843023 1843023 2021-10-23 Chattahoochee Georgia 13053 5859 19
1843024 1843024 2021-10-23 Chattooga Georgia 13055 4561 103
1843025 1843025 2021-10-23 Cherokee Georgia 13057 43435 446
1843026 1843026 2021-10-23 Clarke Georgia 13059 19973 174
1843027 1843027 2021-10-23 Clay Georgia 13061 314 4
1843028 1843028 2021-10-23 Clayton Georgia 13063 39088 705
1843029 1843029 2021-10-23 Clinch Georgia 13065 1486 35
1843030 1843030 2021-10-23 Cobb Georgia 13067 108881 1366
1843031 1843031 2021-10-23 Coffee Georgia 13069 7928 222
1843032 1843032 2021-10-23 Colquitt Georgia 13071 7618 179
1843033 1843033 2021-10-23 Columbia Georgia 13073 24738 288
1843034 1843034 2021-10-23 Cook Georgia 13075 3588 60
1843035 1843035 2021-10-23 Coweta Georgia 13077 20719 353
1843036 1843036 2021-10-23 Crawford Georgia 13079 1130 42
1843037 1843037 2021-10-23 Crisp Georgia 13081 3142 108
1843038 1843038 2021-10-23 Dade Georgia 13083 2156 20
1843039 1843039 2021-10-23 Dawson Georgia 13085 4680 68
1843040 1843040 2021-10-23 DeKalb Georgia 13089 91721 1298
1843041 1843041 2021-10-23 Decatur Georgia 13087 4776 97
1843042 1843042 2021-10-23 Dodge Georgia 13091 3602 125
1843043 1843043 2021-10-23 Dooly Georgia 13093 1645 58
1843044 1843044 2021-10-23 Dougherty Georgia 13095 12413 407
1843045 1843045 2021-10-23 Douglas Georgia 13097 22210 285
1843046 1843046 2021-10-23 Early Georgia 13099 1875 57
1843047 1843047 2021-10-23 Echols Georgia 13101 720 11
1843048 1843048 2021-10-23 Effingham Georgia 13103 8845 162
1843049 1843049 2021-10-23 Elbert Georgia 13105 3231 85
1843050 1843050 2021-10-23 Emanuel Georgia 13107 4413 123
1843051 1843051 2021-10-23 Evans Georgia 13109 1615 52
1843052 1843052 2021-10-23 Fannin Georgia 13111 3752 103
1843053 1843053 2021-10-23 Fayette Georgia 13113 13086 227
1843054 1843054 2021-10-23 Floyd Georgia 13115 18311 364
1843055 1843055 2021-10-23 Forsyth Georgia 13117 34099 267
1843056 1843056 2021-10-23 Franklin Georgia 13119 3955 80
1843057 1843057 2021-10-23 Fulton Georgia 13121 131590 1741
1843058 1843058 2021-10-23 Gilmer Georgia 13123 4650 133
1843059 1843059 2021-10-23 Glascock Georgia 13125 416 20
1843060 1843060 2021-10-23 Glynn Georgia 13127 15320 334
1843061 1843061 2021-10-23 Gordon Georgia 13129 11312 192
1843062 1843062 2021-10-23 Grady Georgia 13131 3626 88
1843063 1843063 2021-10-23 Greene Georgia 13133 2694 70
1843064 1843064 2021-10-23 Gwinnett Georgia 13135 132471 1436
1843065 1843065 2021-10-23 Habersham Georgia 13137 7482 198
1843066 1843066 2021-10-23 Hall Georgia 13139 38027 630
1843067 1843067 2021-10-23 Hancock Georgia 13141 1124 80
1843068 1843068 2021-10-23 Haralson Georgia 13143 3800 115
1843069 1843069 2021-10-23 Harris Georgia 13145 3732 86
1843070 1843070 2021-10-23 Hart Georgia 13147 3532 65
1843071 1843071 2021-10-23 Heard Georgia 13149 1467 36
1843072 1843072 2021-10-23 Henry Georgia 13151 37907 491
1843073 1843073 2021-10-23 Houston Georgia 13153 24820 374
1843074 1843074 2021-10-23 Irwin Georgia 13155 1437 39
1843075 1843075 2021-10-23 Jackson Georgia 13157 14703 207
1843076 1843076 2021-10-23 Jasper Georgia 13159 2123 58
1843077 1843077 2021-10-23 Jeff Davis Georgia 13161 2944 56
1843078 1843078 2021-10-23 Jefferson Georgia 13163 2678 86
1843079 1843079 2021-10-23 Jenkins Georgia 13165 1188 55
1843080 1843080 2021-10-23 Johnson Georgia 13167 1552 61
1843081 1843081 2021-10-23 Jones Georgia 13169 3415 91
1843082 1843082 2021-10-23 Lamar Georgia 13171 3393 89
1843083 1843083 2021-10-23 Lanier Georgia 13173 1473 16
1843084 1843084 2021-10-23 Laurens Georgia 13175 9091 237
1843085 1843085 2021-10-23 Lee Georgia 13177 4701 79
1843086 1843086 2021-10-23 Liberty Georgia 13179 7498 111
1843087 1843087 2021-10-23 Lincoln Georgia 13181 1182 32
1843088 1843088 2021-10-23 Long Georgia 13183 1749 25
1843089 1843089 2021-10-23 Lowndes Georgia 13185 21154 306
1843090 1843090 2021-10-23 Lumpkin Georgia 13187 4827 102
1843091 1843091 2021-10-23 Macon Georgia 13193 1320 42
1843092 1843092 2021-10-23 Madison Georgia 13195 4955 74
1843093 1843093 2021-10-23 Marion Georgia 13197 961 36
1843094 1843094 2021-10-23 McDuffie Georgia 13189 3505 73
1843095 1843095 2021-10-23 McIntosh Georgia 13191 1707 30
1843096 1843096 2021-10-23 Meriwether Georgia 13199 2958 109
1843097 1843097 2021-10-23 Miller Georgia 13201 1214 22

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);