ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36025 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 |
---|---|---|---|---|---|---|---|
1279401 | 1279401 | 2021-05-02 | Delaware | New York | 36025 | 2271 | 37 |
1276154 | 1276154 | 2021-05-01 | Delaware | New York | 36025 | 2266 | 37 |
1272907 | 1272907 | 2021-04-30 | Delaware | New York | 36025 | 2258 | 37 |
1269660 | 1269660 | 2021-04-29 | Delaware | New York | 36025 | 2249 | 37 |
1266413 | 1266413 | 2021-04-28 | Delaware | New York | 36025 | 2243 | 37 |
1263166 | 1263166 | 2021-04-27 | Delaware | New York | 36025 | 2238 | 37 |
1259919 | 1259919 | 2021-04-26 | Delaware | New York | 36025 | 2237 | 37 |
1256672 | 1256672 | 2021-04-25 | Delaware | New York | 36025 | 2234 | 37 |
1253425 | 1253425 | 2021-04-24 | Delaware | New York | 36025 | 2228 | 37 |
1250178 | 1250178 | 2021-04-23 | Delaware | New York | 36025 | 2213 | 37 |
1246931 | 1246931 | 2021-04-22 | Delaware | New York | 36025 | 2201 | 37 |
1243684 | 1243684 | 2021-04-21 | Delaware | New York | 36025 | 2195 | 37 |
1240437 | 1240437 | 2021-04-20 | Delaware | New York | 36025 | 2183 | 36 |
1237190 | 1237190 | 2021-04-19 | Delaware | New York | 36025 | 2180 | 36 |
1233943 | 1233943 | 2021-04-18 | Delaware | New York | 36025 | 2170 | 36 |
1230695 | 1230695 | 2021-04-17 | Delaware | New York | 36025 | 2156 | 36 |
1227447 | 1227447 | 2021-04-16 | Delaware | New York | 36025 | 2142 | 36 |
1224199 | 1224199 | 2021-04-15 | Delaware | New York | 36025 | 2137 | 36 |
1220952 | 1220952 | 2021-04-14 | Delaware | New York | 36025 | 2119 | 36 |
1217704 | 1217704 | 2021-04-13 | Delaware | New York | 36025 | 2112 | 36 |
1214456 | 1214456 | 2021-04-12 | Delaware | New York | 36025 | 2103 | 36 |
1211209 | 1211209 | 2021-04-11 | Delaware | New York | 36025 | 2095 | 36 |
1207960 | 1207960 | 2021-04-10 | Delaware | New York | 36025 | 2083 | 35 |
1204712 | 1204712 | 2021-04-09 | Delaware | New York | 36025 | 2069 | 35 |
1201464 | 1201464 | 2021-04-08 | Delaware | New York | 36025 | 2048 | 35 |
1198215 | 1198215 | 2021-04-07 | Delaware | New York | 36025 | 2040 | 35 |
1194966 | 1194966 | 2021-04-06 | Delaware | New York | 36025 | 2028 | 34 |
1191718 | 1191718 | 2021-04-05 | Delaware | New York | 36025 | 2021 | 34 |
1188469 | 1188469 | 2021-04-04 | Delaware | New York | 36025 | 2013 | 34 |
1185222 | 1185222 | 2021-04-03 | Delaware | New York | 36025 | 2001 | 34 |
1181975 | 1181975 | 2021-04-02 | Delaware | New York | 36025 | 1980 | 34 |
1178728 | 1178728 | 2021-04-01 | Delaware | New York | 36025 | 1952 | 34 |
1175481 | 1175481 | 2021-03-31 | Delaware | New York | 36025 | 1913 | 34 |
1172234 | 1172234 | 2021-03-30 | Delaware | New York | 36025 | 1894 | 34 |
1168987 | 1168987 | 2021-03-29 | Delaware | New York | 36025 | 1887 | 34 |
1165739 | 1165739 | 2021-03-28 | Delaware | New York | 36025 | 1879 | 34 |
1162491 | 1162491 | 2021-03-27 | Delaware | New York | 36025 | 1863 | 34 |
1159242 | 1159242 | 2021-03-26 | Delaware | New York | 36025 | 1846 | 34 |
1155995 | 1155995 | 2021-03-25 | Delaware | New York | 36025 | 1834 | 34 |
1152748 | 1152748 | 2021-03-24 | Delaware | New York | 36025 | 1817 | 34 |
1149501 | 1149501 | 2021-03-23 | Delaware | New York | 36025 | 1805 | 34 |
1146254 | 1146254 | 2021-03-22 | Delaware | New York | 36025 | 1798 | 34 |
1143007 | 1143007 | 2021-03-21 | Delaware | New York | 36025 | 1786 | 34 |
1139760 | 1139760 | 2021-03-20 | Delaware | New York | 36025 | 1771 | 34 |
1136514 | 1136514 | 2021-03-19 | Delaware | New York | 36025 | 1752 | 34 |
1133268 | 1133268 | 2021-03-18 | Delaware | New York | 36025 | 1737 | 34 |
1130020 | 1130020 | 2021-03-17 | Delaware | New York | 36025 | 1721 | 34 |
1126773 | 1126773 | 2021-03-16 | Delaware | New York | 36025 | 1710 | 34 |
1123527 | 1123527 | 2021-03-15 | Delaware | New York | 36025 | 1707 | 34 |
1120281 | 1120281 | 2021-03-14 | Delaware | New York | 36025 | 1697 | 34 |
1117034 | 1117034 | 2021-03-13 | Delaware | New York | 36025 | 1686 | 34 |
1113787 | 1113787 | 2021-03-12 | Delaware | New York | 36025 | 1662 | 33 |
1110541 | 1110541 | 2021-03-11 | Delaware | New York | 36025 | 1635 | 33 |
1107295 | 1107295 | 2021-03-10 | Delaware | New York | 36025 | 1626 | 33 |
1104049 | 1104049 | 2021-03-09 | Delaware | New York | 36025 | 1615 | 33 |
1100803 | 1100803 | 2021-03-08 | Delaware | New York | 36025 | 1605 | 33 |
1097557 | 1097557 | 2021-03-07 | Delaware | New York | 36025 | 1590 | 33 |
1094309 | 1094309 | 2021-03-06 | Delaware | New York | 36025 | 1573 | 33 |
1091063 | 1091063 | 2021-03-05 | Delaware | New York | 36025 | 1560 | 33 |
1087818 | 1087818 | 2021-03-04 | Delaware | New York | 36025 | 1543 | 33 |
1084573 | 1084573 | 2021-03-03 | Delaware | New York | 36025 | 1535 | 33 |
1081327 | 1081327 | 2021-03-02 | Delaware | New York | 36025 | 1524 | 33 |
1078081 | 1078081 | 2021-03-01 | Delaware | New York | 36025 | 1519 | 33 |
1074836 | 1074836 | 2021-02-28 | Delaware | New York | 36025 | 1508 | 33 |
1071590 | 1071590 | 2021-02-27 | Delaware | New York | 36025 | 1498 | 33 |
1068344 | 1068344 | 2021-02-26 | Delaware | New York | 36025 | 1486 | 33 |
1065099 | 1065099 | 2021-02-25 | Delaware | New York | 36025 | 1478 | 33 |
1061855 | 1061855 | 2021-02-24 | Delaware | New York | 36025 | 1469 | 33 |
1058609 | 1058609 | 2021-02-23 | Delaware | New York | 36025 | 1463 | 33 |
1055363 | 1055363 | 2021-02-22 | Delaware | New York | 36025 | 1458 | 33 |
1052117 | 1052117 | 2021-02-21 | Delaware | New York | 36025 | 1448 | 33 |
1048870 | 1048870 | 2021-02-20 | Delaware | New York | 36025 | 1438 | 32 |
1045623 | 1045623 | 2021-02-19 | Delaware | New York | 36025 | 1431 | 32 |
1042378 | 1042378 | 2021-02-18 | Delaware | New York | 36025 | 1411 | 32 |
1039133 | 1039133 | 2021-02-17 | Delaware | New York | 36025 | 1392 | 32 |
1035888 | 1035888 | 2021-02-16 | Delaware | New York | 36025 | 1385 | 32 |
1032643 | 1032643 | 2021-02-15 | Delaware | New York | 36025 | 1371 | 31 |
1029397 | 1029397 | 2021-02-14 | Delaware | New York | 36025 | 1365 | 31 |
1026150 | 1026150 | 2021-02-13 | Delaware | New York | 36025 | 1352 | 31 |
1022905 | 1022905 | 2021-02-12 | Delaware | New York | 36025 | 1340 | 31 |
1019660 | 1019660 | 2021-02-11 | Delaware | New York | 36025 | 1321 | 31 |
1016415 | 1016415 | 2021-02-10 | Delaware | New York | 36025 | 1301 | 31 |
1013170 | 1013170 | 2021-02-09 | Delaware | New York | 36025 | 1290 | 31 |
1009925 | 1009925 | 2021-02-08 | Delaware | New York | 36025 | 1285 | 31 |
1006679 | 1006679 | 2021-02-07 | Delaware | New York | 36025 | 1277 | 31 |
1003433 | 1003433 | 2021-02-06 | Delaware | New York | 36025 | 1261 | 31 |
1000187 | 1000187 | 2021-02-05 | Delaware | New York | 36025 | 1253 | 31 |
996941 | 996941 | 2021-02-04 | Delaware | New York | 36025 | 1241 | 31 |
993695 | 993695 | 2021-02-03 | Delaware | New York | 36025 | 1234 | 30 |
990449 | 990449 | 2021-02-02 | Delaware | New York | 36025 | 1233 | 29 |
987203 | 987203 | 2021-02-01 | Delaware | New York | 36025 | 1226 | 29 |
983956 | 983956 | 2021-01-31 | Delaware | New York | 36025 | 1217 | 29 |
980709 | 980709 | 2021-01-30 | Delaware | New York | 36025 | 1205 | 29 |
977463 | 977463 | 2021-01-29 | Delaware | New York | 36025 | 1197 | 29 |
974218 | 974218 | 2021-01-28 | Delaware | New York | 36025 | 1179 | 29 |
970973 | 970973 | 2021-01-27 | Delaware | New York | 36025 | 1167 | 29 |
967728 | 967728 | 2021-01-26 | Delaware | New York | 36025 | 1159 | 29 |
964484 | 964484 | 2021-01-25 | Delaware | New York | 36025 | 1134 | 29 |
961239 | 961239 | 2021-01-24 | Delaware | New York | 36025 | 1119 | 28 |
957994 | 957994 | 2021-01-23 | Delaware | New York | 36025 | 1100 | 27 |
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);