ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Lake" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1059325 | 1059325 | 2021-02-23 | Lake | Tennessee | 47095 | 1673 | 26 |
1056079 | 1056079 | 2021-02-22 | Lake | Tennessee | 47095 | 1671 | 26 |
1052833 | 1052833 | 2021-02-21 | Lake | Tennessee | 47095 | 1671 | 26 |
1049586 | 1049586 | 2021-02-20 | Lake | Tennessee | 47095 | 1670 | 25 |
1046339 | 1046339 | 2021-02-19 | Lake | Tennessee | 47095 | 1670 | 25 |
1043094 | 1043094 | 2021-02-18 | Lake | Tennessee | 47095 | 1669 | 25 |
1039849 | 1039849 | 2021-02-17 | Lake | Tennessee | 47095 | 1669 | 25 |
1036604 | 1036604 | 2021-02-16 | Lake | Tennessee | 47095 | 1667 | 25 |
1033359 | 1033359 | 2021-02-15 | Lake | Tennessee | 47095 | 1663 | 24 |
1030113 | 1030113 | 2021-02-14 | Lake | Tennessee | 47095 | 1663 | 24 |
1026866 | 1026866 | 2021-02-13 | Lake | Tennessee | 47095 | 1659 | 24 |
1023621 | 1023621 | 2021-02-12 | Lake | Tennessee | 47095 | 1658 | 25 |
1020376 | 1020376 | 2021-02-11 | Lake | Tennessee | 47095 | 1656 | 24 |
1017131 | 1017131 | 2021-02-10 | Lake | Tennessee | 47095 | 1651 | 23 |
1013886 | 1013886 | 2021-02-09 | Lake | Tennessee | 47095 | 1655 | 24 |
1010641 | 1010641 | 2021-02-08 | Lake | Tennessee | 47095 | 1658 | 24 |
1007395 | 1007395 | 2021-02-07 | Lake | Tennessee | 47095 | 1658 | 24 |
1004149 | 1004149 | 2021-02-06 | Lake | Tennessee | 47095 | 1656 | 24 |
1000903 | 1000903 | 2021-02-05 | Lake | Tennessee | 47095 | 1652 | 23 |
997657 | 997657 | 2021-02-04 | Lake | Tennessee | 47095 | 1652 | 23 |
994411 | 994411 | 2021-02-03 | Lake | Tennessee | 47095 | 1652 | 23 |
991165 | 991165 | 2021-02-02 | Lake | Tennessee | 47095 | 1652 | 23 |
987919 | 987919 | 2021-02-01 | Lake | Tennessee | 47095 | 1651 | 22 |
984672 | 984672 | 2021-01-31 | Lake | Tennessee | 47095 | 1652 | 22 |
981425 | 981425 | 2021-01-30 | Lake | Tennessee | 47095 | 1648 | 22 |
978179 | 978179 | 2021-01-29 | Lake | Tennessee | 47095 | 1603 | 22 |
974934 | 974934 | 2021-01-28 | Lake | Tennessee | 47095 | 1591 | 22 |
971689 | 971689 | 2021-01-27 | Lake | Tennessee | 47095 | 1589 | 22 |
968444 | 968444 | 2021-01-26 | Lake | Tennessee | 47095 | 1585 | 22 |
965200 | 965200 | 2021-01-25 | Lake | Tennessee | 47095 | 1585 | 22 |
961955 | 961955 | 2021-01-24 | Lake | Tennessee | 47095 | 1584 | 21 |
958710 | 958710 | 2021-01-23 | Lake | Tennessee | 47095 | 1584 | 21 |
955464 | 955464 | 2021-01-22 | Lake | Tennessee | 47095 | 1578 | 21 |
952219 | 952219 | 2021-01-21 | Lake | Tennessee | 47095 | 1575 | 21 |
948974 | 948974 | 2021-01-20 | Lake | Tennessee | 47095 | 1566 | 20 |
945728 | 945728 | 2021-01-19 | Lake | Tennessee | 47095 | 1560 | 19 |
942481 | 942481 | 2021-01-18 | Lake | Tennessee | 47095 | 1555 | 19 |
939236 | 939236 | 2021-01-17 | Lake | Tennessee | 47095 | 1553 | 19 |
935991 | 935991 | 2021-01-16 | Lake | Tennessee | 47095 | 1545 | 19 |
932746 | 932746 | 2021-01-15 | Lake | Tennessee | 47095 | 1540 | 19 |
929501 | 929501 | 2021-01-14 | Lake | Tennessee | 47095 | 1530 | 19 |
926256 | 926256 | 2021-01-13 | Lake | Tennessee | 47095 | 1521 | 19 |
923010 | 923010 | 2021-01-12 | Lake | Tennessee | 47095 | 1518 | 19 |
919765 | 919765 | 2021-01-11 | Lake | Tennessee | 47095 | 1516 | 19 |
916520 | 916520 | 2021-01-10 | Lake | Tennessee | 47095 | 1514 | 19 |
913275 | 913275 | 2021-01-09 | Lake | Tennessee | 47095 | 1503 | 18 |
910030 | 910030 | 2021-01-08 | Lake | Tennessee | 47095 | 1495 | 16 |
906785 | 906785 | 2021-01-07 | Lake | Tennessee | 47095 | 1491 | 16 |
903539 | 903539 | 2021-01-06 | Lake | Tennessee | 47095 | 1474 | 14 |
900294 | 900294 | 2021-01-05 | Lake | Tennessee | 47095 | 1470 | 15 |
897049 | 897049 | 2021-01-04 | Lake | Tennessee | 47095 | 1466 | 14 |
893803 | 893803 | 2021-01-03 | Lake | Tennessee | 47095 | 1466 | 13 |
890557 | 890557 | 2021-01-02 | Lake | Tennessee | 47095 | 1464 | 13 |
887310 | 887310 | 2021-01-01 | Lake | Tennessee | 47095 | 1408 | 13 |
884065 | 884065 | 2020-12-31 | Lake | Tennessee | 47095 | 1408 | 13 |
880820 | 880820 | 2020-12-30 | Lake | Tennessee | 47095 | 1393 | 13 |
877575 | 877575 | 2020-12-29 | Lake | Tennessee | 47095 | 1390 | 13 |
874330 | 874330 | 2020-12-28 | Lake | Tennessee | 47095 | 1386 | 12 |
871085 | 871085 | 2020-12-27 | Lake | Tennessee | 47095 | 1385 | 12 |
867840 | 867840 | 2020-12-26 | Lake | Tennessee | 47095 | 1379 | 12 |
864595 | 864595 | 2020-12-25 | Lake | Tennessee | 47095 | 1374 | 12 |
861350 | 861350 | 2020-12-24 | Lake | Tennessee | 47095 | 1367 | 12 |
858105 | 858105 | 2020-12-23 | Lake | Tennessee | 47095 | 1355 | 12 |
854860 | 854860 | 2020-12-22 | Lake | Tennessee | 47095 | 1350 | 12 |
851615 | 851615 | 2020-12-21 | Lake | Tennessee | 47095 | 1348 | 12 |
848370 | 848370 | 2020-12-20 | Lake | Tennessee | 47095 | 1345 | 12 |
845125 | 845125 | 2020-12-19 | Lake | Tennessee | 47095 | 1340 | 11 |
841879 | 841879 | 2020-12-18 | Lake | Tennessee | 47095 | 1338 | 11 |
838634 | 838634 | 2020-12-17 | Lake | Tennessee | 47095 | 1331 | 11 |
835388 | 835388 | 2020-12-16 | Lake | Tennessee | 47095 | 1321 | 11 |
832142 | 832142 | 2020-12-15 | Lake | Tennessee | 47095 | 1307 | 11 |
828895 | 828895 | 2020-12-14 | Lake | Tennessee | 47095 | 1298 | 10 |
825649 | 825649 | 2020-12-13 | Lake | Tennessee | 47095 | 1288 | 10 |
822402 | 822402 | 2020-12-12 | Lake | Tennessee | 47095 | 1282 | 9 |
819156 | 819156 | 2020-12-11 | Lake | Tennessee | 47095 | 1274 | 9 |
815910 | 815910 | 2020-12-10 | Lake | Tennessee | 47095 | 1268 | 8 |
812664 | 812664 | 2020-12-09 | Lake | Tennessee | 47095 | 1260 | 8 |
809420 | 809420 | 2020-12-08 | Lake | Tennessee | 47095 | 1244 | 8 |
806175 | 806175 | 2020-12-07 | Lake | Tennessee | 47095 | 1235 | 8 |
802930 | 802930 | 2020-12-06 | Lake | Tennessee | 47095 | 1220 | 7 |
799685 | 799685 | 2020-12-05 | Lake | Tennessee | 47095 | 1209 | 7 |
796440 | 796440 | 2020-12-04 | Lake | Tennessee | 47095 | 1207 | 7 |
793195 | 793195 | 2020-12-03 | Lake | Tennessee | 47095 | 1193 | 6 |
789950 | 789950 | 2020-12-02 | Lake | Tennessee | 47095 | 1189 | 6 |
786705 | 786705 | 2020-12-01 | Lake | Tennessee | 47095 | 1182 | 6 |
783461 | 783461 | 2020-11-30 | Lake | Tennessee | 47095 | 1178 | 6 |
780216 | 780216 | 2020-11-29 | Lake | Tennessee | 47095 | 1178 | 6 |
776970 | 776970 | 2020-11-28 | Lake | Tennessee | 47095 | 1176 | 6 |
773725 | 773725 | 2020-11-27 | Lake | Tennessee | 47095 | 1165 | 6 |
770480 | 770480 | 2020-11-26 | Lake | Tennessee | 47095 | 1163 | 6 |
767234 | 767234 | 2020-11-25 | Lake | Tennessee | 47095 | 1154 | 5 |
763989 | 763989 | 2020-11-24 | Lake | Tennessee | 47095 | 1152 | 5 |
760744 | 760744 | 2020-11-23 | Lake | Tennessee | 47095 | 1151 | 5 |
757499 | 757499 | 2020-11-22 | Lake | Tennessee | 47095 | 1144 | 5 |
754252 | 754252 | 2020-11-21 | Lake | Tennessee | 47095 | 1137 | 5 |
751006 | 751006 | 2020-11-20 | Lake | Tennessee | 47095 | 1132 | 5 |
747760 | 747760 | 2020-11-19 | Lake | Tennessee | 47095 | 1127 | 5 |
744514 | 744514 | 2020-11-18 | Lake | Tennessee | 47095 | 1122 | 5 |
741267 | 741267 | 2020-11-17 | Lake | Tennessee | 47095 | 1116 | 5 |
738021 | 738021 | 2020-11-16 | Lake | Tennessee | 47095 | 1114 | 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);