ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 36119 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 |
---|---|---|---|---|---|---|---|
1717795 | 1717795 | 2021-09-14 | Westchester | New York | 36119 | 139487 | 2322 |
1714547 | 1714547 | 2021-09-13 | Westchester | New York | 36119 | 139331 | 2321 |
1711301 | 1711301 | 2021-09-12 | Westchester | New York | 36119 | 139197 | 2321 |
1708054 | 1708054 | 2021-09-11 | Westchester | New York | 36119 | 139047 | 2320 |
1704807 | 1704807 | 2021-09-10 | Westchester | New York | 36119 | 138882 | 2319 |
1701557 | 1701557 | 2021-09-09 | Westchester | New York | 36119 | 138582 | 2317 |
1698308 | 1698308 | 2021-09-08 | Westchester | New York | 36119 | 138416 | 2317 |
1695060 | 1695060 | 2021-09-07 | Westchester | New York | 36119 | 138298 | 2317 |
1691812 | 1691812 | 2021-09-06 | Westchester | New York | 36119 | 138195 | 2315 |
1688562 | 1688562 | 2021-09-05 | Westchester | New York | 36119 | 138047 | 2314 |
1685312 | 1685312 | 2021-09-04 | Westchester | New York | 36119 | 137872 | 2313 |
1682061 | 1682061 | 2021-09-03 | Westchester | New York | 36119 | 137684 | 2311 |
1678812 | 1678812 | 2021-09-02 | Westchester | New York | 36119 | 137491 | 2311 |
1675564 | 1675564 | 2021-09-01 | Westchester | New York | 36119 | 137315 | 2310 |
1672317 | 1672317 | 2021-08-31 | Westchester | New York | 36119 | 137103 | 2308 |
1669069 | 1669069 | 2021-08-30 | Westchester | New York | 36119 | 136964 | 2308 |
1665822 | 1665822 | 2021-08-29 | Westchester | New York | 36119 | 136817 | 2308 |
1662574 | 1662574 | 2021-08-28 | Westchester | New York | 36119 | 136648 | 2306 |
1659326 | 1659326 | 2021-08-27 | Westchester | New York | 36119 | 136417 | 2305 |
1656077 | 1656077 | 2021-08-26 | Westchester | New York | 36119 | 136136 | 2304 |
1652830 | 1652830 | 2021-08-25 | Westchester | New York | 36119 | 135921 | 2303 |
1649582 | 1649582 | 2021-08-24 | Westchester | New York | 36119 | 135745 | 2303 |
1646333 | 1646333 | 2021-08-23 | Westchester | New York | 36119 | 135599 | 2303 |
1643084 | 1643084 | 2021-08-22 | Westchester | New York | 36119 | 135445 | 2303 |
1639834 | 1639834 | 2021-08-21 | Westchester | New York | 36119 | 135294 | 2302 |
1636584 | 1636584 | 2021-08-20 | Westchester | New York | 36119 | 135064 | 2301 |
1633334 | 1633334 | 2021-08-19 | Westchester | New York | 36119 | 134832 | 2301 |
1630087 | 1630087 | 2021-08-18 | Westchester | New York | 36119 | 134589 | 2301 |
1626840 | 1626840 | 2021-08-17 | Westchester | New York | 36119 | 134355 | 2301 |
1623593 | 1623593 | 2021-08-16 | Westchester | New York | 36119 | 134166 | 2301 |
1620346 | 1620346 | 2021-08-15 | Westchester | New York | 36119 | 134020 | 2300 |
1617098 | 1617098 | 2021-08-14 | Westchester | New York | 36119 | 133812 | 2300 |
1613850 | 1613850 | 2021-08-13 | Westchester | New York | 36119 | 133626 | 2300 |
1610601 | 1610601 | 2021-08-12 | Westchester | New York | 36119 | 133424 | 2298 |
1607353 | 1607353 | 2021-08-11 | Westchester | New York | 36119 | 133196 | 2298 |
1604104 | 1604104 | 2021-08-10 | Westchester | New York | 36119 | 132981 | 2298 |
1600855 | 1600855 | 2021-08-09 | Westchester | New York | 36119 | 132820 | 2298 |
1597607 | 1597607 | 2021-08-08 | Westchester | New York | 36119 | 132652 | 2298 |
1594358 | 1594358 | 2021-08-07 | Westchester | New York | 36119 | 132518 | 2298 |
1591109 | 1591109 | 2021-08-06 | Westchester | New York | 36119 | 132326 | 2297 |
1587860 | 1587860 | 2021-08-05 | Westchester | New York | 36119 | 132178 | 2297 |
1584610 | 1584610 | 2021-08-04 | Westchester | New York | 36119 | 131995 | 2297 |
1581360 | 1581360 | 2021-08-03 | Westchester | New York | 36119 | 131856 | 2296 |
1578111 | 1578111 | 2021-08-02 | Westchester | New York | 36119 | 131709 | 2296 |
1574863 | 1574863 | 2021-08-01 | Westchester | New York | 36119 | 131611 | 2296 |
1571615 | 1571615 | 2021-07-31 | Westchester | New York | 36119 | 131474 | 2296 |
1568367 | 1568367 | 2021-07-30 | Westchester | New York | 36119 | 131318 | 2296 |
1565119 | 1565119 | 2021-07-29 | Westchester | New York | 36119 | 131178 | 2296 |
1561871 | 1561871 | 2021-07-28 | Westchester | New York | 36119 | 131049 | 2296 |
1558623 | 1558623 | 2021-07-27 | Westchester | New York | 36119 | 130967 | 2295 |
1555376 | 1555376 | 2021-07-26 | Westchester | New York | 36119 | 130893 | 2295 |
1552129 | 1552129 | 2021-07-25 | Westchester | New York | 36119 | 130825 | 2295 |
1548882 | 1548882 | 2021-07-24 | Westchester | New York | 36119 | 130751 | 2295 |
1545635 | 1545635 | 2021-07-23 | Westchester | New York | 36119 | 130666 | 2295 |
1542388 | 1542388 | 2021-07-22 | Westchester | New York | 36119 | 130590 | 2295 |
1539140 | 1539140 | 2021-07-21 | Westchester | New York | 36119 | 130527 | 2295 |
1535893 | 1535893 | 2021-07-20 | Westchester | New York | 36119 | 130471 | 2295 |
1532645 | 1532645 | 2021-07-19 | Westchester | New York | 36119 | 130420 | 2295 |
1529398 | 1529398 | 2021-07-18 | Westchester | New York | 36119 | 130386 | 2295 |
1526151 | 1526151 | 2021-07-17 | Westchester | New York | 36119 | 130331 | 2295 |
1522904 | 1522904 | 2021-07-16 | Westchester | New York | 36119 | 130280 | 2294 |
1519656 | 1519656 | 2021-07-15 | Westchester | New York | 36119 | 130233 | 2294 |
1516408 | 1516408 | 2021-07-14 | Westchester | New York | 36119 | 130182 | 2293 |
1513161 | 1513161 | 2021-07-13 | Westchester | New York | 36119 | 130150 | 2293 |
1509915 | 1509915 | 2021-07-12 | Westchester | New York | 36119 | 130113 | 2293 |
1506668 | 1506668 | 2021-07-11 | Westchester | New York | 36119 | 130080 | 2293 |
1503422 | 1503422 | 2021-07-10 | Westchester | New York | 36119 | 130048 | 2293 |
1500176 | 1500176 | 2021-07-09 | Westchester | New York | 36119 | 130014 | 2293 |
1496930 | 1496930 | 2021-07-08 | Westchester | New York | 36119 | 129981 | 2293 |
1493683 | 1493683 | 2021-07-07 | Westchester | New York | 36119 | 129961 | 2293 |
1490436 | 1490436 | 2021-07-06 | Westchester | New York | 36119 | 129946 | 2293 |
1487189 | 1487189 | 2021-07-05 | Westchester | New York | 36119 | 129937 | 2293 |
1483943 | 1483943 | 2021-07-04 | Westchester | New York | 36119 | 129926 | 2293 |
1480697 | 1480697 | 2021-07-03 | Westchester | New York | 36119 | 129911 | 2293 |
1477450 | 1477450 | 2021-07-02 | Westchester | New York | 36119 | 129902 | 2293 |
1474204 | 1474204 | 2021-07-01 | Westchester | New York | 36119 | 129887 | 2293 |
1470958 | 1470958 | 2021-06-30 | Westchester | New York | 36119 | 129865 | 2293 |
1467713 | 1467713 | 2021-06-29 | Westchester | New York | 36119 | 129848 | 2293 |
1464468 | 1464468 | 2021-06-28 | Westchester | New York | 36119 | 129834 | 2293 |
1461223 | 1461223 | 2021-06-27 | Westchester | New York | 36119 | 129829 | 2293 |
1457978 | 1457978 | 2021-06-26 | Westchester | New York | 36119 | 129813 | 2292 |
1454733 | 1454733 | 2021-06-25 | Westchester | New York | 36119 | 129799 | 2292 |
1451488 | 1451488 | 2021-06-24 | Westchester | New York | 36119 | 129780 | 2292 |
1448242 | 1448242 | 2021-06-23 | Westchester | New York | 36119 | 129756 | 2292 |
1444997 | 1444997 | 2021-06-22 | Westchester | New York | 36119 | 129745 | 2291 |
1441752 | 1441752 | 2021-06-21 | Westchester | New York | 36119 | 129736 | 2291 |
1438507 | 1438507 | 2021-06-20 | Westchester | New York | 36119 | 129730 | 2291 |
1435260 | 1435260 | 2021-06-19 | Westchester | New York | 36119 | 129727 | 2291 |
1432013 | 1432013 | 2021-06-18 | Westchester | New York | 36119 | 129705 | 2291 |
1428767 | 1428767 | 2021-06-17 | Westchester | New York | 36119 | 129691 | 2291 |
1425522 | 1425522 | 2021-06-16 | Westchester | New York | 36119 | 129679 | 2291 |
1422275 | 1422275 | 2021-06-15 | Westchester | New York | 36119 | 129663 | 2291 |
1419029 | 1419029 | 2021-06-14 | Westchester | New York | 36119 | 129656 | 2290 |
1415784 | 1415784 | 2021-06-13 | Westchester | New York | 36119 | 129644 | 2289 |
1412538 | 1412538 | 2021-06-12 | Westchester | New York | 36119 | 129623 | 2288 |
1409293 | 1409293 | 2021-06-11 | Westchester | New York | 36119 | 129599 | 2286 |
1406048 | 1406048 | 2021-06-10 | Westchester | New York | 36119 | 129578 | 2286 |
1402802 | 1402802 | 2021-06-09 | Westchester | New York | 36119 | 129551 | 2286 |
1399557 | 1399557 | 2021-06-08 | Westchester | New York | 36119 | 129525 | 2285 |
1396312 | 1396312 | 2021-06-07 | Westchester | New York | 36119 | 129506 | 2285 |
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);