ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Warren" and fips = 37185 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176194 | 2176194 | 2022-02-02 | Warren | North Carolina | 37185 | 3956 | 38 |
2172941 | 2172941 | 2022-02-01 | Warren | North Carolina | 37185 | 3927 | 37 |
2169688 | 2169688 | 2022-01-31 | Warren | North Carolina | 37185 | 3912 | 37 |
2166433 | 2166433 | 2022-01-30 | Warren | North Carolina | 37185 | 3867 | 37 |
2163178 | 2163178 | 2022-01-29 | Warren | North Carolina | 37185 | 3867 | 37 |
2159923 | 2159923 | 2022-01-28 | Warren | North Carolina | 37185 | 3867 | 37 |
2156668 | 2156668 | 2022-01-27 | Warren | North Carolina | 37185 | 3833 | 37 |
2153415 | 2153415 | 2022-01-26 | Warren | North Carolina | 37185 | 3779 | 38 |
2150163 | 2150163 | 2022-01-25 | Warren | North Carolina | 37185 | 3745 | 38 |
2146911 | 2146911 | 2022-01-24 | Warren | North Carolina | 37185 | 3702 | 37 |
2143657 | 2143657 | 2022-01-23 | Warren | North Carolina | 37185 | 3549 | 36 |
2140402 | 2140402 | 2022-01-22 | Warren | North Carolina | 37185 | 3549 | 36 |
2137146 | 2137146 | 2022-01-21 | Warren | North Carolina | 37185 | 3549 | 36 |
2133893 | 2133893 | 2022-01-20 | Warren | North Carolina | 37185 | 3484 | 36 |
2130641 | 2130641 | 2022-01-19 | Warren | North Carolina | 37185 | 3457 | 36 |
2127387 | 2127387 | 2022-01-18 | Warren | North Carolina | 37185 | 3428 | 36 |
2124135 | 2124135 | 2022-01-17 | Warren | North Carolina | 37185 | 3266 | 36 |
2120883 | 2120883 | 2022-01-16 | Warren | North Carolina | 37185 | 3266 | 36 |
2117631 | 2117631 | 2022-01-15 | Warren | North Carolina | 37185 | 3266 | 36 |
2114380 | 2114380 | 2022-01-14 | Warren | North Carolina | 37185 | 3266 | 36 |
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 |
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);