ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Scott" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1065843 | 1065843 | 2021-02-25 | Scott | Tennessee | 47151 | 2858 | 42 |
1062598 | 1062598 | 2021-02-24 | Scott | Tennessee | 47151 | 2850 | 42 |
1059353 | 1059353 | 2021-02-23 | Scott | Tennessee | 47151 | 2848 | 42 |
1056107 | 1056107 | 2021-02-22 | Scott | Tennessee | 47151 | 2845 | 40 |
1052861 | 1052861 | 2021-02-21 | Scott | Tennessee | 47151 | 2846 | 40 |
1049614 | 1049614 | 2021-02-20 | Scott | Tennessee | 47151 | 2840 | 40 |
1046367 | 1046367 | 2021-02-19 | Scott | Tennessee | 47151 | 2836 | 42 |
1043122 | 1043122 | 2021-02-18 | Scott | Tennessee | 47151 | 2832 | 42 |
1039877 | 1039877 | 2021-02-17 | Scott | Tennessee | 47151 | 2828 | 41 |
1036632 | 1036632 | 2021-02-16 | Scott | Tennessee | 47151 | 2824 | 41 |
1033387 | 1033387 | 2021-02-15 | Scott | Tennessee | 47151 | 2772 | 41 |
1030141 | 1030141 | 2021-02-14 | Scott | Tennessee | 47151 | 2730 | 41 |
1026894 | 1026894 | 2021-02-13 | Scott | Tennessee | 47151 | 2676 | 41 |
1023649 | 1023649 | 2021-02-12 | Scott | Tennessee | 47151 | 2619 | 41 |
1020404 | 1020404 | 2021-02-11 | Scott | Tennessee | 47151 | 2608 | 41 |
1017159 | 1017159 | 2021-02-10 | Scott | Tennessee | 47151 | 2462 | 41 |
1013914 | 1013914 | 2021-02-09 | Scott | Tennessee | 47151 | 2434 | 39 |
1010669 | 1010669 | 2021-02-08 | Scott | Tennessee | 47151 | 2420 | 39 |
1007423 | 1007423 | 2021-02-07 | Scott | Tennessee | 47151 | 2416 | 39 |
1004177 | 1004177 | 2021-02-06 | Scott | Tennessee | 47151 | 2406 | 39 |
1000931 | 1000931 | 2021-02-05 | Scott | Tennessee | 47151 | 2394 | 38 |
997685 | 997685 | 2021-02-04 | Scott | Tennessee | 47151 | 2383 | 39 |
994439 | 994439 | 2021-02-03 | Scott | Tennessee | 47151 | 2375 | 36 |
991193 | 991193 | 2021-02-02 | Scott | Tennessee | 47151 | 2368 | 36 |
987947 | 987947 | 2021-02-01 | Scott | Tennessee | 47151 | 2365 | 35 |
984700 | 984700 | 2021-01-31 | Scott | Tennessee | 47151 | 2363 | 34 |
981453 | 981453 | 2021-01-30 | Scott | Tennessee | 47151 | 2352 | 34 |
978207 | 978207 | 2021-01-29 | Scott | Tennessee | 47151 | 2343 | 34 |
974962 | 974962 | 2021-01-28 | Scott | Tennessee | 47151 | 2321 | 33 |
971717 | 971717 | 2021-01-27 | Scott | Tennessee | 47151 | 2314 | 32 |
968472 | 968472 | 2021-01-26 | Scott | Tennessee | 47151 | 2309 | 32 |
965228 | 965228 | 2021-01-25 | Scott | Tennessee | 47151 | 2304 | 32 |
961983 | 961983 | 2021-01-24 | Scott | Tennessee | 47151 | 2303 | 32 |
958738 | 958738 | 2021-01-23 | Scott | Tennessee | 47151 | 2297 | 32 |
955492 | 955492 | 2021-01-22 | Scott | Tennessee | 47151 | 2288 | 32 |
952247 | 952247 | 2021-01-21 | Scott | Tennessee | 47151 | 2278 | 31 |
949002 | 949002 | 2021-01-20 | Scott | Tennessee | 47151 | 2273 | 31 |
945756 | 945756 | 2021-01-19 | Scott | Tennessee | 47151 | 2262 | 31 |
942509 | 942509 | 2021-01-18 | Scott | Tennessee | 47151 | 2254 | 31 |
939264 | 939264 | 2021-01-17 | Scott | Tennessee | 47151 | 2252 | 31 |
936019 | 936019 | 2021-01-16 | Scott | Tennessee | 47151 | 2236 | 31 |
932774 | 932774 | 2021-01-15 | Scott | Tennessee | 47151 | 2224 | 31 |
929529 | 929529 | 2021-01-14 | Scott | Tennessee | 47151 | 2197 | 31 |
926284 | 926284 | 2021-01-13 | Scott | Tennessee | 47151 | 2186 | 32 |
923038 | 923038 | 2021-01-12 | Scott | Tennessee | 47151 | 2176 | 30 |
919793 | 919793 | 2021-01-11 | Scott | Tennessee | 47151 | 2172 | 29 |
916548 | 916548 | 2021-01-10 | Scott | Tennessee | 47151 | 2168 | 28 |
913303 | 913303 | 2021-01-09 | Scott | Tennessee | 47151 | 2153 | 28 |
910058 | 910058 | 2021-01-08 | Scott | Tennessee | 47151 | 2137 | 27 |
906813 | 906813 | 2021-01-07 | Scott | Tennessee | 47151 | 2131 | 26 |
903567 | 903567 | 2021-01-06 | Scott | Tennessee | 47151 | 2106 | 26 |
900322 | 900322 | 2021-01-05 | Scott | Tennessee | 47151 | 2078 | 25 |
897077 | 897077 | 2021-01-04 | Scott | Tennessee | 47151 | 2067 | 25 |
893831 | 893831 | 2021-01-03 | Scott | Tennessee | 47151 | 2061 | 25 |
890585 | 890585 | 2021-01-02 | Scott | Tennessee | 47151 | 2048 | 25 |
887338 | 887338 | 2021-01-01 | Scott | Tennessee | 47151 | 1994 | 23 |
884093 | 884093 | 2020-12-31 | Scott | Tennessee | 47151 | 1994 | 23 |
880848 | 880848 | 2020-12-30 | Scott | Tennessee | 47151 | 1967 | 22 |
877603 | 877603 | 2020-12-29 | Scott | Tennessee | 47151 | 1937 | 21 |
874358 | 874358 | 2020-12-28 | Scott | Tennessee | 47151 | 1924 | 20 |
871113 | 871113 | 2020-12-27 | Scott | Tennessee | 47151 | 1911 | 20 |
867868 | 867868 | 2020-12-26 | Scott | Tennessee | 47151 | 1898 | 20 |
864623 | 864623 | 2020-12-25 | Scott | Tennessee | 47151 | 1894 | 20 |
861378 | 861378 | 2020-12-24 | Scott | Tennessee | 47151 | 1849 | 20 |
858133 | 858133 | 2020-12-23 | Scott | Tennessee | 47151 | 1844 | 20 |
854888 | 854888 | 2020-12-22 | Scott | Tennessee | 47151 | 1812 | 19 |
851643 | 851643 | 2020-12-21 | Scott | Tennessee | 47151 | 1801 | 17 |
848398 | 848398 | 2020-12-20 | Scott | Tennessee | 47151 | 1772 | 16 |
845153 | 845153 | 2020-12-19 | Scott | Tennessee | 47151 | 1737 | 15 |
841907 | 841907 | 2020-12-18 | Scott | Tennessee | 47151 | 1685 | 14 |
838662 | 838662 | 2020-12-17 | Scott | Tennessee | 47151 | 1657 | 12 |
835416 | 835416 | 2020-12-16 | Scott | Tennessee | 47151 | 1616 | 12 |
832170 | 832170 | 2020-12-15 | Scott | Tennessee | 47151 | 1580 | 12 |
828923 | 828923 | 2020-12-14 | Scott | Tennessee | 47151 | 1552 | 12 |
825677 | 825677 | 2020-12-13 | Scott | Tennessee | 47151 | 1491 | 11 |
822430 | 822430 | 2020-12-12 | Scott | Tennessee | 47151 | 1429 | 11 |
819184 | 819184 | 2020-12-11 | Scott | Tennessee | 47151 | 1415 | 10 |
815938 | 815938 | 2020-12-10 | Scott | Tennessee | 47151 | 1376 | 9 |
812692 | 812692 | 2020-12-09 | Scott | Tennessee | 47151 | 1342 | 9 |
809448 | 809448 | 2020-12-08 | Scott | Tennessee | 47151 | 1290 | 9 |
806203 | 806203 | 2020-12-07 | Scott | Tennessee | 47151 | 1271 | 9 |
802958 | 802958 | 2020-12-06 | Scott | Tennessee | 47151 | 1228 | 8 |
799713 | 799713 | 2020-12-05 | Scott | Tennessee | 47151 | 1198 | 8 |
796468 | 796468 | 2020-12-04 | Scott | Tennessee | 47151 | 1177 | 8 |
793223 | 793223 | 2020-12-03 | Scott | Tennessee | 47151 | 1173 | 7 |
789978 | 789978 | 2020-12-02 | Scott | Tennessee | 47151 | 1171 | 7 |
786733 | 786733 | 2020-12-01 | Scott | Tennessee | 47151 | 1144 | 7 |
783489 | 783489 | 2020-11-30 | Scott | Tennessee | 47151 | 1119 | 7 |
780244 | 780244 | 2020-11-29 | Scott | Tennessee | 47151 | 1085 | 7 |
776998 | 776998 | 2020-11-28 | Scott | Tennessee | 47151 | 1072 | 7 |
773753 | 773753 | 2020-11-27 | Scott | Tennessee | 47151 | 1050 | 7 |
770508 | 770508 | 2020-11-26 | Scott | Tennessee | 47151 | 1022 | 7 |
767262 | 767262 | 2020-11-25 | Scott | Tennessee | 47151 | 996 | 7 |
764017 | 764017 | 2020-11-24 | Scott | Tennessee | 47151 | 966 | 7 |
760772 | 760772 | 2020-11-23 | Scott | Tennessee | 47151 | 958 | 7 |
757527 | 757527 | 2020-11-22 | Scott | Tennessee | 47151 | 940 | 7 |
754280 | 754280 | 2020-11-21 | Scott | Tennessee | 47151 | 911 | 7 |
751034 | 751034 | 2020-11-20 | Scott | Tennessee | 47151 | 875 | 7 |
747788 | 747788 | 2020-11-19 | Scott | Tennessee | 47151 | 843 | 6 |
744542 | 744542 | 2020-11-18 | Scott | Tennessee | 47151 | 802 | 6 |
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);