ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Herkimer" 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 |
---|---|---|---|---|---|---|---|
1717760 | 1717760 | 2021-09-14 | Herkimer | New York | 36043 | 5846 | 115 |
1714512 | 1714512 | 2021-09-13 | Herkimer | New York | 36043 | 5828 | 114 |
1711266 | 1711266 | 2021-09-12 | Herkimer | New York | 36043 | 5819 | 114 |
1708019 | 1708019 | 2021-09-11 | Herkimer | New York | 36043 | 5798 | 114 |
1704772 | 1704772 | 2021-09-10 | Herkimer | New York | 36043 | 5776 | 114 |
1701522 | 1701522 | 2021-09-09 | Herkimer | New York | 36043 | 5754 | 113 |
1698273 | 1698273 | 2021-09-08 | Herkimer | New York | 36043 | 5730 | 111 |
1695025 | 1695025 | 2021-09-07 | Herkimer | New York | 36043 | 5705 | 111 |
1691777 | 1691777 | 2021-09-06 | Herkimer | New York | 36043 | 5691 | 111 |
1688527 | 1688527 | 2021-09-05 | Herkimer | New York | 36043 | 5681 | 111 |
1685277 | 1685277 | 2021-09-04 | Herkimer | New York | 36043 | 5667 | 111 |
1682026 | 1682026 | 2021-09-03 | Herkimer | New York | 36043 | 5645 | 111 |
1678777 | 1678777 | 2021-09-02 | Herkimer | New York | 36043 | 5629 | 111 |
1675529 | 1675529 | 2021-09-01 | Herkimer | New York | 36043 | 5616 | 111 |
1672282 | 1672282 | 2021-08-31 | Herkimer | New York | 36043 | 5596 | 110 |
1669034 | 1669034 | 2021-08-30 | Herkimer | New York | 36043 | 5579 | 110 |
1665787 | 1665787 | 2021-08-29 | Herkimer | New York | 36043 | 5567 | 110 |
1662539 | 1662539 | 2021-08-28 | Herkimer | New York | 36043 | 5553 | 110 |
1659291 | 1659291 | 2021-08-27 | Herkimer | New York | 36043 | 5537 | 110 |
1656042 | 1656042 | 2021-08-26 | Herkimer | New York | 36043 | 5519 | 110 |
1652795 | 1652795 | 2021-08-25 | Herkimer | New York | 36043 | 5507 | 110 |
1649547 | 1649547 | 2021-08-24 | Herkimer | New York | 36043 | 5495 | 110 |
1646298 | 1646298 | 2021-08-23 | Herkimer | New York | 36043 | 5478 | 110 |
1643049 | 1643049 | 2021-08-22 | Herkimer | New York | 36043 | 5457 | 110 |
1639799 | 1639799 | 2021-08-21 | Herkimer | New York | 36043 | 5447 | 110 |
1636549 | 1636549 | 2021-08-20 | Herkimer | New York | 36043 | 5426 | 110 |
1633299 | 1633299 | 2021-08-19 | Herkimer | New York | 36043 | 5421 | 110 |
1630052 | 1630052 | 2021-08-18 | Herkimer | New York | 36043 | 5399 | 110 |
1626805 | 1626805 | 2021-08-17 | Herkimer | New York | 36043 | 5392 | 110 |
1623558 | 1623558 | 2021-08-16 | Herkimer | New York | 36043 | 5388 | 110 |
1620311 | 1620311 | 2021-08-15 | Herkimer | New York | 36043 | 5382 | 110 |
1617063 | 1617063 | 2021-08-14 | Herkimer | New York | 36043 | 5376 | 110 |
1613815 | 1613815 | 2021-08-13 | Herkimer | New York | 36043 | 5373 | 110 |
1610566 | 1610566 | 2021-08-12 | Herkimer | New York | 36043 | 5362 | 110 |
1607318 | 1607318 | 2021-08-11 | Herkimer | New York | 36043 | 5350 | 110 |
1604069 | 1604069 | 2021-08-10 | Herkimer | New York | 36043 | 5339 | 110 |
1600820 | 1600820 | 2021-08-09 | Herkimer | New York | 36043 | 5330 | 110 |
1597572 | 1597572 | 2021-08-08 | Herkimer | New York | 36043 | 5326 | 110 |
1594323 | 1594323 | 2021-08-07 | Herkimer | New York | 36043 | 5314 | 110 |
1591074 | 1591074 | 2021-08-06 | Herkimer | New York | 36043 | 5301 | 110 |
1587825 | 1587825 | 2021-08-05 | Herkimer | New York | 36043 | 5294 | 110 |
1584575 | 1584575 | 2021-08-04 | Herkimer | New York | 36043 | 5283 | 110 |
1581325 | 1581325 | 2021-08-03 | Herkimer | New York | 36043 | 5273 | 110 |
1578076 | 1578076 | 2021-08-02 | Herkimer | New York | 36043 | 5266 | 110 |
1574828 | 1574828 | 2021-08-01 | Herkimer | New York | 36043 | 5263 | 110 |
1571580 | 1571580 | 2021-07-31 | Herkimer | New York | 36043 | 5261 | 110 |
1568332 | 1568332 | 2021-07-30 | Herkimer | New York | 36043 | 5255 | 110 |
1565084 | 1565084 | 2021-07-29 | Herkimer | New York | 36043 | 5251 | 110 |
1561836 | 1561836 | 2021-07-28 | Herkimer | New York | 36043 | 5246 | 110 |
1558588 | 1558588 | 2021-07-27 | Herkimer | New York | 36043 | 5242 | 110 |
1555341 | 1555341 | 2021-07-26 | Herkimer | New York | 36043 | 5239 | 110 |
1552094 | 1552094 | 2021-07-25 | Herkimer | New York | 36043 | 5238 | 110 |
1548847 | 1548847 | 2021-07-24 | Herkimer | New York | 36043 | 5235 | 110 |
1545600 | 1545600 | 2021-07-23 | Herkimer | New York | 36043 | 5234 | 110 |
1542353 | 1542353 | 2021-07-22 | Herkimer | New York | 36043 | 5234 | 110 |
1539105 | 1539105 | 2021-07-21 | Herkimer | New York | 36043 | 5231 | 110 |
1535858 | 1535858 | 2021-07-20 | Herkimer | New York | 36043 | 5228 | 110 |
1532610 | 1532610 | 2021-07-19 | Herkimer | New York | 36043 | 5225 | 110 |
1529363 | 1529363 | 2021-07-18 | Herkimer | New York | 36043 | 5225 | 110 |
1526116 | 1526116 | 2021-07-17 | Herkimer | New York | 36043 | 5225 | 110 |
1522869 | 1522869 | 2021-07-16 | Herkimer | New York | 36043 | 5225 | 110 |
1519621 | 1519621 | 2021-07-15 | Herkimer | New York | 36043 | 5224 | 110 |
1516373 | 1516373 | 2021-07-14 | Herkimer | New York | 36043 | 5221 | 110 |
1513126 | 1513126 | 2021-07-13 | Herkimer | New York | 36043 | 5219 | 110 |
1509880 | 1509880 | 2021-07-12 | Herkimer | New York | 36043 | 5219 | 110 |
1506633 | 1506633 | 2021-07-11 | Herkimer | New York | 36043 | 5218 | 110 |
1503387 | 1503387 | 2021-07-10 | Herkimer | New York | 36043 | 5217 | 110 |
1500141 | 1500141 | 2021-07-09 | Herkimer | New York | 36043 | 5216 | 110 |
1496895 | 1496895 | 2021-07-08 | Herkimer | New York | 36043 | 5213 | 110 |
1493648 | 1493648 | 2021-07-07 | Herkimer | New York | 36043 | 5211 | 110 |
1490401 | 1490401 | 2021-07-06 | Herkimer | New York | 36043 | 5210 | 110 |
1487154 | 1487154 | 2021-07-05 | Herkimer | New York | 36043 | 5209 | 109 |
1483908 | 1483908 | 2021-07-04 | Herkimer | New York | 36043 | 5209 | 109 |
1480662 | 1480662 | 2021-07-03 | Herkimer | New York | 36043 | 5208 | 109 |
1477415 | 1477415 | 2021-07-02 | Herkimer | New York | 36043 | 5208 | 109 |
1474169 | 1474169 | 2021-07-01 | Herkimer | New York | 36043 | 5207 | 109 |
1470923 | 1470923 | 2021-06-30 | Herkimer | New York | 36043 | 5206 | 109 |
1467678 | 1467678 | 2021-06-29 | Herkimer | New York | 36043 | 5205 | 109 |
1464433 | 1464433 | 2021-06-28 | Herkimer | New York | 36043 | 5205 | 109 |
1461188 | 1461188 | 2021-06-27 | Herkimer | New York | 36043 | 5205 | 109 |
1457943 | 1457943 | 2021-06-26 | Herkimer | New York | 36043 | 5203 | 109 |
1454698 | 1454698 | 2021-06-25 | Herkimer | New York | 36043 | 5202 | 109 |
1451453 | 1451453 | 2021-06-24 | Herkimer | New York | 36043 | 5198 | 109 |
1448207 | 1448207 | 2021-06-23 | Herkimer | New York | 36043 | 5196 | 109 |
1444962 | 1444962 | 2021-06-22 | Herkimer | New York | 36043 | 5196 | 109 |
1441717 | 1441717 | 2021-06-21 | Herkimer | New York | 36043 | 5196 | 109 |
1438472 | 1438472 | 2021-06-20 | Herkimer | New York | 36043 | 5194 | 109 |
1435225 | 1435225 | 2021-06-19 | Herkimer | New York | 36043 | 5193 | 109 |
1431978 | 1431978 | 2021-06-18 | Herkimer | New York | 36043 | 5191 | 109 |
1428732 | 1428732 | 2021-06-17 | Herkimer | New York | 36043 | 5190 | 109 |
1425487 | 1425487 | 2021-06-16 | Herkimer | New York | 36043 | 5189 | 109 |
1422240 | 1422240 | 2021-06-15 | Herkimer | New York | 36043 | 5187 | 109 |
1418994 | 1418994 | 2021-06-14 | Herkimer | New York | 36043 | 5186 | 109 |
1415749 | 1415749 | 2021-06-13 | Herkimer | New York | 36043 | 5182 | 109 |
1412503 | 1412503 | 2021-06-12 | Herkimer | New York | 36043 | 5182 | 109 |
1409258 | 1409258 | 2021-06-11 | Herkimer | New York | 36043 | 5182 | 109 |
1406013 | 1406013 | 2021-06-10 | Herkimer | New York | 36043 | 5182 | 108 |
1402767 | 1402767 | 2021-06-09 | Herkimer | New York | 36043 | 5182 | 107 |
1399522 | 1399522 | 2021-06-08 | Herkimer | New York | 36043 | 5182 | 107 |
1396277 | 1396277 | 2021-06-07 | Herkimer | New York | 36043 | 5180 | 107 |
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);