ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36067 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 |
---|---|---|---|---|---|---|---|
1717771 | 1717771 | 2021-09-14 | Onondaga | New York | 36067 | 44486 | 698 |
1714523 | 1714523 | 2021-09-13 | Onondaga | New York | 36067 | 44435 | 697 |
1711277 | 1711277 | 2021-09-12 | Onondaga | New York | 36067 | 44329 | 695 |
1708030 | 1708030 | 2021-09-11 | Onondaga | New York | 36067 | 44085 | 694 |
1704783 | 1704783 | 2021-09-10 | Onondaga | New York | 36067 | 43906 | 692 |
1701533 | 1701533 | 2021-09-09 | Onondaga | New York | 36067 | 43698 | 690 |
1698284 | 1698284 | 2021-09-08 | Onondaga | New York | 36067 | 43526 | 690 |
1695036 | 1695036 | 2021-09-07 | Onondaga | New York | 36067 | 43420 | 690 |
1691788 | 1691788 | 2021-09-06 | Onondaga | New York | 36067 | 43325 | 688 |
1688538 | 1688538 | 2021-09-05 | Onondaga | New York | 36067 | 43166 | 688 |
1685288 | 1685288 | 2021-09-04 | Onondaga | New York | 36067 | 43076 | 688 |
1682037 | 1682037 | 2021-09-03 | Onondaga | New York | 36067 | 42914 | 688 |
1678788 | 1678788 | 2021-09-02 | Onondaga | New York | 36067 | 42691 | 687 |
1675540 | 1675540 | 2021-09-01 | Onondaga | New York | 36067 | 42553 | 686 |
1672293 | 1672293 | 2021-08-31 | Onondaga | New York | 36067 | 42456 | 685 |
1669045 | 1669045 | 2021-08-30 | Onondaga | New York | 36067 | 42362 | 685 |
1665798 | 1665798 | 2021-08-29 | Onondaga | New York | 36067 | 42182 | 685 |
1662550 | 1662550 | 2021-08-28 | Onondaga | New York | 36067 | 42103 | 685 |
1659302 | 1659302 | 2021-08-27 | Onondaga | New York | 36067 | 41986 | 684 |
1656053 | 1656053 | 2021-08-26 | Onondaga | New York | 36067 | 41688 | 683 |
1652806 | 1652806 | 2021-08-25 | Onondaga | New York | 36067 | 41600 | 683 |
1649558 | 1649558 | 2021-08-24 | Onondaga | New York | 36067 | 41532 | 683 |
1646309 | 1646309 | 2021-08-23 | Onondaga | New York | 36067 | 41493 | 682 |
1643060 | 1643060 | 2021-08-22 | Onondaga | New York | 36067 | 41364 | 682 |
1639810 | 1639810 | 2021-08-21 | Onondaga | New York | 36067 | 41256 | 681 |
1636560 | 1636560 | 2021-08-20 | Onondaga | New York | 36067 | 41119 | 681 |
1633310 | 1633310 | 2021-08-19 | Onondaga | New York | 36067 | 41016 | 681 |
1630063 | 1630063 | 2021-08-18 | Onondaga | New York | 36067 | 40912 | 681 |
1626816 | 1626816 | 2021-08-17 | Onondaga | New York | 36067 | 40807 | 681 |
1623569 | 1623569 | 2021-08-16 | Onondaga | New York | 36067 | 40711 | 681 |
1620322 | 1620322 | 2021-08-15 | Onondaga | New York | 36067 | 40621 | 681 |
1617074 | 1617074 | 2021-08-14 | Onondaga | New York | 36067 | 40520 | 681 |
1613826 | 1613826 | 2021-08-13 | Onondaga | New York | 36067 | 40404 | 681 |
1610577 | 1610577 | 2021-08-12 | Onondaga | New York | 36067 | 40301 | 681 |
1607329 | 1607329 | 2021-08-11 | Onondaga | New York | 36067 | 40200 | 681 |
1604080 | 1604080 | 2021-08-10 | Onondaga | New York | 36067 | 40136 | 680 |
1600831 | 1600831 | 2021-08-09 | Onondaga | New York | 36067 | 40076 | 680 |
1597583 | 1597583 | 2021-08-08 | Onondaga | New York | 36067 | 40030 | 680 |
1594334 | 1594334 | 2021-08-07 | Onondaga | New York | 36067 | 39964 | 680 |
1591085 | 1591085 | 2021-08-06 | Onondaga | New York | 36067 | 39850 | 680 |
1587836 | 1587836 | 2021-08-05 | Onondaga | New York | 36067 | 39797 | 680 |
1584586 | 1584586 | 2021-08-04 | Onondaga | New York | 36067 | 39738 | 680 |
1581336 | 1581336 | 2021-08-03 | Onondaga | New York | 36067 | 39672 | 680 |
1578087 | 1578087 | 2021-08-02 | Onondaga | New York | 36067 | 39603 | 680 |
1574839 | 1574839 | 2021-08-01 | Onondaga | New York | 36067 | 39580 | 680 |
1571591 | 1571591 | 2021-07-31 | Onondaga | New York | 36067 | 39537 | 680 |
1568343 | 1568343 | 2021-07-30 | Onondaga | New York | 36067 | 39473 | 680 |
1565095 | 1565095 | 2021-07-29 | Onondaga | New York | 36067 | 39420 | 680 |
1561847 | 1561847 | 2021-07-28 | Onondaga | New York | 36067 | 39383 | 680 |
1558599 | 1558599 | 2021-07-27 | Onondaga | New York | 36067 | 39348 | 680 |
1555352 | 1555352 | 2021-07-26 | Onondaga | New York | 36067 | 39320 | 680 |
1552105 | 1552105 | 2021-07-25 | Onondaga | New York | 36067 | 39310 | 680 |
1548858 | 1548858 | 2021-07-24 | Onondaga | New York | 36067 | 39280 | 680 |
1545611 | 1545611 | 2021-07-23 | Onondaga | New York | 36067 | 39271 | 680 |
1542364 | 1542364 | 2021-07-22 | Onondaga | New York | 36067 | 39253 | 680 |
1539116 | 1539116 | 2021-07-21 | Onondaga | New York | 36067 | 39242 | 680 |
1535869 | 1535869 | 2021-07-20 | Onondaga | New York | 36067 | 39228 | 679 |
1532621 | 1532621 | 2021-07-19 | Onondaga | New York | 36067 | 39212 | 679 |
1529374 | 1529374 | 2021-07-18 | Onondaga | New York | 36067 | 39209 | 679 |
1526127 | 1526127 | 2021-07-17 | Onondaga | New York | 36067 | 39182 | 679 |
1522880 | 1522880 | 2021-07-16 | Onondaga | New York | 36067 | 39180 | 679 |
1519632 | 1519632 | 2021-07-15 | Onondaga | New York | 36067 | 39173 | 679 |
1516384 | 1516384 | 2021-07-14 | Onondaga | New York | 36067 | 39166 | 679 |
1513137 | 1513137 | 2021-07-13 | Onondaga | New York | 36067 | 39159 | 679 |
1509891 | 1509891 | 2021-07-12 | Onondaga | New York | 36067 | 39148 | 679 |
1506644 | 1506644 | 2021-07-11 | Onondaga | New York | 36067 | 39139 | 679 |
1503398 | 1503398 | 2021-07-10 | Onondaga | New York | 36067 | 39130 | 679 |
1500152 | 1500152 | 2021-07-09 | Onondaga | New York | 36067 | 39126 | 679 |
1496906 | 1496906 | 2021-07-08 | Onondaga | New York | 36067 | 39107 | 679 |
1493659 | 1493659 | 2021-07-07 | Onondaga | New York | 36067 | 39101 | 679 |
1490412 | 1490412 | 2021-07-06 | Onondaga | New York | 36067 | 39094 | 678 |
1487165 | 1487165 | 2021-07-05 | Onondaga | New York | 36067 | 39089 | 678 |
1483919 | 1483919 | 2021-07-04 | Onondaga | New York | 36067 | 39084 | 678 |
1480673 | 1480673 | 2021-07-03 | Onondaga | New York | 36067 | 39074 | 678 |
1477426 | 1477426 | 2021-07-02 | Onondaga | New York | 36067 | 39066 | 678 |
1474180 | 1474180 | 2021-07-01 | Onondaga | New York | 36067 | 39044 | 678 |
1470934 | 1470934 | 2021-06-30 | Onondaga | New York | 36067 | 39035 | 678 |
1467689 | 1467689 | 2021-06-29 | Onondaga | New York | 36067 | 39030 | 678 |
1464444 | 1464444 | 2021-06-28 | Onondaga | New York | 36067 | 39024 | 678 |
1461199 | 1461199 | 2021-06-27 | Onondaga | New York | 36067 | 39020 | 678 |
1457954 | 1457954 | 2021-06-26 | Onondaga | New York | 36067 | 39007 | 678 |
1454709 | 1454709 | 2021-06-25 | Onondaga | New York | 36067 | 39007 | 678 |
1451464 | 1451464 | 2021-06-24 | Onondaga | New York | 36067 | 39004 | 678 |
1448218 | 1448218 | 2021-06-23 | Onondaga | New York | 36067 | 38998 | 678 |
1444973 | 1444973 | 2021-06-22 | Onondaga | New York | 36067 | 38990 | 678 |
1441728 | 1441728 | 2021-06-21 | Onondaga | New York | 36067 | 38980 | 678 |
1438483 | 1438483 | 2021-06-20 | Onondaga | New York | 36067 | 38976 | 678 |
1435236 | 1435236 | 2021-06-19 | Onondaga | New York | 36067 | 38970 | 678 |
1431989 | 1431989 | 2021-06-18 | Onondaga | New York | 36067 | 38960 | 677 |
1428743 | 1428743 | 2021-06-17 | Onondaga | New York | 36067 | 38954 | 677 |
1425498 | 1425498 | 2021-06-16 | Onondaga | New York | 36067 | 38941 | 677 |
1422251 | 1422251 | 2021-06-15 | Onondaga | New York | 36067 | 38931 | 677 |
1419005 | 1419005 | 2021-06-14 | Onondaga | New York | 36067 | 38928 | 677 |
1415760 | 1415760 | 2021-06-13 | Onondaga | New York | 36067 | 38913 | 677 |
1412514 | 1412514 | 2021-06-12 | Onondaga | New York | 36067 | 38903 | 677 |
1409269 | 1409269 | 2021-06-11 | Onondaga | New York | 36067 | 38888 | 677 |
1406024 | 1406024 | 2021-06-10 | Onondaga | New York | 36067 | 38875 | 677 |
1402778 | 1402778 | 2021-06-09 | Onondaga | New York | 36067 | 38859 | 677 |
1399533 | 1399533 | 2021-06-08 | Onondaga | New York | 36067 | 38849 | 676 |
1396288 | 1396288 | 2021-06-07 | Onondaga | New York | 36067 | 38839 | 676 |
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);