ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Fayette" and fips = 1057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531217 | 531217 | 2020-09-14 | Fayette | Alabama | 1057 | 400 | 7 |
527980 | 527980 | 2020-09-13 | Fayette | Alabama | 1057 | 396 | 7 |
524744 | 524744 | 2020-09-12 | Fayette | Alabama | 1057 | 383 | 7 |
521508 | 521508 | 2020-09-11 | Fayette | Alabama | 1057 | 376 | 7 |
518271 | 518271 | 2020-09-10 | Fayette | Alabama | 1057 | 367 | 6 |
515036 | 515036 | 2020-09-09 | Fayette | Alabama | 1057 | 358 | 6 |
511803 | 511803 | 2020-09-08 | Fayette | Alabama | 1057 | 356 | 6 |
508570 | 508570 | 2020-09-07 | Fayette | Alabama | 1057 | 350 | 6 |
505338 | 505338 | 2020-09-06 | Fayette | Alabama | 1057 | 348 | 6 |
502104 | 502104 | 2020-09-05 | Fayette | Alabama | 1057 | 345 | 6 |
498870 | 498870 | 2020-09-04 | Fayette | Alabama | 1057 | 341 | 6 |
495637 | 495637 | 2020-09-03 | Fayette | Alabama | 1057 | 334 | 6 |
492403 | 492403 | 2020-09-02 | Fayette | Alabama | 1057 | 327 | 6 |
489170 | 489170 | 2020-09-01 | Fayette | Alabama | 1057 | 323 | 6 |
485937 | 485937 | 2020-08-31 | Fayette | Alabama | 1057 | 315 | 6 |
482702 | 482702 | 2020-08-30 | Fayette | Alabama | 1057 | 313 | 6 |
479468 | 479468 | 2020-08-29 | Fayette | Alabama | 1057 | 311 | 6 |
476235 | 476235 | 2020-08-28 | Fayette | Alabama | 1057 | 307 | 6 |
473002 | 473002 | 2020-08-27 | Fayette | Alabama | 1057 | 301 | 6 |
469770 | 469770 | 2020-08-26 | Fayette | Alabama | 1057 | 297 | 6 |
466541 | 466541 | 2020-08-25 | Fayette | Alabama | 1057 | 293 | 6 |
463312 | 463312 | 2020-08-24 | Fayette | Alabama | 1057 | 293 | 6 |
460083 | 460083 | 2020-08-23 | Fayette | Alabama | 1057 | 291 | 6 |
456856 | 456856 | 2020-08-22 | Fayette | Alabama | 1057 | 286 | 6 |
453628 | 453628 | 2020-08-21 | Fayette | Alabama | 1057 | 281 | 6 |
450400 | 450400 | 2020-08-20 | Fayette | Alabama | 1057 | 277 | 6 |
447172 | 447172 | 2020-08-19 | Fayette | Alabama | 1057 | 274 | 6 |
443945 | 443945 | 2020-08-18 | Fayette | Alabama | 1057 | 267 | 6 |
440719 | 440719 | 2020-08-17 | Fayette | Alabama | 1057 | 264 | 5 |
437493 | 437493 | 2020-08-16 | Fayette | Alabama | 1057 | 258 | 5 |
434267 | 434267 | 2020-08-15 | Fayette | Alabama | 1057 | 254 | 5 |
431042 | 431042 | 2020-08-14 | Fayette | Alabama | 1057 | 251 | 5 |
427814 | 427814 | 2020-08-13 | Fayette | Alabama | 1057 | 244 | 5 |
424590 | 424590 | 2020-08-12 | Fayette | Alabama | 1057 | 237 | 5 |
421369 | 421369 | 2020-08-11 | Fayette | Alabama | 1057 | 237 | 5 |
418148 | 418148 | 2020-08-10 | Fayette | Alabama | 1057 | 226 | 5 |
414927 | 414927 | 2020-08-09 | Fayette | Alabama | 1057 | 221 | 5 |
411707 | 411707 | 2020-08-08 | Fayette | Alabama | 1057 | 218 | 5 |
408488 | 408488 | 2020-08-07 | Fayette | Alabama | 1057 | 212 | 5 |
405268 | 405268 | 2020-08-06 | Fayette | Alabama | 1057 | 198 | 5 |
402050 | 402050 | 2020-08-05 | Fayette | Alabama | 1057 | 188 | 5 |
398834 | 398834 | 2020-08-04 | Fayette | Alabama | 1057 | 186 | 5 |
395618 | 395618 | 2020-08-03 | Fayette | Alabama | 1057 | 182 | 5 |
392402 | 392402 | 2020-08-02 | Fayette | Alabama | 1057 | 177 | 5 |
389185 | 389185 | 2020-08-01 | Fayette | Alabama | 1057 | 175 | 5 |
385968 | 385968 | 2020-07-31 | Fayette | Alabama | 1057 | 171 | 5 |
382750 | 382750 | 2020-07-30 | Fayette | Alabama | 1057 | 170 | 5 |
379533 | 379533 | 2020-07-29 | Fayette | Alabama | 1057 | 163 | 5 |
376317 | 376317 | 2020-07-28 | Fayette | Alabama | 1057 | 158 | 5 |
373103 | 373103 | 2020-07-27 | Fayette | Alabama | 1057 | 151 | 5 |
369891 | 369891 | 2020-07-26 | Fayette | Alabama | 1057 | 144 | 5 |
366681 | 366681 | 2020-07-25 | Fayette | Alabama | 1057 | 139 | 5 |
363474 | 363474 | 2020-07-24 | Fayette | Alabama | 1057 | 137 | 5 |
360268 | 360268 | 2020-07-23 | Fayette | Alabama | 1057 | 133 | 5 |
357063 | 357063 | 2020-07-22 | Fayette | Alabama | 1057 | 129 | 5 |
353860 | 353860 | 2020-07-21 | Fayette | Alabama | 1057 | 127 | 5 |
350658 | 350658 | 2020-07-20 | Fayette | Alabama | 1057 | 125 | 5 |
347457 | 347457 | 2020-07-19 | Fayette | Alabama | 1057 | 123 | 5 |
344257 | 344257 | 2020-07-18 | Fayette | Alabama | 1057 | 121 | 5 |
341058 | 341058 | 2020-07-17 | Fayette | Alabama | 1057 | 115 | 3 |
337862 | 337862 | 2020-07-16 | Fayette | Alabama | 1057 | 108 | 3 |
334667 | 334667 | 2020-07-15 | Fayette | Alabama | 1057 | 96 | 3 |
331474 | 331474 | 2020-07-14 | Fayette | Alabama | 1057 | 93 | 2 |
328288 | 328288 | 2020-07-13 | Fayette | Alabama | 1057 | 93 | 1 |
325102 | 325102 | 2020-07-12 | Fayette | Alabama | 1057 | 88 | 1 |
321921 | 321921 | 2020-07-11 | Fayette | Alabama | 1057 | 85 | 1 |
318742 | 318742 | 2020-07-10 | Fayette | Alabama | 1057 | 84 | 1 |
315569 | 315569 | 2020-07-09 | Fayette | Alabama | 1057 | 81 | 1 |
312394 | 312394 | 2020-07-08 | Fayette | Alabama | 1057 | 75 | 1 |
309225 | 309225 | 2020-07-07 | Fayette | Alabama | 1057 | 75 | 1 |
306056 | 306056 | 2020-07-06 | Fayette | Alabama | 1057 | 74 | 1 |
302892 | 302892 | 2020-07-05 | Fayette | Alabama | 1057 | 73 | 1 |
299728 | 299728 | 2020-07-04 | Fayette | Alabama | 1057 | 71 | 1 |
296566 | 296566 | 2020-07-03 | Fayette | Alabama | 1057 | 70 | 1 |
293411 | 293411 | 2020-07-02 | Fayette | Alabama | 1057 | 70 | 1 |
290258 | 290258 | 2020-07-01 | Fayette | Alabama | 1057 | 70 | 1 |
287108 | 287108 | 2020-06-30 | Fayette | Alabama | 1057 | 69 | 1 |
283962 | 283962 | 2020-06-29 | Fayette | Alabama | 1057 | 69 | 1 |
280816 | 280816 | 2020-06-28 | Fayette | Alabama | 1057 | 69 | 1 |
277668 | 277668 | 2020-06-27 | Fayette | Alabama | 1057 | 68 | 1 |
274520 | 274520 | 2020-06-26 | Fayette | Alabama | 1057 | 67 | 1 |
271380 | 271380 | 2020-06-25 | Fayette | Alabama | 1057 | 65 | 1 |
268246 | 268246 | 2020-06-24 | Fayette | Alabama | 1057 | 63 | 1 |
265117 | 265117 | 2020-06-23 | Fayette | Alabama | 1057 | 62 | 1 |
261988 | 261988 | 2020-06-22 | Fayette | Alabama | 1057 | 61 | 1 |
258861 | 258861 | 2020-06-21 | Fayette | Alabama | 1057 | 61 | 1 |
255734 | 255734 | 2020-06-20 | Fayette | Alabama | 1057 | 61 | 1 |
252615 | 252615 | 2020-06-19 | Fayette | Alabama | 1057 | 60 | 1 |
249500 | 249500 | 2020-06-18 | Fayette | Alabama | 1057 | 52 | 1 |
246388 | 246388 | 2020-06-17 | Fayette | Alabama | 1057 | 52 | 0 |
243275 | 243275 | 2020-06-16 | Fayette | Alabama | 1057 | 50 | 0 |
240164 | 240164 | 2020-06-15 | Fayette | Alabama | 1057 | 48 | 0 |
237056 | 237056 | 2020-06-14 | Fayette | Alabama | 1057 | 46 | 0 |
233949 | 233949 | 2020-06-13 | Fayette | Alabama | 1057 | 40 | 0 |
230844 | 230844 | 2020-06-12 | Fayette | Alabama | 1057 | 29 | 0 |
227740 | 227740 | 2020-06-11 | Fayette | Alabama | 1057 | 26 | 0 |
224639 | 224639 | 2020-06-10 | Fayette | Alabama | 1057 | 26 | 0 |
221543 | 221543 | 2020-06-09 | Fayette | Alabama | 1057 | 23 | 0 |
218451 | 218451 | 2020-06-08 | Fayette | Alabama | 1057 | 21 | 0 |
215361 | 215361 | 2020-06-07 | Fayette | Alabama | 1057 | 20 | 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);