ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where date = "2020-10-15" 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 |
---|---|---|---|---|---|---|---|
632029 | 632029 | 2020-10-15 | Appling | Georgia | 13001 | 1191 | 34 |
632030 | 632030 | 2020-10-15 | Atkinson | Georgia | 13003 | 530 | 4 |
632031 | 632031 | 2020-10-15 | Bacon | Georgia | 13005 | 678 | 14 |
632032 | 632032 | 2020-10-15 | Baker | Georgia | 13007 | 97 | 6 |
632033 | 632033 | 2020-10-15 | Baldwin | Georgia | 13009 | 2305 | 62 |
632034 | 632034 | 2020-10-15 | Banks | Georgia | 13011 | 536 | 8 |
632035 | 632035 | 2020-10-15 | Barrow | Georgia | 13013 | 2546 | 47 |
632036 | 632036 | 2020-10-15 | Bartow | Georgia | 13015 | 3471 | 91 |
632037 | 632037 | 2020-10-15 | Ben Hill | Georgia | 13017 | 892 | 29 |
632038 | 632038 | 2020-10-15 | Berrien | Georgia | 13019 | 561 | 12 |
632039 | 632039 | 2020-10-15 | Bibb | Georgia | 13021 | 6526 | 187 |
632040 | 632040 | 2020-10-15 | Bleckley | Georgia | 13023 | 571 | 21 |
632041 | 632041 | 2020-10-15 | Brantley | Georgia | 13025 | 534 | 11 |
632042 | 632042 | 2020-10-15 | Brooks | Georgia | 13027 | 574 | 26 |
632043 | 632043 | 2020-10-15 | Bryan | Georgia | 13029 | 1266 | 13 |
632044 | 632044 | 2020-10-15 | Bulloch | Georgia | 13031 | 3303 | 32 |
632045 | 632045 | 2020-10-15 | Burke | Georgia | 13033 | 1035 | 11 |
632046 | 632046 | 2020-10-15 | Butts | Georgia | 13035 | 814 | 43 |
632047 | 632047 | 2020-10-15 | Calhoun | Georgia | 13037 | 275 | 9 |
632048 | 632048 | 2020-10-15 | Camden | Georgia | 13039 | 1394 | 16 |
632049 | 632049 | 2020-10-15 | Candler | Georgia | 13043 | 525 | 23 |
632050 | 632050 | 2020-10-15 | Carroll | Georgia | 13045 | 3608 | 74 |
632051 | 632051 | 2020-10-15 | Catoosa | Georgia | 13047 | 1324 | 19 |
632052 | 632052 | 2020-10-15 | Charlton | Georgia | 13049 | 715 | 9 |
632053 | 632053 | 2020-10-15 | Chatham | Georgia | 13051 | 9070 | 178 |
632054 | 632054 | 2020-10-15 | Chattahoochee | Georgia | 13053 | 1738 | 1 |
632055 | 632055 | 2020-10-15 | Chattooga | Georgia | 13055 | 886 | 26 |
632056 | 632056 | 2020-10-15 | Cherokee | Georgia | 13057 | 7128 | 98 |
632057 | 632057 | 2020-10-15 | Clarke | Georgia | 13059 | 6320 | 46 |
632058 | 632058 | 2020-10-15 | Clay | Georgia | 13061 | 124 | 3 |
632059 | 632059 | 2020-10-15 | Clayton | Georgia | 13063 | 8121 | 170 |
632060 | 632060 | 2020-10-15 | Clinch | Georgia | 13065 | 444 | 11 |
632061 | 632061 | 2020-10-15 | Cobb | Georgia | 13067 | 22613 | 444 |
632062 | 632062 | 2020-10-15 | Coffee | Georgia | 13069 | 2374 | 57 |
632063 | 632063 | 2020-10-15 | Colquitt | Georgia | 13071 | 2296 | 37 |
632064 | 632064 | 2020-10-15 | Columbia | Georgia | 13073 | 4477 | 62 |
632065 | 632065 | 2020-10-15 | Cook | Georgia | 13075 | 617 | 15 |
632066 | 632066 | 2020-10-15 | Coweta | Georgia | 13077 | 3538 | 58 |
632067 | 632067 | 2020-10-15 | Crawford | Georgia | 13079 | 203 | 6 |
632068 | 632068 | 2020-10-15 | Crisp | Georgia | 13081 | 772 | 20 |
632069 | 632069 | 2020-10-15 | Dade | Georgia | 13083 | 326 | 5 |
632070 | 632070 | 2020-10-15 | Dawson | Georgia | 13085 | 903 | 10 |
632071 | 632071 | 2020-10-15 | DeKalb | Georgia | 13089 | 20810 | 384 |
632072 | 632072 | 2020-10-15 | Decatur | Georgia | 13087 | 1311 | 34 |
632073 | 632073 | 2020-10-15 | Dodge | Georgia | 13091 | 697 | 13 |
632074 | 632074 | 2020-10-15 | Dooly | Georgia | 13093 | 402 | 14 |
632075 | 632075 | 2020-10-15 | Dougherty | Georgia | 13095 | 3411 | 189 |
632076 | 632076 | 2020-10-15 | Douglas | Georgia | 13097 | 4151 | 71 |
632077 | 632077 | 2020-10-15 | Early | Georgia | 13099 | 554 | 33 |
632078 | 632078 | 2020-10-15 | Echols | Georgia | 13101 | 251 | 2 |
632079 | 632079 | 2020-10-15 | Effingham | Georgia | 13103 | 1667 | 28 |
632080 | 632080 | 2020-10-15 | Elbert | Georgia | 13105 | 787 | 8 |
632081 | 632081 | 2020-10-15 | Emanuel | Georgia | 13107 | 1181 | 35 |
632082 | 632082 | 2020-10-15 | Evans | Georgia | 13109 | 479 | 6 |
632083 | 632083 | 2020-10-15 | Fannin | Georgia | 13111 | 785 | 28 |
632084 | 632084 | 2020-10-15 | Fayette | Georgia | 13113 | 2281 | 52 |
632085 | 632085 | 2020-10-15 | Floyd | Georgia | 13115 | 3596 | 51 |
632086 | 632086 | 2020-10-15 | Forsyth | Georgia | 13117 | 4765 | 48 |
632087 | 632087 | 2020-10-15 | Franklin | Georgia | 13119 | 837 | 16 |
632088 | 632088 | 2020-10-15 | Fulton | Georgia | 13121 | 31329 | 599 |
632089 | 632089 | 2020-10-15 | Gilmer | Georgia | 13123 | 1011 | 16 |
632090 | 632090 | 2020-10-15 | Glascock | Georgia | 13125 | 49 | 2 |
632091 | 632091 | 2020-10-15 | Glynn | Georgia | 13127 | 3646 | 99 |
632092 | 632092 | 2020-10-15 | Gordon | Georgia | 13129 | 2113 | 39 |
632093 | 632093 | 2020-10-15 | Grady | Georgia | 13131 | 867 | 23 |
632094 | 632094 | 2020-10-15 | Greene | Georgia | 13133 | 595 | 24 |
632095 | 632095 | 2020-10-15 | Gwinnett | Georgia | 13135 | 30904 | 428 |
632096 | 632096 | 2020-10-15 | Habersham | Georgia | 13137 | 1824 | 72 |
632097 | 632097 | 2020-10-15 | Hall | Georgia | 13139 | 10282 | 164 |
632098 | 632098 | 2020-10-15 | Hancock | Georgia | 13141 | 418 | 44 |
632099 | 632099 | 2020-10-15 | Haralson | Georgia | 13143 | 681 | 9 |
632100 | 632100 | 2020-10-15 | Harris | Georgia | 13145 | 863 | 25 |
632101 | 632101 | 2020-10-15 | Hart | Georgia | 13147 | 566 | 16 |
632102 | 632102 | 2020-10-15 | Heard | Georgia | 13149 | 240 | 6 |
632103 | 632103 | 2020-10-15 | Henry | Georgia | 13151 | 6285 | 106 |
632104 | 632104 | 2020-10-15 | Houston | Georgia | 13153 | 3586 | 86 |
632105 | 632105 | 2020-10-15 | Irwin | Georgia | 13155 | 362 | 6 |
632106 | 632106 | 2020-10-15 | Jackson | Georgia | 13157 | 2285 | 39 |
632107 | 632107 | 2020-10-15 | Jasper | Georgia | 13159 | 344 | 4 |
632108 | 632108 | 2020-10-15 | Jeff Davis | Georgia | 13161 | 849 | 22 |
632109 | 632109 | 2020-10-15 | Jefferson | Georgia | 13163 | 863 | 31 |
632110 | 632110 | 2020-10-15 | Jenkins | Georgia | 13165 | 464 | 31 |
632111 | 632111 | 2020-10-15 | Johnson | Georgia | 13167 | 479 | 22 |
632112 | 632112 | 2020-10-15 | Jones | Georgia | 13169 | 643 | 13 |
632113 | 632113 | 2020-10-15 | Lamar | Georgia | 13171 | 475 | 19 |
632114 | 632114 | 2020-10-15 | Lanier | Georgia | 13173 | 351 | 7 |
632115 | 632115 | 2020-10-15 | Laurens | Georgia | 13175 | 2112 | 82 |
632116 | 632116 | 2020-10-15 | Lee | Georgia | 13177 | 797 | 26 |
632117 | 632117 | 2020-10-15 | Liberty | Georgia | 13179 | 1196 | 24 |
632118 | 632118 | 2020-10-15 | Lincoln | Georgia | 13181 | 233 | 7 |
632119 | 632119 | 2020-10-15 | Long | Georgia | 13183 | 284 | 4 |
632120 | 632120 | 2020-10-15 | Lowndes | Georgia | 13185 | 4777 | 85 |
632121 | 632121 | 2020-10-15 | Lumpkin | Georgia | 13187 | 1009 | 14 |
632122 | 632122 | 2020-10-15 | Macon | Georgia | 13193 | 271 | 10 |
632123 | 632123 | 2020-10-15 | Madison | Georgia | 13195 | 808 | 11 |
632124 | 632124 | 2020-10-15 | Marion | Georgia | 13197 | 219 | 9 |
632125 | 632125 | 2020-10-15 | McDuffie | Georgia | 13189 | 710 | 14 |
632126 | 632126 | 2020-10-15 | McIntosh | Georgia | 13191 | 311 | 7 |
632127 | 632127 | 2020-10-15 | Meriwether | Georgia | 13199 | 662 | 14 |
632128 | 632128 | 2020-10-15 | Miller | Georgia | 13201 | 317 | 2 |
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);