ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
834 rows where fips = 6085 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 434 ✖
- 0 38
- 2100 11
- 2099 8
- 145 7
- 1902 7
- 140 6
- 156 6
- 1970 6
- 2143 6
- 2267 6
- 153 5
- 477 5
- 1898 5
- 1923 5
- 2091 5
- 2098 5
- 2117 5
- 2189 5
- 2201 5
- 2259 5
- 1 4
- 142 4
- 167 4
- 192 4
- 389 4
- 748 4
- 1774 4
- 1821 4
- 1845 4
- 1859 4
- 1874 4
- 1904 4
- 1935 4
- 1942 4
- 1968 4
- 2020 4
- 2086 4
- 2095 4
- 2097 4
- 2139 4
- 2184 4
- 2226 4
- 2251 4
- 2269 4
- 2278 4
- 2282 4
- 2288 4
- 2 3
- 40 3
- 74 3
- 122 3
- 131 3
- 137 3
- 150 3
- 155 3
- 178 3
- 185 3
- 210 3
- 225 3
- 261 3
- 358 3
- 374 3
- 407 3
- 431 3
- 445 3
- 464 3
- 504 3
- 527 3
- 584 3
- 653 3
- 1770 3
- 1778 3
- 1779 3
- 1790 3
- 1808 3
- 1823 3
- 1842 3
- 1863 3
- 1870 3
- 1891 3
- 1895 3
- 1918 3
- 1929 3
- 1938 3
- 1947 3
- 1950 3
- 1962 3
- 1967 3
- 1972 3
- 1975 3
- 1994 3
- 1996 3
- 2014 3
- 2044 3
- 2068 3
- 2069 3
- 2094 3
- 2154 3
- 2158 3
- 2167 3
- 2176 3
- 2188 3
- 2196 3
- 2209 3
- 2266 3
- 2275 3
- 2283 3
- 2286 3
- 2295 3
- 6 2
- 8 2
- 11 2
- 26 2
- 61 2
- 134 2
- 136 2
- 141 2
- 151 2
- 152 2
- 161 2
- 166 2
- 179 2
- 197 2
- 206 2
- 208 2
- 209 2
- 234 2
- 245 2
- 246 2
- 264 2
- 284 2
- 296 2
- 297 2
- 364 2
- 386 2
- 441 2
- 644 2
- 674 2
- 1182 2
- 1748 2
- 1775 2
- 1784 2
- 1836 2
- 1883 2
- 1896 2
- 1897 2
- 1899 2
- 1906 2
- 1908 2
- 1917 2
- 1926 2
- 1943 2
- 1945 2
- 1946 2
- 1951 2
- 1963 2
- 2003 2
- 2007 2
- 2018 2
- 2049 2
- 2071 2
- 2089 2
- 2092 2
- 2131 2
- 2156 2
- 2181 2
- 2186 2
- 2191 2
- 2194 2
- 2202 2
- 2207 2
- 2225 2
- 2258 2
- 4 1
- 5 1
- 17 1
- 18 1
- 20 1
- 21 1
- 29 1
- 31 1
- 33 1
- 37 1
- 39 1
- 44 1
- 47 1
- 48 1
- 50 1
- 52 1
- 54 1
- 66 1
- 70 1
- 84 1
- 89 1
- 95 1
- 96 1
- 99 1
- 100 1
- 101 1
- 104 1
- 107 1
- 108 1
- 112 1
- 114 1
- 115 1
- 116 1
- 118 1
- 129 1
- 138 1
- 146 1
- 157 1
- 159 1
- 160 1
- 162 1
- 165 1
- 168 1
- 171 1
- 174 1
- 177 1
- 181 1
- 182 1
- 184 1
- 186 1
- 188 1
- 191 1
- 193 1
- 204 1
- 205 1
- 214 1
- 217 1
- 218 1
- 223 1
- 241 1
- 249 1
- 251 1
- 254 1
- 255 1
- 258 1
- 277 1
- 281 1
- 288 1
- 294 1
- 298 1
- 300 1
- 301 1
- 305 1
- 307 1
- 312 1
- 313 1
- 315 1
- 319 1
- 323 1
- 326 1
- 331 1
- 334 1
- 345 1
- 346 1
- 348 1
- 354 1
- 355 1
- 363 1
- 368 1
- 379 1
- 383 1
- 393 1
- 403 1
- 405 1
- 410 1
- 413 1
- 422 1
- 425 1
- 434 1
- 437 1
- 446 1
- 448 1
- 454 1
- 460 1
- 465 1
- 468 1
- 471 1
- 483 1
- 487 1
- 496 1
- 512 1
- 513 1
- 516 1
- 520 1
- 530 1
- 554 1
- 562 1
- 567 1
- 608 1
- 616 1
- 633 1
- 710 1
- 772 1
- 800 1
- 816 1
- 844 1
- 884 1
- 920 1
- 945 1
- 987 1
- 1012 1
- 1029 1
- 1041 1
- 1061 1
- 1066 1
- 1077 1
- 1110 1
- 1130 1
- 1159 1
- 1235 1
- 1265 1
- 1279 1
- 1315 1
- 1345 1
- 1373 1
- 1396 1
- 1415 1
- 1419 1
- 1434 1
- 1474 1
- 1506 1
- 1524 1
- 1529 1
- 1541 1
- 1547 1
- 1577 1
- 1595 1
- 1625 1
- 1644 1
- 1662 1
- 1667 1
- 1669 1
- 1670 1
- 1683 1
- 1709 1
- 1726 1
- 1729 1
- 1730 1
- 1737 1
- 1766 1
- 1771 1
- 1773 1
- 1780 1
- 1782 1
- 1783 1
- 1794 1
- 1797 1
- 1798 1
- 1799 1
- 1800 1
- 1802 1
- 1807 1
- 1811 1
- 1817 1
- 1818 1
- 1828 1
- 1829 1
- 1831 1
- 1834 1
- 1837 1
- 1839 1
- 1844 1
- 1853 1
- 1854 1
- 1862 1
- 1873 1
- 1876 1
- 1877 1
- 1882 1
- 1887 1
- 1893 1
- 1900 1
- 1903 1
- 1909 1
- 1913 1
- 1914 1
- 1915 1
- 1916 1
- 1919 1
- 1920 1
- 1921 1
- 1930 1
- 1934 1
- 1941 1
- 1952 1
- 1955 1
- 1964 1
- 1965 1
- 1973 1
- 1977 1
- 1985 1
- 1986 1
- 1987 1
- 1992 1
- 2000 1
- 2006 1
- 2009 1
- 2016 1
- 2026 1
- 2036 1
- 2042 1
- 2048 1
- 2052 1
- 2061 1
- 2070 1
- 2074 1
- 2076 1
- 2085 1
- 2087 1
- 2096 1
- 2115 1
- 2118 1
- 2119 1
- 2128 1
- 2136 1
- 2144 1
- 2159 1
- 2166 1
- 2178 1
- 2179 1
- 2180 1
- 2185 1
- 2198 1
- 2203 1
- 2224 1
- 2244 1
- 2246 1
- 2250 1
- 2260 1
- 2268 1
- 2298 1
state 1
- California 834
fips 1
- 6085 · 834 ✖
county 1
- Santa Clara 834
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
37 | 37 | 2020-01-31 | Santa Clara | California | 6085 | 1 | 0 |
43 | 43 | 2020-02-01 | Santa Clara | California | 6085 | 1 | 0 |
51 | 51 | 2020-02-02 | Santa Clara | California | 6085 | 2 | 0 |
59 | 59 | 2020-02-03 | Santa Clara | California | 6085 | 2 | 0 |
67 | 67 | 2020-02-04 | Santa Clara | California | 6085 | 2 | 0 |
75 | 75 | 2020-02-05 | Santa Clara | California | 6085 | 2 | 0 |
84 | 84 | 2020-02-06 | Santa Clara | California | 6085 | 2 | 0 |
93 | 93 | 2020-02-07 | Santa Clara | California | 6085 | 2 | 0 |
102 | 102 | 2020-02-08 | Santa Clara | California | 6085 | 2 | 0 |
111 | 111 | 2020-02-09 | Santa Clara | California | 6085 | 2 | 0 |
121 | 121 | 2020-02-10 | Santa Clara | California | 6085 | 2 | 0 |
131 | 131 | 2020-02-11 | Santa Clara | California | 6085 | 2 | 0 |
141 | 141 | 2020-02-12 | Santa Clara | California | 6085 | 2 | 0 |
152 | 152 | 2020-02-13 | Santa Clara | California | 6085 | 2 | 0 |
163 | 163 | 2020-02-14 | Santa Clara | California | 6085 | 2 | 0 |
174 | 174 | 2020-02-15 | Santa Clara | California | 6085 | 2 | 0 |
185 | 185 | 2020-02-16 | Santa Clara | California | 6085 | 2 | 0 |
196 | 196 | 2020-02-17 | Santa Clara | California | 6085 | 2 | 0 |
208 | 208 | 2020-02-18 | Santa Clara | California | 6085 | 2 | 0 |
220 | 220 | 2020-02-19 | Santa Clara | California | 6085 | 2 | 0 |
233 | 233 | 2020-02-20 | Santa Clara | California | 6085 | 2 | 0 |
247 | 247 | 2020-02-21 | Santa Clara | California | 6085 | 2 | 0 |
261 | 261 | 2020-02-22 | Santa Clara | California | 6085 | 2 | 0 |
275 | 275 | 2020-02-23 | Santa Clara | California | 6085 | 2 | 0 |
289 | 289 | 2020-02-24 | Santa Clara | California | 6085 | 2 | 0 |
305 | 305 | 2020-02-25 | Santa Clara | California | 6085 | 2 | 0 |
324 | 324 | 2020-02-26 | Santa Clara | California | 6085 | 2 | 0 |
344 | 344 | 2020-02-27 | Santa Clara | California | 6085 | 2 | 0 |
364 | 364 | 2020-02-28 | Santa Clara | California | 6085 | 3 | 0 |
386 | 386 | 2020-02-29 | Santa Clara | California | 6085 | 4 | 0 |
409 | 409 | 2020-03-01 | Santa Clara | California | 6085 | 7 | 0 |
438 | 438 | 2020-03-02 | Santa Clara | California | 6085 | 9 | 0 |
472 | 472 | 2020-03-03 | Santa Clara | California | 6085 | 11 | 0 |
507 | 507 | 2020-03-04 | Santa Clara | California | 6085 | 14 | 0 |
546 | 546 | 2020-03-05 | Santa Clara | California | 6085 | 20 | 0 |
596 | 596 | 2020-03-06 | Santa Clara | California | 6085 | 24 | 0 |
673 | 673 | 2020-03-07 | Santa Clara | California | 6085 | 32 | 0 |
768 | 768 | 2020-03-08 | Santa Clara | California | 6085 | 37 | 0 |
882 | 882 | 2020-03-09 | Santa Clara | California | 6085 | 43 | 1 |
1015 | 1015 | 2020-03-10 | Santa Clara | California | 6085 | 45 | 1 |
1181 | 1181 | 2020-03-11 | Santa Clara | California | 6085 | 48 | 1 |
1387 | 1387 | 2020-03-12 | Santa Clara | California | 6085 | 66 | 1 |
1648 | 1648 | 2020-03-13 | Santa Clara | California | 6085 | 79 | 2 |
1966 | 1966 | 2020-03-14 | Santa Clara | California | 6085 | 91 | 2 |
2347 | 2347 | 2020-03-15 | Santa Clara | California | 6085 | 114 | 2 |
2782 | 2782 | 2020-03-16 | Santa Clara | California | 6085 | 138 | 4 |
3264 | 3264 | 2020-03-17 | Santa Clara | California | 6085 | 155 | 5 |
3818 | 3818 | 2020-03-18 | Santa Clara | California | 6085 | 175 | 6 |
4478 | 4478 | 2020-03-19 | Santa Clara | California | 6085 | 189 | 6 |
5253 | 5253 | 2020-03-20 | Santa Clara | California | 6085 | 196 | 8 |
6174 | 6174 | 2020-03-21 | Santa Clara | California | 6085 | 263 | 8 |
7208 | 7208 | 2020-03-22 | Santa Clara | California | 6085 | 303 | 11 |
8351 | 8351 | 2020-03-23 | Santa Clara | California | 6085 | 321 | 11 |
9594 | 9594 | 2020-03-24 | Santa Clara | California | 6085 | 375 | 17 |
10966 | 10966 | 2020-03-25 | Santa Clara | California | 6085 | 459 | 18 |
12511 | 12511 | 2020-03-26 | Santa Clara | California | 6085 | 542 | 20 |
14177 | 14177 | 2020-03-27 | Santa Clara | California | 6085 | 574 | 21 |
15959 | 15959 | 2020-03-28 | Santa Clara | California | 6085 | 591 | 26 |
17848 | 17848 | 2020-03-29 | Santa Clara | California | 6085 | 646 | 26 |
19825 | 19825 | 2020-03-30 | Santa Clara | California | 6085 | 848 | 29 |
21900 | 21900 | 2020-03-31 | Santa Clara | California | 6085 | 890 | 31 |
24058 | 24058 | 2020-04-01 | Santa Clara | California | 6085 | 956 | 33 |
26287 | 26287 | 2020-04-02 | Santa Clara | California | 6085 | 1019 | 37 |
28586 | 28586 | 2020-04-03 | Santa Clara | California | 6085 | 1094 | 39 |
30944 | 30944 | 2020-04-04 | Santa Clara | California | 6085 | 1148 | 40 |
33350 | 33350 | 2020-04-05 | Santa Clara | California | 6085 | 1207 | 40 |
35795 | 35795 | 2020-04-06 | Santa Clara | California | 6085 | 1224 | 40 |
38284 | 38284 | 2020-04-07 | Santa Clara | California | 6085 | 1285 | 44 |
40828 | 40828 | 2020-04-08 | Santa Clara | California | 6085 | 1380 | 47 |
43400 | 43400 | 2020-04-09 | Santa Clara | California | 6085 | 1442 | 48 |
46000 | 46000 | 2020-04-10 | Santa Clara | California | 6085 | 1484 | 50 |
48630 | 48630 | 2020-04-11 | Santa Clara | California | 6085 | 1566 | 52 |
51292 | 51292 | 2020-04-12 | Santa Clara | California | 6085 | 1621 | 54 |
53971 | 53971 | 2020-04-13 | Santa Clara | California | 6085 | 1666 | 61 |
56663 | 56663 | 2020-04-14 | Santa Clara | California | 6085 | 1666 | 61 |
59371 | 59371 | 2020-04-15 | Santa Clara | California | 6085 | 1793 | 66 |
62090 | 62090 | 2020-04-16 | Santa Clara | California | 6085 | 1833 | 70 |
64823 | 64823 | 2020-04-17 | Santa Clara | California | 6085 | 1870 | 74 |
67571 | 67571 | 2020-04-18 | Santa Clara | California | 6085 | 1870 | 74 |
70333 | 70333 | 2020-04-19 | Santa Clara | California | 6085 | 1870 | 74 |
73102 | 73102 | 2020-04-20 | Santa Clara | California | 6085 | 1922 | 84 |
75878 | 75878 | 2020-04-21 | Santa Clara | California | 6085 | 1946 | 89 |
78662 | 78662 | 2020-04-22 | Santa Clara | California | 6085 | 1962 | 95 |
81456 | 81456 | 2020-04-23 | Santa Clara | California | 6085 | 1987 | 96 |
84256 | 84256 | 2020-04-24 | Santa Clara | California | 6085 | 2018 | 99 |
87064 | 87064 | 2020-04-25 | Santa Clara | California | 6085 | 2040 | 100 |
89881 | 89881 | 2020-04-26 | Santa Clara | California | 6085 | 2084 | 101 |
92699 | 92699 | 2020-04-27 | Santa Clara | California | 6085 | 2105 | 104 |
95531 | 95531 | 2020-04-28 | Santa Clara | California | 6085 | 2122 | 107 |
98376 | 98376 | 2020-04-29 | Santa Clara | California | 6085 | 2134 | 108 |
101226 | 101226 | 2020-04-30 | Santa Clara | California | 6085 | 2163 | 112 |
104081 | 104081 | 2020-05-01 | Santa Clara | California | 6085 | 2179 | 114 |
106946 | 106946 | 2020-05-02 | Santa Clara | California | 6085 | 2204 | 115 |
109815 | 109815 | 2020-05-03 | Santa Clara | California | 6085 | 2231 | 116 |
112690 | 112690 | 2020-05-04 | Santa Clara | California | 6085 | 2244 | 118 |
115573 | 115573 | 2020-05-05 | Santa Clara | California | 6085 | 2255 | 122 |
118532 | 118532 | 2020-05-06 | Santa Clara | California | 6085 | 2268 | 122 |
121499 | 121499 | 2020-05-07 | Santa Clara | California | 6085 | 2281 | 122 |
124479 | 124479 | 2020-05-08 | Santa Clara | California | 6085 | 2290 | 129 |
127464 | 127464 | 2020-05-09 | Santa Clara | California | 6085 | 2307 | 131 |
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);