ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Douglas" and state = "Nevada" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175963 | 2175963 | 2022-02-02 | Douglas | Nevada | 32005 | 7430 | 81 |
2172710 | 2172710 | 2022-02-01 | Douglas | Nevada | 32005 | 7394 | 81 |
2169457 | 2169457 | 2022-01-31 | Douglas | Nevada | 32005 | 7281 | 79 |
2166202 | 2166202 | 2022-01-30 | Douglas | Nevada | 32005 | 7217 | 79 |
2162947 | 2162947 | 2022-01-29 | Douglas | Nevada | 32005 | 7217 | 79 |
2159692 | 2159692 | 2022-01-28 | Douglas | Nevada | 32005 | 7217 | 79 |
2156438 | 2156438 | 2022-01-27 | Douglas | Nevada | 32005 | 7139 | 79 |
2153185 | 2153185 | 2022-01-26 | Douglas | Nevada | 32005 | 7078 | 78 |
2149933 | 2149933 | 2022-01-25 | Douglas | Nevada | 32005 | 6667 | 76 |
2146681 | 2146681 | 2022-01-24 | Douglas | Nevada | 32005 | 7110 | 76 |
2143426 | 2143426 | 2022-01-23 | Douglas | Nevada | 32005 | 6964 | 76 |
2140171 | 2140171 | 2022-01-22 | Douglas | Nevada | 32005 | 6964 | 76 |
2136915 | 2136915 | 2022-01-21 | Douglas | Nevada | 32005 | 6964 | 76 |
2133663 | 2133663 | 2022-01-20 | Douglas | Nevada | 32005 | 6807 | 76 |
2130410 | 2130410 | 2022-01-19 | Douglas | Nevada | 32005 | 6554 | 75 |
2127156 | 2127156 | 2022-01-18 | Douglas | Nevada | 32005 | 6258 | 75 |
2123904 | 2123904 | 2022-01-17 | Douglas | Nevada | 32005 | 6180 | 75 |
2120652 | 2120652 | 2022-01-16 | Douglas | Nevada | 32005 | 6180 | 75 |
2117400 | 2117400 | 2022-01-15 | Douglas | Nevada | 32005 | 6180 | 75 |
2114149 | 2114149 | 2022-01-14 | Douglas | Nevada | 32005 | 6180 | 75 |
2110897 | 2110897 | 2022-01-13 | Douglas | Nevada | 32005 | 6062 | 75 |
2107646 | 2107646 | 2022-01-12 | Douglas | Nevada | 32005 | 5960 | 76 |
2104395 | 2104395 | 2022-01-11 | Douglas | Nevada | 32005 | 5853 | 75 |
2101144 | 2101144 | 2022-01-10 | Douglas | Nevada | 32005 | 5666 | 75 |
2097893 | 2097893 | 2022-01-09 | Douglas | Nevada | 32005 | 5550 | 75 |
2094641 | 2094641 | 2022-01-08 | Douglas | Nevada | 32005 | 5550 | 75 |
2091389 | 2091389 | 2022-01-07 | Douglas | Nevada | 32005 | 5550 | 75 |
2088138 | 2088138 | 2022-01-06 | Douglas | Nevada | 32005 | 5503 | 75 |
2084886 | 2084886 | 2022-01-05 | Douglas | Nevada | 32005 | 5455 | 75 |
2081634 | 2081634 | 2022-01-04 | Douglas | Nevada | 32005 | 5388 | 75 |
2078382 | 2078382 | 2022-01-03 | Douglas | Nevada | 32005 | 5349 | 74 |
2075131 | 2075131 | 2022-01-02 | Douglas | Nevada | 32005 | 5322 | 74 |
2071880 | 2071880 | 2022-01-01 | Douglas | Nevada | 32005 | 5322 | 74 |
2068629 | 2068629 | 2021-12-31 | Douglas | Nevada | 32005 | 5322 | 74 |
2065378 | 2065378 | 2021-12-30 | Douglas | Nevada | 32005 | 5322 | 74 |
2062128 | 2062128 | 2021-12-29 | Douglas | Nevada | 32005 | 5301 | 74 |
2058879 | 2058879 | 2021-12-28 | Douglas | Nevada | 32005 | 5289 | 74 |
2055630 | 2055630 | 2021-12-27 | Douglas | Nevada | 32005 | 5256 | 74 |
2052380 | 2052380 | 2021-12-26 | Douglas | Nevada | 32005 | 5249 | 74 |
2049130 | 2049130 | 2021-12-25 | Douglas | Nevada | 32005 | 5249 | 74 |
2045880 | 2045880 | 2021-12-24 | Douglas | Nevada | 32005 | 5249 | 74 |
2042630 | 2042630 | 2021-12-23 | Douglas | Nevada | 32005 | 5249 | 74 |
2039381 | 2039381 | 2021-12-22 | Douglas | Nevada | 32005 | 5234 | 74 |
2036131 | 2036131 | 2021-12-21 | Douglas | Nevada | 32005 | 5219 | 74 |
2032881 | 2032881 | 2021-12-20 | Douglas | Nevada | 32005 | 5197 | 73 |
2029630 | 2029630 | 2021-12-19 | Douglas | Nevada | 32005 | 5188 | 73 |
2026379 | 2026379 | 2021-12-18 | Douglas | Nevada | 32005 | 5188 | 73 |
2023128 | 2023128 | 2021-12-17 | Douglas | Nevada | 32005 | 5188 | 73 |
2019877 | 2019877 | 2021-12-16 | Douglas | Nevada | 32005 | 5191 | 73 |
2016627 | 2016627 | 2021-12-15 | Douglas | Nevada | 32005 | 5188 | 73 |
2013376 | 2013376 | 2021-12-14 | Douglas | Nevada | 32005 | 5188 | 73 |
2010125 | 2010125 | 2021-12-13 | Douglas | Nevada | 32005 | 5166 | 72 |
2006874 | 2006874 | 2021-12-12 | Douglas | Nevada | 32005 | 5145 | 72 |
2003623 | 2003623 | 2021-12-11 | Douglas | Nevada | 32005 | 5145 | 72 |
2000373 | 2000373 | 2021-12-10 | Douglas | Nevada | 32005 | 5145 | 72 |
1997122 | 1997122 | 2021-12-09 | Douglas | Nevada | 32005 | 5145 | 72 |
1993871 | 1993871 | 2021-12-08 | Douglas | Nevada | 32005 | 5136 | 72 |
1990620 | 1990620 | 2021-12-07 | Douglas | Nevada | 32005 | 5110 | 72 |
1987370 | 1987370 | 2021-12-06 | Douglas | Nevada | 32005 | 5106 | 71 |
1984120 | 1984120 | 2021-12-05 | Douglas | Nevada | 32005 | 5103 | 71 |
1980870 | 1980870 | 2021-12-04 | Douglas | Nevada | 32005 | 5103 | 71 |
1977620 | 1977620 | 2021-12-03 | Douglas | Nevada | 32005 | 5103 | 71 |
1974370 | 1974370 | 2021-12-02 | Douglas | Nevada | 32005 | 5099 | 70 |
1971121 | 1971121 | 2021-12-01 | Douglas | Nevada | 32005 | 5092 | 69 |
1967871 | 1967871 | 2021-11-30 | Douglas | Nevada | 32005 | 5076 | 68 |
1964619 | 1964619 | 2021-11-29 | Douglas | Nevada | 32005 | 5065 | 68 |
1961368 | 1961368 | 2021-11-28 | Douglas | Nevada | 32005 | 5041 | 68 |
1958117 | 1958117 | 2021-11-27 | Douglas | Nevada | 32005 | 5041 | 68 |
1954866 | 1954866 | 2021-11-26 | Douglas | Nevada | 32005 | 5041 | 68 |
1951615 | 1951615 | 2021-11-25 | Douglas | Nevada | 32005 | 5041 | 68 |
1948364 | 1948364 | 2021-11-24 | Douglas | Nevada | 32005 | 5041 | 68 |
1945113 | 1945113 | 2021-11-23 | Douglas | Nevada | 32005 | 5046 | 67 |
1941862 | 1941862 | 2021-11-22 | Douglas | Nevada | 32005 | 5025 | 66 |
1938612 | 1938612 | 2021-11-21 | Douglas | Nevada | 32005 | 5014 | 66 |
1935362 | 1935362 | 2021-11-20 | Douglas | Nevada | 32005 | 5014 | 66 |
1932112 | 1932112 | 2021-11-19 | Douglas | Nevada | 32005 | 5014 | 66 |
1928861 | 1928861 | 2021-11-18 | Douglas | Nevada | 32005 | 5003 | 66 |
1925611 | 1925611 | 2021-11-17 | Douglas | Nevada | 32005 | 4991 | 66 |
1922362 | 1922362 | 2021-11-16 | Douglas | Nevada | 32005 | 4984 | 66 |
1919112 | 1919112 | 2021-11-15 | Douglas | Nevada | 32005 | 4960 | 65 |
1915862 | 1915862 | 2021-11-14 | Douglas | Nevada | 32005 | 4943 | 65 |
1912612 | 1912612 | 2021-11-13 | Douglas | Nevada | 32005 | 4943 | 65 |
1909362 | 1909362 | 2021-11-12 | Douglas | Nevada | 32005 | 4943 | 65 |
1906113 | 1906113 | 2021-11-11 | Douglas | Nevada | 32005 | 4926 | 65 |
1902864 | 1902864 | 2021-11-10 | Douglas | Nevada | 32005 | 4926 | 65 |
1899614 | 1899614 | 2021-11-09 | Douglas | Nevada | 32005 | 4917 | 65 |
1896364 | 1896364 | 2021-11-08 | Douglas | Nevada | 32005 | 4873 | 64 |
1893114 | 1893114 | 2021-11-07 | Douglas | Nevada | 32005 | 4847 | 57 |
1889864 | 1889864 | 2021-11-06 | Douglas | Nevada | 32005 | 4847 | 57 |
1886614 | 1886614 | 2021-11-05 | Douglas | Nevada | 32005 | 4847 | 57 |
1883365 | 1883365 | 2021-11-04 | Douglas | Nevada | 32005 | 4833 | 57 |
1880116 | 1880116 | 2021-11-03 | Douglas | Nevada | 32005 | 4762 | 57 |
1876867 | 1876867 | 2021-11-02 | Douglas | Nevada | 32005 | 4731 | 57 |
1873618 | 1873618 | 2021-11-01 | Douglas | Nevada | 32005 | 4701 | 57 |
1870369 | 1870369 | 2021-10-31 | Douglas | Nevada | 32005 | 4687 | 57 |
1867120 | 1867120 | 2021-10-30 | Douglas | Nevada | 32005 | 4687 | 57 |
1863871 | 1863871 | 2021-10-29 | Douglas | Nevada | 32005 | 4687 | 57 |
1860622 | 1860622 | 2021-10-28 | Douglas | Nevada | 32005 | 4687 | 57 |
1857373 | 1857373 | 2021-10-27 | Douglas | Nevada | 32005 | 4686 | 56 |
1854124 | 1854124 | 2021-10-26 | Douglas | Nevada | 32005 | 4667 | 56 |
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);