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 |
---|---|---|---|---|---|---|---|
1948561 | 1948561 | 2021-11-24 | Mecklenburg | North Carolina | 37119 | 161567 | 1274 |
1945310 | 1945310 | 2021-11-23 | Mecklenburg | North Carolina | 37119 | 161399 | 1272 |
1942059 | 1942059 | 2021-11-22 | Mecklenburg | North Carolina | 37119 | 161218 | 1272 |
1938809 | 1938809 | 2021-11-21 | Mecklenburg | North Carolina | 37119 | 160678 | 1270 |
1935559 | 1935559 | 2021-11-20 | Mecklenburg | North Carolina | 37119 | 160678 | 1270 |
1932309 | 1932309 | 2021-11-19 | Mecklenburg | North Carolina | 37119 | 160678 | 1270 |
1929058 | 1929058 | 2021-11-18 | Mecklenburg | North Carolina | 37119 | 160433 | 1270 |
1925808 | 1925808 | 2021-11-17 | Mecklenburg | North Carolina | 37119 | 160267 | 1269 |
1922559 | 1922559 | 2021-11-16 | Mecklenburg | North Carolina | 37119 | 160063 | 1265 |
1919309 | 1919309 | 2021-11-15 | Mecklenburg | North Carolina | 37119 | 159913 | 1263 |
1916059 | 1916059 | 2021-11-14 | Mecklenburg | North Carolina | 37119 | 159425 | 1261 |
1912809 | 1912809 | 2021-11-13 | Mecklenburg | North Carolina | 37119 | 159425 | 1261 |
1909559 | 1909559 | 2021-11-12 | Mecklenburg | North Carolina | 37119 | 159425 | 1261 |
1906310 | 1906310 | 2021-11-11 | Mecklenburg | North Carolina | 37119 | 159077 | 1260 |
1903061 | 1903061 | 2021-11-10 | Mecklenburg | North Carolina | 37119 | 159077 | 1260 |
1899811 | 1899811 | 2021-11-09 | Mecklenburg | North Carolina | 37119 | 158871 | 1260 |
1896561 | 1896561 | 2021-11-08 | Mecklenburg | North Carolina | 37119 | 158689 | 1259 |
1893311 | 1893311 | 2021-11-07 | Mecklenburg | North Carolina | 37119 | 158324 | 1258 |
1890061 | 1890061 | 2021-11-06 | Mecklenburg | North Carolina | 37119 | 158324 | 1258 |
1886811 | 1886811 | 2021-11-05 | Mecklenburg | North Carolina | 37119 | 158324 | 1258 |
1883562 | 1883562 | 2021-11-04 | Mecklenburg | North Carolina | 37119 | 158157 | 1257 |
1880313 | 1880313 | 2021-11-03 | Mecklenburg | North Carolina | 37119 | 158018 | 1256 |
1877064 | 1877064 | 2021-11-02 | Mecklenburg | North Carolina | 37119 | 157865 | 1252 |
1873815 | 1873815 | 2021-11-01 | Mecklenburg | North Carolina | 37119 | 157711 | 1251 |
1870566 | 1870566 | 2021-10-31 | Mecklenburg | North Carolina | 37119 | 157260 | 1244 |
1867317 | 1867317 | 2021-10-30 | Mecklenburg | North Carolina | 37119 | 157260 | 1244 |
1864068 | 1864068 | 2021-10-29 | Mecklenburg | North Carolina | 37119 | 157260 | 1244 |
1860819 | 1860819 | 2021-10-28 | Mecklenburg | North Carolina | 37119 | 157039 | 1239 |
1857570 | 1857570 | 2021-10-27 | Mecklenburg | North Carolina | 37119 | 156828 | 1237 |
1854321 | 1854321 | 2021-10-26 | Mecklenburg | North Carolina | 37119 | 156694 | 1238 |
1851072 | 1851072 | 2021-10-25 | Mecklenburg | North Carolina | 37119 | 156529 | 1235 |
1847822 | 1847822 | 2021-10-24 | Mecklenburg | North Carolina | 37119 | 156024 | 1227 |
1844572 | 1844572 | 2021-10-23 | Mecklenburg | North Carolina | 37119 | 156024 | 1227 |
1841322 | 1841322 | 2021-10-22 | Mecklenburg | North Carolina | 37119 | 156024 | 1227 |
1838073 | 1838073 | 2021-10-21 | Mecklenburg | North Carolina | 37119 | 155881 | 1224 |
1834824 | 1834824 | 2021-10-20 | Mecklenburg | North Carolina | 37119 | 155663 | 1224 |
1831575 | 1831575 | 2021-10-19 | Mecklenburg | North Carolina | 37119 | 155457 | 1220 |
1828326 | 1828326 | 2021-10-18 | Mecklenburg | North Carolina | 37119 | 155299 | 1219 |
1825077 | 1825077 | 2021-10-17 | Mecklenburg | North Carolina | 37119 | 154718 | 1211 |
1821828 | 1821828 | 2021-10-16 | Mecklenburg | North Carolina | 37119 | 154718 | 1211 |
1818579 | 1818579 | 2021-10-15 | Mecklenburg | North Carolina | 37119 | 154718 | 1211 |
1815330 | 1815330 | 2021-10-14 | Mecklenburg | North Carolina | 37119 | 154435 | 1205 |
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 |
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);