ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Lake" and fips = 47095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195683 | 1195683 | 2021-04-06 | Lake | Tennessee | 47095 | 1693 | 26 |
1192435 | 1192435 | 2021-04-05 | Lake | Tennessee | 47095 | 1693 | 26 |
1189186 | 1189186 | 2021-04-04 | Lake | Tennessee | 47095 | 1689 | 26 |
1185939 | 1185939 | 2021-04-03 | Lake | Tennessee | 47095 | 1689 | 26 |
1182692 | 1182692 | 2021-04-02 | Lake | Tennessee | 47095 | 1689 | 26 |
1179445 | 1179445 | 2021-04-01 | Lake | Tennessee | 47095 | 1689 | 26 |
1176198 | 1176198 | 2021-03-31 | Lake | Tennessee | 47095 | 1688 | 26 |
1172951 | 1172951 | 2021-03-30 | Lake | Tennessee | 47095 | 1687 | 26 |
1169704 | 1169704 | 2021-03-29 | Lake | Tennessee | 47095 | 1686 | 26 |
1166456 | 1166456 | 2021-03-28 | Lake | Tennessee | 47095 | 1683 | 26 |
1163208 | 1163208 | 2021-03-27 | Lake | Tennessee | 47095 | 1683 | 26 |
1159959 | 1159959 | 2021-03-26 | Lake | Tennessee | 47095 | 1683 | 26 |
1156712 | 1156712 | 2021-03-25 | Lake | Tennessee | 47095 | 1683 | 26 |
1153465 | 1153465 | 2021-03-24 | Lake | Tennessee | 47095 | 1683 | 26 |
1150218 | 1150218 | 2021-03-23 | Lake | Tennessee | 47095 | 1683 | 26 |
1146971 | 1146971 | 2021-03-22 | Lake | Tennessee | 47095 | 1683 | 26 |
1143724 | 1143724 | 2021-03-21 | Lake | Tennessee | 47095 | 1683 | 26 |
1140477 | 1140477 | 2021-03-20 | Lake | Tennessee | 47095 | 1683 | 26 |
1137231 | 1137231 | 2021-03-19 | Lake | Tennessee | 47095 | 1683 | 26 |
1133985 | 1133985 | 2021-03-18 | Lake | Tennessee | 47095 | 1681 | 26 |
1130737 | 1130737 | 2021-03-17 | Lake | Tennessee | 47095 | 1681 | 26 |
1127490 | 1127490 | 2021-03-16 | Lake | Tennessee | 47095 | 1681 | 26 |
1124244 | 1124244 | 2021-03-15 | Lake | Tennessee | 47095 | 1681 | 26 |
1120998 | 1120998 | 2021-03-14 | Lake | Tennessee | 47095 | 1680 | 26 |
1117751 | 1117751 | 2021-03-13 | Lake | Tennessee | 47095 | 1680 | 26 |
1114504 | 1114504 | 2021-03-12 | Lake | Tennessee | 47095 | 1680 | 26 |
1111258 | 1111258 | 2021-03-11 | Lake | Tennessee | 47095 | 1680 | 26 |
1108012 | 1108012 | 2021-03-10 | Lake | Tennessee | 47095 | 1680 | 26 |
1104766 | 1104766 | 2021-03-09 | Lake | Tennessee | 47095 | 1679 | 26 |
1101520 | 1101520 | 2021-03-08 | Lake | Tennessee | 47095 | 1679 | 26 |
1098274 | 1098274 | 2021-03-07 | Lake | Tennessee | 47095 | 1679 | 26 |
1095026 | 1095026 | 2021-03-06 | Lake | Tennessee | 47095 | 1679 | 26 |
1091780 | 1091780 | 2021-03-05 | Lake | Tennessee | 47095 | 1679 | 26 |
1088534 | 1088534 | 2021-03-04 | Lake | Tennessee | 47095 | 1679 | 26 |
1085289 | 1085289 | 2021-03-03 | Lake | Tennessee | 47095 | 1678 | 26 |
1082043 | 1082043 | 2021-03-02 | Lake | Tennessee | 47095 | 1678 | 26 |
1078797 | 1078797 | 2021-03-01 | Lake | Tennessee | 47095 | 1678 | 26 |
1075552 | 1075552 | 2021-02-28 | Lake | Tennessee | 47095 | 1678 | 26 |
1072306 | 1072306 | 2021-02-27 | Lake | Tennessee | 47095 | 1678 | 26 |
1069060 | 1069060 | 2021-02-26 | Lake | Tennessee | 47095 | 1675 | 26 |
1065815 | 1065815 | 2021-02-25 | Lake | Tennessee | 47095 | 1675 | 26 |
1062570 | 1062570 | 2021-02-24 | Lake | Tennessee | 47095 | 1673 | 26 |
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 |
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);