ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 36055 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 |
---|---|---|---|---|---|---|---|
1717765 | 1717765 | 2021-09-14 | Monroe | New York | 36055 | 76509 | 1148 |
1714517 | 1714517 | 2021-09-13 | Monroe | New York | 36055 | 76412 | 1146 |
1711271 | 1711271 | 2021-09-12 | Monroe | New York | 36055 | 76269 | 1146 |
1708024 | 1708024 | 2021-09-11 | Monroe | New York | 36055 | 76031 | 1145 |
1704777 | 1704777 | 2021-09-10 | Monroe | New York | 36055 | 75819 | 1145 |
1701527 | 1701527 | 2021-09-09 | Monroe | New York | 36055 | 75614 | 1142 |
1698278 | 1698278 | 2021-09-08 | Monroe | New York | 36055 | 75467 | 1142 |
1695030 | 1695030 | 2021-09-07 | Monroe | New York | 36055 | 75371 | 1141 |
1691782 | 1691782 | 2021-09-06 | Monroe | New York | 36055 | 75260 | 1137 |
1688532 | 1688532 | 2021-09-05 | Monroe | New York | 36055 | 75118 | 1135 |
1685282 | 1685282 | 2021-09-04 | Monroe | New York | 36055 | 74988 | 1132 |
1682031 | 1682031 | 2021-09-03 | Monroe | New York | 36055 | 74796 | 1132 |
1678782 | 1678782 | 2021-09-02 | Monroe | New York | 36055 | 74578 | 1130 |
1675534 | 1675534 | 2021-09-01 | Monroe | New York | 36055 | 74388 | 1130 |
1672287 | 1672287 | 2021-08-31 | Monroe | New York | 36055 | 74236 | 1130 |
1669039 | 1669039 | 2021-08-30 | Monroe | New York | 36055 | 74079 | 1130 |
1665792 | 1665792 | 2021-08-29 | Monroe | New York | 36055 | 73934 | 1130 |
1662544 | 1662544 | 2021-08-28 | Monroe | New York | 36055 | 73750 | 1130 |
1659296 | 1659296 | 2021-08-27 | Monroe | New York | 36055 | 73577 | 1129 |
1656047 | 1656047 | 2021-08-26 | Monroe | New York | 36055 | 73323 | 1128 |
1652800 | 1652800 | 2021-08-25 | Monroe | New York | 36055 | 73119 | 1128 |
1649552 | 1649552 | 2021-08-24 | Monroe | New York | 36055 | 72950 | 1127 |
1646303 | 1646303 | 2021-08-23 | Monroe | New York | 36055 | 72844 | 1127 |
1643054 | 1643054 | 2021-08-22 | Monroe | New York | 36055 | 72716 | 1125 |
1639804 | 1639804 | 2021-08-21 | Monroe | New York | 36055 | 72552 | 1124 |
1636554 | 1636554 | 2021-08-20 | Monroe | New York | 36055 | 72377 | 1124 |
1633304 | 1633304 | 2021-08-19 | Monroe | New York | 36055 | 72207 | 1122 |
1630057 | 1630057 | 2021-08-18 | Monroe | New York | 36055 | 72040 | 1121 |
1626810 | 1626810 | 2021-08-17 | Monroe | New York | 36055 | 71905 | 1121 |
1623563 | 1623563 | 2021-08-16 | Monroe | New York | 36055 | 71760 | 1121 |
1620316 | 1620316 | 2021-08-15 | Monroe | New York | 36055 | 71618 | 1121 |
1617068 | 1617068 | 2021-08-14 | Monroe | New York | 36055 | 71477 | 1120 |
1613820 | 1613820 | 2021-08-13 | Monroe | New York | 36055 | 71362 | 1120 |
1610571 | 1610571 | 2021-08-12 | Monroe | New York | 36055 | 71219 | 1120 |
1607323 | 1607323 | 2021-08-11 | Monroe | New York | 36055 | 71042 | 1119 |
1604074 | 1604074 | 2021-08-10 | Monroe | New York | 36055 | 70908 | 1118 |
1600825 | 1600825 | 2021-08-09 | Monroe | New York | 36055 | 70787 | 1117 |
1597577 | 1597577 | 2021-08-08 | Monroe | New York | 36055 | 70681 | 1117 |
1594328 | 1594328 | 2021-08-07 | Monroe | New York | 36055 | 70558 | 1117 |
1591079 | 1591079 | 2021-08-06 | Monroe | New York | 36055 | 70387 | 1117 |
1587830 | 1587830 | 2021-08-05 | Monroe | New York | 36055 | 70308 | 1117 |
1584580 | 1584580 | 2021-08-04 | Monroe | New York | 36055 | 70215 | 1117 |
1581330 | 1581330 | 2021-08-03 | Monroe | New York | 36055 | 70135 | 1117 |
1578081 | 1578081 | 2021-08-02 | Monroe | New York | 36055 | 70072 | 1117 |
1574833 | 1574833 | 2021-08-01 | Monroe | New York | 36055 | 70033 | 1117 |
1571585 | 1571585 | 2021-07-31 | Monroe | New York | 36055 | 69971 | 1117 |
1568337 | 1568337 | 2021-07-30 | Monroe | New York | 36055 | 69897 | 1117 |
1565089 | 1565089 | 2021-07-29 | Monroe | New York | 36055 | 69828 | 1117 |
1561841 | 1561841 | 2021-07-28 | Monroe | New York | 36055 | 69783 | 1117 |
1558593 | 1558593 | 2021-07-27 | Monroe | New York | 36055 | 69740 | 1117 |
1555346 | 1555346 | 2021-07-26 | Monroe | New York | 36055 | 69693 | 1117 |
1552099 | 1552099 | 2021-07-25 | Monroe | New York | 36055 | 69660 | 1117 |
1548852 | 1548852 | 2021-07-24 | Monroe | New York | 36055 | 69600 | 1117 |
1545605 | 1545605 | 2021-07-23 | Monroe | New York | 36055 | 69567 | 1117 |
1542358 | 1542358 | 2021-07-22 | Monroe | New York | 36055 | 69535 | 1117 |
1539110 | 1539110 | 2021-07-21 | Monroe | New York | 36055 | 69503 | 1117 |
1535863 | 1535863 | 2021-07-20 | Monroe | New York | 36055 | 69482 | 1117 |
1532615 | 1532615 | 2021-07-19 | Monroe | New York | 36055 | 69464 | 1117 |
1529368 | 1529368 | 2021-07-18 | Monroe | New York | 36055 | 69449 | 1117 |
1526121 | 1526121 | 2021-07-17 | Monroe | New York | 36055 | 69417 | 1117 |
1522874 | 1522874 | 2021-07-16 | Monroe | New York | 36055 | 69401 | 1117 |
1519626 | 1519626 | 2021-07-15 | Monroe | New York | 36055 | 69383 | 1117 |
1516378 | 1516378 | 2021-07-14 | Monroe | New York | 36055 | 69348 | 1117 |
1513131 | 1513131 | 2021-07-13 | Monroe | New York | 36055 | 69337 | 1117 |
1509885 | 1509885 | 2021-07-12 | Monroe | New York | 36055 | 69326 | 1115 |
1506638 | 1506638 | 2021-07-11 | Monroe | New York | 36055 | 69316 | 1115 |
1503392 | 1503392 | 2021-07-10 | Monroe | New York | 36055 | 69305 | 1115 |
1500146 | 1500146 | 2021-07-09 | Monroe | New York | 36055 | 69290 | 1115 |
1496900 | 1496900 | 2021-07-08 | Monroe | New York | 36055 | 69274 | 1115 |
1493653 | 1493653 | 2021-07-07 | Monroe | New York | 36055 | 69260 | 1115 |
1490406 | 1490406 | 2021-07-06 | Monroe | New York | 36055 | 69241 | 1115 |
1487159 | 1487159 | 2021-07-05 | Monroe | New York | 36055 | 69234 | 1115 |
1483913 | 1483913 | 2021-07-04 | Monroe | New York | 36055 | 69223 | 1115 |
1480667 | 1480667 | 2021-07-03 | Monroe | New York | 36055 | 69207 | 1115 |
1477420 | 1477420 | 2021-07-02 | Monroe | New York | 36055 | 69197 | 1115 |
1474174 | 1474174 | 2021-07-01 | Monroe | New York | 36055 | 69179 | 1115 |
1470928 | 1470928 | 2021-06-30 | Monroe | New York | 36055 | 69164 | 1115 |
1467683 | 1467683 | 2021-06-29 | Monroe | New York | 36055 | 69153 | 1115 |
1464438 | 1464438 | 2021-06-28 | Monroe | New York | 36055 | 69147 | 1115 |
1461193 | 1461193 | 2021-06-27 | Monroe | New York | 36055 | 69131 | 1115 |
1457948 | 1457948 | 2021-06-26 | Monroe | New York | 36055 | 69125 | 1115 |
1454703 | 1454703 | 2021-06-25 | Monroe | New York | 36055 | 69117 | 1115 |
1451458 | 1451458 | 2021-06-24 | Monroe | New York | 36055 | 69103 | 1114 |
1448212 | 1448212 | 2021-06-23 | Monroe | New York | 36055 | 69091 | 1114 |
1444967 | 1444967 | 2021-06-22 | Monroe | New York | 36055 | 69080 | 1113 |
1441722 | 1441722 | 2021-06-21 | Monroe | New York | 36055 | 69070 | 1113 |
1438477 | 1438477 | 2021-06-20 | Monroe | New York | 36055 | 69064 | 1113 |
1435230 | 1435230 | 2021-06-19 | Monroe | New York | 36055 | 69055 | 1112 |
1431983 | 1431983 | 2021-06-18 | Monroe | New York | 36055 | 69036 | 1111 |
1428737 | 1428737 | 2021-06-17 | Monroe | New York | 36055 | 69013 | 1110 |
1425492 | 1425492 | 2021-06-16 | Monroe | New York | 36055 | 68992 | 1110 |
1422245 | 1422245 | 2021-06-15 | Monroe | New York | 36055 | 68977 | 1110 |
1418999 | 1418999 | 2021-06-14 | Monroe | New York | 36055 | 68960 | 1110 |
1415754 | 1415754 | 2021-06-13 | Monroe | New York | 36055 | 68930 | 1110 |
1412508 | 1412508 | 2021-06-12 | Monroe | New York | 36055 | 68902 | 1110 |
1409263 | 1409263 | 2021-06-11 | Monroe | New York | 36055 | 68880 | 1110 |
1406018 | 1406018 | 2021-06-10 | Monroe | New York | 36055 | 68854 | 1110 |
1402772 | 1402772 | 2021-06-09 | Monroe | New York | 36055 | 68822 | 1110 |
1399527 | 1399527 | 2021-06-08 | Monroe | New York | 36055 | 68796 | 1110 |
1396282 | 1396282 | 2021-06-07 | Monroe | New York | 36055 | 68769 | 1108 |
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);