ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37071 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 |
---|---|---|---|---|---|---|---|
2176137 | 2176137 | 2022-02-02 | Gaston | North Carolina | 37071 | 61380 | 708 |
2172884 | 2172884 | 2022-02-01 | Gaston | North Carolina | 37071 | 61140 | 705 |
2169631 | 2169631 | 2022-01-31 | Gaston | North Carolina | 37071 | 60801 | 704 |
2166376 | 2166376 | 2022-01-30 | Gaston | North Carolina | 37071 | 59726 | 700 |
2163121 | 2163121 | 2022-01-29 | Gaston | North Carolina | 37071 | 59726 | 700 |
2159866 | 2159866 | 2022-01-28 | Gaston | North Carolina | 37071 | 59726 | 700 |
2156611 | 2156611 | 2022-01-27 | Gaston | North Carolina | 37071 | 59211 | 700 |
2153358 | 2153358 | 2022-01-26 | Gaston | North Carolina | 37071 | 58517 | 696 |
2150106 | 2150106 | 2022-01-25 | Gaston | North Carolina | 37071 | 58140 | 692 |
2146854 | 2146854 | 2022-01-24 | Gaston | North Carolina | 37071 | 57613 | 692 |
2143600 | 2143600 | 2022-01-23 | Gaston | North Carolina | 37071 | 55799 | 685 |
2140345 | 2140345 | 2022-01-22 | Gaston | North Carolina | 37071 | 55799 | 685 |
2137089 | 2137089 | 2022-01-21 | Gaston | North Carolina | 37071 | 55799 | 685 |
2133836 | 2133836 | 2022-01-20 | Gaston | North Carolina | 37071 | 55076 | 675 |
2130584 | 2130584 | 2022-01-19 | Gaston | North Carolina | 37071 | 54614 | 672 |
2127330 | 2127330 | 2022-01-18 | Gaston | North Carolina | 37071 | 54331 | 672 |
2124078 | 2124078 | 2022-01-17 | Gaston | North Carolina | 37071 | 51897 | 672 |
2120826 | 2120826 | 2022-01-16 | Gaston | North Carolina | 37071 | 51897 | 672 |
2117574 | 2117574 | 2022-01-15 | Gaston | North Carolina | 37071 | 51897 | 672 |
2114323 | 2114323 | 2022-01-14 | Gaston | North Carolina | 37071 | 51897 | 672 |
2111071 | 2111071 | 2022-01-13 | Gaston | North Carolina | 37071 | 51256 | 671 |
2107819 | 2107819 | 2022-01-12 | Gaston | North Carolina | 37071 | 50612 | 668 |
2104568 | 2104568 | 2022-01-11 | Gaston | North Carolina | 37071 | 50101 | 659 |
2101317 | 2101317 | 2022-01-10 | Gaston | North Carolina | 37071 | 49684 | 659 |
2098066 | 2098066 | 2022-01-09 | Gaston | North Carolina | 37071 | 48286 | 659 |
2094814 | 2094814 | 2022-01-08 | Gaston | North Carolina | 37071 | 48286 | 659 |
2091562 | 2091562 | 2022-01-07 | Gaston | North Carolina | 37071 | 48286 | 659 |
2088311 | 2088311 | 2022-01-06 | Gaston | North Carolina | 37071 | 47798 | 657 |
2085059 | 2085059 | 2022-01-05 | Gaston | North Carolina | 37071 | 47303 | 654 |
2081807 | 2081807 | 2022-01-04 | Gaston | North Carolina | 37071 | 46869 | 653 |
2078555 | 2078555 | 2022-01-03 | Gaston | North Carolina | 37071 | 46673 | 653 |
2075304 | 2075304 | 2022-01-02 | Gaston | North Carolina | 37071 | 45518 | 652 |
2072053 | 2072053 | 2022-01-01 | Gaston | North Carolina | 37071 | 45518 | 652 |
2068802 | 2068802 | 2021-12-31 | Gaston | North Carolina | 37071 | 45518 | 652 |
2065551 | 2065551 | 2021-12-30 | Gaston | North Carolina | 37071 | 45128 | 651 |
2062301 | 2062301 | 2021-12-29 | Gaston | North Carolina | 37071 | 44781 | 651 |
2059052 | 2059052 | 2021-12-28 | Gaston | North Carolina | 37071 | 44591 | 651 |
2055803 | 2055803 | 2021-12-27 | Gaston | North Carolina | 37071 | 43817 | 649 |
2052553 | 2052553 | 2021-12-26 | Gaston | North Carolina | 37071 | 43817 | 649 |
2049303 | 2049303 | 2021-12-25 | Gaston | North Carolina | 37071 | 43817 | 649 |
2046053 | 2046053 | 2021-12-24 | Gaston | North Carolina | 37071 | 43817 | 649 |
2042803 | 2042803 | 2021-12-23 | Gaston | North Carolina | 37071 | 43817 | 649 |
2039554 | 2039554 | 2021-12-22 | Gaston | North Carolina | 37071 | 43817 | 649 |
2036304 | 2036304 | 2021-12-21 | Gaston | North Carolina | 37071 | 43676 | 647 |
2033054 | 2033054 | 2021-12-20 | Gaston | North Carolina | 37071 | 43591 | 647 |
2029804 | 2029804 | 2021-12-19 | Gaston | North Carolina | 37071 | 43320 | 644 |
2026553 | 2026553 | 2021-12-18 | Gaston | North Carolina | 37071 | 43320 | 644 |
2023302 | 2023302 | 2021-12-17 | Gaston | North Carolina | 37071 | 43320 | 644 |
2020051 | 2020051 | 2021-12-16 | Gaston | North Carolina | 37071 | 43220 | 643 |
2016800 | 2016800 | 2021-12-15 | Gaston | North Carolina | 37071 | 43127 | 640 |
2013550 | 2013550 | 2021-12-14 | Gaston | North Carolina | 37071 | 43031 | 640 |
2010299 | 2010299 | 2021-12-13 | Gaston | North Carolina | 37071 | 42927 | 639 |
2007048 | 2007048 | 2021-12-12 | Gaston | North Carolina | 37071 | 42704 | 637 |
2003797 | 2003797 | 2021-12-11 | Gaston | North Carolina | 37071 | 42704 | 637 |
2000546 | 2000546 | 2021-12-10 | Gaston | North Carolina | 37071 | 42704 | 637 |
1997296 | 1997296 | 2021-12-09 | Gaston | North Carolina | 37071 | 42601 | 636 |
1994045 | 1994045 | 2021-12-08 | Gaston | North Carolina | 37071 | 42484 | 634 |
1990794 | 1990794 | 2021-12-07 | Gaston | North Carolina | 37071 | 42392 | 633 |
1987543 | 1987543 | 2021-12-06 | Gaston | North Carolina | 37071 | 42308 | 633 |
1984293 | 1984293 | 2021-12-05 | Gaston | North Carolina | 37071 | 42063 | 633 |
1981043 | 1981043 | 2021-12-04 | Gaston | North Carolina | 37071 | 42063 | 633 |
1977793 | 1977793 | 2021-12-03 | Gaston | North Carolina | 37071 | 42063 | 633 |
1974543 | 1974543 | 2021-12-02 | Gaston | North Carolina | 37071 | 41958 | 633 |
1971294 | 1971294 | 2021-12-01 | Gaston | North Carolina | 37071 | 41827 | 633 |
1968044 | 1968044 | 2021-11-30 | Gaston | North Carolina | 37071 | 41724 | 631 |
1964793 | 1964793 | 2021-11-29 | Gaston | North Carolina | 37071 | 41633 | 631 |
1961541 | 1961541 | 2021-11-28 | Gaston | North Carolina | 37071 | 41343 | 631 |
1958290 | 1958290 | 2021-11-27 | Gaston | North Carolina | 37071 | 41343 | 631 |
1955039 | 1955039 | 2021-11-26 | Gaston | North Carolina | 37071 | 41343 | 631 |
1951788 | 1951788 | 2021-11-25 | Gaston | North Carolina | 37071 | 41343 | 631 |
1948537 | 1948537 | 2021-11-24 | Gaston | North Carolina | 37071 | 41343 | 631 |
1945286 | 1945286 | 2021-11-23 | Gaston | North Carolina | 37071 | 41292 | 630 |
1942035 | 1942035 | 2021-11-22 | Gaston | North Carolina | 37071 | 41241 | 630 |
1938785 | 1938785 | 2021-11-21 | Gaston | North Carolina | 37071 | 41057 | 630 |
1935535 | 1935535 | 2021-11-20 | Gaston | North Carolina | 37071 | 41057 | 630 |
1932285 | 1932285 | 2021-11-19 | Gaston | North Carolina | 37071 | 41057 | 630 |
1929034 | 1929034 | 2021-11-18 | Gaston | North Carolina | 37071 | 40980 | 630 |
1925784 | 1925784 | 2021-11-17 | Gaston | North Carolina | 37071 | 40885 | 629 |
1922535 | 1922535 | 2021-11-16 | Gaston | North Carolina | 37071 | 40824 | 628 |
1919285 | 1919285 | 2021-11-15 | Gaston | North Carolina | 37071 | 40766 | 628 |
1916035 | 1916035 | 2021-11-14 | Gaston | North Carolina | 37071 | 40592 | 628 |
1912785 | 1912785 | 2021-11-13 | Gaston | North Carolina | 37071 | 40592 | 628 |
1909535 | 1909535 | 2021-11-12 | Gaston | North Carolina | 37071 | 40592 | 628 |
1906286 | 1906286 | 2021-11-11 | Gaston | North Carolina | 37071 | 40456 | 627 |
1903037 | 1903037 | 2021-11-10 | Gaston | North Carolina | 37071 | 40456 | 627 |
1899787 | 1899787 | 2021-11-09 | Gaston | North Carolina | 37071 | 40386 | 626 |
1896537 | 1896537 | 2021-11-08 | Gaston | North Carolina | 37071 | 40355 | 626 |
1893287 | 1893287 | 2021-11-07 | Gaston | North Carolina | 37071 | 40243 | 624 |
1890037 | 1890037 | 2021-11-06 | Gaston | North Carolina | 37071 | 40243 | 624 |
1886787 | 1886787 | 2021-11-05 | Gaston | North Carolina | 37071 | 40243 | 624 |
1883538 | 1883538 | 2021-11-04 | Gaston | North Carolina | 37071 | 40208 | 624 |
1880289 | 1880289 | 2021-11-03 | Gaston | North Carolina | 37071 | 40167 | 624 |
1877040 | 1877040 | 2021-11-02 | Gaston | North Carolina | 37071 | 40152 | 622 |
1873791 | 1873791 | 2021-11-01 | Gaston | North Carolina | 37071 | 40131 | 622 |
1870542 | 1870542 | 2021-10-31 | Gaston | North Carolina | 37071 | 40027 | 621 |
1867293 | 1867293 | 2021-10-30 | Gaston | North Carolina | 37071 | 40027 | 621 |
1864044 | 1864044 | 2021-10-29 | Gaston | North Carolina | 37071 | 40027 | 621 |
1860795 | 1860795 | 2021-10-28 | Gaston | North Carolina | 37071 | 39978 | 621 |
1857546 | 1857546 | 2021-10-27 | Gaston | North Carolina | 37071 | 39910 | 615 |
1854297 | 1854297 | 2021-10-26 | Gaston | North Carolina | 37071 | 39877 | 615 |
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);