ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 37083 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 |
---|---|---|---|---|---|---|---|
1717839 | 1717839 | 2021-09-14 | Halifax | North Carolina | 37083 | 6986 | 124 |
1714591 | 1714591 | 2021-09-13 | Halifax | North Carolina | 37083 | 6971 | 124 |
1711345 | 1711345 | 2021-09-12 | Halifax | North Carolina | 37083 | 6859 | 122 |
1708098 | 1708098 | 2021-09-11 | Halifax | North Carolina | 37083 | 6859 | 122 |
1704851 | 1704851 | 2021-09-10 | Halifax | North Carolina | 37083 | 6859 | 122 |
1701601 | 1701601 | 2021-09-09 | Halifax | North Carolina | 37083 | 6840 | 122 |
1698352 | 1698352 | 2021-09-08 | Halifax | North Carolina | 37083 | 6804 | 121 |
1695104 | 1695104 | 2021-09-07 | Halifax | North Carolina | 37083 | 6794 | 121 |
1691856 | 1691856 | 2021-09-06 | Halifax | North Carolina | 37083 | 6667 | 121 |
1688606 | 1688606 | 2021-09-05 | Halifax | North Carolina | 37083 | 6667 | 121 |
1685356 | 1685356 | 2021-09-04 | Halifax | North Carolina | 37083 | 6667 | 121 |
1682105 | 1682105 | 2021-09-03 | Halifax | North Carolina | 37083 | 6667 | 121 |
1678856 | 1678856 | 2021-09-02 | Halifax | North Carolina | 37083 | 6629 | 121 |
1675608 | 1675608 | 2021-09-01 | Halifax | North Carolina | 37083 | 6572 | 119 |
1672361 | 1672361 | 2021-08-31 | Halifax | North Carolina | 37083 | 6536 | 118 |
1669113 | 1669113 | 2021-08-30 | Halifax | North Carolina | 37083 | 6518 | 118 |
1665866 | 1665866 | 2021-08-29 | Halifax | North Carolina | 37083 | 6429 | 118 |
1662618 | 1662618 | 2021-08-28 | Halifax | North Carolina | 37083 | 6429 | 118 |
1659370 | 1659370 | 2021-08-27 | Halifax | North Carolina | 37083 | 6429 | 118 |
1656121 | 1656121 | 2021-08-26 | Halifax | North Carolina | 37083 | 6385 | 118 |
1652874 | 1652874 | 2021-08-25 | Halifax | North Carolina | 37083 | 6343 | 116 |
1649626 | 1649626 | 2021-08-24 | Halifax | North Carolina | 37083 | 6309 | 116 |
1646377 | 1646377 | 2021-08-23 | Halifax | North Carolina | 37083 | 6300 | 116 |
1643128 | 1643128 | 2021-08-22 | Halifax | North Carolina | 37083 | 6218 | 116 |
1639878 | 1639878 | 2021-08-21 | Halifax | North Carolina | 37083 | 6218 | 116 |
1636628 | 1636628 | 2021-08-20 | Halifax | North Carolina | 37083 | 6218 | 116 |
1633378 | 1633378 | 2021-08-19 | Halifax | North Carolina | 37083 | 6183 | 116 |
1630131 | 1630131 | 2021-08-18 | Halifax | North Carolina | 37083 | 6149 | 116 |
1626884 | 1626884 | 2021-08-17 | Halifax | North Carolina | 37083 | 6113 | 116 |
1623637 | 1623637 | 2021-08-16 | Halifax | North Carolina | 37083 | 6105 | 116 |
1620390 | 1620390 | 2021-08-15 | Halifax | North Carolina | 37083 | 6047 | 116 |
1617142 | 1617142 | 2021-08-14 | Halifax | North Carolina | 37083 | 6047 | 116 |
1613894 | 1613894 | 2021-08-13 | Halifax | North Carolina | 37083 | 6047 | 116 |
1610645 | 1610645 | 2021-08-12 | Halifax | North Carolina | 37083 | 6011 | 116 |
1607397 | 1607397 | 2021-08-11 | Halifax | North Carolina | 37083 | 5990 | 116 |
1604148 | 1604148 | 2021-08-10 | Halifax | North Carolina | 37083 | 5975 | 116 |
1600899 | 1600899 | 2021-08-09 | Halifax | North Carolina | 37083 | 5963 | 116 |
1597651 | 1597651 | 2021-08-08 | Halifax | North Carolina | 37083 | 5898 | 116 |
1594402 | 1594402 | 2021-08-07 | Halifax | North Carolina | 37083 | 5898 | 116 |
1591153 | 1591153 | 2021-08-06 | Halifax | North Carolina | 37083 | 5898 | 116 |
1587904 | 1587904 | 2021-08-05 | Halifax | North Carolina | 37083 | 5892 | 116 |
1584654 | 1584654 | 2021-08-04 | Halifax | North Carolina | 37083 | 5867 | 116 |
1581404 | 1581404 | 2021-08-03 | Halifax | North Carolina | 37083 | 5858 | 116 |
1578155 | 1578155 | 2021-08-02 | Halifax | North Carolina | 37083 | 5856 | 116 |
1574907 | 1574907 | 2021-08-01 | Halifax | North Carolina | 37083 | 5818 | 116 |
1571659 | 1571659 | 2021-07-31 | Halifax | North Carolina | 37083 | 5818 | 116 |
1568411 | 1568411 | 2021-07-30 | Halifax | North Carolina | 37083 | 5818 | 116 |
1565163 | 1565163 | 2021-07-29 | Halifax | North Carolina | 37083 | 5803 | 116 |
1561915 | 1561915 | 2021-07-28 | Halifax | North Carolina | 37083 | 5787 | 116 |
1558667 | 1558667 | 2021-07-27 | Halifax | North Carolina | 37083 | 5774 | 116 |
1555420 | 1555420 | 2021-07-26 | Halifax | North Carolina | 37083 | 5772 | 116 |
1552173 | 1552173 | 2021-07-25 | Halifax | North Carolina | 37083 | 5743 | 115 |
1548926 | 1548926 | 2021-07-24 | Halifax | North Carolina | 37083 | 5743 | 115 |
1545679 | 1545679 | 2021-07-23 | Halifax | North Carolina | 37083 | 5743 | 115 |
1542432 | 1542432 | 2021-07-22 | Halifax | North Carolina | 37083 | 5734 | 115 |
1539184 | 1539184 | 2021-07-21 | Halifax | North Carolina | 37083 | 5729 | 115 |
1535937 | 1535937 | 2021-07-20 | Halifax | North Carolina | 37083 | 5723 | 115 |
1532689 | 1532689 | 2021-07-19 | Halifax | North Carolina | 37083 | 5723 | 114 |
1529442 | 1529442 | 2021-07-18 | Halifax | North Carolina | 37083 | 5710 | 114 |
1526195 | 1526195 | 2021-07-17 | Halifax | North Carolina | 37083 | 5710 | 114 |
1522948 | 1522948 | 2021-07-16 | Halifax | North Carolina | 37083 | 5710 | 114 |
1519700 | 1519700 | 2021-07-15 | Halifax | North Carolina | 37083 | 5710 | 114 |
1516452 | 1516452 | 2021-07-14 | Halifax | North Carolina | 37083 | 5708 | 114 |
1513205 | 1513205 | 2021-07-13 | Halifax | North Carolina | 37083 | 5705 | 114 |
1509959 | 1509959 | 2021-07-12 | Halifax | North Carolina | 37083 | 5705 | 114 |
1506712 | 1506712 | 2021-07-11 | Halifax | North Carolina | 37083 | 5701 | 115 |
1503466 | 1503466 | 2021-07-10 | Halifax | North Carolina | 37083 | 5701 | 115 |
1500220 | 1500220 | 2021-07-09 | Halifax | North Carolina | 37083 | 5701 | 115 |
1496974 | 1496974 | 2021-07-08 | Halifax | North Carolina | 37083 | 5697 | 115 |
1493727 | 1493727 | 2021-07-07 | Halifax | North Carolina | 37083 | 5691 | 115 |
1490480 | 1490480 | 2021-07-06 | Halifax | North Carolina | 37083 | 5688 | 114 |
1487233 | 1487233 | 2021-07-05 | Halifax | North Carolina | 37083 | 5686 | 114 |
1483987 | 1483987 | 2021-07-04 | Halifax | North Carolina | 37083 | 5686 | 114 |
1480741 | 1480741 | 2021-07-03 | Halifax | North Carolina | 37083 | 5686 | 114 |
1477494 | 1477494 | 2021-07-02 | Halifax | North Carolina | 37083 | 5686 | 114 |
1474248 | 1474248 | 2021-07-01 | Halifax | North Carolina | 37083 | 5687 | 114 |
1471002 | 1471002 | 2021-06-30 | Halifax | North Carolina | 37083 | 5685 | 114 |
1467757 | 1467757 | 2021-06-29 | Halifax | North Carolina | 37083 | 5684 | 114 |
1464512 | 1464512 | 2021-06-28 | Halifax | North Carolina | 37083 | 5684 | 114 |
1461267 | 1461267 | 2021-06-27 | Halifax | North Carolina | 37083 | 5680 | 114 |
1458022 | 1458022 | 2021-06-26 | Halifax | North Carolina | 37083 | 5680 | 114 |
1454777 | 1454777 | 2021-06-25 | Halifax | North Carolina | 37083 | 5680 | 114 |
1451532 | 1451532 | 2021-06-24 | Halifax | North Carolina | 37083 | 5679 | 114 |
1448286 | 1448286 | 2021-06-23 | Halifax | North Carolina | 37083 | 5680 | 114 |
1445041 | 1445041 | 2021-06-22 | Halifax | North Carolina | 37083 | 5679 | 114 |
1441796 | 1441796 | 2021-06-21 | Halifax | North Carolina | 37083 | 5678 | 112 |
1438551 | 1438551 | 2021-06-20 | Halifax | North Carolina | 37083 | 5677 | 112 |
1435304 | 1435304 | 2021-06-19 | Halifax | North Carolina | 37083 | 5677 | 112 |
1432057 | 1432057 | 2021-06-18 | Halifax | North Carolina | 37083 | 5677 | 112 |
1428811 | 1428811 | 2021-06-17 | Halifax | North Carolina | 37083 | 5678 | 112 |
1425566 | 1425566 | 2021-06-16 | Halifax | North Carolina | 37083 | 5677 | 112 |
1422319 | 1422319 | 2021-06-15 | Halifax | North Carolina | 37083 | 5675 | 112 |
1419073 | 1419073 | 2021-06-14 | Halifax | North Carolina | 37083 | 5675 | 112 |
1415828 | 1415828 | 2021-06-13 | Halifax | North Carolina | 37083 | 5669 | 112 |
1412582 | 1412582 | 2021-06-12 | Halifax | North Carolina | 37083 | 5669 | 112 |
1409337 | 1409337 | 2021-06-11 | Halifax | North Carolina | 37083 | 5669 | 112 |
1406092 | 1406092 | 2021-06-10 | Halifax | North Carolina | 37083 | 5668 | 112 |
1402846 | 1402846 | 2021-06-09 | Halifax | North Carolina | 37083 | 5667 | 112 |
1399601 | 1399601 | 2021-06-08 | Halifax | North Carolina | 37083 | 5663 | 112 |
1396356 | 1396356 | 2021-06-07 | Halifax | North Carolina | 37083 | 5665 | 112 |
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);