ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Union" and fips = 47173 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056118 | 1056118 | 2021-02-22 | Union | Tennessee | 47173 | 1675 | 30 |
1052872 | 1052872 | 2021-02-21 | Union | Tennessee | 47173 | 1669 | 30 |
1049625 | 1049625 | 2021-02-20 | Union | Tennessee | 47173 | 1666 | 30 |
1046378 | 1046378 | 2021-02-19 | Union | Tennessee | 47173 | 1661 | 30 |
1043133 | 1043133 | 2021-02-18 | Union | Tennessee | 47173 | 1656 | 30 |
1039888 | 1039888 | 2021-02-17 | Union | Tennessee | 47173 | 1651 | 29 |
1036643 | 1036643 | 2021-02-16 | Union | Tennessee | 47173 | 1647 | 29 |
1033398 | 1033398 | 2021-02-15 | Union | Tennessee | 47173 | 1642 | 28 |
1030152 | 1030152 | 2021-02-14 | Union | Tennessee | 47173 | 1643 | 28 |
1026905 | 1026905 | 2021-02-13 | Union | Tennessee | 47173 | 1640 | 28 |
1023660 | 1023660 | 2021-02-12 | Union | Tennessee | 47173 | 1633 | 28 |
1020415 | 1020415 | 2021-02-11 | Union | Tennessee | 47173 | 1620 | 28 |
1017170 | 1017170 | 2021-02-10 | Union | Tennessee | 47173 | 1612 | 28 |
1013925 | 1013925 | 2021-02-09 | Union | Tennessee | 47173 | 1566 | 28 |
1010680 | 1010680 | 2021-02-08 | Union | Tennessee | 47173 | 1541 | 27 |
1007434 | 1007434 | 2021-02-07 | Union | Tennessee | 47173 | 1538 | 26 |
1004188 | 1004188 | 2021-02-06 | Union | Tennessee | 47173 | 1534 | 26 |
1000942 | 1000942 | 2021-02-05 | Union | Tennessee | 47173 | 1528 | 26 |
997696 | 997696 | 2021-02-04 | Union | Tennessee | 47173 | 1523 | 25 |
994450 | 994450 | 2021-02-03 | Union | Tennessee | 47173 | 1517 | 25 |
991204 | 991204 | 2021-02-02 | Union | Tennessee | 47173 | 1514 | 25 |
987958 | 987958 | 2021-02-01 | Union | Tennessee | 47173 | 1511 | 25 |
984711 | 984711 | 2021-01-31 | Union | Tennessee | 47173 | 1508 | 25 |
981464 | 981464 | 2021-01-30 | Union | Tennessee | 47173 | 1498 | 25 |
978218 | 978218 | 2021-01-29 | Union | Tennessee | 47173 | 1487 | 25 |
974973 | 974973 | 2021-01-28 | Union | Tennessee | 47173 | 1478 | 25 |
971728 | 971728 | 2021-01-27 | Union | Tennessee | 47173 | 1475 | 25 |
968483 | 968483 | 2021-01-26 | Union | Tennessee | 47173 | 1465 | 25 |
965239 | 965239 | 2021-01-25 | Union | Tennessee | 47173 | 1457 | 25 |
961994 | 961994 | 2021-01-24 | Union | Tennessee | 47173 | 1454 | 25 |
958749 | 958749 | 2021-01-23 | Union | Tennessee | 47173 | 1447 | 25 |
955503 | 955503 | 2021-01-22 | Union | Tennessee | 47173 | 1432 | 25 |
952258 | 952258 | 2021-01-21 | Union | Tennessee | 47173 | 1421 | 25 |
949013 | 949013 | 2021-01-20 | Union | Tennessee | 47173 | 1407 | 23 |
945767 | 945767 | 2021-01-19 | Union | Tennessee | 47173 | 1399 | 23 |
942520 | 942520 | 2021-01-18 | Union | Tennessee | 47173 | 1394 | 22 |
939275 | 939275 | 2021-01-17 | Union | Tennessee | 47173 | 1387 | 21 |
936030 | 936030 | 2021-01-16 | Union | Tennessee | 47173 | 1377 | 21 |
932785 | 932785 | 2021-01-15 | Union | Tennessee | 47173 | 1368 | 21 |
929540 | 929540 | 2021-01-14 | Union | Tennessee | 47173 | 1361 | 21 |
926295 | 926295 | 2021-01-13 | Union | Tennessee | 47173 | 1350 | 20 |
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 |
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);