ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Tompkins" 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 |
---|---|---|---|---|---|---|---|
1717790 | 1717790 | 2021-09-14 | Tompkins | New York | 36109 | 5690 | 57 |
1714542 | 1714542 | 2021-09-13 | Tompkins | New York | 36109 | 5683 | 57 |
1711296 | 1711296 | 2021-09-12 | Tompkins | New York | 36109 | 5669 | 56 |
1708049 | 1708049 | 2021-09-11 | Tompkins | New York | 36109 | 5621 | 56 |
1704802 | 1704802 | 2021-09-10 | Tompkins | New York | 36109 | 5594 | 56 |
1701552 | 1701552 | 2021-09-09 | Tompkins | New York | 36109 | 5544 | 56 |
1698303 | 1698303 | 2021-09-08 | Tompkins | New York | 36109 | 5489 | 56 |
1695055 | 1695055 | 2021-09-07 | Tompkins | New York | 36109 | 5471 | 56 |
1691807 | 1691807 | 2021-09-06 | Tompkins | New York | 36109 | 5453 | 56 |
1688557 | 1688557 | 2021-09-05 | Tompkins | New York | 36109 | 5437 | 56 |
1685307 | 1685307 | 2021-09-04 | Tompkins | New York | 36109 | 5376 | 56 |
1682056 | 1682056 | 2021-09-03 | Tompkins | New York | 36109 | 5331 | 56 |
1678807 | 1678807 | 2021-09-02 | Tompkins | New York | 36109 | 5279 | 56 |
1675559 | 1675559 | 2021-09-01 | Tompkins | New York | 36109 | 5207 | 56 |
1672312 | 1672312 | 2021-08-31 | Tompkins | New York | 36109 | 5167 | 56 |
1669064 | 1669064 | 2021-08-30 | Tompkins | New York | 36109 | 5138 | 56 |
1665817 | 1665817 | 2021-08-29 | Tompkins | New York | 36109 | 5072 | 56 |
1662569 | 1662569 | 2021-08-28 | Tompkins | New York | 36109 | 4980 | 56 |
1659321 | 1659321 | 2021-08-27 | Tompkins | New York | 36109 | 4913 | 55 |
1656072 | 1656072 | 2021-08-26 | Tompkins | New York | 36109 | 4861 | 55 |
1652825 | 1652825 | 2021-08-25 | Tompkins | New York | 36109 | 4830 | 55 |
1649577 | 1649577 | 2021-08-24 | Tompkins | New York | 36109 | 4807 | 55 |
1646328 | 1646328 | 2021-08-23 | Tompkins | New York | 36109 | 4800 | 55 |
1643079 | 1643079 | 2021-08-22 | Tompkins | New York | 36109 | 4790 | 55 |
1639829 | 1639829 | 2021-08-21 | Tompkins | New York | 36109 | 4763 | 55 |
1636579 | 1636579 | 2021-08-20 | Tompkins | New York | 36109 | 4738 | 55 |
1633329 | 1633329 | 2021-08-19 | Tompkins | New York | 36109 | 4719 | 55 |
1630082 | 1630082 | 2021-08-18 | Tompkins | New York | 36109 | 4697 | 55 |
1626835 | 1626835 | 2021-08-17 | Tompkins | New York | 36109 | 4661 | 54 |
1623588 | 1623588 | 2021-08-16 | Tompkins | New York | 36109 | 4656 | 54 |
1620341 | 1620341 | 2021-08-15 | Tompkins | New York | 36109 | 4644 | 54 |
1617093 | 1617093 | 2021-08-14 | Tompkins | New York | 36109 | 4628 | 54 |
1613845 | 1613845 | 2021-08-13 | Tompkins | New York | 36109 | 4613 | 54 |
1610596 | 1610596 | 2021-08-12 | Tompkins | New York | 36109 | 4590 | 54 |
1607348 | 1607348 | 2021-08-11 | Tompkins | New York | 36109 | 4561 | 54 |
1604099 | 1604099 | 2021-08-10 | Tompkins | New York | 36109 | 4551 | 54 |
1600850 | 1600850 | 2021-08-09 | Tompkins | New York | 36109 | 4542 | 54 |
1597602 | 1597602 | 2021-08-08 | Tompkins | New York | 36109 | 4533 | 54 |
1594353 | 1594353 | 2021-08-07 | Tompkins | New York | 36109 | 4519 | 54 |
1591104 | 1591104 | 2021-08-06 | Tompkins | New York | 36109 | 4507 | 54 |
1587855 | 1587855 | 2021-08-05 | Tompkins | New York | 36109 | 4495 | 54 |
1584605 | 1584605 | 2021-08-04 | Tompkins | New York | 36109 | 4488 | 54 |
1581355 | 1581355 | 2021-08-03 | Tompkins | New York | 36109 | 4469 | 53 |
1578106 | 1578106 | 2021-08-02 | Tompkins | New York | 36109 | 4465 | 53 |
1574858 | 1574858 | 2021-08-01 | Tompkins | New York | 36109 | 4459 | 53 |
1571610 | 1571610 | 2021-07-31 | Tompkins | New York | 36109 | 4452 | 52 |
1568362 | 1568362 | 2021-07-30 | Tompkins | New York | 36109 | 4441 | 52 |
1565114 | 1565114 | 2021-07-29 | Tompkins | New York | 36109 | 4428 | 52 |
1561866 | 1561866 | 2021-07-28 | Tompkins | New York | 36109 | 4408 | 52 |
1558618 | 1558618 | 2021-07-27 | Tompkins | New York | 36109 | 4396 | 52 |
1555371 | 1555371 | 2021-07-26 | Tompkins | New York | 36109 | 4393 | 52 |
1552124 | 1552124 | 2021-07-25 | Tompkins | New York | 36109 | 4393 | 52 |
1548877 | 1548877 | 2021-07-24 | Tompkins | New York | 36109 | 4391 | 52 |
1545630 | 1545630 | 2021-07-23 | Tompkins | New York | 36109 | 4384 | 52 |
1542383 | 1542383 | 2021-07-22 | Tompkins | New York | 36109 | 4380 | 52 |
1539135 | 1539135 | 2021-07-21 | Tompkins | New York | 36109 | 4379 | 52 |
1535888 | 1535888 | 2021-07-20 | Tompkins | New York | 36109 | 4377 | 52 |
1532640 | 1532640 | 2021-07-19 | Tompkins | New York | 36109 | 4377 | 52 |
1529393 | 1529393 | 2021-07-18 | Tompkins | New York | 36109 | 4377 | 52 |
1526146 | 1526146 | 2021-07-17 | Tompkins | New York | 36109 | 4377 | 52 |
1522899 | 1522899 | 2021-07-16 | Tompkins | New York | 36109 | 4375 | 52 |
1519651 | 1519651 | 2021-07-15 | Tompkins | New York | 36109 | 4373 | 52 |
1516403 | 1516403 | 2021-07-14 | Tompkins | New York | 36109 | 4372 | 52 |
1513156 | 1513156 | 2021-07-13 | Tompkins | New York | 36109 | 4370 | 52 |
1509910 | 1509910 | 2021-07-12 | Tompkins | New York | 36109 | 4369 | 52 |
1506663 | 1506663 | 2021-07-11 | Tompkins | New York | 36109 | 4368 | 52 |
1503417 | 1503417 | 2021-07-10 | Tompkins | New York | 36109 | 4368 | 52 |
1500171 | 1500171 | 2021-07-09 | Tompkins | New York | 36109 | 4366 | 52 |
1496925 | 1496925 | 2021-07-08 | Tompkins | New York | 36109 | 4365 | 52 |
1493678 | 1493678 | 2021-07-07 | Tompkins | New York | 36109 | 4365 | 52 |
1490431 | 1490431 | 2021-07-06 | Tompkins | New York | 36109 | 4365 | 52 |
1487184 | 1487184 | 2021-07-05 | Tompkins | New York | 36109 | 4364 | 52 |
1483938 | 1483938 | 2021-07-04 | Tompkins | New York | 36109 | 4361 | 52 |
1480692 | 1480692 | 2021-07-03 | Tompkins | New York | 36109 | 4361 | 52 |
1477445 | 1477445 | 2021-07-02 | Tompkins | New York | 36109 | 4360 | 52 |
1474199 | 1474199 | 2021-07-01 | Tompkins | New York | 36109 | 4359 | 52 |
1470953 | 1470953 | 2021-06-30 | Tompkins | New York | 36109 | 4358 | 52 |
1467708 | 1467708 | 2021-06-29 | Tompkins | New York | 36109 | 4358 | 52 |
1464463 | 1464463 | 2021-06-28 | Tompkins | New York | 36109 | 4358 | 52 |
1461218 | 1461218 | 2021-06-27 | Tompkins | New York | 36109 | 4358 | 52 |
1457973 | 1457973 | 2021-06-26 | Tompkins | New York | 36109 | 4357 | 52 |
1454728 | 1454728 | 2021-06-25 | Tompkins | New York | 36109 | 4357 | 52 |
1451483 | 1451483 | 2021-06-24 | Tompkins | New York | 36109 | 4356 | 52 |
1448237 | 1448237 | 2021-06-23 | Tompkins | New York | 36109 | 4353 | 52 |
1444992 | 1444992 | 2021-06-22 | Tompkins | New York | 36109 | 4352 | 52 |
1441747 | 1441747 | 2021-06-21 | Tompkins | New York | 36109 | 4351 | 52 |
1438502 | 1438502 | 2021-06-20 | Tompkins | New York | 36109 | 4350 | 52 |
1435255 | 1435255 | 2021-06-19 | Tompkins | New York | 36109 | 4350 | 52 |
1432008 | 1432008 | 2021-06-18 | Tompkins | New York | 36109 | 4350 | 52 |
1428762 | 1428762 | 2021-06-17 | Tompkins | New York | 36109 | 4349 | 52 |
1425517 | 1425517 | 2021-06-16 | Tompkins | New York | 36109 | 4346 | 52 |
1422270 | 1422270 | 2021-06-15 | Tompkins | New York | 36109 | 4346 | 52 |
1419024 | 1419024 | 2021-06-14 | Tompkins | New York | 36109 | 4346 | 52 |
1415779 | 1415779 | 2021-06-13 | Tompkins | New York | 36109 | 4346 | 52 |
1412533 | 1412533 | 2021-06-12 | Tompkins | New York | 36109 | 4346 | 52 |
1409288 | 1409288 | 2021-06-11 | Tompkins | New York | 36109 | 4344 | 52 |
1406043 | 1406043 | 2021-06-10 | Tompkins | New York | 36109 | 4344 | 52 |
1402797 | 1402797 | 2021-06-09 | Tompkins | New York | 36109 | 4344 | 52 |
1399552 | 1399552 | 2021-06-08 | Tompkins | New York | 36109 | 4341 | 52 |
1396307 | 1396307 | 2021-06-07 | Tompkins | New York | 36109 | 4341 | 52 |
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);