ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Tioga" 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 |
---|---|---|---|---|---|---|---|
1841254 | 1841254 | 2021-10-22 | Tioga | New York | 36107 | 5130 | 72 |
1838005 | 1838005 | 2021-10-21 | Tioga | New York | 36107 | 5094 | 71 |
1834756 | 1834756 | 2021-10-20 | Tioga | New York | 36107 | 5061 | 71 |
1831507 | 1831507 | 2021-10-19 | Tioga | New York | 36107 | 5036 | 71 |
1828258 | 1828258 | 2021-10-18 | Tioga | New York | 36107 | 5025 | 71 |
1825009 | 1825009 | 2021-10-17 | Tioga | New York | 36107 | 5012 | 71 |
1821760 | 1821760 | 2021-10-16 | Tioga | New York | 36107 | 4980 | 71 |
1818511 | 1818511 | 2021-10-15 | Tioga | New York | 36107 | 4946 | 71 |
1815262 | 1815262 | 2021-10-14 | Tioga | New York | 36107 | 4903 | 71 |
1812014 | 1812014 | 2021-10-13 | Tioga | New York | 36107 | 4871 | 70 |
1808765 | 1808765 | 2021-10-12 | Tioga | New York | 36107 | 4845 | 70 |
1805514 | 1805514 | 2021-10-11 | Tioga | New York | 36107 | 4834 | 70 |
1802265 | 1802265 | 2021-10-10 | Tioga | New York | 36107 | 4807 | 70 |
1799016 | 1799016 | 2021-10-09 | Tioga | New York | 36107 | 4789 | 69 |
1795767 | 1795767 | 2021-10-08 | Tioga | New York | 36107 | 4754 | 69 |
1792518 | 1792518 | 2021-10-07 | Tioga | New York | 36107 | 4726 | 68 |
1789269 | 1789269 | 2021-10-06 | Tioga | New York | 36107 | 4694 | 68 |
1786021 | 1786021 | 2021-10-05 | Tioga | New York | 36107 | 4661 | 68 |
1782772 | 1782772 | 2021-10-04 | Tioga | New York | 36107 | 4647 | 68 |
1779523 | 1779523 | 2021-10-03 | Tioga | New York | 36107 | 4637 | 68 |
1776273 | 1776273 | 2021-10-02 | Tioga | New York | 36107 | 4611 | 68 |
1773023 | 1773023 | 2021-10-01 | Tioga | New York | 36107 | 4592 | 68 |
1769773 | 1769773 | 2021-09-30 | Tioga | New York | 36107 | 4571 | 68 |
1766524 | 1766524 | 2021-09-29 | Tioga | New York | 36107 | 4544 | 68 |
1763275 | 1763275 | 2021-09-28 | Tioga | New York | 36107 | 4521 | 68 |
1760026 | 1760026 | 2021-09-27 | Tioga | New York | 36107 | 4513 | 68 |
1756778 | 1756778 | 2021-09-26 | Tioga | New York | 36107 | 4505 | 67 |
1753530 | 1753530 | 2021-09-25 | Tioga | New York | 36107 | 4484 | 67 |
1750282 | 1750282 | 2021-09-24 | Tioga | New York | 36107 | 4464 | 67 |
1747032 | 1747032 | 2021-09-23 | Tioga | New York | 36107 | 4434 | 67 |
1743783 | 1743783 | 2021-09-22 | Tioga | New York | 36107 | 4400 | 67 |
1740534 | 1740534 | 2021-09-21 | Tioga | New York | 36107 | 4385 | 67 |
1737285 | 1737285 | 2021-09-20 | Tioga | New York | 36107 | 4376 | 67 |
1734035 | 1734035 | 2021-09-19 | Tioga | New York | 36107 | 4368 | 67 |
1730785 | 1730785 | 2021-09-18 | Tioga | New York | 36107 | 4360 | 67 |
1727535 | 1727535 | 2021-09-17 | Tioga | New York | 36107 | 4344 | 66 |
1724286 | 1724286 | 2021-09-16 | Tioga | New York | 36107 | 4326 | 66 |
1721037 | 1721037 | 2021-09-15 | Tioga | New York | 36107 | 4311 | 65 |
1717789 | 1717789 | 2021-09-14 | Tioga | New York | 36107 | 4291 | 65 |
1714541 | 1714541 | 2021-09-13 | Tioga | New York | 36107 | 4282 | 65 |
1711295 | 1711295 | 2021-09-12 | Tioga | New York | 36107 | 4264 | 65 |
1708048 | 1708048 | 2021-09-11 | Tioga | New York | 36107 | 4248 | 65 |
1704801 | 1704801 | 2021-09-10 | Tioga | New York | 36107 | 4224 | 65 |
1701551 | 1701551 | 2021-09-09 | Tioga | New York | 36107 | 4206 | 65 |
1698302 | 1698302 | 2021-09-08 | Tioga | New York | 36107 | 4185 | 65 |
1695054 | 1695054 | 2021-09-07 | Tioga | New York | 36107 | 4178 | 65 |
1691806 | 1691806 | 2021-09-06 | Tioga | New York | 36107 | 4168 | 65 |
1688556 | 1688556 | 2021-09-05 | Tioga | New York | 36107 | 4159 | 65 |
1685306 | 1685306 | 2021-09-04 | Tioga | New York | 36107 | 4149 | 65 |
1682055 | 1682055 | 2021-09-03 | Tioga | New York | 36107 | 4133 | 65 |
1678806 | 1678806 | 2021-09-02 | Tioga | New York | 36107 | 4119 | 65 |
1675558 | 1675558 | 2021-09-01 | Tioga | New York | 36107 | 4102 | 65 |
1672311 | 1672311 | 2021-08-31 | Tioga | New York | 36107 | 4092 | 65 |
1669063 | 1669063 | 2021-08-30 | Tioga | New York | 36107 | 4085 | 65 |
1665816 | 1665816 | 2021-08-29 | Tioga | New York | 36107 | 4077 | 65 |
1662568 | 1662568 | 2021-08-28 | Tioga | New York | 36107 | 4067 | 65 |
1659320 | 1659320 | 2021-08-27 | Tioga | New York | 36107 | 4054 | 65 |
1656071 | 1656071 | 2021-08-26 | Tioga | New York | 36107 | 4040 | 65 |
1652824 | 1652824 | 2021-08-25 | Tioga | New York | 36107 | 4034 | 65 |
1649576 | 1649576 | 2021-08-24 | Tioga | New York | 36107 | 4024 | 65 |
1646327 | 1646327 | 2021-08-23 | Tioga | New York | 36107 | 4022 | 65 |
1643078 | 1643078 | 2021-08-22 | Tioga | New York | 36107 | 4019 | 65 |
1639828 | 1639828 | 2021-08-21 | Tioga | New York | 36107 | 4009 | 64 |
1636578 | 1636578 | 2021-08-20 | Tioga | New York | 36107 | 4003 | 64 |
1633328 | 1633328 | 2021-08-19 | Tioga | New York | 36107 | 4000 | 63 |
1630081 | 1630081 | 2021-08-18 | Tioga | New York | 36107 | 3990 | 63 |
1626834 | 1626834 | 2021-08-17 | Tioga | New York | 36107 | 3981 | 63 |
1623587 | 1623587 | 2021-08-16 | Tioga | New York | 36107 | 3974 | 63 |
1620340 | 1620340 | 2021-08-15 | Tioga | New York | 36107 | 3968 | 63 |
1617092 | 1617092 | 2021-08-14 | Tioga | New York | 36107 | 3966 | 63 |
1613844 | 1613844 | 2021-08-13 | Tioga | New York | 36107 | 3958 | 63 |
1610595 | 1610595 | 2021-08-12 | Tioga | New York | 36107 | 3945 | 63 |
1607347 | 1607347 | 2021-08-11 | Tioga | New York | 36107 | 3932 | 63 |
1604098 | 1604098 | 2021-08-10 | Tioga | New York | 36107 | 3923 | 63 |
1600849 | 1600849 | 2021-08-09 | Tioga | New York | 36107 | 3921 | 63 |
1597601 | 1597601 | 2021-08-08 | Tioga | New York | 36107 | 3918 | 63 |
1594352 | 1594352 | 2021-08-07 | Tioga | New York | 36107 | 3912 | 63 |
1591103 | 1591103 | 2021-08-06 | Tioga | New York | 36107 | 3904 | 63 |
1587854 | 1587854 | 2021-08-05 | Tioga | New York | 36107 | 3894 | 63 |
1584604 | 1584604 | 2021-08-04 | Tioga | New York | 36107 | 3883 | 63 |
1581354 | 1581354 | 2021-08-03 | Tioga | New York | 36107 | 3883 | 63 |
1578105 | 1578105 | 2021-08-02 | Tioga | New York | 36107 | 3878 | 63 |
1574857 | 1574857 | 2021-08-01 | Tioga | New York | 36107 | 3876 | 63 |
1571609 | 1571609 | 2021-07-31 | Tioga | New York | 36107 | 3876 | 63 |
1568361 | 1568361 | 2021-07-30 | Tioga | New York | 36107 | 3871 | 63 |
1565113 | 1565113 | 2021-07-29 | Tioga | New York | 36107 | 3869 | 63 |
1561865 | 1561865 | 2021-07-28 | Tioga | New York | 36107 | 3866 | 63 |
1558617 | 1558617 | 2021-07-27 | Tioga | New York | 36107 | 3862 | 63 |
1555370 | 1555370 | 2021-07-26 | Tioga | New York | 36107 | 3861 | 63 |
1552123 | 1552123 | 2021-07-25 | Tioga | New York | 36107 | 3859 | 63 |
1548876 | 1548876 | 2021-07-24 | Tioga | New York | 36107 | 3858 | 63 |
1545629 | 1545629 | 2021-07-23 | Tioga | New York | 36107 | 3858 | 63 |
1542382 | 1542382 | 2021-07-22 | Tioga | New York | 36107 | 3857 | 63 |
1539134 | 1539134 | 2021-07-21 | Tioga | New York | 36107 | 3857 | 63 |
1535887 | 1535887 | 2021-07-20 | Tioga | New York | 36107 | 3854 | 63 |
1532639 | 1532639 | 2021-07-19 | Tioga | New York | 36107 | 3852 | 63 |
1529392 | 1529392 | 2021-07-18 | Tioga | New York | 36107 | 3852 | 63 |
1526145 | 1526145 | 2021-07-17 | Tioga | New York | 36107 | 3852 | 63 |
1522898 | 1522898 | 2021-07-16 | Tioga | New York | 36107 | 3852 | 63 |
1519650 | 1519650 | 2021-07-15 | Tioga | New York | 36107 | 3851 | 63 |
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);