ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where date = "2021-10-31" 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 |
---|---|---|---|---|---|---|---|
1868992 | 1868992 | 2021-10-31 | Appling | Georgia | 13001 | 3502 | 103 |
1868993 | 1868993 | 2021-10-31 | Atkinson | Georgia | 13003 | 1582 | 37 |
1868994 | 1868994 | 2021-10-31 | Bacon | Georgia | 13005 | 2569 | 61 |
1868995 | 1868995 | 2021-10-31 | Baker | Georgia | 13007 | 369 | 14 |
1868996 | 1868996 | 2021-10-31 | Baldwin | Georgia | 13009 | 6684 | 188 |
1868997 | 1868997 | 2021-10-31 | Banks | Georgia | 13011 | 2762 | 62 |
1868998 | 1868998 | 2021-10-31 | Barrow | Georgia | 13013 | 14722 | 197 |
1868999 | 1868999 | 2021-10-31 | Bartow | Georgia | 13015 | 20537 | 345 |
1869000 | 1869000 | 2021-10-31 | Ben Hill | Georgia | 13017 | 3232 | 101 |
1869001 | 1869001 | 2021-10-31 | Berrien | Georgia | 13019 | 3483 | 67 |
1869002 | 1869002 | 2021-10-31 | Bibb | Georgia | 13021 | 25444 | 629 |
1869003 | 1869003 | 2021-10-31 | Bleckley | Georgia | 13023 | 2327 | 74 |
1869004 | 1869004 | 2021-10-31 | Brantley | Georgia | 13025 | 3118 | 87 |
1869005 | 1869005 | 2021-10-31 | Brooks | Georgia | 13027 | 2412 | 70 |
1869006 | 1869006 | 2021-10-31 | Bryan | Georgia | 13029 | 6272 | 67 |
1869007 | 1869007 | 2021-10-31 | Bulloch | Georgia | 13031 | 11166 | 200 |
1869008 | 1869008 | 2021-10-31 | Burke | Georgia | 13033 | 3748 | 84 |
1869009 | 1869009 | 2021-10-31 | Butts | Georgia | 13035 | 4673 | 114 |
1869010 | 1869010 | 2021-10-31 | Calhoun | Georgia | 13037 | 853 | 21 |
1869011 | 1869011 | 2021-10-31 | Camden | Georgia | 13039 | 7909 | 94 |
1869012 | 1869012 | 2021-10-31 | Candler | Georgia | 13043 | 1572 | 87 |
1869013 | 1869013 | 2021-10-31 | Carroll | Georgia | 13045 | 16402 | 307 |
1869014 | 1869014 | 2021-10-31 | Catoosa | Georgia | 13047 | 9594 | 108 |
1869015 | 1869015 | 2021-10-31 | Charlton | Georgia | 13049 | 2299 | 55 |
1869016 | 1869016 | 2021-10-31 | Chatham | Georgia | 13051 | 38581 | 685 |
1869017 | 1869017 | 2021-10-31 | Chattahoochee | Georgia | 13053 | 5923 | 19 |
1869018 | 1869018 | 2021-10-31 | Chattooga | Georgia | 13055 | 4582 | 104 |
1869019 | 1869019 | 2021-10-31 | Cherokee | Georgia | 13057 | 44099 | 449 |
1869020 | 1869020 | 2021-10-31 | Clarke | Georgia | 13059 | 20049 | 179 |
1869021 | 1869021 | 2021-10-31 | Clay | Georgia | 13061 | 314 | 4 |
1869022 | 1869022 | 2021-10-31 | Clayton | Georgia | 13063 | 39321 | 722 |
1869023 | 1869023 | 2021-10-31 | Clinch | Georgia | 13065 | 1490 | 35 |
1869024 | 1869024 | 2021-10-31 | Cobb | Georgia | 13067 | 109556 | 1388 |
1869025 | 1869025 | 2021-10-31 | Coffee | Georgia | 13069 | 7961 | 224 |
1869026 | 1869026 | 2021-10-31 | Colquitt | Georgia | 13071 | 7699 | 185 |
1869027 | 1869027 | 2021-10-31 | Columbia | Georgia | 13073 | 24890 | 295 |
1869028 | 1869028 | 2021-10-31 | Cook | Georgia | 13075 | 3597 | 62 |
1869029 | 1869029 | 2021-10-31 | Coweta | Georgia | 13077 | 20818 | 365 |
1869030 | 1869030 | 2021-10-31 | Crawford | Georgia | 13079 | 1134 | 43 |
1869031 | 1869031 | 2021-10-31 | Crisp | Georgia | 13081 | 3149 | 109 |
1869032 | 1869032 | 2021-10-31 | Dade | Georgia | 13083 | 2173 | 20 |
1869033 | 1869033 | 2021-10-31 | Dawson | Georgia | 13085 | 4702 | 70 |
1869034 | 1869034 | 2021-10-31 | DeKalb | Georgia | 13089 | 92245 | 1327 |
1869035 | 1869035 | 2021-10-31 | Decatur | Georgia | 13087 | 4788 | 98 |
1869036 | 1869036 | 2021-10-31 | Dodge | Georgia | 13091 | 3617 | 126 |
1869037 | 1869037 | 2021-10-31 | Dooly | Georgia | 13093 | 1652 | 59 |
1869038 | 1869038 | 2021-10-31 | Dougherty | Georgia | 13095 | 12466 | 410 |
1869039 | 1869039 | 2021-10-31 | Douglas | Georgia | 13097 | 22292 | 292 |
1869040 | 1869040 | 2021-10-31 | Early | Georgia | 13099 | 1895 | 57 |
1869041 | 1869041 | 2021-10-31 | Echols | Georgia | 13101 | 722 | 11 |
1869042 | 1869042 | 2021-10-31 | Effingham | Georgia | 13103 | 8836 | 165 |
1869043 | 1869043 | 2021-10-31 | Elbert | Georgia | 13105 | 3266 | 86 |
1869044 | 1869044 | 2021-10-31 | Emanuel | Georgia | 13107 | 4427 | 131 |
1869045 | 1869045 | 2021-10-31 | Evans | Georgia | 13109 | 1617 | 53 |
1869046 | 1869046 | 2021-10-31 | Fannin | Georgia | 13111 | 3773 | 106 |
1869047 | 1869047 | 2021-10-31 | Fayette | Georgia | 13113 | 13177 | 234 |
1869048 | 1869048 | 2021-10-31 | Floyd | Georgia | 13115 | 18405 | 377 |
1869049 | 1869049 | 2021-10-31 | Forsyth | Georgia | 13117 | 34344 | 272 |
1869050 | 1869050 | 2021-10-31 | Franklin | Georgia | 13119 | 3967 | 82 |
1869051 | 1869051 | 2021-10-31 | Fulton | Georgia | 13121 | 132239 | 1776 |
1869052 | 1869052 | 2021-10-31 | Gilmer | Georgia | 13123 | 4703 | 135 |
1869053 | 1869053 | 2021-10-31 | Glascock | Georgia | 13125 | 416 | 20 |
1869054 | 1869054 | 2021-10-31 | Glynn | Georgia | 13127 | 15335 | 336 |
1869055 | 1869055 | 2021-10-31 | Gordon | Georgia | 13129 | 11361 | 194 |
1869056 | 1869056 | 2021-10-31 | Grady | Georgia | 13131 | 3635 | 88 |
1869057 | 1869057 | 2021-10-31 | Greene | Georgia | 13133 | 2717 | 70 |
1869058 | 1869058 | 2021-10-31 | Gwinnett | Georgia | 13135 | 133181 | 1454 |
1869059 | 1869059 | 2021-10-31 | Habersham | Georgia | 13137 | 7548 | 206 |
1869060 | 1869060 | 2021-10-31 | Hall | Georgia | 13139 | 38271 | 639 |
1869061 | 1869061 | 2021-10-31 | Hancock | Georgia | 13141 | 1124 | 81 |
1869062 | 1869062 | 2021-10-31 | Haralson | Georgia | 13143 | 3817 | 119 |
1869063 | 1869063 | 2021-10-31 | Harris | Georgia | 13145 | 3783 | 86 |
1869064 | 1869064 | 2021-10-31 | Hart | Georgia | 13147 | 3555 | 68 |
1869065 | 1869065 | 2021-10-31 | Heard | Georgia | 13149 | 1471 | 37 |
1869066 | 1869066 | 2021-10-31 | Henry | Georgia | 13151 | 38173 | 500 |
1869067 | 1869067 | 2021-10-31 | Houston | Georgia | 13153 | 24937 | 378 |
1869068 | 1869068 | 2021-10-31 | Irwin | Georgia | 13155 | 1448 | 39 |
1869069 | 1869069 | 2021-10-31 | Jackson | Georgia | 13157 | 14767 | 213 |
1869070 | 1869070 | 2021-10-31 | Jasper | Georgia | 13159 | 2131 | 59 |
1869071 | 1869071 | 2021-10-31 | Jeff Davis | Georgia | 13161 | 2951 | 57 |
1869072 | 1869072 | 2021-10-31 | Jefferson | Georgia | 13163 | 2692 | 86 |
1869073 | 1869073 | 2021-10-31 | Jenkins | Georgia | 13165 | 1190 | 57 |
1869074 | 1869074 | 2021-10-31 | Johnson | Georgia | 13167 | 1558 | 62 |
1869075 | 1869075 | 2021-10-31 | Jones | Georgia | 13169 | 3439 | 93 |
1869076 | 1869076 | 2021-10-31 | Lamar | Georgia | 13171 | 3414 | 90 |
1869077 | 1869077 | 2021-10-31 | Lanier | Georgia | 13173 | 1474 | 17 |
1869078 | 1869078 | 2021-10-31 | Laurens | Georgia | 13175 | 9131 | 239 |
1869079 | 1869079 | 2021-10-31 | Lee | Georgia | 13177 | 4720 | 80 |
1869080 | 1869080 | 2021-10-31 | Liberty | Georgia | 13179 | 7518 | 114 |
1869081 | 1869081 | 2021-10-31 | Lincoln | Georgia | 13181 | 1189 | 33 |
1869082 | 1869082 | 2021-10-31 | Long | Georgia | 13183 | 1751 | 26 |
1869083 | 1869083 | 2021-10-31 | Lowndes | Georgia | 13185 | 21235 | 309 |
1869084 | 1869084 | 2021-10-31 | Lumpkin | Georgia | 13187 | 4836 | 106 |
1869085 | 1869085 | 2021-10-31 | Macon | Georgia | 13193 | 1325 | 43 |
1869086 | 1869086 | 2021-10-31 | Madison | Georgia | 13195 | 4978 | 75 |
1869087 | 1869087 | 2021-10-31 | Marion | Georgia | 13197 | 969 | 39 |
1869088 | 1869088 | 2021-10-31 | McDuffie | Georgia | 13189 | 3517 | 75 |
1869089 | 1869089 | 2021-10-31 | McIntosh | Georgia | 13191 | 1705 | 31 |
1869090 | 1869090 | 2021-10-31 | Meriwether | Georgia | 13199 | 2971 | 111 |
1869091 | 1869091 | 2021-10-31 | Miller | Georgia | 13201 | 1221 | 22 |
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);