ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Scott" and fips = 47151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195711 | 1195711 | 2021-04-06 | Scott | Tennessee | 47151 | 3015 | 45 |
1192463 | 1192463 | 2021-04-05 | Scott | Tennessee | 47151 | 3011 | 45 |
1189214 | 1189214 | 2021-04-04 | Scott | Tennessee | 47151 | 2995 | 45 |
1185967 | 1185967 | 2021-04-03 | Scott | Tennessee | 47151 | 2995 | 45 |
1182720 | 1182720 | 2021-04-02 | Scott | Tennessee | 47151 | 2995 | 45 |
1179473 | 1179473 | 2021-04-01 | Scott | Tennessee | 47151 | 2995 | 45 |
1176226 | 1176226 | 2021-03-31 | Scott | Tennessee | 47151 | 2988 | 45 |
1172979 | 1172979 | 2021-03-30 | Scott | Tennessee | 47151 | 2980 | 44 |
1169732 | 1169732 | 2021-03-29 | Scott | Tennessee | 47151 | 2978 | 44 |
1166484 | 1166484 | 2021-03-28 | Scott | Tennessee | 47151 | 2970 | 44 |
1163236 | 1163236 | 2021-03-27 | Scott | Tennessee | 47151 | 2970 | 44 |
1159987 | 1159987 | 2021-03-26 | Scott | Tennessee | 47151 | 2970 | 44 |
1156740 | 1156740 | 2021-03-25 | Scott | Tennessee | 47151 | 2971 | 44 |
1153493 | 1153493 | 2021-03-24 | Scott | Tennessee | 47151 | 2964 | 44 |
1150246 | 1150246 | 2021-03-23 | Scott | Tennessee | 47151 | 2958 | 44 |
1146999 | 1146999 | 2021-03-22 | Scott | Tennessee | 47151 | 2954 | 44 |
1143752 | 1143752 | 2021-03-21 | Scott | Tennessee | 47151 | 2937 | 44 |
1140505 | 1140505 | 2021-03-20 | Scott | Tennessee | 47151 | 2937 | 44 |
1137259 | 1137259 | 2021-03-19 | Scott | Tennessee | 47151 | 2937 | 44 |
1134013 | 1134013 | 2021-03-18 | Scott | Tennessee | 47151 | 2932 | 44 |
1130765 | 1130765 | 2021-03-17 | Scott | Tennessee | 47151 | 2928 | 44 |
1127518 | 1127518 | 2021-03-16 | Scott | Tennessee | 47151 | 2925 | 44 |
1124272 | 1124272 | 2021-03-15 | Scott | Tennessee | 47151 | 2922 | 44 |
1121026 | 1121026 | 2021-03-14 | Scott | Tennessee | 47151 | 2910 | 44 |
1117779 | 1117779 | 2021-03-13 | Scott | Tennessee | 47151 | 2910 | 44 |
1114532 | 1114532 | 2021-03-12 | Scott | Tennessee | 47151 | 2910 | 44 |
1111286 | 1111286 | 2021-03-11 | Scott | Tennessee | 47151 | 2910 | 44 |
1108040 | 1108040 | 2021-03-10 | Scott | Tennessee | 47151 | 2903 | 44 |
1104794 | 1104794 | 2021-03-09 | Scott | Tennessee | 47151 | 2899 | 44 |
1101548 | 1101548 | 2021-03-08 | Scott | Tennessee | 47151 | 2895 | 44 |
1098302 | 1098302 | 2021-03-07 | Scott | Tennessee | 47151 | 2891 | 44 |
1095054 | 1095054 | 2021-03-06 | Scott | Tennessee | 47151 | 2886 | 44 |
1091808 | 1091808 | 2021-03-05 | Scott | Tennessee | 47151 | 2883 | 44 |
1088562 | 1088562 | 2021-03-04 | Scott | Tennessee | 47151 | 2881 | 44 |
1085317 | 1085317 | 2021-03-03 | Scott | Tennessee | 47151 | 2877 | 44 |
1082071 | 1082071 | 2021-03-02 | Scott | Tennessee | 47151 | 2876 | 44 |
1078825 | 1078825 | 2021-03-01 | Scott | Tennessee | 47151 | 2870 | 43 |
1075580 | 1075580 | 2021-02-28 | Scott | Tennessee | 47151 | 2868 | 43 |
1072334 | 1072334 | 2021-02-27 | Scott | Tennessee | 47151 | 2863 | 43 |
1069088 | 1069088 | 2021-02-26 | Scott | Tennessee | 47151 | 2858 | 42 |
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 |
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);