ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where date = "2020-08-08" 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 |
---|---|---|---|---|---|---|---|
412067 | 412067 | 2020-08-08 | Appling | Georgia | 13001 | 645 | 19 |
412068 | 412068 | 2020-08-08 | Atkinson | Georgia | 13003 | 317 | 2 |
412069 | 412069 | 2020-08-08 | Bacon | Georgia | 13005 | 433 | 7 |
412070 | 412070 | 2020-08-08 | Baker | Georgia | 13007 | 63 | 3 |
412071 | 412071 | 2020-08-08 | Baldwin | Georgia | 13009 | 1035 | 39 |
412072 | 412072 | 2020-08-08 | Banks | Georgia | 13011 | 270 | 4 |
412073 | 412073 | 2020-08-08 | Barrow | Georgia | 13013 | 1278 | 32 |
412074 | 412074 | 2020-08-08 | Bartow | Georgia | 13015 | 1853 | 62 |
412075 | 412075 | 2020-08-08 | Ben Hill | Georgia | 13017 | 416 | 3 |
412076 | 412076 | 2020-08-08 | Berrien | Georgia | 13019 | 289 | 0 |
412077 | 412077 | 2020-08-08 | Bibb | Georgia | 13021 | 3554 | 68 |
412078 | 412078 | 2020-08-08 | Bleckley | Georgia | 13023 | 184 | 7 |
412079 | 412079 | 2020-08-08 | Brantley | Georgia | 13025 | 244 | 5 |
412080 | 412080 | 2020-08-08 | Brooks | Georgia | 13027 | 408 | 18 |
412081 | 412081 | 2020-08-08 | Bryan | Georgia | 13029 | 651 | 8 |
412082 | 412082 | 2020-08-08 | Bulloch | Georgia | 13031 | 1242 | 14 |
412083 | 412083 | 2020-08-08 | Burke | Georgia | 13033 | 462 | 7 |
412084 | 412084 | 2020-08-08 | Butts | Georgia | 13035 | 487 | 37 |
412085 | 412085 | 2020-08-08 | Calhoun | Georgia | 13037 | 203 | 6 |
412086 | 412086 | 2020-08-08 | Camden | Georgia | 13039 | 730 | 5 |
412087 | 412087 | 2020-08-08 | Candler | Georgia | 13043 | 252 | 4 |
412088 | 412088 | 2020-08-08 | Carroll | Georgia | 13045 | 1862 | 49 |
412089 | 412089 | 2020-08-08 | Catoosa | Georgia | 13047 | 631 | 9 |
412090 | 412090 | 2020-08-08 | Charlton | Georgia | 13049 | 417 | 3 |
412091 | 412091 | 2020-08-08 | Chatham | Georgia | 13051 | 5665 | 75 |
412092 | 412092 | 2020-08-08 | Chattahoochee | Georgia | 13053 | 759 | 1 |
412093 | 412093 | 2020-08-08 | Chattooga | Georgia | 13055 | 255 | 3 |
412094 | 412094 | 2020-08-08 | Cherokee | Georgia | 13057 | 3398 | 63 |
412095 | 412095 | 2020-08-08 | Clarke | Georgia | 13059 | 2027 | 18 |
412096 | 412096 | 2020-08-08 | Clay | Georgia | 13061 | 86 | 2 |
412097 | 412097 | 2020-08-08 | Clayton | Georgia | 13063 | 4952 | 110 |
412098 | 412098 | 2020-08-08 | Clinch | Georgia | 13065 | 192 | 4 |
412099 | 412099 | 2020-08-08 | Cobb | Georgia | 13067 | 13336 | 319 |
412100 | 412100 | 2020-08-08 | Coffee | Georgia | 13069 | 1447 | 28 |
412101 | 412101 | 2020-08-08 | Colquitt | Georgia | 13071 | 1537 | 23 |
412102 | 412102 | 2020-08-08 | Columbia | Georgia | 13073 | 2188 | 23 |
412103 | 412103 | 2020-08-08 | Cook | Georgia | 13075 | 432 | 6 |
412104 | 412104 | 2020-08-08 | Coweta | Georgia | 13077 | 1485 | 22 |
412105 | 412105 | 2020-08-08 | Crawford | Georgia | 13079 | 102 | 0 |
412106 | 412106 | 2020-08-08 | Crisp | Georgia | 13081 | 374 | 14 |
412107 | 412107 | 2020-08-08 | Dade | Georgia | 13083 | 125 | 1 |
412108 | 412108 | 2020-08-08 | Dawson | Georgia | 13085 | 369 | 3 |
412109 | 412109 | 2020-08-08 | DeKalb | Georgia | 13089 | 13752 | 237 |
412110 | 412110 | 2020-08-08 | Decatur | Georgia | 13087 | 770 | 11 |
412111 | 412111 | 2020-08-08 | Dodge | Georgia | 13091 | 210 | 3 |
412112 | 412112 | 2020-08-08 | Dooly | Georgia | 13093 | 252 | 14 |
412113 | 412113 | 2020-08-08 | Dougherty | Georgia | 13095 | 2684 | 170 |
412114 | 412114 | 2020-08-08 | Douglas | Georgia | 13097 | 2602 | 51 |
412115 | 412115 | 2020-08-08 | Early | Georgia | 13099 | 359 | 32 |
412116 | 412116 | 2020-08-08 | Echols | Georgia | 13101 | 221 | 2 |
412117 | 412117 | 2020-08-08 | Effingham | Georgia | 13103 | 719 | 2 |
412118 | 412118 | 2020-08-08 | Elbert | Georgia | 13105 | 354 | 1 |
412119 | 412119 | 2020-08-08 | Emanuel | Georgia | 13107 | 501 | 9 |
412120 | 412120 | 2020-08-08 | Evans | Georgia | 13109 | 249 | 1 |
412121 | 412121 | 2020-08-08 | Fannin | Georgia | 13111 | 329 | 3 |
412122 | 412122 | 2020-08-08 | Fayette | Georgia | 13113 | 1100 | 28 |
412123 | 412123 | 2020-08-08 | Floyd | Georgia | 13115 | 1488 | 17 |
412124 | 412124 | 2020-08-08 | Forsyth | Georgia | 13117 | 2224 | 22 |
412125 | 412125 | 2020-08-08 | Franklin | Georgia | 13119 | 396 | 6 |
412126 | 412126 | 2020-08-08 | Fulton | Georgia | 13121 | 20049 | 430 |
412127 | 412127 | 2020-08-08 | Gilmer | Georgia | 13123 | 616 | 4 |
412128 | 412128 | 2020-08-08 | Glascock | Georgia | 13125 | 24 | 0 |
412129 | 412129 | 2020-08-08 | Glynn | Georgia | 13127 | 2487 | 47 |
412130 | 412130 | 2020-08-08 | Gordon | Georgia | 13129 | 1171 | 23 |
412131 | 412131 | 2020-08-08 | Grady | Georgia | 13131 | 476 | 5 |
412132 | 412132 | 2020-08-08 | Greene | Georgia | 13133 | 308 | 12 |
412133 | 412133 | 2020-08-08 | Gwinnett | Georgia | 13135 | 19548 | 260 |
412134 | 412134 | 2020-08-08 | Habersham | Georgia | 13137 | 1135 | 49 |
412135 | 412135 | 2020-08-08 | Hall | Georgia | 13139 | 6035 | 91 |
412136 | 412136 | 2020-08-08 | Hancock | Georgia | 13141 | 315 | 35 |
412137 | 412137 | 2020-08-08 | Haralson | Georgia | 13143 | 208 | 6 |
412138 | 412138 | 2020-08-08 | Harris | Georgia | 13145 | 652 | 17 |
412139 | 412139 | 2020-08-08 | Hart | Georgia | 13147 | 300 | 7 |
412140 | 412140 | 2020-08-08 | Heard | Georgia | 13149 | 142 | 4 |
412141 | 412141 | 2020-08-08 | Henry | Georgia | 13151 | 3320 | 47 |
412142 | 412142 | 2020-08-08 | Houston | Georgia | 13153 | 1948 | 58 |
412143 | 412143 | 2020-08-08 | Irwin | Georgia | 13155 | 166 | 1 |
412144 | 412144 | 2020-08-08 | Jackson | Georgia | 13157 | 1059 | 16 |
412145 | 412145 | 2020-08-08 | Jasper | Georgia | 13159 | 161 | 1 |
412146 | 412146 | 2020-08-08 | Jeff Davis | Georgia | 13161 | 436 | 8 |
412147 | 412147 | 2020-08-08 | Jefferson | Georgia | 13163 | 485 | 7 |
412148 | 412148 | 2020-08-08 | Jenkins | Georgia | 13165 | 243 | 24 |
412149 | 412149 | 2020-08-08 | Johnson | Georgia | 13167 | 240 | 11 |
412150 | 412150 | 2020-08-08 | Jones | Georgia | 13169 | 302 | 3 |
412151 | 412151 | 2020-08-08 | Lamar | Georgia | 13171 | 273 | 12 |
412152 | 412152 | 2020-08-08 | Lanier | Georgia | 13173 | 219 | 4 |
412153 | 412153 | 2020-08-08 | Laurens | Georgia | 13175 | 886 | 8 |
412154 | 412154 | 2020-08-08 | Lee | Georgia | 13177 | 535 | 22 |
412155 | 412155 | 2020-08-08 | Liberty | Georgia | 13179 | 713 | 3 |
412156 | 412156 | 2020-08-08 | Lincoln | Georgia | 13181 | 137 | 4 |
412157 | 412157 | 2020-08-08 | Long | Georgia | 13183 | 123 | 1 |
412158 | 412158 | 2020-08-08 | Lowndes | Georgia | 13185 | 3156 | 44 |
412159 | 412159 | 2020-08-08 | Lumpkin | Georgia | 13187 | 339 | 6 |
412160 | 412160 | 2020-08-08 | Macon | Georgia | 13193 | 177 | 10 |
412161 | 412161 | 2020-08-08 | Madison | Georgia | 13195 | 392 | 6 |
412162 | 412162 | 2020-08-08 | Marion | Georgia | 13197 | 150 | 5 |
412163 | 412163 | 2020-08-08 | McDuffie | Georgia | 13189 | 338 | 10 |
412164 | 412164 | 2020-08-08 | McIntosh | Georgia | 13191 | 174 | 2 |
412165 | 412165 | 2020-08-08 | Meriwether | Georgia | 13199 | 384 | 6 |
412166 | 412166 | 2020-08-08 | Miller | Georgia | 13201 | 142 | 0 |
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);