ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

637 rows where fips = 6037 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

  • 6037 · 637 ✖

county

Link rowid date ▲ county state fips cases deaths
1842812 1842812 2021-10-23 Los Angeles California 6037 1484896 26540
1839562 1839562 2021-10-22 Los Angeles California 6037 1483735 26527
1836313 1836313 2021-10-21 Los Angeles California 6037 1482518 26506
1833064 1833064 2021-10-20 Los Angeles California 6037 1481360 26473
1829815 1829815 2021-10-19 Los Angeles California 6037 1480125 26446
1826566 1826566 2021-10-18 Los Angeles California 6037 1479326 26443
1823317 1823317 2021-10-17 Los Angeles California 6037 1478390 26414
1820068 1820068 2021-10-16 Los Angeles California 6037 1477495 26410
1816819 1816819 2021-10-15 Los Angeles California 6037 1476398 26398
1813571 1813571 2021-10-14 Los Angeles California 6037 1475222 26379
1810322 1810322 2021-10-13 Los Angeles California 6037 1474114 26362
1807073 1807073 2021-10-12 Los Angeles California 6037 1473123 26346
1803822 1803822 2021-10-11 Los Angeles California 6037 1472349 26338
1800573 1800573 2021-10-10 Los Angeles California 6037 1471533 26312
1797324 1797324 2021-10-09 Los Angeles California 6037 1470494 26308
1794075 1794075 2021-10-08 Los Angeles California 6037 1469338 26284
1790827 1790827 2021-10-07 Los Angeles California 6037 1468154 26254
1787578 1787578 2021-10-06 Los Angeles California 6037 1466952 26226
1784329 1784329 2021-10-05 Los Angeles California 6037 1465497 26195
1781080 1781080 2021-10-04 Los Angeles California 6037 1464593 26179
1777830 1777830 2021-10-03 Los Angeles California 6037 1463743 26153
1774580 1774580 2021-10-02 Los Angeles California 6037 1462717 26143
1771330 1771330 2021-10-01 Los Angeles California 6037 1461354 26126
1768081 1768081 2021-09-30 Los Angeles California 6037 1459891 26106
1764832 1764832 2021-09-29 Los Angeles California 6037 1458381 26078
1761583 1761583 2021-09-28 Los Angeles California 6037 1456984 26047
1758335 1758335 2021-09-27 Los Angeles California 6037 1455864 26035
1755087 1755087 2021-09-26 Los Angeles California 6037 1454881 26013
1751839 1751839 2021-09-25 Los Angeles California 6037 1453702 25999
1748590 1748590 2021-09-24 Los Angeles California 6037 1452147 25972
1745340 1745340 2021-09-23 Los Angeles California 6037 1450632 25942
1742091 1742091 2021-09-22 Los Angeles California 6037 1448769 25911
1738842 1738842 2021-09-21 Los Angeles California 6037 1447057 25870
1735593 1735593 2021-09-20 Los Angeles California 6037 1445830 25852
1732343 1732343 2021-09-19 Los Angeles California 6037 1444836 25849
1729093 1729093 2021-09-18 Los Angeles California 6037 1443517 25828
1725843 1725843 2021-09-17 Los Angeles California 6037 1441425 25799
1722594 1722594 2021-09-16 Los Angeles California 6037 1439720 25775
1719345 1719345 2021-09-15 Los Angeles California 6037 1437782 25748
1716097 1716097 2021-09-14 Los Angeles California 6037 1435872 25713
1712851 1712851 2021-09-13 Los Angeles California 6037 1434174 25688
1709604 1709604 2021-09-12 Los Angeles California 6037 1428526 25630
1706357 1706357 2021-09-11 Los Angeles California 6037 1428526 25630
1703109 1703109 2021-09-10 Los Angeles California 6037 1428526 25611
1699859 1699859 2021-09-09 Los Angeles California 6037 1426515 25563
1696610 1696610 2021-09-08 Los Angeles California 6037 1424329 25514
1693362 1693362 2021-09-07 Los Angeles California 6037 1422320 25477
1690113 1690113 2021-09-06 Los Angeles California 6037 1421269 25465
1686863 1686863 2021-09-05 Los Angeles California 6037 1419739 25454
1683613 1683613 2021-09-04 Los Angeles California 6037 1417628 25434
1680362 1680362 2021-09-03 Los Angeles California 6037 1415563 25401
1677114 1677114 2021-09-02 Los Angeles California 6037 1412949 25364
1673867 1673867 2021-09-01 Los Angeles California 6037 1410254 25322
1670619 1670619 2021-08-31 Los Angeles California 6037 1408026 25284
1667372 1667372 2021-08-30 Los Angeles California 6037 1406094 25263
1664125 1664125 2021-08-29 Los Angeles California 6037 1403757 25245
1660877 1660877 2021-08-28 Los Angeles California 6037 1401541 25240
1657629 1657629 2021-08-27 Los Angeles California 6037 1397943 25211
1654381 1654381 2021-08-26 Los Angeles California 6037 1395192 25181
1651134 1651134 2021-08-25 Los Angeles California 6037 1392067 25150
1647885 1647885 2021-08-24 Los Angeles California 6037 1388847 25114
1644637 1644637 2021-08-23 Los Angeles California 6037 1386207 25089
1641387 1641387 2021-08-22 Los Angeles California 6037 1383888 25080
1638137 1638137 2021-08-21 Los Angeles California 6037 1381117 25061
1634887 1634887 2021-08-20 Los Angeles California 6037 1377253 25032
1631638 1631638 2021-08-19 Los Angeles California 6037 1363550 25002
1628391 1628391 2021-08-18 Los Angeles California 6037 1360366 24967
1625144 1625144 2021-08-17 Los Angeles California 6037 1356392 24935
1621897 1621897 2021-08-16 Los Angeles California 6037 1353485 24918
1618650 1618650 2021-08-15 Los Angeles California 6037 1351064 24911
1615402 1615402 2021-08-14 Los Angeles California 6037 1347717 24892
1612153 1612153 2021-08-13 Los Angeles California 6037 1343533 24874
1608905 1608905 2021-08-12 Los Angeles California 6037 1339835 24854
1605656 1605656 2021-08-11 Los Angeles California 6037 1336029 24833
1602407 1602407 2021-08-10 Los Angeles California 6037 1332556 24805
1599158 1599158 2021-08-09 Los Angeles California 6037 1329959 24793
1595909 1595909 2021-08-08 Los Angeles California 6037 1327058 24786
1592660 1592660 2021-08-07 Los Angeles California 6037 1324042 24769
1589411 1589411 2021-08-06 Los Angeles California 6037 1319913 24756
1586162 1586162 2021-08-05 Los Angeles California 6037 1316009 24739
1582912 1582912 2021-08-04 Los Angeles California 6037 1312352 24721
1579662 1579662 2021-08-03 Los Angeles California 6037 1308666 24705
1576414 1576414 2021-08-02 Los Angeles California 6037 1306400 24700
1573166 1573166 2021-08-01 Los Angeles California 6037 1304039 24691
1569918 1569918 2021-07-31 Los Angeles California 6037 1301009 24691
1566670 1566670 2021-07-30 Los Angeles California 6037 1297728 24691
1563422 1563422 2021-07-29 Los Angeles California 6037 1294135 24675
1560174 1560174 2021-07-28 Los Angeles California 6037 1290911 24658
1556927 1556927 2021-07-27 Los Angeles California 6037 1288516 24647
1553680 1553680 2021-07-26 Los Angeles California 6037 1286456 24643
1550433 1550433 2021-07-25 Los Angeles California 6037 1284529 24628
1547186 1547186 2021-07-24 Los Angeles California 6037 1282445 24624
1543939 1543939 2021-07-23 Los Angeles California 6037 1279856 24623
1540691 1540691 2021-07-22 Los Angeles California 6037 1276818 24609
1537444 1537444 2021-07-21 Los Angeles California 6037 1274071 24603
1534196 1534196 2021-07-20 Los Angeles California 6037 1271567 24600
1530949 1530949 2021-07-19 Los Angeles California 6037 1269771 24598
1527702 1527702 2021-07-18 Los Angeles California 6037 1268541 24583
1524455 1524455 2021-07-17 Los Angeles California 6037 1266908 24582
1521207 1521207 2021-07-16 Los Angeles California 6037 1265131 24582

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);