ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where date = "2020-09-30" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
583397 | 583397 | 2020-09-30 | Appling | Georgia | 13001 | 1040 | 29 |
583398 | 583398 | 2020-09-30 | Atkinson | Georgia | 13003 | 444 | 3 |
583399 | 583399 | 2020-09-30 | Bacon | Georgia | 13005 | 598 | 14 |
583400 | 583400 | 2020-09-30 | Baker | Georgia | 13007 | 84 | 4 |
583401 | 583401 | 2020-09-30 | Baldwin | Georgia | 13009 | 2134 | 57 |
583402 | 583402 | 2020-09-30 | Banks | Georgia | 13011 | 488 | 8 |
583403 | 583403 | 2020-09-30 | Barrow | Georgia | 13013 | 2219 | 48 |
583404 | 583404 | 2020-09-30 | Bartow | Georgia | 13015 | 2938 | 87 |
583405 | 583405 | 2020-09-30 | Ben Hill | Georgia | 13017 | 791 | 24 |
583406 | 583406 | 2020-09-30 | Berrien | Georgia | 13019 | 455 | 12 |
583407 | 583407 | 2020-09-30 | Bibb | Georgia | 13021 | 6089 | 171 |
583408 | 583408 | 2020-09-30 | Bleckley | Georgia | 13023 | 435 | 21 |
583409 | 583409 | 2020-09-30 | Brantley | Georgia | 13025 | 346 | 10 |
583410 | 583410 | 2020-09-30 | Brooks | Georgia | 13027 | 523 | 26 |
583411 | 583411 | 2020-09-30 | Bryan | Georgia | 13029 | 1154 | 11 |
583412 | 583412 | 2020-09-30 | Bulloch | Georgia | 13031 | 2890 | 28 |
583413 | 583413 | 2020-09-30 | Burke | Georgia | 13033 | 813 | 10 |
583414 | 583414 | 2020-09-30 | Butts | Georgia | 13035 | 661 | 42 |
583415 | 583415 | 2020-09-30 | Calhoun | Georgia | 13037 | 246 | 8 |
583416 | 583416 | 2020-09-30 | Camden | Georgia | 13039 | 1303 | 13 |
583417 | 583417 | 2020-09-30 | Candler | Georgia | 13043 | 465 | 19 |
583418 | 583418 | 2020-09-30 | Carroll | Georgia | 13045 | 2807 | 68 |
583419 | 583419 | 2020-09-30 | Catoosa | Georgia | 13047 | 1202 | 18 |
583420 | 583420 | 2020-09-30 | Charlton | Georgia | 13049 | 638 | 7 |
583421 | 583421 | 2020-09-30 | Chatham | Georgia | 13051 | 8511 | 163 |
583422 | 583422 | 2020-09-30 | Chattahoochee | Georgia | 13053 | 1666 | 1 |
583423 | 583423 | 2020-09-30 | Chattooga | Georgia | 13055 | 784 | 22 |
583424 | 583424 | 2020-09-30 | Cherokee | Georgia | 13057 | 6118 | 92 |
583425 | 583425 | 2020-09-30 | Clarke | Georgia | 13059 | 5084 | 44 |
583426 | 583426 | 2020-09-30 | Clay | Georgia | 13061 | 122 | 2 |
583427 | 583427 | 2020-09-30 | Clayton | Georgia | 13063 | 7107 | 162 |
583428 | 583428 | 2020-09-30 | Clinch | Georgia | 13065 | 379 | 6 |
583429 | 583429 | 2020-09-30 | Cobb | Georgia | 13067 | 19740 | 427 |
583430 | 583430 | 2020-09-30 | Coffee | Georgia | 13069 | 2070 | 50 |
583431 | 583431 | 2020-09-30 | Colquitt | Georgia | 13071 | 1895 | 34 |
583432 | 583432 | 2020-09-30 | Columbia | Georgia | 13073 | 3777 | 61 |
583433 | 583433 | 2020-09-30 | Cook | Georgia | 13075 | 551 | 13 |
583434 | 583434 | 2020-09-30 | Coweta | Georgia | 13077 | 2628 | 47 |
583435 | 583435 | 2020-09-30 | Crawford | Georgia | 13079 | 167 | 5 |
583436 | 583436 | 2020-09-30 | Crisp | Georgia | 13081 | 571 | 17 |
583437 | 583437 | 2020-09-30 | Dade | Georgia | 13083 | 286 | 5 |
583438 | 583438 | 2020-09-30 | Dawson | Georgia | 13085 | 830 | 8 |
583439 | 583439 | 2020-09-30 | DeKalb | Georgia | 13089 | 18859 | 367 |
583440 | 583440 | 2020-09-30 | Decatur | Georgia | 13087 | 1165 | 29 |
583441 | 583441 | 2020-09-30 | Dodge | Georgia | 13091 | 431 | 12 |
583442 | 583442 | 2020-09-30 | Dooly | Georgia | 13093 | 340 | 14 |
583443 | 583443 | 2020-09-30 | Dougherty | Georgia | 13095 | 3159 | 187 |
583444 | 583444 | 2020-09-30 | Douglas | Georgia | 13097 | 3595 | 71 |
583445 | 583445 | 2020-09-30 | Early | Georgia | 13099 | 502 | 33 |
583446 | 583446 | 2020-09-30 | Echols | Georgia | 13101 | 241 | 2 |
583447 | 583447 | 2020-09-30 | Effingham | Georgia | 13103 | 1453 | 23 |
583448 | 583448 | 2020-09-30 | Elbert | Georgia | 13105 | 677 | 3 |
583449 | 583449 | 2020-09-30 | Emanuel | Georgia | 13107 | 1064 | 32 |
583450 | 583450 | 2020-09-30 | Evans | Georgia | 13109 | 430 | 6 |
583451 | 583451 | 2020-09-30 | Fannin | Georgia | 13111 | 681 | 24 |
583452 | 583452 | 2020-09-30 | Fayette | Georgia | 13113 | 1877 | 50 |
583453 | 583453 | 2020-09-30 | Floyd | Georgia | 13115 | 3219 | 45 |
583454 | 583454 | 2020-09-30 | Forsyth | Georgia | 13117 | 4114 | 46 |
583455 | 583455 | 2020-09-30 | Franklin | Georgia | 13119 | 758 | 13 |
583456 | 583456 | 2020-09-30 | Fulton | Georgia | 13121 | 27684 | 575 |
583457 | 583457 | 2020-09-30 | Gilmer | Georgia | 13123 | 827 | 12 |
583458 | 583458 | 2020-09-30 | Glascock | Georgia | 13125 | 39 | 2 |
583459 | 583459 | 2020-09-30 | Glynn | Georgia | 13127 | 3486 | 95 |
583460 | 583460 | 2020-09-30 | Gordon | Georgia | 13129 | 1870 | 36 |
583461 | 583461 | 2020-09-30 | Grady | Georgia | 13131 | 785 | 22 |
583462 | 583462 | 2020-09-30 | Greene | Georgia | 13133 | 509 | 24 |
583463 | 583463 | 2020-09-30 | Gwinnett | Georgia | 13135 | 27647 | 409 |
583464 | 583464 | 2020-09-30 | Habersham | Georgia | 13137 | 1674 | 67 |
583465 | 583465 | 2020-09-30 | Hall | Georgia | 13139 | 9373 | 154 |
583466 | 583466 | 2020-09-30 | Hancock | Georgia | 13141 | 394 | 42 |
583467 | 583467 | 2020-09-30 | Haralson | Georgia | 13143 | 487 | 8 |
583468 | 583468 | 2020-09-30 | Harris | Georgia | 13145 | 799 | 22 |
583469 | 583469 | 2020-09-30 | Hart | Georgia | 13147 | 521 | 13 |
583470 | 583470 | 2020-09-30 | Heard | Georgia | 13149 | 197 | 5 |
583471 | 583471 | 2020-09-30 | Henry | Georgia | 13151 | 5281 | 102 |
583472 | 583472 | 2020-09-30 | Houston | Georgia | 13153 | 3163 | 82 |
583473 | 583473 | 2020-09-30 | Irwin | Georgia | 13155 | 305 | 4 |
583474 | 583474 | 2020-09-30 | Jackson | Georgia | 13157 | 2024 | 33 |
583475 | 583475 | 2020-09-30 | Jasper | Georgia | 13159 | 222 | 4 |
583476 | 583476 | 2020-09-30 | Jeff Davis | Georgia | 13161 | 724 | 20 |
583477 | 583477 | 2020-09-30 | Jefferson | Georgia | 13163 | 804 | 29 |
583478 | 583478 | 2020-09-30 | Jenkins | Georgia | 13165 | 429 | 30 |
583479 | 583479 | 2020-09-30 | Johnson | Georgia | 13167 | 415 | 22 |
583480 | 583480 | 2020-09-30 | Jones | Georgia | 13169 | 560 | 9 |
583481 | 583481 | 2020-09-30 | Lamar | Georgia | 13171 | 372 | 18 |
583482 | 583482 | 2020-09-30 | Lanier | Georgia | 13173 | 295 | 5 |
583483 | 583483 | 2020-09-30 | Laurens | Georgia | 13175 | 1661 | 75 |
583484 | 583484 | 2020-09-30 | Lee | Georgia | 13177 | 700 | 26 |
583485 | 583485 | 2020-09-30 | Liberty | Georgia | 13179 | 1125 | 22 |
583486 | 583486 | 2020-09-30 | Lincoln | Georgia | 13181 | 213 | 7 |
583487 | 583487 | 2020-09-30 | Long | Georgia | 13183 | 252 | 3 |
583488 | 583488 | 2020-09-30 | Lowndes | Georgia | 13185 | 3920 | 82 |
583489 | 583489 | 2020-09-30 | Lumpkin | Georgia | 13187 | 926 | 14 |
583490 | 583490 | 2020-09-30 | Macon | Georgia | 13193 | 234 | 10 |
583491 | 583491 | 2020-09-30 | Madison | Georgia | 13195 | 704 | 8 |
583492 | 583492 | 2020-09-30 | Marion | Georgia | 13197 | 192 | 8 |
583493 | 583493 | 2020-09-30 | McDuffie | Georgia | 13189 | 605 | 14 |
583494 | 583494 | 2020-09-30 | McIntosh | Georgia | 13191 | 293 | 7 |
583495 | 583495 | 2020-09-30 | Meriwether | Georgia | 13199 | 546 | 13 |
583496 | 583496 | 2020-09-30 | Miller | Georgia | 13201 | 266 | 1 |
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);