ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where "date" is on date 2021-09-30 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1768267 | 1768267 | 2021-09-30 | Appling | Georgia | 13001 | 3414 | 90 |
1768268 | 1768268 | 2021-09-30 | Atkinson | Georgia | 13003 | 1520 | 28 |
1768269 | 1768269 | 2021-09-30 | Bacon | Georgia | 13005 | 2452 | 52 |
1768270 | 1768270 | 2021-09-30 | Baker | Georgia | 13007 | 362 | 14 |
1768271 | 1768271 | 2021-09-30 | Baldwin | Georgia | 13009 | 6527 | 169 |
1768272 | 1768272 | 2021-09-30 | Banks | Georgia | 13011 | 2658 | 56 |
1768273 | 1768273 | 2021-09-30 | Barrow | Georgia | 13013 | 14128 | 176 |
1768274 | 1768274 | 2021-09-30 | Bartow | Georgia | 13015 | 19861 | 311 |
1768275 | 1768275 | 2021-09-30 | Ben Hill | Georgia | 13017 | 3172 | 94 |
1768276 | 1768276 | 2021-09-30 | Berrien | Georgia | 13019 | 3412 | 59 |
1768277 | 1768277 | 2021-09-30 | Bibb | Georgia | 13021 | 24711 | 572 |
1768278 | 1768278 | 2021-09-30 | Bleckley | Georgia | 13023 | 2276 | 65 |
1768279 | 1768279 | 2021-09-30 | Brantley | Georgia | 13025 | 3087 | 75 |
1768280 | 1768280 | 2021-09-30 | Brooks | Georgia | 13027 | 2377 | 62 |
1768281 | 1768281 | 2021-09-30 | Bryan | Georgia | 13029 | 6213 | 56 |
1768282 | 1768282 | 2021-09-30 | Bulloch | Georgia | 13031 | 11070 | 173 |
1768283 | 1768283 | 2021-09-30 | Burke | Georgia | 13033 | 3675 | 73 |
1768284 | 1768284 | 2021-09-30 | Butts | Georgia | 13035 | 4491 | 98 |
1768285 | 1768285 | 2021-09-30 | Calhoun | Georgia | 13037 | 836 | 20 |
1768286 | 1768286 | 2021-09-30 | Camden | Georgia | 13039 | 7689 | 85 |
1768287 | 1768287 | 2021-09-30 | Candler | Georgia | 13043 | 1558 | 80 |
1768288 | 1768288 | 2021-09-30 | Carroll | Georgia | 13045 | 16028 | 285 |
1768289 | 1768289 | 2021-09-30 | Catoosa | Georgia | 13047 | 9146 | 92 |
1768290 | 1768290 | 2021-09-30 | Charlton | Georgia | 13049 | 2187 | 52 |
1768291 | 1768291 | 2021-09-30 | Chatham | Georgia | 13051 | 37692 | 604 |
1768292 | 1768292 | 2021-09-30 | Chattahoochee | Georgia | 13053 | 5435 | 17 |
1768293 | 1768293 | 2021-09-30 | Chattooga | Georgia | 13055 | 4388 | 91 |
1768294 | 1768294 | 2021-09-30 | Cherokee | Georgia | 13057 | 42444 | 409 |
1768295 | 1768295 | 2021-09-30 | Clarke | Georgia | 13059 | 19580 | 166 |
1768296 | 1768296 | 2021-09-30 | Clay | Georgia | 13061 | 313 | 4 |
1768297 | 1768297 | 2021-09-30 | Clayton | Georgia | 13063 | 37945 | 642 |
1768298 | 1768298 | 2021-09-30 | Clinch | Georgia | 13065 | 1447 | 33 |
1768299 | 1768299 | 2021-09-30 | Cobb | Georgia | 13067 | 105670 | 1274 |
1768300 | 1768300 | 2021-09-30 | Coffee | Georgia | 13069 | 7685 | 205 |
1768301 | 1768301 | 2021-09-30 | Colquitt | Georgia | 13071 | 7420 | 167 |
1768302 | 1768302 | 2021-09-30 | Columbia | Georgia | 13073 | 24105 | 260 |
1768303 | 1768303 | 2021-09-30 | Cook | Georgia | 13075 | 3555 | 54 |
1768304 | 1768304 | 2021-09-30 | Coweta | Georgia | 13077 | 20155 | 303 |
1768305 | 1768305 | 2021-09-30 | Crawford | Georgia | 13079 | 1093 | 37 |
1768306 | 1768306 | 2021-09-30 | Crisp | Georgia | 13081 | 3083 | 105 |
1768307 | 1768307 | 2021-09-30 | Dade | Georgia | 13083 | 2083 | 17 |
1768308 | 1768308 | 2021-09-30 | Dawson | Georgia | 13085 | 4547 | 59 |
1768309 | 1768309 | 2021-09-30 | DeKalb | Georgia | 13089 | 88488 | 1206 |
1768310 | 1768310 | 2021-09-30 | Decatur | Georgia | 13087 | 4622 | 92 |
1768311 | 1768311 | 2021-09-30 | Dodge | Georgia | 13091 | 3538 | 118 |
1768312 | 1768312 | 2021-09-30 | Dooly | Georgia | 13093 | 1606 | 53 |
1768313 | 1768313 | 2021-09-30 | Dougherty | Georgia | 13095 | 11956 | 374 |
1768314 | 1768314 | 2021-09-30 | Douglas | Georgia | 13097 | 21526 | 264 |
1768315 | 1768315 | 2021-09-30 | Early | Georgia | 13099 | 1810 | 56 |
1768316 | 1768316 | 2021-09-30 | Echols | Georgia | 13101 | 710 | 9 |
1768317 | 1768317 | 2021-09-30 | Effingham | Georgia | 13103 | 8778 | 140 |
1768318 | 1768318 | 2021-09-30 | Elbert | Georgia | 13105 | 3122 | 81 |
1768319 | 1768319 | 2021-09-30 | Emanuel | Georgia | 13107 | 4319 | 103 |
1768320 | 1768320 | 2021-09-30 | Evans | Georgia | 13109 | 1594 | 45 |
1768321 | 1768321 | 2021-09-30 | Fannin | Georgia | 13111 | 3616 | 98 |
1768322 | 1768322 | 2021-09-30 | Fayette | Georgia | 13113 | 12739 | 208 |
1768323 | 1768323 | 2021-09-30 | Floyd | Georgia | 13115 | 17737 | 315 |
1768324 | 1768324 | 2021-09-30 | Forsyth | Georgia | 13117 | 33003 | 237 |
1768325 | 1768325 | 2021-09-30 | Franklin | Georgia | 13119 | 3821 | 73 |
1768326 | 1768326 | 2021-09-30 | Fulton | Georgia | 13121 | 128210 | 1633 |
1768327 | 1768327 | 2021-09-30 | Gilmer | Georgia | 13123 | 4420 | 121 |
1768328 | 1768328 | 2021-09-30 | Glascock | Georgia | 13125 | 401 | 19 |
1768329 | 1768329 | 2021-09-30 | Glynn | Georgia | 13127 | 15117 | 312 |
1768330 | 1768330 | 2021-09-30 | Gordon | Georgia | 13129 | 10989 | 173 |
1768331 | 1768331 | 2021-09-30 | Grady | Georgia | 13131 | 3499 | 83 |
1768332 | 1768332 | 2021-09-30 | Greene | Georgia | 13133 | 2627 | 69 |
1768333 | 1768333 | 2021-09-30 | Gwinnett | Georgia | 13135 | 127624 | 1348 |
1768334 | 1768334 | 2021-09-30 | Habersham | Georgia | 13137 | 7207 | 181 |
1768335 | 1768335 | 2021-09-30 | Hall | Georgia | 13139 | 36708 | 578 |
1768336 | 1768336 | 2021-09-30 | Hancock | Georgia | 13141 | 1115 | 75 |
1768337 | 1768337 | 2021-09-30 | Haralson | Georgia | 13143 | 3694 | 104 |
1768338 | 1768338 | 2021-09-30 | Harris | Georgia | 13145 | 3575 | 75 |
1768339 | 1768339 | 2021-09-30 | Hart | Georgia | 13147 | 3415 | 61 |
1768340 | 1768340 | 2021-09-30 | Heard | Georgia | 13149 | 1446 | 32 |
1768341 | 1768341 | 2021-09-30 | Henry | Georgia | 13151 | 36783 | 436 |
1768342 | 1768342 | 2021-09-30 | Houston | Georgia | 13153 | 24217 | 334 |
1768343 | 1768343 | 2021-09-30 | Irwin | Georgia | 13155 | 1418 | 32 |
1768344 | 1768344 | 2021-09-30 | Jackson | Georgia | 13157 | 14209 | 187 |
1768345 | 1768345 | 2021-09-30 | Jasper | Georgia | 13159 | 2069 | 53 |
1768346 | 1768346 | 2021-09-30 | Jeff Davis | Georgia | 13161 | 2890 | 55 |
1768347 | 1768347 | 2021-09-30 | Jefferson | Georgia | 13163 | 2609 | 79 |
1768348 | 1768348 | 2021-09-30 | Jenkins | Georgia | 13165 | 1176 | 50 |
1768349 | 1768349 | 2021-09-30 | Johnson | Georgia | 13167 | 1521 | 57 |
1768350 | 1768350 | 2021-09-30 | Jones | Georgia | 13169 | 3340 | 80 |
1768351 | 1768351 | 2021-09-30 | Lamar | Georgia | 13171 | 3321 | 80 |
1768352 | 1768352 | 2021-09-30 | Lanier | Georgia | 13173 | 1434 | 15 |
1768353 | 1768353 | 2021-09-30 | Laurens | Georgia | 13175 | 8880 | 221 |
1768354 | 1768354 | 2021-09-30 | Lee | Georgia | 13177 | 4557 | 75 |
1768355 | 1768355 | 2021-09-30 | Liberty | Georgia | 13179 | 7162 | 89 |
1768356 | 1768356 | 2021-09-30 | Lincoln | Georgia | 13181 | 1138 | 32 |
1768357 | 1768357 | 2021-09-30 | Long | Georgia | 13183 | 1649 | 20 |
1768358 | 1768358 | 2021-09-30 | Lowndes | Georgia | 13185 | 20781 | 280 |
1768359 | 1768359 | 2021-09-30 | Lumpkin | Georgia | 13187 | 4705 | 91 |
1768360 | 1768360 | 2021-09-30 | Macon | Georgia | 13193 | 1289 | 38 |
1768361 | 1768361 | 2021-09-30 | Madison | Georgia | 13195 | 4801 | 65 |
1768362 | 1768362 | 2021-09-30 | Marion | Georgia | 13197 | 932 | 33 |
1768363 | 1768363 | 2021-09-30 | McDuffie | Georgia | 13189 | 3417 | 66 |
1768364 | 1768364 | 2021-09-30 | McIntosh | Georgia | 13191 | 1688 | 26 |
1768365 | 1768365 | 2021-09-30 | Meriwether | Georgia | 13199 | 2902 | 100 |
1768366 | 1768366 | 2021-09-30 | Miller | Georgia | 13201 | 1186 | 18 |
Advanced export
JSON shape: default, array, newline-delimited
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);