ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Iredell" 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 |
---|---|---|---|---|---|---|---|
1948550 | 1948550 | 2021-11-24 | Iredell | North Carolina | 37097 | 30047 | 331 |
1945299 | 1945299 | 2021-11-23 | Iredell | North Carolina | 37097 | 29972 | 331 |
1942048 | 1942048 | 2021-11-22 | Iredell | North Carolina | 37097 | 29923 | 331 |
1938798 | 1938798 | 2021-11-21 | Iredell | North Carolina | 37097 | 29791 | 331 |
1935548 | 1935548 | 2021-11-20 | Iredell | North Carolina | 37097 | 29791 | 331 |
1932298 | 1932298 | 2021-11-19 | Iredell | North Carolina | 37097 | 29791 | 331 |
1929047 | 1929047 | 2021-11-18 | Iredell | North Carolina | 37097 | 29732 | 330 |
1925797 | 1925797 | 2021-11-17 | Iredell | North Carolina | 37097 | 29663 | 330 |
1922548 | 1922548 | 2021-11-16 | Iredell | North Carolina | 37097 | 29587 | 330 |
1919298 | 1919298 | 2021-11-15 | Iredell | North Carolina | 37097 | 29535 | 330 |
1916048 | 1916048 | 2021-11-14 | Iredell | North Carolina | 37097 | 29409 | 329 |
1912798 | 1912798 | 2021-11-13 | Iredell | North Carolina | 37097 | 29409 | 329 |
1909548 | 1909548 | 2021-11-12 | Iredell | North Carolina | 37097 | 29409 | 329 |
1906299 | 1906299 | 2021-11-11 | Iredell | North Carolina | 37097 | 29272 | 328 |
1903050 | 1903050 | 2021-11-10 | Iredell | North Carolina | 37097 | 29272 | 328 |
1899800 | 1899800 | 2021-11-09 | Iredell | North Carolina | 37097 | 29240 | 327 |
1896550 | 1896550 | 2021-11-08 | Iredell | North Carolina | 37097 | 29214 | 327 |
1893300 | 1893300 | 2021-11-07 | Iredell | North Carolina | 37097 | 29117 | 326 |
1890050 | 1890050 | 2021-11-06 | Iredell | North Carolina | 37097 | 29117 | 326 |
1886800 | 1886800 | 2021-11-05 | Iredell | North Carolina | 37097 | 29117 | 326 |
1883551 | 1883551 | 2021-11-04 | Iredell | North Carolina | 37097 | 29088 | 326 |
1880302 | 1880302 | 2021-11-03 | Iredell | North Carolina | 37097 | 29049 | 326 |
1877053 | 1877053 | 2021-11-02 | Iredell | North Carolina | 37097 | 29011 | 324 |
1873804 | 1873804 | 2021-11-01 | Iredell | North Carolina | 37097 | 28979 | 324 |
1870555 | 1870555 | 2021-10-31 | Iredell | North Carolina | 37097 | 28885 | 324 |
1867306 | 1867306 | 2021-10-30 | Iredell | North Carolina | 37097 | 28885 | 324 |
1864057 | 1864057 | 2021-10-29 | Iredell | North Carolina | 37097 | 28885 | 324 |
1860808 | 1860808 | 2021-10-28 | Iredell | North Carolina | 37097 | 28838 | 323 |
1857559 | 1857559 | 2021-10-27 | Iredell | North Carolina | 37097 | 28786 | 322 |
1854310 | 1854310 | 2021-10-26 | Iredell | North Carolina | 37097 | 28726 | 321 |
1851061 | 1851061 | 2021-10-25 | Iredell | North Carolina | 37097 | 28703 | 321 |
1847811 | 1847811 | 2021-10-24 | Iredell | North Carolina | 37097 | 28584 | 320 |
1844561 | 1844561 | 2021-10-23 | Iredell | North Carolina | 37097 | 28584 | 320 |
1841311 | 1841311 | 2021-10-22 | Iredell | North Carolina | 37097 | 28584 | 320 |
1838062 | 1838062 | 2021-10-21 | Iredell | North Carolina | 37097 | 28518 | 320 |
1834813 | 1834813 | 2021-10-20 | Iredell | North Carolina | 37097 | 28471 | 319 |
1831564 | 1831564 | 2021-10-19 | Iredell | North Carolina | 37097 | 28434 | 318 |
1828315 | 1828315 | 2021-10-18 | Iredell | North Carolina | 37097 | 28387 | 317 |
1825066 | 1825066 | 2021-10-17 | Iredell | North Carolina | 37097 | 28258 | 314 |
1821817 | 1821817 | 2021-10-16 | Iredell | North Carolina | 37097 | 28258 | 314 |
1818568 | 1818568 | 2021-10-15 | Iredell | North Carolina | 37097 | 28258 | 314 |
1815319 | 1815319 | 2021-10-14 | Iredell | North Carolina | 37097 | 28210 | 313 |
1812071 | 1812071 | 2021-10-13 | Iredell | North Carolina | 37097 | 28148 | 312 |
1808822 | 1808822 | 2021-10-12 | Iredell | North Carolina | 37097 | 28098 | 311 |
1805571 | 1805571 | 2021-10-11 | Iredell | North Carolina | 37097 | 28070 | 311 |
1802322 | 1802322 | 2021-10-10 | Iredell | North Carolina | 37097 | 27929 | 310 |
1799073 | 1799073 | 2021-10-09 | Iredell | North Carolina | 37097 | 27929 | 310 |
1795824 | 1795824 | 2021-10-08 | Iredell | North Carolina | 37097 | 27929 | 310 |
1792575 | 1792575 | 2021-10-07 | Iredell | North Carolina | 37097 | 27854 | 308 |
1789326 | 1789326 | 2021-10-06 | Iredell | North Carolina | 37097 | 27779 | 305 |
1786078 | 1786078 | 2021-10-05 | Iredell | North Carolina | 37097 | 27713 | 304 |
1782829 | 1782829 | 2021-10-04 | Iredell | North Carolina | 37097 | 27661 | 304 |
1779580 | 1779580 | 2021-10-03 | Iredell | North Carolina | 37097 | 27466 | 300 |
1776330 | 1776330 | 2021-10-02 | Iredell | North Carolina | 37097 | 27466 | 300 |
1773080 | 1773080 | 2021-10-01 | Iredell | North Carolina | 37097 | 27466 | 300 |
1769830 | 1769830 | 2021-09-30 | Iredell | North Carolina | 37097 | 27396 | 294 |
1766581 | 1766581 | 2021-09-29 | Iredell | North Carolina | 37097 | 27316 | 294 |
1763332 | 1763332 | 2021-09-28 | Iredell | North Carolina | 37097 | 27199 | 293 |
1760083 | 1760083 | 2021-09-27 | Iredell | North Carolina | 37097 | 27123 | 293 |
1756835 | 1756835 | 2021-09-26 | Iredell | North Carolina | 37097 | 26849 | 289 |
1753587 | 1753587 | 2021-09-25 | Iredell | North Carolina | 37097 | 26849 | 289 |
1750339 | 1750339 | 2021-09-24 | Iredell | North Carolina | 37097 | 26849 | 289 |
1747089 | 1747089 | 2021-09-23 | Iredell | North Carolina | 37097 | 26762 | 286 |
1743840 | 1743840 | 2021-09-22 | Iredell | North Carolina | 37097 | 26617 | 286 |
1740591 | 1740591 | 2021-09-21 | Iredell | North Carolina | 37097 | 26513 | 282 |
1737342 | 1737342 | 2021-09-20 | Iredell | North Carolina | 37097 | 26434 | 279 |
1734092 | 1734092 | 2021-09-19 | Iredell | North Carolina | 37097 | 26107 | 276 |
1730842 | 1730842 | 2021-09-18 | Iredell | North Carolina | 37097 | 26107 | 276 |
1727592 | 1727592 | 2021-09-17 | Iredell | North Carolina | 37097 | 26107 | 276 |
1724343 | 1724343 | 2021-09-16 | Iredell | North Carolina | 37097 | 25891 | 274 |
1721094 | 1721094 | 2021-09-15 | Iredell | North Carolina | 37097 | 25758 | 272 |
1717846 | 1717846 | 2021-09-14 | Iredell | North Carolina | 37097 | 25566 | 271 |
1714598 | 1714598 | 2021-09-13 | Iredell | North Carolina | 37097 | 25435 | 268 |
1711352 | 1711352 | 2021-09-12 | Iredell | North Carolina | 37097 | 24780 | 265 |
1708105 | 1708105 | 2021-09-11 | Iredell | North Carolina | 37097 | 24780 | 265 |
1704858 | 1704858 | 2021-09-10 | Iredell | North Carolina | 37097 | 24780 | 265 |
1701608 | 1701608 | 2021-09-09 | Iredell | North Carolina | 37097 | 24585 | 263 |
1698359 | 1698359 | 2021-09-08 | Iredell | North Carolina | 37097 | 24440 | 259 |
1695111 | 1695111 | 2021-09-07 | Iredell | North Carolina | 37097 | 24316 | 259 |
1691863 | 1691863 | 2021-09-06 | Iredell | North Carolina | 37097 | 23800 | 254 |
1688613 | 1688613 | 2021-09-05 | Iredell | North Carolina | 37097 | 23800 | 254 |
1685363 | 1685363 | 2021-09-04 | Iredell | North Carolina | 37097 | 23800 | 254 |
1682112 | 1682112 | 2021-09-03 | Iredell | North Carolina | 37097 | 23800 | 254 |
1678863 | 1678863 | 2021-09-02 | Iredell | North Carolina | 37097 | 23645 | 254 |
1675615 | 1675615 | 2021-09-01 | Iredell | North Carolina | 37097 | 23409 | 252 |
1672368 | 1672368 | 2021-08-31 | Iredell | North Carolina | 37097 | 23261 | 248 |
1669120 | 1669120 | 2021-08-30 | Iredell | North Carolina | 37097 | 23142 | 246 |
1665873 | 1665873 | 2021-08-29 | Iredell | North Carolina | 37097 | 22730 | 245 |
1662625 | 1662625 | 2021-08-28 | Iredell | North Carolina | 37097 | 22730 | 245 |
1659377 | 1659377 | 2021-08-27 | Iredell | North Carolina | 37097 | 22730 | 245 |
1656128 | 1656128 | 2021-08-26 | Iredell | North Carolina | 37097 | 22531 | 245 |
1652881 | 1652881 | 2021-08-25 | Iredell | North Carolina | 37097 | 22306 | 242 |
1649633 | 1649633 | 2021-08-24 | Iredell | North Carolina | 37097 | 22171 | 242 |
1646384 | 1646384 | 2021-08-23 | Iredell | North Carolina | 37097 | 22097 | 240 |
1643135 | 1643135 | 2021-08-22 | Iredell | North Carolina | 37097 | 21762 | 240 |
1639885 | 1639885 | 2021-08-21 | Iredell | North Carolina | 37097 | 21762 | 240 |
1636635 | 1636635 | 2021-08-20 | Iredell | North Carolina | 37097 | 21762 | 240 |
1633385 | 1633385 | 2021-08-19 | Iredell | North Carolina | 37097 | 21645 | 240 |
1630138 | 1630138 | 2021-08-18 | Iredell | North Carolina | 37097 | 21512 | 239 |
1626891 | 1626891 | 2021-08-17 | Iredell | North Carolina | 37097 | 21401 | 238 |
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);