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 2020-06-27 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 |
---|---|---|---|---|---|---|---|
278022 | 278022 | 2020-06-27 | Appling | Georgia | 13001 | 247 | 14 |
278023 | 278023 | 2020-06-27 | Atkinson | Georgia | 13003 | 119 | 2 |
278024 | 278024 | 2020-06-27 | Bacon | Georgia | 13005 | 226 | 4 |
278025 | 278025 | 2020-06-27 | Baker | Georgia | 13007 | 43 | 3 |
278026 | 278026 | 2020-06-27 | Baldwin | Georgia | 13009 | 476 | 33 |
278027 | 278027 | 2020-06-27 | Banks | Georgia | 13011 | 129 | 0 |
278028 | 278028 | 2020-06-27 | Barrow | Georgia | 13013 | 466 | 25 |
278029 | 278029 | 2020-06-27 | Bartow | Georgia | 13015 | 659 | 42 |
278030 | 278030 | 2020-06-27 | Ben Hill | Georgia | 13017 | 150 | 1 |
278031 | 278031 | 2020-06-27 | Berrien | Georgia | 13019 | 110 | 0 |
278032 | 278032 | 2020-06-27 | Bibb | Georgia | 13021 | 724 | 38 |
278033 | 278033 | 2020-06-27 | Bleckley | Georgia | 13023 | 55 | 1 |
278034 | 278034 | 2020-06-27 | Brantley | Georgia | 13025 | 85 | 2 |
278035 | 278035 | 2020-06-27 | Brooks | Georgia | 13027 | 141 | 11 |
278036 | 278036 | 2020-06-27 | Bryan | Georgia | 13029 | 116 | 5 |
278037 | 278037 | 2020-06-27 | Bulloch | Georgia | 13031 | 272 | 4 |
278038 | 278038 | 2020-06-27 | Burke | Georgia | 13033 | 138 | 6 |
278039 | 278039 | 2020-06-27 | Butts | Georgia | 13035 | 263 | 33 |
278040 | 278040 | 2020-06-27 | Calhoun | Georgia | 13037 | 161 | 5 |
278041 | 278041 | 2020-06-27 | Camden | Georgia | 13039 | 114 | 2 |
278042 | 278042 | 2020-06-27 | Candler | Georgia | 13043 | 29 | 0 |
278043 | 278043 | 2020-06-27 | Carroll | Georgia | 13045 | 669 | 39 |
278044 | 278044 | 2020-06-27 | Catoosa | Georgia | 13047 | 303 | 7 |
278045 | 278045 | 2020-06-27 | Charlton | Georgia | 13049 | 43 | 2 |
278046 | 278046 | 2020-06-27 | Chatham | Georgia | 13051 | 1088 | 37 |
278047 | 278047 | 2020-06-27 | Chattahoochee | Georgia | 13053 | 398 | 0 |
278048 | 278048 | 2020-06-27 | Chattooga | Georgia | 13055 | 56 | 2 |
278049 | 278049 | 2020-06-27 | Cherokee | Georgia | 13057 | 1219 | 44 |
278050 | 278050 | 2020-06-27 | Clarke | Georgia | 13059 | 481 | 15 |
278051 | 278051 | 2020-06-27 | Clay | Georgia | 13061 | 57 | 2 |
278052 | 278052 | 2020-06-27 | Clayton | Georgia | 13063 | 1864 | 79 |
278053 | 278053 | 2020-06-27 | Clinch | Georgia | 13065 | 100 | 3 |
278054 | 278054 | 2020-06-27 | Cobb | Georgia | 13067 | 4526 | 239 |
278055 | 278055 | 2020-06-27 | Coffee | Georgia | 13069 | 483 | 17 |
278056 | 278056 | 2020-06-27 | Colquitt | Georgia | 13071 | 895 | 18 |
278057 | 278057 | 2020-06-27 | Columbia | Georgia | 13073 | 410 | 9 |
278058 | 278058 | 2020-06-27 | Cook | Georgia | 13075 | 126 | 1 |
278059 | 278059 | 2020-06-27 | Coweta | Georgia | 13077 | 634 | 15 |
278060 | 278060 | 2020-06-27 | Crawford | Georgia | 13079 | 39 | 0 |
278061 | 278061 | 2020-06-27 | Crisp | Georgia | 13081 | 267 | 12 |
278062 | 278062 | 2020-06-27 | Dade | Georgia | 13083 | 63 | 1 |
278063 | 278063 | 2020-06-27 | Dawson | Georgia | 13085 | 131 | 3 |
278064 | 278064 | 2020-06-27 | DeKalb | Georgia | 13089 | 5404 | 171 |
278065 | 278065 | 2020-06-27 | Decatur | Georgia | 13087 | 249 | 8 |
278066 | 278066 | 2020-06-27 | Dodge | Georgia | 13091 | 88 | 2 |
278067 | 278067 | 2020-06-27 | Dooly | Georgia | 13093 | 200 | 12 |
278068 | 278068 | 2020-06-27 | Dougherty | Georgia | 13095 | 1883 | 154 |
278069 | 278069 | 2020-06-27 | Douglas | Georgia | 13097 | 864 | 36 |
278070 | 278070 | 2020-06-27 | Early | Georgia | 13099 | 260 | 31 |
278071 | 278071 | 2020-06-27 | Echols | Georgia | 13101 | 181 | 0 |
278072 | 278072 | 2020-06-27 | Effingham | Georgia | 13103 | 123 | 1 |
278073 | 278073 | 2020-06-27 | Elbert | Georgia | 13105 | 97 | 0 |
278074 | 278074 | 2020-06-27 | Emanuel | Georgia | 13107 | 101 | 3 |
278075 | 278075 | 2020-06-27 | Evans | Georgia | 13109 | 18 | 0 |
278076 | 278076 | 2020-06-27 | Fannin | Georgia | 13111 | 94 | 1 |
278077 | 278077 | 2020-06-27 | Fayette | Georgia | 13113 | 324 | 17 |
278078 | 278078 | 2020-06-27 | Floyd | Georgia | 13115 | 493 | 15 |
278079 | 278079 | 2020-06-27 | Forsyth | Georgia | 13117 | 778 | 15 |
278080 | 278080 | 2020-06-27 | Franklin | Georgia | 13119 | 181 | 1 |
278081 | 278081 | 2020-06-27 | Fulton | Georgia | 13121 | 6506 | 311 |
278082 | 278082 | 2020-06-27 | Gilmer | Georgia | 13123 | 181 | 2 |
278083 | 278083 | 2020-06-27 | Glascock | Georgia | 13125 | 5 | 0 |
278084 | 278084 | 2020-06-27 | Glynn | Georgia | 13127 | 538 | 4 |
278085 | 278085 | 2020-06-27 | Gordon | Georgia | 13129 | 345 | 18 |
278086 | 278086 | 2020-06-27 | Grady | Georgia | 13131 | 181 | 4 |
278087 | 278087 | 2020-06-27 | Greene | Georgia | 13133 | 97 | 9 |
278088 | 278088 | 2020-06-27 | Gwinnett | Georgia | 13135 | 7604 | 169 |
278089 | 278089 | 2020-06-27 | Habersham | Georgia | 13137 | 659 | 35 |
278090 | 278090 | 2020-06-27 | Hall | Georgia | 13139 | 3101 | 59 |
278091 | 278091 | 2020-06-27 | Hancock | Georgia | 13141 | 210 | 32 |
278092 | 278092 | 2020-06-27 | Haralson | Georgia | 13143 | 68 | 5 |
278093 | 278093 | 2020-06-27 | Harris | Georgia | 13145 | 304 | 9 |
278094 | 278094 | 2020-06-27 | Hart | Georgia | 13147 | 55 | 0 |
278095 | 278095 | 2020-06-27 | Heard | Georgia | 13149 | 48 | 3 |
278096 | 278096 | 2020-06-27 | Henry | Georgia | 13151 | 1128 | 33 |
278097 | 278097 | 2020-06-27 | Houston | Georgia | 13153 | 575 | 23 |
278098 | 278098 | 2020-06-27 | Irwin | Georgia | 13155 | 50 | 1 |
278099 | 278099 | 2020-06-27 | Jackson | Georgia | 13157 | 347 | 10 |
278100 | 278100 | 2020-06-27 | Jasper | Georgia | 13159 | 67 | 1 |
278101 | 278101 | 2020-06-27 | Jeff Davis | Georgia | 13161 | 79 | 2 |
278102 | 278102 | 2020-06-27 | Jefferson | Georgia | 13163 | 86 | 1 |
278103 | 278103 | 2020-06-27 | Jenkins | Georgia | 13165 | 94 | 11 |
278104 | 278104 | 2020-06-27 | Johnson | Georgia | 13167 | 85 | 2 |
278105 | 278105 | 2020-06-27 | Jones | Georgia | 13169 | 61 | 0 |
278106 | 278106 | 2020-06-27 | Lamar | Georgia | 13171 | 110 | 6 |
278107 | 278107 | 2020-06-27 | Lanier | Georgia | 13173 | 127 | 3 |
278108 | 278108 | 2020-06-27 | Laurens | Georgia | 13175 | 151 | 1 |
278109 | 278109 | 2020-06-27 | Lee | Georgia | 13177 | 385 | 22 |
278110 | 278110 | 2020-06-27 | Liberty | Georgia | 13179 | 114 | 1 |
278111 | 278111 | 2020-06-27 | Lincoln | Georgia | 13181 | 33 | 1 |
278112 | 278112 | 2020-06-27 | Long | Georgia | 13183 | 36 | 1 |
278113 | 278113 | 2020-06-27 | Lowndes | Georgia | 13185 | 1129 | 9 |
278114 | 278114 | 2020-06-27 | Lumpkin | Georgia | 13187 | 134 | 3 |
278115 | 278115 | 2020-06-27 | Macon | Georgia | 13193 | 113 | 9 |
278116 | 278116 | 2020-06-27 | Madison | Georgia | 13195 | 87 | 4 |
278117 | 278117 | 2020-06-27 | Marion | Georgia | 13197 | 78 | 2 |
278118 | 278118 | 2020-06-27 | McDuffie | Georgia | 13189 | 89 | 6 |
278119 | 278119 | 2020-06-27 | McIntosh | Georgia | 13191 | 30 | 1 |
278120 | 278120 | 2020-06-27 | Meriwether | Georgia | 13199 | 175 | 2 |
278121 | 278121 | 2020-06-27 | Miller | Georgia | 13201 | 47 | 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);