ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 36111 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 |
---|---|---|---|---|---|---|---|
1717791 | 1717791 | 2021-09-14 | Ulster | New York | 36111 | 16003 | 270 |
1714543 | 1714543 | 2021-09-13 | Ulster | New York | 36111 | 15968 | 268 |
1711297 | 1711297 | 2021-09-12 | Ulster | New York | 36111 | 15935 | 268 |
1708050 | 1708050 | 2021-09-11 | Ulster | New York | 36111 | 15839 | 268 |
1704803 | 1704803 | 2021-09-10 | Ulster | New York | 36111 | 15775 | 268 |
1701553 | 1701553 | 2021-09-09 | Ulster | New York | 36111 | 15726 | 268 |
1698304 | 1698304 | 2021-09-08 | Ulster | New York | 36111 | 15675 | 268 |
1695056 | 1695056 | 2021-09-07 | Ulster | New York | 36111 | 15633 | 267 |
1691808 | 1691808 | 2021-09-06 | Ulster | New York | 36111 | 15592 | 267 |
1688558 | 1688558 | 2021-09-05 | Ulster | New York | 36111 | 15559 | 265 |
1685308 | 1685308 | 2021-09-04 | Ulster | New York | 36111 | 15503 | 265 |
1682057 | 1682057 | 2021-09-03 | Ulster | New York | 36111 | 15456 | 264 |
1678808 | 1678808 | 2021-09-02 | Ulster | New York | 36111 | 15407 | 264 |
1675560 | 1675560 | 2021-09-01 | Ulster | New York | 36111 | 15354 | 264 |
1672313 | 1672313 | 2021-08-31 | Ulster | New York | 36111 | 15311 | 263 |
1669065 | 1669065 | 2021-08-30 | Ulster | New York | 36111 | 15271 | 263 |
1665818 | 1665818 | 2021-08-29 | Ulster | New York | 36111 | 15237 | 263 |
1662570 | 1662570 | 2021-08-28 | Ulster | New York | 36111 | 15197 | 262 |
1659322 | 1659322 | 2021-08-27 | Ulster | New York | 36111 | 15133 | 262 |
1656073 | 1656073 | 2021-08-26 | Ulster | New York | 36111 | 15088 | 262 |
1652826 | 1652826 | 2021-08-25 | Ulster | New York | 36111 | 15022 | 261 |
1649578 | 1649578 | 2021-08-24 | Ulster | New York | 36111 | 14980 | 260 |
1646329 | 1646329 | 2021-08-23 | Ulster | New York | 36111 | 14948 | 260 |
1643080 | 1643080 | 2021-08-22 | Ulster | New York | 36111 | 14910 | 260 |
1639830 | 1639830 | 2021-08-21 | Ulster | New York | 36111 | 14853 | 260 |
1636580 | 1636580 | 2021-08-20 | Ulster | New York | 36111 | 14789 | 260 |
1633330 | 1633330 | 2021-08-19 | Ulster | New York | 36111 | 14749 | 259 |
1630083 | 1630083 | 2021-08-18 | Ulster | New York | 36111 | 14683 | 259 |
1626836 | 1626836 | 2021-08-17 | Ulster | New York | 36111 | 14610 | 258 |
1623589 | 1623589 | 2021-08-16 | Ulster | New York | 36111 | 14572 | 258 |
1620342 | 1620342 | 2021-08-15 | Ulster | New York | 36111 | 14552 | 258 |
1617094 | 1617094 | 2021-08-14 | Ulster | New York | 36111 | 14506 | 258 |
1613846 | 1613846 | 2021-08-13 | Ulster | New York | 36111 | 14459 | 258 |
1610597 | 1610597 | 2021-08-12 | Ulster | New York | 36111 | 14438 | 258 |
1607349 | 1607349 | 2021-08-11 | Ulster | New York | 36111 | 14397 | 258 |
1604100 | 1604100 | 2021-08-10 | Ulster | New York | 36111 | 14360 | 258 |
1600851 | 1600851 | 2021-08-09 | Ulster | New York | 36111 | 14330 | 258 |
1597603 | 1597603 | 2021-08-08 | Ulster | New York | 36111 | 14316 | 258 |
1594354 | 1594354 | 2021-08-07 | Ulster | New York | 36111 | 14293 | 258 |
1591105 | 1591105 | 2021-08-06 | Ulster | New York | 36111 | 14259 | 258 |
1587856 | 1587856 | 2021-08-05 | Ulster | New York | 36111 | 14229 | 258 |
1584606 | 1584606 | 2021-08-04 | Ulster | New York | 36111 | 14202 | 258 |
1581356 | 1581356 | 2021-08-03 | Ulster | New York | 36111 | 14186 | 258 |
1578107 | 1578107 | 2021-08-02 | Ulster | New York | 36111 | 14164 | 258 |
1574859 | 1574859 | 2021-08-01 | Ulster | New York | 36111 | 14148 | 258 |
1571611 | 1571611 | 2021-07-31 | Ulster | New York | 36111 | 14131 | 258 |
1568363 | 1568363 | 2021-07-30 | Ulster | New York | 36111 | 14111 | 258 |
1565115 | 1565115 | 2021-07-29 | Ulster | New York | 36111 | 14096 | 258 |
1561867 | 1561867 | 2021-07-28 | Ulster | New York | 36111 | 14084 | 258 |
1558619 | 1558619 | 2021-07-27 | Ulster | New York | 36111 | 14074 | 258 |
1555372 | 1555372 | 2021-07-26 | Ulster | New York | 36111 | 14060 | 258 |
1552125 | 1552125 | 2021-07-25 | Ulster | New York | 36111 | 14055 | 258 |
1548878 | 1548878 | 2021-07-24 | Ulster | New York | 36111 | 14043 | 258 |
1545631 | 1545631 | 2021-07-23 | Ulster | New York | 36111 | 14031 | 258 |
1542384 | 1542384 | 2021-07-22 | Ulster | New York | 36111 | 14020 | 258 |
1539136 | 1539136 | 2021-07-21 | Ulster | New York | 36111 | 14013 | 258 |
1535889 | 1535889 | 2021-07-20 | Ulster | New York | 36111 | 14004 | 258 |
1532641 | 1532641 | 2021-07-19 | Ulster | New York | 36111 | 14001 | 258 |
1529394 | 1529394 | 2021-07-18 | Ulster | New York | 36111 | 13999 | 258 |
1526147 | 1526147 | 2021-07-17 | Ulster | New York | 36111 | 13993 | 258 |
1522900 | 1522900 | 2021-07-16 | Ulster | New York | 36111 | 13982 | 258 |
1519652 | 1519652 | 2021-07-15 | Ulster | New York | 36111 | 13980 | 258 |
1516404 | 1516404 | 2021-07-14 | Ulster | New York | 36111 | 13975 | 258 |
1513157 | 1513157 | 2021-07-13 | Ulster | New York | 36111 | 13973 | 257 |
1509911 | 1509911 | 2021-07-12 | Ulster | New York | 36111 | 13967 | 257 |
1506664 | 1506664 | 2021-07-11 | Ulster | New York | 36111 | 13966 | 257 |
1503418 | 1503418 | 2021-07-10 | Ulster | New York | 36111 | 13958 | 257 |
1500172 | 1500172 | 2021-07-09 | Ulster | New York | 36111 | 13950 | 257 |
1496926 | 1496926 | 2021-07-08 | Ulster | New York | 36111 | 13948 | 257 |
1493679 | 1493679 | 2021-07-07 | Ulster | New York | 36111 | 13939 | 257 |
1490432 | 1490432 | 2021-07-06 | Ulster | New York | 36111 | 13937 | 257 |
1487185 | 1487185 | 2021-07-05 | Ulster | New York | 36111 | 13936 | 257 |
1483939 | 1483939 | 2021-07-04 | Ulster | New York | 36111 | 13933 | 257 |
1480693 | 1480693 | 2021-07-03 | Ulster | New York | 36111 | 13932 | 257 |
1477446 | 1477446 | 2021-07-02 | Ulster | New York | 36111 | 13932 | 257 |
1474200 | 1474200 | 2021-07-01 | Ulster | New York | 36111 | 13929 | 257 |
1470954 | 1470954 | 2021-06-30 | Ulster | New York | 36111 | 13927 | 257 |
1467709 | 1467709 | 2021-06-29 | Ulster | New York | 36111 | 13927 | 257 |
1464464 | 1464464 | 2021-06-28 | Ulster | New York | 36111 | 13926 | 257 |
1461219 | 1461219 | 2021-06-27 | Ulster | New York | 36111 | 13926 | 257 |
1457974 | 1457974 | 2021-06-26 | Ulster | New York | 36111 | 13925 | 257 |
1454729 | 1454729 | 2021-06-25 | Ulster | New York | 36111 | 13924 | 257 |
1451484 | 1451484 | 2021-06-24 | Ulster | New York | 36111 | 13921 | 257 |
1448238 | 1448238 | 2021-06-23 | Ulster | New York | 36111 | 13918 | 257 |
1444993 | 1444993 | 2021-06-22 | Ulster | New York | 36111 | 13917 | 257 |
1441748 | 1441748 | 2021-06-21 | Ulster | New York | 36111 | 13916 | 257 |
1438503 | 1438503 | 2021-06-20 | Ulster | New York | 36111 | 13916 | 257 |
1435256 | 1435256 | 2021-06-19 | Ulster | New York | 36111 | 13916 | 257 |
1432009 | 1432009 | 2021-06-18 | Ulster | New York | 36111 | 13915 | 257 |
1428763 | 1428763 | 2021-06-17 | Ulster | New York | 36111 | 13912 | 257 |
1425518 | 1425518 | 2021-06-16 | Ulster | New York | 36111 | 13911 | 257 |
1422271 | 1422271 | 2021-06-15 | Ulster | New York | 36111 | 13908 | 257 |
1419025 | 1419025 | 2021-06-14 | Ulster | New York | 36111 | 13907 | 257 |
1415780 | 1415780 | 2021-06-13 | Ulster | New York | 36111 | 13905 | 257 |
1412534 | 1412534 | 2021-06-12 | Ulster | New York | 36111 | 13903 | 257 |
1409289 | 1409289 | 2021-06-11 | Ulster | New York | 36111 | 13897 | 257 |
1406044 | 1406044 | 2021-06-10 | Ulster | New York | 36111 | 13894 | 257 |
1402798 | 1402798 | 2021-06-09 | Ulster | New York | 36111 | 13893 | 257 |
1399553 | 1399553 | 2021-06-08 | Ulster | New York | 36111 | 13891 | 257 |
1396308 | 1396308 | 2021-06-07 | Ulster | New York | 36111 | 13889 | 257 |
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);