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

124,889 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 >30

county >30

state 1

  • Georgia · 124,889 ✖
Link rowid date ▲ county state fips cases deaths
2499966 2499966 2022-05-13 Appling Georgia 13001 4833 128
2499967 2499967 2022-05-13 Atkinson Georgia 13003 2200 50
2499968 2499968 2022-05-13 Bacon Georgia 13005 3692 78
2499969 2499969 2022-05-13 Baker Georgia 13007 536 15
2499970 2499970 2022-05-13 Baldwin Georgia 13009 9574 240
2499971 2499971 2022-05-13 Banks Georgia 13011 3990 94
2499972 2499972 2022-05-13 Barrow Georgia 13013 21998 256
2499973 2499973 2022-05-13 Bartow Georgia 13015 29577 447
2499974 2499974 2022-05-13 Ben Hill Georgia 13017 4344 122
2499975 2499975 2022-05-13 Berrien Georgia 13019 4955 83
2499976 2499976 2022-05-13 Bibb Georgia 13021 37615 788
2499977 2499977 2022-05-13 Bleckley Georgia 13023 3353 100
2499978 2499978 2022-05-13 Brantley Georgia 13025 4168 109
2499979 2499979 2022-05-13 Brooks Georgia 13027 3430 86
2499980 2499980 2022-05-13 Bryan Georgia 13029 9218 91
2499981 2499981 2022-05-13 Bulloch Georgia 13031 15429 264
2499982 2499982 2022-05-13 Burke Georgia 13033 5315 110
2499983 2499983 2022-05-13 Butts Georgia 13035 6556 157
2499984 2499984 2022-05-13 Calhoun Georgia 13037 1364 22
2499985 2499985 2022-05-13 Camden Georgia 13039 11467 120
2499986 2499986 2022-05-13 Candler Georgia 13043 2194 96
2499987 2499987 2022-05-13 Carroll Georgia 13045 23863 460
2499988 2499988 2022-05-13 Catoosa Georgia 13047 14833 168
2499989 2499989 2022-05-13 Charlton Georgia 13049 3067 62
2499990 2499990 2022-05-13 Chatham Georgia 13051 64409 886
2499991 2499991 2022-05-13 Chattahoochee Georgia 13053 7486 22
2499992 2499992 2022-05-13 Chattooga Georgia 13055 6687 134
2499993 2499993 2022-05-13 Cherokee Georgia 13057 63811 630
2499994 2499994 2022-05-13 Clarke Georgia 13059 29898 232
2499995 2499995 2022-05-13 Clay Georgia 13061 533 6
2499996 2499996 2022-05-13 Clayton Georgia 13063 64612 977
2499997 2499997 2022-05-13 Clinch Georgia 13065 2124 42
2499998 2499998 2022-05-13 Cobb Georgia 13067 176832 1819
2499999 2499999 2022-05-13 Coffee Georgia 13069 10872 282
2500000 2500000 2022-05-13 Colquitt Georgia 13071 11752 246
2500001 2500001 2022-05-13 Columbia Georgia 13073 36344 390
2500002 2500002 2022-05-13 Cook Georgia 13075 4911 76
2500003 2500003 2022-05-13 Coweta Georgia 13077 33335 491
2500004 2500004 2022-05-13 Crawford Georgia 13079 1780 55
2500005 2500005 2022-05-13 Crisp Georgia 13081 4678 137
2500006 2500006 2022-05-13 Dade Georgia 13083 3393 29
2500007 2500007 2022-05-13 Dawson Georgia 13085 6964 101
2500008 2500008 2022-05-13 DeKalb Georgia 13089 153194 1746
2500009 2500009 2022-05-13 Decatur Georgia 13087 7269 131
2500010 2500010 2022-05-13 Dodge Georgia 13091 5244 154
2500011 2500011 2022-05-13 Dooly Georgia 13093 2383 69
2500012 2500012 2022-05-13 Dougherty Georgia 13095 19863 498
2500013 2500013 2022-05-13 Douglas Georgia 13097 35159 400
2500014 2500014 2022-05-13 Early Georgia 13099 2765 62
2500015 2500015 2022-05-13 Echols Georgia 13101 937 12
2500016 2500016 2022-05-13 Effingham Georgia 13103 13314 196
2500017 2500017 2022-05-13 Elbert Georgia 13105 4558 109
2500018 2500018 2022-05-13 Emanuel Georgia 13107 5924 160
2500019 2500019 2022-05-13 Evans Georgia 13109 2370 65
2500020 2500020 2022-05-13 Fannin Georgia 13111 5141 160
2500021 2500021 2022-05-13 Fayette Georgia 13113 22818 321
2500022 2500022 2022-05-13 Floyd Georgia 13115 27468 520
2500023 2500023 2022-05-13 Forsyth Georgia 13117 56197 401
2500024 2500024 2022-05-13 Franklin Georgia 13119 5414 104
2500025 2500025 2022-05-13 Fulton Georgia 13121 222488 2343
2500026 2500026 2022-05-13 Gilmer Georgia 13123 6960 178
2500027 2500027 2022-05-13 Glascock Georgia 13125 610 25
2500028 2500028 2022-05-13 Glynn Georgia 13127 23341 405
2500029 2500029 2022-05-13 Gordon Georgia 13129 16793 270
2500030 2500030 2022-05-13 Grady Georgia 13131 5795 113
2500031 2500031 2022-05-13 Greene Georgia 13133 3974 85
2500032 2500032 2022-05-13 Gwinnett Georgia 13135 210364 1886
2500033 2500033 2022-05-13 Habersham Georgia 13137 10192 264
2500034 2500034 2022-05-13 Hall Georgia 13139 54571 844
2500035 2500035 2022-05-13 Hancock Georgia 13141 1587 90
2500036 2500036 2022-05-13 Haralson Georgia 13143 5452 173
2500037 2500037 2022-05-13 Harris Georgia 13145 6095 113
2500038 2500038 2022-05-13 Hart Georgia 13147 4899 100
2500039 2500039 2022-05-13 Heard Georgia 13149 2181 54
2500040 2500040 2022-05-13 Henry Georgia 13151 58353 688
2500041 2500041 2022-05-13 Houston Georgia 13153 39773 500
2500042 2500042 2022-05-13 Irwin Georgia 13155 1926 51
2500043 2500043 2022-05-13 Jackson Georgia 13157 21247 291
2500044 2500044 2022-05-13 Jasper Georgia 13159 3155 73
2500045 2500045 2022-05-13 Jeff Davis Georgia 13161 3935 72
2500046 2500046 2022-05-13 Jefferson Georgia 13163 3668 113
2500047 2500047 2022-05-13 Jenkins Georgia 13165 1504 66
2500048 2500048 2022-05-13 Johnson Georgia 13167 2258 73
2500049 2500049 2022-05-13 Jones Georgia 13169 5080 109
2500050 2500050 2022-05-13 Lamar Georgia 13171 4864 113
2500051 2500051 2022-05-13 Lanier Georgia 13173 2277 25
2500052 2500052 2022-05-13 Laurens Georgia 13175 13827 299
2500053 2500053 2022-05-13 Lee Georgia 13177 7387 103
2500054 2500054 2022-05-13 Liberty Georgia 13179 12434 149
2500055 2500055 2022-05-13 Lincoln Georgia 13181 1601 35
2500056 2500056 2022-05-13 Long Georgia 13183 2801 35
2500057 2500057 2022-05-13 Lowndes Georgia 13185 31175 392
2500058 2500058 2022-05-13 Lumpkin Georgia 13187 7258 132
2500059 2500059 2022-05-13 Macon Georgia 13193 2151 50
2500060 2500060 2022-05-13 Madison Georgia 13195 6950 110
2500061 2500061 2022-05-13 Marion Georgia 13197 1520 50
2500062 2500062 2022-05-13 McDuffie Georgia 13189 5082 98
2500063 2500063 2022-05-13 McIntosh Georgia 13191 2469 37
2500064 2500064 2022-05-13 Meriwether Georgia 13199 4487 145
2500065 2500065 2022-05-13 Miller Georgia 13201 1723 30

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);