ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Lee" 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 |
---|---|---|---|---|---|---|---|
2176154 | 2176154 | 2022-02-02 | Lee | North Carolina | 37105 | 15142 | 129 |
2172901 | 2172901 | 2022-02-01 | Lee | North Carolina | 37105 | 15103 | 129 |
2169648 | 2169648 | 2022-01-31 | Lee | North Carolina | 37105 | 15064 | 129 |
2166393 | 2166393 | 2022-01-30 | Lee | North Carolina | 37105 | 14737 | 129 |
2163138 | 2163138 | 2022-01-29 | Lee | North Carolina | 37105 | 14737 | 129 |
2159883 | 2159883 | 2022-01-28 | Lee | North Carolina | 37105 | 14737 | 129 |
2156628 | 2156628 | 2022-01-27 | Lee | North Carolina | 37105 | 14651 | 129 |
2153375 | 2153375 | 2022-01-26 | Lee | North Carolina | 37105 | 14530 | 128 |
2150123 | 2150123 | 2022-01-25 | Lee | North Carolina | 37105 | 14419 | 128 |
2146871 | 2146871 | 2022-01-24 | Lee | North Carolina | 37105 | 14261 | 128 |
2143617 | 2143617 | 2022-01-23 | Lee | North Carolina | 37105 | 13645 | 128 |
2140362 | 2140362 | 2022-01-22 | Lee | North Carolina | 37105 | 13645 | 128 |
2137106 | 2137106 | 2022-01-21 | Lee | North Carolina | 37105 | 13645 | 128 |
2133853 | 2133853 | 2022-01-20 | Lee | North Carolina | 37105 | 13307 | 125 |
2130601 | 2130601 | 2022-01-19 | Lee | North Carolina | 37105 | 13150 | 125 |
2127347 | 2127347 | 2022-01-18 | Lee | North Carolina | 37105 | 12953 | 125 |
2124095 | 2124095 | 2022-01-17 | Lee | North Carolina | 37105 | 12111 | 125 |
2120843 | 2120843 | 2022-01-16 | Lee | North Carolina | 37105 | 12111 | 125 |
2117591 | 2117591 | 2022-01-15 | Lee | North Carolina | 37105 | 12111 | 125 |
2114340 | 2114340 | 2022-01-14 | Lee | North Carolina | 37105 | 12111 | 125 |
2111088 | 2111088 | 2022-01-13 | Lee | North Carolina | 37105 | 11924 | 125 |
2107836 | 2107836 | 2022-01-12 | Lee | North Carolina | 37105 | 11741 | 121 |
2104585 | 2104585 | 2022-01-11 | Lee | North Carolina | 37105 | 11609 | 121 |
2101334 | 2101334 | 2022-01-10 | Lee | North Carolina | 37105 | 11511 | 121 |
2098083 | 2098083 | 2022-01-09 | Lee | North Carolina | 37105 | 10987 | 121 |
2094831 | 2094831 | 2022-01-08 | Lee | North Carolina | 37105 | 10987 | 121 |
2091579 | 2091579 | 2022-01-07 | Lee | North Carolina | 37105 | 10987 | 121 |
2088328 | 2088328 | 2022-01-06 | Lee | North Carolina | 37105 | 10872 | 121 |
2085076 | 2085076 | 2022-01-05 | Lee | North Carolina | 37105 | 10718 | 120 |
2081824 | 2081824 | 2022-01-04 | Lee | North Carolina | 37105 | 10658 | 120 |
2078572 | 2078572 | 2022-01-03 | Lee | North Carolina | 37105 | 10600 | 120 |
2075321 | 2075321 | 2022-01-02 | Lee | North Carolina | 37105 | 10331 | 119 |
2072070 | 2072070 | 2022-01-01 | Lee | North Carolina | 37105 | 10331 | 119 |
2068819 | 2068819 | 2021-12-31 | Lee | North Carolina | 37105 | 10331 | 119 |
2065568 | 2065568 | 2021-12-30 | Lee | North Carolina | 37105 | 10242 | 119 |
2062318 | 2062318 | 2021-12-29 | Lee | North Carolina | 37105 | 10157 | 119 |
2059069 | 2059069 | 2021-12-28 | Lee | North Carolina | 37105 | 10095 | 119 |
2055820 | 2055820 | 2021-12-27 | Lee | North Carolina | 37105 | 9987 | 116 |
2052570 | 2052570 | 2021-12-26 | Lee | North Carolina | 37105 | 9987 | 116 |
2049320 | 2049320 | 2021-12-25 | Lee | North Carolina | 37105 | 9987 | 116 |
2046070 | 2046070 | 2021-12-24 | Lee | North Carolina | 37105 | 9987 | 116 |
2042820 | 2042820 | 2021-12-23 | Lee | North Carolina | 37105 | 9987 | 116 |
2039571 | 2039571 | 2021-12-22 | Lee | North Carolina | 37105 | 9987 | 116 |
2036321 | 2036321 | 2021-12-21 | Lee | North Carolina | 37105 | 9970 | 116 |
2033071 | 2033071 | 2021-12-20 | Lee | North Carolina | 37105 | 9956 | 116 |
2029821 | 2029821 | 2021-12-19 | Lee | North Carolina | 37105 | 9892 | 115 |
2026570 | 2026570 | 2021-12-18 | Lee | North Carolina | 37105 | 9892 | 115 |
2023319 | 2023319 | 2021-12-17 | Lee | North Carolina | 37105 | 9892 | 115 |
2020068 | 2020068 | 2021-12-16 | Lee | North Carolina | 37105 | 9870 | 113 |
2016817 | 2016817 | 2021-12-15 | Lee | North Carolina | 37105 | 9847 | 113 |
2013567 | 2013567 | 2021-12-14 | Lee | North Carolina | 37105 | 9835 | 113 |
2010316 | 2010316 | 2021-12-13 | Lee | North Carolina | 37105 | 9825 | 113 |
2007065 | 2007065 | 2021-12-12 | Lee | North Carolina | 37105 | 9774 | 113 |
2003814 | 2003814 | 2021-12-11 | Lee | North Carolina | 37105 | 9774 | 113 |
2000563 | 2000563 | 2021-12-10 | Lee | North Carolina | 37105 | 9774 | 113 |
1997313 | 1997313 | 2021-12-09 | Lee | North Carolina | 37105 | 9755 | 113 |
1994062 | 1994062 | 2021-12-08 | Lee | North Carolina | 37105 | 9734 | 111 |
1990811 | 1990811 | 2021-12-07 | Lee | North Carolina | 37105 | 9718 | 111 |
1987560 | 1987560 | 2021-12-06 | Lee | North Carolina | 37105 | 9710 | 111 |
1984310 | 1984310 | 2021-12-05 | Lee | North Carolina | 37105 | 9671 | 111 |
1981060 | 1981060 | 2021-12-04 | Lee | North Carolina | 37105 | 9671 | 111 |
1977810 | 1977810 | 2021-12-03 | Lee | North Carolina | 37105 | 9671 | 111 |
1974560 | 1974560 | 2021-12-02 | Lee | North Carolina | 37105 | 9657 | 111 |
1971311 | 1971311 | 2021-12-01 | Lee | North Carolina | 37105 | 9638 | 111 |
1968061 | 1968061 | 2021-11-30 | Lee | North Carolina | 37105 | 9626 | 110 |
1964810 | 1964810 | 2021-11-29 | Lee | North Carolina | 37105 | 9618 | 110 |
1961558 | 1961558 | 2021-11-28 | Lee | North Carolina | 37105 | 9600 | 110 |
1958307 | 1958307 | 2021-11-27 | Lee | North Carolina | 37105 | 9600 | 110 |
1955056 | 1955056 | 2021-11-26 | Lee | North Carolina | 37105 | 9600 | 110 |
1951805 | 1951805 | 2021-11-25 | Lee | North Carolina | 37105 | 9600 | 110 |
1948554 | 1948554 | 2021-11-24 | Lee | North Carolina | 37105 | 9600 | 110 |
1945303 | 1945303 | 2021-11-23 | Lee | North Carolina | 37105 | 9597 | 110 |
1942052 | 1942052 | 2021-11-22 | Lee | North Carolina | 37105 | 9586 | 110 |
1938802 | 1938802 | 2021-11-21 | Lee | North Carolina | 37105 | 9570 | 110 |
1935552 | 1935552 | 2021-11-20 | Lee | North Carolina | 37105 | 9570 | 110 |
1932302 | 1932302 | 2021-11-19 | Lee | North Carolina | 37105 | 9570 | 110 |
1929051 | 1929051 | 2021-11-18 | Lee | North Carolina | 37105 | 9566 | 110 |
1925801 | 1925801 | 2021-11-17 | Lee | North Carolina | 37105 | 9562 | 110 |
1922552 | 1922552 | 2021-11-16 | Lee | North Carolina | 37105 | 9557 | 110 |
1919302 | 1919302 | 2021-11-15 | Lee | North Carolina | 37105 | 9557 | 110 |
1916052 | 1916052 | 2021-11-14 | Lee | North Carolina | 37105 | 9533 | 110 |
1912802 | 1912802 | 2021-11-13 | Lee | North Carolina | 37105 | 9533 | 110 |
1909552 | 1909552 | 2021-11-12 | Lee | North Carolina | 37105 | 9533 | 110 |
1906303 | 1906303 | 2021-11-11 | Lee | North Carolina | 37105 | 9519 | 110 |
1903054 | 1903054 | 2021-11-10 | Lee | North Carolina | 37105 | 9519 | 110 |
1899804 | 1899804 | 2021-11-09 | Lee | North Carolina | 37105 | 9515 | 110 |
1896554 | 1896554 | 2021-11-08 | Lee | North Carolina | 37105 | 9507 | 110 |
1893304 | 1893304 | 2021-11-07 | Lee | North Carolina | 37105 | 9487 | 110 |
1890054 | 1890054 | 2021-11-06 | Lee | North Carolina | 37105 | 9487 | 110 |
1886804 | 1886804 | 2021-11-05 | Lee | North Carolina | 37105 | 9487 | 110 |
1883555 | 1883555 | 2021-11-04 | Lee | North Carolina | 37105 | 9478 | 110 |
1880306 | 1880306 | 2021-11-03 | Lee | North Carolina | 37105 | 9466 | 110 |
1877057 | 1877057 | 2021-11-02 | Lee | North Carolina | 37105 | 9459 | 110 |
1873808 | 1873808 | 2021-11-01 | Lee | North Carolina | 37105 | 9453 | 110 |
1870559 | 1870559 | 2021-10-31 | Lee | North Carolina | 37105 | 9434 | 109 |
1867310 | 1867310 | 2021-10-30 | Lee | North Carolina | 37105 | 9434 | 109 |
1864061 | 1864061 | 2021-10-29 | Lee | North Carolina | 37105 | 9434 | 109 |
1860812 | 1860812 | 2021-10-28 | Lee | North Carolina | 37105 | 9419 | 109 |
1857563 | 1857563 | 2021-10-27 | Lee | North Carolina | 37105 | 9404 | 108 |
1854314 | 1854314 | 2021-10-26 | Lee | North Carolina | 37105 | 9395 | 108 |
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);