ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 37039 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 |
---|---|---|---|---|---|---|---|
1812042 | 1812042 | 2021-10-13 | Cherokee | North Carolina | 37039 | 4592 | 74 |
1808793 | 1808793 | 2021-10-12 | Cherokee | North Carolina | 37039 | 4579 | 74 |
1805542 | 1805542 | 2021-10-11 | Cherokee | North Carolina | 37039 | 4563 | 74 |
1802293 | 1802293 | 2021-10-10 | Cherokee | North Carolina | 37039 | 4537 | 74 |
1799044 | 1799044 | 2021-10-09 | Cherokee | North Carolina | 37039 | 4537 | 74 |
1795795 | 1795795 | 2021-10-08 | Cherokee | North Carolina | 37039 | 4537 | 74 |
1792546 | 1792546 | 2021-10-07 | Cherokee | North Carolina | 37039 | 4532 | 74 |
1789297 | 1789297 | 2021-10-06 | Cherokee | North Carolina | 37039 | 4520 | 73 |
1786049 | 1786049 | 2021-10-05 | Cherokee | North Carolina | 37039 | 4511 | 71 |
1782800 | 1782800 | 2021-10-04 | Cherokee | North Carolina | 37039 | 4504 | 71 |
1779551 | 1779551 | 2021-10-03 | Cherokee | North Carolina | 37039 | 4467 | 69 |
1776301 | 1776301 | 2021-10-02 | Cherokee | North Carolina | 37039 | 4467 | 69 |
1773051 | 1773051 | 2021-10-01 | Cherokee | North Carolina | 37039 | 4467 | 69 |
1769801 | 1769801 | 2021-09-30 | Cherokee | North Carolina | 37039 | 4459 | 68 |
1766552 | 1766552 | 2021-09-29 | Cherokee | North Carolina | 37039 | 4453 | 68 |
1763303 | 1763303 | 2021-09-28 | Cherokee | North Carolina | 37039 | 4428 | 67 |
1760054 | 1760054 | 2021-09-27 | Cherokee | North Carolina | 37039 | 4414 | 61 |
1756806 | 1756806 | 2021-09-26 | Cherokee | North Carolina | 37039 | 4386 | 61 |
1753558 | 1753558 | 2021-09-25 | Cherokee | North Carolina | 37039 | 4386 | 61 |
1750310 | 1750310 | 2021-09-24 | Cherokee | North Carolina | 37039 | 4386 | 61 |
1747060 | 1747060 | 2021-09-23 | Cherokee | North Carolina | 37039 | 4368 | 61 |
1743811 | 1743811 | 2021-09-22 | Cherokee | North Carolina | 37039 | 4343 | 61 |
1740562 | 1740562 | 2021-09-21 | Cherokee | North Carolina | 37039 | 4310 | 59 |
1737313 | 1737313 | 2021-09-20 | Cherokee | North Carolina | 37039 | 4294 | 59 |
1734063 | 1734063 | 2021-09-19 | Cherokee | North Carolina | 37039 | 4212 | 59 |
1730813 | 1730813 | 2021-09-18 | Cherokee | North Carolina | 37039 | 4212 | 59 |
1727563 | 1727563 | 2021-09-17 | Cherokee | North Carolina | 37039 | 4212 | 59 |
1724314 | 1724314 | 2021-09-16 | Cherokee | North Carolina | 37039 | 4161 | 57 |
1721065 | 1721065 | 2021-09-15 | Cherokee | North Carolina | 37039 | 4136 | 55 |
1717817 | 1717817 | 2021-09-14 | Cherokee | North Carolina | 37039 | 4068 | 54 |
1714569 | 1714569 | 2021-09-13 | Cherokee | North Carolina | 37039 | 4045 | 54 |
1711323 | 1711323 | 2021-09-12 | Cherokee | North Carolina | 37039 | 3906 | 54 |
1708076 | 1708076 | 2021-09-11 | Cherokee | North Carolina | 37039 | 3906 | 54 |
1704829 | 1704829 | 2021-09-10 | Cherokee | North Carolina | 37039 | 3906 | 54 |
1701579 | 1701579 | 2021-09-09 | Cherokee | North Carolina | 37039 | 3887 | 54 |
1698330 | 1698330 | 2021-09-08 | Cherokee | North Carolina | 37039 | 3856 | 54 |
1695082 | 1695082 | 2021-09-07 | Cherokee | North Carolina | 37039 | 3841 | 50 |
1691834 | 1691834 | 2021-09-06 | Cherokee | North Carolina | 37039 | 3740 | 46 |
1688584 | 1688584 | 2021-09-05 | Cherokee | North Carolina | 37039 | 3740 | 46 |
1685334 | 1685334 | 2021-09-04 | Cherokee | North Carolina | 37039 | 3740 | 46 |
1682083 | 1682083 | 2021-09-03 | Cherokee | North Carolina | 37039 | 3740 | 46 |
1678834 | 1678834 | 2021-09-02 | Cherokee | North Carolina | 37039 | 3677 | 46 |
1675586 | 1675586 | 2021-09-01 | Cherokee | North Carolina | 37039 | 3636 | 45 |
1672339 | 1672339 | 2021-08-31 | Cherokee | North Carolina | 37039 | 3602 | 45 |
1669091 | 1669091 | 2021-08-30 | Cherokee | North Carolina | 37039 | 3575 | 39 |
1665844 | 1665844 | 2021-08-29 | Cherokee | North Carolina | 37039 | 3494 | 39 |
1662596 | 1662596 | 2021-08-28 | Cherokee | North Carolina | 37039 | 3494 | 39 |
1659348 | 1659348 | 2021-08-27 | Cherokee | North Carolina | 37039 | 3494 | 39 |
1656099 | 1656099 | 2021-08-26 | Cherokee | North Carolina | 37039 | 3438 | 39 |
1652852 | 1652852 | 2021-08-25 | Cherokee | North Carolina | 37039 | 3389 | 39 |
1649604 | 1649604 | 2021-08-24 | Cherokee | North Carolina | 37039 | 3328 | 39 |
1646355 | 1646355 | 2021-08-23 | Cherokee | North Carolina | 37039 | 3301 | 39 |
1643106 | 1643106 | 2021-08-22 | Cherokee | North Carolina | 37039 | 3193 | 39 |
1639856 | 1639856 | 2021-08-21 | Cherokee | North Carolina | 37039 | 3193 | 39 |
1636606 | 1636606 | 2021-08-20 | Cherokee | North Carolina | 37039 | 3193 | 39 |
1633356 | 1633356 | 2021-08-19 | Cherokee | North Carolina | 37039 | 3165 | 39 |
1630109 | 1630109 | 2021-08-18 | Cherokee | North Carolina | 37039 | 3144 | 39 |
1626862 | 1626862 | 2021-08-17 | Cherokee | North Carolina | 37039 | 3122 | 39 |
1623615 | 1623615 | 2021-08-16 | Cherokee | North Carolina | 37039 | 3106 | 39 |
1620368 | 1620368 | 2021-08-15 | Cherokee | North Carolina | 37039 | 3034 | 39 |
1617120 | 1617120 | 2021-08-14 | Cherokee | North Carolina | 37039 | 3034 | 39 |
1613872 | 1613872 | 2021-08-13 | Cherokee | North Carolina | 37039 | 3034 | 39 |
1610623 | 1610623 | 2021-08-12 | Cherokee | North Carolina | 37039 | 2999 | 39 |
1607375 | 1607375 | 2021-08-11 | Cherokee | North Carolina | 37039 | 2980 | 39 |
1604126 | 1604126 | 2021-08-10 | Cherokee | North Carolina | 37039 | 2920 | 39 |
1600877 | 1600877 | 2021-08-09 | Cherokee | North Carolina | 37039 | 2909 | 39 |
1597629 | 1597629 | 2021-08-08 | Cherokee | North Carolina | 37039 | 2831 | 39 |
1594380 | 1594380 | 2021-08-07 | Cherokee | North Carolina | 37039 | 2831 | 39 |
1591131 | 1591131 | 2021-08-06 | Cherokee | North Carolina | 37039 | 2831 | 39 |
1587882 | 1587882 | 2021-08-05 | Cherokee | North Carolina | 37039 | 2808 | 39 |
1584632 | 1584632 | 2021-08-04 | Cherokee | North Carolina | 37039 | 2790 | 39 |
1581382 | 1581382 | 2021-08-03 | Cherokee | North Carolina | 37039 | 2779 | 39 |
1578133 | 1578133 | 2021-08-02 | Cherokee | North Carolina | 37039 | 2775 | 39 |
1574885 | 1574885 | 2021-08-01 | Cherokee | North Carolina | 37039 | 2742 | 39 |
1571637 | 1571637 | 2021-07-31 | Cherokee | North Carolina | 37039 | 2742 | 39 |
1568389 | 1568389 | 2021-07-30 | Cherokee | North Carolina | 37039 | 2742 | 39 |
1565141 | 1565141 | 2021-07-29 | Cherokee | North Carolina | 37039 | 2735 | 39 |
1561893 | 1561893 | 2021-07-28 | Cherokee | North Carolina | 37039 | 2725 | 39 |
1558645 | 1558645 | 2021-07-27 | Cherokee | North Carolina | 37039 | 2718 | 39 |
1555398 | 1555398 | 2021-07-26 | Cherokee | North Carolina | 37039 | 2714 | 39 |
1552151 | 1552151 | 2021-07-25 | Cherokee | North Carolina | 37039 | 2704 | 39 |
1548904 | 1548904 | 2021-07-24 | Cherokee | North Carolina | 37039 | 2704 | 39 |
1545657 | 1545657 | 2021-07-23 | Cherokee | North Carolina | 37039 | 2704 | 39 |
1542410 | 1542410 | 2021-07-22 | Cherokee | North Carolina | 37039 | 2694 | 39 |
1539162 | 1539162 | 2021-07-21 | Cherokee | North Carolina | 37039 | 2692 | 39 |
1535915 | 1535915 | 2021-07-20 | Cherokee | North Carolina | 37039 | 2691 | 39 |
1532667 | 1532667 | 2021-07-19 | Cherokee | North Carolina | 37039 | 2687 | 39 |
1529420 | 1529420 | 2021-07-18 | Cherokee | North Carolina | 37039 | 2676 | 39 |
1526173 | 1526173 | 2021-07-17 | Cherokee | North Carolina | 37039 | 2676 | 39 |
1522926 | 1522926 | 2021-07-16 | Cherokee | North Carolina | 37039 | 2676 | 39 |
1519678 | 1519678 | 2021-07-15 | Cherokee | North Carolina | 37039 | 2669 | 39 |
1516430 | 1516430 | 2021-07-14 | Cherokee | North Carolina | 37039 | 2665 | 39 |
1513183 | 1513183 | 2021-07-13 | Cherokee | North Carolina | 37039 | 2660 | 38 |
1509937 | 1509937 | 2021-07-12 | Cherokee | North Carolina | 37039 | 2656 | 38 |
1506690 | 1506690 | 2021-07-11 | Cherokee | North Carolina | 37039 | 2655 | 38 |
1503444 | 1503444 | 2021-07-10 | Cherokee | North Carolina | 37039 | 2655 | 38 |
1500198 | 1500198 | 2021-07-09 | Cherokee | North Carolina | 37039 | 2655 | 38 |
1496952 | 1496952 | 2021-07-08 | Cherokee | North Carolina | 37039 | 2648 | 38 |
1493705 | 1493705 | 2021-07-07 | Cherokee | North Carolina | 37039 | 2647 | 38 |
1490458 | 1490458 | 2021-07-06 | Cherokee | North Carolina | 37039 | 2643 | 38 |
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);