ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37057 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717826 | 1717826 | 2021-09-14 | Davidson | North Carolina | 37057 | 22751 | 240 |
1714578 | 1714578 | 2021-09-13 | Davidson | North Carolina | 37057 | 22639 | 237 |
1711332 | 1711332 | 2021-09-12 | Davidson | North Carolina | 37057 | 22146 | 235 |
1708085 | 1708085 | 2021-09-11 | Davidson | North Carolina | 37057 | 22146 | 235 |
1704838 | 1704838 | 2021-09-10 | Davidson | North Carolina | 37057 | 22146 | 235 |
1701588 | 1701588 | 2021-09-09 | Davidson | North Carolina | 37057 | 22060 | 234 |
1698339 | 1698339 | 2021-09-08 | Davidson | North Carolina | 37057 | 21900 | 227 |
1695091 | 1695091 | 2021-09-07 | Davidson | North Carolina | 37057 | 21758 | 226 |
1691843 | 1691843 | 2021-09-06 | Davidson | North Carolina | 37057 | 21026 | 223 |
1688593 | 1688593 | 2021-09-05 | Davidson | North Carolina | 37057 | 21026 | 223 |
1685343 | 1685343 | 2021-09-04 | Davidson | North Carolina | 37057 | 21026 | 223 |
1682092 | 1682092 | 2021-09-03 | Davidson | North Carolina | 37057 | 21026 | 223 |
1678843 | 1678843 | 2021-09-02 | Davidson | North Carolina | 37057 | 20829 | 222 |
1675595 | 1675595 | 2021-09-01 | Davidson | North Carolina | 37057 | 20599 | 218 |
1672348 | 1672348 | 2021-08-31 | Davidson | North Carolina | 37057 | 20399 | 213 |
1669100 | 1669100 | 2021-08-30 | Davidson | North Carolina | 37057 | 20235 | 213 |
1665853 | 1665853 | 2021-08-29 | Davidson | North Carolina | 37057 | 19824 | 212 |
1662605 | 1662605 | 2021-08-28 | Davidson | North Carolina | 37057 | 19824 | 212 |
1659357 | 1659357 | 2021-08-27 | Davidson | North Carolina | 37057 | 19824 | 212 |
1656108 | 1656108 | 2021-08-26 | Davidson | North Carolina | 37057 | 19654 | 212 |
1652861 | 1652861 | 2021-08-25 | Davidson | North Carolina | 37057 | 19473 | 211 |
1649613 | 1649613 | 2021-08-24 | Davidson | North Carolina | 37057 | 19372 | 211 |
1646364 | 1646364 | 2021-08-23 | Davidson | North Carolina | 37057 | 19280 | 211 |
1643115 | 1643115 | 2021-08-22 | Davidson | North Carolina | 37057 | 18982 | 210 |
1639865 | 1639865 | 2021-08-21 | Davidson | North Carolina | 37057 | 18982 | 210 |
1636615 | 1636615 | 2021-08-20 | Davidson | North Carolina | 37057 | 18982 | 210 |
1633365 | 1633365 | 2021-08-19 | Davidson | North Carolina | 37057 | 18904 | 210 |
1630118 | 1630118 | 2021-08-18 | Davidson | North Carolina | 37057 | 18789 | 210 |
1626871 | 1626871 | 2021-08-17 | Davidson | North Carolina | 37057 | 18735 | 210 |
1623624 | 1623624 | 2021-08-16 | Davidson | North Carolina | 37057 | 18652 | 210 |
1620377 | 1620377 | 2021-08-15 | Davidson | North Carolina | 37057 | 18397 | 209 |
1617129 | 1617129 | 2021-08-14 | Davidson | North Carolina | 37057 | 18397 | 209 |
1613881 | 1613881 | 2021-08-13 | Davidson | North Carolina | 37057 | 18397 | 209 |
1610632 | 1610632 | 2021-08-12 | Davidson | North Carolina | 37057 | 18273 | 209 |
1607384 | 1607384 | 2021-08-11 | Davidson | North Carolina | 37057 | 18149 | 209 |
1604135 | 1604135 | 2021-08-10 | Davidson | North Carolina | 37057 | 18089 | 206 |
1600886 | 1600886 | 2021-08-09 | Davidson | North Carolina | 37057 | 18035 | 206 |
1597638 | 1597638 | 2021-08-08 | Davidson | North Carolina | 37057 | 17787 | 206 |
1594389 | 1594389 | 2021-08-07 | Davidson | North Carolina | 37057 | 17787 | 206 |
1591140 | 1591140 | 2021-08-06 | Davidson | North Carolina | 37057 | 17787 | 206 |
1587891 | 1587891 | 2021-08-05 | Davidson | North Carolina | 37057 | 17718 | 206 |
1584641 | 1584641 | 2021-08-04 | Davidson | North Carolina | 37057 | 17630 | 206 |
1581391 | 1581391 | 2021-08-03 | Davidson | North Carolina | 37057 | 17575 | 205 |
1578142 | 1578142 | 2021-08-02 | Davidson | North Carolina | 37057 | 17545 | 205 |
1574894 | 1574894 | 2021-08-01 | Davidson | North Carolina | 37057 | 17423 | 205 |
1571646 | 1571646 | 2021-07-31 | Davidson | North Carolina | 37057 | 17423 | 205 |
1568398 | 1568398 | 2021-07-30 | Davidson | North Carolina | 37057 | 17423 | 205 |
1565150 | 1565150 | 2021-07-29 | Davidson | North Carolina | 37057 | 17381 | 204 |
1561902 | 1561902 | 2021-07-28 | Davidson | North Carolina | 37057 | 17335 | 204 |
1558654 | 1558654 | 2021-07-27 | Davidson | North Carolina | 37057 | 17296 | 203 |
1555407 | 1555407 | 2021-07-26 | Davidson | North Carolina | 37057 | 17268 | 202 |
1552160 | 1552160 | 2021-07-25 | Davidson | North Carolina | 37057 | 17177 | 201 |
1548913 | 1548913 | 2021-07-24 | Davidson | North Carolina | 37057 | 17177 | 201 |
1545666 | 1545666 | 2021-07-23 | Davidson | North Carolina | 37057 | 17177 | 201 |
1542419 | 1542419 | 2021-07-22 | Davidson | North Carolina | 37057 | 17157 | 201 |
1539171 | 1539171 | 2021-07-21 | Davidson | North Carolina | 37057 | 17138 | 201 |
1535924 | 1535924 | 2021-07-20 | Davidson | North Carolina | 37057 | 17124 | 201 |
1532676 | 1532676 | 2021-07-19 | Davidson | North Carolina | 37057 | 17117 | 201 |
1529429 | 1529429 | 2021-07-18 | Davidson | North Carolina | 37057 | 17092 | 201 |
1526182 | 1526182 | 2021-07-17 | Davidson | North Carolina | 37057 | 17092 | 201 |
1522935 | 1522935 | 2021-07-16 | Davidson | North Carolina | 37057 | 17092 | 201 |
1519687 | 1519687 | 2021-07-15 | Davidson | North Carolina | 37057 | 17083 | 201 |
1516439 | 1516439 | 2021-07-14 | Davidson | North Carolina | 37057 | 17071 | 200 |
1513192 | 1513192 | 2021-07-13 | Davidson | North Carolina | 37057 | 17065 | 200 |
1509946 | 1509946 | 2021-07-12 | Davidson | North Carolina | 37057 | 17062 | 200 |
1506699 | 1506699 | 2021-07-11 | Davidson | North Carolina | 37057 | 17048 | 200 |
1503453 | 1503453 | 2021-07-10 | Davidson | North Carolina | 37057 | 17048 | 200 |
1500207 | 1500207 | 2021-07-09 | Davidson | North Carolina | 37057 | 17048 | 200 |
1496961 | 1496961 | 2021-07-08 | Davidson | North Carolina | 37057 | 17041 | 200 |
1493714 | 1493714 | 2021-07-07 | Davidson | North Carolina | 37057 | 17052 | 200 |
1490467 | 1490467 | 2021-07-06 | Davidson | North Carolina | 37057 | 17046 | 200 |
1487220 | 1487220 | 2021-07-05 | Davidson | North Carolina | 37057 | 17032 | 197 |
1483974 | 1483974 | 2021-07-04 | Davidson | North Carolina | 37057 | 17032 | 197 |
1480728 | 1480728 | 2021-07-03 | Davidson | North Carolina | 37057 | 17032 | 197 |
1477481 | 1477481 | 2021-07-02 | Davidson | North Carolina | 37057 | 17032 | 197 |
1474235 | 1474235 | 2021-07-01 | Davidson | North Carolina | 37057 | 17034 | 197 |
1470989 | 1470989 | 2021-06-30 | Davidson | North Carolina | 37057 | 17027 | 197 |
1467744 | 1467744 | 2021-06-29 | Davidson | North Carolina | 37057 | 17026 | 197 |
1464499 | 1464499 | 2021-06-28 | Davidson | North Carolina | 37057 | 17020 | 197 |
1461254 | 1461254 | 2021-06-27 | Davidson | North Carolina | 37057 | 17014 | 198 |
1458009 | 1458009 | 2021-06-26 | Davidson | North Carolina | 37057 | 17014 | 198 |
1454764 | 1454764 | 2021-06-25 | Davidson | North Carolina | 37057 | 17014 | 198 |
1451519 | 1451519 | 2021-06-24 | Davidson | North Carolina | 37057 | 17015 | 198 |
1448273 | 1448273 | 2021-06-23 | Davidson | North Carolina | 37057 | 17010 | 198 |
1445028 | 1445028 | 2021-06-22 | Davidson | North Carolina | 37057 | 17007 | 198 |
1441783 | 1441783 | 2021-06-21 | Davidson | North Carolina | 37057 | 17004 | 198 |
1438538 | 1438538 | 2021-06-20 | Davidson | North Carolina | 37057 | 16992 | 197 |
1435291 | 1435291 | 2021-06-19 | Davidson | North Carolina | 37057 | 16992 | 197 |
1432044 | 1432044 | 2021-06-18 | Davidson | North Carolina | 37057 | 16992 | 197 |
1428798 | 1428798 | 2021-06-17 | Davidson | North Carolina | 37057 | 16986 | 197 |
1425553 | 1425553 | 2021-06-16 | Davidson | North Carolina | 37057 | 16982 | 197 |
1422306 | 1422306 | 2021-06-15 | Davidson | North Carolina | 37057 | 16972 | 196 |
1419060 | 1419060 | 2021-06-14 | Davidson | North Carolina | 37057 | 16967 | 196 |
1415815 | 1415815 | 2021-06-13 | Davidson | North Carolina | 37057 | 16951 | 196 |
1412569 | 1412569 | 2021-06-12 | Davidson | North Carolina | 37057 | 16951 | 196 |
1409324 | 1409324 | 2021-06-11 | Davidson | North Carolina | 37057 | 16951 | 196 |
1406079 | 1406079 | 2021-06-10 | Davidson | North Carolina | 37057 | 16943 | 195 |
1402833 | 1402833 | 2021-06-09 | Davidson | North Carolina | 37057 | 16939 | 194 |
1399588 | 1399588 | 2021-06-08 | Davidson | North Carolina | 37057 | 16951 | 193 |
1396343 | 1396343 | 2021-06-07 | Davidson | North Carolina | 37057 | 16940 | 193 |
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);