ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 36107 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 |
---|---|---|---|---|---|---|---|
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 |
1516402 | 1516402 | 2021-07-14 | Tioga | New York | 36107 | 3851 | 63 |
1513155 | 1513155 | 2021-07-13 | Tioga | New York | 36107 | 3848 | 63 |
1509909 | 1509909 | 2021-07-12 | Tioga | New York | 36107 | 3845 | 63 |
1506662 | 1506662 | 2021-07-11 | Tioga | New York | 36107 | 3845 | 63 |
1503416 | 1503416 | 2021-07-10 | Tioga | New York | 36107 | 3845 | 63 |
1500170 | 1500170 | 2021-07-09 | Tioga | New York | 36107 | 3844 | 63 |
1496924 | 1496924 | 2021-07-08 | Tioga | New York | 36107 | 3844 | 63 |
1493677 | 1493677 | 2021-07-07 | Tioga | New York | 36107 | 3843 | 63 |
1490430 | 1490430 | 2021-07-06 | Tioga | New York | 36107 | 3843 | 63 |
1487183 | 1487183 | 2021-07-05 | Tioga | New York | 36107 | 3843 | 63 |
1483937 | 1483937 | 2021-07-04 | Tioga | New York | 36107 | 3843 | 63 |
1480691 | 1480691 | 2021-07-03 | Tioga | New York | 36107 | 3842 | 63 |
1477444 | 1477444 | 2021-07-02 | Tioga | New York | 36107 | 3842 | 63 |
1474198 | 1474198 | 2021-07-01 | Tioga | New York | 36107 | 3842 | 63 |
1470952 | 1470952 | 2021-06-30 | Tioga | New York | 36107 | 3842 | 63 |
1467707 | 1467707 | 2021-06-29 | Tioga | New York | 36107 | 3842 | 63 |
1464462 | 1464462 | 2021-06-28 | Tioga | New York | 36107 | 3841 | 63 |
1461217 | 1461217 | 2021-06-27 | Tioga | New York | 36107 | 3840 | 63 |
1457972 | 1457972 | 2021-06-26 | Tioga | New York | 36107 | 3840 | 63 |
1454727 | 1454727 | 2021-06-25 | Tioga | New York | 36107 | 3839 | 63 |
1451482 | 1451482 | 2021-06-24 | Tioga | New York | 36107 | 3839 | 63 |
1448236 | 1448236 | 2021-06-23 | Tioga | New York | 36107 | 3838 | 63 |
1444991 | 1444991 | 2021-06-22 | Tioga | New York | 36107 | 3837 | 63 |
1441746 | 1441746 | 2021-06-21 | Tioga | New York | 36107 | 3836 | 63 |
1438501 | 1438501 | 2021-06-20 | Tioga | New York | 36107 | 3834 | 63 |
1435254 | 1435254 | 2021-06-19 | Tioga | New York | 36107 | 3834 | 63 |
1432007 | 1432007 | 2021-06-18 | Tioga | New York | 36107 | 3831 | 63 |
1428761 | 1428761 | 2021-06-17 | Tioga | New York | 36107 | 3830 | 63 |
1425516 | 1425516 | 2021-06-16 | Tioga | New York | 36107 | 3830 | 63 |
1422269 | 1422269 | 2021-06-15 | Tioga | New York | 36107 | 3830 | 63 |
1419023 | 1419023 | 2021-06-14 | Tioga | New York | 36107 | 3829 | 63 |
1415778 | 1415778 | 2021-06-13 | Tioga | New York | 36107 | 3829 | 63 |
1412532 | 1412532 | 2021-06-12 | Tioga | New York | 36107 | 3827 | 63 |
1409287 | 1409287 | 2021-06-11 | Tioga | New York | 36107 | 3827 | 63 |
1406042 | 1406042 | 2021-06-10 | Tioga | New York | 36107 | 3821 | 63 |
1402796 | 1402796 | 2021-06-09 | Tioga | New York | 36107 | 3820 | 63 |
1399551 | 1399551 | 2021-06-08 | Tioga | New York | 36107 | 3817 | 63 |
1396306 | 1396306 | 2021-06-07 | Tioga | New York | 36107 | 3815 | 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);