ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Suffolk" 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 |
---|---|---|---|---|---|---|---|
1841252 | 1841252 | 2021-10-22 | Suffolk | New York | 36103 | 239877 | 3609 |
1838003 | 1838003 | 2021-10-21 | Suffolk | New York | 36103 | 239557 | 3605 |
1834754 | 1834754 | 2021-10-20 | Suffolk | New York | 36103 | 239179 | 3601 |
1831505 | 1831505 | 2021-10-19 | Suffolk | New York | 36103 | 238801 | 3596 |
1828256 | 1828256 | 2021-10-18 | Suffolk | New York | 36103 | 238494 | 3593 |
1825007 | 1825007 | 2021-10-17 | Suffolk | New York | 36103 | 238318 | 3590 |
1821758 | 1821758 | 2021-10-16 | Suffolk | New York | 36103 | 237959 | 3585 |
1818509 | 1818509 | 2021-10-15 | Suffolk | New York | 36103 | 237506 | 3584 |
1815260 | 1815260 | 2021-10-14 | Suffolk | New York | 36103 | 236972 | 3580 |
1812012 | 1812012 | 2021-10-13 | Suffolk | New York | 36103 | 236630 | 3574 |
1808763 | 1808763 | 2021-10-12 | Suffolk | New York | 36103 | 236248 | 3572 |
1805512 | 1805512 | 2021-10-11 | Suffolk | New York | 36103 | 235833 | 3570 |
1802263 | 1802263 | 2021-10-10 | Suffolk | New York | 36103 | 235484 | 3567 |
1799014 | 1799014 | 2021-10-09 | Suffolk | New York | 36103 | 235189 | 3566 |
1795765 | 1795765 | 2021-10-08 | Suffolk | New York | 36103 | 234756 | 3562 |
1792516 | 1792516 | 2021-10-07 | Suffolk | New York | 36103 | 234329 | 3555 |
1789267 | 1789267 | 2021-10-06 | Suffolk | New York | 36103 | 233876 | 3553 |
1786019 | 1786019 | 2021-10-05 | Suffolk | New York | 36103 | 233362 | 3549 |
1782770 | 1782770 | 2021-10-04 | Suffolk | New York | 36103 | 233008 | 3545 |
1779521 | 1779521 | 2021-10-03 | Suffolk | New York | 36103 | 232788 | 3543 |
1776271 | 1776271 | 2021-10-02 | Suffolk | New York | 36103 | 232356 | 3541 |
1773021 | 1773021 | 2021-10-01 | Suffolk | New York | 36103 | 231905 | 3539 |
1769771 | 1769771 | 2021-09-30 | Suffolk | New York | 36103 | 231463 | 3536 |
1766522 | 1766522 | 2021-09-29 | Suffolk | New York | 36103 | 230952 | 3535 |
1763273 | 1763273 | 2021-09-28 | Suffolk | New York | 36103 | 230459 | 3530 |
1760024 | 1760024 | 2021-09-27 | Suffolk | New York | 36103 | 229990 | 3529 |
1756776 | 1756776 | 2021-09-26 | Suffolk | New York | 36103 | 229695 | 3526 |
1753528 | 1753528 | 2021-09-25 | Suffolk | New York | 36103 | 229286 | 3524 |
1750280 | 1750280 | 2021-09-24 | Suffolk | New York | 36103 | 228719 | 3523 |
1747030 | 1747030 | 2021-09-23 | Suffolk | New York | 36103 | 228170 | 3519 |
1743781 | 1743781 | 2021-09-22 | Suffolk | New York | 36103 | 227635 | 3517 |
1740532 | 1740532 | 2021-09-21 | Suffolk | New York | 36103 | 227181 | 3515 |
1737283 | 1737283 | 2021-09-20 | Suffolk | New York | 36103 | 226574 | 3511 |
1734033 | 1734033 | 2021-09-19 | Suffolk | New York | 36103 | 226321 | 3507 |
1730783 | 1730783 | 2021-09-18 | Suffolk | New York | 36103 | 225877 | 3504 |
1727533 | 1727533 | 2021-09-17 | Suffolk | New York | 36103 | 225365 | 3502 |
1724284 | 1724284 | 2021-09-16 | Suffolk | New York | 36103 | 224663 | 3500 |
1721035 | 1721035 | 2021-09-15 | Suffolk | New York | 36103 | 224068 | 3498 |
1717787 | 1717787 | 2021-09-14 | Suffolk | New York | 36103 | 223543 | 3494 |
1714539 | 1714539 | 2021-09-13 | Suffolk | New York | 36103 | 222987 | 3492 |
1711293 | 1711293 | 2021-09-12 | Suffolk | New York | 36103 | 222776 | 3490 |
1708046 | 1708046 | 2021-09-11 | Suffolk | New York | 36103 | 222256 | 3487 |
1704799 | 1704799 | 2021-09-10 | Suffolk | New York | 36103 | 221796 | 3483 |
1701549 | 1701549 | 2021-09-09 | Suffolk | New York | 36103 | 221068 | 3482 |
1698300 | 1698300 | 2021-09-08 | Suffolk | New York | 36103 | 220533 | 3481 |
1695052 | 1695052 | 2021-09-07 | Suffolk | New York | 36103 | 220096 | 3479 |
1691804 | 1691804 | 2021-09-06 | Suffolk | New York | 36103 | 219702 | 3476 |
1688554 | 1688554 | 2021-09-05 | Suffolk | New York | 36103 | 219387 | 3470 |
1685304 | 1685304 | 2021-09-04 | Suffolk | New York | 36103 | 218840 | 3467 |
1682053 | 1682053 | 2021-09-03 | Suffolk | New York | 36103 | 218398 | 3465 |
1678804 | 1678804 | 2021-09-02 | Suffolk | New York | 36103 | 217676 | 3463 |
1675556 | 1675556 | 2021-09-01 | Suffolk | New York | 36103 | 217155 | 3461 |
1672309 | 1672309 | 2021-08-31 | Suffolk | New York | 36103 | 216698 | 3457 |
1669061 | 1669061 | 2021-08-30 | Suffolk | New York | 36103 | 216316 | 3455 |
1665814 | 1665814 | 2021-08-29 | Suffolk | New York | 36103 | 215876 | 3455 |
1662566 | 1662566 | 2021-08-28 | Suffolk | New York | 36103 | 215409 | 3451 |
1659318 | 1659318 | 2021-08-27 | Suffolk | New York | 36103 | 214852 | 3450 |
1656069 | 1656069 | 2021-08-26 | Suffolk | New York | 36103 | 214217 | 3448 |
1652822 | 1652822 | 2021-08-25 | Suffolk | New York | 36103 | 213541 | 3445 |
1649574 | 1649574 | 2021-08-24 | Suffolk | New York | 36103 | 213121 | 3443 |
1646325 | 1646325 | 2021-08-23 | Suffolk | New York | 36103 | 212809 | 3443 |
1643076 | 1643076 | 2021-08-22 | Suffolk | New York | 36103 | 212400 | 3440 |
1639826 | 1639826 | 2021-08-21 | Suffolk | New York | 36103 | 211975 | 3439 |
1636576 | 1636576 | 2021-08-20 | Suffolk | New York | 36103 | 211503 | 3438 |
1633326 | 1633326 | 2021-08-19 | Suffolk | New York | 36103 | 210935 | 3437 |
1630079 | 1630079 | 2021-08-18 | Suffolk | New York | 36103 | 210420 | 3434 |
1626832 | 1626832 | 2021-08-17 | Suffolk | New York | 36103 | 209892 | 3430 |
1623585 | 1623585 | 2021-08-16 | Suffolk | New York | 36103 | 209612 | 3426 |
1620338 | 1620338 | 2021-08-15 | Suffolk | New York | 36103 | 209136 | 3426 |
1617090 | 1617090 | 2021-08-14 | Suffolk | New York | 36103 | 208796 | 3426 |
1613842 | 1613842 | 2021-08-13 | Suffolk | New York | 36103 | 208440 | 3425 |
1610593 | 1610593 | 2021-08-12 | Suffolk | New York | 36103 | 208020 | 3423 |
1607345 | 1607345 | 2021-08-11 | Suffolk | New York | 36103 | 207685 | 3419 |
1604096 | 1604096 | 2021-08-10 | Suffolk | New York | 36103 | 207305 | 3419 |
1600847 | 1600847 | 2021-08-09 | Suffolk | New York | 36103 | 207046 | 3418 |
1597599 | 1597599 | 2021-08-08 | Suffolk | New York | 36103 | 206706 | 3417 |
1594350 | 1594350 | 2021-08-07 | Suffolk | New York | 36103 | 206402 | 3416 |
1591101 | 1591101 | 2021-08-06 | Suffolk | New York | 36103 | 205995 | 3415 |
1587852 | 1587852 | 2021-08-05 | Suffolk | New York | 36103 | 205681 | 3415 |
1584602 | 1584602 | 2021-08-04 | Suffolk | New York | 36103 | 205380 | 3414 |
1581352 | 1581352 | 2021-08-03 | Suffolk | New York | 36103 | 205096 | 3414 |
1578103 | 1578103 | 2021-08-02 | Suffolk | New York | 36103 | 204787 | 3414 |
1574855 | 1574855 | 2021-08-01 | Suffolk | New York | 36103 | 204564 | 3414 |
1571607 | 1571607 | 2021-07-31 | Suffolk | New York | 36103 | 204334 | 3414 |
1568359 | 1568359 | 2021-07-30 | Suffolk | New York | 36103 | 204083 | 3412 |
1565111 | 1565111 | 2021-07-29 | Suffolk | New York | 36103 | 203817 | 3412 |
1561863 | 1561863 | 2021-07-28 | Suffolk | New York | 36103 | 203634 | 3412 |
1558615 | 1558615 | 2021-07-27 | Suffolk | New York | 36103 | 203447 | 3410 |
1555368 | 1555368 | 2021-07-26 | Suffolk | New York | 36103 | 203317 | 3409 |
1552121 | 1552121 | 2021-07-25 | Suffolk | New York | 36103 | 203186 | 3409 |
1548874 | 1548874 | 2021-07-24 | Suffolk | New York | 36103 | 203027 | 3409 |
1545627 | 1545627 | 2021-07-23 | Suffolk | New York | 36103 | 202863 | 3409 |
1542380 | 1542380 | 2021-07-22 | Suffolk | New York | 36103 | 202711 | 3409 |
1539132 | 1539132 | 2021-07-21 | Suffolk | New York | 36103 | 202585 | 3409 |
1535885 | 1535885 | 2021-07-20 | Suffolk | New York | 36103 | 202460 | 3408 |
1532637 | 1532637 | 2021-07-19 | Suffolk | New York | 36103 | 202363 | 3408 |
1529390 | 1529390 | 2021-07-18 | Suffolk | New York | 36103 | 202275 | 3407 |
1526143 | 1526143 | 2021-07-17 | Suffolk | New York | 36103 | 202195 | 3407 |
1522896 | 1522896 | 2021-07-16 | Suffolk | New York | 36103 | 202120 | 3407 |
1519648 | 1519648 | 2021-07-15 | Suffolk | New York | 36103 | 202047 | 3407 |
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);