ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Lincoln" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1082047 | 1082047 | 2021-03-02 | Lincoln | Tennessee | 47103 | 4140 | 62 |
1078801 | 1078801 | 2021-03-01 | Lincoln | Tennessee | 47103 | 4140 | 62 |
1075556 | 1075556 | 2021-02-28 | Lincoln | Tennessee | 47103 | 4133 | 62 |
1072310 | 1072310 | 2021-02-27 | Lincoln | Tennessee | 47103 | 4130 | 62 |
1069064 | 1069064 | 2021-02-26 | Lincoln | Tennessee | 47103 | 4120 | 62 |
1065819 | 1065819 | 2021-02-25 | Lincoln | Tennessee | 47103 | 4117 | 61 |
1062574 | 1062574 | 2021-02-24 | Lincoln | Tennessee | 47103 | 4105 | 61 |
1059329 | 1059329 | 2021-02-23 | Lincoln | Tennessee | 47103 | 4098 | 61 |
1056083 | 1056083 | 2021-02-22 | Lincoln | Tennessee | 47103 | 4097 | 61 |
1052837 | 1052837 | 2021-02-21 | Lincoln | Tennessee | 47103 | 4092 | 61 |
1049590 | 1049590 | 2021-02-20 | Lincoln | Tennessee | 47103 | 4088 | 61 |
1046343 | 1046343 | 2021-02-19 | Lincoln | Tennessee | 47103 | 4085 | 61 |
1043098 | 1043098 | 2021-02-18 | Lincoln | Tennessee | 47103 | 4082 | 61 |
1039853 | 1039853 | 2021-02-17 | Lincoln | Tennessee | 47103 | 4078 | 60 |
1036608 | 1036608 | 2021-02-16 | Lincoln | Tennessee | 47103 | 4077 | 60 |
1033363 | 1033363 | 2021-02-15 | Lincoln | Tennessee | 47103 | 4074 | 60 |
1030117 | 1030117 | 2021-02-14 | Lincoln | Tennessee | 47103 | 4070 | 60 |
1026870 | 1026870 | 2021-02-13 | Lincoln | Tennessee | 47103 | 4066 | 60 |
1023625 | 1023625 | 2021-02-12 | Lincoln | Tennessee | 47103 | 4055 | 60 |
1020380 | 1020380 | 2021-02-11 | Lincoln | Tennessee | 47103 | 4051 | 58 |
1017135 | 1017135 | 2021-02-10 | Lincoln | Tennessee | 47103 | 4031 | 57 |
1013890 | 1013890 | 2021-02-09 | Lincoln | Tennessee | 47103 | 4026 | 55 |
1010645 | 1010645 | 2021-02-08 | Lincoln | Tennessee | 47103 | 4020 | 56 |
1007399 | 1007399 | 2021-02-07 | Lincoln | Tennessee | 47103 | 4019 | 55 |
1004153 | 1004153 | 2021-02-06 | Lincoln | Tennessee | 47103 | 4011 | 55 |
1000907 | 1000907 | 2021-02-05 | Lincoln | Tennessee | 47103 | 4000 | 55 |
997661 | 997661 | 2021-02-04 | Lincoln | Tennessee | 47103 | 3992 | 54 |
994415 | 994415 | 2021-02-03 | Lincoln | Tennessee | 47103 | 3985 | 54 |
991169 | 991169 | 2021-02-02 | Lincoln | Tennessee | 47103 | 3983 | 54 |
987923 | 987923 | 2021-02-01 | Lincoln | Tennessee | 47103 | 3975 | 54 |
984676 | 984676 | 2021-01-31 | Lincoln | Tennessee | 47103 | 3969 | 53 |
981429 | 981429 | 2021-01-30 | Lincoln | Tennessee | 47103 | 3950 | 53 |
978183 | 978183 | 2021-01-29 | Lincoln | Tennessee | 47103 | 3940 | 53 |
974938 | 974938 | 2021-01-28 | Lincoln | Tennessee | 47103 | 3905 | 53 |
971693 | 971693 | 2021-01-27 | Lincoln | Tennessee | 47103 | 3891 | 51 |
968448 | 968448 | 2021-01-26 | Lincoln | Tennessee | 47103 | 3885 | 49 |
965204 | 965204 | 2021-01-25 | Lincoln | Tennessee | 47103 | 3883 | 47 |
961959 | 961959 | 2021-01-24 | Lincoln | Tennessee | 47103 | 3878 | 47 |
958714 | 958714 | 2021-01-23 | Lincoln | Tennessee | 47103 | 3872 | 46 |
955468 | 955468 | 2021-01-22 | Lincoln | Tennessee | 47103 | 3855 | 46 |
952223 | 952223 | 2021-01-21 | Lincoln | Tennessee | 47103 | 3838 | 44 |
948978 | 948978 | 2021-01-20 | Lincoln | Tennessee | 47103 | 3812 | 44 |
945732 | 945732 | 2021-01-19 | Lincoln | Tennessee | 47103 | 3798 | 44 |
942485 | 942485 | 2021-01-18 | Lincoln | Tennessee | 47103 | 3794 | 44 |
939240 | 939240 | 2021-01-17 | Lincoln | Tennessee | 47103 | 3783 | 44 |
935995 | 935995 | 2021-01-16 | Lincoln | Tennessee | 47103 | 3761 | 44 |
932750 | 932750 | 2021-01-15 | Lincoln | Tennessee | 47103 | 3729 | 44 |
929505 | 929505 | 2021-01-14 | Lincoln | Tennessee | 47103 | 3710 | 44 |
926260 | 926260 | 2021-01-13 | Lincoln | Tennessee | 47103 | 3672 | 44 |
923014 | 923014 | 2021-01-12 | Lincoln | Tennessee | 47103 | 3657 | 41 |
919769 | 919769 | 2021-01-11 | Lincoln | Tennessee | 47103 | 3651 | 40 |
916524 | 916524 | 2021-01-10 | Lincoln | Tennessee | 47103 | 3639 | 39 |
913279 | 913279 | 2021-01-09 | Lincoln | Tennessee | 47103 | 3608 | 39 |
910034 | 910034 | 2021-01-08 | Lincoln | Tennessee | 47103 | 3579 | 39 |
906789 | 906789 | 2021-01-07 | Lincoln | Tennessee | 47103 | 3553 | 39 |
903543 | 903543 | 2021-01-06 | Lincoln | Tennessee | 47103 | 3472 | 38 |
900298 | 900298 | 2021-01-05 | Lincoln | Tennessee | 47103 | 3444 | 38 |
897053 | 897053 | 2021-01-04 | Lincoln | Tennessee | 47103 | 3416 | 37 |
893807 | 893807 | 2021-01-03 | Lincoln | Tennessee | 47103 | 3407 | 34 |
890561 | 890561 | 2021-01-02 | Lincoln | Tennessee | 47103 | 3378 | 34 |
887314 | 887314 | 2021-01-01 | Lincoln | Tennessee | 47103 | 3299 | 34 |
884069 | 884069 | 2020-12-31 | Lincoln | Tennessee | 47103 | 3299 | 34 |
880824 | 880824 | 2020-12-30 | Lincoln | Tennessee | 47103 | 3227 | 32 |
877579 | 877579 | 2020-12-29 | Lincoln | Tennessee | 47103 | 3207 | 32 |
874334 | 874334 | 2020-12-28 | Lincoln | Tennessee | 47103 | 3160 | 31 |
871089 | 871089 | 2020-12-27 | Lincoln | Tennessee | 47103 | 3149 | 31 |
867844 | 867844 | 2020-12-26 | Lincoln | Tennessee | 47103 | 3130 | 31 |
864599 | 864599 | 2020-12-25 | Lincoln | Tennessee | 47103 | 3108 | 31 |
861354 | 861354 | 2020-12-24 | Lincoln | Tennessee | 47103 | 3028 | 31 |
858109 | 858109 | 2020-12-23 | Lincoln | Tennessee | 47103 | 3000 | 31 |
854864 | 854864 | 2020-12-22 | Lincoln | Tennessee | 47103 | 2957 | 30 |
851619 | 851619 | 2020-12-21 | Lincoln | Tennessee | 47103 | 2940 | 28 |
848374 | 848374 | 2020-12-20 | Lincoln | Tennessee | 47103 | 2879 | 27 |
845129 | 845129 | 2020-12-19 | Lincoln | Tennessee | 47103 | 2828 | 27 |
841883 | 841883 | 2020-12-18 | Lincoln | Tennessee | 47103 | 2786 | 27 |
838638 | 838638 | 2020-12-17 | Lincoln | Tennessee | 47103 | 2710 | 27 |
835392 | 835392 | 2020-12-16 | Lincoln | Tennessee | 47103 | 2678 | 26 |
832146 | 832146 | 2020-12-15 | Lincoln | Tennessee | 47103 | 2512 | 26 |
828899 | 828899 | 2020-12-14 | Lincoln | Tennessee | 47103 | 2412 | 26 |
825653 | 825653 | 2020-12-13 | Lincoln | Tennessee | 47103 | 2356 | 26 |
822406 | 822406 | 2020-12-12 | Lincoln | Tennessee | 47103 | 2278 | 25 |
819160 | 819160 | 2020-12-11 | Lincoln | Tennessee | 47103 | 2220 | 25 |
815914 | 815914 | 2020-12-10 | Lincoln | Tennessee | 47103 | 2148 | 24 |
812668 | 812668 | 2020-12-09 | Lincoln | Tennessee | 47103 | 2091 | 24 |
809424 | 809424 | 2020-12-08 | Lincoln | Tennessee | 47103 | 2016 | 24 |
806179 | 806179 | 2020-12-07 | Lincoln | Tennessee | 47103 | 1939 | 24 |
802934 | 802934 | 2020-12-06 | Lincoln | Tennessee | 47103 | 1864 | 23 |
799689 | 799689 | 2020-12-05 | Lincoln | Tennessee | 47103 | 1836 | 22 |
796444 | 796444 | 2020-12-04 | Lincoln | Tennessee | 47103 | 1786 | 20 |
793199 | 793199 | 2020-12-03 | Lincoln | Tennessee | 47103 | 1775 | 20 |
789954 | 789954 | 2020-12-02 | Lincoln | Tennessee | 47103 | 1751 | 18 |
786709 | 786709 | 2020-12-01 | Lincoln | Tennessee | 47103 | 1711 | 18 |
783465 | 783465 | 2020-11-30 | Lincoln | Tennessee | 47103 | 1662 | 17 |
780220 | 780220 | 2020-11-29 | Lincoln | Tennessee | 47103 | 1614 | 16 |
776974 | 776974 | 2020-11-28 | Lincoln | Tennessee | 47103 | 1612 | 15 |
773729 | 773729 | 2020-11-27 | Lincoln | Tennessee | 47103 | 1579 | 14 |
770484 | 770484 | 2020-11-26 | Lincoln | Tennessee | 47103 | 1549 | 14 |
767238 | 767238 | 2020-11-25 | Lincoln | Tennessee | 47103 | 1494 | 14 |
763993 | 763993 | 2020-11-24 | Lincoln | Tennessee | 47103 | 1471 | 13 |
760748 | 760748 | 2020-11-23 | Lincoln | Tennessee | 47103 | 1463 | 13 |
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);