ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Schenectady" 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 |
---|---|---|---|---|---|---|---|
1717781 | 1717781 | 2021-09-14 | Schenectady | New York | 36093 | 14951 | 213 |
1714533 | 1714533 | 2021-09-13 | Schenectady | New York | 36093 | 14921 | 213 |
1711287 | 1711287 | 2021-09-12 | Schenectady | New York | 36093 | 14885 | 213 |
1708040 | 1708040 | 2021-09-11 | Schenectady | New York | 36093 | 14854 | 213 |
1704793 | 1704793 | 2021-09-10 | Schenectady | New York | 36093 | 14809 | 212 |
1701543 | 1701543 | 2021-09-09 | Schenectady | New York | 36093 | 14774 | 212 |
1698294 | 1698294 | 2021-09-08 | Schenectady | New York | 36093 | 14726 | 212 |
1695046 | 1695046 | 2021-09-07 | Schenectady | New York | 36093 | 14703 | 211 |
1691798 | 1691798 | 2021-09-06 | Schenectady | New York | 36093 | 14678 | 210 |
1688548 | 1688548 | 2021-09-05 | Schenectady | New York | 36093 | 14654 | 210 |
1685298 | 1685298 | 2021-09-04 | Schenectady | New York | 36093 | 14626 | 209 |
1682047 | 1682047 | 2021-09-03 | Schenectady | New York | 36093 | 14568 | 209 |
1678798 | 1678798 | 2021-09-02 | Schenectady | New York | 36093 | 14529 | 209 |
1675550 | 1675550 | 2021-09-01 | Schenectady | New York | 36093 | 14493 | 209 |
1672303 | 1672303 | 2021-08-31 | Schenectady | New York | 36093 | 14454 | 209 |
1669055 | 1669055 | 2021-08-30 | Schenectady | New York | 36093 | 14412 | 209 |
1665808 | 1665808 | 2021-08-29 | Schenectady | New York | 36093 | 14380 | 209 |
1662560 | 1662560 | 2021-08-28 | Schenectady | New York | 36093 | 14349 | 209 |
1659312 | 1659312 | 2021-08-27 | Schenectady | New York | 36093 | 14315 | 209 |
1656063 | 1656063 | 2021-08-26 | Schenectady | New York | 36093 | 14213 | 209 |
1652816 | 1652816 | 2021-08-25 | Schenectady | New York | 36093 | 14198 | 209 |
1649568 | 1649568 | 2021-08-24 | Schenectady | New York | 36093 | 14169 | 209 |
1646319 | 1646319 | 2021-08-23 | Schenectady | New York | 36093 | 14149 | 209 |
1643070 | 1643070 | 2021-08-22 | Schenectady | New York | 36093 | 14113 | 209 |
1639820 | 1639820 | 2021-08-21 | Schenectady | New York | 36093 | 14083 | 209 |
1636570 | 1636570 | 2021-08-20 | Schenectady | New York | 36093 | 14043 | 209 |
1633320 | 1633320 | 2021-08-19 | Schenectady | New York | 36093 | 13996 | 209 |
1630073 | 1630073 | 2021-08-18 | Schenectady | New York | 36093 | 13943 | 209 |
1626826 | 1626826 | 2021-08-17 | Schenectady | New York | 36093 | 13900 | 208 |
1623579 | 1623579 | 2021-08-16 | Schenectady | New York | 36093 | 13870 | 208 |
1620332 | 1620332 | 2021-08-15 | Schenectady | New York | 36093 | 13826 | 208 |
1617084 | 1617084 | 2021-08-14 | Schenectady | New York | 36093 | 13794 | 208 |
1613836 | 1613836 | 2021-08-13 | Schenectady | New York | 36093 | 13753 | 208 |
1610587 | 1610587 | 2021-08-12 | Schenectady | New York | 36093 | 13695 | 208 |
1607339 | 1607339 | 2021-08-11 | Schenectady | New York | 36093 | 13659 | 207 |
1604090 | 1604090 | 2021-08-10 | Schenectady | New York | 36093 | 13622 | 207 |
1600841 | 1600841 | 2021-08-09 | Schenectady | New York | 36093 | 13587 | 206 |
1597593 | 1597593 | 2021-08-08 | Schenectady | New York | 36093 | 13567 | 206 |
1594344 | 1594344 | 2021-08-07 | Schenectady | New York | 36093 | 13543 | 206 |
1591095 | 1591095 | 2021-08-06 | Schenectady | New York | 36093 | 13500 | 206 |
1587846 | 1587846 | 2021-08-05 | Schenectady | New York | 36093 | 13474 | 206 |
1584596 | 1584596 | 2021-08-04 | Schenectady | New York | 36093 | 13449 | 206 |
1581346 | 1581346 | 2021-08-03 | Schenectady | New York | 36093 | 13432 | 206 |
1578097 | 1578097 | 2021-08-02 | Schenectady | New York | 36093 | 13411 | 206 |
1574849 | 1574849 | 2021-08-01 | Schenectady | New York | 36093 | 13400 | 206 |
1571601 | 1571601 | 2021-07-31 | Schenectady | New York | 36093 | 13383 | 206 |
1568353 | 1568353 | 2021-07-30 | Schenectady | New York | 36093 | 13361 | 206 |
1565105 | 1565105 | 2021-07-29 | Schenectady | New York | 36093 | 13347 | 206 |
1561857 | 1561857 | 2021-07-28 | Schenectady | New York | 36093 | 13327 | 206 |
1558609 | 1558609 | 2021-07-27 | Schenectady | New York | 36093 | 13309 | 205 |
1555362 | 1555362 | 2021-07-26 | Schenectady | New York | 36093 | 13303 | 205 |
1552115 | 1552115 | 2021-07-25 | Schenectady | New York | 36093 | 13299 | 205 |
1548868 | 1548868 | 2021-07-24 | Schenectady | New York | 36093 | 13291 | 205 |
1545621 | 1545621 | 2021-07-23 | Schenectady | New York | 36093 | 13281 | 205 |
1542374 | 1542374 | 2021-07-22 | Schenectady | New York | 36093 | 13263 | 205 |
1539126 | 1539126 | 2021-07-21 | Schenectady | New York | 36093 | 13259 | 205 |
1535879 | 1535879 | 2021-07-20 | Schenectady | New York | 36093 | 13250 | 205 |
1532631 | 1532631 | 2021-07-19 | Schenectady | New York | 36093 | 13245 | 205 |
1529384 | 1529384 | 2021-07-18 | Schenectady | New York | 36093 | 13244 | 205 |
1526137 | 1526137 | 2021-07-17 | Schenectady | New York | 36093 | 13240 | 205 |
1522890 | 1522890 | 2021-07-16 | Schenectady | New York | 36093 | 13234 | 205 |
1519642 | 1519642 | 2021-07-15 | Schenectady | New York | 36093 | 13230 | 205 |
1516394 | 1516394 | 2021-07-14 | Schenectady | New York | 36093 | 13228 | 205 |
1513147 | 1513147 | 2021-07-13 | Schenectady | New York | 36093 | 13228 | 205 |
1509901 | 1509901 | 2021-07-12 | Schenectady | New York | 36093 | 13226 | 205 |
1506654 | 1506654 | 2021-07-11 | Schenectady | New York | 36093 | 13222 | 205 |
1503408 | 1503408 | 2021-07-10 | Schenectady | New York | 36093 | 13222 | 205 |
1500162 | 1500162 | 2021-07-09 | Schenectady | New York | 36093 | 13222 | 205 |
1496916 | 1496916 | 2021-07-08 | Schenectady | New York | 36093 | 13222 | 205 |
1493669 | 1493669 | 2021-07-07 | Schenectady | New York | 36093 | 13221 | 205 |
1490422 | 1490422 | 2021-07-06 | Schenectady | New York | 36093 | 13220 | 205 |
1487175 | 1487175 | 2021-07-05 | Schenectady | New York | 36093 | 13219 | 205 |
1483929 | 1483929 | 2021-07-04 | Schenectady | New York | 36093 | 13219 | 205 |
1480683 | 1480683 | 2021-07-03 | Schenectady | New York | 36093 | 13219 | 205 |
1477436 | 1477436 | 2021-07-02 | Schenectady | New York | 36093 | 13219 | 205 |
1474190 | 1474190 | 2021-07-01 | Schenectady | New York | 36093 | 13217 | 205 |
1470944 | 1470944 | 2021-06-30 | Schenectady | New York | 36093 | 13217 | 205 |
1467699 | 1467699 | 2021-06-29 | Schenectady | New York | 36093 | 13217 | 205 |
1464454 | 1464454 | 2021-06-28 | Schenectady | New York | 36093 | 13217 | 205 |
1461209 | 1461209 | 2021-06-27 | Schenectady | New York | 36093 | 13217 | 205 |
1457964 | 1457964 | 2021-06-26 | Schenectady | New York | 36093 | 13216 | 205 |
1454719 | 1454719 | 2021-06-25 | Schenectady | New York | 36093 | 13216 | 205 |
1451474 | 1451474 | 2021-06-24 | Schenectady | New York | 36093 | 13216 | 205 |
1448228 | 1448228 | 2021-06-23 | Schenectady | New York | 36093 | 13213 | 205 |
1444983 | 1444983 | 2021-06-22 | Schenectady | New York | 36093 | 13210 | 205 |
1441738 | 1441738 | 2021-06-21 | Schenectady | New York | 36093 | 13209 | 205 |
1438493 | 1438493 | 2021-06-20 | Schenectady | New York | 36093 | 13208 | 205 |
1435246 | 1435246 | 2021-06-19 | Schenectady | New York | 36093 | 13207 | 205 |
1431999 | 1431999 | 2021-06-18 | Schenectady | New York | 36093 | 13207 | 205 |
1428753 | 1428753 | 2021-06-17 | Schenectady | New York | 36093 | 13207 | 205 |
1425508 | 1425508 | 2021-06-16 | Schenectady | New York | 36093 | 13204 | 205 |
1422261 | 1422261 | 2021-06-15 | Schenectady | New York | 36093 | 13202 | 205 |
1419015 | 1419015 | 2021-06-14 | Schenectady | New York | 36093 | 13200 | 205 |
1415770 | 1415770 | 2021-06-13 | Schenectady | New York | 36093 | 13197 | 205 |
1412524 | 1412524 | 2021-06-12 | Schenectady | New York | 36093 | 13192 | 205 |
1409279 | 1409279 | 2021-06-11 | Schenectady | New York | 36093 | 13190 | 205 |
1406034 | 1406034 | 2021-06-10 | Schenectady | New York | 36093 | 13186 | 205 |
1402788 | 1402788 | 2021-06-09 | Schenectady | New York | 36093 | 13184 | 205 |
1399543 | 1399543 | 2021-06-08 | Schenectady | New York | 36093 | 13182 | 205 |
1396298 | 1396298 | 2021-06-07 | Schenectady | New York | 36093 | 13180 | 204 |
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);