ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Union" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923049 | 923049 | 2021-01-12 | Union | Tennessee | 47173 | 1340 | 20 |
919804 | 919804 | 2021-01-11 | Union | Tennessee | 47173 | 1340 | 20 |
916559 | 916559 | 2021-01-10 | Union | Tennessee | 47173 | 1334 | 20 |
913314 | 913314 | 2021-01-09 | Union | Tennessee | 47173 | 1327 | 20 |
910069 | 910069 | 2021-01-08 | Union | Tennessee | 47173 | 1319 | 20 |
906824 | 906824 | 2021-01-07 | Union | Tennessee | 47173 | 1312 | 19 |
903578 | 903578 | 2021-01-06 | Union | Tennessee | 47173 | 1289 | 19 |
900333 | 900333 | 2021-01-05 | Union | Tennessee | 47173 | 1279 | 18 |
897088 | 897088 | 2021-01-04 | Union | Tennessee | 47173 | 1269 | 17 |
893842 | 893842 | 2021-01-03 | Union | Tennessee | 47173 | 1259 | 17 |
890596 | 890596 | 2021-01-02 | Union | Tennessee | 47173 | 1255 | 17 |
887349 | 887349 | 2021-01-01 | Union | Tennessee | 47173 | 1221 | 17 |
884104 | 884104 | 2020-12-31 | Union | Tennessee | 47173 | 1221 | 17 |
880859 | 880859 | 2020-12-30 | Union | Tennessee | 47173 | 1208 | 14 |
877614 | 877614 | 2020-12-29 | Union | Tennessee | 47173 | 1197 | 14 |
874369 | 874369 | 2020-12-28 | Union | Tennessee | 47173 | 1189 | 14 |
871124 | 871124 | 2020-12-27 | Union | Tennessee | 47173 | 1182 | 12 |
867879 | 867879 | 2020-12-26 | Union | Tennessee | 47173 | 1174 | 12 |
864634 | 864634 | 2020-12-25 | Union | Tennessee | 47173 | 1169 | 12 |
861389 | 861389 | 2020-12-24 | Union | Tennessee | 47173 | 1150 | 12 |
858144 | 858144 | 2020-12-23 | Union | Tennessee | 47173 | 1142 | 12 |
854899 | 854899 | 2020-12-22 | Union | Tennessee | 47173 | 1130 | 9 |
851654 | 851654 | 2020-12-21 | Union | Tennessee | 47173 | 1123 | 7 |
848409 | 848409 | 2020-12-20 | Union | Tennessee | 47173 | 1102 | 7 |
845164 | 845164 | 2020-12-19 | Union | Tennessee | 47173 | 1086 | 7 |
841918 | 841918 | 2020-12-18 | Union | Tennessee | 47173 | 1069 | 7 |
838673 | 838673 | 2020-12-17 | Union | Tennessee | 47173 | 1045 | 7 |
835427 | 835427 | 2020-12-16 | Union | Tennessee | 47173 | 1045 | 7 |
832181 | 832181 | 2020-12-15 | Union | Tennessee | 47173 | 1025 | 7 |
828934 | 828934 | 2020-12-14 | Union | Tennessee | 47173 | 1013 | 6 |
825688 | 825688 | 2020-12-13 | Union | Tennessee | 47173 | 952 | 6 |
822441 | 822441 | 2020-12-12 | Union | Tennessee | 47173 | 895 | 6 |
819195 | 819195 | 2020-12-11 | Union | Tennessee | 47173 | 880 | 6 |
815949 | 815949 | 2020-12-10 | Union | Tennessee | 47173 | 862 | 6 |
812703 | 812703 | 2020-12-09 | Union | Tennessee | 47173 | 847 | 5 |
809459 | 809459 | 2020-12-08 | Union | Tennessee | 47173 | 820 | 5 |
806214 | 806214 | 2020-12-07 | Union | Tennessee | 47173 | 804 | 5 |
802969 | 802969 | 2020-12-06 | Union | Tennessee | 47173 | 787 | 5 |
799724 | 799724 | 2020-12-05 | Union | Tennessee | 47173 | 780 | 5 |
796479 | 796479 | 2020-12-04 | Union | Tennessee | 47173 | 771 | 5 |
793234 | 793234 | 2020-12-03 | Union | Tennessee | 47173 | 766 | 5 |
789989 | 789989 | 2020-12-02 | Union | Tennessee | 47173 | 759 | 5 |
786744 | 786744 | 2020-12-01 | Union | Tennessee | 47173 | 753 | 5 |
783500 | 783500 | 2020-11-30 | Union | Tennessee | 47173 | 737 | 5 |
780255 | 780255 | 2020-11-29 | Union | Tennessee | 47173 | 722 | 5 |
777009 | 777009 | 2020-11-28 | Union | Tennessee | 47173 | 719 | 5 |
773764 | 773764 | 2020-11-27 | Union | Tennessee | 47173 | 706 | 5 |
770519 | 770519 | 2020-11-26 | Union | Tennessee | 47173 | 704 | 5 |
767273 | 767273 | 2020-11-25 | Union | Tennessee | 47173 | 700 | 5 |
764028 | 764028 | 2020-11-24 | Union | Tennessee | 47173 | 694 | 5 |
760783 | 760783 | 2020-11-23 | Union | Tennessee | 47173 | 691 | 5 |
757538 | 757538 | 2020-11-22 | Union | Tennessee | 47173 | 686 | 5 |
754291 | 754291 | 2020-11-21 | Union | Tennessee | 47173 | 673 | 5 |
751045 | 751045 | 2020-11-20 | Union | Tennessee | 47173 | 669 | 5 |
747799 | 747799 | 2020-11-19 | Union | Tennessee | 47173 | 666 | 5 |
744553 | 744553 | 2020-11-18 | Union | Tennessee | 47173 | 662 | 5 |
741306 | 741306 | 2020-11-17 | Union | Tennessee | 47173 | 657 | 5 |
738060 | 738060 | 2020-11-16 | Union | Tennessee | 47173 | 651 | 5 |
734816 | 734816 | 2020-11-15 | Union | Tennessee | 47173 | 639 | 5 |
731570 | 731570 | 2020-11-14 | Union | Tennessee | 47173 | 628 | 5 |
728326 | 728326 | 2020-11-13 | Union | Tennessee | 47173 | 611 | 5 |
725082 | 725082 | 2020-11-12 | Union | Tennessee | 47173 | 610 | 5 |
721839 | 721839 | 2020-11-11 | Union | Tennessee | 47173 | 604 | 5 |
718596 | 718596 | 2020-11-10 | Union | Tennessee | 47173 | 601 | 5 |
715353 | 715353 | 2020-11-09 | Union | Tennessee | 47173 | 596 | 5 |
712109 | 712109 | 2020-11-08 | Union | Tennessee | 47173 | 591 | 5 |
708865 | 708865 | 2020-11-07 | Union | Tennessee | 47173 | 582 | 5 |
705622 | 705622 | 2020-11-06 | Union | Tennessee | 47173 | 577 | 5 |
702379 | 702379 | 2020-11-05 | Union | Tennessee | 47173 | 573 | 4 |
699135 | 699135 | 2020-11-04 | Union | Tennessee | 47173 | 571 | 4 |
695892 | 695892 | 2020-11-03 | Union | Tennessee | 47173 | 568 | 4 |
692650 | 692650 | 2020-11-02 | Union | Tennessee | 47173 | 567 | 4 |
689406 | 689406 | 2020-11-01 | Union | Tennessee | 47173 | 565 | 4 |
686161 | 686161 | 2020-10-31 | Union | Tennessee | 47173 | 563 | 4 |
682918 | 682918 | 2020-10-30 | Union | Tennessee | 47173 | 560 | 4 |
679675 | 679675 | 2020-10-29 | Union | Tennessee | 47173 | 555 | 4 |
676432 | 676432 | 2020-10-28 | Union | Tennessee | 47173 | 552 | 3 |
673189 | 673189 | 2020-10-27 | Union | Tennessee | 47173 | 549 | 3 |
669947 | 669947 | 2020-10-26 | Union | Tennessee | 47173 | 546 | 3 |
666703 | 666703 | 2020-10-25 | Union | Tennessee | 47173 | 543 | 3 |
663458 | 663458 | 2020-10-24 | Union | Tennessee | 47173 | 538 | 3 |
660214 | 660214 | 2020-10-23 | Union | Tennessee | 47173 | 523 | 3 |
656970 | 656970 | 2020-10-22 | Union | Tennessee | 47173 | 517 | 3 |
653725 | 653725 | 2020-10-21 | Union | Tennessee | 47173 | 514 | 2 |
650480 | 650480 | 2020-10-20 | Union | Tennessee | 47173 | 499 | 2 |
647236 | 647236 | 2020-10-19 | Union | Tennessee | 47173 | 493 | 2 |
643990 | 643990 | 2020-10-18 | Union | Tennessee | 47173 | 490 | 2 |
640742 | 640742 | 2020-10-17 | Union | Tennessee | 47173 | 487 | 2 |
637496 | 637496 | 2020-10-16 | Union | Tennessee | 47173 | 476 | 2 |
634250 | 634250 | 2020-10-15 | Union | Tennessee | 47173 | 474 | 2 |
631005 | 631005 | 2020-10-14 | Union | Tennessee | 47173 | 470 | 2 |
627761 | 627761 | 2020-10-13 | Union | Tennessee | 47173 | 461 | 2 |
624519 | 624519 | 2020-10-12 | Union | Tennessee | 47173 | 461 | 2 |
621276 | 621276 | 2020-10-11 | Union | Tennessee | 47173 | 453 | 2 |
618033 | 618033 | 2020-10-10 | Union | Tennessee | 47173 | 448 | 2 |
614791 | 614791 | 2020-10-09 | Union | Tennessee | 47173 | 444 | 2 |
611550 | 611550 | 2020-10-08 | Union | Tennessee | 47173 | 437 | 2 |
608308 | 608308 | 2020-10-07 | Union | Tennessee | 47173 | 429 | 2 |
605065 | 605065 | 2020-10-06 | Union | Tennessee | 47173 | 420 | 2 |
601823 | 601823 | 2020-10-05 | Union | Tennessee | 47173 | 417 | 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);