ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 37097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176150 | 2176150 | 2022-02-02 | Iredell | North Carolina | 37097 | 45385 | 391 |
2172897 | 2172897 | 2022-02-01 | Iredell | North Carolina | 37097 | 45096 | 391 |
2169644 | 2169644 | 2022-01-31 | Iredell | North Carolina | 37097 | 44945 | 389 |
2166389 | 2166389 | 2022-01-30 | Iredell | North Carolina | 37097 | 44239 | 383 |
2163134 | 2163134 | 2022-01-29 | Iredell | North Carolina | 37097 | 44239 | 383 |
2159879 | 2159879 | 2022-01-28 | Iredell | North Carolina | 37097 | 44239 | 383 |
2156624 | 2156624 | 2022-01-27 | Iredell | North Carolina | 37097 | 43883 | 382 |
2153371 | 2153371 | 2022-01-26 | Iredell | North Carolina | 37097 | 43573 | 382 |
2150119 | 2150119 | 2022-01-25 | Iredell | North Carolina | 37097 | 43258 | 380 |
2146867 | 2146867 | 2022-01-24 | Iredell | North Carolina | 37097 | 42947 | 380 |
2143613 | 2143613 | 2022-01-23 | Iredell | North Carolina | 37097 | 41826 | 377 |
2140358 | 2140358 | 2022-01-22 | Iredell | North Carolina | 37097 | 41826 | 377 |
2137102 | 2137102 | 2022-01-21 | Iredell | North Carolina | 37097 | 41826 | 377 |
2133849 | 2133849 | 2022-01-20 | Iredell | North Carolina | 37097 | 41160 | 376 |
2130597 | 2130597 | 2022-01-19 | Iredell | North Carolina | 37097 | 40738 | 376 |
2127343 | 2127343 | 2022-01-18 | Iredell | North Carolina | 37097 | 40472 | 376 |
2124091 | 2124091 | 2022-01-17 | Iredell | North Carolina | 37097 | 38581 | 374 |
2120839 | 2120839 | 2022-01-16 | Iredell | North Carolina | 37097 | 38581 | 374 |
2117587 | 2117587 | 2022-01-15 | Iredell | North Carolina | 37097 | 38581 | 374 |
2114336 | 2114336 | 2022-01-14 | Iredell | North Carolina | 37097 | 38581 | 374 |
2111084 | 2111084 | 2022-01-13 | Iredell | North Carolina | 37097 | 38004 | 371 |
2107832 | 2107832 | 2022-01-12 | Iredell | North Carolina | 37097 | 37564 | 370 |
2104581 | 2104581 | 2022-01-11 | Iredell | North Carolina | 37097 | 37123 | 366 |
2101330 | 2101330 | 2022-01-10 | Iredell | North Carolina | 37097 | 36851 | 366 |
2098079 | 2098079 | 2022-01-09 | Iredell | North Carolina | 37097 | 35782 | 362 |
2094827 | 2094827 | 2022-01-08 | Iredell | North Carolina | 37097 | 35782 | 362 |
2091575 | 2091575 | 2022-01-07 | Iredell | North Carolina | 37097 | 35782 | 362 |
2088324 | 2088324 | 2022-01-06 | Iredell | North Carolina | 37097 | 35328 | 361 |
2085072 | 2085072 | 2022-01-05 | Iredell | North Carolina | 37097 | 34863 | 358 |
2081820 | 2081820 | 2022-01-04 | Iredell | North Carolina | 37097 | 34491 | 358 |
2078568 | 2078568 | 2022-01-03 | Iredell | North Carolina | 37097 | 34294 | 348 |
2075317 | 2075317 | 2022-01-02 | Iredell | North Carolina | 37097 | 33546 | 348 |
2072066 | 2072066 | 2022-01-01 | Iredell | North Carolina | 37097 | 33546 | 348 |
2068815 | 2068815 | 2021-12-31 | Iredell | North Carolina | 37097 | 33546 | 348 |
2065564 | 2065564 | 2021-12-30 | Iredell | North Carolina | 37097 | 33220 | 348 |
2062314 | 2062314 | 2021-12-29 | Iredell | North Carolina | 37097 | 32897 | 348 |
2059065 | 2059065 | 2021-12-28 | Iredell | North Carolina | 37097 | 32766 | 346 |
2055816 | 2055816 | 2021-12-27 | Iredell | North Carolina | 37097 | 32137 | 342 |
2052566 | 2052566 | 2021-12-26 | Iredell | North Carolina | 37097 | 32137 | 342 |
2049316 | 2049316 | 2021-12-25 | Iredell | North Carolina | 37097 | 32137 | 342 |
2046066 | 2046066 | 2021-12-24 | Iredell | North Carolina | 37097 | 32137 | 342 |
2042816 | 2042816 | 2021-12-23 | Iredell | North Carolina | 37097 | 32137 | 342 |
2039567 | 2039567 | 2021-12-22 | Iredell | North Carolina | 37097 | 32137 | 342 |
2036317 | 2036317 | 2021-12-21 | Iredell | North Carolina | 37097 | 31992 | 338 |
2033067 | 2033067 | 2021-12-20 | Iredell | North Carolina | 37097 | 31918 | 338 |
2029817 | 2029817 | 2021-12-19 | Iredell | North Carolina | 37097 | 31680 | 338 |
2026566 | 2026566 | 2021-12-18 | Iredell | North Carolina | 37097 | 31680 | 338 |
2023315 | 2023315 | 2021-12-17 | Iredell | North Carolina | 37097 | 31680 | 338 |
2020064 | 2020064 | 2021-12-16 | Iredell | North Carolina | 37097 | 31585 | 338 |
2016813 | 2016813 | 2021-12-15 | Iredell | North Carolina | 37097 | 31479 | 336 |
2013563 | 2013563 | 2021-12-14 | Iredell | North Carolina | 37097 | 31380 | 336 |
2010312 | 2010312 | 2021-12-13 | Iredell | North Carolina | 37097 | 31316 | 336 |
2007061 | 2007061 | 2021-12-12 | Iredell | North Carolina | 37097 | 31088 | 336 |
2003810 | 2003810 | 2021-12-11 | Iredell | North Carolina | 37097 | 31088 | 336 |
2000559 | 2000559 | 2021-12-10 | Iredell | North Carolina | 37097 | 31088 | 336 |
1997309 | 1997309 | 2021-12-09 | Iredell | North Carolina | 37097 | 31010 | 336 |
1994058 | 1994058 | 2021-12-08 | Iredell | North Carolina | 37097 | 30905 | 335 |
1990807 | 1990807 | 2021-12-07 | Iredell | North Carolina | 37097 | 30816 | 335 |
1987556 | 1987556 | 2021-12-06 | Iredell | North Carolina | 37097 | 30762 | 334 |
1984306 | 1984306 | 2021-12-05 | Iredell | North Carolina | 37097 | 30546 | 334 |
1981056 | 1981056 | 2021-12-04 | Iredell | North Carolina | 37097 | 30546 | 334 |
1977806 | 1977806 | 2021-12-03 | Iredell | North Carolina | 37097 | 30546 | 334 |
1974556 | 1974556 | 2021-12-02 | Iredell | North Carolina | 37097 | 30459 | 334 |
1971307 | 1971307 | 2021-12-01 | Iredell | North Carolina | 37097 | 30356 | 333 |
1968057 | 1968057 | 2021-11-30 | Iredell | North Carolina | 37097 | 30291 | 332 |
1964806 | 1964806 | 2021-11-29 | Iredell | North Carolina | 37097 | 30231 | 332 |
1961554 | 1961554 | 2021-11-28 | Iredell | North Carolina | 37097 | 30047 | 331 |
1958303 | 1958303 | 2021-11-27 | Iredell | North Carolina | 37097 | 30047 | 331 |
1955052 | 1955052 | 2021-11-26 | Iredell | North Carolina | 37097 | 30047 | 331 |
1951801 | 1951801 | 2021-11-25 | Iredell | North Carolina | 37097 | 30047 | 331 |
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 |
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);