ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Fayette" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386383 | 386383 | 2020-07-31 | Fayette | Georgia | 13113 | 918 | 24 |
383165 | 383165 | 2020-07-30 | Fayette | Georgia | 13113 | 898 | 24 |
379948 | 379948 | 2020-07-29 | Fayette | Georgia | 13113 | 873 | 24 |
376731 | 376731 | 2020-07-28 | Fayette | Georgia | 13113 | 855 | 23 |
373517 | 373517 | 2020-07-27 | Fayette | Georgia | 13113 | 825 | 23 |
370305 | 370305 | 2020-07-26 | Fayette | Georgia | 13113 | 805 | 23 |
367095 | 367095 | 2020-07-25 | Fayette | Georgia | 13113 | 788 | 23 |
363888 | 363888 | 2020-07-24 | Fayette | Georgia | 13113 | 764 | 23 |
360681 | 360681 | 2020-07-23 | Fayette | Georgia | 13113 | 742 | 21 |
357476 | 357476 | 2020-07-22 | Fayette | Georgia | 13113 | 702 | 21 |
354273 | 354273 | 2020-07-21 | Fayette | Georgia | 13113 | 693 | 21 |
351071 | 351071 | 2020-07-20 | Fayette | Georgia | 13113 | 669 | 20 |
347870 | 347870 | 2020-07-19 | Fayette | Georgia | 13113 | 654 | 20 |
344670 | 344670 | 2020-07-18 | Fayette | Georgia | 13113 | 629 | 20 |
341471 | 341471 | 2020-07-17 | Fayette | Georgia | 13113 | 612 | 20 |
338274 | 338274 | 2020-07-16 | Fayette | Georgia | 13113 | 584 | 20 |
335079 | 335079 | 2020-07-15 | Fayette | Georgia | 13113 | 565 | 20 |
331886 | 331886 | 2020-07-14 | Fayette | Georgia | 13113 | 549 | 19 |
328699 | 328699 | 2020-07-13 | Fayette | Georgia | 13113 | 532 | 19 |
325513 | 325513 | 2020-07-12 | Fayette | Georgia | 13113 | 514 | 19 |
322332 | 322332 | 2020-07-11 | Fayette | Georgia | 13113 | 509 | 19 |
319153 | 319153 | 2020-07-10 | Fayette | Georgia | 13113 | 498 | 19 |
315980 | 315980 | 2020-07-09 | Fayette | Georgia | 13113 | 476 | 19 |
312805 | 312805 | 2020-07-08 | Fayette | Georgia | 13113 | 472 | 19 |
309635 | 309635 | 2020-07-07 | Fayette | Georgia | 13113 | 458 | 19 |
306467 | 306467 | 2020-07-06 | Fayette | Georgia | 13113 | 422 | 19 |
303303 | 303303 | 2020-07-05 | Fayette | Georgia | 13113 | 414 | 19 |
300139 | 300139 | 2020-07-04 | Fayette | Georgia | 13113 | 408 | 19 |
296977 | 296977 | 2020-07-03 | Fayette | Georgia | 13113 | 384 | 19 |
293821 | 293821 | 2020-07-02 | Fayette | Georgia | 13113 | 363 | 19 |
290667 | 290667 | 2020-07-01 | Fayette | Georgia | 13113 | 346 | 19 |
287516 | 287516 | 2020-06-30 | Fayette | Georgia | 13113 | 341 | 17 |
284370 | 284370 | 2020-06-29 | Fayette | Georgia | 13113 | 326 | 17 |
281224 | 281224 | 2020-06-28 | Fayette | Georgia | 13113 | 326 | 17 |
278077 | 278077 | 2020-06-27 | Fayette | Georgia | 13113 | 324 | 17 |
274929 | 274929 | 2020-06-26 | Fayette | Georgia | 13113 | 322 | 17 |
271789 | 271789 | 2020-06-25 | Fayette | Georgia | 13113 | 314 | 17 |
268653 | 268653 | 2020-06-24 | Fayette | Georgia | 13113 | 305 | 16 |
265523 | 265523 | 2020-06-23 | Fayette | Georgia | 13113 | 299 | 16 |
262395 | 262395 | 2020-06-22 | Fayette | Georgia | 13113 | 292 | 16 |
259268 | 259268 | 2020-06-21 | Fayette | Georgia | 13113 | 280 | 16 |
256141 | 256141 | 2020-06-20 | Fayette | Georgia | 13113 | 279 | 16 |
253022 | 253022 | 2020-06-19 | Fayette | Georgia | 13113 | 278 | 16 |
249907 | 249907 | 2020-06-18 | Fayette | Georgia | 13113 | 271 | 16 |
246795 | 246795 | 2020-06-17 | Fayette | Georgia | 13113 | 271 | 16 |
243682 | 243682 | 2020-06-16 | Fayette | Georgia | 13113 | 270 | 16 |
240571 | 240571 | 2020-06-15 | Fayette | Georgia | 13113 | 261 | 15 |
237463 | 237463 | 2020-06-14 | Fayette | Georgia | 13113 | 261 | 14 |
234356 | 234356 | 2020-06-13 | Fayette | Georgia | 13113 | 260 | 14 |
231250 | 231250 | 2020-06-12 | Fayette | Georgia | 13113 | 259 | 14 |
228147 | 228147 | 2020-06-11 | Fayette | Georgia | 13113 | 258 | 14 |
225045 | 225045 | 2020-06-10 | Fayette | Georgia | 13113 | 254 | 14 |
221950 | 221950 | 2020-06-09 | Fayette | Georgia | 13113 | 254 | 15 |
218855 | 218855 | 2020-06-08 | Fayette | Georgia | 13113 | 247 | 15 |
215764 | 215764 | 2020-06-07 | Fayette | Georgia | 13113 | 245 | 15 |
212677 | 212677 | 2020-06-06 | Fayette | Georgia | 13113 | 245 | 15 |
209592 | 209592 | 2020-06-05 | Fayette | Georgia | 13113 | 244 | 15 |
206511 | 206511 | 2020-06-04 | Fayette | Georgia | 13113 | 241 | 13 |
203431 | 203431 | 2020-06-03 | Fayette | Georgia | 13113 | 239 | 13 |
200355 | 200355 | 2020-06-02 | Fayette | Georgia | 13113 | 237 | 13 |
197282 | 197282 | 2020-06-01 | Fayette | Georgia | 13113 | 235 | 13 |
194212 | 194212 | 2020-05-31 | Fayette | Georgia | 13113 | 235 | 13 |
191145 | 191145 | 2020-05-30 | Fayette | Georgia | 13113 | 235 | 13 |
188080 | 188080 | 2020-05-29 | Fayette | Georgia | 13113 | 234 | 13 |
185024 | 185024 | 2020-05-28 | Fayette | Georgia | 13113 | 231 | 13 |
181970 | 181970 | 2020-05-27 | Fayette | Georgia | 13113 | 235 | 13 |
178926 | 178926 | 2020-05-26 | Fayette | Georgia | 13113 | 232 | 13 |
175882 | 175882 | 2020-05-25 | Fayette | Georgia | 13113 | 221 | 13 |
172839 | 172839 | 2020-05-24 | Fayette | Georgia | 13113 | 220 | 11 |
169798 | 169798 | 2020-05-23 | Fayette | Georgia | 13113 | 219 | 11 |
166761 | 166761 | 2020-05-22 | Fayette | Georgia | 13113 | 215 | 11 |
163728 | 163728 | 2020-05-21 | Fayette | Georgia | 13113 | 212 | 11 |
160700 | 160700 | 2020-05-20 | Fayette | Georgia | 13113 | 215 | 11 |
157674 | 157674 | 2020-05-19 | Fayette | Georgia | 13113 | 212 | 11 |
154658 | 154658 | 2020-05-18 | Fayette | Georgia | 13113 | 210 | 11 |
151646 | 151646 | 2020-05-17 | Fayette | Georgia | 13113 | 207 | 11 |
148637 | 148637 | 2020-05-16 | Fayette | Georgia | 13113 | 206 | 11 |
145634 | 145634 | 2020-05-15 | Fayette | Georgia | 13113 | 205 | 11 |
142634 | 142634 | 2020-05-14 | Fayette | Georgia | 13113 | 204 | 11 |
139638 | 139638 | 2020-05-13 | Fayette | Georgia | 13113 | 202 | 12 |
136647 | 136647 | 2020-05-12 | Fayette | Georgia | 13113 | 202 | 12 |
133658 | 133658 | 2020-05-11 | Fayette | Georgia | 13113 | 201 | 12 |
130667 | 130667 | 2020-05-10 | Fayette | Georgia | 13113 | 199 | 12 |
127676 | 127676 | 2020-05-09 | Fayette | Georgia | 13113 | 195 | 12 |
124689 | 124689 | 2020-05-08 | Fayette | Georgia | 13113 | 190 | 12 |
121710 | 121710 | 2020-05-07 | Fayette | Georgia | 13113 | 191 | 12 |
118741 | 118741 | 2020-05-06 | Fayette | Georgia | 13113 | 188 | 11 |
115781 | 115781 | 2020-05-05 | Fayette | Georgia | 13113 | 189 | 10 |
112898 | 112898 | 2020-05-04 | Fayette | Georgia | 13113 | 187 | 10 |
110023 | 110023 | 2020-05-03 | Fayette | Georgia | 13113 | 183 | 10 |
107154 | 107154 | 2020-05-02 | Fayette | Georgia | 13113 | 181 | 10 |
104289 | 104289 | 2020-05-01 | Fayette | Georgia | 13113 | 178 | 10 |
101434 | 101434 | 2020-04-30 | Fayette | Georgia | 13113 | 176 | 10 |
98584 | 98584 | 2020-04-29 | Fayette | Georgia | 13113 | 176 | 10 |
95739 | 95739 | 2020-04-28 | Fayette | Georgia | 13113 | 171 | 9 |
92907 | 92907 | 2020-04-27 | Fayette | Georgia | 13113 | 169 | 8 |
90088 | 90088 | 2020-04-26 | Fayette | Georgia | 13113 | 161 | 8 |
87272 | 87272 | 2020-04-25 | Fayette | Georgia | 13113 | 161 | 8 |
84463 | 84463 | 2020-04-24 | Fayette | Georgia | 13113 | 158 | 8 |
81663 | 81663 | 2020-04-23 | Fayette | Georgia | 13113 | 156 | 8 |
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);