ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37147 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 |
---|---|---|---|---|---|---|---|
2176175 | 2176175 | 2022-02-02 | Pitt | North Carolina | 37147 | 49427 | 146 |
2172922 | 2172922 | 2022-02-01 | Pitt | North Carolina | 37147 | 49056 | 146 |
2169669 | 2169669 | 2022-01-31 | Pitt | North Carolina | 37147 | 48951 | 146 |
2166414 | 2166414 | 2022-01-30 | Pitt | North Carolina | 37147 | 48220 | 146 |
2163159 | 2163159 | 2022-01-29 | Pitt | North Carolina | 37147 | 48220 | 146 |
2159904 | 2159904 | 2022-01-28 | Pitt | North Carolina | 37147 | 48220 | 146 |
2156649 | 2156649 | 2022-01-27 | Pitt | North Carolina | 37147 | 47679 | 146 |
2153396 | 2153396 | 2022-01-26 | Pitt | North Carolina | 37147 | 47251 | 146 |
2150144 | 2150144 | 2022-01-25 | Pitt | North Carolina | 37147 | 46822 | 146 |
2146892 | 2146892 | 2022-01-24 | Pitt | North Carolina | 37147 | 46099 | 146 |
2143638 | 2143638 | 2022-01-23 | Pitt | North Carolina | 37147 | 44600 | 146 |
2140383 | 2140383 | 2022-01-22 | Pitt | North Carolina | 37147 | 44600 | 146 |
2137127 | 2137127 | 2022-01-21 | Pitt | North Carolina | 37147 | 44600 | 146 |
2133874 | 2133874 | 2022-01-20 | Pitt | North Carolina | 37147 | 43547 | 146 |
2130622 | 2130622 | 2022-01-19 | Pitt | North Carolina | 37147 | 42710 | 146 |
2127368 | 2127368 | 2022-01-18 | Pitt | North Carolina | 37147 | 42347 | 146 |
2124116 | 2124116 | 2022-01-17 | Pitt | North Carolina | 37147 | 39709 | 146 |
2120864 | 2120864 | 2022-01-16 | Pitt | North Carolina | 37147 | 39709 | 146 |
2117612 | 2117612 | 2022-01-15 | Pitt | North Carolina | 37147 | 39709 | 146 |
2114361 | 2114361 | 2022-01-14 | Pitt | North Carolina | 37147 | 39709 | 146 |
2111109 | 2111109 | 2022-01-13 | Pitt | North Carolina | 37147 | 38793 | 146 |
2107857 | 2107857 | 2022-01-12 | Pitt | North Carolina | 37147 | 37879 | 146 |
2104606 | 2104606 | 2022-01-11 | Pitt | North Carolina | 37147 | 37306 | 146 |
2101355 | 2101355 | 2022-01-10 | Pitt | North Carolina | 37147 | 36996 | 146 |
2098104 | 2098104 | 2022-01-09 | Pitt | North Carolina | 37147 | 35532 | 146 |
2094852 | 2094852 | 2022-01-08 | Pitt | North Carolina | 37147 | 35532 | 146 |
2091600 | 2091600 | 2022-01-07 | Pitt | North Carolina | 37147 | 35532 | 146 |
2088349 | 2088349 | 2022-01-06 | Pitt | North Carolina | 37147 | 34812 | 146 |
2085097 | 2085097 | 2022-01-05 | Pitt | North Carolina | 37147 | 34421 | 146 |
2081845 | 2081845 | 2022-01-04 | Pitt | North Carolina | 37147 | 33939 | 146 |
2078593 | 2078593 | 2022-01-03 | Pitt | North Carolina | 37147 | 33681 | 146 |
2075342 | 2075342 | 2022-01-02 | Pitt | North Carolina | 37147 | 32746 | 146 |
2072091 | 2072091 | 2022-01-01 | Pitt | North Carolina | 37147 | 32746 | 146 |
2068840 | 2068840 | 2021-12-31 | Pitt | North Carolina | 37147 | 32746 | 146 |
2065589 | 2065589 | 2021-12-30 | Pitt | North Carolina | 37147 | 32335 | 146 |
2062339 | 2062339 | 2021-12-29 | Pitt | North Carolina | 37147 | 31976 | 146 |
2059090 | 2059090 | 2021-12-28 | Pitt | North Carolina | 37147 | 31969 | 146 |
2055841 | 2055841 | 2021-12-27 | Pitt | North Carolina | 37147 | 31585 | 146 |
2052591 | 2052591 | 2021-12-26 | Pitt | North Carolina | 37147 | 31585 | 146 |
2049341 | 2049341 | 2021-12-25 | Pitt | North Carolina | 37147 | 31585 | 146 |
2046091 | 2046091 | 2021-12-24 | Pitt | North Carolina | 37147 | 31585 | 146 |
2042841 | 2042841 | 2021-12-23 | Pitt | North Carolina | 37147 | 31585 | 146 |
2039592 | 2039592 | 2021-12-22 | Pitt | North Carolina | 37147 | 31585 | 146 |
2036342 | 2036342 | 2021-12-21 | Pitt | North Carolina | 37147 | 31509 | 146 |
2033092 | 2033092 | 2021-12-20 | Pitt | North Carolina | 37147 | 31471 | 146 |
2029842 | 2029842 | 2021-12-19 | Pitt | North Carolina | 37147 | 31340 | 146 |
2026591 | 2026591 | 2021-12-18 | Pitt | North Carolina | 37147 | 31340 | 146 |
2023340 | 2023340 | 2021-12-17 | Pitt | North Carolina | 37147 | 31340 | 146 |
2020089 | 2020089 | 2021-12-16 | Pitt | North Carolina | 37147 | 31282 | 146 |
2016838 | 2016838 | 2021-12-15 | Pitt | North Carolina | 37147 | 31222 | 146 |
2013588 | 2013588 | 2021-12-14 | Pitt | North Carolina | 37147 | 31153 | 146 |
2010337 | 2010337 | 2021-12-13 | Pitt | North Carolina | 37147 | 31128 | 146 |
2007086 | 2007086 | 2021-12-12 | Pitt | North Carolina | 37147 | 30942 | 146 |
2003835 | 2003835 | 2021-12-11 | Pitt | North Carolina | 37147 | 30942 | 146 |
2000584 | 2000584 | 2021-12-10 | Pitt | North Carolina | 37147 | 30942 | 146 |
1997334 | 1997334 | 2021-12-09 | Pitt | North Carolina | 37147 | 30892 | 146 |
1994083 | 1994083 | 2021-12-08 | Pitt | North Carolina | 37147 | 30819 | 146 |
1990832 | 1990832 | 2021-12-07 | Pitt | North Carolina | 37147 | 30758 | 146 |
1987581 | 1987581 | 2021-12-06 | Pitt | North Carolina | 37147 | 30711 | 146 |
1984331 | 1984331 | 2021-12-05 | Pitt | North Carolina | 37147 | 30550 | 146 |
1981081 | 1981081 | 2021-12-04 | Pitt | North Carolina | 37147 | 30550 | 146 |
1977831 | 1977831 | 2021-12-03 | Pitt | North Carolina | 37147 | 30550 | 146 |
1974581 | 1974581 | 2021-12-02 | Pitt | North Carolina | 37147 | 30499 | 146 |
1971332 | 1971332 | 2021-12-01 | Pitt | North Carolina | 37147 | 30453 | 146 |
1968082 | 1968082 | 2021-11-30 | Pitt | North Carolina | 37147 | 30407 | 146 |
1964831 | 1964831 | 2021-11-29 | Pitt | North Carolina | 37147 | 30387 | 146 |
1961579 | 1961579 | 2021-11-28 | Pitt | North Carolina | 37147 | 30292 | 146 |
1958328 | 1958328 | 2021-11-27 | Pitt | North Carolina | 37147 | 30292 | 146 |
1955077 | 1955077 | 2021-11-26 | Pitt | North Carolina | 37147 | 30292 | 146 |
1951826 | 1951826 | 2021-11-25 | Pitt | North Carolina | 37147 | 30292 | 146 |
1948575 | 1948575 | 2021-11-24 | Pitt | North Carolina | 37147 | 30292 | 146 |
1945324 | 1945324 | 2021-11-23 | Pitt | North Carolina | 37147 | 30267 | 146 |
1942073 | 1942073 | 2021-11-22 | Pitt | North Carolina | 37147 | 30254 | 146 |
1938823 | 1938823 | 2021-11-21 | Pitt | North Carolina | 37147 | 30195 | 146 |
1935573 | 1935573 | 2021-11-20 | Pitt | North Carolina | 37147 | 30195 | 146 |
1932323 | 1932323 | 2021-11-19 | Pitt | North Carolina | 37147 | 30195 | 146 |
1929072 | 1929072 | 2021-11-18 | Pitt | North Carolina | 37147 | 30147 | 146 |
1925822 | 1925822 | 2021-11-17 | Pitt | North Carolina | 37147 | 30107 | 143 |
1922573 | 1922573 | 2021-11-16 | Pitt | North Carolina | 37147 | 30086 | 143 |
1919323 | 1919323 | 2021-11-15 | Pitt | North Carolina | 37147 | 30072 | 143 |
1916073 | 1916073 | 2021-11-14 | Pitt | North Carolina | 37147 | 30032 | 143 |
1912823 | 1912823 | 2021-11-13 | Pitt | North Carolina | 37147 | 30032 | 143 |
1909573 | 1909573 | 2021-11-12 | Pitt | North Carolina | 37147 | 30032 | 143 |
1906324 | 1906324 | 2021-11-11 | Pitt | North Carolina | 37147 | 29970 | 143 |
1903075 | 1903075 | 2021-11-10 | Pitt | North Carolina | 37147 | 29970 | 143 |
1899825 | 1899825 | 2021-11-09 | Pitt | North Carolina | 37147 | 29913 | 143 |
1896575 | 1896575 | 2021-11-08 | Pitt | North Carolina | 37147 | 29910 | 143 |
1893325 | 1893325 | 2021-11-07 | Pitt | North Carolina | 37147 | 29871 | 143 |
1890075 | 1890075 | 2021-11-06 | Pitt | North Carolina | 37147 | 29871 | 143 |
1886825 | 1886825 | 2021-11-05 | Pitt | North Carolina | 37147 | 29871 | 143 |
1883576 | 1883576 | 2021-11-04 | Pitt | North Carolina | 37147 | 29846 | 143 |
1880327 | 1880327 | 2021-11-03 | Pitt | North Carolina | 37147 | 29823 | 143 |
1877078 | 1877078 | 2021-11-02 | Pitt | North Carolina | 37147 | 29786 | 143 |
1873829 | 1873829 | 2021-11-01 | Pitt | North Carolina | 37147 | 29770 | 143 |
1870580 | 1870580 | 2021-10-31 | Pitt | North Carolina | 37147 | 29706 | 143 |
1867331 | 1867331 | 2021-10-30 | Pitt | North Carolina | 37147 | 29706 | 143 |
1864082 | 1864082 | 2021-10-29 | Pitt | North Carolina | 37147 | 29706 | 143 |
1860833 | 1860833 | 2021-10-28 | Pitt | North Carolina | 37147 | 29672 | 143 |
1857584 | 1857584 | 2021-10-27 | Pitt | North Carolina | 37147 | 29609 | 143 |
1854335 | 1854335 | 2021-10-26 | Pitt | North Carolina | 37147 | 29550 | 143 |
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);