ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
160 rows where date = "2020-06-09" 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 |
---|---|---|---|---|---|---|---|
221895 | 221895 | 2020-06-09 | Appling | Georgia | 13001 | 197 | 13 |
221896 | 221896 | 2020-06-09 | Atkinson | Georgia | 13003 | 62 | 2 |
221897 | 221897 | 2020-06-09 | Bacon | Georgia | 13005 | 152 | 3 |
221898 | 221898 | 2020-06-09 | Baker | Georgia | 13007 | 37 | 3 |
221899 | 221899 | 2020-06-09 | Baldwin | Georgia | 13009 | 393 | 29 |
221900 | 221900 | 2020-06-09 | Banks | Georgia | 13011 | 99 | 1 |
221901 | 221901 | 2020-06-09 | Barrow | Georgia | 13013 | 356 | 20 |
221902 | 221902 | 2020-06-09 | Bartow | Georgia | 13015 | 527 | 39 |
221903 | 221903 | 2020-06-09 | Ben Hill | Georgia | 13017 | 93 | 1 |
221904 | 221904 | 2020-06-09 | Berrien | Georgia | 13019 | 59 | 0 |
221905 | 221905 | 2020-06-09 | Bibb | Georgia | 13021 | 511 | 31 |
221906 | 221906 | 2020-06-09 | Bleckley | Georgia | 13023 | 53 | 0 |
221907 | 221907 | 2020-06-09 | Brantley | Georgia | 13025 | 63 | 2 |
221908 | 221908 | 2020-06-09 | Brooks | Georgia | 13027 | 84 | 8 |
221909 | 221909 | 2020-06-09 | Bryan | Georgia | 13029 | 80 | 5 |
221910 | 221910 | 2020-06-09 | Bulloch | Georgia | 13031 | 84 | 3 |
221911 | 221911 | 2020-06-09 | Burke | Georgia | 13033 | 125 | 6 |
221912 | 221912 | 2020-06-09 | Butts | Georgia | 13035 | 253 | 25 |
221913 | 221913 | 2020-06-09 | Calhoun | Georgia | 13037 | 140 | 6 |
221914 | 221914 | 2020-06-09 | Camden | Georgia | 13039 | 70 | 1 |
221915 | 221915 | 2020-06-09 | Candler | Georgia | 13043 | 15 | 0 |
221916 | 221916 | 2020-06-09 | Carroll | Georgia | 13045 | 587 | 33 |
221917 | 221917 | 2020-06-09 | Catoosa | Georgia | 13047 | 164 | 0 |
221918 | 221918 | 2020-06-09 | Charlton | Georgia | 13049 | 36 | 1 |
221919 | 221919 | 2020-06-09 | Chatham | Georgia | 13051 | 556 | 29 |
221920 | 221920 | 2020-06-09 | Chattahoochee | Georgia | 13053 | 180 | 0 |
221921 | 221921 | 2020-06-09 | Chattooga | Georgia | 13055 | 27 | 2 |
221922 | 221922 | 2020-06-09 | Cherokee | Georgia | 13057 | 978 | 35 |
221923 | 221923 | 2020-06-09 | Clarke | Georgia | 13059 | 328 | 15 |
221924 | 221924 | 2020-06-09 | Clay | Georgia | 13061 | 49 | 2 |
221925 | 221925 | 2020-06-09 | Clayton | Georgia | 13063 | 1362 | 54 |
221926 | 221926 | 2020-06-09 | Clinch | Georgia | 13065 | 72 | 2 |
221927 | 221927 | 2020-06-09 | Cobb | Georgia | 13067 | 3337 | 203 |
221928 | 221928 | 2020-06-09 | Coffee | Georgia | 13069 | 307 | 14 |
221929 | 221929 | 2020-06-09 | Colquitt | Georgia | 13071 | 589 | 16 |
221930 | 221930 | 2020-06-09 | Columbia | Georgia | 13073 | 288 | 8 |
221931 | 221931 | 2020-06-09 | Cook | Georgia | 13075 | 57 | 1 |
221932 | 221932 | 2020-06-09 | Coweta | Georgia | 13077 | 474 | 10 |
221933 | 221933 | 2020-06-09 | Crawford | Georgia | 13079 | 31 | 0 |
221934 | 221934 | 2020-06-09 | Crisp | Georgia | 13081 | 239 | 8 |
221935 | 221935 | 2020-06-09 | Dade | Georgia | 13083 | 41 | 1 |
221936 | 221936 | 2020-06-09 | Dawson | Georgia | 13085 | 114 | 1 |
221937 | 221937 | 2020-06-09 | DeKalb | Georgia | 13089 | 4120 | 135 |
221938 | 221938 | 2020-06-09 | Decatur | Georgia | 13087 | 218 | 6 |
221939 | 221939 | 2020-06-09 | Dodge | Georgia | 13091 | 53 | 2 |
221940 | 221940 | 2020-06-09 | Dooly | Georgia | 13093 | 193 | 12 |
221941 | 221941 | 2020-06-09 | Dougherty | Georgia | 13095 | 1818 | 149 |
221942 | 221942 | 2020-06-09 | Douglas | Georgia | 13097 | 612 | 27 |
221943 | 221943 | 2020-06-09 | Early | Georgia | 13099 | 252 | 31 |
221944 | 221944 | 2020-06-09 | Echols | Georgia | 13101 | 146 | 0 |
221945 | 221945 | 2020-06-09 | Effingham | Georgia | 13103 | 81 | 1 |
221946 | 221946 | 2020-06-09 | Elbert | Georgia | 13105 | 82 | 0 |
221947 | 221947 | 2020-06-09 | Emanuel | Georgia | 13107 | 33 | 2 |
221948 | 221948 | 2020-06-09 | Evans | Georgia | 13109 | 6 | 0 |
221949 | 221949 | 2020-06-09 | Fannin | Georgia | 13111 | 57 | 1 |
221950 | 221950 | 2020-06-09 | Fayette | Georgia | 13113 | 254 | 15 |
221951 | 221951 | 2020-06-09 | Floyd | Georgia | 13115 | 335 | 15 |
221952 | 221952 | 2020-06-09 | Forsyth | Georgia | 13117 | 575 | 12 |
221953 | 221953 | 2020-06-09 | Franklin | Georgia | 13119 | 134 | 1 |
221954 | 221954 | 2020-06-09 | Fulton | Georgia | 13121 | 4925 | 272 |
221955 | 221955 | 2020-06-09 | Gilmer | Georgia | 13123 | 161 | 1 |
221956 | 221956 | 2020-06-09 | Glascock | Georgia | 13125 | 1 | 0 |
221957 | 221957 | 2020-06-09 | Glynn | Georgia | 13127 | 164 | 2 |
221958 | 221958 | 2020-06-09 | Gordon | Georgia | 13129 | 209 | 16 |
221959 | 221959 | 2020-06-09 | Grady | Georgia | 13131 | 127 | 4 |
221960 | 221960 | 2020-06-09 | Greene | Georgia | 13133 | 83 | 7 |
221961 | 221961 | 2020-06-09 | Gwinnett | Georgia | 13135 | 4692 | 143 |
221962 | 221962 | 2020-06-09 | Habersham | Georgia | 13137 | 568 | 26 |
221963 | 221963 | 2020-06-09 | Hall | Georgia | 13139 | 2664 | 51 |
221964 | 221964 | 2020-06-09 | Hancock | Georgia | 13141 | 200 | 29 |
221965 | 221965 | 2020-06-09 | Haralson | Georgia | 13143 | 54 | 4 |
221966 | 221966 | 2020-06-09 | Harris | Georgia | 13145 | 143 | 6 |
221967 | 221967 | 2020-06-09 | Hart | Georgia | 13147 | 39 | 0 |
221968 | 221968 | 2020-06-09 | Heard | Georgia | 13149 | 37 | 3 |
221969 | 221969 | 2020-06-09 | Henry | Georgia | 13151 | 779 | 22 |
221970 | 221970 | 2020-06-09 | Houston | Georgia | 13153 | 406 | 20 |
221971 | 221971 | 2020-06-09 | Irwin | Georgia | 13155 | 34 | 1 |
221972 | 221972 | 2020-06-09 | Jackson | Georgia | 13157 | 237 | 7 |
221973 | 221973 | 2020-06-09 | Jasper | Georgia | 13159 | 51 | 1 |
221974 | 221974 | 2020-06-09 | Jeff Davis | Georgia | 13161 | 48 | 1 |
221975 | 221975 | 2020-06-09 | Jefferson | Georgia | 13163 | 52 | 1 |
221976 | 221976 | 2020-06-09 | Jenkins | Georgia | 13165 | 33 | 2 |
221977 | 221977 | 2020-06-09 | Johnson | Georgia | 13167 | 83 | 2 |
221978 | 221978 | 2020-06-09 | Jones | Georgia | 13169 | 49 | 0 |
221979 | 221979 | 2020-06-09 | Lamar | Georgia | 13171 | 76 | 4 |
221980 | 221980 | 2020-06-09 | Lanier | Georgia | 13173 | 34 | 2 |
221981 | 221981 | 2020-06-09 | Laurens | Georgia | 13175 | 116 | 1 |
221982 | 221982 | 2020-06-09 | Lee | Georgia | 13177 | 368 | 22 |
221983 | 221983 | 2020-06-09 | Liberty | Georgia | 13179 | 86 | 1 |
221984 | 221984 | 2020-06-09 | Lincoln | Georgia | 13181 | 16 | 1 |
221985 | 221985 | 2020-06-09 | Long | Georgia | 13183 | 17 | 1 |
221986 | 221986 | 2020-06-09 | Lowndes | Georgia | 13185 | 474 | 4 |
221987 | 221987 | 2020-06-09 | Lumpkin | Georgia | 13187 | 103 | 1 |
221988 | 221988 | 2020-06-09 | Macon | Georgia | 13193 | 106 | 7 |
221989 | 221989 | 2020-06-09 | Madison | Georgia | 13195 | 66 | 2 |
221990 | 221990 | 2020-06-09 | Marion | Georgia | 13197 | 59 | 2 |
221991 | 221991 | 2020-06-09 | McDuffie | Georgia | 13189 | 73 | 5 |
221992 | 221992 | 2020-06-09 | McIntosh | Georgia | 13191 | 15 | 1 |
221993 | 221993 | 2020-06-09 | Meriwether | Georgia | 13199 | 110 | 2 |
221994 | 221994 | 2020-06-09 | Miller | Georgia | 13201 | 43 | 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);