ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37119 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 |
---|---|---|---|---|---|---|---|
1812082 | 1812082 | 2021-10-13 | Mecklenburg | North Carolina | 37119 | 154206 | 1204 |
1808833 | 1808833 | 2021-10-12 | Mecklenburg | North Carolina | 37119 | 153971 | 1192 |
1805582 | 1805582 | 2021-10-11 | Mecklenburg | North Carolina | 37119 | 153765 | 1192 |
1802333 | 1802333 | 2021-10-10 | Mecklenburg | North Carolina | 37119 | 153083 | 1188 |
1799084 | 1799084 | 2021-10-09 | Mecklenburg | North Carolina | 37119 | 153083 | 1188 |
1795835 | 1795835 | 2021-10-08 | Mecklenburg | North Carolina | 37119 | 153083 | 1188 |
1792586 | 1792586 | 2021-10-07 | Mecklenburg | North Carolina | 37119 | 152696 | 1182 |
1789337 | 1789337 | 2021-10-06 | Mecklenburg | North Carolina | 37119 | 152437 | 1177 |
1786089 | 1786089 | 2021-10-05 | Mecklenburg | North Carolina | 37119 | 152121 | 1166 |
1782840 | 1782840 | 2021-10-04 | Mecklenburg | North Carolina | 37119 | 151771 | 1167 |
1779591 | 1779591 | 2021-10-03 | Mecklenburg | North Carolina | 37119 | 150845 | 1166 |
1776341 | 1776341 | 2021-10-02 | Mecklenburg | North Carolina | 37119 | 150845 | 1166 |
1773091 | 1773091 | 2021-10-01 | Mecklenburg | North Carolina | 37119 | 150845 | 1166 |
1769841 | 1769841 | 2021-09-30 | Mecklenburg | North Carolina | 37119 | 150490 | 1162 |
1766592 | 1766592 | 2021-09-29 | Mecklenburg | North Carolina | 37119 | 150189 | 1158 |
1763343 | 1763343 | 2021-09-28 | Mecklenburg | North Carolina | 37119 | 149746 | 1150 |
1760094 | 1760094 | 2021-09-27 | Mecklenburg | North Carolina | 37119 | 149346 | 1150 |
1756846 | 1756846 | 2021-09-26 | Mecklenburg | North Carolina | 37119 | 148228 | 1143 |
1753598 | 1753598 | 2021-09-25 | Mecklenburg | North Carolina | 37119 | 148228 | 1143 |
1750350 | 1750350 | 2021-09-24 | Mecklenburg | North Carolina | 37119 | 148228 | 1143 |
1747100 | 1747100 | 2021-09-23 | Mecklenburg | North Carolina | 37119 | 147806 | 1136 |
1743851 | 1743851 | 2021-09-22 | Mecklenburg | North Carolina | 37119 | 147294 | 1128 |
1740602 | 1740602 | 2021-09-21 | Mecklenburg | North Carolina | 37119 | 146601 | 1123 |
1737353 | 1737353 | 2021-09-20 | Mecklenburg | North Carolina | 37119 | 146038 | 1123 |
1734103 | 1734103 | 2021-09-19 | Mecklenburg | North Carolina | 37119 | 144795 | 1117 |
1730853 | 1730853 | 2021-09-18 | Mecklenburg | North Carolina | 37119 | 144795 | 1117 |
1727603 | 1727603 | 2021-09-17 | Mecklenburg | North Carolina | 37119 | 144795 | 1117 |
1724354 | 1724354 | 2021-09-16 | Mecklenburg | North Carolina | 37119 | 144158 | 1106 |
1721105 | 1721105 | 2021-09-15 | Mecklenburg | North Carolina | 37119 | 143760 | 1102 |
1717857 | 1717857 | 2021-09-14 | Mecklenburg | North Carolina | 37119 | 143083 | 1093 |
1714609 | 1714609 | 2021-09-13 | Mecklenburg | North Carolina | 37119 | 142727 | 1093 |
1711363 | 1711363 | 2021-09-12 | Mecklenburg | North Carolina | 37119 | 140746 | 1083 |
1708116 | 1708116 | 2021-09-11 | Mecklenburg | North Carolina | 37119 | 140746 | 1083 |
1704869 | 1704869 | 2021-09-10 | Mecklenburg | North Carolina | 37119 | 140746 | 1083 |
1701619 | 1701619 | 2021-09-09 | Mecklenburg | North Carolina | 37119 | 140432 | 1074 |
1698370 | 1698370 | 2021-09-08 | Mecklenburg | North Carolina | 37119 | 139839 | 1067 |
1695122 | 1695122 | 2021-09-07 | Mecklenburg | North Carolina | 37119 | 139478 | 1067 |
1691874 | 1691874 | 2021-09-06 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1688624 | 1688624 | 2021-09-05 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1685374 | 1685374 | 2021-09-04 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1682123 | 1682123 | 2021-09-03 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1678874 | 1678874 | 2021-09-02 | Mecklenburg | North Carolina | 37119 | 137078 | 1056 |
1675626 | 1675626 | 2021-09-01 | Mecklenburg | North Carolina | 37119 | 136492 | 1050 |
1672379 | 1672379 | 2021-08-31 | Mecklenburg | North Carolina | 37119 | 135931 | 1050 |
1669131 | 1669131 | 2021-08-30 | Mecklenburg | North Carolina | 37119 | 135422 | 1044 |
1665884 | 1665884 | 2021-08-29 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1662636 | 1662636 | 2021-08-28 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1659388 | 1659388 | 2021-08-27 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1656139 | 1656139 | 2021-08-26 | Mecklenburg | North Carolina | 37119 | 133232 | 1030 |
1652892 | 1652892 | 2021-08-25 | Mecklenburg | North Carolina | 37119 | 132503 | 1025 |
1649644 | 1649644 | 2021-08-24 | Mecklenburg | North Carolina | 37119 | 131949 | 1019 |
1646395 | 1646395 | 2021-08-23 | Mecklenburg | North Carolina | 37119 | 131438 | 1014 |
1643146 | 1643146 | 2021-08-22 | Mecklenburg | North Carolina | 37119 | 129834 | 1012 |
1639896 | 1639896 | 2021-08-21 | Mecklenburg | North Carolina | 37119 | 129834 | 1012 |
1636646 | 1636646 | 2021-08-20 | Mecklenburg | North Carolina | 37119 | 129834 | 1012 |
1633396 | 1633396 | 2021-08-19 | Mecklenburg | North Carolina | 37119 | 129148 | 1006 |
1630149 | 1630149 | 2021-08-18 | Mecklenburg | North Carolina | 37119 | 128514 | 1005 |
1626902 | 1626902 | 2021-08-17 | Mecklenburg | North Carolina | 37119 | 128032 | 1005 |
1623655 | 1623655 | 2021-08-16 | Mecklenburg | North Carolina | 37119 | 127608 | 1005 |
1620408 | 1620408 | 2021-08-15 | Mecklenburg | North Carolina | 37119 | 126019 | 999 |
1617160 | 1617160 | 2021-08-14 | Mecklenburg | North Carolina | 37119 | 126019 | 999 |
1613912 | 1613912 | 2021-08-13 | Mecklenburg | North Carolina | 37119 | 126019 | 999 |
1610663 | 1610663 | 2021-08-12 | Mecklenburg | North Carolina | 37119 | 125408 | 996 |
1607415 | 1607415 | 2021-08-11 | Mecklenburg | North Carolina | 37119 | 124784 | 996 |
1604166 | 1604166 | 2021-08-10 | Mecklenburg | North Carolina | 37119 | 124176 | 995 |
1600917 | 1600917 | 2021-08-09 | Mecklenburg | North Carolina | 37119 | 123743 | 995 |
1597669 | 1597669 | 2021-08-08 | Mecklenburg | North Carolina | 37119 | 121988 | 994 |
1594420 | 1594420 | 2021-08-07 | Mecklenburg | North Carolina | 37119 | 121988 | 994 |
1591171 | 1591171 | 2021-08-06 | Mecklenburg | North Carolina | 37119 | 121988 | 994 |
1587922 | 1587922 | 2021-08-05 | Mecklenburg | North Carolina | 37119 | 121457 | 995 |
1584672 | 1584672 | 2021-08-04 | Mecklenburg | North Carolina | 37119 | 120955 | 995 |
1581422 | 1581422 | 2021-08-03 | Mecklenburg | North Carolina | 37119 | 120493 | 994 |
1578173 | 1578173 | 2021-08-02 | Mecklenburg | North Carolina | 37119 | 120200 | 993 |
1574925 | 1574925 | 2021-08-01 | Mecklenburg | North Carolina | 37119 | 119119 | 991 |
1571677 | 1571677 | 2021-07-31 | Mecklenburg | North Carolina | 37119 | 119119 | 991 |
1568429 | 1568429 | 2021-07-30 | Mecklenburg | North Carolina | 37119 | 119119 | 991 |
1565181 | 1565181 | 2021-07-29 | Mecklenburg | North Carolina | 37119 | 118725 | 990 |
1561933 | 1561933 | 2021-07-28 | Mecklenburg | North Carolina | 37119 | 118317 | 990 |
1558685 | 1558685 | 2021-07-27 | Mecklenburg | North Carolina | 37119 | 118004 | 988 |
1555438 | 1555438 | 2021-07-26 | Mecklenburg | North Carolina | 37119 | 117724 | 988 |
1552191 | 1552191 | 2021-07-25 | Mecklenburg | North Carolina | 37119 | 116949 | 988 |
1548944 | 1548944 | 2021-07-24 | Mecklenburg | North Carolina | 37119 | 116949 | 988 |
1545697 | 1545697 | 2021-07-23 | Mecklenburg | North Carolina | 37119 | 116949 | 988 |
1542450 | 1542450 | 2021-07-22 | Mecklenburg | North Carolina | 37119 | 116762 | 988 |
1539202 | 1539202 | 2021-07-21 | Mecklenburg | North Carolina | 37119 | 116505 | 986 |
1535955 | 1535955 | 2021-07-20 | Mecklenburg | North Carolina | 37119 | 116274 | 985 |
1532707 | 1532707 | 2021-07-19 | Mecklenburg | North Carolina | 37119 | 116154 | 985 |
1529460 | 1529460 | 2021-07-18 | Mecklenburg | North Carolina | 37119 | 115741 | 982 |
1526213 | 1526213 | 2021-07-17 | Mecklenburg | North Carolina | 37119 | 115741 | 982 |
1522966 | 1522966 | 2021-07-16 | Mecklenburg | North Carolina | 37119 | 115741 | 982 |
1519718 | 1519718 | 2021-07-15 | Mecklenburg | North Carolina | 37119 | 115621 | 982 |
1516470 | 1516470 | 2021-07-14 | Mecklenburg | North Carolina | 37119 | 115501 | 981 |
1513223 | 1513223 | 2021-07-13 | Mecklenburg | North Carolina | 37119 | 115389 | 981 |
1509977 | 1509977 | 2021-07-12 | Mecklenburg | North Carolina | 37119 | 115309 | 981 |
1506730 | 1506730 | 2021-07-11 | Mecklenburg | North Carolina | 37119 | 115088 | 980 |
1503484 | 1503484 | 2021-07-10 | Mecklenburg | North Carolina | 37119 | 115088 | 980 |
1500238 | 1500238 | 2021-07-09 | Mecklenburg | North Carolina | 37119 | 115088 | 980 |
1496992 | 1496992 | 2021-07-08 | Mecklenburg | North Carolina | 37119 | 115027 | 979 |
1493745 | 1493745 | 2021-07-07 | Mecklenburg | North Carolina | 37119 | 114974 | 978 |
1490498 | 1490498 | 2021-07-06 | Mecklenburg | North Carolina | 37119 | 114907 | 977 |
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);