ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Fayette" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637433 | 637433 | 2020-10-16 | Fayette | Tennessee | 47047 | 1456 | 21 |
634187 | 634187 | 2020-10-15 | Fayette | Tennessee | 47047 | 1453 | 21 |
630942 | 630942 | 2020-10-14 | Fayette | Tennessee | 47047 | 1432 | 21 |
627698 | 627698 | 2020-10-13 | Fayette | Tennessee | 47047 | 1414 | 23 |
624456 | 624456 | 2020-10-12 | Fayette | Tennessee | 47047 | 1404 | 23 |
621213 | 621213 | 2020-10-11 | Fayette | Tennessee | 47047 | 1369 | 23 |
617970 | 617970 | 2020-10-10 | Fayette | Tennessee | 47047 | 1362 | 23 |
614728 | 614728 | 2020-10-09 | Fayette | Tennessee | 47047 | 1354 | 23 |
611487 | 611487 | 2020-10-08 | Fayette | Tennessee | 47047 | 1340 | 23 |
608245 | 608245 | 2020-10-07 | Fayette | Tennessee | 47047 | 1319 | 22 |
605002 | 605002 | 2020-10-06 | Fayette | Tennessee | 47047 | 1313 | 22 |
601760 | 601760 | 2020-10-05 | Fayette | Tennessee | 47047 | 1301 | 21 |
598517 | 598517 | 2020-10-04 | Fayette | Tennessee | 47047 | 1282 | 21 |
595274 | 595274 | 2020-10-03 | Fayette | Tennessee | 47047 | 1254 | 21 |
592033 | 592033 | 2020-10-02 | Fayette | Tennessee | 47047 | 1241 | 21 |
588792 | 588792 | 2020-10-01 | Fayette | Tennessee | 47047 | 1239 | 21 |
585552 | 585552 | 2020-09-30 | Fayette | Tennessee | 47047 | 1236 | 21 |
582312 | 582312 | 2020-09-29 | Fayette | Tennessee | 47047 | 1227 | 19 |
579072 | 579072 | 2020-09-28 | Fayette | Tennessee | 47047 | 1206 | 19 |
575831 | 575831 | 2020-09-27 | Fayette | Tennessee | 47047 | 1204 | 19 |
572587 | 572587 | 2020-09-26 | Fayette | Tennessee | 47047 | 1188 | 19 |
569345 | 569345 | 2020-09-25 | Fayette | Tennessee | 47047 | 1183 | 19 |
566104 | 566104 | 2020-09-24 | Fayette | Tennessee | 47047 | 1174 | 18 |
562863 | 562863 | 2020-09-23 | Fayette | Tennessee | 47047 | 1167 | 18 |
559626 | 559626 | 2020-09-22 | Fayette | Tennessee | 47047 | 1144 | 18 |
556389 | 556389 | 2020-09-21 | Fayette | Tennessee | 47047 | 1143 | 18 |
553152 | 553152 | 2020-09-20 | Fayette | Tennessee | 47047 | 1139 | 18 |
549913 | 549913 | 2020-09-19 | Fayette | Tennessee | 47047 | 1111 | 18 |
546674 | 546674 | 2020-09-18 | Fayette | Tennessee | 47047 | 1110 | 17 |
543437 | 543437 | 2020-09-17 | Fayette | Tennessee | 47047 | 1092 | 16 |
540201 | 540201 | 2020-09-16 | Fayette | Tennessee | 47047 | 1088 | 16 |
536964 | 536964 | 2020-09-15 | Fayette | Tennessee | 47047 | 1063 | 16 |
533728 | 533728 | 2020-09-14 | Fayette | Tennessee | 47047 | 1063 | 14 |
530493 | 530493 | 2020-09-13 | Fayette | Tennessee | 47047 | 1040 | 14 |
527256 | 527256 | 2020-09-12 | Fayette | Tennessee | 47047 | 1039 | 14 |
524020 | 524020 | 2020-09-11 | Fayette | Tennessee | 47047 | 1030 | 14 |
520784 | 520784 | 2020-09-10 | Fayette | Tennessee | 47047 | 1021 | 13 |
517548 | 517548 | 2020-09-09 | Fayette | Tennessee | 47047 | 1008 | 12 |
514313 | 514313 | 2020-09-08 | Fayette | Tennessee | 47047 | 1008 | 12 |
511080 | 511080 | 2020-09-07 | Fayette | Tennessee | 47047 | 1005 | 11 |
507847 | 507847 | 2020-09-06 | Fayette | Tennessee | 47047 | 997 | 11 |
504615 | 504615 | 2020-09-05 | Fayette | Tennessee | 47047 | 983 | 11 |
501381 | 501381 | 2020-09-04 | Fayette | Tennessee | 47047 | 976 | 11 |
498147 | 498147 | 2020-09-03 | Fayette | Tennessee | 47047 | 973 | 11 |
494914 | 494914 | 2020-09-02 | Fayette | Tennessee | 47047 | 909 | 10 |
491680 | 491680 | 2020-09-01 | Fayette | Tennessee | 47047 | 888 | 10 |
488447 | 488447 | 2020-08-31 | Fayette | Tennessee | 47047 | 886 | 10 |
485214 | 485214 | 2020-08-30 | Fayette | Tennessee | 47047 | 882 | 10 |
481979 | 481979 | 2020-08-29 | Fayette | Tennessee | 47047 | 875 | 10 |
478745 | 478745 | 2020-08-28 | Fayette | Tennessee | 47047 | 873 | 10 |
475512 | 475512 | 2020-08-27 | Fayette | Tennessee | 47047 | 859 | 10 |
472279 | 472279 | 2020-08-26 | Fayette | Tennessee | 47047 | 851 | 10 |
469047 | 469047 | 2020-08-25 | Fayette | Tennessee | 47047 | 824 | 10 |
465818 | 465818 | 2020-08-24 | Fayette | Tennessee | 47047 | 820 | 10 |
462589 | 462589 | 2020-08-23 | Fayette | Tennessee | 47047 | 814 | 10 |
459361 | 459361 | 2020-08-22 | Fayette | Tennessee | 47047 | 806 | 10 |
456133 | 456133 | 2020-08-21 | Fayette | Tennessee | 47047 | 803 | 10 |
452905 | 452905 | 2020-08-20 | Fayette | Tennessee | 47047 | 797 | 10 |
449677 | 449677 | 2020-08-19 | Fayette | Tennessee | 47047 | 787 | 10 |
446449 | 446449 | 2020-08-18 | Fayette | Tennessee | 47047 | 766 | 10 |
443223 | 443223 | 2020-08-17 | Fayette | Tennessee | 47047 | 759 | 8 |
439996 | 439996 | 2020-08-16 | Fayette | Tennessee | 47047 | 755 | 8 |
436771 | 436771 | 2020-08-15 | Fayette | Tennessee | 47047 | 749 | 8 |
433544 | 433544 | 2020-08-14 | Fayette | Tennessee | 47047 | 744 | 8 |
430319 | 430319 | 2020-08-13 | Fayette | Tennessee | 47047 | 725 | 8 |
427092 | 427092 | 2020-08-12 | Fayette | Tennessee | 47047 | 718 | 8 |
423869 | 423869 | 2020-08-11 | Fayette | Tennessee | 47047 | 704 | 8 |
420647 | 420647 | 2020-08-10 | Fayette | Tennessee | 47047 | 702 | 8 |
417426 | 417426 | 2020-08-09 | Fayette | Tennessee | 47047 | 698 | 8 |
414205 | 414205 | 2020-08-08 | Fayette | Tennessee | 47047 | 686 | 8 |
410985 | 410985 | 2020-08-07 | Fayette | Tennessee | 47047 | 670 | 8 |
407766 | 407766 | 2020-08-06 | Fayette | Tennessee | 47047 | 652 | 8 |
404546 | 404546 | 2020-08-05 | Fayette | Tennessee | 47047 | 646 | 8 |
401328 | 401328 | 2020-08-04 | Fayette | Tennessee | 47047 | 642 | 8 |
398113 | 398113 | 2020-08-03 | Fayette | Tennessee | 47047 | 620 | 8 |
394896 | 394896 | 2020-08-02 | Fayette | Tennessee | 47047 | 617 | 8 |
391680 | 391680 | 2020-08-01 | Fayette | Tennessee | 47047 | 616 | 8 |
388463 | 388463 | 2020-07-31 | Fayette | Tennessee | 47047 | 596 | 8 |
385246 | 385246 | 2020-07-30 | Fayette | Tennessee | 47047 | 584 | 8 |
382028 | 382028 | 2020-07-29 | Fayette | Tennessee | 47047 | 574 | 8 |
378811 | 378811 | 2020-07-28 | Fayette | Tennessee | 47047 | 567 | 8 |
375595 | 375595 | 2020-07-27 | Fayette | Tennessee | 47047 | 541 | 8 |
372382 | 372382 | 2020-07-26 | Fayette | Tennessee | 47047 | 525 | 8 |
369170 | 369170 | 2020-07-25 | Fayette | Tennessee | 47047 | 519 | 8 |
365961 | 365961 | 2020-07-24 | Fayette | Tennessee | 47047 | 512 | 8 |
362755 | 362755 | 2020-07-23 | Fayette | Tennessee | 47047 | 510 | 8 |
359548 | 359548 | 2020-07-22 | Fayette | Tennessee | 47047 | 495 | 8 |
356344 | 356344 | 2020-07-21 | Fayette | Tennessee | 47047 | 495 | 7 |
353141 | 353141 | 2020-07-20 | Fayette | Tennessee | 47047 | 473 | 7 |
349938 | 349938 | 2020-07-19 | Fayette | Tennessee | 47047 | 465 | 7 |
346738 | 346738 | 2020-07-18 | Fayette | Tennessee | 47047 | 454 | 7 |
343538 | 343538 | 2020-07-17 | Fayette | Tennessee | 47047 | 433 | 7 |
340340 | 340340 | 2020-07-16 | Fayette | Tennessee | 47047 | 424 | 6 |
337143 | 337143 | 2020-07-15 | Fayette | Tennessee | 47047 | 404 | 6 |
333949 | 333949 | 2020-07-14 | Fayette | Tennessee | 47047 | 393 | 6 |
330757 | 330757 | 2020-07-13 | Fayette | Tennessee | 47047 | 380 | 5 |
327571 | 327571 | 2020-07-12 | Fayette | Tennessee | 47047 | 370 | 5 |
324386 | 324386 | 2020-07-11 | Fayette | Tennessee | 47047 | 368 | 5 |
321205 | 321205 | 2020-07-10 | Fayette | Tennessee | 47047 | 357 | 3 |
318027 | 318027 | 2020-07-09 | Fayette | Tennessee | 47047 | 346 | 3 |
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);