ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 36119 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 |
---|---|---|---|---|---|---|---|
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 |
954792 | 954792 | 2021-01-22 | Westchester | New York | 36119 | 87569 | 1832 |
951547 | 951547 | 2021-01-21 | Westchester | New York | 36119 | 86645 | 1824 |
948302 | 948302 | 2021-01-20 | Westchester | New York | 36119 | 85722 | 1819 |
945055 | 945055 | 2021-01-19 | Westchester | New York | 36119 | 85019 | 1806 |
941809 | 941809 | 2021-01-18 | Westchester | New York | 36119 | 84419 | 1797 |
938564 | 938564 | 2021-01-17 | Westchester | New York | 36119 | 83707 | 1789 |
935319 | 935319 | 2021-01-16 | Westchester | New York | 36119 | 82932 | 1780 |
932074 | 932074 | 2021-01-15 | Westchester | New York | 36119 | 81981 | 1774 |
928829 | 928829 | 2021-01-14 | Westchester | New York | 36119 | 80868 | 1763 |
925584 | 925584 | 2021-01-13 | Westchester | New York | 36119 | 80145 | 1750 |
922338 | 922338 | 2021-01-12 | Westchester | New York | 36119 | 79405 | 1744 |
919093 | 919093 | 2021-01-11 | Westchester | New York | 36119 | 78533 | 1736 |
915848 | 915848 | 2021-01-10 | Westchester | New York | 36119 | 77730 | 1730 |
912603 | 912603 | 2021-01-09 | Westchester | New York | 36119 | 76941 | 1721 |
909358 | 909358 | 2021-01-08 | Westchester | New York | 36119 | 76088 | 1713 |
906113 | 906113 | 2021-01-07 | Westchester | New York | 36119 | 75175 | 1711 |
902867 | 902867 | 2021-01-06 | Westchester | New York | 36119 | 74156 | 1697 |
899622 | 899622 | 2021-01-05 | Westchester | New York | 36119 | 73380 | 1692 |
896377 | 896377 | 2021-01-04 | Westchester | New York | 36119 | 72761 | 1683 |
893131 | 893131 | 2021-01-03 | Westchester | New York | 36119 | 72217 | 1681 |
889885 | 889885 | 2021-01-02 | Westchester | New York | 36119 | 71626 | 1677 |
886638 | 886638 | 2021-01-01 | Westchester | New York | 36119 | 70613 | 1675 |
883393 | 883393 | 2020-12-31 | Westchester | New York | 36119 | 69660 | 1664 |
880148 | 880148 | 2020-12-30 | Westchester | New York | 36119 | 68701 | 1661 |
876903 | 876903 | 2020-12-29 | Westchester | New York | 36119 | 67930 | 1656 |
873658 | 873658 | 2020-12-28 | Westchester | New York | 36119 | 67387 | 1652 |
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);