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 |
---|---|---|---|---|---|---|---|
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 |
1516400 | 1516400 | 2021-07-14 | Suffolk | New York | 36103 | 201964 | 3407 |
1513153 | 1513153 | 2021-07-13 | Suffolk | New York | 36103 | 201904 | 3407 |
1509907 | 1509907 | 2021-07-12 | Suffolk | New York | 36103 | 201850 | 3407 |
1506660 | 1506660 | 2021-07-11 | Suffolk | New York | 36103 | 201809 | 3407 |
1503414 | 1503414 | 2021-07-10 | Suffolk | New York | 36103 | 201770 | 3407 |
1500168 | 1500168 | 2021-07-09 | Suffolk | New York | 36103 | 201718 | 3407 |
1496922 | 1496922 | 2021-07-08 | Suffolk | New York | 36103 | 201663 | 3407 |
1493675 | 1493675 | 2021-07-07 | Suffolk | New York | 36103 | 201633 | 3407 |
1490428 | 1490428 | 2021-07-06 | Suffolk | New York | 36103 | 201602 | 3407 |
1487181 | 1487181 | 2021-07-05 | Suffolk | New York | 36103 | 201580 | 3407 |
1483935 | 1483935 | 2021-07-04 | Suffolk | New York | 36103 | 201555 | 3406 |
1480689 | 1480689 | 2021-07-03 | Suffolk | New York | 36103 | 201530 | 3404 |
1477442 | 1477442 | 2021-07-02 | Suffolk | New York | 36103 | 201489 | 3404 |
1474196 | 1474196 | 2021-07-01 | Suffolk | New York | 36103 | 201456 | 3404 |
1470950 | 1470950 | 2021-06-30 | Suffolk | New York | 36103 | 201431 | 3403 |
1467705 | 1467705 | 2021-06-29 | Suffolk | New York | 36103 | 201418 | 3403 |
1464460 | 1464460 | 2021-06-28 | Suffolk | New York | 36103 | 201398 | 3402 |
1461215 | 1461215 | 2021-06-27 | Suffolk | New York | 36103 | 201368 | 3402 |
1457970 | 1457970 | 2021-06-26 | Suffolk | New York | 36103 | 201342 | 3401 |
1454725 | 1454725 | 2021-06-25 | Suffolk | New York | 36103 | 201310 | 3401 |
1451480 | 1451480 | 2021-06-24 | Suffolk | New York | 36103 | 201292 | 3401 |
1448234 | 1448234 | 2021-06-23 | Suffolk | New York | 36103 | 201261 | 3401 |
1444989 | 1444989 | 2021-06-22 | Suffolk | New York | 36103 | 201237 | 3401 |
1441744 | 1441744 | 2021-06-21 | Suffolk | New York | 36103 | 201219 | 3401 |
1438499 | 1438499 | 2021-06-20 | Suffolk | New York | 36103 | 201193 | 3400 |
1435252 | 1435252 | 2021-06-19 | Suffolk | New York | 36103 | 201168 | 3400 |
1432005 | 1432005 | 2021-06-18 | Suffolk | New York | 36103 | 201139 | 3400 |
1428759 | 1428759 | 2021-06-17 | Suffolk | New York | 36103 | 201112 | 3400 |
1425514 | 1425514 | 2021-06-16 | Suffolk | New York | 36103 | 201070 | 3400 |
1422267 | 1422267 | 2021-06-15 | Suffolk | New York | 36103 | 201036 | 3400 |
1419021 | 1419021 | 2021-06-14 | Suffolk | New York | 36103 | 201008 | 3400 |
1415776 | 1415776 | 2021-06-13 | Suffolk | New York | 36103 | 200989 | 3400 |
1412530 | 1412530 | 2021-06-12 | Suffolk | New York | 36103 | 200959 | 3399 |
1409285 | 1409285 | 2021-06-11 | Suffolk | New York | 36103 | 200895 | 3399 |
1406040 | 1406040 | 2021-06-10 | Suffolk | New York | 36103 | 200858 | 3398 |
1402794 | 1402794 | 2021-06-09 | Suffolk | New York | 36103 | 200824 | 3398 |
1399549 | 1399549 | 2021-06-08 | Suffolk | New York | 36103 | 200798 | 3398 |
1396304 | 1396304 | 2021-06-07 | Suffolk | New York | 36103 | 200766 | 3397 |
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);