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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281010 | 281010 | 2020-06-28 | Santa Clara | California | 6085 | 4162 | 156 |
277863 | 277863 | 2020-06-27 | Santa Clara | California | 6085 | 3984 | 156 |
274715 | 274715 | 2020-06-26 | Santa Clara | California | 6085 | 3984 | 156 |
271575 | 271575 | 2020-06-25 | Santa Clara | California | 6085 | 3888 | 156 |
268440 | 268440 | 2020-06-24 | Santa Clara | California | 6085 | 3832 | 156 |
265310 | 265310 | 2020-06-23 | Santa Clara | California | 6085 | 3727 | 155 |
262182 | 262182 | 2020-06-22 | Santa Clara | California | 6085 | 3606 | 155 |
259055 | 259055 | 2020-06-21 | Santa Clara | California | 6085 | 3547 | 155 |
255928 | 255928 | 2020-06-20 | Santa Clara | California | 6085 | 3458 | 153 |
252809 | 252809 | 2020-06-19 | Santa Clara | California | 6085 | 3398 | 153 |
249694 | 249694 | 2020-06-18 | Santa Clara | California | 6085 | 3363 | 153 |
246582 | 246582 | 2020-06-17 | Santa Clara | California | 6085 | 3288 | 153 |
243469 | 243469 | 2020-06-16 | Santa Clara | California | 6085 | 3254 | 153 |
240358 | 240358 | 2020-06-15 | Santa Clara | California | 6085 | 3230 | 152 |
237250 | 237250 | 2020-06-14 | Santa Clara | California | 6085 | 3197 | 152 |
234143 | 234143 | 2020-06-13 | Santa Clara | California | 6085 | 3157 | 151 |
231037 | 231037 | 2020-06-12 | Santa Clara | California | 6085 | 3117 | 151 |
227934 | 227934 | 2020-06-11 | Santa Clara | California | 6085 | 3063 | 150 |
224832 | 224832 | 2020-06-10 | Santa Clara | California | 6085 | 3032 | 150 |
221737 | 221737 | 2020-06-09 | Santa Clara | California | 6085 | 3017 | 150 |
218642 | 218642 | 2020-06-08 | Santa Clara | California | 6085 | 2973 | 146 |
215551 | 215551 | 2020-06-07 | Santa Clara | California | 6085 | 2942 | 145 |
212464 | 212464 | 2020-06-06 | Santa Clara | California | 6085 | 2920 | 145 |
209379 | 209379 | 2020-06-05 | Santa Clara | California | 6085 | 2892 | 145 |
206298 | 206298 | 2020-06-04 | Santa Clara | California | 6085 | 2850 | 145 |
203218 | 203218 | 2020-06-03 | Santa Clara | California | 6085 | 2832 | 145 |
200142 | 200142 | 2020-06-02 | Santa Clara | California | 6085 | 2819 | 145 |
197069 | 197069 | 2020-06-01 | Santa Clara | California | 6085 | 2805 | 145 |
193999 | 193999 | 2020-05-31 | Santa Clara | California | 6085 | 2776 | 142 |
190932 | 190932 | 2020-05-30 | Santa Clara | California | 6085 | 2731 | 142 |
187867 | 187867 | 2020-05-29 | Santa Clara | California | 6085 | 2707 | 142 |
184811 | 184811 | 2020-05-28 | Santa Clara | California | 6085 | 2701 | 142 |
181757 | 181757 | 2020-05-27 | Santa Clara | California | 6085 | 2688 | 141 |
178713 | 178713 | 2020-05-26 | Santa Clara | California | 6085 | 2675 | 141 |
175669 | 175669 | 2020-05-25 | Santa Clara | California | 6085 | 2652 | 140 |
172625 | 172625 | 2020-05-24 | Santa Clara | California | 6085 | 2617 | 140 |
169584 | 169584 | 2020-05-23 | Santa Clara | California | 6085 | 2571 | 140 |
166547 | 166547 | 2020-05-22 | Santa Clara | California | 6085 | 2546 | 140 |
163515 | 163515 | 2020-05-21 | Santa Clara | California | 6085 | 2508 | 140 |
160487 | 160487 | 2020-05-20 | Santa Clara | California | 6085 | 2492 | 140 |
157461 | 157461 | 2020-05-19 | Santa Clara | California | 6085 | 2483 | 138 |
154445 | 154445 | 2020-05-18 | Santa Clara | California | 6085 | 2453 | 137 |
151433 | 151433 | 2020-05-17 | Santa Clara | California | 6085 | 2453 | 137 |
148424 | 148424 | 2020-05-16 | Santa Clara | California | 6085 | 2418 | 137 |
145420 | 145420 | 2020-05-15 | Santa Clara | California | 6085 | 2403 | 136 |
142421 | 142421 | 2020-05-14 | Santa Clara | California | 6085 | 2391 | 136 |
139425 | 139425 | 2020-05-13 | Santa Clara | California | 6085 | 2364 | 134 |
136434 | 136434 | 2020-05-12 | Santa Clara | California | 6085 | 2364 | 134 |
133444 | 133444 | 2020-05-11 | Santa Clara | California | 6085 | 2341 | 131 |
130454 | 130454 | 2020-05-10 | Santa Clara | California | 6085 | 2339 | 131 |
127464 | 127464 | 2020-05-09 | Santa Clara | California | 6085 | 2307 | 131 |
124479 | 124479 | 2020-05-08 | Santa Clara | California | 6085 | 2290 | 129 |
121499 | 121499 | 2020-05-07 | Santa Clara | California | 6085 | 2281 | 122 |
118532 | 118532 | 2020-05-06 | Santa Clara | California | 6085 | 2268 | 122 |
115573 | 115573 | 2020-05-05 | Santa Clara | California | 6085 | 2255 | 122 |
112690 | 112690 | 2020-05-04 | Santa Clara | California | 6085 | 2244 | 118 |
109815 | 109815 | 2020-05-03 | Santa Clara | California | 6085 | 2231 | 116 |
106946 | 106946 | 2020-05-02 | Santa Clara | California | 6085 | 2204 | 115 |
104081 | 104081 | 2020-05-01 | Santa Clara | California | 6085 | 2179 | 114 |
101226 | 101226 | 2020-04-30 | Santa Clara | California | 6085 | 2163 | 112 |
98376 | 98376 | 2020-04-29 | Santa Clara | California | 6085 | 2134 | 108 |
95531 | 95531 | 2020-04-28 | Santa Clara | California | 6085 | 2122 | 107 |
92699 | 92699 | 2020-04-27 | Santa Clara | California | 6085 | 2105 | 104 |
89881 | 89881 | 2020-04-26 | Santa Clara | California | 6085 | 2084 | 101 |
87064 | 87064 | 2020-04-25 | Santa Clara | California | 6085 | 2040 | 100 |
84256 | 84256 | 2020-04-24 | Santa Clara | California | 6085 | 2018 | 99 |
81456 | 81456 | 2020-04-23 | Santa Clara | California | 6085 | 1987 | 96 |
78662 | 78662 | 2020-04-22 | Santa Clara | California | 6085 | 1962 | 95 |
75878 | 75878 | 2020-04-21 | Santa Clara | California | 6085 | 1946 | 89 |
73102 | 73102 | 2020-04-20 | Santa Clara | California | 6085 | 1922 | 84 |
70333 | 70333 | 2020-04-19 | Santa Clara | California | 6085 | 1870 | 74 |
67571 | 67571 | 2020-04-18 | Santa Clara | California | 6085 | 1870 | 74 |
64823 | 64823 | 2020-04-17 | Santa Clara | California | 6085 | 1870 | 74 |
62090 | 62090 | 2020-04-16 | Santa Clara | California | 6085 | 1833 | 70 |
59371 | 59371 | 2020-04-15 | Santa Clara | California | 6085 | 1793 | 66 |
56663 | 56663 | 2020-04-14 | Santa Clara | California | 6085 | 1666 | 61 |
53971 | 53971 | 2020-04-13 | Santa Clara | California | 6085 | 1666 | 61 |
51292 | 51292 | 2020-04-12 | Santa Clara | California | 6085 | 1621 | 54 |
48630 | 48630 | 2020-04-11 | Santa Clara | California | 6085 | 1566 | 52 |
46000 | 46000 | 2020-04-10 | Santa Clara | California | 6085 | 1484 | 50 |
43400 | 43400 | 2020-04-09 | Santa Clara | California | 6085 | 1442 | 48 |
40828 | 40828 | 2020-04-08 | Santa Clara | California | 6085 | 1380 | 47 |
38284 | 38284 | 2020-04-07 | Santa Clara | California | 6085 | 1285 | 44 |
35795 | 35795 | 2020-04-06 | Santa Clara | California | 6085 | 1224 | 40 |
33350 | 33350 | 2020-04-05 | Santa Clara | California | 6085 | 1207 | 40 |
30944 | 30944 | 2020-04-04 | Santa Clara | California | 6085 | 1148 | 40 |
28586 | 28586 | 2020-04-03 | Santa Clara | California | 6085 | 1094 | 39 |
26287 | 26287 | 2020-04-02 | Santa Clara | California | 6085 | 1019 | 37 |
24058 | 24058 | 2020-04-01 | Santa Clara | California | 6085 | 956 | 33 |
21900 | 21900 | 2020-03-31 | Santa Clara | California | 6085 | 890 | 31 |
19825 | 19825 | 2020-03-30 | Santa Clara | California | 6085 | 848 | 29 |
17848 | 17848 | 2020-03-29 | Santa Clara | California | 6085 | 646 | 26 |
15959 | 15959 | 2020-03-28 | Santa Clara | California | 6085 | 591 | 26 |
14177 | 14177 | 2020-03-27 | Santa Clara | California | 6085 | 574 | 21 |
12511 | 12511 | 2020-03-26 | Santa Clara | California | 6085 | 542 | 20 |
10966 | 10966 | 2020-03-25 | Santa Clara | California | 6085 | 459 | 18 |
9594 | 9594 | 2020-03-24 | Santa Clara | California | 6085 | 375 | 17 |
8351 | 8351 | 2020-03-23 | Santa Clara | California | 6085 | 321 | 11 |
7208 | 7208 | 2020-03-22 | Santa Clara | California | 6085 | 303 | 11 |
6174 | 6174 | 2020-03-21 | Santa Clara | California | 6085 | 263 | 8 |
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);