ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where county = "Westchester" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279445 | 1279445 | 2021-05-02 | Westchester | New York | 36119 | 127912 | 2258 |
1276198 | 1276198 | 2021-05-01 | Westchester | New York | 36119 | 127816 | 2257 |
1272951 | 1272951 | 2021-04-30 | Westchester | New York | 36119 | 127663 | 2257 |
1269704 | 1269704 | 2021-04-29 | Westchester | New York | 36119 | 127520 | 2255 |
1266457 | 1266457 | 2021-04-28 | Westchester | New York | 36119 | 127392 | 2254 |
1263210 | 1263210 | 2021-04-27 | Westchester | New York | 36119 | 127272 | 2251 |
1259963 | 1259963 | 2021-04-26 | Westchester | New York | 36119 | 127178 | 2250 |
1256716 | 1256716 | 2021-04-25 | Westchester | New York | 36119 | 127045 | 2249 |
1253469 | 1253469 | 2021-04-24 | Westchester | New York | 36119 | 126895 | 2248 |
1250222 | 1250222 | 2021-04-23 | Westchester | New York | 36119 | 126705 | 2248 |
1246975 | 1246975 | 2021-04-22 | Westchester | New York | 36119 | 126493 | 2248 |
1243728 | 1243728 | 2021-04-21 | Westchester | New York | 36119 | 126277 | 2246 |
1240481 | 1240481 | 2021-04-20 | Westchester | New York | 36119 | 126093 | 2246 |
1237234 | 1237234 | 2021-04-19 | Westchester | New York | 36119 | 125912 | 2246 |
1233987 | 1233987 | 2021-04-18 | Westchester | New York | 36119 | 125725 | 2245 |
1230739 | 1230739 | 2021-04-17 | Westchester | New York | 36119 | 125486 | 2242 |
1227491 | 1227491 | 2021-04-16 | Westchester | New York | 36119 | 125171 | 2240 |
1224243 | 1224243 | 2021-04-15 | Westchester | New York | 36119 | 124880 | 2238 |
1220996 | 1220996 | 2021-04-14 | Westchester | New York | 36119 | 124534 | 2236 |
1217748 | 1217748 | 2021-04-13 | Westchester | New York | 36119 | 124316 | 2235 |
1214500 | 1214500 | 2021-04-12 | Westchester | New York | 36119 | 124091 | 2234 |
1211253 | 1211253 | 2021-04-11 | Westchester | New York | 36119 | 123837 | 2231 |
1208004 | 1208004 | 2021-04-10 | Westchester | New York | 36119 | 123547 | 2228 |
1204756 | 1204756 | 2021-04-09 | Westchester | New York | 36119 | 123202 | 2226 |
1201508 | 1201508 | 2021-04-08 | Westchester | New York | 36119 | 122779 | 2221 |
1198259 | 1198259 | 2021-04-07 | Westchester | New York | 36119 | 122411 | 2219 |
1195010 | 1195010 | 2021-04-06 | Westchester | New York | 36119 | 122065 | 2218 |
1191762 | 1191762 | 2021-04-05 | Westchester | New York | 36119 | 121803 | 2215 |
1188513 | 1188513 | 2021-04-04 | Westchester | New York | 36119 | 121506 | 2214 |
1185266 | 1185266 | 2021-04-03 | Westchester | New York | 36119 | 121123 | 2210 |
1182019 | 1182019 | 2021-04-02 | Westchester | New York | 36119 | 120733 | 2208 |
1178772 | 1178772 | 2021-04-01 | Westchester | New York | 36119 | 120315 | 2203 |
1175525 | 1175525 | 2021-03-31 | Westchester | New York | 36119 | 119731 | 2198 |
1172278 | 1172278 | 2021-03-30 | Westchester | New York | 36119 | 119241 | 2198 |
1169031 | 1169031 | 2021-03-29 | Westchester | New York | 36119 | 118963 | 2194 |
1165783 | 1165783 | 2021-03-28 | Westchester | New York | 36119 | 118504 | 2190 |
1162535 | 1162535 | 2021-03-27 | Westchester | New York | 36119 | 118000 | 2188 |
1159286 | 1159286 | 2021-03-26 | Westchester | New York | 36119 | 117508 | 2183 |
1156039 | 1156039 | 2021-03-25 | Westchester | New York | 36119 | 117067 | 2182 |
1152792 | 1152792 | 2021-03-24 | Westchester | New York | 36119 | 116663 | 2181 |
1149545 | 1149545 | 2021-03-23 | Westchester | New York | 36119 | 116288 | 2176 |
1146298 | 1146298 | 2021-03-22 | Westchester | New York | 36119 | 115934 | 2171 |
1143051 | 1143051 | 2021-03-21 | Westchester | New York | 36119 | 115562 | 2168 |
1139804 | 1139804 | 2021-03-20 | Westchester | New York | 36119 | 115221 | 2163 |
1136558 | 1136558 | 2021-03-19 | Westchester | New York | 36119 | 114801 | 2162 |
1133312 | 1133312 | 2021-03-18 | Westchester | New York | 36119 | 114401 | 2159 |
1130064 | 1130064 | 2021-03-17 | Westchester | New York | 36119 | 113998 | 2155 |
1126817 | 1126817 | 2021-03-16 | Westchester | New York | 36119 | 113576 | 2152 |
1123571 | 1123571 | 2021-03-15 | Westchester | New York | 36119 | 113203 | 2149 |
1120325 | 1120325 | 2021-03-14 | Westchester | New York | 36119 | 112853 | 2146 |
1117078 | 1117078 | 2021-03-13 | Westchester | New York | 36119 | 112566 | 2145 |
1113831 | 1113831 | 2021-03-12 | Westchester | New York | 36119 | 112207 | 2142 |
1110585 | 1110585 | 2021-03-11 | Westchester | New York | 36119 | 111712 | 2139 |
1107339 | 1107339 | 2021-03-10 | Westchester | New York | 36119 | 111338 | 2134 |
1104093 | 1104093 | 2021-03-09 | Westchester | New York | 36119 | 110969 | 2132 |
1100847 | 1100847 | 2021-03-08 | Westchester | New York | 36119 | 110599 | 2128 |
1097601 | 1097601 | 2021-03-07 | Westchester | New York | 36119 | 110329 | 2125 |
1094353 | 1094353 | 2021-03-06 | Westchester | New York | 36119 | 109950 | 2122 |
1091107 | 1091107 | 2021-03-05 | Westchester | New York | 36119 | 109515 | 2118 |
1087862 | 1087862 | 2021-03-04 | Westchester | New York | 36119 | 109037 | 2116 |
1084617 | 1084617 | 2021-03-03 | Westchester | New York | 36119 | 108622 | 2109 |
1081371 | 1081371 | 2021-03-02 | Westchester | New York | 36119 | 108192 | 2105 |
1078125 | 1078125 | 2021-03-01 | Westchester | New York | 36119 | 107856 | 2101 |
1074880 | 1074880 | 2021-02-28 | Westchester | New York | 36119 | 107486 | 2097 |
1071634 | 1071634 | 2021-02-27 | Westchester | New York | 36119 | 107074 | 2091 |
1068388 | 1068388 | 2021-02-26 | Westchester | New York | 36119 | 106610 | 2087 |
1065143 | 1065143 | 2021-02-25 | Westchester | New York | 36119 | 106128 | 2081 |
1061899 | 1061899 | 2021-02-24 | Westchester | New York | 36119 | 105549 | 2078 |
1058653 | 1058653 | 2021-02-23 | Westchester | New York | 36119 | 105167 | 2070 |
1055407 | 1055407 | 2021-02-22 | Westchester | New York | 36119 | 104776 | 2064 |
1052161 | 1052161 | 2021-02-21 | Westchester | New York | 36119 | 104399 | 2054 |
1048914 | 1048914 | 2021-02-20 | Westchester | New York | 36119 | 103989 | 2051 |
1045667 | 1045667 | 2021-02-19 | Westchester | New York | 36119 | 103505 | 2045 |
1042422 | 1042422 | 2021-02-18 | Westchester | New York | 36119 | 103018 | 2041 |
1039177 | 1039177 | 2021-02-17 | Westchester | New York | 36119 | 102597 | 2035 |
1035932 | 1035932 | 2021-02-16 | Westchester | New York | 36119 | 102196 | 2031 |
1032687 | 1032687 | 2021-02-15 | Westchester | New York | 36119 | 101815 | 2027 |
1029441 | 1029441 | 2021-02-14 | Westchester | New York | 36119 | 101510 | 2021 |
1026194 | 1026194 | 2021-02-13 | Westchester | New York | 36119 | 101014 | 2015 |
1022949 | 1022949 | 2021-02-12 | Westchester | New York | 36119 | 100503 | 2010 |
1019704 | 1019704 | 2021-02-11 | Westchester | New York | 36119 | 99983 | 2002 |
1016459 | 1016459 | 2021-02-10 | Westchester | New York | 36119 | 99308 | 1996 |
1013214 | 1013214 | 2021-02-09 | Westchester | New York | 36119 | 98903 | 1984 |
1009969 | 1009969 | 2021-02-08 | Westchester | New York | 36119 | 98444 | 1976 |
1006723 | 1006723 | 2021-02-07 | Westchester | New York | 36119 | 97907 | 1971 |
1003477 | 1003477 | 2021-02-06 | Westchester | New York | 36119 | 97222 | 1966 |
1000231 | 1000231 | 2021-02-05 | Westchester | New York | 36119 | 96464 | 1952 |
996985 | 996985 | 2021-02-04 | Westchester | New York | 36119 | 95988 | 1948 |
993739 | 993739 | 2021-02-03 | Westchester | New York | 36119 | 95641 | 1938 |
990493 | 990493 | 2021-02-02 | Westchester | New York | 36119 | 95302 | 1927 |
987247 | 987247 | 2021-02-01 | Westchester | New York | 36119 | 94697 | 1917 |
984000 | 984000 | 2021-01-31 | Westchester | New York | 36119 | 94213 | 1906 |
980753 | 980753 | 2021-01-30 | Westchester | New York | 36119 | 93584 | 1894 |
977507 | 977507 | 2021-01-29 | Westchester | New York | 36119 | 92793 | 1884 |
974262 | 974262 | 2021-01-28 | Westchester | New York | 36119 | 92061 | 1875 |
971017 | 971017 | 2021-01-27 | Westchester | New York | 36119 | 91222 | 1864 |
967772 | 967772 | 2021-01-26 | Westchester | New York | 36119 | 90664 | 1858 |
964528 | 964528 | 2021-01-25 | Westchester | New York | 36119 | 90028 | 1851 |
961283 | 961283 | 2021-01-24 | Westchester | New York | 36119 | 89224 | 1846 |
958038 | 958038 | 2021-01-23 | Westchester | New York | 36119 | 88403 | 1836 |
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);