ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Rockland" 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 |
---|---|---|---|---|---|---|---|
1717779 | 1717779 | 2021-09-14 | Rockland | New York | 36087 | 50133 | 766 |
1714531 | 1714531 | 2021-09-13 | Rockland | New York | 36087 | 50062 | 766 |
1711285 | 1711285 | 2021-09-12 | Rockland | New York | 36087 | 50015 | 766 |
1708038 | 1708038 | 2021-09-11 | Rockland | New York | 36087 | 49894 | 766 |
1704791 | 1704791 | 2021-09-10 | Rockland | New York | 36087 | 49823 | 765 |
1701541 | 1701541 | 2021-09-09 | Rockland | New York | 36087 | 49780 | 765 |
1698292 | 1698292 | 2021-09-08 | Rockland | New York | 36087 | 49735 | 765 |
1695044 | 1695044 | 2021-09-07 | Rockland | New York | 36087 | 49679 | 765 |
1691796 | 1691796 | 2021-09-06 | Rockland | New York | 36087 | 49597 | 764 |
1688546 | 1688546 | 2021-09-05 | Rockland | New York | 36087 | 49570 | 764 |
1685296 | 1685296 | 2021-09-04 | Rockland | New York | 36087 | 49503 | 764 |
1682045 | 1682045 | 2021-09-03 | Rockland | New York | 36087 | 49429 | 763 |
1678796 | 1678796 | 2021-09-02 | Rockland | New York | 36087 | 49369 | 763 |
1675548 | 1675548 | 2021-09-01 | Rockland | New York | 36087 | 49276 | 763 |
1672301 | 1672301 | 2021-08-31 | Rockland | New York | 36087 | 49219 | 763 |
1669053 | 1669053 | 2021-08-30 | Rockland | New York | 36087 | 49169 | 763 |
1665806 | 1665806 | 2021-08-29 | Rockland | New York | 36087 | 49138 | 762 |
1662558 | 1662558 | 2021-08-28 | Rockland | New York | 36087 | 49090 | 762 |
1659310 | 1659310 | 2021-08-27 | Rockland | New York | 36087 | 49020 | 762 |
1656061 | 1656061 | 2021-08-26 | Rockland | New York | 36087 | 48943 | 762 |
1652814 | 1652814 | 2021-08-25 | Rockland | New York | 36087 | 48895 | 762 |
1649566 | 1649566 | 2021-08-24 | Rockland | New York | 36087 | 48808 | 761 |
1646317 | 1646317 | 2021-08-23 | Rockland | New York | 36087 | 48767 | 761 |
1643068 | 1643068 | 2021-08-22 | Rockland | New York | 36087 | 48734 | 761 |
1639818 | 1639818 | 2021-08-21 | Rockland | New York | 36087 | 48673 | 761 |
1636568 | 1636568 | 2021-08-20 | Rockland | New York | 36087 | 48613 | 761 |
1633318 | 1633318 | 2021-08-19 | Rockland | New York | 36087 | 48569 | 761 |
1630071 | 1630071 | 2021-08-18 | Rockland | New York | 36087 | 48497 | 761 |
1626824 | 1626824 | 2021-08-17 | Rockland | New York | 36087 | 48452 | 760 |
1623577 | 1623577 | 2021-08-16 | Rockland | New York | 36087 | 48385 | 760 |
1620330 | 1620330 | 2021-08-15 | Rockland | New York | 36087 | 48355 | 760 |
1617082 | 1617082 | 2021-08-14 | Rockland | New York | 36087 | 48302 | 760 |
1613834 | 1613834 | 2021-08-13 | Rockland | New York | 36087 | 48247 | 760 |
1610585 | 1610585 | 2021-08-12 | Rockland | New York | 36087 | 48188 | 760 |
1607337 | 1607337 | 2021-08-11 | Rockland | New York | 36087 | 48101 | 760 |
1604088 | 1604088 | 2021-08-10 | Rockland | New York | 36087 | 48030 | 758 |
1600839 | 1600839 | 2021-08-09 | Rockland | New York | 36087 | 47974 | 758 |
1597591 | 1597591 | 2021-08-08 | Rockland | New York | 36087 | 47914 | 758 |
1594342 | 1594342 | 2021-08-07 | Rockland | New York | 36087 | 47869 | 758 |
1591093 | 1591093 | 2021-08-06 | Rockland | New York | 36087 | 47809 | 758 |
1587844 | 1587844 | 2021-08-05 | Rockland | New York | 36087 | 47721 | 758 |
1584594 | 1584594 | 2021-08-04 | Rockland | New York | 36087 | 47648 | 758 |
1581344 | 1581344 | 2021-08-03 | Rockland | New York | 36087 | 47596 | 758 |
1578095 | 1578095 | 2021-08-02 | Rockland | New York | 36087 | 47553 | 758 |
1574847 | 1574847 | 2021-08-01 | Rockland | New York | 36087 | 47535 | 758 |
1571599 | 1571599 | 2021-07-31 | Rockland | New York | 36087 | 47509 | 758 |
1568351 | 1568351 | 2021-07-30 | Rockland | New York | 36087 | 47465 | 758 |
1565103 | 1565103 | 2021-07-29 | Rockland | New York | 36087 | 47434 | 758 |
1561855 | 1561855 | 2021-07-28 | Rockland | New York | 36087 | 47409 | 758 |
1558607 | 1558607 | 2021-07-27 | Rockland | New York | 36087 | 47386 | 758 |
1555360 | 1555360 | 2021-07-26 | Rockland | New York | 36087 | 47345 | 758 |
1552113 | 1552113 | 2021-07-25 | Rockland | New York | 36087 | 47326 | 758 |
1548866 | 1548866 | 2021-07-24 | Rockland | New York | 36087 | 47307 | 758 |
1545619 | 1545619 | 2021-07-23 | Rockland | New York | 36087 | 47288 | 758 |
1542372 | 1542372 | 2021-07-22 | Rockland | New York | 36087 | 47269 | 758 |
1539124 | 1539124 | 2021-07-21 | Rockland | New York | 36087 | 47258 | 758 |
1535877 | 1535877 | 2021-07-20 | Rockland | New York | 36087 | 47247 | 758 |
1532629 | 1532629 | 2021-07-19 | Rockland | New York | 36087 | 47236 | 758 |
1529382 | 1529382 | 2021-07-18 | Rockland | New York | 36087 | 47227 | 758 |
1526135 | 1526135 | 2021-07-17 | Rockland | New York | 36087 | 47221 | 758 |
1522888 | 1522888 | 2021-07-16 | Rockland | New York | 36087 | 47203 | 758 |
1519640 | 1519640 | 2021-07-15 | Rockland | New York | 36087 | 47190 | 758 |
1516392 | 1516392 | 2021-07-14 | Rockland | New York | 36087 | 47179 | 758 |
1513145 | 1513145 | 2021-07-13 | Rockland | New York | 36087 | 47168 | 758 |
1509899 | 1509899 | 2021-07-12 | Rockland | New York | 36087 | 47156 | 758 |
1506652 | 1506652 | 2021-07-11 | Rockland | New York | 36087 | 47151 | 758 |
1503406 | 1503406 | 2021-07-10 | Rockland | New York | 36087 | 47143 | 758 |
1500160 | 1500160 | 2021-07-09 | Rockland | New York | 36087 | 47131 | 758 |
1496914 | 1496914 | 2021-07-08 | Rockland | New York | 36087 | 47114 | 758 |
1493667 | 1493667 | 2021-07-07 | Rockland | New York | 36087 | 47105 | 758 |
1490420 | 1490420 | 2021-07-06 | Rockland | New York | 36087 | 47093 | 757 |
1487173 | 1487173 | 2021-07-05 | Rockland | New York | 36087 | 47086 | 757 |
1483927 | 1483927 | 2021-07-04 | Rockland | New York | 36087 | 47081 | 757 |
1480681 | 1480681 | 2021-07-03 | Rockland | New York | 36087 | 47076 | 757 |
1477434 | 1477434 | 2021-07-02 | Rockland | New York | 36087 | 47068 | 757 |
1474188 | 1474188 | 2021-07-01 | Rockland | New York | 36087 | 47027 | 757 |
1470942 | 1470942 | 2021-06-30 | Rockland | New York | 36087 | 47022 | 756 |
1467697 | 1467697 | 2021-06-29 | Rockland | New York | 36087 | 47017 | 756 |
1464452 | 1464452 | 2021-06-28 | Rockland | New York | 36087 | 47014 | 756 |
1461207 | 1461207 | 2021-06-27 | Rockland | New York | 36087 | 47011 | 756 |
1457962 | 1457962 | 2021-06-26 | Rockland | New York | 36087 | 47007 | 756 |
1454717 | 1454717 | 2021-06-25 | Rockland | New York | 36087 | 46995 | 755 |
1451472 | 1451472 | 2021-06-24 | Rockland | New York | 36087 | 46987 | 755 |
1448226 | 1448226 | 2021-06-23 | Rockland | New York | 36087 | 46986 | 755 |
1444981 | 1444981 | 2021-06-22 | Rockland | New York | 36087 | 46981 | 754 |
1441736 | 1441736 | 2021-06-21 | Rockland | New York | 36087 | 46969 | 754 |
1438491 | 1438491 | 2021-06-20 | Rockland | New York | 36087 | 46969 | 754 |
1435244 | 1435244 | 2021-06-19 | Rockland | New York | 36087 | 46965 | 754 |
1431997 | 1431997 | 2021-06-18 | Rockland | New York | 36087 | 46958 | 754 |
1428751 | 1428751 | 2021-06-17 | Rockland | New York | 36087 | 46952 | 754 |
1425506 | 1425506 | 2021-06-16 | Rockland | New York | 36087 | 46948 | 754 |
1422259 | 1422259 | 2021-06-15 | Rockland | New York | 36087 | 46944 | 754 |
1419013 | 1419013 | 2021-06-14 | Rockland | New York | 36087 | 46936 | 754 |
1415768 | 1415768 | 2021-06-13 | Rockland | New York | 36087 | 46935 | 754 |
1412522 | 1412522 | 2021-06-12 | Rockland | New York | 36087 | 46930 | 754 |
1409277 | 1409277 | 2021-06-11 | Rockland | New York | 36087 | 46924 | 754 |
1406032 | 1406032 | 2021-06-10 | Rockland | New York | 36087 | 46920 | 754 |
1402786 | 1402786 | 2021-06-09 | Rockland | New York | 36087 | 46915 | 754 |
1399541 | 1399541 | 2021-06-08 | Rockland | New York | 36087 | 46909 | 754 |
1396296 | 1396296 | 2021-06-07 | Rockland | New York | 36087 | 46905 | 753 |
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);