ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where date = "2020-09-12" 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 |
---|---|---|---|---|---|---|---|
525104 | 525104 | 2020-09-12 | Appling | Georgia | 13001 | 956 | 26 |
525105 | 525105 | 2020-09-12 | Atkinson | Georgia | 13003 | 431 | 3 |
525106 | 525106 | 2020-09-12 | Bacon | Georgia | 13005 | 559 | 10 |
525107 | 525107 | 2020-09-12 | Baker | Georgia | 13007 | 73 | 3 |
525108 | 525108 | 2020-09-12 | Baldwin | Georgia | 13009 | 1905 | 55 |
525109 | 525109 | 2020-09-12 | Banks | Georgia | 13011 | 432 | 6 |
525110 | 525110 | 2020-09-12 | Barrow | Georgia | 13013 | 1965 | 43 |
525111 | 525111 | 2020-09-12 | Bartow | Georgia | 13015 | 2666 | 76 |
525112 | 525112 | 2020-09-12 | Ben Hill | Georgia | 13017 | 696 | 18 |
525113 | 525113 | 2020-09-12 | Berrien | Georgia | 13019 | 418 | 10 |
525114 | 525114 | 2020-09-12 | Bibb | Georgia | 13021 | 5693 | 148 |
525115 | 525115 | 2020-09-12 | Bleckley | Georgia | 13023 | 415 | 19 |
525116 | 525116 | 2020-09-12 | Brantley | Georgia | 13025 | 324 | 8 |
525117 | 525117 | 2020-09-12 | Brooks | Georgia | 13027 | 492 | 26 |
525118 | 525118 | 2020-09-12 | Bryan | Georgia | 13029 | 979 | 9 |
525119 | 525119 | 2020-09-12 | Bulloch | Georgia | 13031 | 2602 | 24 |
525120 | 525120 | 2020-09-12 | Burke | Georgia | 13033 | 725 | 9 |
525121 | 525121 | 2020-09-12 | Butts | Georgia | 13035 | 608 | 41 |
525122 | 525122 | 2020-09-12 | Calhoun | Georgia | 13037 | 231 | 7 |
525123 | 525123 | 2020-09-12 | Camden | Georgia | 13039 | 1142 | 7 |
525124 | 525124 | 2020-09-12 | Candler | Georgia | 13043 | 397 | 16 |
525125 | 525125 | 2020-09-12 | Carroll | Georgia | 13045 | 2509 | 63 |
525126 | 525126 | 2020-09-12 | Catoosa | Georgia | 13047 | 1002 | 16 |
525127 | 525127 | 2020-09-12 | Charlton | Georgia | 13049 | 592 | 6 |
525128 | 525128 | 2020-09-12 | Chatham | Georgia | 13051 | 7728 | 136 |
525129 | 525129 | 2020-09-12 | Chattahoochee | Georgia | 13053 | 1584 | 2 |
525130 | 525130 | 2020-09-12 | Chattooga | Georgia | 13055 | 672 | 7 |
525131 | 525131 | 2020-09-12 | Cherokee | Georgia | 13057 | 5473 | 87 |
525132 | 525132 | 2020-09-12 | Clarke | Georgia | 13059 | 4430 | 36 |
525133 | 525133 | 2020-09-12 | Clay | Georgia | 13061 | 116 | 2 |
525134 | 525134 | 2020-09-12 | Clayton | Georgia | 13063 | 6819 | 153 |
525135 | 525135 | 2020-09-12 | Clinch | Georgia | 13065 | 329 | 5 |
525136 | 525136 | 2020-09-12 | Cobb | Georgia | 13067 | 18433 | 410 |
525137 | 525137 | 2020-09-12 | Coffee | Georgia | 13069 | 1907 | 41 |
525138 | 525138 | 2020-09-12 | Colquitt | Georgia | 13071 | 1868 | 32 |
525139 | 525139 | 2020-09-12 | Columbia | Georgia | 13073 | 3443 | 55 |
525140 | 525140 | 2020-09-12 | Cook | Georgia | 13075 | 531 | 12 |
525141 | 525141 | 2020-09-12 | Coweta | Georgia | 13077 | 2396 | 37 |
525142 | 525142 | 2020-09-12 | Crawford | Georgia | 13079 | 162 | 4 |
525143 | 525143 | 2020-09-12 | Crisp | Georgia | 13081 | 510 | 17 |
525144 | 525144 | 2020-09-12 | Dade | Georgia | 13083 | 238 | 4 |
525145 | 525145 | 2020-09-12 | Dawson | Georgia | 13085 | 752 | 6 |
525146 | 525146 | 2020-09-12 | DeKalb | Georgia | 13089 | 17477 | 335 |
525147 | 525147 | 2020-09-12 | Decatur | Georgia | 13087 | 1060 | 23 |
525148 | 525148 | 2020-09-12 | Dodge | Georgia | 13091 | 368 | 9 |
525149 | 525149 | 2020-09-12 | Dooly | Georgia | 13093 | 304 | 14 |
525150 | 525150 | 2020-09-12 | Dougherty | Georgia | 13095 | 3064 | 181 |
525151 | 525151 | 2020-09-12 | Douglas | Georgia | 13097 | 3343 | 68 |
525152 | 525152 | 2020-09-12 | Early | Georgia | 13099 | 445 | 32 |
525153 | 525153 | 2020-09-12 | Echols | Georgia | 13101 | 238 | 2 |
525154 | 525154 | 2020-09-12 | Effingham | Georgia | 13103 | 1257 | 21 |
525155 | 525155 | 2020-09-12 | Elbert | Georgia | 13105 | 553 | 2 |
525156 | 525156 | 2020-09-12 | Emanuel | Georgia | 13107 | 903 | 27 |
525157 | 525157 | 2020-09-12 | Evans | Georgia | 13109 | 400 | 5 |
525158 | 525158 | 2020-09-12 | Fannin | Georgia | 13111 | 529 | 9 |
525159 | 525159 | 2020-09-12 | Fayette | Georgia | 13113 | 1667 | 45 |
525160 | 525160 | 2020-09-12 | Floyd | Georgia | 13115 | 2675 | 39 |
525161 | 525161 | 2020-09-12 | Forsyth | Georgia | 13117 | 3515 | 40 |
525162 | 525162 | 2020-09-12 | Franklin | Georgia | 13119 | 655 | 11 |
525163 | 525163 | 2020-09-12 | Fulton | Georgia | 13121 | 26108 | 554 |
525164 | 525164 | 2020-09-12 | Gilmer | Georgia | 13123 | 780 | 10 |
525165 | 525165 | 2020-09-12 | Glascock | Georgia | 13125 | 37 | 2 |
525166 | 525166 | 2020-09-12 | Glynn | Georgia | 13127 | 3308 | 85 |
525167 | 525167 | 2020-09-12 | Gordon | Georgia | 13129 | 1668 | 35 |
525168 | 525168 | 2020-09-12 | Grady | Georgia | 13131 | 716 | 19 |
525169 | 525169 | 2020-09-12 | Greene | Georgia | 13133 | 482 | 21 |
525170 | 525170 | 2020-09-12 | Gwinnett | Georgia | 13135 | 25726 | 372 |
525171 | 525171 | 2020-09-12 | Habersham | Georgia | 13137 | 1442 | 63 |
525172 | 525172 | 2020-09-12 | Hall | Georgia | 13139 | 8341 | 136 |
525173 | 525173 | 2020-09-12 | Hancock | Georgia | 13141 | 374 | 41 |
525174 | 525174 | 2020-09-12 | Haralson | Georgia | 13143 | 394 | 8 |
525175 | 525175 | 2020-09-12 | Harris | Georgia | 13145 | 760 | 21 |
525176 | 525176 | 2020-09-12 | Hart | Georgia | 13147 | 463 | 11 |
525177 | 525177 | 2020-09-12 | Heard | Georgia | 13149 | 181 | 5 |
525178 | 525178 | 2020-09-12 | Henry | Georgia | 13151 | 4710 | 91 |
525179 | 525179 | 2020-09-12 | Houston | Georgia | 13153 | 2851 | 74 |
525180 | 525180 | 2020-09-12 | Irwin | Georgia | 13155 | 255 | 4 |
525181 | 525181 | 2020-09-12 | Jackson | Georgia | 13157 | 1730 | 27 |
525182 | 525182 | 2020-09-12 | Jasper | Georgia | 13159 | 202 | 4 |
525183 | 525183 | 2020-09-12 | Jeff Davis | Georgia | 13161 | 677 | 15 |
525184 | 525184 | 2020-09-12 | Jefferson | Georgia | 13163 | 743 | 21 |
525185 | 525185 | 2020-09-12 | Jenkins | Georgia | 13165 | 369 | 28 |
525186 | 525186 | 2020-09-12 | Johnson | Georgia | 13167 | 401 | 18 |
525187 | 525187 | 2020-09-12 | Jones | Georgia | 13169 | 501 | 4 |
525188 | 525188 | 2020-09-12 | Lamar | Georgia | 13171 | 342 | 17 |
525189 | 525189 | 2020-09-12 | Lanier | Georgia | 13173 | 284 | 5 |
525190 | 525190 | 2020-09-12 | Laurens | Georgia | 13175 | 1478 | 54 |
525191 | 525191 | 2020-09-12 | Lee | Georgia | 13177 | 667 | 25 |
525192 | 525192 | 2020-09-12 | Liberty | Georgia | 13179 | 997 | 19 |
525193 | 525193 | 2020-09-12 | Lincoln | Georgia | 13181 | 203 | 7 |
525194 | 525194 | 2020-09-12 | Long | Georgia | 13183 | 209 | 3 |
525195 | 525195 | 2020-09-12 | Lowndes | Georgia | 13185 | 3691 | 72 |
525196 | 525196 | 2020-09-12 | Lumpkin | Georgia | 13187 | 803 | 12 |
525197 | 525197 | 2020-09-12 | Macon | Georgia | 13193 | 220 | 10 |
525198 | 525198 | 2020-09-12 | Madison | Georgia | 13195 | 613 | 8 |
525199 | 525199 | 2020-09-12 | Marion | Georgia | 13197 | 178 | 7 |
525200 | 525200 | 2020-09-12 | McDuffie | Georgia | 13189 | 552 | 13 |
525201 | 525201 | 2020-09-12 | McIntosh | Georgia | 13191 | 273 | 7 |
525202 | 525202 | 2020-09-12 | Meriwether | Georgia | 13199 | 516 | 11 |
525203 | 525203 | 2020-09-12 | Miller | Georgia | 13201 | 232 | 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);