ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pasquotank" 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 |
---|---|---|---|---|---|---|---|
2176171 | 2176171 | 2022-02-02 | Pasquotank | North Carolina | 37139 | 7507 | 111 |
2172918 | 2172918 | 2022-02-01 | Pasquotank | North Carolina | 37139 | 7472 | 111 |
2169665 | 2169665 | 2022-01-31 | Pasquotank | North Carolina | 37139 | 7465 | 111 |
2166410 | 2166410 | 2022-01-30 | Pasquotank | North Carolina | 37139 | 7360 | 111 |
2163155 | 2163155 | 2022-01-29 | Pasquotank | North Carolina | 37139 | 7360 | 111 |
2159900 | 2159900 | 2022-01-28 | Pasquotank | North Carolina | 37139 | 7360 | 111 |
2156645 | 2156645 | 2022-01-27 | Pasquotank | North Carolina | 37139 | 7325 | 111 |
2153392 | 2153392 | 2022-01-26 | Pasquotank | North Carolina | 37139 | 7263 | 111 |
2150140 | 2150140 | 2022-01-25 | Pasquotank | North Carolina | 37139 | 7213 | 111 |
2146888 | 2146888 | 2022-01-24 | Pasquotank | North Carolina | 37139 | 7173 | 111 |
2143634 | 2143634 | 2022-01-23 | Pasquotank | North Carolina | 37139 | 6935 | 111 |
2140379 | 2140379 | 2022-01-22 | Pasquotank | North Carolina | 37139 | 6935 | 111 |
2137123 | 2137123 | 2022-01-21 | Pasquotank | North Carolina | 37139 | 6935 | 111 |
2133870 | 2133870 | 2022-01-20 | Pasquotank | North Carolina | 37139 | 6869 | 111 |
2130618 | 2130618 | 2022-01-19 | Pasquotank | North Carolina | 37139 | 6824 | 111 |
2127364 | 2127364 | 2022-01-18 | Pasquotank | North Carolina | 37139 | 6796 | 111 |
2124112 | 2124112 | 2022-01-17 | Pasquotank | North Carolina | 37139 | 6596 | 111 |
2120860 | 2120860 | 2022-01-16 | Pasquotank | North Carolina | 37139 | 6596 | 111 |
2117608 | 2117608 | 2022-01-15 | Pasquotank | North Carolina | 37139 | 6596 | 111 |
2114357 | 2114357 | 2022-01-14 | Pasquotank | North Carolina | 37139 | 6596 | 111 |
2111105 | 2111105 | 2022-01-13 | Pasquotank | North Carolina | 37139 | 6534 | 111 |
2107853 | 2107853 | 2022-01-12 | Pasquotank | North Carolina | 37139 | 6465 | 111 |
2104602 | 2104602 | 2022-01-11 | Pasquotank | North Carolina | 37139 | 6422 | 111 |
2101351 | 2101351 | 2022-01-10 | Pasquotank | North Carolina | 37139 | 6382 | 111 |
2098100 | 2098100 | 2022-01-09 | Pasquotank | North Carolina | 37139 | 6180 | 111 |
2094848 | 2094848 | 2022-01-08 | Pasquotank | North Carolina | 37139 | 6180 | 111 |
2091596 | 2091596 | 2022-01-07 | Pasquotank | North Carolina | 37139 | 6180 | 111 |
2088345 | 2088345 | 2022-01-06 | Pasquotank | North Carolina | 37139 | 6093 | 111 |
2085093 | 2085093 | 2022-01-05 | Pasquotank | North Carolina | 37139 | 6032 | 111 |
2081841 | 2081841 | 2022-01-04 | Pasquotank | North Carolina | 37139 | 5987 | 111 |
2078589 | 2078589 | 2022-01-03 | Pasquotank | North Carolina | 37139 | 5961 | 110 |
2075338 | 2075338 | 2022-01-02 | Pasquotank | North Carolina | 37139 | 5859 | 110 |
2072087 | 2072087 | 2022-01-01 | Pasquotank | North Carolina | 37139 | 5859 | 110 |
2068836 | 2068836 | 2021-12-31 | Pasquotank | North Carolina | 37139 | 5859 | 110 |
2065585 | 2065585 | 2021-12-30 | Pasquotank | North Carolina | 37139 | 5830 | 110 |
2062335 | 2062335 | 2021-12-29 | Pasquotank | North Carolina | 37139 | 5785 | 110 |
2059086 | 2059086 | 2021-12-28 | Pasquotank | North Carolina | 37139 | 5768 | 110 |
2055837 | 2055837 | 2021-12-27 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2052587 | 2052587 | 2021-12-26 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2049337 | 2049337 | 2021-12-25 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2046087 | 2046087 | 2021-12-24 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2042837 | 2042837 | 2021-12-23 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2039588 | 2039588 | 2021-12-22 | Pasquotank | North Carolina | 37139 | 5730 | 110 |
2036338 | 2036338 | 2021-12-21 | Pasquotank | North Carolina | 37139 | 5717 | 110 |
2033088 | 2033088 | 2021-12-20 | Pasquotank | North Carolina | 37139 | 5710 | 110 |
2029838 | 2029838 | 2021-12-19 | Pasquotank | North Carolina | 37139 | 5693 | 110 |
2026587 | 2026587 | 2021-12-18 | Pasquotank | North Carolina | 37139 | 5693 | 110 |
2023336 | 2023336 | 2021-12-17 | Pasquotank | North Carolina | 37139 | 5693 | 110 |
2020085 | 2020085 | 2021-12-16 | Pasquotank | North Carolina | 37139 | 5671 | 110 |
2016834 | 2016834 | 2021-12-15 | Pasquotank | North Carolina | 37139 | 5662 | 110 |
2013584 | 2013584 | 2021-12-14 | Pasquotank | North Carolina | 37139 | 5656 | 110 |
2010333 | 2010333 | 2021-12-13 | Pasquotank | North Carolina | 37139 | 5654 | 110 |
2007082 | 2007082 | 2021-12-12 | Pasquotank | North Carolina | 37139 | 5627 | 110 |
2003831 | 2003831 | 2021-12-11 | Pasquotank | North Carolina | 37139 | 5627 | 110 |
2000580 | 2000580 | 2021-12-10 | Pasquotank | North Carolina | 37139 | 5627 | 110 |
1997330 | 1997330 | 2021-12-09 | Pasquotank | North Carolina | 37139 | 5615 | 110 |
1994079 | 1994079 | 2021-12-08 | Pasquotank | North Carolina | 37139 | 5608 | 110 |
1990828 | 1990828 | 2021-12-07 | Pasquotank | North Carolina | 37139 | 5598 | 108 |
1987577 | 1987577 | 2021-12-06 | Pasquotank | North Carolina | 37139 | 5593 | 108 |
1984327 | 1984327 | 2021-12-05 | Pasquotank | North Carolina | 37139 | 5568 | 108 |
1981077 | 1981077 | 2021-12-04 | Pasquotank | North Carolina | 37139 | 5568 | 108 |
1977827 | 1977827 | 2021-12-03 | Pasquotank | North Carolina | 37139 | 5568 | 108 |
1974577 | 1974577 | 2021-12-02 | Pasquotank | North Carolina | 37139 | 5559 | 108 |
1971328 | 1971328 | 2021-12-01 | Pasquotank | North Carolina | 37139 | 5539 | 108 |
1968078 | 1968078 | 2021-11-30 | Pasquotank | North Carolina | 37139 | 5523 | 108 |
1964827 | 1964827 | 2021-11-29 | Pasquotank | North Carolina | 37139 | 5519 | 108 |
1961575 | 1961575 | 2021-11-28 | Pasquotank | North Carolina | 37139 | 5492 | 108 |
1958324 | 1958324 | 2021-11-27 | Pasquotank | North Carolina | 37139 | 5492 | 108 |
1955073 | 1955073 | 2021-11-26 | Pasquotank | North Carolina | 37139 | 5492 | 108 |
1951822 | 1951822 | 2021-11-25 | Pasquotank | North Carolina | 37139 | 5492 | 108 |
1948571 | 1948571 | 2021-11-24 | Pasquotank | North Carolina | 37139 | 5492 | 108 |
1945320 | 1945320 | 2021-11-23 | Pasquotank | North Carolina | 37139 | 5484 | 108 |
1942069 | 1942069 | 2021-11-22 | Pasquotank | North Carolina | 37139 | 5479 | 107 |
1938819 | 1938819 | 2021-11-21 | Pasquotank | North Carolina | 37139 | 5459 | 107 |
1935569 | 1935569 | 2021-11-20 | Pasquotank | North Carolina | 37139 | 5459 | 107 |
1932319 | 1932319 | 2021-11-19 | Pasquotank | North Carolina | 37139 | 5459 | 107 |
1929068 | 1929068 | 2021-11-18 | Pasquotank | North Carolina | 37139 | 5451 | 106 |
1925818 | 1925818 | 2021-11-17 | Pasquotank | North Carolina | 37139 | 5438 | 106 |
1922569 | 1922569 | 2021-11-16 | Pasquotank | North Carolina | 37139 | 5429 | 105 |
1919319 | 1919319 | 2021-11-15 | Pasquotank | North Carolina | 37139 | 5423 | 105 |
1916069 | 1916069 | 2021-11-14 | Pasquotank | North Carolina | 37139 | 5408 | 105 |
1912819 | 1912819 | 2021-11-13 | Pasquotank | North Carolina | 37139 | 5408 | 105 |
1909569 | 1909569 | 2021-11-12 | Pasquotank | North Carolina | 37139 | 5408 | 105 |
1906320 | 1906320 | 2021-11-11 | Pasquotank | North Carolina | 37139 | 5391 | 105 |
1903071 | 1903071 | 2021-11-10 | Pasquotank | North Carolina | 37139 | 5391 | 105 |
1899821 | 1899821 | 2021-11-09 | Pasquotank | North Carolina | 37139 | 5379 | 105 |
1896571 | 1896571 | 2021-11-08 | Pasquotank | North Carolina | 37139 | 5365 | 105 |
1893321 | 1893321 | 2021-11-07 | Pasquotank | North Carolina | 37139 | 5327 | 104 |
1890071 | 1890071 | 2021-11-06 | Pasquotank | North Carolina | 37139 | 5327 | 104 |
1886821 | 1886821 | 2021-11-05 | Pasquotank | North Carolina | 37139 | 5327 | 104 |
1883572 | 1883572 | 2021-11-04 | Pasquotank | North Carolina | 37139 | 5317 | 104 |
1880323 | 1880323 | 2021-11-03 | Pasquotank | North Carolina | 37139 | 5303 | 104 |
1877074 | 1877074 | 2021-11-02 | Pasquotank | North Carolina | 37139 | 5279 | 104 |
1873825 | 1873825 | 2021-11-01 | Pasquotank | North Carolina | 37139 | 5274 | 104 |
1870576 | 1870576 | 2021-10-31 | Pasquotank | North Carolina | 37139 | 5249 | 103 |
1867327 | 1867327 | 2021-10-30 | Pasquotank | North Carolina | 37139 | 5249 | 103 |
1864078 | 1864078 | 2021-10-29 | Pasquotank | North Carolina | 37139 | 5249 | 103 |
1860829 | 1860829 | 2021-10-28 | Pasquotank | North Carolina | 37139 | 5238 | 102 |
1857580 | 1857580 | 2021-10-27 | Pasquotank | North Carolina | 37139 | 5227 | 101 |
1854331 | 1854331 | 2021-10-26 | Pasquotank | North Carolina | 37139 | 5219 | 101 |
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);