ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Broome" 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 |
---|---|---|---|---|---|---|---|
1717742 | 1717742 | 2021-09-14 | Broome | New York | 36007 | 21081 | 379 |
1714494 | 1714494 | 2021-09-13 | Broome | New York | 36007 | 21020 | 379 |
1711248 | 1711248 | 2021-09-12 | Broome | New York | 36007 | 20961 | 377 |
1708001 | 1708001 | 2021-09-11 | Broome | New York | 36007 | 20883 | 376 |
1704754 | 1704754 | 2021-09-10 | Broome | New York | 36007 | 20808 | 376 |
1701504 | 1701504 | 2021-09-09 | Broome | New York | 36007 | 20702 | 375 |
1698255 | 1698255 | 2021-09-08 | Broome | New York | 36007 | 20618 | 374 |
1695007 | 1695007 | 2021-09-07 | Broome | New York | 36007 | 20560 | 374 |
1691759 | 1691759 | 2021-09-06 | Broome | New York | 36007 | 20525 | 373 |
1688509 | 1688509 | 2021-09-05 | Broome | New York | 36007 | 20471 | 373 |
1685259 | 1685259 | 2021-09-04 | Broome | New York | 36007 | 20406 | 373 |
1682008 | 1682008 | 2021-09-03 | Broome | New York | 36007 | 20312 | 372 |
1678759 | 1678759 | 2021-09-02 | Broome | New York | 36007 | 20201 | 372 |
1675511 | 1675511 | 2021-09-01 | Broome | New York | 36007 | 20109 | 371 |
1672264 | 1672264 | 2021-08-31 | Broome | New York | 36007 | 20041 | 371 |
1669016 | 1669016 | 2021-08-30 | Broome | New York | 36007 | 19991 | 371 |
1665769 | 1665769 | 2021-08-29 | Broome | New York | 36007 | 19937 | 371 |
1662521 | 1662521 | 2021-08-28 | Broome | New York | 36007 | 19881 | 371 |
1659273 | 1659273 | 2021-08-27 | Broome | New York | 36007 | 19809 | 371 |
1656024 | 1656024 | 2021-08-26 | Broome | New York | 36007 | 19726 | 370 |
1652777 | 1652777 | 2021-08-25 | Broome | New York | 36007 | 19667 | 370 |
1649529 | 1649529 | 2021-08-24 | Broome | New York | 36007 | 19597 | 370 |
1646280 | 1646280 | 2021-08-23 | Broome | New York | 36007 | 19560 | 370 |
1643031 | 1643031 | 2021-08-22 | Broome | New York | 36007 | 19523 | 370 |
1639781 | 1639781 | 2021-08-21 | Broome | New York | 36007 | 19480 | 369 |
1636531 | 1636531 | 2021-08-20 | Broome | New York | 36007 | 19437 | 369 |
1633281 | 1633281 | 2021-08-19 | Broome | New York | 36007 | 19414 | 369 |
1630034 | 1630034 | 2021-08-18 | Broome | New York | 36007 | 19365 | 369 |
1626787 | 1626787 | 2021-08-17 | Broome | New York | 36007 | 19322 | 369 |
1623540 | 1623540 | 2021-08-16 | Broome | New York | 36007 | 19285 | 369 |
1620293 | 1620293 | 2021-08-15 | Broome | New York | 36007 | 19254 | 369 |
1617045 | 1617045 | 2021-08-14 | Broome | New York | 36007 | 19226 | 369 |
1613797 | 1613797 | 2021-08-13 | Broome | New York | 36007 | 19180 | 369 |
1610548 | 1610548 | 2021-08-12 | Broome | New York | 36007 | 19116 | 368 |
1607300 | 1607300 | 2021-08-11 | Broome | New York | 36007 | 19074 | 368 |
1604051 | 1604051 | 2021-08-10 | Broome | New York | 36007 | 19047 | 367 |
1600802 | 1600802 | 2021-08-09 | Broome | New York | 36007 | 19020 | 367 |
1597554 | 1597554 | 2021-08-08 | Broome | New York | 36007 | 18994 | 367 |
1594305 | 1594305 | 2021-08-07 | Broome | New York | 36007 | 18963 | 367 |
1591056 | 1591056 | 2021-08-06 | Broome | New York | 36007 | 18929 | 367 |
1587807 | 1587807 | 2021-08-05 | Broome | New York | 36007 | 18901 | 367 |
1584557 | 1584557 | 2021-08-04 | Broome | New York | 36007 | 18882 | 367 |
1581307 | 1581307 | 2021-08-03 | Broome | New York | 36007 | 18850 | 367 |
1578058 | 1578058 | 2021-08-02 | Broome | New York | 36007 | 18827 | 367 |
1574810 | 1574810 | 2021-08-01 | Broome | New York | 36007 | 18814 | 367 |
1571562 | 1571562 | 2021-07-31 | Broome | New York | 36007 | 18800 | 367 |
1568314 | 1568314 | 2021-07-30 | Broome | New York | 36007 | 18789 | 367 |
1565066 | 1565066 | 2021-07-29 | Broome | New York | 36007 | 18776 | 367 |
1561818 | 1561818 | 2021-07-28 | Broome | New York | 36007 | 18769 | 367 |
1558570 | 1558570 | 2021-07-27 | Broome | New York | 36007 | 18764 | 367 |
1555323 | 1555323 | 2021-07-26 | Broome | New York | 36007 | 18755 | 367 |
1552076 | 1552076 | 2021-07-25 | Broome | New York | 36007 | 18751 | 367 |
1548829 | 1548829 | 2021-07-24 | Broome | New York | 36007 | 18744 | 367 |
1545582 | 1545582 | 2021-07-23 | Broome | New York | 36007 | 18730 | 367 |
1542335 | 1542335 | 2021-07-22 | Broome | New York | 36007 | 18724 | 367 |
1539087 | 1539087 | 2021-07-21 | Broome | New York | 36007 | 18718 | 367 |
1535840 | 1535840 | 2021-07-20 | Broome | New York | 36007 | 18715 | 367 |
1532592 | 1532592 | 2021-07-19 | Broome | New York | 36007 | 18710 | 367 |
1529345 | 1529345 | 2021-07-18 | Broome | New York | 36007 | 18706 | 367 |
1526098 | 1526098 | 2021-07-17 | Broome | New York | 36007 | 18702 | 367 |
1522851 | 1522851 | 2021-07-16 | Broome | New York | 36007 | 18695 | 367 |
1519603 | 1519603 | 2021-07-15 | Broome | New York | 36007 | 18693 | 367 |
1516355 | 1516355 | 2021-07-14 | Broome | New York | 36007 | 18690 | 367 |
1513108 | 1513108 | 2021-07-13 | Broome | New York | 36007 | 18686 | 367 |
1509862 | 1509862 | 2021-07-12 | Broome | New York | 36007 | 18682 | 367 |
1506615 | 1506615 | 2021-07-11 | Broome | New York | 36007 | 18681 | 367 |
1503369 | 1503369 | 2021-07-10 | Broome | New York | 36007 | 18678 | 367 |
1500123 | 1500123 | 2021-07-09 | Broome | New York | 36007 | 18676 | 367 |
1496877 | 1496877 | 2021-07-08 | Broome | New York | 36007 | 18671 | 367 |
1493630 | 1493630 | 2021-07-07 | Broome | New York | 36007 | 18669 | 366 |
1490383 | 1490383 | 2021-07-06 | Broome | New York | 36007 | 18669 | 366 |
1487136 | 1487136 | 2021-07-05 | Broome | New York | 36007 | 18669 | 366 |
1483890 | 1483890 | 2021-07-04 | Broome | New York | 36007 | 18660 | 366 |
1480644 | 1480644 | 2021-07-03 | Broome | New York | 36007 | 18659 | 366 |
1477397 | 1477397 | 2021-07-02 | Broome | New York | 36007 | 18659 | 366 |
1474151 | 1474151 | 2021-07-01 | Broome | New York | 36007 | 18656 | 366 |
1470905 | 1470905 | 2021-06-30 | Broome | New York | 36007 | 18655 | 366 |
1467660 | 1467660 | 2021-06-29 | Broome | New York | 36007 | 18652 | 366 |
1464415 | 1464415 | 2021-06-28 | Broome | New York | 36007 | 18652 | 366 |
1461170 | 1461170 | 2021-06-27 | Broome | New York | 36007 | 18650 | 366 |
1457925 | 1457925 | 2021-06-26 | Broome | New York | 36007 | 18648 | 366 |
1454680 | 1454680 | 2021-06-25 | Broome | New York | 36007 | 18647 | 366 |
1451435 | 1451435 | 2021-06-24 | Broome | New York | 36007 | 18643 | 366 |
1448189 | 1448189 | 2021-06-23 | Broome | New York | 36007 | 18641 | 366 |
1444944 | 1444944 | 2021-06-22 | Broome | New York | 36007 | 18638 | 366 |
1441699 | 1441699 | 2021-06-21 | Broome | New York | 36007 | 18637 | 366 |
1438454 | 1438454 | 2021-06-20 | Broome | New York | 36007 | 18636 | 366 |
1435207 | 1435207 | 2021-06-19 | Broome | New York | 36007 | 18633 | 366 |
1431960 | 1431960 | 2021-06-18 | Broome | New York | 36007 | 18630 | 366 |
1428714 | 1428714 | 2021-06-17 | Broome | New York | 36007 | 18626 | 366 |
1425469 | 1425469 | 2021-06-16 | Broome | New York | 36007 | 18625 | 366 |
1422222 | 1422222 | 2021-06-15 | Broome | New York | 36007 | 18623 | 366 |
1418976 | 1418976 | 2021-06-14 | Broome | New York | 36007 | 18619 | 366 |
1415731 | 1415731 | 2021-06-13 | Broome | New York | 36007 | 18616 | 366 |
1412485 | 1412485 | 2021-06-12 | Broome | New York | 36007 | 18612 | 366 |
1409240 | 1409240 | 2021-06-11 | Broome | New York | 36007 | 18607 | 366 |
1405995 | 1405995 | 2021-06-10 | Broome | New York | 36007 | 18603 | 366 |
1402749 | 1402749 | 2021-06-09 | Broome | New York | 36007 | 18600 | 366 |
1399504 | 1399504 | 2021-06-08 | Broome | New York | 36007 | 18600 | 366 |
1396259 | 1396259 | 2021-06-07 | Broome | New York | 36007 | 18599 | 365 |
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);