ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Warren" 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 |
---|---|---|---|---|---|---|---|
2111128 | 2111128 | 2022-01-13 | Warren | North Carolina | 37185 | 3212 | 36 |
2107876 | 2107876 | 2022-01-12 | Warren | North Carolina | 37185 | 3083 | 36 |
2104625 | 2104625 | 2022-01-11 | Warren | North Carolina | 37185 | 3062 | 36 |
2101374 | 2101374 | 2022-01-10 | Warren | North Carolina | 37185 | 3036 | 36 |
2098123 | 2098123 | 2022-01-09 | Warren | North Carolina | 37185 | 2935 | 36 |
2094871 | 2094871 | 2022-01-08 | Warren | North Carolina | 37185 | 2935 | 36 |
2091619 | 2091619 | 2022-01-07 | Warren | North Carolina | 37185 | 2935 | 36 |
2088368 | 2088368 | 2022-01-06 | Warren | North Carolina | 37185 | 2909 | 36 |
2085116 | 2085116 | 2022-01-05 | Warren | North Carolina | 37185 | 2888 | 36 |
2081864 | 2081864 | 2022-01-04 | Warren | North Carolina | 37185 | 2854 | 36 |
2078612 | 2078612 | 2022-01-03 | Warren | North Carolina | 37185 | 2839 | 36 |
2075361 | 2075361 | 2022-01-02 | Warren | North Carolina | 37185 | 2733 | 36 |
2072110 | 2072110 | 2022-01-01 | Warren | North Carolina | 37185 | 2733 | 36 |
2068859 | 2068859 | 2021-12-31 | Warren | North Carolina | 37185 | 2733 | 36 |
2065608 | 2065608 | 2021-12-30 | Warren | North Carolina | 37185 | 2690 | 36 |
2062358 | 2062358 | 2021-12-29 | Warren | North Carolina | 37185 | 2663 | 36 |
2059109 | 2059109 | 2021-12-28 | Warren | North Carolina | 37185 | 2651 | 36 |
2055860 | 2055860 | 2021-12-27 | Warren | North Carolina | 37185 | 2611 | 36 |
2052610 | 2052610 | 2021-12-26 | Warren | North Carolina | 37185 | 2611 | 36 |
2049360 | 2049360 | 2021-12-25 | Warren | North Carolina | 37185 | 2611 | 36 |
2046110 | 2046110 | 2021-12-24 | Warren | North Carolina | 37185 | 2611 | 36 |
2042860 | 2042860 | 2021-12-23 | Warren | North Carolina | 37185 | 2611 | 36 |
2039611 | 2039611 | 2021-12-22 | Warren | North Carolina | 37185 | 2611 | 36 |
2036361 | 2036361 | 2021-12-21 | Warren | North Carolina | 37185 | 2601 | 36 |
2033111 | 2033111 | 2021-12-20 | Warren | North Carolina | 37185 | 2598 | 36 |
2029861 | 2029861 | 2021-12-19 | Warren | North Carolina | 37185 | 2575 | 35 |
2026610 | 2026610 | 2021-12-18 | Warren | North Carolina | 37185 | 2575 | 35 |
2023359 | 2023359 | 2021-12-17 | Warren | North Carolina | 37185 | 2575 | 35 |
2020108 | 2020108 | 2021-12-16 | Warren | North Carolina | 37185 | 2558 | 34 |
2016857 | 2016857 | 2021-12-15 | Warren | North Carolina | 37185 | 2554 | 34 |
2013607 | 2013607 | 2021-12-14 | Warren | North Carolina | 37185 | 2548 | 33 |
2010356 | 2010356 | 2021-12-13 | Warren | North Carolina | 37185 | 2542 | 33 |
2007105 | 2007105 | 2021-12-12 | Warren | North Carolina | 37185 | 2521 | 33 |
2003854 | 2003854 | 2021-12-11 | Warren | North Carolina | 37185 | 2521 | 33 |
2000603 | 2000603 | 2021-12-10 | Warren | North Carolina | 37185 | 2521 | 33 |
1997353 | 1997353 | 2021-12-09 | Warren | North Carolina | 37185 | 2514 | 33 |
1994102 | 1994102 | 2021-12-08 | Warren | North Carolina | 37185 | 2506 | 33 |
1990851 | 1990851 | 2021-12-07 | Warren | North Carolina | 37185 | 2504 | 33 |
1987600 | 1987600 | 2021-12-06 | Warren | North Carolina | 37185 | 2500 | 33 |
1984350 | 1984350 | 2021-12-05 | Warren | North Carolina | 37185 | 2487 | 33 |
1981100 | 1981100 | 2021-12-04 | Warren | North Carolina | 37185 | 2487 | 33 |
1977850 | 1977850 | 2021-12-03 | Warren | North Carolina | 37185 | 2487 | 33 |
1974600 | 1974600 | 2021-12-02 | Warren | North Carolina | 37185 | 2475 | 33 |
1971351 | 1971351 | 2021-12-01 | Warren | North Carolina | 37185 | 2466 | 33 |
1968101 | 1968101 | 2021-11-30 | Warren | North Carolina | 37185 | 2464 | 33 |
1964850 | 1964850 | 2021-11-29 | Warren | North Carolina | 37185 | 2463 | 33 |
1961598 | 1961598 | 2021-11-28 | Warren | North Carolina | 37185 | 2456 | 33 |
1958347 | 1958347 | 2021-11-27 | Warren | North Carolina | 37185 | 2456 | 33 |
1955096 | 1955096 | 2021-11-26 | Warren | North Carolina | 37185 | 2456 | 33 |
1951845 | 1951845 | 2021-11-25 | Warren | North Carolina | 37185 | 2456 | 33 |
1948594 | 1948594 | 2021-11-24 | Warren | North Carolina | 37185 | 2456 | 33 |
1945343 | 1945343 | 2021-11-23 | Warren | North Carolina | 37185 | 2451 | 33 |
1942092 | 1942092 | 2021-11-22 | Warren | North Carolina | 37185 | 2452 | 33 |
1938842 | 1938842 | 2021-11-21 | Warren | North Carolina | 37185 | 2443 | 33 |
1935592 | 1935592 | 2021-11-20 | Warren | North Carolina | 37185 | 2443 | 33 |
1932342 | 1932342 | 2021-11-19 | Warren | North Carolina | 37185 | 2443 | 33 |
1929091 | 1929091 | 2021-11-18 | Warren | North Carolina | 37185 | 2443 | 33 |
1925841 | 1925841 | 2021-11-17 | Warren | North Carolina | 37185 | 2437 | 33 |
1922592 | 1922592 | 2021-11-16 | Warren | North Carolina | 37185 | 2435 | 33 |
1919342 | 1919342 | 2021-11-15 | Warren | North Carolina | 37185 | 2435 | 33 |
1916092 | 1916092 | 2021-11-14 | Warren | North Carolina | 37185 | 2430 | 33 |
1912842 | 1912842 | 2021-11-13 | Warren | North Carolina | 37185 | 2430 | 33 |
1909592 | 1909592 | 2021-11-12 | Warren | North Carolina | 37185 | 2430 | 33 |
1906343 | 1906343 | 2021-11-11 | Warren | North Carolina | 37185 | 2423 | 33 |
1903094 | 1903094 | 2021-11-10 | Warren | North Carolina | 37185 | 2423 | 33 |
1899844 | 1899844 | 2021-11-09 | Warren | North Carolina | 37185 | 2421 | 33 |
1896594 | 1896594 | 2021-11-08 | Warren | North Carolina | 37185 | 2421 | 33 |
1893344 | 1893344 | 2021-11-07 | Warren | North Carolina | 37185 | 2410 | 31 |
1890094 | 1890094 | 2021-11-06 | Warren | North Carolina | 37185 | 2410 | 31 |
1886844 | 1886844 | 2021-11-05 | Warren | North Carolina | 37185 | 2410 | 31 |
1883595 | 1883595 | 2021-11-04 | Warren | North Carolina | 37185 | 2408 | 31 |
1880346 | 1880346 | 2021-11-03 | Warren | North Carolina | 37185 | 2404 | 31 |
1877097 | 1877097 | 2021-11-02 | Warren | North Carolina | 37185 | 2398 | 31 |
1873848 | 1873848 | 2021-11-01 | Warren | North Carolina | 37185 | 2399 | 31 |
1870599 | 1870599 | 2021-10-31 | Warren | North Carolina | 37185 | 2388 | 31 |
1867350 | 1867350 | 2021-10-30 | Warren | North Carolina | 37185 | 2388 | 31 |
1864101 | 1864101 | 2021-10-29 | Warren | North Carolina | 37185 | 2388 | 31 |
1860852 | 1860852 | 2021-10-28 | Warren | North Carolina | 37185 | 2384 | 31 |
1857603 | 1857603 | 2021-10-27 | Warren | North Carolina | 37185 | 2380 | 31 |
1854354 | 1854354 | 2021-10-26 | Warren | North Carolina | 37185 | 2377 | 31 |
1851105 | 1851105 | 2021-10-25 | Warren | North Carolina | 37185 | 2375 | 31 |
1847855 | 1847855 | 2021-10-24 | Warren | North Carolina | 37185 | 2354 | 30 |
1844605 | 1844605 | 2021-10-23 | Warren | North Carolina | 37185 | 2354 | 30 |
1841355 | 1841355 | 2021-10-22 | Warren | North Carolina | 37185 | 2354 | 30 |
1838106 | 1838106 | 2021-10-21 | Warren | North Carolina | 37185 | 2347 | 29 |
1834857 | 1834857 | 2021-10-20 | Warren | North Carolina | 37185 | 2349 | 28 |
1831608 | 1831608 | 2021-10-19 | Warren | North Carolina | 37185 | 2342 | 28 |
1828359 | 1828359 | 2021-10-18 | Warren | North Carolina | 37185 | 2335 | 28 |
1825110 | 1825110 | 2021-10-17 | Warren | North Carolina | 37185 | 2322 | 28 |
1821861 | 1821861 | 2021-10-16 | Warren | North Carolina | 37185 | 2322 | 28 |
1818612 | 1818612 | 2021-10-15 | Warren | North Carolina | 37185 | 2322 | 28 |
1815363 | 1815363 | 2021-10-14 | Warren | North Carolina | 37185 | 2318 | 28 |
1812115 | 1812115 | 2021-10-13 | Warren | North Carolina | 37185 | 2314 | 28 |
1808866 | 1808866 | 2021-10-12 | Warren | North Carolina | 37185 | 2311 | 28 |
1805615 | 1805615 | 2021-10-11 | Warren | North Carolina | 37185 | 2310 | 27 |
1802366 | 1802366 | 2021-10-10 | Warren | North Carolina | 37185 | 2292 | 27 |
1799117 | 1799117 | 2021-10-09 | Warren | North Carolina | 37185 | 2292 | 27 |
1795868 | 1795868 | 2021-10-08 | Warren | North Carolina | 37185 | 2292 | 27 |
1792619 | 1792619 | 2021-10-07 | Warren | North Carolina | 37185 | 2285 | 27 |
1789370 | 1789370 | 2021-10-06 | Warren | North Carolina | 37185 | 2277 | 27 |
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);