ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Greene" 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 |
---|---|---|---|---|---|---|---|
1717758 | 1717758 | 2021-09-14 | Greene | New York | 36039 | 3839 | 82 |
1714510 | 1714510 | 2021-09-13 | Greene | New York | 36039 | 3833 | 82 |
1711264 | 1711264 | 2021-09-12 | Greene | New York | 36039 | 3826 | 82 |
1708017 | 1708017 | 2021-09-11 | Greene | New York | 36039 | 3816 | 82 |
1704770 | 1704770 | 2021-09-10 | Greene | New York | 36039 | 3802 | 82 |
1701520 | 1701520 | 2021-09-09 | Greene | New York | 36039 | 3791 | 82 |
1698271 | 1698271 | 2021-09-08 | Greene | New York | 36039 | 3771 | 82 |
1695023 | 1695023 | 2021-09-07 | Greene | New York | 36039 | 3761 | 82 |
1691775 | 1691775 | 2021-09-06 | Greene | New York | 36039 | 3753 | 82 |
1688525 | 1688525 | 2021-09-05 | Greene | New York | 36039 | 3741 | 82 |
1685275 | 1685275 | 2021-09-04 | Greene | New York | 36039 | 3732 | 82 |
1682024 | 1682024 | 2021-09-03 | Greene | New York | 36039 | 3721 | 82 |
1678775 | 1678775 | 2021-09-02 | Greene | New York | 36039 | 3714 | 82 |
1675527 | 1675527 | 2021-09-01 | Greene | New York | 36039 | 3695 | 82 |
1672280 | 1672280 | 2021-08-31 | Greene | New York | 36039 | 3688 | 82 |
1669032 | 1669032 | 2021-08-30 | Greene | New York | 36039 | 3676 | 82 |
1665785 | 1665785 | 2021-08-29 | Greene | New York | 36039 | 3670 | 82 |
1662537 | 1662537 | 2021-08-28 | Greene | New York | 36039 | 3656 | 82 |
1659289 | 1659289 | 2021-08-27 | Greene | New York | 36039 | 3645 | 82 |
1656040 | 1656040 | 2021-08-26 | Greene | New York | 36039 | 3627 | 82 |
1652793 | 1652793 | 2021-08-25 | Greene | New York | 36039 | 3618 | 82 |
1649545 | 1649545 | 2021-08-24 | Greene | New York | 36039 | 3609 | 82 |
1646296 | 1646296 | 2021-08-23 | Greene | New York | 36039 | 3601 | 81 |
1643047 | 1643047 | 2021-08-22 | Greene | New York | 36039 | 3598 | 81 |
1639797 | 1639797 | 2021-08-21 | Greene | New York | 36039 | 3588 | 81 |
1636547 | 1636547 | 2021-08-20 | Greene | New York | 36039 | 3576 | 80 |
1633297 | 1633297 | 2021-08-19 | Greene | New York | 36039 | 3568 | 80 |
1630050 | 1630050 | 2021-08-18 | Greene | New York | 36039 | 3564 | 80 |
1626803 | 1626803 | 2021-08-17 | Greene | New York | 36039 | 3561 | 80 |
1623556 | 1623556 | 2021-08-16 | Greene | New York | 36039 | 3553 | 80 |
1620309 | 1620309 | 2021-08-15 | Greene | New York | 36039 | 3547 | 80 |
1617061 | 1617061 | 2021-08-14 | Greene | New York | 36039 | 3543 | 80 |
1613813 | 1613813 | 2021-08-13 | Greene | New York | 36039 | 3539 | 80 |
1610564 | 1610564 | 2021-08-12 | Greene | New York | 36039 | 3528 | 80 |
1607316 | 1607316 | 2021-08-11 | Greene | New York | 36039 | 3521 | 80 |
1604067 | 1604067 | 2021-08-10 | Greene | New York | 36039 | 3511 | 80 |
1600818 | 1600818 | 2021-08-09 | Greene | New York | 36039 | 3508 | 80 |
1597570 | 1597570 | 2021-08-08 | Greene | New York | 36039 | 3501 | 79 |
1594321 | 1594321 | 2021-08-07 | Greene | New York | 36039 | 3500 | 79 |
1591072 | 1591072 | 2021-08-06 | Greene | New York | 36039 | 3492 | 79 |
1587823 | 1587823 | 2021-08-05 | Greene | New York | 36039 | 3483 | 79 |
1584573 | 1584573 | 2021-08-04 | Greene | New York | 36039 | 3481 | 79 |
1581323 | 1581323 | 2021-08-03 | Greene | New York | 36039 | 3475 | 79 |
1578074 | 1578074 | 2021-08-02 | Greene | New York | 36039 | 3472 | 79 |
1574826 | 1574826 | 2021-08-01 | Greene | New York | 36039 | 3472 | 79 |
1571578 | 1571578 | 2021-07-31 | Greene | New York | 36039 | 3470 | 79 |
1568330 | 1568330 | 2021-07-30 | Greene | New York | 36039 | 3468 | 79 |
1565082 | 1565082 | 2021-07-29 | Greene | New York | 36039 | 3467 | 79 |
1561834 | 1561834 | 2021-07-28 | Greene | New York | 36039 | 3466 | 79 |
1558586 | 1558586 | 2021-07-27 | Greene | New York | 36039 | 3461 | 79 |
1555339 | 1555339 | 2021-07-26 | Greene | New York | 36039 | 3456 | 79 |
1552092 | 1552092 | 2021-07-25 | Greene | New York | 36039 | 3453 | 79 |
1548845 | 1548845 | 2021-07-24 | Greene | New York | 36039 | 3452 | 79 |
1545598 | 1545598 | 2021-07-23 | Greene | New York | 36039 | 3448 | 79 |
1542351 | 1542351 | 2021-07-22 | Greene | New York | 36039 | 3435 | 79 |
1539103 | 1539103 | 2021-07-21 | Greene | New York | 36039 | 3434 | 79 |
1535856 | 1535856 | 2021-07-20 | Greene | New York | 36039 | 3429 | 79 |
1532608 | 1532608 | 2021-07-19 | Greene | New York | 36039 | 3428 | 79 |
1529361 | 1529361 | 2021-07-18 | Greene | New York | 36039 | 3427 | 79 |
1526114 | 1526114 | 2021-07-17 | Greene | New York | 36039 | 3425 | 79 |
1522867 | 1522867 | 2021-07-16 | Greene | New York | 36039 | 3423 | 79 |
1519619 | 1519619 | 2021-07-15 | Greene | New York | 36039 | 3422 | 79 |
1516371 | 1516371 | 2021-07-14 | Greene | New York | 36039 | 3417 | 79 |
1513124 | 1513124 | 2021-07-13 | Greene | New York | 36039 | 3417 | 79 |
1509878 | 1509878 | 2021-07-12 | Greene | New York | 36039 | 3414 | 79 |
1506631 | 1506631 | 2021-07-11 | Greene | New York | 36039 | 3412 | 79 |
1503385 | 1503385 | 2021-07-10 | Greene | New York | 36039 | 3412 | 79 |
1500139 | 1500139 | 2021-07-09 | Greene | New York | 36039 | 3410 | 79 |
1496893 | 1496893 | 2021-07-08 | Greene | New York | 36039 | 3408 | 79 |
1493646 | 1493646 | 2021-07-07 | Greene | New York | 36039 | 3408 | 79 |
1490399 | 1490399 | 2021-07-06 | Greene | New York | 36039 | 3406 | 79 |
1487152 | 1487152 | 2021-07-05 | Greene | New York | 36039 | 3406 | 79 |
1483906 | 1483906 | 2021-07-04 | Greene | New York | 36039 | 3406 | 79 |
1480660 | 1480660 | 2021-07-03 | Greene | New York | 36039 | 3406 | 79 |
1477413 | 1477413 | 2021-07-02 | Greene | New York | 36039 | 3406 | 79 |
1474167 | 1474167 | 2021-07-01 | Greene | New York | 36039 | 3406 | 79 |
1470921 | 1470921 | 2021-06-30 | Greene | New York | 36039 | 3406 | 79 |
1467676 | 1467676 | 2021-06-29 | Greene | New York | 36039 | 3406 | 79 |
1464431 | 1464431 | 2021-06-28 | Greene | New York | 36039 | 3406 | 79 |
1461186 | 1461186 | 2021-06-27 | Greene | New York | 36039 | 3406 | 79 |
1457941 | 1457941 | 2021-06-26 | Greene | New York | 36039 | 3406 | 79 |
1454696 | 1454696 | 2021-06-25 | Greene | New York | 36039 | 3406 | 79 |
1451451 | 1451451 | 2021-06-24 | Greene | New York | 36039 | 3406 | 79 |
1448205 | 1448205 | 2021-06-23 | Greene | New York | 36039 | 3405 | 79 |
1444960 | 1444960 | 2021-06-22 | Greene | New York | 36039 | 3405 | 79 |
1441715 | 1441715 | 2021-06-21 | Greene | New York | 36039 | 3405 | 79 |
1438470 | 1438470 | 2021-06-20 | Greene | New York | 36039 | 3405 | 79 |
1435223 | 1435223 | 2021-06-19 | Greene | New York | 36039 | 3405 | 79 |
1431976 | 1431976 | 2021-06-18 | Greene | New York | 36039 | 3403 | 79 |
1428730 | 1428730 | 2021-06-17 | Greene | New York | 36039 | 3403 | 79 |
1425485 | 1425485 | 2021-06-16 | Greene | New York | 36039 | 3403 | 79 |
1422238 | 1422238 | 2021-06-15 | Greene | New York | 36039 | 3403 | 79 |
1418992 | 1418992 | 2021-06-14 | Greene | New York | 36039 | 3403 | 79 |
1415747 | 1415747 | 2021-06-13 | Greene | New York | 36039 | 3402 | 79 |
1412501 | 1412501 | 2021-06-12 | Greene | New York | 36039 | 3402 | 79 |
1409256 | 1409256 | 2021-06-11 | Greene | New York | 36039 | 3402 | 79 |
1406011 | 1406011 | 2021-06-10 | Greene | New York | 36039 | 3402 | 79 |
1402765 | 1402765 | 2021-06-09 | Greene | New York | 36039 | 3402 | 79 |
1399520 | 1399520 | 2021-06-08 | Greene | New York | 36039 | 3402 | 79 |
1396275 | 1396275 | 2021-06-07 | Greene | New York | 36039 | 3402 | 79 |
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);