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-08-05 and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1586348 | 1586348 | 2021-08-05 | Appling | Georgia | 13001 | 2494 | 72 |
1586349 | 1586349 | 2021-08-05 | Atkinson | Georgia | 13003 | 1142 | 23 |
1586350 | 1586350 | 2021-08-05 | Bacon | Georgia | 13005 | 1805 | 40 |
1586351 | 1586351 | 2021-08-05 | Baker | Georgia | 13007 | 279 | 11 |
1586352 | 1586352 | 2021-08-05 | Baldwin | Georgia | 13009 | 4749 | 137 |
1586353 | 1586353 | 2021-08-05 | Banks | Georgia | 13011 | 1970 | 41 |
1586354 | 1586354 | 2021-08-05 | Barrow | Georgia | 13013 | 10764 | 147 |
1586355 | 1586355 | 2021-08-05 | Bartow | Georgia | 13015 | 15729 | 242 |
1586356 | 1586356 | 2021-08-05 | Ben Hill | Georgia | 13017 | 2279 | 84 |
1586357 | 1586357 | 2021-08-05 | Berrien | Georgia | 13019 | 2180 | 48 |
1586358 | 1586358 | 2021-08-05 | Bibb | Georgia | 13021 | 17439 | 470 |
1586359 | 1586359 | 2021-08-05 | Bleckley | Georgia | 13023 | 1700 | 52 |
1586360 | 1586360 | 2021-08-05 | Brantley | Georgia | 13025 | 1905 | 42 |
1586361 | 1586361 | 2021-08-05 | Brooks | Georgia | 13027 | 1608 | 50 |
1586362 | 1586362 | 2021-08-05 | Bryan | Georgia | 13029 | 4160 | 42 |
1586363 | 1586363 | 2021-08-05 | Bulloch | Georgia | 13031 | 7481 | 124 |
1586364 | 1586364 | 2021-08-05 | Burke | Georgia | 13033 | 2790 | 66 |
1586365 | 1586365 | 2021-08-05 | Butts | Georgia | 13035 | 3370 | 90 |
1586366 | 1586366 | 2021-08-05 | Calhoun | Georgia | 13037 | 625 | 16 |
1586367 | 1586367 | 2021-08-05 | Camden | Georgia | 13039 | 5147 | 45 |
1586368 | 1586368 | 2021-08-05 | Candler | Georgia | 13043 | 1063 | 68 |
1586369 | 1586369 | 2021-08-05 | Carroll | Georgia | 13045 | 12396 | 250 |
1586370 | 1586370 | 2021-08-05 | Catoosa | Georgia | 13047 | 7044 | 77 |
1586371 | 1586371 | 2021-08-05 | Charlton | Georgia | 13049 | 1822 | 37 |
1586372 | 1586372 | 2021-08-05 | Chatham | Georgia | 13051 | 26329 | 479 |
1586373 | 1586373 | 2021-08-05 | Chattahoochee | Georgia | 13053 | 4919 | 17 |
1586374 | 1586374 | 2021-08-05 | Chattooga | Georgia | 13055 | 3037 | 76 |
1586375 | 1586375 | 2021-08-05 | Cherokee | Georgia | 13057 | 33260 | 338 |
1586376 | 1586376 | 2021-08-05 | Clarke | Georgia | 13059 | 15851 | 149 |
1586377 | 1586377 | 2021-08-05 | Clay | Georgia | 13061 | 253 | 3 |
1586378 | 1586378 | 2021-08-05 | Clayton | Georgia | 13063 | 29364 | 530 |
1586379 | 1586379 | 2021-08-05 | Clinch | Georgia | 13065 | 1047 | 27 |
1586380 | 1586380 | 2021-08-05 | Cobb | Georgia | 13067 | 84890 | 1131 |
1586381 | 1586381 | 2021-08-05 | Coffee | Georgia | 13069 | 5937 | 182 |
1586382 | 1586382 | 2021-08-05 | Colquitt | Georgia | 13071 | 5401 | 134 |
1586383 | 1586383 | 2021-08-05 | Columbia | Georgia | 13073 | 18217 | 213 |
1586384 | 1586384 | 2021-08-05 | Cook | Georgia | 13075 | 2189 | 43 |
1586385 | 1586385 | 2021-08-05 | Coweta | Georgia | 13077 | 15332 | 241 |
1586386 | 1586386 | 2021-08-05 | Crawford | Georgia | 13079 | 728 | 21 |
1586387 | 1586387 | 2021-08-05 | Crisp | Georgia | 13081 | 2228 | 94 |
1586388 | 1586388 | 2021-08-05 | Dade | Georgia | 13083 | 1548 | 14 |
1586389 | 1586389 | 2021-08-05 | Dawson | Georgia | 13085 | 3242 | 49 |
1586390 | 1586390 | 2021-08-05 | DeKalb | Georgia | 13089 | 71475 | 1088 |
1586391 | 1586391 | 2021-08-05 | Decatur | Georgia | 13087 | 3255 | 77 |
1586392 | 1586392 | 2021-08-05 | Dodge | Georgia | 13091 | 2329 | 110 |
1586393 | 1586393 | 2021-08-05 | Dooly | Georgia | 13093 | 1150 | 44 |
1586394 | 1586394 | 2021-08-05 | Dougherty | Georgia | 13095 | 8286 | 313 |
1586395 | 1586395 | 2021-08-05 | Douglas | Georgia | 13097 | 16657 | 235 |
1586396 | 1586396 | 2021-08-05 | Early | Georgia | 13099 | 1327 | 47 |
1586397 | 1586397 | 2021-08-05 | Echols | Georgia | 13101 | 558 | 9 |
1586398 | 1586398 | 2021-08-05 | Effingham | Georgia | 13103 | 5254 | 76 |
1586399 | 1586399 | 2021-08-05 | Elbert | Georgia | 13105 | 2373 | 74 |
1586400 | 1586400 | 2021-08-05 | Emanuel | Georgia | 13107 | 2856 | 84 |
1586401 | 1586401 | 2021-08-05 | Evans | Georgia | 13109 | 1162 | 34 |
1586402 | 1586402 | 2021-08-05 | Fannin | Georgia | 13111 | 2628 | 75 |
1586403 | 1586403 | 2021-08-05 | Fayette | Georgia | 13113 | 9763 | 179 |
1586404 | 1586404 | 2021-08-05 | Floyd | Georgia | 13115 | 12635 | 241 |
1586405 | 1586405 | 2021-08-05 | Forsyth | Georgia | 13117 | 24447 | 206 |
1586406 | 1586406 | 2021-08-05 | Franklin | Georgia | 13119 | 2862 | 57 |
1586407 | 1586407 | 2021-08-05 | Fulton | Georgia | 13121 | 105535 | 1495 |
1586408 | 1586408 | 2021-08-05 | Gilmer | Georgia | 13123 | 3210 | 92 |
1586409 | 1586409 | 2021-08-05 | Glascock | Georgia | 13125 | 287 | 19 |
1586410 | 1586410 | 2021-08-05 | Glynn | Georgia | 13127 | 9428 | 182 |
1586411 | 1586411 | 2021-08-05 | Gordon | Georgia | 13129 | 8643 | 120 |
1586412 | 1586412 | 2021-08-05 | Grady | Georgia | 13131 | 2530 | 66 |
1586413 | 1586413 | 2021-08-05 | Greene | Georgia | 13133 | 1931 | 62 |
1586414 | 1586414 | 2021-08-05 | Gwinnett | Georgia | 13135 | 107279 | 1220 |
1586415 | 1586415 | 2021-08-05 | Habersham | Georgia | 13137 | 5388 | 166 |
1586416 | 1586416 | 2021-08-05 | Hall | Georgia | 13139 | 29032 | 502 |
1586417 | 1586417 | 2021-08-05 | Hancock | Georgia | 13141 | 957 | 69 |
1586418 | 1586418 | 2021-08-05 | Haralson | Georgia | 13143 | 2851 | 91 |
1586419 | 1586419 | 2021-08-05 | Harris | Georgia | 13145 | 2823 | 66 |
1586420 | 1586420 | 2021-08-05 | Hart | Georgia | 13147 | 2559 | 56 |
1586421 | 1586421 | 2021-08-05 | Heard | Georgia | 13149 | 981 | 23 |
1586422 | 1586422 | 2021-08-05 | Henry | Georgia | 13151 | 27894 | 342 |
1586423 | 1586423 | 2021-08-05 | Houston | Georgia | 13153 | 16305 | 274 |
1586424 | 1586424 | 2021-08-05 | Irwin | Georgia | 13155 | 1108 | 31 |
1586425 | 1586425 | 2021-08-05 | Jackson | Georgia | 13157 | 10543 | 153 |
1586426 | 1586426 | 2021-08-05 | Jasper | Georgia | 13159 | 1496 | 40 |
1586427 | 1586427 | 2021-08-05 | Jeff Davis | Georgia | 13161 | 2080 | 44 |
1586428 | 1586428 | 2021-08-05 | Jefferson | Georgia | 13163 | 2035 | 69 |
1586429 | 1586429 | 2021-08-05 | Jenkins | Georgia | 13165 | 932 | 44 |
1586430 | 1586430 | 2021-08-05 | Johnson | Georgia | 13167 | 1194 | 50 |
1586431 | 1586431 | 2021-08-05 | Jones | Georgia | 13169 | 2175 | 61 |
1586432 | 1586432 | 2021-08-05 | Lamar | Georgia | 13171 | 2253 | 59 |
1586433 | 1586433 | 2021-08-05 | Lanier | Georgia | 13173 | 882 | 14 |
1586434 | 1586434 | 2021-08-05 | Laurens | Georgia | 13175 | 6186 | 173 |
1586435 | 1586435 | 2021-08-05 | Lee | Georgia | 13177 | 3092 | 59 |
1586436 | 1586436 | 2021-08-05 | Liberty | Georgia | 13179 | 4718 | 69 |
1586437 | 1586437 | 2021-08-05 | Lincoln | Georgia | 13181 | 870 | 28 |
1586438 | 1586438 | 2021-08-05 | Long | Georgia | 13183 | 1042 | 14 |
1586439 | 1586439 | 2021-08-05 | Lowndes | Georgia | 13185 | 14718 | 221 |
1586440 | 1586440 | 2021-08-05 | Lumpkin | Georgia | 13187 | 3209 | 83 |
1586441 | 1586441 | 2021-08-05 | Macon | Georgia | 13193 | 925 | 37 |
1586442 | 1586442 | 2021-08-05 | Madison | Georgia | 13195 | 3442 | 56 |
1586443 | 1586443 | 2021-08-05 | Marion | Georgia | 13197 | 649 | 26 |
1586444 | 1586444 | 2021-08-05 | McDuffie | Georgia | 13189 | 2681 | 52 |
1586445 | 1586445 | 2021-08-05 | McIntosh | Georgia | 13191 | 935 | 16 |
1586446 | 1586446 | 2021-08-05 | Meriwether | Georgia | 13199 | 2204 | 92 |
1586447 | 1586447 | 2021-08-05 | Miller | Georgia | 13201 | 898 | 14 |
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);